stocksense

Items / SWT-0027

USB Charger Socket Pro SWT-0027 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)455MAIN 455
Value (FIFO)2,119.39avg 4.66
ClassCX / FCV 0.22
Turnover4.1xlast issue 2 days ago
Days of cover95lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00270.060.0120180240Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 149.0Nov 24: 117.0Dec 24: 194.0Jan 25: 180.0Feb 25: 214.0Mar 25: 87.0Apr 25: 143.0May 25: 156.0Jun 25: 132.0Jul 25: 218.0Aug 25: 168.0Sep 25: 63.0Oct 25: 85.0Nov 25: 168.0Dec 25: 135.0Jan 26: 176.0Feb 26: 159.0Mar 26: 180.0Apr 26: 199.0May 26: 125.0Jun 26: 129.0Jul 26: 113.0Aug 26: 114.0Sep 26: 172.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.4375146.25 / 30.43754.805
Daily demand sdmonthly sd / sqrt(30.4375)32.76 / 5.5175.938
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(7.0 * 5.938^2 + 4.805^2 * 1.5^2)22.2
Reorder pointd * LT + safety stock4.805 * 7.0 + 22.255.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days55.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1754/yr, S = 45.00, h = 20%, price = 4.56416.0
Inventory positionon hand + on order455 + 0455

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

From qtyUnit costOrder qtyAnnual costFeasible
04.564168,377yes (chosen if cheapest)

MOQ 460, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 10, 2026455 / 4604.662,119.39

Movement ledger 133 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-907MAIN 7 4.64-32.484552,119.39 Oct. 9, 2026: 2 @ 4.60; Oct. 10, 2026: 5 @ 4.66
Oct. 10, 2026receiptPO-001866MAIN 460 4.662,142.684622,151.87
Oct. 9, 2026returnRMAMAIN 2 4.609.1929.19
Oct. 9, 2026issueSO-261009-663MAIN 18 4.60-82.7200.00 Sept. 2, 2026: 18 @ 4.60
Oct. 8, 2026issueSO-261008-269MAIN 21 4.60-96.511882.72 July 1, 2026: 18 @ 4.60; Sept. 2, 2026: 3 @ 4.60
Oct. 5, 2026issueSO-261005-780MAIN 53 4.60-243.5739179.23 July 1, 2026: 53 @ 4.60
Oct. 5, 2026issueSO-261005-780EAST 12 4.60-55.1592422.80 July 1, 2026: 12 @ 4.60
Sept. 23, 2026issueSO-260923-385MAIN 69 4.60-317.10104477.95 July 1, 2026: 69 @ 4.60
Sept. 22, 2026issueSO-260922-495MAIN 5 4.60-22.98173795.06 July 1, 2026: 5 @ 4.60
Sept. 18, 2026issueSO-260918-574EAST 57 4.60-261.95178818.03 July 1, 2026: 57 @ 4.60
Sept. 13, 2026issueSO-260913-626MAIN 11 4.60-50.552351,079.99 July 1, 2026: 11 @ 4.60
Sept. 11, 2026issueSO-260911-970MAIN 51 4.60-234.382461,130.54 July 1, 2026: 51 @ 4.60
Sept. 2, 2026returnRMAMAIN 21 4.6096.512971,364.92
Aug. 29, 2026issueSO-260829-118MAIN 42 4.60-193.022761,268.41 July 1, 2026: 42 @ 4.60
Aug. 27, 2026issueSO-260827-445EAST 38 4.60-174.643181,461.43 July 1, 2026: 38 @ 4.60
Aug. 17, 2026issueSO-260817-890MAIN 28 4.60-128.683561,636.07 July 1, 2026: 28 @ 4.60
Aug. 16, 2026issueSO-260816-956EAST 6 4.60-27.573841,764.75 July 1, 2026: 6 @ 4.60
July 28, 2026issueSO-260728-102MAIN 3 4.60-13.793901,792.32 July 1, 2026: 3 @ 4.60
July 25, 2026issueSO-260725-211MAIN 39 4.60-179.233931,806.11 July 1, 2026: 39 @ 4.60
July 8, 2026issueSO-260708-216MAIN 71 4.46-316.644321,985.34 March 18, 2026: 26 @ 4.37; April 3, 2026: 1 @ 4.39; April 17, 2026: 16 @ 4.37; July 1, 2026: 28 @ 4.60
July 1, 2026transferTRFMAIN → EAST 113 warehouse transfer, no cost effect
July 1, 2026receiptPO-001616MAIN 460 4.602,114.025032,301.98
June 25, 2026issueSO-260625-574MAIN 26 4.37-113.6443187.96 March 18, 2026: 26 @ 4.37
June 24, 2026issueSO-260624-772MAIN 9 4.37-39.3469301.60 March 18, 2026: 9 @ 4.37
June 7, 2026issueSO-260607-912MAIN 94 4.37-410.8478340.93 March 18, 2026: 94 @ 4.37
May 28, 2026issueSO-260528-305MAIN 24 4.37-104.89172751.77 March 18, 2026: 24 @ 4.37
May 16, 2026issueSO-260516-701MAIN 9 4.37-39.34196856.66 March 18, 2026: 9 @ 4.37
May 4, 2026issueSO-260504-572MAIN 12 4.37-52.45205896.00 March 18, 2026: 12 @ 4.37
May 2, 2026issueSO-260502-533MAIN 36 4.37-157.34217948.44 March 18, 2026: 36 @ 4.37
May 1, 2026issueSO-260501-143MAIN 44 4.37-192.312531,105.79 March 18, 2026: 44 @ 4.37
April 20, 2026issueSO-260420-858MAIN 26 4.37-113.642971,298.09 March 18, 2026: 26 @ 4.37
April 17, 2026returnRMAMAIN 16 4.3769.933231,411.73
April 14, 2026issueSO-260414-728MAIN 27 4.37-118.013071,341.80 March 18, 2026: 27 @ 4.37
April 13, 2026issueSO-260413-439MAIN 6 4.37-26.223341,459.80 March 18, 2026: 6 @ 4.37
April 10, 2026issueSO-260410-873MAIN 57 4.37-249.123401,486.03 March 18, 2026: 57 @ 4.37
April 4, 2026issueSO-260404-109MAIN 67 4.37-292.903971,735.15 Jan. 19, 2026: 3 @ 4.39; March 18, 2026: 64 @ 4.37
April 3, 2026returnRMAMAIN 1 4.394.394642,028.06
April 1, 2026issueSO-260401-426MAIN 33 4.39-145.034632,023.66 Jan. 19, 2026: 33 @ 4.39
March 31, 2026issueSO-260331-284MAIN 3 4.39-13.184962,168.69 Jan. 19, 2026: 3 @ 4.39
March 18, 2026receiptPO-001333MAIN 460 4.372,010.484992,181.88
March 10, 2026issueSO-260310-644MAIN 97 4.39-426.3139171.40 Jan. 19, 2026: 97 @ 4.39
March 9, 2026issueSO-260309-705MAIN 51 4.39-224.14136597.71 Jan. 19, 2026: 51 @ 4.39
March 9, 2026issueSO-260309-705EAST 12 4.39-52.74187821.85 Jan. 19, 2026: 12 @ 4.39
March 4, 2026issueSO-260304-780EAST 17 4.39-74.71199874.59 Jan. 19, 2026: 17 @ 4.39
Feb. 26, 2026issueSO-260226-379MAIN 67 4.39-294.46216949.30 Jan. 19, 2026: 67 @ 4.39
Feb. 5, 2026issueSO-260205-647EAST 74 4.39-325.222831,243.76 Jan. 19, 2026: 74 @ 4.39
Feb. 1, 2026issueSO-260201-602MAIN 18 4.39-79.113571,568.98 Jan. 19, 2026: 18 @ 4.39
Jan. 31, 2026issueSO-260131-195EAST 53 4.39-232.933751,648.09 Jan. 19, 2026: 53 @ 4.39
Jan. 30, 2026issueSO-260130-369MAIN 34 4.39-149.184281,881.02 Sept. 26, 2025: 2 @ 4.27; Jan. 19, 2026: 32 @ 4.39
Jan. 19, 2026transferTRFMAIN → EAST 156 warehouse transfer, no cost effect
Jan. 19, 2026receiptPO-001161MAIN 460 4.392,021.654622,030.19
Jan. 16, 2026issueSO-260116-134MAIN 4 4.27-17.0828.54 Sept. 26, 2025: 4 @ 4.27
Jan. 13, 2026issueSO-260113-653MAIN 75 4.35-326.02625.62 Sept. 17, 2025: 62 @ 4.36; Sept. 26, 2025: 13 @ 4.27
Jan. 10, 2026issueSO-260110-515MAIN 10 4.36-43.6381351.64 Sept. 17, 2025: 10 @ 4.36
Dec. 30, 2025issueSO-251230-310MAIN 47 4.36-205.0891395.27 Sept. 17, 2025: 47 @ 4.36
Dec. 23, 2025issueSO-251223-665MAIN 40 4.36-174.53138600.35 Sept. 17, 2025: 40 @ 4.36
Dec. 17, 2025issueSO-251217-347MAIN 9 4.36-39.27178774.88 Sept. 17, 2025: 9 @ 4.36
Dec. 16, 2025issueSO-251216-161MAIN 16 4.36-69.81187814.15 Sept. 17, 2025: 16 @ 4.36
Dec. 4, 2025issueSO-251204-808MAIN 6 4.36-26.18203883.96 Sept. 17, 2025: 6 @ 4.36
Dec. 1, 2025issueSO-251201-827MAIN 17 4.36-74.18209910.14 Sept. 17, 2025: 17 @ 4.36
Nov. 27, 2025issueSO-251127-410MAIN 40 4.36-174.53226984.32 Sept. 17, 2025: 40 @ 4.36
Nov. 19, 2025issueSO-251119-342MAIN 38 4.36-165.812661,158.85 Sept. 17, 2025: 38 @ 4.36
Nov. 16, 2025issueSO-251116-467MAIN 11 4.36-48.003041,324.66 Sept. 17, 2025: 11 @ 4.36
Nov. 11, 2025issueSO-251111-644MAIN 47 4.36-205.083151,372.65 Sept. 17, 2025: 47 @ 4.36
Nov. 7, 2025issueSO-251107-344MAIN 2 4.36-8.733621,577.73 Sept. 17, 2025: 2 @ 4.36
Nov. 1, 2025issueSO-251101-109MAIN 30 4.36-130.903641,586.45 Sept. 17, 2025: 30 @ 4.36
Oct. 28, 2025issueSO-251028-762MAIN 33 4.36-143.993941,717.35 Sept. 17, 2025: 33 @ 4.36
Oct. 25, 2025issueSO-251025-311MAIN 1 4.36-4.364271,861.34 Sept. 17, 2025: 1 @ 4.36
Oct. 18, 2025issueSO-251018-549MAIN 3 4.36-13.094281,865.70 Sept. 17, 2025: 3 @ 4.36
Oct. 17, 2025issueSO-251017-220MAIN 21 4.36-91.634311,878.79 Sept. 17, 2025: 21 @ 4.36
Oct. 15, 2025issueSO-251015-588MAIN 5 4.36-21.824521,970.42 Sept. 17, 2025: 5 @ 4.36
Oct. 9, 2025issueSO-251009-554MAIN 6 4.36-26.184571,992.24 Sept. 17, 2025: 6 @ 4.36
Oct. 8, 2025issueSO-251008-292MAIN 16 4.36-69.814632,018.42 Sept. 17, 2025: 16 @ 4.36
Sept. 26, 2025returnRMAMAIN 19 4.2781.114792,088.23
Sept. 17, 2025receiptPO-000853MAIN 460 4.362,007.124602,007.12
Sept. 15, 2025issueSO-250915-246MAIN 39 4.27-166.5000.00 June 24, 2025: 39 @ 4.27
Sept. 10, 2025issueSO-250910-533MAIN 43 4.27-183.5839166.50 June 24, 2025: 43 @ 4.27
Aug. 25, 2025issueSO-250825-204MAIN 94 4.27-401.3082350.07 June 24, 2025: 94 @ 4.27
Aug. 4, 2025issueSO-250804-632MAIN 74 4.27-315.92176751.38 June 24, 2025: 74 @ 4.27
July 29, 2025issueSO-250729-589MAIN 38 4.27-162.232501,067.30 June 24, 2025: 38 @ 4.27
July 19, 2025issueSO-250719-426MAIN 17 4.27-72.582881,229.53 June 24, 2025: 17 @ 4.27
July 11, 2025issueSO-250711-116MAIN 104 4.27-444.003051,302.11 June 24, 2025: 104 @ 4.27
July 4, 2025issueSO-250704-674MAIN 59 4.28-252.574091,746.10 June 6, 2025: 8 @ 4.36; June 24, 2025: 51 @ 4.27
June 25, 2025issueSO-250625-767MAIN 25 4.36-108.884681,998.67 Feb. 20, 2025: 12 @ 4.36; June 6, 2025: 13 @ 4.36
June 24, 2025receiptPO-000663MAIN 460 4.271,963.834932,107.55
June 18, 2025issueSO-250618-961MAIN 45 4.36-195.9833143.72 Feb. 20, 2025: 45 @ 4.36
June 12, 2025issueSO-250612-431MAIN 32 4.36-139.3678339.69 Feb. 20, 2025: 32 @ 4.36
June 10, 2025issueSO-250610-995MAIN 12 4.36-52.26110479.05 Feb. 20, 2025: 12 @ 4.36
June 9, 2025issueSO-250609-562MAIN 28 4.36-121.94122531.31 Feb. 20, 2025: 28 @ 4.36
June 8, 2025issueSO-250608-712MAIN 11 4.36-47.90150653.25 Feb. 20, 2025: 11 @ 4.36
June 6, 2025returnRMAMAIN 21 4.3691.46161701.16
May 27, 2025issueSO-250527-745MAIN 42 4.36-182.91140609.70 Feb. 20, 2025: 42 @ 4.36
May 27, 2025issueSO-250527-745EAST 21 4.36-91.46182792.61 Feb. 20, 2025: 21 @ 4.36
May 23, 2025issueSO-250523-600EAST 10 4.36-43.55203884.06 Feb. 20, 2025: 10 @ 4.36
May 21, 2025issueSO-250521-776MAIN 3 4.36-13.06213927.62 Feb. 20, 2025: 3 @ 4.36
May 13, 2025issueSO-250513-499MAIN 14 4.36-60.97216940.68 Feb. 20, 2025: 14 @ 4.36
May 12, 2025issueSO-250512-325MAIN 23 4.36-100.162301,001.65 Feb. 20, 2025: 23 @ 4.36
May 10, 2025issueSO-250510-677EAST 5 4.36-21.782531,101.82 Feb. 20, 2025: 5 @ 4.36
May 6, 2025issueSO-250506-529MAIN 38 4.36-165.492581,123.59 Feb. 20, 2025: 38 @ 4.36
April 18, 2025issueSO-250418-362MAIN 93 4.36-405.022961,289.08 Feb. 20, 2025: 93 @ 4.36
April 10, 2025issueSO-250410-292MAIN 12 4.36-52.263891,694.10 Feb. 20, 2025: 12 @ 4.36
April 3, 2025issueSO-250403-547MAIN 38 4.36-165.494011,746.36 Feb. 20, 2025: 38 @ 4.36
March 28, 2025issueSO-250328-572EAST 45 4.22-189.914391,911.84 Dec. 25, 2024: 20 @ 4.10; Jan. 28, 2025: 4 @ 4.10; Feb. 20, 2025: 21 @ 4.36
March 16, 2025issueSO-250316-500MAIN 14 4.10-57.434842,101.76 Dec. 25, 2024: 14 @ 4.10
March 13, 2025issueSO-250313-535EAST 10 4.10-41.024982,159.19 Dec. 25, 2024: 10 @ 4.10
March 8, 2025issueSO-250308-430EAST 10 4.10-41.025082,200.21 Dec. 25, 2024: 10 @ 4.10
March 1, 2025issueSO-250301-218EAST 8 4.10-32.825182,241.23 Dec. 25, 2024: 8 @ 4.10
Feb. 25, 2025issueSO-250225-136MAIN 1 4.10-4.105262,274.05 Dec. 25, 2024: 1 @ 4.10
Feb. 20, 2025transferTRFMAIN → EAST 109 warehouse transfer, no cost effect
Feb. 20, 2025receiptPO-000284MAIN 460 4.362,003.305272,278.15
Feb. 15, 2025issueSO-250215-567MAIN 14 4.10-57.4367274.85 Dec. 25, 2024: 14 @ 4.10
Feb. 5, 2025issueSO-250205-638MAIN 110 4.10-451.2581332.29 Dec. 25, 2024: 110 @ 4.10
Feb. 3, 2025issueSO-250203-431MAIN 89 4.10-365.10191783.54 Dec. 25, 2024: 89 @ 4.10
Jan. 28, 2025returnRMAMAIN 4 4.1016.412801,148.64
Jan. 22, 2025issueSO-250122-557MAIN 25 4.10-102.562761,132.23 Dec. 25, 2024: 25 @ 4.10
Jan. 13, 2025issueSO-250113-128MAIN 9 4.10-36.923011,234.79 Dec. 25, 2024: 9 @ 4.10
Jan. 10, 2025issueSO-250110-794MAIN 31 4.10-127.173101,271.71 Dec. 25, 2024: 31 @ 4.10
Jan. 8, 2025issueSO-250108-357MAIN 10 4.10-41.023411,398.88 Dec. 25, 2024: 10 @ 4.10
Jan. 8, 2025issueSO-250108-357EAST 91 4.10-373.313511,439.91 Dec. 25, 2024: 91 @ 4.10
Jan. 6, 2025issueSO-250106-394EAST 18 4.10-73.844421,813.22 Dec. 25, 2024: 18 @ 4.10
Dec. 25, 2024transferTRFMAIN → EAST 109 warehouse transfer, no cost effect
Dec. 25, 2024receiptPO-000134MAIN 460 4.101,887.064601,887.06
Dec. 22, 2024issueSO-241222-763MAIN 80 4.33-346.5600.00 Oct. 1, 2024: 80 @ 4.33
Dec. 16, 2024issueSO-241216-437MAIN 114 4.33-493.8580346.56 Oct. 1, 2024: 114 @ 4.33
Nov. 22, 2024issueSO-241122-881MAIN 1 4.33-4.33194840.41 Oct. 1, 2024: 1 @ 4.33
Nov. 17, 2024issueSO-241117-589MAIN 18 4.33-77.98195844.74 Oct. 1, 2024: 18 @ 4.33
Nov. 7, 2024issueSO-241107-372MAIN 98 4.33-424.54213922.72 Oct. 1, 2024: 98 @ 4.33
Oct. 27, 2024issueSO-241027-123MAIN 21 4.33-90.973111,347.25 Oct. 1, 2024: 21 @ 4.33
Oct. 22, 2024issueSO-241022-240MAIN 63 4.33-272.923321,438.22 Oct. 1, 2024: 63 @ 4.33
Oct. 17, 2024issueSO-241017-704MAIN 13 4.33-56.323951,711.14 Oct. 1, 2024: 13 @ 4.33
Oct. 6, 2024issueSO-241006-111MAIN 45 4.33-194.944081,767.46 Oct. 1, 2024: 45 @ 4.33
Oct. 1, 2024issueSO-241001-676MAIN 7 4.33-30.324531,962.40 Oct. 1, 2024: 7 @ 4.33
Oct. 1, 2024receiptPO-000005MAIN 460 4.331,992.724601,992.72