Items / CAB-0036
FR Wire 1.0 sqmm Max CAB-0036 · Cables & Wires · Conduit & Cable Co
On hand (COIL)2MAIN 2
Value (FIFO)196.21avg 98.10
ClassBX / FCV 0.26
Turnover72.7xlast issue 2 days ago
Days of cover2lead time 14d
Reorder suggested: 60 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 24.92 / 30.4375 | 0.819 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.42 / 5.517 | 1.164 |
| 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 * 1.164^2 + 0.819^2 * 3.1^2) | 8.3 |
| Reorder point | d * LT + safety stock | 0.819 * 14.0 + 8.3 | 19.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 19.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 299/yr, S = 45.00, h = 20%, price = 100.27 | 36.6 |
| Inventory position | on hand + on order | 2 + 0 | 2 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 100.27 | 37 | 30,695 | yes (chosen if cheapest) |
MOQ 60, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 26, 2026 | 2 / 6 | 98.10 | 196.21 |
Movement ledger 114 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-571 | MAIN | 11 | 98.10 | -1,079.14 | 2 | 196.21 | Aug. 17, 2026: 7 @ 98.10; Sept. 26, 2026: 4 @ 98.10 |
| Oct. 10, 2026 | issue | SO-261010-318 | MAIN | 3 | 98.10 | -294.31 | 13 | 1,275.35 | Aug. 17, 2026: 3 @ 98.10 |
| Oct. 8, 2026 | issue | SO-261008-509 | MAIN | 7 | 98.10 | -686.73 | 16 | 1,569.66 | Aug. 17, 2026: 7 @ 98.10 |
| Oct. 6, 2026 | issue | SO-261006-786 | MAIN | 8 | 98.10 | -784.83 | 23 | 2,256.38 | Aug. 17, 2026: 8 @ 98.10 |
| Sept. 29, 2026 | issue | SO-260929-383 | MAIN | 8 | 98.10 | -784.83 | 31 | 3,041.21 | Aug. 17, 2026: 8 @ 98.10 |
| Sept. 26, 2026 | return | RMA | MAIN | 6 | 98.10 | 588.62 | 39 | 3,826.04 | |
| Sept. 22, 2026 | issue | SO-260922-647 | MAIN | 5 | 98.10 | -490.52 | 33 | 3,237.42 | Aug. 17, 2026: 5 @ 98.10 |
| Sept. 11, 2026 | issue | SO-260911-498 | MAIN | 12 | 98.10 | -1,177.24 | 38 | 3,727.94 | Aug. 17, 2026: 12 @ 98.10 |
| Aug. 31, 2026 | issue | SO-260831-405 | MAIN | 6 | 98.10 | -588.62 | 50 | 4,905.18 | Aug. 17, 2026: 6 @ 98.10 |
| Aug. 30, 2026 | issue | SO-260830-147 | MAIN | 1 | 98.10 | -98.10 | 56 | 5,493.80 | Aug. 17, 2026: 1 @ 98.10 |
| Aug. 25, 2026 | issue | SO-260825-877 | MAIN | 3 | 98.10 | -294.31 | 57 | 5,591.91 | Aug. 17, 2026: 3 @ 98.10 |
| Aug. 17, 2026 | receipt | PO-001725 | MAIN | 60 | 98.10 | 5,886.22 | 60 | 5,886.22 | |
| Aug. 13, 2026 | issue | SO-260813-615 | EAST | 5 | 97.81 | -489.04 | 0 | 0.00 | June 3, 2026: 2 @ 97.81; July 10, 2026: 3 @ 97.81 |
| Aug. 8, 2026 | issue | SO-260808-578 | EAST | 1 | 97.81 | -97.81 | 5 | 489.04 | June 3, 2026: 1 @ 97.81 |
| Aug. 6, 2026 | issue | SO-260806-213 | EAST | 7 | 97.81 | -684.65 | 6 | 586.84 | June 3, 2026: 7 @ 97.81 |
| Aug. 6, 2026 | issue | SO-260806-213 | MAIN | 14 | 97.81 | -1,369.30 | 13 | 1,271.49 | June 3, 2026: 14 @ 97.81 |
| July 25, 2026 | issue | SO-260725-139 | MAIN | 1 | 97.81 | -97.81 | 27 | 2,640.79 | June 3, 2026: 1 @ 97.81 |
| July 21, 2026 | issue | SO-260721-522 | MAIN | 20 | 97.81 | -1,956.14 | 28 | 2,738.60 | June 3, 2026: 20 @ 97.81 |
| July 10, 2026 | return | RMA | MAIN | 3 | 97.81 | 293.42 | 48 | 4,694.74 | |
| July 5, 2026 | issue | SO-260705-477 | MAIN | 1 | 97.81 | -97.81 | 45 | 4,401.32 | June 3, 2026: 1 @ 97.81 |
| July 3, 2026 | issue | SO-260703-372 | MAIN | 1 | 97.81 | -97.81 | 46 | 4,499.12 | June 3, 2026: 1 @ 97.81 |
| June 29, 2026 | issue | SO-260629-389 | MAIN | 7 | 97.81 | -684.65 | 47 | 4,596.93 | June 3, 2026: 7 @ 97.81 |
| June 14, 2026 | issue | SO-260614-871 | MAIN | 13 | 98.34 | -1,278.42 | 54 | 5,281.58 | March 25, 2026: 7 @ 98.80; June 3, 2026: 6 @ 97.81 |
| June 3, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| June 3, 2026 | receipt | PO-001544 | MAIN | 60 | 97.81 | 5,868.42 | 67 | 6,560.00 | |
| May 29, 2026 | issue | SO-260529-215 | MAIN | 1 | 98.80 | -98.80 | 7 | 691.58 | March 25, 2026: 1 @ 98.80 |
| May 26, 2026 | issue | SO-260526-938 | MAIN | 1 | 98.80 | -98.80 | 8 | 790.38 | March 25, 2026: 1 @ 98.80 |
| May 21, 2026 | issue | SO-260521-353 | MAIN | 30 | 98.80 | -2,963.92 | 9 | 889.18 | March 25, 2026: 30 @ 98.80 |
| April 29, 2026 | issue | SO-260429-586 | MAIN | 5 | 98.80 | -493.99 | 39 | 3,853.10 | March 25, 2026: 5 @ 98.80 |
| April 24, 2026 | issue | SO-260424-643 | MAIN | 10 | 98.80 | -987.97 | 44 | 4,347.09 | March 25, 2026: 10 @ 98.80 |
| April 18, 2026 | issue | SO-260418-535 | MAIN | 5 | 98.80 | -493.99 | 54 | 5,335.06 | March 25, 2026: 5 @ 98.80 |
| April 2, 2026 | issue | SO-260402-944 | MAIN | 2 | 98.23 | -196.47 | 59 | 5,829.05 | Jan. 5, 2026: 1 @ 97.67; March 25, 2026: 1 @ 98.80 |
| March 25, 2026 | receipt | PO-001351 | MAIN | 60 | 98.80 | 5,927.84 | 61 | 6,025.51 | |
| March 10, 2026 | issue | SO-260310-984 | MAIN | 25 | 97.67 | -2,441.74 | 1 | 97.67 | Jan. 5, 2026: 25 @ 97.67 |
| March 8, 2026 | issue | SO-260308-719 | MAIN | 7 | 97.67 | -683.69 | 26 | 2,539.41 | Jan. 5, 2026: 7 @ 97.67 |
| Feb. 24, 2026 | issue | SO-260224-419 | MAIN | 10 | 97.67 | -976.70 | 33 | 3,223.10 | Jan. 5, 2026: 10 @ 97.67 |
| Feb. 23, 2026 | issue | SO-260223-976 | MAIN | 2 | 97.67 | -195.34 | 43 | 4,199.80 | Jan. 5, 2026: 2 @ 97.67 |
| Feb. 18, 2026 | issue | SO-260218-523 | MAIN | 5 | 97.67 | -488.35 | 45 | 4,395.14 | Jan. 5, 2026: 5 @ 97.67 |
| Feb. 16, 2026 | issue | SO-260216-252 | MAIN | 1 | 97.67 | -97.67 | 50 | 4,883.49 | Jan. 5, 2026: 1 @ 97.67 |
| Feb. 9, 2026 | issue | SO-260209-720 | MAIN | 5 | 97.67 | -488.35 | 51 | 4,981.16 | Jan. 5, 2026: 5 @ 97.67 |
| Feb. 5, 2026 | issue | SO-260205-155 | MAIN | 1 | 97.67 | -97.67 | 56 | 5,469.51 | Jan. 5, 2026: 1 @ 97.67 |
| Jan. 20, 2026 | issue | SO-260120-984 | MAIN | 9 | 97.86 | -880.77 | 57 | 5,567.18 | Oct. 22, 2025: 6 @ 97.96; Jan. 5, 2026: 3 @ 97.67 |
| Jan. 14, 2026 | issue | SO-260114-786 | MAIN | 11 | 97.96 | -1,077.55 | 66 | 6,447.94 | Oct. 22, 2025: 11 @ 97.96 |
| Jan. 5, 2026 | receipt | PO-001122 | MAIN | 60 | 97.67 | 5,860.19 | 77 | 7,525.50 | |
| Dec. 25, 2025 | issue | SO-251225-300 | MAIN | 16 | 97.96 | -1,567.35 | 17 | 1,665.31 | Oct. 22, 2025: 16 @ 97.96 |
| Dec. 8, 2025 | issue | SO-251208-999 | MAIN | 1 | 97.96 | -97.96 | 33 | 3,232.66 | Oct. 22, 2025: 1 @ 97.96 |
| Nov. 30, 2025 | issue | SO-251130-228 | MAIN | 15 | 97.96 | -1,469.39 | 34 | 3,330.62 | Oct. 22, 2025: 15 @ 97.96 |
| Nov. 30, 2025 | issue | SO-251130-228 | EAST | 6 | 97.96 | -587.76 | 49 | 4,800.02 | Oct. 22, 2025: 6 @ 97.96 |
| Nov. 18, 2025 | issue | SO-251118-768 | EAST | 1 | 97.96 | -97.96 | 55 | 5,387.77 | Oct. 22, 2025: 1 @ 97.96 |
| Nov. 13, 2025 | issue | SO-251113-828 | MAIN | 5 | 96.94 | -484.72 | 56 | 5,485.73 | Sept. 14, 2025: 1 @ 92.88; Oct. 22, 2025: 4 @ 97.96 |
| Nov. 7, 2025 | issue | SO-251107-480 | EAST | 6 | 92.88 | -557.28 | 61 | 5,970.45 | Sept. 14, 2025: 6 @ 92.88 |
| Oct. 22, 2025 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Oct. 22, 2025 | receipt | PO-000939 | MAIN | 60 | 97.96 | 5,877.57 | 67 | 6,527.73 | |
| Oct. 14, 2025 | issue | SO-251014-174 | MAIN | 2 | 92.88 | -185.76 | 7 | 650.16 | Aug. 6, 2025: 2 @ 92.88 |
| Oct. 10, 2025 | issue | SO-251010-659 | MAIN | 21 | 92.88 | -1,950.47 | 9 | 835.91 | Aug. 6, 2025: 21 @ 92.88 |
| Sept. 23, 2025 | issue | SO-250923-928 | MAIN | 12 | 92.88 | -1,114.55 | 30 | 2,786.38 | Aug. 6, 2025: 12 @ 92.88 |
| Sept. 14, 2025 | return | RMA | MAIN | 7 | 92.88 | 650.16 | 42 | 3,900.93 | |
| Sept. 12, 2025 | issue | SO-250912-685 | MAIN | 1 | 92.88 | -92.88 | 35 | 3,250.78 | Aug. 6, 2025: 1 @ 92.88 |
| Sept. 8, 2025 | issue | SO-250908-154 | MAIN | 2 | 92.88 | -185.76 | 36 | 3,343.65 | Aug. 6, 2025: 2 @ 92.88 |
| Sept. 2, 2025 | issue | SO-250902-916 | MAIN | 14 | 92.88 | -1,300.31 | 38 | 3,529.41 | Aug. 6, 2025: 14 @ 92.88 |