stocksense

Items / SWT-0037

Modular Switch 6A Classic SWT-0037 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)202MAIN 202
Value (FIFO)1,934.49avg 9.58
ClassCX / FCV 0.16
Turnover5.2xlast issue 2 days ago
Days of cover78lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00370.030.360.590.8121Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 87.0Nov 24: 87.0Dec 24: 76.0Jan 25: 92.0Feb 25: 103.0Mar 25: 78.0Apr 25: 102.0May 25: 85.0Jun 25: 40.0Jul 25: 90.0Aug 25: 68.0Sep 25: 110.0Oct 25: 72.0Nov 25: 83.0Dec 25: 75.0Jan 26: 77.0Feb 26: 85.0Mar 26: 88.0Apr 26: 63.0May 26: 102.0Jun 26: 85.0Jul 26: 93.0Aug 26: 66.0Sep 26: 56.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.437578.75 / 30.43752.587
Daily demand sdmonthly sd / sqrt(30.4375)12.64 / 5.5172.291
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.291^2 + 2.587^2 * 1.5^2)9.3
Reorder pointd * LT + safety stock2.587 * 7.0 + 9.327.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 = 944/yr, S = 45.00, h = 20%, price = 9.85207.7
Inventory positionon hand + on order202 + 0202

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

From qtyUnit costOrder qtyAnnual costFeasible
09.852089,711yes (chosen if cheapest)

MOQ 250, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 17, 2026165 / 2509.581,580.16
Sept. 29, 202637 / 379.58354.34

Movement ledger 112 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-740MAIN 7 9.58-67.042021,934.49 Sept. 17, 2026: 7 @ 9.58
Oct. 13, 2026issueSO-261013-795MAIN 21 9.58-201.112092,001.53 Sept. 17, 2026: 21 @ 9.58
Oct. 9, 2026issueSO-261009-504MAIN 1 9.58-9.582302,202.64 Sept. 17, 2026: 1 @ 9.58
Oct. 7, 2026issueSO-261007-171MAIN 11 9.58-105.342312,212.22 Sept. 17, 2026: 11 @ 9.58
Oct. 3, 2026issueSO-261003-774MAIN 43 9.58-411.802422,317.56 Sept. 17, 2026: 43 @ 9.58
Sept. 29, 2026returnRMAMAIN 37 9.58354.342852,729.36
Sept. 26, 2026issueSO-260926-761MAIN 2 9.58-19.152482,375.02 Sept. 17, 2026: 2 @ 9.58
Sept. 17, 2026receiptPO-001809MAIN 250 9.582,394.182502,394.18
Sept. 16, 2026issueSO-260916-682EAST 8 9.67-77.3600.00 July 2, 2026: 2 @ 9.67; Aug. 27, 2026: 6 @ 9.67
Sept. 10, 2026issueSO-260910-807EAST 75 9.67-725.26877.36 July 2, 2026: 75 @ 9.67
Sept. 10, 2026issueSO-260910-807MAIN 8 9.67-77.3683802.63 July 2, 2026: 8 @ 9.67
Aug. 31, 2026issueSO-260831-554MAIN 13 9.67-125.7191879.99 July 2, 2026: 13 @ 9.67
Aug. 27, 2026returnRMAMAIN 6 9.6758.021041,005.70
Aug. 22, 2026issueSO-260822-873MAIN 13 9.67-125.7198947.68 July 2, 2026: 13 @ 9.67
Aug. 21, 2026issueSO-260821-587MAIN 1 9.67-9.671111,073.39 July 2, 2026: 1 @ 9.67
Aug. 16, 2026issueSO-260816-243MAIN 31 9.67-299.781121,083.06 July 2, 2026: 31 @ 9.67
Aug. 11, 2026issueSO-260811-496MAIN 14 9.67-135.381431,382.84 July 2, 2026: 14 @ 9.67
July 11, 2026issueSO-260711-966MAIN 11 9.67-106.371571,518.22 July 2, 2026: 11 @ 9.67
July 8, 2026issueSO-260708-939MAIN 82 9.67-792.961681,624.59 July 2, 2026: 82 @ 9.67
July 2, 2026transferTRFMAIN → EAST 83 warehouse transfer, no cost effect
July 2, 2026receiptPO-001619MAIN 250 9.672,417.552502,417.55
June 29, 2026issueSO-260629-302MAIN 36 9.65-347.2300.00 April 4, 2026: 36 @ 9.65
June 25, 2026issueSO-260625-585MAIN 4 9.65-38.5836347.23 April 4, 2026: 4 @ 9.65
June 19, 2026issueSO-260619-957MAIN 7 9.65-67.5240385.82 April 4, 2026: 7 @ 9.65
June 4, 2026issueSO-260604-913MAIN 23 9.65-221.8447453.33 April 4, 2026: 23 @ 9.65
June 3, 2026issueSO-260603-270MAIN 15 9.65-144.6870675.18 April 4, 2026: 15 @ 9.65
May 17, 2026issueSO-260517-832MAIN 28 9.65-270.0785819.86 April 4, 2026: 28 @ 9.65
May 11, 2026issueSO-260511-689MAIN 74 9.65-713.761131,089.93 April 4, 2026: 74 @ 9.65
April 17, 2026issueSO-260417-749MAIN 9 9.65-86.811871,803.69 April 4, 2026: 9 @ 9.65
April 7, 2026issueSO-260407-660MAIN 2 9.65-19.291961,890.50 April 4, 2026: 2 @ 9.65
April 5, 2026issueSO-260405-512MAIN 52 9.65-501.561981,909.79 April 4, 2026: 52 @ 9.65
April 4, 2026receiptPO-001384MAIN 250 9.652,411.352502,411.35
March 26, 2026issueSO-260326-277MAIN 58 9.70-562.6900.00 Dec. 21, 2025: 58 @ 9.70
March 15, 2026issueSO-260315-528MAIN 30 9.70-291.0458562.69 Dec. 21, 2025: 30 @ 9.70
Feb. 21, 2026issueSO-260221-275MAIN 1 9.70-9.7088853.73 Dec. 21, 2025: 1 @ 9.70
Feb. 7, 2026issueSO-260207-664MAIN 84 9.70-814.9389863.43 Dec. 21, 2025: 84 @ 9.70
Jan. 30, 2026issueSO-260130-698MAIN 42 9.70-407.461731,678.36 Dec. 21, 2025: 42 @ 9.70
Jan. 17, 2026issueSO-260117-867MAIN 12 9.70-116.422152,085.82 Dec. 21, 2025: 12 @ 9.70
Jan. 8, 2026issueSO-260108-775MAIN 23 9.70-223.132272,202.24 Dec. 21, 2025: 23 @ 9.70
Dec. 21, 2025receiptPO-001072MAIN 250 9.702,425.382502,425.38
Dec. 17, 2025issueSO-251217-664EAST 35 9.62-336.5900.00 Sept. 20, 2025: 35 @ 9.62
Dec. 17, 2025issueSO-251217-664MAIN 5 9.62-48.0835336.59 Sept. 20, 2025: 5 @ 9.62
Dec. 3, 2025issueSO-251203-736MAIN 35 9.62-336.5940384.68 Sept. 20, 2025: 35 @ 9.62
Nov. 29, 2025issueSO-251129-414MAIN 10 9.62-96.1775721.27 Sept. 20, 2025: 10 @ 9.62
Nov. 19, 2025issueSO-251119-825EAST 16 9.62-153.8785817.44 Sept. 20, 2025: 16 @ 9.62
Nov. 12, 2025issueSO-251112-325MAIN 44 9.62-423.14101971.31 Sept. 20, 2025: 44 @ 9.62
Nov. 1, 2025issueSO-251101-786MAIN 13 9.62-125.021451,394.45 Sept. 20, 2025: 13 @ 9.62
Oct. 28, 2025issueSO-251028-329MAIN 9 9.62-86.551581,519.47 Sept. 20, 2025: 9 @ 9.62
Oct. 23, 2025issueSO-251023-253MAIN 30 9.62-288.511671,606.02 Sept. 20, 2025: 30 @ 9.62
Oct. 9, 2025issueSO-251009-401MAIN 33 9.62-317.361971,894.53 Sept. 20, 2025: 33 @ 9.62
Sept. 25, 2025issueSO-250925-142MAIN 12 9.62-115.402302,211.89 Sept. 20, 2025: 12 @ 9.62
Sept. 23, 2025issueSO-250923-783EAST 5 9.62-48.082422,327.29 Sept. 20, 2025: 5 @ 9.62
Sept. 20, 2025issueSO-250920-945MAIN 3 9.62-28.852472,375.37 Sept. 20, 2025: 3 @ 9.62
Sept. 20, 2025transferTRFMAIN → EAST 56 warehouse transfer, no cost effect
Sept. 20, 2025receiptPO-000859MAIN 250 9.622,404.222502,404.22
Sept. 16, 2025issueSO-250916-799MAIN 21 9.50-199.4500.00 June 15, 2025: 21 @ 9.50
Sept. 11, 2025issueSO-250911-528MAIN 11 9.50-104.4721199.45 June 15, 2025: 11 @ 9.50
Sept. 10, 2025issueSO-250910-230MAIN 55 9.50-522.3632303.92 June 15, 2025: 55 @ 9.50
Sept. 8, 2025issueSO-250908-725MAIN 3 9.50-28.4987826.28 June 15, 2025: 3 @ 9.50
Aug. 24, 2025issueSO-250824-125MAIN 5 9.50-47.4990854.78 June 15, 2025: 5 @ 9.50
Aug. 22, 2025issueSO-250822-228MAIN 22 9.50-208.9495902.26 June 15, 2025: 22 @ 9.50
Aug. 22, 2025issueSO-250822-228EAST 25 9.50-237.441171,111.21 June 15, 2025: 25 @ 9.50
Aug. 17, 2025issueSO-250817-160EAST 4 9.50-37.991421,348.64 June 15, 2025: 4 @ 9.50
Aug. 16, 2025issueSO-250816-522MAIN 12 9.50-113.971461,386.64 June 15, 2025: 12 @ 9.50
July 31, 2025issueSO-250731-369EAST 32 9.50-303.921581,500.60 June 15, 2025: 32 @ 9.50
July 22, 2025adjustmentCycle countMAIN -2 9.50-19.001901,804.52 June 15, 2025: 2 @ 9.50
July 10, 2025issueSO-250710-561MAIN 41 9.50-389.401921,823.52 June 15, 2025: 41 @ 9.50
July 8, 2025issueSO-250708-714MAIN 10 9.50-94.982332,212.92 June 15, 2025: 10 @ 9.50
July 2, 2025issueSO-250702-992MAIN 7 9.50-66.482432,307.89 June 15, 2025: 7 @ 9.50
June 15, 2025transferTRFMAIN → EAST 61 warehouse transfer, no cost effect
June 15, 2025receiptPO-000638MAIN 250 9.502,374.382502,374.38
June 10, 2025issueSO-250610-232MAIN 16 9.42-150.7600.00 April 3, 2025: 16 @ 9.42
June 9, 2025issueSO-250609-973MAIN 24 9.42-226.1416150.76 March 21, 2025: 18 @ 9.42; April 3, 2025: 6 @ 9.42
May 25, 2025issueSO-250525-738MAIN 36 9.42-339.2240376.91 March 21, 2025: 36 @ 9.42
May 22, 2025issueSO-250522-165MAIN 15 9.42-141.3476716.13 March 21, 2025: 15 @ 9.42
May 19, 2025issueSO-250519-814MAIN 8 9.42-75.3891857.47 March 21, 2025: 8 @ 9.42
May 12, 2025issueSO-250512-810MAIN 1 9.42-9.4299932.85 March 21, 2025: 1 @ 9.42
May 11, 2025issueSO-250511-224MAIN 16 9.42-150.76100942.27 March 21, 2025: 16 @ 9.42
May 4, 2025issueSO-250504-746MAIN 9 9.42-84.801161,093.03 March 21, 2025: 9 @ 9.42
April 26, 2025issueSO-250426-641MAIN 19 9.42-179.031251,177.84 March 21, 2025: 19 @ 9.42
April 23, 2025issueSO-250423-218MAIN 90 9.42-848.041441,356.87 March 21, 2025: 90 @ 9.42
April 15, 2025issueSO-250415-396MAIN 15 9.42-141.342342,204.91 March 21, 2025: 15 @ 9.42
April 3, 2025returnRMAMAIN 22 9.42207.302492,346.25
March 22, 2025issueSO-250322-937MAIN 23 9.42-216.722272,138.95 March 21, 2025: 23 @ 9.42
March 21, 2025receiptPO-000363MAIN 250 9.422,355.682502,355.68
March 16, 2025issueSO-250316-323MAIN 10 8.85-88.4600.00 Dec. 11, 2024: 10 @ 8.85
March 16, 2025issueSO-250316-323EAST 45 8.85-398.051088.46 Dec. 11, 2024: 45 @ 8.85
Feb. 23, 2025issueSO-250223-926MAIN 19 8.85-168.0755486.51 Dec. 11, 2024: 19 @ 8.85
Feb. 9, 2025issueSO-250209-494MAIN 42 8.85-371.5274654.57 Dec. 11, 2024: 42 @ 8.85
Feb. 5, 2025issueSO-250205-533MAIN 21 8.85-185.761161,026.09 Dec. 11, 2024: 21 @ 8.85
Feb. 2, 2025issueSO-250202-762MAIN 21 8.85-185.761371,211.85 Dec. 11, 2024: 21 @ 8.85
Jan. 24, 2025issueSO-250124-979EAST 16 8.85-141.531581,397.60 Dec. 11, 2024: 16 @ 8.85
Jan. 17, 2025issueSO-250117-858MAIN 22 8.85-194.601741,539.13 Dec. 11, 2024: 22 @ 8.85
Jan. 5, 2025issueSO-250105-791EAST 12 8.85-106.151961,733.74 Dec. 11, 2024: 12 @ 8.85
Jan. 4, 2025issueSO-250104-341MAIN 40 8.85-353.822081,839.88 Dec. 11, 2024: 40 @ 8.85
Jan. 3, 2025issueSO-250103-442EAST 2 8.85-17.692482,193.71 Dec. 11, 2024: 2 @ 8.85
Dec. 11, 2024transferTRFMAIN → EAST 75 warehouse transfer, no cost effect
Dec. 11, 2024receiptPO-000091MAIN 250 8.852,211.402502,211.40
Dec. 8, 2024issueSO-241208-816EAST 30 9.36-280.7200.00 Oct. 1, 2024: 30 @ 9.36
Dec. 6, 2024issueSO-241206-111EAST 46 9.36-430.4430280.72 Oct. 1, 2024: 46 @ 9.36
Nov. 28, 2024issueSO-241128-748EAST 10 9.36-93.5876711.17 Oct. 1, 2024: 10 @ 9.36
Nov. 28, 2024issueSO-241128-748MAIN 39 9.36-364.9486804.74 Oct. 1, 2024: 39 @ 9.36
Nov. 23, 2024issueSO-241123-244MAIN 3 9.36-28.071251,169.69 Oct. 1, 2024: 3 @ 9.36
Nov. 21, 2024issueSO-241121-532MAIN 5 9.36-46.791281,197.76 Oct. 1, 2024: 5 @ 9.36
Nov. 13, 2024issueSO-241113-483MAIN 20 9.36-187.151331,244.55 Oct. 1, 2024: 20 @ 9.36
Nov. 1, 2024issueSO-241101-542MAIN 10 9.36-93.581531,431.70 Oct. 1, 2024: 10 @ 9.36
Oct. 31, 2024issueSO-241031-120MAIN 6 9.36-56.141631,525.27 Oct. 1, 2024: 6 @ 9.36
Oct. 23, 2024issueSO-241023-761MAIN 18 9.36-168.441691,581.42 Oct. 1, 2024: 18 @ 9.36
Oct. 20, 2024issueSO-241020-875MAIN 20 9.36-187.151871,749.85 Oct. 1, 2024: 20 @ 9.36
Oct. 18, 2024issueSO-241018-162MAIN 43 9.36-402.372071,937.00 Oct. 1, 2024: 43 @ 9.36
Oct. 1, 2024transferTRFMAIN → EAST 86 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 250 9.362,339.382502,339.38