1. Using the Sensitivity Report in Excel\'s Solver: would the optimal solution t
ID: 429552 • Letter: 1
Question
1. Using the Sensitivity Report in Excel's Solver: would the optimal solution to this problem change if the profits for each case of root beer was $3 instead of $6? Why, why not?
2. Using the Sensitivity Report in Excel's Solver: Over which range of values for the profit of root beer per case would the optimal solution NOT change? What is this range called?
3. Using the Sensitivity Report in Excel's Solver: would the optimal solution to this problem change if the profit of orange soda per case was $5 instead of $4? Why, why not?
4. Using the Sensitivity Report in Excel's Solver: How much more profit would you be able to generate (if any) for each additional hour of daily production time? Explain.
5. Using the Sensitivity Report in Excel's Solver: Interpret the "shadow price" for the amount of available carbonated water. What does it mean? Over which range is this shadow price valid?
Upload a screenshot of the Sensitivity Report for this problem and the spreadsheet. **if you could email this to minahmanning24@gmail.com I would be so thankful and grateful!
Explanation / Answer
1. yes, the profits can becomes as $6 per case
2. this range is called normal range
3. yse, it will be change
4. the profit will be $6*1500= $9000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.