stocksense

Items / MCB-0007

Surge Protector Prime MCB-0007 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)22MAIN 11, EAST 11
Value (FIFO)716.64avg 32.57
ClassCX / FCV 0.34
Turnover7.3xlast issue 5 days ago
Days of cover39lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00070.011.623.134.746.2Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 29.0Nov 24: 18.0Dec 24: 12.0Jan 25: 22.0Feb 25: 23.0Mar 25: 42.0Apr 25: 17.0May 25: 17.0Jun 25: 15.0Jul 25: 16.0Aug 25: 16.0Sep 25: 7.0Oct 25: 6.0Nov 25: 24.0Dec 25: 20.0Jan 26: 15.0Feb 26: 15.0Mar 26: 25.0Apr 26: 11.0May 26: 26.0Jun 26: 22.0Jul 26: 12.0Aug 26: 18.0Sep 26: 14.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.437517.33 / 30.43750.569
Daily demand sdmonthly sd / sqrt(30.4375)5.96 / 5.5171.081
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 * 1.081^2 + 0.569^2 * 1.5^2)3.8
Reorder pointd * LT + safety stock0.569 * 7.0 + 3.87.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days7.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 208/yr, S = 45.00, h = 20%, price = 29.9076.0
Inventory positionon hand + on order22 + 022

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

From qtyUnit costOrder qtyAnnual costFeasible
032.50547,104no
3831.20556,827yes
7629.90766,565yes (chosen if cheapest)

MOQ 19, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 12, 202620 / 3432.52650.44
Sept. 12, 20262 / 233.1066.19

Movement ledger 135 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 11, 2026issueSO-261011-618MAIN 1 32.52-32.5222716.64 Sept. 12, 2026: 1 @ 32.52
Oct. 10, 2026issueSO-261010-996MAIN 5 32.52-162.6123749.16 Sept. 12, 2026: 5 @ 32.52
Oct. 8, 2026issueSO-261008-195MAIN 5 32.52-162.6128911.77 Sept. 12, 2026: 5 @ 32.52
Oct. 7, 2026issueSO-261007-626MAIN 1 32.52-32.52331,074.38 Sept. 12, 2026: 1 @ 32.52
Oct. 6, 2026issueSO-261006-572EAST 1 32.52-32.52341,106.90 Sept. 12, 2026: 1 @ 32.52
Oct. 3, 2026issueSO-261003-191MAIN 1 32.52-32.52351,139.42 Sept. 12, 2026: 1 @ 32.52
Sept. 25, 2026issueSO-260925-850MAIN 4 33.10-132.38361,171.95 July 16, 2026: 4 @ 33.10
Sept. 18, 2026issueSO-260918-872MAIN 2 33.10-66.19401,304.33 July 16, 2026: 2 @ 33.10
Sept. 12, 2026returnRMAMAIN 2 33.1066.19421,370.52
Sept. 12, 2026transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Sept. 12, 2026receiptPO-001794MAIN 34 32.521,105.75401,304.33
Sept. 2, 2026issueSO-260902-511MAIN 5 33.10-165.486198.57 July 16, 2026: 5 @ 33.10
Sept. 2, 2026issueSO-260902-511EAST 5 33.10-165.4811364.05 July 16, 2026: 5 @ 33.10
Aug. 25, 2026issueSO-260825-743MAIN 8 33.10-264.7716529.53 July 16, 2026: 8 @ 33.10
Aug. 24, 2026issueSO-260824-625EAST 2 33.10-66.1924794.30 July 16, 2026: 2 @ 33.10
Aug. 21, 2026issueSO-260821-110MAIN 3 33.10-99.2926860.49 July 16, 2026: 3 @ 33.10
Aug. 9, 2026issueSO-260809-294MAIN 3 33.10-99.2929959.78 July 16, 2026: 3 @ 33.10
Aug. 7, 2026issueSO-260807-517MAIN 1 33.10-33.10321,059.07 July 16, 2026: 1 @ 33.10
Aug. 2, 2026issueSO-260802-950EAST 1 33.10-33.10331,092.16 July 16, 2026: 1 @ 33.10
July 16, 2026transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
July 16, 2026receiptPO-001649MAIN 34 33.101,125.26341,125.26
July 15, 2026issueSO-260715-478EAST 7 32.73-229.0900.00 May 26, 2026: 7 @ 32.73
July 5, 2026issueSO-260705-211EAST 5 32.73-163.647229.09 May 26, 2026: 5 @ 32.73
June 25, 2026issueSO-260625-112EAST 2 32.73-65.4512392.73 May 26, 2026: 2 @ 32.73
June 8, 2026issueSO-260608-339EAST 1 32.73-32.7314458.18 May 26, 2026: 1 @ 32.73
June 8, 2026issueSO-260608-339MAIN 19 32.73-621.8215490.91 May 26, 2026: 19 @ 32.73
June 2, 2026adjustmentCycle countMAIN -2 31.88-63.76341,112.73 May 5, 2026: 1 @ 31.88; May 25, 2026: 1 @ 31.88
May 31, 2026issueSO-260531-138MAIN 5 31.88-159.40361,176.49 April 4, 2026: 4 @ 31.88; April 15, 2026: 1 @ 31.88
May 26, 2026transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
May 26, 2026receiptPO-001525MAIN 34 32.731,112.73411,335.89
May 25, 2026returnRMAMAIN 1 31.8831.887223.16
May 18, 2026issueSO-260518-532EAST 1 31.88-31.886191.28 April 4, 2026: 1 @ 31.88
May 18, 2026issueSO-260518-532MAIN 4 31.88-127.527223.16 April 4, 2026: 4 @ 31.88
May 13, 2026issueSO-260513-180MAIN 2 31.88-63.7611350.68 April 4, 2026: 2 @ 31.88
May 5, 2026returnRMAMAIN 1 31.8831.8813414.43
May 4, 2026issueSO-260504-558MAIN 15 31.88-478.1912382.56 April 4, 2026: 15 @ 31.88
May 1, 2026issueSO-260501-985MAIN 1 31.88-31.8827860.75 April 4, 2026: 1 @ 31.88
April 29, 2026issueSO-260429-144EAST 1 31.88-31.8828892.63 April 4, 2026: 1 @ 31.88
April 28, 2026issueSO-260428-314MAIN 1 31.88-31.8829924.51 April 4, 2026: 1 @ 31.88
April 15, 2026returnRMAMAIN 1 31.8831.8830956.39
April 13, 2026issueSO-260413-929MAIN 2 31.88-63.7629924.51 April 4, 2026: 2 @ 31.88
April 10, 2026issueSO-260410-211MAIN 3 31.88-95.6431988.27 April 4, 2026: 3 @ 31.88
April 5, 2026issueSO-260405-645MAIN 1 31.06-31.06341,083.91 Feb. 11, 2026: 1 @ 31.06
April 4, 2026transferTRFMAIN → EAST 7 warehouse transfer, no cost effect
April 4, 2026receiptPO-001385MAIN 34 31.881,083.91351,114.97
April 3, 2026issueSO-260403-784EAST 1 31.06-31.06131.06 Feb. 11, 2026: 1 @ 31.06
April 1, 2026issueSO-260401-732EAST 3 31.06-93.18262.12 Feb. 11, 2026: 3 @ 31.06
March 29, 2026issueSO-260329-241EAST 2 31.06-62.125155.31 Feb. 11, 2026: 2 @ 31.06
March 29, 2026issueSO-260329-241MAIN 5 31.06-155.317217.43 Feb. 11, 2026: 5 @ 31.06
March 27, 2026issueSO-260327-378MAIN 6 31.06-186.3712372.73 Feb. 11, 2026: 6 @ 31.06
March 10, 2026issueSO-260310-190MAIN 10 31.06-310.6118559.10 Feb. 11, 2026: 10 @ 31.06
March 7, 2026issueSO-260307-584MAIN 2 31.06-62.1228869.71 Feb. 11, 2026: 2 @ 31.06
Feb. 23, 2026issueSO-260223-522MAIN 1 31.06-31.0630931.84 Feb. 11, 2026: 1 @ 31.06
Feb. 11, 2026issueSO-260211-321EAST 3 31.06-93.1831962.90 Feb. 11, 2026: 3 @ 31.06
Feb. 11, 2026transferTRFMAIN → EAST 10 warehouse transfer, no cost effect
Feb. 11, 2026receiptPO-001218MAIN 34 31.061,056.08341,056.08
Feb. 5, 2026issueSO-260205-485MAIN 11 32.13-353.4200.00 Dec. 14, 2025: 11 @ 32.13
Jan. 31, 2026issueSO-260131-801MAIN 8 32.13-257.0311353.42 Dec. 14, 2025: 8 @ 32.13
Jan. 18, 2026issueSO-260118-259MAIN 5 32.13-160.6419610.45 Dec. 14, 2025: 5 @ 32.13
Jan. 4, 2026issueSO-260104-761MAIN 2 32.13-64.2624771.10 Dec. 14, 2025: 2 @ 32.13
Dec. 25, 2025issueSO-251225-522MAIN 2 32.13-64.2626835.35 Dec. 14, 2025: 2 @ 32.13
Dec. 19, 2025issueSO-251219-658MAIN 5 32.13-160.6428899.61 Dec. 14, 2025: 5 @ 32.13
Dec. 15, 2025issueSO-251215-197MAIN 1 32.13-32.13331,060.26 Dec. 14, 2025: 1 @ 32.13
Dec. 14, 2025receiptPO-001052MAIN 34 32.131,092.39341,092.39
Dec. 9, 2025issueSO-251209-991MAIN 5 30.68-153.4200.00 Sept. 26, 2025: 5 @ 30.68
Dec. 7, 2025issueSO-251207-568MAIN 7 30.68-214.785153.42 Sept. 26, 2025: 7 @ 30.68
Nov. 30, 2025issueSO-251130-658MAIN 3 30.68-92.0512368.20 Sept. 26, 2025: 3 @ 30.68
Nov. 26, 2025issueSO-251126-530MAIN 1 30.68-30.6815460.25 Sept. 26, 2025: 1 @ 30.68
Nov. 23, 2025issueSO-251123-277MAIN 1 30.68-30.6816490.93 Sept. 26, 2025: 1 @ 30.68
Nov. 22, 2025issueSO-251122-595MAIN 9 30.68-276.1517521.62 Sept. 26, 2025: 9 @ 30.68
Nov. 12, 2025issueSO-251112-156MAIN 3 30.68-92.0526797.77 Sept. 26, 2025: 3 @ 30.68
Nov. 12, 2025issueSO-251112-156EAST 4 30.68-122.7329889.82 Sept. 26, 2025: 4 @ 30.68
Nov. 2, 2025issueSO-251102-541MAIN 1 30.68-30.68331,012.55 Sept. 26, 2025: 1 @ 30.68
Nov. 1, 2025issueSO-251101-759MAIN 2 30.05-60.11341,043.24 July 12, 2025: 2 @ 30.05
Oct. 29, 2025issueSO-251029-970MAIN 1 30.05-30.05361,103.34 July 12, 2025: 1 @ 30.05
Oct. 27, 2025issueSO-251027-741MAIN 2 30.05-60.11371,133.39 July 12, 2025: 2 @ 30.05
Oct. 20, 2025issueSO-251020-306MAIN 1 30.05-30.05391,193.50 July 12, 2025: 1 @ 30.05
Oct. 18, 2025issueSO-251018-823MAIN 1 30.05-30.05401,223.55 July 12, 2025: 1 @ 30.05
Oct. 4, 2025issueSO-251004-149MAIN 1 30.05-30.05411,253.61 July 12, 2025: 1 @ 30.05
Sept. 26, 2025receiptPO-000876MAIN 34 30.681,043.24421,283.66
Sept. 22, 2025issueSO-250922-496MAIN 1 30.05-30.058240.42 July 12, 2025: 1 @ 30.05
Sept. 12, 2025issueSO-250912-911MAIN 3 30.05-90.169270.48 July 12, 2025: 3 @ 30.05
Sept. 10, 2025issueSO-250910-779MAIN 2 30.05-60.1112360.63 July 12, 2025: 2 @ 30.05
Sept. 3, 2025issueSO-250903-344EAST 1 30.05-30.0514420.74 July 12, 2025: 1 @ 30.05
Aug. 26, 2025issueSO-250826-624EAST 2 30.05-60.1115450.79 July 12, 2025: 2 @ 30.05
Aug. 25, 2025issueSO-250825-506MAIN 12 30.05-360.6317510.90 July 12, 2025: 12 @ 30.05
Aug. 21, 2025issueSO-250821-907EAST 1 30.05-30.0529871.53 July 12, 2025: 1 @ 30.05
Aug. 4, 2025issueSO-250804-866EAST 1 30.05-30.0530901.58 July 12, 2025: 1 @ 30.05
July 25, 2025issueSO-250725-336MAIN 3 30.05-90.1631931.64 July 12, 2025: 3 @ 30.05
July 12, 2025transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
July 12, 2025receiptPO-000703MAIN 34 30.051,021.80341,021.80
July 6, 2025issueSO-250706-372MAIN 13 29.81-387.5900.00 May 24, 2025: 13 @ 29.81
June 25, 2025issueSO-250625-769MAIN 1 29.81-29.8113387.59 May 24, 2025: 1 @ 29.81
June 15, 2025issueSO-250615-718MAIN 14 29.81-417.4114417.41 May 24, 2025: 14 @ 29.81
May 27, 2025issueSO-250527-803MAIN 4 29.81-119.2628834.82 May 24, 2025: 4 @ 29.81
May 24, 2025issueSO-250524-921MAIN 2 29.81-59.6332954.08 May 24, 2025: 2 @ 29.81
May 24, 2025receiptPO-000570MAIN 34 29.811,013.71341,013.71
May 22, 2025issueSO-250522-412MAIN 5 29.99-149.9400.00 March 23, 2025: 5 @ 29.99
May 19, 2025issueSO-250519-871MAIN 4 29.99-119.955149.94 March 23, 2025: 4 @ 29.99
May 12, 2025issueSO-250512-443MAIN 2 29.99-59.989269.89 March 23, 2025: 2 @ 29.99
April 27, 2025issueSO-250427-546MAIN 4 29.99-119.9511329.87 March 23, 2025: 4 @ 29.99
April 26, 2025issueSO-250426-312MAIN 1 29.99-29.9915449.82 March 23, 2025: 1 @ 29.99
April 14, 2025issueSO-250414-987MAIN 7 29.99-209.9216479.81 March 23, 2025: 7 @ 29.99
April 3, 2025issueSO-250403-585MAIN 5 29.99-149.9423689.73 March 23, 2025: 5 @ 29.99
March 30, 2025issueSO-250330-913MAIN 6 29.99-179.9328839.67 March 23, 2025: 6 @ 29.99
March 23, 2025receiptPO-000371MAIN 34 29.991,019.60341,019.60
March 17, 2025issueSO-250317-212MAIN 36 30.86-1,111.0700.00 Jan. 17, 2025: 2 @ 30.28; March 3, 2025: 34 @ 30.90
March 3, 2025receiptPO-000309MAIN 34 30.901,050.51361,111.07
Feb. 22, 2025issueSO-250222-125MAIN 12 30.28-363.39260.56 Jan. 17, 2025: 12 @ 30.28
Feb. 22, 2025issueSO-250222-125EAST 11 30.28-333.1014423.95 Jan. 17, 2025: 11 @ 30.28
Jan. 28, 2025issueSO-250128-161MAIN 6 30.28-181.6925757.05 Jan. 17, 2025: 6 @ 30.28
Jan. 21, 2025issueSO-250121-449MAIN 5 29.95-149.7631938.75 Nov. 10, 2024: 2 @ 29.46; Jan. 17, 2025: 3 @ 30.28
Jan. 17, 2025transferTRFMAIN → EAST 10 warehouse transfer, no cost effect
Jan. 17, 2025receiptPO-000192MAIN 34 30.281,029.59361,088.51
Jan. 15, 2025issueSO-250115-595MAIN 3 29.46-88.37258.92 Nov. 10, 2024: 3 @ 29.46
Jan. 12, 2025issueSO-250112-560MAIN 2 29.46-58.925147.29 Nov. 10, 2024: 2 @ 29.46
Jan. 10, 2025issueSO-250110-720EAST 2 29.46-58.927206.20 Nov. 10, 2024: 2 @ 29.46
Jan. 4, 2025issueSO-250104-244EAST 4 29.46-117.839265.12 Nov. 10, 2024: 4 @ 29.46
Dec. 25, 2024issueSO-241225-454MAIN 1 29.46-29.4613382.95 Nov. 10, 2024: 1 @ 29.46
Dec. 12, 2024issueSO-241212-478MAIN 7 29.46-206.2014412.41 Nov. 10, 2024: 7 @ 29.46
Dec. 4, 2024issueSO-241204-590MAIN 1 29.46-29.4621618.61 Nov. 10, 2024: 1 @ 29.46
Dec. 1, 2024issueSO-241201-577MAIN 3 29.46-88.3722648.07 Nov. 10, 2024: 3 @ 29.46
Nov. 23, 2024issueSO-241123-469EAST 1 29.46-29.4625736.44 Nov. 10, 2024: 1 @ 29.46
Nov. 14, 2024issueSO-241114-897MAIN 2 29.46-58.9226765.90 Nov. 10, 2024: 2 @ 29.46
Nov. 12, 2024issueSO-241112-112MAIN 6 29.46-176.7528824.82 Nov. 10, 2024: 6 @ 29.46
Nov. 10, 2024transferTRFMAIN → EAST 8 warehouse transfer, no cost effect
Nov. 10, 2024receiptPO-000028MAIN 34 29.461,001.57341,001.57
Nov. 8, 2024issueSO-241108-851MAIN 7 30.88-216.1200.00 Oct. 1, 2024: 7 @ 30.88
Nov. 5, 2024issueSO-241105-730MAIN 1 30.88-30.887216.12 Oct. 1, 2024: 1 @ 30.88
Nov. 4, 2024issueSO-241104-272MAIN 1 30.88-30.888247.00 Oct. 1, 2024: 1 @ 30.88
Oct. 30, 2024issueSO-241030-119MAIN 6 30.88-185.259277.88 Oct. 1, 2024: 6 @ 30.88
Oct. 24, 2024issueSO-241024-867MAIN 7 30.88-216.1215463.12 Oct. 1, 2024: 7 @ 30.88
Oct. 17, 2024issueSO-241017-482MAIN 6 30.88-185.2522679.25 Oct. 1, 2024: 6 @ 30.88
Oct. 1, 2024issueSO-241001-306MAIN 10 30.88-308.7528864.50 Oct. 1, 2024: 10 @ 30.88
Oct. 1, 2024receiptPO-000005MAIN 38 30.881,173.25381,173.25