Page 8 - Financial Workbook July
P. 8

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 # 4

                                                     CURRENT PERIOD                      YEAR TO DATE
                                             Actual $ Actual / Day  Budget $  Var $  Actual $ Actual / Day  Budget $  Var $
                 GENERAL AND ADMINISTRATIVE (con't)
                 Bank Charges-ALF                 2       0.00      0       2       4       0.00       0       4
                 Dues & Subscriptions             0       0.00      0       0    1,472      0.25       0    1,472
                 Dues & Subscriptions-ALF         0       0.00      0       0      474      0.08       0     474
                 Employee Function Expense        0       0.00      0       0      33       0.01       0      33
                 Employee Function Expense-ALF    0       0.00      0       0       7       0.00       0       7
                 Employee Screening & Hiring     45       0.05      0      45      326      0.06       0     326
                 Employee Screening & Hire-ALF   10       0.01      0      10      69       0.01       0      69
                 Late Fees & Finance Charges     69       0.08      0      69      406      0.07       0     406
                 Late Fee/Finance Charges-ALF    15       0.02      0      15      86       0.01       0      86
                 Licenses & Permits               0       0.00      0       0    2,825      0.48       0    2,825
                 Licenses & Permits-ALF           0       0.00      0       0    1,775      0.30       0    1,775
                 Marketing Expenses               0       0.00      0       0      65       0.01       0      65
                 Marketing Expense-ALF            0       0.00      0       0       3       0.00       0       3
                 Meals & Entertainment           48       0.06      0      48      48       0.01       0      48
                 Meals & Entertainment-ALF       10       0.01      0      10      10       0.00       0      10
                 Miscellaneous Expense           40       0.05      0      40      90       0.02       0      90
                 ADP Payroll Processing           6       0.01      0       6    1,310      0.22       0    1,310
                 ADP Payroll Processing - ALF     1       0.00      0       1      278      0.05       0     278
                 Payroll Exp - Workers Comp    2,405      2.90      0    2,405   12,024     2.03       0   12,024
                 Postage & Delivery Expenses    183       0.22      0     183      632      0.11       0     632
                 Postage-Delivery Expenses-ALF   39       0.05      0      39      134      0.02       0     134
                 Printing & Copier Expense      143       0.17      0     143    1,000      0.17       0    1,000
                 Printing & Copier Expense-ALF   30       0.04      0      30      212      0.04       0     212
                 Professional Fees - Architect  1,301     1.57      0    1,301   1,301      0.22       0    1,301
                 Professional Fees - Arch. ALF  276       0.33      0     276      276      0.05       0     276
                 Professional Fees - Other        0       0.00      0       0    1,895      0.32       0    1,895
                 Professional Fees - Other        0       0.00      0       0      402      0.07       0     402
                 Software Expense               705       0.85      0     705    3,613      0.61       0    3,613
                 Software Expense-ALF           296       0.36      0     296      905      0.15       0     905
                 Supplies - Office              657       0.79      0     657    2,214      0.37       0    2,214
                 Supplies - Office-ALF          139       0.17      0     139      470      0.08       0     470
                 Travel expenses - Mileage        0       0.00      0       0      195      0.03       0     195
                 Travel expenses - Mileage-ALF    0       0.00      0       0      41       0.01       0      41
                 Bank Charges                     0       0.00      0       0      11       0.00       0      11
                 Bank Charges-ALF                 0       0.00      0       0       2       0.00       0       2
                 Insurance - GL/PL             3,190      3.85      0    3,190   23,647     3.99       0   23,647
                 Insurance - GL/PL-ALF          677       0.82      0     677    5,074      0.86       0    5,074
                 Late Fees & Finance Charges      0       0.00      0       0      330      0.06       0     330
                 Licenses & Permits               0       0.00      0       0      743      0.13       0     743
                 Licenses & Permits-ALF           0       0.00      0       0      158      0.03       0     158
                 Assessment Fees               7,183      8.66      0    7,183   43,097     7.27       0   43,097
                 Management Fees              14,438     17.42      0   14,438   88,688    14.96       0   88,688
                 Management Fees-ALF           3,063      3.69      0    3,063   18,813     3.17       0   18,813
                 Payroll Exp - Benefits         137       0.16      0     137      704      0.12       0     704
                 Payroll Exp - Payroll Taxes   7,654      9.23      0    7,654   48,450     8.17       0   48,450
                 Payroll Exp - Wages - PTO     2,316      2.79      0    2,316   5,456      0.92       0    5,456
                 Payroll Exp - Fac Admin       7,802      9.41      0    7,802   42,913     7.24       0   42,913
                 Payroll Exp-Admin Assist      2,431      2.93      0    2,431   14,666     2.47       0   14,666
                 Payroll Exp-Admin Assist-OT    347       0.42      0     347    1,923      0.32       0    1,923
                 Professional Fees - Accounting  5,176    6.24      0    5,176   6,904      1.16       0    6,904
                 Professional Fees- Account-ALF  1,098    1.32      0    1,098   1,098      0.19       0    1,098
                 Professional Fees - Legal        0       0.00      0       0    9,145      1.54       0    9,145
                 Professional Fees - Legal-ALF    0       0.00      0       0    1,940      0.33       0    1,940
                 Prof. Fees - Billing Services    0       0.00      0       0      765      0.13       0     765
                 Prof. Fees-Billing Serv-ALF      0       0.00      0       0      162      0.03       0     162
                 Professional Fees - Other        0       0.00      0       0      170      0.03       0     170
                 Professional Fees-Other-ALF      0       0.00      0       0      36       0.01       0      36
                 Rent Expense                 21,000     25.33      0   21,000   63,000    10.63       0   63,000
                 Software Expense               550       0.66      0     550    3,300      0.56       0    3,300
                 Taxes - Personal Property      140       0.17      0     140      840      0.14       0     840
                 Taxes - Real Estate           1,848      2.23      0    1,848   11,088     1.87       0   11,088
                 Utilities - Security & Fire      0       0.00      0       0    1,183      0.20       0    1,183
                 TOTAL GENERAL AND ADMINISTRATIVE  85,479  103.11   0   85,479  429,072    72.37       0  429,072
   3   4   5   6   7   8   9   10   11   12   13