# Supply and Demand Graph in Excel - Excel

Document Sample

```					PS 03B: Shifts and Movements Along Curves
80
Demand P
Demand P =    40       -1 Q        70
Supply P
60

Supply P =   10   +   1   Q       50

40

P
30

20

10

0
0   5          10   15   20   25   30   35   40
Q
Data for the Demand and Supply Graph

Q Values Demand P Supply P
0      40        10
2      38        12
4      36        14
6      34        16
8      32        18
10      30        20
12      28        22
14      26        24
16      24        26
18      22        28
20      20        30
22      18        32
24      16        34
26      14        36
28      12        38
30      10        40
32       8        42
34       6        44
36       4        46
38       2        48
40       0        50
PS 03B: Shifts and Movements Along Curves
80
Consumer 1

Demand P =    40       -2 Q        70                          Supply P
Consumer 2
60

50
Demand P2 =    30       -2 Q
40

P
30

Supply P =   1    +   1   Q       20

10

0
0   5   10   15   Q
20     25         30   35   40
Data for the Second Demand and Supply Graph

Q Values Consumer 1 Supply P Consumer 2
0        40         1        30
2        36         3        26
4        32         5        22
6        28         7        18
8        24         9        14
10        20        11        10
12        16        13         6
14        12        15         2
16         8        17        -2
18         4        19        -6
20         0        21       -10
22        -4        23       -14
24        -8        25       -18
26       -12        27       -22
28       -16        29       -26
30       -20        31       -30
32       -24        33       -34
34       -28        35       -38
36       -32        37       -42
38       -36        39       -46
40       -40        41       -50

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 57 posted: 8/18/2011 language: English pages: 4
Description: Supply and Demand Graph in Excel document sample