stocksense

Items / MCB-0002

RCCB 40A Elite MCB-0002 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)20MAIN 20
Value (FIFO)1,040.37avg 52.02
ClassBX / FCV 0.39
Turnover22.6xlast issue 1 days ago
Days of cover23lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00020.018.236.354.572.6Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 22.0Nov 24: 21.0Dec 24: 20.0Jan 25: 66.0Feb 25: 19.0Mar 25: 15.0Apr 25: 32.0May 25: 55.0Jun 25: 21.0Jul 25: 25.0Aug 25: 13.0Sep 25: 17.0Oct 25: 18.0Nov 25: 25.0Dec 25: 23.0Jan 26: 30.0Feb 26: 24.0Mar 26: 13.0Apr 26: 37.0May 26: 32.0Jun 26: 18.0Jul 26: 53.0Aug 26: 21.0Sep 26: 22.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.33 / 30.43750.865
Daily demand sdmonthly sd / sqrt(30.4375)10.22 / 5.5171.852
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.852^2 + 0.865^2 * 1.5^2)8.3
Reorder pointd * LT + safety stock0.865 * 7.0 + 8.314.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days14.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 316/yr, S = 45.00, h = 20%, price = 52.5852.0
Inventory positionon hand + on order20 + 020

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

From qtyUnit costOrder qtyAnnual costFeasible
052.585217,151yes (chosen if cheapest)

MOQ 27, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 25, 202620 / 4952.021,040.37

Movement ledger 134 movements, latest 60 shown - show all

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-781MAIN 7 52.02-364.13201,040.37 Sept. 25, 2026: 7 @ 52.02
Oct. 12, 2026issueSO-261012-478MAIN 9 52.02-468.17271,404.50 Sept. 25, 2026: 9 @ 52.02
Oct. 7, 2026issueSO-261007-900MAIN 13 52.02-676.24361,872.67 Sept. 25, 2026: 13 @ 52.02
Sept. 25, 2026receiptPO-001829MAIN 49 52.022,548.91492,548.91
Sept. 17, 2026issueSO-260917-543MAIN 19 51.93-986.6400.00 July 24, 2026: 19 @ 51.93
Sept. 9, 2026issueSO-260909-405MAIN 3 51.93-155.7919986.64 July 24, 2026: 3 @ 51.93
Aug. 30, 2026issueSO-260830-155MAIN 6 51.93-311.57221,142.43 July 24, 2026: 6 @ 51.93
Aug. 21, 2026issueSO-260821-184MAIN 10 51.93-519.29281,454.00 July 24, 2026: 10 @ 51.93
Aug. 4, 2026issueSO-260804-297MAIN 5 51.93-259.64381,973.29 July 24, 2026: 5 @ 51.93
July 30, 2026issueSO-260730-845MAIN 6 51.93-311.57432,232.93 July 24, 2026: 6 @ 51.93
July 24, 2026receiptPO-001669MAIN 49 51.932,544.50492,544.50
July 19, 2026issueSO-260719-623MAIN 3 52.02-156.0700.00 June 22, 2026: 2 @ 52.02; July 15, 2026: 1 @ 52.02
July 18, 2026issueSO-260718-553MAIN 16 52.02-832.383156.07 June 22, 2026: 16 @ 52.02
July 15, 2026returnRMAMAIN 1 52.0252.0219988.45
July 11, 2026issueSO-260711-565MAIN 26 52.02-1,352.6118936.42 June 22, 2026: 26 @ 52.02
July 10, 2026issueSO-260710-567MAIN 3 52.02-156.07442,289.04 June 22, 2026: 3 @ 52.02
June 27, 2026issueSO-260627-730MAIN 2 52.02-104.05472,445.11 June 22, 2026: 2 @ 52.02
June 22, 2026receiptPO-001594MAIN 49 52.022,549.16492,549.16
June 17, 2026issueSO-260617-713MAIN 4 51.25-205.0100.00 April 17, 2026: 4 @ 51.25
June 15, 2026issueSO-260615-181MAIN 10 51.25-512.514205.01 April 17, 2026: 10 @ 51.25
June 13, 2026issueSO-260613-584MAIN 1 51.25-51.2514717.52 April 17, 2026: 1 @ 51.25
June 1, 2026issueSO-260601-821MAIN 1 51.25-51.2515768.77 April 17, 2026: 1 @ 51.25
May 22, 2026issueSO-260522-399MAIN 5 51.25-256.2616820.02 April 17, 2026: 5 @ 51.25
May 20, 2026issueSO-260520-551MAIN 1 51.25-51.25211,076.28 April 17, 2026: 1 @ 51.25
May 16, 2026issueSO-260516-537MAIN 5 51.25-256.26221,127.53 April 17, 2026: 5 @ 51.25
May 14, 2026issueSO-260514-233MAIN 3 51.25-153.75271,383.79 April 17, 2026: 3 @ 51.25
May 14, 2026issueSO-260514-233EAST 13 51.25-666.27301,537.54 April 17, 2026: 13 @ 51.25
May 11, 2026issueSO-260511-250MAIN 4 51.25-205.01432,203.81 April 17, 2026: 4 @ 51.25
May 9, 2026issueSO-260509-821MAIN 1 51.25-51.25472,408.81 April 17, 2026: 1 @ 51.25
April 25, 2026issueSO-260425-121MAIN 1 51.25-51.25482,460.06 April 17, 2026: 1 @ 51.25
April 17, 2026transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
April 17, 2026receiptPO-001416MAIN 49 51.252,511.31492,511.31
April 12, 2026issueSO-260412-257MAIN 3 52.25-156.7400.00 April 6, 2026: 3 @ 52.25
April 8, 2026issueSO-260408-342MAIN 37 52.25-1,933.093156.74 Feb. 22, 2026: 36 @ 52.25; April 6, 2026: 1 @ 52.25
April 6, 2026returnRMAMAIN 4 52.25208.98402,089.82
March 20, 2026issueSO-260320-491MAIN 9 52.25-470.21361,880.84 Feb. 22, 2026: 9 @ 52.25
March 15, 2026issueSO-260315-475MAIN 1 52.25-52.25452,351.05 Feb. 22, 2026: 1 @ 52.25
March 6, 2026issueSO-260306-320MAIN 1 52.25-52.25462,403.30 Feb. 22, 2026: 1 @ 52.25
March 4, 2026issueSO-260304-316MAIN 2 52.25-104.49472,455.54 Feb. 22, 2026: 2 @ 52.25
Feb. 22, 2026receiptPO-001251MAIN 49 52.252,560.03492,560.03
Feb. 20, 2026issueSO-260220-766MAIN 6 51.15-306.9000.00 Dec. 17, 2025: 6 @ 51.15
Feb. 14, 2026issueSO-260214-904MAIN 13 51.15-664.946306.90 Dec. 17, 2025: 13 @ 51.15
Feb. 13, 2026issueSO-260213-751MAIN 5 51.15-255.7519971.84 Dec. 17, 2025: 5 @ 51.15
Jan. 27, 2026issueSO-260127-591MAIN 6 51.15-306.90241,227.59 Dec. 17, 2025: 6 @ 51.15
Jan. 26, 2026issueSO-260126-333MAIN 5 51.15-255.75301,534.49 Dec. 17, 2025: 5 @ 51.15
Jan. 17, 2026issueSO-260117-896EAST 12 51.15-613.80351,790.24 Dec. 17, 2025: 12 @ 51.15
Jan. 16, 2026issueSO-260116-774MAIN 6 50.60-303.61472,404.03 Oct. 17, 2025: 4 @ 50.33; Dec. 17, 2025: 2 @ 51.15
Jan. 8, 2026issueSO-260108-100EAST 1 50.33-50.33532,707.64 Oct. 17, 2025: 1 @ 50.33
Dec. 22, 2025issueSO-251222-299MAIN 1 50.33-50.33542,757.97 Oct. 17, 2025: 1 @ 50.33
Dec. 17, 2025transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Dec. 17, 2025receiptPO-001060MAIN 49 51.152,506.33552,808.29
Dec. 16, 2025issueSO-251216-697MAIN 1 50.33-50.336301.96 Oct. 17, 2025: 1 @ 50.33
Dec. 10, 2025issueSO-251210-204MAIN 7 50.33-352.297352.29 Oct. 17, 2025: 7 @ 50.33
Dec. 4, 2025issueSO-251204-412MAIN 1 50.33-50.3314704.58 Oct. 17, 2025: 1 @ 50.33
Dec. 3, 2025issueSO-251203-839MAIN 13 50.33-654.2615754.91 Oct. 17, 2025: 13 @ 50.33
Nov. 10, 2025issueSO-251110-166MAIN 24 50.33-1,207.86281,409.17 Aug. 5, 2025: 2 @ 50.33; Sept. 15, 2025: 1 @ 50.33; Oct. 17, 2025: 21 @ 50.33
Nov. 7, 2025issueSO-251107-496MAIN 1 50.33-50.33522,617.03 Aug. 5, 2025: 1 @ 50.33
Oct. 21, 2025issueSO-251021-338MAIN 5 50.33-251.64532,667.36 Aug. 5, 2025: 5 @ 50.33
Oct. 17, 2025issueSO-251017-592MAIN 1 50.33-50.33582,919.00 Aug. 5, 2025: 1 @ 50.33
Oct. 17, 2025receiptPO-000930MAIN 49 50.332,466.04592,969.33