Items / CON-0020
Cable Tray 2m Elite CON-0020 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)114MAIN 114
Value (FIFO)1,467.07avg 12.87
ClassCX / FCV 0.18
Turnover3.8xlast issue 3 days ago
Days of cover98lead 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 | 35.58 / 30.4375 | 1.169 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.29 / 5.517 | 1.140 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(14.0 * 1.140^2 + 1.169^2 * 3.1^2) | 7.2 |
| Reorder point | d * LT + safety stock | 1.169 * 14.0 + 7.2 | 23.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 23.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 427/yr, S = 45.00, h = 20%, price = 12.54 | 280.0 |
| Inventory position | on hand + on order | 114 + 0 | 114 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 13.06 | 121 | 5,890 | yes |
| 280 | 12.54 | 280 | 5,770 | yes (chosen if cheapest) |
| 560 | 12.02 | 560 | 5,834 | yes |
MOQ 140, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 22, 2026 | 114 / 140 | 12.87 | 1,467.07 |
Movement ledger 109 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-426 | MAIN | 21 | 12.87 | -270.25 | 114 | 1,467.07 | Sept. 22, 2026: 21 @ 12.87 |
| Oct. 10, 2026 | issue | SO-261010-708 | MAIN | 1 | 12.87 | -12.87 | 135 | 1,737.32 | Sept. 22, 2026: 1 @ 12.87 |
| Oct. 9, 2026 | issue | SO-261009-929 | MAIN | 2 | 12.87 | -25.74 | 136 | 1,750.18 | Sept. 22, 2026: 2 @ 12.87 |
| Oct. 4, 2026 | issue | SO-261004-660 | MAIN | 3 | 12.68 | -38.03 | 138 | 1,775.92 | May 29, 2026: 1 @ 12.29; Sept. 22, 2026: 2 @ 12.87 |
| Oct. 3, 2026 | issue | SO-261003-799 | MAIN | 6 | 12.65 | -75.89 | 141 | 1,813.95 | May 26, 2026: 3 @ 13.00; May 29, 2026: 3 @ 12.29 |
| Sept. 30, 2026 | issue | SO-260930-632 | MAIN | 1 | 13.00 | -13.00 | 147 | 1,889.85 | May 26, 2026: 1 @ 13.00 |
| Sept. 22, 2026 | receipt | PO-001819 | MAIN | 140 | 12.87 | 1,801.66 | 148 | 1,902.85 | |
| Sept. 19, 2026 | issue | SO-260919-678 | MAIN | 1 | 13.00 | -13.00 | 8 | 101.19 | May 26, 2026: 1 @ 13.00 |
| Sept. 15, 2026 | issue | SO-260915-257 | MAIN | 6 | 13.00 | -78.02 | 9 | 114.19 | May 26, 2026: 6 @ 13.00 |
| Sept. 11, 2026 | issue | SO-260911-440 | MAIN | 2 | 13.00 | -26.01 | 15 | 192.21 | May 26, 2026: 2 @ 13.00 |
| Sept. 9, 2026 | issue | SO-260909-195 | MAIN | 7 | 13.00 | -91.02 | 17 | 218.21 | May 26, 2026: 7 @ 13.00 |
| Sept. 8, 2026 | issue | SO-260908-517 | MAIN | 7 | 13.00 | -91.02 | 24 | 309.23 | May 26, 2026: 7 @ 13.00 |
| Sept. 1, 2026 | issue | SO-260901-613 | MAIN | 8 | 13.00 | -104.02 | 31 | 400.25 | May 26, 2026: 8 @ 13.00 |
| Aug. 29, 2026 | issue | SO-260829-832 | MAIN | 2 | 13.00 | -26.01 | 39 | 504.27 | May 26, 2026: 2 @ 13.00 |
| Aug. 22, 2026 | issue | SO-260822-652 | MAIN | 44 | 13.00 | -572.11 | 41 | 530.28 | May 26, 2026: 44 @ 13.00 |
| July 24, 2026 | issue | SO-260724-283 | MAIN | 17 | 13.00 | -221.04 | 85 | 1,102.39 | May 26, 2026: 17 @ 13.00 |
| July 4, 2026 | issue | SO-260704-241 | MAIN | 2 | 13.00 | -26.01 | 102 | 1,323.43 | May 26, 2026: 2 @ 13.00 |
| July 3, 2026 | issue | SO-260703-462 | MAIN | 4 | 13.00 | -52.01 | 104 | 1,349.44 | May 26, 2026: 4 @ 13.00 |
| July 2, 2026 | issue | SO-260702-212 | MAIN | 4 | 13.00 | -52.01 | 108 | 1,401.45 | May 26, 2026: 4 @ 13.00 |
| July 1, 2026 | issue | SO-260701-266 | MAIN | 5 | 13.00 | -65.01 | 112 | 1,453.46 | May 26, 2026: 5 @ 13.00 |
| June 24, 2026 | issue | SO-260624-130 | MAIN | 7 | 13.00 | -91.02 | 117 | 1,518.47 | May 26, 2026: 7 @ 13.00 |
| June 20, 2026 | issue | SO-260620-743 | MAIN | 1 | 13.00 | -13.00 | 124 | 1,609.49 | May 26, 2026: 1 @ 13.00 |
| June 16, 2026 | issue | SO-260616-429 | MAIN | 15 | 13.00 | -195.04 | 125 | 1,622.49 | May 26, 2026: 15 @ 13.00 |
| June 7, 2026 | issue | SO-260607-510 | MAIN | 2 | 13.00 | -26.01 | 140 | 1,817.53 | May 26, 2026: 2 @ 13.00 |
| May 31, 2026 | issue | SO-260531-198 | MAIN | 6 | 12.53 | -75.18 | 142 | 1,843.54 | Jan. 19, 2026: 4 @ 12.29; May 26, 2026: 2 @ 13.00 |
| May 29, 2026 | return | RMA | MAIN | 4 | 12.29 | 49.18 | 148 | 1,918.72 | |
| May 28, 2026 | issue | SO-260528-999 | MAIN | 4 | 12.29 | -49.18 | 144 | 1,869.54 | Jan. 19, 2026: 4 @ 12.29 |
| May 26, 2026 | receipt | PO-001523 | MAIN | 140 | 13.00 | 1,820.36 | 148 | 1,918.72 | |
| May 17, 2026 | issue | SO-260517-601 | MAIN | 9 | 12.29 | -110.65 | 8 | 98.36 | Jan. 19, 2026: 9 @ 12.29 |
| May 16, 2026 | issue | SO-260516-799 | MAIN | 4 | 12.29 | -49.18 | 17 | 209.01 | Jan. 19, 2026: 4 @ 12.29 |
| May 10, 2026 | issue | SO-260510-214 | MAIN | 15 | 12.29 | -184.42 | 21 | 258.19 | Jan. 19, 2026: 15 @ 12.29 |
| April 14, 2026 | issue | SO-260414-582 | MAIN | 27 | 12.29 | -331.96 | 36 | 442.62 | Jan. 19, 2026: 27 @ 12.29 |
| April 9, 2026 | issue | SO-260409-474 | MAIN | 9 | 12.29 | -110.65 | 63 | 774.58 | Jan. 19, 2026: 9 @ 12.29 |
| March 13, 2026 | issue | SO-260313-672 | MAIN | 1 | 12.29 | -12.29 | 72 | 885.23 | Jan. 19, 2026: 1 @ 12.29 |
| March 6, 2026 | issue | SO-260306-934 | MAIN | 7 | 12.29 | -86.06 | 73 | 897.53 | Jan. 19, 2026: 7 @ 12.29 |
| March 6, 2026 | issue | SO-260306-934 | EAST | 32 | 12.29 | -393.44 | 80 | 983.59 | Jan. 19, 2026: 32 @ 12.29 |
| March 5, 2026 | issue | SO-260305-948 | MAIN | 1 | 12.29 | -12.29 | 112 | 1,377.03 | Jan. 19, 2026: 1 @ 12.29 |
| Feb. 27, 2026 | issue | SO-260227-219 | MAIN | 5 | 12.29 | -61.47 | 113 | 1,389.32 | Jan. 19, 2026: 5 @ 12.29 |
| Feb. 25, 2026 | issue | SO-260225-587 | EAST | 13 | 12.29 | -159.83 | 118 | 1,450.80 | Jan. 19, 2026: 13 @ 12.29 |
| Feb. 19, 2026 | issue | SO-260219-339 | MAIN | 2 | 12.29 | -24.59 | 131 | 1,610.63 | Jan. 19, 2026: 2 @ 12.29 |
| Feb. 1, 2026 | issue | SO-260201-164 | MAIN | 4 | 12.29 | -49.18 | 133 | 1,635.22 | Jan. 19, 2026: 4 @ 12.29 |
| Jan. 26, 2026 | issue | SO-260126-535 | EAST | 4 | 12.37 | -49.46 | 137 | 1,684.40 | Oct. 7, 2025: 1 @ 12.58; Jan. 19, 2026: 3 @ 12.29 |
| Jan. 19, 2026 | transfer | TRF | MAIN → EAST | 49 | warehouse transfer, no cost effect | ||||
| Jan. 19, 2026 | receipt | PO-001160 | MAIN | 140 | 12.29 | 1,721.29 | 141 | 1,733.86 | |
| Jan. 16, 2026 | issue | SO-260116-720 | MAIN | 8 | 12.58 | -100.63 | 1 | 12.58 | Oct. 7, 2025: 8 @ 12.58 |
| Jan. 5, 2026 | issue | SO-260105-691 | MAIN | 25 | 12.58 | -314.46 | 9 | 113.20 | Oct. 7, 2025: 25 @ 12.58 |
| Dec. 27, 2025 | issue | SO-251227-882 | MAIN | 1 | 12.58 | -12.58 | 34 | 427.66 | Oct. 7, 2025: 1 @ 12.58 |
| Dec. 2, 2025 | issue | SO-251202-687 | MAIN | 40 | 12.58 | -503.13 | 35 | 440.24 | Oct. 7, 2025: 40 @ 12.58 |
| Nov. 22, 2025 | issue | SO-251122-867 | MAIN | 10 | 12.58 | -125.78 | 75 | 943.36 | Oct. 7, 2025: 10 @ 12.58 |
| Nov. 5, 2025 | issue | SO-251105-394 | MAIN | 29 | 12.58 | -364.77 | 85 | 1,069.15 | Oct. 7, 2025: 29 @ 12.58 |
| Oct. 16, 2025 | issue | SO-251016-724 | MAIN | 13 | 12.58 | -163.52 | 114 | 1,433.91 | Oct. 7, 2025: 13 @ 12.58 |
| Oct. 12, 2025 | issue | SO-251012-241 | MAIN | 27 | 12.53 | -338.23 | 127 | 1,597.43 | June 12, 2025: 14 @ 12.48; Oct. 7, 2025: 13 @ 12.58 |
| Oct. 7, 2025 | receipt | PO-000905 | MAIN | 140 | 12.58 | 1,760.95 | 154 | 1,935.66 | |
| Sept. 24, 2025 | issue | SO-250924-933 | MAIN | 13 | 12.48 | -162.23 | 14 | 174.71 | June 12, 2025: 13 @ 12.48 |
| Sept. 17, 2025 | issue | SO-250917-424 | MAIN | 10 | 12.48 | -124.79 | 27 | 336.94 | June 12, 2025: 10 @ 12.48 |
| Sept. 13, 2025 | issue | SO-250913-713 | MAIN | 2 | 12.48 | -24.96 | 37 | 461.73 | June 12, 2025: 2 @ 12.48 |
| Sept. 4, 2025 | issue | SO-250904-963 | MAIN | 10 | 12.48 | -124.79 | 39 | 486.69 | June 12, 2025: 10 @ 12.48 |
| Aug. 22, 2025 | issue | SO-250822-817 | MAIN | 8 | 12.48 | -99.83 | 49 | 611.48 | June 12, 2025: 8 @ 12.48 |
| Aug. 18, 2025 | issue | SO-250818-112 | MAIN | 9 | 12.48 | -112.31 | 57 | 711.31 | June 12, 2025: 9 @ 12.48 |
| Aug. 13, 2025 | issue | SO-250813-448 | MAIN | 4 | 12.48 | -49.92 | 66 | 823.63 | June 12, 2025: 4 @ 12.48 |