20061206 Financial and activity templates Appendix 5.xls by alllona

VIEWS: 10 PAGES: 1

									Summary financial forecast
The figures you enter in this sheet will automatically populate the 2007/08 Operating Plan exhibit worksheet
Please ensure all costs are input as negative numbers


£'000                                                                               Plan            Forecast*           Forecast           Forecast           Forecast
                                                                                   2006/07           2006/07            2007/08            2008/09            2009/10
Income
Recurrent revenue allocation                                                           415458            412520             445020
Non-recurrent revenue allocation                                                       -38185            -40269             -44117
Other income (excluding income from provider activities)                                 1569             10856               1626
Total income                                                                           378842            383107             402529
Expenses
Commissioning activities:
Primary care - GPs, prison healthcare, dentistry, and optometry:
  GP                                                                                   -36110             -35887             -35429
  Prescribing                                                                          -35392             -34645             -35903
  Other                                                                                -14105             -12815             -14395
Community and intermediate services                                                     -5384              -5199              -5816
                                                                                       -64489             -64885             -66957
Mental health commissioning, pooled arrangements or jointly funded commissioning
Secondary care
  Provided under PbR
    Inpatient elective                                                                 -13593             -11409             -11819
    Day care elective                                                                  -11248             -13457             -13351
    Inpatient non-elective                                                             -41680             -35989             -36233
    Outpatient                                                                          -8548              -7503              -7672
  Provided at local prices                                                             -59195             -66115             -70330
  Provided by third sector/not-for-profits
  Provided by independent sector
  A&E                                                                                   -7875              -7875              -7613
  Other                                                                                 -4224              -4744              -4658
Ambulance services                                                                      -5961              -5961              -6110
Tertiary and specialist commissioning                                                   -7024              -6757              -6926
Total cost of commissioned services                                                   -314828            -313241            -323212
Provider Activities:
Pay expenditure                                                                        -19150             -18379             -21673
Non-pay expenditure                                                                     -2607              -2922              -2332
Less - provider income                                                                   1961               2136               2010
Net provider costs                                                                     -19796             -19165             -21995
Other costs
Other pay expenditure                                                                   -9349              -9893             -11232
Other non-pay expenditure                                                              -32980             -46683             -43936
Depreciation and amortisation                                                           -1679              -1679              -2154
Exceptional items
Total cost                                                                            -378632            -390661            -402529

PCT surplus/deficit in year                                                                  210           -7554                   0



PCT normalised position (excluding exceptional items)                                    210              -7554                    0


* 9 month actuals plus 3 month forecasts




                    Summary financial forecastG:\Modernisation\Communications\CORPORATE PUBLICATIONS\opearting plan 2007\20061206 Financial and activity templates Appendix 515/05/200709:29

								
To top