Answer Happy

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
In the Petroco Service Station problem, 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 August is (type number only, two decimals)
In the Petroco Service Station problem, for the exponentially smoothed forecast with an a value of .30, compute the mean absolute deviation (MAD) via Excel and/or POM-QM. It is (type number only, two decimals)
In the Petroco Service Station problem, compute an exponentially smoothed forecast with an a value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of January would be (type number only, two decimals)
In the Petroco Service Station problem, compute an exponentially smoothed forecast with an a value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of August is (type number only, two decimals)
In the Petroco Service Station problem, for the exponentially smoothed forecast with an a value of .50, compute the mean absolute deviation (MAD) via Excel and/or POM-QM. It is (type number only, two decimals)
For the Petroco Service Station problem, upload your excel file that shows exponentially smoothed. forecasts with a values of .30 and .50. The mean absolute deviation (MAD) computations of the two forecasts should be included in the file. Upload Choose a File