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)