Building & Property Committee Construction Punch List Fiber - - PowerPoint PPT Presentation

Building & Property Committee

19 12 09 19 12 09

1



Construction Punch List



Fiber Build



Funds Update



Capital Project List



FY 21 Budget Projection



Committee Discussion

Con

• nstruction
• n P

Punch L List

2

Furniture

3

Item Description Status High School Standing height table in Library needs correct base

Ship to Tanner 10/4 came in wrong & reordered

Middle School Ruckus table still needs parts in Library

Side came but was the wrong color

Three Media tables in LGR/innovation lab need to be drilled a Table and power supply here Broken stool in room next to LGR needs fixed/replaced

We have the broken one picture sent 10/21

Broken stool in the commons area

We have the broken one

Booth wheels and locks in commons need looked at - not working properly

Waiting on Tanner

Oak Flat Media tables in LGI need to be drilled & power supplies instal Table and power suppy here Conference room has the wrong table

Waiting on Tanner

broken Kindergarten table neeeds replaced

Ordered & delivered but the wrong color

Legs need placed on tables in the LGI

Shp to Tanner 10/8

Classroom 109 desk needed repaired

Waiting on Tanner

Star table upstairs top is broken

Rm 211

Mt Rock Broken desk in Mrs. Devonald's room needs replaced

Waiting on Tanner

Media table in LGI needs drilled and power installed

Table and power supply here

Covers for sharp screws on student desks

Tom spoke to Theresa 10/23/19

Newville 3 desk tops broken from last year need replaced

1 Fixed - 2 tops delivered on 11/27/19 they are not square tops

New Order Items Portico Table for Oak Flat - Not received

not received

Sway Lounge Chair for HS - Not received

not received

Mobile Steel Bookcases for Mt. Rock - Not received

not received

One Lecturn received at Mt. Rock - Damaged

damaged

Construction

4

Fi Fiber B r Bui uild

5

Fiber eRate Project

• Analysis and Design - Complete
• Feasibility Study to define potential routes
• Engineering project to design the selected route and construction documents
• Develop an eRate competitive bid document – on the agenda for approval this evening
• FCC Filing and PP&L Agreement – December 2019
• PP&L Pole Attachment Agreement – Solicitor reviewing, on the agenda this evening as an information item
• FCC eRate 470 filing – submission of a competitive construction/bidding document
• PP&L Pole Attachment Engineering Study – to commence upon signing the Pole Attachment Agreement

Fiber eRate Project

• Bidding - (January through July 2020)
• Bid Evaluations
• Complete a bid matrix analysis and long-term ROI
• Choose the bid that is most cost effective
• Submit an FCC eRate 471 form
• Secure Township, PennDOT, and CVRT agreements
• FCC Approval and Construction
• Waiting for approval and funding - March 2020 – February 2021
• Construction – May 2021 to April 2022
• Turn up new fiber connections – Summer 2022

Funds U Update

8

Ge Gener eral F Fund und @ @ June une 30

9

June 30, 2019 Unassigned Nonspendable Assigned Committed Total General Fund Balance 4,185,336 4,185,336 Employee Health Insurance 2,200,000 2,200,000 PSERS 650,000 554,000 1,204,000 Healthcare 350,000 350,000 Technology 2,300,000 2,300,000 Special Education 550,000 550,000 Student Info Sy/Financial Software 200,000 200,000 Safety/ y/Security/ y/SRO RO 400, 00,000 000 400, 00,000 000 Studen ent S Ser ervices es/Men ental H Hea ealth 400, 00,000 000 400, 00,000 000 AFR Balance at June 30, 2019 4,185,336 $ 2,200,000 $ 4,850,000 $ 554,000 $ 11,789,336 $ notes

2019-20 Budget 52,354,735 $ Allowable Unassigned @ 8% 4,188,379 $

General Fund Balance

Capital P Projec ects Reser serve F e Fund und

10

Big Spring Capital Projects Fund

Balance at Dec 9, 2019 6,758,262 $ Capital Project: Unused Funds: Pedestrian Safety Improvement

• MS Roof Design Phase I, II, & III

11,200 HS Gym Floor Refinish 2,646 HS Auditorium AV Repair 1,921 Server Room UPS Replacement 5,000 HS Network Replacement (Erate Cat 2) 139,279 HS Roof Design/Mgmt/Inspections 10,600 MR Roof Design & Management 550 HS Gym Audio Replace 19 NV/MR/MS/HS FF&E Design & Purchase 14,315 NV/OF/HS/DAO NV & Assoc Technology Projects 15,260 HS Collaboration Lab 933 NV Asbestos Abatement CO 3 3,834 Ext Wifi/Backup Server & Storage/Erate/Fiber Study 91,460 HS/HS Library Furniture Replacement 70,000 HS/MS/MR Gym Light LED Replacement 3,384 MS - 86" Interactive Panel TV's (50) 500,000 HS - 86" Interactive Panel TV's (73) 750,000 Fitness Center Equipment 149 NV Playground Equipmen Replace 5,236 1,625,786 $ (1,625,786) $ Available Capital Projects Reserve Balance 5,132,476 $

As of 9 Dec 2019

NV NV B Bon

• nd

11

Newville Projects Fund GOB 2017 Bond Issue = 13,004,518 $

Project Budget Paid to Date

Budget Balance

Track & Turf Field ** 1,345,501 (1,413,665) (68,164)

Complete

MS Roof Replacement 1,376,700 (1,376,700)

Complete

MS Gym Floor 80,600 (80,600)

Complete

HS Roof - White Knight 392,000 (392,000)

Complete

MS Exterior Courtyard Renovation 372,251 (106,467) 265,784 Stadium Site Improve/DAO Drainage 537,640 (1,900) 535,740 Emergency Generator 284,888 284,888 Newville Elem Renovation 7,787,097 (7,574,957) 212,140 Mount Rock Renovations

GOB 2018

(19,100) Middle School Renovations

GOB 2018

(112,267) High School Renovations

GOB 2018

(53,424) BSSD Phase 2 Renovations

GOB 2018

(1,606,688) BSSD Phase 2 Technology

GOB 2018

(371,407) BSSD Phase 2 - FFE

GOB 2018

(10,000) Stadium Sound Replace

GOB 2018

(26,655) MS Auditorium Lighting Replace

GOB 2018

(84,338) Total Spend 12,176,677 (13,230,168) $1,230,387 Interest earned to 11/30/19 $225,918 Current Balance Newville Projects Fund = 269 $

MR B Bond

12

Mount Rock Projects Fund - 2018 GOB 2018 Bond Issue = 9,820,944 $

Project Budget Paid to Date

Budget Balance

Mount Rock Renovations 1,304,920 (1,622,744) (317,824) Middle School Renovations 2017 Bond 1,961,123 (1,203,906) 757,217 Middle School Renovations 2018 Bond 394,266 394,266 High School Renovations 1,020,135 (525,326) 494,809 Phase 2 Renovations (CRA Prof Svcs)

incl

(82,512) (82,512) Phase 2 Reno - HS/MS/MR/OF (4,386,423) (4,386,423) BSSD Phase 2 -FFE (331,052) (331,052) Phase 2 Tech

incl

(1,456,818) (1,456,818) Total $4,680,444 (9,608,781) $ (4,928,337) $ Interest earned to 11/30/19 = $225,588 Current Balance Mount Rock Projects Fund - 2018 = $437,751 Bond Funds Remaining (2017 & 2018) = 438,020 $

$438,020

• $237,747

$200,273 Est remaining

Current t Fund Up Update

13

BEGINNING BALANCE RECEIPTS DISBURSEMENTS ENDING BALANCE

FUND

11/1/2019 FEDERAL STATE LOCAL 11/30/2019

GENERAL FUND 27,696,475 77,139 468,627 2,002,805 3,280,938 26,964,108 CAFETERIA FUND 485,985 131,267 7,490 80,819 107,616 597,945 STUDENT ACTIVITIES 286,202 37,926 15,059 309,069

Ca Capital Project Li List

14

Previou

• usly

Approved

15

Cap Project List

16

Pri Bldg Description Cap Proj Gen Fund 1 MS/HS Interactive Panel TVs 1,250,000 1 MS/HS Whiteboards & Wall Treatments 400,000 1 MS Golf Room Reno for Tech 39,000 1 IT PPL Pole Attachment Engineering Study 12,800 1 DAO Add basement HVAC & Fix Cold Air Infiltration 100,000 1 ALL Install of Outdoor Wifi & data wiring 15,000 1 IT Fiber Study (to OF & NV) 7,500 Priority 1 Total = 1,824,300 2 HS Kitchen - Additional Cooling 80,000 2 IT Fiber to OF/NV 750,000 2 IT Core Network Switch 50,000 2 IT Servers 30,000 2 MS Backup pwr for IDF/Server/Ductless unit 40,000 2 MS Kitchen - Additional Cooling 80,000 2 MS Kitchen Kiosk 75,000 2 HS Lwr entrance digital marquee 25,000 2 OF Outdoor Learning Space / Playground Reno's 105,000 2 OF Administration office renovations 70,000 2 OF Kitchen - Additional Cooling 40,000 Priority 2 Total = 1,215,000 130,000

17

3 HS Update cat6 network cabling 300,000 3 HS Bells Clocks Intercom 175,000 3 HS/MS Flexible Seating 500,000 3 HS/MS Re-key locks 80,000 3 MS Courtyard conversion 50,000 3 MS Repointing 4000 SF 75,000 3 IT Backup to Core Switch 50,000 Priority 3 Total = 680,000 550,000 4 HS Commons LED Lighting 35,000 4 HS Turf Field Field House / Lighting 400,000 4 IT eRate cat 2 - District contribution (Wi-Fi & network switching) 250,000 4 IT District Office SAN 75,000 4 MR Replace 3 Ductless AC units 35,000 4 MS Stadium Parking Lot Water Infiltration 50,000 4 OF Roof replace/restore 650,000 Priority 4 Total = 1,495,000 4+ MR Replace Heat Pumps in Room 200,000 4+ MS Replace 110 Heat Pumps (10-15 yr life - installed 2005) 330,000 Priority 4+ Total = 530,000 Total All Projects = 5,744,300 680,000

Track A As B Bui uilt

18

19

Fiel eld H d House

FY 21 B FY 21 Budget

Res esoluti tion to S Stay W With thin I Index – Wi Will I It W Wor

• rk?

k?

20

Act ct 1 1 - Ad Adjusted I Index

21

School District County 2019-20 MV/PI Aid Ratio 2020-21 Adjusted Index Shippensburg Area SD Cumberland 0.5603 3.4% Greencastle-Antrim SD Franklin 0.5484 3.4% Tuscarora SD Franklin 0.5540 3.4% West Perry SD Perry 0.5753 3.4% Carlisle Area SD Cumberland 0.5307 3.3% Northern York County SD York 0.5078 3.3% Big Spring SD Cumberland 0.4731 3.2% East Pennsboro Area SD Cumberland 0.4835 3.2% Mechanicsburg Area SD Cumberland 0.4469 3.1% Camp Hill SD Cumberland 0.4154 3.0% West Shore SD York 0.4142 3.0% Cumberland Valley SD Cumberland 0.3210 2.6% South Middleton SD Cumberland 0.3618 2.6%

Asse sesse ssed V d Value H Hist story

22

23

Property T Tax Assu Assumptions

2020

Assessed Valuation 1,778,011,002 Millage Rate 14.3238

2021 2022 2023 2024 2025

% Change to Assessed Valuation 2.65% 1.50% 1.50% 1.50% 1.50% and/or $ Change to Assessed Valuation Assessed Valuation 1,825,128,294 1,852,505,218 1,880,292,796 1,908,497,188 1,937,124,646 Millage Rate 14.7535 15.1961 15.6520 16.1216 16.6052 Total Taxes $26,927,056 $28,150,891 $29,430,348 $30,767,958 $32,166,362 Adj Act 1 Index 3.20% 3.20% 3.20% 3.20% 3.20% District Index 3.00% 3.00% 3.00% 3.00% 3.00% Index used for tax calculations 3.00% 3.00% 3.00% 3.00% 3.00%

Property Tax Reductions due to Homestead Exclusions

770,000 770,000 770,000 770,000 770,000 Tax Collection Rate 95.00% 95.00% 95.00% 95.00% 95.00% Total Taxes x Tax Collection Rate $24,849,203 $26,011,846 $27,227,331 $28,498,060 $29,826,543 Property Tax Projections (6111) $24,849,203 $26,011,846 $27,227,331 $28,498,060 $29,826,543 Property Tax (6111) $24,008,252 Percent Change 3.5028% 4.6788% 4.6728% 4.6671% 4.6617%

BUDGET 2020 2021 2022 2023 2024 2025 LOCAL Taxes Levied $29,772,052 $30,908,003 $32,070,646 $33,286,131 $34,556,860 $35,885,343 Other Local Revenue $2,167,757 $2,361,696 $2,361,696 $2,361,696 $2,361,696 $2,361,696 TOTAL LOCAL REVENUE $31,939,809 $33,269,699 $34,432,342 $35,647,827 $36,918,556 $38,247,039 STATE Basic Aid $10,090,668 $9,692,817 $9,692,817 $9,692,817 $9,692,817 $9,692,817 Other State Revenue $9,264,029 $9,963,277 $10,180,753 $10,368,513 $10,588,790 $10,741,594 TOTAL STATE REVENUE $19,354,697 $19,656,094 $19,873,570 $20,061,330 $20,281,607 $20,434,411 TOTAL FEDERAL REVENUE $603,813 $608,813 $608,813 $608,813 $608,813 $608,813 OTHER FINANCING SOURCES $0 $0 $0 $0 $0 $0 TOTAL REVENUE $51,898,319 $53,534,606 $54,914,725 $56,317,970 $57,808,976 $59,290,263

General Fund │ Revenue Analysis

REVENUE PROJECTIONS

25

BUDGET 2020

2021 2022 2023 2024 2025

Salaries $20,553,214 $21,177,737 $21,821,222 $22,476,359 $23,151,150 $23,846,184 Benefits $12,383,387 $12,844,111 $13,369,825 $13,869,333 $14,470,544 $14,944,765 TOTAL SALARIES & BENEFITS $32,936,601 $34,021,848 $35,191,047 $36,345,692 $37,621,693 $38,790,949 Supplies $2,390,791 $2,382,567 $2,394,578 $2,406,829 $2,419,325 $2,432,071 Purchases $11,136,645 $11,127,092 $11,423,861 $11,733,620 $12,056,967 $12,394,527 Property $675,281 $675,281 $675,281 $675,281 $675,281 $675,281 Other Objects $1,495,417 $1,486,917 $1,488,260 $1,489,631 $1,491,028 $1,492,454 Other Financing Uses $3,720,000 $3,720,000 $3,720,000 $3,720,000 $3,720,000 $3,720,000 TOTAL ALL OTHER $19,418,134 $19,391,857 $19,701,979 $20,025,360 $20,362,601 $20,714,333 TOTAL EXPENDITURES $52,354,735 $53,413,705 $54,893,026 $56,371,052 $57,984,294 $59,505,282

General Fund │ Expenditure Analysis

EXPENDITURE PROJECTIONS

26

BUDGET 2020 2021 2022 2023 2024 2025 REVENUE Local $31,939,809 $33,269,699 $34,432,342 $35,647,827 $36,918,556 $38,247,039 State $19,354,697 $19,656,094 $19,873,570 $20,061,330 $20,281,607 $20,434,411 Federal $603,813 $608,813 $608,813 $608,813 $608,813 $608,813 Other Financing Sources $0 $0 $0 $0 $0 $0 TOTAL REVENUE $51,898,319 $53,534,606 $54,914,725 $56,317,970 $57,808,976 $59,290,263 EXPENDITURES Salary and Benefit Costs $32,936,601 $34,021,848 $35,191,047 $36,345,692 $37,621,693 $38,790,949 Other $19,418,134 $19,391,857 $19,701,979 $20,025,360 $20,362,601 $20,714,333 TOTAL EXPENDITURES $52,354,735 $53,413,705 $54,893,026 $56,371,052 $57,984,294 $59,505,282 SURPLUS / DEFICIT ($456,416) $120,901 $21,699 ($53,082) ($175,318) ($215,019) BEGINNING FUND BALANCE $11,789,336 $11,332,920 $11,453,821 $11,475,520 $11,422,438 $11,247,121 PROJECTED YEAR END BALANCE $11,332,920 $11,453,821 $11,475,520 $11,422,438 $11,247,121 $11,032,101 FUND BALANCE AS % OF EXPENDITURES 21.65% 21.44% 20.91% 20.26% 19.40% 18.54% FUND BALANCE AS # OF MONTHS OF EXPEND. 2.60 2.57 2.51 2.43 2.33 2.22

General Fund │ Projection Summary

REVENUE / EXPENDITURE PROJECTIONS

27 BUDGET 2020 2021 2022 2023 2024 2025 REVENUE Local $31,939,809 $32,524,630 $32,897,165 $33,275,287 $33,659,081 $34,048,633 State $19,354,697 $19,656,094 $19,873,570 $20,061,330 $20,281,607 $20,434,411 Federal $603,813 $608,813 $608,813 $608,813 $608,813 $608,813 Other Financing Sources $0 $0 $0 $0 $0 $0 TOTAL REVENUE $51,898,319 $52,789,537 $53,379,548 $53,945,430 $54,549,501 $55,091,857 EXPENDITURES Salary and Benefit Costs $32,936,601 $34,021,848 $35,191,047 $36,345,692 $37,621,693 $38,790,949 Other $19,418,134 $19,391,857 $19,701,979 $20,025,360 $20,362,601 $20,714,333 TOTAL EXPENDITURES $52,354,735 $53,413,705 $54,893,026 $56,371,052 $57,984,294 $59,505,282 SURPLUS / DEFICIT ($456,416) ($624,168) ($1,513,478) ($2,425,622) ($3,434,793) ($4,413,425) BEGINNING FUND BALANCE $11,789,336 $11,332,920 $10,708,752 $9,195,274 $6,769,652 $3,334,860 PROJECTED YEAR END BALANCE $11,332,920 $10,708,752 $9,195,274 $6,769,652 $3,334,860 ($1,078,566) FUND BALANCE AS % OF EXPENDITURES 21.65% 20.05% 16.75% 12.01% 5.75%

• 1.81%

FUND BALANCE AS # OF MONTHS OF EXPEND. 2.60 2.41 2.01 1.44 0.69

• 0.22

191209 FY 21 Gen Fund Exp Summary - No tax Increase

REVENUE / EXPENDITURE PROJECTIONS

Gr Grea eat A Amer erican Road

• adtri

rip

28

Qu Ques estion

• ns

& D Discu scussi ssion

29