Items / IND-0012
Push Button Station Lite IND-0012 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)12MAIN 12
Value (FIFO)1,557.31avg 129.78
ClassCZ / SCV 1.27
Turnover3.7xlast issue 107 days ago
Days of cover86lead 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 | 4.25 / 30.4375 | 0.140 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.40 / 5.517 | 0.979 |
| 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.979^2 + 0.140^2 * 1.5^2) | 3.3 |
| Reorder point | d * LT + safety stock | 0.140 * 7.0 + 3.3 | 4.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 4.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 51/yr, S = 45.00, h = 20%, price = 127.99 | 13.4 |
| Inventory position | on hand + on order | 12 + 0 | 12 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 127.99 | 13 | 6,866 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 8, 2026 | 12 / 12 | 129.78 | 1,557.31 |
Movement ledger 30 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| July 8, 2026 | receipt | PO-001635 | MAIN | 12 | 129.78 | 1,557.31 | 12 | 1,557.31 | |
| July 1, 2026 | issue | SO-260701-995 | MAIN | 15 | 123.83 | -1,857.39 | 0 | 0.00 | March 13, 2026: 3 @ 125.91; June 14, 2026: 12 @ 123.30 |
| June 14, 2026 | receipt | PO-001572 | MAIN | 12 | 123.30 | 1,479.65 | 15 | 1,857.39 | |
| June 7, 2026 | issue | SO-260607-847 | MAIN | 6 | 125.91 | -755.48 | 3 | 377.74 | March 13, 2026: 6 @ 125.91 |
| June 7, 2026 | issue | SO-260607-847 | EAST | 3 | 125.91 | -377.74 | 9 | 1,133.23 | March 13, 2026: 3 @ 125.91 |
| March 13, 2026 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| March 13, 2026 | receipt | PO-001315 | MAIN | 12 | 125.91 | 1,510.97 | 12 | 1,510.97 | |
| March 8, 2026 | issue | SO-260308-888 | MAIN | 12 | 125.31 | -1,503.66 | 0 | 0.00 | Feb. 18, 2026: 12 @ 125.31 |
| Feb. 18, 2026 | receipt | PO-001239 | MAIN | 12 | 125.31 | 1,503.66 | 12 | 1,503.66 | |
| Feb. 11, 2026 | issue | SO-260211-268 | MAIN | 6 | 124.82 | -748.90 | 0 | 0.00 | Oct. 7, 2025: 6 @ 124.82 |
| Feb. 11, 2026 | issue | SO-260211-268 | EAST | 3 | 124.82 | -374.45 | 6 | 748.90 | Oct. 7, 2025: 3 @ 124.82 |
| Dec. 26, 2025 | issue | SO-251226-473 | MAIN | 6 | 121.36 | -728.14 | 9 | 1,123.35 | June 28, 2025: 3 @ 117.90; Oct. 7, 2025: 3 @ 124.82 |
| Oct. 7, 2025 | receipt | PO-000906 | MAIN | 12 | 124.82 | 1,497.80 | 15 | 1,851.49 | |
| Sept. 30, 2025 | issue | SO-250930-676 | MAIN | 8 | 117.90 | -943.17 | 3 | 353.69 | June 28, 2025: 8 @ 117.90 |
| July 28, 2025 | issue | SO-250728-228 | EAST | 1 | 117.90 | -117.90 | 11 | 1,296.86 | June 28, 2025: 1 @ 117.90 |
| June 28, 2025 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| June 28, 2025 | receipt | PO-000672 | MAIN | 12 | 117.90 | 1,414.76 | 12 | 1,414.76 | |
| June 24, 2025 | issue | SO-250624-990 | EAST | 3 | 120.82 | -362.46 | 0 | 0.00 | May 19, 2025: 3 @ 120.82 |
| June 24, 2025 | issue | SO-250624-990 | MAIN | 11 | 120.76 | -1,328.37 | 3 | 362.46 | May 16, 2025: 2 @ 120.49; May 19, 2025: 9 @ 120.82 |
| May 19, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| May 19, 2025 | receipt | PO-000551 | MAIN | 12 | 120.82 | 1,449.84 | 14 | 1,690.83 | |
| May 16, 2025 | return | RMA | MAIN | 2 | 120.49 | 240.99 | 2 | 240.99 | |
| May 13, 2025 | issue | SO-250513-672 | EAST | 4 | 120.49 | -481.98 | 0 | 0.00 | Feb. 19, 2025: 4 @ 120.49 |
| May 13, 2025 | issue | SO-250513-672 | MAIN | 5 | 120.49 | -602.47 | 4 | 481.98 | Feb. 19, 2025: 5 @ 120.49 |
| March 9, 2025 | issue | SO-250309-707 | MAIN | 5 | 120.93 | -604.67 | 9 | 1,084.45 | Oct. 1, 2024: 2 @ 121.59; Feb. 19, 2025: 3 @ 120.49 |
| Feb. 19, 2025 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Feb. 19, 2025 | receipt | PO-000282 | MAIN | 12 | 120.49 | 1,445.94 | 14 | 1,689.12 | |
| Feb. 13, 2025 | issue | SO-250213-429 | MAIN | 2 | 121.59 | -243.18 | 2 | 243.18 | Oct. 1, 2024: 2 @ 121.59 |
| Dec. 30, 2024 | issue | SO-241230-225 | MAIN | 2 | 121.59 | -243.18 | 4 | 486.36 | Oct. 1, 2024: 2 @ 121.59 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 6 | 121.59 | 729.54 | 6 | 729.54 | |