As the Dallas Morning News notes, Frisco has been one of the country s fastest-growing cities for years. New homes are being steadily added to the mix. So far this year, the city has issued, on average, 198 single-family building permits each month. Build out is projected to reach about 350,000. Assume that the city of Frisco has hired you as a policy consultant to predict population estimates for the next five years (2016, 2017, 2018, 2019, and 2020). You can find annual data from the United States Census Bureau. Also, prior work has been conducted by the city of Frisco(http://www.ci.frisco.tx.us/578/Population-Estimates-Projections).Provide two different strategies to project the five-year population forecast; then discuss what method you believe will yield the best results. Be sure to include your do file and table of your data in an appendix. Secondly, the city would like you to provide a forecast of the average cost of a single family new house construction building permit for the next five years (2013, 2014, 2015, 2016, and 2017).See data below. Provide two different strategies to project the five-year construction cost forecast; then discuss what method you believe will yield the best results. Be sure to include your do file and table of your data in an appendix. Average cost Single-family new houseconstruction buildingpermits1997 120,3001998 139,4001999 143,3002000 154,9002001 171,7002002 215,4002003 234,2002004 239,7002005 236,8002006 251,4002007 230,7002008 243,3002009 235,2002010 250,8002011 264,8002012 269,300 This is a forecasting assignment. attached is relevant material. use Stata version 14 and include all codes used to produce results. be sure to put an appendix (including to do file and graphs) and follow the guideline in attached.