2. Let the supply and demand functions for winter coats be given by: S = 200+15p and D = 1400−45p where S denotes the qu

[answerhappygod]

2. Let the supply and demand functions for winter coats be givenby: S = 200+15p and D = 1400−45p where S denotes the quantitysupplied of coats, D denotes the quantity demanded of coats, and pdenotes the price of coats.
(a) Use Excel to produce a table listing the quantity demandedand quantity supplied for the following prices: p = 5, 10, 15, 20,25, 30.
(b) Use Excel to generate a plot of the market equilibrium.
(c) Use algebra to find the equilibrium price and quantity (mustshow your work).
(d) Explain what would happen to the equilibrium in the marketfor winter coats if the government set a price ceiling of 10. Besure to quantify any resulting shortage or surplus using theprovided supply and demand functions.
Q 100,000 110,000 125,000 150,000 215,000 300,000 400,000450,000 475,000
P 1,500 1,400 1,300 1,200 1,100 1,000 900 800 700