Split shipments: the cost of several parcels versus consolidation
Shows what it costs to ship an order in several parcels from different places (the second parcel, customer contacts) and compares it with gathering the order in one place (moving goods and the risk of losing the order while waiting).
At a glance
- What question does it answer?
- What is cheaper: ship an order in several parcels or gather it in one place.
- What data is needed?
- Share of split orders, the cost of an additional parcel, the share of contacts and their cost.
- How to read the result?
- There are 720 split orders a month; splitting costs 240 per order (172,800 a month), consolidation 150.75. Consolidation gains 64,260 a month; moving pays while it costs no more than 179.25. Example on the default values: Split orders a month: 720 orders; Cost of splitting per split order: RUB 240; Splitting for the month: RUB 172,800; Splitting per all orders: RUB 28.8. The figures are illustrative: enter your own to see your result.
Why and how to reason
When an order is assembled from different places it arrives in several parcels: the second parcel costs money, the customer writes to support more often, sometimes returns both parts. The alternative is to assemble everything in one place: goods are moved to a warehouse or store and some orders are lost to waiting. The calculation compares two prices per order. Splitting = extra parcel + contact share × contact cost = 210 + 25% × 120 = 240. Assembly in one place = move + lost order share × order margin = 90 + 3% × 2,025 = 150.75. Split orders per month are 12% of 6,000 = 720: splitting costs 172,800, assembly in one place 108,540, benefit 64,260 (89.25 per order). The break-even price of moving at which the options are equal is 179.25: while moving is cheaper, consolidation is better.
When to use it
It comes in handy when setting up shipping rules in an online shop with several warehouses and stores. It suits a brand and retailer with omnichannel. It does not suit a single warehouse: there is no splitting. Assumptions: shares of split orders, contacts and lost orders are your estimates from statistics; the cost of moving is constant. It is especially appropriate when the share of split orders grows with the assortment and the number of storage points and you must decide where to hold stock.
How to read the result
If assembly in one place is cheaper, look at which pairs of places split orders most often: moving fast-moving stock to where it is short lowers the share of splits and saves more than rules. If splitting is cheaper, the rule “ship from where it is” is better. Compare “splitting on all orders” (28.8 per order across the board in the example, about 1.4% of order margin) with your margin: if it eats a noticeable share the problem is systemic. Check returns too: a customer often returns both parts. The decision: how much and which goods to hold in each warehouse so orders do not split.
Common mistakes
Not counting customer contacts: they give a noticeable part of the split cost. Taking “order lost to waiting” as zero. Assuming the customer accepts two parcels equally in any segment: for gift orders tolerance is lower. Not accounting that part of the second parcel arrives later and stretches the lead time.
What data is needed?
- Share of split orders, the cost of an additional parcel, the share of contacts and their cost.
- The cost of moving and the share of orders lost to the wait.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Orders a month | orders | 6,000 | All orders, not only split ones. |
| Share of orders in several parcels | % | 12 | From your shipment statistics: orders whose items left from different places. |
| Gross margin per order | ₽ | 2,025 | Excl. VAT: basket × margin share. Needed to estimate the loss of an order. |
| An additional parcel | ₽ | 210 | Packing and delivery of the second parcel net of the customer’s fee. An example: enter your own data, there is no single standard in Russia. |
| Contacts about a split order | % | 25 | Share of split orders where the customer wrote or called (“where is the second part”). An example: enter your own data, there is no single standard in Russia. |
| Cost of a contact | ₽ | 120 | Support time per contact. An example: enter your own data, there is no single standard in Russia. |
| Moving goods to the picking place | ₽ | 90 | Per order: internal transport and handling. An example: enter your own data, there is no single standard in Russia. |
| Order lost to the wait | % | 3 | Share of orders canceled by the customer because of a longer delivery. An example: enter your own data, there is no single standard in Russia. |
How it is calculated
| Step | Formula |
|---|---|
| Splitting | additional parcel + contact share × cost of a contact |
| Consolidation | moving + share of lost orders × order margin |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Split orders a month
- 720 orders
- Cost of splitting per split order
- 240 ₽The additional parcel plus the expected cost of contacts.
- Splitting for the month
- 172,800 ₽
- Splitting per all orders
- 28.8 ₽
- Consolidation, per order
- 150.75 ₽Moving plus the expected loss of margin on cancellation.
- Gain of consolidation for the month
- 64,260 ₽A minus means shipping in parts is cheaper.
- Break-even moving cost
- 179.25 ₽Above this price moving an order costs more than two parcels.
Two options for one split order
| Item | Ship in parts | Consolidate |
|---|---|---|
| Direct costs | 210 ₽ | 90 ₽ |
| Expected cost of contacts | 30 ₽ | 0 ₽ |
| Expected margin loss | 0 ₽ | 60.75 ₽ |
Consolidation is cheaper by 89.25 ₽ per order. First look at which pairs of places split orders most often: moving fast stock to where it runs short lowers the share of splits.
Splitting also harms returns: customers often send back both parts. If you have the statistics, add them to the cost of contacts.
Nuances and limits
- Take the share of splits from shipments, not an assumption.
- Returns of both parts are not included.