Zooter’s sales department has revised its projections for the profit contributions of the two scooter models. The department now estimates that the profit contribution for each unit of Razor model will be $135 and the profit contribution for each unit of Navajo model will be $170. If these new profit contributions are used in the Excel optimization model, and the Solver is re-run to find the new optimal solution, what is the new optimal value of the objective function, in $?

This question relates to the Zooter Example discussed in Sessions 1 and 2, and tests your understanding of the algebraic model formulation. This question requires you to run an optimization using Solver. You can use the file Zooter.xlsx we developed in Session 2.

Zooter’s sales department has revised its projections for the profit contributions of the two scooter models. The department now estimates that the profit contribution for each unit of Razor model will be $135 and the profit contribution for each unit of Navajo model will be $170. If these new profit contributions are used in the Excel optimization model, and the Solver is re-run to find the new optimal solution, what is the new optimal value of the objective function, in $?