Pattonville School District 2019-20 Budget Executive Summary - - PowerPoint PPT Presentation
Pattonville School District 2019-20 Budget Executive Summary Operating budget shows a net surplus of $0.4 million Beginning operating reserves are 35.45% of expenses (no borrowing) First year of three year agreement for staff (3.60%)
(Actual increase is 0.27% due to SIP in 2018)
General Special/ Teacher
Capital
Operating
Debt Bond
District
Reserves Amount Percent
2012 Prop P Estimate
Beginning Balance 34,854,016 35.45%
30.39%
Net Surplus 402,752 Total Ending Balance 35,256,768 35.08%
30.60%
The district must have approximately 26% in beginning reserves to avoid short-term borrowing in the fall
($105.8 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 1,500,000,000 15-16 16-17 17-18 18-19 19-20
Assessed values are just getting back to 2008 levels
Food Services
2013-14 2014-15 2015-16 2016-17 2017-18 2018-19 (est) Revenues
2,023,894 2,437,252 2,539,541 2,617,252 2,694,808 2,836,000
Expenditures
(2,278,888) (2,269,336) (2,301,720) (2,406,894) (2,617,499) (2,689,480)
Gain/(Loss) w/o Indirect Cost
(254,994) 167,916 237,821 210,358 77,309 146,520
50% Indirect Cost
(123,088) (130,279) (121,424) (136,450) (142,571) (144,000)
Net Gain/ (Loss)
(378,082) 37,637 116,396 73,908 (65,262) 2,520 2019-20 budget is based on: $2.55 Elementary from $2.45 $2.75Secondary from $2.65 $3.45 Adult from $3.35 Change is comparable to area districts, and required by USDA
Actual Reimbursement Full Reimbursement
Estimated Full Funding Shortfall Foundation Formula 4,814,000 4,814,000 ECSE 4,039,200 4,039,200 Transportation 412,000 1,481,300 (1,069,300) Other 270,000 270,000 Total 9,535,200 10,604,500 (1,069,300)
($107 million excluding bond construction)
2019-20 Operating Budget Salaries 60,581,842 Benefits 19,880,694 Services 5,004,722 Supplies 7,305,012 Student Activities 800,000 Capital 4,746,500 Total Operating Revenue 98,318,770
2019-20 Capital 5% Services/Supplies 13% Benefits 20% Salaries 62%
Salaries/Benefits $83.28
Utilities $2.37 Cafeteria Food $1.77 Capital - Technology $1.74 Capital - Other $1.74 Maintenance and repairs $1.56 Professional Services $1.55 School supply costs $1.40 Textbooks $1.18 Student Activities $0.87 Property and Liability Insurance $0.70 Transportation fuel and supplies $0.47 Other $1.36
Everything Else $16.72
($60.5 million)
Favorable/(Unfavorable) 2019-20 2018-19 $ Variance % Variance Support 16,032,290 15,189,400 (842,890) (5.55%) Certified 39,178,072 38,165,325 (1,012,747) (2.65%) Administrative 5,371,480 5,199,994 (171,486) (3.30%) 2018-19 Incentive 1,867,000 1,867,000 100.00% Total Salaries 60,581,842 60,421,719 (160,123) (0.27%) 2019-20 Administrative 9% Support 26% Certified 65% 2018-19 Administrative 9% Support 26% Certified 65%
School Grade Level Ratio
(based on forecast algorithm)
K 1 2 3 4 5 Bridgeway 19.0 19.0 20.7 22.3 24.6 20.7 Drummond 21.0 21.2 21.0 21.6 21.8 22.5 Parkwood 19.0 19.3 16.8 22.9 22.6 20.0 Remington 19.5 19.5 20.5 21.5 22.0 24.0 Rose Acres 19.7 19.7 15.7 18.4 17.3 22.0 Willow Brook 21.3 21.5 20.5 20.6 20.5 22.4
PSD Standard 20-22 20-22 20-22 20-25 20-25 20-25
Below/Lower End of Standard Meet Standard Exceeds Standard
High School Student/Classroom Teacher Ratios 2012 2013 2014 2015 2016 2017 2018 Parkway Central High 16 17 18 17 17 16 16 North High 17 17 17 17 16 16 16 South High 17 17 17 18 17 18 18 West High 17 18 17 16 18 18 18 Rockwood Eureka High 19 18 21 17 19 21 21 Lafayette High 23 23 22 18 20 22 22 Marquette High 23 24 23 19 20 23 23 Rockwood Summit High 22 22 22 18 19 21 21 Pattonville Pattonville High 20 21 20 20 19 19 19
Middle School Student/Classroom Teacher Ratios 2012 2013 2014 2015 2016 2017 2018 Parkway Central Middle 14 13 14 15 14 13 13 Northeast Middle 13 14 14 14 13 14 14 South Middle 13 14 14 13 13 13 13 Southwest Middle 14 14 14 16 16 16 16 West Middle 13 14 14 15 15 15 15 Rockwood Crestview Middle 17 17 16 16 17 17 17 Lasalle Springs Middle 18 17 17 17 16 16 16 Rockwood South Middle 18 17 17 17 18 17 17 Rockwood Valley Middle 16 15 15 15 15 15 15 Selvidge Middle 16 15 15 14 15 14 14 Wildwood Middle 17 16 16 15 15 14 14 Pattonville Holman Middle 14 15 14 14 13 14 14 Heights Middle 13 13 13 13 14 14 14
District Average Salary+Benefits Students per Teacher Budget $ to match PSD Pattonville R-III $78,118 13.65 $ - Kirkwood R-VII $78,105 16.41 $5,144,765 Webster Groves $77,560 14.59 $1,492,030 Parkway $76,593 14.68 $6,080,437 Francis Howell $74,606 15.81 $11,392,305 Ritenour $70,824 16.52 $4,986,416 Rockwood $69,661 15.21 $10,072,998 Hazelwood $68,401 15.14 $7,617,179 Lindbergh $66,343 16.59 $4,948,507
$65,172 11.46 ($3,817,865)
2018-19 2019-20 Change Business Office 5 5 Custodian 76 76 Food Services 27 27 Maintenance 21 21 Nurse 12 13 1 Office Staff 61 61 Paraprofessional 67 67 Printing 4 4 Social Worker 3 3 Student Supervision 8 8 Technology* 25 27 2 Transportation 37 37 Support Staff 346 349 3
*Decreased 1 Hardware Technician and transitioned 7 Library Technology Aides from 10 month to 12 month.
Percent Increase 0% 50% 100% 150% 200% 250% 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
National Insurance Premiums Pattonville Insurance Premiums Overall Inflation
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
$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.
Clinic Utilization Summary - 11/26/2018 - 5/24/2019
Company: Pattonville School District Division: Pattonville School District Facility: CareATC New Ballas; CareATC St. Peters; CareATC Keaton; CareATC McKelvey Park Gender: Not Specified Providers: Not Specified
Visits by Relationship
% of % of Visits Visits Total Total Visits Visits Unique Unique Individuals Individuals Employee 94% 988 406 Spouse 1% 11 5 Dependent 4% 47 27
438 438
1,046 1,046
0.9 0.9
2 2
1,057 1,057
1,330 1,330
Visits By Site
86 86 55 55 22 22 883 883 CareATC New Ballas CareATC St. P eters CareATC Keaton CareATC M cKelvey P ark 250 500 750 1000
Total Diagnosis
Top Diagnosis Categories
660 660 352 352 289 289 260 260 107 107 Health Status Factors Diseases of the Respiratory System Sym ptom s/Ill-defined conditions E ndocrine & Im m unity Disorders Diseases of the Circulatory System 200 400 600 800
Top Referrals By Specialty
7 6 5 5 3 3 2 2 Radiology Gastroenterology P hysical Therapy Sleep M edicine E ndocrinology 2.5 5 7.5
Patients
Unique Individuals by Site
42 42 34 34 14 14 377 377 CareATC New Ballas CareATC St. P eters CareATC Keaton CareATC M cKelvey P ark 100 200 300 400
Net Promoter Score
270 responses. The net promoter score is 88.
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 10,000 Curriculum Database 12,000 Early Childhood 5,000 New Courses 50,000 New Adoptions K-12 Math 840,000 Reading K-5 40,000 Online textbooks 120,000 Music Math Total Textbook Budget 1,226,000
$250,000 $500,000 $1,000,000 $750,000 16-17 17-18 14-15 15-16 18-19 19-20
Capital Spending-$4,746,500 Increased 23.92% or $916,185 from 2018-19
Allowance for 4 new busses
Model Year Number of Busses 2004 2 2007 11 2008 9 2009 4 2010 2 2013 6 2015 2 2016 6 2017 6 2018 4 2019 4 2020 4 Total 60
Average bus age will be 6.5 years
Principal and Interest on Certificates of Participation (Energy) 1,514,426 Lease payments for student technology 888,754 Replace 4 school buses 336,000 Replacement of 8 maintenance vehicles 247,125 Interactive White Board (Smart Board) replacements 205,000 District music instrument replacement 100,000 Virtual server replacements 100,000 High school teacher iPads 75,000 Fire panel replacements 57,500 Administrative laptop replacements 51,200 Uninterrupted Power Source (UPS) replacements 50,000 Synovia system renewal 44,800 Storm drain repairs at Willow Brook 38,000 Document punch in printing 33,000 Other (less than $25,000) 1,005,695 4,746,500
$1,000,000 $2,000,000 $3,000,000 13-14 14-15 15-16 16-17 17-18 18-19 $4,000,000 19-20
2019-20 2020-21 2021-22 2022-23 Budget Projection Projection Projection Local Revenue 85,292,080 86,950,600 90,274,800 91,628,900 Other Revenue 13,429,442 13,592,100 13,756,700 13,923,400 Total Revenue 98,721,522 100,542,700 104,031,500 105,552,300 Salaries/Benefits 80,462,536 82,677,600 85,813,100 88,493,900 Other Expense 17,856,234 17,826,800 17,865,600 17,907,500 Total Expense 98,318,770 100,504,400 103,678,700 106,401,400 Net 402,752 38,300 352,800 (849,100) Beginning Fund Balance 34,854,016 35,256,768 35,295,068 35,647,868 Ending Fund Balance 35,256,768 35,295,068 35,647,868 34,798,768 Beginning % of Exp. 35.45% 35.08% 34.04% 33.50%
2,000,000 6,000,000 10,000,000 14,000,000 18,000,000 22,000,000 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 2028-29 Debt Payments Fund Balance
2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Issuance Total Dec-2010 (Original) 1,265,450 1,265,450 Jan-2012 (Refunding 2000) 180,250 180,250 July-2012 (Original) 3,308,262.5 3,931,262.5 3,948,200 3,938,200 3,948,200 3,957,200 23,031,325 July-2013 (Refunding 2006/2007) 2,090,000 1,733,000 1,794,000 5,617,000 Aug-2017 (Refunding 2010) 794,200 794,200 794,200 794,200 794,200 794,200 4,459,200 4,457,600 4,470,200 4,446,200 4,466,800 27,065,200 June-2018* (Original) 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 1,041,500 3,541,500 14,998,000 Yearly Total 8,679,662.5 7,499,962.5 7,577,900 5,773,900 5,783,900 5,792,900 5,500,700 5,499,100 5,511,700 5,487,700 5,508,300 3,541,500 72,157,225
Principal and Interest
*June 2018 issuance matures in 2038
Required Beg Balance(26%) Actual Beginnning Balance
Short-term borrowing in 2014-15
Prop P projection from 2012