stocksense

Items / MCB-0016

Isolator 63A Prime MCB-0016 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)18MAIN 13, EAST 5
Value (FIFO)1,556.92avg 86.50
ClassBX / FCV 0.41
Turnover11.0xlast issue 3 days ago
Days of cover44lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00160.07.715.423.130.8Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 28.0Nov 24: 9.0Dec 24: 9.0Jan 25: 17.0Feb 25: 15.0Mar 25: 22.0Apr 25: 12.0May 25: 11.0Jun 25: 11.0Jul 25: 16.0Aug 25: 11.0Sep 25: 17.0Oct 25: 11.0Nov 25: 15.0Dec 25: 12.0Jan 26: 13.0Feb 26: 10.0Mar 26: 12.0Apr 26: 1.0May 26: 21.0Jun 26: 8.0Jul 26: 21.0Aug 26: 12.0Sep 26: 13.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.42 / 30.43750.408
Daily demand sdmonthly sd / sqrt(30.4375)5.11 / 5.5170.926
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 * 0.926^2 + 0.408^2 * 1.5^2)4.1
Reorder pointd * LT + safety stock0.408 * 7.0 + 4.17.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days7.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 149/yr, S = 45.00, h = 20%, price = 86.1227.9
Inventory positionon hand + on order18 + 018

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

From qtyUnit costOrder qtyAnnual costFeasible
086.122813,304yes (chosen if cheapest)

MOQ 15, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 30, 202618 / 2786.501,556.92

Movement ledger 123 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026issueSO-261013-189EAST 2 86.50-172.99181,556.92 Sept. 30, 2026: 2 @ 86.50
Oct. 9, 2026issueSO-261009-766MAIN 5 86.50-432.48201,729.91 Sept. 30, 2026: 5 @ 86.50
Oct. 6, 2026issueSO-261006-763MAIN 2 86.50-172.99252,162.38 Sept. 30, 2026: 2 @ 86.50
Sept. 30, 2026transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
Sept. 30, 2026receiptPO-001842MAIN 27 86.502,335.37272,335.37
Sept. 23, 2026issueSO-260923-856MAIN 1 82.84-82.8400.00 Aug. 14, 2026: 1 @ 82.84
Sept. 22, 2026issueSO-260922-370MAIN 7 82.84-579.88182.84 July 17, 2026: 7 @ 82.84
Sept. 11, 2026issueSO-260911-503MAIN 5 82.84-414.208662.72 July 17, 2026: 5 @ 82.84
Aug. 31, 2026issueSO-260831-508MAIN 4 82.84-331.36131,076.91 July 17, 2026: 4 @ 82.84
Aug. 29, 2026issueSO-260829-579MAIN 1 82.84-82.84171,408.27 July 17, 2026: 1 @ 82.84
Aug. 21, 2026issueSO-260821-953MAIN 1 82.84-82.84181,491.11 July 17, 2026: 1 @ 82.84
Aug. 17, 2026issueSO-260817-387MAIN 1 82.84-82.84191,573.95 July 17, 2026: 1 @ 82.84
Aug. 14, 2026returnRMAMAIN 1 82.8482.84201,656.79
Aug. 10, 2026issueSO-260810-884MAIN 4 82.84-331.36191,573.95 July 17, 2026: 4 @ 82.84
Aug. 1, 2026issueSO-260801-811MAIN 2 82.84-165.68231,905.31 July 17, 2026: 2 @ 82.84
July 29, 2026issueSO-260729-177MAIN 3 82.83-248.50252,070.98 July 16, 2026: 1 @ 82.82; July 17, 2026: 2 @ 82.84
July 25, 2026issueSO-260725-490MAIN 1 82.82-82.82282,319.48 July 16, 2026: 1 @ 82.82
July 24, 2026issueSO-260724-960MAIN 6 82.82-496.91292,402.30 June 8, 2026: 4 @ 82.82; July 16, 2026: 2 @ 82.82
July 22, 2026issueSO-260722-505MAIN 1 82.82-82.82352,899.21 June 8, 2026: 1 @ 82.82
July 17, 2026receiptPO-001654MAIN 27 82.842,236.66362,982.03
July 16, 2026returnRMAMAIN 4 82.82331.279745.36
July 9, 2026issueSO-260709-459MAIN 5 82.82-414.095414.09 June 8, 2026: 5 @ 82.82
July 3, 2026issueSO-260703-433MAIN 9 82.82-745.3610828.18 June 8, 2026: 9 @ 82.82
June 28, 2026issueSO-260628-734MAIN 1 82.82-82.82191,573.55 June 8, 2026: 1 @ 82.82
June 16, 2026issueSO-260616-858MAIN 1 82.82-82.82201,656.36 June 8, 2026: 1 @ 82.82
June 14, 2026issueSO-260614-762MAIN 3 82.82-248.45211,739.18 June 8, 2026: 3 @ 82.82
June 10, 2026issueSO-260610-523MAIN 3 82.82-248.45241,987.64 June 8, 2026: 3 @ 82.82
June 8, 2026receiptPO-001562MAIN 27 82.822,236.09272,236.09
May 30, 2026issueSO-260530-251MAIN 11 86.28-949.1200.00 March 9, 2026: 9 @ 86.28; April 7, 2026: 2 @ 86.28
May 29, 2026issueSO-260529-354MAIN 2 86.28-172.5711949.12 March 9, 2026: 2 @ 86.28
May 22, 2026issueSO-260522-714MAIN 2 86.28-172.57131,121.69 March 9, 2026: 2 @ 86.28
May 12, 2026issueSO-260512-765MAIN 5 86.28-431.42151,294.25 March 9, 2026: 5 @ 86.28
May 9, 2026issueSO-260509-968MAIN 1 86.28-86.28201,725.67 March 9, 2026: 1 @ 86.28
April 8, 2026issueSO-260408-235MAIN 1 86.28-86.28211,811.95 March 9, 2026: 1 @ 86.28
April 7, 2026returnRMAMAIN 2 86.28172.57221,898.24
April 1, 2026issueSO-260401-871MAIN 2 86.28-172.57201,725.67 March 9, 2026: 2 @ 86.28
March 29, 2026issueSO-260329-738MAIN 2 86.28-172.57221,898.24 March 9, 2026: 2 @ 86.28
March 23, 2026issueSO-260323-964MAIN 4 85.48-341.90242,070.80 Dec. 29, 2025: 1 @ 83.05; March 9, 2026: 3 @ 86.28
March 18, 2026issueSO-260318-987MAIN 1 83.05-83.05282,412.70 Dec. 29, 2025: 1 @ 83.05
March 9, 2026receiptPO-001301MAIN 27 86.282,329.65292,495.75
March 7, 2026issueSO-260307-371MAIN 3 83.05-249.152166.10 Dec. 29, 2025: 3 @ 83.05
March 6, 2026issueSO-260306-209MAIN 1 83.05-83.055415.25 Dec. 29, 2025: 1 @ 83.05
March 2, 2026issueSO-260302-144MAIN 1 83.05-83.056498.30 Dec. 29, 2025: 1 @ 83.05
Feb. 28, 2026issueSO-260228-637MAIN 2 83.05-166.107581.35 Dec. 29, 2025: 2 @ 83.05
Feb. 9, 2026issueSO-260209-629MAIN 8 83.05-664.409747.45 Dec. 29, 2025: 8 @ 83.05
Jan. 26, 2026issueSO-260126-264MAIN 1 83.05-83.05171,411.84 Dec. 29, 2025: 1 @ 83.05
Jan. 23, 2026issueSO-260123-339MAIN 2 83.05-166.10181,494.89 Dec. 29, 2025: 2 @ 83.05
Jan. 22, 2026issueSO-260122-709MAIN 1 83.05-83.05201,660.99 Dec. 29, 2025: 1 @ 83.05
Jan. 5, 2026issueSO-260105-920MAIN 8 83.11-664.85211,744.04 Oct. 25, 2025: 2 @ 83.28; Dec. 29, 2025: 6 @ 83.05
Jan. 1, 2026issueSO-260101-957MAIN 1 83.28-83.28292,408.89 Oct. 25, 2025: 1 @ 83.28
Dec. 29, 2025issueSO-251229-566MAIN 1 83.28-83.28302,492.17 Oct. 25, 2025: 1 @ 83.28
Dec. 29, 2025receiptPO-001103MAIN 27 83.052,242.34312,575.45
Dec. 22, 2025issueSO-251222-590MAIN 9 83.28-749.494333.11 Oct. 25, 2025: 9 @ 83.28
Dec. 2, 2025issueSO-251202-672MAIN 2 83.28-166.55131,082.60 Oct. 25, 2025: 2 @ 83.28
Nov. 24, 2025issueSO-251124-789MAIN 4 83.28-333.11151,249.15 Oct. 25, 2025: 4 @ 83.28
Nov. 14, 2025issueSO-251114-346MAIN 1 83.28-83.28191,582.26 Oct. 25, 2025: 1 @ 83.28
Nov. 4, 2025issueSO-251104-587MAIN 8 83.22-665.77201,665.53 Aug. 30, 2025: 1 @ 82.84; Oct. 25, 2025: 7 @ 83.28
Nov. 2, 2025issueSO-251102-734MAIN 2 82.84-165.67282,331.30 Aug. 30, 2025: 2 @ 82.84
Oct. 28, 2025issueSO-251028-299MAIN 1 82.84-82.84302,496.98 Aug. 30, 2025: 1 @ 82.84
Oct. 28, 2025issueSO-251028-299EAST 1 82.84-82.84312,579.81 Aug. 30, 2025: 1 @ 82.84
Oct. 25, 2025receiptPO-000954MAIN 27 83.282,248.47322,662.65
Oct. 21, 2025issueSO-251021-959MAIN 1 82.84-82.845414.18 Aug. 30, 2025: 1 @ 82.84
Oct. 19, 2025issueSO-251019-970MAIN 2 82.84-165.676497.01 Aug. 30, 2025: 2 @ 82.84
Oct. 18, 2025issueSO-251018-360MAIN 3 82.84-248.518662.68 Aug. 30, 2025: 3 @ 82.84
Oct. 13, 2025issueSO-251013-380EAST 3 82.84-248.5111911.19 Aug. 30, 2025: 3 @ 82.84
Sept. 24, 2025issueSO-250924-722MAIN 15 82.99-1,244.83141,159.70 June 30, 2025: 2 @ 83.99; Aug. 30, 2025: 13 @ 82.84
Sept. 15, 2025issueSO-250915-679EAST 2 83.99-167.97292,404.53 June 30, 2025: 2 @ 83.99
Aug. 30, 2025transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Aug. 30, 2025receiptPO-000806MAIN 27 82.842,236.56312,572.50
Aug. 29, 2025issueSO-250829-450MAIN 1 83.99-83.994335.94 June 30, 2025: 1 @ 83.99
Aug. 24, 2025issueSO-250824-643MAIN 1 83.99-83.995419.93 June 30, 2025: 1 @ 83.99
Aug. 22, 2025issueSO-250822-570MAIN 1 83.99-83.996503.92 June 30, 2025: 1 @ 83.99
Aug. 21, 2025issueSO-250821-348MAIN 3 83.99-251.967587.90 June 30, 2025: 3 @ 83.99
Aug. 20, 2025issueSO-250820-782MAIN 1 83.99-83.9910839.86 June 30, 2025: 1 @ 83.99
Aug. 14, 2025issueSO-250814-332MAIN 4 83.99-335.9411923.84 June 30, 2025: 4 @ 83.99
July 14, 2025issueSO-250714-806MAIN 5 83.99-419.93151,259.79 June 30, 2025: 5 @ 83.99
July 13, 2025issueSO-250713-237MAIN 1 83.99-83.99201,679.72 June 30, 2025: 1 @ 83.99
July 6, 2025issueSO-250706-523MAIN 5 83.99-419.93211,763.70 June 30, 2025: 5 @ 83.99
July 3, 2025issueSO-250703-152MAIN 1 83.99-83.99262,183.63 June 30, 2025: 1 @ 83.99
July 1, 2025issueSO-250701-804MAIN 4 78.57-314.27272,267.62 April 8, 2025: 4 @ 78.57
June 30, 2025receiptPO-000676MAIN 27 83.992,267.62312,581.89
June 28, 2025issueSO-250628-479MAIN 1 78.57-78.574314.27 April 8, 2025: 1 @ 78.57
June 23, 2025issueSO-250623-163MAIN 4 78.57-314.275392.84 April 8, 2025: 4 @ 78.57
June 21, 2025issueSO-250621-847MAIN 1 78.57-78.579707.12 April 8, 2025: 1 @ 78.57
June 16, 2025issueSO-250616-455MAIN 5 78.57-392.8410785.69 April 8, 2025: 5 @ 78.57
May 22, 2025issueSO-250522-175MAIN 10 78.57-785.69151,178.53 April 8, 2025: 10 @ 78.57
May 13, 2025issueSO-250513-550MAIN 1 78.57-78.57251,964.22 April 8, 2025: 1 @ 78.57
April 17, 2025issueSO-250417-894MAIN 1 78.57-78.57262,042.79 April 8, 2025: 1 @ 78.57
April 8, 2025receiptPO-000427MAIN 27 78.572,121.35272,121.35
April 5, 2025issueSO-250405-175MAIN 1 81.03-81.0300.00 March 4, 2025: 1 @ 81.03
April 3, 2025issueSO-250403-806MAIN 7 81.03-567.24181.03 March 4, 2025: 7 @ 81.03
April 1, 2025issueSO-250401-142MAIN 3 81.03-243.108648.27 March 4, 2025: 3 @ 81.03
March 20, 2025issueSO-250320-851MAIN 18 80.86-1,455.3911891.37 Jan. 22, 2025: 2 @ 79.43; March 4, 2025: 16 @ 81.03
March 17, 2025issueSO-250317-887MAIN 3 79.43-238.28292,346.77 Jan. 22, 2025: 3 @ 79.43
March 7, 2025issueSO-250307-158MAIN 1 79.43-79.43322,585.04 Jan. 22, 2025: 1 @ 79.43
March 4, 2025receiptPO-000313MAIN 27 81.032,187.92332,664.47
Feb. 27, 2025issueSO-250227-669MAIN 5 79.43-397.136476.55 Jan. 22, 2025: 5 @ 79.43
Feb. 19, 2025issueSO-250219-649MAIN 2 79.43-158.8511873.68 Jan. 22, 2025: 2 @ 79.43
Feb. 11, 2025issueSO-250211-315MAIN 6 79.43-476.55131,032.53 Jan. 22, 2025: 6 @ 79.43
Feb. 3, 2025issueSO-250203-198MAIN 1 79.43-79.43191,509.08 Jan. 22, 2025: 1 @ 79.43
Feb. 2, 2025issueSO-250202-248MAIN 1 79.43-79.43201,588.50 Jan. 22, 2025: 1 @ 79.43
Jan. 30, 2025issueSO-250130-873MAIN 4 79.43-317.70211,667.93 Jan. 22, 2025: 4 @ 79.43
Jan. 25, 2025issueSO-250125-823MAIN 2 79.43-158.85251,985.63 Jan. 22, 2025: 2 @ 79.43
Jan. 22, 2025receiptPO-000209MAIN 27 79.432,144.48272,144.48
Jan. 21, 2025issueSO-250121-102MAIN 6 79.76-478.5600.00 Oct. 31, 2024: 4 @ 79.76; Jan. 20, 2025: 2 @ 79.76
Jan. 20, 2025returnRMAMAIN 2 79.76159.526478.56
Jan. 15, 2025issueSO-250115-868MAIN 3 79.76-239.284319.04 Oct. 31, 2024: 3 @ 79.76
Jan. 2, 2025issueSO-250102-598MAIN 4 79.76-319.047558.32 Oct. 31, 2024: 4 @ 79.76
Dec. 21, 2024issueSO-241221-572MAIN 1 79.76-79.7611877.37 Oct. 31, 2024: 1 @ 79.76
Dec. 14, 2024issueSO-241214-704MAIN 1 79.76-79.7612957.13 Oct. 31, 2024: 1 @ 79.76
Dec. 8, 2024issueSO-241208-142MAIN 1 79.76-79.76131,036.89 Oct. 31, 2024: 1 @ 79.76
Dec. 6, 2024issueSO-241206-233MAIN 3 79.76-239.28141,116.65 Oct. 31, 2024: 3 @ 79.76
Dec. 5, 2024issueSO-241205-243MAIN 1 79.76-79.76171,355.93 Oct. 31, 2024: 1 @ 79.76
Dec. 2, 2024issueSO-241202-560MAIN 2 79.76-159.52181,435.69 Oct. 31, 2024: 2 @ 79.76
Nov. 11, 2024issueSO-241111-813MAIN 3 79.76-239.28201,595.21 Oct. 31, 2024: 3 @ 79.76
Nov. 10, 2024issueSO-241110-347MAIN 3 79.76-239.28231,834.49 Oct. 31, 2024: 3 @ 79.76
Nov. 7, 2024issueSO-241107-981MAIN 3 81.13-243.39262,073.78 Oct. 1, 2024: 2 @ 81.81; Oct. 31, 2024: 1 @ 79.76
Oct. 31, 2024receiptPO-000018MAIN 27 79.762,153.54292,317.16
Oct. 28, 2024issueSO-241028-259MAIN 4 81.81-327.262163.63 Oct. 1, 2024: 4 @ 81.81
Oct. 26, 2024issueSO-241026-764MAIN 14 81.81-1,145.406490.88 Oct. 1, 2024: 14 @ 81.81
Oct. 22, 2024issueSO-241022-977MAIN 7 81.81-572.70201,636.28 Oct. 1, 2024: 7 @ 81.81
Oct. 14, 2024issueSO-241014-983MAIN 3 81.81-245.44272,208.98 Oct. 1, 2024: 3 @ 81.81
Oct. 1, 2024receiptPO-000005MAIN 30 81.812,454.42302,454.42