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.

Reviews

Write a Review

Business Management Questions & Answers

  Question related to medical office procedures

Prepare a new office protocol pertaining to billing and cash management and describe the relationship of the new protocol with other existing polices

  Identify the nine main sections of a business plan

Identify the nine main sections of a Business Plan, as stated in the SBA site and in your own words write a brief explanation of the information found in each.

  Example of poor service

Gasoline stations and buffets, for example, are basically "do it yourself". Some eating places even ask you to clean up after yourself - Is this an example of poor service and Or putting it another way, no service

  Calculate the standard cost of the ingredients for wine

Hank approximations that 4% of the grape concentrate is wasted 10% of the sugar is lost, and 25% of the lemons cannot be used. Calculate the standard cost of the ingredients for one gallon of wine

  Total risk of iggy''s portfolio

Determine the total risk of Iggy's portfolio

  Public relations in crisis situations

What are some potential effects of a crisis situation? How can a crisis impact an organization? Why should an organization communicate quickly and honestly to its publics in a crisis situation?

  Explain the fallacy in this argument

the fact remains which many investors like high dividend. If this preference exists, a industry can boost its share price by increasing its dividend payout ratio. Explain the fallacy in this argument.

  Did world bank and other international donor act responsible

Did the World Bank and other international donors act responsibly and ethically in constraining their humanitarian assistance? Who has the responsibility for the health care of the Latin American people?

  Analysis for factory and dealership locations

Analysis for Factory and Dealership Locations - An automobile company is trying to evaluate where to locate its factory and dealerships in a country.

  Explaining servant leadership viewed in islamic view

How is servant leadership viewed in Islamic view? What is an effective way to measure Islamic leadership in the workplace?

  How do percentage comparisons aid to highlight performance

How do percentage comparisons aid to highlight performance? Why is comparing raw data inadequate for understanding comparisons?

  Current level of responsibility and decision- making ability

What would you like to tell us that would help us to evaluate your application?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd