Page 1 · ADP payroll
Labour cost, vacancies and overtime by school
The sample Brandon asked for in November 2024: the ADP pay register joined to the campus budget, so the payroll page is the first slide of the pack.
Fig. 1
Labour cost by school vs budget
Labour cost (ADP)Budgeted labourOver budget
Fig. 2
Overtime hours & open FTE, month by month
24 months · selected period shaded
Page 2 · Board KPI strip
Budget vs actual, per-pupil spend, enrolment vs seats
The one-page strip for the board: finance from the GL by campus and fund, enrolment against budgeted seats, and the published outcomes the network reports on.
Fig. 3
Budget vs actual, month by month
Actual spendBudgetSelected period
What this board answers
Four questions from the leadership meeting
Every answer is a live number from this page
Fig. 4 · Signature view
Campus map — budget variance across the District
Dot size = budgeted seats · colour = actual vs budget for the selected fund and period · hover a campus
Fig. 5
Budget vs actual by fund
Fig. 6
Enrolment vs budgeted seats by campus
Average enrolment over the period against the seats the budget was built on · sorted by fill rate
Budgeted seatsEnrolled (≥ 97% of seats)Enrolled (below 97%)
Ask the data · private AI layer
A question typed into the board pack
Answers from this model and Friendship's own finance documents — runs on a server inside the network, student data out of scope
🔎
Which grants expire before June?Title I allowable-cost rule for this PO?Next PCSB financial submission date?
Table · export view
Campus roll-up for the pack appendix
Rows highlighted in gold are more than 2% over budget for the selected fund and period. Online campuses carry no facilities line, which is why their per-pupil figure sits lower.
