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