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
| 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 |
| Oct. 7, 2025 | issue | SO-251007-210 | MAIN | 31 | 5.51 | -170.76 | 147 | 809.73 | Aug. 2, 2025: 31 @ 5.51 |
| Sept. 27, 2025 | issue | SO-250927-102 | MAIN | 17 | 5.51 | -93.64 | 178 | 980.50 | Aug. 2, 2025: 17 @ 5.51 |
| Sept. 25, 2025 | issue | SO-250925-938 | MAIN | 4 | 5.51 | -22.03 | 195 | 1,074.14 | Aug. 2, 2025: 4 @ 5.51 |
| Sept. 15, 2025 | issue | SO-250915-901 | MAIN | 26 | 5.51 | -143.22 | 199 | 1,096.17 | Aug. 2, 2025: 26 @ 5.51 |
| Sept. 13, 2025 | issue | SO-250913-196 | MAIN | 56 | 5.51 | -308.47 | 225 | 1,239.39 | Aug. 2, 2025: 56 @ 5.51 |
| Sept. 8, 2025 | issue | SO-250908-169 | MAIN | 1 | 5.51 | -5.51 | 281 | 1,547.86 | Aug. 2, 2025: 1 @ 5.51 |
| Sept. 6, 2025 | issue | SO-250906-502 | MAIN | 40 | 5.51 | -220.34 | 282 | 1,553.37 | Aug. 2, 2025: 40 @ 5.51 |
| Aug. 27, 2025 | issue | SO-250827-883 | MAIN | 107 | 5.51 | -589.40 | 322 | 1,773.70 | Aug. 2, 2025: 107 @ 5.51 |
| Aug. 25, 2025 | issue | SO-250825-135 | MAIN | 39 | 5.51 | -214.83 | 429 | 2,363.10 | Aug. 2, 2025: 39 @ 5.51 |
| Aug. 19, 2025 | issue | SO-250819-535 | MAIN | 65 | 5.51 | -358.05 | 468 | 2,577.93 | Aug. 2, 2025: 65 @ 5.51 |
| Aug. 18, 2025 | issue | SO-250818-569 | MAIN | 1 | 5.51 | -5.51 | 533 | 2,935.98 | Aug. 2, 2025: 1 @ 5.51 |
| Aug. 17, 2025 | issue | SO-250817-532 | MAIN | 139 | 5.54 | -769.89 | 534 | 2,941.49 | May 1, 2025: 73 @ 5.57; Aug. 2, 2025: 66 @ 5.51 |
| Aug. 13, 2025 | issue | SO-250813-169 | MAIN | 6 | 5.57 | -33.40 | 673 | 3,711.38 | May 1, 2025: 6 @ 5.57 |
| Aug. 2, 2025 | receipt | PO-000752 | MAIN | 600 | 5.51 | 3,305.04 | 679 | 3,744.78 | |
| July 22, 2025 | issue | SO-250722-954 | MAIN | 64 | 5.57 | -356.24 | 79 | 439.74 | May 1, 2025: 64 @ 5.57 |
| July 19, 2025 | issue | SO-250719-537 | MAIN | 25 | 5.57 | -139.16 | 143 | 795.98 | May 1, 2025: 25 @ 5.57 |
| July 19, 2025 | issue | SO-250719-537 | EAST | 53 | 5.57 | -295.01 | 168 | 935.14 | May 1, 2025: 53 @ 5.57 |
| July 7, 2025 | issue | SO-250707-931 | EAST | 22 | 5.57 | -122.46 | 221 | 1,230.15 | May 1, 2025: 22 @ 5.57 |
| July 5, 2025 | issue | SO-250705-547 | MAIN | 42 | 5.57 | -233.78 | 243 | 1,352.61 | May 1, 2025: 42 @ 5.57 |
| June 23, 2025 | issue | SO-250623-361 | MAIN | 16 | 5.57 | -89.06 | 285 | 1,586.40 | May 1, 2025: 16 @ 5.57 |
| June 6, 2025 | issue | SO-250606-692 | MAIN | 177 | 5.57 | -985.24 | 301 | 1,675.46 | May 1, 2025: 177 @ 5.57 |
| May 27, 2025 | issue | SO-250527-130 | MAIN | 24 | 5.57 | -133.59 | 478 | 2,660.69 | May 1, 2025: 24 @ 5.57 |
| May 20, 2025 | issue | SO-250520-489 | EAST | 4 | 5.57 | -22.27 | 502 | 2,794.28 | May 1, 2025: 4 @ 5.57 |
| May 17, 2025 | issue | SO-250517-337 | EAST | 15 | 5.57 | -83.49 | 506 | 2,816.55 | May 1, 2025: 15 @ 5.57 |
| May 7, 2025 | issue | SO-250507-668 | MAIN | 128 | 5.50 | -703.52 | 521 | 2,900.04 | March 5, 2025: 49 @ 5.38; May 1, 2025: 79 @ 5.57 |
| May 4, 2025 | issue | SO-250504-134 | MAIN | 8 | 5.38 | -43.07 | 649 | 3,603.57 | March 5, 2025: 8 @ 5.38 |
| May 2, 2025 | issue | SO-250502-547 | EAST | 32 | 5.38 | -172.27 | 657 | 3,646.63 | March 5, 2025: 32 @ 5.38 |
| May 1, 2025 | transfer | TRF | MAIN → EAST | 126 | warehouse transfer, no cost effect | ||||
| May 1, 2025 | receipt | PO-000501 | MAIN | 600 | 5.57 | 3,339.78 | 689 | 3,818.90 | |
| April 25, 2025 | issue | SO-250425-307 | MAIN | 334 | 5.38 | -1,798.06 | 89 | 479.12 | March 5, 2025: 334 @ 5.38 |
| March 29, 2025 | issue | SO-250329-673 | MAIN | 21 | 5.38 | -113.05 | 423 | 2,277.18 | March 5, 2025: 21 @ 5.38 |
| March 29, 2025 | issue | SO-250329-673 | EAST | 169 | 5.38 | -908.67 | 444 | 2,390.23 | Dec. 5, 2024: 13 @ 5.30; March 5, 2025: 156 @ 5.38 |
| March 5, 2025 | issue | SO-250305-796 | EAST | 1 | 5.30 | -5.30 | 613 | 3,298.90 | Dec. 5, 2024: 1 @ 5.30 |
| March 5, 2025 | transfer | TRF | MAIN → EAST | 170 | warehouse transfer, no cost effect | ||||
| March 5, 2025 | receipt | PO-000317 | MAIN | 600 | 5.38 | 3,230.04 | 614 | 3,304.19 | |
| Feb. 23, 2025 | issue | SO-250223-718 | MAIN | 80 | 5.30 | -423.73 | 14 | 74.15 | Dec. 5, 2024: 80 @ 5.30 |
| Feb. 17, 2025 | issue | SO-250217-576 | MAIN | 45 | 5.30 | -238.35 | 94 | 497.88 | Dec. 5, 2024: 45 @ 5.30 |
| Feb. 12, 2025 | issue | SO-250212-327 | MAIN | 40 | 5.30 | -211.86 | 139 | 736.23 | Dec. 5, 2024: 40 @ 5.30 |
| Feb. 6, 2025 | issue | SO-250206-839 | MAIN | 19 | 5.30 | -100.64 | 179 | 948.09 | Dec. 5, 2024: 19 @ 5.30 |
| Jan. 3, 2025 | issue | SO-250103-138 | MAIN | 129 | 5.30 | -683.26 | 198 | 1,048.73 | Dec. 5, 2024: 129 @ 5.30 |
| Jan. 1, 2025 | issue | SO-250101-378 | MAIN | 118 | 5.30 | -625.00 | 327 | 1,731.99 | Dec. 5, 2024: 118 @ 5.30 |
| Dec. 20, 2024 | issue | SO-241220-848 | MAIN | 112 | 5.30 | -593.22 | 445 | 2,356.99 | Dec. 5, 2024: 112 @ 5.30 |
| Dec. 19, 2024 | issue | SO-241219-271 | MAIN | 7 | 5.30 | -37.08 | 557 | 2,950.21 | Dec. 5, 2024: 7 @ 5.30 |
| Dec. 8, 2024 | issue | SO-241208-848 | MAIN | 100 | 5.44 | -543.93 | 564 | 2,987.28 | Oct. 1, 2024: 64 @ 5.52; Dec. 5, 2024: 36 @ 5.30 |
| Dec. 5, 2024 | receipt | PO-000081 | MAIN | 600 | 5.30 | 3,177.96 | 664 | 3,531.21 | |
| Dec. 4, 2024 | issue | SO-241204-455 | MAIN | 13 | 5.52 | -71.75 | 64 | 353.25 | Oct. 1, 2024: 13 @ 5.52 |
| Nov. 29, 2024 | issue | SO-241129-586 | MAIN | 192 | 5.52 | -1,059.74 | 77 | 425.00 | Oct. 1, 2024: 192 @ 5.52 |
| Nov. 16, 2024 | issue | SO-241116-980 | MAIN | 1 | 5.52 | -5.52 | 269 | 1,484.75 | Oct. 1, 2024: 1 @ 5.52 |
| Nov. 4, 2024 | issue | SO-241104-485 | MAIN | 94 | 5.52 | -518.83 | 270 | 1,490.26 | Oct. 1, 2024: 94 @ 5.52 |
| Oct. 26, 2024 | issue | SO-241026-906 | MAIN | 5 | 5.52 | -27.60 | 364 | 2,009.10 | Oct. 1, 2024: 5 @ 5.52 |
| Oct. 26, 2024 | issue | SO-241026-906 | EAST | 79 | 5.52 | -436.04 | 369 | 2,036.70 | Oct. 1, 2024: 79 @ 5.52 |
| Oct. 21, 2024 | issue | SO-241021-769 | EAST | 63 | 5.52 | -347.73 | 448 | 2,472.74 | Oct. 1, 2024: 63 @ 5.52 |
| Oct. 6, 2024 | issue | SO-241006-384 | MAIN | 22 | 5.52 | -121.43 | 511 | 2,820.46 | Oct. 1, 2024: 22 @ 5.52 |
| Oct. 3, 2024 | issue | SO-241003-191 | MAIN | 67 | 5.52 | -369.81 | 533 | 2,941.89 | Oct. 1, 2024: 67 @ 5.52 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 142 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 600 | 5.52 | 3,311.70 | 600 | 3,311.70 | |