Determine demand schedule for tammy fay brand mascara

Question

Assignment:

1. Consider the following hypothetical demand schedule for "Tammy Fay" brand Mascara:

Price per pound:	$0	$6	$12	$18	$24	$30	$36
Quantity demanded:	600 lbs	500 lbs	400 lbs	300 lbs	200 lbs	100 lbs	0 lbs

Based on this demand schedule, use excel to set up a graph of the demand curve and also the corresponding total revenue curve (use two separate graphs for this, in both cases with quantities on the horizontal axis).

In this same excel sheet, also calculate the price elasticity of demand for each price range using the midpoints formula (make sure to use excel for your calculations, so that I can take a look at those).

2. Suppose that the demand for Cod Liver Oil (CLO) can be written Q_D =5000-2P (so, the inverse demand curve for CLO is P=2500-0.5QD), where P is the price per ton (in dollars) of CLO and Q_D is the quantity demanded (in tons) in a period. Based on this information, create an excel sheet which:

1. Sets up scatterplots of (i) the demand curve and (ii) the corresponding total revenue curve for this market (in two separate diagrams).

2. Calculate price elasticity of demand using the point elasticity formula at the following amounts of CLO along this demand curve: Q_D=4000, Q_D =2500, Q_D =1000. Also, calculate totals revenue from sales in this market at each of these quantities: Q_D=4000, Q_D =2500, Q_D =1000.