Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help with the excel part. All of the question is there. Use the Sensitivity report posted on Blackboard (similar/same problem from HW2), answer the
Need help with the excel part. All of the question is there.
Use the Sensitivity report posted on Blackboard (similar/same problem from HW2), answer the following questions: a. Is the solution degenerate? ( 10 points) b. Is the solution unique? (10 points) c. Explain the signs of the reduced costs for each of the decision variables. That is, considering the optimal value of each decision variable, why does the sign of its associated reduced cost make economic sense? ( 20 points) d. Suppose the cost per pound for Feed 3 increased by $3. Would the optimal solution change? Would the optimal objective function value change? (20 points) e. If the company could reduce any of the nutrient requirements, which one should it choose and why? (20 points) f. If the company could increase any of the nutrient requirements, which one should it choose and why? (20 points) Please type your answers in Word with justifications (calculations if necessary). You could also choose write down your work on a piece of paper and then take a picture of it. Nutrient (in ounces) per pound of feed 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: The cost per pound of feeds 1,2 , and 3 are $2,$3, and $4, 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started