stocksense

Items / CON-0016

PVC Conduit 25mm Prime CON-0016 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)243MAIN 181, EAST 62
Value (FIFO)10,926.32avg 44.96
ClassAX / FCV 0.25
Turnover3.8xlast issue 3 days ago
Days of cover99lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00160.028.356.785.0113Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 86.0Nov 24: 80.0Dec 24: 83.0Jan 25: 86.0Feb 25: 67.0Mar 25: 71.0Apr 25: 61.0May 25: 84.0Jun 25: 70.0Jul 25: 83.0Aug 25: 50.0Sep 25: 76.0Oct 25: 72.0Nov 25: 94.0Dec 25: 92.0Jan 26: 34.0Feb 26: 88.0Mar 26: 82.0Apr 26: 84.0May 26: 55.0Jun 26: 63.0Jul 26: 103.0Aug 26: 64.0Sep 26: 70.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.437575.08 / 30.43752.467
Daily demand sdmonthly sd / sqrt(30.4375)18.51 / 5.5173.356
Service level / zz = Phi^-1(service level)Phi^-1(0.980)2.054
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)2.054 * sqrt(14.0 * 3.356^2 + 2.467^2 * 3.1^2)30.2
Reorder pointd * LT + safety stock2.467 * 14.0 + 30.264.9
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days64.9
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 900/yr, S = 45.00, h = 20%, price = 45.3494.5
Inventory positionon hand + on order243 + 0243

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

From qtyUnit costOrder qtyAnnual costFeasible
045.349541,681yes (chosen if cheapest)

MOQ 300, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Sept. 20, 2026243 / 30044.9610,926.32

Movement ledger 120 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026issueSO-261013-469EAST 5 44.96-224.8224310,926.32 Sept. 20, 2026: 5 @ 44.96
Oct. 10, 2026issueSO-261010-183MAIN 41 44.96-1,843.5424811,151.15 Sept. 20, 2026: 41 @ 44.96
Oct. 4, 2026issueSO-261004-379EAST 8 44.96-359.7128912,994.68 Sept. 20, 2026: 8 @ 44.96
Oct. 3, 2026issueSO-261003-144MAIN 3 44.96-134.8929713,354.40 Sept. 20, 2026: 3 @ 44.96
Sept. 20, 2026transferTRFMAIN → EAST 75 warehouse transfer, no cost effect
Sept. 20, 2026receiptPO-001813MAIN 300 44.9613,489.2930013,489.29
Sept. 14, 2026issueSO-260914-440MAIN 12 44.84-538.0200.00 May 30, 2026: 12 @ 44.84
Sept. 10, 2026issueSO-260910-657MAIN 58 44.84-2,600.4412538.02 May 30, 2026: 58 @ 44.84
Aug. 24, 2026issueSO-260824-450MAIN 21 44.84-941.54703,138.46 May 30, 2026: 21 @ 44.84
Aug. 16, 2026issueSO-260816-289MAIN 6 44.84-269.01914,080.00 May 30, 2026: 6 @ 44.84
Aug. 12, 2026issueSO-260812-212MAIN 8 44.84-358.68974,349.01 May 30, 2026: 8 @ 44.84
Aug. 6, 2026issueSO-260806-520MAIN 22 44.84-986.371054,707.70 May 30, 2026: 22 @ 44.84
Aug. 2, 2026issueSO-260802-825MAIN 7 44.84-313.851275,694.07 May 30, 2026: 7 @ 44.84
July 30, 2026issueSO-260730-344MAIN 49 44.84-2,196.921346,007.92 May 30, 2026: 49 @ 44.84
July 27, 2026issueSO-260727-566MAIN 54 44.84-2,421.101838,204.84 May 30, 2026: 54 @ 44.84
June 27, 2026issueSO-260627-699MAIN 4 44.84-179.3423710,625.94 May 30, 2026: 4 @ 44.84
June 20, 2026issueSO-260620-640MAIN 6 44.84-269.0124110,805.28 May 30, 2026: 6 @ 44.84
June 19, 2026issueSO-260619-595MAIN 6 44.84-269.0124711,074.29 May 30, 2026: 6 @ 44.84
June 12, 2026issueSO-260612-999MAIN 5 44.84-224.1825311,343.31 May 30, 2026: 5 @ 44.84
June 3, 2026issueSO-260603-288MAIN 3 44.84-134.5125811,567.48 May 30, 2026: 3 @ 44.84
June 1, 2026issueSO-260601-292MAIN 39 44.84-1,748.5726111,701.99 May 30, 2026: 39 @ 44.84
May 30, 2026receiptPO-001534MAIN 300 44.8413,450.5630013,450.56
May 19, 2026issueSO-260519-749EAST 50 43.35-2,167.7300.00 Dec. 25, 2025: 29 @ 43.15; Jan. 19, 2026: 21 @ 43.64
May 17, 2026issueSO-260517-942EAST 5 43.15-215.73502,167.73 Dec. 25, 2025: 5 @ 43.15
April 11, 2026issueSO-260411-174EAST 13 43.15-560.89552,383.45 Dec. 25, 2025: 13 @ 43.15
April 10, 2026issueSO-260410-368EAST 1 43.15-43.15682,944.34 Dec. 25, 2025: 1 @ 43.15
April 9, 2026issueSO-260409-657EAST 7 43.15-302.02692,987.49 Dec. 25, 2025: 7 @ 43.15
April 5, 2026issueSO-260405-294EAST 1 43.15-43.15763,289.51 Dec. 25, 2025: 1 @ 43.15
April 1, 2026issueSO-260401-515EAST 3 43.15-129.44773,332.65 Dec. 25, 2025: 3 @ 43.15
April 1, 2026issueSO-260401-515MAIN 59 43.15-2,545.58803,462.09 Dec. 25, 2025: 59 @ 43.15
March 26, 2026issueSO-260326-135MAIN 18 43.15-776.621396,007.67 Dec. 25, 2025: 18 @ 43.15
March 22, 2026issueSO-260322-926EAST 9 43.15-388.311576,784.28 Dec. 25, 2025: 9 @ 43.15
March 17, 2026issueSO-260317-682MAIN 8 43.15-345.161667,172.59 Dec. 25, 2025: 8 @ 43.15
March 16, 2026issueSO-260316-984MAIN 10 43.15-431.451747,517.76 Dec. 25, 2025: 10 @ 43.15
March 10, 2026issueSO-260310-949MAIN 17 43.15-733.471847,949.21 Dec. 25, 2025: 17 @ 43.15
March 9, 2026issueSO-260309-596EAST 12 43.15-517.742018,682.68 Dec. 25, 2025: 12 @ 43.15
March 2, 2026issueSO-260302-796MAIN 8 43.15-345.162139,200.43 Dec. 25, 2025: 8 @ 43.15
Feb. 27, 2026issueSO-260227-680MAIN 23 43.15-992.342219,545.59 Dec. 25, 2025: 23 @ 43.15
Feb. 20, 2026issueSO-260220-307MAIN 34 43.15-1,466.9424410,537.93 Dec. 25, 2025: 34 @ 43.15
Feb. 18, 2026issueSO-260218-478MAIN 13 43.15-560.8927812,004.88 Dec. 25, 2025: 13 @ 43.15
Feb. 17, 2026issueSO-260217-743MAIN 10 43.15-431.4529112,565.77 Dec. 25, 2025: 10 @ 43.15
Feb. 9, 2026issueSO-260209-101MAIN 8 43.15-345.1630112,997.22 Dec. 25, 2025: 8 @ 43.15
Jan. 19, 2026returnRMAMAIN 21 43.64916.5130913,342.39
Jan. 7, 2026issueSO-260107-628MAIN 42 43.64-1,833.0228812,425.88 Sept. 21, 2025: 30 @ 43.84; Dec. 25, 2025: 12 @ 43.15
Jan. 1, 2026issueSO-260101-169MAIN 13 43.84-569.9533014,258.90 Sept. 21, 2025: 13 @ 43.84
Dec. 25, 2025transferTRFMAIN → EAST 101 warehouse transfer, no cost effect
Dec. 25, 2025receiptPO-001087MAIN 300 43.1512,943.6234314,828.85
Dec. 12, 2025issueSO-251212-789MAIN 1 43.84-43.84431,885.23 Sept. 21, 2025: 1 @ 43.84
Dec. 11, 2025issueSO-251211-631MAIN 39 43.84-1,709.86441,929.07 Sept. 21, 2025: 39 @ 43.84
Dec. 7, 2025issueSO-251207-951MAIN 2 43.84-87.68833,638.93 Sept. 21, 2025: 2 @ 43.84
Dec. 5, 2025issueSO-251205-151MAIN 43 43.84-1,885.23853,726.61 Sept. 21, 2025: 43 @ 43.84
Dec. 1, 2025issueSO-251201-330MAIN 7 43.84-306.901285,611.84 Sept. 21, 2025: 7 @ 43.84
Nov. 26, 2025issueSO-251126-765MAIN 65 43.84-2,849.761355,918.74 Sept. 21, 2025: 65 @ 43.84
Nov. 15, 2025issueSO-251115-620MAIN 13 43.84-569.952008,768.50 Sept. 21, 2025: 13 @ 43.84
Nov. 14, 2025issueSO-251114-650MAIN 16 43.84-701.482139,338.45 Sept. 21, 2025: 16 @ 43.84
Oct. 29, 2025issueSO-251029-301MAIN 8 43.84-350.7422910,039.93 Sept. 21, 2025: 8 @ 43.84
Oct. 22, 2025issueSO-251022-137MAIN 1 43.84-43.8423710,390.67 Sept. 21, 2025: 1 @ 43.84
Oct. 13, 2025issueSO-251013-968MAIN 59 43.84-2,586.7123810,434.52 Sept. 21, 2025: 59 @ 43.84
Oct. 2, 2025issueSO-251002-875MAIN 4 43.49-173.9629713,021.22 Sept. 11, 2025: 1 @ 42.43; Sept. 21, 2025: 3 @ 43.84
Sept. 30, 2025issueSO-250930-302MAIN 28 42.43-1,188.1230113,195.18 May 24, 2025: 20 @ 42.43; Aug. 28, 2025: 3 @ 42.43; Sept. 11, 2025: 5 @ 42.43
Sept. 23, 2025issueSO-250923-725MAIN 8 42.43-339.4632914,383.30 May 24, 2025: 8 @ 42.43
Sept. 21, 2025receiptPO-000864MAIN 300 43.8413,152.7533714,722.77
Sept. 12, 2025issueSO-250912-852MAIN 6 42.43-254.60371,570.02 May 24, 2025: 6 @ 42.43
Sept. 11, 2025returnRMAMAIN 6 42.43254.60431,824.61
Sept. 9, 2025issueSO-250909-309MAIN 21 42.43-891.09371,570.02 May 24, 2025: 21 @ 42.43
Sept. 7, 2025issueSO-250907-834MAIN 12 42.43-509.19582,461.11 May 24, 2025: 12 @ 42.43
Sept. 1, 2025issueSO-250901-927MAIN 7 42.43-297.03702,970.30 May 24, 2025: 7 @ 42.43
Aug. 30, 2025adjustmentCycle countMAIN -2 42.43-84.87773,267.33 May 24, 2025: 2 @ 42.43
Aug. 29, 2025issueSO-250829-242MAIN 4 42.43-169.73793,352.20 May 24, 2025: 4 @ 42.43
Aug. 28, 2025returnRMAMAIN 3 42.43127.30833,521.93
Aug. 14, 2025issueSO-250814-852MAIN 7 42.43-297.03803,394.63 May 24, 2025: 7 @ 42.43
Aug. 9, 2025issueSO-250809-468MAIN 42 42.43-1,782.18873,691.66 May 24, 2025: 42 @ 42.43
July 31, 2025issueSO-250731-355MAIN 6 42.43-254.601295,473.84 May 24, 2025: 6 @ 42.43
July 27, 2025issueSO-250727-611MAIN 1 42.43-42.431355,728.44 May 24, 2025: 1 @ 42.43
July 25, 2025issueSO-250725-831MAIN 27 42.43-1,145.691365,770.87 May 24, 2025: 27 @ 42.43
July 17, 2025issueSO-250717-476MAIN 1 42.43-42.431636,916.56 May 24, 2025: 1 @ 42.43
July 10, 2025issueSO-250710-683MAIN 35 42.43-1,485.151646,959.00 May 24, 2025: 35 @ 42.43
July 9, 2025issueSO-250709-262MAIN 13 42.43-551.631998,444.15 May 24, 2025: 13 @ 42.43
June 12, 2025issueSO-250612-826MAIN 4 42.43-169.732128,995.77 May 24, 2025: 4 @ 42.43
June 7, 2025issueSO-250607-356MAIN 5 42.43-212.162169,165.51 May 24, 2025: 5 @ 42.43
June 6, 2025issueSO-250606-970MAIN 48 42.43-2,036.782219,377.67 May 24, 2025: 48 @ 42.43
June 5, 2025issueSO-250605-120MAIN 5 42.43-212.1626911,414.45 May 24, 2025: 5 @ 42.43
June 1, 2025issueSO-250601-749MAIN 8 42.43-339.4627411,626.61 May 24, 2025: 8 @ 42.43
May 27, 2025issueSO-250527-188MAIN 68 41.93-2,851.4028211,966.08 Jan. 11, 2025: 50 @ 41.75; May 24, 2025: 18 @ 42.43
May 24, 2025receiptPO-000565MAIN 300 42.4312,729.8735014,817.48
May 12, 2025issueSO-250512-676MAIN 16 41.75-668.03502,087.60 Jan. 11, 2025: 16 @ 41.75
April 25, 2025issueSO-250425-505MAIN 5 41.75-208.76662,755.64 Jan. 11, 2025: 5 @ 41.75
April 23, 2025issueSO-250423-900MAIN 8 41.75-334.02712,964.40 Jan. 11, 2025: 8 @ 41.75
April 21, 2025issueSO-250421-600MAIN 1 41.75-41.75793,298.42 Jan. 11, 2025: 1 @ 41.75
April 10, 2025issueSO-250410-353MAIN 9 41.75-375.77803,340.17 Jan. 11, 2025: 9 @ 41.75
April 1, 2025issueSO-250401-366MAIN 38 41.75-1,586.58893,715.94 Jan. 11, 2025: 38 @ 41.75
March 16, 2025issueSO-250316-273MAIN 39 41.75-1,628.331275,302.52 Jan. 11, 2025: 39 @ 41.75
March 14, 2025issueSO-250314-973MAIN 5 41.75-208.761666,930.85 Jan. 11, 2025: 5 @ 41.75
March 12, 2025issueSO-250312-660MAIN 4 41.75-167.011717,139.61 Jan. 11, 2025: 4 @ 41.75
March 11, 2025issueSO-250311-406MAIN 23 41.75-960.301757,306.62 Jan. 11, 2025: 23 @ 41.75
Feb. 19, 2025issueSO-250219-697MAIN 22 41.75-918.551988,266.92 Jan. 11, 2025: 22 @ 41.75
Feb. 3, 2025issueSO-250203-606MAIN 45 41.75-1,878.842209,185.46 Jan. 11, 2025: 45 @ 41.75
Jan. 21, 2025issueSO-250121-462MAIN 11 41.75-459.2726511,064.31 Jan. 11, 2025: 11 @ 41.75
Jan. 17, 2025issueSO-250117-216MAIN 64 42.58-2,724.9727611,523.58 Oct. 1, 2024: 38 @ 43.07; Nov. 21, 2024: 2 @ 43.07; Jan. 11, 2025: 24 @ 41.75
Jan. 11, 2025receiptPO-000180MAIN 300 41.7512,525.6334014,248.55
Jan. 6, 2025issueSO-250106-675MAIN 11 43.07-473.80401,722.92 Oct. 1, 2024: 11 @ 43.07
Dec. 29, 2024issueSO-241229-938MAIN 19 43.07-818.39512,196.72 Oct. 1, 2024: 19 @ 43.07
Dec. 23, 2024issueSO-241223-312MAIN 7 43.07-301.51703,015.11 Oct. 1, 2024: 7 @ 43.07
Dec. 21, 2024issueSO-241221-836MAIN 41 43.07-1,765.99773,316.62 Oct. 1, 2024: 41 @ 43.07
Dec. 21, 2024issueSO-241221-836EAST 16 43.07-689.171185,082.61 Oct. 1, 2024: 16 @ 43.07
Nov. 25, 2024issueSO-241125-511EAST 4 43.07-172.291345,771.78 Oct. 1, 2024: 4 @ 43.07
Nov. 21, 2024returnRMAMAIN 2 43.0786.151385,944.07
Nov. 19, 2024issueSO-241119-431MAIN 12 43.07-516.881365,857.93 Oct. 1, 2024: 12 @ 43.07
Nov. 8, 2024issueSO-241108-556EAST 5 43.07-215.361486,374.80 Oct. 1, 2024: 5 @ 43.07
Nov. 7, 2024issueSO-241107-613EAST 25 43.07-1,076.821536,590.17 Oct. 1, 2024: 25 @ 43.07
Nov. 3, 2024issueSO-241103-620MAIN 36 43.07-1,550.631787,666.99 Oct. 1, 2024: 36 @ 43.07
Oct. 31, 2024issueSO-241031-366MAIN 12 43.07-516.882149,217.62 Oct. 1, 2024: 12 @ 43.07
Oct. 28, 2024issueSO-241028-675MAIN 10 43.07-430.732269,734.50 Oct. 1, 2024: 10 @ 43.07
Oct. 25, 2024issueSO-241025-434MAIN 16 43.07-689.1723610,165.23 Oct. 1, 2024: 16 @ 43.07
Oct. 13, 2024issueSO-241013-784EAST 14 43.07-603.0225210,854.40 Oct. 1, 2024: 14 @ 43.07
Oct. 10, 2024issueSO-241010-810MAIN 16 43.07-689.1726611,457.42 Oct. 1, 2024: 16 @ 43.07
Oct. 6, 2024issueSO-241006-738EAST 2 43.07-86.1528212,146.59 Oct. 1, 2024: 2 @ 43.07
Oct. 5, 2024issueSO-241005-316EAST 16 43.07-689.1728412,232.73 Oct. 1, 2024: 16 @ 43.07
Oct. 1, 2024transferTRFMAIN → EAST 82 warehouse transfer, no cost effect
Oct. 1, 2024receiptPO-000002MAIN 300 43.0712,921.9030012,921.90