Page 2 - Financial April Workbook
P. 2

Date:  Jul 22, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 15:06:17 EDT                          INCOME STATEMENT
      User:  Zach Bell                             4/1/2018 to 4/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           14,880     160.00       0    14,880    69,760    160.00        0    69,760
          Med A - Contract. Adj.         26,079     280.42       0    26,079    96,205    220.65        0    96,205
          Med A - Pharmacy                   0       0.00        0        0     11,409     26.17        0    11,409
          Med A - PT                     11,264     121.12       0    11,264    28,296     64.90        0    28,296
          Med A - OT                     18,549     199.45       0    18,549    96,013    220.21        0    96,013
          Med A - ST                     15,163     163.05       0    15,163    71,427    163.82        0    71,427
          Med A - Anc. Contract. Adj.   (44,976)   (483.61)      0   (44,976)  (207,146)  (475.11)      0  (207,146)
          Med A - 2% Reduction            (678)     (7.30)       0     (678)    (2,297)    (5.27)       0    (2,297)
          TOTAL MEDICARE PART A          40,280     433.12       0    40,280   163,668    375.39        0    163,668
          PRIVATE PAY
          Private - Room & Board         24,675     188.36       0    24,675    70,130    192.66        0    70,130
          Private - Pharmacy                 0       0.00        0        0      (595)     (1.63)       0      (595)
          Private - PT                     496       3.78        0      496      1,217      3.34        0     1,217
          Private - OT                       0       0.00        0        0       365       1.00        0       365
          Private - ST                     425       3.25        0      425       283       0.78        0       283
          TOTAL PRIVATE PAY              25,596     195.39       0    25,596    71,401    196.16        0    71,401
          MEDICAID
          Medicaid - Room & Board        99,720     162.94       0    99,720   383,340    162.98        0    383,340
          Medicaid - Contract. Adj.       4,914      8.03        0     4,914    18,781      7.99        0    18,781
          Medicaid - Pharmacy                0       0.00        0        0       733       0.31        0       733
          Medicaid - Anc. Contract Adj.      0       0.00        0        0      (733)     (0.31)       0      (733)
          TOTAL MEDICAID                104,634     170.97       0   104,634   402,121    170.97        0    402,121
          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                       0          -        0        0      3,667    118.28        0     3,667
          Managed - OT                       0          -        0        0      5,077    163.77        0     5,077
          Managed - ST                       0          -        0        0      5,364    173.04        0     5,364
          Managed - Anc. Contract. Adj.      0          -        0        0    (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,379     172.99       0    10,379    43,055    172.91        0    43,055
          Hospice - Contract. Adj.        (121)     (2.01)       0     (121)     (484)     (1.94)       0      (484)
          Hospice - Pharmacy                 0       0.00        0        0        22       0.09        0        22
          Hospice - Anc. Contract. Adj.      0       0.00        0        0       (22)     (0.09)       0      (22)
          TOTAL HOSPICE                  10,258     170.97       0    10,258    42,572    170.97        0    42,572
          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.         (7,781)   (83.67)       0    (7,781)   (9,299)   (21.33)       0    (9,299)
          Med B - PT                      5,189      55.79       0     5,189    14,732     33.79        0    14,732
          Med B - OT                      6,265      67.36       0     6,265      359       0.82        0       359
          Med B - ST                      4,058      43.63       0     4,058     6,391     14.66        0     6,391
          Med B - 2% Reduction            (124)     (1.33)       0     (124)     (196)     (0.45)       0      (196)
          TOTAL MEDICARE PART B           7,607      81.79       0     7,607    11,987     27.49        0    11,987
          OTHER INCOME
          Other Income - Miscellaneous     300       0.33        0      300      4,329      1.05        0     4,329
          TOTAL OTHER INCOME               300       0.33        0      300      4,329      1.05        0     4,329
      TOTAL REVENUE                     188,675     210.57       0   188,675   743,625    180.67        0    743,625
   1   2   3   4   5   6   7