Items / CAB-0002
Flexible Cable 3 core Flex CAB-0002 · Cables & Wires · Conduit & Cable Co
On hand (COIL)0
Value (FIFO)0.00avg 0.00
ClassAX / FCV 0.17
Turnover25.8xlast issue 4 days ago
Days of cover0lead time 14d
Reorder suggested: 50 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 | 21.50 / 30.4375 | 0.706 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.59 / 5.517 | 0.651 |
| 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.651^2 + 0.706^2 * 3.1^2) | 6.7 |
| Reorder point | d * LT + safety stock | 0.706 * 14.0 + 6.7 | 16.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 258/yr, S = 45.00, h = 20%, price = 368.04 | 17.8 |
| Inventory position | on hand + on order | 0 + 0 | 0 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 368.04 | 18 | 96,196 | yes (chosen if cheapest) |
MOQ 50, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 117 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-556 | EAST | 1 | 361.48 | -361.48 | 0 | 0.00 | Aug. 26, 2026: 1 @ 361.48 |
| Oct. 11, 2026 | issue | SO-261011-730 | EAST | 5 | 361.48 | -1,807.38 | 1 | 361.48 | Aug. 26, 2026: 5 @ 361.48 |
| Oct. 9, 2026 | issue | SO-261009-205 | EAST | 6 | 361.48 | -2,168.85 | 6 | 2,168.85 | Aug. 26, 2026: 6 @ 361.48 |
| Oct. 9, 2026 | issue | SO-261009-205 | MAIN | 7 | 361.48 | -2,530.33 | 12 | 4,337.71 | Aug. 26, 2026: 7 @ 361.48 |
| Sept. 27, 2026 | issue | SO-260927-574 | MAIN | 7 | 361.48 | -2,530.33 | 19 | 6,868.04 | Aug. 26, 2026: 7 @ 361.48 |
| Sept. 26, 2026 | issue | SO-260926-160 | EAST | 11 | 361.48 | -3,976.23 | 26 | 9,398.37 | Aug. 26, 2026: 11 @ 361.48 |
| Sept. 21, 2026 | issue | SO-260921-859 | EAST | 3 | 361.48 | -1,084.43 | 37 | 13,374.60 | Aug. 26, 2026: 3 @ 361.48 |
| Sept. 2, 2026 | issue | SO-260902-651 | MAIN | 8 | 361.48 | -2,891.81 | 40 | 14,459.03 | Aug. 26, 2026: 8 @ 361.48 |
| Aug. 31, 2026 | issue | SO-260831-579 | MAIN | 16 | 358.61 | -5,737.75 | 48 | 17,350.83 | June 9, 2026: 14 @ 358.20; Aug. 26, 2026: 2 @ 361.48 |
| Aug. 26, 2026 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| Aug. 26, 2026 | receipt | PO-001749 | MAIN | 50 | 361.48 | 18,073.78 | 64 | 23,088.58 | |
| Aug. 12, 2026 | issue | SO-260812-235 | MAIN | 3 | 358.20 | -1,074.60 | 14 | 5,014.80 | June 9, 2026: 3 @ 358.20 |
| July 26, 2026 | issue | SO-260726-579 | MAIN | 15 | 358.20 | -5,373.00 | 17 | 6,089.40 | June 9, 2026: 15 @ 358.20 |
| July 12, 2026 | issue | SO-260712-341 | EAST | 6 | 358.20 | -2,149.20 | 32 | 11,462.40 | June 9, 2026: 6 @ 358.20 |
| June 27, 2026 | issue | SO-260627-392 | MAIN | 3 | 358.20 | -1,074.60 | 38 | 13,611.60 | June 9, 2026: 3 @ 358.20 |
| June 22, 2026 | issue | SO-260622-479 | MAIN | 7 | 358.20 | -2,507.40 | 41 | 14,686.20 | June 9, 2026: 7 @ 358.20 |
| June 16, 2026 | issue | SO-260616-225 | MAIN | 1 | 358.20 | -358.20 | 48 | 17,193.60 | June 9, 2026: 1 @ 358.20 |
| June 14, 2026 | issue | SO-260614-597 | MAIN | 4 | 353.34 | -1,413.37 | 49 | 17,551.80 | March 24, 2026: 3 @ 351.72; June 9, 2026: 1 @ 358.20 |
| June 10, 2026 | issue | SO-260610-216 | MAIN | 2 | 351.72 | -703.44 | 53 | 18,965.16 | March 24, 2026: 2 @ 351.72 |
| June 9, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| June 9, 2026 | receipt | PO-001563 | MAIN | 50 | 358.20 | 17,910.00 | 55 | 19,668.61 | |
| June 2, 2026 | issue | SO-260602-225 | MAIN | 2 | 351.72 | -703.44 | 5 | 1,758.61 | March 24, 2026: 2 @ 351.72 |
| May 28, 2026 | issue | SO-260528-523 | MAIN | 1 | 351.72 | -351.72 | 7 | 2,462.06 | March 24, 2026: 1 @ 351.72 |
| May 26, 2026 | issue | SO-260526-648 | MAIN | 5 | 351.72 | -1,758.61 | 8 | 2,813.78 | March 24, 2026: 5 @ 351.72 |
| May 25, 2026 | issue | SO-260525-546 | EAST | 4 | 351.72 | -1,406.89 | 13 | 4,572.39 | March 24, 2026: 4 @ 351.72 |
| May 17, 2026 | issue | SO-260517-849 | EAST | 2 | 351.72 | -703.44 | 17 | 5,979.28 | March 24, 2026: 2 @ 351.72 |
| May 15, 2026 | issue | SO-260515-981 | MAIN | 2 | 351.72 | -703.44 | 19 | 6,682.73 | March 24, 2026: 2 @ 351.72 |
| May 14, 2026 | issue | SO-260514-363 | MAIN | 1 | 351.72 | -351.72 | 21 | 7,386.17 | March 24, 2026: 1 @ 351.72 |
| May 12, 2026 | issue | SO-260512-226 | MAIN | 2 | 351.72 | -703.44 | 22 | 7,737.89 | March 24, 2026: 2 @ 351.72 |
| April 29, 2026 | issue | SO-260429-492 | MAIN | 14 | 351.72 | -4,924.11 | 24 | 8,441.34 | March 24, 2026: 14 @ 351.72 |
| April 12, 2026 | issue | SO-260412-403 | MAIN | 9 | 351.72 | -3,165.50 | 38 | 13,365.45 | March 24, 2026: 9 @ 351.72 |
| March 26, 2026 | issue | SO-260326-420 | EAST | 3 | 351.72 | -1,055.17 | 47 | 16,530.95 | March 24, 2026: 3 @ 351.72 |
| March 24, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| March 24, 2026 | receipt | PO-001347 | MAIN | 50 | 351.72 | 17,586.12 | 50 | 17,586.12 | |
| March 23, 2026 | issue | SO-260323-655 | MAIN | 7 | 358.06 | -2,506.43 | 0 | 0.00 | Jan. 16, 2026: 7 @ 358.06 |
| March 23, 2026 | issue | SO-260323-655 | EAST | 4 | 358.06 | -1,432.25 | 7 | 2,506.43 | Jan. 16, 2026: 4 @ 358.06 |
| March 15, 2026 | issue | SO-260315-561 | MAIN | 8 | 358.06 | -2,864.50 | 11 | 3,938.68 | Jan. 16, 2026: 8 @ 358.06 |
| March 14, 2026 | issue | SO-260314-779 | EAST | 3 | 358.06 | -1,074.19 | 19 | 6,803.18 | Jan. 16, 2026: 3 @ 358.06 |
| Feb. 19, 2026 | issue | SO-260219-739 | MAIN | 3 | 358.06 | -1,074.19 | 22 | 7,877.36 | Jan. 16, 2026: 3 @ 358.06 |
| Feb. 4, 2026 | issue | SO-260204-607 | MAIN | 18 | 358.06 | -6,445.12 | 25 | 8,951.55 | Jan. 16, 2026: 18 @ 358.06 |
| Jan. 30, 2026 | issue | SO-260130-107 | EAST | 4 | 358.06 | -1,432.25 | 43 | 15,396.67 | Jan. 16, 2026: 4 @ 358.06 |
| Jan. 28, 2026 | issue | SO-260128-312 | MAIN | 4 | 354.66 | -1,418.63 | 47 | 16,828.91 | Nov. 10, 2025: 1 @ 344.44; Jan. 16, 2026: 3 @ 358.06 |
| Jan. 26, 2026 | issue | SO-260126-363 | MAIN | 10 | 344.44 | -3,444.40 | 51 | 18,247.54 | Nov. 10, 2025: 10 @ 344.44 |
| Jan. 19, 2026 | issue | SO-260119-477 | EAST | 1 | 344.44 | -344.44 | 61 | 21,691.94 | Nov. 10, 2025: 1 @ 344.44 |
| Jan. 16, 2026 | issue | SO-260116-756 | EAST | 2 | 344.44 | -688.88 | 62 | 22,036.38 | Nov. 10, 2025: 2 @ 344.44 |
| Jan. 16, 2026 | receipt | PO-001147 | MAIN | 50 | 358.06 | 17,903.10 | 64 | 22,725.26 | |
| Jan. 9, 2026 | issue | SO-260109-456 | EAST | 1 | 344.44 | -344.44 | 14 | 4,822.16 | Nov. 10, 2025: 1 @ 344.44 |
| Jan. 7, 2026 | issue | SO-260107-607 | MAIN | 1 | 344.44 | -344.44 | 15 | 5,166.60 | Nov. 10, 2025: 1 @ 344.44 |
| Dec. 27, 2025 | issue | SO-251227-766 | MAIN | 1 | 344.44 | -344.44 | 16 | 5,511.04 | Nov. 10, 2025: 1 @ 344.44 |
| Dec. 26, 2025 | issue | SO-251226-480 | MAIN | 2 | 344.44 | -688.88 | 17 | 5,855.49 | Nov. 10, 2025: 2 @ 344.44 |
| Dec. 24, 2025 | issue | SO-251224-268 | MAIN | 8 | 344.44 | -2,755.52 | 19 | 6,544.37 | Nov. 10, 2025: 8 @ 344.44 |
| Dec. 18, 2025 | issue | SO-251218-516 | MAIN | 2 | 344.44 | -688.88 | 27 | 9,299.89 | Nov. 10, 2025: 2 @ 344.44 |
| Dec. 10, 2025 | issue | SO-251210-754 | EAST | 2 | 344.44 | -688.88 | 29 | 9,988.77 | Nov. 10, 2025: 2 @ 344.44 |
| Nov. 13, 2025 | issue | SO-251113-230 | MAIN | 9 | 344.44 | -3,099.96 | 31 | 10,677.65 | Nov. 10, 2025: 9 @ 344.44 |
| Nov. 10, 2025 | issue | SO-251110-768 | MAIN | 13 | 346.88 | -4,509.41 | 40 | 13,777.61 | Sept. 17, 2025: 3 @ 355.00; Nov. 10, 2025: 10 @ 344.44 |
| Nov. 10, 2025 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| Nov. 10, 2025 | receipt | PO-000991 | MAIN | 50 | 344.44 | 17,222.02 | 53 | 18,287.02 | |
| Oct. 30, 2025 | issue | SO-251030-127 | MAIN | 6 | 355.00 | -2,130.01 | 3 | 1,065.01 | Sept. 17, 2025: 6 @ 355.00 |
| Oct. 27, 2025 | issue | SO-251027-377 | MAIN | 9 | 355.00 | -3,195.02 | 9 | 3,195.02 | Sept. 17, 2025: 9 @ 355.00 |
| Oct. 17, 2025 | issue | SO-251017-382 | MAIN | 3 | 355.00 | -1,065.01 | 18 | 6,390.04 | Sept. 17, 2025: 3 @ 355.00 |