PALMYRA SCHOOL DISTRICT - BY THE NUMBERS May 3, 2018 KEY FINANCIAL - - PowerPoint PPT Presentation
PALMYRA SCHOOL DISTRICT - BY THE NUMBERS May 3, 2018 KEY FINANCIAL - - PowerPoint PPT Presentation
PALMYRA SCHOOL DISTRICT - BY THE NUMBERS May 3, 2018 KEY FINANCIAL OBJECTIVES ACHIEVED CURRENT STATUS CHALLENGES - 2017 Early Bird Teacher Contract through 8/31/21 Uncertainty - Labor Agreements (positive Labor Relations/stability) 3-year
KEY FINANCIAL OBJECTIVES ACHIEVED
CHALLENGES - 2017
Uncertainty - Labor Agreements Staffing Needs / Enrollment Growth Healthcare Spending - No trend available for Self-Insured Plan; low participation in High Deductible Plan Facility & Borrowing decision making
- MS/Forge/Turf
Starting point of $27 million MS only, affordability concerns/other project needs
CURRENT STATUS
Early Bird Teacher Contract through 8/31/21 (positive Labor Relations/stability) 3-year staffing plan reflected in long-range planning Favorable Variances - 16-17: $400,000; 17-18 Claims even YTD with 16-17 Budgeted flat 18-19 Staff education, increased enrollment in High Deductible Plan from 40 to 204. 2 bond issues - interest rates 2.71% and 3.06% GESA/Hybrid Construction methodology
- $18 million MS project
- $6 million documented savings
- condensed timeline - reduced by 1 year
- construction underway - MS/Forge
Grant applications for Forge site work
KEY FINANCIAL OBJECTIVES ACHIEVED
CHALLENGES - 2017
Direction needed - Technology spending Long-range projections
- 18-19 tax increase 3.93%
- 21-22 shortfall $1 million
- 21-22 Fund Balance $2.6 million
PSERS Retirement projected 32.57% to 34.18% in 18-19 Special Education Expenditures increased $581,000 in 17-18
CURRENT STATUS
MS 1:1 Initiative implemented Leasing program implemented Sustainable technology budget without one time infusions HS 1:1 Initiative proposed Updated long-range projections
- 18-19 proposed tax increase 2.0%
- 21-22 shortfall $750,000
- 21-22 Fund Balance $3.4 million
Actual 18-19 33.43% 19-20 projected 34.79% Increased by $418,000 in 18-19
Maintained low expenditures per pupil, healthy Fund Balance and strong bond rating.
2018-19 REVENUES
2% 27% 4% 7% 60%
Real Estate Taxes Earned Income Taxes Other Local Revenues State Revenues Federal Revenues
REAL ESTATE TAXES
*Natural Growth in Real Estate: $349,079 2% Proposed Tax Increase (Index = 3%) $600,926 Total: $950,005 * Trend is 1%
Note: District can add annual revenues of $103,600 due to successful settlement of reverse appeal for Traditions of Hershey
10 LARGEST TAXPAYERS IN SCHOOL DISTRICT
Company Assessed Value Hillwood Palmyra LP $41,669,900 Londonderry Village (Lebanon
Valley Brethren Home)
$29,132,900 Hershey Company $27,920,800 Springbrook Farms, Inc. $20,744,500 GAHC3 LLC (Traditions) $14,000,000 North Londonderry LHC LP $10,415,300 North Londonderry Investment LP $9,500,000 Walmart Real Est. $8,881,800 Cedar Campbelltown LLC $7,700,000 Cedar Palmyra, LLC $7,700,000 Total (9.3% of Total Assessed Value) $177,665,200
ACT 1 EXCEPTIONS HISTORY
2018-19 Resolution — Not to Exceed Index
2018-19 REVENUE TRENDS
2017-18 2018-19 Increase % Earned Income Taxes $3,200,000 $3,400,000 $200,000 6.3% Interest Earnings $62,000 $286,000 $224,000 361.3% Donations $70,000 $130,000 $60,000 85.7% Basic Instructional Subsidy $6,469,696 $6,605,508 $135,812 2.1%
BASIC EDUCATION SUBSIDY PER PUPIL
SPECIAL EDUCATION EXPENSES
- VS. STATE SUBSIDY
EXPENDITURE BUDGET
1% 13% 1% 3% 8% 2% 4% 26% 42%
Salaries Benefits Prof/Tech Services Property Services Other Purchased Services Supplies Equipment Debt Service Other
100 Salaries 20,800,654 21,935,138 1,134,483 5.45% 211 Medical Insurance 3,768,440 3,848,738 466,494 2.13% 212 Dental Insurance 243,734 246,177 80,298 1.00% 213 Life Insurance 21,386 21,980 2,443 2.77% 220 Social Security 1,251,980 1,318,679 593 5.33% 225 Medicare 296,295 310,371 66,700 4.75% 230 Retirement 6,675,193 7,224,480 14,076 8.23% 240 Tuition Reimbursement 338,948 364,533 549,288 7.55% 250 Unemployment Compensation 17,000 17,000 25,585 0.00% 260 Workers Compensation 72,396 76,077 5.08% 290 Other Benefits 12,571 27,979 3,681 122.58% TOTAL BENEFITS 12,697,942 13,456,014 758,072 5.97% 300 Purchased Professional/Tech Services 2,565,511 2,150,258
- 415,253
- 16.19%
400 Purchased Property Services 833,109 1,289,818 456,709 54.82% 500 Other Purchased Services 3,531,865 4,094,409 562,544 15.93% 600 Supplies 1,823,115 1,828,968 5,853 0.32% 700 Property 532,928 151,390
- 381,538
- 71.59%
800 Other Objects 276,728 277,774 1,046 0.38% 900 Other Uses of Funds 6,783,371 7,011,899 228,528 3.37% GRAND TOTAL - OBJECTS 49,845,223 52,195,668 2,350,444 4.72% 17/18 BUDGET PROPOSED 18/19 BUDGET $ +/1 % +/1
SUMMARY BY OBJECT
STUDENT ENROLLMENT - ELEMENTARY DIVISION (K - 5TH): 1,581
Certified Staff
Classroom Teachers 63 Special Ed. Teachers 13 Art Teachers 2 Music Teachers 5 PE/Health Teachers 3 Librarians 2 Technology Teachers 2 Reading Specialists 8
School Certified Nurses
1 Guidance Counselors 4 Administrators 5
Enrollment:
- Kindergarten - 256
- Lingle (1st - 5th) - 362
- Forge - 352
- Northside - 243
- Pine - 368
*Includes all 4 secretaries and nurse aides. Average Class Size: 25 Overall Student/Teacher Ratio: 15:1 Teacher/Administration Ratio: 21:1
Support Staff
Clerical Staff Aides 52*
(2014 - 1,540)
STUDENT ENROLLMENT - MIDDLE SCHOOL (6TH - 8TH): 898
Certified Staff
Core Teachers (ELA, Math, Soc. St., Science)
35
Special Education Teachers
10
Fine Arts Teachers
3.5
PE/Health Teachers
3
Librarian
1
Technology Teachers
1
Practical Arts Teachers
2
World Language Teachers
1
School Certified Nurses
1
Guidance Counselors
3
Administrators
2
Support Staff Clerical Staff 1 Aides 13
Student/Teacher Ratio: 15:1 Teacher/Administration Ratio: 30:1
(2014 - 834)
STUDENT ENROLLMENT - HIGH SCHOOL (9TH - 12TH): 1,121
Certified Staff
Core Teachers (ELA, Math, Soc. St., Science)
37
Special Education Teachers
9
Fine Arts Teachers
3.5
PE/Health Teachers
6
Librarian
1
Technology/Business Teachers
3
Practical Arts Teachers
5
World Language Teachers
4
School Certified Nurses
1
Guidance Counselors
4
Administrators
3
Support Staff Clerical Staff 2 Aides 12
Student/Teacher Ratio: 15:1 Teacher/Administration Ratio: 25:1
(2014 - 987)
DISTRICT SHARED STAFF
Special Services
Psychologists
2.8
Social Worker
1
Itinerant Autistic Support
1
Special Education Consultant
1
Gifted
1
ESL
1
Speech & Language
3
Alternative Education
1
Cougar Academy
0.5
Others
Clerical
8.5
Technology Staff
7
Supervisors (Buildings & Grounds, Human Resources,
4
Administration
5
STAFFING
2018-19 PROPOSED STAFF ADDITIONS
Professional
- 3 MS Teachers
- 1 .5 HS Social Studies Teacher
- 1 Elementary Autistic Support Teacher
- 1 Special Education Supervisor
Support
- 3 Autistic Support Aides
- 1 Grounds Person
- .5 MS Custodian
- 1 Kindergarten Aide
- Human Resources Restructuring
2017-18 STAFF ADDITIONS
Professional
- Lingle Ave. Assistant Principal
- 1 HS Social Studies Teacher
- 2 7th Grade MS Teachers
- .5 Art to FT
- 1 HS Special Ed.
- 1 MS Special Ed.
COLLECTIVE BARGAINING CONTRACT SETTLEMENTS
Teachers - three-year contract through August 31, 2021. Average salary increase inclusive of step movement: 2018-19 - 3% 2019-20 - 3% 2020-21 - 3.25% Support Staff - four-year contract through June 30, 2019. 3.0 % across-the-board increases in remaining year.
HEALTHCARE TREND
Lebanon County Healthcare Consortium self-funding arrangement effective July 1, 2016 Reserves at recommended minimum amount 2016-17 Favorable Variance $400,000 2017-18 claims year-to-date flat 2018-19 budgeting no increase in “pseudo rates” (increased for new staff) Successful Education Campaign - increased participation in High Deductible Plan
- year 1- 40
- year 2 - 96
- year 3 - 204
Smart Shopper implemented November 2017 - incentive payments picking up
PSERS PROJECTIONS
FY Estimated PSERS Rate Net District Cost Net Change
2010-11 5.64 $495,408 2011-12 8.65 $763,590 $268,182 2012-13 12.36 $1,118,827 $355,238 2013-14 16.93 $1,550,307 $431,480 2014-15 21.40 $2,021,471 $471,164 2015-16 25.84 $2,453,291 $431,820 2016-17 30.03 $2,924,872 $471,581 2017-18 32.57 $3,317,888 $393,017 2018-19 33.43 $3,579,058 $261,170 2019-20 34.79 $3,884,580 $305,522 2020-21 35.26 $4,064,272 $179,692 2021-22 35.68 $4,245,550 $181,278
ATHLETICS
Student Athletes Boys Girls High School 252 236 Middle School 120 115
11 Girls Sports, 11 Boys Sports 80 Coaching Positions
Total Expenses $974,369 Less Gate Receipts/Activity Fees $108,500 Net Expenses $865,869
1.7% of Total Budget
EXTRA-CURRICULAR ACTIVITIES
Total Expenses $80,003 .15% of Budget 36 Stipends (Club Advisors, Class Advisors, Marching Band, Drama/Choral Directors, etc.) Funds: National Honor Society Banquet Drama Productions Transportation for chorus, band, and orchestra functions
TRANSPORTATION
40 Square Miles in District 578,000 - Number of Miles Transported Annually 17 Buses & 23 Vans 2 Contractors (Bucks & Boyo-Special Needs Transportation) 2,393 Students Transported (171 Non-Public Students, 89 Special Needs Students) 1,207 Walkers Total Transportation Expense $1,474,899 Less State Subsidy $725,000 Net Transportation Expense $749,899 1.4% of Budget
BUILDINGS & GROUNDS
Staffing: 6 Maintenance
- 19,500 preventive maintenance work orders per year
- 16 athletic fields maintained
27 Custodians
- 6 buildings, 27,500 square feet cleaned per custodian
(average ranch home = 1300 square feet) Maintenance Budget Comprised of: $2,059,011 Salaries & Benefits $849,610 Utilities/Trash/Insurances $733,817 Contracts/Supplies/Other Total $3,642,438 7% of Budget
TUITION & CONTRACTS FOR OUTSIDE PLACEMENTS
Special Education (IU13, Yellow Breeches, Vista, OT/PT)............. Cyber Charter School Tuition.............................................................$ 876,894 Lebanon County Career & Technical Center...................................$ 880,920 Other (Court Placed, Homebound, Adjudicated)...........................$ 130,804 $1,971,965 Total = $3,860,583
(83 Students) (63 Students)
7.4% of Budget
Year
Amount 2007-08 $283,193 2008-09 $405,840 2009-10 $480,705 2010-11 $597,424 2011-12 $759,602 2012-13 $702,712 2013-14 $843,875 2014-15 $773,575 2015-16 $806,700 2016-17 $811,876 2017-18 Estimated $844,649* 2018-19 Budget $876,894
CYBER CHARTER TUITION
*61 Regular Ed. / 22 Special Education Students
DEBT SERVICE
GESA Loan - offset by savings $141,630 General Obligation Bonds $5,908,039 QSCB (Quality School Construction Bonds) $981,360 Total Debt Service $7,031,029 State Subsidy $860,497 Federal Subsidy (QSCB) $675,000 Total Subsidy $1,535,497 Net Debt Service $5,495,532 10.5% of Expenditures
S & P AA- rating reflects the District’s “stable and affluent residential tax base; maintenance of consistently strong General Fund Balance; good financial management practices; and moderate debt profile, with a rapid rate of amortization”.
Funded Major Construction Projects:
- Pine Street 2004
- High School 2007
- Lingle 2011
- Middle School 2017
- Forge 2018
- Turf Project*
*$75,000 added to Revenue Budget for
fundraising proceeds.
DEBT SERVICE - BOND ISSUES 29.5 MILLION
Year Annual Budget Increase 2016-17 $60,000 2017-18 $215,820 2018-19 $237,600 2019-20 $237,600 2020-21 $237,600 2021-22 $237,600 2022-23 $39,600
TECHNOLOGY
Staffing:
- 1 Director
- 1 PIMS Administrator/Supervisor
- 1 Network Administrator/Assistant Supervisor
- 4 Staff
- 1 Supervisor of Instructional Technology
- 1 Technology Coach
Computer Support (including salaries and benefits): $1,531,282 Percentage of Expenditures: 2.9%
High School:
- 1:1 Student Macbook Air - 1,200
- Tech. Ed. Computer Labs - 3 of 30
- General Use iPad Carts - 2 of 30
Student & Staff Devices
Middle School:
- 1:1 Student iPads - 930
- Tech. Ed. & Business Ed. Computer Labs
- 2 of 30
- Science COW - 1 of 32
- General Use COWs - 3 of 30
- Apple TVs - 55
Elementary:
- Student iPads - 1,045
- General Use COWs - 8 of 30
Staff Devices:
- Laptop/Desktop Computers - 446
- iPads - 184
All classrooms have a projector All buildings have adequate wireless coverage and speed
CAFETERIA
$1.6 Million Annual Expenses Separate Fund - Self-supporting from sales and subsidies (National School Lunch Program) 33,000 Breakfasts Served Per Year 284,000 Lunches Served Per Year $1.10 - Breakfast Price $2.15 - Elementary Lunch Price $2.25 - Secondary Lunch Price 79,000 Free Meals Served 16,000 Reduced Price Meals Served 681 (19.9%) Students Eligible for Free Lunch 146 (4.3%) Students Eligible for Reduced Lunch
COST OF PASD EDUCATION
Cost of 12.5 Years of Education (at 16-17 Tuition Rates) Median Assessed Value of Home Real Estate Taxes Generated by Median Home Number of years of paying school taxes to fund one child’s education K-12
$105,697 $187,500 $2,775 38
AUDITED FUND BALANCES – JUNE 30, 2017
Fund Balances General Fund Capital Projects Funds Restricted for: Capital Projects
- 13,618,386
Committed for: Retirement 1,485,000 Assigned for: Dental Claims Self-Insurance Medical Claims Tax Appeals 19,747 800,000 252,390 Non-spendable 98,608 Unassigned 4,140,759 Total Fund Balances 6,796,504 13,618,386
UNASSIGNED FUND BALANCE
$4,140,759 8.89% of Expenditures One month of operating expenses = $3,882,394
WHAT VALUE DOES THE DISTRICT PROVIDE FOR THE COMMUNITY?
COST PER PUPIL VALUE
District Per 2016-2017 AFR Per 2015-2016 Per 2014-15 AFR Annville-Cleona $15,975.42 $14,858.81 $14,430.72 Cocalico $17,862.28 $17,704.07 $16,252.93 Columbia $17,456.06 $13,048.55 $14,650.32 Conestoga Valley $15,400.29 $15,022.84 $12,967.23 Cornwall-Lebanon $15,411.97 $15,328.76 $14,473.71 Donegal $16,677.24 $15,394.95 $15,313.23
- E. Lancaster Co.
$18,076.88 $15,951.96 $15,591.07
- E. Lebanon Co.
$16,508.08 $15,598.32 $14,897.47 Elizabethtown $15,091.91 $13,159.86 $13,737.63 Ephrata $15,255.04 $14,882.10 $14,670.10 Hempfield $17,125.73 $16,577.47 $16,017.31 Lampeter- $16,696.75 $15,949.50 $15,884.88 SD of Lancaster $18,698.59 $17,256.04 $17,625.96 Lebanon SD $14,945.49 $13,442.82 $12,679.00 Manheim Central $16,749.29 $16,373.61 $15,702.24 Manheim Township $16,010.01 $14,807.04 $14,177.71 Northern Lebanon $15,456.84 $14,720.94 $14,003.52 Palmyra 2nd lowest - $13,064.70 lowest - $12,743.46 lowest - $12,502.40 Penn Manor $15,199.67 $14,974.80 $13,650.75 Pequea Valley $23,803.07 $21,111.34 $19,964.22 Solanco $12,346.43 $14,815.33 $13,640.02 Warwick $16,092.18 $15,472.35 $14,975.74 IU Averages * $16,359.27 $15,417.95 $14,900.37
2017 PSSA PROFICIENCY LEVELS: LEBANON COUNTY
Keystone District Level Comparison Variable Analysis
District(s): Annville-Cleona SD, Antietam SD, Big Spring SD and 61 more Testing Area: Algebra I Source: Pennsylvania DOE Keystone Data District Annville-Cleona SD Antietam SD Big Spring SD Boyertown Area SD Brandywine Heights Area SD Camp Hill SD Carlisle Area SD Central Dauphin SD Cocalico SD Columbia Borough SD Conestoga Valley SD Conrad Weiser Area SD Cornwall-Lebanon SD Cumberland Valley SD Daniel Boone Area SD Derry Township SD Donegal SD East Pennsboro Area SD Eastern Lancaster County SD Eastern Lebanon County SD Elizabethtown Area SD Ephrata Area SD Exeter Township SD Fleetwood Area SD Governor Mifflin SD Greenwood SD Halifax Area SD Hamburg Area SD Harrisburg City SD Hempfield SD Kutztown Area SD Lampeter-Strasburg SD Lancaster SD Lebanon SD Lower Dauphin SD Manheim Central SD Manheim Township SD Mechanicsburg Area SD Middletown Area SD Millersburg Area SD Muhlenberg SD Newport SD Northern Lebanon SD Northern York County SD Oley Valley SD Palmyra Area SD Penn Manor SD Pequea Valley SD Reading SD Schuylkill Valley SD Shippensburg Area SD Solanco SD South Middleton SD Steelton-Highspire SD Susquehanna Township SD Susquenita SD Tulpehocken Area SD Twin Valley SD Upper Dauphin Area SD Warwick SD West Perry SD West Shore SD Wilson SD Wyomissing Area SDKeystone District Level Comparison Variable Analysis
District(s): Annville-Cleona SD, Antietam SD, Big Spring SD and 61 more Testing Area: Biology Source: Pennsylvania DOE Keystone Data District Annville-Cleona SD Antietam SD Big Spring SD Boyertown Area SD Brandywine Heights Area SD Camp Hill SD Carlisle Area SD Central Dauphin SD Cocalico SD Columbia Borough SD Conestoga Valley SD Conrad Weiser Area SD Cornwall-Lebanon SD Cumberland Valley SD Daniel Boone Area SD Derry Township SD Donegal SD East Pennsboro Area SD Eastern Lancaster County SD Eastern Lebanon County SD Elizabethtown Area SD Ephrata Area SD Exeter Township SD Fleetwood Area SD Governor Mifflin SD Greenwood SD Halifax Area SD Hamburg Area SD Harrisburg City SD Hempfield SD Kutztown Area SD Lampeter-Strasburg SD Lancaster SD Lebanon SD Lower Dauphin SD Manheim Central SD Manheim Township SD Mechanicsburg Area SD Middletown Area SD Millersburg Area SD Muhlenberg SD Newport SD Northern Lebanon SD Northern York County SD Oley Valley SD Palmyra Area SD Penn Manor SD Pequea Valley SD Reading SD Schuylkill Valley SD Shippensburg Area SD Solanco SD South Middleton SD Steelton-Highspire SD Susquehanna Township SD Susquenita SD Tulpehocken Area SD Twin Valley SD Upper Dauphin Area SD Warwick SD West Perry SD West Shore SD Wilson SD Wyomissing Area SDKeystone District Level Comparison Variable Analysis
District(s): Annville-Cleona SD, Antietam SD, Big Spring SD and 61 more Testing Area: Literature Source: Pennsylvania DOE Keystone Data District Annville-Cleona SD Antietam SD Big Spring SD Boyertown Area SD Brandywine Heights Area SD Camp Hill SD Carlisle Area SD Central Dauphin SD Cocalico SD Columbia Borough SD Conestoga Valley SD Conrad Weiser Area SD Cornwall-Lebanon SD Cumberland Valley SD Daniel Boone Area SD Derry Township SD Donegal SD East Pennsboro Area SD Eastern Lancaster County SD Eastern Lebanon County SD Elizabethtown Area SD Ephrata Area SD Exeter Township SD Fleetwood Area SD Governor Mifflin SD Greenwood SD Halifax Area SD Hamburg Area SD Harrisburg City SD Hempfield SD Kutztown Area SD Lampeter-Strasburg SD Lancaster SD Lebanon SD Lower Dauphin SD Manheim Central SD Manheim Township SD Mechanicsburg Area SD Middletown Area SD Millersburg Area SD Muhlenberg SD Newport SD Northern Lebanon SD Northern York County SD Oley Valley SD Palmyra Area SD Penn Manor SD Pequea Valley SD Reading SD Schuylkill Valley SD Shippensburg Area SD Solanco SD South Middleton SD Steelton-Highspire SD Susquehanna Township SD Susquenita SD Tulpehocken Area SD Twin Valley SD Upper Dauphin Area SD Warwick SD West Perry SD West Shore SD Wilson SD Wyomissing Area SDKEY DATES
MAY 10 JUNE 14 PROPOSED BUDGET ADOPTION FINAL BUDGET ADOPTION MAY 31 FINANCE COMMITTEE - FINAL DISCUSSION - BUDGET REVISIONS