For Professor Ryan

profilebatsch
1_copy_of_qct6_chapter_12_spreadsheet-1.xlsx

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

The Demand Curve

P 14 12 10 8 6 4 2 0 0 1 2 3 4 5 6 7

Sheet2

Sheet3