by using this table please solve all above questions from 2 to 5

16 Q2. Calculate the reseasonalized FC for weighted average method. Q3. Do the same (April to December) using exponential smoothing method and reseasonalize the FC. (Last period's FC, use 296) Q4. Which FC method is more accurate? Back your answer using a quantitative technique (only compare April to Dec data) Q5. Does the forecast meet industry standards? (Hint: use MAPE, Tracking Signal etc. as discussed in class) NOTE: You can provide your answers on an excel sheet showing your calculations. Consider the following data for answering the questions below. avg. FC FO Month 2019 Weighted Exp Seasonal Bescasonalized Rescasonlized 2019 Descasonalized Moving Smoothing Index Weighted Exp Actual Actual demand FC moving avg. smoothing demand Alpha FC 0.5 Jan 319 319 0.941 300 Feb 265 319 1.002 265 Mar 292 292 0.958 280 April 294 287.68 295 1.002 290 May 286 288.41 1.013 305 June 293 289.66 1.040 310 1.024 July 303 290.86 300 1.007 298 Aug 296.81 285 298.8 296 0.963 Sep 285 0.991 Oct 297.85 288 295 0.991 292.34 298 Nov 325 294.36 0.991 Dec **FC - forecast T Focus 16 Q2. Calculate the reseasonalized FC for weighted average method. Q3. Do the same (April to December) using exponential smoothing method and reseasonalize the FC. (Last period's FC, use 296) Q4. Which FC method is more accurate? Back your answer using a quantitative technique (only compare April to Dec data) Q5. Does the forecast meet industry standards? (Hint: use MAPE, Tracking Signal etc. as discussed in class) NOTE: You can provide your answers on an excel sheet showing your calculations. Consider the following data for answering the questions below. avg. FC FO Month 2019 Weighted Exp Seasonal Bescasonalized Rescasonlized 2019 Descasonalized Moving Smoothing Index Weighted Exp Actual Actual demand FC moving avg. smoothing demand Alpha FC 0.5 Jan 319 319 0.941 300 Feb 265 319 1.002 265 Mar 292 292 0.958 280 April 294 287.68 295 1.002 290 May 286 288.41 1.013 305 June 293 289.66 1.040 310 1.024 July 303 290.86 300 1.007 298 Aug 296.81 285 298.8 296 0.963 Sep 285 0.991 Oct 297.85 288 295 0.991 292.34 298 Nov 325 294.36 0.991 Dec **FC - forecast T Focus