Northern Bedford County School District Preliminary Budget - - PowerPoint PPT Presentation
Northern Bedford County School District Preliminary Budget Presentation May 12, 2020 Budget Committee Randy Wiand Chris Cronrath John Eshelman 2020/21 Proposed General Fund Budget At A Glance Revision 3 6/17 Revenues Expenditures 6000
2
Revenues Expenditures 6000‐Local $4,153,645 100 – Personnel $6,174,865 7000‐State $9,116,031 200 – Benefits $4,328,403 8000‐Federal $ 344,851 300 – Professional Other $528,695 400 – Purchased Property $105,996 500 – Other Purchased Services $1,435,020 600 – Supplies $811,467 700 – Property & Equipment $5,000 800 – Dues & Fees $213,381 900 – Debt $554,638 Total $13,614,527 Total $14,157,563 Deficit ‐$543,037
EXPENDITURES BY TOTAL OBJECT
2020/21Budget Revision 3 2019/20 Budget 20/21 vs 19/20 Variance 100 Personnel and Salaries $6,174,865 $6,119,603 $55,262 200 Personnel Services - Employee Benefits $4,328,403 $4,326,264 $2,139 300 Purchased Professional Technical Services $528,695 $581,680
400 Purchased Property Services $105,996 $146,763
500 Other Purchased Services $1,435,020 $1,475,965
600 Supplies $811,467 $717,110 $94,357 700 Property $5,000 $107,050
800 Other Objects $213,481 $233,255
900 Other Financing $554,638 $652,244
Total $14,157,564 $14,359,932
Deficit
$109,821 300-900 OBJECTS $3,654,297 $3,914,067
REVENUES
2020/21Budget Revision 3 2019/20 Budget 20/21 vs 19/20 Variance 6000Local Funds $4,153,645 $4,238,836
7000State Funds $9,116,031 $9,343,029
8000Federal Funds $344,851 $344,851 $0 Total $13,614,527 $13,926,716
EXPENDITURES BY TOTAL OBJECT
2020/21Budget Revision 3 2020/21Budget Revision 2 20/21 vs 19/20 Variance 100 Personnel and Salaries $6,174,865 $6,229,485
200 Personnel Services - Employee Benefits $4,328,403 $4,328,385
300 Purchased Professional Technical Services $528,695 $560,543
400 Purchased Property Services $105,996 $108,948
500 Other Purchased Services $1,435,020 $1,444,770
600 Supplies $811,467 $919,166
700 Property $5,000 $3,000 $2,000 800 Other Objects $213,481 $217,181
900 Other Financing $554,638 $554,638
Total $14,157,564 $14,366,116
Deficit
$62,838 300-900 OBJECTS $3,654,297 $3,808,246
REVENUES
2020/21Budget Revision 3 2020/21Budget Revision 2 Variance 6000Local Funds $4,153,645 $4,356,498
7000State Funds $9,116,031 $9,184,603
8000Federal Funds $344,851 $344,851 $0 Total $13,614,527 $13,885,952
5
6
Level Currently budgeted Maximum we could tax to.. $117,200 additional
APRIL 2020 AV Act 1 Index MILLS TO INDEX 0.50% 1.00% 1.50% 2.00% 2.50% 3.00% 3.20% 3.60% $403,849,990 8.57590 0.0360 8.8846 8.62 8.66 8.70 8.75 8.79 8.83 8.8503 8.8846 ESTIMATED RE TAXES AT 94% COLLECTION $3,463,377 $3,480,694 $3,498,011 $3,515,328 $3,532,645 $3,549,962 $3,567,278 $3,574,20 5 $3,588,0 59 LESS PROPERTY TAX RELIEF $323,998.00 $323,998 $323,998 $323,998 $323,998 $323,998 $323,998 $323,998 $323,99 8 BUDGETED $2,951,016 $2,967,294 $2,983,572 $2,999,850 $3,016,128 $3,032,406 $3,048,684 $3,055,19 5 $3,068,2 17 $16,278 $16,278 $16,278 $16,278 $16,278 $16,278 $6,511 $13,022 REVENUE IMPACT $32,555.75 $48,833.62 $65,111.49 $81,389.36 $97,667.24 $104,178. 38 $117,20 0.68
7
Subsidy Item 2019/20 and 2020/21 Proposed Budget February 2020 Governor Wolf Proposed Subsidy Difference Basic Education Funding (BEF) $5,883,371 $5,946,142 $62,967 Special Education Funding (SEF) $632,336 $637,941 $5,605
9
Cost Math Curriculum Grade 3‐12 REDUCED HIGH SCHOOL $18,161 MS REDUCED $32,000 $67,200 Student Information System – FOCUS REDUCED $9,400 $21,800 MS 1:1 Lease will renew for Grade 6 – 7 – 8 Yearly Cost $20,000 MS/HS Library conversion to Library REDUCED $4,000 $6,000 Replacement 20" walk behind scrubber, pad assist d $5,500 Salt Dogg 2yd Stainless Steel spreader for the dump truck $4,000 6ft Turf Roller for Athletic Fields $3,475 Electronic Balance $1,425 Backflow preventer at Elementary $1,400 Position Budget One Additional Personal Care Aid to Hire thru NBC – Under 30 Hour per week position $18,530 Technology Budget Requests up from 2019/20 to 2020/21 Budgets $19,987 NEW ‐‐ Elementary See Saw Application $2,400
ELEM MPR SPEAKERS $1,200 LED LIGHTING ELEMENTARY LOBBY/NORTH LOBBY/SOUTH MAIN LOBBY $2,400 STIHL KOMIBI HEDGE TRIMMER ATTACHMENT ` $275 STIHL POWER SWEEP ATTACHMENT $325 REPLACE FOOD DISPOSALS ROOM 138/139 $400 REPLACE ENTRACE MATTING MAIN ENTRANCE AT ELEMENTARY $900 LOAD OF ANTI SKID MATERIAL $1,000 ENTRANCE WAY MATTING MAIN ENTRANCE AT ELEMENTARY $1,050 HS/MS AND 6TH GRADE 4 X 10 FOOT MATS $1,500 SNOW PLOW ATTACHMENT SKID STEER $1,800 BATHROOM STALLS KINDERGARTEN PODS $2,000 TURF ROLLER $3,475 SCOREBOARD SOCCER FIELD $8,000 HALF MOON ACTIVITY TABLE AND CHAIRS $1,503 REDUCED ASSEMBLIES FOR PRINCIPAL BUDGETS $950 REDUCED PBIS INCENTIVES FOR PRINCIPALS $1,000 REDUCED PRINCIPAL CONFERENCES $800 REDUCED BUDGET ON STEM CLASROOM $4,000 REDUCED ROCK SALT $500 REDUCED PAINT ATHLETIC FIELD $2,000 REDUCED SKIDS CALCIUM SIDEWALK SALT $1,100 TOTAL $36,178
10
Athletic Trainer was not budgeted for enough ‐$11,000 Travel – Administration $750 Conferences – Principals, Special Education Sup, Bus Manager $3,600 Supplies – Administration $1,500 Board Travel $1,000 Attorney Fees $5,000 Transportation $5,000 IU Services $35,500 FOCUS SIS SOFTWARE REDUCED AMOUNT ORIGINALLY BUDGETED $21,800 TOTAL $63,150
11
12
YEAR TOTAL PAYMENT INTEREST (800) PRINCIPAL (900) TRANSFER TO CAPITAL RESERVE (900) 2017/18 $469,937.50 $87,168.75 $382,168.75 $107,868.75 2018/19 $467,537.50 $81,268.75 $382,268.75 $117,975.00 2019/20 $465,337.50 $75,168.75 $390,168.75 $127,075.00 2020/21 $467,737.50 $68,868.75 $398,868.75 $130,768.75 2021/22 $467,837.50 $63,918.75 $403,918.75 $135,918.75 2022/23 $466,037.50 $60,518.75 $405,518.75 $147,087.50 2023/24 $469,137.50 $57,068.75 $412,068.75 $150,587.50
13
BUDGETARY RESERVE ITEMS Cost Undesignated $67,000 Stand Mixer – MS/HS Cafeteria $27,000 Audiometer $2,300 Budgetary reserve is a LINE item of the General fund budget. This budget year has $96,300 for items that may not be known at the time of budgeting – a contingency. Below are some items that when reviewing the budget are on the verge of needing replaced, but we have placed them in a budgetary reserve so that if they are replaced, the board will know that have contingently planned on them.
14
ITEM BALANCE BEGINNING BALANCE JULY 2019 $1,350,039 TRANSFER FROM GENERAL FUND 2018/19 SURPLUS PLUS INTEREST $523,633 TRANSFER FOR 2019/20 BUDGETED BUT NOT TRANSACTED YET $127,095 2019/20 WITHDRAWALS: TRACK $187,500 HOT WATER SYSTEM $47,700; CRABTREE ROHRBAUGH $13,944 ‐$249,144 ESTIMATED ENDING BALANCE JUNE 2020 $1,751,623
15
Elementary Middle/High A) Federal Reimbursement for Free Meals $3.41 $3.41 B) Federal Reimbursement for Paid Meals $.32 $.32 C) Equitable Meal Price Target (B‐A) $3.09 $3.09 Current Meal Price $2.35 $2.45 2020/21 Meal Price to comply $2.45 $2.55
Last year at this time our district wide percentage was 43.02%.
18
High School Elementary District Wide Free/Reduced Percentage 38.7% 41.04% 39.86% We anticipated increases in the free and reduced program eligibility due to unemployment associated with COVID19, however, we have not experienced this increase. Normally, when applications for unemployment go thru, the Direct Certification automatically updates. With the COVID19 feeding program which we enrolled in, there was no requirement for Free and Reduced status, however we have not received verification from the State if this can continue past June 1.
19