stocksense

Items / CAB-0031

Flexible Cable 3 core Nova CAB-0031 · Cables & Wires · Conduit & Cable Co

On hand (COIL)97MAIN 97
Value (FIFO)26,400.89avg 272.17
ClassAX / FCV 0.19
Turnover7.1xlast issue 4 days ago
Days of cover46lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00310.027.053.980.9108Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 43.0Nov 24: 98.0Dec 24: 83.0Jan 25: 46.0Feb 25: 55.0Mar 25: 65.0Apr 25: 60.0May 25: 43.0Jun 25: 88.0Jul 25: 59.0Aug 25: 56.0Sep 25: 71.0Oct 25: 41.0Nov 25: 59.0Dec 25: 76.0Jan 26: 74.0Feb 26: 71.0Mar 26: 72.0Apr 26: 86.0May 26: 54.0Jun 26: 68.0Jul 26: 45.0Aug 26: 65.0Sep 26: 66.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.437564.75 / 30.43752.127
Daily demand sdmonthly sd / sqrt(30.4375)12.48 / 5.5172.263
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 * 2.263^2 + 2.127^2 * 3.1^2)22.1
Reorder pointd * LT + safety stock2.127 * 14.0 + 22.151.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days51.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 776/yr, S = 45.00, h = 20%, price = 255.63520.0
Inventory positionon hand + on order97 + 097

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

From qtyUnit costOrder qtyAnnual costFeasible
0277.8635217,720yes
260266.75260214,189yes
520255.63520211,850yes (chosen if cheapest)

MOQ 130, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 3, 202697 / 130272.1726,400.89

Movement ledger 136 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 12, 2026issueSO-261012-225MAIN 34 272.04-9,249.239726,400.89 July 21, 2026: 1 @ 267.48; Oct. 3, 2026: 33 @ 272.17
Oct. 8, 2026issueSO-261008-106MAIN 7 267.48-1,872.3713135,650.11 July 21, 2026: 7 @ 267.48
Oct. 3, 2026receiptPO-001846MAIN 130 272.1735,382.6313837,522.48
Oct. 1, 2026issueSO-261001-870MAIN 8 267.48-2,139.8582,139.85 July 21, 2026: 8 @ 267.48
Sept. 29, 2026issueSO-260929-208MAIN 1 267.48-267.48164,279.70 July 21, 2026: 1 @ 267.48
Sept. 22, 2026issueSO-260922-196MAIN 45 267.48-12,036.66174,547.18 July 21, 2026: 45 @ 267.48
Sept. 14, 2026issueSO-260914-662MAIN 5 267.48-1,337.416216,583.84 July 21, 2026: 5 @ 267.48
Sept. 6, 2026issueSO-260906-931MAIN 15 267.48-4,012.226717,921.25 July 21, 2026: 15 @ 267.48
Aug. 11, 2026issueSO-260811-632MAIN 13 267.48-3,477.268221,933.47 July 21, 2026: 13 @ 267.48
Aug. 3, 2026issueSO-260803-453MAIN 6 267.48-1,604.899525,410.72 July 21, 2026: 6 @ 267.48
Aug. 3, 2026issueSO-260803-453EAST 46 268.11-12,333.1710127,015.61 June 1, 2026: 17 @ 269.19; July 21, 2026: 29 @ 267.48
July 29, 2026issueSO-260729-799EAST 8 269.19-2,153.5114739,348.78 June 1, 2026: 8 @ 269.19
July 21, 2026transferTRFMAIN → EAST 39 warehouse transfer, no cost effect
July 21, 2026receiptPO-001658MAIN 130 267.4834,772.5715541,502.29
July 20, 2026issueSO-260720-367MAIN 4 269.19-1,076.76256,729.72 June 1, 2026: 4 @ 269.19
July 5, 2026issueSO-260705-778MAIN 1 269.19-269.19297,806.48 June 1, 2026: 1 @ 269.19
July 2, 2026issueSO-260702-189MAIN 30 269.19-8,075.67308,075.67 June 1, 2026: 30 @ 269.19
July 1, 2026issueSO-260701-735EAST 2 269.19-538.386016,151.34 June 1, 2026: 2 @ 269.19
June 26, 2026issueSO-260626-775MAIN 21 269.19-5,652.976216,689.72 June 1, 2026: 21 @ 269.19
June 22, 2026issueSO-260622-654MAIN 4 269.19-1,076.768322,342.69 June 1, 2026: 4 @ 269.19
June 21, 2026issueSO-260621-200MAIN 5 269.19-1,345.948723,419.44 June 1, 2026: 5 @ 269.19
June 13, 2026issueSO-260613-947MAIN 13 269.19-3,499.469224,765.39 June 1, 2026: 13 @ 269.19
June 12, 2026issueSO-260612-581MAIN 6 269.19-1,615.1310528,264.84 June 1, 2026: 6 @ 269.19
June 11, 2026issueSO-260611-403MAIN 9 269.19-2,422.7011129,879.98 June 1, 2026: 9 @ 269.19
June 5, 2026issueSO-260605-451EAST 10 269.19-2,691.8912032,302.68 June 1, 2026: 10 @ 269.19
June 1, 2026transferTRFMAIN → EAST 27 warehouse transfer, no cost effect
June 1, 2026receiptPO-001538MAIN 130 269.1934,994.5713034,994.57
May 23, 2026issueSO-260523-910MAIN 5 278.43-1,392.1300.00 March 17, 2026: 5 @ 278.43
May 18, 2026issueSO-260518-513MAIN 17 278.43-4,733.2651,392.13 March 17, 2026: 17 @ 278.43
May 9, 2026issueSO-260509-958MAIN 32 278.43-8,909.66226,125.39 March 17, 2026: 32 @ 278.43
April 27, 2026issueSO-260427-654MAIN 6 278.43-1,670.565415,035.05 March 17, 2026: 6 @ 278.43
April 18, 2026issueSO-260418-188MAIN 5 278.43-1,392.136016,705.61 March 17, 2026: 5 @ 278.43
April 18, 2026issueSO-260418-188EAST 35 278.43-9,744.946518,097.74 March 17, 2026: 35 @ 278.43
April 6, 2026issueSO-260406-166MAIN 34 276.68-9,407.0310027,842.68 Feb. 7, 2026: 4 @ 263.56; March 17, 2026: 30 @ 278.43
April 3, 2026issueSO-260403-581EAST 2 263.56-527.1113437,249.71 Feb. 7, 2026: 2 @ 263.56
April 2, 2026issueSO-260402-331MAIN 4 263.56-1,054.2313637,776.82 Feb. 7, 2026: 4 @ 263.56
March 30, 2026issueSO-260330-765MAIN 27 263.56-7,116.0314038,831.05 Feb. 7, 2026: 27 @ 263.56
March 17, 2026transferTRFMAIN → EAST 37 warehouse transfer, no cost effect
March 17, 2026receiptPO-001326MAIN 130 278.4336,195.4816745,947.08
March 5, 2026issueSO-260305-873MAIN 45 263.56-11,860.05379,751.59 Feb. 7, 2026: 45 @ 263.56
Feb. 22, 2026issueSO-260222-881MAIN 21 263.56-5,534.698221,611.64 Feb. 7, 2026: 21 @ 263.56
Feb. 20, 2026issueSO-260220-273MAIN 33 264.34-8,723.2910327,146.33 Nov. 27, 2025: 6 @ 267.88; Feb. 7, 2026: 27 @ 263.56
Feb. 14, 2026issueSO-260214-943MAIN 3 267.88-803.6313635,869.62 Nov. 27, 2025: 3 @ 267.88
Feb. 14, 2026issueSO-260214-943EAST 11 267.88-2,946.6413936,673.25 Nov. 27, 2025: 11 @ 267.88
Feb. 12, 2026issueSO-260212-750MAIN 3 267.88-803.6315039,619.89 Nov. 27, 2025: 3 @ 267.88
Feb. 7, 2026receiptPO-001206MAIN 130 263.5634,262.3615340,423.52
Jan. 26, 2026issueSO-260126-606MAIN 39 267.88-10,447.18236,161.16 Nov. 27, 2025: 39 @ 267.88
Jan. 16, 2026issueSO-260116-657MAIN 2 267.88-535.756216,608.34 Nov. 27, 2025: 2 @ 267.88
Jan. 10, 2026issueSO-260110-340EAST 10 267.88-2,678.766417,144.09 Nov. 27, 2025: 10 @ 267.88
Jan. 6, 2026issueSO-260106-364EAST 12 267.88-3,214.527419,822.85 Nov. 27, 2025: 12 @ 267.88
Jan. 5, 2026issueSO-260105-950MAIN 8 267.88-2,143.018623,037.37 Nov. 27, 2025: 8 @ 267.88
Jan. 3, 2026issueSO-260103-171MAIN 3 267.88-803.639425,180.38 Nov. 27, 2025: 3 @ 267.88
Dec. 31, 2025issueSO-251231-315EAST 5 267.88-1,339.389725,984.01 Nov. 27, 2025: 5 @ 267.88
Dec. 27, 2025issueSO-251227-987MAIN 26 267.88-6,964.7910227,323.39 Nov. 27, 2025: 26 @ 267.88
Dec. 19, 2025issueSO-251219-627MAIN 33 271.66-8,964.6412834,288.18 Oct. 9, 2025: 31 @ 271.90; Nov. 27, 2025: 2 @ 267.88
Dec. 17, 2025issueSO-251217-788MAIN 2 271.90-543.8016143,252.82 Oct. 9, 2025: 2 @ 271.90
Dec. 14, 2025issueSO-251214-262MAIN 8 271.90-2,175.2016343,796.62 Oct. 9, 2025: 8 @ 271.90
Dec. 9, 2025issueSO-251209-538EAST 2 271.90-543.8017145,971.81 Oct. 9, 2025: 2 @ 271.90
Nov. 27, 2025transferTRFMAIN → EAST 40 warehouse transfer, no cost effect
Nov. 27, 2025receiptPO-001022MAIN 130 267.8834,823.9317346,515.61
Nov. 20, 2025issueSO-251120-870MAIN 2 271.90-543.804311,691.68 Oct. 9, 2025: 2 @ 271.90
Nov. 15, 2025issueSO-251115-918MAIN 9 271.90-2,447.104512,235.48 Oct. 9, 2025: 9 @ 271.90
Nov. 12, 2025issueSO-251112-825MAIN 26 271.90-7,069.395414,682.57 Oct. 9, 2025: 26 @ 271.90
Nov. 10, 2025issueSO-251110-541MAIN 18 271.90-4,894.198021,751.96 Oct. 9, 2025: 18 @ 271.90
Nov. 2, 2025issueSO-251102-760MAIN 4 271.90-1,087.609826,646.15 Oct. 9, 2025: 4 @ 271.90
Oct. 26, 2025issueSO-251026-654MAIN 27 271.90-7,341.2910227,733.75 Oct. 9, 2025: 27 @ 271.90
Oct. 12, 2025issueSO-251012-900MAIN 1 271.90-271.9012935,075.04 Oct. 9, 2025: 1 @ 271.90
Oct. 9, 2025receiptPO-000910MAIN 130 271.9035,346.9413035,346.94
Oct. 4, 2025issueSO-251004-600MAIN 13 256.22-3,330.8700.00 Aug. 5, 2025: 13 @ 256.22
Sept. 30, 2025issueSO-250930-744MAIN 15 256.22-3,843.31133,330.87 Aug. 5, 2025: 15 @ 256.22
Sept. 26, 2025issueSO-250926-680MAIN 13 256.22-3,330.87287,174.17 Aug. 5, 2025: 13 @ 256.22
Sept. 26, 2025issueSO-250926-680EAST 20 256.22-5,124.414110,505.04 Aug. 5, 2025: 20 @ 256.22
Sept. 21, 2025issueSO-250921-711EAST 5 256.22-1,281.106115,629.45 Aug. 5, 2025: 5 @ 256.22
Sept. 8, 2025issueSO-250908-317MAIN 7 256.22-1,793.546616,910.55 Aug. 5, 2025: 7 @ 256.22
Sept. 4, 2025issueSO-250904-250MAIN 3 256.22-768.667318,704.10 Aug. 5, 2025: 3 @ 256.22
Sept. 2, 2025issueSO-250902-691MAIN 8 256.22-2,049.767619,472.76 Aug. 5, 2025: 8 @ 256.22
Aug. 26, 2025issueSO-250826-309EAST 13 256.22-3,330.878421,522.52 Aug. 5, 2025: 13 @ 256.22
Aug. 9, 2025issueSO-250809-226MAIN 21 256.22-5,380.639724,853.39 Aug. 5, 2025: 21 @ 256.22
Aug. 6, 2025issueSO-250806-743MAIN 12 256.22-3,074.6511830,234.02 Aug. 5, 2025: 12 @ 256.22
Aug. 5, 2025transferTRFMAIN → EAST 38 warehouse transfer, no cost effect
Aug. 5, 2025receiptPO-000758MAIN 130 256.2233,308.6613033,308.66
Aug. 4, 2025issueSO-250804-307MAIN 10 266.03-2,660.2600.00 May 30, 2025: 10 @ 266.03
July 21, 2025issueSO-250721-896MAIN 45 266.03-11,971.17102,660.26 May 30, 2025: 45 @ 266.03
July 10, 2025issueSO-250710-589MAIN 13 266.03-3,458.345514,631.43 May 30, 2025: 13 @ 266.03
July 10, 2025issueSO-250710-589EAST 1 266.03-266.036818,089.77 May 30, 2025: 1 @ 266.03
June 14, 2025issueSO-250614-761EAST 11 266.03-2,926.296918,355.79 May 30, 2025: 11 @ 266.03
June 7, 2025issueSO-250607-550MAIN 49 266.03-13,035.278021,282.08 May 30, 2025: 49 @ 266.03
June 6, 2025issueSO-250606-484EAST 5 262.02-1,310.1212934,317.35 May 6, 2025: 4 @ 261.02; May 30, 2025: 1 @ 266.03
June 5, 2025issueSO-250605-270MAIN 2 261.02-522.0513435,627.48 March 26, 2025: 2 @ 261.02
June 3, 2025issueSO-250603-967MAIN 9 261.02-2,349.2113636,149.52 March 26, 2025: 9 @ 261.02
June 1, 2025issueSO-250601-479MAIN 12 261.02-3,132.2914538,498.74 March 26, 2025: 12 @ 261.02
May 30, 2025receiptPO-000589MAIN 130 266.0334,583.3815741,631.02
May 24, 2025issueSO-250524-872MAIN 6 261.02-1,566.14277,047.64 March 26, 2025: 6 @ 261.02
May 23, 2025issueSO-250523-475MAIN 2 261.02-522.05338,613.79 March 26, 2025: 2 @ 261.02
May 22, 2025issueSO-250522-581MAIN 3 261.02-783.07359,135.83 March 26, 2025: 3 @ 261.02
May 17, 2025issueSO-250517-937EAST 14 261.02-3,654.33389,918.90 March 26, 2025: 14 @ 261.02
May 12, 2025issueSO-250512-850MAIN 19 261.02-4,959.455213,573.24 March 26, 2025: 19 @ 261.02
May 9, 2025issueSO-250509-323EAST 1 261.02-261.027118,532.69 March 26, 2025: 1 @ 261.02
May 6, 2025returnRMAMAIN 4 261.021,044.107218,793.71
May 1, 2025issueSO-250501-573MAIN 2 261.02-522.056817,749.62 March 26, 2025: 2 @ 261.02
April 26, 2025issueSO-250426-477EAST 8 261.02-2,088.197018,271.67 March 26, 2025: 8 @ 261.02
April 17, 2025issueSO-250417-880MAIN 24 261.02-6,264.577820,359.86 March 26, 2025: 24 @ 261.02
April 3, 2025issueSO-250403-648MAIN 28 261.02-7,308.6710226,624.43 March 26, 2025: 28 @ 261.02
March 26, 2025transferTRFMAIN → EAST 40 warehouse transfer, no cost effect
March 26, 2025receiptPO-000382MAIN 130 261.0233,933.0913033,933.09
March 19, 2025issueSO-250319-282MAIN 26 253.07-6,579.7600.00 Jan. 9, 2025: 26 @ 253.07
March 19, 2025issueSO-250319-282EAST 10 253.07-2,530.68266,579.76 Jan. 9, 2025: 10 @ 253.07
March 13, 2025issueSO-250313-368MAIN 29 253.07-7,338.97369,110.44 Jan. 9, 2025: 29 @ 253.07
Feb. 24, 2025issueSO-250224-617MAIN 19 253.07-4,808.296516,449.41 Jan. 9, 2025: 19 @ 253.07
Feb. 20, 2025issueSO-250220-864EAST 8 253.07-2,024.548421,257.70 Jan. 9, 2025: 8 @ 253.07
Feb. 7, 2025issueSO-250207-585EAST 10 253.07-2,530.689223,282.24 Jan. 9, 2025: 10 @ 253.07
Feb. 3, 2025issueSO-250203-756MAIN 18 253.07-4,555.2210225,812.92 Jan. 9, 2025: 18 @ 253.07
Jan. 30, 2025issueSO-250130-999MAIN 4 253.07-1,012.2712030,368.14 Jan. 9, 2025: 4 @ 253.07
Jan. 24, 2025issueSO-250124-947MAIN 3 253.07-759.2012431,380.41 Jan. 9, 2025: 3 @ 253.07
Jan. 11, 2025issueSO-250111-851EAST 3 253.07-759.2012732,139.61 Jan. 9, 2025: 3 @ 253.07
Jan. 9, 2025transferTRFMAIN → EAST 31 warehouse transfer, no cost effect
Jan. 9, 2025receiptPO-000175MAIN 130 253.0732,898.8113032,898.81
Jan. 2, 2025issueSO-250102-264MAIN 8 262.28-2,098.2200.00 Nov. 23, 2024: 8 @ 262.28
Jan. 2, 2025issueSO-250102-264EAST 28 262.28-7,343.7782,098.22 Nov. 23, 2024: 28 @ 262.28
Dec. 30, 2024issueSO-241230-809MAIN 8 262.28-2,098.22369,441.99 Nov. 23, 2024: 8 @ 262.28
Dec. 25, 2024issueSO-241225-967MAIN 18 262.28-4,720.994411,540.21 Nov. 23, 2024: 18 @ 262.28
Dec. 14, 2024issueSO-241214-582MAIN 40 262.28-10,491.106216,261.20 Nov. 23, 2024: 40 @ 262.28
Dec. 6, 2024issueSO-241206-719MAIN 17 262.28-4,458.7210226,752.29 Nov. 23, 2024: 17 @ 262.28
Nov. 28, 2024issueSO-241128-708EAST 11 262.28-2,885.0511931,211.01 Nov. 23, 2024: 11 @ 262.28
Nov. 23, 2024transferTRFMAIN → EAST 39 warehouse transfer, no cost effect
Nov. 23, 2024receiptPO-000055MAIN 130 262.2834,096.0613034,096.06
Nov. 14, 2024issueSO-241114-336MAIN 55 263.97-14,518.1800.00 Oct. 1, 2024: 55 @ 263.97
Nov. 3, 2024issueSO-241103-834MAIN 32 263.97-8,446.945514,518.18 Oct. 1, 2024: 32 @ 263.97
Oct. 30, 2024issueSO-241030-998MAIN 2 263.97-527.938722,965.13 Oct. 1, 2024: 2 @ 263.97
Oct. 24, 2024issueSO-241024-586MAIN 12 263.97-3,167.608923,493.06 Oct. 1, 2024: 12 @ 263.97
Oct. 20, 2024issueSO-241020-911MAIN 7 263.97-1,847.7710126,660.67 Oct. 1, 2024: 7 @ 263.97
Oct. 18, 2024issueSO-241018-238MAIN 4 263.97-1,055.8710828,508.44 Oct. 1, 2024: 4 @ 263.97
Oct. 11, 2024issueSO-241011-682MAIN 9 263.97-2,375.7011229,564.30 Oct. 1, 2024: 9 @ 263.97
Oct. 8, 2024issueSO-241008-699MAIN 6 263.97-1,583.8012131,940.01 Oct. 1, 2024: 6 @ 263.97
Oct. 6, 2024issueSO-241006-668MAIN 3 263.97-791.9012733,523.81 Oct. 1, 2024: 3 @ 263.97
Oct. 1, 2024receiptPO-000002MAIN 130 263.9734,315.7113034,315.71