Page 3 - Financial Workbook September

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 # 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 1,544 0.76 0 1,544 7,840 0.96 0 7,840
Employee Screening & Hiring 180 0.09 0 180 180 0.02 0 180
Medical Director 5,875 2.88 0 5,875 12,063 1.48 0 12,063
Medical Director-ALF (875) (0.43) 0 (875) 438 0.05 0 438
Medical Records Expense 114 0.06 0 114 716 0.09 0 716
Medical Records-ALF (114) (0.06) 0 (114) 0 0.00 0 0
Payroll Exp - Payroll Taxes (4,025) (1.98) 0 (4,025) 1,419 0.17 0 1,419
Payroll Exp - Wages - OT 3,042 1.49 0 3,042 12,644 1.55 0 12,644
Payroll Exp - Wages - CNA 37,389 18.35 0 37,389 130,190 15.98 0 130,190
Payroll Exp - Wages - DON 12,872 6.32 0 12,872 42,824 5.26 0 42,824
Payroll Exp - Wages - LPN 29,328 14.40 0 29,328 95,815 11.76 0 95,815
Payroll Exp - Wages - MDS 4,578 2.25 0 4,578 17,254 2.12 0 17,254
Payroll Exp - Wages - RN 5,551 2.73 0 5,551 20,301 2.49 0 20,301
TECH 2,079 1.02 0 2,079 2,079 0.26 0 2,079
Payroll Exp-Wages-Univer-ALF 19,787 9.71 0 19,787 58,074 7.13 0 58,074
Small equipment purchases 0 0.00 0 0 389 0.05 0 389
Supplies - Incontinence 1,986 0.97 0 1,986 7,058 0.87 0 7,058
Supplies - Incontinence-ALF 421 0.21 0 421 1,176 0.14 0 1,176
Supplies - Medical 2,717 1.33 0 2,717 10,352 1.27 0 10,352
Supplies - Medical-ALF 523 0.26 0 523 1,976 0.24 0 1,976
Supplies - Non-Medical 0 0.00 0 0 1,067 0.13 0 1,067
Supplies - Non-Medical-ALF 0 0.00 0 0 223 0.03 0 223
Consultants - Pharmacy 317 0.16 0 317 1,035 0.13 0 1,035
Consultants - Pharmacy-ALF 0 0.00 0 0 35 0.00 0 35
Legend Drugs 1,048 0.51 0 1,048 6,051 0.74 0 6,051
Legend Drug-ALF 133 0.07 0 133 133 0.02 0 133
Non-Legend Drugs 523 0.26 0 523 1,192 0.15 0 1,192
Non-Legend Drug-ALF 99 0.05 0 99 236 0.03 0 236
Supplies - Non-Medical 0 0.00 0 0 233 0.03 0 233
TOTAL NURSING 125,092 61.41 0 125,092 432,991 53.14 0 432,991
THERAPY
Payroll Exp - Wages -Therapist 3,849 - 0 3,849 27,355 - 0 27,355
Employee Screening & Hiring 30 - 0 30 30 - 0 30
Payroll Exp - Wages -Therapist 9,219 - 0 9,219 27,657 - 0 27,657
Payroll Exp - Wages -Therapist 9,093 - 0 9,093 18,763 - 0 18,763
Employee Screening & Hiring 30 - 0 30 30 - 0 30
TOTAL THERAPY 22,222 - 0 22,222 73,835 - 0 73,835
DIETARY
Consultants - Dietary 126 0.06 0 126 481 0.06 0 481
Consultants - Dietary-ALF (75) (0.04) 0 (75) 0 0.00 0 0
Employee Function Expense 4 0.00 0 4 25 0.00 0 25
Employee Function Expense-ALF (4) 0.00 0 (4) 0 0.00 0 0
Employee Screening & Hiring 0 0.00 0 0 21 0.00 0 21
Equipment Rental - Non-Medical 69 0.03 0 69 206 0.03 0 206
Equip Rental-Non-Medical-ALF 15 0.01 0 15 29 0.00 0 29
Food Supplements 1,982 0.97 0 1,982 9,313 1.14 0 9,313
Food Supplements-ALF 377 0.19 0 377 1,169 0.14 0 1,169
Payroll Exp - Wages - OT 1,032 0.51 0 1,032 2,704 0.33 0 2,704
Payroll Exp - Wages - Regular 9,962 4.89 0 9,962 33,771 4.14 0 33,771
Payroll Exp - Wages - Supervis 7,955 3.91 0 7,955 24,402 2.99 0 24,402
Raw Food Expense 6,850 3.36 0 6,850 46,496 5.71 0 46,496
Raw Food Expense-ALF 1,453 0.71 0 1,453 9,933 1.22 0 9,933
Repairs & Maintenance - Equip 390 0.19 0 390 1,215 0.15 0 1,215
Repairs- Maintenance-Equip-ALF (130) (0.06) 0 (130) 46 0.01 0 46
Small equipment purchases 66 0.03 0 66 1,872 0.23 0 1,872
Small equipment purchases-ALF 14 0.01 0 14 397 0.05 0 397
Supplies - Chemicals 483 0.24 0 483 1,276 0.16 0 1,276
Supplies - Chemicals-ALF (30) (0.01) 0 (30) 56 0.01 0 56
Supplies - Non-Medical 460 0.23 0 460 1,866 0.23 0 1,866
Supplies - Non-Medical-ALF (90) (0.04) 0 (90) 39 0.00 0 39
TOTAL DIETARY 30,909 15.17 0 30,909 135,316 16.61 0 135,316
SOCIAL SERVICES
TOTAL SOCIAL SERVICES 0 0.00 0 0 0 0.00 0 0