Page 37 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
2,692,151 Supplies Supplies % Net Rev 13.4% 17.5% 4.10%
2,211 EIPAs Supplies per EIPA $1,218 1,650 $432.38
20,087,741 Net Revenue

6321 RUN DATE: 1/10/2018
Mercy Health - West 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,692,151 3,573,252 881,101 24.7% 2,175,220 Total Supplies 41,056,102 41,852,458 796,356 1.9% 37,467,771
1,379,149 1,251,569 (127,580) -10.2% 1,070,909 Medical Surgical 15,126,282 14,624,101 (502,182) -3.4% 13,783,741
288,878 756,478 467,600 61.8% 603,359 Drugs 8,315,263 8,770,512 455,250 5.2% 7,443,129
61,291 75,899 14,608 19.2% 83,924 Implant - Stents 979,229 881,641 (97,589) -11.1% 905,119
122,100 177,006 54,906 31.0% 74,328 Implant - CRM AICD/Pacemakers 1,814,526 2,051,637 237,111 11.6% 1,504,353
- 18,122 18,122 100.0% 13,590 Implant - Open Heart/Heart Valves 136,420 210,241 73,821 35.1% 198,660
183,391 271,027 87,636 32.3% 171,842 Total CRM Implants 2,930,175 3,143,519 213,344 6.8% 2,608,132
19,692 31,951 12,259 38.4% 57,011 Implant - Spinal 488,229 383,099 (105,130) -27.4% 295,377
268,680 335,201 66,521 19.8% 303,290 Implant - Orthopedic Joint 3,631,290 4,030,659 399,369 9.9% 4,022,928
Mercy West Financials
325,900 269,313 (56,587) -21.0% 413,114 Implant - Other 3,745,529 3,227,392 (518,137) -16.1% 3,387,837
614,272 636,465 22,193 3.5% 773,415 Total Non-CRM Implants 7,865,048 7,641,150 (223,898) -2.9% 7,706,142
797,663 907,492 109,829 12.1% 945,257 Implant Total 10,795,223 10,784,669 (10,554) -0.1% 10,314,275
92,915 111,530 18,615 16.7% 144,320 Dietary 1,099,491 1,295,776 196,285 15.1% 1,206,926
72,689 83,974 11,285 13.4% 83,356 Blood 1,089,047 974,459 (114,588) -11.8% 970,700
30,410 39,648 9,238 23.3% 36,522 Endomechanical 401,527 473,063 71,536 15.1% 400,618
83,922 72,035 (11,887) -16.5% 80,844 Other Non-Medical 684,568 836,915 152,347 18.2% 757,050
77,857 61,255 (16,602) -27.1% 77,683 IV and IV Sets 936,577 711,530 (225,046) -31.6% 779,748
1,688 49,044 47,357 96.6% (23,075) Physical Plant/Maintenance 171,866 568,985 397,119 69.8% 424,186
25,350 21,936 (3,414) -15.6% 28,608 Laboratory 340,877 256,714 (84,163) -32.8% 233,415
15,238 12,497 (2,741) -21.9% 11,096 Chemistry Supplies 155,818 144,984 (10,834) -7.5% 162,471
44,776 48,743 3,967 8.1% 30,810 Radiology 496,413 565,489 69,076 12.2% 483,390
21,163 28,957 7,794 26.9% 16,816 Office 314,635 337,772 23,137 6.8% 303,314
18,856 28,615 9,759 34.1% 25,124 Minor Equipment Non-Medical 207,384 333,235 125,850 37.8% 297,861
26,608 30,278 3,671 12.1% 31,804 Suture 321,696 360,378 38,682 10.7% 320,403
48,234 20,815 (27,419) -131.7% 140,605 Instruments 453,258 246,912 (206,346) -83.6% 353,568
28,014 19,836 (8,178) -41.2% 11,050 Minor Equipment Medical 256,975 233,403 (23,572) -10.1% 163,848
- 587 587 100.0% - Linen & Laundry - 6,826 6,826 100.0% 3,358
37,296 29,263 (8,033) -27.5% 27,945 Freight 375,412 339,992 (35,421) -10.4% 301,073
23,418 28,490 5,072 17.8% 25,081 Housekeeping & Laundry 328,183 330,669 2,486 0.8% 301,373
40,779 24,727 (16,052) -64.9% 19,000 Contrast Media 327,146 286,929 (40,217) -14.0% 269,288
1,229 7,838 6,610 84.3% 6,700 Gases, Medical 114,426 92,377 (22,048) -23.9% 75,499
9,505 8,400 (1,105) -13.2% 4,658 Forms 84,177 97,532 13,356 13.7% 90,950
507 370 (137) -36.9% 615 Fuel (aircraft & auto) 5,611 4,298 (1,314) -30.6% 5,040
- 777 777 100.0% - Uniforms 5,412 9,132 3,720 40.7% 5,535
- 281 281 100.0% - Film, Radiographic 4,806 3,262 (1,544) -47.3% 2,057
1,673 - (1,673) 0.0% - Anesthesia 2,260 - (2,260) 0.0% -
(419,995) (11,202) 408,794 -3649.4% (1,135,795) Inventory Variance (443,422) (129,955) 313,467 -241.2% (1,192,702)
(34,482) (45,295) (10,813) 23.9% (39,482) Premier Incentive (473,384) (525,486) (52,102) 9.9% (482,386)
(20,690) (13,419) 7,270 -54.2% (47,458) Rebates & Incentives (427,841) (155,685) 272,155 -174.8% (278,514)
(499) (2,270) (1,771) 78.0% (1,132) Purchase Discounts (13,586) (26,331) (12,745) 48.4% (31,441)
1,134 1,231 (97) -7.9% 1,035 Total Admissions 12,814 13,690 (876) -6.4% 12,041
4,803 5,071 (268) -5.3% 4,625 Total Patient Days 53,757 58,618 (4,861) -8.3% 51,970
163 214 (51) -24.0% 201 Total IP Surgeries 2,151 2,513 (362) -14.4% 2,254
550 484 66 13.6% 378 Total OP Surgeries 4,997 5,516 (519) -9.4% 4,346
713 699 14 2.1% 579 Total Surgeries 7,148 8,029 (881) (0) 6,600
30 52 (22) -42.5% 49 Cath Lab 664 611 53 0 595
2,211 2,165 46 2.1% 1,916 Total EIPAs 25,040 25,115 (75) (0) 22,928
13.2% 17.2% -4.0% -23.4% 11.7% Supply Expense % of Net Revenue 17.0% 17.4% -0.4% -2.1% 16.7%
13.4% 17.5% -4.1% -23.4% 11.9% Supply Expense % of Net Patient Revenue 17.3% 17.7% -0.4% -2.3% 17.0%
1,218 1,650 433 26.2% 1,135 Supply Expense per EIPA 1,640 1,666 27 1.6% 1,634
44,438,386 50,871,835 (6,433,449) -12.6% 43,736,802 Gross Inpatient Revenue 520,569,269 570,118,039 (49,548,770) -8.7% 481,059,115
42,196,209 38,594,224 3,601,985 9.3% 37,239,084 Gross Outpatient Revenue 496,687,351 475,829,587 20,857,764 4.4% 434,965,848
86,634,595 89,466,058 (2,831,464) -3.2% 80,975,886 Total Gross Revenue 1,017,256,620 1,045,947,626 (28,691,006) -2.7% 916,024,963
20,087,741 20,414,087 (326,346) -1.6% 18,206,080 Total Net Patient Revenue 237,169,931 236,330,218 839,713 0.4% 219,998,150