Lee’s Summit R-VII School District 2017-18 Annual Budget We prepare each student for success in life. Stansberry Leadership Center 301 NE Tudor Road Lee’s Summit, MO 64086
www.lsr7.org 816.986.1000
ANNUAL BUDGET OF THE LEE’S SUMMIT R-7 SCHOOL DISTRICT JACKSON/CASS COUNTY LEE’S SUMMIT, MISSOURI FOR THE 2017- 2018 FISCAL YEAR
TABLE OF CONTENTS EXECUTIVE SUMMARY Message from the Superintendent .................................................................. 3 Introduction .................................................................................................... 4 Comprehensive School Improvement Plan – CSIP ........................................ 5 District Priorities ............................................................................................. 6 District Overview ............................................................................................ 7 Personnel Resources .................................................................................... 10 Performance Results ..................................................................................... 10 Budget Overview .......................................................................................... 13 Budget Calendar ........................................................................................... 14 Fund Accounting ........................................................................................... 15 Budget Considerations for 2017-18 ............................................................... 16 Revenue ....................................................................................................... 16 Expenditures ................................................................................................. 18 Budget Schedules ......................................................................................... 22 Fund Balance ................................................................................................ 34 Budget Forecast ............................................................................................ 34 Property Taxes ............................................................................................. 35 Board Members and Administrators ............................................................. 37 Meritorious Budget Award ............................................................................. 38
ORGANIZATIONAL SECTION Mission Statement ....................................................................................... 40 District Entity ................................................................................................. 41 Size and Scope ............................................................................................ 41 Reporting ...................................................................................................... 42 Governance ................................................................................................. 43 About the School Board ............................................................................... 44 Board Members ............................................................................................ 45 District Administrators .................................................................................. 46 Organizational Chart ..................................................................................... 47 District Map ................................................................................................... 48 School Information ....................................................................................... 49 Comprehensive School Improvement Plan – CSIP ...................................... 51 Measurement Basis of Accounting ......................................................................... 54 Classification of Revenue and Expenditures ................................................ 54 Classification of Revenue by Object ............................................................. 55 Classification of Expenditures by Fund ......................................................... 57 Classification of Expenditures by Function ................................................... 58 Classification of Expenditures by Object ....................................................... 59 The Budget Process. ................................................................................................ 60 Budget Alignment ......................................................................................... 61 Budget Planning ............................................................................................ 61 Budget Calendar .......................................................................................... 62 Budget Adoption ........................................................................................... 63 Financial Accountability ................................................................................ 64 Local Revenue Sources ............................................................................... 65
i
Summary of Significant Accounting Policies ............................................................. 66 Reporting Entity ............................................................................................ 66 Fund Accounting ........................................................................................... 66 Basis of Accounting ...................................................................................... 68 Inventories ................................................................................................... 68 Cash and Temporary Investments ................................................................ 68 Taxes ............................................................................................................ 69 Changes in Long Term Debt ........................................................................ 69 Employee Compensation ............................................................................. 69 Pension Plans .............................................................................................. 69 Deferred Compensation Plan ........................................................................ 69 Post-Employment Benefits ........................................................................... 70 Insurance Program ....................................................................................... 70
FINANCIAL SECTION Significant Revenue Sources........................................................................ 72 Revenue ............................................................................................. 73 Revenue Forecast ............................................................................... 74 Significant Expenditure Categories............................................................... 75 Expenditures ........................................................................................ 75 Expenditure Forecast ........................................................................... 78 Budget Schedules Combined District Funds .................................................................... 79 General (Incidental) Fund ................................................................... 81 Restricted Insurance Fund ................................................................. 81 Teachers (Special Revenue) Fund ..................................................... 83 Debt Service Fund .............................................................................. 84 Bond Fund ........................................................................................... 86 Capital Projects Fund ......................................................................... 87 Long Range Capital Improvement Plan ...................................... 89 Nutrition Services Fund ...................................................................... 90 Before and After School Services Fund ............................................. 91 Student Activity Fund ......................................................................... 92 Fund Balance/Fund Balance Forecast ........................................................... 93 INFORMATIONAL SECTION Assessed Valuation ................................................................................................. 95 Property Tax Rate Calculation ................................................................................. 95 Property Taxes ........................................................................................................ 95 Assessed Valuation / Market Value .............................................................. 96 Property Tax Market Value Estimations ....................................................... 98 Property Tax Levy and Collections ............................................................. 100 Alternative Tax Collections ......................................................................... 100 Enrollment History and Projections ... ..................................................................... 101 Applied Economics Projection Scope........................................................... 101 Applied Economics Process ........................................................................ 102 Applied Economics Conclusions .................................................................. 103 Program Capacity and Enrollment Estimates ............................................. 104
ii
Budget Allocations 2017-18 .................................................................................... 105 Building Allocations ..................................................................................... 106 Equipment Allocations ................................................................................. 112 Budget Allocation Summary ....................................................................... 113 Debt Service ........................................................................................................... 114 Debt Service/Lease Principal and Interest ................................................... 114 Detail of Outstanding Bonds/Lease Purchase .............................................. 115 Projects Funded by General Obligation Bonds............................................. 116 Highly Qualified Staff .............................................................................................. 118 Staffing History Summary (FTE) ................................................................. 118 Degrees of Certified Staff ........................................................................... 119 Professional Staff with Advanced Degrees .................................................. 119 Years of Experience Professional Staff ....................................................... 120 Staff Retention ............................................................................................ 120 Key Student Performance Indicators ...................................................................... 121 ACT .............................................................................................................. 121 Drop-out/Free-Reduced Meals ...................................................................... 122 Graduates/Student Attendance Rate ............................................................ 123 MAP Results ................................................................................................. 124 School Calendar 2017-18 ....................................................................................... 125 Glossary ................................................................................................................ 126
iii
A special THANK YOU to the exceptionally talented R-7 students and staff for sharing their artwork featured throughout the budget.
EXECUTIVE SUMMARY
Lilly W., Lee's Summit High School
Courtney M., Lee's Summit High School
The Executive Summary is the first major section of the school budget document. It highlights important information contained within the budget. Users may rely on this section for an overview-summary of the entire budget document.
1
2
SUPERINTENDENT’S MESSAGE Dear Lee’s Summit R-7 Community, Our district’s 2017-18 budget was developed with the input of a number of R-7 employees and community groups as well as being reviewed and approved by our Board of Education. The goal of this budget is to support our district’s mission: To prepare each student for success in life. To help ensure that student success is at the heart of our budget, we maintain a constant focus on financial planning and good stewardship of our district’s resources. Our district continues to grow in enrollment with our student count reaching 18,157 for 2017-18. This is a 230-student jump over our previous year’s enrollment and continues an ongoing growth trend. Planning to meet the needs of our increasing student population is an important aspect of this budget as well as our district’s Comprehensive Facility Master Plan. Dr. Dennis Carpenter, Superintendent of Schools
The Lee’s Summit R-7 budget is also aligned to our Board of Education’s priorities for this school year. The three priorities include student achievement, learning environments and communication. They are listed below. 1. Increase the learning and achievement of every child through the development of a comprehensive academic framework informed by the needs of our students, the district’s strategic plan and the 2016 Academic Systems Review. 2. Ensure equitable access to 21st century learning environments by engaging stakeholders in a process to update the district’s Comprehensive Facility Master Plan to meet the instructional and programming needs of all pre-K-12 students. 3. Strengthen public trust in the district’s governance leadership team by systemically enhancing communication, involvement and collaboration to ensure constructive engagement within the school district community. This budget publication is designed to help our district be more transparent by providing readily available financial information in an understandable format. I appreciate your interest in our district and our annual budget. Our involved families and supportive community members are truly the foundation of our district’s success, and we greatly appreciate you. Yours in the work,
Dennis L. Carpenter, Ed.D. Superintendent
3
INTRODUCTION The following document represents the Annual Budget for the Lee’s Summit R-7 School District (District) for the fiscal year, beginning on July 1, 2017 and ending on June 30, 2018. For compliance with state law and local best practice to provide transparent and useful financial information, it is the District’s responsibility to develop an annual budget for approval by the Board of Education. Budgeting is a continual process involving community stakeholders, staff, site and department leadership, administration, and the Board of Education. The purpose of this document is to provide a planning mechanism for District leadership consistent with the District’s mission, vision, commitments and comprehensive school improvement plan (CSIP-Destination 2021).
MISSION We prepare each student for success in life.
VISION Lee’s Summit R-7 is an exemplary school district, graduating students who are college and career ready with the competitive advantage necessary to be successful. Lee’s Summit R-7 reflects a culture of respect and acceptance. Collaboration is an expectation that fosters mutual understanding and a focus on student achievement and staff development. Lee’s Summit R-7 encourages innovation and creativity, recognizing student learning as our fundamental purpose.
COMMITMENTS We commit to: Engaging students in research-based programs in a technology-rich environment. Embracing open, honest two-way communication. Promoting continuous improvement through data-driven decision-making. Sustaining positive relationships among students, staff, families and community members. Ensuring a rigorous and relevant learning experience that leads to success for each student. Partnering with students in identifying and achieving their learning goals. Continuing a safe and caring environment.
4
DESTINATION 2021 - COMPREHENSIVE SCHOOL IMPROVEMENT PLAN The Lee’s Summit R-7 Comprehensive School Improvement Plan or CSIP provides a guide for our school district with its major emphasis on student achievement. Developed by a community team and approved by the Board of Education, the CSIP focuses on five areas — governance; student performance; highly qualified staff; facilities, support and instructional resources; and parent and community involvement. The five-year plan includes a number of components to guide all efforts, includes goals and tasks to improve, enhance accountability and is also part of the district’s evaluation process through the State of Missouri. The 2017-18 school year is the second year of the District’s most recently developed CSIP – Destination 2021. The five areas of the CSIP, including the goals for each focus area are listed below including the 2017-18 budget allocation by goal. Governance • Goal One: Vision and Accountability: In collaboration with administration, the Board will establish and monitor annual goals for student achievement and instruction, as well as efficient and effective operations and fiscal planning. • Goal Two: Policy and Community Leadership: Through collaboration among the board and administration; establish and maintain policies and procedures that create a foundation for maximizing student achievement and managing district resources effectively. • Goal Three: Board and Superintendent Team: The Board and Superintendent will respectively govern and administer the school district in a collaborative manner that leads to a positive impact on student achievement and efficient and effective operations. 2017-18 Budget Allocation: $24,295 Student Performance • Goal One: Each student will be provided a personalized learning experience that creates student ownership of learning thereby demonstrating growth in student achievement. 2017-18 Budget Allocation: $1,045,970 • Goal Two: The District will increase student connectedness and engagement to the school experience. 2017-18 Budget Allocation: $2,280,000 • Goal Three: Students will demonstrate academic achievement as measured by identified targets at the district, elementary and secondary levels. 2017-18 Budget Allocation: $49,500
5
Highly Qualified Staff • Goal One: Attract and retain quality staff while increasing gender and ethnic diversity ten percent each year. 2017-18 Budget Allocation: $7,867,142 • Goal Two: Provide high quality professional learning that prepares each staff member to successfully support an inclusive learning environment. 2017-18 Budget Allocation: $963,233 Facilities, Support and Instructional Resources • Goal One: Develop and evaluate the annual budget for alignment of district resources with the Comprehensive School Improvement Plan, Comprehensive Facilities Master Plan and other budget planning processes to ensure compliance with the Board of Education targeted financial fund balance reserves. 2017-18 Budget Allocation: $90,000 Parent and Community Involvement • Goal One: Increase the number of community members volunteering in individual school and district locations by enhancing relationships and more fully engaging citizens. 2017-18 Budget Allocation: $66,807 • Goal Two: Increase contributions of time, talent and treasure to Lee's Summit R-7 programs and organizations that supplement and support the mission of the school district. • Goal Three: Develop creative global communication vehicles to promote, facilitate and enhance family, community and business engagements. 2017-18 Budget Allocation: $12,000 Additional CSIP information is available at:
http://www.lsr7.org/district/news-publications/
DISTRICT PRIORITIES Annually the Board of Education collaborates with the Superintendent’s Leadership Team to define annual priorities. Building upon the district’s tradition of excellence and continuous improvement in student learning, the Board of Education commits to the following priorities for the 2017-18 school year. 1. Increase the learning and achievement of every child through the development of a comprehensive academic framework informed by the needs of our students, the district’s strategic plan and the 2016 Academic Systems Review. 2. Ensure equitable access to 21st century learning environments by engaging stakeholders in a process to update the district’s Comprehensive Facility Master Plan to meet the instructional and programming needs of all pre-K-12 students.
6
3. Strengthen public trust in the district’s governance leadership team by systemically enhancing communication, involvement and collaboration to ensure constructive engagement within the school district community. These goals align with the focus of the district’s strategic plan. While each Board priority is championed by a member of the Superintendent's Leadership Team with the guidance of the Superintendent, a variety of individuals contribute to the development of recommendations and all work associated with these priorities. The Superintendent’s Leadership Team will provide regular updates to the Board of Education to allow the Board to monitor the work associated with the priorities while also affording the opportunity for Board member inquiry and contribution. The timeline is as follows: Quarterly formal presentations to the Board at Monthly Meeting
Monthly informal updates via Board Update September 22, 2017 November 10, 2017 December 8, 2017 March 9, 2018 May 11, 2018
October 26, 2017 January 18, 2018 April 12, 2018 June 14, 2018
DISTRICT OVERVIEW The Lee’s Summit R-7 School District, in its present form was reorganized when 16 rural elementary districts combined with the Greenwood School District and the Lee’s Summit City School District. When this reorganization occurred in 1949, the newly formed Reorganized School District No. 7 of Jackson County’s enrollment totaled 1,200 students. Today, the District (more commonly known as the Lee’s Summit R-7 School District or just R-7) provides education for approximately 18,157 students in kindergarten through grade 12. The District’s pre-kindergarten early education center will provide services to approximately 359 students for school year 2017-18. The District is an accredited district in Missouri and covers over 117 square miles. The boundaries of the District encompass the communities of Lee’s Summit, Greenwood, Lake Lotawana, and Kansas City, Missouri. The District boundaries incorporate parts of Jackson County, Missouri and a small portion of Cass County, Missouri. The District’s enrollment has shown continued growth during the past ten years. An increase of 230 students is projected for the 2017-2018 school year when compared to the September 2016 student enrollment. The following chart provides actual enrollment, expressed in student headcount, since 2006 and projected enrollment through 2026-27. The district is projected to continue steady student enrollment growth through the 2026-27 school year when total district enrollment is anticipated to reach 20,298 students.
7
K-12 ENROLLMENT - HISTORICAL & PROJECTED 25,000 20,298
20,000
16,734
15,000 10,000 5,000 0
The District’s facilities currently include the following: 18 elementary (grades K-6) schools, three middle (grades 7-8) schools, three high (grades 9-12) schools; one alternative school, one technology center, one special services center and one early childhood center. In addition to these school buildings, the District owns and maintains six support facilities providing administrative, operational and educational services. The following chart shows the K-12 school building sites, with program capacity and projected student enrollment beginning with 2017-18 through the 2026-27 school year.
8
STUDENT ENROLLMENT SCHOOL YEARS 2013-14 TO 2026-27
ELEMENTARY SCHOOLS: Cedar Creek Greenwood Hawthorn Hill Hazel Grove Highland Park Lee's Summit Longview Farm Mason Meadow Lane Pleasant Lea Prairie View Richardson Summit Pointe Sunset Valley Trailridge Underwood Westview Woodland Other TOTAL ELEMENTARY:
100% Program Capacity 658 564 658 493 658 329 658 399 658 634 1,151 658 658 658 658 658 493 658 11,301
Actual Enroll. 2013-14 509 466 547 422 447 307 588 380 546 604 1,002 633 548 476 426 517 386 375 7 9,186
Actual Actual Actual Proj. Proj. Proj. Proj. Proj. Proj. Proj. Proj. Proj. Proj. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 539 534 515 496 480 473 483 486 477 482 499 504 528 469 455 448 432 432 424 394 388 386 397 408 420 438 545 568 542 525 520 525 525 556 563 601 638 682 722 442 440 461 510 546 553 558 586 594 599 604 611 619 503 503 527 544 541 543 551 546 547 559 572 588 605 289 308 293 295 296 288 287 284 277 280 282 285 288 584 589 577 597 601 598 594 596 589 601 608 617 623 412 449 461 482 518 541 573 591 621 650 679 711 735 531 524 543 551 555 557 563 550 540 530 515 503 491 569 576 585 570 540 536 512 487 466 457 447 440 432 937 888 893 892 862 853 846 827 838 825 824 824 824 638 618 630 627 625 612 596 582 574 563 558 555 552 584 596 598 589 589 616 618 610 630 638 649 661 680 466 474 485 470 481 458 447 443 443 444 450 457 464 455 471 473 467 477 498 514 511 510 531 549 563 577 476 488 482 490 489 485 485 493 479 473 470 468 466 350 362 380 391 388 396 402 397 404 397 395 394 394 348 349 355 375 407 426 470 501 539 574 609 648 688 21 18 1 16 14 14 13 14 11 12 11 11 11 9,147 9,215 9,268 9,338 9,377 9,403 9,421 9,445 9,497 9,608 9,750 9,937 10,113
-0.47%
0.02%
0.74%
0.58%
0.76%
0.42%
0.28%
0.19%
0.25%
0.55%
1.17%
1.48%
1.92%
1.77%
1,183 1,061 1,122
922 882 975 12
918 860 971 9
886 823 1,018 15
871 879 1,101 6
895 910 1,121 18
975 879 1,104 18
1,047 912 1,099 18
1,073 911 1,156 17
1,078 938 1,179 16
1,114 944 1,181 18
1,119 933 1,129 18
1,093 938 1,090 16
1,079 927 1,121 16
1,074 935 1,140 16
TOTAL MIDDLE SCHOOL:
3,366
2,791 1.09%
2,758 1.36%
2,742 -0.58%
2,857 4.19%
2,944 3.05%
2,976 1.09%
3,076 3.36%
3,157 2.63%
3,211 1.71%
3,257 1.43%
3,199 -1.78%
3,137 -1.94%
3,143 0.19%
3,165 0.70%
HIGH SCHOOLS: Lee's Summit Lee's Summit North Lee's Summit West Other
2,166 2,166 2,285
1,799 1,912 1,812 130
1,794 1,849 1,898 164
1,778 1,856 1,991 165
1,794 1,902 2,080 26
1,699 1,889 2,118 169
1,746 1,930 2,215 172
1,758 1,943 2,321 172
1,783 2,026 2,406 171
1,862 2,127 2,444 168
1,846 2,236 2,497 167
1,919 2,309 2,504 166
1,931 2,362 2,571 168
1,956 2,366 2,551 167
1,970 2,366 2,518 166
TOTAL HIGH SCHOOL:
6,617
5,705 0.56% 17,610 -3 -0.02%
5,790 1.49% 17,747 137 0.78%
5,802 0.21% 17,927 180 1.01%
5,875 1.26% 18,157 230 1.28%
6,063 3.20% 18,416 259 1.43%
6,194 2.16% 18,673 257 1.40%
6,386 3.10% 18,964 291 1.56%
6,601 3.37% 19,257 293 1.55%
6,746 2.20% 19,500 243 1.26%
6,898 2.25% 19,705 205 1.05%
7,032 1.94% 19,919 214 1.09%
7,040 0.11% 20,120 201 1.01%
7,020 -0.28% 20,298 178 0.88%
MIDDLE SCHOOLS: Bernard Campbell Pleasant Lea Summit Lakes Other
DISTRICT K-12 TOTAL
5,653 1.97% 21,284 17,630 STUDENTS +/30 GROWTH % 0.17%
9
PERSONNEL RESOURCES Personnel costs account for approximately 80% of the District’s operating expenditures. To provide support for the students, the District employs over 2,500 teachers, support personnel and administrators. During the past five years, the Board of Education has demonstrated a commitment to provide staffing to meet the needs of students and District operation. The 2017-18 budget includes an increase of 37.49 FTE (Full Time Equivalent) positions. FIVE-YEAR STAFFING ADDITIONS BY CATEGORY OF POSITION OTHER YEAR ADMINISTRATIVE* TEACHER SUPPORT*** CERTIFIED** 2013-14 1.14 4.50 14.18 9.57 2014-15 1.50 9.39 22.45 18.63 2015-16 1.14 1.42 12.79 14.04 2016-17 5.00 11.54 11.17 3.36 2017-18 1.00 4.00 9.92 22.57 5-Yr. Total 9.78 30.85 70.51 68.17
TOTAL 29.39 51.97 29.39 31.07 37.49 179.31
NOTES: *Ninety-eight percent of total added administrative positions during FY14 to FY18 are school site administrative positions. **Other Certified positions include school counselors, library media specialists, instructional/curriculum specialists, parent educators, behavior coaches, school improvement coordinators, speech/language pathologists, school psychologists, physical or occupational therapists, special services process coordinators. ***Support positions include direct classroom teacher support, student instruction assistance and operational positions in nutrition services, transportation and facilities.
PERFORMANCE RESULTS The Lee’s Summit R-7 School District, a professional learning community, continues efforts to be a leader in the field of public education and has a long-standing tradition of academic excellence. The following achievements highlight this focus on academic excellence.
Mason Elementary students inspire a new $1 million first ever outdoor interactive exhibit, Simple Machines at Play, at Kansas City’s Science City.
10
Summit Lakes Middle School students capture championship in CyberPatriot nationals.
All three high school robotics team quality for national competition, two schools also win first at state-wide competition. Lee’s Summit West High School robotics team wins top international award in China tourney.
Three Lee’s Summit West High School students earned the top score on the ACT.
Thanks to a partnership with the University of Central Missouri, the R-7 School District is opening a groundbreaking new facility in 2017-18. The Missouri Innovation Campus, home to Summit Technology Academy, has received national recognition for reshaping the way students experience education, accelerating the time it takes students to complete a four-year college degree and significantly reducing college debt. The unique programs located at this new school provide students with jobready skills that are highly sought after by business.
Lee's Summit R-7 students scored above state and national averages on the ACT exams. They also scored above the state average in each area tested and each grade level as part of the 2016 Missouri Assessment Program (MAP) tests.
Lee's Summit R-7 is home to three Missouri Teachers of the Year and has had 13 staff members named Teacher of the Year finalist in the state's prestigious program.
A $40 million bond issue was approved by close to 80 percent of school district voters during April 2015. In addition to a new Missouri Innovation Campus, the issue is funding school improvements in the areas of classroom instruction, safety and security, health and wellness, ADA access renovations and special education as well 11
as maintenance projects designed to protect the district’s investment in its schools. Also included are playground safety upgrades for all elementary schools’ soft play areas and replacement of deteriorated play equipment.
Approximately 81 percent of the R-7 Class of 2017 indicated college plans, according to a spring survey of graduates. The Class of 2017, a total of 1,428 graduates, was also offered over $28 million in college scholarship potential.
All three R-7 high schools offer the International Baccalaureate program, a rigorous curriculum only offered in 12 Missouri high schools.
Community, parent and staff contributions to the district remain at a high level through the Lee's Summit Educational Foundation, PTAs and other parent booster organizations.
PROGRAMS
Lee's Summit West Robotics Team in China
OUTSTANDING COMMUNITY SUPPORT & 12
INVOLVEMENTROUND 84% OF20
1 Visit http://dashboard.lsr7.org/student.html for additional student performance data. BUDGET OVERVIEW Missouri state statutes require school districts to prepare an annual budget to provide for the instructional and support operations of the school district. Section 67.010, RSMo., requires an annual budget including components identified in the law. The budget development, implementation, and maintenance process is a year-round process. 13
Beginning in December, budget packets are made available electronically to all budget managers within the District. The budget managers use their budget allocation to enter their proposed budgets into the budget allocation worksheet. In addition, budget managers have the opportunity to request additional human resources, operating funds, technology, and/or capital projects by completing the appropriate non-allocated request. Based on the projected revenues, the expenditure budget may be adjusted taking into account the needs of the schools and input from the Board, school principals, administrative staff, district-wide teams, parents, and other community members before it is presented to the Board in June for approval prior to the new fiscal year. The budget is amended throughout the year, as needed. BUDGET CALENDAR June 1, 2017 → Finance Work Session - Board of Education → 2017-18 Budget Guidelines Review - Superintendent's Leadership Team July - August 2017 → Jackson/Cass Preliminary Assessed Values Provided by County Assessor → Jackson/Cass County Assessor's Office Board of Equalization Assessment Appeals September 2017 → Jackson/Cass Final Assessed Values Provided by County Assessor → Community/Public Tax Rate Hearing and approval of the 2017 Tax Rate - Board of Education → Finance Work Session - Board of Education → 2017 - 18 Amended Budget - Board of Education → Enrollment estimates confirmed for 2017-18 school year October 2017 → 2017-18 Budget enrollment projections and allocation revision December 2017 → Non-Allocated Request process review (Human Resources, Operation, Instruction, Technology, Capital) - SLT January 2018 → 2018-19 Budget Assumptions, demographics and enrollment projections February - March 2018 → Non-Allocated Request approval review (Human Resources, Operation, Instruction, Technology, Capital) - SLT → 2018-19 Preliminary Budget revenues, expenses, fund balances estimates → Finance Winter Work Session - Board of Education → Purchase Order submittal deadline April - May 2018 → TEAM Lee's Summit (Salary, Benefits and Quality of Work Life recommendations) June 2018 → Finance Summer Work Session - Board of Education → Amend the Final 2017-18 Budget - Board of Education → Approve the 2018-19 Preliminary Budget - Board of Education
14
FUND ACCOUNTING Missouri statutes, in conjunction with generally accepted accounting principles (GAAP) and in accordance with the definitions of the Governmental Accounting Standards Board (GASB) statement on principles on fund accounting systems, have been very specific in certain areas of public school finance. These laws prescribe the duties of the treasurer and secretary of the Board of Education, establish specific funds which must be used in the district accounting process, and place certain limits upon the use of revenue and expenditure transactions allowed in these various funds. As a result, the utilization of available money is limited to only the prescribed fund and in the authorized accounting process. For the 2017-18 school year, there have been no significant Board policy or state regulation changes impacting this budget presentation. The Lee’s Summit R-7 School District accounts for revenues and expenditures in nine specific funds, which collapse into five major funds: Incidental, Teachers, Debt Service, Capital Projects and Restricted. Fund Groups for Generally Accepted Accounting Principles General Fund: Incidental Restricted Fund:
State Required Funds:
Nutrition Services Student Activities
Incidental
Before and After School Services Insurance Reserve Special Revenue Fund:
Teachers
Teachers Debt Service Debt Service Fund: Debt Service Capital Projects Fund:
Capital Projects
Capital Projects Bond
Fund 1: Incidental (General) - Used to account for all financial resources except those required to be accounted for in another fund. Transactions are general operating expenditures. Fund 2: Teachers (Special Revenue) - Used to account for revenue legally restricted to certified salaries, health insurance, benefits and out-of-district tuition. Fund 3: Debt Service - Restricted for the accumulation of resources for and the payment of general long-term debt principal, interest and fees. Fund 4: Capital Projects - Restricted to activities related to the acquisition of or construction/remodeling/ renovation of major capital assets/properties and bond expenses. 15
Fund 5: Restricted - Includes Nutrition Services, Before & After School Services, and extracurricular (student activity) accounts for expenditures from non-taxpayer resources. The District’s budget for the 2017-18 fiscal year includes total revenues, expenses and fund balances as a whole and for each of the District funds. Detailed fund schedules provide additional information on the programs within each fund and include comparison information as required by state law as a minimum. The detailed budget schedules provide revenue and expense information consistent with the Missouri Accounting Manual published by the Department of Elementary and Secondary Education (DESE). Revenues are summarized by object and source, while expenses are summarized by fund, function and object.
BUDGET CONSIDERATIONS FOR 2017-18 REVENUE The total revenue budget for 2017-18 is estimated to increase by $4.8 million (2.06%) to a total of $242 million when compared to the 2016-17 revenue projection. The significant operating fund revenue components, which account for slightly over 87 percent of the operating revenue in the 2017-18 budget, are received in the three revenue areas identified below: Local Property Taxes – Increase estimated at $2.5 million (2.9% increase)
Local property tax revenue is recorded in the General, Debt Service and Capital Projects fund, based on the levy apportioned to each fund. The budget includes an estimated total levy of $5.8618, a decrease from the 2016-17 school year. The tax rate was calculated using an assessed valuation of $1,942,772,167, a 6.24 percent increase from the prior year’s certified assessed values. The increase in assessed value is projected to result from increases in new construction, as 2017 is a reassessment year. The new construction increase has been estimated by the District, using housing permit data provided by the City of Lee’s Summit. The District also expects a slight increase in personal property values. The final tax rate will be established, using forms provided by the Missouri State Auditor’s Office, after certified values from Jackson and Cass Counties are provided, prior to October 1, 2017, as required by Missouri Statute.
Local tax collection is budgeted at a rate of 95.5 percent of total taxes assessed. Proposition C Sales Tax – Increase estimated at $401,751 (2.41% increase) The Missouri Department of Elementary and Secondary Education estimates the amount of funding per weighted ADA (WADA) will be approximately $988, an increase of approximately nine dollars per WADA from the prior year. For 201718, the District is budgeting $988 per previous year WADA, which results in a projected increase in this revenue area due to increased student enrollment and an increase in the per student amount. All Proposition C sales tax revenue is recorded in the Teachers Fund. State Basic Formula – Minimal increase estimated at $72,215 (0.10% increase) 16
Basic Formula revenues (including the Classroom Trust Fund) are projected using a State Adequacy Target (SAT) of $6,200. This category of revenue shows a slight increase due to student enrollment growth. The calculation includes a decrease in the dollar value modifier (DVM) from 1.084 in 2016-17 to 1.081 for 2017-18. A total enrollment growth of 230 students (1.28 percent increase from the 2016-17 school year enrollment). The “official” 2017-18 student enrollment number is based on the last Wednesday in September, consistent with reporting to the Missouri Department of Elementary and Secondary Education. All Basic Formula revenue is recorded in the Teachers Fund. Other categories of revenue are estimated based on historical and prior year receipt patterns and District allocations of revenue, impacting the General, Teachers, Capital Projects and Debt Service Funds. Specifically: Other local revenue is budgeted to increase in revenue categories of other taxes and miscellaneous local sources including nutrition services. County increases are indicative of state assessed utility changes. Other state revenues are expected to decrease primarily due to a reduction in state funds available to reimburse for high cost special education students. Federal revenue shows an increase based on the reimbursement from energy grant funds for the purchase of compressed natural gas buses. Revenue in the Nutrition Services Fund is impacted by an increase in student meal prices ranging from five to ten cents. The prices for adult meals increased by 15 cents for regular meals and 50 cents for premier meals. The department is estimating student and adult participation to remain consistent with prior year numbers. Revenue in the BASS Fund is impacted by the number of children participating in programs offered. The BASS program did not increase tuition fees for the 2017-18 school year. It is anticipated the number of children serviced by the program will remain consistent. Revenue in the Student Activity Fund is expected to remain stable, with the exception of a slight reduction due to the elimination of a $10 programming/activity fee for middle and high school students. The graph identifies the percent of revenue for the 2017-18 school year by source of funds.
17
The table below provides a comparison of total revenue for school years FY14 to FY18. TOTAL REVENUE FY14
FY15
FY16
FY17
FY18
ACTUAL
ACTUAL
ACTUAL
PROJECTED
BUDGET
CHANGE FY17 TO FY18 $$$
%%%
LOCAL Property Tax
$105,703,279
$106,771,838
$108,915,185
$113,382,076
Proposition C
$14,831,594
$15,452,501
$15,947,083
$16,680,976
$17,082,727
$401,751
Restricted Funds
$11,660,626
$11,946,943
$12,700,337
$12,472,452
$12,688,464
$216,012
1.73%
Interest Earnings
$4,293,013
$5,446,037
$6,448,880
$2,058,444
$2,053,310
-$5,134
-0.25%
Other Local
$3,659,464
$3,099,483
$3,821,236
$4,896,451
$4,665,818
-$230,633
-4.71%
$140,147,976
$142,716,802
$147,832,721
$149,490,399
$154,130,725 $4,640,326
3.10%
$3,550,918
$3,902,156
$4,023,669
$4,164,239
$4,398,080
$233,841
5.62%
$64,028,163
$66,865,433
$69,130,251
$74,370,267
$73,802,635
-$567,632
-0.76%
$8,025,067
$9,368,116
$8,732,095
$9,251,108
$9,829,460
$578,352
6.25%
$215,752,123
$222,852,506
$229,718,736
$237,276,012
$242,160,900 $4,884,888
2.06%
$29,345,000
$71,780,000
$40,000,000
$0
TOTAL LOCAL TOTAL COUNTY TOTAL STATE TOTAL FEDERAL TOTAL UNRESTRICTED REVENUE BOND SALE/ REFUNDING
$117,640,406 $4,258,330
$0
$0
3.76% 2.41%
0.00%
EXPENDITURES All funds where salary and benefits are recorded are impacted by the salary and benefit changes approved for the 2017-18 school year and listed below, including the following funds: General (Incidental), Special Revenue (Teachers), Nutrition Services, BASS and Student Activity. The budget includes salary and related benefit increases of $5.2 million for District employees. Employee salary schedules base increases are indicated in the table below, employees did not receive step movement for longevity. Schedule
Base Increase
Percent Increase
Administrator Professional Support Teacher
$0.80 per hour $0.59 per hour $0.35 per hour $1,500 annual
3.32% 3.46% 3.46% 3.57%
Salary adjustments provided to District employees earning advanced degrees. Targeted salary increases for extra duty contracts, with non-scheduled salary increases tied to the average total salary increase. The salary impact is estimated at $576,148. A salary schedule was formalized for various types of hourly pay for certified and support staff. In addition, salaries were development for online class instructors and for instructors of college credit courses. The estimated increase to implement this hourly salary schedule equals $182,000. 18
Total district-wide additional net 37.49 FTE staff positions, an estimated cost increase of $1,863,144. The budget impact is offset by redirection of $758,149 in existing resources, resulting in a net budget expense increase of $1,104,995. Benefit increases include a projected eight percent for health insurance for the plan year beginning on January 1, 2018. In addition, the budget includes increases in benefits tied to salary including state-mandated retirement, social security/Medicare, life insurance and disability insurance. Total budgeted expenditures in the operating funds increased by $7.9 million or 4.17 percent from the projected 2016-17 budget due to increases in employee salaries, additional staff, benefits, increases in general instructional materials, supplies and other site operating expenses due to student enrollment growth and operational increases. The increases for expenses other than salary and benefit will impact the General (Incidental) fund. The District budgeted for a $1.5 million decrease in the Operating (combined General and Teachers) fund balance for the year. This decrease will make the projected ending reserve balance 27.74 percent, which remains well above the targeted minimum fund balance of 15 percent. The ending fund balance is equivalent to 3.33 months of operating expenses. The Capital Projects fund budget includes estimated expenses of $7.8 million and includes lease purchase payments for multiple projects approved in prior years. Expenditures include funding for instructional, music and regular equipment budgeted at the site level on a per student allocation. District-wide needs are restricted to funding for the Capital Projects Team, equipment tied to additional staff positions, and funds to repay the lease purchase of technology, compressed natural gas (CNG) school buses, facility site and CNG maintenance vehicles. Funding in the Capital Fund is achieved through the resources provided by a $0.05 levy and a budgeted transfer from the Incidental Fund to the Capital Projects fund. The District was able to address a number of maintenance projects with revenue received from the 2015 bond issue, to preserve and build the fund balance in the Capital Projects fund. During the 2017-18 school year, the process to revise the District’s Comprehensive Facility Master Plan (CFMP) will begin, consistent with the Board of Education’s priority number 2. Updated student demographic data will be received during November 2017 and will be the primary focus for the District’s short term (one to three years) planning to address facility space needs. For the 2017-18 school year, student enrollment uses approximately 85 percent of the district-wide school site capacity. With projected student enrollment increases, facility needs are an immediate concern. To address the board of education’s priority number 2, a CFMP team will be established and will begin addressing identified parameters in terms of 21st century learning spaces. Previously identified major building projects including elementary, middle and high schools are expected to be part of the CFMP team’s planning work. The District currently has two parcels of land designated as future school sites. Funding for the projects identified in the CFMP will be primarily from general obligation bonds.
19
In the Bond Fund, the remaining bond proceeds from the issue approved by voters in April 2015, approximately $5.2 million will be used to complete the remaining projects identified at the election, with the remaining bond proceeds prioritized by the board of education during the 2017-18 school year. The 2017-18 budget includes the balance of the 2015 bond issue resources as a current year expense. The Debt Service Fund expenses for 2017-18 are increased by approximately $41.3 million dollars for a payment related to a prior year refunded bond. The funds to make this payment reside in the Debt Service fund balance. Section 165.011, RSMo, and administrative interpretations provide for several interfund transfers that a school district may make. The 2017-18 budget includes interfund transfers from the General Fund to the Teachers Fund for expenses in the Teachers Fund in excess of current revenue. This transfer is required for statutory compliance since the Teachers Fund has a zero beginning fund balance and statutes require the District to transfer an amount sufficient to cover all expenditures that are not covered by another source of revenue. An interfund transfer is also budgeted from the General Fund to the Capital Projects Fund for expenses not covered by another source of revenue. The annual amount of transfer is capped at a maximum of $162,326 or 7% multiplied by the SAT, multiplied by the WADA. This calculation is performed by DESE and finalized on June 30, 2018. The preliminary transfer amount calculated by DESE for 2017-18 is $7,496,503 with the District budgeting a transfer of $2,641,989 based on the amount of expenses. The table below provides a comparison of total expenses for school years FY14 to FY18.
20
The graph provides the 2017-18 expenditure areas and percent of total budget.
For comparison purposes with other local school districts, the graph includes data collected by the Department of Elementary and Secondary Education on an expense per average daily attendance (ADA) basis. The data from 2015-16 is the latest data available at the time of budget preparation.
21
BUDGET SCHEDULES The following pages present the budget schedules for all budgeted funds within the District. In each schedule, information is presented for the four prior years, the budget year and three projected budget years. The schedules are presented for all funds in the District, followed by the detail for each individual fund.
22
COMBINED ALL DISTRICT FUNDS Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
EXPENDITURES (Continued) School Administration $6,919,066
$7,483,147
$7,822,216
$7,871,414
$8,186,271
$8,372,236
$8,557,662
$8,739,214
Purchased Services
Employee Salaries & Benefits
$88,299
$105,427
$112,774
$119,887
$120,247
$123,290
$128,516
$135,514
Materials & Supplies
$151,710
$142,252
$163,410
$227,546
$228,274
$234,004
$243,875
$257,104
Employee Salaries & Benefits
$4,669,617
$5,491,792
$6,605,758
$6,050,962
$6,293,001
$6,533,075
$6,761,582
$6,965,130
Purchased Services
$1,741,038
$2,108,726
$3,013,910
$4,308,679
$4,321,605
$4,430,233
$4,526,871
$4,602,622
Materials & Supplies
$1,429,753
$347,133
$240,334
$546,621
$548,370
$562,134
$585,848
$617,627
$341,828
$29,218
$86,775
$90,831
$90,849
$90,868
$90,886
$90,904
Equipment Central Services
Equipment Operation and Maintenance
$12,021,294
$12,189,467
$11,895,900
$11,996,157
$12,746,003
$13,291,610
$13,705,597
$14,121,545
Purchased Services
Employee Salaries & Benefits
$1,725,888
$1,990,299
$1,699,314
$3,213,047
$3,222,686
$3,304,233
$3,444,307
$3,631,866
Materials & Supplies
$4,717,709
$4,879,422
$4,248,502
$4,647,766
$4,662,639
$4,779,671
$4,981,301
$5,282,347
Equipment
$1,732,247
$1,769,322
$200,097
$181,194
$181,231
$181,267
$181,303
$181,339
Transportation Services $6,293,263
$6,519,596
$6,719,041
$6,883,647
$7,578,992
$7,730,466
$8,168,807
$8,731,891
Purchased Services
Employee Salaries & Benefits
$857,330
$814,059
$729,578
$895,661
$898,348
$921,080
$960,127
$1,012,410
Materials & Supplies
$965,648
$1,058,066
$1,063,155
$1,280,537
$1,284,635
$1,316,879
$1,372,432
$1,446,880
$1,731,341
$1,805,330
$2,492
$1,695,977
$10,000
$10,250
$10,506
$10,769
$4,319,170
Equipment Nutrition Services
$3,588,533
$3,839,696
$3,917,978
$3,974,747
$4,130,496
$4,192,453
$4,255,340
Purchased Services
Employee Salaries & Benefits
$89,384
$134,476
$118,716
$95,894
$88,700
$90,000
$91,314
$92,647
Materials & Supplies
$2,972,196
$3,080,732
$3,051,366
$2,985,325
$3,357,000
$3,404,669
$3,451,994
$3,503,774
$218,464
$57,192
$63,940
$117,290
$75,000
$76,050
$77,107
$78,264
Equipment Community Services
$3,470,657
$3,853,211
$3,967,858
$3,967,744
$4,106,616
$4,208,116
$4,308,819
$4,406,008
Purchased Services
Employee Salaries & Benefits
$166,184
$273,575
$236,843
$230,852
$231,545
$233,996
$236,265
$238,226
Materials & Supplies
$354,570
$371,593
$324,406
$473,652
$475,167
$483,312
$490,594
$496,429
$61,781
$69,244
$5,040
$5,995
$5,996
$5,997
$5,999
$6,000
$1,226,003
$890,678
$12,077,093
$20,756,121
$6,739,372
$5,325,994
$5,405,884
$5,486,972
$24,101
$53,572
$2,377,995
$1,134,922
$103,400
$100,000
$100,000
$100,000
$100,000
$3,091,375
$60,000
$407,570
$26,518
Equipment Site/Facility Improvements Construction Contracts Equipment Land Purchase Purchased Services Bond and Lease Payments Bond/Lease Principal
$42,441,347
$45,641,448
$41,594,295
$18,667,335
$61,309,985
$18,616,625
$17,082,949
$16,790,108
Bond/Lease Interest
$9,419,234
$8,710,739
$9,162,802
$8,839,664
$8,361,761
$5,693,681
$5,196,996
$4,735,644
$227,575
$443,310
$143,139
$4,292
$10,000
$10,000
$10,000
$10,000
Other Costs TOTAL EXPENDITURES
$237,902,578 $250,078,461 $265,181,306 $255,205,105 $290,098,178 $248,408,119 $251,755,903 $256,549,216
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
ENDING FUND BALANCE
$105,016,182 $112,210,728 $156,764,773 $161,302,203 $143,373,110
$95,435,832
$95,532,552
$99,422,184
-$17,929,093
-$47,937,278
$96,720
$3,889,632
$4,392,271
$112,210,728 $156,764,773 $161,302,203 $143,373,110
$95,435,832
$95,532,552
$7,194,545
$44,554,046
$4,537,430
23
$99,422,184 $103,814,455
GENERAL (INCIDENTAL) FUND The General Fund accounts for general activities or other activities except those required to be accounted for in the Special Revenue, Debt Service or Capital Projects.
GENERAL (INCIDENTAL) FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
REVENUE Local Property Tax
$81,654,664
$82,947,422
$84,155,964
$87,489,707
$90,574,958
$92,602,406
$94,056,920
$95,289,153
Other Tax
$979,583
$1,107,977
$1,796,675
$1,210,031
$2,096,957
$2,028,265
$2,046,519
$2,201,943
Interest
$820,861
$745,036
$708,251
$742,467
$771,700
$784,750
$794,598
$805,000
Other Miscellaneous
$507,795
$2,134,016
$2,317,327
$3,768,420
$3,527,000
$3,894,559
$4,185,316
$4,353,249
County Fines, Forfeitures State Assessed Utility
$12,513
$14,366
$7,217
$2,521,375
$2,758,942
$2,854,670
$2,909,914
$3,056,879
$3,178,727
$3,305,432
$3,437,188
$1,216,823
State Transportation
$1,781,606
$2,059,419
$1,562,476
$1,214,750
$1,215,000
$1,215,608
$1,216,215
Early Special Education
$1,842,843
$2,218,677
$2,883,505
$3,142,525
$930,631
$1,058,593
$1,175,038
$1,233,790
$819,992
$887,494
$777,125
$859,272
$1,055,002
$1,092,536
$1,135,763
$1,371,531
Medicaid/Title/Grants
$1,571,720
$2,448,450
$2,184,658
$1,229,196
$1,144,693
$1,666,424
$1,885,829
$2,122,784
Special Education
$3,351,502
$3,833,313
$3,367,165
$3,156,484
$2,827,794
$2,864,260
$2,885,618
$2,905,880
$1,000
$750
$2,960
$347,288
$532,992
$607,611
$763,309
Other Federal
Other TOTAL REVENUES
$95,864,453 $101,156,112 $102,615,782 $105,725,725 $107,547,902 $110,919,120 $113,294,859 $115,700,650
EXPENDITURES Instructional Services Employee Salaries & Benefits
$10,549,459
$10,700,099
$12,743,198
$12,934,616
$14,377,755
$15,114,336
$15,679,489
$16,143,556
Purchased Services
$2,006,743
$4,591,454
$2,561,556
$2,385,097
$2,378,256
$2,412,455
$2,434,655
$2,445,683
Materials & Supplies
$2,963,152
$2,787,350
$2,966,193
$2,834,130
$2,874,743
$2,922,322
$2,996,429
$3,018,765
$4,964,556
Student Support Services Employee Salaries & Benefits
$3,487,352
$2,983,958
$3,819,873
$4,282,163
$4,472,830
$4,648,970
$4,816,256
Purchased Services
$95,405
$199,297
$254,457
$219,357
$220,015
$225,582
$235,145
$247,950
Materials & Supplies
$142,587
$106,838
$83,936
$106,245
$106,585
$109,260
$113,869
$120,046
Instruction Support Services Employee Salaries & Benefits
$906,673
$597,967
$1,011,638
$1,024,716
$1,081,559
$1,124,150
$1,164,601
$1,200,461
Purchased Services
$582,678
$1,031,377
$786,761
$758,961
$758,417
$773,871
$787,136
$796,082
Materials & Supplies
$706,750
$569,198
$726,333
$781,195
$783,695
$803,366
$837,256
$882,673
Employee Salaries & Benefits
$376,110
$462,815
$451,966
$405,189
$428,663
$445,544
$461,576
$475,789
Purchased Services
$802,734
$684,982
$532,771
$707,566
$752,027
$771,059
$787,989
$801,255
Materials & Supplies
$61,911
$19,955
$20,164
$93,275
$93,573
$95,922
$99,969
$105,391
General Support Services
24
Within the General Fund, the District maintains a “restricted” fund balance, currently a reserve for health insurance future liability tied to the contract termination. For the 201718 school year, the Board of Education approved a transfer of $900,000 from the restricted insurance fund to the General Fund to support the salary improvements.
RESTRICTED INSURANCE FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
REVENUE Local Other TOTAL REVENUES
$1,809,175
$101,785
$760,444
$0
$0
$0
$0
$0
$1,809,175
$101,785
$760,444
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
EXPENDITURES Transfer TOTAL EXPENDITURES
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
$0 $1,809,175 $1,910,960 $2,671,404 $2,671,404 $1,771,404 $1,771,404 $1,771,404 $1,809,175
$101,785
$760,444
Transfer In/(Out)
ENDING FUND BALANCE
$0
$0
$0
$0
$0
-$900,000 $1,809,175 $1,910,960 $2,671,404 $2,671,404 $1,771,404 $1,771,404 $1,771,404 $1,771,404
25
NUTRITION SERVICES FUND The Nutrition Services Fund is a restricted fund within the General (Incidental) fund for state reporting purposes. This fund is used to account for all revenue and expenses associated with providing food services for students. The Nutrition Services program is a self-supporting program and is currently not supplemented with operational funds.
NUTRITION SERVICES FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$4,624,348
$4,632,068
$4,750,074
$4,734,470
$5,140,500
$5,173,222
$5,206,658
$5,240,310
$1,436
$4,263
$10,486
$9,190
$10,000
$10,500
$10,500
$10,500
$68,261
$53,738
$54,457
$86,583
$97,376
$97,493
$97,611
$97,729
Local Food Sales Other Miscellaneous State Breakfast/Lunch Federal Breakfast Program Lunch Program Other TOTAL REVENUES
$407,033
$451,636
$445,020
$586,485
$585,120
$605,872
$627,437
$649,769
$1,723,311
$1,727,319
$1,759,640
$1,846,743
$1,852,880
$1,918,598
$1,986,887
$2,057,603
$2,632
$2,707
$21,142
$3,211
$3,200
$3,500
$3,500
$3,500
$6,827,020
$6,871,732
$7,040,820
$7,266,683
$7,689,076
$7,809,185
$7,932,593
$8,059,411
EXPENDITURES Nutrition Services Employee Salaries & Benef
$3,588,533
$3,839,696
$3,917,978
$3,974,747
$4,130,496
$4,192,453
$4,255,340
$4,319,170
Purchased Services
$89,384
$134,476
$118,716
$95,894
$88,700
$90,000
$91,314
$92,647
Materials & Supplies
$2,972,196
$3,080,732
$3,051,366
$2,985,325
$3,357,000
$3,404,669
$3,451,994
$3,503,774
Equipment TOTAL EXPENDITURES
$218,464
$57,192
$63,940
$117,290
$75,000
$76,050
$77,107
$78,264
$6,868,576
$7,112,095
$7,152,000
$7,173,256
$7,651,196
$7,763,173
$7,875,756
$7,993,855
$2,153,863
$2,112,307
$1,871,943
$1,760,763
$1,854,189
$1,892,069
$1,938,082
$1,994,919
-$41,556
-$240,364
-$111,180
$93,426
$37,880
$46,012
$56,837
$65,556
$2,112,307
$1,871,943
$1,760,763
$1,854,189
$1,892,069
$1,938,082
$1,994,919
$2,060,474
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense ENDING FUND BALANCE
26
BEFORE AND AFTER SCHOOL SERVICES (BASS) FUND The BASS fund is a restricted fund within the General Fund for state reporting purposes. The revenue and expenses for this program are accounted for in the BASS fund. The BASS program is a self-supporting program and is currently not supplemented with operational funds.
STUDENT ACTIVITY FUND The Student Activity Fund, used to account for assets held by the school district in a trustee capacity for student activities is a restricted fund within the General Fund for state reporting purposes.
STUDENT ACTIVITY FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
Local Other Miscellaneous TOTAL REVENUES
$4,205,097
$4,406,687
$4,767,601
$4,701,249
$4,700,000
$4,725,000
$4,748,719
$4,796,206
$4,205,097
$4,406,687
$4,767,601
$4,701,249
$4,700,000
$4,725,000
$4,748,719
$4,796,206
Student Activity Employee Salaries & Benefit $
199,455
$
288,807
$
370,048
$
323,468
$
328,320
$
330,982
$
335,583
$
340,616
Purchased Services
$ 1,535,607
$ 1,700,033
$ 1,778,428
$ 1,739,666
$ 1,740,000
$ 1,750,000
$ 1,764,725
$ 1,775,000
Materials & Supplies
$ 2,435,480
$ 2,442,323
$ 2,512,283
$ 2,604,211
$ 2,581,000
$ 2,599,000
$ 2,601,920
$ 2,641,234
Equipment
$
$
$
$
$
$
$
$
TOTAL EXPENDITURES
87,223
70,781
65,701
103,819
100,000
100,000
100,000
100,000
$4,257,765
$4,501,944
$4,726,460
$4,771,165
$4,749,320
$4,779,982
$4,802,228
$4,856,850
$2,077,803
$2,025,134
$1,929,877
$1,971,019
$1,901,103
$1,851,783
$1,796,801
$1,743,292
-$52,669
-$95,257
$41,141
-$69,915
-$49,320
-$54,982
-$53,509
-$60,644
$2,025,134
$1,929,877
$1,971,019
$1,901,103
$1,851,783
$1,796,801
$1,743,292
$1,682,648
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
ENDING FUND BALANCE
27
TEACHERS (SPECIAL REVENUE) FUND The Teachers (Special Revenue) Fund accounts for expenditures for certificated employees involved in administration and instruction. It includes revenues restricted by the State for the payment of certificated salaries.
SPECIAL REVENUE (TEACHERS) FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$14,831,594
$15,452,501
$15,947,083
$16,680,976
$17,082,727
$17,327,655
$17,766,910
$18,210,556
$542,411
$578,941
$835,716
$865,813
$838,818
$897,535
$960,363
$1,027,588
$114,858
$146,667
$132,317
$194,838
$164,761
$181,237
$199,361
$219,297
$57,404,484
$59,741,574
$62,240,455
$67,239,663
$66,717,189
$69,205,084
$72,150,584
$74,088,161
$373,966
$2,145,780
$2,356,223
$2,615,408
$2,746,178
REVENUE Local Prop C Sales Tax Other Miscellaneous County Fines, Forfeitures State Basic Entitlement Early Special Education Other
$1,993,376
$1,773,822
$1,504,144
$1,328,853
$1,500,000
$1,500,000
$1,495,012
$1,300,000
$186,203
$264,092
$549,308
$1,361,494
$1,823,884
$1,567,230
$1,654,930
$1,774,188
$175,108
$306,600
$289,800
$293,250
$293,940
$90,579,759
$93,324,764
$97,135,818
$99,659,908
Federal Medicaid/Title/Grants Special Education Other
$205
TOTAL REVENUES
$75,073,132
$1,200 $77,957,598
$81,209,023
$88,221,911
EXPENDITURES Instructional Services Employee Salaries & Benefits Purchased Services
$90,323,757
$96,759,751
$1,665,999
$1,392,743
$97,503,197 $100,291,793 $104,988,719 $106,983,504 $109,016,191 $111,087,499 $2,826,545
$2,697,416
$2,724,390
$2,763,077
$2,801,483
$2,843,506
$3,546,989
$3,458,857
$3,528,905
$3,876,201
$4,011,868
$4,088,093
$4,165,767
$4,244,917
$3,096,525
$3,316,157
$3,158,380
$3,170,864
$3,281,844
$3,344,200
$3,407,739
$3,472,486
$363,457
$403,036
$407,067
$412,847
$418,586
$424,865
$1,530,386
$1,453,303
$1,504,168
$1,532,747
$1,561,870
$1,591,545
$500
$500
$500
$500
$500
Student Support Services Employee Salaries & Benefits Purchased Services Instruction Support Services Employee Salaries & Benefits Purchased Services General Support Services Employee Salaries & Benefits
$1,184,727
$1,212,610
Purchased Services School Administration Employee Salaries & Benefits
$5,712,453
$6,136,389
$6,457,873
$6,466,981
$6,693,326
$6,820,499
$6,950,088
$7,082,140
$407,654
$308,970
$311,290
$367,101
$379,950
$387,169
$394,525
$402,021
$12,034
$35,428
$35,782
$36,290
$36,795
$37,347
$187,181
$194,275
$201,075
$204,895
$208,788
$212,755
$1,360
$1,224
$1,300
$1,300
$1,300
$1,300
Central Services Employee Salaries & Benefits Purchased Services Community Services Employee Salaries & Benefits
$41,302
$177,710
Purchased Services TOTAL EXPENDITURES
$105,979,407 $112,763,186 $115,880,609 $118,958,123 $124,229,989 $126,575,121 $128,963,632 $131,400,880
FUND BALANCE Beginning Fund Balance Excess Revenue Over Expense Transfers In/(Out)
ENDING FUND BALANCE
$0
$0
$0
$0
$0
$0
$0
$0
-$30,906,275
-$34,805,589
-$34,671,586
-$30,736,211
-$33,650,230
-$33,250,357
-$31,827,814
-$31,740,972
$30,906,275
$34,805,589
$34,671,586
$30,736,211
$33,650,230
$33,250,357
$31,827,814
$31,740,972
$0
$0
$0
$0
$0
$0
$0
$0
28
CAPITAL PROJECTS FUND Capital expenditure budgeted in the Capital Projects fund include school and program based expenditures, various equipment lease payments, technology, general equipment, school buses and other vehicles, and major facility repairs.
CAPITAL PROJECTS FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
REVENUE Local Property Tax Other Tax Interest Other Miscellaneous
$825,997
$829,505
$865,497
$897,275
$955,070
$973,491
$1,002,696
$1,012,724
$2,016,131
$2,515,629
$2,487,367
$2,512,106
$3,539,445
$3,871,475
$3,916,768
$3,796,110
$14,399
$19,548
$41,362
$34,345
$35,200
$37,205
$39,000
$41,000
$1,026,903
$557,391
$180,147
$418,440
$300,000
$55,000
$53,205
$51,205
$42,802
$45,572
$30,229
$30,782
$54,610
$56,787
$59,050
$61,404
$4,993,958
$5,070,719
$4,962,443
County State Assessed Utility State Other
$594
Federal Medicaid/Title/Grants Other
$153,468
$468,000
$300,000
TOTAL REVENUES
$4,226,233
$400,000 $4,121,113
$3,604,601
$4,293,542
$5,352,325
EXPENDITURES Instructional Services Equipment
$482,060
$414,622
$541,534
$615,995
$693,436
$693,575
$693,714
$693,853
Student Support Services Equipment
$1,495
Instruction Support Services Equipment
$18,740
$54,323
$22,941
$15,090
$15,093
$15,096
$15,099
$15,102
$998,485
$7,183
$15,296
$25,460
$25,465
$25,470
$25,475
$25,480
$341,828
$29,218
$86,775
$90,831
$90,849
$90,868
$90,886
$90,904
$1,732,247
$1,769,322
$200,097
$181,194
$181,231
$181,267
$181,303
$181,339
$1,731,341
$1,805,330
$2,492
$1,695,977
$10,000
$10,250
$10,506
$10,769
$61,781
$69,244
$5,040
$3,925
$5,996
$5,997
$5,999
$6,000
$1,226,003
$653,638
$467,867
$314,006
$1,516,520
$5,037,703
$5,405,884
$5,486,972
$24,101
$43,042
$65,243
$103,400
$100,000
$100,000
$100,000
$2,906,347
$3,101,448
$4,839,295
$4,877,335
$4,784,984
$3,801,625
$3,267,949
$3,195,108
$735,258
$678,468
$586,896
$494,606
$403,986
$313,982
$236,997
$169,845
$10,258,191
$8,625,838
$6,768,233
$8,381,158
$7,830,960
$10,275,832
$10,033,812
$9,975,372
Beginning Fund Balance
$16,372,600
$14,194,526
$13,685,342
$13,687,988
$13,085,059
$13,248,413
$10,740,628
$8,593,234
Excess Revenue Over Expense
-$6,031,958
-$4,504,725
-$3,163,631
-$4,087,615
-$2,478,635
-$5,281,874
-$4,963,093
-$5,012,929
General Support Services Equipment Central Services Equipment Operation and Maintenance Equipment Transportation Services Equipment Community Services Equipment Site and Facility Improvements Construction Contracts Equipment Lease Payments Principal Interest TOTAL EXPENDITURES
FUND BALANCE
Transfers In/(Out)
ENDING FUND BALANCE
$3,853,885
$3,995,541
$3,166,277
$3,484,686
$2,641,989
$2,774,088
$2,815,700
$2,857,935
$14,194,526
$13,685,342
$13,687,988
$13,085,059
$13,248,413
$10,740,628
$8,593,234
$6,438,240
29
2017-18 SITE AND FACILITY IMPROVEMENT DETAILS LOCATION
PROJECT TYPE
BASS BCMS
CAP EQUIP
CCE
CAP
GWE
CAP
HGE
CAP
HHE HHE HPE LFE LSE LSHS
CAP CAP CAP CAP CAP CAP
LSNHS
EQUIP
LSWHS
CAP
LSWHS
EQUIP
MAE MAE
CAP CAP
MLE
CAP
MP PLE PLMS PVE RHE
CAP CAP EQUIP CAP CAP
SLMS
CAP
SPE
CAP
SVE
CAP
SVE SVE
CAP CAP
TRE
CAP
UWE
CAP
WLE WVE DISTRICT DISTRICT DISTRICT
CAP CAP CAP CAP CAP
PROJECT DESCRIPTION Replace kitchen and bathroom tile flooring Upgrade sound system in Commons-Stage/Fieldhouse Even out concrete where old playground equipment removed and add 4 large picnic tables - Orig Request $24,089 Replace fence around front of building and playground Paint Rms 121, 201, 224, 225, 230, 227, 226, 231, 229, Stairwell 200, Stairwell 06, Exterior cafe doors & Kids Country door New epoxy floor for bathroom - Rm 151 New epoxy floor for bathroom - Rm 152 Remodel and update front office space Replace carpet in 6th grade pod Replace carpet in Rms 3, 6, 19, 21 Strip, sand B gym floor, add new graphic, recoat Exterior Cyclone vacuum system installed in Engineering & Industrial Technology Lab Upgrade PE workout facility - $90k orig request 6 new cameras to be placed in specified locations to increase student, staff and patron safety Paint burlap wall and hang 8 ft white board in Rm 14 Replace 8 ft white board in Rm 49 Bathroom floors and corridor that connects the restrooms needs new epoxy Rms 130, 129, 205, 163, 165, 134D Install chain link fencing with black vinyl around playground Replace carpet in Rms 110, 107, 106, 108, 112 New digital clock system Replace carpet and tile in Rms 54, 60-66, 70-73, 98-99 Replace carpet in main office & library office Add storage container similar to what is being used at TRANS and high schools. Small concrete sidwalk would be needed Replace carpet in 4th grade pod, 6th grade pod - Orig Request $38,778 One pod approved Replace carpet in Rms B-143, B-147, B-146, B-144, B-122, B-126, B-125, B-121, A-128 and install 6' x 9' water hog mat for hallway by playground - Orig Request $55,020 Only waterhog approved Paint inside wall and oustide wall with railing for Rms C-132, A- 122, A-123 Repair concrete outside of the gym and medically fragile room Replace bathroom partitions that have become rusted and could be dangerous Replace carpet in Rms 163, 164, 165, 166, Main Office Hall, Office/Conference Room Repair/Replace kitchen floor and kitchen restroom floor Replace 205 ft of 5 ft tall wood fencing section with chain link fence Contingency (Capital Projects Team) Roofing/Paving Contracts Special Projects (Projects Determined as Needs Arise During Year)
30
TOTAL PROJECT COST $3,000 $44,800 $15,000 $7,500 $15,155 $2,751 $2,751 $22,624 $19,770 $16,506 $56,000 $33,600 $35,000 $10,000 $2,125 $625 $14,408 $9,000 $25,272 $15,000 $35,000 $21,294 $5,000 $19,389 $2,000 $2,009 $1,246 $8,800 $29,208 $17,766 $5,000 $2,401 $500,000 $619,920
BOND FUND The Bond Fund is a sub-fund within the Capital Projects Fund and is maintained as a separate fund with its own revenue sources and expenses. In April 2015 voters approved a $40 million bond issue to address numerous school-community identified needs. The 2017-18 budget includes expenses for the remaining bond resources. During the 2017-18 school year and continuing into 2018-19, the District will develop a Comprehensive Facility Master Plan (CFMP) that will include planning for future facilities. At this time, no bond issues are planned impacting the budgets through fiscal year 2021.
BOND FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
Local Interest
$32,524
Bond Premium
$4,534,394
Sale of Bonds
$40,000,000
TOTAL REVENUES
$0
$0
$44,566,918
$54,243
$6,000
$54,243
$6,000
$0
$0
$0
EXPENDITURES General Obligation Bond Construction Equipment Land
$209,291
$11,609,226
$20,442,115
$10,540
$2,377,995
$1,069,679
$100,000
$3,091,375
$60,000
Purchased Services TOTAL EXPENDITURES
$0
$319,831
$407,570
$26,518
$17,486,166
$21,598,312
$5,222,852
$288,291
$5,222,852
$288,291
$0
$0
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
ENDING FUND BALANCE
$288,291
$288,291
-$31,540
$27,049,212
$5,505,143
$288,291
$0
$0
$0
-$319,831
$27,080,752
-$21,544,069
-$5,216,852
-$288,291
$0
$0
$288,291
-$31,540
$27,049,212
$5,505,143
$288,291
$0
$0
$0
Mason Gym
Missouri Innovation Campus
31
DEBT SERVICE FUND The Debt Service Fund budget includes the necessary expenditures for retirement of the school year’s bonded debt, including an additional $41.3 million for bond issues previously refunded. The refunded bond issues will be paid from escrowed cash which is part of the Debt Service fund balance. Revenue in the debt service fund is provided by a $1.07 levy, investment earnings and state assessed utility revenue allocated to this fund. At the end of the 2018 calendar year, the District will have $142,290,000 in outstanding general obligation bonds.
32
The table below provides the amount of outstanding general obligation bonds of the existing bond issues. At the end of the 2018 calendar year, the District will have $142,290,000 in outstanding general obligation bonds. The latest bond issue was voted in 2015 and issued during 2015 and 2016. The changes in debt will be impacted solely by the pay-off of current issues each year pending any future refunding opportunities. Future bond issues are not planned at this time through the 2020-21 school year. General Obligation Bond Principal Outstanding by Issue Series Series Series Calendar Year 2005/2015 2006/2014 2008/2015 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Totals
$3,760,000 $2,750,000 $4,325,000 $6,000,000 $675,000 $5,350,000 $6,100,000 $1,375,000 $3,500,000 $1,975,000 $670,000 $8,035,000 $2,760,000 $5,670,000 $2,535,000 $5,925,000 $3,235,000 $2,725,000 $3,370,000 $2,925,000 $3,500,000 $3,250,000 $2,300,000 $3,500,000 $17,835,000 $20,870,000 $47,505,000
Series 2010A
Series 2010B
$1,228,000 $1,270,000 $1,315,000 $1,360,000 $1,405,000 $1,460,000 $1,515,000 $9,553,000
$6,447,000 $6,447,000
Series 2012A
Series 2012B
Series 2015B/ 2016
Total Principal Outstanding
$585,000 $2,130,000 $13,550,000 $600,000 $2,190,000 $14,815,000 $600,000 $2,240,000 $13,815,000 $625,000 $2,290,000 $13,595,000 $2,370,000 $10,800,000 $9,688,000 $7,230,000 $7,610,000 $8,110,000 $8,747,000 $4,905,000 $1,460,000 $1,515,000 $0 $9,250,000 $9,250,000 $9,750,000 $9,750,000 $10,250,000 $10,250,000 $10,750,000 $10,750,000 $2,410,000 $11,220,000 $40,000,000 $155,840,000
Estimates of the legal bonding debt limit (15% of assessed value) and the amount of bonding capacity (legal limit less outstanding general obligation debt) are shown in the graph below.
33
FUND BALANCE The Board of Education has set a minimum target of 15 percent for the fiscal year ending fund balance. This percent was determined based on the analysis of cash flow of actual revenue and expenditure patterns over a period of several years. The ending fund balance is particularly important to the Lee’s Summit R-7 District because a significant percent of the district’s revenue comes from local property tax. Taxpayers are billed in mid-November by the counties for the calendar year taxes, with the tax payment due on or before December 31. The fund balance is used to provide cash flow for the District to meet expenditure obligations in the months of July through December, before the bulk of the tax revenue is collected. The District maintains a zero fund balance in the Teacher’s Fund. Teacher’s fund expenses are funded through state aid revenues, Prop C sales tax, miscellaneous local revenues and by a budgeted transfer from the Incidental Fund. The following graph provides both the operating fund balance with the 15 percent minimum balance represented. While the fund balance projections show a slight decrease, the fund balance is well in excess of the minimum required fund balance.
BUDGET FORECAST The District is continually planning, analyzing and revising budget estimates. Multiple year revenue, expense and fund balances are projected to position the District to evaluate the short and long term impact of decisions on District resources. For the next three fiscal years, (FY19 through FY21), the District is conservatively estimating revenue increases at an average of 2.52% per year and expenditure increases at an average of 2.17% per year. Both revenues and expenditures are estimates using projected variables including assessed value, tax rate, enrollment, all categories of revenue and expense, including anticipated salary schedule step movement, additional staff and benefit cost increases.
34
PROPERTY TAXES Historically, property tax revenue has represented a significant source of operating revenue for the school district at approximately 44 percent of total operating revenues. Personal, Residential, Commercial, and Agricultural property are all subject to property tax assessment. The tax burden of an individual taxpayer is determined by multiplying the levy rate by each $100 of assessed valuation. As illustrated in the table below, the property tax on a $100,000 home is currently only $45.24 (3.9%) lower than in fiscal year 2013-14.
Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Market Value of Property $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Assessed Value* $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000
Tax Levy Rate $5.8246 $5.8102 $5.8762 $5.8618 $5.9957 $5.9813 $6.1192 $6.0627
Annual Cumulative Property Tax Change Percent Due from FY07 Change ($12.79) -1.14% $1,106.67 ($15.52) -1.39% $1,103.94 ($2.98) -0.27% $1,116.48 ($5.72) -0.51% $1,113.74 $1,139.18 $19.72 1.76% $1,136.45 $16.99 1.52% $1,162.65 $43.19 3.86% $1,151.91 $32.45 2.90%
A major portion of the District’s assessed value results from residential real estate. This graph shows 68 percent of the total assessed value or $1.3 billion is based on residential real estate value.
35
The table presented below provides the tax rate by fund.
TAX RATE BY FUND Special Incidental Revenue (General) (Teacher's) 2017-18* $4.7418 $0.0000 2016-17 $4.8757 $0.0000 2015-16 $4.8613 $0.0000 2014-15 $4.9992 $0.0000 2013-14 $4.9427 $0.0000
Debt Service $1.0700 $1.0700 $1.0700 $1.0700 $1.0700
Capital Projects $0.0500 $0.0500 $0.0500 $0.0500 $0.0500
Total $5.8618 $5.9957 $5.9813 $6.1192 $6.0627
*Estimated
The Missouri Department of Elementary and Secondary Education provides comparison data to identify the relative wealth of the district based on assessed value per ADA. The chart below provides this comparison data for Lee’s Summit R-VII and five other local comparable districts. For information purposes, the statewide assessed value per ADA is also included. The 2015-16 school year is the most recent information available published by DESE.
36
BOARD MEMBERS AND DISTRICT ADMINISTRATION BOARD OF EDUCATION Bob White............................................................................................................. President Julie Doane……….........................................................................................Vice-President Dennis Smith............................................................................................................ Member Phyllis Balagna........................................................................................................ Member Adam Rutherford..................................................................................................... Member Kim Fritchie.............................................................................................................. Member Jackie Clark............................................................................................................. Member
SUPERINTENDENT’S LEADERSHIP TEAM Dennis Carpenter, Ed. D.......................................................................Superintendent Katie Collier, Ed. D…………………. ….Associate Superintendent, Instruction & Leadership Judy Hedrick, Ed. D………...... Associate Superintendent, Business Services & Operations Jeff Miller, Ed. D…………………..…....…......Associate Superintendent, Human Resources Jennifer Kephart, Ed. D…………….……..Assistant Superintendent, Elementary Instruction Emily Miller, Ed. D……………………….…..…...Assistant Superintendent, Special Services David Sharp, Ed. D……………….….……. Assistant Superintendent, Secondary Instruction Amy Gates, Ed. D……………………..…………….………….Executive Director, Technology Janice Phelan……………………………………….…….Executive Director, Communications
37
38
ORGANIZATIONAL SECTION The Organizational Section of the school budget document describes the District’s organizational and management structure as well as the policies and procedures governing its administrative and financial operations.
M. Eidson, Lee's Summit North High School
Christina B., Campbell Middle School
N. Wood, Lee's Summit High School
K. Cadwell, Lee's Summit High School
39
MISSION STATEMENT Lee’s Summit R-7 School District prepares each student for success in life.
OUR VISION: Lee’s Summit R-7 is an exemplary school district, graduating students who are college and career ready with the competitive advantage necessary to be successful. Lee’s Summit R-7 reflects a culture of respect and acceptance. Collaboration is an expectation that fosters mutual understanding and a focus on student achievement and staff development. Lee’s Summit R-7 encourages innovation and creativity, recognizing student learning as our fundamental purpose.
Aunnuka J, Lee's Summit High School
DISTRICT COMMITMENTS:
Engaging students in research-based programs in a technology-rich environment. Embracing open, honest two-way communication. Promoting continuous improvement through data-driven decision-making. Sustaining positive relationships among students, staff, families and community members. Ensuring a rigorous and relevant learning experience that leads to success for each student. Partnering with students in identifying and achieving their learning goals. Continuing a safe and caring environment.
40
DISTRICT ENTITY The legal name of the District—Reorganized School District Number 7 of Jackson County, Missouri--is a direct result of the manner in which the district was formed in 1949. The 117-square-mile Lee’s Summit R-7 School District is recognized as one of the top educational systems in the state and nation. Located in the southeast portion of the Kansas City metropolitan area, the district serves the communities of Lee’s Summit, Greenwood, Lake Lotawana and Lake Winnebago as well as unincorporated areas of eastern Jackson County and also includes a small portion of Blue Springs and Kansas City municipalities. On the southwestern side of the District, the boundaries extend slightly into northern Cass County. The District is a fiscally independent political subdivision of the State of Missouri that may levy and collect taxes within the limitations of the Missouri state statutes. Section 165.021, RSMo, provides authority for the District to disburse funds only for the purposes for which they were levied, collected and received.
SIZE AND SCOPE The Lee’s Summit R-7 School District has gained an annual average of 178 new students since 2006-07, with kindergarten through grade 12 enrollment for 2017-18 anticipated at 18,157 and projected though 2026-17. The District also provides services to approximately 350 pre-kindergarten students. Recognized nationally for its quality educational programs and a commitment to success for all students, the R-7 School District has good reason to attract its many new residents. Involved parents and a supportive community are key in the school district’s ability to provide excellent educational opportunities in a caring learning environment. Lee’s Summit R-7 citizens understand that quality schools are the foundation of a strong and economically sustainable community.
41
The district currently includes 18 elementary schools, three middle schools, three high schools, an alternative secondary school, a secondary technology academy, an early education center and a special-education day-treatment center, and numerous support facilities serving students in grades pre-kindergarten through grade 12. The R-7 School District has won Missouri’s Distinction in Performance Award, the state’s highest recognition for academic achievement. The district exceeded the criteria for this prestigious award by earning a perfect score on the Missouri performance indicators every year since the program began. Lee’s Summit was featured in BusinessWeek magazine as Missouri’s “Best Place in America to Raise Kids.” Only one town was selected from each state, with the most important factors in the analysis being considered: school performance, affordability and safety. Money magazine named Lee’s Summit R-7 schools as seventh best in the nation in its annual “Best Places to Live” issue focusing on the nation’s top 100 small cities.
REPORTING Every district in the state of Missouri is required to file an Annual Secretary of the Board Report (ASBR) with the Missouri Department of Elementary and Secondary Education (DESE) by August 15 of each year. The ASBR must be subsequently updated to be consistent with the final audited financial reports. The financial operations of the district are established within the parameters of all federal, state and local reporting requirements. An annual audit is performed at the direction of the Board of Education with direct reporting of audit results to a community-based audit review team, also facilitated by Board of Education members. The audit review team performs an in-depth review of the audit process, audit report and accompanying letter to district management. As part of an ongoing emphasis on transparency, the audit review team meets at a public session prior to the audit report being considered for approval by the full Board of Education. Both the audit review team and Board of Education are provided responses to areas identified in the management letter in need of response or practice changes. In addition to the annual external audit, the Board of Education provides resources for internal control reviews of all school sites on a three-year rotation basis. These internal control reviews are performed by an external auditing firm and include all areas at the school sites where money is received, including the school office, cafeteria and library. Following the internal control on-site review, a comprehensive report is provided to the site. The report includes the internal control practices reviewed, the practices consistent with good internal control 42
procedures and the internal control practices needing improvement. During the past ten years, the external auditors have not identified any major misrepresentations or internal control concerns within the school district. Every school district in the state of Missouri is also required to file audited financial reports with DESE by December 31 annually. The auditor’s management letter and board of education minutes approving the audit report are required to be submitted to DESE when available. The District is required to submit a data collection form and reporting package to the Federal Audit Clearinghouse at the U.S. Bureau of Census within the earlier of thirty days from receipt of the audit report or nine months after the end of the audit period. The reporting package consists of the complete audit and a summary schedule of prior audit findings and a corrective action plan for the current year audit.
GOVERNANCE The District is governed by a seven-member board of education. Board members are elected at-large. Each director must be a voter of the District who has resided within the state for one year preceding election or appointment and who is at least 24 years of age. All directors hold their offices for three years and until their successors are duly elected and qualified, provided they maintain the qualifications for board of education members. The role of the Board of Education is to exercise general supervision over the District and to ensure the schools are maintained as provided by state statutes, rules and regulations of the Missouri State Board of Education and the Missouri Department of Elementary and Secondary Education (DESE), and the policies, rules, and regulations approved by previous boards of education. In addition, the Board is accountable to the electorate and is responsible to provide for the educational needs of students within the financial constraints of the District.
Abby R, Lee’s Summit North High School
43
BOARD OF EDUCATION ABOUT THE SCHOOL BOARD School board members must be a resident of the school district and have resided within the state for one year at the time of election or appointment and be at least 24 years of age. The term of a member is three years. The Board has full legislative authority and control of the District as provided for in state law. The Lee’s Summit R-7 Board of Education meets once per month at 7:00 p.m. at the Stansberry Leadership Center, 301 NE Tudor Road, Lee’s Summit, Missouri. Agendas are available prior to Board meetings and are posted on the District web site: http://www.boarddocs.com/mo/lsr7sd/Board.nsf/Public The agenda for each regular meeting of the Board of Education will include a designated time for “Comments from the Public.” The purpose of this item is to permit members of the public to speak, within time limitations, on matters included in the current agenda. The Board of Education may also elect to offer a time for “Comments from the Public” during Board workshops. Citizens desiring to address the Board during “Comments from the Public” will advise the superintendent or the President of the Board prior to the starting time of the meeting. The request will be made in writing on a form provided by the district and will include the name, address, telephone number of the speaker, name of organization represented (if any), and a brief description of the topic to be addressed. A time allocation, not to exceed 20 minutes at a meeting, will be provided for “Comments from the Public.” The Board President will advise the audience at the beginning of “Comments from the Public” of the guidelines to be followed during this time. Speakers will be advised that their speaking time will be limited as directed by the Board President. Speakers will be advised that comments must be limited to items which directly relate to the Board agenda. The Board President will have the authority to discontinue any presentation which violates any of the public participation guidelines. Correspondence to school board members may be directed to Board Secretary Linda Ismert,
[email protected], 301 NE Tudor Road, Lee’s Summit, MO 64086.
44
BOARD OF EDUCATION MEMBERS Julie Doane, Vice President First Elected: 2015 Term Expires: 2018
Bob White, President First Elected: 2013 Term Expires: 2019
Phyllis Balagna, Member First Elected: 2012 Term Expires: 2019
Jackie Clark, Member First Elected: 2017 Term Expires: 2020
Adam Rutherford, Member First Elected: 2015 Term Expires: 2018
Kim Fritchie, Member First Elected: 2017 Term Expires: 2020
Dennis Smith, Member First Elected: 2017 Term Expires: 2020
45
Linda Ismert, Executive Assistant BOE/ Superintendent
DISTRICT ADMINISTRATORS
Dr. Dennis L. Carpenter Superintendent
Dr. Jeff Miller Associate Superintendent Human Resources
Dr. David Sharp Assistant Superintendent Secondary Instruction
Dr. Katie Collier Associate Superintendent Instruction & Leadership
Dr. Jennifer Kephart Assistant Superintendent Elementary Instruction
Dr. Amy Gates Executive Director Technology
46
Dr. Judy Hedrick Associate Superintendent Business Services & Operations
Dr. Emily Miller Assistant Superintendent Special Services
Janice Phelan Executive Director Community Relations
ORGANIZATIONAL CHART
*Superintendent’s Leadership Team 47
Link to map and other street/school finding tools is available at: http://cdn.lsr7.org/wp-content/uploads/2012/04/LSDistrictMap09-10.pdf
48
SCHOOLS Locations/Start and Stop Times PreK – Elementary Great Beginnings Early Education (Pre-K) Hours: 9:00 am-12:00 pm, 1:00 pm – 4:00 pm Address: 905 NE Blue Stem Dr, Lee’s Summit, MO 64086. Office: 816.986.2460 Kerry Boehm, Director
Mason Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 27600 Colbern Rd, Lee’s Summit, MO 64086. Office: 816.986.2330 Beth Ratty, Principal
Cedar Creek Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 2600 SW Third Street, Lee’s Summit, MO 64081. Office: 816.986.1260 Jen Opie, Principal
Meadow Lane Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 1421 NE Independence, Lee’s Summit, MO 64086. Office: 816.986.3250 Dr. Sheryl Cochran Principal
Greenwood Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 805 W Main, Greenwood, MO 64034 Office: 816.986.1320 Carrie Jackson, Principal
Pleasant Lea Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 700 SW Persels, Lee’s Summit, MO 64081. Office: 816.986.1230 Aaron Barnett, Principal
Hawthorn Hill Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 2801 SW Pryor Rd, Lee’s Summit, MO 64086. Office: 816.986.3380 Carol Germano, Principal
Prairie View Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 501 SE Todd George Rd., Lee’s Summit, MO 64063. Office: 816.986.2280 Amy Fennewald, Principal
Hazel Grove Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 2001 NW Blue Parkway, Lee’s Summit, MO 64064. Office: 816.986.3310 Kristen Merrell, Principal
Richardson Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 800 NE Blackwell Rd., Lee’s Summit, MO 64086. Office: 816.986.2220 Lisa Detig, Principal
Highland Park Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 400 SE Millstone Avenue, Lee’s Summit, MO 64063. Office: 816.986.2250 Jodi Mallette, Principal
Summit Pointe Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 13100 E. 147th Street, Kansas City, MO 64149. Office: 816.986.4210 Dr. Heather Kenney, Principal
Lee’s Summit Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 110 SE Green Street, Lee’s Summit, MO 64063. Office: 816.986.3340 Tracy Sample, Principal
Sunset Valley Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 1850 SE Ranson Road, Lee’s Summit, MO 64082. Office: 816.986.4240 Greg Johnson, Principal
Longview Farm Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 1001 SW Longview Park Dr, Lee’s Summit, MO 64081. Office: 816.986.4180 Kim Hassler, Principal
Trailridge Elementary (Grades K-6) Hours: 8:20 am-3:20 pm Address: 3651 SW Windemere Dr., Lee’s Summit, MO 64082. Office: 816.986.1290 Jeff Scalfaro, Principal
49
SCHOOLS Locations/Start and Stop Times Elementary (continued) Underwood Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 1125 NE Colbern Rd., Lee’s Summit, MO 64086. Office: 816.986.3280 Dr. Anna McGraw, Principal
Woodland Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 12709 S Smart Rd., Lee’s Summit, MO 64086. Office: 816.986.2360 Dr. Stacy James, Principal
Westview Elementary (Grades K-6) Hours: 9:00 am-4:00 pm Address: 200 North Ward Rd., Lee’s Summit, MO 64063. Office: 816.986.1350 David Boulden, Principal
High Schools Lee’s Summit High School (Grades 9-12) Hours: 7:30 am-2:23 pm Address: 400 SE Blue Parkway, Lee’s Summit, MO 64063. Office: 816.986.2000 Dr. John Faulkenberry, Principal
Middle Schools Campbell Middle School (Grades 7-8) Hours: 7:40 am-2:35 pm Address: 1201 NE Colbern Rd., Lee’s Summit, MO 64086. Office: 816.986.3175 Dr. Sherri Lewis, Principal
Lee’s Summit North High School (Grades 9-12) Hours: 7:30 am-2:23 pm Address: 901 NE Douglas, Lee’s Summit, MO 64086. Office: 816.986.3000 Dr. Jeff Meisenheimer, Principal
Pleasant Lea Middle School (Grades 7-8) Hours: 7:30 am-2:25 pm Address: 630 SW Persels, Lee’s Summit, MO 64081. Office: 816.986.1175 Dr. Janette Miller, Principal
Lee’s Summit West High School (Grades 9-12) Hours: 7:30 am-2:23 pm Address: 2600 SW Ward Rd., Lee’s Summit, MO 64082. Office: 816.986.4000 Dr. Chad Hertzog, Principal
Summit Lakes Middle School (Grades 7-8) Hours: 7:30 am-2:25 pm Address: 3500 SW Windemere Dr., Lee’s Summit, MO 64082. Office: 816.986.1375 David Mitchell, Principal
Summit Ridge Academy (Grades 7-12) Hours: 7:30 am-1:30 pm Address: 2620 SW Ward Rd, Lee’s Summit, MO 64082. Office: 816.986.4120 Andy Campbell, Principal Summit Technology Academy (Grades 11-12) Hours: 7:55–10:00 am; 11:50 am-1:55 pm Address: 777 NW Blue Parkway, Lee’s Summit, MO 64086. Office: 816.986.3410 Elaine Metcalf, Director
Eve M, Lee's Summit North High School
50
DESTINATION 2021 - COMPREHENSIVE SCHOOL IMPROVEMENT PLAN The Lee’s Summit R-7 Comprehensive School Improvement Plan or CSIP provides a guide for our school district with its major emphasis on student achievement. Developed by a community team and approved by the Board of Education, the CSIP focuses on five areas — governance; student performance; highly qualified staff; facilities, support and instructional resources; and parent and community involvement. The five-year plan includes a number of components to guide all efforts, includes goals and tasks to improve, enhance accountability and is also part of the district’s evaluation process through the State of Missouri. The 2017-18 school year is the second year of the District’s most recently developed CSIP – Destination 2021. The five areas of the CSIP, including the goals for each focus area are listed below including the 2017-18 budget allocation by goal. Governance • Goal One: Vision and Accountability: In collaboration with administration, the Board will establish and monitor annual goals for student achievement and instruction, as well as efficient and effective operations and fiscal planning. • Goal Two: Policy and Community Leadership: Through collaboration among the board and administration; establish and maintain policies and procedures that create a foundation for maximizing student achievement and managing district resources effectively. • Goal Three: Board and Superintendent Team: The Board and Superintendent will respectively govern and administer the school district in a collaborative manner that leads to a positive impact on student achievement and efficient and effective operations. 2017-18 Budget Allocation: $24,295 Student Performance • Goal One: Each student will be provided a personalized learning experience that creates student ownership of learning thereby demonstrating growth in student achievement. 2017-18 Budget Allocation: $1,045,970 • Goal Two: The District will increase student connectedness and engagement to the school experience. 2017-18 Budget Allocation: $2,280,000 • Goal Three: Students will demonstrate academic achievement as measured by identified targets at the district, elementary and secondary levels. 2017-18 Budget Allocation: $49,500
51
Highly Qualified Staff • Goal One: Attract and retain quality staff while increasing gender and ethnic diversity ten percent each year. 2017-18 Budget Allocation: $7,867,142 • Goal Two: Provide high quality professional learning that prepares each staff member to successfully support an inclusive learning environment. 2017-18 Budget Allocation: $963,233 Facilities, Support and Instructional Resources • Goal One: Develop and evaluate the annual budget for alignment of district resources with the Comprehensive School Improvement Plan, Comprehensive Facilities Master Plan and other budget planning processes to ensure compliance with the Board of Education targeted financial fund balance reserves. 2017-18 Budget Allocation: $90,000 Parent and Community Involvement • Goal One: Increase the number of community members volunteering in individual school and district locations by enhancing relationships and more fully engaging citizens. 2017-18 Budget Allocation: $66,807 • Goal Two: Increase contributions of time, talent and treasure to Lee's Summit R-7 pro- grams and organizations that supplement and support the mission of the school district. • Goal Three: Develop creative global communication vehicles to promote, facilitate and enhance family, community and business engagements. 2017-18 Budget Allocation: $12,000 Additional CSIP information is available at:
http://www.lsr7.org/district/news-publications/
DISTRICT PRIORITIES Annually the Board of Education collaborates with the Superintendent’s Leadership Team to define annual priorities. Building upon the district’s tradition of excellence and continuous improvement in student learning, the Board of Education commits to the following priorities for the 2017-18 school year. 1. Increase the learning and achievement of every child through the development of a comprehensive academic framework informed by the needs of our students, the district’s strategic plan and the 2016 Academic Systems Review. 2. Ensure equitable access to 21st century learning environments by engaging stakeholders in a process to update the district’s Comprehensive Facility Master Plan to meet the instructional and programming needs of all pre-K-12 students. 3. Strengthen public trust in the district’s governance leadership team by systemically enhancing communication, involvement and collaboration to ensure constructive engagement within the school district community. 52
These goals align with the focus of the district’s strategic plan. While each Board priority is championed by a member of the Superintendent's Leadership Team with the guidance of the Superintendent, a variety of individuals contribute to the development of recommendations and all work associated with these priorities. The Superintendent’s Leadership Team will provide regular updates to the Board of Education to allow the Board to monitor the work associated with the priorities while also affording the opportunity for Board member inquiry and contribution. The timeline is as follows: Monthly informal updates via Board Update September 22, 2017 November 10, 2017 December 8, 2017 March 9, 2018 May 11, 2018
Quarterly formal presentations to the Board at Monthly Meeting October 26, 2017 January 18, 2018 April 12, 2018 June 14, 2018
Ben S., Lee's Summit High School
53
MEASUREMENT BASIS OF ACCOUNTING The District has elected to use a modified cash basis of accounting. The cash basis of accounting is a basis of accounting other than generally accepted accounting principles. The District uses the modified cash basis of accounting for revenues and expenditures for both accounting and budgeting. This basis of accounting is used for all governmental type funds of the District. Basis of accounting is a reference to when financial events are recorded, such as the timing for recognizing revenues, expenses and their related assets and liabilities. Under the District’s cash basis of accounting, revenues and expenses and related assets and liabilities for all activities are recorded when they result from cash transactions.
CLASSIFICATION OF REVENUE AND EXPENDITURES The Missouri Department of Elementary and Secondary Education has adopted a system of accounting for the classification of revenue and expenditures based on generally accepted accounting principles. Revenues and expenditures are classified by a combination of three dimensions: fund, function, and object. The revenue function code identifies the source of the revenue, such as local, county, state, or federal. The revenue object code identifies the specific source of revenue, such as taxes, student activities, or grants. The expenditure function code describes the action, purpose, or program for which activities are performed. The expenditure object code identifies the service or commodity obtained such as salaries, supplies, or travel. The annual report submitted to DESE must be completed with financial information consistent with the revenue and expenditure codes developed by the Department. Accordingly, revenue and expenditures are presented with these formats in the following pages.
Miranda, Lee's Summit North High School
54
CLASSIFICATION OF REVENUE: BY OBJECT 5100 County Revenue Object Code 5111
Object Name Current Tax
5112 5113
Delinquent Tax Proposition C
5114
Financial Institution Tax M&M Surtax
5115
5116 5131 5140 5151
In Lieu of Tax Transportation Fees from Patrons Earnings on Investments Sales to Pupils
5161
Sales to Adults
5165
Food Service NonProgram
5170 5181
Student Activities Community Services
5190
Other Local Revenue
Description Taxes on real and personal property within the district for the current year. Revenue from prior year real and personal property taxes. Amounts received from the state from a one cent state sales tax, collected and distributed in accordance with Section 163.087, RSMo. Taxes levied on the intangible assets of financial institutions. Surcharge on commercial real estate to replace revenue lost due to the elimination of merchants & manufacturing businesses’ inventory tax. Amounts received for property taken off the tax rolls. Amounts received from parents for transportation of students in the District. Interest earned on deposits and investments. Amounts received from students for the sale of meals served under the National School Lunch and Breakfast Programs. Amounts received from adults for the sale of meals served under the National School Lunch and Breakfast Programs. Amounts received from special Milk Program milk sales, the sale of extra milk, ala carte, snack bar, vending, banquets, after school snack program. All revenue from student activities. Revenues from activities performed by the District as community services, not directly related to providing an education for pupils. All other revenue from local sources not covered by other defined revenue codes.
5200 County Revenue Object Code 5211 5221 5237
Object Name Fines, Escheats, Etc. State Assessed Utilities Other County Revenue
Description Revenue from Jackson and Cass Counties for fines, foreclosures and unclaimed taxes. Levy revenue on the assessed valuation of railroad and utility properties as assessed by the state. Revenue received to reimburse the District for expenses included in the COMBAT grant.
55
5300 State Revenue Object Code
Object Name
Description
5311
Basic Formula
5312
Transportation
5314
Early Childhood Special Education
5319
Classroom Trust Fund Education Screening Program/PAT Career Education
5324
5332 5333 5369
5381
5397
Food Service Residential Placement/Excess Cost High Need Fund Special Education Other State Revenue
Amounts received from the State Foundation Formula (the calculated apportionment amount plus or minus prior year corrections). Excludes Classroom Trust Fund. Amounts received from the state for transportation of school children. 5314 Early Childhood Special Education. Amounts received from the state to provide for early childhood special education programs. Amounts received from the Gaming portion of funding for the State Foundation Formula. Revenue to provide for Early Childhood Screening and Parents as Teacher programs. Amounts received from the state that represent reimbursement for career and technical education. Revenue from state for school lunch programs. Amounts received for children in residential placements through the Missouri Department of Mental Health or Division of Family Services. Reimbursement for expenditures made on behalf of students with disabilities when the current expenditure per eligible pupil exceeds three times the District’s average. All other revenue from the state not covered by the above revenue codes.
5400 Federal Revenue Object Code
Object Name
5412 5418 5441
Medicaid ROTC Individuals with Disabilities Education Act
5442
Early Childhood Special Education ECSE) School Lunch Program School Breakfast Program Title I Title III English Language Acquisition Object Name Title II, Part A & B, ESEA Teacher and Principal Training and Recruitment Other Federal Revenue
5445 5446 5451 5462
Object Code 5465
5497
Description Reimbursement for Medicaid services. Reimbursement for reserve officer training programs. Amounts received through the Individuals with Disabilities Education Act (IDEA) grant for providing special education and related services to students with disabilities. Amounts received for ECSE programs.
Amounts received directly through DESE for the National Food Lunch Program. Amounts received directly through DESE for the National Food Breakfast Program. Amounts received through the Title I programs. Amounts received through the state for teaching English to limited English proficient children and for immigrant children. Description Funds used to improve teacher and principal quality, increase the number of highly qualified teachers and principals and improve the academic achievement of students in mathematics and science. All other federal revenue not covered by the above revenue codes.
56
Other Revenue Object Code
Object Name
Description
5611
Sale of Bonds
Amounts received as principal from the sale of bonds.
5641
Amounts received from the sale of school buses.
5651
Sale of School Buses Sale of Property
5692
Refunding Bonds
Amounts received from the sale of real and personal property. Proceeds from a refunding of general obligation bonds.
CLASSIFICATION OF EXPENDITURES: BY FUND Governmental Funds Governmental fund reporting focuses on the sources, uses, and balances of current financial resources. Expendable assets are assigned to the various governmental funds according to the purposes for which they are to be used. Current liabilities are assigned to the fund from which they will be paid. The difference between governmental fund assets and liabilities is reported as fund balance. The following are the District’s principal governmental funds: Incidental (General) Fund: Accounts for general activities or other activities except those required to be accounted for in the Special Revenue, Debt Service or Capital Projects. Teachers (Special Revenue) Fund: Accounts for expenditures for certificated employees involved in administration and instruction. It includes revenues restricted by the State for the payment of certificated salaries. Debt Service Fund: Accounts for the accumulation of resources for, and the payment of principal, interest, and fiscal charges on general long-term debt. Capital Projects Fund: Accounts for the proceeds of long-term debt and other revenues designated for acquisition or construction of major capital assets and other capital outlay purchases required by law or the Missouri Department of Elementary and Secondary Education to be reported in the Capital Projects Fund.
57
CLASSIFICATION OF EXPENDITURES: BY FUNCTION The expenditure functions of the districts in Missouri are categorized into five general areas: Instruction, Support Services, Community Services, Facilities Acquisition and Construction, and Debt. Each of these categories is further classified into sub-functions based on schools, programs, services, and areas of responsibility. 1000 Instruction–Instruction includes the activities dealing directly with the teaching of pupils or the interaction between teachers and pupils. Teaching may be provided for pupils in a school classroom, in another location such as a home or hospital, and in other learning situations such as those involving co-curricular activities. Also included are the activities of aides or assistants who assist in the instructional process. 2000 Support Services–Support services are those services which provide administrative, technical (such as guidance and health), and logistical support to facilitate and enhance instruction, and to a lesser degree, community services. Support services exist as adjuncts for the fulfillment of instructional objectives. 3000 Community Services–Community services consist of those activities concerned with providing services to the community as a whole or for some segment of the community. 4000 Facilities Acquisition and Construction Services–Those activities concerned with the acquisition of land and buildings, remodeling buildings, the construction of buildings and building additions, initial installation and extensions of service systems, and other built-in equipment and improvements to sites. 5000 Long and Short Term Debt – Activities servicing the debt of the District.
58
CLASSIFICATION OF EXPENDITURES: BY OBJECT The expenditure object code identifies the type of service or commodity obtained such as salaries, supplies, or travel. Listed below are the six major expenditure object categories used for all expenses within the school district. 6100 Salaries–Amounts paid to employees of the district, including all regular, full time, part time, or hourly staff. Salary includes gross wages for services rendered while an employee of the district. 6200 Employee Benefits–Amounts paid by the district for benefits on behalf of employees. These amounts are not considered salary but are included in the overall compensation provided to employees. 6300 Purchased Services-Amounts paid for services rendered by contractors, vendors or others not considered employees of the district. 6400 Supplies–Amounts paid for material items of an expendable nature that are consumed, worn out, deteriorated by use, or items that lose their identity through fabrication or incorporation into different or more complex units or substances. 6500 Capital Outlay–Expenditures for the acquisition of capital assets or additions to capital assets. They are expenditures for land or existing buildings, improvements of grounds, construction of buildings, additions to buildings, remodeling of buildings, and equipment. This category includes expenses for the principal and interest payment for lease purchases. The threshold for expenses to be categorized as capital projects is an item cost of $1,000 or more. 6600 Long and Short Term Debt–Expenditures for the retirement of debt, the payment of interest on debt, and the payment of fees.
Lauren S., Lee's Summit High School
59
THE BUDGET PROCESS The Lee’s Summit R-7 Board of Education provides the leadership for the budget process structure which includes a successful mechanism for fair and equitable distribution of district resources. Through this mechanism, district-wide budget managers’ request staffing as well as operational, capital projects, technology and/or new program resources. This annual process has served the district well for several years and involves all schools and departments. These school and department leaders analyze needs in conjunction with their individual site teams and submit requests through a standardized process. The Superintendent’s Leadership Team, which includes representatives from all functional areas within the district, and other teams such as Capital Projects and Technology, review requests and develop recommendations for Board of Education consideration and approval. These budget requests are incorporated into short- and longrange budget planning processes which are shared with both internal and external stakeholders. In addition, the Lee’s Summit R-7 Board of Education dedicates time on a semi-annual basis to budget and finance work sessions where they learn more about the district’s budgeting processes. Through this process, the Board of Education sets the district’s budget timelines on an annual basis. During the annual budget approval, the Board reviews prior year budget estimates and allows for budget amendments to influence future budgets where necessary. The information is also shared on a regular basis with community, parents and business leaders through groups such as the R-7 Citizens’ Advisory Committee and Business Roundtable. This process has successfully provided the resources to maintain pupil-teacher ratios across the district from 22.6:1 in 2014 to 22.2:1 in 2017 at the K-6 grade levels. At the middle schools, the average class size for 2017 was 20.8 and at the high school level, the average class size was 21.8.
60
BUDGET ALIGNMENT The Lee’s Summit R-7 Comprehensive School Improvement Plan (CSIP) is developed through a district team comprised of Board of Education members, community representatives and staff members. This community group meets on a regular basis to develop action plans in five major focus areas, including governance; student performance; highly qualified staff; facilities, support and instructional resources; and parent and community involvement. The new CSIP plan will guide District operation through 2021. Members of an approximately 40person Comprehensive School Improvement team developed the five focus areas into goals, strategies and action steps for each area. To ensure accountability, the action steps are placed on a timeline and reviewed annually by the CSIP Team, the Superintendent's Leadership Team and the Board of Education.
Destiny C., Lee’s Summit North High School
The CSIP process requires each strategy and action step to include an implementation timeline which can span multiple fiscal years with an accompanying estimate of budget resources needed for each action step. The CSIP budgeting function further identifies currently budgeted resources and needed additional resources by year and by focus area. To keep the five-year plan up-to-date, the CSIP Team recommends annual revisions to the Board of Education during a summer work session. Board members review each annual action step and progress toward each CSIP goal prior to approval of CSIP changes. In addition, the Board of Education establishes priorities for CSIP action steps annually through the use of the school district’s Superintendent/Board of Education Agreement and action items. Board members also receive a mid-year status report of activities and progress for each task included in the Superintendent/Board Agreement.
BUDGET PLANNING In order to make the best use of district resources, the Lee’s Summit R-7 Board of Education established a process for quality focus teams and process action teams. Through this process, the district is better able to monitor and evaluate programs, initiatives and activities. These district teams work in conjunction with and in addition to other established district teams including the Instructional Operations Team, Comprehensive School Improvement Team, Superintendent’s Leadership Team and site teams to determine if programs, initiatives and activities are essential, effective and efficient. 61
This approach to program evaluation provides for a continual cycle of study, planning, implementation and evaluation. This cycle also allows for restructuring or discontinuing of programs, initiatives and/or activities as we seek to prepare our students for success with available resources.
BUDGET CALENDAR
62
BUDGET ADOPTION One of the primary responsibilities of the Board of Education is to secure adequate resources to fund a quality program of education in the school district. Budget planning and preparation is a continual process. The annual school budget represents a written document presenting the Board's plan for allocation of available financial resources into an explicit expenditure plan to sustain and improve the educational function of the school district. It is a legal document describing the programs to be conducted during the fiscal year and is the basis for the establishment of tax rates for the district. The Board of Education receives reports on these consistent processes on at least a semi-annual basis. During work sessions, Board of Education members are provided with both qualitative and quantitative data which enables the Board to give direction for adjustments to programs and determine subsequent budget impacts. The district has implemented, with Board of Education input and approval, numerous cost containment strategies and best practices to address operating fund balances. Since 2004 when the operating fund balance was approximately 11.95 percent, these strategies have contributed to positive operating fund balances projected at 27.74 percent in the current school year. Using these processes and involving numerous stakeholders has allowed the district to positively impact students while continuing to serve as good stewards of our community’s financial resources. The Board designates the superintendent to serve as the budget officer of the district. As budget officer, the superintendent directs the planning and preparation of the budget and will submit the budget to the Board of Education for approval. The superintendent will present the Board the final budget proposal before the new fiscal year begins, as provided by law. The Board may revise the items contained therein and will at that meeting adopt the portion of the budget dealing with the salary schedule and the needed tax rate for the district. The Board will conduct at least one public hearing regarding the proposed budget and taxation rate. The annual budget document shall present a completed financial plan for the ensuing fiscal year and shall include at least the following statutory requirements: •
Damien C, Lee's Summit High School
A budget message describing the important features of the budget and major changes from the preceding year. 63
•
Estimated revenues to be received from all sources for the fiscal year, with a comparative statement of actual or estimated revenues for the two years next preceding, itemized by year, fund and source.
•
Proposed expenditures for each function or program within the district, with a comparative statement of actual or estimated expenditures for the two years preceding, itemized by year, function and object.
•
The amount required for the payment of interest, amortization and redemption charges on the debt of the school district.
•
A general budget summary.
In no event shall the total proposed expenditures from any fund exceed the estimated revenues to be received plus any encumbered balance or less any deficit estimated for the beginning of the fiscal year. Upon the recommendation of the superintendent, the Board will approve a system of internal accounting to ensure proper financial accounting of revenues and expenditures. The adopted budget of the Lee’s Summit R-7 School District serves as the control to direct and limit expenditures in the district. Overall responsibility for assuring control rests with the superintendent. However, each budget manager is responsible for ensuring all expenditures are approved and are consistent with effective, efficient, essential budgeting practices. The total amounts that may be expended during the fiscal year are set forth in the budget. The total budgeted expenditure for each program is the maximum amount that may be expended for that Elizabeth H., Lee's Summit High School classification of expenditures during the school year unless a budget transfer is recommended and approved by the Board of Education, which may occur during the fiscal year. The Board of Education may also consider final budget amendments in June, annually. The Board will review the financial condition of the district on a monthly basis. The monthly reconciliation statement will show the year-to-date revenue received, the year- to-date expenses compared to the budget by fund, the percent of revenue/expense to budget and the fund balance percent.
FINANCIAL ACCOUNTABILITY The Board of Education has effectively implemented policies governing the district’s accounting, auditing and financial reporting including fraud and purchasing/bidding policies. The financial operations of the district are established within the parameters of all federal, state and local reporting requirements. An annual audit is performed at the direction of the Board of Education with direct reporting of audit results to a community-based audit review team, also facilitated by Board of 64
Education members. The audit review team performs an in-depth review of the audit process, audit report and accompanying letter to district management. During the 2012-13 school year, the district was randomly selected for audit by the Missouri State Auditor’s Office (SAO). The review from the SAO lead to recommendations in five areas of district operation. The Board of Education responded to each SAO recommendation and directed practice changes where applicable and necessary. The SAO gave the district an audit rating of “good”. The Board of Education appoints a Finance Committee comprised of two Board members, the superintendent and associate superintendent of business and operations. These team members are tasked with the monthly review of revenue, expense, fund balance, investments and finance/facility issues. The Board of Education Finance Committee members report to the full Board of Education during the regular monthly meeting and include the detailed accounting of the items discussed during the finance meeting. The Board of Education dedicates a portion of each monthly meeting to finance. In addition, annual work sessions are held to discuss and determine short- and longterm finance and facility planning. Per Board of Education policy DB, the adopted budget serves as the control to direct and limit expenditures in the district. Overall responsibility for assuring control rests with the superintendent, who will establish procedures for budget control and reporting throughout the district. All moneys received by the school district shall be disbursed only for the purposes for which they are levied, collected or received. The Board of Education has set a minimum goal of 15 percent for the fiscal year ending fund balance.
LOCAL REVENUE SOURCES The 2017-18 school year revenue budget includes estimates for tuition paid by surrounding school districts sending their students to attend Summit Technology Academy (STA). Approximately 202 students attend the half-day program at the tuition rate of $1,750 per student. The enrollment at STA for students from other school districts is projected to remain consistent over the next four budget years. The Missouri Innovation Campus, home of STA, will provide a partnership with the University of Central Missouri (UCM). UCM will be renting facility space for its programs which will be another source of revenue for the school district. The amount of revenue will be determined following building completion, not finalized at the time of budget preparation.
65
SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The Lee’s Summit R-7 School District was established under the Statutes of the State of Missouri. The District operates as a "six director" district (with seven members of the Board of Education) as described in Chapter 162, of the Revised Statutes of Missouri.
REPORTING ENTITY The financial reporting entity consists of (a) the primary government, (b) organizations for which the primary government is financially accountable, and (c) other organizations for which the primary government is not accountable, but for which the nature and significance of their relationship with the primary government are such that exclusion would cause the reporting entity’s financial statements to be misleading or incomplete. Component units are legally separate organizations for which the elected officials of the primary government are financially accountable. Financially accountable means the primary government is accountable for the component unit and the primary government is able to impose its will or the component unit may provide financial benefits or impose a burden on the primary government. In addition, component units can be other organizations for which the nature and significance of their relationship with the primary government are such that exclusion would cause the reporting entity’s financial statements to be misleading or incomplete. Based upon the application of these criteria, the District has determined that no other outside agency meets the above criteria and, therefore, no other agency has been included as a component unit in the District’s budget. In addition, the District is not aware of any entity which would exercise such oversight that would classify the District as a component unit of the entity.
FUND ACCOUNTING The accounts of the District are organized on the basis of funds, each of which is considered to be a separate accounting entity. The operations of each fund are summarized by providing a separate set of self-balancing accounts that include the assets, liabilities, and fund balances arising from revenues and expenditures. 66
The General (Incidental) Fund is used to account for all financial resources except those required to be accounted for in another fund. This fund accounts for transactions involving local taxes; Foundation Program payments such as Basic Formula, Transportation, Early Childhood Special Education, Career Ladder, Educational Screening Entitlement/PAT, and Vocational/AtRisk; along with various other transactions associated with federal projects. The Special Revenue (Teachers) Fund is used to account for revenue sources Katie L., Lee's Summit High School legally restricted to expenditures for the purpose of teachers' salaries and benefits and tuition payments to other school districts. The Capital Projects Fund is used to account for all facility acquisition, construction, lease purchase principal and interest payments, and other capital outlay expenditures. Expenditures for ordinary repairs to school property are not expensed to the Capital Projects Fund. Capital expenditures are defined as expenses paid or incurred for the acquisition or repair of assets that will remain useful for more than one year. Revenue placed in the Capital Projects Fund comes from the following sources: • tax rate set in the Capital Projects Fund • bond sale proceeds • net insurance recoupment for a capital loss • money received from the sale of capital assets including real estate, furniture, and equipment • inter-fund transfers • money received from any other source for buildings, equipment, lease purchase obligations, or other capital purposes The Debt Service Fund is used to account for the resources accumulated for and the payment of long-term debt. Amounts in the Debt Service Fund are generated from the Debt Service Fund tax levy and are used solely to retire bonded debt. Paying agent fees are included as an expense of the Debt Service Fund. Other expenses associated with the issuance of bonds are paid from the various funds based on the type of bond issue (a new issue or a refunded issue).
67
The Student Activities Fund is used to account for monies held by the District in a trustee capacity for individual student groups. The school board is responsible for all student activity funds in the district and are budgeted and controlled in the same manner as other governmental funds. The Child Nutrition Services Fund is used to account for all Child Nutrition program transactions (school meals) as well as Federal and State free and reduced student lunches and is budgeted and controlled in the same manner as all other funds.
BASIS OF ACCOUNTING The District's policy is to operate its budget and monthly financial statements on the modified cash basis of accounting. Revenues are recognized in the accounting period in which they are received. Expenditures are recognized in the accounting period in which the expense is made.
INVENTORIES Inventories are valued at average cost and consist of purchased food, Meghan F., Lee’s Summit North High School supplies and donated government commodities. The cost is recorded as an expenditure at the time the inventory is delivered to the ordering budget manager. Reporting inventories are equally offset by a fund balance reserve, which indicates they are unavailable for appropriation. Changes are made at year-end in accordance with the physical inventory and reconciliation to the general ledger.
CASH AND TEMPORARY INVESTMENTS The District maintains a cash and temporary investment pool that is available for use by all funds except the Debt Service Fund. State law requires that all deposits of the Debt Service Fund be maintained in a separate account. The District also keeps bond issue funds in a separate account. Investments of the pooled accounts consist primarily of repurchase agreements, carried at fair value, which approximates cost. Interest income, when earned, is allocated to individual funds based upon cash and temporary balances. Missouri statutes require that all deposits with financial institutions be collateralized. The Board authorizes the treasurer and the finance department to direct the investment management of district funds not needed for the daily operation of the district. Board policy outlines the type(s) of allowable investments and other pertinent requirements for the investment of district funds. Monthly, the Board of Education reviews a list of investments. 68
TAXES Property taxes attach as an enforceable lien on property as of January 1 . Taxes are levied on November 1 and are payable by December 31. All unpaid taxes become delinquent January 1 of the following year. The county collects the property taxes and remits them to the District on a weekly basis. The majority of these tax revenues are received in late December and through mid-February.
CHANGES IN LONG-TERM DEBT Article VI, Section 26(b), Constitution of Missouri, limits the outstanding amount of authorized general obligation bonds of a district to fifteen percent of the assessed valuation of a district, including state-assessed railroad and utilities.
EMPLOYEE COMPENSATION The salary payment schedule of the District requires the payment of salaries and benefits over a twelve-month period for all employee groups. The payrolls for the final three months of the fiscal year are included as expense for the applicable fiscal year.
PENSION PLANS The District contributes to the Public School Retirement System of Missouri (PSRS), a cost sharing multiple employer defined benefit pension plan. Positions covered by the PSRS are not covered by Social Security. PSRS benefit provisions are set forth in Chapter 169.010-169.14, RSMo. PSRS members are required to contribute 14.5 percent of their annual covered salary and district-paid health and dental insurance premium. The District is required to contribute a matching amount. The contribution requirements of members and the District are established and may be amended by the PSRS Board of Trustees. The District also contributes to the Public Education Employee Retirement System of Missouri (PEERS), a cost sharing multiple-employer defined benefit pension plan for eligible employees. PEERS provides retirement and disability benefits to employees of the District who work 20 or more hours per week and who do not contribute to the PSRS. Certain part-time certified employees may be covered by this plan. Benefit provisions are set forth in Chapter 169.600-169.715, RSMo. PEERS members are required to contribute 6.86 percent of their annual covered salary and the District is required to contribute a matching amount.
DEFERRED COMPENSATION PLAN The District offers all employees a choice of deferred compensation plans created in accordance with Internal Revenue Code Sections 457(b) or 403(b) through the CSD Retirement Trust. 69
POST EMPLOYMENT BENEFITS The District provides COBRA benefits u nder the Consolidated Omnibus Budget Reconciliation Act (COBRA), to eligible former employees and eligible dependents. Certain requirements are outlined by the federal government for this coverage. The District utilizes a third party administrator to manage the day-to-day operations of the COBRA and retiree benefits. The District offers continued healthcare benefits to retired employees who elect to participate. The retiree pays the premium. There is no additional charge to the District for this state-law mandated benefit.
INSURANCE PROGRAM The District, along with various other local school districts, participates in the Missouri United School Insurance Council ("MUSIC"), an insurance association for workers' compensation, general liability, and property casualty insurance. MUSIC requires an annual premium payment to cover estimated claims payable and reserves for claims for each entity. Part of the assessment purchases group excess insurance contracts.
INTERFUND TRANSFERS Section 165.011, RSMo, and administrative interpretations provide for several interfund transfers that a school district may make. The 2017-18 budget includes interfund transfers from the General Fund to the Teachers Fund. This transfer is required for statutory compliance since the Teachers Fund has a zero beginning fund balance and statutes require the District to transfer an amount sufficient to cover all expenditures that are not covered by another source of revenue. An interfund transfer is also budgeted from the General Fund to the Capital Projects Fund for expenses not covered by another source of revenue. The annual amount of transfer is capped by DESE, with the calculation performed by DESE and finalized on June 30, 2018. The preliminary transfer amount calculated by DESE for 201718 is $7,496,503 with the District budgeting a transfer of $2,641,989.
FUND BALANCE Fund balance has been a continual area of focus for the Board of Education and administrative team. Using an analysis of cash flow, the Board of Education has set a minimum fund balance at 15% of operating expenditures. A balance of 15% or more allows the District to meet its expenditure obligations during the months (July through December, annually) of the fiscal year in which minimal revenue is received.
70
FINANCIAL SECTION Budgets are financial planning and decision-making documents. The Financial Section is the heart of the budget document. The budget financial schedules present the adopted budget compared to the past actual revenues and expenditures.
L. Holderman, Lee's Summit West High School
A. Lock, Lee's Summit West High School
L. Turner, Lee's Summit West High School Tori Barnes, Campbell Middle School
71
The District adheres to the same system of accounting for budgeting and recording of actual revenues and expenses. Annually, the District is required to report to the Missouri DESE on revenue by object and expenditures by function and by object. The District also utilizes additional program codes to further identify specific revenues and expenses. The District uses budget manager/security codes to restrict access to accounts and to route and secure approval of purchasing transactions.
SIGNIFICANT REVENUE SOURCES The following explanations cover the major local, county, state and federal revenues which are allocated to the General, Teachers, Debt Service and/or Building Funds according to the tax levy associated with each fund or at the discretion of the Board of Education. Other revenues are particular to the funds that they support. Property Taxes–Funds derived from taxing the assessed values of real and personal property within the District based upon the authorized tax levy. The growth in property taxes has been budgeted based on the estimated assessed value, the type of assessment growth and the projected tax levy using the historic rate of collection. Sales Taxes (Proposition C)–Funds received from the state based upon the portion of the state sales tax appropriated to school districts. Even though these funds are received from the state, they are considered a local source of revenue. The District is required to “roll back” the local tax levy equivalent to 50 percent of the sales tax revenue received the prior year. This allocation is based on a per student amount determined on an annual basis. Sales taxes have been budgeted based on conservative growth per WADA using the projected increases in student attendance. Basic Formula–Amount received from the state based upon the State Foundation Formula. This estimate is based on average daily student attendance, a State Adequacy Target (SAT) of $6,200. The final SAT for the 2016-17 school year was calculated at $6,199. Classroom Trust Fund– Amount received from the state based upon the State Foundation Formula attributable to gaming proceeds is estimated to remain unchanged from the prior year. Federal Funds–Funds received from various federal sources for categorical programs comprise virtually all of the federal funds received by the District, overall, approximately 4% of the budgeted revenue. This source of revenue remains unchanged as a percent of the total revenue budget.
72
REVENUE The total revenue budget for 2017-18 is estimated to increase by $4.8 million (2.06%) to a total of $242 million when compared to the 2016-17 revenue projection. The significant operating fund revenue components, which account for slightly over 87 percent of the operating revenue in the 2017-18 budget, are received in the three revenue areas identified below: Local Property Taxes – Increase estimated at $2.5 million (2.9% increase)
Local property tax revenue is recorded in the General, Debt Service and Capital Projects fund, based on the levy apportioned to each fund. The budget includes an estimated total levy of $5.8618, a decrease from the 2016-17 school year. The tax rate was calculated using an assessed valuation of $1,942,772,167, a 6.24 percent increase from the prior year’s certified assessed values. The increase in assessed value is projected to result from increases in new construction, as 2017 is a reassessment year. The new construction increase has been estimated by the District, using housing permit data provided by the City of Lee’s Summit. The District also expects a slight increase in personal property values. The final tax rate will be established, using forms provided by the Missouri State Auditor’s Office, after certified values from Jackson and Cass Counties are provided, prior to October 1, 2017, as required by Missouri Statute.
Local tax collection is budgeted at a rate of 95.5 percent of total taxes assessed. Proposition C Sales Tax – Increase estimated at $401,751 (2.41% increase) The Missouri Department of Elementary and Secondary Education estimates the amount of funding per weighted ADA (WADA) will be approximately $988, an increase of approximately nine dollars per WADA from the prior year. For 201718, the District is budgeting $988 per previous year WADA, which results in a projected increase in this revenue area due to increased student enrollment and an increase in the per student amount. All Proposition C sales tax revenue is recorded in the Teachers Fund. State Basic Formula – Minimal increase estimated at $72,215 (0.10% increase) Basic Formula revenues (including the Classroom Trust Fund) are projected using a State Adequacy Target (SAT) of $6,200. This category of revenue shows a slight increase due to student enrollment growth. The calculation includes a decrease in the dollar value modifier (DVM) from 1.084 in 2016-17 to 1.081 for 2017-18. A total enrollment growth of 230 students (1.28 percent increase from the 2016-17 school year enrollment). The “official” 2017-18 student enrollment number is based on the last Wednesday in September, consistent with reporting to the Missouri Department of Elementary and Secondary Education. All Basic Formula revenue is recorded in the Teachers Fund. Other categories of revenue are estimated based on historical and prior year receipt patterns and District allocations of revenue, impacting the General, Teachers, Capital Projects and Debt Service Funds. Specifically: 73
Other local revenue is budgeted to increase in revenue categories of other taxes and miscellaneous local sources including nutrition services. County increases are indicative of state assessed utility changes. Other state revenues are expected to decrease primarily due to a reduction in state funds available to reimburse for high cost special education students. Federal revenue shows an increase based on the reimbursement from energy grant funds for the purchase of compressed natural gas buses. Revenue in the Nutrition Services Fund is impacted by an increase in student meal prices ranging from five to ten cents. The prices for adult meals increased by 15 cents for regular meals and 50 cents for premier meals. The department is estimating student and adult participation to remain consistent with prior year numbers. Revenue in the BASS Fund is impacted by the number of children participating in programs offered. The BASS program did not increase tuition fees for the 2017-18 school year. It is anticipated the number of children serviced by the program will remain consistent. Revenue in the Student Activity Fund is expected to remain stable, with the exception of a slight reduction due to the elimination of a $10 programming/activity fee for middle and high school students.
REVENUE FORECAST Budget forecasting is an essential tool for long term planning of the District's funds. Revenue projections are based on information currently available and certain estimates are based on historical information. The projections have been carefully reviewed; however, actual results may vary from the forecasts. The District evaluates the revenue forecasts on a continual basis in order to provide the most current information available based on new information presented to the District. Variations between actuals and forecasts could have a positive or negative impact. Below is a summary of the major revenue assumptions used to project the 2018-19 through 2020-21 estimates: 1. The forecast for 2018-19 and 2020-21 (non-reassessment years) is based on an estimated increase in assessed valuations of 1.00%. For the 2019-20 school year, the assessed value is expected to increase by 3%. The changes in assessed value are projected to impact the tax rate slightly for each of these budget years. The projected rates are: $5.8762 for 2018-19, $5.8102 for 2019-20 and $5.8246 for 2020-21. The assessed values and tax rates will impact the General Fund, Debt Service Fund and Capital Projects Fund, as each of these funds have a tax rate associated with the fund. 2. The Foundation Formula and Classroom Trust revenue forecast factors are estimated to increase slightly at an average of 0.70% each year. Projected student enrollments are used to determine WADA. 3. Proposition C sales tax revenue is expected to increase by approximately 2% 74
based on increasing student enrollment numbers and modest projections in the per student amount (WADA), estimated on historical trends for this revenue source. 4. Other county, state and federal revenues remain relatively flat. 5. Revenue in the Nutrition Services Fund is impacted by anticipated student meal price increases ranging from approximately five to ten cents. The department is estimating student and adult participation to remain consistent. 6. Revenue in the BASS Fund is impacted by the number of children participating in programs offered. The BASS program is not expecting to increase tuition fees through 2020-21. The number of children serviced by the program is projected to remain relatively stable. 7. Revenue in the Student Activity Fund is expected to remain stable.
SIGNIFICANT EXPENDITURE CATEGORIES Salaries–Amounts paid to employees for services rendered. The budgeted combined overall increase of approximately 2.8 percent resulted from the salary adjustments given to District employees for education and salary schedule improvements. Benefits–Amounts paid on behalf of employees for retirement, Medicare, medical insurance, workers’ compensation, unemployment compensation, life and disability insurance, and tuition reimbursement. The total budget for benefits is expected to remain stable due to changes to worker’s compensation made at the beginning of the fiscal year. Purchased Services–Services that are professional and technical in nature. These expenditures are budgeted to remain consistent with prior year. Supplies–Expenditures for all supplies for the District. Supply costs are expected to increase. This increase is due to the increase in food costs, utility costs, supply costs and staffing levels. Capital Outlay–Expenditures for the acquisition of fixed assets, including land, buildings and major equipment. Long and Short Term Debt–Expenditures for the retirement of debt, the payment of interest on debt, and the payment of fees.
EXPENDITURES All funds where salary and benefits are recorded are impacted by the salary and benefit changes approved for the 2017-18 school year and listed below, including the following funds: General (Incidental), Special Revenue (Teachers), Nutrition Services, BASS and Student Activity. The budget includes salary and related benefit increases of $5.2 million for District 75
employees. Employee salary schedules base increases are indicated in the table below, employees did not receive step movement for longevity. Schedule
Base Increase
Percent Increase
Administrator Professional Support Teacher
$0.80 per hour $0.59 per hour $0.35 per hour $1,500 annual
3.32% 3.46% 3.46% 3.57%
Salary adjustments provided to District employees earning advanced degrees. Targeted salary increases for extra duty contracts, with non-scheduled salary increases tied to the average total salary increase. The salary impact is estimated at $576,148. A salary schedule was formalized for various types of hourly pay for certified and support staff. In addition, salaries were development for online class instructors and for instructors of college credit courses. The estimated increase to implement this hourly salary schedule equals $182,000. Total district-wide additional net 37.49 FTE staff positions, an estimated cost increase of $1,863,144. The budget impact is offset by redirection of $758,149 in existing resources, resulting in a net budget expense increase of $1,104,995. Benefit increases include a projected eight percent for health insurance for the plan year beginning on January 1, 2018. In addition, the budget includes increases in benefits tied to salary including state-mandated retirement, social security/Medicare, life insurance and disability insurance. Total budgeted expenditures in the operating funds increased by $7.9 million or 4.17 percent from the projected 2016-17 budget due to increases in employee salaries, additional staff, benefits, increases in general instructional materials, supplies and other site operating expenses due to student enrollment growth and operational increases. The increases for expenses other than salary and benefit will impact the General (Incidental) fund. The District budgeted for a $1.5 million decrease in the Operating (combined General and Teachers) fund balance for the year. This decrease will make the projected ending reserve balance 27.74 percent, which remains well above the targeted minimum fund balance of 15 percent. The ending fund balance is equivalent to 3.33 months of operating expenses. The Capital Projects fund budget includes estimated expenses of $7.8 million and includes lease purchase payments for multiple projects approved in prior years. Expenditures include funding for instructional, music and regular equipment budgeted at the site level on a per student allocation. District-wide needs are restricted to funding for the Capital Projects Team, equipment tied to additional staff positions, and funds to repay the lease purchase of technology, compressed natural gas (CNG) school buses, facility site and CNG maintenance vehicles. Funding in the Capital Fund is achieved through the resources provided by a $0.05 levy and a budgeted transfer from the Incidental Fund to the Capital Projects fund. The District was able to address a number 76
of maintenance projects with revenue received from the 2015 bond issue, to preserve and build the fund balance in the Capital Projects fund. During the 2017-18 school year, the process to revise the District’s Comprehensive Facility Master Plan (CFMP) will begin, consistent with the Board of Education’s priority number 2. Updated student demographic data will be received during November 2017 and will be the primary focus for the District’s short term (one to three years) planning to address facility space needs. For the 2017-18 school year, student enrollment uses approximately 85 percent of the district-wide school site capacity. With projected student enrollment increases, facility needs are an immediate concern. To address the board of education’s priority number 2, a CFMP team will be established and will begin addressing identified parameters in terms of 21st century learning spaces. Previously identified major building projects including elementary, middle and high schools are expected to be part of the CFMP team’s planning work. The District currently has two parcels of land designated as future school sites. Funding for the projects identified in the CFMP will be primarily from general obligation bonds. In the Bond Fund, the remaining bond proceeds from the issue approved by voters in April 2015, approximately $5.2 million will be used to complete the remaining projects identified at the election, with the remaining bond proceeds prioritized by the board of education during the 2017-18 school year. The 2017-18 budget includes the balance of the 2015 bond issue resources as a current year expense. The Debt Service Fund expenses for 2017-18 are increased by approximately $41.3 million dollars for a payment related to a prior year refunded bond. The funds to make this payment reside in the Debt Service fund balance. Section 165.011, RSMo, and administrative interpretations provide for several interfund transfers that a school district may make. The 2017-18 budget includes interfund transfers from the General Fund to the Teachers Fund for expenses in the Teachers Fund in excess of current revenue. This transfer is required for statutory compliance since the Teachers Fund has a zero beginning fund balance and statutes require the District to transfer an amount sufficient to cover all expenditures that are not covered by another source of revenue. An interfund transfer is also budgeted from the General Fund to the Capital Projects Fund for expenses not covered by another source of revenue. The annual amount of transfer is capped at a maximum of $162,326 or 7% multiplied by the SAT, multiplied by the WADA. This calculation is performed by DESE and finalized on June 30, 2018. The preliminary transfer amount calculated by DESE for 2017-18 is $7,496,503 with the District budgeting a transfer of $2,641,989.
77
EXPENDITURE FORECAST Expenditure projections are based on information currently available regarding the identified future needs of the District and historical spending patterns. The projections have been carefully reviewed; however, actual results may vary from the forecasts. The District also evaluates the expense forecasts on a continual basis in order to provide the most current information available based on new information and factors impacting the forecasting process. Variations between actuals and forecasts could have a positive or negative impact. Below is a summary of the major expenditure assumptions used to project the 2018-19 through 2020-21 estimates. Salary and benefit assumptions impact the General, Teachers, Nutrition Services, BASS and Student Activity Funds: 1. Expense budgets include equivalent salary schedule step increases averaging approximately two percent per year. 2. Salary and benefit cost for additional staff, based on projected student enrollment growth and other District factors, estimated at an average increase of 0.85%. 3. Health insurance increases estimated at eight percent per year. 4. In the General Fund, minimal increases in materials and supplies tied to student enrollment growth. 5. At this time, increased expenses are planned in the Capital Projects Fund in anticipation of the completion of the long-range Capital Improvement Plan during the 2017-18 school year. Lease purchase principal and interest payments will continue, at declining levels, through the 2025-26 school year. 6. The Debt Service Fund reflects the principal and interest payments based on current outstanding debt. 7. The Bond Fund shows expense of $288,291 for the 2018-19 school year which represents the remaining resources generated by the 2015 bond issue. At this time, no additional general obligation bonds are scheduled through the 2020-21 school year.
78
BUDGET SCHEDULES The following pages present the budget schedules for all budgeted funds within the District. In each schedule, information is presented for the four prior years, the budget year and three projected budget years. The schedules are presented for all funds in the District, followed by the detail for each individual fund.
COMBINED ALL DISTRICT FUNDS Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
REVENUE Local Property Tax Prop C Sales Tax
$100,157,328 $101,530,561 $103,543,970 $107,586,948 $111,968,512 $114,408,616 $116,517,316 $117,974,154 $14,831,594
$15,452,501
$15,947,083
$16,680,976
$17,082,727
$17,327,655
$17,766,910
$18,210,556
Other Tax
$5,545,951
$5,241,277
$5,371,215
$5,795,128
$5,671,895
$5,735,588
$5,799,998
$5,865,132
Interest
$4,293,013
$5,446,037
$6,448,880
$2,058,444
$2,053,310
$2,054,337
$2,055,364
$2,056,392
Nutrition Services
$4,624,348
$4,633,357
$4,760,086
$5,688,958
$5,150,500
$5,183,722
$5,217,158
$5,250,810
Other Miscellaneous
$10,695,741
$10,413,069
$11,761,487
$11,679,945
$12,203,782
$12,627,412
$13,071,208
$13,369,973
Sale/Refunded Bonds
$29,345,000
$71,780,000
$40,000,000
$0
$0
$0
$0
$0
County Fines, Forfeitures State Assessed Utility
$127,371
$161,033
$139,534
$194,838
$164,761
$181,237
$199,361
$219,297
$3,423,547
$3,741,123
$3,884,135
$3,969,401
$4,233,319
$4,402,060
$4,577,527
$4,759,988
State Basic Entitlement
$57,404,484
$59,741,574
$62,240,455
$67,239,663
$66,717,189
$69,205,084
$72,150,584
$74,088,161
Transportation
$1,781,606
$2,059,419
$1,562,476
$1,214,750
$1,215,000
$1,215,608
$1,216,215
$1,216,823
Early Special Education
$1,842,843
$2,218,677
$2,883,505
$3,516,491
$3,076,411
$3,414,816
$3,790,446
$3,979,968
Other
$2,999,230
$2,845,763
$2,443,815
$2,399,362
$2,794,035
$2,830,029
$2,868,386
$2,909,260
Medicaid/Title/Grants
$1,757,923
$2,861,009
$2,733,966
$2,590,690
$2,968,577
$3,233,653
$3,540,759
$3,896,972
Nutrition Services
$2,132,975
$2,181,662
$2,225,802
$2,436,439
$2,441,200
$2,527,970
$2,617,824
$2,710,872
Special Education
$3,351,502
$3,838,313
$3,367,165
$3,331,592
$3,134,394
$3,154,060
$3,178,868
$3,199,820
$782,667
$487,131
$405,161
$892,387
$1,285,288
$1,002,992
$1,077,611
$1,233,309
Federal
Other TOTAL REVENUES
$245,097,123 $294,632,506 $269,718,736 $237,276,012 $242,160,900 $248,504,839 $255,645,535 $260,941,487
EXPENDITURES Instructional Services Employee Salaries & Benefits
$101,078,270 $107,748,656 $110,616,443 $113,576,395 $119,694,794 $122,428,823 $125,031,263 $127,571,671
Purchased Services
$5,208,349
$7,684,229
$7,166,529
$6,822,180
$6,842,646
$6,925,531
$7,000,863
$7,064,188
Materials & Supplies
$5,398,631
$5,229,674
$5,478,476
$5,438,340
$5,455,743
$5,521,322
$5,598,349
$5,659,999
$502,758
$457,663
$468,922
$693,298
$793,436
$793,575
$793,714
$793,853
Equipment Student Support Services Employee Salaries & Benefits
$7,034,341
$6,442,815
$7,348,779
$8,158,363
$8,484,698
$8,737,064
$8,982,023
$9,209,473
Purchased Services
$95,405
$199,297
$254,457
$219,357
$220,015
$225,582
$235,145
$247,950
Materials & Supplies
$142,587
$106,838
$83,936
$106,245
$106,585
$109,260
$113,869
$120,046
Equipment
$1,495
Instruction Support Services Employee Salaries & Benefits
$4,064,044
$3,914,125
$4,170,017
$4,195,580
$4,363,403
$4,468,350
$4,572,340
$4,672,947
Purchased Services
$582,678
$1,031,377
$1,150,218
$1,161,998
$1,165,484
$1,186,718
$1,205,721
$1,220,946
Materials & Supplies
$706,750
$569,198
$726,333
$781,195
$783,695
$803,366
$837,256
$882,673
$18,740
$54,323
$22,941
$15,090
$15,093
$15,096
$15,099
$15,102
Equipment General Support Services Employee Salaries & Benefits
$1,560,837
$1,675,424
$1,982,352
$1,858,492
$1,932,831
$1,978,291
$2,023,446
$2,067,334
Purchased Services
$802,734
$684,982
$532,771
$708,066
$752,527
$771,559
$788,489
$801,755
Materials & Supplies
$61,911
$19,955
$20,164
$93,275
$93,573
$95,922
$99,969
$105,391
$998,485
$7,183
$15,296
$25,460
$25,465
$25,470
$25,475
$25,480
Equipment
79
COMBINED ALL DISTRICT FUNDS Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
EXPENDITURES (Continued) School Administration Employee Salaries & Benefits
$6,919,066
$7,483,147
$7,822,216
$7,871,414
$8,186,271
$8,372,236
$8,557,662
$8,739,214
Purchased Services
$88,299
$105,427
$112,774
$119,887
$120,247
$123,290
$128,516
$135,514
Materials & Supplies
$151,710
$142,252
$163,410
$227,546
$228,274
$234,004
$243,875
$257,104
Employee Salaries & Benefits
$4,669,617
$5,491,792
$6,605,758
$6,050,962
$6,293,001
$6,533,075
$6,761,582
$6,965,130
Purchased Services
$1,741,038
$2,108,726
$3,013,910
$4,308,679
$4,321,605
$4,430,233
$4,526,871
$4,602,622
Materials & Supplies
$1,429,753
$347,133
$240,334
$546,621
$548,370
$562,134
$585,848
$617,627
$341,828
$29,218
$86,775
$90,831
$90,849
$90,868
$90,886
$90,904
Equipment Central Services
Equipment Operation and Maintenance Employee Salaries & Benefits
$12,021,294
$12,189,467
$11,895,900
$11,996,157
$12,746,003
$13,291,610
$13,705,597
$14,121,545
Purchased Services
$1,725,888
$1,990,299
$1,699,314
$3,213,047
$3,222,686
$3,304,233
$3,444,307
$3,631,866
Materials & Supplies
$4,717,709
$4,879,422
$4,248,502
$4,647,766
$4,662,639
$4,779,671
$4,981,301
$5,282,347
Equipment
$1,732,247
$1,769,322
$200,097
$181,194
$181,231
$181,267
$181,303
$181,339
$6,293,263
$6,519,596
$6,719,041
$6,883,647
$7,578,992
$7,730,466
$8,168,807
$8,731,891
$857,330
$814,059
$729,578
$895,661
$898,348
$921,080
$960,127
$1,012,410
Transportation Services Employee Salaries & Benefits Purchased Services Materials & Supplies Equipment
$965,648
$1,058,066
$1,063,155
$1,280,537
$1,284,635
$1,316,879
$1,372,432
$1,446,880
$1,731,341
$1,805,330
$2,492
$1,695,977
$10,000
$10,250
$10,506
$10,769
$4,319,170
Nutrition Services Employee Salaries & Benefits
$3,588,533
$3,839,696
$3,917,978
$3,974,747
$4,130,496
$4,192,453
$4,255,340
Purchased Services
$89,384
$134,476
$118,716
$95,894
$88,700
$90,000
$91,314
$92,647
Materials & Supplies
$2,972,196
$3,080,732
$3,051,366
$2,985,325
$3,357,000
$3,404,669
$3,451,994
$3,503,774
$218,464
$57,192
$63,940
$117,290
$75,000
$76,050
$77,107
$78,264
Equipment Community Services Employee Salaries & Benefits
$3,470,657
$3,853,211
$3,967,858
$3,967,744
$4,106,616
$4,208,116
$4,308,819
$4,406,008
Purchased Services
$166,184
$273,575
$236,843
$230,852
$231,545
$233,996
$236,265
$238,226
Materials & Supplies
$354,570
$371,593
$324,406
$473,652
$475,167
$483,312
$490,594
$496,429
$61,781
$69,244
$5,040
$5,995
$5,996
$5,997
$5,999
$6,000
$1,226,003
$890,678
$12,077,093
$20,756,121
$6,739,372
$5,325,994
$5,405,884
$5,486,972
$24,101
$53,572
$2,377,995
$1,134,922
$103,400
$100,000
$100,000
$100,000
$100,000
$3,091,375
$60,000
$407,570
$26,518
Equipment Site/Facility Improvements Construction Contracts Equipment Land Purchase Purchased Services Bond and Lease Payments Bond/Lease Principal
$42,441,347
$45,641,448
$41,594,295
$18,667,335
$61,309,985
$18,616,625
$17,082,949
$16,790,108
Bond/Lease Interest
$9,419,234
$8,710,739
$9,162,802
$8,839,664
$8,361,761
$5,693,681
$5,196,996
$4,735,644
$227,575
$443,310
$143,139
$4,292
$10,000
$10,000
$10,000
$10,000
Other Costs TOTAL EXPENDITURES
$237,902,578 $250,078,461 $265,181,306 $255,205,105 $290,098,178 $248,408,119 $251,755,903 $256,549,216
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
ENDING FUND BALANCE
$105,016,182 $112,210,728 $156,764,773 $161,302,203 $143,373,110
$95,435,832
$95,532,552
$99,422,184
-$17,929,093
-$47,937,278
$96,720
$3,889,632
$4,392,271
$112,210,728 $156,764,773 $161,302,203 $143,373,110
$95,435,832
$95,532,552
$7,194,545
$44,554,046
$4,537,430
$99,422,184 $103,814,455
The total fund balance shows a decrease from 2016-17 to 2017-18 due to the Debt Service fund balance reducing for a refunded bond payment during FY18 of approximately $43 million, a planned reduction in the General Fund of approximately $700,000, and a reduction in the Bond Fund for expending the majority of the remaining bond resources. Based on projections, the total fund balance will be increasing through FY21. 80
GENERAL (INCIDENTAL) FUND The General Fund accounts for general activities or other activities except those required to be accounted for in the Special Revenue, Debt Service or Capital Projects.
GENERAL (INCIDENTAL) FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$81,654,664
$82,947,422
$84,155,964
$87,489,707
$90,574,958
$92,602,406
$94,056,920
$95,289,153
Other Tax
$979,583
$1,107,977
$1,796,675
$1,210,031
$2,096,957
$2,028,265
$2,046,519
$2,201,943
Interest
$820,861
$745,036
$708,251
$742,467
$771,700
$784,750
$794,598
$805,000
Other Miscellaneous
$507,795
$2,134,016
$2,317,327
$3,768,420
$3,527,000
$3,894,559
$4,185,316
$4,353,249
REVENUE Local Property Tax
County Fines, Forfeitures
$12,513
$14,366
$7,217
$2,521,375
$2,758,942
$2,854,670
$2,909,914
$3,056,879
$3,178,727
$3,305,432
$3,437,188
Transportation
$1,781,606
$2,059,419
$1,562,476
$1,214,750
$1,215,000
$1,215,608
$1,216,215
$1,216,823
Early Special Education
$1,842,843
$2,218,677
$2,883,505
$3,142,525
$930,631
$1,058,593
$1,175,038
$1,233,790
$819,992
$887,494
$777,125
$859,272
$1,055,002
$1,092,536
$1,135,763
$1,371,531
Medicaid/Title/Grants
$1,571,720
$2,448,450
$2,184,658
$1,229,196
$1,144,693
$1,666,424
$1,885,829
$2,122,784
Special Education
$3,351,502
$3,833,313
$3,367,165
$3,156,484
$2,827,794
$2,864,260
$2,885,618
$2,905,880
$1,000
$750
$2,960
$347,288
$532,992
$607,611
$763,309
State Assessed Utility State
Other Federal
Other TOTAL REVENUES
$95,864,453 $101,156,112 $102,615,782 $105,725,725 $107,547,902 $110,919,120 $113,294,859 $115,700,650
EXPENDITURES Instructional Services $10,549,459
$10,700,099
$12,743,198
$12,934,616
$14,377,755
$15,114,336
$15,679,489
$16,143,556
Purchased Services
Employee Salaries & Benefits
$2,006,743
$4,591,454
$2,561,556
$2,385,097
$2,378,256
$2,412,455
$2,434,655
$2,445,683
Materials & Supplies
$2,963,152
$2,787,350
$2,966,193
$2,834,130
$2,874,743
$2,922,322
$2,996,429
$3,018,765
Student Support Services $3,487,352
$2,983,958
$3,819,873
$4,282,163
$4,472,830
$4,648,970
$4,816,256
$4,964,556
Purchased Services
Employee Salaries & Benefits
$95,405
$199,297
$254,457
$219,357
$220,015
$225,582
$235,145
$247,950
Materials & Supplies
$142,587
$106,838
$83,936
$106,245
$106,585
$109,260
$113,869
$120,046
$906,673
$597,967
$1,011,638
$1,024,716
$1,081,559
$1,124,150
$1,164,601
$1,200,461
Purchased Services
$582,678
$1,031,377
$786,761
$758,961
$758,417
$773,871
$787,136
$796,082
Materials & Supplies
$706,750
$569,198
$726,333
$781,195
$783,695
$803,366
$837,256
$882,673
Instruction Support Services Employee Salaries & Benefits
General Support Services Employee Salaries & Benefits
$376,110
$462,815
$451,966
$405,189
$428,663
$445,544
$461,576
$475,789
Purchased Services
$802,734
$684,982
$532,771
$707,566
$752,027
$771,059
$787,989
$801,255
Materials & Supplies
$61,911
$19,955
$20,164
$93,275
$93,573
$95,922
$99,969
$105,391
School Administration $1,206,534
$1,346,758
$1,364,343
$1,404,433
$1,492,945
$1,551,737
$1,607,574
$1,657,074
Purchased Services
Employee Salaries & Benefits
$88,299
$105,427
$112,774
$119,887
$120,247
$123,290
$128,516
$135,514
Materials & Supplies
$151,710
$142,252
$163,410
$227,546
$228,274
$234,004
$243,875
$257,104
81
GENERAL (INCIDENTAL) FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
EXPENDITURES (Continued) Central Services Employee Salaries & Benefits
$4,261,963
$5,182,822
$6,294,468
$5,683,861
$5,913,051
$6,145,906
$6,367,057
$6,563,109
Purchased Services
$1,741,038
$2,108,726
$3,001,876
$4,273,251
$4,285,822
$4,393,942
$4,490,077
$4,565,275
Materials & Supplies
$1,429,753
$347,133
$240,334
$546,621
$548,370
$562,134
$585,848
$617,627
$14,121,545
Operation and Maintenance $12,021,294
$12,189,467
$11,895,900
$11,996,157
$12,746,003
$13,291,610
$13,705,597
Purchased Services
Employee Salaries & Benefits
$1,725,888
$1,990,299
$1,699,314
$3,213,047
$3,222,686
$3,304,233
$3,444,307
$3,631,866
Materials & Supplies
$4,717,709
$4,879,422
$4,248,502
$4,647,766
$4,662,639
$4,779,671
$4,981,301
$5,282,347
Transportation Services $6,293,263
$6,519,596
$6,719,041
$6,883,647
$7,578,992
$7,730,466
$8,168,807
$8,731,891
Purchased Services
Employee Salaries & Benefits
$825,605
$814,059
$729,578
$895,661
$898,348
$921,080
$960,127
$1,012,410
Materials & Supplies
$965,648
$1,058,066
$1,063,155
$1,280,537
$1,284,635
$1,316,879
$1,372,432
$1,446,880
$1,302,474
Community Services $1,000,257
$1,163,275
$1,277,656
$1,248,776
$1,141,040
$1,197,253
$1,251,973
Purchased Services
Employee Salaries & Benefits
$54,362
$95,326
$41,562
$53,985
$62,435
$63,628
$64,628
$65,312
Materials & Supplies
$188,639
$186,084
$154,251
$226,094
$288,717
$294,214
$298,868
$301,827
$59,353,513
$62,864,002
$64,965,011
$69,233,778
$72,802,324
$75,356,886
$78,085,356
$80,894,464
TOTAL EXPENDITURES
FUND BALANCE Beginning Fund Balance
$55,287,426
$57,038,207
$56,529,187
$56,342,094
$58,613,144
$57,966,503
$57,504,292
$58,070,280
Excess Revenue Over Expense
$36,510,940
$38,292,110
$37,650,771
$36,491,946
$34,745,578
$35,562,234
$35,209,503
$34,806,186
-$34,760,159
-$38,801,130
-$37,837,863
-$34,220,897
-$35,392,219
-$36,024,445
-$34,643,514
-$34,598,907
$57,038,207
$56,529,187
$56,342,094
$58,613,144
$57,966,503
$57,504,292
$58,070,280
$58,277,559
Transfers In/(Out)
ENDING FUND BALANCE
The General Fund Balance is estimated to decrease from FY17 to FY18 by approximately $700,000. The reduction in fund balance is a planned reduction in the District’s short and long term budget estimates to provide the salary increases and added staff for FY18. Conservative revenue and expense projections through FY21 will cause the fund balance to fluctuate each year and it will remain significantly above the minimum 15% balance needed. Within the General Fund, the District maintains a “restricted” fund balance, currently a reserve for health insurance future liability tied to the contract termination. For the 201718 school year, the Board of Education approved a transfer of $900,000 from the restricted insurance fund to the General Fund to support the salary improvements. RESTRICTED INSURANCE FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$1,809,175
$101,785
$1,809,175
$101,785
$760,444
$0
$0
$0
$0
$0
$760,444
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,809,175
$1,910,960
$2,671,404
$2,671,404
$1,771,404
$1,771,404
$1,771,404
$1,809,175
$101,785
$760,444
$0
$0
$0
$0
$0
$1,771,404
$1,771,404
$1,771,404
REVENUE Local Other TOTAL REVENUES
EXPENDITURES Transf er TOTAL EXPENDITURES
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense Transf er In/(Out)
ENDING FUND BALANCE
-$900,000 $1,809,175
$1,910,960
$2,671,404
82
$2,671,404
$1,771,404
TEACHERS (SPECIAL REVENUE) FUND The Teachers (Special Revenue) Fund accounts for expenditures for certificated employees involved in administration and instruction. It includes revenues restricted by the State for the payment of certificated salaries. This fund will continue to operate with a zero fund balance.
SPECIAL REVENUE (TEACHERS) FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$14,831,594
$15,452,501
$15,947,083
$16,680,976
$17,082,727
$17,327,655
$17,766,910
$18,210,556
$542,411
$578,941
$835,716
$865,813
$838,818
$897,535
$960,363
$1,027,588
$114,858
$146,667
$132,317
$194,838
$164,761
$181,237
$199,361
$219,297
$57,404,484
$59,741,574
$62,240,455
$67,239,663
$66,717,189
$69,205,084
$72,150,584
$74,088,161
$373,966
$2,145,780
$2,356,223
$2,615,408
$2,746,178
REVENUE Local Prop C Sales Tax Other Miscellaneous County Fines, Forfeitures State Basic Entitlement Early Special Education Other
$1,993,376
$1,773,822
$1,504,144
$1,328,853
$1,500,000
$1,500,000
$1,495,012
$1,300,000
$186,203
$264,092
$549,308
$1,361,494
$1,823,884
$1,567,230
$1,654,930
$1,774,188
$175,108
$306,600
$289,800
$293,250
$293,940
$90,579,759
$93,324,764
$97,135,818
$99,659,908
Federal Medicaid/Title/Grants Special Education Other
$205
TOTAL REVENUES
$75,073,132
$1,200 $77,957,598
$81,209,023
$88,221,911
EXPENDITURES Instructional Services Employee Salaries & Benefits Purchased Services
$97,503,197 $100,291,793 $104,988,719 $106,983,504 $109,016,191 $111,087,499
$90,323,757
$96,759,751
$1,665,999
$1,392,743
$2,826,545
$2,697,416
$2,724,390
$2,763,077
$2,801,483
$2,843,506
$3,546,989
$3,458,857
$3,528,905
$3,876,201
$4,011,868
$4,088,093
$4,165,767
$4,244,917
$3,096,525
$3,316,157
$3,158,380
$3,170,864
$3,281,844
$3,344,200
$3,407,739
$3,472,486
$363,457
$403,036
$407,067
$412,847
$418,586
$424,865
$1,530,386
$1,453,303
$1,504,168
$1,532,747
$1,561,870
$1,591,545
$500
$500
$500
$500
$500
Student Support Services Employee Salaries & Benefits Purchased Services Instruction Support Services Employee Salaries & Benefits Purchased Services General Support Services Employee Salaries & Benefits
$1,184,727
$1,212,610
Purchased Services School Administration Employee Salaries & Benefits
$5,712,453
$6,136,389
$6,457,873
$6,466,981
$6,693,326
$6,820,499
$6,950,088
$7,082,140
$407,654
$308,970
$311,290
$367,101
$379,950
$387,169
$394,525
$402,021
$12,034
$35,428
$35,782
$36,290
$36,795
$37,347
$187,181
$194,275
$201,075
$204,895
$208,788
$212,755
$1,360
$1,224
$1,300
$1,300
$1,300
$1,300
Central Services Employee Salaries & Benefits Purchased Services Community Services Employee Salaries & Benefits
$41,302
$177,710
Purchased Services TOTAL EXPENDITURES
$105,979,407 $112,763,186 $115,880,609 $118,958,123 $124,229,989 $126,575,121 $128,963,632 $131,400,880
FUND BALANCE Beginning Fund Balance Excess Revenue Over Expense Transfers In/(Out)
ENDING FUND BALANCE
$0
$0
$0
$0
$0
$0
$0
$0
-$30,906,275
-$34,805,589
-$34,671,586
-$30,736,211
-$33,650,230
-$33,250,357
-$31,827,814
-$31,740,972
$30,906,275
$34,805,589
$34,671,586
$30,736,211
$33,650,230
$33,250,357
$31,827,814
$31,740,972
$0
$0
$0
$0
$0
$0
$0
$0
83
DEBT SERVICE FUND The Debt Service Fund accounts for the accumulation of resources for, and the payment of principal, interest, and fiscal charges on general long-term debt. The current (excluding the refunded payment due this year) and future debt payments remain consistent over the next three projected budget years. These levels of principal and interest payments will be funded by the projected levy of $1.07 which remains unchanged through 2020-21.
DEBT SERVICE FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$21,672,277
REVENUE Local Property Tax
$17,676,667
$17,753,634
$18,522,509
$19,199,966
$20,438,484
$20,832,719
$21,457,700
Other Tax
$2,550,237
$1,617,671
$1,087,173
$2,072,992
$35,493
$35,848
$36,710
$37,078
Interest
$3,457,753
$4,681,452
$1,132,350
$1,227,389
$1,240,410
$977,382
$968,561
$989,187
$29,345,000
$71,780,000
$859,370
$936,609
$999,237
$1,028,705
$1,121,829
$1,166,546
$1,213,045
$1,261,397
$482,462
$486,131
$404,411
$488,227
$470,000
$470,000
$470,000
$470,000
$54,371,489
$97,255,498
$22,189,350
$24,017,280
$23,306,216
$23,482,495
$24,146,016
$24,429,939
Other Miscellaneous Refunded Bonds
$43,670
County State Assessed Utility Federal Other TOTAL REVENUE
EXPENDITURES Bond Payments Bond Principal
$39,535,000
$42,540,000
$36,755,000
$13,790,000
$56,525,000
$14,815,000
$13,815,000
$13,595,000
Bond Interest
$8,683,977
$8,032,271
$8,575,906
$8,345,057
$7,957,775
$5,379,699
$4,959,999
$4,565,799
$227,575
$443,310
$4,825
$4,292
$10,000
$10,000
$10,000
$10,000
$48,446,552
$51,015,581
$45,335,731
$22,139,349
$64,492,775
$20,204,699
$18,784,999
$18,170,799
$25,769,467
Other Costs TOTAL EXPENDITURES
FUND BALANCE Beginning Fund Balance
$27,420,810
$33,345,747
$79,585,664
$56,439,282
$58,317,213
$17,130,654
$20,408,450
Excess Revenue/Expense
$5,924,937
$46,239,917
-$23,146,381
$1,877,931
-$41,186,559
$3,277,796
$5,361,017
$6,259,140
ENDING FUND BALANCE
$33,345,747
$79,585,664
$56,439,282
$58,317,213
$17,130,654
$20,408,450
$25,769,467
$32,028,607
The Debt Service Fund Balance will decrease from the FY17 to FY18 fiscal year due to the payment of approximately $41.3 million during 2017-18 from the fund balance for a prior year refunded bond payment.
84
The table below provides the amount of outstanding general obligation bonds of the existing bond issues. At the end of the 2018 calendar year, the District will have $142.3 million in outstanding bonds and available bond capacity of $105.9 million. The latest bond issue was voted in 2015 and issued during 2015 and 2016. The changes in debt will be impacted solely by the pay-off of current issues each year pending any future refunding opportunities. Future bond issues are not planned at this time through the 2020-21 school year.
The District’s debt capacity, tied to assessed value, is projected to increase conservatively through 2030 while the amount of existing general obligation debt will be decreasing as outstanding bonds are paid-off. Based on current projections, without any additional bond issuance, the District will have sufficient bond capacity by 2021 of approximately $200 million.
85
BOND FUND PROJECTS In April 2015 voters approved a $40 million bond issue to address numerous schoolcommunity identified needs. Projects included construction of a new Summit Technology Academy / Missouri Innovation Campus as well as improvements at schools throughout the district. The school building improvements are in the areas of classroom instruction, safety and security, health and wellness, ADA (Americans with Disabilities Act) access renovations and special education. Playground upgrades to all elementary schools’ soft play areas and replacement of deteriorated play equipment to enhance student safety were also funded. Numerous maintenance projects at schools will continue to be impacted through the 201718 school year and 2018-19 school year. The 2017-18 budget includes expenses for a majority of the remaining bond resources to finish projects at the Lee’s Summit Elementary kitchen, Lee’s Summit High School flooring project, Mason Elementary two-classroom addition, Hazel Grove kitchen renovation and the Missouri Innovation Campus. Projects for the uncommitted bond resources will be prioritized and approved by the Board of Education during 2017-18.
BOND FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
Local Interest
$32,524
Bond Premium
$4,534,394
Sale of Bonds
$40,000,000
TOTAL REVENUES
$0
$0
$44,566,918
$54,243
$6,000
$54,243
$6,000
$0
$0
$0
EXPENDITURES General Obligation Bond Construction Equipment Land
$209,291
$11,609,226
$20,442,115
$10,540
$2,377,995
$1,069,679
$100,000
$3,091,375
$60,000
$407,570
$26,518
$17,486,166
$21,598,312
Purchased Services TOTAL EXPENDITURES
$0
$319,831
$5,222,852
$288,291
$5,222,852
$288,291
$0
$0
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
ENDING FUND BALANCE
$288,291
$288,291
-$31,540
$27,049,212
$5,505,143
$288,291
$0
$0
$0
-$319,831
$27,080,752
-$21,544,069
-$5,216,852
-$288,291
$0
$0
$288,291
-$31,540
$27,049,212
$5,505,143
$288,291
$0
$0
$0
The fund balance in the Bond Fund will decrease for the planned bond expenses during 2017-18 for the remaining resources provided in the 2015 issue. All bond resources are expected to be expended by the end of 2018-19, with no immediate plans for any additional bond resources through the 2020-21 school year.
86
CAPITAL PROJECTS FUND Capital expenditure budgeted in the Capital Projects fund include school and program based expenditures, various equipment lease payments, technology, general equipment, school buses and other vehicles, and major facility repairs.
CAPITAL PROJECTS FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
REVENUE Local Property Tax Other Tax Interest Other Miscellaneous
$825,997
$829,505
$865,497
$897,275
$955,070
$973,491
$1,002,696
$1,012,724
$2,016,131
$2,515,629
$2,487,367
$2,512,106
$3,539,445
$3,871,475
$3,916,768
$3,796,110
$14,399
$19,548
$41,362
$34,345
$35,200
$37,205
$39,000
$41,000
$1,026,903
$557,391
$180,147
$418,440
$300,000
$55,000
$53,205
$51,205
$42,802
$45,572
$30,229
$30,782
$54,610
$56,787
$59,050
$61,404
$4,993,958
$5,070,719
$4,962,443
County State Assessed Utility State Other
$594
Federal Medicaid/Title/Grants Other
$153,468
$468,000
$300,000
TOTAL REVENUES
$4,226,233
$400,000 $4,121,113
$3,604,601
$4,293,542
$5,352,325
EXPENDITURES Instructional Services Equipment
$482,060
$414,622
$541,534
$615,995
$693,436
$693,575
$693,714
$693,853
Student Support Services Equipment
$1,495
Instruction Support Services Equipment
$18,740
$54,323
$22,941
$15,090
$15,093
$15,096
$15,099
$15,102
$998,485
$7,183
$15,296
$25,460
$25,465
$25,470
$25,475
$25,480
$341,828
$29,218
$86,775
$90,831
$90,849
$90,868
$90,886
$90,904
$1,732,247
$1,769,322
$200,097
$181,194
$181,231
$181,267
$181,303
$181,339
$1,731,341
$1,805,330
$2,492
$1,695,977
$10,000
$10,250
$10,506
$10,769
$61,781
$69,244
$5,040
$3,925
$5,996
$5,997
$5,999
$6,000
$1,226,003
$653,638
$467,867
$314,006
$1,516,520
$5,037,703
$5,405,884
$5,486,972
$24,101
$43,042
$65,243
$103,400
$100,000
$100,000
$100,000
$2,906,347
$3,101,448
$4,839,295
$4,877,335
$4,784,984
$3,801,625
$3,267,949
$3,195,108
$735,258
$678,468
$586,896
$494,606
$403,986
$313,982
$236,997
$169,845
$10,258,191
$8,625,838
$6,768,233
$8,381,158
$7,830,960
$10,275,832
$10,033,812
$9,975,372
Beginning Fund Balance
$16,372,600
$14,194,526
$13,685,342
$13,687,988
$13,085,059
$13,248,413
$10,740,628
$8,593,234
Excess Revenue Over Expense
-$6,031,958
-$4,504,725
-$3,163,631
-$4,087,615
-$2,478,635
-$5,281,874
-$4,963,093
-$5,012,929
General Support Services Equipment Central Services Equipment Operation and Maintenance Equipment Transportation Services Equipment Community Services Equipment Site and Facility Improvements Construction Contracts Equipment Lease Payments Principal Interest TOTAL EXPENDITURES
FUND BALANCE
Transfers In/(Out)
ENDING FUND BALANCE
$3,853,885
$3,995,541
$3,166,277
$3,484,686
$2,641,989
$2,774,088
$2,815,700
$2,857,935
$14,194,526
$13,685,342
$13,687,988
$13,085,059
$13,248,413
$10,740,628
$8,593,234
$6,438,240
87
2017-18 SITE AND FACILITY IMPROVEMENT DETAILS LOCATION
PROJECT TYPE
BASS BCMS
CAP EQUIP
CCE
CAP
GWE
CAP
HGE
CAP
HHE HHE HPE LFE LSE LSHS
CAP CAP CAP CAP CAP CAP
LSNHS
EQUIP
LSWHS
CAP
LSWHS
EQUIP
MAE MAE
CAP CAP
MLE
CAP
MP PLE PLMS PVE RHE
CAP CAP EQUIP CAP CAP
SLMS
CAP
SPE
CAP
SVE
CAP
SVE SVE
CAP CAP
TRE
CAP
UWE
CAP
WLE WVE DISTRICT DISTRICT DISTRICT
CAP CAP CAP CAP CAP
PROJECT DESCRIPTION Replace kitchen and bathroom tile flooring Upgrade sound system in Commons-Stage/Fieldhouse Even out concrete where old playground equipment removed and add 4 large picnic tables - Orig Request $24,089 Replace fence around front of building and playground Paint Rms 121, 201, 224, 225, 230, 227, 226, 231, 229, Stairwell 200, Stairwell 06, Exterior cafe doors & Kids Country door New epoxy floor for bathroom - Rm 151 New epoxy floor for bathroom - Rm 152 Remodel and update front office space Replace carpet in 6th grade pod Replace carpet in Rms 3, 6, 19, 21 Strip, sand B gym floor, add new graphic, recoat Exterior Cyclone vacuum system installed in Engineering & Industrial Technology Lab Upgrade PE workout facility - $90k orig request 6 new cameras to be placed in specified locations to increase student, staff and patron safety Paint burlap wall and hang 8 ft white board in Rm 14 Replace 8 ft white board in Rm 49 Bathroom floors and corridor that connects the restrooms needs new epoxy Rms 130, 129, 205, 163, 165, 134D Install chain link fencing with black vinyl around playground Replace carpet in Rms 110, 107, 106, 108, 112 New digital clock system Replace carpet and tile in Rms 54, 60-66, 70-73, 98-99 Replace carpet in main office & library office Add storage container similar to what is being used at TRANS and high schools. Small concrete sidwalk would be needed Replace carpet in 4th grade pod, 6th grade pod - Orig Request $38,778 One pod approved Replace carpet in Rms B-143, B-147, B-146, B-144, B-122, B-126, B-125, B-121, A-128 and install 6' x 9' water hog mat for hallway by playground - Orig Request $55,020 Only waterhog approved Paint inside wall and oustide wall with railing for Rms C-132, A- 122, A-123 Repair concrete outside of the gym and medically fragile room Replace bathroom partitions that have become rusted and could be dangerous Replace carpet in Rms 163, 164, 165, 166, Main Office Hall, Office/Conference Room Repair/Replace kitchen floor and kitchen restroom floor Replace 205 ft of 5 ft tall wood fencing section with chain link fence Contingency (Capital Projects Team) Roofing/Paving Contracts Special Projects (Projects Determined as Needs Arise During Year)
TOTAL PROJECT COST $3,000 $44,800 $15,000 $7,500 $15,155 $2,751 $2,751 $22,624 $19,770 $16,506 $56,000 $33,600 $35,000 $10,000 $2,125 $625 $14,408 $9,000 $25,272 $15,000 $35,000 $21,294 $5,000 $19,389 $2,000 $2,009 $1,246 $8,800 $29,208 $17,766 $5,000 $2,401 $500,000 $619,920
The fund balance in the Capital Projects fund will increase slightly from FY17 to FY18 due to a reduction in planned expenses. 88
LONG RANGE CAPITAL IMPROVEMENT PLAN During the 2017-18 school year, the District will begin the process to develop a ten year comprehensive facility master plan (CFMP) and a comprehensive capital improvement plan. While the district has had some planning documents in place, they are not sufficient to address future facility needs tied to enrollment changes, a systematic approach to capital improvements, plans for current facility use, changes needed to facilities that will better support and enhance student learning or changes needed to address educational program needs. The development of these plans will require comprehensive financing plan development. Funding in the Capital Projects fund has been limited for many years with current year revenue from a five-cent levy, M&M taxes and a transfer from the General (Incidental) Fund. Discretionary revenue which can be recorded in the Capital Projects Fund is limited by state law and DESE regulation. The Board of Education will need to develop a long-range financing plan tied to the CFMP and the long range capital improvement plan which could include funding from general obligation bonds and/or lease purchase revenue to supplement the existing sources of revenue.
C. Jones, Lee's Summit West High School
89
PROPRIETARY FUNDS Proprietary funds are used to account for the District’s ongoing activities similar to businesses found in the private sector. These funds are considered self-supporting in that the services rendered by the program are generally financed through user charges or on a cost reimbursement basis. The Lee’s Summit R-VII School District categories two programs, accounted for in separate funds, as “proprietary”. These two programs are Nutrition Services and Before and After School Services (BASS). NUTRITION SERVICES FUND The Nutrition Services department’s mission to provide food service program meal opportunities that meet the nutritional needs of students in grades PreK – 12 at an affordable cost, encouraging healthy eating habits, personal fitness and proper dietary choices. The revenue and expenses for the Nutrition Services department are provided in the chart below.
NUTRITION SERVICES FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$4,624,348
$4,632,068
$4,750,074
$4,734,470
$5,140,500
$5,173,222
$5,206,658
$5,240,310
$1,436
$4,263
$10,486
$9,190
$10,000
$10,500
$10,500
$10,500
$68,261
$53,738
$54,457
$86,583
$97,376
$97,493
$97,611
$97,729
$407,033
$451,636
$445,020
$586,485
$585,120
$605,872
$627,437
$649,769
$1,723,311
$1,727,319
$1,759,640
$1,846,743
$1,852,880
$1,918,598
$1,986,887
$2,057,603
$2,632
$2,707
$21,142
$3,211
$3,200
$3,500
$3,500
$3,500
$6,827,020
$6,871,732
$7,040,820
$7,266,683
$7,689,076
$7,809,185
$7,932,593
$8,059,411
Local Food Sales Other Miscellaneous State Breakfast/Lunch Federal Breakfast Program Lunch Program Other TOTAL REVENUES
EXPENDITURES Nutrition Services Employee Salaries & Benef
$3,588,533
$3,839,696
$3,917,978
$3,974,747
$4,130,496
$4,192,453
$4,255,340
Purchased Services
$89,384
$134,476
$118,716
$95,894
$88,700
$90,000
$91,314
$92,647
Materials & Supplies
$2,972,196
$3,080,732
$3,051,366
$2,985,325
$3,357,000
$3,404,669
$3,451,994
$3,503,774
$218,464
$57,192
$63,940
$117,290
$75,000
$76,050
$77,107
$78,264
$6,868,576
$7,112,095
$7,152,000
$7,173,256
$7,651,196
$7,763,173
$7,875,756
$7,993,855
$2,153,863
$2,112,307
$1,871,943
$1,760,763
$1,854,189
$1,892,069
$1,938,082
$1,994,919
Equipment TOTAL EXPENDITURES
$4,319,170
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense ENDING FUND BALANCE
-$41,556
-$240,364
-$111,180
$93,426
$37,880
$46,012
$56,837
$65,556
$2,112,307
$1,871,943
$1,760,763
$1,854,189
$1,892,069
$1,938,082
$1,994,919
$2,060,474
The fund balance in the Nutrition Services fund will increase slightly from FY17 to FY18 due to an increase in revenue, tied to an increase in meal prices for FY18.
90
BEFORE AND AFTER SCHOOL SERVICES (BASS) FUND The mission of Before and After School Services (BASS) is to provide support to families by caring for their children during out of school time in a safe, nurturing, fun and educational environment. Established in 1996, BASS, previously only known as Kids Country, is comprised of three fee based programs and one no-cost program serving children ages 3 to 21. Programs begin at 6:30 am and end at 6:00 pm. Child care is also provided on early release, snow days, and most nonschool days. Quality staff supervise and facilitate activities and curriculum while building positive relationships with students and families. Summer programming offers age-appropriate field trips, children’s choice of activities, and stimulating and educational curriculum.
The fund balance in the BASS fund will decrease slightly from FY17 to FY18 due to flat revenue but with increasing expenses, primarily for salaries and benefits for FY18.
91
FIDUCIARY FUNDS Fiduciary funds are used to account for assets held by the school district in a trustee capacity. Within the Lee’s Summit R-VII School District, student activities are classified as fiduciary funds and accounted for in a separate “Student Activity” fund.
STUDENT ACTIVITY FUND Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
Local Other Miscellaneous TOTAL REVENUES
$4,205,097
$4,406,687
$4,767,601
$4,701,249
$4,700,000
$4,725,000
$4,748,719
$4,796,206
$4,205,097
$4,406,687
$4,767,601
$4,701,249
$4,700,000
$4,725,000
$4,748,719
$4,796,206
Student Activity Employee Salaries & Benefit $ Purchased Services
199,455
$ 1,535,607
$
288,807
$ 1,700,033
Materials & Supplies
$ 2,435,480
$ 2,442,323
Equipment
$
$
TOTAL EXPENDITURES
87,223
70,781
$
370,048
$ 1,778,428
$
323,468
$ 1,739,666
$ 2,512,283
$ 2,604,211
$
$
65,701
103,819
$
328,320
$ 1,740,000
$
330,982
$ 1,750,000
$
335,583
$ 1,764,725
$
340,616
$ 1,775,000
$ 2,581,000
$ 2,599,000
$ 2,601,920
$ 2,641,234
$
$
$
$
100,000
100,000
100,000
100,000
$4,257,765
$4,501,944
$4,726,460
$4,771,165
$4,749,320
$4,779,982
$4,802,228
$4,856,850
$2,077,803
$2,025,134
$1,929,877
$1,971,019
$1,901,103
$1,851,783
$1,796,801
$1,743,292
-$52,669
-$95,257
$41,141
-$69,915
-$49,320
-$54,982
-$53,509
-$60,644
$2,025,134
$1,929,877
$1,971,019
$1,901,103
$1,851,783
$1,796,801
$1,743,292
$1,682,648
FUND BALANCE Beginning Fund Balance Excess Revenue/Expense
ENDING FUND BALANCE
The fund balance in the activity fund is projected on a decreasing trend as expenses are outpacing the growth in revenue. This fund is funded from revenue generated from student sources, with increased efforts in fundraising, donations and athletic event gate receipts.
92
FUND BALANCE/FUND BALANCE FORECAST Fund balance has been a continual area of focus for the Board of Education and administrative team. Using an analysis of cash flow, the Board of Education has set a minimum fund balance at 15% of operating expenditures. A balance of 15% or more allows the District to meet its expenditure obligations during the months of the fiscal year in which minimal revenue is received. The cash flow chart below represents the typical pattern of revenues and expenditures in Lee’s Summit R-7.
Past significant budget reductions and cost containment strategies have provided a positive impact on the operating fund balance beginning in the 2010-11 school year. Economic factors, as well as conservative expenditure patterns have provided the opportunity for the District to address targeted salary and benefit improvements to recruit and retain staff providing a planned reduction in the percent of fund balance. The fund balance graph below shows the changes in fund balance and identifies the minimum 15 percent fund balance. The fund balance, while projected to decline slightly in terms of percent, remains well above the minimum fund balance required.
*Budgeted
93
INFORMATIONAL SECTION Budgets are financial planning and decision-making documents. The Financial Section is the heart of the budget document. The budget financial schedules present the adopted budget compared to the past actual revenues and expenditures.
Daniella A., Lee's Summit High School
Brandon H., Lee's Summit High School
Caitlin D., Lee’s Summit High School
94
ASSESSED VALUATION The Lee’s Summit R-7 School District encompasses areas both in Cass and Jackson Counties in Missouri. Annually, the district receives revised assessment numbers in September, after Board of Equalization adjustments. In accordance with state law, the District conducts a community tax rate public hearing and the Board of Education approves the tax rate to be levied. Per state law, the District’s tax levy is rolled-up or rolled-back based on increases or decreases in certified assessed valuation. All taxable real and personal property is to be assessed annually by the County Assessor and re-assessed in odd-numbered years. Assessed value to market value is established by Missouri law at the following values: Agriculture 12%, Residential 19%, Commercial 32%, Personal Property 33 1/3%. Tax bills to property owners are calculated by taking the market value multiplied by the classification percentage to determine the assessed value and multiplying it by the levy rate per $100 of assessed value. Unpaid taxes after January 1 are considered delinquent.
PROPERTY TAX RATE CALCULATION
The tax rates by fund, calculated pursuant to state law and regulation, are shown in the table below.
TAX RATE BY FUND Special Incidental Revenue (General) (Teacher's) 2017-18* $4.7418 $0.0000 2016-17 $4.8757 $0.0000 2015-16 $4.8613 $0.0000 2014-15 $4.9992 $0.0000 2013-14 $4.9427 $0.0000
Debt Service $1.0700 $1.0700 $1.0700 $1.0700 $1.0700
*Estimated
95
Capital Projects $0.0500 $0.0500 $0.0500 $0.0500 $0.0500
Total $5.8618 $5.9957 $5.9813 $6.1192 $6.0627
The following table and graph includes the total assessed and market values of property with the applicable yearly percent change and the ratio or market to assessed value. For fiscal years FY19 to FY21, the assessed value projected growth is one percent in non-reassessment (even-numbered) years and three percent in reassessment (odd-numbered) years.
ASSESSED VALUATION/MARKET VALUE HISTORY OF TAXABLE PROPERTIES
Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Assessed Valuation $2,041,276,544 $2,021,065,885 $1,962,199,889 $1,942,772,167 $1,828,705,105 $1,771,219,825 $1,670,461,658 $1,682,183,866
Percent Change 1.00% 3.00% 1.00% 6.24% 3.25% 6.03% -0.70% 3.02%
*Estimated
96
Market Value $9,328,273,171 $9,235,914,030 $8,966,906,826 $8,878,125,570 $8,352,865,692 $8,064,532,874 $7,661,219,003 $7,665,751,349
Ratio 21.88% 21.88% 21.88% 21.88% 21.89% 21.96% 21.80% 21.94%
The average assessed valuation per pupil for the R-7 District, based on an assessment of $1,942,772,167 and a budgeted enrollment of 18,157 is $106,998 for fiscal year FY18. This compares to $102,008 assessed valuation per pupil for FY17. The assessed value per pupil has shown an overall increase each year since 2014-15.
The chart below provides the assessed value per ADA for comparison school districts and the state average for the 2015-16 school year (the latest data available at the time of budget preparation.
97
PROPERTY TAX MARKET VALUE ESTIMATIONS The actual and projected assessed values are provided in the table below by type of assessed value, using the statutorily mandated assessment rate.
Residential Real Estate Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Assessed Valuation $1,391,854,309 $1,378,073,573 $1,337,935,508 $1,324,688,622 $1,246,100,813 $1,225,817,016 $1,151,245,211 $1,137,678,196
Assessment Rate 19.00% 19.00% 19.00% 19.00% 19.00% 19.00% 19.00% 19.00%
Market Value $7,325,548,996 $7,253,018,808 $7,041,765,833 $6,972,045,379 $6,558,425,332 $6,451,668,505 $6,059,185,321 $5,987,779,979
Agricultural/Horticultural Real Estate Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Assessed Valuation $3,206,277 $3,174,532 $3,082,070 $3,051,554 $2,855,918 $3,092,498 $2,999,405 $3,024,379
Assessment Rate 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00%
Market Value $26,718,975 $26,454,430 $25,683,913 $25,429,617 $23,799,317 $25,770,817 $24,995,042 $25,203,158
Utility/Industrial Real Estate Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Assessed Valuation $298,022,863 $295,072,141 $286,477,807 $283,641,393 $250,376,800 $234,013,811 $226,404,491 $225,837,091
Assessment Rate 32.00% 32.00% 32.00% 32.00% 32.00% 32.00% 32.00% 32.00%
*Estimated
98
Market Value $931,321,445 $922,100,441 $895,243,147 $886,379,353 $782,427,500 $731,293,159 $707,514,034 $705,740,909
PROPERTY TAX MARKET VALUE ESTIMATIONS
Personal Property Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Assessed Valuation $348,193,095 $344,745,639 $334,704,504 $331,390,598 $329,371,574 $285,238,271 $289,812,551 $315,644,200
Assessment Rate 33.33% 33.33% 33.33% 33.33% 33.33% 33.33% 33.33% 33.33%
Market Value $1,044,683,755 $1,034,340,351 $1,004,213,933 $994,271,221 $988,213,543 $855,800,393 $869,524,605 $947,027,303
*Estimated
IMPACT OF DISTRICT TAX RATE ON TAXPAYERS
Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Market Value of Property $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Assessed Value* $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000 $19,000
Tax Levy Rate $5.8246 $5.8102 $5.8762 $5.8618 $5.9957 $5.9813 $6.1192 $6.0627
99
Annual Cumulative Property Tax Change Percent Due from FY07 Change ($12.79) -1.14% $1,106.67 ($15.52) -1.39% $1,103.94 ($2.98) -0.27% $1,116.48 -0.51% ($5.72) $1,113.74 $1,139.18 $19.72 1.76% $16.99 1.52% $1,136.45 $1,162.65 $43.19 3.86% $1,151.91 $32.45 2.90%
PROPERTY TAX LEVY AND COLLECTIONS
Year 2020-21* 2019-20* 2018-19* 2017-18* 2016-17 2015-16 2014-15 2013-14
Total Revenue Total Levy Assessed Valuation from Taxes $2,041,276,544 $5.8246 $118,896,194 $2,021,065,885 $5.8102 $117,427,970 $1,962,199,889 $115,302,790 $5.8762 $1,942,772,167 $5.8618 $113,881,419 $5.9957 $1,828,705,105 $109,643,672 $1,771,219,825 $5.9813 $105,941,971 $6.1192 $102,218,890 $1,670,461,658 $1,682,183,866 $101,985,761 $6.0627
Revenue Collected** $113,545,865 $112,143,711 $110,114,164 $108,756,755 $107,586,948 $103,543,970 $101,660,500 $100,157,328
Tax Collection Rate 95.50% 95.50% 95.50% 95.50% 98.12% 97.74% 99.45% 98.21%
*Estimated for budget purposes. **Collections include the total of current and delinquent property taxes collected less the fees retained by the County Collectors. Actual collections used for school years 2013-14 through 2016-17. Estimated collections for 2017-18 through 2020-21.
ALTERNATIVE TAX COLLECTIONS A one percent state-wide sales tax voted as “Proposition C” is paid by the State of Missouri based on the prior year weighted ADA. While the funds are paid by the state, the revenue is considered a local revenue. The following table provides the amount of Prop C revenue.
PROPOSITION C SALES TAX Actual 2013-14
Actual 2014-15
Actual 2015-16
Budget 2016-17
Proposed 2017-18
Projected 2018-19
Projected 2019-20
Projected 2020-21
$14,831,594
$15,452,501
$15,947,083
$16,680,976
$17,082,727
$17,327,655
$17,766,910
$18,210,556
100
ENROLLMENT The Lee’s Summit R-7 School District Staff, along with demographer-Applied Economics, annually projects current and future enrollment figures using as a baseline the last Wednesday in September enrollment count submitted to the Missouri Department of Elementary and Secondary Education. Included in the process are cohort growth and construction patterns for the school district. This enrollment estimating process, including local city and county officials, the development community, site leadership and R-7 staff allows for annual long-range financial planning, accurate budget estimates, appropriate staffing and prediction of necessary future Comprehensive Facility Master Plan building and capital needs.
APPLIED ECONOMICS ENROLLMENT PROJECTION SCOPE
Enrollment Trends Demographic Characteristics Residential Development Impacts Enrollment Projections Planning Support
•Grade and level characteristics •Geographic distribution •Special programs •Population characteristics •Household type and age structure •Housing supply and occupancy rates •Current development activity •Housing market conditions •Future development potential
•District •Sub-district
•Facilities •Attendance Areas •Programs
101
September
August
APPLIED ECONOMICS ENROLLMENT PROJECTION PROCESS Perform field research on development activity and trends including a windshield survey of active developments, and meetings with land owners, developers and local real estate professionals Meet with representatives of the planning departments from each of the six jurisdictions served by LSR-7 to obtain information on active and near-term future developments / new jobs Obtain housing market information and near-term forecasts from Landmarketing, along with birth rate, housing vacancy rate and permitting activity from various public sources Obtain current year student information from the District, and incorporate it and the information from above into the district and subdistrict enrollment models Develop projections of housing absorption for the District and then allocate that absorption to active and future development projects
November
October
Develop district-level projections of housing units, households, population and school-age population and enrollment by grade Develop sub-district projections of housing units, student generation rates and enrollment by planning area Repeat above to adjust and calibrate the models, prepare and review projections and perform quality control checks Transmit draft numerical results to District staff for review and then prepare and transmit the draft report Revise projections, prepare the final report and perform add-on tasks as requested
102
The district has seen an increase in student enrollment over the past ten years. The current year student enrollment is projected to increase by 230 students when compared to the 2016-17 school year. The official fiscal year budget enrollment is determined on the last Wednesday in September. Current enrollment projections for the next three years (FY19 through FY21) shows an average increase of 269 students per year.
APPLIED ECONOMICS ENROLLMENT CONCLUSIONS Enrollment is likely to continue to grow over the next 10 years with most of the increase being in the upper grades until near the end of the projection period The aging of the existing population will likely offset much of the increase in the school-age population from new housing unless the level of construction increases Single family construction activity is increasing currently, but may remain constrained by the lack of affordable options whereas multifamily construction is likely to expand Current and future enrollment by school shows trends that modification of attendance areas and new facilities may be required as development continues and the school-age population shifts outward The District has great potential for future growth and is very well situated relative to emerging economic growth giving rise to the possibility of accelerated growth again in the future
103
ACTUAL/PROJECTED ENROLLMENT BY SCHOOL – FY14 TO FY27
ELEMENTARY SCHOOLS: Cedar Creek Greenwood Hawthorn Hill Hazel Grove Highland Park Lee's Summit Longview Farm Mason Meadow Lane Pleasant Lea Prairie View Richardson Summit Pointe Sunset Valley Trailridge Underwood Westview Woodland Other TOTAL ELEMENTARY:
100% Program Capacity 658 564 658 493 658 329 658 399 658 634 1,151 658 658 658 658 658 493 658 11,301
Actual Enroll. 2013-14 509 466 547 422 447 307 588 380 546 604 1,002 633 548 476 426 517 386 375 7 9,186
Actual Actual Actual Proj. Proj. Proj. Proj. Proj. Proj. Proj. Proj. Proj. Proj. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. Enroll. 2014-15 2015-16 2016-17 2017-18 2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 539 534 515 496 480 473 483 486 477 482 499 504 528 469 455 448 432 432 424 394 388 386 397 408 420 438 545 568 542 525 520 525 525 556 563 601 638 682 722 442 440 461 510 546 553 558 586 594 599 604 611 619 503 503 527 544 541 543 551 546 547 559 572 588 605 289 308 293 295 296 288 287 284 277 280 282 285 288 584 589 577 597 601 598 594 596 589 601 608 617 623 412 449 461 482 518 541 573 591 621 650 679 711 735 531 524 543 551 555 557 563 550 540 530 515 503 491 569 576 585 570 540 536 512 487 466 457 447 440 432 937 888 893 892 862 853 846 827 838 825 824 824 824 638 618 630 627 625 612 596 582 574 563 558 555 552 584 596 598 589 589 616 618 610 630 638 649 661 680 466 474 485 470 481 458 447 443 443 444 450 457 464 455 471 473 467 477 498 514 511 510 531 549 563 577 476 488 482 490 489 485 485 493 479 473 470 468 466 350 362 380 391 388 396 402 397 404 397 395 394 394 348 349 355 375 407 426 470 501 539 574 609 648 688 21 18 1 16 14 14 13 14 11 12 11 11 11 9,147 9,215 9,268 9,338 9,377 9,403 9,421 9,445 9,497 9,608 9,750 9,937 10,113
-0.47%
0.02%
0.74%
0.58%
0.76%
0.42%
0.28%
0.19%
0.25%
0.55%
1.17%
1.48%
1.92%
1.77%
MIDDLE SCHOOLS: Bernard Campbell Pleasant Lea Summit Lakes Other
1,183 1,061 1,122
922 882 975 12
918 860 971 9
886 823 1,018 15
871 879 1,101 6
895 910 1,121 18
975 879 1,104 18
1,047 912 1,099 18
1,073 911 1,156 17
1,078 938 1,179 16
1,114 944 1,181 18
1,119 933 1,129 18
1,093 938 1,090 16
1,079 927 1,121 16
1,074 935 1,140 16
TOTAL MIDDLE SCHOOL:
3,366
2,791 1.09%
2,758 1.36%
2,742 -0.58%
2,857 4.19%
2,944 3.05%
2,976 1.09%
3,076 3.36%
3,157 2.63%
3,211 1.71%
3,257 1.43%
3,199 -1.78%
3,137 -1.94%
3,143 0.19%
3,165 0.70%
HIGH SCHOOLS: Lee's Summit Lee's Summit North Lee's Summit West Other
2,166 2,166 2,285
1,799 1,912 1,812 130
1,794 1,849 1,898 164
1,778 1,856 1,991 165
1,794 1,902 2,080 26
1,699 1,889 2,118 169
1,746 1,930 2,215 172
1,758 1,943 2,321 172
1,783 2,026 2,406 171
1,862 2,127 2,444 168
1,846 2,236 2,497 167
1,919 2,309 2,504 166
1,931 2,362 2,571 168
1,956 2,366 2,551 167
1,970 2,366 2,518 166
TOTAL HIGH SCHOOL:
6,617
5,705 0.56% 17,610 -3 -0.02%
5,790 1.49% 17,747 137 0.78%
5,802 0.21% 17,927 180 1.01%
5,875 1.26% 18,157 230 1.28%
6,063 3.20% 18,416 259 1.43%
6,194 2.16% 18,673 257 1.40%
6,386 3.10% 18,964 291 1.56%
6,601 3.37% 19,257 293 1.55%
6,746 2.20% 19,500 243 1.26%
6,898 2.25% 19,705 205 1.05%
7,032 1.94% 19,919 214 1.09%
7,040 0.11% 20,120 201 1.01%
7,020 -0.28% 20,298 178 0.88%
DISTRICT K-12 TOTAL
5,653 1.97% 21,284 17,630 STUDENTS +/30 GROWTH % 0.17%
104
BUDGET ALLOCATIONS The Lee’s Summit R-7 School District budget allocations are based on projected student enrollments using a per student allocation for various budget line items for school site locations. The budget allocation per student varies by grade level. The general and music equipment allocations incorporate grade level and age of facility to determine the yearly allocation. School building allocations may be revised using actual student enrollment following the official last Wednesday in September date. District department allocations remain consistent each year. Changes in department budget allocations are requested through the annual non-allocated budget request process.
105
2017-18 SCHOOL BUDGET ALLOCATIONS
Cedar Creek 52 515
Location (Building Number): Enrollment: Textbooks Textbooks (Unrestricted) Supplies Instructional (includes Art, Music, PE, Rem Reading, Paper) Technology Miscellaneous Middle School Implementation Repairs (No replacement, ONLY repair) Printing (Outsourced, not paper) Postage Local Mileage (Principal Office) @ $0.535 per mile Student Travel Dues Memberships (IB) Field Trips (Admission) Other Purchased Services Media Services (Restricted in Elementary Only) Books Base Books Supplies Base Media Base New School (each of 1st 2 yrs) Sub-Total Media Services Only:
Greenwood 45 432
Hazel Grove 42 510
Hawthorn Hill 55 525
Highland Park 53 544
$
6,571 $
5,512 $
6,508 $
6,699 $
6,941
$ $ $
16,232 $ 1,263 $ 1,263 $
13,616 $ 1,060 $ 1,060 $
16,074 $ 1,251 $ 1,251 $
16,547 $ 1,288 $ 1,288 $
17,146 1,334 1,334
$ $ $ $ $ $ $ $
842 1,053 840 577 421 -
$ $ $ $ $ $ $ $
706 883 705 484 353 -
$ $ $ $ $ $ $ $
834 1,042 832 571 417 -
$ $ $ $
3,270 7,159 1,226 1,635
$ $ $ $
3,270 6,005 1,226 1,635
$ $ $ $
3,270 7,089 1,226 1,635
$ $ $ $ $ $ $ $
858 1,073 857 588 429 -
$ $ $ $ $ $ $ $
890 1,112 888 609 445 -
3,270 7,298 1,226 1,635 13,430
$ $ $ $
3,270 7,562 1,226 1,635
$
13,694
$
13,291 $
12,137 $
$ $ $ $ $ 13,221 $
substitutes. Sub days calculated @ $136)
$
1,558 $
1,307 $
1,543 $
1,588 $
1,646
Supplemental Pay (Curriculum, School Improvement, Supervision)
$
2,271 $
1,905 $
2,249 $
2,315 $
2,399
$ $
8,760 $ 8,760 $
7,348 $ 7,348 $
8,675 $ 8,675 $
8,930 $ 8,930 $
9,253 9,253
$ $
54,942 $ 106.68 $
47,076 $ 108.97 $
54,468 $ 106.80 $
55,890 $ 106.46 $
57,691 106.05
$
4,820 $
4,044 $
4,774 $
4,914 $
5,092
$
59,763 $
51,120 $
59,242 $
60,804 $
62,783
$4,341
$3,642
$4,299
$4,426
$4,586
Staff Development (To include inservice/materials, registrations, travel,
Equipment Music Equipment (RESTRICTED) Equipment New/Replacement (Place in Fund 431) Sub-Total Equipment: OVERALL ALLOCATION FORMULA: GRAND TOTALS: Per Student Additions to Budget: (RESTRICTED TO TRANSPORTATION COSTS) Non-athletic Student Travel
Revised Grand Total for 600 Budget Manager: Elementary Music Equipment Allocation (District-w ide Account)
5% Withholding for Technology
$
2,988 $
2,556 $
2,962 $
3,040 $
3,139
Total Budget Allocation for Enrollment FY18
$
56,774 $
48,564 $
56,280 $
57,764 $
59,644
106
2017-18 SCHOOL BUDGET ALLOCATIONS
Location (Building Number): Enrollment: Textbooks Textbooks (Unrestricted) Supplies Instructional (includes Art, Music, PE, Rem Reading, Paper) Technology Miscellaneous Middle School Implementation Repairs (No replacement, ONLY repair) Printing (Outsourced, not paper) Postage Local Mileage (Principal Office) @ $0.535 per mile Student Travel Dues Memberships (IB) Field Trips (Admission) Other Purchased Services Media Services (Restricted in Elementary Only) Books Base Books Supplies Base Media Base New School (each of 1st 2 yrs) Sub-Total Media Services Only:
Lee's Summit Longview Farm 44 56 295 597
Mason 43 482
Meadow Lane 47 551
Pleasant Lea 46 570
$
3,764 $
7,618 $
6,150 $
7,031 $
7,273
$ $ $
9,298 $ 724 $ 724 $
18,817 $ 1,464 $ 1,464 $
15,192 $ 1,182 $ 1,182 $
17,367 $ 1,351 $ 1,351 $
17,966 1,398 1,398
$ $ $ $ $ $ $ $
482 603 481 330 241 -
$ $ $ $ $ $ $ $
976 1,220 974 669 488 -
$ $ $ $ $ $ $ $
788 985 787 540 394 -
$ $ $ $ $ $ $ $
901 1,126 899 617 450 -
$ $ $ $ $ $ $ $
932 1,165 930 638 466 -
$ $ $ $
3,270 4,101 1,226 1,635
$ $ $ $
3,270 8,298 1,226 1,635
$ $ $ $
3,270 6,700 1,226 1,635
$ $ $ $
3,270 7,659 1,226 1,635
$ $ $ $
3,270 7,923 1,226 1,635
$
10,233 $
14,430 $
12,832 $
13,791 $
14,055
substitutes. Sub days calculated @ $136)
$
892 $
1,806 $
1,458 $
1,667 $
1,724
Supplemental Pay (Curriculum , School Im provem ent, Supervision)
$
1,301 $
2,633 $
2,126 $
2,430 $
2,514
$ $
5,018 $ 5,018 $
6,406 $ 6,406 $
8,199 $ 8,199 $
9,373 $ 9,373 $
9,696 9,696
$ $
34,091 $ 115.56 $
58,965 $ 98.77 $
51,815 $ 107.50 $
58,354 $ 105.90 $
60,155 105.53
$
2,761 $
5,588 $
4,512 $
5,157 $
5,335
$
36,852 $
64,553 $
56,326 $
63,511 $
65,490
$2,487
$2,012
$4,063
$4,645
$4,805
Staff Development (To include inservice/materials, registrations, travel,
Equipment Music Equipment (RESTRICTED) Equipment New/Replacement (Place in Fund 431) Sub-Total Equipment: OVERALL ALLOCATION FORMULA: GRAND TOTALS: Per Student Additions to Budget: (RESTRICTED TO TRANSPORTATION COSTS) Non-athletic Student Travel
Revised Grand Total for 600 Budget Manager: Elem entary Music Equipm ent Allocation (District-w ide Account)
5% Withholding for Technology
$
1,843 $
3,228 $
2,816 $
3,176 $
3,274
Total Budget Allocation for Enrollment FY18
$
35,010 $
61,325 $
53,510 $
60,335 $
62,215
107
2017-18 SCHOOL BUDGET ALLOCATIONS
Prairie View 48 Location (Building Number): Enrollment: 892 Textbooks Textbooks (Unrestricted) Supplies Instructional (includes Art, Music, PE, Rem Reading, Paper) Technology Miscellaneous Middle School Implementation Repairs (No replacement, ONLY repair) Printing (Outsourced, not paper) Postage Local Mileage (Principal Office) @ $0.535 per mile Student Travel Dues Memberships (IB) Field Trips (Admission) Other Purchased Services
Sunset Valley 58 470
Summit Pointe 57 589
Richardson 50 627
Trailridge 51 467
$
11,382 $
8,001 $
7,516 $
5,997 $
5,959
$ $ $
28,114 $ 2,188 $ 2,188 $
19,762 $ 1,538 $ 1,538 $
18,564 $ 1,445 $ 1,445 $
14,814 $ 1,153 $ 1,153 $
14,719 1,145 1,145
$ $ $ $ $ $ $ $
1,459 1,823 1,456 999 729 -
$ $ $ $ $ $ $ $
1,025 1,282 1,023 702 513 -
$ $ $ $ $ $ $ $
963 1,204 961 660 482 -
$ $ $ $ $ $ $ $
769 961 767 526 384 -
$ $ $ $ $ $ $ $
764 955 762 523 382 -
$ $ $ $
4,906 12,399 1,840 2,453
$ $ $ $
3,270 8,715 1,226 1,635
$ $ $ $
3,270 8,187 1,226 1,635
$ $ $ $
3,270 6,533 1,226 1,635
$ $ $ $
3,270 6,491 1,226 1,635
$
21,597 $
14,847 $
14,319 $
12,665 $
12,623
substitutes. Sub days calculated @ $136)
$
2,698 $
1,897 $
1,782 $
1,422 $
1,413
Supplemental Pay (Curriculum , School Im provem ent, Supervision)
$
3,934 $
2,765 $
2,597 $
2,073 $
2,059
$ $
15,173 $ 15,173 $
10,665 $ 10,665 $
6,320 $ 6,320 $
5,043 $ 5,043 $
7,944 7,944
$ $
93,740 $ 105.09 $
65,558 $ 104.56 $
58,258 $ 98.91 $
47,727 $ 101.55 $
50,393 107.91
$
8,349 $
5,869 $
5,513 $
4,399 $
4,371
$
102,089 $
71,427 $
63,771 $
52,126 $
54,764
$7,520
$5,286
$1,985
$1,584
$3,937
Media Services (Restricted in Elementary Only) Books Base Books Supplies Base Media Base New School (each of 1st 2 yrs) Sub-Total Media Services Only: Staff Development (To include inservice/materials, registrations, travel,
Equipment Music Equipment (RESTRICTED) Equipment New/Replacement (Place in Fund 431) Sub-Total Equipment: OVERALL ALLOCATION FORMULA: GRAND TOTALS: Per Student Additions to Budget: (RESTRICTED TO TRANSPORTATION COSTS) Non-athletic Student Travel
Revised Grand Total for 600 Budget Manager: Elem entary Music Equipm ent Allocation (District-w ide Account)
5% Withholding for Technology
$
5,104 $
3,571 $
3,189 $
2,606 $
2,738
Total Budget Allocation for Enrollment FY18
$
96,985 $
67,856 $
60,582 $
49,520 $
52,026
108
2017-18 SCHOOL BUDGET ALLOCATIONS Underwood Location (Building Number): 49 490 Enrollment: Textbooks Textbooks (Unrestricted) Supplies Instructional (includes Art, Music, PE, Rem Reading, Paper) Technology Miscellaneous Middle School Implementation Repairs (No replacement, ONLY repair) Printing (Outsourced, not paper) Postage Local Mileage (Principal Office) @ $0.535 per mile Student Travel Dues Memberships (IB) Field Trips (Admission) Other Purchased Services Media Services (Restricted in Elementary Only) Books Base Books Supplies Base Media Base New School (each of 1st 2 yrs) Sub-Total Media Services Only:
Westview 41 391
$
6,252 $
4,989 $
$ $ $
15,444 $ 1,202 $ 1,202 $
12,324 $ 959 $ 959 $
$ $ $ $ $ $ $ $
801 1,002 800 549 401 -
$ $ $ $ $ $ $ $
639 799 638 438 320 -
$ $ $ $
3,270 6,811 1,226 1,635
$ $ $ $
Elem Total
Woodland 54 375
$ $ $ $ $ $ $ $
9322
4,785 $ $ 11,819 $ 920 $ 920 $ $ 613 $ 767 $ 612 $ 420 $ $ $ 307 $ $ -
118,948 293,815 22,865 22,865 15,242 19,055 15,212 10,440 7,622 -
$ $ $ $ $ $
60,502 129,578 22,688 30,251 243,020
$
12,943 $
$ $ $ $ $ 11,567 $
substitutes. Sub days calculated @ $136)
$
1,482 $
1,183 $
1,134 $
28,200
Supplemental Pay (Curriculum , School Im provem ent, Supervision)
$
2,161 $
1,724 $
1,654 $
41,110
$ $
8,335 $ 8,335 $
6,651 $ 6,651 $
6,379 $ 6,379 $
148,168 148,168
$ $
52,574 $ 107.29 $
43,190 $ 110.46 $
41,675 $ 111.13 $
986,562 105.83
$
4,586 $
3,660 $
3,510 $
87,254
$
57,160 $
46,850 $
3,270 5,435 1,226 1,635
3,270 5,213 1,226 1,635 11,345
Staff Development (To include inservice/materials, registrations, travel,
Equipment Music Equipment (RESTRICTED) Equipment New/Replacement (Place in Fund 431) Sub-Total Equipment: OVERALL ALLOCATION FORMULA: GRAND TOTALS: Per Student Additions to Budget: (RESTRICTED TO TRANSPORTATION COSTS) Non-athletic Student Travel
Revised Grand Total for 600 Budget Manager:
$4,131
Elem entary Music Equipm ent Allocation (District-w ide Account)
$3,296
5% Withholding for Technology
$
2,858 $
2,342 $
Total Budget Allocation for Enrollment FY18
$
54,302 $
44,507 $
109
45,185 $ 1,073,815 $3,161
$70,205
2,259 $
53,691
42,926 $ 1,020,125
2017-18 SCHOOL BUDGET ALLOCATIONS
Campbell 21 895
Location (Building Number): Enrollment: Textbooks Textbooks (Unrestricted) Supplies Instructional (includes Art, Music, PE, Rem Reading, Paper) Technology Miscellaneous Middle School Implementation Repairs (No replacement, ONLY repair) Printing (Outsourced, not paper) Postage Local Mileage (Principal Office) @ $0.535 per mile Student Travel Dues Memberships (IB) Field Trips (Admission) Other Purchased Services
Pleasant Lea Summit Lakes 22 20 910 1121
Middle School Total 2926
49,952 $
130,383
72,406 2,750 3,666 10,400 2,750 12,098 4,583 2,410 1,680
$ $ $ $ $ $ $ $ $ $ $ $
188,991 7,177 9,569 31,200 7,177 31,578 11,962 6,291 5,040
7,767 19,248 2,862 4,497
$ $ $ $
23,302 50,240 8,585 13,490
30,751 $
34,374 $
95,617
2,927 $
2,976 $
3,666 $
9,569
$
10,874 $
11,057 $
13,620 $
35,551
$ $ $
9,057 $ 18,562 $ 27,620 $
9,209 $ 18,873 $ 28,083 $
11,345 $ 23,250 $ 34,594 $
29,611 60,685 90,296
$ $
204,241 $ 228.20 $
207,211 $ 227.70 $
248,949 $ 222.08 $
660,401 225.99
$
10,196 $
10,367 $
12,770 $
33,333
$
214,437 $
217,578 $
261,719 $
693,734
5% Withholding for Technology
$
10,722 $
10,879 $
13,086 $
34,687
Total Budget Allocation for Enrollment FY18
$
203,715 $
206,699 $
248,633 $
659,047
40,550 $
$
39,881 $
$ $ $ $ $ $ $ $ $ $ $ $
57,808 2,195 2,927 10,400 2,195 9,659 3,659 1,924 1,680
$ $ $ $ $ $ $ $ $ $ $ $
58,777 2,232 2,976 10,400 2,232 9,821 3,720 1,957 1,680
$ $ $ $ $ $ $ $ $ $ $ $
$ $ $ $
7,767 15,367 2,862 4,497
$ $ $ $
7,767 15,625 2,862 4,497
$ $ $ $
$
30,493 $
substitutes. Sub days calculated @ $136)
$
Supplemental Pay (Curriculum , School Im provem ent, Supervision)
Media Services (Restricted in Elementary Only) Books Base Books Supplies Base Media Base New School (each of 1st 2 yrs) Sub-Total Media Services Only: Staff Development (To include inservice/materials, registrations, travel,
Equipment Music Equipment (RESTRICTED) Equipment New/Replacement (Place in Fund 431) Sub-Total Equipment: OVERALL ALLOCATION FORMULA: GRAND TOTALS: Per Student Additions to Budget: (RESTRICTED TO TRANSPORTATION COSTS) Non-athletic Student Travel
Revised Grand Total for 600 Budget Manager: Elem entary Music Equipm ent Allocation (District-w ide Account)
110
2017-18 SCHOOL BUDGET ALLOCATIONS Summit Ridge Acad. Location (Building Number): 14 Enrollment: 117 Textbooks Textbooks (Unrestricted) Supplies Instructional (includes Art, Music, PE, Rem Reading, Paper) Technology Miscellaneous Middle School Implementation Repairs (No replacement, ONLY repair) Printing (Outsourced, not paper) Postage Local Mileage (Principal Office) @ $0.535 per mile Student Travel Dues Memberships (IB) Field Trips (Admission) Other Purchased Services
Summit Tech. Acad. 13 0
LSHS 15 1699
LSNHS 16 1889
LSWHS 17 2118
Senior High Total 5823
$
5,653 $
10,000 $
104,210 $
115,864 $
130,439 $
366,166
$
4,975 $
$
8,483 $
90,472 $ $ 8,033 $
136,008 $ 4,167 $ 9,724 $
150,145 $ 4,633 $ 10,811 $
167,183 $ 5,195 $ 12,122 $
548,783 13,995 49,173
$ $ $ $
2,019 $ 303 505 $ 521 $
$
43,783 $
Media Services (Restricted in Elementary Only) $ Books Base Books Supplies Base Media Base New School (each of 1st 2 yrs) Sub-Total Media Services Only: $
900 $ $ 1,200 $ 2,063 $ $ $ $ 22,998 $
5,556 29,796 13,891 7,238 1,389 6,946 1,389
$ $ $ $ $ $ $ $
6,178 33,128 15,444 8,047 1,544 7,722 1,544
$ $ $ $ $ $ $ $
6,927 37,144 17,317 9,023 1,732 8,658 1,732
$ $ $ $ $ $ $ $
21,580 100,371 48,357 26,892 4,665 23,326 71,446
3,000
$ $ $ $
16,352 33,334 8,176 8,994
$ $ $ $
16,352 37,062 8,176 8,994
$ $ $ $
16,352 41,555 8,176 8,994
$ $ $ $
52,056 111,952 24,528 26,981
3,000
$
66,856 $
70,584 $
75,077 $
215,517
Staff Development (To include inservice/materials, registrations, travel, substitutes. Sub days calculated @ $136)
$
1,514 $
4,460 $
20,142 $
22,394 $
25,109 $
73,619
Supplemental Pay (Curriculum , School Im provem ent, Supervision)
$
10,384 $
2,640 $
43,146 $
47,971 $
53,787 $
157,928
1,643 1,643 $
$ $ $
20,048 $ 38,771 $ 58,819 $
22,290 $ 43,107 $ 65,397 $
17,495 $ 29,737 $ 47,231 $
59,833 113,258 173,091
142,766 $ $
509,277 $ 299.75 $
561,406 $ 297.20 $
Equipment Music Equipment (RESTRICTED) Equipment New/Replacement (Place in Fund 431) $ Sub-Total Equipment: $ OVERALL ALLOCATION FORMULA: $ GRAND TOTALS: Per Student
82,781 $
-
598,677 $ 1,894,907 282.66 $ 293.20
Additions to Budget: (RESTRICTED TO TRANSPORTATION COSTS) Non-athletic Student Travel
Revised Grand Total for 600 Budget Manager:
$
5,655 $
4,234 $
43,929 $
48,842 $
$
88,436 $
147,000 $
553,207 $
610,248 $
54,763 $
157,423
653,440 $ 2,052,330
Elem entary Music Equipm ent Allocation (District-w ide Account)
5% Withholding for Technology
$
Total Budget Allocation for Enrollment FY18
$
111
88,436 $
$
27,660 $
30,512 $
147,000 $
525,546 $
579,736 $
32,672 $
90,845
620,768 $ 1,961,486
2017-18 EQUIPMENT BUDGET ALLOCATIONS
Building Music Age Age Student Class Enroll Class
Building
Summit Ridge Academy Project Lead The Way Parents As Teachers Early Childhood Center District-Wide (Elem Strings/Instrum/ Band and MS Strolling Strings) Elementary Cedar Creek Greenwood Hazel Grove Hawthorn Hill Highland Park Lee's Summit Longview Farm Elementary Mason Meadow Lane Pleasant Lea Prairie View Richardson Summit Pointe Sunset Valley Trailridge Underwood Westview Woodland
3 3 3 3 3 3 2 3 3 3 3 3 2 2 3 3 3 3
2
457
2
515 432 510 525 544 295 597 482 551 570 892 627 589 470 467 490 391 375
3 3 3 3 3 3 2 3 3 3 3 3 2 2 3 3 3 3
9,322
Sub-total
Middle School B. Campbell Pleasant Lea Summit Lakes
117
3 3 3
895 910 1,121
3 3 3
2,926
Sub-total
2017-18 New/Replace/ Repair/Furn Equipment** Allocation $ $ $ $
Replacement of Music Equipment Allocation*
1,643 81,718 1,634 4,904 11,139
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
4,341 3,642 4,299 4,426 4,586 2,487 2,012 4,063 4,645 4,805 7,520 5,286 1,985 1,584 3,937 4,131 3,296 3,161
$
148,168 $
70,205
$ $ $
18,562 $ 18,873 $ 23,250 $
9,057 9,209 11,345
$
60,685 $
29,611
8,760 7,348 8,675 8,930 9,253 5,018 6,406 8,199 9,373 9,696 15,173 10,665 6,320 5,043 7,944 8,335 6,651 6,379
Index:
Weight 0
Weight Class 1 2 3
$
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
New/Replace/Repair Furniture/Equipment
Replacement of Music Equipment Weight 0 0.2 Weight Class Elem Middle 1 1 $ 1.69 $ 2.02 2 2 $ 3.37 $ 4.05 3 3 $ 8.43 $ 10.12 4 4
Index:
Building Age Class Definition for Music HS Elem/MS Class Years Open Yrs Open 1 1-5 1-5 2 6-15 6-11 3 16 or More 12-16 4 16 or More
*Music Allocations are restricted and have the follow ing parameters:
4 4 3
1,699 1,889 2,118
3 3 2
$ $ $
38,771 $ 43,107 $ 29,737 $
20,048 22,290 17,495
5,706
$
111,615 $
59,833
18,071
$
410,366 $
170,789
1 If a building is less than 1 year old, no funding is allocated since funding w as part of building start-up. 2 At the secondary level, minimum funding is $5,000 at Middle School and $10,000 at
Sub-total
the Senior High level. 3 Repairs have a separate budget and approved
Grand Total
0.4 Senior $ 2.36 $ 4.72 $ 8.26 $ 11.80
Building Age Class Definition-Equipment Years Open Class 1 1-5 2 6-15 3 16 or More
Notes: Senior High LSHS LSNHS LSWHS
$ $ $
0.2 0.4 Elem Middle Senior 8.63 $ 10.69 $ 11.10 10.73 $ 13.20 $ 14.04 17.01 $ 20.74 $ 22.82
by District Music Coordinator. **EQUIPMENT is defined as items costing more than $1,000 per unit.
112
2017-18 BUDGET ALLOCATION SUMMARY
Budget Resp. 101 107 102 103 104 110 120 130 131 132 140 150 160 161 170 180 210 211 211 220 221 222 223 240 241 242 300 310 320 340 350 370 380 920-600 924-600 84-600
Budget Manager Superintendent Board of Education Community Relations Lee's Summit Educational Foundation Partners In Education Asst Supt/Instruction-Leadership Asst Supt/Elementary Special Services Special Services Contracted Educational Services Miller Park Athletics Media Services Assistant Supt/Secondary Music Coordinator Testing Curriculum Asst Supt Human Resources Professional Development PDC 1% Funds Technology Data Processing Instructional Technology Career & Technical Education Student Services Student Services (Homebound) Student Services (Homeless) Associate Supt Business & Operations Aquatic Center Facilities Finance Transportation Purchasing Environmental/Risk Mgr Parents As Teachers Early Childhood Hilltop Restricted Funds Department Budget Managers Subtotal District-Wide Subtotal Building-Level Budget Managers Subtotal Grand Total Budget
113
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Total 2017-18 Allocation 91,328 180,787 66,907 24,540 39,585 561,554 469,856 414,023 965,000 27,056 412,487 177,606 830,149 135,553 201,930 68,500 503,075 68,500 597,118 1,941,052 220,302 85,243 841,915 118,670 115,500 187,021 1,863,159 196,800 2,153,049 119,670 1,521,900 890,363 18,400 45,000 60,000 20,000 15,368,697 31,602,295 254,855,225 3,640,658 290,098,178
DEBT SERVICE Under Article VI, Section 26(b) of the Constitution of Missouri, the Lee’s Summit R-7 School District may incur indebtedness for authorized school district purposes not to exceed 15 percent of the valuation of taxable tangible property in the District according to the last completed assessment. The 2017-18 legal principal debt limit is calculated at $250,569,249. With the amount of outstanding bond principal and the Debt Service fund balance, the district is under the debt capacity by $105,900,665 for 2017-18. 2017-18 DEBT SERVICE DETAIL FOR BOND PAYMENTS Series 2005/2015 2006/2014 2008/2015 2010A 2010B 2012A 2012B 2015B 2016
Principal $3,760,000 $2,750,000 $4,325,000 $0 $0 $585,000 $2,130,000 $0 $0
Interest $1,734,200 $861,900 $2,292,375 $510,204 $353,297 $48,200 $337,600 $600,000 $1,220,000
Total $5,494,200 $3,611,900 $6,617,375 $510,204 $353,297 $633,200 $2,467,600 $600,000 $1,220,000
Refunded Bonds Fees
$42,975,000
$0
TOTAL
$56,525,000
$7,957,775
$42,975,000 $10,000 $64,492,775
Various sections of Missouri law (Sections 8.231, 177.082, 177.088, 640.653) provide authority for school districts to incur debt. The lease purchase principal and interest payments are funded through the Capital Projects fund. 2017-18 DETAIL FOR LEASE PURCHASE PAYMENTS Type Principal Interest Total Copiers $314,353 $8,586 $322,939 DNR Loans $350,426 $47,640 $398,066 Electric Truck $10,002 $0 $10,002 Energy Loan $350,000 $104,428 $454,428 Energy Loan $625,000 $44,950 $669,950 Facility Site $61,069 $8,541 $69,610 Facility Vehicles $201,608 $18,088 $219,697 School Buses $1,803,291 $163,807 $1,967,097 Technology $1,069,236 $7,946 $1,077,181 Totals: $4,784,984 $403,986 $5,188,970
114
For planning purposes, this table identifies the amount of general obligation principal and interest through the pay-off of the current outstanding bonds.
Fiscal Series Series Year 2006/ 2014 2008/2015
Debt Service (Principal & Interest) By Issue Series Series Series Series Series 2012B 2015B 2010A 2010B 2012A
Series 2016
Total Debt Payments
2017-18
$3,611,900
$55,086,576
$510,204
$353,295
$633,200
$2,467,600
$600,000
$1,220,000
$64,482,775
2018-19
$1,430,300
$12,983,700
$510,204
$353,295
$636,500
$2,460,700
$600,000
$1,220,000
$20,194,699
2019-20
$2,116,800
$10,905,200
$510,204
$353,295
$624,500
$2,445,000
$600,000
$1,220,000
$18,774,999
2020-21
$1,356,800
$11,060,200
$510,204
$353,295
$637,500
$2,422,800
$600,000
$1,220,000
$18,160,799
2021-22
$3,426,700
$6,441,150
$510,204
$353,295
-
$2,434,100
$600,000
$1,220,000
$14,985,449
2022-23
$3,063,700
$6,543,750
$1,738,204
$353,295
-
-
$600,000
$1,220,000
$13,518,949
2023-24
$3,639,200
$3,166,000
$1,718,804
$353,295
-
-
$600,000
$1,220,000
$10,697,299
2024-25
$3,644,800
$3,284,250
$1,699,288
$353,296
-
-
$600,000
$1,220,000
$10,801,634
2025-26
$3,640,000
$3,521,500
$1,676,170
$353,296
-
-
$600,000
$1,220,000
$11,010,966
$6,079,000
$5,117,272 $6,800,296
-
-
2026-36 Totals
$16,820,000 $38,610,000
$73,426,568
$25,930,200 $119,071,326 $14,500,758 $9,979,953 $2,531,700 $12,230,200 $22,220,000 $49,590,000 $256,054,137
For planning purposes, this table identifies the amount of lease principal and interest through the pay-off of the current lease purchases. These lease purchases are expensed from the Capital Projects Fund. Fiscal Year
Copiers
DNR Loans
Electric Truck
Energy Loan
Energy Loan
Facility Site
Facility Vehicles
2017-18
$322,939
$398,066
$10,002
$454,428
$669,950
$69,610
$219,697
$1,967,097 $1,077,181
$5,188,970
2018-19
$322,938
$398,066
$10,476
$478,116
$649,606
$69,610
$219,697
$1,967,097
$4,115,607
2019-20
$0
$398,066
$10,963
$604,438
$235,075
$69,610
$219,697
$1,967,097
2020-21
$398,066
$11,490
$494,343
$204,650
$69,610
$219,697
$1,967,097
$3,364,953
2021-22
$0
$12,034
$495,879
$370,949
$69,610
$219,697
$1,967,097
$3,135,266
$0
$190,365
$69,790
$219,697
$0
$492,456
$0
$0
$0
School Buses
Technology $0
Total
$3,504,945
2022-23
$12,604
2023-24
$13,198
2024-25
$12,825
$12,825
2025-26
$968
$968
115
$13,198
PROJECTS FUNDED BY GENERAL OBLIGATION BONDS FOR BONDS OUTSTANDING AS OF 2017-18 2006 Issue Projects Construction Stansberry Leadership Center Construction Summit Pointe Elementary High School Remodel/Renovation (at all three high school sites) Middle School Remodel/Renovation (at all three middle school sites) Non-allocated Budget Requests/Capital Projects Team Purchasing/Distribution/Warehouse Addition School bus purchase Technology Equipment
Amount $8,588,066 $13,892,434 $1,879,563 $5,116,799 $2,000,000 $1,919,914 $500,000 $2,000,000 $35,896,776
2008 Issue Projects Aquatic Center Classroom Additions to Provide All-Day Kindergarten Construction Sunset Valley Elementary Elementary School Remodel/Renovation (Mason, Hazel Grove) Great Beginnings Addition Land Purchase for Future School Sites Lee's Summit West High School Addition Miller Park Renovation Non-allocated Budget Requests/Capital Projects Team Remodel classrooms at Lee's Summit North High School School bus purchase Technology Equipment
116
Amount $10,851,960 $10,987,421 $15,865,869 $3,973,996 $566,738 $1,374,436 $6,459,254 $2,372,362 $2,350,000 $1,041,246 $500,000 $2,138,000 $58,481,282
PROJECTS FUNDED BY GENERAL OBLIGATION BONDS FOR BONDS OUTSTANDING AS OF 2017-18 2010 Issue Projects Gymnasium Addition at Campbell Middle School High School tennis courts/stadium turf Middle School Site Land Acquisition Non-allocated Budget Requests/Capital Projects Team Performance Contract Remodel at Pleasant Lea Middle School Remodel/Addition at Lee's Summit High School Renovation/Remodel at two sites (Hazel Grove/Great Beginnings) Replace track surface at Middle School tracks School bus purchase Softball playing field at Lee's Summit North High School Technology Equipment
Amount $2,146,891 $3,338,462 $960,336 $2,375,928 $250,000 $274,675 $2,263,825 $1,680,964 $350,000 $800,000 $888,572 $2,000,000 $17,329,653
2012A Refunded 2003 Bonds & 2012B Refunded 2004 Bonds Projects Addition Meadow Lane Elementary Construction Longview Farms Elementary Middle School Addition (Pleasant Lea and Summit Lakes) Non-allocated Budget Requests/Capital Projects Team Performance Contract Remodel at High Schools (all three school sites) School bus purchase Technology Equipment
Amount $2,148,301 $9,554,812 $4,972,503 $1,600,000 $1,000,000 $417,774 $600,000 $2,171,610 $22,465,000
2015B/2016 Issue District-wide Mechanical District-wide Paving District-wide Roofing District-wide Site Improvements (28 locations) Playground Safety Improvements (Surface and Equipment) Summit Technology Center/Missouri Innovation Campus
117
$3,200,000 $1,500,000 $1,600,000 $12,935,000 $3,265,000 $17,500,000 $40,000,000
HIGHLY QUALIFIED STAFF The Comprehensive School Improvement Plan (CSIP) includes a focus on an effort to attract and retain a highly qualified teaching and support staff. Regular meetings of certified staff are held in a collaborative environment to support the district Professional Learning Communities. Measurable indicators and effective action plans are used to meet district strategies, tasks and Professional Development program needs. The district, through TEAM Lee’s Summit, the Superintendent’s Leadership Team and Board of Education, remains committed to providing competitive salaries that are in the top third of Kansas City Metro area schools. The FY18 Budget includes base salary and benefit increases and an additional 37.49 FTE (full time equivalent) staff positions. The District provides a comprehensive benefits package for all regular employees representing approximately 25% of the total compensation package. Retirement and employee insurance are the major expenses in the Benefit category, accounting for 89% of the total amount spent for benefits. The District is required to match contributions to the state retirement system for eligible employees, currently at the rate of 14.50% for Teacher Retirement and 6.86% for Non-Certificated staff. It is anticipated that the matching contribution percent required by the District will not increase for the next few budget years. The District has also taken a proactive approach to employee insurance in order to minimize the impact on budgeted expenses. The District opened an employee health center during the 2015-16 school year for employees, dependents and retirees covered on one of the District’s health insurance plans. The health center also provides services for employees injured at work to reduce impact of workers’ compensation costs on the District budget. Key selected staff-related information is included in the table and graphs below, including the changes in full time equivalent employees, degree level of certified staff, district and state comparison of staff with Master-level and above degrees, district and state comparison of professional staff experience and district’s retention percentages of certified and support staff.
STAFFING HISTORY SUMMARY Budget 2013-14
FTE (Full Time Equivalent) Employees
Budget 2014-15
Budget 2015-16
Budget 2016-17
Budget 2017-18
Administrators/District wide Managers
95
102
102.64
111.64
112.64
Custodians & Maintenance Personnel
193
200
200.5
200.50
205.5
Health Services
51.03
57.66
59.66
58.6
59.6
Before & After School Services
45.83
33.6
33.6
40.50
40.5
Nutrition Services
129.25
139.1
139.36
139.36
139.36
Secretaries and Library Clerks
154.64
154.64
155.87
158.23
161.12
Teacher Aides, Paraprofessionals, School Site Support
273.87
299.29
307.36
308.36
309.86
Teacher Assistants, Parent Educators, Therapists
51.51
55.01
55.01
58.51
59.51
Teachers, Counselors, Library Media Specialists
1236.79
1264.64
1274.83
1289.5
1300.42
45
45
47.02
49
49.18
Technology Transportation
178 TOTAL FTE:
2,453.92
118
179.5 2,530.44
179.5 2,555.35
179.5
193.5
2,593.70
2,631.19
*Advanced degrees defined as Masters degree or higher.
119
120
KEY STUDENT PERFORMANCE INDICATORS ACT The ACT Program is a comprehensive system for collecting and reporting information about students planning to enter post-secondary education. The ACT is designed to assess the general educational development of high school students and readiness for success with college-level work. It consists of four major components: English, Math, Reading and Scientific Reasoning. Key findings include:
• For six straight year (2010-2015), the average ACT composite score was 23.0 or higher. • Lee’s Summit students consistently scored higher than Missouri and national averages. • The percent of graduates taking the ACT in Lee’s Summit when compared to Missouri for years 2013 through 2016 is provided in the table below. Year 2013 2014 2015 2016
Lee’s Summit R-7 72.80% 75.30% 73.60% 95.80%
Missouri 64.80% 66.10% 67.60% 91.70%
Beginning in the spring of 2015 all juniors in the state of Missouri were provided an ACT during the school day at no cost to students or districts. As a result, beginning in 2016 a new set of data is available inclusive of results from the all-junior census testing.
121
DROPOUT RATE According to a number of sources, students who drop out of high school are ineligible for 90 percent of jobs in the United States and a high school graduate’s lifetime income is 50 to 100 percent higher than students who do not complete their high school education. In Lee’s Summit R-VII, the dropout rate has been consistently lower than the Missouri average. For the 2015-16 school year, the dropout rate remained consistent at 1.2 percent.
FREE/REDUCED PRICED MEALS The number of students eligible for free/reduced price meals is increasing in the Lee’s Summit R-7 District and has increased by approximately 75 percent in the last ten years. Children eligible for free/reduced price meals generally come from low-income households. The District’s building principals and instructional teams analyze this date on a regular basis to provide additional support and resources to students.
122
GRADUATION RATE The Lee’s Summit graduation rate continues to be significantly above the state's graduation rate. In the 2015-16 school year, Lee’s Summit had a graduation rate of 94.6 percent, compared to the Missouri average of 89.1 percent.
STUDENT ATTENDANCE Student attendance is the District’s basis for receipt of state aid and local Proposition C tax revenue. The District’s attendance rate is significantly above the state average. In the 2015-16 school year, the attendance rate was 92.8 percent compared to the Missouri average of 89.7 percent.
123
MISSOURI ASSESSMENT PROGRAM (MAP) The Missouri Assessment Program (MAP) is mandated by the Outstanding Schools Act of 1993. As a result of this Act, the State Board of Education directed the Department of Elementary and Secondary Education (DESE) to identify the knowledge, skills and competencies that students should acquire and to assess student progress toward those academic standards. Students in grades 3-8 take the MAP Grade Level Assessments annually and are tested in the areas of English language arts and mathematics. Students in grades 5 and 8 also complete a science assessment.
124
2017-18 SCHOOL YEAR CALENDAR
125
GLOSSARY The glossary contains definitions of terms used in this budget and such additional terms as deemed necessary to common understandings concerning financial accounting procedures. Several terms, which are not primarily financial accounting terms, have been included because of their significance for school financial accounting. The glossary is arranged alphabetically. ACCOUNTING SYSTEM-The total structure of records and procedures which discover, record, classify, and report information on the financial position and operations of a school district or any of its funds, and organizational components. ADA- Average daily attendance of students. Calculated by dividing total actual hours of attendance of all students by the amount of scheduled hours (or possible hours) for the term. APPROPRIATION-An authorization granted by a legislative body to make expenditures and to incur obligations for specific purposes. Note: An appropriation is usually limited in amount and as to the time when it may be expected. ASSESSED VALUATION- A valuation set upon real estate or personal property by a government as a basis for levying taxes. In Missouri, the assessed value is a percentage of the appraised value as follows: residential 19%, personal property - 33 1/3%, Commercial - 32%, Agriculture - 12%. BOARD OF EDUCATION-The elected body which has been created according to state law and vested with responsibilities for educational activities in a given geographical area. BOND-A written promise, generally under seal, to pay a specific sum of money, called the face value, at a fixed time in the future, called the date of maturity and carrying interest at a fixed rate, usually payable periodically. BONDED DEBT-The part of the school district debt that is covered by outstanding General Obligation bonds of the district. BUDGET - A plan of financial operation embodying an estimate of proposed expenditures for a given period or purpose and the proposed means financing those expenditures. BUDGET MANAGER -The role designated to control or manage the business affairs of the school or department level in accordance with an approved budget with a responsibility to keep expenditures within the authorized amounts. CAPITAL OUTLAY - Expenditures that result in the acquisition of or addition to fixed assets. CAPITAL PROJECTS TEAM – A team, including representation from all levels in the District, whose major goal is to evaluate requests for capital expenses that are greater than the resources allocated to the site/department. The team meets on an annual basis, is allocated resources in the budget process and prepares a recommendation of projects for Board of Education approval. CLASSIFICATION, FUNCTION - As applied to expenditures, this term has reference to an activity or services aimed at accomplishing a certain purpose or end. CLASSIFICATION, OBJECT - As applied to expenditures, this term has reference to an article or service received; for example, salaries, employee benefits or supplies. CLASSROOM TRUST FUND - A state formula category for the gaming money paid to districts through the formula. Districts have the option to record the revenue and expense in the fund approved by the Board of Education. CODING - A system of numbering, or otherwise designating, accounts, entries, invoices, etc., in such a manner that the symbol used reveals quickly certain required information. CONTRACTED SERVICES - Labor, material and other costs for services rendered by personnel who are not on the payroll of the local education agency.
126
CPI - Consumer Price Index - Used to track the change in the cost of consumer goods over a period of time usually one year. CSIP – Comprehensive School Improvement Plan, a model which provides the framework to guide all components of school district operation. CURRENT EXPENDITURES PER PUPIL - Current expenditures for a given period of time divided by pupil unit of measure. DEBT - An obligation resulting from the borrowing of money or from the purchase of goods and services. Debts of local education agencies include bonds, warrants and notes, etc. DEBT LIMIT - The maximum amount or gross or net debt that is legally permitted. (15% of assessed valuation for school districts in Missouri) DEBT SERVICE - Expenditures for the retirement of debt and expenditures for the interest on debt. (Funds must be segregated) DNR – Department of Natural Resources. DOLLAR VALUE MODIFIER - Used within the new Foundation Formula calculation as introduced by SB287. This modifier will alter the dollar amount received by a school district based on a variable for the relative purchasing power of a district in the various areas of the state. The modifier uses the state's median wage-perjob and a standard deviation from that point to increase or decrease the base amount to be received by each district. ECSE (Early Childhood Special Education) - A state and federally funded program designed to target preKindergarten children who are identified as having special needs. ENCUMBRANCES - Purchase orders, contracts, and/or other commitments which are chargeable to an appropriation and for which a part of the appropriation is reserved. They cease to be encumbrances when paid, as in accounts payable, or when the actual liability is established or when cancelled. EQUIPMENT - Those moveable items used for school operation that are of a non-expendable and mechanical nature, i.e. perform an operation. Computers, printers, smart boards, projectors, vacuum cleaners, lathes, clocks, machinery, and vehicles, etc. are classified as equipment. ELL - English Language Learners - Curriculum designed to support students who do not speak English as their primary language. EXPENDITURES - Total charges incurred for current costs, capital outlay, and debt service. FISCAL YEAR (FY) - Any period at the end of which a local education agency determines its financial position and the results of its operations. The fiscal year of the Lee’s Summit R-VII School District is July 1 to June 30. FTE – Full Time Equivalent – refers to staffing and the calculation of hours/days worked in comparison to the default hours/days required of a position. FUNCTION - As applied to expenditures, this term has reference to an activity or service aimed at accomplishing a certain purpose or end; for example, Instruction, Instructional Administration, Plant Maintenance and Operations. (Also may be referred to as Program.) FUND - A sum of money or other resources set aside for specific activities of a school district. The fund accounts constitute a complete entity and all of the financial transactions for the particular fund are recorded in them. FUND BALANCE - The excess of assets of a fund over its liabilities and reserves. During the fiscal year prior to closing, it represents the excess of the fund's assets and estimated revenues for the period over its liabilities, reserves and appropriations for the period. FUND, GENERAL - The fund used to finance the ordinary operations of the local education agency. It is
127
available for a legally authorized purpose and consists of money not specifically designated for some other particular purpose. IB – International Baccalaureate, an international program of education that develops the intellectual, personal, emotional and social skills needed to live, learn and work in a rapidly globalizing world. IDEA - Individuals with Disabilities Education Act, a federal program protecting the rights of special needs students in public schools. INSTRUCTION - The activities dealing directly with the teaching of students or improving the quality of teaching. LEVY - To impose taxes or special assessments-verb. The total of taxes or special assessments imposed by a governmental unit-noun. LRP - Long range planning. M&M - Merchants and Manufacturers Tax Revenue, a surcharge on commercial real estate to replace revenue lost with the elimination of the merchants and manufacturing business inventory tax. MAP - Missouri Assessment Program, a state criterion based achievement program designed to test the student in Math, Communication Art, Social studies and Science at certain grade levels. MODIFIED CASH BASIS OF ACCOUNTING - Revenues and expenses and related assets and liabilities for all activities are recorded when they result from cash transactions. MSIP - Missouri School Improvement Program, the accreditation review for Missouri schools. MUSIC -Missouri Unified School Insurance, the use of the purchasing power of many united school districts to improve insurance coverage, service and cost. NON-ALLOCATED – Refers to the budget process for additional operating, capital or technology resources that are greater than the resources allocated to the site or department. OBJECT - As applied to expenditures, this term has reference to the classification of goods or services received; for example, salary, benefits, purchased services, supplies, capital outlay, debt service. PAT - Parents as Teachers, a preschool child focused program utilizing parents as teachers under the guidance of trained professional staff members. PDC -Professional Development Committee, an employee-based committee responsible for planning activities and providing support for professional growth. PERSONNEL, ADMINSTRATIVE - Personnel on the school payroll who are primarily engaged in activities which have as their purpose the general regulation, direction, and control of the affairs of the school district. PERSONNEL, CLERICAL - Personnel occupying support positions which have as their major responsibilities the preparing, transferring, transcribing, systematizing, or preserving of written communications and records. This includes classroom aides. PERSONNEL, HEALTH - Persons in the field of physical and mental health such as physicians, psychologists, school nurses, and dentists whose services are directed primarily to students, although sometimes used in group activities. PERSONNEL, INSTRUCTION - Those who render services dealing with the instruction of pupils. PERSONNEL, MAINTENANCE -Personnel occupying support positions which are primarily engaged in the repairing and upkeep of grounds, buildings, and equipment. PIE -Partners in Education, a cooperative program with businesses in the District to further the future of the students in the corporate setting or environment.
128
PROGRAM -The definition of an effort to accomplish a specific objective or objectives consistent with funds or resources available. Budgets and actual revenue and expenditures records may be maintained per program. PROGRAM BUDGET - A budget wherein expenditures are based primarily on programs of work and secondarily on character and object. A program budget further defines function to subject area when necessary. RECEIPTS/ REVENUE - Additions to assets which do not incur an obligation that must be met at some future date and do not represent exchanges of property for money. ROTC -Reserve Officer Training Corps, a military training oriented program for high school students who show an interest in future military careers. SB287 (SENATE BILL 287) - A Missouri law passed in April, 2005. The bill revised the state aid formula distributing $2 billion to Missouri public school districts. The funding provided by SB287 is considered a formula that seeks to provide adequate and equitable funding for student needs and replaced a formula that was primarily tax-levy driven. SCHOOL, ELEMENTARY - A school o f fe r in g ed uc a tio n t o s t ud e nt s in g ra d es k in de r g a rt e n t h r ou gh s i xt h g r ad e . SCHOOL, MIDDLE - A school offering education to students spanning both elementary and secondary levels, grades 7 and8. SCHOOL, SENIOR HIGH - A school offering education to students in grades nine through twelve. SCHOOL, SUMMER - The name applied to the school session carried on during the period between the end of regular school term and the beginning of the next regular school term. SCHOOL, VOCATIONAL - A secondary school which is separately organized under a principal for the purpose of offering training in one or more skilled or semi-skilled trades or occupations. Students may choose to attend Cass Career Center or Herndon Career Center. SCHOOL SITE - The land and all improvements to the site, other than structures, such as grading, drainage, drives, parking areas, walks, plantings and playgrounds, and playfields. STATE ADEQUACY TARGET (SAT) - An amount of expenditure per student that is the base for the Foundation Formula put into law by SB287. The adequacy target is the amount per year spent by certain high performing districts in the state and is subject to change every two years. STUDENT ACTIVITIES - Services for public school pupils such as interscholastic athletics, entertainment, publications, clubs, band, and orchestra, managed or operated by the student body under the guidance and direction of an adult, and are not part of the regular instructional program. SUPPLY - A material item of an expendable nature that is consumed, worn out, or deteriorated in use; or one that loses its identity through fabrication or incorporation into a different or more complex unit or substance. SURETY BOND - A written promise to pay damages or to indemnify against losses caused by the party or parties named in the document, through nonperformance or through defalcation; for example, a surety bond given by a contractor or by an official handling cash or securities. TALENTED AND GIFTED - A separate curriculum for students displaying above average ability through testing, sustained grade point average and measure of intelligence (IQ). TAXES - Compulsory charges levied by a governmental unit for the purpose of financing services performed for the common benefit. WADA-WEIGHTED AVERAGE DAILY ATTENDANCE (ADA)-The current basis for distribution within the Foundation Formula calculations introduced by SB287. The ADA is weighted for specific student characteristics, specifically, free and reduced-price lunch, special education needs or limited English language proficiency.
129
