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.

Given the problem constraints, which Gross Profit amount in the drop$-$down list in cell N$14$ is closest to the maximum profit possible for this problem?

Production would fall short of demand for which of the candy bars $($select your answer from the drop$-$down list in cell $18)?$

If you could buy $1$ million more units of nuts for $$100,000($in addition to the variable cost of nuts already built into the model$),$ should you $($after you reconfigure the model and rerun solver, select your answer from the drop$-$down list in cell N$21)?$