Chapter 6 work

profilerelic415
qct6_chapter_12_spreadsheet.xls

Sheet1

Salvator's chapter 12 spreadsheet problem (p.523)
TR Consumer's Surplus Total amount that consumer is willing to pay
Q 6 24 9 33
P 4
1st Degree TR Consumer's Surplus
2 Prices TR Consumer's Surplus
P1 5.5
P2 4
The Data
Q P
14 0
12 1
10 2
8 3
6 4
4 5
2 6
0 7

Sheet1

The Demand Curve

Sheet2

Sheet3