stocksense

Items / SWT-0017

Socket 5-pin Nova SWT-0017 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)162MAIN 162
Value (FIFO)1,902.25avg 11.74
ClassCX / FCV 0.20
Turnover5.1xlast issue 0 days ago
Days of cover67lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00170.028.957.886.6116Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 65.0Nov 24: 70.0Dec 24: 92.0Jan 25: 55.0Feb 25: 87.0Mar 25: 82.0Apr 25: 57.0May 25: 67.0Jun 25: 77.0Jul 25: 76.0Aug 25: 73.0Sep 25: 58.0Oct 25: 67.0Nov 25: 92.0Dec 25: 82.0Jan 26: 65.0Feb 26: 105.0Mar 26: 50.0Apr 26: 81.0May 26: 59.0Jun 26: 69.0Jul 26: 70.0Aug 26: 61.0Sep 26: 87.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.437574.00 / 30.43752.431
Daily demand sdmonthly sd / sqrt(30.4375)15.02 / 5.5172.723
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 * 2.723^2 + 2.431^2 * 1.5^2)10.4
Reorder pointd * LT + safety stock2.431 * 7.0 + 10.427.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days27.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 887/yr, S = 45.00, h = 20%, price = 10.88880.0
Inventory positionon hand + on order162 + 0162

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

From qtyUnit costOrder qtyAnnual costFeasible
011.8318410,933yes
44011.3644010,668yes
88010.8888010,661yes (chosen if cheapest)

MOQ 220, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 7, 2026162 / 22011.741,902.25

Movement ledger 138 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-999MAIN 32 11.74-375.751621,902.25 Oct. 7, 2026: 32 @ 11.74
Oct. 14, 2026issueSO-261014-623MAIN 12 11.74-140.911942,278.01 Oct. 7, 2026: 12 @ 11.74
Oct. 12, 2026issueSO-261012-610MAIN 14 11.74-164.392062,418.91 Oct. 7, 2026: 14 @ 11.74
Oct. 7, 2026receiptPO-001857MAIN 220 11.742,583.312202,583.31
Oct. 2, 2026issueSO-261002-715MAIN 11 11.93-131.1800.00 June 27, 2026: 2 @ 11.60; Aug. 28, 2026: 9 @ 12.00
Sept. 30, 2026issueSO-260930-254MAIN 78 11.98-934.5411131.18 June 24, 2026: 75 @ 12.00; June 27, 2026: 3 @ 11.60
Sept. 26, 2026issueSO-260926-982MAIN 3 12.00-35.99891,065.72 June 24, 2026: 3 @ 12.00
Sept. 16, 2026issueSO-260916-949MAIN 6 12.00-71.98921,101.71 June 24, 2026: 6 @ 12.00
Aug. 29, 2026issueSO-260829-734MAIN 33 12.00-395.88981,173.69 June 24, 2026: 33 @ 12.00
Aug. 28, 2026returnRMAMAIN 9 12.00107.971311,569.57
Aug. 26, 2026issueSO-260826-675MAIN 19 12.00-227.931221,461.60 June 24, 2026: 19 @ 12.00
Aug. 8, 2026issueSO-260808-766MAIN 18 12.00-215.941411,689.53 June 24, 2026: 18 @ 12.00
July 27, 2026issueSO-260727-455MAIN 1 12.00-12.001591,905.47 June 24, 2026: 1 @ 12.00
July 25, 2026issueSO-260725-991MAIN 5 12.00-59.981601,917.46 June 24, 2026: 5 @ 12.00
July 9, 2026issueSO-260709-242MAIN 2 12.00-23.991651,977.45 June 24, 2026: 2 @ 12.00
July 6, 2026issueSO-260706-571MAIN 27 12.00-323.901672,001.44 June 24, 2026: 27 @ 12.00
July 5, 2026issueSO-260705-205MAIN 13 12.00-155.951942,325.34 June 24, 2026: 13 @ 12.00
July 5, 2026issueSO-260705-205EAST 2 12.00-23.992072,481.29 June 24, 2026: 2 @ 12.00
July 4, 2026issueSO-260704-359EAST 20 11.92-238.362092,505.29 March 29, 2026: 4 @ 11.60; June 24, 2026: 16 @ 12.00
June 27, 2026returnRMAMAIN 5 11.6058.022292,743.65
June 24, 2026issueSO-260624-504MAIN 29 11.60-336.532242,685.63 March 29, 2026: 29 @ 11.60
June 24, 2026receiptPO-001601MAIN 220 12.002,639.212533,022.15
June 19, 2026issueSO-260619-498MAIN 1 11.60-11.6033382.95 March 29, 2026: 1 @ 11.60
June 12, 2026issueSO-260612-158MAIN 10 11.60-116.0434394.55 March 29, 2026: 10 @ 11.60
June 10, 2026issueSO-260610-958EAST 19 11.60-220.4844510.59 March 29, 2026: 19 @ 11.60
June 4, 2026issueSO-260604-798EAST 8 11.60-92.8463731.08 March 29, 2026: 8 @ 11.60
June 3, 2026issueSO-260603-537MAIN 4 11.60-46.4271823.91 March 29, 2026: 4 @ 11.60
June 2, 2026issueSO-260602-327MAIN 3 11.60-34.8175870.33 March 29, 2026: 3 @ 11.60
May 31, 2026issueSO-260531-464MAIN 38 11.60-440.9778905.14 March 29, 2026: 38 @ 11.60
May 23, 2026adjustmentCycle countMAIN -2 11.60-23.211161,346.11 March 29, 2026: 2 @ 11.60
May 19, 2026issueSO-260519-236MAIN 3 11.60-34.811181,369.32 March 29, 2026: 3 @ 11.60
May 4, 2026issueSO-260504-388MAIN 13 11.60-150.861211,404.13 March 29, 2026: 13 @ 11.60
May 3, 2026issueSO-260503-891EAST 5 11.60-58.021341,554.99 March 29, 2026: 5 @ 11.60
April 6, 2026issueSO-260406-597MAIN 49 11.60-568.621391,613.01 March 29, 2026: 49 @ 11.60
April 5, 2026issueSO-260405-415MAIN 32 11.60-371.341882,181.63 March 29, 2026: 32 @ 11.60
March 29, 2026transferTRFMAIN → EAST 54 warehouse transfer, no cost effect
March 29, 2026receiptPO-001365MAIN 220 11.602,552.972202,552.97
March 23, 2026issueSO-260323-401MAIN 11 11.16-122.8100.00 Jan. 2, 2026: 11 @ 11.16
March 22, 2026issueSO-260322-315MAIN 37 11.16-413.1011122.81 Jan. 2, 2026: 37 @ 11.16
March 17, 2026issueSO-260317-815MAIN 2 11.16-22.3348535.91 Jan. 2, 2026: 2 @ 11.16
Feb. 21, 2026issueSO-260221-940MAIN 23 11.16-256.7950558.24 Jan. 2, 2026: 23 @ 11.16
Feb. 20, 2026issueSO-260220-298MAIN 15 11.16-167.4773815.03 Jan. 2, 2026: 15 @ 11.16
Feb. 16, 2026issueSO-260216-752MAIN 30 11.16-334.9488982.50 Jan. 2, 2026: 30 @ 11.16
Feb. 13, 2026issueSO-260213-319MAIN 3 11.16-33.491181,317.45 Jan. 2, 2026: 3 @ 11.16
Feb. 9, 2026issueSO-260209-832MAIN 16 11.16-178.641211,350.94 Jan. 2, 2026: 16 @ 11.16
Feb. 7, 2026issueSO-260207-483MAIN 18 11.16-200.971371,529.58 Jan. 2, 2026: 18 @ 11.16
Jan. 27, 2026issueSO-260127-143MAIN 24 11.16-267.961551,730.54 Jan. 2, 2026: 24 @ 11.16
Jan. 26, 2026issueSO-260126-673MAIN 2 11.16-22.331791,998.50 Jan. 2, 2026: 2 @ 11.16
Jan. 20, 2026issueSO-260120-748MAIN 5 11.16-55.821812,020.83 Jan. 2, 2026: 5 @ 11.16
Jan. 18, 2026issueSO-260118-285MAIN 1 11.16-11.161862,076.65 Jan. 2, 2026: 1 @ 11.16
Jan. 15, 2026issueSO-260115-120MAIN 4 11.16-44.661872,087.82 Jan. 2, 2026: 4 @ 11.16
Jan. 14, 2026issueSO-260114-970MAIN 4 11.16-44.661912,132.48 Jan. 2, 2026: 4 @ 11.16
Jan. 6, 2026issueSO-260106-827MAIN 25 11.16-279.121952,177.14 Jan. 2, 2026: 25 @ 11.16
Jan. 2, 2026receiptPO-001113MAIN 220 11.162,456.262202,456.26
Dec. 27, 2025issueSO-251227-180MAIN 56 11.25-629.9900.00 Oct. 1, 2025: 56 @ 11.25
Dec. 26, 2025issueSO-251226-306MAIN 4 11.25-45.0056629.99 Oct. 1, 2025: 4 @ 11.25
Dec. 22, 2025issueSO-251222-415MAIN 4 11.25-45.0060674.99 Oct. 1, 2025: 4 @ 11.25
Dec. 19, 2025issueSO-251219-540MAIN 1 11.25-11.2564719.99 Oct. 1, 2025: 1 @ 11.25
Dec. 7, 2025issueSO-251207-178MAIN 4 11.25-45.0065731.24 Oct. 1, 2025: 4 @ 11.25
Dec. 6, 2025issueSO-251206-648MAIN 13 11.25-146.2569776.24 Oct. 1, 2025: 13 @ 11.25
Nov. 26, 2025issueSO-251126-824MAIN 3 11.25-33.7582922.49 Oct. 1, 2025: 3 @ 11.25
Nov. 19, 2025issueSO-251119-418MAIN 20 11.25-225.0085956.24 Oct. 1, 2025: 20 @ 11.25
Nov. 15, 2025issueSO-251115-969MAIN 59 11.25-663.741051,181.24 Oct. 1, 2025: 59 @ 11.25
Nov. 14, 2025issueSO-251114-479MAIN 10 11.25-112.501641,844.98 Oct. 1, 2025: 10 @ 11.25
Oct. 26, 2025issueSO-251026-557MAIN 36 11.25-405.001741,957.48 Oct. 1, 2025: 36 @ 11.25
Oct. 25, 2025issueSO-251025-491MAIN 1 11.25-11.252102,362.48 Oct. 1, 2025: 1 @ 11.25
Oct. 13, 2025issueSO-251013-697MAIN 8 11.25-90.002112,373.73 Oct. 1, 2025: 8 @ 11.25
Oct. 9, 2025issueSO-251009-946MAIN 2 11.38-22.762192,463.73 June 23, 2025: 1 @ 11.51; Oct. 1, 2025: 1 @ 11.25
Oct. 2, 2025issueSO-251002-234MAIN 20 11.51-230.132212,486.48 June 23, 2025: 20 @ 11.51
Oct. 1, 2025receiptPO-000892MAIN 220 11.252,474.982412,716.61
Sept. 30, 2025issueSO-250930-163MAIN 10 11.51-115.0621241.64 June 23, 2025: 10 @ 11.51
Sept. 24, 2025issueSO-250924-911MAIN 4 11.51-46.0331356.70 June 23, 2025: 4 @ 11.51
Sept. 20, 2025issueSO-250920-534MAIN 26 11.51-299.1735402.73 June 23, 2025: 26 @ 11.51
Sept. 8, 2025issueSO-250908-802MAIN 18 11.51-207.1261701.90 June 23, 2025: 18 @ 11.51
Aug. 24, 2025issueSO-250824-506MAIN 15 11.51-172.6079909.01 June 23, 2025: 15 @ 11.51
Aug. 8, 2025issueSO-250808-479MAIN 58 11.51-667.38941,081.61 June 23, 2025: 58 @ 11.51
July 25, 2025issueSO-250725-122MAIN 2 11.51-23.011521,748.99 June 23, 2025: 2 @ 11.51
July 25, 2025issueSO-250725-122EAST 39 11.51-448.751541,772.00 June 23, 2025: 39 @ 11.51
July 18, 2025issueSO-250718-232EAST 2 11.51-23.011932,220.75 June 23, 2025: 2 @ 11.51
July 5, 2025issueSO-250705-284EAST 17 11.51-195.611952,243.77 June 23, 2025: 17 @ 11.51
July 1, 2025issueSO-250701-445MAIN 16 11.31-181.022122,439.38 March 18, 2025: 8 @ 11.12; June 23, 2025: 8 @ 11.51
June 24, 2025issueSO-250624-437MAIN 20 11.12-222.432282,620.40 March 18, 2025: 20 @ 11.12
June 23, 2025transferTRFMAIN → EAST 58 warehouse transfer, no cost effect
June 23, 2025receiptPO-000661MAIN 220 11.512,531.432482,842.83
June 14, 2025issueSO-250614-466MAIN 44 11.12-489.3528311.40 March 18, 2025: 44 @ 11.12
June 13, 2025issueSO-250613-113MAIN 13 11.12-144.5872800.76 March 18, 2025: 13 @ 11.12
May 31, 2025issueSO-250531-917MAIN 20 11.12-222.4385945.34 March 18, 2025: 20 @ 11.12
May 27, 2025issueSO-250527-241MAIN 4 11.12-44.491051,167.77 March 18, 2025: 4 @ 11.12
May 21, 2025issueSO-250521-644MAIN 10 11.12-111.221091,212.25 March 18, 2025: 10 @ 11.12
May 17, 2025issueSO-250517-250MAIN 18 11.12-200.191191,323.47 March 18, 2025: 18 @ 11.12
May 5, 2025issueSO-250505-667MAIN 1 11.12-11.121371,523.66 March 18, 2025: 1 @ 11.12
May 1, 2025issueSO-250501-186MAIN 14 11.12-155.701381,534.78 March 18, 2025: 14 @ 11.12
April 30, 2025issueSO-250430-374MAIN 19 11.12-211.311521,690.48 March 18, 2025: 19 @ 11.12
April 28, 2025issueSO-250428-349MAIN 6 11.12-66.731711,901.79 March 18, 2025: 6 @ 11.12
April 21, 2025issueSO-250421-605MAIN 21 11.12-233.551771,968.52 March 18, 2025: 21 @ 11.12
April 19, 2025issueSO-250419-612MAIN 3 11.12-33.361982,202.08 March 18, 2025: 3 @ 11.12
April 15, 2025issueSO-250415-367MAIN 6 11.12-66.732012,235.44 March 18, 2025: 6 @ 11.12
April 2, 2025issueSO-250402-377MAIN 2 11.12-22.242072,302.17 March 18, 2025: 2 @ 11.12
March 25, 2025issueSO-250325-393MAIN 20 11.00-220.042092,324.41 March 6, 2025: 9 @ 10.86; March 18, 2025: 11 @ 11.12
March 22, 2025issueSO-250322-206MAIN 15 10.86-162.832292,544.45 Dec. 30, 2024: 11 @ 10.86; March 6, 2025: 4 @ 10.86
March 18, 2025issueSO-250318-471MAIN 8 10.86-86.842442,707.28 Dec. 30, 2024: 8 @ 10.86
March 18, 2025receiptPO-000353MAIN 220 11.122,446.752522,794.12
March 13, 2025issueSO-250313-135MAIN 25 10.86-271.3832347.37 Dec. 30, 2024: 25 @ 10.86
March 6, 2025returnRMAMAIN 13 10.86141.1257618.76
March 4, 2025issueSO-250304-833MAIN 24 10.86-260.5344477.64 Dec. 30, 2024: 24 @ 10.86
March 1, 2025issueSO-250301-202MAIN 3 10.86-32.5768738.17 Dec. 30, 2024: 3 @ 10.86
Feb. 27, 2025issueSO-250227-704MAIN 27 10.86-293.1071770.73 Dec. 30, 2024: 27 @ 10.86
Feb. 26, 2025issueSO-250226-286MAIN 25 10.86-271.38981,063.83 Dec. 30, 2024: 25 @ 10.86
Feb. 14, 2025issueSO-250214-429MAIN 4 10.86-43.421231,335.21 Dec. 30, 2024: 4 @ 10.86
Feb. 12, 2025issueSO-250212-196MAIN 19 10.86-206.251271,378.64 Dec. 30, 2024: 19 @ 10.86
Feb. 3, 2025issueSO-250203-355MAIN 12 10.86-130.261461,584.89 Dec. 30, 2024: 12 @ 10.86
Jan. 31, 2025issueSO-250131-638MAIN 15 10.86-162.831581,715.15 Dec. 30, 2024: 15 @ 10.86
Jan. 24, 2025issueSO-250124-588MAIN 18 10.86-195.401731,877.98 Dec. 30, 2024: 18 @ 10.86
Jan. 23, 2025issueSO-250123-475MAIN 4 10.86-43.421912,073.38 Dec. 30, 2024: 4 @ 10.86
Jan. 10, 2025issueSO-250110-666MAIN 12 10.86-130.261952,116.80 Dec. 30, 2024: 12 @ 10.86
Jan. 9, 2025issueSO-250109-235EAST 6 10.86-65.132072,247.07 Dec. 30, 2024: 6 @ 10.86
Dec. 31, 2024issueSO-241231-716MAIN 13 11.03-143.422132,312.20 Oct. 1, 2024: 2 @ 11.24; Nov. 6, 2024: 4 @ 11.24; Dec. 30, 2024: 7 @ 10.86
Dec. 30, 2024receiptPO-000152MAIN 220 10.862,388.192262,455.62
Dec. 28, 2024issueSO-241228-477EAST 4 11.24-44.95667.43 Oct. 1, 2024: 4 @ 11.24
Dec. 24, 2024issueSO-241224-486EAST 6 11.24-67.4310112.38 Oct. 1, 2024: 6 @ 11.24
Dec. 24, 2024issueSO-241224-486MAIN 64 11.24-719.2616179.82 Oct. 1, 2024: 64 @ 11.24
Dec. 15, 2024issueSO-241215-635EAST 2 11.24-22.4880899.08 Oct. 1, 2024: 2 @ 11.24
Dec. 8, 2024issueSO-241208-503EAST 1 11.24-11.2482921.56 Oct. 1, 2024: 1 @ 11.24
Dec. 3, 2024issueSO-241203-463EAST 2 11.24-22.4883932.80 Oct. 1, 2024: 2 @ 11.24
Nov. 29, 2024issueSO-241129-177MAIN 18 11.24-202.2985955.27 Oct. 1, 2024: 18 @ 11.24
Nov. 27, 2024issueSO-241127-262EAST 1 11.24-11.241031,157.57 Oct. 1, 2024: 1 @ 11.24
Nov. 17, 2024issueSO-241117-601MAIN 15 11.24-168.581041,168.80 Oct. 1, 2024: 15 @ 11.24
Nov. 13, 2024issueSO-241113-824MAIN 17 11.24-191.051191,337.38 Oct. 1, 2024: 17 @ 11.24
Nov. 11, 2024issueSO-241111-788EAST 20 11.24-224.771361,528.44 Oct. 1, 2024: 20 @ 11.24
Nov. 6, 2024returnRMAMAIN 4 11.2444.951561,753.21
Nov. 5, 2024issueSO-241105-184MAIN 3 11.24-33.721521,708.25 Oct. 1, 2024: 3 @ 11.24
Oct. 29, 2024issueSO-241029-868MAIN 23 11.24-258.491551,741.97 Oct. 1, 2024: 23 @ 11.24
Oct. 21, 2024issueSO-241021-926MAIN 8 11.24-89.911782,000.45 Oct. 1, 2024: 8 @ 11.24
Oct. 20, 2024issueSO-241020-692EAST 18 11.24-202.291862,090.36 Oct. 1, 2024: 18 @ 11.24
Oct. 8, 2024issueSO-241008-192MAIN 14 11.24-157.342042,292.65 Oct. 1, 2024: 14 @ 11.24
Oct. 5, 2024issueSO-241005-725MAIN 2 11.24-22.482182,449.99 Oct. 1, 2024: 2 @ 11.24
Oct. 1, 2024transferTRFMAIN → EAST 60 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 220 11.242,472.472202,472.47