In the quantity discount model in Example 13.2, suppose we want to see how the optimal order quantity and the total annual cost vary as the fixed cost of ordering varies. Use a two-way SolverTable to...

In the quantity discount model in Example 13.2, suppose we want to see how the optimal order quantity and the total annual cost vary as the fixed cost of ordering varies. Use a two-way SolverTable to perform this analysis, allowing the fixed cost of ordering to vary from $50 to $200 in increments of $50. Indicate the optimal ordering policy for each fixed cost of ordering.

Example 13.2