Items / CAB-0014
Cat6 Cable Nova CAB-0014 · Cables & Wires · Conduit & Cable Co
On hand (COIL)23MAIN 14, EAST 9
Value (FIFO)6,958.27avg 302.53
ClassAX / FCV 0.23
Turnover7.5xlast issue 0 days ago
Days of cover41lead 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.08 / 30.4375 | 0.561 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.90 / 5.517 | 0.708 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(14.0 * 0.708^2 + 0.561^2 * 3.1^2) | 6.5 |
| Reorder point | d * LT + safety stock | 0.561 * 14.0 + 6.5 | 14.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 14.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 205/yr, S = 45.00, h = 20%, price = 282.87 | 160.0 |
| Inventory position | on hand + on order | 23 + 0 | 23 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 307.47 | 17 | 64,053 | yes |
| 80 | 295.17 | 80 | 62,945 | yes |
| 160 | 282.87 | 160 | 62,533 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 26, 2026 | 23 / 40 | 302.53 | 6,958.27 |
Movement ledger 125 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-905 | EAST | 1 | 302.53 | -302.53 | 23 | 6,958.27 | Sept. 26, 2026: 1 @ 302.53 |
| Oct. 15, 2026 | issue | SO-261015-523 | EAST | 3 | 302.53 | -907.60 | 24 | 7,260.80 | Sept. 26, 2026: 3 @ 302.53 |
| Oct. 8, 2026 | issue | SO-261008-235 | MAIN | 3 | 302.53 | -907.60 | 27 | 8,168.40 | Sept. 26, 2026: 3 @ 302.53 |
| Oct. 7, 2026 | issue | SO-261007-854 | EAST | 1 | 302.53 | -302.53 | 30 | 9,076.00 | Sept. 26, 2026: 1 @ 302.53 |
| Oct. 3, 2026 | issue | SO-261003-607 | MAIN | 7 | 302.53 | -2,117.73 | 31 | 9,378.54 | Sept. 26, 2026: 7 @ 302.53 |
| Oct. 1, 2026 | issue | SO-261001-111 | MAIN | 1 | 302.53 | -302.53 | 38 | 11,496.27 | Sept. 26, 2026: 1 @ 302.53 |
| Sept. 28, 2026 | issue | SO-260928-783 | MAIN | 3 | 300.55 | -901.64 | 39 | 11,798.80 | July 29, 2026: 2 @ 299.56; Sept. 26, 2026: 1 @ 302.53 |
| Sept. 26, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Sept. 26, 2026 | receipt | PO-001830 | MAIN | 40 | 302.53 | 12,101.34 | 42 | 12,700.45 | |
| Sept. 20, 2026 | issue | SO-260920-489 | MAIN | 7 | 299.56 | -2,096.89 | 2 | 599.11 | July 29, 2026: 7 @ 299.56 |
| Sept. 10, 2026 | issue | SO-260910-674 | MAIN | 2 | 299.56 | -599.11 | 9 | 2,696.00 | July 29, 2026: 2 @ 299.56 |
| Sept. 9, 2026 | issue | SO-260909-379 | MAIN | 8 | 299.56 | -2,396.44 | 11 | 3,295.11 | July 29, 2026: 8 @ 299.56 |
| Sept. 9, 2026 | issue | SO-260909-379 | EAST | 1 | 299.56 | -299.56 | 19 | 5,691.55 | July 29, 2026: 1 @ 299.56 |
| Aug. 31, 2026 | issue | SO-260831-927 | EAST | 8 | 299.56 | -2,396.44 | 20 | 5,991.11 | July 29, 2026: 8 @ 299.56 |
| Aug. 8, 2026 | issue | SO-260808-456 | MAIN | 4 | 299.56 | -1,198.22 | 28 | 8,387.55 | July 29, 2026: 4 @ 299.56 |
| Aug. 3, 2026 | issue | SO-260803-268 | MAIN | 2 | 299.56 | -599.11 | 32 | 9,585.77 | July 29, 2026: 2 @ 299.56 |
| Aug. 1, 2026 | issue | SO-260801-676 | MAIN | 6 | 299.56 | -1,797.33 | 34 | 10,184.88 | July 29, 2026: 6 @ 299.56 |
| July 29, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| July 29, 2026 | receipt | PO-001683 | MAIN | 40 | 299.56 | 11,982.21 | 40 | 11,982.21 | |
| July 22, 2026 | issue | SO-260722-730 | MAIN | 2 | 293.23 | -586.45 | 0 | 0.00 | May 3, 2026: 2 @ 293.23 |
| July 19, 2026 | issue | SO-260719-857 | MAIN | 15 | 293.23 | -4,398.40 | 2 | 586.45 | May 3, 2026: 15 @ 293.23 |
| June 22, 2026 | issue | SO-260622-811 | MAIN | 3 | 293.23 | -879.68 | 17 | 4,984.86 | May 3, 2026: 3 @ 293.23 |
| June 21, 2026 | issue | SO-260621-725 | MAIN | 3 | 293.23 | -879.68 | 20 | 5,864.54 | May 3, 2026: 3 @ 293.23 |
| June 5, 2026 | issue | SO-260605-910 | MAIN | 1 | 293.23 | -293.23 | 23 | 6,744.22 | May 3, 2026: 1 @ 293.23 |
| June 3, 2026 | issue | SO-260603-227 | MAIN | 4 | 293.23 | -1,172.91 | 24 | 7,037.45 | May 3, 2026: 4 @ 293.23 |
| June 1, 2026 | issue | SO-260601-535 | MAIN | 3 | 293.23 | -879.68 | 28 | 8,210.35 | May 3, 2026: 3 @ 293.23 |
| May 17, 2026 | issue | SO-260517-281 | MAIN | 2 | 293.23 | -586.45 | 31 | 9,090.03 | May 3, 2026: 2 @ 293.23 |
| May 13, 2026 | issue | SO-260513-968 | MAIN | 12 | 295.51 | -3,546.13 | 33 | 9,676.49 | Feb. 13, 2026: 3 @ 298.71; April 12, 2026: 2 @ 298.71; May 3, 2026: 7 @ 293.23 |
| May 3, 2026 | receipt | PO-001460 | MAIN | 40 | 293.23 | 11,729.08 | 45 | 13,222.62 | |
| May 2, 2026 | issue | SO-260502-575 | MAIN | 1 | 298.71 | -298.71 | 5 | 1,493.54 | Feb. 13, 2026: 1 @ 298.71 |
| April 30, 2026 | issue | SO-260430-905 | MAIN | 4 | 298.71 | -1,194.84 | 6 | 1,792.25 | Feb. 13, 2026: 4 @ 298.71 |
| April 22, 2026 | issue | SO-260422-792 | MAIN | 4 | 298.71 | -1,194.84 | 10 | 2,987.09 | Feb. 13, 2026: 4 @ 298.71 |
| April 19, 2026 | issue | SO-260419-787 | MAIN | 2 | 298.71 | -597.42 | 14 | 4,181.93 | Feb. 13, 2026: 2 @ 298.71 |
| April 18, 2026 | issue | SO-260418-949 | MAIN | 1 | 298.71 | -298.71 | 16 | 4,779.34 | Feb. 13, 2026: 1 @ 298.71 |
| April 12, 2026 | return | RMA | MAIN | 2 | 298.71 | 597.42 | 17 | 5,078.05 | |
| April 6, 2026 | issue | SO-260406-743 | MAIN | 5 | 298.71 | -1,493.54 | 15 | 4,480.64 | Feb. 13, 2026: 5 @ 298.71 |
| March 31, 2026 | issue | SO-260331-906 | MAIN | 4 | 298.71 | -1,194.84 | 20 | 5,974.18 | Feb. 13, 2026: 4 @ 298.71 |
| March 27, 2026 | issue | SO-260327-514 | MAIN | 4 | 298.71 | -1,194.84 | 24 | 7,169.02 | Feb. 13, 2026: 4 @ 298.71 |
| March 25, 2026 | issue | SO-260325-214 | MAIN | 2 | 298.71 | -597.42 | 28 | 8,363.85 | Feb. 13, 2026: 2 @ 298.71 |
| March 21, 2026 | issue | SO-260321-283 | MAIN | 3 | 298.71 | -896.13 | 30 | 8,961.27 | Feb. 13, 2026: 3 @ 298.71 |
| March 15, 2026 | issue | SO-260315-905 | MAIN | 3 | 298.71 | -896.13 | 33 | 9,857.40 | Feb. 13, 2026: 3 @ 298.71 |
| March 8, 2026 | issue | SO-260308-161 | MAIN | 4 | 298.71 | -1,194.84 | 36 | 10,753.52 | Feb. 13, 2026: 4 @ 298.71 |
| Feb. 13, 2026 | receipt | PO-001223 | MAIN | 40 | 298.71 | 11,948.36 | 40 | 11,948.36 | |
| Feb. 4, 2026 | issue | SO-260204-459 | MAIN | 7 | 293.07 | -2,051.49 | 0 | 0.00 | Nov. 20, 2025: 6 @ 292.99; Nov. 24, 2025: 1 @ 293.55 |
| Feb. 4, 2026 | issue | SO-260204-459 | EAST | 3 | 292.99 | -878.97 | 7 | 2,051.49 | Nov. 20, 2025: 3 @ 292.99 |
| Jan. 30, 2026 | issue | SO-260130-455 | MAIN | 3 | 292.99 | -878.97 | 10 | 2,930.46 | Nov. 20, 2025: 3 @ 292.99 |
| Jan. 18, 2026 | issue | SO-260118-359 | MAIN | 1 | 292.99 | -292.99 | 13 | 3,809.43 | Nov. 20, 2025: 1 @ 292.99 |
| Jan. 13, 2026 | issue | SO-260113-647 | EAST | 1 | 292.99 | -292.99 | 14 | 4,102.42 | Nov. 20, 2025: 1 @ 292.99 |
| Jan. 9, 2026 | issue | SO-260109-496 | EAST | 9 | 292.99 | -2,636.91 | 15 | 4,395.41 | Nov. 20, 2025: 9 @ 292.99 |
| Dec. 25, 2025 | issue | SO-251225-794 | MAIN | 10 | 292.99 | -2,929.90 | 24 | 7,032.32 | Nov. 20, 2025: 10 @ 292.99 |
| Dec. 22, 2025 | issue | SO-251222-993 | MAIN | 2 | 292.99 | -585.98 | 34 | 9,962.23 | Nov. 20, 2025: 2 @ 292.99 |
| Dec. 2, 2025 | issue | SO-251202-923 | MAIN | 9 | 293.24 | -2,639.15 | 36 | 10,548.21 | Sept. 30, 2025: 4 @ 293.55; Nov. 20, 2025: 5 @ 292.99 |
| Nov. 24, 2025 | return | RMA | MAIN | 1 | 293.55 | 293.55 | 45 | 13,187.35 | |
| Nov. 20, 2025 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Nov. 20, 2025 | receipt | PO-001010 | MAIN | 40 | 292.99 | 11,719.61 | 44 | 12,893.80 | |
| Nov. 10, 2025 | issue | SO-251110-636 | EAST | 3 | 293.55 | -880.65 | 4 | 1,174.20 | Sept. 30, 2025: 3 @ 293.55 |
| Nov. 10, 2025 | issue | SO-251110-636 | MAIN | 3 | 293.55 | -880.65 | 7 | 2,054.84 | Sept. 30, 2025: 3 @ 293.55 |
| Nov. 5, 2025 | issue | SO-251105-622 | MAIN | 10 | 293.55 | -2,935.49 | 10 | 2,935.49 | Sept. 30, 2025: 10 @ 293.55 |
| Oct. 31, 2025 | issue | SO-251031-869 | EAST | 6 | 293.55 | -1,761.29 | 20 | 5,870.98 | Sept. 30, 2025: 6 @ 293.55 |
| Oct. 28, 2025 | issue | SO-251028-756 | MAIN | 1 | 293.55 | -293.55 | 26 | 7,632.28 | Sept. 30, 2025: 1 @ 293.55 |