Sunbest Orange Juice Supply demand spreadsheet analysis
Complete the following operations in Microsoft Excel to
complete the supply/demand analysis for Sunbest Orange Juice. The spreadsheet
has been set up and the first half of each section has been completed.
A.Set up a spreadsheet to illustrate the effects of changing
economic assumptions on the demand for Sunbest orange juice. Use the demand
function to calculate demand based on three different underlying assumptions
concerning changes in the operating environment. First, assume that all demand factors change in unison from levels
indicated in the Optimistic Scenario #1 to the levels indicated in Pessimistic
Second, fix all demand factors except the price of Sunbest
at Scenario #6 levels, and then calculate the quantity demanded at each
scenario price level. Finally, fix all demand factors except temperature at
Scenario #6 levels, and then calculate demand at each scenario temperature
level.
B.Set up a spreadsheet to illustrate the effects of changing
economic assumptions on the supply of Sunbest orange juice. Use the supply
function to calculate supply based on three different underlying assumptions
concerning changes in the operating environment. First, assume that all supply factors change in unison from levels
indicated in the Optimistic Scenario #1 to the levels indicated in Pessimistic
Second, fix all supply factors except the price of Sunbest
at Scenario #6 levels, and then calculate the quantity supplied at each
scenario price level. Finally, fix all supply factors except temperature at
Scenario #6 levels, and then calculate supply at each scenario temperature
level.
C.
Set up a spreadsheet to illustrate the effect of changing
economic assumptions on the surplus or shortage of Sunbest orange juice that
results from each scenario detailed in part A and part B. Which operating
scenario results in market equilibrium?
0 comments:
Post a Comment