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
| 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 |
| Sept. 26, 2025 | receipt | PO-000874 | MAIN | 160 | 24.35 | 3,896.14 | 181 | 4,382.53 | |
| Sept. 10, 2025 | issue | SO-250910-650 | MAIN | 4 | 23.16 | -92.65 | 21 | 486.39 | June 10, 2025: 4 @ 23.16 |
| Sept. 10, 2025 | issue | SO-250910-650 | EAST | 22 | 23.16 | -509.55 | 25 | 579.03 | June 10, 2025: 22 @ 23.16 |
| Sept. 8, 2025 | issue | SO-250908-841 | MAIN | 7 | 23.16 | -162.13 | 47 | 1,088.58 | June 10, 2025: 7 @ 23.16 |
| Aug. 31, 2025 | issue | SO-250831-975 | MAIN | 13 | 23.16 | -301.10 | 54 | 1,250.71 | June 10, 2025: 13 @ 23.16 |
| Aug. 18, 2025 | issue | SO-250818-261 | MAIN | 13 | 23.16 | -301.10 | 67 | 1,551.81 | June 10, 2025: 13 @ 23.16 |
| Aug. 8, 2025 | issue | SO-250808-388 | EAST | 3 | 23.16 | -69.48 | 80 | 1,852.90 | June 10, 2025: 3 @ 23.16 |
| Aug. 2, 2025 | issue | SO-250802-622 | MAIN | 20 | 23.16 | -463.23 | 83 | 1,922.39 | June 10, 2025: 20 @ 23.16 |
| July 19, 2025 | issue | SO-250719-669 | EAST | 16 | 23.16 | -370.58 | 103 | 2,385.61 | June 10, 2025: 16 @ 23.16 |
| July 14, 2025 | issue | SO-250714-584 | MAIN | 18 | 23.16 | -416.90 | 119 | 2,756.19 | June 10, 2025: 18 @ 23.16 |
| July 13, 2025 | issue | SO-250713-339 | EAST | 10 | 23.16 | -231.61 | 137 | 3,173.10 | June 10, 2025: 10 @ 23.16 |
| July 8, 2025 | issue | SO-250708-698 | MAIN | 3 | 23.16 | -69.48 | 147 | 3,404.71 | June 10, 2025: 3 @ 23.16 |
| July 4, 2025 | issue | SO-250704-917 | EAST | 2 | 23.16 | -46.32 | 150 | 3,474.20 | June 10, 2025: 2 @ 23.16 |
| June 30, 2025 | issue | SO-250630-614 | MAIN | 12 | 23.05 | -276.56 | 152 | 3,520.52 | Jan. 9, 2025: 4 @ 22.82; June 10, 2025: 8 @ 23.16 |
| June 23, 2025 | issue | SO-250623-253 | MAIN | 10 | 22.82 | -228.18 | 164 | 3,797.08 | Jan. 9, 2025: 10 @ 22.82 |
| June 10, 2025 | transfer | TRF | MAIN → EAST | 53 | warehouse transfer, no cost effect | ||||
| June 10, 2025 | receipt | PO-000623 | MAIN | 160 | 23.16 | 3,705.81 | 174 | 4,025.26 | |
| June 5, 2025 | issue | SO-250605-370 | MAIN | 6 | 22.82 | -136.91 | 14 | 319.46 | Jan. 9, 2025: 6 @ 22.82 |
| May 27, 2025 | issue | SO-250527-686 | MAIN | 14 | 22.82 | -319.46 | 20 | 456.37 | Jan. 9, 2025: 14 @ 22.82 |
| May 8, 2025 | issue | SO-250508-213 | MAIN | 11 | 22.82 | -251.00 | 34 | 775.82 | Jan. 9, 2025: 11 @ 22.82 |
| May 1, 2025 | issue | SO-250501-341 | MAIN | 12 | 22.82 | -273.82 | 45 | 1,026.82 | Jan. 9, 2025: 12 @ 22.82 |
| April 23, 2025 | issue | SO-250423-710 | MAIN | 7 | 22.82 | -159.73 | 57 | 1,300.64 | Jan. 9, 2025: 7 @ 22.82 |
| April 21, 2025 | issue | SO-250421-946 | MAIN | 9 | 22.82 | -205.36 | 64 | 1,460.37 | Jan. 9, 2025: 9 @ 22.82 |
| April 2, 2025 | issue | SO-250402-450 | MAIN | 12 | 22.82 | -273.82 | 73 | 1,665.74 | Jan. 9, 2025: 12 @ 22.82 |
| March 30, 2025 | issue | SO-250330-792 | MAIN | 13 | 22.82 | -296.64 | 85 | 1,939.56 | Jan. 9, 2025: 13 @ 22.82 |
| March 7, 2025 | issue | SO-250307-308 | MAIN | 1 | 22.82 | -22.82 | 98 | 2,236.19 | Jan. 9, 2025: 1 @ 22.82 |
| March 6, 2025 | issue | SO-250306-882 | MAIN | 4 | 22.82 | -91.27 | 99 | 2,259.01 | Jan. 9, 2025: 4 @ 22.82 |
| March 5, 2025 | issue | SO-250305-380 | MAIN | 11 | 22.82 | -251.00 | 103 | 2,350.28 | Jan. 9, 2025: 11 @ 22.82 |
| March 3, 2025 | issue | SO-250303-441 | MAIN | 4 | 22.82 | -91.27 | 114 | 2,601.29 | Jan. 9, 2025: 4 @ 22.82 |
| Feb. 22, 2025 | issue | SO-250222-680 | MAIN | 5 | 22.82 | -114.09 | 118 | 2,692.56 | Jan. 9, 2025: 5 @ 22.82 |
| Feb. 1, 2025 | issue | SO-250201-436 | MAIN | 22 | 22.82 | -502.00 | 123 | 2,806.65 | Jan. 9, 2025: 22 @ 22.82 |
| Jan. 22, 2025 | issue | SO-250122-350 | MAIN | 2 | 22.82 | -45.64 | 145 | 3,308.65 | Jan. 9, 2025: 2 @ 22.82 |
| Jan. 10, 2025 | issue | SO-250110-977 | MAIN | 29 | 23.37 | -677.70 | 147 | 3,354.29 | Oct. 1, 2024: 16 @ 23.82; Jan. 9, 2025: 13 @ 22.82 |
| Jan. 9, 2025 | receipt | PO-000176 | MAIN | 160 | 22.82 | 3,650.93 | 176 | 4,031.99 | |
| Jan. 4, 2025 | issue | SO-250104-677 | MAIN | 3 | 23.82 | -71.45 | 16 | 381.06 | Oct. 1, 2024: 3 @ 23.82 |
| Dec. 27, 2024 | issue | SO-241227-455 | MAIN | 10 | 23.82 | -238.16 | 19 | 452.51 | Oct. 1, 2024: 10 @ 23.82 |
| Dec. 23, 2024 | issue | SO-241223-574 | MAIN | 15 | 23.82 | -357.25 | 29 | 690.68 | Oct. 1, 2024: 15 @ 23.82 |
| Dec. 21, 2024 | issue | SO-241221-690 | MAIN | 5 | 23.82 | -119.08 | 44 | 1,047.93 | Oct. 1, 2024: 5 @ 23.82 |
| Dec. 20, 2024 | issue | SO-241220-984 | MAIN | 2 | 23.82 | -47.63 | 49 | 1,167.01 | Oct. 1, 2024: 2 @ 23.82 |
| Dec. 4, 2024 | issue | SO-241204-771 | MAIN | 22 | 23.82 | -523.96 | 51 | 1,214.64 | Oct. 1, 2024: 22 @ 23.82 |
| Nov. 17, 2024 | issue | SO-241117-822 | MAIN | 32 | 23.82 | -762.13 | 73 | 1,738.60 | Oct. 1, 2024: 32 @ 23.82 |
| Nov. 13, 2024 | issue | SO-241113-523 | MAIN | 3 | 23.82 | -71.45 | 105 | 2,500.73 | Oct. 1, 2024: 3 @ 23.82 |
| Oct. 30, 2024 | issue | SO-241030-242 | MAIN | 1 | 23.82 | -23.82 | 108 | 2,572.18 | Oct. 1, 2024: 1 @ 23.82 |
| Oct. 29, 2024 | issue | SO-241029-411 | MAIN | 3 | 23.82 | -71.45 | 109 | 2,596.00 | Oct. 1, 2024: 3 @ 23.82 |
| Oct. 27, 2024 | issue | SO-241027-820 | MAIN | 17 | 23.82 | -404.88 | 112 | 2,667.45 | Oct. 1, 2024: 17 @ 23.82 |
| Oct. 14, 2024 | issue | SO-241014-361 | MAIN | 21 | 23.82 | -500.15 | 129 | 3,072.33 | Oct. 1, 2024: 21 @ 23.82 |
| Oct. 4, 2024 | issue | SO-241004-784 | MAIN | 1 | 23.82 | -23.82 | 150 | 3,572.48 | Oct. 1, 2024: 1 @ 23.82 |
| Oct. 3, 2024 | issue | SO-241003-123 | MAIN | 9 | 23.82 | -214.35 | 151 | 3,596.29 | Oct. 1, 2024: 9 @ 23.82 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 160 | 23.82 | 3,810.64 | 160 | 3,810.64 | |