Page 130 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
2,122,636 Supplies Supplies % Net Rev 13.7% 16.3% 2.59%
2,129 EIPAs Supplies per EIPA $997 $1,047 $49.99
15,484,570 Net Revenue

6135 RUN DATE: 1/10/2018
Mercy Health – St. Elizabeth Boardman Hospital RUN TIME: 8:18:46 AM
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
Actual Budget Variance Var % PY Actual Budget Variance Var % PY
2,122,636 2,558,319 435,684 17.0% 1,691,560 Total Supplies 32,074,235 31,398,351 (675,885) -2.2% 29,302,917
577,357 910,469 333,112 36.6% 884,189 Medical Surgical 10,532,521 11,186,818 654,297 5.8% 10,698,534
835,063 842,443 7,380 0.9% 945,798 Drugs 10,704,798 10,284,188 (420,610) -4.1% 9,459,001
St Elizabeth Boardman Financials
21,239 12,733 (8,506) -66.8% 12,148 Implant - Stents 283,469 156,797 (126,672) -80.8% 180,174
(429) 3,823 4,253 111.2% - Implant - CRM AICD/Pacemakers 9,640 47,104 37,464 79.5% 27,830
20,810 16,557 (4,253) -25.7% 12,148 Total CRM Implants 293,109 203,901 (89,208) -43.8% 208,004
17,975 1,813 (16,162) -891.5% - Implant - Spinal 95,361 22,349 (73,011) -326.7% 21,720
254,559 214,269 (40,290) -18.8% 249,183 Implant - Orthopedic Joint 2,971,705 2,638,507 (333,198) -12.6% 2,732,635
301,426 211,850 (89,576) -42.3% 323,811 Implant - Other 3,516,748 2,609,990 (906,758) -34.7% 2,976,074
573,960 427,932 (146,028) -34.1% 572,994 Total Non-CRM Implants 6,583,814 5,270,847 (1,312,967) -24.9% 5,730,429
594,770 444,488 (150,281) -33.8% 585,142 Implant Total 6,876,923 5,474,748 (1,402,175) -25.6% 5,938,433

70,315 89,294 18,979 21.3% 83,629 Dietary 931,108 1,100,700 169,591 15.4% 1,021,953
77,091 60,011 (17,080) -28.5% 11,372 Blood 730,182 741,395 11,213 1.5% 671,090
12,974 4,694 (8,280) -176.4% 8,486 Endomechanical 54,935 57,801 2,866 5.0% 56,795
59,738 82,716 22,978 27.8% 77,153 Other Non-Medical 774,727 1,022,749 248,022 24.3% 958,329
77,771 56,626 (21,145) -37.3% 67,780 IV and IV Sets 784,163 697,291 (86,872) -12.5% 665,672
864 16,726 15,862 94.8% - Physical Plant/Maintenance 176,531 205,765 29,234 14.2% 24,409
20,991 1,277 (19,713) -1543.5% 9,917 Laboratory 107,809 15,727 (92,082) -585.5% 32,095
16,014 16,563 549 3.3% 17,024 Office 199,828 205,626 5,798 2.8% 205,259
8,403 11,095 2,692 24.3% 11,180 Minor Equipment Non-Medical 114,980 136,472 21,493 15.7% 331,979
13,605 8,009 (5,597) -69.9% 15,051 Suture 158,409 98,618 (59,791) -60.6% 113,562
16,975 20,842 3,867 18.6% 12,955 Instruments 236,477 256,649 20,172 7.9% 253,087
48 4,466 4,418 98.9% - Minor Equipment Medical 427 54,930 54,503 99.2% 26,118
- 6 6 100.0% - Linen & Laundry - 74 74 100.0% 36
(88,947) 5,261 94,208 1790.8% 4,719 Freight 84,361 65,046 (19,315) -29.7% 60,643
12,047 9,853 (2,194) -22.3% 11,304 Housekeeping & Laundry 156,631 121,652 (34,979) -28.8% 129,151
11,579 11,570 (9) -0.1% 10,217 Contrast Media 186,046 142,474 (43,572) -30.6% 141,916
467 3,951 3,485 88.2% 6,371 Gases, Medical 95,476 48,657 (46,819) -96.2% 51,025
247 14 (233) -1680.2% - Forms 1,566 171 (1,394) -813.5% 503
569 245 (324) -131.9% - Uniforms 5,425 3,029 (2,396) -79.1% 1,867
- 33 33 100.0% - Film, Radiographic 2,246 408 (1,838) -450.1% 1,276
- - - 0.0% - Anesthesia 171 - (171) 0.0% 326
(149,433) - 149,433 0.0% (1,003,292) Inventory Variance (149,433) - 149,433 0.0% (1,003,292)
(24,864) (30,693) (5,828) 19.0% (29,289) Premier Incentive (341,351) (378,921) (37,570) 9.9% (357,847)
(20,662) (10,951) 9,710 -88.7% (36,705) Rebates & Incentives (333,325) (135,200) 198,125 -146.5% (167,879)
(345) (690) (344) 49.9% (1,442) Purchase Discounts (17,396) (8,517) 8,879 -104.3% (11,124)
1,034 1,199 (165) -13.8% 1,201 Total Admissions 13,760 14,317 (557) -3.9% 13,968
3,790 4,340 (550) -12.7% 4,866 Total Patient Days 50,698 51,820 (1,122) -2.2% 51,649
131 163 (32) -19.7% 173 Total IP Surgeries 1,898 1,930 (32) -1.7% 1,880
419 364 55 15.1% 434 Total OP Surgeries 4,783 4,682 101 2.2% 4,575
550 527 23 4.3% 607 Total Surgeries 6,681 6,612 69 1.0% 6,455
2,129 2,445 (315) -12.9% 2,338 Total EIPAs 28,173 29,870 (1,698) -5.7% 29,019
13.5% 16.3% -2.8% -17.3% 10.6% Supply Expense % of Net Revenue 16.5% 16.3% 0.2% 1.4% 15.8%
13.7% 16.6% -2.8% -17.2% 10.8% Supply Expense % of Net Patient Revenue 16.8% 16.6% 0.2% 1.4% 16.1%
997 1,047 50 4.7% 723 Supply Expense per EIPA 1,138 1,051 (87) -8.3% 1,010
30,905,718 32,157,332 (1,251,614) -3.9% 35,322,135 Gross Inpatient Revenue 396,993,179 385,494,115 11,499,064 3.0% 368,343,341
32,739,720 33,407,262 (667,542) -2.0% 33,450,770 Gross Outpatient Revenue 415,829,174 418,785,351 (2,956,178) -0.7% 396,912,990
63,645,438 65,564,594 (1,919,156) -2.9% 68,772,906 Total Gross Revenue 812,822,352 804,279,467 8,542,886 1.1% 765,256,331
15,484,570 15,452,565 32,005 0.2% 15,635,071 Total Net Patient Revenue 190,355,907 188,956,676 1,399,231 0.7% 181,802,441