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