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:

8000

7000

6000

5000

Questions:

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.