Page 4 - Financial Workbook March
P. 4
Date: Aug 13, 2018 Towne Square Care of Puryear - SNF Facility #
Time: 14:32:34 EDT INCOME STATEMENT
User: Zach Bell 3/1/2018 to 3/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.79 0 845 2,113 0.66 0 2,113
Supplies - Non-Medical 14 0.01 0 14 14 0.00 0 14
Travel Expenses - Mileage 0 0.00 0 0 226 0.07 0 226
Utilities - Cable 333 0.31 0 333 1,349 0.42 0 1,349
Utilities - Electricity 5,161 4.81 0 5,161 19,429 6.03 0 19,429
Utilities - Gas 367 0.34 0 367 1,302 0.40 0 1,302
Utilities - Hazardous Waste 124 0.12 0 124 124 0.04 0 124
Utilities - Pest Control 65 0.06 0 65 195 0.06 0 195
Utilities - Security & Fire 325 0.30 0 325 2,133 0.66 0 2,133
Utilities - Telephone 492 0.46 0 492 1,445 0.45 0 1,445
Utilities - Trash disposal 439 0.41 0 439 1,243 0.39 0 1,243
Utilities - Water and sewer 0 0.00 0 0 1,584 0.49 0 1,584
Utilities-Water and sewer-ALF 0 0.00 0 0 188 0.06 0 188
TOTAL PLANT AND MAINTENANCE 17,999 16.79 0 17,999 46,689 14.50 0 46,689
GENERAL AND ADMINISTRATIVE
Bad Debt Expense 2,178 2.03 0 2,178 2,178 0.68 0 2,178
Conferences & Seminars 0 0.00 0 0 300 0.09 0 300
Employee Screening & Hiring 0 0.00 0 0 177 0.05 0 177
Insurance - GL/PL 2,834 2.64 0 2,834 5,668 1.76 0 5,668
Insurance - Surety Bond 0 0.00 0 0 300 0.09 0 300
Late Fees & Finance Charges 1,898 1.77 0 1,898 4,151 1.29 0 4,151
Licenses & Permits-ALF 800 0.75 0 800 800 0.25 0 800
Miscellaneous Expense 1,123 1.05 0 1,123 1,123 0.35 0 1,123
Payroll Exp - Benefits 0 0.00 0 0 352 0.11 0 352
Printing & Copier Expense 174 0.16 0 174 522 0.16 0 522
Software Expense 1,042 0.97 0 1,042 3,843 1.19 0 3,843
Supplies - Office 0 0.00 0 0 660 0.20 0 660
Travel expenses - Mileage 0 0.00 0 0 17 0.01 0 17
Insurance - General Liability 3,190 2.98 0 3,190 9,570 2.97 0 9,570
Insurance - General Liabil-ALF 677 0.63 0 677 2,030 0.63 0 2,030
Insurance - Workers Compensati 123 0.11 0 123 123 0.04 0 123
Late Fees & Finance Charges 200 0.19 0 200 649 0.20 0 649
Assessment Fees 7,183 6.70 0 7,183 21,548 6.69 0 21,548
Management Fees 14,438 13.47 0 14,438 43,313 13.45 0 43,313
Management Fees-ALF 3,063 2.86 0 3,063 9,188 2.85 0 9,188
Payroll Exp-Bonuses all empl 600 0.56 0 600 1,837 0.57 0 1,837
Payroll Exp - Payroll Taxes 22,958 21.42 0 22,958 53,777 16.70 0 53,777
Payroll Exp - Wages - PTO All 0 0.00 0 0 1,302 0.40 0 1,302
Payroll Exp-Fac Administrator 6,377 5.95 0 6,377 19,845 6.16 0 19,845
Payroll Exp-Admin Assist 2,381 2.22 0 2,381 7,482 2.32 0 7,482
Payroll Exp-Admin Assist-OT 0 0.00 0 0 73 0.02 0 73
Professional Fees - Accounting 1,350 1.26 0 1,350 5,128 1.59 0 5,128
Professional Fees - Legal 0 0.00 0 0 4,185 1.30 0 4,185
Prof. Fees - Billing Services 450 0.42 0 450 450 0.14 0 450
Rent Expense 21,000 19.59 0 21,000 63,000 19.57 0 63,000
Software Expense 97 0.09 0 97 291 0.09 0 291
Taxes - Personal Property 140 0.13 0 140 420 0.13 0 420
Taxes - Real Estate 1,848 1.72 0 1,848 5,544 1.72 0 5,544
TOTAL GENERAL AND ADMINISTRATIVE 96,122 89.67 0 96,122 269,845 83.80 0 269,845
OTHER INCOME AND EXPENSE
TOTAL OTHER INCOME AND EXPENSE 0 0.00 0 0 0 0.00 0 0
TOTAL DEPARTMENTAL ROUTINE EXPENSES 194,256 181.21 0 194,256 577,560 179.37 0 577,560
NET INCOME (8,955) - 0 8,955 (18,974) - 0 18,974