=10-34 Using the data in Solved Problem 10-3, develop a spreadsheet for a 2-period weighted moving average

Question:

=10-34 Using the data in Solved Problem 10-3, develop a spreadsheet for a 2-period weighted moving average forecast with weights of 0.6 (w1)for the most recent period and 0.4 (w2) for the other period. Note these weights sum to 1, so the forecast is simply Forest for next period Value in current period Valu

=

+

w w 1 2

(

) ( e in last period)

Find the weights for this 2-period weighted moving average that would minimize the MAD. (Hint: The weights must sum to 1.)

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

Step by Step Answer:

Related Book For  book-img-for-question

Quantitative Analysis For Management

ISBN: 9789332578692

12th Edition

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna

Question Posted: