CON 195 PP.xIsx x * ECON195 - Final ePortfolio Sub x G Supply and demand analysis ce. X + 195%20-%20Portfolio%20Project%20Directions%20and%20Rubric%20-%20Tagged.pdf 4 100% Supply and demand analysis can be used not only to determine the market clearing price and quantity but also to estimate the impact of government policies and regulations. In this scenario, the local market has been impacted by the offshoring of production. With the loss of higher paying production jobs, displaced workers were forced to take on lower paying services jobs. With the decrease in income, the demand for housing decreased, but the demand for rental units increased. The data in Table 2 represent the current market for rental units. In order to help struggling families, the local government passed a rent control law that sets the maximum rent that can be charged at $2,000 per month. Before the mayor acts on the Common Counsel resolution, she has asked you as the Chief of Staff to prepare a brief document on the impact of imposing rent control View this video for help in completing scenario 2: Scenario 2 - Government. Policy Impact on the Market Using Supply & Demand Table 2: Data for Scenario 2 Price Qd Os $ 500 1500 3,500 750 1250 3,000 $ 1000 1000 2,500 $ 1250 750 2,000 1500 500 1,500 1750 250 1,000 Part A: Using the same template used for Scenario 1, begin Scenario 2 by importing the data from Table 2 into the template. In the box provided, insert a chart (Scatter with straight lines and markers) and title the chart Market for Rental Units. Properly label the axis and include a legend. Part B: Fill in the equilibrium table provided and label equilibrium E. Part C: Complete the price ceiling table and, using the values from the table, insert a price ceiling line to the original chart. acer