How To Calculate Weeks of Supply For Seasonal And Promotional Inventory

Weeks of Supply The estimated number of weeks current inventory will last based on expected demand. Seasonal peaks and promotions distort simple historical averages; calculating Weeks of Supply for these cases requires demand normalization, forward‑looking forecasts, and alignment with campaign timing.

When preparing for a season or sale, planners must move beyond trailing average demand and model expected uplift. That preserves service levels, prevents overstocks after the event, and reduces expedited freight costs.

Step‑By‑Step Calculation For Seasonal SKUs

• Step 1 — Establish baseline weekly demand: Use a rolling average excluding prior anomalous promotions, or use 52‑week seasonally smoothed weekly demand.
• Step 2 — Apply seasonal uplift: Estimate percent uplift for each promotional week (from past campaigns or forecast models) and add to baseline.
• Step 3 — Include safety and lead time: Convert desired service level into safety stock in weeks or units, and incorporate supplier lead time expressed in weeks.
• Step 4 — Compute Weeks of Supply: Weeks of Supply = Current On‑Hand ÷ Forecasted Weekly Demand (use the adjusted weekly demand for the upcoming period).

Example: Holiday Promotion

A merchant expects a 300% spike during a 2‑week holiday sale. Baseline weekly demand is 100 units. Forecasted weekly demand during promotion = 100 × (1 + 3.0) = 400 units/week. If on‑hand is 1,200 units, Weeks of Supply during the promotion = 1,200 ÷ 400 = 3 weeks. Because the campaign runs two weeks and lead time is 4 weeks, procurement must place an order immediately to avoid stockout after the promotion ends.

Adjusting For Post‑Promotion Drop

Promotions often leave a post‑event lull. Avoid maintaining elevated Weeks of Supply after the event by calculating expected post‑promotion demand and setting inventory targets that return coverage to normal levels within a defined period. Consider buyback agreements or return windows with suppliers for seasonal overhangs.

Data Sources And Forecasting Methods

• Historical campaign data: Use prior promotion lift percentages by channel and geography whenever possible.
• Point‑of‑sale and e‑commerce signals: Monitor real‑time sell‑through to update Weeks of Supply during campaigns.
• Statistical forecasting: Use simple exponential smoothing with seasonal indices or a causal model if promotional drivers (ads, price cuts) are known.
• Collaboration: Share forecasts with suppliers and carriers to synchronize lead times and expedite when necessary.

Operational Safeguards

• Stagger receipts: For long lead times, schedule multiple receipts before and during the promotion to smooth inbound workload.
• Emergency buffer: Hold a small tactical reserve for high‑value SKUs where stockouts cause significant lost margin.
• Real‑time monitoring: Use WMS or ERP dashboards to alert when Weeks of Supply drops below the planned threshold during the event.
• Post‑event assessment: Compare forecasted vs. actual weeks of supply and adjust uplift assumptions for next season.

Common Pitfalls

• Using trailing demand only: Underestimates required coverage during spikes.
• Ignoring channel differences: A SKU may sell faster online than in stores; compute Weeks of Supply per fulfillment channel if necessary.
• Not aligning with lead time: Failing to compare Weeks of Supply to supplier lead time causes avoidable expedited costs.

In short, the Weeks of Supply for seasonal and promotional inventory must be calculated using adjusted weekly demand that reflects forecasted uplift, safety stock, and lead time. Accurate inputs, real‑time monitoring, and coordination with procurement and carriers turn Weeks of Supply from a static snapshot into an actionable planning tool.