Question 5Forecasting Below is the sales data for Forever Young Boutique in 18 weeks. (You can find the Excel sheet containing this data on Canvas.) Week Sales Week Sales 246 288 245 204 236 257 174 248 229 254 153 244 252 198 162 199 189 213 10 12 13 14 15 16 17 18 4 (a) Develop a forecast for week 19 by using three different forecasting techniques: i. Three-week simple moving average ii. Weighted moving average with weights wl-0.5, w2-0.3, w3-0.2 111. Exponential smoothing technique with a smoothing constant of -03. (Hint: You may use Excel to calculate the problem.) (b) Which forecasting method you considered in Question (a) is the most accurate according to the Mean Absolute Deviation (MAD) criterion? Please justify your answer by providing the MAD values for each model Question 5Forecasting Below is the sales data for Forever Young Boutique in 18 weeks. (You can find the Excel sheet containing this data on Canvas.) Week Sales Week Sales 246 288 245 204 236 257 174 248 229 254 153 244 252 198 162 199 189 213 10 12 13 14 15 16 17 18 4 (a) Develop a forecast for week 19 by using three different forecasting techniques: i. Three-week simple moving average ii. Weighted moving average with weights wl-0.5, w2-0.3, w3-0.2 111. Exponential smoothing technique with a smoothing constant of -03. (Hint: You may use Excel to calculate the problem.) (b) Which forecasting method you considered in Question (a) is the most accurate according to the Mean Absolute Deviation (MAD) criterion? Please justify your answer by providing the MAD values for each model