stocksense

Items / MCB-0014

MCB 16A DP Flex MCB-0014 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)8MAIN 7, EAST 1
Value (FIFO)494.96avg 61.87
ClassCY / FCV 0.56
Turnover14.0xlast issue 0 days ago
Days of cover21lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00140.08.216.524.833.0Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 13.0Nov 24: 9.0Dec 24: 7.0Jan 25: 7.0Feb 25: 26.0Mar 25: 6.0Apr 25: 11.0May 25: 10.0Jun 25: 8.0Jul 25: 5.0Aug 25: 12.0Sep 25: 13.0Oct 25: 11.0Nov 25: 8.0Dec 25: 5.0Jan 26: 10.0Feb 26: 7.0Mar 26: 13.0Apr 26: 8.0May 26: 10.0Jun 26: 30.0Jul 26: 13.0Aug 26: 20.0Sep 26: 7.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.437511.83 / 30.43750.389
Daily demand sdmonthly sd / sqrt(30.4375)6.64 / 5.5171.204
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.204^2 + 0.389^2 * 1.5^2)4.1
Reorder pointd * LT + safety stock0.389 * 7.0 + 4.16.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days6.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 142/yr, S = 45.00, h = 20%, price = 62.1032.1
Inventory positionon hand + on order8 + 08

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

From qtyUnit costOrder qtyAnnual costFeasible
062.10329,210yes (chosen if cheapest)

MOQ 11, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 2, 20265 / 2061.65308.24
Sept. 7, 20263 / 362.24186.73

Movement ledger 130 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-647EAST 1 61.65-61.658494.96 Sept. 2, 2026: 1 @ 61.65
Oct. 13, 2026issueSO-261013-156MAIN 4 61.65-246.599556.61 Sept. 2, 2026: 4 @ 61.65
Sept. 30, 2026issueSO-260930-942MAIN 1 61.65-61.6513803.20 Sept. 2, 2026: 1 @ 61.65
Sept. 29, 2026issueSO-260929-411MAIN 4 61.65-246.5914864.85 Sept. 2, 2026: 4 @ 61.65
Sept. 25, 2026issueSO-260925-868MAIN 1 61.65-61.65181,111.44 Sept. 2, 2026: 1 @ 61.65
Sept. 19, 2026issueSO-260919-748EAST 4 61.65-246.59191,173.09 Sept. 2, 2026: 4 @ 61.65
Sept. 7, 2026returnRMAMAIN 3 62.24186.73231,419.68
Sept. 2, 2026transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Sept. 2, 2026receiptPO-001771MAIN 20 61.651,232.96201,232.96
Aug. 25, 2026issueSO-260825-157MAIN 10 62.24-622.4200.00 Aug. 5, 2026: 10 @ 62.24
Aug. 22, 2026issueSO-260822-630MAIN 1 62.24-62.2410622.42 Aug. 5, 2026: 1 @ 62.24
Aug. 18, 2026issueSO-260818-623MAIN 7 62.24-435.6911684.66 Aug. 5, 2026: 7 @ 62.24
Aug. 11, 2026issueSO-260811-175MAIN 2 62.24-124.48181,120.36 Aug. 5, 2026: 2 @ 62.24
Aug. 5, 2026receiptPO-001697MAIN 20 62.241,244.84201,244.84
July 31, 2026issueSO-260731-739MAIN 5 59.84-299.2200.00 June 30, 2026: 5 @ 59.84
July 18, 2026issueSO-260718-153MAIN 5 59.84-299.225299.22 June 30, 2026: 5 @ 59.84
July 10, 2026issueSO-260710-583MAIN 3 59.84-179.5310598.44 June 30, 2026: 3 @ 59.84
June 30, 2026issueSO-260630-660MAIN 7 59.84-418.9113777.97 June 30, 2026: 7 @ 59.84
June 30, 2026receiptPO-001614MAIN 20 59.841,196.88201,196.88
June 25, 2026issueSO-260625-634MAIN 4 62.94-251.7500.00 June 7, 2026: 4 @ 62.94
June 24, 2026issueSO-260624-508EAST 6 62.94-377.634251.75 June 7, 2026: 6 @ 62.94
June 15, 2026issueSO-260615-233MAIN 10 62.94-629.3910629.39 June 7, 2026: 10 @ 62.94
June 7, 2026transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
June 7, 2026receiptPO-001556MAIN 20 62.941,258.77201,258.77
June 2, 2026issueSO-260602-735MAIN 3 61.29-183.8700.00 March 20, 2026: 3 @ 61.29
May 30, 2026issueSO-260530-950MAIN 5 61.29-306.453183.87 March 20, 2026: 5 @ 61.29
May 22, 2026issueSO-260522-959MAIN 1 61.29-61.298490.32 March 20, 2026: 1 @ 61.29
May 17, 2026issueSO-260517-203MAIN 1 61.29-61.299551.61 March 20, 2026: 1 @ 61.29
May 14, 2026issueSO-260514-341MAIN 2 61.29-122.5810612.90 March 20, 2026: 2 @ 61.29
May 1, 2026issueSO-260501-215MAIN 1 61.29-61.2912735.48 March 20, 2026: 1 @ 61.29
April 21, 2026issueSO-260421-456MAIN 3 61.29-183.8713796.77 March 20, 2026: 3 @ 61.29
April 16, 2026issueSO-260416-408MAIN 1 61.29-61.2916980.64 March 20, 2026: 1 @ 61.29
April 4, 2026issueSO-260404-533MAIN 1 61.29-61.29171,041.93 March 20, 2026: 1 @ 61.29
April 3, 2026issueSO-260403-286MAIN 2 61.29-122.58181,103.22 March 20, 2026: 2 @ 61.29
April 2, 2026issueSO-260402-268MAIN 1 61.34-61.34201,225.80 Jan. 31, 2026: 1 @ 61.34
March 31, 2026issueSO-260331-272MAIN 2 61.34-122.68211,287.14 Jan. 31, 2026: 2 @ 61.34
March 26, 2026issueSO-260326-410MAIN 1 61.34-61.34231,409.83 Jan. 31, 2026: 1 @ 61.34
March 20, 2026receiptPO-001338MAIN 20 61.291,225.80241,471.17
March 11, 2026issueSO-260311-178MAIN 1 61.34-61.344245.37 Jan. 31, 2026: 1 @ 61.34
March 9, 2026issueSO-260309-641MAIN 2 61.34-122.685306.71 Jan. 31, 2026: 2 @ 61.34
March 7, 2026issueSO-260307-850MAIN 4 61.34-245.377429.39 Jan. 31, 2026: 4 @ 61.34
March 1, 2026issueSO-260301-307MAIN 3 61.34-184.0311674.76 Jan. 31, 2026: 3 @ 61.34
Feb. 20, 2026issueSO-260220-166MAIN 5 61.34-306.7114858.79 Jan. 31, 2026: 5 @ 61.34
Feb. 20, 2026issueSO-260220-166EAST 1 61.34-61.34191,165.49 Jan. 31, 2026: 1 @ 61.34
Feb. 6, 2026issueSO-260206-777MAIN 1 60.72-60.72201,226.84 Oct. 31, 2025: 1 @ 60.72
Jan. 31, 2026receiptPO-001189MAIN 20 61.341,226.84211,287.55
Jan. 25, 2026issueSO-260125-575EAST 2 60.72-121.43160.72 Oct. 31, 2025: 2 @ 60.72
Jan. 24, 2026issueSO-260124-629EAST 1 60.72-60.723182.15 Oct. 31, 2025: 1 @ 60.72
Jan. 24, 2026issueSO-260124-629MAIN 1 60.72-60.724242.87 Oct. 31, 2025: 1 @ 60.72
Jan. 22, 2026issueSO-260122-432MAIN 3 60.72-182.155303.58 Oct. 31, 2025: 3 @ 60.72
Jan. 15, 2026issueSO-260115-420MAIN 1 60.72-60.728485.74 Oct. 31, 2025: 1 @ 60.72
Jan. 13, 2026issueSO-260113-669MAIN 1 60.72-60.729546.45 Oct. 31, 2025: 1 @ 60.72
Jan. 1, 2026issueSO-260101-820MAIN 1 60.72-60.7210607.17 Oct. 31, 2025: 1 @ 60.72
Dec. 19, 2025issueSO-251219-748MAIN 1 60.72-60.7211667.89 Oct. 31, 2025: 1 @ 60.72
Dec. 6, 2025issueSO-251206-144MAIN 3 60.72-182.1512728.60 Oct. 31, 2025: 3 @ 60.72
Dec. 2, 2025issueSO-251202-737MAIN 1 60.72-60.7215910.75 Oct. 31, 2025: 1 @ 60.72
Nov. 26, 2025issueSO-251126-272MAIN 1 60.72-60.7216971.47 Oct. 31, 2025: 1 @ 60.72
Nov. 17, 2025issueSO-251117-281MAIN 2 60.72-121.43171,032.19 Oct. 31, 2025: 2 @ 60.72
Nov. 10, 2025issueSO-251110-210MAIN 2 59.18-118.36191,153.62 Sept. 17, 2025: 1 @ 57.65; Oct. 31, 2025: 1 @ 60.72
Nov. 5, 2025issueSO-251105-648MAIN 1 57.65-57.65211,271.98 Sept. 17, 2025: 1 @ 57.65
Nov. 4, 2025issueSO-251104-802EAST 1 57.65-57.65221,329.63 Sept. 17, 2025: 1 @ 57.65
Nov. 3, 2025issueSO-251103-253MAIN 1 57.65-57.65231,387.28 Sept. 17, 2025: 1 @ 57.65
Oct. 31, 2025transferTRFMAIN → EAST 5 warehouse transfer, no cost effect
Oct. 31, 2025receiptPO-000967MAIN 20 60.721,214.34241,444.92
Oct. 26, 2025issueSO-251026-885MAIN 1 57.65-57.654230.59 Sept. 17, 2025: 1 @ 57.65
Oct. 25, 2025issueSO-251025-851MAIN 5 57.65-288.235288.23 Sept. 17, 2025: 5 @ 57.65
Oct. 24, 2025issueSO-251024-469MAIN 3 57.65-172.9410576.46 Sept. 17, 2025: 3 @ 57.65
Oct. 20, 2025issueSO-251020-916MAIN 1 57.65-57.6513749.40 Sept. 17, 2025: 1 @ 57.65
Oct. 2, 2025issueSO-251002-634MAIN 1 57.65-57.6514807.05 Sept. 17, 2025: 1 @ 57.65
Sept. 20, 2025issueSO-250920-306MAIN 5 57.65-288.2315864.69 Sept. 17, 2025: 5 @ 57.65
Sept. 17, 2025receiptPO-000854MAIN 20 57.651,152.93201,152.93
Sept. 8, 2025issueSO-250908-634MAIN 8 57.63-461.0200.00 July 11, 2025: 8 @ 57.63
Aug. 29, 2025issueSO-250829-791MAIN 1 57.63-57.638461.02 July 11, 2025: 1 @ 57.63
Aug. 24, 2025issueSO-250824-806MAIN 2 57.63-115.269518.65 July 11, 2025: 2 @ 57.63
Aug. 17, 2025issueSO-250817-743EAST 5 57.63-288.1411633.91 July 11, 2025: 5 @ 57.63
Aug. 8, 2025issueSO-250808-611MAIN 1 57.63-57.6316922.05 July 11, 2025: 1 @ 57.63
Aug. 6, 2025issueSO-250806-908MAIN 1 57.63-57.6317979.68 July 11, 2025: 1 @ 57.63
Aug. 5, 2025issueSO-250805-842MAIN 2 57.63-115.26181,037.31 July 11, 2025: 2 @ 57.63
July 11, 2025transferTRFMAIN → EAST 5 warehouse transfer, no cost effect
July 11, 2025receiptPO-000701MAIN 20 57.631,152.56201,152.56
July 1, 2025issueSO-250701-621MAIN 5 59.72-298.5900.00 April 28, 2025: 4 @ 59.95; May 1, 2025: 1 @ 58.79
June 30, 2025issueSO-250630-833MAIN 1 59.95-59.955298.59 April 28, 2025: 1 @ 59.95
June 15, 2025issueSO-250615-848MAIN 1 59.95-59.956358.54 April 28, 2025: 1 @ 59.95
June 11, 2025issueSO-250611-841MAIN 3 59.95-179.857418.48 April 28, 2025: 3 @ 59.95
June 10, 2025issueSO-250610-611MAIN 2 59.95-119.9010598.33 April 28, 2025: 2 @ 59.95
June 7, 2025issueSO-250607-697MAIN 1 59.95-59.9512718.23 April 28, 2025: 1 @ 59.95
May 28, 2025issueSO-250528-400MAIN 1 59.95-59.9513778.18 April 28, 2025: 1 @ 59.95
May 22, 2025issueSO-250522-306MAIN 1 59.95-59.9514838.13 April 28, 2025: 1 @ 59.95
May 18, 2025issueSO-250518-335MAIN 2 59.95-119.9015898.08 April 28, 2025: 2 @ 59.95
May 13, 2025issueSO-250513-519MAIN 7 59.45-416.17171,017.98 March 6, 2025: 3 @ 58.79; April 28, 2025: 4 @ 59.95
May 1, 2025returnRMAMAIN 1 58.7958.79241,434.14
April 28, 2025receiptPO-000490MAIN 20 59.951,198.98231,375.35
April 27, 2025issueSO-250427-844MAIN 1 58.79-58.793176.37 March 6, 2025: 1 @ 58.79
April 21, 2025issueSO-250421-141MAIN 3 58.79-176.374235.16 March 6, 2025: 3 @ 58.79
April 20, 2025issueSO-250420-939MAIN 1 58.79-58.797411.53 March 6, 2025: 1 @ 58.79
April 14, 2025issueSO-250414-293MAIN 2 58.79-117.588470.32 March 6, 2025: 2 @ 58.79
April 12, 2025issueSO-250412-452MAIN 1 58.79-58.7910587.90 March 6, 2025: 1 @ 58.79
April 1, 2025issueSO-250401-927MAIN 3 58.79-176.3711646.69 March 6, 2025: 3 @ 58.79
March 25, 2025issueSO-250325-769MAIN 1 58.79-58.7914823.06 March 6, 2025: 1 @ 58.79
March 18, 2025issueSO-250318-711MAIN 3 58.79-176.3715881.85 March 6, 2025: 3 @ 58.79
March 8, 2025issueSO-250308-250MAIN 2 58.79-117.58181,058.21 March 6, 2025: 2 @ 58.79
March 6, 2025receiptPO-000322MAIN 20 58.791,175.79201,175.79
Feb. 25, 2025issueSO-250225-704MAIN 18 58.70-1,056.5900.00 Feb. 10, 2025: 18 @ 58.70
Feb. 14, 2025issueSO-250214-249MAIN 2 58.70-117.40181,056.59 Feb. 10, 2025: 2 @ 58.70
Feb. 10, 2025receiptPO-000256MAIN 20 58.701,173.99201,173.99
Feb. 8, 2025issueSO-250208-771MAIN 1 56.37-56.3700.00 Dec. 1, 2024: 1 @ 56.37
Feb. 4, 2025issueSO-250204-724MAIN 2 56.37-112.74156.37 Dec. 1, 2024: 2 @ 56.37
Feb. 1, 2025issueSO-250201-227MAIN 3 56.37-169.123169.12 Dec. 1, 2024: 3 @ 56.37
Jan. 20, 2025issueSO-250120-601MAIN 3 56.37-169.126338.23 Dec. 1, 2024: 3 @ 56.37
Jan. 14, 2025issueSO-250114-543MAIN 4 56.37-225.499507.35 Dec. 1, 2024: 4 @ 56.37
Dec. 31, 2024issueSO-241231-624MAIN 2 56.37-112.7413732.84 Dec. 1, 2024: 2 @ 56.37
Dec. 26, 2024issueSO-241226-814MAIN 2 56.37-112.7415845.58 Dec. 1, 2024: 2 @ 56.37
Dec. 21, 2024issueSO-241221-941MAIN 3 56.37-169.1217958.33 Dec. 1, 2024: 3 @ 56.37
Dec. 1, 2024receiptPO-000073MAIN 20 56.371,127.45201,127.45
Nov. 30, 2024issueSO-241130-348EAST 1 59.00-59.0000.00 Oct. 1, 2024: 1 @ 59.00
Nov. 26, 2024issueSO-241126-532EAST 2 59.00-117.99159.00 Oct. 1, 2024: 2 @ 59.00
Nov. 24, 2024issueSO-241124-652MAIN 1 59.00-59.003176.98 Oct. 1, 2024: 1 @ 59.00
Nov. 22, 2024issueSO-241122-169MAIN 1 59.00-59.004235.98 Oct. 1, 2024: 1 @ 59.00
Nov. 20, 2024issueSO-241120-841EAST 2 59.00-117.995294.98 Oct. 1, 2024: 2 @ 59.00
Nov. 9, 2024issueSO-241109-471MAIN 1 59.00-59.007412.96 Oct. 1, 2024: 1 @ 59.00
Nov. 4, 2024issueSO-241104-766EAST 1 59.00-59.008471.96 Oct. 1, 2024: 1 @ 59.00
Oct. 30, 2024issueSO-241030-473EAST 1 59.00-59.009530.96 Oct. 1, 2024: 1 @ 59.00
Oct. 29, 2024issueSO-241029-780MAIN 6 59.00-353.9710589.95 Oct. 1, 2024: 6 @ 59.00
Oct. 20, 2024issueSO-241020-620MAIN 1 59.00-59.0016943.92 Oct. 1, 2024: 1 @ 59.00
Oct. 11, 2024issueSO-241011-585MAIN 1 59.00-59.00171,002.92 Oct. 1, 2024: 1 @ 59.00
Oct. 8, 2024issueSO-241008-380MAIN 2 59.00-117.99181,061.91 Oct. 1, 2024: 2 @ 59.00
Oct. 6, 2024issueSO-241006-563MAIN 1 59.00-59.00201,179.90 Oct. 1, 2024: 1 @ 59.00
Oct. 3, 2024issueSO-241003-804MAIN 1 59.00-59.00211,238.90 Oct. 1, 2024: 1 @ 59.00
Oct. 1, 2024transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 22 59.001,297.89221,297.89