Use the provided excel format to formulate ananswer
The Salem Board of Education wants to evaluate the efficiency ofthe town’s four elementary schools. The three outputs of theschools are
â– Â Â output 1 = average reading score
â– Â Â output 2 = average mathematics score
â– Â Â output 3 = average self-esteem score
The three inputs to the schools are
â– Â Â input 1 = average educational level ofmothers
(defined by highest grade completed: 12 = high
school graduate; 16 = college graduate, and so on)
â– Â Â input 2 = number of parent visits to school (perchild)
â– Â Â input 3 = teacher-to-student ratio
The relevant information for the four schools is given in the fileP04_42.xlsx. Determine which (if any) schools are inefficient.
| Selected DEA school | | | |
| Inputs used for outputs produced | | |
| Inputs |
| School | Input 1 | Input 2 | Input 3 |
| 1 | 13 | 4 | 0.05 |
| 2 | 14 | 5 | 0.05 |
| 3 | 11 | 6 | 0.06 |
| 4 | 15 | 8 | 0.08 |
| | | |
| Outputs |
| School | Output 1 | Output 2 | Output 3 |
| 1 | 9 | 7 | 6 |
| 2 | 10 | 8 | 7 |
| 3 | 11 | 7 | 8 |
| 4 | 9 | 9 | 9 |
| | | |
| Input 1 | Input 2 | Input 3 |
| Unit costs of inputs | | | |
| | | |
| Output 1 | Output 2 | Output 3 |
| Unit value of outputs | | | |
| | | |
| Costs/prices of inputs/outputs used | | |
| School | Input costs | | Output values |
| 1 | | | |
| 2 | | | |
| 3 | | | |
| 4 | | | |
| | | |
| Selected school input cost | | | |
| | | |
| Selected school output value | | | |
| | | |
| School | Efficient or not? | | |
| 1 | | | |
| 2 | | | |
| 3 | | | |
| 4 | | | |
Use the provided excel format to explainanswer
