Page 55 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
182,084 Supplies Supplies % Net Rev 26.7% 9.6% -17.12%
355 EIPAs Supplies per EIPA $513 $301 ($211.91)
681,415 Net Revenue

6620 RUN DATE: 1/8/2018
Marcum & Wallace Memorial Hospital RUN TIME: 3:01:15 PM
For Periods Ending December 31, 2017
Month To Date Month To Date Month To Date MTD MTD Year To Date Year To Date Year To Date YTD YTD
Marcum & Wallace Financials
Actual Budget Variance Var % PY Actual Budget Variance Var % PY
182,084 114,322 (67,762) -59.3% 205,496 Total Supplies 1,870,796 1,752,966 (117,829) -6.7% 1,607,175
21,369 25,757 4,388 17.0% 28,995 Medical Surgical 280,488 355,090 74,603 21.0% 277,420
82,564 34,292 (48,272) -140.8% 91,749 Drugs 822,950 651,585 (171,365) -26.3% 551,091

2,405 5,171 2,767 53.5% 5,926 Dietary 46,406 55,900 9,495 17.0% 54,068
15,466 8,145 (7,321) -89.9% 10,136 Blood 72,998 97,046 24,048 24.8% 101,300
2,156 1,963 (193) -9.8% 1,251 Other Non-Medical 41,947 25,695 (16,252) -63.3% 22,190
5,066 1,817 (3,249) -178.8% 2,457 IV and IV Sets 46,538 24,503 (22,035) -89.9% 24,278
1,531 3,554 2,023 56.9% 1,115 Physical Plant/Maintenance 44,763 53,640 8,877 16.5% 40,660
31,082 18,623 (12,459) -66.9% 29,231 Laboratory 298,076 287,047 (11,029) -3.8% 286,539
493 28 (465) -1638.9% 161 Radiology 9,030 421 (8,609) -2046.0% 31
4,291 3,096 (1,194) -38.6% 3,934 Office 42,041 45,874 3,833 8.4% 39,688
1,198 785 (413) -52.7% 11,603 Minor Equipment Non-Medical 30,912 11,756 (19,156) -162.9% 19,434
67 137 70 50.9% 17 Suture 948 1,730 782 45.2% 1,275
126 52 (74) -142.6% - Instruments 3,421 620 (2,801) -451.4% 2,299
1,708 3,422 1,715 50.1% 8,714 Minor Equipment Medical 19,949 41,349 21,400 51.8% 83,123
2,402 1,446 (956) -66.1% 1,964 Linen & Laundry 21,008 21,656 648 3.0% 21,540
4,625 1,346 (3,279) -243.6% 4,124 Freight 41,841 20,922 (20,919) -100.0% 24,874
1,327 837 (489) -58.4% 1,194 Housekeeping & Laundry 15,303 12,543 (2,759) -22.0% 15,362
994 715 (278) -38.9% 1,059 Contrast Media 17,095 10,546 (6,548) -62.1% 11,119
6,235 5,316 (919) -17.3% 6,776 Gases, Medical 58,113 63,338 5,225 8.2% 66,030
- - - 0.0% - Forms 301 - (301) 0.0% -
- 83 83 100.0% - Fuel (aircraft & auto) - 1,244 1,244 100.0% 611
- - - 0.0% - Film, Radiographic - - - 0.0% 110
317 (51) (368) 722.0% 759 Inventory Variance 2,977 (763) (3,739) 490.4% 2,620
(1,479) (1,793) (314) 17.5% (1,733) Premier Incentive (20,304) (22,539) (2,235) 9.9% (21,168)
(1,832) (383) 1,449 -378.6% (3,875) Rebates & Incentives (25,098) (5,727) 19,370 -338.2% (16,689)
(27) (41) (14) 34.4% (61) Purchase Discounts (906) (512) 394 -76.9% (629)
93 91 2 2.7% 93 Total Admissions 1,153 1,017 136 13.4% 956
372 540 (168) -31.1% 466 Total Patient Days 4,713 5,838 (1,125) -19.3% 4,611
355 379 (24) -6.4% 312 Total EIPAs 4,335 4,558 (223) -4.9% 3,830
21.2% 8.4% 12.8% 151.7% 15.9% Supply Expense % of Net Revenue 10.8% 11.0% -0.2% -2.0% 13.0%
26.7% 9.6% 17.1% 178.6% 17.8% Supply Expense % of Net Patient Revenue 12.2% 12.4% -0.2% -1.9% 14.2%
512 301 (211) -70.1% 659 Supply Expense per EIPA 432 385 (47) -12.2% 420
1,338,959 1,299,174 39,785 3.1% 1,412,282 Gross Inpatient Revenue 17,155,033 14,523,703 2,631,330 18.1% 14,441,197
3,777,025 4,143,648 (366,623) -8.8% 3,320,015 Gross Outpatient Revenue 47,343,446 50,562,136 (3,218,690) -6.4% 43,419,266
5,115,985 5,442,822 (326,837) -6.0% 4,732,297 Total Gross Revenue 64,498,479 65,085,839 (587,360) -0.9% 57,860,463
681,415 1,191,945 (510,530) -42.8% 1,153,570 Total Net Patient Revenue 15,328,818 14,094,072 1,234,746 8.8% 11,290,306