Math Problem Statement

Using simple moving averages and the following time series data, respond to each of the items.

Period Demand 1 130 2 122 3 121 4 112 5 141 6 105 7 116 8 120 9 142 10 125 Compute all possible forecasts using a six-period simple moving average model. (Round your answers to 1 decimal place.) Compute the MAD. (Round your answer to 1 decimal place.) What is the forecast demand for period 11? (Round your answer to 1 decimal place.) What is the error associated with the eleventh-period forecast? (Round your answer to 1 decimal place.)

Solution

To address your request, I'll compute the forecasts using a six-period simple moving average (SMA) model. The forecast for each period will be the average demand of the preceding six periods. The Mean Absolute Deviation (MAD) will also be calculated, and finally, the forecast and associated error for the 11th period will be determined.

Step 1: Compute the forecasts using a six-period simple moving average

To calculate the forecast for a period, we'll use the average of the previous six periods' demand. Since we can't forecast for the first six periods, the first forecast will be for period 7.

Formula: SMAn=Dn1+Dn2+Dn3+Dn4+Dn5+Dn66\text{SMA}_n = \frac{D_{n-1} + D_{n-2} + D_{n-3} + D_{n-4} + D_{n-5} + D_{n-6}}{6}

Forecasts:

  • Forecast for period 7 = 130+122+121+112+141+1056\frac{130 + 122 + 121 + 112 + 141 + 105}{6}
  • Forecast for period 8 = 122+121+112+141+105+1166\frac{122 + 121 + 112 + 141 + 105 + 116}{6}
  • Forecast for period 9 = 121+112+141+105+116+1206\frac{121 + 112 + 141 + 105 + 116 + 120}{6}
  • Forecast for period 10 = 112+141+105+116+120+1426\frac{112 + 141 + 105 + 116 + 120 + 142}{6}

Let's compute these values first, and then move forward.Here are the forecasts for periods 7 through 10 using a six-period simple moving average model:

  • Forecast for period 7: 121.8
  • Forecast for period 8: 119.5
  • Forecast for period 9: 119.2
  • Forecast for period 10: 122.7

Step 2: Compute the Mean Absolute Deviation (MAD)

The MAD is calculated as the average of the absolute forecast errors (the absolute difference between the actual demand and forecasted demand).

The formula for MAD is: MAD=DiFin\text{MAD} = \frac{\sum |D_i - F_i|}{n} Where DiD_i is the actual demand and FiF_i is the forecast.

Let's now compute the MAD using the forecasts and actual demand for periods 7 through 10.The Mean Absolute Deviation (MAD) for the forecasts from periods 7 to 10 is 7.8.

Step 3: Forecast demand for period 11

To forecast the demand for period 11, we'll use the six-period simple moving average of the actual demands from periods 5 to 10.

Forecast for period 11=141+105+116+120+142+1256\text{Forecast for period 11} = \frac{141 + 105 + 116 + 120 + 142 + 125}{6}

Let me compute that forecast.The forecast demand for period 11, using the six-period simple moving average model, is 124.8.

Step 4: Compute the error associated with the 11th-period forecast

Since the actual demand for period 11 is not provided, the error cannot be computed at this time. However, the error would be calculated using the formula:

Error for period 11=D11F11\text{Error for period 11} = D_{11} - F_{11} Where D11D_{11} is the actual demand for period 11 (once available), and F11=124.8F_{11} = 124.8.

Would you like further clarification or more details? Here are some related questions you could explore:

  1. How would the forecast change if we used a different period for the moving average?
  2. What happens to MAD when there are outliers in the data?
  3. How does the simple moving average model compare to weighted moving averages?
  4. Can we apply exponential smoothing to forecast demand?
  5. What strategies can be used to reduce forecast errors?

Tip: The simple moving average model works best when demand is relatively stable and there are no strong trends or seasonal patterns.

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Time Series Analysis
Simple Moving Average
Mean Absolute Deviation (MAD)
Forecasting

Formulas

SMA_n = (D_{n-1} + D_{n-2} + D_{n-3} + D_{n-4} + D_{n-5} + D_{n-6}) / 6
MAD = (sum(|D_i - F_i|)) / n

Theorems

-

Suitable Grade Level

Grades 10-12