stocksense

Items / MCB-0023

Surge Protector Eco MCB-0023 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)72MAIN 72
Value (FIFO)6,232.42avg 86.56
ClassAX / FCV 0.39
Turnover7.7xlast issue 5 days ago
Days of cover55lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00230.020.641.261.982.5Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 18.0Nov 24: 65.0Dec 24: 35.0Jan 25: 34.0Feb 25: 26.0Mar 25: 38.0Apr 25: 30.0May 25: 50.0Jun 25: 18.0Jul 25: 36.0Aug 25: 26.0Sep 25: 64.0Oct 25: 31.0Nov 25: 38.0Dec 25: 75.0Jan 26: 57.0Feb 26: 28.0Mar 26: 32.0Apr 26: 36.0May 26: 55.0Jun 26: 54.0Jul 26: 26.0Aug 26: 23.0Sep 26: 25.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.437540.00 / 30.43751.314
Daily demand sdmonthly sd / sqrt(30.4375)15.69 / 5.5172.844
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 * 2.844^2 + 1.314^2 * 1.5^2)16.0
Reorder pointd * LT + safety stock1.314 * 7.0 + 16.025.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days25.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 480/yr, S = 45.00, h = 20%, price = 78.15160.0
Inventory positionon hand + on order72 + 072

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

From qtyUnit costOrder qtyAnnual costFeasible
084.955041,605yes
8081.558040,040yes
16078.1516038,874yes (chosen if cheapest)

MOQ 40, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 13, 202672 / 7286.566,232.42

Movement ledger 133 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026receiptPO-001878MAIN 72 86.566,232.42726,232.42
Oct. 11, 2026issueSO-261011-807MAIN 14 83.90-1,174.5500.00 July 29, 2026: 14 @ 83.90
Oct. 5, 2026issueSO-261005-671MAIN 8 83.90-671.17141,174.55 July 29, 2026: 8 @ 83.90
Oct. 2, 2026issueSO-261002-604MAIN 2 83.90-167.79221,845.72 July 29, 2026: 2 @ 83.90
Sept. 27, 2026issueSO-260927-567MAIN 4 83.90-335.59242,013.51 July 29, 2026: 4 @ 83.90
Sept. 17, 2026issueSO-260917-156MAIN 4 83.90-335.59282,349.10 July 29, 2026: 4 @ 83.90
Sept. 13, 2026issueSO-260913-897MAIN 8 83.90-671.17322,684.68 July 29, 2026: 8 @ 83.90
Sept. 6, 2026issueSO-260906-491MAIN 7 83.90-587.27403,355.85 July 29, 2026: 7 @ 83.90
Sept. 3, 2026issueSO-260903-808MAIN 1 83.90-83.90473,943.13 July 29, 2026: 1 @ 83.90
Sept. 1, 2026issueSO-260901-484MAIN 1 83.90-83.90484,027.02 July 29, 2026: 1 @ 83.90
Aug. 27, 2026issueSO-260827-642MAIN 3 83.90-251.69494,110.92 July 29, 2026: 3 @ 83.90
Aug. 16, 2026issueSO-260816-155MAIN 6 83.90-503.38524,362.61 July 29, 2026: 6 @ 83.90
Aug. 13, 2026issueSO-260813-572MAIN 1 83.90-83.90584,865.99 July 29, 2026: 1 @ 83.90
Aug. 11, 2026issueSO-260811-928MAIN 7 83.90-587.27594,949.88 July 29, 2026: 7 @ 83.90
Aug. 8, 2026issueSO-260808-657MAIN 5 83.90-419.48665,537.16 July 29, 2026: 5 @ 83.90
Aug. 7, 2026issueSO-260807-724MAIN 1 83.90-83.90715,956.64 July 29, 2026: 1 @ 83.90
July 29, 2026receiptPO-001685MAIN 72 83.906,040.53726,040.53
July 24, 2026issueSO-260724-306EAST 8 83.88-671.0100.00 May 14, 2026: 8 @ 83.88
July 22, 2026issueSO-260722-883EAST 3 83.88-251.638671.01 May 14, 2026: 3 @ 83.88
July 21, 2026issueSO-260721-277EAST 2 83.88-167.7511922.64 May 14, 2026: 2 @ 83.88
July 21, 2026issueSO-260721-277MAIN 7 83.88-587.14131,090.39 May 14, 2026: 7 @ 83.88
July 15, 2026issueSO-260715-107EAST 6 83.88-503.26201,677.53 May 14, 2026: 6 @ 83.88
June 16, 2026issueSO-260616-972MAIN 17 83.88-1,425.90262,180.79 May 14, 2026: 17 @ 83.88
June 15, 2026issueSO-260615-126MAIN 7 83.88-587.14433,606.69 May 14, 2026: 7 @ 83.88
June 14, 2026issueSO-260614-504MAIN 11 83.88-922.64504,193.82 May 14, 2026: 11 @ 83.88
June 10, 2026issueSO-260610-517MAIN 14 84.06-1,176.86615,116.47 April 21, 2026: 3 @ 84.74; May 14, 2026: 11 @ 83.88
June 4, 2026issueSO-260604-485EAST 5 84.74-423.70756,293.33 April 21, 2026: 5 @ 84.74
May 23, 2026issueSO-260523-390MAIN 8 84.74-677.93806,717.04 April 21, 2026: 8 @ 84.74
May 14, 2026transferTRFMAIN → EAST 24 warehouse transfer, no cost effect
May 14, 2026receiptPO-001493MAIN 72 83.886,039.11887,394.96
May 6, 2026issueSO-260506-907MAIN 47 84.74-3,982.83161,355.86 April 21, 2026: 47 @ 84.74
April 29, 2026issueSO-260429-281MAIN 9 84.74-762.67635,338.68 April 21, 2026: 9 @ 84.74
April 22, 2026issueSO-260422-613EAST 8 82.30-658.44726,101.35 Feb. 1, 2026: 4 @ 82.30; Feb. 27, 2026: 4 @ 82.30
April 21, 2026receiptPO-001427MAIN 72 84.746,101.35806,759.79
April 16, 2026issueSO-260416-199EAST 14 82.30-1,152.278658.44 Feb. 1, 2026: 14 @ 82.30
April 16, 2026issueSO-260416-199MAIN 3 82.30-246.91221,810.71 Feb. 1, 2026: 3 @ 82.30
April 13, 2026issueSO-260413-252MAIN 2 82.30-164.61252,057.62 Feb. 1, 2026: 2 @ 82.30
March 16, 2026issueSO-260316-310MAIN 11 82.30-905.35272,222.23 Feb. 1, 2026: 11 @ 82.30
March 13, 2026issueSO-260313-953MAIN 21 82.30-1,728.40383,127.59 Feb. 1, 2026: 21 @ 82.30
Feb. 27, 2026returnRMAMAIN 4 82.30329.22594,855.99
Feb. 21, 2026issueSO-260221-119MAIN 3 82.30-246.91554,526.77 Feb. 1, 2026: 3 @ 82.30
Feb. 12, 2026issueSO-260212-266MAIN 9 82.30-740.74584,773.68 Feb. 1, 2026: 9 @ 82.30
Feb. 7, 2026issueSO-260207-512MAIN 20 80.41-1,608.14675,514.43 Dec. 15, 2025: 15 @ 79.77; Feb. 1, 2026: 5 @ 82.30
Feb. 1, 2026transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
Feb. 1, 2026receiptPO-001192MAIN 72 82.305,925.95877,122.57
Jan. 25, 2026issueSO-260125-632MAIN 12 79.77-957.29151,196.61 Dec. 15, 2025: 12 @ 79.77
Jan. 23, 2026issueSO-260123-569MAIN 2 79.77-159.55272,153.91 Dec. 15, 2025: 2 @ 79.77
Jan. 20, 2026issueSO-260120-263MAIN 8 79.77-638.19292,313.45 Dec. 15, 2025: 8 @ 79.77
Jan. 17, 2026issueSO-260117-855MAIN 8 79.77-638.19372,951.65 Dec. 15, 2025: 8 @ 79.77
Jan. 10, 2026issueSO-260110-452MAIN 1 79.77-79.77453,589.84 Dec. 15, 2025: 1 @ 79.77
Jan. 4, 2026issueSO-260104-900MAIN 26 79.77-2,074.13463,669.62 Dec. 15, 2025: 26 @ 79.77
Dec. 15, 2025receiptPO-001055MAIN 72 79.775,743.75725,743.75
Dec. 7, 2025issueSO-251207-165MAIN 75 81.18-6,088.2800.00 Oct. 1, 2025: 3 @ 82.76; Nov. 29, 2025: 72 @ 81.11
Nov. 29, 2025receiptPO-001025MAIN 72 81.115,839.99756,088.28
Nov. 23, 2025issueSO-251123-188MAIN 36 82.76-2,979.443248.29 Oct. 1, 2025: 36 @ 82.76
Nov. 23, 2025issueSO-251123-188EAST 1 82.76-82.76393,227.73 Oct. 1, 2025: 1 @ 82.76
Nov. 22, 2025issueSO-251122-150EAST 1 82.76-82.76403,310.49 Oct. 1, 2025: 1 @ 82.76
Oct. 26, 2025issueSO-251026-142EAST 9 82.76-744.86413,393.25 Oct. 1, 2025: 9 @ 82.76
Oct. 7, 2025issueSO-251007-130EAST 11 82.76-910.39504,138.12 Oct. 1, 2025: 11 @ 82.76
Oct. 6, 2025issueSO-251006-820MAIN 11 82.76-910.39615,048.50 Oct. 1, 2025: 11 @ 82.76
Oct. 1, 2025transferTRFMAIN → EAST 22 warehouse transfer, no cost effect
Oct. 1, 2025receiptPO-000893MAIN 72 82.765,958.89725,958.89
Sept. 22, 2025issueSO-250922-773EAST 13 81.56-1,060.2400.00 Aug. 7, 2025: 13 @ 81.56
Sept. 22, 2025issueSO-250922-773MAIN 9 81.56-734.01131,060.24 Aug. 7, 2025: 9 @ 81.56
Sept. 16, 2025issueSO-250916-447MAIN 1 81.56-81.56221,794.25 Aug. 7, 2025: 1 @ 81.56
Sept. 9, 2025issueSO-250909-455MAIN 27 81.56-2,202.03231,875.80 Aug. 7, 2025: 27 @ 81.56
Sept. 8, 2025issueSO-250908-617MAIN 4 81.56-326.23504,077.84 Aug. 7, 2025: 4 @ 81.56
Sept. 6, 2025issueSO-250906-198MAIN 10 81.56-815.57544,404.06 Aug. 7, 2025: 10 @ 81.56
Aug. 30, 2025issueSO-250830-953MAIN 7 81.56-570.90645,219.63 Aug. 7, 2025: 7 @ 81.56
Aug. 27, 2025issueSO-250827-411EAST 5 79.32-396.59715,790.53 June 5, 2025: 4 @ 78.76; Aug. 7, 2025: 1 @ 81.56
Aug. 18, 2025issueSO-250818-209EAST 3 78.76-236.28766,187.12 June 5, 2025: 3 @ 78.76
Aug. 14, 2025issueSO-250814-230MAIN 5 78.76-393.80796,423.40 June 5, 2025: 5 @ 78.76
Aug. 12, 2025issueSO-250812-183MAIN 4 78.76-315.04846,817.19 June 5, 2025: 4 @ 78.76
Aug. 7, 2025transferTRFMAIN → EAST 21 warehouse transfer, no cost effect
Aug. 7, 2025receiptPO-000764MAIN 72 81.565,872.08887,132.23
Aug. 2, 2025issueSO-250802-354MAIN 2 78.76-157.52161,260.15 June 5, 2025: 2 @ 78.76
July 31, 2025issueSO-250731-289MAIN 7 78.76-551.31181,417.67 June 5, 2025: 7 @ 78.76
July 19, 2025issueSO-250719-369MAIN 11 78.76-866.35251,968.98 June 5, 2025: 11 @ 78.76
July 13, 2025issueSO-250713-807MAIN 17 78.76-1,338.91362,835.33 June 5, 2025: 17 @ 78.76
July 2, 2025issueSO-250702-700MAIN 1 78.76-78.76534,174.24 June 5, 2025: 1 @ 78.76
June 25, 2025issueSO-250625-744MAIN 2 78.76-157.52544,253.00 June 5, 2025: 2 @ 78.76
June 24, 2025issueSO-250624-210MAIN 2 78.76-157.52564,410.52 June 5, 2025: 2 @ 78.76
June 15, 2025issueSO-250615-675MAIN 2 78.76-157.52584,568.03 June 5, 2025: 2 @ 78.76
June 11, 2025issueSO-250611-646MAIN 11 78.76-866.35604,725.55 June 5, 2025: 11 @ 78.76
June 8, 2025issueSO-250608-431MAIN 1 78.76-78.76715,591.90 June 5, 2025: 1 @ 78.76
June 5, 2025receiptPO-000606MAIN 72 78.765,670.66725,670.66
May 30, 2025issueSO-250530-896EAST 1 78.16-78.1600.00 March 30, 2025: 1 @ 78.16
May 30, 2025issueSO-250530-896MAIN 33 78.16-2,579.16178.16 March 30, 2025: 33 @ 78.16
May 20, 2025issueSO-250520-177MAIN 8 78.16-625.25342,657.32 March 30, 2025: 8 @ 78.16
May 2, 2025issueSO-250502-855MAIN 8 78.16-625.25423,282.57 March 30, 2025: 8 @ 78.16
April 30, 2025issueSO-250430-793MAIN 2 78.16-156.31503,907.82 March 30, 2025: 2 @ 78.16
April 27, 2025issueSO-250427-423MAIN 20 78.16-1,563.13524,064.13 March 30, 2025: 20 @ 78.16
April 26, 2025issueSO-250426-525EAST 3 78.11-234.34725,627.26 Jan. 9, 2025: 1 @ 78.11; March 10, 2025: 2 @ 78.11
April 8, 2025issueSO-250408-172EAST 5 78.11-390.57755,861.60 Jan. 9, 2025: 5 @ 78.11
March 31, 2025issueSO-250331-826MAIN 1 78.11-78.11806,252.18 Jan. 9, 2025: 1 @ 78.11
March 30, 2025receiptPO-000394MAIN 72 78.165,627.26816,330.29
March 23, 2025issueSO-250323-683EAST 17 78.11-1,327.959703.03 Jan. 9, 2025: 17 @ 78.11
March 21, 2025issueSO-250321-699EAST 2 78.11-156.23262,030.98 Jan. 9, 2025: 2 @ 78.11
March 21, 2025issueSO-250321-699MAIN 12 78.11-937.38282,187.21 Jan. 9, 2025: 12 @ 78.11
March 10, 2025returnRMAMAIN 2 78.11156.23403,124.58
March 8, 2025issueSO-250308-897MAIN 8 78.11-624.92382,968.35 Jan. 9, 2025: 8 @ 78.11
Feb. 26, 2025issueSO-250226-757MAIN 4 78.11-312.46463,593.27 Jan. 9, 2025: 4 @ 78.11
Feb. 21, 2025issueSO-250221-286MAIN 3 78.11-234.34503,905.73 Jan. 9, 2025: 3 @ 78.11
Feb. 18, 2025issueSO-250218-577MAIN 9 78.11-703.03534,140.07 Jan. 9, 2025: 9 @ 78.11
Feb. 15, 2025issueSO-250215-220EAST 2 78.11-156.23624,843.11 Jan. 9, 2025: 2 @ 78.11
Feb. 12, 2025issueSO-250212-355MAIN 2 78.11-156.23644,999.33 Jan. 9, 2025: 2 @ 78.11
Feb. 10, 2025issueSO-250210-775MAIN 6 78.11-468.69665,155.56 Jan. 9, 2025: 6 @ 78.11
Jan. 30, 2025issueSO-250130-627MAIN 7 79.06-553.39725,624.25 Nov. 30, 2024: 7 @ 79.06
Jan. 21, 2025issueSO-250121-924MAIN 2 79.06-158.11796,177.64 Nov. 30, 2024: 2 @ 79.06
Jan. 12, 2025issueSO-250112-505EAST 3 79.06-237.17816,335.75 Nov. 30, 2024: 3 @ 79.06
Jan. 9, 2025transferTRFMAIN → EAST 25 warehouse transfer, no cost effect
Jan. 9, 2025receiptPO-000178MAIN 72 78.115,624.25846,572.91
Jan. 2, 2025issueSO-250102-912MAIN 22 79.06-1,739.2212948.66 Nov. 30, 2024: 22 @ 79.06
Dec. 26, 2024issueSO-241226-497MAIN 1 79.06-79.06342,687.88 Nov. 30, 2024: 1 @ 79.06
Dec. 24, 2024issueSO-241224-725EAST 15 79.06-1,185.83352,766.94 Nov. 30, 2024: 15 @ 79.06
Dec. 8, 2024issueSO-241208-320MAIN 11 79.06-869.61503,952.76 Nov. 30, 2024: 11 @ 79.06
Dec. 7, 2024issueSO-241207-669MAIN 8 79.06-632.44614,822.37 Nov. 30, 2024: 8 @ 79.06
Nov. 30, 2024issueSO-241130-499MAIN 3 79.06-237.17695,454.82 Nov. 30, 2024: 3 @ 79.06
Nov. 30, 2024transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Nov. 30, 2024receiptPO-000068MAIN 72 79.065,691.98725,691.98
Nov. 26, 2024issueSO-241126-951MAIN 12 80.70-968.4300.00 Oct. 1, 2024: 8 @ 80.70; Nov. 20, 2024: 4 @ 80.70
Nov. 22, 2024issueSO-241122-694MAIN 30 80.70-2,421.0812968.43 Oct. 1, 2024: 30 @ 80.70
Nov. 20, 2024returnRMAMAIN 4 80.70322.81423,389.50
Nov. 18, 2024issueSO-241118-379MAIN 5 80.70-403.51383,066.70 Oct. 1, 2024: 5 @ 80.70
Nov. 14, 2024issueSO-241114-300MAIN 4 80.70-322.81433,470.21 Oct. 1, 2024: 4 @ 80.70
Nov. 7, 2024issueSO-241107-875MAIN 6 80.70-484.22473,793.02 Oct. 1, 2024: 6 @ 80.70
Nov. 1, 2024issueSO-241101-366MAIN 9 80.70-726.32534,277.23 Oct. 1, 2024: 9 @ 80.70
Oct. 17, 2024issueSO-241017-963MAIN 2 80.70-161.40625,003.56 Oct. 1, 2024: 2 @ 80.70
Oct. 15, 2024issueSO-241015-947MAIN 1 80.70-80.70645,164.96 Oct. 1, 2024: 1 @ 80.70
Oct. 13, 2024issueSO-241013-326MAIN 1 80.70-80.70655,245.66 Oct. 1, 2024: 1 @ 80.70
Oct. 9, 2024issueSO-241009-569MAIN 9 80.70-726.32665,326.36 Oct. 1, 2024: 9 @ 80.70
Oct. 2, 2024issueSO-241002-245MAIN 5 80.70-403.51756,052.69 Oct. 1, 2024: 5 @ 80.70
Oct. 1, 2024receiptPO-000005MAIN 80 80.706,456.20806,456.20