Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The spreadsheet Question3-Forecasting.xlsx has data for the past 30 weeks of sales for product X. Based on the data, do the following questions. [If
The spreadsheet "Question3-Forecasting.xlsx" has data for the past 30 weeks of sales for product X. Based on the data, do the following questions. [If you use Excel to solve this question, submit the excel file along with your solutions to the assignment. Note that you need to explain your answers to the following questions in detail, and just submitting the calculations done by excel is not enough.] (a) Plot the data. Just by looking at the plot, do you think a 3-week simple moving average would be a better forecast, or a 6-week simple moving average? Just by looking at the plot, do you think an exponential smoothing with value of a = 0.2 would be better forecast or would a = 0.6 be better? Explain your reasoning. (b) Which one of the four possible forecasts mentioned in part (a) (3-week and 6-week simple moving average and exponential smoothing with value of a = 0.2 and a = 0.6) is the best forecast? Justify your answer by calculating MAD. (Different people could reach different conclusions, but you need to give good reasons for your conclusions.) Question 3 of Assignment 3 Week t 1 23456 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Sales 574 1,004 717 1,076 1,076 932 1,291 1,219 932 1,219 1,219 1,076 1,650 1,650 1,434 1,219 1,291 1,578 1,793 1,721 1,578 1,865 1,434 1,793 1,865 1,506 1,650 1,506 1,721 1,506
Step by Step Solution
★★★★★
3.55 Rating (148 Votes )
There are 3 Steps involved in it
Step: 1
a The data is plotted below By looking at the plot it seems that the 6 month moving average will give a better forecast b The forecast using 3 week 6 week moving average alpha 02 and 06 are shown belo...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started