70.2K

Verified Solution

Link Copied!

Table 2. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 wecks appears in table 1 below weck Demand Forecadad Ahe Des Som AS 120 4 22 18 22 22 22 o 10 lii 13 12 23 23 bu 127 125 13 116 11 18 19 120 123 14 14 15 11 16 22 23 14 Using the exponential smoothing forecasting techniques with a =40. a). Compute the exponentially smoothed forecast average without trend: Use this formula F,=(A.-) +(1-a) F... 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) e). Mean Square Error (MSE). d). Mean Absolute Percentage Error (MAPE). Table 2. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 weeks appears in table I below weck Demand Free Timo Ahe DAPO 20 13 4 18 22 22 16 193 11 12 13 14 16 17 118 19 27 25 22 20 114 14 15 11 16 21 22 ST 14 40. Using the exponential smoothing forecasting techniques with a a). Compute the exponentially smoothed forecast average without trend: Use this formula F,= (A.-1) +(1-a) F1 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)

Answer & Explanation Solved by verified expert

See Answer