et up solver to determine how many of each type of candy bar to make to maximize total profit subject to the following constraints:

The number of candy bars made should not exceed the demand for that type of candy bar.

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.

The ingredients consumed in making the candy bars should not exceed what is available.

There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts.

Make only whole number amounts of candy bars.

Before solving make the solving method "Simplex LP$"$ and checkmark the "Make Unconstrained Variables Non$-$negative" option.

Reference the profit calculation in cell F$12.$

Notice the Supplier Contract and Profitability chart updates with the values in the data table to visually demonstrate the relationship between supplier contract amounts and the profitability.