Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

a. Compute an exponential smoothed forecast, using an α value of 0.4

b. Compute the MAD.

Petroco Service Station







alpha =0.4







MonthGas DemandExp ForecastError
October775----
November835
December605
January450
February600
March700
April820
May925
June1500
July1200
August


8410
SUM





MAPD




Month Gasoline Demanded (gal.) October 775 November 835 December 605 January 450 February 600 March 700 April 820 May 925 June 1500 July 1200

Step by Step Solution

3.48 Rating (164 Votes )

There are 3 Steps involved in it

Step: 1

Petroco Service Station alpha 04 Month Gas Demand Exp Forecast Error ... 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

Document Format ( 1 attachment)

Excel file Icon
60700b1d9a418_711931.xlsx

300 KBs Excel File

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

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these Finance questions