File View Home Insert Formula Page Layout General Arial Narrow Test 1 -AA Chic 5 - % Merge Center BU- . Conditional Format Formatting as Table A Copy Paste Format Painter Chebang 027 Number E F B G H A Beet up Ranch 1 2 3 4 WN Nutrient (in ounces) per pound of feed Nutrient Feed 1 Feed 3 Feed 2 Available Req'd Pounds 5 Req'd Ounces 64 80 Max Ounces 128 3 2 4 7 3 1 5 ON 000 1 0 3 2 4 16 C D 160 32 256 1 8 6 3 128 $2.00 $2.50 $3.00 NH Cost perib Pounds per cow per mo Max Available 15 15 15 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Model Spider Plot Red Type here to search O . 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? & Suppose there is some uncertainty about the cost estimates for each type of feed. Prepare a Spider Plot varying the cost per pound of each feed type between plus and minus $0.25 of its stated value in S0.05 increments and tracking the impact on the optimal cost. What does this chart reveal, and what are the managerial implications