stocksense

Items / MCB-0015

Surge Protector Elite MCB-0015 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)97MAIN 97
Value (FIFO)1,827.01avg 18.84
ClassCX / FCV 0.40
Turnover9.5xlast issue 14 days ago
Days of cover76lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00150.028.957.886.6116Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 82.0Nov 24: 52.0Dec 24: 24.0Jan 25: 24.0Feb 25: 41.0Mar 25: 79.0Apr 25: 92.0May 25: 43.0Jun 25: 62.0Jul 25: 105.0Aug 25: 19.0Sep 25: 39.0Oct 25: 43.0Nov 25: 30.0Dec 25: 29.0Jan 26: 33.0Feb 26: 27.0Mar 26: 57.0Apr 26: 36.0May 26: 28.0Jun 26: 35.0Jul 26: 81.0Aug 26: 43.0Sep 26: 22.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.437538.67 / 30.43751.270
Daily demand sdmonthly sd / sqrt(30.4375)15.58 / 5.5172.825
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 * 2.825^2 + 1.270^2 * 1.5^2)9.9
Reorder pointd * LT + safety stock1.270 * 7.0 + 9.918.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days18.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 464/yr, S = 45.00, h = 20%, price = 18.78105.4
Inventory positionon hand + on order97 + 097

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

From qtyUnit costOrder qtyAnnual costFeasible
018.781059,104yes (chosen if cheapest)

MOQ 54, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 11, 202697 / 9718.841,827.01

Movement ledger 129 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 11, 2026receiptPO-001870MAIN 97 18.841,827.01971,827.01
Oct. 2, 2026issueSO-261002-235MAIN 28 19.17-536.6700.00 Aug. 6, 2026: 28 @ 19.17
Oct. 1, 2026issueSO-261001-357MAIN 21 19.17-402.5028536.67 Aug. 6, 2026: 21 @ 19.17
Sept. 28, 2026issueSO-260928-365MAIN 3 19.17-57.5049939.17 Aug. 6, 2026: 3 @ 19.17
Sept. 25, 2026issueSO-260925-964MAIN 7 19.17-134.1752996.67 Aug. 6, 2026: 7 @ 19.17
Sept. 23, 2026issueSO-260923-381MAIN 3 19.17-57.50591,130.84 Aug. 6, 2026: 3 @ 19.17
Sept. 22, 2026issueSO-260922-255MAIN 3 19.17-57.50621,188.34 Aug. 6, 2026: 3 @ 19.17
Sept. 11, 2026issueSO-260911-674MAIN 2 19.17-38.33651,245.84 Aug. 6, 2026: 2 @ 19.17
Sept. 4, 2026issueSO-260904-340MAIN 1 19.17-19.17671,284.18 Aug. 6, 2026: 1 @ 19.17
Sept. 2, 2026issueSO-260902-929MAIN 3 19.17-57.50681,303.34 Aug. 6, 2026: 3 @ 19.17
Aug. 31, 2026issueSO-260831-405MAIN 10 19.17-191.67711,360.84 Aug. 6, 2026: 10 @ 19.17
Aug. 15, 2026issueSO-260815-526MAIN 33 18.83-621.50811,552.51 July 1, 2026: 17 @ 18.52; Aug. 6, 2026: 16 @ 19.17
Aug. 6, 2026receiptPO-001701MAIN 97 19.171,859.181142,174.01
July 31, 2026issueSO-260731-919MAIN 11 18.52-203.7117314.83 July 1, 2026: 11 @ 18.52
July 29, 2026issueSO-260729-480MAIN 8 18.52-148.1528518.54 July 1, 2026: 8 @ 18.52
July 24, 2026issueSO-260724-953MAIN 40 18.52-740.7736666.69 July 1, 2026: 40 @ 18.52
July 20, 2026issueSO-260720-692MAIN 1 18.52-18.52761,407.47 July 1, 2026: 1 @ 18.52
July 11, 2026issueSO-260711-237MAIN 18 18.52-333.35771,425.99 July 1, 2026: 18 @ 18.52
July 5, 2026issueSO-260705-221MAIN 2 18.52-37.04951,759.33 July 1, 2026: 2 @ 18.52
July 4, 2026issueSO-260704-355MAIN 1 18.33-18.33971,796.37 March 24, 2026: 1 @ 18.33
July 1, 2026receiptPO-001617MAIN 97 18.521,796.37981,814.70
June 26, 2026issueSO-260626-660MAIN 7 18.33-128.29118.33 March 24, 2026: 7 @ 18.33
June 22, 2026issueSO-260622-109MAIN 28 18.33-513.178146.62 March 24, 2026: 28 @ 18.33
May 23, 2026issueSO-260523-801MAIN 4 18.33-73.3136659.79 March 24, 2026: 4 @ 18.33
May 21, 2026issueSO-260521-165MAIN 1 18.33-18.3340733.10 March 24, 2026: 1 @ 18.33
May 18, 2026issueSO-260518-370MAIN 19 18.33-348.2241751.43 March 24, 2026: 19 @ 18.33
May 12, 2026issueSO-260512-552MAIN 3 18.33-54.98601,099.66 March 24, 2026: 3 @ 18.33
May 11, 2026issueSO-260511-162MAIN 1 18.33-18.33631,154.64 March 24, 2026: 1 @ 18.33
April 22, 2026issueSO-260422-818MAIN 14 18.33-256.59641,172.97 March 24, 2026: 14 @ 18.33
April 18, 2026issueSO-260418-131MAIN 1 18.33-18.33781,429.55 March 24, 2026: 1 @ 18.33
April 14, 2026issueSO-260414-160MAIN 1 18.33-18.33791,447.88 March 24, 2026: 1 @ 18.33
April 12, 2026issueSO-260412-533MAIN 19 18.26-346.88801,466.21 Jan. 7, 2026: 2 @ 17.66; March 24, 2026: 17 @ 18.33
April 6, 2026issueSO-260406-617MAIN 1 17.66-17.66991,813.09 Jan. 7, 2026: 1 @ 17.66
March 30, 2026issueSO-260330-734MAIN 13 17.66-229.551001,830.75 Jan. 7, 2026: 13 @ 17.66
March 24, 2026receiptPO-001348MAIN 97 18.331,777.781132,060.30
March 23, 2026issueSO-260323-369MAIN 3 17.66-52.9716282.52 Jan. 7, 2026: 3 @ 17.66
March 16, 2026issueSO-260316-533MAIN 12 17.66-211.8919335.49 Jan. 7, 2026: 12 @ 17.66
March 10, 2026issueSO-260310-176MAIN 4 17.66-70.6331547.38 Jan. 7, 2026: 4 @ 17.66
March 4, 2026issueSO-260304-496MAIN 18 17.66-317.8435618.01 Jan. 7, 2026: 18 @ 17.66
March 3, 2026issueSO-260303-759MAIN 7 17.66-123.6053935.85 Jan. 7, 2026: 7 @ 17.66
Feb. 16, 2026issueSO-260216-256MAIN 1 17.66-17.66601,059.45 Jan. 7, 2026: 1 @ 17.66
Feb. 14, 2026issueSO-260214-320MAIN 6 17.66-105.94611,077.11 Jan. 7, 2026: 6 @ 17.66
Feb. 13, 2026issueSO-260213-775MAIN 2 17.66-35.32671,183.05 Jan. 7, 2026: 2 @ 17.66
Feb. 11, 2026issueSO-260211-623MAIN 2 17.66-35.32691,218.37 Jan. 7, 2026: 2 @ 17.66
Feb. 9, 2026issueSO-260209-484MAIN 4 17.66-70.63711,253.68 Jan. 7, 2026: 4 @ 17.66
Feb. 8, 2026issueSO-260208-482MAIN 12 17.66-211.89751,324.31 Jan. 7, 2026: 12 @ 17.66
Jan. 12, 2026issueSO-260112-175MAIN 10 17.66-176.58871,536.20 Jan. 7, 2026: 10 @ 17.66
Jan. 7, 2026receiptPO-001127MAIN 97 17.661,712.78971,712.78
Jan. 6, 2026issueSO-260106-831MAIN 21 17.51-367.7000.00 Oct. 23, 2025: 21 @ 17.51
Jan. 6, 2026issueSO-260106-831EAST 2 17.51-35.0221367.70 Oct. 23, 2025: 2 @ 17.51
Dec. 30, 2025issueSO-251230-994MAIN 8 17.51-140.0723402.71 Oct. 23, 2025: 8 @ 17.51
Dec. 27, 2025issueSO-251227-448MAIN 6 17.51-105.0631542.79 Oct. 23, 2025: 6 @ 17.51
Dec. 26, 2025issueSO-251226-590EAST 8 17.51-140.0737647.84 Oct. 23, 2025: 8 @ 17.51
Dec. 20, 2025issueSO-251220-695MAIN 1 17.51-17.5145787.92 Oct. 23, 2025: 1 @ 17.51
Dec. 16, 2025issueSO-251216-457EAST 1 17.51-17.5146805.43 Oct. 23, 2025: 1 @ 17.51
Dec. 13, 2025issueSO-251213-966EAST 4 17.51-70.0447822.94 Oct. 23, 2025: 4 @ 17.51
Dec. 9, 2025issueSO-251209-629MAIN 1 17.51-17.5151892.97 Oct. 23, 2025: 1 @ 17.51
Nov. 14, 2025issueSO-251114-795EAST 1 17.51-17.5152910.48 Oct. 23, 2025: 1 @ 17.51
Nov. 13, 2025issueSO-251113-980MAIN 2 17.51-35.0253927.99 Oct. 23, 2025: 2 @ 17.51
Nov. 12, 2025issueSO-251112-638EAST 18 17.51-315.1755963.01 Oct. 23, 2025: 18 @ 17.51
Nov. 1, 2025issueSO-251101-289MAIN 9 17.51-157.58731,278.18 Oct. 23, 2025: 9 @ 17.51
Oct. 31, 2025issueSO-251031-627MAIN 4 17.51-70.04821,435.76 Oct. 23, 2025: 4 @ 17.51
Oct. 23, 2025issueSO-251023-118MAIN 13 17.53-227.94861,505.80 July 19, 2025: 2 @ 17.67; Oct. 23, 2025: 11 @ 17.51
Oct. 23, 2025transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
Oct. 23, 2025receiptPO-000944MAIN 97 17.511,698.40991,733.74
Oct. 13, 2025issueSO-251013-333MAIN 26 17.67-459.34235.33 July 19, 2025: 26 @ 17.67
Sept. 26, 2025issueSO-250926-467MAIN 14 17.67-247.3428494.67 July 19, 2025: 14 @ 17.67
Sept. 9, 2025issueSO-250909-888MAIN 2 17.67-35.3342742.01 July 19, 2025: 2 @ 17.67
Sept. 9, 2025issueSO-250909-888EAST 23 17.67-406.3444777.34 July 19, 2025: 23 @ 17.67
Aug. 31, 2025issueSO-250831-376MAIN 1 17.67-17.67671,183.68 July 19, 2025: 1 @ 17.67
Aug. 26, 2025issueSO-250826-350MAIN 1 17.67-17.67681,201.34 July 19, 2025: 1 @ 17.67
Aug. 22, 2025issueSO-250822-367EAST 1 17.67-17.67691,219.01 July 19, 2025: 1 @ 17.67
Aug. 19, 2025issueSO-250819-828MAIN 10 17.67-176.67701,236.68 July 19, 2025: 10 @ 17.67
Aug. 11, 2025issueSO-250811-398MAIN 5 17.67-88.33801,413.34 July 19, 2025: 5 @ 17.67
Aug. 1, 2025issueSO-250801-303MAIN 1 17.67-17.67851,501.68 July 19, 2025: 1 @ 17.67
July 30, 2025issueSO-250730-400MAIN 11 17.67-194.33861,519.34 July 19, 2025: 11 @ 17.67
July 19, 2025transferTRFMAIN → EAST 24 warehouse transfer, no cost effect
July 19, 2025receiptPO-000725MAIN 97 17.671,713.68971,713.68
July 14, 2025issueSO-250714-159EAST 14 17.87-250.1800.00 June 20, 2025: 11 @ 17.88; July 2, 2025: 3 @ 17.83
July 14, 2025issueSO-250714-159MAIN 1 17.88-17.8814250.18 June 20, 2025: 1 @ 17.88
July 13, 2025issueSO-250713-752MAIN 82 17.88-1,466.2015268.06 June 20, 2025: 82 @ 17.88
July 2, 2025returnRMAMAIN 3 17.8353.49971,734.26
June 30, 2025issueSO-250630-249EAST 11 17.83-196.14941,680.77 April 26, 2025: 8 @ 17.81; June 20, 2025: 3 @ 17.88
June 29, 2025issueSO-250629-648MAIN 4 17.81-71.251051,876.91 April 26, 2025: 4 @ 17.81
June 23, 2025issueSO-250623-878MAIN 10 17.81-178.121091,948.16 April 26, 2025: 10 @ 17.81
June 20, 2025issueSO-250620-428MAIN 3 17.81-53.441192,126.28 April 26, 2025: 3 @ 17.81
June 20, 2025receiptPO-000654MAIN 97 17.881,734.411222,179.72
June 12, 2025issueSO-250612-191EAST 6 17.81-106.8825445.31 April 26, 2025: 6 @ 17.81
June 12, 2025issueSO-250612-191MAIN 11 17.81-195.9431552.19 April 26, 2025: 11 @ 17.81
June 3, 2025issueSO-250603-700MAIN 16 17.81-285.0042748.12 April 26, 2025: 16 @ 17.81
June 2, 2025issueSO-250602-642MAIN 1 17.81-17.81581,033.12 April 26, 2025: 1 @ 17.81
May 24, 2025issueSO-250524-603MAIN 25 17.81-445.31591,050.94 April 26, 2025: 25 @ 17.81
May 8, 2025issueSO-250508-142MAIN 17 17.88-303.98841,496.25 March 26, 2025: 4 @ 18.10; April 26, 2025: 13 @ 17.81
May 3, 2025issueSO-250503-126MAIN 1 18.10-18.101011,800.23 March 26, 2025: 1 @ 18.10
April 26, 2025transferTRFMAIN → EAST 31 warehouse transfer, no cost effect
April 26, 2025receiptPO-000485MAIN 97 17.811,727.811021,818.34
April 22, 2025issueSO-250422-331MAIN 53 18.10-959.55590.52 March 26, 2025: 53 @ 18.10
April 16, 2025issueSO-250416-325MAIN 22 18.10-398.30581,050.07 March 26, 2025: 22 @ 18.10
April 9, 2025issueSO-250409-749MAIN 16 18.10-289.68801,448.38 March 26, 2025: 16 @ 18.10
April 7, 2025issueSO-250407-878MAIN 1 18.10-18.10961,738.05 March 26, 2025: 1 @ 18.10
March 26, 2025receiptPO-000385MAIN 97 18.101,756.16971,756.16
March 18, 2025issueSO-250318-219MAIN 36 17.06-614.0700.00 Feb. 8, 2025: 36 @ 17.06
March 15, 2025issueSO-250315-502MAIN 8 17.06-136.4636614.07 Feb. 8, 2025: 8 @ 17.06
March 11, 2025issueSO-250311-115MAIN 8 17.06-136.4644750.53 Feb. 8, 2025: 8 @ 17.06
March 9, 2025issueSO-250309-116MAIN 27 17.06-460.5652887.00 Feb. 8, 2025: 27 @ 17.06
Feb. 27, 2025issueSO-250227-936MAIN 5 17.06-85.29791,347.55 Feb. 8, 2025: 5 @ 17.06
Feb. 23, 2025issueSO-250223-605MAIN 3 17.06-51.17841,432.84 Feb. 8, 2025: 3 @ 17.06
Feb. 21, 2025issueSO-250221-965MAIN 10 17.06-170.58871,484.01 Feb. 8, 2025: 10 @ 17.06
Feb. 8, 2025receiptPO-000248MAIN 97 17.061,654.59971,654.59
Feb. 6, 2025issueSO-250206-288MAIN 23 16.86-387.7900.00 Nov. 10, 2024: 23 @ 16.86
Jan. 31, 2025issueSO-250131-754MAIN 10 16.86-168.6123387.79 Nov. 10, 2024: 10 @ 16.86
Jan. 27, 2025issueSO-250127-834MAIN 2 16.86-33.7233556.40 Nov. 10, 2024: 2 @ 16.86
Jan. 16, 2025issueSO-250116-415MAIN 5 16.86-84.3035590.12 Nov. 10, 2024: 5 @ 16.86
Jan. 14, 2025issueSO-250114-687MAIN 3 16.86-50.5840674.42 Nov. 10, 2024: 3 @ 16.86
Jan. 9, 2025issueSO-250109-595MAIN 4 16.86-67.4443725.01 Nov. 10, 2024: 4 @ 16.86
Dec. 30, 2024issueSO-241230-122MAIN 9 16.86-151.7547792.45 Nov. 10, 2024: 9 @ 16.86
Dec. 28, 2024issueSO-241228-833MAIN 1 16.86-16.8656944.19 Nov. 10, 2024: 1 @ 16.86
Dec. 12, 2024issueSO-241212-336MAIN 4 16.86-67.4457961.05 Nov. 10, 2024: 4 @ 16.86
Dec. 6, 2024issueSO-241206-448MAIN 10 16.86-168.61611,028.50 Nov. 10, 2024: 10 @ 16.86
Nov. 27, 2024issueSO-241127-514MAIN 4 16.86-67.44711,197.10 Nov. 10, 2024: 4 @ 16.86
Nov. 16, 2024issueSO-241116-751MAIN 38 17.27-656.39751,264.54 Oct. 1, 2024: 16 @ 17.84; Nov. 10, 2024: 22 @ 16.86
Nov. 14, 2024issueSO-241114-703MAIN 5 17.84-89.201131,920.93 Oct. 1, 2024: 5 @ 17.84
Nov. 11, 2024issueSO-241111-648MAIN 4 17.84-71.361182,010.14 Oct. 1, 2024: 4 @ 17.84
Nov. 10, 2024receiptPO-000029MAIN 97 16.861,635.481222,081.50
Nov. 6, 2024issueSO-241106-194MAIN 1 17.84-17.8425446.02 Oct. 1, 2024: 1 @ 17.84
Oct. 19, 2024issueSO-241019-455MAIN 19 17.84-338.9826463.87 Oct. 1, 2024: 19 @ 17.84
Oct. 12, 2024issueSO-241012-999MAIN 3 17.84-53.5245802.84 Oct. 1, 2024: 3 @ 17.84
Oct. 3, 2024issueSO-241003-440MAIN 60 17.84-1,070.4648856.37 Oct. 1, 2024: 60 @ 17.84
Oct. 1, 2024receiptPO-000005MAIN 108 17.841,926.831081,926.83