Items / CON-0025
Cable Tie 200mm Elite CON-0025 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)274MAIN 274
Value (FIFO)2,921.17avg 10.66
ClassCX / FCV 0.16
Turnover3.6xlast issue 1 days ago
Days of cover113lead 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 | 74.00 / 30.4375 | 2.431 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.08 / 5.517 | 2.190 |
| 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 * 2.190^2 + 2.431^2 * 3.1^2) | 14.3 |
| Reorder point | d * LT + safety stock | 2.431 * 14.0 + 14.3 | 48.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 48.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 887/yr, S = 45.00, h = 20%, price = 10.68 | 193.4 |
| Inventory position | on hand + on order | 274 + 0 | 274 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 10.68 | 193 | 9,890 | yes (chosen if cheapest) |
MOQ 320, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 27, 2026 | 274 / 320 | 10.66 | 2,921.17 |
Movement ledger 133 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-233 | MAIN | 16 | 10.66 | -170.58 | 274 | 2,921.17 | Sept. 27, 2026: 16 @ 10.66 |
| Oct. 11, 2026 | issue | SO-261011-368 | MAIN | 25 | 10.66 | -266.53 | 290 | 3,091.75 | Sept. 27, 2026: 25 @ 10.66 |
| Oct. 10, 2026 | issue | SO-261010-874 | MAIN | 34 | 10.73 | -364.85 | 315 | 3,358.28 | May 16, 2026: 29 @ 10.74; Sept. 27, 2026: 5 @ 10.66 |
| Oct. 5, 2026 | issue | SO-261005-240 | EAST | 4 | 10.74 | -42.97 | 349 | 3,723.13 | May 16, 2026: 4 @ 10.74 |
| Sept. 27, 2026 | receipt | PO-001833 | MAIN | 320 | 10.66 | 3,411.58 | 353 | 3,766.10 | |
| Sept. 26, 2026 | issue | SO-260926-326 | MAIN | 14 | 10.74 | -150.40 | 33 | 354.52 | May 16, 2026: 14 @ 10.74 |
| Sept. 15, 2026 | issue | SO-260915-227 | EAST | 15 | 10.74 | -161.14 | 47 | 504.92 | May 16, 2026: 15 @ 10.74 |
| Sept. 13, 2026 | issue | SO-260913-222 | EAST | 17 | 10.74 | -182.63 | 62 | 666.06 | May 16, 2026: 17 @ 10.74 |
| Sept. 5, 2026 | issue | SO-260905-494 | MAIN | 39 | 10.74 | -418.97 | 79 | 848.69 | May 16, 2026: 39 @ 10.74 |
| Aug. 26, 2026 | issue | SO-260826-135 | MAIN | 4 | 10.74 | -42.97 | 118 | 1,267.66 | May 16, 2026: 4 @ 10.74 |
| Aug. 17, 2026 | issue | SO-260817-866 | EAST | 34 | 10.74 | -365.26 | 122 | 1,310.63 | May 16, 2026: 34 @ 10.74 |
| Aug. 14, 2026 | issue | SO-260814-104 | MAIN | 1 | 10.74 | -10.74 | 156 | 1,675.89 | May 16, 2026: 1 @ 10.74 |
| Aug. 5, 2026 | issue | SO-260805-955 | MAIN | 31 | 10.74 | -333.03 | 157 | 1,686.64 | May 16, 2026: 31 @ 10.74 |
| July 30, 2026 | issue | SO-260730-613 | EAST | 12 | 10.74 | -128.91 | 188 | 2,019.67 | May 16, 2026: 12 @ 10.74 |
| July 28, 2026 | issue | SO-260728-226 | MAIN | 12 | 10.74 | -128.91 | 200 | 2,148.58 | May 16, 2026: 12 @ 10.74 |
| July 24, 2026 | issue | SO-260724-445 | MAIN | 13 | 10.74 | -139.66 | 212 | 2,277.49 | May 16, 2026: 13 @ 10.74 |
| July 15, 2026 | issue | SO-260715-116 | EAST | 1 | 10.74 | -10.74 | 225 | 2,417.15 | May 16, 2026: 1 @ 10.74 |
| July 7, 2026 | issue | SO-260707-569 | MAIN | 29 | 10.74 | -311.54 | 226 | 2,427.90 | May 16, 2026: 29 @ 10.74 |
| June 27, 2026 | issue | SO-260627-722 | MAIN | 4 | 10.74 | -42.97 | 255 | 2,739.44 | May 16, 2026: 4 @ 10.74 |
| June 17, 2026 | issue | SO-260617-469 | MAIN | 32 | 10.74 | -343.77 | 259 | 2,782.41 | May 16, 2026: 32 @ 10.74 |
| June 13, 2026 | issue | SO-260613-808 | MAIN | 3 | 10.74 | -32.23 | 291 | 3,126.18 | May 16, 2026: 3 @ 10.74 |
| June 11, 2026 | issue | SO-260611-876 | MAIN | 19 | 10.74 | -204.12 | 294 | 3,158.41 | May 16, 2026: 19 @ 10.74 |
| May 30, 2026 | issue | SO-260530-122 | MAIN | 6 | 10.74 | -64.46 | 313 | 3,362.53 | May 16, 2026: 6 @ 10.74 |
| May 26, 2026 | issue | SO-260526-458 | MAIN | 26 | 10.16 | -264.27 | 319 | 3,426.99 | Jan. 22, 2026: 25 @ 10.14; May 16, 2026: 1 @ 10.74 |
| May 16, 2026 | transfer | TRF | MAIN → EAST | 70 | warehouse transfer, no cost effect | ||||
| May 16, 2026 | receipt | PO-001498 | MAIN | 320 | 10.74 | 3,437.73 | 345 | 3,691.26 | |
| May 8, 2026 | issue | SO-260508-283 | MAIN | 26 | 10.14 | -263.67 | 25 | 253.53 | Jan. 22, 2026: 26 @ 10.14 |
| May 6, 2026 | issue | SO-260506-220 | MAIN | 16 | 10.14 | -162.26 | 51 | 517.20 | Jan. 22, 2026: 16 @ 10.14 |
| May 2, 2026 | issue | SO-260502-541 | MAIN | 15 | 10.14 | -152.12 | 67 | 679.46 | Jan. 22, 2026: 15 @ 10.14 |
| April 30, 2026 | issue | SO-260430-815 | MAIN | 6 | 10.14 | -60.85 | 82 | 831.58 | Jan. 22, 2026: 6 @ 10.14 |
| April 14, 2026 | issue | SO-260414-728 | MAIN | 15 | 10.14 | -152.12 | 88 | 892.43 | Jan. 22, 2026: 15 @ 10.14 |
| April 11, 2026 | issue | SO-260411-907 | MAIN | 27 | 10.14 | -273.81 | 103 | 1,044.54 | Jan. 22, 2026: 27 @ 10.14 |
| April 5, 2026 | issue | SO-260405-335 | MAIN | 24 | 10.14 | -243.39 | 130 | 1,318.36 | Jan. 22, 2026: 24 @ 10.14 |
| April 2, 2026 | issue | SO-260402-948 | MAIN | 11 | 10.14 | -111.55 | 154 | 1,561.74 | Jan. 22, 2026: 11 @ 10.14 |
| March 31, 2026 | issue | SO-260331-536 | EAST | 20 | 10.14 | -202.82 | 165 | 1,673.30 | Jan. 22, 2026: 20 @ 10.14 |
| March 30, 2026 | issue | SO-260330-606 | MAIN | 17 | 10.14 | -172.40 | 185 | 1,876.12 | Jan. 22, 2026: 17 @ 10.14 |
| March 25, 2026 | issue | SO-260325-348 | EAST | 7 | 10.14 | -70.99 | 202 | 2,048.52 | Jan. 22, 2026: 7 @ 10.14 |
| March 21, 2026 | issue | SO-260321-565 | MAIN | 2 | 10.14 | -20.28 | 209 | 2,119.51 | Jan. 22, 2026: 2 @ 10.14 |
| March 8, 2026 | issue | SO-260308-923 | MAIN | 19 | 10.14 | -192.68 | 211 | 2,139.79 | Jan. 22, 2026: 19 @ 10.14 |
| Feb. 27, 2026 | issue | SO-260227-869 | MAIN | 9 | 10.14 | -91.27 | 230 | 2,332.48 | Jan. 22, 2026: 9 @ 10.14 |
| Feb. 22, 2026 | issue | SO-260222-482 | MAIN | 4 | 10.14 | -40.56 | 239 | 2,423.75 | Jan. 22, 2026: 4 @ 10.14 |
| Feb. 20, 2026 | issue | SO-260220-646 | MAIN | 10 | 10.14 | -101.41 | 243 | 2,464.31 | Jan. 22, 2026: 10 @ 10.14 |
| Feb. 14, 2026 | issue | SO-260214-768 | EAST | 35 | 10.14 | -354.94 | 253 | 2,565.72 | Jan. 22, 2026: 35 @ 10.14 |
| Feb. 13, 2026 | issue | SO-260213-119 | MAIN | 6 | 10.14 | -60.85 | 288 | 2,920.67 | Jan. 22, 2026: 6 @ 10.14 |
| Feb. 9, 2026 | issue | SO-260209-648 | MAIN | 15 | 10.14 | -152.12 | 294 | 2,981.51 | Jan. 22, 2026: 15 @ 10.14 |
| Feb. 6, 2026 | issue | SO-260206-553 | MAIN | 4 | 10.14 | -40.56 | 309 | 3,133.63 | Jan. 22, 2026: 4 @ 10.14 |
| Jan. 31, 2026 | issue | SO-260131-551 | MAIN | 1 | 10.14 | -10.14 | 313 | 3,174.20 | Jan. 22, 2026: 1 @ 10.14 |
| Jan. 27, 2026 | issue | SO-260127-407 | MAIN | 14 | 10.23 | -143.24 | 314 | 3,184.34 | Aug. 31, 2025: 2 @ 10.30; Oct. 4, 2025: 6 @ 10.30; Jan. 22, 2026: 6 @ 10.14 |
| Jan. 22, 2026 | issue | SO-260122-880 | MAIN | 29 | 10.30 | -298.66 | 328 | 3,327.57 | Aug. 31, 2025: 29 @ 10.30 |
| Jan. 22, 2026 | transfer | TRF | MAIN → EAST | 75 | warehouse transfer, no cost effect | ||||
| Jan. 22, 2026 | receipt | PO-001169 | MAIN | 320 | 10.14 | 3,245.18 | 357 | 3,626.23 | |
| Jan. 19, 2026 | issue | SO-260119-547 | MAIN | 2 | 10.30 | -20.60 | 37 | 381.05 | Aug. 31, 2025: 2 @ 10.30 |
| Jan. 18, 2026 | issue | SO-260118-893 | MAIN | 8 | 10.30 | -82.39 | 39 | 401.65 | Aug. 31, 2025: 8 @ 10.30 |
| Jan. 12, 2026 | issue | SO-260112-347 | MAIN | 23 | 10.30 | -236.87 | 47 | 484.03 | Aug. 31, 2025: 23 @ 10.30 |
| Jan. 1, 2026 | issue | SO-260101-672 | MAIN | 2 | 10.30 | -20.60 | 70 | 720.90 | Aug. 31, 2025: 2 @ 10.30 |
| Dec. 29, 2025 | issue | SO-251229-339 | MAIN | 26 | 10.30 | -267.76 | 72 | 741.50 | Aug. 31, 2025: 26 @ 10.30 |
| Dec. 21, 2025 | issue | SO-251221-325 | MAIN | 5 | 10.30 | -51.49 | 98 | 1,009.26 | Aug. 31, 2025: 5 @ 10.30 |
| Dec. 9, 2025 | issue | SO-251209-529 | MAIN | 9 | 10.30 | -92.69 | 103 | 1,060.76 | Aug. 31, 2025: 9 @ 10.30 |
| Dec. 2, 2025 | issue | SO-251202-241 | MAIN | 10 | 10.30 | -102.99 | 112 | 1,153.44 | Aug. 31, 2025: 10 @ 10.30 |
| Nov. 28, 2025 | issue | SO-251128-559 | MAIN | 14 | 10.30 | -144.18 | 122 | 1,256.43 | Aug. 31, 2025: 14 @ 10.30 |