Items / IND-0014
Proximity Sensor Flex IND-0014 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)3MAIN 3
Value (FIFO)486.83avg 162.28
ClassCY / FCV 0.88
Turnover5.0xlast issue 10 days ago
Days of cover84lead 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.08 / 30.4375 | 0.036 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.95 / 5.517 | 0.173 |
| 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.173^2 + 0.036^2 * 1.5^2) | 0.6 |
| Reorder point | d * LT + safety stock | 0.036 * 7.0 + 0.6 | 0.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 13/yr, S = 45.00, h = 20%, price = 163.10 | 6.0 |
| 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 | 163.10 | 6 | 2,314 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 14, 2026 | 3 / 3 | 162.28 | 486.83 |
Movement ledger 24 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | receipt | PO-001880 | MAIN | 3 | 162.28 | 486.83 | 3 | 486.83 | |
| Oct. 6, 2026 | issue | SO-261006-214 | MAIN | 2 | 159.34 | -318.68 | 0 | 0.00 | June 16, 2026: 2 @ 159.34 |
| Sept. 16, 2026 | issue | SO-260916-953 | MAIN | 1 | 159.34 | -159.34 | 2 | 318.68 | June 16, 2026: 1 @ 159.34 |
| June 16, 2026 | receipt | PO-001582 | MAIN | 3 | 159.34 | 478.03 | 3 | 478.03 | |
| June 8, 2026 | issue | SO-260608-693 | MAIN | 1 | 163.04 | -163.04 | 0 | 0.00 | Feb. 12, 2026: 1 @ 163.04 |
| May 22, 2026 | issue | SO-260522-911 | MAIN | 2 | 163.04 | -326.09 | 1 | 163.04 | Feb. 12, 2026: 2 @ 163.04 |
| Feb. 12, 2026 | receipt | PO-001222 | MAIN | 3 | 163.04 | 489.13 | 3 | 489.13 | |
| Feb. 6, 2026 | issue | SO-260206-353 | MAIN | 2 | 156.24 | -312.49 | 0 | 0.00 | Jan. 5, 2026: 2 @ 156.24 |
| Jan. 26, 2026 | issue | SO-260126-469 | MAIN | 1 | 156.24 | -156.24 | 2 | 312.49 | Jan. 5, 2026: 1 @ 156.24 |
| Jan. 5, 2026 | receipt | PO-001124 | MAIN | 3 | 156.24 | 468.73 | 3 | 468.73 | |
| Dec. 28, 2025 | issue | SO-251228-433 | MAIN | 1 | 160.03 | -160.03 | 0 | 0.00 | Nov. 4, 2025: 1 @ 160.03 |
| Nov. 20, 2025 | issue | SO-251120-653 | MAIN | 2 | 160.03 | -320.06 | 1 | 160.03 | Nov. 4, 2025: 2 @ 160.03 |
| Nov. 4, 2025 | receipt | PO-000981 | MAIN | 3 | 160.03 | 480.09 | 3 | 480.09 | |
| Oct. 27, 2025 | issue | SO-251027-863 | MAIN | 3 | 156.28 | -468.84 | 0 | 0.00 | Sept. 20, 2025: 3 @ 156.28 |
| Sept. 20, 2025 | receipt | PO-000860 | MAIN | 3 | 156.28 | 468.84 | 3 | 468.84 | |
| Sept. 12, 2025 | issue | SO-250912-273 | MAIN | 1 | 157.89 | -157.89 | 0 | 0.00 | May 12, 2025: 1 @ 157.89 |
| Aug. 11, 2025 | issue | SO-250811-694 | MAIN | 2 | 157.89 | -315.79 | 1 | 157.89 | May 12, 2025: 2 @ 157.89 |
| May 12, 2025 | receipt | PO-000531 | MAIN | 3 | 157.89 | 473.68 | 3 | 473.68 | |
| May 5, 2025 | issue | SO-250505-831 | MAIN | 1 | 155.34 | -155.34 | 0 | 0.00 | Feb. 8, 2025: 1 @ 155.34 |
| March 10, 2025 | issue | SO-250310-305 | MAIN | 2 | 155.34 | -310.67 | 1 | 155.34 | Feb. 8, 2025: 2 @ 155.34 |
| Feb. 8, 2025 | receipt | PO-000249 | MAIN | 3 | 155.34 | 466.01 | 3 | 466.01 | |
| Feb. 3, 2025 | issue | SO-250203-227 | MAIN | 1 | 154.94 | -154.94 | 0 | 0.00 | Oct. 1, 2024: 1 @ 154.94 |
| Jan. 6, 2025 | issue | SO-250106-862 | MAIN | 1 | 154.94 | -154.94 | 1 | 154.94 | Oct. 1, 2024: 1 @ 154.94 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 154.94 | 309.89 | 2 | 309.89 |