Assignment 3: Demand and Supply

The use of E-Books has increased in recent years, especially with the advent of mobile E-Readers.  A marketing research firm recently developed the following supply and demand schedules for E-books:


Quantity Demanded

Quantity Supplied

$18 4000 10,000
16 5000 9500
14 6000 9000
12 7000 8500
10 8000 8000
9 9000 7500
8 10000 7000
7 11000 6500
6 12000 6000
5 13000 5500
4 14000 5000
2 15000 4500


  1. Construct a graph showing supply and demand in the E-Book market, using Excel.
  2. How are the Laws of Supply and Demand illustrated in this graph?  Explain your answers.
  3. What is the equilibrium price and quantity in this market?
  4. Assume that the government imposes a price floor of $12 in the E-Book market.  What would happen in this market?
  5. Assume that the price floor is removed and a price ceiling is imposed at $6.  What would happen in this market?
  6. Now assume that the price of E-Readers (used with E-Books) drops by fifty percent. How would this change impact the demand for E-Books? Explain your answer and reconstruct the graph developed in question one to show this change. 

Present your analysis in Excel format. Enter non-numerical responses in the same worksheet using textboxes.

If you want to learn how to use Microsoft Excel to create curves, refer to the MS Excel tutorials placed.