stocksense

Items / MCB-0003

Isolator 63A Eco MCB-0003 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)21MAIN 21
Value (FIFO)2,905.74avg 138.37
ClassAY / FCV 0.62
Turnover16.0xlast issue 1 days ago
Days of cover32lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00030.016.031.947.963.8Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 39.0Nov 24: 37.0Dec 24: 10.0Jan 25: 16.0Feb 25: 10.0Mar 25: 17.0Apr 25: 19.0May 25: 17.0Jun 25: 19.0Jul 25: 29.0Aug 25: 8.0Sep 25: 14.0Oct 25: 19.0Nov 25: 13.0Dec 25: 25.0Jan 26: 58.0Feb 26: 15.0Mar 26: 12.0Apr 26: 20.0May 26: 13.0Jun 26: 11.0Jul 26: 15.0Aug 26: 17.0Sep 26: 19.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.437519.75 / 30.43750.649
Daily demand sdmonthly sd / sqrt(30.4375)12.15 / 5.5172.203
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 * 2.203^2 + 0.649^2 * 1.5^2)12.1
Reorder pointd * LT + safety stock0.649 * 7.0 + 12.116.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days16.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 237/yr, S = 45.00, h = 20%, price = 137.1727.9
Inventory positionon hand + on order21 + 021

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

From qtyUnit costOrder qtyAnnual costFeasible
0137.172833,252yes (chosen if cheapest)

MOQ 20, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 29, 202621 / 36138.372,905.74

Movement ledger 130 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-469MAIN 2 138.37-276.74212,905.74 Sept. 29, 2026: 2 @ 138.37
Oct. 14, 2026issueSO-261014-707MAIN 3 138.37-415.11233,182.48 Sept. 29, 2026: 3 @ 138.37
Oct. 13, 2026issueSO-261013-756MAIN 5 138.37-691.84263,597.58 Sept. 29, 2026: 5 @ 138.37
Oct. 4, 2026issueSO-261004-910MAIN 3 138.37-415.11314,289.43 Sept. 29, 2026: 3 @ 138.37
Oct. 3, 2026issueSO-261003-225MAIN 2 138.37-276.74344,704.53 Sept. 29, 2026: 2 @ 138.37
Sept. 29, 2026receiptPO-001840MAIN 36 138.374,981.27364,981.27
Sept. 22, 2026issueSO-260922-571MAIN 2 131.66-263.3200.00 Aug. 3, 2026: 2 @ 131.66
Sept. 22, 2026issueSO-260922-571EAST 2 131.66-263.322263.32 Aug. 3, 2026: 2 @ 131.66
Sept. 20, 2026issueSO-260920-931MAIN 9 133.89-1,205.014526.64 Aug. 3, 2026: 8 @ 134.17; Aug. 3, 2026: 1 @ 131.66
Sept. 19, 2026issueSO-260919-676MAIN 1 134.17-134.17131,731.65 Aug. 3, 2026: 1 @ 134.17
Sept. 11, 2026issueSO-260911-922MAIN 1 134.17-134.17141,865.82 Aug. 3, 2026: 1 @ 134.17
Sept. 10, 2026issueSO-260910-276MAIN 4 134.17-536.68151,999.99 Aug. 3, 2026: 4 @ 134.17
Aug. 24, 2026issueSO-260824-167MAIN 11 134.17-1,475.86192,536.66 Aug. 3, 2026: 11 @ 134.17
Aug. 16, 2026issueSO-260816-924MAIN 3 134.17-402.51304,012.52 Aug. 3, 2026: 3 @ 134.17
Aug. 11, 2026issueSO-260811-155EAST 6 134.17-805.01334,415.03 Aug. 3, 2026: 6 @ 134.17
Aug. 8, 2026issueSO-260808-542MAIN 2 134.17-268.34395,220.04 Aug. 3, 2026: 2 @ 134.17
Aug. 3, 2026returnRMAMAIN 5 131.66658.30415,488.38
Aug. 3, 2026transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Aug. 3, 2026receiptPO-001695MAIN 36 134.174,830.08364,830.08
July 29, 2026issueSO-260729-324MAIN 4 131.66-526.6400.00 May 6, 2026: 3 @ 131.66; May 16, 2026: 1 @ 131.66
July 28, 2026issueSO-260728-942MAIN 11 131.66-1,448.254526.64 May 6, 2026: 11 @ 131.66
June 28, 2026issueSO-260628-459MAIN 2 131.66-263.32151,974.89 May 6, 2026: 2 @ 131.66
June 28, 2026issueSO-260628-459EAST 6 131.66-789.96172,238.21 May 6, 2026: 6 @ 131.66
June 26, 2026issueSO-260626-732MAIN 1 131.66-131.66233,028.16 May 6, 2026: 1 @ 131.66
June 5, 2026issueSO-260605-556EAST 2 131.66-263.32243,159.82 May 6, 2026: 2 @ 131.66
May 17, 2026issueSO-260517-519MAIN 1 131.66-131.66263,423.14 May 6, 2026: 1 @ 131.66
May 16, 2026returnRMAMAIN 1 131.66131.66273,554.80
May 13, 2026issueSO-260513-478MAIN 1 131.66-131.66263,423.14 May 6, 2026: 1 @ 131.66
May 11, 2026issueSO-260511-454MAIN 7 131.66-921.61273,554.80 May 6, 2026: 7 @ 131.66
May 7, 2026issueSO-260507-126MAIN 3 132.93-398.79344,476.41 May 2, 2026: 1 @ 135.47; May 6, 2026: 2 @ 131.66
May 6, 2026transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
May 6, 2026receiptPO-001468MAIN 36 131.664,739.73374,875.21
May 2, 2026returnRMAMAIN 1 135.47135.471135.47
May 2, 2026issueSO-260502-937MAIN 3 135.47-406.4200.00 Feb. 18, 2026: 3 @ 135.47
April 30, 2026issueSO-260430-687MAIN 7 135.47-948.323406.42 Feb. 18, 2026: 7 @ 135.47
April 26, 2026issueSO-260426-983MAIN 2 135.47-270.95101,354.74 Feb. 18, 2026: 2 @ 135.47
April 20, 2026issueSO-260420-698MAIN 6 135.47-812.84121,625.69 Feb. 18, 2026: 6 @ 135.47
April 20, 2026issueSO-260420-698EAST 1 135.47-135.47182,438.53 Feb. 18, 2026: 1 @ 135.47
April 16, 2026issueSO-260416-272EAST 1 135.47-135.47192,574.01 Feb. 18, 2026: 1 @ 135.47
April 14, 2026issueSO-260414-696MAIN 1 135.47-135.47202,709.48 Feb. 18, 2026: 1 @ 135.47
April 13, 2026issueSO-260413-323MAIN 1 135.47-135.47212,844.95 Feb. 18, 2026: 1 @ 135.47
April 5, 2026issueSO-260405-663MAIN 1 135.47-135.47222,980.43 Feb. 18, 2026: 1 @ 135.47
March 30, 2026issueSO-260330-118MAIN 6 135.47-812.84233,115.90 Feb. 18, 2026: 6 @ 135.47
March 20, 2026issueSO-260320-671MAIN 2 135.47-270.95293,928.75 Feb. 18, 2026: 2 @ 135.47
March 6, 2026issueSO-260306-708MAIN 1 135.47-135.47314,199.69 Feb. 18, 2026: 1 @ 135.47
March 4, 2026issueSO-260304-952EAST 2 135.47-270.95324,335.17 Feb. 18, 2026: 2 @ 135.47
March 2, 2026issueSO-260302-785EAST 1 135.47-135.47344,606.12 Feb. 18, 2026: 1 @ 135.47
Feb. 27, 2026issueSO-260227-141MAIN 6 134.47-806.80354,741.59 Jan. 12, 2026: 5 @ 134.27; Feb. 18, 2026: 1 @ 135.47
Feb. 18, 2026receiptPO-001237MAIN 36 135.474,877.06415,548.39
Feb. 14, 2026issueSO-260214-212EAST 1 134.27-134.275671.33 Jan. 12, 2026: 1 @ 134.27
Feb. 13, 2026issueSO-260213-195EAST 2 134.27-268.536805.59 Jan. 12, 2026: 2 @ 134.27
Feb. 12, 2026issueSO-260212-769MAIN 5 134.27-671.3381,074.12 Jan. 12, 2026: 5 @ 134.27
Feb. 4, 2026issueSO-260204-821MAIN 1 134.27-134.27131,745.45 Jan. 12, 2026: 1 @ 134.27
Jan. 17, 2026issueSO-260117-340MAIN 22 134.27-2,953.83141,879.71 Jan. 12, 2026: 22 @ 134.27
Jan. 12, 2026transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Jan. 12, 2026receiptPO-001140MAIN 36 134.274,833.55364,833.55
Jan. 1, 2026issueSO-260101-408MAIN 25 135.54-3,388.5700.00 Jan. 1, 2026: 25 @ 135.54
Jan. 1, 2026issueSO-260101-408EAST 11 135.54-1,490.97253,388.57 Jan. 1, 2026: 11 @ 135.54
Jan. 1, 2026transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Jan. 1, 2026receiptPO-001111MAIN 36 135.544,879.54364,879.54
Dec. 26, 2025issueSO-251226-698MAIN 22 128.97-2,837.3600.00 Oct. 25, 2025: 22 @ 128.97
Dec. 17, 2025issueSO-251217-499MAIN 1 128.97-128.97222,837.36 Oct. 25, 2025: 1 @ 128.97
Dec. 2, 2025issueSO-251202-585MAIN 2 128.97-257.94232,966.33 Oct. 25, 2025: 2 @ 128.97
Nov. 18, 2025issueSO-251118-468MAIN 1 128.97-128.97253,224.27 Oct. 25, 2025: 1 @ 128.97
Nov. 6, 2025issueSO-251106-346MAIN 7 128.97-902.79263,353.24 Oct. 25, 2025: 7 @ 128.97
Nov. 4, 2025issueSO-251104-114MAIN 1 128.97-128.97334,256.03 Oct. 25, 2025: 1 @ 128.97
Nov. 2, 2025issueSO-251102-755MAIN 4 131.25-525.00344,385.00 July 23, 2025: 2 @ 133.53; Oct. 25, 2025: 2 @ 128.97
Oct. 25, 2025issueSO-251025-279MAIN 2 133.53-267.06384,910.00 July 23, 2025: 2 @ 133.53
Oct. 25, 2025receiptPO-000953MAIN 36 128.974,642.95405,177.06
Oct. 22, 2025issueSO-251022-488MAIN 2 133.53-267.064534.12 July 23, 2025: 2 @ 133.53
Oct. 17, 2025issueSO-251017-468MAIN 4 133.53-534.126801.18 July 23, 2025: 4 @ 133.53
Oct. 16, 2025issueSO-251016-978MAIN 6 133.53-801.18101,335.30 July 23, 2025: 6 @ 133.53
Oct. 4, 2025issueSO-251004-803MAIN 5 133.53-667.65162,136.47 July 23, 2025: 5 @ 133.53
Sept. 26, 2025issueSO-250926-543MAIN 5 133.53-667.65212,804.12 July 23, 2025: 5 @ 133.53
Sept. 24, 2025issueSO-250924-199MAIN 1 133.53-133.53263,471.77 July 23, 2025: 1 @ 133.53
Sept. 17, 2025issueSO-250917-662MAIN 1 133.53-133.53273,605.30 July 23, 2025: 1 @ 133.53
Sept. 14, 2025issueSO-250914-980MAIN 1 133.53-133.53283,738.83 July 23, 2025: 1 @ 133.53
Sept. 6, 2025issueSO-250906-377EAST 2 133.53-267.06293,872.36 July 23, 2025: 2 @ 133.53
Sept. 5, 2025issueSO-250905-507MAIN 1 133.53-133.53314,139.41 July 23, 2025: 1 @ 133.53
Sept. 2, 2025issueSO-250902-952MAIN 3 133.53-400.59324,272.94 July 23, 2025: 3 @ 133.53
Aug. 28, 2025issueSO-250828-373MAIN 3 133.45-400.34354,673.53 July 10, 2025: 2 @ 133.40; July 23, 2025: 1 @ 133.53
Aug. 23, 2025issueSO-250823-877EAST 5 133.40-667.02385,073.87 July 10, 2025: 5 @ 133.40
July 23, 2025receiptPO-000729MAIN 36 133.534,807.06435,740.88
July 16, 2025issueSO-250716-803MAIN 15 133.40-2,001.057933.82 July 10, 2025: 15 @ 133.40
July 13, 2025issueSO-250713-604MAIN 14 133.40-1,867.64222,934.87 July 10, 2025: 14 @ 133.40
July 10, 2025transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
July 10, 2025receiptPO-000698MAIN 36 133.404,802.51364,802.51
June 30, 2025issueSO-250630-745MAIN 17 127.48-2,167.0800.00 April 16, 2025: 17 @ 127.48
June 25, 2025issueSO-250625-723MAIN 1 127.48-127.48172,167.08 April 16, 2025: 1 @ 127.48
June 22, 2025issueSO-250622-864MAIN 1 127.48-127.48182,294.55 April 16, 2025: 1 @ 127.48
May 10, 2025issueSO-250510-645MAIN 3 127.48-382.43192,422.03 April 16, 2025: 3 @ 127.48
May 10, 2025issueSO-250510-645EAST 3 127.48-382.43222,804.45 April 16, 2025: 3 @ 127.48
May 4, 2025issueSO-250504-881MAIN 3 127.48-382.43253,186.88 April 16, 2025: 3 @ 127.48
May 3, 2025issueSO-250503-274MAIN 4 127.48-509.90283,569.30 April 16, 2025: 4 @ 127.48
May 2, 2025issueSO-250502-160EAST 4 127.48-509.90324,079.20 April 16, 2025: 4 @ 127.48
April 26, 2025issueSO-250426-482MAIN 5 129.01-645.04364,589.10 Feb. 28, 2025: 5 @ 129.01
April 17, 2025issueSO-250417-183EAST 3 129.01-387.02415,234.14 Feb. 28, 2025: 3 @ 129.01
April 16, 2025transferTRFMAIN → EAST 10 warehouse transfer, no cost effect
April 16, 2025receiptPO-000454MAIN 36 127.484,589.10445,621.16
April 12, 2025issueSO-250412-360MAIN 6 129.01-774.0481,032.06 Feb. 28, 2025: 6 @ 129.01
April 9, 2025issueSO-250409-969MAIN 5 129.01-645.04141,806.10 Feb. 28, 2025: 5 @ 129.01
March 30, 2025issueSO-250330-787MAIN 1 129.01-129.01192,451.14 Feb. 28, 2025: 1 @ 129.01
March 27, 2025issueSO-250327-701MAIN 1 129.01-129.01202,580.15 Feb. 28, 2025: 1 @ 129.01
March 18, 2025issueSO-250318-111MAIN 6 129.01-774.04212,709.15 Feb. 28, 2025: 6 @ 129.01
March 17, 2025issueSO-250317-866EAST 3 129.01-387.02273,483.20 Feb. 28, 2025: 3 @ 129.01
March 10, 2025issueSO-250310-101MAIN 1 129.01-129.01303,870.22 Feb. 28, 2025: 1 @ 129.01
March 9, 2025issueSO-250309-652EAST 5 129.01-645.04313,999.23 Feb. 28, 2025: 5 @ 129.01
Feb. 28, 2025transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Feb. 28, 2025receiptPO-000303MAIN 36 129.014,644.26364,644.26
Feb. 27, 2025issueSO-250227-504MAIN 6 128.77-772.6000.00 Nov. 29, 2024: 5 @ 128.77; Dec. 25, 2024: 1 @ 128.77
Feb. 22, 2025issueSO-250222-811MAIN 4 128.77-515.066772.60 Nov. 29, 2024: 4 @ 128.77
Jan. 31, 2025issueSO-250131-522MAIN 1 128.77-128.77101,287.66 Nov. 29, 2024: 1 @ 128.77
Jan. 19, 2025issueSO-250119-870MAIN 7 128.77-901.36111,416.42 Nov. 29, 2024: 7 @ 128.77
Jan. 16, 2025issueSO-250116-311MAIN 5 128.77-643.83182,317.79 Nov. 29, 2024: 5 @ 128.77
Jan. 10, 2025issueSO-250110-142MAIN 3 128.77-386.30232,961.62 Nov. 29, 2024: 3 @ 128.77
Dec. 29, 2024issueSO-241229-259MAIN 7 128.77-901.36263,347.91 Nov. 29, 2024: 7 @ 128.77
Dec. 25, 2024returnRMAMAIN 1 128.77128.77334,249.27
Dec. 22, 2024issueSO-241222-103MAIN 2 128.77-257.53324,120.51 Nov. 29, 2024: 2 @ 128.77
Dec. 13, 2024issueSO-241213-370MAIN 1 128.77-128.77344,378.04 Nov. 29, 2024: 1 @ 128.77
Dec. 6, 2024issueSO-241206-712MAIN 1 128.77-128.77354,506.81 Nov. 29, 2024: 1 @ 128.77
Nov. 29, 2024receiptPO-000065MAIN 36 128.774,635.57364,635.57
Nov. 24, 2024issueSO-241124-492MAIN 10 129.36-1,293.6100.00 Oct. 30, 2024: 10 @ 129.36
Nov. 8, 2024issueSO-241108-265MAIN 20 129.36-2,587.23101,293.61 Oct. 30, 2024: 20 @ 129.36
Nov. 2, 2024issueSO-241102-571MAIN 7 129.50-906.48303,880.84 Oct. 1, 2024: 1 @ 130.31; Oct. 30, 2024: 6 @ 129.36
Oct. 30, 2024receiptPO-000016MAIN 36 129.364,657.01374,787.32
Oct. 22, 2024issueSO-241022-620MAIN 14 130.31-1,824.361130.31 Oct. 1, 2024: 14 @ 130.31
Oct. 21, 2024issueSO-241021-258MAIN 5 130.31-651.56151,954.67 Oct. 1, 2024: 5 @ 130.31
Oct. 14, 2024issueSO-241014-338MAIN 7 130.31-912.18202,606.23 Oct. 1, 2024: 7 @ 130.31
Oct. 3, 2024issueSO-241003-652MAIN 13 130.31-1,694.05273,518.41 Oct. 1, 2024: 13 @ 130.31
Oct. 1, 2024receiptPO-000005MAIN 40 130.315,212.46405,212.46