Exam 11: Time Series Forecasting

Exhibit 11.4 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using the additive seasonal method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.4. What formula should be entered in cell E7 to compute the remaining expected levels?

Exhibit 11.5 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the multiplicative seasonal effects model. -Refer to Exhibit 11.5. What formula should be entered in cell G13 to compute the forecast for time period 11?

Exhibit 11.10 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using a quadratic trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.10. What is the Input X Range in the Regression command settings dialog box?

Exhibit 11.6 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4. -Refer to Exhibit 11.6. What formula should be entered in cell E6 (and copied to E7:E14) to compute the first average when using the double moving average method with k = 4?

Exhibit 11.21 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use Winter's method to forecast sales. -Refer to Exhibit 11.21. The store wishes to use Solver to find the optimal values for cell E6. Provide the following Analytic Solver Platform (ASP) settings. Objective Cell: ​ Variables Cells: ​ Constraints Cells:

Exhibit 11.8 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using Winter's method. The store has collected 12 quarters of data and needs your help to analyze the data. -Refer to Exhibit 11.8. What are predicted sales for the first quarter of year 4?

Assume that seasonality exists in the monthly product sales data. The number of seasonal indexes needed to model this is equal to

Exhibit 11.22 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use regression and a linear trend model. -Refer to Exhibit 11.22. Interpret the R² value for your model.

Seasonality is a regular, repeating pattern in the data that takes longer than 1 year to complete.

A time series which has no significant upward or downward trend is referred to as

Exhibit 11.19 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average method. -Refer to Exhibit 11.19. What formulas should go in cells E6:G14 of the spreadsheet if the double moving average method is used to forecast sales?

As the number of periods in the forecast, k, increases

Exhibit 11.14 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average. -Refer to Exhibit 11.14. What formulas should go into cells B15:B18 and cells C15:C18 of the spreadsheet if a 2-month moving average forecasting model is used?

Exhibit 11.14 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs help analyzing the data using a 2-month moving average. -Refer to Exhibit 11.14. What is the forecast for time periods 13-15?

Exhibit 11.1 The following questions use the data below. Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.1. If predicting the cars sold for time period 14, what formula must be placed in cell B16?

Exhibit 11.6 The following questions use the data below. A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4. -Refer to Exhibit 11.6. What formula should be entered in cell H9 to compute the trend using the double moving average model with k = 4?

Exhibit 11.13 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.13. What formulas should go in cells C3:C16 of the spreadsheet if Bill uses a 4 month moving average forecasting model?

Exhibit 11.11 The following questions use the data below. Joe's Sporting Goods wants to forecast quarterly sales figures using seasonal indices. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table. -Refer to Exhibit 11.11. What formula should be entered in cell G3 to compute the "Actual as a % of Trend" value for year 1 Quarter 1?

Exhibit 11.13 The following questions use the data below. The owner of Tim's Toys wants to predict monthly sales. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.13. What formulas go into cells B7:B9 of the following partial spreadsheet where data for periods 9-12 represent actual data?

Exhibit 11.1 The following questions use the data below. Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages. -Refer to Exhibit 11.1. What would be the forecasted values for time periods 13 and 14?