Purchase Solution

Formulate a linear programming model for this program in QM

Not what you're looking for?

Ask Custom Question

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,

Thank you

Purchase this Solution

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

Purchase this Solution


Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Probability Quiz

Some questions on probability