Page 3 - Financial Workbook December

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 # 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,100 0.94 246 855 11,018 0.95 2,645 8,373
Employee Screening & Hiring 0 0.00 19 (19) 180 0.02 200 (20)
Medical Director 1,031 0.88 1,414 (382) 16,188 1.40 15,230 957
Medical Director-ALF 219 0.19 22 196 1,313 0.11 240 1,072
Medical Records Expense 0 0.00 74 (74) 716 0.06 802 (85)
Payroll Exp - Payroll Taxes 780 0.67 307 473 5,505 0.48 3,307 2,199
Payroll Exp - Wages - OT 868 0.74 1,349 (480) 16,070 1.39 14,529 1,541
Payroll Exp - Wages - CNA 8,329 7.13 14,424 (6,095) 165,812 14.31 155,410 10,402
Payroll Exp - Wages - DON 5,551 4.75 4,799 752 58,432 5.04 51,703 6,729
Payroll Exp - Wages - LPN 18,839 16.12 10,751 8,088 138,421 11.94 115,831 22,590
Payroll Exp - Wages - MDS 2,512 2.15 1,925 587 24,395 2.10 20,741 3,653
Payroll Exp - Wages - RN 2,549 2.18 2,297 252 28,398 2.45 24,749 3,649
TECH 0 0.00 0 0 2,079 0.18 0 2,079
Payroll Exp-Wages-Univer-ALF 9,265 7.93 1,771 7,494 83,942 7.24 19,078 64,864
Small equipment purchases 0 0.00 37 (37) 389 0.03 401 (12)
Supplies - Incontinence 869 0.74 707 162 8,506 0.73 7,615 891
Supplies - Incontinence-ALF 184 0.16 31 153 1,483 0.13 315 1,168
Supplies - Medical 815 0.70 1,190 (375) 14,397 1.24 12,826 1,571
Supplies - Medical-ALF 106 0.09 60 47 2,323 0.20 641 1,682
Supplies - Non-Medical 0 0.00 112 (112) 1,458 0.13 1,217 241
Supplies - Non-Medical-ALF 0 0.00 5 (5) 305 0.03 53 251
Consultants - Pharmacy 0 0.00 102 (102) 1,035 0.09 1,102 (67)
Consultants - Pharmacy-ALF 0 0.00 0 0 35 0.00 0 35
Legend Drugs 0 0.00 605 (604) 6,067 0.52 6,513 (446)
Legend Drug-ALF 0 0.00 2 (2) 133 0.01 27 106
Non-Legend Drugs 659 0.56 121 538 2,008 0.17 1,303 705
Non-Legend Drug-ALF 0 0.00 20 (20) 237 0.02 214 23
Supplies - Non-Medical 0 0.00 28 (28) 233 0.02 301 (67)
TOTAL NURSING 53,678 45.92 42,416 11,262 591,075 51.00 456,994 134,081
THERAPY
Payroll Exp - Wages -Therapist 2,151 - 0 2,151 34,268 - 0 34,268
Employee Screening & Hiring 0 - 0 0 30 - 0 30
Payroll Exp - Wages -Therapist 3,742 - 0 3,742 42,802 - 0 42,802
Payroll Exp - Wages -Therapist 3,385 - 0 3,385 35,324 - 0 35,324
Employee Screening & Hiring 0 - 0 0 30 - 0 30
Supplies - Medical 0 - 0 0 112 - 0 112
TOTAL THERAPY 9,278 - 0 9,278 112,566 - 0 112,566
DIETARY
Consultants - Dietary 0 0.00 84 (84) 1,264 0.11 902 362
Consultants - Dietary-ALF 0 0.00 2 (2) 166 0.01 27 139
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 19 (19) 206 0.02 200 6
Equip Rental-Non-Medical-ALF 0 0.00 0 0 29 0.00 0 29
Food Supplements 614 0.53 930 (316) 10,478 0.90 10,020 458
Food Supplements-ALF 130 0.11 32 98 1,417 0.12 347 1,069
Miscellaneous Expense 0 0.00 37 (37) 330 0.03 401 (71)
Miscellaneous Expense-ALF 0 0.00 2 (2) 70 0.01 27 43
Payroll Exp - Wages - OT 0 0.00 298 (298) 3,366 0.29 3,206 160
Payroll Exp - Wages - Regular 4,502 3.85 3,832 671 47,103 4.06 41,282 5,821
Payroll Exp - Wages - Supervis 2,753 2.35 2,669 83 32,210 2.78 28,757 3,452
Raw Food Expense 5,753 4.92 5,831 (78) 65,366 5.64 62,825 2,541
Raw Food Expense-ALF 1,220 1.04 1,237 (17) 13,937 1.20 13,327 610
Repairs & Maintenance - Equip 0 0.00 121 (121) 1,462 0.13 1,303 160
Repairs- Maintenance-Equip-ALF 0 0.00 0 0 98 0.01 0 98
Small equipment purchases 0 0.00 186 (186) 1,872 0.16 2,004 (132)
Small equipment purchases-ALF 0 0.00 10 (10) 397 0.03 107 290
Supplies - Chemicals 231 0.20 167 64 1,974 0.17 1,804 170
Supplies - Chemicals-ALF 34 0.03 2 31 186 0.02 27 159
Supplies - Non-Medical 134 0.11 214 (80) 2,526 0.22 2,305 221
Supplies - Non-Medical-ALF 28 0.02 2 26 146 0.01 27 119
TOTAL DIETARY 15,400 13.17 15,676 (276) 184,649 15.93 168,897 15,752
SOCIAL SERVICES