Inventory Analytics For Ecommerce Industry
Current Inventory Level by SKU
Shows current inventory levels in comparison to level needed.
Target level of Inventory to fulfil demand
Many companies have different methods to calculate the plan for the inventory. Most common method of planning is based on previous periods’ sales data, taking in consideration seasonality and some reserve.
Number of times Inventory level reached Zero by SKU
Times ‘out of stock’ during a specified period. Shows how good are set the targets for inventory by SKU, if too often ‘out of stock’ means Web-site is losing sales.
Cost Value /1 Unit
Shows the cost associated with SKU including purchase cost, transportation, packaging, storage, handling.
Inventory Value by SKU in currency
Shows the current value of total inventory for the specific SKU.
Cost Value Units Sold
Shows the current value of total sold units for specific SKU.
Inventory days by SKU
Shows in what period of time, usually days, an inventory unit stays until sold.
Returns by SKU, by units, by value
Shows total quantity and value cost per SKU that were returned by customers.
Rate of Returns by SKU
Shows which SKU item has higher return level – to be identified the reasons why this particular position has these issues.
Wastage by SKU by units, by value
Shows cost SKU that cannot be sold due to expiry date or other quality issues.
Rate of Wastage by SKU
Shows which SKU item has higher wastage level – to be identified the reasons why this particular position has these issues.