stocksense

Items / MCB-0028

RCCB 40A Classic MCB-0028 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)124MAIN 124
Value (FIFO)3,900.64avg 31.46
ClassBX / FCV 0.27
Turnover5.6xlast issue 2 days ago
Days of cover73lead time 7d

Demand and forecast

Monthly demand and forecast for MCB-00280.026.753.480.0107Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 43.0Nov 24: 49.0Dec 24: 33.0Jan 25: 53.0Feb 25: 59.0Mar 25: 77.0Apr 25: 50.0May 25: 70.0Jun 25: 47.0Jul 25: 97.0Aug 25: 51.0Sep 25: 58.0Oct 25: 67.0Nov 25: 50.0Dec 25: 47.0Jan 26: 66.0Feb 26: 26.0Mar 26: 76.0Apr 26: 63.0May 26: 51.0Jun 26: 56.0Jul 26: 44.0Aug 26: 36.0Sep 26: 40.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.437551.83 / 30.43751.703
Daily demand sdmonthly sd / sqrt(30.4375)13.86 / 5.5172.511
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(7.0 * 2.511^2 + 1.703^2 * 1.5^2)11.7
Reorder pointd * LT + safety stock1.703 * 7.0 + 11.723.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days23.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 622/yr, S = 45.00, h = 20%, price = 31.5494.2
Inventory positionon hand + on order124 + 0124

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

From qtyUnit costOrder qtyAnnual costFeasible
031.549420,198yes (chosen if cheapest)

MOQ 63, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 13, 202611 / 1230.87339.59
Oct. 14, 2026113 / 11331.513,561.06

Movement ledger 123 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-916MAIN 1 30.87-30.871243,900.64 Oct. 13, 2026: 1 @ 30.87
Oct. 14, 2026receiptPO-001879MAIN 113 31.513,561.061253,931.52
Oct. 13, 2026returnRMAMAIN 12 30.87370.4612370.46
Oct. 5, 2026issueSO-261005-779MAIN 35 30.87-1,080.5000.00 Aug. 2, 2026: 35 @ 30.87
Oct. 1, 2026issueSO-261001-510MAIN 25 30.87-771.78351,080.50 Aug. 2, 2026: 25 @ 30.87
Sept. 28, 2026issueSO-260928-982MAIN 3 30.87-92.61601,852.28 Aug. 2, 2026: 3 @ 30.87
Sept. 20, 2026issueSO-260920-212MAIN 21 30.87-648.30631,944.90 Aug. 2, 2026: 21 @ 30.87
Sept. 14, 2026issueSO-260914-294MAIN 3 30.87-92.61842,593.20 Aug. 2, 2026: 3 @ 30.87
Sept. 5, 2026issueSO-260905-209MAIN 11 30.87-339.59872,685.81 Aug. 2, 2026: 11 @ 30.87
Sept. 1, 2026issueSO-260901-128MAIN 2 30.87-61.74983,025.40 Aug. 2, 2026: 2 @ 30.87
Aug. 17, 2026issueSO-260817-421MAIN 22 30.84-678.571003,087.14 May 20, 2026: 9 @ 30.81; Aug. 2, 2026: 13 @ 30.87
Aug. 17, 2026issueSO-260817-421EAST 4 30.81-123.221223,765.71 May 20, 2026: 4 @ 30.81
Aug. 2, 2026receiptPO-001693MAIN 113 30.873,488.471263,888.93
Aug. 1, 2026issueSO-260801-129MAIN 10 30.81-308.0513400.47 May 20, 2026: 10 @ 30.81
July 27, 2026issueSO-260727-708MAIN 6 30.81-184.8323708.52 May 20, 2026: 6 @ 30.81
July 26, 2026issueSO-260726-350MAIN 15 30.81-462.0829893.35 May 20, 2026: 15 @ 30.81
July 24, 2026issueSO-260724-834MAIN 4 30.81-123.22441,355.42 May 20, 2026: 4 @ 30.81
July 19, 2026issueSO-260719-280MAIN 4 30.81-123.22481,478.64 May 20, 2026: 4 @ 30.81
July 18, 2026issueSO-260718-122EAST 1 30.81-30.81521,601.87 May 20, 2026: 1 @ 30.81
July 5, 2026issueSO-260705-934MAIN 14 30.81-431.27531,632.67 May 20, 2026: 14 @ 30.81
June 30, 2026issueSO-260630-779MAIN 21 30.81-646.91672,063.94 May 20, 2026: 21 @ 30.81
June 29, 2026issueSO-260629-858EAST 19 30.81-585.30882,710.85 May 20, 2026: 19 @ 30.81
June 24, 2026issueSO-260624-575MAIN 16 30.73-491.731073,296.15 March 23, 2026: 10 @ 30.69; May 20, 2026: 6 @ 30.81
May 20, 2026transferTRFMAIN → EAST 24 warehouse transfer, no cost effect
May 20, 2026receiptPO-001513MAIN 113 30.813,480.981233,787.88
May 19, 2026issueSO-260519-351MAIN 1 30.69-30.6910306.90 March 23, 2026: 1 @ 30.69
May 15, 2026issueSO-260515-308MAIN 50 30.69-1,534.5011337.59 March 23, 2026: 50 @ 30.69
April 25, 2026issueSO-260425-930MAIN 26 30.69-797.94611,872.08 March 23, 2026: 26 @ 30.69
April 20, 2026issueSO-260420-309MAIN 15 30.69-460.35872,670.02 March 23, 2026: 15 @ 30.69
April 18, 2026issueSO-260418-756MAIN 15 30.89-463.311023,130.37 Feb. 5, 2026: 4 @ 31.43; March 23, 2026: 11 @ 30.69
April 1, 2026issueSO-260401-437MAIN 7 31.43-220.021173,593.68 Feb. 5, 2026: 7 @ 31.43
March 26, 2026issueSO-260326-669MAIN 3 31.43-94.291243,813.70 Feb. 5, 2026: 3 @ 31.43
March 23, 2026receiptPO-001345MAIN 113 30.693,467.961273,907.99
March 16, 2026issueSO-260316-122MAIN 5 31.43-157.1614440.04 Feb. 5, 2026: 5 @ 31.43
March 16, 2026issueSO-260316-122EAST 29 31.43-911.5019597.19 Feb. 5, 2026: 29 @ 31.43
March 6, 2026issueSO-260306-403MAIN 39 31.43-1,225.81481,508.69 Feb. 5, 2026: 39 @ 31.43
Feb. 26, 2026issueSO-260226-824EAST 4 31.43-125.72872,734.51 Feb. 5, 2026: 4 @ 31.43
Feb. 25, 2026issueSO-260225-486MAIN 1 31.43-31.43912,860.23 Feb. 5, 2026: 1 @ 31.43
Feb. 22, 2026issueSO-260222-241MAIN 18 31.43-565.76922,891.66 Feb. 5, 2026: 18 @ 31.43
Feb. 13, 2026issueSO-260213-788MAIN 2 31.43-62.861103,457.42 Feb. 5, 2026: 2 @ 31.43
Feb. 5, 2026issueSO-260205-464MAIN 1 31.43-31.431123,520.28 Feb. 5, 2026: 1 @ 31.43
Feb. 5, 2026transferTRFMAIN → EAST 33 warehouse transfer, no cost effect
Feb. 5, 2026receiptPO-001199MAIN 113 31.433,551.711133,551.71
Jan. 29, 2026issueSO-260129-471MAIN 60 30.15-1,809.0700.00 Nov. 26, 2025: 60 @ 30.15
Jan. 26, 2026issueSO-260126-554MAIN 6 30.15-180.91601,809.07 Nov. 26, 2025: 6 @ 30.15
Dec. 29, 2025issueSO-251229-824MAIN 1 30.15-30.15661,989.97 Nov. 26, 2025: 1 @ 30.15
Dec. 14, 2025issueSO-251214-922MAIN 17 30.15-512.57672,020.12 Nov. 26, 2025: 17 @ 30.15
Dec. 9, 2025issueSO-251209-490MAIN 3 30.15-90.45842,532.69 Nov. 26, 2025: 3 @ 30.15
Dec. 7, 2025issueSO-251207-805MAIN 13 30.15-391.96872,623.15 Nov. 26, 2025: 13 @ 30.15
Dec. 6, 2025issueSO-251206-579MAIN 1 30.15-30.151003,015.11 Nov. 26, 2025: 1 @ 30.15
Dec. 5, 2025issueSO-251205-785MAIN 6 30.15-180.911013,045.26 Nov. 26, 2025: 6 @ 30.15
Dec. 1, 2025issueSO-251201-236MAIN 6 30.15-180.911073,226.17 Nov. 26, 2025: 6 @ 30.15
Nov. 26, 2025receiptPO-001020MAIN 113 30.153,407.071133,407.07
Nov. 20, 2025issueSO-251120-278MAIN 43 30.98-1,332.2600.00 Sept. 23, 2025: 43 @ 30.98
Nov. 12, 2025issueSO-251112-741MAIN 1 30.98-30.98431,332.26 Sept. 23, 2025: 1 @ 30.98
Nov. 10, 2025issueSO-251110-873MAIN 6 30.98-185.90441,363.24 Sept. 23, 2025: 6 @ 30.98
Oct. 30, 2025issueSO-251030-186MAIN 30 30.98-929.48501,549.14 Sept. 23, 2025: 30 @ 30.98
Oct. 30, 2025issueSO-251030-186EAST 23 30.98-712.60802,478.62 Sept. 23, 2025: 23 @ 30.98
Oct. 28, 2025issueSO-251028-117MAIN 12 30.73-368.701033,191.22 July 27, 2025: 2 @ 29.44; Sept. 23, 2025: 10 @ 30.98
Oct. 14, 2025issueSO-251014-821MAIN 2 29.44-58.881153,559.92 July 27, 2025: 2 @ 29.44
Sept. 23, 2025transferTRFMAIN → EAST 23 warehouse transfer, no cost effect
Sept. 23, 2025receiptPO-000867MAIN 113 30.983,501.051173,618.80
Sept. 16, 2025issueSO-250916-863MAIN 27 29.44-794.854117.76 July 27, 2025: 27 @ 29.44
Sept. 4, 2025issueSO-250904-954MAIN 31 29.44-912.6131912.61 July 27, 2025: 31 @ 29.44
Aug. 29, 2025issueSO-250829-900MAIN 1 29.44-29.44621,825.22 July 27, 2025: 1 @ 29.44
Aug. 24, 2025issueSO-250824-837MAIN 8 29.44-235.51631,854.66 July 27, 2025: 8 @ 29.44
Aug. 20, 2025issueSO-250820-916MAIN 1 29.44-29.44712,090.17 July 27, 2025: 1 @ 29.44
Aug. 4, 2025issueSO-250804-927MAIN 35 29.44-1,030.36722,119.61 July 27, 2025: 35 @ 29.44
Aug. 2, 2025issueSO-250802-850MAIN 6 29.44-176.631073,149.97 July 27, 2025: 6 @ 29.44
July 27, 2025receiptPO-000740MAIN 113 29.443,326.611133,326.61
July 21, 2025issueSO-250721-816MAIN 37 29.00-1,072.8800.00 June 20, 2025: 37 @ 29.00
July 6, 2025issueSO-250706-721MAIN 16 29.00-463.95371,072.88 June 20, 2025: 16 @ 29.00
July 4, 2025issueSO-250704-437MAIN 2 29.00-57.99531,536.83 June 20, 2025: 2 @ 29.00
July 3, 2025issueSO-250703-318MAIN 42 29.00-1,217.86551,594.82 June 20, 2025: 42 @ 29.00
June 29, 2025issueSO-250629-439MAIN 25 29.50-737.50972,812.68 April 15, 2025: 9 @ 30.39; June 20, 2025: 16 @ 29.00
June 29, 2025issueSO-250629-439EAST 3 30.39-91.181223,550.17 April 15, 2025: 3 @ 30.39
June 20, 2025receiptPO-000654MAIN 113 29.003,276.631253,641.36
June 16, 2025issueSO-250616-229MAIN 3 30.39-91.1812364.73 April 15, 2025: 3 @ 30.39
June 12, 2025issueSO-250612-848EAST 15 30.39-455.9115455.91 April 15, 2025: 15 @ 30.39
June 10, 2025issueSO-250610-120MAIN 1 30.39-30.3930911.83 April 15, 2025: 1 @ 30.39
May 11, 2025issueSO-250511-616EAST 15 30.39-455.9131942.22 April 15, 2025: 15 @ 30.39
May 5, 2025issueSO-250505-284EAST 6 30.39-182.37461,398.13 April 15, 2025: 6 @ 30.39
May 1, 2025issueSO-250501-477MAIN 49 30.39-1,489.32521,580.50 April 15, 2025: 49 @ 30.39
April 29, 2025issueSO-250429-272MAIN 1 30.39-30.391013,069.81 April 15, 2025: 1 @ 30.39
April 25, 2025issueSO-250425-623MAIN 4 30.39-121.581023,100.21 April 15, 2025: 4 @ 30.39
April 20, 2025issueSO-250420-228MAIN 28 29.21-817.911063,221.79 March 3, 2025: 21 @ 28.82; April 15, 2025: 7 @ 30.39
April 15, 2025transferTRFMAIN → EAST 39 warehouse transfer, no cost effect
April 15, 2025receiptPO-000450MAIN 113 30.393,434.541344,039.70
April 14, 2025issueSO-250414-150MAIN 6 28.82-172.9021605.15 March 3, 2025: 6 @ 28.82
April 12, 2025issueSO-250412-203MAIN 1 28.82-28.8227778.05 March 3, 2025: 1 @ 28.82
April 11, 2025issueSO-250411-457MAIN 10 28.82-288.1728806.87 March 3, 2025: 10 @ 28.82
March 15, 2025issueSO-250315-253MAIN 69 28.82-1,988.35381,095.03 March 3, 2025: 69 @ 28.82
March 7, 2025issueSO-250307-160MAIN 8 29.10-232.831073,083.39 Dec. 14, 2024: 2 @ 29.96; March 3, 2025: 6 @ 28.82
March 3, 2025receiptPO-000308MAIN 113 28.823,256.291153,316.21
Feb. 28, 2025issueSO-250228-706MAIN 10 29.96-299.63259.93 Dec. 14, 2024: 10 @ 29.96
Feb. 24, 2025issueSO-250224-533MAIN 8 29.21-233.6612359.56 Dec. 13, 2024: 8 @ 29.21
Feb. 24, 2025issueSO-250224-533EAST 16 29.21-467.3120593.21 Dec. 13, 2024: 16 @ 29.21
Feb. 23, 2025issueSO-250223-906EAST 2 29.21-58.41361,060.52 Dec. 13, 2024: 2 @ 29.21
Feb. 16, 2025issueSO-250216-390MAIN 6 29.21-175.24381,118.94 Dec. 13, 2024: 6 @ 29.21
Feb. 15, 2025issueSO-250215-480MAIN 12 29.21-350.48441,294.18 Dec. 13, 2024: 12 @ 29.21
Feb. 9, 2025issueSO-250209-118MAIN 1 29.21-29.21561,644.66 Dec. 13, 2024: 1 @ 29.21
Feb. 1, 2025issueSO-250201-892MAIN 4 29.21-116.83571,673.87 Dec. 13, 2024: 4 @ 29.21
Jan. 31, 2025issueSO-250131-369MAIN 29 29.21-847.00611,790.70 Dec. 13, 2024: 29 @ 29.21
Jan. 17, 2025issueSO-250117-742MAIN 10 29.21-292.07902,637.70 Dec. 13, 2024: 10 @ 29.21
Jan. 14, 2025issueSO-250114-968MAIN 1 29.21-29.211002,929.77 Dec. 13, 2024: 1 @ 29.21
Jan. 5, 2025issueSO-250105-315MAIN 11 29.21-321.281012,958.98 Dec. 13, 2024: 11 @ 29.21
Jan. 2, 2025issueSO-250102-400MAIN 2 29.21-58.411123,280.26 Dec. 13, 2024: 2 @ 29.21
Dec. 31, 2024issueSO-241231-299MAIN 2 29.21-58.411143,338.67 Dec. 13, 2024: 2 @ 29.21
Dec. 17, 2024issueSO-241217-528EAST 9 29.21-262.861163,397.08 Dec. 13, 2024: 9 @ 29.21
Dec. 14, 2024returnRMAMAIN 12 29.96359.561253,659.95
Dec. 13, 2024transferTRFMAIN → EAST 27 warehouse transfer, no cost effect
Dec. 13, 2024receiptPO-000102MAIN 113 29.213,300.391133,300.39
Dec. 6, 2024issueSO-241206-111MAIN 6 29.96-179.7800.00 Oct. 1, 2024: 6 @ 29.96
Dec. 5, 2024issueSO-241205-649MAIN 24 29.96-719.116179.78 Oct. 1, 2024: 24 @ 29.96
Dec. 4, 2024issueSO-241204-535MAIN 4 29.96-119.8530898.89 Oct. 1, 2024: 4 @ 29.96
Nov. 21, 2024issueSO-241121-988MAIN 26 29.96-779.04341,018.74 Oct. 1, 2024: 26 @ 29.96
Nov. 15, 2024issueSO-241115-890MAIN 23 29.96-689.15601,797.78 Oct. 1, 2024: 23 @ 29.96
Oct. 27, 2024issueSO-241027-868MAIN 12 29.96-359.56832,486.93 Oct. 1, 2024: 12 @ 29.96
Oct. 24, 2024issueSO-241024-654MAIN 21 29.96-629.22952,846.48 Oct. 1, 2024: 21 @ 29.96
Oct. 20, 2024issueSO-241020-887MAIN 4 29.96-119.851163,475.71 Oct. 1, 2024: 4 @ 29.96
Oct. 18, 2024issueSO-241018-590MAIN 5 29.96-149.821203,595.56 Oct. 1, 2024: 5 @ 29.96
Oct. 7, 2024issueSO-241007-890MAIN 1 29.96-29.961253,745.38 Oct. 1, 2024: 1 @ 29.96
Oct. 1, 2024receiptPO-000005MAIN 126 29.963,775.341263,775.34