Syntha Lab RU

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.

Buying budget and cash For whom: Buyers and planners who turn a sales forecast into a weekly receipts schedule and order dates.

Calculate on your data →

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

FieldUnitValue in the exampleMeaning
Target weeks of supplywk3For 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, weekswk1From 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, unitspcs450Available stock in the warehouse and stores that can be sold. The example value is illustrative.
Purchase price per unit₽1,500Excl. VAT, at warehouse cost. Empty counts as zero: order sums will not be shown. The example value is illustrative.
Minimum delivery batch, unitspcs0If the needed receipt is below the batch, the batch is received. 0 means no minimum. The example value is illustrative.
Pack multiple, unitspcs1The receipt is rounded up to a whole number of packs. 1 means no rounding. The example value is illustrative.

How it is calculated

StepFormula
Target at the week endT(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 receiptE(t) = opening stock + receipt in transit − week sales
Needed receiptR(t) = max(0; T(t) − E(t)), then up to the pack and not below the minimum batch
Stock for the next weekStock(t+1) = E(t) + R(t)
Order week and valueorder 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 and target by week, units
Line chart: Stock before receipt: 430 → 260; End stock: 430 → 390; Target at week end: 420 → 39025030035040045012345678Stock before receipt, 1: 430Stock before receipt, 2: 300Stock before receipt, 3: 300Stock before receipt, 4: 290Stock before receipt, 5: 270Stock before receipt, 6: 250Stock before receipt, 7: 250Stock before receipt, 8: 260End stock, 1: 430End stock, 2: 440End stock, 3: 440End stock, 4: 420End stock, 5: 390End stock, 6: 380End stock, 7: 380End stock, 8: 390Target at week end, 1: 420Target at week end, 2: 440Target at week end, 3: 440Target at week end, 4: 420Target at week end, 5: 390Target at week end, 6: 380Target at week end, 7: 380Target at week end, 8: 390
  • Stock before receipt
  • End stock
  • Target at week end
Data as a table
MeasureStock before receiptEnd stockTarget at week end
1430430420
2300440440
3300440440
4290420420
5270390390
6250380380
7250380380
8260390390
Receipts by week, units
Bar chart: 1 0, 2 140, 3 140, 4 130, 5 120, 6 13005010015011Receipt: 0022Receipt: 14014033Receipt: 14014044Receipt: 13013055Receipt: 12012066Receipt: 13013077Receipt: 13013088Receipt: 130130
Data as a table
MeasureReceipt
10
2140
3140
4130
5120
6130
7130
8130

The tape by week

WeekForecastIn transitStock before receiptEnd targetReceiptEnd stockOrder weekOrder value
11201004304200430——
213003004401404401210,000 ₽
314003004401404402210,000 ₽
415002904201304203195,000 ₽
515002703901203904180,000 ₽
614002503801303805195,000 ₽
713002503801303806195,000 ₽
812002603901303907195,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.

Terms used

Calculate on your data →