Items / CON-0003
Cable Tray 2m Lite CON-0003 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)89MAIN 13, EAST 76
Value (FIFO)2,770.05avg 31.12
ClassAX / FCV 0.31
Turnover4.5xlast issue 4 days ago
Days of cover34lead 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 | 79.17 / 30.4375 | 2.601 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 24.44 / 5.517 | 4.429 |
| 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 * 4.429^2 + 2.601^2 * 3.1^2) | 37.9 |
| Reorder point | d * LT + safety stock | 2.601 * 14.0 + 37.9 | 74.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 74.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 949/yr, S = 45.00, h = 20%, price = 31.90 | 115.7 |
| Inventory position | on hand + on order | 89 + 0 | 89 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 31.90 | 116 | 31,023 | yes (chosen if cheapest) |
MOQ 360, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 2, 2026 | 89 / 360 | 31.12 | 2,770.05 |
Movement ledger 118 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-534 | MAIN | 12 | 31.12 | -373.49 | 89 | 2,770.05 | Aug. 2, 2026: 12 @ 31.12 |
| Oct. 6, 2026 | issue | SO-261006-266 | MAIN | 39 | 31.12 | -1,213.84 | 101 | 3,143.54 | Aug. 2, 2026: 39 @ 31.12 |
| Oct. 5, 2026 | issue | SO-261005-756 | EAST | 21 | 31.12 | -653.61 | 140 | 4,357.39 | Aug. 2, 2026: 21 @ 31.12 |
| Oct. 3, 2026 | issue | SO-261003-817 | EAST | 6 | 31.12 | -186.75 | 161 | 5,011.00 | Aug. 2, 2026: 6 @ 31.12 |
| Sept. 30, 2026 | issue | SO-260930-478 | MAIN | 2 | 31.12 | -62.25 | 167 | 5,197.74 | Aug. 2, 2026: 2 @ 31.12 |
| Sept. 20, 2026 | issue | SO-260920-223 | EAST | 2 | 31.12 | -62.25 | 169 | 5,259.99 | Aug. 2, 2026: 2 @ 31.12 |
| Sept. 13, 2026 | issue | SO-260913-566 | MAIN | 59 | 31.12 | -1,836.33 | 171 | 5,322.24 | Aug. 2, 2026: 59 @ 31.12 |
| Sept. 4, 2026 | issue | SO-260904-812 | MAIN | 9 | 31.12 | -280.12 | 230 | 7,158.57 | Aug. 2, 2026: 9 @ 31.12 |
| Aug. 23, 2026 | issue | SO-260823-748 | MAIN | 6 | 31.12 | -186.75 | 239 | 7,438.68 | Aug. 2, 2026: 6 @ 31.12 |
| Aug. 22, 2026 | issue | SO-260822-146 | MAIN | 40 | 31.12 | -1,244.97 | 245 | 7,625.43 | Aug. 2, 2026: 40 @ 31.12 |
| Aug. 19, 2026 | issue | SO-260819-669 | EAST | 2 | 31.12 | -62.25 | 285 | 8,870.40 | Aug. 2, 2026: 2 @ 31.12 |
| Aug. 15, 2026 | issue | SO-260815-638 | MAIN | 53 | 31.12 | -1,649.58 | 287 | 8,932.65 | Aug. 2, 2026: 53 @ 31.12 |
| Aug. 14, 2026 | issue | SO-260814-128 | MAIN | 9 | 31.12 | -280.12 | 340 | 10,582.23 | Aug. 2, 2026: 9 @ 31.12 |
| Aug. 4, 2026 | issue | SO-260804-797 | EAST | 5 | 31.12 | -155.62 | 349 | 10,862.35 | Aug. 2, 2026: 5 @ 31.12 |
| Aug. 2, 2026 | issue | SO-260802-964 | MAIN | 6 | 31.12 | -186.75 | 354 | 11,017.97 | Aug. 2, 2026: 6 @ 31.12 |
| Aug. 2, 2026 | transfer | TRF | MAIN → EAST | 112 | warehouse transfer, no cost effect | ||||
| Aug. 2, 2026 | receipt | PO-001690 | MAIN | 360 | 31.12 | 11,204.71 | 360 | 11,204.71 | |
| July 31, 2026 | issue | SO-260731-139 | MAIN | 16 | 31.57 | -505.08 | 0 | 0.00 | March 17, 2026: 16 @ 31.57 |
| July 30, 2026 | issue | SO-260730-777 | MAIN | 31 | 31.57 | -978.59 | 16 | 505.08 | March 17, 2026: 31 @ 31.57 |
| July 16, 2026 | issue | SO-260716-838 | MAIN | 6 | 31.57 | -189.40 | 47 | 1,483.67 | March 17, 2026: 6 @ 31.57 |
| July 15, 2026 | issue | SO-260715-840 | MAIN | 1 | 31.57 | -31.57 | 53 | 1,673.07 | March 17, 2026: 1 @ 31.57 |
| July 13, 2026 | issue | SO-260713-729 | MAIN | 14 | 31.57 | -441.94 | 54 | 1,704.64 | March 17, 2026: 14 @ 31.57 |
| July 2, 2026 | issue | SO-260702-726 | MAIN | 9 | 31.57 | -284.11 | 68 | 2,146.58 | March 17, 2026: 9 @ 31.57 |
| June 27, 2026 | issue | SO-260627-102 | MAIN | 8 | 31.57 | -252.54 | 77 | 2,430.69 | March 17, 2026: 8 @ 31.57 |
| June 27, 2026 | issue | SO-260627-102 | EAST | 14 | 31.57 | -441.94 | 85 | 2,683.23 | March 17, 2026: 14 @ 31.57 |
| June 17, 2026 | issue | SO-260617-665 | MAIN | 57 | 31.57 | -1,799.34 | 99 | 3,125.17 | March 17, 2026: 57 @ 31.57 |
| May 31, 2026 | issue | SO-260531-768 | EAST | 10 | 31.57 | -315.67 | 156 | 4,924.51 | March 17, 2026: 10 @ 31.57 |
| May 30, 2026 | issue | SO-260530-470 | MAIN | 1 | 31.57 | -31.57 | 166 | 5,240.19 | March 17, 2026: 1 @ 31.57 |
| May 27, 2026 | issue | SO-260527-664 | MAIN | 2 | 31.57 | -63.13 | 167 | 5,271.76 | March 17, 2026: 2 @ 31.57 |
| May 26, 2026 | issue | SO-260526-950 | EAST | 1 | 31.57 | -31.57 | 169 | 5,334.89 | March 17, 2026: 1 @ 31.57 |
| May 21, 2026 | issue | SO-260521-105 | MAIN | 4 | 31.57 | -126.27 | 170 | 5,366.46 | March 17, 2026: 4 @ 31.57 |
| May 20, 2026 | issue | SO-260520-291 | MAIN | 40 | 31.57 | -1,262.70 | 174 | 5,492.73 | March 17, 2026: 40 @ 31.57 |
| May 2, 2026 | issue | SO-260502-465 | MAIN | 9 | 31.57 | -284.11 | 214 | 6,755.42 | March 17, 2026: 9 @ 31.57 |
| April 18, 2026 | issue | SO-260418-515 | MAIN | 8 | 31.57 | -252.54 | 223 | 7,039.53 | March 17, 2026: 8 @ 31.57 |
| April 16, 2026 | issue | SO-260416-764 | MAIN | 28 | 31.57 | -883.89 | 231 | 7,292.07 | March 17, 2026: 28 @ 31.57 |
| April 13, 2026 | issue | SO-260413-603 | EAST | 40 | 31.57 | -1,262.70 | 259 | 8,175.96 | March 17, 2026: 40 @ 31.57 |
| April 5, 2026 | issue | SO-260405-803 | MAIN | 30 | 31.57 | -947.02 | 299 | 9,438.65 | March 17, 2026: 30 @ 31.57 |
| March 22, 2026 | issue | SO-260322-995 | MAIN | 9 | 31.57 | -284.11 | 329 | 10,385.67 | March 17, 2026: 9 @ 31.57 |
| March 17, 2026 | issue | SO-260317-979 | EAST | 22 | 31.57 | -694.48 | 338 | 10,669.78 | March 17, 2026: 22 @ 31.57 |
| March 17, 2026 | transfer | TRF | MAIN → EAST | 87 | warehouse transfer, no cost effect | ||||
| March 17, 2026 | receipt | PO-001327 | MAIN | 360 | 31.57 | 11,364.26 | 360 | 11,364.26 | |
| March 1, 2026 | issue | SO-260301-683 | MAIN | 19 | 30.56 | -580.55 | 0 | 0.00 | Nov. 9, 2025: 11 @ 30.56; Feb. 7, 2026: 6 @ 30.56; Feb. 14, 2026: 2 @ 30.56 |
| Feb. 26, 2026 | issue | SO-260226-399 | MAIN | 54 | 30.56 | -1,649.99 | 19 | 580.55 | Sept. 16, 2025: 41 @ 30.56; Nov. 9, 2025: 13 @ 30.56 |
| Feb. 16, 2026 | issue | SO-260216-836 | MAIN | 14 | 30.56 | -427.78 | 73 | 2,230.54 | Sept. 16, 2025: 14 @ 30.56 |
| Feb. 14, 2026 | return | RMA | MAIN | 2 | 30.56 | 61.11 | 87 | 2,658.32 | |
| Feb. 10, 2026 | issue | SO-260210-877 | MAIN | 8 | 30.56 | -244.44 | 85 | 2,597.21 | Sept. 16, 2025: 8 @ 30.56 |
| Feb. 7, 2026 | return | RMA | MAIN | 6 | 30.56 | 183.33 | 93 | 2,841.65 | |
| Feb. 2, 2026 | issue | SO-260202-692 | MAIN | 28 | 30.56 | -855.55 | 87 | 2,658.32 | Sept. 16, 2025: 28 @ 30.56 |
| Feb. 1, 2026 | issue | SO-260201-754 | MAIN | 5 | 30.56 | -152.78 | 115 | 3,513.87 | Sept. 16, 2025: 5 @ 30.56 |
| Jan. 25, 2026 | issue | SO-260125-451 | MAIN | 13 | 30.56 | -397.22 | 120 | 3,666.65 | Sept. 16, 2025: 13 @ 30.56 |
| Jan. 24, 2026 | issue | SO-260124-405 | MAIN | 24 | 30.56 | -733.33 | 133 | 4,063.87 | Sept. 16, 2025: 24 @ 30.56 |
| Jan. 23, 2026 | issue | SO-260123-954 | MAIN | 16 | 30.56 | -488.89 | 157 | 4,797.20 | Sept. 16, 2025: 16 @ 30.56 |
| Dec. 28, 2025 | issue | SO-251228-881 | MAIN | 29 | 30.56 | -886.11 | 173 | 5,286.08 | Sept. 16, 2025: 29 @ 30.56 |
| Dec. 11, 2025 | issue | SO-251211-314 | MAIN | 4 | 30.56 | -122.22 | 202 | 6,172.19 | Sept. 16, 2025: 4 @ 30.56 |
| Dec. 8, 2025 | issue | SO-251208-879 | MAIN | 8 | 30.56 | -244.44 | 206 | 6,294.41 | Sept. 16, 2025: 8 @ 30.56 |
| Dec. 7, 2025 | issue | SO-251207-850 | MAIN | 6 | 30.56 | -183.33 | 214 | 6,538.86 | Sept. 16, 2025: 6 @ 30.56 |
| Dec. 1, 2025 | issue | SO-251201-983 | MAIN | 1 | 30.56 | -30.56 | 220 | 6,722.19 | Sept. 16, 2025: 1 @ 30.56 |
| Nov. 12, 2025 | issue | SO-251112-486 | MAIN | 38 | 30.56 | -1,161.11 | 221 | 6,752.74 | Sept. 16, 2025: 38 @ 30.56 |
| Nov. 9, 2025 | return | RMA | MAIN | 24 | 30.56 | 733.33 | 259 | 7,913.85 | |
| Nov. 8, 2025 | issue | SO-251108-373 | MAIN | 49 | 30.56 | -1,497.21 | 235 | 7,180.52 | Sept. 16, 2025: 49 @ 30.56 |
| Nov. 3, 2025 | issue | SO-251103-989 | MAIN | 51 | 30.56 | -1,558.33 | 284 | 8,677.73 | Sept. 16, 2025: 51 @ 30.56 |
| Oct. 21, 2025 | issue | SO-251021-634 | MAIN | 48 | 30.23 | -1,451.02 | 335 | 10,236.06 | June 8, 2025: 23 @ 29.88; Sept. 16, 2025: 25 @ 30.56 |
| Oct. 12, 2025 | issue | SO-251012-299 | MAIN | 6 | 29.88 | -179.25 | 383 | 11,687.08 | June 8, 2025: 6 @ 29.88 |
| Oct. 3, 2025 | issue | SO-251003-648 | MAIN | 8 | 29.88 | -239.00 | 389 | 11,866.33 | June 8, 2025: 8 @ 29.88 |
| Sept. 26, 2025 | issue | SO-250926-511 | MAIN | 25 | 29.88 | -746.88 | 397 | 12,105.33 | June 8, 2025: 25 @ 29.88 |
| Sept. 16, 2025 | receipt | PO-000847 | MAIN | 360 | 30.56 | 10,999.94 | 422 | 12,852.22 | |
| Sept. 4, 2025 | issue | SO-250904-121 | MAIN | 24 | 29.88 | -717.01 | 62 | 1,852.27 | June 8, 2025: 24 @ 29.88 |
| Sept. 3, 2025 | issue | SO-250903-142 | MAIN | 41 | 29.88 | -1,224.89 | 86 | 2,569.28 | June 8, 2025: 41 @ 29.88 |
| Aug. 30, 2025 | issue | SO-250830-150 | MAIN | 51 | 29.88 | -1,523.65 | 127 | 3,794.18 | June 8, 2025: 51 @ 29.88 |
| Aug. 29, 2025 | issue | SO-250829-515 | MAIN | 15 | 29.88 | -448.13 | 178 | 5,317.82 | June 8, 2025: 15 @ 29.88 |
| Aug. 9, 2025 | issue | SO-250809-777 | MAIN | 8 | 29.88 | -239.00 | 193 | 5,765.95 | June 8, 2025: 8 @ 29.88 |
| Aug. 6, 2025 | issue | SO-250806-636 | EAST | 16 | 29.88 | -478.01 | 201 | 6,004.96 | June 8, 2025: 16 @ 29.88 |
| Aug. 2, 2025 | issue | SO-250802-369 | EAST | 27 | 29.88 | -806.64 | 217 | 6,482.96 | June 8, 2025: 27 @ 29.88 |
| July 31, 2025 | issue | SO-250731-254 | EAST | 6 | 29.88 | -179.25 | 244 | 7,289.60 | June 8, 2025: 6 @ 29.88 |
| July 30, 2025 | issue | SO-250730-952 | EAST | 19 | 29.88 | -567.63 | 250 | 7,468.85 | June 8, 2025: 19 @ 29.88 |
| July 23, 2025 | issue | SO-250723-463 | EAST | 31 | 29.88 | -926.14 | 269 | 8,036.48 | June 8, 2025: 31 @ 29.88 |
| July 21, 2025 | issue | SO-250721-571 | MAIN | 1 | 29.88 | -29.88 | 300 | 8,962.62 | June 8, 2025: 1 @ 29.88 |
| June 17, 2025 | issue | SO-250617-776 | MAIN | 1 | 29.88 | -29.88 | 301 | 8,992.50 | June 8, 2025: 1 @ 29.88 |
| June 15, 2025 | issue | SO-250615-480 | EAST | 12 | 29.88 | -358.50 | 302 | 9,022.37 | June 8, 2025: 12 @ 29.88 |
| June 14, 2025 | issue | SO-250614-198 | MAIN | 6 | 29.88 | -179.25 | 314 | 9,380.88 | June 8, 2025: 6 @ 29.88 |
| June 13, 2025 | issue | SO-250613-301 | MAIN | 41 | 29.86 | -1,224.18 | 320 | 9,560.13 | Feb. 7, 2025: 1 @ 29.16; June 8, 2025: 40 @ 29.88 |
| June 8, 2025 | issue | SO-250608-712 | MAIN | 22 | 29.16 | -641.50 | 361 | 10,784.30 | Feb. 7, 2025: 22 @ 29.16 |
| June 8, 2025 | transfer | TRF | MAIN → EAST | 111 | warehouse transfer, no cost effect | ||||
| June 8, 2025 | receipt | PO-000616 | MAIN | 360 | 29.88 | 10,755.14 | 383 | 11,425.80 | |
| June 6, 2025 | issue | SO-250606-695 | MAIN | 7 | 29.16 | -204.11 | 23 | 670.66 | Feb. 7, 2025: 7 @ 29.16 |
| May 29, 2025 | issue | SO-250529-130 | MAIN | 33 | 29.16 | -962.25 | 30 | 874.77 | Feb. 7, 2025: 33 @ 29.16 |
| May 13, 2025 | issue | SO-250513-831 | MAIN | 73 | 29.16 | -2,128.61 | 63 | 1,837.02 | Feb. 7, 2025: 73 @ 29.16 |
| April 29, 2025 | issue | SO-250429-795 | MAIN | 5 | 29.16 | -145.80 | 136 | 3,965.62 | Feb. 7, 2025: 5 @ 29.16 |
| April 20, 2025 | issue | SO-250420-359 | MAIN | 2 | 29.16 | -58.32 | 141 | 4,111.42 | Feb. 7, 2025: 2 @ 29.16 |
| April 19, 2025 | issue | SO-250419-152 | MAIN | 9 | 29.16 | -262.43 | 143 | 4,169.74 | Feb. 7, 2025: 9 @ 29.16 |
| April 16, 2025 | issue | SO-250416-685 | MAIN | 7 | 29.16 | -204.11 | 152 | 4,432.17 | Feb. 7, 2025: 7 @ 29.16 |
| April 13, 2025 | issue | SO-250413-882 | MAIN | 42 | 29.16 | -1,224.68 | 159 | 4,636.28 | Feb. 7, 2025: 42 @ 29.16 |
| April 7, 2025 | issue | SO-250407-858 | MAIN | 21 | 29.16 | -612.34 | 201 | 5,860.96 | Feb. 7, 2025: 21 @ 29.16 |
| March 27, 2025 | issue | SO-250327-365 | MAIN | 62 | 29.16 | -1,807.86 | 222 | 6,473.30 | Feb. 7, 2025: 62 @ 29.16 |
| March 13, 2025 | issue | SO-250313-227 | MAIN | 1 | 29.16 | -29.16 | 284 | 8,281.16 | Feb. 7, 2025: 1 @ 29.16 |
| March 2, 2025 | issue | SO-250302-412 | MAIN | 18 | 29.16 | -524.86 | 285 | 8,310.32 | Feb. 7, 2025: 18 @ 29.16 |
| Feb. 16, 2025 | issue | SO-250216-813 | MAIN | 56 | 29.16 | -1,632.90 | 303 | 8,835.18 | Feb. 7, 2025: 56 @ 29.16 |
| Feb. 8, 2025 | issue | SO-250208-959 | MAIN | 31 | 30.27 | -938.31 | 359 | 10,468.08 | Oct. 1, 2024: 30 @ 30.30; Feb. 7, 2025: 1 @ 29.16 |
| Feb. 7, 2025 | receipt | PO-000245 | MAIN | 360 | 29.16 | 10,497.24 | 390 | 11,406.39 | |
| Feb. 5, 2025 | issue | SO-250205-110 | MAIN | 11 | 30.30 | -333.36 | 30 | 909.15 | Oct. 1, 2024: 11 @ 30.30 |
| Jan. 27, 2025 | issue | SO-250127-970 | MAIN | 16 | 30.30 | -484.88 | 41 | 1,242.50 | Oct. 1, 2024: 16 @ 30.30 |
| Jan. 26, 2025 | issue | SO-250126-872 | MAIN | 17 | 30.30 | -515.18 | 57 | 1,727.38 | Oct. 1, 2024: 17 @ 30.30 |
| Jan. 23, 2025 | issue | SO-250123-167 | MAIN | 3 | 30.30 | -90.92 | 74 | 2,242.57 | Oct. 1, 2024: 3 @ 30.30 |
| Jan. 20, 2025 | issue | SO-250120-105 | MAIN | 3 | 30.30 | -90.92 | 77 | 2,333.48 | Oct. 1, 2024: 3 @ 30.30 |
| Jan. 13, 2025 | issue | SO-250113-412 | MAIN | 9 | 30.30 | -272.74 | 80 | 2,424.40 | Oct. 1, 2024: 9 @ 30.30 |
| Jan. 10, 2025 | issue | SO-250110-286 | MAIN | 20 | 30.30 | -606.10 | 89 | 2,697.14 | Oct. 1, 2024: 20 @ 30.30 |
| Jan. 4, 2025 | issue | SO-250104-570 | MAIN | 6 | 30.30 | -181.83 | 109 | 3,303.24 | Oct. 1, 2024: 6 @ 30.30 |
| Dec. 21, 2024 | issue | SO-241221-981 | MAIN | 4 | 30.30 | -121.22 | 115 | 3,485.08 | Oct. 1, 2024: 4 @ 30.30 |
| Dec. 21, 2024 | issue | SO-241221-981 | EAST | 59 | 30.30 | -1,788.00 | 119 | 3,606.30 | Oct. 1, 2024: 59 @ 30.30 |
| Dec. 14, 2024 | issue | SO-241214-405 | MAIN | 10 | 30.30 | -303.05 | 178 | 5,394.29 | Oct. 1, 2024: 10 @ 30.30 |
| Nov. 29, 2024 | issue | SO-241129-337 | MAIN | 11 | 30.30 | -333.36 | 188 | 5,697.34 | Oct. 1, 2024: 11 @ 30.30 |
| Nov. 22, 2024 | issue | SO-241122-973 | EAST | 25 | 30.30 | -757.62 | 199 | 6,030.70 | Oct. 1, 2024: 25 @ 30.30 |
| Nov. 17, 2024 | issue | SO-241117-201 | MAIN | 33 | 30.30 | -1,000.06 | 224 | 6,788.32 | Oct. 1, 2024: 33 @ 30.30 |
| Oct. 31, 2024 | issue | SO-241031-283 | MAIN | 16 | 30.30 | -484.88 | 257 | 7,788.38 | Oct. 1, 2024: 16 @ 30.30 |
| Oct. 16, 2024 | issue | SO-241016-614 | MAIN | 10 | 30.30 | -303.05 | 273 | 8,273.26 | Oct. 1, 2024: 10 @ 30.30 |
| Oct. 10, 2024 | issue | SO-241010-251 | MAIN | 77 | 30.30 | -2,333.48 | 283 | 8,576.32 | Oct. 1, 2024: 77 @ 30.30 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 84 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 360 | 30.30 | 10,909.80 | 360 | 10,909.80 | |