Loading metrics…
No metrics computed yet
Click Compute Metrics to calculate monthly Inventory Level KPIs from
tx_material_inward_data,
tx_material_issue_data
&
monthly_material_report.
A. Inventory Level
INVENTORY LEVEL
1. Total Stock Level (% of Monthly Sales)
(Total Sales /[[opening balance+closing balance]/2]) × 100
—
latest month
INVENTORY LEVEL
2. Fast Moving Items (% of Monthly Stock)
(Value of Fast Moving Stock / Total Stock) × 100
—
latest month
INVENTORY LEVEL
3. Slow Moving Items (% of Monthly Stock)
(Value of Slow Moving Stock / Total Stock) × 100
—
latest month
INVENTORY LEVEL
4. Non-Moving Stock Items (% of Monthly Stock)
(Value of Non-Moving Stock / Total Stock) × 100
—
latest month
Dead Stock
INVENTORY LEVEL
5. Dead Stock Items (% of Monthly Stock)
(Value of Dead Stock / Total Stock Value) × 100
—
latest month
STOCK VALUE
Total Closing Stock Value (₹)
Sum of stock_val (close balance × avg unit price)
—
latest month
Month-wise KPI Detail
| Month | Total Stock (₹) | Production Val (₹) | A1: Total Stock % | A2: Fast Moving % | A3: Slow Moving % | A4: Non Moving % | A5: Dead Stock % | Cl. Bal (Units) | Issues (Units) |
|---|