Fred Jonasson manages a family-owned farm. To supplement several food products grown on the farm, Fredalso raises cows for market. He now wishes to determine the quantities of the available types of feed (corn,tankage, and alfalfa) that should be given to each cow. Since cows will eat any mix of these feed types, the objective is to determine which mix will meet certain nutritional requirements at a minimum cost. The number of units of each type of basic nutritional ingredient contained within a kilogram of each feed type is given in the following table, along with the daily nutritional requirements and feed costs:

NutritionalIngredient Kilogram ofCorn Kilogram ofTankage Kilogram ofAlfalfa Minimum DailyRequirement

Carbohydrates 90 20 40 200

Protein 30 80 60 180

Vitamins 10 20 60 150

Cost ($) 0.84 0.72 0.60

Formulate a linear programming model for this problem in excel sheet with table using solver tool and solve it