stocksense

Items / SWT-0029

Modular Switch 6A Prime SWT-0029 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)687MAIN 551, EAST 136
Value (FIFO)11,354.62avg 16.53
ClassAX / FCV 0.14
Turnover7.7xlast issue 4 days ago
Days of cover95lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00290.074.5149224298Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 235.0Nov 24: 271.0Dec 24: 169.0Jan 25: 210.0Feb 25: 231.0Mar 25: 204.0Apr 25: 186.0May 25: 192.0Jun 25: 177.0Jul 25: 155.0Aug 25: 231.0Sep 25: 161.0Oct 25: 233.0Nov 25: 182.0Dec 25: 216.0Jan 26: 233.0Feb 26: 215.0Mar 26: 181.0Apr 26: 261.0May 26: 256.0Jun 26: 201.0Jul 26: 166.0Aug 26: 253.0Sep 26: 258.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.4375221.25 / 30.43757.269
Daily demand sdmonthly sd / sqrt(30.4375)31.77 / 5.5175.759
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.759^2 + 7.269^2 * 1.5^2)38.8
Reorder pointd * LT + safety stock7.269 * 7.0 + 38.889.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days89.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 2653/yr, S = 45.00, h = 20%, price = 16.171320.0
Inventory positionon hand + on order687 + 0687

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

From qtyUnit costOrder qtyAnnual costFeasible
016.8426645,576yes
1,32016.171,32045,117yes (chosen if cheapest)
2,64015.492,64045,241yes

MOQ 660, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 24, 202627 / 66017.13462.64
Oct. 16, 2026660 / 66016.5010,891.98

Movement ledger 125 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026transferTRFMAIN → EAST 136 warehouse transfer, no cost effect
Oct. 16, 2026receiptPO-001886MAIN 660 16.5010,891.9868711,354.62
Oct. 12, 2026issueSO-261012-956MAIN 5 17.13-85.6727462.64 July 24, 2026: 5 @ 17.13
Oct. 11, 2026issueSO-261011-742MAIN 53 17.13-908.1532548.32 July 24, 2026: 53 @ 17.13
Oct. 10, 2026issueSO-261010-444MAIN 41 17.13-702.53851,456.47 July 24, 2026: 41 @ 17.13
Oct. 9, 2026issueSO-261009-909MAIN 25 17.13-428.371262,159.00 July 24, 2026: 25 @ 17.13
Oct. 8, 2026issueSO-261008-551MAIN 28 17.13-479.781512,587.37 July 24, 2026: 28 @ 17.13
Oct. 2, 2026issueSO-261002-153MAIN 24 17.13-411.241793,067.15 July 24, 2026: 24 @ 17.13
Sept. 26, 2026issueSO-260926-876MAIN 98 17.13-1,679.222033,478.38 July 24, 2026: 98 @ 17.13
Sept. 14, 2026issueSO-260914-323MAIN 41 17.13-702.533015,157.60 July 24, 2026: 41 @ 17.13
Sept. 13, 2026issueSO-260913-908MAIN 56 17.13-959.553425,860.14 July 24, 2026: 56 @ 17.13
Sept. 10, 2026issueSO-260910-254MAIN 47 17.13-805.343986,819.69 July 24, 2026: 47 @ 17.13
Sept. 7, 2026issueSO-260907-548MAIN 16 17.13-274.164457,625.03 July 24, 2026: 16 @ 17.13
Aug. 31, 2026issueSO-260831-679MAIN 15 17.13-257.024617,899.19 July 24, 2026: 15 @ 17.13
Aug. 21, 2026issueSO-260821-690MAIN 83 17.13-1,422.204768,156.21 July 24, 2026: 83 @ 17.13
Aug. 12, 2026issueSO-260812-975MAIN 155 16.99-2,632.895599,578.41 April 24, 2026: 54 @ 16.71; July 24, 2026: 101 @ 17.13
July 24, 2026receiptPO-001668MAIN 660 17.1311,309.0371412,211.30
July 16, 2026issueSO-260716-236MAIN 104 16.71-1,737.7054902.27 April 24, 2026: 104 @ 16.71
July 11, 2026issueSO-260711-759MAIN 62 16.71-1,035.941582,639.97 April 24, 2026: 62 @ 16.71
June 20, 2026issueSO-260620-971MAIN 22 16.71-367.592203,675.91 April 24, 2026: 22 @ 16.71
June 19, 2026issueSO-260619-448MAIN 65 16.71-1,086.072424,043.51 April 24, 2026: 65 @ 16.71
June 10, 2026issueSO-260610-540MAIN 97 16.71-1,620.743075,129.57 April 24, 2026: 97 @ 16.71
June 5, 2026issueSO-260605-966MAIN 17 16.71-284.054046,750.31 April 24, 2026: 17 @ 16.71
May 29, 2026issueSO-260529-845MAIN 10 16.71-167.094217,034.36 April 24, 2026: 10 @ 16.71
May 27, 2026issueSO-260527-126MAIN 14 16.71-233.924317,201.45 April 24, 2026: 14 @ 16.71
May 20, 2026issueSO-260520-249MAIN 108 16.71-1,804.544457,435.37 April 24, 2026: 108 @ 16.71
May 8, 2026issueSO-260508-365MAIN 38 16.71-634.935539,239.91 April 24, 2026: 38 @ 16.71
May 4, 2026issueSO-260504-102MAIN 86 16.67-1,433.675919,874.84 Jan. 22, 2026: 17 @ 16.52; April 24, 2026: 69 @ 16.71
April 26, 2026issueSO-260426-189MAIN 3 16.52-49.5567711,308.51 Jan. 22, 2026: 3 @ 16.52
April 24, 2026receiptPO-001434MAIN 660 16.7111,027.7468011,358.06
April 22, 2026issueSO-260422-628MAIN 33 16.52-545.0220330.31 Jan. 22, 2026: 33 @ 16.52
April 17, 2026issueSO-260417-112MAIN 166 16.52-2,741.6153875.33 Jan. 22, 2026: 166 @ 16.52
April 16, 2026issueSO-260416-278MAIN 58 16.52-957.912193,616.94 Jan. 22, 2026: 58 @ 16.52
April 6, 2026issueSO-260406-291MAIN 1 16.52-16.522774,574.85 Jan. 22, 2026: 1 @ 16.52
March 19, 2026issueSO-260319-274MAIN 19 16.52-313.802784,591.36 Jan. 22, 2026: 19 @ 16.52
March 9, 2026issueSO-260309-491MAIN 56 16.52-924.882974,905.16 Jan. 22, 2026: 56 @ 16.52
March 6, 2026issueSO-260306-290MAIN 53 16.52-875.333535,830.04 Jan. 22, 2026: 53 @ 16.52
March 4, 2026issueSO-260304-170MAIN 53 16.52-875.334066,705.37 Jan. 22, 2026: 53 @ 16.52
Feb. 28, 2026issueSO-260228-538MAIN 35 16.52-578.054597,580.71 Jan. 22, 2026: 35 @ 16.52
Feb. 22, 2026issueSO-260222-620MAIN 21 16.52-346.834948,158.76 Jan. 22, 2026: 21 @ 16.52
Feb. 17, 2026issueSO-260217-196MAIN 39 16.52-644.115158,505.59 Jan. 22, 2026: 39 @ 16.52
Feb. 15, 2026issueSO-260215-808MAIN 20 16.52-330.315549,149.70 Jan. 22, 2026: 20 @ 16.52
Feb. 3, 2026issueSO-260203-212MAIN 100 16.46-1,646.405749,480.01 Oct. 17, 2025: 12 @ 16.15; Dec. 1, 2025: 2 @ 16.15; Jan. 22, 2026: 86 @ 16.52
Jan. 26, 2026issueSO-260126-991MAIN 52 16.15-839.6167411,126.41 Oct. 17, 2025: 52 @ 16.15
Jan. 22, 2026receiptPO-001172MAIN 660 16.5210,900.3672611,966.02
Jan. 16, 2026issueSO-260116-820MAIN 48 16.15-775.02661,065.66 Oct. 17, 2025: 48 @ 16.15
Jan. 14, 2026issueSO-260114-592MAIN 18 16.15-290.631141,840.68 Oct. 17, 2025: 18 @ 16.15
Jan. 5, 2026issueSO-260105-227MAIN 36 16.15-581.271322,131.31 Oct. 17, 2025: 36 @ 16.15
Jan. 3, 2026issueSO-260103-386MAIN 68 16.15-1,097.951682,712.58 Oct. 17, 2025: 68 @ 16.15
Jan. 1, 2026issueSO-260101-286MAIN 11 16.15-177.612363,810.53 Oct. 17, 2025: 11 @ 16.15
Dec. 31, 2025issueSO-251231-130MAIN 13 16.15-209.902473,988.14 Oct. 17, 2025: 13 @ 16.15
Dec. 18, 2025issueSO-251218-432MAIN 49 16.15-791.172604,198.04 Oct. 17, 2025: 49 @ 16.15
Dec. 12, 2025issueSO-251212-178MAIN 33 16.15-532.833094,989.21 Oct. 17, 2025: 33 @ 16.15
Dec. 11, 2025issueSO-251211-256MAIN 32 16.15-516.683425,522.03 Oct. 17, 2025: 32 @ 16.15
Dec. 7, 2025issueSO-251207-472MAIN 16 16.15-258.343746,038.72 Oct. 17, 2025: 16 @ 16.15
Dec. 6, 2025issueSO-251206-958MAIN 75 16.15-1,210.973906,297.06 Oct. 17, 2025: 75 @ 16.15
Dec. 1, 2025returnRMAMAIN 2 16.1532.294657,508.03
Nov. 30, 2025issueSO-251130-490MAIN 51 16.15-823.464637,475.74 Oct. 17, 2025: 51 @ 16.15
Nov. 18, 2025issueSO-251118-978MAIN 4 16.15-64.595148,299.20 Oct. 17, 2025: 4 @ 16.15
Nov. 15, 2025issueSO-251115-159MAIN 75 16.15-1,210.975188,363.78 Oct. 17, 2025: 75 @ 16.15
Nov. 12, 2025issueSO-251112-956MAIN 13 16.15-209.905939,574.76 Oct. 17, 2025: 13 @ 16.15
Nov. 10, 2025issueSO-251110-768MAIN 39 16.15-629.716069,784.66 Oct. 17, 2025: 39 @ 16.15
Oct. 25, 2025issueSO-251025-185MAIN 11 16.15-177.6164510,414.36 Oct. 17, 2025: 11 @ 16.15
Oct. 21, 2025issueSO-251021-720MAIN 4 16.15-64.5965610,591.97 Oct. 17, 2025: 4 @ 16.15
Oct. 17, 2025receiptPO-000929MAIN 660 16.1510,656.5666010,656.56
Oct. 15, 2025issueSO-251015-554MAIN 25 15.80-395.0300.00 July 10, 2025: 15 @ 15.80; Sept. 8, 2025: 10 @ 15.80
Oct. 11, 2025issueSO-251011-435MAIN 111 15.80-1,753.9425395.03 July 10, 2025: 111 @ 15.80
Oct. 8, 2025issueSO-251008-502MAIN 40 15.80-632.051362,148.98 July 10, 2025: 40 @ 15.80
Oct. 8, 2025issueSO-251008-502EAST 42 15.80-663.651762,781.03 July 10, 2025: 42 @ 15.80
Sept. 18, 2025issueSO-250918-689MAIN 1 15.80-15.802183,444.68 July 10, 2025: 1 @ 15.80
Sept. 8, 2025returnRMAMAIN 10 15.80158.012193,460.48
Sept. 3, 2025issueSO-250903-752EAST 14 15.80-221.222093,302.47 July 10, 2025: 14 @ 15.80
Sept. 1, 2025issueSO-250901-212MAIN 156 15.80-2,465.002233,523.69 July 10, 2025: 156 @ 15.80
Aug. 29, 2025issueSO-250829-685EAST 42 15.80-663.653795,988.69 July 10, 2025: 42 @ 15.80
Aug. 25, 2025issueSO-250825-610MAIN 33 15.80-521.444216,652.35 July 10, 2025: 33 @ 15.80
Aug. 22, 2025issueSO-250822-437EAST 20 15.80-316.034547,173.79 July 10, 2025: 20 @ 15.80
Aug. 21, 2025issueSO-250821-979MAIN 1 15.80-15.804747,489.82 July 10, 2025: 1 @ 15.80
Aug. 9, 2025issueSO-250809-407MAIN 99 15.80-1,564.334757,505.62 July 10, 2025: 99 @ 15.80
Aug. 8, 2025issueSO-250808-481MAIN 36 15.80-568.855749,069.95 July 10, 2025: 36 @ 15.80
July 29, 2025issueSO-250729-575MAIN 29 15.80-458.246109,638.79 July 10, 2025: 29 @ 15.80
July 26, 2025issueSO-250726-346MAIN 7 15.80-110.6163910,097.03 July 10, 2025: 7 @ 15.80
July 14, 2025issueSO-250714-977MAIN 24 15.70-376.8764610,207.64 April 1, 2025: 10 @ 15.57; July 10, 2025: 14 @ 15.80
July 10, 2025issueSO-250710-844EAST 53 15.57-824.9867010,584.51 April 1, 2025: 53 @ 15.57
July 10, 2025transferTRFMAIN → EAST 171 warehouse transfer, no cost effect
July 10, 2025receiptPO-000697MAIN 660 15.8010,428.8672311,409.49
July 5, 2025issueSO-250705-178MAIN 21 15.57-326.8863980.63 April 1, 2025: 21 @ 15.57
July 2, 2025issueSO-250702-281MAIN 21 15.57-326.88841,307.51 April 1, 2025: 21 @ 15.57
June 29, 2025issueSO-250629-354MAIN 161 15.57-2,506.061051,634.39 April 1, 2025: 161 @ 15.57
June 19, 2025issueSO-250619-329MAIN 12 15.57-186.792664,140.45 April 1, 2025: 12 @ 15.57
June 5, 2025issueSO-250605-283MAIN 4 15.57-62.262784,327.24 April 1, 2025: 4 @ 15.57
May 28, 2025issueSO-250528-926MAIN 10 15.57-155.662824,389.50 April 1, 2025: 10 @ 15.57
May 25, 2025issueSO-250525-227MAIN 11 15.57-171.222924,545.16 April 1, 2025: 11 @ 15.57
May 14, 2025issueSO-250514-450MAIN 18 15.57-280.183034,716.38 April 1, 2025: 18 @ 15.57
May 14, 2025issueSO-250514-450EAST 98 15.57-1,525.433214,996.56 April 1, 2025: 98 @ 15.57
May 8, 2025issueSO-250508-352EAST 55 15.57-856.114196,521.99 April 1, 2025: 55 @ 15.57
April 22, 2025issueSO-250422-529MAIN 37 15.57-575.934747,378.09 April 1, 2025: 37 @ 15.57
April 15, 2025issueSO-250415-173MAIN 59 15.57-918.375117,954.02 April 1, 2025: 59 @ 15.57
April 7, 2025issueSO-250407-964MAIN 68 15.57-1,058.465708,872.39 April 1, 2025: 68 @ 15.57
April 6, 2025issueSO-250406-706EAST 10 15.57-155.666389,930.85 April 1, 2025: 10 @ 15.57
April 2, 2025issueSO-250402-219MAIN 12 15.57-186.7964810,086.51 April 1, 2025: 12 @ 15.57
April 1, 2025transferTRFMAIN → EAST 163 warehouse transfer, no cost effect
April 1, 2025receiptPO-000399MAIN 660 15.5710,273.3066010,273.30
March 29, 2025issueSO-250329-200MAIN 87 15.33-1,333.6300.00 Dec. 19, 2024: 87 @ 15.33
March 23, 2025issueSO-250323-162MAIN 46 15.33-705.14871,333.63 Dec. 19, 2024: 46 @ 15.33
March 15, 2025issueSO-250315-852MAIN 23 15.33-352.571332,038.77 Dec. 19, 2024: 23 @ 15.33
March 7, 2025issueSO-250307-353MAIN 48 15.33-735.801562,391.34 Dec. 19, 2024: 48 @ 15.33
Feb. 24, 2025issueSO-250224-576MAIN 61 15.33-935.082043,127.14 Dec. 19, 2024: 61 @ 15.33
Feb. 22, 2025issueSO-250222-349MAIN 53 15.33-812.442654,062.21 Dec. 19, 2024: 53 @ 15.33
Feb. 17, 2025issueSO-250217-169MAIN 66 15.33-1,011.723184,874.65 Dec. 19, 2024: 66 @ 15.33
Feb. 16, 2025issueSO-250216-803MAIN 51 15.33-781.783845,886.37 Dec. 19, 2024: 51 @ 15.33
Jan. 29, 2025issueSO-250129-939MAIN 30 15.33-459.874356,668.16 Dec. 19, 2024: 30 @ 15.33
Jan. 24, 2025issueSO-250124-854MAIN 64 15.33-981.064657,128.03 Dec. 19, 2024: 64 @ 15.33
Jan. 18, 2025issueSO-250118-198MAIN 116 15.33-1,778.185298,109.09 Dec. 19, 2024: 116 @ 15.33
Dec. 19, 2024issueSO-241219-358MAIN 15 15.33-229.946459,887.27 Dec. 19, 2024: 15 @ 15.33
Dec. 19, 2024receiptPO-000119MAIN 660 15.3310,117.2166010,117.21
Dec. 12, 2024issueSO-241212-938MAIN 61 16.00-975.8800.00 Oct. 1, 2024: 61 @ 16.00
Dec. 11, 2024issueSO-241211-956MAIN 93 16.00-1,487.8161975.88 Oct. 1, 2024: 93 @ 16.00
Nov. 30, 2024issueSO-241130-918MAIN 64 16.00-1,023.871542,463.69 Oct. 1, 2024: 64 @ 16.00
Nov. 26, 2024issueSO-241126-658MAIN 31 16.00-495.942183,487.56 Oct. 1, 2024: 31 @ 16.00
Nov. 6, 2024issueSO-241106-224MAIN 176 16.00-2,815.652493,983.50 Oct. 1, 2024: 176 @ 16.00
Oct. 29, 2024issueSO-241029-802MAIN 5 16.00-79.994256,799.15 Oct. 1, 2024: 5 @ 16.00
Oct. 26, 2024issueSO-241026-619MAIN 21 16.00-335.964306,879.14 Oct. 1, 2024: 21 @ 16.00
Oct. 19, 2024issueSO-241019-105MAIN 200 16.00-3,199.604517,215.10 Oct. 1, 2024: 200 @ 16.00
Oct. 17, 2024issueSO-241017-362MAIN 9 16.00-143.9865110,414.70 Oct. 1, 2024: 9 @ 16.00
Oct. 1, 2024receiptPO-000005MAIN 660 16.0010,558.6866010,558.68