stocksense

Items / CAB-0019

Flexible Cable 3 core Prime CAB-0019 · Cables & Wires · Conduit & Cable Co

On hand (COIL)75MAIN 75
Value (FIFO)27,815.19avg 370.87
ClassAX / FCV 0.21
Turnover10.8xlast issue 6 days ago
Days of cover18lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00190.047.695.2143190Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 173.0Nov 24: 94.0Dec 24: 112.0Jan 25: 159.0Feb 25: 129.0Mar 25: 94.0Apr 25: 93.0May 25: 79.0Jun 25: 122.0Jul 25: 102.0Aug 25: 148.0Sep 25: 101.0Oct 25: 130.0Nov 25: 139.0Dec 25: 96.0Jan 26: 120.0Feb 26: 128.0Mar 26: 157.0Apr 26: 126.0May 26: 142.0Jun 26: 100.0Jul 26: 158.0Aug 26: 151.0Sep 26: 63.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.4375125.83 / 30.43754.134
Daily demand sdmonthly sd / sqrt(30.4375)26.83 / 5.5174.862
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.862^2 + 4.134^2 * 3.1^2)45.8
Reorder pointd * LT + safety stock4.134 * 14.0 + 45.8103.8
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days103.8
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1509/yr, S = 45.00, h = 20%, price = 347.52960.0
Inventory positionon hand + on order75 + 075

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

From qtyUnit costOrder qtyAnnual costFeasible
0377.7442573,200yes
480362.63480564,745yes
960347.52960557,830yes (chosen if cheapest)

MOQ 240, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 14, 202675 / 240370.8727,815.19

Movement ledger 137 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 10, 2026issueSO-261010-419MAIN 44 370.87-16,318.247527,815.19 Sept. 14, 2026: 44 @ 370.87
Oct. 8, 2026issueSO-261008-416MAIN 77 370.87-28,556.9311944,133.43 Sept. 14, 2026: 77 @ 370.87
Oct. 5, 2026issueSO-261005-265MAIN 4 370.87-1,483.4819672,690.36 Sept. 14, 2026: 4 @ 370.87
Sept. 29, 2026issueSO-260929-674MAIN 47 371.31-17,451.4120074,173.84 July 23, 2026: 7 @ 373.81; Sept. 14, 2026: 40 @ 370.87
Sept. 14, 2026receiptPO-001799MAIN 240 370.8789,008.6124791,625.25
Sept. 12, 2026issueSO-260912-621MAIN 16 373.81-5,980.9172,616.65 July 23, 2026: 16 @ 373.81
Aug. 28, 2026issueSO-260828-529MAIN 30 373.81-11,214.20238,597.55 July 23, 2026: 30 @ 373.81
Aug. 28, 2026issueSO-260828-529EAST 16 373.81-5,980.915319,811.75 July 23, 2026: 16 @ 373.81
Aug. 27, 2026issueSO-260827-736EAST 53 373.81-19,811.756925,792.66 July 23, 2026: 53 @ 373.81
Aug. 22, 2026issueSO-260822-767MAIN 40 373.81-14,952.2612245,604.41 July 23, 2026: 40 @ 373.81
Aug. 17, 2026issueSO-260817-283MAIN 12 373.81-4,485.6816260,556.67 July 23, 2026: 12 @ 373.81
July 29, 2026issueSO-260729-425MAIN 65 373.81-24,297.4317465,042.35 July 23, 2026: 65 @ 373.81
July 27, 2026issueSO-260727-742EAST 12 381.01-4,572.1523989,339.78 May 17, 2026: 11 @ 381.67; July 23, 2026: 1 @ 373.81
July 24, 2026issueSO-260724-804MAIN 70 381.67-26,716.7625193,911.93 May 17, 2026: 70 @ 381.67
July 23, 2026receiptPO-001664MAIN 240 373.8189,713.58321120,628.69
July 7, 2026issueSO-260707-580EAST 11 381.67-4,198.358130,915.11 May 17, 2026: 11 @ 381.67
June 23, 2026issueSO-260623-738EAST 19 381.67-7,251.699235,113.46 May 17, 2026: 19 @ 381.67
June 23, 2026issueSO-260623-738MAIN 48 381.67-18,320.0611142,365.15 May 17, 2026: 48 @ 381.67
June 22, 2026issueSO-260622-336MAIN 8 381.67-3,053.3415960,685.21 May 17, 2026: 8 @ 381.67
June 5, 2026issueSO-260605-741MAIN 25 381.67-9,541.7016763,738.56 May 17, 2026: 25 @ 381.67
May 29, 2026issueSO-260529-590MAIN 8 381.67-3,053.3419273,280.26 May 17, 2026: 8 @ 381.67
May 17, 2026issueSO-260517-390MAIN 99 370.03-36,633.2820076,333.60 March 27, 2026: 59 @ 362.15; May 17, 2026: 40 @ 381.67
May 17, 2026transferTRFMAIN → EAST 59 warehouse transfer, no cost effect
May 17, 2026receiptPO-001501MAIN 240 381.6791,600.32299112,966.88
May 3, 2026issueSO-260503-642MAIN 35 362.15-12,675.085921,366.56 March 27, 2026: 35 @ 362.15
April 30, 2026issueSO-260430-834MAIN 56 362.15-20,280.139434,041.64 March 27, 2026: 56 @ 362.15
April 27, 2026issueSO-260427-904EAST 19 362.15-6,880.7615054,321.76 March 27, 2026: 19 @ 362.15
April 22, 2026issueSO-260422-483MAIN 5 362.15-1,810.7316961,202.52 March 27, 2026: 5 @ 362.15
April 21, 2026issueSO-260421-773MAIN 41 362.15-14,847.9517463,013.25 March 27, 2026: 41 @ 362.15
April 20, 2026issueSO-260420-991MAIN 3 362.15-1,086.4421577,861.20 March 27, 2026: 3 @ 362.15
April 18, 2026issueSO-260418-622MAIN 1 362.15-362.1521878,947.63 March 27, 2026: 1 @ 362.15
April 6, 2026issueSO-260406-560MAIN 1 362.15-362.1521979,309.78 March 27, 2026: 1 @ 362.15
March 30, 2026issueSO-260330-975MAIN 77 369.76-28,471.7822079,671.92 Jan. 17, 2026: 57 @ 372.44; March 27, 2026: 20 @ 362.15
March 27, 2026transferTRFMAIN → EAST 71 warehouse transfer, no cost effect
March 27, 2026receiptPO-001359MAIN 240 362.1586,914.82297108,143.70
March 13, 2026issueSO-260313-987MAIN 46 372.44-17,132.085721,228.88 Jan. 17, 2026: 46 @ 372.44
March 13, 2026issueSO-260313-987EAST 27 372.44-10,055.7910338,360.96 Jan. 17, 2026: 27 @ 372.44
March 7, 2026issueSO-260307-579MAIN 7 372.44-2,607.0613048,416.74 Jan. 17, 2026: 7 @ 372.44
Feb. 22, 2026issueSO-260222-575EAST 43 372.44-16,014.7713751,023.80 Jan. 17, 2026: 43 @ 372.44
Feb. 19, 2026issueSO-260219-936MAIN 20 372.44-7,448.7318067,038.57 Jan. 17, 2026: 20 @ 372.44
Feb. 15, 2026issueSO-260215-647MAIN 14 372.44-5,214.1120074,487.30 Jan. 17, 2026: 14 @ 372.44
Feb. 14, 2026issueSO-260214-685MAIN 1 372.44-372.4421479,701.41 Jan. 17, 2026: 1 @ 372.44
Feb. 13, 2026issueSO-260213-186EAST 9 372.44-3,351.9321580,073.85 Jan. 17, 2026: 9 @ 372.44
Feb. 7, 2026issueSO-260207-594MAIN 41 368.10-15,092.3022483,425.78 Nov. 24, 2025: 25 @ 365.33; Jan. 17, 2026: 16 @ 372.44
Jan. 27, 2026issueSO-260127-186MAIN 26 365.33-9,498.6526598,518.08 Nov. 24, 2025: 26 @ 365.33
Jan. 17, 2026transferTRFMAIN → EAST 79 warehouse transfer, no cost effect
Jan. 17, 2026receiptPO-001151MAIN 240 372.4489,384.76291108,016.73
Jan. 10, 2026issueSO-260110-710MAIN 7 365.33-2,557.335118,631.97 Nov. 24, 2025: 7 @ 365.33
Jan. 2, 2026issueSO-260102-107MAIN 60 365.33-21,919.965821,189.30 Nov. 24, 2025: 60 @ 365.33
Jan. 1, 2026issueSO-260101-133MAIN 27 365.33-9,863.9811843,109.26 Nov. 24, 2025: 27 @ 365.33
Dec. 29, 2025issueSO-251229-930MAIN 58 365.33-21,189.3014552,973.24 Nov. 24, 2025: 58 @ 365.33
Dec. 5, 2025issueSO-251205-583MAIN 38 365.40-13,885.3220374,162.54 Oct. 3, 2025: 1 @ 368.01; Nov. 24, 2025: 37 @ 365.33
Nov. 24, 2025receiptPO-001017MAIN 240 365.3387,679.8524188,047.86
Nov. 9, 2025issueSO-251109-562MAIN 30 368.01-11,040.311368.01 Oct. 3, 2025: 30 @ 368.01
Nov. 7, 2025issueSO-251107-889MAIN 109 368.01-40,113.123111,408.32 Oct. 3, 2025: 109 @ 368.01
Oct. 31, 2025issueSO-251031-378MAIN 8 368.01-2,944.0814051,521.44 Oct. 3, 2025: 8 @ 368.01
Oct. 30, 2025issueSO-251030-948MAIN 36 368.01-13,248.3714854,465.52 Oct. 3, 2025: 36 @ 368.01
Oct. 27, 2025issueSO-251027-458MAIN 13 368.01-4,784.1318467,713.90 Oct. 3, 2025: 13 @ 368.01
Oct. 23, 2025issueSO-251023-843MAIN 22 368.01-8,096.2319772,498.03 Oct. 3, 2025: 22 @ 368.01
Oct. 11, 2025issueSO-251011-884MAIN 51 368.70-18,803.8421980,594.26 July 31, 2025: 30 @ 369.19; Oct. 3, 2025: 21 @ 368.01
Oct. 3, 2025receiptPO-000898MAIN 240 368.0188,322.4727099,398.09
Sept. 27, 2025issueSO-250927-288MAIN 4 369.19-1,476.753011,075.62 July 31, 2025: 4 @ 369.19
Sept. 25, 2025issueSO-250925-920MAIN 10 369.19-3,691.873412,552.37 July 31, 2025: 10 @ 369.19
Sept. 15, 2025issueSO-250915-499MAIN 59 369.19-21,782.064416,244.25 July 31, 2025: 59 @ 369.19
Sept. 8, 2025issueSO-250908-419MAIN 27 369.19-9,968.0610338,026.30 July 31, 2025: 27 @ 369.19
Sept. 6, 2025issueSO-250906-756MAIN 1 369.19-369.1913047,994.36 July 31, 2025: 1 @ 369.19
Aug. 27, 2025issueSO-250827-541MAIN 18 369.19-6,645.3713148,363.55 July 31, 2025: 18 @ 369.19
Aug. 20, 2025issueSO-250820-582MAIN 84 369.19-31,011.7414955,008.92 July 31, 2025: 84 @ 369.19
Aug. 18, 2025issueSO-250818-251MAIN 46 361.90-16,647.2823386,020.66 June 4, 2025: 39 @ 360.59; July 31, 2025: 7 @ 369.19
July 31, 2025issueSO-250731-143MAIN 15 360.59-5,408.84279102,667.95 June 4, 2025: 15 @ 360.59
July 31, 2025receiptPO-000745MAIN 240 369.1988,604.98294108,076.78
July 22, 2025issueSO-250722-344MAIN 2 360.59-721.185419,471.81 June 4, 2025: 2 @ 360.59
July 15, 2025issueSO-250715-732MAIN 46 360.59-16,587.095620,192.98 June 4, 2025: 46 @ 360.59
July 9, 2025issueSO-250709-942MAIN 39 360.59-14,062.9710236,780.08 June 4, 2025: 39 @ 360.59
June 27, 2025issueSO-250627-534MAIN 5 360.59-1,802.9414150,843.05 June 4, 2025: 5 @ 360.59
June 15, 2025issueSO-250615-485MAIN 83 360.59-29,928.8914652,645.99 June 4, 2025: 83 @ 360.59
June 8, 2025issueSO-250608-273MAIN 34 355.87-12,099.5222982,574.88 March 13, 2025: 23 @ 353.61; June 4, 2025: 11 @ 360.59
June 4, 2025receiptPO-000602MAIN 240 360.5986,541.3626394,674.40
May 26, 2025issueSO-250526-406MAIN 26 349.31-9,082.03238,133.04 March 9, 2025: 24 @ 348.95; March 13, 2025: 2 @ 353.61
May 23, 2025issueSO-250523-525MAIN 24 348.95-8,374.814917,215.07 March 9, 2025: 24 @ 348.95
May 18, 2025issueSO-250518-358MAIN 29 348.95-10,119.567325,589.88 March 9, 2025: 29 @ 348.95
April 25, 2025issueSO-250425-833MAIN 6 348.95-2,093.7010235,709.44 March 9, 2025: 6 @ 348.95
April 23, 2025issueSO-250423-412MAIN 10 348.95-3,489.5010837,803.15 March 9, 2025: 10 @ 348.95
April 18, 2025issueSO-250418-131MAIN 48 348.95-16,749.6211841,292.65 March 9, 2025: 48 @ 348.95
April 18, 2025issueSO-250418-131EAST 1 348.95-348.9516658,042.27 March 9, 2025: 1 @ 348.95
April 15, 2025issueSO-250415-710EAST 1 348.95-348.9516758,391.22 March 9, 2025: 1 @ 348.95
April 14, 2025issueSO-250414-280MAIN 2 348.95-697.9016858,740.17 March 9, 2025: 2 @ 348.95
April 8, 2025issueSO-250408-994EAST 11 348.95-3,838.4517059,438.07 March 9, 2025: 11 @ 348.95
April 5, 2025issueSO-250405-539EAST 14 348.95-4,885.3118163,276.52 March 9, 2025: 14 @ 348.95
March 28, 2025issueSO-250328-513MAIN 1 348.95-348.9519568,161.83 March 9, 2025: 1 @ 348.95
March 27, 2025issueSO-250327-412MAIN 13 348.95-4,536.3619668,510.78 March 9, 2025: 13 @ 348.95
March 23, 2025issueSO-250323-333MAIN 33 348.95-11,515.3620973,047.14 March 9, 2025: 33 @ 348.95
March 17, 2025issueSO-250317-375MAIN 39 350.86-13,683.6324284,562.50 Jan. 21, 2025: 16 @ 353.61; March 9, 2025: 23 @ 348.95
March 15, 2025issueSO-250315-143MAIN 11 353.61-3,889.7228198,246.13 Jan. 21, 2025: 11 @ 353.61
March 13, 2025returnRMAMAIN 25 353.618,840.26292102,135.84
March 9, 2025receiptPO-000329MAIN 240 348.9583,748.1026793,295.58
March 5, 2025issueSO-250305-130EAST 4 353.61-1,414.44279,547.48 Jan. 21, 2025: 4 @ 353.61
March 5, 2025issueSO-250305-130MAIN 18 353.61-6,364.993110,961.93 Jan. 21, 2025: 18 @ 353.61
Feb. 25, 2025issueSO-250225-293MAIN 63 353.61-22,277.464917,326.91 Jan. 21, 2025: 63 @ 353.61
Feb. 24, 2025issueSO-250224-607EAST 51 353.61-18,034.1411239,604.38 Jan. 21, 2025: 51 @ 353.61
Feb. 10, 2025issueSO-250210-997MAIN 1 353.61-353.6116357,638.51 Jan. 21, 2025: 1 @ 353.61
Feb. 3, 2025issueSO-250203-794MAIN 5 353.61-1,768.0516457,992.12 Jan. 21, 2025: 5 @ 353.61
Feb. 2, 2025issueSO-250202-792MAIN 9 353.61-3,182.4916959,760.17 Jan. 21, 2025: 9 @ 353.61
Jan. 27, 2025issueSO-250127-343MAIN 9 353.61-3,182.4917862,942.67 Jan. 21, 2025: 9 @ 353.61
Jan. 24, 2025issueSO-250124-925MAIN 53 353.61-18,741.3618766,125.16 Jan. 21, 2025: 53 @ 353.61
Jan. 21, 2025transferTRFMAIN → EAST 82 warehouse transfer, no cost effect
Jan. 21, 2025receiptPO-000203MAIN 240 353.6184,866.5224084,866.52
Jan. 12, 2025issueSO-250112-235MAIN 14 348.06-4,872.8200.00 Nov. 13, 2024: 13 @ 348.06; Dec. 17, 2024: 1 @ 348.06
Jan. 10, 2025issueSO-250110-991MAIN 23 348.06-8,005.34144,872.82 Nov. 13, 2024: 23 @ 348.06
Jan. 5, 2025issueSO-250105-849MAIN 26 348.06-9,049.523712,878.16 Nov. 13, 2024: 26 @ 348.06
Jan. 2, 2025issueSO-250102-986MAIN 4 348.06-1,392.236321,927.68 Nov. 13, 2024: 4 @ 348.06
Jan. 2, 2025issueSO-250102-986EAST 20 348.06-6,961.176723,319.91 Nov. 13, 2024: 20 @ 348.06
Jan. 1, 2025issueSO-250101-668MAIN 10 348.06-3,480.588730,281.08 Nov. 13, 2024: 10 @ 348.06
Dec. 31, 2024adjustmentCycle countMAIN -2 348.06-696.129733,761.66 Nov. 13, 2024: 2 @ 348.06
Dec. 30, 2024issueSO-241230-959MAIN 6 348.06-2,088.359934,457.78 Nov. 13, 2024: 6 @ 348.06
Dec. 29, 2024issueSO-241229-622MAIN 5 348.06-1,740.2910536,546.13 Nov. 13, 2024: 5 @ 348.06
Dec. 17, 2024returnRMAMAIN 1 348.06348.0611038,286.42
Dec. 15, 2024issueSO-241215-386MAIN 15 348.06-5,220.8810937,938.37 Nov. 13, 2024: 15 @ 348.06
Dec. 7, 2024issueSO-241207-919EAST 1 348.06-348.0612443,159.24 Nov. 13, 2024: 1 @ 348.06
Dec. 6, 2024issueSO-241206-921MAIN 31 348.06-10,789.8112543,507.30 Nov. 13, 2024: 31 @ 348.06
Dec. 3, 2024issueSO-241203-218EAST 16 348.06-5,568.9315654,297.11 Nov. 13, 2024: 16 @ 348.06
Dec. 2, 2024issueSO-241202-680EAST 39 348.06-13,574.2817259,866.04 Nov. 13, 2024: 39 @ 348.06
Nov. 25, 2024issueSO-241125-991MAIN 4 348.06-1,392.2321173,440.32 Nov. 13, 2024: 4 @ 348.06
Nov. 24, 2024adjustmentCycle countMAIN -2 348.06-696.1221574,832.56 Nov. 13, 2024: 2 @ 348.06
Nov. 24, 2024issueSO-241124-657MAIN 23 348.06-8,005.3421775,528.67 Nov. 13, 2024: 23 @ 348.06
Nov. 13, 2024transferTRFMAIN → EAST 76 warehouse transfer, no cost effect
Nov. 13, 2024receiptPO-000033MAIN 240 348.0683,534.0224083,534.02
Nov. 9, 2024issueSO-241109-774MAIN 14 358.85-5,023.9400.00 Oct. 1, 2024: 14 @ 358.85
Nov. 8, 2024issueSO-241108-884MAIN 22 358.85-7,894.77145,023.94 Oct. 1, 2024: 22 @ 358.85
Nov. 5, 2024issueSO-241105-677MAIN 2 358.85-717.713612,918.71 Oct. 1, 2024: 2 @ 358.85
Nov. 1, 2024issueSO-241101-484MAIN 29 358.85-10,406.743813,636.41 Oct. 1, 2024: 29 @ 358.85
Oct. 31, 2024issueSO-241031-422MAIN 37 358.85-13,277.566724,043.15 Oct. 1, 2024: 37 @ 358.85
Oct. 27, 2024issueSO-241027-374MAIN 21 358.85-7,535.9110437,320.71 Oct. 1, 2024: 21 @ 358.85
Oct. 25, 2024issueSO-241025-922MAIN 4 358.85-1,435.4112544,856.62 Oct. 1, 2024: 4 @ 358.85
Oct. 10, 2024issueSO-241010-558MAIN 53 358.85-19,019.2112946,292.04 Oct. 1, 2024: 53 @ 358.85
Oct. 7, 2024issueSO-241007-840MAIN 58 358.85-20,813.4718265,311.25 Oct. 1, 2024: 58 @ 358.85
Oct. 1, 2024receiptPO-000002MAIN 240 358.8586,124.7224086,124.72