Page 158 - Mercy MOR All Regions_FinalwVideo

RUN DATE: 2/7/2018 RUN TIME: 3:31:02 PM YTD PY 1,946,909 643,868 289,333 27,796 28,728 - 56,524 86,042 154,387 330,430 570,859 627,383 65,605 45,652 - 18,788 17,650 30,417

YTD Var % -12.8% 10.4% 6.2% 79.3% -0.4% -35.5% 16.4% -330.9% -37.2% -13.2% -58.8% -47.9% -34.9% 14.3% 0.0% -112.1% -104.5% 13362.6% -39.2% -23.2% 49.4% -94.5% -29.0% 34.3% -76.5% -270.9% 2.6% 34.3% 59.3% 64.6% 0.3% 4 -8.1% 100.0% 3.2% 182.8% -32.7% -167.6% 0.4% (2) 32.0% 8.7% -26.0% -11.2% (0) 0 1 0 9.6% 9.7% 6.6% 20.4% 2.4% 10.2% 2.8%

Year To Date Variance (231,271) 64,548 22,528 15,535 (237) (2,227) 13,071 (189,448) (51,691) (36,431) (277,570) (264,499) (14,051) 5,505 (16,581) (29,750) (19,964) (7,780) (24,101)

Year To Date Budget 1,803,119 622,022 363,630 19,583 54,080 6,273 79,937 57,252 139,112 275,548 471,912 551,848 40,297 38,425 - 26,538 19,107 (58) 61,415 28,330

Year To Date Actual 2,034,390 557,473 341,102 4,048 54,318 8,500 66,865 246,700 190,803 311,978 749,482 816,347 54,348 32,920 16,581 56,288 39,071 7,722 85,516 34,888

Mercy Health – St. Anne Hospital

6740 For Periods Ending January 31, 2018 Total Supplies Medical Surgical Drugs Implant - Stents Implant - CRM AICD/Pacemakers Implant - Open Heart/Heart Valves 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 Radiology Office Minor Equipment Non-Medical Suture Instruments Minor Equipment Medical Linen & Laundry Freight Housekeeping & Laundry Contrast Media Gases, Medical Forms Fuel (aircraft & auto) Film, Rad

1,946,909 643,868 289,333 27,796 28,728 - 56,524 86,042 154,387 330,430 570,859 627,383 65,605 45,652 - 18,788 17,650 30,417 77,148 35,579 10,249 13,991 14,481 37,855 1,470 - 3,835 12,619 8,023 328 1,381 568 70 5,651 10,223 (22,943) (1,498) (815) 498 1,878 130 611 741 22 1,040 18.7% 18.9% 1,872 33,193,420 36,113,758 69,307,178 10,317,122
MTD PY

-12.8% 10.4% 6.2% 79.3% -0.4% -35.5% 16.4% -330.9% -37.2% -13.2% -58.8% -47.9% -34.9% 14.3% 0.0% -112.1% -104.5% 13362.6% -39.2% -23.2% 49.4% -94.5% -29.0% 34.3% -76.5% -270.9% 2.6% 34.3% 59.3% 64.6% 0.3% -8.1% 100.0% 3.2% 182.8% -32.7% -167.6% 0.4% 32.0% 8.7% -26.0% -11.2% -13.3% 6.3% 20.8% 9.6% 9.7% 6.6% 20.4% 2.4% 10.2% 2.8%
MTD Var %

Month To Date Variance (231,271) 64,548 22,528 15,535 (237) (2,227) 13,071 (189,448) (51,691) (36,431) (277,570) (264,499) (14,051) 5,505 (16,581) (29,750) (19,964) (7,780) (24,101)

Month To Date Budget 1,803,119 622,022 363,630 19,583 54,080 6,273 79,937 57,252 139,112 275,548 471,912 551,848 40,297 38,425 - 26,538 19,107 (58) 61,415

Month To Date Actual 2,034,390 557,473 341,102 4,048 54,318 8,500 66,865 246,700 190,803 311,978 749,482 816,347 54,348 32,920 16,581 56,288 39,071