The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons 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:
Month Gasoline Demanded (gal.)
a. Compute an exponentially smoothed forecast, using an α value of 0.30.
b. Compute the MAPD.
The solution comprises of detailed calculations of Exponential Smoothing Forecast and MAPD in Excel.