Question
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
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 Demand (Gal)
October 800
November 725
December 630
January 500
February 645
March 690
April 730
May 810
June 1200
July 980
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 is (type number only, two decimals)
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. It is (type number only, two decimals)
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 is (type number only, two decimals)
In the Petroco Service Station problem, for the exponentially smoothed forecast with an value of .50, compute the mean absolute deviation (MAD) via Excel and/or POM-QM. It is (type number only, two decimals)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started