stocksense

Items / SWT-0015

Socket 5-pin Flex SWT-0015 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)289MAIN 289
Value (FIFO)1,530.63avg 5.30
ClassCX / FCV 0.22
Turnover5.4xlast issue 4 days ago
Days of cover75lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00150.053.6107161215Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 100.0Nov 24: 195.0Dec 24: 130.0Jan 25: 146.0Feb 25: 130.0Mar 25: 134.0Apr 25: 154.0May 25: 122.0Jun 25: 83.0Jul 25: 126.0Aug 25: 111.0Sep 25: 146.0Oct 25: 105.0Nov 25: 101.0Dec 25: 116.0Jan 26: 78.0Feb 26: 139.0Mar 26: 135.0Apr 26: 93.0May 26: 131.0Jun 26: 101.0Jul 26: 177.0Aug 26: 135.0Sep 26: 99.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.4375117.50 / 30.43753.860
Daily demand sdmonthly sd / sqrt(30.4375)25.82 / 5.5174.681
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 * 4.681^2 + 3.860^2 * 1.5^2)17.6
Reorder pointd * LT + safety stock3.860 * 7.0 + 17.644.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days44.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1409/yr, S = 45.00, h = 20%, price = 5.10760.0
Inventory positionon hand + on order289 + 0289

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

From qtyUnit costOrder qtyAnnual costFeasible
05.313467,849yes
7605.107607,654yes (chosen if cheapest)
1,5204.891,5207,668yes

MOQ 380, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 10, 2026289 / 3805.301,530.63

Movement ledger 130 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-431MAIN 129 5.26-678.972891,530.63 July 19, 2026: 24 @ 5.18; July 27, 2026: 1 @ 5.17; Sept. 5, 2026: 13 @ 5.18; Oct. 10, 2026: 91 @ 5.30
Oct. 10, 2026receiptPO-001865MAIN 380 5.302,012.594182,209.60
Oct. 7, 2026issueSO-261007-441MAIN 14 5.18-72.5938197.01 July 19, 2026: 14 @ 5.18
Sept. 30, 2026issueSO-260930-235MAIN 22 5.18-114.0752269.60 July 19, 2026: 22 @ 5.18
Sept. 5, 2026returnRMAMAIN 13 5.1867.4074383.67
Sept. 4, 2026issueSO-260904-849MAIN 78 5.18-404.4261316.26 July 19, 2026: 78 @ 5.18
Sept. 2, 2026issueSO-260902-848MAIN 12 5.18-62.22139720.69 July 19, 2026: 12 @ 5.18
Aug. 31, 2026issueSO-260831-800MAIN 10 5.18-51.85151782.90 July 19, 2026: 10 @ 5.18
Aug. 27, 2026issueSO-260827-444MAIN 27 5.18-139.99161834.75 July 19, 2026: 27 @ 5.18
Aug. 25, 2026issueSO-260825-204MAIN 10 5.18-51.85188974.75 July 19, 2026: 10 @ 5.18
Aug. 23, 2026issueSO-260823-581MAIN 31 5.18-160.731981,026.59 July 19, 2026: 31 @ 5.18
Aug. 20, 2026issueSO-260820-799MAIN 15 5.18-77.772291,187.33 July 19, 2026: 15 @ 5.18
Aug. 19, 2026issueSO-260819-988MAIN 28 5.18-145.182441,265.10 July 19, 2026: 28 @ 5.18
Aug. 12, 2026issueSO-260812-100MAIN 14 5.18-72.592721,410.28 July 19, 2026: 14 @ 5.18
July 31, 2026issueSO-260731-290MAIN 47 5.18-243.692861,482.87 July 19, 2026: 47 @ 5.18
July 27, 2026returnRMAMAIN 1 5.175.173331,726.56
July 26, 2026issueSO-260726-692MAIN 80 5.17-413.563321,721.39 April 5, 2026: 32 @ 5.15; July 19, 2026: 48 @ 5.18
July 23, 2026issueSO-260723-235MAIN 24 5.15-123.514122,134.94 April 5, 2026: 24 @ 5.15
July 19, 2026receiptPO-001656MAIN 380 5.181,970.264362,258.45
July 15, 2026issueSO-260715-117MAIN 2 5.15-10.2956288.19 April 5, 2026: 2 @ 5.15
July 11, 2026issueSO-260711-152MAIN 14 5.15-72.0558298.49 April 5, 2026: 14 @ 5.15
July 11, 2026issueSO-260711-152EAST 11 5.15-56.6172370.53 April 5, 2026: 11 @ 5.15
June 27, 2026issueSO-260627-959MAIN 32 5.15-164.6883427.14 April 5, 2026: 32 @ 5.15
June 25, 2026issueSO-260625-483MAIN 56 5.15-288.19115591.82 April 5, 2026: 56 @ 5.15
June 5, 2026issueSO-260605-337MAIN 13 5.15-66.90171880.02 April 5, 2026: 13 @ 5.15
May 23, 2026issueSO-260523-688MAIN 25 5.15-128.66184946.92 April 5, 2026: 25 @ 5.15
May 22, 2026issueSO-260522-794EAST 18 5.15-92.632091,075.58 April 5, 2026: 18 @ 5.15
May 19, 2026issueSO-260519-793EAST 51 5.15-262.462271,168.21 April 5, 2026: 51 @ 5.15
May 5, 2026issueSO-260505-243MAIN 37 5.15-190.412781,430.67 April 5, 2026: 37 @ 5.15
April 19, 2026issueSO-260419-172EAST 38 5.15-195.563151,621.08 April 5, 2026: 38 @ 5.15
April 11, 2026issueSO-260411-226MAIN 1 5.15-5.153531,816.64 April 5, 2026: 1 @ 5.15
April 10, 2026issueSO-260410-628MAIN 54 5.15-278.023541,821.79 Jan. 4, 2026: 28 @ 5.15; April 5, 2026: 26 @ 5.15
April 5, 2026transferTRFMAIN → EAST 118 warehouse transfer, no cost effect
April 5, 2026receiptPO-001387MAIN 380 5.151,955.594082,099.81
March 30, 2026issueSO-260330-875MAIN 30 5.15-154.5228144.22 Jan. 4, 2026: 30 @ 5.15
March 29, 2026issueSO-260329-626MAIN 50 5.15-257.5458298.74 Jan. 4, 2026: 50 @ 5.15
March 29, 2026issueSO-260329-626EAST 10 5.15-51.51108556.28 Jan. 4, 2026: 10 @ 5.15
March 26, 2026issueSO-260326-547EAST 3 5.15-15.45118607.78 Jan. 4, 2026: 3 @ 5.15
March 16, 2026issueSO-260316-668EAST 3 5.15-15.45121623.23 Jan. 4, 2026: 3 @ 5.15
March 8, 2026issueSO-260308-390EAST 5 5.15-25.75124638.69 Jan. 4, 2026: 5 @ 5.15
March 7, 2026issueSO-260307-123EAST 30 5.15-154.52129664.44 Jan. 4, 2026: 30 @ 5.15
March 4, 2026issueSO-260304-601MAIN 4 5.15-20.60159818.96 Jan. 4, 2026: 4 @ 5.15
Feb. 28, 2026issueSO-260228-389EAST 24 5.15-123.62163839.56 Jan. 4, 2026: 24 @ 5.15
Feb. 21, 2026issueSO-260221-753MAIN 9 5.15-46.36187963.18 Jan. 4, 2026: 9 @ 5.15
Feb. 15, 2026issueSO-260215-723MAIN 13 5.15-66.961961,009.54 Jan. 4, 2026: 13 @ 5.15
Feb. 14, 2026issueSO-260214-601MAIN 44 5.15-226.632091,076.50 Jan. 4, 2026: 44 @ 5.15
Feb. 1, 2026issueSO-260201-611EAST 49 5.15-252.382531,303.13 Jan. 4, 2026: 49 @ 5.15
Jan. 28, 2026issueSO-260128-699MAIN 48 5.15-247.233021,555.51 Jan. 4, 2026: 48 @ 5.15
Jan. 26, 2026issueSO-260126-984MAIN 1 5.15-5.153501,802.74 Jan. 4, 2026: 1 @ 5.15
Jan. 9, 2026issueSO-260109-287EAST 3 5.15-15.453511,807.90 Jan. 4, 2026: 3 @ 5.15
Jan. 6, 2026issueSO-260106-630EAST 4 5.15-20.603541,823.35 Jan. 4, 2026: 4 @ 5.15
Jan. 4, 2026issueSO-260104-578MAIN 22 5.15-113.323581,843.95 Jan. 4, 2026: 22 @ 5.15
Jan. 4, 2026transferTRFMAIN → EAST 131 warehouse transfer, no cost effect
Jan. 4, 2026receiptPO-001120MAIN 380 5.151,957.273801,957.27
Dec. 31, 2025issueSO-251231-113MAIN 56 5.02-280.9200.00 Sept. 16, 2025: 56 @ 5.02
Dec. 31, 2025issueSO-251231-113EAST 40 5.02-200.6656280.92 Sept. 16, 2025: 40 @ 5.02
Dec. 17, 2025issueSO-251217-750EAST 20 5.02-100.3396481.58 Sept. 16, 2025: 20 @ 5.02
Nov. 30, 2025issueSO-251130-289EAST 16 5.02-80.26116581.91 Sept. 16, 2025: 16 @ 5.02
Nov. 29, 2025issueSO-251129-404MAIN 4 5.02-20.07132662.18 Sept. 16, 2025: 4 @ 5.02
Nov. 21, 2025issueSO-251121-130EAST 9 5.02-45.15136682.24 Sept. 16, 2025: 9 @ 5.02
Nov. 3, 2025issueSO-251103-504MAIN 72 5.02-361.19145727.39 Sept. 16, 2025: 72 @ 5.02
Oct. 28, 2025issueSO-251028-603EAST 6 5.02-30.102171,088.58 Sept. 16, 2025: 6 @ 5.02
Oct. 26, 2025issueSO-251026-324MAIN 45 5.02-225.742231,118.68 Sept. 16, 2025: 45 @ 5.02
Oct. 15, 2025issueSO-251015-285MAIN 17 5.02-85.282681,344.42 Sept. 16, 2025: 17 @ 5.02
Oct. 5, 2025issueSO-251005-904MAIN 37 5.02-185.612851,429.70 Sept. 16, 2025: 37 @ 5.02
Sept. 28, 2025issueSO-250928-449MAIN 78 5.02-391.663221,615.31 May 21, 2025: 7 @ 5.03; June 27, 2025: 13 @ 5.03; Sept. 16, 2025: 58 @ 5.02
Sept. 24, 2025issueSO-250924-110MAIN 12 5.03-60.424002,006.97 May 21, 2025: 12 @ 5.03
Sept. 18, 2025issueSO-250918-690MAIN 5 5.03-25.174122,067.39 May 21, 2025: 5 @ 5.03
Sept. 16, 2025transferTRFMAIN → EAST 91 warehouse transfer, no cost effect
Sept. 16, 2025receiptPO-000848MAIN 380 5.021,906.274172,092.56
Sept. 10, 2025issueSO-250910-728MAIN 7 5.03-35.2437186.29 May 21, 2025: 7 @ 5.03
Sept. 9, 2025issueSO-250909-945MAIN 39 5.03-196.3644221.54 May 21, 2025: 39 @ 5.03
Sept. 8, 2025issueSO-250908-915MAIN 5 5.03-25.1783417.90 May 21, 2025: 5 @ 5.03
Aug. 22, 2025issueSO-250822-918MAIN 20 5.03-100.7088443.07 May 21, 2025: 20 @ 5.03
Aug. 18, 2025issueSO-250818-323MAIN 37 5.03-186.29108543.77 May 21, 2025: 37 @ 5.03
Aug. 16, 2025issueSO-250816-792MAIN 3 5.03-15.10145730.06 May 21, 2025: 3 @ 5.03
Aug. 14, 2025issueSO-250814-128MAIN 13 5.03-65.45148745.17 May 21, 2025: 13 @ 5.03
Aug. 8, 2025issueSO-250808-846MAIN 38 5.03-191.33161810.62 May 21, 2025: 38 @ 5.03
July 28, 2025issueSO-250728-898MAIN 8 5.03-40.281991,001.95 May 21, 2025: 8 @ 5.03
July 26, 2025issueSO-250726-509MAIN 18 5.03-90.632071,042.22 May 21, 2025: 18 @ 5.03
July 23, 2025issueSO-250723-714MAIN 44 5.03-221.542251,132.85 May 21, 2025: 44 @ 5.03
July 22, 2025issueSO-250722-492MAIN 9 5.03-45.312691,354.39 May 21, 2025: 9 @ 5.03
July 12, 2025issueSO-250712-843MAIN 31 5.03-156.082781,399.70 May 21, 2025: 31 @ 5.03
July 2, 2025issueSO-250702-838MAIN 16 5.03-80.563091,555.78 May 21, 2025: 16 @ 5.03
June 27, 2025returnRMAMAIN 13 5.0365.453251,636.34
June 19, 2025issueSO-250619-362MAIN 27 5.03-135.943121,570.89 May 21, 2025: 27 @ 5.03
June 2, 2025issueSO-250602-127MAIN 69 5.01-345.883391,706.83 March 4, 2025: 28 @ 4.98; May 21, 2025: 41 @ 5.03
May 25, 2025issueSO-250525-116MAIN 1 4.98-4.984082,052.71 March 4, 2025: 1 @ 4.98
May 21, 2025receiptPO-000559MAIN 380 5.031,913.264092,057.69
May 14, 2025issueSO-250514-369MAIN 57 4.98-283.8829144.43 March 4, 2025: 57 @ 4.98
May 12, 2025issueSO-250512-332MAIN 6 4.98-29.8886428.31 March 4, 2025: 6 @ 4.98
May 11, 2025issueSO-250511-586MAIN 21 4.98-104.5992458.20 March 4, 2025: 21 @ 4.98
May 9, 2025issueSO-250509-649MAIN 31 4.98-154.39113562.79 March 4, 2025: 31 @ 4.98
May 4, 2025issueSO-250504-212MAIN 6 4.98-29.88144717.18 March 4, 2025: 6 @ 4.98
April 29, 2025issueSO-250429-846MAIN 41 4.98-204.20150747.06 March 4, 2025: 41 @ 4.98
April 22, 2025issueSO-250422-882MAIN 69 4.98-343.65191951.26 March 4, 2025: 69 @ 4.98
April 21, 2025issueSO-250421-888MAIN 3 4.98-14.942601,294.90 March 4, 2025: 3 @ 4.98
April 12, 2025issueSO-250412-537MAIN 41 4.98-204.202631,309.85 March 4, 2025: 41 @ 4.98
March 22, 2025issueSO-250322-419MAIN 50 4.98-249.023041,514.04 March 4, 2025: 50 @ 4.98
March 17, 2025issueSO-250317-519MAIN 23 4.98-114.553541,763.06 March 4, 2025: 23 @ 4.98
March 14, 2025issueSO-250314-685MAIN 5 4.90-24.523771,877.61 Dec. 9, 2024: 2 @ 4.79; March 4, 2025: 3 @ 4.98
March 8, 2025issueSO-250308-599MAIN 41 4.79-196.473821,902.14 Dec. 9, 2024: 41 @ 4.79
March 4, 2025receiptPO-000312MAIN 380 4.981,892.554232,098.60
March 2, 2025issueSO-250302-213MAIN 15 4.79-71.8843206.05 Dec. 9, 2024: 15 @ 4.79
Feb. 25, 2025issueSO-250225-685MAIN 46 4.79-220.4358277.93 Dec. 9, 2024: 46 @ 4.79
Feb. 9, 2025issueSO-250209-816MAIN 84 4.79-402.52104498.36 Dec. 9, 2024: 84 @ 4.79
Jan. 27, 2025issueSO-250127-679MAIN 37 4.79-177.30188900.88 Dec. 9, 2024: 37 @ 4.79
Jan. 26, 2025issueSO-250126-797MAIN 5 4.79-23.962251,078.18 Dec. 9, 2024: 5 @ 4.79
Jan. 25, 2025issueSO-250125-407MAIN 81 4.79-388.142301,102.14 Dec. 9, 2024: 81 @ 4.79
Jan. 23, 2025issueSO-250123-986MAIN 11 4.79-52.713111,490.28 Dec. 9, 2024: 11 @ 4.79
Jan. 19, 2025issueSO-250119-643MAIN 12 4.79-57.503221,542.99 Dec. 9, 2024: 12 @ 4.79
Dec. 31, 2024issueSO-241231-261MAIN 16 4.79-76.673341,600.49 Dec. 9, 2024: 16 @ 4.79
Dec. 30, 2024issueSO-241230-435MAIN 42 4.86-204.293501,677.16 Oct. 1, 2024: 12 @ 5.04; Dec. 9, 2024: 30 @ 4.79
Dec. 29, 2024issueSO-241229-770MAIN 19 5.04-95.853921,881.46 Oct. 1, 2024: 19 @ 5.04
Dec. 20, 2024issueSO-241220-886MAIN 1 5.04-5.044111,977.30 Oct. 1, 2024: 1 @ 5.04
Dec. 12, 2024adjustmentCycle countMAIN -1 5.04-5.044121,982.35 Oct. 1, 2024: 1 @ 5.04
Dec. 9, 2024receiptPO-000087MAIN 380 4.791,820.924131,987.39
Dec. 4, 2024issueSO-241204-845MAIN 20 5.04-100.8933166.47 Oct. 1, 2024: 20 @ 5.04
Dec. 2, 2024issueSO-241202-468MAIN 32 5.04-161.4253267.36 Oct. 1, 2024: 32 @ 5.04
Nov. 27, 2024issueSO-241127-107MAIN 16 5.04-80.7185428.78 Oct. 1, 2024: 16 @ 5.04
Nov. 26, 2024issueSO-241126-433MAIN 44 5.04-221.96101509.49 Oct. 1, 2024: 44 @ 5.04
Nov. 22, 2024issueSO-241122-880MAIN 63 5.04-317.80145731.45 Oct. 1, 2024: 63 @ 5.04
Nov. 8, 2024issueSO-241108-572MAIN 68 5.04-343.032081,049.26 Oct. 1, 2024: 68 @ 5.04
Nov. 4, 2024issueSO-241104-947MAIN 4 5.04-20.182761,392.28 Oct. 1, 2024: 4 @ 5.04
Oct. 28, 2024issueSO-241028-235MAIN 6 5.04-30.272801,412.46 Oct. 1, 2024: 6 @ 5.04
Oct. 25, 2024issueSO-241025-590MAIN 23 5.04-116.022861,442.73 Oct. 1, 2024: 23 @ 5.04
Oct. 24, 2024issueSO-241024-572MAIN 9 5.04-45.403091,558.75 Oct. 1, 2024: 9 @ 5.04
Oct. 22, 2024issueSO-241022-245MAIN 14 5.04-70.623181,604.15 Oct. 1, 2024: 14 @ 5.04
Oct. 3, 2024issueSO-241003-601MAIN 48 5.04-242.143321,674.77 Oct. 1, 2024: 48 @ 5.04
Oct. 1, 2024receiptPO-000005MAIN 380 5.041,916.913801,916.91