Page 4 - Financial Workbook October
P. 4

Date:  Dec 4, 2017                Towne Square Care of Puryear - SNF
            Time: 16:52:35 CT                       INCOME STATEMENT
            User:  Zach Bell                        10/1/2017 to 10/31/2017                               Page # 3

                                                  CURRENT PERIOD                        YEAR TO DATE
                                          Actual $  Actual / Day  Budget $  Var $  Actual $  Actual / Day  Budget $  Var $
                 ACTIVITIES
                 Payroll Exp - Wages - OT    224       0.20       0     224      797       0.09       0      797
                 Payroll Exp - Wages - Regular  1,968  1.75       0    1,968   16,058      1.73       0    16,058
                 Resident Entertainment        0       0.00       0       0      403       0.04       0      403
                 Supplies - Non-Medical       12       0.01       0      12      404       0.04       0      404
                 Supplies - Office             0       0.00       0       0       48       0.01       0       48
                 TOTAL ACTIVITIES           2,204      1.96       0    2,204   17,711      1.91       0    17,711
                 LAUNDRY
                 Linen expense                 0       0.00       0       0     1,033      0.11       0     1,033
                 Linen expense-ALF             0       0.00       0       0      219       0.02       0      219
                 Payroll Exp - Wages - OT     21       0.02       0      21      793       0.09       0      793
                 Payroll Exp - Wages - Regular  2,244  1.99       0    2,244   21,586      2.33       0    21,586
                 Small equipment purchases     0       0.00       0       0     1,177      0.13       0     1,177
                 Supplies - Chemicals        144       0.13       0     144     2,030      0.22       0     2,030
                 Supplies - Chemicals-ALF     19       0.02       0      19      263       0.03       0      263
                 Supplies - Non-Medical        0       0.00       0       0      244       0.03       0      244
                 Supplies - Non-Medical-ALF    0       0.00       0       0       (8)      0.00       0       (8)
                 TOTAL LAUNDRY              2,427      2.16       0    2,427   27,336      2.95       0    27,336
                 HOUSEKEEPING
                 Employee Screening & Hiring   0       0.00       0       0       60       0.01       0       60
                 Payroll Exp - Wages - OT    811       0.72       0     811     4,153      0.45       0     4,153
                 Payroll Exp - Wages - Regular  1,835  1.63       0    1,835   22,298      2.40       0    22,298
                 Payroll Exp - Wages - Supervis  1,795  1.59      0    1,795    8,942      0.96       0     8,942
                 Small equipment purchases   329       0.29       0     329     3,330      0.36       0     3,330
                 Small equipment purchases-ALF  70     0.06       0      70       70       0.01       0       70
                 Supplies - Chemicals        411       0.37       0     411     4,975      0.54       0     4,975
                 Supplies - Chemicals-ALF     99       0.09       0      99     1,295      0.14       0     1,295
                 Supplies - Non-Medical      421       0.37       0     421     4,493      0.48       0     4,493
                 Supplies - Non-Medical -ALF  56       0.05       0      56      141       0.02       0      141
                 TOTAL HOUSEKEEPING         5,827      5.17       0    5,827   49,758      5.37       0    49,758
                 PLANT AND MAINTENANCE
                 Equipment Rental - Non-Medical  0     0.00       0       0       38       0.00       0       38
                 Payroll Exp - Wages - Supervis  2,659  2.36      0    2,659   22,589      2.44       0    22,589
                 Payroll Exp-Maint Super-OT   91       0.08       0      91     1,326      0.14       0     1,326
                 Repairs & Maint - Building    0       0.00       0       0     5,983      0.65       0     5,983
                 Repairs & Maint - Building-ALF  0     0.00       0       0     1,185      0.13       0     1,185
                 Repairs & Maint - Equipment  116      0.10       0     116     2,090      0.23       0     2,090
                 Repairs & Maint -Equipment-ALF  25    0.02       0      25      443       0.05       0      443
                 Repairs & Maint - Grounds     0       0.00       0       0     4,595      0.50       0     4,595
                 Repairs & Maint - Grounds-ALF  0      0.00       0       0      975       0.11       0      975
                 Supplies - Non-Medical        0       0.00       0       0        9       0.00       0        9
                 Supplies - Non-Medical-ALF    0       0.00       0       0        2       0.00       0        2
                 Travel Expenses - Mileage    21       0.02       0      21       21       0.00       0       21
                 Utilities - Cable           261       0.23       0     261     2,217      0.24       0     2,217
                 Utilities - Cable-ALF        55       0.05       0      55      404       0.04       0      404
                 Utilities - Electricity    2,941      2.61       0    2,941   27,310      2.94       0    27,310
                 Utilities - Electricity-ALF  624      0.55       0     624     5,793      0.62       0     5,793
                 Utilities - Gas             154       0.14       0     154     2,042      0.22       0     2,042
                 Utilities - Gas-ALF          33       0.03       0      33      433       0.05       0      433
                 Utilities - Pest Control     54       0.05       0      54      483       0.05       0      483
                 Utilities - Pest Control-ALF  11      0.01       0      11      102       0.01       0      102
                 Utilities - Security & Fire  784      0.70       0     784     3,302      0.36       0     3,302
                 Utilities-Security & Fire-ALF  166    0.15       0     166      701       0.08       0      701
                 Utilities - Telephone       405       0.36       0     405     3,802      0.41       0     3,802
                 Utilities - Telephone-ALF    86       0.08       0      86      807       0.09       0      807
                 Utilities - Trash disposal  296       0.26       0     296     3,238      0.35       0     3,238
                 Utilities - Trash disposal-ALF  63    0.06       0      63      687       0.07       0      687
                 Utilities - Water and sewer  795      0.71       0     795     8,736      0.94       0     8,736
                 Utilities-Water and sewer-ALF  169    0.15       0     169     1,853      0.20       0     1,853
                 TOTAL PLANT AND MAINTENANCE  9,805    8.71       0    9,805  101,166     10.91       0   101,166
                 GENERAL AND ADMINISTRATIVE
                 Bank Charges                  0       0.00       0       0      194       0.02       0      194
                 Conferences & Seminars        0       0.00       0       0     2,475      0.27       0     2,475
                 Conferences & Seminars-ALF    0       0.00       0       0      525       0.06       0      525
                 Employee Function Expense     0       0.00       0       0       33       0.00       0       33
   1   2   3   4   5   6   7   8   9