Items / CON-0004
PVC Conduit 25mm Prime CON-0004 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)75MAIN 75
Value (FIFO)1,913.61avg 25.51
ClassAX / FCV 0.20
Turnover22.5xlast issue 3 days ago
Days of cover20lead time 14d
Reorder suggested: 460 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 | 112.25 / 30.4375 | 3.688 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 22.31 / 5.517 | 4.044 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(14.0 * 4.044^2 + 3.688^2 * 3.1^2) | 39.0 |
| Reorder point | d * LT + safety stock | 3.688 * 14.0 + 39.0 | 90.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 90.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1346/yr, S = 45.00, h = 20%, price = 25.45 | 154.3 |
| Inventory position | on hand + on order | 75 + 0 | 75 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 25.45 | 154 | 35,043 | yes (chosen if cheapest) |
MOQ 460, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 28, 2026 | 75 / 460 | 25.51 | 1,913.61 |
Movement ledger 119 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-595 | MAIN | 71 | 25.51 | -1,811.55 | 75 | 1,913.61 | June 28, 2026: 71 @ 25.51 |
| Oct. 8, 2026 | issue | SO-261008-190 | MAIN | 16 | 25.51 | -408.24 | 146 | 3,725.16 | June 28, 2026: 16 @ 25.51 |
| Oct. 3, 2026 | issue | SO-261003-262 | MAIN | 7 | 25.51 | -178.60 | 162 | 4,133.40 | June 28, 2026: 7 @ 25.51 |
| Sept. 30, 2026 | issue | SO-260930-225 | MAIN | 14 | 25.51 | -357.21 | 169 | 4,312.00 | June 28, 2026: 14 @ 25.51 |
| Sept. 18, 2026 | issue | SO-260918-361 | MAIN | 11 | 25.51 | -280.66 | 183 | 4,669.21 | June 28, 2026: 11 @ 25.51 |
| Sept. 13, 2026 | issue | SO-260913-313 | MAIN | 27 | 25.51 | -688.90 | 194 | 4,949.87 | June 28, 2026: 27 @ 25.51 |
| Sept. 10, 2026 | issue | SO-260910-995 | MAIN | 17 | 25.51 | -433.75 | 221 | 5,638.77 | June 28, 2026: 17 @ 25.51 |
| Sept. 8, 2026 | issue | SO-260908-792 | MAIN | 23 | 25.51 | -586.84 | 238 | 6,072.52 | June 28, 2026: 23 @ 25.51 |
| Aug. 22, 2026 | issue | SO-260822-221 | MAIN | 57 | 25.51 | -1,454.34 | 261 | 6,659.36 | June 28, 2026: 57 @ 25.51 |
| Aug. 19, 2026 | issue | SO-260819-374 | MAIN | 40 | 25.51 | -1,020.59 | 318 | 8,113.71 | June 28, 2026: 40 @ 25.51 |
| Aug. 10, 2026 | issue | SO-260810-974 | MAIN | 10 | 25.51 | -255.15 | 358 | 9,134.30 | June 28, 2026: 10 @ 25.51 |
| July 18, 2026 | issue | SO-260718-442 | MAIN | 25 | 25.51 | -637.87 | 368 | 9,389.45 | June 28, 2026: 25 @ 25.51 |
| July 17, 2026 | issue | SO-260717-587 | MAIN | 37 | 25.51 | -944.05 | 393 | 10,027.32 | June 28, 2026: 37 @ 25.51 |
| July 11, 2026 | issue | SO-260711-538 | MAIN | 2 | 25.51 | -51.03 | 430 | 10,971.36 | June 28, 2026: 2 @ 25.51 |
| July 7, 2026 | issue | SO-260707-514 | MAIN | 16 | 25.51 | -408.24 | 432 | 11,022.39 | June 28, 2026: 16 @ 25.51 |
| July 2, 2026 | issue | SO-260702-153 | MAIN | 12 | 25.51 | -306.18 | 448 | 11,430.63 | June 28, 2026: 12 @ 25.51 |
| June 28, 2026 | receipt | PO-001608 | MAIN | 460 | 25.51 | 11,736.81 | 460 | 11,736.81 | |
| June 26, 2026 | issue | SO-260626-547 | MAIN | 79 | 24.85 | -1,963.12 | 0 | 0.00 | Feb. 27, 2026: 79 @ 24.85 |
| June 17, 2026 | issue | SO-260617-874 | MAIN | 41 | 24.85 | -1,018.83 | 79 | 1,963.12 | Feb. 27, 2026: 41 @ 24.85 |
| May 30, 2026 | issue | SO-260530-981 | MAIN | 21 | 24.85 | -521.84 | 120 | 2,981.95 | Feb. 27, 2026: 21 @ 24.85 |
| May 22, 2026 | issue | SO-260522-104 | MAIN | 53 | 24.85 | -1,317.03 | 141 | 3,503.79 | Feb. 27, 2026: 53 @ 24.85 |
| May 14, 2026 | issue | SO-260514-394 | MAIN | 87 | 24.85 | -2,161.92 | 194 | 4,820.82 | Feb. 27, 2026: 87 @ 24.85 |
| April 29, 2026 | issue | SO-260429-925 | MAIN | 1 | 24.85 | -24.85 | 281 | 6,982.74 | Feb. 27, 2026: 1 @ 24.85 |
| April 23, 2026 | issue | SO-260423-227 | MAIN | 19 | 24.85 | -472.14 | 282 | 7,007.59 | Feb. 27, 2026: 19 @ 24.85 |
| April 12, 2026 | issue | SO-260412-990 | MAIN | 20 | 24.85 | -496.99 | 301 | 7,479.73 | Feb. 27, 2026: 20 @ 24.85 |
| April 10, 2026 | issue | SO-260410-142 | MAIN | 37 | 24.85 | -919.44 | 321 | 7,976.72 | Feb. 27, 2026: 37 @ 24.85 |
| March 15, 2026 | issue | SO-260315-848 | MAIN | 7 | 24.85 | -173.95 | 358 | 8,896.16 | Feb. 27, 2026: 7 @ 24.85 |
| March 14, 2026 | issue | SO-260314-966 | MAIN | 3 | 24.85 | -74.55 | 365 | 9,070.10 | Feb. 27, 2026: 3 @ 24.85 |
| March 11, 2026 | issue | SO-260311-265 | MAIN | 8 | 24.85 | -198.80 | 368 | 9,144.65 | Feb. 27, 2026: 8 @ 24.85 |
| March 9, 2026 | issue | SO-260309-174 | MAIN | 47 | 24.85 | -1,167.93 | 376 | 9,343.45 | Feb. 27, 2026: 47 @ 24.85 |
| March 8, 2026 | issue | SO-260308-984 | MAIN | 51 | 24.58 | -1,253.45 | 423 | 10,511.38 | Nov. 10, 2025: 14 @ 23.86; Feb. 27, 2026: 37 @ 24.85 |
| March 2, 2026 | issue | SO-260302-390 | MAIN | 6 | 23.86 | -143.15 | 474 | 11,764.83 | Oct. 30, 2025: 6 @ 23.86 |
| Feb. 27, 2026 | receipt | PO-001266 | MAIN | 460 | 24.85 | 11,430.82 | 480 | 11,907.98 | |
| Feb. 21, 2026 | issue | SO-260221-567 | MAIN | 32 | 23.86 | -763.47 | 20 | 477.17 | Oct. 30, 2025: 32 @ 23.86 |
| Feb. 16, 2026 | issue | SO-260216-439 | MAIN | 35 | 23.86 | -835.04 | 52 | 1,240.63 | Oct. 30, 2025: 35 @ 23.86 |
| Feb. 11, 2026 | issue | SO-260211-912 | MAIN | 3 | 23.86 | -71.57 | 87 | 2,075.67 | Oct. 30, 2025: 3 @ 23.86 |
| Feb. 2, 2026 | issue | SO-260202-407 | MAIN | 15 | 23.86 | -357.87 | 90 | 2,147.25 | Oct. 30, 2025: 15 @ 23.86 |
| Feb. 1, 2026 | issue | SO-260201-653 | MAIN | 41 | 23.86 | -978.19 | 105 | 2,505.12 | Oct. 30, 2025: 41 @ 23.86 |
| Jan. 30, 2026 | issue | SO-260130-414 | MAIN | 78 | 23.86 | -1,860.95 | 146 | 3,483.31 | Oct. 30, 2025: 78 @ 23.86 |
| Jan. 28, 2026 | issue | SO-260128-361 | MAIN | 17 | 23.86 | -405.59 | 224 | 5,344.26 | Oct. 30, 2025: 17 @ 23.86 |
| Jan. 7, 2026 | issue | SO-260107-374 | MAIN | 5 | 23.86 | -119.29 | 241 | 5,749.85 | Oct. 30, 2025: 5 @ 23.86 |
| Dec. 27, 2025 | issue | SO-251227-579 | MAIN | 9 | 23.86 | -214.72 | 246 | 5,869.14 | Oct. 30, 2025: 9 @ 23.86 |
| Dec. 24, 2025 | issue | SO-251224-929 | MAIN | 24 | 23.86 | -572.60 | 255 | 6,083.87 | Oct. 30, 2025: 24 @ 23.86 |
| Dec. 17, 2025 | issue | SO-251217-588 | MAIN | 2 | 23.86 | -47.72 | 279 | 6,656.47 | Oct. 30, 2025: 2 @ 23.86 |
| Dec. 15, 2025 | issue | SO-251215-952 | MAIN | 42 | 23.86 | -1,002.05 | 281 | 6,704.18 | Oct. 30, 2025: 42 @ 23.86 |
| Dec. 13, 2025 | issue | SO-251213-561 | MAIN | 11 | 23.86 | -262.44 | 323 | 7,706.23 | Oct. 30, 2025: 11 @ 23.86 |
| Dec. 12, 2025 | issue | SO-251212-643 | MAIN | 17 | 23.86 | -405.59 | 334 | 7,968.67 | Oct. 30, 2025: 17 @ 23.86 |
| Dec. 3, 2025 | issue | SO-251203-864 | MAIN | 16 | 23.86 | -381.73 | 351 | 8,374.26 | Oct. 30, 2025: 16 @ 23.86 |
| Nov. 26, 2025 | issue | SO-251126-703 | MAIN | 14 | 23.86 | -334.02 | 367 | 8,756.00 | Oct. 30, 2025: 14 @ 23.86 |
| Nov. 25, 2025 | issue | SO-251125-261 | MAIN | 4 | 23.86 | -95.43 | 381 | 9,090.01 | Oct. 30, 2025: 4 @ 23.86 |
| Nov. 18, 2025 | issue | SO-251118-171 | MAIN | 17 | 23.86 | -405.59 | 385 | 9,185.45 | Oct. 30, 2025: 17 @ 23.86 |
| Nov. 10, 2025 | return | RMA | MAIN | 14 | 23.86 | 334.02 | 402 | 9,591.04 | |
| Nov. 10, 2025 | issue | SO-251110-513 | MAIN | 47 | 23.86 | -1,121.34 | 388 | 9,257.02 | Oct. 30, 2025: 47 @ 23.86 |
| Nov. 8, 2025 | issue | SO-251108-158 | MAIN | 11 | 23.86 | -262.44 | 435 | 10,378.36 | Oct. 30, 2025: 11 @ 23.86 |
| Nov. 5, 2025 | issue | SO-251105-603 | MAIN | 14 | 23.86 | -334.02 | 446 | 10,640.80 | Oct. 30, 2025: 14 @ 23.86 |
| Oct. 30, 2025 | receipt | PO-000964 | MAIN | 460 | 23.86 | 10,974.82 | 460 | 10,974.82 | |
| Oct. 28, 2025 | issue | SO-251028-669 | MAIN | 29 | 24.13 | -699.69 | 0 | 0.00 | June 16, 2025: 24 @ 24.13; Oct. 22, 2025: 5 @ 24.13 |
| Oct. 22, 2025 | return | RMA | MAIN | 5 | 24.13 | 120.64 | 29 | 699.69 | |
| Oct. 21, 2025 | issue | SO-251021-837 | MAIN | 17 | 24.13 | -410.16 | 24 | 579.05 | June 16, 2025: 17 @ 24.13 |
| Oct. 17, 2025 | issue | SO-251017-863 | MAIN | 7 | 24.13 | -168.89 | 41 | 989.21 | June 16, 2025: 7 @ 24.13 |