Items / IND-0006
Timer Relay Plus IND-0006 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)3MAIN 3
Value (FIFO)479.33avg 159.78
ClassCZ / SCV 3.32
Turnover0.3xlast issue 16 days ago
Days of cover1,096lead 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.08 / 30.4375 | 0.003 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.28 / 5.517 | 0.050 |
| 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.050^2 + 0.003^2 * 1.5^2) | 0.2 |
| Reorder point | d * LT + safety stock | 0.003 * 7.0 + 0.2 | 0.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1/yr, S = 45.00, h = 20%, price = 161.88 | 1.7 |
| 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 | 161.88 | 2 | 216 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 10, 2026 | 3 / 3 | 159.78 | 479.33 |
Movement ledger 7 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | receipt | PO-001865 | MAIN | 3 | 159.78 | 479.33 | 3 | 479.33 | |
| Sept. 30, 2026 | issue | SO-260930-332 | MAIN | 1 | 156.99 | -156.99 | 0 | 0.00 | Sept. 12, 2025: 1 @ 156.99 |
| April 3, 2026 | adjustment | Cycle count | MAIN | -2 | 156.99 | -313.98 | 1 | 156.99 | Sept. 12, 2025: 2 @ 156.99 |
| Sept. 12, 2025 | receipt | PO-000835 | MAIN | 3 | 156.99 | 470.97 | 3 | 470.97 | |
| Sept. 6, 2025 | issue | SO-250906-151 | MAIN | 1 | 153.79 | -153.79 | 0 | 0.00 | Oct. 1, 2024: 1 @ 153.79 |
| Dec. 31, 2024 | issue | SO-241231-274 | MAIN | 1 | 153.79 | -153.79 | 1 | 153.79 | Oct. 1, 2024: 1 @ 153.79 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 153.79 | 307.57 | 2 | 307.57 |