Items / SWT-0040
USB Charger Socket Lite SWT-0040 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)182MAIN 117, EAST 65
Value (FIFO)2,056.20avg 11.30
ClassBX / FCV 0.25
Turnover6.3xlast issue 2 days ago
Days of cover32lead 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 | 170.92 / 30.4375 | 5.615 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 42.30 / 5.517 | 7.667 |
| 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 * 7.667^2 + 5.615^2 * 1.5^2) | 36.2 |
| Reorder point | d * LT + safety stock | 5.615 * 7.0 + 36.2 | 75.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 75.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2050/yr, S = 45.00, h = 20%, price = 11.33 | 285.3 |
| Inventory position | on hand + on order | 182 + 0 | 182 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.33 | 285 | 23,868 | yes (chosen if cheapest) |
MOQ 620, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 8, 2026 | 169 / 620 | 11.30 | 1,909.33 | |
| Sept. 1, 2026 | 13 / 13 | 11.30 | 146.87 |
Movement ledger 133 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-356 | MAIN | 45 | 11.30 | -508.40 | 182 | 2,056.20 | Aug. 8, 2026: 45 @ 11.30 |
| Oct. 2, 2026 | issue | SO-261002-244 | EAST | 174 | 11.30 | -1,965.82 | 227 | 2,564.60 | Aug. 8, 2026: 174 @ 11.30 |
| Sept. 28, 2026 | issue | SO-260928-154 | MAIN | 11 | 11.30 | -124.28 | 401 | 4,530.42 | Aug. 8, 2026: 11 @ 11.30 |
| Sept. 19, 2026 | issue | SO-260919-811 | MAIN | 4 | 11.30 | -45.19 | 412 | 4,654.69 | Aug. 8, 2026: 4 @ 11.30 |
| Sept. 18, 2026 | issue | SO-260918-429 | MAIN | 8 | 11.30 | -90.38 | 416 | 4,699.88 | Aug. 8, 2026: 8 @ 11.30 |
| Sept. 16, 2026 | issue | SO-260916-222 | MAIN | 22 | 11.30 | -248.55 | 424 | 4,790.27 | Aug. 8, 2026: 22 @ 11.30 |
| Sept. 15, 2026 | issue | SO-260915-468 | MAIN | 109 | 11.30 | -1,231.46 | 446 | 5,038.82 | Aug. 8, 2026: 109 @ 11.30 |
| Sept. 1, 2026 | return | RMA | MAIN | 13 | 11.30 | 146.87 | 555 | 6,270.28 | |
| Sept. 1, 2026 | issue | SO-260901-800 | MAIN | 72 | 11.30 | -813.44 | 542 | 6,123.41 | Aug. 8, 2026: 72 @ 11.30 |
| Aug. 29, 2026 | issue | SO-260829-865 | MAIN | 54 | 11.36 | -613.34 | 614 | 6,936.85 | May 7, 2026: 48 @ 11.37; Aug. 8, 2026: 6 @ 11.30 |
| Aug. 27, 2026 | issue | SO-260827-422 | EAST | 12 | 11.37 | -136.39 | 668 | 7,550.18 | May 7, 2026: 12 @ 11.37 |
| Aug. 22, 2026 | issue | SO-260822-789 | MAIN | 27 | 11.37 | -306.87 | 680 | 7,686.57 | May 7, 2026: 27 @ 11.37 |
| Aug. 15, 2026 | issue | SO-260815-793 | MAIN | 9 | 11.37 | -102.29 | 707 | 7,993.44 | May 7, 2026: 9 @ 11.37 |
| Aug. 8, 2026 | transfer | TRF | MAIN → EAST | 155 | warehouse transfer, no cost effect | ||||
| Aug. 8, 2026 | receipt | PO-001705 | MAIN | 620 | 11.30 | 7,004.64 | 716 | 8,095.73 | |
| Aug. 2, 2026 | issue | SO-260802-115 | EAST | 66 | 11.37 | -750.13 | 96 | 1,091.10 | May 7, 2026: 66 @ 11.37 |
| Aug. 2, 2026 | issue | SO-260802-115 | MAIN | 71 | 11.37 | -806.96 | 162 | 1,841.23 | May 7, 2026: 71 @ 11.37 |
| July 17, 2026 | issue | SO-260717-719 | MAIN | 25 | 11.37 | -284.14 | 233 | 2,648.18 | May 7, 2026: 25 @ 11.37 |
| July 4, 2026 | issue | SO-260704-240 | MAIN | 75 | 11.37 | -852.42 | 258 | 2,932.32 | May 7, 2026: 75 @ 11.37 |
| July 3, 2026 | issue | SO-260703-675 | MAIN | 24 | 11.37 | -272.77 | 333 | 3,784.74 | May 7, 2026: 24 @ 11.37 |
| July 1, 2026 | issue | SO-260701-383 | MAIN | 31 | 11.37 | -352.33 | 357 | 4,057.52 | May 7, 2026: 31 @ 11.37 |
| June 23, 2026 | issue | SO-260623-248 | MAIN | 52 | 11.37 | -591.01 | 388 | 4,409.85 | May 7, 2026: 52 @ 11.37 |
| June 13, 2026 | issue | SO-260613-907 | MAIN | 111 | 11.37 | -1,261.58 | 440 | 5,000.86 | May 7, 2026: 111 @ 11.37 |
| June 5, 2026 | issue | SO-260605-283 | EAST | 6 | 11.37 | -68.19 | 551 | 6,262.45 | May 7, 2026: 6 @ 11.37 |
| May 22, 2026 | issue | SO-260522-372 | MAIN | 48 | 11.37 | -545.55 | 557 | 6,330.64 | May 7, 2026: 48 @ 11.37 |
| May 10, 2026 | issue | SO-260510-587 | EAST | 5 | 11.37 | -56.83 | 605 | 6,876.19 | May 7, 2026: 5 @ 11.37 |
| May 9, 2026 | issue | SO-260509-326 | MAIN | 59 | 10.98 | -647.97 | 610 | 6,933.02 | March 17, 2026: 49 @ 10.90; May 7, 2026: 10 @ 11.37 |
| May 7, 2026 | transfer | TRF | MAIN → EAST | 173 | warehouse transfer, no cost effect | ||||
| May 7, 2026 | receipt | PO-001474 | MAIN | 620 | 11.37 | 7,046.67 | 669 | 7,580.99 | |
| May 3, 2026 | issue | SO-260503-428 | MAIN | 5 | 10.90 | -54.52 | 49 | 534.32 | Jan. 8, 2026: 3 @ 10.90; March 17, 2026: 2 @ 10.90 |
| May 2, 2026 | issue | SO-260502-654 | MAIN | 30 | 10.90 | -327.13 | 54 | 588.84 | Jan. 8, 2026: 30 @ 10.90 |
| April 29, 2026 | issue | SO-260429-149 | MAIN | 23 | 10.90 | -250.80 | 84 | 915.97 | Jan. 8, 2026: 23 @ 10.90 |
| April 21, 2026 | issue | SO-260421-663 | MAIN | 1 | 10.90 | -10.90 | 107 | 1,166.77 | Jan. 8, 2026: 1 @ 10.90 |
| April 15, 2026 | issue | SO-260415-821 | MAIN | 10 | 10.90 | -109.04 | 108 | 1,177.68 | Jan. 8, 2026: 10 @ 10.90 |
| April 12, 2026 | issue | SO-260412-794 | MAIN | 38 | 10.90 | -414.37 | 118 | 1,286.72 | Jan. 8, 2026: 38 @ 10.90 |
| April 11, 2026 | issue | SO-260411-708 | MAIN | 61 | 10.90 | -665.17 | 156 | 1,701.09 | Jan. 8, 2026: 61 @ 10.90 |
| April 9, 2026 | issue | SO-260409-603 | MAIN | 13 | 10.90 | -141.76 | 217 | 2,366.25 | Jan. 8, 2026: 13 @ 10.90 |
| March 17, 2026 | return | RMA | MAIN | 51 | 10.90 | 556.12 | 230 | 2,508.01 | |
| March 7, 2026 | issue | SO-260307-293 | MAIN | 103 | 10.90 | -1,123.15 | 179 | 1,951.89 | Jan. 8, 2026: 103 @ 10.90 |
| March 2, 2026 | issue | SO-260302-406 | MAIN | 32 | 10.90 | -348.94 | 282 | 3,075.04 | Jan. 8, 2026: 32 @ 10.90 |
| Feb. 21, 2026 | issue | SO-260221-235 | MAIN | 27 | 10.90 | -294.42 | 314 | 3,423.98 | Jan. 8, 2026: 27 @ 10.90 |
| Feb. 14, 2026 | issue | SO-260214-331 | MAIN | 32 | 10.90 | -348.94 | 341 | 3,718.40 | Jan. 8, 2026: 32 @ 10.90 |
| Feb. 6, 2026 | issue | SO-260206-798 | MAIN | 32 | 10.90 | -348.94 | 373 | 4,067.34 | Jan. 8, 2026: 32 @ 10.90 |
| Feb. 3, 2026 | issue | SO-260203-409 | MAIN | 37 | 10.90 | -403.46 | 405 | 4,416.28 | Jan. 8, 2026: 37 @ 10.90 |
| Feb. 2, 2026 | issue | SO-260202-291 | MAIN | 49 | 10.90 | -534.32 | 442 | 4,819.74 | Jan. 8, 2026: 49 @ 10.90 |
| Jan. 26, 2026 | issue | SO-260126-334 | MAIN | 107 | 10.90 | -1,166.77 | 491 | 5,354.06 | Jan. 8, 2026: 107 @ 10.90 |
| Jan. 24, 2026 | issue | SO-260124-198 | MAIN | 1 | 10.90 | -10.90 | 598 | 6,520.83 | Jan. 8, 2026: 1 @ 10.90 |
| Jan. 20, 2026 | issue | SO-260120-455 | MAIN | 6 | 10.90 | -65.43 | 599 | 6,531.74 | Jan. 8, 2026: 6 @ 10.90 |
| Jan. 17, 2026 | issue | SO-260117-399 | MAIN | 22 | 10.88 | -239.38 | 605 | 6,597.16 | Aug. 29, 2025: 7 @ 10.83; Jan. 8, 2026: 15 @ 10.90 |
| Jan. 16, 2026 | issue | SO-260116-821 | MAIN | 18 | 10.83 | -194.95 | 627 | 6,836.54 | Aug. 29, 2025: 18 @ 10.83 |
| Jan. 8, 2026 | receipt | PO-001128 | MAIN | 620 | 10.90 | 6,760.73 | 645 | 7,031.49 | |
| Jan. 2, 2026 | issue | SO-260102-917 | MAIN | 25 | 10.83 | -270.76 | 25 | 270.76 | Aug. 29, 2025: 25 @ 10.83 |
| Dec. 31, 2025 | issue | SO-251231-643 | MAIN | 82 | 10.83 | -888.11 | 50 | 541.53 | Aug. 29, 2025: 82 @ 10.83 |
| Dec. 15, 2025 | issue | SO-251215-928 | MAIN | 85 | 10.83 | -920.60 | 132 | 1,429.64 | Aug. 29, 2025: 85 @ 10.83 |
| Dec. 6, 2025 | issue | SO-251206-883 | MAIN | 59 | 10.83 | -639.01 | 217 | 2,350.24 | Aug. 29, 2025: 59 @ 10.83 |
| Nov. 29, 2025 | issue | SO-251129-706 | MAIN | 6 | 10.83 | -64.98 | 276 | 2,989.25 | Aug. 29, 2025: 6 @ 10.83 |
| Nov. 27, 2025 | issue | SO-251127-489 | MAIN | 18 | 10.83 | -194.95 | 282 | 3,054.23 | Aug. 29, 2025: 18 @ 10.83 |
| Nov. 26, 2025 | issue | SO-251126-687 | MAIN | 41 | 10.83 | -444.05 | 300 | 3,249.18 | Aug. 29, 2025: 41 @ 10.83 |
| Nov. 15, 2025 | issue | SO-251115-762 | MAIN | 11 | 10.83 | -119.14 | 341 | 3,693.23 | Aug. 29, 2025: 11 @ 10.83 |
| Nov. 7, 2025 | issue | SO-251107-775 | MAIN | 31 | 10.83 | -335.75 | 352 | 3,812.37 | Aug. 29, 2025: 31 @ 10.83 |