stocksense

Items / MCB-0018

MCB 32A TP Pro MCB-0018 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)45MAIN 36, EAST 9
Value (FIFO)2,093.18avg 46.52
ClassBX / FCV 0.44
Turnover8.5xlast issue 9 days ago
Days of cover58lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00180.018.436.955.373.7Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 12.0Nov 24: 17.0Dec 24: 27.0Jan 25: 17.0Feb 25: 37.0Mar 25: 23.0Apr 25: 9.0May 25: 21.0Jun 25: 67.0Jul 25: 23.0Aug 25: 25.0Sep 25: 12.0Oct 25: 16.0Nov 25: 19.0Dec 25: 40.0Jan 26: 18.0Feb 26: 24.0Mar 26: 33.0Apr 26: 10.0May 26: 15.0Jun 26: 35.0Jul 26: 41.0Aug 26: 16.0Sep 26: 15.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.437523.50 / 30.43750.772
Daily demand sdmonthly sd / sqrt(30.4375)10.37 / 5.5171.880
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 * 1.880^2 + 0.772^2 * 1.5^2)8.4
Reorder pointd * LT + safety stock0.772 * 7.0 + 8.413.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days13.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 282/yr, S = 45.00, h = 20%, price = 47.2051.8
Inventory positionon hand + on order45 + 045

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

From qtyUnit costOrder qtyAnnual costFeasible
047.205213,791yes (chosen if cheapest)

MOQ 25, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 14, 202645 / 4546.522,093.18

Movement ledger 131 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
Oct. 14, 2026receiptPO-001879MAIN 45 46.522,093.18452,093.18
Oct. 7, 2026issueSO-261007-875MAIN 8 46.47-371.7800.00 Aug. 2, 2026: 6 @ 46.31; Aug. 2, 2026: 2 @ 46.98
Oct. 5, 2026issueSO-261005-719MAIN 9 46.31-416.758371.78 Aug. 2, 2026: 9 @ 46.31
Oct. 4, 2026issueSO-261004-985MAIN 1 46.31-46.3117788.53 Aug. 2, 2026: 1 @ 46.31
Sept. 20, 2026issueSO-260920-784MAIN 2 46.31-92.6118834.84 Aug. 2, 2026: 2 @ 46.31
Sept. 12, 2026issueSO-260912-543MAIN 4 46.31-185.2220927.45 Aug. 2, 2026: 4 @ 46.31
Sept. 11, 2026issueSO-260911-453MAIN 5 46.31-231.53241,112.67 Aug. 2, 2026: 5 @ 46.31
Sept. 10, 2026issueSO-260910-487MAIN 1 46.31-46.31291,344.19 Aug. 2, 2026: 1 @ 46.31
Sept. 6, 2026issueSO-260906-271MAIN 3 46.31-138.92301,390.50 Aug. 2, 2026: 3 @ 46.31
Aug. 29, 2026issueSO-260829-573MAIN 11 46.31-509.36331,529.41 Aug. 2, 2026: 11 @ 46.31
Aug. 20, 2026issueSO-260820-829MAIN 2 46.31-92.61442,038.77 Aug. 2, 2026: 2 @ 46.31
Aug. 5, 2026issueSO-260805-496MAIN 1 46.31-46.31462,131.38 Aug. 2, 2026: 1 @ 46.31
Aug. 2, 2026returnRMAMAIN 2 46.9893.95472,177.68
Aug. 2, 2026receiptPO-001692MAIN 45 46.312,083.73452,083.73
Aug. 1, 2026issueSO-260801-329MAIN 4 46.98-187.9100.00 June 20, 2026: 4 @ 46.98
July 27, 2026issueSO-260727-792MAIN 11 46.98-516.754187.91 June 20, 2026: 11 @ 46.98
July 19, 2026issueSO-260719-272MAIN 4 46.98-187.9115704.66 June 20, 2026: 4 @ 46.98
July 16, 2026issueSO-260716-873MAIN 16 46.98-751.6319892.56 June 20, 2026: 16 @ 46.98
July 14, 2026issueSO-260714-333MAIN 1 46.98-46.98351,644.20 June 20, 2026: 1 @ 46.98
July 1, 2026issueSO-260701-495MAIN 9 46.98-422.79361,691.17 June 20, 2026: 9 @ 46.98
June 21, 2026issueSO-260621-304MAIN 7 45.11-315.77452,113.96 April 12, 2026: 7 @ 45.11
June 20, 2026receiptPO-001590MAIN 45 46.982,113.96522,429.74
June 14, 2026issueSO-260614-528MAIN 14 45.11-631.547315.77 April 12, 2026: 14 @ 45.11
June 13, 2026issueSO-260613-699MAIN 3 45.11-135.3321947.31 April 12, 2026: 3 @ 45.11
June 7, 2026issueSO-260607-215MAIN 7 45.11-315.77241,082.64 April 12, 2026: 7 @ 45.11
June 5, 2026issueSO-260605-211MAIN 4 45.11-180.44311,398.41 April 12, 2026: 4 @ 45.11
May 29, 2026issueSO-260529-300MAIN 1 45.11-45.11351,578.85 April 12, 2026: 1 @ 45.11
May 25, 2026issueSO-260525-483MAIN 2 45.11-90.22361,623.96 April 12, 2026: 2 @ 45.11
May 24, 2026issueSO-260524-153MAIN 4 45.11-180.44381,714.18 April 12, 2026: 4 @ 45.11
May 21, 2026issueSO-260521-406MAIN 3 45.11-135.33421,894.62 April 12, 2026: 3 @ 45.11
May 19, 2026issueSO-260519-747MAIN 4 46.82-187.29452,029.95 Feb. 21, 2026: 4 @ 46.82
May 8, 2026issueSO-260508-720MAIN 1 46.82-46.82492,217.25 Feb. 21, 2026: 1 @ 46.82
April 27, 2026issueSO-260427-774MAIN 1 46.82-46.82502,264.07 Feb. 21, 2026: 1 @ 46.82
April 21, 2026issueSO-260421-843MAIN 4 46.82-187.29512,310.89 Feb. 21, 2026: 4 @ 46.82
April 12, 2026receiptPO-001404MAIN 45 45.112,029.95552,498.18
April 10, 2026issueSO-260410-166MAIN 1 46.82-46.8210468.23 Feb. 21, 2026: 1 @ 46.82
April 4, 2026issueSO-260404-434MAIN 3 46.82-140.4711515.05 Feb. 21, 2026: 3 @ 46.82
April 3, 2026issueSO-260403-565MAIN 1 46.82-46.8214655.52 Feb. 21, 2026: 1 @ 46.82
March 25, 2026issueSO-260325-947MAIN 7 46.82-327.7615702.34 Feb. 21, 2026: 7 @ 46.82
March 21, 2026issueSO-260321-810MAIN 3 46.82-140.47221,030.10 Feb. 21, 2026: 3 @ 46.82
March 4, 2026issueSO-260304-783MAIN 23 46.61-1,071.98251,170.57 Dec. 25, 2025: 2 @ 45.17; Jan. 27, 2026: 1 @ 45.17; Feb. 21, 2026: 20 @ 46.82
Feb. 26, 2026issueSO-260226-720MAIN 5 45.17-225.87482,242.55 Dec. 25, 2025: 5 @ 45.17
Feb. 21, 2026receiptPO-001249MAIN 45 46.822,107.03532,468.42
Feb. 14, 2026issueSO-260214-115MAIN 5 45.17-225.878361.39 Dec. 25, 2025: 5 @ 45.17
Feb. 12, 2026issueSO-260212-366MAIN 10 45.17-451.7413587.26 Dec. 25, 2025: 10 @ 45.17
Feb. 10, 2026issueSO-260210-282MAIN 4 45.17-180.70231,039.00 Dec. 25, 2025: 4 @ 45.17
Jan. 27, 2026returnRMAMAIN 1 45.1745.17271,219.70
Jan. 23, 2026issueSO-260123-513MAIN 2 45.17-90.35261,174.53 Dec. 25, 2025: 2 @ 45.17
Jan. 19, 2026issueSO-260119-312MAIN 1 45.17-45.17281,264.87 Dec. 25, 2025: 1 @ 45.17
Jan. 19, 2026issueSO-260119-312EAST 3 45.17-135.52291,310.05 Dec. 25, 2025: 3 @ 45.17
Jan. 18, 2026issueSO-260118-282EAST 2 45.17-90.35321,445.57 Dec. 25, 2025: 2 @ 45.17
Jan. 9, 2026issueSO-260109-745EAST 7 45.17-316.22341,535.92 Dec. 25, 2025: 7 @ 45.17
Jan. 8, 2026issueSO-260108-483EAST 3 45.17-135.52411,852.14 Dec. 25, 2025: 3 @ 45.17
Jan. 7, 2026issueSO-260107-390MAIN 1 45.17-45.17441,987.66 Dec. 25, 2025: 1 @ 45.17
Dec. 25, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Dec. 25, 2025receiptPO-001088MAIN 45 45.172,032.83452,032.83
Dec. 22, 2025issueSO-251222-528MAIN 6 46.13-276.7600.00 Nov. 17, 2025: 6 @ 46.13
Dec. 18, 2025issueSO-251218-281MAIN 34 46.13-1,568.316276.76 Nov. 17, 2025: 34 @ 46.13
Nov. 22, 2025issueSO-251122-326MAIN 3 46.13-138.38401,845.07 Nov. 17, 2025: 3 @ 46.13
Nov. 19, 2025issueSO-251119-849MAIN 3 45.56-136.69431,983.45 Aug. 18, 2025: 1 @ 44.44; Nov. 17, 2025: 2 @ 46.13
Nov. 17, 2025issueSO-251117-458MAIN 7 44.44-311.08462,120.15 Aug. 18, 2025: 7 @ 44.44
Nov. 17, 2025receiptPO-001006MAIN 45 46.132,075.71532,431.22
Nov. 10, 2025issueSO-251110-189MAIN 6 44.44-266.648355.52 Aug. 18, 2025: 6 @ 44.44
Oct. 25, 2025issueSO-251025-860MAIN 2 44.44-88.8814622.15 Aug. 18, 2025: 2 @ 44.44
Oct. 24, 2025issueSO-251024-922MAIN 4 44.44-177.7616711.03 Aug. 18, 2025: 4 @ 44.44
Oct. 23, 2025issueSO-251023-725MAIN 5 44.44-222.2020888.79 Aug. 18, 2025: 5 @ 44.44
Oct. 22, 2025issueSO-251022-751MAIN 1 44.44-44.44251,110.99 Aug. 18, 2025: 1 @ 44.44
Oct. 2, 2025issueSO-251002-129MAIN 4 44.44-177.76261,155.43 Aug. 18, 2025: 4 @ 44.44
Sept. 27, 2025issueSO-250927-186MAIN 2 44.44-88.88301,333.19 Aug. 18, 2025: 2 @ 44.44
Sept. 24, 2025issueSO-250924-408MAIN 2 44.44-88.88321,422.07 Aug. 18, 2025: 2 @ 44.44
Sept. 16, 2025issueSO-250916-787MAIN 1 44.44-44.44341,510.95 Aug. 18, 2025: 1 @ 44.44
Sept. 12, 2025issueSO-250912-430MAIN 1 44.44-44.44351,555.39 Aug. 18, 2025: 1 @ 44.44
Sept. 9, 2025issueSO-250909-687MAIN 1 44.44-44.44361,599.83 Aug. 18, 2025: 1 @ 44.44
Sept. 6, 2025issueSO-250906-434MAIN 5 44.44-222.20371,644.27 Aug. 18, 2025: 5 @ 44.44
Aug. 18, 2025issueSO-250818-349MAIN 3 44.44-133.32421,866.46 Aug. 18, 2025: 3 @ 44.44
Aug. 18, 2025receiptPO-000783MAIN 45 44.441,999.78451,999.78
Aug. 14, 2025issueSO-250814-198MAIN 13 45.94-597.1900.00 July 4, 2025: 13 @ 45.94
Aug. 4, 2025issueSO-250804-995MAIN 3 45.94-137.8113597.19 July 4, 2025: 3 @ 45.94
Aug. 4, 2025issueSO-250804-995EAST 6 45.94-275.6316735.00 July 4, 2025: 6 @ 45.94
July 28, 2025issueSO-250728-996EAST 8 45.94-367.50221,010.63 July 4, 2025: 8 @ 45.94
July 20, 2025issueSO-250720-482MAIN 5 45.94-229.69301,378.13 July 4, 2025: 5 @ 45.94
July 6, 2025issueSO-250706-429MAIN 10 45.94-459.38351,607.82 July 4, 2025: 10 @ 45.94
July 4, 2025transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
July 4, 2025receiptPO-000683MAIN 45 45.942,067.20452,067.20
June 26, 2025issueSO-250626-734EAST 12 44.38-532.5700.00 June 22, 2025: 12 @ 44.38
June 26, 2025issueSO-250626-734MAIN 33 44.38-1,464.5712532.57 June 22, 2025: 33 @ 44.38
June 22, 2025transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
June 22, 2025receiptPO-000658MAIN 45 44.381,997.14451,997.14
June 16, 2025issueSO-250616-845EAST 2 44.80-89.6000.00 April 6, 2025: 2 @ 44.80
June 16, 2025issueSO-250616-845MAIN 20 44.80-896.03289.60 April 6, 2025: 20 @ 44.80
May 27, 2025issueSO-250527-490EAST 7 44.80-313.6122985.63 April 6, 2025: 7 @ 44.80
May 17, 2025issueSO-250517-405EAST 1 44.80-44.80291,299.24 April 6, 2025: 1 @ 44.80
May 14, 2025issueSO-250514-195MAIN 13 44.80-582.42301,344.04 April 6, 2025: 13 @ 44.80
April 16, 2025issueSO-250416-678MAIN 1 44.80-44.80431,926.46 April 6, 2025: 1 @ 44.80
April 12, 2025issueSO-250412-983EAST 1 44.80-44.80441,971.27 April 6, 2025: 1 @ 44.80
April 6, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
April 6, 2025receiptPO-000420MAIN 45 44.802,016.07452,016.07
April 5, 2025issueSO-250405-753MAIN 4 43.80-175.2200.00 Feb. 23, 2025: 4 @ 43.80
April 1, 2025issueSO-250401-540MAIN 3 43.80-131.414175.22 Feb. 23, 2025: 3 @ 43.80
March 31, 2025issueSO-250331-598MAIN 6 43.80-262.837306.63 Feb. 23, 2025: 6 @ 43.80
March 18, 2025issueSO-250318-940MAIN 13 43.80-569.4613569.46 Feb. 23, 2025: 13 @ 43.80
March 9, 2025issueSO-250309-567MAIN 4 43.80-175.22261,138.93 Feb. 23, 2025: 4 @ 43.80
Feb. 23, 2025issueSO-250223-706MAIN 15 43.80-657.07301,314.15 Feb. 23, 2025: 15 @ 43.80
Feb. 23, 2025receiptPO-000296MAIN 45 43.801,971.22451,971.22
Feb. 17, 2025issueSO-250217-668MAIN 12 43.32-519.8700.00 Dec. 17, 2024: 10 @ 43.32; Feb. 11, 2025: 2 @ 43.32
Feb. 14, 2025issueSO-250214-662MAIN 3 43.32-129.9712519.87 Dec. 17, 2024: 3 @ 43.32
Feb. 11, 2025returnRMAMAIN 2 43.3286.6515649.84
Feb. 10, 2025issueSO-250210-991MAIN 8 43.32-346.5813563.20 Dec. 17, 2024: 8 @ 43.32
Feb. 4, 2025issueSO-250204-255MAIN 1 43.32-43.3221909.78 Dec. 17, 2024: 1 @ 43.32
Jan. 31, 2025issueSO-250131-381MAIN 4 43.32-173.2922953.10 Dec. 17, 2024: 4 @ 43.32
Jan. 27, 2025issueSO-250127-209MAIN 8 43.32-346.58261,126.39 Dec. 17, 2024: 8 @ 43.32
Jan. 20, 2025issueSO-250120-782MAIN 1 43.32-43.32341,472.98 Dec. 17, 2024: 1 @ 43.32
Jan. 2, 2025issueSO-250102-772MAIN 4 43.32-173.29351,516.30 Dec. 17, 2024: 4 @ 43.32
Dec. 28, 2024issueSO-241228-162MAIN 2 43.32-86.65391,689.59 Dec. 17, 2024: 2 @ 43.32
Dec. 23, 2024issueSO-241223-562MAIN 4 43.32-173.29411,776.23 Dec. 17, 2024: 4 @ 43.32
Dec. 17, 2024receiptPO-000112MAIN 45 43.321,949.53451,949.53
Dec. 15, 2024issueSO-241215-216MAIN 3 44.84-134.5200.00 Oct. 1, 2024: 3 @ 44.84
Dec. 14, 2024issueSO-241214-118MAIN 7 44.84-313.883134.52 Oct. 1, 2024: 7 @ 44.84
Dec. 10, 2024issueSO-241210-511MAIN 6 44.84-269.0410448.40 Oct. 1, 2024: 6 @ 44.84
Dec. 4, 2024issueSO-241204-895MAIN 3 44.84-134.5216717.44 Oct. 1, 2024: 3 @ 44.84
Dec. 3, 2024issueSO-241203-112MAIN 2 44.84-89.6819851.96 Oct. 1, 2024: 2 @ 44.84
Nov. 24, 2024issueSO-241124-231MAIN 2 44.84-89.6821941.64 Oct. 1, 2024: 2 @ 44.84
Nov. 21, 2024issueSO-241121-244MAIN 3 44.84-134.52231,031.32 Oct. 1, 2024: 3 @ 44.84
Nov. 16, 2024issueSO-241116-648MAIN 1 44.84-44.84261,165.84 Oct. 1, 2024: 1 @ 44.84
Nov. 11, 2024issueSO-241111-295MAIN 6 44.84-269.04271,210.68 Oct. 1, 2024: 6 @ 44.84
Nov. 7, 2024issueSO-241107-147MAIN 2 44.84-89.68331,479.72 Oct. 1, 2024: 2 @ 44.84
Nov. 3, 2024issueSO-241103-894MAIN 3 44.84-134.52351,569.40 Oct. 1, 2024: 3 @ 44.84
Oct. 10, 2024issueSO-241010-156MAIN 5 44.84-224.20381,703.92 Oct. 1, 2024: 5 @ 44.84
Oct. 4, 2024issueSO-241004-216MAIN 7 44.84-313.88431,928.12 Oct. 1, 2024: 7 @ 44.84
Oct. 1, 2024receiptPO-000005MAIN 50 44.842,242.00502,242.00