Page 2 - Financial Workbook December

Date: Jan 19, 2018 Towne Square Care of Puryear - SNF
Time: 17:51:54 CT INCOME STATEMENT
User: Zach Bell 12/1/2017 to 12/31/2017 Page # 1

Include Adjustment Periods: NO Include Closing Periods: NO

CURRENT PERIOD YEAR TO DATE
Actual $ Actual / Day Budget $ Var $ Actual $ Actual / Day Budget $ Var $
REVENUE
MEDICARE PART A
Med A - Room & Board 15,200 160.00 13,640 1,560 115,570 162.55 145,840 (30,270)
Med A - Contract. Adj. 19,940 209.90 0 19,940 34,466 48.48 0 34,466
Med A - Pharmacy 0 0.00 0 0 11,471 16.13 0 11,471
Med A - PT 2,373 24.97 0 2,373 26,100 36.71 0 26,100
Med A - OT 11,150 117.37 0 11,150 117,042 164.62 0 117,042
Med A - ST 5,170 54.42 0 5,170 55,130 77.54 0 55,130
Med A - X-Ray 0 0.00 0 0 100 0.14 0 100
Med A - Laboratory 0 0.00 0 0 16 0.02 0 16
Med A - Anc. Contract. Adj. (18,692) (196.76) 0 (18,692) (93,448) (131.43) 0 (93,448)
Med A - 2% Reduction (525) (5.53) 0 (525) (1,912) (2.69) 0 (1,912)
TOTAL MEDICARE PART A 34,615 364.37 13,640 20,975 264,536 372.06 145,840 118,696
PRIVATE PAY
Private - Room & Board 36,575 182.88 6,045 30,530 241,715 141.85 65,130 176,585
Private - PT 837 4.18 0 837 1,066 0.63 0 1,066
Private - OT 611 3.06 0 611 1,104 0.65 0 1,104
Private - ST 0 0.00 0 0 283 0.17 0 283
TOTAL PRIVATE PAY 38,023 190.11 6,045 31,978 244,168 143.29 65,130 179,038
MEDICAID
Medicaid - Room & Board 86,660 162.59 5,580 81,080 996,265 170.04 60,120 936,145
Medicaid - Contract. Adj. 4,467 8.38 0 4,467 93,137 15.90 0 93,137
Medicaid - Pharmacy 0 0.00 0 0 489 0.08 0 489
Medicaid - Anc. Contract Adj. 0 0.00 0 0 (433) (0.07) 0 (433)
TOTAL MEDICAID 91,127 170.97 5,580 85,547 1,089,458 185.95 60,120 1,029,338
MANAGED CARE
Managed - Room & Board 0 - 12,710 (12,710) 14,680 164.94 136,940 (122,260)
Managed - Contract. Adj. 0 - 0 0 21,458 241.10 0 21,458
Managed - Pharmacy 0 - 0 0 1,273 14.30 0 1,273
Managed - PT 0 - 0 0 8,967 100.75 0 8,967
Managed - OT 0 - 0 0 23,626 265.47 0 23,626
Managed - ST 0 - 0 0 10,675 119.95 0 10,675
Managed - Anc. Contract. Adj. 0 - 0 0 (43,444) (488.14) 0 (43,444)
TOTAL MANAGED CARE 0 - 12,710 (12,710) 37,235 418.37 136,940 (99,705)
HOSPICE
Hospice - Room & Board 16,025 172.31 0 16,025 181,164 176.75 0 181,164
Hospice - Contract. Adj. (125) (1.34) 0 (125) 7,905 7.71 0 7,905
TOTAL HOSPICE 15,900 170.97 0 15,900 189,070 184.46 0 189,070
VETERANS ADMINISTRATION
TOTAL VETERANS ADMINISTRATION 0 - 0 0 0 - 0 0
ASSISTED LIVING
Asst. Living - Room & Board 12,000 48.39 0 12,000 115,178 52.31 0 115,178
TOTAL ASSISTED LIVING 12,000 48.39 0 12,000 115,178 52.31 0 115,178
MEDICARE PART B
Med B - Contract. Adj. 434 4.57 0 434 (25,348) (35.65) 0 (25,348)
Med B - PT 1,653 17.40 0 1,653 15,395 21.65 0 15,395
Med B - OT 3,055 32.16 0 3,055 31,628 44.48 0 31,628
Med B - ST 5,324 56.04 0 5,324 33,581 47.23 0 33,581
Med B - Anc. Contract. Adj. (5,792) (60.97) 0 (5,792) (12,271) (17.26) 0 (12,271)
Med B - 2% Reduction (75) (0.79) 0 (75) (451) (0.63) 0 (451)
TOTAL MEDICARE PART B 4,599 48.41 0 4,599 42,535 59.82 0 42,535
OTHER INCOME
Acuity Revenue Accrual 8,557 7.32 0 8,557 25,670 2.21 0 25,670
Other Income - Interest 0 0.00 0 0 150 0.01 0 150
Other Income - Miscellaneous 310 0.27 0 310 3,947 0.34 0 3,947
TOTAL OTHER INCOME 8,867 7.58 0 8,867 29,767 2.57 0 29,767
TOTAL REVENUE 205,131 175.48 37,975 167,156 2,011,946 173.59 408,030 1,603,916