Supply size and frequency to a marketplace warehouse
Picks the size of a supply to the marketplace warehouse at which the sum of supply and storage costs is lowest: the platform storage fee and the cost of tied-up money give the daily holding cost of a unit, the fixed cost of a supply is spread over the frequency. Shows the size, the cover in days, the number of supplies per year and the annual costs, takes the minimum lot and the storage period without the paid zone into account.
At a glance
- What question does it answer?
- What the supply size must be for the costs of supplies and storage to be lowest and how often to supply.
- What data is needed?
- Sales per day without days out of stock.
- How to read the result?
- Look at the overpayment due to constraints and at the cover against the lead time: a short cover means shipping before the previous supply arrives. Example on the default values: Holding cost of a unit per day: RUB 2.22; Economic supply size: 328.6 pcs; Recommended supply size: 328.6 pcs; Cover of a supply: 16 days. The figures are illustrative: enter your own to see your result.
Why and how to reason
Each supply costs fixed money and each unit in the warehouse costs a storage fee and tied-up capital. The balance gives the supply size √(2 × demand × supply cost ÷ holding cost). In the example the cost is RUB 2.22 a day, size 328.6 pcs, cover 16.4 days, 22.2 supplies a year, costs RUB 266,622.
When to use it
Apply when planning the supply schedule to the platform warehouse and when the storage tariff changes.
How to read the result
Look at the recommended size, the cover against the lead time and the overpayment due to constraints: it shows the price of the minimum lot and the storage period.
Common mistakes
They ignore the stock-out risk at a long lead time and take the storage fee as an average.
What data is needed?
- Sales per day without days out of stock.
- The platform storage fee, the fixed cost of a supply, the cost and the cost of capital.
- The minimum lot and the storage period without the paid zone, the lead time.
- An example: 20 pcs a day, storage RUB 1.5, supply cost RUB 6,000, rate 22%, cost RUB 1,200: size 328.6 pcs, cover 16.4 days, 22.2 supplies a year (illustrative numbers).
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Sales per day | pcs/day | 20 | Average sales of the item at this warehouse per day, without days out of stock and one-off promotions. The example value is illustrative. |
| Storage fee | RUB/unit/day | 1.5 | The average platform fee per unit per day with the paid zone. Tariffs change several times a year: enter the tariff on the date of the calculation and write that date down. The example value is illustrative. |
| Cost of a unit | ₽ | 1,200 | The purchase cost: the cost of tied-up money is counted from it. The example value is illustrative. |
| Cost of capital rate | % per year | 22 | The annual cost of money in stock: the loan rate or your required return. The example value is illustrative. |
| Fixed cost of one supply | ₽ | 6,000 | Everything that does not depend on the size of the supply: delivery to the warehouse, receiving, paperwork, people. The example value is illustrative. |
| Minimum lot or multiple (optional) | pcs | 0 | You cannot supply less. 0 means no minimum. The example value is illustrative. Optional. Empty: the field is ignored (counted as zero in sums). |
| Storage period without the paid zone (optional) | days | 0 | How many days stock may be held without the raised fee: the supply size is capped above it. 0 means no cap. The example value is illustrative. Optional. Empty: the field is ignored (counted as zero in sums). |
| Lead time to the warehouse (optional) | days | 0 | How many days pass from dispatch to receiving: the reorder point is counted from it. The example value is illustrative. Optional. Empty: the field is ignored (counted as zero in sums). |
How it is calculated
| Step | Formula |
|---|---|
| Holding cost | 1.5 ₽ + 22 % × 1,200 ₽ ÷ 365 = 2.22 ₽ |
| Economic size | √(2 × 20 × 6,000 ₽ ÷ 2.22 ₽) = 328.6 pcs |
| Cover and frequency | size ÷ sales per day; sales per year ÷ size |
| Annual costs | sales per year ÷ size × supply cost + size ÷ 2 × holding cost × 365 |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Holding cost of a unit per day
- 2.22 ₽Storage fee + cost of capital × cost ÷ 365.
- Economic supply size
- 328.6 pcs
- Recommended supply size
- 328.6 pcsWith the minimum lot and the storage period.
- Cover of a supply
- 16 daysSize ÷ sales per day.
- Supplies per year
- 22.2
- Annual supply and holding costs
- 266,622 ₽
- Overpayment due to constraints
- 0 ₽
- Reorder point
- the lead time is not set
Data as a table
| Measure | Costs |
|---|---|
| 164 | 333 |
| 246 | 278 |
| 329 | 267 |
| 411 | 273 |
| 493 | 289 |
| 657 | 333 |
Costs at sizes relative to the economic one
| Size, pcs | Cover, days | Supplies per year | Annual costs |
|---|---|---|---|
| 164 | 8.2 | 44.4 | 333,278 ₽ |
| 246 | 12.3 | 29.6 | 277,731 ₽ |
| 329 | 16.4 | 22.2 | 266,622 ₽ |
| 411 | 20.5 | 17.8 | 273,288 ₽ |
| 493 | 24.6 | 14.8 | 288,841 ₽ |
| 657 | 32.9 | 11.1 | 333,278 ₽ |
What to do with the result: put the size into the supply schedule, but keep a safety stock for the lead time: the formula does not include it. Take the storage fee as the average over the tariff grid, not for a single day.
A typical mistake: ignoring the risk of a stock-out at a long lead time and counting the storage fee as an average over the whole season although it depends on the day and the warehouse load.
Nuances and limits
- Ignoring the risk of a stock-out at a long lead time.
- Taking the storage fee as the season average.
- Not entering the minimum lot: the recommendation will be infeasible.