Page 4 - Financial Workbook December
P. 4

Date:  Jan 19, 2018                  Towne Square Care of Puryear - SNF
       Time: 17:51:55 CT                           INCOME STATEMENT
       User:  Zach Bell                            12/1/2017 to 12/31/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        168       0.14       84       85      1,068       0.09      902      166
            Payroll Exp - Wages - Regular  1,628      1.39     1,609      19     19,607       1.69    16,535    3,072
            Resident Entertainment           0        0.00       37      (37)      403        0.03      401        2
            Supplies - Non-Medical           0        0.00       37      (37)      404        0.03      401        3
            Supplies - Office                0        0.00        9       (9)       48        0.00      100      (52)
            TOTAL ACTIVITIES              1,796       1.54     1,776      20     21,531       1.86    18,338    3,192
            LAUNDRY
            Linen expense                    0        0.00      102     (102)     1,055       0.09     1,102     (47)
            Linen expense-ALF                0        0.00        5       (5)      224        0.02       53      170
            Payroll Exp - Wages - OT         97       0.08       84       13      1,022       0.09      902      121
            Payroll Exp - Wages - Regular  2,696      2.31     2,167     529     26,748       2.31    23,347    3,401
            Small equipment purchases        0        0.00      121     (121)     1,177       0.10     1,303    (126)
            Supplies - Chemicals             60       0.05      205     (144)     2,313       0.20     2,204     109
            Supplies - Chemicals-ALF         6        0.01        7       (1)      311        0.03       80      230
            Supplies - Non-Medical           0        0.00       28      (28)      297        0.03      301       (4)
            Supplies - Non-Medical-ALF       0        0.00        0        0         7        0.00        0        7
            TOTAL LAUNDRY                 2,860       2.45     2,719     141     33,154       2.86    29,292    3,862
            HOUSEKEEPING
            Employee Screening & Hiring      0        0.00        9       (9)       60        0.01      100      (40)
            Payroll Exp - Wages - OT        572       0.49      419      154      5,434       0.47     4,509     925
            Payroll Exp - Wages - Regular  1,851      1.58     2,232    (381)    25,877       2.23    24,048    1,829
            Payroll Exp - Wages - Supervis  1,632     1.40      893      739     12,203       1.05     9,619    2,584
            Small equipment purchases     1,109       0.95      335      774      4,439       0.38     3,607     832
            Small equipment purchases-ALF   235       0.20        2      233       305        0.03       27      278
            Supplies - Chemicals            294       0.25      502     (208)     5,743       0.50     5,411     332
            Supplies - Chemicals-ALF         11       0.01       35      (23)     1,389       0.12      374     1,015
            Supplies - Non-Medical          574       0.49      446      128      5,433       0.47     4,810     624
            Supplies - Non-Medical -ALF      15       0.01        5       10       203        0.02       53      150
            TOTAL HOUSEKEEPING            6,294       5.38     4,878    1,416    61,086       5.27    52,558    8,528
            PLANT AND MAINTENANCE
            Equipment Rental - Non-Medical   0        0.00        0        0        38        0.00        0       38
            Payroll Exp - Wages - Supervis  2,315     1.98     2,196     119     27,565       2.38    24,376    3,190
            Payroll Exp-Maint Super-OT       57       0.05      130      (73)     1,563       0.13     1,403     161
            Repairs & Maint - Building       0        0.00      605     (604)     7,993       0.69     6,513    1,480
            Repairs & Maint - Building-ALF   0        0.00       32      (32)     1,611       0.14      347     1,264
            Repairs & Maint - Equipment   1,646       1.41      214     1,432     3,736       0.32     2,305    1,431
            Repairs & Maint -Equipment-ALF   0        0.00       12      (12)      443        0.04      134      310
            Repairs & Maint - Grounds        0        0.00      465     (465)     5,292       0.46     5,010     282
            Repairs & Maint - Grounds-ALF    0        0.00       27      (27)     1,123       0.10      294      829
            Supplies - Non-Medical           18       0.02        0       18        28        0.00        0       28
            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               282       0.24      223       58      2,772       0.24     2,405     367
            Utilities - Cable-ALF            60       0.05       10       50       522        0.05      107      415
            Utilities - Electricity       8,336       7.13     2,734    5,602    34,887       3.01    29,459    5,428
            Utilities - Electricity-ALF     683       0.58      154      529      6,315       0.54     1,657    4,658
            Utilities - Gas                 225       0.19      205       21      2,681       0.23     2,204     477
            Utilities - Gas-ALF              48       0.04       12       35       569        0.05      134      435
            Utilities - Pest Control         54       0.05       47        7       590        0.05      501       89
            Utilities - Pest Control-ALF     11       0.01        2        9       125        0.01       27       98
            Utilities - Security & Fire     268       0.23      335      (67)     3,701       0.32     3,607      94
            Utilities-Security & Fire-ALF    57       0.05       20       37       785        0.07      214      571
            Utilities - Telephone           380       0.33      381       (1)     4,576       0.39     4,108     468
            Utilities - Telephone-ALF        81       0.07       22       58       971        0.08      240      730
            Utilities - Trash disposal      299       0.26      326      (27)     3,830       0.33     3,507     323
            Utilities - Trash disposal-ALF   63       0.05       17       46       812        0.07      187      625
            Utilities - Water and sewer      0        0.00      874     (874)     9,702       0.84     9,419     283
            Utilities-Water and sewer-ALF    0        0.00       50      (50)     2,058       0.18      534     1,524
            TOTAL PLANT AND MAINTENANCE  14,884      12.73     9,094    5,791   124,312      10.73    98,691   25,622
            GENERAL AND ADMINISTRATIVE
            Bank Charges                     0        0.00       19      (19)      194        0.02      200       (6)
            Conferences & Seminars           0        0.00      251     (251)     2,475       0.21     2,705    (230)
   1   2   3   4   5   6   7   8   9