Solve using solver on Excel and show the formula used

$\backslash$table$[[$Candy Bars$],[$Ingredients$,$Milky Way,Snickers,Nut Roll,$3$ Musketeers,Cost$],[$Chocolate$,1,1,0,1,$$$0\mathrm{.}15],[$Nougat$,1,1,1,1,$$$0\mathrm{.}15],[$Nuts$,0,1,1,0,$$$0\mathrm{.}20],[$Caramel$,1,1,1,0,$$$0\mathrm{.}15],[0,0,0,0,,],[$Demand$,2,000,000,2,500,000,1,000,000,1,500,000,],[$Total to Make,$0,0,0,0,],[$Price$/$Bar$,$$$0\mathrm{.}90,$$$0\mathrm{.}90,$$$1\mathrm{.}05,$$$0\mathrm{.}90,],[$Cost$/$Bar$,$$$0\mathrm{.}45,$$$0\mathrm{.}65,$$$0\mathrm{.}50,$$$0\mathrm{.}30,],[$Gross Profit$/$Bar$,$$$0\mathrm{.}45,$$$0\mathrm{.}25,$$$0\mathrm{.}55,$$$0\mathrm{.}60,],[$Gross Profit$/$Type$,$$$0,$$$0,$$$0,$$$0,],[$Total Gross Profit,$$0,,,,],[$Mater$,$ial Totals,,,,$],[$Ingredients$,$Used,Available,,,$],[$Chocolate$,0,6,000,000,,,],[$Nougat$,0,7,000,000,,,],[$Nuts$,0,2,500,000,,,],[$Caramel$,0,5,500,000,,,]]$

MyEducator Tasks

$2\mathrm{.}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

USD$/$CNY

$-0\mathrm{.}31\%$

Search

$3$:$44$ PM

$10/27/2024$