stocksense

Items / MCB-0011

Isolator 63A Elite MCB-0011 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)60MAIN 60
Value (FIFO)2,014.84avg 33.58
ClassBY / FCV 0.52
Turnover7.2xlast issue 1 days ago
Days of cover34lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00110.034.468.8103138Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 19.0Nov 24: 69.0Dec 24: 49.0Jan 25: 63.0Feb 25: 62.0Mar 25: 33.0Apr 25: 61.0May 25: 73.0Jun 25: 51.0Jul 25: 69.0Aug 25: 119.0Sep 25: 22.0Oct 25: 49.0Nov 25: 86.0Dec 25: 125.0Jan 26: 26.0Feb 26: 48.0Mar 26: 72.0Apr 26: 28.0May 26: 39.0Jun 26: 39.0Jul 26: 37.0Aug 26: 54.0Sep 26: 33.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.437553.00 / 30.43751.741
Daily demand sdmonthly sd / sqrt(30.4375)27.50 / 5.5174.985
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 * 4.985^2 + 1.741^2 * 1.5^2)22.1
Reorder pointd * LT + safety stock1.741 * 7.0 + 22.134.2
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days34.2
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 636/yr, S = 45.00, h = 20%, price = 33.8391.9
Inventory positionon hand + on order60 + 060

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

From qtyUnit costOrder qtyAnnual costFeasible
033.839222,123yes (chosen if cheapest)

MOQ 52, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 10, 202660 / 9433.582,014.84

Movement ledger 129 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-567MAIN 5 33.58-167.90602,014.84 Sept. 10, 2026: 5 @ 33.58
Oct. 12, 2026issueSO-261012-536MAIN 3 33.58-100.74652,182.75 Sept. 10, 2026: 3 @ 33.58
Oct. 8, 2026issueSO-261008-895MAIN 4 33.58-134.32682,283.49 Sept. 10, 2026: 4 @ 33.58
Oct. 3, 2026issueSO-261003-831MAIN 2 33.58-67.16722,417.81 Sept. 10, 2026: 2 @ 33.58
Oct. 1, 2026issueSO-261001-111MAIN 20 33.58-671.61742,484.97 Sept. 10, 2026: 20 @ 33.58
Sept. 10, 2026receiptPO-001788MAIN 94 33.583,156.59943,156.59
Sept. 2, 2026issueSO-260902-731MAIN 33 33.58-1,108.0500.00 July 8, 2026: 33 @ 33.58
Aug. 19, 2026issueSO-260819-935MAIN 17 33.58-570.82331,108.05 July 8, 2026: 17 @ 33.58
Aug. 15, 2026issueSO-260815-636MAIN 13 33.58-436.51501,678.87 July 8, 2026: 13 @ 33.58
Aug. 2, 2026issueSO-260802-226MAIN 15 33.58-503.66632,115.38 July 8, 2026: 15 @ 33.58
Aug. 1, 2026issueSO-260801-628MAIN 9 33.58-302.20782,619.04 July 8, 2026: 9 @ 33.58
July 21, 2026issueSO-260721-876MAIN 7 33.58-235.04872,921.23 July 8, 2026: 7 @ 33.58
July 16, 2026issueSO-260716-504MAIN 5 32.29-161.46943,156.28 June 25, 2026: 5 @ 32.29
July 8, 2026receiptPO-001636MAIN 94 33.583,156.28993,317.73
July 6, 2026issueSO-260706-273MAIN 5 32.29-161.465161.46 May 3, 2026: 1 @ 32.29; June 25, 2026: 4 @ 32.29
July 4, 2026issueSO-260704-145MAIN 10 32.29-322.9110322.91 May 3, 2026: 10 @ 32.29
July 2, 2026issueSO-260702-756MAIN 10 32.29-322.9120645.82 May 3, 2026: 10 @ 32.29
June 29, 2026issueSO-260629-227MAIN 9 32.29-290.6230968.73 May 3, 2026: 9 @ 32.29
June 25, 2026returnRMAMAIN 9 32.29290.62391,259.35
June 21, 2026issueSO-260621-137MAIN 4 32.29-129.1630968.73 May 3, 2026: 4 @ 32.29
June 21, 2026issueSO-260621-137EAST 17 32.29-548.95341,097.89 May 3, 2026: 17 @ 32.29
June 14, 2026issueSO-260614-805MAIN 18 32.29-581.24511,646.84 May 3, 2026: 18 @ 32.29
May 30, 2026issueSO-260530-540MAIN 15 32.29-484.36692,228.08 May 3, 2026: 15 @ 32.29
May 22, 2026issueSO-260522-773EAST 5 32.29-161.46842,712.44 May 3, 2026: 5 @ 32.29
May 16, 2026issueSO-260516-643EAST 2 32.29-64.58892,873.90 May 3, 2026: 2 @ 32.29
May 6, 2026issueSO-260506-106MAIN 14 32.40-453.65912,938.48 March 8, 2026: 11 @ 32.43; May 3, 2026: 3 @ 32.29
May 5, 2026issueSO-260505-392MAIN 1 32.43-32.431053,392.13 March 8, 2026: 1 @ 32.43
May 4, 2026issueSO-260504-954MAIN 2 32.43-64.871063,424.57 March 8, 2026: 2 @ 32.43
May 3, 2026transferTRFMAIN → EAST 24 warehouse transfer, no cost effect
May 3, 2026receiptPO-001461MAIN 94 32.293,035.351083,489.44
April 27, 2026issueSO-260427-279MAIN 11 32.43-356.7814454.08 March 8, 2026: 11 @ 32.43
April 24, 2026issueSO-260424-597MAIN 6 32.43-194.6125810.86 March 8, 2026: 6 @ 32.43
April 14, 2026issueSO-260414-390MAIN 4 32.43-129.74311,005.47 March 8, 2026: 4 @ 32.43
April 2, 2026issueSO-260402-622MAIN 7 32.43-227.04351,135.20 March 8, 2026: 7 @ 32.43
March 21, 2026issueSO-260321-747MAIN 33 32.43-1,070.34421,362.24 March 8, 2026: 33 @ 32.43
March 12, 2026issueSO-260312-794MAIN 12 32.43-389.21752,432.58 March 8, 2026: 12 @ 32.43
March 9, 2026issueSO-260309-891MAIN 25 32.90-822.49872,821.79 Dec. 29, 2025: 16 @ 33.08; March 5, 2026: 2 @ 33.08; March 8, 2026: 7 @ 32.43
March 8, 2026receiptPO-001297MAIN 94 32.433,048.831123,644.28
March 5, 2026returnRMAMAIN 2 33.0866.1618595.45
March 4, 2026issueSO-260304-206MAIN 4 33.08-132.3216529.28 Dec. 29, 2025: 4 @ 33.08
Feb. 28, 2026issueSO-260228-118MAIN 8 33.08-264.6420661.61 Dec. 29, 2025: 8 @ 33.08
Feb. 20, 2026issueSO-260220-244MAIN 7 33.08-231.5628926.25 Dec. 29, 2025: 7 @ 33.08
Feb. 16, 2026issueSO-260216-350MAIN 4 33.08-132.32351,157.81 Dec. 29, 2025: 4 @ 33.08
Feb. 14, 2026issueSO-260214-698MAIN 27 33.08-893.17391,290.13 Dec. 29, 2025: 27 @ 33.08
Feb. 8, 2026issueSO-260208-100MAIN 1 33.08-33.08662,183.30 Dec. 29, 2025: 1 @ 33.08
Feb. 6, 2026issueSO-260206-171MAIN 1 33.08-33.08672,216.38 Dec. 29, 2025: 1 @ 33.08
Jan. 29, 2026issueSO-260129-294MAIN 8 33.08-264.64682,249.46 Dec. 29, 2025: 8 @ 33.08
Jan. 26, 2026issueSO-260126-411MAIN 7 33.08-231.56762,514.10 Dec. 29, 2025: 7 @ 33.08
Jan. 20, 2026issueSO-260120-462MAIN 5 33.08-165.40832,745.66 Dec. 29, 2025: 5 @ 33.08
Jan. 10, 2026issueSO-260110-793MAIN 3 33.08-99.24882,911.07 Dec. 29, 2025: 3 @ 33.08
Jan. 7, 2026issueSO-260107-851MAIN 3 33.08-99.24913,010.31 Dec. 29, 2025: 3 @ 33.08
Dec. 29, 2025receiptPO-001102MAIN 94 33.083,109.55943,109.55
Dec. 24, 2025issueSO-251224-196MAIN 22 31.74-698.3000.00 Dec. 8, 2025: 16 @ 31.74; Dec. 20, 2025: 6 @ 31.74
Dec. 20, 2025returnRMAMAIN 6 31.74190.4522698.30
Dec. 19, 2025issueSO-251219-702MAIN 70 31.74-2,221.8816507.86 Dec. 8, 2025: 70 @ 31.74
Dec. 13, 2025issueSO-251213-540MAIN 18 31.86-573.45862,729.73 Oct. 9, 2025: 10 @ 31.95; Dec. 8, 2025: 8 @ 31.74
Dec. 8, 2025receiptPO-001039MAIN 94 31.742,983.661043,303.18
Dec. 4, 2025issueSO-251204-570MAIN 12 31.95-383.4210319.52 Oct. 9, 2025: 12 @ 31.95
Dec. 1, 2025issueSO-251201-497MAIN 9 31.95-287.5722702.94 Oct. 9, 2025: 9 @ 31.95
Nov. 25, 2025issueSO-251125-964MAIN 57 31.95-1,821.2631990.51 Oct. 9, 2025: 57 @ 31.95
Nov. 18, 2025issueSO-251118-454MAIN 7 31.94-223.61882,811.77 Sept. 4, 2025: 1 @ 31.90; Oct. 9, 2025: 6 @ 31.95
Nov. 8, 2025issueSO-251108-651MAIN 22 31.90-701.86953,035.38 Sept. 4, 2025: 22 @ 31.90
Oct. 9, 2025receiptPO-000912MAIN 94 31.953,003.481173,737.24
Oct. 4, 2025issueSO-251004-417MAIN 24 31.90-765.6723733.76 Sept. 4, 2025: 24 @ 31.90
Oct. 1, 2025issueSO-251001-566MAIN 25 31.90-797.57471,499.43 Sept. 4, 2025: 25 @ 31.90
Sept. 23, 2025issueSO-250923-926MAIN 7 31.90-223.32722,297.00 Sept. 4, 2025: 7 @ 31.90
Sept. 18, 2025issueSO-250918-557MAIN 3 31.90-95.71792,520.32 Sept. 4, 2025: 3 @ 31.90
Sept. 13, 2025issueSO-250913-821MAIN 7 31.90-223.32822,616.03 Sept. 4, 2025: 7 @ 31.90
Sept. 11, 2025issueSO-250911-797MAIN 3 31.90-95.71892,839.35 Sept. 4, 2025: 3 @ 31.90
Sept. 9, 2025issueSO-250909-290MAIN 1 31.90-31.90922,935.06 Sept. 4, 2025: 1 @ 31.90
Sept. 6, 2025issueSO-250906-731MAIN 1 31.90-31.90932,966.96 Sept. 4, 2025: 1 @ 31.90
Sept. 4, 2025receiptPO-000816MAIN 94 31.902,998.86942,998.86
Aug. 29, 2025issueSO-250829-825MAIN 94 32.05-3,012.4400.00 Aug. 29, 2025: 94 @ 32.05
Aug. 29, 2025receiptPO-000804MAIN 94 32.053,012.44943,012.44
Aug. 26, 2025issueSO-250826-228MAIN 2 31.75-63.4900.00 June 26, 2025: 2 @ 31.75
Aug. 23, 2025issueSO-250823-663MAIN 23 31.75-730.18263.49 June 26, 2025: 23 @ 31.75
July 28, 2025issueSO-250728-457MAIN 3 31.75-95.2425793.68 June 26, 2025: 3 @ 31.75
July 20, 2025issueSO-250720-287MAIN 46 31.75-1,460.3628888.92 June 26, 2025: 46 @ 31.75
July 18, 2025issueSO-250718-678MAIN 8 31.75-253.98742,349.28 June 26, 2025: 8 @ 31.75
July 16, 2025issueSO-250716-709MAIN 3 31.75-95.24822,603.25 June 26, 2025: 3 @ 31.75
July 4, 2025issueSO-250704-600MAIN 7 31.75-222.23852,698.50 June 26, 2025: 7 @ 31.75
July 2, 2025issueSO-250702-437MAIN 2 31.75-63.49922,920.72 June 26, 2025: 2 @ 31.75
June 26, 2025receiptPO-000668MAIN 94 31.752,984.22942,984.22
June 19, 2025issueSO-250619-853MAIN 45 31.92-1,436.4900.00 May 14, 2025: 44 @ 31.92; June 18, 2025: 1 @ 31.92
June 19, 2025issueSO-250619-853EAST 4 31.92-127.69451,436.49 May 14, 2025: 4 @ 31.92
June 18, 2025returnRMAMAIN 1 31.9231.92491,564.18
June 6, 2025issueSO-250606-109EAST 3 31.92-95.77481,532.26 May 14, 2025: 3 @ 31.92
May 28, 2025issueSO-250528-270EAST 17 31.92-542.67511,628.02 May 14, 2025: 17 @ 31.92
May 26, 2025issueSO-250526-509EAST 1 31.92-31.92682,170.70 May 14, 2025: 1 @ 31.92
May 22, 2025issueSO-250522-856MAIN 11 31.92-351.14692,202.62 May 14, 2025: 11 @ 31.92
May 19, 2025issueSO-250519-575MAIN 14 31.92-446.91802,553.76 May 14, 2025: 14 @ 31.92
May 16, 2025issueSO-250516-130MAIN 1 31.29-31.29943,000.67 March 11, 2025: 1 @ 31.29
May 14, 2025transferTRFMAIN → EAST 25 warehouse transfer, no cost effect
May 14, 2025receiptPO-000536MAIN 94 31.923,000.67953,031.96
May 12, 2025issueSO-250512-631MAIN 7 31.29-219.02131.29 March 11, 2025: 7 @ 31.29
May 6, 2025issueSO-250506-423MAIN 22 31.29-688.338250.30 March 11, 2025: 22 @ 31.29
April 30, 2025issueSO-250430-968MAIN 7 31.29-219.0230938.64 March 11, 2025: 7 @ 31.29
April 23, 2025issueSO-250423-151EAST 4 31.29-125.15371,157.65 March 11, 2025: 4 @ 31.29
April 17, 2025issueSO-250417-841MAIN 1 31.29-31.29411,282.80 March 11, 2025: 1 @ 31.29
April 14, 2025issueSO-250414-895MAIN 38 31.29-1,188.94421,314.09 March 11, 2025: 38 @ 31.29
April 4, 2025issueSO-250404-294EAST 8 31.29-250.30802,503.03 March 11, 2025: 8 @ 31.29
April 1, 2025issueSO-250401-485MAIN 3 31.29-93.86882,753.34 March 11, 2025: 3 @ 31.29
March 30, 2025issueSO-250330-173MAIN 1 31.29-31.29912,847.20 March 11, 2025: 1 @ 31.29
March 27, 2025issueSO-250327-123EAST 12 30.79-369.49922,878.49 Jan. 8, 2025: 10 @ 30.69; March 11, 2025: 2 @ 31.29
March 22, 2025issueSO-250322-844EAST 2 30.69-61.381043,247.97 Jan. 8, 2025: 2 @ 30.69
March 21, 2025issueSO-250321-174MAIN 7 30.69-214.841063,309.36 Jan. 8, 2025: 7 @ 30.69
March 11, 2025transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
March 11, 2025receiptPO-000336MAIN 94 31.292,941.061133,524.19
March 2, 2025issueSO-250302-150MAIN 11 30.69-337.6019583.13 Jan. 8, 2025: 11 @ 30.69
Feb. 28, 2025issueSO-250228-911MAIN 3 30.69-92.0730920.73 Jan. 8, 2025: 3 @ 30.69
Feb. 10, 2025issueSO-250210-678MAIN 59 30.69-1,810.77331,012.81 Jan. 8, 2025: 59 @ 30.69
Jan. 28, 2025issueSO-250128-185MAIN 2 30.69-61.38922,823.58 Jan. 8, 2025: 2 @ 30.69
Jan. 8, 2025receiptPO-000173MAIN 94 30.692,884.96942,884.96
Jan. 7, 2025issueSO-250107-454MAIN 18 31.74-571.3500.00 Dec. 2, 2024: 14 @ 31.74; Dec. 29, 2024: 4 @ 31.74
Jan. 2, 2025issueSO-250102-957MAIN 43 31.74-1,364.8818571.35 Dec. 2, 2024: 43 @ 31.74
Dec. 29, 2024returnRMAMAIN 4 31.74126.97611,936.23
Dec. 28, 2024issueSO-241228-575MAIN 29 31.74-920.50571,809.26 Dec. 2, 2024: 29 @ 31.74
Dec. 26, 2024issueSO-241226-432MAIN 15 31.93-478.90862,729.76 Oct. 1, 2024: 7 @ 32.14; Dec. 2, 2024: 8 @ 31.74
Dec. 21, 2024issueSO-241221-663MAIN 9 32.14-289.251013,208.66 Oct. 1, 2024: 9 @ 32.14
Dec. 2, 2024receiptPO-000076MAIN 94 31.742,983.691103,497.91
Nov. 25, 2024issueSO-241125-856MAIN 16 32.14-514.2216514.22 Oct. 1, 2024: 16 @ 32.14
Nov. 24, 2024issueSO-241124-246MAIN 5 32.14-160.69321,028.43 Oct. 1, 2024: 5 @ 32.14
Nov. 13, 2024issueSO-241113-102MAIN 28 32.14-899.88371,189.12 Oct. 1, 2024: 28 @ 32.14
Nov. 8, 2024issueSO-241108-711MAIN 1 32.14-32.14652,089.00 Oct. 1, 2024: 1 @ 32.14
Nov. 1, 2024issueSO-241101-739MAIN 19 32.14-610.63662,121.14 Oct. 1, 2024: 19 @ 32.14
Oct. 14, 2024issueSO-241014-936MAIN 2 32.14-64.28852,731.77 Oct. 1, 2024: 2 @ 32.14
Oct. 7, 2024issueSO-241007-863MAIN 4 32.14-128.55872,796.05 Oct. 1, 2024: 4 @ 32.14
Oct. 2, 2024issueSO-241002-348MAIN 13 32.14-417.80912,924.60 Oct. 1, 2024: 13 @ 32.14
Oct. 1, 2024receiptPO-000005MAIN 104 32.143,342.401043,342.40