stocksense

Items / MCB-0032

Distribution Board 8-way Prime MCB-0032 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)56MAIN 56
Value (FIFO)5,684.38avg 101.51
ClassAX / FCV 0.48
Turnover14.6xlast issue 1 days ago
Days of cover38lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00320.025.651.276.7102Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 31.0Nov 24: 32.0Dec 24: 78.0Jan 25: 43.0Feb 25: 18.0Mar 25: 65.0Apr 25: 65.0May 25: 18.0Jun 25: 45.0Jul 25: 46.0Aug 25: 70.0Sep 25: 58.0Oct 25: 46.0Nov 25: 20.0Dec 25: 33.0Jan 26: 26.0Feb 26: 23.0Mar 26: 93.0Apr 26: 40.0May 26: 30.0Jun 26: 36.0Jul 26: 55.0Aug 26: 75.0Sep 26: 64.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.437545.08 / 30.43751.481
Daily demand sdmonthly sd / sqrt(30.4375)21.62 / 5.5173.919
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(7.0 * 3.919^2 + 1.481^2 * 1.5^2)21.8
Reorder pointd * LT + safety stock1.481 * 7.0 + 21.832.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days32.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 541/yr, S = 45.00, h = 20%, price = 100.3149.2
Inventory positionon hand + on order56 + 056

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

From qtyUnit costOrder qtyAnnual costFeasible
0100.314955,219yes (chosen if cheapest)

MOQ 36, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 3, 202656 / 65101.515,684.38

Movement ledger 120 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-481MAIN 8 101.51-812.05565,684.38 Oct. 3, 2026: 8 @ 101.51
Oct. 10, 2026issueSO-261010-266MAIN 1 101.51-101.51646,496.44 Oct. 3, 2026: 1 @ 101.51
Oct. 3, 2026receiptPO-001849MAIN 65 101.516,597.94656,597.94
Oct. 1, 2026issueSO-261001-877MAIN 1 98.30-98.3000.00 Aug. 25, 2026: 1 @ 98.30
Sept. 28, 2026issueSO-260928-889MAIN 22 98.30-2,162.58198.30 Aug. 25, 2026: 22 @ 98.30
Sept. 27, 2026issueSO-260927-368MAIN 32 98.30-3,145.56232,260.87 Aug. 25, 2026: 32 @ 98.30
Sept. 12, 2026issueSO-260912-412MAIN 4 98.30-393.20555,406.44 Aug. 25, 2026: 4 @ 98.30
Sept. 3, 2026issueSO-260903-855MAIN 2 98.30-196.60595,799.64 Aug. 25, 2026: 2 @ 98.30
Sept. 2, 2026issueSO-260902-501MAIN 4 98.30-393.20615,996.23 Aug. 25, 2026: 4 @ 98.30
Aug. 25, 2026receiptPO-001747MAIN 65 98.306,389.43656,389.43
Aug. 23, 2026issueSO-260823-672EAST 3 99.38-298.1500.00 July 16, 2026: 3 @ 99.38
Aug. 19, 2026issueSO-260819-393EAST 13 99.38-1,292.003298.15 July 16, 2026: 13 @ 99.38
Aug. 19, 2026issueSO-260819-393MAIN 25 99.38-2,484.61161,590.15 July 16, 2026: 25 @ 99.38
Aug. 10, 2026issueSO-260810-205MAIN 2 99.38-198.77414,074.76 July 16, 2026: 2 @ 99.38
Aug. 1, 2026issueSO-260801-138MAIN 32 99.47-3,183.18434,273.52 July 2, 2026: 10 @ 99.67; July 16, 2026: 22 @ 99.38
July 19, 2026issueSO-260719-543MAIN 4 99.67-398.69757,456.71 July 2, 2026: 4 @ 99.67
July 16, 2026transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
July 16, 2026receiptPO-001650MAIN 65 99.386,459.98797,855.40
July 8, 2026issueSO-260708-284MAIN 51 99.67-5,083.32141,395.42 July 2, 2026: 51 @ 99.67
July 2, 2026receiptPO-001619MAIN 65 99.676,478.74656,478.74
June 25, 2026issueSO-260625-530MAIN 19 97.47-1,851.8400.00 April 18, 2026: 18 @ 97.47; May 19, 2026: 1 @ 97.47
June 17, 2026issueSO-260617-509MAIN 5 97.47-487.33191,851.84 April 18, 2026: 5 @ 97.47
June 11, 2026issueSO-260611-384MAIN 12 97.47-1,169.58242,339.17 April 18, 2026: 12 @ 97.47
May 20, 2026issueSO-260520-451MAIN 6 97.47-584.79363,508.75 April 18, 2026: 6 @ 97.47
May 19, 2026returnRMAMAIN 1 97.4797.47424,093.54
May 17, 2026issueSO-260517-415MAIN 5 97.47-487.33413,996.08 April 18, 2026: 5 @ 97.47
May 14, 2026issueSO-260514-657MAIN 2 97.47-194.93464,483.40 April 18, 2026: 2 @ 97.47
May 3, 2026issueSO-260503-323MAIN 2 97.47-194.93484,678.33 April 18, 2026: 2 @ 97.47
May 1, 2026issueSO-260501-755MAIN 16 97.45-1,559.20504,873.26 March 14, 2026: 1 @ 97.22; April 18, 2026: 15 @ 97.47
April 25, 2026issueSO-260425-913MAIN 11 97.22-1,069.44666,432.47 March 14, 2026: 11 @ 97.22
April 18, 2026receiptPO-001420MAIN 65 97.476,335.24777,501.91
April 10, 2026issueSO-260410-485MAIN 29 97.22-2,819.44121,166.67 March 14, 2026: 29 @ 97.22
March 22, 2026issueSO-260322-715MAIN 22 97.22-2,138.89413,986.11 March 14, 2026: 22 @ 97.22
March 20, 2026issueSO-260320-447MAIN 2 97.22-194.44636,124.99 March 14, 2026: 2 @ 97.22
March 14, 2026receiptPO-001319MAIN 65 97.226,319.44656,319.44
March 9, 2026issueSO-260309-281MAIN 64 99.42-6,363.1200.00 Feb. 11, 2026: 64 @ 99.42
March 9, 2026issueSO-260309-281EAST 5 96.48-482.42646,363.12 Dec. 13, 2025: 4 @ 95.75; Feb. 11, 2026: 1 @ 99.42
Feb. 22, 2026issueSO-260222-802EAST 11 95.75-1,053.24696,845.54 Dec. 13, 2025: 11 @ 95.75
Feb. 11, 2026transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
Feb. 11, 2026receiptPO-001219MAIN 65 99.426,462.55807,898.78
Feb. 7, 2026issueSO-260207-875MAIN 12 95.75-1,148.99151,436.23 Dec. 13, 2025: 12 @ 95.75
Jan. 21, 2026issueSO-260121-354MAIN 9 95.75-861.74272,585.22 Dec. 13, 2025: 9 @ 95.75
Jan. 12, 2026issueSO-260112-863MAIN 10 95.75-957.49363,446.96 Dec. 13, 2025: 10 @ 95.75
Jan. 10, 2026issueSO-260110-499MAIN 6 95.75-574.49464,404.45 Dec. 13, 2025: 6 @ 95.75
Jan. 6, 2026issueSO-260106-175MAIN 1 95.75-95.75524,978.94 Dec. 13, 2025: 1 @ 95.75
Dec. 17, 2025issueSO-251217-959MAIN 25 94.97-2,374.26535,074.69 Oct. 24, 2025: 13 @ 94.25; Dec. 13, 2025: 12 @ 95.75
Dec. 13, 2025receiptPO-001050MAIN 65 95.756,223.68787,448.95
Dec. 7, 2025issueSO-251207-550MAIN 8 94.25-754.02131,225.28 Oct. 24, 2025: 8 @ 94.25
Nov. 28, 2025issueSO-251128-771MAIN 10 94.25-942.52211,979.29 Oct. 24, 2025: 10 @ 94.25
Nov. 27, 2025issueSO-251127-870MAIN 10 94.25-942.52312,921.81 Oct. 24, 2025: 10 @ 94.25
Oct. 29, 2025issueSO-251029-624MAIN 4 94.25-377.01413,864.33 Oct. 24, 2025: 4 @ 94.25
Oct. 24, 2025issueSO-251024-437MAIN 20 94.25-1,885.04454,241.34 Oct. 24, 2025: 20 @ 94.25
Oct. 24, 2025receiptPO-000948MAIN 65 94.256,126.38656,126.38
Oct. 23, 2025issueSO-251023-202MAIN 7 96.84-677.9100.00 Sept. 2, 2025: 7 @ 96.84
Oct. 21, 2025issueSO-251021-290MAIN 9 96.84-871.597677.91 Sept. 2, 2025: 9 @ 96.84
Oct. 18, 2025issueSO-251018-289MAIN 1 96.84-96.84161,549.50 Sept. 2, 2025: 1 @ 96.84
Oct. 3, 2025issueSO-251003-176MAIN 5 96.84-484.22171,646.34 Sept. 2, 2025: 5 @ 96.84
Sept. 22, 2025issueSO-250922-346MAIN 15 96.84-1,452.65222,130.56 Sept. 2, 2025: 15 @ 96.84
Sept. 10, 2025issueSO-250910-445MAIN 4 96.84-387.37373,583.21 Sept. 2, 2025: 4 @ 96.84
Sept. 6, 2025issueSO-250906-577MAIN 3 96.84-290.53413,970.59 Sept. 2, 2025: 3 @ 96.84
Sept. 6, 2025issueSO-250906-577EAST 15 96.84-1,452.65444,261.12 Sept. 2, 2025: 15 @ 96.84
Sept. 2, 2025issueSO-250902-336MAIN 21 95.99-2,015.87595,713.77 Aug. 10, 2025: 15 @ 95.65; Sept. 2, 2025: 6 @ 96.84
Sept. 2, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Sept. 2, 2025receiptPO-000810MAIN 65 96.846,294.83807,729.64
Aug. 25, 2025issueSO-250825-364MAIN 10 95.65-956.54151,434.81 Aug. 10, 2025: 10 @ 95.65
Aug. 12, 2025issueSO-250812-940MAIN 11 95.65-1,052.19252,391.34 Aug. 10, 2025: 11 @ 95.65
Aug. 11, 2025issueSO-250811-586MAIN 29 95.65-2,773.96363,443.53 Aug. 10, 2025: 29 @ 95.65
Aug. 10, 2025receiptPO-000769MAIN 65 95.656,217.49656,217.49
Aug. 1, 2025issueSO-250801-371MAIN 20 96.91-1,938.1700.00 June 19, 2025: 20 @ 96.91
July 17, 2025issueSO-250717-837MAIN 44 96.91-4,263.97201,938.17 June 19, 2025: 44 @ 96.91
July 14, 2025issueSO-250714-495MAIN 2 95.38-190.75646,202.13 May 7, 2025: 1 @ 93.84; June 19, 2025: 1 @ 96.91
June 26, 2025adjustmentCycle countMAIN -1 93.84-93.84666,392.88 May 7, 2025: 1 @ 93.84
June 19, 2025receiptPO-000650MAIN 65 96.916,299.04676,486.73
June 16, 2025issueSO-250616-806MAIN 22 93.84-2,064.572187.69 May 7, 2025: 22 @ 93.84
June 7, 2025issueSO-250607-945MAIN 23 93.84-2,158.42242,252.26 May 7, 2025: 23 @ 93.84
May 30, 2025issueSO-250530-311MAIN 3 93.84-281.53474,410.68 May 7, 2025: 3 @ 93.84
May 17, 2025issueSO-250517-422MAIN 2 93.84-187.69504,692.22 May 7, 2025: 2 @ 93.84
May 12, 2025issueSO-250512-561MAIN 2 93.84-187.69524,879.90 May 7, 2025: 2 @ 93.84
May 10, 2025issueSO-250510-213MAIN 11 93.84-1,032.29545,067.59 May 7, 2025: 11 @ 93.84
May 7, 2025receiptPO-000522MAIN 65 93.846,099.88656,099.88
April 29, 2025issueSO-250429-651EAST 22 95.48-2,100.6200.00 April 2, 2025: 22 @ 95.48
April 29, 2025issueSO-250429-651MAIN 38 95.48-3,628.34222,100.62 April 2, 2025: 38 @ 95.48
April 5, 2025issueSO-250405-714MAIN 5 95.48-477.41605,728.96 April 2, 2025: 5 @ 95.48
April 2, 2025transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
April 2, 2025receiptPO-000404MAIN 65 95.486,206.37656,206.37
March 30, 2025issueSO-250330-911MAIN 1 92.59-92.5900.00 Feb. 27, 2025: 1 @ 92.59
March 27, 2025issueSO-250327-865MAIN 26 92.59-2,407.34192.59 Feb. 27, 2025: 26 @ 92.59
March 27, 2025issueSO-250327-865EAST 18 92.59-1,666.62272,499.93 Feb. 27, 2025: 18 @ 92.59
March 8, 2025issueSO-250308-310MAIN 8 92.59-740.72454,166.55 Feb. 27, 2025: 8 @ 92.59
March 5, 2025issueSO-250305-523MAIN 5 92.59-462.95534,907.27 Feb. 27, 2025: 5 @ 92.59
March 2, 2025issueSO-250302-416MAIN 7 92.59-648.13585,370.22 Feb. 27, 2025: 7 @ 92.59
Feb. 27, 2025transferTRFMAIN → EAST 18 warehouse transfer, no cost effect
Feb. 27, 2025receiptPO-000302MAIN 65 92.596,018.35656,018.35
Feb. 18, 2025issueSO-250218-302MAIN 18 92.22-1,659.9900.00 Dec. 20, 2024: 18 @ 92.22
Jan. 29, 2025issueSO-250129-885MAIN 24 92.22-2,213.31181,659.99 Dec. 20, 2024: 24 @ 92.22
Jan. 15, 2025issueSO-250115-877MAIN 10 92.22-922.21423,873.30 Dec. 20, 2024: 10 @ 92.22
Jan. 4, 2025issueSO-250104-190MAIN 9 92.22-829.99524,795.51 Dec. 20, 2024: 9 @ 92.22
Dec. 27, 2024issueSO-241227-248MAIN 4 92.22-368.89615,625.51 Dec. 20, 2024: 4 @ 92.22
Dec. 20, 2024receiptPO-000122MAIN 65 92.225,994.39655,994.39
Dec. 16, 2024issueSO-241216-753MAIN 10 93.05-930.5400.00 Nov. 30, 2024: 10 @ 93.05
Dec. 13, 2024issueSO-241213-822MAIN 32 93.05-2,977.7210930.54 Nov. 30, 2024: 32 @ 93.05
Dec. 7, 2024issueSO-241207-730MAIN 29 93.52-2,712.00423,908.25 Oct. 1, 2024: 6 @ 95.29; Nov. 30, 2024: 23 @ 93.05
Dec. 2, 2024issueSO-241202-661MAIN 3 95.29-285.88716,620.25 Oct. 1, 2024: 3 @ 95.29
Nov. 30, 2024receiptPO-000069MAIN 65 93.056,048.48746,906.13
Nov. 24, 2024issueSO-241124-172MAIN 10 95.29-952.949857.65 Oct. 1, 2024: 10 @ 95.29
Nov. 22, 2024issueSO-241122-545MAIN 2 95.29-190.59191,810.60 Oct. 1, 2024: 2 @ 95.29
Nov. 13, 2024issueSO-241113-796MAIN 3 95.29-285.88212,001.18 Oct. 1, 2024: 3 @ 95.29
Nov. 8, 2024issueSO-241108-229MAIN 2 95.29-190.59242,287.07 Oct. 1, 2024: 2 @ 95.29
Nov. 7, 2024issueSO-241107-568MAIN 9 95.29-857.65262,477.66 Oct. 1, 2024: 9 @ 95.29
Nov. 5, 2024issueSO-241105-940MAIN 1 95.29-95.29353,335.31 Oct. 1, 2024: 1 @ 95.29
Nov. 1, 2024issueSO-241101-333MAIN 5 95.29-476.47363,430.60 Oct. 1, 2024: 5 @ 95.29
Oct. 25, 2024issueSO-241025-183MAIN 3 95.29-285.88413,907.07 Oct. 1, 2024: 3 @ 95.29
Oct. 18, 2024issueSO-241018-221MAIN 3 95.29-285.88444,192.96 Oct. 1, 2024: 3 @ 95.29
Oct. 15, 2024issueSO-241015-744EAST 10 95.29-952.94474,478.84 Oct. 1, 2024: 10 @ 95.29
Oct. 14, 2024issueSO-241014-330EAST 2 95.29-190.59575,431.79 Oct. 1, 2024: 2 @ 95.29
Oct. 5, 2024issueSO-241005-369MAIN 2 95.29-190.59595,622.38 Oct. 1, 2024: 2 @ 95.29
Oct. 2, 2024issueSO-241002-902MAIN 2 95.29-190.59615,812.96 Oct. 1, 2024: 2 @ 95.29
Oct. 1, 2024issueSO-241001-800EAST 9 95.29-857.65636,003.55 Oct. 1, 2024: 9 @ 95.29
Oct. 1, 2024transferTRFMAIN → EAST 21 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 72 95.296,861.20726,861.20