Int. Micro.
Main

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.
 
Cost-Minimizing Combination of Inputs
This template covers the impact on the cost-minimizing 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 Short-Run Product Supply
Text... To learn more about the firm's short-run supply curve, work through these Chapter 8 problems.
 
Competitive Product Market
This template covers the impact on the price-taking 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 price-setting 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 wage-taking 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 wage-setting 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
  | Main | Economics Department | Illinois State | PreviousTopNext
Copyright © 1997-98: Mark S. Walbert All rights reserved. Last modified 21 December, 1997