XY Spreadsheet Solutions

Call Now:
0771 247 6588

Spinal Injuries Association - Personal Health Budgets

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.