Page 99 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
2,039,410 Supplies Supplies % Net Rev 17.7% 12.6% -5.12%
1,557 EIPAs Supplies per EIPA $1,310 $896 ($413.83)
11,511,193 Net Revenue

6710 RUN DATE: 1/10/2018
Mercy Health – St. Charles 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,039,410 1,538,743 (500,666) -32.5% 711,576 Total Supplies 18,234,076 18,299,618 65,542 0.4% 15,934,594
719,212 509,818 (209,395) -41.1% 226,275 Medical Surgical 5,718,417 5,759,737 41,320 0.7% 4,841,077
542,345 393,583 (148,762) -37.8% 384,349 Drugs 4,725,612 4,787,420 61,808 1.3% 4,246,302
(15,351) 9,017 24,369 270.2% 3,444 Implant - Stents 77,213 110,064 32,851 29.8% 87,193
- 4,605 4,605 100.0% - Implant - CRM AICD/Pacemakers - 56,228 56,228 100.0% 55,951
(15,351) 13,622 28,974 212.7% 3,444 Total CRM Implants 77,213 166,292 89,080 53.6% 143,144
83,650 50,497 (33,153) -65.7% 20,815 Implant - Spinal 692,223 616,638 (75,585) -12.3% 508,129
66,627 120,389 53,762 44.7% 152,187 Implant - Orthopedic Joint 1,177,391 1,472,123 294,732 20.0% 1,498,276
122,827 256,053 269,675 85,168 (37,659) (17,050) 11,923 -44.2% 255,982 Total Non-CRM Implants 1,349,861 3,219,475 3,296,688 1,040,566 3,129,326 3,295,619 (309,296) (90,149) -29.7% 1,034,974
82,980
Implant - Other
St Charles Financials 69,250 105,297 25,989 (16,138) (11,104) 36,047 -112.4% 87,854 Minor Equipment Non-Medical 1,272,240 305,402 1,284,777 317,219 150,810 -26.8% 1,260,077
-2.9%
3,041,379

-6.7%

273,103

(1,069)
0.0%

257,752
Implant Total
259,426
3,184,524

4.4%

34.2%
12,537
Dietary
1.0%
3.7%

17,234
345,456
33.7%
8,755

11,817
Blood
20,326

-

0.0%
85,843

-
-

0.0%
16,138

(85,843)
-
Endomechanical
18,908
236,171
2,495

17,104

-0.6%
Other Non-Medical

14,608
207,853

(1,238)
209,091

14.6%
-19.6%

(4,905)
305,039
24,694
275,055
IV and IV Sets
29,904

(81,898)
386,937

24,999

440,973
25,268

34.2%
11,493
176,805
Physical Plant/Maintenance

36,761
13,798

31.3%

290,163

Laboratory
705,430

24.8%
71,000
54,535
668,671

(36,759)
-5.5%
41,015

13,520
712,269
0.0%

-
58

Chemistry Supplies
-
2,153
0.0%
2,398
-

-
(2,153)
21,574
425,749
510,790
140,549

24.8%

Radiology
53.6%
38,919
46,457

566,298
24,883

15.3%
146,878
1,603

30,544

10,192

23.9%
97,103
127,647
Office
8,852

10,456
-14.3%
137,615
120,425

115,864
(17,190)

14,417

9,878

20,983

-52.6%
55,996
6,507
4,263

52,034

(2,244)

(3,962)
50,758
-7.6%

Suture

7,074
79,149
-24.1%
6,486

-34.3%
8,047
Instruments
5,894

71,825

142,027
10,226

-97.7%
71,416
(70,202)
5,154
2,046

(12,408)

7,164
-248.6%
(1,459)

Linen & Laundry
609
19,571

587
4,787
(7,399)
79,985
Freight

22.4%
1,380

6,936
73,968
81,367
-10.0%

6,167

12,328
12,549
17,736
6.0%
197,800
212,548
5,151

29.5%

Housekeeping & Laundry
34,620 17,479 (28,726) (1,562) -487.4% 15,233 Minor Equipment Medical 106,318 210,350 (27,169) -173.2% 83,534
24,482

10.6%
160,262
8.5%

16,705
140,804
Contrast Media
11,802
12,905

157,509
1,103

1,090 3,860 2,770 71.8% 14,085 Gases, Medical 43,126 47,037 3,911 8.3% 51,160
6,415 1,828 (4,587) -250.9% 1,291 Forms 21,806 22,213 407 1.8% 35,617
(1,192) 831 2,023 243.5% 11,740 Fuel (aircraft & auto) 3,703 9,951 6,248 62.8% 15,856
- 158 158 100.0% 797 Uniforms 1,910 1,914 4 0.2% 2,598
747 569 (178) -31.4% - Film, Radiographic 4,792 6,876 2,084 30.3% 7,615
357 1,963 1,606 81.8% 2,481 Pack & Gowns 17,419 23,962 6,543 27.3% 23,349
198,165 (387) (198,552) 51334.5% (529,593) Inventory Variance 153,621 (4,632) (158,254) 3416.3% (566,702)
(15,554) (19,791) (4,237) 21.4% (18,322) Premier Incentive (213,529) (237,030) (23,501) 9.9% (223,862)
(14,722) (8,130) 6,593 -81.1% (22,853) Rebates & Incentives (191,439) (98,468) 92,971 -94.4% (122,747)
(168) (491) (323) 65.9% (564) Purchase Discounts (9,658) (5,880) 3,778 -64.3% (5,613)
793 936 (143) -15.2% 938 Total Admissions 10,485 10,927 (442) -4.0% 10,578
3,810 4,576 (766) -16.7% 4,416 Total Patient Days 51,311 54,545 (3,234) -5.9% 53,095
97 112 (15) -13.2% 116 Total IP Surgeries 1,165 1,135 30 2.6% 1,144
420 434 (14) -3.2% 495 Total OP Surgeries 5,527 5,340 187 3.5% 5,302
517 545 (28) -5.2% 611 Total Surgeries 6,692 6,475 217 0 6,446
1,557 1,718 (161) -9.4% 1,778 Total EIPAs 20,493 20,852 (359) (0) 20,313
17.6% 12.5% 5.1% 40.4% 6.3% Supply Expense % of Net Revenue 12.9% 12.6% 0.2% 1.8% 11.6%
17.7% 12.6% 5.1% 40.3% 6.4% Supply Expense % of Net Patient Revenue 13.0% 12.8% 0.2% 1.7% 11.7%
1,310 896 (414) -46.2% 400 Supply Expense per EIPA 890 878 (12) -1.4% 784
29,402,456 35,980,689 (6,578,234) -18.3% 31,649,731 Gross Inpatient Revenue 386,151,738 406,971,124 (20,819,386) -5.1% 367,616,819
28,321,343 30,076,593 (1,755,250) -5.8% 28,338,846 Gross Outpatient Revenue 368,595,728 369,657,269 (1,061,542) -0.3% 338,331,774
57,723,799 66,057,282 (8,333,484) -12.6% 59,988,577 Total Gross Revenue 754,747,465 776,628,393 (21,880,928) -2.8% 705,948,593
11,511,193 12,183,001 (671,808) -5.5% 11,167,631 Total Net Patient Revenue 140,329,133 143,181,534 (2,852,401) -2.0% 135,770,118