stocksense

Items / MCB-0021

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

On hand (EA)49MAIN 49
Value (FIFO)6,305.11avg 128.68
ClassAX / FCV 0.40
Turnover6.7xlast issue 10 days ago
Days of cover62lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00210.014.028.142.156.1Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 49.0Nov 24: 42.0Dec 24: 38.0Jan 25: 31.0Feb 25: 21.0Mar 25: 26.0Apr 25: 13.0May 25: 45.0Jun 25: 34.0Jul 25: 14.0Aug 25: 19.0Sep 25: 49.0Oct 25: 29.0Nov 25: 26.0Dec 25: 21.0Jan 26: 31.0Feb 26: 21.0Mar 26: 15.0Apr 26: 11.0May 26: 20.0Jun 26: 22.0Jul 26: 23.0Aug 26: 51.0Sep 26: 18.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.437524.00 / 30.43750.789
Daily demand sdmonthly sd / sqrt(30.4375)9.71 / 5.5171.760
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 * 1.760^2 + 0.789^2 * 1.5^2)9.9
Reorder pointd * LT + safety stock0.789 * 7.0 + 9.915.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days15.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 288/yr, S = 45.00, h = 20%, price = 131.6931.4
Inventory positionon hand + on order49 + 049

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

From qtyUnit costOrder qtyAnnual costFeasible
0131.693138,727yes (chosen if cheapest)

MOQ 25, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 8, 20265 / 44127.80638.98
Oct. 11, 202644 / 44128.785,666.14

Movement ledger 142 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 11, 2026receiptPO-001871MAIN 44 128.785,666.14496,305.11
Oct. 6, 2026issueSO-261006-556MAIN 32 127.80-4,089.445638.98 Sept. 8, 2026: 32 @ 127.80
Oct. 5, 2026issueSO-261005-638EAST 3 127.80-383.38374,728.42 Sept. 8, 2026: 3 @ 127.80
Sept. 27, 2026issueSO-260927-234MAIN 1 127.80-127.80405,111.80 Sept. 8, 2026: 1 @ 127.80
Sept. 24, 2026issueSO-260924-468MAIN 6 129.94-779.64415,239.60 Aug. 28, 2026: 3 @ 132.09; Sept. 8, 2026: 3 @ 127.80
Sept. 20, 2026issueSO-260920-309MAIN 2 132.09-264.17476,019.24 Aug. 28, 2026: 2 @ 132.09
Sept. 10, 2026issueSO-260910-234MAIN 1 132.09-132.09496,283.41 Aug. 28, 2026: 1 @ 132.09
Sept. 8, 2026receiptPO-001783MAIN 44 127.805,622.98506,415.49
Sept. 7, 2026issueSO-260907-544MAIN 5 132.09-660.436792.51 Aug. 28, 2026: 5 @ 132.09
Sept. 2, 2026issueSO-260902-811MAIN 3 132.09-396.26111,452.94 Aug. 28, 2026: 3 @ 132.09
Aug. 30, 2026issueSO-260830-561EAST 11 132.09-1,452.94141,849.19 Aug. 28, 2026: 11 @ 132.09
Aug. 29, 2026issueSO-260829-544MAIN 22 131.38-2,890.34253,302.13 Aug. 10, 2026: 3 @ 126.91; Aug. 28, 2026: 19 @ 132.09
Aug. 28, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Aug. 28, 2026receiptPO-001755MAIN 44 132.095,811.75476,192.47
Aug. 26, 2026issueSO-260826-949MAIN 8 126.91-1,015.253380.72 July 16, 2026: 6 @ 126.91; Aug. 10, 2026: 2 @ 126.91
Aug. 23, 2026issueSO-260823-574MAIN 5 126.91-634.53111,395.97 July 7, 2026: 5 @ 126.91
Aug. 20, 2026issueSO-260820-976MAIN 10 126.91-1,269.06162,030.50 July 7, 2026: 10 @ 126.91
Aug. 10, 2026returnRMAMAIN 5 126.91634.53263,299.56
July 28, 2026issueSO-260728-484MAIN 1 126.91-126.91212,665.03 July 7, 2026: 1 @ 126.91
July 27, 2026issueSO-260727-525MAIN 10 126.91-1,269.06222,791.94 July 7, 2026: 10 @ 126.91
July 21, 2026issueSO-260721-324MAIN 3 126.91-380.72324,061.00 July 7, 2026: 3 @ 126.91
July 18, 2026issueSO-260718-467MAIN 11 126.91-1,395.97354,441.72 July 7, 2026: 11 @ 126.91
July 16, 2026returnRMAMAIN 6 126.91761.44465,837.69
July 15, 2026issueSO-260715-106MAIN 4 126.91-507.63405,076.25 July 7, 2026: 4 @ 126.91
July 7, 2026receiptPO-001631MAIN 44 126.915,583.88445,583.88
June 28, 2026issueSO-260628-793MAIN 13 128.57-1,671.4500.00 April 2, 2026: 13 @ 128.57
June 8, 2026issueSO-260608-211MAIN 9 128.57-1,157.16131,671.45 April 2, 2026: 9 @ 128.57
May 28, 2026issueSO-260528-643MAIN 19 128.57-2,442.89222,828.61 April 2, 2026: 19 @ 128.57
May 14, 2026issueSO-260514-567MAIN 1 128.57-128.57415,271.51 April 2, 2026: 1 @ 128.57
April 27, 2026issueSO-260427-815MAIN 1 128.57-128.57425,400.08 April 2, 2026: 1 @ 128.57
April 19, 2026issueSO-260419-551MAIN 4 127.72-510.89435,528.66 Feb. 7, 2026: 3 @ 127.44; April 2, 2026: 1 @ 128.57
April 18, 2026issueSO-260418-689MAIN 1 127.44-127.44476,039.54 Feb. 7, 2026: 1 @ 127.44
April 14, 2026issueSO-260414-886MAIN 3 127.44-382.31486,166.98 Feb. 7, 2026: 3 @ 127.44
April 3, 2026issueSO-260403-168MAIN 2 127.44-254.88516,549.29 Feb. 7, 2026: 2 @ 127.44
April 2, 2026receiptPO-001376MAIN 44 128.575,657.23536,804.17
March 24, 2026issueSO-260324-388MAIN 7 127.44-892.0791,146.94 Feb. 7, 2026: 7 @ 127.44
March 16, 2026issueSO-260316-479MAIN 1 127.44-127.44162,039.01 Feb. 7, 2026: 1 @ 127.44
March 6, 2026issueSO-260306-186MAIN 2 127.44-254.88172,166.44 Feb. 7, 2026: 2 @ 127.44
March 4, 2026issueSO-260304-566MAIN 5 127.44-637.19192,421.32 Feb. 7, 2026: 5 @ 127.44
Feb. 10, 2026issueSO-260210-843MAIN 20 127.44-2,548.76243,058.51 Feb. 7, 2026: 20 @ 127.44
Feb. 7, 2026receiptPO-001207MAIN 44 127.445,607.27445,607.27
Feb. 3, 2026issueSO-260203-516MAIN 1 124.36-124.3600.00 Nov. 29, 2025: 1 @ 124.36
Jan. 31, 2026issueSO-260131-289MAIN 16 124.36-1,989.741124.36 Nov. 29, 2025: 16 @ 124.36
Jan. 25, 2026issueSO-260125-285MAIN 6 124.36-746.15172,114.10 Nov. 29, 2025: 6 @ 124.36
Jan. 18, 2026issueSO-260118-651MAIN 2 124.36-248.72232,860.25 Nov. 29, 2025: 2 @ 124.36
Jan. 4, 2026issueSO-260104-101MAIN 5 124.36-621.79253,108.97 Nov. 29, 2025: 5 @ 124.36
Jan. 2, 2026issueSO-260102-808MAIN 2 124.36-248.72303,730.76 Nov. 29, 2025: 2 @ 124.36
Dec. 30, 2025issueSO-251230-960MAIN 5 124.36-621.79323,979.48 Nov. 29, 2025: 5 @ 124.36
Dec. 23, 2025issueSO-251223-403MAIN 1 124.36-124.36374,601.28 Nov. 29, 2025: 1 @ 124.36
Dec. 16, 2025issueSO-251216-963MAIN 2 124.36-248.72384,725.63 Nov. 29, 2025: 2 @ 124.36
Dec. 16, 2025issueSO-251216-963EAST 1 124.36-124.36404,974.35 Nov. 29, 2025: 1 @ 124.36
Dec. 10, 2025issueSO-251210-650EAST 2 124.36-248.72415,098.71 Nov. 29, 2025: 2 @ 124.36
Dec. 7, 2025issueSO-251207-520MAIN 9 123.78-1,114.02435,347.43 Oct. 12, 2025: 8 @ 123.71; Nov. 29, 2025: 1 @ 124.36
Dec. 4, 2025issueSO-251204-430MAIN 1 123.71-123.71526,461.45 Oct. 12, 2025: 1 @ 123.71
Nov. 29, 2025receiptPO-001025MAIN 44 124.365,471.79536,585.15
Nov. 23, 2025issueSO-251123-809MAIN 10 123.71-1,237.0891,113.37 Oct. 12, 2025: 10 @ 123.71
Nov. 19, 2025issueSO-251119-608MAIN 1 123.71-123.71192,350.44 Oct. 12, 2025: 1 @ 123.71
Nov. 18, 2025issueSO-251118-554MAIN 2 123.71-247.42202,474.15 Oct. 12, 2025: 2 @ 123.71
Nov. 16, 2025issueSO-251116-121MAIN 1 123.71-123.71222,721.56 Oct. 12, 2025: 1 @ 123.71
Nov. 11, 2025issueSO-251111-198EAST 1 123.71-123.71232,845.27 Oct. 12, 2025: 1 @ 123.71
Nov. 2, 2025issueSO-251102-465EAST 11 123.71-1,360.78242,968.98 Oct. 12, 2025: 11 @ 123.71
Oct. 19, 2025issueSO-251019-481MAIN 13 125.31-1,629.07354,329.76 Sept. 7, 2025: 4 @ 128.92; Oct. 12, 2025: 9 @ 123.71
Oct. 16, 2025issueSO-251016-704MAIN 6 128.92-773.55485,958.83 Sept. 7, 2025: 6 @ 128.92
Oct. 12, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Oct. 12, 2025receiptPO-000915MAIN 44 123.715,443.13546,732.38
Oct. 4, 2025issueSO-251004-877MAIN 10 128.92-1,289.25101,289.25 Sept. 7, 2025: 10 @ 128.92
Sept. 25, 2025issueSO-250925-139MAIN 21 128.92-2,707.42202,578.49 Sept. 7, 2025: 21 @ 128.92
Sept. 25, 2025issueSO-250925-139EAST 5 128.21-641.07415,285.91 Aug. 2, 2025: 2 @ 127.15; Sept. 7, 2025: 3 @ 128.92
Sept. 23, 2025issueSO-250923-722MAIN 3 127.15-381.45465,926.99 Aug. 2, 2025: 3 @ 127.15
Sept. 14, 2025issueSO-250914-126EAST 2 127.15-254.30496,308.43 Aug. 2, 2025: 2 @ 127.15
Sept. 7, 2025receiptPO-000821MAIN 44 128.925,672.69516,562.73
Sept. 1, 2025issueSO-250901-148EAST 7 127.15-890.057890.05 Aug. 2, 2025: 7 @ 127.15
Sept. 1, 2025issueSO-250901-148MAIN 11 127.15-1,398.64141,780.09 Aug. 2, 2025: 11 @ 127.15
Aug. 24, 2025issueSO-250824-348MAIN 5 127.15-635.75253,178.73 Aug. 2, 2025: 5 @ 127.15
Aug. 19, 2025issueSO-250819-674MAIN 4 127.15-508.60303,814.48 Aug. 2, 2025: 4 @ 127.15
Aug. 12, 2025issueSO-250812-278MAIN 1 127.15-127.15344,323.08 Aug. 2, 2025: 1 @ 127.15
Aug. 11, 2025issueSO-250811-444MAIN 6 127.15-762.90354,450.23 Aug. 2, 2025: 6 @ 127.15
Aug. 5, 2025issueSO-250805-532MAIN 3 127.15-381.45415,213.12 Aug. 2, 2025: 3 @ 127.15
Aug. 2, 2025transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Aug. 2, 2025receiptPO-000753MAIN 44 127.155,594.57445,594.57
July 27, 2025issueSO-250727-152EAST 8 124.93-999.4500.00 June 6, 2025: 6 @ 124.93; June 13, 2025: 2 @ 124.93
July 25, 2025issueSO-250725-476EAST 1 124.93-124.938999.45 June 6, 2025: 1 @ 124.93
July 25, 2025issueSO-250725-476MAIN 3 124.93-374.7991,124.38 June 6, 2025: 3 @ 124.93
July 19, 2025issueSO-250719-216MAIN 2 124.93-249.86121,499.18 June 6, 2025: 2 @ 124.93
June 28, 2025issueSO-250628-180MAIN 15 124.93-1,873.97141,749.04 June 6, 2025: 15 @ 124.93
June 26, 2025issueSO-250626-635MAIN 2 124.93-249.86293,623.01 June 6, 2025: 2 @ 124.93
June 15, 2025issueSO-250615-618EAST 5 124.93-624.66313,872.87 June 6, 2025: 5 @ 124.93
June 13, 2025returnRMAMAIN 2 124.93249.86364,497.53
June 9, 2025issueSO-250609-376MAIN 10 124.93-1,249.31344,247.66 June 6, 2025: 10 @ 124.93
June 6, 2025transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
June 6, 2025receiptPO-000608MAIN 44 124.935,496.98445,496.98
June 5, 2025issueSO-250605-783MAIN 4 125.71-502.8500.00 April 18, 2025: 3 @ 125.71; April 21, 2025: 1 @ 125.71
May 30, 2025issueSO-250530-973MAIN 11 121.68-1,338.494502.85 April 16, 2025: 10 @ 121.28; April 18, 2025: 1 @ 125.71
May 27, 2025issueSO-250527-339MAIN 1 121.28-121.28151,841.34 April 16, 2025: 1 @ 121.28
May 24, 2025issueSO-250524-333MAIN 11 121.28-1,334.05161,962.61 April 16, 2025: 11 @ 121.28
May 23, 2025issueSO-250523-722MAIN 1 121.28-121.28273,296.67 April 16, 2025: 1 @ 121.28
May 9, 2025issueSO-250509-590MAIN 11 121.28-1,334.05283,417.95 April 16, 2025: 11 @ 121.28
May 8, 2025issueSO-250508-388MAIN 10 121.28-1,212.78394,752.00 April 16, 2025: 10 @ 121.28
April 21, 2025returnRMAMAIN 1 125.71125.71495,964.77
April 18, 2025returnRMAMAIN 4 125.71502.85485,839.06
April 16, 2025receiptPO-000456MAIN 44 121.285,336.21445,336.21
April 11, 2025issueSO-250411-420EAST 9 125.71-1,131.4100.00 March 6, 2025: 9 @ 125.71
April 9, 2025issueSO-250409-403EAST 2 125.71-251.4291,131.41 March 6, 2025: 2 @ 125.71
April 9, 2025issueSO-250409-403MAIN 6 125.71-754.27111,382.83 March 6, 2025: 6 @ 125.71
April 5, 2025issueSO-250405-228MAIN 1 125.71-125.71172,137.11 March 6, 2025: 1 @ 125.71
March 29, 2025issueSO-250329-608MAIN 2 125.71-251.42182,262.82 March 6, 2025: 2 @ 125.71
March 28, 2025issueSO-250328-374MAIN 8 125.71-1,005.70202,514.24 March 6, 2025: 8 @ 125.71
March 25, 2025issueSO-250325-939MAIN 1 125.71-125.71283,519.94 March 6, 2025: 1 @ 125.71
March 14, 2025issueSO-250314-686MAIN 5 125.71-628.56293,645.65 March 6, 2025: 5 @ 125.71
March 9, 2025issueSO-250309-874MAIN 10 125.71-1,257.12344,274.21 March 6, 2025: 10 @ 125.71
March 6, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
March 6, 2025receiptPO-000323MAIN 44 125.715,531.33445,531.33
Feb. 26, 2025issueSO-250226-472EAST 10 118.66-1,186.6400.00 Jan. 3, 2025: 10 @ 118.66
Feb. 26, 2025issueSO-250226-472MAIN 11 118.66-1,305.30101,186.64 Jan. 3, 2025: 11 @ 118.66
Jan. 22, 2025issueSO-250122-663EAST 9 118.66-1,067.97212,491.94 Jan. 3, 2025: 9 @ 118.66
Jan. 20, 2025issueSO-250120-171MAIN 4 118.66-474.65303,559.91 Jan. 3, 2025: 4 @ 118.66
Jan. 13, 2025issueSO-250113-274MAIN 4 118.66-474.65344,034.57 Jan. 3, 2025: 4 @ 118.66
Jan. 6, 2025issueSO-250106-860EAST 1 118.66-118.66384,509.22 Jan. 3, 2025: 1 @ 118.66
Jan. 5, 2025issueSO-250105-790MAIN 5 118.66-593.32394,627.88 Jan. 3, 2025: 5 @ 118.66
Jan. 4, 2025issueSO-250104-584MAIN 8 121.61-972.86445,221.20 Dec. 2, 2024: 8 @ 121.61
Jan. 3, 2025transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Jan. 3, 2025receiptPO-000160MAIN 44 118.665,221.20526,194.06
Dec. 25, 2024issueSO-241225-602EAST 5 121.61-608.048972.86 Dec. 2, 2024: 5 @ 121.61
Dec. 22, 2024issueSO-241222-117MAIN 2 121.61-243.21131,580.89 Dec. 2, 2024: 2 @ 121.61
Dec. 10, 2024issueSO-241210-502MAIN 4 121.61-486.43151,824.11 Dec. 2, 2024: 4 @ 121.61
Dec. 3, 2024issueSO-241203-521MAIN 27 121.72-3,286.36192,310.53 Nov. 7, 2024: 2 @ 123.09; Dec. 2, 2024: 25 @ 121.61
Dec. 2, 2024transferTRFMAIN → EAST 13 warehouse transfer, no cost effect
Dec. 2, 2024receiptPO-000076MAIN 44 121.615,350.71465,596.90
Nov. 30, 2024issueSO-241130-746MAIN 4 123.09-492.372246.18 Nov. 7, 2024: 4 @ 123.09
Nov. 25, 2024issueSO-241125-672MAIN 10 123.09-1,230.926738.55 Nov. 7, 2024: 10 @ 123.09
Nov. 18, 2024issueSO-241118-914MAIN 11 123.09-1,354.01161,969.48 Nov. 7, 2024: 11 @ 123.09
Nov. 14, 2024issueSO-241114-961MAIN 6 123.09-738.55273,323.49 Nov. 7, 2024: 6 @ 123.09
Nov. 13, 2024issueSO-241113-646MAIN 6 123.09-738.55334,062.04 Nov. 7, 2024: 6 @ 123.09
Nov. 9, 2024issueSO-241109-945MAIN 5 123.09-615.46394,800.60 Nov. 7, 2024: 5 @ 123.09
Nov. 7, 2024receiptPO-000027MAIN 44 123.095,416.06445,416.06
Oct. 31, 2024issueSO-241031-145MAIN 15 125.11-1,876.5800.00 Oct. 1, 2024: 15 @ 125.11
Oct. 31, 2024issueSO-241031-145EAST 12 125.11-1,501.27151,876.58 Oct. 1, 2024: 12 @ 125.11
Oct. 23, 2024issueSO-241023-668MAIN 2 125.11-250.21273,377.85 Oct. 1, 2024: 2 @ 125.11
Oct. 12, 2024issueSO-241012-381MAIN 1 125.11-125.11293,628.06 Oct. 1, 2024: 1 @ 125.11
Oct. 9, 2024issueSO-241009-132MAIN 19 125.11-2,377.00303,753.16 Oct. 1, 2024: 19 @ 125.11
Oct. 1, 2024transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 49 125.116,130.17496,130.17