Balanced Score Card Report Review of June 2017 Data Finance Finance - PowerPoint PPT Presentation

Balanced Score Card Report Review of June 2017 Data

Finance

Finance Report – June 2017 CUH Actual outturn 1H 2017 PAY & NONPAY  Gross pay & non pay budget € 176.7m (2016 : € 170.5m)  Actual pay & non pay € 181.9m (2016: € 174.4m)  Actual Deficit € 5.2m (-3%) (2016 : € 3.9m/-2.3%) Less Adjustments € 3.87m increase in Bad debts provision € 2.1m PCRS Drugs € 0.85m LRA Restoration unfunded € 0.94m Adjusted Deficit € 1.34m(-0.76%) (2016 : € 1.8m/-1%) INCOME  Income budget € 39.74m (2016 : € 40m)  Actual Income € 38.97m (2016 : € 39.1m)  Actual Deficit € 0.77m (-2%) (2016 : € 0.9m/-2%)

CUH – Pay & Non pay Budget Surplus/(Deficit) % Jan Feb Mar April May June July Aug Sept Oct Nov Dec 1.0% 0.51% 0.5% 0.0% -0.18% -0.28% -0.40% -0.84% -0.5% -0.52% -0.75% -0.76% -0.66% -0.81% -0.85% -0.85% -0.72% -1.0% -1.01% -1.04% -0.91% -1.22% -1.32% -1.14% -1.36% -1.5% -1.86% -1.94% -1.96% -2.0% -2.27% -2.30% -2.27% -2.01% -2.03% -2.42% -2.43% -2.5% -2.86% -2.88% -2.92% -2.95% -3.0% -3.5% 2017(adj) 2017 2016(adj) 2016

CUH AGENCY WTE 2014-7 Jul-14 Sep-14 Dec-14 Jan-15 Mar-15 Jun-15 Sep-15 Dec-15 Jun-16 Jul-16 Aug-16 Sep16 Oct 16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 June-17 Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual A ctual A ctual Actual A ctual A ctual Actual Actual Actual Actual Actual A ctual Radiotherapist 9.40 4.00 4.87 2.78 0.95 0.9 Radiographer 0.09 0.05 0.06 Labs 12.04 13.40 11.0 12.19 1.0 Cardiac Techs 3.80 3.80 1.0 Physio 1.60 1.50 Pharmacy 2.00 1.00 Admin 23.40 9.08 9.36 14.1 9.3 Nursing 46.20 33.0 34.7 37.8 40.0 30.4 28.6 26.1 31.6 32.1 28.7 27.6 29.6 31.5 25.5 33.3 33.3 32.7 31.7 34.3 37.3 HCA 34.80 16.2 22.7 23.2 24.4 29.8 30.8 38.2 38.4 45.7 52.1 52.1 56.9 32.1 17.7 26.1 25.3 34.5 34.5 33.9 36.6 House-Keeping 10.40 0.16 Physics 4.30 2.6 1.6 1.09 0.92 0.75 0.66 0.46 0.83 0.83 0.83 0.83 0.83 0.83 0.83 0.83 0.83 0.23 Catering 3.00 8.5 2.0 2.7 1.8 6.9 3.9 0.9 1.2 Social Work 1.00 0.5 Occ Therapy 1.00 0.37 Dietician 0.50 0.3 1 1 1 1 1 1 1 1 1 1 1 1 1 Medical 11.00 5.27 4.77 4.4 6.35 5.86 7.97 15.73 0.25 0.95 4.44 0 0.38 1.62 0.6 0.34 Consult 2.47 4.45 5.13 6.7 2.99 2.84 1.87 1.82 2.83 2.94 2.15 2.34 1.54 NCHD 5 164.5 99.7 91.1 98.26 84.7 74.6 71.9 81.4 76.75 85.03 92.20 88.23 91.70 69.89 46.9 63.05 63.26 71.37 69.95 71.88 76.4

CUH AGENCY COSTS € k 2015 - 2017

Acute Nursing Agency WTE 2015 to 2017 50 40 32.9 40 35.9 32.2 34.4 30.4 33.8 32.6 31.7 27.6 29.3 34.2 30.8 29.5 31.1 31.3 30.5 25.5 27.8 27.6 30 25.2 30.4 30.5 30.5 31.3 30.7 29.8 23.8 31.4 26.8 20 10 0 Jan Feb Mar April May June July Aug Sept Oct Nov Dec 2017 2016 2015 Acute HCA Agency WTE 2015 to 2017 70 60 52.1 56.9 41.1 50 38.4 45.7 52.1 36.9 36.6 37.7 35.2 32.1 38.2 40 37.2 34.7 34.5 33.9 32.4 32.7 30.8 29.8 34.5 34.5 30 26.1 31.0 25.3 17.7 20 23.2 26.8 24.4 19.3 10 0 Jan Feb Mar April May June July Aug Sept Oct Nov Dec 2017 2016 2015 7

CUH Average Nursing & HCA Agency WTE’s per Week 2015 -17 90 84.5 79.9 77.3 70.4 76.2 80 66.9 70.4 71.6 68.8 68 71.4 61.6 70 65.2 64.2 59.1 56.6 60 64.6 65.1 64.9 63.7 64.4 61.7 61.2 59.9 63.2 59.3 58.4 50 52.2 57.4 41.5 40 30 20 10 0 Jan Feb Mar April May June July Aug Sept Oct Nov Dec 2017 2016 2015 CUH Average Specials /Other Nursing & HCA Agency WTE’s per Week 2016 -17 70 57.8 60 50.4 49.2 51.9 48.2 50 43.7 43.1 52.4 51.3 45.6 37.5 40 29 28.9 33.3 33.7 32.4 34.1 30 30.5 32.8 31.9 30.6 32.4 32.2 20.9 27.6 29.5 28.5 29.2 28.1 20 24.9 23.4 21.3 20.5 20 18.7 10 11 0 Jan Feb Mar April May June July Aug Sept Oct Nov Dec 8 Specials 2016 Specials 2017 Other 2016 Other 2017

CUH Non-Pay Budget v Actual June 2017

CUH Actual Non-pay expenditure € k June 2017 v 2016

CUH Private Bed Occupancy 2017 v 2016 CUH Bed Occupancy 2017 v 2016 160 151 150 147 145 140 139 130 130 128 126 2016 125 124 123 121 120 120 120 2017 118 115 115 114 114 113 111 111 111 111 110 110 110 102 100 Aug 7th Dec Jan Feb Mar Apr May Jun Jul Sep 12th Oct 19th Oct 26th Oct 2nd Nov 9th Nov 16th Nov 23rd Nov 14th Dec 21st Dec 30th Nov

Patient Income 2015 – 2017

CUH Debtor Days Consultant Claims June 2017 50 49.0 46 44 44 45 43 43 44 44 44 44 44 42.0 43 43 42 42 41 40 41 42 41 42 40 41 41 40 42.0 39 40 35 35 30 30 25 20 Jan Feb Mar April May June July Aug Sept Oct Nov Dec 2016 2017 Target (old) 2015

MGH - Finance Report – June 2017 Mallow YTD June 2017 outturn  Gross pay & non pay budget € 10.03m (2016: € 10m)  Actual pay & non pay € 10.32m (2016: € 10.1m)  Actual deficit € 287k (-2.9%) (2016: € 118k -1.2%)  Less Adjustments € 246k increase in Bad debts provision € 186k LRA Restoration unfunded € 60k Adjusted deficit € 41k (-0.4%) Mallow Income outturn  Income budget € 1.77m (2016: € 1.92m)  Actual Income € 2.09m(2016: € 1.91m)  Actual surplus € 315k (18%) (2016:Surplus € 91k 6%)

BGH - Finance Report – June 2017 Bantry YTD June 2017 outturn  Gross pay & non pay budget € 10.3m  Actual pay & non pay € 10.48m  Actual deficit € 181k (-1.8%) – Less Adjustments € 199k – increase in Bad debts provision € 41k – St. Josephs ward € 111k – LRA Restoration unfunded € 45k – Waiting list initiative € 2k  Adjusted surplus € 18k (0.2%) Bantry Income outturn  Income budget € 1.79m  Actual Income € 1.81m  Actual surplus € 23k (1%)

Relocation of HBS Storage to the National Distribution Centre CUH Project-go live 12 th June 17

CUH - NDC Implementation Committee The CUH - NDC Implementation Committee is being established to: Oversee the implementation of residual actions set out in HBS Local project plan Address the specific service issues arising from the project Monitor the achievement of the HBS Cost Containment target of € 700k Monitor the introduction of barcode/scanning to all stock locations Develop the suite of appropriate user reports for all levels of Management

CUH - NDC Implementation Committee This committee will operate on behalf of the EMB The core membership will comprise: • Mr. Brendan O’Reilly, Operations Manager • Mr. Terry Kiely ,Finance Manager • Mr. Stephen Lynch ,Assistant Head of Logistics & Inventory • Management • Mr. Michael Coleman, Logistics Operations Manager .Cork • City & County • A/ Director of Nursing Nominee Other individuals and departments will be called on as required

Patient Access – Emergency Department

CUH 30 Day Moving Average 2016 - 2017 (14/07/2017)

30 Day Moving Average (21/07/2017)

6 Hour PET & 8AM TrolleyGAR per 100 ED Attends 23

PET Monthly Comparison (Non Admitted)

PET Monthly Comparison (Admitted)

PET > 24hrs PET >24 hours 350 300 320 250 328 316 264 200 150 100 97 85 50 57 0 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17

>75 years Bed Wait >9 hours >75yrs Bed Wait >9 hrs (2017) 250 200 150 **Up to 18th July 218 215 200 199 100 129 120 50 46 0 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17

Delayed Discharges – April – June 2017

Bed Days Used by inpatients for Associated Date with LOS > 14 days

>14 Day Target Reduction 31

Overview of CUH In-Patients Awaiting Cardiac Surgery Numbe Ward Adm. Patients in Referring Intended Current Status r Date Hospital Consultant Surgical in excess of Cardiologist Procedure 14 days & Consultant Surgeon  Patient SDU 21/06/ Dr. E. AVR Surgery Date Wednesday 1. 2016 McFadden TA 19/07/2017 Patient SDU 10/07/ Dr. P. CABG Surgery Date (TBC) 2. 2017 Kearney KD Referral rec’d 17/07/17 Patient 3D Card. 17/07/ Dr. E. CABG - KD Referral received @ 3. Ward 17 McFadden 4.00pm this afternoon referral on Mr Doddakula desk for his attention

Patient Flow Improvement Plan - PF 17  Whiteboards (completed)  >14 Day Patient Review – Discharge Coordinator Staffing (completed) – Weekly >14 Day Review(work in progress) – Delayed Discharges (18 patients >100 days) – Long Term Care Process (MUH Meeting 20 th June) – Early identification of patients with LOS >14 days (work in progress)  Acute Surgical Pathway (work in progress)  Cardiothoracic Pathway (completed)  Orthopaedic Pathway (to be progressed)  Integrated Care Pathways (work in progress)  Acute Floor Interface Group (work in progress)  Communication Plan (work in progress)

Patient Access - Outpatient Waiting Lists

Total Medical Patients to be seen by 15 Month Target (as of June 2017) (205) 70 64 60 50 40 31 28 30 20 18 20 14 9 10 6 4 3 2 2 1 1 1 1 0