I have this solution in excel, however, I would like to see it in QM.
I have purchased a similar solution, however I was looking for the formulation and solution in QM.
Linear programming #84515
Using Excel, please solve for the following:
The Southfork Feed Company makes a feed mix from four ingredients-oats, corn, soybeans, and a vitamin supplement. The company has 300 pounds of oats, 400 pounds of corn, 200 pounds of soybeans, and 100 pounds of vitamin supplement available for mix. The company has the following recipe for the mix:
At least 30% of the mix must be soybeans
At least 20% of the mix must be the vitamin supplement
The ratio of corn to oats cannot exceed 2 to 1
The amount of oats cannot exceed the amount of soybeans
The mix must be at least 500 pounds
A pound of oats costs $0.50, a pound of corn is $1.20; a pound of soybean is $0.60, and a pound of vitamin supplement is $2.00. The feed company wants to know the number of pounds of each ingredient to put in the mix in order to minimize costs.
Formulate a linear programming model for this program in QM,
A Complete, Neat and Step-by-step Solution is provided in the attached file.