The following is average weekly per pound price data for apple pears in the US (from usda.gov) starting May. Your employer wants you to determine forecasted average weekly price for all the weeks starting in May.

Week of (2019 Calendar Year)	Actual ($/lb)	Nave Previous Period ($/lb)	Moving Average ($/lb)	Weighted Moving Average ($/lb)	Exponential Smoothing ($/lb)
May 6	1.72
May 13	2.43
May 20	2.99
May 27	1.72
June 3	1.59
June 10	3.50
June 17	3.50
June 24	1.50
July 1	1.50
July 8	1.59
July 15	2.49
July 22	2.49
July 29	1.99

1. For each period starting in May (through August 6), determine the forecasted values (round all responses to two decimal places) using:
   1. Nave previous period
   2. Four-period moving average
   3. Four-period weighted moving average (w₁=0.35, w₂=0.3, w₃=0.25, w₄=0.10).
   4. Exponential smoothing with an = .35. Make the assumption that the forecasted value of May 20 is equal to the actual value of May 20.

To receive any credit for filling out the above table, you must show your hand written work on attached pages. You should also double check your work using Excel (Excel for forecasting wont be graded).

2. For the last four periods in the month of July (includes: July 8, July 15, July 22, and July 29),
   1. calculate MAD, MSE, and MAPE (ok to use Excel here), and fill out the following table

	Nave Same Period	Four- period moving average	Weighted Moving Average	Exponential Smoothing
Error Summary
MAD ($/lb)
MSE [($/lb)2]
MAPE (%)

2. Which forecasting technique do you recommend the company uses? Justify your response.