Handling stock is an important issue for any seller, both for those who use Amazon’s warehouses and for those who have their own logistics network.
However very few sellers have a clear view of how to optimize the warehouse levels of their products whilst reducing their handling costs to a minimum.
To solve this problem you must consider these two factors:
- the costs for restocking orders that diminish as the stocks increase
- the warehouse storage costs that grow as the stocks increase
Costs for restocking orders
Let’s suppose that a certain product has a sales velocity of 11 per day, this means that the annual sales volume is about 4000 units.
This quantity of the product can be ordered in lots, and the smaller the lot the higher the number of lots that will have to be ordered yearly.
For example, you could order 2 lots of 2000 pieces or 20 lots of 200 pieces each.
Each restocking order has fixed costs (that do not depend on the size of the lot) that can be determined according to the work necessary for:
- ordering the goods from the supplier
- handling the billing
- handling the shipment and loading the quantities on seller central
Therefore, the annual restocking cost can be found by multiplying the number of orders by the fixed costs of each order,
Co = Cf * N (Annual cost for handling orders)
Cf (Fixed cost per order) [€]
N = Va / Q (Number of order per year) [orders/year]
Q (Lot Quantity) [units]
Va = Sv * 365 (Annual turnover) [units/year]
Sv (Sales Velocity) [units/day]
Co = Cf * Sv * 365 / Q (annual cost for handling restocking orders)
Continuing with our example, and supposing we have a fixed cost of 50€ per order, we can see how the cost for reordering stock varies according to the quantity of the lot.
The yearly storage cost of a product can be calculated by multiplying the average volume it occupies by the yearly warehouse cost per m3.
Supposing each lot is sold out at the time of arrival of the next lot, the average quantity of the product present in the warehouse will be half the lot.
For example for a lot of 400 pieces, the average quantity in the warehouse is 200 pieces.
If the product with its packaging has a volume of 0,01 m3, then it will occupy and average of 2 m3 of warehouse capacity.
To determine the yearly storage cost we can multiply the volume occupied by the cost per warehouse m3.
In case you are using Amazon Logistics services you can find their storage costs on the following link:
FBA storage costs
If you use your own logistics the warehouse storage cost per m3 will be established by the seller taking for example all the warehouse-related costs of the previous year and dividing them by the overall storage capacity of the warehouse.
At this point we can calculate the yearly storage cost of a product:
Cs = Cm * Vm
Cm (yearly warehouse cost) [€ / m3]
Vm = V * Q / 2 (Average volume occupied by the product) [m3]
V (volume of the product including packaging) [m3]
Cs = Cm * V * Q / 2 (annual storage cost)
With the data of our example and supposing an annual storage cost of 433€/m3
The economic lot
Having the cost for reordering stock and the storage costs that vary according to the quantity of the lot, we can now estimate the overall cost represented by the sum of these 2 amounts:
Overall cost = Cost for reordering stock + Storage cost
The minimum overall cost is obtained when Co is equal to Cs.
Thus we can find the optimal quantity as follows:
Co = Cs
Cf * Sv * 365 / Q = Cm * V * Q / 2 (optimal quantity equation)
Formula for obtaining the optimal reorder quantity and minimizing costs:
In our example:
By activating the optimization of your warehouse levels and choosing the most economic lot for each product based on its sales velocity and size, you will be able to considerably save on the logistics management of your products, whether it is done through FBA or FBM.
Thanks to ZonWizard Analytics Tool you will have the calculation of the optimal level of your stocks and the notifications to reorder the products that are running out, in addition to many more features that will optimize your business on Amazon.
7 thoughts on “FBA or FBM, how to calculate the optimal stock level”
[…] mention that one of the metrics that are essential to obtaining a more satisfactory position is the sales velocity, meaning the number of units sold per […]
[…] program basically offers three main benefits. These are essentially the same as the generality of FBA program benefits, into which category Small and Light […]
[…] the FBA program can push up sales on Amazon by […]
[…] there is also the case of orders handled with Amazon Logistics and free shipping. Oftentimes the customer does not yet receive the order because not all the items […]
[…] Although this may seem superfluous, it is very important that your products always be in stock. […]
[…] set of benefits is reserved for new sellers who use Amazon’s Logistics service. Specifically, these bonuses […]
[…] product is a popular Valentine’s Day gift, you will surely want to ensure maximum profit and you won’t want to run out of stock. In this case, replenishing your inventory abundantly and/or implementing a dynamic pricing […]