Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets for the month of August are Week 1250Week 2350Week 3550Week 4650 a. Using a three-week moving average, what would you forecast the next week to be?b. Using exponential smoothing with α = 0.30, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(250 + 350)/2 = 300], what would you forecast week 5 to be?

Given- Week Demand Week 1 250 Week 2 350 Week 3 550 Week 4 650

Answered: Not all the items in your office supply…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Related questions

Question

Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets for the month of August are


Week 1	250
Week 2	350
Week 3	550
Week 4	650

a. Using a three-week moving average, what would you forecast the next week to be?

b. Using exponential smoothing with α = 0.30, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(250 + 350)/2 = 300], what would you forecast week 5 to be?

Expert Solution