Page 4 - May Financial Workbook
P. 4
Date: Jul 22, 2018 Towne Square Care of Puryear - SNF Facility #
Time: 16:07:06 EDT INCOME STATEMENT
User: Zach Bell 5/1/2018 to 5/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.86 0 845 2,958 0.58 0 2,958
Supplies - Non-Medical 0 0.00 0 0 14 0.00 0 14
Travel Expenses - Mileage 0 0.00 0 0 226 0.04 0 226
Utilities - Cable 385 0.39 0 385 1,734 0.34 0 1,734
Utilities - Electricity 4,591 4.66 0 4,591 28,508 5.59 0 28,508
Utilities - Gas 181 0.18 0 181 1,762 0.35 0 1,762
Utilities - Hazardous Waste 59 0.06 0 59 242 0.05 0 242
Utilities - Pest Control 0 0.00 0 0 195 0.04 0 195
Utilities - Security & Fire 3,420 3.47 0 3,420 5,553 1.09 0 5,553
Utilities - Telephone 477 0.48 0 477 2,416 0.47 0 2,416
Utilities - Trash disposal 445 0.45 0 445 2,134 0.42 0 2,134
Utilities - Water and sewer 1,172 1.19 0 1,172 3,739 0.73 0 3,739
Utilities-Water and sewer-ALF 0 0.00 0 0 188 0.04 0 188
TOTAL PLANT AND MAINTENANCE 13,955 14.15 0 13,955 70,106 13.74 0 70,106
GENERAL AND ADMINISTRATIVE
Bad Debt Expense 0 0.00 0 0 0 0.00 0 0
Conferences & Seminars 0 0.00 0 0 300 0.06 0 300
Employee Screening & Hiring 0 0.00 0 0 177 0.03 0 177
Insurance - GL/PL 0 0.00 0 0 8,502 1.67 0 8,502
Insurance - Surety Bond 0 0.00 0 0 300 0.06 0 300
Late Fees & Finance Charges 630 0.64 0 630 9,903 1.94 0 9,903
Licenses & Permits-ALF 0 0.00 0 0 800 0.16 0 800
Miscellaneous Expense 0 0.00 0 0 1,123 0.22 0 1,123
Payroll Exp - Benefits 0 0.00 0 0 352 0.07 0 352
Postage & Delivery Expenses 46 0.05 0 46 46 0.01 0 46
Printing & Copier Expense 174 0.18 0 174 870 0.17 0 870
Professional Fees - Other 18,025 18.28 0 18,025 18,025 3.53 0 18,025
Software Expense 1,000 1.01 0 1,000 5,844 1.15 0 5,844
Supplies - Office 0 0.00 0 0 660 0.13 0 660
Travel expenses - Mileage 0 0.00 0 0 17 0.00 0 17
Insurance - General Liability 0 0.00 0 0 12,546 2.46 0 12,546
Insurance - General Liabil-ALF 0 0.00 0 0 2,030 0.40 0 2,030
Insurance - Workers Compensati 0 0.00 0 0 123 0.02 0 123
Late Fees & Finance Charges 165 0.17 0 165 993 0.19 0 993
Assessment Fees 7,183 7.28 0 7,183 35,914 7.04 0 35,914
Management Fees 14,438 14.64 0 14,438 72,188 14.15 0 72,188
Management Fees-ALF 3,063 3.11 0 3,063 15,313 3.00 0 15,313
Payroll Exp-Bonuses all empl 271 0.28 0 271 2,414 0.47 0 2,414
Payroll Exp - Payroll Taxes 17,754 18.01 0 17,754 94,104 18.44 0 94,104
Payroll Exp - Wages - PTO All 0 0.00 0 0 1,302 0.26 0 1,302
Payroll Exp-Fac Administrator 6,377 6.47 0 6,377 32,600 6.39 0 32,600
Payroll Exp-Admin Assist 2,311 2.34 0 2,311 12,200 2.39 0 12,200
Payroll Exp-Admin Assist-OT 0 0.00 0 0 73 0.01 0 73
Professional Fees - Accounting 2,983 3.02 0 2,983 10,073 1.97 0 10,073
Professional Fees - Legal 0 0.00 0 0 4,185 0.82 0 4,185
Prof. Fees - Billing Services 0 0.00 0 0 450 0.09 0 450
Rent Expense 21,000 21.30 0 21,000 105,000 20.58 0 105,000
Software Expense 197 0.20 0 197 1,578 0.31 0 1,578
Taxes - Personal Property 0 0.00 0 0 560 0.11 0 560
Taxes - Real Estate 0 0.00 0 0 7,392 1.45 0 7,392
TOTAL GENERAL AND ADMINISTRATIVE 95,616 96.97 0 95,616 457,954 89.76 0 457,954
OTHER INCOME AND EXPENSE
TOTAL OTHER INCOME AND EXPENSE 0 0.00 0 0 0 0.00 0 0
TOTAL DEPARTMENTAL ROUTINE EXPENSES 171,713 174.15 0 171,713 927,703 181.83 0 927,703
NET INCOME 24,886 - 0 (24,886) 16,156 - 0 (16,156)