stocksense

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

Monthly demand and forecast for SWT-00310.042.685.2128170Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 155.0Nov 24: 53.0Dec 24: 70.0Jan 25: 48.0Feb 25: 87.0Mar 25: 79.0Apr 25: 70.0May 25: 72.0Jun 25: 80.0Jul 25: 42.0Aug 25: 86.0Sep 25: 84.0Oct 25: 66.0Nov 25: 96.0Dec 25: 63.0Jan 26: 99.0Feb 26: 58.0Mar 26: 113.0Apr 26: 60.0May 26: 75.0Jun 26: 54.0Jul 26: 123.0Aug 26: 94.0Sep 26: 86.0

actual forecast 90% prediction interval

No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.

Policy numbers explained

MetricFormulaSubstitutedResult
Daily demand dmonthly mean / 30.437582.25 / 30.43752.702
Daily demand sdmonthly sd / sqrt(30.4375)21.98 / 5.5173.984
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * 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 pointd * LT + safety stock2.702 * 7.0 + 18.637.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days37.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 986/yr, S = 45.00, h = 20%, price = 26.89128.5
Inventory positionon hand + on order175 + 0175

Price break evaluation (annual cost at each tier's EOQ)

From qtyUnit costOrder qtyAnnual costFeasible
026.8912827,213yes (chosen if cheapest)

MOQ 240, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 13, 2026175 / 24026.584,650.96

Movement ledger 125 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-527MAIN 33 26.58-877.041754,650.96 Sept. 13, 2026: 33 @ 26.58
Oct. 8, 2026issueSO-261008-273MAIN 35 26.65-932.632085,528.00 July 22, 2026: 3 @ 27.39; Sept. 13, 2026: 32 @ 26.58
Sept. 13, 2026issueSO-260913-422MAIN 3 27.39-82.172436,460.63 July 22, 2026: 3 @ 27.39
Sept. 13, 2026receiptPO-001798MAIN 240 26.586,378.462466,542.80
Sept. 7, 2026issueSO-260907-762MAIN 18 27.39-493.026164.34 July 22, 2026: 18 @ 27.39
Sept. 7, 2026issueSO-260907-762EAST 65 27.39-1,780.3624657.36 July 22, 2026: 65 @ 27.39
Aug. 30, 2026issueSO-260830-327MAIN 4 27.39-109.56892,437.72 July 22, 2026: 4 @ 27.39
Aug. 27, 2026issueSO-260827-369MAIN 16 27.39-438.24932,547.28 July 22, 2026: 16 @ 27.39
Aug. 23, 2026issueSO-260823-856MAIN 19 27.39-520.411092,985.52 July 22, 2026: 19 @ 27.39
Aug. 21, 2026issueSO-260821-420EAST 29 27.39-794.311283,505.93 July 22, 2026: 29 @ 27.39
Aug. 20, 2026issueSO-260820-278MAIN 12 27.39-328.681574,300.25 July 22, 2026: 12 @ 27.39
Aug. 12, 2026issueSO-260812-365MAIN 11 27.39-301.291694,628.93 July 22, 2026: 11 @ 27.39
Aug. 8, 2026issueSO-260808-990MAIN 3 27.39-82.171804,930.22 July 22, 2026: 3 @ 27.39
July 22, 2026issueSO-260722-144MAIN 79 26.87-2,122.621835,012.39 March 18, 2026: 22 @ 25.52; July 22, 2026: 57 @ 27.39
July 22, 2026transferTRFMAIN → EAST 72 warehouse transfer, no cost effect
July 22, 2026receiptPO-001662MAIN 240 27.396,573.622627,135.00
July 18, 2026issueSO-260718-709EAST 11 25.52-280.6922561.38 March 18, 2026: 11 @ 25.52
July 18, 2026issueSO-260718-709MAIN 3 25.52-76.5533842.07 March 18, 2026: 3 @ 25.52
July 16, 2026issueSO-260716-902MAIN 1 25.52-25.5236918.62 March 18, 2026: 1 @ 25.52
July 15, 2026issueSO-260715-156MAIN 4 25.52-102.0737944.14 March 18, 2026: 4 @ 25.52
July 2, 2026issueSO-260702-594MAIN 25 25.52-637.93411,046.21 March 18, 2026: 25 @ 25.52
June 18, 2026issueSO-260618-908EAST 38 25.52-969.66661,684.14 March 18, 2026: 38 @ 25.52
June 9, 2026issueSO-260609-259EAST 7 25.52-178.621042,653.80 March 18, 2026: 7 @ 25.52
June 6, 2026issueSO-260606-502MAIN 5 25.52-127.591112,832.42 March 18, 2026: 5 @ 25.52
June 3, 2026issueSO-260603-993MAIN 4 25.52-102.071162,960.01 March 18, 2026: 4 @ 25.52
May 22, 2026issueSO-260522-411MAIN 40 25.52-1,020.691203,062.08 March 18, 2026: 40 @ 25.52
May 12, 2026issueSO-260512-444MAIN 30 25.52-765.521604,082.77 March 18, 2026: 30 @ 25.52
May 9, 2026issueSO-260509-793MAIN 5 25.52-127.591904,848.29 March 18, 2026: 5 @ 25.52
April 30, 2026adjustmentCycle countMAIN -2 25.52-51.031954,975.87 March 18, 2026: 2 @ 25.52
April 27, 2026issueSO-260427-349MAIN 40 25.52-1,020.691975,026.91 March 18, 2026: 40 @ 25.52
April 22, 2026issueSO-260422-314MAIN 11 26.01-286.102376,047.60 Jan. 21, 2026: 8 @ 26.19; March 18, 2026: 3 @ 25.52
April 12, 2026issueSO-260412-857MAIN 9 26.19-235.742486,333.70 Jan. 21, 2026: 9 @ 26.19
March 28, 2026issueSO-260328-453MAIN 2 26.19-52.392576,569.44 Jan. 21, 2026: 2 @ 26.19
March 24, 2026issueSO-260324-758MAIN 6 26.19-157.162596,621.83 Jan. 21, 2026: 6 @ 26.19
March 18, 2026transferTRFMAIN → EAST 78 warehouse transfer, no cost effect
March 18, 2026receiptPO-001334MAIN 240 25.526,124.152656,778.99
March 13, 2026issueSO-260313-134MAIN 1 26.19-26.1925654.84 Jan. 21, 2026: 1 @ 26.19
March 12, 2026issueSO-260312-440MAIN 71 26.19-1,859.7426681.03 Jan. 21, 2026: 71 @ 26.19
March 7, 2026issueSO-260307-454MAIN 33 26.19-864.39972,540.77 Jan. 21, 2026: 33 @ 26.19
Feb. 5, 2026issueSO-260205-623MAIN 48 26.19-1,257.291303,405.16 Jan. 21, 2026: 48 @ 26.19
Feb. 2, 2026issueSO-260202-984MAIN 10 26.19-261.941784,662.44 Jan. 21, 2026: 10 @ 26.19
Jan. 25, 2026issueSO-260125-819MAIN 78 25.93-2,022.701884,924.38 Oct. 2, 2025: 26 @ 25.41; Jan. 21, 2026: 52 @ 26.19
Jan. 21, 2026receiptPO-001168MAIN 240 26.196,286.442666,947.07
Jan. 18, 2026issueSO-260118-273MAIN 16 25.41-406.5426660.63 Oct. 2, 2025: 16 @ 25.41
Jan. 13, 2026issueSO-260113-745MAIN 5 25.41-127.04421,067.18 Oct. 2, 2025: 5 @ 25.41
Dec. 26, 2025issueSO-251226-894MAIN 1 25.41-25.41471,194.22 Oct. 2, 2025: 1 @ 25.41
Dec. 24, 2025issueSO-251224-946MAIN 35 25.41-889.32481,219.63 Oct. 2, 2025: 35 @ 25.41
Dec. 23, 2025issueSO-251223-985MAIN 12 25.41-304.91832,108.95 Oct. 2, 2025: 12 @ 25.41
Dec. 3, 2025issueSO-251203-351MAIN 15 25.41-381.14952,413.86 Oct. 2, 2025: 15 @ 25.41
Nov. 30, 2025issueSO-251130-420MAIN 10 25.41-254.091102,794.99 Oct. 2, 2025: 10 @ 25.41
Nov. 26, 2025issueSO-251126-540MAIN 5 25.41-127.041203,049.08 Oct. 2, 2025: 5 @ 25.41
Nov. 16, 2025issueSO-251116-423MAIN 21 25.41-533.591253,176.12 Oct. 2, 2025: 21 @ 25.41
Nov. 15, 2025issueSO-251115-309MAIN 6 25.41-152.451463,709.71 Oct. 2, 2025: 6 @ 25.41
Nov. 13, 2025issueSO-251113-664MAIN 20 25.41-508.181523,862.17 Oct. 2, 2025: 20 @ 25.41
Nov. 3, 2025issueSO-251103-593MAIN 34 25.41-863.911724,370.35 Oct. 2, 2025: 34 @ 25.41
Oct. 21, 2025issueSO-251021-478MAIN 3 25.41-76.232065,234.25 Oct. 2, 2025: 3 @ 25.41
Oct. 18, 2025issueSO-251018-397MAIN 7 25.41-177.862095,310.48 Oct. 2, 2025: 7 @ 25.41
Oct. 10, 2025issueSO-251010-431MAIN 35 25.53-893.422165,488.34 June 13, 2025: 11 @ 25.78; Oct. 2, 2025: 24 @ 25.41
Oct. 9, 2025issueSO-251009-354MAIN 3 25.78-77.352516,381.76 June 13, 2025: 3 @ 25.78
Oct. 2, 2025issueSO-251002-598MAIN 18 25.78-464.082546,459.11 June 13, 2025: 18 @ 25.78
Oct. 2, 2025receiptPO-000894MAIN 240 25.416,098.162726,923.19
Sept. 26, 2025issueSO-250926-999MAIN 13 25.78-335.1732825.03 June 13, 2025: 13 @ 25.78
Sept. 20, 2025issueSO-250920-630MAIN 3 25.78-77.35451,160.20 June 13, 2025: 3 @ 25.78
Sept. 15, 2025issueSO-250915-982MAIN 6 25.78-154.69481,237.55 June 13, 2025: 6 @ 25.78
Sept. 12, 2025issueSO-250912-797MAIN 62 25.78-1,598.50541,392.24 June 13, 2025: 62 @ 25.78
Aug. 30, 2025issueSO-250830-854MAIN 11 25.78-283.601162,990.74 June 13, 2025: 11 @ 25.78
Aug. 25, 2025issueSO-250825-436MAIN 27 25.78-696.121273,274.34 June 13, 2025: 27 @ 25.78
Aug. 20, 2025issueSO-250820-371MAIN 2 25.78-51.561543,970.46 June 13, 2025: 2 @ 25.78
Aug. 20, 2025issueSO-250820-371EAST 3 25.78-77.351564,022.02 June 13, 2025: 3 @ 25.78
Aug. 6, 2025issueSO-250806-620EAST 43 25.78-1,108.631594,099.37 June 13, 2025: 43 @ 25.78
July 27, 2025issueSO-250727-990EAST 2 25.78-51.562025,208.00 June 13, 2025: 2 @ 25.78
July 25, 2025issueSO-250725-590MAIN 4 25.78-103.132045,259.57 June 13, 2025: 4 @ 25.78
July 21, 2025issueSO-250721-335MAIN 2 25.78-51.562085,362.70 June 13, 2025: 2 @ 25.78
July 20, 2025issueSO-250720-297MAIN 17 25.78-438.302105,414.26 June 13, 2025: 17 @ 25.78
July 5, 2025issueSO-250705-784EAST 1 25.78-25.782275,852.56 June 13, 2025: 1 @ 25.78
July 4, 2025issueSO-250704-822EAST 1 25.78-25.782285,878.34 June 13, 2025: 1 @ 25.78
July 3, 2025issueSO-250703-677MAIN 15 25.63-384.512295,904.12 March 20, 2025: 4 @ 25.23; June 13, 2025: 11 @ 25.78
June 25, 2025issueSO-250625-783MAIN 5 25.23-126.132446,288.63 March 20, 2025: 5 @ 25.23
June 18, 2025issueSO-250618-721MAIN 21 25.23-529.752496,414.76 March 20, 2025: 21 @ 25.23
June 13, 2025transferTRFMAIN → EAST 50 warehouse transfer, no cost effect
June 13, 2025receiptPO-000632MAIN 240 25.786,187.732706,944.51
June 11, 2025issueSO-250611-249MAIN 2 25.23-50.4530756.79 March 20, 2025: 2 @ 25.23
June 6, 2025issueSO-250606-235MAIN 1 25.23-25.2332807.24 March 20, 2025: 1 @ 25.23
June 5, 2025issueSO-250605-209MAIN 35 25.23-882.9233832.46 March 20, 2025: 35 @ 25.23
June 2, 2025issueSO-250602-110MAIN 16 25.23-403.62681,715.38 March 20, 2025: 16 @ 25.23
May 30, 2025issueSO-250530-183MAIN 27 25.23-681.11842,119.00 March 20, 2025: 27 @ 25.23
May 26, 2025issueSO-250526-527MAIN 45 25.23-1,135.181112,800.11 March 20, 2025: 45 @ 25.23
April 27, 2025issueSO-250427-428MAIN 10 25.23-252.261563,935.29 March 20, 2025: 10 @ 25.23
April 23, 2025issueSO-250423-805MAIN 14 25.23-353.171664,187.55 March 20, 2025: 14 @ 25.23
April 19, 2025issueSO-250419-112MAIN 17 25.23-428.851804,540.72 March 20, 2025: 17 @ 25.23
April 13, 2025issueSO-250413-330MAIN 15 25.23-378.391974,969.56 March 20, 2025: 15 @ 25.23
April 8, 2025issueSO-250408-583MAIN 8 25.23-201.812125,347.95 March 20, 2025: 8 @ 25.23
April 7, 2025issueSO-250407-466MAIN 6 25.23-151.362205,549.76 March 20, 2025: 6 @ 25.23
March 29, 2025issueSO-250329-926MAIN 24 25.03-600.762265,701.12 Nov. 30, 2024: 10 @ 24.76; March 20, 2025: 14 @ 25.23
March 25, 2025issueSO-250325-629MAIN 7 24.76-173.322506,301.88 Nov. 30, 2024: 7 @ 24.76
March 21, 2025issueSO-250321-692MAIN 8 24.76-198.082576,475.20 Nov. 30, 2024: 8 @ 24.76
March 20, 2025receiptPO-000359MAIN 240 25.236,054.292656,673.28
March 14, 2025issueSO-250314-536MAIN 8 24.76-198.0825618.99 Nov. 30, 2024: 8 @ 24.76
March 12, 2025issueSO-250312-965MAIN 23 24.76-569.4733817.07 Nov. 30, 2024: 23 @ 24.76
March 3, 2025issueSO-250303-422MAIN 9 24.76-222.84561,386.54 Nov. 30, 2024: 9 @ 24.76
Feb. 26, 2025issueSO-250226-758MAIN 29 24.76-718.03651,609.38 Nov. 30, 2024: 29 @ 24.76
Feb. 5, 2025adjustmentCycle countMAIN -2 24.76-49.52942,327.41 Nov. 30, 2024: 2 @ 24.76
Feb. 4, 2025issueSO-250204-928MAIN 58 24.76-1,436.06962,376.93 Nov. 30, 2024: 58 @ 24.76
Jan. 18, 2025issueSO-250118-132MAIN 13 24.76-321.881543,812.99 Nov. 30, 2024: 13 @ 24.76
Jan. 16, 2025issueSO-250116-943MAIN 21 24.76-519.951674,134.87 Nov. 30, 2024: 21 @ 24.76
Jan. 4, 2025issueSO-250104-530MAIN 11 24.76-272.361884,654.82 Nov. 30, 2024: 11 @ 24.76
Jan. 2, 2025issueSO-250102-811MAIN 3 24.76-74.281994,927.18 Nov. 30, 2024: 3 @ 24.76
Dec. 10, 2024issueSO-241210-852MAIN 30 24.76-742.792025,001.46 Nov. 30, 2024: 30 @ 24.76
Dec. 8, 2024issueSO-241208-699MAIN 40 25.39-1,015.532325,744.25 Oct. 1, 2024: 32 @ 25.55; Nov. 30, 2024: 8 @ 24.76
Nov. 30, 2024receiptPO-000067MAIN 240 24.765,942.332726,759.78
Nov. 20, 2024issueSO-241120-989MAIN 5 25.55-127.7332817.46 Oct. 1, 2024: 5 @ 25.55
Nov. 19, 2024issueSO-241119-918MAIN 1 25.55-25.5537945.18 Oct. 1, 2024: 1 @ 25.55
Nov. 16, 2024issueSO-241116-495MAIN 3 25.55-76.6438970.73 Oct. 1, 2024: 3 @ 25.55
Nov. 9, 2024issueSO-241109-419MAIN 11 25.55-281.00411,047.37 Oct. 1, 2024: 11 @ 25.55
Nov. 9, 2024issueSO-241109-419EAST 20 25.55-510.91521,328.37 Oct. 1, 2024: 20 @ 25.55
Nov. 2, 2024issueSO-241102-967MAIN 6 25.55-153.27721,839.28 Oct. 1, 2024: 6 @ 25.55
Nov. 1, 2024issueSO-241101-313EAST 7 25.55-178.82781,992.55 Oct. 1, 2024: 7 @ 25.55
Oct. 22, 2024issueSO-241022-176MAIN 17 25.55-434.27852,171.37 Oct. 1, 2024: 17 @ 25.55
Oct. 21, 2024issueSO-241021-122MAIN 1 25.55-25.551022,605.64 Oct. 1, 2024: 1 @ 25.55
Oct. 8, 2024issueSO-241008-408MAIN 45 25.55-1,149.551032,631.19 Oct. 1, 2024: 45 @ 25.55
Oct. 6, 2024issueSO-241006-663EAST 14 25.55-357.641483,780.73 Oct. 1, 2024: 14 @ 25.55
Oct. 2, 2024issueSO-241002-646MAIN 45 25.55-1,149.551624,138.37 Oct. 1, 2024: 45 @ 25.55
Oct. 1, 2024issueSO-241001-100EAST 33 25.55-843.002075,287.92 Oct. 1, 2024: 33 @ 25.55
Oct. 1, 2024transferTRFMAIN → EAST 74 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 240 25.556,130.922406,130.92