stocksense

Items / CON-0013

PVC Conduit 20mm Max CON-0013 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)69MAIN 69
Value (FIFO)1,839.77avg 26.66
ClassCZ / NCV -
Turnover0.0xlast issue 412 days ago
Days of cover-lead time 14d

NRV 14.7535 is below cost: lower-of-cost-or-NRV write-down 821.78.

Demand and forecast

Monthly demand and forecast for CON-00130.055.0110165220Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 101.0Nov 24: 200.0Dec 24: 135.0Jan 25: 128.0Feb 25: 195.0Mar 25: 193.0Apr 25: 102.0May 25: 111.0Jun 25: 129.0Jul 25: 138.0Aug 25: 119.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 = 27.691.0
Inventory positionon hand + on order69 + 069

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

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

MOQ 540, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
April 9, 202569 / 54026.661,839.77

Movement ledger 48 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Aug. 30, 2025issueSO-250830-565MAIN 7 26.66-186.64691,839.77 April 9, 2025: 7 @ 26.66
Aug. 26, 2025issueSO-250826-997MAIN 101 26.66-2,692.99762,026.41 April 9, 2025: 101 @ 26.66
Aug. 21, 2025issueSO-250821-314MAIN 11 26.66-293.301774,719.40 April 9, 2025: 11 @ 26.66
July 26, 2025issueSO-250726-603MAIN 19 26.66-506.601885,012.70 April 9, 2025: 19 @ 26.66
July 13, 2025issueSO-250713-595MAIN 5 26.66-133.322075,519.30 April 9, 2025: 5 @ 26.66
July 3, 2025issueSO-250703-894MAIN 76 26.66-2,026.412125,652.62 April 9, 2025: 76 @ 26.66
July 1, 2025issueSO-250701-914MAIN 38 26.66-1,013.212887,679.03 April 9, 2025: 38 @ 26.66
June 26, 2025issueSO-250626-974MAIN 110 26.66-2,932.963268,692.24 April 9, 2025: 110 @ 26.66
June 12, 2025issueSO-250612-164MAIN 19 26.66-506.6043611,625.20 April 9, 2025: 19 @ 26.66
May 24, 2025issueSO-250524-176MAIN 55 26.66-1,466.4845512,131.80 April 9, 2025: 55 @ 26.66
May 20, 2025issueSO-250520-373MAIN 20 26.66-533.2751013,598.28 April 9, 2025: 20 @ 26.66
May 14, 2025issueSO-250514-667MAIN 5 26.66-133.3253014,131.55 April 9, 2025: 5 @ 26.66
May 1, 2025issueSO-250501-749MAIN 31 26.01-806.2553514,264.87 Jan. 26, 2025: 26 @ 25.88; April 9, 2025: 5 @ 26.66
April 24, 2025issueSO-250424-653MAIN 34 25.88-879.9956615,071.12 Jan. 26, 2025: 34 @ 25.88
April 9, 2025receiptPO-000429MAIN 540 26.6614,398.1860015,951.11
April 5, 2025issueSO-250405-969MAIN 10 25.88-258.82601,552.93 Jan. 26, 2025: 10 @ 25.88
April 2, 2025issueSO-250402-610MAIN 58 25.88-1,501.16701,811.75 Jan. 26, 2025: 58 @ 25.88
March 27, 2025issueSO-250327-486MAIN 70 25.88-1,811.751283,312.91 Jan. 26, 2025: 70 @ 25.88
March 20, 2025issueSO-250320-921MAIN 3 25.88-77.651985,124.66 Jan. 26, 2025: 3 @ 25.88
March 16, 2025issueSO-250316-751MAIN 26 25.88-672.932015,202.30 Jan. 26, 2025: 26 @ 25.88
March 15, 2025issueSO-250315-841MAIN 24 25.88-621.172275,875.24 Jan. 26, 2025: 24 @ 25.88
March 13, 2025issueSO-250313-764MAIN 70 25.88-1,811.752516,496.41 Jan. 26, 2025: 70 @ 25.88
Feb. 21, 2025issueSO-250221-530MAIN 56 25.88-1,449.403218,308.15 Jan. 26, 2025: 56 @ 25.88
Feb. 20, 2025issueSO-250220-992MAIN 76 25.88-1,967.043779,757.55 Jan. 26, 2025: 76 @ 25.88
Feb. 15, 2025issueSO-250215-328MAIN 28 25.88-724.7045311,724.59 Jan. 26, 2025: 28 @ 25.88
Feb. 10, 2025issueSO-250210-963MAIN 28 25.88-724.7048112,449.29 Jan. 26, 2025: 28 @ 25.88
Feb. 5, 2025issueSO-250205-365MAIN 7 25.88-181.1750913,173.99 Jan. 26, 2025: 7 @ 25.88
Jan. 30, 2025issueSO-250130-839MAIN 24 25.88-621.1751613,355.16 Jan. 26, 2025: 24 @ 25.88
Jan. 26, 2025receiptPO-000220MAIN 540 25.8813,976.3354013,976.33
Jan. 16, 2025issueSO-250116-176EAST 15 26.31-394.5800.00 Oct. 1, 2024: 15 @ 26.31
Jan. 15, 2025issueSO-250115-958EAST 11 26.31-289.3615394.58 Oct. 1, 2024: 11 @ 26.31
Jan. 13, 2025issueSO-250113-447EAST 30 26.31-789.1626683.94 Oct. 1, 2024: 30 @ 26.31
Jan. 13, 2025issueSO-250113-447MAIN 43 26.31-1,131.14561,473.11 Oct. 1, 2024: 43 @ 26.31
Jan. 1, 2025issueSO-250101-946MAIN 5 26.31-131.53992,604.24 Oct. 1, 2024: 5 @ 26.31
Dec. 28, 2024issueSO-241228-654MAIN 58 26.31-1,525.721042,735.77 Oct. 1, 2024: 58 @ 26.31
Dec. 6, 2024issueSO-241206-839MAIN 45 26.31-1,183.751624,261.49 Oct. 1, 2024: 45 @ 26.31
Dec. 2, 2024issueSO-241202-554EAST 32 26.31-841.782075,445.24 Oct. 1, 2024: 32 @ 26.31
Nov. 18, 2024issueSO-241118-375EAST 8 26.31-210.442396,287.01 Oct. 1, 2024: 8 @ 26.31
Nov. 14, 2024issueSO-241114-352MAIN 24 26.31-631.332476,497.46 Oct. 1, 2024: 24 @ 26.31
Nov. 13, 2024issueSO-241113-203EAST 65 26.31-1,709.862717,128.79 Oct. 1, 2024: 65 @ 26.31
Nov. 12, 2024issueSO-241112-685MAIN 100 26.31-2,630.553368,838.65 Oct. 1, 2024: 100 @ 26.31
Nov. 6, 2024issueSO-241106-725MAIN 3 26.31-78.9243611,469.20 Oct. 1, 2024: 3 @ 26.31
Oct. 21, 2024issueSO-241021-253EAST 6 26.31-157.8343911,548.11 Oct. 1, 2024: 6 @ 26.31
Oct. 18, 2024issueSO-241018-870MAIN 58 26.31-1,525.7244511,705.95 Oct. 1, 2024: 58 @ 26.31
Oct. 9, 2024issueSO-241009-961EAST 5 26.31-131.5350313,231.67 Oct. 1, 2024: 5 @ 26.31
Oct. 8, 2024issueSO-241008-699MAIN 32 26.31-841.7850813,363.19 Oct. 1, 2024: 32 @ 26.31
Oct. 1, 2024transferTRFMAIN → EAST 172 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 540 26.3114,204.9754014,204.97