Inventory Analytics Dashboard
Cost of Goods Sold (COGS)
| Item | Category | Beginning Qty | Beginning Value | Purchases | Purchase Value | Ending Qty | Ending Value | COGS | Sales Qty |
|---|---|---|---|---|---|---|---|---|---|
| Loading... | |||||||||
Inventory Turnover Analysis
Turnover Ratio = COGS / Avg Inventory Value
Higher turnover = faster inventory movement. Days of Inventory shows how long inventory sits before being sold.
Higher turnover = faster inventory movement. Days of Inventory shows how long inventory sits before being sold.
| Item | Category | Avg Inventory Value | COGS | Turnover Ratio | Days of Inventory | Movement Status |
|---|---|---|---|---|---|---|
| Loading... | ||||||
ABC Analysis
ABC Classification:
A High value items (top 80% of usage value) - tight control
B Medium value items (next 15%) - moderate control
C Low value items (remaining 5%) - simple controls
A High value items (top 80% of usage value) - tight control
B Medium value items (next 15%) - moderate control
C Low value items (remaining 5%) - simple controls
| Class | Item | Category | Annual Usage Value | % of Total | Cumulative % | Current Qty | Current Value |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Slow Moving Inventory
| Item | Category | Current Qty | Current Value | Days Since Movement | Last Movement | Recommendation |
|---|---|---|---|---|---|---|
| Loading... | ||||||