stocksense

Items / CAB-0028

Flexible Cable 3 core Flex CAB-0028 · Cables & Wires · Conduit & Cable Co

On hand (COIL)11MAIN 11
Value (FIFO)3,682.41avg 334.76
ClassCZ / NCV -
Turnover0.0xlast issue 456 days ago
Days of cover-lead time 14d

NRV 138.5735 is below cost: lower-of-cost-or-NRV write-down 2,158.10.

Demand and forecast

Monthly demand and forecast for CAB-00280.05.09.914.919.8Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 13.0Nov 24: 11.0Dec 24: 14.0Jan 25: 16.0Feb 25: 18.0Mar 25: 17.0Apr 25: 15.0May 25: 12.0Jun 25: 18.0Jul 25: 14.0Aug 25: 0.0Sep 25: 0.0Oct 25: 0.0Nov 25: 0.0Dec 25: 0.0Jan 26: 0.0Feb 26: 0.0Mar 26: 0.0Apr 26: 0.0May 26: 0.0Jun 26: 0.0Jul 26: 0.0Aug 26: 0.0Sep 26: 0.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.43750.00 / 30.43750.000
Daily demand sdmonthly sd / sqrt(30.4375)0.00 / 5.5170.000
Service level / zz = Phi^-1(service level)Phi^-1(0.900)1.282
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.282 * sqrt(14.0 * 0.000^2 + 0.000^2 * 3.1^2)0.0
Reorder pointd * LT + safety stock0.000 * 14.0 + 0.00.0
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days0.0
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 0/yr, S = 45.00, h = 20%, price = 358.011.0
Inventory positionon hand + on order11 + 011

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

From qtyUnit costOrder qtyAnnual costFeasible
0358.01136yes (chosen if cheapest)

MOQ 40, pack size 10, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
May 30, 202511 / 40334.763,682.41

Movement ledger 47 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Aug. 31, 2025adjustmentCycle countMAIN -1 334.76-334.76113,682.41 May 30, 2025: 1 @ 334.76
July 17, 2025issueSO-250717-748MAIN 3 334.76-1,004.29124,017.18 May 30, 2025: 3 @ 334.76
July 4, 2025issueSO-250704-167MAIN 3 334.76-1,004.29155,021.47 May 30, 2025: 3 @ 334.76
July 2, 2025issueSO-250702-146MAIN 8 334.76-2,678.12186,025.77 May 30, 2025: 8 @ 334.76
June 15, 2025issueSO-250615-689MAIN 2 334.76-669.53268,703.88 May 30, 2025: 2 @ 334.76
June 14, 2025issueSO-250614-687MAIN 7 334.76-2,343.35289,373.41 May 30, 2025: 7 @ 334.76
June 10, 2025issueSO-250610-754MAIN 5 334.76-1,673.823511,716.77 May 30, 2025: 5 @ 334.76
June 4, 2025issueSO-250604-446MAIN 4 344.34-1,377.374013,390.59 March 8, 2025: 4 @ 344.34
May 30, 2025receiptPO-000588MAIN 40 334.7613,390.594414,767.96
May 29, 2025issueSO-250529-167MAIN 2 344.34-688.6841,377.37 March 8, 2025: 2 @ 344.34
May 16, 2025issueSO-250516-741MAIN 2 344.34-688.6862,066.05 March 8, 2025: 2 @ 344.34
May 14, 2025issueSO-250514-505MAIN 5 344.34-1,721.7182,754.73 March 8, 2025: 5 @ 344.34
May 12, 2025issueSO-250512-300MAIN 3 344.34-1,033.02134,476.44 March 8, 2025: 3 @ 344.34
April 15, 2025issueSO-250415-634MAIN 4 344.34-1,377.37165,509.47 March 8, 2025: 4 @ 344.34
April 2, 2025issueSO-250402-348MAIN 9 344.34-3,099.07206,886.83 March 8, 2025: 9 @ 344.34
April 2, 2025issueSO-250402-348EAST 2 344.34-688.68299,985.91 March 8, 2025: 2 @ 344.34
March 24, 2025issueSO-250324-898MAIN 1 344.34-344.343110,674.59 March 8, 2025: 1 @ 344.34
March 21, 2025issueSO-250321-473EAST 5 344.34-1,721.713211,018.93 March 8, 2025: 5 @ 344.34
March 13, 2025issueSO-250313-374EAST 3 344.34-1,033.023712,740.64 March 8, 2025: 3 @ 344.34
March 8, 2025transferTRFMAIN → EAST 10 warehouse transfer, no cost effect
March 8, 2025receiptPO-000327MAIN 40 344.3413,773.664013,773.66
March 3, 2025issueSO-250303-111EAST 7 327.37-2,291.5600.00 Dec. 15, 2024: 7 @ 327.37
March 3, 2025issueSO-250303-111MAIN 1 327.37-327.3772,291.56 Dec. 15, 2024: 1 @ 327.37
Feb. 19, 2025issueSO-250219-837MAIN 15 327.37-4,910.4882,618.92 Dec. 15, 2024: 15 @ 327.37
Feb. 18, 2025issueSO-250218-547MAIN 3 327.37-982.10237,529.41 Dec. 15, 2024: 3 @ 327.37
Jan. 17, 2025issueSO-250117-232MAIN 4 327.37-1,309.46268,511.50 Dec. 15, 2024: 4 @ 327.37
Jan. 15, 2025issueSO-250115-868MAIN 9 327.37-2,946.29309,820.96 Dec. 15, 2024: 9 @ 327.37
Jan. 2, 2025issueSO-250102-758EAST 3 335.86-1,007.583912,767.25 Oct. 1, 2024: 2 @ 340.11; Dec. 15, 2024: 1 @ 327.37
Dec. 30, 2024issueSO-241230-639MAIN 3 340.11-1,020.334213,774.84 Oct. 1, 2024: 3 @ 340.11
Dec. 15, 2024transferTRFMAIN → EAST 10 warehouse transfer, no cost effect
Dec. 15, 2024receiptPO-000107MAIN 40 327.3713,094.624514,795.17
Dec. 10, 2024issueSO-241210-361MAIN 5 340.11-1,700.5551,700.55 Oct. 1, 2024: 5 @ 340.11
Dec. 7, 2024issueSO-241207-979MAIN 3 340.11-1,020.33103,401.10 Oct. 1, 2024: 3 @ 340.11
Dec. 5, 2024issueSO-241205-799MAIN 3 340.11-1,020.33134,421.42 Oct. 1, 2024: 3 @ 340.11
Nov. 30, 2024issueSO-241130-833MAIN 2 340.11-680.22165,441.75 Oct. 1, 2024: 2 @ 340.11
Nov. 27, 2024issueSO-241127-903MAIN 2 340.11-680.22186,121.97 Oct. 1, 2024: 2 @ 340.11
Nov. 22, 2024issueSO-241122-256MAIN 1 340.11-340.11206,802.19 Oct. 1, 2024: 1 @ 340.11
Nov. 21, 2024issueSO-241121-470MAIN 2 340.11-680.22217,142.30 Oct. 1, 2024: 2 @ 340.11
Nov. 15, 2024issueSO-241115-452MAIN 1 340.11-340.11237,822.52 Oct. 1, 2024: 1 @ 340.11
Nov. 11, 2024issueSO-241111-717MAIN 2 340.11-680.22248,162.63 Oct. 1, 2024: 2 @ 340.11
Nov. 2, 2024issueSO-241102-290MAIN 1 340.11-340.11268,842.85 Oct. 1, 2024: 1 @ 340.11
Oct. 28, 2024issueSO-241028-987MAIN 3 340.11-1,020.33279,182.96 Oct. 1, 2024: 3 @ 340.11
Oct. 24, 2024issueSO-241024-948MAIN 3 340.11-1,020.333010,203.28 Oct. 1, 2024: 3 @ 340.11
Oct. 6, 2024issueSO-241006-538MAIN 5 340.11-1,700.553311,223.61 Oct. 1, 2024: 5 @ 340.11
Oct. 4, 2024issueSO-241004-282MAIN 1 340.11-340.113812,924.16 Oct. 1, 2024: 1 @ 340.11
Oct. 3, 2024issueSO-241003-609MAIN 1 340.11-340.113913,264.27 Oct. 1, 2024: 1 @ 340.11
Oct. 1, 2024receiptPO-000002MAIN 40 340.1113,604.384013,604.38