Items / IND-0008
Overload Relay Lite IND-0008 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassCZ / FCV 3.32
Turnover2.0xlast issue 4 days ago
Days of cover0lead time 7d
Reorder suggested: 2 units (position at or below reorder point: order EOQ), stockout risk high.
Demand and forecast
actual forecast 90% prediction interval
No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.
Policy numbers explained
| Metric | Formula | Substituted | Result |
|---|---|---|---|
| Daily demand d | monthly mean / 30.4375 | 0.08 / 30.4375 | 0.003 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.28 / 5.517 | 0.050 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(7.0 * 0.050^2 + 0.003^2 * 1.5^2) | 0.2 |
| Reorder point | d * LT + safety stock | 0.003 * 7.0 + 0.2 | 0.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1/yr, S = 45.00, h = 20%, price = 123.98 | 1.9 |
| Inventory position | on hand + on order | 0 + 0 | 0 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 123.98 | 2 | 171 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 16 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-562 | MAIN | 3 | 116.52 | -349.57 | 0 | 0.00 | Aug. 7, 2025: 3 @ 116.52 |
| July 28, 2026 | issue | SO-260728-830 | MAIN | 1 | 116.52 | -116.52 | 3 | 349.57 | Aug. 7, 2025: 1 @ 116.52 |
| Aug. 7, 2025 | receipt | PO-000765 | MAIN | 4 | 116.52 | 466.10 | 4 | 466.10 | |
| Aug. 2, 2025 | issue | SO-250802-173 | MAIN | 4 | 119.41 | -477.63 | 0 | 0.00 | July 26, 2025: 4 @ 119.41 |
| July 26, 2025 | receipt | PO-000736 | MAIN | 4 | 119.41 | 477.63 | 4 | 477.63 | |
| July 19, 2025 | issue | SO-250719-498 | MAIN | 3 | 114.94 | -344.82 | 0 | 0.00 | April 29, 2025: 3 @ 114.94 |
| May 6, 2025 | issue | SO-250506-925 | MAIN | 2 | 115.15 | -230.29 | 3 | 344.82 | Jan. 24, 2025: 1 @ 115.35; April 29, 2025: 1 @ 114.94 |
| April 29, 2025 | receipt | PO-000492 | MAIN | 4 | 114.94 | 459.76 | 5 | 575.12 | |
| April 22, 2025 | issue | SO-250422-971 | MAIN | 3 | 115.35 | -346.06 | 1 | 115.35 | Jan. 24, 2025: 3 @ 115.35 |
| Jan. 24, 2025 | receipt | PO-000213 | MAIN | 4 | 115.35 | 461.41 | 4 | 461.41 | |
| Jan. 14, 2025 | issue | SO-250114-655 | MAIN | 4 | 111.71 | -446.85 | 0 | 0.00 | Nov. 18, 2024: 4 @ 111.71 |
| Nov. 18, 2024 | receipt | PO-000037 | MAIN | 4 | 111.71 | 446.85 | 4 | 446.85 | |
| Nov. 11, 2024 | issue | SO-241111-344 | MAIN | 4 | 114.24 | -456.96 | 0 | 0.00 | Oct. 16, 2024: 4 @ 114.24 |
| Oct. 16, 2024 | receipt | PO-000009 | MAIN | 4 | 114.24 | 456.96 | 4 | 456.96 | |
| Oct. 10, 2024 | issue | SO-241010-819 | MAIN | 2 | 117.78 | -235.56 | 0 | 0.00 | Oct. 1, 2024: 2 @ 117.78 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 117.78 | 235.56 | 2 | 235.56 |