stocksense

Items / CON-0024

Bend 20mm Classic CON-0024 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)45MAIN 45
Value (FIFO)1,316.45avg 29.25
ClassCZ / NCV -
Turnover0.0xlast issue 503 days ago
Days of cover-lead time 14d

NRV 19.5621 is below cost: lower-of-cost-or-NRV write-down 436.15.

Demand and forecast

Monthly demand and forecast for CON-00240.045.991.9138184Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 111.0Nov 24: 128.0Dec 24: 167.0Jan 25: 92.0Feb 25: 103.0Mar 25: 72.0Apr 25: 84.0May 25: 118.0Jun 25: 0.0Jul 25: 0.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 = 31.941.0
Inventory positionon hand + on order45 + 045

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

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

MOQ 460, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Jan. 14, 202513 / 46029.25380.31
May 4, 202518 / 1829.25526.58
May 18, 202514 / 1429.25409.56

Movement ledger 43 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
May 31, 2025issueSO-250531-717MAIN 69 29.25-2,018.55451,316.45 Jan. 14, 2025: 69 @ 29.25
May 26, 2025issueSO-250526-387MAIN 21 29.25-614.341143,335.00 Jan. 14, 2025: 21 @ 29.25
May 21, 2025issueSO-250521-484MAIN 1 29.25-29.251353,949.34 Jan. 14, 2025: 1 @ 29.25
May 18, 2025returnRMAMAIN 14 29.25409.561363,978.60
May 17, 2025issueSO-250517-682MAIN 2 29.25-58.511223,569.04 Jan. 14, 2025: 2 @ 29.25
May 6, 2025issueSO-250506-441MAIN 28 29.25-819.121243,627.55 Jan. 14, 2025: 28 @ 29.25
May 5, 2025issueSO-250505-803MAIN 23 29.25-672.851524,446.67 Jan. 14, 2025: 23 @ 29.25
May 4, 2025returnRMAMAIN 18 29.25526.581755,119.52
May 3, 2025issueSO-250503-834MAIN 6 29.25-175.531574,592.94 Jan. 14, 2025: 6 @ 29.25
April 21, 2025issueSO-250421-753MAIN 37 29.25-1,082.411634,768.47 Jan. 14, 2025: 37 @ 29.25
April 20, 2025issueSO-250420-287MAIN 9 29.25-263.292005,850.88 Jan. 14, 2025: 9 @ 29.25
April 17, 2025issueSO-250417-975MAIN 2 29.25-58.512096,114.17 Jan. 14, 2025: 2 @ 29.25
April 16, 2025issueSO-250416-753MAIN 36 29.25-1,053.162116,172.68 Jan. 14, 2025: 36 @ 29.25
March 20, 2025issueSO-250320-266MAIN 19 29.25-555.832477,225.84 Jan. 14, 2025: 19 @ 29.25
March 11, 2025issueSO-250311-179MAIN 3 29.25-87.762667,781.67 Jan. 14, 2025: 3 @ 29.25
March 9, 2025issueSO-250309-144MAIN 50 29.25-1,462.722697,869.43 Jan. 14, 2025: 50 @ 29.25
Feb. 25, 2025issueSO-250225-652MAIN 11 29.25-321.803199,332.15 Jan. 14, 2025: 11 @ 29.25
Feb. 24, 2025issueSO-250224-110MAIN 2 29.25-58.513309,653.95 Jan. 14, 2025: 2 @ 29.25
Feb. 21, 2025issueSO-250221-649MAIN 11 29.25-321.803329,712.46 Jan. 14, 2025: 11 @ 29.25
Feb. 15, 2025issueSO-250215-355MAIN 37 29.25-1,082.4134310,034.26 Jan. 14, 2025: 37 @ 29.25
Feb. 13, 2025issueSO-250213-490MAIN 15 29.25-438.8238011,116.67 Jan. 14, 2025: 15 @ 29.25
Feb. 2, 2025issueSO-250202-541MAIN 27 29.25-789.8739511,555.49 Jan. 14, 2025: 27 @ 29.25
Jan. 31, 2025issueSO-250131-414MAIN 32 29.25-936.1442212,345.36 Jan. 14, 2025: 32 @ 29.25
Jan. 28, 2025issueSO-250128-975MAIN 4 29.25-117.0245413,281.50 Jan. 14, 2025: 4 @ 29.25
Jan. 25, 2025issueSO-250125-506MAIN 2 29.25-58.5145813,398.52 Jan. 14, 2025: 2 @ 29.25
Jan. 14, 2025receiptPO-000184MAIN 460 29.2513,457.0246013,457.02
Jan. 10, 2025issueSO-250110-422MAIN 42 30.34-1,274.4100.00 Oct. 1, 2024: 42 @ 30.34
Jan. 2, 2025issueSO-250102-719MAIN 12 30.34-364.12421,274.41 Oct. 1, 2024: 12 @ 30.34
Dec. 28, 2024issueSO-241228-477MAIN 82 30.34-2,488.13541,638.52 Oct. 1, 2024: 82 @ 30.34
Dec. 27, 2024issueSO-241227-332MAIN 7 30.34-212.401364,126.65 Oct. 1, 2024: 7 @ 30.34
Dec. 25, 2024issueSO-241225-688MAIN 31 30.34-940.631434,339.05 Oct. 1, 2024: 31 @ 30.34
Dec. 11, 2024issueSO-241211-854MAIN 47 30.34-1,426.121745,279.68 Oct. 1, 2024: 47 @ 30.34
Nov. 18, 2024issueSO-241118-380MAIN 83 30.34-2,518.472216,705.80 Oct. 1, 2024: 83 @ 30.34
Nov. 18, 2024issueSO-241118-380EAST 24 30.34-728.233049,224.27 Oct. 1, 2024: 24 @ 30.34
Nov. 7, 2024issueSO-241107-512EAST 21 30.34-637.203289,952.50 Oct. 1, 2024: 21 @ 30.34
Oct. 31, 2024issueSO-241031-991MAIN 2 30.34-60.6934910,589.71 Oct. 1, 2024: 2 @ 30.34
Oct. 30, 2024issueSO-241030-817EAST 19 30.34-576.5235110,650.39 Oct. 1, 2024: 19 @ 30.34
Oct. 19, 2024issueSO-241019-299MAIN 44 30.34-1,335.0937011,226.91 Oct. 1, 2024: 44 @ 30.34
Oct. 18, 2024issueSO-241018-905EAST 14 30.34-424.8041412,562.00 Oct. 1, 2024: 14 @ 30.34
Oct. 10, 2024issueSO-241010-267MAIN 5 30.34-151.7242812,986.80 Oct. 1, 2024: 5 @ 30.34
Oct. 2, 2024issueSO-241002-686EAST 27 30.34-819.2643313,138.52 Oct. 1, 2024: 27 @ 30.34
Oct. 1, 2024transferTRFMAIN → EAST 105 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 460 30.3413,957.7846013,957.78