Cost Modeling
Interactive Budget Projection Calculator
Mirrors the current Excel logic from Expenditure Projections, with non-numeric enrollments treated as 0.
Scenario Inputs
Select a district to auto-load its CSV, or upload it manually.
Campus levels run in if/else-if order: Level 1 first, then Level 2, then Level 3, then Level 4. Lookback checks always require all selected prior years to match. For each level, choose whether current-year and lookback rules combine as OR or AND. If a campus misses all criteria, it is still assigned to Level 4. Campuses marked as ACE or ADSY are automatically assigned to Level 1 before other level criteria are applied.
Current Level Summary
Totals for the selected district: schools, teachers (FTE), students, and affected schools fed into (deduped by level order). Level exports download as Excel workbooks with an overview sheet and optional student performance sheet.
School Enrollment Map
Dot size scales with students and color represents feeder pattern. Map filter is independent from AIM level filters.
Budget Inputs
Overall projections
Load district CSV data to populate Level 1 staffing cost estimates.
Investment Inputs (Costs)
Staffing
Teachers
Principals/Campus Leadership
Other
Levels Counted as AIM Schools (Budget)
Defaults to Levels 1 and 2. This controls budget AIM/non-AIM calculations only.
School Grade Levels Counted as AIM Schools (Budget)
Select school types to include. Combination types appear automatically when present in district data.
FY25-26 Budget Inputs
Teacher-Student Ratio Scenario
Set district target students per teacher to model staffing-driven expenditure changes.
Staffing expenditure impact combines ratio-driven required teacher counts and the flat salary add-on, applied to each district’s scenario teacher salary.
AIM Uplift Weights (Function Code Increases)
Weighted using FWISD budget function shares (same as workbook row 23 logic).
Assumptions
Set district-wide salary assumptions for staff budgeting. These values drive the projection and campus cost views.
Projections
Review total projected staffing cost change across Level 1 campuses. Teacher apprentices use a zero current-cost baseline, and some districts may have partial current admin/support cost coverage.
Campuses
Review Level 1 campus staffing counts and costs. Projected columns use the Staffing tab logic, and current columns depend on the selected district’s campus master CSV coverage.
Projection Results
| Metric | FWISD |
|---|
Staffing
Vacancies & hiring
Review total filled and vacant Frontline staffing PFTE by category across included Level 1-4 schools.
Load district CSV data to view staffing vacancies.
Level 1 restructuring
Adjust model assumptions for Level 1 elementary, middle, and high school staffing.
Staffing Assumptions
SpEd Source Mode
Actual uses 2025 Enrollment: SpEd when available.
Assumed 10% uses 2025 Enrollment: Total × 10% fallback.
Load district CSV data to view staffing estimates.