Items / SWT-0006
USB Charger Socket Prime SWT-0006 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)192MAIN 192
Value (FIFO)1,124.93avg 5.86
ClassBX / FCV 0.31
Turnover14.0xlast issue 0 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 | 185.50 / 30.4375 | 6.094 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 57.56 / 5.517 | 10.434 |
| 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 * 10.434^2 + 6.094^2 * 1.5^2) | 47.9 |
| Reorder point | d * LT + safety stock | 6.094 * 7.0 + 47.9 | 90.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 90.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 2224/yr, S = 45.00, h = 20%, price = 5.58 | 1200.0 |
| Inventory position | on hand + on order | 192 + 0 | 192 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 5.81 | 415 | 13,407 | yes |
| 1,200 | 5.58 | 1,200 | 13,160 | yes (chosen if cheapest) |
| 2,400 | 5.35 | 2,400 | 13,215 | yes |
MOQ 600, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 9, 2026 | 192 / 600 | 5.86 | 1,124.93 |
Movement ledger 116 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-248 | MAIN | 41 | 5.86 | -240.22 | 192 | 1,124.93 | Aug. 9, 2026: 41 @ 5.86 |
| Oct. 13, 2026 | issue | SO-261013-223 | MAIN | 22 | 5.86 | -128.90 | 233 | 1,365.15 | Aug. 9, 2026: 22 @ 5.86 |
| Oct. 11, 2026 | issue | SO-261011-411 | MAIN | 1 | 5.86 | -5.86 | 255 | 1,494.04 | Aug. 9, 2026: 1 @ 5.86 |
| Oct. 6, 2026 | issue | SO-261006-849 | MAIN | 54 | 5.86 | -316.39 | 256 | 1,499.90 | Aug. 9, 2026: 54 @ 5.86 |
| Oct. 2, 2026 | issue | SO-261002-852 | MAIN | 41 | 5.86 | -240.22 | 310 | 1,816.29 | Aug. 9, 2026: 41 @ 5.86 |
| Sept. 17, 2026 | issue | SO-260917-936 | MAIN | 152 | 5.86 | -890.57 | 351 | 2,056.51 | Aug. 9, 2026: 152 @ 5.86 |
| Sept. 14, 2026 | issue | SO-260914-702 | MAIN | 59 | 5.86 | -345.68 | 503 | 2,947.08 | Aug. 9, 2026: 59 @ 5.86 |
| Aug. 23, 2026 | issue | SO-260823-807 | MAIN | 12 | 5.86 | -70.31 | 562 | 3,292.76 | Aug. 9, 2026: 12 @ 5.86 |
| Aug. 16, 2026 | issue | SO-260816-655 | MAIN | 2 | 5.86 | -11.72 | 574 | 3,363.07 | Aug. 9, 2026: 2 @ 5.86 |
| Aug. 14, 2026 | issue | SO-260814-315 | MAIN | 13 | 5.86 | -76.17 | 576 | 3,374.78 | Aug. 9, 2026: 13 @ 5.86 |
| Aug. 12, 2026 | issue | SO-260812-374 | MAIN | 19 | 5.82 | -110.58 | 589 | 3,450.95 | Aug. 2, 2026: 8 @ 5.77; Aug. 9, 2026: 11 @ 5.86 |
| Aug. 9, 2026 | receipt | PO-001708 | MAIN | 600 | 5.86 | 3,515.40 | 608 | 3,561.53 | |
| Aug. 2, 2026 | return | RMA | MAIN | 8 | 5.77 | 46.13 | 8 | 46.13 | |
| July 31, 2026 | issue | SO-260731-336 | MAIN | 214 | 5.77 | -1,234.03 | 0 | 0.00 | April 15, 2026: 214 @ 5.77 |
| July 24, 2026 | issue | SO-260724-562 | MAIN | 13 | 5.77 | -74.96 | 214 | 1,234.03 | April 15, 2026: 13 @ 5.77 |
| July 24, 2026 | issue | SO-260724-562 | EAST | 17 | 5.77 | -98.03 | 227 | 1,309.00 | April 15, 2026: 17 @ 5.77 |
| June 30, 2026 | issue | SO-260630-647 | MAIN | 67 | 5.77 | -386.36 | 244 | 1,407.03 | April 15, 2026: 67 @ 5.77 |
| June 26, 2026 | issue | SO-260626-203 | EAST | 53 | 5.77 | -305.62 | 311 | 1,793.38 | April 15, 2026: 53 @ 5.77 |
| June 22, 2026 | issue | SO-260622-538 | MAIN | 101 | 5.77 | -582.42 | 364 | 2,099.01 | April 15, 2026: 101 @ 5.77 |
| May 29, 2026 | issue | SO-260529-292 | MAIN | 19 | 5.77 | -109.56 | 465 | 2,681.42 | April 15, 2026: 19 @ 5.77 |
| May 28, 2026 | issue | SO-260528-350 | MAIN | 25 | 5.77 | -144.16 | 484 | 2,790.99 | April 15, 2026: 25 @ 5.77 |
| May 18, 2026 | issue | SO-260518-777 | EAST | 60 | 5.77 | -345.99 | 509 | 2,935.15 | April 15, 2026: 60 @ 5.77 |
| May 13, 2026 | issue | SO-260513-265 | EAST | 13 | 5.77 | -74.96 | 569 | 3,281.14 | April 15, 2026: 13 @ 5.77 |
| May 7, 2026 | issue | SO-260507-585 | MAIN | 41 | 5.66 | -231.91 | 582 | 3,356.10 | Jan. 12, 2026: 23 @ 5.57; April 15, 2026: 18 @ 5.77 |
| April 23, 2026 | issue | SO-260423-175 | MAIN | 11 | 5.57 | -61.27 | 623 | 3,588.01 | Jan. 12, 2026: 11 @ 5.57 |
| April 15, 2026 | transfer | TRF | MAIN → EAST | 143 | warehouse transfer, no cost effect | ||||
| April 15, 2026 | receipt | PO-001411 | MAIN | 600 | 5.77 | 3,459.90 | 634 | 3,649.28 | |
| April 13, 2026 | adjustment | Cycle count | MAIN | -1 | 5.57 | -5.57 | 34 | 189.38 | Jan. 12, 2026: 1 @ 5.57 |
| April 12, 2026 | issue | SO-260412-206 | MAIN | 55 | 5.57 | -306.36 | 35 | 194.95 | Jan. 12, 2026: 55 @ 5.57 |
| April 10, 2026 | issue | SO-260410-990 | MAIN | 28 | 5.57 | -155.96 | 90 | 501.31 | Jan. 12, 2026: 28 @ 5.57 |
| April 10, 2026 | issue | SO-260410-990 | EAST | 14 | 5.57 | -77.98 | 118 | 657.27 | Jan. 12, 2026: 14 @ 5.57 |
| April 6, 2026 | issue | SO-260406-946 | MAIN | 30 | 5.57 | -167.10 | 132 | 735.25 | Jan. 12, 2026: 30 @ 5.57 |
| March 30, 2026 | issue | SO-260330-865 | MAIN | 29 | 5.57 | -161.53 | 162 | 902.36 | Jan. 12, 2026: 29 @ 5.57 |
| March 25, 2026 | issue | SO-260325-703 | EAST | 35 | 5.57 | -194.95 | 191 | 1,063.89 | Jan. 12, 2026: 35 @ 5.57 |
| March 20, 2026 | issue | SO-260320-868 | MAIN | 64 | 5.57 | -356.49 | 226 | 1,258.84 | Jan. 12, 2026: 64 @ 5.57 |
| March 19, 2026 | issue | SO-260319-619 | MAIN | 80 | 5.57 | -445.61 | 290 | 1,615.33 | Jan. 12, 2026: 80 @ 5.57 |
| March 11, 2026 | issue | SO-260311-453 | MAIN | 4 | 5.57 | -22.28 | 370 | 2,060.94 | Jan. 12, 2026: 4 @ 5.57 |
| Feb. 23, 2026 | issue | SO-260223-639 | MAIN | 1 | 5.57 | -5.57 | 374 | 2,083.22 | Jan. 12, 2026: 1 @ 5.57 |
| Feb. 21, 2026 | issue | SO-260221-507 | MAIN | 62 | 5.57 | -345.35 | 375 | 2,088.79 | Jan. 12, 2026: 62 @ 5.57 |
| Feb. 19, 2026 | issue | SO-260219-462 | MAIN | 44 | 5.57 | -245.08 | 437 | 2,434.13 | Jan. 12, 2026: 44 @ 5.57 |
| Feb. 18, 2026 | issue | SO-260218-816 | EAST | 75 | 5.57 | -417.76 | 481 | 2,679.22 | Jan. 12, 2026: 75 @ 5.57 |
| Feb. 13, 2026 | issue | SO-260213-372 | MAIN | 28 | 5.57 | -155.96 | 556 | 3,096.98 | Jan. 12, 2026: 28 @ 5.57 |
| Feb. 1, 2026 | issue | SO-260201-909 | MAIN | 16 | 5.57 | -89.12 | 584 | 3,252.94 | Jan. 12, 2026: 16 @ 5.57 |
| Jan. 12, 2026 | transfer | TRF | MAIN → EAST | 124 | warehouse transfer, no cost effect | ||||
| Jan. 12, 2026 | receipt | PO-001138 | MAIN | 600 | 5.57 | 3,342.06 | 600 | 3,342.06 | |
| Jan. 4, 2026 | issue | SO-260104-984 | MAIN | 130 | 5.66 | -735.28 | 0 | 0.00 | Oct. 28, 2025: 130 @ 5.66 |
| Jan. 3, 2026 | issue | SO-260103-655 | MAIN | 42 | 5.66 | -237.55 | 130 | 735.28 | Oct. 28, 2025: 42 @ 5.66 |
| Dec. 28, 2025 | issue | SO-251228-306 | MAIN | 21 | 5.66 | -118.78 | 172 | 972.83 | Oct. 28, 2025: 21 @ 5.66 |
| Dec. 26, 2025 | issue | SO-251226-289 | MAIN | 212 | 5.66 | -1,199.07 | 193 | 1,091.61 | Oct. 28, 2025: 212 @ 5.66 |
| Dec. 24, 2025 | issue | SO-251224-617 | MAIN | 13 | 5.66 | -73.53 | 405 | 2,290.68 | Oct. 28, 2025: 13 @ 5.66 |
| Dec. 9, 2025 | issue | SO-251209-470 | MAIN | 1 | 5.66 | -5.66 | 418 | 2,364.21 | Oct. 28, 2025: 1 @ 5.66 |
| Nov. 30, 2025 | issue | SO-251130-203 | MAIN | 8 | 5.66 | -45.25 | 419 | 2,369.86 | Oct. 28, 2025: 8 @ 5.66 |
| Nov. 24, 2025 | issue | SO-251124-991 | MAIN | 31 | 5.66 | -175.34 | 427 | 2,415.11 | Oct. 28, 2025: 31 @ 5.66 |
| Nov. 17, 2025 | issue | SO-251117-306 | MAIN | 51 | 5.66 | -288.46 | 458 | 2,590.45 | Oct. 28, 2025: 51 @ 5.66 |
| Nov. 5, 2025 | issue | SO-251105-615 | MAIN | 129 | 5.61 | -724.02 | 509 | 2,878.90 | Aug. 2, 2025: 38 @ 5.51; Oct. 28, 2025: 91 @ 5.66 |
| Nov. 4, 2025 | issue | SO-251104-873 | MAIN | 1 | 5.51 | -5.51 | 638 | 3,602.92 | Aug. 2, 2025: 1 @ 5.51 |
| Oct. 29, 2025 | issue | SO-251029-479 | MAIN | 7 | 5.51 | -38.56 | 639 | 3,608.43 | Aug. 2, 2025: 7 @ 5.51 |
| Oct. 28, 2025 | receipt | PO-000958 | MAIN | 600 | 5.66 | 3,393.60 | 646 | 3,646.99 | |
| Oct. 18, 2025 | issue | SO-251018-858 | MAIN | 98 | 5.51 | -539.82 | 46 | 253.39 | Aug. 2, 2025: 98 @ 5.51 |
| Oct. 16, 2025 | issue | SO-251016-393 | MAIN | 3 | 5.51 | -16.53 | 144 | 793.21 | Aug. 2, 2025: 3 @ 5.51 |