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
| 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 | ||||
| Oct. 5, 2025 | receipt | PO-000900 | MAIN | 40 | 70.99 | 2,839.45 | 40 | 2,839.45 | |
| Sept. 26, 2025 | issue | SO-250926-415 | EAST | 5 | 70.77 | -353.87 | 0 | 0.00 | July 19, 2025: 5 @ 70.77 |
| Sept. 24, 2025 | issue | SO-250924-995 | EAST | 1 | 70.77 | -70.77 | 5 | 353.87 | July 19, 2025: 1 @ 70.77 |
| Sept. 23, 2025 | issue | SO-250923-304 | EAST | 4 | 70.77 | -283.10 | 6 | 424.65 | July 19, 2025: 4 @ 70.77 |
| Sept. 23, 2025 | issue | SO-250923-304 | MAIN | 2 | 70.77 | -141.55 | 10 | 707.75 | July 19, 2025: 2 @ 70.77 |
| Sept. 17, 2025 | issue | SO-250917-326 | MAIN | 1 | 70.77 | -70.77 | 12 | 849.30 | July 19, 2025: 1 @ 70.77 |
| Sept. 3, 2025 | issue | SO-250903-526 | MAIN | 3 | 70.77 | -212.32 | 13 | 920.07 | July 19, 2025: 3 @ 70.77 |
| Aug. 21, 2025 | issue | SO-250821-909 | MAIN | 6 | 70.77 | -424.65 | 16 | 1,132.40 | July 19, 2025: 6 @ 70.77 |
| Aug. 16, 2025 | issue | SO-250816-181 | MAIN | 6 | 70.77 | -424.65 | 22 | 1,557.05 | July 19, 2025: 6 @ 70.77 |
| Aug. 4, 2025 | issue | SO-250804-128 | MAIN | 6 | 70.77 | -424.65 | 28 | 1,981.69 | July 19, 2025: 6 @ 70.77 |
| July 21, 2025 | issue | SO-250721-127 | MAIN | 6 | 70.77 | -424.65 | 34 | 2,406.34 | July 19, 2025: 6 @ 70.77 |
| July 19, 2025 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| July 19, 2025 | receipt | PO-000724 | MAIN | 40 | 70.77 | 2,830.99 | 40 | 2,830.99 | |
| July 2, 2025 | issue | SO-250702-191 | MAIN | 13 | 70.17 | -912.19 | 0 | 0.00 | May 8, 2025: 13 @ 70.17 |
| June 17, 2025 | issue | SO-250617-400 | MAIN | 2 | 70.17 | -140.34 | 13 | 912.19 | May 8, 2025: 2 @ 70.17 |
| June 16, 2025 | issue | SO-250616-774 | MAIN | 5 | 70.17 | -350.84 | 15 | 1,052.52 | May 8, 2025: 5 @ 70.17 |
| June 5, 2025 | issue | SO-250605-217 | MAIN | 10 | 70.17 | -701.68 | 20 | 1,403.37 | May 8, 2025: 10 @ 70.17 |
| May 27, 2025 | issue | SO-250527-917 | MAIN | 6 | 70.17 | -421.01 | 30 | 2,105.05 | May 8, 2025: 6 @ 70.17 |
| May 10, 2025 | issue | SO-250510-561 | MAIN | 4 | 70.17 | -280.67 | 36 | 2,526.06 | May 8, 2025: 4 @ 70.17 |
| May 8, 2025 | receipt | PO-000523 | MAIN | 40 | 70.17 | 2,806.73 | 40 | 2,806.73 | |
| May 5, 2025 | issue | SO-250505-403 | MAIN | 2 | 73.01 | -146.01 | 0 | 0.00 | Feb. 16, 2025: 2 @ 73.01 |
| April 28, 2025 | issue | SO-250428-841 | MAIN | 6 | 73.01 | -438.04 | 2 | 146.01 | Feb. 16, 2025: 6 @ 73.01 |
| April 24, 2025 | issue | SO-250424-246 | MAIN | 7 | 73.01 | -511.05 | 8 | 584.05 | Feb. 16, 2025: 7 @ 73.01 |
| April 21, 2025 | issue | SO-250421-857 | MAIN | 5 | 73.01 | -365.03 | 15 | 1,095.10 | Feb. 16, 2025: 5 @ 73.01 |
| March 29, 2025 | issue | SO-250329-298 | MAIN | 4 | 73.01 | -292.03 | 20 | 1,460.14 | Feb. 16, 2025: 4 @ 73.01 |
| March 24, 2025 | issue | SO-250324-671 | MAIN | 2 | 73.01 | -146.01 | 24 | 1,752.16 | Feb. 16, 2025: 2 @ 73.01 |
| March 24, 2025 | issue | SO-250324-671 | EAST | 1 | 73.01 | -73.01 | 26 | 1,898.18 | Feb. 16, 2025: 1 @ 73.01 |
| March 18, 2025 | issue | SO-250318-643 | MAIN | 5 | 73.01 | -365.03 | 27 | 1,971.18 | Feb. 16, 2025: 5 @ 73.01 |
| Feb. 24, 2025 | issue | SO-250224-110 | EAST | 2 | 73.01 | -146.01 | 32 | 2,336.22 | Feb. 16, 2025: 2 @ 73.01 |
| Feb. 21, 2025 | issue | SO-250221-313 | MAIN | 1 | 73.01 | -73.01 | 34 | 2,482.23 | Feb. 16, 2025: 1 @ 73.01 |
| Feb. 18, 2025 | issue | SO-250218-518 | EAST | 1 | 73.01 | -73.01 | 35 | 2,555.24 | Feb. 16, 2025: 1 @ 73.01 |
| Feb. 16, 2025 | issue | SO-250216-309 | MAIN | 8 | 71.90 | -575.21 | 36 | 2,628.24 | Nov. 20, 2024: 4 @ 70.80; Feb. 16, 2025: 4 @ 73.01 |
| Feb. 16, 2025 | receipt | PO-000269 | MAIN | 40 | 73.01 | 2,920.27 | 44 | 3,203.46 | |
| Feb. 9, 2025 | issue | SO-250209-273 | EAST | 3 | 70.80 | -212.39 | 4 | 283.19 | Nov. 20, 2024: 3 @ 70.80 |
| Feb. 9, 2025 | issue | SO-250209-273 | MAIN | 3 | 70.80 | -212.39 | 7 | 495.58 | Nov. 20, 2024: 3 @ 70.80 |
| Feb. 3, 2025 | issue | SO-250203-307 | MAIN | 1 | 70.80 | -70.80 | 10 | 707.96 | Nov. 20, 2024: 1 @ 70.80 |
| Jan. 30, 2025 | issue | SO-250130-876 | MAIN | 9 | 70.80 | -637.17 | 11 | 778.76 | Nov. 20, 2024: 9 @ 70.80 |
| Jan. 20, 2025 | issue | SO-250120-725 | MAIN | 10 | 70.80 | -707.96 | 20 | 1,415.93 | Nov. 20, 2024: 10 @ 70.80 |
| Jan. 5, 2025 | issue | SO-250105-352 | MAIN | 1 | 70.80 | -70.80 | 30 | 2,123.90 | Nov. 20, 2024: 1 @ 70.80 |
| Dec. 31, 2024 | issue | SO-241231-188 | EAST | 2 | 70.80 | -141.59 | 31 | 2,194.69 | Nov. 20, 2024: 2 @ 70.80 |
| Dec. 27, 2024 | issue | SO-241227-272 | MAIN | 5 | 70.80 | -353.98 | 33 | 2,336.28 | Nov. 20, 2024: 5 @ 70.80 |
| Dec. 16, 2024 | issue | SO-241216-385 | MAIN | 3 | 71.36 | -214.08 | 38 | 2,690.27 | Oct. 1, 2024: 1 @ 72.48; Nov. 20, 2024: 2 @ 70.80 |
| Dec. 3, 2024 | issue | SO-241203-487 | MAIN | 2 | 72.48 | -144.97 | 41 | 2,904.34 | Oct. 1, 2024: 2 @ 72.48 |
| Dec. 1, 2024 | issue | SO-241201-283 | MAIN | 4 | 72.48 | -289.94 | 43 | 3,049.32 | Oct. 1, 2024: 4 @ 72.48 |
| Nov. 20, 2024 | transfer | TRF | MAIN → EAST | 9 | warehouse transfer, no cost effect | ||||
| Nov. 20, 2024 | receipt | PO-000046 | MAIN | 40 | 70.80 | 2,831.86 | 47 | 3,339.26 | |
| Nov. 15, 2024 | issue | SO-241115-405 | MAIN | 4 | 72.48 | -289.94 | 7 | 507.40 | Oct. 1, 2024: 4 @ 72.48 |
| Nov. 3, 2024 | issue | SO-241103-917 | MAIN | 15 | 72.48 | -1,087.28 | 11 | 797.34 | Oct. 1, 2024: 15 @ 72.48 |
| Nov. 1, 2024 | issue | SO-241101-453 | MAIN | 1 | 72.48 | -72.48 | 26 | 1,884.61 | Oct. 1, 2024: 1 @ 72.48 |
| Oct. 13, 2024 | issue | SO-241013-393 | MAIN | 4 | 72.48 | -289.94 | 27 | 1,957.10 | Oct. 1, 2024: 4 @ 72.48 |
| Oct. 10, 2024 | issue | SO-241010-219 | MAIN | 9 | 72.48 | -652.36 | 31 | 2,247.04 | Oct. 1, 2024: 9 @ 72.48 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 40 | 72.48 | 2,899.40 | 40 | 2,899.40 | |