Items / CON-0019
Cable Tie 200mm Elite CON-0019 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)187MAIN 187
Value (FIFO)2,596.85avg 13.89
ClassCX / FCV 0.25
Turnover2.9xlast issue 5 days ago
Days of cover136lead 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 | 41.92 / 30.4375 | 1.377 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.36 / 5.517 | 1.879 |
| 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.879^2 + 1.377^2 * 3.1^2) | 10.6 |
| Reorder point | d * LT + safety stock | 1.377 * 14.0 + 10.6 | 29.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 29.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 503/yr, S = 45.00, h = 20%, price = 13.71 | 128.4 |
| Inventory position | on hand + on order | 187 + 0 | 187 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 13.71 | 128 | 7,244 | yes (chosen if cheapest) |
MOQ 180, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| June 19, 2026 | 7 / 180 | 13.23 | 92.58 | |
| Oct. 15, 2026 | 180 / 180 | 13.91 | 2,504.27 |
Movement ledger 131 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 | receipt | PO-001881 | MAIN | 180 | 13.91 | 2,504.27 | 187 | 2,596.85 | |
| Oct. 11, 2026 | issue | SO-261011-159 | MAIN | 3 | 13.23 | -39.68 | 7 | 92.58 | June 19, 2026: 3 @ 13.23 |
| Oct. 3, 2026 | issue | SO-261003-498 | MAIN | 4 | 13.23 | -52.90 | 10 | 132.25 | June 19, 2026: 4 @ 13.23 |
| Oct. 3, 2026 | issue | SO-261003-498 | EAST | 14 | 13.23 | -185.15 | 14 | 185.15 | June 19, 2026: 14 @ 13.23 |
| Oct. 2, 2026 | issue | SO-261002-184 | EAST | 37 | 13.23 | -489.34 | 28 | 370.31 | June 19, 2026: 37 @ 13.23 |
| Oct. 1, 2026 | issue | SO-261001-702 | MAIN | 3 | 13.23 | -39.68 | 65 | 859.64 | June 19, 2026: 3 @ 13.23 |
| Sept. 21, 2026 | issue | SO-260921-790 | MAIN | 14 | 13.23 | -185.15 | 68 | 899.32 | June 19, 2026: 14 @ 13.23 |
| Sept. 19, 2026 | issue | SO-260919-495 | MAIN | 20 | 13.23 | -264.51 | 82 | 1,084.47 | June 19, 2026: 20 @ 13.23 |
| Aug. 30, 2026 | issue | SO-260830-868 | MAIN | 37 | 13.23 | -489.34 | 102 | 1,348.98 | June 19, 2026: 37 @ 13.23 |
| Aug. 25, 2026 | issue | SO-260825-142 | EAST | 1 | 13.23 | -13.23 | 139 | 1,838.32 | June 19, 2026: 1 @ 13.23 |
| Aug. 16, 2026 | issue | SO-260816-483 | MAIN | 24 | 13.23 | -317.41 | 140 | 1,851.54 | June 19, 2026: 24 @ 13.23 |
| July 30, 2026 | issue | SO-260730-758 | MAIN | 2 | 13.23 | -26.45 | 164 | 2,168.95 | June 19, 2026: 2 @ 13.23 |
| July 22, 2026 | issue | SO-260722-307 | EAST | 1 | 13.23 | -13.23 | 166 | 2,195.40 | June 19, 2026: 1 @ 13.23 |
| July 18, 2026 | issue | SO-260718-190 | MAIN | 19 | 13.35 | -253.56 | 167 | 2,208.63 | March 5, 2026: 6 @ 13.61; June 19, 2026: 13 @ 13.23 |
| July 14, 2026 | issue | SO-260714-753 | MAIN | 1 | 13.61 | -13.61 | 186 | 2,462.19 | March 5, 2026: 1 @ 13.61 |
| July 11, 2026 | issue | SO-260711-766 | MAIN | 10 | 13.61 | -136.06 | 187 | 2,475.79 | March 5, 2026: 10 @ 13.61 |
| July 5, 2026 | issue | SO-260705-670 | EAST | 1 | 13.61 | -13.61 | 197 | 2,611.85 | March 5, 2026: 1 @ 13.61 |
| June 19, 2026 | transfer | TRF | MAIN → EAST | 54 | warehouse transfer, no cost effect | ||||
| June 19, 2026 | receipt | PO-001586 | MAIN | 180 | 13.23 | 2,380.55 | 198 | 2,625.45 | |
| June 15, 2026 | issue | SO-260615-758 | MAIN | 9 | 13.61 | -122.45 | 18 | 244.90 | March 5, 2026: 9 @ 13.61 |
| June 4, 2026 | issue | SO-260604-861 | MAIN | 21 | 13.61 | -285.72 | 27 | 367.35 | March 5, 2026: 21 @ 13.61 |
| May 28, 2026 | issue | SO-260528-146 | MAIN | 2 | 13.61 | -27.21 | 48 | 653.06 | March 5, 2026: 2 @ 13.61 |
| May 24, 2026 | issue | SO-260524-813 | MAIN | 17 | 13.61 | -231.29 | 50 | 680.28 | March 5, 2026: 17 @ 13.61 |
| May 21, 2026 | issue | SO-260521-282 | MAIN | 1 | 13.61 | -13.61 | 67 | 911.57 | March 5, 2026: 1 @ 13.61 |
| May 13, 2026 | issue | SO-260513-133 | MAIN | 17 | 13.61 | -231.29 | 68 | 925.17 | March 5, 2026: 17 @ 13.61 |
| May 2, 2026 | issue | SO-260502-674 | MAIN | 14 | 13.61 | -190.48 | 85 | 1,156.47 | March 5, 2026: 14 @ 13.61 |
| April 14, 2026 | issue | SO-260414-771 | MAIN | 1 | 13.61 | -13.61 | 99 | 1,346.94 | March 5, 2026: 1 @ 13.61 |
| April 13, 2026 | issue | SO-260413-616 | MAIN | 19 | 13.61 | -258.50 | 100 | 1,360.55 | March 5, 2026: 19 @ 13.61 |
| April 9, 2026 | issue | SO-260409-103 | MAIN | 13 | 13.61 | -176.87 | 119 | 1,619.05 | March 5, 2026: 13 @ 13.61 |
| April 7, 2026 | issue | SO-260407-276 | MAIN | 5 | 13.61 | -68.03 | 132 | 1,795.93 | March 5, 2026: 5 @ 13.61 |
| April 4, 2026 | issue | SO-260404-210 | MAIN | 8 | 13.61 | -108.84 | 137 | 1,863.95 | March 5, 2026: 8 @ 13.61 |
| March 26, 2026 | issue | SO-260326-293 | MAIN | 9 | 13.61 | -122.45 | 145 | 1,972.80 | March 5, 2026: 9 @ 13.61 |
| March 23, 2026 | issue | SO-260323-222 | MAIN | 16 | 13.61 | -217.69 | 154 | 2,095.25 | March 5, 2026: 16 @ 13.61 |
| March 20, 2026 | issue | SO-260320-652 | MAIN | 3 | 13.61 | -40.82 | 170 | 2,312.94 | March 5, 2026: 3 @ 13.61 |
| March 18, 2026 | issue | SO-260318-149 | MAIN | 2 | 13.61 | -27.21 | 173 | 2,353.75 | March 5, 2026: 2 @ 13.61 |
| March 16, 2026 | adjustment | Cycle count | MAIN | -1 | 13.61 | -13.61 | 175 | 2,380.96 | March 5, 2026: 1 @ 13.61 |
| March 13, 2026 | issue | SO-260313-145 | MAIN | 12 | 13.24 | -158.90 | 176 | 2,394.57 | Oct. 16, 2025: 8 @ 13.06; March 5, 2026: 4 @ 13.61 |
| March 9, 2026 | issue | SO-260309-722 | MAIN | 3 | 13.06 | -39.18 | 188 | 2,553.47 | Oct. 16, 2025: 3 @ 13.06 |
| March 5, 2026 | receipt | PO-001287 | MAIN | 180 | 13.61 | 2,448.99 | 191 | 2,592.64 | |
| March 2, 2026 | issue | SO-260302-626 | MAIN | 6 | 13.06 | -78.36 | 11 | 143.65 | Oct. 16, 2025: 6 @ 13.06 |
| Feb. 27, 2026 | issue | SO-260227-358 | MAIN | 5 | 13.06 | -65.30 | 17 | 222.01 | Oct. 16, 2025: 5 @ 13.06 |
| Feb. 20, 2026 | issue | SO-260220-385 | MAIN | 3 | 13.06 | -39.18 | 22 | 287.31 | Oct. 16, 2025: 3 @ 13.06 |
| Feb. 19, 2026 | issue | SO-260219-410 | MAIN | 1 | 13.06 | -13.06 | 25 | 326.48 | Oct. 16, 2025: 1 @ 13.06 |
| Feb. 12, 2026 | issue | SO-260212-274 | MAIN | 11 | 13.06 | -143.65 | 26 | 339.54 | Oct. 16, 2025: 11 @ 13.06 |
| Feb. 8, 2026 | issue | SO-260208-665 | MAIN | 24 | 13.06 | -313.43 | 37 | 483.20 | Oct. 16, 2025: 24 @ 13.06 |
| Feb. 6, 2026 | issue | SO-260206-878 | MAIN | 6 | 13.06 | -78.36 | 61 | 796.62 | Oct. 16, 2025: 6 @ 13.06 |
| Jan. 31, 2026 | issue | SO-260131-652 | MAIN | 6 | 13.06 | -78.36 | 67 | 874.98 | Oct. 16, 2025: 6 @ 13.06 |
| Jan. 30, 2026 | issue | SO-260130-194 | MAIN | 2 | 13.06 | -26.12 | 73 | 953.34 | Oct. 16, 2025: 2 @ 13.06 |
| Jan. 29, 2026 | issue | SO-260129-283 | MAIN | 2 | 13.06 | -26.12 | 75 | 979.46 | Oct. 16, 2025: 2 @ 13.06 |
| Jan. 18, 2026 | issue | SO-260118-386 | MAIN | 5 | 13.06 | -65.30 | 77 | 1,005.57 | Oct. 16, 2025: 5 @ 13.06 |
| Jan. 13, 2026 | issue | SO-260113-274 | MAIN | 4 | 13.06 | -52.24 | 82 | 1,070.87 | Oct. 16, 2025: 4 @ 13.06 |
| Jan. 11, 2026 | issue | SO-260111-390 | MAIN | 10 | 13.06 | -130.59 | 86 | 1,123.11 | Oct. 16, 2025: 10 @ 13.06 |
| Jan. 5, 2026 | issue | SO-260105-970 | MAIN | 2 | 13.06 | -26.12 | 96 | 1,253.70 | Oct. 16, 2025: 2 @ 13.06 |
| Dec. 31, 2025 | issue | SO-251231-547 | MAIN | 6 | 13.06 | -78.36 | 98 | 1,279.82 | Oct. 16, 2025: 6 @ 13.06 |
| Dec. 31, 2025 | issue | SO-251231-547 | EAST | 3 | 13.06 | -39.18 | 104 | 1,358.18 | Oct. 16, 2025: 3 @ 13.06 |
| Dec. 26, 2025 | issue | SO-251226-153 | MAIN | 12 | 13.06 | -156.71 | 107 | 1,397.36 | Oct. 16, 2025: 12 @ 13.06 |
| Dec. 4, 2025 | issue | SO-251204-287 | MAIN | 8 | 13.06 | -104.48 | 119 | 1,554.07 | Oct. 16, 2025: 8 @ 13.06 |
| Nov. 29, 2025 | issue | SO-251129-830 | MAIN | 6 | 13.06 | -78.36 | 127 | 1,658.54 | Oct. 16, 2025: 6 @ 13.06 |
| Nov. 9, 2025 | issue | SO-251109-592 | MAIN | 19 | 13.06 | -248.13 | 133 | 1,736.90 | Oct. 16, 2025: 19 @ 13.06 |
| Nov. 4, 2025 | issue | SO-251104-985 | MAIN | 11 | 13.06 | -143.65 | 152 | 1,985.03 | Oct. 16, 2025: 11 @ 13.06 |