hard20 pts · first answer countsexcelwhat-if-analysis

Production mix with limits

A factory wants to choose quantities of three products to maximise profit, with limits on machine hours, raw material and minimum orders. Which Excel tool suits this?

A.Goal Seek, which changes inputs to hit a targetB.A Data Table with three input cells at onceC.Solver, which changes many inputs under constraintsD.Scenario Manager with the three product quantities saved

Discussion 0

Join free to post in the discussion.

Production mix with limits

Discussion 0

Related questions