Instruction: Explain how you would use Excel’s Solver add-in to optimize a supply chain model for minimizing cost while meeting production demands.
Context: This question tests the candidate’s proficiency in using Excel’s Solver add-in for solving complex optimization problems. The response should cover the steps to define decision variables, constraints, and the objective function, and how to interpret the Solver’s output to make informed decisions.