BBampaa

Lessons › Retail Supply Chain › Weeks of supply

Retail Supply Chain lesson

Weeks of supply across markets

Weeks of supply (WOS) divides stock on hand by weekly sales. One product, five markets.

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

The idea

Weeks of supply (WOS) divides stock on hand by weekly sales. One product, five markets:

Formulas

On hand ÷ Weekly sales

Key points

Weeks of supplyOn hand ÷ Weekly sales. Also called weeks of cover.
Global WOSTotal stock ÷ total weekly sales, across every market.
Not an averageAveraging each market's WOS gives small markets too much weight.

Replenishment analysts check WOS every week to spot shortages and excess early.

Practice

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

1. How many weeks of supply does Canada have?
300 ÷ 150 = 2 weeks
2. In D4, work out Canada's weeks of supply: on hand ÷ weekly sales.
=B4/C4
3. Tap the market holding the most weeks of supply.
Germany, with 9 weeks of supply.
4. What's the global WOS across all five markets?
4,900 ÷ 925 = 5.3 weeks

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