Items / CON-0009
Cable Tray 2m Nova CON-0009 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)385MAIN 385
Value (FIFO)16,093.62avg 41.80
ClassAX / FCV 0.15
Turnover3.6xlast issue 1 days ago
Days of cover102lead 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 | 114.50 / 30.4375 | 3.762 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 17.54 / 5.517 | 3.180 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(14.0 * 3.180^2 + 3.762^2 * 3.1^2) | 34.3 |
| Reorder point | d * LT + safety stock | 3.762 * 14.0 + 34.3 | 87.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 87.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1373/yr, S = 45.00, h = 20%, price = 43.00 | 119.9 |
| Inventory position | on hand + on order | 385 + 0 | 385 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 43.00 | 120 | 60,072 | yes (chosen if cheapest) |
MOQ 480, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 15, 2026 | 385 / 480 | 41.80 | 16,093.62 |
Movement ledger 121 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-393 | MAIN | 58 | 41.80 | -2,424.49 | 385 | 16,093.62 | Sept. 15, 2026: 58 @ 41.80 |
| Oct. 9, 2026 | issue | SO-261009-163 | MAIN | 20 | 41.80 | -836.03 | 443 | 18,518.11 | Sept. 15, 2026: 20 @ 41.80 |
| Oct. 7, 2026 | issue | SO-261007-956 | MAIN | 90 | 41.28 | -3,715.23 | 463 | 19,354.14 | June 1, 2026: 73 @ 41.16; Sept. 15, 2026: 17 @ 41.80 |
| Sept. 15, 2026 | receipt | PO-001802 | MAIN | 480 | 41.80 | 20,064.77 | 553 | 23,069.37 | |
| Sept. 13, 2026 | issue | SO-260913-114 | MAIN | 4 | 41.16 | -164.64 | 73 | 3,004.60 | June 1, 2026: 4 @ 41.16 |
| Sept. 5, 2026 | issue | SO-260905-874 | MAIN | 7 | 41.16 | -288.11 | 77 | 3,169.24 | June 1, 2026: 7 @ 41.16 |
| Sept. 3, 2026 | issue | SO-260903-951 | MAIN | 99 | 41.16 | -4,074.73 | 84 | 3,457.35 | June 1, 2026: 99 @ 41.16 |
| Aug. 21, 2026 | issue | SO-260821-244 | MAIN | 11 | 41.16 | -452.75 | 183 | 7,532.08 | June 1, 2026: 11 @ 41.16 |
| Aug. 18, 2026 | issue | SO-260818-143 | MAIN | 11 | 41.16 | -452.75 | 194 | 7,984.83 | June 1, 2026: 11 @ 41.16 |
| Aug. 15, 2026 | issue | SO-260815-898 | MAIN | 75 | 41.16 | -3,086.92 | 205 | 8,437.57 | June 1, 2026: 75 @ 41.16 |
| Aug. 3, 2026 | issue | SO-260803-922 | MAIN | 6 | 41.16 | -246.95 | 280 | 11,524.49 | June 1, 2026: 6 @ 41.16 |
| July 26, 2026 | issue | SO-260726-137 | MAIN | 54 | 41.16 | -2,222.58 | 286 | 11,771.45 | June 1, 2026: 54 @ 41.16 |
| July 8, 2026 | issue | SO-260708-380 | MAIN | 35 | 41.16 | -1,440.56 | 340 | 13,994.03 | June 1, 2026: 35 @ 41.16 |
| June 27, 2026 | issue | SO-260627-954 | MAIN | 4 | 41.16 | -164.64 | 375 | 15,434.59 | June 1, 2026: 4 @ 41.16 |
| June 19, 2026 | issue | SO-260619-342 | MAIN | 10 | 41.16 | -411.59 | 379 | 15,599.22 | June 1, 2026: 10 @ 41.16 |
| June 17, 2026 | issue | SO-260617-485 | MAIN | 70 | 41.16 | -2,881.12 | 389 | 16,010.81 | June 1, 2026: 70 @ 41.16 |
| June 12, 2026 | issue | SO-260612-210 | MAIN | 21 | 41.16 | -864.34 | 459 | 18,891.94 | June 1, 2026: 21 @ 41.16 |
| June 1, 2026 | receipt | PO-001539 | MAIN | 480 | 41.16 | 19,756.27 | 480 | 19,756.27 | |
| May 29, 2026 | issue | SO-260529-671 | EAST | 23 | 40.51 | -931.81 | 0 | 0.00 | Jan. 18, 2026: 23 @ 40.51 |
| May 26, 2026 | issue | SO-260526-330 | EAST | 5 | 40.51 | -202.57 | 23 | 931.81 | Jan. 18, 2026: 5 @ 40.51 |
| May 26, 2026 | issue | SO-260526-330 | MAIN | 23 | 40.51 | -931.81 | 28 | 1,134.37 | Jan. 18, 2026: 23 @ 40.51 |
| May 25, 2026 | issue | SO-260525-372 | MAIN | 9 | 40.51 | -364.62 | 51 | 2,066.18 | Jan. 18, 2026: 9 @ 40.51 |
| May 23, 2026 | issue | SO-260523-613 | MAIN | 15 | 40.51 | -607.70 | 60 | 2,430.80 | Jan. 18, 2026: 15 @ 40.51 |
| May 18, 2026 | issue | SO-260518-430 | EAST | 11 | 40.51 | -445.65 | 75 | 3,038.50 | Jan. 18, 2026: 11 @ 40.51 |
| May 6, 2026 | issue | SO-260506-336 | EAST | 11 | 40.51 | -445.65 | 86 | 3,484.14 | Jan. 18, 2026: 11 @ 40.51 |
| April 21, 2026 | issue | SO-260421-416 | MAIN | 34 | 40.51 | -1,377.45 | 97 | 3,929.79 | Jan. 18, 2026: 34 @ 40.51 |
| April 20, 2026 | issue | SO-260420-590 | MAIN | 26 | 40.51 | -1,053.35 | 131 | 5,307.24 | Jan. 18, 2026: 26 @ 40.51 |
| April 16, 2026 | issue | SO-260416-284 | MAIN | 11 | 40.51 | -445.65 | 157 | 6,360.59 | Jan. 18, 2026: 11 @ 40.51 |
| April 13, 2026 | issue | SO-260413-655 | MAIN | 2 | 40.51 | -81.03 | 168 | 6,806.23 | Jan. 18, 2026: 2 @ 40.51 |
| April 11, 2026 | issue | SO-260411-683 | MAIN | 23 | 40.51 | -931.81 | 170 | 6,887.26 | Jan. 18, 2026: 23 @ 40.51 |
| April 9, 2026 | issue | SO-260409-344 | MAIN | 14 | 40.51 | -567.19 | 193 | 7,819.07 | Jan. 18, 2026: 14 @ 40.51 |
| April 4, 2026 | issue | SO-260404-669 | MAIN | 14 | 40.51 | -567.19 | 207 | 8,386.25 | Jan. 18, 2026: 14 @ 40.51 |
| March 18, 2026 | issue | SO-260318-682 | EAST | 77 | 40.51 | -3,119.52 | 221 | 8,953.44 | Jan. 18, 2026: 77 @ 40.51 |
| March 15, 2026 | issue | SO-260315-995 | EAST | 2 | 40.51 | -81.03 | 298 | 12,072.96 | Jan. 18, 2026: 2 @ 40.51 |
| March 4, 2026 | issue | SO-260304-704 | MAIN | 42 | 40.51 | -1,701.56 | 300 | 12,153.99 | Jan. 18, 2026: 42 @ 40.51 |
| Feb. 14, 2026 | issue | SO-260214-584 | MAIN | 60 | 40.51 | -2,430.80 | 342 | 13,855.55 | Jan. 18, 2026: 60 @ 40.51 |
| Feb. 12, 2026 | issue | SO-260212-569 | EAST | 19 | 40.51 | -769.75 | 402 | 16,286.35 | Jan. 18, 2026: 19 @ 40.51 |
| Feb. 5, 2026 | issue | SO-260205-931 | MAIN | 24 | 40.51 | -972.32 | 421 | 17,056.10 | Jan. 18, 2026: 24 @ 40.51 |
| Jan. 31, 2026 | issue | SO-260131-719 | MAIN | 23 | 40.51 | -931.81 | 445 | 18,028.42 | Jan. 18, 2026: 23 @ 40.51 |
| Jan. 29, 2026 | issue | SO-260129-600 | EAST | 1 | 40.51 | -40.51 | 468 | 18,960.22 | Jan. 18, 2026: 1 @ 40.51 |
| Jan. 27, 2026 | issue | SO-260127-419 | MAIN | 13 | 40.47 | -526.16 | 469 | 19,000.74 | Sept. 13, 2025: 2 @ 40.26; Jan. 18, 2026: 11 @ 40.51 |
| Jan. 21, 2026 | issue | SO-260121-454 | MAIN | 37 | 40.26 | -1,489.53 | 482 | 19,526.90 | Sept. 13, 2025: 37 @ 40.26 |
| Jan. 18, 2026 | transfer | TRF | MAIN → EAST | 149 | warehouse transfer, no cost effect | ||||
| Jan. 18, 2026 | receipt | PO-001156 | MAIN | 480 | 40.51 | 19,446.38 | 519 | 21,016.43 | |
| Jan. 15, 2026 | issue | SO-260115-956 | MAIN | 10 | 40.26 | -402.58 | 39 | 1,570.04 | Sept. 13, 2025: 10 @ 40.26 |
| Jan. 12, 2026 | issue | SO-260112-583 | MAIN | 65 | 40.26 | -2,616.74 | 49 | 1,972.62 | Sept. 13, 2025: 65 @ 40.26 |
| Dec. 27, 2025 | issue | SO-251227-980 | MAIN | 8 | 40.26 | -322.06 | 114 | 4,589.36 | Sept. 13, 2025: 8 @ 40.26 |
| Dec. 26, 2025 | issue | SO-251226-958 | MAIN | 13 | 40.26 | -523.35 | 122 | 4,911.42 | Sept. 13, 2025: 13 @ 40.26 |
| Dec. 25, 2025 | issue | SO-251225-748 | MAIN | 5 | 40.26 | -201.29 | 135 | 5,434.76 | Sept. 13, 2025: 5 @ 40.26 |
| Dec. 23, 2025 | issue | SO-251223-361 | MAIN | 14 | 40.26 | -563.60 | 140 | 5,636.05 | Sept. 13, 2025: 14 @ 40.26 |
| Dec. 20, 2025 | issue | SO-251220-207 | MAIN | 4 | 40.26 | -161.03 | 154 | 6,199.66 | Sept. 13, 2025: 4 @ 40.26 |
| Dec. 8, 2025 | issue | SO-251208-751 | MAIN | 55 | 40.26 | -2,214.16 | 158 | 6,360.68 | Sept. 13, 2025: 55 @ 40.26 |
| Dec. 6, 2025 | issue | SO-251206-640 | MAIN | 3 | 40.26 | -120.77 | 213 | 8,574.85 | Sept. 13, 2025: 3 @ 40.26 |
| Nov. 29, 2025 | issue | SO-251129-165 | MAIN | 17 | 40.26 | -684.38 | 216 | 8,695.62 | Sept. 13, 2025: 17 @ 40.26 |
| Nov. 27, 2025 | issue | SO-251127-494 | MAIN | 33 | 40.26 | -1,328.50 | 233 | 9,380.00 | Sept. 13, 2025: 33 @ 40.26 |
| Nov. 19, 2025 | issue | SO-251119-406 | MAIN | 37 | 40.26 | -1,489.53 | 266 | 10,708.50 | Sept. 13, 2025: 37 @ 40.26 |
| Nov. 8, 2025 | issue | SO-251108-661 | MAIN | 11 | 40.26 | -442.83 | 303 | 12,198.02 | Sept. 13, 2025: 11 @ 40.26 |
| Nov. 7, 2025 | issue | SO-251107-676 | MAIN | 38 | 40.26 | -1,529.78 | 314 | 12,640.86 | Sept. 13, 2025: 38 @ 40.26 |
| Oct. 31, 2025 | issue | SO-251031-371 | MAIN | 27 | 40.26 | -1,086.95 | 352 | 14,170.64 | Sept. 13, 2025: 27 @ 40.26 |
| Oct. 26, 2025 | issue | SO-251026-917 | MAIN | 12 | 40.26 | -483.09 | 379 | 15,257.59 | Sept. 13, 2025: 12 @ 40.26 |