Items / SWT-0003
USB Charger Socket Plus SWT-0003 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)119MAIN 119
Value (FIFO)954.59avg 8.02
ClassCX / FCV 0.20
Turnover4.4xlast issue 4 days ago
Days of cover83lead 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 | 43.42 / 30.4375 | 1.426 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.82 / 5.517 | 1.598 |
| 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 * 1.598^2 + 1.426^2 * 1.5^2) | 6.1 |
| Reorder point | d * LT + safety stock | 1.426 * 7.0 + 6.1 | 16.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 521/yr, S = 45.00, h = 20%, price = 7.88 | 172.4 |
| Inventory position | on hand + on order | 119 + 0 | 119 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.88 | 172 | 4,374 | yes (chosen if cheapest) |
MOQ 130, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 8, 2026 | 119 / 130 | 8.02 | 954.59 |
Movement ledger 118 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-831 | MAIN | 16 | 7.91 | -126.60 | 119 | 954.59 | June 26, 2026: 5 @ 7.67; Oct. 8, 2026: 11 @ 8.02 |
| Oct. 11, 2026 | issue | SO-261011-849 | MAIN | 6 | 7.67 | -46.03 | 135 | 1,081.20 | June 26, 2026: 6 @ 7.67 |
| Oct. 10, 2026 | issue | SO-261010-647 | MAIN | 1 | 7.67 | -7.67 | 141 | 1,127.23 | June 26, 2026: 1 @ 7.67 |
| Oct. 8, 2026 | receipt | PO-001861 | MAIN | 130 | 8.02 | 1,042.83 | 142 | 1,134.90 | |
| Oct. 5, 2026 | issue | SO-261005-561 | MAIN | 7 | 7.67 | -53.71 | 12 | 92.07 | June 26, 2026: 7 @ 7.67 |
| Oct. 1, 2026 | issue | SO-261001-384 | MAIN | 3 | 7.67 | -23.02 | 19 | 145.77 | June 26, 2026: 3 @ 7.67 |
| Oct. 1, 2026 | issue | SO-261001-384 | EAST | 4 | 7.67 | -30.69 | 22 | 168.79 | June 26, 2026: 4 @ 7.67 |
| Sept. 18, 2026 | issue | SO-260918-107 | MAIN | 31 | 7.67 | -237.84 | 26 | 199.48 | June 26, 2026: 31 @ 7.67 |
| Sept. 9, 2026 | issue | SO-260909-136 | MAIN | 8 | 7.67 | -61.38 | 57 | 437.32 | June 26, 2026: 8 @ 7.67 |
| Aug. 21, 2026 | issue | SO-260821-889 | MAIN | 9 | 7.67 | -69.05 | 65 | 498.69 | June 26, 2026: 9 @ 7.67 |
| Aug. 19, 2026 | issue | SO-260819-472 | EAST | 18 | 7.67 | -138.10 | 74 | 567.74 | June 26, 2026: 18 @ 7.67 |
| Aug. 11, 2026 | issue | SO-260811-482 | MAIN | 5 | 7.67 | -38.36 | 92 | 705.84 | June 26, 2026: 5 @ 7.67 |
| Aug. 4, 2026 | issue | SO-260804-700 | EAST | 5 | 7.67 | -38.36 | 97 | 744.20 | June 26, 2026: 5 @ 7.67 |
| Aug. 1, 2026 | issue | SO-260801-899 | MAIN | 1 | 7.67 | -7.67 | 102 | 782.56 | June 26, 2026: 1 @ 7.67 |
| July 30, 2026 | issue | SO-260730-556 | MAIN | 11 | 7.67 | -84.39 | 103 | 790.24 | June 26, 2026: 11 @ 7.67 |
| July 9, 2026 | issue | SO-260709-183 | MAIN | 29 | 7.63 | -221.27 | 114 | 874.63 | March 31, 2026: 13 @ 7.58; June 26, 2026: 16 @ 7.67 |
| June 29, 2026 | issue | SO-260629-196 | MAIN | 3 | 7.58 | -22.73 | 143 | 1,095.90 | March 31, 2026: 3 @ 7.58 |
| June 26, 2026 | transfer | TRF | MAIN → EAST | 27 | warehouse transfer, no cost effect | ||||
| June 26, 2026 | receipt | PO-001605 | MAIN | 130 | 7.67 | 997.39 | 146 | 1,118.63 | |
| June 19, 2026 | issue | SO-260619-411 | MAIN | 7 | 7.58 | -53.05 | 16 | 121.25 | March 31, 2026: 7 @ 7.58 |
| June 11, 2026 | issue | SO-260611-869 | MAIN | 6 | 7.58 | -45.47 | 23 | 174.29 | March 31, 2026: 6 @ 7.58 |
| June 6, 2026 | issue | SO-260606-935 | MAIN | 20 | 7.58 | -151.56 | 29 | 219.76 | March 31, 2026: 20 @ 7.58 |
| June 6, 2026 | issue | SO-260606-935 | EAST | 4 | 7.58 | -30.31 | 49 | 371.32 | March 31, 2026: 4 @ 7.58 |
| June 5, 2026 | issue | SO-260605-725 | EAST | 2 | 7.58 | -15.16 | 53 | 401.63 | March 31, 2026: 2 @ 7.58 |
| May 28, 2026 | issue | SO-260528-760 | EAST | 1 | 7.58 | -7.58 | 55 | 416.78 | March 31, 2026: 1 @ 7.58 |
| May 27, 2026 | issue | SO-260527-605 | EAST | 20 | 7.58 | -151.56 | 56 | 424.36 | March 31, 2026: 20 @ 7.58 |
| May 10, 2026 | issue | SO-260510-517 | MAIN | 7 | 7.58 | -53.05 | 76 | 575.92 | March 31, 2026: 7 @ 7.58 |
| May 1, 2026 | issue | SO-260501-350 | MAIN | 2 | 7.58 | -15.16 | 83 | 628.97 | March 31, 2026: 2 @ 7.58 |
| April 30, 2026 | issue | SO-260430-898 | MAIN | 37 | 7.58 | -280.38 | 85 | 644.12 | March 31, 2026: 37 @ 7.58 |
| April 20, 2026 | issue | SO-260420-127 | MAIN | 23 | 7.54 | -173.49 | 122 | 924.50 | Dec. 18, 2025: 15 @ 7.52; March 31, 2026: 8 @ 7.58 |
| March 31, 2026 | transfer | TRF | MAIN → EAST | 27 | warehouse transfer, no cost effect | ||||
| March 31, 2026 | receipt | PO-001373 | MAIN | 130 | 7.58 | 985.13 | 145 | 1,098.00 | |
| March 24, 2026 | issue | SO-260324-779 | MAIN | 9 | 7.52 | -67.72 | 15 | 112.87 | Dec. 18, 2025: 9 @ 7.52 |
| March 7, 2026 | issue | SO-260307-711 | MAIN | 23 | 7.52 | -173.07 | 24 | 180.59 | Dec. 18, 2025: 23 @ 7.52 |
| March 1, 2026 | issue | SO-260301-346 | MAIN | 21 | 7.52 | -158.02 | 47 | 353.66 | Dec. 18, 2025: 21 @ 7.52 |
| Feb. 23, 2026 | issue | SO-260223-253 | MAIN | 4 | 7.52 | -30.10 | 68 | 511.67 | Dec. 18, 2025: 4 @ 7.52 |
| Feb. 18, 2026 | issue | SO-260218-950 | MAIN | 27 | 7.52 | -203.16 | 72 | 541.77 | Dec. 18, 2025: 27 @ 7.52 |
| Feb. 14, 2026 | issue | SO-260214-437 | MAIN | 15 | 7.52 | -112.87 | 99 | 744.94 | Dec. 18, 2025: 15 @ 7.52 |
| Jan. 30, 2026 | issue | SO-260130-652 | MAIN | 7 | 7.52 | -52.67 | 114 | 857.80 | Dec. 18, 2025: 7 @ 7.52 |
| Jan. 28, 2026 | issue | SO-260128-115 | MAIN | 1 | 7.52 | -7.52 | 121 | 910.48 | Dec. 18, 2025: 1 @ 7.52 |
| Jan. 17, 2026 | issue | SO-260117-837 | MAIN | 9 | 7.51 | -67.59 | 122 | 918.00 | Oct. 12, 2025: 1 @ 7.39; Dec. 18, 2025: 8 @ 7.52 |
| Jan. 13, 2026 | issue | SO-260113-184 | MAIN | 4 | 7.39 | -29.57 | 131 | 985.59 | Oct. 12, 2025: 4 @ 7.39 |
| Jan. 12, 2026 | issue | SO-260112-590 | MAIN | 9 | 7.39 | -66.54 | 135 | 1,015.16 | Oct. 12, 2025: 9 @ 7.39 |
| Dec. 18, 2025 | issue | SO-251218-555 | MAIN | 1 | 7.39 | -7.39 | 144 | 1,081.70 | Oct. 12, 2025: 1 @ 7.39 |
| Dec. 18, 2025 | receipt | PO-001063 | MAIN | 130 | 7.52 | 978.20 | 145 | 1,089.09 | |
| Dec. 7, 2025 | issue | SO-251207-819 | MAIN | 29 | 7.39 | -214.39 | 15 | 110.89 | Oct. 12, 2025: 29 @ 7.39 |
| Dec. 2, 2025 | issue | SO-251202-152 | MAIN | 25 | 7.39 | -184.82 | 44 | 325.28 | Oct. 12, 2025: 25 @ 7.39 |
| Nov. 19, 2025 | issue | SO-251119-779 | MAIN | 8 | 7.39 | -59.14 | 69 | 510.10 | Oct. 12, 2025: 8 @ 7.39 |
| Nov. 8, 2025 | issue | SO-251108-460 | MAIN | 22 | 7.39 | -162.64 | 77 | 569.25 | Oct. 12, 2025: 22 @ 7.39 |
| Nov. 6, 2025 | issue | SO-251106-915 | MAIN | 6 | 7.39 | -44.36 | 99 | 731.89 | Oct. 12, 2025: 6 @ 7.39 |
| Nov. 1, 2025 | issue | SO-251101-940 | MAIN | 7 | 7.39 | -51.75 | 105 | 776.24 | Oct. 12, 2025: 7 @ 7.39 |
| Oct. 16, 2025 | issue | SO-251016-623 | MAIN | 2 | 7.39 | -14.79 | 112 | 827.99 | Oct. 12, 2025: 2 @ 7.39 |
| Oct. 14, 2025 | issue | SO-251014-215 | MAIN | 27 | 7.35 | -198.47 | 114 | 842.78 | July 12, 2025: 11 @ 7.29; Oct. 12, 2025: 16 @ 7.39 |
| Oct. 12, 2025 | receipt | PO-000914 | MAIN | 130 | 7.39 | 961.06 | 141 | 1,041.25 | |
| Oct. 11, 2025 | issue | SO-251011-952 | MAIN | 1 | 7.29 | -7.29 | 11 | 80.19 | July 12, 2025: 1 @ 7.29 |
| Oct. 8, 2025 | issue | SO-251008-761 | MAIN | 3 | 7.29 | -21.87 | 12 | 87.48 | July 12, 2025: 3 @ 7.29 |
| Oct. 6, 2025 | issue | SO-251006-670 | MAIN | 1 | 7.29 | -7.29 | 15 | 109.35 | July 12, 2025: 1 @ 7.29 |
| Oct. 3, 2025 | issue | SO-251003-253 | MAIN | 11 | 7.29 | -80.19 | 16 | 116.64 | July 12, 2025: 11 @ 7.29 |
| Sept. 30, 2025 | issue | SO-250930-870 | MAIN | 8 | 7.29 | -58.32 | 27 | 196.83 | July 12, 2025: 8 @ 7.29 |
| Sept. 28, 2025 | issue | SO-250928-741 | MAIN | 11 | 7.29 | -80.19 | 35 | 255.15 | July 12, 2025: 11 @ 7.29 |
| Sept. 27, 2025 | issue | SO-250927-868 | MAIN | 12 | 7.29 | -87.48 | 46 | 335.34 | July 12, 2025: 12 @ 7.29 |
| Sept. 26, 2025 | issue | SO-250926-982 | MAIN | 3 | 7.29 | -21.87 | 58 | 422.81 | July 12, 2025: 3 @ 7.29 |
| Sept. 16, 2025 | issue | SO-250916-605 | MAIN | 1 | 7.29 | -7.29 | 61 | 444.68 | July 12, 2025: 1 @ 7.29 |
| Sept. 14, 2025 | issue | SO-250914-937 | MAIN | 7 | 7.29 | -51.03 | 62 | 451.97 | July 12, 2025: 7 @ 7.29 |
| Sept. 5, 2025 | issue | SO-250905-106 | MAIN | 6 | 7.29 | -43.74 | 69 | 503.00 | July 12, 2025: 6 @ 7.29 |
| Aug. 26, 2025 | issue | SO-250826-343 | MAIN | 16 | 7.29 | -116.64 | 75 | 546.74 | July 12, 2025: 16 @ 7.29 |
| Aug. 18, 2025 | issue | SO-250818-287 | MAIN | 16 | 7.29 | -116.64 | 91 | 663.38 | July 12, 2025: 16 @ 7.29 |
| Aug. 16, 2025 | issue | SO-250816-832 | MAIN | 1 | 7.29 | -7.29 | 107 | 780.02 | July 12, 2025: 1 @ 7.29 |
| Aug. 15, 2025 | issue | SO-250815-882 | MAIN | 10 | 7.29 | -72.90 | 108 | 787.31 | July 12, 2025: 10 @ 7.29 |
| July 26, 2025 | issue | SO-250726-885 | MAIN | 11 | 7.29 | -80.19 | 118 | 860.21 | July 12, 2025: 11 @ 7.29 |
| July 19, 2025 | issue | SO-250719-347 | MAIN | 1 | 7.29 | -7.29 | 129 | 940.40 | July 12, 2025: 1 @ 7.29 |
| July 12, 2025 | receipt | PO-000702 | MAIN | 130 | 7.29 | 947.69 | 130 | 947.69 | |
| July 10, 2025 | issue | SO-250710-315 | EAST | 4 | 7.20 | -28.79 | 0 | 0.00 | April 21, 2025: 4 @ 7.20 |
| July 8, 2025 | issue | SO-250708-644 | EAST | 13 | 7.20 | -93.57 | 4 | 28.79 | April 21, 2025: 13 @ 7.20 |
| July 4, 2025 | issue | SO-250704-723 | EAST | 16 | 7.20 | -115.16 | 17 | 122.36 | April 21, 2025: 16 @ 7.20 |
| June 28, 2025 | issue | SO-250628-763 | EAST | 7 | 7.20 | -50.38 | 33 | 237.52 | April 21, 2025: 7 @ 7.20 |
| June 22, 2025 | issue | SO-250622-421 | EAST | 1 | 7.20 | -7.20 | 40 | 287.91 | April 21, 2025: 1 @ 7.20 |
| June 22, 2025 | issue | SO-250622-421 | MAIN | 14 | 7.20 | -100.77 | 41 | 295.11 | April 21, 2025: 14 @ 7.20 |
| June 13, 2025 | issue | SO-250613-548 | MAIN | 25 | 7.20 | -179.94 | 55 | 395.87 | April 21, 2025: 25 @ 7.20 |
| May 22, 2025 | issue | SO-250522-523 | MAIN | 5 | 7.20 | -35.99 | 80 | 575.82 | April 21, 2025: 5 @ 7.20 |
| May 20, 2025 | issue | SO-250520-911 | MAIN | 13 | 7.20 | -93.57 | 85 | 611.80 | April 21, 2025: 13 @ 7.20 |
| May 13, 2025 | issue | SO-250513-350 | MAIN | 17 | 7.20 | -122.36 | 98 | 705.37 | April 21, 2025: 17 @ 7.20 |
| April 29, 2025 | issue | SO-250429-654 | MAIN | 15 | 7.20 | -107.97 | 115 | 827.74 | April 21, 2025: 15 @ 7.20 |
| April 28, 2025 | issue | SO-250428-380 | EAST | 6 | 7.25 | -43.47 | 130 | 935.70 | Dec. 26, 2024: 6 @ 7.25 |
| April 27, 2025 | issue | SO-250427-109 | MAIN | 1 | 7.25 | -7.25 | 136 | 979.17 | Dec. 26, 2024: 1 @ 7.25 |
| April 21, 2025 | transfer | TRF | MAIN → EAST | 40 | warehouse transfer, no cost effect | ||||
| April 21, 2025 | receipt | PO-000467 | MAIN | 130 | 7.20 | 935.70 | 137 | 986.42 | |
| April 17, 2025 | issue | SO-250417-730 | EAST | 3 | 7.25 | -21.74 | 7 | 50.72 | Dec. 26, 2024: 3 @ 7.25 |
| April 17, 2025 | issue | SO-250417-730 | MAIN | 4 | 7.25 | -28.98 | 10 | 72.45 | Dec. 26, 2024: 4 @ 7.25 |
| April 16, 2025 | issue | SO-250416-316 | EAST | 1 | 7.25 | -7.25 | 14 | 101.43 | Dec. 26, 2024: 1 @ 7.25 |
| April 14, 2025 | issue | SO-250414-640 | EAST | 9 | 7.25 | -65.21 | 15 | 108.68 | Dec. 26, 2024: 9 @ 7.25 |
| April 10, 2025 | issue | SO-250410-369 | EAST | 1 | 7.25 | -7.25 | 24 | 173.89 | Dec. 26, 2024: 1 @ 7.25 |
| March 8, 2025 | issue | SO-250308-763 | MAIN | 6 | 7.25 | -43.47 | 25 | 181.13 | Dec. 26, 2024: 6 @ 7.25 |
| March 7, 2025 | issue | SO-250307-898 | MAIN | 31 | 7.25 | -224.60 | 31 | 224.60 | Dec. 26, 2024: 31 @ 7.25 |
| Feb. 28, 2025 | issue | SO-250228-716 | MAIN | 5 | 7.25 | -36.23 | 62 | 449.21 | Dec. 26, 2024: 5 @ 7.25 |
| Feb. 22, 2025 | issue | SO-250222-958 | MAIN | 1 | 7.25 | -7.25 | 67 | 485.44 | Dec. 26, 2024: 1 @ 7.25 |
| Feb. 20, 2025 | issue | SO-250220-534 | MAIN | 9 | 7.25 | -65.21 | 68 | 492.68 | Dec. 26, 2024: 9 @ 7.25 |
| Feb. 17, 2025 | issue | SO-250217-806 | EAST | 2 | 7.25 | -14.49 | 77 | 557.89 | Dec. 26, 2024: 2 @ 7.25 |
| Feb. 10, 2025 | issue | SO-250210-953 | EAST | 7 | 7.25 | -50.72 | 79 | 572.38 | Dec. 26, 2024: 7 @ 7.25 |
| Feb. 4, 2025 | issue | SO-250204-961 | MAIN | 10 | 7.25 | -72.45 | 86 | 623.10 | Dec. 26, 2024: 10 @ 7.25 |
| Feb. 1, 2025 | issue | SO-250201-154 | MAIN | 1 | 7.25 | -7.25 | 96 | 695.55 | Dec. 26, 2024: 1 @ 7.25 |
| Jan. 31, 2025 | issue | SO-250131-343 | MAIN | 1 | 7.25 | -7.25 | 97 | 702.79 | Dec. 26, 2024: 1 @ 7.25 |
| Jan. 28, 2025 | issue | SO-250128-942 | EAST | 6 | 7.25 | -43.47 | 98 | 710.04 | Dec. 26, 2024: 6 @ 7.25 |
| Jan. 14, 2025 | issue | SO-250114-722 | EAST | 1 | 7.25 | -7.25 | 104 | 753.51 | Dec. 26, 2024: 1 @ 7.25 |
| Jan. 13, 2025 | issue | SO-250113-713 | MAIN | 15 | 7.25 | -108.68 | 105 | 760.76 | Dec. 26, 2024: 15 @ 7.25 |
| Jan. 6, 2025 | issue | SO-250106-755 | MAIN | 10 | 7.25 | -72.45 | 120 | 869.44 | Dec. 26, 2024: 10 @ 7.25 |
| Dec. 26, 2024 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| Dec. 26, 2024 | receipt | PO-000138 | MAIN | 130 | 7.25 | 941.89 | 130 | 941.89 | |
| Dec. 19, 2024 | issue | SO-241219-753 | MAIN | 8 | 7.49 | -59.89 | 0 | 0.00 | Oct. 1, 2024: 8 @ 7.49 |
| Dec. 18, 2024 | issue | SO-241218-231 | MAIN | 23 | 7.49 | -172.18 | 8 | 59.89 | Oct. 1, 2024: 23 @ 7.49 |
| Dec. 7, 2024 | issue | SO-241207-691 | MAIN | 11 | 7.49 | -82.35 | 31 | 232.07 | Oct. 1, 2024: 11 @ 7.49 |
| Nov. 25, 2024 | issue | SO-241125-943 | MAIN | 6 | 7.49 | -44.92 | 42 | 314.41 | Oct. 1, 2024: 6 @ 7.49 |
| Nov. 4, 2024 | issue | SO-241104-327 | MAIN | 27 | 7.49 | -202.12 | 48 | 359.33 | Oct. 1, 2024: 27 @ 7.49 |
| Nov. 1, 2024 | issue | SO-241101-924 | MAIN | 10 | 7.49 | -74.86 | 75 | 561.45 | Oct. 1, 2024: 10 @ 7.49 |
| Oct. 29, 2024 | issue | SO-241029-405 | MAIN | 23 | 7.49 | -172.18 | 85 | 636.31 | Oct. 1, 2024: 23 @ 7.49 |
| Oct. 25, 2024 | issue | SO-241025-258 | MAIN | 3 | 7.49 | -22.46 | 108 | 808.49 | Oct. 1, 2024: 3 @ 7.49 |
| Oct. 24, 2024 | issue | SO-241024-296 | MAIN | 19 | 7.49 | -142.23 | 111 | 830.95 | Oct. 1, 2024: 19 @ 7.49 |
| Oct. 1, 2024 | receipt | PO-000005 | MAIN | 130 | 7.49 | 973.18 | 130 | 973.18 | |