Forecast the sales for each week

Assignment Help Business Management

Reference no: EM132075658

1. The following table shows the number of Blu-ray DVD players that Electronic Depot has sold during the past 12 weeks:

Week	Sales	Week	Sales
1	22	7	24
2	27	8	25
3	30	9	22
4	21	10	30
5	33	11	38
6	28	12	37

Develop 2-week, 3-week, and 4-week moving averages to forecast the sales for each week. What is the forecast for week 13 in each case?

2. Consider the data given in Problem 17 for Bluray DVD player sales at Electronic Depot.

(a) If Electronic Depot decides to forecast sales by using a three-period weighted moving average, what are the optimal weights that minimize MAPE? What would be the week 13 forecast using these weights?

(b) If Electronic Depot decides to forecast sales by using exponential smoothing, what is the optimal value of a that minimizes MAPE? What would be the week 13 forecast using this procedure?

Reference no: EM132075658

Questions Cloud

Modern extension of classical trade : 1. How would you analyze the statement that ‘‘international investment is simply a modern extension of classical trade''?

Develop a forecasting system : 1. Briefly describe the steps used to develop a forecasting system. 2. What is a time-series forecasting model?

Briefly describe the delphi technique : 1. What effect does the value of the smoothing constant have on the weight given to the past forecast and the past observed value?

Forecast the sales for each day : Develop two-day, three-day, and four-day moving averages to forecast the sales for each day. What is the forecast for day 11 in each case?

Forecast the sales for each week : Develop 2-week, 3-week, and 4-week moving averages to forecast the sales for each week. What is the forecast for week 13 in each case?

Discuss any issues impacting the business events sector : What benefits do business events bring to the visitor economy in both financial and non-financial terms? Discuss any issues impacting the business events.

How the documents would be utilized by a health care manager : To complete this Application Assignment, write a 2 page paper that provides a detailed explanation of each of the following four documents commonly found.

Describe the change in southwest airlines boarding process : Describe the change in Southwest Airlines boarding process. What was Southwest's main goal in introducing the early-bird check-in?

Which smoothing constant gives the most accurate forecast : The sales manager had predicted, before the business started, that year 1's sales would be 440 air conditioners.

User Account

All Pages