stocksense

Items / CAB-0029

FR Wire 2.5 sqmm Plus CAB-0029 · Cables & Wires · Conduit & Cable Co

On hand (COIL)41MAIN 24, EAST 17
Value (FIFO)1,762.96avg 43.00
ClassBX / FCV 0.18
Turnover9.4xlast issue 0 days ago
Days of cover62lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00290.08.016.023.931.9Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 25.0Nov 24: 25.0Dec 24: 26.0Jan 25: 20.0Feb 25: 24.0Mar 25: 20.0Apr 25: 29.0May 25: 25.0Jun 25: 27.0Jul 25: 29.0Aug 25: 16.0Sep 25: 16.0Oct 25: 18.0Nov 25: 18.0Dec 25: 26.0Jan 26: 27.0Feb 26: 17.0Mar 26: 20.0Apr 26: 19.0May 26: 23.0Jun 26: 16.0Jul 26: 16.0Aug 26: 18.0Sep 26: 24.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.17 / 30.43750.663
Daily demand sdmonthly sd / sqrt(30.4375)3.69 / 5.5170.669
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(14.0 * 0.669^2 + 0.663^2 * 3.1^2)5.3
Reorder pointd * LT + safety stock0.663 * 14.0 + 5.314.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days14.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 242/yr, S = 45.00, h = 20%, price = 41.9950.9
Inventory positionon hand + on order41 + 041

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

From qtyUnit costOrder qtyAnnual costFeasible
041.995110,582yes (chosen if cheapest)

MOQ 50, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 15, 202641 / 5043.001,762.96

Movement ledger 136 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-506MAIN 12 42.55-510.61411,762.96 Sept. 30, 2026: 3 @ 41.21; Oct. 15, 2026: 9 @ 43.00
Oct. 15, 2026transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Oct. 15, 2026receiptPO-001881MAIN 50 43.002,149.95532,273.57
Oct. 8, 2026issueSO-261008-200MAIN 3 41.21-123.623123.62 Aug. 17, 2026: 3 @ 41.21
Oct. 6, 2026issueSO-261006-931MAIN 10 41.21-412.076247.24 Aug. 17, 2026: 10 @ 41.21
Oct. 2, 2026issueSO-261002-370MAIN 1 41.21-41.2116659.31 Aug. 17, 2026: 1 @ 41.21
Oct. 1, 2026issueSO-261001-556MAIN 9 41.21-370.8617700.52 Aug. 17, 2026: 9 @ 41.21
Sept. 30, 2026returnRMAMAIN 3 41.21123.62261,071.38
Sept. 24, 2026issueSO-260924-147MAIN 5 41.21-206.0323947.76 Aug. 17, 2026: 5 @ 41.21
Sept. 20, 2026issueSO-260920-758EAST 1 41.21-41.21281,153.79 Aug. 17, 2026: 1 @ 41.21
Sept. 18, 2026issueSO-260918-983MAIN 6 41.21-247.24291,195.00 Aug. 17, 2026: 6 @ 41.21
Sept. 14, 2026issueSO-260914-936EAST 4 41.21-164.83351,442.24 Aug. 17, 2026: 4 @ 41.21
Sept. 13, 2026issueSO-260913-395MAIN 10 41.21-412.07391,607.07 Aug. 17, 2026: 10 @ 41.21
Sept. 4, 2026issueSO-260904-173MAIN 1 41.21-41.21492,019.14 Aug. 17, 2026: 1 @ 41.21
Aug. 29, 2026issueSO-260829-163MAIN 6 41.07-246.40502,060.34 June 10, 2026: 3 @ 41.07; Aug. 11, 2026: 3 @ 41.07
Aug. 24, 2026issueSO-260824-998MAIN 5 41.07-205.33562,306.74 June 10, 2026: 5 @ 41.07
Aug. 18, 2026issueSO-260818-198EAST 2 41.07-82.13612,512.07 June 10, 2026: 2 @ 41.07
Aug. 17, 2026receiptPO-001724MAIN 50 41.212,060.34632,594.20
Aug. 11, 2026returnRMAMAIN 3 41.07123.2013533.86
Aug. 5, 2026issueSO-260805-994EAST 1 41.07-41.0710410.66 June 10, 2026: 1 @ 41.07
Aug. 5, 2026issueSO-260805-994MAIN 7 41.07-287.4611451.73 June 10, 2026: 7 @ 41.07
July 29, 2026issueSO-260729-485MAIN 4 41.07-164.2618739.19 June 10, 2026: 4 @ 41.07
July 26, 2026issueSO-260726-580MAIN 1 41.07-41.0722903.45 June 10, 2026: 1 @ 41.07
July 14, 2026issueSO-260714-195MAIN 2 41.07-82.1323944.52 June 10, 2026: 2 @ 41.07
July 13, 2026issueSO-260713-556EAST 5 41.07-205.33251,026.65 June 10, 2026: 5 @ 41.07
July 10, 2026issueSO-260710-766MAIN 1 41.07-41.07301,231.98 June 10, 2026: 1 @ 41.07
July 3, 2026issueSO-260703-521MAIN 1 41.07-41.07311,273.05 June 10, 2026: 1 @ 41.07
July 2, 2026issueSO-260702-571MAIN 2 41.07-82.13321,314.11 June 10, 2026: 2 @ 41.07
June 29, 2026issueSO-260629-332MAIN 2 41.07-82.13341,396.24 June 10, 2026: 2 @ 41.07
June 24, 2026issueSO-260624-801MAIN 1 41.07-41.07361,478.38 June 10, 2026: 1 @ 41.07
June 23, 2026issueSO-260623-434MAIN 5 41.07-205.33371,519.44 June 10, 2026: 5 @ 41.07
June 14, 2026issueSO-260614-990MAIN 8 41.07-328.53421,724.77 June 10, 2026: 8 @ 41.07
June 10, 2026transferTRFMAIN → EAST 16 warehouse transfer, no cost effect
June 10, 2026receiptPO-001566MAIN 50 41.072,053.30502,053.30
May 30, 2026issueSO-260530-159MAIN 17 41.24-701.1000.00 Feb. 19, 2026: 17 @ 41.24
May 22, 2026issueSO-260522-994MAIN 6 41.24-247.4517701.10 Feb. 19, 2026: 6 @ 41.24
April 26, 2026issueSO-260426-622MAIN 1 41.24-41.2423948.55 Feb. 19, 2026: 1 @ 41.24
April 21, 2026issueSO-260421-933MAIN 17 41.24-701.1024989.79 Feb. 19, 2026: 17 @ 41.24
April 4, 2026issueSO-260404-152MAIN 1 41.24-41.24411,690.89 Feb. 19, 2026: 1 @ 41.24
March 27, 2026issueSO-260327-965MAIN 1 41.24-41.24421,732.13 Feb. 19, 2026: 1 @ 41.24
March 20, 2026issueSO-260320-730MAIN 11 40.57-446.27431,773.37 Dec. 29, 2025: 2 @ 39.39; Jan. 20, 2026: 2 @ 39.39; Feb. 19, 2026: 7 @ 41.24
March 11, 2026issueSO-260311-451MAIN 2 39.39-78.79542,219.63 Dec. 29, 2025: 2 @ 39.39
March 4, 2026issueSO-260304-633MAIN 1 39.39-39.39562,298.42 Dec. 29, 2025: 1 @ 39.39
March 3, 2026issueSO-260303-818MAIN 5 39.39-196.97572,337.82 Dec. 29, 2025: 5 @ 39.39
Feb. 19, 2026receiptPO-001240MAIN 50 41.242,062.06622,534.79
Feb. 9, 2026issueSO-260209-485MAIN 5 39.39-196.9712472.73 Dec. 29, 2025: 5 @ 39.39
Feb. 5, 2026issueSO-260205-166MAIN 9 39.39-354.5517669.71 Dec. 29, 2025: 9 @ 39.39
Feb. 1, 2026issueSO-260201-559MAIN 1 39.39-39.39261,024.26 Dec. 29, 2025: 1 @ 39.39
Feb. 1, 2026issueSO-260201-559EAST 2 39.39-78.79271,063.65 Dec. 29, 2025: 2 @ 39.39
Jan. 29, 2026issueSO-260129-657MAIN 2 39.39-78.79291,142.44 Dec. 29, 2025: 2 @ 39.39
Jan. 23, 2026issueSO-260123-831MAIN 13 39.39-512.13311,221.23 Dec. 29, 2025: 13 @ 39.39
Jan. 21, 2026issueSO-260121-407EAST 5 39.39-196.97441,733.36 Dec. 29, 2025: 5 @ 39.39
Jan. 20, 2026returnRMAMAIN 2 39.3978.79491,930.33
Jan. 20, 2026issueSO-260120-497MAIN 1 39.39-39.39471,851.54 Dec. 29, 2025: 1 @ 39.39
Jan. 15, 2026issueSO-260115-429EAST 4 40.42-161.68481,890.94 Nov. 4, 2025: 2 @ 41.45; Dec. 29, 2025: 2 @ 39.39
Jan. 12, 2026issueSO-260112-406MAIN 2 41.45-82.89522,052.62 Nov. 4, 2025: 2 @ 41.45
Jan. 11, 2026issueSO-260111-328MAIN 2 41.45-82.89542,135.51 Nov. 4, 2025: 2 @ 41.45
Dec. 30, 2025issueSO-251230-215MAIN 8 41.45-331.58562,218.41 Nov. 4, 2025: 8 @ 41.45
Dec. 29, 2025transferTRFMAIN → EAST 11 warehouse transfer, no cost effect
Dec. 29, 2025receiptPO-001100MAIN 50 39.391,969.72642,549.98
Dec. 14, 2025issueSO-251214-528MAIN 7 41.45-290.1314580.26 Nov. 4, 2025: 7 @ 41.45
Dec. 12, 2025issueSO-251212-973MAIN 10 41.45-414.4721870.39 Nov. 4, 2025: 10 @ 41.45
Dec. 3, 2025issueSO-251203-698MAIN 1 41.45-41.45311,284.86 Nov. 4, 2025: 1 @ 41.45
Nov. 22, 2025issueSO-251122-764MAIN 8 41.45-331.58321,326.31 Nov. 4, 2025: 8 @ 41.45
Nov. 18, 2025issueSO-251118-957MAIN 8 41.45-331.58401,657.88 Nov. 4, 2025: 8 @ 41.45
Nov. 17, 2025issueSO-251117-812MAIN 1 41.45-41.45481,989.46 Nov. 4, 2025: 1 @ 41.45
Nov. 9, 2025issueSO-251109-322MAIN 1 41.45-41.45492,030.91 Nov. 4, 2025: 1 @ 41.45
Nov. 4, 2025receiptPO-000979MAIN 50 41.452,072.36502,072.36
Oct. 25, 2025issueSO-251025-690MAIN 3 40.35-121.0600.00 Aug. 14, 2025: 3 @ 40.35
Oct. 22, 2025issueSO-251022-921MAIN 6 40.35-242.123121.06 Aug. 14, 2025: 6 @ 40.35
Oct. 19, 2025issueSO-251019-254MAIN 9 40.35-363.199363.19 Aug. 14, 2025: 9 @ 40.35
Sept. 18, 2025issueSO-250918-242MAIN 8 40.35-322.8318726.37 Aug. 14, 2025: 8 @ 40.35
Sept. 17, 2025issueSO-250917-743MAIN 1 40.35-40.35261,049.21 Aug. 14, 2025: 1 @ 40.35
Sept. 13, 2025issueSO-250913-230MAIN 1 40.35-40.35271,089.56 Aug. 14, 2025: 1 @ 40.35
Sept. 6, 2025issueSO-250906-448MAIN 6 40.35-242.12281,129.91 Aug. 14, 2025: 6 @ 40.35
Aug. 28, 2025issueSO-250828-636MAIN 3 40.35-121.06341,372.04 Aug. 14, 2025: 3 @ 40.35
Aug. 27, 2025issueSO-250827-333MAIN 3 40.35-121.06371,493.10 Aug. 14, 2025: 3 @ 40.35
Aug. 19, 2025issueSO-250819-113MAIN 1 40.35-40.35401,614.16 Aug. 14, 2025: 1 @ 40.35
Aug. 18, 2025issueSO-250818-923MAIN 9 40.35-363.19411,654.52 Aug. 14, 2025: 9 @ 40.35
Aug. 14, 2025receiptPO-000776MAIN 50 40.352,017.70502,017.70
July 29, 2025issueSO-250729-624EAST 5 40.22-201.1200.00 June 2, 2025: 5 @ 40.22
July 29, 2025issueSO-250729-624MAIN 19 40.22-764.245201.12 June 2, 2025: 19 @ 40.22
July 17, 2025issueSO-250717-532MAIN 5 40.22-201.1224965.36 June 2, 2025: 5 @ 40.22
June 28, 2025issueSO-250628-571MAIN 3 40.22-120.67291,166.48 June 2, 2025: 3 @ 40.22
June 20, 2025issueSO-250620-681MAIN 1 40.22-40.22321,287.15 June 2, 2025: 1 @ 40.22
June 18, 2025issueSO-250618-896MAIN 4 40.22-160.89331,327.37 June 2, 2025: 4 @ 40.22
June 17, 2025issueSO-250617-433EAST 1 40.22-40.22371,488.27 June 2, 2025: 1 @ 40.22
June 15, 2025issueSO-250615-437MAIN 4 40.22-160.89381,528.49 June 2, 2025: 4 @ 40.22
June 13, 2025issueSO-250613-812MAIN 5 40.22-201.12421,689.38 June 2, 2025: 5 @ 40.22
June 3, 2025issueSO-250603-153MAIN 9 38.86-349.78471,890.50 March 26, 2025: 6 @ 38.19; June 2, 2025: 3 @ 40.22
June 2, 2025receiptPO-000598MAIN 50 40.222,011.17562,240.28
May 27, 2025issueSO-250527-192EAST 1 38.19-38.196229.11 March 26, 2025: 1 @ 38.19
May 25, 2025issueSO-250525-680EAST 4 38.19-152.747267.30 March 26, 2025: 4 @ 38.19
May 18, 2025issueSO-250518-734EAST 3 38.19-114.5611420.04 March 26, 2025: 3 @ 38.19
May 18, 2025issueSO-250518-734MAIN 7 38.19-267.3014534.60 March 26, 2025: 7 @ 38.19
May 15, 2025issueSO-250515-535MAIN 1 38.19-38.1921801.90 March 26, 2025: 1 @ 38.19
May 11, 2025issueSO-250511-574MAIN 6 38.19-229.1122840.08 March 26, 2025: 6 @ 38.19
May 10, 2025issueSO-250510-492MAIN 1 38.19-38.19281,069.20 March 26, 2025: 1 @ 38.19
May 1, 2025issueSO-250501-547MAIN 2 38.19-76.37291,107.38 March 26, 2025: 2 @ 38.19
April 25, 2025issueSO-250425-381MAIN 9 38.19-343.67311,183.75 March 26, 2025: 9 @ 38.19
April 17, 2025issueSO-250417-314MAIN 10 38.19-381.86401,527.42 March 26, 2025: 10 @ 38.19
April 5, 2025issueSO-250405-191MAIN 10 38.68-386.84501,909.28 Jan. 19, 2025: 5 @ 39.19; Jan. 20, 2025: 5 @ 38.18
March 31, 2025issueSO-250331-300EAST 2 39.19-78.39602,296.12 Jan. 19, 2025: 2 @ 39.19
March 30, 2025issueSO-250330-306MAIN 2 39.19-78.39622,374.51 Jan. 19, 2025: 2 @ 39.19
March 26, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
March 26, 2025receiptPO-000381MAIN 50 38.191,909.28642,452.90
March 22, 2025issueSO-250322-427MAIN 1 39.19-39.1914543.62 Jan. 19, 2025: 1 @ 39.19
March 14, 2025issueSO-250314-809MAIN 2 39.19-78.3915582.81 Jan. 19, 2025: 2 @ 39.19
March 10, 2025issueSO-250310-112EAST 6 39.19-235.1617661.19 Jan. 19, 2025: 6 @ 39.19
March 1, 2025issueSO-250301-699MAIN 7 39.19-274.3523896.35 Jan. 19, 2025: 7 @ 39.19
Feb. 22, 2025issueSO-250222-642MAIN 12 39.19-470.32301,170.70 Jan. 19, 2025: 12 @ 39.19
Feb. 21, 2025issueSO-250221-728EAST 8 39.19-313.54421,641.02 Jan. 19, 2025: 8 @ 39.19
Feb. 11, 2025issueSO-250211-559MAIN 4 39.19-156.77501,954.57 Jan. 19, 2025: 4 @ 39.19
Jan. 22, 2025issueSO-250122-700MAIN 1 39.19-39.19542,111.34 Jan. 19, 2025: 1 @ 39.19
Jan. 20, 2025returnRMAMAIN 5 38.18190.88552,150.53
Jan. 19, 2025transferTRFMAIN → EAST 15 warehouse transfer, no cost effect
Jan. 19, 2025receiptPO-000197MAIN 50 39.191,959.66501,959.66
Jan. 12, 2025issueSO-250112-983EAST 5 38.18-190.8800.00 Nov. 19, 2024: 5 @ 38.18
Jan. 11, 2025issueSO-250111-237MAIN 11 38.18-419.935190.88 Nov. 19, 2024: 11 @ 38.18
Jan. 3, 2025issueSO-250103-124MAIN 8 38.18-305.4016610.81 Nov. 19, 2024: 8 @ 38.18
Dec. 31, 2024issueSO-241231-549EAST 9 38.18-343.5824916.21 Nov. 19, 2024: 9 @ 38.18
Dec. 20, 2024issueSO-241220-678MAIN 14 38.18-534.46331,259.79 Nov. 19, 2024: 14 @ 38.18
Dec. 17, 2024issueSO-241217-550MAIN 3 38.18-114.53471,794.25 Nov. 19, 2024: 3 @ 38.18
Nov. 19, 2024transferTRFMAIN → EAST 14 warehouse transfer, no cost effect
Nov. 19, 2024receiptPO-000040MAIN 50 38.181,908.78501,908.78
Nov. 7, 2024issueSO-241107-881EAST 9 39.89-359.0100.00 Oct. 1, 2024: 9 @ 39.89
Nov. 7, 2024issueSO-241107-881MAIN 5 39.89-199.459359.01 Oct. 1, 2024: 5 @ 39.89
Nov. 5, 2024issueSO-241105-437MAIN 11 39.89-438.8014558.47 Oct. 1, 2024: 11 @ 39.89
Oct. 20, 2024issueSO-241020-637MAIN 4 39.89-159.5625997.26 Oct. 1, 2024: 4 @ 39.89
Oct. 19, 2024issueSO-241019-806MAIN 1 39.89-39.89291,156.82 Oct. 1, 2024: 1 @ 39.89
Oct. 17, 2024issueSO-241017-265MAIN 11 39.89-438.80301,196.72 Oct. 1, 2024: 11 @ 39.89
Oct. 11, 2024issueSO-241011-676MAIN 1 39.89-39.89411,635.51 Oct. 1, 2024: 1 @ 39.89
Oct. 4, 2024issueSO-241004-562EAST 3 39.89-119.67421,675.40 Oct. 1, 2024: 3 @ 39.89
Oct. 3, 2024issueSO-241003-625MAIN 5 39.89-199.45451,795.07 Oct. 1, 2024: 5 @ 39.89
Oct. 1, 2024transferTRFMAIN → EAST 12 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 50 39.891,994.52501,994.52