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, latest 60 shown - show all

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