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