Items / CAB-0032
Coaxial Cable Pro CAB-0032 · Cables & Wires · Conduit & Cable Co
On hand (COIL)2MAIN 2
Value (FIFO)533.02avg 266.51
ClassAX / FCV 0.30
Turnover11.7xlast issue 7 days ago
Days of cover2lead time 14d
Reorder suggested: 60 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 | 29.42 / 30.4375 | 0.966 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 8.69 / 5.517 | 1.576 |
| 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.576^2 + 0.966^2 * 3.1^2) | 13.6 |
| Reorder point | d * LT + safety stock | 0.966 * 14.0 + 13.6 | 27.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 27.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 353/yr, S = 45.00, h = 20%, price = 266.61 | 24.4 |
| Inventory position | on hand + on order | 2 + 0 | 2 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 266.61 | 24 | 95,350 | yes (chosen if cheapest) |
MOQ 60, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 23, 2026 | 1 / 60 | 266.51 | 266.51 | |
| Sept. 14, 2026 | 1 / 1 | 266.51 | 266.51 |
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. 9, 2026 | issue | SO-261009-501 | MAIN | 8 | 266.51 | -2,132.07 | 2 | 533.02 | Aug. 23, 2026: 8 @ 266.51 |
| Oct. 4, 2026 | issue | SO-261004-180 | MAIN | 6 | 266.51 | -1,599.06 | 10 | 2,665.09 | Aug. 23, 2026: 6 @ 266.51 |
| Oct. 4, 2026 | issue | SO-261004-180 | EAST | 1 | 266.51 | -266.51 | 16 | 4,264.15 | Aug. 23, 2026: 1 @ 266.51 |
| Oct. 3, 2026 | issue | SO-261003-855 | EAST | 5 | 266.51 | -1,332.55 | 17 | 4,530.66 | Aug. 23, 2026: 5 @ 266.51 |
| Oct. 1, 2026 | issue | SO-261001-751 | EAST | 5 | 266.51 | -1,332.55 | 22 | 5,863.20 | Aug. 23, 2026: 5 @ 266.51 |
| Sept. 30, 2026 | issue | SO-260930-996 | MAIN | 12 | 266.51 | -3,198.11 | 27 | 7,195.75 | Aug. 23, 2026: 12 @ 266.51 |
| Sept. 23, 2026 | issue | SO-260923-851 | MAIN | 14 | 266.51 | -3,731.13 | 39 | 10,393.86 | Aug. 23, 2026: 14 @ 266.51 |
| Sept. 14, 2026 | return | RMA | MAIN | 1 | 266.51 | 266.51 | 53 | 14,124.99 | |
| Sept. 11, 2026 | issue | SO-260911-684 | EAST | 2 | 266.51 | -533.02 | 52 | 13,858.48 | Aug. 23, 2026: 2 @ 266.51 |
| Sept. 2, 2026 | issue | SO-260902-951 | MAIN | 12 | 263.56 | -3,162.72 | 54 | 14,391.50 | July 28, 2026: 6 @ 260.61; Aug. 23, 2026: 6 @ 266.51 |
| Aug. 30, 2026 | issue | SO-260830-901 | MAIN | 7 | 260.61 | -1,824.28 | 66 | 17,554.22 | July 28, 2026: 7 @ 260.61 |
| Aug. 23, 2026 | transfer | TRF | MAIN → EAST | 13 | warehouse transfer, no cost effect | ||||
| Aug. 23, 2026 | receipt | PO-001740 | MAIN | 60 | 266.51 | 15,990.55 | 73 | 19,378.50 | |
| Aug. 13, 2026 | issue | SO-260813-245 | MAIN | 15 | 260.61 | -3,909.17 | 13 | 3,387.95 | July 28, 2026: 15 @ 260.61 |
| Aug. 13, 2026 | issue | SO-260813-245 | EAST | 14 | 260.61 | -3,648.56 | 28 | 7,297.12 | July 28, 2026: 14 @ 260.61 |
| Aug. 7, 2026 | issue | SO-260807-797 | MAIN | 15 | 260.61 | -3,909.17 | 42 | 10,945.68 | July 28, 2026: 15 @ 260.61 |
| July 31, 2026 | issue | SO-260731-777 | MAIN | 1 | 260.61 | -260.61 | 57 | 14,854.85 | July 28, 2026: 1 @ 260.61 |
| July 29, 2026 | issue | SO-260729-546 | MAIN | 7 | 260.82 | -1,825.71 | 58 | 15,115.46 | May 16, 2026: 5 @ 260.90; July 28, 2026: 2 @ 260.61 |
| July 28, 2026 | transfer | TRF | MAIN → EAST | 14 | warehouse transfer, no cost effect | ||||
| July 28, 2026 | receipt | PO-001681 | MAIN | 60 | 260.61 | 15,636.68 | 65 | 16,941.18 | |
| July 27, 2026 | issue | SO-260727-637 | MAIN | 3 | 260.90 | -782.69 | 5 | 1,304.49 | May 16, 2026: 3 @ 260.90 |
| July 17, 2026 | issue | SO-260717-298 | MAIN | 4 | 260.90 | -1,043.59 | 8 | 2,087.19 | May 16, 2026: 4 @ 260.90 |
| July 14, 2026 | issue | SO-260714-308 | MAIN | 18 | 260.90 | -4,696.17 | 12 | 3,130.78 | May 16, 2026: 18 @ 260.90 |
| July 9, 2026 | issue | SO-260709-948 | MAIN | 2 | 260.90 | -521.80 | 30 | 7,826.95 | May 16, 2026: 2 @ 260.90 |
| July 4, 2026 | issue | SO-260704-181 | MAIN | 1 | 260.90 | -260.90 | 32 | 8,348.74 | May 16, 2026: 1 @ 260.90 |
| June 30, 2026 | issue | SO-260630-298 | MAIN | 3 | 260.90 | -782.69 | 33 | 8,609.64 | May 16, 2026: 3 @ 260.90 |
| June 22, 2026 | issue | SO-260622-107 | MAIN | 2 | 260.90 | -521.80 | 36 | 9,392.34 | May 16, 2026: 2 @ 260.90 |
| June 16, 2026 | issue | SO-260616-713 | MAIN | 3 | 260.90 | -782.69 | 38 | 9,914.13 | May 16, 2026: 3 @ 260.90 |
| June 13, 2026 | issue | SO-260613-206 | MAIN | 3 | 260.90 | -782.69 | 41 | 10,696.83 | May 16, 2026: 3 @ 260.90 |
| June 12, 2026 | issue | SO-260612-748 | MAIN | 5 | 260.90 | -1,304.49 | 44 | 11,479.52 | May 16, 2026: 5 @ 260.90 |
| June 9, 2026 | issue | SO-260609-149 | MAIN | 3 | 260.90 | -782.69 | 49 | 12,784.01 | May 16, 2026: 3 @ 260.90 |
| June 6, 2026 | issue | SO-260606-748 | MAIN | 4 | 260.90 | -1,043.59 | 52 | 13,566.71 | May 16, 2026: 4 @ 260.90 |
| May 16, 2026 | issue | SO-260516-551 | MAIN | 6 | 258.20 | -1,549.19 | 56 | 14,610.30 | March 14, 2026: 2 @ 252.80; May 16, 2026: 4 @ 260.90 |
| May 16, 2026 | receipt | PO-001497 | MAIN | 60 | 260.90 | 15,653.89 | 62 | 16,159.49 | |
| May 13, 2026 | issue | SO-260513-560 | MAIN | 1 | 252.80 | -252.80 | 2 | 505.60 | March 14, 2026: 1 @ 252.80 |
| May 7, 2026 | issue | SO-260507-432 | MAIN | 17 | 252.80 | -4,297.57 | 3 | 758.40 | March 14, 2026: 17 @ 252.80 |
| May 2, 2026 | issue | SO-260502-195 | MAIN | 7 | 252.80 | -1,769.59 | 20 | 5,055.97 | March 14, 2026: 7 @ 252.80 |
| April 29, 2026 | issue | SO-260429-784 | MAIN | 3 | 252.80 | -758.40 | 27 | 6,825.56 | March 14, 2026: 3 @ 252.80 |
| April 27, 2026 | issue | SO-260427-843 | MAIN | 3 | 252.80 | -758.40 | 30 | 7,583.95 | March 14, 2026: 3 @ 252.80 |
| April 19, 2026 | issue | SO-260419-167 | MAIN | 3 | 252.80 | -758.40 | 33 | 8,342.35 | March 14, 2026: 3 @ 252.80 |
| April 15, 2026 | issue | SO-260415-388 | MAIN | 1 | 252.80 | -252.80 | 36 | 9,100.74 | March 14, 2026: 1 @ 252.80 |
| April 10, 2026 | issue | SO-260410-447 | MAIN | 12 | 252.80 | -3,033.58 | 37 | 9,353.54 | March 14, 2026: 12 @ 252.80 |
| April 1, 2026 | issue | SO-260401-468 | MAIN | 8 | 252.80 | -2,022.39 | 49 | 12,387.12 | March 14, 2026: 8 @ 252.80 |
| March 29, 2026 | issue | SO-260329-257 | MAIN | 13 | 262.00 | -3,405.98 | 57 | 14,409.51 | Dec. 19, 2025: 10 @ 264.76; March 14, 2026: 3 @ 252.80 |
| March 14, 2026 | receipt | PO-001317 | MAIN | 60 | 252.80 | 15,167.90 | 70 | 17,815.49 | |
| March 1, 2026 | issue | SO-260301-913 | MAIN | 5 | 264.76 | -1,323.79 | 10 | 2,647.59 | Dec. 19, 2025: 5 @ 264.76 |
| Feb. 28, 2026 | issue | SO-260228-450 | MAIN | 7 | 264.76 | -1,853.31 | 15 | 3,971.38 | Dec. 19, 2025: 7 @ 264.76 |
| Feb. 1, 2026 | issue | SO-260201-800 | MAIN | 17 | 264.76 | -4,500.90 | 22 | 5,824.69 | Dec. 19, 2025: 17 @ 264.76 |
| Jan. 29, 2026 | issue | SO-260129-858 | MAIN | 2 | 264.76 | -529.52 | 39 | 10,325.59 | Dec. 19, 2025: 2 @ 264.76 |
| Jan. 19, 2026 | issue | SO-260119-517 | MAIN | 5 | 264.76 | -1,323.79 | 41 | 10,855.11 | Dec. 19, 2025: 5 @ 264.76 |
| Jan. 14, 2026 | issue | SO-260114-196 | MAIN | 3 | 264.76 | -794.28 | 46 | 12,178.90 | Dec. 19, 2025: 3 @ 264.76 |
| Jan. 13, 2026 | issue | SO-260113-587 | MAIN | 4 | 264.76 | -1,059.04 | 49 | 12,973.18 | Dec. 19, 2025: 4 @ 264.76 |
| Jan. 11, 2026 | issue | SO-260111-807 | MAIN | 1 | 264.76 | -264.76 | 53 | 14,032.22 | Dec. 19, 2025: 1 @ 264.76 |
| Jan. 8, 2026 | issue | SO-260108-514 | MAIN | 1 | 264.76 | -264.76 | 54 | 14,296.98 | Dec. 19, 2025: 1 @ 264.76 |
| Jan. 1, 2026 | issue | SO-260101-970 | MAIN | 5 | 264.76 | -1,323.79 | 55 | 14,561.73 | Dec. 19, 2025: 5 @ 264.76 |
| Jan. 1, 2026 | issue | SO-260101-970 | EAST | 4 | 256.28 | -1,025.11 | 60 | 15,885.53 | Oct. 15, 2025: 4 @ 256.28 |
| Dec. 29, 2025 | issue | SO-251229-429 | EAST | 7 | 256.28 | -1,793.94 | 64 | 16,910.64 | Oct. 15, 2025: 7 @ 256.28 |
| Dec. 19, 2025 | receipt | PO-001065 | MAIN | 60 | 264.76 | 15,885.53 | 71 | 18,704.57 | |
| Dec. 11, 2025 | issue | SO-251211-792 | EAST | 1 | 256.28 | -256.28 | 11 | 2,819.05 | Oct. 15, 2025: 1 @ 256.28 |
| Dec. 7, 2025 | issue | SO-251207-244 | EAST | 5 | 256.28 | -1,281.38 | 12 | 3,075.32 | Oct. 15, 2025: 5 @ 256.28 |