Items / IND-0002
Contactor 25A Eco IND-0002 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)7MAIN 7
Value (FIFO)3,143.05avg 449.01
ClassCZ / SCV 2.04
Turnover1.0xlast issue 172 days ago
Days of cover365lead 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.58 / 30.4375 | 0.019 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.19 / 5.517 | 0.215 |
| 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.215^2 + 0.019^2 * 1.5^2) | 0.7 |
| Reorder point | d * LT + safety stock | 0.019 * 7.0 + 0.7 | 0.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 7/yr, S = 45.00, h = 20%, price = 452.67 | 2.6 |
| Inventory position | on hand + on order | 7 + 0 | 7 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 452.67 | 3 | 3,405 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 3, 2026 | 7 / 7 | 449.01 | 3,143.05 |
Movement ledger 18 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| May 3, 2026 | receipt | PO-001461 | MAIN | 7 | 449.01 | 3,143.05 | 7 | 3,143.05 | |
| April 27, 2026 | issue | SO-260427-973 | MAIN | 4 | 438.71 | -1,754.83 | 0 | 0.00 | June 14, 2025: 4 @ 438.71 |
| Feb. 10, 2026 | issue | SO-260210-425 | MAIN | 1 | 438.71 | -438.71 | 4 | 1,754.83 | June 14, 2025: 1 @ 438.71 |
| Dec. 14, 2025 | issue | SO-251214-713 | MAIN | 2 | 438.71 | -877.41 | 5 | 2,193.54 | June 14, 2025: 2 @ 438.71 |
| June 14, 2025 | receipt | PO-000636 | MAIN | 7 | 438.71 | 3,070.95 | 7 | 3,070.95 | |
| June 9, 2025 | issue | SO-250609-370 | MAIN | 5 | 414.61 | -2,073.05 | 0 | 0.00 | April 17, 2025: 5 @ 414.61 |
| May 22, 2025 | issue | SO-250522-794 | MAIN | 1 | 414.61 | -414.61 | 5 | 2,073.05 | April 17, 2025: 1 @ 414.61 |
| May 5, 2025 | adjustment | Cycle count | MAIN | -2 | 421.97 | -843.94 | 6 | 2,487.66 | Feb. 1, 2025: 1 @ 429.33; April 17, 2025: 1 @ 414.61 |
| April 17, 2025 | receipt | PO-000458 | MAIN | 7 | 414.61 | 2,902.27 | 8 | 3,331.60 | |
| April 9, 2025 | issue | SO-250409-573 | MAIN | 5 | 429.33 | -2,146.66 | 1 | 429.33 | Feb. 1, 2025: 5 @ 429.33 |
| Feb. 17, 2025 | issue | SO-250217-887 | MAIN | 1 | 429.33 | -429.33 | 6 | 2,575.99 | Feb. 1, 2025: 1 @ 429.33 |
| Feb. 1, 2025 | receipt | PO-000233 | MAIN | 7 | 429.33 | 3,005.32 | 7 | 3,005.32 | |
| Jan. 24, 2025 | issue | SO-250124-920 | MAIN | 7 | 430.28 | -3,011.94 | 0 | 0.00 | Dec. 12, 2024: 7 @ 430.28 |
| Dec. 12, 2024 | receipt | PO-000098 | MAIN | 7 | 430.28 | 3,011.94 | 7 | 3,011.94 | |
| Dec. 6, 2024 | issue | SO-241206-296 | MAIN | 8 | 409.22 | -3,273.74 | 0 | 0.00 | Oct. 1, 2024: 1 @ 430.04; Nov. 19, 2024: 7 @ 406.24 |
| Nov. 19, 2024 | receipt | PO-000044 | MAIN | 7 | 406.24 | 2,843.70 | 8 | 3,273.74 | |
| Nov. 13, 2024 | issue | SO-241113-180 | MAIN | 3 | 430.04 | -1,290.11 | 1 | 430.04 | Oct. 1, 2024: 3 @ 430.04 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 4 | 430.04 | 1,720.15 | 4 | 1,720.15 |