Page 5 - Financial Workbook July
P. 5

Date:  Aug 25, 2017               Towne Square Care of Puryear - SNF
            Time: 15:15:00 CT                       INCOME STATEMENT
            User:  Zach Bell                         7/1/2017 to 7/31/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        2,720    160.00      0    2,720    56,445   174.21       0    56,445
                 Med A - Contract. Adj.      8,568    504.00      0    8,568    69,402   214.20       0    69,402
                 Med A - Pharmacy            1,201     70.67      0    1,201    6,332     19.54       0     6,332
                 Med A - PT                  2,332    137.18      0    2,332    10,695    33.01       0    10,695
                 Med A - OT                 10,844    637.88      0    10,844   62,917   194.19       0    62,917
                 Med A - ST                  9,553    561.92      0    9,553    21,712    67.01       0    21,712
                 Med A - X-Ray                  0      0.00       0       0       100      0.31       0      100
                 Med A - Laboratory            16      0.91       0       16      16       0.05       0       16
                 Med A - Anc. Contract. Adj.   (23,946)  (1,408.56)  0  (23,946)  (102,273)  (315.66)  0  (102,273)
                 Med A - 2% Reduction        (182)    (10.70)     0     (182)  (1,546)    (4.77)      0    (1,546)
                 TOTAL MEDICARE PART A      11,106    653.31      0    11,106  123,801   382.10       0   123,801

                 PRIVATE PAY
                 Private - Room & Board     34,960    166.48      0    34,960  166,630   130.38       0   166,630
                 TOTAL PRIVATE PAY          34,960    166.48      0    34,960  166,630   130.38       0   166,630
                 MEDICAID
                 Medicaid - Room & Board    85,215    163.88      0    85,215  517,845   180.31       0   517,845
                 Medicaid - Contract. Adj.   4,333     8.33       0    4,333    13,717     4.78       0    13,717
                 Medicaid - Pharmacy            0      0.00       0       0       56       0.02       0       56
                 Medicaid - Anc. Contract Adj.  0      0.00       0       0      (56)     (0.02)      0      (56)
                 TOTAL MEDICAID             89,548    172.21      0    89,548  531,562   185.08       0   531,562
                 MANAGED CARE
                 Managed - ST                   0         -       0       0     1,097        -        0     1,097
                 Managed - Anc. Contract. Adj.  0         -       0       0      (518)       -        0     (518)
                 TOTAL MANAGED CARE             0         -       0       0       578        -        0      578
                 HOSPICE
                 Hospice - Room & Board     13,830    168.66      0    13,830   90,240   168.36       0    90,240
                 Hospice - Contract. Adj.     260      3.17       0      260    1,170      2.18       0     1,170
                 TOTAL HOSPICE              14,090    171.83      0    14,090   91,410   170.54       0    91,410
                 VETERANS ADMINISTRATION
                 TOTAL VETERANS ADMINISTRATION  0         -       0       0        0         -        0        0
                 ASSISTED LIVING
                 Asst. Living - Room & Board    0         -       0       0     47,561    51.75       0    47,561
                 TOTAL ASSISTED LIVING          0         -       0       0     47,561    51.75       0    47,561
                 MEDICARE PART B
                 Med B - Contract. Adj.     (1,985)  (116.79)     0   (1,985)  (6,239)   (19.26)      0    (6,239)
                 Med B - PT                     0      0.00       0       0     3,744     11.55       0     3,744
                 Med B - OT                  1,154     67.86      0    1,154    3,587     11.07       0     3,587
                 Med B - ST                  2,350    138.25      0    2,350    3,615     11.16       0     3,615
                 Med B - 2% Reduction         (24)    (1.43)      0      (24)    (75)     (0.23)      0      (75)
                 TOTAL MEDICARE PART B       1,494     87.89      0    1,494    4,632     14.30       0     4,632
                 OTHER INCOME
                 Acuity Revenue Accrual     59,897     72.25      0    59,897   59,897    10.10       0    59,897
                 Other Income - Discounts       0      0.00       0       0       150      0.03       0      150
                 TOTAL OTHER INCOME         59,897     72.25      0    59,897   60,047    10.13       0    60,047
            TOTAL REVENUE                  211,095    254.64      0   211,095  1,026,221  173.09      0  1,026,221
   1   2   3   4   5   6   7   8   9   10