Q: In the current no-backlogging problem, SureStep doesn’t hire any
In the current no-backlogging problem, SureStep doesn’t hire any workers and uses almost no overtime. This is evidently because of low demand. Change the demands to 6000, 8000, 5000, and 3000, and reo...
See AnswerQ: In the SureStep no-backlogging problem, change the demands so
In the SureStep no-backlogging problem, change the demands so that they become 6000, 8000, 5000, 3000. Also, change the problem slightly so that newly hired workers take six hours to produce a pair of...
See AnswerQ: We saw that the natural way to model SureStep’s backlogging model,
We saw that the natural way to model SureStep’s backlogging model, with IF functions, leads to a nonsmooth model that Solver has difficulty handling. Another version of the problem is also difficult f...
See AnswerQ: Suppose, as a matter of corporate policy, that General Flakes
Suppose, as a matter of corporate policy, that General Flakes decides not to advertise on the “Rachael Ray” show. Modify the original advertising model appropriately and find the new optimal solution....
See AnswerQ: Use SolverTable in Chandler’s blending model to see whether, by increasing
Use SolverTable in Chandler’s blending model to see whether, by increasing the selling price of gasoline, you can get an optimal solution that produces only gasoline, no heating oil. Then use SolverTa...
See AnswerQ: Use SolverTable in Chandler’s blending model to find the shadow price of
Use SolverTable in Chandler’s blending model to find the shadow price of crude oil 1—that is, the amount Chandler would be willing to spend to acquire more crude oil 1. Does this shadow price change a...
See AnswerQ: Modify Acron’s model so that sales increase, then stay steady,
Modify Acron’s model so that sales increase, then stay steady, and finally decrease. Specifically, assume that the gross margin is $1.2 million in year 1, then increases by 10% annually through year 6...
See AnswerQ: How sensitive is the optimal solution (barrels of each input and
How sensitive is the optimal solution (barrels of each input and output sold and total revenue) to the required quality levels? Answer this by running a two-way SolverTable with these five outputs. Yo...
See AnswerQ: In Chandler’s blending model, suppose a chemical ingredient called CI is
In Chandler’s blending model, suppose a chemical ingredient called CI is needed by both gasoline and heating oil. At least 3% of every barrel of gasoline must be CI, and at least 5% of every barrel of...
See AnswerQ: In the current blending model, a barrel of any input results
In the current blending model, a barrel of any input results in a barrel of output. However, in a real blending problem, there can be losses. Suppose a barrel of input results in only a fraction of a...
See Answer
