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

career technical benchmarking
SMART_READER_LITE
LIVE PREVIEW

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 Todays Roadmap Benchmarking and State Funding State Funding Trend


slide-1
SLIDE 1

Career Technical Benchmarking

“A Case Study” Ernie Strawser, Consultant April 12, 2016

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

1

slide-2
SLIDE 2

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

slide-3
SLIDE 3

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?

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

3 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?

slide-4
SLIDE 4

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

4

Guarantee as % Cap as % Formula District

  • f Funding
  • f 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 Lockland Local SD 0.0% 39.93% 44.79% 65.40% $886,907 Hillsboro City SD 0.0% 0.00% 7.74% 62.29% $0 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 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 Reading Community City SD 0.0% 25.27% 11.97% 48.50% $173,648 Wilmington City SD 0.0% 32.92% 8.79% 47.35% $0 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 Southwest Local SD 4.8% 0.00% 0.00% 44.14% $0 Mason City SD 0.0% 0.00% 4.78% 42.53% $0 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 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

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? What did we miss?

slide-5
SLIDE 5

State Funding Trend

  • Categorical funding has dropped
  • Why?

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

5 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%

slide-6
SLIDE 6

State Share Index - Statewide

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

6

2009 2014 2015 2016 State Share Percentage 66.19% 64.60% 64.10% 65.30%

How does my district compare?

slide-7
SLIDE 7

Understanding State Share

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

7

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 Compare? Impacts Spec Ed., Weighted CTC

slide-8
SLIDE 8

State Share Benchmark

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

8

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%

2009 2014 2015 2016 State Share Percentage 66.19% 64.60% 64.10% 65.30%

Statewide

slide-9
SLIDE 9

Weighted Funding Benchmark

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

9

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%

slide-10
SLIDE 10

District Weighted Funding Benchmark

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

10

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%

slide-11
SLIDE 11

A Look At Member Profiles

  • Enrollment
  • Demographics
  • Funding

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

11

slide-12
SLIDE 12

‘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

slide-13
SLIDE 13

The Public Finance Resources Team

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

13 Matt Bunting, Consultant, has over 30 years of experience in the public finance sector. This includes 20 plus years as a school district treasurer, and 11 years with the Auditor of State where he led financial, legal compliance, and Federal single audits of government entities. Matt has helped develop financial forecasting tools, and providing instruction and training

  • pportunities attended and used by over two hundred of Ohio’s public school treasurers. Matt works with clients to help

determine a long-term operating strategy for the organization. He holds a Degree in Accounting from Hocking College, and is a Certified Government Financial Manager. Ryan Ghizzoni, Consultant, began his career with the Auditor of State’s Office and has served as a school district treasurer for the past 10 years. During his career, he has been the recipient of six Association of School Business Officials International Meritorious Budget Awards and was the recipient of the Ohio Association of School Business Officials 2011 Outstanding Treasurer of the Year Award. Ryan holds a Bachelors of Business Administration from the Youngstown State University, and is a Certified Administrator of School Finance and Operations. Debra Hoelzle, Chief Operations Officer, provides direct services to clients, and oversees the day-to-day operations of PFR. She brings with her operational experience from both the public and private sectors, including a school district and multiple corporations in the financial services industry. Debra holds her Masters of Business Administration from Ohio University, and her Bachelors of Science in Business Administration from The Ohio State University. Stacy Overly, Consultant, provides direct financial services to clients. He has over 20 years of experience serving as school district treasurer, including 15 plus years of developing financial forecasting tools, and providing instruction and training

  • pportunities attended and used by over two hundred of Ohio’s public school treasurers. Stacy works with clients to analyze

trends and review local economic data to help determine a long-term operating strategy for the organization. He holds his Masters of Business Administration and his Bachelors of Business Administration in Finance from Ohio University. Mike Sobul, Consultant, brings 30 years of experience in public finance and tax analysis. Currently a school district treasurer, Mike spent nearly 25 years with the Ohio Department of Taxation where he led revenue forecasting efforts and provided analysis , training, and fiscal services to schools and local governments. Mike holds a Masters Degree in Public Policy from the University of Michigan and a Bachelors Degree in Economics and Political Science from Wittenberg University. Ernie Strawser, Consultant, provides direct services to our public finance clients. He has over 30 years of public finance experience as a CFO, consultant, and developer and instructor of financial forecasting techniques and tools which have been used by over two hundred Ohio school district CFOs. Ernie works with clients to facilitate their understanding of local financial results , trends, and strategies. He holds both a Masters of Science in Administration from Central Michigan University and a Bachelor of Science in Finance from Ohio University.

slide-14
SLIDE 14

PUBLIC FINANCE RESOURCES: EMPOWERING THE PUBLIC'S FINANCIAL LEADERS

14

PFR Contact Information

Ernie Strawser

Consultant

Public Finance Resources, Inc.

PO Box 1822 Columbus, OH 43216

ernie@PFRCFO.com

Phone: 614-732-5948

Debra Hoelzle

Chief Operating Officer

Public Finance Resources, Inc.

PO Box 1822 Columbus, OH 43216

debra@PFRCFO.com

Phone: 614-732-5948

www.PFRCFO.com