Page 4 - Financial Workbook September
P. 4

Date:  Oct 25, 2017               Towne Square Care of Puryear - SNF
            Time: 17:23:04 CT                       INCOME STATEMENT
            User:  Zach Bell                         8/1/2017 to 9/30/2017                                Page # 3

                                                   CURRENT PERIOD                       YEAR TO DATE
                                          Actual $  Actual / Day  Budget $  Var $  Actual $  Actual / Day  Budget $  Var $
                 ACTIVITIES
                 Payroll Exp - Wages - OT      0       0.00       0       0      573       0.07       0      573
                 Payroll Exp - Wages - Regular  3,537  1.74       0    3,537   14,091      1.73       0    14,091
                 Resident Entertainment       71       0.03       0      71      403       0.05       0      403
                 Resident Entertainment-ALF  (71)     (0.03)      0     (71)       0       0.00       0        0
                 Supplies - Non-Medical       48       0.02       0      48      392       0.05       0      392
                 Supplies - Non-Medical-ALF   (48)    (0.02)      0     (48)       0       0.00       0        0
                 Supplies - Office             8       0.00       0       8       48       0.01       0       48
                 Supplies - Office-ALF        (8)      0.00       0      (8)       0       0.00       0        0
                 TOTAL ACTIVITIES           3,537      1.74       0    3,537   15,507      1.90       0    15,507
                 LAUNDRY
                 Linen expense               384       0.19       0     384     1,033      0.13       0     1,033
                 Linen expense-ALF            82       0.04       0      82      219       0.03       0      219
                 Payroll Exp - Wages - OT    163       0.08       0     163      772       0.09       0      772
                 Payroll Exp - Wages - Regular  5,619  2.76       0    5,619   19,342      2.37       0    19,342
                 Small equipment purchases     0       0.00       0       0     1,177      0.14       0     1,177
                 Supplies - Chemicals        393       0.19       0     393     1,886      0.23       0     1,886
                 Supplies - Chemicals-ALF     83       0.04       0      83      244       0.03       0      244
                 Supplies - Non-Medical      244       0.12       0     244      244       0.03       0      244
                 Supplies - Non-Medical-ALF   (8)      0.00       0      (8)      (8)      0.00       0       (8)
                 TOTAL LAUNDRY              6,960      3.42       0    6,960   24,909      3.06       0    24,909
                 HOUSEKEEPING
                 Employee Screening & Hiring   60      0.03       0      60       60       0.01       0       60
                 Payroll Exp - Wages - OT   1,155      0.57       0    1,155    3,342      0.41       0     3,342
                 Payroll Exp - Wages - Regular  5,552  2.73       0    5,552   20,463      2.51       0    20,463
                 Payroll Exp - Wages - Supervis  3,093  1.52      0    3,093    7,147      0.88       0     7,147
                 Small equipment purchases   525       0.26       0     525     3,002      0.37       0     3,002
                 Small equipment purchases-ALF  (525)  (0.26)     0     (525)      0       0.00       0        0
                 Supplies - Chemicals        750       0.37       0     750     4,564      0.56       0     4,564
                 Supplies - Chemicals-ALF    158       0.08       0     158     1,196      0.15       0     1,196
                 Supplies - Non-Medical     1,255      0.62       0    1,255    4,072      0.50       0     4,072
                 Supplies - Non-Medical -ALF  (267)   (0.13)      0     (267)     85       0.01       0       85
                 TOTAL HOUSEKEEPING        11,757      5.77       0   11,757   43,931      5.39       0    43,931
                 PLANT AND MAINTENANCE
                 Equipment Rental - Non-Medical  0     0.00       0       0       38       0.00       0       38
                 Payroll Exp - Wages - Supervis  5,386  2.64      0    5,386   19,930      2.45       0    19,930
                 Payroll Exp-Maint Super-OT  294       0.14       0     294     1,235      0.15       0     1,235
                 Repairs & Maint - Building  452       0.22       0     452     5,983      0.73       0     5,983
                 Repairs & Maint - Building-ALF  96    0.05       0      96     1,185      0.15       0     1,185
                 Repairs & Maint - Equipment   0       0.00       0       0     1,974      0.24       0     1,974
                 Repairs & Maint -Equipment-ALF  0     0.00       0       0      419       0.05       0      419
                 Repairs & Maint - Grounds  1,394      0.68       0    1,394    4,595      0.56       0     4,595
                 Repairs & Maint - Grounds-ALF  296    0.15       0     296      975       0.12       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
                 Utilities - Cable           528       0.26       0     528     1,956      0.24       0     1,956
                 Utilities - Cable-ALF       112       0.05       0     112      349       0.04       0      349
                 Utilities - Electricity    7,098      3.48       0    7,098   24,369      2.99       0    24,369
                 Utilities - Electricity-ALF  1,506    0.74       0    1,506    5,169      0.63       0     5,169
                 Utilities - Gas             327       0.16       0     327     1,889      0.23       0     1,889
                 Utilities - Gas-ALF          69       0.03       0      69      401       0.05       0      401
                 Utilities - Pest Control    107       0.05       0     107      429       0.05       0      429
                 Utilities - Pest Control-ALF  23      0.01       0      23       91       0.01       0       91
                 Utilities - Security & Fire  763      0.37       0     763     2,519      0.31       0     2,519
                 Utilities-Security & Fire-ALF  162    0.08       0     162      534       0.07       0      534
                 Utilities - Telephone       924       0.45       0     924     3,398      0.42       0     3,398
                 Utilities - Telephone-ALF   196       0.10       0     196      721       0.09       0      721
                 Utilities - Trash disposal  581       0.29       0     581     2,941      0.36       0     2,941
                 Utilities - Trash disposal-ALF  123   0.06       0     123      624       0.08       0      624
                 Utilities - Water and sewer  1,762    0.87       0    1,762    7,941      0.97       0     7,941
                 Utilities-Water and sewer-ALF  374    0.18       0     374     1,685      0.21       0     1,685
                 TOTAL PLANT AND MAINTENANCE  22,572  11.08       0   22,572   91,361     11.21       0    91,361
                 GENERAL AND ADMINISTRATIVE
                 Bank Charges                 24       0.01       0      24      194       0.02       0      194
                 Bank Charges-ALF             (4)      0.00       0      (4)       0       0.00       0        0
   1   2   3   4   5   6   7   8   9