Share
Explore BrainMass

Optimal Solution

Jake's Buy Products purchases two unprocessed corn (ConCorn and Stalkers) to produce various products. It has a customer order for 800 pounds of corn meal, 600 pounds of corn bran, and 500 pounds of corn feed. The amount of each product found in each 100 pound of the unprocessed corn and the cost per 100 pounds are given in the table below. (see attached)

Determine the amount of each ore that should be purchased if the objective is to:
1, minimize cost
2. minimize waste

In each case, describe the qualitative pattern of the optimal solution. Which constraints are binding and which decision variable is zero.

Attachments

Solution Preview

Refer to the excel worksheet for the optimal amount for each of the two objectives. If you are not familiar with linear programming with excel, refer to this tutorial here http://it.usu.edu/plugins/work/sitemaps/107/files/Linear_Programming_Using_Excel.pdf. I use the exact same setup as the tutorial so it should be very easy to ...

Solution Summary

Which constraints are binding and which decision variable is zero are determined. Optimal solutions are provided.

$2.19