stocksense

Items / CON-0028

Bend 20mm Max CON-0028 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)47MAIN 47
Value (FIFO)500.00avg 10.64
ClassCX / FCV 0.16
Turnover10.3xlast issue 2 days ago
Days of cover56lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00280.09.418.728.137.4Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 31.0Nov 24: 21.0Dec 24: 32.0Jan 25: 26.0Feb 25: 19.0Mar 25: 28.0Apr 25: 29.0May 25: 25.0Jun 25: 29.0Jul 25: 30.0Aug 25: 30.0Sep 25: 34.0Oct 25: 20.0Nov 25: 22.0Dec 25: 26.0Jan 26: 27.0Feb 26: 31.0Mar 26: 20.0Apr 26: 29.0May 26: 19.0Jun 26: 29.0Jul 26: 27.0Aug 26: 24.0Sep 26: 31.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.437525.42 / 30.43750.835
Daily demand sdmonthly sd / sqrt(30.4375)4.15 / 5.5170.753
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.753^2 + 0.835^2 * 3.1^2)4.9
Reorder pointd * LT + safety stock0.835 * 14.0 + 4.916.6
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days16.6
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 305/yr, S = 45.00, h = 20%, price = 11.06111.4
Inventory positionon hand + on order47 + 047

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

From qtyUnit costOrder qtyAnnual costFeasible
011.061113,617yes (chosen if cheapest)

MOQ 120, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
July 27, 202647 / 12010.64500.00

Movement ledger 99 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 14, 2026issueSO-261014-928MAIN 21 10.64-223.4147500.00 July 27, 2026: 21 @ 10.64
Oct. 12, 2026issueSO-261012-805MAIN 2 10.64-21.2868723.41 July 27, 2026: 2 @ 10.64
Oct. 7, 2026issueSO-261007-131MAIN 5 10.64-53.1970744.69 July 27, 2026: 5 @ 10.64
Oct. 5, 2026issueSO-261005-199MAIN 1 10.64-10.6475797.88 July 27, 2026: 1 @ 10.64
Oct. 2, 2026issueSO-261002-624MAIN 5 10.64-53.1976808.52 July 27, 2026: 5 @ 10.64
Sept. 30, 2026issueSO-260930-629MAIN 7 10.64-74.4781861.71 July 27, 2026: 7 @ 10.64
Sept. 15, 2026issueSO-260915-340MAIN 3 10.64-31.9288936.18 July 27, 2026: 3 @ 10.64
Sept. 4, 2026issueSO-260904-191MAIN 21 10.64-223.4191968.09 July 27, 2026: 21 @ 10.64
Aug. 23, 2026issueSO-260823-431MAIN 16 10.77-172.331121,191.50 March 20, 2026: 8 @ 10.90; July 27, 2026: 8 @ 10.64
Aug. 16, 2026issueSO-260816-659MAIN 8 10.90-87.221281,363.83 March 20, 2026: 8 @ 10.90
July 27, 2026receiptPO-001679MAIN 120 10.641,276.611361,451.05
July 18, 2026issueSO-260718-978MAIN 27 10.90-294.3716174.44 March 20, 2026: 27 @ 10.90
June 25, 2026issueSO-260625-745MAIN 12 10.90-130.8343468.81 March 20, 2026: 12 @ 10.90
June 16, 2026issueSO-260616-144MAIN 4 10.90-43.6155599.64 March 20, 2026: 4 @ 10.90
June 15, 2026issueSO-260615-574MAIN 6 10.90-65.4259643.25 March 20, 2026: 6 @ 10.90
June 4, 2026issueSO-260604-773MAIN 7 10.90-76.3265708.67 March 20, 2026: 7 @ 10.90
May 12, 2026issueSO-260512-167MAIN 6 10.90-65.4272784.99 March 20, 2026: 6 @ 10.90
May 2, 2026issueSO-260502-918MAIN 13 10.90-141.7378850.40 March 20, 2026: 13 @ 10.90
April 26, 2026issueSO-260426-560MAIN 1 10.90-10.9091992.14 March 20, 2026: 1 @ 10.90
April 15, 2026issueSO-260415-209MAIN 4 10.90-43.61921,003.04 March 20, 2026: 4 @ 10.90
April 14, 2026issueSO-260414-471MAIN 3 10.90-32.71961,046.65 March 20, 2026: 3 @ 10.90
April 8, 2026issueSO-260408-457MAIN 14 10.90-152.64991,079.36 March 20, 2026: 14 @ 10.90
April 6, 2026issueSO-260406-190MAIN 7 10.90-76.321131,231.99 March 20, 2026: 7 @ 10.90
March 20, 2026receiptPO-001335MAIN 120 10.901,308.311201,308.31
March 6, 2026issueSO-260306-955MAIN 16 10.43-166.8300.00 Nov. 2, 2025: 16 @ 10.43
March 5, 2026issueSO-260305-349MAIN 4 10.43-41.7116166.83 Nov. 2, 2025: 4 @ 10.43
Feb. 17, 2026issueSO-260217-257MAIN 2 10.43-20.8520208.54 Nov. 2, 2025: 2 @ 10.43
Feb. 13, 2026issueSO-260213-932MAIN 9 10.43-93.8422229.39 Nov. 2, 2025: 9 @ 10.43
Feb. 11, 2026issueSO-260211-936MAIN 11 10.43-114.6931323.23 Nov. 2, 2025: 11 @ 10.43
Feb. 9, 2026issueSO-260209-491MAIN 3 10.43-31.2842437.93 Nov. 2, 2025: 3 @ 10.43
Feb. 8, 2026issueSO-260208-293MAIN 1 10.43-10.4345469.21 Nov. 2, 2025: 1 @ 10.43
Feb. 1, 2026issueSO-260201-477MAIN 5 10.43-52.1346479.63 Nov. 2, 2025: 5 @ 10.43
Jan. 26, 2026issueSO-260126-630MAIN 12 10.43-125.1251531.77 Nov. 2, 2025: 12 @ 10.43
Jan. 16, 2026issueSO-260116-101MAIN 15 10.43-156.4063656.89 Nov. 2, 2025: 15 @ 10.43
Dec. 29, 2025issueSO-251229-868MAIN 10 10.43-104.2778813.29 Nov. 2, 2025: 10 @ 10.43
Dec. 25, 2025issueSO-251225-823MAIN 4 10.43-41.7188917.56 Nov. 2, 2025: 4 @ 10.43
Dec. 22, 2025issueSO-251222-272MAIN 1 10.43-10.4392959.27 Nov. 2, 2025: 1 @ 10.43
Dec. 20, 2025issueSO-251220-952MAIN 2 10.43-20.8593969.69 Nov. 2, 2025: 2 @ 10.43
Dec. 18, 2025issueSO-251218-401MAIN 1 10.43-10.4395990.55 Nov. 2, 2025: 1 @ 10.43
Dec. 14, 2025issueSO-251214-270MAIN 8 10.43-83.41961,000.97 Nov. 2, 2025: 8 @ 10.43
Nov. 28, 2025issueSO-251128-836MAIN 15 10.43-156.401041,084.39 Nov. 2, 2025: 15 @ 10.43
Nov. 25, 2025issueSO-251125-881MAIN 1 10.43-10.431191,240.79 Nov. 2, 2025: 1 @ 10.43
Nov. 3, 2025issueSO-251103-742MAIN 6 10.28-61.691201,251.22 June 14, 2025: 6 @ 10.28
Nov. 2, 2025receiptPO-000974MAIN 120 10.431,251.221261,312.90
Oct. 21, 2025issueSO-251021-121MAIN 4 10.28-41.12661.69 June 14, 2025: 4 @ 10.28
Oct. 19, 2025issueSO-251019-228MAIN 7 10.28-71.9710102.81 June 14, 2025: 7 @ 10.28
Oct. 18, 2025issueSO-251018-214MAIN 1 10.28-10.2817174.78 June 14, 2025: 1 @ 10.28
Oct. 12, 2025issueSO-251012-800MAIN 6 10.28-61.6918185.06 June 14, 2025: 6 @ 10.28
Oct. 9, 2025issueSO-251009-545MAIN 2 10.28-20.5624246.75 June 14, 2025: 2 @ 10.28
Sept. 28, 2025issueSO-250928-315MAIN 3 10.28-30.8426267.31 June 14, 2025: 3 @ 10.28
Sept. 25, 2025issueSO-250925-230MAIN 8 10.28-82.2529298.15 June 14, 2025: 8 @ 10.28
Sept. 21, 2025issueSO-250921-975MAIN 14 10.28-143.9437380.40 June 14, 2025: 14 @ 10.28
Sept. 20, 2025issueSO-250920-853MAIN 3 10.28-30.8451524.34 June 14, 2025: 3 @ 10.28
Sept. 19, 2025issueSO-250919-382MAIN 5 10.28-51.4154555.18 June 14, 2025: 5 @ 10.28
Sept. 8, 2025issueSO-250908-517MAIN 1 10.28-10.2859606.59 June 14, 2025: 1 @ 10.28
Aug. 22, 2025issueSO-250822-664MAIN 2 10.28-20.5660616.87 June 14, 2025: 2 @ 10.28
Aug. 17, 2025issueSO-250817-740MAIN 3 10.28-30.8462637.43 June 14, 2025: 3 @ 10.28
Aug. 8, 2025issueSO-250808-972MAIN 2 10.28-20.5665668.28 June 14, 2025: 2 @ 10.28
Aug. 2, 2025issueSO-250802-186MAIN 23 10.28-236.4767688.84 June 14, 2025: 23 @ 10.28
July 26, 2025issueSO-250726-455MAIN 1 10.28-10.2890925.31 June 14, 2025: 1 @ 10.28
July 26, 2025issueSO-250726-455EAST 26 10.28-267.3191935.59 June 14, 2025: 26 @ 10.28
July 6, 2025issueSO-250706-597MAIN 3 10.28-30.841171,202.90 June 14, 2025: 3 @ 10.28
June 14, 2025transferTRFMAIN → EAST 26 warehouse transfer, no cost effect
June 14, 2025receiptPO-000634MAIN 120 10.281,233.741201,233.74
June 3, 2025issueSO-250603-767MAIN 19 10.46-198.6800.00 Feb. 8, 2025: 19 @ 10.46
June 1, 2025issueSO-250601-843MAIN 10 10.46-104.5719198.68 Feb. 8, 2025: 10 @ 10.46
May 28, 2025issueSO-250528-359MAIN 8 10.46-83.6629303.25 Feb. 8, 2025: 8 @ 10.46
May 26, 2025issueSO-250526-364MAIN 2 10.46-20.9137386.91 Feb. 8, 2025: 2 @ 10.46
May 25, 2025issueSO-250525-978MAIN 5 10.46-52.2839407.82 Feb. 8, 2025: 5 @ 10.46
May 17, 2025issueSO-250517-901MAIN 8 10.46-83.6644460.10 Feb. 8, 2025: 8 @ 10.46
May 3, 2025issueSO-250503-413MAIN 2 10.46-20.9152543.76 Feb. 8, 2025: 2 @ 10.46
April 11, 2025issueSO-250411-293MAIN 1 10.46-10.4654564.67 Feb. 8, 2025: 1 @ 10.46
April 7, 2025issueSO-250407-589MAIN 18 10.46-188.2255575.13 Feb. 8, 2025: 18 @ 10.46
April 2, 2025issueSO-250402-898MAIN 10 10.46-104.5773763.35 Feb. 8, 2025: 10 @ 10.46
March 15, 2025issueSO-250315-253MAIN 19 10.46-198.6883867.92 Feb. 8, 2025: 19 @ 10.46
March 11, 2025issueSO-250311-104MAIN 9 10.46-94.111021,066.60 Feb. 8, 2025: 9 @ 10.46
Feb. 24, 2025issueSO-250224-885MAIN 11 10.47-115.131111,160.72 Oct. 1, 2024: 2 @ 10.51; Feb. 8, 2025: 9 @ 10.46
Feb. 20, 2025issueSO-250220-836MAIN 1 10.51-10.511221,275.84 Oct. 1, 2024: 1 @ 10.51
Feb. 15, 2025issueSO-250215-604MAIN 5 10.51-52.541231,286.35 Oct. 1, 2024: 5 @ 10.51
Feb. 13, 2025issueSO-250213-273MAIN 2 10.51-21.011281,338.88 Oct. 1, 2024: 2 @ 10.51
Feb. 8, 2025receiptPO-000246MAIN 120 10.461,254.831301,359.90
Jan. 29, 2025issueSO-250129-618MAIN 1 10.51-10.5110105.07 Oct. 1, 2024: 1 @ 10.51
Jan. 25, 2025issueSO-250125-625MAIN 14 10.51-147.1011115.58 Oct. 1, 2024: 14 @ 10.51
Jan. 20, 2025issueSO-250120-430MAIN 1 10.51-10.5125262.68 Oct. 1, 2024: 1 @ 10.51
Jan. 17, 2025issueSO-250117-586MAIN 2 10.51-21.0126273.18 Oct. 1, 2024: 2 @ 10.51
Jan. 10, 2025issueSO-250110-237MAIN 7 10.51-73.5528294.20 Oct. 1, 2024: 7 @ 10.51
Jan. 4, 2025issueSO-250104-869MAIN 1 10.51-10.5135367.74 Oct. 1, 2024: 1 @ 10.51
Dec. 15, 2024issueSO-241215-924MAIN 7 10.51-73.5536378.25 Oct. 1, 2024: 7 @ 10.51
Dec. 12, 2024issueSO-241212-555MAIN 25 10.51-262.6843451.80 Oct. 1, 2024: 25 @ 10.51
Nov. 13, 2024issueSO-241113-791MAIN 1 10.51-10.5168714.48 Oct. 1, 2024: 1 @ 10.51
Nov. 12, 2024issueSO-241112-501MAIN 4 10.51-42.0369724.98 Oct. 1, 2024: 4 @ 10.51
Nov. 9, 2024issueSO-241109-680MAIN 3 10.51-31.5273767.01 Oct. 1, 2024: 3 @ 10.51
Nov. 3, 2024issueSO-241103-138MAIN 12 10.51-126.0876798.53 Oct. 1, 2024: 12 @ 10.51
Nov. 2, 2024issueSO-241102-628MAIN 1 10.51-10.5188924.62 Oct. 1, 2024: 1 @ 10.51
Oct. 27, 2024issueSO-241027-612MAIN 10 10.51-105.0789935.12 Oct. 1, 2024: 10 @ 10.51
Oct. 16, 2024issueSO-241016-445MAIN 1 10.51-10.51991,040.19 Oct. 1, 2024: 1 @ 10.51
Oct. 15, 2024issueSO-241015-675MAIN 9 10.51-94.561001,050.70 Oct. 1, 2024: 9 @ 10.51
Oct. 1, 2024issueSO-241001-827MAIN 11 10.51-115.581091,145.26 Oct. 1, 2024: 11 @ 10.51
Oct. 1, 2024receiptPO-000002MAIN 120 10.511,260.841201,260.84