Items / CAB-0005
FR Wire 1.0 sqmm Max CAB-0005 · Cables & Wires · Conduit & Cable Co
On hand (COIL)26MAIN 26
Value (FIFO)2,785.10avg 107.12
ClassAX / FCV 0.23
Turnover8.1xlast issue 0 days ago
Days of cover31lead 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 | 25.83 / 30.4375 | 0.849 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.89 / 5.517 | 1.067 |
| 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 * 1.067^2 + 0.849^2 * 3.1^2) | 9.8 |
| Reorder point | d * LT + safety stock | 0.849 * 14.0 + 9.8 | 21.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 21.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 310/yr, S = 45.00, h = 20%, price = 98.87 | 240.0 |
| Inventory position | on hand + on order | 26 + 0 | 26 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 107.47 | 36 | 34,067 | yes |
| 120 | 103.17 | 120 | 33,315 | yes |
| 240 | 98.87 | 240 | 33,060 | yes (chosen if cheapest) |
MOQ 60, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 23, 2026 | 26 / 60 | 107.12 | 2,785.10 |
Movement ledger 122 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-142 | MAIN | 20 | 107.12 | -2,142.38 | 26 | 2,785.10 | Sept. 23, 2026: 20 @ 107.12 |
| Oct. 16, 2026 | issue | SO-261016-142 | EAST | 10 | 107.12 | -1,071.19 | 46 | 4,927.48 | Sept. 23, 2026: 10 @ 107.12 |
| Oct. 10, 2026 | issue | SO-261010-799 | MAIN | 2 | 107.12 | -214.24 | 56 | 5,998.67 | Sept. 23, 2026: 2 @ 107.12 |
| Sept. 25, 2026 | issue | SO-260925-209 | MAIN | 12 | 108.74 | -1,304.87 | 58 | 6,212.91 | Aug. 9, 2026: 10 @ 109.06; Sept. 23, 2026: 2 @ 107.12 |
| Sept. 23, 2026 | receipt | PO-001822 | MAIN | 60 | 107.12 | 6,427.15 | 70 | 7,517.78 | |
| Sept. 4, 2026 | issue | SO-260904-905 | MAIN | 23 | 109.06 | -2,508.46 | 10 | 1,090.63 | Aug. 9, 2026: 23 @ 109.06 |
| Aug. 24, 2026 | issue | SO-260824-946 | MAIN | 29 | 108.75 | -3,153.74 | 33 | 3,599.09 | June 20, 2026: 2 @ 104.52; Aug. 9, 2026: 27 @ 109.06 |
| Aug. 22, 2026 | issue | SO-260822-735 | EAST | 3 | 104.52 | -313.55 | 62 | 6,752.83 | May 25, 2026: 1 @ 104.52; June 20, 2026: 2 @ 104.52 |
| Aug. 9, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Aug. 9, 2026 | receipt | PO-001707 | MAIN | 60 | 109.06 | 6,543.80 | 65 | 7,066.38 | |
| July 29, 2026 | issue | SO-260729-597 | MAIN | 11 | 104.52 | -1,149.69 | 5 | 522.58 | May 25, 2026: 11 @ 104.52 |
| July 24, 2026 | issue | SO-260724-712 | MAIN | 2 | 104.52 | -209.03 | 16 | 1,672.27 | May 25, 2026: 2 @ 104.52 |
| July 21, 2026 | issue | SO-260721-759 | MAIN | 2 | 104.52 | -209.03 | 18 | 1,881.30 | May 25, 2026: 2 @ 104.52 |
| July 13, 2026 | issue | SO-260713-464 | MAIN | 1 | 104.52 | -104.52 | 20 | 2,090.34 | May 25, 2026: 1 @ 104.52 |
| July 8, 2026 | issue | SO-260708-853 | MAIN | 3 | 104.52 | -313.55 | 21 | 2,194.85 | May 25, 2026: 3 @ 104.52 |
| July 6, 2026 | issue | SO-260706-270 | MAIN | 7 | 104.52 | -731.62 | 24 | 2,508.41 | May 25, 2026: 7 @ 104.52 |
| July 2, 2026 | issue | SO-260702-999 | MAIN | 2 | 104.52 | -209.03 | 31 | 3,240.02 | May 25, 2026: 2 @ 104.52 |
| June 30, 2026 | issue | SO-260630-409 | MAIN | 3 | 104.52 | -313.55 | 33 | 3,449.06 | May 25, 2026: 3 @ 104.52 |
| June 20, 2026 | return | RMA | MAIN | 4 | 104.52 | 418.07 | 36 | 3,762.61 | |
| June 18, 2026 | issue | SO-260618-309 | MAIN | 1 | 104.52 | -104.52 | 32 | 3,344.54 | May 25, 2026: 1 @ 104.52 |
| June 15, 2026 | issue | SO-260615-652 | MAIN | 7 | 104.52 | -731.62 | 33 | 3,449.06 | May 25, 2026: 7 @ 104.52 |
| June 13, 2026 | issue | SO-260613-537 | MAIN | 3 | 104.52 | -313.55 | 40 | 4,180.68 | May 25, 2026: 3 @ 104.52 |
| June 13, 2026 | issue | SO-260613-537 | EAST | 8 | 104.52 | -836.14 | 43 | 4,494.23 | May 25, 2026: 8 @ 104.52 |
| June 11, 2026 | issue | SO-260611-497 | EAST | 5 | 104.52 | -522.58 | 51 | 5,330.36 | May 25, 2026: 5 @ 104.52 |
| May 29, 2026 | issue | SO-260529-890 | MAIN | 5 | 104.27 | -521.36 | 56 | 5,852.95 | March 8, 2026: 1 @ 103.29; May 25, 2026: 4 @ 104.52 |
| May 28, 2026 | issue | SO-260528-364 | MAIN | 1 | 103.29 | -103.29 | 61 | 6,374.31 | March 8, 2026: 1 @ 103.29 |
| May 25, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| May 25, 2026 | receipt | PO-001520 | MAIN | 60 | 104.52 | 6,271.01 | 62 | 6,477.60 | |
| May 16, 2026 | issue | SO-260516-612 | MAIN | 3 | 103.29 | -309.88 | 2 | 206.59 | March 8, 2026: 3 @ 103.29 |
| May 12, 2026 | issue | SO-260512-861 | MAIN | 4 | 103.29 | -413.18 | 5 | 516.47 | March 8, 2026: 4 @ 103.29 |
| May 8, 2026 | issue | SO-260508-450 | MAIN | 14 | 103.29 | -1,446.12 | 9 | 929.65 | March 8, 2026: 14 @ 103.29 |
| April 30, 2026 | issue | SO-260430-246 | MAIN | 7 | 103.29 | -723.06 | 23 | 2,375.77 | March 8, 2026: 7 @ 103.29 |
| April 25, 2026 | issue | SO-260425-528 | MAIN | 8 | 103.29 | -826.35 | 30 | 3,098.83 | March 8, 2026: 8 @ 103.29 |
| April 15, 2026 | issue | SO-260415-599 | MAIN | 1 | 103.29 | -103.29 | 38 | 3,925.18 | March 8, 2026: 1 @ 103.29 |
| April 13, 2026 | issue | SO-260413-738 | MAIN | 3 | 103.29 | -309.88 | 39 | 4,028.48 | March 8, 2026: 3 @ 103.29 |
| April 1, 2026 | issue | SO-260401-655 | MAIN | 1 | 103.29 | -103.29 | 42 | 4,338.36 | March 8, 2026: 1 @ 103.29 |
| March 19, 2026 | issue | SO-260319-897 | MAIN | 8 | 103.29 | -826.35 | 43 | 4,441.65 | March 8, 2026: 8 @ 103.29 |
| March 17, 2026 | issue | SO-260317-898 | MAIN | 13 | 102.65 | -1,334.41 | 51 | 5,268.01 | Dec. 22, 2025: 4 @ 101.19; March 8, 2026: 9 @ 103.29 |
| March 8, 2026 | receipt | PO-001293 | MAIN | 60 | 103.29 | 6,197.66 | 64 | 6,602.41 | |
| March 4, 2026 | issue | SO-260304-901 | MAIN | 1 | 101.19 | -101.19 | 4 | 404.76 | Dec. 22, 2025: 1 @ 101.19 |
| March 1, 2026 | issue | SO-260301-362 | MAIN | 10 | 101.19 | -1,011.89 | 5 | 505.95 | Dec. 22, 2025: 10 @ 101.19 |
| Feb. 22, 2026 | issue | SO-260222-691 | MAIN | 8 | 101.19 | -809.51 | 15 | 1,517.84 | Dec. 22, 2025: 8 @ 101.19 |
| Feb. 11, 2026 | issue | SO-260211-562 | MAIN | 6 | 101.19 | -607.13 | 23 | 2,327.35 | Dec. 22, 2025: 6 @ 101.19 |
| Jan. 25, 2026 | issue | SO-260125-586 | MAIN | 3 | 101.19 | -303.57 | 29 | 2,934.48 | Dec. 22, 2025: 3 @ 101.19 |
| Jan. 17, 2026 | issue | SO-260117-361 | MAIN | 6 | 101.19 | -607.13 | 32 | 3,238.05 | Dec. 22, 2025: 6 @ 101.19 |
| Jan. 12, 2026 | issue | SO-260112-630 | MAIN | 5 | 101.19 | -505.95 | 38 | 3,845.19 | Dec. 22, 2025: 5 @ 101.19 |
| Jan. 10, 2026 | issue | SO-260110-458 | MAIN | 1 | 101.19 | -101.19 | 43 | 4,351.13 | Dec. 22, 2025: 1 @ 101.19 |
| Jan. 6, 2026 | issue | SO-260106-422 | MAIN | 12 | 101.19 | -1,214.27 | 44 | 4,452.32 | Dec. 22, 2025: 12 @ 101.19 |
| Jan. 4, 2026 | issue | SO-260104-178 | MAIN | 1 | 101.19 | -101.19 | 56 | 5,666.59 | Dec. 22, 2025: 1 @ 101.19 |
| Jan. 1, 2026 | issue | SO-260101-265 | MAIN | 3 | 101.19 | -303.57 | 57 | 5,767.78 | Dec. 22, 2025: 3 @ 101.19 |
| Dec. 28, 2025 | issue | SO-251228-228 | MAIN | 1 | 101.26 | -101.26 | 60 | 6,071.35 | Sept. 26, 2025: 1 @ 101.26 |
| Dec. 25, 2025 | issue | SO-251225-113 | MAIN | 5 | 101.26 | -506.30 | 61 | 6,172.60 | Sept. 26, 2025: 5 @ 101.26 |
| Dec. 22, 2025 | receipt | PO-001073 | MAIN | 60 | 101.19 | 6,071.35 | 66 | 6,678.90 | |
| Dec. 18, 2025 | issue | SO-251218-787 | MAIN | 10 | 101.26 | -1,012.59 | 6 | 607.55 | Sept. 26, 2025: 10 @ 101.26 |
| Dec. 8, 2025 | issue | SO-251208-302 | MAIN | 4 | 101.26 | -405.04 | 16 | 1,620.14 | Sept. 26, 2025: 4 @ 101.26 |
| Dec. 1, 2025 | issue | SO-251201-582 | MAIN | 4 | 101.26 | -405.04 | 20 | 2,025.18 | Sept. 26, 2025: 4 @ 101.26 |
| Nov. 27, 2025 | issue | SO-251127-191 | MAIN | 1 | 101.26 | -101.26 | 24 | 2,430.22 | Sept. 26, 2025: 1 @ 101.26 |
| Nov. 26, 2025 | issue | SO-251126-941 | MAIN | 3 | 101.26 | -303.78 | 25 | 2,531.48 | Sept. 26, 2025: 3 @ 101.26 |
| Nov. 21, 2025 | issue | SO-251121-678 | MAIN | 2 | 101.26 | -202.52 | 28 | 2,835.25 | Sept. 26, 2025: 2 @ 101.26 |
| Nov. 7, 2025 | issue | SO-251107-441 | MAIN | 8 | 101.26 | -810.07 | 30 | 3,037.77 | Sept. 26, 2025: 8 @ 101.26 |