Items / CAB-0019
Flexible Cable 3 core Prime CAB-0019 · Cables & Wires · Conduit & Cable Co
On hand (COIL)75MAIN 75
Value (FIFO)27,815.19avg 370.87
ClassAX / FCV 0.21
Turnover10.8xlast issue 6 days ago
Days of cover18lead time 14d
Reorder suggested: 960 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 | 125.83 / 30.4375 | 4.134 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 26.83 / 5.517 | 4.862 |
| 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 * 4.862^2 + 4.134^2 * 3.1^2) | 45.8 |
| Reorder point | d * LT + safety stock | 4.134 * 14.0 + 45.8 | 103.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 103.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1509/yr, S = 45.00, h = 20%, price = 347.52 | 960.0 |
| Inventory position | on hand + on order | 75 + 0 | 75 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 377.74 | 42 | 573,200 | yes |
| 480 | 362.63 | 480 | 564,745 | yes |
| 960 | 347.52 | 960 | 557,830 | yes (chosen if cheapest) |
MOQ 240, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 14, 2026 | 75 / 240 | 370.87 | 27,815.19 |
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. 10, 2026 | issue | SO-261010-419 | MAIN | 44 | 370.87 | -16,318.24 | 75 | 27,815.19 | Sept. 14, 2026: 44 @ 370.87 |
| Oct. 8, 2026 | issue | SO-261008-416 | MAIN | 77 | 370.87 | -28,556.93 | 119 | 44,133.43 | Sept. 14, 2026: 77 @ 370.87 |
| Oct. 5, 2026 | issue | SO-261005-265 | MAIN | 4 | 370.87 | -1,483.48 | 196 | 72,690.36 | Sept. 14, 2026: 4 @ 370.87 |
| Sept. 29, 2026 | issue | SO-260929-674 | MAIN | 47 | 371.31 | -17,451.41 | 200 | 74,173.84 | July 23, 2026: 7 @ 373.81; Sept. 14, 2026: 40 @ 370.87 |
| Sept. 14, 2026 | receipt | PO-001799 | MAIN | 240 | 370.87 | 89,008.61 | 247 | 91,625.25 | |
| Sept. 12, 2026 | issue | SO-260912-621 | MAIN | 16 | 373.81 | -5,980.91 | 7 | 2,616.65 | July 23, 2026: 16 @ 373.81 |
| Aug. 28, 2026 | issue | SO-260828-529 | MAIN | 30 | 373.81 | -11,214.20 | 23 | 8,597.55 | July 23, 2026: 30 @ 373.81 |
| Aug. 28, 2026 | issue | SO-260828-529 | EAST | 16 | 373.81 | -5,980.91 | 53 | 19,811.75 | July 23, 2026: 16 @ 373.81 |
| Aug. 27, 2026 | issue | SO-260827-736 | EAST | 53 | 373.81 | -19,811.75 | 69 | 25,792.66 | July 23, 2026: 53 @ 373.81 |
| Aug. 22, 2026 | issue | SO-260822-767 | MAIN | 40 | 373.81 | -14,952.26 | 122 | 45,604.41 | July 23, 2026: 40 @ 373.81 |
| Aug. 17, 2026 | issue | SO-260817-283 | MAIN | 12 | 373.81 | -4,485.68 | 162 | 60,556.67 | July 23, 2026: 12 @ 373.81 |
| July 29, 2026 | issue | SO-260729-425 | MAIN | 65 | 373.81 | -24,297.43 | 174 | 65,042.35 | July 23, 2026: 65 @ 373.81 |
| July 27, 2026 | issue | SO-260727-742 | EAST | 12 | 381.01 | -4,572.15 | 239 | 89,339.78 | May 17, 2026: 11 @ 381.67; July 23, 2026: 1 @ 373.81 |
| July 24, 2026 | issue | SO-260724-804 | MAIN | 70 | 381.67 | -26,716.76 | 251 | 93,911.93 | May 17, 2026: 70 @ 381.67 |
| July 23, 2026 | receipt | PO-001664 | MAIN | 240 | 373.81 | 89,713.58 | 321 | 120,628.69 | |
| July 7, 2026 | issue | SO-260707-580 | EAST | 11 | 381.67 | -4,198.35 | 81 | 30,915.11 | May 17, 2026: 11 @ 381.67 |
| June 23, 2026 | issue | SO-260623-738 | EAST | 19 | 381.67 | -7,251.69 | 92 | 35,113.46 | May 17, 2026: 19 @ 381.67 |
| June 23, 2026 | issue | SO-260623-738 | MAIN | 48 | 381.67 | -18,320.06 | 111 | 42,365.15 | May 17, 2026: 48 @ 381.67 |
| June 22, 2026 | issue | SO-260622-336 | MAIN | 8 | 381.67 | -3,053.34 | 159 | 60,685.21 | May 17, 2026: 8 @ 381.67 |
| June 5, 2026 | issue | SO-260605-741 | MAIN | 25 | 381.67 | -9,541.70 | 167 | 63,738.56 | May 17, 2026: 25 @ 381.67 |
| May 29, 2026 | issue | SO-260529-590 | MAIN | 8 | 381.67 | -3,053.34 | 192 | 73,280.26 | May 17, 2026: 8 @ 381.67 |
| May 17, 2026 | issue | SO-260517-390 | MAIN | 99 | 370.03 | -36,633.28 | 200 | 76,333.60 | March 27, 2026: 59 @ 362.15; May 17, 2026: 40 @ 381.67 |
| May 17, 2026 | transfer | TRF | MAIN → EAST | 59 | warehouse transfer, no cost effect | ||||
| May 17, 2026 | receipt | PO-001501 | MAIN | 240 | 381.67 | 91,600.32 | 299 | 112,966.88 | |
| May 3, 2026 | issue | SO-260503-642 | MAIN | 35 | 362.15 | -12,675.08 | 59 | 21,366.56 | March 27, 2026: 35 @ 362.15 |
| April 30, 2026 | issue | SO-260430-834 | MAIN | 56 | 362.15 | -20,280.13 | 94 | 34,041.64 | March 27, 2026: 56 @ 362.15 |
| April 27, 2026 | issue | SO-260427-904 | EAST | 19 | 362.15 | -6,880.76 | 150 | 54,321.76 | March 27, 2026: 19 @ 362.15 |
| April 22, 2026 | issue | SO-260422-483 | MAIN | 5 | 362.15 | -1,810.73 | 169 | 61,202.52 | March 27, 2026: 5 @ 362.15 |
| April 21, 2026 | issue | SO-260421-773 | MAIN | 41 | 362.15 | -14,847.95 | 174 | 63,013.25 | March 27, 2026: 41 @ 362.15 |
| April 20, 2026 | issue | SO-260420-991 | MAIN | 3 | 362.15 | -1,086.44 | 215 | 77,861.20 | March 27, 2026: 3 @ 362.15 |
| April 18, 2026 | issue | SO-260418-622 | MAIN | 1 | 362.15 | -362.15 | 218 | 78,947.63 | March 27, 2026: 1 @ 362.15 |
| April 6, 2026 | issue | SO-260406-560 | MAIN | 1 | 362.15 | -362.15 | 219 | 79,309.78 | March 27, 2026: 1 @ 362.15 |
| March 30, 2026 | issue | SO-260330-975 | MAIN | 77 | 369.76 | -28,471.78 | 220 | 79,671.92 | Jan. 17, 2026: 57 @ 372.44; March 27, 2026: 20 @ 362.15 |
| March 27, 2026 | transfer | TRF | MAIN → EAST | 71 | warehouse transfer, no cost effect | ||||
| March 27, 2026 | receipt | PO-001359 | MAIN | 240 | 362.15 | 86,914.82 | 297 | 108,143.70 | |
| March 13, 2026 | issue | SO-260313-987 | MAIN | 46 | 372.44 | -17,132.08 | 57 | 21,228.88 | Jan. 17, 2026: 46 @ 372.44 |
| March 13, 2026 | issue | SO-260313-987 | EAST | 27 | 372.44 | -10,055.79 | 103 | 38,360.96 | Jan. 17, 2026: 27 @ 372.44 |
| March 7, 2026 | issue | SO-260307-579 | MAIN | 7 | 372.44 | -2,607.06 | 130 | 48,416.74 | Jan. 17, 2026: 7 @ 372.44 |
| Feb. 22, 2026 | issue | SO-260222-575 | EAST | 43 | 372.44 | -16,014.77 | 137 | 51,023.80 | Jan. 17, 2026: 43 @ 372.44 |
| Feb. 19, 2026 | issue | SO-260219-936 | MAIN | 20 | 372.44 | -7,448.73 | 180 | 67,038.57 | Jan. 17, 2026: 20 @ 372.44 |
| Feb. 15, 2026 | issue | SO-260215-647 | MAIN | 14 | 372.44 | -5,214.11 | 200 | 74,487.30 | Jan. 17, 2026: 14 @ 372.44 |
| Feb. 14, 2026 | issue | SO-260214-685 | MAIN | 1 | 372.44 | -372.44 | 214 | 79,701.41 | Jan. 17, 2026: 1 @ 372.44 |
| Feb. 13, 2026 | issue | SO-260213-186 | EAST | 9 | 372.44 | -3,351.93 | 215 | 80,073.85 | Jan. 17, 2026: 9 @ 372.44 |
| Feb. 7, 2026 | issue | SO-260207-594 | MAIN | 41 | 368.10 | -15,092.30 | 224 | 83,425.78 | Nov. 24, 2025: 25 @ 365.33; Jan. 17, 2026: 16 @ 372.44 |
| Jan. 27, 2026 | issue | SO-260127-186 | MAIN | 26 | 365.33 | -9,498.65 | 265 | 98,518.08 | Nov. 24, 2025: 26 @ 365.33 |
| Jan. 17, 2026 | transfer | TRF | MAIN → EAST | 79 | warehouse transfer, no cost effect | ||||
| Jan. 17, 2026 | receipt | PO-001151 | MAIN | 240 | 372.44 | 89,384.76 | 291 | 108,016.73 | |
| Jan. 10, 2026 | issue | SO-260110-710 | MAIN | 7 | 365.33 | -2,557.33 | 51 | 18,631.97 | Nov. 24, 2025: 7 @ 365.33 |
| Jan. 2, 2026 | issue | SO-260102-107 | MAIN | 60 | 365.33 | -21,919.96 | 58 | 21,189.30 | Nov. 24, 2025: 60 @ 365.33 |
| Jan. 1, 2026 | issue | SO-260101-133 | MAIN | 27 | 365.33 | -9,863.98 | 118 | 43,109.26 | Nov. 24, 2025: 27 @ 365.33 |
| Dec. 29, 2025 | issue | SO-251229-930 | MAIN | 58 | 365.33 | -21,189.30 | 145 | 52,973.24 | Nov. 24, 2025: 58 @ 365.33 |
| Dec. 5, 2025 | issue | SO-251205-583 | MAIN | 38 | 365.40 | -13,885.32 | 203 | 74,162.54 | Oct. 3, 2025: 1 @ 368.01; Nov. 24, 2025: 37 @ 365.33 |
| Nov. 24, 2025 | receipt | PO-001017 | MAIN | 240 | 365.33 | 87,679.85 | 241 | 88,047.86 | |
| Nov. 9, 2025 | issue | SO-251109-562 | MAIN | 30 | 368.01 | -11,040.31 | 1 | 368.01 | Oct. 3, 2025: 30 @ 368.01 |
| Nov. 7, 2025 | issue | SO-251107-889 | MAIN | 109 | 368.01 | -40,113.12 | 31 | 11,408.32 | Oct. 3, 2025: 109 @ 368.01 |
| Oct. 31, 2025 | issue | SO-251031-378 | MAIN | 8 | 368.01 | -2,944.08 | 140 | 51,521.44 | Oct. 3, 2025: 8 @ 368.01 |
| Oct. 30, 2025 | issue | SO-251030-948 | MAIN | 36 | 368.01 | -13,248.37 | 148 | 54,465.52 | Oct. 3, 2025: 36 @ 368.01 |
| Oct. 27, 2025 | issue | SO-251027-458 | MAIN | 13 | 368.01 | -4,784.13 | 184 | 67,713.90 | Oct. 3, 2025: 13 @ 368.01 |
| Oct. 23, 2025 | issue | SO-251023-843 | MAIN | 22 | 368.01 | -8,096.23 | 197 | 72,498.03 | Oct. 3, 2025: 22 @ 368.01 |
| Oct. 11, 2025 | issue | SO-251011-884 | MAIN | 51 | 368.70 | -18,803.84 | 219 | 80,594.26 | July 31, 2025: 30 @ 369.19; Oct. 3, 2025: 21 @ 368.01 |