What is the total cost (in dollars) at this optimal number of warehouses?

How

many units should the business produce for the “Creamy” category?

In

setting up your Excel Solver to solve this problem, which cell(s) would you

need to put “Constraints” on?

In setting up your Excel Solver to solve this problem, which cell(s) would

you put as the “Changing Variable Cells”?

How

many units should the business produce for the “Crunchy” category?

In setting up your Excel Solver to

solve this problem, which cell is the Objective cell?