stocksense

Items / CAB-0004

FR Wire 2.5 sqmm Prime CAB-0004 · Cables & Wires · Conduit & Cable Co

On hand (COIL)130MAIN 95, EAST 35
Value (FIFO)12,377.16avg 95.21
ClassAX / FCV 0.29
Turnover7.6xlast issue 9 days ago
Days of cover70lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00040.023.146.269.392.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 83.0Nov 24: 47.0Dec 24: 64.0Jan 25: 80.0Feb 25: 43.0Mar 25: 60.0Apr 25: 31.0May 25: 58.0Jun 25: 48.0Jul 25: 64.0Aug 25: 65.0Sep 25: 53.0Oct 25: 84.0Nov 25: 35.0Dec 25: 51.0Jan 26: 38.0Feb 26: 83.0Mar 26: 53.0Apr 26: 68.0May 26: 61.0Jun 26: 42.0Jul 26: 44.0Aug 26: 74.0Sep 26: 43.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.437556.33 / 30.43751.851
Daily demand sdmonthly sd / sqrt(30.4375)16.61 / 5.5173.012
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 * 3.012^2 + 1.851^2 * 3.1^2)26.0
Reorder pointd * LT + safety stock1.851 * 14.0 + 26.052.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days52.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 676/yr, S = 45.00, h = 20%, price = 94.3356.8
Inventory positionon hand + on order130 + 0130

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

From qtyUnit costOrder qtyAnnual costFeasible
094.335764,794yes (chosen if cheapest)

MOQ 130, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 13, 2026130 / 13095.2112,377.16

Movement ledger 119 movements, latest 60 shown - show all

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026transferTRFMAIN → EAST 35 warehouse transfer, no cost effect
Oct. 13, 2026receiptPO-001875MAIN 130 95.2112,377.1613012,377.16
Oct. 7, 2026issueSO-261007-125MAIN 16 93.74-1,499.8400.00 Aug. 23, 2026: 16 @ 93.74
Oct. 3, 2026issueSO-261003-308MAIN 27 93.74-2,530.98161,499.84 Aug. 23, 2026: 27 @ 93.74
Oct. 2, 2026issueSO-261002-206MAIN 14 93.74-1,312.36434,030.82 Aug. 23, 2026: 14 @ 93.74
Sept. 29, 2026adjustmentCycle countMAIN -1 93.74-93.74575,343.19 Aug. 23, 2026: 1 @ 93.74
Sept. 24, 2026issueSO-260924-167MAIN 17 93.74-1,593.58585,436.93 Aug. 23, 2026: 17 @ 93.74
Sept. 19, 2026issueSO-260919-877MAIN 1 93.74-93.74757,030.51 Aug. 23, 2026: 1 @ 93.74
Sept. 13, 2026issueSO-260913-355MAIN 4 93.74-374.96767,124.25 Aug. 23, 2026: 4 @ 93.74
Sept. 6, 2026issueSO-260906-661MAIN 21 93.74-1,968.54807,499.21 Aug. 23, 2026: 21 @ 93.74
Aug. 30, 2026issueSO-260830-698MAIN 18 93.74-1,687.321019,467.75 Aug. 23, 2026: 18 @ 93.74
Aug. 25, 2026issueSO-260825-880MAIN 12 93.75-1,125.0311911,155.07 July 27, 2026: 1 @ 93.89; Aug. 23, 2026: 11 @ 93.74
Aug. 23, 2026issueSO-260823-129MAIN 6 93.89-563.3613112,280.11 July 17, 2026: 6 @ 93.89
Aug. 23, 2026receiptPO-001738MAIN 130 93.7412,186.2113712,843.46
Aug. 21, 2026issueSO-260821-501MAIN 15 93.89-1,408.397657.25 May 26, 2026: 13 @ 93.89; July 17, 2026: 2 @ 93.89
Aug. 4, 2026issueSO-260804-208MAIN 23 93.89-2,159.54222,065.64 May 26, 2026: 23 @ 93.89
July 31, 2026issueSO-260731-522MAIN 19 93.89-1,783.97454,225.18 May 26, 2026: 19 @ 93.89
July 27, 2026returnRMAMAIN 1 93.8993.89646,009.15
July 19, 2026issueSO-260719-886MAIN 17 93.89-1,596.18635,915.25 May 26, 2026: 17 @ 93.89
July 17, 2026returnRMAMAIN 8 93.89751.14807,511.43
July 14, 2026issueSO-260714-403MAIN 1 93.89-93.89726,760.29 May 26, 2026: 1 @ 93.89
July 4, 2026issueSO-260704-238MAIN 16 93.89-1,502.29736,854.18 May 26, 2026: 16 @ 93.89
June 20, 2026issueSO-260620-296MAIN 14 93.89-1,314.50898,356.47 May 26, 2026: 14 @ 93.89
June 20, 2026issueSO-260620-296EAST 4 93.89-375.571039,670.97 May 26, 2026: 4 @ 93.89
June 2, 2026issueSO-260602-430MAIN 24 93.88-2,253.0110710,046.54 April 3, 2026: 1 @ 93.47; May 26, 2026: 23 @ 93.89
May 28, 2026issueSO-260528-644MAIN 3 93.47-280.4213112,299.55 April 3, 2026: 3 @ 93.47
May 26, 2026receiptPO-001522MAIN 130 93.8912,206.0813412,579.97
May 24, 2026issueSO-260524-955EAST 6 93.47-560.844373.89 April 3, 2026: 6 @ 93.47
May 21, 2026issueSO-260521-552EAST 7 93.47-654.3110934.74 April 3, 2026: 7 @ 93.47
May 19, 2026issueSO-260519-257EAST 11 93.47-1,028.21171,589.05 April 3, 2026: 11 @ 93.47
May 19, 2026issueSO-260519-257MAIN 15 93.47-1,402.10282,617.26 April 3, 2026: 15 @ 93.47
May 11, 2026issueSO-260511-835MAIN 8 93.47-747.79434,019.36 April 3, 2026: 8 @ 93.47
May 4, 2026issueSO-260504-461EAST 6 93.47-560.84514,767.15 April 3, 2026: 6 @ 93.47
May 1, 2026issueSO-260501-546MAIN 5 93.47-467.37575,327.99 April 3, 2026: 5 @ 93.47
April 29, 2026issueSO-260429-143MAIN 8 93.47-747.79625,795.36 April 3, 2026: 8 @ 93.47
April 26, 2026issueSO-260426-722MAIN 35 93.47-3,271.57706,543.14 April 3, 2026: 35 @ 93.47
April 18, 2026issueSO-260418-126MAIN 11 93.47-1,028.211059,814.72 April 3, 2026: 11 @ 93.47
April 8, 2026issueSO-260408-459MAIN 14 93.47-1,308.6311610,842.93 April 3, 2026: 14 @ 93.47
April 3, 2026transferTRFMAIN → EAST 34 warehouse transfer, no cost effect
April 3, 2026receiptPO-001379MAIN 130 93.4712,151.5613012,151.56
March 29, 2026issueSO-260329-158MAIN 24 91.47-2,195.3500.00 Feb. 5, 2026: 24 @ 91.47
March 28, 2026issueSO-260328-168MAIN 11 91.47-1,006.20242,195.35 Feb. 5, 2026: 11 @ 91.47
March 25, 2026issueSO-260325-749MAIN 14 91.47-1,280.62353,201.56 Feb. 5, 2026: 14 @ 91.47
March 2, 2026issueSO-260302-192MAIN 4 91.47-365.89494,482.18 Feb. 5, 2026: 4 @ 91.47
Feb. 28, 2026issueSO-260228-741MAIN 56 91.47-5,122.49534,848.07 Feb. 5, 2026: 56 @ 91.47
Feb. 27, 2026issueSO-260227-476MAIN 6 91.47-548.841099,970.57 Feb. 5, 2026: 6 @ 91.47
Feb. 19, 2026issueSO-260219-644MAIN 15 91.47-1,372.1011510,519.41 Feb. 5, 2026: 15 @ 91.47
Feb. 5, 2026receiptPO-001197MAIN 130 91.4711,891.5013011,891.50
Feb. 4, 2026issueSO-260204-912EAST 3 90.45-271.3400.00 Jan. 8, 2026: 3 @ 90.45
Feb. 4, 2026issueSO-260204-912MAIN 3 90.45-271.343271.34 Nov. 11, 2025: 3 @ 90.45
Jan. 30, 2026issueSO-260130-588MAIN 1 90.45-90.456542.69 Nov. 11, 2025: 1 @ 90.45
Jan. 28, 2026issueSO-260128-419MAIN 33 90.45-2,984.797633.14 Nov. 11, 2025: 33 @ 90.45
Jan. 22, 2026issueSO-260122-277EAST 7 90.45-633.14403,617.93 Nov. 11, 2025: 7 @ 90.45
Jan. 8, 2026returnRMAMAIN 3 90.45271.34474,251.07
Dec. 28, 2025issueSO-251228-476MAIN 12 90.45-1,085.38443,979.72 Nov. 11, 2025: 12 @ 90.45
Dec. 22, 2025issueSO-251222-982MAIN 7 90.45-633.14565,065.10 Nov. 11, 2025: 7 @ 90.45
Dec. 17, 2025issueSO-251217-166EAST 27 90.45-2,442.10635,698.24 Nov. 11, 2025: 27 @ 90.45
Dec. 8, 2025issueSO-251208-394MAIN 5 90.45-452.24908,140.34 Nov. 11, 2025: 5 @ 90.45
Nov. 29, 2025issueSO-251129-224MAIN 1 90.45-90.45958,592.58 Nov. 11, 2025: 1 @ 90.45
Nov. 17, 2025issueSO-251117-876EAST 7 90.45-633.14968,683.03 Nov. 11, 2025: 7 @ 90.45