stocksense

Items / MCB-0022

MCB 16A DP Nova MCB-0022 · Circuit Protection · Volta Electricals Pvt Ltd

On hand (EA)16MAIN 16
Value (FIFO)865.46avg 54.09
ClassBY / FCV 0.62
Turnover12.2xlast issue 8 days ago
Days of cover18lead time 7d

Reorder suggested: 52 units (position at or below reorder point: order EOQ), stockout risk low.

Demand and forecast

Monthly demand and forecast for MCB-00220.019.238.557.877.0Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 9.0Nov 24: 14.0Dec 24: 16.0Jan 25: 18.0Feb 25: 9.0Mar 25: 22.0Apr 25: 29.0May 25: 26.0Jun 25: 12.0Jul 25: 26.0Aug 25: 35.0Sep 25: 15.0Oct 25: 16.0Nov 25: 25.0Dec 25: 70.0Jan 26: 14.0Feb 26: 17.0Mar 26: 37.0Apr 26: 21.0May 26: 10.0Jun 26: 22.0Jul 26: 13.0Aug 26: 48.0Sep 26: 30.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.437526.92 / 30.43750.884
Daily demand sdmonthly sd / sqrt(30.4375)16.68 / 5.5173.023
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 * 3.023^2 + 0.884^2 * 1.5^2)13.3
Reorder pointd * LT + safety stock0.884 * 7.0 + 13.319.5
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days19.5
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 323/yr, S = 45.00, h = 20%, price = 54.7851.5
Inventory positionon hand + on order16 + 016

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

From qtyUnit costOrder qtyAnnual costFeasible
054.785118,246yes (chosen if cheapest)

MOQ 25, pack size 1, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 18, 202616 / 4554.09865.46

Movement ledger 133 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 8, 2026issueSO-261008-386MAIN 10 54.09-540.9116865.46 Sept. 18, 2026: 10 @ 54.09
Oct. 8, 2026issueSO-261008-386EAST 6 54.09-324.55261,406.37 Sept. 18, 2026: 6 @ 54.09
Oct. 6, 2026issueSO-261006-205MAIN 1 54.09-54.09321,730.92 Sept. 18, 2026: 1 @ 54.09
Oct. 4, 2026issueSO-261004-833EAST 1 54.09-54.09331,785.01 Sept. 18, 2026: 1 @ 54.09
Oct. 2, 2026issueSO-261002-776EAST 2 54.09-108.18341,839.10 Sept. 18, 2026: 2 @ 54.09
Sept. 27, 2026issueSO-260927-691MAIN 10 54.06-540.61361,947.28 Aug. 22, 2026: 1 @ 53.79; Sept. 18, 2026: 9 @ 54.09
Sept. 18, 2026transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
Sept. 18, 2026receiptPO-001810MAIN 45 54.092,434.10462,487.89
Sept. 11, 2026issueSO-260911-309MAIN 13 53.79-699.31153.79 Aug. 22, 2026: 13 @ 53.79
Sept. 2, 2026issueSO-260902-130MAIN 7 53.79-376.5514753.10 Aug. 22, 2026: 7 @ 53.79
Aug. 27, 2026issueSO-260827-754MAIN 31 54.05-1,675.58211,129.65 June 24, 2026: 7 @ 54.94; Aug. 22, 2026: 24 @ 53.79
Aug. 22, 2026receiptPO-001734MAIN 45 53.792,420.68522,805.23
Aug. 16, 2026issueSO-260816-135MAIN 17 54.94-933.917384.55 June 24, 2026: 17 @ 54.94
July 15, 2026issueSO-260715-723MAIN 1 54.94-54.94241,318.46 June 24, 2026: 1 @ 54.94
July 9, 2026issueSO-260709-769MAIN 2 54.94-109.87251,373.39 June 24, 2026: 2 @ 54.94
July 7, 2026issueSO-260707-242MAIN 5 54.94-274.68271,483.26 June 24, 2026: 5 @ 54.94
July 2, 2026issueSO-260702-397MAIN 5 54.94-274.68321,757.94 June 24, 2026: 5 @ 54.94
June 25, 2026issueSO-260625-225MAIN 8 54.94-439.49372,032.62 June 24, 2026: 8 @ 54.94
June 24, 2026receiptPO-001602MAIN 45 54.942,472.11452,472.11
June 22, 2026issueSO-260622-438MAIN 5 54.78-273.9200.00 April 2, 2026: 5 @ 54.78
June 19, 2026issueSO-260619-541MAIN 6 54.78-328.705273.92 April 2, 2026: 6 @ 54.78
June 18, 2026issueSO-260618-811MAIN 1 54.78-54.7811602.62 April 2, 2026: 1 @ 54.78
June 3, 2026issueSO-260603-602MAIN 2 54.78-109.5712657.40 April 2, 2026: 2 @ 54.78
May 24, 2026issueSO-260524-577MAIN 1 54.78-54.7814766.97 April 2, 2026: 1 @ 54.78
May 24, 2026issueSO-260524-577EAST 8 54.78-438.2715821.75 April 2, 2026: 8 @ 54.78
May 10, 2026issueSO-260510-327MAIN 1 54.78-54.78231,260.02 April 2, 2026: 1 @ 54.78
April 20, 2026issueSO-260420-793MAIN 7 54.78-383.48241,314.80 April 2, 2026: 7 @ 54.78
April 16, 2026issueSO-260416-419MAIN 2 54.78-109.57311,698.29 April 2, 2026: 2 @ 54.78
April 14, 2026issueSO-260414-247EAST 1 54.78-54.78331,807.85 April 2, 2026: 1 @ 54.78
April 8, 2026issueSO-260408-877MAIN 11 54.78-602.62341,862.64 April 2, 2026: 11 @ 54.78
April 2, 2026transferTRFMAIN → EAST 9 warehouse transfer, no cost effect
April 2, 2026receiptPO-001377MAIN 45 54.782,465.25452,465.25
March 28, 2026issueSO-260328-234EAST 14 53.90-754.6300.00 Jan. 16, 2026: 13 @ 53.90; Feb. 27, 2026: 1 @ 53.90
March 18, 2026issueSO-260318-765EAST 9 53.90-485.1214754.63 Jan. 16, 2026: 9 @ 53.90
March 18, 2026issueSO-260318-765MAIN 13 53.90-700.73231,239.75 Jan. 16, 2026: 13 @ 53.90
March 6, 2026issueSO-260306-923EAST 1 53.90-53.90361,940.48 Jan. 16, 2026: 1 @ 53.90
Feb. 27, 2026returnRMAMAIN 1 53.9053.90371,994.38
Feb. 25, 2026issueSO-260225-842MAIN 1 53.90-53.90361,940.48 Jan. 16, 2026: 1 @ 53.90
Feb. 19, 2026issueSO-260219-846MAIN 1 53.90-53.90371,994.38 Jan. 16, 2026: 1 @ 53.90
Feb. 7, 2026issueSO-260207-556MAIN 15 54.01-810.20382,048.28 Dec. 19, 2025: 8 @ 54.11; Jan. 16, 2026: 7 @ 53.90
Feb. 6, 2026issueSO-260206-782MAIN 1 54.11-54.11532,858.48 Dec. 19, 2025: 1 @ 54.11
Jan. 16, 2026transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Jan. 16, 2026receiptPO-001148MAIN 45 53.902,425.59542,912.59
Jan. 8, 2026issueSO-260108-931MAIN 13 54.11-703.439486.99 Dec. 19, 2025: 13 @ 54.11
Jan. 3, 2026issueSO-260103-167MAIN 1 54.11-54.11221,190.43 Dec. 19, 2025: 1 @ 54.11
Dec. 28, 2025issueSO-251228-414MAIN 18 54.11-973.99231,244.54 Dec. 19, 2025: 18 @ 54.11
Dec. 27, 2025issueSO-251227-515MAIN 6 54.07-324.39412,218.52 Nov. 18, 2025: 2 @ 53.98; Dec. 19, 2025: 4 @ 54.11
Dec. 22, 2025issueSO-251222-592EAST 6 53.98-323.86472,542.92 Nov. 18, 2025: 6 @ 53.98
Dec. 19, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Dec. 19, 2025receiptPO-001067MAIN 45 54.112,434.96532,866.78
Dec. 12, 2025issueSO-251212-847MAIN 3 53.98-161.938431.81 Nov. 18, 2025: 3 @ 53.98
Dec. 11, 2025issueSO-251211-381MAIN 17 53.98-917.6011593.74 Nov. 18, 2025: 17 @ 53.98
Dec. 10, 2025issueSO-251210-411MAIN 3 53.98-161.93281,511.34 Nov. 18, 2025: 3 @ 53.98
Dec. 4, 2025issueSO-251204-947MAIN 1 53.98-53.98311,673.27 Nov. 18, 2025: 1 @ 53.98
Dec. 4, 2025issueSO-251204-947EAST 16 53.55-856.85321,727.25 Sept. 16, 2025: 1 @ 51.72; Nov. 7, 2025: 2 @ 51.72; Nov. 18, 2025: 13 @ 53.98
Nov. 27, 2025issueSO-251127-277MAIN 3 51.72-155.16482,584.10 Sept. 16, 2025: 3 @ 51.72
Nov. 19, 2025issueSO-251119-217EAST 1 51.72-51.72512,739.26 Sept. 16, 2025: 1 @ 51.72
Nov. 18, 2025issueSO-251118-579MAIN 3 51.72-155.16522,790.98 Sept. 16, 2025: 3 @ 51.72
Nov. 18, 2025transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Nov. 18, 2025receiptPO-001007MAIN 45 53.982,428.94552,946.14
Nov. 11, 2025issueSO-251111-995MAIN 4 51.72-206.8810517.20 Sept. 16, 2025: 4 @ 51.72
Nov. 7, 2025returnRMAMAIN 2 51.72103.4414724.08
Nov. 7, 2025issueSO-251107-379MAIN 12 51.72-620.6412620.64 Sept. 16, 2025: 12 @ 51.72
Nov. 5, 2025issueSO-251105-131EAST 4 51.72-206.88241,241.28 Sept. 16, 2025: 4 @ 51.72
Oct. 29, 2025issueSO-251029-519MAIN 7 51.72-362.04281,448.16 Sept. 16, 2025: 7 @ 51.72
Oct. 27, 2025issueSO-251027-436EAST 5 51.72-258.60351,810.20 Sept. 16, 2025: 5 @ 51.72
Oct. 24, 2025issueSO-251024-714MAIN 1 51.72-51.72402,068.80 Sept. 16, 2025: 1 @ 51.72
Oct. 23, 2025issueSO-251023-309MAIN 1 51.72-51.72412,120.52 Sept. 16, 2025: 1 @ 51.72
Oct. 4, 2025issueSO-251004-576EAST 2 51.72-103.44422,172.24 Sept. 16, 2025: 2 @ 51.72
Sept. 25, 2025issueSO-250925-334MAIN 5 51.62-258.10442,275.68 July 16, 2025: 4 @ 51.59; Sept. 16, 2025: 1 @ 51.72
Sept. 16, 2025transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Sept. 16, 2025receiptPO-000850MAIN 45 51.722,327.40492,533.77
Sept. 14, 2025issueSO-250914-455MAIN 2 51.59-103.194206.38 July 16, 2025: 2 @ 51.59
Sept. 13, 2025issueSO-250913-584MAIN 1 51.59-51.596309.57 July 16, 2025: 1 @ 51.59
Sept. 11, 2025issueSO-250911-532MAIN 5 51.59-257.977361.16 July 16, 2025: 5 @ 51.59
Sept. 8, 2025issueSO-250908-529MAIN 2 51.59-103.1912619.13 July 16, 2025: 2 @ 51.59
Aug. 10, 2025issueSO-250810-679MAIN 11 51.59-567.5414722.32 July 16, 2025: 11 @ 51.59
Aug. 6, 2025issueSO-250806-259MAIN 24 51.38-1,233.14251,289.86 May 22, 2025: 4 @ 50.31; July 16, 2025: 20 @ 51.59
July 27, 2025issueSO-250727-209MAIN 3 50.31-150.94492,523.00 May 22, 2025: 3 @ 50.31
July 16, 2025receiptPO-000717MAIN 45 51.592,321.74522,673.94
July 12, 2025issueSO-250712-665MAIN 2 50.31-100.637352.20 May 22, 2025: 2 @ 50.31
July 8, 2025issueSO-250708-302MAIN 4 50.31-201.259452.82 May 22, 2025: 4 @ 50.31
July 1, 2025issueSO-250701-242MAIN 11 50.31-553.4513654.08 May 22, 2025: 11 @ 50.31
July 1, 2025issueSO-250701-242EAST 6 50.31-301.88241,207.53 May 22, 2025: 6 @ 50.31
June 27, 2025issueSO-250627-512MAIN 3 50.31-150.94301,509.41 May 22, 2025: 3 @ 50.31
June 24, 2025issueSO-250624-866MAIN 1 50.31-50.31331,660.35 May 22, 2025: 1 @ 50.31
June 21, 2025issueSO-250621-381EAST 1 50.31-50.31341,710.66 May 22, 2025: 1 @ 50.31
June 18, 2025issueSO-250618-314MAIN 5 50.31-251.57351,760.98 May 22, 2025: 5 @ 50.31
June 15, 2025issueSO-250615-531MAIN 1 50.31-50.31402,012.54 May 22, 2025: 1 @ 50.31
June 10, 2025issueSO-250610-192MAIN 1 50.31-50.31412,062.86 May 22, 2025: 1 @ 50.31
May 26, 2025issueSO-250526-932EAST 4 50.26-201.02422,113.17 March 13, 2025: 1 @ 50.08; May 22, 2025: 3 @ 50.31
May 22, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
May 22, 2025receiptPO-000563MAIN 45 50.312,264.11462,314.19
May 18, 2025issueSO-250518-960MAIN 10 50.08-500.82150.08 March 13, 2025: 10 @ 50.08
May 14, 2025issueSO-250514-407MAIN 7 50.08-350.5811550.90 March 13, 2025: 7 @ 50.08
May 10, 2025issueSO-250510-166MAIN 1 50.08-50.0818901.48 March 13, 2025: 1 @ 50.08
May 5, 2025issueSO-250505-380MAIN 1 50.08-50.0819951.56 March 13, 2025: 1 @ 50.08
May 2, 2025issueSO-250502-707MAIN 1 50.08-50.08201,001.64 March 13, 2025: 1 @ 50.08
May 1, 2025issueSO-250501-809MAIN 2 50.08-100.16211,051.73 March 13, 2025: 2 @ 50.08
April 19, 2025issueSO-250419-439MAIN 15 50.08-751.23231,151.89 March 13, 2025: 15 @ 50.08
April 17, 2025issueSO-250417-672MAIN 12 50.84-610.09381,903.12 Dec. 22, 2024: 4 @ 52.04; Feb. 28, 2025: 1 @ 51.35; March 13, 2025: 7 @ 50.08
April 14, 2025issueSO-250414-934MAIN 1 52.04-52.04502,513.21 Dec. 22, 2024: 1 @ 52.04
April 2, 2025issueSO-250402-262MAIN 1 52.04-52.04512,565.25 Dec. 22, 2024: 1 @ 52.04
March 19, 2025issueSO-250319-842MAIN 4 51.69-206.78522,617.29 Dec. 16, 2024: 2 @ 51.35; Dec. 21, 2024: 1 @ 52.04; Dec. 22, 2024: 1 @ 52.04
March 13, 2025receiptPO-000338MAIN 45 50.082,253.70562,824.07
March 7, 2025issueSO-250307-432MAIN 14 51.35-718.8611570.37 Dec. 16, 2024: 14 @ 51.35
March 1, 2025issueSO-250301-105MAIN 4 51.35-205.39251,289.23 Dec. 16, 2024: 4 @ 51.35
Feb. 28, 2025returnRMAMAIN 1 51.3551.35291,494.62
Feb. 27, 2025issueSO-250227-103MAIN 2 51.35-102.69281,443.27 Dec. 16, 2024: 2 @ 51.35
Feb. 24, 2025issueSO-250224-933MAIN 1 51.35-51.35301,545.96 Dec. 16, 2024: 1 @ 51.35
Feb. 23, 2025issueSO-250223-470MAIN 1 51.35-51.35311,597.31 Dec. 16, 2024: 1 @ 51.35
Feb. 18, 2025issueSO-250218-901MAIN 3 51.35-154.04321,648.66 Dec. 16, 2024: 3 @ 51.35
Feb. 6, 2025issueSO-250206-187MAIN 2 51.35-102.69351,802.70 Dec. 16, 2024: 2 @ 51.35
Feb. 3, 2025issueSO-250203-140MAIN 1 51.35-51.35371,905.39 Dec. 16, 2024: 1 @ 51.35
Jan. 31, 2025issueSO-250131-913MAIN 4 51.35-205.39381,956.74 Dec. 16, 2024: 4 @ 51.35
Jan. 30, 2025issueSO-250130-483MAIN 4 51.35-205.39422,162.13 Dec. 16, 2024: 4 @ 51.35
Jan. 8, 2025issueSO-250108-382MAIN 10 51.56-515.55462,367.51 Dec. 13, 2024: 3 @ 52.04; Dec. 16, 2024: 7 @ 51.35
Dec. 22, 2024returnRMAMAIN 7 52.04364.29562,883.07
Dec. 22, 2024issueSO-241222-568MAIN 1 52.04-52.04492,518.78 Dec. 13, 2024: 1 @ 52.04
Dec. 21, 2024returnRMAMAIN 1 52.0452.04502,570.82
Dec. 16, 2024receiptPO-000110MAIN 45 51.352,310.62492,518.78
Dec. 13, 2024returnRMAMAIN 4 52.04208.164208.16
Dec. 13, 2024issueSO-241213-305MAIN 10 52.04-520.4100.00 Oct. 1, 2024: 10 @ 52.04
Dec. 9, 2024issueSO-241209-938MAIN 1 52.04-52.0410520.41 Oct. 1, 2024: 1 @ 52.04
Dec. 8, 2024issueSO-241208-628MAIN 2 52.04-104.0811572.45 Oct. 1, 2024: 2 @ 52.04
Dec. 2, 2024issueSO-241202-698MAIN 14 52.04-728.5713676.53 Oct. 1, 2024: 14 @ 52.04
Nov. 30, 2024issueSO-241130-591MAIN 8 52.04-416.33271,405.11 Oct. 1, 2024: 8 @ 52.04
Nov. 24, 2024issueSO-241124-479MAIN 5 52.04-260.20351,821.44 Oct. 1, 2024: 5 @ 52.04
Nov. 20, 2024issueSO-241120-922MAIN 1 52.04-52.04402,081.64 Oct. 1, 2024: 1 @ 52.04
Oct. 26, 2024issueSO-241026-378MAIN 4 52.04-208.16412,133.68 Oct. 1, 2024: 4 @ 52.04
Oct. 16, 2024issueSO-241016-733MAIN 4 52.04-208.16452,341.84 Oct. 1, 2024: 4 @ 52.04
Oct. 7, 2024issueSO-241007-266MAIN 1 52.04-52.04492,550.01 Oct. 1, 2024: 1 @ 52.04
Oct. 1, 2024receiptPO-000005MAIN 50 52.042,602.05502,602.05