Items / IND-0015
Proximity Sensor Elite IND-0015 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)14MAIN 13, EAST 1
Value (FIFO)3,213.08avg 229.51
ClassCZ / SCV 1.49
Turnover2.8xlast issue 92 days ago
Days of cover183lead 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.33 / 30.4375 | 0.077 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.47 / 5.517 | 0.629 |
| 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.629^2 + 0.077^2 * 1.5^2) | 2.1 |
| Reorder point | d * LT + safety stock | 0.077 * 7.0 + 2.1 | 2.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 2.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 28/yr, S = 45.00, h = 20%, price = 235.17 | 7.3 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 235.17 | 7 | 6,924 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Jan. 9, 2026 | 2 / 12 | 230.75 | 461.50 | |
| July 23, 2026 | 12 / 12 | 229.30 | 2,751.59 |
Movement ledger 16 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| July 23, 2026 | receipt | PO-001667 | MAIN | 12 | 229.30 | 2,751.59 | 14 | 3,213.08 | |
| July 16, 2026 | issue | SO-260716-234 | EAST | 5 | 230.75 | -1,153.74 | 2 | 461.50 | Jan. 9, 2026: 5 @ 230.75 |
| Feb. 2, 2026 | issue | SO-260202-816 | MAIN | 7 | 229.32 | -1,605.23 | 7 | 1,615.24 | Dec. 20, 2025: 2 @ 225.74; Jan. 9, 2026: 5 @ 230.75 |
| Jan. 9, 2026 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Jan. 9, 2026 | receipt | PO-001132 | MAIN | 12 | 230.75 | 2,768.98 | 14 | 3,220.47 | |
| Jan. 5, 2026 | issue | SO-260105-361 | EAST | 1 | 225.74 | -225.74 | 2 | 451.49 | Dec. 20, 2025: 1 @ 225.74 |
| Jan. 5, 2026 | issue | SO-260105-361 | MAIN | 9 | 225.74 | -2,031.69 | 3 | 677.23 | Dec. 20, 2025: 9 @ 225.74 |
| Dec. 20, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Dec. 20, 2025 | receipt | PO-001070 | MAIN | 12 | 225.74 | 2,708.92 | 12 | 2,708.92 | |
| Dec. 13, 2025 | issue | SO-251213-994 | MAIN | 6 | 215.25 | -1,291.47 | 0 | 0.00 | Nov. 18, 2024: 6 @ 215.25 |
| Sept. 22, 2025 | issue | SO-250922-826 | MAIN | 3 | 215.25 | -645.74 | 6 | 1,291.47 | Nov. 18, 2024: 3 @ 215.25 |
| June 17, 2025 | issue | SO-250617-900 | MAIN | 3 | 215.25 | -645.74 | 9 | 1,937.21 | Nov. 18, 2024: 3 @ 215.25 |
| April 12, 2025 | issue | SO-250412-712 | MAIN | 2 | 223.41 | -446.82 | 12 | 2,582.94 | Oct. 1, 2024: 2 @ 223.41 |
| Nov. 18, 2024 | receipt | PO-000038 | MAIN | 12 | 215.25 | 2,582.94 | 14 | 3,029.76 | |
| Nov. 13, 2024 | issue | SO-241113-568 | MAIN | 4 | 223.41 | -893.65 | 2 | 446.82 | Oct. 1, 2024: 4 @ 223.41 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 6 | 223.41 | 1,340.47 | 6 | 1,340.47 | |