How to mix raw materials to get a certain chemical composition at the lowest cost? How much ice cream to produce as a function of the weather forecast and day of the week?
What buttons to press (how hard) to maximize profit?
This page shows how to control Excel's Solver using VBA macros, and you can download a sample VBA application, that uses Solver.Įxcel's Solver is a strong tool to calculate and/or optimize complex models.
