Question: Please show how to enter formulas on excel The recent drought has hit farmers hard. Cows are eating candy corn! You are interested in creating

Please show how to enter formulas on excel

Please show how to enter formulas on excel The

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 non-traditional feeding products. Chocolate Lucky Charms cereal, Butterfinger bars, Milk Duds, vanilla ice cream, Cap'n Crunch cereal, candy corn, and Chips Ahoy cookies. Chapter 6 Prescriptive Analytics: Optimization and Simulation Choc Lucky Charms 2.15 Vanilla Ice Cream Milk Duds Candy Corn Butterfinger 7 Cap'n Crunch 5.25 Chips Ahoy 6.75 $$/b 4.25 6.35 4 Choc YES YES YES NO NO NO YES Protein 75 80 45 65 72 26 62 TON 12 20 18 6 11 8 12 Calcium 3 4 45 12 2. 1 5 Their per pound cost is shown, as is the protein units per pound they contribute, their total digestible nutrients (TDN) they contribute per pound, and the calcium units per pound. You estimate that the total amount of nontraditional feeding products contribute the following amount of nutrients: at least 20,000 units of protein, at least 4,025 units of TDN, at least 1,000 but not more than 1,200 units of calcium. There are some other miscellaneous requirements as well. The chocolate in your overall feed plan (in pounds) cannot exceed the amount of nonchocolate poundage. Whether a product is considered chocolate or not is shown in the table (YES = chocolate, NO = not chocolate). No one feeding product can make up more than 25% of the total pounds needed to create an acceptable feed mix. There are two cereals (Chocolate Lucky Charms and Capn Crunch). Combined, they can be no more than 40% (in pounds) of the total mix required to meet the requirements. Determine the optimal levels of the seven products to create your weekly feed plan that minimizes cost. Note that all amounts of products must not have fractional values (whole numbered pounds only)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!