Items / CON-0026
Cable Tray 2m Plus CON-0026 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)100MAIN 47, EAST 53
Value (FIFO)2,885.26avg 28.85
ClassBX / FCV 0.23
Turnover4.3xlast issue 2 days ago
Days of cover45lead 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 | 67.17 / 30.4375 | 2.207 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 15.36 / 5.517 | 2.783 |
| 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 * 2.783^2 + 2.207^2 * 3.1^2) | 20.5 |
| Reorder point | d * LT + safety stock | 2.207 * 14.0 + 20.5 | 51.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 51.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 805/yr, S = 45.00, h = 20%, price = 29.85 | 110.2 |
| Inventory position | on hand + on order | 100 + 0 | 100 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 29.85 | 110 | 24,700 | yes (chosen if cheapest) |
MOQ 320, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 3, 2026 | 100 / 320 | 28.85 | 2,885.26 |
Movement ledger 118 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-994 | EAST | 25 | 28.85 | -721.32 | 100 | 2,885.26 | Aug. 3, 2026: 25 @ 28.85 |
| Oct. 11, 2026 | issue | SO-261011-729 | MAIN | 30 | 28.85 | -865.58 | 125 | 3,606.58 | Aug. 3, 2026: 30 @ 28.85 |
| Oct. 10, 2026 | issue | SO-261010-695 | MAIN | 32 | 28.85 | -923.28 | 155 | 4,472.15 | Aug. 3, 2026: 32 @ 28.85 |
| Oct. 7, 2026 | issue | SO-261007-405 | MAIN | 26 | 28.85 | -750.17 | 187 | 5,395.44 | Aug. 3, 2026: 26 @ 28.85 |
| Sept. 28, 2026 | issue | SO-260928-584 | MAIN | 47 | 28.85 | -1,356.07 | 213 | 6,145.60 | Aug. 3, 2026: 47 @ 28.85 |
| Sept. 26, 2026 | issue | SO-260926-883 | MAIN | 6 | 28.85 | -173.12 | 260 | 7,501.68 | Aug. 3, 2026: 6 @ 28.85 |
| Sept. 14, 2026 | issue | SO-260914-820 | EAST | 7 | 28.85 | -201.97 | 266 | 7,674.79 | Aug. 3, 2026: 7 @ 28.85 |
| Aug. 26, 2026 | issue | SO-260826-746 | EAST | 2 | 28.85 | -57.71 | 273 | 7,876.76 | Aug. 3, 2026: 2 @ 28.85 |
| Aug. 24, 2026 | issue | SO-260824-562 | MAIN | 14 | 28.85 | -403.94 | 275 | 7,934.46 | Aug. 3, 2026: 14 @ 28.85 |
| Aug. 21, 2026 | issue | SO-260821-325 | MAIN | 22 | 28.85 | -634.76 | 289 | 8,338.40 | Aug. 3, 2026: 22 @ 28.85 |
| Aug. 17, 2026 | issue | SO-260817-315 | MAIN | 17 | 28.68 | -487.50 | 311 | 8,973.16 | March 1, 2026: 8 @ 28.48; Aug. 3, 2026: 9 @ 28.85 |
| Aug. 14, 2026 | issue | SO-260814-641 | MAIN | 3 | 28.48 | -85.44 | 328 | 9,460.66 | March 1, 2026: 3 @ 28.48 |
| Aug. 13, 2026 | issue | SO-260813-518 | MAIN | 28 | 28.48 | -797.40 | 331 | 9,546.10 | March 1, 2026: 28 @ 28.48 |
| Aug. 3, 2026 | transfer | TRF | MAIN → EAST | 87 | warehouse transfer, no cost effect | ||||
| Aug. 3, 2026 | receipt | PO-001694 | MAIN | 320 | 28.85 | 9,232.83 | 359 | 10,343.50 | |
| July 28, 2026 | issue | SO-260728-163 | MAIN | 4 | 28.48 | -113.91 | 39 | 1,110.67 | March 1, 2026: 4 @ 28.48 |
| July 25, 2026 | issue | SO-260725-130 | MAIN | 1 | 28.48 | -28.48 | 43 | 1,224.58 | March 1, 2026: 1 @ 28.48 |
| July 20, 2026 | issue | SO-260720-893 | MAIN | 19 | 28.48 | -541.09 | 44 | 1,253.06 | March 1, 2026: 19 @ 28.48 |
| July 17, 2026 | issue | SO-260717-133 | MAIN | 28 | 28.48 | -797.40 | 63 | 1,794.15 | March 1, 2026: 28 @ 28.48 |
| July 12, 2026 | issue | SO-260712-286 | MAIN | 10 | 28.48 | -284.79 | 91 | 2,591.55 | March 1, 2026: 10 @ 28.48 |
| July 11, 2026 | issue | SO-260711-748 | MAIN | 15 | 28.48 | -427.18 | 101 | 2,876.34 | March 1, 2026: 15 @ 28.48 |
| July 8, 2026 | issue | SO-260708-913 | MAIN | 12 | 28.48 | -341.74 | 116 | 3,303.52 | March 1, 2026: 12 @ 28.48 |
| June 30, 2026 | issue | SO-260630-933 | MAIN | 32 | 28.48 | -911.32 | 128 | 3,645.26 | March 1, 2026: 32 @ 28.48 |
| June 21, 2026 | issue | SO-260621-546 | MAIN | 2 | 28.48 | -56.96 | 160 | 4,556.58 | March 1, 2026: 2 @ 28.48 |
| June 19, 2026 | issue | SO-260619-391 | MAIN | 13 | 28.48 | -370.22 | 162 | 4,613.53 | March 1, 2026: 13 @ 28.48 |
| June 1, 2026 | issue | SO-260601-688 | MAIN | 4 | 28.48 | -113.91 | 175 | 4,983.76 | March 1, 2026: 4 @ 28.48 |
| May 25, 2026 | issue | SO-260525-681 | MAIN | 6 | 28.48 | -170.87 | 179 | 5,097.67 | March 1, 2026: 6 @ 28.48 |
| May 20, 2026 | issue | SO-260520-634 | MAIN | 4 | 28.48 | -113.91 | 185 | 5,268.54 | March 1, 2026: 4 @ 28.48 |
| May 18, 2026 | issue | SO-260518-123 | MAIN | 5 | 28.48 | -142.39 | 189 | 5,382.46 | March 1, 2026: 5 @ 28.48 |
| May 12, 2026 | issue | SO-260512-877 | MAIN | 4 | 28.48 | -113.91 | 194 | 5,524.85 | March 1, 2026: 4 @ 28.48 |
| May 10, 2026 | issue | SO-260510-285 | MAIN | 5 | 28.48 | -142.39 | 198 | 5,638.76 | March 1, 2026: 5 @ 28.48 |
| May 6, 2026 | issue | SO-260506-745 | MAIN | 14 | 28.48 | -398.70 | 203 | 5,781.16 | March 1, 2026: 14 @ 28.48 |
| May 1, 2026 | issue | SO-260501-954 | MAIN | 27 | 28.48 | -768.92 | 217 | 6,179.86 | March 1, 2026: 27 @ 28.48 |
| April 16, 2026 | issue | SO-260416-689 | MAIN | 7 | 28.48 | -199.35 | 244 | 6,948.78 | March 1, 2026: 7 @ 28.48 |
| April 6, 2026 | issue | SO-260406-372 | MAIN | 16 | 28.48 | -455.66 | 251 | 7,148.13 | March 1, 2026: 16 @ 28.48 |
| April 1, 2026 | issue | SO-260401-651 | MAIN | 24 | 28.48 | -683.49 | 267 | 7,603.79 | March 1, 2026: 24 @ 28.48 |
| March 31, 2026 | issue | SO-260331-405 | MAIN | 32 | 28.44 | -909.99 | 291 | 8,287.27 | Feb. 15, 2026: 3 @ 28.04; March 1, 2026: 29 @ 28.48 |
| March 28, 2026 | issue | SO-260328-184 | MAIN | 5 | 28.04 | -140.18 | 323 | 9,197.26 | Feb. 15, 2026: 5 @ 28.04 |
| March 25, 2026 | issue | SO-260325-125 | MAIN | 15 | 28.04 | -420.54 | 328 | 9,337.44 | Oct. 9, 2025: 3 @ 28.04; Feb. 15, 2026: 12 @ 28.04 |
| March 16, 2026 | issue | SO-260316-568 | MAIN | 3 | 28.04 | -84.11 | 343 | 9,757.98 | Oct. 9, 2025: 3 @ 28.04 |
| March 9, 2026 | issue | SO-260309-836 | MAIN | 6 | 28.04 | -168.22 | 346 | 9,842.09 | Oct. 9, 2025: 6 @ 28.04 |
| March 9, 2026 | issue | SO-260309-836 | EAST | 10 | 28.04 | -280.36 | 352 | 10,010.30 | Oct. 9, 2025: 10 @ 28.04 |
| March 1, 2026 | receipt | PO-001270 | MAIN | 320 | 28.48 | 9,113.15 | 362 | 10,290.66 | |
| Feb. 22, 2026 | issue | SO-260222-711 | EAST | 10 | 28.04 | -280.36 | 42 | 1,177.51 | Oct. 9, 2025: 10 @ 28.04 |
| Feb. 18, 2026 | issue | SO-260218-118 | EAST | 13 | 28.04 | -364.47 | 52 | 1,457.87 | Oct. 9, 2025: 13 @ 28.04 |
| Feb. 15, 2026 | return | RMA | MAIN | 20 | 28.04 | 560.72 | 65 | 1,822.34 | |
| Feb. 13, 2026 | issue | SO-260213-402 | MAIN | 14 | 28.04 | -392.50 | 45 | 1,261.62 | Oct. 9, 2025: 14 @ 28.04 |
| Feb. 3, 2026 | issue | SO-260203-939 | EAST | 23 | 28.04 | -644.83 | 59 | 1,654.12 | Oct. 9, 2025: 23 @ 28.04 |
| Jan. 30, 2026 | issue | SO-260130-852 | MAIN | 40 | 28.04 | -1,121.44 | 82 | 2,298.95 | Oct. 9, 2025: 40 @ 28.04 |
| Jan. 21, 2026 | issue | SO-260121-423 | MAIN | 6 | 28.04 | -168.22 | 122 | 3,420.39 | Oct. 9, 2025: 6 @ 28.04 |
| Jan. 19, 2026 | issue | SO-260119-226 | MAIN | 4 | 28.04 | -112.14 | 128 | 3,588.61 | Oct. 9, 2025: 4 @ 28.04 |
| Jan. 17, 2026 | issue | SO-260117-789 | MAIN | 5 | 28.04 | -140.18 | 132 | 3,700.75 | Oct. 9, 2025: 5 @ 28.04 |
| Jan. 10, 2026 | issue | SO-260110-666 | MAIN | 5 | 28.04 | -140.18 | 137 | 3,840.93 | Oct. 9, 2025: 5 @ 28.04 |
| Dec. 19, 2025 | issue | SO-251219-365 | MAIN | 8 | 28.04 | -224.29 | 142 | 3,981.11 | Oct. 9, 2025: 8 @ 28.04 |
| Dec. 14, 2025 | issue | SO-251214-472 | MAIN | 35 | 28.04 | -981.26 | 150 | 4,205.40 | Oct. 9, 2025: 35 @ 28.04 |
| Dec. 9, 2025 | issue | SO-251209-352 | EAST | 4 | 28.04 | -112.14 | 185 | 5,186.66 | Oct. 9, 2025: 4 @ 28.04 |
| Dec. 8, 2025 | issue | SO-251208-526 | MAIN | 15 | 28.04 | -420.54 | 189 | 5,298.80 | Oct. 9, 2025: 15 @ 28.04 |
| Dec. 2, 2025 | issue | SO-251202-268 | EAST | 12 | 28.04 | -336.43 | 204 | 5,719.34 | Oct. 9, 2025: 12 @ 28.04 |
| Nov. 29, 2025 | issue | SO-251129-804 | MAIN | 36 | 28.04 | -1,009.30 | 216 | 6,055.78 | Oct. 9, 2025: 36 @ 28.04 |
| Nov. 26, 2025 | issue | SO-251126-413 | EAST | 17 | 28.04 | -476.61 | 252 | 7,065.07 | Oct. 9, 2025: 17 @ 28.04 |