Items / CON-0010
Cable Tray 2m Prime CON-0010 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)315MAIN 303, EAST 12
Value (FIFO)3,119.51avg 9.90
ClassCX / FCV 0.11
Turnover3.5xlast issue 3 days ago
Days of cover109lead 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 | 87.67 / 30.4375 | 2.880 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.29 / 5.517 | 1.685 |
| 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.685^2 + 2.880^2 * 3.1^2) | 14.0 |
| Reorder point | d * LT + safety stock | 2.880 * 14.0 + 14.0 | 54.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 54.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1051/yr, S = 45.00, h = 20%, price = 9.67 | 221.2 |
| Inventory position | on hand + on order | 315 + 0 | 315 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 9.67 | 221 | 10,594 | yes (chosen if cheapest) |
MOQ 360, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 6, 2026 | 315 / 360 | 9.90 | 3,119.51 |
Movement ledger 120 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 13, 2026 | issue | SO-261013-114 | MAIN | 34 | 9.90 | -336.71 | 315 | 3,119.51 | Oct. 6, 2026: 34 @ 9.90 |
| Oct. 11, 2026 | issue | SO-261011-826 | MAIN | 7 | 9.90 | -69.32 | 349 | 3,456.22 | Oct. 6, 2026: 7 @ 9.90 |
| Oct. 7, 2026 | issue | SO-261007-858 | MAIN | 13 | 9.78 | -127.20 | 356 | 3,525.54 | July 29, 2026: 9 @ 9.73; Oct. 6, 2026: 4 @ 9.90 |
| Oct. 6, 2026 | issue | SO-261006-576 | MAIN | 48 | 9.73 | -467.13 | 369 | 3,652.74 | June 7, 2026: 30 @ 9.73; July 29, 2026: 18 @ 9.73 |
| Oct. 6, 2026 | receipt | PO-001853 | MAIN | 360 | 9.90 | 3,565.15 | 417 | 4,119.87 | |
| Oct. 3, 2026 | issue | SO-261003-987 | EAST | 2 | 9.73 | -19.46 | 57 | 554.72 | June 7, 2026: 2 @ 9.73 |
| Sept. 25, 2026 | issue | SO-260925-742 | MAIN | 55 | 9.73 | -535.25 | 59 | 574.18 | June 7, 2026: 55 @ 9.73 |
| Sept. 24, 2026 | issue | SO-260924-892 | MAIN | 6 | 9.73 | -58.39 | 114 | 1,109.44 | June 7, 2026: 6 @ 9.73 |
| Sept. 23, 2026 | issue | SO-260923-887 | EAST | 36 | 9.73 | -350.35 | 120 | 1,167.83 | June 7, 2026: 36 @ 9.73 |
| Sept. 21, 2026 | issue | SO-260921-599 | MAIN | 4 | 9.73 | -38.93 | 156 | 1,518.18 | June 7, 2026: 4 @ 9.73 |
| Sept. 17, 2026 | issue | SO-260917-777 | MAIN | 1 | 9.73 | -9.73 | 160 | 1,557.10 | June 7, 2026: 1 @ 9.73 |
| Sept. 11, 2026 | issue | SO-260911-200 | MAIN | 6 | 9.73 | -58.39 | 161 | 1,566.84 | June 7, 2026: 6 @ 9.73 |
| Aug. 15, 2026 | issue | SO-260815-396 | MAIN | 2 | 9.73 | -19.46 | 167 | 1,625.23 | June 7, 2026: 2 @ 9.73 |
| Aug. 4, 2026 | issue | SO-260804-375 | MAIN | 70 | 9.73 | -681.23 | 169 | 1,644.69 | June 7, 2026: 70 @ 9.73 |
| Aug. 3, 2026 | issue | SO-260803-784 | MAIN | 5 | 9.73 | -48.66 | 239 | 2,325.92 | June 7, 2026: 5 @ 9.73 |
| Aug. 1, 2026 | issue | SO-260801-260 | MAIN | 1 | 9.73 | -9.73 | 244 | 2,374.58 | June 7, 2026: 1 @ 9.73 |
| July 31, 2026 | issue | SO-260731-705 | EAST | 19 | 9.73 | -184.91 | 245 | 2,384.32 | June 7, 2026: 19 @ 9.73 |
| July 29, 2026 | return | RMA | MAIN | 27 | 9.73 | 262.76 | 264 | 2,569.22 | |
| July 25, 2026 | issue | SO-260725-645 | MAIN | 20 | 9.73 | -194.64 | 237 | 2,306.46 | June 7, 2026: 20 @ 9.73 |
| July 21, 2026 | issue | SO-260721-708 | EAST | 55 | 9.73 | -535.25 | 257 | 2,501.10 | June 7, 2026: 55 @ 9.73 |
| July 4, 2026 | issue | SO-260704-597 | MAIN | 8 | 9.73 | -77.86 | 312 | 3,036.35 | June 7, 2026: 8 @ 9.73 |
| June 29, 2026 | issue | SO-260629-495 | MAIN | 5 | 9.73 | -48.66 | 320 | 3,114.21 | June 7, 2026: 5 @ 9.73 |
| June 21, 2026 | issue | SO-260621-985 | MAIN | 25 | 9.73 | -243.30 | 325 | 3,162.87 | June 7, 2026: 25 @ 9.73 |
| June 12, 2026 | issue | SO-260612-504 | MAIN | 6 | 9.73 | -58.39 | 350 | 3,406.16 | June 7, 2026: 6 @ 9.73 |
| June 9, 2026 | issue | SO-260609-225 | MAIN | 4 | 9.73 | -38.93 | 356 | 3,464.56 | June 7, 2026: 4 @ 9.73 |
| June 7, 2026 | transfer | TRF | MAIN → EAST | 124 | warehouse transfer, no cost effect | ||||
| June 7, 2026 | receipt | PO-001553 | MAIN | 360 | 9.73 | 3,503.48 | 360 | 3,503.48 | |
| June 6, 2026 | issue | SO-260606-864 | MAIN | 3 | 9.31 | -27.92 | 0 | 0.00 | March 6, 2026: 3 @ 9.31 |
| June 3, 2026 | issue | SO-260603-495 | MAIN | 30 | 9.31 | -279.16 | 3 | 27.92 | Feb. 12, 2026: 22 @ 9.31; March 6, 2026: 8 @ 9.31 |
| May 22, 2026 | issue | SO-260522-421 | MAIN | 33 | 9.31 | -307.07 | 33 | 307.07 | Feb. 12, 2026: 33 @ 9.31 |
| May 4, 2026 | issue | SO-260504-342 | MAIN | 54 | 9.31 | -502.48 | 66 | 614.14 | Feb. 12, 2026: 54 @ 9.31 |
| April 20, 2026 | issue | SO-260420-764 | MAIN | 72 | 9.31 | -669.97 | 120 | 1,116.62 | Feb. 12, 2026: 72 @ 9.31 |
| April 7, 2026 | issue | SO-260407-473 | MAIN | 4 | 9.31 | -37.22 | 192 | 1,786.60 | Feb. 12, 2026: 4 @ 9.31 |
| April 2, 2026 | issue | SO-260402-914 | MAIN | 8 | 9.31 | -74.44 | 196 | 1,823.82 | Feb. 12, 2026: 8 @ 9.31 |
| March 26, 2026 | issue | SO-260326-884 | MAIN | 28 | 9.31 | -260.55 | 204 | 1,898.26 | Feb. 12, 2026: 28 @ 9.31 |
| March 23, 2026 | issue | SO-260323-991 | MAIN | 23 | 9.31 | -214.02 | 232 | 2,158.81 | Feb. 12, 2026: 23 @ 9.31 |
| March 16, 2026 | issue | SO-260316-783 | MAIN | 17 | 9.31 | -158.19 | 255 | 2,372.83 | Feb. 12, 2026: 17 @ 9.31 |
| March 8, 2026 | issue | SO-260308-117 | MAIN | 37 | 9.31 | -344.29 | 272 | 2,531.01 | Feb. 12, 2026: 37 @ 9.31 |
| March 6, 2026 | return | RMA | MAIN | 11 | 9.31 | 102.36 | 309 | 2,875.31 | |
| Feb. 25, 2026 | issue | SO-260225-699 | MAIN | 22 | 9.31 | -204.71 | 298 | 2,772.95 | Feb. 12, 2026: 22 @ 9.31 |
| Feb. 22, 2026 | issue | SO-260222-496 | MAIN | 22 | 9.31 | -204.71 | 320 | 2,977.66 | Feb. 12, 2026: 22 @ 9.31 |
| Feb. 16, 2026 | issue | SO-260216-582 | MAIN | 18 | 9.31 | -167.49 | 342 | 3,182.38 | Feb. 12, 2026: 18 @ 9.31 |
| Feb. 16, 2026 | issue | SO-260216-582 | EAST | 19 | 9.26 | -175.93 | 360 | 3,349.87 | Oct. 7, 2025: 19 @ 9.26 |
| Feb. 12, 2026 | receipt | PO-001220 | MAIN | 360 | 9.31 | 3,349.87 | 379 | 3,525.80 | |
| Feb. 6, 2026 | issue | SO-260206-439 | EAST | 8 | 9.26 | -74.08 | 19 | 175.93 | Oct. 7, 2025: 8 @ 9.26 |
| Jan. 31, 2026 | issue | SO-260131-589 | EAST | 37 | 9.26 | -342.60 | 27 | 250.01 | Oct. 7, 2025: 37 @ 9.26 |
| Jan. 31, 2026 | issue | SO-260131-589 | MAIN | 6 | 9.26 | -55.56 | 64 | 592.61 | Oct. 7, 2025: 6 @ 9.26 |
| Jan. 15, 2026 | issue | SO-260115-142 | MAIN | 29 | 9.26 | -268.53 | 70 | 648.16 | Oct. 7, 2025: 29 @ 9.26 |
| Jan. 14, 2026 | issue | SO-260114-524 | EAST | 20 | 9.26 | -185.19 | 99 | 916.69 | Oct. 7, 2025: 20 @ 9.26 |
| Dec. 30, 2025 | issue | SO-251230-708 | MAIN | 10 | 9.26 | -92.60 | 119 | 1,101.88 | Oct. 7, 2025: 10 @ 9.26 |
| Dec. 24, 2025 | issue | SO-251224-500 | MAIN | 3 | 9.26 | -27.78 | 129 | 1,194.48 | Oct. 7, 2025: 3 @ 9.26 |
| Dec. 12, 2025 | issue | SO-251212-790 | MAIN | 39 | 9.26 | -361.12 | 132 | 1,222.25 | Oct. 7, 2025: 39 @ 9.26 |
| Dec. 6, 2025 | issue | SO-251206-654 | EAST | 18 | 9.26 | -166.67 | 171 | 1,583.37 | Oct. 7, 2025: 18 @ 9.26 |
| Dec. 4, 2025 | issue | SO-251204-206 | MAIN | 7 | 9.26 | -64.82 | 189 | 1,750.05 | Oct. 7, 2025: 7 @ 9.26 |
| Dec. 1, 2025 | issue | SO-251201-181 | MAIN | 18 | 9.26 | -166.67 | 196 | 1,814.86 | Oct. 7, 2025: 18 @ 9.26 |
| Nov. 15, 2025 | issue | SO-251115-279 | EAST | 3 | 9.26 | -27.78 | 214 | 1,981.53 | Oct. 7, 2025: 3 @ 9.26 |
| Nov. 9, 2025 | issue | SO-251109-345 | MAIN | 27 | 9.26 | -250.01 | 217 | 2,009.31 | Oct. 7, 2025: 27 @ 9.26 |
| Nov. 1, 2025 | issue | SO-251101-879 | MAIN | 55 | 9.26 | -509.27 | 244 | 2,259.32 | Oct. 7, 2025: 55 @ 9.26 |
| Oct. 30, 2025 | issue | SO-251030-931 | MAIN | 1 | 9.26 | -9.26 | 299 | 2,768.59 | Oct. 7, 2025: 1 @ 9.26 |
| Oct. 19, 2025 | issue | SO-251019-245 | EAST | 6 | 9.26 | -55.56 | 300 | 2,777.85 | Oct. 7, 2025: 6 @ 9.26 |
| Oct. 14, 2025 | issue | SO-251014-940 | MAIN | 39 | 9.26 | -361.12 | 306 | 2,833.41 | Oct. 7, 2025: 39 @ 9.26 |
| Oct. 10, 2025 | issue | SO-251010-369 | MAIN | 35 | 9.21 | -322.39 | 345 | 3,194.53 | June 15, 2025: 20 @ 9.18; Oct. 7, 2025: 15 @ 9.26 |
| Oct. 8, 2025 | issue | SO-251008-970 | MAIN | 11 | 9.18 | -100.92 | 380 | 3,516.92 | June 15, 2025: 11 @ 9.18 |
| Oct. 7, 2025 | transfer | TRF | MAIN → EAST | 80 | warehouse transfer, no cost effect | ||||
| Oct. 7, 2025 | receipt | PO-000905 | MAIN | 360 | 9.26 | 3,333.42 | 391 | 3,617.84 | |
| Sept. 24, 2025 | issue | SO-250924-893 | EAST | 10 | 9.18 | -91.75 | 31 | 284.42 | June 15, 2025: 10 @ 9.18 |
| Sept. 24, 2025 | issue | SO-250924-893 | MAIN | 45 | 9.18 | -412.88 | 41 | 376.18 | June 15, 2025: 45 @ 9.18 |
| Sept. 9, 2025 | issue | SO-250909-570 | MAIN | 34 | 9.18 | -311.95 | 86 | 789.05 | June 15, 2025: 34 @ 9.18 |
| Aug. 21, 2025 | issue | SO-250821-359 | MAIN | 6 | 9.18 | -55.05 | 120 | 1,101.00 | June 15, 2025: 6 @ 9.18 |
| Aug. 14, 2025 | issue | SO-250814-843 | EAST | 6 | 9.18 | -55.05 | 126 | 1,156.05 | June 15, 2025: 6 @ 9.18 |
| Aug. 9, 2025 | issue | SO-250809-923 | MAIN | 86 | 9.18 | -789.05 | 132 | 1,211.10 | June 15, 2025: 86 @ 9.18 |
| Aug. 6, 2025 | issue | SO-250806-614 | MAIN | 8 | 9.18 | -73.40 | 218 | 2,000.15 | June 15, 2025: 8 @ 9.18 |
| Aug. 5, 2025 | issue | SO-250805-668 | EAST | 1 | 9.18 | -9.18 | 226 | 2,073.55 | June 15, 2025: 1 @ 9.18 |
| July 22, 2025 | issue | SO-250722-415 | EAST | 21 | 9.18 | -192.68 | 227 | 2,082.72 | June 15, 2025: 21 @ 9.18 |
| July 12, 2025 | issue | SO-250712-740 | MAIN | 8 | 9.18 | -73.40 | 248 | 2,275.40 | June 15, 2025: 8 @ 9.18 |
| July 6, 2025 | issue | SO-250706-852 | EAST | 50 | 9.18 | -458.75 | 256 | 2,348.80 | June 15, 2025: 50 @ 9.18 |
| July 1, 2025 | issue | SO-250701-915 | EAST | 5 | 9.18 | -45.88 | 306 | 2,807.55 | June 15, 2025: 5 @ 9.18 |
| June 26, 2025 | issue | SO-250626-811 | MAIN | 11 | 9.18 | -100.92 | 311 | 2,853.42 | June 15, 2025: 11 @ 9.18 |
| June 18, 2025 | issue | SO-250618-683 | MAIN | 37 | 9.18 | -339.48 | 322 | 2,954.35 | June 15, 2025: 37 @ 9.18 |
| June 17, 2025 | issue | SO-250617-734 | MAIN | 21 | 8.98 | -188.50 | 359 | 3,293.82 | Feb. 2, 2025: 20 @ 8.97; June 15, 2025: 1 @ 9.18 |
| June 15, 2025 | transfer | TRF | MAIN → EAST | 124 | warehouse transfer, no cost effect | ||||
| June 15, 2025 | receipt | PO-000637 | MAIN | 360 | 9.18 | 3,303.00 | 380 | 3,482.32 | |
| June 7, 2025 | issue | SO-250607-587 | MAIN | 21 | 8.97 | -188.29 | 20 | 179.32 | Feb. 2, 2025: 21 @ 8.97 |
| June 2, 2025 | issue | SO-250602-704 | MAIN | 2 | 8.97 | -17.93 | 41 | 367.61 | Feb. 2, 2025: 2 @ 8.97 |
| June 1, 2025 | issue | SO-250601-638 | MAIN | 1 | 8.97 | -8.97 | 43 | 385.54 | Feb. 2, 2025: 1 @ 8.97 |
| May 27, 2025 | issue | SO-250527-159 | MAIN | 31 | 8.97 | -277.95 | 44 | 394.51 | Feb. 2, 2025: 31 @ 8.97 |
| May 1, 2025 | issue | SO-250501-456 | MAIN | 69 | 8.97 | -618.66 | 75 | 672.46 | Feb. 2, 2025: 69 @ 8.97 |
| April 27, 2025 | issue | SO-250427-718 | MAIN | 36 | 8.97 | -322.78 | 144 | 1,291.12 | Feb. 2, 2025: 36 @ 8.97 |
| April 25, 2025 | issue | SO-250425-906 | MAIN | 10 | 8.97 | -89.66 | 180 | 1,613.90 | Feb. 2, 2025: 10 @ 8.97 |
| April 15, 2025 | issue | SO-250415-693 | MAIN | 15 | 8.97 | -134.49 | 190 | 1,703.56 | Feb. 2, 2025: 15 @ 8.97 |
| April 4, 2025 | issue | SO-250404-474 | MAIN | 32 | 8.97 | -286.92 | 205 | 1,838.05 | Feb. 2, 2025: 32 @ 8.97 |
| March 4, 2025 | issue | SO-250304-303 | MAIN | 21 | 8.97 | -188.29 | 237 | 2,124.97 | Feb. 2, 2025: 21 @ 8.97 |
| March 3, 2025 | issue | SO-250303-580 | MAIN | 47 | 8.97 | -421.41 | 258 | 2,313.25 | Feb. 2, 2025: 47 @ 8.97 |
| March 2, 2025 | issue | SO-250302-378 | MAIN | 19 | 8.97 | -170.36 | 305 | 2,734.66 | Feb. 2, 2025: 19 @ 8.97 |
| Feb. 26, 2025 | issue | SO-250226-596 | MAIN | 13 | 8.97 | -116.56 | 324 | 2,905.02 | Feb. 2, 2025: 13 @ 8.97 |
| Feb. 25, 2025 | issue | SO-250225-670 | MAIN | 23 | 8.97 | -206.22 | 337 | 3,021.58 | Feb. 2, 2025: 23 @ 8.97 |
| Feb. 25, 2025 | issue | SO-250225-670 | EAST | 23 | 9.19 | -211.29 | 360 | 3,227.80 | Oct. 1, 2024: 23 @ 9.19 |
| Feb. 2, 2025 | receipt | PO-000237 | MAIN | 360 | 8.97 | 3,227.80 | 383 | 3,439.09 | |
| Feb. 1, 2025 | issue | SO-250201-617 | EAST | 4 | 9.19 | -36.75 | 23 | 211.29 | Oct. 1, 2024: 4 @ 9.19 |
| Feb. 1, 2025 | issue | SO-250201-617 | MAIN | 21 | 9.19 | -192.92 | 27 | 248.04 | Oct. 1, 2024: 21 @ 9.19 |
| Jan. 25, 2025 | issue | SO-250125-776 | EAST | 5 | 9.19 | -45.93 | 48 | 440.95 | Oct. 1, 2024: 5 @ 9.19 |
| Jan. 24, 2025 | issue | SO-250124-710 | MAIN | 24 | 9.19 | -220.48 | 53 | 486.88 | Oct. 1, 2024: 24 @ 9.19 |
| Jan. 4, 2025 | issue | SO-250104-760 | MAIN | 40 | 9.19 | -367.46 | 77 | 707.36 | Oct. 1, 2024: 40 @ 9.19 |
| Jan. 1, 2025 | issue | SO-250101-995 | EAST | 18 | 9.19 | -165.36 | 117 | 1,074.82 | Oct. 1, 2024: 18 @ 9.19 |
| Dec. 18, 2024 | issue | SO-241218-276 | MAIN | 13 | 9.19 | -119.42 | 135 | 1,240.18 | Oct. 1, 2024: 13 @ 9.19 |
| Dec. 15, 2024 | issue | SO-241215-949 | MAIN | 3 | 9.19 | -27.56 | 148 | 1,359.60 | Oct. 1, 2024: 3 @ 9.19 |
| Dec. 11, 2024 | issue | SO-241211-720 | MAIN | 10 | 9.19 | -91.86 | 151 | 1,387.16 | Oct. 1, 2024: 10 @ 9.19 |
| Dec. 4, 2024 | issue | SO-241204-330 | EAST | 20 | 9.19 | -183.73 | 161 | 1,479.03 | Oct. 1, 2024: 20 @ 9.19 |
| Dec. 3, 2024 | issue | SO-241203-145 | MAIN | 12 | 9.19 | -110.24 | 181 | 1,662.76 | Oct. 1, 2024: 12 @ 9.19 |
| Dec. 2, 2024 | issue | SO-241202-235 | MAIN | 21 | 9.19 | -192.92 | 193 | 1,772.99 | Oct. 1, 2024: 21 @ 9.19 |
| Nov. 20, 2024 | issue | SO-241120-295 | EAST | 6 | 9.19 | -55.12 | 214 | 1,965.91 | Oct. 1, 2024: 6 @ 9.19 |
| Nov. 1, 2024 | issue | SO-241101-179 | MAIN | 67 | 9.19 | -615.50 | 220 | 2,021.03 | Oct. 1, 2024: 67 @ 9.19 |
| Oct. 29, 2024 | issue | SO-241029-998 | MAIN | 19 | 9.19 | -174.54 | 287 | 2,636.53 | Oct. 1, 2024: 19 @ 9.19 |
| Oct. 18, 2024 | issue | SO-241018-339 | MAIN | 1 | 9.19 | -9.19 | 306 | 2,811.07 | Oct. 1, 2024: 1 @ 9.19 |
| Oct. 15, 2024 | issue | SO-241015-906 | MAIN | 23 | 9.19 | -211.29 | 307 | 2,820.26 | Oct. 1, 2024: 23 @ 9.19 |
| Oct. 12, 2024 | issue | SO-241012-709 | EAST | 16 | 9.19 | -146.98 | 330 | 3,031.54 | Oct. 1, 2024: 16 @ 9.19 |
| Oct. 9, 2024 | issue | SO-241009-772 | MAIN | 8 | 9.19 | -73.49 | 346 | 3,178.53 | Oct. 1, 2024: 8 @ 9.19 |
| Oct. 4, 2024 | issue | SO-241004-621 | MAIN | 6 | 9.19 | -55.12 | 354 | 3,252.02 | Oct. 1, 2024: 6 @ 9.19 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 92 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 360 | 9.19 | 3,307.14 | 360 | 3,307.14 | |