Cattle are sent to a feedlot to be grain-fed before being processed into beef. The owners of
Question:
Feed mixes X, Y, and Z cost $3, $4, and $2.25 per pound, respectively. The minimum requirement per cattle per day is 4 pounds of nutrient A, 5 pounds of nutrient B, 1 pound of nutrient C, and 8 pounds of nutrient D. The ranch faces one additional restriction: it can only obtain 500 pounds of feed mix Z per day from the feed supplier regardless of its need. Because there are usually 100 cattle at the feed lot 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 cattle per day. Formulate this problem as a linear program and solve it by using Excel.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Managerial Decision Modeling With Spreadsheets
ISBN: 9780136115830
3rd Edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Question Posted: