Page 26 - Mercy MOR All Regions_FinalwithVideo

RUN DATE: 2/7/2018 RUN TIME: 6:50:53 AM YTD PY 4,106,437 1,304,366 761,986 55,437 127,081 11,195 193,714 41,873 703,451 366,960 1,112,284 1,305,998 75,295 80,229 42,236 21,464 83,546 75,751 35

YTD Var % -2.6% -4.4% 7.2% -7.4% -118.7% 33.3% -63.5% -33.5% -2.4% -20.5% -10.6% -20.6% -1.3% 27.4% 16.8% -54.2% -48.9% 64.5% -12.2% 7.8% 15.2% 20.0% 43.0% -4.6% -16.0% -29.8% -69.1% 42.9% 48.4% -55.6% -49.0% 16.2% -10.2% 25.5% 100.0% 1473.9% -27.1% -334.0% 80.4% 6.5% 8.7% -30.5% 13.6% (0) (0) 0 2.5% 2.9% 2.2% 3.6% -0.3% 2.0% -0.4%

Year To Date Variance (97,790) (50,904) 61,101 (4,638) (145,890) 11,273 (139,255) (12,978) (13,383) (73,219) (99,580) (238,835) (1,260) 21,163 7,524 (9,453) (37,062) 46,014 (5,237)

Year To Date Budget 3,814,047 1,149,736 847,767 62,578 122,882 33,813 219,273 38,684 546,558 357,513 942,755 1,162,028 96,524 77,209 44,900 17,442 75,722 71,366 42,795 31,693

Year To Date Actual 3,911,837 1,200,639 786,666 67,216 268,772 22,540 358,528 51,663 559,941 430,732 1,042,335 1,400,863 97,784 56,046 37,376 26,895 112,784 25,352 48,032 29,230

6301 Mercy Health - Anderson Hospital 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 Chemistry Supplies Radiology Office Minor Equipment Non-Medical Suture Instruments Minor Equipment Medical Linen & Laundry Freight Housekeeping & Laundry Contrast Media Gase

4,106,437 1,304,366 761,986 55,437 127,081 11,195 193,714 41,873 703,451 366,960 1,112,284 1,305,998 75,295 80,229 42,236 21,464 83,546 75,751 35,573 26,368 68,518 24,516 21,614 46,059 41,490 46,180 7,232 24,419 27,530 22,011 4,878 11,976 205 - - 3,832 (53,251) (2,126) (1,460) 1,187 4,925 249 506 755 71 2,017 19.9% 20.1% 2,036 47,713,986 33,361,607 81,075,594 20,416,263
MTD PY

-2.6% -4.4% 7.2% -7.4% -118.7% 33.3% -63.5% -33.5% -2.4% -20.5% -10.6% -20.6% -1.3% 27.4% 16.8% -54.2% -48.9% 64.5% -12.2% 7.8% 15.2% 20.0% 43.0% -4.6% -16.0% -29.8% -69.1% 42.9% 48.4% -55.6% -49.0% 16.2% -10.2% 25.5% 100.0% 1473.9% -27.1% -334.0% 80.4% 6.5% 8.7% -30.5% 13.6% -1.7% -15.0% 4.9% 2.5% 2.9% 2.2% 3.6% -0.3% 2.0% -0.4%
MTD Var %

Month To Date Variance (97,790) (50,904) 61,101 (4,638) (145,890) 11,273 (139,255) (12,978) (13,383) (73,219) (99,580) (238,835) (1,260) 21,163 7,524 (9,453) (37,062) 46,014 (5,237)

Month To Date Budget 3,814,047 1,149,736 847,767 62,578 122,882 33,813 219,273 38,684 546,558 357,513 942,755 1,162,028 96,524 77,209 44,900 17,442 75,722 71,366 42,795 31,693

Month To Date Actual 3,911,837 1,200,639 786,666 67,216 268,772 22,540 358,528 51,663 559,941 430,732 1,042,335 1,400,863 97,784 56,046 37,376 26,895 112,784 25,352