NORWELL PUBLIC SCHOOLS FY18 Year End Budget Report Financial - - PowerPoint PPT Presentation
NORWELL PUBLIC SCHOOLS FY18 Year End Budget Report Financial - - PowerPoint PPT Presentation
NORWELL PUBLIC SCHOOLS FY18 Year End Budget Report Financial Presentation As of June 30, 2018 Warren MacCallum September 17, 2018 OVERVIEW Periods ending 6/30/17 and 6/30/18 FY'17 FY18 Budget $25,444,860 $26,332,976 Special Ed.
OVERVIEW Periods ending 6/30/17 and 6/30/18
FY'17 FY’18 Budget $25,444,860 $26,332,976 Special Ed. Stabilization $50,000 $50,000 Total Budget $25,494,860 $26,382,976 Total Expenditures $25,494,860 $26,382,783 Percent of Budget 100% 99.99%
FY’18 Major Variances @ June 30, 2018
l
(Tech Replacement Equipment)
l
(Utilities)
l
(Employee Separation)
l
(Out of District Tuitions and Transportation)
l
(Medical Therapeutic)
l
Hiring
l
Grant Management
l
Summer School
l
Professional Development
l
Texts
l
Long Term Leaves
l
Regular Transportation
l
Supplies and Materials
FY’17 to FY’18 Actual Spending Comparison
FY’17 to FY’18 Actual Spending Comparison
FY’17 to FY’18 Actual Spending Comparison
Revolving Accounts Tracking
Commty Rev. Athletics Facilities Transpor- tation Opening Balance 7/1/17 (FY'18) $49,404 $55,061 $25,598 $10,429 Budget Receipts FY'18 $336,000 $325,000 $0 $155,000 Budget Expenditures FY'18 $336,000 $325,000 $0 $155,000 Projected Rollover $49,404 $55,061 $25,598 $10,429 Collected Y-T-D @ 6/30/18 $412,047 $341,166 $66,576 $154,510 Expended Y-T-D @ 6/30/18 $374,386 $340,564 $70,090 $151,523 Funds Available @ 6/30/18 $87,065 $55,663 $22,084 $13,416 FY'19 deposits and fees collected in FY'18 $45,200 $9,750
Circuit Breaker Forecast for FY’19
Special Education O
- n Out of District Tuitions Forecast and Planning Worksheet
Reimbursement % Carryover from Prior Year Receipts Expenditures Balance Rolled over FY’16 FY’17 FY’18 FY’19 FY’20 FY’21 73% 70% 72.1% 75% $ 613,915 498,383 $ 572,486 $ 357,238 $ 5,856 $ 200,856 $ $ 730,548 $ 727,819 850,239 $ 968,618 $ $ 950,000 $ 750,000
- $ 846,080
653,716
- $
1,065,487
- $
1,320,000
- $
755,000
- $
805,000
- $
$ 498,383 572,486 $ 357,238 $ 5,856 $ 200,856 $ 145,856 $ Language Based Program Budget Operational Expenditure Reserve Circuit Breaker ** Budgeted Circuit Breaker With 5th quarter and Ex Relief Circuit Breaker Expenditure Tot Expenditure
** Funds expended from current year circuit
949,607 $ 1,100,000 $ 1,250,000 $ 1,420,000 $ 1,420,000 $ 1,420,000 $ 1,128,922 $ 1,365,274 $ 1,471,649 $ 1,420,000 $ 1,420,000 $ 1,420,000 $ 115,532 $ 155,333 $ 493,001 $ 962,762 $ 749,144 $ 604,144 $ 601,017 $ 498,383 $ 572,486 $ 249,208 $ 5,856 $ 200,856 $ 730,548 $ 498,383 $ 572,486 $ 357,238 $ 5,856 $ 200,856 $ 846,080 $ 653,716 $ 1,065,487 $ 1,320,000 $ 755,000 $ 805,000 $ 1,975,002 $ 2,018,990 $ 2,537,136 $ 2,740,000 $ 2,175,000 $ 2,225,000 $
cuit breaker receipts