# Question

The file S12_75.xlsx contains five years of monthly data for a particular company. The first variable is Time (1 to 60). The second variable, Sales1, contains data on sales of a product. Note that Sales1 increases linearly throughout the period, with only a minor amount of noise. (The third variable, Sales2, is discussed and used in the next problem.) For this problem use the Sales1 variable to see how the following forecasting methods are able to track a linear trend.

a. Forecast this series with the moving average method with various spans such as 3, 6, and 12. What can you conclude?

b. Forecast this series with simple exponential smoothing with various smoothing constants such as 0.1, 0.3, 0.5, and 0.7. What can you conclude?

c. Now repeat part b with Holt’s exponential smoothing method, again for various smoothing constants. Can you do significantly better than in parts a and b?

d. What can you conclude from your findings in parts a, b, and c about forecasting this type of series?

a. Forecast this series with the moving average method with various spans such as 3, 6, and 12. What can you conclude?

b. Forecast this series with simple exponential smoothing with various smoothing constants such as 0.1, 0.3, 0.5, and 0.7. What can you conclude?

c. Now repeat part b with Holt’s exponential smoothing method, again for various smoothing constants. Can you do significantly better than in parts a and b?

d. What can you conclude from your findings in parts a, b, and c about forecasting this type of series?

## Answer to relevant Questions

The Sales2 variable in the file from the previous problem was created from the Sales1 variable by multiplying by monthly seasonal factors. Basically, the summer months are high and the winter months are low. This might ...Other sensitivity analyses besides those discussed could be performed on the product mix model. Use Solver Table to perform each of the following. In each case keep track of the values in the changing cells and the objective ...Again continuing problem 2, perform a sensitivity analysis where the selling prices of Basics and XPs simultaneously change by the same percentage, but the selling price of VXPs remains at its original value. Let the ...Some analysts complain that spreadsheet models are difficult to resize. You can be the judge of this. Suppose the current product mix problem is changed so that there is an extra resource, packaging labor hours, and two ...A chemical company manufactures three chemicals: A, B, and C. These chemicals are produced via two production processes: 1 and 2. Running process 1 for an hour costs $400 and yields 300 units of A, 100 units of B, and 100 ...Post your question

0