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
| 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 |
| Oct. 14, 2025 | issue | SO-251014-578 | EAST | 2 | 7.54 | -15.08 | 121 | 912.05 | Sept. 13, 2025: 2 @ 7.54 |
| Oct. 8, 2025 | issue | SO-251008-376 | MAIN | 24 | 7.54 | -180.90 | 123 | 927.12 | Sept. 13, 2025: 24 @ 7.54 |
| Sept. 29, 2025 | issue | SO-250929-590 | MAIN | 33 | 7.54 | -248.74 | 147 | 1,108.03 | Sept. 13, 2025: 33 @ 7.54 |
| Sept. 18, 2025 | issue | SO-250918-759 | MAIN | 12 | 7.19 | -86.34 | 180 | 1,356.77 | May 2, 2025: 12 @ 7.19 |
| Sept. 15, 2025 | issue | SO-250915-554 | MAIN | 5 | 7.19 | -35.97 | 192 | 1,443.10 | May 2, 2025: 5 @ 7.19 |
| Sept. 13, 2025 | receipt | PO-000839 | MAIN | 180 | 7.54 | 1,356.77 | 197 | 1,479.08 | |
| Aug. 30, 2025 | issue | SO-250830-334 | MAIN | 21 | 7.19 | -151.09 | 17 | 122.31 | May 2, 2025: 21 @ 7.19 |
| Aug. 13, 2025 | issue | SO-250813-890 | MAIN | 1 | 7.19 | -7.19 | 38 | 273.39 | May 2, 2025: 1 @ 7.19 |
| Aug. 8, 2025 | issue | SO-250808-583 | EAST | 34 | 7.19 | -244.62 | 39 | 280.59 | May 2, 2025: 34 @ 7.19 |
| July 25, 2025 | issue | SO-250725-570 | MAIN | 18 | 7.19 | -129.50 | 73 | 525.21 | May 2, 2025: 18 @ 7.19 |
| July 21, 2025 | issue | SO-250721-659 | MAIN | 21 | 7.19 | -151.09 | 91 | 654.71 | May 2, 2025: 21 @ 7.19 |
| July 6, 2025 | issue | SO-250706-894 | MAIN | 17 | 7.19 | -122.31 | 112 | 805.80 | May 2, 2025: 17 @ 7.19 |
| June 22, 2025 | issue | SO-250622-840 | MAIN | 8 | 7.19 | -57.56 | 129 | 928.10 | May 2, 2025: 8 @ 7.19 |
| June 16, 2025 | issue | SO-250616-602 | MAIN | 4 | 7.19 | -28.78 | 137 | 985.66 | May 2, 2025: 4 @ 7.19 |
| June 9, 2025 | issue | SO-250609-662 | MAIN | 5 | 7.19 | -35.97 | 141 | 1,014.44 | May 2, 2025: 5 @ 7.19 |
| June 6, 2025 | issue | SO-250606-463 | MAIN | 2 | 7.19 | -14.39 | 146 | 1,050.41 | May 2, 2025: 2 @ 7.19 |
| June 2, 2025 | issue | SO-250602-414 | EAST | 9 | 7.19 | -64.75 | 148 | 1,064.80 | May 2, 2025: 9 @ 7.19 |
| June 1, 2025 | issue | SO-250601-104 | MAIN | 1 | 7.19 | -7.19 | 157 | 1,129.55 | May 2, 2025: 1 @ 7.19 |
| May 13, 2025 | issue | SO-250513-215 | MAIN | 10 | 7.19 | -71.95 | 158 | 1,136.75 | May 2, 2025: 10 @ 7.19 |
| May 11, 2025 | issue | SO-250511-191 | MAIN | 5 | 7.19 | -35.97 | 168 | 1,208.69 | May 2, 2025: 5 @ 7.19 |
| May 9, 2025 | issue | SO-250509-340 | MAIN | 10 | 7.26 | -72.59 | 173 | 1,244.67 | Jan. 3, 2025: 3 @ 7.41; May 2, 2025: 7 @ 7.19 |
| May 2, 2025 | issue | SO-250502-712 | MAIN | 4 | 7.41 | -29.64 | 183 | 1,317.26 | Jan. 3, 2025: 4 @ 7.41 |
| May 2, 2025 | transfer | TRF | MAIN → EAST | 45 | warehouse transfer, no cost effect | ||||
| May 2, 2025 | receipt | PO-000503 | MAIN | 180 | 7.19 | 1,295.03 | 187 | 1,346.90 | |
| April 23, 2025 | issue | SO-250423-377 | MAIN | 20 | 7.41 | -148.20 | 7 | 51.87 | Jan. 3, 2025: 20 @ 7.41 |
| April 17, 2025 | issue | SO-250417-659 | MAIN | 1 | 7.41 | -7.41 | 27 | 200.08 | Jan. 3, 2025: 1 @ 7.41 |
| April 17, 2025 | issue | SO-250417-659 | EAST | 12 | 7.41 | -88.92 | 28 | 207.49 | Jan. 3, 2025: 12 @ 7.41 |
| April 8, 2025 | issue | SO-250408-467 | MAIN | 7 | 7.41 | -51.87 | 40 | 296.41 | Jan. 3, 2025: 7 @ 7.41 |
| April 7, 2025 | issue | SO-250407-882 | MAIN | 1 | 7.41 | -7.41 | 47 | 348.28 | Jan. 3, 2025: 1 @ 7.41 |
| April 5, 2025 | issue | SO-250405-530 | MAIN | 16 | 7.41 | -118.56 | 48 | 355.69 | Jan. 3, 2025: 16 @ 7.41 |
| March 18, 2025 | issue | SO-250318-423 | MAIN | 9 | 7.41 | -66.69 | 64 | 474.25 | Jan. 3, 2025: 9 @ 7.41 |
| March 9, 2025 | issue | SO-250309-156 | EAST | 2 | 7.41 | -14.82 | 73 | 540.94 | Jan. 3, 2025: 2 @ 7.41 |
| March 4, 2025 | issue | SO-250304-333 | EAST | 20 | 7.41 | -148.20 | 75 | 555.76 | Jan. 3, 2025: 20 @ 7.41 |
| Feb. 10, 2025 | issue | SO-250210-928 | EAST | 12 | 7.41 | -88.92 | 95 | 703.97 | Jan. 3, 2025: 12 @ 7.41 |
| Feb. 9, 2025 | issue | SO-250209-145 | MAIN | 35 | 7.41 | -259.36 | 107 | 792.89 | Jan. 3, 2025: 35 @ 7.41 |
| Jan. 27, 2025 | issue | SO-250127-326 | MAIN | 25 | 7.41 | -185.26 | 142 | 1,052.25 | Jan. 3, 2025: 25 @ 7.41 |
| Jan. 22, 2025 | issue | SO-250122-965 | MAIN | 3 | 7.41 | -22.23 | 167 | 1,237.50 | Jan. 3, 2025: 3 @ 7.41 |
| Jan. 11, 2025 | issue | SO-250111-688 | EAST | 9 | 7.41 | -66.69 | 170 | 1,259.73 | Jan. 3, 2025: 9 @ 7.41 |
| Jan. 4, 2025 | issue | SO-250104-450 | MAIN | 11 | 7.39 | -81.32 | 179 | 1,326.43 | Oct. 1, 2024: 8 @ 7.39; Dec. 12, 2024: 2 @ 7.39; Jan. 3, 2025: 1 @ 7.41 |
| Jan. 3, 2025 | transfer | TRF | MAIN → EAST | 55 | warehouse transfer, no cost effect | ||||
| Jan. 3, 2025 | receipt | PO-000158 | MAIN | 180 | 7.41 | 1,333.84 | 190 | 1,407.75 | |
| Dec. 27, 2024 | issue | SO-241227-448 | MAIN | 35 | 7.39 | -258.68 | 10 | 73.91 | Oct. 1, 2024: 35 @ 7.39 |
| Dec. 12, 2024 | return | RMA | MAIN | 2 | 7.39 | 14.78 | 45 | 332.60 | |
| Dec. 11, 2024 | issue | SO-241211-866 | MAIN | 6 | 7.39 | -44.35 | 43 | 317.81 | Oct. 1, 2024: 6 @ 7.39 |
| Dec. 9, 2024 | issue | SO-241209-937 | MAIN | 9 | 7.39 | -66.52 | 49 | 362.16 | Oct. 1, 2024: 9 @ 7.39 |
| Nov. 30, 2024 | issue | SO-241130-460 | MAIN | 63 | 7.39 | -465.63 | 58 | 428.68 | Oct. 1, 2024: 63 @ 7.39 |
| Nov. 23, 2024 | issue | SO-241123-675 | MAIN | 4 | 7.39 | -29.56 | 121 | 894.31 | Oct. 1, 2024: 4 @ 7.39 |
| Oct. 28, 2024 | issue | SO-241028-666 | MAIN | 13 | 7.39 | -96.08 | 125 | 923.88 | Oct. 1, 2024: 13 @ 7.39 |
| Oct. 23, 2024 | issue | SO-241023-522 | MAIN | 13 | 7.39 | -96.08 | 138 | 1,019.96 | Oct. 1, 2024: 13 @ 7.39 |
| Oct. 16, 2024 | issue | SO-241016-846 | MAIN | 4 | 7.39 | -29.56 | 151 | 1,116.04 | Oct. 1, 2024: 4 @ 7.39 |
| Oct. 15, 2024 | issue | SO-241015-100 | MAIN | 3 | 7.39 | -22.17 | 155 | 1,145.60 | Oct. 1, 2024: 3 @ 7.39 |
| Oct. 10, 2024 | issue | SO-241010-947 | MAIN | 1 | 7.39 | -7.39 | 158 | 1,167.78 | Oct. 1, 2024: 1 @ 7.39 |
| Oct. 4, 2024 | issue | SO-241004-843 | MAIN | 21 | 7.39 | -155.21 | 159 | 1,175.17 | Oct. 1, 2024: 21 @ 7.39 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 180 | 7.39 | 1,330.38 | 180 | 1,330.38 | |