Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help please with a , b , and c The Beef - Up Ranch feeds cattle for Midwestern farmers and delivers them to processing

need help please with a,b, and c
The Beef-Up Ranch feeds cattle for Midwestern farmers and delivers them to processing plants in Topeka, Kansas, and Tulsa, Oklahoma. The ranch must determine the amounts of cattle feed to buy so that various nutritional requirements are met while minimizing total feed costs. The mixture fed to the cows must contain three different levels of four key nutrients and can be made by blending three different feeds. The amount of each nutrient (in ounces) found in each pound of feed is summarized as follows:
\table[[Nutrient (in ounces),,per Pound of Feed,],[Nutrient,Feed 1,Feed 2,Feed 3],[A,3,2,4],[B,3,1,3],[C,1,0,2],[D,6,8,4]]
The cost per pound of feeds 1,2, and 3 are $2,$2.5, and $3.5, respectively. The minimum requirement per cow each pound is 4 pounds of nutrient A,5 pounds nutrient B,1 pound of nutrient C, and 8 pounds of nutrient D. However, cows should not be fed more than twice the minimum requirement for any nutrient each month. (Note that there are 16 ounces in a pound.) Additionally, the ranch can only obtain 1,500 pounds of each type of feed each month. Because there are usually 100 cows at the Beed-Up Ranch at any given type, this means that no more than 15 pounds of each type of feed can be used per cow each month.
a. Formulate a linear programming problem to determine how much of each type of feed a cow should be fed each month. (30 points)
b. Create a spreadsheet model for this problem and solve it using Solver. (50 points)
c. What is the optimal solution? (20 points)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Financial Management

Authors: Eugene F. Brigham, Phillip R. Daves

7th Edition

0030333288, 9780030333286

More Books

Students also viewed these Finance questions

Question

Why can pro-forma financial information be misleading?

Answered: 1 week ago

Question

Explain the various kinds of retirement plans.

Answered: 1 week ago

Question

Explain workplace flexibility (work-life balance).

Answered: 1 week ago

Question

Discuss global issues in employee benefits.

Answered: 1 week ago