Items / CON-0002
Cable Tray 2m Lite CON-0002 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)2MAIN 2
Value (FIFO)15.64avg 7.82
ClassCX / FCV 0.18
Turnover8.3xlast issue 1 days ago
Days of cover2lead time 14d
Reorder suggested: 360 units (position at or below reorder point: order EOQ), stockout risk high.
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 | 38.42 / 30.4375 | 1.262 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.87 / 5.517 | 1.246 |
| 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.246^2 + 1.262^2 * 3.1^2) | 7.8 |
| Reorder point | d * LT + safety stock | 1.262 * 14.0 + 7.8 | 25.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 25.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 461/yr, S = 45.00, h = 20%, price = 7.47 | 360.0 |
| Inventory position | on hand + on order | 2 + 0 | 2 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 7.78 | 163 | 3,838 | yes |
| 360 | 7.47 | 360 | 3,767 | yes (chosen if cheapest) |
| 720 | 7.16 | 720 | 3,842 | yes |
MOQ 180, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 30, 2026 | 2 / 180 | 7.82 | 15.64 |
Movement ledger 114 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-673 | MAIN | 1 | 7.82 | -7.82 | 2 | 15.64 | May 30, 2026: 1 @ 7.82 |
| Oct. 14, 2026 | issue | SO-261014-839 | MAIN | 35 | 7.82 | -273.78 | 3 | 23.47 | May 30, 2026: 35 @ 7.82 |
| Oct. 3, 2026 | issue | SO-261003-425 | MAIN | 8 | 7.82 | -62.58 | 38 | 297.25 | May 30, 2026: 8 @ 7.82 |
| Sept. 17, 2026 | issue | SO-260917-503 | MAIN | 5 | 7.82 | -39.11 | 46 | 359.83 | May 30, 2026: 5 @ 7.82 |
| Sept. 12, 2026 | issue | SO-260912-536 | MAIN | 8 | 7.82 | -62.58 | 51 | 398.94 | May 30, 2026: 8 @ 7.82 |
| Sept. 10, 2026 | issue | SO-260910-312 | MAIN | 15 | 7.82 | -117.34 | 59 | 461.52 | May 30, 2026: 15 @ 7.82 |
| Sept. 8, 2026 | issue | SO-260908-227 | MAIN | 11 | 7.82 | -86.05 | 74 | 578.86 | May 30, 2026: 11 @ 7.82 |
| Sept. 4, 2026 | issue | SO-260904-348 | MAIN | 9 | 7.82 | -70.40 | 85 | 664.90 | May 30, 2026: 9 @ 7.82 |
| Aug. 31, 2026 | issue | SO-260831-809 | MAIN | 5 | 7.82 | -39.11 | 94 | 735.31 | May 30, 2026: 5 @ 7.82 |
| Aug. 29, 2026 | issue | SO-260829-810 | MAIN | 15 | 7.82 | -117.34 | 99 | 774.42 | May 30, 2026: 15 @ 7.82 |
| Aug. 15, 2026 | issue | SO-260815-486 | MAIN | 5 | 7.82 | -39.11 | 114 | 891.75 | May 30, 2026: 5 @ 7.82 |
| Aug. 4, 2026 | issue | SO-260804-725 | MAIN | 4 | 7.82 | -31.29 | 119 | 930.87 | May 30, 2026: 4 @ 7.82 |
| Aug. 3, 2026 | issue | SO-260803-594 | MAIN | 4 | 7.82 | -31.29 | 123 | 962.16 | May 30, 2026: 4 @ 7.82 |
| July 22, 2026 | issue | SO-260722-428 | MAIN | 18 | 7.82 | -140.80 | 127 | 993.44 | May 30, 2026: 18 @ 7.82 |
| July 21, 2026 | issue | SO-260721-374 | MAIN | 9 | 7.82 | -70.40 | 145 | 1,134.25 | May 30, 2026: 9 @ 7.82 |
| July 20, 2026 | issue | SO-260720-648 | MAIN | 13 | 7.82 | -101.69 | 154 | 1,204.65 | May 30, 2026: 13 @ 7.82 |
| July 10, 2026 | issue | SO-260710-859 | MAIN | 1 | 7.82 | -7.82 | 167 | 1,306.34 | May 30, 2026: 1 @ 7.82 |
| July 7, 2026 | issue | SO-260707-101 | MAIN | 1 | 7.82 | -7.82 | 168 | 1,314.16 | May 30, 2026: 1 @ 7.82 |
| June 30, 2026 | issue | SO-260630-148 | MAIN | 9 | 7.82 | -70.40 | 169 | 1,321.99 | May 30, 2026: 9 @ 7.82 |
| June 27, 2026 | issue | SO-260627-546 | MAIN | 12 | 7.75 | -92.98 | 178 | 1,392.39 | Jan. 13, 2026: 9 @ 7.73; April 25, 2026: 1 @ 7.73; May 30, 2026: 2 @ 7.82 |
| June 20, 2026 | issue | SO-260620-157 | MAIN | 6 | 7.73 | -46.40 | 190 | 1,485.37 | Jan. 13, 2026: 6 @ 7.73 |
| June 14, 2026 | issue | SO-260614-499 | MAIN | 11 | 7.73 | -85.07 | 196 | 1,531.77 | Jan. 13, 2026: 11 @ 7.73 |
| May 30, 2026 | receipt | PO-001533 | MAIN | 180 | 7.82 | 1,408.03 | 207 | 1,616.85 | |
| May 27, 2026 | issue | SO-260527-288 | MAIN | 5 | 7.73 | -38.67 | 27 | 208.82 | Jan. 13, 2026: 5 @ 7.73 |
| May 24, 2026 | issue | SO-260524-414 | MAIN | 17 | 7.73 | -131.48 | 32 | 247.48 | Jan. 13, 2026: 17 @ 7.73 |
| May 17, 2026 | issue | SO-260517-775 | MAIN | 6 | 7.73 | -46.40 | 49 | 378.96 | Jan. 13, 2026: 6 @ 7.73 |
| April 27, 2026 | issue | SO-260427-949 | MAIN | 7 | 7.73 | -54.14 | 55 | 425.36 | Jan. 13, 2026: 7 @ 7.73 |
| April 25, 2026 | return | RMA | MAIN | 1 | 7.73 | 7.73 | 62 | 479.50 | |
| April 25, 2026 | issue | SO-260425-833 | MAIN | 3 | 7.73 | -23.20 | 61 | 471.77 | Jan. 13, 2026: 3 @ 7.73 |
| April 20, 2026 | issue | SO-260420-898 | MAIN | 11 | 7.73 | -85.07 | 64 | 494.97 | Jan. 13, 2026: 11 @ 7.73 |
| April 12, 2026 | issue | SO-260412-769 | MAIN | 10 | 7.73 | -77.34 | 75 | 580.04 | Jan. 13, 2026: 10 @ 7.73 |
| April 8, 2026 | issue | SO-260408-698 | MAIN | 2 | 7.73 | -15.47 | 85 | 657.38 | Jan. 13, 2026: 2 @ 7.73 |
| April 7, 2026 | issue | SO-260407-603 | MAIN | 3 | 7.73 | -23.20 | 87 | 672.85 | Jan. 13, 2026: 3 @ 7.73 |
| March 23, 2026 | issue | SO-260323-425 | MAIN | 29 | 7.73 | -224.28 | 90 | 696.05 | Jan. 13, 2026: 29 @ 7.73 |
| March 18, 2026 | issue | SO-260318-766 | MAIN | 12 | 7.73 | -92.81 | 119 | 920.33 | Jan. 13, 2026: 12 @ 7.73 |
| Feb. 23, 2026 | issue | SO-260223-628 | MAIN | 14 | 7.73 | -108.27 | 131 | 1,013.14 | Jan. 13, 2026: 14 @ 7.73 |
| Feb. 19, 2026 | issue | SO-260219-197 | MAIN | 7 | 7.73 | -54.14 | 145 | 1,121.42 | Jan. 13, 2026: 7 @ 7.73 |
| Feb. 13, 2026 | issue | SO-260213-655 | MAIN | 2 | 7.73 | -15.47 | 152 | 1,175.55 | Jan. 13, 2026: 2 @ 7.73 |
| Feb. 12, 2026 | issue | SO-260212-137 | MAIN | 7 | 7.73 | -54.14 | 154 | 1,191.02 | Jan. 13, 2026: 7 @ 7.73 |
| Feb. 6, 2026 | issue | SO-260206-881 | MAIN | 2 | 7.73 | -15.47 | 161 | 1,245.16 | Jan. 13, 2026: 2 @ 7.73 |
| Feb. 4, 2026 | issue | SO-260204-493 | MAIN | 1 | 7.73 | -7.73 | 163 | 1,260.63 | Jan. 13, 2026: 1 @ 7.73 |
| Feb. 1, 2026 | issue | SO-260201-602 | MAIN | 8 | 7.73 | -61.87 | 164 | 1,268.36 | Jan. 13, 2026: 8 @ 7.73 |
| Jan. 17, 2026 | issue | SO-260117-184 | MAIN | 16 | 7.64 | -122.17 | 172 | 1,330.23 | Sept. 13, 2025: 7 @ 7.54; Dec. 16, 2025: 1 @ 7.54; Jan. 13, 2026: 8 @ 7.73 |
| Jan. 13, 2026 | issue | SO-260113-737 | MAIN | 12 | 7.54 | -90.45 | 188 | 1,452.40 | Sept. 13, 2025: 12 @ 7.54 |
| Jan. 13, 2026 | receipt | PO-001141 | MAIN | 180 | 7.73 | 1,392.10 | 200 | 1,542.85 | |
| Dec. 30, 2025 | issue | SO-251230-166 | MAIN | 17 | 7.54 | -128.14 | 20 | 150.75 | Sept. 13, 2025: 17 @ 7.54 |
| Dec. 29, 2025 | issue | SO-251229-803 | MAIN | 2 | 7.54 | -15.08 | 37 | 278.89 | Sept. 13, 2025: 2 @ 7.54 |
| Dec. 23, 2025 | issue | SO-251223-653 | MAIN | 2 | 7.54 | -15.08 | 39 | 293.97 | Sept. 13, 2025: 2 @ 7.54 |
| Dec. 16, 2025 | return | RMA | MAIN | 1 | 7.54 | 7.54 | 41 | 309.04 | |
| Dec. 10, 2025 | issue | SO-251210-796 | MAIN | 2 | 7.54 | -15.08 | 40 | 301.50 | Sept. 13, 2025: 2 @ 7.54 |
| Dec. 8, 2025 | issue | SO-251208-879 | MAIN | 5 | 7.54 | -37.69 | 42 | 316.58 | Sept. 13, 2025: 5 @ 7.54 |
| Dec. 7, 2025 | issue | SO-251207-902 | MAIN | 25 | 7.54 | -188.44 | 47 | 354.27 | Sept. 13, 2025: 25 @ 7.54 |
| Nov. 29, 2025 | issue | SO-251129-373 | MAIN | 6 | 7.54 | -45.23 | 72 | 542.71 | Sept. 13, 2025: 6 @ 7.54 |
| Nov. 23, 2025 | issue | SO-251123-891 | MAIN | 8 | 7.54 | -60.30 | 78 | 587.93 | Sept. 13, 2025: 8 @ 7.54 |
| Nov. 14, 2025 | issue | SO-251114-511 | MAIN | 14 | 7.54 | -105.53 | 86 | 648.23 | Sept. 13, 2025: 14 @ 7.54 |
| Nov. 3, 2025 | issue | SO-251103-653 | MAIN | 11 | 7.54 | -82.91 | 100 | 753.76 | Sept. 13, 2025: 11 @ 7.54 |
| Oct. 31, 2025 | issue | SO-251031-995 | MAIN | 3 | 7.54 | -22.61 | 111 | 836.67 | Sept. 13, 2025: 3 @ 7.54 |
| Oct. 17, 2025 | issue | SO-251017-564 | MAIN | 2 | 7.54 | -15.08 | 114 | 859.29 | Sept. 13, 2025: 2 @ 7.54 |
| Oct. 16, 2025 | issue | SO-251016-542 | MAIN | 3 | 7.54 | -22.61 | 116 | 874.36 | Sept. 13, 2025: 3 @ 7.54 |
| Oct. 14, 2025 | issue | SO-251014-578 | MAIN | 2 | 7.54 | -15.08 | 119 | 896.97 | Sept. 13, 2025: 2 @ 7.54 |