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 |