Items / CAB-0008
FR Wire 1.5 sqmm Nova CAB-0008 · Cables & Wires · Conduit & Cable Co
On hand (COIL)95MAIN 95
Value (FIFO)6,045.13avg 63.63
ClassAX / FCV 0.21
Turnover10.3xlast issue 2 days ago
Days of cover49lead 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 | 59.08 / 30.4375 | 1.941 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.24 / 5.517 | 2.218 |
| 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.218^2 + 1.941^2 * 3.1^2) | 21.1 |
| Reorder point | d * LT + safety stock | 1.941 * 14.0 + 21.1 | 48.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 48.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 709/yr, S = 45.00, h = 20%, price = 58.17 | 520.0 |
| Inventory position | on hand + on order | 95 + 0 | 95 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 63.23 | 71 | 45,697 | yes |
| 260 | 60.70 | 260 | 44,708 | yes |
| 520 | 58.17 | 520 | 44,302 | yes (chosen if cheapest) |
MOQ 130, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 28, 2026 | 95 / 130 | 63.63 | 6,045.13 |
Movement ledger 132 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-769 | MAIN | 5 | 63.63 | -318.16 | 95 | 6,045.13 | Sept. 28, 2026: 5 @ 63.63 |
| Oct. 11, 2026 | issue | SO-261011-326 | MAIN | 26 | 63.63 | -1,654.46 | 100 | 6,363.29 | Sept. 28, 2026: 26 @ 63.63 |
| Oct. 5, 2026 | issue | SO-261005-390 | MAIN | 35 | 63.62 | -2,226.55 | 126 | 8,017.75 | July 26, 2026: 16 @ 64.13; July 29, 2026: 15 @ 63.07; Sept. 28, 2026: 4 @ 63.63 |
| Oct. 1, 2026 | issue | SO-261001-299 | MAIN | 5 | 64.13 | -320.63 | 161 | 10,244.30 | July 26, 2026: 5 @ 64.13 |
| Sept. 28, 2026 | receipt | PO-001835 | MAIN | 130 | 63.63 | 8,272.28 | 166 | 10,564.93 | |
| Sept. 27, 2026 | issue | SO-260927-502 | MAIN | 7 | 64.13 | -448.88 | 36 | 2,292.65 | July 26, 2026: 7 @ 64.13 |
| Sept. 15, 2026 | issue | SO-260915-781 | MAIN | 36 | 64.13 | -2,308.54 | 43 | 2,741.53 | July 26, 2026: 36 @ 64.13 |
| Sept. 13, 2026 | issue | SO-260913-660 | MAIN | 2 | 64.13 | -128.25 | 79 | 5,050.07 | July 26, 2026: 2 @ 64.13 |
| Sept. 2, 2026 | issue | SO-260902-599 | MAIN | 15 | 64.13 | -961.89 | 81 | 5,178.32 | July 26, 2026: 15 @ 64.13 |
| Aug. 29, 2026 | issue | SO-260829-928 | MAIN | 1 | 64.13 | -64.13 | 96 | 6,140.21 | July 26, 2026: 1 @ 64.13 |
| Aug. 29, 2026 | issue | SO-260829-928 | EAST | 26 | 64.13 | -1,667.28 | 97 | 6,204.34 | July 26, 2026: 26 @ 64.13 |
| Aug. 22, 2026 | issue | SO-260822-504 | MAIN | 10 | 64.13 | -641.26 | 123 | 7,871.61 | July 26, 2026: 10 @ 64.13 |
| Aug. 11, 2026 | issue | SO-260811-861 | MAIN | 25 | 63.58 | -1,589.38 | 133 | 8,512.87 | May 20, 2026: 13 @ 63.07; July 26, 2026: 12 @ 64.13 |
| July 31, 2026 | issue | SO-260731-589 | MAIN | 9 | 63.07 | -567.60 | 158 | 10,102.25 | May 20, 2026: 9 @ 63.07 |
| July 30, 2026 | issue | SO-260730-191 | MAIN | 8 | 63.07 | -504.54 | 167 | 10,669.86 | May 20, 2026: 8 @ 63.07 |
| July 29, 2026 | return | RMA | MAIN | 15 | 63.07 | 946.00 | 175 | 11,174.39 | |
| July 26, 2026 | transfer | TRF | MAIN → EAST | 26 | warehouse transfer, no cost effect | ||||
| July 26, 2026 | receipt | PO-001673 | MAIN | 130 | 64.13 | 8,336.38 | 160 | 10,228.39 | |
| July 25, 2026 | issue | SO-260725-145 | MAIN | 1 | 63.07 | -63.07 | 30 | 1,892.01 | May 20, 2026: 1 @ 63.07 |
| July 14, 2026 | issue | SO-260714-304 | MAIN | 30 | 63.07 | -1,892.01 | 31 | 1,955.07 | May 20, 2026: 30 @ 63.07 |
| July 10, 2026 | issue | SO-260710-865 | MAIN | 4 | 63.07 | -252.27 | 61 | 3,847.08 | May 20, 2026: 4 @ 63.07 |
| June 30, 2026 | issue | SO-260630-138 | MAIN | 24 | 63.07 | -1,513.61 | 65 | 4,099.35 | May 20, 2026: 24 @ 63.07 |
| June 25, 2026 | issue | SO-260625-388 | MAIN | 8 | 63.07 | -504.54 | 89 | 5,612.95 | May 20, 2026: 8 @ 63.07 |
| June 16, 2026 | issue | SO-260616-209 | MAIN | 3 | 63.07 | -189.20 | 97 | 6,117.49 | May 20, 2026: 3 @ 63.07 |
| June 12, 2026 | issue | SO-260612-304 | MAIN | 8 | 63.07 | -504.54 | 100 | 6,306.69 | May 20, 2026: 8 @ 63.07 |
| June 12, 2026 | issue | SO-260612-304 | EAST | 30 | 62.56 | -1,876.93 | 108 | 6,811.23 | March 17, 2026: 8 @ 61.18; May 20, 2026: 22 @ 63.07 |
| June 10, 2026 | issue | SO-260610-224 | EAST | 3 | 61.18 | -183.55 | 138 | 8,688.16 | March 17, 2026: 3 @ 61.18 |
| June 7, 2026 | issue | SO-260607-770 | EAST | 2 | 61.18 | -122.37 | 141 | 8,871.71 | March 17, 2026: 2 @ 61.18 |
| May 31, 2026 | issue | SO-260531-438 | MAIN | 2 | 61.18 | -122.37 | 143 | 8,994.07 | March 17, 2026: 2 @ 61.18 |
| May 20, 2026 | issue | SO-260520-597 | MAIN | 25 | 61.18 | -1,529.57 | 145 | 9,116.44 | March 17, 2026: 25 @ 61.18 |
| May 20, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| May 20, 2026 | receipt | PO-001509 | MAIN | 130 | 63.07 | 8,198.70 | 170 | 10,646.01 | |
| May 19, 2026 | issue | SO-260519-738 | MAIN | 1 | 61.18 | -61.18 | 40 | 2,447.31 | March 17, 2026: 1 @ 61.18 |
| May 6, 2026 | issue | SO-260506-798 | MAIN | 27 | 61.18 | -1,651.94 | 41 | 2,508.49 | March 17, 2026: 27 @ 61.18 |
| May 3, 2026 | issue | SO-260503-737 | MAIN | 12 | 61.18 | -734.19 | 68 | 4,160.43 | March 17, 2026: 12 @ 61.18 |
| April 28, 2026 | issue | SO-260428-886 | MAIN | 14 | 61.18 | -856.56 | 80 | 4,894.62 | March 17, 2026: 14 @ 61.18 |
| April 12, 2026 | issue | SO-260412-543 | MAIN | 6 | 61.18 | -367.10 | 94 | 5,751.18 | March 17, 2026: 6 @ 61.18 |
| April 10, 2026 | issue | SO-260410-487 | MAIN | 17 | 61.18 | -1,040.11 | 100 | 6,118.28 | March 17, 2026: 17 @ 61.18 |
| April 7, 2026 | issue | SO-260407-429 | EAST | 12 | 61.18 | -734.19 | 117 | 7,158.39 | March 17, 2026: 12 @ 61.18 |
| April 4, 2026 | issue | SO-260404-971 | MAIN | 10 | 62.85 | -628.45 | 129 | 7,892.58 | Feb. 11, 2026: 9 @ 63.03; March 17, 2026: 1 @ 61.18 |
| March 26, 2026 | issue | SO-260326-732 | EAST | 12 | 63.03 | -756.36 | 139 | 8,521.04 | Feb. 11, 2026: 12 @ 63.03 |
| March 23, 2026 | issue | SO-260323-699 | MAIN | 3 | 63.03 | -189.09 | 151 | 9,277.40 | Feb. 11, 2026: 3 @ 63.03 |
| March 17, 2026 | receipt | PO-001325 | MAIN | 130 | 61.18 | 7,953.76 | 154 | 9,466.49 | |
| March 12, 2026 | issue | SO-260312-894 | EAST | 9 | 63.03 | -567.27 | 24 | 1,512.72 | Feb. 11, 2026: 9 @ 63.03 |
| March 6, 2026 | issue | SO-260306-626 | EAST | 9 | 63.03 | -567.27 | 33 | 2,080.00 | Feb. 11, 2026: 9 @ 63.03 |
| March 6, 2026 | issue | SO-260306-626 | MAIN | 10 | 63.03 | -630.30 | 42 | 2,647.27 | Feb. 11, 2026: 10 @ 63.03 |
| March 4, 2026 | issue | SO-260304-830 | MAIN | 4 | 63.03 | -252.12 | 52 | 3,277.57 | Feb. 11, 2026: 4 @ 63.03 |
| March 1, 2026 | issue | SO-260301-617 | MAIN | 9 | 63.03 | -567.27 | 56 | 3,529.69 | Feb. 11, 2026: 9 @ 63.03 |
| Feb. 15, 2026 | issue | SO-260215-816 | MAIN | 45 | 63.03 | -2,836.36 | 65 | 4,096.96 | Feb. 11, 2026: 45 @ 63.03 |
| Feb. 12, 2026 | issue | SO-260212-867 | MAIN | 14 | 63.03 | -882.42 | 110 | 6,933.32 | Feb. 11, 2026: 14 @ 63.03 |
| Feb. 11, 2026 | issue | SO-260211-897 | MAIN | 17 | 61.90 | -1,052.32 | 124 | 7,815.74 | Nov. 7, 2025: 6 @ 61.29; Dec. 25, 2025: 5 @ 61.29; Feb. 11, 2026: 6 @ 63.03 |
| Feb. 11, 2026 | transfer | TRF | MAIN → EAST | 42 | warehouse transfer, no cost effect | ||||
| Feb. 11, 2026 | receipt | PO-001216 | MAIN | 130 | 63.03 | 8,193.93 | 141 | 8,868.07 | |
| Jan. 30, 2026 | issue | SO-260130-867 | MAIN | 57 | 61.29 | -3,493.28 | 11 | 674.14 | Nov. 7, 2025: 57 @ 61.29 |
| Jan. 5, 2026 | issue | SO-260105-927 | MAIN | 3 | 61.29 | -183.86 | 68 | 4,167.42 | Nov. 7, 2025: 3 @ 61.29 |
| Dec. 25, 2025 | return | RMA | MAIN | 5 | 61.29 | 306.43 | 71 | 4,351.28 | |
| Dec. 21, 2025 | issue | SO-251221-459 | MAIN | 11 | 61.29 | -674.14 | 66 | 4,044.85 | Nov. 7, 2025: 11 @ 61.29 |
| Dec. 8, 2025 | issue | SO-251208-233 | MAIN | 30 | 61.29 | -1,838.57 | 77 | 4,718.99 | Nov. 7, 2025: 30 @ 61.29 |
| Nov. 19, 2025 | issue | SO-251119-144 | MAIN | 12 | 61.29 | -735.43 | 107 | 6,557.56 | Nov. 7, 2025: 12 @ 61.29 |
| Nov. 17, 2025 | issue | SO-251117-883 | MAIN | 40 | 60.45 | -2,417.99 | 119 | 7,292.99 | Sept. 5, 2025: 29 @ 60.13; Nov. 7, 2025: 11 @ 61.29 |