Weekly receipts from target weeks of supply (WOS)
A weekly receipts tape: at the end of each week the stock must cover the forecast sales of the next W weeks. Counts how much to receive each week allowing for stock and orders in transit, and when to order given the lead time.
At a glance
- What question does it answer?
- How much to receive each week and when to order for the end-of-week stock to cover the sales W weeks ahead.
- What data is needed?
- The sales forecast by week for 8–26 weeks.
- How to read the result?
- First the receipts that are already too late to order and the weeks with a shortage, then the sum of receipts and the minimum cover. Compare the tape with the OTB remainder. Example on the default values: Receipts for the period, units: 920; Receipts value at the purchase price: RUB 1.38 million; First week of receipt: 2; First order week (receipt minus lead time): 1. The figures are illustrative: enter your own to see your result.
Why and how to reason
A seasonal purchase total does not say which week to receive what. The tape from the target cover answers this: at the end of each week the stock must cover the forecast of the next W weeks. From the forecast, the stock and the orders in transit comes the receipt of the week, and subtracting the lead time gives the order week. In the example sales are 120–150 a week, W = 3, lead time 1 week, stock 450 and 100 in transit: receipts over eight weeks are 920 units, the first receipt is needed in week 2, so the order is due in week 1.
When to use it
Apply when turning the plan or the season reforecast into an order schedule, before each peak (11.11, Black Friday, 8 March, 1 September) and when the lead time changes. It does not replace the budget in roubles (OTB): that answers how much can be bought, this answers when and by week.
How to read the result
First the receipts that are already too late to order and the weeks with a shortage; then the minimum cover and the sum of receipts. The stock at the end of the tape is money in stock.
Common mistakes
One W for the whole year, orders in transit not subtracted, cover counted from past sales, the lead time forgotten and the order “late” from the first week.
What data is needed?
- The sales forecast by week for 8–26 weeks.
- Stock and orders in transit by week of receipt.
- Lead time, purchase price, pack and minimum batch.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Target weeks of supply | wk | 3 | For how many weeks ahead the end-of-week stock must cover the sales forecast. A whole number. Take it higher in peak weeks and lower outside them: one W for the whole year is a mistake. The example value is illustrative. |
| Lead time, weeks | wk | 1 | From placing the order to receipt at the warehouse, including production, transport, customs and documents. A whole number. Take a separate lead time for imports. The example value is illustrative. |
| Stock at the start of the first week, units | pcs | 450 | Available stock in the warehouse and stores that can be sold. The example value is illustrative. |
| Purchase price per unit | ₽ | 1,500 | Excl. VAT, at warehouse cost. Empty counts as zero: order sums will not be shown. The example value is illustrative. |
| Minimum delivery batch, units | pcs | 0 | If the needed receipt is below the batch, the batch is received. 0 means no minimum. The example value is illustrative. |
| Pack multiple, units | pcs | 1 | The receipt is rounded up to a whole number of packs. 1 means no rounding. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Target at the week end | T(t) = the sum of the sales forecast of weeks t+1 … t+3; beyond the horizon the average of the last three weeks |
| Stock before receipt | E(t) = opening stock + receipt in transit − week sales |
| Needed receipt | R(t) = max(0; T(t) − E(t)), then up to the pack and not below the minimum batch |
| Stock for the next week | Stock(t+1) = E(t) + R(t) |
| Order week and value | order week = receipt week − 1; value = R × 1,500 ₽ |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Receipts for the period, units
- 920The sum of weekly receipts allowing for the pack and the minimum batch.
- Receipts value at the purchase price
- 1.38 m ₽
- First week of receipt
- 2
- First order week (receipt minus lead time)
- 1
- Receipts that are already too late to order, units
- 0
- Minimum cover before the receipt, weeks
- 2week 6.
- Weeks with a shortage before receipt
- 0
- Stock at the end of the tape, units
- 390
- Forecast sales for the period, units
- 1,080
- Stock before receipt
- End stock
- Target at week end
Data as a table
| Measure | Stock before receipt | End stock | Target at week end |
|---|---|---|---|
| 1 | 430 | 430 | 420 |
| 2 | 300 | 440 | 440 |
| 3 | 300 | 440 | 440 |
| 4 | 290 | 420 | 420 |
| 5 | 270 | 390 | 390 |
| 6 | 250 | 380 | 380 |
| 7 | 250 | 380 | 380 |
| 8 | 260 | 390 | 390 |
Data as a table
| Measure | Receipt |
|---|---|
| 1 | 0 |
| 2 | 140 |
| 3 | 140 |
| 4 | 130 |
| 5 | 120 |
| 6 | 130 |
| 7 | 130 |
| 8 | 130 |
The tape by week
| Week | Forecast | In transit | Stock before receipt | End target | Receipt | End stock | Order week | Order value |
|---|---|---|---|---|---|---|---|---|
| 1 | 120 | 100 | 430 | 420 | 0 | 430 | — | — |
| 2 | 130 | 0 | 300 | 440 | 140 | 440 | 1 | 210,000 ₽ |
| 3 | 140 | 0 | 300 | 440 | 140 | 440 | 2 | 210,000 ₽ |
| 4 | 150 | 0 | 290 | 420 | 130 | 420 | 3 | 195,000 ₽ |
| 5 | 150 | 0 | 270 | 390 | 120 | 390 | 4 | 180,000 ₽ |
| 6 | 140 | 0 | 250 | 380 | 130 | 380 | 5 | 195,000 ₽ |
| 7 | 130 | 0 | 250 | 380 | 130 | 380 | 6 | 195,000 ₽ |
| 8 | 120 | 0 | 260 | 390 | 130 | 390 | 7 | 195,000 ₽ |
Beyond the horizon demand is taken equal to the average of the last three weeks: 130 units. The tape does not see a peak or a drop beyond the horizon.
What to do with the result: give buying the order week and the volume; compare the sum with the open-to-buy remainder, and count the excess stock at the end of the tape as money in stock (holding cost in carrycost).
A typical mistake: taking one W for the whole year, not subtracting orders in transit, counting cover from past sales and forgetting the lead time.
Nuances and limits
- One target W for the whole year.
- Not subtracting orders in transit.
- Counting cover from past sales instead of the forecast.