Quo. 4 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: NUTRIENT (Ounces per Pound of feed) Feed A B C D Feed Mix X 3 2 1 6 Feed Mix Y 2 3 8 Feed Mix Z 4 1 2 4 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.

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question

Help me fast so that I will give Upvote.

Quo. 4 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:
NUTRIENT (Ounces per Pound of feed)
Feed
A
B
C
D
Feed Mix X
3
2
1
6
Feed Mix Y
2
3
8
Feed Mix Z
4
1
2
4
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.
Transcribed Image Text:Quo. 4 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: NUTRIENT (Ounces per Pound of feed) Feed A B C D Feed Mix X 3 2 1 6 Feed Mix Y 2 3 8 Feed Mix Z 4 1 2 4 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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 8 images

Blurred answer
Knowledge Booster
Indefinite Integral
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, advanced-math and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,