Page 105 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
9,962,191 Supplies Supplies % Net Rev 23.6% 17.9% -5.74%
2,539 EIPAs Supplies per EIPA $3,924 $2,886 ($1,037.67)
42,140,587 Net Revenue

6760 RUN DATE: 1/10/2018
Mercy Health – St. Vincent Medical Center 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
9,962,191 7,347,927 (2,614,264) -35.6% 4,650,433 Total Supplies 85,476,603 95,538,079 10,061,477 10.5% 84,217,777
3,927,361 1,845,332 (2,082,029) -112.8% 1,132,551 Medical Surgical 26,550,647 27,662,752 1,112,105 4.0% 25,232,358
2,195,235 2,830,256 635,020 22.4% 2,078,611 Drugs 27,927,741 35,664,911 7,737,170 21.7% 26,911,063
174,392 177,458 3,065 1.7% 41,206 Implant - Stents 1,721,850 2,243,970 522,121 23.3% 1,990,767
227,140 535,326 308,186 57.6% 589,781 Implant - CRM AICD/Pacemakers 5,011,122 5,882,180 871,058 14.8% 5,791,756
86,050 96,029 9,979 10.4% 201,300 Implant - Open Heart/Heart Valves 1,486,880 1,214,413 (272,467) -22.4% 1,335,276
487,582 808,813 321,231 39.7% 832,287 Total CRM Implants 8,219,852 9,340,563 1,120,712 12.0% 9,117,799
161,550 261,559 100,010 38.2% 219,023 Implant - Spinal 1,981,289 3,311,635 1,330,346 40.2% 2,323,341
131,257 117,355 (13,902) -11.8% 102,279 Implant - Orthopedic Joint 1,427,039 1,487,143 60,104 4.0% 1,292,567
5,023,281
Implant - Other
5,413,971
650,158 1,581,552 (256,333) -65.1% 1,600,360 Total Non-CRM Implants 17,646,428 19,162,623 1,516,195 (994,967) 395,483 -19.8% 18,147,678
6,018,249
446,771
393,825
St vincent Financials 206,749 207,086 324,028 50,731 338 -162.4% 152,975 Minor Equipment Non-Medical 2,329,242 3,548,461 1,047,391 781,931 2,525,534 3,604,722 1,051,979 641,558 (140,373) (361,374) 196,292 100.0% 2,390,465
942,964

-22.0%
9,822,060

772,739
(170,225)
9,029,879

768,074
4.0%
9,426,577

1,430,546
Implant Total

9.5%

7.9%

151,005
7.8%
Dietary
0.2%
-

(1,464)
138,823

Blood
-
(1,464)
100.0%
(18,511)

1,484,199
(18,511)

629,260

(42,936)
-21.9%
Endomechanical

-84.6%
93,667

72,291
Other Non-Medical
332,551

3,964,247
1.6%

-13.9%

(45,005)
56,261
369,034

(45,107)
-83.1%

99,386
635,824

686,016
-52.7%

60,700
54,279

IV and IV Sets
297,446
81,237
55,705
31.6%

Physical Plant/Maintenance
(15,956)
642,881
102.7%
940,327

79,114

(2,123)

136,954

Laboratory
5,485
116,389

1,445,513
(66,552)
-94.5%

70,402

14,394
(8,909)
83,169

252,486
920,096
799,493
48,728
94,057

24.0%
Radiology

34,441
41.4%

48,391
316,375

210,401
39.9%
(4,051)
623,384
526,776
44,340

-9.1%
Office
31,972

62,168
3.5%
-57.6%
442,293
458,442
55,012

454,830
39,438

16,149
(22,730)

40,423
474,002

480,004

(6,002)

-1.3%

(2,888)
Suture
-7.7%
37,534
27,533

473,486
-50.2%
Instruments

635,712

44,790
-47.8%

44,162

-84.0%
0.0%

Linen & Laundry

-
0.0%
(179)
-

-
-
179
16,351

66,547
732,655
44.6%

Freight

36,856
743,443
1.5%

84,488
10,766
721,889

546,986

4.7%

26,403
4.1%
47,371
562,003
49,378

51,694
Housekeeping & Laundry

2,007

535,600

4,559

Contrast Media
30.6%
2,007
194
519
62.7%
325
6,566
6,574

180
80,769
150,838
Gases, Medical

27,639
5,046

8,190

(49,917)
100,922

-49.5%
160,241 106,692 24,337 (53,549) (20,453) (19,449) 29,691 -237.5% 172,892 Minor Equipment Medical 1,898,058 443,174 1,349,076 299,761 (548,983) (143,413) (16,351) -40.7% 1,682,709
12,194 16,405 4,211 25.7% 5,925 Forms 117,418 204,054 86,636 42.5% 139,974
54,904 37,279 (17,626) -47.3% 12,221 Fuel (aircraft & auto) 472,718 409,984 (62,734) -15.3% 445,289
1,004 6,212 5,208 83.8% 2,917 Uniforms 36,018 68,503 32,485 47.4% 64,329
- 165 165 100.0% - Film, Radiographic 747 2,088 1,341 64.2% 2,323
2,747 2,389 (358) -15.0% 1,918 Pack & Gowns 31,876 30,207 (1,669) -5.5% 32,296
247 619 373 60.1% (150) Research Animals 6,727 6,813 85 1.3% 9,365
1,175,620 - (1,175,620) 0.0% (1,433,266) Inventory Variance 494,037 - (494,037) 0.0% (1,882,020)
(79,893) (110,707) (30,814) 27.8% (94,115) Premier Incentive (1,096,817) (1,217,536) (120,718) 9.9% (1,149,895)
(55,685) (30,965) 24,720 -79.8% (79,777) Rebates & Incentives (941,331) (358,439) 582,893 -162.6% (408,625)
(175) (10,012) (9,837) 98.3% (1,572) Purchase Discounts (65,102) (110,110) (45,009) 40.9% (99,562)
1,416 1,468 (52) -3.5% 1,360 Total Admissions 16,571 17,417 (846) -4.9% 16,525
5,326 6,243 (917) -14.7% 5,837 Total Patient Days 71,026 73,460 (2,434) -3.3% 73,890
286 296 (10) -3.5% 276 Total IP Surgeries 3,347 3,420 (73) -2.1% 3,280
592 662 (70) -10.6% 667 Total OP Surgeries 7,581 7,873 (292) -3.7% 7,856
878 958 (80) -8.4% 943 Total Surgeries 10,928 11,293 (365) (0) 11,136
140 154 (14) -9.3% 141 Cath Lab 1,633 2,089 (456) (0) 1,908
2,539 2,546 (7) -0.3% 2,439 Total EIPAs 29,712 32,058 (2,346) (0) 29,641
22.6% 17.3% 5.4% 31.1% 11.7% Supply Expense % of Net Revenue 16.4% 18.1% -1.7% -9.2% 17.2%
23.6% 17.9% 5.8% 32.4% 12.2% Supply Expense % of Net Patient Revenue 17.0% 18.7% -1.6% -8.8% 17.9%
3,923 2,886 (1,038) -36.0% 1,906 Supply Expense per EIPA 2,877 2,980 103 3.5% 2,841
118,331,168 125,598,903 (7,267,734) -5.8% 114,014,238 Gross Inpatient Revenue 1,458,273,515 1,481,544,262 (23,270,747) -1.6% 1,362,228,927
93,879,476 92,332,608 1,546,868 1.7% 90,487,434 Gross Outpatient Revenue 1,156,417,679 1,245,401,189 (88,983,510) -7.1% 1,081,241,822
212,210,644 217,931,511 (5,720,866) -2.6% 204,501,673 Total Gross Revenue 2,614,691,194 2,726,945,451 (112,254,257) -4.1% 2,443,470,749
42,140,587 41,146,838 993,749 2.4% 38,172,240 Total Net Patient Revenue 502,110,408 511,698,198 (9,587,790) -1.9% 471,656,225