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

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
Oct. 31, 2025issueSO-251031-933EAST 18 33.74-607.401043,509.43 Aug. 29, 2025: 18 @ 33.74
Oct. 18, 2025issueSO-251018-959EAST 1 33.74-33.741224,116.83 Aug. 29, 2025: 1 @ 33.74
Oct. 13, 2025issueSO-251013-419EAST 20 33.74-674.891234,150.57 Aug. 29, 2025: 20 @ 33.74
Oct. 13, 2025issueSO-251013-419MAIN 39 33.74-1,316.041434,825.46 Aug. 29, 2025: 39 @ 33.74
Oct. 9, 2025issueSO-251009-376EAST 9 33.74-303.701826,141.50 Aug. 29, 2025: 9 @ 33.74
Oct. 3, 2025issueSO-251003-250MAIN 96 33.74-3,239.471916,445.20 Aug. 29, 2025: 96 @ 33.74
Sept. 20, 2025issueSO-250920-252MAIN 71 33.74-2,395.862879,684.67 Aug. 29, 2025: 71 @ 33.74
Sept. 17, 2025issueSO-250917-416MAIN 32 33.74-1,079.8235812,080.53 Aug. 29, 2025: 32 @ 33.74
Sept. 8, 2025issueSO-250908-364MAIN 159 33.49-5,325.2839013,160.36 June 7, 2025: 29 @ 32.36; Aug. 29, 2025: 130 @ 33.74
Sept. 7, 2025issueSO-250907-125MAIN 24 32.36-776.6854918,485.63 June 7, 2025: 24 @ 32.36
Aug. 29, 2025transferTRFMAIN → EAST 152 warehouse transfer, no cost effect
Aug. 29, 2025receiptPO-000802MAIN 520 33.7417,547.1457319,262.32
Aug. 28, 2025issueSO-250828-771MAIN 4 32.36-129.45531,715.18 June 7, 2025: 4 @ 32.36
Aug. 24, 2025issueSO-250824-428MAIN 25 32.36-809.04571,844.62 June 7, 2025: 25 @ 32.36
Aug. 22, 2025issueSO-250822-693MAIN 89 32.36-2,880.20822,653.67 June 7, 2025: 89 @ 32.36
Aug. 17, 2025issueSO-250817-377MAIN 60 32.36-1,941.711715,533.87 June 7, 2025: 60 @ 32.36
Aug. 13, 2025issueSO-250813-220MAIN 28 32.36-906.132317,475.58 June 7, 2025: 28 @ 32.36
July 28, 2025issueSO-250728-965MAIN 6 32.36-194.172598,381.71 June 7, 2025: 6 @ 32.36
July 23, 2025issueSO-250723-425MAIN 94 32.36-3,042.012658,575.88 June 7, 2025: 94 @ 32.36
July 13, 2025issueSO-250713-146MAIN 31 32.36-1,003.2235911,617.89 June 7, 2025: 31 @ 32.36
July 12, 2025issueSO-250712-344MAIN 2 32.36-64.7239012,621.10 June 7, 2025: 2 @ 32.36
July 11, 2025issueSO-250711-146MAIN 87 32.36-2,815.4839212,685.83 June 7, 2025: 87 @ 32.36
July 7, 2025issueSO-250707-386MAIN 18 32.36-582.5147915,501.30 June 7, 2025: 18 @ 32.36
June 25, 2025issueSO-250625-217MAIN 23 32.36-744.3249716,083.81 June 7, 2025: 23 @ 32.36
June 7, 2025receiptPO-000613MAIN 520 32.3616,828.1452016,828.14
June 3, 2025issueSO-250603-838MAIN 30 32.52-975.5800.00 March 21, 2025: 30 @ 32.52
June 3, 2025issueSO-250603-838EAST 23 32.52-747.9430975.58 March 21, 2025: 23 @ 32.52
May 30, 2025issueSO-250530-541MAIN 44 32.52-1,430.85531,723.52 March 21, 2025: 44 @ 32.52
May 18, 2025issueSO-250518-221EAST 89 32.52-2,894.22973,154.37 March 21, 2025: 89 @ 32.52
May 14, 2025issueSO-250514-758MAIN 68 32.52-2,211.311866,048.59 March 21, 2025: 68 @ 32.52
May 10, 2025issueSO-250510-647EAST 22 32.52-715.422548,259.90 March 21, 2025: 22 @ 32.52
April 30, 2025issueSO-250430-616MAIN 27 32.52-878.022768,975.33 March 21, 2025: 27 @ 32.52
April 22, 2025issueSO-250422-573EAST 6 32.52-195.123039,853.35 March 21, 2025: 6 @ 32.52
April 18, 2025issueSO-250418-528MAIN 110 32.52-3,577.1230910,048.46 March 21, 2025: 110 @ 32.52
April 9, 2025issueSO-250409-455MAIN 20 32.52-650.3941913,625.59 March 21, 2025: 20 @ 32.52
April 6, 2025issueSO-250406-370MAIN 9 32.52-292.6743914,275.97 March 21, 2025: 9 @ 32.52
April 3, 2025issueSO-250403-121EAST 39 32.52-1,268.2544814,568.65 March 21, 2025: 39 @ 32.52
April 2, 2025issueSO-250402-507MAIN 31 32.52-1,008.1048715,836.90 March 21, 2025: 31 @ 32.52
March 24, 2025issueSO-250324-529MAIN 54 32.52-1,756.0751816,845.00 Feb. 20, 2025: 30 @ 32.52; March 20, 2025: 22 @ 32.52; March 21, 2025: 2 @ 32.52
March 22, 2025issueSO-250322-312MAIN 30 32.52-975.5957218,601.07 Feb. 4, 2025: 17 @ 32.52; Feb. 20, 2025: 13 @ 32.52
March 21, 2025transferTRFMAIN → EAST 179 warehouse transfer, no cost effect
March 21, 2025receiptPO-000362MAIN 520 32.5216,910.0460219,576.66
March 20, 2025returnRMAMAIN 22 32.52715.44822,666.62
March 15, 2025issueSO-250315-140MAIN 45 32.52-1,463.39601,951.19 Jan. 7, 2025: 45 @ 32.52
March 11, 2025issueSO-250311-561MAIN 52 32.52-1,691.031053,414.58 Jan. 7, 2025: 52 @ 32.52
March 4, 2025issueSO-250304-411MAIN 35 32.52-1,138.191575,105.61 Jan. 7, 2025: 35 @ 32.52
Feb. 23, 2025issueSO-250223-247MAIN 25 32.52-813.001926,243.80 Jan. 7, 2025: 25 @ 32.52
Feb. 20, 2025returnRMAMAIN 43 32.521,398.352177,056.80
Feb. 13, 2025issueSO-250213-956MAIN 87 32.52-2,829.221745,658.45 Jan. 7, 2025: 87 @ 32.52
Feb. 8, 2025issueSO-250208-813MAIN 17 32.52-552.842618,487.67 Jan. 7, 2025: 17 @ 32.52
Feb. 7, 2025issueSO-250207-492MAIN 91 32.52-2,959.302789,040.50 Jan. 7, 2025: 91 @ 32.52
Feb. 4, 2025returnRMAMAIN 17 32.52552.8436911,999.81
Feb. 2, 2025issueSO-250202-831MAIN 34 32.52-1,105.6735211,446.97 Jan. 7, 2025: 34 @ 32.52
Jan. 25, 2025issueSO-250125-892MAIN 110 32.52-3,577.1838612,552.64 Jan. 7, 2025: 110 @ 32.52
Jan. 22, 2025issueSO-250122-679MAIN 35 32.69-1,144.0349616,129.82 Oct. 1, 2024: 11 @ 33.05; Jan. 7, 2025: 24 @ 32.52
Jan. 7, 2025receiptPO-000168MAIN 520 32.5216,910.3053117,273.85
Dec. 31, 2024issueSO-241231-462MAIN 90 33.05-2,974.5411363.56 Oct. 1, 2024: 90 @ 33.05
Dec. 27, 2024issueSO-241227-322MAIN 54 33.05-1,784.731013,338.10 Oct. 1, 2024: 54 @ 33.05
Nov. 24, 2024issueSO-241124-398MAIN 98 33.05-3,238.951555,122.83 Oct. 1, 2024: 98 @ 33.05
Nov. 18, 2024issueSO-241118-842MAIN 27 33.05-892.362538,361.78 Oct. 1, 2024: 27 @ 33.05
Nov. 14, 2024issueSO-241114-757MAIN 21 33.05-694.062809,254.14 Oct. 1, 2024: 21 @ 33.05
Oct. 30, 2024issueSO-241030-303MAIN 55 33.05-1,817.783019,948.20 Oct. 1, 2024: 55 @ 33.05
Oct. 17, 2024issueSO-241017-350MAIN 1 33.05-33.0535611,765.98 Oct. 1, 2024: 1 @ 33.05
Oct. 2, 2024issueSO-241002-224MAIN 163 33.05-5,387.2335711,799.03 Oct. 1, 2024: 163 @ 33.05
Oct. 1, 2024receiptPO-000005MAIN 520 33.0517,186.2652017,186.26