Using Microsoft Excel with the Solver application, determine the optimal levels of the seven products that minimizes cost. Open the worksheet in Excel, create formulas as necessary, and use the Solver to determine the optimal levels for each product. The quantity of products must be in whole numbers $($integers$).$

$1.$ This problem was contributed by Dr$.$ Rick Wilson of Oklahoma State University.

$$ The recent drought has hit farmers hard. Cows are eating candy corn! You are interested in creating a feed plan for the next week for your cattle using the following seven nontraditional feeding products: Chocolate Lucky Charms cereal, Butterfinger bars, Milk Duds, vanilla ice cream, Cap$$n Crunch cereal, candy corn $($because the real corn is all dead$),$ and Chips Ahoy cookies.

The table has $5$ rows and $8$ columns. The column headings are as follows. Blank, Choc Lucky Charms, Butterfinger, Milk Duds, vanilla ice$-$cream, Cap'n Crunch, Candy Corn, and Chips Ahoy. The row values are as follows. Row $1.$ Dollars per pound, $2\mathrm{.}15,7,4\mathrm{.}25,6\mathrm{.}35,5\mathrm{.}25,4,6\mathrm{.}75.$ Row $2.$ Choc, YES, YES, YES, NO$,$ NO$,$ NO$,$ YES. Row $3.$ Protein, $75,80,45,65,72,26,62.$ Row $4.$ T D N$,12,20,18,6,11,8,12.$ Row $5.$ Calcium, $3,4,4\mathrm{.}5,12,2,1,5.$

$$ Their per pound cost is shown, as is the protein units per pound they contribute, the total digestible nutrients $($TDN$)$ they contribute per pound, and the calcium units per pound.

$$ You estimate that the total amount of nontraditional feeding products contributes the following amount of nutrients: