Items / CAB-0024
Flexible Cable 3 core Flex CAB-0024 · Cables & Wires · Conduit & Cable Co
On hand (COIL)0
Value (FIFO)0.00avg 0.00
ClassAX / FCV 0.18
Turnover10.7xlast issue 2 days ago
Days of cover0lead time 14d
Reorder suggested: 400 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 | 48.83 / 30.4375 | 1.604 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.88 / 5.517 | 1.609 |
| 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 * 1.609^2 + 1.604^2 * 3.1^2) | 16.1 |
| Reorder point | d * LT + safety stock | 1.604 * 14.0 + 16.1 | 38.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 38.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 586/yr, S = 45.00, h = 20%, price = 334.20 | 400.0 |
| 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 | 363.26 | 27 | 214,681 | yes |
| 200 | 348.73 | 200 | 211,322 | yes |
| 400 | 334.20 | 400 | 209,141 | yes (chosen if cheapest) |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| No stock. | ||||
Movement ledger 123 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-597 | EAST | 14 | 355.15 | -4,972.07 | 0 | 0.00 | Aug. 31, 2026: 14 @ 355.15 |
| Oct. 13, 2026 | issue | SO-261013-694 | EAST | 13 | 355.15 | -4,616.92 | 14 | 4,972.07 | Aug. 31, 2026: 13 @ 355.15 |
| Oct. 8, 2026 | issue | SO-261008-355 | EAST | 2 | 355.15 | -710.30 | 27 | 9,588.99 | Aug. 31, 2026: 2 @ 355.15 |
| Oct. 8, 2026 | issue | SO-261008-355 | MAIN | 2 | 355.15 | -710.30 | 29 | 10,299.28 | Aug. 31, 2026: 2 @ 355.15 |
| Oct. 7, 2026 | issue | SO-261007-978 | MAIN | 12 | 355.15 | -4,261.77 | 31 | 11,009.58 | Aug. 31, 2026: 12 @ 355.15 |
| Sept. 30, 2026 | issue | SO-260930-792 | MAIN | 2 | 355.15 | -710.30 | 43 | 15,271.35 | Aug. 31, 2026: 2 @ 355.15 |
| Sept. 26, 2026 | issue | SO-260926-280 | MAIN | 25 | 355.15 | -8,878.69 | 45 | 15,981.65 | Aug. 31, 2026: 25 @ 355.15 |
| Sept. 20, 2026 | issue | SO-260920-993 | MAIN | 27 | 355.15 | -9,588.99 | 70 | 24,860.34 | Aug. 31, 2026: 27 @ 355.15 |
| Sept. 11, 2026 | issue | SO-260911-780 | EAST | 1 | 355.15 | -355.15 | 97 | 34,449.33 | Aug. 31, 2026: 1 @ 355.15 |
| Sept. 2, 2026 | issue | SO-260902-219 | MAIN | 6 | 350.12 | -2,100.70 | 98 | 34,804.47 | Aug. 4, 2026: 4 @ 347.60; Aug. 31, 2026: 2 @ 355.15 |
| Aug. 31, 2026 | transfer | TRF | MAIN → EAST | 26 | warehouse transfer, no cost effect | ||||
| Aug. 31, 2026 | receipt | PO-001763 | MAIN | 100 | 355.15 | 35,514.77 | 104 | 36,905.17 | |
| Aug. 23, 2026 | issue | SO-260823-422 | EAST | 21 | 347.60 | -7,299.61 | 4 | 1,390.40 | June 21, 2026: 10 @ 347.60; Aug. 4, 2026: 11 @ 347.60 |
| Aug. 23, 2026 | issue | SO-260823-422 | MAIN | 1 | 347.60 | -347.60 | 25 | 8,690.01 | June 21, 2026: 1 @ 347.60 |
| Aug. 15, 2026 | issue | SO-260815-220 | MAIN | 28 | 347.60 | -9,732.81 | 26 | 9,037.61 | June 21, 2026: 28 @ 347.60 |
| Aug. 4, 2026 | return | RMA | MAIN | 15 | 347.60 | 5,214.01 | 54 | 18,770.43 | |
| July 31, 2026 | issue | SO-260731-357 | MAIN | 11 | 347.60 | -3,823.61 | 39 | 13,556.42 | June 21, 2026: 11 @ 347.60 |
| July 30, 2026 | issue | SO-260730-267 | MAIN | 30 | 347.60 | -10,428.02 | 50 | 17,380.02 | June 21, 2026: 30 @ 347.60 |
| July 22, 2026 | issue | SO-260722-878 | MAIN | 10 | 347.60 | -3,476.00 | 80 | 27,808.04 | June 21, 2026: 10 @ 347.60 |
| July 15, 2026 | issue | SO-260715-542 | MAIN | 1 | 347.60 | -347.60 | 90 | 31,284.04 | June 21, 2026: 1 @ 347.60 |
| July 8, 2026 | issue | SO-260708-718 | MAIN | 9 | 347.60 | -3,128.40 | 91 | 31,631.65 | June 21, 2026: 9 @ 347.60 |
| June 21, 2026 | transfer | TRF | MAIN → EAST | 25 | warehouse transfer, no cost effect | ||||
| June 21, 2026 | receipt | PO-001591 | MAIN | 100 | 347.60 | 34,760.05 | 100 | 34,760.05 | |
| June 11, 2026 | issue | SO-260611-258 | EAST | 10 | 361.15 | -3,611.51 | 0 | 0.00 | April 12, 2026: 10 @ 361.15 |
| June 11, 2026 | issue | SO-260611-258 | MAIN | 17 | 361.15 | -6,139.57 | 10 | 3,611.51 | April 12, 2026: 17 @ 361.15 |
| June 8, 2026 | issue | SO-260608-747 | MAIN | 20 | 361.15 | -7,223.02 | 27 | 9,751.08 | April 12, 2026: 20 @ 361.15 |
| May 30, 2026 | issue | SO-260530-232 | MAIN | 36 | 361.15 | -13,001.44 | 47 | 16,974.10 | April 12, 2026: 36 @ 361.15 |
| May 10, 2026 | issue | SO-260510-938 | EAST | 8 | 361.15 | -2,889.21 | 83 | 29,975.54 | April 12, 2026: 8 @ 361.15 |
| May 4, 2026 | issue | SO-260504-806 | EAST | 11 | 358.00 | -3,938.00 | 91 | 32,864.75 | March 3, 2026: 2 @ 343.82; April 12, 2026: 9 @ 361.15 |
| April 30, 2026 | issue | SO-260430-749 | MAIN | 4 | 343.82 | -1,375.27 | 102 | 36,802.75 | March 3, 2026: 4 @ 343.82 |
| April 12, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| April 12, 2026 | receipt | PO-001400 | MAIN | 100 | 361.15 | 36,115.11 | 106 | 38,178.02 | |
| April 11, 2026 | issue | SO-260411-845 | EAST | 2 | 343.82 | -687.64 | 6 | 2,062.91 | March 3, 2026: 2 @ 343.82 |
| April 11, 2026 | issue | SO-260411-845 | MAIN | 7 | 343.82 | -2,406.72 | 8 | 2,750.54 | March 3, 2026: 7 @ 343.82 |
| April 4, 2026 | issue | SO-260404-691 | EAST | 27 | 343.82 | -9,283.08 | 15 | 5,157.27 | March 3, 2026: 27 @ 343.82 |
| April 2, 2026 | issue | SO-260402-414 | MAIN | 11 | 343.82 | -3,782.00 | 42 | 14,440.35 | March 3, 2026: 11 @ 343.82 |
| March 23, 2026 | issue | SO-260323-219 | MAIN | 18 | 343.82 | -6,188.72 | 53 | 18,222.34 | March 3, 2026: 18 @ 343.82 |
| March 21, 2026 | issue | SO-260321-951 | MAIN | 30 | 344.31 | -10,329.43 | 71 | 24,411.06 | Dec. 28, 2025: 1 @ 358.72; March 3, 2026: 29 @ 343.82 |
| March 10, 2026 | issue | SO-260310-414 | MAIN | 4 | 358.72 | -1,434.87 | 101 | 34,740.50 | Dec. 28, 2025: 4 @ 358.72 |
| March 7, 2026 | issue | SO-260307-488 | EAST | 9 | 358.72 | -3,228.45 | 105 | 36,175.36 | Dec. 28, 2025: 9 @ 358.72 |
| March 3, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| March 3, 2026 | receipt | PO-001279 | MAIN | 100 | 343.82 | 34,381.78 | 114 | 39,403.81 | |
| Feb. 17, 2026 | issue | SO-260217-308 | MAIN | 32 | 358.72 | -11,478.93 | 14 | 5,022.03 | Dec. 28, 2025: 32 @ 358.72 |
| Feb. 11, 2026 | issue | SO-260211-765 | EAST | 12 | 358.72 | -4,304.60 | 46 | 16,500.97 | Dec. 28, 2025: 12 @ 358.72 |
| Jan. 27, 2026 | issue | SO-260127-981 | MAIN | 7 | 358.72 | -2,511.02 | 58 | 20,805.57 | Dec. 28, 2025: 7 @ 358.72 |
| Jan. 24, 2026 | issue | SO-260124-135 | MAIN | 6 | 358.72 | -2,152.30 | 65 | 23,316.59 | Dec. 28, 2025: 6 @ 358.72 |
| Jan. 23, 2026 | issue | SO-260123-468 | MAIN | 2 | 358.72 | -717.43 | 71 | 25,468.89 | Dec. 28, 2025: 2 @ 358.72 |
| Jan. 20, 2026 | issue | SO-260120-550 | EAST | 7 | 358.72 | -2,511.02 | 73 | 26,186.32 | Dec. 28, 2025: 7 @ 358.72 |
| Jan. 15, 2026 | issue | SO-260115-446 | MAIN | 4 | 358.72 | -1,434.87 | 80 | 28,697.34 | Dec. 28, 2025: 4 @ 358.72 |
| Jan. 7, 2026 | issue | SO-260107-807 | MAIN | 15 | 358.72 | -5,380.75 | 84 | 30,132.20 | Dec. 28, 2025: 15 @ 358.72 |
| Dec. 30, 2025 | issue | SO-251230-348 | MAIN | 2 | 348.67 | -697.34 | 99 | 35,512.95 | Oct. 13, 2025: 1 @ 338.62; Dec. 28, 2025: 1 @ 358.72 |
| Dec. 28, 2025 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| Dec. 28, 2025 | receipt | PO-001097 | MAIN | 100 | 358.72 | 35,871.67 | 101 | 36,210.29 | |
| Dec. 21, 2025 | issue | SO-251221-767 | MAIN | 4 | 341.90 | -1,367.60 | 1 | 338.62 | Sept. 30, 2025: 2 @ 345.18; Oct. 13, 2025: 2 @ 338.62 |
| Dec. 19, 2025 | issue | SO-251219-286 | MAIN | 10 | 345.18 | -3,451.80 | 5 | 1,706.22 | Sept. 30, 2025: 10 @ 345.18 |
| Dec. 17, 2025 | issue | SO-251217-777 | MAIN | 9 | 345.18 | -3,106.62 | 15 | 5,158.02 | Sept. 30, 2025: 9 @ 345.18 |
| Dec. 15, 2025 | issue | SO-251215-101 | MAIN | 12 | 345.18 | -4,142.16 | 24 | 8,264.63 | Sept. 30, 2025: 12 @ 345.18 |
| Dec. 6, 2025 | issue | SO-251206-918 | MAIN | 3 | 345.18 | -1,035.54 | 36 | 12,406.79 | Sept. 30, 2025: 3 @ 345.18 |
| Nov. 20, 2025 | issue | SO-251120-523 | MAIN | 10 | 345.18 | -3,451.80 | 39 | 13,442.33 | Sept. 30, 2025: 10 @ 345.18 |
| Nov. 13, 2025 | issue | SO-251113-394 | MAIN | 6 | 345.18 | -2,071.08 | 49 | 16,894.12 | Sept. 30, 2025: 6 @ 345.18 |