Question: Below is the sales data for Forever Young Boutique between March of Year 1 and July of Year 5 . ( You can find the

Below is the sales data for Forever Young Boutique between March of Year 1 and July of
Year 5.(You can find the Excel sheet
containing this
Year 2
6381.074405.839126.9510970.4510189.287043.856717.379139.7211315.1910838.411150.94
data on Blackboard.)
1) Develop a forecast for the sales in August of Year 5 by using three different forecasting techniques: Three-month simple moving average, Weighted moving average with weights 0.5,0.3,0.2(the weight 0.5 is given to the most recent observation), and Exponential smoothing method with a smoothing constant of 0.3.(15 points)
2) Which forecasting method you considered in Question 1 is the most accurate according to the Mean Absolute Deviation (MAD) criterion? Please justify your answer. (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!