stocksense

Items / SWT-0016

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

On hand (EA)350MAIN 305, EAST 45
Value (FIFO)11,977.91avg 34.22
ClassAX / FCV 0.21
Turnover4.8xlast issue 8 days ago
Days of cover74lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00160.061.1122183244Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 222.0Nov 24: 120.0Dec 24: 93.0Jan 25: 95.0Feb 25: 138.0Mar 25: 144.0Apr 25: 127.0May 25: 126.0Jun 25: 160.0Jul 25: 203.0Aug 25: 118.0Sep 25: 123.0Oct 25: 139.0Nov 25: 148.0Dec 25: 141.0Jan 26: 149.0Feb 26: 208.0Mar 26: 124.0Apr 26: 105.0May 26: 125.0Jun 26: 200.0Jul 26: 131.0Aug 26: 113.0Sep 26: 141.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.4375143.67 / 30.43754.720
Daily demand sdmonthly sd / sqrt(30.4375)29.90 / 5.5175.419
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 * 5.419^2 + 4.720^2 * 1.5^2)33.0
Reorder pointd * LT + safety stock4.720 * 7.0 + 33.065.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days65.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1723/yr, S = 45.00, h = 20%, price = 32.16860.0
Inventory positionon hand + on order350 + 0350

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

From qtyUnit costOrder qtyAnnual costFeasible
033.5015258,734yes
86032.1686058,262yes (chosen if cheapest)
1,72030.821,72058,443yes

MOQ 430, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 21, 2026350 / 43034.2211,977.91

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 8, 2026issueSO-261008-397MAIN 125 33.82-4,228.0635011,977.91 June 22, 2026: 45 @ 33.12; Sept. 21, 2026: 80 @ 34.22
Sept. 21, 2026receiptPO-001818MAIN 430 34.2214,715.7247516,205.97
Sept. 15, 2026issueSO-260915-819EAST 14 33.12-463.64451,490.26 June 22, 2026: 14 @ 33.12
Sept. 15, 2026issueSO-260915-819MAIN 127 33.12-4,205.83591,953.89 June 22, 2026: 127 @ 33.12
Aug. 30, 2026issueSO-260830-623MAIN 6 33.12-198.701866,159.72 June 22, 2026: 6 @ 33.12
Aug. 29, 2026issueSO-260829-822EAST 13 33.12-430.521926,358.43 June 22, 2026: 13 @ 33.12
Aug. 16, 2026issueSO-260816-872MAIN 32 33.12-1,059.742056,788.94 June 22, 2026: 32 @ 33.12
Aug. 5, 2026issueSO-260805-291MAIN 62 33.12-2,053.242377,848.68 June 22, 2026: 62 @ 33.12
July 21, 2026issueSO-260721-770MAIN 64 33.12-2,119.482999,901.92 June 22, 2026: 64 @ 33.12
July 20, 2026issueSO-260720-856EAST 7 33.12-231.8236312,021.40 June 22, 2026: 7 @ 33.12
July 9, 2026issueSO-260709-834MAIN 27 33.12-894.1537012,253.22 June 22, 2026: 27 @ 33.12
July 3, 2026issueSO-260703-668EAST 8 33.12-264.9339713,147.37 June 22, 2026: 8 @ 33.12
July 2, 2026issueSO-260702-958MAIN 25 33.12-827.9240513,412.30 June 22, 2026: 25 @ 33.12
June 22, 2026transferTRFMAIN → EAST 87 warehouse transfer, no cost effect
June 22, 2026receiptPO-001594MAIN 430 33.1214,240.2243014,240.22
June 15, 2026issueSO-260615-293MAIN 67 32.27-2,162.2800.00 April 3, 2026: 67 @ 32.27
June 11, 2026issueSO-260611-640MAIN 66 32.27-2,130.01672,162.28 April 3, 2026: 66 @ 32.27
June 8, 2026issueSO-260608-349MAIN 32 32.27-1,032.731334,292.30 April 3, 2026: 32 @ 32.27
June 8, 2026issueSO-260608-349EAST 35 32.27-1,129.551655,325.03 April 3, 2026: 35 @ 32.27
May 28, 2026issueSO-260528-329MAIN 7 32.27-225.912006,454.58 April 3, 2026: 7 @ 32.27
May 18, 2026issueSO-260518-362MAIN 5 32.27-161.362076,680.49 April 3, 2026: 5 @ 32.27
May 9, 2026issueSO-260509-673EAST 49 32.27-1,581.372126,841.85 April 3, 2026: 49 @ 32.27
May 4, 2026issueSO-260504-664MAIN 10 32.27-322.732618,423.23 April 3, 2026: 10 @ 32.27
May 1, 2026issueSO-260501-271EAST 54 32.27-1,742.742718,745.96 April 3, 2026: 54 @ 32.27
April 26, 2026issueSO-260426-395MAIN 24 32.27-774.5532510,488.69 April 3, 2026: 24 @ 32.27
April 13, 2026issueSO-260413-343MAIN 10 32.27-322.7334911,263.24 April 3, 2026: 10 @ 32.27
April 12, 2026issueSO-260412-521MAIN 5 32.27-161.3635911,585.97 April 3, 2026: 5 @ 32.27
April 5, 2026issueSO-260405-867MAIN 66 32.27-2,130.0136411,747.34 April 3, 2026: 66 @ 32.27
April 3, 2026transferTRFMAIN → EAST 138 warehouse transfer, no cost effect
April 3, 2026receiptPO-001382MAIN 430 32.2713,877.3543013,877.35
March 27, 2026issueSO-260327-100MAIN 116 32.74-3,797.5400.00 Jan. 6, 2026: 116 @ 32.74
March 13, 2026issueSO-260313-426MAIN 8 32.74-261.901163,797.54 Jan. 6, 2026: 8 @ 32.74
Feb. 26, 2026issueSO-260226-423MAIN 94 32.74-3,077.321244,059.44 Jan. 6, 2026: 94 @ 32.74
Feb. 24, 2026issueSO-260224-863MAIN 10 32.74-327.372187,136.75 Jan. 6, 2026: 10 @ 32.74
Feb. 13, 2026issueSO-260213-327MAIN 50 32.74-1,636.872287,464.13 Jan. 6, 2026: 50 @ 32.74
Feb. 2, 2026issueSO-260202-548MAIN 15 32.74-491.062789,101.00 Jan. 6, 2026: 15 @ 32.74
Feb. 1, 2026issueSO-260201-446MAIN 39 32.74-1,276.762939,592.06 Jan. 6, 2026: 39 @ 32.74
Jan. 22, 2026issueSO-260122-860MAIN 20 32.74-654.7533210,868.82 Jan. 6, 2026: 20 @ 32.74
Jan. 22, 2026issueSO-260122-860EAST 4 32.74-130.9535211,523.56 Jan. 6, 2026: 4 @ 32.74
Jan. 15, 2026issueSO-260115-672MAIN 14 32.74-458.3235611,654.51 Jan. 6, 2026: 14 @ 32.74
Jan. 14, 2026issueSO-260114-814MAIN 64 32.73-2,094.9537012,112.84 Nov. 20, 2025: 4 @ 32.68; Jan. 6, 2026: 60 @ 32.74
Jan. 6, 2026receiptPO-001126MAIN 430 32.7414,077.0843414,207.79
Jan. 4, 2026issueSO-260104-927EAST 47 32.68-1,535.784130.70 Sept. 30, 2025: 34 @ 32.68; Nov. 20, 2025: 13 @ 32.68
Dec. 29, 2025issueSO-251229-403EAST 41 32.68-1,339.72511,666.49 Sept. 30, 2025: 41 @ 32.68
Dec. 29, 2025issueSO-251229-403MAIN 84 32.68-2,744.80923,006.21 Sept. 30, 2025: 84 @ 32.68
Dec. 8, 2025issueSO-251208-259MAIN 15 32.68-490.141765,751.01 Sept. 30, 2025: 15 @ 32.68
Dec. 4, 2025issueSO-251204-420MAIN 1 32.68-32.681916,241.15 Sept. 30, 2025: 1 @ 32.68
Nov. 30, 2025issueSO-251130-548MAIN 9 32.68-294.091926,273.83 Sept. 30, 2025: 9 @ 32.68
Nov. 23, 2025issueSO-251123-699MAIN 63 32.68-2,058.602016,567.92 Sept. 30, 2025: 63 @ 32.68
Nov. 20, 2025returnRMAMAIN 17 32.68555.502648,626.52
Nov. 20, 2025issueSO-251120-949MAIN 31 32.68-1,012.962478,071.02 Sept. 30, 2025: 31 @ 32.68
Nov. 4, 2025issueSO-251104-770MAIN 35 32.68-1,143.672789,083.98 Sept. 30, 2025: 35 @ 32.68
Nov. 3, 2025issueSO-251103-693MAIN 27 32.68-882.2631310,227.65 Sept. 30, 2025: 27 @ 32.68
Oct. 31, 2025issueSO-251031-743EAST 3 32.68-98.0334011,109.91 Sept. 30, 2025: 3 @ 32.68
Oct. 25, 2025issueSO-251025-215MAIN 4 32.68-130.7034311,207.94 Sept. 30, 2025: 4 @ 32.68
Oct. 22, 2025issueSO-251022-392MAIN 14 32.68-457.4734711,338.64 Sept. 30, 2025: 14 @ 32.68
Oct. 9, 2025issueSO-251009-986MAIN 8 32.68-261.4136111,796.11 Sept. 30, 2025: 8 @ 32.68
Oct. 7, 2025issueSO-251007-721EAST 11 32.68-359.4436912,057.52 Sept. 30, 2025: 11 @ 32.68
Oct. 6, 2025issueSO-251006-151MAIN 99 32.30-3,198.0038012,416.96 July 7, 2025: 49 @ 31.92; Sept. 30, 2025: 50 @ 32.68
Sept. 30, 2025transferTRFMAIN → EAST 106 warehouse transfer, no cost effect
Sept. 30, 2025receiptPO-000890MAIN 430 32.6814,050.7747915,614.95
Sept. 29, 2025issueSO-250929-582MAIN 7 31.92-223.46491,564.19 July 7, 2025: 7 @ 31.92
Sept. 28, 2025adjustmentCycle countMAIN -2 31.92-63.84561,787.64 July 7, 2025: 2 @ 31.92
Sept. 24, 2025issueSO-250924-631MAIN 17 31.92-542.68581,851.49 July 7, 2025: 17 @ 31.92
Sept. 21, 2025issueSO-250921-428MAIN 42 31.92-1,340.73752,394.16 July 7, 2025: 42 @ 31.92
Sept. 16, 2025issueSO-250916-160MAIN 43 31.92-1,372.651173,734.90 July 7, 2025: 43 @ 31.92
Sept. 3, 2025issueSO-250903-346MAIN 14 31.92-446.911605,107.55 July 7, 2025: 14 @ 31.92
Aug. 19, 2025issueSO-250819-728MAIN 48 31.92-1,532.271745,554.46 July 7, 2025: 48 @ 31.92
Aug. 18, 2025issueSO-250818-802MAIN 2 31.92-63.842227,086.73 July 7, 2025: 2 @ 31.92
Aug. 17, 2025issueSO-250817-803MAIN 14 31.92-446.912247,150.57 July 7, 2025: 14 @ 31.92
Aug. 8, 2025issueSO-250808-975MAIN 11 31.92-351.142387,597.48 July 7, 2025: 11 @ 31.92
Aug. 6, 2025issueSO-250806-784MAIN 8 31.92-255.382497,948.63 July 7, 2025: 8 @ 31.92
Aug. 3, 2025issueSO-250803-415MAIN 35 31.92-1,117.282578,204.01 July 7, 2025: 35 @ 31.92
July 17, 2025issueSO-250717-269MAIN 83 31.92-2,649.542929,321.28 July 7, 2025: 83 @ 31.92
July 10, 2025issueSO-250710-842MAIN 19 31.92-606.5237511,970.82 July 7, 2025: 19 @ 31.92
July 7, 2025issueSO-250707-324MAIN 61 31.60-1,927.7139412,577.35 April 4, 2025: 25 @ 31.14; July 7, 2025: 36 @ 31.92
July 7, 2025receiptPO-000693MAIN 430 31.9213,726.5545514,505.06
July 2, 2025issueSO-250702-859MAIN 17 31.14-529.3925778.51 April 4, 2025: 17 @ 31.14
July 1, 2025issueSO-250701-913MAIN 23 31.14-716.23421,307.90 April 4, 2025: 23 @ 31.14
June 30, 2025issueSO-250630-913MAIN 46 31.14-1,432.46652,024.13 April 4, 2025: 46 @ 31.14
June 26, 2025issueSO-250626-925MAIN 24 31.14-747.371113,456.60 April 4, 2025: 24 @ 31.14
June 8, 2025issueSO-250608-696MAIN 32 31.14-996.501354,203.97 April 4, 2025: 32 @ 31.14
June 5, 2025issueSO-250605-193MAIN 50 31.14-1,557.021675,200.46 April 4, 2025: 50 @ 31.14
June 2, 2025issueSO-250602-374MAIN 8 31.14-249.122176,757.49 April 4, 2025: 8 @ 31.14
May 22, 2025issueSO-250522-210MAIN 23 31.14-716.232257,006.61 April 4, 2025: 23 @ 31.14
May 14, 2025issueSO-250514-864MAIN 34 31.14-1,058.782487,722.84 April 4, 2025: 34 @ 31.14
May 13, 2025issueSO-250513-919MAIN 55 31.14-1,712.732828,781.62 April 4, 2025: 55 @ 31.14
May 7, 2025issueSO-250507-179MAIN 14 31.14-435.9733710,494.35 April 4, 2025: 14 @ 31.14
April 26, 2025issueSO-250426-946MAIN 28 31.14-871.9335110,930.32 April 4, 2025: 28 @ 31.14
April 20, 2025issueSO-250420-507MAIN 99 30.95-3,064.1037911,802.25 Dec. 19, 2024: 42 @ 30.75; March 2, 2025: 6 @ 30.75; April 4, 2025: 51 @ 31.14
April 4, 2025receiptPO-000412MAIN 430 31.1413,390.4247814,866.35
March 27, 2025issueSO-250327-601MAIN 64 30.75-1,967.92481,475.94 Dec. 19, 2024: 64 @ 30.75
March 23, 2025issueSO-250323-108MAIN 11 30.75-338.241123,443.85 Dec. 19, 2024: 11 @ 30.75
March 19, 2025issueSO-250319-485MAIN 45 30.75-1,383.691233,782.09 Dec. 19, 2024: 45 @ 30.75
March 15, 2025issueSO-250315-906MAIN 15 30.75-461.231685,165.78 Dec. 19, 2024: 15 @ 30.75
March 12, 2025issueSO-250312-121MAIN 13 30.75-399.731835,627.01 Dec. 19, 2024: 13 @ 30.75
March 9, 2025issueSO-250309-664MAIN 1 30.75-30.751966,026.75 Dec. 19, 2024: 1 @ 30.75
March 3, 2025issueSO-250303-910MAIN 1 30.75-30.751976,057.49 Dec. 19, 2024: 1 @ 30.75
March 2, 2025returnRMAMAIN 6 30.75184.491986,088.24
Feb. 27, 2025issueSO-250227-828MAIN 1 30.75-30.751925,903.75 Dec. 19, 2024: 1 @ 30.75
Feb. 23, 2025issueSO-250223-109MAIN 8 30.75-245.991935,934.50 Dec. 19, 2024: 8 @ 30.75
Feb. 22, 2025issueSO-250222-367MAIN 13 30.75-399.732016,180.49 Dec. 19, 2024: 13 @ 30.75
Feb. 22, 2025issueSO-250222-367EAST 7 30.75-215.242146,580.22 Dec. 19, 2024: 7 @ 30.75
Feb. 17, 2025issueSO-250217-135EAST 21 30.75-645.722216,795.46 Dec. 19, 2024: 21 @ 30.75
Feb. 8, 2025issueSO-250208-199MAIN 40 30.75-1,229.952427,441.19 Dec. 19, 2024: 40 @ 30.75
Feb. 4, 2025issueSO-250204-392EAST 7 30.75-215.242828,671.13 Dec. 19, 2024: 7 @ 30.75
Feb. 3, 2025issueSO-250203-563MAIN 41 30.75-1,260.702898,886.37 Dec. 19, 2024: 41 @ 30.75
Jan. 31, 2025issueSO-250131-622MAIN 75 30.75-2,306.1533010,147.07 Dec. 19, 2024: 75 @ 30.75
Jan. 25, 2025issueSO-250125-574EAST 6 30.75-184.4940512,453.22 Dec. 19, 2024: 6 @ 30.75
Jan. 23, 2025issueSO-250123-223MAIN 1 30.75-30.7541112,637.72 Dec. 19, 2024: 1 @ 30.75
Jan. 20, 2025issueSO-250120-861EAST 4 30.75-122.9941212,668.46 Dec. 19, 2024: 4 @ 30.75
Jan. 16, 2025issueSO-250116-619EAST 2 30.75-61.5041612,791.46 Dec. 19, 2024: 2 @ 30.75
Jan. 13, 2025issueSO-250113-980MAIN 1 30.75-30.7541812,852.96 Dec. 19, 2024: 1 @ 30.75
Jan. 2, 2025issueSO-250102-959MAIN 6 30.75-184.4941912,883.71 Dec. 19, 2024: 6 @ 30.75
Dec. 31, 2024issueSO-241231-420MAIN 11 31.34-344.6942513,068.20 Nov. 17, 2024: 6 @ 31.82; Dec. 19, 2024: 5 @ 30.75
Dec. 29, 2024issueSO-241229-303MAIN 40 31.82-1,273.0043613,412.89 Oct. 1, 2024: 31 @ 31.82; Nov. 17, 2024: 9 @ 31.82
Dec. 28, 2024issueSO-241228-877MAIN 13 31.82-413.7247614,685.89 Oct. 1, 2024: 13 @ 31.82
Dec. 19, 2024receiptPO-000117MAIN 430 30.7513,221.9448915,099.62
Dec. 13, 2024issueSO-241213-362EAST 15 31.82-477.38591,877.68 Oct. 1, 2024: 15 @ 31.82
Dec. 12, 2024issueSO-241212-740EAST 5 31.82-159.12742,355.05 Oct. 1, 2024: 5 @ 31.82
Dec. 3, 2024issueSO-241203-435EAST 9 31.82-286.42792,514.18 Oct. 1, 2024: 9 @ 31.82
Nov. 23, 2024issueSO-241123-903MAIN 48 31.82-1,527.60882,800.60 Oct. 1, 2024: 48 @ 31.82
Nov. 22, 2024issueSO-241122-901MAIN 8 31.82-254.601364,328.20 Oct. 1, 2024: 8 @ 31.82
Nov. 17, 2024returnRMAMAIN 15 31.82477.381444,582.80
Nov. 14, 2024issueSO-241114-943EAST 31 31.82-986.581294,105.42 Oct. 1, 2024: 31 @ 31.82
Nov. 9, 2024issueSO-241109-351MAIN 25 31.82-795.621605,092.00 Oct. 1, 2024: 25 @ 31.82
Nov. 2, 2024issueSO-241102-835EAST 23 31.82-731.981855,887.62 Oct. 1, 2024: 23 @ 31.82
Oct. 26, 2024issueSO-241026-997MAIN 148 31.82-4,710.102086,619.60 Oct. 1, 2024: 148 @ 31.82
Oct. 8, 2024issueSO-241008-168MAIN 74 31.82-2,355.0535611,329.70 Oct. 1, 2024: 74 @ 31.82
Oct. 1, 2024transferTRFMAIN → EAST 130 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 430 31.8213,684.7543013,684.75