Items / CON-0021
PVC Conduit 25mm Lite CON-0021 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)133MAIN 66, EAST 67
Value (FIFO)1,566.78avg 11.78
ClassCX / FCV 0.13
Turnover5.3xlast issue 1 days ago
Days of cover84lead 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 | 48.08 / 30.4375 | 1.580 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.06 / 5.517 | 1.099 |
| 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.099^2 + 1.580^2 * 3.1^2) | 8.2 |
| Reorder point | d * LT + safety stock | 1.580 * 14.0 + 8.2 | 30.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 30.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 577/yr, S = 45.00, h = 20%, price = 11.69 | 149.0 |
| Inventory position | on hand + on order | 133 + 0 | 133 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.69 | 149 | 7,089 | yes (chosen if cheapest) |
MOQ 220, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 29, 2026 | 133 / 220 | 11.78 | 1,566.78 |
Movement ledger 125 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-139 | EAST | 8 | 11.78 | -94.24 | 133 | 1,566.78 | Aug. 29, 2026: 8 @ 11.78 |
| Oct. 14, 2026 | issue | SO-261014-265 | MAIN | 5 | 11.78 | -58.90 | 141 | 1,661.02 | Aug. 29, 2026: 5 @ 11.78 |
| Oct. 11, 2026 | issue | SO-261011-602 | MAIN | 10 | 11.78 | -117.80 | 146 | 1,719.92 | Aug. 29, 2026: 10 @ 11.78 |
| Oct. 7, 2026 | issue | SO-261007-438 | MAIN | 23 | 11.78 | -270.95 | 156 | 1,837.73 | Aug. 29, 2026: 23 @ 11.78 |
| Oct. 3, 2026 | issue | SO-261003-419 | MAIN | 10 | 11.78 | -117.80 | 179 | 2,108.67 | Aug. 29, 2026: 10 @ 11.78 |
| Sept. 13, 2026 | issue | SO-260913-868 | MAIN | 45 | 11.59 | -521.71 | 189 | 2,226.48 | April 18, 2026: 14 @ 11.18; Aug. 29, 2026: 31 @ 11.78 |
| Sept. 2, 2026 | issue | SO-260902-791 | MAIN | 5 | 11.18 | -55.90 | 234 | 2,748.18 | April 18, 2026: 5 @ 11.18 |
| Aug. 31, 2026 | issue | SO-260831-975 | MAIN | 8 | 11.18 | -89.44 | 239 | 2,804.08 | April 18, 2026: 8 @ 11.18 |
| Aug. 30, 2026 | issue | SO-260830-569 | MAIN | 2 | 11.18 | -22.36 | 247 | 2,893.52 | April 18, 2026: 2 @ 11.18 |
| Aug. 29, 2026 | transfer | TRF | MAIN → EAST | 59 | warehouse transfer, no cost effect | ||||
| Aug. 29, 2026 | receipt | PO-001757 | MAIN | 220 | 11.78 | 2,591.67 | 249 | 2,915.88 | |
| Aug. 27, 2026 | issue | SO-260827-683 | EAST | 9 | 11.18 | -100.62 | 29 | 324.21 | April 18, 2026: 9 @ 11.18 |
| Aug. 18, 2026 | issue | SO-260818-189 | EAST | 3 | 11.18 | -33.54 | 38 | 424.83 | April 18, 2026: 3 @ 11.18 |
| Aug. 13, 2026 | issue | SO-260813-405 | MAIN | 17 | 11.18 | -190.06 | 41 | 458.37 | April 18, 2026: 17 @ 11.18 |
| July 28, 2026 | issue | SO-260728-608 | MAIN | 7 | 11.18 | -78.26 | 58 | 648.43 | April 18, 2026: 7 @ 11.18 |
| July 22, 2026 | issue | SO-260722-662 | MAIN | 12 | 11.18 | -134.16 | 65 | 726.69 | April 18, 2026: 12 @ 11.18 |
| July 16, 2026 | issue | SO-260716-520 | MAIN | 27 | 11.18 | -301.85 | 77 | 860.84 | April 18, 2026: 27 @ 11.18 |
| June 29, 2026 | issue | SO-260629-395 | MAIN | 27 | 11.18 | -301.85 | 104 | 1,162.70 | April 18, 2026: 27 @ 11.18 |
| June 28, 2026 | issue | SO-260628-737 | EAST | 9 | 11.18 | -100.62 | 131 | 1,464.55 | April 18, 2026: 9 @ 11.18 |
| June 6, 2026 | issue | SO-260606-708 | MAIN | 1 | 11.18 | -11.18 | 140 | 1,565.17 | April 18, 2026: 1 @ 11.18 |
| June 5, 2026 | issue | SO-260605-106 | MAIN | 23 | 11.18 | -257.14 | 141 | 1,576.35 | April 18, 2026: 23 @ 11.18 |
| May 30, 2026 | issue | SO-260530-664 | EAST | 15 | 11.18 | -167.70 | 164 | 1,833.49 | April 18, 2026: 15 @ 11.18 |
| May 26, 2026 | issue | SO-260526-648 | MAIN | 11 | 11.18 | -122.98 | 179 | 2,001.18 | April 18, 2026: 11 @ 11.18 |
| May 25, 2026 | issue | SO-260525-150 | MAIN | 7 | 11.18 | -78.26 | 190 | 2,124.16 | April 18, 2026: 7 @ 11.18 |
| May 15, 2026 | issue | SO-260515-441 | MAIN | 10 | 11.18 | -111.80 | 197 | 2,202.42 | April 18, 2026: 10 @ 11.18 |
| May 7, 2026 | issue | SO-260507-404 | MAIN | 12 | 11.18 | -134.16 | 207 | 2,314.22 | April 18, 2026: 12 @ 11.18 |
| May 2, 2026 | issue | SO-260502-883 | MAIN | 2 | 11.26 | -22.53 | 219 | 2,448.38 | Nov. 12, 2025: 1 @ 11.35; April 18, 2026: 1 @ 11.18 |
| April 30, 2026 | issue | SO-260430-969 | EAST | 7 | 11.35 | -79.42 | 221 | 2,470.90 | Nov. 12, 2025: 7 @ 11.35 |
| April 25, 2026 | issue | SO-260425-707 | MAIN | 2 | 11.35 | -22.69 | 228 | 2,550.32 | Nov. 12, 2025: 2 @ 11.35 |
| April 20, 2026 | issue | SO-260420-452 | MAIN | 8 | 11.35 | -90.76 | 230 | 2,573.01 | Nov. 12, 2025: 8 @ 11.35 |
| April 18, 2026 | issue | SO-260418-545 | MAIN | 13 | 11.35 | -147.49 | 238 | 2,663.77 | Nov. 12, 2025: 13 @ 11.35 |
| April 18, 2026 | transfer | TRF | MAIN → EAST | 59 | warehouse transfer, no cost effect | ||||
| April 18, 2026 | receipt | PO-001418 | MAIN | 220 | 11.18 | 2,459.56 | 251 | 2,811.26 | |
| April 9, 2026 | issue | SO-260409-762 | MAIN | 2 | 11.35 | -22.69 | 31 | 351.71 | Nov. 12, 2025: 2 @ 11.35 |
| April 1, 2026 | issue | SO-260401-320 | MAIN | 10 | 11.35 | -113.45 | 33 | 374.40 | Nov. 12, 2025: 10 @ 11.35 |
| March 30, 2026 | issue | SO-260330-928 | MAIN | 13 | 11.35 | -147.49 | 43 | 487.85 | Nov. 12, 2025: 13 @ 11.35 |
| March 29, 2026 | issue | SO-260329-689 | MAIN | 10 | 11.35 | -113.45 | 56 | 635.34 | Nov. 12, 2025: 10 @ 11.35 |
| March 18, 2026 | issue | SO-260318-220 | MAIN | 7 | 11.35 | -79.42 | 66 | 748.80 | Nov. 12, 2025: 7 @ 11.35 |
| March 17, 2026 | issue | SO-260317-601 | MAIN | 12 | 11.35 | -136.14 | 73 | 828.21 | Nov. 12, 2025: 12 @ 11.35 |
| March 5, 2026 | issue | SO-260305-320 | MAIN | 2 | 11.35 | -22.69 | 85 | 964.36 | Nov. 12, 2025: 2 @ 11.35 |
| Feb. 27, 2026 | issue | SO-260227-603 | MAIN | 12 | 11.35 | -136.14 | 87 | 987.05 | Nov. 12, 2025: 12 @ 11.35 |
| Feb. 24, 2026 | issue | SO-260224-633 | MAIN | 25 | 11.35 | -283.64 | 99 | 1,123.19 | Nov. 12, 2025: 25 @ 11.35 |
| Feb. 18, 2026 | issue | SO-260218-957 | MAIN | 11 | 11.35 | -124.80 | 124 | 1,406.83 | Nov. 12, 2025: 11 @ 11.35 |
| Feb. 13, 2026 | issue | SO-260213-841 | MAIN | 1 | 11.35 | -11.35 | 135 | 1,531.63 | Nov. 12, 2025: 1 @ 11.35 |
| Feb. 10, 2026 | issue | SO-260210-435 | MAIN | 5 | 11.35 | -56.73 | 136 | 1,542.97 | Nov. 12, 2025: 5 @ 11.35 |
| Jan. 15, 2026 | adjustment | Cycle count | MAIN | -1 | 11.35 | -11.35 | 141 | 1,599.70 | Nov. 12, 2025: 1 @ 11.35 |
| Jan. 10, 2026 | issue | SO-260110-309 | MAIN | 24 | 11.35 | -272.29 | 142 | 1,611.05 | Nov. 12, 2025: 24 @ 11.35 |
| Jan. 5, 2026 | issue | SO-260105-491 | MAIN | 18 | 11.35 | -204.22 | 166 | 1,883.34 | Nov. 12, 2025: 18 @ 11.35 |
| Dec. 24, 2025 | issue | SO-251224-468 | MAIN | 7 | 11.35 | -79.42 | 184 | 2,087.55 | Nov. 12, 2025: 7 @ 11.35 |
| Dec. 17, 2025 | issue | SO-251217-761 | MAIN | 23 | 11.35 | -260.94 | 191 | 2,166.97 | Nov. 12, 2025: 23 @ 11.35 |
| Dec. 14, 2025 | issue | SO-251214-931 | MAIN | 3 | 11.35 | -34.04 | 214 | 2,427.92 | Nov. 12, 2025: 3 @ 11.35 |
| Dec. 12, 2025 | issue | SO-251212-606 | MAIN | 14 | 11.37 | -159.24 | 217 | 2,461.95 | July 16, 2025: 11 @ 11.38; Nov. 12, 2025: 3 @ 11.35 |
| Nov. 19, 2025 | issue | SO-251119-264 | MAIN | 1 | 11.38 | -11.38 | 231 | 2,621.19 | July 16, 2025: 1 @ 11.38 |
| Nov. 17, 2025 | issue | SO-251117-455 | MAIN | 14 | 11.38 | -159.35 | 232 | 2,632.58 | July 16, 2025: 14 @ 11.38 |
| Nov. 15, 2025 | issue | SO-251115-507 | MAIN | 2 | 11.38 | -22.76 | 246 | 2,791.93 | July 16, 2025: 2 @ 11.38 |
| Nov. 14, 2025 | issue | SO-251114-685 | MAIN | 5 | 11.38 | -56.91 | 248 | 2,814.70 | July 16, 2025: 5 @ 11.38 |
| Nov. 12, 2025 | receipt | PO-000996 | MAIN | 220 | 11.35 | 2,495.99 | 253 | 2,871.61 | |
| Nov. 7, 2025 | issue | SO-251107-270 | MAIN | 4 | 11.38 | -45.53 | 33 | 375.62 | July 16, 2025: 4 @ 11.38 |
| Nov. 1, 2025 | issue | SO-251101-683 | MAIN | 21 | 11.38 | -239.03 | 37 | 421.15 | July 16, 2025: 21 @ 11.38 |
| Oct. 21, 2025 | issue | SO-251021-144 | MAIN | 12 | 11.38 | -136.59 | 58 | 660.18 | July 16, 2025: 12 @ 11.38 |