Items / CAB-0020
Flexible Cable 3 core Nova CAB-0020 · Cables & Wires · Conduit & Cable Co
On hand (COIL)144MAIN 144
Value (FIFO)10,242.30avg 71.13
ClassAX / FCV 0.23
Turnover11.5xlast issue 0 days ago
Days of cover40lead time 14d
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 | 110.33 / 30.4375 | 3.625 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 25.23 / 5.517 | 4.573 |
| 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.573^2 + 3.625^2 * 3.1^2) | 42.1 |
| Reorder point | d * LT + safety stock | 3.625 * 14.0 + 42.1 | 93.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 93.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1323/yr, S = 45.00, h = 20%, price = 67.31 | 920.0 |
| Inventory position | on hand + on order | 144 + 0 | 144 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 73.16 | 90 | 98,118 | yes |
| 460 | 70.23 | 460 | 96,286 | yes |
| 920 | 67.31 | 920 | 95,311 | yes (chosen if cheapest) |
MOQ 230, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 17, 2026 | 144 / 230 | 71.13 | 10,242.30 |
Movement ledger 119 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-799 | MAIN | 1 | 71.13 | -71.13 | 144 | 10,242.30 | Sept. 17, 2026: 1 @ 71.13 |
| Oct. 9, 2026 | issue | SO-261009-603 | MAIN | 12 | 71.13 | -853.53 | 145 | 10,313.43 | Sept. 17, 2026: 12 @ 71.13 |
| Oct. 4, 2026 | issue | SO-261004-226 | MAIN | 9 | 71.13 | -640.14 | 157 | 11,166.95 | Sept. 17, 2026: 9 @ 71.13 |
| Oct. 2, 2026 | issue | SO-261002-863 | MAIN | 56 | 71.13 | -3,983.12 | 166 | 11,807.10 | Sept. 17, 2026: 56 @ 71.13 |
| Oct. 1, 2026 | issue | SO-261001-709 | MAIN | 34 | 71.05 | -2,415.85 | 222 | 15,790.22 | July 29, 2026: 26 @ 71.03; Sept. 17, 2026: 8 @ 71.13 |
| Sept. 17, 2026 | issue | SO-260917-451 | MAIN | 26 | 71.03 | -1,846.84 | 256 | 18,206.07 | July 29, 2026: 26 @ 71.03 |
| Sept. 17, 2026 | receipt | PO-001807 | MAIN | 230 | 71.13 | 16,359.23 | 282 | 20,052.91 | |
| Sept. 9, 2026 | issue | SO-260909-925 | MAIN | 4 | 71.03 | -284.13 | 52 | 3,693.67 | July 29, 2026: 4 @ 71.03 |
| Sept. 2, 2026 | issue | SO-260902-345 | MAIN | 96 | 71.03 | -6,819.09 | 56 | 3,977.80 | July 29, 2026: 96 @ 71.03 |
| Aug. 26, 2026 | issue | SO-260826-999 | MAIN | 32 | 71.03 | -2,273.03 | 152 | 10,796.89 | July 29, 2026: 32 @ 71.03 |
| Aug. 19, 2026 | issue | SO-260819-341 | MAIN | 32 | 71.03 | -2,273.03 | 184 | 13,069.92 | July 29, 2026: 32 @ 71.03 |
| Aug. 18, 2026 | issue | SO-260818-187 | MAIN | 7 | 71.03 | -497.23 | 216 | 15,342.96 | July 29, 2026: 7 @ 71.03 |
| Aug. 4, 2026 | issue | SO-260804-709 | MAIN | 7 | 71.03 | -497.23 | 223 | 15,840.18 | July 29, 2026: 7 @ 71.03 |
| July 29, 2026 | receipt | PO-001684 | MAIN | 230 | 71.03 | 16,337.41 | 230 | 16,337.41 | |
| July 24, 2026 | issue | SO-260724-341 | MAIN | 12 | 72.35 | -868.21 | 0 | 0.00 | May 29, 2026: 12 @ 72.35 |
| July 23, 2026 | issue | SO-260723-270 | MAIN | 60 | 72.35 | -4,341.07 | 12 | 868.21 | May 29, 2026: 60 @ 72.35 |
| July 18, 2026 | issue | SO-260718-249 | MAIN | 11 | 72.35 | -795.86 | 72 | 5,209.28 | May 29, 2026: 11 @ 72.35 |
| July 16, 2026 | issue | SO-260716-438 | MAIN | 4 | 72.35 | -289.40 | 83 | 6,005.14 | May 29, 2026: 4 @ 72.35 |
| June 25, 2026 | issue | SO-260625-126 | MAIN | 39 | 72.35 | -2,821.69 | 87 | 6,294.55 | May 29, 2026: 39 @ 72.35 |
| June 21, 2026 | issue | SO-260621-815 | MAIN | 31 | 72.35 | -2,242.88 | 126 | 9,116.24 | May 29, 2026: 31 @ 72.35 |
| June 16, 2026 | issue | SO-260616-151 | MAIN | 62 | 72.35 | -4,485.77 | 157 | 11,359.12 | May 29, 2026: 62 @ 72.35 |
| June 3, 2026 | issue | SO-260603-413 | MAIN | 3 | 72.35 | -217.05 | 219 | 15,844.89 | May 29, 2026: 3 @ 72.35 |
| May 31, 2026 | issue | SO-260531-660 | MAIN | 3 | 72.35 | -217.05 | 222 | 16,061.94 | May 29, 2026: 3 @ 72.35 |
| May 29, 2026 | issue | SO-260529-503 | MAIN | 24 | 71.68 | -1,720.22 | 225 | 16,279.00 | March 25, 2026: 19 @ 71.50; May 29, 2026: 5 @ 72.35 |
| May 29, 2026 | receipt | PO-001529 | MAIN | 230 | 72.35 | 16,640.75 | 249 | 17,999.22 | |
| May 17, 2026 | issue | SO-260517-711 | MAIN | 48 | 71.50 | -3,431.91 | 19 | 1,358.46 | March 25, 2026: 48 @ 71.50 |
| May 17, 2026 | issue | SO-260517-711 | EAST | 20 | 71.50 | -1,429.96 | 67 | 4,790.37 | March 25, 2026: 20 @ 71.50 |
| April 29, 2026 | issue | SO-260429-334 | MAIN | 27 | 71.50 | -1,930.45 | 87 | 6,220.33 | March 25, 2026: 27 @ 71.50 |
| April 19, 2026 | issue | SO-260419-297 | MAIN | 127 | 71.28 | -9,052.47 | 114 | 8,150.78 | Feb. 2, 2026: 11 @ 68.97; March 25, 2026: 116 @ 71.50 |
| March 26, 2026 | issue | SO-260326-166 | MAIN | 18 | 68.97 | -1,241.50 | 241 | 17,203.26 | Feb. 2, 2026: 18 @ 68.97 |
| March 25, 2026 | receipt | PO-001350 | MAIN | 230 | 71.50 | 16,444.56 | 259 | 18,444.75 | |
| March 21, 2026 | issue | SO-260321-957 | MAIN | 28 | 68.97 | -1,931.22 | 29 | 2,000.19 | Feb. 2, 2026: 28 @ 68.97 |
| March 16, 2026 | issue | SO-260316-945 | EAST | 28 | 68.97 | -1,931.22 | 57 | 3,931.41 | Feb. 2, 2026: 28 @ 68.97 |
| March 14, 2026 | issue | SO-260314-181 | MAIN | 4 | 68.97 | -275.89 | 85 | 5,862.63 | Feb. 2, 2026: 4 @ 68.97 |
| Feb. 26, 2026 | issue | SO-260226-519 | MAIN | 5 | 68.97 | -344.86 | 89 | 6,138.52 | Feb. 2, 2026: 5 @ 68.97 |
| Feb. 14, 2026 | issue | SO-260214-360 | MAIN | 31 | 68.97 | -2,138.14 | 94 | 6,483.38 | Feb. 2, 2026: 31 @ 68.97 |
| Feb. 5, 2026 | issue | SO-260205-551 | MAIN | 105 | 68.97 | -7,242.07 | 125 | 8,621.51 | Feb. 2, 2026: 105 @ 68.97 |
| Feb. 2, 2026 | transfer | TRF | MAIN → EAST | 48 | warehouse transfer, no cost effect | ||||
| Feb. 2, 2026 | receipt | PO-001193 | MAIN | 230 | 68.97 | 15,863.58 | 230 | 15,863.58 | |
| Jan. 26, 2026 | issue | SO-260126-341 | MAIN | 75 | 72.32 | -5,424.34 | 0 | 0.00 | Nov. 26, 2025: 75 @ 72.32 |
| Jan. 22, 2026 | issue | SO-260122-684 | MAIN | 7 | 72.32 | -506.27 | 75 | 5,424.34 | Nov. 26, 2025: 7 @ 72.32 |
| Jan. 5, 2026 | issue | SO-260105-461 | MAIN | 10 | 72.32 | -723.25 | 82 | 5,930.62 | Nov. 26, 2025: 10 @ 72.32 |
| Dec. 29, 2025 | issue | SO-251229-519 | MAIN | 11 | 72.32 | -795.57 | 92 | 6,653.86 | Nov. 26, 2025: 11 @ 72.32 |
| Dec. 22, 2025 | issue | SO-251222-547 | MAIN | 10 | 72.32 | -723.25 | 103 | 7,449.43 | Nov. 26, 2025: 10 @ 72.32 |
| Dec. 17, 2025 | issue | SO-251217-855 | MAIN | 19 | 72.32 | -1,374.17 | 113 | 8,172.68 | Nov. 26, 2025: 19 @ 72.32 |
| Dec. 15, 2025 | issue | SO-251215-615 | MAIN | 62 | 72.32 | -4,484.13 | 132 | 9,546.85 | Nov. 26, 2025: 62 @ 72.32 |
| Dec. 1, 2025 | issue | SO-251201-987 | MAIN | 27 | 72.32 | -1,952.76 | 194 | 14,030.97 | Nov. 26, 2025: 27 @ 72.32 |
| Nov. 30, 2025 | issue | SO-251130-980 | MAIN | 9 | 72.32 | -650.92 | 221 | 15,983.74 | Nov. 26, 2025: 9 @ 72.32 |
| Nov. 26, 2025 | receipt | PO-001019 | MAIN | 230 | 72.32 | 16,634.66 | 230 | 16,634.66 | |
| Nov. 23, 2025 | issue | SO-251123-291 | MAIN | 26 | 68.50 | -1,780.94 | 0 | 0.00 | Sept. 9, 2025: 26 @ 68.50 |
| Nov. 17, 2025 | issue | SO-251117-957 | MAIN | 5 | 68.50 | -342.49 | 26 | 1,780.94 | Sept. 9, 2025: 5 @ 68.50 |
| Nov. 9, 2025 | issue | SO-251109-815 | MAIN | 52 | 68.50 | -3,561.87 | 31 | 2,123.42 | Sept. 9, 2025: 52 @ 68.50 |
| Oct. 26, 2025 | issue | SO-251026-113 | MAIN | 3 | 68.50 | -205.49 | 83 | 5,685.29 | Sept. 9, 2025: 3 @ 68.50 |
| Oct. 18, 2025 | adjustment | Cycle count | MAIN | -2 | 68.50 | -137.00 | 86 | 5,890.78 | Sept. 9, 2025: 2 @ 68.50 |
| Oct. 15, 2025 | issue | SO-251015-956 | MAIN | 32 | 68.50 | -2,191.92 | 88 | 6,027.78 | Sept. 9, 2025: 32 @ 68.50 |
| Oct. 8, 2025 | issue | SO-251008-164 | MAIN | 82 | 68.50 | -5,616.80 | 120 | 8,219.70 | Sept. 9, 2025: 82 @ 68.50 |
| Sept. 18, 2025 | issue | SO-250918-839 | MAIN | 15 | 68.50 | -1,027.46 | 202 | 13,836.50 | Sept. 9, 2025: 15 @ 68.50 |
| Sept. 10, 2025 | issue | SO-250910-773 | MAIN | 77 | 67.76 | -5,217.44 | 217 | 14,863.96 | July 15, 2025: 64 @ 67.61; Sept. 9, 2025: 13 @ 68.50 |
| Sept. 9, 2025 | receipt | PO-000825 | MAIN | 230 | 68.50 | 15,754.42 | 294 | 20,081.40 | |
| Aug. 26, 2025 | issue | SO-250826-670 | MAIN | 27 | 67.61 | -1,825.44 | 64 | 4,326.98 | July 15, 2025: 27 @ 67.61 |