stocksense

Items / CAB-0013

FR Wire 1.5 sqmm Elite CAB-0013 · Cables & Wires · Conduit & Cable Co

On hand (COIL)20MAIN 20
Value (FIFO)2,702.05avg 135.10
ClassAX / FCV 0.19
Turnover11.8xlast issue 1 days ago
Days of cover29lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00130.07.715.423.130.8Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 18.0Nov 24: 24.0Dec 24: 15.0Jan 25: 16.0Feb 25: 21.0Mar 25: 15.0Apr 25: 18.0May 25: 22.0Jun 25: 17.0Jul 25: 15.0Aug 25: 17.0Sep 25: 18.0Oct 25: 22.0Nov 25: 26.0Dec 25: 14.0Jan 26: 20.0Feb 26: 28.0Mar 26: 18.0Apr 26: 23.0May 26: 21.0Jun 26: 19.0Jul 26: 24.0Aug 26: 19.0Sep 26: 16.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.437520.83 / 30.43750.684
Daily demand sdmonthly sd / sqrt(30.4375)3.87 / 5.5170.701
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(14.0 * 0.701^2 + 0.684^2 * 3.1^2)6.9
Reorder pointd * LT + safety stock0.684 * 14.0 + 6.916.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days16.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 250/yr, S = 45.00, h = 20%, price = 132.6829.1
Inventory positionon hand + on order20 + 020

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

From qtyUnit costOrder qtyAnnual costFeasible
0132.682933,920yes (chosen if cheapest)

MOQ 50, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 1, 202620 / 50135.102,702.05

Movement ledger 133 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-144MAIN 8 135.10-1,080.82202,702.05 Sept. 1, 2026: 8 @ 135.10
Oct. 14, 2026issueSO-261014-970MAIN 4 135.10-540.41283,782.87 Sept. 1, 2026: 4 @ 135.10
Oct. 8, 2026issueSO-261008-776MAIN 2 135.10-270.20324,323.28 Sept. 1, 2026: 2 @ 135.10
Sept. 30, 2026issueSO-260930-247MAIN 1 135.10-135.10344,593.48 Sept. 1, 2026: 1 @ 135.10
Sept. 11, 2026issueSO-260911-475MAIN 9 135.10-1,215.92354,728.59 Sept. 1, 2026: 9 @ 135.10
Sept. 7, 2026issueSO-260907-723MAIN 1 135.10-135.10445,944.51 Sept. 1, 2026: 1 @ 135.10
Sept. 6, 2026issueSO-260906-733MAIN 1 135.10-135.10456,079.61 Sept. 1, 2026: 1 @ 135.10
Sept. 4, 2026issueSO-260904-945MAIN 3 135.10-405.31466,214.72 Sept. 1, 2026: 3 @ 135.10
Sept. 2, 2026issueSO-260902-180MAIN 1 135.10-135.10496,620.02 Sept. 1, 2026: 1 @ 135.10
Sept. 1, 2026receiptPO-001764MAIN 50 135.106,755.12506,755.12
Aug. 22, 2026issueSO-260822-195MAIN 2 128.83-257.6600.00 June 14, 2026: 2 @ 128.83
Aug. 22, 2026issueSO-260822-195EAST 3 128.83-386.482257.66 June 14, 2026: 3 @ 128.83
Aug. 19, 2026issueSO-260819-784MAIN 10 128.83-1,288.285644.14 June 14, 2026: 10 @ 128.83
Aug. 14, 2026issueSO-260814-261MAIN 4 128.83-515.31151,932.42 June 14, 2026: 4 @ 128.83
July 31, 2026issueSO-260731-438MAIN 7 128.83-901.80192,447.74 June 14, 2026: 7 @ 128.83
July 30, 2026issueSO-260730-184MAIN 1 128.83-128.83263,349.54 June 14, 2026: 1 @ 128.83
July 22, 2026issueSO-260722-265MAIN 1 128.83-128.83273,478.36 June 14, 2026: 1 @ 128.83
July 20, 2026issueSO-260720-313MAIN 6 128.83-772.97283,607.19 June 14, 2026: 6 @ 128.83
July 1, 2026issueSO-260701-785MAIN 9 128.83-1,159.45344,380.16 June 14, 2026: 9 @ 128.83
June 30, 2026issueSO-260630-725MAIN 7 128.83-901.80435,539.62 June 14, 2026: 7 @ 128.83
June 27, 2026issueSO-260627-207EAST 3 129.77-389.30506,441.42 March 22, 2026: 2 @ 130.38; April 17, 2026: 1 @ 128.55
June 26, 2026issueSO-260626-553MAIN 1 130.38-130.38536,830.72 March 22, 2026: 1 @ 130.38
June 22, 2026issueSO-260622-720EAST 6 130.38-782.25546,961.09 March 22, 2026: 6 @ 130.38
June 14, 2026transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
June 14, 2026receiptPO-001571MAIN 50 128.836,441.42607,743.34
June 13, 2026issueSO-260613-781MAIN 2 130.38-260.75101,301.93 March 22, 2026: 2 @ 130.38
May 31, 2026issueSO-260531-733MAIN 2 130.38-260.75121,562.68 March 22, 2026: 2 @ 130.38
May 30, 2026issueSO-260530-739MAIN 18 130.38-2,346.75141,823.43 March 22, 2026: 18 @ 130.38
May 23, 2026issueSO-260523-224MAIN 1 130.38-130.38324,170.18 March 22, 2026: 1 @ 130.38
April 20, 2026issueSO-260420-343MAIN 1 130.38-130.38334,300.55 March 22, 2026: 1 @ 130.38
April 19, 2026issueSO-260419-652MAIN 2 130.38-260.75344,430.93 March 22, 2026: 2 @ 130.38
April 18, 2026issueSO-260418-146MAIN 17 130.16-2,212.73364,691.68 Feb. 5, 2026: 2 @ 128.55; March 22, 2026: 15 @ 130.38
April 17, 2026returnRMAMAIN 1 128.55128.55536,904.41
April 17, 2026issueSO-260417-519MAIN 1 128.55-128.55526,775.86 Feb. 5, 2026: 1 @ 128.55
April 8, 2026issueSO-260408-495MAIN 2 128.55-257.10536,904.41 Feb. 5, 2026: 2 @ 128.55
April 2, 2026issueSO-260402-513MAIN 1 128.55-128.55557,161.51 Feb. 5, 2026: 1 @ 128.55
March 22, 2026receiptPO-001342MAIN 50 130.386,518.76567,290.06
March 21, 2026issueSO-260321-816MAIN 2 128.55-257.106771.30 Feb. 5, 2026: 2 @ 128.55
March 5, 2026issueSO-260305-819MAIN 16 128.55-2,056.8181,028.41 Feb. 5, 2026: 16 @ 128.55
Feb. 24, 2026issueSO-260224-798EAST 2 128.55-257.10243,085.22 Feb. 5, 2026: 2 @ 128.55
Feb. 18, 2026issueSO-260218-898MAIN 9 128.55-1,156.96263,342.32 Feb. 5, 2026: 9 @ 128.55
Feb. 9, 2026issueSO-260209-197MAIN 10 128.55-1,285.51354,499.27 Feb. 5, 2026: 10 @ 128.55
Feb. 8, 2026issueSO-260208-927MAIN 2 128.55-257.10455,784.78 Feb. 5, 2026: 2 @ 128.55
Feb. 7, 2026issueSO-260207-546MAIN 5 128.64-643.18476,041.88 Nov. 2, 2025: 2 @ 128.77; Feb. 5, 2026: 3 @ 128.55
Feb. 5, 2026receiptPO-001198MAIN 50 128.556,427.54526,685.07
Jan. 28, 2026issueSO-260128-735EAST 3 128.77-386.302257.53 Nov. 2, 2025: 3 @ 128.77
Jan. 23, 2026issueSO-260123-687EAST 3 128.77-386.305643.83 Nov. 2, 2025: 3 @ 128.77
Jan. 23, 2026issueSO-260123-687MAIN 7 128.77-901.3681,030.12 Nov. 2, 2025: 7 @ 128.77
Jan. 12, 2026issueSO-260112-234MAIN 5 128.77-643.83151,931.48 Nov. 2, 2025: 5 @ 128.77
Jan. 3, 2026issueSO-260103-173EAST 2 128.77-257.53202,575.30 Nov. 2, 2025: 2 @ 128.77
Dec. 29, 2025issueSO-251229-594MAIN 1 128.77-128.77222,832.83 Nov. 2, 2025: 1 @ 128.77
Dec. 27, 2025issueSO-251227-161MAIN 1 128.77-128.77232,961.60 Nov. 2, 2025: 1 @ 128.77
Dec. 23, 2025issueSO-251223-288EAST 3 128.77-386.30243,090.36 Nov. 2, 2025: 3 @ 128.77
Dec. 15, 2025issueSO-251215-682MAIN 1 128.77-128.77273,476.66 Nov. 2, 2025: 1 @ 128.77
Dec. 10, 2025issueSO-251210-541EAST 4 128.77-515.06283,605.43 Nov. 2, 2025: 4 @ 128.77
Dec. 8, 2025issueSO-251208-462MAIN 3 128.77-386.30324,120.49 Nov. 2, 2025: 3 @ 128.77
Dec. 6, 2025issueSO-251206-969EAST 1 128.77-128.77354,506.78 Nov. 2, 2025: 1 @ 128.77
Nov. 22, 2025issueSO-251122-376EAST 1 128.77-128.77364,635.55 Nov. 2, 2025: 1 @ 128.77
Nov. 14, 2025issueSO-251114-202MAIN 13 128.77-1,673.95374,764.31 Nov. 2, 2025: 13 @ 128.77
Nov. 9, 2025issueSO-251109-246EAST 4 125.24-500.94506,438.26 Aug. 30, 2025: 1 @ 125.71; Sept. 4, 2025: 3 @ 125.08
Nov. 3, 2025issueSO-251103-336MAIN 8 125.71-1,005.71546,939.20 Aug. 30, 2025: 8 @ 125.71
Nov. 2, 2025transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
Nov. 2, 2025receiptPO-000973MAIN 50 128.776,438.26627,944.91
Oct. 21, 2025issueSO-251021-351MAIN 2 125.71-251.43121,506.65 Aug. 30, 2025: 2 @ 125.71
Oct. 20, 2025issueSO-251020-397MAIN 2 125.71-251.43141,758.08 Aug. 30, 2025: 2 @ 125.71
Oct. 18, 2025issueSO-251018-144MAIN 2 125.71-251.43162,009.51 Aug. 30, 2025: 2 @ 125.71
Oct. 17, 2025issueSO-251017-229MAIN 5 125.71-628.57182,260.93 Aug. 30, 2025: 5 @ 125.71
Oct. 15, 2025issueSO-251015-121MAIN 2 125.71-251.43232,889.50 Aug. 30, 2025: 2 @ 125.71
Oct. 10, 2025issueSO-251010-286MAIN 6 125.71-754.28253,140.93 Aug. 30, 2025: 6 @ 125.71
Oct. 8, 2025issueSO-251008-981MAIN 3 125.71-377.14313,895.21 Aug. 30, 2025: 3 @ 125.71
Sept. 27, 2025issueSO-250927-784MAIN 3 125.71-377.14344,272.35 Aug. 30, 2025: 3 @ 125.71
Sept. 20, 2025issueSO-250920-871MAIN 6 125.71-754.28374,649.50 Aug. 30, 2025: 6 @ 125.71
Sept. 19, 2025issueSO-250919-896MAIN 4 125.71-502.85435,403.78 Aug. 30, 2025: 4 @ 125.71
Sept. 7, 2025issueSO-250907-386MAIN 3 125.71-377.14475,906.63 Aug. 30, 2025: 3 @ 125.71
Sept. 4, 2025returnRMAMAIN 3 125.08375.23506,283.77
Sept. 4, 2025issueSO-250904-888EAST 5 125.08-625.38475,908.54 May 21, 2025: 2 @ 124.12; Aug. 30, 2025: 3 @ 125.71
Aug. 30, 2025transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Aug. 30, 2025receiptPO-000805MAIN 50 125.716,285.68526,533.93
Aug. 22, 2025issueSO-250822-590MAIN 1 124.12-124.122248.24 May 21, 2025: 1 @ 124.12
Aug. 18, 2025issueSO-250818-795MAIN 6 124.12-744.723372.36 May 21, 2025: 6 @ 124.12
Aug. 15, 2025issueSO-250815-742MAIN 10 124.12-1,241.2191,117.09 May 21, 2025: 10 @ 124.12
July 31, 2025issueSO-250731-459MAIN 4 124.12-496.48192,358.29 May 21, 2025: 4 @ 124.12
July 27, 2025issueSO-250727-723MAIN 7 124.12-868.84232,854.77 May 21, 2025: 7 @ 124.12
July 26, 2025issueSO-250726-533MAIN 1 124.12-124.12303,723.62 May 21, 2025: 1 @ 124.12
July 15, 2025issueSO-250715-116MAIN 1 124.12-124.12313,847.74 May 21, 2025: 1 @ 124.12
July 14, 2025issueSO-250714-122MAIN 1 124.12-124.12323,971.86 May 21, 2025: 1 @ 124.12
July 1, 2025issueSO-250701-556MAIN 1 124.12-124.12334,095.98 May 21, 2025: 1 @ 124.12
June 24, 2025issueSO-250624-888MAIN 2 124.12-248.24344,220.10 May 21, 2025: 2 @ 124.12
June 20, 2025issueSO-250620-217MAIN 1 124.12-124.12364,468.34 May 21, 2025: 1 @ 124.12
June 12, 2025issueSO-250612-694MAIN 9 124.12-1,117.09374,592.46 May 21, 2025: 9 @ 124.12
June 11, 2025issueSO-250611-112MAIN 1 124.12-124.12465,709.55 May 21, 2025: 1 @ 124.12
June 7, 2025issueSO-250607-836MAIN 2 124.12-248.24475,833.67 May 21, 2025: 2 @ 124.12
June 5, 2025issueSO-250605-668MAIN 2 122.77-245.55496,081.91 March 7, 2025: 1 @ 121.43; May 21, 2025: 1 @ 124.12
May 26, 2025issueSO-250526-230MAIN 5 121.43-607.14516,327.46 March 7, 2025: 5 @ 121.43
May 21, 2025receiptPO-000554MAIN 50 124.126,206.03566,934.60
May 19, 2025issueSO-250519-828MAIN 6 121.43-728.576728.57 March 7, 2025: 6 @ 121.43
May 8, 2025issueSO-250508-791MAIN 3 121.43-364.28121,457.13 March 7, 2025: 3 @ 121.43
May 7, 2025issueSO-250507-966MAIN 8 121.43-971.42151,821.42 March 7, 2025: 8 @ 121.43
April 21, 2025issueSO-250421-996EAST 6 121.43-728.57232,792.84 March 7, 2025: 6 @ 121.43
April 15, 2025issueSO-250415-202MAIN 1 121.43-121.43293,521.41 March 7, 2025: 1 @ 121.43
April 12, 2025issueSO-250412-457MAIN 1 121.43-121.43303,642.84 March 7, 2025: 1 @ 121.43
April 6, 2025issueSO-250406-637EAST 5 121.43-607.14313,764.26 March 7, 2025: 5 @ 121.43
April 5, 2025issueSO-250405-847EAST 4 121.43-485.71364,371.40 March 7, 2025: 4 @ 121.43
April 4, 2025issueSO-250404-241EAST 1 121.43-121.43404,857.12 March 7, 2025: 1 @ 121.43
March 18, 2025issueSO-250318-106EAST 6 121.43-728.57414,978.54 March 7, 2025: 6 @ 121.43
March 17, 2025issueSO-250317-147MAIN 3 121.43-364.28475,707.11 March 7, 2025: 3 @ 121.43
March 10, 2025issueSO-250310-692MAIN 6 120.74-724.45506,071.40 Dec. 3, 2024: 6 @ 120.74
March 7, 2025transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
March 7, 2025receiptPO-000324MAIN 50 121.436,071.40566,795.84
Feb. 23, 2025issueSO-250223-472EAST 1 120.74-120.746724.45 Dec. 3, 2024: 1 @ 120.74
Feb. 22, 2025issueSO-250222-970EAST 1 120.74-120.747845.19 Dec. 3, 2024: 1 @ 120.74
Feb. 21, 2025issueSO-250221-436EAST 8 120.74-965.938965.93 Dec. 3, 2024: 8 @ 120.74
Feb. 9, 2025issueSO-250209-408EAST 1 120.74-120.74161,931.86 Dec. 3, 2024: 1 @ 120.74
Feb. 9, 2025issueSO-250209-408MAIN 7 120.74-845.19172,052.60 Dec. 3, 2024: 7 @ 120.74
Feb. 7, 2025issueSO-250207-143MAIN 3 120.74-362.22242,897.78 Dec. 3, 2024: 3 @ 120.74
Jan. 31, 2025issueSO-250131-499MAIN 5 120.74-603.70273,260.01 Dec. 3, 2024: 5 @ 120.74
Jan. 28, 2025issueSO-250128-586MAIN 9 120.74-1,086.67323,863.71 Dec. 3, 2024: 9 @ 120.74
Jan. 3, 2025issueSO-250103-824EAST 2 120.74-241.48414,950.38 Dec. 3, 2024: 2 @ 120.74
Dec. 25, 2024issueSO-241225-653MAIN 13 123.19-1,601.46435,191.86 Oct. 1, 2024: 6 @ 126.05; Dec. 3, 2024: 7 @ 120.74
Dec. 21, 2024issueSO-241221-100MAIN 2 126.05-252.09566,793.33 Oct. 1, 2024: 2 @ 126.05
Dec. 3, 2024transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Dec. 3, 2024receiptPO-000077MAIN 50 120.746,037.05587,045.42
Nov. 19, 2024issueSO-241119-415MAIN 1 126.05-126.0581,008.37 Oct. 1, 2024: 1 @ 126.05
Nov. 18, 2024issueSO-241118-449EAST 9 126.05-1,134.4191,134.41 Oct. 1, 2024: 9 @ 126.05
Nov. 6, 2024issueSO-241106-227MAIN 14 126.05-1,764.64182,268.83 Oct. 1, 2024: 14 @ 126.05
Oct. 24, 2024issueSO-241024-232MAIN 8 126.05-1,008.37324,033.47 Oct. 1, 2024: 8 @ 126.05
Oct. 23, 2024issueSO-241023-771MAIN 1 126.05-126.05405,041.84 Oct. 1, 2024: 1 @ 126.05
Oct. 16, 2024issueSO-241016-691MAIN 1 126.05-126.05415,167.89 Oct. 1, 2024: 1 @ 126.05
Oct. 15, 2024issueSO-241015-929EAST 1 126.05-126.05425,293.93 Oct. 1, 2024: 1 @ 126.05
Oct. 14, 2024issueSO-241014-367MAIN 1 126.05-126.05435,419.98 Oct. 1, 2024: 1 @ 126.05
Oct. 12, 2024issueSO-241012-186MAIN 6 126.05-756.28445,546.02 Oct. 1, 2024: 6 @ 126.05
Oct. 1, 2024transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 50 126.056,302.30506,302.30