Reference no: EM1359897
Forecasting: Forecasting impacts so many parts of business. It is used to set budgets, allocated resources, plan for the future, etc. There are many ways to forecast since there so many nuances to it. The forecasting we will look at this semester is based on the historical momentum of the data being forecasted, using various techniques like period-over-period growth, regression, etc. The assignment here is to apply the best technique to forecast a real business dataset.
The project requires you forecast the historical data, replicating the appropriate trends, seasonalities, week-over-week variability, etc. Please refer to the chapter and materials on Forecasting for the procedures to do.
The Questions
For each question, show the work to support your answer.
Analysis
a) Using regression as the procedure, produce the forecast of weekly sales for the periods Jan 27, 2014 through Jan 19, 2015
b) Show a graph of the historical and forecasted sales in one graph
c) Which week in the forecasted period is expected to have the highest volume of sales and which week is expected to have the lowest volume of sales
d) Using year-over-year change as the procedure, produce the forecast of weekly sales for the periods Jan 27, 2014 through Jan 19, 2015
e) Show a graph of the historical and forecasted sales in one graph
f) Which weeks in the forecasted period are expected to have the highest volume of sales and the lowest volume of sales (5 points)
General
e) Does either of the forecasts "look" good to you? Why or why not?
f) What are the implications to a business if the forecast is too high?
g) What are the implications to a business if the forecast is too low?
h) Give three examples of of data that cannot be forecasted and why.
Download:- Forecasting_project.xlsx
|
Considering the state of the region today
: Considering the state of the region today. How is your influence still evident? If you could go back and colonize the area again, what might you do differently and what results do you expect for your country and for the colonized country? If you woul..
|
|
World regional geography course
: In your opinion, should economic tigers be feared or tamed? Why? If you chose "feared," how does this impact other global economies and powers? If you chose '"tamed," how should other global powers tame them?
|
|
World regional geography
: The course is World Regional Geography and the subject is WEST AFRICA, as follows: a summary of the region you researched, including pre- and post-colonial information about culture, economy,
|
|
World geology
: How do these scripture quotes relate to the current state of this realm surrounding Mecca, Medina, and Jerusalem? How is each religious faction reacting to current events based on their beliefs?
|
|
Forecasting-the historical data, replicating the appropriate
: The project requires you forecast the historical data, replicating the appropriate trends, seasonalities, week-over-week variability, etc. Please refer to the chapter and materials on Forecasting for the procedures to do.
|
|
Explain honda has invested
: Explain Honda has invested $550 million in building an assembly plant in Greensburg
|
|
Explain and provide examples and supporting evidence
: Explain and Provide examples and supporting evidence from multiple sources to support your position.
|
|
Explain what is an opinion leader
: Explain What is an opinion leader and Describe how marketers attempt to use opinion leaders to help sell their products.
|
|
Explain the team ha to present a completed strategic plan
: Explain The team ha to present a completed strategic plan to the board of directors of Riordan Manufacturing
|