1. Formulate the stated problems as a linear model (clearly state decision variables, objective function, and constraints). ATTACH YOUR FORMULATIONS!!!!!!!!!!!!!

2. Find the optimal solution using Solver as shown in class PowerPoint slides.

3. Answer questions using your sensitivity report.

4. Attach your Excel solver files.

Question 2.

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 supplements available for the mix. The company has the following requirements 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, $1.20, a pound of soybeans, $0.60, and a pound of vitamin supplement, $2.00. The feed company wants to know the number of pounds of each ingredient to put in the mix to minimize cost.

a. Formulate a linear programming model for this problem.

b. Solve the model by using the computer.