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, latest 60 shown - show all
| 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 |