Career Technical Benchmarking A Case Study Ernie Strawser, - PowerPoint PPT Presentation

Career Technical Benchmarking “A Case Study” Ernie Strawser, Consultant April 12, 2016 PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 1

Today’s Roadmap • Benchmarking and State Funding • State Funding Trend • State Share Percentage • The ½ mill charge-off • Member District Profile PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 2

Benchmarking Tips • Developing a “Target Rich” Approach • What questions do I want answered? • Higher level variables first • Will it make a difference? • Can I change it or respond? Which of my district's state funding is driven by enrollment? (Cap vs. Guarantee) Which of my district's lose foundation funding with enrollment loss? Which district's have the highest and lowest % of state share funding? PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 3

Guarantee as % Cap as % Formula District of Funding of Funding Above Guarantee SSI Capacity $ North College Hill City SD 0.0% 27.03% 16.15% 79.15% $789,698 Mount Healthy City SD 0.0% 11.93% 7.50% 75.97% $0 Fairfield Local SD 0.0% 2.40% 26.27% 74.10% $1,055,222 Greenfield Exempted Village SD 0.0% 0.00% 9.30% 72.82% $363,198 Washington Court House City SD 0.0% 10.16% 8.44% 71.30% $127,970 Lynchburg‐Clay Local SD 0.0% 0.00% 11.76% 70.67% $774,072 Blanchester Local SD 0.0% 0.00% 0.96% 67.54% $493,226 Goshen Local SD 0.0% 0.00% 5.63% 66.41% $0 Batavia Local SD 0.0% 28.50% 8.57% 65.60% $93,273 Which of my district's Lockland Local SD 0.0% 39.93% 44.79% 65.40% $886,907 state funding is driven by Hillsboro City SD 0.0% 0.00% 7.74% 62.29% $0 enrollment? (Cap vs. St Bernard‐Elmwood Place City SD 0.0% 26.26% 26.09% 58.58% $639,472 East Clinton Local SD 0.0% 0.00% 3.29% 58.00% $343,615 Guarantee) Winton Woods City SD 0.0% 13.97% 7.50% 55.41% $0 Finneytown Local SD 0.0% 0.54% 9.56% 50.15% $120,531 Which of my district's lose Reading Community City SD 0.0% 25.27% 11.97% 48.50% $173,648 foundation funding with Wilmington City SD 0.0% 32.92% 8.79% 47.35% $0 enrollment loss? Clinton‐Massie Local SD 0.1% 0.00% 0.00% 46.11% $0 Oak Hills Local SD 0.0% 0.00% 3.78% 45.33% $0 Milford Exempted Village SD 0.0% 6.58% 7.50% 45.14% $0 Which district's have the Southwest Local SD 4.8% 0.00% 0.00% 44.14% $0 highest and lowest % of Mason City SD 0.0% 0.00% 4.78% 42.53% $0 state share funding? Wyoming City SD 0.0% 0.00% 0.75% 42.47% $0 West Clermont Local SD 0.0% 0.00% 2.32% 42.17% $0 Norwood City SD 1.9% 0.00% 0.00% 39.21% $0 Clermont Northeastern Local SD 0.0% 0.00% 2.38% 38.74% $0 Miami Trace Local SD 0.0% 0.00% 12.21% 36.17% $0 Loveland City SD 0.0% 0.00% 3.07% 35.28% $0 Deer Park Community City SD 0.0% 0.00% 1.92% 34.31% $0 Forest Hills Local SD 0.1% 0.00% 0.00% 32.76% $0 What did we miss? Mariemont City SD 1.2% 0.00% 0.00% 24.00% $0 Three Rivers Local SD 0.2% 0.00% 0.00% 23.72% $0 Madeira City SD 16.2% 0.00% 0.00% 18.58% $0 Princeton City SD 0.0% 83.84% 7.50% 13.48% $0 Indian Hill Exempted Village SD 0.0% 18.14% 7.50% 5.00% $0 Sycamore Community City SD 0.0% 17.94% 7.50% 5.00% $0 PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 4

State Funding Trend 2012 2013 2014 2015 2016 Formula Aid $151,172,156 $151,172,156 $139,413,355 $136,490,150 $142,035,867 CTE Weighted $72,743,285 $72,743,285 $60,481,191 $61,701,257 $65,147,751 All Other $39,076,383 $39,076,383 $63,097,278 $70,744,692 $68,005,544 Total State Foundation $262,991,824 $262,991,824 $262,991,824 $268,936,099 $275,189,162 Calculated Funding $271,708,600 $270,084,532 $277,547,982 Guarantee $17,172,962 $17,172,962 $31,962,557 $32,162,535 $26,165,709 CTE Weighted 0.0% ‐16.9% 2.0% 5.6% Total State Foundation 0.0% 0.0% 2.3% 2.3% Calculated Funding ‐0.6% 2.8% Guarantee 0.0% 86.1% 0.6% ‐18.6% • Categorical funding has dropped • Why? PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 5

State Share Index - Statewide 2009 2014 2015 2016 State Share Percentage 66.19% 64.60% 64.10% 65.30% How does my district compare? PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 6

Understanding State Share Calculating State Share Current Current + 25 ADM Aid Per Pupil $5,900 $5,900 Funded ADM 1,911 1,936 Total Funding $11,274,900 $11,422,400 $147,500 Local Share Valuation $5,485,481,197 1/2 Mill 0.0005 ($2,742,741) ($2,742,741) $0 State Funding $8,532,159 $8,679,659 $147,500 Local Share 24.33% 24.01% ‐0.31% State Share 75.67% 75.99% 0.31% Impacts Spec Ed., Weighted CTC Statewide Compare? PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 7

State Share Benchmark Calculating State Share Current Current + 25 ADM Aid Per Pupil $5,900 $5,900 Funded ADM 1,911 1,936 Total Funding $11,274,900 $11,422,400 $147,500 Local Share Valuation $5,485,481,197 1/2 Mill 0.0005 ($2,742,741) ($2,742,741) $0 State Funding $8,532,159 $8,679,659 $147,500 Local Share 24.33% 24.01% ‐0.31% State Share 75.67% 75.99% 0.31% Statewide 2009 2014 2015 2016 State Share Percentage 66.19% 64.60% 64.10% 65.30% PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 8

Weighted Funding Benchmark Statewide Statewide Statewide 2014 2015 2016 ADM 37,551 36,713 37,840 Weighted CTC 1 10,226 27.23% 10,547 28.73% 10,451 27.62% CTC 2 6,383 17.00% 6,225 16.96% 6,175 16.32% CTC 3 1,387 3.69% 1,255 3.42% 1,233 3.26% CTC 4 10,069 26.81% 11,305 30.79% 11,230 29.68% CTC 5 1,393 3.71% 1,244 3.39% 1,221 3.23% % of Student FTE "Weighted" as % of Funded 78.45% 83.28% 80.10% Formula Aid $139,413,355 $136,490,150 $142,035,867 Weighted as % of Formula $4,992 CTC 1 $30,837,845 22.12% $31,639,225 23.18% $33,444,972 23.55% $4,732 CTC 2 $17,609,010 12.63% $17,178,351 12.59% $18,192,967 12.81% $1,726 CTC 3 $1,591,997 1.14% $1,435,529 1.05% $1,493,905 1.05% $1,466 CTC 4 $9,194,775 6.60% $10,340,512 7.58% $10,864,713 7.65% $1,258 CTC 5 $1,247,564 0.89% $1,107,640 0.81% $1,151,194 0.81% Associated Services $4,269,931 $4,422,152 $4,657,728 State Share Percentage 64.60% 64.10% 65.30% PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 9

District Weighted Funding Benchmark Statewide 2016 2016 District ADM 37,840 1,911 Weighted CTC 1 10,451 27.62% 496 25.95% CTC 2 6,175 16.32% 220 11.51% CTC 3 1,233 3.26% 15 0.78% CTC 4 11,230 29.68% 643 33.65% CTC 5 1,221 3.23% 121 6.33% % of Student FTE "Weighted" as % of Funded 80.10% 78.23% Formula Aid $142,035,867 $8,222,668 Weighted as % of Formula $4,992 CTC 1 $33,444,972 23.55% 1,872,823 22.78% $4,732 CTC 2 $18,192,967 12.81% 788,106 9.58% $1,726 CTC 3 $1,493,905 1.05% 201,398 2.45% $1,466 CTC 4 $10,864,713 7.65% 713,985 8.68% $1,258 CTC 5 $1,151,194 0.81% 115,174 1.40% Associated Services $4,657,728 $291,927 State Share Percentage 65.30% 75.67% PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 10

A Look At Member Profiles • Enrollment • Demographics • Funding PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 11

‘Take Aways’ • Benchmark Focus – recognize data windmills • What questions are you answering • Incorporate year-over-year comparison • Be able to explain results, draw conclusions, and if applicable make recommendations. PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS 12