Demand and Supply
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:
Price/E-Book | 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 |
Assignment Guidelines:
Using Microsoft (MS) Excel, construct a graph showing supply and demand in the E-Book market based on the data above. (Save this file because you will re-work it later in the assignment.) When finished, copy and paste or import your graph into an MS Word document.
(Tutorials for working with MS Excel and MS Word can be found through the Tutoring Services and Tutorials link at the top of the page.)
In your MS Word document, below your imported graph, respond to the following:
- Explain how the Laws of Supply and Demand are illustrated in this graph.
- Describe the equilibrium price and quantity in this market.
- Assume that the government imposes a price floor of $12 in the E-Book market. Explain what would happen in this market.
- Assume that the price floor is removed and a price ceiling is imposed at $6. Explain what would happen in this market.
- Now, assume that the price of E-Readers (used with E-Books) drops from $60 by fifty percent. How would this change impact the demand for E-Books? Explain your answer. Then, reconstruct your original graph to show this change and place it in your MS Word document below your explanation.
Remember, quotations, paraphrases, and ideas you get from books, articles, or other sources of information should be cited using APA style. Help with citing sources can be found through the Academic Resources page under Course Home.
10 years ago
3
Purchase the answer to view it

- soln.docx
- data.xlsx
Purchase the answer to view it

- demand_and_supply.docx
Purchase the answer to view it

- m2_assignment_3_demand_and_supply.docx
- m2_assignment_3_demand_and_supply.xlsx
- Customized search results based on a user’s previous Internet use history
- Explain the differences between regression analysis and correlation analysis
- Finance QS
- Using data from 82 subjects, a cancer epidemiologist studied the relationship
- Applying the 21 Synectics Steps (FOR KIM WOODS ONLY)
- Response Paper
- macroeconomics
- Healtcare Administration
- Why would Christians in the West be moved to embark on a dangerous journey to fight in the Holy Land after hearing Pope Urban's speech at Clermont?
- write 4 pages aboout a character in the word freak book

