Page 93 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
2,168,432 Supplies Supplies % Net Rev 20.7% 16.2% -4.47%
1,069 EIPAs Supplies per EIPA $2,028 $1,939 ($89.47)
10,488,688 Net Revenue

6740 RUN DATE: 1/10/2018
Mercy Health – St. Anne 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,168,432 1,862,988 (305,444) -16.4% 1,836,508 Total Supplies 23,284,332 22,102,704 (1,181,628) -5.3% 20,849,945
648,002 603,363 (44,639) -7.4% 646,563 Medical Surgical 7,540,950 7,156,017 (384,932) -5.4% 6,847,335
510,258 364,807 (145,451) -39.9% 334,953 Drugs 4,356,363 4,406,544 50,181 1.1% 3,956,623
18,349 29,461 11,112 37.7% 25,722 Implant - Stents 262,338 333,243 70,905 21.3% 313,119
10,487 113,372 102,885 90.7% 33,936 Implant - CRM AICD/Pacemakers 700,958 1,172,850 471,893 40.2% 845,851
11,825 7,473 (4,352) -58.2% 17,475 Implant - Open Heart/Heart Valves 78,623 90,080 11,457 12.7% 99,706
40,661 150,306 109,645 72.9% 77,133 Total CRM Implants 1,041,919 1,596,173 554,255 34.7% 1,258,677
190,403 84,133 (106,270) -126.3% 106,315 Implant - Spinal 1,439,344 1,017,662 (421,683) -41.4% 940,283
158,162 102,705 (55,457) -54.0% 152,867 Implant - Orthopedic Joint 1,780,275 1,244,327 (535,948) -43.1% 1,463,423
(27,013)
266,825 239,812 426,650 576,955 (188,740) -11.3% 338,409 Total Non-CRM Implants 3,550,616 6,770,235 7,812,154 2,903,209 5,165,197 6,761,370 (1,605,038) -22.3% 3,091,718
(647,407)
Implant - Other
St Anne Financials 34,287 42,269 30,783 -16.0% 30,806 Minor Equipment Non-Medical 474,086 490,239 210,202 -71.9% 494,259 444,141 352,210 204,003 780,430 410,591 132,043 19,750

615,389

5,495,424
-31.1%
-44.2%

597,591

-15.5%
656,050

(1,050,784)
-13.7%
Implant Total
674,724
6,754,100

(79,095)

Dietary
7,982
18.9%
3.3%
16,153

431,917

483,534
19,501

39,985
30,624
9,361
10.7%
23.4%

Blood

51,617
-

Endomechanical
(3,028)
3,805
-
0.0%

3,028
(3,805)

-
-
0.0%

327,809

Other Non-Medical
-3.6%
28,076
(11,350)

33,990
(4,692)

29,298
316,459

(14,342)
32,126

209,257

-80.7%

17,696
IV and IV Sets

(150,488)
17,783

359,745
160,273
370,475
161
Physical Plant/Maintenance

56.7%

99.5%

1,296
30,945
-14.7%

1.8%

39,930
776,839
76,801

(9,838)
66,963

14,503
791,342
Laboratory

354,972
429,150
17.3%
Radiology
74,177

28.4%

10,152
25,582
35,734

33,158

103,208
127,428
3,453

Office
24,219

8,368
10,717
19.0%

7,264
32.2%
94,306

121,686

7,845
8,165
-29.0%
(27,380)

3.9%

88,719
962

320
(1,327)
Suture

-11.7%

23,397
359,224

Instruments

24,299
-27.0%
(76,287)
47,753

282,937
71,905
19.5%
14,037
33,832

6,040
57,868

8,244
-460.2%

Linen & Laundry
5,455
547
6,099

38
644
2,490
89.4%

-
509
6.9%

Freight
74,337
-1.7%
167.0%
(1,361)
6,471

81,131
(5,236)

7,817

82,493

117,578
Housekeeping & Laundry
-3.6%
10,885
11,473

12,707 11,380 (24,356) (27,792) 13,054 -104.1% 17,262 Minor Equipment Medical 172,031 137,458 (34,573) -25.2% 148,086 257,606 118,739 88,344
121,851
(4,273)
12,037
(1,152)

-10.6%

(664) 3,968 4,632 116.7% 3,451 Contrast Media 29,828 47,987 18,160 37.8% 51,950
394 909 515 56.6% 696 Gases, Medical 17,740 10,994 (6,745) -61.4% 9,616
424 1,150 725 63.1% 1,466 Forms 18,265 13,486 (4,780) -35.4% 11,604
(761) 863 1,623 188.2% (2,880) Fuel (aircraft & auto) 6,631 10,431 3,800 36.4% 7,086
- 6 6 100.0% 32 Uniforms 398 58 (340) -588.6% 332
374 755 381 50.5% 78 Film, Radiographic 3,616 9,128 5,512 60.4% 12,940
8,693 7,198 (1,495) -20.8% 9,504 Pack & Gowns 84,378 87,047 2,669 3.1% 87,123
23,734 756 (22,978) -3039.3% (37,785) Inventory Variance 39,834 7,840 (31,994) -408.1% (31,397)
(16,573) (24,355) (7,782) 32.0% (19,523) Premier Incentive (227,520) (252,562) (25,041) 9.9% (238,530)
(14,006) (14,667) (661) 4.5% (21,567) Rebates & Incentives (292,910) (158,260) 134,649 -85.1% (227,478)
(804) (643) 160 -24.9% (747) Purchase Discounts (13,842) (6,672) 7,170 -107.5% (7,107)
498 422 76 18.0% 392 Total Admissions 5,537 4,884 653 13.4% 4,861
1,610 1,653 (43) -2.6% 1,435 Total Patient Days 19,755 18,562 1,193 6.4% 17,908
132 96 36 37.3% 91 Total IP Surgeries 1,285 1,046 239 22.9% 1,084
601 628 (27) -4.2% 708 Total OP Surgeries 7,904 7,892 12 0.2% 7,727
733 724 9 1.3% 799 Total Surgeries 9,189 8,938 251 0 8,811
14 19 (5) -27.9% 21 Cath Lab 224 236 (12) (0) 235
1,069 961 108 11.3% 903 Total EIPAs 11,978 11,495 483 0 11,613
20.5% 16.1% 4.4% 27.4% 17.7% Supply Expense % of Net Revenue 17.7% 16.1% 1.5% 9.5% 16.2%
20.7% 16.2% 4.4% 27.3% 17.9% Supply Expense % of Net Patient Revenue 17.8% 16.3% 1.5% 9.3% 16.3%
2,028 1,939 (89) -4.6% 2,035 Supply Expense per EIPA 1,944 1,923 (21) -1.1% 1,795
31,642,688 31,285,345 357,343 1.1% 28,823,943 Gross Inpatient Revenue 378,378,792 357,919,643 20,459,148 5.7% 332,542,255
36,299,418 39,942,036 (3,642,618) -9.1% 37,542,558 Gross Outpatient Revenue 440,187,737 484,559,276 (44,371,539) -9.2% 461,915,518
67,942,106 71,227,381 (3,285,275) -4.6% 66,366,501 Total Gross Revenue 818,566,529 842,478,920 (23,912,391) -2.8% 794,457,773
10,488,688 11,467,584 (978,896) -8.5% 10,253,041 Total Net Patient Revenue 130,780,436 135,658,053 (4,877,616) -3.6% 127,567,684