Page 87 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
427,731 Supplies Supplies % Net Rev 19.0% 14.8% -4.16%
343 EIPAs Supplies per EIPA $1,247 $844 ($403.03)
2,256,252 Net Revenue

6795 RUN DATE: 1/10/2018
Mercy Health – Defiance 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
427,731 303,971 (123,761) -40.7% 213,563 Total Supplies 3,869,896 3,761,401 (108,494) -2.9% 3,328,459
103,781 76,152 (27,629) -36.3% 21,535 Medical Surgical 1,070,391 934,475 (135,916) -14.5% 863,658
138,299 150,480 12,180 8.1% 120,563 Drugs 1,742,155 1,870,705 128,550 6.9% 1,511,220
912 482 (430) -89.0% 228 Implant - Stents 5,586 5,999 413 6.9% 5,016
912 482 (430) -89.0% 228 Total CRM Implants 5,586 5,999 413 6.9% 5,016
452 536 84 15.6% - Implant - Spinal 1,061 6,674 5,613 84.1% 3,415
-83.4%
26.1%
55,266 30,131 (25,135) (24,160) (49,211) (49,641) -169.2% 32,680 Implant - Orthopedic Joint 277,458 375,397 (44,924) -25.3% 371,252 274,651 649,318 654,334
97,939

222,507
34,469
Defiance Financials 29,986 2,127 9 (2,289) -1318.7% 409 4 Minor Equipment Non-Medical 133,090 100,606 (106,814) (13,107) -406.5% 46,435
38,442

14,282
Implant - Other

177,583

94,161

-109.5%

559,653
44,949

10.5%

Total Non-CRM Implants
58,627
501,026
67,149

45,432

95,073
10.4%
59,041
67,377
506,612
565,653

Implant Total
-109.3%

Dietary
49.5%
1,054
26,390
4,284
-49.7%
1,073
39,498
1,569
21.3%
Blood

84,644

8,350
1,778

69,679

15,962

15.9%
6,572
0.0%
-
3,244
0.0%

-

Endomechanical
(3,244)

-

2,289
-
(2,242)
-9.3%
3,090

(950)

Other Non-Medical
-264.1%
11,198
12,803

849
10,248

IV and IV Sets
65,565

77,405
-29.9%

5,547
5,566

-11.8%
(8,200)

7,232

69,204
(1,667)

4,167
50,000
-

-

35,519
14,481

Physical Plant/Maintenance
4,167
71.0%
100.0%

-

26,276
326

27,940
Laboratory

(27,873)

2,114

Radiology

6,288
118
13,260

(13,142) -11146.7%
(6,278) -66225.2%
119
17,433
1,573

15,860

Office
2,088
9.0%

1,026
(662)
1,426
-46.4%

11,558

-69.6%
-824.6%
19,966
14,795
11,776

(7,951)
8,916
964

(8,191)

4,359

1,742
65

1,232
Suture
5.5%

3.6%
33,286

2,677
1,823
Instruments
31.9%

29,242
24,723

25.7%

8,563
2,099

(14,685)
9,712

494

9,743
290
24,428
785
995

37.0%

-
0.0%

0.0%
302
-
(302)
-

Linen & Laundry
-
302

-
Freight
469

20,291
-19.3%
7,407
1,413

17,013
13,936
18,281
6.4%
1,391

728
40.2%
1,812
1,084
(5,994) 1,807 854 524.1% 645 Minor Equipment Medical 21,236 22,468 (3,278) -150.7% 17,756

21,829

20,438
Housekeeping & Laundry
1,226

9,196 1,050 (8,145) -775.7% 1,804 Contrast Media 48,525 12,629 (35,895) -284.2% 11,060
2,211 402 (1,809) -450.5% (20) Gases, Medical 8,057 4,993 (3,065) -61.4% 304
423 229 (194) -84.5% 209 Forms 2,221 2,825 604 21.4% 2,158
62 143 81 56.5% 64 Fuel (aircraft & auto) 1,317 1,722 405 23.5% 722
- - - 0.0% - Uniforms 111 - (111) 0.0% -
17,867 - (17,867) 0.0% (15,788) Inventory Variance 34,060 - (34,060) 0.0% (3,253)
(2,096) (2,656) (561) 21.1% (2,469) Premier Incentive (28,770) (31,936) (3,166) 9.9% (30,162)
(3,768) (1,191) 2,576 -216.3% (2,526) Rebates & Incentives (36,680) (14,419) 22,261 -154.4% (18,167)
(2) (136) (134) 98.6% (144) Purchase Discounts (2,165) (1,636) 530 -32.4% (1,539)
76 84 (8) -9.8% 87 Total Admissions 1,025 1,064 (39) -3.7% 1,057
208 220 (12) -5.5% 235 Total Patient Days 2,710 2,899 (189) -6.5% 2,842
13 15 (2) -11.1% 13 Total IP Surgeries 170 162 8 5.0% 172
148 173 (25) -14.2% 154 Total OP Surgeries 1,807 2,017 (210) -10.4% 1,931
161 187 (26) -14.0% 167 Total Surgeries 1,977 2,179 (202) (0) 2,103
343 360 (17) -4.8% 311 Total EIPAs 4,434 4,411 23 0 4,203
18.3% 14.8% 3.5% 23.6% 10.0% Supply Expense % of Net Revenue 13.2% 15.0% -1.8% -12.2% 13.5%
19.0% 14.8% 4.2% 28.1% 10.0% Supply Expense % of Net Patient Revenue 13.2% 15.0% -1.8% -11.9% 13.7%
1,248 844 (404) -47.8% 687 Supply Expense per EIPA 873 853 (20) -2.3% 792
1,711,408 1,451,832 259,576 17.9% 1,452,641 Gross Inpatient Revenue 19,098,074 18,282,117 815,957 4.5% 17,108,284
6,008,338 4,751,244 1,257,093 26.5% 3,740,995 Gross Outpatient Revenue 63,515,004 57,473,065 6,041,939 10.5% 50,921,943
7,719,746 6,203,077 1,516,669 24.5% 5,193,637 Total Gross Revenue 82,613,078 75,755,183 6,857,896 9.1% 68,030,227
2,256,252 2,053,410 202,842 9.9% 2,139,562 Total Net Patient Revenue 29,285,196 25,063,399 4,221,797 16.8% 24,371,650