BBampaa

Lessons › Retail Supply Chain › Distribution and launches

Retail Supply Chain lesson

DC to store deployment

One UK region: a distribution centre (DC) holding 300 units, and four stores. Each store should reach 4 weeks of cover.

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

The idea

One UK region: a distribution centre (DC) holding 300 units, and four stores. Each store should reach 4 weeks of cover:

Formulas

Weekly sales × 4 − On hand

Key points

Store needWeekly sales × 4 − On hand. Below zero means none needed.
DC coverDC stock ÷ the stores' total weekly sales: here, 300 ÷ 150 = 2 weeks.
Deploy by needFill the stores closest to running out first.

Deployment decides where stock goes for the last mile, from the DC to the store.

Practice

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

1. How many units does London need to reach 4 weeks of cover?
60 × 4 − 90 = 150 units
2. In D2, work out what London needs for 4 weeks of cover: weekly sales × 4 − on hand, and never below 0.
=MAX(0,B2*4-C2)
3. Tap the store that needs nothing from the DC.
Manchester already has 5 weeks of cover.
4. The DC has 300 units. After sending every store what it needs, how many stay in the DC?
150 + 0 + 90 + 30 = 270 needed, so 300 − 270 = 30 stay

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