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, latest 60 shown - show all
| 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 |