Question

The weekly sales figures for the previous year for a new board game are given below. Assuming a weighting of 3, 2, 1, determine the three-period weighted moving average forecast for the second week in July.

WEEK	June 1	2	3	4	July 1	2	3	4	5	Aug 1	2	3	4
SALES	4	6	4	5	10	8	7	9	12	14	16

Answer 1

Solution - Consider_thegiven_peekly sales date as follows: I week June 1 2 3 4 July 1 2 3 4 Sales 4 6 4 5 10 8 7 9 - Week 1 July 5 Aug 1 2 13 14 We have been given the weights as followuss. Dy = 3_ 1,2 W= 1 three-poprod How he calculate * weighted moving average to abaile data by using the formula below; kleighted moving average where Biz ith weighing and Si= sales of ith time peziod. (thece- pezjod) And bence the weighted moving auträge is given - in the following table :

Week | Sales | Weighted (thele-pecjod) moving average 4.67 5-00 6.33 7.67. 8-33 8.00 9,33 11-67 14.00 and hence the three-period weighted moving average forecast for second week in July is, _ 8.33_ L {from above tablet