Items / CAB-0022
Flexible Cable 3 core Pro CAB-0022 · Cables & Wires · Conduit & Cable Co
On hand (COIL)10MAIN 10
Value (FIFO)1,279.37avg 127.94
ClassBX / FCV 0.16
Turnover19.9xlast issue 0 days ago
Days of cover16lead time 14d
Reorder suggested: 40 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 19.58 / 30.4375 | 0.643 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.07 / 5.517 | 0.556 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(14.0 * 0.556^2 + 0.643^2 * 3.1^2) | 4.7 |
| Reorder point | d * LT + safety stock | 0.643 * 14.0 + 4.7 | 13.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 13.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 235/yr, S = 45.00, h = 20%, price = 130.99 | 28.4 |
| Inventory position | on hand + on order | 10 + 0 | 10 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 130.99 | 28 | 31,506 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 25, 2026 | 10 / 40 | 127.94 | 1,279.37 |
Movement ledger 137 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-598 | MAIN | 9 | 127.94 | -1,151.43 | 10 | 1,279.37 | Aug. 25, 2026: 9 @ 127.94 |
| Oct. 12, 2026 | issue | SO-261012-547 | MAIN | 1 | 127.94 | -127.94 | 19 | 2,430.80 | Aug. 25, 2026: 1 @ 127.94 |
| Oct. 8, 2026 | issue | SO-261008-724 | MAIN | 1 | 127.94 | -127.94 | 20 | 2,558.74 | Aug. 25, 2026: 1 @ 127.94 |
| Oct. 7, 2026 | issue | SO-261007-885 | MAIN | 1 | 127.94 | -127.94 | 21 | 2,686.68 | Aug. 25, 2026: 1 @ 127.94 |
| Oct. 5, 2026 | issue | SO-261005-177 | MAIN | 1 | 127.94 | -127.94 | 22 | 2,814.61 | Aug. 25, 2026: 1 @ 127.94 |
| Oct. 4, 2026 | issue | SO-261004-215 | MAIN | 1 | 127.94 | -127.94 | 23 | 2,942.55 | Aug. 25, 2026: 1 @ 127.94 |
| Oct. 3, 2026 | issue | SO-261003-816 | MAIN | 2 | 127.94 | -255.87 | 24 | 3,070.49 | Aug. 25, 2026: 2 @ 127.94 |
| Sept. 20, 2026 | issue | SO-260920-646 | MAIN | 6 | 127.94 | -767.62 | 26 | 3,326.36 | Aug. 25, 2026: 6 @ 127.94 |
| Sept. 16, 2026 | issue | SO-260916-220 | MAIN | 2 | 127.94 | -255.87 | 32 | 4,093.98 | Aug. 25, 2026: 2 @ 127.94 |
| Sept. 9, 2026 | issue | SO-260909-980 | MAIN | 1 | 127.94 | -127.94 | 34 | 4,349.86 | Aug. 25, 2026: 1 @ 127.94 |
| Sept. 9, 2026 | issue | SO-260909-980 | EAST | 5 | 127.94 | -639.68 | 35 | 4,477.80 | Aug. 25, 2026: 5 @ 127.94 |
| Sept. 8, 2026 | issue | SO-260908-346 | MAIN | 1 | 128.97 | -128.97 | 40 | 5,117.48 | July 8, 2026: 1 @ 128.97 |
| Sept. 4, 2026 | issue | SO-260904-305 | MAIN | 8 | 128.97 | -1,031.73 | 41 | 5,246.45 | July 8, 2026: 8 @ 128.97 |
| Sept. 1, 2026 | issue | SO-260901-326 | MAIN | 1 | 128.97 | -128.97 | 49 | 6,278.17 | July 8, 2026: 1 @ 128.97 |
| Aug. 28, 2026 | issue | SO-260828-401 | MAIN | 2 | 128.97 | -257.93 | 50 | 6,407.14 | July 8, 2026: 2 @ 128.97 |
| Aug. 25, 2026 | receipt | PO-001744 | MAIN | 40 | 127.94 | 5,117.48 | 52 | 6,665.07 | |
| Aug. 11, 2026 | issue | SO-260811-886 | MAIN | 1 | 128.97 | -128.97 | 12 | 1,547.59 | July 8, 2026: 1 @ 128.97 |
| Aug. 10, 2026 | issue | SO-260810-304 | MAIN | 9 | 128.97 | -1,160.69 | 13 | 1,676.56 | July 8, 2026: 9 @ 128.97 |
| Aug. 9, 2026 | issue | SO-260809-157 | EAST | 5 | 128.97 | -644.83 | 22 | 2,837.25 | July 8, 2026: 5 @ 128.97 |
| Aug. 1, 2026 | issue | SO-260801-387 | MAIN | 1 | 128.97 | -128.97 | 27 | 3,482.08 | July 8, 2026: 1 @ 128.97 |
| July 27, 2026 | issue | SO-260727-610 | MAIN | 5 | 128.97 | -644.83 | 28 | 3,611.05 | July 8, 2026: 5 @ 128.97 |
| July 9, 2026 | issue | SO-260709-491 | MAIN | 9 | 129.47 | -1,165.20 | 33 | 4,255.88 | April 30, 2026: 2 @ 131.22; July 8, 2026: 7 @ 128.97 |
| July 8, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| July 8, 2026 | receipt | PO-001632 | MAIN | 40 | 128.97 | 5,158.64 | 42 | 5,421.08 | |
| July 7, 2026 | issue | SO-260707-596 | MAIN | 2 | 131.22 | -262.44 | 2 | 262.44 | April 30, 2026: 2 @ 131.22 |
| June 27, 2026 | issue | SO-260627-335 | MAIN | 7 | 131.22 | -918.54 | 4 | 524.88 | April 30, 2026: 7 @ 131.22 |
| June 21, 2026 | issue | SO-260621-418 | MAIN | 2 | 131.22 | -262.44 | 11 | 1,443.42 | April 30, 2026: 2 @ 131.22 |
| June 20, 2026 | issue | SO-260620-212 | MAIN | 3 | 131.22 | -393.66 | 13 | 1,705.86 | April 30, 2026: 3 @ 131.22 |
| June 1, 2026 | issue | SO-260601-692 | MAIN | 6 | 131.22 | -787.32 | 16 | 2,099.52 | April 30, 2026: 6 @ 131.22 |
| May 30, 2026 | issue | SO-260530-479 | MAIN | 16 | 131.22 | -2,099.52 | 22 | 2,886.84 | April 30, 2026: 16 @ 131.22 |
| May 26, 2026 | issue | SO-260526-451 | MAIN | 1 | 131.22 | -131.22 | 38 | 4,986.35 | April 30, 2026: 1 @ 131.22 |
| May 4, 2026 | issue | SO-260504-441 | MAIN | 1 | 131.22 | -131.22 | 39 | 5,117.57 | April 30, 2026: 1 @ 131.22 |
| April 30, 2026 | receipt | PO-001452 | MAIN | 40 | 131.22 | 5,248.79 | 40 | 5,248.79 | |
| April 23, 2026 | issue | SO-260423-197 | MAIN | 2 | 131.11 | -262.22 | 0 | 0.00 | March 11, 2026: 2 @ 131.11 |
| April 22, 2026 | issue | SO-260422-223 | MAIN | 3 | 131.11 | -393.32 | 2 | 262.22 | March 11, 2026: 3 @ 131.11 |
| April 19, 2026 | issue | SO-260419-644 | MAIN | 7 | 131.11 | -917.75 | 5 | 655.54 | March 11, 2026: 7 @ 131.11 |
| April 14, 2026 | issue | SO-260414-873 | MAIN | 2 | 131.11 | -262.22 | 12 | 1,573.29 | March 11, 2026: 2 @ 131.11 |
| April 12, 2026 | issue | SO-260412-116 | MAIN | 2 | 131.11 | -262.22 | 14 | 1,835.51 | March 11, 2026: 2 @ 131.11 |
| March 26, 2026 | issue | SO-260326-927 | MAIN | 14 | 131.11 | -1,835.51 | 16 | 2,097.72 | March 11, 2026: 14 @ 131.11 |
| March 20, 2026 | issue | SO-260320-702 | MAIN | 1 | 131.11 | -131.11 | 30 | 3,933.23 | March 11, 2026: 1 @ 131.11 |
| March 17, 2026 | issue | SO-260317-458 | MAIN | 2 | 131.11 | -262.22 | 31 | 4,064.34 | March 11, 2026: 2 @ 131.11 |
| March 15, 2026 | issue | SO-260315-334 | MAIN | 7 | 131.11 | -917.75 | 33 | 4,326.55 | March 11, 2026: 7 @ 131.11 |
| March 11, 2026 | receipt | PO-001306 | MAIN | 40 | 131.11 | 5,244.31 | 40 | 5,244.31 | |
| March 3, 2026 | issue | SO-260303-166 | MAIN | 1 | 128.30 | -128.30 | 0 | 0.00 | Dec. 22, 2025: 1 @ 128.30 |
| Feb. 26, 2026 | issue | SO-260226-526 | MAIN | 17 | 128.30 | -2,181.15 | 1 | 128.30 | Dec. 22, 2025: 17 @ 128.30 |
| Feb. 25, 2026 | issue | SO-260225-352 | MAIN | 1 | 128.30 | -128.30 | 18 | 2,309.45 | Dec. 22, 2025: 1 @ 128.30 |
| Feb. 14, 2026 | issue | SO-260214-217 | MAIN | 1 | 128.30 | -128.30 | 19 | 2,437.76 | Dec. 22, 2025: 1 @ 128.30 |
| Feb. 13, 2026 | issue | SO-260213-758 | MAIN | 1 | 128.30 | -128.30 | 20 | 2,566.06 | Dec. 22, 2025: 1 @ 128.30 |
| Feb. 8, 2026 | issue | SO-260208-863 | MAIN | 1 | 128.30 | -128.30 | 21 | 2,694.36 | Dec. 22, 2025: 1 @ 128.30 |
| Feb. 3, 2026 | issue | SO-260203-719 | MAIN | 1 | 128.30 | -128.30 | 22 | 2,822.66 | Dec. 22, 2025: 1 @ 128.30 |
| Jan. 21, 2026 | issue | SO-260121-803 | MAIN | 10 | 128.30 | -1,283.03 | 23 | 2,950.97 | Dec. 22, 2025: 10 @ 128.30 |
| Jan. 17, 2026 | issue | SO-260117-249 | MAIN | 3 | 128.30 | -384.91 | 33 | 4,234.00 | Dec. 22, 2025: 3 @ 128.30 |
| Jan. 6, 2026 | issue | SO-260106-106 | MAIN | 3 | 128.30 | -384.91 | 36 | 4,618.90 | Dec. 22, 2025: 3 @ 128.30 |
| Dec. 31, 2025 | issue | SO-251231-777 | MAIN | 4 | 128.17 | -512.69 | 39 | 5,003.81 | Nov. 3, 2025: 3 @ 128.13; Dec. 22, 2025: 1 @ 128.30 |
| Dec. 25, 2025 | issue | SO-251225-473 | MAIN | 1 | 128.13 | -128.13 | 43 | 5,516.50 | Nov. 3, 2025: 1 @ 128.13 |
| Dec. 22, 2025 | receipt | PO-001074 | MAIN | 40 | 128.30 | 5,132.12 | 44 | 5,644.63 | |
| Dec. 14, 2025 | issue | SO-251214-456 | MAIN | 5 | 128.13 | -640.64 | 4 | 512.51 | Nov. 3, 2025: 5 @ 128.13 |
| Dec. 7, 2025 | issue | SO-251207-591 | MAIN | 9 | 128.13 | -1,153.15 | 9 | 1,153.15 | Nov. 3, 2025: 9 @ 128.13 |
| Nov. 23, 2025 | issue | SO-251123-742 | MAIN | 11 | 128.13 | -1,409.41 | 18 | 2,306.31 | Nov. 3, 2025: 11 @ 128.13 |
| Nov. 12, 2025 | issue | SO-251112-431 | MAIN | 1 | 128.13 | -128.13 | 29 | 3,715.71 | Nov. 3, 2025: 1 @ 128.13 |