Inventory Management for Consumer Packed Goods
Current Inventory Level by SKU
Shows current Inventory Levels in comparison to levels needed.
Target level of Inventory to fulfill demand
Many companies have different methods to calculate 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 Retailer is losing sales.
Cost Value per 1 Unit
Shows the cost associated with SKUs 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.