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
| 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 |
| Aug. 22, 2025 | issue | SO-250822-400 | MAIN | 6 | 92.46 | -554.79 | 15 | 1,386.96 | July 10, 2025: 6 @ 92.46 |
| Aug. 20, 2025 | issue | SO-250820-976 | MAIN | 1 | 92.46 | -92.46 | 21 | 1,941.75 | July 10, 2025: 1 @ 92.46 |
| Aug. 19, 2025 | issue | SO-250819-555 | MAIN | 1 | 92.46 | -92.46 | 22 | 2,034.21 | July 10, 2025: 1 @ 92.46 |
| Aug. 12, 2025 | issue | SO-250812-839 | EAST | 3 | 92.46 | -277.39 | 23 | 2,126.68 | July 10, 2025: 3 @ 92.46 |
| Aug. 9, 2025 | issue | SO-250809-374 | MAIN | 4 | 92.46 | -369.86 | 26 | 2,404.07 | July 10, 2025: 4 @ 92.46 |
| July 30, 2025 | issue | SO-250730-727 | EAST | 1 | 92.46 | -92.46 | 30 | 2,773.93 | July 10, 2025: 1 @ 92.46 |
| July 28, 2025 | issue | SO-250728-276 | MAIN | 4 | 92.46 | -369.86 | 31 | 2,866.39 | July 10, 2025: 4 @ 92.46 |
| July 27, 2025 | issue | SO-250727-237 | MAIN | 3 | 92.46 | -277.39 | 35 | 3,236.25 | July 10, 2025: 3 @ 92.46 |
| July 20, 2025 | issue | SO-250720-190 | MAIN | 1 | 92.46 | -92.46 | 38 | 3,513.64 | July 10, 2025: 1 @ 92.46 |
| July 12, 2025 | return | RMA | MAIN | 2 | 92.46 | 184.93 | 39 | 3,606.11 | |
| July 12, 2025 | issue | SO-250712-533 | MAIN | 1 | 92.46 | -92.46 | 37 | 3,421.18 | July 10, 2025: 1 @ 92.46 |
| July 10, 2025 | issue | SO-250710-445 | MAIN | 8 | 90.15 | -721.20 | 38 | 3,513.64 | April 16, 2025: 6 @ 89.38; July 10, 2025: 2 @ 92.46 |
| July 10, 2025 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| July 10, 2025 | receipt | PO-000695 | MAIN | 40 | 92.46 | 3,698.57 | 46 | 4,234.84 | |
| June 30, 2025 | issue | SO-250630-574 | MAIN | 2 | 89.38 | -178.76 | 6 | 536.27 | April 16, 2025: 2 @ 89.38 |
| June 29, 2025 | issue | SO-250629-751 | MAIN | 2 | 89.38 | -178.76 | 8 | 715.03 | April 16, 2025: 2 @ 89.38 |
| June 26, 2025 | issue | SO-250626-186 | MAIN | 5 | 89.38 | -446.89 | 10 | 893.79 | April 16, 2025: 5 @ 89.38 |
| June 20, 2025 | issue | SO-250620-835 | MAIN | 1 | 89.38 | -89.38 | 15 | 1,340.68 | April 16, 2025: 1 @ 89.38 |
| June 16, 2025 | issue | SO-250616-953 | MAIN | 1 | 89.38 | -89.38 | 16 | 1,430.06 | April 16, 2025: 1 @ 89.38 |
| June 16, 2025 | issue | SO-250616-953 | EAST | 3 | 89.38 | -268.14 | 17 | 1,519.44 | April 16, 2025: 3 @ 89.38 |
| June 10, 2025 | issue | SO-250610-716 | MAIN | 2 | 89.38 | -178.76 | 20 | 1,787.58 | April 16, 2025: 2 @ 89.38 |
| May 24, 2025 | issue | SO-250524-412 | EAST | 2 | 89.38 | -178.76 | 22 | 1,966.33 | April 16, 2025: 2 @ 89.38 |
| May 14, 2025 | issue | SO-250514-635 | MAIN | 7 | 89.38 | -625.65 | 24 | 2,145.09 | April 16, 2025: 7 @ 89.38 |
| May 9, 2025 | issue | SO-250509-691 | EAST | 5 | 89.38 | -446.89 | 31 | 2,770.74 | April 16, 2025: 5 @ 89.38 |
| April 25, 2025 | issue | SO-250425-843 | MAIN | 7 | 89.72 | -628.04 | 36 | 3,217.64 | Feb. 2, 2025: 3 @ 90.17; April 16, 2025: 4 @ 89.38 |
| April 22, 2025 | issue | SO-250422-228 | MAIN | 1 | 90.17 | -90.17 | 43 | 3,845.67 | Feb. 2, 2025: 1 @ 90.17 |
| April 21, 2025 | issue | SO-250421-598 | MAIN | 1 | 90.17 | -90.17 | 44 | 3,935.85 | Feb. 2, 2025: 1 @ 90.17 |
| April 16, 2025 | issue | SO-250416-418 | MAIN | 5 | 90.17 | -450.87 | 45 | 4,026.02 | Feb. 2, 2025: 5 @ 90.17 |
| April 16, 2025 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| April 16, 2025 | receipt | PO-000452 | MAIN | 40 | 89.38 | 3,575.15 | 50 | 4,476.89 | |
| April 7, 2025 | issue | SO-250407-405 | MAIN | 10 | 90.17 | -901.74 | 10 | 901.74 | Feb. 2, 2025: 10 @ 90.17 |
| March 14, 2025 | issue | SO-250314-947 | MAIN | 12 | 90.17 | -1,082.08 | 20 | 1,803.47 | Feb. 2, 2025: 12 @ 90.17 |
| March 12, 2025 | issue | SO-250312-602 | MAIN | 5 | 90.17 | -450.87 | 32 | 2,885.56 | Feb. 2, 2025: 5 @ 90.17 |
| Feb. 18, 2025 | issue | SO-250218-253 | MAIN | 4 | 89.00 | -356.01 | 37 | 3,336.42 | Nov. 23, 2024: 1 @ 85.49; Feb. 2, 2025: 3 @ 90.17 |
| Feb. 17, 2025 | issue | SO-250217-248 | MAIN | 1 | 85.49 | -85.49 | 41 | 3,692.44 | Nov. 23, 2024: 1 @ 85.49 |
| Feb. 4, 2025 | issue | SO-250204-843 | MAIN | 7 | 85.49 | -598.45 | 42 | 3,777.93 | Nov. 23, 2024: 7 @ 85.49 |
| Feb. 2, 2025 | receipt | PO-000234 | MAIN | 40 | 90.17 | 3,606.94 | 49 | 4,376.38 | |
| Jan. 26, 2025 | issue | SO-250126-547 | MAIN | 2 | 85.49 | -170.99 | 9 | 769.44 | Nov. 23, 2024: 2 @ 85.49 |
| Jan. 21, 2025 | issue | SO-250121-496 | MAIN | 1 | 85.49 | -85.49 | 11 | 940.42 | Nov. 23, 2024: 1 @ 85.49 |
| Jan. 19, 2025 | issue | SO-250119-213 | MAIN | 8 | 85.49 | -683.94 | 12 | 1,025.91 | Nov. 23, 2024: 8 @ 85.49 |
| Jan. 17, 2025 | issue | SO-250117-842 | MAIN | 1 | 85.49 | -85.49 | 20 | 1,709.86 | Nov. 23, 2024: 1 @ 85.49 |
| Jan. 10, 2025 | issue | SO-250110-273 | MAIN | 6 | 85.49 | -512.96 | 21 | 1,795.35 | Nov. 23, 2024: 6 @ 85.49 |
| Jan. 10, 2025 | issue | SO-250110-273 | EAST | 1 | 85.49 | -85.49 | 27 | 2,308.31 | Nov. 23, 2024: 1 @ 85.49 |
| Jan. 3, 2025 | issue | SO-250103-518 | EAST | 1 | 85.49 | -85.49 | 28 | 2,393.80 | Nov. 23, 2024: 1 @ 85.49 |
| Dec. 26, 2024 | issue | SO-241226-953 | MAIN | 12 | 85.87 | -1,030.49 | 29 | 2,479.29 | Oct. 1, 2024: 1 @ 90.07; Nov. 23, 2024: 11 @ 85.49 |
| Dec. 13, 2024 | issue | SO-241213-325 | MAIN | 7 | 90.07 | -630.49 | 41 | 3,509.79 | Oct. 1, 2024: 7 @ 90.07 |
| Nov. 23, 2024 | receipt | PO-000054 | MAIN | 40 | 85.49 | 3,419.72 | 48 | 4,140.27 | |
| Nov. 16, 2024 | issue | SO-241116-548 | MAIN | 3 | 90.07 | -270.21 | 8 | 720.56 | Oct. 1, 2024: 3 @ 90.07 |
| Nov. 8, 2024 | issue | SO-241108-314 | MAIN | 10 | 90.07 | -900.70 | 11 | 990.76 | Oct. 1, 2024: 10 @ 90.07 |
| Nov. 7, 2024 | issue | SO-241107-695 | EAST | 3 | 90.07 | -270.21 | 21 | 1,891.46 | Oct. 1, 2024: 3 @ 90.07 |
| Oct. 28, 2024 | issue | SO-241028-441 | MAIN | 1 | 90.07 | -90.07 | 24 | 2,161.67 | Oct. 1, 2024: 1 @ 90.07 |
| Oct. 27, 2024 | issue | SO-241027-684 | EAST | 2 | 90.07 | -180.14 | 25 | 2,251.74 | Oct. 1, 2024: 2 @ 90.07 |
| Oct. 26, 2024 | issue | SO-241026-786 | MAIN | 1 | 90.07 | -90.07 | 27 | 2,431.88 | Oct. 1, 2024: 1 @ 90.07 |
| Oct. 21, 2024 | issue | SO-241021-765 | MAIN | 4 | 90.07 | -360.28 | 28 | 2,521.95 | Oct. 1, 2024: 4 @ 90.07 |
| Oct. 13, 2024 | issue | SO-241013-614 | EAST | 1 | 90.07 | -90.07 | 32 | 2,882.22 | Oct. 1, 2024: 1 @ 90.07 |
| Oct. 11, 2024 | issue | SO-241011-894 | EAST | 1 | 90.07 | -90.07 | 33 | 2,972.29 | Oct. 1, 2024: 1 @ 90.07 |
| Oct. 9, 2024 | issue | SO-241009-933 | MAIN | 6 | 90.07 | -540.42 | 34 | 3,062.36 | Oct. 1, 2024: 6 @ 90.07 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 40 | 90.07 | 3,602.78 | 40 | 3,602.78 | |