Please Solve in Excel Solver

Please Solve in Excel Solver

HW 11: Model an applicaton using DEA and solve it with Excel A bank has 4 branches. Branch 1 has 15 people and uses a building of 140m; Branch 2 has 20 people and uses a building of 130m; Branch 3 has 21 people and uses a building of 120m; Branch 4 has 20 people and uses a building of 135m; Each branch produces three types of products A, B,C. Branch 1 produces 1800 (product A), 200 (product B), 1600 (product C); Branch 2 produces 1000 (product A), 350 (product B), 1000 (product C); Branch 3 produces 800 (product A), 450 (product B), 1300 (product C); Branch 4 produces 900 (product A), 420 (product B), 1500 (product C). Analyze the DEA efficiency of Branch 3 and Branch 4. You need to hand in LP models and your conclusion after solving it using Excel Solver. HW 11: Model an applicaton using DEA and solve it with Excel A bank has 4 branches. Branch 1 has 15 people and uses a building of 140m; Branch 2 has 20 people and uses a building of 130m; Branch 3 has 21 people and uses a building of 120m; Branch 4 has 20 people and uses a building of 135m; Each branch produces three types of products A, B,C. Branch 1 produces 1800 (product A), 200 (product B), 1600 (product C); Branch 2 produces 1000 (product A), 350 (product B), 1000 (product C); Branch 3 produces 800 (product A), 450 (product B), 1300 (product C); Branch 4 produces 900 (product A), 420 (product B), 1500 (product C). Analyze the DEA efficiency of Branch 3 and Branch 4. You need to hand in LP models and your conclusion after solving it using Excel Solver