Items / CAB-0029
FR Wire 2.5 sqmm Plus CAB-0029 · Cables & Wires · Conduit & Cable Co
On hand (COIL)41MAIN 24, EAST 17
Value (FIFO)1,762.96avg 43.00
ClassBX / FCV 0.18
Turnover9.4xlast issue 0 days ago
Days of cover62lead 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 | 20.17 / 30.4375 | 0.663 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.69 / 5.517 | 0.669 |
| 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 * 0.669^2 + 0.663^2 * 3.1^2) | 5.3 |
| Reorder point | d * LT + safety stock | 0.663 * 14.0 + 5.3 | 14.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 14.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 242/yr, S = 45.00, h = 20%, price = 41.99 | 50.9 |
| Inventory position | on hand + on order | 41 + 0 | 41 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 41.99 | 51 | 10,582 | yes (chosen if cheapest) |
MOQ 50, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 15, 2026 | 41 / 50 | 43.00 | 1,762.96 |
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. 16, 2026 | issue | SO-261016-506 | MAIN | 12 | 42.55 | -510.61 | 41 | 1,762.96 | Sept. 30, 2026: 3 @ 41.21; Oct. 15, 2026: 9 @ 43.00 |
| Oct. 15, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Oct. 15, 2026 | receipt | PO-001881 | MAIN | 50 | 43.00 | 2,149.95 | 53 | 2,273.57 | |
| Oct. 8, 2026 | issue | SO-261008-200 | MAIN | 3 | 41.21 | -123.62 | 3 | 123.62 | Aug. 17, 2026: 3 @ 41.21 |
| Oct. 6, 2026 | issue | SO-261006-931 | MAIN | 10 | 41.21 | -412.07 | 6 | 247.24 | Aug. 17, 2026: 10 @ 41.21 |
| Oct. 2, 2026 | issue | SO-261002-370 | MAIN | 1 | 41.21 | -41.21 | 16 | 659.31 | Aug. 17, 2026: 1 @ 41.21 |
| Oct. 1, 2026 | issue | SO-261001-556 | MAIN | 9 | 41.21 | -370.86 | 17 | 700.52 | Aug. 17, 2026: 9 @ 41.21 |
| Sept. 30, 2026 | return | RMA | MAIN | 3 | 41.21 | 123.62 | 26 | 1,071.38 | |
| Sept. 24, 2026 | issue | SO-260924-147 | MAIN | 5 | 41.21 | -206.03 | 23 | 947.76 | Aug. 17, 2026: 5 @ 41.21 |
| Sept. 20, 2026 | issue | SO-260920-758 | EAST | 1 | 41.21 | -41.21 | 28 | 1,153.79 | Aug. 17, 2026: 1 @ 41.21 |
| Sept. 18, 2026 | issue | SO-260918-983 | MAIN | 6 | 41.21 | -247.24 | 29 | 1,195.00 | Aug. 17, 2026: 6 @ 41.21 |
| Sept. 14, 2026 | issue | SO-260914-936 | EAST | 4 | 41.21 | -164.83 | 35 | 1,442.24 | Aug. 17, 2026: 4 @ 41.21 |
| Sept. 13, 2026 | issue | SO-260913-395 | MAIN | 10 | 41.21 | -412.07 | 39 | 1,607.07 | Aug. 17, 2026: 10 @ 41.21 |
| Sept. 4, 2026 | issue | SO-260904-173 | MAIN | 1 | 41.21 | -41.21 | 49 | 2,019.14 | Aug. 17, 2026: 1 @ 41.21 |
| Aug. 29, 2026 | issue | SO-260829-163 | MAIN | 6 | 41.07 | -246.40 | 50 | 2,060.34 | June 10, 2026: 3 @ 41.07; Aug. 11, 2026: 3 @ 41.07 |
| Aug. 24, 2026 | issue | SO-260824-998 | MAIN | 5 | 41.07 | -205.33 | 56 | 2,306.74 | June 10, 2026: 5 @ 41.07 |
| Aug. 18, 2026 | issue | SO-260818-198 | EAST | 2 | 41.07 | -82.13 | 61 | 2,512.07 | June 10, 2026: 2 @ 41.07 |
| Aug. 17, 2026 | receipt | PO-001724 | MAIN | 50 | 41.21 | 2,060.34 | 63 | 2,594.20 | |
| Aug. 11, 2026 | return | RMA | MAIN | 3 | 41.07 | 123.20 | 13 | 533.86 | |
| Aug. 5, 2026 | issue | SO-260805-994 | EAST | 1 | 41.07 | -41.07 | 10 | 410.66 | June 10, 2026: 1 @ 41.07 |
| Aug. 5, 2026 | issue | SO-260805-994 | MAIN | 7 | 41.07 | -287.46 | 11 | 451.73 | June 10, 2026: 7 @ 41.07 |
| July 29, 2026 | issue | SO-260729-485 | MAIN | 4 | 41.07 | -164.26 | 18 | 739.19 | June 10, 2026: 4 @ 41.07 |
| July 26, 2026 | issue | SO-260726-580 | MAIN | 1 | 41.07 | -41.07 | 22 | 903.45 | June 10, 2026: 1 @ 41.07 |
| July 14, 2026 | issue | SO-260714-195 | MAIN | 2 | 41.07 | -82.13 | 23 | 944.52 | June 10, 2026: 2 @ 41.07 |
| July 13, 2026 | issue | SO-260713-556 | EAST | 5 | 41.07 | -205.33 | 25 | 1,026.65 | June 10, 2026: 5 @ 41.07 |
| July 10, 2026 | issue | SO-260710-766 | MAIN | 1 | 41.07 | -41.07 | 30 | 1,231.98 | June 10, 2026: 1 @ 41.07 |
| July 3, 2026 | issue | SO-260703-521 | MAIN | 1 | 41.07 | -41.07 | 31 | 1,273.05 | June 10, 2026: 1 @ 41.07 |
| July 2, 2026 | issue | SO-260702-571 | MAIN | 2 | 41.07 | -82.13 | 32 | 1,314.11 | June 10, 2026: 2 @ 41.07 |
| June 29, 2026 | issue | SO-260629-332 | MAIN | 2 | 41.07 | -82.13 | 34 | 1,396.24 | June 10, 2026: 2 @ 41.07 |
| June 24, 2026 | issue | SO-260624-801 | MAIN | 1 | 41.07 | -41.07 | 36 | 1,478.38 | June 10, 2026: 1 @ 41.07 |
| June 23, 2026 | issue | SO-260623-434 | MAIN | 5 | 41.07 | -205.33 | 37 | 1,519.44 | June 10, 2026: 5 @ 41.07 |
| June 14, 2026 | issue | SO-260614-990 | MAIN | 8 | 41.07 | -328.53 | 42 | 1,724.77 | June 10, 2026: 8 @ 41.07 |
| June 10, 2026 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||
| June 10, 2026 | receipt | PO-001566 | MAIN | 50 | 41.07 | 2,053.30 | 50 | 2,053.30 | |
| May 30, 2026 | issue | SO-260530-159 | MAIN | 17 | 41.24 | -701.10 | 0 | 0.00 | Feb. 19, 2026: 17 @ 41.24 |
| May 22, 2026 | issue | SO-260522-994 | MAIN | 6 | 41.24 | -247.45 | 17 | 701.10 | Feb. 19, 2026: 6 @ 41.24 |
| April 26, 2026 | issue | SO-260426-622 | MAIN | 1 | 41.24 | -41.24 | 23 | 948.55 | Feb. 19, 2026: 1 @ 41.24 |
| April 21, 2026 | issue | SO-260421-933 | MAIN | 17 | 41.24 | -701.10 | 24 | 989.79 | Feb. 19, 2026: 17 @ 41.24 |
| April 4, 2026 | issue | SO-260404-152 | MAIN | 1 | 41.24 | -41.24 | 41 | 1,690.89 | Feb. 19, 2026: 1 @ 41.24 |
| March 27, 2026 | issue | SO-260327-965 | MAIN | 1 | 41.24 | -41.24 | 42 | 1,732.13 | Feb. 19, 2026: 1 @ 41.24 |
| March 20, 2026 | issue | SO-260320-730 | MAIN | 11 | 40.57 | -446.27 | 43 | 1,773.37 | Dec. 29, 2025: 2 @ 39.39; Jan. 20, 2026: 2 @ 39.39; Feb. 19, 2026: 7 @ 41.24 |
| March 11, 2026 | issue | SO-260311-451 | MAIN | 2 | 39.39 | -78.79 | 54 | 2,219.63 | Dec. 29, 2025: 2 @ 39.39 |
| March 4, 2026 | issue | SO-260304-633 | MAIN | 1 | 39.39 | -39.39 | 56 | 2,298.42 | Dec. 29, 2025: 1 @ 39.39 |
| March 3, 2026 | issue | SO-260303-818 | MAIN | 5 | 39.39 | -196.97 | 57 | 2,337.82 | Dec. 29, 2025: 5 @ 39.39 |
| Feb. 19, 2026 | receipt | PO-001240 | MAIN | 50 | 41.24 | 2,062.06 | 62 | 2,534.79 | |
| Feb. 9, 2026 | issue | SO-260209-485 | MAIN | 5 | 39.39 | -196.97 | 12 | 472.73 | Dec. 29, 2025: 5 @ 39.39 |
| Feb. 5, 2026 | issue | SO-260205-166 | MAIN | 9 | 39.39 | -354.55 | 17 | 669.71 | Dec. 29, 2025: 9 @ 39.39 |
| Feb. 1, 2026 | issue | SO-260201-559 | MAIN | 1 | 39.39 | -39.39 | 26 | 1,024.26 | Dec. 29, 2025: 1 @ 39.39 |
| Feb. 1, 2026 | issue | SO-260201-559 | EAST | 2 | 39.39 | -78.79 | 27 | 1,063.65 | Dec. 29, 2025: 2 @ 39.39 |
| Jan. 29, 2026 | issue | SO-260129-657 | MAIN | 2 | 39.39 | -78.79 | 29 | 1,142.44 | Dec. 29, 2025: 2 @ 39.39 |
| Jan. 23, 2026 | issue | SO-260123-831 | MAIN | 13 | 39.39 | -512.13 | 31 | 1,221.23 | Dec. 29, 2025: 13 @ 39.39 |
| Jan. 21, 2026 | issue | SO-260121-407 | EAST | 5 | 39.39 | -196.97 | 44 | 1,733.36 | Dec. 29, 2025: 5 @ 39.39 |
| Jan. 20, 2026 | return | RMA | MAIN | 2 | 39.39 | 78.79 | 49 | 1,930.33 | |
| Jan. 20, 2026 | issue | SO-260120-497 | MAIN | 1 | 39.39 | -39.39 | 47 | 1,851.54 | Dec. 29, 2025: 1 @ 39.39 |
| Jan. 15, 2026 | issue | SO-260115-429 | EAST | 4 | 40.42 | -161.68 | 48 | 1,890.94 | Nov. 4, 2025: 2 @ 41.45; Dec. 29, 2025: 2 @ 39.39 |
| Jan. 12, 2026 | issue | SO-260112-406 | MAIN | 2 | 41.45 | -82.89 | 52 | 2,052.62 | Nov. 4, 2025: 2 @ 41.45 |
| Jan. 11, 2026 | issue | SO-260111-328 | MAIN | 2 | 41.45 | -82.89 | 54 | 2,135.51 | Nov. 4, 2025: 2 @ 41.45 |
| Dec. 30, 2025 | issue | SO-251230-215 | MAIN | 8 | 41.45 | -331.58 | 56 | 2,218.41 | Nov. 4, 2025: 8 @ 41.45 |
| Dec. 29, 2025 | transfer | TRF | MAIN → EAST | 11 | warehouse transfer, no cost effect | ||||
| Dec. 29, 2025 | receipt | PO-001100 | MAIN | 50 | 39.39 | 1,969.72 | 64 | 2,549.98 | |