Calculate mad, mapd and mse

Assignment Help Business Management

Reference no: EM13265204

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 12 months:
Month Gasoline Demanded (gal.)
October 800
November 725
December 630
January 500
February 645
March 690
April 730
May 810
June 1,200
July 980
August 1,000
September 850
a. Compute a 2-month moving average demand forecast for the months of December to September. Calculate MAD, MAPD and MSE.
b. Compute a 2-month weighted moving average demand forecast for the months of December to September. Calculate MAD, MAPD and MSE. (w1=0.6, w2=0.4)
c. Assume the demand forecast for November is equal to the actual demand of October, 800. Compute an exponentially smoothed demand forecast for the months of November to September, using an α value of .30. Calculate MAD, MAPD and MSE.
d. Assume the demand forecast for October is also 800. Compute an adjusted exponentially smoothed demand forecast for the months of November to September. Calculate MAD, MAPD and MSE. (with α = .30 and β=.20).
e. Compute linear trend line demand forecast for the months of October to September. Calculate MAD, MAPD and MSE.
f. Compare the five forecasts by using MAD, MAPD and MSE and indicate which seems to be more accurate.

Reference no: EM13265204

Questions Cloud

How accurate is the estimate : A six-year bond with a continuosly compounded yield of 4% provides a 5% coupon at the end of each year. Use duration and convexity to estimate the effect of a 1% increase in the yield on the price of the bond. How accurate is the estimate?

Find what is the quality factor q of the coil : purchase an inductor coil for a resonance circuit resonating at 1500 kHz; the operating bandwidth is 10 kHz. What is the quality factor Q of the coil

How much will he have to save each month : He can afford to save $4,100 per month for the next 10 years. If he can earn a 10 percent EAR before he retires and a 7 percent EAR after he retires, how much will he have to save each month in years 11 through 30?

Obtain fraction of its kinetic energy is rotational : An 8.70-cm-diameter, 340g solid sphere is released from rest at the top of a 1.50-m-long, 18.0 degree incline. What fraction of its kinetic energy is rotational

Calculate mad, mapd and mse : Compare the five forecasts by using MAD, MAPD and MSE and indicate which seems to be more accurate.

Determine the total energy lost to friction : A 3.3-m-diameter merry-go-round with rotational inertia 100kg?m2 is spinning freely at 0.60rev/s. Determine the total energy lost to friction

What is the maximum number of barrels of cranberries : What is the maximum number of barrels of cranberries that are waiting onthe trucks at any given time?

Compute the maximum induced emf in the coil : A rectangular coil of 58 turns, dimensions 0.100 m by 0.200 m, and total resistance 10.0 ? rotates with angular speed 35.0 rad/s, Calculate the maximum induced emf in the coil

Evaluate the cost aspects of each alternative : How would you structure an analysis to not only evaluate the cost aspects of each alternative, but also the benefits over a 3 year time horizon? Limit your answer to 500 words.

User Account

All Pages