stocksense

Items / SWT-0030

Bell Push Flex SWT-0030 · Switches & Sockets · Volta Electricals Pvt Ltd

On hand (EA)159MAIN 159
Value (FIFO)2,112.00avg 13.28
ClassBX / FCV 0.26
Turnover6.2xlast issue 1 days ago
Days of cover50lead time 7d

Demand and forecast

Monthly demand and forecast for SWT-00300.039.679.2119158Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 116.0Nov 24: 124.0Dec 24: 94.0Jan 25: 103.0Feb 25: 83.0Mar 25: 60.0Apr 25: 83.0May 25: 90.0Jun 25: 105.0Jul 25: 94.0Aug 25: 119.0Sep 25: 109.0Oct 25: 92.0Nov 25: 116.0Dec 25: 76.0Jan 26: 55.0Feb 26: 106.0Mar 26: 144.0Apr 26: 89.0May 26: 109.0Jun 26: 65.0Jul 26: 109.0Aug 26: 75.0Sep 26: 124.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.437596.67 / 30.43753.176
Daily demand sdmonthly sd / sqrt(30.4375)24.95 / 5.5174.522
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.522^2 + 3.176^2 * 1.5^2)21.2
Reorder pointd * LT + safety stock3.176 * 7.0 + 21.243.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days43.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1159/yr, S = 45.00, h = 20%, price = 12.98580.0
Inventory positionon hand + on order159 + 0159

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

From qtyUnit costOrder qtyAnnual costFeasible
013.5219616,204yes
58012.9858015,888yes (chosen if cheapest)
1,16012.441,16015,906yes

MOQ 290, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 9, 2026159 / 29013.282,112.00

Movement ledger 122 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-241MAIN 10 13.28-132.831592,112.00 Sept. 9, 2026: 10 @ 13.28
Oct. 11, 2026issueSO-261011-888MAIN 100 13.28-1,328.301692,244.83 Sept. 9, 2026: 100 @ 13.28
Oct. 3, 2026issueSO-261003-101MAIN 1 13.28-13.282693,573.13 Sept. 9, 2026: 1 @ 13.28
Sept. 15, 2026issueSO-260915-515MAIN 4 13.28-53.132703,586.41 Sept. 9, 2026: 4 @ 13.28
Sept. 12, 2026issueSO-260912-400MAIN 16 13.28-212.532743,639.54 Sept. 9, 2026: 16 @ 13.28
Sept. 9, 2026receiptPO-001786MAIN 290 13.283,852.072903,852.07
Sept. 4, 2026issueSO-260904-972MAIN 104 13.19-1,371.6800.00 June 21, 2026: 104 @ 13.19
Aug. 30, 2026issueSO-260830-319MAIN 18 13.19-237.411041,371.68 June 21, 2026: 18 @ 13.19
Aug. 25, 2026issueSO-260825-525MAIN 57 13.19-751.781221,609.08 June 21, 2026: 57 @ 13.19
July 24, 2026issueSO-260724-777MAIN 32 13.19-422.051792,360.87 June 21, 2026: 32 @ 13.19
July 23, 2026issueSO-260723-834MAIN 40 13.19-527.572112,782.92 June 21, 2026: 40 @ 13.19
July 19, 2026issueSO-260719-407MAIN 22 13.19-290.162513,310.49 June 21, 2026: 22 @ 13.19
July 11, 2026issueSO-260711-597MAIN 15 13.19-197.842733,600.65 June 21, 2026: 15 @ 13.19
June 29, 2026issueSO-260629-465MAIN 2 13.19-26.382883,798.49 June 21, 2026: 2 @ 13.19
June 21, 2026receiptPO-001592MAIN 290 13.193,824.872903,824.87
June 17, 2026issueSO-260617-525MAIN 14 13.47-188.5400.00 March 25, 2026: 14 @ 13.47
June 16, 2026issueSO-260616-695MAIN 12 13.47-161.6114188.54 March 25, 2026: 12 @ 13.47
June 13, 2026issueSO-260613-724MAIN 37 13.47-498.2926350.15 March 25, 2026: 37 @ 13.47
May 28, 2026issueSO-260528-729MAIN 13 13.47-175.0763848.44 March 25, 2026: 13 @ 13.47
May 20, 2026issueSO-260520-415MAIN 4 13.47-53.87761,023.51 March 25, 2026: 4 @ 13.47
May 16, 2026issueSO-260516-313MAIN 6 13.47-80.80801,077.38 March 25, 2026: 6 @ 13.47
May 9, 2026issueSO-260509-317MAIN 3 13.47-40.40861,158.19 March 25, 2026: 3 @ 13.47
May 2, 2026issueSO-260502-453MAIN 83 13.47-1,117.79891,198.59 March 25, 2026: 83 @ 13.47
April 25, 2026issueSO-260425-885MAIN 4 13.47-53.871722,316.38 March 25, 2026: 4 @ 13.47
April 22, 2026issueSO-260422-698MAIN 47 13.47-632.961762,370.24 March 25, 2026: 47 @ 13.47
April 8, 2026issueSO-260408-294MAIN 37 13.47-498.292233,003.21 March 25, 2026: 37 @ 13.47
April 6, 2026issueSO-260406-601MAIN 1 13.47-13.472603,501.50 March 25, 2026: 1 @ 13.47
March 29, 2026issueSO-260329-459MAIN 12 13.47-161.612613,514.97 March 25, 2026: 12 @ 13.47
March 28, 2026issueSO-260328-621MAIN 21 13.39-281.182733,676.57 Dec. 17, 2025: 4 @ 13.06; March 25, 2026: 17 @ 13.47
March 25, 2026receiptPO-001354MAIN 290 13.473,905.522943,957.75
March 21, 2026issueSO-260321-469MAIN 64 13.06-835.73452.23 Dec. 17, 2025: 64 @ 13.06
March 3, 2026issueSO-260303-799MAIN 47 13.06-613.7468887.96 Dec. 17, 2025: 47 @ 13.06
Feb. 28, 2026issueSO-260228-332MAIN 75 13.06-979.371151,501.70 Dec. 17, 2025: 75 @ 13.06
Feb. 27, 2026issueSO-260227-449MAIN 31 13.06-404.811902,481.08 Dec. 17, 2025: 31 @ 13.06
Jan. 30, 2026issueSO-260130-601MAIN 3 13.06-39.172212,885.88 Dec. 17, 2025: 3 @ 13.06
Jan. 25, 2026issueSO-260125-807MAIN 1 13.06-13.062242,925.06 Dec. 17, 2025: 1 @ 13.06
Jan. 9, 2026issueSO-260109-138MAIN 38 13.06-496.222252,938.12 Dec. 17, 2025: 38 @ 13.06
Jan. 3, 2026issueSO-260103-304MAIN 12 13.06-156.702633,434.33 Dec. 17, 2025: 12 @ 13.06
Jan. 2, 2026issueSO-260102-886MAIN 1 13.06-13.062753,591.03 Dec. 17, 2025: 1 @ 13.06
Dec. 22, 2025issueSO-251222-459MAIN 10 13.06-130.582763,604.09 Dec. 17, 2025: 10 @ 13.06
Dec. 17, 2025issueSO-251217-663MAIN 4 13.06-52.232863,734.67 Dec. 17, 2025: 4 @ 13.06
Dec. 17, 2025receiptPO-001059MAIN 290 13.063,786.912903,786.91
Dec. 16, 2025issueSO-251216-529MAIN 10 13.17-131.7200.00 Sept. 10, 2025: 10 @ 13.17
Dec. 11, 2025issueSO-251211-226MAIN 5 13.17-65.8610131.72 Sept. 10, 2025: 5 @ 13.17
Dec. 9, 2025issueSO-251209-609MAIN 33 13.17-434.6815197.58 Sept. 10, 2025: 33 @ 13.17
Dec. 6, 2025issueSO-251206-548MAIN 14 13.17-184.4148632.26 Sept. 10, 2025: 14 @ 13.17
Nov. 29, 2025issueSO-251129-789MAIN 2 13.17-26.3462816.66 Sept. 10, 2025: 2 @ 13.17
Nov. 28, 2025issueSO-251128-823MAIN 23 13.17-302.9664843.01 Sept. 10, 2025: 23 @ 13.17
Nov. 16, 2025issueSO-251116-427MAIN 12 13.17-158.06871,145.96 Sept. 10, 2025: 12 @ 13.17
Nov. 12, 2025issueSO-251112-630MAIN 29 13.17-381.99991,304.03 Sept. 10, 2025: 29 @ 13.17
Nov. 11, 2025issueSO-251111-144MAIN 11 13.17-144.891281,686.02 Sept. 10, 2025: 11 @ 13.17
Nov. 4, 2025issueSO-251104-754MAIN 39 13.17-513.711391,830.91 Sept. 10, 2025: 39 @ 13.17
Oct. 26, 2025issueSO-251026-337MAIN 11 13.17-144.891782,344.62 Sept. 10, 2025: 11 @ 13.17
Oct. 19, 2025issueSO-251019-399MAIN 28 13.17-368.821892,489.51 Sept. 10, 2025: 28 @ 13.17
Oct. 19, 2025issueSO-251019-399EAST 21 13.17-276.612172,858.32 Sept. 10, 2025: 21 @ 13.17
Oct. 15, 2025issueSO-251015-500EAST 5 13.17-65.862383,134.94 Sept. 10, 2025: 5 @ 13.17
Oct. 5, 2025issueSO-251005-337MAIN 16 13.17-210.752433,200.80 Sept. 10, 2025: 16 @ 13.17
Oct. 3, 2025issueSO-251003-344MAIN 11 13.17-144.892593,411.55 Sept. 10, 2025: 11 @ 13.17
Sept. 17, 2025issueSO-250917-354MAIN 34 13.05-443.772703,556.44 June 27, 2025: 14 @ 12.88; Sept. 10, 2025: 20 @ 13.17
Sept. 16, 2025issueSO-250916-800EAST 8 12.88-103.053044,000.21 June 27, 2025: 8 @ 12.88
Sept. 11, 2025issueSO-250911-783MAIN 12 12.88-154.573124,103.26 June 27, 2025: 12 @ 12.88
Sept. 10, 2025receiptPO-000829MAIN 290 13.173,819.883244,257.83
Sept. 7, 2025issueSO-250907-803EAST 2 12.88-25.7634437.95 June 27, 2025: 2 @ 12.88
Sept. 4, 2025issueSO-250904-365EAST 14 12.88-180.3336463.71 June 27, 2025: 14 @ 12.88
Sept. 4, 2025issueSO-250904-365MAIN 6 12.88-77.2950644.04 June 27, 2025: 6 @ 12.88
Sept. 2, 2025issueSO-250902-152EAST 33 12.88-425.0756721.33 June 27, 2025: 33 @ 12.88
Aug. 29, 2025issueSO-250829-871MAIN 40 12.88-515.24891,146.40 June 27, 2025: 40 @ 12.88
Aug. 8, 2025issueSO-250808-519MAIN 69 12.88-888.781291,661.64 June 27, 2025: 69 @ 12.88
Aug. 5, 2025issueSO-250805-386MAIN 10 12.88-128.811982,550.42 June 27, 2025: 10 @ 12.88
July 29, 2025issueSO-250729-681EAST 6 12.88-77.292082,679.23 June 27, 2025: 6 @ 12.88
July 23, 2025issueSO-250723-651MAIN 17 12.88-218.982142,756.51 June 27, 2025: 17 @ 12.88
July 10, 2025issueSO-250710-294MAIN 39 12.88-502.362312,975.49 June 27, 2025: 39 @ 12.88
July 8, 2025issueSO-250708-597EAST 3 12.88-38.642703,477.84 June 27, 2025: 3 @ 12.88
July 3, 2025issueSO-250703-869MAIN 29 12.84-372.402733,516.49 March 23, 2025: 12 @ 12.79; June 27, 2025: 17 @ 12.88
June 29, 2025issueSO-250629-652MAIN 22 12.79-281.283023,888.89 March 23, 2025: 22 @ 12.79
June 27, 2025transferTRFMAIN → EAST 58 warehouse transfer, no cost effect
June 27, 2025receiptPO-000671MAIN 290 12.883,735.463244,170.16
June 20, 2025issueSO-250620-852EAST 23 12.79-294.0634434.70 March 23, 2025: 23 @ 12.79
June 20, 2025issueSO-250620-852MAIN 54 12.79-690.4157728.77 March 23, 2025: 54 @ 12.79
June 15, 2025issueSO-250615-368EAST 5 12.79-63.931111,419.18 March 23, 2025: 5 @ 12.79
June 12, 2025issueSO-250612-347MAIN 1 12.79-12.791161,483.11 March 23, 2025: 1 @ 12.79
May 29, 2025issueSO-250529-818MAIN 11 12.79-140.641171,495.89 March 23, 2025: 11 @ 12.79
May 24, 2025issueSO-250524-371EAST 34 12.79-434.701281,636.53 March 23, 2025: 34 @ 12.79
May 13, 2025issueSO-250513-311MAIN 8 12.79-102.281622,071.23 March 23, 2025: 8 @ 12.79
May 2, 2025issueSO-250502-556MAIN 3 12.79-38.361702,173.52 March 23, 2025: 3 @ 12.79
May 1, 2025issueSO-250501-406MAIN 34 12.79-434.701732,211.87 March 23, 2025: 34 @ 12.79
April 27, 2025issueSO-250427-364MAIN 13 12.79-166.212072,646.58 March 23, 2025: 13 @ 12.79
April 22, 2025issueSO-250422-315MAIN 34 12.79-434.702202,812.79 March 23, 2025: 34 @ 12.79
April 20, 2025issueSO-250420-967MAIN 5 12.79-63.932543,247.49 March 23, 2025: 5 @ 12.79
April 11, 2025issueSO-250411-686MAIN 13 12.79-166.212593,311.42 March 23, 2025: 13 @ 12.79
April 5, 2025issueSO-250405-310MAIN 18 12.79-230.142723,477.63 March 23, 2025: 18 @ 12.79
March 23, 2025transferTRFMAIN → EAST 96 warehouse transfer, no cost effect
March 23, 2025receiptPO-000369MAIN 290 12.793,707.772903,707.77
March 19, 2025issueSO-250319-781MAIN 24 12.66-303.7400.00 Dec. 10, 2024: 24 @ 12.66
March 14, 2025issueSO-250314-452MAIN 36 12.66-455.6224303.74 Dec. 10, 2024: 36 @ 12.66
Feb. 25, 2025issueSO-250225-348MAIN 5 12.66-63.2860759.36 Dec. 10, 2024: 5 @ 12.66
Feb. 24, 2025issueSO-250224-890MAIN 36 12.66-455.6265822.64 Dec. 10, 2024: 36 @ 12.66
Feb. 20, 2025issueSO-250220-279MAIN 1 12.66-12.661011,278.26 Dec. 10, 2024: 1 @ 12.66
Feb. 16, 2025issueSO-250216-281MAIN 4 12.66-50.621021,290.91 Dec. 10, 2024: 4 @ 12.66
Feb. 13, 2025issueSO-250213-154MAIN 37 12.66-468.271061,341.54 Dec. 10, 2024: 37 @ 12.66
Jan. 28, 2025issueSO-250128-555MAIN 41 12.66-518.901431,809.81 Dec. 10, 2024: 41 @ 12.66
Jan. 28, 2025issueSO-250128-555EAST 58 12.66-734.051842,328.70 Dec. 10, 2024: 58 @ 12.66
Jan. 18, 2025issueSO-250118-556EAST 4 12.66-50.622423,062.75 Dec. 10, 2024: 4 @ 12.66
Dec. 29, 2024issueSO-241229-563MAIN 36 12.66-455.622463,113.38 Dec. 10, 2024: 36 @ 12.66
Dec. 10, 2024issueSO-241210-476MAIN 34 12.80-435.192823,568.99 Oct. 1, 2024: 26 @ 12.84; Dec. 10, 2024: 8 @ 12.66
Dec. 10, 2024transferTRFMAIN → EAST 62 warehouse transfer, no cost effect
Dec. 10, 2024receiptPO-000089MAIN 290 12.663,670.243164,004.18
Dec. 3, 2024issueSO-241203-823MAIN 24 12.84-308.2626333.94 Oct. 1, 2024: 24 @ 12.84
Nov. 28, 2024issueSO-241128-287MAIN 1 12.84-12.8450642.20 Oct. 1, 2024: 1 @ 12.84
Nov. 21, 2024issueSO-241121-347MAIN 28 12.84-359.6351655.04 Oct. 1, 2024: 28 @ 12.84
Nov. 19, 2024issueSO-241119-898MAIN 2 12.84-25.69791,014.68 Oct. 1, 2024: 2 @ 12.84
Nov. 15, 2024issueSO-241115-197MAIN 31 12.84-398.16811,040.36 Oct. 1, 2024: 31 @ 12.84
Nov. 9, 2024issueSO-241109-359MAIN 30 12.84-385.321121,438.53 Oct. 1, 2024: 30 @ 12.84
Nov. 8, 2024issueSO-241108-737MAIN 16 12.84-205.501421,823.85 Oct. 1, 2024: 16 @ 12.84
Nov. 3, 2024issueSO-241103-229MAIN 16 12.84-205.501582,029.35 Oct. 1, 2024: 16 @ 12.84
Oct. 27, 2024issueSO-241027-363MAIN 16 12.84-205.501742,234.86 Oct. 1, 2024: 16 @ 12.84
Oct. 21, 2024issueSO-241021-890MAIN 14 12.84-179.821902,440.36 Oct. 1, 2024: 14 @ 12.84
Oct. 19, 2024issueSO-241019-727MAIN 17 12.84-218.352042,620.18 Oct. 1, 2024: 17 @ 12.84
Oct. 11, 2024issueSO-241011-393MAIN 22 12.84-282.572212,838.52 Oct. 1, 2024: 22 @ 12.84
Oct. 8, 2024issueSO-241008-624MAIN 16 12.84-205.502433,121.09 Oct. 1, 2024: 16 @ 12.84
Oct. 4, 2024issueSO-241004-467MAIN 31 12.84-398.162593,326.60 Oct. 1, 2024: 31 @ 12.84
Oct. 1, 2024receiptPO-000005MAIN 290 12.843,724.762903,724.76