Question

Week 1 Project

Instructions

Supply and Demand Concepts

You have been hired by a new firm selling electronic dog feeders. Your client has asked you to gather some data on the supply and demand for the feeder, which is given below, and address several questions regarding the supply and demand for these feeders.

Price per Feeder	Quantity Demanded	Quantity Supplied
$300	500	1800
270	600	1700
240	700	1600
210	800	1500
180	1000	1400
1150	1100	1300
120	1200	1200
80	1300	1100
60	1400	1000
30	1500	900
10	1600	800

Your client has asked that you develop a report addressing the following questions so that you can present these findings to their Board of Directors:

Questions:

Construct a graph showing supply and demand in the electronic dog feeder market, using Microsoft 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 $180 in the feeder market. What would happen in this market?

Assume that the price floor is removed and a price ceiling is imposed at $90. What would happen in this market?

Now, assume that the price of feeders drops by 50%. How would this change impact the demand for feeders? Explain your answer and reconstruct the graph developed in question one to show this change.

Assume that incomes of the consumers in this market increases. What would happen in this market? Explain your answer and reconstruct the graph developed in question one to show this change.

Assume that the number of sellers decreases in this market. What would happen in this market? Explain your answer and reconstruct the graph developed in question one to show this change.

Explain the difference between a normal good and an inferior good. Would your answers to question 7 change depending on whether this good is a normal or inferior good? Why?

Submission Details:

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

Name your document SU_ECO2072_W1_LastName_FirstInitial

Submit to the Submissions Area by the due date assigned.

If you want to learn how to use Microsoft Excel to create curves, refer to the Microsoft Excel tutorial link.

Due Date

Dec 20, 2017 11:59 PM

Answer 1

2. The law of demand is diminishing demand with increase in price and law of supply is increasing with increase in price.
3. The equilibrium price is 120 and quantity is 1200
4. With quantity supplied 1400 and demand is 1000, it would lead to excess of 400 at price floor of $180
5. This would lead to shortages by 300 as the demand would be 1350 and supply 1050

6. For the decrease in price the supply would decrease and demand increases

7. For the decreased sellers this would create lesser supply leading to increased demand and increase in price

8. A normal good will have increased demand for decrease in price while for a inferior good the demand decreases for decrease in price