STEELTON-HIGHSPIRE SCHOOL DISTRICT 2018-2019 Budget and Financial - - PowerPoint PPT Presentation
STEELTON-HIGHSPIRE SCHOOL DISTRICT 2018-2019 Budget and Financial Forecast Presentation April 18, 2018 Presented by: Michael Simonetti Business Manager Steelton-Highspire School District Nikki Moore District Accountant Steelton-Highspire
2018-2019 Budget and Financial Forecast Presentation April 18, 2018
Presented by: Michael Simonetti Business Manager Steelton-Highspire School District Nikki Moore District Accountant Steelton-Highspire School District
Financial Forecast
Expenditures
18-19 proj 19-20 proj. 20-21 proj. 21-22 proj. sa la rie s 7,803,309 7,959,375 8,118,562 8,280,934 he a lthca re 1,874,251 2,024,191 2,176,005 2,339,206 R e tire me nt 2,058,704 2,827,966 2,918,623 3,014,260 Soc.Se c./Misc. 626,565 639,096 651,878 664,916 prof.se rvice s 1,750,320 1,785,326 1,785,326 1,785,326 prope rty se r./utilitie s 397,360 405,307 413,413 421,682 T uition to Schools 2,904,155 2,962,238 3,021,483 3,081,913 T ra nsp./othe r pur.se r. 867,723 885,077 902,779 920,834 supplie s/books/soft. 372,197 483,856 485,308 486,764 e ne rgy 208,021 212,181 216,425 220,754 e quipme nt 310,174 316,378 316,378 316,378 fe e s,re se rve ,mis. 33,994 33,994 33,994 33,994 de bt se rvice 2,636,684 2,652,169 2,670,355 2,677,150 T OT AL EXP. 21,843,456 23,187,155 23,710,530 24,244,108 e nrollme nt 1347 1,347 1349.00 1349.00
Revenue
18-19 proj 19-20 proj. 20-21 proj. 21-22 proj. R e a l Esta te /Int. 4,683,851 4,827,769 4,969,894 5,068,073 W a ge &Income 1,067,000 1,088,340 1,110,107 1,132,309 D e linque nt T a x 500,000 510,000 520,200 530,604 ID EA pa ss through 1,003,574 1,023,646 1,044,119 1,065,001 Othe r Loca l 363,741 374,653 385,893 397,470 Total Local 7,618,166 7,824,408 8,030,213 8,193,457 Prope rty T a x R e l. 395,040 395,040 395,040 395,041 PA Block Gra nt/R T L 352,679 352,679 352,679 352,679 Ba sic Instruction 8,390,762 8,726,392 9,075,448 9,438,466 Spe cia l Ed. 1,096,874 1,118,811 1,141,188 1,164,011 T ra nsport.Sub. 383,634 395,143 406,997 419,207 Socia l Se curity 410,000 450,398 459,405 468,594 R e tire me nt 1,871,593 2,091,846 2,158,906 2,229,648 D e bt Subsidy 202,232 214,000 234,000 234,001 Othe r Sta te 78,810 81,174 83,610 86,954 T ota l Sta te 13,181,624 13,825,484 14,307,273 14,788,601 Fe d.Sub./Sch.Inte rve n 1,067,173 1,088,516 1,110,287 1,143,595 T OT AL R EV. 21,866,963 22,738,409 23,447,772 24,125,654
$723,980 $275,234 12,477 (105,978) R e v. ove r Exp. $23,507 ($448,746) (262,757) (118,455) va lue of mill 171,594 170,616 169,644 168,677 milla ge 26.977 27.977 28.98 29.73 mills 0.75 1 1 0.75 Ave r. T a x incre a se $42.56 $56.74 $56.74 $42.56
18-19 Budget Projection with Proposed Tax Increase
Expenditures
18-19 proj salaries 7,803,309 healthcare 1,874,251 Retirement 2,058,704 Soc.Sec./Misc. 626,565 prof.services 1,750,320 property ser./utilities 397,360 Tuition to Schools 2,904,155 Transp./other pur.ser. 867,723 supplies/books/soft. 372,197 energy 208,021 equipment 310,174 fees,reserve,mis. 33,994 debt service 2,636,684 TOTAL EXP. 21,843,456
Revenue
18-19 proj Real Estate/Int. 4,683,851 Wage&Income 1,067,000 Delinquent Tax 500,000 IDEA pass through 1,003,574 Other Local 363,741 Total Local 7,618,166 Property Tax Rel. 395,040 PA Block Grant/RTL 352,679 Basic Instruction 8,390,762 Special Ed. 1,096,874 Transport.Sub. 383,634 Social Security 410,000 Retirement 1,871,593 Debt Subsidy 202,232 Other State 78,810 Total State 13,181,624 Fed.Sub./Sch.Interven 1,067,173 Erate Funds TOTAL REV. 21,866,963
$723,980
$23,507 One time subsidy value of mill 171,594 millage 26.977 mills 0.75
$42.56
18-19 Budget Projection EXCLUDING Proposed Tax Increase
Expenditures
18-19 proj salaries 7,803,309 healthcare 1,874,251 Retirement 2,058,704 Soc.Sec./Misc. 626,565 prof.services 1,750,320 property ser./utilities 397,360 Tuition to Schools 2,904,155 Transp./other pur.ser. 867,723 supplies/books/soft. 372,197 energy 208,021 equipment 310,174 fees,reserve,mis. 33,994 debt service 2,636,684 TOTAL EXP. 21,843,456
Revenue
18-19 proj Real Estate/Int. 4,555,155 Wage&Income 1,067,000 Delinquent Tax 500,000 IDEA pass through 1,003,574 Other Local 363,741 Total Local 7,489,471 Property Tax Rel. 395,040 PA Block Grant/RTL 352,679 Basic Instruction 8,390,762 Special Ed. 1,096,874 Transport.Sub. 383,634 Social Security 410,000 Retirement 1,871,593 Debt Subsidy 202,232 Other State 78,810 Total State 13,181,624 Fed.Sub./Sch.Interven 1,067,173 Erate Funds TOTAL REV. 21,738,268
$595,285
($105,188) One time subsidy value of mill 171,594 millage 26.227 mills
$0.00
3-Year Lost Revenue Resulting from No Tax Increase
Expenditures
15-16 act 15-16 T AX variance 16-17 act 16-17 T AX variance 17-18 proj. 17-18 T AX variance 3 yr total salaries 6,751,137 6,751,137 7,230,293 7,230,293 7,336,350 7,336,350 healthcare 1,671,822 1,671,822 1,606,868 1,606,868 1,735,417 1,735,417 Retirement 1,696,553 1,696,553 1,990,589 1,990,589 2,041,150 2,041,150 Soc.Sec./Misc. 809,563 809,563 685,287 685,287 689,193 689,193 prof.services 1,112,607 1,112,607 1,762,598 1,762,598 1,716,000 1,716,000 property ser./utilities 706,676 706,676 480,264 480,264 518,000 518,000 T uition to Schools 3,060,139 3,060,139 2,819,568 2,819,568 2,819,568 2,819,568 T ransp./other pur.ser. 882,907 882,907 834,028 834,028 850,709 850,709 supplies/books/soft. 382,230 382,230 367,780 367,780 337,758 337,758 energy 294,462 294,462 226,856 226,856 231,393 231,393 equipment 275,056 275,056 326,499 326,499 326,499 326,499 fees,reserve,mis. 17,416 17,416 33,994 33,994 33,994 33,994 debt service 2,673,859 2,673,859 2,638,978 2,638,978 2,514,653 2,514,653 T OT AL EXP. 20,334,427 20,334,427 21,003,602 21,003,602 21,150,684 21,150,684
Revenue
15-16 act 15-16 T AX 16-17 act 16-17 T AX 17-18 proj. 17-18 T AX Real Estate/Int. 4,426,106 4,491,897 65,791 4,607,531 4,717,019 109,488 4,581,268 4,693,593 112,325 287,604 Wage&Income 921,585 921,585 1,067,739 1,067,739 1,078,416 1,078,416 Delinquent T ax 785,125 785,125 702,258 702,258 716,303 716,303 IDEA pass through 1,296,937 1,296,937 964,604 964,604 983,897 983,897 Other Local 144,786 144,786 110,999 110,999 193,219 193,219 T otal Local 7,574,539 7,640,330 65,791 7,453,132 7,562,620 109,488 7,553,104 7,665,429 112,325 287,604 Property T ax Rel. 592,517 592,517 484,255 484,255 395,040 395,040 PA Block Grant/RT L 352,720 352,720 352,679 352,679 352,679 352,679 Basic Instruction 7,793,308 7,793,308 8,000,743 8,000,743 8,208,102 8,208,102 Special Ed. 990,724 990,724 1,177,972 1,177,972 1,052,941 1,052,941 T ransport.Sub. 473,510 473,510 419,612 419,612 377,651 377,651 Social Security 340,426 340,426 402,743 402,743 415,142 415,142 Retirement 1,113,823 1,113,823 1,648,705 1,648,705 1,509,839 1,509,839 Debt Subsidy 638,000 638,000 Other State 138,769 138,769 93,657 93,657 96,466 96,466 T otal State 11,795,797 11,795,797 12,580,367 12,580,367 13,045,860 13,045,860 Fed.Sub./Sch.Interven 986,252 986,252 994,250 994,250 952,193 952,193 T OT AL REV. 20,356,588 20,422,379 65,791 21,027,749 21,137,237 109,488 23,151,157 23,263,482 112,325 287,604
($2,900,473) ($2,834,683) $65,791 ($1,300,000) ($1,124,721) $175,279 $700,473 $988,077 $287,604 $287,604
$22,161 $87,952 $65,791 $24,147 $133,635 $109,488 $2,000,473 $2,112,798 $112,325 $287,604 One time subsidy $1,170,000 $1,170,000 $900,000 $900,000 $1,600,000 $1,600,000 value of mill 174,562 175,038 173,567 174,040 172,578 173,048 millage 25.477 25.997 25.477 26.777 25.477 27.577 mills 0.52 0.78 0.8
$0.00 $29.51 $0.00 $44.26 $0.00 $45.40 Steelton-Highspire School District Financial Forecast- Actual Vs. Proposed T ax Increase
PSERS Percent by Year
1.09% 1.15% 3.77% 4.23% 4.69% 6.46% 7.13% 4.76% 4.78% 5.64% 8.65% 12.36% 16.93% 21.40% 25.84% 30.03% 32.57% 34.79% 35.26% 35.68% 36.32% 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 01/02 02/03 03/04 04/05 05/06 06/07 07/08 08/09 09/10 10/11 11/12 12/13 13/14 14/15 15/16 16/17 17/18 18/19 19/20 20/21 21/22 22/23
Percent Year
PSERS History/Projections Employer Contribution Rates
Salaries 100salaries $7,803,309 $7,803,309 Healthcare 210Healthcare $1,874,251 $1,874,251 Retirement 230PSERS Retirement $2,058,704 $2,058,704 Social Security/Misc 220Social Security $483,797 240Tuition Reimbursement $77,313 250Unemployment Comp $2,265 260Workers' Compensation $60,884 290Other Benefits $2,306 $626,565
322Prof Ed Serv IU $755,287 324Prof Ed Serv Employee Training & Dev $5,904 329Prof Ed Serv Other $513,378 330Other Prof Serv $19,054 350Security/Safety Services $154,399 390Other Purchased Prof and Technical Services $302,299 $1,750,320 Property Services/Utilities 410Cleaning Services $20,641 420Utility Services $44,199 430Repairs & Maintenance $270,054* 440Rentals $56,179 460Extermination Services $3,805 490Other Purchased Property Services $2,482 $397,360
Expense Detail
Tuition to Schools 561 Tuition to Other School District In State $814,275 562 Tuition to PA Charter Schools $1,392,129 564 Tuition to Career & Technology Centers $466,040 566 Tuition to Higher Education/Technical Inst $52,242 568 Tuition to PRRI Detention Centers $179,470 569 Tuition Other $0 $2,904,155 Transporation/Other Pur. Ser 510 Student Transportation Services $302 513 Transportation Contracted Carriers $284,042 516 Student Transportation Services IU $461,772 523 General Property and Liability Insurance $39,369 529 Other Insurance $10,323 530 Communications $60,015 549 Other Advertising/Public Relations $1,631 580 Travel $2,803 595 IU Payment by Withholding $7,159 599 Other Misc Purchased Services $306 $867,723 Supplies/Books/Software 610 General Supplies $327,954 630 Food $1,412 640 Books And Periodicals $8,822 650 Supplies & Fees - Technology Related $34,010 $372,197 Energy 620 Energy $208,021 $208,021 Equipment 751 Equipment - Original $282,911 761 Equipment - Replacement $27,263 $310,174 Fees/Reserves/Misc 810 Dues and Fees $33,994 $33,994 Debt Service 830 Interest $1,305,225 890 Miscellaneous Expenditures $1,451 910 Redemption of Principal $1,330,008 $2,636,684
*Includes Capital Projects: $45,000 Trailer Setup (Est.) $20,000 Rehab (Est.) $89,000 Curbing $65,000 Office Safety Entrance (Est.)
Revenue Percent by Category
Expense Percent by Category
35.7% 13.3% 12.1% 9.4% 8.6% 8.0% 4.2% 4.0% 2.9% 1.8%
0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% 35.0% 40.0% salaries Tuition to Schools debt service Retirement healthcare prof.services supplies/equipment/energy/fees Transp./other pur.ser. Soc.Sec./Misc. property ser./utilities
Expenses 2018-2019