You are given the following information about the satellite dish (for television/cable reception) market in the USA; specifically, the fictitious Cocojob Satellite Corporation, Inc. in Unid, California. The graph you are about to construct will appear as the 2nd graph in your presentation to the Cocojob Board of Directors as they try to get an idea about the supply and demand for their products.

From 1994-2019, the prices of their best-selling Satellite dish, the Klopz Model, measured in $1,000's of US Dollars, was: 9.0, 7.0, 5.0, 3.0, AND 1.0, respectively.

During that time, the corresponding amounts that the Cocojob Corporation was willing to produce/sell at those same prices, the quantity supplied, measured in 10,000's of Satellite dishes was: 12, 10, 8, 6, AND 4.

Meanwhile, the amount that consumers were willing to purchase at those same prices, the quantity demanded, also measured in 10,000's of units, was: 2, 5, 8, 11, AND 14.

a.) In one clearly constructed, legible, and properly labeled graph created using Excel, construct the supply and demand curves based on the data above.

b.) Referencing the curves constructed in part A, clearly state the equilibrium price and quantity.

c.) Using your supply and demand analytical skills, and referencing only the curves constructed in part A, identify the area where surplus exists and where shortage exists.

d.) Offer one clear and logical real-world reason why in this market a surplus could have occurred and one clear and logical real-world reason why a shortage could have occurred in this market

e.) Would imposing a price floor help anyone in this market? Whom and why?