Page 5 - Financial Workbook November
P. 5

Date:  Dec 18, 2017               Towne Square Care of Puryear - SNF
            Time: 16:41:19 CT                       INCOME STATEMENT
            User:  Zach Bell                        11/1/2017 to 11/30/2017                               Page # 4

                                                     CURRENT PERIOD                      YEAR TO DATE
                                             Actual $ Actual / Day  Budget $  Var $  Actual $ Actual / Day  Budget $  Var $
                 GENERAL AND ADMINISTRATIVE (con't)
                 Conferences & Seminars-ALF       0      0.00      14     (14)    525       0.05     145     380
                 Employee Function Expense        0      0.00       0       0      33       0.00      0       33
                 Employee Function Expense-ALF    0      0.00       0       0       7       0.00      0        7
                 Employee Screening & Hiring      0      0.00      36     (36)    326       0.03     364     (37)
                 Employee Screening & Hire-ALF    0      0.00       2      (2)     69       0.01      24      45
                 Late Fees & Finance Charges      2      0.00      63     (61)   1,207      0.12     636     570
                 Late Fee/Finance Charges-ALF     0      0.00       2      (2)     89       0.01      24      65
                 Licenses & Permits               0      0.00     270    (270)   2,825      0.27    2,727     98
                 Licenses & Permits-ALF           0      0.00      46     (46)   1,775      0.17     461    1,314
                 Marketing Expenses               0      0.00       9      (9)     65       0.01      91     (26)
                 Marketing Expense-ALF            0      0.00       0       0       3       0.00      0        3
                 Meals & Entertainment            0      0.00       0       0      48       0.00      0       48
                 Meals & Entertainment-ALF        0      0.00       0       0      10       0.00      0       10
                 Miscellaneous Expense            0      0.00       0       0    1,261      0.12      0     1,261
                 ADP Payroll Processing           0      0.00     144    (144)   1,483      0.14    1,454     28
                 ADP Payroll Processing - ALF     0      0.00       7      (7)    315       0.03      73     242
                 Payroll Exp - Payroll Taxes      0      0.00       0       0  (10,997)    (1.06)     0   (10,997)
                 SUTA Taxes                       0      0.00     855    (855)   8,774      0.84    8,634    140
                 SUTA Taxes ALF                   0      0.00      22     (22)    822       0.08     218     604
                 FUTA Taxes                       0      0.00     189    (189)   1,944      0.19    1,909     35
                 FUTA Taxes ALF                   0      0.00       5      (5)    182       0.02      48     134
                 Payroll Exp - Workers Comp    2,405     2.10     468    1,937   7,214      0.69    4,727   2,487
                 Postage & Delivery Expenses      0      0.00      81     (81)    801       0.08     818     (17)
                 Printing & Copier Expense      144      0.13     162     (18)   1,835      0.18    1,636    199
                 Printing & Copier Expense-ALF   30      0.03       2      28      91       0.01      24      67
                 Professional fees - Accounting  1,114   0.97     162     952    2,742      0.26    1,636   1,106
                 Professional fees-Account-ALF  236      0.21      10     227     582       0.06      97     485
                 Professional Fees - Architect    0      0.00     450    (450)   4,656      0.45    4,545    111
                 Professional Fees - Arch. ALF    0      0.00      12     (12)    425       0.04     121     304
                 Professional Fees - Other        0      0.00     225    (225)   2,298      0.22    2,273     25
                 Software Expense              1,404     1.22     972     432   11,431      1.10    9,817   1,614
                 Software Expense-ALF           146      0.13      10     137     500       0.05      97     403
                 Supplies - Office                0      0.00     225    (225)   2,326      0.22    2,273     53
                 Supplies - Office-ALF            0      0.00      12     (12)    494       0.05     121     373
                 Travel expenses - Mileage        0      0.00      72     (72)    781       0.07     727      54
                 Travel expenses - Mileage-ALF    0      0.00       5      (5)    166       0.02      48     117
                 Bank Charges                     0      0.00       0       0      13       0.00      0       13
                 Insurance - General Liability  3,190    2.78    2,619    571   28,677      2.75   26,452   2,225
                 Insurance - General Liabil-ALF  677     0.59     142     535    6,124      0.59    1,430   4,694
                 Insurance - Workers Compensati   0      0.00    1,242  (1,242)  12,835     1.23   12,544    291
                 Insurance WC ALF                 0      0.00      31     (31)   1,203      0.12     315     888
                 Late Fees & Finance Charges      0      0.00     165    (165)   1,630      0.16    1,648    (18)
                 Licenses & Permits               0      0.00      90     (90)    900       0.09     909      (9)
                 Assessment Fees               7,183     6.26    6,147   1,036  70,548      6.77   62,085   8,464
                 Management Fees              14,438    12.59   10,872   3,566  126,438    12.13   99,695  26,743
                 Management Fees-ALF           3,063     2.67     725    2,338  31,063      2.98    7,320  23,742
                 Payroll Exp - Benefits         118      0.10      99      19    1,092      0.10    1,000     93
                 Payroll Exp - Payroll Taxes   7,835     6.83    6,831   1,004  78,181      7.50   68,993   9,188
                 Payroll Exp - Wages - PTO     2,432     2.12     981    1,451  12,538      1.20    9,908   2,630
                 Payroll Exp - Fac Admin       7,802     6.80    6,831    971   78,203      7.50   68,993   9,210
                 Payroll Exp-Admin Assist      2,321     2.02    2,322     (1)  26,237      2.52   23,452   2,785
                 Payroll Exp-Admin Assist-OT    163      0.14     279    (116)   3,015      0.29    2,818    197
                 Professional Fees - Accounting   0      0.00    1,224  (1,224)  12,599     1.21   12,362    236
                 Professional Fees- Account-ALF   0      0.00      60     (60)   2,306      0.22     606    1,700
                 Professional Fees - Legal        0      0.00     891    (891)   9,145      0.88    8,999    146
                 Professional Fees - Legal-ALF    0      0.00     450    (450)   1,940      0.19     909    1,031
                 Prof. Fees - Billing Services    0      0.00     149    (149)   1,464      0.14    1,454     10
                 Prof. Fees-Billing Serv-ALF      0      0.00       7      (7)    311       0.03      73     238
                 Professional Fees - Other        0      0.00     198    (198)    170       0.02    2,000  (1,830)
                 Professional Fees-Other-ALF      0      0.00       0       0      36       0.00      0       36
                 Rent Expense                 21,000    18.31   12,231   8,769  147,000    14.11  123,533  23,467
                 Software Expense               550      0.48     477      73    5,500      0.53    4,818    682
                 Taxes - Personal Property      140      0.12     126      14    1,400      0.13    1,273    127
                 Taxes - Real Estate           1,848     1.61    1,611    237   18,480      1.77   16,271   2,209
   1   2   3   4   5   6   7   8   9   10