Question: Assignment #2 Atlantic Farm Feeds makes a feed mix from four ingredients - oats, corn, soybeans and a vitamin supplement. The company has a stock

Assignment #2 Atlantic Farm Feeds makes a feed

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

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!