Question: please do not use excel while solving. thank you 1. John's department at a local department store has tracked the sales of a product over

please do not use excel while solving. thank you please do not use excel while solving. thank you
1. John's department at a local department store has tracked the sales of a product over the last 10 weeks. 1 Week 1 2 3 4 5 6 7 8 9 10 Sale 24 28 26 32 22 30 38 32 29 24 a) Compute simple three month moving averages. b) Forecast demand using exponential smoothing with an alpha of 0.4, and an initial forecast of 28 for period 1. c) Develop Linear Trend Model. d) Based on the Linear Trend formulation find the 11th week's forecast. e) Compare the MAD results and indicate which method you would use

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!