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