Assignment 3: Demand and Supply
ronyroThe 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 |
Questions:
- Construct a graph showing supply and demand in the E-Book market, using Excel.
- How are the Laws of Supply and Demand illustrated in this graph? Explain your answers.
- What is the equilibrium price and quantity in this market?
- Assume that the government imposes a price floor of $12 in the E-Book market. What would happen in this market?
- Assume that the price floor is removed and a price ceiling is imposed at $6. What would happen in this market?
- 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.
- 11 years ago
- 5
Answer(3)
Purchase the answer to view it
- supply_and_demand.docx
- supply_and_demand.xlsx
Purchase the answer to view it
NOT RATED
- supply_and_demand.xlsx
Purchase the answer to view it
NOT RATED
- m2_assignment_3_demand_and_supply.docx
- m2_assignment_3_demand_and_supply.xlsx
Bids(0)
other Questions(10)
- mat540 - Quiz - 5: Week - 9 ( Graded 40/40 )
- is there any links between The Fibonacci sequence
- Read the short story Kill to eat and write a diary entry from any character's point of view about the...
- What types of learning strategies and evidence of accomplishments will you be using for your practicum project? Give some specific examples.
- Marketing Assignment
- for kim
- Assignment: Common Market to European Union
- 800-1000 word count paper
- Fundamental of accounting 1 - Fire destroyed accounting records. From information given, prepare a heading and reconstruct a trial balance...
- mine is math lab homework and pre test have don about half the assignments but work does not allow me...