The brief here was to create a tool that would help a person applying for an NHS Personal Health Budget to work out how much money they would need annually to employ their personal assistants (care staff) and any additional agency workers they might need to fill in. Having completed the inputs, the resulting two reports calculated the cost of wages, tax, national insurance, training, holidays and sick pay. In addition, contingency provisions were calculated for PA turnover (such as recruitment, initial training and redundancy).
The first report shows the financial picture in summary and the second in detail. These were formatted to optimise them for PDF export.
PHB Inputs Sheet
PHB Summary report sheet, with +/- expansion groups on left
(click image to expand)
PHB Detail report sheet
Links to these as PDFs:
PHB Summary.pdf PHB Detail.pdf
If you would like to discuss a potential project, XY provides a free 30 minute telephone consultation.
If you are interested, you can request one here.
