Page 4 - Financial Workbook November
P. 4

Date:  Dec 18, 2017               Towne Square Care of Puryear - SNF
            Time: 16:41:19 CT                       INCOME STATEMENT
            User:  Zach Bell                        11/1/2017 to 11/30/2017                               Page # 3

                                                   CURRENT PERIOD                       YEAR TO DATE
                                          Actual $  Actual / Day  Budget $  Var $  Actual $  Actual / Day  Budget $  Var $
                 SOCIAL SERVICES (con't)
                 TOTAL SOCIAL SERVICES         0       0.00       0       0        0       0.00       0        0
                 ACTIVITIES
                 Payroll Exp - Wages - OT    103       0.09      81      22      900       0.09      818      82
                 Payroll Exp - Wages - Regular  1,920  1.67    1,157    763    17,979      1.73   14,926    3,053
                 Resident Entertainment        0       0.00      36     (36)     403       0.04      364      40
                 Supplies - Non-Medical        0       0.00      36     (36)     404       0.04      364      40
                 Supplies - Office             0       0.00       9      (9)      48       0.00      91      (43)
                 TOTAL ACTIVITIES           2,023      1.76    1,319    704    19,734      1.89   16,562    3,172
                 LAUNDRY
                 Linen expense                23       0.02      99     (76)    1,055      0.10    1,000      55
                 Linen expense-ALF             5       0.00       5       0      224       0.02      48      175
                 Payroll Exp - Wages - OT    132       0.12      81      51      925       0.09      818     107
                 Payroll Exp - Wages - Regular  2,466  2.15    2,097    369    24,052      2.31   21,180    2,872
                 Small equipment purchases     0       0.00     117    (117)    1,177      0.11    1,182      (5)
                 Supplies - Chemicals        223       0.19     198      25     2,253      0.22    2,000     253
                 Supplies - Chemicals-ALF     41       0.04       7      34      304       0.03      73      231
                 Supplies - Non-Medical       53       0.05      27      26      297       0.03      273      24
                 Supplies - Non-Medical-ALF   15       0.01       0      15        7       0.00       0        7
                 TOTAL LAUNDRY              2,958      2.58    2,631    327    30,294      2.91   26,573    3,721
                 HOUSEKEEPING
                 Employee Screening & Hiring   0       0.00       9      (9)      60       0.01      91      (31)
                 Payroll Exp - Wages - OT    708       0.62     405     303     4,861      0.47    4,091     771
                 Payroll Exp - Wages - Regular  1,728  1.51    2,160   (432)   24,026      2.31   21,816    2,210
                 Payroll Exp - Wages - Supervis  1,629  1.42    864     765    10,571      1.01    8,726    1,844
                 Small equipment purchases     0       0.00     324    (324)    3,330      0.32    3,272      58
                 Small equipment purchases-ALF  0      0.00       2      (2)      70       0.01      24       45
                 Supplies - Chemicals        473       0.41     486     (13)    5,448      0.52    4,909     540
                 Supplies - Chemicals-ALF     83       0.07      34      49     1,378      0.13      339    1,038
                 Supplies - Non-Medical      366       0.32     432     (66)    4,859      0.47    4,363     496
                 Supplies - Non-Medical -ALF  47       0.04       5      42      188       0.02      48      140
                 TOTAL HOUSEKEEPING         5,034      4.39    4,721    313    54,792      5.26   47,680    7,112
                 PLANT AND MAINTENANCE
                 Equipment Rental - Non-Medical  0     0.00       0       0       38       0.00       0       38
                 Payroll Exp - Wages - Supervis  2,661  2.32   2,269    392    25,250      2.42   22,180    3,070
                 Payroll Exp-Maint Super-OT  180       0.16     126      54     1,506      0.14    1,273     234
                 Repairs & Maint - Building  2,011     1.75     585    1,426    7,993      0.77    5,909    2,085
                 Repairs & Maint - Building-ALF  426   0.37      31     395     1,611      0.15      315    1,296
                 Repairs & Maint - Equipment   0       0.00     207    (207)    2,090      0.20    2,091      (1)
                 Repairs & Maint -Equipment-ALF  0     0.00      12     (12)     443       0.04      121     322
                 Repairs & Maint - Grounds   697       0.61     450     247     5,292      0.51    4,545     747
                 Repairs & Maint - Grounds-ALF  148    0.13      26     121     1,123      0.11      267     856
                 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     0       0.00       0       0       21       0.00       0       21
                 Utilities - Cable           273       0.24     216      57     2,490      0.24    2,182     309
                 Utilities - Cable-ALF        58       0.05      10      48      462       0.04      97      365
                 Utilities - Electricity    3,022      2.63    2,646    376    26,550      2.55   26,725    (174)
                 Utilities - Electricity-ALF  641      0.56     149     492     5,632      0.54    1,503    4,129
                 Utilities - Gas             413       0.36     198     215     2,456      0.24    2,000     456
                 Utilities - Gas-ALF          88       0.08      12      76      521       0.05      121     400
                 Utilities - Pest Control     54       0.05      45       9      536       0.05      455      82
                 Utilities - Pest Control-ALF  11      0.01       2       9      114       0.01      24       90
                 Utilities - Security & Fire  131      0.11     324    (193)    3,433      0.33    3,272     161
                 Utilities-Security & Fire-ALF  28     0.02      19       8      728       0.07      194     534
                 Utilities - Telephone       394       0.34     369      25     4,196      0.40    3,727     469
                 Utilities - Telephone-ALF    83       0.07      22      62      890       0.09      218     672
                 Utilities - Trash disposal  294       0.26     315     (21)    3,532      0.34    3,182     350
                 Utilities - Trash disposal-ALF  62    0.05      17      46      749       0.07      170     579
                 Utilities - Water and sewer  966      0.84     846     120     9,702      0.93    8,545    1,157
                 Utilities-Water and sewer-ALF  205    0.18      48     157     2,058      0.20      485    1,573
                 TOTAL PLANT AND MAINTENANCE  12,846  11.20    8,944   3,902   109,428    10.50   89,597   19,831
                 GENERAL AND ADMINISTRATIVE
                 Bank Charges                  0       0.00      18     (18)     194       0.02      182      12
                 Conferences & Seminars        0       0.00     243    (243)    2,475      0.24    2,454      21
   1   2   3   4   5   6   7   8   9