stocksense

Items / MCB-0027

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

On hand (EA)59MAIN 59
Value (FIFO)1,376.26avg 23.33
ClassBX / FCV 0.45
Turnover20.2xlast issue 0 days ago
Days of cover21lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00270.045.991.9138184Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 125.0Nov 24: 99.0Dec 24: 55.0Jan 25: 57.0Feb 25: 50.0Mar 25: 88.0Apr 25: 92.0May 25: 124.0Jun 25: 90.0Jul 25: 33.0Aug 25: 59.0Sep 25: 50.0Oct 25: 99.0Nov 25: 104.0Dec 25: 64.0Jan 26: 50.0Feb 26: 84.0Mar 26: 152.0Apr 26: 64.0May 26: 167.0Jun 26: 93.0Jul 26: 77.0Aug 26: 31.0Sep 26: 51.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.437586.33 / 30.43752.836
Daily demand sdmonthly sd / sqrt(30.4375)38.79 / 5.5177.031
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 * 7.031^2 + 2.836^2 * 1.5^2)31.4
Reorder pointd * LT + safety stock2.836 * 7.0 + 31.451.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days51.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1035/yr, S = 45.00, h = 20%, price = 22.90142.6
Inventory positionon hand + on order59 + 059

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

From qtyUnit costOrder qtyAnnual costFeasible
022.9014324,361yes (chosen if cheapest)

MOQ 63, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 7, 202659 / 11323.331,376.26

Movement ledger 139 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-578MAIN 19 23.33-443.20591,376.26 Sept. 7, 2026: 19 @ 23.33
Oct. 14, 2026issueSO-261014-970MAIN 5 23.33-116.63781,819.46 Sept. 7, 2026: 5 @ 23.33
Oct. 7, 2026issueSO-261007-981MAIN 5 23.33-116.63831,936.09 Sept. 7, 2026: 5 @ 23.33
Sept. 25, 2026issueSO-260925-197MAIN 15 23.33-349.90882,052.72 Sept. 7, 2026: 15 @ 23.33
Sept. 20, 2026issueSO-260920-682MAIN 16 22.80-364.841032,402.62 June 27, 2026: 6 @ 21.93; Sept. 7, 2026: 10 @ 23.33
Sept. 12, 2026issueSO-260912-125MAIN 2 21.93-43.861192,767.46 June 27, 2026: 2 @ 21.93
Sept. 9, 2026issueSO-260909-708MAIN 2 21.93-43.861212,811.32 June 27, 2026: 2 @ 21.93
Sept. 7, 2026receiptPO-001780MAIN 113 23.332,635.881232,855.18
Sept. 3, 2026issueSO-260903-878MAIN 16 21.93-350.8810219.30 June 27, 2026: 16 @ 21.93
Aug. 30, 2026issueSO-260830-490MAIN 16 21.93-350.8826570.17 June 27, 2026: 16 @ 21.93
Aug. 25, 2026issueSO-260825-224MAIN 1 21.93-21.9342921.05 June 27, 2026: 1 @ 21.93
Aug. 23, 2026issueSO-260823-741MAIN 5 21.93-109.6543942.98 June 27, 2026: 5 @ 21.93
Aug. 15, 2026issueSO-260815-311MAIN 6 21.93-131.58481,052.63 June 27, 2026: 6 @ 21.93
Aug. 13, 2026issueSO-260813-358MAIN 2 21.93-43.86541,184.21 June 27, 2026: 2 @ 21.93
Aug. 11, 2026issueSO-260811-458MAIN 1 21.93-21.93561,228.07 June 27, 2026: 1 @ 21.93
July 10, 2026issueSO-260710-682MAIN 22 21.93-482.46571,250.00 June 27, 2026: 22 @ 21.93
July 10, 2026issueSO-260710-682EAST 9 21.93-197.37791,732.45 June 27, 2026: 9 @ 21.93
July 9, 2026issueSO-260709-639EAST 30 22.02-660.64881,929.82 May 21, 2026: 5 @ 22.48; June 27, 2026: 25 @ 21.93
July 1, 2026issueSO-260701-557MAIN 16 22.48-359.651182,590.46 May 21, 2026: 16 @ 22.48
June 27, 2026transferTRFMAIN → EAST 39 warehouse transfer, no cost effect
June 27, 2026receiptPO-001606MAIN 113 21.932,478.071342,950.11
June 24, 2026issueSO-260624-289MAIN 1 22.48-22.4821472.04 May 21, 2026: 1 @ 22.48
June 21, 2026issueSO-260621-746MAIN 22 22.48-494.5222494.52 May 21, 2026: 22 @ 22.48
June 20, 2026issueSO-260620-432MAIN 7 22.48-157.3544989.03 May 21, 2026: 7 @ 22.48
June 19, 2026issueSO-260619-991MAIN 7 22.48-157.35511,146.38 May 21, 2026: 7 @ 22.48
June 12, 2026issueSO-260612-291MAIN 14 22.48-314.69581,303.72 May 21, 2026: 14 @ 22.48
June 5, 2026issueSO-260605-873MAIN 42 22.46-943.50721,618.42 May 7, 2026: 1 @ 21.90; May 21, 2026: 41 @ 22.48
May 21, 2026receiptPO-001515MAIN 113 22.482,540.011142,561.92
May 17, 2026issueSO-260517-702MAIN 112 21.90-2,453.35121.90 May 7, 2026: 112 @ 21.90
May 7, 2026receiptPO-001475MAIN 113 21.902,475.251132,475.25
May 2, 2026issueSO-260502-732MAIN 55 21.82-1,199.8500.00 March 27, 2026: 55 @ 21.82
April 15, 2026issueSO-260415-199MAIN 46 21.82-1,003.51551,199.85 March 27, 2026: 46 @ 21.82
April 9, 2026issueSO-260409-305MAIN 18 22.12-398.251012,203.37 March 12, 2026: 6 @ 22.74; March 27, 2026: 12 @ 21.82
March 27, 2026receiptPO-001361MAIN 113 21.822,465.151192,601.61
March 21, 2026issueSO-260321-548MAIN 13 22.74-295.676136.46 March 12, 2026: 13 @ 22.74
March 21, 2026issueSO-260321-548EAST 1 22.74-22.7419432.13 March 12, 2026: 1 @ 22.74
March 19, 2026issueSO-260319-969MAIN 15 22.74-341.1620454.88 March 12, 2026: 15 @ 22.74
March 16, 2026issueSO-260316-476MAIN 74 22.74-1,683.0435796.03 March 12, 2026: 74 @ 22.74
March 13, 2026issueSO-260313-339MAIN 5 22.61-113.041092,479.07 Jan. 16, 2026: 1 @ 22.07; March 12, 2026: 4 @ 22.74
March 12, 2026receiptPO-001310MAIN 113 22.742,570.051142,592.12
March 9, 2026issueSO-260309-864EAST 5 22.07-110.35122.07 Jan. 16, 2026: 5 @ 22.07
March 9, 2026issueSO-260309-864MAIN 14 22.07-308.986132.42 Jan. 16, 2026: 14 @ 22.07
March 8, 2026issueSO-260308-742MAIN 2 22.07-44.1420441.40 Jan. 16, 2026: 2 @ 22.07
March 3, 2026issueSO-260303-510MAIN 23 22.07-507.6122485.54 Jan. 16, 2026: 23 @ 22.07
Feb. 26, 2026issueSO-260226-938MAIN 23 22.07-507.6145993.14 Jan. 16, 2026: 23 @ 22.07
Feb. 21, 2026issueSO-260221-485EAST 21 22.07-463.47681,500.75 Jan. 16, 2026: 21 @ 22.07
Feb. 9, 2026issueSO-260209-909MAIN 26 22.05-573.33891,964.21 Nov. 30, 2025: 2 @ 21.83; Jan. 16, 2026: 24 @ 22.07
Feb. 4, 2026issueSO-260204-468MAIN 7 21.83-152.811152,537.55 Nov. 30, 2025: 7 @ 21.83
Feb. 3, 2026issueSO-260203-575MAIN 7 21.83-152.811222,690.35 Nov. 30, 2025: 7 @ 21.83
Jan. 18, 2026issueSO-260118-188MAIN 11 21.83-240.131292,843.16 Nov. 30, 2025: 11 @ 21.83
Jan. 16, 2026receiptPO-001149MAIN 113 22.072,493.891403,083.29
Jan. 7, 2026issueSO-260107-840MAIN 29 21.83-633.0627589.40 Nov. 30, 2025: 29 @ 21.83
Jan. 4, 2026issueSO-260104-806EAST 10 21.83-218.30561,222.46 Nov. 30, 2025: 10 @ 21.83
Dec. 25, 2025issueSO-251225-117MAIN 1 21.83-21.83661,440.76 Nov. 30, 2025: 1 @ 21.83
Dec. 24, 2025issueSO-251224-923MAIN 5 21.83-109.15671,462.59 Nov. 30, 2025: 5 @ 21.83
Dec. 23, 2025issueSO-251223-504MAIN 9 21.83-196.47721,571.74 Nov. 30, 2025: 9 @ 21.83
Dec. 22, 2025issueSO-251222-758MAIN 38 21.89-831.78811,768.21 Oct. 31, 2025: 6 @ 22.20; Nov. 30, 2025: 32 @ 21.83
Dec. 16, 2025issueSO-251216-236MAIN 11 22.20-244.251192,599.98 Oct. 31, 2025: 11 @ 22.20
Nov. 30, 2025transferTRFMAIN → EAST 37 warehouse transfer, no cost effect
Nov. 30, 2025receiptPO-001028MAIN 113 21.832,466.761302,844.23
Nov. 23, 2025issueSO-251123-314MAIN 14 22.20-310.8617377.48 Oct. 31, 2025: 14 @ 22.20
Nov. 16, 2025issueSO-251116-346MAIN 50 22.20-1,110.2331688.34 Oct. 31, 2025: 50 @ 22.20
Nov. 16, 2025issueSO-251116-346EAST 8 22.20-177.64811,798.57 Oct. 31, 2025: 8 @ 22.20
Nov. 14, 2025issueSO-251114-206MAIN 14 22.20-310.86891,976.21 Oct. 31, 2025: 14 @ 22.20
Nov. 1, 2025issueSO-251101-196MAIN 18 21.84-393.081032,287.07 Sept. 22, 2025: 8 @ 21.38; Oct. 31, 2025: 10 @ 22.20
Oct. 31, 2025receiptPO-000968MAIN 113 22.202,509.121212,680.15
Oct. 23, 2025issueSO-251023-223EAST 1 21.38-21.388171.03 Sept. 22, 2025: 1 @ 21.38
Oct. 23, 2025issueSO-251023-223MAIN 17 21.38-363.459192.41 Sept. 22, 2025: 17 @ 21.38
Oct. 22, 2025issueSO-251022-657EAST 12 21.38-256.5526555.86 Sept. 22, 2025: 12 @ 21.38
Oct. 9, 2025issueSO-251009-503MAIN 12 21.38-256.5538812.41 Sept. 22, 2025: 12 @ 21.38
Oct. 7, 2025issueSO-251007-116MAIN 14 21.38-299.31501,068.96 Sept. 22, 2025: 14 @ 21.38
Oct. 6, 2025issueSO-251006-674MAIN 24 21.38-513.10641,368.27 Sept. 22, 2025: 24 @ 21.38
Oct. 1, 2025issueSO-251001-845MAIN 19 21.38-406.20881,881.37 Sept. 22, 2025: 19 @ 21.38
Sept. 22, 2025issueSO-250922-271EAST 10 21.51-215.071072,287.57 July 1, 2025: 4 @ 21.70; Sept. 22, 2025: 6 @ 21.38
Sept. 22, 2025transferTRFMAIN → EAST 29 warehouse transfer, no cost effect
Sept. 22, 2025receiptPO-000866MAIN 113 21.382,415.851172,502.65
Sept. 14, 2025issueSO-250914-413MAIN 40 21.70-868.00486.80 July 1, 2025: 40 @ 21.70
Aug. 26, 2025issueSO-250826-719EAST 11 21.70-238.7044954.80 July 1, 2025: 11 @ 21.70
Aug. 22, 2025issueSO-250822-862MAIN 18 21.70-390.60551,193.49 July 1, 2025: 18 @ 21.70
Aug. 11, 2025issueSO-250811-623EAST 4 21.70-86.80731,584.09 July 1, 2025: 4 @ 21.70
Aug. 10, 2025issueSO-250810-781MAIN 24 21.70-520.80771,670.89 July 1, 2025: 24 @ 21.70
Aug. 8, 2025issueSO-250808-946MAIN 2 21.70-43.401012,191.69 July 1, 2025: 2 @ 21.70
July 30, 2025issueSO-250730-533EAST 11 21.68-238.521032,235.09 June 1, 2025: 1 @ 21.53; July 1, 2025: 10 @ 21.70
July 24, 2025issueSO-250724-849MAIN 3 21.53-64.581142,473.61 June 1, 2025: 3 @ 21.53
July 21, 2025issueSO-250721-358MAIN 7 21.53-150.681172,538.19 June 1, 2025: 7 @ 21.53
July 8, 2025issueSO-250708-180MAIN 6 21.53-129.151242,688.86 June 1, 2025: 6 @ 21.53
July 7, 2025issueSO-250707-157MAIN 2 21.53-43.051302,818.02 June 1, 2025: 2 @ 21.53
July 6, 2025issueSO-250706-467EAST 3 21.53-64.581322,861.07 June 1, 2025: 3 @ 21.53
July 2, 2025issueSO-250702-506MAIN 1 21.53-21.531352,925.64 June 1, 2025: 1 @ 21.53
July 1, 2025transferTRFMAIN → EAST 31 warehouse transfer, no cost effect
July 1, 2025receiptPO-000677MAIN 113 21.702,452.091362,947.17
June 25, 2025issueSO-250625-454MAIN 4 21.53-86.1023495.08 June 1, 2025: 4 @ 21.53
June 23, 2025issueSO-250623-759MAIN 7 21.53-150.6827581.18 June 1, 2025: 7 @ 21.53
June 11, 2025issueSO-250611-708MAIN 60 21.53-1,291.5134731.85 June 1, 2025: 60 @ 21.53
June 5, 2025issueSO-250605-904MAIN 4 21.53-86.10942,023.36 June 1, 2025: 4 @ 21.53
June 2, 2025issueSO-250602-803MAIN 15 21.53-322.88982,109.46 June 1, 2025: 15 @ 21.53
June 1, 2025receiptPO-000597MAIN 113 21.532,432.341132,432.34
May 24, 2025issueSO-250524-574MAIN 36 21.04-757.4700.00 April 30, 2025: 36 @ 21.04
May 17, 2025issueSO-250517-835MAIN 61 21.04-1,283.4836757.47 April 30, 2025: 61 @ 21.04
May 13, 2025issueSO-250513-174MAIN 27 21.15-570.97972,040.95 March 23, 2025: 11 @ 21.30; April 30, 2025: 16 @ 21.04
April 30, 2025receiptPO-000495MAIN 113 21.042,377.601242,611.92
April 26, 2025issueSO-250426-151MAIN 24 21.30-511.2411234.32 March 23, 2025: 24 @ 21.30
April 25, 2025issueSO-250425-837MAIN 6 21.30-127.8135745.56 March 23, 2025: 6 @ 21.30
April 14, 2025issueSO-250414-228MAIN 38 21.30-809.4641873.37 March 23, 2025: 38 @ 21.30
April 12, 2025issueSO-250412-145MAIN 4 21.30-85.21791,682.83 March 23, 2025: 4 @ 21.30
April 5, 2025issueSO-250405-219MAIN 9 21.30-191.71831,768.03 March 23, 2025: 9 @ 21.30
April 3, 2025issueSO-250403-438MAIN 11 21.30-234.32921,959.75 March 23, 2025: 11 @ 21.30
March 31, 2025issueSO-250331-176MAIN 10 21.30-213.021032,194.06 March 23, 2025: 10 @ 21.30
March 23, 2025receiptPO-000372MAIN 113 21.302,407.081132,407.08
March 22, 2025issueSO-250322-947MAIN 9 21.27-191.4500.00 Jan. 27, 2025: 1 @ 21.21; Feb. 1, 2025: 1 @ 21.76; Feb. 11, 2025: 7 @ 21.21
March 20, 2025issueSO-250320-619MAIN 6 21.21-127.279191.45 Jan. 27, 2025: 6 @ 21.21
March 18, 2025issueSO-250318-966MAIN 47 21.21-996.9115318.71 Jan. 27, 2025: 47 @ 21.21
March 1, 2025issueSO-250301-415MAIN 16 21.21-339.37621,315.62 Jan. 27, 2025: 16 @ 21.21
Feb. 23, 2025issueSO-250223-964MAIN 9 21.21-190.90781,655.00 Jan. 27, 2025: 9 @ 21.21
Feb. 20, 2025issueSO-250220-962MAIN 6 21.21-127.27871,845.90 Jan. 27, 2025: 6 @ 21.21
Feb. 11, 2025returnRMAMAIN 7 21.21148.48931,973.16
Feb. 10, 2025issueSO-250210-977MAIN 2 21.21-42.42861,824.68 Jan. 27, 2025: 2 @ 21.21
Feb. 8, 2025issueSO-250208-690MAIN 10 21.21-212.11881,867.11 Jan. 27, 2025: 10 @ 21.21
Feb. 5, 2025issueSO-250205-843MAIN 17 21.24-361.13982,079.22 Jan. 9, 2025: 1 @ 21.76; Jan. 27, 2025: 16 @ 21.21
Feb. 4, 2025issueSO-250204-973MAIN 14 21.76-304.611152,440.35 Dec. 7, 2024: 14 @ 21.76
Feb. 1, 2025returnRMAMAIN 1 21.7621.761292,744.96
Jan. 27, 2025receiptPO-000225MAIN 113 21.212,396.831282,723.20
Jan. 26, 2025issueSO-250126-149MAIN 1 21.76-21.7615326.37 Dec. 7, 2024: 1 @ 21.76
Jan. 19, 2025issueSO-250119-899MAIN 54 21.76-1,174.9416348.13 Dec. 7, 2024: 54 @ 21.76
Jan. 9, 2025returnRMAMAIN 1 21.7621.76701,523.07
Jan. 6, 2025issueSO-250106-371MAIN 3 21.76-65.27691,501.32 Dec. 7, 2024: 3 @ 21.76
Dec. 30, 2024issueSO-241230-395MAIN 33 21.76-718.02721,566.59 Dec. 7, 2024: 33 @ 21.76
Dec. 29, 2024issueSO-241229-514MAIN 15 21.54-323.101052,284.61 Oct. 27, 2024: 7 @ 21.29; Dec. 7, 2024: 8 @ 21.76
Dec. 27, 2024issueSO-241227-497MAIN 1 21.29-21.291202,607.71 Oct. 27, 2024: 1 @ 21.29
Dec. 25, 2024issueSO-241225-421MAIN 6 21.29-127.741212,629.00 Oct. 27, 2024: 6 @ 21.29
Dec. 7, 2024receiptPO-000083MAIN 113 21.762,458.681272,756.74
Nov. 30, 2024issueSO-241130-437MAIN 34 21.29-723.8614298.06 Oct. 27, 2024: 34 @ 21.29
Nov. 25, 2024issueSO-241125-355MAIN 24 21.29-510.96481,021.92 Oct. 27, 2024: 24 @ 21.29
Nov. 18, 2024issueSO-241118-785MAIN 1 21.29-21.29721,532.89 Oct. 27, 2024: 1 @ 21.29
Nov. 10, 2024issueSO-241110-435MAIN 29 21.29-617.41731,554.18 Oct. 27, 2024: 29 @ 21.29
Nov. 9, 2024issueSO-241109-742MAIN 11 21.29-234.191022,171.59 Oct. 27, 2024: 11 @ 21.29
Oct. 27, 2024receiptPO-000014MAIN 113 21.292,405.781132,405.78
Oct. 21, 2024issueSO-241021-699MAIN 125 21.76-2,719.3800.00 Oct. 1, 2024: 125 @ 21.76
Oct. 1, 2024receiptPO-000005MAIN 125 21.762,719.381252,719.38