Chapter 30. Using Solver to determine the optimal product mix

Questions answered in this chapter:

Image How can I determine the monthly product mix that maximizes profitability?

Image Does a Solver model always have a solution?

Image What does it mean if a Solver model yields the result Set Values Do Not Converge?

Answers to this chapter’s questions

How can I determine the monthly product mix that maximizes profitability?

Companies often need to determine the quantity ...

Get Microsoft Excel 2016 Data Analysis and Business Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.