Items / IND-0003
Proximity Sensor Classic IND-0003 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)1MAIN 1
Value (FIFO)193.57avg 193.57
ClassCZ / FCV 1.27
Turnover4.0xlast issue 37 days ago
Days of cover46lead 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.67 / 30.4375 | 0.022 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.85 / 5.517 | 0.154 |
| 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.154^2 + 0.022^2 * 1.5^2) | 0.5 |
| Reorder point | d * LT + safety stock | 0.022 * 7.0 + 0.5 | 0.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 8/yr, S = 45.00, h = 20%, price = 198.63 | 4.3 |
| 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 | 198.63 | 4 | 1,757 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 6, 2026 | 1 / 3 | 193.57 | 193.57 |
Movement ledger 17 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 9, 2026 | issue | SO-260909-297 | MAIN | 1 | 193.57 | -193.57 | 1 | 193.57 | April 6, 2026: 1 @ 193.57 |
| Aug. 24, 2026 | issue | SO-260824-203 | MAIN | 1 | 193.57 | -193.57 | 2 | 387.14 | April 6, 2026: 1 @ 193.57 |
| April 6, 2026 | receipt | PO-001389 | MAIN | 3 | 193.57 | 580.71 | 3 | 580.71 | |
| March 30, 2026 | issue | SO-260330-338 | MAIN | 3 | 190.81 | -572.43 | 0 | 0.00 | Jan. 30, 2026: 3 @ 190.81 |
| Jan. 30, 2026 | receipt | PO-001188 | MAIN | 3 | 190.81 | 572.43 | 3 | 572.43 | |
| Jan. 25, 2026 | issue | SO-260125-187 | MAIN | 1 | 191.41 | -191.41 | 0 | 0.00 | Aug. 9, 2025: 1 @ 191.41 |
| Dec. 27, 2025 | issue | SO-251227-540 | MAIN | 1 | 191.41 | -191.41 | 1 | 191.41 | Aug. 9, 2025: 1 @ 191.41 |
| Oct. 22, 2025 | issue | SO-251022-240 | MAIN | 1 | 191.41 | -191.41 | 2 | 382.82 | Aug. 9, 2025: 1 @ 191.41 |
| Aug. 9, 2025 | receipt | PO-000768 | MAIN | 3 | 191.41 | 574.23 | 3 | 574.23 | |
| Aug. 3, 2025 | issue | SO-250803-979 | MAIN | 3 | 183.41 | -550.24 | 0 | 0.00 | April 3, 2025: 3 @ 183.41 |
| April 3, 2025 | receipt | PO-000409 | MAIN | 3 | 183.41 | 550.24 | 3 | 550.24 | |
| March 29, 2025 | issue | SO-250329-890 | MAIN | 3 | 180.29 | -540.87 | 0 | 0.00 | Feb. 16, 2025: 3 @ 180.29 |
| Feb. 16, 2025 | receipt | PO-000271 | MAIN | 3 | 180.29 | 540.87 | 3 | 540.87 | |
| Feb. 8, 2025 | issue | SO-250208-471 | MAIN | 3 | 184.60 | -553.80 | 0 | 0.00 | Dec. 16, 2024: 3 @ 184.60 |
| Dec. 16, 2024 | receipt | PO-000110 | MAIN | 3 | 184.60 | 553.80 | 3 | 553.80 | |
| Dec. 8, 2024 | issue | SO-241208-783 | MAIN | 2 | 188.70 | -377.40 | 0 | 0.00 | Oct. 1, 2024: 2 @ 188.70 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 188.70 | 377.40 | 2 | 377.40 |