Forecasting

1. Weekly sales of bread at a local Whole Foods Market are given in the table below. Forecast sales for week 7 using a 3-week MA. Week 1 2 3 4 5 6 7 8 Sales 402 385 420 382 410 432 385 411 Week Sales Forecast Calculation 1 402 2 385 3 420 4 382 402.33 5 410 395.66 6 432 398.00 =402+385+420/3 = 385+420+382/3 = 420+382+410/3 7 385 408.00 = 382+410+432/3 8 411 409.00 = 410+432+385/3 9 386.00 = 432+385+411/3 10 2. Weekly sales of ten-grain bread at the local Whole Foods Market are in the table below. Based on this data, forecast week 9 using a 3 moving average. Week Sales Forecast Calculation 1 415 2 389 3 420 415+389+420/3 4 382 408 389+420+382/3 5 410 397 420+382+410/3 6 432 404 382+410+432/3 7 380 408 410+432+380/3 8 410 407.3 432+380+410/3 9 407.3