Syntha Lab RU

Ship from store or from the warehouse: order cost and the value of the saved stock

Compares picking and shipping an online order from a store and from the warehouse: costs, cancellations and reassignment. Adds the benefit: sales that would otherwise be lost for lack of goods at the warehouse and discounts avoided. Shows the gain per order and per month and the share of saved sales needed.

Omnichannel: click and collect and ship from store For whom: Omnichannel and logistics directors.

Calculate on your data →

At a glance

What question does it answer?
When picking an online order in a store beats the warehouse.
What data is needed?
Order cost from the warehouse and from a store, cancellations and reassignment.
How to read the result?
From a store an order costs 459.6, from the warehouse 390: an extra 69.6. Saved sales give 303.75, avoided discounts 56.25: a net of 290.4 per order and 348,480 a month. Saving 0.66% of orders is enough. Example on the default values: From the store: cost per order: RUB 459.6; From the warehouse: cost per order: RUB 390; Extra cost from the store: RUB 69.6; Value of saved sales per order: RUB 303.75. The figures are illustrative: enter your own to see your result.

Why and how to reason

A store can ship online orders when goods are not in the warehouse: stock works and sales are not lost. But picking in a store is dearer and riskier, so it must be compared. From store = minutes ÷ 60 × hourly cost + materials + delivery + cancellations × reassignment = 14 ÷ 60 × 450 + 25 + 320 + 8% × 120 = 459.6. From warehouse 160 + 230 = 390. A premium of 69.6 per order. What the store gives: saved sales (without it the order would be lost) = lost share × order margin = 15% × 2,025 = 303.75 and avoided discounts: part of store stock would have gone to a sale and now sells at a higher price = 5% × 25% × 4,500 = 56.25. Result per order = 303.75 + 56.25 − 69.6 = 290.4, per month at 1,200 orders 348,480. The share of saved sales needed to pay is only 0.66%.

When to use it

It comes in handy when launching shipping from stores, choosing participating stores and revising rules. It suits a retailer and a brand with omnichannel. It does not suit stores with small stock and weak records: cancellations will outweigh the benefit. Assumptions: the share of lost orders and the discounts avoided are your estimates; picking and delivery costs are constant; the store does not lose its own sales to reservation.

How to read the result

Look at “result per order” and “needed share of saved sales”: if your estimate of the share of saved orders is well above the threshold the scheme pays with a margin. Compare the cost premium with order margin: if above 5–10%, limit the scheme to scarce goods only. Watch cancellations: if more than 10% the store’s record accuracy is weak and the benefit falls. The store loses its own sales while an employee picks an order and reserved goods cannot be sold on the floor: if this matters add its price to reassignment. The decision: which stores and goods to connect.

Common mistakes

Counting the benefit of saved sales without checking: some customers would have waited for the warehouse. Not accounting for cancellations and reassignment. Connecting stores with inaccurate stock records. Forgetting that part of the benefit comes at the expense of another channel: the store loses a floor sale. Another trap: connecting all stores indiscriminately. Start with those where stock records are accurate and cancellations few, and expand on results.

What data is needed?

  • Order cost from the warehouse and from a store, cancellations and reassignment.
  • Share of orders that would otherwise be lost and of discounts avoided.

Inputs

FieldUnitValue in the exampleMeaning
Orders that can be picked from a store a monthorders1,200Only those where the goods are in a store.
Average order excl. VAT₽4,500Excl. VAT (if you pay VAT and deduct it). Confirm your regime and rate with an accountant.
Gross margin%45The gross margin in the ticket excl. VAT in percent: the order’s contribution when shipping from a store or the warehouse is counted from it.
Picking and packing at the warehouse₽160Per order: see “Own warehouse or 3PL”. An example: enter your own data, there is no single standard in Russia.
Delivery from the warehouse₽230Net delivery cost. An example: enter your own data, there is no single standard in Russia.
Picking time in the storemin14Finding the goods, taking them off display, packing. An example: enter your own data, there is no single standard in Russia.
Cost of a staff hour₽450The cost of an employee hour with contributions in roubles: from store payroll; the picking work is counted from it.
Packing materials₽25Packaging materials per order in roubles: box, tape, filler; from purchase prices.
Delivery from the store₽320Net delivery cost; usually above the warehouse because of pick-ups at many points. An example: enter your own data, there is no single standard in Russia.
Cancellations from the store%8Share of orders where the goods were not in the store (inaccurate records), a defect or a try-on. An example: enter your own data, there is no single standard in Russia.
Cost of reassigning a canceled order₽120Time and the delay of the order until the new picking. An example: enter your own data, there is no single standard in Russia.
Share of orders that would be lost without the store%15The warehouse has no goods: the customer would leave. An estimate from refusals; replace with yours. An example: enter your own data, there is no single standard in Russia.
Share of orders with stock that would go to a discount%5The goods sit in the store and would otherwise go to a sale. An example: enter your own data, there is no single standard in Russia.
Discount avoided%25Of the price excl. VAT. An example: enter your own data, there is no single standard in Russia.

How it is calculated

StepFormula
From the storeminutes ÷ 60 × hourly cost + materials + delivery + cancellations × reassignment
Benefitlost share × order margin + discount share × avoided discount × basket
Resultbenefit − (from store − from warehouse)

Worked numbers

Default values from the app; in the interactive version you enter your own.

From the store: cost per order
459.6 ₽
From the warehouse: cost per order
390 ₽
Extra cost from the store
69.6 ₽
Value of saved sales per order
303.75 ₽Share of lost orders × order margin.
Value of avoided discounts per order
56.25 ₽
Net result per order
290.4 ₽
Net result for the month
348,480 ₽
Share of saved sales needed
0.7 %The minimum share at which the extra cost pays back; 0 if avoided discounts suffice.

One order: store and warehouse

ItemStoreWarehouse
Picking and packing130 ₽160 ₽
Delivery320 ₽230 ₽
Cancellations and reassignment9.6 ₽—
Saved sales and discounts−360 ₽—

The store loses its own sales while an employee picks an online order, and the item reserved for an order cannot be sold to a walk-in customer. If this matters to you, add its cost to the reassignment cost or to the picking time.

Nuances and limits

  • Cancellations from a store reveal inaccurate records: reconcile stock.
  • The probabilities of the benefits are set by the user.

Terms used

Calculate on your data →