stocksense

Items / MCB-0006

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

On hand (EA)80MAIN 57, EAST 23
Value (FIFO)3,234.63avg 40.43
ClassBY / FCV 0.72
Turnover14.1xlast issue 0 days ago
Days of cover48lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00060.036.673.2110146Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 24.0Nov 24: 32.0Dec 24: 48.0Jan 25: 42.0Feb 25: 45.0Mar 25: 50.0Apr 25: 26.0May 25: 46.0Jun 25: 106.0Jul 25: 41.0Aug 25: 31.0Sep 25: 27.0Oct 25: 70.0Nov 25: 16.0Dec 25: 63.0Jan 26: 112.0Feb 26: 19.0Mar 26: 23.0Apr 26: 49.0May 26: 41.0Jun 26: 31.0Jul 26: 133.0Aug 26: 9.0Sep 26: 47.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.437551.08 / 30.43751.678
Daily demand sdmonthly sd / sqrt(30.4375)36.82 / 5.5176.674
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 * 6.674^2 + 1.678^2 * 1.5^2)29.3
Reorder pointd * LT + safety stock1.678 * 7.0 + 29.341.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days41.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 613/yr, S = 45.00, h = 20%, price = 38.28184.0
Inventory positionon hand + on order80 + 080

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

From qtyUnit costOrder qtyAnnual costFeasible
041.618126,167yes
9239.959225,137yes
18438.2818424,305yes (chosen if cheapest)

MOQ 46, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 13, 202680 / 8240.433,234.63

Movement ledger 128 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-105MAIN 3 40.63-121.90803,234.63 Aug. 15, 2026: 1 @ 41.03; Oct. 13, 2026: 2 @ 40.43
Oct. 14, 2026issueSO-261014-253MAIN 16 41.10-657.60833,356.53 Aug. 7, 2026: 13 @ 41.12; Aug. 15, 2026: 3 @ 41.03
Oct. 13, 2026transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Oct. 13, 2026receiptPO-001877MAIN 82 40.433,315.50994,014.13
Oct. 9, 2026issueSO-261009-437MAIN 9 41.12-370.0417698.63 Aug. 7, 2026: 9 @ 41.12
Sept. 13, 2026issueSO-260913-624MAIN 46 41.12-1,891.31261,068.67 Aug. 7, 2026: 46 @ 41.12
Sept. 5, 2026issueSO-260905-764MAIN 1 41.12-41.12722,959.98 Aug. 7, 2026: 1 @ 41.12
Aug. 22, 2026issueSO-260822-368MAIN 9 41.12-370.04733,001.10 Aug. 7, 2026: 9 @ 41.12
Aug. 15, 2026returnRMAMAIN 4 41.03164.13823,371.14
Aug. 9, 2026issueSO-260809-334MAIN 9 41.03-369.30783,207.00 Aug. 6, 2026: 5 @ 40.97; Aug. 7, 2026: 4 @ 41.12
Aug. 7, 2026receiptPO-001703MAIN 82 41.123,371.46873,576.30
Aug. 6, 2026returnRMAMAIN 5 40.97204.845204.84
July 30, 2026issueSO-260730-447EAST 17 40.97-696.4600.00 July 25, 2026: 17 @ 40.97
July 30, 2026issueSO-260730-447MAIN 65 40.97-2,662.9417696.46 July 25, 2026: 65 @ 40.97
July 26, 2026issueSO-260726-403EAST 20 40.09-801.90823,359.40 June 8, 2026: 20 @ 40.09
July 25, 2026transferTRFMAIN → EAST 17 warehouse transfer, no cost effect
July 25, 2026receiptPO-001672MAIN 82 40.973,359.401024,161.30
July 18, 2026issueSO-260718-611EAST 6 40.09-240.5720801.90 June 8, 2026: 6 @ 40.09
July 18, 2026issueSO-260718-611MAIN 10 40.09-400.95261,042.46 June 8, 2026: 10 @ 40.09
July 9, 2026issueSO-260709-708MAIN 15 40.09-601.42361,443.41 June 8, 2026: 15 @ 40.09
June 23, 2026issueSO-260623-321MAIN 15 40.09-601.42512,044.83 June 8, 2026: 15 @ 40.09
June 16, 2026issueSO-260616-853MAIN 16 40.09-641.52662,646.26 June 8, 2026: 16 @ 40.09
June 8, 2026transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
June 8, 2026receiptPO-001561MAIN 82 40.093,287.77823,287.77
May 31, 2026issueSO-260531-590MAIN 36 40.35-1,452.5100.00 March 17, 2026: 36 @ 40.35
May 29, 2026issueSO-260529-401MAIN 5 40.35-201.74361,452.51 March 17, 2026: 5 @ 40.35
April 23, 2026issueSO-260423-474MAIN 8 40.35-322.78411,654.25 March 17, 2026: 8 @ 40.35
April 12, 2026issueSO-260412-139MAIN 12 40.35-484.17491,977.03 March 17, 2026: 12 @ 40.35
April 11, 2026issueSO-260411-845MAIN 20 40.35-806.95612,461.20 March 17, 2026: 20 @ 40.35
April 10, 2026issueSO-260410-347MAIN 4 39.74-158.95813,268.15 Jan. 26, 2026: 3 @ 39.54; March 17, 2026: 1 @ 40.35
April 4, 2026issueSO-260404-507MAIN 5 39.54-197.68853,427.10 Jan. 26, 2026: 5 @ 39.54
March 17, 2026receiptPO-001330MAIN 82 40.353,308.50903,624.78
March 13, 2026issueSO-260313-836MAIN 7 39.54-276.758316.29 Jan. 26, 2026: 7 @ 39.54
March 8, 2026issueSO-260308-921MAIN 16 39.54-632.5715593.04 Jan. 26, 2026: 16 @ 39.54
Feb. 26, 2026issueSO-260226-533MAIN 3 39.54-118.61311,225.61 Jan. 26, 2026: 3 @ 39.54
Feb. 25, 2026issueSO-260225-675MAIN 4 39.54-158.14341,344.22 Jan. 26, 2026: 4 @ 39.54
Feb. 13, 2026issueSO-260213-281MAIN 1 39.54-39.54381,502.36 Jan. 26, 2026: 1 @ 39.54
Feb. 10, 2026issueSO-260210-223MAIN 5 39.54-197.68391,541.90 Jan. 26, 2026: 5 @ 39.54
Feb. 9, 2026issueSO-260209-766MAIN 2 39.54-79.07441,739.58 Jan. 26, 2026: 2 @ 39.54
Feb. 8, 2026issueSO-260208-944MAIN 3 39.54-118.61461,818.65 Jan. 26, 2026: 3 @ 39.54
Feb. 5, 2026issueSO-260205-705MAIN 1 39.54-39.54491,937.25 Jan. 26, 2026: 1 @ 39.54
Jan. 29, 2026issueSO-260129-450MAIN 9 39.54-355.82501,976.79 Jan. 26, 2026: 9 @ 39.54
Jan. 29, 2026issueSO-260129-450EAST 17 39.54-672.11592,332.61 Jan. 26, 2026: 17 @ 39.54
Jan. 26, 2026issueSO-260126-639MAIN 6 39.54-237.21763,004.72 Jan. 26, 2026: 6 @ 39.54
Jan. 26, 2026transferTRFMAIN → EAST 17 warehouse transfer, no cost effect
Jan. 26, 2026receiptPO-001176MAIN 82 39.543,241.94823,241.94
Jan. 18, 2026issueSO-260118-395MAIN 31 39.38-1,220.9200.00 Dec. 27, 2025: 31 @ 39.38
Jan. 16, 2026issueSO-260116-464MAIN 17 39.38-669.54311,220.92 Dec. 27, 2025: 17 @ 39.38
Jan. 1, 2026issueSO-260101-934MAIN 31 39.38-1,220.92481,890.46 Dec. 27, 2025: 31 @ 39.38
Jan. 1, 2026issueSO-260101-934EAST 1 39.38-39.38793,111.38 Dec. 27, 2025: 1 @ 39.38
Dec. 28, 2025issueSO-251228-123MAIN 3 39.91-119.72803,150.76 Oct. 24, 2025: 1 @ 40.95; Dec. 27, 2025: 2 @ 39.38
Dec. 27, 2025receiptPO-001095MAIN 82 39.383,229.53833,270.48
Dec. 24, 2025issueSO-251224-504EAST 17 40.95-696.21140.95 Oct. 24, 2025: 17 @ 40.95
Dec. 22, 2025issueSO-251222-901EAST 2 40.95-81.9118737.16 Oct. 24, 2025: 2 @ 40.95
Dec. 22, 2025issueSO-251222-901MAIN 11 40.95-450.4920819.07 Oct. 24, 2025: 11 @ 40.95
Dec. 6, 2025issueSO-251206-494MAIN 5 40.95-204.77311,269.55 Oct. 24, 2025: 5 @ 40.95
Dec. 4, 2025issueSO-251204-138MAIN 5 40.95-204.77361,474.32 Oct. 24, 2025: 5 @ 40.95
Dec. 3, 2025issueSO-251203-213MAIN 20 40.95-819.07411,679.09 Oct. 24, 2025: 20 @ 40.95
Nov. 24, 2025issueSO-251124-274EAST 1 40.95-40.95612,498.15 Oct. 24, 2025: 1 @ 40.95
Nov. 18, 2025issueSO-251118-866MAIN 8 40.95-327.63622,539.10 Oct. 24, 2025: 8 @ 40.95
Nov. 16, 2025issueSO-251116-469MAIN 5 40.95-204.77702,866.73 Oct. 24, 2025: 5 @ 40.95
Nov. 6, 2025issueSO-251106-328MAIN 1 40.95-40.95753,071.50 Oct. 24, 2025: 1 @ 40.95
Nov. 4, 2025issueSO-251104-992EAST 1 40.95-40.95763,112.45 Oct. 24, 2025: 1 @ 40.95
Oct. 28, 2025issueSO-251028-712MAIN 4 40.95-163.81773,153.40 Oct. 24, 2025: 4 @ 40.95
Oct. 27, 2025issueSO-251027-561MAIN 1 40.95-40.95813,317.22 Oct. 24, 2025: 1 @ 40.95
Oct. 24, 2025transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
Oct. 24, 2025receiptPO-000946MAIN 82 40.953,358.17823,358.17
Oct. 20, 2025issueSO-251020-186MAIN 3 40.08-120.2500.00 Aug. 28, 2025: 3 @ 40.08
Oct. 15, 2025issueSO-251015-322MAIN 24 40.08-961.983120.25 Aug. 28, 2025: 24 @ 40.08
Oct. 14, 2025issueSO-251014-624MAIN 18 40.08-721.49271,082.23 Aug. 28, 2025: 18 @ 40.08
Oct. 3, 2025issueSO-251003-178MAIN 20 40.08-801.65451,803.72 Aug. 28, 2025: 20 @ 40.08
Sept. 22, 2025issueSO-250922-500MAIN 15 40.08-601.24652,605.37 Aug. 28, 2025: 15 @ 40.08
Sept. 13, 2025issueSO-250913-221MAIN 2 40.08-80.17803,206.61 Aug. 28, 2025: 2 @ 40.08
Sept. 1, 2025issueSO-250901-968MAIN 10 39.76-397.62823,286.77 June 29, 2025: 10 @ 39.76
Aug. 28, 2025receiptPO-000799MAIN 82 40.083,286.77923,684.39
Aug. 21, 2025issueSO-250821-891MAIN 20 39.76-795.2410397.62 June 29, 2025: 20 @ 39.76
Aug. 10, 2025issueSO-250810-106MAIN 11 39.76-437.38301,192.86 June 29, 2025: 11 @ 39.76
July 28, 2025issueSO-250728-597MAIN 2 39.76-79.52411,630.24 June 29, 2025: 2 @ 39.76
July 25, 2025issueSO-250725-888MAIN 11 39.76-437.38431,709.77 June 29, 2025: 11 @ 39.76
July 22, 2025issueSO-250722-439MAIN 5 39.76-198.81542,147.15 June 29, 2025: 5 @ 39.76
July 18, 2025issueSO-250718-602MAIN 7 39.76-278.33592,345.96 June 29, 2025: 7 @ 39.76
July 16, 2025issueSO-250716-957MAIN 3 39.76-119.29662,624.29 June 29, 2025: 3 @ 39.76
July 5, 2025issueSO-250705-594MAIN 13 39.76-516.91692,743.58 June 29, 2025: 13 @ 39.76
June 29, 2025receiptPO-000673MAIN 82 39.763,260.48823,260.48
June 22, 2025issueSO-250622-758MAIN 98 40.11-3,930.2900.00 April 5, 2025: 16 @ 38.39; June 16, 2025: 82 @ 40.44
June 16, 2025receiptPO-000643MAIN 82 40.443,316.07983,930.29
June 9, 2025issueSO-250609-424MAIN 8 38.39-307.1116614.22 April 5, 2025: 8 @ 38.39
May 21, 2025issueSO-250521-394MAIN 2 38.39-76.7824921.33 April 5, 2025: 2 @ 38.39
May 15, 2025issueSO-250515-324MAIN 28 38.39-1,074.8926998.11 April 5, 2025: 28 @ 38.39
May 12, 2025issueSO-250512-219MAIN 4 38.39-153.56542,073.00 April 5, 2025: 4 @ 38.39
May 10, 2025issueSO-250510-903MAIN 3 38.39-115.17582,226.56 April 5, 2025: 3 @ 38.39
May 7, 2025issueSO-250507-469MAIN 5 38.39-191.94612,341.72 April 5, 2025: 5 @ 38.39
May 4, 2025issueSO-250504-563MAIN 4 38.39-153.56662,533.67 April 5, 2025: 4 @ 38.39
April 30, 2025issueSO-250430-120MAIN 10 38.39-383.89702,687.22 April 5, 2025: 10 @ 38.39
April 28, 2025issueSO-250428-467MAIN 2 38.39-76.78803,071.11 April 5, 2025: 2 @ 38.39
April 24, 2025issueSO-250424-464MAIN 3 38.64-115.91823,147.89 Feb. 10, 2025: 3 @ 38.64
April 17, 2025issueSO-250417-629MAIN 9 38.64-347.74853,263.80 Feb. 10, 2025: 9 @ 38.64
April 11, 2025issueSO-250411-548MAIN 2 38.64-77.27943,611.54 Feb. 10, 2025: 2 @ 38.64
April 5, 2025receiptPO-000416MAIN 82 38.393,147.89963,688.81
March 31, 2025issueSO-250331-679MAIN 6 38.64-231.8214540.92 Feb. 10, 2025: 6 @ 38.64
March 29, 2025issueSO-250329-516MAIN 18 38.64-695.4720772.75 Feb. 10, 2025: 18 @ 38.64
March 26, 2025issueSO-250326-289MAIN 1 38.64-38.64381,468.22 Feb. 10, 2025: 1 @ 38.64
March 19, 2025issueSO-250319-227MAIN 14 38.64-540.92391,506.85 Feb. 10, 2025: 14 @ 38.64
March 10, 2025issueSO-250310-299MAIN 5 38.64-193.19532,047.78 Feb. 10, 2025: 5 @ 38.64
March 9, 2025issueSO-250309-658MAIN 6 38.64-231.82582,240.96 Feb. 10, 2025: 6 @ 38.64
Feb. 21, 2025issueSO-250221-287MAIN 12 38.64-463.65642,472.79 Feb. 10, 2025: 12 @ 38.64
Feb. 19, 2025issueSO-250219-166MAIN 6 38.64-231.82762,936.43 Feb. 10, 2025: 6 @ 38.64
Feb. 10, 2025receiptPO-000254MAIN 82 38.643,168.26823,168.26
Feb. 6, 2025issueSO-250206-218EAST 4 37.76-151.0500.00 Dec. 8, 2024: 4 @ 37.76
Feb. 3, 2025issueSO-250203-597EAST 9 37.76-339.874151.05 Dec. 8, 2024: 9 @ 37.76
Feb. 3, 2025issueSO-250203-597MAIN 14 37.76-528.6813490.92 Dec. 8, 2024: 14 @ 37.76
Jan. 28, 2025issueSO-250128-905MAIN 10 37.76-377.63271,019.60 Dec. 8, 2024: 10 @ 37.76
Jan. 11, 2025issueSO-250111-754MAIN 12 37.76-453.15371,397.23 Dec. 8, 2024: 12 @ 37.76
Jan. 7, 2025issueSO-250107-650MAIN 20 37.76-755.26491,850.38 Dec. 8, 2024: 20 @ 37.76
Dec. 31, 2024issueSO-241231-546EAST 13 37.76-490.92692,605.64 Dec. 8, 2024: 13 @ 37.76
Dec. 8, 2024transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
Dec. 8, 2024receiptPO-000085MAIN 82 37.763,096.56823,096.56
Dec. 1, 2024issueSO-241201-237MAIN 35 39.53-1,383.5300.00 Oct. 1, 2024: 34 @ 39.53; Nov. 18, 2024: 1 @ 39.53
Nov. 24, 2024issueSO-241124-230MAIN 7 39.53-276.71351,383.53 Oct. 1, 2024: 7 @ 39.53
Nov. 18, 2024returnRMAMAIN 1 39.5339.53421,660.24
Nov. 18, 2024issueSO-241118-134MAIN 13 39.53-513.88411,620.71 Oct. 1, 2024: 13 @ 39.53
Nov. 14, 2024issueSO-241114-837MAIN 1 39.53-39.53542,134.59 Oct. 1, 2024: 1 @ 39.53
Nov. 5, 2024issueSO-241105-950MAIN 5 39.53-197.65552,174.12 Oct. 1, 2024: 5 @ 39.53
Nov. 4, 2024issueSO-241104-968MAIN 3 39.53-118.59602,371.77 Oct. 1, 2024: 3 @ 39.53
Nov. 3, 2024issueSO-241103-419MAIN 4 39.53-158.12632,490.36 Oct. 1, 2024: 4 @ 39.53
Oct. 20, 2024issueSO-241020-950MAIN 18 39.53-711.53672,648.48 Oct. 1, 2024: 18 @ 39.53
Oct. 12, 2024issueSO-241012-113MAIN 6 39.53-237.18853,360.01 Oct. 1, 2024: 6 @ 39.53
Oct. 1, 2024receiptPO-000005MAIN 91 39.533,597.18913,597.18