Use the Excel spreadsheet that accompanies this chapter to evaluate different forecasting models using the ice cream

Question:

Use the Excel spreadsheet that accompanies this chapter to evaluate different forecasting models using the ice cream sales data. Try the following parameters for the moving average and simple exponential smoothing models; n=1, 4, 8; alpha = 0.1, 0.5, 0.9. Which parameters yield the best forecasting model for the periods under evaluation?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managing Operations Across the Supply Chain

ISBN: 978-0078024030

2nd edition

Authors: Morgan Swink, Steven Melnyk, Bixby Cooper, Janet Hartley

Question Posted: