Pattonville School District 2018-19 Budget Executive Summary - - PowerPoint PPT Presentation

Pattonville School District 2018-19 Budget

Executive Summary

• Operating budget shows a net surplus of $1.6 million
• Beginning operating reserves are 34.07% of expenses (no borrowing)
• Final year of three year agreement for staff (3.75%)

(Actual increase is 3.2% and three year average was 2.8% due to SIP in 2016)

• Health insurance to increase 3.5% (0% prior four years)
• 1% increase in property values non-reassessment year
• Normal text book adoption cycle $1million
• Vehicle replacements (4 buses, 2 maintenance)
• Middle school laptop replacement (iPads)
• No transfer students from unaccredited districts

Different Funds

General Special/ Teacher

Capital

Operating

Debt Bond

District

Operating Fund Summary

Reserves Amount Percent

2012 Prop P Estimate

Beginning Balance 31,254,338 34.06%

30.41%

Net Surplus 1,110,368 Total Ending Balance 32,364,706 34.59%

30.39%

The district must have approximately 26% in beginning reserves to avoid short-term borrowing in the fall

Revenue Budget

($99.7 million excluding bond sales)

Local 87% State 9% Federal 4%

Assessed Value of Property

1,000,000,000 1,100,000,000 1,200,000,000 1,300,000,000 1,400,000,000 14-15 15-16 16-17 17-18 18-19

Assessed Valuation

Assessed values are below 2008 levels

Food Services

2013-14 2014-15 2015-16 2016-17 2017-18 (est) Revenues 2,023,894 2,437,252 2,539,541 2,617,252 2,804,000 Expenditures (2,278,888) (2,269,336) (2,301,720) (2,406,894)(2,575,000) Gain/(Loss) w/o Indirect Cost (254,994) 167,916 237,821 210,358 229,000 50% Indirect Cost (123,088) (130,279) (121,424) (136,450) (150,500) Net Gain/(Loss) (378,082) 37,637 116,396 73,908 78,500

2018-19 budget is based on: $2.45 Elementary from $2.40 $2.65 Secondary from $2.60 $3.35 Adult from $3.30 Change is comparable to area districts, and required by USDA

State Funding

Actual Reimbursement Full Reimbursement

Estimated Full Funding Shortfall Foundation Formula 4,739,300 4,739,300 ECSE 3,685,000 3,685,000 Transportation 415,000 1,482,300 (1,067,300) Other 260,000 260,000 Total 9,099,300 10,166,600 (1,067,300)

Expenditure Budget

($99.3 million excluding bond construction)

Salaries/Benefits

($77.6 million)

Elementary Staffing

School Grade Level Ratio

(based on forecast algorithm)

K 1 2 3 4 5 Bridgeway 20.0 20.7 16.3 23.3 21.3 19.5 Drummond 20.9 19.7 21.7 23.0 22.4 25.0 Parkwood 21.7 19.8 22.5 21.8 22.3 23.3 Remington 19.7 18.0 21.0 19.5 22.3 22.2 Rose Acres 19.6 18.3 18.3 18.3 21.8 25.0 Willow Brook 20.8 20.5 20.6 19.5 21.3 21.0

PSD Standard 20-22 20-22 20-22 20-25 20-25 20-25

Below/Lower End of Standard Meet Standard Exceeds Standard

Secondary Staffing

High School Student/Classroom Teacher Ratios 2011 2012 2013 2014 2015 2016 2017 Parkway Central High 17 16 17 18 17 17 16 North High 17 17 17 17 17 16 16 South High 17 17 17 17 18 17 18 West High 18 17 18 17 16 18 18 Rockwood Eureka High 20 19 18 21 17 19 21 Lafayette High 22 23 23 22 18 20 22 Marquette High 22 23 24 23 19 20 23 Rockwood Summit High 20 22 22 22 18 19 21 Pattonville Pattonville High 19 20 21 20 20 19 19

Secondary Staffing

Middle School Student/Classroom Teacher Ratios 2010 2011 2012 2013 2014 2015 2016 Parkway Central Middle 14 14 13 14 15 14 13 Northeast Middle 14 13 14 14 14 13 14 South Middle 13 13 14 14 13 13 13 Southwest Middle 14 14 14 14 16 16 16 West Middle 14 13 14 14 15 15 15 Rockwood Crestview Middle 17 17 17 16 16 17 17 Lasalle Springs Middle 17 18 17 17 17 16 16 Rockwood South Middle 18 18 17 17 17 18 17 Rockwood Valley Middle 15 16 15 15 15 15 15 Selvidge Middle 15 16 15 15 14 15 14 Wildwood Middle 17 17 16 16 15 15 14 Pattonville Holman Middle 13 14 15 14 14 13 14 Heights Middle 14 13 13 13 13 14 14

Total Teacher Staffing

District Average Salary+Benefits Students per Teacher Kirkwood 77,716 13.40 Pattonville 75,212 11.88 Webster 74,561 14.17 Parkway 73,829 13.56 Ritenour 68,825 17.34 Lindbergh 67,791 15.65 Francis Howell 67,438 14.85 Rockwood 67,082 14.34 Hazelwood 66,555 14.31

• St. Charles

60,016 11.30

• Ft. Zumwalt

59,973 14.87 Pattonvilles lower student to teacher ratio vs. Kirkwood is valued at $4,001,491 or $8,545 per Teacher

Support Staffing (FTE)

2017-18 2018-19 Change Business Office 4 5 1 Custodian 76 76 Food Services 27 27 Maintenance 21 21 Nurse 12 12 Office Staff 61 61 Paraprofessional 67 67 Printing 5 4

• 1

Social Worker 3 3 Student Supervision 8 8 Technology* 25 25 Transportation 37 37 Support Staff 346 346

*Added 1 hour per day to library/technology aids

Health Insurance

Percent Increase 0% 75% 150% 225% 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018

National Insurance Premiums Pattonville Insurance Premiums Overall Inflation

Text Book Adoptions

Recurring Costs Math Journals 63,000 Science Journals 18,000 Middle School Electives 3,000 Online Education 40,000 Naviance 25,000 6-8 Consumables 5,500 Curriculum Database 12,000 Early Childhood 5,000 New Courses 40,000 New Adoptions Health 220,000 Modern language 171,000 Online textbooks 150,000 Music 58,000 Math 20,000 Total Textbook Budget 830,500

$250,000 $500,000 $1,000,000 13-14 $750,000 16-17 17-18 14-15 15-16 18-19

Capital Spending-$3,189,865 Decreased 9.25% or $207,131 from 2017-18

Allowance for 4 new busses

Model Year Number of Busses 2003 2 2004 4 2005 2 2007 11 2008 9 2009 4 2010 2 2014 7 2015 1 2016 6 2017 6 2018 4 Total 58

Average bus age will be 7.3 years

2015 secondary laptop lease payment 566,869 Elementary iPad 1 to 1 lease payment 385,228 4 new type C school buses 360,000

• Cert. of participation HO and WB energy improvements

314,000 2018 middle school iPad lease payment 265,053 2016 teacher MacBook/student iPad replacement lease payment 231,097 Music instrument replacements 100,000 Paint interior of Drummond 100,000 Copier/printer lease 97,956 Replace maintenance truck/snowplow #177 58,000 Uninterrupted power source (UPS) replacements 50,000 Box truck with lift gate 46,000 PLTW gateway labs replacement 38,500 CAD lab replacement 27,930 Other (less than $25,000) 549,232 3,189,865

$1,000,000 $2,000,000 $3,000,000 11-12 12-13 13-14 14-15 15-16 16-17 17-18

Budget Initiatives - Stop Loss Captive

Example $750,000 Major Medical Claim $0 $125,000 $250,000 $375,000 $500,000 $625,000 $750,000 Francis Howell Northwest Pattonville

300,000 300,000 200,000 300,000 300,000 300,000 150,000 150,000 250,000

Deductible Captive Layer Stop Loss

Based on year to date 2017-18 data this may save the district $50,000- $100,000.

Budget Initiatives - Employee Health Clinics

Case Study by QuikTrip Corporation

$0 $275,000 $550,000 $825,000 $1,100,000 AVG savings per month AVG savings per year

$1,063,475 $88,623

QuikTrip Corporation, 2016

Potential Savings

$0 $50 $100 $150 $200

• Avg. per Visit
• Avg. per Visit

$126 CareATC $59 Savings $185 Retail

A particular focus is also placed on assisting those employees who currently have chronic health needs, and more importantly helping employees improve their health before developing chronic health concerns. The district provider anticipates a savings of about $0.30 for every $1.00 spent at the clinic. The anticipated savings is expected to be approximately $150,000 per year and grow over time.

Budget Initiatives - Performance Contracting

$126 CareATC $59 Savings $185 Retail

Projected Utility Cost Savings Operational & Maintenance Cost Savings Capital Cost Avoidance Savings Grants & Rebates Additional Funding Total Funds Available Construction $85,105 $0 $4,270,662 $422,025 $0 $4,777,792 1 $354,037 $73,653 $0 $427,690 2 $368,199 $75,863 $0 $444,062 3 $382,927 $78,139 $0 $461,066 4 $398,244 $80,483 $0 $478,727 5 $414,173 $82,897 $0 $497,070 6 $430,740 $85,384 $0 $516,124 7 $447,969 $87,946 $0 $535,915 8 $465,888 $90,584 $0 $556,472 9 $484,523 $93,302 $0 $577,825 10 $503,904 $96,101 $0 $600,005 11 $524,061 $98,984 $0 $623,045 12 $545,023 $101,954 $0 $646,977 13 $566,824 $105,013 $0 $671,837 14 $589,497 $108,163 $0 $697,660 15 $613,077 $111,408 $0 $724,485 TOTALS $7,174,191 $1,369,874 $4,270,662 $422,025 $0 $13,236,752

• gram

Program Year Savings & New Revenue Program Data Program Cost $10,251,097 Comprehensive Energy Audit Fee $0 Total Program Cost $10,251,097 Less Up Front Cash Buydown $0 Net Financed Costs $10,251,097 Rebates/Incentives Contribution $422,025 72 % 15 2 8 $0 13 Projected Savings Data % Savings Total Utility Savings $340,420 33.16% Electric Savings $259,070 28.78% Gas Savings $44,650 35.33% Water Savings $36,700 37.24% Operational Savings $71,508 1.94% Capital Cost Avoidance Savings $4,270,662 Additional Annual Funding $0 05 62 90 86 25 82 28 37 80 27 47 07 75 15 92 67 ,213

Propositon K included $2.5 million in HVAC/ Lighting at SR, RA, PW, and HT. However, by utilizing PC that scope of work was increased to $10.3 million. The additional work is 100% funded by utility/operational savings.

Projections

2017-18 2018-19 2019-20 2020-21 Budget Projection Projection Projection Local Revenue 80,076,300 82,794,900 83,709,500 86,181,400 Other Revenue 12,802,428 12,957,500 13,114,200 13,273,000 Total Revenue 92,878,728 95,752,400 96,823,700 99,454,400 Salaries/Benefits 76,290,636 77,998,500 80,338,500 83,135,000 Other Expense 15,477,724 15,571,100 15,665,100 15,821,700 Total Expense 91,768,360 93,569,600 96,003,600 98,956,700 Net 1,110,368 2,182,800 820,100 497,700 Beginning Fund Balance 31,254,338 32,364,706 34,547,506 35,367,606 Ending Fund Balance 32,364,706 34,547,506 35,367,606 35,865,306 Beginning % of Exp. 34.06% 34.59% 35.99% 35.74%

Debt Service

Payments Reserves

2014 2019

Operating Fund Balance Projection

Required Beg Balance(26%) Actual Beginnning Balance

Short-term borrowing in 2014-15

Questions?