Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 . The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of

1. 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 \alpha 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) Oct 800 Nov 725 Dec 630 Jan 500 Feb 645 Mar 690 April 730 May 810 June 1200 July 9802. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an \alpha 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)3. In the Petroco Service Station problem, for the exponentially smoothed forecast with an \alpha value of .30, compute the mean absolute deviation (MAD) via Excel and/or POM-QM. It is (type number only, two decimals)4. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an \alpha 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)5. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an \alpha 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)6. In the Petroco Service Station problem, for the exponentially smoothed forecast with an \alpha value of .50, compute the mean absolute deviation (MAD) via Excel and/or POM-QM. It is (type number only, two decimals)7. For the Petroco Service Station problem, upload your excel file that shows exponentially smoothed forecasts with \alpha values of .30 and .50. The mean absolute deviation (MAD) computations of the two forecasts should be included in the file.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Social Media Management

Authors: Ben Shields

1st Edition

019029633X, 978-0190296339

More Books

Students also viewed these General Management questions

Question

How does nonverbal communication express cultural values?

Answered: 1 week ago