Items / CON-0029
Cable Tie 200mm Max CON-0029 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)10MAIN 10
Value (FIFO)63.26avg 6.33
ClassCX / FCV 0.23
Turnover6.7xlast issue 0 days ago
Days of cover11lead time 14d
Reorder suggested: 160 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 26.83 / 30.4375 | 0.882 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.27 / 5.517 | 1.136 |
| 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.136^2 + 0.882^2 * 3.1^2) | 6.5 |
| Reorder point | d * LT + safety stock | 0.882 * 14.0 + 6.5 | 18.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 18.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 322/yr, S = 45.00, h = 20%, price = 6.53 | 148.9 |
| Inventory position | on hand + on order | 10 + 0 | 10 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 6.53 | 149 | 2,296 | yes (chosen if cheapest) |
MOQ 120, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 27, 2026 | 10 / 120 | 6.33 | 63.26 |
Movement ledger 104 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-272 | MAIN | 19 | 6.33 | -120.20 | 10 | 63.26 | May 27, 2026: 19 @ 6.33 |
| Oct. 1, 2026 | issue | SO-261001-270 | MAIN | 11 | 6.33 | -69.59 | 29 | 183.46 | May 27, 2026: 11 @ 6.33 |
| Sept. 28, 2026 | issue | SO-260928-410 | MAIN | 1 | 6.33 | -6.33 | 40 | 253.05 | May 27, 2026: 1 @ 6.33 |
| Sept. 27, 2026 | issue | SO-260927-815 | MAIN | 1 | 6.33 | -6.33 | 41 | 259.38 | May 27, 2026: 1 @ 6.33 |
| Sept. 15, 2026 | issue | SO-260915-368 | MAIN | 2 | 6.33 | -12.65 | 42 | 265.70 | May 27, 2026: 2 @ 6.33 |
| Sept. 11, 2026 | issue | SO-260911-701 | MAIN | 15 | 6.33 | -94.89 | 44 | 278.36 | May 27, 2026: 15 @ 6.33 |
| Sept. 5, 2026 | issue | SO-260905-289 | MAIN | 3 | 6.33 | -18.98 | 59 | 373.25 | May 27, 2026: 3 @ 6.33 |
| Aug. 30, 2026 | issue | SO-260830-968 | MAIN | 1 | 6.33 | -6.33 | 62 | 392.23 | May 27, 2026: 1 @ 6.33 |
| Aug. 20, 2026 | issue | SO-260820-881 | MAIN | 5 | 6.33 | -31.63 | 63 | 398.56 | May 27, 2026: 5 @ 6.33 |
| Aug. 15, 2026 | issue | SO-260815-829 | MAIN | 10 | 6.33 | -63.26 | 68 | 430.19 | May 27, 2026: 10 @ 6.33 |
| July 31, 2026 | issue | SO-260731-808 | MAIN | 14 | 6.33 | -88.57 | 78 | 493.45 | May 27, 2026: 14 @ 6.33 |
| July 13, 2026 | issue | SO-260713-106 | MAIN | 1 | 6.33 | -6.33 | 92 | 582.02 | May 27, 2026: 1 @ 6.33 |
| July 7, 2026 | issue | SO-260707-746 | MAIN | 6 | 6.33 | -37.96 | 93 | 588.35 | May 27, 2026: 6 @ 6.33 |
| June 26, 2026 | issue | SO-260626-127 | MAIN | 23 | 6.32 | -145.33 | 99 | 626.30 | Jan. 30, 2026: 1 @ 6.36; Feb. 5, 2026: 1 @ 6.11; May 27, 2026: 21 @ 6.33 |
| June 11, 2026 | issue | SO-260611-119 | MAIN | 2 | 6.36 | -12.72 | 122 | 771.63 | Jan. 30, 2026: 2 @ 6.36 |
| June 6, 2026 | issue | SO-260606-421 | MAIN | 4 | 6.36 | -25.45 | 124 | 784.35 | Jan. 30, 2026: 4 @ 6.36 |
| May 28, 2026 | issue | SO-260528-722 | MAIN | 10 | 6.36 | -63.62 | 128 | 809.80 | Jan. 30, 2026: 10 @ 6.36 |
| May 27, 2026 | issue | SO-260527-263 | MAIN | 1 | 6.36 | -6.36 | 138 | 873.42 | Jan. 30, 2026: 1 @ 6.36 |
| May 27, 2026 | receipt | PO-001526 | MAIN | 120 | 6.33 | 759.16 | 139 | 879.78 | |
| May 11, 2026 | issue | SO-260511-861 | MAIN | 22 | 6.36 | -139.96 | 19 | 120.63 | Jan. 30, 2026: 22 @ 6.36 |
| April 28, 2026 | issue | SO-260428-839 | MAIN | 6 | 6.36 | -38.17 | 41 | 260.59 | Jan. 30, 2026: 6 @ 6.36 |
| April 14, 2026 | issue | SO-260414-507 | MAIN | 4 | 6.36 | -25.45 | 47 | 298.76 | Jan. 30, 2026: 4 @ 6.36 |
| April 7, 2026 | issue | SO-260407-724 | MAIN | 24 | 6.36 | -152.69 | 51 | 324.21 | Jan. 30, 2026: 24 @ 6.36 |
| March 30, 2026 | issue | SO-260330-997 | MAIN | 1 | 6.36 | -6.36 | 75 | 476.90 | Jan. 30, 2026: 1 @ 6.36 |
| March 19, 2026 | issue | SO-260319-863 | MAIN | 10 | 6.36 | -63.62 | 76 | 483.26 | Jan. 30, 2026: 10 @ 6.36 |
| March 18, 2026 | issue | SO-260318-321 | MAIN | 13 | 6.36 | -82.71 | 86 | 546.88 | Jan. 30, 2026: 13 @ 6.36 |
| Feb. 22, 2026 | issue | SO-260222-785 | MAIN | 1 | 6.36 | -6.36 | 99 | 629.59 | Jan. 30, 2026: 1 @ 6.36 |
| Feb. 10, 2026 | issue | SO-260210-574 | MAIN | 9 | 6.36 | -57.26 | 100 | 635.95 | Jan. 30, 2026: 9 @ 6.36 |
| Feb. 7, 2026 | issue | SO-260207-448 | MAIN | 12 | 6.36 | -76.34 | 109 | 693.21 | Jan. 30, 2026: 12 @ 6.36 |
| Feb. 5, 2026 | return | RMA | MAIN | 1 | 6.11 | 6.11 | 121 | 769.55 | |
| Jan. 30, 2026 | receipt | PO-001186 | MAIN | 120 | 6.36 | 763.44 | 120 | 763.44 | |
| Jan. 19, 2026 | issue | SO-260119-396 | MAIN | 3 | 6.11 | -18.34 | 0 | 0.00 | Sept. 30, 2025: 2 @ 6.11; Dec. 7, 2025: 1 @ 6.11 |
| Jan. 18, 2026 | issue | SO-260118-626 | MAIN | 11 | 6.11 | -67.24 | 3 | 18.34 | Sept. 30, 2025: 11 @ 6.11 |
| Jan. 17, 2026 | issue | SO-260117-519 | MAIN | 3 | 6.11 | -18.34 | 14 | 85.57 | Sept. 30, 2025: 3 @ 6.11 |
| Jan. 12, 2026 | issue | SO-260112-652 | MAIN | 12 | 6.11 | -73.35 | 17 | 103.91 | Sept. 30, 2025: 12 @ 6.11 |
| Dec. 27, 2025 | issue | SO-251227-559 | MAIN | 1 | 6.11 | -6.11 | 29 | 177.26 | Sept. 30, 2025: 1 @ 6.11 |
| Dec. 26, 2025 | issue | SO-251226-333 | MAIN | 13 | 6.11 | -79.46 | 30 | 183.37 | Sept. 30, 2025: 13 @ 6.11 |
| Dec. 7, 2025 | return | RMA | MAIN | 1 | 6.11 | 6.11 | 43 | 262.83 | |
| Dec. 7, 2025 | issue | SO-251207-581 | MAIN | 20 | 6.11 | -122.25 | 42 | 256.72 | Sept. 30, 2025: 20 @ 6.11 |
| Nov. 30, 2025 | issue | SO-251130-523 | MAIN | 2 | 6.11 | -12.22 | 62 | 378.96 | Sept. 30, 2025: 2 @ 6.11 |
| Nov. 25, 2025 | issue | SO-251125-189 | MAIN | 1 | 6.11 | -6.11 | 64 | 391.19 | Sept. 30, 2025: 1 @ 6.11 |
| Nov. 22, 2025 | issue | SO-251122-434 | MAIN | 6 | 6.11 | -36.67 | 65 | 397.30 | Sept. 30, 2025: 6 @ 6.11 |
| Nov. 21, 2025 | issue | SO-251121-852 | MAIN | 4 | 6.11 | -24.45 | 71 | 433.97 | Sept. 30, 2025: 4 @ 6.11 |
| Nov. 15, 2025 | issue | SO-251115-494 | MAIN | 2 | 6.11 | -12.22 | 75 | 458.42 | Sept. 30, 2025: 2 @ 6.11 |
| Nov. 12, 2025 | issue | SO-251112-901 | MAIN | 8 | 6.11 | -48.90 | 77 | 470.65 | Sept. 30, 2025: 8 @ 6.11 |
| Nov. 5, 2025 | adjustment | Cycle count | MAIN | -1 | 6.11 | -6.11 | 85 | 519.55 | Sept. 30, 2025: 1 @ 6.11 |
| Oct. 29, 2025 | issue | SO-251029-187 | MAIN | 1 | 6.11 | -6.11 | 86 | 525.66 | Sept. 30, 2025: 1 @ 6.11 |
| Oct. 15, 2025 | issue | SO-251015-535 | MAIN | 2 | 6.11 | -12.22 | 87 | 531.77 | Sept. 30, 2025: 2 @ 6.11 |
| Oct. 14, 2025 | issue | SO-251014-917 | MAIN | 14 | 6.11 | -85.57 | 89 | 543.99 | Sept. 30, 2025: 14 @ 6.11 |
| Oct. 12, 2025 | issue | SO-251012-792 | MAIN | 8 | 6.11 | -48.90 | 103 | 629.57 | Sept. 30, 2025: 8 @ 6.11 |
| Oct. 11, 2025 | issue | SO-251011-850 | MAIN | 5 | 6.11 | -30.56 | 111 | 678.47 | Sept. 30, 2025: 5 @ 6.11 |
| Oct. 3, 2025 | issue | SO-251003-979 | MAIN | 7 | 6.20 | -43.37 | 116 | 709.03 | June 16, 2025: 1 @ 6.31; Aug. 28, 2025: 2 @ 6.31; Sept. 30, 2025: 4 @ 6.11 |
| Sept. 30, 2025 | receipt | PO-000888 | MAIN | 120 | 6.11 | 733.48 | 123 | 752.40 | |
| Sept. 13, 2025 | issue | SO-250913-232 | MAIN | 22 | 6.31 | -138.76 | 3 | 18.92 | June 16, 2025: 22 @ 6.31 |
| Sept. 6, 2025 | issue | SO-250906-474 | MAIN | 9 | 6.31 | -56.77 | 25 | 157.68 | June 16, 2025: 9 @ 6.31 |
| Aug. 28, 2025 | return | RMA | MAIN | 2 | 6.31 | 12.61 | 34 | 214.45 | |
| Aug. 24, 2025 | issue | SO-250824-517 | MAIN | 8 | 6.31 | -50.46 | 32 | 201.84 | June 16, 2025: 8 @ 6.31 |
| Aug. 22, 2025 | issue | SO-250822-624 | MAIN | 5 | 6.31 | -31.54 | 40 | 252.30 | June 16, 2025: 5 @ 6.31 |
| Aug. 13, 2025 | issue | SO-250813-309 | MAIN | 3 | 6.31 | -18.92 | 45 | 283.83 | June 16, 2025: 3 @ 6.31 |
| Aug. 11, 2025 | issue | SO-250811-745 | MAIN | 2 | 6.31 | -12.61 | 48 | 302.76 | June 16, 2025: 2 @ 6.31 |
| Aug. 6, 2025 | issue | SO-250806-911 | MAIN | 8 | 6.31 | -50.46 | 50 | 315.37 | June 16, 2025: 8 @ 6.31 |
| Aug. 5, 2025 | issue | SO-250805-793 | MAIN | 2 | 6.31 | -12.61 | 58 | 365.83 | June 16, 2025: 2 @ 6.31 |
| July 21, 2025 | issue | SO-250721-388 | MAIN | 1 | 6.31 | -6.31 | 60 | 378.44 | June 16, 2025: 1 @ 6.31 |
| July 7, 2025 | issue | SO-250707-907 | MAIN | 24 | 6.31 | -151.38 | 61 | 384.75 | June 16, 2025: 24 @ 6.31 |
| July 5, 2025 | issue | SO-250705-547 | MAIN | 4 | 6.31 | -25.23 | 85 | 536.13 | June 16, 2025: 4 @ 6.31 |
| July 2, 2025 | issue | SO-250702-752 | MAIN | 1 | 6.31 | -6.31 | 89 | 561.36 | June 16, 2025: 1 @ 6.31 |
| June 29, 2025 | issue | SO-250629-931 | MAIN | 30 | 6.31 | -189.22 | 90 | 567.67 | June 16, 2025: 30 @ 6.31 |
| June 16, 2025 | receipt | PO-000641 | MAIN | 120 | 6.31 | 756.89 | 120 | 756.89 | |
| June 5, 2025 | issue | SO-250605-734 | MAIN | 14 | 5.99 | -83.84 | 0 | 0.00 | Jan. 24, 2025: 14 @ 5.99 |
| May 27, 2025 | issue | SO-250527-766 | MAIN | 13 | 5.99 | -77.85 | 14 | 83.84 | Jan. 24, 2025: 13 @ 5.99 |
| May 19, 2025 | issue | SO-250519-346 | MAIN | 22 | 5.99 | -131.74 | 27 | 161.68 | Jan. 24, 2025: 22 @ 5.99 |
| May 6, 2025 | issue | SO-250506-446 | MAIN | 1 | 5.99 | -5.99 | 49 | 293.43 | Jan. 24, 2025: 1 @ 5.99 |
| April 18, 2025 | issue | SO-250418-437 | MAIN | 4 | 5.99 | -23.95 | 50 | 299.42 | Jan. 24, 2025: 4 @ 5.99 |
| April 15, 2025 | issue | SO-250415-660 | MAIN | 6 | 5.99 | -35.93 | 54 | 323.37 | Jan. 24, 2025: 6 @ 5.99 |
| April 6, 2025 | issue | SO-250406-395 | MAIN | 6 | 5.99 | -35.93 | 60 | 359.30 | Jan. 24, 2025: 6 @ 5.99 |
| April 5, 2025 | issue | SO-250405-321 | MAIN | 13 | 5.99 | -77.85 | 66 | 395.23 | Jan. 24, 2025: 13 @ 5.99 |
| March 15, 2025 | issue | SO-250315-253 | MAIN | 3 | 5.99 | -17.96 | 79 | 473.08 | Jan. 24, 2025: 3 @ 5.99 |
| March 14, 2025 | issue | SO-250314-531 | MAIN | 4 | 5.99 | -23.95 | 82 | 491.04 | Jan. 24, 2025: 4 @ 5.99 |
| March 12, 2025 | issue | SO-250312-990 | MAIN | 13 | 5.99 | -77.85 | 86 | 514.99 | Jan. 24, 2025: 13 @ 5.99 |
| Feb. 24, 2025 | issue | SO-250224-453 | MAIN | 2 | 5.99 | -11.98 | 99 | 592.84 | Jan. 24, 2025: 2 @ 5.99 |
| Feb. 14, 2025 | issue | SO-250214-766 | MAIN | 5 | 5.99 | -29.94 | 101 | 604.82 | Jan. 24, 2025: 5 @ 5.99 |
| Feb. 14, 2025 | issue | SO-250214-766 | EAST | 1 | 5.99 | -5.99 | 106 | 634.76 | Jan. 24, 2025: 1 @ 5.99 |
| Feb. 13, 2025 | issue | SO-250213-177 | MAIN | 7 | 5.99 | -41.92 | 107 | 640.75 | Jan. 24, 2025: 7 @ 5.99 |
| Feb. 11, 2025 | issue | SO-250211-493 | MAIN | 5 | 5.99 | -29.94 | 114 | 682.67 | Jan. 24, 2025: 5 @ 5.99 |
| Feb. 5, 2025 | issue | SO-250205-177 | MAIN | 1 | 5.99 | -5.99 | 119 | 712.61 | Jan. 24, 2025: 1 @ 5.99 |
| Feb. 3, 2025 | issue | SO-250203-248 | MAIN | 1 | 6.20 | -6.20 | 120 | 718.60 | Oct. 1, 2024: 1 @ 6.20 |
| Jan. 24, 2025 | receipt | PO-000212 | MAIN | 120 | 5.99 | 718.60 | 121 | 724.80 | |
| Jan. 16, 2025 | issue | SO-250116-608 | EAST | 1 | 6.20 | -6.20 | 1 | 6.20 | Oct. 1, 2024: 1 @ 6.20 |
| Jan. 16, 2025 | issue | SO-250116-608 | MAIN | 10 | 6.20 | -62.04 | 2 | 12.41 | Oct. 1, 2024: 10 @ 6.20 |
| Jan. 10, 2025 | issue | SO-250110-397 | MAIN | 16 | 6.20 | -99.26 | 12 | 74.44 | Oct. 1, 2024: 16 @ 6.20 |
| Dec. 17, 2024 | issue | SO-241217-680 | MAIN | 8 | 6.20 | -49.63 | 28 | 173.70 | Oct. 1, 2024: 8 @ 6.20 |
| Dec. 5, 2024 | issue | SO-241205-913 | EAST | 30 | 6.20 | -186.10 | 36 | 223.33 | Oct. 1, 2024: 30 @ 6.20 |
| Nov. 27, 2024 | issue | SO-241127-857 | MAIN | 2 | 6.20 | -12.41 | 66 | 409.43 | Oct. 1, 2024: 2 @ 6.20 |
| Nov. 16, 2024 | issue | SO-241116-664 | MAIN | 10 | 6.20 | -62.04 | 68 | 421.84 | Oct. 1, 2024: 10 @ 6.20 |
| Nov. 8, 2024 | issue | SO-241108-786 | MAIN | 9 | 6.20 | -55.83 | 78 | 483.87 | Oct. 1, 2024: 9 @ 6.20 |
| Nov. 7, 2024 | issue | SO-241107-191 | EAST | 1 | 6.20 | -6.20 | 87 | 539.70 | Oct. 1, 2024: 1 @ 6.20 |
| Nov. 5, 2024 | issue | SO-241105-671 | MAIN | 1 | 6.20 | -6.20 | 88 | 545.91 | Oct. 1, 2024: 1 @ 6.20 |
| Nov. 2, 2024 | issue | SO-241102-360 | MAIN | 3 | 6.20 | -18.61 | 89 | 552.11 | Oct. 1, 2024: 3 @ 6.20 |
| Oct. 28, 2024 | issue | SO-241028-937 | MAIN | 1 | 6.20 | -6.20 | 92 | 570.72 | Oct. 1, 2024: 1 @ 6.20 |
| Oct. 22, 2024 | issue | SO-241022-223 | MAIN | 1 | 6.20 | -6.20 | 93 | 576.93 | Oct. 1, 2024: 1 @ 6.20 |
| Oct. 9, 2024 | issue | SO-241009-489 | MAIN | 19 | 6.20 | -117.87 | 94 | 583.13 | Oct. 1, 2024: 19 @ 6.20 |
| Oct. 3, 2024 | issue | SO-241003-143 | MAIN | 7 | 6.20 | -43.42 | 113 | 701.00 | Oct. 1, 2024: 7 @ 6.20 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 33 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 120 | 6.20 | 744.42 | 120 | 744.42 | |