Estimating NHS and social care spend: a tool for commissioners
An Excel-based tool and guide to help NHS commissioners approximate how their local care economy spends its money by age group, patient group and care settings, and how this may evolve over time.

Context:

Increasingly, focus is turning towards integrated care and how we can tailor the care we
provide to our population. To do so efficiently and effectively, we need an in-depth
understanding of patients’ needs.

The best examples of this in-depth understanding of patient needs rely on robust
patient-level linked datasets. However, getting to this level can take several months.
This is why we have the ‘Care Spend Estimating Tool’, to help commissioners estimate
indicative population segmentation and forecast commissioner spends associated with
each segment across different health and social care settings.

What is the ‘Care Spend Estimating Tool’ who is it for, and what should it be used
for?:

The ‘Care Spend Estimating Tool’ is a simple Excel tool designed to approximate how
the local care economy spends its money by age group, patient group and care
settings, and how this may evolve over time. It is a new tool which may be revised from
time to time as assumptions are tested and data are verified.
Access the tool here.