Type or paste question here

-N3+ 2 4 567 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 A B Ingredients D E Candy Bars Milky Way Snickers Nut Roll 1 1 0 1 1 1 0 1 1 1 1 1 2,000,000 2,500,000 1,000,000 1 1 1 $0.90 $0.90 $1.05 $0.45 $0.65 $0.50 $0.45 $0.25 $0.55 $0 $0 $1 $2 Material Totals Used Available 3 6,000,000 4 7,000,000 2 2,500,000 3 5,500,000 Chocolate Nougat Nuts Caramel Demand Total to Make Price/Bar Cost/Bar Gross Profit/Bar Gross Profit/Type Total Gross Profit Ingredients Chocolate Nougat Nuts Caramel F Musketeers 1 1 0 1,500,000 1 $0.90 $0.30 $0.60 $1 Cost $0.15 $0.15 $0.20 $0.15 H (1.1) Set up solver to determine how many of each type of candy bar to make to maximize total profit subject to the following constraints: a. The number of candy bars made should not exceed the demand for that type of candy bar. b. You must make at least 1 million of each type of candy bar. Do not use commas when entering the number into the Solver constraint. c. The ingredients consumed in making the candy bars should not exceed what is available. d. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. e. Make only whole number amounts of candy bars. f. Before solving make the solving method "Simplex LP" and checkmark the "Make Unconstrained Variables Non-negative" option