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, latest 60 shown - show all

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