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
| 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 |
| Oct. 10, 2025 | issue | SO-251010-445 | MAIN | 6 | 355.00 | -2,130.01 | 21 | 7,455.05 | Sept. 17, 2025: 6 @ 355.00 |
| Sept. 30, 2025 | issue | SO-250930-337 | MAIN | 13 | 355.00 | -4,615.03 | 27 | 9,585.06 | Sept. 17, 2025: 13 @ 355.00 |
| Sept. 23, 2025 | issue | SO-250923-118 | MAIN | 8 | 355.00 | -2,840.02 | 40 | 14,200.09 | Sept. 17, 2025: 8 @ 355.00 |
| Sept. 20, 2025 | issue | SO-250920-584 | MAIN | 2 | 355.00 | -710.00 | 48 | 17,040.11 | Sept. 17, 2025: 2 @ 355.00 |
| Sept. 17, 2025 | receipt | PO-000851 | MAIN | 50 | 355.00 | 17,750.11 | 50 | 17,750.11 | |
| Sept. 16, 2025 | issue | SO-250916-366 | MAIN | 8 | 350.32 | -2,802.54 | 0 | 0.00 | June 25, 2025: 8 @ 350.32 |
| Aug. 29, 2025 | issue | SO-250829-649 | MAIN | 8 | 350.32 | -2,802.54 | 8 | 2,802.54 | June 25, 2025: 8 @ 350.32 |
| Aug. 17, 2025 | issue | SO-250817-621 | MAIN | 1 | 350.32 | -350.32 | 16 | 5,605.08 | June 25, 2025: 1 @ 350.32 |
| Aug. 8, 2025 | issue | SO-250808-625 | MAIN | 2 | 350.32 | -700.63 | 17 | 5,955.39 | June 25, 2025: 2 @ 350.32 |
| Aug. 6, 2025 | issue | SO-250806-858 | MAIN | 2 | 350.32 | -700.63 | 19 | 6,656.03 | June 25, 2025: 2 @ 350.32 |
| Aug. 6, 2025 | issue | SO-250806-858 | EAST | 13 | 350.32 | -4,554.12 | 21 | 7,356.66 | June 25, 2025: 13 @ 350.32 |
| July 31, 2025 | issue | SO-250731-196 | MAIN | 1 | 350.32 | -350.32 | 34 | 11,910.78 | June 25, 2025: 1 @ 350.32 |
| July 25, 2025 | issue | SO-250725-524 | MAIN | 4 | 350.32 | -1,401.27 | 35 | 12,261.10 | June 25, 2025: 4 @ 350.32 |
| July 21, 2025 | issue | SO-250721-613 | MAIN | 5 | 350.32 | -1,751.59 | 39 | 13,662.37 | June 25, 2025: 5 @ 350.32 |
| July 17, 2025 | issue | SO-250717-995 | MAIN | 7 | 351.02 | -2,457.15 | 44 | 15,413.96 | April 27, 2025: 1 @ 355.24; June 25, 2025: 6 @ 350.32 |
| June 25, 2025 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| June 25, 2025 | receipt | PO-000665 | MAIN | 50 | 350.32 | 17,515.86 | 51 | 17,871.10 | |
| June 16, 2025 | issue | SO-250616-804 | EAST | 3 | 355.24 | -1,065.73 | 1 | 355.24 | April 27, 2025: 3 @ 355.24 |
| June 6, 2025 | issue | SO-250606-465 | MAIN | 13 | 355.24 | -4,618.18 | 4 | 1,420.98 | April 27, 2025: 13 @ 355.24 |
| June 2, 2025 | issue | SO-250602-148 | MAIN | 8 | 355.24 | -2,841.96 | 17 | 6,039.16 | April 27, 2025: 8 @ 355.24 |
| May 29, 2025 | issue | SO-250529-812 | MAIN | 17 | 355.24 | -6,039.16 | 25 | 8,881.12 | April 27, 2025: 17 @ 355.24 |
| May 8, 2025 | issue | SO-250508-100 | EAST | 7 | 355.24 | -2,486.71 | 42 | 14,920.27 | April 27, 2025: 7 @ 355.24 |
| April 29, 2025 | issue | SO-250429-321 | EAST | 6 | 350.49 | -2,102.93 | 49 | 17,406.99 | Feb. 22, 2025: 4 @ 349.54; April 16, 2025: 1 @ 349.54; April 27, 2025: 1 @ 355.24 |
| April 27, 2025 | issue | SO-250427-286 | MAIN | 5 | 349.54 | -1,747.69 | 55 | 19,509.92 | Feb. 22, 2025: 5 @ 349.54 |
| April 27, 2025 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| April 27, 2025 | receipt | PO-000487 | MAIN | 50 | 355.24 | 17,762.23 | 60 | 21,257.61 | |
| April 25, 2025 | issue | SO-250425-922 | MAIN | 1 | 349.54 | -349.54 | 10 | 3,495.38 | Feb. 22, 2025: 1 @ 349.54 |
| April 16, 2025 | return | RMA | MAIN | 1 | 349.54 | 349.54 | 11 | 3,844.91 | |
| April 13, 2025 | issue | SO-250413-432 | MAIN | 12 | 349.54 | -4,194.45 | 10 | 3,495.38 | Feb. 22, 2025: 12 @ 349.54 |
| April 7, 2025 | issue | SO-250407-552 | MAIN | 1 | 349.54 | -349.54 | 22 | 7,689.83 | Feb. 22, 2025: 1 @ 349.54 |
| March 9, 2025 | issue | SO-250309-802 | MAIN | 22 | 349.54 | -7,689.83 | 23 | 8,039.37 | Feb. 22, 2025: 22 @ 349.54 |
| March 3, 2025 | issue | SO-250303-180 | MAIN | 5 | 349.54 | -1,747.69 | 45 | 15,729.20 | Feb. 22, 2025: 5 @ 349.54 |
| March 3, 2025 | issue | SO-250303-180 | EAST | 1 | 337.64 | -337.64 | 50 | 17,476.88 | Nov. 28, 2024: 1 @ 337.64 |
| Feb. 22, 2025 | receipt | PO-000291 | MAIN | 50 | 349.54 | 17,476.88 | 51 | 17,814.52 | |
| Feb. 11, 2025 | issue | SO-250211-572 | MAIN | 14 | 337.64 | -4,726.90 | 1 | 337.64 | Nov. 28, 2024: 14 @ 337.64 |
| Feb. 4, 2025 | issue | SO-250204-322 | MAIN | 6 | 337.64 | -2,025.82 | 15 | 5,064.54 | Nov. 28, 2024: 6 @ 337.64 |
| Jan. 22, 2025 | issue | SO-250122-559 | MAIN | 8 | 337.64 | -2,701.09 | 21 | 7,090.35 | Nov. 28, 2024: 8 @ 337.64 |
| Jan. 18, 2025 | issue | SO-250118-838 | MAIN | 9 | 337.64 | -3,038.72 | 29 | 9,791.44 | Nov. 28, 2024: 9 @ 337.64 |
| Jan. 4, 2025 | issue | SO-250104-312 | EAST | 8 | 337.64 | -2,701.09 | 38 | 12,830.16 | Nov. 28, 2024: 8 @ 337.64 |
| Dec. 29, 2024 | issue | SO-241229-525 | MAIN | 3 | 337.64 | -1,012.91 | 46 | 15,531.25 | Nov. 28, 2024: 3 @ 337.64 |
| Dec. 22, 2024 | issue | SO-241222-713 | MAIN | 6 | 347.64 | -2,085.83 | 49 | 16,544.16 | Oct. 1, 2024: 4 @ 349.64; Oct. 23, 2024: 1 @ 349.64; Nov. 28, 2024: 1 @ 337.64 |
| Dec. 6, 2024 | issue | SO-241206-262 | MAIN | 1 | 349.64 | -349.64 | 55 | 18,629.98 | Oct. 1, 2024: 1 @ 349.64 |
| Dec. 4, 2024 | issue | SO-241204-886 | EAST | 4 | 349.64 | -1,398.55 | 56 | 18,979.62 | Oct. 1, 2024: 4 @ 349.64 |
| Nov. 28, 2024 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Nov. 28, 2024 | receipt | PO-000063 | MAIN | 50 | 337.64 | 16,881.80 | 60 | 20,378.18 | |
| Nov. 17, 2024 | issue | SO-241117-135 | MAIN | 12 | 349.64 | -4,195.66 | 10 | 3,496.38 | Oct. 1, 2024: 12 @ 349.64 |
| Nov. 7, 2024 | issue | SO-241107-906 | MAIN | 1 | 349.64 | -349.64 | 22 | 7,692.04 | Oct. 1, 2024: 1 @ 349.64 |
| Nov. 3, 2024 | issue | SO-241103-667 | MAIN | 6 | 349.64 | -2,097.83 | 23 | 8,041.67 | Oct. 1, 2024: 6 @ 349.64 |
| Nov. 2, 2024 | issue | SO-241102-697 | MAIN | 3 | 349.64 | -1,048.91 | 29 | 10,139.50 | Oct. 1, 2024: 3 @ 349.64 |
| Oct. 29, 2024 | issue | SO-241029-798 | MAIN | 3 | 349.64 | -1,048.91 | 32 | 11,188.42 | Oct. 1, 2024: 3 @ 349.64 |
| Oct. 23, 2024 | return | RMA | MAIN | 1 | 349.64 | 349.64 | 35 | 12,237.33 | |
| Oct. 18, 2024 | issue | SO-241018-331 | MAIN | 1 | 349.64 | -349.64 | 34 | 11,887.69 | Oct. 1, 2024: 1 @ 349.64 |
| Oct. 14, 2024 | issue | SO-241014-564 | MAIN | 1 | 349.64 | -349.64 | 35 | 12,237.33 | Oct. 1, 2024: 1 @ 349.64 |
| Oct. 12, 2024 | issue | SO-241012-289 | MAIN | 5 | 349.64 | -1,748.19 | 36 | 12,586.97 | Oct. 1, 2024: 5 @ 349.64 |
| Oct. 10, 2024 | issue | SO-241010-849 | MAIN | 1 | 349.64 | -349.64 | 41 | 14,335.16 | Oct. 1, 2024: 1 @ 349.64 |
| Oct. 1, 2024 | issue | SO-241001-930 | MAIN | 8 | 349.64 | -2,797.10 | 42 | 14,684.80 | Oct. 1, 2024: 8 @ 349.64 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 50 | 349.64 | 17,481.90 | 50 | 17,481.90 | |