Items / CON-0018
Bend 20mm Nova CON-0018 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)394MAIN 394
Value (FIFO)1,628.60avg 4.13
ClassCX / FCV 0.26
Turnover3.4xlast issue 3 days ago
Days of cover114lead 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 | 105.42 / 30.4375 | 3.463 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 27.88 / 5.517 | 5.054 |
| 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 * 5.054^2 + 3.463^2 * 3.1^2) | 27.9 |
| Reorder point | d * LT + safety stock | 3.463 * 14.0 + 27.9 | 76.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 76.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1264/yr, S = 45.00, h = 20%, price = 3.95 | 880.0 |
| Inventory position | on hand + on order | 394 + 0 | 394 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 4.11 | 372 | 5,501 | yes |
| 880 | 3.95 | 880 | 5,400 | yes (chosen if cheapest) |
| 1,760 | 3.78 | 1,760 | 5,478 | yes |
MOQ 440, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 5, 2026 | 394 / 440 | 4.13 | 1,628.60 |
Movement ledger 114 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-103 | MAIN | 39 | 4.13 | -161.21 | 394 | 1,628.60 | Oct. 5, 2026: 39 @ 4.13 |
| Oct. 10, 2026 | issue | SO-261010-889 | MAIN | 7 | 4.13 | -28.93 | 433 | 1,789.81 | Oct. 5, 2026: 7 @ 4.13 |
| Oct. 5, 2026 | receipt | PO-001851 | MAIN | 440 | 4.13 | 1,818.74 | 440 | 1,818.74 | |
| Oct. 4, 2026 | issue | SO-261004-333 | EAST | 33 | 4.11 | -135.74 | 0 | 0.00 | June 2, 2026: 20 @ 4.11; Sept. 15, 2026: 13 @ 4.11 |
| Oct. 3, 2026 | issue | SO-261003-534 | EAST | 16 | 4.11 | -65.81 | 33 | 135.74 | June 2, 2026: 16 @ 4.11 |
| Oct. 2, 2026 | issue | SO-261002-804 | EAST | 7 | 4.11 | -28.79 | 49 | 201.55 | June 2, 2026: 7 @ 4.11 |
| Oct. 1, 2026 | issue | SO-261001-862 | EAST | 8 | 4.11 | -32.91 | 56 | 230.34 | June 2, 2026: 8 @ 4.11 |
| Sept. 29, 2026 | issue | SO-260929-556 | EAST | 6 | 4.11 | -24.68 | 64 | 263.24 | June 2, 2026: 6 @ 4.11 |
| Sept. 27, 2026 | issue | SO-260927-315 | EAST | 4 | 4.11 | -16.45 | 70 | 287.92 | June 2, 2026: 4 @ 4.11 |
| Sept. 27, 2026 | issue | SO-260927-315 | MAIN | 12 | 4.11 | -49.36 | 74 | 304.38 | June 2, 2026: 12 @ 4.11 |
| Sept. 20, 2026 | issue | SO-260920-352 | MAIN | 57 | 4.11 | -234.45 | 86 | 353.74 | June 2, 2026: 57 @ 4.11 |
| Sept. 15, 2026 | return | RMA | MAIN | 13 | 4.11 | 53.47 | 143 | 588.19 | |
| Sept. 7, 2026 | issue | SO-260907-729 | MAIN | 26 | 4.11 | -106.94 | 130 | 534.72 | June 2, 2026: 26 @ 4.11 |
| Sept. 1, 2026 | issue | SO-260901-236 | MAIN | 19 | 4.11 | -78.15 | 156 | 641.66 | June 2, 2026: 19 @ 4.11 |
| Aug. 31, 2026 | issue | SO-260831-438 | EAST | 32 | 4.11 | -131.62 | 175 | 719.81 | June 2, 2026: 32 @ 4.11 |
| Aug. 28, 2026 | issue | SO-260828-143 | MAIN | 34 | 4.11 | -139.85 | 207 | 851.43 | June 2, 2026: 34 @ 4.11 |
| Aug. 25, 2026 | issue | SO-260825-754 | MAIN | 2 | 4.11 | -8.23 | 241 | 991.28 | June 2, 2026: 2 @ 4.11 |
| Aug. 9, 2026 | issue | SO-260809-639 | EAST | 23 | 4.11 | -94.60 | 243 | 999.51 | June 2, 2026: 23 @ 4.11 |
| July 26, 2026 | issue | SO-260726-702 | MAIN | 9 | 4.11 | -37.02 | 266 | 1,094.11 | June 2, 2026: 9 @ 4.11 |
| July 11, 2026 | issue | SO-260711-662 | EAST | 9 | 4.11 | -37.02 | 275 | 1,131.13 | June 2, 2026: 9 @ 4.11 |
| July 4, 2026 | issue | SO-260704-112 | MAIN | 16 | 4.11 | -65.81 | 284 | 1,168.15 | June 2, 2026: 16 @ 4.11 |
| July 3, 2026 | issue | SO-260703-839 | MAIN | 40 | 4.11 | -164.53 | 300 | 1,233.96 | June 2, 2026: 40 @ 4.11 |
| July 1, 2026 | issue | SO-260701-791 | MAIN | 9 | 4.11 | -37.02 | 340 | 1,398.49 | June 2, 2026: 9 @ 4.11 |
| June 28, 2026 | issue | SO-260628-988 | MAIN | 35 | 4.11 | -143.96 | 349 | 1,435.51 | June 2, 2026: 35 @ 4.11 |
| June 20, 2026 | issue | SO-260620-162 | MAIN | 1 | 4.11 | -4.11 | 384 | 1,579.47 | June 2, 2026: 1 @ 4.11 |
| June 16, 2026 | issue | SO-260616-912 | MAIN | 87 | 4.04 | -351.79 | 385 | 1,583.58 | Dec. 24, 2025: 32 @ 3.92; June 2, 2026: 55 @ 4.11 |
| June 5, 2026 | issue | SO-260605-243 | EAST | 6 | 3.92 | -23.54 | 472 | 1,935.38 | Dec. 24, 2025: 6 @ 3.92 |
| June 2, 2026 | transfer | TRF | MAIN → EAST | 144 | warehouse transfer, no cost effect | ||||
| June 2, 2026 | receipt | PO-001543 | MAIN | 440 | 4.11 | 1,809.81 | 478 | 1,958.92 | |
| May 28, 2026 | issue | SO-260528-586 | MAIN | 30 | 3.92 | -117.72 | 38 | 149.11 | Dec. 24, 2025: 30 @ 3.92 |
| May 26, 2026 | issue | SO-260526-701 | MAIN | 2 | 3.92 | -7.85 | 68 | 266.83 | Dec. 24, 2025: 2 @ 3.92 |
| May 21, 2026 | issue | SO-260521-858 | MAIN | 5 | 3.92 | -19.62 | 70 | 274.68 | Dec. 24, 2025: 5 @ 3.92 |
| May 18, 2026 | issue | SO-260518-645 | MAIN | 6 | 3.92 | -23.54 | 75 | 294.30 | Dec. 24, 2025: 6 @ 3.92 |
| May 15, 2026 | issue | SO-260515-652 | MAIN | 1 | 3.92 | -3.92 | 81 | 317.84 | Dec. 24, 2025: 1 @ 3.92 |
| May 9, 2026 | issue | SO-260509-134 | MAIN | 5 | 3.92 | -19.62 | 82 | 321.77 | Dec. 24, 2025: 5 @ 3.92 |
| May 7, 2026 | issue | SO-260507-641 | MAIN | 6 | 3.92 | -23.54 | 87 | 341.39 | Dec. 24, 2025: 6 @ 3.92 |
| April 29, 2026 | issue | SO-260429-109 | MAIN | 13 | 3.92 | -51.01 | 93 | 364.93 | Dec. 24, 2025: 13 @ 3.92 |
| April 20, 2026 | issue | SO-260420-453 | MAIN | 119 | 3.92 | -466.96 | 106 | 415.94 | Dec. 24, 2025: 119 @ 3.92 |
| March 26, 2026 | issue | SO-260326-469 | MAIN | 108 | 3.92 | -423.79 | 225 | 882.90 | Dec. 24, 2025: 108 @ 3.92 |
| March 2, 2026 | issue | SO-260302-934 | MAIN | 1 | 3.92 | -3.92 | 333 | 1,306.69 | Dec. 24, 2025: 1 @ 3.92 |
| Feb. 27, 2026 | issue | SO-260227-102 | MAIN | 31 | 3.92 | -121.64 | 334 | 1,310.62 | Dec. 24, 2025: 31 @ 3.92 |
| Feb. 21, 2026 | issue | SO-260221-243 | MAIN | 5 | 3.92 | -19.62 | 365 | 1,432.26 | Dec. 24, 2025: 5 @ 3.92 |
| Feb. 14, 2026 | issue | SO-260214-691 | MAIN | 35 | 3.92 | -137.34 | 370 | 1,451.88 | Dec. 24, 2025: 35 @ 3.92 |
| Feb. 9, 2026 | issue | SO-260209-363 | MAIN | 1 | 3.92 | -3.92 | 405 | 1,589.22 | Dec. 24, 2025: 1 @ 3.92 |
| Feb. 8, 2026 | issue | SO-260208-937 | MAIN | 3 | 3.92 | -11.77 | 406 | 1,593.14 | Dec. 24, 2025: 3 @ 3.92 |
| Jan. 14, 2026 | issue | SO-260114-709 | MAIN | 10 | 3.92 | -39.24 | 409 | 1,604.92 | Dec. 24, 2025: 10 @ 3.92 |
| Jan. 11, 2026 | issue | SO-260111-978 | MAIN | 55 | 3.98 | -218.79 | 419 | 1,644.16 | Sept. 18, 2025: 21 @ 4.01; Nov. 20, 2025: 13 @ 4.01; Dec. 24, 2025: 21 @ 3.92 |
| Jan. 7, 2026 | issue | SO-260107-194 | MAIN | 23 | 4.01 | -92.26 | 474 | 1,862.94 | Sept. 18, 2025: 23 @ 4.01 |
| Dec. 24, 2025 | receipt | PO-001081 | MAIN | 440 | 3.92 | 1,726.56 | 497 | 1,955.20 | |
| Dec. 16, 2025 | issue | SO-251216-646 | MAIN | 116 | 4.01 | -465.31 | 57 | 228.64 | Sept. 18, 2025: 116 @ 4.01 |
| Dec. 13, 2025 | issue | SO-251213-593 | MAIN | 36 | 4.01 | -144.41 | 173 | 693.95 | Sept. 18, 2025: 36 @ 4.01 |
| Dec. 12, 2025 | issue | SO-251212-783 | MAIN | 8 | 4.01 | -32.09 | 209 | 838.36 | Sept. 18, 2025: 8 @ 4.01 |
| Nov. 29, 2025 | issue | SO-251129-106 | MAIN | 13 | 4.01 | -52.15 | 217 | 870.45 | Sept. 18, 2025: 13 @ 4.01 |
| Nov. 20, 2025 | return | RMA | MAIN | 13 | 4.01 | 52.15 | 230 | 922.60 | |
| Nov. 20, 2025 | issue | SO-251120-498 | MAIN | 7 | 4.01 | -28.08 | 217 | 870.45 | Sept. 18, 2025: 7 @ 4.01 |
| Nov. 20, 2025 | issue | SO-251120-498 | EAST | 36 | 4.01 | -144.41 | 224 | 898.53 | Sept. 18, 2025: 36 @ 4.01 |
| Nov. 8, 2025 | issue | SO-251108-702 | MAIN | 33 | 4.01 | -132.37 | 260 | 1,042.94 | Sept. 18, 2025: 33 @ 4.01 |
| Nov. 6, 2025 | issue | SO-251106-337 | MAIN | 27 | 4.01 | -108.31 | 293 | 1,175.31 | Sept. 18, 2025: 27 @ 4.01 |
| Oct. 30, 2025 | issue | SO-251030-962 | MAIN | 79 | 4.01 | -316.89 | 320 | 1,283.62 | Sept. 18, 2025: 79 @ 4.01 |
| Oct. 5, 2025 | issue | SO-251005-690 | MAIN | 50 | 4.00 | -199.83 | 399 | 1,600.51 | May 24, 2025: 9 @ 3.93; Sept. 18, 2025: 41 @ 4.01 |