Share
Explore BrainMass

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.
Already completed:
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 Scenario #10.

Not yet completed:
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.
Already completed:
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 Scenario #10.

Not yet completed:
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.
Not yet completed:
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?

Attachments

Solution Preview

How I completed the spreadsheet:

First, I changed the formula in cell F11. I added dollar signs in front of all the coordinates except the 11 in "B11". That meant that when I copied the formula in cell F11 into cells G6-G15, all the coordinates remained unchanged except the coordinates of the ...

Solution Summary

This solution shows how to use Microsoft Excel to complete a supply/demand analysis for Sunbest Orange Juice. Detailed instructions are given for how to set up the formulas in Excel to complete the calculations.

$2.19