Items / CON-0005
Bend 20mm Pro CON-0005 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)151EAST 151
Value (FIFO)867.36avg 5.74
ClassCX / FCV 0.23
Turnover4.5xlast issue 4 days ago
Days of cover36lead 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 | 129.08 / 30.4375 | 4.241 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 30.33 / 5.517 | 5.498 |
| 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.498^2 + 4.241^2 * 3.1^2) | 31.3 |
| Reorder point | d * LT + safety stock | 4.241 * 14.0 + 31.3 | 90.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 90.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1548/yr, S = 45.00, h = 20%, price = 5.69 | 349.9 |
| Inventory position | on hand + on order | 151 + 0 | 151 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 5.69 | 350 | 9,206 | yes (chosen if cheapest) |
MOQ 600, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 8, 2026 | 151 / 600 | 5.74 | 867.36 |
Movement ledger 136 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-109 | EAST | 42 | 5.74 | -241.25 | 151 | 867.36 | Aug. 8, 2026: 42 @ 5.74 |
| Oct. 12, 2026 | issue | SO-261012-109 | MAIN | 20 | 5.74 | -114.88 | 193 | 1,108.61 | Aug. 8, 2026: 20 @ 5.74 |
| Oct. 11, 2026 | issue | SO-261011-543 | MAIN | 58 | 5.74 | -333.16 | 213 | 1,223.49 | Aug. 8, 2026: 58 @ 5.74 |
| Oct. 1, 2026 | issue | SO-261001-674 | MAIN | 58 | 5.74 | -333.16 | 271 | 1,556.65 | Aug. 8, 2026: 58 @ 5.74 |
| Sept. 26, 2026 | issue | SO-260926-109 | MAIN | 35 | 5.74 | -201.04 | 329 | 1,889.81 | Aug. 8, 2026: 35 @ 5.74 |
| Sept. 10, 2026 | issue | SO-260910-295 | MAIN | 166 | 5.74 | -953.52 | 364 | 2,090.85 | Aug. 8, 2026: 166 @ 5.74 |
| Aug. 25, 2026 | issue | SO-260825-326 | MAIN | 157 | 5.67 | -890.83 | 530 | 3,044.37 | April 4, 2026: 11 @ 5.62; May 23, 2026: 76 @ 5.62; Aug. 8, 2026: 70 @ 5.74 |
| Aug. 22, 2026 | issue | SO-260822-205 | MAIN | 5 | 5.62 | -28.09 | 687 | 3,935.20 | April 4, 2026: 5 @ 5.62 |
| Aug. 8, 2026 | transfer | TRF | MAIN → EAST | 176 | warehouse transfer, no cost effect | ||||
| Aug. 8, 2026 | receipt | PO-001704 | MAIN | 600 | 5.74 | 3,446.46 | 692 | 3,963.29 | |
| July 24, 2026 | issue | SO-260724-962 | MAIN | 48 | 5.62 | -269.65 | 92 | 516.83 | March 8, 2026: 44 @ 5.62; April 4, 2026: 4 @ 5.62 |
| July 23, 2026 | issue | SO-260723-205 | EAST | 10 | 5.62 | -56.18 | 140 | 786.48 | March 8, 2026: 10 @ 5.62 |
| July 17, 2026 | issue | SO-260717-483 | MAIN | 24 | 5.62 | -134.82 | 150 | 842.66 | March 8, 2026: 24 @ 5.62 |
| July 14, 2026 | issue | SO-260714-381 | MAIN | 25 | 5.62 | -140.44 | 174 | 977.48 | March 8, 2026: 25 @ 5.62 |
| July 11, 2026 | issue | SO-260711-746 | MAIN | 9 | 5.62 | -50.56 | 199 | 1,117.92 | March 8, 2026: 9 @ 5.62 |
| July 3, 2026 | issue | SO-260703-839 | EAST | 1 | 5.62 | -5.62 | 208 | 1,168.48 | March 8, 2026: 1 @ 5.62 |
| June 30, 2026 | issue | SO-260630-575 | MAIN | 29 | 5.62 | -162.91 | 209 | 1,174.10 | March 8, 2026: 29 @ 5.62 |
| June 27, 2026 | issue | SO-260627-645 | EAST | 15 | 5.62 | -84.27 | 238 | 1,337.01 | March 8, 2026: 15 @ 5.62 |
| June 25, 2026 | issue | SO-260625-929 | EAST | 14 | 5.62 | -78.65 | 253 | 1,421.28 | March 8, 2026: 14 @ 5.62 |
| June 22, 2026 | issue | SO-260622-606 | MAIN | 5 | 5.62 | -28.09 | 267 | 1,499.93 | March 8, 2026: 5 @ 5.62 |
| June 18, 2026 | issue | SO-260618-255 | MAIN | 27 | 5.62 | -151.68 | 272 | 1,528.01 | March 8, 2026: 27 @ 5.62 |
| June 7, 2026 | issue | SO-260607-667 | MAIN | 6 | 5.62 | -33.71 | 299 | 1,679.69 | March 8, 2026: 6 @ 5.62 |
| May 27, 2026 | issue | SO-260527-255 | MAIN | 25 | 5.62 | -140.44 | 305 | 1,713.40 | March 8, 2026: 25 @ 5.62 |
| May 23, 2026 | return | RMA | MAIN | 76 | 5.62 | 426.95 | 330 | 1,853.84 | |
| May 3, 2026 | issue | SO-260503-232 | MAIN | 152 | 5.62 | -853.89 | 254 | 1,426.90 | March 8, 2026: 152 @ 5.62 |
| April 20, 2026 | issue | SO-260420-113 | MAIN | 24 | 5.62 | -134.82 | 406 | 2,280.79 | March 8, 2026: 24 @ 5.62 |
| April 19, 2026 | issue | SO-260419-310 | MAIN | 76 | 5.62 | -426.95 | 430 | 2,415.61 | March 8, 2026: 76 @ 5.62 |
| April 16, 2026 | issue | SO-260416-359 | EAST | 22 | 5.62 | -123.59 | 506 | 2,842.56 | March 8, 2026: 22 @ 5.62 |
| April 6, 2026 | issue | SO-260406-958 | MAIN | 16 | 5.62 | -89.88 | 528 | 2,966.15 | March 8, 2026: 16 @ 5.62 |
| April 4, 2026 | return | RMA | MAIN | 20 | 5.62 | 112.35 | 544 | 3,056.03 | |
| April 3, 2026 | issue | SO-260403-845 | MAIN | 12 | 5.62 | -67.41 | 524 | 2,943.67 | March 8, 2026: 12 @ 5.62 |
| April 2, 2026 | issue | SO-260402-171 | EAST | 15 | 5.62 | -84.27 | 536 | 3,011.09 | March 8, 2026: 15 @ 5.62 |
| March 30, 2026 | issue | SO-260330-625 | EAST | 41 | 5.62 | -230.33 | 551 | 3,095.35 | March 8, 2026: 41 @ 5.62 |
| March 24, 2026 | issue | SO-260324-793 | MAIN | 26 | 5.40 | -140.34 | 592 | 3,325.68 | Sept. 17, 2025: 16 @ 5.30; Jan. 25, 2026: 2 @ 5.32; March 8, 2026: 8 @ 5.62 |
| March 23, 2026 | issue | SO-260323-734 | EAST | 38 | 5.32 | -202.01 | 618 | 3,466.02 | Sept. 14, 2025: 34 @ 5.32; Sept. 17, 2025: 4 @ 5.30 |
| March 14, 2026 | issue | SO-260314-410 | MAIN | 11 | 5.32 | -58.50 | 656 | 3,668.03 | Sept. 14, 2025: 11 @ 5.32 |
| March 8, 2026 | transfer | TRF | MAIN → EAST | 173 | warehouse transfer, no cost effect | ||||
| March 8, 2026 | receipt | PO-001294 | MAIN | 600 | 5.62 | 3,370.62 | 667 | 3,726.53 | |
| March 7, 2026 | issue | SO-260307-501 | MAIN | 5 | 5.32 | -26.59 | 67 | 355.91 | Sept. 14, 2025: 5 @ 5.32 |
| March 1, 2026 | issue | SO-260301-180 | MAIN | 14 | 5.32 | -74.45 | 72 | 382.50 | Sept. 14, 2025: 14 @ 5.32 |
| Feb. 26, 2026 | issue | SO-260226-552 | MAIN | 11 | 5.32 | -58.50 | 86 | 456.95 | Sept. 14, 2025: 11 @ 5.32 |
| Feb. 19, 2026 | issue | SO-260219-838 | MAIN | 18 | 5.32 | -95.73 | 97 | 515.45 | Sept. 14, 2025: 18 @ 5.32 |
| Feb. 12, 2026 | issue | SO-260212-170 | MAIN | 58 | 5.32 | -308.45 | 115 | 611.18 | Sept. 14, 2025: 58 @ 5.32 |
| Feb. 5, 2026 | issue | SO-260205-812 | MAIN | 10 | 5.32 | -53.18 | 173 | 919.63 | Sept. 14, 2025: 10 @ 5.32 |
| Jan. 25, 2026 | return | RMA | MAIN | 2 | 5.32 | 10.64 | 183 | 972.81 | |
| Jan. 20, 2026 | issue | SO-260120-475 | MAIN | 28 | 5.32 | -148.91 | 181 | 962.17 | Sept. 14, 2025: 28 @ 5.32 |
| Jan. 17, 2026 | issue | SO-260117-323 | MAIN | 4 | 5.32 | -21.27 | 209 | 1,111.08 | Sept. 14, 2025: 4 @ 5.32 |
| Jan. 16, 2026 | issue | SO-260116-389 | MAIN | 14 | 5.32 | -74.45 | 213 | 1,132.35 | Sept. 14, 2025: 14 @ 5.32 |
| Jan. 12, 2026 | issue | SO-260112-652 | MAIN | 4 | 5.32 | -21.27 | 227 | 1,206.80 | Sept. 14, 2025: 4 @ 5.32 |
| Jan. 11, 2026 | issue | SO-260111-518 | MAIN | 52 | 5.32 | -276.54 | 231 | 1,228.08 | Sept. 14, 2025: 52 @ 5.32 |
| Jan. 8, 2026 | issue | SO-260108-495 | MAIN | 5 | 5.32 | -26.59 | 283 | 1,504.62 | Sept. 14, 2025: 5 @ 5.32 |
| Dec. 30, 2025 | issue | SO-251230-697 | MAIN | 26 | 5.32 | -138.27 | 288 | 1,531.21 | Sept. 14, 2025: 26 @ 5.32 |
| Dec. 17, 2025 | issue | SO-251217-116 | MAIN | 5 | 5.32 | -26.59 | 314 | 1,669.48 | Sept. 14, 2025: 5 @ 5.32 |
| Dec. 13, 2025 | issue | SO-251213-153 | MAIN | 14 | 5.32 | -74.45 | 319 | 1,696.07 | Sept. 14, 2025: 14 @ 5.32 |
| Dec. 8, 2025 | issue | SO-251208-844 | MAIN | 30 | 5.32 | -159.54 | 333 | 1,770.52 | Sept. 14, 2025: 30 @ 5.32 |
| Dec. 5, 2025 | issue | SO-251205-809 | MAIN | 58 | 5.32 | -308.45 | 363 | 1,930.06 | Sept. 14, 2025: 58 @ 5.32 |
| Nov. 27, 2025 | issue | SO-251127-737 | MAIN | 20 | 5.32 | -106.36 | 421 | 2,238.51 | Sept. 14, 2025: 20 @ 5.32 |
| Nov. 27, 2025 | issue | SO-251127-737 | EAST | 6 | 5.32 | -31.91 | 441 | 2,344.88 | Sept. 14, 2025: 6 @ 5.32 |
| Nov. 22, 2025 | issue | SO-251122-374 | MAIN | 27 | 5.32 | -143.59 | 447 | 2,376.78 | Sept. 14, 2025: 27 @ 5.32 |
| Nov. 19, 2025 | issue | SO-251119-369 | MAIN | 2 | 5.32 | -10.64 | 474 | 2,520.37 | Sept. 14, 2025: 2 @ 5.32 |