Monitor has made available an Excel-based estimating tool to help NHS commissioners determine how effectively their local care economies spend NHS and social care funding. The description supplied with this tool suggests that, simply by submitting some basic variables, commissioners can create a brief indicative patient segmentation for their locality, with analyses by age group, patient group and care settings (and then form judgements about how all of this might change over time).
Estimating NHS and social care spend: a tool for commissioners. London: Monitor, September 8th 2014.
Click here to download this Care Spend Estimating Tool (in Microsoft Excel spreadsheet format).
A user guide is available:
Care spend estimating tool: user guide. London: Monitor, September 2014.