Page 6 - Financial Workbook July
P. 6

Date:  Aug 25, 2017               Towne Square Care of Puryear - SNF
            Time: 15:15:02 CT                       INCOME STATEMENT
            User:  Zach Bell                         7/1/2017 to 7/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  937      1.13       0      937    6,296      1.06       0     6,296
                 Medical Director           1,031      1.24       0    1,031    6,188      1.04       0     6,188
                 Medical Director-ALF        219       0.26       0      219    1,313      0.22       0     1,313
                 Medical Records Expense       0       0.00       0       0      603       0.10       0      603
                 Medical Records-ALF           0       0.00       0       0      114       0.02       0      114
                 Payroll Exp - Payroll Taxes  805      0.97       0      805    5,444      0.92       0     5,444
                 Payroll Exp - Wages - OT   1,603      1.93       0    1,603    9,602      1.62       0     9,602
                 Payroll Exp - Wages - CNA  14,741    17.78       0   14,741   92,801     15.65       0    92,801
                 Payroll Exp - Wages - DON  5,029      6.07       0    5,029   29,952      5.05       0    29,952
                 Payroll Exp - Wages - LPN  11,870    14.32       0   11,870   66,487     11.21       0    66,487
                 Payroll Exp - Wages - MDS  1,721      2.08       0    1,721   12,677      2.14       0    12,677
                 Payroll Exp - Wages - RN   3,584      4.32       0    3,584   14,749      2.49       0    14,749
                 Payroll Exp-Wages-Univer-ALF  8,151   9.83       0    8,151   38,287      6.46       0    38,287
                 Small equipment purchases   389       0.47       0      389     389       0.07       0      389
                 Supplies - Incontinence    1,312      1.58       0    1,312    5,072      0.86       0     5,072
                 Supplies - Incontinence-ALF  278      0.34       0      278     755       0.13       0      755
                 Supplies - Medical         2,595      3.13       0    2,595    7,635      1.29       0     7,635
                 Supplies - Medical-ALF      550       0.66       0      550    1,452      0.24       0     1,452
                 Supplies - Non-Medical       34       0.04       0      34     1,067      0.18       0     1,067
                 Supplies - Non-Medical-ALF    7       0.01       0       7      223       0.04       0      223
                 Consultants - Pharmacy      165       0.20       0      165     718       0.12       0      718
                 Consultants - Pharmacy-ALF   35       0.04       0      35       35       0.01       0       35
                 Legend Drugs                110       0.13       0      110    5,003      0.84       0     5,003
                 Non-Legend Drugs            286       0.34       0      286     669       0.11       0      669
                 Non-Legend Drug-ALF          88       0.11       0      88      137       0.02       0      137
                 Supplies - Non-Medical        0       0.00       0       0      233       0.04       0      233
                 TOTAL NURSING             55,539     67.00       0   55,539   307,899    51.93       0   307,899
                 THERAPY
                 Payroll Exp - Wages -Therapist  558     -        0      558   23,506        -        0    23,506
                 Payroll Exp - Wages -Therapist  4,089   -        0    4,089   18,438        -        0    18,438
                 Payroll Exp - Wages -Therapist  2,282   -        0    2,282    9,670        -        0     9,670
                 TOTAL THERAPY              6,929        -        0    6,929   51,614        -        0    51,614
                 DIETARY
                 Consultants - Dietary       355       0.43       0      355     355       0.06       0      355
                 Consultants - Dietary-ALF    75       0.09       0      75       75       0.01       0       75
                 Employee Function Expense    21       0.02       0      21       21       0.00       0       21
                 Employee Function Expense-ALF   4     0.01       0       4        4       0.00       0        4
                 Employee Screening & Hiring   0       0.00       0       0       21       0.00       0       21
                 Equipment Rental - Non-Medical  0     0.00       0       0      138       0.02       0      138
                 Equip Rental-Non-Medical-ALF  0       0.00       0       0       15       0.00       0       15
                 Food Supplements           1,040      1.25       0    1,040    7,331      1.24       0     7,331
                 Food Supplements-ALF        221       0.27       0      221     792       0.13       0      792
                 Payroll Exp - Wages - OT    363       0.44       0      363    1,673      0.28       0     1,673
                 Payroll Exp - Wages - Regular  4,045  4.88       0    4,045   23,809      4.02       0    23,809
                 Payroll Exp - Wages - Supervis  2,718  3.28      0    2,718   16,447      2.77       0    16,447
                 Raw Food Expense           6,703      8.09       0    6,703   39,646      6.69       0    39,646
                 Raw Food Expense-ALF       1,421      1.71       0    1,421    8,480      1.43       0     8,480
                 Repairs & Maintenance - Equip  0      0.00       0       0      825       0.14       0      825
                 Repairs- Maintenance-Equip-ALF  0     0.00       0       0      175       0.03       0      175
                 Small equipment purchases     0       0.00       0       0     1,806      0.30       0     1,806
                 Small equipment purchases-ALF  0      0.00       0       0      383       0.06       0      383
                 Supplies - Chemicals        214       0.26       0      214     793       0.13       0      793
                 Supplies - Chemicals-ALF     45       0.05       0      45       86       0.01       0       86
                 Supplies - Non-Medical      105       0.13       0      105    1,405      0.24       0     1,405
                 Supplies - Non-Medical-ALF   22       0.03       0      22      128       0.02       0      128
                 TOTAL DIETARY             17,351     20.93       0   17,351   104,407    17.61       0   104,407

                 SOCIAL SERVICES
                 TOTAL SOCIAL SERVICES         0       0.00       0       0        0       0.00       0        0
                 ACTIVITIES
   1   2   3   4   5   6   7   8   9   10   11