The economics of an order on a platform: logistics by liters, redemption, the advertising bid, supplies and tax as a guide
The document shows how to assemble the cost of one redeemed order on a platform from four parts: logistics by dimensions and redemption, the maximum advertising bid, the size and frequency of supplies to the warehouse and tax by regime. The decision it supports: whether to put an item on a platform, which advertising bid to set and in what lots to ship.
Why this document
Platforms name delivery costs and commissions by their tariffs, while the owner of an item sees the result only in last month’s report. Breaking an order into links shows which one eats the contribution: a package one liter larger, redemption ten points lower, an advertising bid above the break-even one. The document is read by the platform manager, the category manager, the finance director and the accountant. Tariffs and tax rates are not hard-wired here: you enter them on the date.
At a glance
- What is this document and why is it needed?
- The document shows how to assemble the cost of one redeemed order on a platform from four parts: logistics by dimensions and redemption, the maximum advertising bid, the size and frequency of supplies to the warehouse and tax by regime. The decision it supports: whether to put an item on a platform, which advertising bid to set and in what lots to ship.
- Who owns the document and how often is it rebuilt?
- Brand and retail: the platform manager builds the calculation, the finance director approves the assumptions, the accountant checks the tax; recalculate at each change of tariff and packaging.
- What mistakes are the most common?
- Taking logistics from last month’s report → the tariff has already changed → count by the tariff on the date and the dimensions. Leaving out the reverse logistics of non-redemption → the item looks profitable → divide by redemption. Counting the advertising contribution without redemption → the bid is overstated → multiply by redemption.
For whom
- Brand
- A brand decides which packaging to build into production: a centimeter of height changes liters and the cost of each redeemed unit all season.
- Retail
- A retail seller on a platform counts the contribution from the purchase and tariffs and decides which items to list and which to keep in the shop.
What it consists of
Logistics by liters and redemption
- Volume in liters = length × width × height of the package in centimeters ÷ 1000. Take the dimensions of the package and not of the item and check them by measuring: the platform counts exactly by them.
- Direct logistics = (base for the first liter + (volume − 1) × price per liter) × warehouse coefficient × localization coefficient. The tariff changes several times a year: enter it on the date of the calculation and write the date next to the result.
- Non-redemption adds reverse logistics and it is paid by the redeemed units: per redeemed unit = (direct + (1 − redemption) × reverse) ÷ redemption. The lower the redemption, the faster this amount grows.
The maximum advertising bid
- Contribution per click = conversion of a paid click into an order × redemption × the contribution of a redeemed order before advertising. It is the break-even bid: above it every click loses money.
- The allowed bid = the share of the contribution you keep × the break-even one. The rest is a reserve for competition for position and for conversion error. If payment is per impression, the bid per click = CPM ÷ 1000 ÷ CTR.
- Ad cost ratio = bid ÷ (conversion × price). Always say of which revenue it is counted: before returns (ordered) or after (redeemed).
The size and frequency of supplies to the warehouse
- The holding cost of a unit per day = the platform fee + cost of capital × cost ÷ 365. The fee depends on the day and the warehouse load: take the average over the tariff grid.
- The supply size = √(2 × sales per day × fixed supply cost ÷ holding cost); cover = size ÷ sales per day. The minimum lot and the storage period without the paid zone cap the size, and the overpayment is shown separately.
- The safety stock for the lead time is not in the formula: add it on top and count the reorder point as sales per day × lead time.
Tax by regime as a guide
- The tax calculation needs a specialist check: rates and thresholds are entered as guides on a date, it gives no legal conclusions. The regimes: the simplified system “income” is counted from the selling price to the buyer, “income minus costs” from the difference with a minimum tax, the general system from VAT and profit.
- Compare the remainder after tax per redeemed unit and not only the tax: a regime with less tax may give a smaller remainder because of the VAT deduction. The regime is chosen by the accountant on the whole turnover, thresholds and revenue recognition specifics.
Sanity checks and what to do with the result
- Logistics per redeemed unit not below the price means a loss before commission. A bid from CPM above the break-even means a loss-making click. A minimum lot larger than the storage period means incompatible conditions. A non-positive contribution means there is nothing to pay for advertising with.
- Put the logistics per redeemed unit into the order contribution, get the advertising bid from the contribution, then decide the supply lots. Recount the chain at each change of tariff, packaging or redemption.
Where the data comes from
| Data source | Fields |
|---|---|
| The item card and the packaging | package dimensions in centimeters, selling price, cost, redemption by item |
| Platform tariffs on the date | the base for the first liter, price per liter, warehouse and localization coefficients, return cost, storage fee |
| The ad account | conversion of paid clicks, CPM, CTR, the current bid |
| Accounting | the tax regime, rates as guides on a date, the share of the purchase from VAT payers |
How to build it step by step
- Step 1: Measure the package and count the volume in liters.
- Step 2: Enter the platform tariff on the date and count the direct logistics.
- Step 3: Take the redemption by item and find the logistics per redeemed unit.
- Step 4: Assemble the order contribution before advertising and get the break-even and allowed bid.
- Step 5: Compare the auction bid or the bid from CPM with the allowed one.
- Step 6: Find the supply size and cover, add a safety stock for the lead time.
- Step 7: Compare the remainder after tax by regime and pass the result to the accountant.
- Step 8: Record the date of the tariff and rates and set a recalculation when they change.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Logistics per redeemed unit | (direct + (1 − redemption) × reverse) ÷ redemption | Direct = (base + (liters − 1) × price per liter) × coefficients. |
| Break-even advertising bid | conversion × redemption × order contribution before advertising | Allowed = share of the contribution × break-even. |
| Supply size | √(2 × sales per day × supply cost ÷ holding cost per day) | Capped by the minimum lot and the storage period. |
Worked example
An illustrative item: a 40 × 30 × 10 cm package, redemption 70%, order contribution RUB 1,100, 20 pcs a day
| Metric | Value |
|---|---|
| Package volume, l | 12.0 |
| Logistics per redeemed unit, RUB | 437.14 |
| Allowed bid per click, RUB | 16.17 |
| Supply size, pcs | 328.6 |
| Supplies per year | 22.2 |
Direct logistics RUB 276, supply cover 16.4 days. All numbers are illustrative.
Figures
Data as a table
| Measure | RUB per redeemed unit |
|---|---|
| 40% | 840 |
| 50% | 652 |
| 60% | 527 |
| 70% | 437 |
| 80% | 370 |
| 90% | 318 |
| 100% | 276 |
Logistics per redeemed unit at different redemption. The lower the redemption, the steeper the cost of a redeemed unit grows.
Data as a table
| Measure | Bid |
|---|---|
| Break-even | 23.1 |
| Allowed | 16.2 |
| From CPM | 11.3 |
Bids per click, RUB. The allowed bid is below the break-even one by the set reserve.
Specifics by category
- Apparel
- Apparel: many sizes and seasonality, so count redemption, purchase gaps and day indices by season.
- Footwear
- Footwear: redemption is lower because of fitting, and reverse logistics noticeably changes the cost of a redeemed unit.
- Accessories
- Accessories: the check is small, pairs with apparel give a lift; the delivery threshold and bundles work stronger.
- Kids
- Kids: frequent repurchases by height, gaps between purchases are shorter, the lapsed threshold is lower.
- Men
- Men: a steady core range, less frequent purchases, a longer lapsed threshold.
- Women
- Women: more novelties and seasonal peaks; count day indices and pair lift separately by season.
Common mistakes
- Taking logistics from last month’s report → the tariff has already changed → count by the tariff on the date and the dimensions.
- Leaving out the reverse logistics of non-redemption → the item looks profitable → divide by redemption.
- Counting the advertising contribution without redemption → the bid is overstated → multiply by redemption.
- Taking organic conversion → paid clicks convert less → take the conversion of paid clicks.
- Ignoring the lead time → the goods run out → add a safety stock and a reorder point.
- Counting tax from the platform payout → the base is understated → count from the selling price and check with an accountant.
Russian specifics
- The tax calculation needs a specialist check: VAT and tax rates, thresholds and regimes are entered as guides on a date and checked against the act in force. Advertising is subject to marking: count its costs separately.