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
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 | 75.08 / 30.4375 | 2.467 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 18.51 / 5.517 | 3.356 |
| 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 * 3.356^2 + 2.467^2 * 3.1^2) | 30.2 |
| Reorder point | d * LT + safety stock | 2.467 * 14.0 + 30.2 | 64.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 64.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 900/yr, S = 45.00, h = 20%, price = 45.34 | 94.5 |
| Inventory position | on hand + on order | 243 + 0 | 243 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 45.34 | 95 | 41,681 | yes (chosen if cheapest) |
MOQ 300, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 20, 2026 | 243 / 300 | 44.96 | 10,926.32 |
Movement ledger 120 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-469 | EAST | 5 | 44.96 | -224.82 | 243 | 10,926.32 | Sept. 20, 2026: 5 @ 44.96 |
| Oct. 10, 2026 | issue | SO-261010-183 | MAIN | 41 | 44.96 | -1,843.54 | 248 | 11,151.15 | Sept. 20, 2026: 41 @ 44.96 |
| Oct. 4, 2026 | issue | SO-261004-379 | EAST | 8 | 44.96 | -359.71 | 289 | 12,994.68 | Sept. 20, 2026: 8 @ 44.96 |
| Oct. 3, 2026 | issue | SO-261003-144 | MAIN | 3 | 44.96 | -134.89 | 297 | 13,354.40 | Sept. 20, 2026: 3 @ 44.96 |
| Sept. 20, 2026 | transfer | TRF | MAIN → EAST | 75 | warehouse transfer, no cost effect | ||||
| Sept. 20, 2026 | receipt | PO-001813 | MAIN | 300 | 44.96 | 13,489.29 | 300 | 13,489.29 | |
| Sept. 14, 2026 | issue | SO-260914-440 | MAIN | 12 | 44.84 | -538.02 | 0 | 0.00 | May 30, 2026: 12 @ 44.84 |
| Sept. 10, 2026 | issue | SO-260910-657 | MAIN | 58 | 44.84 | -2,600.44 | 12 | 538.02 | May 30, 2026: 58 @ 44.84 |
| Aug. 24, 2026 | issue | SO-260824-450 | MAIN | 21 | 44.84 | -941.54 | 70 | 3,138.46 | May 30, 2026: 21 @ 44.84 |
| Aug. 16, 2026 | issue | SO-260816-289 | MAIN | 6 | 44.84 | -269.01 | 91 | 4,080.00 | May 30, 2026: 6 @ 44.84 |
| Aug. 12, 2026 | issue | SO-260812-212 | MAIN | 8 | 44.84 | -358.68 | 97 | 4,349.01 | May 30, 2026: 8 @ 44.84 |
| Aug. 6, 2026 | issue | SO-260806-520 | MAIN | 22 | 44.84 | -986.37 | 105 | 4,707.70 | May 30, 2026: 22 @ 44.84 |
| Aug. 2, 2026 | issue | SO-260802-825 | MAIN | 7 | 44.84 | -313.85 | 127 | 5,694.07 | May 30, 2026: 7 @ 44.84 |
| July 30, 2026 | issue | SO-260730-344 | MAIN | 49 | 44.84 | -2,196.92 | 134 | 6,007.92 | May 30, 2026: 49 @ 44.84 |
| July 27, 2026 | issue | SO-260727-566 | MAIN | 54 | 44.84 | -2,421.10 | 183 | 8,204.84 | May 30, 2026: 54 @ 44.84 |
| June 27, 2026 | issue | SO-260627-699 | MAIN | 4 | 44.84 | -179.34 | 237 | 10,625.94 | May 30, 2026: 4 @ 44.84 |
| June 20, 2026 | issue | SO-260620-640 | MAIN | 6 | 44.84 | -269.01 | 241 | 10,805.28 | May 30, 2026: 6 @ 44.84 |
| June 19, 2026 | issue | SO-260619-595 | MAIN | 6 | 44.84 | -269.01 | 247 | 11,074.29 | May 30, 2026: 6 @ 44.84 |
| June 12, 2026 | issue | SO-260612-999 | MAIN | 5 | 44.84 | -224.18 | 253 | 11,343.31 | May 30, 2026: 5 @ 44.84 |
| June 3, 2026 | issue | SO-260603-288 | MAIN | 3 | 44.84 | -134.51 | 258 | 11,567.48 | May 30, 2026: 3 @ 44.84 |
| June 1, 2026 | issue | SO-260601-292 | MAIN | 39 | 44.84 | -1,748.57 | 261 | 11,701.99 | May 30, 2026: 39 @ 44.84 |
| May 30, 2026 | receipt | PO-001534 | MAIN | 300 | 44.84 | 13,450.56 | 300 | 13,450.56 | |
| May 19, 2026 | issue | SO-260519-749 | EAST | 50 | 43.35 | -2,167.73 | 0 | 0.00 | Dec. 25, 2025: 29 @ 43.15; Jan. 19, 2026: 21 @ 43.64 |
| May 17, 2026 | issue | SO-260517-942 | EAST | 5 | 43.15 | -215.73 | 50 | 2,167.73 | Dec. 25, 2025: 5 @ 43.15 |
| April 11, 2026 | issue | SO-260411-174 | EAST | 13 | 43.15 | -560.89 | 55 | 2,383.45 | Dec. 25, 2025: 13 @ 43.15 |
| April 10, 2026 | issue | SO-260410-368 | EAST | 1 | 43.15 | -43.15 | 68 | 2,944.34 | Dec. 25, 2025: 1 @ 43.15 |
| April 9, 2026 | issue | SO-260409-657 | EAST | 7 | 43.15 | -302.02 | 69 | 2,987.49 | Dec. 25, 2025: 7 @ 43.15 |
| April 5, 2026 | issue | SO-260405-294 | EAST | 1 | 43.15 | -43.15 | 76 | 3,289.51 | Dec. 25, 2025: 1 @ 43.15 |
| April 1, 2026 | issue | SO-260401-515 | EAST | 3 | 43.15 | -129.44 | 77 | 3,332.65 | Dec. 25, 2025: 3 @ 43.15 |
| April 1, 2026 | issue | SO-260401-515 | MAIN | 59 | 43.15 | -2,545.58 | 80 | 3,462.09 | Dec. 25, 2025: 59 @ 43.15 |
| March 26, 2026 | issue | SO-260326-135 | MAIN | 18 | 43.15 | -776.62 | 139 | 6,007.67 | Dec. 25, 2025: 18 @ 43.15 |
| March 22, 2026 | issue | SO-260322-926 | EAST | 9 | 43.15 | -388.31 | 157 | 6,784.28 | Dec. 25, 2025: 9 @ 43.15 |
| March 17, 2026 | issue | SO-260317-682 | MAIN | 8 | 43.15 | -345.16 | 166 | 7,172.59 | Dec. 25, 2025: 8 @ 43.15 |
| March 16, 2026 | issue | SO-260316-984 | MAIN | 10 | 43.15 | -431.45 | 174 | 7,517.76 | Dec. 25, 2025: 10 @ 43.15 |
| March 10, 2026 | issue | SO-260310-949 | MAIN | 17 | 43.15 | -733.47 | 184 | 7,949.21 | Dec. 25, 2025: 17 @ 43.15 |
| March 9, 2026 | issue | SO-260309-596 | EAST | 12 | 43.15 | -517.74 | 201 | 8,682.68 | Dec. 25, 2025: 12 @ 43.15 |
| March 2, 2026 | issue | SO-260302-796 | MAIN | 8 | 43.15 | -345.16 | 213 | 9,200.43 | Dec. 25, 2025: 8 @ 43.15 |
| Feb. 27, 2026 | issue | SO-260227-680 | MAIN | 23 | 43.15 | -992.34 | 221 | 9,545.59 | Dec. 25, 2025: 23 @ 43.15 |
| Feb. 20, 2026 | issue | SO-260220-307 | MAIN | 34 | 43.15 | -1,466.94 | 244 | 10,537.93 | Dec. 25, 2025: 34 @ 43.15 |
| Feb. 18, 2026 | issue | SO-260218-478 | MAIN | 13 | 43.15 | -560.89 | 278 | 12,004.88 | Dec. 25, 2025: 13 @ 43.15 |
| Feb. 17, 2026 | issue | SO-260217-743 | MAIN | 10 | 43.15 | -431.45 | 291 | 12,565.77 | Dec. 25, 2025: 10 @ 43.15 |
| Feb. 9, 2026 | issue | SO-260209-101 | MAIN | 8 | 43.15 | -345.16 | 301 | 12,997.22 | Dec. 25, 2025: 8 @ 43.15 |
| Jan. 19, 2026 | return | RMA | MAIN | 21 | 43.64 | 916.51 | 309 | 13,342.39 | |
| Jan. 7, 2026 | issue | SO-260107-628 | MAIN | 42 | 43.64 | -1,833.02 | 288 | 12,425.88 | Sept. 21, 2025: 30 @ 43.84; Dec. 25, 2025: 12 @ 43.15 |
| Jan. 1, 2026 | issue | SO-260101-169 | MAIN | 13 | 43.84 | -569.95 | 330 | 14,258.90 | Sept. 21, 2025: 13 @ 43.84 |
| Dec. 25, 2025 | transfer | TRF | MAIN → EAST | 101 | warehouse transfer, no cost effect | ||||
| Dec. 25, 2025 | receipt | PO-001087 | MAIN | 300 | 43.15 | 12,943.62 | 343 | 14,828.85 | |
| Dec. 12, 2025 | issue | SO-251212-789 | MAIN | 1 | 43.84 | -43.84 | 43 | 1,885.23 | Sept. 21, 2025: 1 @ 43.84 |
| Dec. 11, 2025 | issue | SO-251211-631 | MAIN | 39 | 43.84 | -1,709.86 | 44 | 1,929.07 | Sept. 21, 2025: 39 @ 43.84 |
| Dec. 7, 2025 | issue | SO-251207-951 | MAIN | 2 | 43.84 | -87.68 | 83 | 3,638.93 | Sept. 21, 2025: 2 @ 43.84 |
| Dec. 5, 2025 | issue | SO-251205-151 | MAIN | 43 | 43.84 | -1,885.23 | 85 | 3,726.61 | Sept. 21, 2025: 43 @ 43.84 |
| Dec. 1, 2025 | issue | SO-251201-330 | MAIN | 7 | 43.84 | -306.90 | 128 | 5,611.84 | Sept. 21, 2025: 7 @ 43.84 |
| Nov. 26, 2025 | issue | SO-251126-765 | MAIN | 65 | 43.84 | -2,849.76 | 135 | 5,918.74 | Sept. 21, 2025: 65 @ 43.84 |
| Nov. 15, 2025 | issue | SO-251115-620 | MAIN | 13 | 43.84 | -569.95 | 200 | 8,768.50 | Sept. 21, 2025: 13 @ 43.84 |
| Nov. 14, 2025 | issue | SO-251114-650 | MAIN | 16 | 43.84 | -701.48 | 213 | 9,338.45 | Sept. 21, 2025: 16 @ 43.84 |
| Oct. 29, 2025 | issue | SO-251029-301 | MAIN | 8 | 43.84 | -350.74 | 229 | 10,039.93 | Sept. 21, 2025: 8 @ 43.84 |
| Oct. 22, 2025 | issue | SO-251022-137 | MAIN | 1 | 43.84 | -43.84 | 237 | 10,390.67 | Sept. 21, 2025: 1 @ 43.84 |
| Oct. 13, 2025 | issue | SO-251013-968 | MAIN | 59 | 43.84 | -2,586.71 | 238 | 10,434.52 | Sept. 21, 2025: 59 @ 43.84 |
| Oct. 2, 2025 | issue | SO-251002-875 | MAIN | 4 | 43.49 | -173.96 | 297 | 13,021.22 | Sept. 11, 2025: 1 @ 42.43; Sept. 21, 2025: 3 @ 43.84 |
| Sept. 30, 2025 | issue | SO-250930-302 | MAIN | 28 | 42.43 | -1,188.12 | 301 | 13,195.18 | May 24, 2025: 20 @ 42.43; Aug. 28, 2025: 3 @ 42.43; Sept. 11, 2025: 5 @ 42.43 |