Page 2 - June Financial Workbook
P. 2

Date:  Jul 22, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 16:07:37 EDT                          INCOME STATEMENT
      User:  Zach Bell                             6/1/2018 to 6/30/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            9,600     160.00       0     9,600    89,280    160.00        0    89,280
          Med A - Contract. Adj.         16,455     274.25       0    16,455   131,385    235.46        0    131,385
          Med A - Pharmacy                4,417     73.61        0     4,417    15,826     28.36        0    15,826
          Med A - PT                      7,164     119.40       0     7,164    35,461     63.55        0    35,461
          Med A - OT                     10,397     173.28       0    10,397   106,410    190.70        0    106,410
          Med A - ST                     12,346     205.77       0    12,346    83,773    150.13        0    83,773
          Med A - Anc. Contract. Adj.   (34,324)   (572.07)      0   (34,324)  (241,470)  (432.74)      0  (241,470)
          Med A - 2% Reduction            (320)     (5.34)       0     (320)    (3,033)    (5.44)       0    (3,033)
          TOTAL MEDICARE PART A          25,735     428.92       0    25,735   217,632    390.02        0    217,632
          PRIVATE PAY
          Private - Room & Board         30,825     186.82       0    30,825   133,015    189.48        0    133,015
          Private - Pharmacy                (2)     (0.01)       0       (2)     (597)     (0.85)       0      (597)
          Private - PT                    1,798     10.90        0     1,798     3,016      4.30        0     3,016
          Private - OT                    2,281     13.82        0     2,281     2,646      3.77        0     2,646
          Private - ST                    3,917     23.74        0     3,917     4,201      5.98        0     4,201
          TOTAL PRIVATE PAY              38,819     235.27       0    38,819   142,280    202.68        0    142,280
          MEDICAID
          Medicaid - Room & Board        99,295     163.05       0    99,295   589,615    162.97        0    589,615
          Medicaid - Contract. Adj.       4,826      7.92        0     4,826    28,954      8.00        0    28,954
          Medicaid - Pharmacy              271       0.45        0      271      1,004      0.28        0     1,004
          Medicaid - Anc. Contract Adj.   (271)     (0.45)       0     (271)    (1,004)    (0.28)       0    (1,004)
          TOTAL MEDICAID                104,121     170.97       0   104,121   618,569    170.97        0    618,569
          MANAGED CARE
          Managed - Room & Board           320      160.00       0      320      5,280    160.00        0     5,280
          Managed - Contract. Adj.           0       0.00        0        0      8,329    252.39        0     8,329
          Managed - Pharmacy                 0       0.00        0        0      7,119    215.74        0     7,119
          Managed - PT                       0       0.00        0        0       115       3.48        0       115
          Managed - OT                       0       0.00        0        0       246       7.46        0       246
          Managed - ST                       0       0.00        0        0       142       4.29        0       142
          Managed - Anc. Contract. Adj.      0       0.00        0        0     (7,622)  (230.97)       0    (7,622)
          TOTAL MANAGED CARE               320      160.00       0      320     13,609    412.39        0    13,609
          HOSPICE
          Hospice - Room & Board         14,995     172.36       0    14,995    74,247    172.67        0    74,247
          Hospice - Contract. Adj.        (121)     (1.39)       0     (121)     (729)     (1.70)       0      (729)
          Hospice - Pharmacy                 0       0.00        0        0        22       0.05        0        22
          Hospice - Anc. Contract. Adj.      0       0.00        0        0       (22)     (0.05)       0      (22)
          TOTAL HOSPICE                  14,874     170.97       0    14,874    73,517    170.97        0    73,517
          VETERANS ADMINISTRATION
          TOTAL VETERANS ADMINISTRATION      0          -        0        0         0          -        0        0
          ASSISTED LIVING
          Asst. Living - Room & Board        0          -        0        0     34,258     50.09        0    34,258
          TOTAL ASSISTED LIVING              0          -        0        0     34,258     50.09        0    34,258
          MEDICARE PART B
          Med B - Contract. Adj.        (14,303)   (238.39)      0   (14,303)  (29,481)   (52.83)       0   (29,481)
          Med B - PT                      7,794     129.91       0     7,794    26,079     46.74        0    26,079
          Med B - OT                     10,211     170.19       0    10,211    15,400     27.60        0    15,400
          Med B - ST                      8,200     136.67       0     8,200    19,813     35.51        0    19,813
          Med B - 2% Reduction            (191)     (3.18)       0     (191)     (511)     (0.91)       0      (511)
          TOTAL MEDICARE PART B          11,712     195.20       0    11,712    31,300     56.09        0    31,300
          OTHER INCOME
          Other Income - Miscellaneous     337       0.37        0      337      4,976      0.83        0     4,976
          TOTAL OTHER INCOME               337       0.37        0      337      4,976      0.83        0     4,976
      TOTAL REVENUE                     195,918     212.26       0   195,918  1,136,142   188.57        0  1,136,142
   1   2   3   4   5   6   7