Page 112 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
575,069 Supplies Supplies % Net Rev 8.9% 11.5% 2.57%
779 EIPAs Supplies per EIPA $738 1,005 $266.79
6,442,220 Net Revenue

6770 RUN DATE: 1/10/2018
Mercy Health – Tiffin 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
575,069 736,516 161,447 21.9% 650,027 Total Supplies 9,112,319 9,236,757 124,438 1.3% 8,646,354
148,731 123,403 (25,328) -20.5% 49,015 Medical Surgical 1,194,576 1,731,876 537,300 31.0% 1,274,461
335,694 381,966 46,272 12.1% 566,079 Drugs 5,333,771 4,676,172 (657,600) -14.1% 4,716,386
6,664 424 (6,240) -1470.3% 121 Implant - Stents 28,492 5,137 (23,356) -454.7% 12,568
4,845 17,019 12,174 71.5% - Implant - CRM AICD/Pacemakers 116,808 206,030 89,222 43.3% 161,661
11,509 17,443 5,934 34.0% 121 Total CRM Implants 145,300 211,167 65,866 31.2% 174,229
1,424 - (1,424) 0.0% - Implant - Spinal 3,012 - (3,012) 0.0% 1,815
64,574 52,665 (11,909) -22.6% 97,862 Implant - Orthopedic Joint 702,964 638,526 (64,439) -10.1% 825,199
17,748 13,660 (4,087) -29.9% 8,425 Implant - Other 157,285 166,676 9,391 5.6% 178,191
83,746 66,326 (17,420) -26.3% 106,287 Total Non-CRM Implants 863,262 805,202 (58,060) -7.2% 1,005,206
Tiffin Financials 15,285 21,258 (8,224) -116.5% 36,497 Minor Equipment Non-Medical 129,212 100,917 (28,296) -119.4% 107,703
(11,486)
-13.7%

83,769

Implant Total
106,408
1,008,562
0.8%
7,806
1,179,435

95,255

1,016,368

4,053
16,285
20,338

254,123

240,361

254,779

13,762
5.4%

14,910
19.9%
Dietary
Blood
5,067
3,271
39.2%
8,338
5,661
-28.0%
530
100.0%

10,374

530

515
6,419

(7,664)

Endomechanical

14,082
-
73,505
83,301
6,962

Other Non-Medical
6,734

68,027
15,274

(227)
-3.4%

5,030
18.3%

6,713

IV and IV Sets
77,533
(52,745)

87,937

140,682
-60.0%
7,061

187,231
7,903
15,466
37.2%
240,919

13,355
6.0%
256,385
Physical Plant/Maintenance

(26,393)
535,017
539,385
-65.2%

36,735

Laboratory

-5.2%
68,627
(27,090)
41,537
508,624

1,177
-
0.0%
-

0.0%

-
-

(3,372)
Chemistry Supplies

-
3,372

5,844
45,368
1,641
19,606

51,514
71,120

Radiology
72.4%
4,203
1,042

71.9%

141,069

11.3%
130,022
1,265
138,337

9,943
11,208

Office
6.0%
5,716
8,315
47,745
449

21.5%

60,051
6,112
60,847
4,441
4,889
9.2%

13,102

423
7,008
1,629
(3,267)
8,504

Suture
5,238
(1,206)
9,705

507

-87.2%
7,992
45.2%

2,737
Instruments

(1,274)

98,826

62,917
4,949
15.5%

-181.6%
7,891
32,202
2,859
721.4%
-29.2%
41,617
34,413
Freight
2,656

(16,505)
(9,415)
19,162

473
54,533

17.5%

4,051
4,911
Housekeeping & Laundry
0.8%
4,343
860

59,438
59,911
4,556

1,666
7,224
18.7%
111,049
97,652

22,220 1,462 (14,329) -285.1% 1,070 Minor Equipment Medical 83,464 17,696 15,362 -62.4% 12,740
109,924

12,272
8,890
Contrast Media
11.2%
4,373 1,813 (2,560) -141.2% 6,144 Gases, Medical 29,489 21,975 (7,514) -34.2% 30,499
543 1,378 836 60.6% 1,247 Forms 5,962 17,295 11,333 65.5% 5,446
222 180 (42) -23.4% 164 Fuel (aircraft & auto) 2,663 2,178 (486) -22.3% 2,404
- 67 67 100.0% 207 Uniforms 215 846 632 74.6% 642
- 35 35 100.0% - Film, Radiographic - 443 443 100.0% 208
- - - 0.0% - Radiopharmaceuticals 1,697 - (1,697) 0.0% -
202 373 171 45.8% 252 Pack & Gowns 2,420 4,519 2,099 46.4% 4,256
- - - 0.0% - Anesthesia 1,303 - (1,303) 0.0% -
(160,228) - 160,228 0.0% (199,055) Inventory Variance (167,374) - 167,374 -278956883.3% (210,199)
(5,812) (7,318) (1,506) 20.6% (6,847) Premier Incentive (79,796) (88,578) (8,782) 9.9% (83,657)
(6,268) (2,816) 3,452 -122.6% (10,398) Rebates & Incentives (84,597) (34,433) 50,164 -145.7% (50,550)
(604) (307) 297 -96.9% (404) Purchase Discounts (6,000) (3,711) 2,289 -61.7% (3,812)
171 186 (15) -8.3% 166 Total Admissions 2,080 2,059 21 1.0% 2,024
482 523 (41) -7.8% 474 Total Patient Days 5,907 6,180 (273) -4.4% 6,120
42 34 8 24.1% 30 Total IP Surgeries 298 357 (59) -16.5% 347
335 366 (31) -8.4% 365 Total OP Surgeries 3,832 4,260 (428) -10.1% 3,881
377 400 (23) -5.6% 395 Total Surgeries 4,130 4,617 (487) (0) 4,228
21 16 5 31.7% 29 Cath Lab 256 200 56 0 200
779 733 46 6.3% 716 Total EIPAs 9,517 8,958 560 0 8,673
8.7% 11.2% -2.5% -22.5% 10.4% Supply Expense % of Net Revenue 11.9% 11.6% 0.3% 2.4% 11.9%
8.9% 11.5% -2.5% -22.2% 10.8% Supply Expense % of Net Patient Revenue 12.3% 11.9% 0.4% 3.2% 12.4%
738 1,005 266 26.5% 908 Supply Expense per EIPA 957 1,031 74 7.1% 997
3,784,729 4,425,384 (640,655) -14.5% 3,801,662 Gross Inpatient Revenue 44,239,779 48,446,105 (4,206,326) -8.7% 43,885,510
13,453,894 12,974,387 479,506 3.7% 12,599,150 Gross Outpatient Revenue 158,184,408 162,336,946 (4,152,539) -2.6% 144,175,414
17,238,623 17,399,772 (161,149) -0.9% 16,400,812 Total Gross Revenue 202,424,187 210,783,051 (8,358,864) -4.0% 188,060,924
6,442,220 6,421,992 20,229 0.3% 6,016,184 Total Net Patient Revenue 74,312,165 77,771,374 (3,459,209) -4.4% 70,001,592