Items / SWT-0029
Modular Switch 6A Prime SWT-0029 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)687MAIN 551, EAST 136
Value (FIFO)11,354.62avg 16.53
ClassAX / FCV 0.14
Turnover7.7xlast issue 4 days ago
Days of cover95lead 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 | 221.25 / 30.4375 | 7.269 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 31.77 / 5.517 | 5.759 |
| 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.759^2 + 7.269^2 * 1.5^2) | 38.8 |
| Reorder point | d * LT + safety stock | 7.269 * 7.0 + 38.8 | 89.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 89.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2653/yr, S = 45.00, h = 20%, price = 16.17 | 1320.0 |
| Inventory position | on hand + on order | 687 + 0 | 687 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 16.84 | 266 | 45,576 | yes |
| 1,320 | 16.17 | 1,320 | 45,117 | yes (chosen if cheapest) |
| 2,640 | 15.49 | 2,640 | 45,241 | yes |
MOQ 660, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 24, 2026 | 27 / 660 | 17.13 | 462.64 | |
| Oct. 16, 2026 | 660 / 660 | 16.50 | 10,891.98 |
Movement ledger 125 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | transfer | TRF | MAIN → EAST | 136 | warehouse transfer, no cost effect | ||||
| Oct. 16, 2026 | receipt | PO-001886 | MAIN | 660 | 16.50 | 10,891.98 | 687 | 11,354.62 | |
| Oct. 12, 2026 | issue | SO-261012-956 | MAIN | 5 | 17.13 | -85.67 | 27 | 462.64 | July 24, 2026: 5 @ 17.13 |
| Oct. 11, 2026 | issue | SO-261011-742 | MAIN | 53 | 17.13 | -908.15 | 32 | 548.32 | July 24, 2026: 53 @ 17.13 |
| Oct. 10, 2026 | issue | SO-261010-444 | MAIN | 41 | 17.13 | -702.53 | 85 | 1,456.47 | July 24, 2026: 41 @ 17.13 |
| Oct. 9, 2026 | issue | SO-261009-909 | MAIN | 25 | 17.13 | -428.37 | 126 | 2,159.00 | July 24, 2026: 25 @ 17.13 |
| Oct. 8, 2026 | issue | SO-261008-551 | MAIN | 28 | 17.13 | -479.78 | 151 | 2,587.37 | July 24, 2026: 28 @ 17.13 |
| Oct. 2, 2026 | issue | SO-261002-153 | MAIN | 24 | 17.13 | -411.24 | 179 | 3,067.15 | July 24, 2026: 24 @ 17.13 |
| Sept. 26, 2026 | issue | SO-260926-876 | MAIN | 98 | 17.13 | -1,679.22 | 203 | 3,478.38 | July 24, 2026: 98 @ 17.13 |
| Sept. 14, 2026 | issue | SO-260914-323 | MAIN | 41 | 17.13 | -702.53 | 301 | 5,157.60 | July 24, 2026: 41 @ 17.13 |
| Sept. 13, 2026 | issue | SO-260913-908 | MAIN | 56 | 17.13 | -959.55 | 342 | 5,860.14 | July 24, 2026: 56 @ 17.13 |
| Sept. 10, 2026 | issue | SO-260910-254 | MAIN | 47 | 17.13 | -805.34 | 398 | 6,819.69 | July 24, 2026: 47 @ 17.13 |
| Sept. 7, 2026 | issue | SO-260907-548 | MAIN | 16 | 17.13 | -274.16 | 445 | 7,625.03 | July 24, 2026: 16 @ 17.13 |
| Aug. 31, 2026 | issue | SO-260831-679 | MAIN | 15 | 17.13 | -257.02 | 461 | 7,899.19 | July 24, 2026: 15 @ 17.13 |
| Aug. 21, 2026 | issue | SO-260821-690 | MAIN | 83 | 17.13 | -1,422.20 | 476 | 8,156.21 | July 24, 2026: 83 @ 17.13 |
| Aug. 12, 2026 | issue | SO-260812-975 | MAIN | 155 | 16.99 | -2,632.89 | 559 | 9,578.41 | April 24, 2026: 54 @ 16.71; July 24, 2026: 101 @ 17.13 |
| July 24, 2026 | receipt | PO-001668 | MAIN | 660 | 17.13 | 11,309.03 | 714 | 12,211.30 | |
| July 16, 2026 | issue | SO-260716-236 | MAIN | 104 | 16.71 | -1,737.70 | 54 | 902.27 | April 24, 2026: 104 @ 16.71 |
| July 11, 2026 | issue | SO-260711-759 | MAIN | 62 | 16.71 | -1,035.94 | 158 | 2,639.97 | April 24, 2026: 62 @ 16.71 |
| June 20, 2026 | issue | SO-260620-971 | MAIN | 22 | 16.71 | -367.59 | 220 | 3,675.91 | April 24, 2026: 22 @ 16.71 |
| June 19, 2026 | issue | SO-260619-448 | MAIN | 65 | 16.71 | -1,086.07 | 242 | 4,043.51 | April 24, 2026: 65 @ 16.71 |
| June 10, 2026 | issue | SO-260610-540 | MAIN | 97 | 16.71 | -1,620.74 | 307 | 5,129.57 | April 24, 2026: 97 @ 16.71 |
| June 5, 2026 | issue | SO-260605-966 | MAIN | 17 | 16.71 | -284.05 | 404 | 6,750.31 | April 24, 2026: 17 @ 16.71 |
| May 29, 2026 | issue | SO-260529-845 | MAIN | 10 | 16.71 | -167.09 | 421 | 7,034.36 | April 24, 2026: 10 @ 16.71 |
| May 27, 2026 | issue | SO-260527-126 | MAIN | 14 | 16.71 | -233.92 | 431 | 7,201.45 | April 24, 2026: 14 @ 16.71 |
| May 20, 2026 | issue | SO-260520-249 | MAIN | 108 | 16.71 | -1,804.54 | 445 | 7,435.37 | April 24, 2026: 108 @ 16.71 |
| May 8, 2026 | issue | SO-260508-365 | MAIN | 38 | 16.71 | -634.93 | 553 | 9,239.91 | April 24, 2026: 38 @ 16.71 |
| May 4, 2026 | issue | SO-260504-102 | MAIN | 86 | 16.67 | -1,433.67 | 591 | 9,874.84 | Jan. 22, 2026: 17 @ 16.52; April 24, 2026: 69 @ 16.71 |
| April 26, 2026 | issue | SO-260426-189 | MAIN | 3 | 16.52 | -49.55 | 677 | 11,308.51 | Jan. 22, 2026: 3 @ 16.52 |
| April 24, 2026 | receipt | PO-001434 | MAIN | 660 | 16.71 | 11,027.74 | 680 | 11,358.06 | |
| April 22, 2026 | issue | SO-260422-628 | MAIN | 33 | 16.52 | -545.02 | 20 | 330.31 | Jan. 22, 2026: 33 @ 16.52 |
| April 17, 2026 | issue | SO-260417-112 | MAIN | 166 | 16.52 | -2,741.61 | 53 | 875.33 | Jan. 22, 2026: 166 @ 16.52 |
| April 16, 2026 | issue | SO-260416-278 | MAIN | 58 | 16.52 | -957.91 | 219 | 3,616.94 | Jan. 22, 2026: 58 @ 16.52 |
| April 6, 2026 | issue | SO-260406-291 | MAIN | 1 | 16.52 | -16.52 | 277 | 4,574.85 | Jan. 22, 2026: 1 @ 16.52 |
| March 19, 2026 | issue | SO-260319-274 | MAIN | 19 | 16.52 | -313.80 | 278 | 4,591.36 | Jan. 22, 2026: 19 @ 16.52 |
| March 9, 2026 | issue | SO-260309-491 | MAIN | 56 | 16.52 | -924.88 | 297 | 4,905.16 | Jan. 22, 2026: 56 @ 16.52 |
| March 6, 2026 | issue | SO-260306-290 | MAIN | 53 | 16.52 | -875.33 | 353 | 5,830.04 | Jan. 22, 2026: 53 @ 16.52 |
| March 4, 2026 | issue | SO-260304-170 | MAIN | 53 | 16.52 | -875.33 | 406 | 6,705.37 | Jan. 22, 2026: 53 @ 16.52 |
| Feb. 28, 2026 | issue | SO-260228-538 | MAIN | 35 | 16.52 | -578.05 | 459 | 7,580.71 | Jan. 22, 2026: 35 @ 16.52 |
| Feb. 22, 2026 | issue | SO-260222-620 | MAIN | 21 | 16.52 | -346.83 | 494 | 8,158.76 | Jan. 22, 2026: 21 @ 16.52 |
| Feb. 17, 2026 | issue | SO-260217-196 | MAIN | 39 | 16.52 | -644.11 | 515 | 8,505.59 | Jan. 22, 2026: 39 @ 16.52 |
| Feb. 15, 2026 | issue | SO-260215-808 | MAIN | 20 | 16.52 | -330.31 | 554 | 9,149.70 | Jan. 22, 2026: 20 @ 16.52 |
| Feb. 3, 2026 | issue | SO-260203-212 | MAIN | 100 | 16.46 | -1,646.40 | 574 | 9,480.01 | Oct. 17, 2025: 12 @ 16.15; Dec. 1, 2025: 2 @ 16.15; Jan. 22, 2026: 86 @ 16.52 |
| Jan. 26, 2026 | issue | SO-260126-991 | MAIN | 52 | 16.15 | -839.61 | 674 | 11,126.41 | Oct. 17, 2025: 52 @ 16.15 |
| Jan. 22, 2026 | receipt | PO-001172 | MAIN | 660 | 16.52 | 10,900.36 | 726 | 11,966.02 | |
| Jan. 16, 2026 | issue | SO-260116-820 | MAIN | 48 | 16.15 | -775.02 | 66 | 1,065.66 | Oct. 17, 2025: 48 @ 16.15 |
| Jan. 14, 2026 | issue | SO-260114-592 | MAIN | 18 | 16.15 | -290.63 | 114 | 1,840.68 | Oct. 17, 2025: 18 @ 16.15 |
| Jan. 5, 2026 | issue | SO-260105-227 | MAIN | 36 | 16.15 | -581.27 | 132 | 2,131.31 | Oct. 17, 2025: 36 @ 16.15 |
| Jan. 3, 2026 | issue | SO-260103-386 | MAIN | 68 | 16.15 | -1,097.95 | 168 | 2,712.58 | Oct. 17, 2025: 68 @ 16.15 |
| Jan. 1, 2026 | issue | SO-260101-286 | MAIN | 11 | 16.15 | -177.61 | 236 | 3,810.53 | Oct. 17, 2025: 11 @ 16.15 |
| Dec. 31, 2025 | issue | SO-251231-130 | MAIN | 13 | 16.15 | -209.90 | 247 | 3,988.14 | Oct. 17, 2025: 13 @ 16.15 |
| Dec. 18, 2025 | issue | SO-251218-432 | MAIN | 49 | 16.15 | -791.17 | 260 | 4,198.04 | Oct. 17, 2025: 49 @ 16.15 |
| Dec. 12, 2025 | issue | SO-251212-178 | MAIN | 33 | 16.15 | -532.83 | 309 | 4,989.21 | Oct. 17, 2025: 33 @ 16.15 |
| Dec. 11, 2025 | issue | SO-251211-256 | MAIN | 32 | 16.15 | -516.68 | 342 | 5,522.03 | Oct. 17, 2025: 32 @ 16.15 |
| Dec. 7, 2025 | issue | SO-251207-472 | MAIN | 16 | 16.15 | -258.34 | 374 | 6,038.72 | Oct. 17, 2025: 16 @ 16.15 |
| Dec. 6, 2025 | issue | SO-251206-958 | MAIN | 75 | 16.15 | -1,210.97 | 390 | 6,297.06 | Oct. 17, 2025: 75 @ 16.15 |
| Dec. 1, 2025 | return | RMA | MAIN | 2 | 16.15 | 32.29 | 465 | 7,508.03 | |
| Nov. 30, 2025 | issue | SO-251130-490 | MAIN | 51 | 16.15 | -823.46 | 463 | 7,475.74 | Oct. 17, 2025: 51 @ 16.15 |
| Nov. 18, 2025 | issue | SO-251118-978 | MAIN | 4 | 16.15 | -64.59 | 514 | 8,299.20 | Oct. 17, 2025: 4 @ 16.15 |
| Nov. 15, 2025 | issue | SO-251115-159 | MAIN | 75 | 16.15 | -1,210.97 | 518 | 8,363.78 | Oct. 17, 2025: 75 @ 16.15 |