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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

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

Question Posted: