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 staffing plan reflected in long-range Staffing Needs / Enrollment Growth planning Favorable Variances - 16-17: $400,000; Healthcare Spending - No trend 17-18 Claims even YTD with 16-17 available for Self-Insured Plan; low Budgeted flat 18-19 participation in High Deductible Plan Staff education, increased enrollment in High Deductible Plan from 40 to 204. 2 bond issues - interest rates 2.71% and 3.06% Facility & Borrowing decision making GESA/Hybrid Construction methodology - MS/Forge/Turf • $18 million MS project Starting point of $27 million MS only, • $6 million documented savings affordability concerns/other project • condensed timeline - reduced by 1 year needs • construction underway - MS/Forge Grant applications for Forge site work

KEY FINANCIAL OBJECTIVES ACHIEVED CHALLENGES - 2017 CURRENT STATUS Direction needed - Technology spending MS 1:1 Initiative implemented Leasing program implemented Sustainable technology budget without one time infusions HS 1:1 Initiative proposed Long-range projections Updated long-range projections • 18-19 tax increase 3.93% • 18-19 proposed tax increase 2.0% • 21-22 shortfall $1 million • 21-22 shortfall $750,000 • 21-22 Fund Balance $2.6 million • 21-22 Fund Balance $3.4 million PSERS Retirement projected 32.57% to Actual 18-19 33.43% 34.18% in 18-19 19-20 projected 34.79% Special Education Expenditures increased Increased by $418,000 in 18-19 $581,000 in 17-18 Maintained low expenditures per pupil, healthy Fund Balance and strong bond rating.

2018-19 REVENUES 2% Real Estate Taxes 27% Earned Income Taxes Other Local Revenues State Revenues Federal Revenues 60% 4% 7%

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 $29,132,900 Valley Brethren Home) 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 $3,200,000 $3,400,000 $200,000 6.3% Income Taxes Interest $62,000 $286,000 $224,000 361.3% Earnings Donations $70,000 $130,000 $60,000 85.7% Basic Instructional $6,469,696 $6,605,508 $135,812 2.1% Subsidy

BASIC EDUCATION SUBSIDY PER PUPIL

SPECIAL EDUCATION EXPENSES VS. STATE SUBSIDY

EXPENDITURE BUDGET 1% 13% 1% Salaries 3% Benefits Prof/Tech Services 42% 8% Property Services Other Purchased Services 2% Supplies Equipment 4% Debt Service Other 26%

SUMMARY BY OBJECT PROPOSED $ +/1 % +/1 17/18 BUDGET 18/19 BUDGET 100 Salaries 20,800,654 21,935,138 1,134,483 5.45% 3,768,440 3,848,738 2.13% 466,494 211 Medical Insurance 243,734 246,177 80,298 1.00% 212 Dental Insurance 21,386 21,980 2,443 2.77% 213 Life Insurance 1,251,980 1,318,679 593 5.33% 220 Social Security 296,295 310,371 66,700 4.75% 225 Medicare 6,675,193 7,224,480 14,076 8.23% 230 Retirement 338,948 364,533 549,288 7.55% 240 Tuition Reimbursement 17,000 17,000 25,585 0.00% 250 Unemployment Compensation 72,396 76,077 0 5.08% 260 Workers Compensation 12,571 27,979 3,681 122.58% 290 Other Benefits 13,456,014 TOTAL BENEFITS 12,697,942 758,072 5.97% 2,565,511 2,150,258 -415,253 -16.19% 300 Purchased Professional/Tech Services 833,109 1,289,818 456,709 54.82% 400 Purchased Property Services 3,531,865 4,094,409 562,544 15.93% 500 Other Purchased Services 1,823,115 1,828,968 5,853 0.32% 600 Supplies 532,928 151,390 -381,538 -71.59% 700 Property 276,728 277,774 1,046 0.38% 800 Other Objects 6,783,371 7,011,899 228,528 3.37% 900 Other Uses of Funds 52,195,668 GRAND TOTAL - OBJECTS 49,845,223 2,350,444 4.72%

STUDENT ENROLLMENT - ELEMENTARY DIVISION (K - 5TH): 1,581 (2014 - 1,540) Certified Staff Support Staff Classroom Teachers 63 0 Clerical Staff Special Ed. Teachers 13 Aides 52* Art Teachers 2 *Includes all 4 secretaries and nurse aides. Music Teachers 5 PE/Health Teachers 3 Enrollment: - Kindergarten - 256 Librarians 2 - Lingle (1st - 5th) - 362 - Forge - 352 Technology Teachers 2 - Northside - 243 - Pine - 368 Reading Specialists 8 School Certified Nurses 1 Guidance Counselors 4 Average Class Size: 25 Overall Student/Teacher Ratio: 15:1 Administrators 5 Teacher/Administration Ratio: 21:1

STUDENT ENROLLMENT - MIDDLE SCHOOL (6TH - 8TH): 898 (2014 - 834) Certified Staff Support Staff Core Teachers Clerical Staff 1 35 (ELA, Math, Soc. St., Science) Aides 13 Special Education Teachers 10 Fine Arts Teachers 3.5 PE/Health Teachers 3 1 Librarian 1 Technology Teachers 2 Practical Arts Teachers World Language Teachers 1 School Certified Nurses 1 Student/Teacher Ratio: 15:1 Guidance Counselors 3 Teacher/Administration Ratio: 30:1 2 Administrators

STUDENT ENROLLMENT - HIGH SCHOOL (9TH - 12TH): 1,121 (2014 - 987) Certified Staff Support Staff Core Teachers Clerical Staff 2 37 (ELA, Math, Soc. St., Science) Aides 12 Special Education Teachers 9 Fine Arts Teachers 3.5 PE/Health Teachers 6 1 Librarian 3 Technology/Business Teachers 5 Practical Arts Teachers World Language Teachers 4 School Certified Nurses 1 Student/Teacher Ratio: 15:1 Guidance Counselors 4 Teacher/Administration Ratio: 25:1 3 Administrators

DISTRICT SHARED STAFF Special Services 2.8 Psychologists Others 1 Social Worker 1 Itinerant Autistic Support 8.5 Clerical 1 Special Education Consultant 7 Technology Staff 1 Gifted Supervisors 4 (Buildings & Grounds, 1 ESL Human Resources, 3 Speech & Language 5 Administration 1 Alternative Education 0.5 Cougar Academy

STAFFING 2018-19 PROPOSED STAFF ADDITIONS Professional • 3 MS Teachers • 1 .5 HS Social Studies Teacher • 1 Elementary Autistic Support Teacher 2017-18 STAFF ADDITIONS • 1 Special Education Supervisor Professional Support • Lingle Ave. Assistant Principal • 3 Autistic Support Aides • 1 HS Social Studies Teacher • 1 Grounds Person • 2 7th Grade MS Teachers • .5 MS Custodian • .5 Art to FT • 1 Kindergarten Aide • 1 HS Special Ed. • Human Resources Restructuring • 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 Estimated PSERS FY Net District Cost Net Change Rate 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 $3,317,888 $393,017 2017-18 32.57 $3,579,058 $261,170 2018-19 33.43 $3,884,580 $305,522 2019-20 34.79 $4,064,272 $179,692 2020-21 35.26 $4,245,550 $181,278 2021-22 35.68

ATHLETICS Student Boys Girls Athletes High School 252 236 Middle School 120 115 11 Girls Sports, 11 Boys Sports 80 Coaching Positions 1.7% of Total Budget Total Expenses $974,369 Less Gate Receipts/Activity Fees $108,500 Net Expenses $865,869

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 $1,474,899 Total Transportation Expense Less State Subsidy $725,000 Net Transportation Expense $749,899 1.4% of Budget