Page 124 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
387,494 Supplies Supplies % Net Rev 15.0% 11.8% -3.21%
290 EIPAs Supplies per EIPA $1,336 1,010 ($326.19)
2,582,005 Net Revenue

6780 RUN DATE: 1/10/2018
Mercy Health – Willard 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
387,494 246,602 (140,892) -57.1% 348,212 Total Supplies 3,445,127 3,464,044 18,917 0.5% 3,366,803
56,834 44,552 (12,282) -27.6% 102,267 Medical Surgical 504,661 623,759 119,098 19.1% 522,284
144,707 95,970 (48,737) -50.8% 163,361 Drugs 1,538,405 1,441,327 (97,079) -6.7% 1,537,145
9,599 7,330 (2,269) -31.0% 6,838 Implant - CRM AICD/Pacemakers 80,325 80,073 (251) -0.3% 117,160
9,599 7,330 (2,269) -31.0% 6,838 Total CRM Implants 80,325 80,073 (251) -0.3% 117,160
41,100 25,466 (15,634) -61.4% 40,812 Implant - Orthopedic Joint 188,974 297,019 108,045 36.4% 275,445
15,120 3,676 (11,444) -311.3% 13,671 Implant - Other 114,259 43,137 (71,122) -164.9% 64,019
56,220 29,142 (27,078) (29,347) 1,647 -92.9% 54,483 Total Non-CRM Implants 303,233 340,156 36,923 10.9% 339,464 456,624 159,274
Willard Financials 18,639 25,281 (2,671) -185.0% 15,073 Minor Equipment Non-Medical 193,108 322,356 (95,262) -97.4% 312,231 57,886

383,558
65,820

-80.5%
8.7%
420,229

Implant Total

36,472
36,671
61,321

9,188

Dietary
7,541
155,776
13,372

8.6%

17.9%
8,681
142,404

3,311
32,586
1,980
Blood
23,685
56,271
2,945
42.1%
40.2%
1,331

893

244
651
-8.4%
10,405
72.9%
11,278

10,793
Endomechanical
242
(873)
5,467
Other Non-Medical
85,597
20.9%
1,141
54,229
4,104

36.6%
4,326

81,522

31,368

42,819

5,917
2,879
(2,650)
-6.6%
3,246
-82.3%
IV and IV Sets
40,169

31,481

(12,099)

6,541
90,104

Physical Plant/Maintenance

97,846

-7.6%

-110.3%

53,161
(27,880)

(24,646)
Laboratory
26,534

347,003

Chemistry Supplies
5,360
13,728

-
3,491

605
1,178
10,237
25.4%

573

48.6%

2,054
-286.8%
143
3,060

551
376
Radiology
2,678
-30.4%
(409)

(624)
47,621
Office

3,000
3,378
13,340

28.0%
38,732
11.2%
378

2,856

34,281

29,737

2,299

82.5%
1,897
15,920

-1.2%
402
(344)
29,392
2,230

327
8,099
7,632
11,034
5.8%
467
Suture
695
368
53.0%

8.8%
24,340
Instruments
6,265

730
59.3%

39,131
(1,592)

-3.2%
49,675

2.6%
4,467

3,758

97
51,267

-47.5%
1,097

1,023
-15.8%

(521)
1,619

Freight
18,486
21,669
(2,953)

18,716

2,256

2,587
4,181

3,748
37,048

Housekeeping & Laundry
41,230
331
36,350
10.1%
12.8%

3,662 1,792 1,062 100.0% 917 Minor Equipment Medical 19,044 20,880 1,836 -132.9% 552
(249)

Contrast Media

16
188
-
437
-

16

2,486 1,202 (1,284) -106.8% 1,237 Gases, Medical 17,666 20,429 2,763 13.5% 17,942
279 412 133 32.3% 262 Forms 4,072 6,473 2,401 37.1% 4,531
414 246 (168) -68.4% 332 Fuel (aircraft & auto) 5,051 4,176 (874) -20.9% 4,201
- 39 39 100.0% 70 Uniforms 111 659 549 83.2% 387
- (6) (6) 100.0% - Film, Radiographic 357 (105) (462) 438.8% (52)
- 17 17 100.0% - Dietary Utensils Disposable - 287 287 100.0% 141
- (4) (4) 100.0% - Dept Transfers (42) (73) (31) 42.0% (36)
17,283 331 (16,952) -5124.1% (52,853) Inventory Variance 27,357 5,623 (21,734) -386.5% (46,583)
(2,896) (2,597) 299 -11.5% (3,412) Premier Incentive (39,758) (44,134) (4,376) 9.9% (41,682)
(2,363) (848) 1,515 -178.6% (6,612) Rebates & Incentives (32,905) (13,744) 19,160 -139.4% (23,410)
(26) (51) (25) 48.6% (103) Purchase Discounts (861) (866) (4) 0.5% (947)
52 48 4 7.4% 45 Total Admissions 540 576 (36) -6.3% 574
238 206 32 15.6% 243 Total Patient Days 2,224 2,557 (333) -13.0% 2,593
10 10 - -1.1% 11 Total IP Surgeries 60 123 (63) -51.2% 119
64 67 (3) -4.3% 83 Total OP Surgeries 735 813 (78) -9.6% 803
74 77 (3) -3.8% 94 Total Surgeries 795 936 (141) (0) 922
290 244 46 18.9% 176 Total EIPAs 3,152 2,763 389 0 2,628
14.6% 11.4% 3.2% 28.1% 15.6% Supply Expense % of Net Revenue 12.2% 12.6% -0.4% -3.2% 12.7%
15.0% 11.8% 3.2% 27.5% 16.3% Supply Expense % of Net Patient Revenue 12.6% 13.1% -0.4% -3.3% 13.3%
1,335 1,010 (325) -32.2% 1,977 Supply Expense per EIPA 1,093 1,254 161 12.8% 1,281
1,051,825 1,100,702 (48,877) -4.4% 1,457,314 Gross Inpatient Revenue 11,453,607 14,697,426 (3,243,819) -22.1% 14,377,875
4,817,347 4,447,559 369,788 8.3% 4,245,295 Gross Outpatient Revenue 55,401,338 55,732,642 (331,304) -0.6% 51,440,007
5,869,173 5,548,261 320,912 5.8% 5,702,609 Total Gross Revenue 66,854,944 70,430,068 (3,575,124) -5.1% 65,817,882
2,582,005 2,094,272 487,733 23.3% 2,135,765 Total Net Patient Revenue 27,286,186 26,527,738 758,447 2.9% 25,305,410