Items / SWT-0001
Modular Switch 6A Max SWT-0001 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)149MAIN 149
Value (FIFO)1,130.27avg 7.59
ClassCX / FCV 0.34
Turnover4.0xlast issue 0 days ago
Days of cover81lead 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 | 55.83 / 30.4375 | 1.834 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 19.24 / 5.517 | 3.488 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(7.0 * 3.488^2 + 1.834^2 * 1.5^2) | 12.3 |
| Reorder point | d * LT + safety stock | 1.834 * 7.0 + 12.3 | 25.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 25.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 670/yr, S = 45.00, h = 20%, price = 7.40 | 201.8 |
| Inventory position | on hand + on order | 149 + 0 | 149 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.40 | 202 | 5,253 | yes (chosen if cheapest) |
MOQ 160, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 7, 2026 | 149 / 160 | 7.59 | 1,130.27 |
Movement ledger 107 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-635 | MAIN | 3 | 7.59 | -22.76 | 149 | 1,130.27 | Oct. 7, 2026: 3 @ 7.59 |
| Oct. 15, 2026 | issue | SO-261015-729 | MAIN | 5 | 7.59 | -37.93 | 152 | 1,153.03 | Oct. 7, 2026: 5 @ 7.59 |
| Oct. 9, 2026 | issue | SO-261009-915 | MAIN | 3 | 7.59 | -22.76 | 157 | 1,190.95 | Oct. 7, 2026: 3 @ 7.59 |
| Oct. 7, 2026 | receipt | PO-001856 | MAIN | 160 | 7.59 | 1,213.71 | 160 | 1,213.71 | |
| Oct. 5, 2026 | issue | SO-261005-308 | EAST | 24 | 7.33 | -175.85 | 0 | 0.00 | July 8, 2026: 24 @ 7.33 |
| Sept. 29, 2026 | issue | SO-260929-327 | EAST | 16 | 7.33 | -117.23 | 24 | 175.85 | July 8, 2026: 16 @ 7.33 |
| Sept. 27, 2026 | issue | SO-260927-560 | EAST | 10 | 7.33 | -73.27 | 40 | 293.08 | July 8, 2026: 10 @ 7.33 |
| Sept. 25, 2026 | issue | SO-260925-444 | EAST | 6 | 7.33 | -43.96 | 50 | 366.36 | July 8, 2026: 6 @ 7.33 |
| Sept. 25, 2026 | issue | SO-260925-444 | MAIN | 6 | 7.33 | -43.96 | 56 | 410.32 | July 8, 2026: 6 @ 7.33 |
| Sept. 22, 2026 | issue | SO-260922-539 | EAST | 6 | 7.33 | -43.96 | 62 | 454.28 | July 8, 2026: 6 @ 7.33 |
| Sept. 17, 2026 | issue | SO-260917-875 | MAIN | 1 | 7.33 | -7.33 | 68 | 498.24 | July 8, 2026: 1 @ 7.33 |
| Sept. 16, 2026 | issue | SO-260916-681 | EAST | 6 | 7.33 | -43.96 | 69 | 505.57 | July 8, 2026: 6 @ 7.33 |
| Aug. 21, 2026 | issue | SO-260821-220 | MAIN | 41 | 7.33 | -300.41 | 75 | 549.53 | July 8, 2026: 41 @ 7.33 |
| Aug. 3, 2026 | issue | SO-260803-838 | MAIN | 43 | 7.33 | -315.07 | 116 | 849.94 | July 8, 2026: 43 @ 7.33 |
| July 17, 2026 | issue | SO-260717-608 | MAIN | 17 | 7.32 | -124.42 | 159 | 1,165.01 | April 28, 2026: 16 @ 7.32; July 8, 2026: 1 @ 7.33 |
| July 12, 2026 | issue | SO-260712-211 | EAST | 1 | 7.32 | -7.32 | 176 | 1,289.43 | April 28, 2026: 1 @ 7.32 |
| July 8, 2026 | transfer | TRF | MAIN → EAST | 52 | warehouse transfer, no cost effect | ||||
| July 8, 2026 | receipt | PO-001635 | MAIN | 160 | 7.33 | 1,172.34 | 177 | 1,296.75 | |
| July 1, 2026 | issue | SO-260701-252 | EAST | 12 | 7.32 | -87.82 | 17 | 124.41 | April 28, 2026: 12 @ 7.32 |
| July 1, 2026 | issue | SO-260701-252 | MAIN | 32 | 7.32 | -234.18 | 29 | 212.23 | April 28, 2026: 32 @ 7.32 |
| June 24, 2026 | issue | SO-260624-384 | MAIN | 4 | 7.32 | -29.27 | 61 | 446.41 | April 28, 2026: 4 @ 7.32 |
| June 22, 2026 | issue | SO-260622-377 | MAIN | 27 | 7.32 | -197.59 | 65 | 475.68 | April 28, 2026: 27 @ 7.32 |
| June 20, 2026 | issue | SO-260620-385 | MAIN | 2 | 7.32 | -14.64 | 92 | 673.27 | April 28, 2026: 2 @ 7.32 |
| June 18, 2026 | issue | SO-260618-688 | MAIN | 12 | 7.32 | -87.82 | 94 | 687.91 | April 28, 2026: 12 @ 7.32 |
| June 17, 2026 | issue | SO-260617-497 | MAIN | 8 | 7.32 | -58.55 | 106 | 775.73 | April 28, 2026: 8 @ 7.32 |
| June 9, 2026 | issue | SO-260609-603 | MAIN | 5 | 7.32 | -36.59 | 114 | 834.27 | April 28, 2026: 5 @ 7.32 |
| May 30, 2026 | issue | SO-260530-314 | EAST | 6 | 7.32 | -43.91 | 119 | 870.87 | April 28, 2026: 6 @ 7.32 |
| May 28, 2026 | issue | SO-260528-813 | MAIN | 22 | 7.32 | -161.00 | 125 | 914.78 | April 28, 2026: 22 @ 7.32 |
| May 19, 2026 | issue | SO-260519-704 | MAIN | 5 | 7.32 | -36.59 | 147 | 1,075.78 | April 28, 2026: 5 @ 7.32 |
| May 15, 2026 | issue | SO-260515-731 | MAIN | 9 | 7.29 | -65.63 | 152 | 1,112.37 | Feb. 6, 2026: 1 @ 7.08; April 28, 2026: 8 @ 7.32 |
| April 28, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| April 28, 2026 | receipt | PO-001448 | MAIN | 160 | 7.32 | 1,170.91 | 161 | 1,177.99 | |
| April 25, 2026 | issue | SO-260425-577 | MAIN | 6 | 7.08 | -42.49 | 1 | 7.08 | Dec. 25, 2025: 5 @ 7.08; Feb. 6, 2026: 1 @ 7.08 |
| April 21, 2026 | issue | SO-260421-304 | MAIN | 22 | 7.08 | -155.78 | 7 | 49.57 | Dec. 25, 2025: 22 @ 7.08 |
| April 3, 2026 | issue | SO-260403-706 | MAIN | 5 | 7.08 | -35.41 | 29 | 205.35 | Dec. 25, 2025: 5 @ 7.08 |
| March 28, 2026 | issue | SO-260328-281 | MAIN | 1 | 7.08 | -7.08 | 34 | 240.76 | Dec. 25, 2025: 1 @ 7.08 |
| March 13, 2026 | issue | SO-260313-678 | MAIN | 54 | 7.08 | -382.38 | 35 | 247.84 | Dec. 25, 2025: 54 @ 7.08 |
| Feb. 15, 2026 | issue | SO-260215-526 | MAIN | 7 | 7.08 | -49.57 | 89 | 630.22 | Dec. 25, 2025: 7 @ 7.08 |
| Feb. 10, 2026 | issue | SO-260210-913 | MAIN | 32 | 7.08 | -226.60 | 96 | 679.79 | Dec. 25, 2025: 32 @ 7.08 |
| Feb. 6, 2026 | return | RMA | MAIN | 2 | 7.08 | 14.16 | 128 | 906.38 | |
| Feb. 6, 2026 | issue | SO-260206-273 | MAIN | 2 | 7.08 | -14.16 | 126 | 892.22 | Dec. 25, 2025: 2 @ 7.08 |
| Jan. 28, 2026 | issue | SO-260128-334 | MAIN | 1 | 7.08 | -7.08 | 128 | 906.38 | Dec. 25, 2025: 1 @ 7.08 |
| Jan. 25, 2026 | issue | SO-260125-467 | MAIN | 4 | 7.08 | -28.32 | 129 | 913.46 | Dec. 25, 2025: 4 @ 7.08 |
| Jan. 19, 2026 | issue | SO-260119-711 | MAIN | 4 | 7.08 | -28.32 | 133 | 941.79 | Dec. 25, 2025: 4 @ 7.08 |
| Jan. 12, 2026 | issue | SO-260112-183 | MAIN | 3 | 7.08 | -21.24 | 137 | 970.11 | Dec. 25, 2025: 3 @ 7.08 |
| Jan. 9, 2026 | issue | SO-260109-594 | MAIN | 11 | 7.08 | -77.89 | 140 | 991.35 | Dec. 25, 2025: 11 @ 7.08 |
| Jan. 8, 2026 | issue | SO-260108-984 | MAIN | 6 | 7.08 | -42.49 | 151 | 1,069.25 | Dec. 25, 2025: 6 @ 7.08 |
| Jan. 4, 2026 | issue | SO-260104-351 | MAIN | 4 | 7.10 | -28.41 | 157 | 1,111.73 | Oct. 16, 2025: 1 @ 7.17; Dec. 25, 2025: 3 @ 7.08 |
| Dec. 30, 2025 | issue | SO-251230-630 | MAIN | 5 | 7.17 | -35.84 | 161 | 1,140.14 | Oct. 16, 2025: 5 @ 7.17 |
| Dec. 25, 2025 | receipt | PO-001088 | MAIN | 160 | 7.08 | 1,132.98 | 166 | 1,175.98 | |
| Dec. 18, 2025 | issue | SO-251218-806 | MAIN | 14 | 7.17 | -100.35 | 6 | 43.01 | Oct. 16, 2025: 14 @ 7.17 |
| Dec. 18, 2025 | issue | SO-251218-806 | EAST | 27 | 7.17 | -193.53 | 20 | 143.35 | Oct. 16, 2025: 27 @ 7.17 |
| Dec. 10, 2025 | issue | SO-251210-788 | MAIN | 21 | 7.17 | -150.52 | 47 | 336.88 | Oct. 16, 2025: 21 @ 7.17 |
| Nov. 28, 2025 | adjustment | Cycle count | MAIN | -1 | 7.17 | -7.17 | 68 | 487.40 | Oct. 16, 2025: 1 @ 7.17 |
| Nov. 18, 2025 | issue | SO-251118-512 | MAIN | 45 | 7.17 | -322.55 | 69 | 494.57 | Oct. 16, 2025: 45 @ 7.17 |
| Nov. 10, 2025 | issue | SO-251110-850 | MAIN | 42 | 7.17 | -301.04 | 114 | 817.12 | Oct. 16, 2025: 42 @ 7.17 |
| Nov. 8, 2025 | issue | SO-251108-881 | MAIN | 12 | 6.97 | -83.69 | 156 | 1,118.16 | July 31, 2025: 8 @ 6.88; Oct. 16, 2025: 4 @ 7.17 |
| Oct. 22, 2025 | issue | SO-251022-384 | EAST | 5 | 6.88 | -34.38 | 168 | 1,201.85 | July 31, 2025: 5 @ 6.88 |
| Oct. 20, 2025 | issue | SO-251020-356 | MAIN | 4 | 6.88 | -27.51 | 173 | 1,236.23 | July 31, 2025: 4 @ 6.88 |
| Oct. 16, 2025 | transfer | TRF | MAIN → EAST | 32 | warehouse transfer, no cost effect | ||||
| Oct. 16, 2025 | receipt | PO-000926 | MAIN | 160 | 7.17 | 1,146.83 | 177 | 1,263.74 | |
| Oct. 8, 2025 | issue | SO-251008-504 | MAIN | 28 | 6.88 | -192.56 | 17 | 116.91 | July 31, 2025: 28 @ 6.88 |
| Oct. 4, 2025 | issue | SO-251004-939 | MAIN | 10 | 6.88 | -68.77 | 45 | 309.46 | July 31, 2025: 10 @ 6.88 |
| Sept. 30, 2025 | issue | SO-250930-371 | MAIN | 2 | 6.88 | -13.75 | 55 | 378.24 | July 31, 2025: 2 @ 6.88 |
| Sept. 29, 2025 | issue | SO-250929-938 | MAIN | 1 | 6.88 | -6.88 | 57 | 391.99 | July 31, 2025: 1 @ 6.88 |
| Sept. 25, 2025 | issue | SO-250925-649 | MAIN | 1 | 6.88 | -6.88 | 58 | 398.87 | July 31, 2025: 1 @ 6.88 |
| Sept. 1, 2025 | issue | SO-250901-610 | MAIN | 38 | 6.88 | -261.33 | 59 | 405.74 | July 31, 2025: 38 @ 6.88 |
| Aug. 27, 2025 | issue | SO-250827-740 | MAIN | 31 | 6.88 | -213.19 | 97 | 667.07 | July 31, 2025: 31 @ 6.88 |
| Aug. 17, 2025 | issue | SO-250817-519 | MAIN | 3 | 6.88 | -20.63 | 128 | 880.26 | July 31, 2025: 3 @ 6.88 |
| Aug. 2, 2025 | issue | SO-250802-781 | MAIN | 29 | 6.88 | -199.43 | 131 | 900.89 | July 31, 2025: 29 @ 6.88 |
| July 31, 2025 | receipt | PO-000746 | MAIN | 160 | 6.88 | 1,100.32 | 160 | 1,100.32 | |
| July 25, 2025 | issue | SO-250725-262 | MAIN | 6 | 7.13 | -42.79 | 0 | 0.00 | May 1, 2025: 6 @ 7.13 |
| July 23, 2025 | issue | SO-250723-831 | MAIN | 38 | 7.13 | -271.02 | 6 | 42.79 | May 1, 2025: 38 @ 7.13 |
| June 26, 2025 | issue | SO-250626-153 | MAIN | 12 | 7.13 | -85.59 | 44 | 313.82 | May 1, 2025: 12 @ 7.13 |
| June 22, 2025 | issue | SO-250622-876 | MAIN | 25 | 7.13 | -178.30 | 56 | 399.40 | May 1, 2025: 25 @ 7.13 |
| June 14, 2025 | issue | SO-250614-646 | MAIN | 19 | 7.13 | -135.51 | 81 | 577.71 | May 1, 2025: 19 @ 7.13 |
| June 4, 2025 | issue | SO-250604-819 | MAIN | 11 | 7.13 | -78.45 | 100 | 713.22 | May 1, 2025: 11 @ 7.13 |
| May 20, 2025 | issue | SO-250520-738 | MAIN | 5 | 7.13 | -35.66 | 111 | 791.67 | May 1, 2025: 5 @ 7.13 |
| May 14, 2025 | issue | SO-250514-312 | MAIN | 14 | 7.13 | -99.85 | 116 | 827.34 | May 1, 2025: 14 @ 7.13 |
| May 3, 2025 | issue | SO-250503-366 | MAIN | 30 | 7.13 | -213.97 | 130 | 927.19 | May 1, 2025: 30 @ 7.13 |
| May 1, 2025 | receipt | PO-000500 | MAIN | 160 | 7.13 | 1,141.15 | 160 | 1,141.15 | |
| April 24, 2025 | issue | SO-250424-526 | MAIN | 37 | 6.82 | -252.38 | 0 | 0.00 | Dec. 31, 2024: 33 @ 6.80; Jan. 5, 2025: 4 @ 7.03 |
| March 22, 2025 | issue | SO-250322-774 | MAIN | 1 | 6.80 | -6.80 | 37 | 252.38 | Dec. 31, 2024: 1 @ 6.80 |
| March 18, 2025 | issue | SO-250318-407 | MAIN | 16 | 6.80 | -108.73 | 38 | 259.17 | Dec. 31, 2024: 16 @ 6.80 |
| March 7, 2025 | issue | SO-250307-535 | MAIN | 2 | 6.80 | -13.59 | 54 | 367.90 | Dec. 31, 2024: 2 @ 6.80 |
| March 4, 2025 | issue | SO-250304-725 | MAIN | 5 | 6.80 | -33.98 | 56 | 381.50 | Dec. 31, 2024: 5 @ 6.80 |
| March 1, 2025 | issue | SO-250301-618 | MAIN | 16 | 6.80 | -108.73 | 61 | 415.47 | Dec. 31, 2024: 16 @ 6.80 |
| Feb. 23, 2025 | issue | SO-250223-897 | MAIN | 44 | 6.80 | -299.01 | 77 | 524.21 | Dec. 31, 2024: 44 @ 6.80 |
| Feb. 22, 2025 | issue | SO-250222-611 | MAIN | 9 | 6.80 | -61.16 | 121 | 823.22 | Dec. 31, 2024: 9 @ 6.80 |
| Feb. 2, 2025 | issue | SO-250202-357 | MAIN | 2 | 6.80 | -13.59 | 130 | 884.38 | Dec. 31, 2024: 2 @ 6.80 |
| Jan. 31, 2025 | issue | SO-250131-118 | MAIN | 28 | 6.80 | -190.28 | 132 | 897.97 | Dec. 31, 2024: 28 @ 6.80 |
| Jan. 23, 2025 | issue | SO-250123-459 | MAIN | 13 | 6.96 | -90.45 | 160 | 1,088.25 | Oct. 1, 2024: 9 @ 7.03; Dec. 31, 2024: 4 @ 6.80 |
| Jan. 5, 2025 | return | RMA | MAIN | 4 | 7.03 | 28.12 | 173 | 1,178.70 | |
| Dec. 31, 2024 | receipt | PO-000155 | MAIN | 160 | 6.80 | 1,087.31 | 169 | 1,150.58 | |
| Dec. 26, 2024 | issue | SO-241226-418 | MAIN | 1 | 7.03 | -7.03 | 9 | 63.27 | Oct. 1, 2024: 1 @ 7.03 |
| Dec. 24, 2024 | issue | SO-241224-398 | MAIN | 45 | 7.03 | -316.35 | 10 | 70.30 | Oct. 1, 2024: 45 @ 7.03 |
| Dec. 18, 2024 | issue | SO-241218-718 | MAIN | 8 | 7.03 | -56.24 | 55 | 386.65 | Oct. 1, 2024: 8 @ 7.03 |
| Dec. 9, 2024 | issue | SO-241209-741 | MAIN | 10 | 7.03 | -70.30 | 63 | 442.89 | Oct. 1, 2024: 10 @ 7.03 |
| Nov. 28, 2024 | issue | SO-241128-727 | MAIN | 7 | 7.03 | -49.21 | 73 | 513.19 | Oct. 1, 2024: 7 @ 7.03 |
| Nov. 15, 2024 | issue | SO-241115-873 | MAIN | 1 | 7.03 | -7.03 | 80 | 562.40 | Oct. 1, 2024: 1 @ 7.03 |
| Nov. 9, 2024 | issue | SO-241109-747 | MAIN | 8 | 7.03 | -56.24 | 81 | 569.43 | Oct. 1, 2024: 8 @ 7.03 |
| Nov. 4, 2024 | issue | SO-241104-350 | MAIN | 4 | 7.03 | -28.12 | 89 | 625.67 | Oct. 1, 2024: 4 @ 7.03 |
| Nov. 3, 2024 | issue | SO-241103-709 | MAIN | 24 | 7.03 | -168.72 | 93 | 653.79 | Oct. 1, 2024: 24 @ 7.03 |
| Nov. 1, 2024 | issue | SO-241101-977 | MAIN | 11 | 7.03 | -77.33 | 117 | 822.51 | Oct. 1, 2024: 11 @ 7.03 |
| Oct. 15, 2024 | issue | SO-241015-708 | MAIN | 27 | 7.03 | -189.81 | 128 | 899.84 | Oct. 1, 2024: 27 @ 7.03 |
| Oct. 9, 2024 | issue | SO-241009-654 | MAIN | 5 | 7.03 | -35.15 | 155 | 1,089.65 | Oct. 1, 2024: 5 @ 7.03 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 160 | 7.03 | 1,124.80 | 160 | 1,124.80 | |