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

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