BBampaa

Lessons › Retail & Allocation › Allocation and merchandising

Retail & Allocation lesson

Weeks of cover (Weeks of Supply)

Weeks of cover divides the stock on hand by how fast it sells.

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

The idea

Weeks of cover divides the stock on hand by how fast it sells:

Formulas

Stock ÷ Rate

Key points

Weekly rateAverage units sold per week, usually over the last 4 weeks.
Weeks of coverStock on hand ÷ Weekly rate. Many companies call it Weeks of Supply (WOS).
Target coverOften 3 to 6 weeks, depending on the product.

Units needed = Weekly rate × Target weeks − Stock on hand.

Practice

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

1. How many weeks of cover does Vancouver have?
150 ÷ 25 = 6 weeks
2. In D3, work out Vancouver's weeks of cover: stock ÷ weekly sales.
=C3/B3
3. Tap the store that will run out first.
Montreal has just 1 week of cover.
4. How many more units does Toronto need to reach 4 weeks of cover?
40 × 4 = 160 needed, minus 80 on hand = 80 units

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