Question: NAME : Month Seasonal Factor Regular Midgrade Premium Total ( gal ) Forecast Seasonalized Error Abs ( error ) / Demand Forecast ( Reg )

NAME : Month Seasonal Factor
Regular Midgrade Premium Total (gal) Forecast Seasonalized Error Abs (error)/Demand Forecast (Reg) Forecast (Mid) Forecast (Prem) Jan 0.87
July Feb 0.95
August Mar 1
September Apr 1.05
October May 1.08
November Jun 1.15
December Jul 1.13
January Aug 1.07
Sep 1.02
MAPE = Oct 0.94
Nov 0.89
What is the forecasting method that you are using? Put your answer in the provided box: Dec 0.85
2% for the correct calculation of deseasonalized numbers (for the total demand)
2% for the correct calculation of seasonalized final forecast numbers (for the total demand)
2% for the correct calculation of Abs(error)/actual demand percentages
2% for the correct calculation of the MAPE
2% for the correct calculation of the forecast for each one of the gasoline grades
Note: We will only check for the correct formulas (to see if they have done it correctly). Everybody will have different numbers in their simulation.
All the columns for calculations are added here already. You can add more rows or columns if you want
 NAME : Month Seasonal Factor Regular Midgrade Premium Total (gal) Forecast

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!