1.) Review “Forecasting Case Study: Urban Planning” (Attached link) for this topic’s case study, in which you will serve as an urban planner forecasting economic growth and decline for a specific industry in your city.
********NOTE: Students must access the “County Business Patterns” webpage (https://www.census.gov/econ/cbp/index.html) for this assignment. Students will use this U.S. Census Industry data portal to access data for a zip code with which you are familiar. ***Please use a zip code in the United States of Phoenix, Arizona or Houston, Texas**** This can be the
zip code of your personal residence, location of employer (corporate, regional, or local office), undergraduate educational institution, hometown, etc.*************
2.) In addition to the forecasting model and data, prepare a 500-750-(word document) report to your city manager. Explain your approach and the rationale for why this is the best model. Evaluate the data and conclude your report with a recommendation about either expanding the industry in your area or allocating resources elsewhere.
3.) Please use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Please use the “Forecasting Template” (attached) resource to complete this assignment.