stocksense

Items / MCB-0013

MCB 6A SP Lite MCB-0013 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)0
Value (FIFO)0.00avg 0.00
ClassCX / FCV 0.46
Turnover12.4xlast issue 2 days ago
Days of cover0lead time 7d

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

Demand and forecast

Monthly demand and forecast for MCB-00130.06.913.820.627.5Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 22.0Nov 24: 8.0Dec 24: 9.0Jan 25: 11.0Feb 25: 13.0Mar 25: 18.0Apr 25: 8.0May 25: 17.0Jun 25: 13.0Jul 25: 11.0Aug 25: 14.0Sep 25: 8.0Oct 25: 24.0Nov 25: 13.0Dec 25: 14.0Jan 26: 8.0Feb 26: 13.0Mar 26: 10.0Apr 26: 11.0May 26: 9.0Jun 26: 12.0Jul 26: 25.0Aug 26: 7.0Sep 26: 6.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.437512.67 / 30.43750.416
Daily demand sdmonthly sd / sqrt(30.4375)5.81 / 5.5171.053
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.053^2 + 0.416^2 * 1.5^2)3.7
Reorder pointd * LT + safety stock0.416 * 7.0 + 3.76.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days6.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 152/yr, S = 45.00, h = 20%, price = 49.5637.1
Inventory positionon hand + on order0 + 00

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

From qtyUnit costOrder qtyAnnual costFeasible
049.56377,896yes (chosen if cheapest)

MOQ 12, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
No stock.

Movement ledger 138 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-584MAIN 5 48.94-244.7200.00 July 22, 2026: 4 @ 48.94; Oct. 1, 2026: 1 @ 48.94
Oct. 13, 2026issueSO-261013-767MAIN 1 48.94-48.945244.72 July 22, 2026: 1 @ 48.94
Oct. 11, 2026issueSO-261011-239MAIN 1 48.94-48.946293.66 July 22, 2026: 1 @ 48.94
Oct. 1, 2026returnRMAMAIN 1 48.9448.947342.61
Sept. 28, 2026issueSO-260928-610MAIN 1 48.94-48.946293.66 July 22, 2026: 1 @ 48.94
Sept. 27, 2026issueSO-260927-963MAIN 1 48.94-48.947342.61 July 22, 2026: 1 @ 48.94
Sept. 16, 2026issueSO-260916-790MAIN 1 48.94-48.948391.55 July 22, 2026: 1 @ 48.94
Sept. 13, 2026issueSO-260913-857MAIN 2 48.94-97.899440.50 July 22, 2026: 2 @ 48.94
Sept. 11, 2026issueSO-260911-941MAIN 1 48.94-48.9411538.38 July 22, 2026: 1 @ 48.94
Aug. 12, 2026issueSO-260812-398MAIN 1 48.94-48.9412587.33 July 22, 2026: 1 @ 48.94
Aug. 10, 2026issueSO-260810-538MAIN 1 48.94-48.9413636.27 July 22, 2026: 1 @ 48.94
Aug. 9, 2026issueSO-260809-503MAIN 5 48.94-244.7214685.21 July 22, 2026: 5 @ 48.94
July 27, 2026issueSO-260727-508MAIN 1 48.94-48.9419929.93 July 22, 2026: 1 @ 48.94
July 23, 2026issueSO-260723-229MAIN 2 48.94-97.8920978.88 July 22, 2026: 2 @ 48.94
July 22, 2026receiptPO-001662MAIN 22 48.941,076.77221,076.77
July 17, 2026issueSO-260717-195MAIN 1 49.25-49.2500.00 June 30, 2026: 1 @ 49.25
July 16, 2026issueSO-260716-121MAIN 10 49.25-492.48149.25 June 30, 2026: 10 @ 49.25
July 11, 2026issueSO-260711-122MAIN 1 49.25-49.2511541.73 June 30, 2026: 1 @ 49.25
July 5, 2026issueSO-260705-630MAIN 8 49.25-393.9912590.98 June 30, 2026: 8 @ 49.25
July 1, 2026issueSO-260701-127MAIN 2 49.25-98.5020984.97 June 30, 2026: 2 @ 49.25
June 30, 2026receiptPO-001613MAIN 22 49.251,083.46221,083.46
June 24, 2026issueSO-260624-971EAST 1 48.39-48.3900.00 May 28, 2026: 1 @ 48.39
June 24, 2026issueSO-260624-971MAIN 1 48.39-48.39148.39 April 12, 2026: 1 @ 48.39
June 22, 2026issueSO-260622-918MAIN 6 48.39-290.34296.78 April 12, 2026: 6 @ 48.39
June 16, 2026issueSO-260616-968EAST 1 48.39-48.398387.12 April 12, 2026: 1 @ 48.39
June 14, 2026issueSO-260614-508EAST 2 48.39-96.789435.51 April 12, 2026: 2 @ 48.39
June 2, 2026issueSO-260602-640MAIN 1 48.39-48.3911532.29 April 12, 2026: 1 @ 48.39
May 31, 2026issueSO-260531-987MAIN 5 48.39-241.9512580.68 April 12, 2026: 5 @ 48.39
May 30, 2026issueSO-260530-573MAIN 1 48.39-48.3917822.64 April 12, 2026: 1 @ 48.39
May 28, 2026returnRMAMAIN 1 48.3948.3918871.03
May 22, 2026issueSO-260522-164MAIN 1 48.39-48.3917822.64 April 12, 2026: 1 @ 48.39
May 15, 2026issueSO-260515-840MAIN 1 48.39-48.3918871.03 April 12, 2026: 1 @ 48.39
May 12, 2026issueSO-260512-675MAIN 1 48.39-48.3919919.42 April 12, 2026: 1 @ 48.39
May 2, 2026issueSO-260502-142EAST 1 48.39-48.3920967.81 April 12, 2026: 1 @ 48.39
April 16, 2026issueSO-260416-791MAIN 1 48.39-48.39211,016.20 April 12, 2026: 1 @ 48.39
April 12, 2026issueSO-260412-450MAIN 1 48.06-48.06221,064.59 Feb. 6, 2026: 1 @ 48.06
April 12, 2026transferTRFMAIN → EAST 5 warehouse transfer, no cost effect
April 12, 2026receiptPO-001404MAIN 22 48.391,064.59231,112.65
April 10, 2026issueSO-260410-946MAIN 1 48.06-48.06148.06 Feb. 6, 2026: 1 @ 48.06
April 4, 2026issueSO-260404-842MAIN 1 48.06-48.06296.13 Feb. 6, 2026: 1 @ 48.06
April 4, 2026issueSO-260404-842EAST 5 48.06-240.323144.19 Feb. 6, 2026: 5 @ 48.06
April 3, 2026issueSO-260403-317MAIN 1 48.06-48.068384.50 Feb. 6, 2026: 1 @ 48.06
April 2, 2026issueSO-260402-951EAST 1 48.06-48.069432.57 Feb. 6, 2026: 1 @ 48.06
March 28, 2026issueSO-260328-114MAIN 6 48.06-288.3810480.63 Feb. 6, 2026: 6 @ 48.06
March 26, 2026issueSO-260326-585EAST 1 48.06-48.0616769.01 Feb. 6, 2026: 1 @ 48.06
March 20, 2026issueSO-260320-428MAIN 3 48.06-144.1917817.07 Feb. 6, 2026: 3 @ 48.06
Feb. 7, 2026issueSO-260207-396MAIN 1 48.06-48.0620961.26 Feb. 6, 2026: 1 @ 48.06
Feb. 6, 2026issueSO-260206-726MAIN 1 48.06-48.06211,009.33 Feb. 6, 2026: 1 @ 48.06
Feb. 6, 2026transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
Feb. 6, 2026receiptPO-001204MAIN 22 48.061,057.39221,057.39
Feb. 2, 2026issueSO-260202-803MAIN 11 47.00-517.0400.00 Dec. 22, 2025: 11 @ 47.00
Jan. 31, 2026issueSO-260131-156MAIN 2 47.00-94.0111517.04 Dec. 22, 2025: 2 @ 47.00
Jan. 25, 2026issueSO-260125-960MAIN 2 47.00-94.0113611.04 Dec. 22, 2025: 2 @ 47.00
Jan. 22, 2026issueSO-260122-839MAIN 1 47.00-47.0015705.05 Dec. 22, 2025: 1 @ 47.00
Jan. 17, 2026issueSO-260117-163MAIN 1 47.00-47.0016752.05 Dec. 22, 2025: 1 @ 47.00
Jan. 16, 2026issueSO-260116-637MAIN 1 47.00-47.0017799.05 Dec. 22, 2025: 1 @ 47.00
Jan. 4, 2026issueSO-260104-708MAIN 1 47.00-47.0018846.06 Dec. 22, 2025: 1 @ 47.00
Dec. 29, 2025issueSO-251229-592MAIN 1 47.00-47.0019893.06 Dec. 22, 2025: 1 @ 47.00
Dec. 23, 2025issueSO-251223-410MAIN 1 47.00-47.0020940.06 Dec. 22, 2025: 1 @ 47.00
Dec. 22, 2025issueSO-251222-964MAIN 6 46.72-280.3121987.07 Nov. 7, 2025: 5 @ 46.66; Dec. 22, 2025: 1 @ 47.00
Dec. 22, 2025receiptPO-001075MAIN 22 47.001,034.07271,267.38
Dec. 14, 2025issueSO-251214-434MAIN 5 46.66-233.315233.31 Nov. 7, 2025: 5 @ 46.66
Dec. 8, 2025issueSO-251208-892MAIN 1 46.66-46.6610466.62 Nov. 7, 2025: 1 @ 46.66
Nov. 20, 2025issueSO-251120-338MAIN 4 46.66-186.6511513.28 Nov. 7, 2025: 4 @ 46.66
Nov. 18, 2025issueSO-251118-995MAIN 4 46.66-186.6515699.93 Nov. 7, 2025: 4 @ 46.66
Nov. 17, 2025issueSO-251117-322MAIN 3 46.66-139.9919886.58 Nov. 7, 2025: 3 @ 46.66
Nov. 14, 2025issueSO-251114-528MAIN 1 47.82-47.82221,026.56 Sept. 22, 2025: 1 @ 47.82
Nov. 10, 2025issueSO-251110-821MAIN 1 47.82-47.82231,074.38 Sept. 22, 2025: 1 @ 47.82
Nov. 7, 2025receiptPO-000984MAIN 22 46.661,026.56241,122.20
Oct. 30, 2025issueSO-251030-566MAIN 21 47.77-1,003.20295.64 Aug. 6, 2025: 1 @ 46.84; Sept. 22, 2025: 20 @ 47.82
Oct. 24, 2025issueSO-251024-506MAIN 3 46.84-140.52231,098.83 Aug. 6, 2025: 3 @ 46.84
Sept. 22, 2025receiptPO-000865MAIN 22 47.821,051.99261,239.35
Sept. 16, 2025issueSO-250916-439MAIN 5 46.84-234.204187.36 Aug. 6, 2025: 5 @ 46.84
Sept. 16, 2025issueSO-250916-439EAST 2 46.84-93.689421.56 Aug. 6, 2025: 2 @ 46.84
Sept. 10, 2025issueSO-250910-458MAIN 1 46.84-46.8411515.24 Aug. 6, 2025: 1 @ 46.84
Aug. 31, 2025issueSO-250831-527MAIN 2 46.84-93.6812562.08 Aug. 6, 2025: 2 @ 46.84
Aug. 26, 2025issueSO-250826-921MAIN 1 46.84-46.8414655.76 Aug. 6, 2025: 1 @ 46.84
Aug. 20, 2025issueSO-250820-380MAIN 1 46.84-46.8415702.60 Aug. 6, 2025: 1 @ 46.84
Aug. 11, 2025issueSO-250811-569MAIN 10 46.61-466.0516749.44 June 8, 2025: 4 @ 46.25; Aug. 6, 2025: 6 @ 46.84
Aug. 6, 2025receiptPO-000763MAIN 22 46.841,030.48261,215.49
July 31, 2025issueSO-250731-365EAST 1 46.25-46.254185.01 June 8, 2025: 1 @ 46.25
July 30, 2025issueSO-250730-451MAIN 5 46.25-231.265231.26 June 8, 2025: 5 @ 46.25
July 26, 2025issueSO-250726-819EAST 2 46.25-92.5110462.53 June 8, 2025: 2 @ 46.25
July 23, 2025issueSO-250723-296MAIN 1 46.25-46.2512555.04 June 8, 2025: 1 @ 46.25
July 20, 2025issueSO-250720-918MAIN 1 46.25-46.2513601.29 June 8, 2025: 1 @ 46.25
July 11, 2025issueSO-250711-747MAIN 1 46.25-46.2514647.54 June 8, 2025: 1 @ 46.25
June 29, 2025issueSO-250629-147EAST 3 46.25-138.7615693.80 June 8, 2025: 3 @ 46.25
June 26, 2025issueSO-250626-734MAIN 2 46.25-92.5118832.55 June 8, 2025: 2 @ 46.25
June 10, 2025issueSO-250610-368MAIN 1 46.25-46.2520925.06 June 8, 2025: 1 @ 46.25
June 9, 2025issueSO-250609-257MAIN 6 46.21-277.2721971.31 April 29, 2025: 5 @ 46.20; June 8, 2025: 1 @ 46.25
June 8, 2025transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
June 8, 2025receiptPO-000618MAIN 22 46.251,017.57271,248.58
June 2, 2025issueSO-250602-265MAIN 1 46.20-46.205231.02 April 29, 2025: 1 @ 46.20
May 31, 2025issueSO-250531-958MAIN 4 46.20-184.816277.22 April 29, 2025: 4 @ 46.20
May 31, 2025issueSO-250531-958EAST 1 46.20-46.2010462.04 April 29, 2025: 1 @ 46.20
May 16, 2025issueSO-250516-351EAST 1 46.20-46.2011508.24 April 29, 2025: 1 @ 46.20
May 15, 2025issueSO-250515-753MAIN 6 46.20-277.2212554.44 April 29, 2025: 6 @ 46.20
May 11, 2025issueSO-250511-212MAIN 1 46.20-46.2018831.67 April 29, 2025: 1 @ 46.20
May 10, 2025issueSO-250510-366EAST 4 45.95-183.7919877.87 Feb. 22, 2025: 1 @ 45.18; April 29, 2025: 3 @ 46.20
April 29, 2025transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
April 29, 2025receiptPO-000491MAIN 22 46.201,016.48231,061.66
April 21, 2025issueSO-250421-558MAIN 7 45.18-316.26145.18 Feb. 22, 2025: 7 @ 45.18
April 12, 2025issueSO-250412-143MAIN 1 45.18-45.188361.44 Feb. 22, 2025: 1 @ 45.18
March 30, 2025issueSO-250330-508MAIN 2 45.18-90.369406.62 Feb. 22, 2025: 2 @ 45.18
March 22, 2025issueSO-250322-709MAIN 1 45.18-45.1811496.98 Feb. 22, 2025: 1 @ 45.18
March 20, 2025issueSO-250320-689MAIN 8 45.18-361.4412542.16 Feb. 22, 2025: 8 @ 45.18
March 20, 2025issueSO-250320-689EAST 3 45.33-135.9820903.60 Jan. 10, 2025: 1 @ 45.62; Feb. 22, 2025: 2 @ 45.18
March 14, 2025issueSO-250314-279EAST 1 45.62-45.62231,039.57 Jan. 10, 2025: 1 @ 45.62
March 7, 2025issueSO-250307-520MAIN 2 45.62-91.23241,085.19 Jan. 10, 2025: 2 @ 45.62
March 3, 2025issueSO-250303-953EAST 1 45.62-45.62261,176.43 Jan. 10, 2025: 1 @ 45.62
Feb. 22, 2025receiptPO-000294MAIN 22 45.18993.96271,222.04
Feb. 14, 2025issueSO-250214-554MAIN 6 45.62-273.705228.09 Jan. 10, 2025: 6 @ 45.62
Feb. 9, 2025issueSO-250209-570MAIN 7 45.62-319.3211501.79 Jan. 10, 2025: 7 @ 45.62
Jan. 17, 2025issueSO-250117-390MAIN 1 45.62-45.6218821.11 Jan. 10, 2025: 1 @ 45.62
Jan. 13, 2025issueSO-250113-239MAIN 3 45.62-136.8519866.73 Jan. 10, 2025: 3 @ 45.62
Jan. 10, 2025transferTRFMAIN → EAST 5 warehouse transfer, no cost effect
Jan. 10, 2025receiptPO-000179MAIN 22 45.621,003.58221,003.58
Jan. 6, 2025issueSO-250106-829MAIN 3 47.01-141.0300.00 Nov. 4, 2024: 3 @ 47.01
Jan. 2, 2025issueSO-250102-660MAIN 4 47.01-188.043141.03 Nov. 4, 2024: 4 @ 47.01
Dec. 22, 2024issueSO-241222-656MAIN 3 47.01-141.037329.06 Nov. 4, 2024: 3 @ 47.01
Dec. 20, 2024issueSO-241220-168MAIN 1 47.01-47.0110470.09 Nov. 4, 2024: 1 @ 47.01
Dec. 12, 2024issueSO-241212-287EAST 1 47.01-47.0111517.10 Nov. 4, 2024: 1 @ 47.01
Dec. 10, 2024issueSO-241210-103MAIN 1 47.01-47.0112564.11 Nov. 4, 2024: 1 @ 47.01
Dec. 9, 2024issueSO-241209-718MAIN 1 47.01-47.0113611.12 Nov. 4, 2024: 1 @ 47.01
Dec. 4, 2024issueSO-241204-823MAIN 1 47.01-47.0114658.12 Nov. 4, 2024: 1 @ 47.01
Dec. 1, 2024issueSO-241201-544EAST 1 47.01-47.0115705.13 Nov. 4, 2024: 1 @ 47.01
Nov. 29, 2024issueSO-241129-802MAIN 3 47.01-141.0316752.14 Nov. 4, 2024: 3 @ 47.01
Nov. 15, 2024issueSO-241115-538MAIN 1 47.01-47.0119893.17 Nov. 4, 2024: 1 @ 47.01
Nov. 11, 2024issueSO-241111-503EAST 4 47.05-188.1820940.18 Oct. 1, 2024: 2 @ 47.08; Nov. 4, 2024: 2 @ 47.01
Nov. 4, 2024transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Nov. 4, 2024receiptPO-000024MAIN 22 47.011,034.20241,128.36
Oct. 28, 2024issueSO-241028-857MAIN 4 47.08-188.33294.16 Oct. 1, 2024: 4 @ 47.08
Oct. 19, 2024issueSO-241019-940MAIN 1 47.08-47.086282.49 Oct. 1, 2024: 1 @ 47.08
Oct. 13, 2024issueSO-241013-894MAIN 4 47.08-188.337329.57 Oct. 1, 2024: 4 @ 47.08
Oct. 11, 2024issueSO-241011-566MAIN 6 47.08-282.4911517.90 Oct. 1, 2024: 6 @ 47.08
Oct. 9, 2024issueSO-241009-753MAIN 6 47.08-282.4917800.39 Oct. 1, 2024: 6 @ 47.08
Oct. 6, 2024issueSO-241006-920MAIN 1 47.08-47.08231,082.89 Oct. 1, 2024: 1 @ 47.08
Oct. 1, 2024receiptPO-000005MAIN 24 47.081,129.97241,129.97