In Anywhere, USA, the demand function of a gym membership is Qd= 600-50p+0.6Y. Where Qd Is quantity demand per month, p is the price of a membership, and Y is the average monthly income in the town. The supply function of gym memberships is Qs= 100+20p-20w, where Qs is the number of membership and w is the average hourly wage of trainers.

A. If Y=$5000 and w=$10, use Excel to calculate quantity demanded and quantity supplied for p= 5, 10, 15, 20, 25, 30, 35, 40. Determine excess shortages or surpluses. Use Excel to illustrate the supply and demand curves.

Quantity Demanded	Quantity Supplied	Price
		5
		10
		15
		20
		25
		30
		35
		40

B. Assume Y increase to $6875 and w increases to $15. Use Excel to recalculate quantity demanded and quantity supplied for p= 5, 10, 15, 20, 25, 30, 35, 40. Illustrate supply and demand curves. Explain the change in equilibrium.

Quantity Demanded	Quantity Supplied	Price
		5
		10
		15
		20
		25
		30
		35
		40

2. The price elasticity of demand is 0.8, calculate the percentage change in quantity demand if the price of cigarettes per pack rose from $5.50 to $6.50. Use the formula for Price Elasticity of Demand.

3. Calculate the price elasticity of demand given a 20% increase in price and 40% decrease in quantity demanded.

Would the good be considered as elastic, unitarily elastic, or inelastic in demand? Please explain.

Use the price elasticity of demand formula.

4. A local movie theater owner decided to increase his ticket prices from $8.50 to $10.00, as a result the quantity of ticket sold per week decreases from 1,000 tickets to 800 tickets. Calculate the price elasticity of demand using the point elasticity of demand formula. De consumers have an elastic, inelastic, or unitarily elastic demand for theater tickets? Please explain.

5. The marketing department of Acme, Inc. has estimated the following demand function for it Febreze Car Vent Clip Air Freshener, 1-count: Q= 200-50p, where Q is the quantity (sold in thousand units) and p is the price for one (1) Febreze Car Vent Clip Air Freshener. Using Excel, calculate the point price elasticity of demand, e, for price, p= 1, 2, 3….., 20. Describe the pattern of price elasticity of demand that you have calculated along the demand curve.

Quantity	Price	Elasticity €
	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20