Items / CON-0011
Clamp 25mm Elite CON-0011 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)30MAIN 29, EAST 1
Value (FIFO)129.52avg 4.32
ClassCX / FCV 0.26
Turnover18.0xlast issue 4 days ago
Days of cover41lead 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 | 22.42 / 30.4375 | 0.736 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.78 / 5.517 | 1.048 |
| 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.048^2 + 0.736^2 * 3.1^2) | 5.8 |
| Reorder point | d * LT + safety stock | 0.736 * 14.0 + 5.8 | 16.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 269/yr, S = 45.00, h = 20%, price = 4.42 | 165.4 |
| Inventory position | on hand + on order | 30 + 0 | 30 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 4.42 | 165 | 1,334 | yes (chosen if cheapest) |
MOQ 100, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 6, 2026 | 30 / 100 | 4.32 | 129.52 |
Movement ledger 101 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-568 | MAIN | 7 | 4.32 | -30.22 | 30 | 129.52 | July 6, 2026: 7 @ 4.32 |
| Oct. 10, 2026 | issue | SO-261010-396 | EAST | 15 | 4.32 | -64.76 | 37 | 159.74 | July 6, 2026: 15 @ 4.32 |
| Oct. 3, 2026 | issue | SO-261003-503 | MAIN | 1 | 4.32 | -4.32 | 52 | 224.49 | July 6, 2026: 1 @ 4.32 |
| Sept. 26, 2026 | issue | SO-260926-876 | MAIN | 3 | 4.32 | -12.95 | 53 | 228.81 | July 6, 2026: 3 @ 4.32 |
| Sept. 2, 2026 | issue | SO-260902-231 | MAIN | 19 | 4.32 | -82.03 | 56 | 241.76 | July 6, 2026: 19 @ 4.32 |
| Aug. 20, 2026 | issue | SO-260820-280 | MAIN | 14 | 4.32 | -60.44 | 75 | 323.79 | July 6, 2026: 14 @ 4.32 |
| Aug. 18, 2026 | issue | SO-260818-441 | EAST | 4 | 4.32 | -17.27 | 89 | 384.23 | July 6, 2026: 4 @ 4.32 |
| Aug. 9, 2026 | issue | SO-260809-158 | MAIN | 10 | 4.31 | -43.05 | 93 | 401.50 | Jan. 28, 2026: 1 @ 4.28; April 19, 2026: 1 @ 4.28; July 5, 2026: 1 @ 4.28; July 6, 2026: 7 @ 4.32 |
| July 25, 2026 | issue | SO-260725-225 | MAIN | 11 | 4.28 | -47.05 | 103 | 444.55 | Jan. 28, 2026: 11 @ 4.28 |
| July 20, 2026 | issue | SO-260720-562 | EAST | 3 | 4.28 | -12.83 | 114 | 491.61 | Jan. 28, 2026: 3 @ 4.28 |
| July 6, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| July 6, 2026 | receipt | PO-001627 | MAIN | 100 | 4.32 | 431.72 | 117 | 504.44 | |
| July 5, 2026 | return | RMA | MAIN | 1 | 4.28 | 4.28 | 17 | 72.72 | |
| June 23, 2026 | issue | SO-260623-853 | MAIN | 3 | 4.28 | -12.83 | 16 | 68.44 | Jan. 28, 2026: 3 @ 4.28 |
| June 16, 2026 | issue | SO-260616-769 | MAIN | 1 | 4.28 | -4.28 | 19 | 81.28 | Jan. 28, 2026: 1 @ 4.28 |
| June 11, 2026 | issue | SO-260611-686 | MAIN | 11 | 4.28 | -47.05 | 20 | 85.55 | Jan. 28, 2026: 11 @ 4.28 |
| May 17, 2026 | issue | SO-260517-481 | MAIN | 1 | 4.28 | -4.28 | 31 | 132.61 | Jan. 28, 2026: 1 @ 4.28 |
| May 4, 2026 | issue | SO-260504-726 | MAIN | 2 | 4.28 | -8.56 | 32 | 136.89 | Jan. 28, 2026: 2 @ 4.28 |
| May 3, 2026 | issue | SO-260503-857 | MAIN | 15 | 4.28 | -64.17 | 34 | 145.44 | Jan. 28, 2026: 15 @ 4.28 |
| April 28, 2026 | issue | SO-260428-994 | MAIN | 3 | 4.28 | -12.83 | 49 | 209.61 | Jan. 28, 2026: 3 @ 4.28 |
| April 27, 2026 | issue | SO-260427-323 | MAIN | 2 | 4.28 | -8.56 | 52 | 222.44 | Jan. 28, 2026: 2 @ 4.28 |
| April 19, 2026 | return | RMA | MAIN | 1 | 4.28 | 4.28 | 54 | 231.00 | |
| April 19, 2026 | issue | SO-260419-883 | MAIN | 5 | 4.28 | -21.39 | 53 | 226.72 | Jan. 28, 2026: 5 @ 4.28 |
| April 18, 2026 | issue | SO-260418-725 | MAIN | 2 | 4.28 | -8.56 | 58 | 248.11 | Jan. 28, 2026: 2 @ 4.28 |
| April 16, 2026 | issue | SO-260416-526 | MAIN | 3 | 4.28 | -12.83 | 60 | 256.66 | Jan. 28, 2026: 3 @ 4.28 |
| April 12, 2026 | issue | SO-260412-159 | MAIN | 9 | 4.28 | -38.50 | 63 | 269.50 | Jan. 28, 2026: 9 @ 4.28 |
| March 31, 2026 | issue | SO-260331-710 | MAIN | 1 | 4.28 | -4.28 | 72 | 307.99 | Jan. 28, 2026: 1 @ 4.28 |
| March 30, 2026 | issue | SO-260330-732 | MAIN | 2 | 4.28 | -8.56 | 73 | 312.27 | Jan. 28, 2026: 2 @ 4.28 |
| March 25, 2026 | issue | SO-260325-702 | MAIN | 1 | 4.28 | -4.28 | 75 | 320.83 | Jan. 28, 2026: 1 @ 4.28 |
| March 22, 2026 | issue | SO-260322-425 | MAIN | 8 | 4.28 | -34.22 | 76 | 325.11 | Jan. 28, 2026: 8 @ 4.28 |
| March 14, 2026 | issue | SO-260314-223 | MAIN | 2 | 4.28 | -8.56 | 84 | 359.33 | Jan. 28, 2026: 2 @ 4.28 |
| March 9, 2026 | issue | SO-260309-243 | MAIN | 1 | 4.28 | -4.28 | 86 | 367.88 | Jan. 28, 2026: 1 @ 4.28 |
| Feb. 27, 2026 | issue | SO-260227-991 | MAIN | 5 | 4.28 | -21.39 | 87 | 372.16 | Jan. 28, 2026: 5 @ 4.28 |
| Feb. 22, 2026 | issue | SO-260222-952 | MAIN | 13 | 4.29 | -55.74 | 92 | 393.55 | Oct. 19, 2025: 5 @ 4.30; Jan. 28, 2026: 8 @ 4.28 |
| Feb. 18, 2026 | issue | SO-260218-929 | MAIN | 5 | 4.30 | -21.52 | 105 | 449.29 | Oct. 19, 2025: 5 @ 4.30 |
| Feb. 16, 2026 | issue | SO-260216-466 | MAIN | 1 | 4.30 | -4.30 | 110 | 470.80 | Oct. 19, 2025: 1 @ 4.30 |
| Feb. 9, 2026 | issue | SO-260209-478 | MAIN | 4 | 4.30 | -17.21 | 111 | 475.11 | Oct. 19, 2025: 4 @ 4.30 |
| Feb. 6, 2026 | issue | SO-260206-563 | MAIN | 1 | 4.30 | -4.30 | 115 | 492.32 | Oct. 19, 2025: 1 @ 4.30 |
| Jan. 28, 2026 | receipt | PO-001180 | MAIN | 100 | 4.28 | 427.77 | 116 | 496.62 | |
| Jan. 19, 2026 | issue | SO-260119-909 | MAIN | 15 | 4.30 | -64.55 | 16 | 68.85 | Oct. 19, 2025: 15 @ 4.30 |
| Jan. 4, 2026 | issue | SO-260104-773 | MAIN | 8 | 4.30 | -34.43 | 31 | 133.41 | Oct. 19, 2025: 8 @ 4.30 |
| Dec. 26, 2025 | issue | SO-251226-716 | MAIN | 1 | 4.30 | -4.30 | 39 | 167.83 | Oct. 19, 2025: 1 @ 4.30 |
| Dec. 20, 2025 | issue | SO-251220-453 | MAIN | 10 | 4.30 | -43.03 | 40 | 172.14 | Oct. 19, 2025: 10 @ 4.30 |
| Dec. 16, 2025 | issue | SO-251216-383 | MAIN | 3 | 4.30 | -12.91 | 50 | 215.17 | Oct. 19, 2025: 3 @ 4.30 |
| Dec. 12, 2025 | issue | SO-251212-370 | MAIN | 5 | 4.30 | -21.52 | 53 | 228.08 | Oct. 19, 2025: 5 @ 4.30 |
| Dec. 12, 2025 | issue | SO-251212-370 | EAST | 7 | 4.30 | -30.12 | 58 | 249.60 | Oct. 19, 2025: 7 @ 4.30 |
| Dec. 4, 2025 | issue | SO-251204-906 | MAIN | 2 | 4.30 | -8.61 | 65 | 279.72 | Oct. 19, 2025: 2 @ 4.30 |
| Nov. 8, 2025 | issue | SO-251108-903 | EAST | 20 | 4.30 | -86.07 | 67 | 288.33 | Oct. 19, 2025: 20 @ 4.30 |
| Nov. 7, 2025 | issue | SO-251107-434 | EAST | 3 | 4.30 | -12.91 | 87 | 374.40 | Oct. 19, 2025: 3 @ 4.30 |
| Nov. 3, 2025 | issue | SO-251103-915 | MAIN | 8 | 4.30 | -34.43 | 90 | 387.31 | Oct. 19, 2025: 8 @ 4.30 |
| Oct. 23, 2025 | issue | SO-251023-928 | MAIN | 2 | 4.30 | -8.61 | 98 | 421.73 | Oct. 19, 2025: 2 @ 4.30 |
| Oct. 19, 2025 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| Oct. 19, 2025 | receipt | PO-000932 | MAIN | 100 | 4.30 | 430.34 | 100 | 430.34 | |
| Oct. 10, 2025 | issue | SO-251010-529 | MAIN | 2 | 4.12 | -8.24 | 0 | 0.00 | May 29, 2025: 2 @ 4.12 |
| Oct. 6, 2025 | issue | SO-251006-325 | MAIN | 11 | 4.12 | -45.31 | 2 | 8.24 | May 29, 2025: 11 @ 4.12 |
| Oct. 1, 2025 | issue | SO-251001-130 | MAIN | 9 | 4.12 | -37.07 | 13 | 53.55 | May 29, 2025: 9 @ 4.12 |
| Sept. 26, 2025 | issue | SO-250926-177 | MAIN | 12 | 4.12 | -49.43 | 22 | 90.62 | May 29, 2025: 12 @ 4.12 |
| Sept. 11, 2025 | issue | SO-250911-377 | MAIN | 10 | 4.12 | -41.19 | 34 | 140.05 | May 29, 2025: 10 @ 4.12 |
| Sept. 10, 2025 | issue | SO-250910-911 | MAIN | 9 | 4.12 | -37.07 | 44 | 181.24 | May 29, 2025: 9 @ 4.12 |
| Aug. 20, 2025 | issue | SO-250820-169 | MAIN | 1 | 4.12 | -4.12 | 53 | 218.31 | May 29, 2025: 1 @ 4.12 |