Compare the absolute deviation for forecasts

Assignment Help Operation Management

Reference no: EM131911768

Question: The famous Widget Company uses simple exponential smoothing to forecast the demand for its best-selling widgets. The company is considering whether it should use α = .1 or α = .3 for forecasting purposes. Use the following data for daily sales to arrive at a recommendation:

Develop an Excel spreadsheet to answer the following questions.

a. For the first seven days of data compare the absolute deviation for forecasts using α = .1 and α = .3. Start with A0 = 33. Which method is best?

b. Use the second week of data to make the same comparison. Use A7 = 32. Which method is best now?

c. What does this example illustrate?

Reference no: EM131911768

Questions Cloud

How many kanban containers are needed for situation : A company is in the business of machining parts that go through various work centers. Suppose work center A feeds work center B with parts.

The market for zithers is growing quickly : You have been hired as a consultant for Pristine Urban-Tech Zither, Inc. (PUTZ), manufacturers of fine zithers. The market for zithers is growing quickly.

Prepare a forecast of sales for each day : Prepare a forecast of sales for each day, starting with F1 = 85 and a = .2. Compute the MAD and the tracking signal in each period. Use MAD0 = 0.

What was market risk premium during ten years : The average annual T-bill yield during the same period was 6.60 percent. What was the market risk premium during these ten years?

Compare the absolute deviation for forecasts : For the first seven days of data compare the absolute deviation for forecasts using a = .1 and a = .3. Start with A0 = 33. Which method is best?

Compute the errors of bias and absolute deviation : Compute the errors of bias and absolute deviation for the forecasts. Which of the forecasting models is the best?

What is arbitrage profit per dollar used : What is the cross-rate in terms of yen per pound? What is the arbitrage profit per dollar used?

Indifferent between accepting the project and not accepting : At what level of pretax cost savings would you be indifferent between accepting the project and not accepting it?

Explain the purpose of standstill agreement : Explain the purpose of a standstill agreement and the basics of how it works. Find a recent example in the USA and use it in your discussion.

User Account

All Pages