Items / CAB-0040
Cat6 Cable Eco CAB-0040 · Cables & Wires · Conduit & Cable Co
On hand (COIL)60MAIN 60
Value (FIFO)4,524.39avg 75.41
ClassAX / FCV 0.19
Turnover27.7xlast issue 4 days ago
Days of cover19lead time 14d
Reorder suggested: 200 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 | 95.00 / 30.4375 | 3.121 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.62 / 5.517 | 3.193 |
| 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 * 3.193^2 + 3.121^2 * 3.1^2) | 31.6 |
| Reorder point | d * LT + safety stock | 3.121 * 14.0 + 31.6 | 75.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 75.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1139/yr, S = 45.00, h = 20%, price = 75.29 | 82.5 |
| Inventory position | on hand + on order | 60 + 0 | 60 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 75.29 | 83 | 87,014 | yes (chosen if cheapest) |
MOQ 200, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 12, 2026 | 60 / 200 | 75.41 | 4,524.39 |
Movement ledger 136 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-270 | MAIN | 12 | 75.41 | -904.88 | 60 | 4,524.39 | Sept. 12, 2026: 12 @ 75.41 |
| Oct. 11, 2026 | issue | SO-261011-452 | MAIN | 48 | 75.41 | -3,619.51 | 72 | 5,429.27 | Sept. 12, 2026: 48 @ 75.41 |
| Oct. 5, 2026 | issue | SO-261005-312 | MAIN | 11 | 75.41 | -829.47 | 120 | 9,048.78 | Sept. 12, 2026: 11 @ 75.41 |
| Oct. 3, 2026 | issue | SO-261003-753 | MAIN | 8 | 75.41 | -603.25 | 131 | 9,878.25 | Sept. 12, 2026: 8 @ 75.41 |
| Sept. 30, 2026 | issue | SO-260930-266 | MAIN | 9 | 75.41 | -678.66 | 139 | 10,481.50 | Sept. 12, 2026: 9 @ 75.41 |
| Sept. 27, 2026 | issue | SO-260927-188 | MAIN | 16 | 75.41 | -1,206.50 | 148 | 11,160.16 | Sept. 12, 2026: 16 @ 75.41 |
| Sept. 21, 2026 | issue | SO-260921-877 | MAIN | 73 | 74.81 | -5,461.03 | 164 | 12,366.67 | June 15, 2026: 36 @ 74.25; July 2, 2026: 1 @ 73.56; Sept. 12, 2026: 36 @ 75.41 |
| Sept. 12, 2026 | receipt | PO-001793 | MAIN | 200 | 75.41 | 15,081.30 | 237 | 17,827.70 | |
| Aug. 29, 2026 | issue | SO-260829-546 | MAIN | 39 | 74.25 | -2,895.57 | 37 | 2,746.40 | June 15, 2026: 39 @ 74.25 |
| Aug. 27, 2026 | issue | SO-260827-509 | MAIN | 17 | 74.25 | -1,262.17 | 76 | 5,641.97 | June 15, 2026: 17 @ 74.25 |
| Aug. 15, 2026 | issue | SO-260815-654 | MAIN | 23 | 74.25 | -1,707.64 | 93 | 6,904.14 | June 15, 2026: 23 @ 74.25 |
| Aug. 14, 2026 | issue | SO-260814-332 | MAIN | 29 | 74.25 | -2,153.12 | 116 | 8,611.78 | June 15, 2026: 29 @ 74.25 |
| July 26, 2026 | issue | SO-260726-493 | MAIN | 18 | 74.25 | -1,336.42 | 145 | 10,764.90 | June 15, 2026: 18 @ 74.25 |
| July 12, 2026 | issue | SO-260712-879 | MAIN | 10 | 74.25 | -742.45 | 163 | 12,101.32 | June 15, 2026: 10 @ 74.25 |
| July 8, 2026 | issue | SO-260708-248 | MAIN | 51 | 73.94 | -3,770.82 | 173 | 12,843.77 | April 19, 2026: 4 @ 73.56; June 10, 2026: 19 @ 73.56; June 15, 2026: 28 @ 74.25 |
| July 7, 2026 | issue | SO-260707-217 | MAIN | 14 | 73.56 | -1,029.88 | 224 | 16,614.59 | April 19, 2026: 14 @ 73.56 |
| July 2, 2026 | return | RMA | MAIN | 1 | 73.56 | 73.56 | 238 | 17,644.47 | |
| June 21, 2026 | issue | SO-260621-159 | MAIN | 3 | 73.56 | -220.69 | 237 | 17,570.91 | April 19, 2026: 3 @ 73.56 |
| June 19, 2026 | issue | SO-260619-562 | MAIN | 5 | 73.56 | -367.82 | 240 | 17,791.60 | April 19, 2026: 5 @ 73.56 |
| June 15, 2026 | receipt | PO-001574 | MAIN | 200 | 74.25 | 14,849.08 | 245 | 18,159.42 | |
| June 14, 2026 | issue | SO-260614-311 | MAIN | 3 | 73.56 | -220.69 | 45 | 3,310.34 | April 19, 2026: 3 @ 73.56 |
| June 10, 2026 | return | RMA | MAIN | 19 | 73.56 | 1,397.70 | 48 | 3,531.02 | |
| June 10, 2026 | issue | SO-260610-330 | MAIN | 22 | 73.56 | -1,618.39 | 29 | 2,133.33 | April 19, 2026: 22 @ 73.56 |
| June 9, 2026 | issue | SO-260609-367 | MAIN | 1 | 73.56 | -73.56 | 51 | 3,751.71 | April 19, 2026: 1 @ 73.56 |
| June 2, 2026 | issue | SO-260602-487 | MAIN | 20 | 73.56 | -1,471.26 | 52 | 3,825.28 | April 19, 2026: 20 @ 73.56 |
| June 1, 2026 | issue | SO-260601-909 | MAIN | 22 | 73.56 | -1,618.39 | 72 | 5,296.54 | April 19, 2026: 22 @ 73.56 |
| May 25, 2026 | issue | SO-260525-964 | MAIN | 38 | 73.56 | -2,795.39 | 94 | 6,914.92 | April 19, 2026: 38 @ 73.56 |
| May 11, 2026 | issue | SO-260511-374 | MAIN | 73 | 73.48 | -5,363.81 | 132 | 9,710.32 | Feb. 27, 2026: 5 @ 72.30; April 19, 2026: 68 @ 73.56 |
| May 9, 2026 | issue | SO-260509-925 | MAIN | 1 | 72.30 | -72.30 | 205 | 15,074.12 | Feb. 27, 2026: 1 @ 72.30 |
| May 4, 2026 | issue | SO-260504-180 | MAIN | 16 | 72.30 | -1,156.87 | 206 | 15,146.43 | Feb. 27, 2026: 16 @ 72.30 |
| April 19, 2026 | receipt | PO-001422 | MAIN | 200 | 73.56 | 14,712.60 | 222 | 16,303.29 | |
| April 9, 2026 | issue | SO-260409-480 | MAIN | 2 | 72.30 | -144.61 | 22 | 1,590.69 | Feb. 27, 2026: 2 @ 72.30 |
| April 3, 2026 | issue | SO-260403-534 | MAIN | 112 | 72.30 | -8,098.08 | 24 | 1,735.30 | Feb. 27, 2026: 112 @ 72.30 |
| March 30, 2026 | issue | SO-260330-210 | MAIN | 23 | 72.30 | -1,663.00 | 136 | 9,833.38 | Feb. 27, 2026: 23 @ 72.30 |
| March 29, 2026 | issue | SO-260329-967 | MAIN | 10 | 72.30 | -723.04 | 159 | 11,496.38 | Feb. 27, 2026: 10 @ 72.30 |
| March 29, 2026 | issue | SO-260329-967 | EAST | 14 | 72.30 | -1,012.26 | 169 | 12,219.43 | Feb. 27, 2026: 14 @ 72.30 |
| March 24, 2026 | issue | SO-260324-346 | EAST | 1 | 72.30 | -72.30 | 183 | 13,231.69 | Feb. 27, 2026: 1 @ 72.30 |
| March 23, 2026 | issue | SO-260323-165 | MAIN | 13 | 72.30 | -939.96 | 184 | 13,303.99 | Feb. 27, 2026: 13 @ 72.30 |
| March 9, 2026 | issue | SO-260309-193 | MAIN | 7 | 72.13 | -504.94 | 197 | 14,243.95 | Jan. 3, 2026: 4 @ 72.01; Feb. 27, 2026: 3 @ 72.30 |
| March 8, 2026 | issue | SO-260308-839 | MAIN | 1 | 72.01 | -72.01 | 204 | 14,748.89 | Jan. 3, 2026: 1 @ 72.01 |
| March 6, 2026 | issue | SO-260306-836 | MAIN | 10 | 72.01 | -720.07 | 205 | 14,820.89 | Jan. 3, 2026: 10 @ 72.01 |
| Feb. 27, 2026 | receipt | PO-001265 | MAIN | 200 | 72.30 | 14,460.86 | 215 | 15,540.96 | |
| Feb. 24, 2026 | issue | SO-260224-391 | EAST | 17 | 72.01 | -1,224.12 | 15 | 1,080.10 | Jan. 3, 2026: 17 @ 72.01 |
| Feb. 15, 2026 | issue | SO-260215-286 | EAST | 12 | 72.01 | -864.08 | 32 | 2,304.22 | Jan. 3, 2026: 12 @ 72.01 |
| Feb. 15, 2026 | issue | SO-260215-286 | MAIN | 48 | 72.01 | -3,456.33 | 44 | 3,168.30 | Jan. 3, 2026: 48 @ 72.01 |
| Feb. 11, 2026 | issue | SO-260211-611 | MAIN | 6 | 72.01 | -432.04 | 92 | 6,624.63 | Jan. 3, 2026: 6 @ 72.01 |
| Jan. 27, 2026 | issue | SO-260127-559 | MAIN | 9 | 72.01 | -648.06 | 98 | 7,056.68 | Jan. 3, 2026: 9 @ 72.01 |
| Jan. 26, 2026 | issue | SO-260126-249 | MAIN | 1 | 72.01 | -72.01 | 107 | 7,704.74 | Jan. 3, 2026: 1 @ 72.01 |
| Jan. 21, 2026 | issue | SO-260121-702 | MAIN | 11 | 72.01 | -792.08 | 108 | 7,776.75 | Jan. 3, 2026: 11 @ 72.01 |
| Jan. 14, 2026 | issue | SO-260114-486 | EAST | 24 | 72.01 | -1,728.17 | 119 | 8,568.82 | Jan. 3, 2026: 24 @ 72.01 |
| Jan. 12, 2026 | issue | SO-260112-375 | MAIN | 41 | 72.01 | -2,952.28 | 143 | 10,296.99 | Jan. 3, 2026: 41 @ 72.01 |
| Jan. 5, 2026 | issue | SO-260105-389 | MAIN | 16 | 72.01 | -1,152.11 | 184 | 13,249.27 | Jan. 3, 2026: 16 @ 72.01 |
| Jan. 3, 2026 | transfer | TRF | MAIN → EAST | 68 | warehouse transfer, no cost effect | ||||
| Jan. 3, 2026 | receipt | PO-001115 | MAIN | 200 | 72.01 | 14,401.38 | 200 | 14,401.38 | |
| Dec. 21, 2025 | issue | SO-251221-241 | EAST | 9 | 71.42 | -642.82 | 0 | 0.00 | Oct. 25, 2025: 9 @ 71.42 |
| Dec. 21, 2025 | issue | SO-251221-241 | MAIN | 63 | 71.42 | -4,499.76 | 9 | 642.82 | Oct. 25, 2025: 63 @ 71.42 |
| Dec. 20, 2025 | issue | SO-251220-879 | MAIN | 13 | 71.42 | -928.52 | 72 | 5,142.58 | Oct. 25, 2025: 13 @ 71.42 |
| Dec. 5, 2025 | issue | SO-251205-142 | MAIN | 13 | 71.42 | -928.52 | 85 | 6,071.10 | Oct. 25, 2025: 13 @ 71.42 |
| Nov. 30, 2025 | issue | SO-251130-936 | MAIN | 26 | 71.42 | -1,857.04 | 98 | 6,999.62 | Oct. 25, 2025: 26 @ 71.42 |
| Nov. 26, 2025 | issue | SO-251126-624 | EAST | 7 | 71.42 | -499.97 | 124 | 8,856.66 | Oct. 25, 2025: 7 @ 71.42 |