stocksense

Items / CAB-0015

FR Wire 1.0 sqmm Pro CAB-0015 · Cables & Wires · Conduit & Cable Co

On hand (COIL)83MAIN 83
Value (FIFO)15,046.54avg 181.28
ClassAX / FCV 0.32
Turnover6.0xlast issue 1 days ago
Days of cover63lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00150.020.941.862.783.6Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 40.0Nov 24: 45.0Dec 24: 30.0Jan 25: 53.0Feb 25: 41.0Mar 25: 55.0Apr 25: 76.0May 25: 48.0Jun 25: 71.0Jul 25: 41.0Aug 25: 50.0Sep 25: 48.0Oct 25: 25.0Nov 25: 25.0Dec 25: 33.0Jan 26: 32.0Feb 26: 71.0Mar 26: 24.0Apr 26: 43.0May 26: 41.0Jun 26: 44.0Jul 26: 42.0Aug 26: 51.0Sep 26: 48.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.437539.92 / 30.43751.311
Daily demand sdmonthly sd / sqrt(30.4375)12.89 / 5.5172.337
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 * 2.337^2 + 1.311^2 * 3.1^2)19.8
Reorder pointd * LT + safety stock1.311 * 14.0 + 19.838.2
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days38.2
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 479/yr, S = 45.00, h = 20%, price = 176.9534.9
Inventory positionon hand + on order83 + 083

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

From qtyUnit costOrder qtyAnnual costFeasible
0176.953585,936yes (chosen if cheapest)

MOQ 100, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 13, 202683 / 100181.2815,046.54

Movement ledger 105 movements, latest 60 shown - show all

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 15, 2026issueSO-261015-839MAIN 17 181.28-3,081.828315,046.54 Oct. 13, 2026: 17 @ 181.28
Oct. 13, 2026receiptPO-001876MAIN 100 181.2818,128.3610018,128.36
Oct. 7, 2026issueSO-261007-566MAIN 23 171.46-3,943.4700.00 Aug. 13, 2026: 23 @ 171.46
Sept. 27, 2026issueSO-260927-494MAIN 35 171.46-6,000.94233,943.47 Aug. 13, 2026: 35 @ 171.46
Sept. 18, 2026issueSO-260918-108MAIN 6 171.46-1,028.73589,944.41 Aug. 13, 2026: 6 @ 171.46
Sept. 12, 2026issueSO-260912-906MAIN 6 171.46-1,028.736410,973.14 Aug. 13, 2026: 6 @ 171.46
Sept. 5, 2026issueSO-260905-972MAIN 1 171.46-171.467012,001.87 Aug. 13, 2026: 1 @ 171.46
Aug. 22, 2026issueSO-260822-700MAIN 29 171.46-4,972.207112,173.33 Aug. 13, 2026: 29 @ 171.46
Aug. 13, 2026receiptPO-001717MAIN 100 171.4617,145.5310017,145.53
Aug. 12, 2026issueSO-260812-771MAIN 22 172.20-3,788.3200.00 June 4, 2026: 10 @ 172.62; June 8, 2026: 12 @ 171.84
July 29, 2026issueSO-260729-538MAIN 40 172.62-6,904.96223,788.32 June 4, 2026: 40 @ 172.62
July 7, 2026issueSO-260707-987MAIN 2 172.62-345.256210,693.27 June 4, 2026: 2 @ 172.62
June 21, 2026issueSO-260621-185MAIN 22 172.62-3,797.736411,038.52 June 4, 2026: 22 @ 172.62
June 14, 2026issueSO-260614-921MAIN 9 172.62-1,553.628614,836.24 June 4, 2026: 9 @ 172.62
June 10, 2026issueSO-260610-800MAIN 25 172.37-4,309.329516,389.86 March 9, 2026: 8 @ 171.84; June 4, 2026: 17 @ 172.62
June 8, 2026returnRMAMAIN 12 171.842,062.0812020,699.18
June 4, 2026receiptPO-001547MAIN 100 172.6217,262.3910818,637.11
May 30, 2026issueSO-260530-676MAIN 6 171.84-1,031.0481,374.72 March 9, 2026: 6 @ 171.84
May 23, 2026issueSO-260523-407MAIN 9 171.84-1,546.56142,405.76 March 9, 2026: 9 @ 171.84
May 19, 2026issueSO-260519-462MAIN 25 171.84-4,295.99233,952.31 March 9, 2026: 25 @ 171.84
May 10, 2026issueSO-260510-230MAIN 1 171.84-171.84488,248.31 March 9, 2026: 1 @ 171.84
April 28, 2026issueSO-260428-574MAIN 3 171.84-515.52498,420.15 March 9, 2026: 3 @ 171.84
April 27, 2026issueSO-260427-783MAIN 17 171.84-2,921.27528,935.66 March 9, 2026: 17 @ 171.84
April 17, 2026issueSO-260417-552MAIN 10 171.84-1,718.406911,856.94 March 9, 2026: 10 @ 171.84
April 7, 2026issueSO-260407-177MAIN 12 171.84-2,062.087913,575.34 March 9, 2026: 12 @ 171.84
April 6, 2026issueSO-260406-311MAIN 1 171.84-171.849115,637.41 March 9, 2026: 1 @ 171.84
March 11, 2026issueSO-260311-492MAIN 8 171.84-1,374.729215,809.25 March 9, 2026: 8 @ 171.84
March 9, 2026receiptPO-001298MAIN 100 171.8417,183.9710017,183.97
March 7, 2026issueSO-260307-504MAIN 1 168.69-168.6900.00 Jan. 4, 2026: 1 @ 168.69
March 5, 2026issueSO-260305-240MAIN 15 168.69-2,530.371168.69 Jan. 4, 2026: 15 @ 168.69
Feb. 24, 2026issueSO-260224-853MAIN 67 168.69-11,302.34162,699.07 Jan. 4, 2026: 67 @ 168.69
Feb. 16, 2026issueSO-260216-386MAIN 4 168.69-674.778314,001.40 Jan. 4, 2026: 4 @ 168.69
Jan. 21, 2026issueSO-260121-228MAIN 2 168.69-337.388714,676.17 Jan. 4, 2026: 2 @ 168.69
Jan. 18, 2026issueSO-260118-639MAIN 11 168.69-1,855.618915,013.55 Jan. 4, 2026: 11 @ 168.69
Jan. 4, 2026receiptPO-001118MAIN 100 168.6916,869.1610016,869.16
Jan. 2, 2026issueSO-260102-340MAIN 19 167.34-3,179.5200.00 Nov. 2, 2025: 4 @ 167.34; Dec. 5, 2025: 15 @ 167.34
Dec. 28, 2025issueSO-251228-915MAIN 8 167.34-1,338.75193,179.52 Oct. 3, 2025: 1 @ 167.34; Nov. 2, 2025: 7 @ 167.34
Dec. 24, 2025issueSO-251224-652MAIN 11 167.34-1,840.78274,518.27 Oct. 3, 2025: 11 @ 167.34
Dec. 17, 2025issueSO-251217-565MAIN 29 167.34-4,852.95386,359.04 Oct. 3, 2025: 29 @ 167.34
Dec. 5, 2025returnRMAMAIN 15 167.342,510.156711,211.99
Nov. 27, 2025issueSO-251127-384MAIN 30 167.34-5,020.30528,701.85 Oct. 3, 2025: 30 @ 167.34
Nov. 18, 2025issueSO-251118-262MAIN 4 167.34-669.378213,722.14 Oct. 3, 2025: 4 @ 167.34
Nov. 15, 2025issueSO-251115-607MAIN 2 167.34-334.698614,391.52 Oct. 3, 2025: 2 @ 167.34
Nov. 2, 2025returnRMAMAIN 11 167.341,840.788814,726.20
Oct. 30, 2025issueSO-251030-419MAIN 23 167.34-3,848.897712,885.43 Oct. 3, 2025: 23 @ 167.34
Oct. 3, 2025receiptPO-000897MAIN 100 167.3416,734.3210016,734.32
Oct. 1, 2025issueSO-251001-854MAIN 2 167.27-334.5400.00 July 31, 2025: 2 @ 167.27
Sept. 21, 2025issueSO-250921-230MAIN 48 167.27-8,028.852334.54 July 31, 2025: 48 @ 167.27
Aug. 14, 2025issueSO-250814-903MAIN 9 167.27-1,505.41508,363.38 July 31, 2025: 9 @ 167.27
Aug. 9, 2025issueSO-250809-647MAIN 41 167.27-6,857.98599,868.79 July 31, 2025: 41 @ 167.27
July 31, 2025receiptPO-000744MAIN 100 167.2716,726.7710016,726.77
July 26, 2025issueSO-250726-550MAIN 4 171.13-684.5400.00 June 5, 2025: 4 @ 171.13
July 17, 2025issueSO-250717-743MAIN 37 171.13-6,331.974684.54 June 5, 2025: 37 @ 171.13
June 16, 2025issueSO-250616-404MAIN 21 171.13-3,593.82417,016.51 June 5, 2025: 21 @ 171.13
June 14, 2025issueSO-250614-640MAIN 26 171.13-4,449.496210,610.33 June 5, 2025: 26 @ 171.13
June 14, 2025issueSO-250614-640EAST 21 166.95-3,505.898815,059.83 April 19, 2025: 9 @ 161.36; June 5, 2025: 12 @ 171.13
June 5, 2025transferTRFMAIN → EAST 21 warehouse transfer, no cost effect
June 5, 2025receiptPO-000605MAIN 100 171.1317,113.4410918,565.72
June 4, 2025issueSO-250604-853MAIN 3 161.36-484.0991,452.28 April 19, 2025: 3 @ 161.36
May 31, 2025issueSO-250531-635MAIN 10 161.36-1,613.65121,936.38 April 19, 2025: 10 @ 161.36