Spreadsheet: 774565d1648547187-pulling-budget-data-into-summary-sheet-donottouch
Sheet: Budget P&L

Summary P&L | 2020-21 Avg | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 |  | YTD Total
No of Days in Period |  | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31
Registered Beds |  | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001 | 59.00003000000001
Average Occupancy |  | 42.00003 | 44.00003 | 47.00003 | 49.00003 | 52.00003 | 54.00003 | 55.00003 | 55.00003 | 56.00003 | 55.00003 | 55.00003 | 55.00003
Average Occupancy %
Average Fee Rate / Week
Turnover
Fee Income |  | 116177.0304968944 | 125806.7410372671 | 130748.459068323 | 140863.8838944099 | 149499.5981801242 | 150248.459068323 | 158135.3124658385 | 153034.1733540373 | 161013.8838944099 | 158135.3124658385 | 142831.8951304348 | 158135.3124658385
Other Income |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Turnover Total
Direct Costs
Provisions (Food) | -3.453398817677158
Medical Supplies | -0.01123718549491771
Disposable Items | -0.07207007425564127
Consumables (Cleaning) | -0.7234031432485025
Waste Disposal | -2743.897777777774
Bedding & Linen | 0 | -100
Utensils/Crockery | -56.50777777777765
Equipment Maintenance | -1440.982222222222
Residents Activities | -0.01775733544805698
Direct Cost Total
 |  |  |  |  |  |  | 0.08344539320811085 | 0.0639546072371343
Operating Expenses
Payroll |  | -59309.90453749999 | -64315.04795000001 | -65599.0831375 | -68381.82789999999 | -71243.6624375 | -68744.6624375 | -75746.54754999999 | -72694.8526875 | -78370.54754999999 | -78282.78736088707 | -68808.5316375 | -77830.37400000001
Agency |  | -9935.99 | -11218.03 | -11260.76 | -10897.51 | -11923.14 | -11923.14 | -11218 | -11591.94 | -11218 | -11260.74 | -9935.95 | -8974.4
Recruitment | 0 | -300
1:1 Care - Agency Costs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Training Fees | -40.55555555555556 | -300
Training time |  | -1178.09 | -1199.34 | -1340.85 | -1297.32 | -1422.23 | -1422.23 | -1474.06 | -1523.48 | -1474.06 | -1657.02 | -1556.6 | -1405.68
Uniforms | -21.36111111111124 | -30
Team Recognition | -100
Operating Expenses Total
 |  |  |  |  |  |  | 0.5728279703492255 | 0.5981025428129132
Gross Profit
 |  |  |  |  |  |  | 0.3437266364426637 | 0.3379428499499526
Home Overheads
Council Tax | -286.3600000000006
Water Rates | -652.0566666666668
Electricity | -1833.330000000001
Gas | -2206.136666666666
Insurance | -737.3488888888883
Telephone/FAX | -194.3555555555556
Printing/Stationery/Postage | -544.5877777777783 | -500
Property Mtce | -2489.487777777776
Garden & Grounds Mtce | 0
Registration Fees | -732.7055555555557
Audit & Acctcy Fees | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275 | -275
Legal & Consultancy | -40 | -100
Travel Expenses & Accommodation | -13.33333333333328 | -100
Bed Filler Fees | -77.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Advertising/Sales Promotions | -500 | -500
Bank Charges | -29.34444444444446 | -30
Bad Debt W/O | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Home Overheads Total
EBITDAR
 |  |  |  |  |  |  | 0.2526110312925017 | 0.2250524381786254
Head Office Costs
Profit After HO Costs
Central Costs
Interest |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Depreciation |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent | -31125
Refurbishment & Renewals | -450
Exceptional Items |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Central Costs Total
Pre-tax Profit