Creating Your School and Its Budget Activity
Instructions1. Determine the FTE based on the information provided. a. Use the Chart for Computing School Revenue and FEFP manual, OR
b. Excel Funding Schools 2022_2023.xlsx Download Excel Funding Schools 2022_2023.xlsx Use the attached Excel Spread Sheet and related colored information Tabs
2. Create a name for your school.3. Once you determine the amount of money that you will receive based on your calculated budget from FTE, you need to purchase personnel/supplies/other.a. Balance to “0”. (Reference the Prototype Elementary School K-5 Worksheet for positions and salaries. 2022 Update – see page 3 of 3 on the link document. )Download Reference the Prototype Elementary School K-5 Worksheet for positions and salaries. 2022 Update – see page 3 of 3 on the link document. )b. Consider the vision and mission of the school.c. What programs will be offered?d. Do you need additional teachers/personnel?e. What are the class size requirements that would suit the needs of your school?f. Do you need instructional support?g. Do you need money for supplies? If so, how much?4. Discuss and explain your school, budget, and rationale for the choices in personnel and other expenditures.
School Level Elementary Middle High School
Population 485 760 1450ESOL 34 30 205ESE* 36 100 71
*ESE services include Level 4 and 5 services. You determine the quantity.
Grade 2 = 4 Grade 6 = 27 Grade 9 = 16 Grade 3 = 5 Grade 7 = 35 Grade 10 = 29 Grade 4 = 12 Grade 8 = 30 Grade 11 =12 Grade 5 = 4 Level 4 = 3 Grade 12 = 8 Level 4 = 7 Level 5 = 5 Level 4 = 2 Level 5 = 4 Level 5 = 4
Based on the total school population, the school generates the following personnel:
Positions Elementary Middle High SchoolTeachers 15 24 35Clerical 2 2 5Custodians 2 5 10Assistant Principal(s) 1 2 4Security Monitor(s) 1 4 8
Remember to:
- determine the FTE for your given population
- calculate the budgeted annual amount of money you will receive based on FTE suing the FTE formula.
- determine class size requirements that would suit your school needs
- balanced to “0”.
