Question
Sales for the past 12 months at XYZ Company are given here. Months Sales ($ millions) Months Sales ($ millions) January 20 July 53 February
Sales for the past 12 months at XYZ Company are given here.
Months | Sales ($ millions) | Months | Sales ($ millions) |
January | 20 | July | 53 |
February | 24 | August | 62 |
March | 27 | September | 54 |
April | 31 | October | 36 |
May | 37 | November | 32 |
June | 47 | December | 29 |
Tasks:
1. Use a 3-month weighted moving average to forecast the sales for the months April through December. Use weights of (3/6), (2/6), and (1/6), giving more weight to more recent data.
2. Use exponential smoothing with α = 0.6 to forecast the sales for the months April through December. Assume that the initial forecast for January was $22 million. Start error measurement in April.
3. Compare the performance of the two methods by using the mean absolute deviation (MAD) as the performance criterion, with error measurement beginning in April. Which method would you recommend?
Step by Step Solution
3.34 Rating (145 Votes )
There are 3 Steps involved in it
Step: 1
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 StartedRecommended Textbook for
Operations Management Processes and Supply Chains
Authors: Lee J. Krajewski, Manoj K. Malhotra, Larry P. Ritzman
11th edition
978-0133872460, 133872467, 133872130, 978-0133872682, 133872688, 978-0133872132
Students also viewed these Accounting questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App