Items / IND-0013
Contactor 25A Pro IND-0013 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)11MAIN 8, EAST 3
Value (FIFO)3,575.41avg 325.04
ClassCZ / FCV 1.29
Turnover3.4xlast issue 24 days ago
Days of cover155lead 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 | 2.17 / 30.4375 | 0.071 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.79 / 5.517 | 0.506 |
| 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.506^2 + 0.071^2 * 1.5^2) | 1.7 |
| Reorder point | d * LT + safety stock | 0.071 * 7.0 + 1.7 | 2.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 2.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 26/yr, S = 45.00, h = 20%, price = 330.91 | 5.9 |
| Inventory position | on hand + on order | 11 + 0 | 11 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 330.91 | 6 | 8,991 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 29, 2026 | 11 / 11 | 325.04 | 3,575.41 |
Movement ledger 29 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 29, 2026 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Sept. 29, 2026 | receipt | PO-001841 | MAIN | 11 | 325.04 | 3,575.41 | 11 | 3,575.41 | |
| Sept. 22, 2026 | issue | SO-260922-892 | EAST | 2 | 319.20 | -638.41 | 0 | 0.00 | April 4, 2026: 2 @ 319.20 |
| Sept. 22, 2026 | issue | SO-260922-892 | MAIN | 6 | 319.20 | -1,915.23 | 2 | 638.41 | April 4, 2026: 6 @ 319.20 |
| June 5, 2026 | issue | SO-260605-779 | MAIN | 6 | 317.69 | -1,906.14 | 8 | 2,553.63 | Dec. 1, 2025: 3 @ 316.17; April 4, 2026: 3 @ 319.20 |
| April 4, 2026 | transfer | TRF | MAIN → EAST | 2 | warehouse transfer, no cost effect | ||||
| April 4, 2026 | receipt | PO-001385 | MAIN | 11 | 319.20 | 3,511.25 | 14 | 4,459.77 | |
| March 29, 2026 | issue | SO-260329-816 | MAIN | 3 | 316.17 | -948.52 | 3 | 948.52 | Dec. 1, 2025: 3 @ 316.17 |
| Jan. 30, 2026 | issue | SO-260130-514 | MAIN | 6 | 315.56 | -1,893.35 | 6 | 1,897.05 | June 12, 2025: 1 @ 312.48; Dec. 1, 2025: 5 @ 316.17 |
| Dec. 3, 2025 | issue | SO-251203-640 | MAIN | 1 | 312.48 | -312.48 | 12 | 3,790.40 | June 12, 2025: 1 @ 312.48 |
| Dec. 1, 2025 | receipt | PO-001029 | MAIN | 11 | 316.17 | 3,477.92 | 13 | 4,102.88 | |
| Nov. 23, 2025 | issue | SO-251123-148 | MAIN | 2 | 312.48 | -624.96 | 2 | 624.96 | June 12, 2025: 2 @ 312.48 |
| Sept. 21, 2025 | issue | SO-250921-515 | MAIN | 3 | 312.48 | -937.44 | 4 | 1,249.92 | June 12, 2025: 3 @ 312.48 |
| Aug. 27, 2025 | issue | SO-250827-279 | MAIN | 4 | 312.48 | -1,249.92 | 7 | 2,187.36 | June 12, 2025: 4 @ 312.48 |
| June 12, 2025 | receipt | PO-000630 | MAIN | 11 | 312.48 | 3,437.28 | 11 | 3,437.28 | |
| June 3, 2025 | issue | SO-250603-903 | MAIN | 11 | 314.03 | -3,454.28 | 0 | 0.00 | May 14, 2025: 11 @ 314.03 |
| May 14, 2025 | receipt | PO-000536 | MAIN | 11 | 314.03 | 3,454.28 | 11 | 3,454.28 | |
| May 6, 2025 | issue | SO-250506-878 | MAIN | 5 | 299.29 | -1,496.44 | 0 | 0.00 | Feb. 13, 2025: 5 @ 299.29 |
| May 6, 2025 | issue | SO-250506-878 | EAST | 3 | 299.29 | -897.86 | 5 | 1,496.44 | Feb. 13, 2025: 3 @ 299.29 |
| April 28, 2025 | issue | SO-250428-206 | MAIN | 4 | 300.14 | -1,200.55 | 8 | 2,394.31 | Jan. 13, 2025: 1 @ 302.68; Feb. 13, 2025: 3 @ 299.29 |
| Feb. 13, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Feb. 13, 2025 | receipt | PO-000265 | MAIN | 11 | 299.29 | 3,292.17 | 12 | 3,594.85 | |
| Feb. 5, 2025 | issue | SO-250205-685 | MAIN | 10 | 302.68 | -3,026.82 | 1 | 302.68 | Jan. 13, 2025: 10 @ 302.68 |
| Jan. 13, 2025 | receipt | PO-000183 | MAIN | 11 | 302.68 | 3,329.50 | 11 | 3,329.50 | |
| Jan. 6, 2025 | issue | SO-250106-345 | MAIN | 10 | 311.70 | -3,116.96 | 0 | 0.00 | Dec. 20, 2024: 10 @ 311.70 |
| Dec. 20, 2024 | adjustment | Cycle count | MAIN | -1 | 311.70 | -311.70 | 10 | 3,116.96 | Dec. 20, 2024: 1 @ 311.70 |
| Dec. 20, 2024 | receipt | PO-000123 | MAIN | 11 | 311.70 | 3,428.65 | 11 | 3,428.65 | |
| Dec. 14, 2024 | issue | SO-241214-178 | MAIN | 6 | 314.36 | -1,886.19 | 0 | 0.00 | Oct. 1, 2024: 6 @ 314.36 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 6 | 314.36 | 1,886.19 | 6 | 1,886.19 | |