Page 3 - Financial Workbook October
P. 3

Date:  Dec 4, 2017                Towne Square Care of Puryear - SNF
            Time: 16:52:35 CT                       INCOME STATEMENT
            User:  Zach Bell                        10/1/2017 to 10/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,384    1.23       0    1,384    9,224      0.99       0     9,224
                 Employee Screening & Hiring   0       0.00       0       0      180       0.02       0      180
                 Medical Director           2,063      1.83       0    2,063   14,125      1.52       0    14,125
                 Medical Director-ALF        438       0.39       0      438     875       0.09       0      875
                 Medical Records Expense       0       0.00       0       0      716       0.08       0      716
                 Payroll Exp - Payroll Taxes  1,626    1.44       0    1,626    3,045      0.33       0     3,045
                 Payroll Exp - Wages - OT    849       0.75       0      849   13,493      1.45       0    13,493
                 Payroll Exp - Wages - CNA  13,617    12.09       0   13,617   143,807    15.51       0   143,807
                 Payroll Exp - Wages - DON  5,029      4.47       0    5,029   47,852      5.16       0    47,852
                 Payroll Exp - Wages - LPN  11,426    10.15       0   11,426   107,241    11.56       0   107,241
                 Payroll Exp - Wages - MDS  1,916      1.70       0    1,916   19,171      2.07       0    19,171
                 Payroll Exp - Wages - RN   2,633      2.34       0    2,633   22,933      2.47       0    22,933
                 TECH                          0       0.00       0       0     2,079      0.22       0     2,079
                 Payroll Exp-Wages-Univer-ALF  8,139   7.23       0    8,139   66,212      7.14       0    66,212
                 Small equipment purchases     0       0.00       0       0      389       0.04       0      389
                 Supplies - Incontinence       0       0.00       0       0     7,058      0.76       0     7,058
                 Supplies - Incontinence-ALF   0       0.00       0       0     1,176      0.13       0     1,176
                 Supplies - Medical         1,506      1.34       0    1,506   11,858      1.28       0    11,858
                 Supplies - Medical-ALF      241       0.21       0      241    2,217      0.24       0     2,217
                 Supplies - Non-Medical        0       0.00       0       0     1,067      0.12       0     1,067
                 Supplies - Non-Medical-ALF    0       0.00       0       0      223       0.02       0      223
                 Consultants - Pharmacy        0       0.00       0       0     1,035      0.11       0     1,035
                 Consultants - Pharmacy-ALF    0       0.00       0       0       35       0.00       0       35
                 Legend Drugs                  0       0.00       0       0     6,051      0.65       0     6,051
                 Legend Drug-ALF               0       0.00       0       0      133       0.01       0      133
                 Non-Legend Drugs              4       0.00       0       4     1,197      0.13       0     1,197
                 Non-Legend Drug-ALF           1       0.00       0       1      237       0.03       0      237
                 Supplies - Non-Medical        0       0.00       0       0      233       0.03       0      233
                 TOTAL NURSING             50,871     45.18       0   50,871   483,862    52.17       0   483,862
                 THERAPY
                 Payroll Exp - Wages -Therapist  1,383   -        0    1,383   28,738        -        0    28,738
                 Employee Screening & Hiring   0         -        0       0       30         -        0       30
                 Payroll Exp - Wages -Therapist  6,560   -        0    6,560   34,217        -        0    34,217
                 Payroll Exp - Wages -Therapist  8,511   -        0    8,511   27,274        -        0    27,274
                 Employee Screening & Hiring   0         -        0       0       30         -        0       30
                 TOTAL THERAPY             16,454        -        0   16,454   90,289        -        0    90,289
                 DIETARY
                 Consultants - Dietary       397       0.35       0      397     878       0.09       0      878
                 Consultants - Dietary-ALF    84       0.07       0      84       84       0.01       0       84
                 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       0       0      206       0.02       0      206
                 Equip Rental-Non-Medical-ALF  0       0.00       0       0       29       0.00       0       29
                 Food Supplements              0       0.00       0       0     9,313      1.00       0     9,313
                 Food Supplements-ALF          0       0.00       0       0     1,169      0.13       0     1,169
                 Miscellaneous Expense       330       0.29       0      330     330       0.04       0      330
                 Miscellaneous Expense-ALF    70       0.06       0      70       70       0.01       0       70
                 Payroll Exp - Wages - OT    243       0.22       0      243    2,947      0.32       0     2,947
                 Payroll Exp - Wages - Regular  4,392  3.90       0    4,392   38,163      4.12       0    38,163
                 Payroll Exp - Wages - Supervis  2,248  2.00      0    2,248   26,649      2.87       0    26,649
                 Raw Food Expense           7,511      6.67       0    7,511   54,007      5.82       0    54,007
                 Raw Food Expense-ALF       1,593      1.41       0    1,593   11,526      1.24       0    11,526
                 Repairs & Maintenance - Equip  0      0.00       0       0     1,215      0.13       0     1,215
                 Repairs- Maintenance-Equip-ALF  0     0.00       0       0       46       0.00       0       46
                 Small equipment purchases     0       0.00       0       0     1,872      0.20       0     1,872
                 Small equipment purchases-ALF  0      0.00       0       0      397       0.04       0      397
                 Supplies - Chemicals        362       0.32       0      362    1,638      0.18       0     1,638
                 Supplies - Chemicals-ALF     77       0.07       0      77      133       0.01       0      133
                 Supplies - Non-Medical      247       0.22       0      247    2,113      0.23       0     2,113
                 Supplies - Non-Medical-ALF   30       0.03       0      30       68       0.01       0       68
                 TOTAL DIETARY             17,583     15.62       0   17,583   152,899    16.49       0   152,899
                 SOCIAL SERVICES
                 TOTAL SOCIAL SERVICES         0       0.00       0       0        0       0.00       0        0
   1   2   3   4   5   6   7   8