Replace X with = 32. Please show the excel formulas!! :)

1. The demand manager of Maverick Jeans is responsible for ensuring sufficient warehouse space for the finished jeans that come from the production plants. It has occasionally been necessary to rent pubic warehouse space, something that Maverick would like to avoid. In order to determine the space requirements, the demand manager is evaluating a few forecasts. The demand (in 1,000 case units) for the last fiscal year is shown below.

Month	1	2	3	4	5	6	7	8	9	10	11	12	13	14
Demand	X	X-1	X+2	X-3	X+3	X+5	X+6	X+8	X+11	X+10	X+13	X+16	X+15	X+17

a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4-14 and generate a forecast for the fifteenth month.

b. Repeat part a, use a 3-month weighted moving average with the following weights: First weight (most recent month): [X/90] Second weight: [1-(X/90)]*0.65 Third weight: [1-(X/90)]*0.35 Use all decimal places for the weights.

c. Use X as the forecast for month 1. Use an exponential smoothing model with = X/90 to estimate the month-in-advance forecast of demand for months 2-14 and generate a forecast for the fifteenth month. Use three decimal places for the value. Use the exponential smoothing formula with sub index t-1 in both terms of the formula.

d. Use X as the forecast for month 1. Use an exponential smoothing model with = [1- (X/90)] to estimate the month-in-advance forecast of demand for months 2-14 and generate a forecast for the fifteenth month. Use three decimal places for the value. Use the exponential smoothing formula with sub index t-1 in both terms of the formula.

e. Compare the simple average forecast error and MAD for the forecasting methods in parts a., b., c., and d. Based on these error calculations, which of the four forecast methods would you recommend? Why? (25 points)