Question: I have to formulate the LP model. Can someone do this on word instead of excel? Anna Creek is the world largest farm. They send

I have to formulate the LP model. Can someone do this on word instead of excel?

I have to formulate the LP model. Can someone do

Anna Creek is the world largest farm. They send cattle to a feedlot to be grain-fed before being processed into beef. Anna Creek seeks to determine the amounts of cattle feed to buy so that minimum nutritional standards are satisfied to ensure proper weight gain, while total feed costs are minimized. The feed mix used is made up of three grains that contain the following nutrients per pound of feed: Feed Feed Mix X Feed Mix Y Feed Mix Z NUTRIENT (Ounces per Pound of feed) A 3 2 4 B 2 3 1 1 0 2 D 1.0 6 8 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!