Page 2 - Financial Workbook November

Date: Dec 18, 2017 Towne Square Care of Puryear - SNF
Time: 16:41:17 CT INCOME STATEMENT
User: Zach Bell 11/1/2017 to 11/30/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 12,160 160.00 13,200 (1,040) 100,370 162.94 132,200 (31,830)
Med A - Contract. Adj. 15,189 199.86 0 15,189 14,526 23.58 0 14,526
Med A - Pharmacy 3,318 43.66 0 3,318 11,471 18.62 0 11,471
Med A - PT 3,514 46.23 0 3,514 18,819 30.55 0 18,819
Med A - OT 6,302 82.93 0 6,302 84,039 136.43 0 84,039
Med A - ST 6,446 84.82 0 6,446 34,577 56.13 0 34,577
Med A - X-Ray 0 0.00 0 0 100 0.16 0 100
Med A - Laboratory 0 0.00 0 0 16 0.03 0 16
Med A - Anc. Contract. Adj. (19,580) (257.63) 0 (19,580) (32,610) (52.94) 0 (32,610)
Med A - 2% Reduction (350) (4.60) 0 (350) (1,387) (2.25) 0 (1,387)
TOTAL MEDICARE PART A 27,000 355.26 13,200 13,800 229,921 373.25 132,200 97,721
PRIVATE PAY
Private - Room & Board 15,645 168.23 5,850 9,795 205,140 136.40 59,085 146,055
Private - PT 115 1.23 0 115 115 0.08 0 115
Private - OT 246 2.65 0 246 246 0.16 0 246
Private - ST (608) (6.54) 0 (608) 142 0.09 0 142
TOTAL PRIVATE PAY 15,397 165.56 5,850 9,547 205,643 136.73 59,085 146,558
MEDICAID
Medicaid - Room & Board 98,785 162.48 5,400 93,385 909,605 170.79 54,540 855,065
Medicaid - Contract. Adj. 5,842 9.61 0 5,842 88,670 16.65 0 88,670
Medicaid - Pharmacy 433 0.71 0 433 489 0.09 0 489
Medicaid - Anc. Contract Adj. (433) (0.71) 0 (433) (433) (0.08) 0 (433)
TOTAL MEDICAID 104,627 172.08 5,400 99,227 998,331 187.44 54,540 943,791
MANAGED CARE
Managed - Room & Board 6,680 167.00 12,300 (5,620) 14,680 164.94 124,230 (109,550)
Managed - Contract. Adj. 10,498 262.45 0 10,498 21,458 241.10 0 21,458
Managed - Pharmacy 1,273 31.82 0 1,273 1,273 14.30 0 1,273
Managed - PT 3,574 89.34 0 3,574 3,574 40.15 0 3,574
Managed - OT 7,748 193.69 0 7,748 7,748 87.05 0 7,748
Managed - ST 2,409 60.23 0 2,409 3,506 39.39 0 3,506
Managed - Anc. Contract. Adj. (15,003) (375.08) 0 (15,003) (15,003) (168.58) 0 (15,003)
TOTAL MANAGED CARE 17,178 429.45 12,300 4,878 37,235 418.37 124,230 (86,995)
HOSPICE
Hospice - Room & Board 17,144 190.49 0 17,144 165,139 177.19 0 165,139
Hospice - Contract. Adj. (1,636) (18.18) 0 (1,636) 8,030 8.62 0 8,030
TOTAL HOSPICE 15,508 172.31 0 15,508 173,169 185.80 0 173,169
VETERANS ADMINISTRATION
TOTAL VETERANS ADMINISTRATION 0 - 0 0 0 - 0 0
ASSISTED LIVING
Asst. Living - Room & Board 12,000 50.00 0 12,000 103,178 52.80 0 103,178
TOTAL ASSISTED LIVING 12,000 50.00 0 12,000 103,178 52.80 0 103,178
MEDICARE PART B
Med B - Contract. Adj. (254) (3.34) 0 (254) (12,417) (20.16) 0 (12,417)
Med B - PT 2,770 36.45 0 2,770 10,415 16.91 0 10,415
Med B - OT 5,605 73.75 0 5,605 19,572 31.77 0 19,572
Med B - ST 3,279 43.15 0 3,279 16,639 27.01 0 16,639
Med B - Anc. Contract. Adj. (6,479) (85.25) 0 (6,479) (6,479) (10.52) 0 (6,479)
Med B - 2% Reduction (79) (1.04) 0 (79) (207) (0.34) 0 (207)
TOTAL MEDICARE PART B 4,843 63.73 0 4,843 27,523 44.68 0 27,523
OTHER INCOME
Acuity Revenue Accrual 0 0.00 0 0 17,113 1.64 0 17,113
Other Income - Interest 0 0.00 0 0 150 0.01 0 150
Other Income - Miscellaneous 907 0.79 0 907 3,637 0.35 0 3,637
TOTAL OTHER INCOME 907 0.79 0 907 20,901 2.01 0 20,901
TOTAL REVENUE 197,460 172.15 36,750 160,710 1,795,900 172.33 370,055 1,425,845