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
| 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 |
| Sept. 27, 2025 | issue | SO-250927-978 | MAIN | 15 | 3.93 | -58.94 | 449 | 1,800.33 | May 24, 2025: 15 @ 3.93 |
| Sept. 20, 2025 | issue | SO-250920-893 | MAIN | 14 | 3.93 | -55.01 | 464 | 1,859.27 | May 24, 2025: 14 @ 3.93 |
| Sept. 19, 2025 | issue | SO-250919-574 | MAIN | 14 | 3.93 | -55.01 | 478 | 1,914.28 | May 24, 2025: 14 @ 3.93 |
| Sept. 18, 2025 | receipt | PO-000855 | MAIN | 440 | 4.01 | 1,764.97 | 492 | 1,969.29 | |
| Sept. 6, 2025 | issue | SO-250906-570 | MAIN | 45 | 3.93 | -176.81 | 52 | 204.32 | May 24, 2025: 45 @ 3.93 |
| Aug. 30, 2025 | issue | SO-250830-993 | MAIN | 12 | 3.93 | -47.15 | 97 | 381.13 | May 24, 2025: 12 @ 3.93 |
| Aug. 23, 2025 | issue | SO-250823-810 | MAIN | 2 | 3.93 | -7.86 | 109 | 428.28 | May 24, 2025: 2 @ 3.93 |
| Aug. 18, 2025 | issue | SO-250818-221 | MAIN | 74 | 3.93 | -290.76 | 111 | 436.14 | May 24, 2025: 74 @ 3.93 |
| Aug. 9, 2025 | issue | SO-250809-254 | MAIN | 11 | 3.93 | -43.22 | 185 | 726.90 | May 24, 2025: 11 @ 3.93 |
| Aug. 3, 2025 | issue | SO-250803-768 | MAIN | 10 | 3.93 | -39.29 | 196 | 770.12 | May 24, 2025: 10 @ 3.93 |
| July 29, 2025 | issue | SO-250729-234 | MAIN | 42 | 3.93 | -165.03 | 206 | 809.42 | May 24, 2025: 42 @ 3.93 |
| July 9, 2025 | issue | SO-250709-256 | MAIN | 40 | 3.93 | -157.17 | 248 | 974.44 | May 24, 2025: 40 @ 3.93 |
| July 3, 2025 | issue | SO-250703-766 | MAIN | 88 | 3.93 | -345.77 | 288 | 1,131.61 | May 24, 2025: 88 @ 3.93 |
| June 22, 2025 | issue | SO-250622-851 | MAIN | 51 | 3.93 | -200.39 | 376 | 1,477.38 | May 24, 2025: 51 @ 3.93 |
| June 7, 2025 | issue | SO-250607-770 | MAIN | 13 | 3.93 | -51.08 | 427 | 1,677.77 | May 24, 2025: 13 @ 3.93 |
| June 5, 2025 | issue | SO-250605-482 | MAIN | 30 | 3.90 | -117.14 | 440 | 1,728.85 | Jan. 27, 2025: 30 @ 3.90 |
| May 26, 2025 | issue | SO-250526-872 | MAIN | 8 | 3.76 | -30.05 | 470 | 1,845.98 | Jan. 21, 2025: 6 @ 3.71; Jan. 27, 2025: 2 @ 3.90 |
| May 24, 2025 | receipt | PO-000566 | MAIN | 440 | 3.93 | 1,728.85 | 478 | 1,876.03 | |
| May 16, 2025 | issue | SO-250516-487 | MAIN | 19 | 3.71 | -70.43 | 38 | 147.19 | Jan. 21, 2025: 19 @ 3.71 |
| May 13, 2025 | issue | SO-250513-956 | MAIN | 12 | 3.71 | -44.48 | 57 | 217.62 | Jan. 21, 2025: 12 @ 3.71 |
| May 10, 2025 | issue | SO-250510-394 | MAIN | 16 | 3.71 | -59.31 | 69 | 262.10 | Jan. 21, 2025: 16 @ 3.71 |
| May 8, 2025 | issue | SO-250508-141 | MAIN | 56 | 3.71 | -207.59 | 85 | 321.41 | Jan. 21, 2025: 56 @ 3.71 |
| April 24, 2025 | issue | SO-250424-489 | EAST | 17 | 3.71 | -63.02 | 141 | 529.00 | Jan. 21, 2025: 17 @ 3.71 |
| April 18, 2025 | issue | SO-250418-921 | MAIN | 41 | 3.71 | -151.98 | 158 | 592.01 | Jan. 21, 2025: 41 @ 3.71 |
| April 17, 2025 | issue | SO-250417-232 | MAIN | 1 | 3.71 | -3.71 | 199 | 744.00 | Jan. 21, 2025: 1 @ 3.71 |
| April 13, 2025 | issue | SO-250413-529 | MAIN | 4 | 3.71 | -14.83 | 200 | 747.70 | Jan. 21, 2025: 4 @ 3.71 |
| April 12, 2025 | issue | SO-250412-323 | MAIN | 6 | 3.71 | -22.24 | 204 | 762.53 | Jan. 21, 2025: 6 @ 3.71 |
| April 7, 2025 | issue | SO-250407-937 | EAST | 3 | 3.71 | -11.12 | 210 | 784.77 | Jan. 21, 2025: 3 @ 3.71 |
| March 23, 2025 | issue | SO-250323-355 | MAIN | 56 | 3.71 | -207.59 | 213 | 795.89 | Jan. 21, 2025: 56 @ 3.71 |
| March 21, 2025 | issue | SO-250321-727 | MAIN | 31 | 3.71 | -114.91 | 269 | 1,003.48 | Jan. 21, 2025: 31 @ 3.71 |
| March 18, 2025 | issue | SO-250318-196 | EAST | 14 | 3.71 | -51.90 | 300 | 1,118.39 | Jan. 21, 2025: 14 @ 3.71 |
| March 14, 2025 | issue | SO-250314-943 | MAIN | 9 | 3.71 | -33.36 | 314 | 1,170.29 | Jan. 21, 2025: 9 @ 3.71 |
| Feb. 27, 2025 | issue | SO-250227-835 | MAIN | 8 | 3.71 | -29.66 | 323 | 1,203.65 | Jan. 21, 2025: 8 @ 3.71 |
| Feb. 25, 2025 | issue | SO-250225-775 | EAST | 27 | 3.71 | -100.09 | 331 | 1,233.31 | Jan. 21, 2025: 27 @ 3.71 |
| Feb. 15, 2025 | issue | SO-250215-776 | MAIN | 85 | 3.71 | -315.09 | 358 | 1,333.39 | Jan. 21, 2025: 85 @ 3.71 |
| Feb. 12, 2025 | issue | SO-250212-359 | EAST | 25 | 3.71 | -92.67 | 443 | 1,648.48 | Jan. 21, 2025: 25 @ 3.71 |
| Jan. 30, 2025 | issue | SO-250130-671 | EAST | 10 | 3.83 | -38.25 | 468 | 1,741.15 | Oct. 1, 2024: 6 @ 3.90; Jan. 21, 2025: 4 @ 3.71 |
| Jan. 27, 2025 | return | RMA | MAIN | 32 | 3.90 | 124.94 | 478 | 1,779.41 | |
| Jan. 21, 2025 | issue | SO-250121-704 | EAST | 5 | 3.90 | -19.52 | 446 | 1,654.46 | Oct. 1, 2024: 5 @ 3.90 |
| Jan. 21, 2025 | transfer | TRF | MAIN → EAST | 137 | warehouse transfer, no cost effect | ||||
| Jan. 21, 2025 | receipt | PO-000205 | MAIN | 440 | 3.71 | 1,631.04 | 451 | 1,673.99 | |
| Jan. 18, 2025 | issue | SO-250118-587 | MAIN | 39 | 3.90 | -152.28 | 11 | 42.95 | Oct. 1, 2024: 39 @ 3.90 |
| Jan. 12, 2025 | issue | SO-250112-797 | MAIN | 5 | 3.90 | -19.52 | 50 | 195.22 | Oct. 1, 2024: 5 @ 3.90 |
| Jan. 7, 2025 | issue | SO-250107-659 | MAIN | 64 | 3.90 | -249.89 | 55 | 214.75 | Oct. 1, 2024: 64 @ 3.90 |
| Dec. 26, 2024 | issue | SO-241226-657 | MAIN | 71 | 3.90 | -277.22 | 119 | 464.64 | Oct. 1, 2024: 71 @ 3.90 |
| Dec. 16, 2024 | issue | SO-241216-206 | MAIN | 33 | 3.90 | -128.85 | 190 | 741.86 | Oct. 1, 2024: 33 @ 3.90 |
| Dec. 7, 2024 | issue | SO-241207-997 | MAIN | 12 | 3.90 | -46.85 | 223 | 870.70 | Oct. 1, 2024: 12 @ 3.90 |
| Dec. 6, 2024 | issue | SO-241206-815 | MAIN | 3 | 3.90 | -11.71 | 235 | 917.56 | Oct. 1, 2024: 3 @ 3.90 |
| Nov. 30, 2024 | issue | SO-241130-119 | MAIN | 103 | 3.90 | -402.16 | 238 | 929.27 | Oct. 1, 2024: 103 @ 3.90 |
| Nov. 26, 2024 | issue | SO-241126-763 | MAIN | 7 | 3.90 | -27.33 | 341 | 1,331.43 | Oct. 1, 2024: 7 @ 3.90 |
| Nov. 19, 2024 | issue | SO-241119-817 | MAIN | 2 | 3.90 | -7.81 | 348 | 1,358.77 | Oct. 1, 2024: 2 @ 3.90 |
| Oct. 28, 2024 | issue | SO-241028-305 | MAIN | 42 | 3.90 | -163.99 | 350 | 1,366.58 | Oct. 1, 2024: 42 @ 3.90 |
| Oct. 27, 2024 | issue | SO-241027-492 | MAIN | 48 | 3.90 | -187.42 | 392 | 1,530.56 | Oct. 1, 2024: 48 @ 3.90 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 440 | 3.90 | 1,717.98 | 440 | 1,717.98 | |