Workforce funding calculator

Spreadsheet to help PCNs explore different workforce funding options

We’ve developed a funding model in which we’ve pre-populated for each PCN their population and member practices.  You can use the spreadsheet to explore different options by inputting your data into the green cells (you don’t need to do anything to the other cells).

The main caveat to the model is that the “expected funds” are the minimum funds that each PCN can expect to receive, based on the information issued so far.  This figure could increase or decrease due to changes in population or further guidance issued, but for now it gives an estimated minimum figure for future years. Similarly, the “expected costs” could be affected by Agenda for Change uplifts or changes, and costs of living or minimum wages. The figure is an estimate of anticipated costs against anticipated funds to give each PCN a rough idea of what future years could look like, to inform and aid the establishment of PCNs.

Download the calculator