Items / IND-0009
Timer Relay Nova IND-0009 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)6MAIN 6
Value (FIFO)3,372.99avg 562.17
ClassBZ / FCV 1.41
Turnover3.7xlast issue 15 days ago
Days of cover137lead 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 | 1.33 / 30.4375 | 0.044 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.89 / 5.517 | 0.342 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(7.0 * 0.342^2 + 0.044^2 * 1.5^2) | 1.5 |
| Reorder point | d * LT + safety stock | 0.044 * 7.0 + 1.5 | 1.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 16/yr, S = 45.00, h = 20%, price = 561.30 | 3.6 |
| Inventory position | on hand + on order | 6 + 0 | 6 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 561.30 | 4 | 9,377 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 5, 2026 | 6 / 6 | 562.17 | 3,372.99 |
Movement ledger 20 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 5, 2026 | receipt | PO-001852 | MAIN | 6 | 562.17 | 3,372.99 | 6 | 3,372.99 | |
| Oct. 1, 2026 | issue | SO-261001-785 | MAIN | 6 | 554.73 | -3,328.40 | 0 | 0.00 | June 12, 2026: 6 @ 554.73 |
| June 12, 2026 | receipt | PO-001569 | MAIN | 6 | 554.73 | 3,328.40 | 6 | 3,328.40 | |
| June 6, 2026 | issue | SO-260606-202 | MAIN | 2 | 564.76 | -1,129.53 | 0 | 0.00 | April 25, 2026: 2 @ 564.76 |
| May 25, 2026 | issue | SO-260525-456 | MAIN | 2 | 564.76 | -1,129.53 | 2 | 1,129.53 | April 25, 2026: 2 @ 564.76 |
| May 20, 2026 | adjustment | Cycle count | MAIN | -2 | 564.76 | -1,129.53 | 4 | 2,259.05 | April 25, 2026: 2 @ 564.76 |
| April 25, 2026 | receipt | PO-001439 | MAIN | 6 | 564.76 | 3,388.58 | 6 | 3,388.58 | |
| April 21, 2026 | issue | SO-260421-380 | MAIN | 6 | 546.41 | -3,278.43 | 0 | 0.00 | March 6, 2026: 6 @ 546.41 |
| March 6, 2026 | receipt | PO-001292 | MAIN | 6 | 546.41 | 3,278.43 | 6 | 3,278.43 | |
| Feb. 28, 2026 | issue | SO-260228-192 | MAIN | 4 | 544.33 | -2,177.34 | 0 | 0.00 | Sept. 18, 2025: 4 @ 544.33 |
| Nov. 30, 2025 | issue | SO-251130-892 | MAIN | 2 | 544.33 | -1,088.67 | 4 | 2,177.34 | Sept. 18, 2025: 2 @ 544.33 |
| Sept. 18, 2025 | receipt | PO-000856 | MAIN | 6 | 544.33 | 3,266.01 | 6 | 3,266.01 | |
| Sept. 9, 2025 | issue | SO-250909-344 | MAIN | 6 | 540.14 | -3,240.83 | 0 | 0.00 | April 23, 2025: 6 @ 540.14 |
| April 23, 2025 | receipt | PO-000477 | MAIN | 6 | 540.14 | 3,240.83 | 6 | 3,240.83 | |
| April 20, 2025 | issue | SO-250420-267 | MAIN | 6 | 539.73 | -3,238.38 | 0 | 0.00 | March 29, 2025: 6 @ 539.73 |
| March 29, 2025 | receipt | PO-000391 | MAIN | 6 | 539.73 | 3,238.38 | 6 | 3,238.38 | |
| March 21, 2025 | issue | SO-250321-140 | MAIN | 6 | 521.62 | -3,129.74 | 0 | 0.00 | Nov. 23, 2024: 6 @ 521.62 |
| Nov. 23, 2024 | receipt | PO-000058 | MAIN | 6 | 521.62 | 3,129.74 | 6 | 3,129.74 | |
| Nov. 14, 2024 | issue | SO-241114-871 | MAIN | 3 | 533.24 | -1,599.70 | 0 | 0.00 | Oct. 1, 2024: 3 @ 533.24 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 3 | 533.24 | 1,599.70 | 3 | 1,599.70 |