Click and collect: the economics against delivery
Compares an order collected in store with a delivered order: the cost of picking and handing over in the store, the cost of uncollected orders, the saving on delivery and the margin of add-on sales when the customer comes to the store. Shows the gain per order and per month, the staff workload and the needed share of add-on sales.
At a glance
- What question does it answer?
- Is click-and-collect cheaper than delivery?
- What data is needed?
- Click-and-collect orders, delivery cost, picking and handover time, cost of an hour.
- How to read the result?
- Collection costs 95 per order, delivery 200: a saving of 105. Add-ons give another 178.2, an advantage of 283.2 per order and 424,800 a month at 1,500 orders. Staff spend 300 hours a month. Example on the default values: Collection: cost per order: RUB 95; Delivery: cost per order: RUB 200; Saving per order without add-ons: RUB 105; Add-on margin per order: RUB 178.2. The figures are illustrative: enter your own to see your result.
Why and how to reason
Click and collect from a store seems a win: no delivery. But it has its own costs: an employee picks and hands over the order, some orders are not collected and must be returned to the shelf. The calculation compares the cost of an order in two options. Pickup = minutes ÷ 60 × hourly cost + uncollected × cost − customer fee = 12 ÷ 60 × 450 + 5% × 100 − 0 = 95. Delivery costs 200. A saving of 105 per order. But pickup has a bonus: the customer comes to the store and may buy more. Add-on sales = share who bought × add-on order value × margin = 22% × 1,800 × 45% = 178.2 per order. Benefit of pickup = 200 − 95 + 178 = 283 per order, 424,800 a month at 1,500 orders. Staff hours on pickup are 300 a month: almost two people. The share of add-on sales needed for break-even is zero, because pickup is cheaper than delivery even without them.
When to use it
Reach for it when launching pickup, deciding on a fee for it and sizing store staff load. It suits a retailer and a brand with stores and an online channel. It does not suit fitting with return of part of the order: add the cost of returns to pickup costs. Assumptions: include add-on sales only at the share you actually observe, some customers would have bought it without the order anyway.
How to read the result
Look at “benefit of pickup per order” and its components: saving on delivery and add-on sales. If add-on sales give most of the benefit, check them on real data: the customer may just come for the order and leave. Compare “staff hours on pickup per month” with the store’s time reserve: if it is almost two people, a pickup zone must be created or the organization changed. Uncollected orders should be reduced by reminders and a storage period. The decision: whether to promote pickup, whether to charge, how to organize handover. Revisit the result after a pilot in several stores.
Common mistakes
Counting add-on sales at the maximum: some customers would have bought anyway. Not including staff time at peak hours. Forgetting storage space for orders: it occupies meters. Not accounting for the store losing its own sales while an employee picks an order. Counting uncollected orders as zero. Another mistake: taking picking time from the best employee. At peak it is higher and 12 minutes easily become 20.
What data is needed?
- Click-and-collect orders, delivery cost, picking and handover time, cost of an hour.
- Share uncollected, cost of an uncollected order, add-on share, add-on basket and margin.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Click-and-collect orders a month | orders | 1,500 | Orders handed over in stores. |
| Net cost of delivering an order | ₽ | 200 | The delivery cost to you net of the customer’s fee; from “Last mile”. An example: enter your own data, there is no single standard in Russia. |
| Picking and handing over an order | min | 12 | Staff minutes per order: picking, packing, holding, handover. An example: enter your own data, there is no single standard in Russia. |
| Cost of a staff hour | ₽ | 450 | With contributions: see “Payroll and the full cost of an employee”. An example: enter your own data, there is no single standard in Russia. |
| Customer’s fee for collection | ₽ | 0 | The customer’s fee for pickup in roubles: usually zero; if it is free, leave 0. |
| Uncollected orders | % | 5 | Share of orders the customer did not collect. An example: enter your own data, there is no single standard in Russia. |
| Cost of an uncollected order | ₽ | 100 | Restocking, a refund, lost time. An example: enter your own data, there is no single standard in Russia. |
| Share of customers buying something more | % | 22 | From your receipts: the customer came for an order and bought more. Do not borrow other people’s figures. An example: enter your own data, there is no single standard in Russia. |
| Average add-on basket excl. VAT | ₽ | 1,800 | Excl. VAT (if you pay VAT and deduct it). Confirm your regime and rate with an accountant. |
| Margin of the add-on | % | 45 | Margin share in revenue excl. VAT. |
How it is calculated
| Step | Formula |
|---|---|
| Collection | minutes ÷ 60 × hourly cost + uncollected × cost − customer fee |
| Add-ons | share buying × add-on basket × margin |
| Advantage | delivery − collection + add-ons |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Collection: cost per order
- 95 ₽Staff work + expected cost of uncollected − the customer’s fee.
- Delivery: cost per order
- 200 ₽
- Saving per order without add-ons
- 105 ₽
- Add-on margin per order
- 178.2 ₽Share buying × add-on basket × margin.
- Advantage of collection per order
- 283.2 ₽
- Advantage of collection for the month
- 424,800 ₽
- Staff hours on collection a month
- 300 h
- Add-on share needed to break even
- 0 % · collection already pays on the saving
One order: two ways
| Item | Collection | Delivery |
|---|---|---|
| Staff work | 90 ₽ | — |
| Uncollected | 5 ₽ | — |
| Customer fee | −0 ₽ | — |
| Net delivery | — | 200 ₽ |
| Add-on margin | −178.2 ₽ | — |
Include add-ons only at the share you actually observe: some customers would have bought it without the order anyway. If the customer tries things on in store and returns part of the order, add the cost of returns to the collection costs.
Nuances and limits
- Take the add-on share from your own receipts.
- The space to hold orders in the store is not included.