I need help in this question. Please do it correctly and follow all the steps. Please show me all the steps so i can solve it myself. Please use SOLVER TABLE. Must use solver Table as Part B is related to SOLVER TABLE. This is the only data we have given in excel and question statement is also same it is
PLEASE SHOW ALL STEPS
A B D E F G H 1 K 1 2 3 Question 11. Consider a group of five hospitals as shown below. Please: 4 a. Build DEA model in this spreadsheet, and find the efficiency for the hospital 1 via Solver. 5 b. Using SolverTable, find the efficeincy for all hospitals (hint: by changing the cell "Selected hospital"). 6 7 8 9 10 11 12 13 DEA model for checking efficiency of a selected hospital 14 D E F G H | J L Output 1 Output 2 Output 3 9 4 16 5 7 10 Outputs produced Hospital 1 Hospital 2 Hospital 3 Hospital 4 Hospital 5 4 9 9 A B C 13 DEA model for checking efficiency of a selected hospital 14 15 Selected hospital 1 16 17 Inputs used Input 1 Input 2 18 Hospital 1 5 14 19 Hospital 2 8 15 20 Hospital 3 7 12 21 Hospital 4 6 18 22 Hospital 5 10 13 23 24 Unit costs of inputs 25 26 Constraints that input costs must cover output values 27 Hospital Input costs 28 1 29 2 13 7 8 15 6 10 14 Unit prices of outputs Output Values 30 3 31 4 32 5 33 33 34 Constraint on selected hospital's input cost 35 Selected hospital input cost 36 37 Maximize selected hospital's output value 38 Selected hospital output value 39 A B D E F G 1 2 3 4 5 5 6 6 7 8 oo Oy 9 10 11 12 13 14 15 un 16 17 18 19 20 21 22 Part I, Multiple Choices Q11.a (20 pts) Q11.b (10 pts) A B D E F G H 1 K 1 2 3 Question 11. Consider a group of five hospitals as shown below. Please: 4 a. Build DEA model in this spreadsheet, and find the efficiency for the hospital 1 via Solver. 5 b. Using SolverTable, find the efficeincy for all hospitals (hint: by changing the cell "Selected hospital"). 6 7 8 9 10 11 12 13 DEA model for checking efficiency of a selected hospital 14 D E F G H | J L Output 1 Output 2 Output 3 9 4 16 5 7 10 Outputs produced Hospital 1 Hospital 2 Hospital 3 Hospital 4 Hospital 5 4 9 9 A B C 13 DEA model for checking efficiency of a selected hospital 14 15 Selected hospital 1 16 17 Inputs used Input 1 Input 2 18 Hospital 1 5 14 19 Hospital 2 8 15 20 Hospital 3 7 12 21 Hospital 4 6 18 22 Hospital 5 10 13 23 24 Unit costs of inputs 25 26 Constraints that input costs must cover output values 27 Hospital Input costs 28 1 29 2 13 7 8 15 6 10 14 Unit prices of outputs Output Values 30 3 31 4 32 5 33 33 34 Constraint on selected hospital's input cost 35 Selected hospital input cost 36 37 Maximize selected hospital's output value 38 Selected hospital output value 39 A B D E F G 1 2 3 4 5 5 6 6 7 8 oo Oy 9 10 11 12 13 14 15 un 16 17 18 19 20 21 22 Part I, Multiple Choices Q11.a (20 pts) Q11.b (10 pts)
