Items / CON-0015
PVC Conduit 25mm Plus CON-0015 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)310MAIN 213, EAST 97
Value (FIFO)6,141.56avg 19.81
ClassBX / FCV 0.25
Turnover4.0xlast issue 1 days ago
Days of cover90lead 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 | 104.75 / 30.4375 | 3.441 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 26.18 / 5.517 | 4.746 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(14.0 * 4.746^2 + 3.441^2 * 3.1^2) | 34.1 |
| Reorder point | d * LT + safety stock | 3.441 * 14.0 + 34.1 | 82.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 82.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1256/yr, S = 45.00, h = 20%, price = 18.60 | 840.0 |
| Inventory position | on hand + on order | 310 + 0 | 310 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 19.38 | 171 | 25,006 | yes |
| 840 | 18.60 | 840 | 25,000 | yes (chosen if cheapest) |
| 1,680 | 17.83 | 1,680 | 25,425 | yes |
MOQ 420, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 27, 2026 | 310 / 420 | 19.81 | 6,141.56 |
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-857 | EAST | 20 | 19.81 | -396.23 | 310 | 6,141.56 | Sept. 27, 2026: 20 @ 19.81 |
| Oct. 9, 2026 | issue | SO-261009-267 | MAIN | 71 | 19.81 | -1,406.62 | 330 | 6,537.80 | Sept. 27, 2026: 71 @ 19.81 |
| Oct. 2, 2026 | issue | SO-261002-211 | MAIN | 19 | 19.81 | -376.42 | 401 | 7,944.41 | Sept. 27, 2026: 19 @ 19.81 |
| Sept. 27, 2026 | transfer | TRF | MAIN → EAST | 117 | warehouse transfer, no cost effect | ||||
| Sept. 27, 2026 | receipt | PO-001832 | MAIN | 420 | 19.81 | 8,320.83 | 420 | 8,320.83 | |
| Sept. 22, 2026 | issue | SO-260922-231 | EAST | 9 | 19.50 | -175.46 | 0 | 0.00 | June 5, 2026: 9 @ 19.50 |
| Sept. 19, 2026 | issue | SO-260919-232 | EAST | 27 | 19.50 | -526.38 | 9 | 175.46 | June 5, 2026: 27 @ 19.50 |
| Sept. 14, 2026 | issue | SO-260914-297 | EAST | 36 | 19.50 | -701.84 | 36 | 701.84 | June 5, 2026: 36 @ 19.50 |
| Sept. 14, 2026 | issue | SO-260914-297 | MAIN | 5 | 19.50 | -97.48 | 72 | 1,403.68 | June 5, 2026: 5 @ 19.50 |
| Aug. 29, 2026 | issue | SO-260829-762 | MAIN | 11 | 19.50 | -214.45 | 77 | 1,501.15 | June 5, 2026: 11 @ 19.50 |
| Aug. 28, 2026 | issue | SO-260828-796 | MAIN | 55 | 19.50 | -1,072.25 | 88 | 1,715.60 | June 5, 2026: 55 @ 19.50 |
| Aug. 13, 2026 | issue | SO-260813-771 | MAIN | 43 | 19.50 | -838.31 | 143 | 2,787.86 | June 5, 2026: 43 @ 19.50 |
| Aug. 11, 2026 | issue | SO-260811-251 | MAIN | 10 | 19.50 | -194.96 | 186 | 3,626.16 | June 5, 2026: 10 @ 19.50 |
| Aug. 10, 2026 | issue | SO-260810-249 | MAIN | 4 | 19.50 | -77.98 | 196 | 3,821.12 | June 5, 2026: 4 @ 19.50 |
| Aug. 5, 2026 | issue | SO-260805-363 | MAIN | 37 | 19.50 | -721.33 | 200 | 3,899.10 | June 5, 2026: 37 @ 19.50 |
| July 19, 2026 | issue | SO-260719-775 | MAIN | 33 | 19.50 | -643.35 | 237 | 4,620.43 | June 5, 2026: 33 @ 19.50 |
| July 14, 2026 | issue | SO-260714-346 | MAIN | 53 | 19.50 | -1,033.26 | 270 | 5,263.78 | June 5, 2026: 53 @ 19.50 |
| July 12, 2026 | issue | SO-260712-735 | MAIN | 2 | 19.50 | -38.99 | 323 | 6,297.05 | June 5, 2026: 2 @ 19.50 |
| June 24, 2026 | issue | SO-260624-864 | MAIN | 37 | 19.50 | -721.33 | 325 | 6,336.04 | June 5, 2026: 37 @ 19.50 |
| June 8, 2026 | issue | SO-260608-373 | EAST | 21 | 19.50 | -409.41 | 362 | 7,057.37 | June 5, 2026: 21 @ 19.50 |
| June 5, 2026 | issue | SO-260605-516 | MAIN | 37 | 19.50 | -721.33 | 383 | 7,466.78 | June 5, 2026: 37 @ 19.50 |
| June 5, 2026 | transfer | TRF | MAIN → EAST | 93 | warehouse transfer, no cost effect | ||||
| June 5, 2026 | receipt | PO-001549 | MAIN | 420 | 19.50 | 8,188.11 | 420 | 8,188.11 | |
| June 1, 2026 | issue | SO-260601-457 | EAST | 18 | 18.97 | -341.38 | 0 | 0.00 | May 1, 2026: 18 @ 18.97 |
| May 26, 2026 | issue | SO-260526-394 | EAST | 32 | 18.97 | -606.90 | 18 | 341.38 | Jan. 19, 2026: 30 @ 18.97; March 2, 2026: 1 @ 18.97; May 1, 2026: 1 @ 18.97 |
| May 20, 2026 | issue | SO-260520-911 | EAST | 2 | 18.97 | -37.93 | 50 | 948.28 | Jan. 19, 2026: 2 @ 18.97 |
| May 20, 2026 | issue | SO-260520-911 | MAIN | 25 | 18.97 | -474.14 | 52 | 986.21 | Jan. 19, 2026: 25 @ 18.97 |
| May 14, 2026 | issue | SO-260514-577 | EAST | 9 | 18.97 | -170.69 | 77 | 1,460.34 | Jan. 19, 2026: 9 @ 18.97 |
| May 10, 2026 | issue | SO-260510-396 | MAIN | 31 | 18.97 | -587.93 | 86 | 1,631.03 | Jan. 19, 2026: 31 @ 18.97 |
| May 1, 2026 | return | RMA | MAIN | 19 | 18.97 | 360.34 | 117 | 2,218.96 | |
| April 22, 2026 | issue | SO-260422-218 | EAST | 38 | 18.97 | -720.69 | 98 | 1,858.62 | Jan. 19, 2026: 38 @ 18.97 |
| April 21, 2026 | issue | SO-260421-976 | MAIN | 8 | 18.97 | -151.72 | 136 | 2,579.31 | Jan. 19, 2026: 8 @ 18.97 |
| April 19, 2026 | issue | SO-260419-821 | MAIN | 30 | 18.97 | -568.96 | 144 | 2,731.03 | Jan. 19, 2026: 30 @ 18.97 |
| April 18, 2026 | issue | SO-260418-659 | MAIN | 18 | 18.97 | -341.38 | 174 | 3,300.00 | Jan. 19, 2026: 18 @ 18.97 |
| April 12, 2026 | issue | SO-260412-585 | MAIN | 23 | 18.97 | -436.21 | 192 | 3,641.38 | Jan. 19, 2026: 23 @ 18.97 |
| March 31, 2026 | issue | SO-260331-932 | MAIN | 20 | 18.97 | -379.31 | 215 | 4,077.58 | Jan. 19, 2026: 20 @ 18.97 |
| March 5, 2026 | issue | SO-260305-702 | MAIN | 45 | 18.97 | -853.45 | 235 | 4,456.89 | Jan. 19, 2026: 45 @ 18.97 |
| March 2, 2026 | return | RMA | MAIN | 1 | 18.97 | 18.97 | 280 | 5,310.34 | |
| Feb. 17, 2026 | issue | SO-260217-498 | MAIN | 1 | 18.97 | -18.97 | 279 | 5,291.37 | Jan. 19, 2026: 1 @ 18.97 |
| Feb. 15, 2026 | issue | SO-260215-610 | MAIN | 1 | 18.97 | -18.97 | 280 | 5,310.34 | Jan. 19, 2026: 1 @ 18.97 |
| Feb. 13, 2026 | issue | SO-260213-903 | EAST | 9 | 18.97 | -170.69 | 281 | 5,329.31 | Jan. 19, 2026: 9 @ 18.97 |
| Feb. 7, 2026 | issue | SO-260207-883 | MAIN | 58 | 18.97 | -1,100.00 | 290 | 5,500.00 | Jan. 19, 2026: 58 @ 18.97 |
| Feb. 2, 2026 | issue | SO-260202-312 | MAIN | 67 | 18.97 | -1,270.69 | 348 | 6,599.99 | Jan. 19, 2026: 67 @ 18.97 |
| Jan. 30, 2026 | issue | SO-260130-445 | MAIN | 18 | 19.03 | -342.58 | 415 | 7,870.68 | Sept. 26, 2025: 13 @ 19.06; Jan. 19, 2026: 5 @ 18.97 |
| Jan. 28, 2026 | issue | SO-260128-398 | MAIN | 52 | 19.06 | -991.00 | 433 | 8,213.26 | Sept. 26, 2025: 52 @ 19.06 |
| Jan. 19, 2026 | transfer | TRF | MAIN → EAST | 108 | warehouse transfer, no cost effect | ||||
| Jan. 19, 2026 | receipt | PO-001159 | MAIN | 420 | 18.97 | 7,965.51 | 485 | 9,204.25 | |
| Jan. 18, 2026 | issue | SO-260118-665 | MAIN | 6 | 19.06 | -114.35 | 65 | 1,238.74 | Sept. 26, 2025: 6 @ 19.06 |
| Jan. 17, 2026 | issue | SO-260117-896 | MAIN | 2 | 19.06 | -38.12 | 71 | 1,353.09 | Sept. 26, 2025: 2 @ 19.06 |
| Jan. 7, 2026 | issue | SO-260107-817 | MAIN | 8 | 19.06 | -152.46 | 73 | 1,391.20 | Sept. 26, 2025: 8 @ 19.06 |
| Dec. 30, 2025 | issue | SO-251230-886 | MAIN | 33 | 19.06 | -628.90 | 81 | 1,543.67 | Sept. 26, 2025: 33 @ 19.06 |
| Dec. 30, 2025 | issue | SO-251230-886 | EAST | 14 | 19.06 | -266.81 | 114 | 2,172.57 | Sept. 26, 2025: 14 @ 19.06 |
| Dec. 18, 2025 | issue | SO-251218-178 | EAST | 55 | 19.06 | -1,048.17 | 128 | 2,439.37 | Sept. 26, 2025: 55 @ 19.06 |
| Dec. 13, 2025 | issue | SO-251213-742 | EAST | 9 | 19.06 | -171.52 | 183 | 3,487.54 | Sept. 26, 2025: 9 @ 19.06 |
| Nov. 29, 2025 | issue | SO-251129-185 | EAST | 54 | 19.06 | -1,029.11 | 192 | 3,659.06 | Sept. 26, 2025: 54 @ 19.06 |
| Nov. 15, 2025 | issue | SO-251115-937 | MAIN | 67 | 19.06 | -1,276.86 | 246 | 4,688.17 | Sept. 26, 2025: 67 @ 19.06 |
| Oct. 26, 2025 | issue | SO-251026-285 | MAIN | 7 | 19.06 | -133.40 | 313 | 5,965.03 | Sept. 26, 2025: 7 @ 19.06 |
| Oct. 21, 2025 | issue | SO-251021-502 | MAIN | 6 | 19.06 | -114.35 | 320 | 6,098.43 | Sept. 26, 2025: 6 @ 19.06 |
| Oct. 19, 2025 | issue | SO-251019-423 | MAIN | 1 | 19.06 | -19.06 | 326 | 6,212.78 | Sept. 26, 2025: 1 @ 19.06 |
| Oct. 16, 2025 | issue | SO-251016-498 | MAIN | 1 | 19.06 | -19.06 | 327 | 6,231.84 | Sept. 26, 2025: 1 @ 19.06 |