All Exams Test series for 1 year @ ₹349 only
Question

The actual demand for castings in a factory is 500 units and 635 units for the months of January 2026 and February 2026, respectively. The forecasted demand for January 2026 is 250 units and smoothing constant is 0.7. Using the exponential smoothing method, the forecast of the demand for castings in March 2026 is________ units (in integer).

Exponential Smoothing Calculation

The forecast for the next period ($F_{t+1}$) using exponential smoothing is calculated based on the previous forecast ($F_t$) and the actual demand of the current period ($A_t$). The formula is:

$ F_{t+1} = \alpha A_t + (1-\alpha) F_t $

Where $A_t$ is the actual demand for period $t$, $F_t$ is the forecast for period $t$, and $\alpha$ is the smoothing constant.

Forecast for February 2026

We are given:

  • Actual demand for January ($A_1$): 500 units
  • Forecast for January ($F_1$): 250 units
  • Smoothing constant ($\alpha$): 0.7

First, calculate the forecast for February ($F_2$) using the January data:

$ F_2 = \alpha A_1 + (1-\alpha) F_1 $ $ F_2 = (0.7 \times 500) + (1 - 0.7) \times 250 $ $ F_2 = (350) + (0.3 \times 250) $ $ F_2 = 350 + 75 $ $ F_2 = 425 \text{ units} $

Forecast for March 2026

Now, calculate the forecast for March ($F_3$) using the February data:

  • Actual demand for February ($A_2$): 635 units
  • Forecast for February ($F_2$): 425 units (calculated above)
  • Smoothing constant ($\alpha$): 0.7

Using the exponential smoothing formula:

$ F_3 = \alpha A_2 + (1-\alpha) F_2 $ $ F_3 = (0.7 \times 635) + (1 - 0.7) \times 425 $ $ F_3 = (444.5) + (0.3 \times 425) $ $ F_3 = 444.5 + 127.5 $ $ F_3 = 572 \text{ units} $

The forecast demand for March 2026 is 572 units.

Was this answer helpful?

Important Questions from Forecasting

  1. The correlation coefficient between two variables X and Y is found to be 0.6. All the observations on X and Y are transformed using the transformations U = 2 – 3X and V = 4Y + 1. The correlation coefficient between the transformed variables U and V will be

  2. Which of the following lines is known as the trend line?

  3. An XYZ television supplier found a demand of 200 sets in July, 225 sets in August and 245 sets in September. Find the demand forecast for the month for the month of October using simple average method.

  4. Name the human resource demand (need) forecasting technique, which solicits estimates of personnel needs from a group of experts, usually managers. The HRP experts act as intermediaries, summarise the various responses and report the findings back to the experts. The experts are surveyed again after they receive this feedback. Summaries and surveys are repeated until the experts' opinions begin to agree. The agreement reached is the forecast of the personnel needs.

    Select the correct option :

  5. Which of the following is a technique used for forecasting?

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App