Page 4 - Financial Workbook March
P. 4

Date:  Aug 13, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 14:32:34 EDT                          INCOME STATEMENT
      User:  Zach Bell                             3/1/2018 to 3/31/2018                                    Page # 3


                                                     CURRENT PERIOD                       YEAR TO DATE
                                            Actual $ Actual / Day  Budget $  Var $  Actual $ Actual / Day  Budget $  Var $
          PLANT AND MAINTENANCE (con't)
          Repairs & Maint - Grounds            845       0.79        0     845     2,113      0.66       0    2,113
          Supplies - Non-Medical                14       0.01        0      14       14       0.00       0       14
          Travel Expenses - Mileage              0       0.00        0       0      226       0.07       0      226
          Utilities - Cable                    333       0.31        0     333     1,349      0.42       0    1,349
          Utilities - Electricity             5,161      4.81        0    5,161   19,429      6.03       0   19,429
          Utilities - Gas                      367       0.34        0     367     1,302      0.40       0    1,302
          Utilities - Hazardous Waste          124       0.12        0     124      124       0.04       0      124
          Utilities - Pest Control              65       0.06        0      65      195       0.06       0      195
          Utilities - Security & Fire          325       0.30        0     325     2,133      0.66       0    2,133
          Utilities - Telephone                492       0.46        0     492     1,445      0.45       0    1,445
          Utilities - Trash disposal           439       0.41        0     439     1,243      0.39       0    1,243
          Utilities - Water and sewer            0       0.00        0       0     1,584      0.49       0    1,584
          Utilities-Water and sewer-ALF          0       0.00        0       0      188       0.06       0      188
          TOTAL PLANT AND MAINTENANCE        17,999     16.79        0   17,999   46,689     14.50       0   46,689
          GENERAL AND ADMINISTRATIVE
          Bad Debt Expense                    2,178      2.03        0    2,178    2,178      0.68       0    2,178
          Conferences & Seminars                 0       0.00        0       0      300       0.09       0      300
          Employee Screening & Hiring            0       0.00        0       0      177       0.05       0      177
          Insurance - GL/PL                   2,834      2.64        0    2,834    5,668      1.76       0    5,668
          Insurance - Surety Bond                0       0.00        0       0      300       0.09       0      300
          Late Fees & Finance Charges         1,898      1.77        0    1,898    4,151      1.29       0    4,151
          Licenses & Permits-ALF               800       0.75        0     800      800       0.25       0      800
          Miscellaneous Expense               1,123      1.05        0    1,123    1,123      0.35       0    1,123
          Payroll Exp - Benefits                 0       0.00        0       0      352       0.11       0      352
          Printing & Copier Expense            174       0.16        0     174      522       0.16       0      522
          Software Expense                    1,042      0.97        0    1,042    3,843      1.19       0    3,843
          Supplies - Office                      0       0.00        0       0      660       0.20       0      660
          Travel expenses - Mileage              0       0.00        0       0       17       0.01       0       17
          Insurance - General Liability       3,190      2.98        0    3,190    9,570      2.97       0    9,570
          Insurance - General Liabil-ALF       677       0.63        0     677     2,030      0.63       0    2,030
          Insurance - Workers Compensati       123       0.11        0     123      123       0.04       0      123
          Late Fees & Finance Charges          200       0.19        0     200      649       0.20       0      649
          Assessment Fees                     7,183      6.70        0    7,183   21,548      6.69       0   21,548
          Management Fees                    14,438     13.47        0   14,438   43,313     13.45       0   43,313
          Management Fees-ALF                 3,063      2.86        0    3,063    9,188      2.85       0    9,188
          Payroll Exp-Bonuses all empl         600       0.56        0     600     1,837      0.57       0    1,837
          Payroll Exp - Payroll Taxes        22,958     21.42        0   22,958   53,777     16.70       0   53,777
          Payroll Exp - Wages - PTO All          0       0.00        0       0     1,302      0.40       0    1,302
          Payroll Exp-Fac Administrator       6,377      5.95        0    6,377   19,845      6.16       0   19,845
          Payroll Exp-Admin Assist            2,381      2.22        0    2,381    7,482      2.32       0    7,482
          Payroll Exp-Admin Assist-OT            0       0.00        0       0       73       0.02       0       73
          Professional Fees - Accounting      1,350      1.26        0    1,350    5,128      1.59       0    5,128
          Professional Fees - Legal              0       0.00        0       0     4,185      1.30       0    4,185
          Prof. Fees - Billing Services        450       0.42        0     450      450       0.14       0      450
          Rent Expense                       21,000     19.59        0   21,000   63,000     19.57       0   63,000
          Software Expense                      97       0.09        0      97      291       0.09       0      291
          Taxes - Personal Property            140       0.13        0     140      420       0.13       0      420
          Taxes - Real Estate                 1,848      1.72        0    1,848    5,544      1.72       0    5,544
          TOTAL GENERAL AND ADMINISTRATIVE   96,122     89.67        0   96,122  269,845     83.80       0   269,845
          OTHER INCOME AND EXPENSE
          TOTAL OTHER INCOME AND EXPENSE         0       0.00        0       0        0       0.00       0       0
      TOTAL DEPARTMENTAL ROUTINE EXPENSES   194,256     181.21       0  194,256  577,560    179.37       0   577,560
      NET INCOME                             (8,955)        -        0    8,955  (18,974)       -        0   18,974
   1   2   3   4   5   6   7   8   9