Activity 6
AGB 435
Dr. Sean Hurley
50 Points
Due: 5/9/12
Introduction:
Today’s activity will have you examine the Save-it and Revised Super Grain spreadsheets to familiarize you with the most common type of spreadsheet models, the mixed spreadsheet model.
Answer the following questions based on chapter 5’s spreadsheet of Wyndor.
- Based on the sensitivity report that has already been run, what is the range of prices for doors that will give you the same optimal decision based on the price of windows staying constant? Please explain how you found this.
- Based on the sensitivity report that has already been run, what is the range of prices for windows that will give you the same optimal decision based on the price of doors staying constant? Please explain how you found this.
- What is the range for Plant 1 of the right hand constraint that will give you the same optimal answer? Please explain how you found this.
- What is the range for Plant 2 of the right hand constraint that will give you the same optimal answer? Please explain how you found this.
- Please explain in layman terms what the shadow price on Plant 1 means.
- Please explain in layman terms what the shadow price on Plant 2 means.
- If you change the price of doors from $300 to $500 and resolve for the optimal, do you get the same Sensitivity Report that you originally have? Please explain.
Answer the following questions based on chapter 5’s spreadsheet of Profit & Gambit.
- Based on the sensitivity report that has already been run, what is the range of advertising costs for television that will give you the same optimal decision based on the advertising cost of print media staying constant? Please explain how you found this.
- Based on the sensitivity report that has already been run, what is the range of the advertising cost of print media that will give you the same optimal decision based on the advertising costs for television staying constant? Please explain how you found this.
- What is the range for the liquid detergent minimum increase of the right hand constraint that will give you the same optimal answer? Please explain how you found this.
- What is the range for the stain remover minimum increase of the right hand constraint that will give you the same optimal answer? Please explain how you found this.
- Please explain in layman terms what the shadow price on Stain Remover Sales means.
- Please explain in layman terms what the shadow price on Powder Detergent Sales means.
Answer the following questions based on chapter 3’s spreadsheet of Super Grain.
- Please run a sensitivity report on Super Grains spreadsheet model and explain what is telling you. You should discuss the following items:
- The range of the objective coefficients before the optimal answer would change.
- The range of the right hand side of the constraints before the optimal answer would change.
- The meaning of the shadow prices.
Last Revised: 5/7/12
Page 1 of 2