Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed 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

blur-text-image

Get Instant Access with AI-Powered 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

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

Authors: Cliff Ragsdale

7th Edition

1285418689, 978-1285969701, 1285969707, 978-1285418681

More Books

Students also viewed these Accounting questions