How to Calculate Weeks of Supply for Your Fragrance Line (And Why It Matters)

Weeks of Supply is a simple metric that most fragrance brands either track incorrectly or not at all. That matters more in fragrance than in most consumer goods categories, because production lead times are longer. Custom glass, specialty closures, fine fragrance components — when your lead time is 12 to 16 weeks and your sell-out data is three weeks stale, you are making replenishment decisions with less than half the information you need.

The Weeks of Supply Formula

• Current inventory: Units physically in a retail partner's location, available for sale — not what you shipped, what they have on hand.
• Average weekly sell-out rate: Units sold per week at that location over a recent four to eight week period — what consumers actually purchased, not what you shipped to that location.

A product with 140 units in a boutique selling 20 units per week has 7 weeks of supply. With a 14-week component lead time, that is the point at which you should already have a replenishment order in motion.

Why Most Brands Get This Wrong

The inventory problem: Most fragrance brands know what they shipped to each partner. Very few know what partners currently hold in inventory. Without accurate on-hand inventory data, you cannot calculate a reliable WOS.

The sell-out data problem: The denominator — weekly sell-out rate — requires current, accurate sell-out data. If your data is four weeks stale, a product selling 35 units per week now appears to be selling 20. Your WOS says 7 weeks. The actual number is 4. You are not ordering soon enough.

The aggregation problem: Most brands calculate WOS at the total inventory level. A 14-week aggregate WOS could mask one partner with 30 weeks of stock and three partners with 6 weeks each. Aggregate WOS does not tell you which specific locations need urgent attention.

Setting WOS Thresholds That Match Your Lead Times

WOS is only actionable when you have defined thresholds that trigger decisions:

• Green (safe): WOS greater than lead time + buffer (e.g., above 18 weeks for a 14-week lead time with a 4-week buffer)
• Amber (monitor): WOS between lead time and lead time + buffer — initiate sourcing conversations
• Red (urgent): WOS below lead time — a reorder is already overdue
• Critical: WOS below 4 weeks — stockout territory, look at emergency options

Travel Retail: The Special Case

At a major international airport, a fragrance can sell at 10x the velocity of a standalone boutique. Seasonal peaks — summer holidays, Chinese New Year, Christmas — can compress months of sales into weeks. For travel retail, most fragrance brands aim for a minimum of six to eight weeks of supply on hero SKUs at all times, with thresholds set tighter than in other channels.

What You Need to Make WOS Tracking Work

• Current sell-out data from each partner: Regular, automated collection — not monthly reporting cycles where data is already three weeks old when it arrives.
• SKU normalization: Your internal SKU codes mapped against each partner's naming conventions, so WOS calculations apply to the right products.
• Partner-level and store-level granularity: Aggregate WOS hides the distribution of risk across your network.

TaskifAI calculates WOS automatically from unified sell-out data — across every partner and SKU — and sends alerts when a product drops below your defined threshold. No manual calculation required.