Items / CAB-0017
FR Wire 4 sqmm Eco CAB-0017 · Cables & Wires · Conduit & Cable Co
On hand (COIL)24MAIN 24
Value (FIFO)2,201.17avg 91.72
ClassBX / FCV 0.19
Turnover8.0xlast issue 3 days ago
Days of cover44lead 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 | 16.50 / 30.4375 | 0.542 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.07 / 5.517 | 0.556 |
| 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.556^2 + 0.542^2 * 3.1^2) | 4.4 |
| Reorder point | d * LT + safety stock | 0.542 * 14.0 + 4.4 | 12.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 12.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 198/yr, S = 45.00, h = 20%, price = 94.81 | 30.6 |
| Inventory position | on hand + on order | 24 + 0 | 24 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 94.81 | 31 | 19,341 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 28, 2026 | 24 / 40 | 91.72 | 2,201.17 |
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. 13, 2026 | issue | SO-261013-519 | MAIN | 3 | 91.72 | -275.15 | 24 | 2,201.17 | Sept. 28, 2026: 3 @ 91.72 |
| Oct. 12, 2026 | issue | SO-261012-581 | MAIN | 4 | 91.72 | -366.86 | 27 | 2,476.32 | Sept. 28, 2026: 4 @ 91.72 |
| Oct. 11, 2026 | issue | SO-261011-195 | MAIN | 2 | 91.72 | -183.43 | 31 | 2,843.18 | Sept. 28, 2026: 2 @ 91.72 |
| Oct. 8, 2026 | issue | SO-261008-982 | MAIN | 8 | 92.23 | -737.86 | 33 | 3,026.61 | Aug. 10, 2026: 1 @ 95.85; Sept. 28, 2026: 7 @ 91.72 |
| Oct. 2, 2026 | issue | SO-261002-784 | MAIN | 1 | 96.11 | -96.11 | 41 | 3,764.47 | July 27, 2026: 1 @ 96.11 |
| Sept. 30, 2026 | issue | SO-260930-377 | MAIN | 2 | 96.11 | -192.21 | 42 | 3,860.57 | July 27, 2026: 2 @ 96.11 |
| Sept. 28, 2026 | receipt | PO-001836 | MAIN | 40 | 91.72 | 3,668.62 | 44 | 4,052.79 | |
| Sept. 22, 2026 | issue | SO-260922-192 | MAIN | 6 | 96.11 | -576.64 | 4 | 384.17 | July 27, 2026: 6 @ 96.11 |
| Sept. 21, 2026 | issue | SO-260921-930 | MAIN | 4 | 96.11 | -384.43 | 10 | 960.81 | July 27, 2026: 4 @ 96.11 |
| Sept. 6, 2026 | issue | SO-260906-919 | MAIN | 4 | 96.11 | -384.43 | 14 | 1,345.24 | July 27, 2026: 4 @ 96.11 |
| Aug. 19, 2026 | issue | SO-260819-626 | MAIN | 3 | 96.11 | -288.32 | 18 | 1,729.67 | July 27, 2026: 3 @ 96.11 |
| Aug. 10, 2026 | return | RMA | MAIN | 1 | 95.85 | 95.85 | 21 | 2,017.99 | |
| Aug. 7, 2026 | issue | SO-260807-308 | MAIN | 21 | 95.85 | -2,012.83 | 20 | 1,922.14 | May 12, 2026: 1 @ 90.69; July 27, 2026: 20 @ 96.11 |
| July 27, 2026 | receipt | PO-001677 | MAIN | 40 | 96.11 | 3,844.28 | 41 | 3,934.97 | |
| July 23, 2026 | issue | SO-260723-521 | MAIN | 1 | 90.69 | -90.69 | 1 | 90.69 | May 12, 2026: 1 @ 90.69 |
| July 22, 2026 | issue | SO-260722-307 | MAIN | 2 | 90.69 | -181.38 | 2 | 181.38 | May 12, 2026: 2 @ 90.69 |
| July 19, 2026 | issue | SO-260719-712 | MAIN | 1 | 90.69 | -90.69 | 4 | 362.75 | May 12, 2026: 1 @ 90.69 |
| July 16, 2026 | issue | SO-260716-781 | MAIN | 6 | 90.69 | -544.13 | 5 | 453.44 | May 12, 2026: 6 @ 90.69 |
| July 11, 2026 | issue | SO-260711-734 | EAST | 5 | 90.69 | -453.44 | 11 | 997.56 | May 12, 2026: 5 @ 90.69 |
| July 2, 2026 | issue | SO-260702-421 | MAIN | 3 | 90.69 | -272.06 | 16 | 1,451.00 | May 12, 2026: 3 @ 90.69 |
| June 21, 2026 | issue | SO-260621-388 | MAIN | 10 | 90.69 | -906.88 | 19 | 1,723.07 | May 12, 2026: 10 @ 90.69 |
| June 9, 2026 | issue | SO-260609-120 | MAIN | 8 | 90.69 | -725.50 | 29 | 2,629.94 | May 12, 2026: 8 @ 90.69 |
| May 17, 2026 | issue | SO-260517-348 | MAIN | 14 | 91.87 | -1,286.15 | 37 | 3,355.44 | Feb. 23, 2026: 11 @ 92.19; May 12, 2026: 3 @ 90.69 |
| May 12, 2026 | receipt | PO-001484 | MAIN | 40 | 90.69 | 3,627.51 | 51 | 4,641.60 | |
| May 10, 2026 | issue | SO-260510-467 | MAIN | 1 | 92.19 | -92.19 | 11 | 1,014.09 | Feb. 23, 2026: 1 @ 92.19 |
| April 30, 2026 | issue | SO-260430-832 | MAIN | 2 | 92.19 | -184.38 | 12 | 1,106.28 | Feb. 23, 2026: 2 @ 92.19 |
| April 18, 2026 | issue | SO-260418-644 | MAIN | 6 | 92.19 | -553.14 | 14 | 1,290.66 | Feb. 23, 2026: 6 @ 92.19 |
| April 16, 2026 | issue | SO-260416-615 | MAIN | 1 | 92.19 | -92.19 | 20 | 1,843.80 | Feb. 23, 2026: 1 @ 92.19 |
| April 10, 2026 | issue | SO-260410-462 | MAIN | 1 | 92.19 | -92.19 | 21 | 1,935.99 | Feb. 23, 2026: 1 @ 92.19 |
| April 8, 2026 | issue | SO-260408-105 | MAIN | 4 | 92.19 | -368.76 | 22 | 2,028.18 | Feb. 23, 2026: 4 @ 92.19 |
| April 2, 2026 | issue | SO-260402-999 | EAST | 2 | 92.19 | -184.38 | 26 | 2,396.94 | Feb. 23, 2026: 2 @ 92.19 |
| March 28, 2026 | issue | SO-260328-642 | MAIN | 2 | 92.19 | -184.38 | 28 | 2,581.32 | Feb. 23, 2026: 2 @ 92.19 |
| March 26, 2026 | issue | SO-260326-333 | EAST | 1 | 92.19 | -92.19 | 30 | 2,765.70 | Feb. 23, 2026: 1 @ 92.19 |
| March 18, 2026 | issue | SO-260318-489 | EAST | 1 | 92.19 | -92.19 | 31 | 2,857.89 | Feb. 23, 2026: 1 @ 92.19 |
| March 11, 2026 | issue | SO-260311-989 | MAIN | 13 | 92.76 | -1,205.94 | 32 | 2,950.08 | Nov. 15, 2025: 5 @ 93.68; Feb. 23, 2026: 8 @ 92.19 |
| March 8, 2026 | issue | SO-260308-568 | MAIN | 1 | 93.68 | -93.68 | 45 | 4,156.03 | Nov. 15, 2025: 1 @ 93.68 |
| Feb. 23, 2026 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Feb. 23, 2026 | receipt | PO-001252 | MAIN | 40 | 92.19 | 3,687.60 | 46 | 4,249.71 | |
| Feb. 15, 2026 | issue | SO-260215-849 | MAIN | 6 | 93.68 | -562.11 | 6 | 562.11 | Nov. 15, 2025: 6 @ 93.68 |
| Feb. 9, 2026 | issue | SO-260209-907 | MAIN | 10 | 93.68 | -936.84 | 12 | 1,124.21 | Nov. 15, 2025: 10 @ 93.68 |
| Jan. 23, 2026 | issue | SO-260123-869 | MAIN | 3 | 93.68 | -281.05 | 22 | 2,061.05 | Nov. 15, 2025: 3 @ 93.68 |
| Jan. 15, 2026 | issue | SO-260115-399 | MAIN | 3 | 93.68 | -281.05 | 25 | 2,342.11 | Nov. 15, 2025: 3 @ 93.68 |
| Jan. 8, 2026 | issue | SO-260108-323 | MAIN | 5 | 93.68 | -468.42 | 28 | 2,623.16 | Nov. 15, 2025: 5 @ 93.68 |
| Jan. 7, 2026 | issue | SO-260107-914 | MAIN | 4 | 93.68 | -374.74 | 33 | 3,091.58 | Nov. 15, 2025: 4 @ 93.68 |
| Jan. 2, 2026 | issue | SO-260102-273 | MAIN | 1 | 93.68 | -93.68 | 37 | 3,466.32 | Nov. 15, 2025: 1 @ 93.68 |
| Dec. 21, 2025 | issue | SO-251221-614 | MAIN | 3 | 91.85 | -275.56 | 38 | 3,560.00 | Sept. 11, 2025: 1 @ 88.19; Nov. 15, 2025: 2 @ 93.68 |
| Dec. 18, 2025 | issue | SO-251218-329 | MAIN | 7 | 88.19 | -617.34 | 41 | 3,835.56 | Sept. 11, 2025: 7 @ 88.19 |
| Nov. 30, 2025 | issue | SO-251130-771 | MAIN | 1 | 88.19 | -88.19 | 48 | 4,452.91 | Sept. 11, 2025: 1 @ 88.19 |
| Nov. 17, 2025 | issue | SO-251117-234 | MAIN | 2 | 88.19 | -176.38 | 49 | 4,541.10 | Sept. 11, 2025: 2 @ 88.19 |
| Nov. 15, 2025 | receipt | PO-001002 | MAIN | 40 | 93.68 | 3,747.37 | 51 | 4,717.49 | |
| Nov. 5, 2025 | issue | SO-251105-615 | MAIN | 10 | 88.19 | -881.92 | 11 | 970.11 | Sept. 11, 2025: 10 @ 88.19 |
| Oct. 26, 2025 | issue | SO-251026-406 | MAIN | 2 | 88.19 | -176.38 | 21 | 1,852.03 | Sept. 11, 2025: 2 @ 88.19 |
| Oct. 23, 2025 | issue | SO-251023-641 | MAIN | 1 | 88.19 | -88.19 | 23 | 2,028.42 | Sept. 11, 2025: 1 @ 88.19 |
| Oct. 19, 2025 | issue | SO-251019-576 | MAIN | 5 | 88.19 | -440.96 | 24 | 2,116.61 | Sept. 11, 2025: 5 @ 88.19 |
| Oct. 9, 2025 | issue | SO-251009-253 | MAIN | 3 | 88.19 | -264.58 | 29 | 2,557.57 | Sept. 11, 2025: 3 @ 88.19 |
| Oct. 6, 2025 | issue | SO-251006-992 | MAIN | 8 | 88.19 | -705.54 | 32 | 2,822.15 | Sept. 11, 2025: 8 @ 88.19 |
| Sept. 11, 2025 | receipt | PO-000830 | MAIN | 40 | 88.19 | 3,527.68 | 40 | 3,527.68 | |
| Sept. 10, 2025 | issue | SO-250910-638 | EAST | 2 | 92.46 | -184.93 | 0 | 0.00 | July 12, 2025: 2 @ 92.46 |
| Sept. 1, 2025 | issue | SO-250901-297 | EAST | 7 | 92.46 | -647.25 | 2 | 184.93 | July 10, 2025: 7 @ 92.46 |
| Sept. 1, 2025 | issue | SO-250901-297 | MAIN | 6 | 92.46 | -554.79 | 9 | 832.18 | July 10, 2025: 6 @ 92.46 |