1. Statistics
2. 192064

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

The Feed 'n Ship Ranch Fattens cattle for local farmers and ships them to meat markets in Kansas City and Omaha. The owners of the ranch seek to determine the amounts of cattle feed to buy so that minimum nutritional standards are satisfied, and at the same time total feed costs are minimized. The feed mix used can be made up of the three grains that contain the following ingredients per pound of feed: (20 points)

Feed (oz)
Ingredient Stock X Stock Y Stock Z
A 3 2 4
B 2 3 1
C 1 0 2
D 6 8 4

The cost per pound of stocks X, Y, and Z are $2, $4, and $2.5, respectively. The minimum requirement per cow per month is 4 pounds of ingredient A, 5 pounds of ingredient B, 1 pound of ingredient C, and 8 pounds of ingredient D.

The ranch faces on additional restriction: it can only obtain 500 pounds of stock Z per month from the feed supplier regardless of its need. Because there are usually 100 cows at the Feed 'n Ship Ranch at any given time, this means that no more than 5 pounds of stock Z can be counted on for use in the feed of each cow per month.

a. Identify the objective function and all constraints.
b. Solve using Excel.
c. Based on the Answer Report from Excel, what is the optimal feed mix and cost?