stocksense

Items / SWT-0012

Bell Push Pro SWT-0012 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)174MAIN 174
Value (FIFO)4,951.71avg 28.46
ClassBX / FCV 0.21
Turnover4.9xlast issue 1 days ago
Days of cover67lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00120.030.561.191.6122Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 65.0Nov 24: 66.0Dec 24: 81.0Jan 25: 82.0Feb 25: 67.0Mar 25: 74.0Apr 25: 82.0May 25: 98.0Jun 25: 57.0Jul 25: 111.0Aug 25: 95.0Sep 25: 79.0Oct 25: 75.0Nov 25: 99.0Dec 25: 60.0Jan 26: 76.0Feb 26: 103.0Mar 26: 99.0Apr 26: 58.0May 26: 77.0Jun 26: 91.0Jul 26: 56.0Aug 26: 62.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.437578.58 / 30.43752.582
Daily demand sdmonthly sd / sqrt(30.4375)16.41 / 5.5172.974
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 * 2.974^2 + 2.582^2 * 1.5^2)14.5
Reorder pointd * LT + safety stock2.582 * 7.0 + 14.532.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days32.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 942/yr, S = 45.00, h = 20%, price = 28.95121.0
Inventory positionon hand + on order174 + 0174

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

From qtyUnit costOrder qtyAnnual costFeasible
028.9512127,982yes (chosen if cheapest)

MOQ 240, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 3, 2026174 / 24028.464,951.71

Movement ledger 127 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-855MAIN 25 28.46-711.451744,951.71 Oct. 3, 2026: 25 @ 28.46
Oct. 14, 2026issueSO-261014-241MAIN 9 28.46-256.121995,663.16 Oct. 3, 2026: 9 @ 28.46
Oct. 13, 2026issueSO-261013-358MAIN 9 28.46-256.122085,919.28 Oct. 3, 2026: 9 @ 28.46
Oct. 12, 2026issueSO-261012-808MAIN 3 28.46-85.372176,175.41 Oct. 3, 2026: 3 @ 28.46
Oct. 9, 2026issueSO-261009-245MAIN 36 28.44-1,023.672206,260.78 June 16, 2026: 16 @ 28.41; Oct. 3, 2026: 20 @ 28.46
Oct. 4, 2026issueSO-261004-700MAIN 4 28.41-113.632567,284.46 June 16, 2026: 4 @ 28.41
Oct. 3, 2026receiptPO-001848MAIN 240 28.466,829.942607,398.08
Sept. 25, 2026issueSO-260925-930MAIN 44 28.41-1,249.9120568.14 June 16, 2026: 44 @ 28.41
Sept. 21, 2026issueSO-260921-775MAIN 7 28.41-198.85641,818.05 June 16, 2026: 7 @ 28.41
Sept. 18, 2026issueSO-260918-488MAIN 18 28.41-511.33712,016.90 June 16, 2026: 18 @ 28.41
Sept. 16, 2026issueSO-260916-467MAIN 16 28.41-454.51892,528.22 June 16, 2026: 16 @ 28.41
Sept. 11, 2026issueSO-260911-884MAIN 2 28.41-56.811052,982.74 June 16, 2026: 2 @ 28.41
Aug. 28, 2026issueSO-260828-838MAIN 14 28.41-397.701073,039.55 June 16, 2026: 14 @ 28.41
Aug. 22, 2026issueSO-260822-108MAIN 9 28.41-255.661213,437.25 June 16, 2026: 9 @ 28.41
Aug. 6, 2026issueSO-260806-543MAIN 6 28.41-170.441303,692.91 June 16, 2026: 6 @ 28.41
Aug. 4, 2026issueSO-260804-863MAIN 13 28.41-369.291363,863.35 June 16, 2026: 13 @ 28.41
Aug. 2, 2026issueSO-260802-178MAIN 20 28.41-568.141494,232.64 June 16, 2026: 20 @ 28.41
July 31, 2026issueSO-260731-305MAIN 1 28.41-28.411694,800.78 June 16, 2026: 1 @ 28.41
July 28, 2026issueSO-260728-352MAIN 7 28.41-198.851704,829.19 June 16, 2026: 7 @ 28.41
July 22, 2026issueSO-260722-398MAIN 2 28.41-56.811775,028.04 June 16, 2026: 2 @ 28.41
July 10, 2026issueSO-260710-669MAIN 5 28.41-142.041795,084.85 June 16, 2026: 5 @ 28.41
July 10, 2026issueSO-260710-669EAST 18 28.41-511.331845,226.89 June 16, 2026: 18 @ 28.41
July 1, 2026issueSO-260701-406EAST 23 28.41-653.362025,738.21 June 16, 2026: 23 @ 28.41
June 20, 2026issueSO-260620-615MAIN 20 28.20-564.072256,391.58 March 25, 2026: 5 @ 27.59; June 16, 2026: 15 @ 28.41
June 19, 2026issueSO-260619-212MAIN 11 27.59-303.522456,955.64 March 25, 2026: 11 @ 27.59
June 18, 2026issueSO-260618-690EAST 10 27.59-275.932567,259.16 March 25, 2026: 10 @ 27.59
June 16, 2026transferTRFMAIN → EAST 51 warehouse transfer, no cost effect
June 16, 2026receiptPO-001580MAIN 240 28.416,817.682667,535.09
June 10, 2026issueSO-260610-792MAIN 43 27.59-1,186.4926717.41 March 25, 2026: 43 @ 27.59
June 8, 2026issueSO-260608-643MAIN 7 27.59-193.15691,903.90 March 25, 2026: 7 @ 27.59
May 31, 2026issueSO-260531-322MAIN 6 27.59-165.56762,097.05 March 25, 2026: 6 @ 27.59
May 15, 2026issueSO-260515-889MAIN 38 27.59-1,048.52822,262.60 March 25, 2026: 38 @ 27.59
May 15, 2026issueSO-260515-889EAST 32 27.59-882.971203,311.12 March 25, 2026: 32 @ 27.59
May 8, 2026issueSO-260508-805MAIN 1 27.59-27.591524,194.09 March 25, 2026: 1 @ 27.59
April 28, 2026issueSO-260428-114MAIN 30 27.59-827.781534,221.68 March 25, 2026: 30 @ 27.59
April 25, 2026issueSO-260425-463MAIN 4 27.59-110.371835,049.46 March 25, 2026: 4 @ 27.59
April 20, 2026issueSO-260420-784MAIN 5 27.59-137.961875,159.83 March 25, 2026: 5 @ 27.59
April 18, 2026issueSO-260418-993EAST 19 27.59-524.261925,297.80 March 25, 2026: 19 @ 27.59
March 29, 2026issueSO-260329-109MAIN 63 27.53-1,734.552115,822.06 Dec. 24, 2025: 30 @ 27.48; Feb. 8, 2026: 4 @ 27.48; March 25, 2026: 29 @ 27.59
March 25, 2026transferTRFMAIN → EAST 51 warehouse transfer, no cost effect
March 25, 2026receiptPO-001353MAIN 240 27.596,622.252747,556.61
March 23, 2026issueSO-260323-571MAIN 1 27.48-27.4834934.36 Dec. 24, 2025: 1 @ 27.48
March 19, 2026issueSO-260319-374MAIN 12 27.48-329.7735961.84 Dec. 24, 2025: 12 @ 27.48
March 1, 2026issueSO-260301-493MAIN 23 27.48-632.07471,291.62 Dec. 24, 2025: 23 @ 27.48
Feb. 12, 2026issueSO-260212-279MAIN 61 27.48-1,676.35701,923.68 Dec. 24, 2025: 61 @ 27.48
Feb. 10, 2026issueSO-260210-531MAIN 6 27.48-164.891313,600.04 Dec. 24, 2025: 6 @ 27.48
Feb. 8, 2026returnRMAMAIN 4 27.48109.921373,764.92
Feb. 7, 2026issueSO-260207-965MAIN 32 27.48-879.401333,655.00 Dec. 24, 2025: 32 @ 27.48
Feb. 1, 2026issueSO-260201-648MAIN 8 27.48-219.851654,534.40 Dec. 24, 2025: 8 @ 27.48
Jan. 22, 2026issueSO-260122-458MAIN 36 27.48-989.321734,754.25 Dec. 24, 2025: 36 @ 27.48
Jan. 19, 2026issueSO-260119-161MAIN 2 27.48-54.962095,743.57 Dec. 24, 2025: 2 @ 27.48
Jan. 17, 2026issueSO-260117-422MAIN 10 27.48-274.812115,798.53 Dec. 24, 2025: 10 @ 27.48
Jan. 10, 2026issueSO-260110-913MAIN 7 27.48-192.372216,073.35 Dec. 24, 2025: 7 @ 27.48
Jan. 10, 2026issueSO-260110-913EAST 16 27.68-442.962286,265.71 Oct. 1, 2025: 4 @ 28.30; Dec. 24, 2025: 12 @ 27.48
Jan. 4, 2026issueSO-260104-757MAIN 5 28.30-141.482446,708.67 Oct. 1, 2025: 5 @ 28.30
Dec. 30, 2025issueSO-251230-576MAIN 7 28.30-198.072496,850.15 Oct. 1, 2025: 7 @ 28.30
Dec. 24, 2025receiptPO-001083MAIN 240 27.486,595.492567,048.22
Dec. 18, 2025issueSO-251218-584EAST 38 28.30-1,075.2416452.73 Oct. 1, 2025: 38 @ 28.30
Dec. 11, 2025issueSO-251211-224EAST 15 28.30-424.44541,527.98 Oct. 1, 2025: 15 @ 28.30
Nov. 18, 2025issueSO-251118-370EAST 12 28.30-339.55691,952.42 Oct. 1, 2025: 12 @ 28.30
Nov. 15, 2025issueSO-251115-211EAST 5 28.30-141.48812,291.97 Oct. 1, 2025: 5 @ 28.30
Nov. 15, 2025issueSO-251115-211MAIN 55 28.30-1,556.27862,433.45 Oct. 1, 2025: 55 @ 28.30
Nov. 1, 2025issueSO-251101-419MAIN 27 28.30-763.991413,989.72 Oct. 1, 2025: 27 @ 28.30
Oct. 26, 2025issueSO-251026-787MAIN 25 28.30-707.401684,753.71 Oct. 1, 2025: 25 @ 28.30
Oct. 23, 2025issueSO-251023-140MAIN 28 28.30-792.291935,461.11 Oct. 1, 2025: 28 @ 28.30
Oct. 22, 2025issueSO-251022-398MAIN 7 28.30-198.072216,253.39 Oct. 1, 2025: 7 @ 28.30
Oct. 17, 2025issueSO-251017-202MAIN 14 28.10-393.462286,451.47 July 6, 2025: 1 @ 26.96; July 31, 2025: 1 @ 26.96; Oct. 1, 2025: 12 @ 28.30
Oct. 10, 2025issueSO-251010-329MAIN 1 26.96-26.962426,844.93 July 6, 2025: 1 @ 26.96
Oct. 1, 2025transferTRFMAIN → EAST 83 warehouse transfer, no cost effect
Oct. 1, 2025receiptPO-000892MAIN 240 28.306,791.022436,871.88
Sept. 24, 2025issueSO-250924-913EAST 39 26.96-1,051.27380.87 July 6, 2025: 39 @ 26.96
Sept. 20, 2025issueSO-250920-888EAST 2 26.96-53.91421,132.14 July 6, 2025: 2 @ 26.96
Sept. 17, 2025issueSO-250917-488EAST 5 26.96-134.78441,186.05 July 6, 2025: 5 @ 26.96
Sept. 17, 2025issueSO-250917-488MAIN 25 26.96-673.89491,320.82 July 6, 2025: 25 @ 26.96
Sept. 11, 2025issueSO-250911-557MAIN 8 26.96-215.64741,994.71 July 6, 2025: 8 @ 26.96
Aug. 31, 2025issueSO-250831-570MAIN 91 26.96-2,452.96822,210.36 July 6, 2025: 91 @ 26.96
Aug. 11, 2025issueSO-250811-708MAIN 4 26.96-107.821734,663.32 July 6, 2025: 4 @ 26.96
July 31, 2025returnRMAMAIN 1 26.9626.961774,771.14
July 28, 2025issueSO-250728-505MAIN 14 26.96-377.381764,744.19 July 6, 2025: 14 @ 26.96
July 22, 2025issueSO-250722-611MAIN 14 26.96-377.381905,121.56 July 6, 2025: 14 @ 26.96
July 18, 2025issueSO-250718-278MAIN 35 26.96-943.452045,498.94 July 6, 2025: 35 @ 26.96
July 13, 2025issueSO-250713-190EAST 1 26.96-26.962396,442.39 July 6, 2025: 1 @ 26.96
July 6, 2025transferTRFMAIN → EAST 50 warehouse transfer, no cost effect
July 6, 2025receiptPO-000688MAIN 240 26.966,469.342406,469.34
July 3, 2025issueSO-250703-767MAIN 4 27.48-109.9100.00 April 8, 2025: 4 @ 27.48
July 1, 2025issueSO-250701-199MAIN 44 27.48-1,208.974109.91 April 8, 2025: 44 @ 27.48
June 24, 2025issueSO-250624-119MAIN 37 27.48-1,016.63481,318.88 April 8, 2025: 37 @ 27.48
June 24, 2025issueSO-250624-119EAST 9 27.48-247.29852,335.51 April 8, 2025: 9 @ 27.48
June 22, 2025issueSO-250622-202MAIN 1 27.48-27.48942,582.80 April 8, 2025: 1 @ 27.48
June 9, 2025issueSO-250609-676EAST 10 27.48-274.77952,610.28 April 8, 2025: 10 @ 27.48
May 29, 2025issueSO-250529-864MAIN 34 27.48-934.201052,885.04 April 8, 2025: 34 @ 27.48
May 27, 2025issueSO-250527-843MAIN 33 27.48-906.731393,819.25 April 8, 2025: 33 @ 27.48
May 16, 2025issueSO-250516-278MAIN 31 27.48-851.771724,725.98 April 8, 2025: 31 @ 27.48
April 14, 2025issueSO-250414-387MAIN 6 27.48-164.862035,577.75 April 8, 2025: 6 @ 27.48
April 12, 2025issueSO-250412-922EAST 31 27.48-851.772095,742.61 April 8, 2025: 31 @ 27.48
April 8, 2025transferTRFMAIN → EAST 50 warehouse transfer, no cost effect
April 8, 2025receiptPO-000425MAIN 240 27.486,594.382406,594.38
April 1, 2025issueSO-250401-141MAIN 45 26.45-1,190.1000.00 Jan. 5, 2025: 45 @ 26.45
March 31, 2025issueSO-250331-255MAIN 4 26.45-105.79451,190.10 Jan. 5, 2025: 4 @ 26.45
March 22, 2025issueSO-250322-628MAIN 8 26.45-211.57491,295.89 Jan. 5, 2025: 8 @ 26.45
March 20, 2025issueSO-250320-832MAIN 26 26.45-687.61571,507.46 Jan. 5, 2025: 26 @ 26.45
March 10, 2025issueSO-250310-447MAIN 36 26.45-952.08832,195.08 Jan. 5, 2025: 36 @ 26.45
Feb. 25, 2025issueSO-250225-150MAIN 1 26.45-26.451193,147.16 Jan. 5, 2025: 1 @ 26.45
Feb. 16, 2025issueSO-250216-951MAIN 14 26.45-370.251203,173.60 Jan. 5, 2025: 14 @ 26.45
Feb. 9, 2025issueSO-250209-439MAIN 1 26.45-26.451343,543.86 Jan. 5, 2025: 1 @ 26.45
Feb. 8, 2025issueSO-250208-493MAIN 5 26.45-132.231353,570.30 Jan. 5, 2025: 5 @ 26.45
Feb. 2, 2025issueSO-250202-707MAIN 46 26.45-1,216.551403,702.54 Jan. 5, 2025: 46 @ 26.45
Jan. 27, 2025issueSO-250127-876MAIN 29 26.45-766.951864,919.09 Jan. 5, 2025: 29 @ 26.45
Jan. 26, 2025issueSO-250126-906MAIN 30 26.62-798.682155,686.04 Oct. 1, 2024: 5 @ 27.50; Jan. 5, 2025: 25 @ 26.45
Jan. 25, 2025issueSO-250125-464MAIN 3 27.50-82.512456,484.72 Oct. 1, 2024: 3 @ 27.50
Jan. 24, 2025issueSO-250124-822MAIN 12 27.50-330.032486,567.23 Oct. 1, 2024: 12 @ 27.50
Jan. 23, 2025issueSO-250123-861MAIN 4 27.50-110.012606,897.26 Oct. 1, 2024: 4 @ 27.50
Jan. 18, 2025issueSO-250118-890MAIN 3 27.50-82.512647,007.27 Oct. 1, 2024: 3 @ 27.50
Jan. 15, 2025issueSO-250115-419MAIN 1 27.50-27.502677,089.78 Oct. 1, 2024: 1 @ 27.50
Jan. 5, 2025receiptPO-000163MAIN 240 26.456,347.212687,117.28
Dec. 27, 2024issueSO-241227-994MAIN 24 27.50-660.0628770.07 Oct. 1, 2024: 24 @ 27.50
Dec. 14, 2024issueSO-241214-459MAIN 16 27.50-440.04521,430.13 Oct. 1, 2024: 16 @ 27.50
Dec. 7, 2024issueSO-241207-384MAIN 23 27.50-632.56681,870.17 Oct. 1, 2024: 23 @ 27.50
Dec. 6, 2024issueSO-241206-810MAIN 17 27.50-467.54912,502.73 Oct. 1, 2024: 17 @ 27.50
Dec. 4, 2024issueSO-241204-806MAIN 1 27.50-27.501082,970.27 Oct. 1, 2024: 1 @ 27.50
Nov. 29, 2024issueSO-241129-139MAIN 16 27.50-440.041092,997.77 Oct. 1, 2024: 16 @ 27.50
Nov. 28, 2024issueSO-241128-249MAIN 1 27.50-27.501253,437.81 Oct. 1, 2024: 1 @ 27.50
Nov. 21, 2024issueSO-241121-801MAIN 2 27.50-55.001263,465.32 Oct. 1, 2024: 2 @ 27.50
Nov. 12, 2024issueSO-241112-676MAIN 47 27.50-1,292.621283,520.32 Oct. 1, 2024: 47 @ 27.50
Oct. 19, 2024issueSO-241019-137MAIN 8 27.50-220.021754,812.94 Oct. 1, 2024: 8 @ 27.50
Oct. 15, 2024issueSO-241015-714MAIN 57 27.50-1,567.641835,032.96 Oct. 1, 2024: 57 @ 27.50
Oct. 1, 2024receiptPO-000005MAIN 240 27.506,600.602406,600.60