For the nonlinear pricing decision model in Example 14.8, suppose that the company wants to keep the

Question:

For the nonlinear pricing decision model in Example 14.8, suppose that the company wants to keep the price at a maximum of $500. Note that the solution in Figure 14.19 will no longer be feasible. Modify the spreadsheet model to include a constraint on the maximum price and solve the model. Interpret the information in the Solver Sensitivity Report.

Data from Figure 14.19

Optimal Solver Solution for Pricing Decision Model