stocksense

Items / MCB-0031

MCB 6A SP Elite MCB-0031 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)8MAIN 8
Value (FIFO)723.88avg 90.49
ClassBY / FCV 0.55
Turnover13.2xlast issue 0 days ago
Days of cover14lead time 7d

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

Demand and forecast

Monthly demand and forecast for MCB-00310.017.635.252.870.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 8.0Nov 24: 23.0Dec 24: 19.0Jan 25: 21.0Feb 25: 64.0Mar 25: 9.0Apr 25: 25.0May 25: 9.0Jun 25: 13.0Jul 25: 15.0Aug 25: 8.0Sep 25: 20.0Oct 25: 11.0Nov 25: 7.0Dec 25: 20.0Jan 26: 28.0Feb 26: 33.0Mar 26: 0.0Apr 26: 11.0May 26: 12.0Jun 26: 14.0Jul 26: 27.0Aug 26: 17.0Sep 26: 26.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.437517.17 / 30.43750.564
Daily demand sdmonthly sd / sqrt(30.4375)9.41 / 5.5171.705
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.705^2 + 0.564^2 * 1.5^2)7.5
Reorder pointd * LT + safety stock0.564 * 7.0 + 7.511.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days11.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 206/yr, S = 45.00, h = 20%, price = 90.5832.0
Inventory positionon hand + on order8 + 08

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

From qtyUnit costOrder qtyAnnual costFeasible
090.583219,226yes (chosen if cheapest)

MOQ 18, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 11, 20264 / 3391.13364.51
Sept. 13, 20262 / 288.56177.11
Sept. 30, 20262 / 291.13182.26

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-174MAIN 1 91.13-91.138723.88 Sept. 11, 2026: 1 @ 91.13
Oct. 12, 2026issueSO-261012-395MAIN 1 91.13-91.139815.01 Sept. 11, 2026: 1 @ 91.13
Oct. 9, 2026issueSO-261009-574MAIN 11 91.13-1,002.4110906.14 Sept. 11, 2026: 11 @ 91.13
Oct. 7, 2026issueSO-261007-885MAIN 4 91.13-364.51211,908.55 Sept. 11, 2026: 4 @ 91.13
Sept. 30, 2026returnRMAMAIN 2 91.13182.26252,273.06
Sept. 22, 2026issueSO-260922-678MAIN 4 91.13-364.51232,090.80 Sept. 11, 2026: 4 @ 91.13
Sept. 21, 2026issueSO-260921-968MAIN 5 91.13-455.64272,455.32 Sept. 11, 2026: 5 @ 91.13
Sept. 16, 2026issueSO-260916-920MAIN 1 91.13-91.13322,910.96 Sept. 11, 2026: 1 @ 91.13
Sept. 14, 2026issueSO-260914-244MAIN 8 89.20-713.60333,002.08 July 21, 2026: 6 @ 88.56; Sept. 11, 2026: 2 @ 91.13
Sept. 13, 2026returnRMAMAIN 2 88.56177.11413,715.68
Sept. 11, 2026receiptPO-001790MAIN 33 91.133,007.23393,538.57
Sept. 7, 2026issueSO-260907-791MAIN 4 88.56-354.236531.34 July 21, 2026: 4 @ 88.56
Sept. 4, 2026issueSO-260904-181MAIN 8 88.56-708.4610885.57 July 21, 2026: 8 @ 88.56
Aug. 28, 2026issueSO-260828-409MAIN 1 88.56-88.56181,594.02 July 21, 2026: 1 @ 88.56
Aug. 26, 2026issueSO-260826-690MAIN 6 88.56-531.34191,682.58 July 21, 2026: 6 @ 88.56
Aug. 14, 2026issueSO-260814-145MAIN 3 88.56-265.67252,213.92 July 21, 2026: 3 @ 88.56
Aug. 14, 2026issueSO-260814-145EAST 7 88.20-617.40282,479.59 June 9, 2026: 1 @ 88.80; June 12, 2026: 1 @ 85.81; July 21, 2026: 5 @ 88.56
July 22, 2026issueSO-260722-889MAIN 4 88.80-355.21353,096.99 June 9, 2026: 4 @ 88.80
July 21, 2026transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
July 21, 2026receiptPO-001659MAIN 33 88.562,922.38393,452.20
July 13, 2026issueSO-260713-772MAIN 1 88.80-88.806529.83 June 9, 2026: 1 @ 88.80
July 12, 2026issueSO-260712-342MAIN 2 88.80-177.617618.63 June 9, 2026: 2 @ 88.80
July 9, 2026issueSO-260709-899MAIN 6 88.80-532.829796.23 June 9, 2026: 6 @ 88.80
July 8, 2026issueSO-260708-149MAIN 14 88.80-1,243.24151,329.05 June 9, 2026: 14 @ 88.80
June 26, 2026issueSO-260626-697MAIN 1 88.80-88.80292,572.29 June 9, 2026: 1 @ 88.80
June 23, 2026issueSO-260623-534MAIN 4 88.80-355.21302,661.09 June 9, 2026: 4 @ 88.80
June 12, 2026returnRMAMAIN 1 85.8185.81343,016.30
June 9, 2026receiptPO-001565MAIN 33 88.802,930.49332,930.49
June 8, 2026issueSO-260608-788MAIN 2 85.81-171.6300.00 May 9, 2026: 2 @ 85.81
June 7, 2026issueSO-260607-501MAIN 2 85.81-171.632171.63 March 4, 2026: 2 @ 85.81
June 5, 2026issueSO-260605-929MAIN 1 85.81-85.814343.25 March 4, 2026: 1 @ 85.81
June 4, 2026issueSO-260604-719MAIN 2 85.81-171.635429.06 March 4, 2026: 2 @ 85.81
June 3, 2026issueSO-260603-904MAIN 3 85.81-257.447600.69 March 4, 2026: 3 @ 85.81
May 29, 2026issueSO-260529-790MAIN 2 85.81-171.6310858.13 March 4, 2026: 2 @ 85.81
May 24, 2026issueSO-260524-931MAIN 1 85.81-85.81121,029.75 March 4, 2026: 1 @ 85.81
May 23, 2026issueSO-260523-456MAIN 1 85.81-85.81131,115.57 March 4, 2026: 1 @ 85.81
May 11, 2026issueSO-260511-123MAIN 9 85.81-772.32141,201.38 March 4, 2026: 9 @ 85.81
May 9, 2026returnRMAMAIN 2 85.81171.63231,973.70
May 9, 2026issueSO-260509-628MAIN 1 85.81-85.81211,802.07 March 4, 2026: 1 @ 85.81
April 25, 2026issueSO-260425-520MAIN 1 85.81-85.81221,887.88 March 4, 2026: 1 @ 85.81
April 23, 2026issueSO-260423-697MAIN 5 85.81-429.06231,973.70 March 4, 2026: 5 @ 85.81
April 22, 2026issueSO-260422-827MAIN 4 85.81-343.25282,402.76 March 4, 2026: 4 @ 85.81
April 21, 2026issueSO-260421-453MAIN 1 85.81-85.81322,746.01 March 4, 2026: 1 @ 85.81
March 4, 2026receiptPO-001284MAIN 33 85.812,831.83332,831.83
Feb. 23, 2026issueSO-260223-909MAIN 11 87.34-960.7300.00 Jan. 30, 2026: 11 @ 87.34
Feb. 14, 2026issueSO-260214-753MAIN 1 87.34-87.3411960.73 Jan. 30, 2026: 1 @ 87.34
Feb. 12, 2026issueSO-260212-292MAIN 21 87.34-1,834.12121,048.07 Jan. 30, 2026: 21 @ 87.34
Jan. 30, 2026receiptPO-001188MAIN 33 87.342,882.18332,882.18
Jan. 25, 2026issueSO-260125-770EAST 10 85.76-857.6000.00 Dec. 12, 2025: 10 @ 85.76
Jan. 25, 2026issueSO-260125-770MAIN 7 85.76-600.3210857.60 Dec. 12, 2025: 7 @ 85.76
Jan. 22, 2026issueSO-260122-905MAIN 5 85.76-428.80171,457.92 Dec. 12, 2025: 5 @ 85.76
Jan. 12, 2026issueSO-260112-334MAIN 6 85.76-514.56221,886.72 Dec. 12, 2025: 6 @ 85.76
Dec. 31, 2025issueSO-251231-773EAST 1 85.76-85.76282,401.28 Dec. 12, 2025: 1 @ 85.76
Dec. 29, 2025issueSO-251229-970MAIN 3 85.76-257.28292,487.04 Dec. 12, 2025: 3 @ 85.76
Dec. 19, 2025issueSO-251219-741MAIN 1 85.76-85.76322,744.32 Dec. 12, 2025: 1 @ 85.76
Dec. 12, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Dec. 12, 2025receiptPO-001046MAIN 33 85.762,830.08332,830.08
Dec. 8, 2025issueSO-251208-226MAIN 2 86.29-172.5900.00 Sept. 30, 2025: 2 @ 86.29
Dec. 7, 2025issueSO-251207-903MAIN 13 86.29-1,121.822172.59 Sept. 30, 2025: 13 @ 86.29
Nov. 24, 2025issueSO-251124-693MAIN 4 86.29-345.17151,294.40 Sept. 30, 2025: 4 @ 86.29
Nov. 6, 2025issueSO-251106-587MAIN 3 86.29-258.88191,639.58 Sept. 30, 2025: 3 @ 86.29
Oct. 30, 2025issueSO-251030-964MAIN 4 86.29-345.17221,898.46 Sept. 30, 2025: 4 @ 86.29
Oct. 9, 2025issueSO-251009-899MAIN 6 86.29-517.76262,243.63 Sept. 30, 2025: 6 @ 86.29
Oct. 1, 2025issueSO-251001-929MAIN 1 86.29-86.29322,761.39 Sept. 30, 2025: 1 @ 86.29
Sept. 30, 2025receiptPO-000891MAIN 33 86.292,847.69332,847.69
Sept. 21, 2025issueSO-250921-281MAIN 9 83.56-752.0600.00 July 13, 2025: 9 @ 83.56
Sept. 18, 2025issueSO-250918-666MAIN 6 83.56-501.389752.06 July 13, 2025: 6 @ 83.56
Sept. 17, 2025issueSO-250917-391MAIN 2 83.56-167.13151,253.44 July 13, 2025: 2 @ 83.56
Sept. 3, 2025issueSO-250903-511MAIN 3 83.56-250.69171,420.56 July 13, 2025: 3 @ 83.56
Aug. 28, 2025issueSO-250828-180MAIN 1 83.56-83.56201,671.25 July 13, 2025: 1 @ 83.56
Aug. 7, 2025issueSO-250807-591MAIN 2 83.56-167.13211,754.81 July 13, 2025: 2 @ 83.56
Aug. 3, 2025issueSO-250803-806MAIN 5 83.56-417.81231,921.94 July 13, 2025: 5 @ 83.56
July 30, 2025issueSO-250730-369MAIN 2 83.56-167.13282,339.75 July 13, 2025: 2 @ 83.56
July 26, 2025issueSO-250726-521MAIN 2 83.56-167.13302,506.88 July 13, 2025: 2 @ 83.56
July 18, 2025issueSO-250718-273MAIN 1 83.56-83.56322,674.00 July 13, 2025: 1 @ 83.56
July 13, 2025receiptPO-000707MAIN 33 83.562,757.57332,757.57
July 8, 2025issueSO-250708-888MAIN 2 82.83-165.6500.00 May 29, 2025: 2 @ 82.83
July 7, 2025issueSO-250707-749MAIN 6 82.83-496.962165.65 April 14, 2025: 6 @ 82.83
July 3, 2025issueSO-250703-372MAIN 2 82.83-165.658662.61 April 14, 2025: 2 @ 82.83
June 24, 2025issueSO-250624-236MAIN 2 82.83-165.6510828.26 April 14, 2025: 2 @ 82.83
June 24, 2025issueSO-250624-236EAST 4 82.83-331.3112993.92 April 14, 2025: 4 @ 82.83
June 21, 2025issueSO-250621-827EAST 2 82.83-165.65161,325.22 April 14, 2025: 2 @ 82.83
June 18, 2025issueSO-250618-996MAIN 3 82.83-248.48181,490.88 April 14, 2025: 3 @ 82.83
June 1, 2025issueSO-250601-181EAST 2 82.83-165.65211,739.35 April 14, 2025: 2 @ 82.83
May 29, 2025returnRMAMAIN 2 82.83165.65231,905.01
May 22, 2025issueSO-250522-343MAIN 1 82.83-82.83211,739.35 April 14, 2025: 1 @ 82.83
May 14, 2025issueSO-250514-953MAIN 6 82.83-496.96221,822.18 April 14, 2025: 6 @ 82.83
May 13, 2025issueSO-250513-406MAIN 4 82.83-331.31282,319.14 April 14, 2025: 4 @ 82.83
April 18, 2025issueSO-250418-831MAIN 1 82.83-82.83322,650.44 April 14, 2025: 1 @ 82.83
April 16, 2025issueSO-250416-480MAIN 1 86.19-86.19332,733.27 March 5, 2025: 1 @ 86.19
April 14, 2025transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
April 14, 2025receiptPO-000447MAIN 33 82.832,733.27342,819.46
April 9, 2025issueSO-250409-688MAIN 1 86.19-86.19186.19 March 5, 2025: 1 @ 86.19
April 5, 2025issueSO-250405-359MAIN 8 86.19-689.532172.38 March 5, 2025: 8 @ 86.19
April 5, 2025issueSO-250405-359EAST 7 86.19-603.3410861.92 March 5, 2025: 7 @ 86.19
April 4, 2025issueSO-250404-653MAIN 3 86.19-258.58171,465.26 March 5, 2025: 3 @ 86.19
April 2, 2025issueSO-250402-336MAIN 4 86.19-344.77201,723.84 March 5, 2025: 4 @ 86.19
March 27, 2025issueSO-250327-576MAIN 1 86.19-86.19242,068.60 March 5, 2025: 1 @ 86.19
March 20, 2025issueSO-250320-139MAIN 1 86.19-86.19252,154.80 March 5, 2025: 1 @ 86.19
March 17, 2025issueSO-250317-679MAIN 1 86.19-86.19262,240.99 March 5, 2025: 1 @ 86.19
March 8, 2025issueSO-250308-259MAIN 6 86.19-517.15272,327.18 March 5, 2025: 6 @ 86.19
March 5, 2025transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
March 5, 2025receiptPO-000319MAIN 33 86.192,844.33332,844.33
Feb. 24, 2025issueSO-250224-311MAIN 26 86.47-2,248.3200.00 Feb. 11, 2025: 26 @ 86.47
Feb. 14, 2025issueSO-250214-696MAIN 7 86.47-605.32262,248.32 Feb. 11, 2025: 7 @ 86.47
Feb. 11, 2025receiptPO-000260MAIN 33 86.472,853.64332,853.64
Feb. 2, 2025issueSO-250202-572EAST 8 83.52-668.1800.00 Jan. 13, 2025: 8 @ 83.52
Feb. 2, 2025issueSO-250202-572MAIN 23 83.52-1,921.038668.18 Jan. 13, 2025: 23 @ 83.52
Jan. 14, 2025issueSO-250114-202MAIN 1 83.52-83.52312,589.21 Jan. 13, 2025: 1 @ 83.52
Jan. 13, 2025issueSO-250113-665MAIN 1 83.52-83.52322,672.74 Jan. 13, 2025: 1 @ 83.52
Jan. 13, 2025transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Jan. 13, 2025receiptPO-000183MAIN 33 83.522,756.26332,756.26
Jan. 6, 2025issueSO-250106-479EAST 4 83.95-335.8000.00 Dec. 4, 2024: 4 @ 83.95
Jan. 6, 2025issueSO-250106-479MAIN 15 83.95-1,259.264335.80 Dec. 4, 2024: 15 @ 83.95
Dec. 28, 2024issueSO-241228-436MAIN 8 83.95-671.61191,595.06 Dec. 4, 2024: 8 @ 83.95
Dec. 20, 2024issueSO-241220-802EAST 4 83.95-335.80272,266.67 Dec. 4, 2024: 4 @ 83.95
Dec. 8, 2024issueSO-241208-778MAIN 7 85.45-598.16312,602.47 Oct. 1, 2024: 5 @ 86.05; Dec. 4, 2024: 2 @ 83.95
Dec. 4, 2024transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Dec. 4, 2024receiptPO-000079MAIN 33 83.952,770.37383,200.63
Nov. 26, 2024issueSO-241126-305MAIN 3 86.05-258.155430.26 Oct. 1, 2024: 3 @ 86.05
Nov. 25, 2024issueSO-241125-715MAIN 3 86.05-258.158688.41 Oct. 1, 2024: 3 @ 86.05
Nov. 18, 2024issueSO-241118-477MAIN 3 86.05-258.1511946.56 Oct. 1, 2024: 3 @ 86.05
Nov. 13, 2024issueSO-241113-445MAIN 3 86.05-258.15141,204.71 Oct. 1, 2024: 3 @ 86.05
Nov. 5, 2024issueSO-241105-461MAIN 9 86.05-774.46171,462.87 Oct. 1, 2024: 9 @ 86.05
Nov. 1, 2024issueSO-241101-352MAIN 2 86.05-172.10262,237.33 Oct. 1, 2024: 2 @ 86.05
Oct. 22, 2024issueSO-241022-901MAIN 3 86.05-258.15282,409.43 Oct. 1, 2024: 3 @ 86.05
Oct. 21, 2024issueSO-241021-939MAIN 1 86.05-86.05312,667.58 Oct. 1, 2024: 1 @ 86.05
Oct. 13, 2024issueSO-241013-304MAIN 2 86.05-172.10322,753.63 Oct. 1, 2024: 2 @ 86.05
Oct. 8, 2024issueSO-241008-141MAIN 1 86.05-86.05342,925.73 Oct. 1, 2024: 1 @ 86.05
Oct. 1, 2024issueSO-241001-149MAIN 1 86.05-86.05353,011.78 Oct. 1, 2024: 1 @ 86.05
Oct. 1, 2024receiptPO-000005MAIN 36 86.053,097.84363,097.84