stocksense

Items / MCB-0026

MCB 16A DP Pro MCB-0026 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)1EAST 1
Value (FIFO)18.85avg 18.85
ClassCX / FCV 0.30
Turnover13.8xlast issue 1 days ago
Days of cover1lead time 7d

Reorder suggested: 88 units (position at or below reorder point: order EOQ), stockout risk high.

Demand and forecast

Monthly demand and forecast for MCB-00260.017.935.853.671.5Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 22.0Nov 24: 32.0Dec 24: 32.0Jan 25: 26.0Feb 25: 13.0Mar 25: 30.0Apr 25: 30.0May 25: 18.0Jun 25: 19.0Jul 25: 40.0Aug 25: 19.0Sep 25: 65.0Oct 25: 36.0Nov 25: 25.0Dec 25: 20.0Jan 26: 34.0Feb 26: 31.0Mar 26: 13.0Apr 26: 40.0May 26: 13.0Jun 26: 23.0Jul 26: 27.0Aug 26: 28.0Sep 26: 27.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.437526.42 / 30.43750.868
Daily demand sdmonthly sd / sqrt(30.4375)8.03 / 5.5171.455
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 * 1.455^2 + 0.868^2 * 1.5^2)5.2
Reorder pointd * LT + safety stock0.868 * 7.0 + 5.211.3
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days11.3
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 317/yr, S = 45.00, h = 20%, price = 18.5187.8
Inventory positionon hand + on order1 + 01

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

From qtyUnit costOrder qtyAnnual costFeasible
018.51886,189yes (chosen if cheapest)

MOQ 25, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 15, 20261 / 4518.8518.85

Movement ledger 146 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-852EAST 11 18.85-207.31118.85 Aug. 15, 2026: 11 @ 18.85
Oct. 14, 2026issueSO-261014-230EAST 3 18.85-56.5412226.15 Aug. 15, 2026: 3 @ 18.85
Oct. 4, 2026issueSO-261004-715MAIN 1 18.85-18.8515282.69 Aug. 15, 2026: 1 @ 18.85
Sept. 24, 2026issueSO-260924-999MAIN 13 18.85-245.0016301.54 Aug. 15, 2026: 13 @ 18.85
Sept. 12, 2026issueSO-260912-885MAIN 6 18.85-113.0829546.53 Aug. 15, 2026: 6 @ 18.85
Sept. 9, 2026issueSO-260909-340MAIN 8 18.85-150.7735659.61 Aug. 15, 2026: 8 @ 18.85
Aug. 23, 2026issueSO-260823-745MAIN 3 18.58-55.7343810.38 July 6, 2026: 1 @ 18.04; Aug. 15, 2026: 2 @ 18.85
Aug. 19, 2026issueSO-260819-584MAIN 4 18.04-72.1646866.11 July 6, 2026: 4 @ 18.04
Aug. 15, 2026transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Aug. 15, 2026receiptPO-001722MAIN 45 18.85848.0750938.26
Aug. 12, 2026issueSO-260812-296MAIN 1 18.04-18.04590.19 July 6, 2026: 1 @ 18.04
Aug. 8, 2026issueSO-260808-191MAIN 8 18.04-144.316108.23 July 6, 2026: 8 @ 18.04
Aug. 5, 2026issueSO-260805-918MAIN 3 18.04-54.1214252.54 July 6, 2026: 3 @ 18.04
Aug. 2, 2026issueSO-260802-713MAIN 7 18.04-126.2717306.66 July 6, 2026: 7 @ 18.04
Aug. 1, 2026issueSO-260801-371MAIN 2 18.04-36.0824432.93 July 6, 2026: 2 @ 18.04
July 18, 2026issueSO-260718-348MAIN 1 18.04-18.0426469.01 July 6, 2026: 1 @ 18.04
July 17, 2026issueSO-260717-653MAIN 7 18.04-126.2727487.05 July 6, 2026: 7 @ 18.04
July 14, 2026issueSO-260714-923MAIN 4 18.04-72.1634613.32 July 6, 2026: 4 @ 18.04
July 14, 2026issueSO-260714-923EAST 2 18.04-36.0838685.48 July 6, 2026: 2 @ 18.04
July 12, 2026issueSO-260712-594EAST 12 18.42-221.0440721.56 May 8, 2026: 3 @ 18.69; May 30, 2026: 3 @ 18.69; July 1, 2026: 1 @ 18.69; July 6, 2026: 5 @ 18.04
July 10, 2026issueSO-260710-910MAIN 2 18.69-37.3852942.60 May 8, 2026: 2 @ 18.69
July 6, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
July 6, 2026receiptPO-001628MAIN 45 18.04811.7554979.98
July 1, 2026returnRMAMAIN 1 18.6918.699168.23
June 30, 2026issueSO-260630-221MAIN 1 18.69-18.698149.54 May 8, 2026: 1 @ 18.69
June 30, 2026issueSO-260630-221EAST 7 18.69-130.849168.23 May 3, 2026: 7 @ 18.69
June 25, 2026issueSO-260625-839MAIN 6 18.69-112.1516299.07 May 3, 2026: 6 @ 18.69
June 22, 2026issueSO-260622-772MAIN 1 18.69-18.6922411.23 May 3, 2026: 1 @ 18.69
June 14, 2026issueSO-260614-966MAIN 1 18.69-18.6923429.92 May 3, 2026: 1 @ 18.69
June 11, 2026adjustmentCycle countMAIN -1 18.69-18.6924448.61 May 3, 2026: 1 @ 18.69
June 5, 2026issueSO-260605-573MAIN 2 18.69-37.3825467.30 May 3, 2026: 2 @ 18.69
June 2, 2026issueSO-260602-810MAIN 5 18.69-93.4627504.69 May 3, 2026: 5 @ 18.69
May 30, 2026returnRMAMAIN 3 18.6956.0832598.15
May 26, 2026issueSO-260526-111EAST 1 18.69-18.6929542.07 May 3, 2026: 1 @ 18.69
May 19, 2026issueSO-260519-677EAST 4 18.69-74.7730560.76 May 3, 2026: 4 @ 18.69
May 16, 2026issueSO-260516-916MAIN 6 18.69-112.1534635.53 May 3, 2026: 6 @ 18.69
May 13, 2026issueSO-260513-499MAIN 4 18.69-74.7740747.68 May 3, 2026: 4 @ 18.69
May 8, 2026returnRMAMAIN 6 18.69112.1544822.45
May 8, 2026issueSO-260508-382MAIN 7 18.69-130.8438710.30 May 3, 2026: 7 @ 18.69
May 3, 2026transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
May 3, 2026receiptPO-001461MAIN 45 18.69841.1445841.14
April 27, 2026issueSO-260427-816MAIN 12 17.54-210.4300.00 March 1, 2026: 12 @ 17.54
April 21, 2026issueSO-260421-413MAIN 3 17.54-52.6112210.43 March 1, 2026: 3 @ 17.54
April 11, 2026issueSO-260411-290MAIN 25 17.54-438.4015263.04 March 1, 2026: 25 @ 17.54
March 29, 2026issueSO-260329-638MAIN 4 17.54-70.1440701.43 March 1, 2026: 4 @ 17.54
March 26, 2026issueSO-260326-363MAIN 1 17.54-17.5444771.58 March 1, 2026: 1 @ 17.54
March 21, 2026issueSO-260321-608MAIN 3 17.74-53.2145789.11 Jan. 11, 2026: 3 @ 17.74
March 9, 2026issueSO-260309-168MAIN 5 17.74-88.6848842.32 Jan. 11, 2026: 5 @ 17.74
March 1, 2026receiptPO-001272MAIN 45 17.54789.1153930.99
Feb. 26, 2026issueSO-260226-362MAIN 2 17.74-35.478141.88 Jan. 11, 2026: 2 @ 17.74
Feb. 24, 2026issueSO-260224-650MAIN 5 17.74-88.6810177.35 Jan. 11, 2026: 5 @ 17.74
Feb. 13, 2026issueSO-260213-698MAIN 2 17.74-35.4715266.03 Jan. 11, 2026: 2 @ 17.74
Feb. 11, 2026issueSO-260211-562MAIN 16 17.74-283.7717301.50 Jan. 11, 2026: 16 @ 17.74
Feb. 10, 2026issueSO-260210-744MAIN 3 17.74-53.2133585.27 Jan. 11, 2026: 3 @ 17.74
Feb. 9, 2026issueSO-260209-217MAIN 3 17.74-53.2136638.48 Jan. 11, 2026: 3 @ 17.74
Jan. 25, 2026issueSO-260125-666MAIN 8 17.84-142.7039691.68 Nov. 19, 2025: 2 @ 18.14; Jan. 11, 2026: 6 @ 17.74
Jan. 15, 2026issueSO-260115-293MAIN 2 18.14-36.2947834.38 Nov. 19, 2025: 2 @ 18.14
Jan. 14, 2026issueSO-260114-227MAIN 5 17.97-89.8549870.67 Nov. 9, 2025: 3 @ 17.86; Nov. 19, 2025: 2 @ 18.14
Jan. 11, 2026receiptPO-001136MAIN 45 17.74798.1054960.52
Jan. 4, 2026issueSO-260104-542MAIN 7 17.86-124.999162.42 Nov. 9, 2025: 7 @ 17.86
Jan. 1, 2026issueSO-260101-157MAIN 4 17.86-71.4216287.42 Nov. 9, 2025: 4 @ 17.86
Jan. 1, 2026issueSO-260101-157EAST 8 17.86-142.8520358.84 Nov. 9, 2025: 8 @ 17.86
Dec. 29, 2025issueSO-251229-778MAIN 9 17.86-160.7028501.69 Nov. 9, 2025: 9 @ 17.86
Dec. 25, 2025issueSO-251225-137MAIN 1 17.86-17.8637662.40 Nov. 9, 2025: 1 @ 17.86
Dec. 24, 2025issueSO-251224-319MAIN 5 17.86-89.2838680.25 Nov. 9, 2025: 5 @ 17.86
Dec. 17, 2025issueSO-251217-170MAIN 1 17.86-17.8643769.53 Nov. 9, 2025: 1 @ 17.86
Dec. 16, 2025issueSO-251216-520MAIN 1 17.86-17.8644787.39 Nov. 9, 2025: 1 @ 17.86
Dec. 9, 2025issueSO-251209-800MAIN 3 17.86-53.5745805.24 Nov. 9, 2025: 3 @ 17.86
Nov. 27, 2025issueSO-251127-583EAST 1 17.86-17.8648858.81 Nov. 9, 2025: 1 @ 17.86
Nov. 19, 2025returnRMAMAIN 6 18.14108.8649876.67
Nov. 10, 2025issueSO-251110-175MAIN 12 18.14-217.7143767.81 Oct. 12, 2025: 10 @ 18.20; Nov. 9, 2025: 2 @ 17.86
Nov. 9, 2025transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
Nov. 9, 2025receiptPO-000989MAIN 45 17.86803.5255985.52
Nov. 2, 2025issueSO-251102-990MAIN 16 18.20-291.2010182.00 Oct. 12, 2025: 16 @ 18.20
Nov. 2, 2025issueSO-251102-990EAST 2 18.20-36.4026473.20 Oct. 12, 2025: 2 @ 18.20
Oct. 22, 2025issueSO-251022-533MAIN 6 18.20-109.2028509.60 Oct. 12, 2025: 6 @ 18.20
Oct. 20, 2025issueSO-251020-201MAIN 10 18.20-182.0034618.80 Oct. 12, 2025: 10 @ 18.20
Oct. 17, 2025issueSO-251017-909EAST 3 17.83-53.4844800.80 Sept. 13, 2025: 2 @ 17.64; Oct. 12, 2025: 1 @ 18.20
Oct. 14, 2025issueSO-251014-315MAIN 3 17.64-52.9247854.28 Sept. 13, 2025: 3 @ 17.64
Oct. 12, 2025receiptPO-000916MAIN 45 18.20819.0050907.20
Oct. 10, 2025issueSO-251010-834EAST 6 17.64-105.84588.20 Sept. 13, 2025: 6 @ 17.64
Oct. 6, 2025issueSO-251006-482EAST 2 17.64-35.2811194.04 Sept. 13, 2025: 2 @ 17.64
Oct. 2, 2025issueSO-251002-863MAIN 6 17.64-105.8413229.33 Sept. 13, 2025: 6 @ 17.64
Sept. 29, 2025issueSO-250929-539MAIN 6 17.64-105.8419335.17 Sept. 13, 2025: 6 @ 17.64
Sept. 19, 2025issueSO-250919-448MAIN 20 17.64-352.8125441.01 Sept. 13, 2025: 20 @ 17.64
Sept. 13, 2025transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Sept. 13, 2025receiptPO-000841MAIN 45 17.64793.8245793.82
Sept. 10, 2025issueSO-250910-652MAIN 24 18.11-434.7100.00 Aug. 11, 2025: 24 @ 18.11
Sept. 3, 2025issueSO-250903-747MAIN 4 18.11-72.4524434.71 Aug. 11, 2025: 4 @ 18.11
Sept. 3, 2025issueSO-250903-747EAST 11 18.11-199.2428507.17 Aug. 11, 2025: 11 @ 18.11
Aug. 21, 2025issueSO-250821-816MAIN 6 18.11-108.6839706.41 Aug. 11, 2025: 6 @ 18.11
Aug. 11, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Aug. 11, 2025receiptPO-000771MAIN 45 18.11815.0945815.09
Aug. 3, 2025issueSO-250803-514MAIN 4 18.07-72.2800.00 July 4, 2025: 4 @ 18.07
Aug. 3, 2025issueSO-250803-514EAST 9 18.07-162.64472.28 July 4, 2025: 9 @ 18.07
July 21, 2025issueSO-250721-150EAST 5 18.07-90.3513234.92 July 4, 2025: 5 @ 18.07
July 14, 2025issueSO-250714-618MAIN 35 18.01-630.3118325.27 April 8, 2025: 8 @ 17.80; July 4, 2025: 27 @ 18.07
July 4, 2025transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
July 4, 2025receiptPO-000684MAIN 45 18.07813.1853955.58
June 28, 2025issueSO-250628-243MAIN 7 17.80-124.608142.40 April 8, 2025: 7 @ 17.80
June 25, 2025issueSO-250625-726MAIN 1 17.80-17.8015267.00 April 8, 2025: 1 @ 17.80
June 23, 2025issueSO-250623-939MAIN 1 17.80-17.8016284.80 April 8, 2025: 1 @ 17.80
June 23, 2025issueSO-250623-939EAST 3 17.80-53.4017302.61 April 8, 2025: 3 @ 17.80
June 14, 2025issueSO-250614-223MAIN 1 17.80-17.8020356.01 April 8, 2025: 1 @ 17.80
June 6, 2025issueSO-250606-122EAST 5 17.80-89.0021373.81 April 8, 2025: 5 @ 17.80
June 2, 2025issueSO-250602-863MAIN 1 17.80-17.8026462.81 April 8, 2025: 1 @ 17.80
May 30, 2025issueSO-250530-774EAST 1 17.80-17.8027480.61 April 8, 2025: 1 @ 17.80
May 25, 2025issueSO-250525-500MAIN 2 17.80-35.6028498.41 April 8, 2025: 2 @ 17.80
May 24, 2025issueSO-250524-930MAIN 3 17.80-53.4030534.01 April 8, 2025: 3 @ 17.80
May 21, 2025issueSO-250521-933MAIN 2 17.80-35.6033587.41 April 8, 2025: 2 @ 17.80
May 13, 2025issueSO-250513-966MAIN 1 17.80-17.8035623.01 April 8, 2025: 1 @ 17.80
May 4, 2025issueSO-250504-204MAIN 9 17.80-160.2036640.81 April 8, 2025: 9 @ 17.80
April 8, 2025transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
April 8, 2025receiptPO-000427MAIN 45 17.80801.0145801.01
April 3, 2025issueSO-250403-438MAIN 24 17.67-423.9800.00 March 10, 2025: 24 @ 17.67
April 3, 2025issueSO-250403-438EAST 6 17.67-105.9924423.98 March 10, 2025: 6 @ 17.67
March 28, 2025issueSO-250328-717EAST 5 17.67-88.3330529.97 March 10, 2025: 5 @ 17.67
March 20, 2025issueSO-250320-107MAIN 10 17.67-176.6635618.30 March 10, 2025: 10 @ 17.67
March 10, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
March 10, 2025receiptPO-000335MAIN 45 17.67794.9645794.96
March 8, 2025issueSO-250308-623EAST 10 17.40-173.9500.00 Dec. 30, 2024: 2 @ 17.40; Jan. 26, 2025: 8 @ 17.40
March 3, 2025issueSO-250303-551EAST 1 17.40-17.4010173.95 Dec. 30, 2024: 1 @ 17.40
March 3, 2025issueSO-250303-551MAIN 4 17.40-69.5811191.35 Dec. 30, 2024: 4 @ 17.40
Feb. 17, 2025issueSO-250217-382MAIN 1 17.40-17.4015260.93 Dec. 30, 2024: 1 @ 17.40
Feb. 15, 2025issueSO-250215-914MAIN 9 17.40-156.5616278.33 Dec. 30, 2024: 9 @ 17.40
Feb. 14, 2025issueSO-250214-972MAIN 2 17.40-34.7925434.88 Dec. 30, 2024: 2 @ 17.40
Feb. 2, 2025issueSO-250202-624EAST 1 17.40-17.4027469.68 Dec. 30, 2024: 1 @ 17.40
Jan. 31, 2025issueSO-250131-843MAIN 5 17.40-86.9828487.07 Dec. 30, 2024: 5 @ 17.40
Jan. 26, 2025returnRMAMAIN 8 17.40139.1633574.05
Jan. 26, 2025issueSO-250126-597MAIN 7 17.40-121.7725434.88 Dec. 30, 2024: 7 @ 17.40
Jan. 9, 2025issueSO-250109-318MAIN 17 17.26-293.4732556.65 Nov. 21, 2024: 4 @ 16.83; Dec. 30, 2024: 13 @ 17.40
Jan. 2, 2025issueSO-250102-358MAIN 5 16.83-84.1649850.12 Nov. 21, 2024: 5 @ 16.83
Dec. 30, 2024transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Dec. 30, 2024receiptPO-000151MAIN 45 17.40782.7954934.28
Dec. 23, 2024issueSO-241223-860MAIN 10 16.83-168.329151.49 Nov. 21, 2024: 10 @ 16.83
Dec. 18, 2024issueSO-241218-247MAIN 1 16.83-16.8319319.81 Nov. 21, 2024: 1 @ 16.83
Dec. 15, 2024issueSO-241215-198MAIN 4 16.83-67.3320336.64 Nov. 21, 2024: 4 @ 16.83
Dec. 13, 2024issueSO-241213-655MAIN 10 16.83-168.3224403.97 Nov. 21, 2024: 10 @ 16.83
Dec. 2, 2024issueSO-241202-900MAIN 7 16.83-117.8234572.29 Nov. 21, 2024: 7 @ 16.83
Nov. 27, 2024issueSO-241127-903MAIN 4 16.83-67.3341690.12 Nov. 21, 2024: 4 @ 16.83
Nov. 21, 2024receiptPO-000049MAIN 45 16.83757.4445757.44
Nov. 15, 2024issueSO-241115-952MAIN 14 17.58-246.1800.00 Oct. 1, 2024: 14 @ 17.58
Nov. 1, 2024issueSO-241101-984MAIN 14 17.58-246.1814246.18 Oct. 1, 2024: 14 @ 17.58
Oct. 29, 2024issueSO-241029-689MAIN 8 17.58-140.6828492.37 Oct. 1, 2024: 8 @ 17.58
Oct. 19, 2024issueSO-241019-194MAIN 14 17.58-246.1836633.04 Oct. 1, 2024: 14 @ 17.58
Oct. 1, 2024receiptPO-000005MAIN 50 17.58879.2250879.22