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, latest 60 shown - show all
| 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 |