stocksense

Items / CAB-0018

FR Wire 4 sqmm Elite CAB-0018 · Cables & Wires · Conduit & Cable Co

On hand (COIL)129MAIN 97, EAST 32
Value (FIFO)8,619.10avg 66.81
ClassAX / FCV 0.13
Turnover5.9xlast issue 0 days ago
Days of cover58lead time 14d

Demand and forecast

Monthly demand and forecast for CAB-00180.045.490.8136182Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 65.0Nov 24: 66.0Dec 24: 165.0Jan 25: 63.0Feb 25: 75.0Mar 25: 65.0Apr 25: 54.0May 25: 79.0Jun 25: 98.0Jul 25: 73.0Aug 25: 52.0Sep 25: 78.0Oct 25: 52.0Nov 25: 76.0Dec 25: 57.0Jan 26: 60.0Feb 26: 78.0Mar 26: 65.0Apr 26: 81.0May 26: 60.0Jun 26: 75.0Jul 26: 65.0Aug 26: 76.0Sep 26: 67.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.437567.67 / 30.43752.223
Daily demand sdmonthly sd / sqrt(30.4375)8.98 / 5.5171.629
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 * 1.629^2 + 2.223^2 * 3.1^2)18.9
Reorder pointd * LT + safety stock2.223 * 14.0 + 18.950.1
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days50.1
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 811/yr, S = 45.00, h = 20%, price = 67.6573.5
Inventory positionon hand + on order129 + 0129

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

From qtyUnit costOrder qtyAnnual costFeasible
067.657355,888yes (chosen if cheapest)

MOQ 160, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 11, 2026129 / 16066.818,619.10

Movement ledger 128 movements, latest 60 shown - show all

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 16, 2026issueSO-261016-514MAIN 12 66.81-801.781298,619.10 Oct. 11, 2026: 12 @ 66.81
Oct. 15, 2026issueSO-261015-956EAST 19 66.81-1,269.481419,420.87 Oct. 11, 2026: 19 @ 66.81
Oct. 11, 2026transferTRFMAIN → EAST 51 warehouse transfer, no cost effect
Oct. 11, 2026receiptPO-001869MAIN 160 66.8110,690.3516010,690.35
Oct. 10, 2026issueSO-261010-819MAIN 13 66.86-869.1600.00 July 21, 2026: 13 @ 66.86
Sept. 30, 2026issueSO-260930-963MAIN 65 66.86-4,345.8213869.16 July 21, 2026: 65 @ 66.86
Sept. 18, 2026issueSO-260918-111MAIN 2 66.86-133.72785,214.98 July 21, 2026: 2 @ 66.86
Aug. 31, 2026issueSO-260831-964MAIN 1 66.86-66.86805,348.70 July 21, 2026: 1 @ 66.86
Aug. 24, 2026issueSO-260824-482MAIN 10 66.86-668.59815,415.55 July 21, 2026: 10 @ 66.86
Aug. 21, 2026issueSO-260821-505MAIN 11 66.86-735.45916,084.14 July 21, 2026: 11 @ 66.86
Aug. 15, 2026issueSO-260815-959MAIN 30 66.86-2,005.761026,819.59 July 21, 2026: 30 @ 66.86
Aug. 6, 2026issueSO-260806-576MAIN 9 66.86-601.731328,825.35 July 21, 2026: 9 @ 66.86
Aug. 4, 2026issueSO-260804-912MAIN 15 66.86-1,002.881419,427.08 July 21, 2026: 15 @ 66.86
July 26, 2026issueSO-260726-100MAIN 3 66.86-200.5815610,429.96 July 21, 2026: 3 @ 66.86
July 22, 2026issueSO-260722-733MAIN 1 66.86-66.8615910,630.53 July 21, 2026: 1 @ 66.86
July 21, 2026receiptPO-001657MAIN 160 66.8610,697.3916010,697.39
July 13, 2026issueSO-260713-188MAIN 33 65.21-2,152.0100.00 May 14, 2026: 33 @ 65.21
July 4, 2026issueSO-260704-674MAIN 28 65.21-1,825.95332,152.01 May 14, 2026: 28 @ 65.21
June 17, 2026issueSO-260617-540MAIN 9 65.21-586.91613,977.96 May 14, 2026: 9 @ 65.21
June 10, 2026issueSO-260610-315MAIN 66 65.21-4,304.02704,564.88 May 14, 2026: 66 @ 65.21
May 27, 2026issueSO-260527-845MAIN 9 65.21-586.911368,868.90 May 14, 2026: 9 @ 65.21
May 24, 2026issueSO-260524-699MAIN 11 65.21-717.341459,455.81 May 14, 2026: 11 @ 65.21
May 22, 2026issueSO-260522-302MAIN 4 65.21-260.8515610,173.15 May 14, 2026: 4 @ 65.21
May 14, 2026receiptPO-001491MAIN 160 65.2110,434.0016010,434.00
May 10, 2026issueSO-260510-805MAIN 10 64.50-645.0400.00 Feb. 27, 2026: 10 @ 64.50
May 8, 2026issueSO-260508-302MAIN 26 64.50-1,677.1110645.04 Feb. 27, 2026: 26 @ 64.50
April 30, 2026issueSO-260430-786MAIN 20 64.50-1,290.09362,322.15 Feb. 27, 2026: 20 @ 64.50
April 17, 2026issueSO-260417-659MAIN 6 64.50-387.03563,612.24 Feb. 27, 2026: 6 @ 64.50
April 14, 2026issueSO-260414-513MAIN 9 64.50-580.54623,999.27 Feb. 27, 2026: 9 @ 64.50
April 11, 2026issueSO-260411-838MAIN 2 64.50-129.01714,579.81 Feb. 27, 2026: 2 @ 64.50
April 10, 2026issueSO-260410-972MAIN 44 64.50-2,838.19734,708.81 Feb. 27, 2026: 44 @ 64.50
March 29, 2026issueSO-260329-410MAIN 8 64.50-516.031177,547.00 Feb. 27, 2026: 8 @ 64.50
March 27, 2026issueSO-260327-641MAIN 2 64.50-129.011258,063.04 Feb. 27, 2026: 2 @ 64.50
March 18, 2026issueSO-260318-551MAIN 43 64.30-2,764.991278,192.05 Dec. 25, 2025: 10 @ 63.63; Feb. 27, 2026: 33 @ 64.50
March 17, 2026issueSO-260317-826MAIN 1 63.63-63.6317010,957.03 Dec. 25, 2025: 1 @ 63.63
March 14, 2026issueSO-260314-136MAIN 1 63.63-63.6317111,020.67 Dec. 25, 2025: 1 @ 63.63
March 13, 2026issueSO-260313-551MAIN 1 63.63-63.6317211,084.30 Dec. 25, 2025: 1 @ 63.63
March 12, 2026issueSO-260312-569MAIN 9 63.63-572.7117311,147.94 Dec. 25, 2025: 9 @ 63.63
Feb. 27, 2026receiptPO-001263MAIN 160 64.5010,320.6918211,720.64
Feb. 26, 2026issueSO-260226-562MAIN 6 63.63-381.81221,399.96 Dec. 25, 2025: 6 @ 63.63
Feb. 22, 2026issueSO-260222-591MAIN 11 63.63-699.98281,781.76 Dec. 25, 2025: 11 @ 63.63
Feb. 16, 2026issueSO-260216-313MAIN 12 63.63-763.61392,481.74 Dec. 25, 2025: 12 @ 63.63
Feb. 12, 2026issueSO-260212-616MAIN 14 63.63-890.88513,245.35 Dec. 25, 2025: 14 @ 63.63
Feb. 9, 2026issueSO-260209-821MAIN 35 63.63-2,227.20654,136.24 Dec. 25, 2025: 35 @ 63.63
Jan. 28, 2026issueSO-260128-135MAIN 1 63.63-63.631006,363.44 Dec. 25, 2025: 1 @ 63.63
Jan. 23, 2026issueSO-260123-531MAIN 16 63.63-1,018.151016,427.07 Dec. 25, 2025: 16 @ 63.63
Jan. 14, 2026issueSO-260114-963MAIN 1 63.63-63.631177,445.22 Dec. 25, 2025: 1 @ 63.63
Jan. 13, 2026issueSO-260113-828MAIN 23 63.63-1,463.591187,508.86 Dec. 25, 2025: 23 @ 63.63
Jan. 7, 2026issueSO-260107-636MAIN 11 63.63-699.981418,972.45 Dec. 25, 2025: 11 @ 63.63
Jan. 5, 2026issueSO-260105-772MAIN 8 63.63-509.081529,672.43 Dec. 25, 2025: 8 @ 63.63
Dec. 25, 2025receiptPO-001086MAIN 160 63.6310,181.5016010,181.50
Dec. 17, 2025issueSO-251217-658MAIN 18 64.28-1,157.0700.00 Sept. 27, 2025: 18 @ 64.28
Dec. 10, 2025issueSO-251210-573MAIN 39 64.28-2,506.97181,157.07 Sept. 27, 2025: 39 @ 64.28
Nov. 28, 2025issueSO-251128-190MAIN 29 64.28-1,864.16573,664.04 Sept. 27, 2025: 29 @ 64.28
Nov. 9, 2025issueSO-251109-158MAIN 2 64.28-128.56865,528.20 Sept. 27, 2025: 2 @ 64.28
Nov. 5, 2025issueSO-251105-221MAIN 45 64.28-2,892.66885,656.76 Sept. 27, 2025: 45 @ 64.28
Oct. 18, 2025issueSO-251018-600MAIN 15 64.28-964.221338,549.43 Sept. 27, 2025: 15 @ 64.28
Oct. 11, 2025issueSO-251011-640MAIN 4 64.28-257.131489,513.65 Sept. 27, 2025: 4 @ 64.28
Oct. 8, 2025issueSO-251008-749MAIN 24 62.93-1,510.231529,770.77 July 18, 2025: 16 @ 62.25; Sept. 27, 2025: 8 @ 64.28
Oct. 7, 2025issueSO-251007-164MAIN 4 62.25-248.9917611,281.00 July 18, 2025: 4 @ 62.25