Answered step by step
Verified Expert Solution
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 | |||
Month | Gas Demand | Exp Forecast | Error | |
October | 775 | ---- | ||
November | 835 | |||
December | 605 | |||
January | 450 | |||
February | 600 | |||
March | 700 | |||
April | 820 | |||
May | 925 | |||
June | 1500 | |||
July | 1200 | |||
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 1 attachment)
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