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, latest 60 shown - show all

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