Question

"Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. The marketing department of Acme Inc. has estimated the following demand function for its popular carpet deodorizer, Freshbreeze: Q = 100 – 5p, where Q is the quantity of an 8 oz box sold (in thousand units) and p the price of an 8 oz. box."

Q = 100 - 5 p Use Excel to calculate the point price elasticity of demand, ε, for price, p = 1, 2, 3,…, 19.

p Q ε $1 95 $2 90 $3 85 $4 80 $5 75 $6 70 $7 65 $8 60 $9 55 $10 50 $11 45 $12 40 $13 35 $14 30 $15 25 $16 20 $17 15 $18 10 $19 5 Determine the prices at which the demand curve is elastic, inelastic and has unitary elasticity moving from low prices to high prices. The demand curve is inelastic at prices from to . The demand curve has unitary elasticity at price . The demand curve is elastic at prices from to .

Answer 1