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
| 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 |
| Sept. 14, 2025 | transfer | TRF | MAIN → EAST | 215 | warehouse transfer, no cost effect | ||||
| Sept. 14, 2025 | receipt | PO-000844 | MAIN | 620 | 9.35 | 5,795.45 | 620 | 5,795.45 | |
| Sept. 7, 2025 | issue | SO-250907-461 | MAIN | 247 | 9.32 | -2,301.03 | 0 | 0.00 | June 16, 2025: 247 @ 9.32 |
| Aug. 23, 2025 | issue | SO-250823-419 | MAIN | 77 | 9.32 | -717.32 | 247 | 2,301.03 | June 16, 2025: 77 @ 9.32 |
| Aug. 14, 2025 | issue | SO-250814-815 | MAIN | 10 | 9.32 | -93.16 | 324 | 3,018.35 | June 16, 2025: 10 @ 9.32 |
| Aug. 12, 2025 | issue | SO-250812-434 | MAIN | 14 | 9.32 | -130.42 | 334 | 3,111.51 | June 16, 2025: 14 @ 9.32 |
| Aug. 4, 2025 | issue | SO-250804-910 | MAIN | 17 | 9.32 | -158.37 | 348 | 3,241.93 | June 16, 2025: 17 @ 9.32 |
| Aug. 1, 2025 | issue | SO-250801-701 | MAIN | 10 | 9.32 | -93.16 | 365 | 3,400.30 | June 16, 2025: 10 @ 9.32 |
| July 29, 2025 | issue | SO-250729-143 | MAIN | 4 | 9.32 | -37.26 | 375 | 3,493.46 | June 16, 2025: 4 @ 9.32 |
| July 20, 2025 | issue | SO-250720-895 | MAIN | 11 | 9.32 | -102.47 | 379 | 3,530.73 | June 16, 2025: 11 @ 9.32 |
| July 14, 2025 | issue | SO-250714-873 | MAIN | 128 | 9.32 | -1,192.44 | 390 | 3,633.20 | June 16, 2025: 128 @ 9.32 |
| July 12, 2025 | issue | SO-250712-548 | MAIN | 4 | 9.32 | -37.26 | 518 | 4,825.64 | June 16, 2025: 4 @ 9.32 |
| July 7, 2025 | issue | SO-250707-386 | MAIN | 90 | 9.32 | -838.43 | 522 | 4,862.90 | June 16, 2025: 90 @ 9.32 |
| July 4, 2025 | issue | SO-250704-532 | MAIN | 8 | 9.32 | -74.53 | 612 | 5,701.33 | June 16, 2025: 8 @ 9.32 |
| June 16, 2025 | receipt | PO-000642 | MAIN | 620 | 9.32 | 5,775.86 | 620 | 5,775.86 | |
| June 12, 2025 | issue | SO-250612-725 | MAIN | 65 | 9.20 | -598.24 | 0 | 0.00 | March 14, 2025: 65 @ 9.20 |
| June 10, 2025 | issue | SO-250610-801 | MAIN | 11 | 9.20 | -101.24 | 65 | 598.24 | March 14, 2025: 11 @ 9.20 |
| June 7, 2025 | issue | SO-250607-279 | MAIN | 33 | 9.20 | -303.72 | 76 | 699.48 | March 14, 2025: 33 @ 9.20 |
| June 3, 2025 | issue | SO-250603-934 | MAIN | 16 | 9.20 | -147.26 | 109 | 1,003.20 | March 14, 2025: 16 @ 9.20 |
| May 22, 2025 | issue | SO-250522-144 | MAIN | 259 | 9.20 | -2,383.76 | 125 | 1,150.46 | March 14, 2025: 259 @ 9.20 |
| May 16, 2025 | issue | SO-250516-886 | MAIN | 28 | 9.20 | -257.70 | 384 | 3,534.22 | March 14, 2025: 28 @ 9.20 |
| April 24, 2025 | issue | SO-250424-420 | MAIN | 27 | 9.20 | -248.50 | 412 | 3,791.92 | March 14, 2025: 27 @ 9.20 |
| April 23, 2025 | issue | SO-250423-995 | MAIN | 39 | 9.20 | -358.94 | 439 | 4,040.42 | March 14, 2025: 39 @ 9.20 |
| April 22, 2025 | issue | SO-250422-661 | MAIN | 82 | 9.20 | -754.70 | 478 | 4,399.37 | March 14, 2025: 82 @ 9.20 |
| April 4, 2025 | issue | SO-250404-722 | MAIN | 58 | 9.20 | -533.81 | 560 | 5,154.07 | March 14, 2025: 58 @ 9.20 |
| March 22, 2025 | issue | SO-250322-408 | MAIN | 42 | 9.27 | -389.36 | 618 | 5,687.89 | Dec. 16, 2024: 40 @ 9.27; March 14, 2025: 2 @ 9.20 |
| March 16, 2025 | issue | SO-250316-178 | MAIN | 46 | 9.27 | -426.59 | 660 | 6,077.24 | Dec. 16, 2024: 46 @ 9.27 |
| March 14, 2025 | receipt | PO-000342 | MAIN | 620 | 9.20 | 5,706.29 | 706 | 6,503.83 | |
| March 7, 2025 | issue | SO-250307-113 | MAIN | 129 | 9.27 | -1,196.31 | 86 | 797.54 | Dec. 16, 2024: 129 @ 9.27 |
| Feb. 21, 2025 | issue | SO-250221-307 | MAIN | 26 | 9.27 | -241.12 | 215 | 1,993.85 | Dec. 16, 2024: 26 @ 9.27 |
| Feb. 20, 2025 | issue | SO-250220-837 | MAIN | 53 | 9.27 | -491.51 | 241 | 2,234.96 | Dec. 16, 2024: 53 @ 9.27 |
| Feb. 16, 2025 | issue | SO-250216-939 | MAIN | 5 | 9.27 | -46.37 | 294 | 2,726.47 | Dec. 16, 2024: 5 @ 9.27 |
| Feb. 10, 2025 | issue | SO-250210-934 | MAIN | 9 | 9.27 | -83.46 | 299 | 2,772.84 | Dec. 16, 2024: 9 @ 9.27 |
| Feb. 6, 2025 | issue | SO-250206-850 | MAIN | 22 | 9.27 | -204.02 | 308 | 2,856.30 | Dec. 16, 2024: 22 @ 9.27 |
| Feb. 3, 2025 | issue | SO-250203-401 | MAIN | 17 | 9.27 | -157.65 | 330 | 3,060.32 | Dec. 16, 2024: 17 @ 9.27 |
| Jan. 31, 2025 | issue | SO-250131-512 | MAIN | 65 | 9.27 | -602.79 | 347 | 3,217.97 | Dec. 16, 2024: 65 @ 9.27 |
| Jan. 27, 2025 | issue | SO-250127-896 | MAIN | 4 | 9.27 | -37.09 | 412 | 3,820.76 | Dec. 16, 2024: 4 @ 9.27 |
| Jan. 25, 2025 | issue | SO-250125-324 | MAIN | 70 | 9.27 | -649.16 | 416 | 3,857.86 | Dec. 16, 2024: 70 @ 9.27 |
| Jan. 21, 2025 | issue | SO-250121-465 | MAIN | 40 | 9.27 | -370.95 | 486 | 4,507.02 | Dec. 16, 2024: 40 @ 9.27 |
| Jan. 12, 2025 | issue | SO-250112-552 | MAIN | 33 | 9.27 | -306.03 | 526 | 4,877.97 | Dec. 16, 2024: 33 @ 9.27 |
| Jan. 10, 2025 | issue | SO-250110-380 | MAIN | 28 | 9.27 | -259.66 | 559 | 5,184.00 | Dec. 16, 2024: 28 @ 9.27 |
| Jan. 1, 2025 | issue | SO-250101-919 | MAIN | 11 | 9.27 | -102.01 | 587 | 5,443.66 | Dec. 16, 2024: 11 @ 9.27 |
| Dec. 26, 2024 | issue | SO-241226-888 | MAIN | 37 | 9.35 | -345.95 | 598 | 5,545.67 | Oct. 1, 2024: 15 @ 9.46; Dec. 16, 2024: 22 @ 9.27 |
| Dec. 16, 2024 | receipt | PO-000109 | MAIN | 620 | 9.27 | 5,749.69 | 635 | 5,891.62 | |
| Dec. 12, 2024 | issue | SO-241212-590 | MAIN | 50 | 9.46 | -473.10 | 15 | 141.93 | Oct. 1, 2024: 50 @ 9.46 |
| Dec. 10, 2024 | issue | SO-241210-554 | MAIN | 89 | 9.46 | -842.12 | 65 | 615.03 | Oct. 1, 2024: 89 @ 9.46 |
| Dec. 6, 2024 | issue | SO-241206-522 | MAIN | 23 | 9.46 | -217.63 | 154 | 1,457.15 | Oct. 1, 2024: 23 @ 9.46 |
| Dec. 4, 2024 | issue | SO-241204-678 | MAIN | 8 | 9.46 | -75.70 | 177 | 1,674.77 | Oct. 1, 2024: 8 @ 9.46 |
| Nov. 19, 2024 | issue | SO-241119-784 | MAIN | 93 | 9.46 | -879.97 | 185 | 1,750.47 | Oct. 1, 2024: 93 @ 9.46 |
| Nov. 14, 2024 | adjustment | Cycle count | MAIN | -2 | 9.46 | -18.92 | 278 | 2,630.44 | Oct. 1, 2024: 2 @ 9.46 |
| Nov. 10, 2024 | issue | SO-241110-288 | MAIN | 86 | 9.46 | -813.73 | 280 | 2,649.36 | Oct. 1, 2024: 86 @ 9.46 |
| Oct. 30, 2024 | issue | SO-241030-631 | MAIN | 64 | 9.46 | -605.57 | 366 | 3,463.09 | Oct. 1, 2024: 64 @ 9.46 |
| Oct. 28, 2024 | issue | SO-241028-532 | MAIN | 58 | 9.46 | -548.80 | 430 | 4,068.66 | Oct. 1, 2024: 58 @ 9.46 |
| Oct. 18, 2024 | issue | SO-241018-227 | MAIN | 8 | 9.46 | -75.70 | 488 | 4,617.46 | Oct. 1, 2024: 8 @ 9.46 |
| Oct. 14, 2024 | issue | SO-241014-152 | MAIN | 124 | 9.46 | -1,173.29 | 496 | 4,693.15 | Oct. 1, 2024: 124 @ 9.46 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 620 | 9.46 | 5,866.44 | 620 | 5,866.44 | |