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
| 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 |
| Nov. 17, 2025 | issue | SO-251117-436 | MAIN | 3 | 28.04 | -84.11 | 269 | 7,541.68 | Oct. 9, 2025: 3 @ 28.04 |
| Nov. 9, 2025 | issue | SO-251109-170 | MAIN | 11 | 28.04 | -308.40 | 272 | 7,625.79 | Oct. 9, 2025: 11 @ 28.04 |
| Nov. 5, 2025 | issue | SO-251105-757 | MAIN | 12 | 28.04 | -336.43 | 283 | 7,934.19 | Oct. 9, 2025: 12 @ 28.04 |
| Oct. 17, 2025 | issue | SO-251017-953 | EAST | 6 | 28.04 | -168.22 | 295 | 8,270.62 | Oct. 9, 2025: 6 @ 28.04 |
| Oct. 10, 2025 | issue | SO-251010-262 | MAIN | 30 | 27.93 | -837.84 | 301 | 8,438.84 | June 9, 2025: 6 @ 27.72; June 12, 2025: 5 @ 27.77; Oct. 9, 2025: 19 @ 28.04 |
| Oct. 9, 2025 | transfer | TRF | MAIN → EAST | 95 | warehouse transfer, no cost effect | ||||
| Oct. 9, 2025 | receipt | PO-000911 | MAIN | 320 | 28.04 | 8,971.52 | 331 | 9,276.68 | |
| Oct. 7, 2025 | issue | SO-251007-480 | MAIN | 3 | 27.72 | -83.15 | 11 | 305.16 | June 9, 2025: 3 @ 27.72 |
| Oct. 6, 2025 | issue | SO-251006-406 | MAIN | 3 | 27.72 | -83.15 | 14 | 388.31 | June 9, 2025: 3 @ 27.72 |
| Oct. 3, 2025 | issue | SO-251003-297 | MAIN | 6 | 27.72 | -166.31 | 17 | 471.46 | June 9, 2025: 6 @ 27.72 |
| Oct. 2, 2025 | issue | SO-251002-371 | MAIN | 36 | 27.72 | -997.84 | 23 | 637.77 | June 9, 2025: 36 @ 27.72 |
| Sept. 13, 2025 | issue | SO-250913-262 | MAIN | 41 | 27.72 | -1,136.43 | 59 | 1,635.62 | June 9, 2025: 41 @ 27.72 |
| Sept. 8, 2025 | issue | SO-250908-803 | MAIN | 36 | 27.72 | -997.84 | 100 | 2,772.05 | June 9, 2025: 36 @ 27.72 |
| Aug. 30, 2025 | issue | SO-250830-871 | MAIN | 13 | 27.72 | -360.33 | 136 | 3,769.89 | June 9, 2025: 13 @ 27.72 |
| Aug. 28, 2025 | issue | SO-250828-436 | MAIN | 8 | 27.72 | -221.74 | 149 | 4,130.23 | June 9, 2025: 8 @ 27.72 |
| Aug. 26, 2025 | issue | SO-250826-407 | MAIN | 25 | 27.72 | -692.95 | 157 | 4,351.97 | June 9, 2025: 25 @ 27.72 |
| Aug. 25, 2025 | issue | SO-250825-801 | MAIN | 19 | 27.72 | -526.64 | 182 | 5,044.92 | June 9, 2025: 19 @ 27.72 |
| Aug. 23, 2025 | issue | SO-250823-148 | MAIN | 20 | 27.72 | -554.36 | 201 | 5,571.56 | June 9, 2025: 20 @ 27.72 |
| July 27, 2025 | issue | SO-250727-491 | MAIN | 7 | 27.72 | -194.03 | 221 | 6,125.92 | June 9, 2025: 7 @ 27.72 |
| July 15, 2025 | issue | SO-250715-920 | MAIN | 2 | 27.72 | -55.44 | 228 | 6,319.94 | June 9, 2025: 2 @ 27.72 |
| July 14, 2025 | issue | SO-250714-542 | MAIN | 70 | 27.72 | -1,940.25 | 230 | 6,375.38 | June 9, 2025: 70 @ 27.72 |
| June 26, 2025 | issue | SO-250626-324 | MAIN | 38 | 27.74 | -1,053.96 | 300 | 8,315.63 | Jan. 17, 2025: 13 @ 27.77; June 9, 2025: 25 @ 27.72 |
| June 12, 2025 | return | RMA | MAIN | 5 | 27.77 | 138.85 | 338 | 9,369.59 | |
| June 9, 2025 | receipt | PO-000620 | MAIN | 320 | 27.72 | 8,869.73 | 333 | 9,230.74 | |
| June 7, 2025 | issue | SO-250607-352 | MAIN | 30 | 27.77 | -833.10 | 13 | 361.01 | Jan. 17, 2025: 30 @ 27.77 |
| May 24, 2025 | issue | SO-250524-814 | MAIN | 10 | 27.77 | -277.70 | 43 | 1,194.11 | Jan. 17, 2025: 10 @ 27.77 |
| May 22, 2025 | issue | SO-250522-319 | MAIN | 16 | 27.77 | -444.32 | 53 | 1,471.81 | Jan. 17, 2025: 16 @ 27.77 |
| May 12, 2025 | issue | SO-250512-516 | MAIN | 8 | 27.77 | -222.16 | 69 | 1,916.13 | Jan. 17, 2025: 8 @ 27.77 |
| May 3, 2025 | issue | SO-250503-167 | MAIN | 30 | 27.77 | -833.10 | 77 | 2,138.29 | Jan. 17, 2025: 30 @ 27.77 |
| April 23, 2025 | issue | SO-250423-644 | MAIN | 1 | 27.77 | -27.77 | 107 | 2,971.39 | Jan. 17, 2025: 1 @ 27.77 |
| April 20, 2025 | issue | SO-250420-986 | MAIN | 7 | 27.77 | -194.39 | 108 | 2,999.16 | Jan. 17, 2025: 7 @ 27.77 |
| April 15, 2025 | issue | SO-250415-814 | MAIN | 16 | 27.77 | -444.32 | 115 | 3,193.55 | Jan. 17, 2025: 16 @ 27.77 |
| April 6, 2025 | issue | SO-250406-377 | MAIN | 10 | 27.77 | -277.70 | 131 | 3,637.87 | Jan. 17, 2025: 10 @ 27.77 |
| April 2, 2025 | issue | SO-250402-788 | MAIN | 42 | 27.77 | -1,166.34 | 141 | 3,915.57 | Jan. 17, 2025: 42 @ 27.77 |
| March 29, 2025 | issue | SO-250329-447 | MAIN | 13 | 27.77 | -361.01 | 183 | 5,081.91 | Jan. 17, 2025: 13 @ 27.77 |
| March 15, 2025 | issue | SO-250315-371 | MAIN | 30 | 27.77 | -833.10 | 196 | 5,442.92 | Jan. 17, 2025: 30 @ 27.77 |
| March 14, 2025 | issue | SO-250314-433 | MAIN | 8 | 27.77 | -222.16 | 226 | 6,276.02 | Jan. 17, 2025: 8 @ 27.77 |
| March 4, 2025 | issue | SO-250304-924 | MAIN | 18 | 27.77 | -499.86 | 234 | 6,498.18 | Jan. 17, 2025: 18 @ 27.77 |
| Feb. 22, 2025 | issue | SO-250222-794 | MAIN | 3 | 27.77 | -83.31 | 252 | 6,998.04 | Jan. 17, 2025: 3 @ 27.77 |
| Feb. 15, 2025 | issue | SO-250215-522 | MAIN | 30 | 27.77 | -833.10 | 255 | 7,081.35 | Jan. 17, 2025: 30 @ 27.77 |
| Feb. 8, 2025 | issue | SO-250208-822 | MAIN | 1 | 27.77 | -27.77 | 285 | 7,914.45 | Jan. 17, 2025: 1 @ 27.77 |
| Feb. 2, 2025 | issue | SO-250202-264 | MAIN | 24 | 27.77 | -666.48 | 286 | 7,942.22 | Jan. 17, 2025: 24 @ 27.77 |
| Jan. 27, 2025 | issue | SO-250127-971 | MAIN | 39 | 28.21 | -1,100.07 | 310 | 8,608.70 | Oct. 1, 2024: 29 @ 28.36; Jan. 17, 2025: 10 @ 27.77 |
| Jan. 23, 2025 | issue | SO-250123-718 | MAIN | 23 | 28.36 | -652.22 | 349 | 9,708.77 | Oct. 1, 2024: 23 @ 28.36 |
| Jan. 17, 2025 | receipt | PO-000191 | MAIN | 320 | 27.77 | 8,886.40 | 372 | 10,360.99 | |
| Jan. 2, 2025 | issue | SO-250102-906 | MAIN | 10 | 28.36 | -283.58 | 52 | 1,474.59 | Oct. 1, 2024: 10 @ 28.36 |
| Dec. 30, 2024 | issue | SO-241230-615 | MAIN | 24 | 28.36 | -680.58 | 62 | 1,758.16 | Oct. 1, 2024: 24 @ 28.36 |
| Dec. 28, 2024 | issue | SO-241228-208 | MAIN | 10 | 28.36 | -283.58 | 86 | 2,438.74 | Oct. 1, 2024: 10 @ 28.36 |
| Dec. 25, 2024 | issue | SO-241225-981 | MAIN | 16 | 28.36 | -453.72 | 96 | 2,722.32 | Oct. 1, 2024: 16 @ 28.36 |
| Dec. 11, 2024 | issue | SO-241211-427 | MAIN | 12 | 28.36 | -340.29 | 112 | 3,176.04 | Oct. 1, 2024: 12 @ 28.36 |
| Dec. 10, 2024 | issue | SO-241210-529 | MAIN | 13 | 28.36 | -368.65 | 124 | 3,516.33 | Oct. 1, 2024: 13 @ 28.36 |
| Nov. 12, 2024 | issue | SO-241112-535 | MAIN | 45 | 28.36 | -1,276.09 | 137 | 3,884.98 | Oct. 1, 2024: 45 @ 28.36 |
| Nov. 6, 2024 | issue | SO-241106-643 | MAIN | 35 | 28.36 | -992.51 | 182 | 5,161.06 | Oct. 1, 2024: 35 @ 28.36 |
| Oct. 28, 2024 | issue | SO-241028-555 | MAIN | 4 | 28.36 | -113.43 | 217 | 6,153.58 | Oct. 1, 2024: 4 @ 28.36 |
| Oct. 18, 2024 | issue | SO-241018-952 | MAIN | 27 | 28.36 | -765.65 | 221 | 6,267.01 | Oct. 1, 2024: 27 @ 28.36 |
| Oct. 10, 2024 | issue | SO-241010-906 | MAIN | 42 | 28.36 | -1,191.02 | 248 | 7,032.66 | Oct. 1, 2024: 42 @ 28.36 |
| Oct. 4, 2024 | issue | SO-241004-130 | MAIN | 30 | 28.36 | -850.72 | 290 | 8,223.68 | Oct. 1, 2024: 30 @ 28.36 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 320 | 28.36 | 9,074.40 | 320 | 9,074.40 | |