stocksense

Items / CAB-0030

FR Wire 2.5 sqmm Elite CAB-0030 · Cables & Wires · Conduit & Cable Co

On hand (COIL)24MAIN 24
Value (FIFO)7,311.19avg 304.63
ClassAX / FCV 0.33
Turnover34.3xlast issue 9 days ago
Days of cover8lead time 14d

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

Demand and forecast

Monthly demand and forecast for CAB-00300.038.577.0116154Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 107.0Nov 24: 81.0Dec 24: 82.0Jan 25: 85.0Feb 25: 96.0Mar 25: 85.0Apr 25: 94.0May 25: 55.0Jun 25: 66.0Jul 25: 104.0Aug 25: 95.0Sep 25: 62.0Oct 25: 89.0Nov 25: 140.0Dec 25: 89.0Jan 26: 93.0Feb 26: 76.0Mar 26: 89.0Apr 26: 122.0May 26: 21.0Jun 26: 56.0Jul 26: 104.0Aug 26: 99.0Sep 26: 116.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.437591.17 / 30.43752.995
Daily demand sdmonthly sd / sqrt(30.4375)29.70 / 5.5175.383
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 * 5.383^2 + 2.995^2 * 3.1^2)45.6
Reorder pointd * LT + safety stock2.995 * 14.0 + 45.687.7
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days87.7
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1093/yr, S = 45.00, h = 20%, price = 287.39760.0
Inventory positionon hand + on order24 + 024

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

From qtyUnit costOrder qtyAnnual costFeasible
0312.3840343,989yes
380299.88380339,375yes
760287.39760336,095yes (chosen if cheapest)

MOQ 190, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 23, 202624 / 190304.637,311.19

Movement ledger 122 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 7, 2026issueSO-261007-943MAIN 150 304.63-45,694.96247,311.19 Sept. 23, 2026: 150 @ 304.63
Sept. 30, 2026issueSO-260930-781MAIN 5 304.63-1,523.1717453,006.16 Sept. 23, 2026: 5 @ 304.63
Sept. 29, 2026issueSO-260929-928MAIN 16 307.71-4,923.2917954,529.32 July 28, 2026: 1 @ 314.46; Aug. 16, 2026: 3 @ 314.46; Sept. 20, 2026: 1 @ 314.46; Sept. 23, 2026: 11 @ 304.63
Sept. 23, 2026receiptPO-001823MAIN 190 304.6357,880.2919559,452.61
Sept. 20, 2026returnRMAMAIN 1 314.46314.4651,572.32
Sept. 15, 2026issueSO-260915-580MAIN 43 314.46-13,521.9641,257.86 July 28, 2026: 43 @ 314.46
Sept. 10, 2026issueSO-260910-103MAIN 37 314.46-11,635.184714,779.82 July 28, 2026: 37 @ 314.46
Sept. 8, 2026issueSO-260908-556MAIN 2 314.46-628.938426,414.99 July 28, 2026: 2 @ 314.46
Sept. 2, 2026issueSO-260902-702MAIN 14 314.46-4,402.508627,043.92 July 28, 2026: 14 @ 314.46
Aug. 29, 2026issueSO-260829-977MAIN 4 314.46-1,257.8610031,446.42 July 28, 2026: 4 @ 314.46
Aug. 21, 2026issueSO-260821-507MAIN 17 314.46-5,345.8910432,704.28 July 28, 2026: 17 @ 314.46
Aug. 20, 2026issueSO-260820-569MAIN 49 314.46-15,408.7512138,050.17 July 28, 2026: 49 @ 314.46
Aug. 20, 2026issueSO-260820-569EAST 2 314.46-628.9317053,458.91 July 28, 2026: 2 @ 314.46
Aug. 16, 2026returnRMAMAIN 3 314.46943.3917254,087.84
Aug. 15, 2026issueSO-260815-137EAST 3 314.46-943.3916953,144.45 July 28, 2026: 3 @ 314.46
Aug. 10, 2026issueSO-260810-686MAIN 21 313.92-6,592.3117254,087.84 June 26, 2026: 3 @ 310.65; July 28, 2026: 18 @ 314.46
Aug. 3, 2026issueSO-260803-309EAST 6 310.65-1,863.9219360,680.16 June 26, 2026: 6 @ 310.65
July 28, 2026issueSO-260728-205MAIN 34 310.65-10,562.2019962,544.07 May 9, 2026: 29 @ 310.65; June 26, 2026: 5 @ 310.65
July 28, 2026receiptPO-001681MAIN 190 314.4659,748.2023373,106.27
July 27, 2026issueSO-260727-880MAIN 5 310.65-1,553.264313,358.07 May 9, 2026: 5 @ 310.65
July 20, 2026issueSO-260720-735EAST 2 310.65-621.314814,911.33 May 9, 2026: 2 @ 310.65
July 16, 2026issueSO-260716-173MAIN 16 310.65-4,970.445015,532.64 May 9, 2026: 16 @ 310.65
July 14, 2026issueSO-260714-709MAIN 47 310.65-14,600.686620,503.08 May 9, 2026: 47 @ 310.65
June 26, 2026returnRMAMAIN 14 310.654,349.1411335,103.77
June 26, 2026issueSO-260626-579MAIN 2 310.65-621.319930,754.63 May 9, 2026: 2 @ 310.65
June 19, 2026issueSO-260619-933EAST 11 310.65-3,417.1810131,375.93 May 9, 2026: 11 @ 310.65
June 14, 2026issueSO-260614-412EAST 29 310.65-9,008.9311234,793.11 May 9, 2026: 29 @ 310.65
June 13, 2026issueSO-260613-551MAIN 20 310.65-6,213.0614143,802.04 May 9, 2026: 20 @ 310.65
June 6, 2026issueSO-260606-825MAIN 8 310.65-2,485.2216150,015.10 May 9, 2026: 8 @ 310.65
May 11, 2026issueSO-260511-841MAIN 15 310.65-4,659.7916952,500.32 May 9, 2026: 15 @ 310.65
May 9, 2026issueSO-260509-486MAIN 6 310.65-1,863.9218457,160.12 May 9, 2026: 6 @ 310.65
May 9, 2026transferTRFMAIN → EAST 53 warehouse transfer, no cost effect
May 9, 2026receiptPO-001477MAIN 190 310.6559,024.0319059,024.03
April 26, 2026issueSO-260426-488EAST 11 301.68-3,318.4300.00 Feb. 28, 2026: 11 @ 301.68
April 26, 2026issueSO-260426-488MAIN 101 301.68-30,469.27113,318.43 Feb. 28, 2026: 101 @ 301.68
April 14, 2026issueSO-260414-731MAIN 10 301.68-3,016.7611233,787.70 Feb. 28, 2026: 10 @ 301.68
March 29, 2026issueSO-260329-752EAST 10 301.68-3,016.7612236,804.46 Feb. 28, 2026: 10 @ 301.68
March 23, 2026issueSO-260323-518MAIN 9 301.68-2,715.0813239,821.22 Feb. 28, 2026: 9 @ 301.68
March 22, 2026issueSO-260322-448MAIN 35 301.68-10,558.6614142,536.30 Feb. 28, 2026: 35 @ 301.68
March 7, 2026issueSO-260307-237MAIN 35 297.60-10,415.9617653,094.96 Dec. 26, 2025: 21 @ 294.88; Feb. 28, 2026: 14 @ 301.68
Feb. 28, 2026receiptPO-001268MAIN 190 301.6857,318.4221163,510.92
Feb. 25, 2026issueSO-260225-978EAST 24 294.88-7,077.14216,192.50 Dec. 26, 2025: 24 @ 294.88
Feb. 25, 2026issueSO-260225-978MAIN 12 294.88-3,538.574513,269.64 Dec. 26, 2025: 12 @ 294.88
Feb. 20, 2026issueSO-260220-685EAST 3 294.88-884.645716,808.22 Dec. 26, 2025: 3 @ 294.88
Feb. 10, 2026issueSO-260210-654MAIN 24 294.88-7,077.146017,692.86 Dec. 26, 2025: 24 @ 294.88
Feb. 6, 2026issueSO-260206-774MAIN 4 294.88-1,179.528424,770.00 Dec. 26, 2025: 4 @ 294.88
Feb. 5, 2026issueSO-260205-696MAIN 9 294.88-2,653.938825,949.53 Dec. 26, 2025: 9 @ 294.88
Jan. 21, 2026issueSO-260121-617MAIN 10 294.88-2,948.819728,603.46 Dec. 26, 2025: 10 @ 294.88
Jan. 3, 2026issueSO-260103-195MAIN 83 294.88-24,475.1210731,552.27 Dec. 26, 2025: 83 @ 294.88
Dec. 26, 2025transferTRFMAIN → EAST 48 warehouse transfer, no cost effect
Dec. 26, 2025receiptPO-001091MAIN 190 294.8856,027.3919056,027.39
Dec. 15, 2025issueSO-251215-244MAIN 89 301.97-26,875.4500.00 Oct. 25, 2025: 89 @ 301.97
Nov. 25, 2025issueSO-251125-809MAIN 55 301.97-16,608.428926,875.45 Oct. 25, 2025: 55 @ 301.97
Nov. 16, 2025issueSO-251116-904MAIN 85 296.75-25,223.5214443,483.87 Sept. 29, 2025: 39 @ 290.59; Oct. 25, 2025: 46 @ 301.97
Oct. 30, 2025issueSO-251030-222MAIN 8 290.59-2,324.6922968,707.39 Aug. 27, 2025: 8 @ 290.59
Oct. 25, 2025receiptPO-000950MAIN 190 301.9757,374.5523771,032.07
Oct. 10, 2025issueSO-251010-744MAIN 81 290.59-23,537.444713,657.53 Aug. 27, 2025: 81 @ 290.59
Sept. 29, 2025returnRMAMAIN 39 290.5911,332.8412837,194.97
Sept. 10, 2025issueSO-250910-254MAIN 79 290.59-22,956.278925,862.13 Aug. 27, 2025: 79 @ 290.59
Sept. 9, 2025issueSO-250909-275MAIN 22 290.59-6,392.8916848,818.40 Aug. 27, 2025: 22 @ 290.59
Aug. 27, 2025receiptPO-000798MAIN 190 290.5955,211.2819055,211.28
Aug. 20, 2025issueSO-250820-972MAIN 34 300.33-10,211.1200.00 June 18, 2025: 34 @ 300.33
Aug. 20, 2025issueSO-250820-972EAST 12 300.33-3,603.933410,211.12 June 18, 2025: 12 @ 300.33
Aug. 12, 2025issueSO-250812-539MAIN 43 300.33-12,914.074613,815.05 June 18, 2025: 43 @ 300.33
Aug. 1, 2025issueSO-250801-308EAST 6 300.33-1,801.968926,729.12 June 18, 2025: 6 @ 300.33
July 29, 2025issueSO-250729-482EAST 45 300.33-13,514.729528,531.08 June 18, 2025: 45 @ 300.33
July 27, 2025issueSO-250727-153MAIN 7 300.33-2,102.2914042,045.81 June 18, 2025: 7 @ 300.33
July 20, 2025issueSO-250720-262EAST 9 300.33-2,702.9414744,148.10 June 18, 2025: 9 @ 300.33
July 13, 2025issueSO-250713-179MAIN 17 300.33-5,105.5615646,851.04 June 18, 2025: 17 @ 300.33
July 8, 2025issueSO-250708-778MAIN 16 300.33-4,805.2417351,956.61 June 18, 2025: 16 @ 300.33
July 6, 2025issueSO-250706-713MAIN 10 294.43-2,944.2918956,761.84 April 4, 2025: 3 @ 293.77; April 21, 2025: 5 @ 293.77; May 15, 2025: 1 @ 293.77; June 18, 2025: 1 @ 300.33
June 21, 2025issueSO-250621-481MAIN 16 293.77-4,700.3819959,706.13 April 4, 2025: 16 @ 293.77
June 18, 2025transferTRFMAIN → EAST 47 warehouse transfer, no cost effect
June 18, 2025receiptPO-000646MAIN 190 300.3357,062.1721564,406.51
June 4, 2025issueSO-250604-368EAST 13 293.77-3,819.06257,344.34 April 4, 2025: 13 @ 293.77
June 4, 2025issueSO-250604-368MAIN 37 293.77-10,869.623811,163.39 April 4, 2025: 37 @ 293.77
May 27, 2025issueSO-250527-410MAIN 2 293.77-587.557522,033.01 April 4, 2025: 2 @ 293.77
May 26, 2025issueSO-250526-848EAST 11 293.77-3,231.517722,620.56 April 4, 2025: 11 @ 293.77
May 24, 2025issueSO-250524-748MAIN 5 293.77-1,468.878825,852.07 April 4, 2025: 5 @ 293.77
May 20, 2025issueSO-250520-341MAIN 5 293.77-1,468.879327,320.94 April 4, 2025: 5 @ 293.77
May 15, 2025returnRMAMAIN 1 293.77293.779828,789.80
May 12, 2025issueSO-250512-106EAST 5 293.77-1,468.879728,496.03 April 4, 2025: 5 @ 293.77
May 10, 2025issueSO-250510-198MAIN 26 293.77-7,638.1110229,964.90 April 4, 2025: 26 @ 293.77
May 7, 2025issueSO-250507-584MAIN 2 293.77-587.5512837,603.01 April 4, 2025: 2 @ 293.77
April 21, 2025returnRMAMAIN 5 293.771,468.8713038,190.56
April 18, 2025issueSO-250418-653MAIN 16 293.77-4,700.3812536,721.69 April 4, 2025: 16 @ 293.77
April 9, 2025issueSO-250409-962EAST 3 293.77-881.3214141,422.06 April 4, 2025: 3 @ 293.77
April 8, 2025issueSO-250408-396MAIN 42 293.77-12,338.4914442,303.38 April 4, 2025: 42 @ 293.77
April 7, 2025issueSO-250407-133MAIN 11 290.54-3,195.9918654,641.87 Jan. 19, 2025: 7 @ 288.70; April 4, 2025: 4 @ 293.77
April 6, 2025issueSO-250406-215MAIN 3 288.70-866.1019757,837.86 Jan. 19, 2025: 3 @ 288.70
April 5, 2025issueSO-250405-901MAIN 24 288.70-6,928.7820058,703.96 Jan. 19, 2025: 24 @ 288.70
April 4, 2025transferTRFMAIN → EAST 55 warehouse transfer, no cost effect
April 4, 2025receiptPO-000411MAIN 190 293.7755,816.9622465,632.73
March 24, 2025issueSO-250324-392MAIN 62 288.70-17,899.34349,815.77 Jan. 19, 2025: 62 @ 288.70
March 21, 2025issueSO-250321-915MAIN 23 288.70-6,640.089627,715.10 Jan. 19, 2025: 23 @ 288.70
Feb. 28, 2025issueSO-250228-582MAIN 28 288.70-8,083.5711934,355.18 Jan. 19, 2025: 28 @ 288.70
Feb. 26, 2025issueSO-250226-121MAIN 44 288.70-12,702.8314742,438.75 Nov. 19, 2024: 1 @ 288.78; Jan. 19, 2025: 43 @ 288.70
Feb. 14, 2025issueSO-250214-890EAST 3 288.78-866.3319155,141.59 Nov. 19, 2024: 3 @ 288.78
Feb. 12, 2025issueSO-250212-347EAST 21 288.78-6,064.3219456,007.92 Nov. 19, 2024: 21 @ 288.78
Jan. 29, 2025issueSO-250129-146EAST 6 288.78-1,732.6621562,072.24 Nov. 19, 2024: 6 @ 288.78
Jan. 23, 2025issueSO-250123-984MAIN 1 288.78-288.7822163,804.91 Nov. 19, 2024: 1 @ 288.78
Jan. 19, 2025receiptPO-000199MAIN 190 288.7054,852.8122264,093.68
Jan. 13, 2025issueSO-250113-923EAST 3 288.78-866.33329,240.87 Nov. 19, 2024: 3 @ 288.78
Jan. 9, 2025issueSO-250109-340EAST 22 288.78-6,353.103510,107.21 Nov. 19, 2024: 22 @ 288.78
Jan. 9, 2025issueSO-250109-340MAIN 47 288.78-13,572.535716,460.31 Nov. 19, 2024: 47 @ 288.78
Jan. 8, 2025issueSO-250108-650MAIN 5 288.78-1,443.8910430,032.84 Nov. 19, 2024: 5 @ 288.78
Jan. 7, 2025issueSO-250107-763EAST 1 288.78-288.7810931,476.73 Nov. 19, 2024: 1 @ 288.78
Dec. 15, 2024issueSO-241215-100MAIN 49 288.78-14,150.0911031,765.50 Nov. 19, 2024: 49 @ 288.78
Dec. 6, 2024issueSO-241206-515MAIN 25 288.78-7,219.4315945,915.59 Nov. 19, 2024: 25 @ 288.78
Dec. 4, 2024issueSO-241204-167EAST 8 290.77-2,326.1918453,135.02 Oct. 1, 2024: 2 @ 296.76; Nov. 19, 2024: 6 @ 288.78
Nov. 23, 2024issueSO-241123-884MAIN 41 296.76-12,167.2019255,461.21 Oct. 1, 2024: 41 @ 296.76
Nov. 19, 2024transferTRFMAIN → EAST 66 warehouse transfer, no cost effect
Nov. 19, 2024receiptPO-000041MAIN 190 288.7854,867.6923367,628.41
Nov. 5, 2024issueSO-241105-951MAIN 24 296.76-7,122.264312,760.72 Oct. 1, 2024: 24 @ 296.76
Nov. 1, 2024issueSO-241101-110MAIN 16 296.76-4,748.186719,882.99 Oct. 1, 2024: 16 @ 296.76
Oct. 29, 2024issueSO-241029-539MAIN 44 296.76-13,057.488324,631.16 Oct. 1, 2024: 44 @ 296.76
Oct. 28, 2024issueSO-241028-545MAIN 33 296.76-9,793.1112737,688.65 Oct. 1, 2024: 33 @ 296.76
Oct. 19, 2024issueSO-241019-244MAIN 1 296.76-296.7616047,481.76 Oct. 1, 2024: 1 @ 296.76
Oct. 16, 2024issueSO-241016-685MAIN 14 296.76-4,154.6516147,778.52 Oct. 1, 2024: 14 @ 296.76
Oct. 11, 2024issueSO-241011-106MAIN 12 296.76-3,561.1317551,933.18 Oct. 1, 2024: 12 @ 296.76
Oct. 1, 2024issueSO-241001-683MAIN 3 296.76-890.2818755,494.31 Oct. 1, 2024: 3 @ 296.76
Oct. 1, 2024receiptPO-000002MAIN 190 296.7656,384.5919056,384.59