Platform warehouse or own warehouse (FBO and FBS): the full cost of an ordered unit and the storage term
Compares two schemes for one product: the platform warehouse (storage, acceptance and logistics at the platform) and your own warehouse (your picking and your own storage, platform delivery). Calculates profit per ordered unit with returns, storage by day and the cost of money in stock, finds the storage term up to which the platform warehouse scheme pays, the money in stock and the monthly profit in each scheme.
At a glance
- What question does it answer?
- In which scheme the item brings more, at what storage term the platform warehouse stops paying and how much money is frozen in stock.
- What data is needed?
- Price, cost, returns, commission, advertising, tax, fines: common to both schemes.
- How to read the result?
- Example on the default values (600 orders a month): profit per ordered in FBO RUB 823.41, in FBS RUB 801.62; the platform warehouse pays up to 58 days of storage; money in stock RUB 1.2 million at the platform and RUB 1.8 million with you. Example on the default values: Profit per ordered: FBO: RUB 823.41; Profit per ordered: FBS: RUB 801.62; Difference FBO minus FBS: +RUB 21.79; The better scheme: FBO. The figures are illustrative: enter your own to see your result.
Why and how to reason
The choice between the platform warehouse and your own warehouse is often made by habit or by how “everybody does”. But the schemes differ in who pays for storage, picking and delivery and in how much money is frozen in goods. The platform warehouse charges for storage and acceptance, but picks and delivers itself. Your own warehouse needs your picking costs and space but does not pay the platform for storage. The main link here is the term: the longer goods lie before a sale, the more expensive the platform warehouse is, because storage accumulates by days and frozen money costs interest. The calculation puts together the full cost of an ordered unit in both schemes and finds the term after which the scheme changes. At the default values the profit in FBO is RUB 823.41, in FBS RUB 801.62: a difference of RUB 21.79 in favor of the platform warehouse at 40 days of storage, and the maximum term is about 58 days.
When to use it
Apply it for a separate item or a group with similar turnover when deciding where to take goods and once a season at review. The calculation requires honest days to sale in each scheme: they depend on sales speed, and the speed may differ. Assumptions: price, returns, commission, advertising and tax are the same in both schemes, rates do not depend on volume. For fast hits with short turnover the result is usually in favor of the platform warehouse, for the slow tail and bulky items in favor of your own warehouse.
How to read the result
First compare the two profits per ordered unit and the difference: if it is within a few roubles the schemes are practically equal and other considerations decide: delivery speed, the risk of a missed term, your capacity. Then look at the “Maximum storage term in FBO”: this is the number of days up to which the platform warehouse pays better at your days in your own scheme. If the item’s sale term is longer than the maximum, move it to your own warehouse. “Money in stock” shows how much capital is frozen in each scheme: your own warehouse often freezes more because of the longer term. “Monthly profit” turns the difference into money at your volume of orders. The chart shows how the FBO profit falls with days and where it crosses the FBS level.
Common mistakes
The first mistake is to take the same days to sale for both schemes although sales speed depends on the scheme. The second is not to include your picking, packing and warehouse costs in the own warehouse scheme: it looks better than it is. The third is to forget the cost of money in stock: a slow item seems cheaper. The fourth is to decide with one scheme for the whole range instead of deciding by item.
What data is needed?
- Price, cost, returns, commission, advertising, tax, fines: common to both schemes.
- For each scheme: logistics, acceptance, storage rate, days to sale, your picking.
- Orders per month and the cost of money.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Buyer price | ₽ | 4,000 | The price on which the platform counts your accruals after discounts; the same in both schemes. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Unit cost | ₽ | 1,500 | Cost or purchase price; the cost of money frozen in stock is counted from it as well. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Returns and non-pickup | % | 25 | The share of ordered units that came back; the same in both schemes, take it by item from past reports. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Platform commission | % | 15 | The rate for the card category; if the rates differ between schemes put an average or calculate separately. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Advertising | % | 8 | The share of advertising spend of revenue net of returns; the same in both schemes. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Tax | % | 6 | Tax on revenue by your regime; count VAT in the price separately. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Fines and other per order | ₽ | 12 | The average sum of fines and small deductions per ordered unit from past reports. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Forward logistics per order | ₽ | 90 | The platform services of delivering one order to the buyer; depends on size and region. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Reverse logistics per return | ₽ | 80 | The platform services of returning one unit; paid only for those that came back. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Acceptance per unit | ₽ | 10 | The fee for accepting a delivery at the warehouse, per unit; depends on the warehouse and day. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Storage at the platform | per unit per day | 0.5 | The storage fee rate for one unit per day from the offer. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Days to sale in FBO | days | 40 | How many days a unit lies on average in the platform warehouse before an order; from the item turnover. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Forward logistics per order | ₽ | 70 | The platform services of delivering an order picked by you; usually lower than for the platform warehouse. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Reverse logistics per return | ₽ | 80 | The platform services of returning a unit to you; paid only for those that came back. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Your picking and packing per order | ₽ | 45 | The costs of picking, packing and handing the order to the platform: staff, materials, transport to the acceptance point. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Own storage | per unit per day | 0.2 | The rate of storing one unit in your warehouse per day: rent, staff, systems. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Days to sale in FBS | days | 60 | How many days a unit lies with you before an order; in FBS it is often longer because of lower delivery speed. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Orders per month | pcs | 600 | The expected number of orders of the item per month in the chosen scheme; needed for money in stock and monthly profit. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
| Cost of money | % per year | 18 | The rate at which you borrow or forgo the money frozen in stock. The example value is illustrative: substitute your own from the offer on the date of the calculation. |
How it is calculated
| Step | Formula |
|---|---|
| Revenue and buy-out | price × (1 − returns); commission, advertising and tax are taken from it |
| Logistics | forward on every order + reverse × return share |
| Storage | rate per day × days to sale; in FBS the rate is yours |
| Cost of money | cost × annual rate × days ÷ 365 |
| Maximum term | (FBO profit at zero days − FBS profit) ÷ (storage rate + cost of money per day) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Profit per ordered: FBO
- 823.41 ₽With the platform warehouse: platform services, storage by day, the cost of money in stock.
- Profit per ordered: FBS
- 801.62 ₽With your own warehouse: your picking and own storage, platform delivery.
- Difference FBO minus FBS
- +21.79 ₽Plus means the platform warehouse scheme brings more on every ordered unit.
- The better scheme
- FBO
- Maximum storage term in FBO
- 58 daysWhile a unit lies at the platform for less than this term FBO pays better; longer and FBS pays better (at your days in FBS).
- Money in stock: platform
- 1.2 m ₽Orders per day × days to sale × cost: the capital frozen in goods in the platform warehouse.
- Money in stock: own warehouse
- 1.8 m ₽
- Monthly profit: FBO
- 494,047 ₽
- Monthly profit: FBS
- 480,970 ₽
- FBO
- FBS at your days
Data as a table
| Days to sale in FBO | FBO | FBS at your days |
|---|---|---|
| 0 | 873 | 802 |
| 15 | 854 | 802 |
| 30 | 836 | 802 |
| 45 | 817 | 802 |
| 60 | 799 | 802 |
| 90 | 761 | 802 |
| 120 | 724 | 802 |
| 150 | 687 | 802 |
| 180 | 650 | 802 |
Data as a table
| Measure | Profit |
|---|---|
| FBO | 823 |
| FBS | 802 |
Items per ordered unit
| Item | FBO | FBS |
|---|---|---|
| Revenue net of returns | 3,000 ₽ | 3,000 ₽ |
| Commission | −450 ₽ | −450 ₽ |
| Platform logistics | −110 ₽ | −90 ₽ |
| Acceptance | −10 ₽ | 0 ₽ |
| Storage | −20 ₽ | −12 ₽ |
| Your picking and packing | 0 ₽ | −45 ₽ |
| Fines and other | −12 ₽ | −12 ₽ |
| Advertising | −240 ₽ | −240 ₽ |
| Tax | −180 ₽ | −180 ₽ |
| Cost of kept units | −1,125 ₽ | −1,125 ₽ |
| Cost of money in stock | −29.59 ₽ | −44.38 ₽ |
| Profit per ordered | 823.41 ₽ | 801.62 ₽ |
At the given rates the platform warehouse scheme pays better: the difference is 21.79 ₽ per ordered unit. The platform warehouse stops being better after 58 days of storage.
The model is linear: rates do not depend on volume, returns and price are the same in both schemes. In practice the scheme affects sales speed and position in the results: if in one scheme the item sells faster, reflect this in days to sale. For a hybrid by item calculate every item separately: hits more often in FBO, the slow tail in FBS.
Nuances and limits
- Taking the same days to sale for both schemes: sales speed depends on the scheme.
- Forgetting your picking and warehouse costs in FBS: the scheme looks better than it is.
- Not counting the cost of money in stock: a slow item looks cheaper.
- Deciding with one scheme for the whole range: decide by item.