Items / CON-0023
Cable Tie 200mm Eco CON-0023 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)48MAIN 40, EAST 8
Value (FIFO)1,185.68avg 24.70
ClassCX / FCV 0.31
Turnover4.3xlast issue 0 days ago
Days of cover42lead 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 | 34.75 / 30.4375 | 1.142 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.74 / 5.517 | 1.947 |
| 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.947^2 + 1.142^2 * 3.1^2) | 10.4 |
| Reorder point | d * LT + safety stock | 1.142 * 14.0 + 10.4 | 26.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 26.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 417/yr, S = 45.00, h = 20%, price = 25.07 | 86.5 |
| Inventory position | on hand + on order | 48 + 0 | 48 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 25.07 | 86 | 10,881 | yes (chosen if cheapest) |
MOQ 160, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 1, 2026 | 48 / 160 | 24.70 | 1,185.68 |
Movement ledger 109 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-216 | EAST | 2 | 24.70 | -49.40 | 48 | 1,185.68 | Aug. 1, 2026: 2 @ 24.70 |
| Oct. 13, 2026 | issue | SO-261013-871 | MAIN | 27 | 24.70 | -666.95 | 50 | 1,235.08 | Aug. 1, 2026: 27 @ 24.70 |
| Oct. 11, 2026 | issue | SO-261011-967 | EAST | 2 | 24.70 | -49.40 | 77 | 1,902.03 | Aug. 1, 2026: 2 @ 24.70 |
| Oct. 7, 2026 | issue | SO-261007-255 | MAIN | 2 | 24.70 | -49.40 | 79 | 1,951.43 | Aug. 1, 2026: 2 @ 24.70 |
| Oct. 2, 2026 | issue | SO-261002-704 | MAIN | 3 | 24.70 | -74.11 | 81 | 2,000.84 | Aug. 1, 2026: 3 @ 24.70 |
| Sept. 28, 2026 | issue | SO-260928-746 | EAST | 7 | 24.70 | -172.91 | 84 | 2,074.94 | Aug. 1, 2026: 7 @ 24.70 |
| Sept. 22, 2026 | issue | SO-260922-780 | MAIN | 6 | 24.70 | -148.21 | 91 | 2,247.85 | Aug. 1, 2026: 6 @ 24.70 |
| Sept. 16, 2026 | issue | SO-260916-366 | EAST | 36 | 24.70 | -889.26 | 97 | 2,396.06 | Aug. 1, 2026: 36 @ 24.70 |
| Sept. 10, 2026 | issue | SO-260910-283 | MAIN | 1 | 24.70 | -24.70 | 133 | 3,285.33 | Aug. 1, 2026: 1 @ 24.70 |
| Aug. 27, 2026 | issue | SO-260827-594 | MAIN | 2 | 24.70 | -49.40 | 134 | 3,310.03 | Aug. 1, 2026: 2 @ 24.70 |
| Aug. 17, 2026 | issue | SO-260817-809 | MAIN | 30 | 24.73 | -741.95 | 136 | 3,359.43 | July 21, 2026: 6 @ 24.85; Aug. 1, 2026: 24 @ 24.70 |
| Aug. 1, 2026 | issue | SO-260801-489 | MAIN | 10 | 24.85 | -248.52 | 166 | 4,101.38 | March 12, 2026: 8 @ 24.85; July 21, 2026: 2 @ 24.85 |
| Aug. 1, 2026 | transfer | TRF | MAIN → EAST | 55 | warehouse transfer, no cost effect | ||||
| Aug. 1, 2026 | receipt | PO-001687 | MAIN | 160 | 24.70 | 3,952.27 | 176 | 4,349.90 | |
| July 24, 2026 | issue | SO-260724-794 | MAIN | 8 | 24.85 | -198.81 | 16 | 397.63 | March 12, 2026: 8 @ 24.85 |
| July 22, 2026 | issue | SO-260722-691 | MAIN | 9 | 24.85 | -223.67 | 24 | 596.44 | March 12, 2026: 9 @ 24.85 |
| July 21, 2026 | return | RMA | MAIN | 8 | 24.85 | 198.81 | 33 | 820.11 | |
| July 20, 2026 | issue | SO-260720-435 | MAIN | 4 | 24.85 | -99.41 | 25 | 621.29 | March 12, 2026: 4 @ 24.85 |
| July 17, 2026 | issue | SO-260717-871 | MAIN | 2 | 24.85 | -49.70 | 29 | 720.70 | March 12, 2026: 2 @ 24.85 |
| July 11, 2026 | issue | SO-260711-686 | MAIN | 5 | 24.85 | -124.26 | 31 | 770.40 | March 12, 2026: 5 @ 24.85 |
| July 4, 2026 | issue | SO-260704-864 | MAIN | 16 | 24.85 | -397.63 | 36 | 894.66 | March 12, 2026: 16 @ 24.85 |
| June 29, 2026 | issue | SO-260629-118 | MAIN | 5 | 24.85 | -124.26 | 52 | 1,292.29 | March 12, 2026: 5 @ 24.85 |
| June 28, 2026 | issue | SO-260628-704 | MAIN | 14 | 24.85 | -347.92 | 57 | 1,416.55 | March 12, 2026: 14 @ 24.85 |
| June 26, 2026 | issue | SO-260626-919 | MAIN | 6 | 24.85 | -149.11 | 71 | 1,764.47 | March 12, 2026: 6 @ 24.85 |
| June 22, 2026 | issue | SO-260622-214 | MAIN | 4 | 24.85 | -99.41 | 77 | 1,913.58 | March 12, 2026: 4 @ 24.85 |
| June 15, 2026 | issue | SO-260615-130 | MAIN | 6 | 24.85 | -149.11 | 81 | 2,012.99 | March 12, 2026: 6 @ 24.85 |
| May 26, 2026 | issue | SO-260526-281 | MAIN | 8 | 24.85 | -198.81 | 87 | 2,162.10 | March 12, 2026: 8 @ 24.85 |
| May 21, 2026 | issue | SO-260521-294 | MAIN | 3 | 24.85 | -74.56 | 95 | 2,360.91 | March 12, 2026: 3 @ 24.85 |
| May 13, 2026 | issue | SO-260513-293 | MAIN | 1 | 24.85 | -24.85 | 98 | 2,435.47 | March 12, 2026: 1 @ 24.85 |
| May 9, 2026 | issue | SO-260509-602 | MAIN | 15 | 24.85 | -372.78 | 99 | 2,460.32 | March 12, 2026: 15 @ 24.85 |
| May 5, 2026 | issue | SO-260505-341 | MAIN | 3 | 24.85 | -74.56 | 114 | 2,833.09 | March 12, 2026: 3 @ 24.85 |
| April 27, 2026 | issue | SO-260427-250 | MAIN | 22 | 24.85 | -546.74 | 117 | 2,907.65 | March 12, 2026: 22 @ 24.85 |
| April 17, 2026 | issue | SO-260417-473 | MAIN | 17 | 24.85 | -422.48 | 139 | 3,454.39 | March 12, 2026: 17 @ 24.85 |
| March 27, 2026 | issue | SO-260327-195 | MAIN | 4 | 24.85 | -99.41 | 156 | 3,876.87 | March 12, 2026: 4 @ 24.85 |
| March 12, 2026 | receipt | PO-001307 | MAIN | 160 | 24.85 | 3,976.27 | 160 | 3,976.27 | |
| March 4, 2026 | issue | SO-260304-215 | MAIN | 1 | 24.35 | -24.35 | 0 | 0.00 | Dec. 23, 2025: 1 @ 24.35 |
| Feb. 27, 2026 | issue | SO-260227-942 | MAIN | 25 | 24.35 | -608.77 | 1 | 24.35 | Sept. 26, 2025: 24 @ 24.35; Dec. 23, 2025: 1 @ 24.35 |
| Feb. 20, 2026 | issue | SO-260220-113 | MAIN | 14 | 24.35 | -340.91 | 26 | 633.12 | Sept. 26, 2025: 14 @ 24.35 |
| Feb. 4, 2026 | issue | SO-260204-158 | MAIN | 2 | 24.35 | -48.70 | 40 | 974.04 | Sept. 26, 2025: 2 @ 24.35 |
| Jan. 24, 2026 | issue | SO-260124-102 | MAIN | 1 | 24.35 | -24.35 | 42 | 1,022.74 | Sept. 26, 2025: 1 @ 24.35 |
| Jan. 18, 2026 | issue | SO-260118-582 | MAIN | 20 | 24.35 | -487.02 | 43 | 1,047.09 | Sept. 26, 2025: 20 @ 24.35 |
| Jan. 13, 2026 | issue | SO-260113-546 | MAIN | 3 | 24.35 | -73.05 | 63 | 1,534.11 | Sept. 26, 2025: 3 @ 24.35 |
| Jan. 1, 2026 | issue | SO-260101-127 | MAIN | 12 | 24.35 | -292.21 | 66 | 1,607.16 | Sept. 26, 2025: 12 @ 24.35 |
| Dec. 30, 2025 | issue | SO-251230-977 | MAIN | 3 | 24.35 | -73.05 | 78 | 1,899.37 | Sept. 26, 2025: 3 @ 24.35 |
| Dec. 23, 2025 | return | RMA | MAIN | 2 | 24.35 | 48.70 | 81 | 1,972.42 | |
| Dec. 18, 2025 | issue | SO-251218-641 | MAIN | 1 | 24.35 | -24.35 | 79 | 1,923.72 | Sept. 26, 2025: 1 @ 24.35 |
| Dec. 15, 2025 | issue | SO-251215-768 | MAIN | 2 | 24.35 | -48.70 | 80 | 1,948.07 | Sept. 26, 2025: 2 @ 24.35 |
| Dec. 14, 2025 | issue | SO-251214-834 | MAIN | 4 | 24.35 | -97.40 | 82 | 1,996.77 | Sept. 26, 2025: 4 @ 24.35 |
| Dec. 8, 2025 | issue | SO-251208-744 | MAIN | 9 | 24.35 | -219.16 | 86 | 2,094.18 | Sept. 26, 2025: 9 @ 24.35 |
| Dec. 7, 2025 | issue | SO-251207-345 | MAIN | 2 | 24.35 | -48.70 | 95 | 2,313.34 | Sept. 26, 2025: 2 @ 24.35 |
| Dec. 6, 2025 | issue | SO-251206-631 | MAIN | 20 | 24.35 | -487.02 | 97 | 2,362.04 | Sept. 26, 2025: 20 @ 24.35 |
| Nov. 24, 2025 | issue | SO-251124-791 | MAIN | 9 | 24.35 | -219.16 | 117 | 2,849.06 | Sept. 26, 2025: 9 @ 24.35 |
| Nov. 15, 2025 | issue | SO-251115-178 | MAIN | 15 | 24.35 | -365.26 | 126 | 3,068.21 | Sept. 26, 2025: 15 @ 24.35 |
| Nov. 13, 2025 | issue | SO-251113-643 | MAIN | 2 | 24.35 | -48.70 | 141 | 3,433.48 | Sept. 26, 2025: 2 @ 24.35 |
| Nov. 6, 2025 | issue | SO-251106-165 | MAIN | 7 | 24.35 | -170.46 | 143 | 3,482.18 | Sept. 26, 2025: 7 @ 24.35 |
| Nov. 1, 2025 | issue | SO-251101-898 | MAIN | 6 | 24.35 | -146.11 | 150 | 3,652.64 | Sept. 26, 2025: 6 @ 24.35 |
| Oct. 28, 2025 | issue | SO-251028-433 | MAIN | 2 | 24.35 | -48.70 | 156 | 3,798.74 | Sept. 26, 2025: 2 @ 24.35 |
| Oct. 15, 2025 | issue | SO-251015-547 | MAIN | 8 | 23.46 | -187.67 | 158 | 3,847.44 | June 10, 2025: 6 @ 23.16; Sept. 26, 2025: 2 @ 24.35 |
| Oct. 13, 2025 | issue | SO-251013-130 | MAIN | 9 | 23.16 | -208.45 | 166 | 4,035.11 | June 10, 2025: 9 @ 23.16 |
| Oct. 3, 2025 | issue | SO-251003-983 | MAIN | 6 | 23.16 | -138.97 | 175 | 4,243.56 | June 10, 2025: 6 @ 23.16 |