Joshua Sweigard, CPA Business Manager June 10, 2020 2020-2021 - - PowerPoint PPT Presentation

Joshua Sweigard, CPA Business Manager June 10, 2020

2020-2021 BUDGET Sections:

• Budget Overview
• Revenue
• Expenditures
• Countywide

Benchmarking Data

• Total Budget

March 6th Preliminary Budget June 10th Proposed Final Budget

0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00%

COVID Pandemic

13.3%

Great Recession Great Depression

Great Recession COVID-19

FINAL BUDGET OVERVIEW:

Preliminary Budget Proposed Final Budget 2020-2021 2020-2021 TOTAL ESTIMATED REVENUES $ 142,660,978 $ 139,165,372 TOTAL ESTIMATED EXPENDITURES $ 146,912,723 $ 146,487,687 SURPLUS/(SHORTAGE) $ (4,251,745) $ (7,322,315)

Final Budget Proposed Final Budget 2019-2020 2020-2021 Change LOCAL REVENUES $ 92,614,667 $ 88,366,312 $(4,248,355) STATE REVENUES 46,522,767 46,583,593 60,826 FEDERAL REVENUES 2,452,983 4,215,467 1,762,484 TOTAL REVENUES $ 141,590,417 $139,165,372 $(2,425,045)

Local Revenues

2018-2019 Actual 2019-2020 Budget Proposed Final 2020-2021 Budget Change

6111 Current Real Estate Taxes

$ 84,224,652 $ 83,571,866 $ 80,900,731 $ (2,671,135)

6113 Public Utility Realty Taxes

88,598 89,000 81,000 (8,000)

6114 Payments in Lieu of Taxes

34,987 284,987 284,987

• 6141

Current Act 511 Taxes - Flat Rate Assessments - Per Cap

84,014 90,000 90,000

• 6143

Current Act 511 Taxes - Flat Rate Assessments - LST

91,319 79,000 79,000

• 6153

Current Act 511 Taxes - Prop. Assessments - RE Transfer

1,597,748 1,100,000 733,333 (366,667)

6157

Current Act 511 Taxes - Prop. Assessments - Mercantile

537,651 554,000 286,667 (267,333)

6411 Delinquencies on Taxes Levied

4,112,238 4,326,000 3,850,000 (476,000)

6510 Earnings on Investments

1,469,654 650,000 150,000 (500,000)

6710 Revenues from District Activities

53,747 25,644 35,000 9,356

6832

Revenues from Intermediary Sources IDEA - Pass Through 1,516,166 1,409,749 1,495,741 85,992

6910 Rentals

157,948 37,555 50,000 12,445

6920 Contributions and Donations

61,571

• 6941

Tuition from Other Schools - Regular Day

273,384 292,225 234,962 (57,263)

6942 Tuition from Other Schools - Summer School

7,022 40,000 29,891 (10,109)

6990 Refunds and other Miscellaneous Revenue

160,932 39,641 40,000 359

6992 Energy Incentive Rebates

23,585 25,000 25,000

• $ 94,495,217

$ 92,614,667 $ 88,366,312 $ (4,248,355)

State Revenues

2018-2019 Actual 2019-2020 Budget Proposed Final 2020-2021 Budget Change

7110 Basic Ed Subsidy

$ 21,402,563 $ 21,943,222 $ 21,939,692 $ (3,530)

7160 Tuition for Orphans & Private Home Placements

81,185 95,000 80,000 (15,000)

7271 Special Ed Funding

4,908,481 5,190,414 4,897,930 (292,484)

7292 Pre K Counts

678,595 680,000 700,000 20,000

7310 Transportation

2,089,345 1,855,000 2,025,000 170,000

7320 Rental & Sinking Fund Payments

870,691 750,000 750,000

• 7330

Health Services

133,883 125,000 130,000 5,000

7340 State Property Reduction Allocation

3,390,935 3,390,935 3,391,219 284

7361 Safe Schools Grants

50,857

• 7501

Accountability Block Grant

1,029,712 1,029,712 1,029,712

• 7810

Social Security

1,987,683 2,090,979 2,099,159 8,180

7820 Retirement

9,684,908 9,372,505 9,540,882 168,377 $ 46,308,838 $ 46,522,767 $ 46,583,593 $ 60,826

Federal Revenues

2018-2019 Actual 2019-2020 Budget Proposed Final 2020-2021 Budget Change

8514 Title I

$ 1,606,538 $ 1,663,429 $ 1,566,289 $ (97,140)

8515 Title II

265,084 264,792 223,772 (41,020)

8516 Title III

49,664 60,561 59,561 (1,000)

8518 Title IV

58,414 114,201 125,772 11,571

8690 Restricted Federal Grants

3,282

• 8709

CARES - ESSER Grant

• 1,362,131

1,362,131

8710 CARES - PCCD Grant

• 602,942

602,942

8810 Medical Access

491,544 350,000 275,000 (75,000) $ 2,474,526 $ 2,452,983 $ 4,215,467 $ 1,762,484

TotalRevenues

$ 143,278,581 $ 141,590,417 $ 139,165,372 $ (2,425,045)

394,687 376,221 371,611 371,017 372,279 370,135 371,893 375,613 374,248 374,095 381,993 382,596 382,966 367,497 350,000 355,000 360,000 365,000 370,000 375,000 380,000 385,000 390,000 395,000 400,000

2019-2020 BUDGET TOTAL REVENUES $ 141,590,417

LOCAL REVENUES: REAL ESTATE TAXES (WITHOUT RATE INCREASE) $ (2,671,135) INVESTMENT INCOME (500,000) DELINQUENCIES ON TAXIES LEVIED (476,000) ALL OTHERS (601,220) (4,248,355) STATE REVENUES: SPECIAL EDUCATION FUNDING (292,484) TRANSPORTATION 170,000 RETIREMENT REIMBURSEMENT 168,377 ALL OTHERS 14,933 60,826 FEDERAL REVENUES: CARES ACT - ESSER 1,362,131 CARES ACT - PCCD SAFETY GRANT 602,942 ALL OTHERS (202,589) 1,762,484

2020-2021 BUDGET TOTAL REVENUES $ 139,165,372

18 - 19 Actual 19 - 20 Budget 20 - 21 Proposed Final Budget Change 1100 Regular Education 100 Salaries $ 28,221,113 $ 29,622,717 $ 29,139,973 $ (482,744) 200 Benefits 18,877,119 20,473,090 20,204,043 (269,047) 300 Purch Prof & Tech Srvs 524,568 760,500 760,500 400 Purch Property Srvs 2,672 11,109 9,109 (2,000) 500 Other Purchased Srvs 3,028,202 3,224,643 3,321,116 96,473 600 Supplies 700,052 815,620 764,220 (51,400) 700 Property 2,653 800 Other Objects 555 51,356,934 54,907,679 54,198,961 (708,718) 1200 Special Education 100 Salaries 9,336,835 9,346,379 10,931,818 1,585,439 200 Benefits 6,127,653 6,363,970 7,553,620 1,189,650 300 Purch Prof & Tech Srvs 9,808,658 11,589,437 11,133,640 (455,797) 400 Purch Property Srvs 23,493 (23,493) 500 Other Purchased Srvs 6,591,846 6,128,014 5,769,112 (358,902) 600 Supplies 29,540 70,299 70,299 700 Property 13,500 13,500 800 Other Objects 31,894,532 33,535,092 35,471,989 1,936,897 1300 Vocational Education 100 Salaries 608,213 579,256 581,507 2,251 200 Benefits 394,165 395,224 405,862 10,638 300 Purch Prof & Tech Srvs 15,000 15,000 400 Purch Property Srvs 2,900 2,900 500 Other Purchased Srvs 5,215,494 5,351,346 6,302,000 950,654 600 Supplies 46,881 78,144 79,044 900 700 Property 1,000 1,000 800 Other Objects 6,264,753 6,422,870 7,387,313 964,443

18 - 19 Actual 19 - 20 Budget 20 - 21 Proposed Final Budget Change 1400 Other Instr. Programs 100 Salaries 48,218 45,000 45,000 200 Benefits 31,248 51,252 31,435 (19,817) 300 Purch Prof & Tech Srvs 76,817 66,272 102,100 35,828 400 Purch Property Srvs 10,125 500 Other Purchased Srvs 399,087 515,029 364,621 (150,408) 600 Supplies 6,731 8,950 10,950 2,000 700 Property 800 Other Objects 572,226 686,503 554,106 (132,397) 1500 Non Public Programs 100 Salaries 200 Benefits 300 Purch Prof & Tech Srvs 97,664 97,663 97,663 400 Purch Property Srvs 500 Other Purchased Srvs 600 Supplies 6,395 12,040 12,040 700 Property 800 Other Objects 104,059 109,703 109,703 1800 Pre-Kindergarten 100 Salaries 200 Benefits 300 Purch Prof & Tech Srvs 325 100 100 400 Purch Property Srvs 500 Other Purchased Srvs 678,225 678,800 698,800 20,000 600 Supplies 5 1,100 1,100 700 Property 800 Other Objects 678,555 680,000 700,000 20,000

18 - 19 Actual 19 - 20 Budget 20 - 21 Proposed Final Budget Change 2100 Pupil Personnel 100 Salaries 2,640,998 2,724,415 2,755,290 30,875 200 Benefits 1,711,553 1,844,382 1,910,298 65,916 300 Purch Prof & Tech Srvs 75,107 201,005 66,740 (134,265) 400 Purch Property Srvs 500 Other Purchased Srvs 5,696 13,100 12,300 (800) 600 Supplies 39,009 67,216 89,356 22,140 700 Property 800 Other Objects 400 400 4,472,363 4,850,518 4,834,384 (16,134) 2200 Instructional Staff 100 Salaries 2,027,111 2,176,730 2,201,772 25,042 200 Benefits 1,394,241 1,476,629 1,529,318 52,689 300 Purch Prof & Tech Srvs 318,015 266,752 249,252 (17,500) 400 Purch Property Srvs 98,149 118,063 129,220 11,157 500 Other Purchased Srvs 31,016 64,898 64,898 600 Supplies 368,107 379,150 251,575 (127,575) 700 Property 11,600 329,936 267,862 (62,074) 800 Other Objects 100 4,248,339 4,812,157 4,693,897 (118,260) 2300 Administration 100 Salaries 2,900,038 3,169,439 3,082,570 (86,869) 200 Benefits 1,984,731 2,157,337 2,151,059 (6,278) 300 Purch Prof & Tech Srvs 345,491 586,500 586,500 400 Purch Property Srvs 3,200 6,600 6,600 500 Other Purchased Srvs 47,436 173,532 173,532 600 Supplies 64,744 67,071 63,071 (4,000) 700 Property 12,422 10,000 10,000 800 Other Objects 25,884 27,303 27,953 650 5,383,946 6,197,782 6,101,285 (96,497)

18 - 19 Actual 19 - 20 Budget 20 - 21 Proposed Final Budget Change 2400 Pupil Health 100 Salaries 804,920 806,307 838,659 32,352 200 Benefits 521,645 548,019 581,741 33,722 300 Purch Prof & Tech Srvs 12,148 67,379 77,228 9,849 400 Purch Property Srvs 4,800 4,800 500 Other Purchased Srvs 1,293 3,835 4,500 665 600 Supplies 25,791 42,897 42,897 700 Property 2,643 3,000 3,000 800 Other Objects 130 130 130 1,368,570 1,476,367 1,552,955 76,588 2500 Business 100 Salaries 655,779 672,524 684,166 11,642 200 Benefits 424,475 455,133 473,534 18,401 300 Purch Prof & Tech Srvs 400 Purch Property Srvs 123,393 104,810 52,000 (52,810) 500 Other Purchased Srvs 15,446 20,050 20,050 600 Supplies 8,908 4,300 4,300 700 Property 800 Other Objects 3,400 1,775 1,775 1,231,401 1,258,592 1,235,825 (22,767) 2600 Operations 100 Salaries 3,327,485 3,299,406 3,477,277 177,871 200 Benefits 2,156,444 2,235,249 2,290,448 55,199 300 Purch Prof & Tech Srvs 8,974 58,400 36,900 (21,500) 400 Purch Property Srvs 1,677,768 1,564,500 1,764,750 200,250 500 Other Purchased Srvs 485,976 349,880 349,880 600 Supplies 732,294 869,000 1,019,887 150,887 700 Property 36,891 800 Other Objects 11,004 10,440 10,440 8,436,836 8,386,875 8,949,582 562,707

18 - 19 Actual 19 - 20 Budget 20 - 21 Proposed Final Budget Change 2700 Student Transportation 100 Salaries 1,172,468 1,170,378 1,244,065 73,687 200 Benefits 773,434 561,620 590,547 28,927 300 Purch Prof & Tech Srvs 545,387 580,000 580,000 400 Purch Property Srvs 493,584 418,800 418,800 500 Other Purchased Srvs 4,488,695 4,343,468 4,895,520 552,052 600 Supplies 396,696 474,214 474,214 700 Property 800 Other Objects 375 375 7,870,264 7,548,855 8,203,521 654,666 2800 Support Services - Central 100 Salaries 401,168 308,033 189,970 (118,063) 200 Benefits 358,824 220,149 136,159 (83,990) 300 Purch Prof & Tech Srvs 100,067 124,200 160,200 36,000 400 Purch Property Srvs 1,000 1,000 500 Other Purchased Srvs 2,865 19,000 19,000 600 Supplies 193,448 229,907 253,457 23,550 700 Property 800 Other Objects 459 1,359 1,399 40 1,056,831 903,648 761,185 (142,463) 2900 Other Support Services 100 Salaries 200 Benefits 300 Purch Prof & Tech Srvs 400 Purch Property Srvs 500 Other Purchased Srvs 63,402 65,000 65,000 600 Supplies 700 Property 800 Other Objects 63,402 65,000 65,000

18 - 19 Actual 19 - 20 Budget 20 - 21 Proposed Final Budget Change 3200 Student Activities 100 Salaries 549,071 562,522 473,793 (88,729) 200 Benefits 226,014 248,061 210,364 (37,697) 300 Purch Prof & Tech Srvs 113,116 137,303 141,589 4,286 400 Purch Property Srvs 34,669 43,400 49,500 6,100 500 Other Purchased Srvs 41,876 27,100 33,200 6,100 600 Supplies 115,902 138,852 134,022 (4,830) 700 Property 24,367 17,441 4,938 (12,503) 800 Other Objects 36,222 52,525 52,955 430 1,141,237 1,227,203 1,100,361 (126,842) 3300 Community Services 100 Salaries 200 Benefits 300 Purch Prof & Tech Srvs 1,022 400 Purch Property Srvs 500 Other Purchased Srvs 114,211 115,000 115,000 600 Supplies 23,929 24,989 24,989 700 Property 800 Other Objects 139,162 139,989 139,989 5100 Debt Service 800 Other Objects 7,169,926 6,663,918 6,342,407 (321,511) 900 Other Uses of Funds 3,273,995 3,765,503 3,935,224 169,721 10,443,921 10,429,421 10,277,631 (151,790) 5200 Interfund Transfers - Out 1,106,921 1,106,921 5900 Budgetary Reserve 800 Other Objects 150,000 150,000 150,000 150,000

Totals $ 137,834,252 $ 143,788,255 $ 146,487,687 $ 2,699,431

2019-2020 FINAL BUDGET TOTAL EXPENDITURES $ 143,872,700 SPEICAL EDUCATION 1,064,158 HEALTH CARE COSTS 932,375 TECHNICAL HIGH SCHOOL TUITION 700,000 PENSION EXPENSE 399,202 CHARTER SCHOOL TUITION 186,095 ALL OTHER BUDGETED DISTRICT COSTS (666,843) 2019-2020 FINAL BUDGETED TOTAL EXPENDITURES $ 146,487,687

* RETIREMENT TO BE OFFSET BY STATE CONTRIBUTION OF $199,601, NET COST $199,601

$- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 PENSION SPECIAL EDUCATION (NON-SALARY) CHARTER SCHOOLS HEALTH CARE COSTS DEBT SERVICE

$6,847,423 $7,851,973 $8,966,453 $10,855,444 $11,875,419 $13,149,051 $14,190,123 $14,593,389 $2,663,007 $3,156,417 $2,963,691 $2,561,682 $3,075,709 $3,363,695 $3,776,127 $3,122,704 $21,529,893 $22,959,433 $27,973,703 $29,528,201 $32,900,730 $34,288,244 $36,406,732 $37,578,949 2012 2013 2014 2015 2016 2017 2018 2019

Funding for State Mandated Costs: TOTAL

State Funded Federal Funded Local R/E Tax Funded

TOTAL EXPENSE $$$

TOTAL MANDATED COSTS

School District 2019-2020 Real Estate Mills Median Assessment Median Tax Bill Bensalem Township SD 162.8340 22,595 3,679 Bristol Borough SD 154.0000 16,400 2,526 Bristol Township SD 220.1400 17,600 3,877 Centennial SD 144.2716 26,400 3,809 Central Bucks SD 124.1000 37,480 4,964 Council Rock SD 126.3010 38,880 4,901 Morrisville Borough SD 219.8249 18,400 4,045 Neshaminy SD 163.1000 27,200 4,499 New Hope-Solebury SD 102.3418 54,040 5,545 Palisades SD 115.0000 34,280 3,957 Pennridge SD 135.2550 30,880 4,166 Pennsbury SD 170.0760 28,000 5,454 Quakertown Community SD 168.8300 25,790 4,028

$0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000

Bristol Borough SD $345,706 Bristol Township SD $390,755 Morrisville Borough SD $451,890 Quakertown SD $552,341 Bensalem Township SD $598,660 Pennridge SD $604,477 Pennsbury SD $614,110 Neshaminy SD $640,253 Central Bucks SD $712,863 Centennial SD $714,576 Council Rock SD $846,615 Palisades SD $1,241,916 New Hope-Solebury SD $1,482,228

• 1,000

2,000 3,000 4,000 5,000 6,000

District County 2018-19 tax bill 2019-20 tax bill Chg. 1-yr. chg. 5-yr. chg. 10-yr. chg. Centennial Bucks $3,723 $3,809 $86 2.30% 18% 41% Morrisville Bucks $3,805 $4,045 $240 6.30% 17% 24% New Hope-Solebury Bucks $5,420 $5,545 $125 2.30% 16% 28% Quakertown Bucks $3,922 $4,028 $106 2.70% 15% 30% Pennsbury Bucks $5,373 $5,454 $81 1.50% 11% 14% Council Rock Bucks $4,796 $4,901 $105 2.20% 10% 17% Bristol Township Bucks $3,877 $3,877 $0 0.00% 9% 24% Bensalem Township Bucks $3,597 $3,680 $83 2.30% 9% 22% Neshaminy Bucks $4,400 $4,499 $99 2.30% 7% 7% Pennridge Bucks $4,166 $4,166 $0 0.00% 4% 13% Palisades Bucks $3,933 $3,957 $24 0.60% 4% 11% Bristol Borough Bucks $2,526 $2,526 $0 0.00% 0% 28% Central Bucks Bucks $4,964 $4,964 $0 0.00% 0% 8%

Total Instructional Expenditures Total Expenditures School District Enrollment Per Pupil Rank Per Pupil

Central Bucks SD 18,366.422 $188,117,761.84 $10,242.48

1

$331,977,483.69 $18,075.24 Pennridge SD 7,397.074 $79,031,693.00 $10,684.18

2

$135,131,094.00 $18,268.18 Quakertown Community SD 5,392.159 $63,775,176.39 $11,827.39

3

$104,580,213.22 $19,394.87 Bristol Borough SD 1,400.304 $16,746,831.71 $11,959.43

4

$24,361,679.61 $17,397.42 Neshaminy SD 9,340.138 $113,593,190.77 $12,161.83

5

$183,816,066.67 $19,680.23 Pennsbury SD 10,693.928 $130,336,803.85 $12,187.93

6

$229,775,515.83 $21,486.54 Bristol Township SD 7,371.185 $90,022,487.32 $12,212.76

7

$134,789,438.18 $18,285.99 Bensalem Township SD 7,792.169 $97,687,777.54 $12,536.66

8

$163,325,171.00 $20,960.17 Centennial SD 5,597.716 $72,641,288.95 $12,976.95

9

$117,319,065.51 $20,958.38 Council Rock SD 11,029.890 $149,973,880.15 $13,597.04

10

$235,166,615.00 $21,320.85 Palisades SD 1,615.029 $23,675,997.08 $14,659.80

11

$41,582,919.80 $25,747.48 New Hope-Solebury SD 1,422.864 $21,564,776.12 $15,155.89

12

$38,965,513.13 $27,385.27 Morrisville Borough SD 963.501 $15,628,304.00 $16,220.33

13

$22,633,560.00 $23,490.96

Average 6,799 $81,753,536 $12,802 $135,648,026 $20,958

Total Estimated Revenues $ 139,165,372 Total Estimated Expenditures 146,487,687 Surplus / (Shortage) (7,322,315) Act 1 Property Tax Index - 3.5% 2,939,223 Surplus / (Shortage) with Tax Increase (4,387,258) Total Projected General Fund Balance as of 06/30/20 26,275,124 Projected Reserves with Tax Increase 21,892,032 Projected Reserves without Tax Increase 18,952,809

BUDGET OVERVIEW: FUTURE REVENUES VS. EXPENDITURES

$100,000,000 $110,000,000 $120,000,000 $130,000,000 $140,000,000 $150,000,000 $160,000,000

REVENUES EXPENDITURES