Page 206 - Mercy MOR All Regions_FinalwithVideo

RUN DATE: 2/7/2018 RUN TIME: 3:31:02 PM YTD PY 268,790 48,183 107,157 4,625 4,625 9,354 14,130 23,483 28,108 14,400 5,870 122 4,555 2,271 10,848 20,628 1,998

YTD Var % -24.1% -15.1% -49.2% 202.4% 202.4% -34.4% -33.5% -34.1% -11.1% -41.9% -97.8% -156.8% 47.2% -61.7% -40.7% -24.1% 91.6% -584.3% 36.0% 11.0% 23.0% -249.3% 94.0% -23.1% -6.8% -19.8% 68.0% -182.8% -26.5% 100.0% 100.0% (6) 308.9% -63.8% -906.3% 79.5% 24.5% 28.6% 38.9% 2 -14.7% (0) 0 20.1% 19.3% -12.6% 30.0% 11.7% 15.1% 4.0%

Year To Date Variance (60,028) (6,344) (53,607) 5,189 5,189 (5,504) (2,591) (8,094) (2,905) (4,528) (2,631) (1,086) 2,179 (1,859) (2,012) (7,141) 616 (975)

Year To Date Budget 249,424 42,030 108,883 2,564 2,564 15,980 7,723 23,703 26,267 10,811 2,690 693 4,612 3,014 4,945 29,571 672 167 2,295

Year To Date Actual 309,453 48,374 162,490 (2,626) (2,626) 21,484 10,314 31,798 29,172 15,339 5,321 1,779 2,433 4,874 6,957 36,712 56 1,142 1,469

Mercy Health – Willard Hospital For Periods Ending January 31, 2018 Total Supplies Medical Surgical Drugs Implant - CRM AICD/Pacemakers Total CRM Implants 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 Freight Housekeeping & Laundry Contrast Media Gases, Medical Forms Fuel (aircraft & auto) Film, Radiographic Dept Transfers Inventory

6780

268,790 48,183 107,157 4,625 4,625 9,354 14,130 23,483 28,108 14,400 5,870 122 4,555 2,271 10,848 20,628 1,998 234 2,527 1,144 1,050 3,826 11,793 818 3,782 - 1,338 2,007 417 - - 227 (4,009) (331) (173) 58 214 8 63 71 274 11.4% 11.9% 980 1,204,948 4,493,269 5,698,217 2,267,533

MTD PY

-24.1% -15.1% -49.2% 202.4% 202.4% -34.4% -33.5% -34.1% -11.1% -41.9% -97.8% -156.8% 47.2% -61.7% -40.7% -24.1% 91.6% -584.3% 36.0% 11.0% 23.0% -249.3% 94.0% -23.1% -6.8% -19.8% 68.0% -182.8% -26.5% 100.0% 100.0% 308.9% -63.8% -906.3% 79.5% 24.5% 28.6% 38.9% -14.7% -11.5% 10.2% 20.1% 19.3% -12.6% 30.0% 11.7% 15.1% 4.0%
MTD Var %

Month To Date Variance (60,028) (6,344) (53,607) 5,189 5,189 (5,504) (2,591) (8,094) (2,905) (4,528) (2,631) (1,086) 2,179 (1,859) (2,012) (7,141) 616 (975)

Month To Date Budget 249,424 42,030 108,883 2,564 2,564 15,980 7,723 23,703 26,267 10,811 2,690 693 4,612 3,014 4,945 29,571 672 167

Month To Date Actual 309,453 48,374 162,490 (2,626) (2,626) 21,484 10,314 31,798 29,172 15,339 5,321 1,779 2,433 4,874 6,957 36,712 56