Page 3 - Financial Workbook November

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 # 2

CURRENT PERIOD YEAR TO DATE
Actual $ Actual / Day Budget $ Var $ Actual $ Actual / Day Budget $ Var $
DEPARTMENTAL ROUTINE EXPENSES
NURSING
Payroll Exp-Wages-Univer-OT 694 0.61 238 457 9,918 0.95 2,400 7,518
Employee Screening & Hiring 0 0.00 18 (18) 180 0.02 182 (2)
Medical Director 1,031 0.90 1,368 (337) 15,156 1.45 13,817 1,339
Medical Director-ALF 219 0.19 22 197 1,094 0.10 218 876
Medical Records Expense 0 0.00 72 (72) 716 0.07 727 (11)
Payroll Exp - Payroll Taxes 1,680 1.46 297 1,383 4,725 0.45 3,000 1,725
Payroll Exp - Wages - OT 1,708 1.49 1,305 403 15,202 1.46 13,181 2,021
Payroll Exp - Wages - CNA 13,676 11.92 13,959 (283) 157,483 15.11 140,986 16,497
Payroll Exp - Wages - DON 5,029 4.38 4,644 385 52,881 5.07 46,904 5,976
Payroll Exp - Wages - LPN 12,341 10.76 10,404 1,937 119,582 11.48 105,080 14,502
Payroll Exp - Wages - MDS 2,712 2.36 1,863 849 21,882 2.10 18,816 3,066
Payroll Exp - Wages - RN 2,916 2.54 2,223 693 25,849 2.48 22,452 3,397
TECH 0 0.00 0 0 2,079 0.20 0 2,079
Payroll Exp-Wages-Univer-ALF 8,465 7.38 1,714 6,751 74,677 7.17 17,307 57,370
Small equipment purchases 0 0.00 36 (36) 389 0.04 364 25
Supplies - Incontinence 579 0.51 684 (105) 7,637 0.73 6,908 729
Supplies - Incontinence-ALF 123 0.11 0 123 1,299 0.12 284 1,015
Supplies - Medical 1,723 1.50 1,152 571 13,581 1.30 11,635 1,946
Supplies - Medical-ALF 0 0.00 58 (58) 2,217 0.21 582 1,635
Supplies - Non-Medical 391 0.34 112 280 1,458 0.14 1,105 353
Supplies - Non-Medical-ALF 82 0.07 5 77 305 0.03 48 256
Consultants - Pharmacy 0 0.00 99 (99) 1,035 0.10 1,000 35
Consultants - Pharmacy-ALF 0 0.00 0 0 35 0.00 0 35
Legend Drugs 0 0.00 585 (585) 6,051 0.58 5,909 142
Legend Drug-ALF 0 0.00 2 (2) 133 0.01 24 109
Non-Legend Drugs 151 0.13 117 34 1,348 0.13 1,182 166
Non-Legend Drug-ALF 0 0.00 19 (19) 237 0.02 194 43
Supplies - Non-Medical 0 0.00 27 (27) 233 0.02 273 (39)
TOTAL NURSING 53,519 46.66 41,021 12,498 537,381 51.57 414,578 122,803
THERAPY
Payroll Exp - Wages -Therapist 3,380 - 0 3,380 32,118 - 0 32,118
Employee Screening & Hiring 0 - 0 0 30 - 0 30
Payroll Exp - Wages -Therapist 4,843 - 0 4,843 39,061 - 0 39,061
Payroll Exp - Wages -Therapist 4,664 - 0 4,664 31,939 - 0 31,939
Employee Screening & Hiring 0 - 0 0 30 - 0 30
Supplies - Medical 112 - 0 112 112 - 0 112
TOTAL THERAPY 12,999 - 0 12,999 103,289 - 0 103,289
DIETARY
Consultants - Dietary 386 0.34 81 305 1,264 0.12 818 446
Consultants - Dietary-ALF 82 0.07 2 80 166 0.02 24 142
Employee Function Expense 0 0.00 0 0 25 0.00 0 25
Employee Screening & Hiring 0 0.00 0 0 21 0.00 0 21
Equipment Rental - Non-Medical 0 0.00 18 (18) 206 0.02 182 25
Equip Rental-Non-Medical-ALF 0 0.00 0 0 29 0.00 0 29
Food Supplements 551 0.48 900 (349) 9,864 0.95 9,090 774
Food Supplements-ALF 117 0.10 31 86 1,286 0.12 315 971
Miscellaneous Expense 0 0.00 36 (36) 330 0.03 364 (34)
Miscellaneous Expense-ALF 0 0.00 2 (2) 70 0.01 24 46
Payroll Exp - Wages - OT 419 0.37 288 131 3,366 0.32 2,909 457
Payroll Exp - Wages - Regular 4,438 3.87 3,708 730 42,601 4.09 37,451 5,150
Payroll Exp - Wages - Supervis 2,808 2.45 2,583 225 29,457 2.83 26,088 3,369
Raw Food Expense 5,607 4.89 5,643 (36) 59,614 5.72 56,994 2,619
Raw Food Expense-ALF 1,190 1.04 1,197 (7) 12,716 1.22 12,090 627
Repairs & Maintenance - Equip 248 0.22 117 131 1,462 0.14 1,182 281
Repairs- Maintenance-Equip-ALF 53 0.05 0 53 98 0.01 0 98
Small equipment purchases 0 0.00 180 (180) 1,872 0.18 1,818 54
Small equipment purchases-ALF 0 0.00 10 (10) 397 0.04 97 300
Supplies - Chemicals 105 0.09 162 (57) 1,742 0.17 1,636 106
Supplies - Chemicals-ALF 19 0.02 2 17 152 0.01 24 128
Supplies - Non-Medical 279 0.24 207 72 2,392 0.23 2,091 301
Supplies - Non-Medical-ALF 49 0.04 2 47 117 0.01 24 93
TOTAL DIETARY 16,350 14.25 15,170 1,180 169,249 16.24 153,221 16,028
SOCIAL SERVICES