Title With Picture Layout - Big Spring High School

Title With Picture Layout - Big Spring High School

BIG SPRING SCHOOL DISTRICT Preliminary Budget 2019-20 Board Finance Committee - Agenda Fund Update Debt Service Update Enrollment Commonwealth Funding PSERS Transportation Healthcare Special Ed Tuition Personnel Adjusted Index Preliminary Budget Capital Projects Fund FUNDS & DEBT SERVICE Fund 10 General Fund Balance As of 30 June 2018 Unassigned Nonspendable General Fund Balance Employee Health Insurance PSERS Healthcare Technology Special Education Student Info Sy/Financial Software Assigned Committe d 3,992,375 2,000,000 650,000 350,000 2,300,000 550,000 200,000 AFR Balance at June 30, 2018 $ 3,992,375 2018-19 Budget Allowable Unassigned @ 8%

$ $ 50,396,578 4,031,726 $ 2,000,000 $ 4,050,000 554,000 $ 554,000 Total 3,992,375 2,000,000 1,204,000 350,000 2,300,000 550,000 200,000 $ 10,596,375 Fund Balance As of 15 March 2019 Big Spring Capital Projects Fund Capital Projects Fund Balance at Mar 15, 2019 $ 7,194,536 205,557 $ (205,557) Available Capital Projects Reserve Balance $ 6,988,979 Capital Project: Pedestrian Safety Improvement

MS Roof Design Phase I, II, & III MS Roof Monitoring & Inspections HS Gym Floor Refinish HS Auditorium AV Repair Server Room UPS Replacement HS Network Replacement (Erate Cat 2) HS Roof Design/Mgmt/Inspections MR Roof Design & Management HS Gym Audio Replace HS Auditorium Speaker Replace MR Partial Roof Replacement NV/MR/MS/HS FF&E Design & Purchase NV/OF/HS/DAO NV & Assoc Technology Projects HS Collaboration Lab HS/MS Flexible Furniture Pilot NV Asbestos Abatement CO 3 MR Asbestos Abatement MS Asbestos Abatement Unused Funds: 11,200 2,646 1,921 5,000 139,279 10,600 550 19 14,315 15,260 933 3,834 $ Newville Bond Fund Newville Projects Fund GOB 2017 Bond Issue = $ 13,004,518 Project Budget Track & Turf Field ** 1,345,501 MS Roof Replacement 1,376,700 MS Gym Floor 80,600 HS Roof - White Knight 392,000 MS Exterior Courtyard Renovation 372,251 Stadium Site Improve/DAO Drainage 537,640 Emergency Generator

284,888 Newville Elem Renovation 7,787,097 Mount Rock Renovations GOB 2018 Middle School Renovations GOB 2018 High School Renovations GOB 2018 BSSD Phase 2 Renovations GOB 2018 Total Spend 12,176,677 Interest earned to 02/28/19 Current Balance Newville Projects Fund = $ Paid to Date (1,413,665) (1,376,700) (80,600) (392,000) (104,759) (1,900) 0 (7,560,957) (19,100) (112,267) (53,424) (227,588) (11,342,960) $209,839 1,871,397 Budget Balance (68,164) 0 0 0 267,492 535,740 284,888 226,140 $1,246,096 Mt Rock Bond Fund Mount Rock Projects Fund - 2018 GOB 2018 Bond Issue = $ 9,820,944 Project Budget

Mount Rock Renovations 1,304,920 (1,622,661.06) Middle School Renovations 2017 Bond 1,961,123 (1,199,466.22) Middle School Renovations 2018 Bond 394,266 High School Renovations 1,020,135 (525,325.78) Phase II Renovations (CRA Prof Svc) (56,395.89) incl Total $4,680,444 $ (3,403,849) Interest earned to 02/28/19 = $142,114 Current Balance Mount Rock Projects Fund - 2018 = $6,559,209 Bond Funds Remaining (2017 & 2018) = $ Budget Balance Paid to Date 8,430,606 $ (317,741) 761,657 394,266 494,809 (56,396) 1,276,595 Debt Service 2019/20 Debt Service Expense Bond Principal Annual Debt Service Interest RBC Gross Outstanding 2012 2015 2016 2016A

2017 2018 $ 885,000 1,285,000 1,215,000 5,000 5,000 5,000 $ 144,500 184,710 47,724 75,660 481,328 379,721 $ 1,029,500 1,469,710 1,262,724 80,660 486,328 384,721 $ 6,650,600 6,725,280 1,269,153 4,212,869 16,053,700 13,609,125 Totals $ 3,400,000 $ 1,313,643 $ 4,713,643 $

48,520,727 2019/20 Debt Service - PA State Reimbursement Bond Principal 2012 2015 2016 2017 $ Totals $ Interest 190,993 97,821 162,834 768 $ 452,416 $ Total Reimbursement 31,185 14,061 6,396 73,964 $ 125,606 $ 222,178 111,882 169,230 74,733 Net Debt 578,022

$ 4,135,620 ENROLLMENT Budget Drivers Trends 51.00 46.00 41.00 36.00 31.00 26.00 21.00 16.00 11.00 2001-02 2002-03 2003-04 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 Budget * $1M Oct Enr * 100 ProStaff * 10 ClasStaff * 10 Enrollment 2018 Enrollment By grade Staff FTE v Enrollment Low Income Enrollment COMMONWEALTH FUNDING Commonwealth & Federal Subsidy Major State Subsidies Basic Education Fund (BEF)

Special Education Funding ABG > RTL Transportation PLANCON Subsidy SocSec PSERS Total of Major Subsidy Federal Revenue Sources IDEA-B Title I Title II Title IV Fed Instruct Subsidy AFR 2011/12 AFR 2012/13 AFR 013/14 8,780,162 1,732,918 171,093 1,675,919 869,330 706,189 853,009 $14,791,293 8,924,141 1,724,253 171,093 1,564,253 806,000 711,900 1,569,907 $15,471,547 8,779,810 1,732,918 171,093 1,617,014 790,846 669,105 1,143,932 $14,904,718 AFR 14/15 AFR 2015/16 AFR 2016/17 1,240,004 1,106,571 2018/19

2019/20 8,941,596 9,087,149 9,488,526 9,337,340 9,466,568 10,078,394 1,771,736 1,827,743 1,883,516 1,908,984 1,904,859 1,973,552 320,597 401,851 401,854 401,851 401,851 1,597,496 1,673,676 1,456,682 1,470,194 1,573,833 1,550,000 870,736 718,646 776,400 767,379 504,000 578,022 675,961 688,215 723,862 741,159 758,210 780,000 1,991,079 2,430,097 2,855,079 3,132,579 3,295,511 3,545,000 $16,169,201 $16,827,377 $17,585,919 $17,759,486 $17,904,832 $18,504,968 AFR 2011/12 AFR 2012/13 AFR 2013/14 AFR 2014/15 AFR 2015/16 AFR 2016/17 656,516 647,413 582,420 556,181 552,661 565,494 423,189 461,874 400,760

444,232 423,460 496,724 130,297 130,717 123,391 124,618 135,184 122,087 1,210,002 2017/18 1,125,031 1,111,305 1,184,305 Prior Yr -> $145,346 $600,136 2017/18 549,500 496,724 107,437 10,633 1,164,294 2018/19 572,756 477,110 100,528 30,778 1,181,172 2019/20 572,756 477,110 100,528 30,778 1,181,172 PY 611,826 68,693 (23,833) 74,022 21,790 249,489

PSERS PSERS + Social Security (BSSD share) PSERS ($299,107) TRANSPORTATION 2017 Transportation (Forecast 5 only) Cost/ Mile Cost / Vehicle Cost/Studt Schl Trans Days SqMi District MV AR Market Value Miles % Ppl # of Veh Subsidy Density Total Cost Total Stu $2.32 $30,342.12 $1,300.77 180 49 Littlestown Area SD 0.5276 $957,635,175 613,501

46.9 52.9 39.84 $1,423,045 1094 $3.59 $41,927.77 $1,058.11 178 76 Carlisle Area SD 0.4825 $2,636,837,589 1,040,496 89.19 29.9 66.08 $3,739,344 3534 $2.62 $45,441.16 $909.80 179 194 Big Spring SD 0.4846 $1,408,727,067 926,246

53.5 60.4 13.24 $2,430,975 2672 $3.91 $59,067.82 $880.30 182 109 South Eastern SD 0.4723 $1,424,611,553 595,198 39.43 47.7 23.89 $2,329,284 2646 $2.36 $36,051.12 $839.03 178 74 Bermudian Springs SD 0.6265 $766,127,412

730,364 47.8 64.8 26.8 $1,723,365 2054 $2.20 $35,936.36 $828.28 177 206 Tuscarora SD 0.5114 $1,206,888,893 1,000,545 61.38 67.9 11.84 $2,205,721 2663 $2.06 $31,184.68 $819.37 176 83 Upper Adams SD 0.636

$632,903,179 676,831 44.69 70.1 20.22 $1,393,743 1701 $3.04 $50,442.82 $772.41 178 93 Waynesboro Area SD 0.5885 $1,766,494,904 885,762 53.41 46.2 47.81 $2,694,157 3488 $3.04 $40,633.74 $743.01 181 103 Cumberland Valley SD

0.2714 $6,252,228,393 2,268,964 169.58 36.3 85.28 $6,890,674 9274 $2.83 $39,826.08 $720.43 180 123 Shippensburg Area SD 0.5155 $1,698,955,394 803,336 57 44.7 27.52 $2,270,087 3151 $4.68 $62,617.38 $706.74 181 68

Southern York County SD 0.4373 $1,692,837,572 467,994 35 35.8 45.2 $2,191,608 3101 $2.55 $35,227.40 $644.52 179 250 Chambersburg Area SD 0.4821 $4,777,581,128 2,383,654 172.53 52.2 37.32 $6,077,809 9430 $4.31 $35,336.12 $632.92 180

4 Hanover Public SD 0.4767 $936,477,036 282,957 34.53 31.2 504.32 $1,220,274 1928 $3.77 $50,418.41 $626.74 180 73 Conewago Valley SD 0.5729 $1,649,243,639 671,191 50.18 50.9 52.47 $2,530,164 4037 $4.37 $44,161.51 $557.29

180 56 South Western SD 0.4437 $2,222,192,638 532,625 52.71 33.4 73.24 $2,327,802 4177 $2.83 $37,920.98 $530.88 180 72 Greencastle-Antrim SD 0.5248 $1,451,832,771 569,204 42.49 47.2 42.1 $1,611,220 3035 $3.04 $33,436.39

$499.05 179 16 Mechanicsburg Area SD 0.4259 $2,273,708,725 549,523 49.96 40.1 249.25 $1,670,325 3347 Transportation Subsidy 2018/19 Transportation Subsidy Analysis HEALTHCARE Through January 2019, total costs have decreased by Executive Summary $174,526 or -10.35%; total costs of $1,512,142 in 2018/2019 compared to $1,686,668 in 2017/2018 YTD paid claims are $1,355,467, which represents a decrease of $170,392 or -11.17%; driven by a significant decrease in Medical spend YTD PEPM is $720 vs. $819 in the prior period Medical claims: $526 YTD PEPM vs. $685 PEPM in the prior period Rx claims: $194 YTD PEPM vs. $135 PEPM in the prior period Prescription Drug Rebates received for the period have already exceeded the prior full plan year rebates of $58,703 by +$13,760 ($72,463 YTD) Overall enrollment YTD has been steady and is currently at 269, a +1.13% increase over the prior period which had 266 covered employees Total member enrollment for the period is 817, with an average | 31

2018/2019 YTD Financial Summary Big Spring School District Executive Summary July 1, 2018 through June 30, 2019 Total Paid Claims and Fixed Costs Paid Claims Total Paid Medical Rx Claims Month Covered Employees Deposits Administrative Cost Stop Loss Total Costs Surplus (Deficit) Jul-18 264 288,525 169,247 28,759 198,006 12,843 9,163 220,012 68,513 Aug-18 270 294,961

200,961 50,632 251,593 13,128 9,372 274,093 20,868 Sep-18 270 294,961 177,435 67,350 244,785 13,128 9,372 267,285 27,676 Oct-18 269 293,189 84,225 40,434 124,659 13,080 9,337 147,076 146,113

Nov-18 269 291,743 145,810 68,125 213,935 13,080 9,337 236,352 55,391 Dec-18 270 292,333 112,764 57,142 169,906 13,128 9,372 192,406 99,927 Jan-19 268 289,705 100,186 52,397 152,583 13,033

9,302 174,918 114,787 1,880 $2,045,417 $990,628 $364,839 $1,355,467 $91,420 $65,255 $1,512,142 $533,275 $65,255 $1,439,844 $605,573 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Prescription Drug Rebates Value Based Program ($72,463) $2,400 Less Stop Loss Reimbursements Current Plan Year $0 Less Stop Loss Reimbursements Previous Plan Year ($2,235) Total $1,283,169

$13,060 $91,420 | 32 Base Experience Period Paid Claims # of Budgeted Paid Claims Month EE's Amount Medical Drug Total Feb-18 264 $296,786 $169,127 $70,462 $239,589 Mar-18 262 $295,287 $267,801 $56,887 $324,688 Apr-18 262

$295,287 $260,190 $78,753 $338,943 May-18 263 $297,399 $172,998 $64,596 $237,594 Jun-18 265 $299,480 $260,747 $91,675 $352,422 Jul-18 264 $288,525 $169,247 $28,759 $198,006 Aug-18 270 $294,961 $200,961 $50,632

$251,593 Sep-18 270 $294,961 $177,435 $67,350 $244,785 Oct-18 269 $293,189 $84,225 $40,434 $124,659 Nov-18 269 $291,743 $145,810 $68,125 $213,935 Dec-18 270 $292,333 $112,764 $57,142 $169,906 Jan-19 268

$289,705 $100,186 $52,397 $152,583 Total 3,196 $3,529,656 $2,121,491 $727,212 $2,848,703 | 33 Renewal Projection Big Spring School District Health Insurance Cost Projections (Medical and Prescription Drug) Plan Year: July 1, 2019 through June 30, 2020 Experience Period: February 1, 2018 through January 31, 2019 Medical Prescription Drug Total $2,121,491 $727,212 $2,848,703 Claims Cost: Paid in the Experience Period Adjustments 1 Large Claims $0 Benefit Plan Changes $0 $0

$0 Mandated Benefit Changes $0 $0 $0 Health Care Reform Mandated Changes $0 $0 $0 $2,121,491 $727,212 $2,848,703 $244,382 $115,868 $360,250 $2,365,873 $843,080 $3,208,953 $2,383,662 $849,419 $3,233,081 $0 $0 $0 $127,032 -$104,456 $22,576

Adjusted Experience Period Claims Trend at 17 Months 2 Estimated Total Projected Claims Total Claims (adjusted for enrollment) 3 Reserve Adjustment 4 Administrative Costs Stop Loss Premium 5 6 $229,476 Health Care Reform Legislative Costs 7/18 - 6/19 Projected Costs 7/17 - 6/18 Budget Amount $0 $229,476 $0 $3,485,133 7 Overall Projected Percent Adjustment: $3,434,999 1.46% | 34 SPECIAL EDUCATION Special Ed Special Ed Budget Account 2013-14 AFR 2014-15 AFR 2015-16 AFR 2016-17 AFR

2017-18 AFR 2018-19 Bud 2019-20 Bud 1200 Special Programs - Elem/sec 100 Personnel Services - Salaries 2,687,533 200 Personal Services - Employee Benefit1,199,814 s 300 Purchased Professional And Technical493,707 Services 400 Purchased Property Services 2,766 500 Other Purchased Services 2,196,009 600 Supplies 60,302 700 Property 38,907 800 Other Objects 0 3,053,188 1,444,454 324,506 6,055 2,298,281 56,101 2,824 0 2,898,609 1,451,930 573,952 3,216 2,578,900 38,002 3,266 0 2,977,276 1,488,912 443,643 4,062 2,578,188 41,929 9,198 250 3,169,901 1,733,943

493,073 3,951 2,489,217 51,727 4,079 250 3,209,263 1,810,404 881,652 3,981 2,411,095 94,746 23,500 253 3,375,384 2,016,777 656,459 4,500 2,282,435 154,350 31,000 750 3,503,176 2,121,512 816,356 0 2,463,611 140,340 30,000 606 1200 Sub Total 7,185,409 7,547,875 7,543,458 7,946,141 8,434,894 8,521,655 9,075,601 2012-13 AFR 6,679,038

Special Ed Cost / Student Comparison TUITION Tuition 2012/13 561 562 322 563 564 566 568 568/9 Tuition Other PA LEAs PA Charter (+Cyber) CAOLA Tuition NonPublic Schls Tuition to CPAVTS Tuition to HigherEd Aprv Priv Schls Other Total 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20 $234,645 $145,638 $151,615 $244,975 $385,004 $292,717 $308,000 $1,420,969 $1,485,206 $1,563,636 $1,510,009 $1,457,450 $1,426,932 $1,975,500 $93,812 $120,235 $137,037 $125,118 $126,094 $150,000 $130,000 $1,620,396 $1,797,352 $1,864,731 $1,844,926 $1,787,842 $1,865,900 $1,750,629 $615,134 $606,038 $539,127 $550,447 $536,454 $589,580 $729,000 $0 $0 $3,135 $0 $0 $0 $68,971

$69,741 $182,176 $134,737 $76,705 $69,284 $70,000 $29,170 $39,969 $33,398 $18,553 $0 $20,000 $0 $4,083,098 $4,264,179 $4,474,855 $4,428,765 $4,369,549 $4,414,413 $4,963,129 $323,400 $1,600,000 $135,000 $1,953,431 $788,000 $0 $73,000 $0 $4,872,831 PERSONNEL Professional Staff District 2017 -> 2018 Avg. Enrol FTE Stu/FTE Avg. Oper Funds $ / Stu Big Spring SD 2,621 229.8 11.4 $41,279,177 $15,751.50

South Middleton SD 2,177 180.0 12.1 $31,409,112 $14,424.92 Northern York County SD 3,248 240.8 13.5 $41,294,029 $12,714.54 Carlisle Area SD 5,174 381.9 13.5 $70,714,820 $13,666.47 West Perry SD 2,564 183.1 14.0 $33,589,685 $13,099.28 Bermudian Springs SD 2,057 145.7

14.1 $24,748,343 $12,033.33 Tuscarora SD 2,499 166.5 15.0 $32,437,679 $12,979.48 Shippensburg Area SD 3,484 226.3 15.4 $42,595,197 $12,226.65 Greencastle-Antrim SD 3,058 183.5 16.7 $37,101,469 $12,134.50 Salary Schedule Comparison rn Northe rg ensbu Shipp Carlisle n

dleto S. Mid W Perry Personnel Professional Staff Classified Staff Gilliam Replacement: Drawbaugh/Frank Martin (Warehouse to Plumbing/Security) Putt replacement Admin Asst - PAO/Trans/Caf Admin MS Guidance Admin Asst PT > FT Bldg admin asst $ adjustments ADJUSTED INDEX Real Estate Tax Review Assessed Values - 2019 Proposed Tax Increase Mill Calculation Prior Yr Mills Adjusted Index for Budget Mill increase @ Adj index Adjusted Index as Mills 2016-17 2017/18 2018/19 2019/20 13.2885 3.10% 0.4119 13.7004 13.7004 3.20% 0.4384 14.1388 14.1388 3.00% 0.4242 14.5630 14.3238 2.90% 0.4154 14.7392

Preliminary Proposed Final Budget Mills 13.7004 14.0429 14.3238 14.7392 $1,723,378,300 3.10% $23,610,972 95.0% $22,430,422 $1,637,209 $2,387 Real Estate Tax Increase as $$ Taxes Tax on $100,000 property = $1,370 Increase from prior year per $100,000 = $41 1,728,353,200 2.50% $23,497,827 95.0% $20,375,511 1589624.316 1,752,507,100 2.00% $24,331,844 95.0% $23,115,252 $1,613,765 1,776,691,698 2.90% $25,410,456 95% $24,139,933 $1,637,804.82 Taxes $1,404 $34 Taxes $1,432 $28

Taxes $1,474 $42 March Assessed Value Proposed Increase as % Gross Tax Revenue Assumed Collection rate Est. Collected Tax $$ from Proposed Mills Est. Mill Value $333,106 increased assessment $691,576 Increase in mills $1,024,681 increase in RE tax PRELIMINARY BUDGET Revenue General Fund Revenue Analysis Preliminary Budget 20 @ 2.9% BUDGET 2019 REVENUE PROJECTIONS 2021 2022 2023 2020 2024 LOCAL Property Taxes $28,630,560 $30,007,097 $31,093,000 $32,220,090 $33,326,509 $34,405,673 Other Local Revenue $1,994,900 $2,167,757

$2,167,757 $2,167,757 $2,167,757 $2,167,757 TOTAL LOCAL REVENUE $30,625,460 $32,174,854 $33,260,757 $34,387,847 $35,494,266 $36,573,430 Basic Aid $9,521,068 $10,107,294 $10,208,078 $10,309,869 $10,412,679 $10,516,517 Other State Revenue $9,526,903 $9,372,775 $9,558,517 $9,746,013 $9,963,746 $10,115,864 TOTAL STATE REVENUE $19,047,971

$19,480,069 $19,766,594 $20,055,882 $20,376,425 $20,632,381 TOTAL FEDERAL REVENUE $503,500 $608,638 $608,638 $608,638 $608,638 $608,638 OTR FINANCING SOURCES $0 $0 $0 $0 $0 $0 TOTAL REVENUE $50,176,931 $52,263,561 $53,635,989 $55,052,367 $56,479,329 $57,814,449 STATE

Expenditures General Fund Expenditure Analysis Preliminary Budget 20 @ 2.9% BUDGET 2019 EXPENDITURE PROJECTIONS 2020 2021 2022 2023 2024 Salaries $19,787,997 $20,589,421 $21,229,721 $21,889,469 $22,561,324 $23,253,340 Benefits $12,000,353 $12,611,874 $13,012,584 $13,446,576 $14,002,359 $14,556,811 TOTAL SALARIES & BENEFITS $31,788,350 $33,201,295

$34,242,304 $35,336,045 $36,563,683 $37,810,151 Supplies $2,216,969 $2,259,445 $2,290,410 $2,321,579 $2,353,187 $2,385,241 Purchases $10,829,513 $11,186,581 $11,293,006 $11,531,921 $11,780,909 $12,040,592 Property $558,175 $589,848 $607,543 $625,770 $644,543 $653,454 Other Objects $1,608,571

$1,488,350 $1,488,350 $1,488,350 $1,488,350 $1,488,350 Other Financing Uses $3,395,000 $3,465,000 $3,465,000 $3,465,000 $3,465,000 $3,465,000 TOTAL ALL OTHER $18,608,228 $18,989,224 $19,144,310 $19,432,620 $19,731,990 $20,032,637 TOTAL EXPENDITURES $50,396,578 $52,190,519 $53,386,614 $54,768,665 $56,295,673 $57,842,789 General Fund Expenditures by Sub-Function Preliminary Budget 20 @ 2.9%

ACTUAL EXPENDITURES BUDGET PROJECTION 2016 2017 2018 2019 2020 Regular Programs $17,460,056 $18,747,322 $18,831,514 $20,664,544 $21,177,909 $513,365 2.48% Special Programs $7,543,459 $7,946,139 $8,434,896 $8,521,655 $9,072,599 $550,944 6.47% Vocational Education $550,447 $536,454

$589,581 $729,000 $788,000 $59,000 8.09% Non-Instructional Programs $9,376 $34,331 $125,380 $101,844 $110,712 $8,868 8.71% Nonpublic School Programs - IU $0 $3,109 $936 $3,109 $3,469 $360 11.58% DOLLAR CHG % INSTRUCTION Adult Education Programs $0 $0

$0 $0 $0 Higher Education Programs $4,282 $0 $3,439 $3,000 $2,566 $0 Pre-Kindergarten $0 $0 $0 $0 $0 $0 TOTAL INSTRUCTION $25,567,620 $27,267,355 $27,985,745 $30,023,152 $31,155,256 $1,132,104 3.77% Support Services - Students $1,091,802

$1,323,032 $1,524,912 $1,552,075 $1,620,303 $68,228 4.40% Support Services - Instructional Staff $1,788,926 $1,409,281 $1,447,388 $1,553,364 $1,586,095 $32,731 2.11% Support Services - Administration $2,355,959 $2,451,814 $2,589,447 $2,774,533 $2,872,671 $98,138 3.54% Support Services - Pupil Health $512,512 $513,809 $495,680 $547,645

$570,236 $22,591 4.13% Support Services - Business $395,099 $360,024 $384,107 $415,439 $441,837 $26,398 6.35% Operation and Maintenance of Plant Services $3,449,750 $3,653,800 $3,908,780 $3,932,951 $4,192,710 $259,759 6.60% Student Transportation Services $2,386,102 $2,430,975 $2,464,051 $2,551,729 $2,636,286 $84,557 3.31%

Support Services - Central $421,836 $863,870 $935,549 $1,005,538 $1,023,592 $18,054 1.80% Other Support Services $27,589 $27,664 $27,523 $28,000 $28,000 $0 0.00% TOTAL SUPPORT SERVICES $12,429,575 $13,034,270 $13,777,437 $14,361,274 $14,971,729 $610,455 4.25% ($434) -14.46% SUPPORT SERVICES

NON-INSTRUCTIONAL SERVICES Food Services $0 $0 $0 $0 $0 $0 Student Activities $888,322 $948,645 $906,772 $1,023,366 $1,105,859 $82,493 8.06% Community Services $28,560 $26,660 $26,426 $38,934 $39,799 $865 2.22% Scholarship and Awards $0 $0 $0

$0 $0 $0 TOTAL NON-INSTRUC'L SUPPORT SVCS $916,882 $975,305 $933,198 $1,062,300 $1,145,658 $83,358 7.85% FAC IMPROVEMENT $15,597 $0 $0 $37,835 $39,377 $1,542 4.08% Debt Service / Other Spend and financing Uses $3,689,895 $3,899,789 $4,436,794 $4,675,286 $4,714,000 $38,714 0.83%

Interfund Transfers-Out $2,778,835 $2,665,909 $1,559,302 $65,000 $65,000 $0 Budgetary Reserve $0 $0 $0 $171,731 $99,500 ($72,231) -42.06% TOTAL DEBT SERVICES / OTHER $6,468,730 $6,565,698 $5,996,096 $4,912,017 $4,878,500 ($33,517) -0.68% TOTAL EXPENDITURES $45,398,404 $47,842,627 $48,692,477

$50,396,578 $52,190,519 DEBT SERVICES / OTHER $1,793,941 0.00% 3.56% Budget Projection General Fund Projection Summary Preliminary Budget 20 @ 2.9% BUDGET 2019 2020 2021 Budget 2022 2023 2024 REVENUE Local State Federal Other Financing Sources TOTAL REVENUE $30,625,460 $19,047,971 $503,500 $0 $50,176,931 $32,174,854 $19,480,069 $608,638 $0 $52,263,561 $33,260,757 $19,766,594 $608,638 $0 $53,635,989

$34,387,847 $20,055,882 $608,638 $0 $55,052,367 $35,494,266 $20,376,425 $608,638 $0 $56,479,329 $36,573,430 $20,632,381 $608,638 $0 $57,814,449 EXPENDITURES Salary and Benefit Costs Other TOTAL EXPENDITURES $31,788,350 $18,608,228 $50,396,578 $33,201,295 $18,989,224 $52,190,519 $34,242,304 $19,144,310 $53,386,614 $35,336,045 $19,432,620 $54,768,665 $36,563,683 $19,731,990 $56,295,673 $37,810,151 $20,032,637 $57,842,789 $73,042 $249,375 $283,703

$183,656 SURPLUS / DEFICIT ($219,647) ($28,340) BEGINNING FUND BALANCE $10,596,375 $10,376,728 $10,449,769 $10,699,145 $10,982,847 $11,166,504 PROJECTED YEAR END BALANCE $10,376,728 $10,449,769 $10,699,145 $10,982,847 $11,166,504 $11,138,164 FUND BALANCE AS % OF EXPENDITURES FUND BAL AS # OF Mos OF EXPEND. 20.59% 2.47 20.02% 2.40 20.04% 20.05% 19.84% 19.26% 2.40

2.41 2.38 2.31 CAPITAL PROJECTS FUND HS desk & library furniture > 2019 project MS/HS tech tv replacement for 2020/21 CO 2 for 2019 Projects Smart Interactive 86 TVs High School $750,000 Interactive TVs, wall mounts, sound bars, shipping, installation for 73 classrooms Classroom desktop for 73 classrooms 5 Standard 55 TVs for IPC and conference rooms Middle School $500,000 Interactive TVs, wall mounts, sound bars, shipping, installation for 50 classrooms Classroom desktops for 50 classrooms 4 Standard 55 TVs for conference rooms WiFi Access Point, Backup, Fiber Study CO#2 Technology Change Order $167,000 WiFi access points all buildings $64,500 MS & HS currently have minimal outdoor WiFi access Utilized during fire and emergency drills Navigate Prepared Secondary benefit provides WiFi access for the community Supplemental WiFi indoor access for kitchens at all buildings Backup Server and Backup Storage $75,000 Primary backup copy of all district servers Existing equipment over 5 years old multiple disk drive failures in the past 30 days Fiber cable to Oak Flat and Newville Engineering Study $27,500 Allows for collaborative group seating as well as options for individual seating. Ribbon Model #1 tables are easily pushed together to create a larger table for 16-20 students which works well for discussion. Cafe seating allows option for standing. Quantity HS Furniture

Item Cost Per Item 261.79 Total Cost 4 Ribbon Tables $ 5 Gray Chairs 1,047.16 261.71/box of 4 $ 3 Square cafe standing height table 416 $ 1,308.55 1,248.00 6 stools **need options other than what was offered this year due to stools being uncomfortable** 175 $ 1,050.00 $ 3,603.71 Total *need to add cost of stools ***

If we use 8 free standing desks that we currently have we could eliminate 1 ribbon table and 1 cafe table for a total cost of $2,925.92. HS Library Quantity Item Cost Per Item Total Cost COMFORTABLE OPTION 4 "egg" seats (like in innovation lab) 850 $ 1 round ottaman/table 500 ? 3,400.00 Allows for collaborative group seating as well as options for individual seating. Sit to stand desks can be used individually or pushed together in pods of 2 or 4. Two wisp Model #2 tables may be pushed together to create a larger table for more collaborators. Standing option for students could be provided with sit to stand desks. Quantity HIGH TOP SEATING 4 16 Item 4 wisp table 416 $ 1,664.00

4 sit to stand desks stools (flavor or plato??) 28 in. 160 $ 2,560.00 6 gray chairs **not sure which height is needed** 24 in. 154 36 in square cafe table Cost Per Item 315 $ 1,260.00 465.08/pack of 2 $ 1,860.32 261.71/box of 4 $ 1,570.26 Total COLLABORATIVE OPTIONS 8 15 gray chairs/pack of 4 3-2-1 table 261.71/box of 4 $ 317 $ 2,141.68

*** 4,755.00 Total Cost $ 4,690.58 If we use 8 free standing desks that we currently have we could eliminate 2 sit to stand packages for a total cost of $3,760.42 INDIVIDUAL OPTIONS 5 30 in round cafe table 155 $ 755.00 6 common area chair with tablet arm 600 $ 3,600.00 Total $ 18,875.68 Model #3 Allows for most standing options, cafe style seating, and collaborative seating. Quantity Item 1 Standing Height Table & Top 3 2 2 Square cafe standing height table gray chairs ribbon table

12 stools **need options other than what was offered this year due to stools being uncomfortable** Cost Per Item 1025 Total Cost $ 1,025.00 416 $ 261.71/box of 4 $ 261.79 $ 175 $ 1,248.00 1,308.55 523.58 2,100.00 Total $ 4,105.13 *need to add cost of stools Questions & Discussion RANDOM BACKUP Buildings & Grounds ACHIEVEMENT - ROI PSSA Summary - 2018 Keystones Algebra 1 Keystones - Literature Keystones - Biology

Recently Viewed Presentations