The following table provides sales data for 5 years. a. Forecast sales for 2017

Question

The following table provides sales data for 5 years. a. Forecast sales for 2017 using the naive method. ______ b. Forecast sales for 2017 using a 2-year moving average method. ______ c. Suppose sales had been forecast to be 20 in each of the 5 years. Calculate the MAD ______ Quarterly sales data for a company was collected over a three year period. There was both trend and seasonality present in the sales data, so the decomposition method was used to develop a forecasting model. Using the data from these 12 quarters (time periods 1, 2, 3, ...., 11, 12) the following was found: Calculate the forecast (including both the trend and the seasonal component) for quarter 3 of year 4. ______

Explanation / Answer

From trend component,

For X = 3,

Y = 30 + 10(3) = 60

Including seasonal component,

The forecast for quarter 3 = 60(1.2) = 72

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.