Page 75 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
3,562,313 Supplies Supplies % Net Rev 18.1% 17.0% -1.14%
2,344 EIPAs Supplies per EIPA $1,520 $1,572 $52.24
19,636,751 Net Revenue

6205 RUN DATE: 1/10/2018
Springfield Regional Medical Center CH 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
3,562,313 3,377,926 (184,386) -5.5% 2,678,896 Total Supplies 40,253,109 39,430,348 (822,760) -2.1% 39,716,763
1,311,432 1,304,076 (7,356) -0.6% 1,222,886 Medical Surgical 14,718,536 14,509,554 (208,982) -1.4% 14,294,942
784,221 740,429 (43,791) -5.9% 639,780 Drugs 9,651,672 9,074,044 (577,628) -6.4% 9,519,902
59,975 105,711 45,736 43.3% 97,862 Implant - Stents 1,389,760 1,295,349 (94,411) -7.3% 1,354,907
362,559 241,461 (121,098) -50.2% 274,718 Implant - CRM AICD/Pacemakers 3,183,504 2,967,831 (215,673) -7.3% 3,483,079
23,421 22,141 (1,280) -5.8% 20,193 Implant - Open Heart/Heart Valves 269,321 271,125 1,804 0.7% 300,919
445,955 369,313 (76,642) -20.8% 392,773 Total CRM Implants 4,842,585 4,534,304 (308,281) -6.8% 5,138,905
14,935 11,053 (3,882) -35.1% 29,870 Implant - Spinal 105,366 135,464 30,098 22.2% 220,335
Springfield Financials
55,953 53,537 (2,416) -4.5% 59,452 Implant - Orthopedic Joint 442,608 657,992 215,384 32.7% 737,805
241,392 136,844 (104,549) -76.4% 193,098 Implant - Other 2,481,507 1,676,378 (805,130) -48.0% 2,187,858
312,280 201,433 (110,847) -55.0% 282,420 Total Non-CRM Implants 3,029,481 2,469,833 (559,648) -22.7% 3,145,998
758,235 570,747 (187,488) -32.8% 675,192 Implant Total 7,872,066 7,004,138 (867,928) -12.4% 8,284,903
83,466 89,861 6,394 7.1% 102,291 Dietary 1,120,154 1,103,405 (16,749) -1.5% 1,436,601
96,659 78,127 (18,532) -23.7% 79,290 Blood 1,009,297 960,129 (49,168) -5.1% 1,018,244
27,810 27,109 (701) -2.6% 39,745 Endomechanical 300,194 331,954 31,761 9.6% 419,071
69,537 102,026 32,488 31.8% 69,750 Other Non-Medical 932,943 1,185,997 253,054 21.3% 1,565,661
76,682 65,444 (11,239) -17.2% 58,413 IV and IV Sets 840,613 801,375 (39,239) -4.9% 733,450
930 55,519 54,589 98.3% 4,334 Physical Plant/Maintenance 364,085 647,970 283,885 43.8% 78,485
164,077 165,675 1,598 1.0% 165,903 Laboratory 2,135,863 2,029,179 (106,684) -5.3% 1,925,654
32,080 13,364 (18,716) -140.1% 8,422 Radiology 168,127 163,641 (4,486) -2.7% 162,713
14,550 18,270 3,720 20.4% 17,189 Office 187,416 220,130 32,714 14.9% 221,733
42,018 91,652 49,634 54.2% 37,691 Minor Equipment Non-Medical 562,294 1,099,947 537,653 48.9% 343,342
29,421 15,381 (14,040) -91.3% 15,407 Suture 213,687 188,342 (25,345) -13.5% 190,456
54,566 68,084 13,518 19.9% 39,071 Instruments 589,949 448,486 (141,462) -31.5% 330,721
12,075 6,953 (5,122) -73.7% 12,892 Minor Equipment Medical 95,373 82,364 (13,009) -15.8% 52,254
- 491 491 100.0% 1,022 Linen & Laundry 2,976 6,008 3,032 50.5% 4,216
11,408 27,299 15,891 58.2% 19,877 Freight 277,579 317,563 39,984 12.6% 292,904
12,627 14,837 2,210 14.9% 16,954 Housekeeping & Laundry 208,313 180,739 (27,574) -15.3% 181,115
66 138 72 52.2% 131 Contrast Media 3,403 1,694 (1,709) -100.9% 1,356
15,358 6,303 (9,056) -143.7% 3,982 Gases, Medical 144,307 77,177 (67,130) -87.0% 63,755
1,881 2,952 1,072 36.3% 5,660 Forms 36,101 35,551 (550) -1.5% 37,732
- - - 0.0% - Fuel (aircraft & auto) 14 - (14) 0.0% -
417 1,400 983 70.2% - Uniforms 968 18,748 17,780 94.8% 14,005
3,356 2,964 (391) -13.2% 1,666 Dept Transfers 33,778 36,300 2,522 6.9% 32,384
22,035 (5,138) (27,173) 528.8% (460,714) Inventory Variance (60,874) (61,658) (784) 1.3% (413,152)
(41,061) (52,146) (11,085) 21.3% (48,165) Premier Incentive (563,714) (625,758) (62,044) 9.9% (588,473)
(21,288) (28,085) (6,797) 24.2% (48,728) Rebates & Incentives (542,488) (337,024) 205,464 -61.0% (416,226)
(245) (5,804) (5,559) 95.8% (1,045) Purchase Discounts (49,524) (69,648) (20,125) 28.9% (70,984)
1,252 1,195 57 4.8% 1,195 Total Admissions 14,216 14,181 35 0.2% 13,709
5,621 5,034 587 11.7% 4,756 Total Patient Days 60,248 60,854 (606) -1.0% 61,442
179 168 11 6.5% 179 Total IP Surgeries 1,884 1,938 (54) -2.8% 1,951
141 185 (44) -23.7% 182 Total OP Surgeries 1,990 2,132 (142) -6.7% 2,157
320 353 (33) -9.3% 361 Total Surgeries 3,874 4,070 (196) -4.8% 4,108
138 91 47 51.8% 121 Cath Lab 1,589 1,150 439 38.2% 1,191
2,344 2,149 195 9.1% 2,222 Total EIPAs 26,835 26,310 525 2.0% 25,722
17.9% 16.8% 1.1% 6.6% 16.2% Supply Expense % of Net Revenue 17.0% 16.7% 0.3% 1.7% 17.8%
18.1% 17.0% 1.1% 6.7% 16.5% Supply Expense % of Net Patient Revenue 17.3% 17.0% 0.3% 1.6% 18.0%
1,520 1,572 52 3.3% 1,206 Supply Expense per EIPA 1,500 1,499 (1) -0.1% 1,544
48,114,636 49,458,595 (1,343,960) -2.7% 42,652,294 Gross Inpatient Revenue 553,828,040 565,957,241 (12,129,201) -2.1% 519,296,486
41,973,246 39,478,068 2,495,177 6.3% 36,651,826 Gross Outpatient Revenue 491,631,364 484,048,901 7,582,462 1.6% 455,033,660
90,087,881 88,936,663 1,151,218 1.3% 79,304,120 Total Gross Revenue 1,045,459,404 1,050,006,143 (4,546,739) -0.4% 974,330,146
19,636,751 19,863,281 (226,530) -1.1% 16,267,841 Total Net Patient Revenue 233,237,252 232,089,879 1,147,373 0.5% 220,047,810