Question: In this problem you are to determine the cheapest combination of three grains (corn, wheat, and alfalfa) to feed cows. This mix of grains must meet certain nutritional requirements. The table below shows, for each of the three grains, the number of units of each nutritional ingredient contained in a kilogram of grain. It also gives the minimum daily requirement for a cow for each ingredient, as well as the cost per kilogram of each grain. You are to determine the mix of these three grains that satisfies the nutritional requirements at minimum total cost.

1. Formulate a linear programming model to determine the number of kilograms of each grain to feed a cow so that the mix provides the minimum daily requirements, at minimum total cost. Write the algebraic formulation in your excel file on the worksheet for this problem . Below that show the excel spreadsheet setup to solve this problem.
2. Use your excel setup of the problem to check whether this solution is feasible: 1 kilogram of corn, 2 kilograms of wheat, and 2 kilograms of alfalfa. Is it feasible? How many units of each nutritional ingredient would this solution provide? What would it cost?
3. Use solver to find the optimal solution. How much of each grain is needed? How many units of each nutritional ingredient would your solution provide? What would it cost?

Price: $2.99

Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document