# Intermediate Microeconomics with Excel

### Videos

During the Spring 2012 semester, I arranged to have my class lectures taped. I did not edit the video (beyond removing the beginning of class when I pass out handouts and collect homework). I certainly did not use high end equipment nor try to storyboard or follow a script. Thus, the results are quite raw -- it's a historical record of what I taught at that time. As unpolished as they are, these videos may help students understand the material and instructors to see how to use the files in class so I am making them available. They also enable the possibility of "inverting the classroom," which I may try one day. Simply click on a link to go to vimeo.com and view a lecture (all are under an hour).

Not all chapters in the book are covered. If you only have time for one video, see IntroSupplyDemand -- it's my favorite! (Curiously, it does not use Excel . . . )

Section Topic Description
Introduction Introduction Class intro; show an optimization problem
Theory of Consumer Behavior BudgetConstraint m = p1x1 + p2x2
Preferences Revealed preference
Utility U=f(x1,x2)
IntroducingOptimalChoice Max U s.t. budget constraint with calculus and Solver
OptimalChoicePractice Quasilinear U and perfect complements
FoodStamps Application to food stamps
EngelCurves x1* = f(m)
DemandCurves x1* = f(p1)
DemandCurvesPractice Demand with quasilinear U and perfect complements
GiffenGoods U functions that yield Giffenness
IncSubEffects Income and substitution effects
IncSubEffectsPractice Inc/sub with quasilinear U (no income effect)
EndowmentModelIntro w1x1 + w2x2 = p1x1 + p2x2
IntertemporalChoice Borrowing/saving as optimal choice
CharitableGiving Application to charity
RiskandReturn Optimal portfolio theory
SafetyRegulation Peltzman's seat belt paper
Theory of the Firm ProductionFunction Y=f(L,k)
InputCostMin Isoquant/isocost
EnfieldArsenal Application to British rifle making
CostFunction Deriving cost from input cost min
CostCurves TC, TFC, TVC, MC, ATC, AVC
OutputProfitMaxPCSR Profit max for a PC firm in the SR
DerivingSupply q* = f(p)
DiffusionandTechnicalChange Shutdown rule application
InputProfitMax Max profit by choosing L and K
DemandforLabor Short versus long run labor demand
Consistency All three opt problems in one workbook
Monopoly Profit max for a monopoly
GameTheory Cournot-Nash
Market System IntroSupplyDemand Markets as an allocation mechanism
TaxesDWL Tax incidence and DWL
MonopolyDWL Monopoly and DWL
SugarQuota Application to US TRQ on sugar
IntroEdgeworthBox Introducing the Edgeworth Box
EquilibriumEdgeworthBox Equilibrium in the Edgeworth Box
ParetoOptimality First Fundamental Theorem of Welfare Economics

Screencasts (short snippets of a few minutes that I will try to create more of as time permits):

Section Topic Description

Theory of Consumer Behavior

Theory of the Firm
MarketSystem SolvertoFindGE Using Solver in an Edgeworth Box to find equilibrium