Items / CAB-0026
FR Wire 2.5 sqmm Classic CAB-0026 · Cables & Wires · Conduit & Cable Co
On hand (COIL)126MAIN 126
Value (FIFO)8,509.71avg 67.54
ClassAX / FCV 0.30
Turnover5.8xlast issue 0 days ago
Days of cover74lead 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 | 52.08 / 30.4375 | 1.711 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.62 / 5.517 | 2.831 |
| 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.831^2 + 1.711^2 * 3.1^2) | 24.4 |
| Reorder point | d * LT + safety stock | 1.711 * 14.0 + 24.4 | 48.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 48.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 625/yr, S = 45.00, h = 20%, price = 61.56 | 520.0 |
| Inventory position | on hand + on order | 126 + 0 | 126 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 66.91 | 65 | 42,657 | yes |
| 260 | 64.23 | 260 | 41,897 | yes |
| 520 | 61.56 | 520 | 41,702 | yes (chosen if cheapest) |
MOQ 130, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 20, 2026 | 126 / 130 | 67.54 | 8,509.71 |
Movement ledger 105 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-340 | MAIN | 5 | 67.58 | -337.89 | 126 | 8,509.71 | July 26, 2026: 1 @ 67.74; Sept. 20, 2026: 4 @ 67.54 |
| Oct. 11, 2026 | issue | SO-261011-531 | MAIN | 4 | 67.74 | -270.97 | 131 | 8,847.60 | July 26, 2026: 4 @ 67.74 |
| Oct. 7, 2026 | issue | SO-261007-515 | MAIN | 27 | 67.74 | -1,829.03 | 135 | 9,118.57 | July 26, 2026: 27 @ 67.74 |
| Oct. 4, 2026 | issue | SO-261004-345 | MAIN | 6 | 67.74 | -406.45 | 162 | 10,947.61 | July 26, 2026: 6 @ 67.74 |
| Sept. 20, 2026 | receipt | PO-001812 | MAIN | 130 | 67.54 | 8,779.86 | 168 | 11,354.06 | |
| Sept. 11, 2026 | issue | SO-260911-545 | MAIN | 5 | 67.74 | -338.71 | 38 | 2,574.20 | July 26, 2026: 5 @ 67.74 |
| Sept. 6, 2026 | issue | SO-260906-943 | MAIN | 45 | 67.74 | -3,048.39 | 43 | 2,912.91 | July 26, 2026: 45 @ 67.74 |
| Aug. 25, 2026 | issue | SO-260825-762 | MAIN | 1 | 67.74 | -67.74 | 88 | 5,961.30 | July 26, 2026: 1 @ 67.74 |
| Aug. 24, 2026 | issue | SO-260824-676 | MAIN | 44 | 67.61 | -2,974.69 | 89 | 6,029.04 | July 19, 2026: 3 @ 65.76; July 26, 2026: 41 @ 67.74 |
| Aug. 16, 2026 | issue | SO-260816-387 | MAIN | 10 | 65.76 | -657.57 | 133 | 9,003.73 | July 19, 2026: 10 @ 65.76 |
| Aug. 6, 2026 | adjustment | Cycle count | MAIN | -1 | 65.76 | -65.76 | 143 | 9,661.30 | July 19, 2026: 1 @ 65.76 |
| July 26, 2026 | receipt | PO-001674 | MAIN | 130 | 67.74 | 8,806.46 | 144 | 9,727.06 | |
| July 24, 2026 | issue | SO-260724-578 | MAIN | 27 | 65.76 | -1,775.43 | 14 | 920.60 | May 31, 2026: 22 @ 65.76; July 19, 2026: 5 @ 65.76 |
| July 19, 2026 | return | RMA | MAIN | 19 | 65.76 | 1,249.38 | 41 | 2,696.03 | |
| July 16, 2026 | issue | SO-260716-357 | MAIN | 38 | 65.76 | -2,498.76 | 22 | 1,446.65 | May 31, 2026: 38 @ 65.76 |
| July 1, 2026 | issue | SO-260701-963 | MAIN | 30 | 65.76 | -1,972.70 | 60 | 3,945.41 | May 31, 2026: 30 @ 65.76 |
| June 29, 2026 | issue | SO-260629-690 | MAIN | 11 | 65.76 | -723.32 | 90 | 5,918.11 | May 31, 2026: 11 @ 65.76 |
| June 22, 2026 | issue | SO-260622-954 | MAIN | 1 | 65.76 | -65.76 | 101 | 6,641.44 | May 31, 2026: 1 @ 65.76 |
| June 19, 2026 | issue | SO-260619-745 | MAIN | 30 | 65.73 | -1,972.01 | 102 | 6,707.19 | March 15, 2026: 2 @ 65.41; May 31, 2026: 28 @ 65.76 |
| June 16, 2026 | issue | SO-260616-940 | MAIN | 1 | 65.41 | -65.41 | 132 | 8,679.20 | March 15, 2026: 1 @ 65.41 |
| June 15, 2026 | issue | SO-260615-106 | MAIN | 2 | 65.41 | -130.82 | 133 | 8,744.61 | March 15, 2026: 2 @ 65.41 |
| June 12, 2026 | issue | SO-260612-513 | MAIN | 9 | 65.41 | -588.69 | 135 | 8,875.44 | March 15, 2026: 9 @ 65.41 |
| May 31, 2026 | receipt | PO-001536 | MAIN | 130 | 65.76 | 8,548.38 | 144 | 9,464.13 | |
| May 15, 2026 | issue | SO-260515-836 | MAIN | 24 | 65.41 | -1,569.84 | 14 | 915.74 | March 15, 2026: 24 @ 65.41 |
| May 14, 2026 | issue | SO-260514-622 | MAIN | 6 | 65.41 | -392.46 | 38 | 2,485.59 | March 15, 2026: 6 @ 65.41 |
| May 11, 2026 | issue | SO-260511-485 | MAIN | 5 | 65.41 | -327.05 | 44 | 2,878.05 | March 15, 2026: 5 @ 65.41 |
| May 1, 2026 | issue | SO-260501-892 | MAIN | 15 | 65.41 | -981.15 | 49 | 3,205.10 | March 15, 2026: 15 @ 65.41 |
| April 30, 2026 | issue | SO-260430-884 | MAIN | 1 | 65.41 | -65.41 | 64 | 4,186.25 | March 15, 2026: 1 @ 65.41 |
| April 26, 2026 | issue | SO-260426-768 | MAIN | 33 | 65.41 | -2,158.54 | 65 | 4,251.66 | March 15, 2026: 33 @ 65.41 |
| April 20, 2026 | issue | SO-260420-981 | MAIN | 13 | 65.41 | -850.33 | 98 | 6,410.20 | March 15, 2026: 13 @ 65.41 |
| April 12, 2026 | issue | SO-260412-150 | MAIN | 11 | 65.41 | -719.51 | 111 | 7,260.53 | March 15, 2026: 11 @ 65.41 |
| March 30, 2026 | issue | SO-260330-221 | MAIN | 8 | 65.41 | -523.28 | 122 | 7,980.04 | March 15, 2026: 8 @ 65.41 |
| March 15, 2026 | receipt | PO-001321 | MAIN | 130 | 65.41 | 8,503.33 | 130 | 8,503.33 | |
| Feb. 28, 2026 | issue | SO-260228-931 | MAIN | 45 | 64.16 | -2,887.16 | 0 | 0.00 | Dec. 18, 2025: 36 @ 64.16; Dec. 19, 2025: 9 @ 64.16 |
| Feb. 17, 2026 | issue | SO-260217-985 | MAIN | 17 | 64.16 | -1,090.70 | 45 | 2,887.16 | Dec. 18, 2025: 17 @ 64.16 |
| Feb. 15, 2026 | issue | SO-260215-101 | MAIN | 5 | 64.16 | -320.80 | 62 | 3,977.86 | Dec. 18, 2025: 5 @ 64.16 |
| Jan. 20, 2026 | issue | SO-260120-155 | MAIN | 9 | 64.16 | -577.43 | 67 | 4,298.65 | Dec. 18, 2025: 9 @ 64.16 |
| Jan. 10, 2026 | issue | SO-260110-136 | MAIN | 1 | 64.16 | -64.16 | 76 | 4,876.08 | Dec. 18, 2025: 1 @ 64.16 |
| Jan. 5, 2026 | issue | SO-260105-706 | MAIN | 27 | 64.16 | -1,732.29 | 77 | 4,940.24 | Dec. 18, 2025: 27 @ 64.16 |
| Jan. 2, 2026 | issue | SO-260102-253 | MAIN | 13 | 64.16 | -834.07 | 104 | 6,672.54 | Dec. 18, 2025: 13 @ 64.16 |
| Dec. 24, 2025 | issue | SO-251224-569 | MAIN | 15 | 64.16 | -962.38 | 117 | 7,506.60 | Dec. 18, 2025: 15 @ 64.16 |
| Dec. 19, 2025 | return | RMA | MAIN | 9 | 64.16 | 577.43 | 132 | 8,468.99 | |
| Dec. 19, 2025 | issue | SO-251219-863 | MAIN | 7 | 64.16 | -449.11 | 123 | 7,891.56 | Dec. 18, 2025: 7 @ 64.16 |
| Dec. 18, 2025 | receipt | PO-001061 | MAIN | 130 | 64.16 | 8,340.67 | 130 | 8,340.67 | |
| Dec. 9, 2025 | issue | SO-251209-806 | MAIN | 18 | 65.39 | -1,177.01 | 0 | 0.00 | Sept. 29, 2025: 18 @ 65.39 |
| Dec. 1, 2025 | issue | SO-251201-872 | MAIN | 13 | 65.39 | -850.07 | 18 | 1,177.01 | Sept. 29, 2025: 13 @ 65.39 |
| Nov. 30, 2025 | issue | SO-251130-467 | MAIN | 24 | 65.39 | -1,569.35 | 31 | 2,027.08 | Sept. 29, 2025: 24 @ 65.39 |
| Nov. 4, 2025 | issue | SO-251104-621 | MAIN | 36 | 65.39 | -2,354.03 | 55 | 3,596.43 | Sept. 29, 2025: 36 @ 65.39 |
| Oct. 11, 2025 | issue | SO-251011-510 | MAIN | 19 | 65.39 | -1,242.40 | 91 | 5,950.46 | Sept. 29, 2025: 19 @ 65.39 |
| Oct. 5, 2025 | issue | SO-251005-610 | MAIN | 34 | 65.05 | -2,211.70 | 110 | 7,192.87 | July 18, 2025: 12 @ 64.56; Sept. 24, 2025: 2 @ 64.56; Sept. 29, 2025: 20 @ 65.39 |
| Sept. 29, 2025 | receipt | PO-000883 | MAIN | 130 | 65.39 | 8,500.66 | 144 | 9,404.56 | |
| Sept. 25, 2025 | issue | SO-250925-982 | MAIN | 5 | 64.56 | -322.82 | 14 | 903.90 | July 18, 2025: 5 @ 64.56 |
| Sept. 24, 2025 | return | RMA | MAIN | 2 | 64.56 | 129.13 | 19 | 1,226.72 | |
| Sept. 21, 2025 | issue | SO-250921-103 | MAIN | 4 | 64.56 | -258.26 | 17 | 1,097.59 | July 18, 2025: 4 @ 64.56 |
| Sept. 20, 2025 | issue | SO-250920-413 | MAIN | 8 | 64.56 | -516.52 | 21 | 1,355.85 | July 18, 2025: 8 @ 64.56 |
| Sept. 16, 2025 | issue | SO-250916-303 | MAIN | 12 | 64.56 | -774.77 | 29 | 1,872.37 | July 18, 2025: 12 @ 64.56 |
| Sept. 14, 2025 | issue | SO-250914-711 | MAIN | 7 | 64.56 | -451.95 | 41 | 2,647.14 | July 18, 2025: 7 @ 64.56 |
| Sept. 10, 2025 | issue | SO-250910-222 | MAIN | 5 | 64.56 | -322.82 | 48 | 3,099.09 | July 18, 2025: 5 @ 64.56 |
| Aug. 26, 2025 | issue | SO-250826-833 | MAIN | 32 | 64.56 | -2,066.06 | 53 | 3,421.91 | July 18, 2025: 32 @ 64.56 |
| Aug. 12, 2025 | issue | SO-250812-651 | MAIN | 66 | 63.88 | -4,215.97 | 85 | 5,487.97 | May 29, 2025: 21 @ 62.41; July 18, 2025: 45 @ 64.56 |