WHAT WILL BE THE CONSTRAINT FOR NUMBER 5?

Do we need to put in the values as I have put in the Total to make row before hand?

1 x fx B C C D E H 1 L M N 0 P Q f 1 2 3 3 4. 5 Ingredients Chocolate Nougat Nuts Caramel Milky Way 1 1 Candy Bars Snickers Nut Roll 1 0 1 1 1 1 1 1 3 Musketeers 1 1 0 0 Cost $0.15 $0.15 $0.20 $0.15 0 1 You are in charge of manufacturing for a candy bar plant. Your facility manufactures four types of candy bars (Milky Ways, Snickers, Nut Rolls, and 3 Musketeers). You must maximize the profit for your facility by making the right number of each type of candy bar. There are four main ingredients used in the candy bars. Chocolate, nougat, nuts, and caramel. You have created a spreadsheet model on the "Candy" worksheet to help you in your decision-making. The table at the top of the "Candy worksheet details how many units of each ingredient are used in making each type of candy bar and the costs for these ingredients. The demand and prices You can charge for each type of candy bar are also listed in the spreadsheet model. Finally, the model calculates the ingredient used and total prafit for the candy bars you plan to make. Use solver to complete the assignment tasks Demand Total to Make 2,000,000 2,000,000 2,500,000 1,000,000 1,500,000 1,000,000 1,500,000 1,500,000 Price/Bar Cost/Bar Gross Profit/Bar $0.90 $0.45 $0.45 $0.90 $0.65 $0.25 $1.05 $0.50 $0.55 $0.90 $0.30 $0.60 Gross Profit/Type $900,000 $375,000 $550,000 $900,000 Total Gross Profit $2,725,000 6 7 8 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Assignment Tasks Candy Bar Solver Set up solver to determine how many of each type of candy bar to make to maximize total profit subject to the following constraints: 1 - The number of candy bars made should not exceed the demand for that type of candy bar. 2 - You must make at least 1 million of each type of candy bar. 3 - The ingredients consumed in making the candy bars should not exceed what is available. 4 - There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts 5 - Make only whole number amounts of candy bars. [82 points) 1 Material Totals Ingredients Used Chocolate 5,000,000 Nougat 6,000,000 Nuts Caramel 4,500,000 Available 6,000,000 7,000,000 2,500,000 5,500,000 2,500,000 Add Constraint Cell Reference: Constraint: int integer Add Cancel OK