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
| 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 |
| July 18, 2025 | receipt | PO-000721 | MAIN | 130 | 64.56 | 8,393.37 | 151 | 9,703.95 | |
| July 6, 2025 | issue | SO-250706-421 | MAIN | 28 | 62.41 | -1,747.44 | 21 | 1,310.58 | May 29, 2025: 28 @ 62.41 |
| July 1, 2025 | issue | SO-250701-626 | MAIN | 25 | 62.41 | -1,560.21 | 49 | 3,058.01 | May 29, 2025: 25 @ 62.41 |
| June 13, 2025 | issue | SO-250613-290 | MAIN | 5 | 62.41 | -312.04 | 74 | 4,618.22 | May 29, 2025: 5 @ 62.41 |
| June 5, 2025 | issue | SO-250605-662 | MAIN | 52 | 62.39 | -3,244.13 | 79 | 4,930.26 | March 21, 2025: 1 @ 61.30; May 29, 2025: 51 @ 62.41 |
| June 3, 2025 | issue | SO-250603-699 | MAIN | 1 | 61.30 | -61.30 | 131 | 8,174.39 | March 21, 2025: 1 @ 61.30 |
| June 2, 2025 | issue | SO-250602-949 | MAIN | 4 | 61.30 | -245.21 | 132 | 8,235.70 | March 21, 2025: 4 @ 61.30 |
| May 29, 2025 | receipt | PO-000586 | MAIN | 130 | 62.41 | 8,113.09 | 136 | 8,480.91 | |
| May 19, 2025 | issue | SO-250519-506 | MAIN | 12 | 61.30 | -735.63 | 6 | 367.82 | March 21, 2025: 12 @ 61.30 |
| May 15, 2025 | issue | SO-250515-957 | MAIN | 44 | 61.30 | -2,697.31 | 18 | 1,103.45 | March 21, 2025: 44 @ 61.30 |
| April 26, 2025 | issue | SO-250426-489 | MAIN | 1 | 61.30 | -61.30 | 62 | 3,800.76 | March 21, 2025: 1 @ 61.30 |
| April 17, 2025 | issue | SO-250417-944 | MAIN | 11 | 61.30 | -674.33 | 63 | 3,862.06 | March 21, 2025: 11 @ 61.30 |
| April 10, 2025 | issue | SO-250410-267 | MAIN | 44 | 61.30 | -2,697.31 | 74 | 4,536.39 | March 21, 2025: 44 @ 61.30 |
| March 31, 2025 | issue | SO-250331-182 | MAIN | 28 | 61.25 | -1,714.87 | 118 | 7,233.71 | Jan. 18, 2025: 16 @ 61.20; March 21, 2025: 12 @ 61.30 |
| March 26, 2025 | issue | SO-250326-836 | MAIN | 2 | 61.20 | -122.40 | 146 | 8,948.58 | Jan. 18, 2025: 2 @ 61.20 |
| March 21, 2025 | receipt | PO-000361 | MAIN | 130 | 61.30 | 7,969.34 | 148 | 9,070.98 | |
| March 8, 2025 | issue | SO-250308-297 | MAIN | 54 | 61.20 | -3,304.93 | 18 | 1,101.64 | Jan. 18, 2025: 54 @ 61.20 |
| Feb. 21, 2025 | issue | SO-250221-910 | MAIN | 17 | 61.20 | -1,040.44 | 72 | 4,406.57 | Jan. 18, 2025: 17 @ 61.20 |
| Feb. 17, 2025 | issue | SO-250217-668 | MAIN | 15 | 61.20 | -918.04 | 89 | 5,447.01 | Jan. 18, 2025: 15 @ 61.20 |
| Feb. 11, 2025 | issue | SO-250211-813 | MAIN | 31 | 61.15 | -1,895.53 | 104 | 6,365.05 | Nov. 19, 2024: 5 @ 60.85; Jan. 18, 2025: 26 @ 61.20 |
| Jan. 30, 2025 | issue | SO-250130-559 | MAIN | 19 | 60.85 | -1,156.24 | 135 | 8,260.58 | Nov. 19, 2024: 19 @ 60.85 |
| Jan. 18, 2025 | issue | SO-250118-527 | MAIN | 3 | 60.85 | -182.56 | 154 | 9,416.82 | Nov. 19, 2024: 3 @ 60.85 |
| Jan. 18, 2025 | receipt | PO-000195 | MAIN | 130 | 61.20 | 7,956.31 | 157 | 9,599.38 | |
| Jan. 14, 2025 | issue | SO-250114-200 | MAIN | 10 | 60.85 | -608.54 | 27 | 1,643.07 | Nov. 19, 2024: 10 @ 60.85 |
| Jan. 9, 2025 | issue | SO-250109-468 | MAIN | 9 | 60.85 | -547.69 | 37 | 2,251.62 | Nov. 19, 2024: 9 @ 60.85 |
| Jan. 5, 2025 | issue | SO-250105-827 | MAIN | 2 | 60.85 | -121.71 | 46 | 2,799.31 | Nov. 19, 2024: 2 @ 60.85 |
| Jan. 2, 2025 | issue | SO-250102-496 | MAIN | 11 | 60.85 | -669.40 | 48 | 2,921.02 | Nov. 19, 2024: 11 @ 60.85 |
| Jan. 1, 2025 | issue | SO-250101-254 | MAIN | 35 | 60.85 | -2,129.91 | 59 | 3,590.42 | Nov. 19, 2024: 35 @ 60.85 |
| Dec. 31, 2024 | issue | SO-241231-415 | MAIN | 6 | 60.85 | -365.13 | 94 | 5,720.32 | Nov. 19, 2024: 6 @ 60.85 |
| Dec. 21, 2024 | issue | SO-241221-846 | MAIN | 10 | 60.85 | -608.54 | 100 | 6,085.45 | Nov. 19, 2024: 10 @ 60.85 |
| Dec. 15, 2024 | issue | SO-241215-448 | MAIN | 5 | 60.85 | -304.27 | 110 | 6,694.00 | Nov. 19, 2024: 5 @ 60.85 |
| Dec. 10, 2024 | issue | SO-241210-607 | MAIN | 3 | 60.85 | -182.56 | 115 | 6,998.27 | Nov. 19, 2024: 3 @ 60.85 |
| Dec. 8, 2024 | issue | SO-241208-604 | MAIN | 7 | 60.85 | -425.98 | 118 | 7,180.83 | Nov. 19, 2024: 7 @ 60.85 |
| Dec. 5, 2024 | issue | SO-241205-741 | MAIN | 4 | 60.85 | -243.42 | 125 | 7,606.81 | Nov. 19, 2024: 4 @ 60.85 |
| Nov. 20, 2024 | issue | SO-241120-914 | MAIN | 1 | 60.85 | -60.85 | 129 | 7,850.23 | Nov. 19, 2024: 1 @ 60.85 |
| Nov. 19, 2024 | receipt | PO-000039 | MAIN | 130 | 60.85 | 7,911.08 | 130 | 7,911.08 | |
| Nov. 14, 2024 | issue | SO-241114-716 | MAIN | 8 | 63.56 | -508.52 | 0 | 0.00 | Oct. 1, 2024: 8 @ 63.56 |
| Nov. 13, 2024 | issue | SO-241113-235 | MAIN | 24 | 63.56 | -1,525.55 | 8 | 508.52 | Oct. 1, 2024: 24 @ 63.56 |
| Nov. 3, 2024 | issue | SO-241103-550 | MAIN | 19 | 63.56 | -1,207.73 | 32 | 2,034.06 | Oct. 1, 2024: 19 @ 63.56 |
| Oct. 23, 2024 | issue | SO-241023-961 | MAIN | 7 | 63.56 | -444.95 | 51 | 3,241.79 | Oct. 1, 2024: 7 @ 63.56 |
| Oct. 20, 2024 | issue | SO-241020-255 | MAIN | 33 | 63.56 | -2,097.63 | 58 | 3,686.74 | Oct. 1, 2024: 33 @ 63.56 |
| Oct. 20, 2024 | issue | SO-241020-255 | EAST | 32 | 63.56 | -2,034.06 | 91 | 5,784.37 | Oct. 1, 2024: 32 @ 63.56 |
| Oct. 18, 2024 | issue | SO-241018-778 | MAIN | 7 | 63.56 | -444.95 | 123 | 7,818.43 | Oct. 1, 2024: 7 @ 63.56 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 32 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 130 | 63.56 | 8,263.38 | 130 | 8,263.38 | |