Base Demand

Base demand is a calculated demand normalized from actual demand corrected for seasonal and period length variations. Actual demand is also corrected with any manual forecast adjustments. Non-representative demand is also excluded.

Description

Base demand is used in calculating base forecasts.

Base Demand Calculation

The following formula is used to calculate base demand.

D(i) = ((Dr(i) - M(i)) / (L(i) / (Ln * 12 / p)) / S(i)

Key:

D(i) = Base demand during period (i)
Dr(i) = Actual demand during period (i)
M(i) = Manual forecast adjustment for period (i)
L(i) = Number of workdays in period (i)
Ln = Average number of workdays per month
S(i) = Seasonal index for period (i)
i = Period number
p = Number of periods per year

Assume the following demand data for an item.

Actual demand Nov. 95 119
Manual forecast adjustment Nov. 95 10
Seasonal index Nov. 95 1.15
Number of workdays in Nov. 95 21
Average number of workdays per month 19
Number of periods per year 12

The following base demand is calculated for November 1995.

D(Nov.) = ((119 - 10) / (21 / (19 * 12 / 12)) / 1.15 = (109 / 1.10) / 1.15 = 86.2