Chapter 30 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 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 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. Product mix must usually adhere to the following constraints:
Product mix can’t use more ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition 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.
