Page 4 - June Financial Workbook
P. 4

Date:  Jul 22, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 16:07:37 EDT                          INCOME STATEMENT
      User:  Zach Bell                             6/1/2018 to 6/30/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.92       0     845     3,803      0.63       0     3,803
          Supplies - Non-Medical                 0       0.00       0       0       14       0.00       0        14
          Travel Expenses - Mileage              0       0.00       0       0       226      0.04       0       226
          Utilities - Cable                      0       0.00       0       0     1,734      0.29       0     1,734
          Utilities - Electricity             3,975      4.31       0    3,975   32,483      5.39       0    32,483
          Utilities - Gas                      551       0.60       0     551     2,313      0.38       0     2,313
          Utilities - Hazardous Waste           59       0.06       0      59       301      0.05       0       301
          Utilities - Pest Control              65       0.07       0      65       260      0.04       0       260
          Utilities - Security & Fire            0       0.00       0       0     5,553      0.92       0     5,553
          Utilities - Telephone                454       0.49       0     454     2,870      0.48       0     2,870
          Utilities - Trash disposal           452       0.49       0     452     2,585      0.43       0     2,585
          Utilities - Water and sewer          855       0.93       0     855     4,594      0.76       0     4,594
          Utilities-Water and sewer-ALF          0       0.00       0       0       188      0.03       0       188
          TOTAL PLANT AND MAINTENANCE        16,954     18.37       0   16,954   87,061      14.45      0    87,061
          GENERAL AND ADMINISTRATIVE
          Bad Debt Expense                       0       0.00       0       0        0       0.00       0        0
          Conferences & Seminars                 0       0.00       0       0       300      0.05       0       300
          Employee Screening & Hiring            0       0.00       0       0       177      0.03       0       177
          Insurance - GL/PL                      0       0.00       0       0     8,502      1.41       0     8,502
          Insurance - Surety Bond                0       0.00       0       0       300      0.05       0       300
          Late Fees & Finance Charges         3,012      3.26       0    3,012   12,915      2.14       0    12,915
          Licenses & Permits-ALF                 0       0.00       0       0       800      0.13       0       800
          Miscellaneous Expense                  0       0.00       0       0     1,123      0.19       0     1,123
          Payroll Exp - Benefits                 0       0.00       0       0       352      0.06       0       352
          Postage & Delivery Expenses            0       0.00       0       0       46       0.01       0        46
          Printing & Copier Expense              0       0.00       0       0       870      0.14       0       870
          Professional Fees - Other          18,088     19.60       0   18,088   36,113      5.99       0    36,113
          Software Expense                       0       0.00       0       0     5,844      0.97       0     5,844
          Supplies - Office                      0       0.00       0       0       660      0.11       0       660
          Travel expenses - Mileage              0       0.00       0       0       17       0.00       0        17
          Insurance - General Liability          0       0.00       0       0    12,546      2.08       0    12,546
          Insurance - General Liabil-ALF         0       0.00       0       0     2,030      0.34       0     2,030
          Insurance - Workers Compensati         0       0.00       0       0       123      0.02       0       123
          Late Fees & Finance Charges            0       0.00       0       0       993      0.16       0       993
          Licenses & Permits                  1,000      1.08       0    1,000    1,000      0.17       0     1,000
          Assessment Fees                     7,183      7.78       0    7,183   43,097      7.15       0    43,097
          Management Fees                    14,438     15.64       0   14,438   86,625      14.38      0    86,625
          Management Fees-ALF                 3,063      3.32       0    3,063   18,375      3.05       0    18,375
          Payroll Exp-Bonuses all empl         547       0.59       0     547     2,960      0.49       0     2,960
          Payroll Exp - Payroll Taxes         9,971     10.80       0    9,971  104,075      17.27      0    104,075
          Payroll Exp - Wages - PTO All          0       0.00       0       0     1,302      0.22       0     1,302
          Payroll Exp-Fac Administrator       6,600      7.15       0    6,600   39,200      6.51       0    39,200
          Payroll Exp-Admin Assist            2,690      2.91       0    2,690   14,889      2.47       0    14,889
          Payroll Exp-Admin Assist-OT            0       0.00       0       0       73       0.01       0        73
          Professional Fees - Accounting      3,135      3.40       0    3,135   13,208      2.19       0    13,208
          Professional Fees - Legal              0       0.00       0       0     4,185      0.69       0     4,185
          Prof. Fees - Billing Services          0       0.00       0       0       450      0.07       0       450
          Rent Expense                       21,000     22.75       0   21,000  126,000      20.91      0    126,000
          Software Expense                      97       0.11       0      97     1,675      0.28       0     1,675
          Taxes - Personal Property            140       0.15       0     140       700      0.12       0       700
          Taxes - Real Estate                 1,848      2.00       0    1,848    9,240      1.53       0     9,240
          TOTAL GENERAL AND ADMINISTRATIVE   92,810    100.55       0   92,810  550,764      91.41      0    550,764
          OTHER INCOME AND EXPENSE
          TOTAL OTHER INCOME AND EXPENSE         0       0.00       0       0        0       0.00       0        0
      TOTAL DEPARTMENTAL ROUTINE EXPENSES   180,197    195.23       0  180,197  1,107,900   183.88      0  1,107,900

      NET INCOME                             15,721         -       0  (15,721)  31,877         -       0   (31,877)
   1   2   3   4   5   6   7   8   9