Items / SWT-0026
Modular Switch 16A Plus SWT-0026 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)17MAIN 17
Value (FIFO)391.35avg 23.02
ClassBX / FCV 0.17
Turnover20.2xlast issue 5 days ago
Days of cover5lead time 7d
Reorder suggested: 270 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 94.42 / 30.4375 | 3.102 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 16.47 / 5.517 | 2.985 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(7.0 * 2.985^2 + 3.102^2 * 1.5^2) | 15.2 |
| Reorder point | d * LT + safety stock | 3.102 * 7.0 + 15.2 | 36.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 36.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1132/yr, S = 45.00, h = 20%, price = 23.39 | 147.6 |
| Inventory position | on hand + on order | 17 + 0 | 17 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 23.39 | 148 | 27,173 | yes (chosen if cheapest) |
MOQ 270, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 12, 2026 | 17 / 270 | 23.02 | 391.35 |
Movement ledger 113 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-192 | MAIN | 38 | 23.02 | -874.78 | 17 | 391.35 | July 12, 2026: 38 @ 23.02 |
| Oct. 10, 2026 | issue | SO-261010-858 | MAIN | 16 | 23.02 | -368.33 | 55 | 1,266.12 | July 12, 2026: 16 @ 23.02 |
| Sept. 14, 2026 | issue | SO-260914-653 | MAIN | 8 | 23.02 | -184.16 | 71 | 1,634.45 | July 12, 2026: 8 @ 23.02 |
| Sept. 8, 2026 | issue | SO-260908-227 | MAIN | 23 | 23.02 | -529.47 | 79 | 1,818.61 | July 12, 2026: 23 @ 23.02 |
| Sept. 4, 2026 | issue | SO-260904-900 | MAIN | 44 | 23.02 | -1,012.90 | 102 | 2,348.08 | July 12, 2026: 44 @ 23.02 |
| Aug. 27, 2026 | issue | SO-260827-801 | MAIN | 13 | 23.02 | -299.27 | 146 | 3,360.98 | July 12, 2026: 13 @ 23.02 |
| Aug. 11, 2026 | issue | SO-260811-907 | MAIN | 88 | 23.02 | -2,025.80 | 159 | 3,660.24 | July 12, 2026: 88 @ 23.02 |
| July 18, 2026 | issue | SO-260718-825 | MAIN | 23 | 23.02 | -529.47 | 247 | 5,686.04 | July 12, 2026: 23 @ 23.02 |
| July 12, 2026 | receipt | PO-001644 | MAIN | 270 | 23.02 | 6,215.51 | 270 | 6,215.51 | |
| July 11, 2026 | issue | SO-260711-241 | EAST | 5 | 23.04 | -115.18 | 0 | 0.00 | April 27, 2026: 5 @ 23.04 |
| July 7, 2026 | issue | SO-260707-113 | EAST | 24 | 23.04 | -552.87 | 5 | 115.18 | April 27, 2026: 24 @ 23.04 |
| July 7, 2026 | issue | SO-260707-113 | MAIN | 11 | 23.04 | -253.40 | 29 | 668.05 | April 27, 2026: 11 @ 23.04 |
| July 6, 2026 | issue | SO-260706-919 | MAIN | 28 | 23.04 | -645.01 | 40 | 921.45 | April 27, 2026: 28 @ 23.04 |
| June 29, 2026 | issue | SO-260629-661 | EAST | 9 | 23.04 | -207.33 | 68 | 1,566.46 | April 27, 2026: 9 @ 23.04 |
| June 26, 2026 | issue | SO-260626-244 | MAIN | 19 | 23.04 | -437.69 | 77 | 1,773.79 | April 27, 2026: 19 @ 23.04 |
| June 21, 2026 | issue | SO-260621-107 | EAST | 39 | 23.04 | -898.41 | 96 | 2,211.48 | April 27, 2026: 39 @ 23.04 |
| June 12, 2026 | issue | SO-260612-810 | EAST | 3 | 23.04 | -69.11 | 135 | 3,109.89 | April 27, 2026: 3 @ 23.04 |
| June 4, 2026 | issue | SO-260604-838 | MAIN | 43 | 23.04 | -990.56 | 138 | 3,179.00 | April 27, 2026: 43 @ 23.04 |
| May 24, 2026 | issue | SO-260524-550 | MAIN | 46 | 23.04 | -1,059.67 | 181 | 4,169.55 | April 27, 2026: 46 @ 23.04 |
| May 17, 2026 | issue | SO-260517-775 | MAIN | 31 | 23.04 | -714.12 | 227 | 5,229.22 | April 27, 2026: 31 @ 23.04 |
| May 7, 2026 | issue | SO-260507-350 | EAST | 12 | 23.04 | -276.43 | 258 | 5,943.34 | April 27, 2026: 12 @ 23.04 |
| April 27, 2026 | transfer | TRF | MAIN → EAST | 92 | warehouse transfer, no cost effect | ||||
| April 27, 2026 | receipt | PO-001443 | MAIN | 270 | 23.04 | 6,219.77 | 270 | 6,219.77 | |
| April 20, 2026 | issue | SO-260420-718 | MAIN | 61 | 22.41 | -1,367.25 | 0 | 0.00 | Jan. 29, 2026: 59 @ 22.41; April 5, 2026: 2 @ 22.41 |
| April 5, 2026 | return | RMA | MAIN | 2 | 22.41 | 44.83 | 61 | 1,367.25 | |
| April 5, 2026 | issue | SO-260405-135 | MAIN | 7 | 22.41 | -156.90 | 59 | 1,322.43 | Jan. 29, 2026: 7 @ 22.41 |
| March 29, 2026 | issue | SO-260329-867 | MAIN | 90 | 22.41 | -2,017.26 | 66 | 1,479.32 | Jan. 29, 2026: 90 @ 22.41 |
| March 27, 2026 | issue | SO-260327-912 | MAIN | 5 | 22.41 | -112.07 | 156 | 3,496.58 | Jan. 29, 2026: 5 @ 22.41 |
| Feb. 24, 2026 | issue | SO-260224-591 | MAIN | 22 | 22.41 | -493.11 | 161 | 3,608.65 | Jan. 29, 2026: 22 @ 22.41 |
| Feb. 22, 2026 | issue | SO-260222-970 | MAIN | 36 | 22.41 | -806.90 | 183 | 4,101.76 | Jan. 29, 2026: 36 @ 22.41 |
| Feb. 12, 2026 | issue | SO-260212-149 | MAIN | 29 | 22.41 | -650.01 | 219 | 4,908.67 | Jan. 29, 2026: 29 @ 22.41 |
| Feb. 8, 2026 | issue | SO-260208-162 | MAIN | 22 | 22.41 | -493.11 | 248 | 5,558.67 | Jan. 29, 2026: 22 @ 22.41 |
| Jan. 29, 2026 | receipt | PO-001185 | MAIN | 270 | 22.41 | 6,051.78 | 270 | 6,051.78 | |
| Jan. 18, 2026 | issue | SO-260118-705 | MAIN | 43 | 23.16 | -995.76 | 0 | 0.00 | Nov. 4, 2025: 43 @ 23.16 |
| Jan. 6, 2026 | issue | SO-260106-267 | MAIN | 26 | 23.16 | -602.08 | 43 | 995.76 | Nov. 4, 2025: 26 @ 23.16 |
| Dec. 31, 2025 | issue | SO-251231-152 | MAIN | 28 | 23.16 | -648.40 | 69 | 1,597.84 | Nov. 4, 2025: 28 @ 23.16 |
| Dec. 21, 2025 | issue | SO-251221-805 | MAIN | 3 | 23.16 | -69.47 | 97 | 2,246.24 | Nov. 4, 2025: 3 @ 23.16 |
| Dec. 20, 2025 | issue | SO-251220-499 | MAIN | 31 | 23.16 | -717.87 | 100 | 2,315.71 | Nov. 4, 2025: 31 @ 23.16 |
| Dec. 17, 2025 | issue | SO-251217-483 | MAIN | 13 | 23.16 | -301.04 | 131 | 3,033.58 | Nov. 4, 2025: 13 @ 23.16 |
| Dec. 5, 2025 | issue | SO-251205-274 | MAIN | 8 | 23.16 | -185.26 | 144 | 3,334.62 | Nov. 4, 2025: 8 @ 23.16 |
| Dec. 4, 2025 | issue | SO-251204-564 | MAIN | 33 | 23.16 | -764.18 | 152 | 3,519.88 | Nov. 4, 2025: 33 @ 23.16 |
| Nov. 29, 2025 | issue | SO-251129-297 | MAIN | 4 | 23.16 | -92.63 | 185 | 4,284.06 | Nov. 4, 2025: 4 @ 23.16 |
| Nov. 26, 2025 | issue | SO-251126-164 | MAIN | 32 | 23.16 | -741.03 | 189 | 4,376.69 | Nov. 4, 2025: 32 @ 23.16 |
| Nov. 18, 2025 | issue | SO-251118-816 | MAIN | 11 | 23.16 | -254.73 | 221 | 5,117.72 | Nov. 4, 2025: 11 @ 23.16 |
| Nov. 17, 2025 | issue | SO-251117-949 | MAIN | 65 | 22.77 | -1,480.14 | 232 | 5,372.45 | July 15, 2025: 27 @ 22.23; Nov. 4, 2025: 38 @ 23.16 |
| Nov. 4, 2025 | receipt | PO-000980 | MAIN | 270 | 23.16 | 6,252.42 | 297 | 6,852.59 | |
| Oct. 28, 2025 | issue | SO-251028-502 | MAIN | 24 | 22.23 | -533.48 | 27 | 600.17 | July 15, 2025: 24 @ 22.23 |
| Oct. 19, 2025 | issue | SO-251019-495 | MAIN | 38 | 22.23 | -844.68 | 51 | 1,133.65 | July 15, 2025: 38 @ 22.23 |
| Oct. 17, 2025 | issue | SO-251017-664 | MAIN | 12 | 22.23 | -266.74 | 89 | 1,978.34 | July 15, 2025: 12 @ 22.23 |
| Oct. 10, 2025 | issue | SO-251010-399 | MAIN | 14 | 22.23 | -311.20 | 101 | 2,245.08 | July 15, 2025: 14 @ 22.23 |
| Oct. 8, 2025 | issue | SO-251008-188 | MAIN | 1 | 22.23 | -22.23 | 115 | 2,556.28 | July 15, 2025: 1 @ 22.23 |
| Oct. 3, 2025 | issue | SO-251003-896 | MAIN | 8 | 22.23 | -177.83 | 116 | 2,578.51 | July 15, 2025: 8 @ 22.23 |
| Sept. 24, 2025 | issue | SO-250924-283 | MAIN | 41 | 22.23 | -911.37 | 124 | 2,756.33 | July 15, 2025: 41 @ 22.23 |
| Sept. 17, 2025 | issue | SO-250917-182 | MAIN | 7 | 22.23 | -155.60 | 165 | 3,667.70 | July 15, 2025: 7 @ 22.23 |
| Sept. 12, 2025 | issue | SO-250912-721 | MAIN | 16 | 22.23 | -355.66 | 172 | 3,823.30 | July 15, 2025: 16 @ 22.23 |
| Sept. 9, 2025 | issue | SO-250909-452 | MAIN | 8 | 22.23 | -177.83 | 188 | 4,178.96 | July 15, 2025: 8 @ 22.23 |
| Aug. 30, 2025 | issue | SO-250830-610 | MAIN | 14 | 22.23 | -311.20 | 196 | 4,356.79 | July 15, 2025: 14 @ 22.23 |
| Aug. 25, 2025 | issue | SO-250825-540 | MAIN | 22 | 22.23 | -489.03 | 210 | 4,667.98 | July 15, 2025: 22 @ 22.23 |
| Aug. 17, 2025 | issue | SO-250817-895 | EAST | 20 | 22.23 | -444.57 | 232 | 5,157.01 | July 15, 2025: 20 @ 22.23 |
| Aug. 10, 2025 | issue | SO-250810-756 | MAIN | 37 | 21.89 | -809.87 | 252 | 5,601.58 | April 22, 2025: 12 @ 21.57; May 12, 2025: 7 @ 21.57; July 15, 2025: 18 @ 22.23 |
| July 18, 2025 | issue | SO-250718-772 | MAIN | 15 | 21.57 | -323.49 | 289 | 6,411.45 | April 22, 2025: 15 @ 21.57 |
| July 15, 2025 | receipt | PO-000715 | MAIN | 270 | 22.23 | 6,001.70 | 304 | 6,734.94 | |
| July 8, 2025 | issue | SO-250708-253 | MAIN | 33 | 21.57 | -711.67 | 34 | 733.24 | April 22, 2025: 33 @ 21.57 |
| July 6, 2025 | issue | SO-250706-218 | MAIN | 19 | 21.57 | -409.75 | 67 | 1,444.92 | April 22, 2025: 19 @ 21.57 |
| July 5, 2025 | issue | SO-250705-212 | EAST | 2 | 21.57 | -43.13 | 86 | 1,854.67 | April 22, 2025: 2 @ 21.57 |
| July 3, 2025 | issue | SO-250703-265 | MAIN | 1 | 21.57 | -21.57 | 88 | 1,897.80 | April 22, 2025: 1 @ 21.57 |
| July 1, 2025 | issue | SO-250701-461 | MAIN | 18 | 21.57 | -388.19 | 89 | 1,919.37 | April 22, 2025: 18 @ 21.57 |
| June 30, 2025 | issue | SO-250630-109 | MAIN | 10 | 21.57 | -215.66 | 107 | 2,307.55 | April 22, 2025: 10 @ 21.57 |
| June 27, 2025 | issue | SO-250627-787 | MAIN | 17 | 21.57 | -366.62 | 117 | 2,523.21 | April 22, 2025: 17 @ 21.57 |
| June 10, 2025 | issue | SO-250610-163 | MAIN | 46 | 21.57 | -992.03 | 134 | 2,889.83 | April 22, 2025: 46 @ 21.57 |
| May 23, 2025 | issue | SO-250523-512 | MAIN | 7 | 21.57 | -150.96 | 180 | 3,881.86 | April 22, 2025: 7 @ 21.57 |
| May 20, 2025 | issue | SO-250520-606 | MAIN | 76 | 21.57 | -1,639.01 | 187 | 4,032.82 | April 22, 2025: 76 @ 21.57 |
| May 17, 2025 | issue | SO-250517-546 | EAST | 8 | 21.57 | -172.53 | 263 | 5,671.83 | April 22, 2025: 8 @ 21.57 |
| May 12, 2025 | return | RMA | MAIN | 7 | 21.57 | 150.96 | 271 | 5,844.36 | |
| May 3, 2025 | issue | SO-250503-598 | MAIN | 2 | 21.57 | -43.13 | 264 | 5,693.40 | April 22, 2025: 2 @ 21.57 |
| April 30, 2025 | issue | SO-250430-710 | MAIN | 15 | 21.67 | -325.03 | 266 | 5,736.53 | Jan. 8, 2025: 11 @ 21.71; April 22, 2025: 4 @ 21.57 |
| April 27, 2025 | issue | SO-250427-932 | MAIN | 16 | 21.71 | -347.29 | 281 | 6,061.56 | Jan. 8, 2025: 16 @ 21.71 |
| April 22, 2025 | issue | SO-250422-763 | MAIN | 11 | 21.71 | -238.76 | 297 | 6,408.85 | Jan. 8, 2025: 11 @ 21.71 |
| April 22, 2025 | receipt | PO-000473 | MAIN | 270 | 21.57 | 5,822.79 | 308 | 6,647.62 | |
| April 17, 2025 | issue | SO-250417-603 | MAIN | 12 | 21.71 | -260.47 | 38 | 824.82 | Jan. 8, 2025: 12 @ 21.71 |
| April 9, 2025 | issue | SO-250409-241 | MAIN | 20 | 21.71 | -434.12 | 50 | 1,085.30 | Jan. 8, 2025: 20 @ 21.71 |
| April 3, 2025 | issue | SO-250403-495 | MAIN | 1 | 21.71 | -21.71 | 70 | 1,519.41 | Jan. 8, 2025: 1 @ 21.71 |
| March 22, 2025 | issue | SO-250322-190 | MAIN | 65 | 21.71 | -1,410.88 | 71 | 1,541.12 | Jan. 8, 2025: 65 @ 21.71 |
| March 21, 2025 | issue | SO-250321-732 | EAST | 10 | 21.71 | -217.06 | 136 | 2,952.00 | Jan. 8, 2025: 10 @ 21.71 |
| March 14, 2025 | issue | SO-250314-416 | EAST | 8 | 21.71 | -173.65 | 146 | 3,169.06 | Jan. 8, 2025: 8 @ 21.71 |
| Feb. 28, 2025 | issue | SO-250228-597 | MAIN | 21 | 21.71 | -455.82 | 154 | 3,342.71 | Jan. 8, 2025: 21 @ 21.71 |
| Feb. 21, 2025 | issue | SO-250221-993 | MAIN | 28 | 21.71 | -607.77 | 175 | 3,798.53 | Jan. 8, 2025: 28 @ 21.71 |
| Feb. 2, 2025 | issue | SO-250202-965 | MAIN | 8 | 21.71 | -173.65 | 203 | 4,406.30 | Jan. 8, 2025: 8 @ 21.71 |
| Feb. 1, 2025 | issue | SO-250201-379 | MAIN | 31 | 21.71 | -672.88 | 211 | 4,579.94 | Jan. 8, 2025: 31 @ 21.71 |
| Jan. 27, 2025 | issue | SO-250127-138 | EAST | 11 | 21.71 | -238.76 | 242 | 5,252.83 | Jan. 8, 2025: 11 @ 21.71 |
| Jan. 19, 2025 | issue | SO-250119-826 | EAST | 12 | 21.71 | -260.47 | 253 | 5,491.59 | Jan. 8, 2025: 12 @ 21.71 |
| Jan. 18, 2025 | issue | SO-250118-652 | MAIN | 23 | 22.11 | -508.50 | 265 | 5,752.06 | Oct. 1, 2024: 18 @ 22.22; Jan. 8, 2025: 5 @ 21.71 |
| Jan. 8, 2025 | transfer | TRF | MAIN → EAST | 71 | warehouse transfer, no cost effect | ||||
| Jan. 8, 2025 | receipt | PO-000172 | MAIN | 270 | 21.71 | 5,860.59 | 288 | 6,260.56 | |
| Jan. 4, 2025 | issue | SO-250104-346 | MAIN | 29 | 22.22 | -644.39 | 18 | 399.97 | Oct. 1, 2024: 29 @ 22.22 |
| Jan. 1, 2025 | issue | SO-250101-945 | MAIN | 2 | 22.22 | -44.44 | 47 | 1,044.36 | Oct. 1, 2024: 2 @ 22.22 |
| Dec. 21, 2024 | issue | SO-241221-125 | MAIN | 2 | 22.22 | -44.44 | 49 | 1,088.80 | Oct. 1, 2024: 2 @ 22.22 |
| Dec. 19, 2024 | issue | SO-241219-412 | MAIN | 13 | 22.22 | -288.87 | 51 | 1,133.25 | Oct. 1, 2024: 13 @ 22.22 |
| Dec. 15, 2024 | issue | SO-241215-327 | MAIN | 11 | 22.22 | -244.43 | 64 | 1,422.11 | Oct. 1, 2024: 11 @ 22.22 |
| Dec. 12, 2024 | issue | SO-241212-836 | MAIN | 5 | 22.22 | -111.10 | 75 | 1,666.54 | Oct. 1, 2024: 5 @ 22.22 |
| Dec. 9, 2024 | issue | SO-241209-745 | MAIN | 5 | 22.22 | -111.10 | 80 | 1,777.64 | Oct. 1, 2024: 5 @ 22.22 |
| Dec. 6, 2024 | issue | SO-241206-808 | MAIN | 12 | 22.22 | -266.65 | 85 | 1,888.74 | Oct. 1, 2024: 12 @ 22.22 |
| Dec. 1, 2024 | issue | SO-241201-639 | MAIN | 23 | 22.22 | -511.07 | 97 | 2,155.39 | Oct. 1, 2024: 23 @ 22.22 |
| Nov. 24, 2024 | issue | SO-241124-608 | MAIN | 2 | 22.22 | -44.44 | 120 | 2,666.46 | Oct. 1, 2024: 2 @ 22.22 |
| Nov. 15, 2024 | issue | SO-241115-845 | MAIN | 11 | 22.22 | -244.43 | 122 | 2,710.90 | Oct. 1, 2024: 11 @ 22.22 |
| Nov. 14, 2024 | issue | SO-241114-963 | MAIN | 15 | 22.22 | -333.31 | 133 | 2,955.33 | Oct. 1, 2024: 15 @ 22.22 |
| Nov. 7, 2024 | issue | SO-241107-876 | MAIN | 25 | 22.22 | -555.51 | 148 | 3,288.63 | Oct. 1, 2024: 25 @ 22.22 |
| Nov. 6, 2024 | issue | SO-241106-558 | MAIN | 7 | 22.22 | -155.54 | 173 | 3,844.15 | Oct. 1, 2024: 7 @ 22.22 |
| Nov. 2, 2024 | issue | SO-241102-947 | MAIN | 10 | 22.22 | -222.20 | 180 | 3,999.69 | Oct. 1, 2024: 10 @ 22.22 |
| Oct. 15, 2024 | issue | SO-241015-140 | MAIN | 1 | 22.22 | -22.22 | 190 | 4,221.90 | Oct. 1, 2024: 1 @ 22.22 |
| Oct. 5, 2024 | issue | SO-241005-153 | MAIN | 10 | 22.22 | -222.20 | 191 | 4,244.12 | Oct. 1, 2024: 10 @ 22.22 |
| Oct. 3, 2024 | issue | SO-241003-724 | MAIN | 69 | 22.22 | -1,533.21 | 201 | 4,466.32 | Oct. 1, 2024: 69 @ 22.22 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 270 | 22.22 | 5,999.54 | 270 | 5,999.54 | |