Demand and Supply 73
CASE STUDY FOR CHAPTER 3
Spreadsheet Analysis of Demand and Supply for Sunbest Orange Juice
Spreadsheet analysis is an appropriate means for studying the demand and supply effects of possible
changes in various exogenous and endogenous variables. Endogenous variables include all
important demand and supply-related factors that are within the control of the firm. Examples
include product pricing, advertising, product design, and so on. Exogenous variables consist of all
significant demand and supply-related influences that are beyond the control of the firm. Examples
include competitor pricing, competitor advertising, weather, general economic conditions, and
related factors.
In comparative statics analysis, the marginal influence on demand and supply of a change in
any one factor can be isolated and studied in depth. The advantage of this approach is that causal
relationships can be identified and responded to, if appropriate. The disadvantage of this marginal
approach is that it becomes rather tedious to investigate the marginal effects of a wide range of
demand and supply influences. It is here that spreadsheet analysis of demand and supply conditions
becomes useful. Using spreadsheet analysis, it is possible to learn the demand and supply
implications of an almost limitless range of operating scenarios. Rather than calculating the effects
of only a few possibilities, it is feasible to consider even rather unlikely outcomes. A complete
picture can be drawn of the firm’s operating environment, and strategies for responding to a host of
operating conditions can be drawn up.
where P is the average wholesale price of Sunbest ($ per case), PS is the average wholesale price of
canned soda ($ per case), Y is disposable income per household ($), T is the average daily high
temperature (degrees), PL is the average price of unskilled labor ($ per hour), and PK is the risk-
adjusted cost of capital (in percent).
During the coming planning period, a wide variety of operating conditions are possible. To gauge
the sensitivity of demand and supply to changes in these operating conditions, a number of scenarios
that employ a range from optimistic to relatively pessimistic assumptions have been drawn up in
Table 3.4.