stocksense

Items / SWT-0008

Socket 5-pin Pro SWT-0008 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)21MAIN 20, EAST 1
Value (FIFO)433.83avg 20.66
ClassBX / FCV 0.24
Turnover8.6xlast issue 1 days ago
Days of cover8lead time 7d

Reorder suggested: 220 units (position at or below reorder point: order EOQ), stockout risk medium.

Demand and forecast

Monthly demand and forecast for SWT-00080.034.468.8103138Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 78.0Nov 24: 63.0Dec 24: 79.0Jan 25: 63.0Feb 25: 68.0Mar 25: 84.0Apr 25: 80.0May 25: 96.0Jun 25: 53.0Jul 25: 78.0Aug 25: 47.0Sep 25: 74.0Oct 25: 86.0Nov 25: 87.0Dec 25: 57.0Jan 26: 75.0Feb 26: 125.0Mar 26: 54.0Apr 26: 72.0May 26: 104.0Jun 26: 70.0Jul 26: 112.0Aug 26: 78.0Sep 26: 93.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.437584.42 / 30.43752.773
Daily demand sdmonthly sd / sqrt(30.4375)20.50 / 5.5173.716
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(7.0 * 3.716^2 + 2.773^2 * 1.5^2)17.6
Reorder pointd * LT + safety stock2.773 * 7.0 + 17.636.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days36.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1012/yr, S = 45.00, h = 20%, price = 21.47145.7
Inventory positionon hand + on order21 + 021

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

From qtyUnit costOrder qtyAnnual costFeasible
021.4714622,360yes (chosen if cheapest)

MOQ 220, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 8, 202621 / 22020.66433.83

Movement ledger 129 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-684EAST 75 20.66-1,549.4121433.83 Aug. 8, 2026: 75 @ 20.66
Oct. 9, 2026issueSO-261009-878MAIN 2 20.66-41.32961,983.24 Aug. 8, 2026: 2 @ 20.66
Oct. 2, 2026issueSO-261002-586MAIN 6 20.66-123.95982,024.56 Aug. 8, 2026: 6 @ 20.66
Sept. 21, 2026issueSO-260921-984MAIN 18 20.66-371.861042,148.52 Aug. 8, 2026: 18 @ 20.66
Sept. 20, 2026issueSO-260920-918MAIN 3 20.66-61.981222,520.37 Aug. 8, 2026: 3 @ 20.66
Sept. 19, 2026issueSO-260919-713MAIN 4 20.66-82.641252,582.35 Aug. 8, 2026: 4 @ 20.66
Sept. 6, 2026issueSO-260906-881MAIN 57 20.66-1,177.551292,664.99 Aug. 8, 2026: 57 @ 20.66
Sept. 1, 2026issueSO-260901-582MAIN 11 20.66-227.251863,842.54 Aug. 8, 2026: 11 @ 20.66
Aug. 27, 2026issueSO-260827-856MAIN 55 21.15-1,163.051974,069.78 May 29, 2026: 32 @ 21.50; Aug. 8, 2026: 23 @ 20.66
Aug. 8, 2026transferTRFMAIN → EAST 44 warehouse transfer, no cost effect
Aug. 8, 2026receiptPO-001705MAIN 220 20.664,544.942525,232.83
Aug. 2, 2026issueSO-260802-565EAST 23 21.50-494.4332687.90 May 29, 2026: 23 @ 21.50
July 29, 2026issueSO-260729-437EAST 13 21.50-279.46551,182.32 May 29, 2026: 13 @ 21.50
July 29, 2026issueSO-260729-437MAIN 9 21.50-193.47681,461.78 May 29, 2026: 9 @ 21.50
July 27, 2026issueSO-260727-694MAIN 39 21.50-838.38771,655.25 May 29, 2026: 39 @ 21.50
July 21, 2026issueSO-260721-203MAIN 3 21.50-64.491162,493.63 May 29, 2026: 3 @ 21.50
July 18, 2026issueSO-260718-840EAST 7 21.50-150.481192,558.12 May 29, 2026: 7 @ 21.50
July 8, 2026issueSO-260708-609MAIN 34 21.50-730.891262,708.60 May 29, 2026: 34 @ 21.50
July 5, 2026issueSO-260705-324MAIN 7 21.50-150.481603,439.49 May 29, 2026: 7 @ 21.50
June 25, 2026issueSO-260625-735MAIN 7 21.50-150.481673,589.97 May 29, 2026: 7 @ 21.50
June 17, 2026issueSO-260617-124EAST 1 21.50-21.501743,740.44 May 29, 2026: 1 @ 21.50
June 8, 2026issueSO-260608-784MAIN 1 21.50-21.501753,761.94 May 29, 2026: 1 @ 21.50
June 4, 2026issueSO-260604-391MAIN 46 21.46-986.961763,783.44 Feb. 28, 2026: 2 @ 20.55; May 29, 2026: 44 @ 21.50
June 2, 2026issueSO-260602-182MAIN 15 20.55-308.252224,770.40 Feb. 28, 2026: 15 @ 20.55
May 29, 2026transferTRFMAIN → EAST 71 warehouse transfer, no cost effect
May 29, 2026receiptPO-001531MAIN 220 21.504,729.302375,078.64
May 27, 2026issueSO-260527-157MAIN 9 20.55-184.9517349.35 Feb. 28, 2026: 9 @ 20.55
May 22, 2026issueSO-260522-178MAIN 16 20.55-328.8026534.29 Feb. 28, 2026: 16 @ 20.55
May 18, 2026issueSO-260518-991MAIN 79 20.55-1,623.4342863.09 Feb. 28, 2026: 79 @ 20.55
April 29, 2026issueSO-260429-803MAIN 3 20.55-61.651212,486.53 Feb. 28, 2026: 3 @ 20.55
April 26, 2026issueSO-260426-170EAST 6 20.55-123.301242,548.18 Feb. 28, 2026: 6 @ 20.55
April 25, 2026issueSO-260425-716EAST 19 20.55-390.451302,671.47 Feb. 28, 2026: 19 @ 20.55
April 24, 2026issueSO-260424-466MAIN 19 20.55-390.451493,061.92 Feb. 28, 2026: 19 @ 20.55
April 6, 2026issueSO-260406-964EAST 4 20.55-82.201683,452.37 Feb. 28, 2026: 4 @ 20.55
April 4, 2026issueSO-260404-412MAIN 21 20.55-431.551723,534.57 Feb. 28, 2026: 21 @ 20.55
March 25, 2026issueSO-260325-117MAIN 1 20.55-20.551933,966.11 Feb. 28, 2026: 1 @ 20.55
March 22, 2026issueSO-260322-530MAIN 14 20.55-287.701943,986.66 Feb. 28, 2026: 14 @ 20.55
March 20, 2026issueSO-260320-510MAIN 13 20.56-267.282084,274.36 Dec. 29, 2025: 1 @ 20.68; Feb. 28, 2026: 12 @ 20.55
March 19, 2026issueSO-260319-809MAIN 4 20.68-82.712214,541.63 Dec. 29, 2025: 4 @ 20.68
March 11, 2026issueSO-260311-991EAST 10 20.68-206.782254,624.35 Dec. 29, 2025: 10 @ 20.68
March 4, 2026issueSO-260304-257EAST 12 20.68-248.142354,831.13 Dec. 29, 2025: 12 @ 20.68
Feb. 28, 2026transferTRFMAIN → EAST 56 warehouse transfer, no cost effect
Feb. 28, 2026receiptPO-001269MAIN 220 20.554,520.962475,079.28
Feb. 20, 2026issueSO-260220-651MAIN 74 20.68-1,530.2127558.32 Dec. 29, 2025: 74 @ 20.68
Feb. 9, 2026issueSO-260209-241MAIN 51 20.68-1,054.601012,088.53 Dec. 29, 2025: 51 @ 20.68
Jan. 26, 2026issueSO-260126-572MAIN 10 20.68-206.781523,143.13 Dec. 29, 2025: 10 @ 20.68
Jan. 18, 2026issueSO-260118-996MAIN 65 20.72-1,346.831623,349.92 Sept. 30, 2025: 3 @ 21.07; Nov. 22, 2025: 4 @ 21.07; Dec. 29, 2025: 58 @ 20.68
Dec. 29, 2025receiptPO-001101MAIN 220 20.684,549.272274,696.75
Dec. 26, 2025issueSO-251226-963MAIN 11 21.07-231.757147.48 Sept. 30, 2025: 11 @ 21.07
Dec. 22, 2025issueSO-251222-262MAIN 6 21.07-126.4118379.23 Sept. 30, 2025: 6 @ 21.07
Dec. 21, 2025issueSO-251221-984MAIN 16 21.07-337.1024505.64 Sept. 30, 2025: 16 @ 21.07
Dec. 16, 2025issueSO-251216-892MAIN 6 21.07-126.4140842.74 Sept. 30, 2025: 6 @ 21.07
Dec. 11, 2025issueSO-251211-367MAIN 5 21.07-105.3446969.15 Sept. 30, 2025: 5 @ 21.07
Dec. 4, 2025issueSO-251204-237MAIN 13 21.07-273.89511,074.49 Sept. 30, 2025: 13 @ 21.07
Nov. 22, 2025returnRMAMAIN 4 21.0784.27641,348.38
Nov. 18, 2025issueSO-251118-389MAIN 21 21.07-442.44601,264.11 Sept. 30, 2025: 21 @ 21.07
Nov. 14, 2025issueSO-251114-330MAIN 8 21.07-168.55811,706.55 Sept. 30, 2025: 8 @ 21.07
Nov. 9, 2025issueSO-251109-178MAIN 4 21.07-84.27891,875.10 Sept. 30, 2025: 4 @ 21.07
Nov. 3, 2025issueSO-251103-640MAIN 30 21.07-632.06931,959.37 Sept. 30, 2025: 30 @ 21.07
Nov. 3, 2025issueSO-251103-640EAST 28 21.07-589.921232,591.43 Sept. 30, 2025: 28 @ 21.07
Oct. 30, 2025issueSO-251030-728EAST 45 21.07-948.081513,181.34 Sept. 30, 2025: 45 @ 21.07
Oct. 25, 2025issueSO-251025-842MAIN 20 21.07-421.371964,129.43 Sept. 30, 2025: 20 @ 21.07
Oct. 22, 2025issueSO-251022-485MAIN 16 20.94-335.032164,550.80 June 13, 2025: 12 @ 20.90; Sept. 30, 2025: 4 @ 21.07
Oct. 10, 2025issueSO-251010-738EAST 5 20.90-104.482324,885.83 June 13, 2025: 5 @ 20.90
Sept. 30, 2025transferTRFMAIN → EAST 61 warehouse transfer, no cost effect
Sept. 30, 2025receiptPO-000889MAIN 220 21.074,635.072374,990.31
Sept. 25, 2025issueSO-250925-592EAST 2 20.90-41.7917355.24 June 13, 2025: 2 @ 20.90
Sept. 25, 2025issueSO-250925-592MAIN 15 20.90-313.4519397.04 June 13, 2025: 15 @ 20.90
Sept. 6, 2025issueSO-250906-224MAIN 19 20.90-397.0434710.48 June 13, 2025: 19 @ 20.90
Sept. 1, 2025issueSO-250901-439MAIN 38 20.90-794.07531,107.52 June 13, 2025: 38 @ 20.90
Aug. 25, 2025issueSO-250825-657EAST 10 20.90-208.97911,901.59 June 13, 2025: 10 @ 20.90
Aug. 21, 2025issueSO-250821-780MAIN 23 20.90-480.621012,110.56 June 13, 2025: 23 @ 20.90
Aug. 17, 2025issueSO-250817-998MAIN 13 20.90-271.661242,591.18 June 13, 2025: 13 @ 20.90
Aug. 16, 2025issueSO-250816-528EAST 1 20.90-20.901372,862.83 June 13, 2025: 1 @ 20.90
July 24, 2025issueSO-250724-581MAIN 22 20.90-459.731382,883.73 June 13, 2025: 22 @ 20.90
July 23, 2025issueSO-250723-350MAIN 7 20.90-146.281603,343.46 June 13, 2025: 7 @ 20.90
July 21, 2025issueSO-250721-806EAST 11 20.90-229.861673,489.73 June 13, 2025: 11 @ 20.90
July 19, 2025issueSO-250719-443EAST 10 20.90-208.971783,719.59 June 13, 2025: 10 @ 20.90
July 17, 2025issueSO-250717-360MAIN 15 20.90-313.451883,928.56 June 13, 2025: 15 @ 20.90
July 6, 2025issueSO-250706-987MAIN 10 20.90-208.972034,242.01 June 13, 2025: 10 @ 20.90
July 1, 2025issueSO-250701-372MAIN 3 20.90-62.692134,450.98 June 13, 2025: 3 @ 20.90
June 24, 2025issueSO-250624-800EAST 2 20.90-41.792164,513.67 June 13, 2025: 2 @ 20.90
June 18, 2025issueSO-250618-820MAIN 6 20.75-124.482184,555.46 June 12, 2025: 4 @ 20.67; June 13, 2025: 2 @ 20.90
June 13, 2025transferTRFMAIN → EAST 53 warehouse transfer, no cost effect
June 13, 2025receiptPO-000631MAIN 220 20.904,597.252244,679.94
June 12, 2025returnRMAMAIN 4 20.6782.69482.69
June 10, 2025issueSO-250610-918MAIN 19 20.67-392.7800.00 March 26, 2025: 19 @ 20.67
June 9, 2025issueSO-250609-311MAIN 13 20.67-268.7419392.78 March 26, 2025: 13 @ 20.67
June 8, 2025issueSO-250608-101MAIN 8 20.67-165.3832661.52 March 26, 2025: 8 @ 20.67
June 5, 2025issueSO-250605-824MAIN 9 20.67-186.0540826.90 March 26, 2025: 9 @ 20.67
May 24, 2025issueSO-250524-766MAIN 58 20.67-1,199.00491,012.95 March 26, 2025: 58 @ 20.67
May 19, 2025issueSO-250519-936MAIN 31 20.67-640.851072,211.96 March 26, 2025: 31 @ 20.67
May 7, 2025issueSO-250507-850MAIN 1 20.67-20.671382,852.80 March 26, 2025: 1 @ 20.67
May 7, 2025issueSO-250507-850EAST 5 20.67-103.361392,873.48 March 26, 2025: 5 @ 20.67
May 6, 2025issueSO-250506-160MAIN 1 20.67-20.671442,976.84 March 26, 2025: 1 @ 20.67
April 29, 2025issueSO-250429-982EAST 64 20.67-1,323.041452,997.51 March 26, 2025: 64 @ 20.67
April 20, 2025issueSO-250420-454MAIN 5 20.67-103.362094,320.55 March 26, 2025: 5 @ 20.67
April 13, 2025issueSO-250413-575MAIN 4 20.67-82.692144,423.92 March 26, 2025: 4 @ 20.67
April 12, 2025issueSO-250412-901MAIN 7 20.05-140.322184,506.60 Jan. 4, 2025: 5 @ 19.80; March 26, 2025: 2 @ 20.67
March 26, 2025transferTRFMAIN → EAST 69 warehouse transfer, no cost effect
March 26, 2025receiptPO-000383MAIN 220 20.674,547.952254,646.93
March 21, 2025issueSO-250321-705MAIN 42 19.80-831.41598.98 Jan. 4, 2025: 42 @ 19.80
March 16, 2025issueSO-250316-633MAIN 42 19.80-831.4147930.38 Jan. 4, 2025: 42 @ 19.80
Feb. 28, 2025issueSO-250228-700MAIN 15 19.80-296.93891,761.79 Jan. 4, 2025: 15 @ 19.80
Feb. 25, 2025issueSO-250225-969MAIN 11 19.80-217.751042,058.72 Jan. 4, 2025: 11 @ 19.80
Feb. 22, 2025issueSO-250222-874MAIN 32 19.80-633.451152,276.47 Jan. 4, 2025: 32 @ 19.80
Feb. 13, 2025issueSO-250213-551MAIN 10 19.80-197.951472,909.92 Jan. 4, 2025: 10 @ 19.80
Jan. 13, 2025issueSO-250113-677MAIN 22 19.80-435.501573,107.88 Jan. 4, 2025: 22 @ 19.80
Jan. 10, 2025issueSO-250110-147MAIN 10 19.80-197.951793,543.38 Jan. 4, 2025: 10 @ 19.80
Jan. 8, 2025issueSO-250108-328MAIN 16 19.80-316.731893,741.33 Jan. 4, 2025: 16 @ 19.80
Jan. 6, 2025issueSO-250106-303MAIN 15 19.80-296.932054,058.06 Jan. 4, 2025: 15 @ 19.80
Jan. 4, 2025receiptPO-000161MAIN 220 19.804,354.992204,354.99
Dec. 30, 2024issueSO-241230-939MAIN 27 20.40-550.7100.00 Oct. 1, 2024: 27 @ 20.40
Dec. 26, 2024issueSO-241226-995MAIN 34 20.40-693.4827550.71 Oct. 1, 2024: 34 @ 20.40
Dec. 14, 2024issueSO-241214-644MAIN 14 20.40-285.55611,244.19 Oct. 1, 2024: 14 @ 20.40
Dec. 1, 2024issueSO-241201-182MAIN 4 20.40-81.59751,529.74 Oct. 1, 2024: 4 @ 20.40
Nov. 30, 2024issueSO-241130-849MAIN 9 20.40-183.57791,611.32 Oct. 1, 2024: 9 @ 20.40
Nov. 28, 2024issueSO-241128-402MAIN 10 20.40-203.96881,794.89 Oct. 1, 2024: 10 @ 20.40
Nov. 21, 2024issueSO-241121-354MAIN 1 20.40-20.40981,998.86 Oct. 1, 2024: 1 @ 20.40
Nov. 17, 2024issueSO-241117-844MAIN 28 20.40-571.10992,019.25 Oct. 1, 2024: 28 @ 20.40
Nov. 4, 2024issueSO-241104-147MAIN 14 20.40-285.551272,590.36 Oct. 1, 2024: 14 @ 20.40
Nov. 2, 2024issueSO-241102-998MAIN 1 20.40-20.401412,875.91 Oct. 1, 2024: 1 @ 20.40
Oct. 31, 2024issueSO-241031-666MAIN 29 20.40-591.501422,896.30 Oct. 1, 2024: 29 @ 20.40
Oct. 23, 2024issueSO-241023-295MAIN 16 20.40-326.341713,487.80 Oct. 1, 2024: 16 @ 20.40
Oct. 21, 2024issueSO-241021-427MAIN 25 20.40-509.911873,814.15 Oct. 1, 2024: 25 @ 20.40
Oct. 19, 2024issueSO-241019-262MAIN 2 20.40-40.792124,324.06 Oct. 1, 2024: 2 @ 20.40
Oct. 7, 2024issueSO-241007-884MAIN 2 20.40-40.792144,364.85 Oct. 1, 2024: 2 @ 20.40
Oct. 4, 2024issueSO-241004-914MAIN 4 20.40-81.592164,405.64 Oct. 1, 2024: 4 @ 20.40
Oct. 1, 2024receiptPO-000005MAIN 220 20.404,487.232204,487.23