stocksense

Items / MCB-0020

MCB 32A TP Elite MCB-0020 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)18MAIN 18
Value (FIFO)996.61avg 55.37
ClassBX / FCV 0.32
Turnover13.6xlast issue 7 days ago
Days of cover19lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00200.016.833.650.367.1Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 45.0Nov 24: 28.0Dec 24: 31.0Jan 25: 27.0Feb 25: 16.0Mar 25: 8.0Apr 25: 33.0May 25: 61.0Jun 25: 9.0Jul 25: 25.0Aug 25: 12.0Sep 25: 9.0Oct 25: 36.0Nov 25: 14.0Dec 25: 27.0Jan 26: 34.0Feb 26: 23.0Mar 26: 27.0Apr 26: 23.0May 26: 24.0Jun 26: 33.0Jul 26: 38.0Aug 26: 53.0Sep 26: 23.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.437529.58 / 30.43750.972
Daily demand sdmonthly sd / sqrt(30.4375)9.61 / 5.5171.742
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 * 1.742^2 + 0.972^2 * 1.5^2)8.0
Reorder pointd * LT + safety stock0.972 * 7.0 + 8.014.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days14.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 355/yr, S = 45.00, h = 20%, price = 51.18112.0
Inventory positionon hand + on order18 + 018

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

From qtyUnit costOrder qtyAnnual costFeasible
055.635420,331yes
5653.405619,530yes
11251.1811218,872yes (chosen if cheapest)

MOQ 28, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 19, 202611 / 4955.27607.98
Aug. 29, 20267 / 755.52388.63

Movement ledger 126 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 9, 2026issueSO-261009-629MAIN 2 55.27-110.5418996.61 Aug. 19, 2026: 2 @ 55.27
Oct. 8, 2026issueSO-261008-735MAIN 6 55.27-331.63201,107.15 Aug. 19, 2026: 6 @ 55.27
Oct. 6, 2026issueSO-261006-692MAIN 2 55.27-110.54261,438.78 Aug. 19, 2026: 2 @ 55.27
Oct. 3, 2026issueSO-261003-415MAIN 5 55.27-276.35281,549.32 Aug. 19, 2026: 5 @ 55.27
Sept. 22, 2026issueSO-260922-253MAIN 4 55.27-221.08331,825.67 Aug. 19, 2026: 4 @ 55.27
Sept. 16, 2026issueSO-260916-747MAIN 7 55.27-386.90372,046.76 Aug. 19, 2026: 7 @ 55.27
Sept. 12, 2026issueSO-260912-378MAIN 1 55.27-55.27442,433.65 Aug. 19, 2026: 1 @ 55.27
Sept. 6, 2026issueSO-260906-414MAIN 4 55.27-221.08452,488.92 Aug. 19, 2026: 4 @ 55.27
Sept. 3, 2026issueSO-260903-721MAIN 1 55.27-55.27492,710.01 Aug. 19, 2026: 1 @ 55.27
Sept. 1, 2026issueSO-260901-697MAIN 6 55.27-331.63502,765.28 Aug. 19, 2026: 6 @ 55.27
Aug. 29, 2026returnRMAMAIN 7 55.52388.63563,096.90
Aug. 22, 2026issueSO-260822-464MAIN 2 55.52-111.04492,708.27 Aug. 2, 2026: 2 @ 55.52
Aug. 21, 2026issueSO-260821-254MAIN 5 55.52-277.59512,819.31 Aug. 2, 2026: 5 @ 55.52
Aug. 19, 2026receiptPO-001730MAIN 49 55.272,708.27563,096.90
Aug. 13, 2026issueSO-260813-529MAIN 18 55.52-999.337388.63 Aug. 2, 2026: 18 @ 55.52
Aug. 13, 2026issueSO-260813-529EAST 14 55.52-777.26251,387.96 Aug. 2, 2026: 14 @ 55.52
Aug. 5, 2026issueSO-260805-773MAIN 21 54.96-1,154.11392,165.22 June 20, 2026: 11 @ 54.45; Aug. 2, 2026: 10 @ 55.52
Aug. 2, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Aug. 2, 2026receiptPO-001692MAIN 49 55.522,720.41603,319.33
July 27, 2026issueSO-260727-989MAIN 6 54.45-326.6911598.93 June 20, 2026: 6 @ 54.45
July 20, 2026issueSO-260720-302MAIN 7 54.45-381.1317925.61 June 20, 2026: 7 @ 54.45
July 17, 2026issueSO-260717-978MAIN 1 54.45-54.45241,306.75 June 20, 2026: 1 @ 54.45
July 14, 2026issueSO-260714-964MAIN 2 54.45-108.90251,361.20 June 20, 2026: 2 @ 54.45
July 11, 2026issueSO-260711-959MAIN 22 54.45-1,197.85271,470.09 June 20, 2026: 22 @ 54.45
June 20, 2026receiptPO-001589MAIN 49 54.452,667.94492,667.94
June 13, 2026issueSO-260613-802MAIN 13 53.56-696.3000.00 May 9, 2026: 13 @ 53.56
June 11, 2026issueSO-260611-218MAIN 1 53.56-53.5613696.30 May 9, 2026: 1 @ 53.56
June 10, 2026issueSO-260610-684MAIN 15 53.56-803.4314749.87 May 9, 2026: 15 @ 53.56
June 10, 2026issueSO-260610-684EAST 4 53.56-214.25291,553.29 May 9, 2026: 4 @ 53.56
May 24, 2026issueSO-260524-164MAIN 7 53.56-374.93331,767.54 May 9, 2026: 7 @ 53.56
May 12, 2026issueSO-260512-446MAIN 7 53.56-374.93402,142.47 May 9, 2026: 7 @ 53.56
May 10, 2026issueSO-260510-678EAST 10 54.94-549.44472,517.40 March 4, 2026: 8 @ 55.29; May 9, 2026: 2 @ 53.56
May 9, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
May 9, 2026receiptPO-001478MAIN 49 53.562,624.53573,066.85
April 29, 2026issueSO-260429-916MAIN 13 55.29-718.778442.32 March 4, 2026: 13 @ 55.29
April 11, 2026issueSO-260411-437MAIN 10 55.29-552.90211,161.08 March 4, 2026: 10 @ 55.29
March 10, 2026issueSO-260310-722MAIN 18 55.29-995.21311,713.98 March 4, 2026: 18 @ 55.29
March 4, 2026receiptPO-001283MAIN 49 55.292,709.20492,709.20
March 2, 2026issueSO-260302-943MAIN 9 54.58-491.1900.00 Jan. 26, 2026: 4 @ 54.58; Feb. 9, 2026: 5 @ 54.58
Feb. 26, 2026issueSO-260226-377MAIN 14 54.58-764.089491.19 Jan. 26, 2026: 14 @ 54.58
Feb. 9, 2026returnRMAMAIN 5 54.58272.88231,255.27
Feb. 8, 2026issueSO-260208-832MAIN 4 54.58-218.3118982.39 Jan. 26, 2026: 4 @ 54.58
Feb. 3, 2026issueSO-260203-984MAIN 10 54.58-545.77221,200.69 Jan. 26, 2026: 10 @ 54.58
Jan. 27, 2026issueSO-260127-877MAIN 21 54.33-1,140.95321,746.46 Nov. 9, 2025: 4 @ 53.29; Jan. 26, 2026: 17 @ 54.58
Jan. 26, 2026receiptPO-001177MAIN 49 54.582,674.27532,887.41
Jan. 17, 2026issueSO-260117-286MAIN 12 53.29-639.424213.14 Nov. 9, 2025: 12 @ 53.29
Jan. 11, 2026issueSO-260111-403MAIN 1 53.29-53.2916852.56 Nov. 9, 2025: 1 @ 53.29
Dec. 26, 2025issueSO-251226-244MAIN 22 53.29-1,172.2717905.85 Nov. 9, 2025: 22 @ 53.29
Dec. 25, 2025issueSO-251225-410MAIN 3 53.29-159.86392,078.12 Nov. 9, 2025: 3 @ 53.29
Dec. 17, 2025issueSO-251217-805MAIN 1 53.29-53.29422,237.97 Nov. 9, 2025: 1 @ 53.29
Dec. 2, 2025issueSO-251202-479MAIN 1 53.29-53.29432,291.26 Nov. 9, 2025: 1 @ 53.29
Nov. 26, 2025issueSO-251126-462MAIN 3 53.29-159.86442,344.54 Nov. 9, 2025: 3 @ 53.29
Nov. 10, 2025issueSO-251110-764MAIN 2 53.29-106.57472,504.40 Nov. 9, 2025: 2 @ 53.29
Nov. 9, 2025receiptPO-000988MAIN 49 53.292,610.97492,610.97
Nov. 2, 2025issueSO-251102-657EAST 8 54.26-434.0600.00 Aug. 22, 2025: 8 @ 54.26
Nov. 1, 2025issueSO-251101-151EAST 1 54.26-54.268434.06 Aug. 22, 2025: 1 @ 54.26
Oct. 31, 2025issueSO-251031-349EAST 1 54.26-54.269488.31 Aug. 22, 2025: 1 @ 54.26
Oct. 31, 2025issueSO-251031-349MAIN 20 54.26-1,085.1410542.57 Aug. 22, 2025: 20 @ 54.26
Oct. 23, 2025issueSO-251023-144MAIN 4 54.26-217.03301,627.72 Aug. 22, 2025: 4 @ 54.26
Oct. 17, 2025issueSO-251017-746MAIN 4 54.26-217.03341,844.74 Aug. 22, 2025: 4 @ 54.26
Oct. 16, 2025issueSO-251016-116MAIN 7 54.26-379.80382,061.77 Aug. 22, 2025: 7 @ 54.26
Sept. 28, 2025issueSO-250928-814MAIN 1 54.26-54.26452,441.57 Aug. 22, 2025: 1 @ 54.26
Sept. 15, 2025issueSO-250915-336EAST 6 52.90-317.39462,495.83 May 27, 2025: 3 @ 51.54; Aug. 22, 2025: 3 @ 54.26
Sept. 10, 2025issueSO-250910-255MAIN 1 51.54-51.54522,813.22 May 27, 2025: 1 @ 51.54
Sept. 5, 2025issueSO-250905-533MAIN 1 51.54-51.54532,864.76 May 27, 2025: 1 @ 51.54
Aug. 28, 2025issueSO-250828-739MAIN 1 51.54-51.54542,916.30 May 27, 2025: 1 @ 51.54
Aug. 27, 2025issueSO-250827-526MAIN 1 51.54-51.54552,967.84 May 27, 2025: 1 @ 51.54
Aug. 22, 2025transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
Aug. 22, 2025receiptPO-000790MAIN 49 54.262,658.60563,019.38
Aug. 16, 2025issueSO-250816-103MAIN 2 51.54-103.087360.77 May 27, 2025: 2 @ 51.54
Aug. 14, 2025issueSO-250814-959MAIN 4 51.54-206.169463.85 May 27, 2025: 4 @ 51.54
Aug. 9, 2025issueSO-250809-459MAIN 1 51.54-51.5413670.01 May 27, 2025: 1 @ 51.54
Aug. 6, 2025issueSO-250806-242MAIN 3 51.54-154.6214721.55 May 27, 2025: 3 @ 51.54
July 30, 2025issueSO-250730-818MAIN 5 51.54-257.7017876.17 May 27, 2025: 5 @ 51.54
July 24, 2025issueSO-250724-726MAIN 1 51.54-51.54221,133.86 May 27, 2025: 1 @ 51.54
July 12, 2025issueSO-250712-124MAIN 14 51.54-721.55231,185.40 May 27, 2025: 14 @ 51.54
July 9, 2025issueSO-250709-249MAIN 1 51.54-51.54371,906.95 May 27, 2025: 1 @ 51.54
July 6, 2025issueSO-250706-328MAIN 4 51.54-206.16381,958.49 May 27, 2025: 4 @ 51.54
June 24, 2025issueSO-250624-827MAIN 4 51.54-206.16422,164.65 May 27, 2025: 4 @ 51.54
June 19, 2025issueSO-250619-729MAIN 2 51.54-103.08462,370.80 May 27, 2025: 2 @ 51.54
June 15, 2025issueSO-250615-946MAIN 3 51.40-154.20482,473.88 May 7, 2025: 2 @ 51.33; May 27, 2025: 1 @ 51.54
May 27, 2025receiptPO-000583MAIN 49 51.542,525.42512,628.08
May 21, 2025issueSO-250521-666MAIN 31 51.33-1,591.212102.66 May 7, 2025: 31 @ 51.33
May 20, 2025issueSO-250520-724MAIN 19 51.19-972.53331,693.87 Feb. 23, 2025: 3 @ 50.42; May 7, 2025: 16 @ 51.33
May 13, 2025issueSO-250513-369MAIN 2 50.42-100.84522,666.40 Feb. 23, 2025: 2 @ 50.42
May 7, 2025receiptPO-000521MAIN 49 51.332,515.14542,767.24
May 2, 2025issueSO-250502-558MAIN 3 50.42-151.265252.10 Feb. 23, 2025: 3 @ 50.42
May 2, 2025issueSO-250502-558EAST 6 50.42-302.528403.36 Feb. 23, 2025: 6 @ 50.42
April 12, 2025issueSO-250412-374MAIN 6 50.42-302.5214705.88 Feb. 23, 2025: 6 @ 50.42
April 10, 2025issueSO-250410-942MAIN 5 50.42-252.10201,008.40 Feb. 23, 2025: 5 @ 50.42
April 9, 2025issueSO-250409-919MAIN 1 50.42-50.42251,260.50 Feb. 23, 2025: 1 @ 50.42
April 2, 2025issueSO-250402-575MAIN 1 50.42-50.42261,310.92 Feb. 23, 2025: 1 @ 50.42
April 1, 2025issueSO-250401-149MAIN 20 50.42-1,008.40271,361.34 Feb. 23, 2025: 20 @ 50.42
March 29, 2025issueSO-250329-772MAIN 2 50.42-100.84472,369.74 Feb. 23, 2025: 2 @ 50.42
March 28, 2025issueSO-250328-810MAIN 1 51.56-51.56492,470.58 Dec. 19, 2024: 1 @ 51.56
March 22, 2025issueSO-250322-816MAIN 1 51.56-51.56502,522.14 Dec. 19, 2024: 1 @ 51.56
March 16, 2025issueSO-250316-114MAIN 3 51.56-154.67512,573.70 Dec. 19, 2024: 3 @ 51.56
March 3, 2025issueSO-250303-928MAIN 1 51.56-51.56542,728.37 Dec. 19, 2024: 1 @ 51.56
Feb. 23, 2025receiptPO-000297MAIN 49 50.422,470.58552,779.93
Feb. 15, 2025issueSO-250215-661EAST 8 51.56-412.466309.34 Dec. 19, 2024: 8 @ 51.56
Feb. 2, 2025issueSO-250202-567EAST 1 51.56-51.5614721.80 Dec. 19, 2024: 1 @ 51.56
Feb. 2, 2025issueSO-250202-567MAIN 7 51.56-360.9015773.36 Dec. 19, 2024: 7 @ 51.56
Jan. 23, 2025issueSO-250123-377MAIN 2 51.56-103.11221,134.26 Dec. 19, 2024: 2 @ 51.56
Jan. 21, 2025issueSO-250121-453MAIN 7 51.56-360.90241,237.38 Dec. 19, 2024: 7 @ 51.56
Jan. 5, 2025issueSO-250105-230MAIN 18 51.56-928.03311,598.28 Dec. 19, 2024: 18 @ 51.56
Dec. 19, 2024transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Dec. 19, 2024receiptPO-000119MAIN 49 51.562,526.31492,526.31
Dec. 18, 2024issueSO-241218-864EAST 6 49.75-298.4900.00 Nov. 5, 2024: 6 @ 49.75
Dec. 11, 2024issueSO-241211-124EAST 7 49.75-348.246298.49 Nov. 5, 2024: 7 @ 49.75
Dec. 7, 2024issueSO-241207-488EAST 1 49.75-49.7513646.72 Nov. 5, 2024: 1 @ 49.75
Dec. 7, 2024issueSO-241207-488MAIN 13 49.75-646.7214696.47 Nov. 5, 2024: 13 @ 49.75
Dec. 4, 2024issueSO-241204-938EAST 4 49.75-198.99271,343.19 Nov. 5, 2024: 4 @ 49.75
Nov. 22, 2024issueSO-241122-691MAIN 21 50.19-1,054.01311,542.18 Oct. 1, 2024: 3 @ 52.85; Nov. 5, 2024: 18 @ 49.75
Nov. 10, 2024issueSO-241110-384EAST 7 52.85-369.94522,596.19 Oct. 1, 2024: 7 @ 52.85
Nov. 5, 2024transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Nov. 5, 2024receiptPO-000025MAIN 49 49.752,437.65592,966.13
Oct. 31, 2024issueSO-241031-269EAST 2 52.85-105.7010528.48 Oct. 1, 2024: 2 @ 52.85
Oct. 29, 2024issueSO-241029-202EAST 1 52.85-52.8512634.18 Oct. 1, 2024: 1 @ 52.85
Oct. 29, 2024issueSO-241029-202MAIN 15 52.85-792.7313687.03 Oct. 1, 2024: 15 @ 52.85
Oct. 23, 2024issueSO-241023-104MAIN 3 52.85-158.55281,479.76 Oct. 1, 2024: 3 @ 52.85
Oct. 22, 2024issueSO-241022-910MAIN 13 52.85-687.03311,638.30 Oct. 1, 2024: 13 @ 52.85
Oct. 15, 2024issueSO-241015-842MAIN 3 52.85-158.55442,325.33 Oct. 1, 2024: 3 @ 52.85
Oct. 14, 2024issueSO-241014-592MAIN 7 52.85-369.94472,483.88 Oct. 1, 2024: 7 @ 52.85
Oct. 10, 2024issueSO-241010-297EAST 1 52.85-52.85542,853.82 Oct. 1, 2024: 1 @ 52.85
Oct. 1, 2024transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 55 52.852,906.67552,906.67