Blog · Board and management reporting · Education
K-12 analytics connects enrollment, staffing and spending summaries for administrative decisions. Work through a school-level comparison, reconcile the totals and separate capacity questions from classroom decisions.
K 12 analytics connects enrollment, staffed positions and budget actuals so school administrators can see where operating resources differ from the plan. The useful comparison starts with reconciled school summaries and consistent dates. It supports finance and operations reviews; staffing ratios alone cannot determine classroom assignments or student needs.
A district business office might ask: where did enrollment move, where are authorized positions unfilled, and which schools spent above their phased operating budgets? These are related questions, but they have different denominators. Combining them in one table does not make one measure an explanation for another.
Enrollment is a count at a specified date. Staffing is a position measure at a specified date, expressed in full-time equivalents, or FTE. Spending is activity across a period. Label each basis so a reader can distinguish a closing snapshot from a monthly flow.
Keep the scope administrative. The US Census Bureau's school finance survey covers public school system revenues, expenditures, debt and assets. Its categories provide context for financial reporting, but a local monthly operating comparison needs its own explicit cost scope rather than an unsupported comparison with an annual national figure.
Use a stable school identifier across the files. Names alone can change after a merger or a reporting-system update.
| Summary | Required fields | Reconciliation |
|---|---|---|
| Enrollment | School ID, count date, planned enrollment, actual enrollment | Sum school counts to the official enrollment report for that date |
| Positions | School ID, effective date, authorized teaching FTE, staffed teaching FTE | Tie authorized positions to the approved register and staffed assignments to HR records |
| Spending | School ID, fiscal month, cost scope, phased budget, actual spending | Tie actuals to the same school-managed accounts in the ledger |
One approved full teaching assignment counts as one FTE under the hypothetical district's definition. Two half assignments together count as one FTE. Keep support staff separate unless the measure explicitly includes them, and show vacant positions separately from staffed assignments.
The finance file should contain the budget phased for the month being reviewed. An annual allocation divided evenly across months can create a misleading variance when payroll calendars or contracted services are uneven. Variance analysis explains the broader budget comparison; this review adds the enrollment and position context.
Consider an illustrative US district with three schools. Enrollment and staffing are snapshots at September 30, 2026. Spending covers September 2026 and includes only school-managed operating accounts; central administration and construction costs are excluded from both budget and actuals.
| School | Planned enrollment | Actual enrollment | Authorized teaching FTE | Staffed teaching FTE | September budget (USD) | September actual (USD) |
|---|---|---|---|---|---|---|
| Cedar Elementary | 620 | 600 | 31.0 | 30.0 | 700,000 | 720,000 |
| Maple Middle | 480 | 500 | 25.0 | 25.0 | 630,000 | 600,000 |
| Lake High | 300 | 300 | 20.0 | 20.0 | 420,000 | 450,000 |
| School subtotal | 1,400 | 1,400 | 76.0 | 75.0 | 1,750,000 | 1,770,000 |
Calculate the measures from those same rows:
Enrollment difference = Actual enrollment − Planned enrollment
Unfilled teaching FTE = Authorized teaching FTE − Staffed teaching FTE
Students per teaching FTE = Actual enrollment / Staffed teaching FTE
Spending difference = Actual spending − Phased budget
Period operating cost per student = Period operating spending / Snapshot enrollment
Positive spending differences mean actual spending exceeded budget. The cost-per-student measure below is a local monthly management measure, not an annual per-pupil expenditure statistic. Ratios and dollar amounts are rounded to two decimals; calculations use unrounded values.
| School | Enrollment difference | Unfilled FTE | Students per teaching FTE | Spending difference (USD) | September operating cost per student (USD) |
|---|---|---|---|---|---|
| Cedar Elementary | -20 | 1.0 | 20.00 | 20,000 | 1,200.00 |
| Maple Middle | 20 | 0.0 | 20.00 | -30,000 | 1,200.00 |
| Lake High | 0 | 0.0 | 15.00 | 30,000 | 1,500.00 |
| School subtotal | 0 | 1.0 | 18.67 | 20,000 | 1,264.29 |
For Cedar, the staffing ratio is 600 / 30 = 20.00, and the spending difference is 720,000 − 700,000 = $20,000. The school subtotal ratio is 1,400 / 75 = 18.67. Calculate it from total enrollment and total FTE; do not average the school ratios.
The spending bridge is equally visible: 20,000 − 30,000 + 30,000 = $20,000 above budget. Dividing that difference by the $1,750,000 phased budget gives 1.14% above budget, rounded to two decimals. The school-managed cost per student is 1,770,000 / 1,400 = $1,264.29.
Enrollment met the district plan in total, but Cedar is below plan while Maple is above it. A district total alone hides that distribution. Enrollment administration should confirm whether the difference reflects transfers, boundary changes or an earlier planning assumption before operations changes a staffing plan.
Cedar also has an unfilled teaching FTE while spending exceeds budget. That combination does not prove that vacancy generated the overrun. Finance should inspect account details for substitute costs, timing and other included expenses, while HR verifies the position's effective dates. Headcount planning provides the wider distinction between authorized roles and filled assignments.
Lake has a lower student-to-teacher ratio and higher period cost per student. Those observations do not establish excess staffing. The NCES explanation of pupil/teacher ratios notes that these ratios include special teachers generally excluded from class-size calculations. The administrator needs the school's service responsibilities and schedule before interpreting the difference.
Finance owns the spending tie-out, HR owns teaching assignments, and enrollment administration owns the count. Operations owns the follow-up list. Record a question, an owner and the source rows behind it; the aggregate table should direct review rather than substitute for it. Budget redesign is a separate exercise covered in zero-based budgeting for education.
Bring a sample of your own aggregated enrollment, position and budget exports to Covirage, where columns are mapped and its tools compute and check the school comparisons. The external AI model explains the results with every figure traced to its rows; artificial intelligence in business gives the broader context for checking numerical explanations. Create a free Covirage account, which takes about a minute, then set up your organization and bring your summaries.
See Covirage for education for the supporting administrative reporting context.
Start with school-level enrollment counts, authorized and staffed positions in full-time equivalents, and phased operating budgets with actual spending. Include school identifiers, reporting dates and fund or department scope. Aggregate summaries are sufficient for the operational comparisons here; individual student records are unnecessary.
No. A school-wide ratio divides enrollment by teacher full-time equivalents and can include teachers outside ordinary classroom assignments. Class size requires class-level rosters and schedules. Use the staffing ratio to identify questions for administrators, then examine the relevant schedules before changing assignments.
Yes, if the spending period, included costs and enrollment basis are consistent. Label a monthly operating-cost measure clearly and disclose central costs excluded from it. Differences can reflect service responsibilities, staffing arrangements or timing, so the ratio alone does not establish efficiency.
Finance should own spending definitions and reconciliation, human resources should own position and staffing counts, and enrollment administration should own the official population. A designated operations leader should assemble the comparison and assign follow-up questions to the people responsible for the underlying records.