Q: Which of the following can be set as the objective of a linear programming optimization model using Excel’s Solver function (check all that apply)?

or

Q: Using Excel’s Solver tool, which of the following can be the goal of an optimization model for linear programming? Make sure to tick all that apply.

**Min****A specific target value**- Average
**Max**- Random variables

**Explanation:** Solver can minimize an objective, such as minimizing costs or resource use. Solver can maximize an objective, like profit or production output.A specific target value: Solver can be set to achieve an exact value, such as targeting a specific profit or production level.