Items / CAB-0027
FR Wire 4 sqmm Max CAB-0027 · Cables & Wires · Conduit & Cable Co
On hand (COIL)11MAIN 11
Value (FIFO)514.25avg 46.75
ClassAX / FCV 0.18
Turnover10.1xlast issue 4 days ago
Days of cover6lead time 14d
Reorder suggested: 120 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 | 59.00 / 30.4375 | 1.938 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.40 / 5.517 | 1.885 |
| 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.885^2 + 1.938^2 * 3.1^2) | 19.1 |
| Reorder point | d * LT + safety stock | 1.938 * 14.0 + 19.1 | 46.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 46.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 708/yr, S = 45.00, h = 20%, price = 48.45 | 81.1 |
| Inventory position | on hand + on order | 11 + 0 | 11 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 48.45 | 81 | 35,065 | yes (chosen if cheapest) |
MOQ 120, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 15, 2026 | 2 / 4 | 46.75 | 93.50 | |
| Aug. 21, 2026 | 9 / 9 | 46.75 | 420.75 |
Movement ledger 131 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-269 | MAIN | 19 | 46.75 | -888.25 | 11 | 514.25 | Aug. 11, 2026: 17 @ 46.75; Aug. 15, 2026: 2 @ 46.75 |
| Oct. 10, 2026 | issue | SO-261010-133 | MAIN | 21 | 46.75 | -981.75 | 30 | 1,402.51 | Aug. 11, 2026: 21 @ 46.75 |
| Oct. 1, 2026 | issue | SO-261001-986 | MAIN | 4 | 46.75 | -187.00 | 51 | 2,384.26 | Aug. 11, 2026: 4 @ 46.75 |
| Sept. 19, 2026 | issue | SO-260919-967 | MAIN | 6 | 46.75 | -280.50 | 55 | 2,571.26 | Aug. 11, 2026: 6 @ 46.75 |
| Sept. 12, 2026 | issue | SO-260912-819 | MAIN | 3 | 46.75 | -140.25 | 61 | 2,851.76 | Aug. 11, 2026: 3 @ 46.75 |
| Sept. 10, 2026 | issue | SO-260910-451 | MAIN | 21 | 46.75 | -981.75 | 64 | 2,992.01 | Aug. 11, 2026: 21 @ 46.75 |
| Sept. 4, 2026 | issue | SO-260904-927 | MAIN | 14 | 46.75 | -654.50 | 85 | 3,973.77 | Aug. 11, 2026: 14 @ 46.75 |
| Aug. 29, 2026 | issue | SO-260829-345 | MAIN | 1 | 46.75 | -46.75 | 99 | 4,628.27 | Aug. 11, 2026: 1 @ 46.75 |
| Aug. 29, 2026 | issue | SO-260829-345 | EAST | 4 | 46.75 | -187.00 | 100 | 4,675.02 | Aug. 11, 2026: 4 @ 46.75 |
| Aug. 21, 2026 | return | RMA | MAIN | 9 | 46.75 | 420.75 | 104 | 4,862.02 | |
| Aug. 15, 2026 | return | RMA | MAIN | 4 | 46.75 | 187.00 | 95 | 4,441.27 | |
| Aug. 12, 2026 | issue | SO-260812-250 | EAST | 29 | 46.75 | -1,355.76 | 91 | 4,254.27 | Aug. 11, 2026: 29 @ 46.75 |
| Aug. 11, 2026 | transfer | TRF | MAIN → EAST | 33 | warehouse transfer, no cost effect | ||||
| Aug. 11, 2026 | receipt | PO-001712 | MAIN | 120 | 46.75 | 5,610.02 | 120 | 5,610.02 | |
| Aug. 5, 2026 | issue | SO-260805-468 | EAST | 2 | 48.17 | -96.33 | 0 | 0.00 | June 22, 2026: 2 @ 48.17 |
| Aug. 3, 2026 | issue | SO-260803-329 | EAST | 19 | 48.17 | -915.17 | 2 | 96.33 | June 22, 2026: 19 @ 48.17 |
| Aug. 3, 2026 | issue | SO-260803-329 | MAIN | 8 | 48.17 | -385.34 | 21 | 1,011.51 | June 22, 2026: 8 @ 48.17 |
| Aug. 2, 2026 | issue | SO-260802-843 | EAST | 9 | 48.17 | -433.50 | 29 | 1,396.84 | June 22, 2026: 9 @ 48.17 |
| July 31, 2026 | issue | SO-260731-256 | MAIN | 6 | 48.17 | -289.00 | 38 | 1,830.35 | June 22, 2026: 6 @ 48.17 |
| July 25, 2026 | issue | SO-260725-656 | MAIN | 34 | 48.17 | -1,637.68 | 44 | 2,119.35 | June 22, 2026: 34 @ 48.17 |
| July 12, 2026 | issue | SO-260712-416 | MAIN | 35 | 48.17 | -1,685.84 | 78 | 3,757.03 | June 22, 2026: 35 @ 48.17 |
| June 26, 2026 | issue | SO-260626-647 | MAIN | 7 | 48.17 | -337.17 | 113 | 5,442.87 | June 22, 2026: 7 @ 48.17 |
| June 22, 2026 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| June 22, 2026 | receipt | PO-001593 | MAIN | 120 | 48.17 | 5,780.04 | 120 | 5,780.04 | |
| June 19, 2026 | issue | SO-260619-173 | MAIN | 7 | 46.71 | -326.98 | 0 | 0.00 | April 21, 2026: 7 @ 46.71 |
| June 14, 2026 | issue | SO-260614-848 | MAIN | 3 | 46.71 | -140.13 | 7 | 326.98 | April 21, 2026: 3 @ 46.71 |
| June 10, 2026 | issue | SO-260610-657 | MAIN | 29 | 46.71 | -1,354.62 | 10 | 467.11 | April 21, 2026: 29 @ 46.71 |
| June 7, 2026 | issue | SO-260607-951 | MAIN | 3 | 46.71 | -140.13 | 39 | 1,821.73 | April 21, 2026: 3 @ 46.71 |
| June 4, 2026 | issue | SO-260604-449 | MAIN | 3 | 46.71 | -140.13 | 42 | 1,961.86 | April 21, 2026: 3 @ 46.71 |
| May 24, 2026 | issue | SO-260524-381 | MAIN | 17 | 46.71 | -794.09 | 45 | 2,102.00 | April 21, 2026: 17 @ 46.71 |
| May 24, 2026 | issue | SO-260524-381 | EAST | 18 | 46.71 | -840.80 | 62 | 2,896.08 | April 21, 2026: 18 @ 46.71 |
| May 21, 2026 | issue | SO-260521-190 | MAIN | 6 | 46.71 | -280.27 | 80 | 3,736.88 | April 21, 2026: 6 @ 46.71 |
| May 19, 2026 | issue | SO-260519-463 | MAIN | 12 | 46.71 | -560.53 | 86 | 4,017.15 | April 21, 2026: 12 @ 46.71 |
| May 2, 2026 | issue | SO-260502-310 | MAIN | 23 | 46.75 | -1,075.26 | 98 | 4,577.68 | March 4, 2026: 1 @ 47.62; April 21, 2026: 22 @ 46.71 |
| April 24, 2026 | issue | SO-260424-296 | MAIN | 13 | 47.62 | -619.08 | 121 | 5,652.94 | March 4, 2026: 13 @ 47.62 |
| April 23, 2026 | issue | SO-260423-811 | MAIN | 2 | 47.62 | -95.24 | 134 | 6,272.02 | March 4, 2026: 2 @ 47.62 |
| April 22, 2026 | issue | SO-260422-933 | MAIN | 2 | 47.62 | -95.24 | 136 | 6,367.27 | March 4, 2026: 2 @ 47.62 |
| April 21, 2026 | receipt | PO-001425 | MAIN | 120 | 46.71 | 5,605.32 | 138 | 6,462.51 | |
| April 19, 2026 | issue | SO-260419-982 | EAST | 19 | 47.62 | -904.81 | 18 | 857.19 | March 4, 2026: 19 @ 47.62 |
| April 7, 2026 | issue | SO-260407-896 | MAIN | 30 | 47.62 | -1,428.65 | 37 | 1,762.00 | March 4, 2026: 30 @ 47.62 |
| March 25, 2026 | issue | SO-260325-747 | MAIN | 11 | 47.62 | -523.84 | 67 | 3,190.65 | March 4, 2026: 11 @ 47.62 |
| March 23, 2026 | issue | SO-260323-978 | MAIN | 2 | 47.62 | -95.24 | 78 | 3,714.49 | March 4, 2026: 2 @ 47.62 |
| March 17, 2026 | issue | SO-260317-188 | MAIN | 8 | 47.62 | -380.97 | 80 | 3,809.74 | March 4, 2026: 8 @ 47.62 |
| March 13, 2026 | issue | SO-260313-229 | MAIN | 13 | 47.62 | -619.08 | 88 | 4,190.71 | March 4, 2026: 13 @ 47.62 |
| March 11, 2026 | issue | SO-260311-829 | MAIN | 7 | 47.62 | -333.35 | 101 | 4,809.79 | March 4, 2026: 7 @ 47.62 |
| March 9, 2026 | issue | SO-260309-602 | MAIN | 12 | 47.62 | -571.46 | 108 | 5,143.14 | March 4, 2026: 12 @ 47.62 |
| March 4, 2026 | transfer | TRF | MAIN → EAST | 37 | warehouse transfer, no cost effect | ||||
| March 4, 2026 | receipt | PO-001282 | MAIN | 120 | 47.62 | 5,714.60 | 120 | 5,714.60 | |
| Feb. 20, 2026 | issue | SO-260220-249 | MAIN | 55 | 47.94 | -2,636.83 | 0 | 0.00 | Dec. 11, 2025: 55 @ 47.94 |
| Feb. 19, 2026 | issue | SO-260219-418 | MAIN | 6 | 47.94 | -287.65 | 55 | 2,636.83 | Dec. 11, 2025: 6 @ 47.94 |
| Jan. 23, 2026 | issue | SO-260123-621 | MAIN | 22 | 47.94 | -1,054.73 | 61 | 2,924.48 | Dec. 11, 2025: 22 @ 47.94 |
| Jan. 17, 2026 | issue | SO-260117-495 | MAIN | 34 | 47.94 | -1,630.04 | 83 | 3,979.21 | Dec. 11, 2025: 34 @ 47.94 |
| Dec. 29, 2025 | issue | SO-251229-860 | MAIN | 2 | 47.94 | -95.88 | 117 | 5,609.25 | Dec. 11, 2025: 2 @ 47.94 |
| Dec. 13, 2025 | issue | SO-251213-973 | MAIN | 1 | 47.94 | -47.94 | 119 | 5,705.13 | Dec. 11, 2025: 1 @ 47.94 |
| Dec. 11, 2025 | receipt | PO-001044 | MAIN | 120 | 47.94 | 5,753.08 | 120 | 5,753.08 | |
| Dec. 5, 2025 | issue | SO-251205-185 | MAIN | 6 | 46.00 | -275.98 | 0 | 0.00 | Nov. 12, 2025: 6 @ 46.00 |
| Dec. 3, 2025 | issue | SO-251203-296 | MAIN | 33 | 46.00 | -1,517.89 | 6 | 275.98 | Oct. 15, 2025: 23 @ 46.00; Nov. 12, 2025: 10 @ 46.00 |
| Dec. 2, 2025 | issue | SO-251202-886 | MAIN | 1 | 46.00 | -46.00 | 39 | 1,793.87 | Oct. 15, 2025: 1 @ 46.00 |
| Nov. 26, 2025 | issue | SO-251126-963 | MAIN | 28 | 46.00 | -1,287.90 | 40 | 1,839.86 | Oct. 15, 2025: 28 @ 46.00 |
| Nov. 12, 2025 | return | RMA | MAIN | 16 | 46.00 | 735.95 | 68 | 3,127.77 | |