The merchant’s decision desk: 20 everyday store calculations

A supplier invoice, a second shipping label, a late payout. Pick the decision on your desk and open it to compare eight worked examples. Use the line of arithmetic to repeat it with your figures.

How many working days will a packing machine take to pay back?

Try the 48-day example. Replace the purchase price and daily costs with a supplier quote and your own estimate.

Payback · 48 working days

Use labour costs you can actually avoid. This simple payback estimate excludes interest, tax and resale value.

Try the Ecommerce Profit & Pricing Workbook

Open the free workbook preview

Would a stronger box pay off?

Count actual replacements over the next 100 parcels.

Worked example · 100 × 0.3 ÷ 15 → 2 ↑

Extra per boxCost of one replacementBreakages to prevent in 100 parcels
$0.3$152
$0.35$202
$0.4$252
$0.45$302
$0.5$154
$0.55$203
$0.6$253
$0.65$303
What does each sellable item really cost?

Divide the invoice by what passed inspection.

Worked example · 300 ÷ 60 = 5

Supplier invoice for the batchUnits fit for sale after inspectionPurchase cost per sellable unit
$30060$5
$43272$6
$58884$7
$76896$8
$972108$9
$1,200120$10
$1,452132$11
$1,728144$12
How long until the shelf is empty?

Take out reserved stock before running the numbers.

Worked example · 72 ÷ 8 = 9

Saleable units on the shelfUnits sold each dayDays of stock at this pace
7289
1001010
1321211
1681412
2081613
2521814
3002015
3522216
How many pieces repay a setup fee?

Use the contribution per piece after variable costs.

Worked example · 72 ÷ 4 = 18

One-time setup chargeContribution per piece before setupPieces needed to cover setup
$72$418
$105$521
$144$624
$189$727
$240$830
$297$933
$360$1036
$429$1139
A retailer wants a case. What is left?

Use the wholesale price on the purchase order.

Worked example · (16 − 9) × 12 = 84

Wholesale price per unitVariable cost per unitContribution per case of 12
$16$9$84
$18$10$96
$20$11$108
$22$12$120
$24$13$132
$26$14$144
$28$15$156
$30$16$168
What do split shipments cost this week?

Count the extra labels on your carrier invoice.

Worked example · 7 × 4 = 28

Orders needing a second parcelExtra delivery charge per parcelExtra delivery charges this week
7$4$28
10$5$50
13$6$78
16$7$112
19$8$152
22$9$198
25$10$250
28$11$308
What does one picking mistake really cost?

Check both labels when a returned item is resellable.

Worked example · 4 + 6 = 10

Return label paid by the storeNew outbound label and handlingCorrection cost if item is recovered
$4$6$10
$5$8$13
$6$10$16
$7$12$19
$8$14$22
$9$16$25
$10$18$28
$11$20$31
How much should a size exchange reserve cover?

Use the actual exchange rate for this size range.

Worked example · 5 ÷ 100 × 10 = 0.5

Exchanges per 100 ordersExtra cost of each exchangeAverage reserve per original order
5$10$0.5
6$12$0.72
7$14$0.98
8$16$1.28
9$18$1.62
10$20$2
11$22$2.42
12$24$2.88
Marketplace or direct: what fee would you pay?

Compare equal orders before adding channel-specific costs.

Worked example · 50 × (12% − 3%) = 4.5

Order valueMarketplace fee versus direct feeFee difference on this order
$5012% / 3%$4.5
$6013% / 3%$6
$7014% / 3%$7.7
$8015% / 3%$9.6
$9016% / 3%$11.7
$10012% / 3%$9
$11013% / 3%$11
$12014% / 3%$13.2
Does commission include delivery?

Read the commission base in your own agreement.

Worked example · 5 × 8% = 0.4

Delivery charge excluded by contractAffiliate commission rateOverpayment if delivery is included
$58%$0.4
$710%$0.7
$912%$1.08
$1114%$1.54
$1316%$2.08
$1518%$2.7
$1720%$3.4
$1922%$4.18
Can gift wrapping fund its own labour?

Time one wrapped order from ribbon to label.

Worked example · 2 ÷ 12 × 60 = 10

Wrap fee after materialsLabour cost per hourMinutes of labour covered
$2$1210
$3$1810
$4$2410
$5$3010
$6$3610
$7$4210
$8$4810
$9$5410
How many label rolls do you need?

Round up so the last orders have labels too.

Worked example · 335 ÷ 100 → 4 ↑

Labels still needed after counting stockLabels per unopened rollWhole rolls to buy
3351004
6351505
1,0352006
1,5352507
7351008
1,2351509
1,83520010
2,53525011
At what stock level should you reorder?

Compare this point with stock on hand plus stock on order, minus backorders.

Worked example · 8 × 4 + 10 = 42

Daily unit demand × lead daysSafety stock in unitsReorder point in units
8 × 41042
10 × 51363
12 × 61688
14 × 719117
16 × 42286
18 × 525115
20 × 628148
22 × 731185
Can an insert pay for its print run?

Count extra purchases against a comparable group without the insert.

Worked example · 120 ÷ 6 = 20

Total printing costContribution per extra repeat orderAdditional repeat orders to break even
$120$620
$168$724
$224$828
$288$932
$360$1036
$440$1140
$528$1244
$624$1348
How many subscribers stay this month?

Track new signups separately from the starting group.

Worked example · 100 × (100% − 6%) = 94

Subscribers at start of monthShare of starting group that cancelsStarting subscribers retained
1006%94
2007%186
3008%276
4009%364
50010%450
60011%534
70012%616
80013%696
What did the slow shelf cost this month?

Use the bins this item actually occupied.

Worked example · 6 × 8 = 48

Bins kept all monthMonthly cost per binStorage cost for this item
6$8$48
7$10$70
8$12$96
9$14$126
10$16$160
11$18$198
12$20$240
13$22$286
What does a product shoot add per sale?

Recalculate with actual sales after the launch.

Worked example · 240 ÷ 80 = 3

One-off shoot costUnits expected to sellShoot cost per expected unit
$24080$3
$400100$4
$600120$5
$840140$6
$1,120160$7
$1,440180$8
$1,800200$9
$2,200220$10
Should you pay for express restocking?

Exclude sales that would simply wait for the normal shipment.

Worked example · 72 ÷ 7 → 11 ↑

Extra freight for express restockingContribution per sale keptLost sales you must prevent
$72$711
$90$812
$110$913
$132$1014
$156$1115
$182$1216
$210$1317
$240$1418
How many sample kits can the budget fund?

Include packaging and outbound postage before dividing.

Worked example · 101 ÷ 4 → 25 ↓

Available sample budgetAll-in variable cost per kitComplete kits within the budget
$101$425
$136$527
$175$629
$218$731
$265$833
$316$935
$371$1037
$430$1139
How much cash is still waiting for payout?

Match the bank transfer to its settlement batch.

Worked example · 1,200 − 825 = 375

Net receipts due for this batchAlready paid into the bankBalance outstanding for the batch
$1,200$825$375
$1,450$950$500
$1,700$1,075$625
$1,950$1,200$750
$2,200$1,325$875
$2,450$1,450$1,000
$2,700$1,575$1,125
$2,950$1,700$1,250

Hypothetical inputs. Only the listed costs are included.

Try the Ecommerce Profit & Pricing Workbook