Assignment #2 Atlantic Farm Feeds makes a feed mix from four ingredients - oats, corn, soybeans and a vitamin supplement. The company has a stock of 300 kilos of oats, 400 kilos of corn, 200 kilos of soybeans and 150 kilos of vitamins. The company also has the following requirements for the mix: i) ii) iii) iv) At least 30% of the mix must be soybeans At least 20% of the mix must be vitamin supplement The ratio of corn to oats cannot be less than 2:1 The amount of oats cannot exceed the amount of soybeans The total weight of the mixture must be at least 500 kilos. A kilo of oats costs $0.50, a kilo of corn $1.20, soybeans, $0.60, vitamin supplement $2.00. The feed company wants to know the now much of each ingredient to put in the mix to minimize total cost/. a) Formulate a model for this problem b) Solve using Excel 1 13