BBampaa

Lessons › Demand Planning & Forecasting › Forecasting basics

Demand Planning & Forecasting lesson

Seasonal forecast

Next year's plan is 320 units in an average quarter. Multiply by each quarter's seasonal index.

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

The idea

Next year's plan is 320 units in an average quarter. Multiply by each quarter's seasonal index:

Formulas

Base × Index

Key points

Seasonal forecastBase forecast × Seasonal index.
Base forecastWhat an average quarter would sell.
CheckThe quarters still add up to 4 × 320 = 1,280.

Base × index is how planners spread a yearly forecast across the year.

Practice

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

1. In D5, work out Q4's seasonal forecast.
=B5*C5
2. What's the Q1 forecast?
320 × 0.667 = 213.3 units
3. Your dashboard needs one number at the top: next year's total forecast. Which visual?
Card

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