stocksense

Items / CAB-0020

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

On hand (COIL)144MAIN 144
Value (FIFO)10,242.30avg 71.13
ClassAX / FCV 0.23
Turnover11.5xlast issue 0 days ago
Days of cover40lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00200.050.6101152202Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 107.0Nov 24: 80.0Dec 24: 112.0Jan 25: 112.0Feb 25: 91.0Mar 25: 133.0Apr 25: 161.0May 25: 124.0Jun 25: 184.0Jul 25: 108.0Aug 25: 104.0Sep 25: 92.0Oct 25: 117.0Nov 25: 92.0Dec 25: 129.0Jan 26: 92.0Feb 26: 141.0Mar 26: 78.0Apr 26: 154.0May 26: 95.0Jun 26: 135.0Jul 26: 87.0Aug 26: 78.0Sep 26: 126.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.4375110.33 / 30.43753.625
Daily demand sdmonthly sd / sqrt(30.4375)25.23 / 5.5174.573
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 * 4.573^2 + 3.625^2 * 3.1^2)42.1
Reorder pointd * LT + safety stock3.625 * 14.0 + 42.193.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days93.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1323/yr, S = 45.00, h = 20%, price = 67.31920.0
Inventory positionon hand + on order144 + 0144

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

From qtyUnit costOrder qtyAnnual costFeasible
073.169098,118yes
46070.2346096,286yes
92067.3192095,311yes (chosen if cheapest)

MOQ 230, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 17, 2026144 / 23071.1310,242.30

Movement ledger 119 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-799MAIN 1 71.13-71.1314410,242.30 Sept. 17, 2026: 1 @ 71.13
Oct. 9, 2026issueSO-261009-603MAIN 12 71.13-853.5314510,313.43 Sept. 17, 2026: 12 @ 71.13
Oct. 4, 2026issueSO-261004-226MAIN 9 71.13-640.1415711,166.95 Sept. 17, 2026: 9 @ 71.13
Oct. 2, 2026issueSO-261002-863MAIN 56 71.13-3,983.1216611,807.10 Sept. 17, 2026: 56 @ 71.13
Oct. 1, 2026issueSO-261001-709MAIN 34 71.05-2,415.8522215,790.22 July 29, 2026: 26 @ 71.03; Sept. 17, 2026: 8 @ 71.13
Sept. 17, 2026issueSO-260917-451MAIN 26 71.03-1,846.8425618,206.07 July 29, 2026: 26 @ 71.03
Sept. 17, 2026receiptPO-001807MAIN 230 71.1316,359.2328220,052.91
Sept. 9, 2026issueSO-260909-925MAIN 4 71.03-284.13523,693.67 July 29, 2026: 4 @ 71.03
Sept. 2, 2026issueSO-260902-345MAIN 96 71.03-6,819.09563,977.80 July 29, 2026: 96 @ 71.03
Aug. 26, 2026issueSO-260826-999MAIN 32 71.03-2,273.0315210,796.89 July 29, 2026: 32 @ 71.03
Aug. 19, 2026issueSO-260819-341MAIN 32 71.03-2,273.0318413,069.92 July 29, 2026: 32 @ 71.03
Aug. 18, 2026issueSO-260818-187MAIN 7 71.03-497.2321615,342.96 July 29, 2026: 7 @ 71.03
Aug. 4, 2026issueSO-260804-709MAIN 7 71.03-497.2322315,840.18 July 29, 2026: 7 @ 71.03
July 29, 2026receiptPO-001684MAIN 230 71.0316,337.4123016,337.41
July 24, 2026issueSO-260724-341MAIN 12 72.35-868.2100.00 May 29, 2026: 12 @ 72.35
July 23, 2026issueSO-260723-270MAIN 60 72.35-4,341.0712868.21 May 29, 2026: 60 @ 72.35
July 18, 2026issueSO-260718-249MAIN 11 72.35-795.86725,209.28 May 29, 2026: 11 @ 72.35
July 16, 2026issueSO-260716-438MAIN 4 72.35-289.40836,005.14 May 29, 2026: 4 @ 72.35
June 25, 2026issueSO-260625-126MAIN 39 72.35-2,821.69876,294.55 May 29, 2026: 39 @ 72.35
June 21, 2026issueSO-260621-815MAIN 31 72.35-2,242.881269,116.24 May 29, 2026: 31 @ 72.35
June 16, 2026issueSO-260616-151MAIN 62 72.35-4,485.7715711,359.12 May 29, 2026: 62 @ 72.35
June 3, 2026issueSO-260603-413MAIN 3 72.35-217.0521915,844.89 May 29, 2026: 3 @ 72.35
May 31, 2026issueSO-260531-660MAIN 3 72.35-217.0522216,061.94 May 29, 2026: 3 @ 72.35
May 29, 2026issueSO-260529-503MAIN 24 71.68-1,720.2222516,279.00 March 25, 2026: 19 @ 71.50; May 29, 2026: 5 @ 72.35
May 29, 2026receiptPO-001529MAIN 230 72.3516,640.7524917,999.22
May 17, 2026issueSO-260517-711MAIN 48 71.50-3,431.91191,358.46 March 25, 2026: 48 @ 71.50
May 17, 2026issueSO-260517-711EAST 20 71.50-1,429.96674,790.37 March 25, 2026: 20 @ 71.50
April 29, 2026issueSO-260429-334MAIN 27 71.50-1,930.45876,220.33 March 25, 2026: 27 @ 71.50
April 19, 2026issueSO-260419-297MAIN 127 71.28-9,052.471148,150.78 Feb. 2, 2026: 11 @ 68.97; March 25, 2026: 116 @ 71.50
March 26, 2026issueSO-260326-166MAIN 18 68.97-1,241.5024117,203.26 Feb. 2, 2026: 18 @ 68.97
March 25, 2026receiptPO-001350MAIN 230 71.5016,444.5625918,444.75
March 21, 2026issueSO-260321-957MAIN 28 68.97-1,931.22292,000.19 Feb. 2, 2026: 28 @ 68.97
March 16, 2026issueSO-260316-945EAST 28 68.97-1,931.22573,931.41 Feb. 2, 2026: 28 @ 68.97
March 14, 2026issueSO-260314-181MAIN 4 68.97-275.89855,862.63 Feb. 2, 2026: 4 @ 68.97
Feb. 26, 2026issueSO-260226-519MAIN 5 68.97-344.86896,138.52 Feb. 2, 2026: 5 @ 68.97
Feb. 14, 2026issueSO-260214-360MAIN 31 68.97-2,138.14946,483.38 Feb. 2, 2026: 31 @ 68.97
Feb. 5, 2026issueSO-260205-551MAIN 105 68.97-7,242.071258,621.51 Feb. 2, 2026: 105 @ 68.97
Feb. 2, 2026transferTRFMAIN → EAST 48 warehouse transfer, no cost effect
Feb. 2, 2026receiptPO-001193MAIN 230 68.9715,863.5823015,863.58
Jan. 26, 2026issueSO-260126-341MAIN 75 72.32-5,424.3400.00 Nov. 26, 2025: 75 @ 72.32
Jan. 22, 2026issueSO-260122-684MAIN 7 72.32-506.27755,424.34 Nov. 26, 2025: 7 @ 72.32
Jan. 5, 2026issueSO-260105-461MAIN 10 72.32-723.25825,930.62 Nov. 26, 2025: 10 @ 72.32
Dec. 29, 2025issueSO-251229-519MAIN 11 72.32-795.57926,653.86 Nov. 26, 2025: 11 @ 72.32
Dec. 22, 2025issueSO-251222-547MAIN 10 72.32-723.251037,449.43 Nov. 26, 2025: 10 @ 72.32
Dec. 17, 2025issueSO-251217-855MAIN 19 72.32-1,374.171138,172.68 Nov. 26, 2025: 19 @ 72.32
Dec. 15, 2025issueSO-251215-615MAIN 62 72.32-4,484.131329,546.85 Nov. 26, 2025: 62 @ 72.32
Dec. 1, 2025issueSO-251201-987MAIN 27 72.32-1,952.7619414,030.97 Nov. 26, 2025: 27 @ 72.32
Nov. 30, 2025issueSO-251130-980MAIN 9 72.32-650.9222115,983.74 Nov. 26, 2025: 9 @ 72.32
Nov. 26, 2025receiptPO-001019MAIN 230 72.3216,634.6623016,634.66
Nov. 23, 2025issueSO-251123-291MAIN 26 68.50-1,780.9400.00 Sept. 9, 2025: 26 @ 68.50
Nov. 17, 2025issueSO-251117-957MAIN 5 68.50-342.49261,780.94 Sept. 9, 2025: 5 @ 68.50
Nov. 9, 2025issueSO-251109-815MAIN 52 68.50-3,561.87312,123.42 Sept. 9, 2025: 52 @ 68.50
Oct. 26, 2025issueSO-251026-113MAIN 3 68.50-205.49835,685.29 Sept. 9, 2025: 3 @ 68.50
Oct. 18, 2025adjustmentCycle countMAIN -2 68.50-137.00865,890.78 Sept. 9, 2025: 2 @ 68.50
Oct. 15, 2025issueSO-251015-956MAIN 32 68.50-2,191.92886,027.78 Sept. 9, 2025: 32 @ 68.50
Oct. 8, 2025issueSO-251008-164MAIN 82 68.50-5,616.801208,219.70 Sept. 9, 2025: 82 @ 68.50
Sept. 18, 2025issueSO-250918-839MAIN 15 68.50-1,027.4620213,836.50 Sept. 9, 2025: 15 @ 68.50
Sept. 10, 2025issueSO-250910-773MAIN 77 67.76-5,217.4421714,863.96 July 15, 2025: 64 @ 67.61; Sept. 9, 2025: 13 @ 68.50
Sept. 9, 2025receiptPO-000825MAIN 230 68.5015,754.4229420,081.40
Aug. 26, 2025issueSO-250826-670MAIN 27 67.61-1,825.44644,326.98 July 15, 2025: 27 @ 67.61
Aug. 7, 2025issueSO-250807-290MAIN 77 67.61-5,205.89916,152.42 July 15, 2025: 77 @ 67.61
July 27, 2025issueSO-250727-418MAIN 44 67.61-2,974.8016811,358.31 July 15, 2025: 44 @ 67.61
July 25, 2025issueSO-250725-898MAIN 34 68.45-2,327.3121214,333.11 May 31, 2025: 16 @ 69.40; July 15, 2025: 18 @ 67.61
July 25, 2025issueSO-250725-898EAST 2 69.40-138.7924616,660.42 May 31, 2025: 2 @ 69.40
July 22, 2025issueSO-250722-157EAST 1 69.40-69.4024816,799.21 May 31, 2025: 1 @ 69.40
July 19, 2025issueSO-250719-130EAST 16 69.40-1,110.3524916,868.61 May 31, 2025: 16 @ 69.40
July 15, 2025receiptPO-000711MAIN 230 67.6115,550.0726517,978.95
July 7, 2025issueSO-250707-528MAIN 8 69.40-555.17352,428.88 May 31, 2025: 8 @ 69.40
July 5, 2025issueSO-250705-684EAST 3 69.40-208.19432,984.06 May 31, 2025: 3 @ 69.40
June 30, 2025issueSO-250630-125MAIN 53 69.40-3,678.03463,192.25 May 31, 2025: 53 @ 69.40
June 20, 2025issueSO-250620-572EAST 2 69.40-138.79996,870.27 May 31, 2025: 2 @ 69.40
June 17, 2025issueSO-250617-748MAIN 24 69.40-1,665.521017,009.07 May 31, 2025: 24 @ 69.40
June 16, 2025issueSO-250616-470EAST 16 69.40-1,110.351258,674.59 May 31, 2025: 16 @ 69.40
June 13, 2025issueSO-250613-689EAST 28 69.40-1,943.111419,784.93 May 31, 2025: 28 @ 69.40
June 6, 2025issueSO-250606-719MAIN 61 69.40-4,233.2016911,728.04 May 31, 2025: 61 @ 69.40
May 31, 2025transferTRFMAIN → EAST 68 warehouse transfer, no cost effect
May 31, 2025receiptPO-000591MAIN 230 69.4015,961.2423015,961.24
May 28, 2025issueSO-250528-740EAST 25 68.48-1,712.0500.00 April 6, 2025: 25 @ 68.48
May 25, 2025issueSO-250525-433EAST 42 68.48-2,876.25251,712.05 April 6, 2025: 42 @ 68.48
May 17, 2025issueSO-250517-146EAST 13 68.48-890.27674,588.30 April 6, 2025: 13 @ 68.48
May 17, 2025issueSO-250517-146MAIN 44 68.48-3,013.21805,478.57 April 6, 2025: 44 @ 68.48
April 29, 2025issueSO-250429-175MAIN 50 68.48-3,424.101248,491.78 April 6, 2025: 50 @ 68.48
April 22, 2025issueSO-250422-495MAIN 3 68.48-205.4517411,915.89 April 6, 2025: 3 @ 68.48
April 18, 2025issueSO-250418-370MAIN 22 68.48-1,506.6117712,121.33 April 6, 2025: 22 @ 68.48
April 11, 2025issueSO-250411-186MAIN 4 68.48-273.9319913,627.94 April 6, 2025: 4 @ 68.48
April 8, 2025issueSO-250408-847MAIN 82 67.67-5,549.1420313,901.87 Feb. 11, 2025: 55 @ 67.28; April 6, 2025: 27 @ 68.48
April 6, 2025transferTRFMAIN → EAST 80 warehouse transfer, no cost effect
April 6, 2025receiptPO-000418MAIN 230 68.4815,750.8828519,451.01
March 22, 2025issueSO-250322-794MAIN 16 67.28-1,076.40553,700.12 Feb. 11, 2025: 16 @ 67.28
March 19, 2025issueSO-250319-829MAIN 15 67.28-1,009.12714,776.52 Feb. 11, 2025: 15 @ 67.28
March 18, 2025issueSO-250318-915MAIN 7 67.28-470.92865,785.65 Feb. 11, 2025: 7 @ 67.28
March 8, 2025issueSO-250308-898MAIN 41 67.28-2,758.28936,256.58 Feb. 11, 2025: 41 @ 67.28
March 6, 2025issueSO-250306-673MAIN 54 67.28-3,632.851349,014.85 Feb. 11, 2025: 54 @ 67.28
Feb. 21, 2025issueSO-250221-505MAIN 37 67.28-2,489.1818812,647.70 Feb. 11, 2025: 37 @ 67.28
Feb. 13, 2025issueSO-250213-730MAIN 48 67.48-3,239.2522515,136.88 Nov. 22, 2024: 42 @ 67.51; Jan. 18, 2025: 1 @ 67.51; Feb. 11, 2025: 5 @ 67.28
Feb. 11, 2025receiptPO-000258MAIN 230 67.2815,473.2527318,376.13
Feb. 5, 2025issueSO-250205-298MAIN 6 67.51-405.05432,902.88 Nov. 22, 2024: 6 @ 67.51
Jan. 27, 2025issueSO-250127-534MAIN 50 67.51-3,375.44493,307.93 Nov. 22, 2024: 50 @ 67.51
Jan. 18, 2025returnRMAMAIN 1 67.5167.51996,683.37
Jan. 13, 2025issueSO-250113-704MAIN 36 67.51-2,430.32986,615.86 Nov. 22, 2024: 36 @ 67.51
Jan. 7, 2025issueSO-250107-920MAIN 1 67.51-67.511349,046.18 Nov. 22, 2024: 1 @ 67.51
Jan. 4, 2025issueSO-250104-846MAIN 26 67.51-1,755.231359,113.69 Nov. 22, 2024: 26 @ 67.51
Dec. 30, 2024issueSO-241230-290MAIN 11 67.51-742.6016110,868.92 Nov. 22, 2024: 11 @ 67.51
Dec. 28, 2024issueSO-241228-905MAIN 29 67.51-1,957.7617211,611.51 Nov. 22, 2024: 29 @ 67.51
Dec. 27, 2024issueSO-241227-500MAIN 16 67.51-1,080.1420113,569.27 Nov. 22, 2024: 16 @ 67.51
Dec. 24, 2024issueSO-241224-554MAIN 7 67.51-472.5621714,649.41 Nov. 22, 2024: 7 @ 67.51
Dec. 20, 2024issueSO-241220-651MAIN 49 69.26-3,393.6422415,121.97 Oct. 1, 2024: 34 @ 69.50; Oct. 28, 2024: 9 @ 69.50; Nov. 22, 2024: 6 @ 67.51
Nov. 22, 2024receiptPO-000051MAIN 230 67.5115,527.0227318,515.61
Nov. 9, 2024issueSO-241109-595MAIN 41 69.50-2,849.58432,988.59 Oct. 1, 2024: 41 @ 69.50
Nov. 6, 2024issueSO-241106-598MAIN 12 69.50-834.02845,838.17 Oct. 1, 2024: 12 @ 69.50
Nov. 5, 2024issueSO-241105-588MAIN 27 69.50-1,876.55966,672.19 Oct. 1, 2024: 27 @ 69.50
Oct. 28, 2024returnRMAMAIN 9 69.50625.521238,548.75
Oct. 23, 2024issueSO-241023-122MAIN 18 69.50-1,251.041147,923.23 Oct. 1, 2024: 18 @ 69.50
Oct. 20, 2024issueSO-241020-968MAIN 5 69.50-347.511329,174.26 Oct. 1, 2024: 5 @ 69.50
Oct. 17, 2024issueSO-241017-712MAIN 67 69.50-4,656.631379,521.77 Oct. 1, 2024: 67 @ 69.50
Oct. 8, 2024issueSO-241008-568MAIN 9 69.50-625.5220414,178.41 Oct. 1, 2024: 9 @ 69.50
Oct. 7, 2024issueSO-241007-769MAIN 4 69.50-278.0121314,803.93 Oct. 1, 2024: 4 @ 69.50
Oct. 6, 2024issueSO-241006-703MAIN 13 69.50-903.5321715,081.93 Oct. 1, 2024: 13 @ 69.50
Oct. 1, 2024receiptPO-000002MAIN 230 69.5015,985.4623015,985.46