Due soon,! We know that Branch 5 is inefficient and should aspire to Branches 1,

Question

Due soon,!

We know that Branch 5 is inefficient and should aspire to Branches 1,6, and 8. From the efficiency analysis, we also learn that Branch 10 is also inefficient. See worksheet below. At your request, your buddy has also generated the sensitivity report for Branch 10. What is the measured efficiency of Branch 10? Perform a complete analysis of efficiency improvment alternatives for Branch 10, including determination of a composite reference unit. Does Branch 10 aspire to the same branches as Branch 5?

Thank you so much..

specific numbers in Allowable decrease for constraint is 0.1284. Allowable increase for constraint is 0.0384.

Fidelity savings & Loans Outputs Inputs Weighted Weighted Branch ROA New Loansatisfactio Labor Hrs Costs Ou Difference Effic 2 339 780 94 349 443 06304 0.6957 1.0.0653 1.0000 3 495 790 93 598 631 8537 1.0653 -0.2116 0.8297 5 640 910 98 869 02 -0.2868 0.8099 6.38 742 9 598 770 94 4.74 75 r 0.9961 1.0175 -0,0214 0.9922 16 17 weights 0.1419 0.0002 0.0000 0.0137 0.0990 T B20 By changing: B17:F17 18 Subject to 19 Branch B21 20 Output 0.8834 21 input 1.0000

Explanation / Answer

This problem can be considered as the product mix problem in Operation Research.

The problem is to find values of P and Q that maximize the objective of the problem. We use the add-in to generate the model in Excel. The model is then solved with the excel solver only. The worksheet with the model is given in the question. Notice that the model has eight constraints representing the branches. The market constraints on production are represented as simple upper bounds. These could have been included in the constraint set, but using simple upper bounds provides a more compact model.

This result is determined from the sensitivity analysis.

The final value is the amount of that variable for the optimum solution.

We can easily see that the Allowable Increase and Decrease columns give the change in the constraint limit within which the current basis remains optimal. then we carry out the parametric analysis and conclude our analysis by plotting the parametric response plot.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.