2019-20 Budget Hearing July 22, 2019 Wendy Brockert Director of - PowerPoint PPT Presentation

2019-20 Budget Hearing July 22, 2019 Wendy Brockert Director of Business Services Preparing all of today’s students for tomorrow’s opportunities

Agenda • LMASD Accounting Funds and Functions • Factors Impacting the 2019-20 Budget • Revenue Limit Worksheet • LMASD Revenue and Expense Budget, including Post Employment Benefit Trust • Property Tax

Lake Mills Area School District Fairly Normal School District 2019-2020 2013-2104 Fund Summary Fund Summary Fund 70 Fund Fund 50 Fund 50 Fund 30 27 Fund 20

Budget Impactors • Stable Enrollment Projection • $175 increase per member for Revenue Cap • Per Pupil Aid Allocation increase from $654 to $679 per Member • 1.0 Additional Administrative Position-AP/AD, .5 Additional Recreation Program Staff

Future Budget Adjustments in October 2019 • Per pupil aid increase from $679 to $742 • Additional General Aid which will reduce the tax levy, approximately $350,000 • Update Revenue Limit to reflect actual Sept 2019 enrollment, General Aid certified Oct 15, Equalized Value, Private School Voucher Aid Deduction, Computer State Aid, Personal Property State Aid • Grant and Staffing changes

2019-2020 Revenue Limit Worksheet 1. 2018-19 Base Revenue (Funds 10, 38, 41) (from left) 14,942,519 2. Base Sept Membership Avg (2016+.4ss, 2017+.4ss, 2018+.4ss)/3 (from left) 1,533 3. 2018-19 Base Revenue Per Member (Ln 1 / Ln2) (with cents) 9,747.24 4. 2019-20 Per Member Change (A+B+C) 175.00 A. Allowed Per-Member Change 175.00 B. Low Rev Incr (Enter DPI Adjustment) 0.00 C. Low Rev Dist in CCDEB (Enter DPI Adjustment) 0.00 5. 2019-20 Maximum Revenue / Member (Ln 3 + Ln 4) 9,922.24 6. Current Membership Avg (2017+.4ss, 2018+.4ss, 2019+.4ss)/3 (from left) 1,537 7. 2019-20 Rev Limit, No Exemptions (Ln7A + Ln 7B) (rounded) 15,250,483 A. Max Rev/Memb x Cur Memb Avg (Ln 5 x Ln 6) 15,250,483 B. Hold Harmless Non-Recurring Exemption 0 8. Total 2019-20 Recurring Exemptions (A+B+C+D+E) (rounded) 0 A. Prior Year Carryover 0 B. Transfer of Service 0 C. Transfer of Territory/Other Reorg (if negative, include sign) 0 D. Federal Impact Aid Loss (2017-18 to 2018-19) 0 E. Recurring Referenda to Exceed (If 2019-20 is first year) 0 9. 2019-20 Limit with Recurring Exemptions (Ln 7 + Ln 8) 15,250,483 10. Total 2019-20 Non-Recurring Exemptions (A+B+C+D+E+F+G+H+I) 91,754 A. Non-Recurring Referenda to Exceed 2019-20 Limit 0 B. Declining Enrollment Exemption for 2019-20 (from left) C. Energy Efficiency Net Exemption for 2019-20 (see pg 4 for details) 0 D. Adjustment for Refunded or Rescinded Taxes, 2019-20 0 E. Prior Year Open Enrollment (uncounted pupil[s]) 0 F. Reduction for Ineligible Fund 80 Expenditures (enter as negative) 0 G. Environmental Remediation Exemption 0 H. WPCP and RPCP Private School Voucher Aid Deduction 91,754 I. SNSP Private School Voucher Aid Deduction 0 11. 2019-20 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 15,342,237

11. 2019-20 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 15,342,237 12. Total Aid to be Used in Computation (12A + 12B + 12C + 12D) 8,023,854 A. 2019-20 October 15 Aid Certification → Cell is locked. 7,962,607 B. State Aid to High Poverty Districts (not all districts) 0 C. State Aid for Exempt Computers (Source 691) 8,229 D. State Aid for Exempt Personal Property (Source 691) 53,018 REMEMBER TO USE THE OCTOBER 15 AID CERTIFICATION WHEN SETTING THE DISTRICT LEVY. 13. Allowable Limited Revenue: (Line 11 - Line 12) 7,318,383 (10, 38, 41 Levies) 14. Total Limited Revenue To Be Used (A+B+C) 7,318,383 Not >line 13 Entries Required Below: Enter amnts needed by purpose and fund: A. Gen Operations: Fnd 10 Src 211 6,951,183 (Proposed Fund 10) B. Non-Referendum Debt (inside limit) Fund 38 Src 211 217,200 (to Budget Rpt) C. Capital Exp, Annual Meeting Approved: Fund 41 Src 211 150,000 (to Budget Rpt) 15. Total Revenue from Other Levies (A+B+C+D) 2,890,859 A. Referendum Apprvd Debt (Fund 39 Debt-Src 211) 2,690,859 B. Community Services (Fund 80 Src 211) 200,000 (to Budget Rpt) C. Prior Year Levy Chargeback for Uncollectible Taxes (Src 212) 0 (to Budget Rpt) D. Other Levy Revenue - Milwaukee & Kenosha Only 0 (to Budget Rpt) 16. Total Fall, 2019 ESTIMATED All Fund Tax Levy (14A + 14B + 14C + 15) 10,209,242 Levy Rate = 0.00986146 Line 16 is the total levy to be apportioned in the PI-401.

BUDGET ADOPTION 2019-20* Audited Unaudited Budget GENERAL FUND (FUND 10) 2017-18 2018-19 2019-20 Beginning Fund Balance (Account 930 000) 4,070,982.61 4,134,118.36 4,561,692.93 Ending Fund Balance, Nonspendable (Acct. 935 000) 0.00 0.00 0.00 Ending Fund Balance, Restricted (Acct. 936 000) 0.00 0.00 0.00 Ending Fund Balance, Committed (Acct. 937 000) 0.00 0.00 0.00 Ending Fund Balance, Assigned (Acct. 938 000) 0.00 0.00 0.00 4,134,118.36 0.00 0.00 Ending Fund Balance, Unassigned (Acct. 939 000) TOTAL ENDING FUND BALANCE (ACCT. 930 000) 4,134,118.36 4,561,692.93 4,161,692.93 REVENUES & OTHER FINANCING SOURCES 100 Transfers-in 0.00 0.00 0.00 Local Sources 210 Taxes 6,464,623.61 6,692,467.68 7,009,183.00 240 Payments for Services 21,716.30 26,257.50 15,000.00 260 Non-Capital Sales 9,429.00 8,900.00 500.00 270 School Activity Income 42,074.15 34,647.75 38,000.00 280 Interest on Investments 8,653.88 9,504.48 8,000.00 193,808.67 182,965.94 88,000.00 290 Other Revenue, Local Sources Subtotal Local Sources 6,740,305.61 6,954,743.35 7,158,683.00 Other School Districts Within Wisconsin 310 Transit of Aids 15,012.14 20,177.90 0.00 340 Payments for Services 883,783.00 908,190.26 996,000.00 380 Medical Service Reimbursements 0.00 0.00 0.00 0.00 0.00 0.00 390 Other Inter-district, Within Wisconsin 898,795.14 928,368.16 996,000.00 Subtotal Other School Districts within Wisconsin Other School Districts Outside Wisconsin 440 Payments for Services 0.00 0.00 0.00 0.00 0.00 0.00 490 Other Inter-district, Outside Wisconsin 0.00 0.00 0.00 Subtotal Other School Districts Outside Wisconsin Intermediate Sources 510 Transit of Aids 4,427.00 4,081.61 0.00 530 Payments for Services from CCDEB 0.00 0.00 0.00 540 Payments for Services from CESA 6,750.71 0.00 0.00 580 Medical Services Reimbursement 0.00 0.00 0.00 0.00 0.00 0.00 590 Other Intermediate Sources Subtotal Intermediate Sources 11,177.71 4,081.61 0.00

State Sources 610 State Aid -- Categorical 74,055.16 75,074.07 68,500.00 620 State Aid -- General 8,037,009.00 7,962,607.00 7,962,607.00 630 DPI Special Project Grants 32,711.63 62,605.30 0.00 640 Payments for Services 0.00 0.00 0.00 650 Student Achievement Guarantee in Education (SAGE Grant) 0.00 0.00 0.00 660 Other State Revenue Through Local Units 7,750.00 7,672.39 7,800.00 693,834.39 1,167,784.29 1,104,870.00 690 Other Revenue 8,845,360.18 9,275,743.05 9,143,777.00 Subtotal State Sources Federal Sources 710 Federal Aid - Categorical 0.00 0.00 0.00 720 Impact Aid 0.00 0.00 0.00 730 DPI Special Project Grants 34,661.02 32,852.78 18,500.00 750 IASA Grants 127,209.01 98,294.87 95,000.00 760 JTPA 0.00 0.00 0.00 770 Other Federal Revenue Through Local Units 0.00 0.00 0.00 780 Other Federal Revenue Through State 14,721.37 36,782.08 0.00 0.00 0.00 0.00 790 Other Federal Revenue - Direct 176,591.40 167,929.73 113,500.00 Subtotal Federal Sources Other Financing Sources 850 Reorganization Settlement 0.00 0.00 0.00 860 Compensation, Fixed Assets 500.00 1,400.00 0.00 870 Long-Term Obligations 0.00 50,067.75 0.00 500.00 51,467.75 0.00 Subtotal Other Financing Sources Other Revenues 960 Adjustments 1,230.77 0.00 0.00 970 Refund of Disbursement 77,620.57 227,593.49 30,000.00 980 Medical Service Reimbursement 0.00 0.00 0.00 1,291.82 505.00 0.00 990 Miscellaneous Subtotal Other Revenues 80,143.16 228,098.49 30,000.00 16,752,873.20 17,610,432.14 17,441,960.00 TOTAL REVENUES & OTHER FINANCING SOURCES

General Fund Revenues $30,000.00 $113,500.00 $1,181,170.00 $6,951,183.00 $7,962,607.00 $207,500.00 $996,000.00 Property Taxes Local Sources School Districts Within Wisconsin General Aid Other State Sources Federal Sources Other Revenues

Fund 10 Instructional Expenses EXPENDITURES & OTHER FINANCING USES Instruction 110 000 Undifferentiated Curriculum 2,443,963.91 2,346,899.38 2,488,902.00 120 000 Regular Curriculum 3,503,832.59 3,731,551.37 3,765,270.00 130 000 Vocational Curriculum 640,224.97 573,518.52 525,414.00 140 000 Physical Curriculum 372,223.07 362,923.22 349,343.00 160 000 Co-Curricular Activities 317,387.35 329,871.50 317,385.00 55,238.33 74,185.96 76,657.00 170 000 Other Special Needs 7,332,870.22 7,418,949.95 7,522,971.00 Subtotal Instruction $317,385.00 $76,657.00 $349,343.00 $525,414.00 $2,488,902.00 $3,765,270.00 110 000 Undifferentiated Curriculum 120 000 Regular Curriculum 130 000 Vocational Curriculum 140 000 Physical Curriculum 160 000 Co-Curricular Activities 170 000 Other Special Needs