Items / CAB-0003
Coaxial Cable Classic CAB-0003 · Cables & Wires · Conduit & Cable Co
On hand (COIL)19MAIN 19
Value (FIFO)1,106.89avg 58.26
ClassAX / FCV 0.26
Turnover9.7xlast issue 3 days ago
Days of cover12lead time 14d
Reorder suggested: 100 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 | 49.33 / 30.4375 | 1.621 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 12.92 / 5.517 | 2.342 |
| 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 * 2.342^2 + 1.621^2 * 3.1^2) | 20.8 |
| Reorder point | d * LT + safety stock | 1.621 * 14.0 + 20.8 | 43.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 43.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 592/yr, S = 45.00, h = 20%, price = 59.24 | 67.0 |
| Inventory position | on hand + on order | 19 + 0 | 19 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 59.24 | 67 | 35,840 | yes (chosen if cheapest) |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 30, 2026 | 18 / 100 | 58.26 | 1,048.63 | |
| Sept. 27, 2026 | 1 / 1 | 58.26 | 58.26 |
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. 13, 2026 | issue | SO-261013-746 | MAIN | 6 | 58.26 | -349.54 | 19 | 1,106.89 | Aug. 30, 2026: 6 @ 58.26 |
| Oct. 12, 2026 | issue | SO-261012-888 | MAIN | 25 | 58.26 | -1,456.43 | 25 | 1,456.43 | Aug. 30, 2026: 25 @ 58.26 |
| Oct. 8, 2026 | issue | SO-261008-595 | MAIN | 7 | 58.26 | -407.80 | 50 | 2,912.86 | Aug. 30, 2026: 7 @ 58.26 |
| Oct. 5, 2026 | issue | SO-261005-270 | MAIN | 3 | 58.26 | -174.77 | 57 | 3,320.66 | Aug. 30, 2026: 3 @ 58.26 |
| Oct. 4, 2026 | issue | SO-261004-640 | MAIN | 1 | 58.26 | -58.26 | 60 | 3,495.43 | Aug. 30, 2026: 1 @ 58.26 |
| Sept. 27, 2026 | return | RMA | MAIN | 1 | 58.26 | 58.26 | 61 | 3,553.69 | |
| Sept. 21, 2026 | issue | SO-260921-915 | MAIN | 1 | 58.26 | -58.26 | 60 | 3,495.43 | Aug. 30, 2026: 1 @ 58.26 |
| Sept. 19, 2026 | issue | SO-260919-954 | MAIN | 7 | 58.26 | -407.80 | 61 | 3,553.69 | Aug. 30, 2026: 7 @ 58.26 |
| Sept. 19, 2026 | issue | SO-260919-954 | EAST | 5 | 58.26 | -291.29 | 68 | 3,961.49 | Aug. 30, 2026: 5 @ 58.26 |
| Sept. 17, 2026 | issue | SO-260917-653 | MAIN | 8 | 58.26 | -466.06 | 73 | 4,252.78 | Aug. 30, 2026: 8 @ 58.26 |
| Sept. 11, 2026 | issue | SO-260911-152 | MAIN | 4 | 58.26 | -233.03 | 81 | 4,718.83 | Aug. 30, 2026: 4 @ 58.26 |
| Sept. 3, 2026 | issue | SO-260903-781 | EAST | 13 | 58.26 | -757.34 | 85 | 4,951.86 | Aug. 30, 2026: 13 @ 58.26 |
| Sept. 1, 2026 | issue | SO-260901-353 | EAST | 4 | 57.67 | -230.70 | 98 | 5,709.21 | Aug. 3, 2026: 2 @ 57.09; Aug. 30, 2026: 2 @ 58.26 |
| Aug. 30, 2026 | transfer | TRF | MAIN → EAST | 22 | warehouse transfer, no cost effect | ||||
| Aug. 30, 2026 | receipt | PO-001761 | MAIN | 100 | 58.26 | 5,825.72 | 102 | 5,939.90 | |
| Aug. 14, 2026 | issue | SO-260814-646 | MAIN | 37 | 57.09 | -2,112.41 | 2 | 114.18 | June 16, 2026: 35 @ 57.09; Aug. 3, 2026: 2 @ 57.09 |
| Aug. 11, 2026 | adjustment | Cycle count | MAIN | -2 | 57.09 | -114.18 | 39 | 2,226.60 | June 16, 2026: 2 @ 57.09 |
| Aug. 5, 2026 | issue | SO-260805-421 | MAIN | 6 | 57.09 | -342.55 | 41 | 2,340.78 | June 16, 2026: 6 @ 57.09 |
| Aug. 3, 2026 | return | RMA | MAIN | 4 | 57.09 | 228.37 | 47 | 2,683.33 | |
| July 19, 2026 | issue | SO-260719-757 | MAIN | 8 | 57.09 | -456.74 | 43 | 2,454.96 | June 16, 2026: 8 @ 57.09 |
| July 8, 2026 | issue | SO-260708-326 | MAIN | 22 | 57.09 | -1,256.03 | 51 | 2,911.70 | June 16, 2026: 22 @ 57.09 |
| July 3, 2026 | issue | SO-260703-766 | MAIN | 19 | 57.09 | -1,084.75 | 73 | 4,167.73 | June 16, 2026: 19 @ 57.09 |
| June 28, 2026 | issue | SO-260628-357 | MAIN | 6 | 57.09 | -342.55 | 92 | 5,252.48 | June 16, 2026: 6 @ 57.09 |
| June 20, 2026 | issue | SO-260620-743 | MAIN | 1 | 57.09 | -57.09 | 98 | 5,595.04 | June 16, 2026: 1 @ 57.09 |
| June 19, 2026 | issue | SO-260619-552 | MAIN | 1 | 57.09 | -57.09 | 99 | 5,652.13 | June 16, 2026: 1 @ 57.09 |
| June 16, 2026 | receipt | PO-001576 | MAIN | 100 | 57.09 | 5,709.22 | 100 | 5,709.22 | |
| June 15, 2026 | issue | SO-260615-647 | MAIN | 1 | 58.36 | -58.36 | 0 | 0.00 | March 28, 2026: 1 @ 58.36 |
| June 3, 2026 | issue | SO-260603-551 | MAIN | 17 | 58.36 | -992.15 | 1 | 58.36 | March 28, 2026: 17 @ 58.36 |
| June 2, 2026 | issue | SO-260602-433 | MAIN | 8 | 58.36 | -466.89 | 18 | 1,050.51 | March 28, 2026: 8 @ 58.36 |
| June 1, 2026 | issue | SO-260601-283 | MAIN | 9 | 58.36 | -525.25 | 26 | 1,517.40 | March 28, 2026: 9 @ 58.36 |
| June 1, 2026 | issue | SO-260601-283 | EAST | 3 | 58.36 | -175.08 | 35 | 2,042.66 | March 28, 2026: 3 @ 58.36 |
| May 30, 2026 | issue | SO-260530-820 | MAIN | 3 | 58.36 | -175.08 | 38 | 2,217.74 | March 28, 2026: 3 @ 58.36 |
| May 24, 2026 | issue | SO-260524-972 | EAST | 3 | 58.36 | -175.08 | 41 | 2,392.83 | March 28, 2026: 3 @ 58.36 |
| May 20, 2026 | issue | SO-260520-197 | MAIN | 5 | 58.36 | -291.81 | 44 | 2,567.91 | March 28, 2026: 5 @ 58.36 |
| May 16, 2026 | issue | SO-260516-823 | MAIN | 2 | 58.36 | -116.72 | 49 | 2,859.72 | March 28, 2026: 2 @ 58.36 |
| May 9, 2026 | issue | SO-260509-659 | MAIN | 14 | 58.36 | -817.06 | 51 | 2,976.44 | March 28, 2026: 14 @ 58.36 |
| April 29, 2026 | issue | SO-260429-768 | MAIN | 12 | 58.36 | -700.34 | 65 | 3,793.50 | March 28, 2026: 12 @ 58.36 |
| April 24, 2026 | issue | SO-260424-949 | MAIN | 27 | 58.44 | -1,577.81 | 77 | 4,493.84 | Feb. 20, 2026: 4 @ 58.87; March 28, 2026: 23 @ 58.36 |
| April 23, 2026 | issue | SO-260423-874 | MAIN | 2 | 58.87 | -117.74 | 104 | 6,071.65 | Feb. 20, 2026: 2 @ 58.87 |
| April 10, 2026 | issue | SO-260410-387 | MAIN | 9 | 58.87 | -529.85 | 106 | 6,189.39 | Feb. 20, 2026: 9 @ 58.87 |
| April 2, 2026 | issue | SO-260402-986 | MAIN | 3 | 58.87 | -176.62 | 115 | 6,719.24 | Feb. 20, 2026: 3 @ 58.87 |
| March 28, 2026 | receipt | PO-001362 | MAIN | 100 | 58.36 | 5,836.16 | 118 | 6,895.86 | |
| March 25, 2026 | issue | SO-260325-806 | MAIN | 14 | 58.87 | -824.21 | 18 | 1,059.70 | Feb. 20, 2026: 14 @ 58.87 |
| March 23, 2026 | issue | SO-260323-363 | MAIN | 4 | 58.87 | -235.49 | 32 | 1,883.91 | Feb. 20, 2026: 4 @ 58.87 |
| March 19, 2026 | issue | SO-260319-122 | EAST | 14 | 58.87 | -824.21 | 36 | 2,119.40 | Feb. 20, 2026: 14 @ 58.87 |
| March 5, 2026 | issue | SO-260305-700 | MAIN | 30 | 58.87 | -1,766.17 | 50 | 2,943.62 | Feb. 20, 2026: 30 @ 58.87 |
| Feb. 21, 2026 | issue | SO-260221-890 | MAIN | 1 | 58.87 | -58.87 | 80 | 4,709.78 | Feb. 20, 2026: 1 @ 58.87 |
| Feb. 20, 2026 | issue | SO-260220-972 | MAIN | 19 | 58.87 | -1,118.57 | 81 | 4,768.66 | Feb. 20, 2026: 19 @ 58.87 |
| Feb. 20, 2026 | transfer | TRF | MAIN → EAST | 20 | warehouse transfer, no cost effect | ||||
| Feb. 20, 2026 | receipt | PO-001245 | MAIN | 100 | 58.87 | 5,887.23 | 100 | 5,887.23 | |
| Feb. 5, 2026 | issue | SO-260205-193 | MAIN | 36 | 56.64 | -2,038.92 | 0 | 0.00 | Dec. 27, 2025: 36 @ 56.64 |
| Jan. 28, 2026 | issue | SO-260128-888 | MAIN | 4 | 56.64 | -226.55 | 36 | 2,038.92 | Dec. 27, 2025: 4 @ 56.64 |
| Jan. 13, 2026 | issue | SO-260113-283 | MAIN | 19 | 56.64 | -1,076.10 | 40 | 2,265.47 | Dec. 27, 2025: 19 @ 56.64 |
| Jan. 4, 2026 | issue | SO-260104-725 | MAIN | 28 | 56.64 | -1,585.83 | 59 | 3,341.57 | Dec. 27, 2025: 28 @ 56.64 |
| Jan. 4, 2026 | issue | SO-260104-725 | EAST | 30 | 56.35 | -1,690.42 | 87 | 4,927.39 | Oct. 16, 2025: 17 @ 56.13; Dec. 27, 2025: 13 @ 56.64 |
| Dec. 29, 2025 | issue | SO-251229-125 | MAIN | 7 | 56.13 | -392.88 | 117 | 6,617.82 | Oct. 16, 2025: 7 @ 56.13 |
| Dec. 27, 2025 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| Dec. 27, 2025 | receipt | PO-001094 | MAIN | 100 | 56.64 | 5,663.67 | 124 | 7,010.70 | |
| Dec. 22, 2025 | issue | SO-251222-709 | MAIN | 3 | 56.13 | -168.38 | 24 | 1,347.03 | Oct. 16, 2025: 3 @ 56.13 |
| Dec. 12, 2025 | issue | SO-251212-374 | MAIN | 2 | 56.13 | -112.25 | 27 | 1,515.41 | Oct. 16, 2025: 2 @ 56.13 |