Interactive model · linear programming
🏭 Product Mix Optimizer
How many computers of each kind should a plant build? Change the margins and the labour hours, and the optimiser re-solves instantly. Press Find the optimum to watch the profit line sweep across the feasible region until it touches the best corner.
Same formulation as the original Excel Solver models; the in-browser solver reproduces Solver's answers exactly ($199,600, $615,812.50 and $1,535,562.50).
Feasible region
Every point inside the shaded area is a plan the plant can actually make
Eight models, two test lines
Optimal number of each model to build, by test line
Six-month production plan
Produce early when it's cheap, store it, ship it later