Show a graph of the historical and forecasted sales

Assignment Help Applied Statistics

Reference no: EM13509949

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.

This assignment 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 (20 points)

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

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.

Reference no: EM13509949

Questions Cloud

Examine the reasons for confidentiality of the igce : Examine the reasons for confidentiality of the IGCE. Propose two (2) actions that should be taken in order to maintain the confidentiality of the IGCE.

Calculate the speed of the three coupled cars : A railroad car of mass 2.00 x 10^4 kg moving at 3.00 m/s collides and couples with two coupled railroad cars, What is the speed of the three coupled cars after the collision

Compare and contrast critique guidelines : Click Compare and Contrast Critique Guidelines and Rubric for further details.

Particular criminal organization is an example : A __________ is especially valuable when aspects of the social setting are beyond the control of the researcher. The study of one particular criminal organization is an example of the __________ data-gathering strategy.

Show a graph of the historical and forecasted sales : Using regression as the procedure, produce the forecast of weekly sales for the periods Jan 27, 2014 through Jan 19, 2015 - show a graph of the historical and forecasted sales in one graph

The greatest amount of happiness for the greatest number : Mill famously argued that the ethical action is what leads to the greatest amount of happiness for the greatest number of people

Finding of the national youth survey : Which of the following is not a finding of the National Youth Survey? The first step in any research is to

Most compatible with social darwinism : In debate over current political and social issues, which arguments and ideas are most compatible with social Darwinism? Which current ideas are most at odds with social Darwinism?

What issue is the speaker using to take a position : Question 1.1. (TCOs 2 and 3) What issue is the speaker using to take a position in the following situation? There is little merit to the claim that inheritance taxes will force small businesses to close. After all, the tax has existed for a lo..

User Account

All Pages