Page 2 - May Financial Workbook
P. 2

Date:  Jul 22, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 16:07:06 EDT                          INCOME STATEMENT
      User:  Zach Bell                             5/1/2018 to 5/31/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,920     160.00       0     9,920    79,680    160.00        0    79,680
          Med A - Contract. Adj.         18,724     302.01       0    18,724   114,930    230.78        0    114,930
          Med A - Pharmacy                   0       0.00        0        0     11,409     22.91        0    11,409
          Med A - PT                         0       0.00        0        0     28,296     56.82        0    28,296
          Med A - OT                         0       0.00        0        0     96,013    192.80        0    96,013
          Med A - ST                         0       0.00        0        0     71,427    143.43        0    71,427
          Med A - Anc. Contract. Adj.        0       0.00        0        0   (207,146)  (415.96)       0  (207,146)
          Med A - 2% Reduction            (415)     (6.70)       0     (415)    (2,713)    (5.45)       0    (2,713)
          TOTAL MEDICARE PART A          28,229     455.31       0    28,229   191,897    385.34        0    191,897
          PRIVATE PAY
          Private - Room & Board         32,060     185.32       0    32,060   102,190    190.30        0    102,190
          Private - Pharmacy                 0       0.00        0        0      (595)     (1.11)       0      (595)
          Private - PT                       0       0.00        0        0      1,217      2.27        0     1,217
          Private - OT                       0       0.00        0        0       365       0.68        0       365
          Private - ST                       0       0.00        0        0       283       0.53        0       283
          TOTAL PRIVATE PAY              32,060     185.32       0    32,060   103,461    192.66        0    103,461
          MEDICAID
          Medicaid - Room & Board       106,980     162.83       0   106,980   490,320    162.95        0    490,320
          Medicaid - Contract. Adj.       5,347      8.14        0     5,347    24,129      8.02        0    24,129
          Medicaid - Pharmacy                0       0.00        0        0       733       0.24        0       733
          Medicaid - Anc. Contract Adj.      0       0.00        0        0      (733)     (0.24)       0      (733)
          TOTAL MEDICAID                112,327     170.97       0   112,327   514,449    170.97        0    514,449
          MANAGED CARE
          Managed - Room & Board             0          -        0        0      4,960    160.00        0     4,960
          Managed - Contract. Adj.           0          -        0        0      8,329    268.67        0     8,329
          Managed - Pharmacy                 0          -        0        0      7,119    229.65        0     7,119
          Managed - PT                   (3,552)        -        0    (3,552)     115       3.70        0       115
          Managed - OT                   (4,830)        -        0    (4,830)     246       7.94        0       246
          Managed - ST                   (5,223)        -        0    (5,223)     142       4.57        0       142
          Managed - Anc. Contract. Adj.  13,605         -        0    13,605    (7,622)  (245.87)       0    (7,622)
          TOTAL MANAGED CARE                 0          -        0        0     13,289    428.67        0    13,289
          HOSPICE
          Hospice - Room & Board         16,196     172.30       0    16,196    59,251    172.74        0    59,251
          Hospice - Contract. Adj.        (125)     (1.33)       0     (125)     (609)     (1.77)       0      (609)
          Hospice - Pharmacy                 0       0.00        0        0        22       0.06        0        22
          Hospice - Anc. Contract. Adj.      0       0.00        0        0       (22)     (0.06)       0      (22)
          TOTAL HOSPICE                  16,071     170.97       0    16,071    58,643    170.97        0    58,643
          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.         (5,879)   (94.83)       0    (5,879)  (15,178)   (30.48)       0   (15,178)
          Med B - PT                      3,552      57.29       0     3,552    18,284     36.72        0    18,284
          Med B - OT                      4,831      77.91       0     4,831     5,189     10.42        0     5,189
          Med B - ST                      5,223      84.24       0     5,223    11,613     23.32        0    11,613
          Med B - 2% Reduction            (124)     (2.00)       0     (124)     (320)     (0.64)       0      (320)
          TOTAL MEDICARE PART B           7,602     122.61       0     7,602    19,589     39.33        0    19,589
          OTHER INCOME
          Other Income - Miscellaneous     310       0.31        0      310      4,639      0.91        0     4,639
          TOTAL OTHER INCOME               310       0.31        0      310      4,639      0.91        0     4,639
      TOTAL REVENUE                     196,599     199.39       0   196,599   940,224    184.29        0    940,224
   1   2   3   4   5   6   7