Items / SWT-0031
USB Charger Socket Nova SWT-0031 · Switches & Sockets · Volta Electricals Pvt Ltd
On hand (EA)175MAIN 175
Value (FIFO)4,650.96avg 26.58
ClassBX / FCV 0.27
Turnover5.2xlast issue 0 days ago
Days of cover65lead 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 | 82.25 / 30.4375 | 2.702 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 21.98 / 5.517 | 3.984 |
| 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 * 3.984^2 + 2.702^2 * 1.5^2) | 18.6 |
| Reorder point | d * LT + safety stock | 2.702 * 7.0 + 18.6 | 37.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 37.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 986/yr, S = 45.00, h = 20%, price = 26.89 | 128.5 |
| Inventory position | on hand + on order | 175 + 0 | 175 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 26.89 | 128 | 27,213 | yes (chosen if cheapest) |
MOQ 240, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 13, 2026 | 175 / 240 | 26.58 | 4,650.96 |
Movement ledger 125 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-527 | MAIN | 33 | 26.58 | -877.04 | 175 | 4,650.96 | Sept. 13, 2026: 33 @ 26.58 |
| Oct. 8, 2026 | issue | SO-261008-273 | MAIN | 35 | 26.65 | -932.63 | 208 | 5,528.00 | July 22, 2026: 3 @ 27.39; Sept. 13, 2026: 32 @ 26.58 |
| Sept. 13, 2026 | issue | SO-260913-422 | MAIN | 3 | 27.39 | -82.17 | 243 | 6,460.63 | July 22, 2026: 3 @ 27.39 |
| Sept. 13, 2026 | receipt | PO-001798 | MAIN | 240 | 26.58 | 6,378.46 | 246 | 6,542.80 | |
| Sept. 7, 2026 | issue | SO-260907-762 | MAIN | 18 | 27.39 | -493.02 | 6 | 164.34 | July 22, 2026: 18 @ 27.39 |
| Sept. 7, 2026 | issue | SO-260907-762 | EAST | 65 | 27.39 | -1,780.36 | 24 | 657.36 | July 22, 2026: 65 @ 27.39 |
| Aug. 30, 2026 | issue | SO-260830-327 | MAIN | 4 | 27.39 | -109.56 | 89 | 2,437.72 | July 22, 2026: 4 @ 27.39 |
| Aug. 27, 2026 | issue | SO-260827-369 | MAIN | 16 | 27.39 | -438.24 | 93 | 2,547.28 | July 22, 2026: 16 @ 27.39 |
| Aug. 23, 2026 | issue | SO-260823-856 | MAIN | 19 | 27.39 | -520.41 | 109 | 2,985.52 | July 22, 2026: 19 @ 27.39 |
| Aug. 21, 2026 | issue | SO-260821-420 | EAST | 29 | 27.39 | -794.31 | 128 | 3,505.93 | July 22, 2026: 29 @ 27.39 |
| Aug. 20, 2026 | issue | SO-260820-278 | MAIN | 12 | 27.39 | -328.68 | 157 | 4,300.25 | July 22, 2026: 12 @ 27.39 |
| Aug. 12, 2026 | issue | SO-260812-365 | MAIN | 11 | 27.39 | -301.29 | 169 | 4,628.93 | July 22, 2026: 11 @ 27.39 |
| Aug. 8, 2026 | issue | SO-260808-990 | MAIN | 3 | 27.39 | -82.17 | 180 | 4,930.22 | July 22, 2026: 3 @ 27.39 |
| July 22, 2026 | issue | SO-260722-144 | MAIN | 79 | 26.87 | -2,122.62 | 183 | 5,012.39 | March 18, 2026: 22 @ 25.52; July 22, 2026: 57 @ 27.39 |
| July 22, 2026 | transfer | TRF | MAIN → EAST | 72 | warehouse transfer, no cost effect | ||||
| July 22, 2026 | receipt | PO-001662 | MAIN | 240 | 27.39 | 6,573.62 | 262 | 7,135.00 | |
| July 18, 2026 | issue | SO-260718-709 | EAST | 11 | 25.52 | -280.69 | 22 | 561.38 | March 18, 2026: 11 @ 25.52 |
| July 18, 2026 | issue | SO-260718-709 | MAIN | 3 | 25.52 | -76.55 | 33 | 842.07 | March 18, 2026: 3 @ 25.52 |
| July 16, 2026 | issue | SO-260716-902 | MAIN | 1 | 25.52 | -25.52 | 36 | 918.62 | March 18, 2026: 1 @ 25.52 |
| July 15, 2026 | issue | SO-260715-156 | MAIN | 4 | 25.52 | -102.07 | 37 | 944.14 | March 18, 2026: 4 @ 25.52 |
| July 2, 2026 | issue | SO-260702-594 | MAIN | 25 | 25.52 | -637.93 | 41 | 1,046.21 | March 18, 2026: 25 @ 25.52 |
| June 18, 2026 | issue | SO-260618-908 | EAST | 38 | 25.52 | -969.66 | 66 | 1,684.14 | March 18, 2026: 38 @ 25.52 |
| June 9, 2026 | issue | SO-260609-259 | EAST | 7 | 25.52 | -178.62 | 104 | 2,653.80 | March 18, 2026: 7 @ 25.52 |
| June 6, 2026 | issue | SO-260606-502 | MAIN | 5 | 25.52 | -127.59 | 111 | 2,832.42 | March 18, 2026: 5 @ 25.52 |
| June 3, 2026 | issue | SO-260603-993 | MAIN | 4 | 25.52 | -102.07 | 116 | 2,960.01 | March 18, 2026: 4 @ 25.52 |
| May 22, 2026 | issue | SO-260522-411 | MAIN | 40 | 25.52 | -1,020.69 | 120 | 3,062.08 | March 18, 2026: 40 @ 25.52 |
| May 12, 2026 | issue | SO-260512-444 | MAIN | 30 | 25.52 | -765.52 | 160 | 4,082.77 | March 18, 2026: 30 @ 25.52 |
| May 9, 2026 | issue | SO-260509-793 | MAIN | 5 | 25.52 | -127.59 | 190 | 4,848.29 | March 18, 2026: 5 @ 25.52 |
| April 30, 2026 | adjustment | Cycle count | MAIN | -2 | 25.52 | -51.03 | 195 | 4,975.87 | March 18, 2026: 2 @ 25.52 |
| April 27, 2026 | issue | SO-260427-349 | MAIN | 40 | 25.52 | -1,020.69 | 197 | 5,026.91 | March 18, 2026: 40 @ 25.52 |
| April 22, 2026 | issue | SO-260422-314 | MAIN | 11 | 26.01 | -286.10 | 237 | 6,047.60 | Jan. 21, 2026: 8 @ 26.19; March 18, 2026: 3 @ 25.52 |
| April 12, 2026 | issue | SO-260412-857 | MAIN | 9 | 26.19 | -235.74 | 248 | 6,333.70 | Jan. 21, 2026: 9 @ 26.19 |
| March 28, 2026 | issue | SO-260328-453 | MAIN | 2 | 26.19 | -52.39 | 257 | 6,569.44 | Jan. 21, 2026: 2 @ 26.19 |
| March 24, 2026 | issue | SO-260324-758 | MAIN | 6 | 26.19 | -157.16 | 259 | 6,621.83 | Jan. 21, 2026: 6 @ 26.19 |
| March 18, 2026 | transfer | TRF | MAIN → EAST | 78 | warehouse transfer, no cost effect | ||||
| March 18, 2026 | receipt | PO-001334 | MAIN | 240 | 25.52 | 6,124.15 | 265 | 6,778.99 | |
| March 13, 2026 | issue | SO-260313-134 | MAIN | 1 | 26.19 | -26.19 | 25 | 654.84 | Jan. 21, 2026: 1 @ 26.19 |
| March 12, 2026 | issue | SO-260312-440 | MAIN | 71 | 26.19 | -1,859.74 | 26 | 681.03 | Jan. 21, 2026: 71 @ 26.19 |
| March 7, 2026 | issue | SO-260307-454 | MAIN | 33 | 26.19 | -864.39 | 97 | 2,540.77 | Jan. 21, 2026: 33 @ 26.19 |
| Feb. 5, 2026 | issue | SO-260205-623 | MAIN | 48 | 26.19 | -1,257.29 | 130 | 3,405.16 | Jan. 21, 2026: 48 @ 26.19 |
| Feb. 2, 2026 | issue | SO-260202-984 | MAIN | 10 | 26.19 | -261.94 | 178 | 4,662.44 | Jan. 21, 2026: 10 @ 26.19 |
| Jan. 25, 2026 | issue | SO-260125-819 | MAIN | 78 | 25.93 | -2,022.70 | 188 | 4,924.38 | Oct. 2, 2025: 26 @ 25.41; Jan. 21, 2026: 52 @ 26.19 |
| Jan. 21, 2026 | receipt | PO-001168 | MAIN | 240 | 26.19 | 6,286.44 | 266 | 6,947.07 | |
| Jan. 18, 2026 | issue | SO-260118-273 | MAIN | 16 | 25.41 | -406.54 | 26 | 660.63 | Oct. 2, 2025: 16 @ 25.41 |
| Jan. 13, 2026 | issue | SO-260113-745 | MAIN | 5 | 25.41 | -127.04 | 42 | 1,067.18 | Oct. 2, 2025: 5 @ 25.41 |
| Dec. 26, 2025 | issue | SO-251226-894 | MAIN | 1 | 25.41 | -25.41 | 47 | 1,194.22 | Oct. 2, 2025: 1 @ 25.41 |
| Dec. 24, 2025 | issue | SO-251224-946 | MAIN | 35 | 25.41 | -889.32 | 48 | 1,219.63 | Oct. 2, 2025: 35 @ 25.41 |
| Dec. 23, 2025 | issue | SO-251223-985 | MAIN | 12 | 25.41 | -304.91 | 83 | 2,108.95 | Oct. 2, 2025: 12 @ 25.41 |
| Dec. 3, 2025 | issue | SO-251203-351 | MAIN | 15 | 25.41 | -381.14 | 95 | 2,413.86 | Oct. 2, 2025: 15 @ 25.41 |
| Nov. 30, 2025 | issue | SO-251130-420 | MAIN | 10 | 25.41 | -254.09 | 110 | 2,794.99 | Oct. 2, 2025: 10 @ 25.41 |
| Nov. 26, 2025 | issue | SO-251126-540 | MAIN | 5 | 25.41 | -127.04 | 120 | 3,049.08 | Oct. 2, 2025: 5 @ 25.41 |
| Nov. 16, 2025 | issue | SO-251116-423 | MAIN | 21 | 25.41 | -533.59 | 125 | 3,176.12 | Oct. 2, 2025: 21 @ 25.41 |
| Nov. 15, 2025 | issue | SO-251115-309 | MAIN | 6 | 25.41 | -152.45 | 146 | 3,709.71 | Oct. 2, 2025: 6 @ 25.41 |
| Nov. 13, 2025 | issue | SO-251113-664 | MAIN | 20 | 25.41 | -508.18 | 152 | 3,862.17 | Oct. 2, 2025: 20 @ 25.41 |
| Nov. 3, 2025 | issue | SO-251103-593 | MAIN | 34 | 25.41 | -863.91 | 172 | 4,370.35 | Oct. 2, 2025: 34 @ 25.41 |
| Oct. 21, 2025 | issue | SO-251021-478 | MAIN | 3 | 25.41 | -76.23 | 206 | 5,234.25 | Oct. 2, 2025: 3 @ 25.41 |
| Oct. 18, 2025 | issue | SO-251018-397 | MAIN | 7 | 25.41 | -177.86 | 209 | 5,310.48 | Oct. 2, 2025: 7 @ 25.41 |
| Oct. 10, 2025 | issue | SO-251010-431 | MAIN | 35 | 25.53 | -893.42 | 216 | 5,488.34 | June 13, 2025: 11 @ 25.78; Oct. 2, 2025: 24 @ 25.41 |
| Oct. 9, 2025 | issue | SO-251009-354 | MAIN | 3 | 25.78 | -77.35 | 251 | 6,381.76 | June 13, 2025: 3 @ 25.78 |
| Oct. 2, 2025 | issue | SO-251002-598 | MAIN | 18 | 25.78 | -464.08 | 254 | 6,459.11 | June 13, 2025: 18 @ 25.78 |