stocksense

Items / SWT-0005

Socket 5-pin Plus SWT-0005 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)307MAIN 295, EAST 12
Value (FIFO)10,873.54avg 35.42
ClassAX / FCV 0.26
Turnover8.6xlast issue 4 days ago
Days of cover61lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00050.078.7157236315Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 219.0Nov 24: 146.0Dec 24: 144.0Jan 25: 145.0Feb 25: 194.0Mar 25: 194.0Apr 25: 242.0May 25: 223.0Jun 25: 76.0Jul 25: 238.0Aug 25: 206.0Sep 25: 286.0Oct 25: 183.0Nov 25: 91.0Dec 25: 120.0Jan 26: 134.0Feb 26: 156.0Mar 26: 148.0Apr 26: 191.0May 26: 191.0Jun 26: 143.0Jul 26: 236.0Aug 26: 157.0Sep 26: 96.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.4375153.83 / 30.43755.054
Daily demand sdmonthly sd / sqrt(30.4375)40.17 / 5.5177.281
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(7.0 * 7.281^2 + 5.054^2 * 1.5^2)42.6
Reorder pointd * LT + safety stock5.054 * 7.0 + 42.677.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days77.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1845/yr, S = 45.00, h = 20%, price = 34.79154.5
Inventory positionon hand + on order307 + 0307

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

From qtyUnit costOrder qtyAnnual costFeasible
034.7915465,253yes (chosen if cheapest)

MOQ 520, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 27, 2026307 / 52035.4210,873.54

Movement ledger 125 movements, latest 60 shown - show all

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-552EAST 80 35.42-2,833.5030710,873.54 Sept. 27, 2026: 80 @ 35.42
Oct. 10, 2026issueSO-261010-964MAIN 38 35.42-1,345.9138713,707.04 Sept. 27, 2026: 38 @ 35.42
Oct. 6, 2026issueSO-261006-708EAST 26 35.42-920.8942515,052.95 Sept. 27, 2026: 26 @ 35.42
Oct. 3, 2026issueSO-261003-535MAIN 69 35.42-2,443.8945115,973.83 Sept. 27, 2026: 69 @ 35.42
Sept. 27, 2026transferTRFMAIN → EAST 118 warehouse transfer, no cost effect
Sept. 27, 2026receiptPO-001834MAIN 520 35.4218,417.7252018,417.72
Sept. 19, 2026issueSO-260919-610MAIN 96 33.78-3,243.1500.00 June 16, 2026: 96 @ 33.78
Aug. 28, 2026issueSO-260828-302MAIN 16 33.78-540.52963,243.15 June 16, 2026: 16 @ 33.78
Aug. 20, 2026issueSO-260820-816MAIN 6 33.78-202.701123,783.67 June 16, 2026: 6 @ 33.78
Aug. 10, 2026issueSO-260810-527MAIN 8 33.78-270.261183,986.37 June 16, 2026: 8 @ 33.78
Aug. 8, 2026issueSO-260808-388MAIN 18 33.78-608.091264,256.63 June 16, 2026: 18 @ 33.78
Aug. 6, 2026issueSO-260806-183MAIN 72 33.78-2,432.361444,864.72 June 16, 2026: 72 @ 33.78
Aug. 4, 2026issueSO-260804-167MAIN 37 33.78-1,249.962167,297.08 June 16, 2026: 37 @ 33.78
July 25, 2026issueSO-260725-341MAIN 64 33.78-2,162.102538,547.05 June 16, 2026: 64 @ 33.78
July 20, 2026issueSO-260720-806MAIN 20 33.78-675.6631710,709.15 June 16, 2026: 20 @ 33.78
July 12, 2026issueSO-260712-101MAIN 26 33.78-878.3533711,384.80 June 16, 2026: 26 @ 33.78
July 5, 2026issueSO-260705-527MAIN 12 33.78-405.3936312,263.16 June 16, 2026: 12 @ 33.78
July 5, 2026issueSO-260705-527EAST 114 33.78-3,851.2437512,668.55 June 16, 2026: 114 @ 33.78
June 27, 2026issueSO-260627-628MAIN 13 33.78-439.1848916,519.79 June 16, 2026: 13 @ 33.78
June 21, 2026issueSO-260621-425MAIN 19 33.81-642.4350216,958.97 March 20, 2026: 1 @ 34.34; June 16, 2026: 18 @ 33.78
June 16, 2026transferTRFMAIN → EAST 114 warehouse transfer, no cost effect
June 16, 2026receiptPO-001579MAIN 520 33.7817,567.0652117,601.39
June 15, 2026issueSO-260615-967MAIN 16 34.34-549.38134.34 March 20, 2026: 16 @ 34.34
June 10, 2026issueSO-260610-996MAIN 18 34.34-618.0617583.72 March 20, 2026: 18 @ 34.34
June 7, 2026issueSO-260607-162MAIN 48 34.34-1,648.15351,201.77 March 20, 2026: 48 @ 34.34
June 4, 2026issueSO-260604-188MAIN 27 34.34-927.08832,849.92 March 20, 2026: 27 @ 34.34
June 2, 2026issueSO-260602-213MAIN 2 34.34-68.671103,777.00 March 20, 2026: 2 @ 34.34
May 27, 2026issueSO-260527-542MAIN 144 34.34-4,944.441123,845.68 March 20, 2026: 144 @ 34.34
May 27, 2026issueSO-260527-542EAST 4 34.34-137.352568,790.12 March 20, 2026: 4 @ 34.34
May 26, 2026issueSO-260526-168MAIN 43 34.34-1,476.472608,927.46 March 20, 2026: 43 @ 34.34
April 15, 2026issueSO-260415-412MAIN 2 34.34-68.6730310,403.93 March 20, 2026: 2 @ 34.34
April 6, 2026issueSO-260406-327MAIN 37 34.34-1,270.4530510,472.60 March 20, 2026: 37 @ 34.34
April 4, 2026issueSO-260404-467EAST 20 34.34-686.7334211,743.05 March 20, 2026: 20 @ 34.34
April 3, 2026issueSO-260403-232MAIN 132 34.34-4,532.4036212,429.78 March 20, 2026: 132 @ 34.34
March 30, 2026issueSO-260330-432MAIN 2 34.34-68.6749416,962.18 March 20, 2026: 2 @ 34.34
March 27, 2026issueSO-260327-858MAIN 24 34.34-824.0749617,030.85 March 20, 2026: 24 @ 34.34
March 22, 2026issueSO-260322-609EAST 39 33.89-1,321.5852017,854.93 Nov. 20, 2025: 39 @ 33.89
March 21, 2026issueSO-260321-215MAIN 27 33.89-914.9455919,176.51 Nov. 20, 2025: 27 @ 33.89
March 20, 2026receiptPO-001337MAIN 520 34.3417,854.9358620,091.44
March 14, 2026issueSO-260314-299MAIN 39 33.89-1,321.58662,236.52 Nov. 20, 2025: 39 @ 33.89
March 7, 2026issueSO-260307-208MAIN 1 33.89-33.891053,558.09 Nov. 20, 2025: 1 @ 33.89
March 1, 2026issueSO-260301-645MAIN 16 33.89-542.191063,591.98 Nov. 20, 2025: 16 @ 33.89
Feb. 25, 2026issueSO-260225-263MAIN 73 33.89-2,473.721224,134.17 Nov. 20, 2025: 73 @ 33.89
Feb. 21, 2026issueSO-260221-326EAST 28 33.89-948.821956,607.89 Nov. 20, 2025: 28 @ 33.89
Feb. 19, 2026issueSO-260219-679MAIN 55 33.89-1,863.762237,556.71 Nov. 20, 2025: 55 @ 33.89
Jan. 8, 2026issueSO-260108-894MAIN 130 33.89-4,405.262789,420.47 Nov. 20, 2025: 130 @ 33.89
Jan. 6, 2026adjustmentCycle countMAIN -1 33.89-33.8940813,825.73 Nov. 20, 2025: 1 @ 33.89
Jan. 4, 2026issueSO-260104-789MAIN 4 33.89-135.5540913,859.62 Nov. 20, 2025: 4 @ 33.89
Dec. 26, 2025issueSO-251226-516EAST 91 33.89-3,083.6841313,995.17 Nov. 20, 2025: 91 @ 33.89
Dec. 13, 2025issueSO-251213-952EAST 2 33.89-67.7750417,078.85 Nov. 20, 2025: 2 @ 33.89
Dec. 11, 2025issueSO-251211-536MAIN 27 33.82-913.0950617,146.62 Aug. 29, 2025: 13 @ 33.74; Nov. 20, 2025: 14 @ 33.89
Nov. 28, 2025issueSO-251128-389MAIN 15 33.74-506.1753318,059.71 Aug. 29, 2025: 15 @ 33.74
Nov. 27, 2025issueSO-251127-344MAIN 6 33.74-202.4754818,565.88 Aug. 29, 2025: 6 @ 33.74
Nov. 25, 2025issueSO-251125-804MAIN 4 33.74-134.9855418,768.34 Aug. 29, 2025: 4 @ 33.74
Nov. 22, 2025issueSO-251122-367EAST 25 33.74-843.6155818,903.32 Aug. 29, 2025: 25 @ 33.74
Nov. 20, 2025issueSO-251120-251EAST 12 33.74-404.9358319,746.94 Aug. 29, 2025: 12 @ 33.74
Nov. 20, 2025transferTRFMAIN → EAST 146 warehouse transfer, no cost effect
Nov. 20, 2025receiptPO-001013MAIN 520 33.8917,621.0359520,151.87
Nov. 14, 2025issueSO-251114-789EAST 17 33.74-573.66752,530.84 Aug. 29, 2025: 17 @ 33.74
Nov. 2, 2025issueSO-251102-757EAST 12 33.74-404.93923,104.49 Aug. 29, 2025: 12 @ 33.74