Transcript Slide 1
9.0
Report Status: Open
Board of Directors Meeting – 25th July 2012
Report Title: Finance Report, June 2012
Covering the month ending 30th June 2012
Report from: Finance Director
Report Purpose: Review of monthly financial position
1.Background
This is a monthly finance report
2.
Key Messages
The financial position at the end of June was a deficit against plan of £473,000 a
worsening of £173,000 from the position in May
3. Recommendation/Next Steps
That the Board of Directors note the information provided in the report
Page 1
Trustwide Finance Overview as at 30th June 2012
Income & Expenditure (£'000)
Balance Sheet
Key Financial Drivers
Cumulative Capital Spend 2012/13
In Month Variance to Plan
12000
YTD Variance to Plan
(173)
Variance to plan
YTD £'000
Total Income:
501
Commissioner Income
648
Other Income
(147)
10000
(473)
8000
Cumulative Financial Position (Income & Expenditure)
May-12
568
579
(11)
6000
Plan ( £'0 0 0)
600
500
400
300
200
100
0
-100
-200
-300
4000
£'000's
Plan (£'000)
Actual
(£'000)
0
Cash in Hand
Planned Cash
Cost Improvement Programme 2012/13
High Risk,
£2,865
Actual ( £ '00 0)
2000
Cash (£'000)
6,208
5,836
Monitor Metrics
Metric
Underlying Performance - EBITDA Margin
Achievement of Plan - EBITDA % of Plan Achieved
Financial Efficiency - Return on Assets
Financial Efficiency - I&E Surplus Margin
Liquidity Rating
Overall Risk Rating
Plan
Actual
3
4
4
3
4
4
2
3
3
2
4
3
Weighting
25%
10%
20%
20%
25%
100%
Actual Pay Expenditure & WTE per Month
Total Expenditure
Pay:
Nursing
Medical Staff
Other Pay
Drugs
Clinical Supplies
Other Non-Pay
(974)
115
(159)
(164)
(21)
(187)
(557)
(868)
31
(162)
(13)
(33)
(188)
(502)
Total
(473)
(300)
Variance to plan by Directorate
Integrated Care
(208)
Elective Care
(423)
Acute Care & Cancer Services
(404)
Corporate Services
(270)
(165)
(429)
(221)
(191)
Comments:
Directorate Overspends were due to:
Integrated Care: The main driver for the overspend is due to £126k of
high risk CIP and £16 pressure on Medical Staffing.
Trustwide Pay Expenditure and WTE
Medium Risk,
£1,267
Cumulative CIP Target to Date (£'000)
1,885
Cumulative CIP Achieved to Date (£'000)
1,318
Over-achievement/Shortfall (£'000)
(568)
Comments:
At the end of June the Trust had a deficit against plan of £473k a
deterioration of £173 in June. The in month position was due to an over
achievement in Commissioner Income (£69k) being offset by operational
overspends (£241k). A significant proportion of the operational overspend
relates to high risk CIPs across Directorates. In response to this an Efficiency
Group has been set up, chaired by the Finance Director, to ensure delivery
of significant CIP schemes across the Trust.
10,000
9,500
9,000
8,500
8,000
7,500
7,000
6,500
6,000
5,500
5,000
2,800.00
Elective Care: Medical Staffing - Reduced pressures across Medical
Staffing budget so that overspend was £17k in month compared to £64k in
the previous month. Ward budgets continue to be within budget.
Activity related pressures account for just over 50% of the operational
overspend
2,700.00
2,600.00
2,500.00
WTE
£000s
CIP Actioned &
Low Risk,
£4,542
2,400.00
2,300.00
Actual
2,200.00
WTE
2,100.00
2,000.00
Comments:
Actual pay spend in June was £172k lower than in May spend due mainly to reduced spend
on medical staff and nursing
Acute Care & Cancer Services: High risk CIP phased into the position £45k,
pressures in the Emergency Department £47k and overspends on
wheelchairs and equipment £56k
Corporate: Pressures due to overspends on Estates non-pay (£42k), Car
Parking income (£17k) and high risk CIP phased into the position (£22k).
Main Risk Areas:
The key risk to the Trust is ensuring robust plans are in place to deliver
the outstanding 2012/13 CIP targets, in particular generating new
schemes across the Trust. Continued staffing and associated cost
pressures in the Emergency Department is a concern going forward
Page 2
Key Finance Overview
June Financial Position
• The in month financial position was a negative variance against plan of £172,000. This represents an over recovery of Commissioner
Income offset by an overspend on operating budgets particularly in non-pay budgets.
• Whilst the annual equivalent of £7.2m of CIP plans are delivering, the balance of £2.8m is not yet being delivered, contributing to the
overspend at the end of Month 3.
• Commissioner Income is over recovered in June by £69k. The June position reflects performance against the expected value of activity
with NYYPCT and Leeds as per the Trust’s annual planning process. Following the Quarter one reconciliation process activity funding will
be transferred to Directorates.
• Directorate budgets has overspent in month by £241,000:
•Pay overspent by £64,000, the majority of which related to locum cover for medical staff particularly in Emergency Department
(£46,000)
•Non-pay and Directorate Income overspent by £176,000. The majority of the overspend on non-pay across the Trust relates to high
risk or unactioned CIP schemes (£102,000). In addition in June there were significant overspends in Estates (£42,000) on energy
and repair and maintenance and an undertrade on car parking income (£17,000)
• Whilst it is still early in the financial year, a straight line forecast of this position would result in an overspend in excess of £1.8m at year
end. Given the significant cash commitment to the major capital schemes within the capital programme, all other capital schemes are being
reviewed to manage within the resource available. All Directorates and Departments have been tasked with bringing expenditure back into
line with budgets, in particular to focus on delivery of CIP targets alongside increasing activity levels.
• An efficiency group has been set up chaired by the Finance Director with a remit to develop and deliver key cross Trust efficiency projects.
The group has identified key areas to review including Medical Staff Locum expenditure, Procurement initiatives, absence management
costs, outpatient pharmacy and energy efficiency. Action plans are being developed for implementation.
• In addition work is on-going to deliver further activity from Leeds, with an additional Orthopaedic Clinic being planned in Wetherby. This
should deliver around £250,000 of extra income in the second half of the year. Detailed plans are being prepared to deliver this.
•
The cash balance at the end of June was £6.208m. The aged debt report (page 12) shows £2.187m of debt over 61 days old, almost all
of which is due from North Yorkshire and York PCT. Regular meetings are being held with NYYPCT to reduce this level of debtors and
resolve any outstanding issues relating to 2011/12. It is anticipated that payment will be received for a significant proportion of this debt by
the end of July, in particular over £500,000 of outstanding debt related to the GP OOH costs service incurred in 2011/12.
• The financial risk rating for Quarter 1 is a 3 and the returns will be submitted to Monitor at the end of July.
Page 3
Staffing Expenditure Analysis
Staffing Group
Jun-12
Budget
Medical Staff:
- Contracted Pay
- Contracted GP Pay
- Waiting List Initiative
- Agency
- Locum GP Pay
- Locum
Total Medical Staff
Nursing:
- Contracted Pay
- Overtime
- Bank
- Agency
- Nursing (prev capitalised)
Total Nursing
Other Clinical Staff:
- Contracted Pay
- Overtime
- Bank
- Agency
Total Other Clinical Staff
Non-Clinical Staff:
- Contracted Pay
- Overtime
- Bank
- Agency
- Locum
Total Non-Clinical Staff
Vacancy Factor/Reserves
GP Out of Hours Reserve
TOTAL
May-12
Actual
Variance
Budget
YEAR TO DATE
Actual
Change in Actual
April less May
Budget
Actual
Variance
WTE
£'000
Actual
WTE
£'000
WTE
£'000
WTE
£'000
Actual
WTE
£'000
WTE
£'000
WTE
£'000
Average
WTE
£'000
Average
WTE
£'000
289.06
27.43
2,147
295
99
272.08
18.02
1,992
236
99
16.98
9.41
155
59
0
289.06
27.43
2,091
295
181
274.25
19.25
2,087
244
113
2.17
1.23
0.00
95
7
15
289.06
27.43
6,269
885
461
273.17
18.64
5,968
724
461
15.89
8.79
0.00
301
161
0
0.00
0.00
0.00
(2.63)
23.76
(180)
19
(50)
3
1.00
317.49
10
273
39
2,889
3.49
296.99
183
195
110
2,932
0.00
0.00
(0.14)
3.26
(15)
(16)
7
92
0.00
0.00
1.00
317.49
40
622
124
8,400
6.79
3.63
293.73
199
211
103
2,840
0.00
1.00
317.49
19
230
54
2,842
3.56
302.16
532
580
294
8,559
(6.79)
0.00
(2.56)
15.33
(493)
42
(170)
(159)
1095.89
3,298
1037.75
3,138
58.14
0.00
160
0
1094.41
3,261
1042.26
3,171
4.51
0.00
32
0
1095.89
9,779
1040.01
9,390
55.88
0.00
389
0
1.07
2.64
6
12
33.97
0.45
84
10
7
16
39.56
2.92
96
21
1072.17
3,232
1098.12
3,284
1084.74
3,287
5.59
2.47
0.00
12.57
12
11
0
55
1.07
7.92
0.00
1104.88
29
38
0
9,847
36.77
1.69
3,316
(78)
2
0
84
1.07
2.64
1099.60
(32.90)
2.19
0.00
27.43
1,078.47
292
49
0
9,731
(35.70)
6.23
0.00
26.41
(263)
(11)
0
115
587.67
1,773
556.27
1,703
31.40
0.00
70
0
588.04
1,778
553.67
1,694
(2.60)
0.00
(9)
0
587.67
5,328
554.97
5,101
32.70
0.00
227
0
0.00
1.11
0.00
557.38
2
25
1,731
(1.11)
0.00
30.29
1
(0)
71
0.00
587.67
4
25
1,802
588.04
4
30
1,811
1.03
0.00
554.70
2
27
1,724
(0.08)
0.00
(2.68)
(0)
2
-7
0.00
0.00
587.67
11
55
5,394
1.07
1.30
557.34
7
65
5,173
(1.07)
(1.30)
30.33
4
(10)
221
829.80
1,842
775.96
1,781
53.84
0.00
61
0
829.00
1,824
784.74
1,814
8.78
0.00
33
0
829.80
5,521
781.75
5,362
48.05
0.00
159
0
8
30
21.26
0.00
43
56
(21.26)
0.00
(36)
(27)
7
30
17.36
0.00
37
64
22
89
19.31
17.58
127
179
1,879
797.22
1,881
32.58
802.10
1,916
(6)
8
0
35
0.00
0.00
829.80
(3.90)
0.00
0.00
4.88
829.80
5,632
818.64
5,667
(19.31)
(17.58)
0.00
11.16
(105)
(90)
0
(35)
-2.78
(230)
-14
0
0.00
0.00
(3)
0
(35)
0
0.00
0.00
(350)
0
2831.78
9,609
9,845
18.03
172
29,096
83.23
(208)
-11
0
2720.50
9,673
114.06
(2)
829.00
1,861
(220)
0
-1.28
(95)
(64)
2831.37
9,750
2738.53
(384)
0
2839.84
28,888
2756.61
Notes
• “Vacancy factor” is a negative budget line which reduces the overall staffing budget to take into account the expected slippage between staff leaving and being replaced
• The overspend on GP’s relates to the GP OOH service which is being funded by NYYPCT in the first 2 years of the Community Services contract
Page 4
Overview Income & Expenditure Position
Summary Income & Expenditure 2012/13
For the month ending June 30 2012
2011/12
Actual
£000
153,262
0
1,525
652
12,870
497
327
169,133
Current Ledger Position
Budget
Actual
Annual
Proportion
To Date
Budget
To Date
£000
£000
£000
2012/13
Plan
£000
INCOME
NHS Clinical Income (Commissioners)
153,754
NHS Clinical Income
0
Over-Performance to CBU's
Non NHS Clinical Income
1,580
Private Patient& Amenity Bed Income
544
Other Non-Protected Clinical Income (RTA)
Other Income
10,223
Non Clinical Income
SHA Sustainability Funding
0
Hosted Services
166,101 TOTAL INCOME
(115,686)
(110,730)
(8,514)
(16,147)
(19,931)
(2,988)
(14,755)
(15,684)
EXPENSES
Pay
Pay Expenditure
Non Pay
Drugs
Clinical Services & Supplies
Other Costs
(497)
(16)
0
(77)
0
0
(14)
(327)
(161,211)
7,922
0
(4,014)
66
(2,379)
1,596
(707)
889
Pay
Pay savings targets
Other Reserves
High Cost Drugs
Non Pay savings targets
Other Finance Costs
Hosted Services
Change in
Variance
£000
£'000
154,871
37,790
38,438
648
0
69
0
1,811
544
436
136
359
175
(77)
39
(15)
(3)
10,990
3,018
153
168,369
61
41,441
2,909
0
61
41,942
(109)
0
0
501
(118)
0
0
(67)
(113,403)
(28,888)
(29,096)
(208)
(64)
(4,575)
(14,857)
(14,111)
(2,247)
(3,895)
(4,054)
(2,268)
(4,082)
(4,776)
(21)
(187)
(721)
12
1
(114)
Transforming Community Services Costs
(1,062)
0
(12,213)
(6,401)
6,209
(18)
0
Cumulative
Variance
0
0
0
Reserves :
(534)
0
(7,311)
(4,947)
0
(18)
(153)
0
0
(141)
0
0
(4)
(61)
0
0
0
0
0
(14)
(61)
0
0
141
0
0
(10)
0
0
0
14
0
0
1
(0)
(157,641) TOTAL COSTS
(159,908)
(39,291)
(40,297)
(1,006)
(149)
8,460
2,150
1,645
(505)
(216)
0
(4,186)
34
(2,456)
0
(1,046)
8
(614)
0
(1,005)
16
(630)
0
42
7
(16)
0
42
8
(5)
1,852
498
25
(473)
(173)
0
0
(473)
(173)
8,459 EBITDA
0
(4,186)
34
(2,456)
Profit / (Loss) on disposal of assets
Depreciation
Interest Receivable
Dividend Payable
1,851 Net Surplus/(Deficit) before restructure costs
(500)
Restructure Costs
(500)
1,351 Net Surplus/(Deficit)
1,352
498
25
Negative sign under variance indicates an UNDER-recovery of forecast income, or an OVER-spending against budget
NB - There was an in-month adjustment between non-clinical income and non-pay expenditure in Community Equipment Stores that contributed to
£50,000 of the in-month adverse variance on non-clinical income with the oppoiste impact on non-pay (other costs)
Page 5
Acute & Cancer Care Directorate 30th June 2012
Directorate Income & Expenditure (£'000)
In Month Variance to Plan
Key Financial Drivers
YTD Variance to Plan
(183)
(404)
Monthly Financial Position
Variance to plan
YTD £'000
(18)
7
(25)
Previous Month
YTD (£'000)
41
(3)
44
Total Expenditure
(386)
(263)
Pay:
44
39
(127)
9
33
(7)
(6)
(9)
Clinical Supplies
Other Non Pay
(147)
(189)
(106)
(182)
Net Position
(404)
(221)
Total Income:
Private Patient Income
Other Income
3700
3650
Value £'000
3600
3550
3500
3450
Nursing
Medical Staff
Other Pay
3400
Drugs
3350
3300
Plan (£'000)
Actual (£'000)
Performance Against CIP 2012/13
Med risk CIP
£458,000
ACTIONS AGREED
Actioned &
Low risk CIP,
£746,600
High risk CIP,
£1,136,800
Cumulative CIP Target to Date (£'000)
585
Cumulative CIP Achieved to Date (£'000)
359
Over-achievement/(Shortfall) (£'000)
(226)
Comments:
The Acute & Cancer Care Directorate reported an in-month over spend
against total budget of £183k.
** £45k relates to level of CIP shortfall in Month 03.
** The Emergency Department reported a £46k in month over spend against
pay budgets.
** There was a non-pay overspend across community equipment and
wheelchairs of £56k. This is due mainly to overspends in the York
equipment store
12.13 CIP TARGET
The directorate must continue to address the 40% of current CIP target
that is high risk. This will be monitored and reported at the Directorate
Board
OUT OF HOURS SERVICES
Work is ongoing in this financial year to address the £1.0m over spend
that this service has. An action plan to achieve a significant amount of
savings has been drafted and tabled internally within the Trust.
Communication with key stakeholders is now the main priority in order
that we can progress with timetabled consultation.
Community Equipment Stores
A meeting is being set up with York City Council, and York Trust to
discuss address any operational issues that are contributing to the
overspend on the York equipment store.
EMERGENCY DEPARTMENT
The directorate are continuing to report monthly on the medical staffing
rota costs within the emergency department. There had been a
reduction in the on-going overspend, mainly due to the new monies
identified as part of the business case and also on-going recruitment to
vacant middle grade posts. In recent months however further medical
staffing pressures have emerged which need addressing
Page 6
Elective Services Directorate Finance Overview as at 30th June 2012
Directorate Income & Expenditure (£'000)
In Month Variance to Plan
Key Financial Drivers
YTD Variance to Plan
5
(423)
Monthly Financial Position
Variance to plan
Total Income:
Private Patient Income
Other Income
YTD £'000
(97)
(73)
(25)
Previous Month
YTD (£'000)
(62)
(52)
(10)
Total Expenditure
Pay:
Nursing
Medical Staff
Other Pay
(326)
(3)
(177)
(2)
(367)
(13)
(171)
2
Drugs
Clinical Supplies
Other Non Pay
(19)
16
(141)
(26)
(38)
(120)
Net Position
(423)
(429)
4,450
4,350
Value £'000
4,250
4,150
4,050
3,950
3,850
3,750
Pla n ( £' 0 00 )
Act ual ( £' 00 0 )
Actions Agreed:
Performance Against CIP 2012/13
Medium risk
£497k
* Discussions to be held with all clinical leads to discuss the most cost
effective ways of covering current medical staffing issues
Actioned & Low
risk, £1,451k
* Reduce sickness levels on the wards and in outpatients through pro-active
management and working with HR representatives.
* Work flexibly to cover shifts across all outpatient areas - sharing staff and
ideas
* Weekly meetings to assess shortfall in CIP action plan
High Risk
£492k
Progress on Actions Agreed:
Cumulative CIP Target to Date (£'000)
Cumulative CIP Achieved to Date (£'000)
Over-achievement/Shortfall (£'000)
628
482
(146)
Comments:
* The elective directorate had an underpend of £5k in the financial month of June
2012/13. The main reasons for the movement against plan were:
1) Medical Staffing - Signficant progress was made on the medical staffing position
with it being only £17k over in month (down from £64k in May). The main issue that
currently remains is due to gaps on the junior doctor rota in Orthopaedics from
Deanery vacancies
2) PP Income - Income was down against the revised plan. This was mainly in
Orthopaedics where the anticipated levels of additional growth have not yet
materialised.
3) All the nursing budgets across the Directorate continue to perform strongly in
spite of a number of pressures such as increased activity levels and high levels of
sickness
* Analysis shows activity levels are up in all elective specialities with the
exception of Orthopaedics.
* Significant improvements continue on the pay financial position on the
wards and in outpatients even withstanding significant growth in activity.
* Work continually on-going to close the shortfall in the CIP action plan. The
Oral surgery and Orthodontic department inc clinician have agreed to do an
additional clinic and associated procedure list free of charge.
* More savings identified from Orthopaedic consumables tendering process
and dental income initiatives through the mobile dental unit.
* Medical staffing issues continue to be the biggest financial risk to the
directorate in 12/13 particularly covering short term vacancies. Significant
issues has been resolved in General Surgery, Ophthalmology and Paediatrics
although concerns remain about the upcoming deanery rotation
Page 7
Integrated Care Directorate Finance Overview as at 30th June 2012
Directorate Income & Expenditure (£'000)
In Month Variance to Plan
Key Financial Drivers
YTD Variance to Plan
(43)
Variance to plan
YTD £'000
Total Income:
(7)
Private Patient Income
(12)
Other Income
5
(208)
In Month Financial Position
Previous
Month
(21)
(5)
(16)
3000
Pla n ( £'000)
£'000's
2900
2800
Act ual ( £'000)
2700
2600
2500
Total Expenditure
Pay:
Nursing
Medical Staff
Other Pay
(201)
68
(39)
(45)
(22)
48
(16)
(29)
Drugs
Clinical Supplies
Other Non Pay
3
(39)
(150)
1
(7)
(20)
Net Position
(208)
(43)
Performance Against CIP 2012/13
Actions Agreed:
Medium risk,
£120
Actioned & Low
risk, £1,109
* Delivery of CIP high risk plans. Creation of new actions through Specialty redesign
meetings.
* Assessment of current vacancies to prioritise areas to recruit.
High risk, £903
Cumulative CIP Target to Date (£'000)
525
Cumulative CIP Achieved to Date (£'000)
371
Over-achievement/Shortfall (£'000)
(154)
Comments:
*The Integrated Care Directorate overspend was £42k for the month of
June, due to the following:
* Unmet CIP of £26k was phased into the position.
* The financial position for the wards was much improved, with a 3k
underspend.
* Medical staffing saw a £16k pressure from vacancies across the Junior
doctor rota.
* Review options around private patient income.
* Recruitment into vacant medical staffing posts.
Progress on Actions Agreed:
* Pilot specialty meetings with Haematology, to take place in Q1. Network visits /
presentations to raise the profile of Lascelles as a continuing care provider.
* Vacancy control is in place to assess all posts that arise for replacement, through an
authorisation process via the Directorate. Further review of non clinical vacancies.
* Action underway to care for patients requiring 1 -1 care using a more sustainable
model.
* Adverts placed for Elderly/Stroke and Neurology/Stroke posts, and reduced number
of vacancies on the Tier 2 & 3 General Medicine rota.
Page 8
Corporate Directorate Finance Overview as at 30th June 2012
Directorate Income & Expenditure (£'000)
In Month Variance to Plan
Key Financial Drivers
YTD Variance to Plan
(80)
C
u
m
1
u
l
1
a
t
i
1
v
(270)
Monthly Financial Position
Previous Month
YTD (£'000)
(27)
Total Expenditure
Pay:
Corporate Clinical
Corporate Non Clinical
(225)
(1)
34
(163)
(6)
28
Non Pay:
(235)
(23)
(156)
(30)
(270)
(191)
1
2,500
Value £'000
YTD £'000
(46)
Total Income:
£'000's
2,700
Variance to plan
2,300
0
2,100
0
1,900
S
p
e
0
1,700
1,500
P lan ( £'0 0 0)
Act u al ( £ '00 0)
Performance Against CIP 2011/12
Med-Risk ,
£192
High-Risk,
£333
Actioned &
low Risk ,
£1,235
VarinceYto
ActualYeroD
PlanYertoD MgilRaes
Specialty £0
ENT 1,92 3 0
GenralSugy 1,370 49 2
Gynaecolg 2,80 61 (9)
Obsteric 6,408 192
Ophtalmogy 5,317 49 (2)
Oral&MxiofcSugey 95 1,08 3
Orthopaedics 17,40 52
Urolgy 4,321 0
Total 50,68 3 (2)
Clinical Corporate
Non Clinical Corporate
Net Position
Actions Agreed:
* All vacancies have to be brought before the Weekly Vacancy Control Group
Meeting
* Continued reinforcement of the message to budget holders of the need to
strictly manage non pay budgets
* On going series of meetings with budget holders regarding the finding of
further CIP schemes to replace high-risk schemes
Progress on Actions Agreed:
Cumulative CIP Target to Date (£'000)
147
Cumulative CIP Achieved to Date (£'000)
105
Over-achievement/Shortfall (£'000)
(42)
Comments:
At the end of month 3 Corporate is showing a £270K overspend with £253k
relating to clinical corporate areas and £17k being on non-clinical areas. The
in month variance was £80K. Pressures continue on car parking income.
Domestic pay was overspent by £17K . Energy was overspent by £23K and
unexpected repairs cost £21K. There was £22k high risk CIP.
Meeting arranged with Estates and Facilities management including the
Director to discuss the overspends and procedures for future expenditure
controls, particularly non-pay repairs and maintenance
Consultant engineers commissioned to investigate more efficient usage
of CHP.
Page 9
Overview Total Directorate Position
For the month ending June 30 2012
2011/12
Actual
£000
Opening
Budget
£000
Annual
Budget
£000
1,149
(28,551)
(6,355)
(33,756)
1,021
(28,166)
(3,559)
(30,705)
Non-Comissioner Income
Pay
Non-Pay
Total Integrated Care Directorate
1,107
(28,734)
(3,669)
(31,296)
3,068
(34,018)
(12,620)
(43,570)
2,210
(32,411)
(8,792)
(38,993)
Non-Comissioner Income
Pay
Non-Pay
Total Acute & Cancer Care Services Directorate
2,418
(32,756)
(8,475)
(38,813)
1,388
(37,143)
(12,047)
(47,801)
1,489
(34,783)
(9,499)
(42,793)
Non-Comissioner Income
Pay
Non-Pay
Total Elective Care Directorate
1,553
(36,158)
(9,126)
(43,730)
(14,166)
(13,384) Corporate (Clinical)
(139,294)
(125,875) Total Clinical Spend
(12,885)
(5,836) Corporate (inc. CNST)
(27,051)
153,262
Total Corporate Position
153,754 Commissioner Income
Workforce
Budget
Actual
wte
wte
Budget
£000
In Month
Actual
£000
Variance
£000
Cumulative
Budget
Actual
£000
£000
Variance
(o.s)/u.s
£000
123
(2,429)
(535)
(2,841)
102
(2,425)
(561)
(2,884)
(21)
4
(26)
(43)
320
(7,260)
(1,454)
(8,393)
314
(7,276)
(1,639)
(8,601)
(7)
(16)
(185)
(208)
204
(2,741)
(948)
(3,486)
145
(2,820)
(993)
(3,668)
(59)
(79)
(45)
(183)
671
(8,315)
(2,696)
(10,341)
653
(8,359)
(3,039)
(10,745)
(18)
(44)
(343)
(404)
794.20
122
(3,117)
(991)
(3,987)
87
(3,117)
(951)
(3,981)
(35)
(0)
41
5
372
(9,345)
(2,776)
(11,749)
275
(9,527)
(2,920)
(12,172)
(97)
(182)
(144)
(423)
340.51
320.53
(1,187)
(1,274)
(87)
(3,518)
(3,772)
(254)
(127,506)
2645.19
2543.13
(11,500)
(11,807)
(307)
(34,001)
(35,289)
(1,288)
(5,404)
186.59
177.37
(444)
(443)
1
(1,288)
(1,281)
7
(19,071)
527.10
497.90
(1,630)
(1,716)
(86)
(4,806)
(5,053)
(247)
154,871
12,990
13,059
69
37,790
38,438
648
(20,609)
(549)
(483)
65
(2,003)
(1,842)
161
498
325
(172)
498
25
(473)
773.39
750.63
773.39
750.63
724.11
677.77
724.11
677.77
807.18
794.20
807.18
(13,667)
Transforming Community Services
(194)
889
(20,691) Central
1,352
1,352
2,831.78
2,720.50
Page 10
Cash Flow – Receipts & Payments
CASH FLOW FORECAST 2012-13
Opening cash balance
APRIL
MAY
Actual
Actual
Plan
Actual
Plan
Plan
Plan
Plan
Plan
Plan
Plan
Plan
Plan
£000
£000
£000
£000
£000
£000
£000
£000
£000
£000
£000
£000
£000
5,874
JUN
5,084
5,555
JUL
5,555
AUG
6,208
SEP
5,990
OCT
5,944
NOV
5,423
DEC
5,423
JAN
5,436
FEB
5,672
TOTAL FOR
YEAR
MAR
5,394
£000
5,591
5,874
Receipts
New public Dividend Capital draw
0
0
0
0
0
0
0
0
0
0
0
0
0
0
10,047
10,160
10,347
10,083
10,560
10,347
11,046
11,127
10,348
10,348
11,714
10,348
10,346
126,474
NHS patient care
2,022
2,254
2,263
2,579
2,239
2,263
2,248
2,247
2,271
2,263
2,215
2,263
1,488
26,352
Other income
1,575
1,646
1,574
1,653
1,404
1,404
1,534
1,404
1,404
1,884
1,404
1,404
1,554
18,270
Investment interest
5
1
3
2
3
3
3
2
3
3
2
3
3
33
Macmillan Contribution
0
371
0
0
325
139
117
481
315
416
1
548
529
3,242
Loan finance
0
0
0
0
0
0
0
0
0
0
0
0
0
0
13,649
14,432
14,187
14,317
14,531
14,156
14,948
15,261
14,341
14,914
15,336
14,566
13,920
174,371
Cash spend - payroll
(5,435)
(5,498)
(5,435)
(5,468)
(5,435)
(5,435)
(5,435)
(5,435)
(5,435)
(5,435)
(5,435)
(5,435)
(5,435)
(65,316)
PAYE & Pensions
(3,721)
(3,841)
(3,741)
(3,828)
(3,741)
(3,741)
(3,741)
(3,741)
(3,741)
(3,741)
(3,741)
(3,741)
(3,741)
(45,059)
Cash spend - non-pay
(5,000)
(4,067)
(3,887)
(3,539)
(4,316)
(4,109)
(4,422)
(4,801)
(4,279)
(4,171)
(5,241)
(4,162)
(2,369)
(50,476)
(111)
(555)
(1,029)
(782)
(1,257)
(917)
(585)
(1,284)
(873)
(1,217)
(1,197)
(1,031)
(1,079)
(10,888)
0
0
0
0
0
0
(1,286)
0
0
0
0
0
(1,260)
(2,546)
(172)
0
0
(47)
0
0
0
0
0
(114)
0
0
(250)
(583)
(14,439)
(13,961)
(14,092)
(13,664)
(14,749)
(14,202)
(15,469)
(15,261)
(14,328)
(14,678)
(15,614)
(14,369)
(14,134)
(174,868)
Closing cash balance
5,084
5,555
5,650
6,208
5,990
5,944
5,423
5,423
5,436
5,672
5,394
5,591
5,377
5,377
Monitor plan month-end cash balance
5,551
5,741
5,836
5,836
5,618
5,572
5,051
5,051
5,064
5,300
5,022
5,219
5,005
Closing cash balance required to
equal 10 days Operating Exp.
4,466
4,466
4,466
4,466
4,485
4,485
4,485
4,504
4,504
4,504
4,526
4,526
4,526
NHS patient care - NYY PCT
Total cash receipts
Payments
Cash spend - non-pay - Capital
Dividend paid
Restructuring costs
Total cash spend
Page 11
Debtors Report
Outstanding Accounts Receivable Debts - JUNE 2012
NHS Debts
Insurance Companies
Other
T otals
0 to 30
Days
£000
31 to 60
Days
£000
61 to 90
Days
£000
Over 91 Days
£000
Total
£000
848
256
145
2,147
3,396
88
28
8
23
147
256
47
27
39
369
1,192
331
180
2,209
3,912
Note:- Excludes RTA's, Accruals & Prepayments.
Outstanding Invoices Over 61 Days & £10,000 - JUNE 2012
Debtor Name
*
Invoice Description
Total
£000
North Yorkshire & York PCT
H137308
ECR journeys undertaken by YAD outside PTS
12
North Yorkshire & York PCT
H139602
Charge for GP Annual Leave
80
North Yorkshire & York PCT
H139770
Smoking in Pregnancy 11/12
16
North Yorkshire & York PCT
H141773
July Patient Transport
26
North Yorkshire & York PCT
H144882
Novemebr Patient Transport
22
North Yorkshire & York PCT
H145534
Support Costs re Specialist Childrens Team
19
North Yorkshire & York PCT
H145608
Patient Transport Service December 2011
28
Depuy Product Recall
H146127
In-Patient Fixed Cost Hip Replacement Revision
North Yorkshire & York PCT
H146331
Q3 Out of Hours Service Overspend
North Yorkshire & York PCT
H146332
Mth 10 Out of Hours Service Overspend
82
North Yorkshire & York PCT
H146402
Long Stay MS Patient-April-December 2011
95
NHS East Ridings Of Yorkshire
H146682
NCA (Flex) January 2012
North Yorkshire & York PCT
H146794
Q2 Out of Hours Service Overspend
North Yorkshire & York PCT
H146945
Patient Transport Service January 2012
York Hospitals NHS FT
H147103
Q4 Ophthalmology Recharge
North Yorkshire & York PCT
H147151
Minor Injuries Unit Income April 11-Feb 12
466
North Yorkshire & York PCT
H147214
Community Services Contract Adjustment
228
North Yorkshire & York PCT
H147215
Provider to Provider Income Shortfall
219
North Yorkshire & York PCT
H147217
Community Admin Contract Variation-Sth Tees
North Yorkshire & York PCT
H147218
Health Visitor Funding 2011/12
North Yorkshire & York PCT
H147219
Reablement Monies 2011/12
North Yorkshire & York PCT
H147276
Community Services provided by HDFT April 2012
25
North Yorkshire & York PCT
H147319
Huntleigh Discharge Equipment April - December
67
Hampshire PCT
H147501
NCA (Flex) February 2012
11
NHS Lanarkshire
H147512
NCA (Flex) February 2012
14
Yorkshire & Humber SHA
H147644
Postgrad Deanery-LTFR Trainees
12
N.Y.C.C
H147651
Q4 2011/2012 JES Running Costs
22
Yorkshire & Humber SHA
H147973
Deanery Recharges
17
North Yorkshire & York PCT
H148090
Community Services May 2012
25
North Yorkshire & York PCT
H148146
Patient Transport Service May 2012
24
NHS East Lancashire
H148323
NCA March 2012
17
T otal
*
Invoice
Number
Now paid
12
106
16
320
27
14
33
32
100
2,187
Page 12