Items / SWT-0039
Modular Switch 6A Max SWT-0039 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)198MAIN 167, EAST 31
Value (FIFO)5,413.38avg 27.34
ClassBX / FCV 0.22
Turnover4.1xlast issue 4 days ago
Days of cover90lead 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 | 66.75 / 30.4375 | 2.193 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 14.68 / 5.517 | 2.661 |
| 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.661^2 + 2.193^2 * 1.5^2) | 12.8 |
| Reorder point | d * LT + safety stock | 2.193 * 7.0 + 12.8 | 28.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 28.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 800/yr, S = 45.00, h = 20%, price = 26.46 | 420.0 |
| Inventory position | on hand + on order | 198 + 0 | 198 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 27.56 | 114 | 22,691 | yes |
| 420 | 26.46 | 420 | 22,375 | yes (chosen if cheapest) |
| 840 | 25.36 | 840 | 22,468 | yes |
MOQ 210, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 9, 2026 | 198 / 210 | 27.34 | 5,413.38 |
Movement ledger 120 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-707 | EAST | 16 | 27.24 | -435.90 | 198 | 5,413.38 | July 17, 2026: 4 @ 26.95; Oct. 9, 2026: 12 @ 27.34 |
| Oct. 9, 2026 | transfer | TRF | MAIN → EAST | 47 | warehouse transfer, no cost effect | ||||
| Oct. 9, 2026 | receipt | PO-001863 | MAIN | 210 | 27.34 | 5,741.46 | 214 | 5,849.28 | |
| Oct. 4, 2026 | issue | SO-261004-603 | MAIN | 55 | 26.95 | -1,482.47 | 4 | 107.82 | July 17, 2026: 55 @ 26.95 |
| Sept. 30, 2026 | issue | SO-260930-855 | MAIN | 8 | 26.95 | -215.63 | 59 | 1,590.29 | July 17, 2026: 8 @ 26.95 |
| Sept. 27, 2026 | issue | SO-260927-617 | MAIN | 13 | 26.95 | -350.40 | 67 | 1,805.92 | July 17, 2026: 13 @ 26.95 |
| Sept. 26, 2026 | issue | SO-260926-155 | MAIN | 9 | 26.95 | -242.59 | 80 | 2,156.32 | July 17, 2026: 9 @ 26.95 |
| Sept. 11, 2026 | issue | SO-260911-875 | MAIN | 16 | 26.95 | -431.26 | 89 | 2,398.91 | July 17, 2026: 16 @ 26.95 |
| Sept. 9, 2026 | issue | SO-260909-156 | MAIN | 4 | 26.95 | -107.82 | 105 | 2,830.17 | July 17, 2026: 4 @ 26.95 |
| Sept. 3, 2026 | issue | SO-260903-770 | MAIN | 5 | 26.95 | -134.77 | 109 | 2,937.99 | July 17, 2026: 5 @ 26.95 |
| Aug. 28, 2026 | issue | SO-260828-461 | MAIN | 2 | 26.95 | -53.91 | 114 | 3,072.76 | July 17, 2026: 2 @ 26.95 |
| Aug. 25, 2026 | issue | SO-260825-320 | MAIN | 18 | 26.95 | -485.17 | 116 | 3,126.66 | July 17, 2026: 18 @ 26.95 |
| Aug. 9, 2026 | issue | SO-260809-717 | MAIN | 4 | 26.95 | -107.82 | 134 | 3,611.84 | July 17, 2026: 4 @ 26.95 |
| Aug. 8, 2026 | issue | SO-260808-807 | MAIN | 33 | 26.95 | -889.48 | 138 | 3,719.65 | July 17, 2026: 33 @ 26.95 |
| Aug. 3, 2026 | issue | SO-260803-727 | MAIN | 10 | 26.95 | -269.54 | 171 | 4,609.13 | July 17, 2026: 10 @ 26.95 |
| July 31, 2026 | issue | SO-260731-898 | MAIN | 15 | 26.95 | -404.31 | 181 | 4,878.67 | July 17, 2026: 15 @ 26.95 |
| July 20, 2026 | issue | SO-260720-285 | MAIN | 8 | 26.95 | -215.63 | 196 | 5,282.98 | July 17, 2026: 8 @ 26.95 |
| July 19, 2026 | issue | SO-260719-350 | MAIN | 17 | 26.72 | -454.16 | 204 | 5,498.62 | March 15, 2026: 5 @ 26.63; March 26, 2026: 6 @ 26.54; July 17, 2026: 6 @ 26.95 |
| July 17, 2026 | receipt | PO-001653 | MAIN | 210 | 26.95 | 5,660.34 | 221 | 5,952.78 | |
| July 12, 2026 | issue | SO-260712-902 | MAIN | 11 | 26.63 | -292.98 | 11 | 292.44 | March 15, 2026: 11 @ 26.63 |
| July 10, 2026 | issue | SO-260710-682 | MAIN | 12 | 26.63 | -319.61 | 22 | 585.41 | March 15, 2026: 12 @ 26.63 |
| July 7, 2026 | issue | SO-260707-720 | MAIN | 9 | 26.63 | -239.71 | 34 | 905.02 | March 15, 2026: 9 @ 26.63 |
| June 28, 2026 | issue | SO-260628-258 | MAIN | 12 | 26.63 | -319.61 | 43 | 1,144.73 | March 15, 2026: 12 @ 26.63 |
| June 16, 2026 | issue | SO-260616-578 | MAIN | 5 | 26.63 | -133.17 | 55 | 1,464.34 | March 15, 2026: 5 @ 26.63 |
| June 15, 2026 | issue | SO-260615-172 | MAIN | 20 | 26.63 | -532.68 | 60 | 1,597.51 | March 15, 2026: 20 @ 26.63 |
| June 6, 2026 | issue | SO-260606-851 | MAIN | 16 | 26.63 | -426.15 | 80 | 2,130.19 | March 15, 2026: 16 @ 26.63 |
| June 4, 2026 | issue | SO-260604-923 | MAIN | 9 | 26.63 | -239.71 | 96 | 2,556.33 | March 15, 2026: 9 @ 26.63 |
| May 29, 2026 | issue | SO-260529-914 | MAIN | 39 | 26.63 | -1,038.73 | 105 | 2,796.04 | March 15, 2026: 39 @ 26.63 |
| May 1, 2026 | issue | SO-260501-990 | MAIN | 11 | 26.63 | -292.98 | 144 | 3,834.77 | March 15, 2026: 11 @ 26.63 |
| April 29, 2026 | issue | SO-260429-103 | MAIN | 8 | 26.63 | -213.07 | 155 | 4,127.75 | March 15, 2026: 8 @ 26.63 |
| April 20, 2026 | issue | SO-260420-167 | MAIN | 11 | 26.63 | -292.98 | 163 | 4,340.82 | March 15, 2026: 11 @ 26.63 |
| April 17, 2026 | issue | SO-260417-507 | MAIN | 9 | 26.63 | -239.71 | 174 | 4,633.79 | March 15, 2026: 9 @ 26.63 |
| April 14, 2026 | issue | SO-260414-141 | MAIN | 14 | 26.63 | -372.88 | 183 | 4,873.50 | March 15, 2026: 14 @ 26.63 |
| April 4, 2026 | issue | SO-260404-532 | MAIN | 7 | 26.63 | -186.44 | 197 | 5,246.38 | March 15, 2026: 7 @ 26.63 |
| March 26, 2026 | return | RMA | MAIN | 6 | 26.54 | 159.27 | 204 | 5,432.82 | |
| March 25, 2026 | issue | SO-260325-813 | MAIN | 18 | 26.54 | -477.80 | 198 | 5,273.55 | Jan. 25, 2026: 6 @ 26.36; March 15, 2026: 12 @ 26.63 |
| March 22, 2026 | issue | SO-260322-782 | MAIN | 6 | 26.36 | -158.19 | 216 | 5,751.35 | Jan. 25, 2026: 6 @ 26.36 |
| March 21, 2026 | issue | SO-260321-448 | MAIN | 13 | 26.36 | -342.74 | 222 | 5,909.53 | Jan. 25, 2026: 13 @ 26.36 |
| March 16, 2026 | issue | SO-260316-696 | MAIN | 6 | 26.36 | -158.19 | 235 | 6,252.27 | Jan. 25, 2026: 6 @ 26.36 |
| March 15, 2026 | receipt | PO-001322 | MAIN | 210 | 26.63 | 5,593.16 | 241 | 6,410.46 | |
| March 6, 2026 | issue | SO-260306-837 | MAIN | 3 | 26.36 | -79.09 | 31 | 817.30 | Jan. 25, 2026: 3 @ 26.36 |
| March 3, 2026 | issue | SO-260303-406 | MAIN | 26 | 26.36 | -685.47 | 34 | 896.39 | Jan. 25, 2026: 26 @ 26.36 |
| March 1, 2026 | issue | SO-260301-366 | MAIN | 1 | 26.36 | -26.36 | 60 | 1,581.86 | Jan. 25, 2026: 1 @ 26.36 |
| Feb. 27, 2026 | issue | SO-260227-184 | MAIN | 49 | 26.36 | -1,291.86 | 61 | 1,608.23 | Jan. 25, 2026: 49 @ 26.36 |
| Feb. 17, 2026 | issue | SO-260217-991 | MAIN | 43 | 26.36 | -1,133.67 | 110 | 2,900.08 | Jan. 25, 2026: 43 @ 26.36 |
| Feb. 6, 2026 | issue | SO-260206-880 | MAIN | 16 | 26.36 | -421.83 | 153 | 4,033.75 | Jan. 25, 2026: 16 @ 26.36 |
| Jan. 29, 2026 | issue | SO-260129-629 | MAIN | 14 | 26.36 | -369.10 | 169 | 4,455.58 | Jan. 25, 2026: 14 @ 26.36 |
| Jan. 25, 2026 | issue | SO-260125-954 | MAIN | 27 | 26.36 | -711.84 | 183 | 4,824.69 | Jan. 25, 2026: 27 @ 26.36 |
| Jan. 25, 2026 | receipt | PO-001174 | MAIN | 210 | 26.36 | 5,536.52 | 210 | 5,536.52 | |
| Jan. 17, 2026 | issue | SO-260117-561 | MAIN | 35 | 27.18 | -951.36 | 0 | 0.00 | Oct. 5, 2025: 35 @ 27.18 |
| Dec. 31, 2025 | issue | SO-251231-881 | MAIN | 3 | 27.18 | -81.55 | 35 | 951.36 | Oct. 5, 2025: 3 @ 27.18 |
| Dec. 27, 2025 | issue | SO-251227-817 | MAIN | 50 | 27.18 | -1,359.09 | 38 | 1,032.91 | Oct. 5, 2025: 50 @ 27.18 |
| Dec. 18, 2025 | issue | SO-251218-551 | MAIN | 6 | 27.18 | -163.09 | 88 | 2,392.00 | Oct. 5, 2025: 6 @ 27.18 |
| Dec. 17, 2025 | issue | SO-251217-874 | MAIN | 7 | 27.18 | -190.27 | 94 | 2,555.09 | Oct. 5, 2025: 7 @ 27.18 |
| Dec. 6, 2025 | issue | SO-251206-481 | MAIN | 1 | 27.18 | -27.18 | 101 | 2,745.36 | Oct. 5, 2025: 1 @ 27.18 |
| Nov. 17, 2025 | adjustment | Cycle count | MAIN | -1 | 27.18 | -27.18 | 102 | 2,772.54 | Oct. 5, 2025: 1 @ 27.18 |
| Nov. 17, 2025 | issue | SO-251117-488 | MAIN | 4 | 27.18 | -108.73 | 103 | 2,799.73 | Oct. 5, 2025: 4 @ 27.18 |
| Nov. 13, 2025 | issue | SO-251113-837 | MAIN | 17 | 27.18 | -462.09 | 107 | 2,908.45 | Oct. 5, 2025: 17 @ 27.18 |
| Nov. 4, 2025 | issue | SO-251104-703 | MAIN | 43 | 27.18 | -1,168.82 | 124 | 3,370.54 | Oct. 5, 2025: 43 @ 27.18 |
| Oct. 24, 2025 | issue | SO-251024-384 | MAIN | 46 | 27.12 | -1,247.39 | 167 | 4,539.36 | Sept. 1, 2025: 3 @ 26.19; Oct. 5, 2025: 43 @ 27.18 |
| Oct. 5, 2025 | issue | SO-251005-376 | MAIN | 13 | 26.19 | -340.50 | 213 | 5,786.75 | June 11, 2025: 11 @ 26.19; Sept. 1, 2025: 2 @ 26.19 |
| Oct. 5, 2025 | receipt | PO-000901 | MAIN | 210 | 27.18 | 5,708.18 | 226 | 6,127.25 | |
| Oct. 4, 2025 | issue | SO-251004-334 | MAIN | 5 | 26.19 | -130.96 | 16 | 419.08 | June 11, 2025: 5 @ 26.19 |
| Sept. 28, 2025 | issue | SO-250928-473 | MAIN | 50 | 26.19 | -1,309.61 | 21 | 550.04 | June 11, 2025: 50 @ 26.19 |
| Sept. 25, 2025 | issue | SO-250925-852 | MAIN | 3 | 26.19 | -78.58 | 71 | 1,859.65 | June 11, 2025: 3 @ 26.19 |
| Sept. 24, 2025 | issue | SO-250924-558 | MAIN | 16 | 26.19 | -419.08 | 74 | 1,938.22 | June 11, 2025: 16 @ 26.19 |
| Sept. 18, 2025 | issue | SO-250918-926 | MAIN | 8 | 26.19 | -209.54 | 90 | 2,357.30 | June 11, 2025: 8 @ 26.19 |
| Sept. 1, 2025 | return | RMA | MAIN | 5 | 26.19 | 130.96 | 98 | 2,566.84 | |
| Aug. 25, 2025 | issue | SO-250825-389 | MAIN | 11 | 26.19 | -288.11 | 93 | 2,435.87 | June 11, 2025: 11 @ 26.19 |
| Aug. 23, 2025 | issue | SO-250823-664 | MAIN | 6 | 26.19 | -157.15 | 104 | 2,723.99 | June 11, 2025: 6 @ 26.19 |
| Aug. 19, 2025 | issue | SO-250819-865 | MAIN | 9 | 26.19 | -235.73 | 110 | 2,881.14 | June 11, 2025: 9 @ 26.19 |
| Aug. 16, 2025 | issue | SO-250816-636 | MAIN | 5 | 26.19 | -130.96 | 119 | 3,116.87 | June 11, 2025: 5 @ 26.19 |
| Aug. 15, 2025 | issue | SO-250815-502 | MAIN | 3 | 26.19 | -78.58 | 124 | 3,247.83 | June 11, 2025: 3 @ 26.19 |
| Aug. 14, 2025 | issue | SO-250814-396 | MAIN | 7 | 26.19 | -183.35 | 127 | 3,326.41 | June 11, 2025: 7 @ 26.19 |
| July 27, 2025 | issue | SO-250727-923 | MAIN | 37 | 26.19 | -969.11 | 134 | 3,509.75 | June 11, 2025: 37 @ 26.19 |
| July 26, 2025 | issue | SO-250726-549 | MAIN | 12 | 26.19 | -314.31 | 171 | 4,478.87 | June 11, 2025: 12 @ 26.19 |
| July 18, 2025 | issue | SO-250718-445 | MAIN | 2 | 26.19 | -52.38 | 183 | 4,793.17 | June 11, 2025: 2 @ 26.19 |
| July 17, 2025 | issue | SO-250717-752 | MAIN | 12 | 26.19 | -314.31 | 185 | 4,845.56 | June 11, 2025: 12 @ 26.19 |
| July 4, 2025 | issue | SO-250704-783 | MAIN | 1 | 26.19 | -26.19 | 197 | 5,159.86 | June 11, 2025: 1 @ 26.19 |
| June 18, 2025 | issue | SO-250618-336 | MAIN | 12 | 26.19 | -314.31 | 198 | 5,186.06 | June 11, 2025: 12 @ 26.19 |
| June 11, 2025 | receipt | PO-000625 | MAIN | 210 | 26.19 | 5,500.36 | 210 | 5,500.36 | |
| June 5, 2025 | issue | SO-250605-244 | MAIN | 36 | 25.07 | -902.45 | 0 | 0.00 | March 18, 2025: 36 @ 25.07 |
| June 3, 2025 | issue | SO-250603-373 | MAIN | 16 | 25.07 | -401.09 | 36 | 902.45 | March 18, 2025: 16 @ 25.07 |
| June 3, 2025 | issue | SO-250603-373 | EAST | 13 | 25.07 | -325.89 | 52 | 1,303.54 | March 18, 2025: 13 @ 25.07 |
| May 30, 2025 | issue | SO-250530-830 | MAIN | 10 | 25.07 | -250.68 | 65 | 1,629.43 | March 18, 2025: 10 @ 25.07 |
| May 25, 2025 | issue | SO-250525-416 | MAIN | 12 | 25.07 | -300.82 | 75 | 1,880.11 | March 18, 2025: 12 @ 25.07 |
| May 18, 2025 | issue | SO-250518-506 | EAST | 1 | 25.07 | -25.07 | 87 | 2,180.92 | March 18, 2025: 1 @ 25.07 |
| May 12, 2025 | issue | SO-250512-532 | EAST | 19 | 25.07 | -476.29 | 88 | 2,205.99 | March 18, 2025: 19 @ 25.07 |
| May 7, 2025 | issue | SO-250507-286 | MAIN | 3 | 25.07 | -75.20 | 107 | 2,682.29 | March 18, 2025: 3 @ 25.07 |
| May 3, 2025 | issue | SO-250503-163 | MAIN | 22 | 25.07 | -551.50 | 110 | 2,757.49 | March 18, 2025: 22 @ 25.07 |
| May 1, 2025 | issue | SO-250501-931 | MAIN | 5 | 25.07 | -125.34 | 132 | 3,308.99 | March 18, 2025: 5 @ 25.07 |
| April 22, 2025 | issue | SO-250422-694 | EAST | 16 | 25.07 | -401.09 | 137 | 3,434.33 | March 18, 2025: 16 @ 25.07 |
| April 7, 2025 | issue | SO-250407-347 | MAIN | 60 | 25.10 | -1,506.03 | 153 | 3,835.42 | Jan. 13, 2025: 3 @ 25.72; March 18, 2025: 57 @ 25.07 |
| March 18, 2025 | transfer | TRF | MAIN → EAST | 46 | warehouse transfer, no cost effect | ||||
| March 18, 2025 | receipt | PO-000354 | MAIN | 210 | 25.07 | 5,264.30 | 213 | 5,341.45 | |
| March 10, 2025 | issue | SO-250310-924 | EAST | 19 | 25.72 | -488.63 | 3 | 77.15 | Jan. 13, 2025: 19 @ 25.72 |
| March 10, 2025 | issue | SO-250310-924 | MAIN | 28 | 25.72 | -720.08 | 22 | 565.78 | Jan. 13, 2025: 28 @ 25.72 |
| March 4, 2025 | issue | SO-250304-996 | EAST | 23 | 25.72 | -591.50 | 50 | 1,285.86 | Jan. 13, 2025: 23 @ 25.72 |
| Feb. 16, 2025 | issue | SO-250216-988 | MAIN | 19 | 25.72 | -488.63 | 73 | 1,877.36 | Jan. 13, 2025: 19 @ 25.72 |
| Feb. 9, 2025 | issue | SO-250209-556 | EAST | 36 | 25.72 | -925.82 | 92 | 2,365.99 | Jan. 13, 2025: 36 @ 25.72 |
| Feb. 1, 2025 | issue | SO-250201-970 | MAIN | 33 | 25.72 | -848.67 | 128 | 3,291.81 | Jan. 13, 2025: 33 @ 25.72 |
| Jan. 21, 2025 | issue | SO-250121-694 | MAIN | 15 | 25.72 | -385.76 | 161 | 4,140.49 | Jan. 13, 2025: 15 @ 25.72 |
| Jan. 16, 2025 | issue | SO-250116-326 | MAIN | 49 | 25.86 | -1,267.12 | 176 | 4,526.24 | Oct. 1, 2024: 14 @ 26.18; Nov. 8, 2024: 1 @ 26.18; Jan. 13, 2025: 34 @ 25.72 |
| Jan. 14, 2025 | issue | SO-250114-926 | MAIN | 8 | 26.18 | -209.46 | 225 | 5,793.36 | Oct. 1, 2024: 8 @ 26.18 |
| Jan. 13, 2025 | transfer | TRF | MAIN → EAST | 62 | warehouse transfer, no cost effect | ||||
| Jan. 13, 2025 | receipt | PO-000183 | MAIN | 210 | 25.72 | 5,400.63 | 233 | 6,002.82 | |
| Jan. 6, 2025 | issue | SO-250106-659 | MAIN | 12 | 26.18 | -314.18 | 23 | 602.19 | Oct. 1, 2024: 12 @ 26.18 |
| Dec. 26, 2024 | issue | SO-241226-779 | EAST | 49 | 26.18 | -1,282.92 | 35 | 916.37 | Oct. 1, 2024: 49 @ 26.18 |
| Dec. 19, 2024 | issue | SO-241219-589 | EAST | 2 | 26.18 | -52.36 | 84 | 2,199.29 | Oct. 1, 2024: 2 @ 26.18 |
| Nov. 21, 2024 | issue | SO-241121-114 | MAIN | 13 | 26.18 | -340.37 | 86 | 2,251.65 | Oct. 1, 2024: 13 @ 26.18 |
| Nov. 17, 2024 | issue | SO-241117-388 | MAIN | 7 | 26.18 | -183.27 | 99 | 2,592.02 | Oct. 1, 2024: 7 @ 26.18 |
| Nov. 12, 2024 | issue | SO-241112-379 | MAIN | 40 | 26.18 | -1,047.28 | 106 | 2,775.29 | Oct. 1, 2024: 40 @ 26.18 |
| Nov. 8, 2024 | return | RMA | MAIN | 1 | 26.18 | 26.18 | 146 | 3,822.57 | |
| Nov. 3, 2024 | issue | SO-241103-524 | EAST | 2 | 26.18 | -52.36 | 145 | 3,796.39 | Oct. 1, 2024: 2 @ 26.18 |
| Oct. 26, 2024 | issue | SO-241026-412 | MAIN | 9 | 26.18 | -235.64 | 147 | 3,848.75 | Oct. 1, 2024: 9 @ 26.18 |
| Oct. 22, 2024 | issue | SO-241022-913 | MAIN | 30 | 26.18 | -785.46 | 156 | 4,084.39 | Oct. 1, 2024: 30 @ 26.18 |
| Oct. 9, 2024 | issue | SO-241009-355 | MAIN | 8 | 26.18 | -209.46 | 186 | 4,869.85 | Oct. 1, 2024: 8 @ 26.18 |
| Oct. 1, 2024 | issue | SO-241001-685 | MAIN | 16 | 26.18 | -418.91 | 194 | 5,079.31 | Oct. 1, 2024: 16 @ 26.18 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 72 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 210 | 26.18 | 5,498.22 | 210 | 5,498.22 | |