Docstoc

Supply and Demand Graph in Excel - Excel

Document Sample
Supply and Demand Graph in Excel - Excel Powered By Docstoc
					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
Description: Supply and Demand Graph in Excel document sample