Page 170 - Mercy MOR All Regions_FinalwithVideo

RUN DATE: 2/7/2018 RUN TIME: 6:50:53 AM YTD PY 1,561,848 518,985 359,867 1,969 1,969 34,720 155,025 98,051 287,797 289,766 132,764 25,301 - 32,015 26,910 37,176 44,940 -

YTD Var % -21.6% -7.4% -41.8% 63.8% 63.8% 41.9% -60.1% -25.7% -26.5% -23.4% -11.4% 7.6% -180.2% -40.1% -49.8% 60.9% -72.9% 100.0% 24.6% 32.1% 41.9% -60.4% -121.9% 85.1% -48.2% -610.1% 14.3% 8.6% -9.2% 357.8% 80.0% 100.0% 100.0% 90.3% -467.7% -31.2% -47.1% 75.8% 16.7% -6.0% -26.0% -5.1% (0) 0 29.5% 29.7% -11.6% 14.3% -1.2% 6.7% -6.3%

Year To Date Variance (297,980) (33,415) (147,438) 5,031 5,031 17,152 (51,262) (24,375) (58,484) (53,453) (10,264) 2,035 (8,120) (7,530) (13,728) 18,175 (42,068) 349 9,849

Year To Date Budget 1,381,021 452,549 353,068 7,880 7,880 40,916 85,240 94,847 221,003 228,883 90,181 26,785 4,505 18,766 27,571 29,821 57,742 349 40,109 8,741

Year To Date Actual 1,679,001 485,963 500,506 2,849 2,849 23,764 136,502 119,222 279,488 282,337 100,444 24,750 12,625 26,296 41,300 11,646 99,810 - 30,260 5,938

Mercy Health – St. Charles Hospital For Periods Ending January 31, 2018

6710 Total Supplies Medical Surgical Drugs Implant - Stents Total CRM Implants Implant - Spinal Implant - Orthopedic Joint Implant - Other Total Non-CRM Implants Implant Total Dietary Blood Endomechanical Other Non-Medical IV and IV Sets Physical Plant/Maintenance Laboratory Chemistry Supplies Radiology Office Minor Equipment Non-Medical Suture Instruments Minor Equipment Medical Linen & Laundry Freight Housekeeping & Laundry Contrast Media Gases, Medical Forms Fuel (aircraft & auto) Uniforms Film, Radiographic Pack & Gowns Inventory Variance Premier Incentive Rebates

1,561,848 518,985 359,867 1,969 1,969 34,720 155,025 98,051 287,797 289,766 132,764 25,301 - 32,015 26,910 37,176 44,940 - 34,092 8,428 10,739 6,975 4,392 6,507 778 4,946 22,968 12,122 5,406 1,892 21 - - 2,343 (3,431) (21,532) (2,192) (330) 956 4,999 119 416 535 1,760 13.6% 13.7% 887 35,778,955 30,086,446 65,865,402 11,376,020
MTD PY

-21.6% -7.4% -41.8% 63.8% 63.8% 41.9% -60.1% -25.7% -26.5% -23.4% -11.4% 7.6% -180.2% -40.1% -49.8% 60.9% -72.9% 100.0% 24.6% 32.1% 41.9% -60.4% -121.9% 85.1% -48.2% -610.1% 14.3% 8.6% -9.2% 357.8% 80.0% 100.0% 100.0% 90.3% -467.7% -31.2% -47.1% 75.8% 16.7% -6.0% -26.0% -5.1% -8.8% 8.9% 29.5% 29.7% -11.6% 14.3% -1.2% 6.7% -6.3%

MTD Var %

Month To Date Variance (297,980) (33,415) (147,438) 5,031 5,031 17,152 (51,262) (24,375) (58,484) (53,453) (10,264) 2,035 (8,120) (7,530) (13,728) 18,175 (42,068) 349 9,84

Month To Date Budget 1,381,021 452,549 353,068 7,880 7,880 40,916 85,240 94,847 221,003 228,883 90,181 26,785 4,505 18,766 27,571 29,821 57,742 349 40,109

Month To Date Actual 1,679,001 485,963 500,506 2,849 2,849 23,764 136,502 119,222 279,488 282,337 100,444 24,750 12,625 26,296 41,300 11,646 99,810