stocksense

Items / CON-0007

PVC Conduit 25mm Pro CON-0007 · Conduit & Fittings · Conduit & Cable Co

On hand (EA)290MAIN 200, EAST 90
Value (FIFO)3,627.03avg 12.51
ClassBX / FCV 0.26
Turnover5.8xlast issue 3 days ago
Days of cover104lead time 14d

Demand and forecast

Monthly demand and forecast for CON-00070.035.871.5107143Oct 24Dec 24Feb 25Apr 25Jun 25Aug 25Oct 25Dec 25Feb 26Apr 26Jun 26Aug 26Oct 24: 90.0Nov 24: 95.0Dec 24: 59.0Jan 25: 55.0Feb 25: 95.0Mar 25: 93.0Apr 25: 45.0May 25: 91.0Jun 25: 65.0Jul 25: 49.0Aug 25: 49.0Sep 25: 69.0Oct 25: 96.0Nov 25: 52.0Dec 25: 130.0Jan 26: 64.0Feb 26: 83.0Mar 26: 79.0Apr 26: 74.0May 26: 78.0Jun 26: 89.0Jul 26: 77.0Aug 26: 71.0Sep 26: 129.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.437585.17 / 30.43752.798
Daily demand sdmonthly sd / sqrt(30.4375)22.54 / 5.5174.086
Service level / zz = Phi^-1(service level)Phi^-1(0.950)1.645
Safety stockz * sqrt(LT * sd_d^2 + d^2 * sd_LT^2)1.645 * sqrt(14.0 * 4.086^2 + 2.798^2 * 3.1^2)29.0
Reorder pointd * LT + safety stock2.798 * 14.0 + 29.068.2
Order-up-to Sd * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2)R = 0 days68.2
EOQ (best price tier)sqrt(2 * D * S / H), H = holding rate * unit costD = 1021/yr, S = 45.00, h = 20%, price = 12.55191.4
Inventory positionon hand + on order290 + 0290

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

From qtyUnit costOrder qtyAnnual costFeasible
012.5519113,298yes (chosen if cheapest)

MOQ 320, pack size 20, ordering cost 45.00.

Open cost layers

ReceivedLeft / inUnit costValueExpiry
Oct. 2, 2026290 / 32012.513,627.03

Movement ledger 123 movements

DateTypeRefWarehouseQtyUnit costValue changeQty afterValue afterCost layers consumed
Oct. 13, 2026issueSO-261013-802MAIN 23 12.51-287.662903,627.03 Oct. 2, 2026: 23 @ 12.51
Oct. 2, 2026issueSO-261002-565MAIN 40 12.33-493.373133,914.69 June 24, 2026: 33 @ 12.30; Oct. 2, 2026: 7 @ 12.51
Oct. 2, 2026transferTRFMAIN → EAST 90 warehouse transfer, no cost effect
Oct. 2, 2026receiptPO-001844MAIN 320 12.514,002.243534,408.06
Oct. 1, 2026issueSO-261001-683MAIN 9 12.30-110.6833405.82 June 24, 2026: 9 @ 12.30
Sept. 18, 2026issueSO-260918-632MAIN 69 12.30-848.5342516.50 June 24, 2026: 69 @ 12.30
Sept. 13, 2026issueSO-260913-840MAIN 28 12.30-344.331111,365.02 June 24, 2026: 28 @ 12.30
Sept. 10, 2026issueSO-260910-758MAIN 32 12.30-393.521391,709.35 June 24, 2026: 32 @ 12.30
Aug. 30, 2026issueSO-260830-505MAIN 1 12.30-12.301712,102.87 June 24, 2026: 1 @ 12.30
Aug. 29, 2026issueSO-260829-272MAIN 14 12.30-172.161722,115.17 June 24, 2026: 14 @ 12.30
Aug. 26, 2026issueSO-260826-505MAIN 1 12.30-12.301862,287.34 June 24, 2026: 1 @ 12.30
Aug. 21, 2026issueSO-260821-882MAIN 1 12.30-12.301872,299.63 June 24, 2026: 1 @ 12.30
Aug. 14, 2026issueSO-260814-802MAIN 18 12.30-221.361882,311.93 June 24, 2026: 18 @ 12.30
Aug. 9, 2026issueSO-260809-634MAIN 6 12.30-73.782062,533.28 June 24, 2026: 6 @ 12.30
Aug. 3, 2026issueSO-260803-408MAIN 30 12.30-368.922122,607.07 June 24, 2026: 30 @ 12.30
July 29, 2026issueSO-260729-514MAIN 5 12.30-61.492422,976.00 June 24, 2026: 5 @ 12.30
July 24, 2026issueSO-260724-283MAIN 16 12.30-196.762473,037.48 June 24, 2026: 16 @ 12.30
July 18, 2026issueSO-260718-187MAIN 50 12.30-614.882633,234.24 June 24, 2026: 50 @ 12.30
July 10, 2026issueSO-260710-265MAIN 6 12.30-73.783133,849.12 June 24, 2026: 6 @ 12.30
June 29, 2026adjustmentCycle countMAIN -1 12.30-12.303193,922.90 June 24, 2026: 1 @ 12.30
June 24, 2026receiptPO-001600MAIN 320 12.303,935.203203,935.20
June 21, 2026issueSO-260621-313EAST 8 11.97-95.7300.00 Feb. 23, 2026: 8 @ 11.97
June 16, 2026issueSO-260616-465EAST 13 11.97-155.57895.73 Feb. 23, 2026: 13 @ 11.97
June 12, 2026issueSO-260612-332EAST 66 11.97-789.8021251.30 Feb. 23, 2026: 66 @ 11.97
June 12, 2026issueSO-260612-332MAIN 2 11.97-23.93871,041.10 Feb. 23, 2026: 2 @ 11.97
May 28, 2026issueSO-260528-999MAIN 12 11.97-143.60891,065.04 Feb. 23, 2026: 12 @ 11.97
May 25, 2026issueSO-260525-942MAIN 29 11.97-347.031011,208.64 Feb. 23, 2026: 29 @ 11.97
May 16, 2026issueSO-260516-199EAST 22 11.97-263.271301,555.67 Feb. 23, 2026: 22 @ 11.97
May 7, 2026issueSO-260507-624MAIN 14 11.97-167.531521,818.94 Feb. 23, 2026: 14 @ 11.97
May 6, 2026issueSO-260506-142MAIN 1 11.97-11.971661,986.47 Feb. 23, 2026: 1 @ 11.97
April 28, 2026issueSO-260428-278MAIN 5 11.97-59.831671,998.44 Feb. 23, 2026: 5 @ 11.97
April 24, 2026issueSO-260424-681MAIN 47 11.97-562.431722,058.27 Feb. 23, 2026: 47 @ 11.97
April 8, 2026issueSO-260408-928MAIN 21 11.97-251.302192,620.71 Feb. 23, 2026: 21 @ 11.97
April 7, 2026issueSO-260407-813MAIN 1 11.97-11.972402,872.01 Feb. 23, 2026: 1 @ 11.97
March 20, 2026issueSO-260320-177MAIN 13 11.97-155.572412,883.97 Feb. 23, 2026: 13 @ 11.97
March 16, 2026issueSO-260316-503MAIN 3 11.97-35.902543,039.54 Feb. 23, 2026: 3 @ 11.97
March 14, 2026issueSO-260314-931MAIN 31 11.97-370.972573,075.44 Feb. 23, 2026: 31 @ 11.97
March 7, 2026issueSO-260307-708MAIN 23 11.97-275.232883,446.41 Feb. 23, 2026: 23 @ 11.97
March 4, 2026issueSO-260304-230MAIN 9 11.97-107.703113,721.64 Feb. 23, 2026: 9 @ 11.97
Feb. 23, 2026transferTRFMAIN → EAST 109 warehouse transfer, no cost effect
Feb. 23, 2026receiptPO-001253MAIN 320 11.973,829.343203,829.34
Feb. 19, 2026issueSO-260219-707MAIN 2 11.91-23.8200.00 Oct. 29, 2025: 2 @ 11.91
Feb. 13, 2026issueSO-260213-737MAIN 49 11.91-583.63223.82 Oct. 29, 2025: 49 @ 11.91
Feb. 4, 2026issueSO-260204-179MAIN 15 11.91-178.6651607.46 Oct. 29, 2025: 15 @ 11.91
Feb. 3, 2026issueSO-260203-108MAIN 17 11.91-202.4966786.12 Oct. 29, 2025: 17 @ 11.91
Jan. 30, 2026issueSO-260130-171MAIN 9 11.91-107.2083988.60 Oct. 29, 2025: 9 @ 11.91
Jan. 26, 2026issueSO-260126-907MAIN 10 11.91-119.11921,095.80 Oct. 29, 2025: 10 @ 11.91
Jan. 25, 2026issueSO-260125-205MAIN 16 11.91-190.571021,214.91 Oct. 29, 2025: 16 @ 11.91
Jan. 13, 2026issueSO-260113-863MAIN 2 11.91-23.821181,405.49 Oct. 29, 2025: 2 @ 11.91
Jan. 7, 2026issueSO-260107-743MAIN 24 11.91-285.861201,429.31 Oct. 29, 2025: 24 @ 11.91
Jan. 6, 2026issueSO-260106-149MAIN 3 11.91-35.731441,715.17 Oct. 29, 2025: 3 @ 11.91
Dec. 30, 2025issueSO-251230-464MAIN 2 11.91-23.821471,750.90 Oct. 29, 2025: 2 @ 11.91
Dec. 28, 2025issueSO-251228-375MAIN 1 11.91-11.911491,774.72 Oct. 29, 2025: 1 @ 11.91
Dec. 27, 2025issueSO-251227-382MAIN 13 11.91-154.841501,786.64 Oct. 29, 2025: 13 @ 11.91
Dec. 22, 2025issueSO-251222-349MAIN 17 11.91-202.491631,941.48 Oct. 29, 2025: 17 @ 11.91
Dec. 8, 2025issueSO-251208-313MAIN 33 11.91-393.061802,143.96 Oct. 29, 2025: 33 @ 11.91
Dec. 7, 2025issueSO-251207-552MAIN 7 11.91-83.382132,537.02 Oct. 29, 2025: 7 @ 11.91
Dec. 2, 2025issueSO-251202-755MAIN 15 11.91-178.662202,620.40 Oct. 29, 2025: 15 @ 11.91
Dec. 2, 2025issueSO-251202-755EAST 42 11.91-500.262352,799.06 Oct. 29, 2025: 42 @ 11.91
Nov. 30, 2025issueSO-251130-442MAIN 4 11.91-47.642773,299.32 Oct. 29, 2025: 4 @ 11.91
Nov. 25, 2025issueSO-251125-300EAST 32 11.91-381.152813,346.96 Oct. 29, 2025: 32 @ 11.91
Nov. 10, 2025issueSO-251110-280EAST 1 11.91-11.913133,728.11 Oct. 29, 2025: 1 @ 11.91
Nov. 9, 2025issueSO-251109-417EAST 1 11.91-11.913143,740.02 Oct. 29, 2025: 1 @ 11.91
Nov. 3, 2025issueSO-251103-495EAST 14 12.07-168.943153,751.93 June 9, 2025: 9 @ 12.15; Oct. 29, 2025: 5 @ 11.91
Oct. 29, 2025transferTRFMAIN → EAST 81 warehouse transfer, no cost effect
Oct. 29, 2025receiptPO-000960MAIN 320 11.913,811.493293,920.87
Oct. 24, 2025issueSO-251024-719EAST 16 12.15-194.469109.38 June 9, 2025: 16 @ 12.15
Oct. 17, 2025issueSO-251017-766EAST 34 12.15-413.2225303.84 June 9, 2025: 34 @ 12.15
Oct. 13, 2025issueSO-251013-635EAST 15 12.15-182.3059717.06 June 9, 2025: 15 @ 12.15
Oct. 13, 2025issueSO-251013-635MAIN 9 12.15-109.3874899.37 June 9, 2025: 9 @ 12.15
Oct. 6, 2025issueSO-251006-393MAIN 1 12.15-12.15831,008.75 June 9, 2025: 1 @ 12.15
Oct. 4, 2025issueSO-251004-789MAIN 21 12.15-255.23841,020.90 June 9, 2025: 21 @ 12.15
Sept. 28, 2025issueSO-250928-110MAIN 42 12.15-510.451051,276.13 June 9, 2025: 42 @ 12.15
Sept. 16, 2025issueSO-250916-410MAIN 4 12.15-48.611471,786.58 June 9, 2025: 4 @ 12.15
Sept. 12, 2025issueSO-250912-675MAIN 10 12.15-121.541511,835.19 June 9, 2025: 10 @ 12.15
Sept. 8, 2025issueSO-250908-808EAST 13 12.15-158.001611,956.73 June 9, 2025: 13 @ 12.15
Aug. 31, 2025issueSO-250831-454MAIN 33 12.15-401.071742,114.73 June 9, 2025: 33 @ 12.15
Aug. 6, 2025issueSO-250806-542MAIN 16 12.15-194.462072,515.80 June 9, 2025: 16 @ 12.15
July 12, 2025issueSO-250712-592MAIN 6 12.15-72.922232,710.25 June 9, 2025: 6 @ 12.15
July 3, 2025issueSO-250703-867MAIN 43 12.15-522.602292,783.17 June 9, 2025: 43 @ 12.15
June 21, 2025issueSO-250621-504MAIN 53 12.08-640.222723,305.78 Jan. 20, 2025: 5 @ 11.37; June 9, 2025: 48 @ 12.15
June 13, 2025issueSO-250613-599MAIN 12 11.37-136.433253,946.00 Jan. 20, 2025: 12 @ 11.37
June 9, 2025transferTRFMAIN → EAST 87 warehouse transfer, no cost effect
June 9, 2025receiptPO-000619MAIN 320 12.153,889.153374,082.43
May 25, 2025issueSO-250525-999MAIN 44 11.37-500.2617193.28 Jan. 20, 2025: 44 @ 11.37
May 15, 2025issueSO-250515-808MAIN 20 11.37-227.3961693.54 Jan. 20, 2025: 20 @ 11.37
May 13, 2025issueSO-250513-965MAIN 15 11.37-170.5481920.93 Jan. 20, 2025: 15 @ 11.37
May 10, 2025issueSO-250510-855MAIN 2 11.37-22.74961,091.47 Jan. 20, 2025: 2 @ 11.37
May 7, 2025issueSO-250507-917MAIN 10 11.37-113.70981,114.21 Jan. 20, 2025: 10 @ 11.37
April 29, 2025issueSO-250429-549MAIN 31 11.37-352.451081,227.91 Jan. 20, 2025: 31 @ 11.37
April 27, 2025issueSO-250427-978MAIN 6 11.37-68.221391,580.36 Jan. 20, 2025: 6 @ 11.37
April 25, 2025issueSO-250425-406MAIN 2 11.37-22.741451,648.58 Jan. 20, 2025: 2 @ 11.37
April 4, 2025issueSO-250404-254MAIN 6 11.37-68.221471,671.32 Jan. 20, 2025: 6 @ 11.37
March 29, 2025issueSO-250329-532MAIN 10 11.37-113.701531,739.53 Jan. 20, 2025: 10 @ 11.37
March 19, 2025issueSO-250319-763MAIN 29 11.37-329.721631,853.23 Jan. 20, 2025: 29 @ 11.37
March 16, 2025issueSO-250316-442MAIN 24 11.37-272.871922,182.94 Jan. 20, 2025: 24 @ 11.37
March 11, 2025issueSO-250311-293MAIN 3 11.37-34.112162,455.81 Jan. 20, 2025: 3 @ 11.37
March 6, 2025issueSO-250306-775MAIN 5 11.37-56.852192,489.92 Jan. 20, 2025: 5 @ 11.37
March 4, 2025issueSO-250304-751MAIN 22 11.37-250.132242,546.77 Jan. 20, 2025: 22 @ 11.37
Feb. 20, 2025issueSO-250220-813MAIN 24 11.37-272.872462,796.90 Jan. 20, 2025: 24 @ 11.37
Feb. 17, 2025issueSO-250217-329MAIN 36 11.37-409.302703,069.76 Jan. 20, 2025: 36 @ 11.37
Feb. 16, 2025issueSO-250216-275MAIN 12 11.37-136.433063,479.07 Jan. 20, 2025: 12 @ 11.37
Feb. 8, 2025issueSO-250208-205MAIN 2 11.37-22.743183,615.50 Jan. 20, 2025: 2 @ 11.37
Feb. 2, 2025issueSO-250202-355MAIN 21 11.92-250.373203,638.24 Oct. 1, 2024: 21 @ 11.92
Jan. 20, 2025receiptPO-000201MAIN 320 11.373,638.243413,888.61
Jan. 15, 2025issueSO-250115-727MAIN 32 11.92-381.5221250.37 Oct. 1, 2024: 32 @ 11.92
Jan. 10, 2025issueSO-250110-532MAIN 8 11.92-95.3853631.89 Oct. 1, 2024: 8 @ 11.92
Jan. 6, 2025issueSO-250106-436MAIN 15 11.92-178.8461727.27 Oct. 1, 2024: 15 @ 11.92
Dec. 30, 2024issueSO-241230-608MAIN 14 11.92-166.9276906.11 Oct. 1, 2024: 14 @ 11.92
Dec. 26, 2024issueSO-241226-264MAIN 3 11.92-35.77901,073.02 Oct. 1, 2024: 3 @ 11.92
Dec. 20, 2024issueSO-241220-637MAIN 7 11.92-83.46931,108.79 Oct. 1, 2024: 7 @ 11.92
Dec. 19, 2024issueSO-241219-506MAIN 2 11.92-23.841001,192.25 Oct. 1, 2024: 2 @ 11.92
Dec. 7, 2024issueSO-241207-992MAIN 31 11.92-369.601021,216.10 Oct. 1, 2024: 31 @ 11.92
Dec. 2, 2024issueSO-241202-703MAIN 2 11.92-23.841331,585.69 Oct. 1, 2024: 2 @ 11.92
Nov. 26, 2024issueSO-241126-686MAIN 20 11.92-238.451351,609.54 Oct. 1, 2024: 20 @ 11.92
Nov. 15, 2024issueSO-241115-747MAIN 1 11.92-11.921551,847.99 Oct. 1, 2024: 1 @ 11.92
Nov. 10, 2024issueSO-241110-408MAIN 2 11.92-23.841561,859.91 Oct. 1, 2024: 2 @ 11.92
Nov. 9, 2024issueSO-241109-501MAIN 2 11.92-23.841581,883.76 Oct. 1, 2024: 2 @ 11.92
Nov. 5, 2024issueSO-241105-522MAIN 70 11.92-834.581601,907.60 Oct. 1, 2024: 70 @ 11.92
Oct. 24, 2024issueSO-241024-143MAIN 46 11.92-548.442302,742.18 Oct. 1, 2024: 46 @ 11.92
Oct. 18, 2024issueSO-241018-695MAIN 30 11.92-357.682763,290.61 Oct. 1, 2024: 30 @ 11.92
Oct. 17, 2024issueSO-241017-926MAIN 14 11.92-166.923063,648.28 Oct. 1, 2024: 14 @ 11.92
Oct. 1, 2024receiptPO-000002MAIN 320 11.923,815.203203,815.20