Question: SECTION 2 Question 4 You are given the following information, comprising of the sales in a particular company for the Month of September, 2016. Use

SECTION 2 Question 4 You are given the following information, comprising of the sales in a particular company for the Month of September, 2016. Use the information provided to forecast the sales for September, 2017. Day Sales Day Sales N a) Determine the sales forecast using a three (3) period moving average. b) Determine the sales forecast using a three (3) period weighted moving average. Use 4, 3, & 2 for the weights of the most recent, second most recent and third most recent periods. c) Develop an exponential smoothing forecast using a=0.7. Assume the forecast for the first day is equal the actual for the first day. d) Evaluate the accuracy of each method, using the MAD and MSE. e) Which forecasting method is the most accurate and why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
