Items / CAB-0037
Coaxial Cable Prime CAB-0037 · Cables & Wires · Conduit & Cable Co
On hand (COIL)13MAIN 13
Value (FIFO)2,220.90avg 170.84
ClassAX / FCV 0.22
Turnover13.7xlast issue 2 days ago
Days of cover15lead time 14d
Reorder suggested: 60 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 25.75 / 30.4375 | 0.846 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.75 / 5.517 | 1.042 |
| 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.042^2 + 0.846^2 * 3.1^2) | 9.7 |
| Reorder point | d * LT + safety stock | 0.846 * 14.0 + 9.7 | 21.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 21.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 309/yr, S = 45.00, h = 20%, price = 170.46 | 28.6 |
| Inventory position | on hand + on order | 13 + 0 | 13 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 170.46 | 29 | 53,609 | yes (chosen if cheapest) |
MOQ 60, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 2, 2026 | 13 / 60 | 170.84 | 2,220.90 |
Movement ledger 140 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-867 | MAIN | 1 | 170.84 | -170.84 | 13 | 2,220.90 | Sept. 2, 2026: 1 @ 170.84 |
| Oct. 13, 2026 | issue | SO-261013-164 | MAIN | 13 | 170.84 | -2,220.90 | 14 | 2,391.73 | Sept. 2, 2026: 13 @ 170.84 |
| Oct. 13, 2026 | issue | SO-261013-164 | EAST | 11 | 170.84 | -1,879.22 | 27 | 4,612.63 | Sept. 2, 2026: 11 @ 170.84 |
| Oct. 12, 2026 | issue | SO-261012-354 | EAST | 2 | 170.84 | -341.68 | 38 | 6,491.85 | Sept. 2, 2026: 2 @ 170.84 |
| Oct. 6, 2026 | issue | SO-261006-874 | MAIN | 3 | 170.84 | -512.51 | 40 | 6,833.52 | Sept. 2, 2026: 3 @ 170.84 |
| Oct. 4, 2026 | issue | SO-261004-794 | MAIN | 2 | 170.84 | -341.68 | 43 | 7,346.04 | Sept. 2, 2026: 2 @ 170.84 |
| Sept. 30, 2026 | issue | SO-260930-914 | EAST | 3 | 170.84 | -512.51 | 45 | 7,687.71 | Sept. 2, 2026: 3 @ 170.84 |
| Sept. 22, 2026 | issue | SO-260922-859 | MAIN | 1 | 170.84 | -170.84 | 48 | 8,200.23 | Sept. 2, 2026: 1 @ 170.84 |
| Sept. 20, 2026 | issue | SO-260920-355 | MAIN | 13 | 170.51 | -2,216.58 | 49 | 8,371.07 | July 8, 2026: 2 @ 168.68; Sept. 2, 2026: 11 @ 170.84 |
| Sept. 19, 2026 | issue | SO-260919-268 | MAIN | 1 | 168.68 | -168.68 | 62 | 10,587.65 | July 8, 2026: 1 @ 168.68 |
| Sept. 2, 2026 | transfer | TRF | MAIN → EAST | 16 | warehouse transfer, no cost effect | ||||
| Sept. 2, 2026 | receipt | PO-001769 | MAIN | 60 | 170.84 | 10,250.29 | 63 | 10,756.33 | |
| Aug. 23, 2026 | issue | SO-260823-592 | MAIN | 8 | 168.68 | -1,349.46 | 3 | 506.05 | July 8, 2026: 8 @ 168.68 |
| Aug. 22, 2026 | issue | SO-260822-170 | MAIN | 17 | 168.68 | -2,867.59 | 11 | 1,855.50 | July 8, 2026: 17 @ 168.68 |
| Aug. 18, 2026 | issue | SO-260818-979 | MAIN | 3 | 168.68 | -506.05 | 28 | 4,723.09 | July 8, 2026: 3 @ 168.68 |
| Aug. 14, 2026 | issue | SO-260814-788 | MAIN | 1 | 168.68 | -168.68 | 31 | 5,229.14 | July 8, 2026: 1 @ 168.68 |
| July 28, 2026 | issue | SO-260728-790 | MAIN | 10 | 168.68 | -1,686.82 | 32 | 5,397.82 | July 8, 2026: 10 @ 168.68 |
| July 27, 2026 | issue | SO-260727-435 | MAIN | 4 | 168.68 | -674.73 | 42 | 7,084.64 | July 8, 2026: 4 @ 168.68 |
| July 21, 2026 | issue | SO-260721-614 | MAIN | 15 | 168.41 | -2,526.10 | 46 | 7,759.37 | April 13, 2026: 1 @ 164.55; July 8, 2026: 14 @ 168.68 |
| July 17, 2026 | issue | SO-260717-268 | MAIN | 6 | 163.55 | -981.30 | 61 | 10,285.46 | April 8, 2026: 6 @ 163.55 |
| July 8, 2026 | receipt | PO-001633 | MAIN | 60 | 168.68 | 10,120.91 | 67 | 11,266.76 | |
| June 22, 2026 | issue | SO-260622-121 | MAIN | 16 | 163.55 | -2,616.80 | 7 | 1,145.85 | April 8, 2026: 16 @ 163.55 |
| June 1, 2026 | issue | SO-260601-901 | MAIN | 13 | 163.55 | -2,126.15 | 23 | 3,762.65 | April 8, 2026: 13 @ 163.55 |
| May 19, 2026 | issue | SO-260519-672 | MAIN | 10 | 163.55 | -1,635.50 | 36 | 5,888.80 | April 8, 2026: 10 @ 163.55 |
| May 15, 2026 | issue | SO-260515-423 | MAIN | 1 | 163.55 | -163.55 | 46 | 7,524.30 | April 8, 2026: 1 @ 163.55 |
| May 14, 2026 | issue | SO-260514-861 | MAIN | 1 | 163.55 | -163.55 | 47 | 7,687.85 | April 8, 2026: 1 @ 163.55 |
| May 13, 2026 | issue | SO-260513-362 | MAIN | 3 | 163.55 | -490.65 | 48 | 7,851.40 | April 8, 2026: 3 @ 163.55 |
| May 6, 2026 | issue | SO-260506-216 | MAIN | 4 | 163.55 | -654.20 | 51 | 8,342.05 | April 8, 2026: 4 @ 163.55 |
| May 2, 2026 | issue | SO-260502-549 | MAIN | 5 | 163.55 | -817.75 | 55 | 8,996.25 | April 8, 2026: 5 @ 163.55 |
| April 13, 2026 | return | RMA | MAIN | 1 | 164.55 | 164.55 | 60 | 9,814.00 | |
| April 11, 2026 | issue | SO-260411-975 | MAIN | 8 | 164.55 | -1,316.39 | 59 | 9,649.45 | Feb. 8, 2026: 7 @ 164.69; April 8, 2026: 1 @ 163.55 |
| April 11, 2026 | issue | SO-260411-975 | EAST | 8 | 164.69 | -1,317.53 | 67 | 10,965.84 | Feb. 8, 2026: 8 @ 164.69 |
| April 10, 2026 | issue | SO-260410-689 | MAIN | 3 | 164.69 | -494.07 | 75 | 12,283.37 | Feb. 8, 2026: 3 @ 164.69 |
| April 8, 2026 | receipt | PO-001391 | MAIN | 60 | 163.55 | 9,813.00 | 78 | 12,777.44 | |
| March 26, 2026 | issue | SO-260326-942 | MAIN | 2 | 164.69 | -329.38 | 18 | 2,964.44 | Feb. 8, 2026: 2 @ 164.69 |
| March 23, 2026 | issue | SO-260323-305 | MAIN | 14 | 164.69 | -2,305.68 | 20 | 3,293.82 | Feb. 8, 2026: 14 @ 164.69 |
| March 21, 2026 | issue | SO-260321-745 | EAST | 4 | 164.69 | -658.76 | 34 | 5,599.50 | Feb. 8, 2026: 4 @ 164.69 |
| March 15, 2026 | issue | SO-260315-691 | MAIN | 4 | 164.69 | -658.76 | 38 | 6,258.27 | Feb. 8, 2026: 4 @ 164.69 |
| March 12, 2026 | issue | SO-260312-316 | EAST | 1 | 164.69 | -164.69 | 42 | 6,917.03 | Feb. 8, 2026: 1 @ 164.69 |
| March 3, 2026 | issue | SO-260303-499 | EAST | 1 | 164.69 | -164.69 | 43 | 7,081.72 | Feb. 8, 2026: 1 @ 164.69 |
| Feb. 23, 2026 | issue | SO-260223-260 | MAIN | 1 | 164.69 | -164.69 | 44 | 7,246.41 | Feb. 8, 2026: 1 @ 164.69 |
| Feb. 22, 2026 | issue | SO-260222-198 | MAIN | 4 | 164.69 | -658.76 | 45 | 7,411.10 | Feb. 8, 2026: 4 @ 164.69 |
| Feb. 19, 2026 | issue | SO-260219-385 | MAIN | 4 | 164.69 | -658.76 | 49 | 8,069.87 | Feb. 8, 2026: 4 @ 164.69 |
| Feb. 13, 2026 | issue | SO-260213-591 | MAIN | 3 | 164.69 | -494.07 | 53 | 8,728.63 | Feb. 8, 2026: 3 @ 164.69 |
| Feb. 9, 2026 | issue | SO-260209-216 | MAIN | 4 | 164.69 | -658.76 | 56 | 9,222.71 | Feb. 8, 2026: 4 @ 164.69 |
| Feb. 8, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| Feb. 8, 2026 | receipt | PO-001208 | MAIN | 60 | 164.69 | 9,881.47 | 60 | 9,881.47 | |
| Feb. 7, 2026 | issue | SO-260207-515 | EAST | 2 | 160.08 | -320.16 | 0 | 0.00 | Nov. 26, 2025: 2 @ 160.08 |
| Jan. 28, 2026 | issue | SO-260128-990 | EAST | 2 | 160.08 | -320.16 | 2 | 320.16 | Nov. 26, 2025: 2 @ 160.08 |
| Jan. 26, 2026 | issue | SO-260126-945 | EAST | 2 | 160.08 | -320.16 | 4 | 640.33 | Nov. 26, 2025: 2 @ 160.08 |
| Jan. 25, 2026 | issue | SO-260125-763 | EAST | 7 | 160.08 | -1,120.57 | 6 | 960.49 | Nov. 26, 2025: 7 @ 160.08 |
| Jan. 25, 2026 | issue | SO-260125-763 | MAIN | 7 | 160.08 | -1,120.57 | 13 | 2,081.07 | Nov. 26, 2025: 7 @ 160.08 |
| Jan. 4, 2026 | issue | SO-260104-979 | MAIN | 9 | 160.08 | -1,440.74 | 20 | 3,201.64 | Nov. 26, 2025: 9 @ 160.08 |
| Dec. 27, 2025 | issue | SO-251227-964 | MAIN | 21 | 160.08 | -3,361.72 | 29 | 4,642.38 | Nov. 26, 2025: 21 @ 160.08 |
| Dec. 22, 2025 | issue | SO-251222-771 | MAIN | 1 | 160.08 | -160.08 | 50 | 8,004.10 | Nov. 26, 2025: 1 @ 160.08 |
| Nov. 26, 2025 | issue | SO-251126-820 | MAIN | 19 | 159.07 | -3,022.35 | 51 | 8,164.18 | Sept. 11, 2025: 10 @ 158.16; Nov. 26, 2025: 9 @ 160.08 |
| Nov. 26, 2025 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Nov. 26, 2025 | receipt | PO-001019 | MAIN | 60 | 160.08 | 9,604.92 | 70 | 11,186.53 | |
| Nov. 23, 2025 | issue | SO-251123-507 | MAIN | 4 | 158.16 | -632.65 | 10 | 1,581.61 | Sept. 11, 2025: 4 @ 158.16 |
| Nov. 11, 2025 | issue | SO-251111-304 | MAIN | 3 | 158.16 | -474.48 | 14 | 2,214.26 | Sept. 11, 2025: 3 @ 158.16 |