Page 81 - CombinedTest_Neat
P. 81
Actual Current Period KPI Actual Budget Variance
261,728 Supplies Supplies % Net Rev 10.6% 9.3% -1.25%
478 EIPAs Supplies per EIPA $548 $501 ($46.55)
2,479,838 Net Revenue
6202 RUN DATE: 1/10/2018
Urbana 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
261,728 215,550 (46,177) -21.4% 155,912 Total Supplies 2,280,933 2,493,824 212,891 8.5% 2,167,728
158,337 75,091 (83,246) -110.9% 39,554 Medical Surgical 629,640 785,108 155,468 19.8% 557,386
32,787 52,517 19,731 37.6% 82,039 Drugs 674,845 635,979 (38,866) -6.1% 740,905
- - - 0.0% - Implant - Stents 342 - (342) 0.0% 114
- 469 469 100.0% 4,845 Implant - CRM AICD/Pacemakers - 5,673 5,673 100.0% 12,596
- 469 469 100.0% 4,845 Total CRM Implants 342 5,673 5,331 94.0% 12,710
6,182 12,487 6,305 50.5% 1,374 Implant - Orthopedic Joint 64,463 151,477 87,014 57.4% 100,504
14,575 19,098 10,829 23.7% 40,446 Total Non-CRM Implants 334,045 231,046 (102,998) (15,985) -44.6% 250,904 351,408 364,118
Implant - Other
4,524
Urbana Financials 723 - 11 38 (723) -2426.3% - - - 41 Physical Plant/Maintenance 1,453 130 460 - (1,114) -980.3% 24,003
34.3%
41,820
382,523
31,585
20,757
398,508
-4.2%
Implant Total
32,054
398,850
-2.7%
20,757
35.2%
11,297
46,665
388,196
(10,653)
-162.1%
238
(17)
224
28
Dietary
-83.2%
(108)
2,063
Blood
1,760
24,960
303
14.7%
-4.5%
26,074
1,760
Endomechanical
-
0.0%
(1,453)
0.0%
26.3%
11.1%
104,804
142,138
10,073
115,747
37,334
1,258
11,331
7,452
Other Non-Medical
-22.0%
50,910
52,472
IV and IV Sets
3.0%
1,562
46,477
4,176
4,337
5,292
(954)
19,937
41,401
4,894
-
67.5%
4,894
-
100.0%
61,338
314,143
8.0%
25,967
Laboratory
25,079
1.3%
25,620
347
308,128
25,309
289,065
960
Radiology
4,966
(4,506)
2,769
(922)
39,593
42,099
2,979
3,160
18
3,178
0.6%
-2.9%
(1,131)
40,723
Office
374
(2,220)
6,514
729
-
66.1%
9,065
73.2%
9,547
20.0%
986
Suture
721
264
2,380
11,927
20,701
1,083
53.3%
1,711
Instruments
118.2%
9,678
(312)
0.0%
-
-
-
-
0.0%
94
Minor Equipment Medical
-
-
-
2,504
Linen & Laundry
94.2%
-
154
2,659
220
1,308
220
-
100.0%
1,871 1,103 2,023 -123.8% 930 Minor Equipment Non-Medical 15,559 13,339 11,023 -16.6% 16,418
9,959
(1,035)
592
1.1%
836
Freight
10,045
9,932
113
387 1,244 857 68.9% 1,579 Housekeeping & Laundry 18,391 14,977 (3,414) -22.8% 16,367
- 19 19 100.0% - Contrast Media - 227 227 100.0% 114
3,275 1,734 (1,540) -88.8% 308 Gases, Medical 29,115 20,982 (8,133) -38.8% 20,269
212 236 23 10.0% 541 Forms 5,112 2,674 (2,438) -91.2% 4,123
- - - 0.0% - Pack & Gowns 104 - (104) 0.0% -
(387) 168 554 330.8% (51,017) Inventory Variance (3,551) 2,012 5,563 276.5% (48,509)
(2,968) (3,770) (801) 21.3% (3,482) Premier Incentive (40,752) (45,238) (4,485) 9.9% (42,542)
(443) (359) 83 -23.1% (4,536) Rebates & Incentives (13,471) (4,314) 9,157 -212.3% (26,689)
(41) (57) (16) 28.0% (63) Purchase Discounts (390) (684) (294) 43.0% (618)
102 82 20 24.2% 71 Total Admissions 994 939 55 5.8% 862
325 283 42 14.9% 221 Total Patient Days 3,244 3,213 31 1.0% 3,111
4 9 (5) -55.7% - Total IP Surgeries 23 87 (64) -73.6% 21
43 37 6 16.6% 52 Total OP Surgeries 393 472 (79) -16.7% 463
47 46 1 2.4% 52 Total Surgeries 416 559 (143) -25.6% 484
478 430 48 11.2% 411 Total EIPAs 4,843 5,185 (342) -6.6% 5,247
10.5% 9.2% 1.3% 13.7% 0 Supply Expense % of Net Revenue 8.7% 8.9% -0.2% -2.0% 8.1%
10.6% 9.3% 1.3% 14.0% 0 Supply Expense % of Net Patient Revenue 8.7% 8.9% -0.2% -1.9% 8.2%
547 501 (46) -9.2% 379 Supply Expense per EIPA 471 481 10 0 413
1,892,753 1,750,002 142,751 8.2% 1,473,191 Gross Inpatient Revenue 21,526,787 20,123,116 1,403,671 0 16,753,542
6,978,520 7,409,872 (431,352) -5.8% 7,054,839 Gross Outpatient Revenue 83,346,059 90,973,705 (7,627,646) (0) 85,227,661
8,871,273 9,159,874 (288,601) -3.2% 8,528,030 Total Gross Revenue 104,872,846 111,096,821 (6,223,974) (0) 101,981,204
2,479,838 2,329,079 150,758 6.5% 2,221,166 Total Net Patient Revenue 26,103,444 27,992,378 (1,888,934) (0) 26,505,237
