Items / IND-0010
Proximity Sensor Eco IND-0010 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)5MAIN 5
Value (FIFO)1,546.31avg 309.26
ClassCZ / SCV 1.54
Turnover1.3xlast issue 82 days ago
Days of cover365lead 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.42 / 30.4375 | 0.014 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.64 / 5.517 | 0.116 |
| 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.116^2 + 0.014^2 * 1.5^2) | 0.4 |
| Reorder point | d * LT + safety stock | 0.014 * 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 = 5/yr, S = 45.00, h = 20%, price = 305.72 | 2.7 |
| Inventory position | on hand + on order | 5 + 0 | 5 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 305.72 | 3 | 1,693 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 6, 2026 | 1 / 4 | 298.96 | 298.96 | |
| Aug. 2, 2026 | 4 / 4 | 311.84 | 1,247.35 |
Movement ledger 18 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Aug. 2, 2026 | receipt | PO-001693 | MAIN | 4 | 311.84 | 1,247.35 | 5 | 1,546.31 | |
| July 26, 2026 | issue | SO-260726-367 | MAIN | 1 | 298.96 | -298.96 | 1 | 298.96 | June 6, 2026: 1 @ 298.96 |
| June 23, 2026 | adjustment | Cycle count | MAIN | -2 | 298.96 | -597.92 | 2 | 597.92 | June 6, 2026: 2 @ 298.96 |
| June 8, 2026 | issue | SO-260608-223 | MAIN | 1 | 279.94 | -279.94 | 4 | 1,195.84 | Jan. 18, 2026: 1 @ 279.94 |
| June 6, 2026 | receipt | PO-001552 | MAIN | 4 | 298.96 | 1,195.84 | 5 | 1,475.78 | |
| May 27, 2026 | issue | SO-260527-250 | MAIN | 2 | 284.45 | -568.89 | 1 | 279.94 | April 19, 2025: 1 @ 279.94; April 24, 2025: 1 @ 288.96 |
| Jan. 18, 2026 | return | RMA | MAIN | 1 | 279.94 | 279.94 | 3 | 848.83 | |
| Jan. 2, 2026 | issue | SO-260102-304 | MAIN | 2 | 279.94 | -559.87 | 2 | 568.89 | April 19, 2025: 2 @ 279.94 |
| July 3, 2025 | issue | SO-250703-727 | MAIN | 1 | 279.94 | -279.94 | 4 | 1,128.77 | April 19, 2025: 1 @ 279.94 |
| April 24, 2025 | return | RMA | MAIN | 1 | 288.96 | 288.96 | 5 | 1,408.70 | |
| April 19, 2025 | receipt | PO-000463 | MAIN | 4 | 279.94 | 1,119.75 | 4 | 1,119.75 | |
| April 12, 2025 | issue | SO-250412-462 | MAIN | 2 | 288.96 | -577.91 | 0 | 0.00 | Nov. 2, 2024: 1 @ 288.96; Nov. 13, 2024: 1 @ 288.96 |
| Feb. 5, 2025 | issue | SO-250205-812 | MAIN | 1 | 288.96 | -288.96 | 2 | 577.91 | Nov. 2, 2024: 1 @ 288.96 |
| Nov. 13, 2024 | return | RMA | MAIN | 1 | 288.96 | 288.96 | 3 | 866.87 | |
| Nov. 3, 2024 | issue | SO-241103-391 | MAIN | 2 | 288.96 | -577.91 | 2 | 577.91 | Nov. 2, 2024: 2 @ 288.96 |
| Nov. 2, 2024 | receipt | PO-000021 | MAIN | 4 | 288.96 | 1,155.82 | 4 | 1,155.82 | |
| Oct. 27, 2024 | issue | SO-241027-541 | MAIN | 2 | 290.43 | -580.87 | 0 | 0.00 | Oct. 1, 2024: 2 @ 290.43 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 2 | 290.43 | 580.87 | 2 | 580.87 |