stocksense

Items / MCB-0030

Surge Protector Lite MCB-0030 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)20MAIN 20
Value (FIFO)461.60avg 23.08
ClassCX / FCV 0.35
Turnover10.1xlast issue 2 days ago
Days of cover55lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00300.06.613.219.826.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 24.0Nov 24: 6.0Dec 24: 15.0Jan 25: 9.0Feb 25: 10.0Mar 25: 10.0Apr 25: 12.0May 25: 9.0Jun 25: 8.0Jul 25: 8.0Aug 25: 9.0Sep 25: 8.0Oct 25: 15.0Nov 25: 6.0Dec 25: 8.0Jan 26: 17.0Feb 26: 9.0Mar 26: 7.0Apr 26: 15.0May 26: 7.0Jun 26: 9.0Jul 26: 13.0Aug 26: 17.0Sep 26: 10.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.437511.08 / 30.43750.364
Daily demand sdmonthly sd / sqrt(30.4375)3.90 / 5.5170.708
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(7.0 * 0.708^2 + 0.364^2 * 1.5^2)2.5
Reorder pointd * LT + safety stock0.364 * 7.0 + 2.55.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days5.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 133/yr, S = 45.00, h = 20%, price = 21.9152.2
Inventory positionon hand + on order20 + 020

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

From qtyUnit costOrder qtyAnnual costFeasible
023.82503,405no
2422.87513,273no
4821.91523,142yes (chosen if cheapest)

MOQ 12, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 11, 202620 / 2123.08461.60

Movement ledger 126 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-642MAIN 2 23.51-47.0120461.60 Sept. 1, 2026: 1 @ 23.93; Oct. 11, 2026: 1 @ 23.08
Oct. 11, 2026receiptPO-001870MAIN 21 23.08484.6822508.61
Oct. 9, 2026issueSO-261009-230MAIN 3 23.93-71.80123.93 Sept. 1, 2026: 3 @ 23.93
Oct. 7, 2026issueSO-261007-781MAIN 1 23.93-23.93495.74 Sept. 1, 2026: 1 @ 23.93
Oct. 2, 2026issueSO-261002-338MAIN 1 23.93-23.935119.67 Sept. 1, 2026: 1 @ 23.93
Oct. 1, 2026issueSO-261001-992MAIN 8 23.93-191.486143.61 Sept. 1, 2026: 8 @ 23.93
Sept. 25, 2026issueSO-260925-881MAIN 1 23.93-23.9314335.09 Sept. 1, 2026: 1 @ 23.93
Sept. 21, 2026issueSO-260921-168MAIN 1 23.93-23.9315359.02 Sept. 1, 2026: 1 @ 23.93
Sept. 11, 2026issueSO-260911-103MAIN 1 23.93-23.9316382.96 Sept. 1, 2026: 1 @ 23.93
Sept. 1, 2026issueSO-260901-806MAIN 7 23.56-164.8917406.89 July 30, 2026: 3 @ 23.05; Sept. 1, 2026: 4 @ 23.93
Sept. 1, 2026receiptPO-001767MAIN 21 23.93502.6324571.78
Aug. 25, 2026issueSO-260825-660MAIN 3 23.05-69.15369.15 July 30, 2026: 3 @ 23.05
Aug. 18, 2026issueSO-260818-282MAIN 4 23.05-92.206138.29 July 30, 2026: 4 @ 23.05
Aug. 17, 2026issueSO-260817-943MAIN 4 23.05-92.2010230.49 July 30, 2026: 4 @ 23.05
Aug. 15, 2026issueSO-260815-111EAST 1 23.05-23.0514322.68 July 30, 2026: 1 @ 23.05
Aug. 10, 2026issueSO-260810-896MAIN 4 23.05-92.2015345.73 July 30, 2026: 4 @ 23.05
Aug. 8, 2026issueSO-260808-523EAST 1 23.05-23.0519437.93 July 30, 2026: 1 @ 23.05
July 30, 2026issueSO-260730-268EAST 4 23.52-94.1020460.98 May 12, 2026: 1 @ 23.68; July 16, 2026: 2 @ 23.68; July 30, 2026: 1 @ 23.05
July 30, 2026transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
July 30, 2026receiptPO-001686MAIN 21 23.05484.0224555.08
July 26, 2026issueSO-260726-372MAIN 1 23.68-23.68371.05 May 12, 2026: 1 @ 23.68
July 24, 2026issueSO-260724-928MAIN 3 23.68-71.05494.73 May 12, 2026: 3 @ 23.68
July 22, 2026issueSO-260722-941MAIN 1 23.68-23.687165.79 May 12, 2026: 1 @ 23.68
July 16, 2026returnRMAMAIN 2 23.6847.378189.47
July 6, 2026issueSO-260706-226MAIN 4 23.68-94.736142.10 May 12, 2026: 4 @ 23.68
July 5, 2026issueSO-260705-700MAIN 2 23.68-47.3710236.84 May 12, 2026: 2 @ 23.68
June 29, 2026issueSO-260629-496MAIN 1 23.68-23.6812284.20 May 12, 2026: 1 @ 23.68
June 26, 2026issueSO-260626-665MAIN 2 23.68-47.3713307.89 May 12, 2026: 2 @ 23.68
June 17, 2026issueSO-260617-340MAIN 1 23.68-23.6815355.25 May 12, 2026: 1 @ 23.68
June 10, 2026issueSO-260610-191MAIN 3 23.68-71.0516378.94 May 12, 2026: 3 @ 23.68
June 4, 2026issueSO-260604-807MAIN 2 23.68-47.3719449.99 May 12, 2026: 2 @ 23.68
May 15, 2026issueSO-260515-858EAST 1 22.77-22.7721497.36 March 25, 2026: 1 @ 22.77
May 12, 2026receiptPO-001487MAIN 21 23.68497.3622520.13
May 7, 2026issueSO-260507-907EAST 1 22.77-22.77122.77 March 25, 2026: 1 @ 22.77
May 7, 2026issueSO-260507-907MAIN 2 22.77-45.55245.55 March 25, 2026: 2 @ 22.77
May 5, 2026issueSO-260505-495MAIN 3 22.77-68.32491.10 March 25, 2026: 3 @ 22.77
April 23, 2026issueSO-260423-537MAIN 4 22.77-91.107159.42 March 25, 2026: 4 @ 22.77
April 14, 2026issueSO-260414-729MAIN 1 22.77-22.7711250.52 March 25, 2026: 1 @ 22.77
April 7, 2026issueSO-260407-326EAST 4 22.77-91.1012273.30 March 25, 2026: 4 @ 22.77
April 1, 2026issueSO-260401-367MAIN 6 22.92-137.5116364.40 Jan. 21, 2026: 1 @ 23.64; March 25, 2026: 5 @ 22.77
March 25, 2026transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
March 25, 2026receiptPO-001355MAIN 21 22.77478.2722501.91
March 23, 2026issueSO-260323-792MAIN 3 23.64-70.92123.64 Jan. 15, 2026: 1 @ 23.64; Jan. 21, 2026: 2 @ 23.64
March 16, 2026issueSO-260316-668MAIN 2 23.64-47.28494.55 Jan. 15, 2026: 2 @ 23.64
March 15, 2026issueSO-260315-574MAIN 2 23.64-47.286141.83 Jan. 15, 2026: 2 @ 23.64
Feb. 21, 2026issueSO-260221-749MAIN 2 23.64-47.288189.11 Jan. 15, 2026: 2 @ 23.64
Feb. 17, 2026issueSO-260217-587MAIN 4 23.64-94.5510236.38 Jan. 15, 2026: 4 @ 23.64
Feb. 15, 2026issueSO-260215-667MAIN 1 23.64-23.6414330.94 Jan. 15, 2026: 1 @ 23.64
Feb. 13, 2026issueSO-260213-174MAIN 1 23.64-23.6415354.58 Jan. 15, 2026: 1 @ 23.64
Feb. 6, 2026issueSO-260206-956MAIN 1 23.64-23.6416378.21 Jan. 15, 2026: 1 @ 23.64
Jan. 21, 2026returnRMAMAIN 3 23.6470.9217401.85
Jan. 17, 2026issueSO-260117-281MAIN 7 23.64-165.4714330.94 Jan. 15, 2026: 7 @ 23.64
Jan. 15, 2026receiptPO-001146MAIN 21 23.64496.4121496.41
Jan. 8, 2026issueSO-260108-829MAIN 7 22.98-160.8300.00 Nov. 13, 2025: 7 @ 22.98
Jan. 3, 2026issueSO-260103-741MAIN 6 22.98-137.867160.83 Nov. 13, 2025: 6 @ 22.98
Dec. 30, 2025issueSO-251230-663MAIN 2 22.98-45.9513298.69 Nov. 13, 2025: 2 @ 22.98
Dec. 26, 2025issueSO-251226-395MAIN 1 22.98-22.9815344.64 Nov. 13, 2025: 1 @ 22.98
Dec. 14, 2025issueSO-251214-236MAIN 1 22.98-22.9816367.62 Nov. 13, 2025: 1 @ 22.98
Dec. 9, 2025issueSO-251209-132MAIN 2 22.98-45.9517390.60 Nov. 13, 2025: 2 @ 22.98
Dec. 6, 2025issueSO-251206-917MAIN 2 22.98-45.9519436.55 Nov. 13, 2025: 2 @ 22.98
Nov. 13, 2025receiptPO-001000MAIN 21 22.98482.5021482.50
Nov. 12, 2025issueSO-251112-115MAIN 1 23.18-23.1800.00 Sept. 11, 2025: 1 @ 23.18
Nov. 7, 2025issueSO-251107-201MAIN 5 23.18-115.89123.18 Sept. 11, 2025: 5 @ 23.18
Oct. 29, 2025issueSO-251029-525MAIN 1 23.18-23.186139.07 Sept. 11, 2025: 1 @ 23.18
Oct. 23, 2025issueSO-251023-119MAIN 1 23.18-23.187162.24 Sept. 11, 2025: 1 @ 23.18
Oct. 10, 2025issueSO-251010-566MAIN 12 23.18-278.138185.42 Sept. 11, 2025: 12 @ 23.18
Oct. 2, 2025issueSO-251002-767MAIN 1 23.18-23.1820463.55 Sept. 11, 2025: 1 @ 23.18
Sept. 17, 2025issueSO-250917-951MAIN 1 22.88-22.8821486.73 June 17, 2025: 1 @ 22.88
Sept. 11, 2025receiptPO-000833MAIN 21 23.18486.7322509.61
Sept. 8, 2025issueSO-250908-191MAIN 4 22.88-91.50122.88 June 17, 2025: 4 @ 22.88
Sept. 5, 2025issueSO-250905-594MAIN 3 22.88-68.635114.38 June 17, 2025: 3 @ 22.88
Aug. 19, 2025issueSO-250819-137MAIN 2 22.88-45.758183.00 June 17, 2025: 2 @ 22.88
Aug. 7, 2025issueSO-250807-887MAIN 3 22.88-68.6310228.76 June 17, 2025: 3 @ 22.88
Aug. 6, 2025issueSO-250806-965MAIN 2 22.88-45.7513297.38 June 17, 2025: 2 @ 22.88
Aug. 1, 2025issueSO-250801-738MAIN 2 22.88-45.7515343.13 June 17, 2025: 2 @ 22.88
July 12, 2025issueSO-250712-951MAIN 1 22.88-22.8817388.88 June 17, 2025: 1 @ 22.88
July 12, 2025issueSO-250712-951EAST 1 22.88-22.8818411.76 June 17, 2025: 1 @ 22.88
July 6, 2025issueSO-250706-855MAIN 5 22.32-111.6019434.63 April 27, 2025: 3 @ 21.95; June 17, 2025: 2 @ 22.88
July 4, 2025issueSO-250704-555MAIN 1 21.95-21.9524546.24 April 27, 2025: 1 @ 21.95
June 22, 2025issueSO-250622-105EAST 1 21.95-21.9525568.19 April 27, 2025: 1 @ 21.95
June 17, 2025receiptPO-000645MAIN 21 22.88480.3926590.14
June 9, 2025issueSO-250609-603MAIN 7 21.95-153.655109.75 April 27, 2025: 7 @ 21.95
May 24, 2025issueSO-250524-538MAIN 1 21.95-21.9512263.40 April 27, 2025: 1 @ 21.95
May 20, 2025issueSO-250520-215MAIN 2 21.95-43.9013285.35 April 27, 2025: 2 @ 21.95
May 17, 2025issueSO-250517-131EAST 2 21.95-43.9015329.25 April 27, 2025: 2 @ 21.95
May 14, 2025issueSO-250514-225MAIN 4 21.95-87.8017373.16 April 27, 2025: 4 @ 21.95
April 27, 2025transferTRFMAIN → EAST 4 warehouse transfer, no cost effect
April 27, 2025receiptPO-000489MAIN 21 21.95460.9621460.96
April 21, 2025issueSO-250421-608MAIN 7 21.84-152.8900.00 March 5, 2025: 7 @ 21.84
April 8, 2025issueSO-250408-442MAIN 5 21.84-109.217152.89 March 5, 2025: 5 @ 21.84
March 28, 2025issueSO-250328-649MAIN 1 21.84-21.8412262.10 March 5, 2025: 1 @ 21.84
March 26, 2025issueSO-250326-134MAIN 1 21.84-21.8413283.94 March 5, 2025: 1 @ 21.84
March 21, 2025issueSO-250321-817MAIN 6 21.84-131.0514305.78 March 5, 2025: 6 @ 21.84
March 10, 2025issueSO-250310-784MAIN 1 21.84-21.8420436.83 March 5, 2025: 1 @ 21.84
March 5, 2025issueSO-250305-918MAIN 1 22.00-22.0021458.67 Dec. 25, 2024: 1 @ 22.00
March 5, 2025receiptPO-000318MAIN 21 21.84458.6722480.67
Feb. 28, 2025issueSO-250228-764MAIN 3 22.00-65.99122.00 Dec. 25, 2024: 3 @ 22.00
Feb. 27, 2025issueSO-250227-525EAST 2 22.00-43.99487.99 Dec. 25, 2024: 2 @ 22.00
Feb. 25, 2025issueSO-250225-977MAIN 1 22.00-22.006131.98 Dec. 25, 2024: 1 @ 22.00
Feb. 21, 2025issueSO-250221-564EAST 1 22.00-22.007153.98 Dec. 25, 2024: 1 @ 22.00
Feb. 16, 2025issueSO-250216-832EAST 1 22.00-22.008175.98 Dec. 25, 2024: 1 @ 22.00
Feb. 7, 2025issueSO-250207-455EAST 1 22.00-22.009197.97 Dec. 25, 2024: 1 @ 22.00
Feb. 5, 2025issueSO-250205-591MAIN 1 22.00-22.0010219.97 Dec. 25, 2024: 1 @ 22.00
Jan. 30, 2025issueSO-250130-561MAIN 1 22.00-22.0011241.97 Dec. 25, 2024: 1 @ 22.00
Jan. 29, 2025adjustmentCycle countMAIN -1 22.00-22.0012263.96 Dec. 25, 2024: 1 @ 22.00
Jan. 28, 2025issueSO-250128-354MAIN 2 22.00-43.9913285.96 Dec. 25, 2024: 2 @ 22.00
Jan. 25, 2025issueSO-250125-347MAIN 2 22.00-43.9915329.95 Dec. 25, 2024: 2 @ 22.00
Jan. 21, 2025issueSO-250121-694EAST 1 22.00-22.0017373.95 Dec. 25, 2024: 1 @ 22.00
Jan. 15, 2025issueSO-250115-552MAIN 3 22.00-65.9918395.94 Dec. 25, 2024: 3 @ 22.00
Dec. 25, 2024transferTRFMAIN → EAST 6 warehouse transfer, no cost effect
Dec. 25, 2024receiptPO-000135MAIN 21 22.00461.9321461.93
Dec. 23, 2024issueSO-241223-896MAIN 5 22.39-111.9600.00 Oct. 9, 2024: 4 @ 22.39; Nov. 12, 2024: 1 @ 22.39
Dec. 19, 2024issueSO-241219-421MAIN 8 22.39-179.135111.96 Oct. 9, 2024: 8 @ 22.39
Dec. 16, 2024issueSO-241216-184MAIN 2 22.39-44.7813291.09 Oct. 9, 2024: 2 @ 22.39
Nov. 16, 2024issueSO-241116-166MAIN 1 22.39-22.3915335.88 Oct. 9, 2024: 1 @ 22.39
Nov. 15, 2024issueSO-241115-660MAIN 1 22.39-22.3916358.27 Oct. 9, 2024: 1 @ 22.39
Nov. 12, 2024returnRMAMAIN 1 22.3922.3917380.66
Nov. 4, 2024issueSO-241104-111MAIN 1 22.39-22.3916358.27 Oct. 9, 2024: 1 @ 22.39
Nov. 3, 2024issueSO-241103-768MAIN 1 22.39-22.3917380.66 Oct. 9, 2024: 1 @ 22.39
Nov. 1, 2024issueSO-241101-452MAIN 3 22.39-67.1818403.05 Oct. 9, 2024: 3 @ 22.39
Oct. 9, 2024receiptPO-000006MAIN 21 22.39470.2321470.23
Oct. 7, 2024issueSO-241007-552EAST 1 22.63-22.6300.00 Oct. 1, 2024: 1 @ 22.63
Oct. 2, 2024issueSO-241002-231EAST 7 22.63-158.40122.63 Oct. 1, 2024: 7 @ 22.63
Oct. 2, 2024issueSO-241002-231MAIN 16 22.63-362.068181.03 Oct. 1, 2024: 16 @ 22.63
Oct. 1, 2024transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000005MAIN 24 22.63543.1024543.10