PRACTICE QUESTIONS: Please show actual calculations (not excel functions WHEN FILLING IN TABLE)!

Using the exponential smoothing forecasting techniques with = .40.

a). Compute the exponentially smoothed forecast average without trend: Use this formula F_t = (A_t-1) +(1- ) F_t-1 to calculate separately the forecast for all the required weeks in the table provided, before inserting the answers from your calculations in the forecast column of the table.

b). Calculate the Mean Absolute Deviation (MAD). ________________

c). Mean Square Error (MSE). _________________________________

d). Mean Absolute Percentage Error (MAPE). _____________________

Table 1.The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Table 1. Create a five-week moving average and compute the followings: a). The mean absolute deviation (MAD) b.)The mean squated error (MSE) c). The mean absolute percentage error (MAPE) Table 1.The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Table 1. Create a five-week moving average and compute the followings: a). The mean absolute deviation (MAD) b.)The mean squated error (MSE) c). The mean absolute percentage error (MAPE)