Page 3 - Financial Workbook August
P. 3

Date:  Sep 15, 2017               Towne Square Care of Puryear - SNF
            Time: 13:50:09 CT                       INCOME STATEMENT
            User:  Zach Bell                         8/1/2017 to 8/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  463      0.46       0      463    6,759      0.95       0     6,759
                 Employee Screening & Hiring   180     0.18       0      180     180       0.03       0      180
                 Medical Director           1,031      1.02       0    1,031    7,219      1.01       0     7,219
                 Medical Director-ALF        219       0.22       0      219    1,531      0.21       0     1,531
                 Medical Records Expense       0       0.00       0       0      603       0.08       0      603
                 Medical Records-ALF           0       0.00       0       0      114       0.02       0      114
                 Payroll Exp - Payroll Taxes  157      0.15       0      157    5,601      0.79       0     5,601
                 Payroll Exp - Wages - OT    381       0.38       0      381    9,983      1.40       0     9,983
                 Payroll Exp - Wages - CNA  14,433    14.25       0   14,433   107,234    15.05       0   107,234
                 Payroll Exp - Wages - DON  5,029      4.96       0    5,029   34,981      4.91       0    34,981
                 Payroll Exp - Wages - LPN  12,380    12.22       0   12,380   78,867     11.07       0    78,867
                 Payroll Exp - Wages - MDS  1,699      1.68       0    1,699   14,376      2.02       0    14,376
                 Payroll Exp - Wages - RN   1,742      1.72       0    1,742   16,491      2.31       0    16,491
                 Payroll Exp-Wages-Univer-ALF  8,263   8.16       0    8,263   46,550      6.53       0    46,550
                 Small equipment purchases     0       0.00       0       0      389       0.05       0      389
                 Supplies - Incontinence     609       0.60       0      609    5,680      0.80       0     5,680
                 Supplies - Incontinence-ALF  129      0.13       0      129     884       0.12       0      884
                 Supplies - Medical         1,287      1.27       0    1,287    8,922      1.25       0     8,922
                 Supplies - Medical-ALF      326       0.32       0      326    1,778      0.25       0     1,778
                 Supplies - Non-Medical        0       0.00       0       0     1,067      0.15       0     1,067
                 Supplies - Non-Medical-ALF    0       0.00       0       0      223       0.03       0      223
                 Consultants - Pharmacy        0       0.00       0       0      718       0.10       0      718
                 Consultants - Pharmacy-ALF    0       0.00       0       0       35       0.00       0       35
                 Legend Drugs                  0       0.00       0       0     5,003      0.70       0     5,003
                 Non-Legend Drugs            133       0.13       0      133     802       0.11       0      802
                 Non-Legend Drug-ALF          16       0.02       0      16      153       0.02       0      153
                 Supplies - Non-Medical        0       0.00       0       0      233       0.03       0      233
                 TOTAL NURSING             48,476     47.85       0   48,476   356,375    50.02       0   356,375

                 THERAPY
                 Payroll Exp - Wages -Therapist  2,330   -        0    2,330   25,835        -        0    25,835
                 Employee Screening & Hiring   30        -        0      30       30         -        0       30
                 Payroll Exp - Wages -Therapist  3,625   -        0    3,625   22,063        -        0    22,063
                 Payroll Exp - Wages -Therapist  3,422   -        0    3,422   13,092        -        0    13,092
                 Employee Screening & Hiring   30        -        0      30       30         -        0       30
                 TOTAL THERAPY              9,437        -        0    9,437   61,050        -        0    61,050
                 DIETARY
                 Consultants - Dietary        51       0.05       0      51      406       0.06       0      406
                 Consultants - Dietary-ALF     0       0.00       0       0       75       0.01       0       75
                 Employee Function Expense     0       0.00       0       0       21       0.00       0       21
                 Employee Function Expense-ALF   0     0.00       0       0        4       0.00       0        4
                 Employee Screening & Hiring   0       0.00       0       0       21       0.00       0       21
                 Equipment Rental - Non-Medical  69    0.07       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,332      1.32       0    1,332    8,663      1.22       0     8,663
                 Food Supplements-ALF        239       0.24       0      239    1,032      0.14       0     1,032
                 Payroll Exp - Wages - OT    508       0.50       0      508    2,181      0.31       0     2,181
                 Payroll Exp - Wages - Regular  4,284  4.23       0    4,284   28,093      3.94       0    28,093
                 Payroll Exp - Wages - Supervis  3,027  2.99      0    3,027   19,474      2.73       0    19,474
                 Raw Food Expense           2,155      2.13       0    2,155   41,801      5.87       0    41,801
                 Raw Food Expense-ALF        457       0.45       0      457    8,937      1.25       0     8,937
                 Repairs & Maintenance - Equip  0      0.00       0       0      825       0.12       0      825
                 Repairs- Maintenance-Equip-ALF  0     0.00       0       0      175       0.02       0      175
                 Small equipment purchases    66       0.07       0      66     1,872      0.26       0     1,872
                 Small equipment purchases-ALF  14     0.01       0      14      397       0.06       0      397
                 Supplies - Chemicals        109       0.11       0      109     902       0.13       0      902
                 Supplies - Chemicals-ALF     23       0.02       0      23      109       0.02       0      109
                 Supplies - Non-Medical      124       0.12       0      124    1,529      0.21       0     1,529
                 Supplies - Non-Medical-ALF   26       0.03       0      26      155       0.02       0      155
                 TOTAL DIETARY             12,500     12.34       0   12,500   116,907    16.41       0   116,907

                 SOCIAL SERVICES
   1   2   3   4   5   6   7   8