stocksense

Items / CAB-0025

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

On hand (COIL)22MAIN 22
Value (FIFO)934.84avg 42.49
ClassBX / FCV 0.16
Turnover34.2xlast issue 5 days ago
Days of cover12lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00250.020.641.261.982.5Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 57.0Nov 24: 49.0Dec 24: 63.0Jan 25: 71.0Feb 25: 52.0Mar 25: 40.0Apr 25: 59.0May 25: 69.0Jun 25: 56.0Jul 25: 75.0Aug 25: 54.0Sep 25: 30.0Oct 25: 45.0Nov 25: 43.0Dec 25: 55.0Jan 26: 59.0Feb 26: 69.0Mar 26: 62.0Apr 26: 61.0May 26: 65.0Jun 26: 50.0Jul 26: 64.0Aug 26: 44.0Sep 26: 69.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.437557.17 / 30.43751.878
Daily demand sdmonthly sd / sqrt(30.4375)9.16 / 5.5171.661
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 * 1.661^2 + 1.878^2 * 3.1^2)14.0
Reorder pointd * LT + safety stock1.878 * 14.0 + 14.040.4
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days40.4
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 686/yr, S = 45.00, h = 20%, price = 39.48480.0
Inventory positionon hand + on order22 + 022

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

From qtyUnit costOrder qtyAnnual costFeasible
042.918530,144yes
24041.1924029,357yes
48039.4848029,022yes (chosen if cheapest)

MOQ 120, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 28, 202615 / 12042.49637.39
Sept. 25, 20267 / 742.49297.45

Movement ledger 139 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 11, 2026issueSO-261011-458MAIN 21 42.49-892.3522934.84 Aug. 28, 2026: 21 @ 42.49
Oct. 10, 2026issueSO-261010-208MAIN 11 42.49-467.42431,827.19 Aug. 28, 2026: 11 @ 42.49
Oct. 7, 2026issueSO-261007-898MAIN 25 42.49-1,062.32542,294.62 Aug. 28, 2026: 25 @ 42.49
Sept. 25, 2026returnRMAMAIN 7 42.49297.45793,356.94
Sept. 24, 2026issueSO-260924-268MAIN 1 42.49-42.49723,059.49 Aug. 28, 2026: 1 @ 42.49
Sept. 21, 2026issueSO-260921-399MAIN 13 42.49-552.41733,101.98 Aug. 28, 2026: 13 @ 42.49
Sept. 20, 2026issueSO-260920-433MAIN 14 42.49-594.90863,654.39 Aug. 28, 2026: 14 @ 42.49
Sept. 17, 2026issueSO-260917-141MAIN 15 42.49-637.391004,249.29 Aug. 28, 2026: 15 @ 42.49
Sept. 4, 2026issueSO-260904-290MAIN 10 42.73-427.331154,886.68 June 24, 2026: 5 @ 42.97; Aug. 28, 2026: 5 @ 42.49
Sept. 1, 2026issueSO-260901-357MAIN 23 42.97-988.371255,314.01 June 24, 2026: 23 @ 42.97
Aug. 29, 2026issueSO-260829-924MAIN 6 42.97-257.841486,302.39 June 24, 2026: 6 @ 42.97
Aug. 28, 2026receiptPO-001752MAIN 120 42.495,099.151546,560.22
Aug. 24, 2026issueSO-260824-653MAIN 1 42.97-42.97341,461.08 June 24, 2026: 1 @ 42.97
Aug. 14, 2026issueSO-260814-794MAIN 37 42.97-1,589.99351,504.05 June 24, 2026: 37 @ 42.97
July 30, 2026issueSO-260730-431MAIN 8 42.97-343.78723,094.04 June 24, 2026: 8 @ 42.97
July 23, 2026issueSO-260723-608MAIN 9 42.97-386.76803,437.82 June 24, 2026: 9 @ 42.97
July 22, 2026issueSO-260722-850MAIN 1 42.97-42.97893,824.58 June 24, 2026: 1 @ 42.97
July 21, 2026issueSO-260721-160MAIN 6 42.97-257.84903,867.55 June 24, 2026: 6 @ 42.97
July 21, 2026issueSO-260721-160EAST 6 42.97-257.84964,125.39 June 24, 2026: 6 @ 42.97
July 8, 2026issueSO-260708-570MAIN 7 42.97-300.811024,383.23 June 24, 2026: 7 @ 42.97
July 7, 2026issueSO-260707-235MAIN 22 41.96-923.031094,684.04 April 22, 2026: 11 @ 40.94; June 24, 2026: 11 @ 42.97
July 1, 2026issueSO-260701-826MAIN 5 40.94-204.691315,607.06 April 22, 2026: 5 @ 40.94
June 24, 2026receiptPO-001599MAIN 120 42.975,156.741365,811.75
June 20, 2026issueSO-260620-415MAIN 11 40.94-450.3216655.02 April 22, 2026: 11 @ 40.94
June 9, 2026issueSO-260609-529EAST 23 40.94-941.59271,105.34 April 22, 2026: 23 @ 40.94
June 7, 2026issueSO-260607-142MAIN 10 40.94-409.39502,046.93 April 22, 2026: 10 @ 40.94
June 6, 2026issueSO-260606-184MAIN 6 40.94-245.63602,456.32 April 22, 2026: 6 @ 40.94
May 30, 2026issueSO-260530-540EAST 1 40.94-40.94662,701.95 April 22, 2026: 1 @ 40.94
May 25, 2026issueSO-260525-366MAIN 22 40.94-900.65672,742.89 April 22, 2026: 22 @ 40.94
May 20, 2026issueSO-260520-949MAIN 8 40.94-327.51893,643.54 April 22, 2026: 8 @ 40.94
May 19, 2026issueSO-260519-402MAIN 5 40.94-204.69973,971.04 April 22, 2026: 5 @ 40.94
May 9, 2026issueSO-260509-475MAIN 1 40.94-40.941024,175.74 April 22, 2026: 1 @ 40.94
May 6, 2026issueSO-260506-106MAIN 28 40.90-1,145.201034,216.68 Feb. 27, 2026: 11 @ 40.84; April 22, 2026: 17 @ 40.94
April 22, 2026issueSO-260422-492MAIN 14 40.84-571.771315,361.88 Feb. 27, 2026: 14 @ 40.84
April 22, 2026transferTRFMAIN → EAST 30 warehouse transfer, no cost effect
April 22, 2026receiptPO-001430MAIN 120 40.944,912.631455,933.65
April 12, 2026issueSO-260412-103MAIN 2 40.84-81.68251,021.02 Feb. 27, 2026: 2 @ 40.84
April 11, 2026issueSO-260411-133MAIN 39 40.84-1,592.78271,102.70 Feb. 27, 2026: 39 @ 40.84
April 1, 2026issueSO-260401-120MAIN 6 40.84-245.04662,695.48 Feb. 27, 2026: 6 @ 40.84
March 20, 2026issueSO-260320-585MAIN 1 40.84-40.84722,940.52 Feb. 27, 2026: 1 @ 40.84
March 11, 2026issueSO-260311-768MAIN 7 40.84-285.88732,981.36 Feb. 27, 2026: 7 @ 40.84
March 7, 2026issueSO-260307-920MAIN 34 40.84-1,388.58803,267.25 Feb. 27, 2026: 34 @ 40.84
March 2, 2026issueSO-260302-211MAIN 11 41.16-452.741144,655.83 Dec. 31, 2025: 5 @ 41.54; Feb. 27, 2026: 6 @ 40.84
March 1, 2026issueSO-260301-597MAIN 9 41.54-373.861255,108.57 Dec. 31, 2025: 9 @ 41.54
Feb. 27, 2026receiptPO-001264MAIN 120 40.844,900.871345,482.43
Feb. 14, 2026issueSO-260214-818MAIN 39 41.54-1,620.0514581.56 Dec. 31, 2025: 39 @ 41.54
Feb. 3, 2026issueSO-260203-588MAIN 30 41.54-1,246.19532,201.60 Dec. 31, 2025: 30 @ 41.54
Jan. 26, 2026issueSO-260126-291MAIN 45 41.52-1,868.59833,447.80 Dec. 7, 2025: 8 @ 41.45; Dec. 31, 2025: 37 @ 41.54
Jan. 13, 2026issueSO-260113-235MAIN 10 41.45-414.521285,316.38 Oct. 29, 2025: 10 @ 41.45
Jan. 4, 2026issueSO-260104-457MAIN 4 41.45-165.811385,730.91 Oct. 29, 2025: 4 @ 41.45
Dec. 31, 2025receiptPO-001107MAIN 120 41.544,984.761425,896.72
Dec. 29, 2025issueSO-251229-257MAIN 3 41.45-124.3622911.95 Oct. 29, 2025: 3 @ 41.45
Dec. 24, 2025issueSO-251224-336MAIN 1 41.45-41.45251,036.31 Oct. 29, 2025: 1 @ 41.45
Dec. 22, 2025issueSO-251222-157MAIN 21 41.45-870.50261,077.76 Oct. 29, 2025: 21 @ 41.45
Dec. 20, 2025issueSO-251220-877MAIN 17 41.45-704.69471,948.26 Oct. 29, 2025: 17 @ 41.45
Dec. 20, 2025issueSO-251220-877EAST 12 41.45-497.43642,652.95 Oct. 29, 2025: 12 @ 41.45
Dec. 7, 2025returnRMAMAIN 8 41.45331.62763,150.38
Dec. 1, 2025issueSO-251201-157EAST 9 41.45-373.07682,818.76 Oct. 29, 2025: 9 @ 41.45
Nov. 29, 2025issueSO-251129-831MAIN 23 41.45-953.41773,191.83 Oct. 29, 2025: 23 @ 41.45
Nov. 24, 2025issueSO-251124-482EAST 16 41.45-663.241004,145.24 Oct. 29, 2025: 16 @ 41.45
Nov. 14, 2025issueSO-251114-433MAIN 4 41.45-165.811164,808.48 Oct. 29, 2025: 4 @ 41.45
Oct. 29, 2025transferTRFMAIN → EAST 37 warehouse transfer, no cost effect
Oct. 29, 2025receiptPO-000959MAIN 120 41.454,974.291204,974.29
Oct. 25, 2025issueSO-251025-521MAIN 2 41.47-82.9300.00 Aug. 2, 2025: 2 @ 41.47
Oct. 22, 2025issueSO-251022-346MAIN 1 41.47-41.47282.93 Aug. 2, 2025: 1 @ 41.47
Oct. 21, 2025issueSO-251021-180MAIN 19 41.47-787.873124.40 Aug. 2, 2025: 19 @ 41.47
Oct. 16, 2025issueSO-251016-472MAIN 22 41.47-912.2722912.27 Aug. 2, 2025: 22 @ 41.47
Oct. 6, 2025issueSO-251006-965MAIN 1 41.47-41.47441,824.53 Aug. 2, 2025: 1 @ 41.47
Sept. 28, 2025issueSO-250928-358MAIN 19 41.47-787.87451,866.00 Aug. 2, 2025: 19 @ 41.47
Sept. 26, 2025issueSO-250926-605MAIN 1 41.47-41.47642,653.86 Aug. 2, 2025: 1 @ 41.47
Sept. 4, 2025issueSO-250904-679MAIN 10 41.47-414.67652,695.33 Aug. 2, 2025: 10 @ 41.47
Aug. 31, 2025issueSO-250831-742MAIN 13 41.47-539.07753,110.00 Aug. 2, 2025: 13 @ 41.47
Aug. 30, 2025issueSO-250830-872MAIN 3 41.47-124.40883,649.06 Aug. 2, 2025: 3 @ 41.47
Aug. 17, 2025issueSO-250817-425MAIN 1 41.47-41.47913,773.46 Aug. 2, 2025: 1 @ 41.47
Aug. 13, 2025issueSO-250813-384MAIN 1 41.47-41.47923,814.93 Aug. 2, 2025: 1 @ 41.47
Aug. 12, 2025issueSO-250812-602MAIN 2 41.47-82.93933,856.39 Aug. 2, 2025: 2 @ 41.47
Aug. 4, 2025issueSO-250804-522MAIN 26 41.40-1,076.31953,939.33 May 29, 2025: 1 @ 39.64; Aug. 2, 2025: 25 @ 41.47
Aug. 3, 2025issueSO-250803-165MAIN 8 39.64-317.121215,015.63 May 29, 2025: 8 @ 39.64
Aug. 2, 2025receiptPO-000749MAIN 120 41.474,975.991295,332.75
July 29, 2025issueSO-250729-895MAIN 28 39.64-1,109.939356.76 May 29, 2025: 28 @ 39.64
July 22, 2025issueSO-250722-735MAIN 15 39.64-594.60371,466.69 May 29, 2025: 15 @ 39.64
July 20, 2025issueSO-250720-275MAIN 32 39.64-1,268.49522,061.29 May 29, 2025: 32 @ 39.64
June 29, 2025issueSO-250629-322MAIN 5 39.64-198.20843,329.78 May 29, 2025: 5 @ 39.64
June 22, 2025issueSO-250622-454MAIN 31 39.64-1,228.85893,527.98 May 29, 2025: 31 @ 39.64
June 17, 2025issueSO-250617-790MAIN 9 39.84-358.591204,756.82 April 8, 2025: 8 @ 39.84; May 6, 2025: 1 @ 39.84
June 10, 2025issueSO-250610-213MAIN 6 39.84-239.061295,115.41 April 8, 2025: 6 @ 39.84
June 3, 2025issueSO-250603-994MAIN 3 39.84-119.531355,354.47 April 8, 2025: 3 @ 39.84
June 2, 2025issueSO-250602-460MAIN 2 39.84-79.691385,474.00 April 8, 2025: 2 @ 39.84
May 29, 2025receiptPO-000586MAIN 120 39.644,756.821405,553.69
May 21, 2025issueSO-250521-134MAIN 11 39.84-438.2820796.86 April 8, 2025: 11 @ 39.84
May 15, 2025issueSO-250515-440MAIN 13 39.84-517.96311,235.14 April 8, 2025: 13 @ 39.84
May 9, 2025issueSO-250509-346MAIN 26 39.84-1,035.92441,753.10 April 8, 2025: 26 @ 39.84
May 6, 2025returnRMAMAIN 1 39.8439.84702,789.02
May 5, 2025issueSO-250505-753MAIN 20 39.84-796.86692,749.18 April 8, 2025: 20 @ 39.84
April 29, 2025issueSO-250429-581MAIN 3 39.84-119.53893,546.04 April 8, 2025: 3 @ 39.84
April 26, 2025issueSO-250426-696MAIN 1 39.84-39.84923,665.57 April 8, 2025: 1 @ 39.84
April 19, 2025issueSO-250419-338MAIN 1 39.84-39.84933,705.42 April 8, 2025: 1 @ 39.84
April 14, 2025issueSO-250414-747MAIN 9 39.84-358.59943,745.26 April 8, 2025: 9 @ 39.84
April 11, 2025issueSO-250411-124MAIN 33 39.56-1,305.451034,103.85 Feb. 1, 2025: 8 @ 39.26; March 8, 2025: 8 @ 39.26; April 8, 2025: 17 @ 39.84
April 9, 2025issueSO-250409-883MAIN 10 39.26-392.571365,409.30 Feb. 1, 2025: 10 @ 39.26
April 8, 2025issueSO-250408-745MAIN 2 39.26-78.511465,801.87 Feb. 1, 2025: 2 @ 39.26
April 8, 2025receiptPO-000423MAIN 120 39.844,781.181485,880.38
March 26, 2025issueSO-250326-689MAIN 25 39.26-981.43281,099.20 Feb. 1, 2025: 25 @ 39.26
March 17, 2025issueSO-250317-228MAIN 1 39.26-39.26532,080.63 Feb. 1, 2025: 1 @ 39.26
March 14, 2025issueSO-250314-274MAIN 2 39.26-78.51542,119.88 Feb. 1, 2025: 2 @ 39.26
March 11, 2025issueSO-250311-865MAIN 4 39.26-157.03562,198.40 Feb. 1, 2025: 4 @ 39.26
March 8, 2025returnRMAMAIN 8 39.26314.06602,355.43
March 4, 2025issueSO-250304-431MAIN 4 39.26-157.03522,041.37 Feb. 1, 2025: 4 @ 39.26
March 2, 2025issueSO-250302-934MAIN 12 39.26-471.09562,198.40 Feb. 1, 2025: 12 @ 39.26
Feb. 27, 2025issueSO-250227-502MAIN 10 39.26-392.57682,669.48 Feb. 1, 2025: 10 @ 39.26
Feb. 21, 2025issueSO-250221-563MAIN 4 39.26-157.03783,062.05 Feb. 1, 2025: 4 @ 39.26
Feb. 20, 2025issueSO-250220-529MAIN 15 39.26-588.86823,219.08 Feb. 1, 2025: 15 @ 39.26
Feb. 16, 2025issueSO-250216-451MAIN 16 39.26-628.11973,807.94 Feb. 1, 2025: 16 @ 39.26
Feb. 13, 2025issueSO-250213-492MAIN 2 39.26-78.511134,436.05 Feb. 1, 2025: 2 @ 39.26
Feb. 11, 2025issueSO-250211-644MAIN 5 39.26-196.291154,514.57 Feb. 1, 2025: 5 @ 39.26
Feb. 1, 2025receiptPO-000232MAIN 120 39.264,710.851204,710.85
Jan. 29, 2025issueSO-250129-271MAIN 1 40.76-40.7600.00 Dec. 5, 2024: 1 @ 40.76
Jan. 27, 2025issueSO-250127-416MAIN 7 40.63-284.38140.76 Dec. 3, 2024: 1 @ 39.80; Dec. 5, 2024: 6 @ 40.76
Jan. 20, 2025issueSO-250120-815MAIN 18 39.80-716.328325.15 Dec. 3, 2024: 18 @ 39.80
Jan. 19, 2025issueSO-250119-928MAIN 13 39.80-517.34261,041.46 Dec. 3, 2024: 13 @ 39.80
Jan. 15, 2025issueSO-250115-535MAIN 22 39.80-875.50391,558.80 Dec. 3, 2024: 22 @ 39.80
Jan. 10, 2025issueSO-250110-436MAIN 10 39.80-397.95612,434.30 Dec. 3, 2024: 10 @ 39.80
Dec. 21, 2024issueSO-241221-339MAIN 11 39.80-437.75712,832.26 Dec. 3, 2024: 11 @ 39.80
Dec. 15, 2024issueSO-241215-665MAIN 15 39.80-596.93823,270.01 Dec. 3, 2024: 15 @ 39.80
Dec. 14, 2024issueSO-241214-647MAIN 8 39.80-318.36973,866.94 Dec. 3, 2024: 8 @ 39.80
Dec. 13, 2024issueSO-241213-648MAIN 19 39.80-756.111054,185.30 Dec. 3, 2024: 19 @ 39.80
Dec. 12, 2024issueSO-241212-714MAIN 17 40.59-690.091244,941.41 Oct. 1, 2024: 14 @ 40.76; Dec. 3, 2024: 3 @ 39.80
Dec. 5, 2024returnRMAMAIN 7 40.76285.351415,631.50
Dec. 3, 2024receiptPO-000077MAIN 120 39.804,775.451345,346.15
Nov. 29, 2024issueSO-241129-447MAIN 4 40.76-163.0614570.70 Oct. 1, 2024: 4 @ 40.76
Nov. 22, 2024issueSO-241122-479MAIN 4 40.76-163.0618733.76 Oct. 1, 2024: 4 @ 40.76
Nov. 18, 2024issueSO-241118-942MAIN 27 40.76-1,100.6422896.82 Oct. 1, 2024: 27 @ 40.76
Nov. 17, 2024issueSO-241117-643MAIN 14 40.76-570.70491,997.46 Oct. 1, 2024: 14 @ 40.76
Oct. 29, 2024issueSO-241029-522MAIN 4 40.76-163.06632,568.16 Oct. 1, 2024: 4 @ 40.76
Oct. 27, 2024issueSO-241027-177MAIN 8 40.76-326.12672,731.22 Oct. 1, 2024: 8 @ 40.76
Oct. 11, 2024issueSO-241011-791MAIN 11 40.76-448.41753,057.34 Oct. 1, 2024: 11 @ 40.76
Oct. 8, 2024issueSO-241008-158MAIN 22 40.76-896.82863,505.75 Oct. 1, 2024: 22 @ 40.76
Oct. 1, 2024issueSO-241001-398MAIN 12 40.76-489.171084,402.57 Oct. 1, 2024: 12 @ 40.76
Oct. 1, 2024receiptPO-000002MAIN 120 40.764,891.741204,891.74