Chapter 29. Using Solver to determine the optimal product mix

Questions answered in this chapter:

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

  • Does a Solver model always have a solution?

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

Answers to this chapter’s questions

This section provides the answers to the questions that are listed at the beginning of the chapter.

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

Companies often need to determine the quantity of each product to produce on a monthly basis. In its simplest form, the product mix problem involves how to determine the amount of each product that should be produced during a month to maximize profits. ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.