Items / CON-0001
Cable Tray 2m Classic CON-0001 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)193MAIN 193
Value (FIFO)2,167.97avg 11.23
ClassBX / FCV 0.23
Turnover6.9xlast issue 6 days ago
Days of cover39lead 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 | 150.67 / 30.4375 | 4.950 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 34.57 / 5.517 | 6.267 |
| 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 * 6.267^2 + 4.950^2 * 3.1^2) | 46.2 |
| Reorder point | d * LT + safety stock | 4.950 * 14.0 + 46.2 | 115.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 115.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1807/yr, S = 45.00, h = 20%, price = 11.45 | 266.5 |
| Inventory position | on hand + on order | 193 + 0 | 193 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.45 | 266 | 21,298 | yes (chosen if cheapest) |
MOQ 560, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 10, 2026 | 188 / 560 | 11.23 | 2,111.80 | |
| Sept. 19, 2026 | 5 / 5 | 11.23 | 56.16 |
Movement ledger 116 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-935 | MAIN | 70 | 11.23 | -786.31 | 193 | 2,167.97 | Aug. 10, 2026: 70 @ 11.23 |
| Oct. 9, 2026 | issue | SO-261009-194 | MAIN | 50 | 11.23 | -561.65 | 263 | 2,954.28 | Aug. 10, 2026: 50 @ 11.23 |
| Oct. 5, 2026 | issue | SO-261005-517 | MAIN | 19 | 11.23 | -213.43 | 313 | 3,515.93 | Aug. 10, 2026: 19 @ 11.23 |
| Oct. 1, 2026 | issue | SO-261001-428 | MAIN | 4 | 11.23 | -44.93 | 332 | 3,729.36 | Aug. 10, 2026: 4 @ 11.23 |
| Sept. 19, 2026 | return | RMA | MAIN | 5 | 11.23 | 56.16 | 336 | 3,774.29 | |
| Sept. 19, 2026 | issue | SO-260919-869 | MAIN | 15 | 11.23 | -168.50 | 331 | 3,718.12 | Aug. 10, 2026: 15 @ 11.23 |
| Sept. 13, 2026 | issue | SO-260913-871 | MAIN | 63 | 11.23 | -707.68 | 346 | 3,886.62 | Aug. 10, 2026: 63 @ 11.23 |
| Sept. 12, 2026 | issue | SO-260912-865 | MAIN | 47 | 11.23 | -527.95 | 409 | 4,594.30 | Aug. 10, 2026: 47 @ 11.23 |
| Sept. 12, 2026 | issue | SO-260912-865 | EAST | 11 | 11.23 | -123.56 | 456 | 5,122.25 | Aug. 10, 2026: 11 @ 11.23 |
| Aug. 30, 2026 | issue | SO-260830-142 | EAST | 57 | 11.23 | -640.28 | 467 | 5,245.81 | Aug. 10, 2026: 57 @ 11.23 |
| Aug. 22, 2026 | issue | SO-260822-811 | EAST | 98 | 11.04 | -1,081.51 | 524 | 5,886.09 | April 14, 2026: 62 @ 10.92; Aug. 10, 2026: 36 @ 11.23 |
| Aug. 16, 2026 | issue | SO-260816-153 | MAIN | 16 | 10.92 | -174.74 | 622 | 6,967.61 | April 14, 2026: 16 @ 10.92 |
| Aug. 10, 2026 | transfer | TRF | MAIN → EAST | 165 | warehouse transfer, no cost effect | ||||
| Aug. 10, 2026 | receipt | PO-001710 | MAIN | 560 | 11.23 | 6,290.48 | 638 | 7,142.35 | |
| Aug. 6, 2026 | issue | SO-260806-144 | EAST | 5 | 10.92 | -54.61 | 78 | 851.87 | April 14, 2026: 5 @ 10.92 |
| July 26, 2026 | issue | SO-260726-644 | MAIN | 84 | 10.92 | -917.40 | 83 | 906.48 | April 14, 2026: 84 @ 10.92 |
| July 25, 2026 | issue | SO-260725-554 | EAST | 23 | 10.92 | -251.19 | 167 | 1,823.87 | April 14, 2026: 23 @ 10.92 |
| July 14, 2026 | issue | SO-260714-167 | MAIN | 3 | 10.92 | -32.76 | 190 | 2,075.07 | April 14, 2026: 3 @ 10.92 |
| July 10, 2026 | issue | SO-260710-446 | EAST | 38 | 10.92 | -415.01 | 193 | 2,107.83 | April 14, 2026: 38 @ 10.92 |
| July 3, 2026 | issue | SO-260703-713 | MAIN | 1 | 10.92 | -10.92 | 231 | 2,522.84 | April 14, 2026: 1 @ 10.92 |
| June 27, 2026 | issue | SO-260627-355 | MAIN | 38 | 10.92 | -415.01 | 232 | 2,533.76 | April 14, 2026: 38 @ 10.92 |
| June 3, 2026 | issue | SO-260603-344 | MAIN | 115 | 10.92 | -1,255.96 | 270 | 2,948.78 | April 14, 2026: 115 @ 10.92 |
| May 27, 2026 | issue | SO-260527-245 | EAST | 48 | 10.92 | -524.23 | 385 | 4,204.74 | April 14, 2026: 48 @ 10.92 |
| May 23, 2026 | issue | SO-260523-484 | MAIN | 24 | 10.92 | -262.11 | 433 | 4,728.97 | April 14, 2026: 24 @ 10.92 |
| May 18, 2026 | issue | SO-260518-179 | MAIN | 45 | 10.92 | -491.46 | 457 | 4,991.08 | April 14, 2026: 45 @ 10.92 |
| May 17, 2026 | issue | SO-260517-302 | MAIN | 10 | 10.92 | -109.21 | 502 | 5,482.54 | April 14, 2026: 10 @ 10.92 |
| May 14, 2026 | issue | SO-260514-768 | MAIN | 7 | 10.92 | -76.45 | 512 | 5,591.76 | April 14, 2026: 7 @ 10.92 |
| May 6, 2026 | issue | SO-260506-297 | EAST | 20 | 10.92 | -218.43 | 519 | 5,668.21 | April 14, 2026: 20 @ 10.92 |
| May 5, 2026 | issue | SO-260505-211 | MAIN | 7 | 10.92 | -76.45 | 539 | 5,886.63 | April 14, 2026: 7 @ 10.92 |
| April 25, 2026 | issue | SO-260425-580 | MAIN | 13 | 10.92 | -141.98 | 546 | 5,963.08 | April 14, 2026: 13 @ 10.92 |
| April 22, 2026 | issue | SO-260422-699 | MAIN | 1 | 10.92 | -10.92 | 559 | 6,105.06 | April 14, 2026: 1 @ 10.92 |
| April 14, 2026 | transfer | TRF | MAIN → EAST | 135 | warehouse transfer, no cost effect | ||||
| April 14, 2026 | receipt | PO-001407 | MAIN | 560 | 10.92 | 6,115.98 | 560 | 6,115.98 | |
| April 3, 2026 | issue | SO-260403-883 | MAIN | 30 | 11.25 | -337.59 | 0 | 0.00 | Dec. 14, 2025: 30 @ 11.25 |
| April 1, 2026 | issue | SO-260401-655 | MAIN | 40 | 11.25 | -450.12 | 30 | 337.59 | Dec. 14, 2025: 40 @ 11.25 |
| March 27, 2026 | issue | SO-260327-137 | MAIN | 112 | 11.25 | -1,260.34 | 70 | 787.71 | Dec. 14, 2025: 112 @ 11.25 |
| March 26, 2026 | issue | SO-260326-771 | MAIN | 55 | 11.25 | -618.92 | 182 | 2,048.05 | Dec. 14, 2025: 55 @ 11.25 |
| Feb. 26, 2026 | issue | SO-260226-474 | MAIN | 8 | 11.25 | -90.02 | 237 | 2,666.96 | Dec. 14, 2025: 8 @ 11.25 |
| Feb. 20, 2026 | issue | SO-260220-271 | MAIN | 8 | 11.25 | -90.02 | 245 | 2,756.98 | Dec. 14, 2025: 8 @ 11.25 |
| Feb. 19, 2026 | issue | SO-260219-252 | MAIN | 17 | 11.25 | -191.30 | 253 | 2,847.01 | Dec. 14, 2025: 17 @ 11.25 |
| Feb. 17, 2026 | issue | SO-260217-219 | MAIN | 15 | 11.25 | -168.80 | 270 | 3,038.31 | Dec. 14, 2025: 15 @ 11.25 |
| Feb. 16, 2026 | issue | SO-260216-933 | MAIN | 31 | 11.25 | -348.84 | 285 | 3,207.10 | Dec. 14, 2025: 31 @ 11.25 |
| Feb. 13, 2026 | issue | SO-260213-978 | MAIN | 17 | 11.25 | -191.30 | 316 | 3,555.95 | Dec. 14, 2025: 17 @ 11.25 |
| Feb. 9, 2026 | issue | SO-260209-513 | MAIN | 2 | 11.25 | -22.51 | 333 | 3,747.25 | Dec. 14, 2025: 2 @ 11.25 |
| Jan. 29, 2026 | issue | SO-260129-205 | MAIN | 23 | 11.25 | -258.82 | 335 | 3,769.76 | Dec. 14, 2025: 23 @ 11.25 |
| Jan. 28, 2026 | issue | SO-260128-759 | MAIN | 55 | 11.25 | -618.92 | 358 | 4,028.57 | Dec. 14, 2025: 55 @ 11.25 |
| Jan. 17, 2026 | issue | SO-260117-205 | MAIN | 50 | 11.25 | -562.65 | 413 | 4,647.49 | Dec. 14, 2025: 50 @ 11.25 |
| Jan. 15, 2026 | adjustment | Cycle count | MAIN | -2 | 11.25 | -22.51 | 463 | 5,210.14 | Dec. 14, 2025: 2 @ 11.25 |
| Jan. 14, 2026 | issue | SO-260114-251 | MAIN | 14 | 11.25 | -157.54 | 465 | 5,232.64 | Dec. 14, 2025: 14 @ 11.25 |
| Jan. 10, 2026 | issue | SO-260110-582 | MAIN | 16 | 11.25 | -180.05 | 479 | 5,390.19 | Dec. 14, 2025: 16 @ 11.25 |
| Jan. 1, 2026 | issue | SO-260101-253 | MAIN | 14 | 11.25 | -157.54 | 495 | 5,570.24 | Dec. 14, 2025: 14 @ 11.25 |
| Dec. 21, 2025 | issue | SO-251221-736 | MAIN | 52 | 11.25 | -585.10 | 509 | 5,727.78 | Sept. 10, 2025: 1 @ 11.19; Dec. 14, 2025: 51 @ 11.25 |
| Dec. 16, 2025 | issue | SO-251216-228 | MAIN | 30 | 11.19 | -335.77 | 561 | 6,312.87 | Sept. 10, 2025: 30 @ 11.19 |
| Dec. 15, 2025 | issue | SO-251215-458 | MAIN | 43 | 11.19 | -481.26 | 591 | 6,648.64 | Sept. 10, 2025: 43 @ 11.19 |
| Dec. 14, 2025 | receipt | PO-001051 | MAIN | 560 | 11.25 | 6,301.68 | 634 | 7,129.90 | |
| Dec. 13, 2025 | issue | SO-251213-651 | MAIN | 2 | 11.19 | -22.38 | 74 | 828.22 | Sept. 10, 2025: 2 @ 11.19 |
| Dec. 11, 2025 | issue | SO-251211-563 | MAIN | 19 | 11.19 | -212.65 | 76 | 850.61 | Sept. 10, 2025: 19 @ 11.19 |
| Nov. 29, 2025 | issue | SO-251129-376 | MAIN | 6 | 11.19 | -67.15 | 95 | 1,063.26 | Sept. 10, 2025: 6 @ 11.19 |
| Nov. 16, 2025 | issue | SO-251116-730 | MAIN | 101 | 11.19 | -1,130.41 | 101 | 1,130.41 | Sept. 10, 2025: 101 @ 11.19 |
| Nov. 11, 2025 | issue | SO-251111-817 | MAIN | 34 | 11.19 | -380.53 | 202 | 2,260.82 | Sept. 10, 2025: 34 @ 11.19 |
| Nov. 8, 2025 | issue | SO-251108-660 | MAIN | 82 | 11.19 | -917.76 | 236 | 2,641.36 | Sept. 10, 2025: 82 @ 11.19 |
| Oct. 18, 2025 | issue | SO-251018-188 | MAIN | 12 | 11.19 | -134.31 | 318 | 3,559.12 | Sept. 10, 2025: 12 @ 11.19 |
| Oct. 5, 2025 | issue | SO-251005-172 | MAIN | 136 | 11.19 | -1,522.14 | 330 | 3,693.43 | Sept. 10, 2025: 136 @ 11.19 |
| Sept. 30, 2025 | issue | SO-250930-666 | MAIN | 8 | 11.19 | -89.54 | 466 | 5,215.57 | Sept. 10, 2025: 8 @ 11.19 |
| Sept. 28, 2025 | issue | SO-250928-873 | MAIN | 38 | 11.19 | -425.30 | 474 | 5,305.10 | Sept. 10, 2025: 38 @ 11.19 |
| Sept. 23, 2025 | issue | SO-250923-989 | MAIN | 13 | 11.19 | -145.50 | 512 | 5,730.41 | Sept. 10, 2025: 13 @ 11.19 |
| Sept. 17, 2025 | issue | SO-250917-203 | MAIN | 13 | 11.19 | -145.50 | 525 | 5,875.90 | Sept. 10, 2025: 13 @ 11.19 |
| Sept. 16, 2025 | issue | SO-250916-881 | MAIN | 22 | 11.19 | -246.23 | 538 | 6,021.40 | Sept. 10, 2025: 22 @ 11.19 |
| Sept. 10, 2025 | receipt | PO-000827 | MAIN | 560 | 11.19 | 6,267.63 | 560 | 6,267.63 | |
| Sept. 3, 2025 | issue | SO-250903-259 | MAIN | 52 | 10.80 | -561.65 | 0 | 0.00 | May 15, 2025: 37 @ 10.80; Aug. 27, 2025: 15 @ 10.80 |
| Aug. 28, 2025 | issue | SO-250828-300 | MAIN | 63 | 10.80 | -680.46 | 52 | 561.65 | May 15, 2025: 63 @ 10.80 |
| Aug. 27, 2025 | return | RMA | MAIN | 15 | 10.80 | 162.01 | 115 | 1,242.10 | |
| Aug. 26, 2025 | issue | SO-250826-599 | MAIN | 46 | 10.80 | -496.84 | 100 | 1,080.09 | May 15, 2025: 46 @ 10.80 |
| Aug. 25, 2025 | issue | SO-250825-837 | MAIN | 22 | 10.80 | -237.62 | 146 | 1,576.93 | May 15, 2025: 22 @ 10.80 |
| Aug. 21, 2025 | issue | SO-250821-236 | MAIN | 30 | 10.80 | -324.03 | 168 | 1,814.55 | May 15, 2025: 30 @ 10.80 |
| Aug. 4, 2025 | issue | SO-250804-909 | MAIN | 2 | 10.80 | -21.60 | 198 | 2,138.58 | May 15, 2025: 2 @ 10.80 |
| July 30, 2025 | issue | SO-250730-577 | MAIN | 15 | 10.80 | -162.01 | 200 | 2,160.18 | May 15, 2025: 15 @ 10.80 |
| July 16, 2025 | issue | SO-250716-550 | MAIN | 139 | 10.80 | -1,501.33 | 215 | 2,322.19 | May 15, 2025: 139 @ 10.80 |
| June 24, 2025 | issue | SO-250624-320 | MAIN | 22 | 10.80 | -237.62 | 354 | 3,823.52 | May 15, 2025: 22 @ 10.80 |
| June 23, 2025 | issue | SO-250623-719 | MAIN | 8 | 10.80 | -86.41 | 376 | 4,061.14 | May 15, 2025: 8 @ 10.80 |
| June 17, 2025 | issue | SO-250617-845 | MAIN | 28 | 10.80 | -302.43 | 384 | 4,147.55 | May 15, 2025: 28 @ 10.80 |
| June 11, 2025 | issue | SO-250611-104 | MAIN | 47 | 10.80 | -507.64 | 412 | 4,449.97 | May 15, 2025: 47 @ 10.80 |
| June 2, 2025 | issue | SO-250602-331 | MAIN | 14 | 10.80 | -151.21 | 459 | 4,957.61 | May 15, 2025: 14 @ 10.80 |
| May 29, 2025 | issue | SO-250529-395 | MAIN | 153 | 10.85 | -1,659.40 | 473 | 5,108.83 | Jan. 22, 2025: 66 @ 10.90; May 15, 2025: 87 @ 10.80 |
| May 15, 2025 | receipt | PO-000537 | MAIN | 560 | 10.80 | 6,048.50 | 626 | 6,768.22 | |
| May 3, 2025 | issue | SO-250503-151 | MAIN | 33 | 10.90 | -359.86 | 66 | 719.72 | Jan. 22, 2025: 33 @ 10.90 |
| April 29, 2025 | issue | SO-250429-562 | MAIN | 57 | 10.90 | -621.57 | 99 | 1,079.58 | Jan. 22, 2025: 57 @ 10.90 |
| April 25, 2025 | issue | SO-250425-529 | MAIN | 111 | 10.90 | -1,210.43 | 156 | 1,701.15 | Jan. 22, 2025: 111 @ 10.90 |
| March 29, 2025 | issue | SO-250329-655 | MAIN | 43 | 10.90 | -468.91 | 267 | 2,911.58 | Jan. 22, 2025: 43 @ 10.90 |
| March 27, 2025 | issue | SO-250327-892 | MAIN | 28 | 10.90 | -305.33 | 310 | 3,380.49 | Jan. 22, 2025: 28 @ 10.90 |
| March 14, 2025 | issue | SO-250314-857 | MAIN | 47 | 10.90 | -512.53 | 338 | 3,685.82 | Jan. 22, 2025: 47 @ 10.90 |
| Feb. 26, 2025 | issue | SO-250226-919 | MAIN | 24 | 10.90 | -261.72 | 385 | 4,198.35 | Jan. 22, 2025: 24 @ 10.90 |
| Feb. 19, 2025 | issue | SO-250219-221 | MAIN | 86 | 10.90 | -937.81 | 409 | 4,460.06 | Jan. 22, 2025: 86 @ 10.90 |
| Feb. 2, 2025 | issue | SO-250202-608 | MAIN | 71 | 10.90 | -774.08 | 495 | 5,397.88 | Oct. 1, 2024: 5 @ 10.88; Dec. 7, 2024: 1 @ 10.88; Jan. 22, 2025: 65 @ 10.90 |
| Jan. 22, 2025 | receipt | PO-000208 | MAIN | 560 | 10.90 | 6,106.69 | 566 | 6,171.95 | |
| Jan. 12, 2025 | issue | SO-250112-583 | MAIN | 19 | 10.88 | -206.67 | 6 | 65.26 | Oct. 1, 2024: 19 @ 10.88 |
| Jan. 10, 2025 | issue | SO-250110-955 | MAIN | 20 | 10.88 | -217.55 | 25 | 271.94 | Oct. 1, 2024: 20 @ 10.88 |
| Jan. 3, 2025 | issue | SO-250103-968 | MAIN | 95 | 10.88 | -1,033.36 | 45 | 489.49 | Oct. 1, 2024: 95 @ 10.88 |
| Dec. 27, 2024 | issue | SO-241227-765 | MAIN | 10 | 10.88 | -108.78 | 140 | 1,522.85 | Oct. 1, 2024: 10 @ 10.88 |
| Dec. 16, 2024 | issue | SO-241216-228 | MAIN | 16 | 10.88 | -174.04 | 150 | 1,631.62 | Oct. 1, 2024: 16 @ 10.88 |
| Dec. 9, 2024 | issue | SO-241209-260 | MAIN | 27 | 10.88 | -293.69 | 166 | 1,805.66 | Oct. 1, 2024: 27 @ 10.88 |
| Dec. 7, 2024 | return | RMA | MAIN | 1 | 10.88 | 10.88 | 193 | 2,099.36 | |
| Dec. 7, 2024 | issue | SO-241207-955 | MAIN | 65 | 10.88 | -707.04 | 192 | 2,088.48 | Oct. 1, 2024: 65 @ 10.88 |
| Dec. 5, 2024 | issue | SO-241205-799 | MAIN | 39 | 10.88 | -424.22 | 257 | 2,795.52 | Oct. 1, 2024: 39 @ 10.88 |
| Dec. 2, 2024 | issue | SO-241202-388 | MAIN | 2 | 10.88 | -21.76 | 296 | 3,219.74 | Oct. 1, 2024: 2 @ 10.88 |
| Nov. 30, 2024 | issue | SO-241130-857 | MAIN | 10 | 10.88 | -108.78 | 298 | 3,241.50 | Oct. 1, 2024: 10 @ 10.88 |
| Nov. 25, 2024 | issue | SO-241125-399 | MAIN | 31 | 10.88 | -337.20 | 308 | 3,350.27 | Oct. 1, 2024: 31 @ 10.88 |
| Nov. 17, 2024 | issue | SO-241117-308 | MAIN | 4 | 10.88 | -43.51 | 339 | 3,687.47 | Oct. 1, 2024: 4 @ 10.88 |
| Nov. 12, 2024 | issue | SO-241112-399 | MAIN | 20 | 10.88 | -217.55 | 343 | 3,730.98 | Oct. 1, 2024: 20 @ 10.88 |
| Nov. 9, 2024 | issue | SO-241109-886 | MAIN | 14 | 10.88 | -152.28 | 363 | 3,948.53 | Oct. 1, 2024: 14 @ 10.88 |
| Nov. 5, 2024 | issue | SO-241105-149 | MAIN | 39 | 10.88 | -424.22 | 377 | 4,100.82 | Oct. 1, 2024: 39 @ 10.88 |
| Oct. 22, 2024 | issue | SO-241022-609 | MAIN | 5 | 10.88 | -54.39 | 416 | 4,525.04 | Oct. 1, 2024: 5 @ 10.88 |
| Oct. 20, 2024 | issue | SO-241020-321 | MAIN | 10 | 10.88 | -108.78 | 421 | 4,579.43 | Oct. 1, 2024: 10 @ 10.88 |
| Oct. 9, 2024 | issue | SO-241009-355 | MAIN | 82 | 10.88 | -891.96 | 431 | 4,688.20 | Oct. 1, 2024: 82 @ 10.88 |
| Oct. 6, 2024 | issue | SO-241006-754 | MAIN | 47 | 10.88 | -511.24 | 513 | 5,580.16 | Oct. 1, 2024: 47 @ 10.88 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 560 | 10.88 | 6,091.40 | 560 | 6,091.40 | |