A B C D E F G H M N O Month Seasonal Factor Regular Midgrade Premium Total (gal) Forecast Seasonalized Error Abs (error)/Demand Forecast (Reg) Forecast (Mid) Forecast (Prem) Jan 0.87 July 8431 1581 527 10539 Feb 0.95 August 7691 1442 481 9614 Mar 1 5 September 7377 1383 461 9221 Apr 1.05 6 October 7092 1330 443 8865 May 1.08 November 6430 1206 402 8038 Jun 1.15 8 December 6135 1150 383 7668 Jul 1.13 9 January Aug 1.07 10 Sep 1.02 11 MAPE = Oct 0.94 12 Nov 0.89 13 What is the forecasting method Dec 0.85 that you are using? Put your 14 answer in the provided box: 15 16 2% for the correct calculation of deseasonalized numbers (for the total demand) 17 2% for the correct calculation of seasonalized final forecast numbers (for the total demand) 18 2% for the correct calculation of Abs(error)/actual demand percentages 19 2% for the correct calculation of the MAPE 20 2% for the correct calculation of the forecast for each one of the gasoline grades 21 22 Note: We will only check for the correct formulas (to see if they have done it correctly). Everybody will have different 23 numbers in their simulation. 24 25 26 All the columns for calculations are added here already. 27 28