Seasonal Demand Planning: A Practical Approach

Seasonal demand planning, a core part of demand planning and inventory optimization, is the practice of forecasting the regular rise and fall of demand through the year and building supply, inventory and cash plans to match it. Almost every consumer business has some seasonality, from the holiday peak in gifts to the summer peak in beverages, the back-to-school spike in stationery or the winter surge in heating products. The pattern is predictable in shape, but the size of the peak, its timing and the weather or events that move it are not. A good seasonal plan builds from a clear seasonal index, decides how to supply the peak (build ahead, chase with capacity, or mix), and manages the entry and exit so that stock does not linger after the season. This guide shows how to calculate seasonal indices with a checked example, how to compare level and chase supply strategies including the carrying cost, how to plan the build and the exit, and what to do when the season behaves unexpectedly. It follows specialty retail inventory planning and pharma and healthcare products, and leads to promotion forecasting and demand planning for CPG companies. Related finance topics are in seasonality in financial forecasting and cash flow management.

Calculating a seasonal index

A seasonal index shows how much higher or lower a period is than the average period. A value of 1.00 is average, 1.60 means 60 percent above average, and 0.60 means 40 percent below. To calculate it, take several years of history, preferably at least three, calculate the average for each period (month, quarter or week) and divide by the overall average per period.

Suppose average quarterly sales over three years were 120 in Q1, 150 in Q2, 90 in Q3 and 240 in Q4, in thousands of units (illustrative). The overall average per quarter is (120 + 150 + 90 + 240) / 4 = 600 / 4 = 150. The indices are 120 / 150 = 0.80, 150 / 150 = 1.00, 90 / 150 = 0.60 and 240 / 150 = 1.60. Check: the indices sum to 0.80 + 1.00 + 0.60 + 1.60 = 4.00, which is the number of periods, as it should. To use them, forecast the annual total from the trend and any known changes, divide by four for the average quarter, and multiply by each index. If next year's annual forecast is 650 thousand, the average quarter is 162.5, and the quarterly forecasts are 0.80 × 162.5 = 130, 1.00 × 162.5 = 162.5, 0.60 × 162.5 = 97.5 and 1.60 × 162.5 = 260. Check: 130 + 162.5 + 97.5 + 260 = 650.

In practice, use monthly or weekly indices for planning, because quarters hide the shape of the peak. Where history is short, use analogs or category data. Remove the effect of unusual events from the history, such as a stockout that depressed a peak month or a one-off promotion that inflated it. Update indices regularly, because patterns shift as channels, products and customers change. See seasonality.

Level or chase

Once the seasonal demand is known, the supply strategy has to be chosen. In a chase strategy, production or purchasing follows demand, which keeps inventory low but requires capacity or supplier flexibility to meet the peak. In a level strategy, production runs at a steady rate and inventory is built ahead of the peak, which uses capacity evenly but carries stock. Most businesses use a mix.

Use the quarterly forecast above, in thousands of units. A level plan produces 162.5 each quarter. Opening inventory is zero. In Q1, production of 162.5 less demand of 130 builds 32.5. In Q2, production equals demand, so inventory stays at 32.5. In Q3, production of 162.5 less demand of 97.5 adds 65, so inventory is 97.5. In Q4, production of 162.5 less demand of 260 draws down 97.5, leaving zero. Check: total production is 4 × 162.5 = 650, equal to total demand. Quarter-end inventory is 32.5, 32.5, 97.5 and 0, with an average of (32.5 + 32.5 + 97.5 + 0) / 4 = 40.6 thousand units. At a unit cost of $10 and a carrying cost of 18 percent, the average inventory is $406,250 and the annual carrying cost is about 406,250 × 0.18 = $73,125. Check: 40,625 units × $10 = 406,250. The chase plan carries almost no inventory but needs capacity of 260 in Q4, 60 percent above the average of 162.5, and the cost of that extra capacity, whether in overtime, temporary labor or premium supplier terms, must be compared with $73,125 a year. If the premium for peak capacity is lower than that, chase is cheaper; if higher, level wins. The answer depends on the product's shelf life too. A product that spoils or goes out of fashion cannot be built ahead for long.

Plan the build

A seasonal build needs a calendar of commitments. Work backward from the peak: the date by which stock must be on the shelf, the shipping time, the production time, the date for raw material orders and the date at which the quantity must be committed. List the commitment dates for each product and supplier and track them. Decide how much to commit at each date, using the principle of committing the likely base early and keeping a flexible portion for later. The build also needs space, labor and cash, so plan warehouse capacity and funding in advance. See how inventory decisions affect cash flow.

Plan the exit

The end of the season is where profit is lost. Plan the exit when planning the entry: expected sell-through by week, the point at which markdowns begin, the depth, the channels for clearance and the treatment of leftover stock. Set a target for the amount of stock left at the end, and track against it from the middle of the season. For products that can be carried over, decide which and how much. For those that cannot, make sure the clearance plan is funded and staffed. See markdown planning and inventory write-downs.

Reading the season as it unfolds

Compare actual sales with the seasonal forecast weekly during the peak. Distinguish between a shift in timing and a change in volume. If sales in the first half of the season are ahead of plan, is the whole season higher, or has demand simply come earlier? Use cumulative curves and the early read to adjust. Weather, news, competitor actions and the economy can all move the season. Prepare scenarios in advance, such as a mild, normal and strong season, and decide what actions each triggers. Keep a flexible reserve to respond where lead times allow.

Seasonality across the portfolio

Products and customers have different seasonal shapes. A single company-wide index hides these differences. Build indices by category and, where it matters, by channel and region. Aggregate for financial planning and keep the detail for operations. Pay attention to products whose seasons are shifting, such as those affected by climate or by changes in retail calendars. Also watch for promotional seasons that are created by the company itself, such as sales events, which can create an artificial peak.

Working with suppliers and customers

Suppliers can help with seasonal flexibility if they know what is coming. Share the seasonal forecast early, agree capacity reservations and ask for options to adjust quantities close to the season. Customers can share their own plans, such as retail calendars, store resets and promotional programs. A shared calendar of commitments and events across planning, sales, marketing and finance prevents surprises. See cash flow management.

Common mistakes

Using a single year of history produces unreliable indices. Failing to adjust history for stockouts or promotions distorts the pattern. Building the whole peak early removes flexibility. Ignoring the exit plan leaves leftover stock to be cleared in a panic. Treating timing shifts as volume changes leads to wrong reactions. Applying company-wide indices to categories with different seasons creates mismatches between supply and demand.

FAQs

What is a seasonal index?

The ratio of a period's average demand to the overall average period. A value of 1.60 means 60 percent above average.

How many years of data do I need?

At least three where possible. With less, use analogs or category data and update the indices as data accumulates.

What is the difference between level and chase supply?

Level supply produces at a steady rate and builds inventory ahead of the peak. Chase supply follows demand and needs flexible capacity.

How do I plan the end of the season?

Set sell-through targets, markdown timing and channels for clearance when planning the entry, and track weekly from mid-season.

How can I tell if a season is early or just stronger?

Look at cumulative sales against the plan curve and compare the shape across years. A shift in timing shows as ahead early and behind later.