To evaluate the long-term alignment between student enrollment levels and staffing levels in Warwick’s schools, a cumulative gap measure was used. This measure summarizes how differences in annual rates of change between enrollment and staffing accumulate over time. The following steps describe the methodology used to produce the cumulative gap metric.
A. Measurement of Annual Enrollment Change
For each reporting year, we calculated the year-over-year percentage change in student enrollment. This figure indicates the increase or decreases in enrollment compared with the prior year.
B. Measurement of Annual Staffing Change
A parallel calculation is conducted for staffing levels. The year-over-year percentage change in staffing reflects the adjustment in staffing relative to the previous reporting year. This measure ensures comparability with the enrollment change metric.
C. Calculation of the Annual Alignment Gap
To evaluate whether staffing changes are aligned with enrollment changes, we compute an annual alignment gap:
Negative Gap
Indicates enrollment declined at a greater rate than staffing, or enrollment decreased while staffing levels remained stable or increased.
A negative gap signals under-adjustment in staffing compared to enrollment changes.
Positive Gap
Indicates staffing declined at a greater rate than enrollment or staffing decreased while enrollment remained stable or increased.
A positive gap signals over-adjustment in staffing compared to enrollment changes.
This metric provides a year-by-year assessment of alignment between staffing and enrollment.
D. Development of the Cumulative Gap Indicator
To understand longer-term alignment patterns, annual gap values are cumulatively summed across reporting years. This cumulative gap indicator reflects the aggregated effect of enrollment–staffing misalignment over time.
More negative misalignment over the time measured indicates repeated years in which enrollment declined more than staffing, demonstrating sustained under-adjustment of staffing levels.
More positive misalignment over the time measured indicates repeated years in which staffing declined more than enrollment.
Purpose and Use of the Cumulative Gap Metric
The cumulative staffing–enrollment gap provides a long-term perspective on whether staffing actions have been proportional to shifts in student enrollment. The metric is used to:
- Document multi-year patterns relevant to student population.
- Support staffing levels associated with school building utilization.
- Identify areas where staffing may require strategic adjustment.
- Provide auditors and oversight bodies with evidence of systematic problems.
E. Gap Alignment Ratings
Gap Analysis calculates year-over-year percentage changes for enrollment and employment, highlighting divergences and identifying periods of alignment, moderate misalignment, or high misalignment.
F. Methodology for Estimating Excess Staffing Relative to Enrollment Trends
In addition to evaluating alignment between year-over-year percentage changes in enrollment and staffing, we calculated the extent of “excess staffing” by estimating how many staff members would have been expected in each year if staffing levels had changed at the same proportional rate as student enrollment. This analysis provides a quantifiable measure of staffing variance relative to enrollment.
i. Establishing Expected Staffing Levels
For each reporting year, an expected staffing value was calculated by applying the annual enrollment percentage change to the prior year’s actual staffing level. This represents the staffing level that would have resulted had it declined or increased at the same proportional rate as enrollment.
This method ensures that expected staffing reflects the precise enrollment trend for each year.
ii. Determining Excess Staffing
Excess staffing is calculated as the difference between the school department’s actual staffing level and the expected staffing level for each year:
Interpretation:
Positive excess staffing indicates the institution employed more staff than would be expected.
Negative excess staffing indicates staffing levels were lower than expected.
This calculation provides a concrete measure of the magnitude of misalignment and translates percentage-based gaps into actual staffing counts.
iii. Uses of the Excess Staffing Metric
The excess staffing measure serves several analytic and compliance-focused purposes:
- It quantifies the operational impact of enrollment–staffing misalignment.
- It supports internal decision-making regarding staffing adjustments.
- It provides auditors with transparent, evidence-based justification for staffing patterns.
- It highlights years in which staffing decisions were responsive or not to enrollment changes.
iv. Relationship to the Cumulative Gap Metric
While the cumulative gap metric summarizes the direction and magnitude of misalignment over time, the excess staffing measure translates this misalignment into actual staffing counts, offering a more concrete operational interpretation. The two measures together provide a comprehensive view of absolute alignment between staffing and enrollment.
G. Methodology for Estimating the Financial Impact of Excess Staffing
To translate excess staffing levels into a measurable financial impact, we applied a cost model that assigns an annual dollar value to each excess position. This model incorporates both a base staffing cost and year-specific inflation adjustments, ensuring that cost estimates reflect economic conditions across the reporting period.
i. Establishing the Base Cost of an Excess Position
Beginning in 2007—the first year in which a year-over-year staffing–enrollment gap could be calculated—this report assigned a base annual cost of $80,000 per excess staff position. This amount represents a standardized estimate of total compensation, inclusive of salary and benefits, associated with a full-time position.
ii. Application of Annual CPI Adjustments
To ensure that the estimated financial impact reflects changes in labor costs and purchasing power, the base cost was adjusted annually using the Consumer Price Index (CPI). For each year following 2007, the prior year’s adjusted cost was multiplied by (1 + CPI for that year), producing a year-specific cost per excess position.
This approach accounts for normal inflationary increases in the cost of staffing.
iii. Calculating the Annual Financial Impact
The total annual financial impact of excess staffing was calculated by multiplying:
This yields a dollar-based estimate of the staffing variance for each year, reflecting both the number of excess positions and the inflation-adjusted cost of each position.
iv. Interpretation and Use
This financial model provides a standardized, inflation-adjusted estimate of the cost associated with maintaining staffing levels above what would have been expected based on enrollment decline. The resulting annual and multi-year financial impacts:
- quantify the budgetary implications of staffing patterns,
- support audit and accreditation compliance by demonstrating a systematic approach to resource deployment,
- inform leadership decisions regarding long-term staffing strategy and efficiency, and
- supplement the cumulative gap metrics with a concrete monetary analysis.
This methodology ensures that the financial impact assessment is consistent, transparent, and aligned with recognized economic indicators.
H. Three Phase Alignment Breakdown
The period from 2006 to 2025 represents two decades of enrollment decline and evolving staffing patterns within the Warwick School Department. To make sense of these long-term trends, this study divides the 19 years into three phases. Each phase reflects a unique combination of enrollment pressures, employment decisions, governance actions, and fiscal outcomes.
- Phase I - Strategic Alignment2007–2013
- Phase II - Reactive Alignment2014–2019
- Phase III - Structural Decoupling2020–2025
I. ESSER COVID Funding Impact
During COVID-years (2020–2024), Warwick received over $19 million in one-time federal relief through Elementary and Secondary School Emergency Relief (ESSER) and American Rescue Plan (ARP) programs. These funds were used to sustain staffing rather than restructuring operations. When they expired, many of these temporary positions were absorbed into the district’s baseline budget. This decision widened the cumulative gap and created a structural imbalance that is central to the current fiscal crisis.
The funds allocated to the Warwick School Department are displayed in the table below.
| ESSER Program | Fiscal Year | Dollars Expensed |
|---|---|---|
| ESSER I (CARES Act) | 2021 | $1,488,005 |
| ESSER II (CARES Act) | 2021 | $5,429,122 |
| ESSER III (ARP Act) | 2023 | $12,196,862 |
| Total | — | $19,113,989 |
📱 Rotate your phone to landscape or swipe horizontally to view the complete table.
According to the City of Warwick Audited Annual Financial Reports from June 30, 2020, through June 30, 2024, ESSER fund usage by the school department from 2020 through 2024 is displayed in the table below.
The ESSER III grant allowed expenditures through September 30, 2024, which fall into the district’s FY2025 fiscal year. Warwick’s FY2025 audit has not yet been released; therefore, the FY25 amount reflects the remaining unreported portion of the total allocation, calculated as the difference between the full RIDE ESSER allocation ($19,113,989) and the ESSER revenue recognized in the FY2021–FY2024 audits ($18,119,469). This figure may include final ESSER reimbursements and/or indirect cost adjustments.
| Fiscal Year | ESSER Funds Used | % of Total | Dollars Used |
|---|---|---|---|
| 2020 | None | 0% | — |
| 2021 | ESSER I & early ESSER II | 14.5% | $2,766,156 |
| 2022 | ESSER II & early ESSER III | 49.8% | $9,523,819 |
| 2023 | ESSER III | 24.1% | $4,603,822 |
| 2024 | Final ESSER III liquidation | 6.4% | $1,225,672 |
| 2025 | Estimated ESSER III final drawdown | 5.2% | $994,520 |
| Total | — | 100% | $19,113,989 |
📱 Rotate your phone to landscape or swipe horizontally to view the complete table.
1 RIDE, ESSER COVID Fund Allocation by school district
2 Warwick Audited Annual Financial Reports 2020–2024