stocksense

Items / SWT-0009

Dimmer Switch Nova SWT-0009 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)239MAIN 167, EAST 72
Value (FIFO)2,101.57avg 8.79
ClassBX / FCV 0.18
Turnover12.1xlast issue 3 days ago
Days of cover57lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00090.047.695.2143190Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 117.0Nov 24: 101.0Dec 24: 126.0Jan 25: 111.0Feb 25: 122.0Mar 25: 72.0Apr 25: 105.0May 25: 119.0Jun 25: 88.0Jul 25: 119.0Aug 25: 131.0Sep 25: 114.0Oct 25: 98.0Nov 25: 116.0Dec 25: 156.0Jan 26: 96.0Feb 26: 116.0Mar 26: 123.0Apr 26: 117.0May 26: 132.0Jun 26: 158.0Jul 26: 173.0Aug 26: 122.0Sep 26: 137.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.4375128.67 / 30.43754.227
Daily demand sdmonthly sd / sqrt(30.4375)22.72 / 5.5174.118
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 * 4.118^2 + 4.227^2 * 1.5^2)20.9
Reorder pointd * LT + safety stock4.227 * 7.0 + 20.950.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days50.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1543/yr, S = 45.00, h = 20%, price = 8.011440.0
Inventory positionon hand + on order239 + 0239

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

From qtyUnit costOrder qtyAnnual costFeasible
08.7128213,931yes
7208.3672013,600yes
1,4408.011,44013,566yes (chosen if cheapest)

MOQ 360, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 11, 2026239 / 3608.792,101.57

Movement ledger 121 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026issueSO-261013-665MAIN 46 8.79-404.492392,101.57 Sept. 11, 2026: 46 @ 8.79
Oct. 8, 2026issueSO-261008-988MAIN 9 8.79-79.142852,506.06 Sept. 11, 2026: 9 @ 8.79
Oct. 7, 2026issueSO-261007-969MAIN 3 8.79-26.382942,585.20 Sept. 11, 2026: 3 @ 8.79
Oct. 3, 2026issueSO-261003-316MAIN 65 8.78-570.962972,611.58 Sept. 9, 2026: 2 @ 8.49; Sept. 11, 2026: 63 @ 8.79
Oct. 2, 2026issueSO-261002-910MAIN 9 8.49-76.443623,182.54 Sept. 9, 2026: 9 @ 8.49
Sept. 22, 2026issueSO-260922-658EAST 10 8.48-84.813713,258.98 July 10, 2026: 2 @ 8.43; Sept. 9, 2026: 8 @ 8.49
Sept. 16, 2026issueSO-260916-208MAIN 20 8.47-169.373813,343.78 July 10, 2026: 12 @ 8.49; July 10, 2026: 8 @ 8.43
Sept. 15, 2026issueSO-260915-766MAIN 20 8.49-169.864013,513.15 July 10, 2026: 20 @ 8.49
Sept. 11, 2026transferTRFMAIN → EAST 82 warehouse transfer, no cost effect
Sept. 11, 2026receiptPO-001789MAIN 360 8.793,165.554213,683.02
Sept. 9, 2026returnRMAMAIN 19 8.49161.3761517.46
Sept. 1, 2026issueSO-260901-438MAIN 106 8.49-900.2742356.09 July 10, 2026: 106 @ 8.49
Aug. 28, 2026issueSO-260828-965MAIN 3 8.49-25.481481,256.36 July 10, 2026: 3 @ 8.49
Aug. 22, 2026issueSO-260822-955MAIN 38 8.49-322.741511,281.84 July 10, 2026: 38 @ 8.49
Aug. 21, 2026issueSO-260821-869MAIN 68 8.49-577.531891,604.58 July 10, 2026: 68 @ 8.49
Aug. 18, 2026issueSO-260818-702MAIN 2 8.49-16.992572,182.11 July 10, 2026: 2 @ 8.49
Aug. 3, 2026issueSO-260803-995MAIN 3 8.49-25.482592,199.10 July 10, 2026: 3 @ 8.49
Aug. 1, 2026issueSO-260801-743MAIN 8 8.49-67.942622,224.58 July 10, 2026: 8 @ 8.49
July 29, 2026issueSO-260729-945MAIN 7 8.49-59.452702,292.52 July 10, 2026: 7 @ 8.49
July 29, 2026issueSO-260729-945EAST 29 8.49-246.302772,351.97 July 10, 2026: 29 @ 8.49
July 24, 2026issueSO-260724-324EAST 16 8.49-135.893062,598.27 July 10, 2026: 16 @ 8.49
July 21, 2026issueSO-260721-527MAIN 5 8.49-42.473222,734.16 July 10, 2026: 5 @ 8.49
July 15, 2026issueSO-260715-401MAIN 61 8.47-516.903272,776.63 May 1, 2026: 12 @ 8.43; May 7, 2026: 6 @ 8.42; July 10, 2026: 43 @ 8.49
July 13, 2026issueSO-260713-696MAIN 34 8.43-286.673883,293.53 May 1, 2026: 34 @ 8.43
July 10, 2026returnRMAMAIN 10 8.4384.324223,580.20
July 10, 2026receiptPO-001639MAIN 360 8.493,057.524123,495.88
July 3, 2026issueSO-260703-881MAIN 31 8.43-261.3852438.37 May 1, 2026: 31 @ 8.43
June 30, 2026issueSO-260630-785MAIN 20 8.43-168.6383699.74 May 1, 2026: 20 @ 8.43
June 2, 2026issueSO-260602-786MAIN 138 8.43-1,163.55103868.37 May 1, 2026: 138 @ 8.43
May 29, 2026issueSO-260529-746MAIN 103 8.43-868.442412,031.92 May 1, 2026: 103 @ 8.43
May 21, 2026issueSO-260521-272EAST 35 8.43-294.953442,900.36 Jan. 12, 2026: 7 @ 8.42; April 21, 2026: 6 @ 8.42; May 1, 2026: 22 @ 8.43
May 7, 2026returnRMAMAIN 6 8.4250.523793,195.31
May 1, 2026transferTRFMAIN → EAST 80 warehouse transfer, no cost effect
May 1, 2026receiptPO-001456MAIN 360 8.433,035.343733,144.79
April 29, 2026issueSO-260429-687MAIN 8 8.42-67.3613109.45 Jan. 12, 2026: 8 @ 8.42
April 27, 2026issueSO-260427-720MAIN 13 8.42-109.4521176.81 Jan. 12, 2026: 13 @ 8.42
April 24, 2026issueSO-260424-646MAIN 42 8.42-353.6134286.26 Jan. 12, 2026: 42 @ 8.42
April 22, 2026issueSO-260422-123MAIN 25 8.42-210.4876639.87 Jan. 12, 2026: 25 @ 8.42
April 21, 2026returnRMAMAIN 6 8.4250.52101850.36
April 21, 2026issueSO-260421-533MAIN 23 8.42-193.6595799.84 Jan. 12, 2026: 23 @ 8.42
April 2, 2026issueSO-260402-113MAIN 12 8.42-101.03118993.49 Jan. 12, 2026: 12 @ 8.42
March 16, 2026issueSO-260316-468MAIN 20 8.42-168.391301,094.52 Jan. 12, 2026: 20 @ 8.42
March 1, 2026issueSO-260301-898MAIN 103 8.42-867.201501,262.91 Jan. 12, 2026: 103 @ 8.42
Feb. 18, 2026issueSO-260218-386MAIN 83 8.42-698.812532,130.11 Jan. 12, 2026: 83 @ 8.42
Feb. 11, 2026issueSO-260211-334MAIN 22 8.42-185.233362,828.92 Jan. 12, 2026: 22 @ 8.42
Feb. 10, 2026issueSO-260210-328MAIN 6 8.27-49.643583,014.15 Oct. 17, 2025: 4 @ 8.20; Jan. 12, 2026: 2 @ 8.42
Feb. 1, 2026issueSO-260201-471MAIN 5 8.20-41.003643,063.78 Oct. 17, 2025: 5 @ 8.20
Jan. 29, 2026issueSO-260129-633MAIN 1 8.20-8.203693,104.78 Oct. 17, 2025: 1 @ 8.20
Jan. 28, 2026issueSO-260128-459MAIN 1 8.20-8.203703,112.98 Oct. 17, 2025: 1 @ 8.20
Jan. 22, 2026issueSO-260122-541MAIN 23 8.20-188.593713,121.18 Oct. 17, 2025: 23 @ 8.20
Jan. 12, 2026receiptPO-001139MAIN 360 8.423,030.983943,309.76
Jan. 10, 2026issueSO-260110-930MAIN 2 8.20-16.4034278.78 Oct. 17, 2025: 2 @ 8.20
Jan. 7, 2026issueSO-260107-268MAIN 13 8.20-106.5936295.18 Oct. 17, 2025: 13 @ 8.20
Jan. 6, 2026issueSO-260106-822MAIN 34 8.20-278.7849401.77 Oct. 17, 2025: 34 @ 8.20
Jan. 1, 2026issueSO-260101-721MAIN 22 8.20-180.3983680.55 Oct. 17, 2025: 22 @ 8.20
Dec. 16, 2025issueSO-251216-804MAIN 57 8.20-467.37105860.94 Oct. 17, 2025: 57 @ 8.20
Dec. 9, 2025issueSO-251209-732MAIN 32 8.20-262.381621,328.30 Oct. 17, 2025: 32 @ 8.20
Dec. 9, 2025issueSO-251209-732EAST 52 8.20-426.371941,590.68 Oct. 17, 2025: 52 @ 8.20
Dec. 3, 2025issueSO-251203-950MAIN 15 8.20-122.992462,017.05 Oct. 17, 2025: 15 @ 8.20
Nov. 27, 2025issueSO-251127-699MAIN 3 8.20-24.602612,140.04 Oct. 17, 2025: 3 @ 8.20
Nov. 23, 2025issueSO-251123-426MAIN 58 8.20-475.572642,164.64 Oct. 17, 2025: 58 @ 8.20
Nov. 18, 2025issueSO-251118-221EAST 29 8.20-237.783222,640.21 Oct. 17, 2025: 29 @ 8.20
Nov. 2, 2025issueSO-251102-122MAIN 26 8.39-218.113512,877.99 Aug. 5, 2025: 9 @ 8.49; Sept. 20, 2025: 8 @ 8.49; Oct. 17, 2025: 9 @ 8.20
Oct. 27, 2025issueSO-251027-110MAIN 2 8.49-16.983773,096.10 Aug. 5, 2025: 2 @ 8.49
Oct. 17, 2025transferTRFMAIN → EAST 81 warehouse transfer, no cost effect
Oct. 17, 2025receiptPO-000927MAIN 360 8.202,951.783793,113.08
Oct. 13, 2025issueSO-251013-448MAIN 45 8.49-382.0119161.29 Aug. 5, 2025: 45 @ 8.49
Oct. 5, 2025issueSO-251005-232MAIN 51 8.49-432.9564543.31 Aug. 5, 2025: 51 @ 8.49
Sept. 29, 2025issueSO-250929-351MAIN 54 8.49-458.42115976.26 Aug. 5, 2025: 54 @ 8.49
Sept. 20, 2025returnRMAMAIN 8 8.4967.911691,434.67
Sept. 19, 2025issueSO-250919-176MAIN 1 8.49-8.491611,366.76 Aug. 5, 2025: 1 @ 8.49
Sept. 17, 2025issueSO-250917-775MAIN 6 8.49-50.941621,375.25 Aug. 5, 2025: 6 @ 8.49
Sept. 10, 2025issueSO-250910-168MAIN 17 8.49-144.321681,426.19 Aug. 5, 2025: 17 @ 8.49
Sept. 6, 2025issueSO-250906-672MAIN 12 8.49-101.871851,570.50 Aug. 5, 2025: 12 @ 8.49
Sept. 3, 2025issueSO-250903-979MAIN 32 8.49-271.651971,672.37 Aug. 5, 2025: 32 @ 8.49
Aug. 23, 2025issueSO-250823-748MAIN 59 8.49-500.862291,944.03 Aug. 5, 2025: 59 @ 8.49
Aug. 17, 2025issueSO-250817-326MAIN 72 8.49-611.222882,444.89 Aug. 5, 2025: 72 @ 8.49
Aug. 5, 2025receiptPO-000760MAIN 360 8.493,056.113603,056.11
July 28, 2025issueSO-250728-726MAIN 28 7.99-223.8000.00 April 21, 2025: 28 @ 7.99
July 28, 2025issueSO-250728-726EAST 57 7.99-455.5828223.80 April 21, 2025: 57 @ 7.99
July 16, 2025issueSO-250716-498MAIN 34 7.99-271.7585679.38 April 21, 2025: 34 @ 7.99
June 18, 2025issueSO-250618-104MAIN 24 7.99-191.82119951.13 April 21, 2025: 24 @ 7.99
June 14, 2025issueSO-250614-723MAIN 64 7.99-511.531431,142.96 April 21, 2025: 64 @ 7.99
May 17, 2025issueSO-250517-815MAIN 29 7.99-231.792071,654.49 April 21, 2025: 29 @ 7.99
May 16, 2025issueSO-250516-217MAIN 10 7.99-79.932361,886.28 April 21, 2025: 10 @ 7.99
May 7, 2025issueSO-250507-398EAST 35 7.99-279.742461,966.20 April 21, 2025: 35 @ 7.99
May 4, 2025issueSO-250504-692MAIN 45 7.99-359.672812,245.95 April 21, 2025: 45 @ 7.99
April 24, 2025issueSO-250424-231MAIN 71 8.03-570.283262,605.62 Dec. 24, 2024: 35 @ 8.07; Jan. 21, 2025: 2 @ 8.07; April 21, 2025: 34 @ 7.99
April 21, 2025transferTRFMAIN → EAST 92 warehouse transfer, no cost effect
April 21, 2025receiptPO-000468MAIN 360 7.992,877.373973,175.90
April 15, 2025issueSO-250415-718MAIN 34 8.07-274.3237298.52 Dec. 24, 2024: 34 @ 8.07
March 27, 2025issueSO-250327-696MAIN 42 8.07-338.8671572.84 Dec. 24, 2024: 42 @ 8.07
March 23, 2025issueSO-250323-233MAIN 8 8.07-64.55113911.71 Dec. 24, 2024: 8 @ 8.07
March 21, 2025issueSO-250321-865MAIN 2 8.07-16.14121976.25 Dec. 24, 2024: 2 @ 8.07
March 18, 2025issueSO-250318-574MAIN 5 8.07-40.34123992.39 Dec. 24, 2024: 5 @ 8.07
March 16, 2025issueSO-250316-473MAIN 5 8.07-40.341281,032.73 Dec. 24, 2024: 5 @ 8.07
March 1, 2025issueSO-250301-511MAIN 10 8.07-80.681331,073.07 Dec. 24, 2024: 10 @ 8.07
Feb. 22, 2025issueSO-250222-178MAIN 39 8.07-314.661431,153.75 Dec. 24, 2024: 39 @ 8.07
Feb. 6, 2025issueSO-250206-705MAIN 83 8.07-669.661821,468.41 Dec. 24, 2024: 83 @ 8.07
Jan. 21, 2025returnRMAMAIN 2 8.0716.142652,138.07
Jan. 17, 2025issueSO-250117-592MAIN 16 8.07-129.092632,121.94 Dec. 24, 2024: 16 @ 8.07
Jan. 6, 2025issueSO-250106-131MAIN 5 8.07-40.342792,251.03 Dec. 24, 2024: 5 @ 8.07
Jan. 5, 2025issueSO-250105-221MAIN 43 8.07-346.932842,291.37 Dec. 24, 2024: 43 @ 8.07
Jan. 4, 2025issueSO-250104-727MAIN 49 8.14-398.643272,638.30 Oct. 1, 2024: 16 @ 8.27; Dec. 24, 2024: 33 @ 8.07
Dec. 31, 2024issueSO-241231-317MAIN 4 8.27-33.103763,036.94 Oct. 1, 2024: 4 @ 8.27
Dec. 24, 2024receiptPO-000130MAIN 360 8.072,904.553803,070.04
Dec. 22, 2024issueSO-241222-666MAIN 10 8.27-82.7420165.49 Oct. 1, 2024: 10 @ 8.27
Dec. 17, 2024issueSO-241217-642MAIN 112 8.27-926.7430248.24 Oct. 1, 2024: 112 @ 8.27
Nov. 29, 2024issueSO-241129-932MAIN 1 8.27-8.271421,174.98 Oct. 1, 2024: 1 @ 8.27
Nov. 28, 2024issueSO-241128-370MAIN 5 8.27-41.371431,183.25 Oct. 1, 2024: 5 @ 8.27
Nov. 27, 2024issueSO-241127-787MAIN 74 8.27-612.311481,224.63 Oct. 1, 2024: 74 @ 8.27
Nov. 8, 2024issueSO-241108-664MAIN 19 8.27-157.222221,836.94 Oct. 1, 2024: 19 @ 8.27
Nov. 4, 2024issueSO-241104-851MAIN 2 8.27-16.552411,994.15 Oct. 1, 2024: 2 @ 8.27
Oct. 29, 2024issueSO-241029-837MAIN 1 8.27-8.272432,010.70 Oct. 1, 2024: 1 @ 8.27
Oct. 22, 2024issueSO-241022-157MAIN 55 8.27-455.102442,018.98 Oct. 1, 2024: 55 @ 8.27
Oct. 21, 2024issueSO-241021-943MAIN 8 8.27-66.202992,474.08 Oct. 1, 2024: 8 @ 8.27
Oct. 15, 2024issueSO-241015-221MAIN 14 8.27-115.843072,540.27 Oct. 1, 2024: 14 @ 8.27
Oct. 7, 2024issueSO-241007-804MAIN 13 8.27-107.573212,656.11 Oct. 1, 2024: 13 @ 8.27
Oct. 3, 2024issueSO-241003-621MAIN 1 8.27-8.273342,763.68 Oct. 1, 2024: 1 @ 8.27
Oct. 1, 2024issueSO-241001-269MAIN 25 8.27-206.863352,771.96 Oct. 1, 2024: 25 @ 8.27
Oct. 1, 2024receiptPO-000005MAIN 360 8.272,978.823602,978.82