Items / SWT-0016
Socket 5-pin Nova SWT-0016 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)350MAIN 305, EAST 45
Value (FIFO)11,977.91avg 34.22
ClassAX / FCV 0.21
Turnover4.8xlast issue 8 days ago
Days of cover74lead 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 | 143.67 / 30.4375 | 4.720 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 29.90 / 5.517 | 5.419 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(7.0 * 5.419^2 + 4.720^2 * 1.5^2) | 33.0 |
| Reorder point | d * LT + safety stock | 4.720 * 7.0 + 33.0 | 65.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 65.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1723/yr, S = 45.00, h = 20%, price = 32.16 | 860.0 |
| Inventory position | on hand + on order | 350 + 0 | 350 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 33.50 | 152 | 58,734 | yes |
| 860 | 32.16 | 860 | 58,262 | yes (chosen if cheapest) |
| 1,720 | 30.82 | 1,720 | 58,443 | yes |
MOQ 430, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 21, 2026 | 350 / 430 | 34.22 | 11,977.91 |
Movement ledger 131 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 8, 2026 | issue | SO-261008-397 | MAIN | 125 | 33.82 | -4,228.06 | 350 | 11,977.91 | June 22, 2026: 45 @ 33.12; Sept. 21, 2026: 80 @ 34.22 |
| Sept. 21, 2026 | receipt | PO-001818 | MAIN | 430 | 34.22 | 14,715.72 | 475 | 16,205.97 | |
| Sept. 15, 2026 | issue | SO-260915-819 | EAST | 14 | 33.12 | -463.64 | 45 | 1,490.26 | June 22, 2026: 14 @ 33.12 |
| Sept. 15, 2026 | issue | SO-260915-819 | MAIN | 127 | 33.12 | -4,205.83 | 59 | 1,953.89 | June 22, 2026: 127 @ 33.12 |
| Aug. 30, 2026 | issue | SO-260830-623 | MAIN | 6 | 33.12 | -198.70 | 186 | 6,159.72 | June 22, 2026: 6 @ 33.12 |
| Aug. 29, 2026 | issue | SO-260829-822 | EAST | 13 | 33.12 | -430.52 | 192 | 6,358.43 | June 22, 2026: 13 @ 33.12 |
| Aug. 16, 2026 | issue | SO-260816-872 | MAIN | 32 | 33.12 | -1,059.74 | 205 | 6,788.94 | June 22, 2026: 32 @ 33.12 |
| Aug. 5, 2026 | issue | SO-260805-291 | MAIN | 62 | 33.12 | -2,053.24 | 237 | 7,848.68 | June 22, 2026: 62 @ 33.12 |
| July 21, 2026 | issue | SO-260721-770 | MAIN | 64 | 33.12 | -2,119.48 | 299 | 9,901.92 | June 22, 2026: 64 @ 33.12 |
| July 20, 2026 | issue | SO-260720-856 | EAST | 7 | 33.12 | -231.82 | 363 | 12,021.40 | June 22, 2026: 7 @ 33.12 |
| July 9, 2026 | issue | SO-260709-834 | MAIN | 27 | 33.12 | -894.15 | 370 | 12,253.22 | June 22, 2026: 27 @ 33.12 |
| July 3, 2026 | issue | SO-260703-668 | EAST | 8 | 33.12 | -264.93 | 397 | 13,147.37 | June 22, 2026: 8 @ 33.12 |
| July 2, 2026 | issue | SO-260702-958 | MAIN | 25 | 33.12 | -827.92 | 405 | 13,412.30 | June 22, 2026: 25 @ 33.12 |
| June 22, 2026 | transfer | TRF | MAIN → EAST | 87 | warehouse transfer, no cost effect | ||||
| June 22, 2026 | receipt | PO-001594 | MAIN | 430 | 33.12 | 14,240.22 | 430 | 14,240.22 | |
| June 15, 2026 | issue | SO-260615-293 | MAIN | 67 | 32.27 | -2,162.28 | 0 | 0.00 | April 3, 2026: 67 @ 32.27 |
| June 11, 2026 | issue | SO-260611-640 | MAIN | 66 | 32.27 | -2,130.01 | 67 | 2,162.28 | April 3, 2026: 66 @ 32.27 |
| June 8, 2026 | issue | SO-260608-349 | MAIN | 32 | 32.27 | -1,032.73 | 133 | 4,292.30 | April 3, 2026: 32 @ 32.27 |
| June 8, 2026 | issue | SO-260608-349 | EAST | 35 | 32.27 | -1,129.55 | 165 | 5,325.03 | April 3, 2026: 35 @ 32.27 |
| May 28, 2026 | issue | SO-260528-329 | MAIN | 7 | 32.27 | -225.91 | 200 | 6,454.58 | April 3, 2026: 7 @ 32.27 |
| May 18, 2026 | issue | SO-260518-362 | MAIN | 5 | 32.27 | -161.36 | 207 | 6,680.49 | April 3, 2026: 5 @ 32.27 |
| May 9, 2026 | issue | SO-260509-673 | EAST | 49 | 32.27 | -1,581.37 | 212 | 6,841.85 | April 3, 2026: 49 @ 32.27 |
| May 4, 2026 | issue | SO-260504-664 | MAIN | 10 | 32.27 | -322.73 | 261 | 8,423.23 | April 3, 2026: 10 @ 32.27 |
| May 1, 2026 | issue | SO-260501-271 | EAST | 54 | 32.27 | -1,742.74 | 271 | 8,745.96 | April 3, 2026: 54 @ 32.27 |
| April 26, 2026 | issue | SO-260426-395 | MAIN | 24 | 32.27 | -774.55 | 325 | 10,488.69 | April 3, 2026: 24 @ 32.27 |
| April 13, 2026 | issue | SO-260413-343 | MAIN | 10 | 32.27 | -322.73 | 349 | 11,263.24 | April 3, 2026: 10 @ 32.27 |
| April 12, 2026 | issue | SO-260412-521 | MAIN | 5 | 32.27 | -161.36 | 359 | 11,585.97 | April 3, 2026: 5 @ 32.27 |
| April 5, 2026 | issue | SO-260405-867 | MAIN | 66 | 32.27 | -2,130.01 | 364 | 11,747.34 | April 3, 2026: 66 @ 32.27 |
| April 3, 2026 | transfer | TRF | MAIN → EAST | 138 | warehouse transfer, no cost effect | ||||
| April 3, 2026 | receipt | PO-001382 | MAIN | 430 | 32.27 | 13,877.35 | 430 | 13,877.35 | |
| March 27, 2026 | issue | SO-260327-100 | MAIN | 116 | 32.74 | -3,797.54 | 0 | 0.00 | Jan. 6, 2026: 116 @ 32.74 |
| March 13, 2026 | issue | SO-260313-426 | MAIN | 8 | 32.74 | -261.90 | 116 | 3,797.54 | Jan. 6, 2026: 8 @ 32.74 |
| Feb. 26, 2026 | issue | SO-260226-423 | MAIN | 94 | 32.74 | -3,077.32 | 124 | 4,059.44 | Jan. 6, 2026: 94 @ 32.74 |
| Feb. 24, 2026 | issue | SO-260224-863 | MAIN | 10 | 32.74 | -327.37 | 218 | 7,136.75 | Jan. 6, 2026: 10 @ 32.74 |
| Feb. 13, 2026 | issue | SO-260213-327 | MAIN | 50 | 32.74 | -1,636.87 | 228 | 7,464.13 | Jan. 6, 2026: 50 @ 32.74 |
| Feb. 2, 2026 | issue | SO-260202-548 | MAIN | 15 | 32.74 | -491.06 | 278 | 9,101.00 | Jan. 6, 2026: 15 @ 32.74 |
| Feb. 1, 2026 | issue | SO-260201-446 | MAIN | 39 | 32.74 | -1,276.76 | 293 | 9,592.06 | Jan. 6, 2026: 39 @ 32.74 |
| Jan. 22, 2026 | issue | SO-260122-860 | MAIN | 20 | 32.74 | -654.75 | 332 | 10,868.82 | Jan. 6, 2026: 20 @ 32.74 |
| Jan. 22, 2026 | issue | SO-260122-860 | EAST | 4 | 32.74 | -130.95 | 352 | 11,523.56 | Jan. 6, 2026: 4 @ 32.74 |
| Jan. 15, 2026 | issue | SO-260115-672 | MAIN | 14 | 32.74 | -458.32 | 356 | 11,654.51 | Jan. 6, 2026: 14 @ 32.74 |
| Jan. 14, 2026 | issue | SO-260114-814 | MAIN | 64 | 32.73 | -2,094.95 | 370 | 12,112.84 | Nov. 20, 2025: 4 @ 32.68; Jan. 6, 2026: 60 @ 32.74 |
| Jan. 6, 2026 | receipt | PO-001126 | MAIN | 430 | 32.74 | 14,077.08 | 434 | 14,207.79 | |
| Jan. 4, 2026 | issue | SO-260104-927 | EAST | 47 | 32.68 | -1,535.78 | 4 | 130.70 | Sept. 30, 2025: 34 @ 32.68; Nov. 20, 2025: 13 @ 32.68 |
| Dec. 29, 2025 | issue | SO-251229-403 | EAST | 41 | 32.68 | -1,339.72 | 51 | 1,666.49 | Sept. 30, 2025: 41 @ 32.68 |
| Dec. 29, 2025 | issue | SO-251229-403 | MAIN | 84 | 32.68 | -2,744.80 | 92 | 3,006.21 | Sept. 30, 2025: 84 @ 32.68 |
| Dec. 8, 2025 | issue | SO-251208-259 | MAIN | 15 | 32.68 | -490.14 | 176 | 5,751.01 | Sept. 30, 2025: 15 @ 32.68 |
| Dec. 4, 2025 | issue | SO-251204-420 | MAIN | 1 | 32.68 | -32.68 | 191 | 6,241.15 | Sept. 30, 2025: 1 @ 32.68 |
| Nov. 30, 2025 | issue | SO-251130-548 | MAIN | 9 | 32.68 | -294.09 | 192 | 6,273.83 | Sept. 30, 2025: 9 @ 32.68 |
| Nov. 23, 2025 | issue | SO-251123-699 | MAIN | 63 | 32.68 | -2,058.60 | 201 | 6,567.92 | Sept. 30, 2025: 63 @ 32.68 |
| Nov. 20, 2025 | return | RMA | MAIN | 17 | 32.68 | 555.50 | 264 | 8,626.52 | |
| Nov. 20, 2025 | issue | SO-251120-949 | MAIN | 31 | 32.68 | -1,012.96 | 247 | 8,071.02 | Sept. 30, 2025: 31 @ 32.68 |
| Nov. 4, 2025 | issue | SO-251104-770 | MAIN | 35 | 32.68 | -1,143.67 | 278 | 9,083.98 | Sept. 30, 2025: 35 @ 32.68 |
| Nov. 3, 2025 | issue | SO-251103-693 | MAIN | 27 | 32.68 | -882.26 | 313 | 10,227.65 | Sept. 30, 2025: 27 @ 32.68 |
| Oct. 31, 2025 | issue | SO-251031-743 | EAST | 3 | 32.68 | -98.03 | 340 | 11,109.91 | Sept. 30, 2025: 3 @ 32.68 |
| Oct. 25, 2025 | issue | SO-251025-215 | MAIN | 4 | 32.68 | -130.70 | 343 | 11,207.94 | Sept. 30, 2025: 4 @ 32.68 |
| Oct. 22, 2025 | issue | SO-251022-392 | MAIN | 14 | 32.68 | -457.47 | 347 | 11,338.64 | Sept. 30, 2025: 14 @ 32.68 |
| Oct. 9, 2025 | issue | SO-251009-986 | MAIN | 8 | 32.68 | -261.41 | 361 | 11,796.11 | Sept. 30, 2025: 8 @ 32.68 |
| Oct. 7, 2025 | issue | SO-251007-721 | EAST | 11 | 32.68 | -359.44 | 369 | 12,057.52 | Sept. 30, 2025: 11 @ 32.68 |
| Oct. 6, 2025 | issue | SO-251006-151 | MAIN | 99 | 32.30 | -3,198.00 | 380 | 12,416.96 | July 7, 2025: 49 @ 31.92; Sept. 30, 2025: 50 @ 32.68 |
| Sept. 30, 2025 | transfer | TRF | MAIN → EAST | 106 | warehouse transfer, no cost effect | ||||