Items / CAB-0021
FR Wire 4 sqmm Nova CAB-0021 · Cables & Wires · Conduit & Cable Co
On hand (COIL)3MAIN 3
Value (FIFO)226.59avg 75.53
ClassBX / FCV 0.14
Turnover10.6xlast issue 1 days ago
Days of cover6lead time 14d
Reorder suggested: 40 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 | 14.50 / 30.4375 | 0.476 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.02 / 5.517 | 0.366 |
| 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 * 0.366^2 + 0.476^2 * 3.1^2) | 3.3 |
| Reorder point | d * LT + safety stock | 0.476 * 14.0 + 3.3 | 10.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 10.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 174/yr, S = 45.00, h = 20%, price = 76.30 | 32.0 |
| Inventory position | on hand + on order | 3 + 0 | 3 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 76.30 | 32 | 13,756 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 10, 2026 | 3 / 3 | 75.53 | 226.59 |
Movement ledger 112 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-977 | MAIN | 1 | 75.53 | -75.53 | 3 | 226.59 | Aug. 19, 2026: 1 @ 75.53 |
| Oct. 8, 2026 | issue | SO-261008-209 | MAIN | 19 | 75.53 | -1,435.10 | 4 | 302.13 | Aug. 19, 2026: 19 @ 75.53 |
| Oct. 6, 2026 | issue | SO-261006-854 | MAIN | 1 | 75.53 | -75.53 | 23 | 1,737.23 | Aug. 19, 2026: 1 @ 75.53 |
| Sept. 30, 2026 | issue | SO-260930-530 | MAIN | 3 | 75.53 | -226.59 | 24 | 1,812.76 | Aug. 19, 2026: 3 @ 75.53 |
| Sept. 10, 2026 | return | RMA | MAIN | 3 | 75.53 | 226.59 | 27 | 2,039.35 | |
| Sept. 5, 2026 | issue | SO-260905-626 | MAIN | 7 | 75.53 | -528.72 | 24 | 1,812.76 | Aug. 19, 2026: 7 @ 75.53 |
| Sept. 1, 2026 | issue | SO-260901-387 | MAIN | 6 | 75.53 | -453.19 | 31 | 2,341.48 | Aug. 19, 2026: 6 @ 75.53 |
| Aug. 25, 2026 | issue | SO-260825-165 | MAIN | 4 | 75.87 | -303.46 | 37 | 2,794.67 | May 20, 2026: 1 @ 76.87; Aug. 19, 2026: 3 @ 75.53 |
| Aug. 24, 2026 | issue | SO-260824-603 | MAIN | 7 | 76.87 | -538.08 | 41 | 3,098.13 | May 20, 2026: 7 @ 76.87 |
| Aug. 23, 2026 | issue | SO-260823-836 | MAIN | 1 | 76.87 | -76.87 | 48 | 3,636.21 | May 20, 2026: 1 @ 76.87 |
| Aug. 19, 2026 | receipt | PO-001728 | MAIN | 40 | 75.53 | 3,021.26 | 49 | 3,713.08 | |
| Aug. 8, 2026 | issue | SO-260808-110 | MAIN | 2 | 76.87 | -153.74 | 9 | 691.82 | May 20, 2026: 2 @ 76.87 |
| Aug. 4, 2026 | adjustment | Cycle count | MAIN | -2 | 76.87 | -153.74 | 11 | 845.56 | May 20, 2026: 2 @ 76.87 |
| Aug. 2, 2026 | issue | SO-260802-580 | MAIN | 1 | 76.87 | -76.87 | 13 | 999.29 | May 20, 2026: 1 @ 76.87 |
| July 30, 2026 | issue | SO-260730-897 | MAIN | 1 | 76.87 | -76.87 | 14 | 1,076.16 | May 20, 2026: 1 @ 76.87 |
| July 29, 2026 | issue | SO-260729-668 | MAIN | 1 | 76.87 | -76.87 | 15 | 1,153.03 | May 20, 2026: 1 @ 76.87 |
| July 26, 2026 | issue | SO-260726-605 | MAIN | 5 | 76.87 | -384.34 | 16 | 1,229.90 | May 20, 2026: 5 @ 76.87 |
| July 8, 2026 | issue | SO-260708-104 | MAIN | 6 | 76.87 | -461.21 | 21 | 1,614.24 | May 20, 2026: 6 @ 76.87 |
| June 30, 2026 | issue | SO-260630-984 | MAIN | 5 | 76.87 | -384.34 | 27 | 2,075.45 | May 20, 2026: 5 @ 76.87 |
| June 27, 2026 | issue | SO-260627-826 | MAIN | 4 | 76.87 | -307.47 | 32 | 2,459.80 | May 20, 2026: 4 @ 76.87 |
| June 15, 2026 | issue | SO-260615-149 | MAIN | 5 | 76.12 | -380.62 | 36 | 2,767.27 | March 29, 2026: 1 @ 73.14; May 20, 2026: 4 @ 76.87 |
| June 12, 2026 | issue | SO-260612-574 | MAIN | 1 | 73.14 | -73.14 | 41 | 3,147.89 | March 10, 2026: 1 @ 73.14 |
| May 29, 2026 | issue | SO-260529-895 | MAIN | 3 | 73.14 | -219.43 | 42 | 3,221.03 | March 10, 2026: 3 @ 73.14 |
| May 20, 2026 | receipt | PO-001510 | MAIN | 40 | 76.87 | 3,074.75 | 45 | 3,440.46 | |
| May 4, 2026 | issue | SO-260504-844 | MAIN | 1 | 73.14 | -73.14 | 5 | 365.71 | March 10, 2026: 1 @ 73.14 |
| May 3, 2026 | issue | SO-260503-995 | MAIN | 13 | 73.14 | -950.84 | 6 | 438.85 | March 10, 2026: 13 @ 73.14 |
| April 28, 2026 | issue | SO-260428-960 | MAIN | 6 | 73.14 | -438.85 | 19 | 1,389.69 | March 10, 2026: 6 @ 73.14 |
| April 27, 2026 | issue | SO-260427-729 | MAIN | 3 | 73.14 | -219.43 | 25 | 1,828.54 | March 10, 2026: 3 @ 73.14 |
| April 8, 2026 | issue | SO-260408-602 | MAIN | 4 | 73.14 | -292.57 | 28 | 2,047.97 | March 10, 2026: 4 @ 73.14 |
| March 29, 2026 | return | RMA | MAIN | 1 | 73.14 | 73.14 | 32 | 2,340.54 | |
| March 26, 2026 | issue | SO-260326-862 | MAIN | 3 | 73.14 | -219.43 | 31 | 2,267.40 | March 10, 2026: 3 @ 73.14 |
| March 18, 2026 | issue | SO-260318-814 | MAIN | 13 | 72.43 | -941.54 | 34 | 2,486.82 | Dec. 10, 2025: 7 @ 71.81; March 10, 2026: 6 @ 73.14 |
| March 10, 2026 | receipt | PO-001302 | MAIN | 40 | 73.14 | 2,925.67 | 47 | 3,428.36 | |
| March 9, 2026 | issue | SO-260309-389 | MAIN | 1 | 71.81 | -71.81 | 7 | 502.69 | Dec. 10, 2025: 1 @ 71.81 |
| Feb. 21, 2026 | issue | SO-260221-340 | MAIN | 7 | 71.81 | -502.69 | 8 | 574.50 | Dec. 10, 2025: 7 @ 71.81 |
| Feb. 15, 2026 | issue | SO-260215-394 | MAIN | 2 | 71.81 | -143.63 | 15 | 1,077.19 | Dec. 10, 2025: 2 @ 71.81 |
| Feb. 8, 2026 | issue | SO-260208-386 | EAST | 3 | 71.81 | -215.44 | 17 | 1,220.82 | Dec. 10, 2025: 3 @ 71.81 |
| Jan. 25, 2026 | issue | SO-260125-875 | EAST | 1 | 71.81 | -71.81 | 20 | 1,436.26 | Dec. 10, 2025: 1 @ 71.81 |
| Jan. 24, 2026 | issue | SO-260124-773 | MAIN | 3 | 71.81 | -215.44 | 21 | 1,508.07 | Dec. 10, 2025: 3 @ 71.81 |
| Jan. 20, 2026 | issue | SO-260120-920 | EAST | 5 | 71.81 | -359.06 | 24 | 1,723.51 | Dec. 10, 2025: 5 @ 71.81 |
| Jan. 10, 2026 | issue | SO-260110-527 | EAST | 3 | 71.81 | -215.44 | 29 | 2,082.57 | Dec. 10, 2025: 3 @ 71.81 |
| Jan. 9, 2026 | issue | SO-260109-534 | EAST | 5 | 71.81 | -359.06 | 32 | 2,298.01 | Dec. 10, 2025: 5 @ 71.81 |
| Dec. 20, 2025 | issue | SO-251220-307 | MAIN | 11 | 71.19 | -783.12 | 37 | 2,657.07 | Oct. 5, 2025: 4 @ 70.99; Oct. 5, 2025: 1 @ 70.77; Oct. 9, 2025: 2 @ 70.99; Dec. 7, 2025: 1 @ 70.99; Dec. 10, 2025: 3 @ 71.81 |
| Dec. 10, 2025 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Dec. 10, 2025 | receipt | PO-001042 | MAIN | 40 | 71.81 | 2,872.51 | 48 | 3,440.19 | |
| Dec. 7, 2025 | return | RMA | MAIN | 1 | 70.99 | 70.99 | 8 | 567.68 | |
| Dec. 6, 2025 | issue | SO-251206-832 | MAIN | 3 | 70.99 | -212.96 | 7 | 496.69 | Oct. 5, 2025: 3 @ 70.99 |
| Nov. 25, 2025 | issue | SO-251125-106 | MAIN | 10 | 70.99 | -709.86 | 10 | 709.65 | Oct. 5, 2025: 10 @ 70.99 |
| Nov. 20, 2025 | issue | SO-251120-177 | MAIN | 1 | 70.99 | -70.99 | 20 | 1,419.51 | Oct. 5, 2025: 1 @ 70.99 |
| Nov. 19, 2025 | issue | SO-251119-174 | MAIN | 1 | 70.99 | -70.99 | 21 | 1,490.50 | Oct. 5, 2025: 1 @ 70.99 |
| Nov. 16, 2025 | issue | SO-251116-659 | EAST | 1 | 70.99 | -70.99 | 22 | 1,561.49 | Oct. 5, 2025: 1 @ 70.99 |
| Nov. 8, 2025 | issue | SO-251108-665 | MAIN | 5 | 70.99 | -354.93 | 23 | 1,632.47 | Oct. 5, 2025: 5 @ 70.99 |
| Oct. 28, 2025 | issue | SO-251028-558 | MAIN | 5 | 70.99 | -354.93 | 28 | 1,987.40 | Oct. 5, 2025: 5 @ 70.99 |
| Oct. 26, 2025 | issue | SO-251026-889 | MAIN | 1 | 70.99 | -70.99 | 33 | 2,342.34 | Oct. 5, 2025: 1 @ 70.99 |
| Oct. 20, 2025 | issue | SO-251020-600 | EAST | 1 | 70.99 | -70.99 | 34 | 2,413.32 | Oct. 5, 2025: 1 @ 70.99 |
| Oct. 9, 2025 | return | RMA | MAIN | 2 | 70.99 | 141.97 | 35 | 2,484.31 | |
| Oct. 9, 2025 | issue | SO-251009-242 | EAST | 7 | 70.99 | -496.90 | 33 | 2,342.34 | Oct. 5, 2025: 7 @ 70.99 |
| Oct. 6, 2025 | issue | SO-251006-611 | MAIN | 1 | 70.99 | -70.99 | 40 | 2,839.24 | Oct. 5, 2025: 1 @ 70.99 |
| Oct. 5, 2025 | return | RMA | MAIN | 1 | 70.77 | 70.77 | 41 | 2,910.23 | |
| Oct. 5, 2025 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||