Linear Programming using MS Solver

Question

enter image description here

I would like to solve the above question using MS Excel Solver.

Given that x1, x2, x3, x4, x5 represent the weight (in pounds) of Dried Cranberries, Oats, Dark Chocolate, Cashews, and Walnuts, respectively, in the two-pound package.

I have created the constraints and objective statement below.

enter image description here

May I know if the above constraints are correct? What should I put in the Solver pop up?

Answer 1

The LP formulation seems basically correct except that the total weight of the ingredients should be set to 2 (pounds). So add a constraint X1+X2+X3+X4+X5 =2