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