Weekly sales of ten-grain bread at the local organic food market are provided in the table below. Based on these data, forecast Week 9 using a four-week moving average.

Week	Sales
1	415
2	389
3	420
4	382
5	410
6	432
7	425
8	421

What is the forecast for May based on a weighted moving average applied to the following past demand data and using the weights: 4, 3, 3 (largest weight is for most recent data)?

Nov.	Dec.	Jan.	Feb.	Mar.	April
37	36	40	42	47	43

 

Arestauranthastrackedthenumberofmealsservedatlunchoverthelastfourweeks.The data show little in terms of trends, but do display substantial variation by day of the week. Use the following information to determine the seasonal (daily) indices for this restaurant. Round all numbers in your calculations to four decimal places.

Week
Day	1	2	3	4
Sunday	40	35	39	43
Monday	54	55	51	59
Tuesday	61	60	65	64
Wednesday	72	77	78	69
Thursday	89	80	81	79
Friday	91	90	99	95
Saturday	80	82	81	83

 A coffee chain sells temperature-controlled smart mugs at $150 each. The monthly sales of mugs for the last twelve months were:

Month	Sales
January	825
February	756
March	808
April	950
May	678
June	875
July	695
August	589
September	690
October	890
November	1030
December	1525

2. Computea3-monthmovingaveragedemandforecastforeachmonthfromJunethrough December. (Round all forecasts to the nearest whole unit.)
4. Computea5-monthmovingaveragedemandforecastforeachmonthfromJunethrough December. (Round all forecasts to the nearest whole unit.)
6. Calculate the MSE. covering June through December for both methods.
7.  
8. Which method is more likely to have a better for cast performance?
9.