Page 63 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
$7,214,488 Supplies Supplies % Net Rev 16.0% 15.3% -0.74%
3,372 EIPAs Supplies per EIPA $2,140 $2,234 $94
$44,967,688 Net Revenue

64 RUN DATE: 1/10/2018
Mercy Health – St. Rita's 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

7,214,488 7,578,878 364,390 4.80% $5,447,292 Total Supplies 88,747,540 89,525,894 778,354 0.90% 81,981,260
2,160,846 2,468,724 307,878 12.50% $2,432,927 Medical Surgical 26,641,388 28,383,059 1,741,672 6.10% 26,970,076
1,479,135 2,320,779 841,645 36.30% $1,923,046 Drugs 27,603,417 27,945,060 341,643 1.20% 25,153,518
92,247 138,594 46,347 33.40% $140,335 Implant - Stents 2,053,300 1,661,762 (391,539) (23.60%) 1,581,639
460,546 273,393 (187,153) (68.50%) $379,801 Implant - CRM AICD/Pacemakers 3,593,615 3,277,974 (315,641) (9.60%) 3,222,013
51,305 13,519 (37,786) (279.50%) $18,727 Implant - Open Heart/Heart Valves 56,305 162,093 105,788 65.30% 229,314
604,098 425,505 (178,593) (42.00%) $538,863 Total CRM Implants 5,703,220 5,101,828 (601,392) (11.80%) 5,032,966
374,476 208,640 (165,836) (79.50%) $183,504 Implant - Spinal 2,735,514 2,501,582 (233,932) (9.40%) 1,991,781
266,264 160,539 (105,724) (65.90%) $185,693 Implant - Orthopedic Joint 2,239,106 1,930,748 (308,358) (16.00%) 2,132,116
732,657 604,164 (128,493) -21.30% $760,621 Implant - Other 7,467,706 7,018,385 (449,321) (6.40%) 6,955,736
1,373,397 973,344 (400,053) -41.10% $1,129,818 Total Non-CRM Implants 12,442,326 11,450,715 (991,611) (8.70%) 11,079,633
(9.60%)
1,977,495 1,398,849 (578,646) (41.40%) $1,668,682 Implant Total 18,145,546 16,552,543 (1,593,003) (16.30%) 16,112,599
Lima Financials 221,220 200,426 0 (164,335) (29.80%) $281,367 Minor Equipment Non-Medical 1,868,978 2,216,567 0 (164,465) -137.80% 1,921,853 0
15.60%
Dietary
205,247
10.80%
$285,387
2,192,667
2,369,410
264,984
173,264
31,982
2,457,651
$70,685
70,564
(26,674)
(37.80%)
849,001
987,088
897,081
(138,086)
Blood
97,238
0.00%
$0
Endomechanical
0.00%
164,465
(70,318)
70,318
-10.40%
Other Non-Medical
347,589
-20,794
15.70%
1,253,599
1,038,797
86,787
(25,837)
$78,926
IV and IV Sets
112,624
(20.70%)
911,705
(214,802)
74,597
1,039,810
Physical Plant/Maintenance
-10.30%
117,967
43,369
$72,675
36.80%
-135,892
1,461,116
1,325,224
(673,493)
7,470,718
(29.00%)
730,510
$683,445
(9.90%)
Laboratory
6,886,685
6,797,224
566,176
-132,463
(10,130) (126.30%)
$5,713
18,150
96,121
228,584
8,020
Radiology
78,806
728,313
$77,534
61,028
58,207
5,441
737,822
7.90%
Office
679,615
8.20%
66,469
994,352
1,181,188
1,180,972
99,505
186,621
18.40%
15.80%
18,268
81,237
$135,145
38,761
Suture
626,587
52,266
4.50%
25.80%
28,119
$56,497
598,469
670,045
13,505
Instruments
(2.80%)
137,516
23,437
65,675
-31,144
3,040
-20,397
$5,189
34,531
40,275
-671.00%
411,821
-2.50%
472,455
-10,388
24,906
12,744
37,650
Linen & Laundry
$31,052
33.80%
422,209
642,273
31.30%
17901
$61,969
(16,072)
(2.60%)
Freight
57,142
601,815
626,201
39,241
$37,136
10,045
46,371
11.60%
27.40%
380,966
26,589 46,871 (90,645) (193.40%) $27,105 Minor Equipment Medical 577,484 561,996 (15,487) -90.20% 262,756
399,086
352,716
36,633
Housekeeping & Laundry
51,407 37,892 -13,515 -35.70% $37,352 Contrast Media 526,204 454,315 (71,888) (15.80%) 485,207
23260 18635 (4625) (24.80%) $16,970 Gases, Medical 242,498 221,734 (20,763) (9.40%) 209,547
15681 15598 -83 -0.50% $29,800 Forms 155,136 171,853 16,717 9.70% 190,755
9773 9624 (149) (1.50%) $9,657 Fuel (aircraft & auto) 129,547 112,189 -17357 -15.50% 114,364
10015 2281 -7734 -339.10% $3,424 Uniforms 32170 24,838 -7,333 -29.50% 89,773
0 100 100 100.00% $0 Film, Radiographic 1,648 1,195 -453 (37.90%) 2,028
60,231 70,597 10,366 14.70% $67,046 Radiopharmaceuticals 836,533 846,470 9,938 1.20% 875,306
18,220 52,227 34,006 65.10% $49,889 Anesthesia 535,002 584,421 49,419 8.50% 589,790
(324455) (320,929) 3,527 -1.10% ($379,678) Dept Transfers (3,761,049) (3,494,951) 266,098 -7.60% (3,540,819)
-81,404 -15,239 66,165 -434.20% ($2,153,009) Inventory Variance -464784 -164708 300076 -1.822 -2114248
-60,456 -84,602 -24,146 28.50% ($71,206) Premier Incentive -829977 -921326 -91349 0.099 -869991
-54,999 -44,106 10893 -24.70% ($94,882) Rebates & Incentives -960,207 -481,188 479019 (99.50%) -668,269
-899 -6,316 (5417) 85.80% ($2,551) Purchase Discounts -45,535 -69,214 -23,679 34.20% -61,540
1698 1790 (92) (5.10%) 1,663 Total Admissions 19,957 20,594 (637) (3.10%) 19,763
6,798 7,430 -632 -8.50% 7,157 Total Patient Days 83,107 84,435 -1328 -1.60% 82,421
252 300 -48 -16.00% 280 Total IP Surgeries 3249 3513 -264 (7.50%) 3,345
1032 1089 -57 -5.20% 1,169 Total OP Surgeries 12761 12451 310 2.50% 12,669
1,284 1,389 -105 -7.60% 1,449 Total Surgeries 16,010 15,964 46 0.30% 16,014
185 144 41 28.80% 144 Cath Lab 1,785 1,580 205 13.00% 1,547
3,372 3,393 -20 -0.60% 3,346 Total EIPAs 39,710 40,559 -849 -2.10% 41,254
14.40% 15.30% -1.00% -6.20% 11.70% Supply Expense % of Net Revenue 15.40% 15.40% 0.00% 0.10% 0
16.00% 16.80% -0.80% -4.60% 12.80% Supply Expense % of Net Patient Revenue 17.10% 16.90% 0.20% 1.00% 0
$2,139 $2,234 $95 4.20% $1,628 Supply Expense per EIPA $2,235 $2,207 -$28 -1.30% $1,987
$88,855,501 $90,854,493 -$1,998,993 -2.20% $78,936,751 Gross Inpatient Revenue $1,026,052,437 $1,033,807,597 -$7,755,159 -0.80% $921,791,363
$87,612,193 $81,371,420 $6,240,773 7.70% $79,872,146 Gross Outpatient Revenue $1,015,562,991 $1,002,295,705 $13,267,286 1.30% $1,002,386,840
$176,467,693 $172,225,913 $4,241,780 2.50% $158,808,897 Total Gross Revenue $2,041,615,428 $2,036,103,301 $5,512,127 0.30% $1,924,178,203
$44,967,688 $45,047,683 -$79,995 -0.20% $42,622,786 Total Net Patient Revenue $519,471,135 $529,410,955 -$9,939,820 -1.90% $506,446,076