BBampaa

Lessons › Retail Supply Chain › Put it together

Retail Supply Chain lesson

Weekly inventory update

Stakeholders want three things: where we're short, where we're long, and what we'll do about it.

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

The idea

Stakeholders want three things: where we're short, where we're long, and what we'll do about it.

Key points

Risks firstWhich markets run out, and when.
Then the opportunitiesWhere excess can fix a shortage.
One clear actionA recommendation with a number and a date.

A replenishment analyst's job isn't the numbers. It's the inventory decision they lead to.

Practice

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

1. In I2, total the stock on hand across all markets. Each answer stays in the report as you go.
=SUM(B2:B6)
2. In I3, work out global weeks of supply: total on hand ÷ total weekly sales.
=I2/SUM(C2:C6)
3. In I4, work out the overall fill rate, as a decimal.
=SUM(F2:F6)/SUM(E2:E6)
4. In I5, work out Canada's reorder point: weekly sales × lead time.
=C4*D4
5. In I6, work out the US excess over 6 weeks: on hand − weekly sales × 6, never below 0.
=MAX(0,B3-C3*6)

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