Items / SWT-0035
Modular Switch 6A Plus SWT-0035 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)185MAIN 45, EAST 140
Value (FIFO)1,799.57avg 9.73
ClassBX / FCV 0.23
Turnover9.1xlast issue 3 days ago
Days of cover25lead 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 | 222.33 / 30.4375 | 7.305 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 51.23 / 5.517 | 9.286 |
| 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 * 9.286^2 + 7.305^2 * 1.5^2) | 44.4 |
| Reorder point | d * LT + safety stock | 7.305 * 7.0 + 44.4 | 95.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 95.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2666/yr, S = 45.00, h = 20%, price = 9.16 | 2480.0 |
| Inventory position | on hand + on order | 185 + 0 | 185 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 9.96 | 347 | 27,246 | yes |
| 1,240 | 9.56 | 1,240 | 26,775 | yes |
| 2,480 | 9.16 | 2,480 | 26,752 | yes (chosen if cheapest) |
MOQ 620, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 8, 2026 | 185 / 620 | 9.73 | 1,799.57 |
Movement ledger 116 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-226 | MAIN | 54 | 9.73 | -525.28 | 185 | 1,799.57 | Sept. 8, 2026: 54 @ 9.73 |
| Oct. 3, 2026 | issue | SO-261003-279 | EAST | 27 | 9.73 | -262.64 | 239 | 2,324.85 | Sept. 8, 2026: 27 @ 9.73 |
| Oct. 2, 2026 | issue | SO-261002-113 | MAIN | 94 | 9.73 | -914.38 | 266 | 2,587.49 | Sept. 8, 2026: 94 @ 9.73 |
| Oct. 1, 2026 | issue | SO-261001-195 | MAIN | 31 | 9.73 | -301.55 | 360 | 3,501.86 | Sept. 8, 2026: 31 @ 9.73 |
| Sept. 28, 2026 | issue | SO-260928-107 | MAIN | 6 | 9.73 | -58.36 | 391 | 3,803.41 | Sept. 8, 2026: 6 @ 9.73 |
| Sept. 15, 2026 | issue | SO-260915-101 | MAIN | 134 | 9.73 | -1,303.47 | 397 | 3,861.78 | Sept. 8, 2026: 134 @ 9.73 |
| Sept. 14, 2026 | issue | SO-260914-471 | MAIN | 25 | 9.73 | -243.18 | 531 | 5,165.25 | Sept. 8, 2026: 25 @ 9.73 |
| Sept. 11, 2026 | issue | SO-260911-348 | MAIN | 64 | 9.73 | -622.55 | 556 | 5,408.43 | Sept. 8, 2026: 64 @ 9.73 |
| Sept. 8, 2026 | transfer | TRF | MAIN → EAST | 167 | warehouse transfer, no cost effect | ||||
| Sept. 8, 2026 | receipt | PO-001782 | MAIN | 620 | 9.73 | 6,030.99 | 620 | 6,030.99 | |
| Aug. 31, 2026 | issue | SO-260831-719 | MAIN | 105 | 9.74 | -1,022.76 | 0 | 0.00 | June 5, 2026: 105 @ 9.74 |
| Aug. 26, 2026 | issue | SO-260826-265 | MAIN | 5 | 9.74 | -48.70 | 105 | 1,022.76 | June 5, 2026: 5 @ 9.74 |
| Aug. 13, 2026 | issue | SO-260813-201 | MAIN | 32 | 9.74 | -311.70 | 110 | 1,071.47 | June 5, 2026: 32 @ 9.74 |
| Aug. 2, 2026 | issue | SO-260802-130 | MAIN | 7 | 9.74 | -68.18 | 142 | 1,383.17 | June 5, 2026: 7 @ 9.74 |
| July 30, 2026 | issue | SO-260730-147 | MAIN | 45 | 9.74 | -438.33 | 149 | 1,451.35 | June 5, 2026: 45 @ 9.74 |
| July 19, 2026 | issue | SO-260719-969 | MAIN | 31 | 9.74 | -301.96 | 194 | 1,889.68 | June 5, 2026: 31 @ 9.74 |
| July 17, 2026 | issue | SO-260717-870 | MAIN | 1 | 9.74 | -9.74 | 225 | 2,191.64 | June 5, 2026: 1 @ 9.74 |
| July 11, 2026 | issue | SO-260711-399 | MAIN | 65 | 9.74 | -633.14 | 226 | 2,201.38 | June 5, 2026: 65 @ 9.74 |
| July 5, 2026 | issue | SO-260705-143 | MAIN | 77 | 9.74 | -750.03 | 291 | 2,834.51 | June 5, 2026: 77 @ 9.74 |
| June 21, 2026 | issue | SO-260621-869 | MAIN | 252 | 9.74 | -2,454.63 | 368 | 3,584.54 | June 5, 2026: 252 @ 9.74 |
| June 5, 2026 | receipt | PO-001550 | MAIN | 620 | 9.74 | 6,039.17 | 620 | 6,039.17 | |
| June 2, 2026 | issue | SO-260602-921 | EAST | 16 | 9.68 | -154.96 | 0 | 0.00 | Feb. 11, 2026: 16 @ 9.68 |
| May 30, 2026 | issue | SO-260530-392 | EAST | 21 | 9.68 | -203.38 | 16 | 154.96 | Feb. 11, 2026: 21 @ 9.68 |
| May 30, 2026 | issue | SO-260530-392 | MAIN | 167 | 9.68 | -1,617.38 | 37 | 358.34 | Feb. 11, 2026: 167 @ 9.68 |
| May 24, 2026 | issue | SO-260524-476 | EAST | 1 | 9.68 | -9.68 | 204 | 1,975.72 | Feb. 11, 2026: 1 @ 9.68 |
| May 16, 2026 | issue | SO-260516-123 | EAST | 14 | 9.68 | -135.59 | 205 | 1,985.40 | Feb. 11, 2026: 14 @ 9.68 |
| April 11, 2026 | issue | SO-260411-869 | MAIN | 86 | 9.68 | -832.90 | 219 | 2,120.99 | Feb. 11, 2026: 86 @ 9.68 |
| April 5, 2026 | issue | SO-260405-869 | MAIN | 56 | 9.68 | -542.35 | 305 | 2,953.89 | Feb. 11, 2026: 56 @ 9.68 |
| April 3, 2026 | issue | SO-260403-544 | MAIN | 41 | 9.68 | -397.08 | 361 | 3,496.25 | Feb. 11, 2026: 41 @ 9.68 |
| April 1, 2026 | issue | SO-260401-132 | MAIN | 93 | 9.68 | -900.70 | 402 | 3,893.33 | Feb. 11, 2026: 93 @ 9.68 |
| March 31, 2026 | issue | SO-260331-314 | MAIN | 19 | 9.68 | -184.01 | 495 | 4,794.03 | Feb. 11, 2026: 19 @ 9.68 |
| March 26, 2026 | issue | SO-260326-244 | EAST | 34 | 9.68 | -329.29 | 514 | 4,978.04 | Feb. 11, 2026: 34 @ 9.68 |
| March 24, 2026 | issue | SO-260324-680 | MAIN | 37 | 9.68 | -358.34 | 548 | 5,307.33 | Feb. 11, 2026: 37 @ 9.68 |
| March 22, 2026 | issue | SO-260322-537 | MAIN | 1 | 9.68 | -9.68 | 585 | 5,665.67 | Feb. 11, 2026: 1 @ 9.68 |
| March 19, 2026 | issue | SO-260319-614 | MAIN | 26 | 9.68 | -251.81 | 586 | 5,675.35 | Feb. 11, 2026: 26 @ 9.68 |
| March 7, 2026 | issue | SO-260307-568 | MAIN | 4 | 9.68 | -38.74 | 612 | 5,927.16 | Feb. 11, 2026: 4 @ 9.68 |
| March 5, 2026 | issue | SO-260305-688 | MAIN | 65 | 9.44 | -613.75 | 616 | 5,965.90 | Jan. 4, 2026: 61 @ 9.43; Feb. 11, 2026: 4 @ 9.68 |
| Feb. 15, 2026 | issue | SO-260215-584 | MAIN | 36 | 9.43 | -339.35 | 681 | 6,579.65 | Jan. 4, 2026: 36 @ 9.43 |
| Feb. 11, 2026 | receipt | PO-001218 | MAIN | 620 | 9.68 | 6,004.64 | 717 | 6,919.00 | |
| Feb. 5, 2026 | issue | SO-260205-337 | MAIN | 235 | 9.43 | -2,215.20 | 97 | 914.36 | Jan. 4, 2026: 235 @ 9.43 |
| Jan. 31, 2026 | issue | SO-260131-821 | MAIN | 55 | 9.43 | -518.45 | 332 | 3,129.56 | Jan. 4, 2026: 55 @ 9.43 |
| Jan. 25, 2026 | issue | SO-260125-877 | MAIN | 121 | 9.43 | -1,140.59 | 387 | 3,648.02 | Jan. 4, 2026: 121 @ 9.43 |
| Jan. 9, 2026 | issue | SO-260109-124 | EAST | 89 | 9.43 | -838.95 | 508 | 4,788.61 | Jan. 4, 2026: 89 @ 9.43 |
| Jan. 8, 2026 | issue | SO-260108-982 | EAST | 40 | 9.39 | -375.71 | 597 | 5,627.56 | Sept. 14, 2025: 17 @ 9.35; Jan. 4, 2026: 23 @ 9.43 |
| Jan. 4, 2026 | transfer | TRF | MAIN → EAST | 215 | warehouse transfer, no cost effect | ||||
| Jan. 4, 2026 | receipt | PO-001121 | MAIN | 620 | 9.43 | 5,844.37 | 637 | 6,003.28 | |
| Dec. 29, 2025 | issue | SO-251229-673 | MAIN | 65 | 9.35 | -607.59 | 17 | 158.91 | Sept. 14, 2025: 65 @ 9.35 |
| Dec. 29, 2025 | issue | SO-251229-673 | EAST | 63 | 9.35 | -588.89 | 82 | 766.50 | Sept. 14, 2025: 63 @ 9.35 |
| Dec. 12, 2025 | issue | SO-251212-738 | MAIN | 1 | 9.35 | -9.35 | 145 | 1,355.39 | Sept. 14, 2025: 1 @ 9.35 |
| Dec. 6, 2025 | issue | SO-251206-586 | MAIN | 124 | 9.35 | -1,159.09 | 146 | 1,364.74 | Sept. 14, 2025: 124 @ 9.35 |
| Nov. 29, 2025 | issue | SO-251129-887 | EAST | 6 | 9.35 | -56.08 | 270 | 2,523.82 | Sept. 14, 2025: 6 @ 9.35 |
| Nov. 22, 2025 | issue | SO-251122-815 | MAIN | 25 | 9.35 | -233.69 | 276 | 2,579.91 | Sept. 14, 2025: 25 @ 9.35 |
| Nov. 17, 2025 | issue | SO-251117-823 | EAST | 42 | 9.35 | -392.60 | 301 | 2,813.60 | Sept. 14, 2025: 42 @ 9.35 |
| Nov. 16, 2025 | issue | SO-251116-165 | MAIN | 18 | 9.35 | -168.26 | 343 | 3,206.19 | Sept. 14, 2025: 18 @ 9.35 |
| Nov. 14, 2025 | issue | SO-251114-309 | MAIN | 4 | 9.35 | -37.39 | 361 | 3,374.45 | Sept. 14, 2025: 4 @ 9.35 |
| Nov. 4, 2025 | issue | SO-251104-144 | MAIN | 54 | 9.35 | -504.76 | 365 | 3,411.84 | Sept. 14, 2025: 54 @ 9.35 |
| Oct. 11, 2025 | issue | SO-251011-967 | EAST | 104 | 9.35 | -972.14 | 419 | 3,916.60 | Sept. 14, 2025: 104 @ 9.35 |
| Oct. 9, 2025 | issue | SO-251009-264 | MAIN | 56 | 9.35 | -523.46 | 523 | 4,888.74 | Sept. 14, 2025: 56 @ 9.35 |
| Sept. 24, 2025 | issue | SO-250924-217 | MAIN | 17 | 9.35 | -158.91 | 579 | 5,412.20 | Sept. 14, 2025: 17 @ 9.35 |
| Sept. 22, 2025 | issue | SO-250922-160 | MAIN | 24 | 9.35 | -224.34 | 596 | 5,571.11 | Sept. 14, 2025: 24 @ 9.35 |