Page 30 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
6,009,695 Supplies Supplies % Net Rev 24.3% 20.1% -4.17%
1,857 EIPAs Supplies per EIPA $3,236 $2,839 ($397.24)
24,757,714 Net Revenue

6319 RUN DATE: 1/10/2018
The Jewish Hospital - Mercy Health 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
6,009,695 4,514,029 (1,495,666) -33.1% 4,364,790 Total Supplies 58,157,191 52,006,232 (6,150,958) -11.8% 49,594,982
1,751,919 1,299,340 (452,579) -34.8% 1,006,568 Medical Surgical 14,943,190 14,673,143 (270,046) -1.8% 12,759,033
1,593,233 1,340,771 (252,463) -18.8% 1,372,674 Drugs 16,753,722 15,650,395 (1,103,327) -7.0% 14,318,208
40,925 41,956 1,031 2.5% 22,540 Implant - Stents 376,774 491,567 114,793 23.4% 419,015
99,281 112,426 13,145 11.7% 54,142 Implant - CRM AICD/Pacemakers 1,134,352 1,320,134 185,781 14.1% 1,379,622
17,200 14,987 (2,213) -14.8% 3,600 Implant - Open Heart/Heart Valves 180,511 171,515 (8,996) -5.2% 180,590
157,406 169,368 11,963 7.1% 80,282 Total CRM Implants 1,691,637 1,983,215 291,579 14.7% 1,979,228
242,754 83,793 (158,961) -189.7% 135,404 Implant - Spinal 1,584,841 958,967 (625,874) -65.3% 1,162,418
554,358 403,382 (150,977) -37.4% 514,915 Implant - Orthopedic Joint 5,445,743 4,616,479 (829,264) -18.0% 4,748,233
975,225 441,894 (533,331) -120.7% 709,438 Implant - Other 7,296,432 5,070,522 (2,225,909) -43.9% 5,635,808
1,772,337 929,069 (843,268) -90.8% 1,359,757 Total Non-CRM Implants 14,327,016 10,645,968 (3,681,048) -34.6% 11,546,459
1,929,742 1,098,437 (831,305) -75.7% 1,440,039 Implant Total 16,018,653 12,629,184 (3,389,469) -26.8% 13,525,687
Financials 206,611 161,708 66,786 (44,903) (21,168) (26,254) (13,825) 39,795 -27.8% 178,442 Physical Plant/Maintenance 3,101,904 1,061,725 1,146,249 1,026,671 258,552 1,901,046 764,331 (1,200,858) -63.2% 2,170,836
1,093,523

1,091,615

111,947
0.2%
92,729
Dietary
150
92,879

-0.2%
992,907
(1,908)

Blood
Endomechanical
-38.9%
9.7%

892,021
60,305
151,224
6,481

(297,394)

78
25,369
0.4%
246,522

-4.9%
(12,030)
Other Non-Medical
279,272
20,967

21,045

771,065
(375,184)
737,654
-48.7%
72,383
-32.0%
IV and IV Sets

66,064

87,232
40.5%
40,227
98.9%

431

191,640
(1,838)
281,265
472,904

315,599
100,019
98,035
840,861
-22.1%
924,818

71,781
(185,810)
-36.6%
Laboratory

49,355
504,645

33,551
Chemistry Supplies
-28.0%
5.8%
580,223

63,180
87,709

546,673
Radiology
(2,108)
6,573

77,274
8,682

306,332

44.1%
9.0%
15,800

30,177
Office

14.7%

638,136
93,654

544,482

-38.6%
73,086

54,474

75,481
52,242

Suture
16,080 28,762 (21,007) 12,682 -32.1% 10,811 Minor Equipment Non-Medical 108,446 336,509 (31,172) -40.3% 321,994 785,804 487,211 93,536
(13,802)

42,786
484
1.1%
42,302
-2.8%

489,759
503,561

58,564 16,006 (42,558) -265.9% 34,945 Instruments 500,348 183,357 (316,991) -172.9% 291,513
21,420 27,121 5,701 21.0% 56,902 Minor Equipment Medical 217,266 314,273 97,008 30.9% 272,562
(1,166) 32,888 34,055 103.5% 6,495 Linen & Laundry 204,239 381,100 176,861 46.4% 363,831
(55,634) 29,153 84,786 290.8% 13,567 Freight 254,571 343,175 88,604 25.8% 309,369
28,087 28,249 162 0.6% 34,608 Housekeeping & Laundry 365,427 331,811 (33,616) -10.1% 390,792
1,156 408 (748) -183.4% 1,348 Contrast Media 8,998 4,796 (4,202) -87.6% 6,615
7,981 8,835 853 9.7% 13,180 Gases, Medical 117,690 103,593 (14,097) -13.6% 106,486
5,072 6,349 1,278 20.1% 4,648 Forms 71,136 74,406 3,270 4.4% 69,773
6,532 6,780 248 3.7% 1,724 Fuel (aircraft & auto) 26,500 79,703 53,204 66.8% 50,124
(19) 867 886 102.2% - Uniforms 11,359 10,197 (1,162) -11.4% 6,871
- 150 150 100.0% - Film, Radiographic 122 1,761 1,639 93.1% 1,205
849 504 (344) -68.3% 411 Anesthesia 13,592 5,770 (7,822) -135.6% 3,710
(21,711) (2,473) 19,238 -778.0% (379,447) Inventory Variance (120,690) (29,070) 91,620 -315.2% (381,241)
(50,517) (65,486) (14,969) 22.9% (60,153) Premier Incentive (693,527) (769,859) (76,331) 9.9% (734,941)
(37,019) (13,004) 24,015 -184.7% (57,457) Rebates & Incentives (487,634) (152,873) 334,761 -219.0% (228,666)
(830) (3,307) (2,477) 74.9% (2,455) Purchase Discounts (27,153) (38,878) (11,725) 30.2% (42,248)
1,086 968 118 12.2% 1,066 Total Admissions 11,977 11,082 895 8.1% 10,832
4,528 4,008 520 13.0% 4,141 Total Patient Days 52,904 46,981 5,923 12.6% 46,519
290 269 21 7.7% 275 Total IP Surgeries 3,000 2,926 74 2.5% 2,736
419 364 56 15.3% 493 Total OP Surgeries 4,408 4,496 (88) -2.0% 4,337
709 633 76 12.1% 768 Total Surgeries 7,408 7,422 (14) (0) 7,073
37 44 (7) -16.4% 44 Cath Lab 496 516 (20) (0) 541
1,857 1,590 267 16.8% 1,880 Total EIPAs 20,481 18,847 1,633 0 19,092
23.9% 19.7% 4.2% 21.1% 19.9% Supply Expense % of Net Revenue 20.6% 19.6% 1.0% 5.2% 19.9%
24.3% 20.1% 4.2% 20.8% 20.1% Supply Expense % of Net Patient Revenue 20.9% 19.9% 1.0% 4.8% 20.2%
3,236 2,839 (397) -14.0% 2,321 Supply Expense per EIPA 2,840 2,759 (80) -2.9% 2,598
53,772,272 50,260,246 3,512,026 7.0% 47,468,369 Gross Inpatient Revenue 614,089,530 569,080,896 45,008,634 7.9% 508,177,278
38,194,183 32,306,568 5,887,615 18.2% 36,266,823 Gross Outpatient Revenue 436,009,077 398,754,693 37,254,384 9.3% 387,490,357
91,966,455 82,566,814 9,399,641 11.4% 83,735,192 Total Gross Revenue 1,050,098,607 967,835,589 82,263,018 8.5% 895,667,636
24,757,714 22,461,333 2,296,382 10.2% 21,707,435 Total Net Patient Revenue 278,508,063 260,944,874 17,563,189 6.7% 245,303,528