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 profit for the candy bars you plan to make. Use solver to complete the assignment tasks.

Given the problem constraints which number 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,000,000$ more units of nuts for $$100,000($in addition to the variable cost of nuts already built into the model$),$ should you $($select your answer from the drop$-$down list in cell N$21)?$