Compare the two forecasts by utilizing mad

Reference no: EM1316020

Compute a 3-month and weighted moving average and also compare the forecast using MAD.
The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from t he carpet mill, customers will buy their carpet from one of Carpet's City's many competitors. The manager has collected the following demand data for the past 8 months:
Month Demand for Soft Shag Carpet (1,000 yd.)

1 8
2 12
3 7
4 9
5 15
6 11
7 10
8 12

A. Compute a 3-month moving average forecast for months 4 through 9(use excel)

B. Compute a weighted 3-month moving average forecast for months 4 through 9. Assign weights of .55, .33, and .12 to the months is sequence, starting with the most recent month.

C. Compare the two forecasts by using MAD. Which forecast appears to be more accurate?

Reference no: EM1316020

Questions Cloud

Find the source of funds for decision making : Find the source of funds for decision making - If interest rates were expected to increase, which plan would you recommend? Why?

Marshallia and hicksian demand functions : Use the utility function to answer the questions, below: (x1, x2) = exp (√(x 1 ) + √(x 2 )-Derive the Marshallian (ordinary) demand function for good1 and 2, x i *(p,l), i =1,2 . Then derive the indirect utility function (p,l).

Describe forecasting of net income using ebit-eps analysis : Describe Forecasting of net income using EBIT-EPS analysis and what will be the forecast for Robert's year-end net income

Assumptions of the capital asset pricing model : Consider a world where the assumptions of the Capital Asset Pricing Model hold. How are agency costs controlled in a "CAPM world?" and How can the financial markets reduce the total agency costs of the firm?

Compare the two forecasts by utilizing mad : Calculate a 3-month moving average forecast for months 4 through 9 also Compare the two forecasts by utilizing MAD. Which forecast appears to be more accurate.

Determining standard z-scores : Is the z value positive or negative? Explain why it should be positive or negative.

Capm and valuation of the company to be purchased : CAPM and Valuation of the company to be purchased - What is the expected rate of return for BigCo and What discount rate should BigCo use to evaluate ChemCo and why?

Application problems in linear equation : Application problems in linear equation

One-tailed or two-tailed test : Would you use a one-tailed or two-tailed test? Explain your response.

User Account

All Pages