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
V.21-22
Instructions:
Determine the FTE based on the information provided.
Use the Chart for Computing School Revenue and FEFP manual
Use the attached Excel Spread Sheet and related colored information Tabs
(this link originates in the EDU 675 Canvas Course – You must be logged into your Canvas Course to open this link) The document is also available in the Canvas Course under the Syllabus link).
Create a name for your school.
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”. (See Page 3 - Reference the Prototype School Average Salary Worksheet for positions and salaries.)Consider the vision and mission of the school.
What programs will be offered?
Do you need additional teachers/personnel?
What are the class size requirements that would suit the needs of your school?
Do you need instructional support?
Do you need money for supplies? If so, how much?
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 | 1450 | ||
ESOL | 34 | 30 | 205 | ||
ESE* | 36 | 100 | 71 | ||
*ESE services include Level 4 and 5 services. You determine the quantity. | |||||
Grade 2 = 4 Grade 4 = 12 Grade 5 = 4 Level 4 = 7 Level 5 = 4 | Grade 6 = 27 Grade 7 = 35 Grade 8 = 30 Level 4 = 3 Level 5 = 5 | Grade 9 = 16 Grade 10 = 29 Grade 11 = 12 Grade 12 = 8 Level 4 = 2 Level5 = 4 |
(NEXT PAGE)
Based on the total school population, the school generates the following personnel:
Positions | Elementary | Middle | High School |
Teachers | 15 | 24 | 35 |
Clerical | |||
Custodians | 10 | ||
Assistant Principal(s) | |||
Security Monitor(s) |
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”.
Include the ten items presented on the Page 1 Instructions
See the Worksheet for Positions and Salaries – Page 3
Submit your response by 11:59 EST of Day 7.
Worksheet for Positions and Salaries
Though salaries averages will vary greatly depending on the school district, type of school, level, responsibility and experience, use the below published averages as a base for this assignment.
Teacher: Florida’s teachers earned an average of $57,729 per contract year.
https://www.salary.com/research/salary/benchmark/public-school-teacher-salary/fl
PERCENTILE | SALARY | LOCATION | LAST UPDATED |
10th Percentile Public School Teacher Salary | $43,713 | FL | February 25, 2022 |
25th Percentile Public School Teacher Salary | $50,393 | FL | February 25, 2022 |
50th Percentile Public School Teacher Salary | $57,729 | FL | February 25, 2022 |
75th Percentile Public School Teacher Salary | $66,658 | FL | February 25, 2022 |
90th Percentile Public School Teacher Salary | $74,789 | FL | February 25, 2022 |
Assistant Principal: The average salary for a Miami area Assistant Principal is $89, 230
https://www.salary.com/tools/salary-calculator/assistant-school-principal/miami-fl?view=table
PERCENTILE | SALARY | LOCATION | LAST UPDATED |
10th Percentile Assistant School Principal Salary | $67,384 | Miami,FL | February 25, 2022 |
25th Percentile Assistant School Principal Salary | $77,795 | Miami,FL | February 25, 2022 |
50th Percentile Assistant School Principal Salary | $89,230 | Miami,FL | February 25, 2022 |
75th Percentile Assistant School Principal Salary | $104,289 | Miami,FL | February 25, 2022 |
90th Percentile Assistant School Principal Salary | $117,999 | Miami,FL | February 25, 2022 |
Principal: The average School Principal salary in Florida is $109,64 per year.
https://www.salary.com/tools/salary-calculator/school-principal/west-palm-beach-fl?view=table
PERCENTILE | SALARY | LOCATION | LAST UPDATED |
10th Percentile School Principal Salary | $84,738 | West Palm Beach,FL | February 25, 2022 |
25th Percentile School Principal Salary | $96,331 | West Palm Beach,FL | February 25, 2022 |
50th Percentile School Principal Salary | $109,064 | West Palm Beach,FL | February 25, 2022 |
75th Percentile School Principal Salary | $122,685 | West Palm Beach,FL | February 25, 2022 |
90th Percentile School Principal Salary | $135,086 | West Palm Beach,FL | February 25, 2022 |
Clerical / Secretary: The average salary Clerical staff $35,000 per year.
Custodial: The Custodial Average in Florida. $24,000 per year.
Security Guard: Unarmed role earned an average salary of $30,000 in Florida
Page 4 of 4