Page 2 - Financial Workbook March
P. 2

Date:  Aug 13, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 14:32:34 EDT                          INCOME STATEMENT
      User:  Zach Bell                             3/1/2018 to 3/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           19,040     160.00       0    19,040    54,880    160.00        0    54,880
          Med A - Contract. Adj.         28,984     243.56       0    28,984    70,127    204.45        0    70,127
          Med A - Pharmacy                1,759      14.78       0     1,759    11,409     33.26        0    11,409
          Med A - PT                      9,812      82.45       0     9,812    17,032     49.66        0    17,032
          Med A - OT                     28,883     242.72       0    28,883    77,465    225.84        0    77,465
          Med A - ST                     24,541     206.22       0    24,541    56,263    164.03        0    56,263
          Med A - Anc. Contract. Adj.   (64,994)   (546.17)      0   (64,994)  (162,170)  (472.80)      0  (162,170)
          Med A - 2% Reduction            (669)     (5.62)       0     (669)    (1,619)    (4.72)       0    (1,619)
          TOTAL MEDICARE PART A          47,355     397.94       0    47,355   123,388    359.73        0    123,388
          PRIVATE PAY
          Private - Room & Board          8,720     229.47       0     8,720    45,455    195.09        0    45,455
          Private - Pharmacy              (550)    (14.48)       0     (550)     (595)     (2.55)       0      (595)
          Private - PT                    (115)     (3.02)       0     (115)      722       3.10        0       722
          Private - OT                    (246)     (6.48)       0     (246)      365       1.57        0       365
          Private - ST                    (142)     (3.73)       0     (142)     (142)     (0.61)       0      (142)
          TOTAL PRIVATE PAY               7,667     201.77       0     7,667    45,805    196.59        0    45,805
          MEDICAID
          Medicaid - Room & Board       104,740     163.40       0   104,740   283,620    163.00        0    283,620
          Medicaid - Contract. Adj.       4,852      7.57        0     4,852    13,868      7.97        0    13,868
          Medicaid - Pharmacy              865       1.35        0      865       733       0.42        0       733
          Medicaid - Anc. Contract Adj.   (865)     (1.35)       0     (865)     (733)     (0.42)       0      (733)
          TOTAL MEDICAID                109,592     170.97       0   109,592   297,488    170.97        0    297,488
          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                     115          -        0      115      3,667    118.28        0     3,667
          Managed - OT                     246          -        0      246      5,077    163.77        0     5,077
          Managed - ST                     142          -        0      142      5,364    173.04        0     5,364
          Managed - Anc. Contract. Adj.   (503)         -        0     (503)   (21,227)  (684.74)       0   (21,227)
          TOTAL MANAGED CARE                 0          -        0        0     13,289    428.67        0    13,289
          HOSPICE
          Hospice - Room & Board         10,725     172.99       0    10,725    32,676    172.89        0    32,676
          Hospice - Contract. Adj.        (125)     (2.01)       0     (125)     (363)     (1.92)       0      (363)
          Hospice - Pharmacy                 0       0.00        0        0        22       0.12        0        22
          Hospice - Anc. Contract. Adj.      0       0.00        0        0       (22)     (0.12)       0      (22)
          TOTAL HOSPICE                  10,600     170.97       0    10,600    32,313    170.97        0    32,313
          VETERANS ADMINISTRATION
          TOTAL VETERANS ADMINISTRATION      0          -        0        0         0          -        0        0
          ASSISTED LIVING
          Asst. Living - Room & Board    10,258      48.39       0    10,258    34,258     50.09        0    34,258
          TOTAL ASSISTED LIVING          10,258      48.39       0    10,258    34,258     50.09        0    34,258
          MEDICARE PART B
          Med B - Contract. Adj.          7,194      60.45       0     7,194    (1,518)    (4.43)       0    (1,518)
          Med B - PT                      2,454      20.62       0     2,454     9,544     27.82        0     9,544
          Med B - OT                     (7,109)   (59.74)       0    (7,109)   (5,906)   (17.22)       0    (5,906)
          Med B - ST                     (6,435)   (54.07)       0    (6,435)    2,333      6.80        0     2,333
          Med B - 2% Reduction             207       1.74        0      207       (72)     (0.21)       0      (72)
          TOTAL MEDICARE PART B          (3,688)   (30.99)       0    (3,688)    4,380     12.77        0     4,380
          OTHER INCOME
          Other Income - Miscellaneous    2,739      2.55        0     2,739     4,029      1.25        0     4,029
          TOTAL OTHER INCOME              2,739      2.55        0     2,739     4,029      1.25        0     4,029
      TOTAL REVENUE                     184,523     172.13       0   184,523   554,950    172.34        0    554,950
   1   2   3   4   5   6   7