Items / IND-0004
Overload Relay Classic IND-0004 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)3MAIN 3
Value (FIFO)1,748.48avg 582.83
ClassCZ / SCV 1.23
Turnover2.5xlast issue 76 days ago
Days of cover122lead time 7d
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.75 / 30.4375 | 0.025 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.92 / 5.517 | 0.168 |
| 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.168^2 + 0.025^2 * 1.5^2) | 0.6 |
| Reorder point | d * LT + safety stock | 0.025 * 7.0 + 0.6 | 0.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 9/yr, S = 45.00, h = 20%, price = 584.40 | 2.6 |
| Inventory position | on hand + on order | 3 + 0 | 3 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 584.40 | 3 | 5,564 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 26, 2026 | 3 / 4 | 582.83 | 1,748.48 |
Movement ledger 15 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Aug. 1, 2026 | issue | SO-260801-837 | MAIN | 2 | 567.87 | -1,135.75 | 3 | 1,748.48 | Dec. 31, 2025: 1 @ 552.92; July 26, 2026: 1 @ 582.83 |
| July 26, 2026 | receipt | PO-001676 | MAIN | 4 | 582.83 | 2,331.30 | 5 | 2,884.22 | |
| July 22, 2026 | issue | SO-260722-219 | MAIN | 2 | 552.92 | -1,105.84 | 1 | 552.92 | Dec. 31, 2025: 2 @ 552.92 |
| April 19, 2026 | issue | SO-260419-334 | MAIN | 1 | 552.92 | -552.92 | 3 | 1,658.76 | Dec. 31, 2025: 1 @ 552.92 |
| Dec. 31, 2025 | receipt | PO-001108 | MAIN | 4 | 552.92 | 2,211.68 | 4 | 2,211.68 | |
| Dec. 24, 2025 | issue | SO-251224-925 | MAIN | 2 | 558.77 | -1,117.54 | 0 | 0.00 | Sept. 12, 2025: 2 @ 558.77 |
| Oct. 22, 2025 | issue | SO-251022-919 | MAIN | 2 | 558.77 | -1,117.54 | 2 | 1,117.54 | Sept. 12, 2025: 2 @ 558.77 |
| Sept. 12, 2025 | receipt | PO-000834 | MAIN | 4 | 558.77 | 2,235.08 | 4 | 2,235.08 | |
| Sept. 5, 2025 | issue | SO-250905-196 | MAIN | 2 | 549.71 | -1,099.42 | 0 | 0.00 | March 5, 2025: 2 @ 549.71 |
| April 25, 2025 | issue | SO-250425-963 | MAIN | 3 | 549.79 | -1,649.36 | 2 | 1,099.42 | Dec. 29, 2024: 1 @ 549.95; March 5, 2025: 2 @ 549.71 |
| March 5, 2025 | receipt | PO-000320 | MAIN | 4 | 549.71 | 2,198.83 | 5 | 2,748.78 | |
| Feb. 25, 2025 | issue | SO-250225-215 | MAIN | 3 | 549.95 | -1,649.85 | 1 | 549.95 | Dec. 29, 2024: 3 @ 549.95 |
| Dec. 29, 2024 | receipt | PO-000148 | MAIN | 4 | 549.95 | 2,199.79 | 4 | 2,199.79 | |
| Dec. 24, 2024 | issue | SO-241224-545 | MAIN | 2 | 555.18 | -1,110.36 | 0 | 0.00 | Oct. 1, 2024: 2 @ 555.18 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 555.18 | 1,110.36 | 2 | 1,110.36 |