Modify the synchronized ordering model in Example 12.5 slightly so that you can use a two-way SolverTable on the fixed costs. Specifically, enter a formula in cell B9 so that the fixed cost of ordering kings alone is equal to the fixed cost of ordering queens alone. Then let the two inputs for SolverTable be the fixed cost of ordering queens alone and the joint fixed cost of ordering both kings and queens together. Let these vary over a reasonable range, but make sure that the first input is less than the second, and the second input is less than twice the first. (Otherwise, the model wouldn’t be realistic.)

Capture the changing cells and the sum of annual setup and holding costs as SolverTable outputs. Describe your findings in a brief report.

Skill-Extending Problems