BBampaa

Lessons › Demand Planning & Forecasting › Events and promotions

Demand Planning & Forecasting lesson

Event stock

Forecast the event week (baseline × (1 + uplift)), then compare with the stock you already have.

Try this lesson free →
About 5–10 minutes · no sign-up needed

The idea

Forecast the event week (baseline × (1 + uplift)), then compare with the stock you already have:

Formulas

Baseline × ( 1 + Uplift )

Key points

Event forecastBaseline × (1 + Uplift).
To orderEvent forecast − On hand, and never below zero.
Order earlyEvent stock has to land before the event, so lead time matters.

Event stock planning is the same forecast and gap, done weeks ahead.

Practice

Try each one in your head first, then open the answer.

1. What's the event forecast for the Fast charger?
360 × (1 + 0.5) = 540 units
2. In D3, work out how many Earbuds Lite to order. Never order a negative amount: use MAX(0, event forecast − on hand).
=MAX(0,B3-C3)
3. Tap a product you need to order more of.
Three products need more stock. Only Earbuds Lite is covered.

Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.

Try this lesson free →
About 5–10 minutes · no sign-up needed