Question: Formulate an LP model, then use Solver to create Answer and Sensitivity Reports for your model and answer the following questions. (a) If the profit

 Formulate an LP model, then use Solver to create Answer and

Formulate an LP model, then use Solver to create Answer and Sensitivity Reports for your model and answer the following questions. (a) If the profit on doors increased to $600 would the optimal solution change? Yes No (b) If the profit on windows decreased to $175 would the optimal solution change? Yes No (c) Explain the shadow price (in dollars) for the finishing process. The shadow price for the finishing process is $ . This is because in the optimal solution the available finishing time has been used up. So, we would expect an increase to the amount of time available for finishing to result in Select. V change to the optimal profit. (d) If 24 additional hours of cutting capacity became available, how much additional profit (in dollars) could the company earn? $ number in dollars.) Sanderson agree to this since it woulc Sanderson's total profit by $ How (if at all) would your answer change if the company instead wanted 25 hours of sanding capacity? (Enter your answer as a positive number in dollars.) Our answer since this would Sanderson's total profit by $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!