Items / CAB-0038
FR Wire 1.0 sqmm Plus CAB-0038 · Cables & Wires · Conduit & Cable Co
On hand (COIL)20MAIN 20
Value (FIFO)1,953.65avg 97.68
ClassBX / FCV 0.25
Turnover10.0xlast issue 1 days ago
Days of cover38lead 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 | 15.92 / 30.4375 | 0.523 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.97 / 5.517 | 0.719 |
| 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.719^2 + 0.523^2 * 3.1^2) | 5.2 |
| Reorder point | d * LT + safety stock | 0.523 * 14.0 + 5.2 | 12.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 12.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 191/yr, S = 45.00, h = 20%, price = 101.30 | 29.1 |
| Inventory position | on hand + on order | 20 + 0 | 20 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 101.30 | 29 | 19,925 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 7, 2026 | 19 / 40 | 97.68 | 1,855.97 | |
| Sept. 25, 2026 | 1 / 1 | 97.68 | 97.68 |
Movement ledger 121 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-239 | MAIN | 14 | 97.68 | -1,367.56 | 20 | 1,953.65 | Sept. 7, 2026: 14 @ 97.68 |
| Oct. 6, 2026 | issue | SO-261006-896 | MAIN | 1 | 97.68 | -97.68 | 34 | 3,321.21 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 25, 2026 | return | RMA | MAIN | 1 | 97.68 | 97.68 | 35 | 3,418.89 | |
| Sept. 25, 2026 | issue | SO-260925-354 | MAIN | 1 | 97.68 | -97.68 | 34 | 3,321.21 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 18, 2026 | issue | SO-260918-360 | MAIN | 1 | 97.68 | -97.68 | 35 | 3,418.89 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 14, 2026 | issue | SO-260914-675 | MAIN | 1 | 97.68 | -97.68 | 36 | 3,516.57 | Sept. 7, 2026: 1 @ 97.68 |
| Sept. 13, 2026 | issue | SO-260913-496 | MAIN | 2 | 97.68 | -195.37 | 37 | 3,614.26 | Sept. 7, 2026: 2 @ 97.68 |
| Sept. 8, 2026 | issue | SO-260908-637 | MAIN | 2 | 98.43 | -196.86 | 39 | 3,809.62 | June 16, 2026: 1 @ 99.18; Sept. 7, 2026: 1 @ 97.68 |
| Sept. 7, 2026 | issue | SO-260907-100 | MAIN | 1 | 99.18 | -99.18 | 41 | 4,006.49 | June 16, 2026: 1 @ 99.18 |
| Sept. 7, 2026 | receipt | PO-001778 | MAIN | 40 | 97.68 | 3,907.30 | 42 | 4,105.67 | |
| Sept. 2, 2026 | issue | SO-260902-527 | MAIN | 5 | 99.18 | -495.91 | 2 | 198.36 | June 16, 2026: 5 @ 99.18 |
| Aug. 18, 2026 | issue | SO-260818-969 | MAIN | 9 | 99.18 | -892.64 | 7 | 694.27 | June 16, 2026: 9 @ 99.18 |
| Aug. 16, 2026 | issue | SO-260816-134 | MAIN | 6 | 99.18 | -595.09 | 16 | 1,586.91 | June 16, 2026: 6 @ 99.18 |
| Aug. 14, 2026 | issue | SO-260814-658 | MAIN | 1 | 99.18 | -99.18 | 22 | 2,182.01 | June 16, 2026: 1 @ 99.18 |
| Aug. 11, 2026 | issue | SO-260811-833 | MAIN | 1 | 99.18 | -99.18 | 23 | 2,281.19 | June 16, 2026: 1 @ 99.18 |
| Aug. 10, 2026 | issue | SO-260810-363 | MAIN | 2 | 99.18 | -198.36 | 24 | 2,380.37 | June 16, 2026: 2 @ 99.18 |
| July 19, 2026 | issue | SO-260719-973 | MAIN | 3 | 99.18 | -297.55 | 26 | 2,578.73 | June 16, 2026: 3 @ 99.18 |
| July 15, 2026 | issue | SO-260715-266 | MAIN | 1 | 99.18 | -99.18 | 29 | 2,876.28 | June 16, 2026: 1 @ 99.18 |
| July 5, 2026 | issue | SO-260705-667 | MAIN | 1 | 99.18 | -99.18 | 30 | 2,975.46 | June 16, 2026: 1 @ 99.18 |
| July 4, 2026 | issue | SO-260704-429 | MAIN | 6 | 99.18 | -595.09 | 31 | 3,074.65 | June 16, 2026: 6 @ 99.18 |
| July 3, 2026 | issue | SO-260703-870 | MAIN | 5 | 100.17 | -500.86 | 37 | 3,669.74 | June 8, 2026: 2 @ 101.66; June 16, 2026: 3 @ 99.18 |
| July 1, 2026 | issue | SO-260701-226 | MAIN | 4 | 101.66 | -406.62 | 42 | 4,170.60 | April 18, 2026: 3 @ 101.66; May 13, 2026: 1 @ 101.66 |
| June 19, 2026 | issue | SO-260619-488 | MAIN | 1 | 101.66 | -101.66 | 46 | 4,577.22 | April 18, 2026: 1 @ 101.66 |
| June 18, 2026 | issue | SO-260618-266 | MAIN | 1 | 101.66 | -101.66 | 47 | 4,678.88 | April 18, 2026: 1 @ 101.66 |
| June 16, 2026 | receipt | PO-001578 | MAIN | 40 | 99.18 | 3,967.28 | 48 | 4,780.53 | |
| June 11, 2026 | issue | SO-260611-874 | MAIN | 5 | 101.66 | -508.28 | 8 | 813.25 | April 18, 2026: 5 @ 101.66 |
| June 8, 2026 | return | RMA | MAIN | 2 | 101.66 | 203.31 | 13 | 1,321.53 | |
| June 4, 2026 | issue | SO-260604-644 | MAIN | 4 | 101.66 | -406.62 | 11 | 1,118.22 | April 18, 2026: 4 @ 101.66 |
| June 3, 2026 | issue | SO-260603-995 | MAIN | 12 | 101.66 | -1,219.87 | 15 | 1,524.84 | April 18, 2026: 12 @ 101.66 |
| May 31, 2026 | issue | SO-260531-782 | MAIN | 1 | 101.66 | -101.66 | 27 | 2,744.72 | April 18, 2026: 1 @ 101.66 |
| May 21, 2026 | issue | SO-260521-527 | MAIN | 1 | 101.66 | -101.66 | 28 | 2,846.37 | April 18, 2026: 1 @ 101.66 |
| May 20, 2026 | issue | SO-260520-569 | MAIN | 2 | 101.66 | -203.31 | 29 | 2,948.03 | April 18, 2026: 2 @ 101.66 |
| May 15, 2026 | issue | SO-260515-501 | MAIN | 1 | 101.66 | -101.66 | 31 | 3,151.34 | April 18, 2026: 1 @ 101.66 |
| May 13, 2026 | return | RMA | MAIN | 1 | 101.66 | 101.66 | 32 | 3,253.00 | |
| May 11, 2026 | issue | SO-260511-712 | MAIN | 5 | 101.66 | -508.28 | 31 | 3,151.34 | April 18, 2026: 5 @ 101.66 |
| May 6, 2026 | issue | SO-260506-934 | MAIN | 1 | 101.66 | -101.66 | 36 | 3,659.62 | April 18, 2026: 1 @ 101.66 |
| May 1, 2026 | issue | SO-260501-825 | MAIN | 3 | 101.66 | -304.97 | 37 | 3,761.28 | April 18, 2026: 3 @ 101.66 |
| April 18, 2026 | receipt | PO-001417 | MAIN | 40 | 101.66 | 4,066.25 | 40 | 4,066.25 | |
| April 3, 2026 | issue | SO-260403-140 | MAIN | 6 | 99.66 | -597.95 | 0 | 0.00 | Jan. 17, 2026: 6 @ 99.66 |
| March 31, 2026 | issue | SO-260331-214 | MAIN | 7 | 99.66 | -697.61 | 6 | 597.95 | Jan. 17, 2026: 7 @ 99.66 |
| March 30, 2026 | issue | SO-260330-664 | MAIN | 1 | 99.66 | -99.66 | 13 | 1,295.55 | Jan. 17, 2026: 1 @ 99.66 |
| March 9, 2026 | issue | SO-260309-467 | MAIN | 3 | 99.66 | -298.97 | 14 | 1,395.21 | Jan. 17, 2026: 3 @ 99.66 |
| March 8, 2026 | issue | SO-260308-965 | MAIN | 5 | 99.66 | -498.29 | 17 | 1,694.18 | Jan. 17, 2026: 5 @ 99.66 |
| Feb. 7, 2026 | issue | SO-260207-201 | MAIN | 4 | 99.66 | -398.63 | 22 | 2,192.47 | Jan. 17, 2026: 4 @ 99.66 |
| Feb. 7, 2026 | issue | SO-260207-201 | EAST | 8 | 99.66 | -797.26 | 26 | 2,591.11 | Jan. 17, 2026: 8 @ 99.66 |
| Feb. 5, 2026 | issue | SO-260205-457 | MAIN | 5 | 99.66 | -498.29 | 34 | 3,388.37 | Jan. 17, 2026: 5 @ 99.66 |
| Jan. 26, 2026 | issue | SO-260126-239 | MAIN | 4 | 96.99 | -387.97 | 39 | 3,886.66 | Nov. 13, 2025: 3 @ 96.10; Jan. 17, 2026: 1 @ 99.66 |
| Jan. 21, 2026 | issue | SO-260121-640 | MAIN | 4 | 96.10 | -384.42 | 43 | 4,274.63 | Nov. 13, 2025: 4 @ 96.10 |
| Jan. 20, 2026 | issue | SO-260120-294 | EAST | 2 | 96.10 | -192.21 | 47 | 4,659.04 | Nov. 13, 2025: 2 @ 96.10 |
| Jan. 17, 2026 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Jan. 17, 2026 | receipt | PO-001152 | MAIN | 40 | 99.66 | 3,986.32 | 49 | 4,851.25 | |
| Jan. 14, 2026 | issue | SO-260114-188 | MAIN | 1 | 96.10 | -96.10 | 9 | 864.93 | Nov. 13, 2025: 1 @ 96.10 |
| Jan. 11, 2026 | issue | SO-260111-735 | MAIN | 1 | 96.10 | -96.10 | 10 | 961.04 | Nov. 13, 2025: 1 @ 96.10 |
| Jan. 7, 2026 | issue | SO-260107-671 | MAIN | 5 | 96.10 | -480.52 | 11 | 1,057.14 | Nov. 13, 2025: 5 @ 96.10 |
| Dec. 10, 2025 | issue | SO-251210-318 | MAIN | 11 | 96.10 | -1,057.14 | 16 | 1,537.66 | Nov. 13, 2025: 11 @ 96.10 |
| Dec. 7, 2025 | issue | SO-251207-796 | MAIN | 3 | 96.10 | -288.31 | 27 | 2,594.80 | Nov. 13, 2025: 3 @ 96.10 |
| Nov. 23, 2025 | issue | SO-251123-773 | MAIN | 9 | 96.10 | -864.93 | 30 | 2,883.11 | Nov. 13, 2025: 9 @ 96.10 |
| Nov. 15, 2025 | issue | SO-251115-479 | MAIN | 1 | 96.10 | -96.10 | 39 | 3,748.05 | Nov. 13, 2025: 1 @ 96.10 |
| Nov. 15, 2025 | issue | SO-251115-479 | EAST | 8 | 95.52 | -764.14 | 40 | 3,844.15 | Aug. 12, 2025: 8 @ 95.52 |
| Nov. 13, 2025 | receipt | PO-000998 | MAIN | 40 | 96.10 | 3,844.15 | 48 | 4,608.29 | |