Satellite dish

You are given the following information about the satellite dish (for television/cable reception) marketin the USA; specifically, the fictitious Rennert Satellite Corporation, Inc in Albany NY. The graph you areabout to construct will appear as the 3rd graph in your presentation to the Rennert Board of Directors asthey try to get a handle on the supply and demand for their products. From 1996-2019, the prices oftheir best-selling Satellite, the TELEGRAPHER Model, measured in $1,000’s of US Dollars, was: 8.0, 6.5,5.0. 3.5, 2.0, and 0.5, respectively. During that time, the corresponding amounts that RennertCorporation was willing to produce/sell at those same prices, measured in 100,000s of Satellite disheswas: 11, 9, 7, 5, 3, and 1, respectively. Meanwhile, the amount that consumers were willing to purchaseat those same prices, also measured in 100,000s of units, was: 1, 2, 3, 4, 5, and 6, respectively. Theproduction data was retrieved from The Satellite Journal Magazine, in the article “How Many SatelliteDishes is Enough,” in the December 8, 2020 edition in an article written by Bruce Paton. The consumerdata was retrieved from Cablevision Digest, in an article written by Rich Mullins, in their April 2020 issue,pages 89-94, “How Many Satellite Dishes Can Consumers Purchase?”a. In one clearly constructed, legible, and properly labeled graph created using Excel, construct thesupply and demand curves based on the data above. (45 pts)b. Referencing the curves constructed in part A, clearly state the equilibrium price and quantity. (2 pts)c. Using your supply and demand analytical skills, and referencing only the curves constructed in part A,clearly identify the area where surplus exists and where shortage exists. (2 pts)d. Offer one clear and logical reason why in this market a surplus may have occurred (2.5 pts) and oneclear and logical reason why a shortage may have occurred in this market (2.5 pts).e. Would imposing a price floor help anyone in the market? Whom and why? (2 pts) What about a priceceiling? (2 pts)). How would Dead Weight Loss factor into your answer? (2 pts)Graphs for this assignment must be properly constructed and created using Excel. Prepare yourassignment as a Word document with embedded Excel charts. Number each step of the assignment.