Page 43 - CombinedTest_Neat

Actual Current Period KPI Actual Budget Variance
5,360,713 Supplies Supplies % Net Rev 21.8% 22.0% 0.15%
2,470 EIPAs Supplies per EIPA $2,170 2,197 $26.67
24,538,863 Net Revenue

66 - Paducah RUN DATE: 1/10/2018
Paducah 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

5,360,713 4,961,301 (399,412) (8.10%) 4,534,280 Total Supplies 58,929,280 60,315,024 1,385,744 2.30% 55,622,952
1,112,501 1,245,245 132,744 10.70% 1,106,786 Medical Surgical 13,629,878 15,308,480 1,678,602 11.00% 14,228,970
1,267,140 1,501,689 234,549 15.60% 1,417,805 Drugs 18,157,752 18,461,812 304,060 1.60% 16,948,984
87,616 94,456 6,840 7.20% 91,781 Implant - Stents 1,090,247 1,161,477 71,230 6.10% 1,092,198
159,970 158,772 (1,198) (0.80%) 175,856 Implant - CRM AICD/Pacemakers 2,144,000 1,899,034 (244,966) (12.90%) 1,970,214
26,350 98,217 71,867 73.20% 8,890 Implant - Open Heart/Heart Valves 224,455 801,287 576,832 72.00% 347,320
273,936 351,445 77,509 22.10% 276,527 Total CRM Implants 3,458,702 3,861,798 403,096 10.40% 3,409,733
384,477 281,418 (103,059) (36.60%) 426,432 Implant - Spinal 3,563,144 3,155,453 (407,690) (12.90%) 2,997,291
511,150 622,764 111,614 17.90% 687,049 Implant - Orthopedic Joint 7,324,584 7,663,205 338,621 4.40% 6,878,924
604,150 355,893 (248,256) (69.80%) 437,017 Implant - Other 5,157,532 4,432,764 (724,769) (16.40%) 4,514,758
Kentucky Financials
1,499,776 1,260,075 (239,701) (19.00%) 1,550,499 Total Non-CRM Implants 16,045,260 15,251,422 (793,838) (5.20%) 14,390,972
1,773,713 1,611,521 (162,192) (10.10%) 1,827,026 Implant Total 19,503,962 19,113,220 (390,742) (2.00%) 17,800,705

77,937 97,356 19,418 19.90% 106,915 Dietary 1,125,843 1,160,185 34,342 3.00% 1,224,739
72,754 76,848 4,094 5.30% 102,184 Blood 851,049 950,934 99,885 10.50% 981,732
25,505 11,885 (13,620) (114.60%) 12,302 Endomechanical 244,885 147,539 (97,345) (66.00%) 188,163
62,457 75,333 12,875 17.10% 61,324 Other Non-Medical 705,138 903,535 198,397 22.00% 707,711
71,097 47,870 (23,226) (48.50%) 54,307 IV and IV Sets 809,578 589,906 (219,672) (37.20%) 560,335
18,295 89,054 70,759 79.50% 16,567 Physical Plant/Maintenance 555,454 1,014,818 459,364 45.30% 838,501
165,984 93,453 (72,531) (77.60%) 126,535 Laboratory 1,624,408 1,212,998 (411,410) (33.90%) 1,296,486
6,932 5,085 (1,846) (36.30%) 5,673 Radiology 75,470 62,886 (12,584) (20.00%) 63,355
35,591 47,480 11,889 25.00% 33,663 Office 416,223 570,549 154,327 27.00% 469,285
8,390 7,785 (605) (7.80%) 14,043 Minor Equipment Non-Medical 109,593 95,725 (13,868) (14.50%) 79,887
34,674 23,052 (11,621) (50.40%) 24,496 Suture 344,611 286,098 (58,513) (20.50%) 304,133
14,138 13,062 (1,076) (8.20%) 8,390 Instruments 218,119 162,011 (56,108) (34.60%) 151,155
61,112 31,492 (29,619) (94.10%) 58,810 Minor Equipment Medical 297,441 381,808 84,367 22.10% 437,192
2,482 2,398 (84) (3.50%) 2,178 Linen & Laundry 25,795 33,005 7,210 21.80% 35,305
14,452 9,307 (5,144) (55.30%) 14,162 Freight 188,140 118,763 (69,377) (58.40%) 141,671
20,903 18,590 (2,313) (12.40%) 16,787 Housekeeping & Laundry 229,736 219,164 (10,572) (4.80%) 229,507
27,798 23,284 (4,514) (19.40%) 18,200 Contrast Media 297,156 289,853 (7,303) (2.50%) 293,359
19,538 20,309 771 3.80% 25,633 Gases, Medical 230,137 248,141 18,004 7.30% 245,269
6,433 5,499 (934) (17.00%) 8,866 Forms 78,206 66,594 (11,611) (17.40%) 69,241
0 120 120 100.00% 0 Fuel (aircraft & auto) 0 1,653 1,653 100.00% 4,085
0 (146) (146) 100.00% 0 Uniforms 804 (1,804) (2,608) 144.60% (887)
0 0 0 0.00% 0 Film, Radiographic 0 0 0 0.00% 110
0 650 650 100.00% 0 Radiology CAT Tubes 0 7,086 7,086 100.00% 3,793
32,437 0 (32,437) 0.00% 0 Radiopharmaceuticals 540,917 0 (540,917) 0.00% 0
624 238 (386) (162.50%) 0 Anesthesia 1,744 2,603 859 33.00% 2,994
491,598 (18,980) (510,578) 2690.10% (435,577) Inventory Variance (75,489) (205,617) (130,128) 63.30% (824,542)
(39,392) (54,819) (15,427) 28.10% (46,877) Premier Incentive (540,795) (600,316) (59,521) 9.90% (572,739)
(22,376) (27,164) (4,788) 17.60% (51,111) Rebates & Incentives (658,453) (327,051) 331,402 (101.30%) (314,461)
(2,002) 3,804 5,806 152.60% 5,192 Purchase Discounts (58,021) 40,446 98,467 243.50% 28,917
1,057 1,020 37 3.60% 1,002 Total Admissions 12,200 12,525 (325) (2.60%) 11,626
5,013 4,500 513 11.40% 4,352 Total Patient Days 54,884 55,152 (268) (0.50%) 54,039
232 224 8 3.60% 243 Total IP Surgeries 2,767 2,805 (38) (1.30%) 2,675
688 654 34 5.20% 732 Total OP Surgeries 7,487 8,069 (582) (7.20%) 6,898
920 878 42 4.80% 975 Total Surgeries 10,254 10,874 (620) (5.70%) 9,573
123 813 -690 -84.90% 130 Cath Lab 1,455 8,555 (7100) (83.00%) 1,501
2,470 2,259 212 9.40% 2,303 Total EIPAs 28,519 27,798 721 2.60% 26,708
20.40% 20.80% -0.40% (1.80%) 20.70% Supply Expense % of Net Revenue 19.70% 20.60% -0.90% (4.60%) 20.70%
21.80% 22.00% -0.20% (0.70%) 22.10% Supply Expense % of Net Patient Revenue 21.00% 21.80% -0.80% (3.60%) 21.90%
2,170 2,197 26 1.20% 1,969 Supply Expense per EIPA 2,066 2,170 103 4.80% 2,083
38,393,037 38,777,421 (384,384) (1.00%) 36,928,364 Gross Inpatient Revenue 448,621,932 477,529,874 (28,907,942) (6.10%) 421,188,001
51,324,557 47,086,120 4,238,438 9.00% 47,934,160 Gross Outpatient Revenue 600,087,036 582,341,601 17,745,435 3.00% 546,408,660
89,717,594 85,863,541 3,854,054 4.50% 84,862,524 Total Gross Revenue 1,048,708,968 1,059,871,475 (11,162,507) (1.10%) 967,596,661
24,538,863 22,543,005 1,995,857 8.90% 20,551,929 Total Net Patient Revenue 280,265,643 276,647,715 3,617,928 1.30% 253,682,358