Section B - Linear Programming Excel Solution Methods For problems 4 build the LP Model from the word problem, using Excel solution method. Submit all supporting work. 4. Fred Johnson manages a family-owned farm. To supplement several food products grown on the farm, Fred also raises pigs for market. He now wishes to determine the quantities of the available types of feed (corn, tankage, alfalfa) that should be given to each pig. The units of basic nutritional information contained within each kilogram of feed is given in the table below, along with daily requirements and feed cost. Nutritional Minimum Daily Corn Tankage Alfalfa Information Requirement Carbohydrates 90 20 40 200 Protein 30 80 60 180 Vitamins 10 20 60 150 Cost $2.10 $1.80 $1.50 a). Formulate a linear programming model for this problem statement. b). What is the optimum solution for the feed? c). Alfalfa becomes unavailable in the winter, what should the winter mixture be