Calculate mad mapd and mse

Assignment Help Finance Basics
Reference no: EM13279762

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: EM13279762

Questions Cloud

Drawbacks to market-based carbon strategies : Drawbacks to market-based carbon strategies include all of the following except:
Neo-classical architecture and neo-classical painting : Neo-classical architecture and neo-classical painting both find inspiation from what period?
An organization to foster extrinsic motivation : 1. Determine which is better for an organization - to foster extrinsic motivation in its employees or intrinsic motivation in its employees. Explain your reasoning.
More correct about artists of the netherlands : Which statement is more correct about artists of the Netherlands.
Calculate mad mapd and mse : 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 unlea..
Find multiple banks to deposit his money why : Michael has inherited $500,000 from the sale of a family business. His banker is advising him to find multiple banks to deposit his money. Why?
About theories regarding the technology : In Czitrom's book he talks about theories regarding the technology. How could this be related to Appadurais view about technoscape?
Consider the issues within the jurisdiction of arbitration : Consider the issues within the jurisdiction of arbitration. Which of these issues do you think will expand or contract in the future? Do you anticipate that arbitration will handle more or fewer issues, and why?
The primary motive of an enterprise is to make a profit : A skunkworks is a group of people who split off from a company to use its proprietary technology and trade secrets for starting their own enterprise.

Reviews

Write a Review

Finance Basics Questions & Answers

  What would you tell the president

The company president has approached you about Mullineaux's capital structure. He wants to know why the company doesn't use more preferred stock financing because it costs less than debt. What would you tell the president?

  Finding the bond value

What was your average annual capital gains yield over the past three years on this bond ('07-'10)? Note: just find the capital gains yield, not the "total" yield.

  What is the standard deviation of these returns

Over the past six years, a stock had annual returns of 2 percent, -5 percent, 6 percent, 3 percent, 3 percent, and -2 percent, respectively. What is the standard deviation of these returns? 3.61 percent 3.88 percent 3.33 percent 3.97 percent 3.29 ..

  What would the weights used in the calculations

What would the weights used in the calculations of Accessory WACC for comon stock and preferred stock and bonds, respectively?

  Calculate the after-tax cost of debt

Calculate the firm's weighted average cost of capital using he capital structure weights shown in teh following table. (Round answer to the nearest 0.1%)

  Determine at least one primary and one secondary method

There are a number if large projects to evaluate. What criteria are you most likely to use to evaluate these projects and why? What would each criterion tell you? Determine at least one primary and one secondary method.

  Explain stock valuation with constant growth rates

Explain Stock Valuation with constant growth rates in the dividends and the required rate of return on the stock

  Explain trend of interest rates

Explain trend of interest rates and describe the trend of interest rates over the last several years

  Mergers and team building

You've just been part of merger. You've each been chosen to head up your department and merge the two groups into a self-directed work team.

  What will you pay for a share today

Antiques R Us is a mature manufacturing firm. The company just paid a dividend of $9, but management expects to reduce the payout by 4 percent per year, indefinitely. If you require an 11 percent return on this stock, what will you pay for a share..

  Calculate the depreciation tax shield

Assume a tax rate of 30% and a discount rate of 12%. Calculate the depreciation tax shield for this project in year 1.

  Explain finding required rate of return using capm formula

Explain Finding required rate of return using CAPM formula and Calculate the tax liability on the assets

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