Shawano School District 2016-17 Budget Community Budget Meetings - PowerPoint PPT Presentation

Shawano School District 2016-17 Budget Community Budget Meetings August 31 & September 6

August 31, 2016 – Public presentation of 2016-17 Budget (HS Auditorium) September 6, 2016 – Public presentation of 2016-17 (HS Auditorium) September 16, 2016 – Third Friday in September count date (for revenue cap purposes) September 17, 2016 – Middle School Open House (10 am to 2 pm) September 19, 2016 - Shawano School District Annual Meeting (Middle School) October 1, 2016 – Equalized valuation received from the Department of Revenue October 14 or 17, 2016 – Equalized Aid Determined by the DPI October 14 or 17, 2016 – Final Revenue Limit Determined by the DPI October 19, 2016 - Finance Committee meeting to determine final levy and budget to be presented to BOE October 24, 2016 – Regular Board meeting – Approve 2016-17 Budget and final levy By November 6, 2016 – Tax levy certificates (for 16-17 school year) sent to each municipality within the district.

Key Variables in School Finance • ***Equalized Aid*** • ***Revenue Limits*** • State pot of money • 3 rd Friday in September • Prior year Sept. & January • 3 year rolling average Membership • Property Values • How much we spend (aka • Under levying or levying shared cost) the maximum allowable • How much other districts • Per Pupil $$ Increase spend • Equalization Aid • Property Values • Debt Service

What we have done in preparation of the 2016-17 Budget • Presenting the 16-17budget based on assumptions and estimates both locally and at the state level (DPI) • Presenting a balanced general fund budget • Health insurance change in 15-16. The gift that keeps giving! By changing our plan, our rates are far below what they would have been had we stayed self funded. • The current state budget was beneficial for Shawano because: a. We have stable enrollment b. Levied the maximum limit in 2015-16 AND spent $500,000 of it on the MS remodel. • Per Pupil Aid was increased to $250 per pupil (from $150)and with a stable or growing enrollment, means more money. • Establish Fund 46 to address future maintenance needs

What we know and don’t know (at this point) What we know: • Health and dental rates - 7.9% premium increase on health insurance • 0% increase on dental premiums • Wage increases for all staff have been determined • Transportation contract • Both food service and cleaning service vendors are contracted What we are uncertain of: • Third Friday count – anticipating growth • District property values • Open enrollment numbers – Students in, out and Special Education • What other districts spent in 15-16 (impacts equalization aid) • The impact of end of year audit entries – OPEB, June expenditures, what is allowed and not allowed

2779 2807 2867 2920 2937 2929 Enrollment Trends 2927 2927 1994-2016 2927 2918 2940 2872 2843 2529 2447 2491 2456 2422 2411 2500 2426 2448

DISTRICT: 2016-2017 Revenue Limit Worksheet DATA AS OF 7/5/2016 7:25 AM 1. 2015-16 Base Revenue (Funds 10, 38, 41) (from left) 23,568,814 Line 1 Amount may Not Exceed Line 11 - (Line 7B+Line 10) of Final 15-16 Revenue Limit 2. Base Sept Membership Avg (13+.4ss, 14+.4ss, 15+.4ss/3) (from left) 2,451 2015-16 General Aid Certification (15-16 Line 12A, src 621) + 13,468,129 3. 2015-16 Base Revenue Per Member (Ln 1 / Ln2) (with cents) 9,616.00 2015-16 Computer Aid Received (15-16 Line 17, Src 691) + 31,358 4. 2016-17 Per Member Change (A+B+C) 0.00 2015-16 Hi Pov Aid (15-16 Line 12B, Src 628) + 166,808 A. Allowed Per-Member Change 0.00 2015-16 Fnd 10 Levy Cert (15-16 Line 18, Levy 10 Src 211) + 10,295,632 B. Low Rev Incr (( 9,100 - (3 + 4A))-4C) Not < 0 0 2015-16 Fnd 38 Levy Cert (15-16 Line 14B, Levy 38 Src 211) + 0 C. Low Rev Dist in CCDEB (Enter DPI Adjustment) 2015-16 Fnd 41 Levy Cert (15-16 Line 14C, Levy 41 Src 211) + 0 5. 2016-17 Maximum Revenue / Member (Ln 3 + Ln 4) 9,616.00 2015-16 Aid Penalty for Over Levy (15-16 FINAL Rev Limit Wksh - 0 6. Current Membership Avg (14+.4ss, 15+.4ss, 16+.4ss/3) (from left) 2,448 2015-16 Total Levy for All Levied Non-Recurring Exemptions* - 393,113 7. 2016-17 Rev Limit, No Exemptions (Ln7A + Ln 7B) (rounded) 23,568,814 *NET Base Revenue Built from 15-16 Data (Line 1) = 23,568,814 A. Max Rev/Memb x Cur Memb Avg (Ln 5 x Ln 6) 23,539,968 B. Hold Harmless Non-Recurring Exemption 28,846 *For 2015-16 Non-Recurring Exemptions Levy Amount, enter actual amount for which district levied; (7B 8. Total 2016-17 Recurring Exemptions (A+B+C+D+E) (rounded) 0 Hold Harmless, Non-Recurring Referenda, Declining Enrollment, Energy Efficiency Exemption, A. Prior Year Carryover 0 Refunded/Rescinded Taxes, Prior Year Open Enrollment Pupils, Reduction for Ineligible Fund 80 Expends, B. Transfer of Service Environmental Remediation, Adjustment for New choice Pupils in 2015-16) C. Transfer of Territory/Other Reorg (if negative, include sign) D. Federal Impact Aid Loss (2014-15 to 2015-16) September & Summer FTE Membership Averages E. Recurring Referenda to Exceed (If 2016-17 is first year) 0 Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%. 9. 2016-17 Limit with Recurring Exemptions (Ln 7 + Ln 8) 23,568,814 Line 2: Base Avg:(13+.4ss)+(14+.4ss)+(15+.4ss) / 3 = 2,451 10.Total 2016-17 Non-Recurring Exemptions (A+B+C+D+E+F+G+H) 267,212 2013 2014 2015 A. Non-Recurring Referenda to Exceed 2016-17 Limit 0 Summer fte: 133 140 123 B. Declining Enrollment Exemption for 2016-17 (from left) 28,848 % (40,40,40) 53 56 49 C. Energy Efficiency Net Exemption for 2016-17 (see pg 4 for details) 0 Sept fte: 2,429 2,372 2,393 D. Adjustment for Refunded or Rescinded Taxes, 2016-17 0 Total fte 2,482 2,428 2,442 E. Prior Year Open Enrollment (uncounted pupil[s]) F. Reduction for Ineligible Fund 80 Expenditures (enter as negative) Line 6: Curr Avg:(14+.4ss)+(15+.4ss)+(16+.4ss) / 3 = 2,448 G. Environmental Remediation Exemption 2014 2015 2016 H. Private School Voucher Aid Deduction per 2015 Act 622 238,364 Summer fte: 140 123 123 11.2016-17 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 23,836,026 % (40,40,40) 56 49 49 12.Total Aid to be Used in Computation (12A + 12B) 14,339,007 Sept fte: 2,372 2,393 2,425 A. JULY 1 General Aid ESTIMATE 14,172,199 B. State Aid to High Poverty Districts (not all districts) Total fte 2,428 2,442 2,474 166,808 THIS IS THE JULY 1 ESTIMATE OF GENERAL AID. REMEMBER TO REPLACE WITH THE OCT 15 CERT. Line 10B: Declining Enrollment Exemption = 28,848 13.Allowable Limited Revenue: (Line 11 - Line 12) 9,497,019 Average FTE Loss ( Line 2 - Line 6, if > 0) 3 (10, 38, 41 Levies + Src 691. Src 691 is DOR Computer Aid.) X 1.00 3 14.Total Limited Revenue To Be Used (A+B+C) 9,497,019 = X (Line 5, Maximum 2016-2017 Revenue per Memb) = 9,616.00 Entries Required Below: Enter amnts needed by purpose and fund: Non-Recurring Exemption Amount: 28,848 A. Gen Operations: Fnd 10 including Src 211 & Src 691 9,497,019 (Proposed Fund 10) B. Non-Referendum Debt (inside limit) Fnd 38 Src 211 (to Budget Rpt) Line 17: State Aid for Exempt Computers = 30,819 C. Capital Exp, Annual Meeting Approved: Fnd 41 Src 211 (to Budget Rpt) Line 17 = A X (Line 16 / C) (to 8 decimals) 15.Total Revenue from Other Levies (A+B+C+D) 3,428,229 Round to Dollar A. Referendum Apprvd Debt (Non Fund 38 Debt-Src 211) 3,242,802 B. Community Services (Fnd 80 Src 211) 185,000 (to Budget Rpt) 2016 Property Values (estimate until Oct '16 values are available) A. 2016 Exempt Computer Property Valuation 3,039,800 C. Prior Year Levy Chargeback for Uncollectible Taxes (Src 212) 427 (to Budget Rpt) Required + B. 2016 TIF-Out Tax Apportionment Equalized Valuation + 1,271,833,060 D. Other Levy Revenue - Milwaukee & Kenosha Only (to Budget Rpt) C. 2016 TIF-Out Value plus Exempt Computers (A + B) = 1,274,872,860 16.Total Levy + Src 691, "Proposed Levy" (Ln 14 + Ln 15) 12,925,248 17.Est Src 691 (Comp Aid) Based on Ln 16 & Values Entered 30,819 Computer aid replaces a portion of proposed Fund 10 Levy Src 691 = Computer Value X (Proposed Levy / (TIF-Out Val + Computer Value)) 18.Fnd 10 Src 211 (Ln 14A-Ln 17), 2016-17 Budget 9,466,200 Line 18 ( not 14A) is the Fund 10 Levy certified by the Board. 19.Total Fall, 2016 All Fund Tax Levy (14B + 14C + 15 + 18 ) 12,894,429 CELL COLOR KEY: Auto-Calc Line 19 is the total levy to be apportioned in the PI-401. Levy Rate = 0.01013846 DPI Data District-Entered

What are all these Funds? • Fund 10 – General Fund – used to operate a school district & normal expenses • Fund 27 – ALL Special Education Expenses and Revenues – must be cost neutral • Fund 38 & 39 - Debt • Fund 46 – Capital Projects Fund – NEW! • Fund 50 – ALL Food Service Expenses and Revenues – Can make money; only used for food service • Fund 80 – Community Education – Adult classes, Open Swim, Community Hockey, etc.

Fund 46 – Why it works for Shawano • Set a 10-year • Allows deposit of EOY maintenance plan; Can dollars to fund change with BOE approval • The EOY deposit is • Open a designated trust AIDABLE even though we account did not spend the money • Cannot withdraw from • Builds a fund for future account for first 5 years capital projects – boilers, windows, sites, other big • Board approves any maintenance projects. changes and reviews at least annually