Items / IND-0007
Timer Relay Classic IND-0007 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)1MAIN 1
Value (FIFO)682.11avg 682.11
ClassCZ / NCV 1.87
Turnover4.0xlast issue 281 days ago
Days of cover91lead 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.33 / 30.4375 | 0.011 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.62 / 5.517 | 0.113 |
| 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.113^2 + 0.011^2 * 1.5^2) | 0.4 |
| Reorder point | d * LT + safety stock | 0.011 * 7.0 + 0.4 | 0.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 4/yr, S = 45.00, h = 20%, price = 720.64 | 1.6 |
| Inventory position | on hand + on order | 1 + 0 | 1 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 720.64 | 2 | 3,108 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Jan. 16, 2026 | 1 / 3 | 682.11 | 682.11 |
Movement ledger 12 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| April 30, 2026 | adjustment | Cycle count | MAIN | -2 | 682.11 | -1,364.21 | 1 | 682.11 | Jan. 16, 2026: 2 @ 682.11 |
| Jan. 16, 2026 | receipt | PO-001148 | MAIN | 3 | 682.11 | 2,046.32 | 3 | 2,046.32 | |
| Jan. 8, 2026 | issue | SO-260108-338 | MAIN | 1 | 693.47 | -693.47 | 0 | 0.00 | Nov. 7, 2025: 1 @ 693.47 |
| Dec. 13, 2025 | issue | SO-251213-888 | MAIN | 2 | 693.47 | -1,386.93 | 1 | 693.47 | Nov. 7, 2025: 2 @ 693.47 |
| Nov. 7, 2025 | receipt | PO-000985 | MAIN | 3 | 693.47 | 2,080.40 | 3 | 2,080.40 | |
| Oct. 29, 2025 | issue | SO-251029-846 | MAIN | 1 | 687.65 | -687.65 | 0 | 0.00 | March 25, 2025: 1 @ 687.65 |
| Aug. 31, 2025 | issue | SO-250831-742 | MAIN | 2 | 687.65 | -1,375.31 | 1 | 687.65 | March 25, 2025: 2 @ 687.65 |
| March 25, 2025 | receipt | PO-000380 | MAIN | 3 | 687.65 | 2,062.96 | 3 | 2,062.96 | |
| March 17, 2025 | issue | SO-250317-516 | MAIN | 3 | 687.41 | -2,062.23 | 0 | 0.00 | Feb. 11, 2025: 3 @ 687.41 |
| Feb. 11, 2025 | receipt | PO-000261 | MAIN | 3 | 687.41 | 2,062.23 | 3 | 2,062.23 | |
| Feb. 4, 2025 | issue | SO-250204-250 | MAIN | 2 | 684.61 | -1,369.22 | 0 | 0.00 | Oct. 1, 2024: 2 @ 684.61 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 684.61 | 1,369.22 | 2 | 1,369.22 |