The manager of the Excom Service Station wants to forecast the demand for unleaded gasoline next month
Question:
The manager of the Excom Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of litres can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months:
Gasoline
Month Demanded (liters)
October .................................................... 800
November ................................................ 725
December ................................................ 630
January .................................................... 500
February .................................................. 645
March ...................................................... 690
April ......................................................... 730
May ......................................................... 810
June ....................................................... 1200
July ......................................................... 980
a. Compute an exponentially smoothed forecast using an α value of 0.30.
b. Compute an adjusted exponentially smoothed forecast (α = 0.30 and β = 0.20).
c. Compare the two forecasts using MAPD and indicate which seems to be the most accurate.
d. Compare the two forecasts using MSE and indicate which seems to be the most accurate.
Step by Step Answer:
Operations Management Creating Value Along the Supply Chain
ISBN: 978-1118301173
1st Canadian Edition
Authors: Roberta S. Russell, Bernard W. Taylor, Ignacio Castillo, Navneet Vidyarthi