Answered step by step
Verified Expert Solution
Question
1 Approved Answer
14. Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions: a. Is the
14. Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate? b. Is the solution unique? 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? d. Suppose the cost per pound for Feed 3 increased by $3. Would the optimal solu- tion change? Would the optimal objective function value change? e. If the company could reduce any of the nutrient requirements, which one should it choose and why? f. If the company could increase any of the nutrient requirements, which one should it choose and why? 2 B 103 st 16588 7 A B C D 9 0 1 2 13 4 15 16 17 18 LLI E F G H Beef-Up Ranch Nutrient (in ounces) per pound of feed Req'd Req'd Max Nutrient Feed 1 Feed 2 Feed 3 Available Pounds Ounces Ounces A 3 2 4 4 64 128 B 3 1 3 5 80 160 C 1 0 2 1 16 32 D 6 8 4 8 128 256 Cost per lb Pounds per cow per mo $2.00 $2.50 $3.00 Max Available 15 15 15 1234 A B C D E F G H Beef-Up Ranch Nutrient (in ounces) per pound of feed Req'd Req'd Max 56989 Nutrient Feed 1 Feed 2 Feed 3 Available Pounds Ounces Ounces A 3. 2 4 4 64 7 B 3 1 3 5 80 C 1 0 2 1 16 D 6 8 4 8 322 128 160 32 128 256 Cost per lb #NAME? #NAME? #NAME? 10 11 Pounds per cow per mo 12 Max Available 15 15 15 13 14 Base Case Cost per lb $2.00 $2.50 $3.00 15 16
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