Construct a graph showing supply and demand

Reference no: EM13128954

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/Feeder	Quantity Demanded	Quantity Supplied
$300	500	1800
270	600	1700
240	700	1600
210	800	1500
180	1000	1400
150	1100	1300
120	1200	1200
90	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?

Reference no: EM13128954

Questions Cloud

What is the new volume of the gas : Occupies 6.0 cubic meters at a pressure of 1.5 atm. The pressure is then expanded to 2.0 atm. The temperature remaining constant, what is the new volume of the gas?

What are the ethical factors in this situation : Identify the parties potentially affected by this audit and the fee plan proposed.

Assets and liabilities from transaction : CalCount pays a weekly payroll of $85,000 that includes federal taxes withheld of $12,700, FICA taxes withheld of $7,890, and 401(k) withholdings of $9,000. What is the effect of assets and liabilities from this transaction?

Find the probability that all of the products are acceptable : The remainder are defective. If 4 of the products are randomly selected, find the probability that all of them are acceptable.

Construct a graph showing supply and demand : Construct a graph showing supply and demand in the electronic dog feeder market and how are the laws of supply and demand illustrated in this graph? Explain your answers.

How does size ,electron configuration of sodium atom change : When the sodium atom becomes a sodium ion, how does the size and electron configuration of the sodium atom change?

Define what you would observe after elution : Discuss what you would observe after elution and visualization of a TLC plate having made the following mistakes in carrying out the anaylsis.

How much gain was required to be allocated to tina : Tina and Betty formed a partnership. Tina received a 40 percent interest in the partnership in exchange for land with an adjusted basis to her of $60,000 and a fair market value of $80,000.

Find probability that at least half of sample are in favor : Suppose in fact that 47% of the population favors this idea. Use the normal distribution to calculate the probability that at least half of the sample are in favor.

User Account

All Pages