Page 69 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
3,188,797 Supplies Supplies % Net Rev 14.0% 16.4% 2.36%
2,886 EIPAs Supplies per EIPA $1,105 1,333 $228.08
22,706,519 Net Revenue

60 - Lorain RUN DATE: 1/10/2018
Lorain 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
Actual Budget Variance Var % PY Actual Budget Variance Var %

3,188,797 3,881,649 692,853 17.80% 3,109,618 Total Supplies 40,654,260 43,447,915 2,793,655 6.40% 40,476,030
644,998 995,518 350,520 35.20% 775,437 Medical Surgical 10,976,083 11,789,873 813,790 6.90% 10,330,353
883,400 1,048,313 164,913 15.70% 1,027,733 Drugs 11,510,118 12,352,836 842,718 6.80% 11,489,559
40,442 80,434 39,993 49.70% 107,284 Implant - Stents 949,698 994,222 44,524 4.50% 883,055
171,094 190,601 19,507 10.20% 214,744 Implant - CRM AICD/Pacemakers 1,836,018 2,357,320 521,302 22.10% 2,384,326
0 6,650 6,650 100.00% 0 Implant - Open Heart/Heart Valves 3,700 82,194 78,494 95.50% 75,800
211,536 277,686 66,150 23.80% 322,029 Total CRM Implants 2,789,416 3,433,735 644,319 18.80% 3,343,181
199,410 123,094 (76,316) (62.00%) 62,826 Implant - Spinal 1,421,395 1,519,386 97,991 6.40% 1,369,560
288,886 189,873 (99,013) (52.10%) 181,530 Implant - Orthopedic Joint 2,684,241 2,338,124 (346,117) (14.80%) 2,693,331
283,472 276,863 (6,609) (2.40%) 309,882 Implant - Other 3,483,335 3,410,895 (72,440) (2.10%) 3,080,617
771,768 589,830 (181,938) (30.80%) 554,238 Total Non-CRM Implants 7,588,970 7,268,405 (320,565) (4.40%) 7,143,508
3.00%
983,304 867,516 (115,789) (13.30%) 876,267 Implant Total 10,378,386 10,702,140 323,754 14.40% 10,486,689
Lorain Financials 110,774 101,200 (10,085) (1753.90%) 14,666 Other Non-Medical 1,083,356 1,248,294 (302,526) (678.70%) 1,113,726
123,571
166,697 Dietary
1,385,715
1,262,144
25,363
22.40%
8.90%
1,453,653
88,055
113,418
706,990
605,472
59,641 Blood
25.10%
14,377
57,236
101,519
42,860
678,932
(19.40%)
20,444
8,307 Endomechanical
10,359
119,583
(97.40%)
152,943
128,043
(24,899)
236,459
(11.00%)
14.30%
334,638
34,667
4,964
371,585
(36,947)
29,704
13.20%
95,780 IV and IV Sets
(9.50%)
(9,573)
164,938
234,444
(54,699)
(13.10%)
472,006
(2.40%)
17,250 Physical Plant/Maintenance
(710)
417,307
30,729
30,020
1,133,334
(24,103)
74,182
85,204 Laboratory
98,285
1,219,290
(33.00%)
(32.50%)
916,764
9.30%
15.70%
81,866
11,173
57,842 Chemistry Supplies
794,881
876,747
71,074
59,900
932,483
9,266
1,785
1,190
0 Radiology
(8,076)
96
(1,688)
2,311
36,607
178,372
554,123
47,502 Office
637,249
732,496
164,780
81.80%
201,387
24.40%
457,746
64,282 Minor Equipment Non-Medical
(5.60%)
377,514
(149.30%)
(43,390)
72,445
(21,249)
398,763
29,054
(20.40%)
(21.50%)
141,353
136,762
9,442
11,372
10,372 Suture
(1,930)
(25,015)
116,338
103,937
190,534
45,925
(33.40%)
246,751
184,939
(61,813)
2,908 Minor Equipment Medical
13,394
(242.90%)
(32,532)
78.50%
746 Linen & Laundry
85.70%
1,368
196
18,761
23,902
1,171
20,269
5,141
19,310
319,433
313,758
4.40%
13,790
299,968
5,433
24,300 Freight
28.10%
13,878
47,156
(0.40%)
287,912
16.20%
18,561
18,638
244,710
30,454 Housekeeping & Laundry
(77)
291,867
3.30%
18,463
(795)
7,524
227,774
21,856 Contrast Media
220,250
19,258 10,486 (93,452) (891.20%) 18,162 Instruments 244,532 126,781 (117,751) (92.90%) 149,830
(4.30%)
214,165
7,017 7,689 672 8.70% 10,644 Gases, Medical 116,577 94,107 (22,471) (23.90%) 92,541
5,701 28,410 22,709 79.90% 12,569 Forms 54,701 95,903 41,201 43.00% 86,471
1,188 26,099 24,911 95.40% 1,577 Fuel (aircraft & auto) 36,516 38,850 2,334 6.00% 32,029
4,437 94,065 89,628 95.30% 4,500 Uniforms 4,896 107,313 102,417 95.40% 20,486
0 434 434 100.00% 713 Film, Radiographic 4,627 5,370 744 13.80% 8,259
20,487 33,110 12,624 38.10% 40,369 Radiopharmaceuticals 179,457 409,267 229,810 56.20% 566,937
1,516 2,121 605 28.50% 1,814 Pack & Gowns 18,312 26,149 7,837 30.00% 22,857
0 35 35 100.00% 0 Anesthesia 934 426 (508) (119.20%) 414
463 3,658 3,195 87.30% 3,750 Dietary Utensils Disposable 33,740 54,556 20,816 38.20% 52,880
0 0 0 0.00% 0 Dept Transfers 0 0 0 200.00% 0
(116,616) 1,599 118,215 7392.60% (259,824) Inventory Variance (164,097) 27,694 191,790 692.50% (287,988)
(32,590) (30,034) 2,556 (8.50%) (38,806) Premier Incentive (447,410) (496,653) (49,243) 9.90% (474,127)
(17,014) (6,787) 10,228 (150.70%) (69,320) Rebates & Incentives (332,336) (113,161) 219,175 (193.70%) (221,182)
(2,287) (3,815) (1,528) 40.00% (3,775) Purchase Discounts (42,779) (57,812) (15,032) 26.00% (48,975)
1,027 1,121 (94) (8.40%) 1,049 Total Admissions 11,993 13,128 (1,135) (8.60%) 12,830
4,483 5,038 (555) (11.00%) 4,603 Total Patient Days 53,892 61,086 (7,194) (11.80%) 59,019
139 148 (9) (5.80%) 125 Total IP Surgeries 1,516 1,589 (73) (4.60%) 1,492
757 778 (21) (2.70%) 838 Total OP Surgeries 8,610 8,396 214 2.50% 8,047
896 926 (30) (3.20%) 963 Total Surgeries 10,126 9,985 141 1.40% 9,539
68 60 8 13.00% 70 Cath Lab 925 753 172 22.90% 793
2,886 2,913 (27) (0.90%) 2,925 Total EIPAs 33,607 35,948 (2,340) (6.50%) 36,373
12.80% 15.40% -2.70% (17.40%) 13.10% Supply Expense % of Net Revenue 13.60% 14.40% -0.80% (5.70%) 14.20%
14.00% 16.40% -2.40% (14.40%) 14.20% Supply Expense % of Net Patient Revenue 14.60% 15.30% -0.70% (4.60%) 15.20%
1,105 1,333 228 17.10% 1,063 Supply Expense per EIPA 1,210 1,209 -1 -0.10% 1,113
30,334,936 33,869,867 (3,534,932) (10.40%) 29,140,186 Gross Inpatient Revenue 368,739,467 388,184,796 (19,445,329) (5.00%) 355,492,779
54,917,473 54,148,618 768,855 1.40% 52,124,003 Gross Outpatient Revenue 664,555,434 674,733,658 (10,178,224) (1.50%) 652,336,074
85,252,408 88,018,485 (2,766,076) (3.10%) 81,264,189 Total Gross Revenue 1,033,294,901 1,062,918,454 (29,623,553) (2.80%) 1,007,828,853
22,706,519 23,660,087 (953,568) (4.00%) 21,976,071 Total Net Patient Revenue 278,081,267 283,457,203 (5,375,937) (1.90%) 267,011,324