Excel Templates and Problems
Instructions for downloading
and running the Excel templates
 Reservation Prices
 Text... To learn more about how reservation prices influence the shape
of supply and demand curves, and the size of consumer and producer surpluses,
work through these problems.

 Supply and Demand
 This template covers shifts in demand or supply; changes in equilibrium
price and quantity; imposition of price floors or ceilings; and changes
in the relative price elasticity of demand or supply. To learn how to manipulate
this model, work through these Chapter 2 problems.

 Consumer Choice Model
 This template covers changes in the prices of the two goods, the consumer's
income, and the parameters describing the consumer's utility function.
Excel's Solver is used to find the optimum combination of the two goods.
To learn how to manipulate this model, work through these Chapter 3 problems, and these
Chapter 4 problems.

 Consumer Demand
 In this template, the consumer choice model is used to derive the consumer's
demand curve for a good. Product price and consumer income can be changed
and the new demand curve replotted. To learn how to use the consumer choice
model to generate a consumer's demand curve, work through these Chapter
4 problems.

 CostMinimizing Combination of Inputs
 This template covers the impact on the costminimizing combination
of two inputs of changes in the firm's production function and factor prices.
To learn how to manipulate this model, work through these Chapter 7 problems.

 The Firm's ShortRun Product Supply
 Text... To learn more about the firm's shortrun supply curve, work
through these Chapter 8 problems.

 Competitive Product Market
 This template covers the impact on the pricetaking firm and market
of changes in market demand; the number of sellers; and the cost of fixed
and variable inputs. To learn how to manipulate this model, work through
these Chapter 8 problems.

 Monopoly
 This template covers the impact on a pricesetting firm of changes
in product demand; the number of sellers (including the resulting change
to the realative price elasticity of demand); and the cost of fixed and
variable inputs. To learn how to manipulate this model, work through these
Chapter 10 problems.

 Labor/Leisure Choice
 text...

 Competitive Labor Market
 This template covers the impact on the wagetaking firm and market
of changes in product demand; worker productivity; and the number of product
sellers. To learn how to manipulate this model, work through these Chapter
14 problems.

 Monopsony
 Using this model, we will explore how the market for labor changes
when a firm has wagesetting power. To learn how to manipulate this model,
work through these Chapter 10 problems

 General Equilibrium Model .
 This template allows you to explore the interactions between the perfectly
competitive product market and the perfectly competitive labor market.
It is designed to let you explore how, in a market system, everything is
connected to everything else. To learn how to manipulate this model, work
through these problems
