Compute their forecasting errors using mad and bias

Assignment Help Civil Engineering

Reference no: EM131408699

Consider the various forecasting methods in Exercise 2.6. Compute their forecasting errors using MAD and BIAS. Based on the forecast errors, which method would you recommend and why?

Exercise 2.6

The monthly sales data for the year 2011 for Datastream, Inc., which produces network routers for small companies, are given in Table 2.18. The sales manager wants a forecast of sales for the first quarter of year 2012 (months 13-15). Compute the forecasts using the following methods:

(a) Last value method

(b) Averaging method

(d) Exponential smoothing with α = 0.25

(e) Holt's method with α = 0.4 and β = 0.5

(f) Given the sales pattern for 2011, do any of these methods seem inappropriate for obtaining the forecasts? Is there another method you would recommend to get a better forecast for months 13, 14, and 15.

Reference no: EM131408699

Questions Cloud

Analyze economic theory used to complete the policy solution : Design an economic policy solution to the problem. Analyze the economic theory used to complete the policy solution and determine the impact on the appropriate stakeholders.

Create graphical representation of recommended architecture : Application Architecture:You have been tasked with building a payroll program for a large organization with offices spread across the United States. The company has one larger data center that each office connects to via a wide area network (WAN).

Calculate mad mse and bias for the two methods : Are the methods under-forecasting or over-forecasting? Which method would you recommend for forecasting future sales and why?

Geno-type of the mother : Assume the gene for freckles is dominate (F). A woman with freckles has a sone that does not. What would have be the geno-type of the mother?

Compute their forecasting errors using mad and bias : Consider the various forecasting methods in Exercise 2.6. Compute their forecasting errors using MAD and BIAS. Based on the forecast errors, which method would you recommend and why?

Which independent variables are statistically significant : Which independent variables are statistically significant? How do you know this? c) What is the marginal propensity to save (MPS)? Consume (MPC)?

Fermentation to make atp : What other hypotheses can you suggest concerning yeast's ability to use fermentation to make ATP?

Determine the forecast for month 13 : Show that the determination of the optimal weights can be formulated as an LP problem. Solve the linear program using any optimization software and determine the forecast for month 13.

Develop a strategy for periodically testing your inventory : Assume that you are employed by Sahara, Inc. Sahara Inc is an up-and-coming on-line reseller of books, video games, and small household appliances. Projections for 2016 sales are looking up, and expected to be in the $750,000,000 dollar range, wit..

User Account

All Pages