Source Lookup: Where Every Number Comes From
Use this to trace any chart number back to its original document and page.
Tax Levy ($30.2M in FY01 to $82.2M in FY24)
- FY01-FY10: FY10 ACFR page 121, “Property Tax Levies and Collections”
- FY05-FY14: FY14 ACFR page 117, same table
- FY15-FY24: FY24 ACFR page 129, same table
Tax Rate ($8.42 in FY03 to $8.56 in FY26)
Average Single Family Tax Bill ($11,055 in FY26)
Total FTE (599.6 in FY01 to 706.0 in FY24)
- FY01-FY10: FY10 ACFR page 127, “Full-time Equivalent Town Employees by Function”
- FY05-FY14: FY14 ACFR page 123, same table
- FY15-FY24: FY24 ACFR page 136, same table
Education FTE (400.1 in FY01 to 537.0 in FY24)
- Same ACFR pages as Total FTE, “Education” row
Population and School Enrollment
- FY01-FY10: FY10 ACFR page 125, “Demographic and Economic Statistics”
- FY05-FY14: FY14 ACFR page 121, same table
- FY15-FY24: FY24 ACFR page 134, same table
Group Insurance Spending ($8.0M in FY06 to $16.8M in FY27)
Pension Expenditure ($5.1M in FY01 to $12.5M in FY24)
- FY01-FY10: FY10 ACFR page 118, “Changes in Fund Balances,” “Pension benefits” row
- FY05-FY14: FY14 ACFR page 114, same table
- FY15-FY24: FY24 ACFR page 126, same table
- CAUTION: This line is volatile due to GASB accounting changes. Not a clean trend.
Pension Assessment - Budget Line ($5,380,625 in FY26)
- FY26-FY27: FY27 Proposed Budget page 4, Line 217 “Contributory Retirement Fund”
- FY27: $5,843,360 (same document)
OPEB Insurance Membership (642-748 active, FY11-FY24)
GIC Premium Rates ($24,107 in FY19 to $38,562 in FY26)
PERAC Retirement System (358 active, 339 retired in FY24)
FY26 Budget Line Items (every position and salary)
- FY26 General Fund Budget (Excel)
- Four sheets: TOWN BUDGET, SCHOOL BUDGET, TOWN PIVOT TABLE, SCHOOL PIVOT TABLE
- Key lookups:
- Town Administrator salary: TOWN BUDGET, “SB-DEPT HEAD” = $207,732
- Sustainability Coordinator: TOWN BUDGET, “PCD-SUSTAINABILITY COORD” = $79,445
- Grant Coordinator: TOWN BUDGET, “PCD-GRANT COORDINATOR” = $79,064
- Health Insurance Transfer: TOWN PIVOT TABLE, “HEALTH INS TSF” = $11,828,487
- Pension: TOWN PIVOT TABLE, “CONTRIB RETIRE” = $5,380,625
FY27 Deficit ($8,471,823)
Revenue and Expense Projections
Melrose/Stoneham Case Studies
Override Tier Amounts and Tax Impact
Extracted into:
data/override_town_line_items.csv has every town-side item funded at each tier (slide 6)
data/override_school_items.csv has school-side items by tier and fiscal year (slides 7-9)
data/override_draws_schedule.csv has the year-by-year draw schedule per tier (slides 10-12)
data/override_tax_impact_asf.csv has the annual and monthly tax impact on the average single-family home ($1,291,507) per tier per year (slides 13-15)
data/override_trash_schedule.csv has the Question 2 trash and recycling draw breakdown (slide 20)
Cumulative annual tax increase on avg single-family home ($1,291,507):
- Tier 1 ($9M): FY27 +$167.90, FY28 +$804.93, FY29 +$1,186.68 (full phase-in)
- Tier 2 ($12M): FY27 +$361.62, FY28 +$1,132.65, FY29 +$1,587.17
- Tier 3 ($15M): FY27 +$555.35, FY28 +$1,369.97, FY29 +$1,985.39
Each year’s draw stays on the levy permanently; Year 3 is the ongoing annual cost.
Marblehead Independent & Current Articles (referenced across site)