Decision Support using Excel

Order Description

The Springville School District has seven elementary schools. The following table shows the current enrollment in each elementary school and the number of teachers currently assigned
to each school. The district has established a goal of ensuring that there is at
least one teacher for every 20 students in each elementary school. (You can divide the number of students by the
number of teachers to determine this ratio for each school.) Is it possible to achieve this goal
without increasing the number of teachers in the district?