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. Compute an exponentially smoothed forecast with an a value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of January would be (type number only, two decimals) Month October November December January February March April May June July Gasoline Demanded (gal.) 800 725 630 500 645 690 730 810 1,200 980
a. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of August
b.In the Petroco Service Station problem, for the exponentially smoothed forecast with an α value of .30, compute the mean absolute deviation (MAD) via Excel and/or POM-QM
c. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of January would be
d.In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of August
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 7 images
