Items / CON-0014
PVC Conduit 25mm Classic CON-0014 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)23MAIN 23
Value (FIFO)211.22avg 9.18
ClassCX / FCV 0.21
Turnover29.3xlast issue 7 days ago
Days of cover17lead time 14d
Reorder suggested: 180 units (position at or below reorder point: order EOQ), stockout risk medium.
Demand and forecast
actual forecast 90% prediction interval
No forecast run yet for this item. Run forecasts. Policy numbers use trailing 12-month demand.
Policy numbers explained
| Metric | Formula | Substituted | Result |
|---|---|---|---|
| Daily demand d | monthly mean / 30.4375 | 42.33 / 30.4375 | 1.391 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.07 / 5.517 | 1.644 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(14.0 * 1.644^2 + 1.391^2 * 3.1^2) | 9.6 |
| Reorder point | d * LT + safety stock | 1.391 * 14.0 + 9.6 | 29.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 29.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 508/yr, S = 45.00, h = 20%, price = 9.06 | 158.8 |
| Inventory position | on hand + on order | 23 + 0 | 23 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 9.06 | 159 | 4,887 | yes (chosen if cheapest) |
MOQ 180, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 17, 2026 | 23 / 180 | 9.18 | 211.22 |
Movement ledger 98 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 9, 2026 | issue | SO-261009-987 | MAIN | 11 | 9.18 | -101.02 | 23 | 211.22 | July 17, 2026: 11 @ 9.18 |
| Oct. 7, 2026 | issue | SO-261007-572 | MAIN | 19 | 9.18 | -174.49 | 34 | 312.24 | July 17, 2026: 19 @ 9.18 |
| Oct. 6, 2026 | issue | SO-261006-390 | MAIN | 29 | 9.18 | -266.32 | 53 | 486.73 | July 17, 2026: 29 @ 9.18 |
| Sept. 27, 2026 | issue | SO-260927-560 | MAIN | 10 | 9.18 | -91.84 | 82 | 753.05 | July 17, 2026: 10 @ 9.18 |
| Sept. 22, 2026 | issue | SO-260922-815 | MAIN | 6 | 9.18 | -55.10 | 92 | 844.88 | July 17, 2026: 6 @ 9.18 |
| Sept. 17, 2026 | issue | SO-260917-171 | MAIN | 14 | 9.18 | -128.57 | 98 | 899.98 | July 17, 2026: 14 @ 9.18 |
| Sept. 10, 2026 | issue | SO-260910-652 | MAIN | 5 | 9.18 | -45.92 | 112 | 1,028.55 | July 17, 2026: 5 @ 9.18 |
| Sept. 8, 2026 | issue | SO-260908-775 | MAIN | 9 | 9.18 | -82.65 | 117 | 1,074.47 | July 17, 2026: 9 @ 9.18 |
| Aug. 26, 2026 | issue | SO-260826-231 | MAIN | 26 | 9.18 | -238.77 | 126 | 1,157.12 | July 17, 2026: 26 @ 9.18 |
| Aug. 21, 2026 | issue | SO-260821-108 | MAIN | 1 | 9.18 | -9.18 | 152 | 1,395.89 | July 17, 2026: 1 @ 9.18 |
| Aug. 10, 2026 | issue | SO-260810-225 | MAIN | 10 | 9.18 | -91.84 | 153 | 1,405.08 | July 17, 2026: 10 @ 9.18 |
| Aug. 9, 2026 | issue | SO-260809-660 | MAIN | 7 | 9.18 | -64.28 | 163 | 1,496.91 | July 17, 2026: 7 @ 9.18 |
| July 26, 2026 | issue | SO-260726-197 | MAIN | 2 | 9.18 | -18.37 | 170 | 1,561.20 | July 17, 2026: 2 @ 9.18 |
| July 20, 2026 | issue | SO-260720-800 | MAIN | 29 | 9.00 | -261.03 | 172 | 1,579.56 | March 3, 2026: 21 @ 8.93; July 17, 2026: 8 @ 9.18 |
| July 17, 2026 | receipt | PO-001652 | MAIN | 180 | 9.18 | 1,653.03 | 201 | 1,840.60 | |
| July 1, 2026 | issue | SO-260701-696 | MAIN | 11 | 8.93 | -98.25 | 21 | 187.57 | March 3, 2026: 11 @ 8.93 |
| June 29, 2026 | issue | SO-260629-549 | MAIN | 10 | 8.93 | -89.32 | 32 | 285.81 | March 3, 2026: 10 @ 8.93 |
| June 25, 2026 | issue | SO-260625-598 | MAIN | 3 | 8.93 | -26.80 | 42 | 375.13 | March 3, 2026: 3 @ 8.93 |
| June 6, 2026 | issue | SO-260606-994 | MAIN | 5 | 8.93 | -44.66 | 45 | 401.93 | March 3, 2026: 5 @ 8.93 |
| June 4, 2026 | issue | SO-260604-610 | MAIN | 26 | 8.93 | -232.22 | 50 | 446.58 | March 3, 2026: 26 @ 8.93 |
| May 31, 2026 | issue | SO-260531-196 | MAIN | 8 | 8.93 | -71.45 | 76 | 678.81 | March 3, 2026: 8 @ 8.93 |
| May 26, 2026 | issue | SO-260526-734 | MAIN | 21 | 8.93 | -187.57 | 84 | 750.26 | March 3, 2026: 21 @ 8.93 |
| May 17, 2026 | issue | SO-260517-219 | MAIN | 1 | 8.93 | -8.93 | 105 | 937.83 | March 3, 2026: 1 @ 8.93 |
| May 8, 2026 | issue | SO-260508-783 | MAIN | 6 | 8.93 | -53.59 | 106 | 946.76 | March 3, 2026: 6 @ 8.93 |
| May 6, 2026 | issue | SO-260506-800 | MAIN | 10 | 8.93 | -89.32 | 112 | 1,000.35 | March 3, 2026: 10 @ 8.93 |
| May 2, 2026 | issue | SO-260502-649 | MAIN | 2 | 8.93 | -17.86 | 122 | 1,089.67 | March 3, 2026: 2 @ 8.93 |
| April 28, 2026 | issue | SO-260428-896 | MAIN | 25 | 8.93 | -223.29 | 124 | 1,107.53 | March 3, 2026: 25 @ 8.93 |
| April 26, 2026 | issue | SO-260426-567 | MAIN | 3 | 8.93 | -26.80 | 149 | 1,330.82 | March 3, 2026: 3 @ 8.93 |
| April 15, 2026 | issue | SO-260415-818 | MAIN | 13 | 8.93 | -116.11 | 152 | 1,357.62 | March 3, 2026: 13 @ 8.93 |
| March 18, 2026 | issue | SO-260318-458 | MAIN | 3 | 8.93 | -26.80 | 165 | 1,473.73 | March 3, 2026: 3 @ 8.93 |
| March 11, 2026 | issue | SO-260311-366 | MAIN | 39 | 8.78 | -342.60 | 168 | 1,500.53 | Oct. 21, 2025: 19 @ 8.72; Dec. 27, 2025: 8 @ 8.72; March 3, 2026: 12 @ 8.93 |
| March 3, 2026 | receipt | PO-001280 | MAIN | 180 | 8.93 | 1,607.71 | 207 | 1,843.13 | |
| Feb. 20, 2026 | issue | SO-260220-770 | MAIN | 27 | 8.72 | -235.42 | 27 | 235.42 | Oct. 21, 2025: 27 @ 8.72 |
| Feb. 8, 2026 | issue | SO-260208-434 | MAIN | 34 | 8.72 | -296.46 | 54 | 470.85 | Oct. 21, 2025: 34 @ 8.72 |
| Feb. 4, 2026 | issue | SO-260204-357 | MAIN | 1 | 8.72 | -8.72 | 88 | 767.31 | Oct. 21, 2025: 1 @ 8.72 |
| Jan. 23, 2026 | issue | SO-260123-690 | MAIN | 16 | 8.72 | -139.51 | 89 | 776.03 | Oct. 21, 2025: 16 @ 8.72 |
| Jan. 19, 2026 | issue | SO-260119-919 | MAIN | 17 | 8.72 | -148.23 | 105 | 915.54 | Oct. 21, 2025: 17 @ 8.72 |
| Dec. 27, 2025 | return | RMA | MAIN | 8 | 8.72 | 69.76 | 122 | 1,063.77 | |
| Dec. 24, 2025 | issue | SO-251224-966 | MAIN | 16 | 8.72 | -139.51 | 114 | 994.01 | Oct. 21, 2025: 16 @ 8.72 |
| Dec. 15, 2025 | issue | SO-251215-379 | MAIN | 13 | 8.72 | -113.35 | 130 | 1,133.52 | Oct. 21, 2025: 13 @ 8.72 |
| Nov. 14, 2025 | issue | SO-251114-595 | MAIN | 10 | 8.72 | -87.19 | 143 | 1,246.87 | Oct. 21, 2025: 10 @ 8.72 |
| Nov. 6, 2025 | issue | SO-251106-826 | MAIN | 36 | 8.62 | -310.31 | 153 | 1,334.07 | June 18, 2025: 9 @ 8.32; Oct. 21, 2025: 27 @ 8.72 |
| Oct. 22, 2025 | issue | SO-251022-572 | MAIN | 5 | 8.32 | -41.60 | 189 | 1,644.38 | June 18, 2025: 5 @ 8.32 |
| Oct. 21, 2025 | receipt | PO-000938 | MAIN | 180 | 8.72 | 1,569.49 | 194 | 1,685.99 | |
| Oct. 5, 2025 | issue | SO-251005-549 | MAIN | 21 | 8.32 | -174.74 | 14 | 116.49 | June 18, 2025: 21 @ 8.32 |
| Oct. 3, 2025 | issue | SO-251003-880 | MAIN | 15 | 8.32 | -124.82 | 35 | 291.24 | June 18, 2025: 15 @ 8.32 |
| Sept. 19, 2025 | issue | SO-250919-273 | MAIN | 2 | 8.32 | -16.64 | 50 | 416.05 | June 18, 2025: 2 @ 8.32 |
| Sept. 14, 2025 | issue | SO-250914-504 | MAIN | 29 | 8.32 | -241.31 | 52 | 432.69 | June 18, 2025: 29 @ 8.32 |
| Sept. 10, 2025 | issue | SO-250910-189 | MAIN | 20 | 8.32 | -166.42 | 81 | 674.00 | June 18, 2025: 20 @ 8.32 |
| Aug. 16, 2025 | issue | SO-250816-357 | MAIN | 16 | 8.32 | -133.14 | 101 | 840.42 | June 18, 2025: 16 @ 8.32 |
| Aug. 4, 2025 | issue | SO-250804-140 | MAIN | 30 | 8.32 | -249.63 | 117 | 973.56 | June 18, 2025: 30 @ 8.32 |
| July 15, 2025 | issue | SO-250715-849 | MAIN | 38 | 8.34 | -316.90 | 147 | 1,223.19 | June 14, 2025: 5 @ 8.46; June 18, 2025: 33 @ 8.32 |
| July 7, 2025 | issue | SO-250707-596 | MAIN | 16 | 8.46 | -135.38 | 185 | 1,540.09 | Jan. 23, 2025: 6 @ 8.46; June 14, 2025: 10 @ 8.46 |
| June 18, 2025 | receipt | PO-000647 | MAIN | 180 | 8.32 | 1,497.78 | 201 | 1,675.47 | |
| June 17, 2025 | issue | SO-250617-644 | MAIN | 1 | 8.46 | -8.46 | 21 | 177.69 | Jan. 23, 2025: 1 @ 8.46 |
| June 14, 2025 | return | RMA | MAIN | 15 | 8.46 | 126.92 | 22 | 186.15 | |
| June 10, 2025 | issue | SO-250610-531 | MAIN | 3 | 8.46 | -25.38 | 7 | 59.23 | Jan. 23, 2025: 3 @ 8.46 |
| June 9, 2025 | issue | SO-250609-518 | MAIN | 1 | 8.46 | -8.46 | 10 | 84.61 | Jan. 23, 2025: 1 @ 8.46 |
| June 7, 2025 | issue | SO-250607-833 | MAIN | 14 | 8.46 | -118.46 | 11 | 93.07 | Jan. 23, 2025: 14 @ 8.46 |
| June 5, 2025 | issue | SO-250605-197 | MAIN | 2 | 8.46 | -16.92 | 25 | 211.53 | Jan. 23, 2025: 2 @ 8.46 |