Creating Your School and Its Budget Activity Instructions 1. Determine the FTE based on the information provided. a. Use the Chart for Computing School Revenue and FEFP manual, OR b. Excel Fu


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”.