Page 4 - Financial April Workbook
P. 4

Date:  Jul 22, 2018                  Towne Square Care of Puryear - SNF                              Facility #
      Time: 15:06:17 EDT                          INCOME STATEMENT
      User:  Zach Bell                             4/1/2018 to 4/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              0       0.00        0       0     2,113      0.51       0    2,113
          Supplies - Non-Medical                 0       0.00        0       0       14       0.00       0       14
          Travel Expenses - Mileage              0       0.00        0       0      226       0.05       0      226
          Utilities - Cable                      0       0.00        0       0     1,349      0.33       0    1,349
          Utilities - Electricity             4,488      5.01        0    4,488   23,917      5.81       0   23,917
          Utilities - Gas                      279       0.31        0     279     1,581      0.38       0    1,581
          Utilities - Hazardous Waste           59       0.07        0      59      183       0.04       0      183
          Utilities - Pest Control               0       0.00        0       0      195       0.05       0      195
          Utilities - Security & Fire            0       0.00        0       0     2,133      0.52       0    2,133
          Utilities - Telephone                494       0.55        0     494     1,939      0.47       0    1,939
          Utilities - Trash disposal           445       0.50        0     445     1,688      0.41       0    1,688
          Utilities - Water and sewer          983       1.10        0     983     2,567      0.62       0    2,567
          Utilities-Water and sewer-ALF          0       0.00        0       0      188       0.05       0      188
          TOTAL PLANT AND MAINTENANCE         9,462     10.56        0    9,462   56,151     13.64       0   56,151
          GENERAL AND ADMINISTRATIVE
          Bad Debt Expense                   (2,177)    (2.43)       0   (2,177)      0       0.00       0       0
          Conferences & Seminars                 0       0.00        0       0      300       0.07       0      300
          Employee Screening & Hiring            0       0.00        0       0      177       0.04       0      177
          Insurance - GL/PL                   2,834      3.16        0    2,834    8,502      2.07       0    8,502
          Insurance - Surety Bond                0       0.00        0       0      300       0.07       0      300
          Late Fees & Finance Charges          434       0.48        0     434     9,273      2.25       0    9,273
          Licenses & Permits-ALF                 0       0.00        0       0      800       0.19       0      800
          Miscellaneous Expense                  0       0.00        0       0     1,123      0.27       0    1,123
          Payroll Exp - Benefits                 0       0.00        0       0      352       0.09       0      352
          Printing & Copier Expense            174       0.19        0     174      696       0.17       0      696
          Software Expense                    1,000      1.12        0    1,000    4,844      1.18       0    4,844
          Supplies - Office                      0       0.00        0       0      660       0.16       0      660
          Travel expenses - Mileage              0       0.00        0       0       17       0.00       0       17
          Insurance - General Liability       2,976      3.32        0    2,976   12,546      3.05       0   12,546
          Insurance - General Liabil-ALF         0       0.00        0       0     2,030      0.49       0    2,030
          Insurance - Workers Compensati         0       0.00        0       0      123       0.03       0      123
          Late Fees & Finance Charges          179       0.20        0     179      827       0.20       0      827
          Assessment Fees                     7,183      8.02        0    7,183   28,731      6.98       0   28,731
          Management Fees                    14,438     16.11        0   14,438   57,750     14.03       0   57,750
          Management Fees-ALF                 3,063      3.42        0    3,063   12,250      2.98       0   12,250
          Payroll Exp-Bonuses all empl         305       0.34        0     305     2,142      0.52       0    2,142
          Payroll Exp - Payroll Taxes        22,573     25.19        0   22,573   76,351     18.55       0   76,351
          Payroll Exp - Wages - PTO All          0       0.00        0       0     1,302      0.32       0    1,302
          Payroll Exp-Fac Administrator       6,377      7.12        0    6,377   26,222      6.37       0   26,222
          Payroll Exp-Admin Assist            2,407      2.69        0    2,407    9,889      2.40       0    9,889
          Payroll Exp-Admin Assist-OT            0       0.00        0       0       73       0.02       0       73
          Professional Fees - Accounting      1,963      2.19        0    1,963    7,090      1.72       0    7,090
          Professional Fees - Legal              0       0.00        0       0     4,185      1.02       0    4,185
          Prof. Fees - Billing Services          0       0.00        0       0      450       0.11       0      450
          Rent Expense                       21,000     23.44        0   21,000   84,000     20.41       0   84,000
          Software Expense                    1,090      1.22        0    1,090    1,381      0.34       0    1,381
          Taxes - Personal Property            140       0.16        0     140      560       0.14       0      560
          Taxes - Real Estate                 1,848      2.06        0    1,848    7,392      1.80       0    7,392
          TOTAL GENERAL AND ADMINISTRATIVE   87,806     98.00        0   87,806  362,338     88.03       0   362,338
          OTHER INCOME AND EXPENSE
          TOTAL OTHER INCOME AND EXPENSE         0       0.00        0       0        0       0.00       0       0
      TOTAL DEPARTMENTAL ROUTINE EXPENSES   173,742     193.91       0  173,742  755,990    183.67       0   755,990
      NET INCOME                             14,932         -        0  (14,932)  (8,730)       -        0    8,730
   1   2   3   4   5   6   7   8   9