Docstoc

Slide 1 - The Shrewsbury and Telford Hospital

Document Sample
Slide 1 - The Shrewsbury and Telford Hospital Powered By Docstoc
					                                                                                                                                                                                         Enclosure 3
                                                        Trust Board Meeting
                                                                       – 7th October 2010
                                     FINANCE REPORT for the period ending 31st August 2010 (Month 5)
EXECUTIVE        Steve Shanahan                                                  KEY FACTS
RESPONSIBILE     Finance Director                                                The table below summarises the Income and Expenditure position for August.
AUTHOR (if       Tony Brown                                                      Plan         Actual     Variance     L Year                     Plan       Actual                       L Year     Annual
different from   Assistant Director Financial Performance                        £'000        £'000       £'000       £'000                      £'000      £'000      Variance £'000    £'000      Budget
above)           Jill Price
                 Assistant Director Financial Management                           21,753       22,120          367     21,630     Income         110,366 111,926                1,560 105,987 261,883
                 Chris Benham                                                    (14,589)     (15,100)        (511)   (14,321)       Pay         (73,126) (76,237)             (3,111) (71,764) (174,222)
                 Assistant Director Financial Accounting                          (5,937)      (6,277)        (340)    (5,458)     Non Pay       (30,376) (30,883)               (507) (29,185) (71,488)

CORPORATE        Ensuring a clinically viable and financially sustainable           1,227          743        (484)      1,851      EBITDA          6,864      4,806           (2,058)      5,038     16,173
OBJECTIVE        organisation                                                     (1,128)      (1,126)            2    (1,309)   Finance Costs    (5,640)    (5,610)                30    (6,533)   (13,606)

                                                                                         99      (383)        (482)       542        Total         1,224      (804)            (2,028)    (1,495)      2,567
EXECUTIVE        August 2010 (Month 5) financial performance shows :
SUMMARY          Actual deficit of £383k; plan surplus £99k.                     ● The Better Payments Practice Code (BPPC) target is to pay 95% of creditors
                                                                                   within 30 days. In August the Trust achieved an improvement :
                 ●Income; Further reduction for Emergency Threshold
                  £256k; year to date £897k.                                                 55% for Non-NHS invoices (50% July)
                 ●Pay run rate £15.1m.                                                       23% for NHS invoices (38% July)
                 ●Pay costs; overspend £0.511m, of which 63% due to              ● Overall deterioration in liquidity, increased cash balance offset by
                  overspend in Junior Medical staff.                               increases in net liabilities.
                 ●Junior medical staff pay pressures continue. In month             Increased cash holding in preparation for payment of PDC Dividend £2.6m
                  overspend £323k. Medical staff agency spend reduced              in September.
                  by £47k in month. Non recurrent pressures linked to
                  provision for non-compliant rotas and locum arrears
                  (£91k) in month.                                               RECOMMENDATIONS                           The Committee is asked to NOTE at month 5:
                 ●Further pay control measures forecast from September
                  giving improvement to pay run rate.
                                                                                                                           1. An Income and Expenditure deficit of £0.804m
                 ●e-Rostering lost opportunities being reviewed by                                                            against planned surplus of £1.224m.
                  Divisional Managers to ensure Ward Managers aware of
                                                                                                                           2. Forecast Outturn remains at £2.6 million
                  cost of inappropriate rostering and how to avoid such
                                                                                                                              surplus.
                  losses.
                                                                                                                           3. Improvement in performance against the Better
                 ●Forecast outturn, Month 5 FIMS return £2.6m surplus
                                                                                                                              Payments Practice Code (BPCC) target of 95%
                                                                                                                              for Non NHS creditors.



                            Finance Report                             Sheet 1   The Shrewsbury and Telford Hospital NHS Trust
       Section One- EXECUTIVE SUMMARY


                                                                                                       Monthly   Direction    2010/11                                                                   Sheet
                                                                       Position                      Performance of Travel     Actual                                Comment                             Ref
                                               In month                            £0.383m deficit       Red         =          Red     £0.482m deficit to plan                                           1
               I & E Position




                                               2010/11 Actual ytd                  £0.804m deficit       Red         =          Red     £2.028m deficit to plan                                           1
                                               Pay Costs                             £15.100m            Red         =          Red     3.5% above plan for the month                                    3/4
                                               WTE Worked                               4520            Green        =         Amber    Below plan                                                       3/4
                                               Agency WTE                                56             Amber        =          Red                                                                      3/4
                                               Agency Costs                           £0.571m           Amber        =          Red                                                                      3/4
                                               Non Pay Costs                          £6.277m            Red         =          Red     £0.340m over plan                                                10
                         Balance Improvement
                                  Programme




                                               CIP's delivered                        £0.894m           Amber        =         Red      Shortfall against plan ytd of £303k                               7



                                               Debtors                                                   Red         =         Red      £16k increase; significant +60 day NHS amounts outstanding       11
                          Sheet




                                               Creditors                                                 Red         =         Red      55% Non-NHS invoices and 37% NHS invoices paid within 30 days   12/13
                    Cash




                                               In Month Movement                  £1.893m increase      Green        =        Green     £1.938m balance at Month 5 against plan of £0.126m                5
 Ratios Expenditure
          Capital




                                               In month                               £1.231m           Green        =        Green                                                                      14
Metrics &




                                               Liquidity                                8.6              Red         =         Red      Impact of I & E position on working capital                       8
  Key




                                               EBITDA Margin %                          4.3%             Red         =         Red      Below plan level of 6.2%                                          8
                                               Financial Risk Rating                     2               Red         =         Red                                                                        8




                                                                       Finance Report                    Sheet 2         The Shrewsbury and Telford Hospital NHS Trust
          Section Two – Expenditure - Pay

                                                                                              PAY
                                                 Pay                                          ●   Month 5 Pay overspend £511k, across all staff groups. Efficiencies required to
                                                                                                  cover the pay award continue to be the main cost pressure.
          16,000                                                                              ●   Pay cost in Month 5 was £15.1m, the average for months 1 to 5 was £15.3m
          15,500                                                                              ●   Pay control totals were allocated to divisions during August . The June pay spend
          15,000                                                                                  of £15.4m was taken as a base against which to allocate run rate reductions of
£'000




          14,500                                                                                  £350k per month.
          14,000                                                                                  In month 5 the pay cost exceeded the control total by £41k, a reduction in pay
          13,500
                                                                                                  cost of £313k against the June level.
          13,000                                                                              ●   Key initiatives to reduce the level of nursing spend are in process of being
                                                                                                  implemented, these include reducing bank shift duration, changing working
                    Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
                                                                                                  patterns and contracting for hours to be worked over a given period rather than
                                                                                                  fixed weekly hours. Divisional lead nurses have led these reviews to ensure
                            2010/11 Actual             2010/11 Plan        2009/10 Actual
                                                                                                  quality and service levels are maintained.
                                                                                              ●   When considering the reduction in run rate it should be noted that some of the
                                                                                                  initiatives described above will begin to impact on pay spend in September and
                                                                                                  October and so further reductions linked to these can be expected over the next
                                                                                                  two months.
                                                                                              ●   Within the month 5 pay spend £131k non recurrent items have been identified.
                                                                                                  After adjusting for these the underlying pay spend is just below £15m.
                                                  Agency Costs
                                                                                               AGENCY
        1400                                                                                   ●   Month 5 agency costs decreased to £571k (July £654k). This is equivalent to
                                                                                                   56 wte.
        1200
                                                                                               ●   The in month agency spend per wte is 10.2k. The month 4 average was £9.3k.
  £'000




        1000                                                                                   ●   Agency costs in all areas other than consultants show a reduction on the month
          800                                                                                      4 figure.
          600                                                                                  ●   The consultant increase is largely in Radiology where the appointment of a
                                                                                                   locum radiologist is predicted, by the division, to reduce reliance on external
          400                                                                                      reporting of films/scans and reduce waiting list expenditure with radiologists. The
                   Apr   May Jun   Jul   Aug Sep Oct             Nov Dec Jan Feb Mar               current forecast spend reduction is £13k per month .
                                                                                               ●   Non clinical agency staff spend shows a £14k reduction on the month 4 level.
                                                                                                   This is predominantly in agency usage in facilities for housekeepers
                                             2010/11 Actual      2009/10 Actual


                                         Finance Report                             Sheet 3         The Shrewsbury and Telford Hospital NHS Trust
Section Two – Expenditure – Pay – Medical Staffing

                                                           Medical Staffing                                           ●   Medical Staff overspend £323k (July £237k). Agency overspend
                                                                                                                          within this is £263k which as reported previously is due to the
               2,500
                                                                                                                          premium cost of providing cover to ensure continuity and safety of
                                                                                                                          service and compliance with EWTD requirements.
               2,000
                                                                                                                      ●   In July 559 shifts were filled. Of these 88 (16%) were internally
               1,500
£'000




                                                                                                                          covered, the balance of 471 (84%) were filled by agency. For 2009/10
               1,000                                                                                                      the average was 652 shifts with the agency cover averaging 511
                        500
                                                                                                                          (78%).
                                                                                                                      ●   Medical staff agency cover costs have seen a slight reduction in
                             0
                                                                                                                          August to £448k (£495k in July).
                                  Sep Oct     Nov Dec Jan Feb Mar Apr May June Jul                            Aug
                                                                                                                      ●   The graphs opposite show the trend in medical staffing expenditure
                                                   Pay                   Agency                       Locum               over the 12 months. The graph shows that the cost of directly
                                                                                                                          employed and locum have remained even. However, since
                                                                                                                          September 2009 the reliance on agency to cover Deanery vacancies
                                                                                                                          and EWTD rota gaps is clearly illustrated. In September 2009 agency
                                                                                                                          was 19.8% of the total medical staffing spend, in August 2010 this has
              100%                                                                                                        risen to 20.4%
                       90%                                                                                            ●   Following the August rotation the fill rate for training posts has
                       80%                                                                                                substantially improved. This has reduced reliance on medical
    % of total spend




                       70%                                                                                                agencies, for longer term posts, and had a favourable impact on pay
                       60%
                                                                                                                          run rate.
                       50%
                       40%                                                                                            ●   Managers are currently assessing the potential impact and risk linked
                       30%                                                                                                to agency reliance following the October rotation.
                       20%
                       10%
                       0%
                                 Sep   Oct   Nov     Dec    Jan    Feb     Mar    Apr   May     Jun     Jul     Aug
                                             Pay                  Agency                Locum




                                                         Finance Report                                Sheet 4        The Shrewsbury and Telford Hospital NHS Trust
Section Three - Cash

                                                     Plan     Actual     Plan     Actual
                                                       M5         M5     YTD        YTD

Opening cash balance                                   203         45      441       441      Closing cash balance of £1,938k is an
                                                                                               increase of £1,893k on the prior month
EBITDA                                               1,179       681     6,123     4,502
                                                                                              EBITDA shortfalls (YTD £1,621k) and the
                                                                                               requirement to make capital expenditure
Impairments                                              0         0       500         0
                                                                                               payments have been managed through
Working capital movement                               200     1,979    (2,955)    3,720       creditor payments within working capital.
                                                                                              The Trust is liaising with the SHA to assist in
Operating cash flow                                  1,379     2,660     3,668     8,222       accelerating cash allocations and payment of
                                                                                               +60 day invoices from the local PCT’s to
Capital expenditure                                 (1,457)     (740)   (6,378)   (6,645)
                                                                                               improve the BPPC.
Proceeds from sale of assets                             0         0         0         0      Revised forecasting procedures are in place.
                                                                                               There were significant cash outflows in the
Operating cash flow after net capital expenditure      (78)    1,920    (2,710)    1,577       first quarter 2010/11 due to the completion
                                                                                               and timing of large capital projects (including
Net interest paid                                        1         2         5         6       decontamination offsite solution).
Provisions movement                                      0       (29)      (10)      (86)     Increase in cash balance to fulfil PDC
                                                                                               payment obligation of £2,528k to DH payable
Loan received                                            0         0     2,400         0       17 September 2010.

Loan repayment                                           0         0         0         0

Lease payment                                            0         0         0         0

PDC received                                             0         0         0         0

PDC paid                                                 0         0         0         0

Cash flow for period                                   (77)    1,893     (315)     1,497
Closing cash balance                                   126     1,938       126     1,938

                           Finance Report                Sheet 5         The Shrewsbury and Telford Hospital NHS Trust
 Section Four – Forecast Outturn – FIMS Month 5


                       M1-5       M6       Q3       Q4        FY11      FY11     FY11
                      Actual Forecast Forecast Forecast       Total     Plan Variance
                         £m       £m       £m       £m          £m        £m       £m    ●   The forecast outturn submitted as part of the Month 5
                                                                                             FIMS return is a £2.6 million surplus in line with original
Income :                                                                                     plan.
                                                                                         Assumptions are:
Patient Care           103.4        20.3    60.8     60.2     244.7     241.6     3.1     PCT QIPP schemes delivered in line with agreed plan
Other                    8.6         1.7     5.1      5.5      20.8      20.3     0.5        levels of activity from August to March.
                                                                                          Shropshire County PCT non elective activity
                                                                                             overperformance continues (after accounting for QIPP
Total Income           111.9        22.0    66.0     65.7     265.5     261.9     3.6        schemes)
                                                                                          Month 5 pay run rate continues after adjusting for non-
Pay                    (76.2)     (14.9)   (43.8)   (43.0)   (178.0)   (174.2)   (3.8)       recurrent items
Non Pay                (30.9)      (5.8)   (17.4)   (17.1)    (71.3)    (71.5)     0.2    Pay run rate reductions including confirmed schemes and
                                                                                             medical agency cost reductions phase in from month 6
Total Expenditure     (107.1)     (20.8)   (61.2)   (60.2)   (249.3)   (245.7)   (3.6)    CIPs at 74% of target
                                                                                          Additional posts (£1.2m) offset with additional run rate
                                                                                             reductions
EBITDA                   4.8         1.2     4.7      5.5      16.2      16.2     0.0
                                                                                          Emergency threshold adjustment is reimbursed (£0.9m)
                                                                                         ●   Non pay inflation continues to be managed as in previous
Finance Costs           (5.6)      (1.1)    (3.4)    (3.5)    (13.6)    (13.6)   (0.0)       years

Surplus / (Deficit)     (0.8)        0.1     1.3      2.0       2.6       2.6     0.0




                                Finance Report                    Sheet 6        The Shrewsbury and Telford Hospital NHS Trust
Section Five - Improvement Programme


                                                             SaTH Im provem ent Program m e Status Report


                         £7,000

                         £6,000

                         £5,000

                         £4,000
      £000




                         £3,000

                         £2,000

                         £1,000

                             £0
                                     M1        M2     M3        M4      M5        M6         M7    M8       M9       M10      M11      M12

   Actual Savings £'000             £87       £208    £383     £631    £894
   Planned Saving (FIMS) £'000      £90       £240    £463     £803    £1,197   £1,756   £2,462   £3,248   £4,041   £5,035   £5,876   £6,792
   Forecast Savings £'000           £81       £212    £409     £729    £1,103   £1,653   £2,324   £3,080   £3,880   £4,896   £5,756   £6,696

        The summary position is as follows:
            IP target for 2010/11 is £6.8 million.
            At Month 5 £0.894m has been delivered against a target of £1.197m. This equates to 75%. Against the revised
             forecast of
             £1.103m delivery equates to 81%.
            The current forecast outturn assumption is that delivery will be at 74% (£5m)
            A more detailed report is presented separately to the Finance & Performance Committee.
                       Finance Report                   Sheet 7        The Shrewsbury and Telford Hospital NHS Trust
Section Six - Financial Risk Rating

Plan     Financial        Weight   Metric         Rating categories (min thresholds)     Current Previous
                                                                                                                                             ROA excluding dividend (%)
         Criteria                                                                        Month    Month
                                                     5       4      3      2       1      Value    Value                                              10


                                    EBITDA
         Achievement of                                                                                                                                8
100.0%                      10%     Achieved       100%    85%     70%    50%    <50%      70.0%    72.1%
              plan
                                   (% of Plan)                                                                                                         6
                                                                                                                                                     5.1
                                                                                                                                                       4 3.4
           Underlying               EBITDA
6.2%                        25%                    11%      9%     5%     1%     <1%        4.3%     4.5%
          Performance              Margin (% )                                                                         10.4                                2.1
                                                                                                                Liquidity                              2                                         EBITDA Margin (%)
                                    Return on                                                                         10.2                                                     4.5   6.2
                                                                                                                                 8.6
                                      assets                                                                                                           0
                                                                                                                                                                         4.3
5.1%                        20%     excluding       6%      5%     3%     -2%    <-2%       2.1%     3.4%
                                                                                                                                                      -2
                                     dividend                                                                                                        -0.7
                                       (% )
            Financial                                                                                                                                       -0.5
            Efficiency                                                                                                                                             1.0
                                   I&E Surplus
                                    Margin net
1.0%                        20%                     3%      2%     1%     -2%    <-2%      -0.7%    -0.5%
                                   of dividends                                                                                              70
                                        (% )                                                                                            72

                                                                                                                                  100
                                    Liquidity                                                                Achievement of plan (%)                                                 I&E surplus margin (%)
 10.4       Liquidity       25%                     35      25      15     10     <10        8.6      10.2
                                   Ratio (days)
                                                                                                                          Current Month Value                    Plan                Previous Month Value
 2.8        Weighted Financial Risk Rating                                                   1.9       2.3
  3                Overall Rating                                                              2         2


 Risk rating of 2.
                                                                                                          The diagram above illustrates the Trust position in each metric of
 Deterioration in each of the FRR performance metrics.
                                                                                                           the FRR against the full year plan position and illustrates the in-
 Liquidity metric shows rating of 1. Increased cash balances offset                                       month deterioration against each of the metrics.
  by increasing net current liabilities. Cash balance growth due to
                                                                                                          The Trust is currently underperforming in each area.
  planning cash holdings to ensure Trust is able to meet PDC
  Dividend payment in September.
 Performance below plan continues to impact on the liquidity
  position
                                   Finance Report                                      Sheet 8          The Shrewsbury and Telford Hospital NHS Trust
Section Seven- Activity and Income

                                            Inpatients                                                        Inpatient Performance:
          10,000                                                                                               Total elective and day case activity was 101 spells below plan in August. This has given
                                                                                                                rise to an income under-recovery of £276k in August.
           9,500
                                                                                                               Overall Day Cases show an over performance of 4 spells in August. Over performance in
           9,000                                                                                                Day Case is reported in Gastroenterology, Ophthalmology, Clinical Haematology,
 Spells                                                                                                         Gynaecology and Clinical Oncology this is offset by underperformance in all other
           8,500                                                                                                specialties.
           8,000                                                                                               Backlog activity validated to 31st August is 891 spells in surgical specialties

           7,500
                                                                                                               Elective inpatient activity was 105 below plan in August. Under performance is reported
                    Apr     May Jun        Jul     Aug Sept Oct         Nov Dec      Jan Feb     Mar            in all specialties other than Paediatrics,
                          2010/11 Actual                 2009/10 Actual              2010/11 Plan              Non elective activity is 128 spells above plan in August. General Medicine being the main
                                               Outpatie nts                                                     area of over performance. Reported income has been adjusted to reflect the emergency
   A                                                                                                            threshold tariff adjustment, this has reduced reported income by £897k. Non elective
   t
   t
          28500                                                                                                 activity in total including maternity is £307k above plan in August
   e
   n
          26500
                                                                                                               Maternity activity is below plan 32 spells in August
   d
          24500
   a                                                                                                          Outpatient Performance:
   n
   c      22500
   e                                                                                                           In August outpatients were 2 attendances above plan (1,756 July) the income over
   s      20500                                                                                                 recovery for the five months is £1,427k.
                                                           ct

                                                                    v
                                     l

                                               g




                                                                          ec


                                                                                 n
                ay


                               n




                                                    ep




                                                                                      eb
                   r




                                                                                            ar
                                   Ju
                 p




                                                                 o



                                                                               Ja
                                            u
                            Ju




                                                          O




                                                                                                               In August new outpatients are 740 attendances above plan and 1329 attendances below
                                                                                           M
              A




                                                                N

                                                                        D
               M




                                                   S




                                                                                     F
                                           A




                   2010/11 Actual                     2009/10 Actual                     2010/11 Plan
                                                                                                                the July level. This includes Outpatient Procedures over performance in the month of
                                                                                                                1,039. The underlying new outpatient activity is 299 below plan.New attendances notably
                                                                                                                show under performance in Orthopaedics, Oral Surgery, Orthodontics, Dermatology and
                                   Accide nt & Em e rge ncy
                                                                                                                Geriatric Medicine.
   A
   t 10,000                                                                                                    Outpatient Procedure activity is significantly above plan in Orthodontics, Oral Surgery,
   t 9,500
   e
                                                                                                                Dermatology and Obstetrics. This partially offsets underperformance in new outpatients.
      9,000
   n
   d 8,500                                                                                                     Backlog activity validated to 31st August is 1,532 attendances in surgical specialties
   a 8,000
   n                                                                                                           Follow up outpatients are 737 attendances below plan and 1709 attendances below the
      7,500
   c                                                                                                            July level.
   e 7,000
   s               Apr M ay Jun            Jul Aug Se p Oct Nov De c                     Jan Fe b M ar
                                                                                                              Accident and Emergency

                   2010/11 Actual                     2009/10 Actual                      2010/11 Plan
                                                                                                               A & E attendances are 207 above plan in August (880 YTD). In month activity analysis
                                                                                                                shows RSH 53% and PRH 47%, income shows RSH 52% and PRH 48% split.

                                           Finance Report                                           Sheet 9        The Shrewsbury and Telford Hospital NHS Trust
  Section Eight - Expenditure – Non-Pay and Finance Costs


                                               Non Pay                                     Non pay shows an overspend of £340k in month. All non-clinical non-pay
                                                                                            expenditure requisitions continue to be reviewed and scrutinised for validity
        7,000                                                                               and necessity before being approved.
        6,500                                                                              The Divisional Report highlights specific areas of non pay over spend
        6,000
                                                                                            including:
£'000




        5,500
                                                                                                   Cancer/ Oncology/ Haematology drugs offset, by income recovery
        5,000
                                                                                                   Theatres Orthopaedic products, hip, knee and trauma related. Use
                                                                                                     of specific implants, under review.
        4,500
                    Apr May Jun    Jul     Aug Sep Oct Nov Dec Jan Feb Mar                         Increased demand for blood products in Medical specialties.
                                                                                                   Patient Transport Costs, offset by income.
                            2010/11 Actual           2009/10 Actual       2010/11 Plan




                                              Finance Costs
                                                                                           Finance costs are £2k underspent in August. Forecast outturn is in line with
            1,400                                                                           plan.
            1,200
            1,000
    £'000




              800
              600
              400
              200
                0
                     Apr May Jun     Jul    Aug Sep Oct Nov Dec Jan Feb Mar

                             2010/11 Actual              2009/10 Actual    2010/11 Plan




                                           Finance Report                      Sheet 10       The Shrewsbury and Telford Hospital NHS Trust
  Section Nine - Debtors

All                           Current              + 30 days              + 60 days         Total
                                                                                                       Trade debtors have increased by £274k compared to prior month
                                 £ '000                  £ '000               £ '000        £ '000
                                                                                                        with a reduction in accrued revenue of £258k. Total debtors have
NHS                              1,280                     480                1,145         2,905
                                                                                                        therefore increased by £16k.
Priv ate Patients                   78                      19                   84           181
Other *                            258                      78                  148           484
                                                                                                       Shropshire County PCT +60 days decreased by £67k. The +60day
Total                            1,616                     577                1,377         3,570
                                                                                                        category has been escalated and raised at the recent local FD
* Includes prescriptions, catering recharges, accomodation, telephones, ov erseas
                                                                                                        meeting with little impact and/or movement. The key invoices still
v isitors and MES activ ity
                                                                                                        outstanding are £363k for EPO drugs and £141k for a disputed
                                                                                                        balance of cardiac catheterisation (part payment of £203k received in
                                               + 30               + 60                                  month of May). FD is due to write to PCTs with possible involvement
      NHS                     Current          days               days        2009/10      Total        with the SHA.
                                £'000          £'000              £'000         £'000      £'000       Telford and Wrekin PCT +60 days category shows an increase of
      Shropshire County PCT      437                53              77            540      1,107
                                                                                                        £128k and is represented by the continued ageing of + 30 day
                                                                                                        category. The 3 main invoices outstanding are; £201k relating to
      Telford & Wrekin PCT       367                11             129            278       785         Month 12 2009/10 Herceptin; £15k that refers to Nuffield activity –
                                                                                                        the credit team are working with Contracts and Performance to
      Powys                         7                9              18                       34
                                                                                                        resolve and £22k relating to Lucentis injections. Recent
      RJAH                       179               122               1                 1    303         communication indicates the Herceptin amount of £201k will be paid
                                                                                                        15 September 2010. The over-performance invoice of £212k within
      Others                     290               285              79             -87      567
                                                                                                        current category will be paid 8 September 2010.
      Total                     1,280              480             312            833      2,905
                                                                                                       Herefordshire +60 days relates to month 12 forecast out-turn. All but
                                                                                                        1 of the 8 PCTs have agreed with the year end position. This is worth
                                                                                                        a net gain of £66k.
Non NHS Debtors > £ 25k                   £ '000     NHS Debtors > £ 100k                    £ '000
CP Plus                                     124      Shropshire County PCT                   1,107
NHS Employ ers                               72      Telford & Wrekin PCT                      785     Of the other debtors outstanding £34k has been referred to a
Ov erseas Visitor Z                          56      RJAH                                      303      specialist collection agency with appropriate provisions for write off
Keele Univ ersity                            50      West Mids Specialised Serv ices           122
                                                                                                        made based on expected collection success.
BUPA                                         34      Herefordshire PCT                         109
League of Friends - PRH                      30                                                        £56k in respect of an overseas visitor with no means to pay is
                                                                                                        shown in line with DH guidance – this debtor has been provided for
                                                                                                        in full.
Total                                       366                                              2,426

                              Finance Report                                  Sheet 11         The Shrewsbury and Telford Hospital NHS Trust
Section Ten – Creditors (Non NHS)

Table 1
NON NHS                     YTD         M1        M2      M3      M4      M5     YTD                   Table 1 summarises the non-NHS creditor payment
                         2009/10    2010/11   2010/11 2010/11 2010/11 2010/11 2010/11                   performance for the cumulative prior year, month 5 and
By Volume                                                                                               year to date position. The graph shows the prior year by
Total Volume               75587      4240      7670    6614     6654     4503       29681              month with current month position.
BPPC compliant volume      49629      1813      2135    2062     1318     1962        9290             The Better Payment Practice Code stipulates a target of
BPPC compliant %            66%       43%       28%     31%      20%      44%         31%               30 days.
                                                                                                       Increase in monthly compliance position due to
By Value
                                                                                                        prioritisation of non-NHS payments. The current
Total value (£000)          72097     5275      7056   11389     9671     8155       41546              cumulative compliance is on par with month 5 and is
BPPC compliant value (£000) 46040     2679      1850    7013     5234     6082       22858              31% for volume and 55% for value.
BPPC compliant %             64%      51%       26%     62%      54%      75%         55%
                                                                                                       Table 2 summarises the actual payment performance in
                                                                                                        the month.
                                                                                                              Better Payment Practice Code - Trade Creditors

Table 2
Payment made            Quantity Quantity %   Value Value %
0-30 days                 1,962        44%    £6,082    75%               Percentage
                                                                             100
31-35 days                  170         4%      £183     2%                   95
                                                                              90
36-40 days                  353         8%      £286     4%                   85
41-45 days                  341         8%      £274     3%                   80
                                                                              75
46-50 days                  236         5%      £178     2%                   70
                                                                              65
51-55 days                  342         8%      £300     4%                   60
                                                                              55
56-60 days                  402         9%      £317     4%                   50
over 60 days                697        15%      £535     7%                   45
                                                                              40
Total invoices paid       4,503       100%    £8,155   100%                   35
                                                                              30
                                                                              25
                                                                              20
                                                                              15
                                                                                   Sep-09   Oct-09   Nov-09    Dec-09     Jan-10     Feb-10     Mar-10     Apr-10      May-10     Jun-10   Jul-10   Aug-10
                                                                                                                                           Month

                                                                                                                   % Invoices Paid In 30 Days      % Value of Invoices Paid In 30 Days


                           Finance Report                      Sheet 12          The Shrewsbury and Telford Hospital NHS Trust
  Section Ten – Creditors (NHS)


Table 1
NHS Spend                         YTD        M1         M2        M3      M4      M5     YTD                  Table 1 summarises the non-NHS creditor payment
                               2009/10   2010/11    2010/11   2010/11 2010/11 2010/11 2010/11                  performance for the cumulative prior year, month 5 and
By Volume                                                                                                      year to date position. The graph shows the prior year by
Total Volume                     2189         29         79       154     489      24          775             month with current month position.
BPPC compliant volume            1192         14         35        23      97       7          176
BPPC compliant %                 54%        48%        44%       15%     20%     29%          23%             The Better Payment Practice Code stipulates a target of
                                                                                                               30 days.
By Value                                                                                                      The cumulative compliance position at Month 5 is 23%
Total value (£000)              20045       1776      1529       1487   3448      415         8655             for volume and 37% for value.
BPPC compliant value (£000)      6993        687       892        347   1242       67         3235
BPPC compliant %                 35%        39%       58%        23%    36%      16%          37%             Table 2 summarises the actual payment performance in
                                                                                                               the month.


                                                                                                                              Better Payment Practice Code - NHS Creditors

Table 2
Payment made                  Quantity Quantity %    Value    Value %
                                                                                    Percentage
0-30 days                            7       29%       £68        16%                   100

31-35 days                           2        8%        £0         0%                    90
                                                                                         80
36-40 days                           0        0%        £0         0%                    70

41-45 days                           1        4%       £58        14%                    60
                                                                                         50
46-50 days                           0        0%        £0         0%                    40
50-55 days                           3       13%       £61        15%                    30
                                                                                         20
56-60 days                           0        0%        £0         0%
                                                                                         10
over 60 days                       11        46%      £228        55%                            Sep-09   Oct-09   Nov-09       Dec-09      Jan-10       Feb-10    Mar-10      Apr-10      May-10   Jun-10   Jul-10   Aug-10

Total invoices paid                24       100%      £415       100%                                                                                        Month


                                                                                                                            % Invoices Paid In 30 Days       % Value of Invoices Paid In 30 Days




                               Finance Report                    Sheet 13        The Shrewsbury and Telford Hospital NHS Trust
   Section Eleven - Capital

                                                                    Total
                                                              Expenditure/           Forecast % of spend
                              Plan CRL Expenditure Committed Committed                Outturn /committed
                                2010/11   M05 YTD    M05 YTD     M05 YTD              2010/11     against
                                  £'000      £'000      £'000       £'000               £'000    forecast
                                                                                                                   The Capital Programme for 2010/11 has been revised to
B/Fwd 2009/10 projects             546        181             291           472          552       85.5%            £7.7m, based on internally generated funds only.
                                                                                                                   Only £222k of capital funds remains available.
2010/11 projects
CT Scanner PRH                     800           0            672            672          676      99.4%           CT Scanner PRH – temporary CT Scanner currently in
Bathroom refurbishment             350           0              0              0            0       0.0%            use.    Planned date for new CT Scanner to be
Decontamination Project          3,734       1,118          1,213          2,331        3,734      62.4%            operational is 25 October 2010.
Redevelopment of Women and                                                                                         Decontamination Project – delay in commissioning of
Children Zone                    3,000          14              4             18           18     100.0%            equipment due to utility upgrades not being completed
Electrical infrastructure          600           0              0              0            0       0.0%            as agreed. PRH service move will be on completion of
Theatres Air Handling              450         137            202            339          400      84.8%            works and commissioning. RSH service move planned
Others                           1,904         194            259            453        1,023      44.3%            for Mid-Spring 2011.
                                10,838       1,463          2,350          3,813        5,851      65.2%
                                                                                                                   Theatres Air Handling Scheme – works to complete
2010/11 contingency funds        1,350        389              50           439         1,080      40.6%            theatre 1 air plant currently being undertaken. Once
                                                                                                                    theatre 1 air plant becomes operational, then installation
2010/11 unallocated funds          371          0               0              0         222        0.0%            works of theatre 2 air plant will commence. Estimated
                                                                                                                    operational date for theatre 2 is 27 September 2010.
Total 2010/11                   13,105       2,033          2,691          4,724        7,705      61.3%



Planned CRL consists of:                             Forecast CRL consists of:
Depreciation                     7,705               Depreciation                       7,705
DH Loan for Decontamination      2,400               DH Loan for Decontamination            0
DH Loan for W&C Zone             3,000               DH Loan for W&C Zone                   0
Total 2009/10                   13,105               Total 2009/10                      7,705




                                  Finance Report                                   Sheet 14           The Shrewsbury and Telford Hospital NHS Trust

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:3/14/2012
language:Estonian
pages:14