Using Microsoft Excel with the Solver application, determine the optimal levels of the seven products.

 

Using Microsoft Excel with the Solver application, determine the optimal levels of the seven products.

Open the worksheet in Excel, create formulas as necessary, and use the Solver to determine the optimal levels for each product.