Items / CAB-0001
FR Wire 1.5 sqmm Plus CAB-0001 · Cables & Wires · Conduit & Cable Co
On hand (COIL)53MAIN 35, EAST 18
Value (FIFO)20,380.41avg 384.54
ClassAX / FCV 0.23
Turnover8.1xlast issue 0 days ago
Days of cover39lead 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 | 41.83 / 30.4375 | 1.374 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.79 / 5.517 | 1.774 |
| 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.774^2 + 1.374^2 * 3.1^2) | 16.2 |
| Reorder point | d * LT + safety stock | 1.374 * 14.0 + 16.2 | 35.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 35.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 502/yr, S = 45.00, h = 20%, price = 397.64 | 23.8 |
| Inventory position | on hand + on order | 53 + 0 | 53 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 397.64 | 24 | 201,374 | yes (chosen if cheapest) |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 17, 2026 | 49 / 100 | 384.54 | 18,842.26 | |
| Oct. 14, 2026 | 4 / 4 | 384.54 | 1,538.14 |
Movement ledger 137 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-292 | EAST | 5 | 384.54 | -1,922.68 | 53 | 20,380.41 | Sept. 17, 2026: 5 @ 384.54 |
| Oct. 15, 2026 | issue | SO-261015-858 | MAIN | 9 | 384.54 | -3,460.82 | 58 | 22,303.09 | Sept. 17, 2026: 9 @ 384.54 |
| Oct. 14, 2026 | return | RMA | MAIN | 4 | 384.54 | 1,538.14 | 67 | 25,763.91 | |
| Oct. 9, 2026 | issue | SO-261009-400 | MAIN | 9 | 384.54 | -3,460.82 | 63 | 24,225.77 | Sept. 17, 2026: 9 @ 384.54 |
| Oct. 8, 2026 | issue | SO-261008-462 | MAIN | 2 | 384.54 | -769.07 | 72 | 27,686.59 | Sept. 17, 2026: 2 @ 384.54 |
| Oct. 4, 2026 | issue | SO-261004-541 | MAIN | 12 | 384.54 | -4,614.43 | 74 | 28,455.66 | Sept. 17, 2026: 12 @ 384.54 |
| Oct. 3, 2026 | issue | SO-261003-170 | MAIN | 7 | 384.54 | -2,691.75 | 86 | 33,070.10 | Sept. 17, 2026: 7 @ 384.54 |
| Oct. 2, 2026 | issue | SO-261002-652 | MAIN | 7 | 384.54 | -2,691.75 | 93 | 35,761.85 | Sept. 17, 2026: 7 @ 384.54 |
| Sept. 17, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| Sept. 17, 2026 | receipt | PO-001806 | MAIN | 100 | 384.54 | 38,453.60 | 100 | 38,453.60 | |
| Sept. 12, 2026 | issue | SO-260912-691 | MAIN | 4 | 383.75 | -1,534.98 | 0 | 0.00 | Aug. 4, 2026: 4 @ 383.75 |
| Sept. 10, 2026 | issue | SO-260910-687 | MAIN | 21 | 383.76 | -8,058.96 | 4 | 1,534.98 | July 3, 2026: 19 @ 383.75; July 14, 2026: 1 @ 384.04; Aug. 4, 2026: 1 @ 383.75 |
| Sept. 9, 2026 | issue | SO-260909-742 | MAIN | 3 | 383.75 | -1,151.24 | 25 | 9,593.94 | July 3, 2026: 3 @ 383.75 |
| Sept. 6, 2026 | issue | SO-260906-719 | MAIN | 4 | 383.75 | -1,534.98 | 28 | 10,745.18 | July 3, 2026: 4 @ 383.75 |
| Aug. 30, 2026 | issue | SO-260830-960 | MAIN | 22 | 383.75 | -8,442.41 | 32 | 12,280.16 | July 3, 2026: 22 @ 383.75 |
| Aug. 27, 2026 | issue | SO-260827-214 | MAIN | 4 | 383.75 | -1,534.98 | 54 | 20,722.57 | July 3, 2026: 4 @ 383.75 |
| Aug. 25, 2026 | issue | SO-260825-262 | MAIN | 2 | 383.75 | -767.49 | 58 | 22,257.55 | July 3, 2026: 2 @ 383.75 |
| Aug. 9, 2026 | issue | SO-260809-403 | MAIN | 10 | 383.75 | -3,837.46 | 60 | 23,025.04 | July 3, 2026: 10 @ 383.75 |
| Aug. 4, 2026 | return | RMA | MAIN | 5 | 383.75 | 1,918.73 | 70 | 26,862.50 | |
| Aug. 3, 2026 | issue | SO-260803-853 | MAIN | 1 | 383.75 | -383.75 | 65 | 24,943.77 | July 3, 2026: 1 @ 383.75 |
| July 29, 2026 | issue | SO-260729-155 | MAIN | 3 | 383.75 | -1,151.24 | 66 | 25,327.52 | July 3, 2026: 3 @ 383.75 |
| July 25, 2026 | issue | SO-260725-852 | MAIN | 10 | 383.75 | -3,837.46 | 69 | 26,478.76 | July 3, 2026: 10 @ 383.75 |
| July 21, 2026 | issue | SO-260721-189 | MAIN | 17 | 383.75 | -6,523.68 | 79 | 30,316.21 | July 3, 2026: 17 @ 383.75 |
| July 14, 2026 | return | RMA | MAIN | 1 | 384.04 | 384.04 | 96 | 36,839.89 | |
| July 8, 2026 | issue | SO-260708-983 | MAIN | 6 | 384.04 | -2,304.25 | 95 | 36,455.85 | April 28, 2026: 1 @ 385.52; July 3, 2026: 5 @ 383.75 |
| July 3, 2026 | issue | SO-260703-883 | MAIN | 10 | 385.52 | -3,855.19 | 101 | 38,760.10 | April 28, 2026: 10 @ 385.52 |
| July 3, 2026 | receipt | PO-001621 | MAIN | 100 | 383.75 | 38,374.58 | 111 | 42,615.29 | |
| June 30, 2026 | issue | SO-260630-267 | MAIN | 12 | 385.52 | -4,626.22 | 11 | 4,240.71 | April 28, 2026: 12 @ 385.52 |
| June 26, 2026 | issue | SO-260626-423 | MAIN | 3 | 385.52 | -1,156.56 | 23 | 8,866.93 | April 28, 2026: 3 @ 385.52 |
| June 24, 2026 | issue | SO-260624-927 | MAIN | 2 | 385.52 | -771.04 | 26 | 10,023.49 | April 28, 2026: 2 @ 385.52 |
| June 19, 2026 | issue | SO-260619-809 | MAIN | 6 | 385.52 | -2,313.11 | 28 | 10,794.52 | April 28, 2026: 6 @ 385.52 |
| June 16, 2026 | issue | SO-260616-760 | MAIN | 3 | 385.52 | -1,156.56 | 34 | 13,107.64 | April 28, 2026: 3 @ 385.52 |
| June 12, 2026 | issue | SO-260612-313 | MAIN | 10 | 385.52 | -3,855.19 | 37 | 14,264.19 | April 28, 2026: 10 @ 385.52 |
| May 14, 2026 | issue | SO-260514-882 | MAIN | 46 | 385.52 | -17,733.86 | 47 | 18,119.38 | April 28, 2026: 46 @ 385.52 |
| May 8, 2026 | issue | SO-260508-720 | MAIN | 7 | 385.52 | -2,698.63 | 93 | 35,853.24 | April 28, 2026: 7 @ 385.52 |
| May 4, 2026 | issue | SO-260504-179 | MAIN | 8 | 393.18 | -3,145.46 | 100 | 38,551.87 | Feb. 26, 2026: 6 @ 393.18; March 6, 2026: 1 @ 393.18; April 10, 2026: 1 @ 393.18 |
| April 30, 2026 | issue | SO-260430-396 | MAIN | 11 | 393.18 | -4,325.01 | 108 | 41,697.33 | Feb. 26, 2026: 11 @ 393.18 |
| April 28, 2026 | receipt | PO-001445 | MAIN | 100 | 385.52 | 38,551.87 | 119 | 46,022.34 | |
| April 14, 2026 | issue | SO-260414-175 | MAIN | 9 | 393.18 | -3,538.64 | 19 | 7,470.47 | Feb. 26, 2026: 9 @ 393.18 |
| April 13, 2026 | issue | SO-260413-704 | MAIN | 28 | 393.18 | -11,009.12 | 28 | 11,009.12 | Feb. 26, 2026: 28 @ 393.18 |
| April 11, 2026 | issue | SO-260411-300 | MAIN | 1 | 393.18 | -393.18 | 56 | 22,018.23 | Feb. 26, 2026: 1 @ 393.18 |
| April 10, 2026 | return | RMA | MAIN | 1 | 393.18 | 393.18 | 57 | 22,411.41 | |
| April 9, 2026 | issue | SO-260409-915 | MAIN | 6 | 393.18 | -2,359.10 | 56 | 22,018.23 | Feb. 26, 2026: 6 @ 393.18 |
| March 31, 2026 | issue | SO-260331-803 | MAIN | 3 | 393.18 | -1,179.55 | 62 | 24,377.33 | Feb. 26, 2026: 3 @ 393.18 |
| March 27, 2026 | issue | SO-260327-523 | MAIN | 1 | 393.18 | -393.18 | 65 | 25,556.88 | Feb. 26, 2026: 1 @ 393.18 |
| March 19, 2026 | issue | SO-260319-399 | MAIN | 1 | 393.18 | -393.18 | 66 | 25,950.06 | Feb. 26, 2026: 1 @ 393.18 |
| March 17, 2026 | issue | SO-260317-732 | MAIN | 17 | 393.18 | -6,684.11 | 67 | 26,343.24 | Feb. 26, 2026: 17 @ 393.18 |
| March 16, 2026 | issue | SO-260316-266 | MAIN | 3 | 393.18 | -1,179.55 | 84 | 33,027.35 | Feb. 26, 2026: 3 @ 393.18 |
| March 16, 2026 | issue | SO-260316-266 | EAST | 10 | 393.18 | -3,931.83 | 87 | 34,206.89 | Feb. 26, 2026: 10 @ 393.18 |
| March 6, 2026 | return | RMA | MAIN | 1 | 393.18 | 393.18 | 97 | 38,138.72 | |
| March 3, 2026 | issue | SO-260303-468 | EAST | 4 | 393.18 | -1,572.73 | 96 | 37,745.54 | Feb. 26, 2026: 4 @ 393.18 |
| March 1, 2026 | issue | SO-260301-236 | MAIN | 2 | 383.18 | -766.35 | 100 | 39,318.27 | Dec. 30, 2025: 2 @ 383.18 |
| Feb. 27, 2026 | issue | SO-260227-254 | MAIN | 1 | 383.18 | -383.18 | 102 | 40,084.62 | Dec. 30, 2025: 1 @ 383.18 |
| Feb. 26, 2026 | issue | SO-260226-296 | MAIN | 11 | 383.18 | -4,214.93 | 103 | 40,467.80 | Dec. 30, 2025: 11 @ 383.18 |
| Feb. 26, 2026 | receipt | PO-001258 | MAIN | 100 | 393.18 | 39,318.27 | 114 | 44,682.72 | |
| Feb. 24, 2026 | issue | SO-260224-540 | EAST | 11 | 383.18 | -4,214.93 | 14 | 5,364.45 | Dec. 30, 2025: 11 @ 383.18 |
| Feb. 21, 2026 | issue | SO-260221-763 | EAST | 1 | 383.18 | -383.18 | 25 | 9,579.38 | Dec. 30, 2025: 1 @ 383.18 |
| Feb. 21, 2026 | issue | SO-260221-763 | MAIN | 5 | 383.18 | -1,915.88 | 26 | 9,962.56 | Dec. 30, 2025: 5 @ 383.18 |
| Feb. 16, 2026 | issue | SO-260216-975 | EAST | 8 | 383.18 | -3,065.40 | 31 | 11,878.43 | Dec. 30, 2025: 8 @ 383.18 |
| Feb. 14, 2026 | issue | SO-260214-467 | MAIN | 1 | 383.18 | -383.18 | 39 | 14,943.83 | Dec. 30, 2025: 1 @ 383.18 |