Reference no: EM131342687
Forecasting case study
Review "Forecasting Case Study: Urban Planning" 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.
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. This can be the zip code of your personal residence, location of employer (corporate, regional, or local office), undergraduate educational institution, hometown, etc.
In addition to the forecasting model and data, prepare a 500-750-word 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.
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). Students are highly encouraged to use the "Forecasting Template" Excel resource to complete this assignment.
Scenario
You have recently been hired as an urban planner for your local government. You have been tasked with determining economic growth and decline patterns in your area. As an urban planner, you will ultimately be responsible for determining patterns and forecasting for all industries within your area. However, the city manager has asked that you prioritize one of the 10 industries below. Business proposals have been submitted and the city manager would like to have use forecasting data to make an informed decision about whether to approve industry expansion or to allocate resources elsewhere.
Industries
• Construction
• Manufacturing
• Transportation and Warehousing
• Information
• Finance and Insurance
• Real Estate and Rental and Leasing
• Professional, Scientific, and Technical Services
• Management of Companies and Enterprises
• Administrative and Support and Waste Management and Remediation Services
• Health Care and Social Assistance
Forecasting
Access the "County Business Patterns" page on the United States Census Bureau website and enter your city's zip code. Using one of the industries above, access the data for the last 5 years that are available on website. Determine patterns of economic growth or decline during this time period, and develop the most optimal forecasting model for the next 2 years. Note that you will need to set up these two forecast calculations.
Clearly justify why your selected model is the best one. Specifically explain what forecast error is and how you used it to ascertain the most optimal forecasting model. Assume that you are presenting your findings to senior management and that senior management has minimal knowledge of forecasting techniques and how forecast error is calculated.
What dilemma does the differ-ence create for government
: How might this difference in the rate of unemployment be explained? What dilemma does the differ-ence create for government?
|
Describe the goals of the change initiative
: Write a memo to the department heads of Pegasus to describe the goals of the change initiative, which is the reorganization. In this memo, you must do the following: Gain the trust of the department heads by offering a clear explanation of the need..
|
Ancestors of modern europeans
: With which archaic human species did some of the ancestors of modern Europeans interbreed during the past 100,000 years?
|
Label regions of the digestive tract
: Be able to list and label regions of the digestive tract and the accessory organs of the digestive system. Be able to trace food from the mouth, through the body, and exiting the body
|
Determine patterns of economic growth or decline
: Determine patterns of economic growth or decline during this time period, and develop the most optimal forecasting model for the next 2 years. Note that you will need to set up these two forecast calculations.
|
What changes can the company-brand expect in the future
: "The formal creation of Fiat Chrysler Automobiles and its debut on the New York Stock Exchange is a historic moment. Today, building on the foundations and aspirations of Fiat S.p.A. and Chrysler Group LLC, we are beginning a completely new phase ..
|
Sticky wax werubbed on the sticks
: We stuck flies to popsickle sticks by pushing their wings into a sticky wax werubbed on the sticks. Then we made a dilution series of glucose, maltose, and sucrose inone-half log molar steps (0.003M, 0.01M, 0.03M, 0.1M, 0.3M, and 1M) from the 1Mco..
|
Describe models of change
: Describe 3 models of change. Discuss their advantages and disadvantages in relation to the situation and culture at Pegasus
|
Step-by-step process of change for the reorganization
: Describes a step-by-step process of change for the reorganization. From the 3 change models that you identified in your DB, determine which one is most appropriate for the Pegasus situation. Justify your answer
|