Page 17 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
1,704,038 Supplies Supplies % Net Rev 14.9% 14.3% -0.62%
1,689 EIPAs Supplies per EIPA $1,009 $959 ($49.90)
11,419,197 Net Revenue

6302 RUN DATE: 1/10/2018
Mercy Health - Clermont 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

1,704,038 1,521,217 (182,822) -12.0% 1,332,506 Total Supplies 18,226,772 18,076,194 (150,578) -0.8% 16,958,977
420,557 464,510 43,953 9.5% 470,646 Medical Surgical 4,906,831 5,365,212 458,381 8.5% 5,024,140
335,390 386,096 50,707 13.1% 221,974 Drugs 4,622,657 4,710,508 87,851 1.9% 4,359,312
6,262 2,559 (3,703) -144.7% (2,839) Implant - Stents 41,088 30,822 (10,266) -33.3% 36,788
500 1,882 1,382 73.4% 40,400 Implant - CRM AICD/Pacemakers 21,088 22,056 969 4.4% 51,400
6,762 4,441 (2,321) -52.3% 37,561 Total CRM Implants 62,176 52,879 (9,298) -17.6% 88,188
189,067 51,105 (137,962) -270.0% 56,215 Implant - Spinal 1,194,852 604,051 (590,800) -97.8% 604,272
64,690 86,277 21,587 25.0% 71,009 Implant - Orthopedic Joint 729,859 1,067,337 337,478 31.6% 995,178
305,874 175,531 (130,343) -74.3% 293,097 Implant - Other 2,675,029 2,111,160 (563,869) -26.7% 2,258,336
Clermont Financials
559,631 312,913 (246,718) -78.8% 420,321 Total Non-CRM Implants 4,599,739 3,782,549 (817,191) -21.6% 3,857,786
566,393 317,354 (249,039) -78.5% 457,882 Implant Total 4,661,915 3,835,427 (826,488) -21.5% 3,945,974

46,345 46,894 549 1.2% 60,235 Dietary 565,543 550,934 (14,609) -2.7% 535,016
42,154 34,655 (7,499) -21.6% 31,428 Blood 461,372 407,042 (54,330) -13.3% 420,668
17,107 21,893 4,786 21.9% 21,823 Endomechanical 240,475 270,495 30,021 11.1% 269,231
20,879 13,373 (7,506) -56.1% 13,149 Other Non-Medical 154,393 156,949 2,556 1.6% 138,515
58,235 25,968 (32,267) -124.3% 27,369 IV and IV Sets 457,262 305,333 (151,929) -49.8% 277,471
21,263 39,543 18,280 46.2% 22,189 Physical Plant/Maintenance 265,294 463,759 198,465 42.8% 354,433
28,045 27,742 (304) -1.1% 31,919 Laboratory 385,498 324,820 (60,679) -18.7% 328,255
26,614 32,056 5,441 17.0% 19,212 Chemistry Supplies 299,325 375,805 76,480 20.4% 332,340
21,728 31,660 9,933 31.4% 24,561 Radiology 291,811 371,172 79,361 21.4% 280,550
10,405 17,283 6,878 39.8% 15,030 Office 173,520 203,872 30,352 14.9% 204,357
13,531 14,459 928 6.4% 12,901 Minor Equipment Non-Medical 153,993 169,624 15,632 9.2% 145,206
11,397 6,603 (4,794) -72.6% 9,500 Suture 118,937 80,249 (38,688) -48.2% 91,390
17,249 2,902 (14,347) -494.3% 3,836 Instruments 175,889 35,242 (140,647) -399.1% 69,712
22,516 11,356 (11,160) -98.3% 12,204 Minor Equipment Medical 129,932 134,029 4,097 3.1% 82,954
9,705 10,042 337 3.4% 7,205 Linen & Laundry 61,043 117,769 56,725 48.2% 72,685
14,170 9,812 (4,358) -44.4% 5,584 Freight 156,237 115,273 (40,964) -35.5% 114,544
8,686 11,793 3,106 26.3% 9,820 Housekeeping & Laundry 121,875 138,420 16,545 12.0% 132,094
9,454 7,185 (2,269) -31.6% 5,142 Contrast Media 131,577 84,237 (47,340) -56.2% 83,202
2,065 12,135 10,069 83.0% 8,685 Gases, Medical 87,796 142,300 54,504 38.3% 132,078
2,910 4,363 1,453 33.3% 3,516 Forms 36,099 51,508 15,409 29.9% 42,808
7,419 908 (6,512) -717.5% 151 Fuel (aircraft & auto) 9,021 10,643 1,623 15.2% 5,779
- - - 0.0% 192 Uniforms 925 - (925) 0.0% 192
- - - 0.0% 549 Film, Radiographic 1,648 - (1,648) 0.0% 3,298
(3,587) (3,520) 67 -1.9% (129,124) Inventory Variance (74,102) (41,281) 32,820 -79.5% (157,226)
(15,124) (19,653) (4,529) 23.0% (18,009) Premier Incentive (207,637) (230,490) (22,853) 9.9% (220,036)
(11,061) (5,491) 5,570 -101.4% (16,292) Rebates & Incentives (154,593) (64,387) 90,206 -140.1% (101,386)
(405) (705) (300) 42.6% (771) Purchase Discounts (7,768) (8,272) (504) 6.1% (8,579)

658 688 (30) -4.4% 649 Total Admissions 7,339 7,624 (285) -3.7% 7,258
2,496 2,949 (453) -15.4% 2,422 Total Patient Days 27,795 31,202 (3,407) -10.9% 27,701
50 72 (22) -30.4% 60 Total IP Surgeries 686 806 (120) -14.9% 738
631 591 40 6.8% 773 Total OP Surgeries 7,149 7,422 (273) -3.7% 7,813
681 663 18 2.8% 833 Total Surgeries 7,835 8,228 (393) -4.8% 8,551
1,689 1,585 103 6.5% 1,649 Total EIPAs 18,869 18,819 50 0.3% 18,778
14.8% 14.2% 0.6% 4.5% 12.9% Supply Expense % of Net Revenue 14.9% 14.5% 0.4% 2.8% 14.0%
14.9% 14.3% 0.6% 4.4% 13.0% Supply Expense % of Net Patient Revenue 15.1% 14.6% 0.4% 2.9% 14.1%
1,009 959 (50) -5.2% 808 Supply Expense per EIPA 966 961 (5) -0.6% 903
17,746,581 19,747,787 (2,001,206) -10.1% 17,220,015 Gross Inpatient Revenue 204,935,865 217,018,035 (12,082,170) -5.6% 190,566,297
27,800,555 25,759,486 2,041,070 7.9% 26,527,106 Gross Outpatient Revenue 321,960,531 318,657,640 3,302,891 1.0% 302,479,654
45,547,136 45,507,273 39,864 0.1% 43,747,122 Total Gross Revenue 526,896,396 535,675,675 (8,779,279) -1.6% 493,045,951
11,419,197 10,641,088 778,109 7.3% 10,245,539 Total Net Patient Revenue 121,101,337 123,624,370 (2,523,033) -2.0% 119,914,041