Table of Contents:
Optimum Product Mix:
This type of calculation is done to model the costs/ benefits of different production mixes on overall profitability. It is often associated with cost accounting and with effective operations managment.
For more, please see our discusson on product mix decisions
Using MS Excel
- Linear programming using Excel is very good at helping you solve the optimum product mix (ie how much of each type of product should you make?).
- Try the add-on called "solver" from microsoft excel:
- For a tutorial, please see