A restaurant wants to forecast its weekly sales (in dollars) for 15 weeks are shown below:

Time Period	Observation
1	1486
2	1345
3	1455
4	1386
5	1209
6	1178
7	1581
8	1332
9	1245
10	1521
11	1544
12	1502
13	1656
14	1701
15	1532

Use the following Template to solve the problem and answer the following questions

(a.) What is the forecast for week 16, using a two-period moving average?

(b.) What is the forecast for week 16, using a three-period moving average?

(c.) Compute and compare MSE for the two- and three-period moving average models.

(d.) Can you think of the best number of periods for the moving average model based on MSE

Enter data only in yellow cells. The template is designed for up to 20 observations and k -2, 3, or 4. Periods in moving average,k(2,3, or 41 3 observation Forecast Time period Error Error 1172 217 190 #N/A #N/A #N/A 233 193.00 40.00 160.00 1178.78 179 213.33 -34.33 162 200.67 1495.11 191.33 1367 181.67 1.67 2.78 43.00 1849.00 250 2013.00 4 2209.00 1511 -67.33 4533.78 11 218.33 218 208.67 9.33 87.11 13, #N/A #N/A 14 RNA. #N/A #N/A 16 #N/A #N/A. #N/A 17 MN/A AN/A #N/A #N/A 250 Moving Average Forecast 3 14 Time Period Observaton Forecast 9 20