Page 2 - Financial Workbook February
P. 2

Date:  Apr 24, 2018               Towne Square Care of Puryear - SNF                         Facility #
            Time: 19:30:19 EDT                      INCOME STATEMENT
            User:  Zach Bell                         2/1/2018 to 2/28/2018                                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       19,360    160.00      0    19,360   35,840    160.00      0    35,840
                 Med A - Contract. Adj.     27,283    225.48      0    27,283   41,142    183.67      0    41,142
                 Med A - Pharmacy            3,161     26.12      0     3,161    9,651    43.08       0     9,651
                 Med A - PT                  2,557     21.13      0     2,557    7,221    32.24       0     7,221
                 Med A - OT                 19,432    160.59      0    19,432   48,581    216.88      0    48,581
                 Med A - ST                 14,262    117.87      0    14,262   31,723    141.62      0    31,723
                 Med A - Anc. Contract. Adj.   (39,412)  (325.72)  0  (39,412)  (97,176)  (433.82)    0   (97,176)
                 Med A - 2% Reduction        (601)     (4.97)     0     (601)    (950)    (4.24)      0     (950)
                 TOTAL MEDICARE PART A      46,042    380.51      0    46,042   76,033    339.43      0    76,033
                 PRIVATE PAY
                 Private - Room & Board     24,975    183.64      0    24,975   36,735    188.38      0    36,735
                 Private - Pharmacy             0       0.00      0        0      (45)    (0.23)      0      (45)
                 Private - PT                   0       0.00      0        0      837      4.29       0      837
                 Private - OT                   0       0.00      0        0      611      3.14       0      611
                 TOTAL PRIVATE PAY          24,975    183.64      0    24,975   38,138    195.58      0    38,138
                 MEDICAID
                 Medicaid - Room & Board    79,840    162.94      0    79,840  178,880    162.77      0   178,880
                 Medicaid - Contract. Adj.   3,935      8.03      0     3,935    9,016     8.20       0     9,016
                 Medicaid - Pharmacy            0       0.00      0        0     (132)    (0.12)      0     (132)
                 Medicaid - Anc. Contract Adj.  0       0.00      0        0      132      0.12       0      132
                 TOTAL MEDICAID             83,775    170.97      0    83,775  187,896    170.97      0   187,896
                 MANAGED CARE
                 Managed - Room & Board      1,440    160.00      0     1,440    4,960    160.00      0     4,960
                 Managed - Contract. Adj.    2,624    291.53      0     2,624    8,329    268.67      0     8,329
                 Managed - Pharmacy             0       0.00      0        0     7,119    229.65      0     7,119
                 Managed - PT                1,153    128.12      0     1,153    3,552    114.58      0     3,552
                 Managed - OT                1,230    136.63      0     1,230    4,831    155.82      0     4,831
                 Managed - ST                1,149    127.64      0     1,149    5,223    168.47      0     5,223
                 Managed - Anc. Contract. Adj.  (3,532)  (392.39)  0   (3,532)  (20,724)  (668.52)    0   (20,724)
                 TOTAL MANAGED CARE          4,064    451.53      0     4,064   13,289    428.67      0    13,289
                 HOSPICE
                 Hospice - Room & Board      9,687    172.99      0     9,687   21,951    172.84      0    21,951
                 Hospice - Contract. Adj.    (113)     (2.01)     0     (113)    (238)    (1.87)      0     (238)
                 Hospice - Pharmacy             0       0.00      0        0       22      0.17       0       22
                 Hospice - Anc. Contract. Adj.  0       0.00      0        0      (22)    (0.17)      0      (22)
                 TOTAL HOSPICE               9,574    170.97      0     9,574   21,713    170.97      0    21,713
                 VETERANS ADMINISTRATION
                 TOTAL VETERANS ADMINISTRATION  0         -       0        0       0          -       0        0
                 ASSISTED LIVING
                 Asst. Living - Room & Board  12,000   53.57      0    12,000   24,000    50.85       0    24,000
                 TOTAL ASSISTED LIVING      12,000     53.57      0    12,000   24,000    50.85       0    24,000
                 MEDICARE PART B
                 Med B - Contract. Adj.     (2,545)   (21.03)     0    (2,545)  (8,712)   (38.89)     0    (8,712)
                 Med B - PT                  6,055     50.04      0     6,055    7,089    31.65       0     7,089
                 Med B - OT                 (1,181)    (9.76)     0    (1,181)   1,203     5.37       0     1,203
                 Med B - ST                   510       4.21      0      510     8,767    39.14       0     8,767
                 Med B - 2% Reduction          (5)     (0.04)     0       (5)    (278)    (1.24)      0     (278)
                 TOTAL MEDICARE PART B       2,834     23.42      0     2,834    8,069    36.02       0     8,069
                 OTHER INCOME
                 Other Income - Miscellaneous   980     0.95      0      980     1,290     0.60       0     1,290
                 TOTAL OTHER INCOME           980       0.95      0      980     1,290     0.60       0     1,290
            TOTAL REVENUE                  184,244    177.84      0   184,244  370,427    172.45      0   370,427
   1   2   3   4   5   6   7