Items / CAB-0023
Cat6 Cable Classic CAB-0023 · Cables & Wires · Conduit & Cable Co
On hand (COIL)39MAIN 25, EAST 14
Value (FIFO)1,650.18avg 42.31
ClassCX / FCV 0.25
Turnover7.6xlast issue 0 days ago
Days of cover68lead 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 | 17.50 / 30.4375 | 0.575 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.44 / 5.517 | 0.806 |
| 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 * 0.806^2 + 0.575^2 * 3.1^2) | 4.5 |
| Reorder point | d * LT + safety stock | 0.575 * 14.0 + 4.5 | 12.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 12.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 210/yr, S = 45.00, h = 20%, price = 41.50 | 47.7 |
| Inventory position | on hand + on order | 39 + 0 | 39 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 41.50 | 48 | 9,105 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 16, 2026 | 39 / 40 | 42.31 | 1,650.18 |
Movement ledger 129 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-806 | MAIN | 8 | 41.74 | -333.93 | 39 | 1,650.18 | Aug. 31, 2026: 7 @ 41.66; Oct. 16, 2026: 1 @ 42.31 |
| Oct. 16, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Oct. 16, 2026 | receipt | PO-001884 | MAIN | 40 | 42.31 | 1,692.49 | 47 | 1,984.11 | |
| Oct. 13, 2026 | issue | SO-261013-133 | MAIN | 3 | 41.66 | -124.98 | 7 | 291.62 | Aug. 31, 2026: 3 @ 41.66 |
| Oct. 5, 2026 | issue | SO-261005-277 | MAIN | 12 | 41.66 | -499.92 | 10 | 416.60 | Aug. 31, 2026: 12 @ 41.66 |
| Oct. 4, 2026 | issue | SO-261004-555 | MAIN | 1 | 41.66 | -41.66 | 22 | 916.52 | Aug. 31, 2026: 1 @ 41.66 |
| Oct. 2, 2026 | issue | SO-261002-882 | MAIN | 3 | 41.66 | -124.98 | 23 | 958.18 | Aug. 31, 2026: 3 @ 41.66 |
| Sept. 29, 2026 | issue | SO-260929-674 | MAIN | 2 | 41.66 | -83.32 | 26 | 1,083.16 | Aug. 31, 2026: 2 @ 41.66 |
| Sept. 29, 2026 | issue | SO-260929-674 | EAST | 13 | 41.68 | -541.83 | 28 | 1,166.48 | June 15, 2026: 1 @ 41.91; Aug. 31, 2026: 12 @ 41.66 |
| Sept. 6, 2026 | issue | SO-260906-873 | MAIN | 2 | 41.91 | -83.82 | 41 | 1,708.31 | June 15, 2026: 2 @ 41.91 |
| Aug. 31, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Aug. 31, 2026 | receipt | PO-001762 | MAIN | 40 | 41.66 | 1,666.40 | 43 | 1,792.13 | |
| Aug. 28, 2026 | issue | SO-260828-985 | EAST | 2 | 41.91 | -83.82 | 3 | 125.73 | June 15, 2026: 2 @ 41.91 |
| Aug. 18, 2026 | issue | SO-260818-350 | EAST | 7 | 41.91 | -293.36 | 5 | 209.54 | June 15, 2026: 7 @ 41.91 |
| Aug. 18, 2026 | issue | SO-260818-350 | MAIN | 12 | 41.91 | -502.90 | 12 | 502.90 | June 15, 2026: 12 @ 41.91 |
| Aug. 3, 2026 | issue | SO-260803-451 | MAIN | 1 | 41.91 | -41.91 | 24 | 1,005.80 | June 15, 2026: 1 @ 41.91 |
| July 29, 2026 | issue | SO-260729-509 | MAIN | 1 | 41.91 | -41.91 | 25 | 1,047.71 | June 15, 2026: 1 @ 41.91 |
| July 28, 2026 | issue | SO-260728-959 | MAIN | 4 | 41.91 | -167.63 | 26 | 1,089.62 | June 15, 2026: 4 @ 41.91 |
| July 8, 2026 | issue | SO-260708-685 | MAIN | 4 | 41.91 | -167.63 | 30 | 1,257.26 | June 15, 2026: 4 @ 41.91 |
| July 1, 2026 | issue | SO-260701-473 | MAIN | 6 | 41.91 | -251.45 | 34 | 1,424.89 | June 15, 2026: 6 @ 41.91 |
| June 15, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| June 15, 2026 | receipt | PO-001573 | MAIN | 40 | 41.91 | 1,676.34 | 40 | 1,676.34 | |
| June 4, 2026 | issue | SO-260604-223 | MAIN | 14 | 39.61 | -554.59 | 0 | 0.00 | April 25, 2026: 14 @ 39.61 |
| May 26, 2026 | issue | SO-260526-951 | MAIN | 4 | 39.61 | -158.46 | 14 | 554.59 | April 25, 2026: 4 @ 39.61 |
| May 16, 2026 | issue | SO-260516-324 | MAIN | 1 | 39.61 | -39.61 | 18 | 713.05 | April 25, 2026: 1 @ 39.61 |
| May 7, 2026 | issue | SO-260507-927 | MAIN | 3 | 39.61 | -118.84 | 19 | 752.66 | April 25, 2026: 3 @ 39.61 |
| May 4, 2026 | issue | SO-260504-973 | MAIN | 9 | 39.61 | -356.52 | 22 | 871.50 | April 25, 2026: 9 @ 39.61 |
| May 3, 2026 | issue | SO-260503-534 | MAIN | 4 | 39.61 | -158.46 | 31 | 1,228.03 | April 25, 2026: 4 @ 39.61 |
| May 2, 2026 | issue | SO-260502-460 | MAIN | 2 | 39.61 | -79.23 | 35 | 1,386.48 | April 25, 2026: 2 @ 39.61 |
| April 27, 2026 | issue | SO-260427-848 | MAIN | 3 | 39.61 | -118.84 | 37 | 1,465.71 | April 25, 2026: 3 @ 39.61 |
| April 25, 2026 | receipt | PO-001435 | MAIN | 40 | 39.61 | 1,584.55 | 40 | 1,584.55 | |
| April 23, 2026 | issue | SO-260423-669 | MAIN | 7 | 39.58 | -277.09 | 0 | 0.00 | Feb. 6, 2026: 7 @ 39.58 |
| April 15, 2026 | issue | SO-260415-915 | MAIN | 4 | 39.58 | -158.34 | 7 | 277.09 | Feb. 6, 2026: 4 @ 39.58 |
| April 13, 2026 | issue | SO-260413-190 | MAIN | 1 | 39.58 | -39.58 | 11 | 435.42 | Feb. 6, 2026: 1 @ 39.58 |
| April 8, 2026 | issue | SO-260408-939 | MAIN | 1 | 39.58 | -39.58 | 12 | 475.01 | Feb. 6, 2026: 1 @ 39.58 |
| March 24, 2026 | issue | SO-260324-347 | MAIN | 5 | 39.58 | -197.92 | 13 | 514.59 | Feb. 6, 2026: 5 @ 39.58 |
| March 7, 2026 | issue | SO-260307-715 | MAIN | 8 | 39.58 | -316.67 | 18 | 712.51 | Feb. 6, 2026: 8 @ 39.58 |
| Feb. 27, 2026 | issue | SO-260227-956 | MAIN | 3 | 39.58 | -118.75 | 26 | 1,029.18 | Feb. 6, 2026: 3 @ 39.58 |
| Feb. 20, 2026 | issue | SO-260220-843 | MAIN | 2 | 39.58 | -79.17 | 29 | 1,147.94 | Feb. 6, 2026: 2 @ 39.58 |
| Feb. 14, 2026 | issue | SO-260214-749 | MAIN | 18 | 40.00 | -720.07 | 31 | 1,227.10 | Nov. 20, 2025: 4 @ 40.42; Dec. 16, 2025: 5 @ 40.42; Feb. 6, 2026: 9 @ 39.58 |
| Feb. 10, 2026 | issue | SO-260210-836 | MAIN | 1 | 40.42 | -40.42 | 49 | 1,947.18 | Nov. 20, 2025: 1 @ 40.42 |
| Feb. 6, 2026 | receipt | PO-001200 | MAIN | 40 | 39.58 | 1,583.36 | 50 | 1,987.60 | |
| Jan. 22, 2026 | issue | SO-260122-565 | MAIN | 3 | 40.42 | -121.27 | 10 | 404.24 | Nov. 20, 2025: 3 @ 40.42 |
| Jan. 19, 2026 | issue | SO-260119-194 | MAIN | 13 | 40.42 | -525.51 | 13 | 525.51 | Nov. 20, 2025: 13 @ 40.42 |
| Jan. 9, 2026 | issue | SO-260109-123 | MAIN | 1 | 40.42 | -40.42 | 26 | 1,051.02 | Nov. 20, 2025: 1 @ 40.42 |
| Jan. 1, 2026 | issue | SO-260101-697 | MAIN | 4 | 40.42 | -161.70 | 27 | 1,091.45 | Nov. 20, 2025: 4 @ 40.42 |
| Dec. 21, 2025 | issue | SO-251221-360 | MAIN | 1 | 40.42 | -40.42 | 31 | 1,253.14 | Nov. 20, 2025: 1 @ 40.42 |
| Dec. 16, 2025 | return | RMA | MAIN | 5 | 40.42 | 202.12 | 32 | 1,293.57 | |
| Dec. 13, 2025 | issue | SO-251213-899 | MAIN | 3 | 40.42 | -121.27 | 27 | 1,091.45 | Nov. 20, 2025: 3 @ 40.42 |
| Dec. 13, 2025 | issue | SO-251213-899 | EAST | 10 | 40.42 | -404.24 | 30 | 1,212.72 | Nov. 20, 2025: 10 @ 40.42 |
| Nov. 20, 2025 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Nov. 20, 2025 | receipt | PO-001011 | MAIN | 40 | 40.42 | 1,616.96 | 40 | 1,616.96 | |
| Nov. 7, 2025 | issue | SO-251107-985 | MAIN | 14 | 38.70 | -541.84 | 0 | 0.00 | Sept. 13, 2025: 14 @ 38.70 |
| Nov. 4, 2025 | issue | SO-251104-811 | MAIN | 1 | 38.70 | -38.70 | 14 | 541.84 | Sept. 13, 2025: 1 @ 38.70 |
| Oct. 21, 2025 | issue | SO-251021-991 | MAIN | 5 | 38.70 | -193.51 | 15 | 580.54 | Sept. 13, 2025: 5 @ 38.70 |
| Oct. 16, 2025 | issue | SO-251016-183 | MAIN | 2 | 38.70 | -77.41 | 20 | 774.06 | Sept. 13, 2025: 2 @ 38.70 |
| Oct. 15, 2025 | issue | SO-251015-705 | MAIN | 1 | 38.70 | -38.70 | 22 | 851.46 | Sept. 13, 2025: 1 @ 38.70 |
| Oct. 14, 2025 | issue | SO-251014-495 | MAIN | 4 | 38.70 | -154.81 | 23 | 890.17 | Sept. 13, 2025: 4 @ 38.70 |
| Oct. 14, 2025 | issue | SO-251014-495 | EAST | 4 | 38.70 | -154.81 | 27 | 1,044.98 | Sept. 13, 2025: 4 @ 38.70 |
| Oct. 12, 2025 | issue | SO-251012-998 | EAST | 2 | 38.70 | -77.41 | 31 | 1,199.79 | Sept. 13, 2025: 2 @ 38.70 |