Items / IND-0001
Push Button Station Pro IND-0001 · Industrial Controls · Volta Electricals Pvt Ltd
On hand (EA)5MAIN 5
Value (FIFO)1,078.44avg 215.69
ClassCZ / FCV 1.22
Turnover6.1xlast issue 35 days ago
Days of cover49lead 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 | 3.08 / 30.4375 | 0.101 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.77 / 5.517 | 0.684 |
| 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.684^2 + 0.101^2 * 1.5^2) | 2.3 |
| Reorder point | d * LT + safety stock | 0.101 * 7.0 + 2.3 | 3.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 37/yr, S = 45.00, h = 20%, price = 212.36 | 8.9 |
| 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 | 212.36 | 9 | 8,228 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 4, 2026 | 5 / 12 | 215.69 | 1,078.44 |
Movement ledger 28 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 11, 2026 | issue | SO-260911-655 | MAIN | 8 | 214.09 | -1,712.72 | 5 | 1,078.44 | June 7, 2026: 1 @ 202.90; July 4, 2026: 7 @ 215.69 |
| Aug. 13, 2026 | adjustment | Cycle count | MAIN | -1 | 202.90 | -202.90 | 13 | 2,791.16 | June 7, 2026: 1 @ 202.90 |
| July 4, 2026 | receipt | PO-001625 | MAIN | 12 | 215.69 | 2,588.26 | 14 | 2,994.06 | |
| June 24, 2026 | issue | SO-260624-937 | MAIN | 10 | 202.90 | -2,029.01 | 2 | 405.80 | June 7, 2026: 10 @ 202.90 |
| June 7, 2026 | receipt | PO-001557 | MAIN | 12 | 202.90 | 2,434.81 | 12 | 2,434.81 | |
| May 29, 2026 | issue | SO-260529-186 | MAIN | 6 | 206.79 | -1,240.77 | 0 | 0.00 | Nov. 28, 2025: 6 @ 206.79 |
| May 29, 2026 | issue | SO-260529-186 | EAST | 2 | 206.79 | -413.59 | 6 | 1,240.77 | Nov. 28, 2025: 2 @ 206.79 |
| April 1, 2026 | issue | SO-260401-759 | MAIN | 2 | 206.79 | -413.59 | 8 | 1,654.36 | Nov. 28, 2025: 2 @ 206.79 |
| Feb. 6, 2026 | issue | SO-260206-952 | EAST | 2 | 206.79 | -413.59 | 10 | 2,067.95 | Nov. 28, 2025: 2 @ 206.79 |
| Nov. 28, 2025 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Nov. 28, 2025 | receipt | PO-001023 | MAIN | 12 | 206.79 | 2,481.54 | 12 | 2,481.54 | |
| Nov. 20, 2025 | issue | SO-251120-372 | MAIN | 4 | 203.83 | -815.34 | 0 | 0.00 | Aug. 9, 2025: 4 @ 203.83 |
| Nov. 20, 2025 | issue | SO-251120-372 | EAST | 3 | 203.83 | -611.50 | 4 | 815.34 | Aug. 9, 2025: 3 @ 203.83 |
| Oct. 11, 2025 | adjustment | Cycle count | MAIN | -1 | 203.83 | -203.83 | 7 | 1,426.84 | Aug. 9, 2025: 1 @ 203.83 |
| Sept. 17, 2025 | issue | SO-250917-839 | MAIN | 4 | 203.83 | -815.34 | 8 | 1,630.68 | Aug. 9, 2025: 4 @ 203.83 |
| Aug. 9, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Aug. 9, 2025 | receipt | PO-000767 | MAIN | 12 | 203.83 | 2,446.02 | 12 | 2,446.02 | |
| Aug. 4, 2025 | issue | SO-250804-761 | EAST | 3 | 204.68 | -614.05 | 0 | 0.00 | May 19, 2025: 3 @ 204.68 |
| Aug. 4, 2025 | issue | SO-250804-761 | MAIN | 9 | 204.68 | -1,842.15 | 3 | 614.05 | May 19, 2025: 9 @ 204.68 |
| May 19, 2025 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| May 19, 2025 | receipt | PO-000551 | MAIN | 12 | 204.68 | 2,456.20 | 12 | 2,456.20 | |
| May 13, 2025 | issue | SO-250513-306 | MAIN | 7 | 195.12 | -1,365.81 | 0 | 0.00 | Oct. 11, 2024: 5 @ 192.47; Oct. 21, 2024: 2 @ 201.74 |
| April 17, 2025 | issue | SO-250417-246 | MAIN | 7 | 192.47 | -1,347.26 | 7 | 1,365.81 | Oct. 11, 2024: 7 @ 192.47 |
| Jan. 12, 2025 | issue | SO-250112-723 | MAIN | 2 | 201.74 | -403.48 | 14 | 2,713.07 | Oct. 1, 2024: 2 @ 201.74 |
| Oct. 21, 2024 | return | RMA | MAIN | 2 | 201.74 | 403.48 | 16 | 3,116.55 | |
| Oct. 11, 2024 | receipt | PO-000007 | MAIN | 12 | 192.47 | 2,309.58 | 14 | 2,713.07 | |
| Oct. 4, 2024 | issue | SO-241004-174 | MAIN | 4 | 201.74 | -806.97 | 2 | 403.48 | Oct. 1, 2024: 4 @ 201.74 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 6 | 201.74 | 1,210.45 | 6 | 1,210.45 | |