Items / CAB-0031
Flexible Cable 3 core Nova CAB-0031 · Cables & Wires · Conduit & Cable Co
On hand (COIL)97MAIN 97
Value (FIFO)26,400.89avg 272.17
ClassAX / FCV 0.19
Turnover7.1xlast issue 4 days ago
Days of cover46lead 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 | 64.75 / 30.4375 | 2.127 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.48 / 5.517 | 2.263 |
| 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 * 2.263^2 + 2.127^2 * 3.1^2) | 22.1 |
| Reorder point | d * LT + safety stock | 2.127 * 14.0 + 22.1 | 51.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 51.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 776/yr, S = 45.00, h = 20%, price = 255.63 | 520.0 |
| Inventory position | on hand + on order | 97 + 0 | 97 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 277.86 | 35 | 217,720 | yes |
| 260 | 266.75 | 260 | 214,189 | yes |
| 520 | 255.63 | 520 | 211,850 | yes (chosen if cheapest) |
MOQ 130, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 3, 2026 | 97 / 130 | 272.17 | 26,400.89 |
Movement ledger 136 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-225 | MAIN | 34 | 272.04 | -9,249.23 | 97 | 26,400.89 | July 21, 2026: 1 @ 267.48; Oct. 3, 2026: 33 @ 272.17 |
| Oct. 8, 2026 | issue | SO-261008-106 | MAIN | 7 | 267.48 | -1,872.37 | 131 | 35,650.11 | July 21, 2026: 7 @ 267.48 |
| Oct. 3, 2026 | receipt | PO-001846 | MAIN | 130 | 272.17 | 35,382.63 | 138 | 37,522.48 | |
| Oct. 1, 2026 | issue | SO-261001-870 | MAIN | 8 | 267.48 | -2,139.85 | 8 | 2,139.85 | July 21, 2026: 8 @ 267.48 |
| Sept. 29, 2026 | issue | SO-260929-208 | MAIN | 1 | 267.48 | -267.48 | 16 | 4,279.70 | July 21, 2026: 1 @ 267.48 |
| Sept. 22, 2026 | issue | SO-260922-196 | MAIN | 45 | 267.48 | -12,036.66 | 17 | 4,547.18 | July 21, 2026: 45 @ 267.48 |
| Sept. 14, 2026 | issue | SO-260914-662 | MAIN | 5 | 267.48 | -1,337.41 | 62 | 16,583.84 | July 21, 2026: 5 @ 267.48 |
| Sept. 6, 2026 | issue | SO-260906-931 | MAIN | 15 | 267.48 | -4,012.22 | 67 | 17,921.25 | July 21, 2026: 15 @ 267.48 |
| Aug. 11, 2026 | issue | SO-260811-632 | MAIN | 13 | 267.48 | -3,477.26 | 82 | 21,933.47 | July 21, 2026: 13 @ 267.48 |
| Aug. 3, 2026 | issue | SO-260803-453 | MAIN | 6 | 267.48 | -1,604.89 | 95 | 25,410.72 | July 21, 2026: 6 @ 267.48 |
| Aug. 3, 2026 | issue | SO-260803-453 | EAST | 46 | 268.11 | -12,333.17 | 101 | 27,015.61 | June 1, 2026: 17 @ 269.19; July 21, 2026: 29 @ 267.48 |
| July 29, 2026 | issue | SO-260729-799 | EAST | 8 | 269.19 | -2,153.51 | 147 | 39,348.78 | June 1, 2026: 8 @ 269.19 |
| July 21, 2026 | transfer | TRF | MAIN → EAST | 39 | warehouse transfer, no cost effect | ||||
| July 21, 2026 | receipt | PO-001658 | MAIN | 130 | 267.48 | 34,772.57 | 155 | 41,502.29 | |
| July 20, 2026 | issue | SO-260720-367 | MAIN | 4 | 269.19 | -1,076.76 | 25 | 6,729.72 | June 1, 2026: 4 @ 269.19 |
| July 5, 2026 | issue | SO-260705-778 | MAIN | 1 | 269.19 | -269.19 | 29 | 7,806.48 | June 1, 2026: 1 @ 269.19 |
| July 2, 2026 | issue | SO-260702-189 | MAIN | 30 | 269.19 | -8,075.67 | 30 | 8,075.67 | June 1, 2026: 30 @ 269.19 |
| July 1, 2026 | issue | SO-260701-735 | EAST | 2 | 269.19 | -538.38 | 60 | 16,151.34 | June 1, 2026: 2 @ 269.19 |
| June 26, 2026 | issue | SO-260626-775 | MAIN | 21 | 269.19 | -5,652.97 | 62 | 16,689.72 | June 1, 2026: 21 @ 269.19 |
| June 22, 2026 | issue | SO-260622-654 | MAIN | 4 | 269.19 | -1,076.76 | 83 | 22,342.69 | June 1, 2026: 4 @ 269.19 |
| June 21, 2026 | issue | SO-260621-200 | MAIN | 5 | 269.19 | -1,345.94 | 87 | 23,419.44 | June 1, 2026: 5 @ 269.19 |
| June 13, 2026 | issue | SO-260613-947 | MAIN | 13 | 269.19 | -3,499.46 | 92 | 24,765.39 | June 1, 2026: 13 @ 269.19 |
| June 12, 2026 | issue | SO-260612-581 | MAIN | 6 | 269.19 | -1,615.13 | 105 | 28,264.84 | June 1, 2026: 6 @ 269.19 |
| June 11, 2026 | issue | SO-260611-403 | MAIN | 9 | 269.19 | -2,422.70 | 111 | 29,879.98 | June 1, 2026: 9 @ 269.19 |
| June 5, 2026 | issue | SO-260605-451 | EAST | 10 | 269.19 | -2,691.89 | 120 | 32,302.68 | June 1, 2026: 10 @ 269.19 |
| June 1, 2026 | transfer | TRF | MAIN → EAST | 27 | warehouse transfer, no cost effect | ||||
| June 1, 2026 | receipt | PO-001538 | MAIN | 130 | 269.19 | 34,994.57 | 130 | 34,994.57 | |
| May 23, 2026 | issue | SO-260523-910 | MAIN | 5 | 278.43 | -1,392.13 | 0 | 0.00 | March 17, 2026: 5 @ 278.43 |
| May 18, 2026 | issue | SO-260518-513 | MAIN | 17 | 278.43 | -4,733.26 | 5 | 1,392.13 | March 17, 2026: 17 @ 278.43 |
| May 9, 2026 | issue | SO-260509-958 | MAIN | 32 | 278.43 | -8,909.66 | 22 | 6,125.39 | March 17, 2026: 32 @ 278.43 |
| April 27, 2026 | issue | SO-260427-654 | MAIN | 6 | 278.43 | -1,670.56 | 54 | 15,035.05 | March 17, 2026: 6 @ 278.43 |
| April 18, 2026 | issue | SO-260418-188 | MAIN | 5 | 278.43 | -1,392.13 | 60 | 16,705.61 | March 17, 2026: 5 @ 278.43 |
| April 18, 2026 | issue | SO-260418-188 | EAST | 35 | 278.43 | -9,744.94 | 65 | 18,097.74 | March 17, 2026: 35 @ 278.43 |
| April 6, 2026 | issue | SO-260406-166 | MAIN | 34 | 276.68 | -9,407.03 | 100 | 27,842.68 | Feb. 7, 2026: 4 @ 263.56; March 17, 2026: 30 @ 278.43 |
| April 3, 2026 | issue | SO-260403-581 | EAST | 2 | 263.56 | -527.11 | 134 | 37,249.71 | Feb. 7, 2026: 2 @ 263.56 |
| April 2, 2026 | issue | SO-260402-331 | MAIN | 4 | 263.56 | -1,054.23 | 136 | 37,776.82 | Feb. 7, 2026: 4 @ 263.56 |
| March 30, 2026 | issue | SO-260330-765 | MAIN | 27 | 263.56 | -7,116.03 | 140 | 38,831.05 | Feb. 7, 2026: 27 @ 263.56 |
| March 17, 2026 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| March 17, 2026 | receipt | PO-001326 | MAIN | 130 | 278.43 | 36,195.48 | 167 | 45,947.08 | |
| March 5, 2026 | issue | SO-260305-873 | MAIN | 45 | 263.56 | -11,860.05 | 37 | 9,751.59 | Feb. 7, 2026: 45 @ 263.56 |
| Feb. 22, 2026 | issue | SO-260222-881 | MAIN | 21 | 263.56 | -5,534.69 | 82 | 21,611.64 | Feb. 7, 2026: 21 @ 263.56 |
| Feb. 20, 2026 | issue | SO-260220-273 | MAIN | 33 | 264.34 | -8,723.29 | 103 | 27,146.33 | Nov. 27, 2025: 6 @ 267.88; Feb. 7, 2026: 27 @ 263.56 |
| Feb. 14, 2026 | issue | SO-260214-943 | MAIN | 3 | 267.88 | -803.63 | 136 | 35,869.62 | Nov. 27, 2025: 3 @ 267.88 |
| Feb. 14, 2026 | issue | SO-260214-943 | EAST | 11 | 267.88 | -2,946.64 | 139 | 36,673.25 | Nov. 27, 2025: 11 @ 267.88 |
| Feb. 12, 2026 | issue | SO-260212-750 | MAIN | 3 | 267.88 | -803.63 | 150 | 39,619.89 | Nov. 27, 2025: 3 @ 267.88 |
| Feb. 7, 2026 | receipt | PO-001206 | MAIN | 130 | 263.56 | 34,262.36 | 153 | 40,423.52 | |
| Jan. 26, 2026 | issue | SO-260126-606 | MAIN | 39 | 267.88 | -10,447.18 | 23 | 6,161.16 | Nov. 27, 2025: 39 @ 267.88 |
| Jan. 16, 2026 | issue | SO-260116-657 | MAIN | 2 | 267.88 | -535.75 | 62 | 16,608.34 | Nov. 27, 2025: 2 @ 267.88 |
| Jan. 10, 2026 | issue | SO-260110-340 | EAST | 10 | 267.88 | -2,678.76 | 64 | 17,144.09 | Nov. 27, 2025: 10 @ 267.88 |
| Jan. 6, 2026 | issue | SO-260106-364 | EAST | 12 | 267.88 | -3,214.52 | 74 | 19,822.85 | Nov. 27, 2025: 12 @ 267.88 |
| Jan. 5, 2026 | issue | SO-260105-950 | MAIN | 8 | 267.88 | -2,143.01 | 86 | 23,037.37 | Nov. 27, 2025: 8 @ 267.88 |
| Jan. 3, 2026 | issue | SO-260103-171 | MAIN | 3 | 267.88 | -803.63 | 94 | 25,180.38 | Nov. 27, 2025: 3 @ 267.88 |
| Dec. 31, 2025 | issue | SO-251231-315 | EAST | 5 | 267.88 | -1,339.38 | 97 | 25,984.01 | Nov. 27, 2025: 5 @ 267.88 |
| Dec. 27, 2025 | issue | SO-251227-987 | MAIN | 26 | 267.88 | -6,964.79 | 102 | 27,323.39 | Nov. 27, 2025: 26 @ 267.88 |
| Dec. 19, 2025 | issue | SO-251219-627 | MAIN | 33 | 271.66 | -8,964.64 | 128 | 34,288.18 | Oct. 9, 2025: 31 @ 271.90; Nov. 27, 2025: 2 @ 267.88 |
| Dec. 17, 2025 | issue | SO-251217-788 | MAIN | 2 | 271.90 | -543.80 | 161 | 43,252.82 | Oct. 9, 2025: 2 @ 271.90 |
| Dec. 14, 2025 | issue | SO-251214-262 | MAIN | 8 | 271.90 | -2,175.20 | 163 | 43,796.62 | Oct. 9, 2025: 8 @ 271.90 |
| Dec. 9, 2025 | issue | SO-251209-538 | EAST | 2 | 271.90 | -543.80 | 171 | 45,971.81 | Oct. 9, 2025: 2 @ 271.90 |
| Nov. 27, 2025 | transfer | TRF | MAIN → EAST | 40 | warehouse transfer, no cost effect | ||||
| Nov. 27, 2025 | receipt | PO-001022 | MAIN | 130 | 267.88 | 34,823.93 | 173 | 46,515.61 | |