stocksense

Items / CON-0017

Bend 20mm Prime CON-0017 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)85MAIN 85
Value (FIFO)506.08avg 5.95
ClassCX / FCV 0.18
Turnover7.5xlast issue 11 days ago
Days of cover50lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00170.019.839.659.479.2Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 52.0Nov 24: 54.0Dec 24: 35.0Jan 25: 40.0Feb 25: 43.0Mar 25: 50.0Apr 25: 36.0May 25: 55.0Jun 25: 45.0Jul 25: 44.0Aug 25: 66.0Sep 25: 31.0Oct 25: 55.0Nov 25: 41.0Dec 25: 43.0Jan 26: 59.0Feb 26: 54.0Mar 26: 52.0Apr 26: 38.0May 26: 43.0Jun 26: 54.0Jul 26: 55.0Aug 26: 60.0Sep 26: 72.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.437552.17 / 30.43751.714
Daily demand sdmonthly sd / sqrt(30.4375)9.21 / 5.5171.669
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 * 1.669^2 + 1.714^2 * 3.1^2)10.5
Reorder pointd * LT + safety stock1.714 * 14.0 + 10.534.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days34.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 626/yr, S = 45.00, h = 20%, price = 5.72440.0
Inventory positionon hand + on order85 + 085

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

From qtyUnit costOrder qtyAnnual costFeasible
05.962173,987yes
4405.724403,895yes (chosen if cheapest)
8805.488803,945yes

MOQ 220, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Aug. 19, 202677 / 2205.95458.45
Sept. 25, 20268 / 85.9547.63

Movement ledger 125 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 5, 2026issueSO-261005-137EAST 33 5.95-196.4885506.08 Aug. 19, 2026: 33 @ 5.95
Oct. 4, 2026issueSO-261004-907MAIN 18 5.95-107.17118702.56 Aug. 19, 2026: 18 @ 5.95
Oct. 1, 2026issueSO-261001-572EAST 7 5.95-41.68136809.73 Aug. 19, 2026: 7 @ 5.95
Sept. 28, 2026issueSO-260928-604EAST 32 5.95-190.52143851.41 Aug. 19, 2026: 32 @ 5.95
Sept. 27, 2026issueSO-260927-409MAIN 24 5.95-142.891751,041.93 Aug. 19, 2026: 24 @ 5.95
Sept. 25, 2026returnRMAMAIN 8 5.9547.631991,184.83
Sept. 18, 2026issueSO-260918-455MAIN 16 5.95-95.261911,137.19 Aug. 19, 2026: 16 @ 5.95
Sept. 16, 2026issueSO-260916-424MAIN 2 5.95-11.912071,232.46 Aug. 19, 2026: 2 @ 5.95
Sept. 10, 2026issueSO-260910-945MAIN 2 5.95-11.912091,244.37 Aug. 19, 2026: 2 @ 5.95
Sept. 9, 2026issueSO-260909-800EAST 4 5.95-23.822111,256.27 Aug. 19, 2026: 4 @ 5.95
Aug. 30, 2026issueSO-260830-722MAIN 3 5.95-17.862151,280.09 Aug. 19, 2026: 3 @ 5.95
Aug. 23, 2026issueSO-260823-853MAIN 12 5.84-70.132181,297.95 April 15, 2026: 4 @ 5.82; May 5, 2026: 6 @ 5.82; Aug. 19, 2026: 2 @ 5.95
Aug. 20, 2026issueSO-260820-431MAIN 2 5.82-11.652301,368.08 April 15, 2026: 2 @ 5.82
Aug. 19, 2026transferTRFMAIN → EAST 76 warehouse transfer, no cost effect
Aug. 19, 2026receiptPO-001729MAIN 220 5.951,309.862321,379.73
Aug. 7, 2026issueSO-260807-618MAIN 43 5.82-250.371269.87 April 15, 2026: 43 @ 5.82
July 31, 2026issueSO-260731-586MAIN 4 5.82-23.2955320.24 April 15, 2026: 4 @ 5.82
July 6, 2026issueSO-260706-302MAIN 3 5.82-17.4759343.53 April 15, 2026: 3 @ 5.82
July 4, 2026issueSO-260704-122MAIN 45 5.82-262.0262361.00 April 15, 2026: 45 @ 5.82
July 3, 2026issueSO-260703-641MAIN 3 5.82-17.47107623.02 April 15, 2026: 3 @ 5.82
June 28, 2026issueSO-260628-558MAIN 1 5.82-5.82110640.49 April 15, 2026: 1 @ 5.82
June 26, 2026issueSO-260626-417MAIN 5 5.82-29.11111646.31 April 15, 2026: 5 @ 5.82
June 25, 2026issueSO-260625-219MAIN 15 5.82-87.34116675.42 April 15, 2026: 15 @ 5.82
June 24, 2026issueSO-260624-185MAIN 13 5.82-75.69131762.76 April 15, 2026: 13 @ 5.82
June 21, 2026issueSO-260621-706MAIN 6 5.82-34.94144838.45 April 15, 2026: 6 @ 5.82
June 15, 2026issueSO-260615-580MAIN 13 5.82-75.69150873.39 April 15, 2026: 13 @ 5.82
June 10, 2026issueSO-260610-843MAIN 1 5.82-5.82163949.08 April 15, 2026: 1 @ 5.82
May 25, 2026issueSO-260525-229MAIN 8 5.82-46.58164954.91 April 15, 2026: 8 @ 5.82
May 21, 2026issueSO-260521-424MAIN 21 5.82-122.271721,001.49 April 15, 2026: 21 @ 5.82
May 8, 2026issueSO-260508-290MAIN 15 5.82-87.341931,123.76 April 15, 2026: 15 @ 5.82
May 5, 2026returnRMAMAIN 6 5.8234.942081,211.10
May 3, 2026issueSO-260503-618MAIN 5 5.82-29.112021,176.17 April 15, 2026: 5 @ 5.82
April 26, 2026issueSO-260426-606MAIN 13 5.82-75.692071,205.28 April 15, 2026: 13 @ 5.82
April 15, 2026receiptPO-001410MAIN 220 5.821,280.972201,280.97
April 13, 2026issueSO-260413-622MAIN 25 5.79-144.8500.00 Nov. 19, 2025: 24 @ 5.80; Dec. 14, 2025: 1 @ 5.68
March 30, 2026issueSO-260330-515MAIN 21 5.80-121.7825144.85 Nov. 19, 2025: 21 @ 5.80
March 27, 2026issueSO-260327-465MAIN 4 5.80-23.2046266.63 Nov. 19, 2025: 4 @ 5.80
March 15, 2026issueSO-260315-194MAIN 27 5.80-156.5750289.83 Nov. 19, 2025: 27 @ 5.80
Feb. 21, 2026issueSO-260221-201MAIN 27 5.80-156.5777446.40 Nov. 19, 2025: 27 @ 5.80
Feb. 20, 2026issueSO-260220-583MAIN 8 5.80-46.39104602.97 Nov. 19, 2025: 8 @ 5.80
Feb. 19, 2026issueSO-260219-380MAIN 12 5.80-69.59112649.36 Nov. 19, 2025: 12 @ 5.80
Feb. 7, 2026issueSO-260207-406MAIN 7 5.80-40.59124718.94 Nov. 19, 2025: 7 @ 5.80
Jan. 29, 2026issueSO-260129-513MAIN 8 5.80-46.39131759.54 Nov. 19, 2025: 8 @ 5.80
Jan. 26, 2026issueSO-260126-212MAIN 18 5.80-104.38139805.93 Nov. 19, 2025: 18 @ 5.80
Jan. 24, 2026issueSO-260124-656MAIN 17 5.80-98.58157910.31 Nov. 19, 2025: 17 @ 5.80
Jan. 8, 2026issueSO-260108-165MAIN 8 5.80-46.391741,008.89 Nov. 19, 2025: 8 @ 5.80
Jan. 1, 2026issueSO-260101-453MAIN 8 5.80-46.391821,055.28 Nov. 19, 2025: 8 @ 5.80
Dec. 30, 2025issueSO-251230-495MAIN 32 5.80-185.441901,101.67 July 4, 2025: 1 @ 5.68; Nov. 19, 2025: 31 @ 5.80
Dec. 23, 2025issueSO-251223-356MAIN 3 5.68-17.042221,287.12 July 4, 2025: 3 @ 5.68
Dec. 14, 2025returnRMAMAIN 1 5.685.682251,304.15
Dec. 12, 2025issueSO-251212-921MAIN 1 5.68-5.682241,298.47 July 4, 2025: 1 @ 5.68
Dec. 10, 2025issueSO-251210-269MAIN 7 5.68-39.752251,304.15 July 4, 2025: 7 @ 5.68
Dec. 2, 2025issueSO-251202-488MAIN 1 5.68-5.682321,343.91 July 4, 2025: 1 @ 5.68
Nov. 19, 2025receiptPO-001008MAIN 220 5.801,275.762331,349.59
Nov. 5, 2025issueSO-251105-565MAIN 27 5.68-153.341373.83 July 4, 2025: 27 @ 5.68
Nov. 4, 2025issueSO-251104-279MAIN 14 5.68-79.5140227.16 July 4, 2025: 14 @ 5.68
Oct. 22, 2025issueSO-251022-993MAIN 1 5.68-5.6854306.67 July 4, 2025: 1 @ 5.68
Oct. 21, 2025issueSO-251021-855MAIN 6 5.68-34.0755312.35 July 4, 2025: 6 @ 5.68
Oct. 19, 2025issueSO-251019-314MAIN 37 5.68-210.1361346.43 July 4, 2025: 37 @ 5.68
Oct. 10, 2025issueSO-251010-718MAIN 10 5.68-56.7998556.55 July 4, 2025: 10 @ 5.68
Oct. 6, 2025issueSO-251006-206MAIN 1 5.68-5.68108613.34 July 4, 2025: 1 @ 5.68
Sept. 24, 2025issueSO-250924-398MAIN 4 5.68-22.72109619.02 July 4, 2025: 4 @ 5.68
Sept. 21, 2025issueSO-250921-625MAIN 3 5.68-17.04113641.74 July 4, 2025: 3 @ 5.68
Sept. 10, 2025issueSO-250910-940MAIN 9 5.68-51.11116658.78 July 4, 2025: 9 @ 5.68
Sept. 9, 2025issueSO-250909-205MAIN 5 5.68-28.40125709.89 July 4, 2025: 5 @ 5.68
Sept. 4, 2025issueSO-250904-864MAIN 9 5.68-51.11130738.28 July 4, 2025: 9 @ 5.68
Sept. 2, 2025issueSO-250902-941MAIN 1 5.68-5.68139789.39 July 4, 2025: 1 @ 5.68
Aug. 24, 2025issueSO-250824-359MAIN 65 5.68-369.14140795.07 July 4, 2025: 65 @ 5.68
Aug. 6, 2025issueSO-250806-989MAIN 1 5.68-5.682051,164.22 July 4, 2025: 1 @ 5.68
July 22, 2025issueSO-250722-632MAIN 13 5.68-73.832061,169.89 July 4, 2025: 13 @ 5.68
July 16, 2025issueSO-250716-426MAIN 17 5.71-97.002191,243.72 Feb. 18, 2025: 9 @ 5.71; June 16, 2025: 7 @ 5.71; July 4, 2025: 1 @ 5.68
July 7, 2025issueSO-250707-601MAIN 14 5.71-79.912361,340.73 Feb. 18, 2025: 14 @ 5.71
July 4, 2025receiptPO-000681MAIN 220 5.681,249.402501,420.64
June 27, 2025issueSO-250627-358MAIN 2 5.71-11.4230171.23 Feb. 18, 2025: 2 @ 5.71
June 26, 2025issueSO-250626-528MAIN 3 5.71-17.1232182.65 Feb. 18, 2025: 3 @ 5.71
June 20, 2025issueSO-250620-361MAIN 6 5.71-34.2535199.77 Feb. 18, 2025: 6 @ 5.71
June 17, 2025issueSO-250617-193MAIN 21 5.71-119.8641234.02 Feb. 18, 2025: 21 @ 5.71
June 16, 2025returnRMAMAIN 7 5.7139.9562353.88
June 14, 2025issueSO-250614-811MAIN 5 5.71-28.5455313.93 Feb. 18, 2025: 5 @ 5.71
June 13, 2025issueSO-250613-588MAIN 15 5.71-85.6260342.47 Feb. 18, 2025: 15 @ 5.71
May 24, 2025issueSO-250524-494MAIN 15 5.71-85.6275428.08 Feb. 18, 2025: 15 @ 5.71
May 22, 2025issueSO-250522-407MAIN 3 5.71-17.1290513.70 Feb. 18, 2025: 3 @ 5.71
May 21, 2025issueSO-250521-365MAIN 18 5.71-102.7493530.83 Feb. 18, 2025: 18 @ 5.71
May 7, 2025issueSO-250507-234MAIN 1 5.71-5.71111633.57 Feb. 18, 2025: 1 @ 5.71
May 1, 2025issueSO-250501-971MAIN 18 5.71-102.74112639.27 Feb. 18, 2025: 18 @ 5.71
April 23, 2025issueSO-250423-416MAIN 4 5.71-22.83130742.01 Feb. 18, 2025: 4 @ 5.71
April 22, 2025issueSO-250422-282MAIN 5 5.71-28.54134764.85 Feb. 18, 2025: 5 @ 5.71
April 20, 2025issueSO-250420-654MAIN 2 5.71-11.42139793.38 Feb. 18, 2025: 2 @ 5.71
April 7, 2025issueSO-250407-675MAIN 6 5.71-34.25141804.80 Feb. 18, 2025: 6 @ 5.71
April 6, 2025issueSO-250406-609MAIN 4 5.71-22.83147839.05 Feb. 18, 2025: 4 @ 5.71
April 2, 2025issueSO-250402-612MAIN 15 5.71-85.62151861.88 Feb. 18, 2025: 15 @ 5.71
March 16, 2025issueSO-250316-489MAIN 23 5.71-131.28166947.49 Feb. 18, 2025: 23 @ 5.71
March 14, 2025issueSO-250314-261MAIN 7 5.71-39.951891,078.77 Feb. 18, 2025: 7 @ 5.71
March 1, 2025issueSO-250301-459MAIN 20 5.71-114.161961,118.73 Feb. 18, 2025: 20 @ 5.71
Feb. 19, 2025issueSO-250219-729MAIN 7 5.69-39.822161,232.88 Oct. 1, 2024: 3 @ 5.66; Feb. 18, 2025: 4 @ 5.71
Feb. 18, 2025receiptPO-000275MAIN 220 5.711,255.722231,272.70
Feb. 16, 2025issueSO-250216-704MAIN 18 5.66-101.92316.99 Oct. 1, 2024: 18 @ 5.66
Feb. 3, 2025issueSO-250203-566MAIN 11 5.66-62.2821118.90 Oct. 1, 2024: 11 @ 5.66
Feb. 2, 2025issueSO-250202-572MAIN 7 5.66-39.6332181.18 Oct. 1, 2024: 7 @ 5.66
Jan. 28, 2025issueSO-250128-386MAIN 2 5.66-11.3239220.82 Oct. 1, 2024: 2 @ 5.66
Jan. 25, 2025issueSO-250125-127MAIN 11 5.66-62.2841232.14 Oct. 1, 2024: 11 @ 5.66
Jan. 24, 2025issueSO-250124-133MAIN 8 5.66-45.3052294.42 Oct. 1, 2024: 8 @ 5.66
Jan. 18, 2025issueSO-250118-457MAIN 4 5.66-22.6560339.72 Oct. 1, 2024: 4 @ 5.66
Jan. 5, 2025issueSO-250105-653MAIN 15 5.66-84.9364362.37 Oct. 1, 2024: 15 @ 5.66
Dec. 31, 2024issueSO-241231-297MAIN 1 5.66-5.6679447.30 Oct. 1, 2024: 1 @ 5.66
Dec. 24, 2024issueSO-241224-667MAIN 7 5.66-39.6380452.96 Oct. 1, 2024: 7 @ 5.66
Dec. 21, 2024issueSO-241221-488MAIN 11 5.66-62.2887492.59 Oct. 1, 2024: 11 @ 5.66
Dec. 20, 2024issueSO-241220-762MAIN 1 5.66-5.6698554.88 Oct. 1, 2024: 1 @ 5.66
Dec. 10, 2024issueSO-241210-521MAIN 9 5.66-50.9699560.54 Oct. 1, 2024: 9 @ 5.66
Dec. 9, 2024issueSO-241209-520MAIN 6 5.66-33.97108611.50 Oct. 1, 2024: 6 @ 5.66
Nov. 28, 2024issueSO-241128-470MAIN 1 5.66-5.66114645.47 Oct. 1, 2024: 1 @ 5.66
Nov. 23, 2024issueSO-241123-854MAIN 13 5.66-73.61115651.13 Oct. 1, 2024: 13 @ 5.66
Nov. 23, 2024issueSO-241123-854EAST 2 5.66-11.32128724.74 Oct. 1, 2024: 2 @ 5.66
Nov. 18, 2024issueSO-241118-793EAST 1 5.66-5.66130736.06 Oct. 1, 2024: 1 @ 5.66
Nov. 17, 2024issueSO-241117-880EAST 12 5.66-67.94131741.72 Oct. 1, 2024: 12 @ 5.66
Nov. 5, 2024issueSO-241105-437EAST 20 5.66-113.24143809.67 Oct. 1, 2024: 20 @ 5.66
Nov. 3, 2024issueSO-241103-540EAST 5 5.66-28.31163922.91 Oct. 1, 2024: 5 @ 5.66
Oct. 29, 2024issueSO-241029-469MAIN 4 5.66-22.65168951.22 Oct. 1, 2024: 4 @ 5.66
Oct. 26, 2024issueSO-241026-912EAST 1 5.66-5.66172973.86 Oct. 1, 2024: 1 @ 5.66
Oct. 23, 2024issueSO-241023-747MAIN 8 5.66-45.30173979.53 Oct. 1, 2024: 8 @ 5.66
Oct. 22, 2024issueSO-241022-841EAST 20 5.66-113.241811,024.82 Oct. 1, 2024: 20 @ 5.66
Oct. 17, 2024issueSO-241017-777MAIN 11 5.66-62.282011,138.06 Oct. 1, 2024: 11 @ 5.66
Oct. 7, 2024issueSO-241007-176MAIN 8 5.66-45.302121,200.34 Oct. 1, 2024: 8 @ 5.66
Oct. 1, 2024transferTRFMAIN → EAST 61 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 220 5.661,245.642201,245.64