Docstoc

Shifts in Demand Curve - Excel - Excel

Document Sample
Shifts in Demand Curve - Excel - Excel Powered By Docstoc
					Demand Curve Shifts
Supply Constant

Increase in Income (and the good is
▼ ▼ ▼ Price

Consumers spend more of their higher incom

Demand curve shifts rightward.

↑
12 10 8

Price

6 4
2

0 0 20 40 60 80 100 120

Quantity

d Curve Shifts

ply Constant

e (and the good is normal)
▼ ▼ ▼ Quantity

of their higher income on the good.

urve shifts rightward.

↑
Demand Supply Shifted Demand

120

140

160

180

200

Follow the steps to enable your Shifts in Demand Curve template.
>> >> 1) Your Shifts in Demand Curve template is ready to use. Following steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your Shifts in Demand Curve template. 2) Visit the site below: http://trial.spreadsheetweb.com/spreadsheetweb/ Login to page with your new account information. 3) >> >> Click "Add Web Application" to upload this file. Your Shifts in Demand Curve template will be created automatically. You can simply use the Shifts in Demand Curve template from that link or place it on your website. Your Shifts in Demand Curve template will look like: http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=29325f1f-ee96-4306-9c8b-12de2e90eb56 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

This template is prepared for understanding the shifts in the demand curves, while everything except the selected event is held cons

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

e.

he selected event is held constant.

6-9c8b-12de2e90eb56

Arrows ↓ ↑ ─ Shift to R Shift Increment 40 Supply Constant Table No Event … 0 Increase in the Price of a Substitute Good Consumers buy less of the substitute good and40 more of this good. Increase in the Price of a Complementary Good buy less of the complementary good and less of this good. Consumers -40 Increase in Income (and the good is normal) Consumers spend more of their higher income40 the good. on Increase in Income (and the good is inferior) Consumers spend less of their higher income -40 the good. on Increase in the Taste for the Good Consumers are willing to buy a larger quantity of the good at every price. 40 Increase in Population Additional consumers result in a greater quantity demanded at every price 40 Increase in the Expected Price of the Good in the Future Consumers buy more of the good today to avoid the higher price in the fut 40 CHART DATA Price 1 2 3 4 5 6 7 8 9 10 First Intersection 95 Second Intersection 115 Shift Line 80 50 Arrow part 1 80 75 Arrow part 2 80 75 10 9.5 10 10.5 10 10 7 5

Demand 135 125 115 105 95 85 75 65 55 45

Shifted Supply 175 55 165 65 155 75 145 85 135 95 125 105 115 115 105 125 95 135 85 145

Increment first 45 10 10 10 10 10 10 10 10 10

second 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0