Chapter 25. Using Solver to Determine the Optimal Product Mix
How can I determine the monthly product mix for our plant that maximizes corporate 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?
How can I determine the monthly product mix for our plant that maximizes corporate profitability?
Companies often need to determine the monthly (or weekly) production schedule that gives the quantity of each product that must be produced. In its simplest incarnation, 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 often satisfy the following constraints:
Product mix ...
Get Microsoft® Excel 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.
