Question 4 · Mankiw, Taylor & Ashwin, Business Economics, ch. 4

Chocolate Bar Market

Demand Qd = 1600 − 300P and supply Qs = −1400 + 700P. Drag the sliders to shift or rotate each curve and watch the equilibrium move. Hover the chart to read off quantities and the shortage or surplus at any price.

Equilibrium price P*
£3.00
1000P = 3000
Equilibrium quantity Q*
700
chocolate bars
Demand choke price
£5.33
price at which Qd = 0
Supply entry price
£2.00
price at which Qs = 0

Equilibrium price & quantity for chocolate bars

Quantity demanded Quantity supplied Equilibrium guides

Textbook convention: Price on the vertical axis, Quantity on the horizontal — part (c) of the question. Toggle above to see how Excel first draws it.

Part (a) working — solve Qd = Qs

Part (b) — the Excel schedule

Hypothetical prices £0–£5 with quantities computed from the functions, exactly as the spreadsheet formulas =$F$2+($G$2*A2) and =$F$3+($G$3*A2) produce them. The final column reads the market: excess demand below P*, excess supply above it.

Price (£)Quantity demandedQuantity suppliedQs − QdMarket state

← Back to module

Built by Dr Kasra Kassai, LSBU Business School · drkassai.com