Items / CAB-0025
Flexible Cable 3 core Nova CAB-0025 · Cables & Wires · Conduit & Cable Co
On hand (COIL)22MAIN 22
Value (FIFO)934.84avg 42.49
ClassBX / FCV 0.16
Turnover34.2xlast issue 5 days ago
Days of cover12lead time 14d
Reorder suggested: 480 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 | 57.17 / 30.4375 | 1.878 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.16 / 5.517 | 1.661 |
| 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 * 1.661^2 + 1.878^2 * 3.1^2) | 14.0 |
| Reorder point | d * LT + safety stock | 1.878 * 14.0 + 14.0 | 40.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 40.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 686/yr, S = 45.00, h = 20%, price = 39.48 | 480.0 |
| Inventory position | on hand + on order | 22 + 0 | 22 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 42.91 | 85 | 30,144 | yes |
| 240 | 41.19 | 240 | 29,357 | yes |
| 480 | 39.48 | 480 | 29,022 | yes (chosen if cheapest) |
MOQ 120, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 28, 2026 | 15 / 120 | 42.49 | 637.39 | |
| Sept. 25, 2026 | 7 / 7 | 42.49 | 297.45 |
Movement ledger 139 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-458 | MAIN | 21 | 42.49 | -892.35 | 22 | 934.84 | Aug. 28, 2026: 21 @ 42.49 |
| Oct. 10, 2026 | issue | SO-261010-208 | MAIN | 11 | 42.49 | -467.42 | 43 | 1,827.19 | Aug. 28, 2026: 11 @ 42.49 |
| Oct. 7, 2026 | issue | SO-261007-898 | MAIN | 25 | 42.49 | -1,062.32 | 54 | 2,294.62 | Aug. 28, 2026: 25 @ 42.49 |
| Sept. 25, 2026 | return | RMA | MAIN | 7 | 42.49 | 297.45 | 79 | 3,356.94 | |
| Sept. 24, 2026 | issue | SO-260924-268 | MAIN | 1 | 42.49 | -42.49 | 72 | 3,059.49 | Aug. 28, 2026: 1 @ 42.49 |
| Sept. 21, 2026 | issue | SO-260921-399 | MAIN | 13 | 42.49 | -552.41 | 73 | 3,101.98 | Aug. 28, 2026: 13 @ 42.49 |
| Sept. 20, 2026 | issue | SO-260920-433 | MAIN | 14 | 42.49 | -594.90 | 86 | 3,654.39 | Aug. 28, 2026: 14 @ 42.49 |
| Sept. 17, 2026 | issue | SO-260917-141 | MAIN | 15 | 42.49 | -637.39 | 100 | 4,249.29 | Aug. 28, 2026: 15 @ 42.49 |
| Sept. 4, 2026 | issue | SO-260904-290 | MAIN | 10 | 42.73 | -427.33 | 115 | 4,886.68 | June 24, 2026: 5 @ 42.97; Aug. 28, 2026: 5 @ 42.49 |
| Sept. 1, 2026 | issue | SO-260901-357 | MAIN | 23 | 42.97 | -988.37 | 125 | 5,314.01 | June 24, 2026: 23 @ 42.97 |
| Aug. 29, 2026 | issue | SO-260829-924 | MAIN | 6 | 42.97 | -257.84 | 148 | 6,302.39 | June 24, 2026: 6 @ 42.97 |
| Aug. 28, 2026 | receipt | PO-001752 | MAIN | 120 | 42.49 | 5,099.15 | 154 | 6,560.22 | |
| Aug. 24, 2026 | issue | SO-260824-653 | MAIN | 1 | 42.97 | -42.97 | 34 | 1,461.08 | June 24, 2026: 1 @ 42.97 |
| Aug. 14, 2026 | issue | SO-260814-794 | MAIN | 37 | 42.97 | -1,589.99 | 35 | 1,504.05 | June 24, 2026: 37 @ 42.97 |
| July 30, 2026 | issue | SO-260730-431 | MAIN | 8 | 42.97 | -343.78 | 72 | 3,094.04 | June 24, 2026: 8 @ 42.97 |
| July 23, 2026 | issue | SO-260723-608 | MAIN | 9 | 42.97 | -386.76 | 80 | 3,437.82 | June 24, 2026: 9 @ 42.97 |
| July 22, 2026 | issue | SO-260722-850 | MAIN | 1 | 42.97 | -42.97 | 89 | 3,824.58 | June 24, 2026: 1 @ 42.97 |
| July 21, 2026 | issue | SO-260721-160 | MAIN | 6 | 42.97 | -257.84 | 90 | 3,867.55 | June 24, 2026: 6 @ 42.97 |
| July 21, 2026 | issue | SO-260721-160 | EAST | 6 | 42.97 | -257.84 | 96 | 4,125.39 | June 24, 2026: 6 @ 42.97 |
| July 8, 2026 | issue | SO-260708-570 | MAIN | 7 | 42.97 | -300.81 | 102 | 4,383.23 | June 24, 2026: 7 @ 42.97 |
| July 7, 2026 | issue | SO-260707-235 | MAIN | 22 | 41.96 | -923.03 | 109 | 4,684.04 | April 22, 2026: 11 @ 40.94; June 24, 2026: 11 @ 42.97 |
| July 1, 2026 | issue | SO-260701-826 | MAIN | 5 | 40.94 | -204.69 | 131 | 5,607.06 | April 22, 2026: 5 @ 40.94 |
| June 24, 2026 | receipt | PO-001599 | MAIN | 120 | 42.97 | 5,156.74 | 136 | 5,811.75 | |
| June 20, 2026 | issue | SO-260620-415 | MAIN | 11 | 40.94 | -450.32 | 16 | 655.02 | April 22, 2026: 11 @ 40.94 |
| June 9, 2026 | issue | SO-260609-529 | EAST | 23 | 40.94 | -941.59 | 27 | 1,105.34 | April 22, 2026: 23 @ 40.94 |
| June 7, 2026 | issue | SO-260607-142 | MAIN | 10 | 40.94 | -409.39 | 50 | 2,046.93 | April 22, 2026: 10 @ 40.94 |
| June 6, 2026 | issue | SO-260606-184 | MAIN | 6 | 40.94 | -245.63 | 60 | 2,456.32 | April 22, 2026: 6 @ 40.94 |
| May 30, 2026 | issue | SO-260530-540 | EAST | 1 | 40.94 | -40.94 | 66 | 2,701.95 | April 22, 2026: 1 @ 40.94 |
| May 25, 2026 | issue | SO-260525-366 | MAIN | 22 | 40.94 | -900.65 | 67 | 2,742.89 | April 22, 2026: 22 @ 40.94 |
| May 20, 2026 | issue | SO-260520-949 | MAIN | 8 | 40.94 | -327.51 | 89 | 3,643.54 | April 22, 2026: 8 @ 40.94 |
| May 19, 2026 | issue | SO-260519-402 | MAIN | 5 | 40.94 | -204.69 | 97 | 3,971.04 | April 22, 2026: 5 @ 40.94 |
| May 9, 2026 | issue | SO-260509-475 | MAIN | 1 | 40.94 | -40.94 | 102 | 4,175.74 | April 22, 2026: 1 @ 40.94 |
| May 6, 2026 | issue | SO-260506-106 | MAIN | 28 | 40.90 | -1,145.20 | 103 | 4,216.68 | Feb. 27, 2026: 11 @ 40.84; April 22, 2026: 17 @ 40.94 |
| April 22, 2026 | issue | SO-260422-492 | MAIN | 14 | 40.84 | -571.77 | 131 | 5,361.88 | Feb. 27, 2026: 14 @ 40.84 |
| April 22, 2026 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| April 22, 2026 | receipt | PO-001430 | MAIN | 120 | 40.94 | 4,912.63 | 145 | 5,933.65 | |
| April 12, 2026 | issue | SO-260412-103 | MAIN | 2 | 40.84 | -81.68 | 25 | 1,021.02 | Feb. 27, 2026: 2 @ 40.84 |
| April 11, 2026 | issue | SO-260411-133 | MAIN | 39 | 40.84 | -1,592.78 | 27 | 1,102.70 | Feb. 27, 2026: 39 @ 40.84 |
| April 1, 2026 | issue | SO-260401-120 | MAIN | 6 | 40.84 | -245.04 | 66 | 2,695.48 | Feb. 27, 2026: 6 @ 40.84 |
| March 20, 2026 | issue | SO-260320-585 | MAIN | 1 | 40.84 | -40.84 | 72 | 2,940.52 | Feb. 27, 2026: 1 @ 40.84 |
| March 11, 2026 | issue | SO-260311-768 | MAIN | 7 | 40.84 | -285.88 | 73 | 2,981.36 | Feb. 27, 2026: 7 @ 40.84 |
| March 7, 2026 | issue | SO-260307-920 | MAIN | 34 | 40.84 | -1,388.58 | 80 | 3,267.25 | Feb. 27, 2026: 34 @ 40.84 |
| March 2, 2026 | issue | SO-260302-211 | MAIN | 11 | 41.16 | -452.74 | 114 | 4,655.83 | Dec. 31, 2025: 5 @ 41.54; Feb. 27, 2026: 6 @ 40.84 |
| March 1, 2026 | issue | SO-260301-597 | MAIN | 9 | 41.54 | -373.86 | 125 | 5,108.57 | Dec. 31, 2025: 9 @ 41.54 |
| Feb. 27, 2026 | receipt | PO-001264 | MAIN | 120 | 40.84 | 4,900.87 | 134 | 5,482.43 | |
| Feb. 14, 2026 | issue | SO-260214-818 | MAIN | 39 | 41.54 | -1,620.05 | 14 | 581.56 | Dec. 31, 2025: 39 @ 41.54 |
| Feb. 3, 2026 | issue | SO-260203-588 | MAIN | 30 | 41.54 | -1,246.19 | 53 | 2,201.60 | Dec. 31, 2025: 30 @ 41.54 |
| Jan. 26, 2026 | issue | SO-260126-291 | MAIN | 45 | 41.52 | -1,868.59 | 83 | 3,447.80 | Dec. 7, 2025: 8 @ 41.45; Dec. 31, 2025: 37 @ 41.54 |
| Jan. 13, 2026 | issue | SO-260113-235 | MAIN | 10 | 41.45 | -414.52 | 128 | 5,316.38 | Oct. 29, 2025: 10 @ 41.45 |
| Jan. 4, 2026 | issue | SO-260104-457 | MAIN | 4 | 41.45 | -165.81 | 138 | 5,730.91 | Oct. 29, 2025: 4 @ 41.45 |
| Dec. 31, 2025 | receipt | PO-001107 | MAIN | 120 | 41.54 | 4,984.76 | 142 | 5,896.72 | |
| Dec. 29, 2025 | issue | SO-251229-257 | MAIN | 3 | 41.45 | -124.36 | 22 | 911.95 | Oct. 29, 2025: 3 @ 41.45 |
| Dec. 24, 2025 | issue | SO-251224-336 | MAIN | 1 | 41.45 | -41.45 | 25 | 1,036.31 | Oct. 29, 2025: 1 @ 41.45 |
| Dec. 22, 2025 | issue | SO-251222-157 | MAIN | 21 | 41.45 | -870.50 | 26 | 1,077.76 | Oct. 29, 2025: 21 @ 41.45 |
| Dec. 20, 2025 | issue | SO-251220-877 | MAIN | 17 | 41.45 | -704.69 | 47 | 1,948.26 | Oct. 29, 2025: 17 @ 41.45 |
| Dec. 20, 2025 | issue | SO-251220-877 | EAST | 12 | 41.45 | -497.43 | 64 | 2,652.95 | Oct. 29, 2025: 12 @ 41.45 |
| Dec. 7, 2025 | return | RMA | MAIN | 8 | 41.45 | 331.62 | 76 | 3,150.38 | |
| Dec. 1, 2025 | issue | SO-251201-157 | EAST | 9 | 41.45 | -373.07 | 68 | 2,818.76 | Oct. 29, 2025: 9 @ 41.45 |
| Nov. 29, 2025 | issue | SO-251129-831 | MAIN | 23 | 41.45 | -953.41 | 77 | 3,191.83 | Oct. 29, 2025: 23 @ 41.45 |
| Nov. 24, 2025 | issue | SO-251124-482 | EAST | 16 | 41.45 | -663.24 | 100 | 4,145.24 | Oct. 29, 2025: 16 @ 41.45 |