Page 4 - May Financial Workbook
P. 4

Date:  Jul 22, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 16:07:06 EDT                          INCOME STATEMENT
      User:  Zach Bell                             5/1/2018 to 5/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.86       0      845     2,958      0.58       0    2,958
          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                    385       0.39       0      385     1,734      0.34       0    1,734
          Utilities - Electricity             4,591      4.66       0     4,591   28,508      5.59       0   28,508
          Utilities - Gas                      181       0.18        0     181     1,762      0.35       0    1,762
          Utilities - Hazardous Waste           59       0.06       0       59      242       0.05       0      242
          Utilities - Pest Control               0       0.00       0        0      195       0.04       0      195
          Utilities - Security & Fire         3,420      3.47        0    3,420    5,553      1.09       0    5,553
          Utilities - Telephone                477       0.48       0      477     2,416      0.47       0    2,416
          Utilities - Trash disposal           445       0.45       0      445     2,134      0.42       0    2,134
          Utilities - Water and sewer         1,172      1.19       0     1,172    3,739      0.73       0    3,739
          Utilities-Water and sewer-ALF          0       0.00       0        0      188       0.04       0      188
          TOTAL PLANT AND MAINTENANCE        13,955     14.15       0    13,955   70,106     13.74       0   70,106
          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.06       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.67       0    8,502
          Insurance - Surety Bond                0       0.00       0        0      300       0.06       0      300
          Late Fees & Finance Charges          630       0.64       0      630     9,903      1.94       0    9,903
          Licenses & Permits-ALF                 0       0.00       0        0      800       0.16       0      800
          Miscellaneous Expense                  0       0.00       0        0     1,123      0.22       0    1,123
          Payroll Exp - Benefits                 0       0.00       0        0      352       0.07       0      352
          Postage & Delivery Expenses           46       0.05       0       46       46       0.01       0       46
          Printing & Copier Expense            174       0.18       0      174      870       0.17       0      870
          Professional Fees - Other          18,025     18.28       0    18,025   18,025      3.53       0   18,025
          Software Expense                    1,000      1.01        0    1,000    5,844      1.15       0    5,844
          Supplies - Office                      0       0.00        0       0      660       0.13       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.46       0   12,546
          Insurance - General Liabil-ALF         0       0.00       0        0     2,030      0.40       0    2,030
          Insurance - Workers Compensati         0       0.00       0        0      123       0.02       0      123
          Late Fees & Finance Charges          165       0.17       0      165      993       0.19       0      993
          Assessment Fees                     7,183      7.28        0    7,183   35,914      7.04       0   35,914
          Management Fees                    14,438     14.64       0    14,438   72,188     14.15       0   72,188
          Management Fees-ALF                 3,063      3.11       0     3,063   15,313      3.00       0   15,313
          Payroll Exp-Bonuses all empl         271       0.28       0      271     2,414      0.47       0    2,414
          Payroll Exp - Payroll Taxes        17,754     18.01       0    17,754   94,104     18.44       0   94,104
          Payroll Exp - Wages - PTO All          0       0.00       0        0     1,302      0.26       0    1,302
          Payroll Exp-Fac Administrator       6,377      6.47       0     6,377   32,600      6.39       0   32,600
          Payroll Exp-Admin Assist            2,311      2.34       0     2,311   12,200      2.39       0   12,200
          Payroll Exp-Admin Assist-OT            0       0.00       0        0       73       0.01       0       73
          Professional Fees - Accounting      2,983      3.02       0     2,983   10,073      1.97       0   10,073
          Professional Fees - Legal              0       0.00       0        0     4,185      0.82       0    4,185
          Prof. Fees - Billing Services          0       0.00       0        0      450       0.09       0      450
          Rent Expense                       21,000     21.30       0    21,000  105,000     20.58       0   105,000
          Software Expense                     197       0.20        0     197     1,578      0.31       0    1,578
          Taxes - Personal Property              0       0.00        0       0      560       0.11       0      560
          Taxes - Real Estate                    0       0.00       0        0     7,392      1.45       0    7,392
          TOTAL GENERAL AND ADMINISTRATIVE   95,616     96.97       0    95,616  457,954     89.76       0   457,954
          OTHER INCOME AND EXPENSE
          TOTAL OTHER INCOME AND EXPENSE         0       0.00       0        0        0       0.00       0       0
      TOTAL DEPARTMENTAL ROUTINE EXPENSES   171,713     174.15      0   171,713  927,703    181.83       0   927,703

      NET INCOME                             24,886         -       0   (24,886)  16,156        -        0  (16,156)
   1   2   3   4   5   6   7   8   9