Next, load the solver by filling in the \'Set Target Cell \', \'By Changing Cell

Question

Next, load the solver by filling in the 'Set Target Cell', 'By Changing Cells', and 'Subject to the Constraints' boxes.

Once you have loaded the solver and solved the problem, you are required to obtain the sensitivity analysis. If you do this correctly, the 'Sensitivity Report' will show up in a new tab in the bottom of the sheet.

Question 1 (20 Points): What are the optimal solution and the total profit?

Question 2 (20 Points): If the unit profit of the DRW decreases to $260 per unit, how would the optimal solution change?

Question 3 (20 Points): How much should the company be willing to pay to acquire additional capacity in the 'Assembly minutes' area? Explain in detail.

Question 4 (20 Points): How much should the company be willing to pay to acquire additional 'Steel'? Explain in detail.

Question 5 (20 Points): How much will the objective function, 'Total Profit', change if there was one additiional hour of Manufacturing capacity available?

Explanation / Answer

Question 1 (20 Points): What are the optimal solution and the total profit?

optimal solution : DRB = 1000, DRW= 800, total profit = 424000$

Question 2 (20 Points): If the unit profit of the DRW decreases to $260 per unit, how would the optimal solution change?

optimal solution : DRB = 1000, DRW= 800, total profit = 408000$

Question 3 (20 Points): How much should the company be willing to pay to acquire additional capacity in the 'Assembly minutes' area? Explain in detail.

It can increase by 1E+30, as the maximum allowable change in assembly minutes, without changing the optimal solution is e+30, from sensitivity report

Question 4 (20 Points): How much should the company be willing to pay to acquire additional 'Steel'? Explain in detail.

It can increase by 20000$, as the maximum allowable change in steel without changing the optimal solution is 20000$, from sensitivity report

Question 5 (20 Points): How much will the objective function, 'Total Profit', change if there was one additiional hour of Manufacturing capacity available?

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

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