DoorbookTwelve-month dormitory budget
Set the bed count and occupancy once, then let the budget roll through twelve named months. Annual repairs, replacements and editable one-off lines appear in the month they belong to, so the total is a real schedule rather than a single guess.
-
01 Set
Start with occupied capacity
Enter beds, expected occupancy and the fixed and variable monthly costs. Recovery is shown separately so the net cost remains auditable.
-
02 Plan
Place annual and one-off work
Annual repairs and replacements are placed in the sixth and twelfth scheduled months. Add or remove one-off rows for the actual work plan.
-
03 Print
Take the twelve rows to review
The annual total, net cost per occupied head and most expensive month are calculated from all twelve rows. Print the schedule for the next budget review.
Twelve-month dormitory budget
Staff accommodation twelve-month budget
Planning schedule based on the entered assumptions. Review occupancy, one-off timing and local supplier costs before approval.
- Annual net budget
- £78,818.12
- Net cost per occupied head per month
- £155.50
- Most expensive month
- June
| Month | Fixed | Variable | One-off | Recovered | Net |
|---|---|---|---|---|---|
| January | £4,200.00 | £2,956.80 | £0.00 | £1,056.00 | £6,100.80 |
| February | £4,210.36 | £2,964.09 | £0.00 | £1,056.00 | £6,118.45 |
| March | £4,220.74 | £2,971.40 | £422.07 | £1,056.00 | £6,558.22 |
| April | £4,231.15 | £2,978.73 | £0.00 | £1,056.00 | £6,153.88 |
| May | £4,241.59 | £2,986.08 | £0.00 | £1,056.00 | £6,171.66 |
| June | £4,252.05 | £2,993.44 | £1,822.31 | £1,056.00 | £8,011.80 |
| July | £4,262.53 | £3,000.82 | £690.12 | £1,056.00 | £6,897.48 |
| August | £4,273.05 | £3,008.23 | £0.00 | £1,056.00 | £6,225.27 |
| September | £4,283.59 | £3,015.64 | £0.00 | £1,056.00 | £6,243.23 |
| October | £4,294.15 | £3,023.08 | £0.00 | £1,056.00 | £6,261.23 |
| November | £4,304.74 | £3,030.54 | £266.48 | £1,056.00 | £6,545.76 |
| December | £4,315.36 | £3,038.01 | £1,232.96 | £1,056.00 | £7,530.33 |
Planning schedule based on the entered assumptions. Review occupancy, one-off timing and local supplier costs before approval.
Questions to check
These are the practical budget questions to settle before a dormitory cost review.
Why does the table have twelve rows?
A dormitory budget is easier to challenge when repairs, replacements and inflation are visible month by month. The annual total is the sum of the twelve calculated net rows.
Where do annual repairs and replacements appear?
The annual repairs amount is placed in the sixth scheduled month and annual replacements in the twelfth. Use one-off rows to place additional work in its actual month.
What does expected occupancy change?
It changes the number of occupied heads used for variable cost and recovery. Fixed cost stays attached to the building, whether every bed fills or not.
How is inflation applied?
The entered annual percentage is compounded gradually across the twelve scheduled months for fixed, variable and one-off costs. Recovery is kept at the entered per-person figure.
Can I adjust the budget without losing a file?
Yes. Add or remove one-off rows and edit the inputs in this browser. Nothing is uploaded or stored; print the finished schedule when the assumptions are agreed.