School Budgeting & Enrolment Forecasting: Per-Pupil Funding, Staff Costs & Reserves
Forecast next year's roll with grade progression ratios, price a per-pupil funding formula with a minimum guarantee, cost teachers on pay steps with September increments and on-costs, budget term-time support staff and non-staff lines, monitor spending against profiles, plan three years of reserves and close a deficit with ranked savings – 8 hands-on labs at one fictional primary school, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you build a school business manager's budget workbook for a fictional primary school, one checked formula at a time. You forecast next year's roll with grade progression ratios and an entry rate from births, then price a per-pupil funding formula with needs factors, a lump sum and a minimum funding guarantee. You cost teachers on a pay scale with September step increments, a pay award and employer on-costs, and budget term-time support staff with FTE. Then you build non-staff lines from their drivers, monitor spending against profiles, forecast the outturn, plan three years of income, costs and reserves, and close a deficit with a ranked savings plan.
Lessons
- Enrolment Forecasting: Grade Progression Ratios, Entry from Births & Next Year's Roll Pro
- Per-Pupil Funding: Basic Entitlement, Additional Needs, Lump Sum & a Minimum Guarantee Pro
- Teacher Salary Costs: Pay Steps, Part-Time FTE, September Increments & On-Costs Pro
- Support Staff Costs: Hourly Rates, Term-Time Contracts, FTE & Clean Inputs Pro
- Non-Staff Costs: Energy, Catering, Indexed Contracts & Per-Pupil Lines Pro
- Budget Monitoring: Spending Profiles, Variance to Date & Forecast Outturn Pro
- A Three-Year Budget: Income vs Costs, In-Year Balances & Reserves Pro
- Capstone: Closing the Deficit – Ranked Savings, Running Totals & Staff-Cost Ratio Pro