!! IMPORTANT !!

!! Must complete this problem in excel using the solver functon under the data tab !!

!! only solve it in exel !!

I have completed it but I did some of it wrong (highlighted in yellow) if you could please go off the picture I would appreciate it.

She wants it set up like the picture below

1. The Marrs Candy Company makes three different gummy products : Worms , Bears and Stars .

The ingredients for each candy bar are as follows :

Corn Syrup ( oz per candy) worms 12, bears 6, stars 10.

Gelatin (gm per candy) worms 4, bears 10, stars 2.

Juice Concentrate ( oz per candy ) worms 15, bears 8, stars 15.

The company's suppliers have limited the company to the following ingredients per week : Corn Syrup , 25,000 ounces ; Gelatin , 15,000 grams and Juice concentrate , 30,000 ounces .

The Marketing Department estimates that the maximum demand for the Worms will be 900 per week .

There appears to be no limit on the demand for Bears and Stars .

Per - unit profit contributions for each product are as follows : Worms , $ .02 Bears , $ .025 ; and Stars , $ .015 .

Write the linear programming formulation to help the company determine how many of each type of candy to produce next week in order to maximize profits .

Profit CS G 7 The Marrs Candy Company B Wthe number of Worms to be produce weekly Bthe number of Bears to be produce weekly 10 S-the number of Stars to be produce weekly. 11 12 Maximize Profit-0.02W+0.025B+0.0155 13 Subject to 14 CS: 12W+61.105 25.000 15 G: 4W+10B-29 15.000 J: 15W+883+155 30,000 W 900 B0 19 S0 PO Worms Bears Stars 0.02 0.025 0.015 12 6 10 4 10 Dr. AMD: 15 8 15 The constrant st"W 0, 1'>0 o O'R > or O'S >0. See who comment below O 0 w B 5 Dec Var 5 Solution: Make 1525.424 Worms, 35 ans, and Stars w 1525.424 8305 0 17 Objective result: Profit-$52.75 Max Profit 52.75424 52,75424 2 3 -4 Subject to C G 1 23644.07 15000 30000 16 1 > 25.000 15,000 30,000 900 Dr. AMD: 0 No need to nude non constant because you can check the box Solver window Note you did have them, there would need to be one for W as we > Band you cannot at type in for the left hand side. The left hand side of these constants must port to the Decision was just healther constants B 9 0