Items / CON-0008
Clamp 25mm Lite CON-0008 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)100MAIN 100
Value (FIFO)5,759.74avg 57.60
ClassBX / FCV 0.26
Turnover7.8xlast issue 1 days ago
Days of cover81lead 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 | 37.42 / 30.4375 | 1.229 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.74 / 5.517 | 1.766 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(14.0 * 1.766^2 + 1.229^2 * 3.1^2) | 12.6 |
| Reorder point | d * LT + safety stock | 1.229 * 14.0 + 12.6 | 29.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 29.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 449/yr, S = 45.00, h = 20%, price = 59.65 | 58.2 |
| Inventory position | on hand + on order | 100 + 0 | 100 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 59.65 | 58 | 27,459 | yes (chosen if cheapest) |
MOQ 180, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 27, 2026 | 90 / 180 | 57.60 | 5,183.77 | |
| Aug. 20, 2026 | 10 / 10 | 57.60 | 575.97 |
Movement ledger 120 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-889 | MAIN | 1 | 57.60 | -57.60 | 100 | 5,759.74 | July 27, 2026: 1 @ 57.60 |
| Oct. 12, 2026 | issue | SO-261012-650 | MAIN | 4 | 57.60 | -230.39 | 101 | 5,817.34 | July 27, 2026: 4 @ 57.60 |
| Oct. 11, 2026 | issue | SO-261011-708 | MAIN | 4 | 57.60 | -230.39 | 105 | 6,047.73 | July 27, 2026: 4 @ 57.60 |
| Oct. 7, 2026 | issue | SO-261007-232 | MAIN | 4 | 57.60 | -230.39 | 109 | 6,278.12 | July 27, 2026: 4 @ 57.60 |
| Oct. 5, 2026 | issue | SO-261005-844 | MAIN | 24 | 57.60 | -1,382.34 | 113 | 6,508.51 | July 27, 2026: 24 @ 57.60 |
| Oct. 3, 2026 | issue | SO-261003-617 | MAIN | 1 | 57.60 | -57.60 | 137 | 7,890.84 | July 27, 2026: 1 @ 57.60 |
| Oct. 2, 2026 | issue | SO-261002-319 | MAIN | 1 | 57.60 | -57.60 | 138 | 7,948.44 | July 27, 2026: 1 @ 57.60 |
| Sept. 21, 2026 | issue | SO-260921-601 | MAIN | 9 | 57.60 | -518.38 | 139 | 8,006.04 | July 27, 2026: 9 @ 57.60 |
| Sept. 19, 2026 | issue | SO-260919-468 | MAIN | 1 | 57.60 | -57.60 | 148 | 8,524.42 | July 27, 2026: 1 @ 57.60 |
| Sept. 9, 2026 | issue | SO-260909-701 | MAIN | 29 | 57.60 | -1,670.32 | 149 | 8,582.01 | July 27, 2026: 29 @ 57.60 |
| Sept. 2, 2026 | issue | SO-260902-897 | MAIN | 1 | 57.60 | -57.60 | 178 | 10,252.34 | July 27, 2026: 1 @ 57.60 |
| Aug. 20, 2026 | return | RMA | MAIN | 10 | 57.60 | 575.97 | 179 | 10,309.93 | |
| Aug. 12, 2026 | issue | SO-260812-541 | MAIN | 2 | 57.60 | -115.19 | 169 | 9,733.96 | July 27, 2026: 2 @ 57.60 |
| Aug. 11, 2026 | issue | SO-260811-171 | MAIN | 4 | 57.60 | -230.39 | 171 | 9,849.16 | July 27, 2026: 4 @ 57.60 |
| Aug. 9, 2026 | issue | SO-260809-492 | MAIN | 1 | 57.60 | -57.60 | 175 | 10,079.54 | July 27, 2026: 1 @ 57.60 |
| Aug. 3, 2026 | issue | SO-260803-370 | MAIN | 20 | 56.96 | -1,139.21 | 176 | 10,137.14 | April 3, 2026: 16 @ 56.80; July 27, 2026: 4 @ 57.60 |
| Aug. 2, 2026 | issue | SO-260802-308 | MAIN | 8 | 56.80 | -454.41 | 196 | 11,276.35 | April 3, 2026: 8 @ 56.80 |
| July 27, 2026 | receipt | PO-001678 | MAIN | 180 | 57.60 | 10,367.53 | 204 | 11,730.77 | |
| July 18, 2026 | issue | SO-260718-217 | MAIN | 3 | 56.80 | -170.40 | 24 | 1,363.23 | April 3, 2026: 3 @ 56.80 |
| July 9, 2026 | issue | SO-260709-994 | MAIN | 2 | 56.80 | -113.60 | 27 | 1,533.64 | April 3, 2026: 2 @ 56.80 |
| July 8, 2026 | issue | SO-260708-220 | MAIN | 14 | 56.80 | -795.22 | 29 | 1,647.24 | April 3, 2026: 14 @ 56.80 |
| July 5, 2026 | issue | SO-260705-561 | MAIN | 1 | 56.80 | -56.80 | 43 | 2,442.46 | April 3, 2026: 1 @ 56.80 |
| July 2, 2026 | issue | SO-260702-458 | MAIN | 21 | 56.80 | -1,192.83 | 44 | 2,499.26 | April 3, 2026: 21 @ 56.80 |
| June 27, 2026 | issue | SO-260627-674 | MAIN | 2 | 56.80 | -113.60 | 65 | 3,692.09 | April 3, 2026: 2 @ 56.80 |
| June 6, 2026 | issue | SO-260606-162 | MAIN | 3 | 56.80 | -170.40 | 67 | 3,805.69 | April 3, 2026: 3 @ 56.80 |
| June 5, 2026 | issue | SO-260605-360 | MAIN | 16 | 56.80 | -908.82 | 70 | 3,976.10 | April 3, 2026: 16 @ 56.80 |
| June 2, 2026 | issue | SO-260602-199 | MAIN | 1 | 56.80 | -56.80 | 86 | 4,884.92 | April 3, 2026: 1 @ 56.80 |
| May 31, 2026 | issue | SO-260531-144 | MAIN | 4 | 56.80 | -227.21 | 87 | 4,941.72 | April 3, 2026: 4 @ 56.80 |
| May 10, 2026 | issue | SO-260510-440 | MAIN | 49 | 56.80 | -2,783.27 | 91 | 5,168.93 | April 3, 2026: 49 @ 56.80 |
| May 7, 2026 | issue | SO-260507-894 | MAIN | 1 | 56.80 | -56.80 | 140 | 7,952.20 | April 3, 2026: 1 @ 56.80 |
| April 14, 2026 | issue | SO-260414-584 | MAIN | 3 | 56.80 | -170.40 | 141 | 8,009.00 | April 3, 2026: 3 @ 56.80 |
| April 9, 2026 | issue | SO-260409-548 | MAIN | 31 | 56.80 | -1,760.84 | 144 | 8,179.40 | April 3, 2026: 31 @ 56.80 |
| April 8, 2026 | issue | SO-260408-674 | MAIN | 5 | 56.80 | -284.01 | 175 | 9,940.24 | April 3, 2026: 5 @ 56.80 |
| April 3, 2026 | receipt | PO-001380 | MAIN | 180 | 56.80 | 10,224.25 | 180 | 10,224.25 | |
| April 2, 2026 | issue | SO-260402-748 | MAIN | 11 | 55.85 | -614.39 | 0 | 0.00 | Oct. 21, 2025: 1 @ 55.85; Dec. 3, 2025: 10 @ 55.85 |
| March 29, 2026 | issue | SO-260329-803 | MAIN | 1 | 55.85 | -55.85 | 11 | 614.39 | Oct. 21, 2025: 1 @ 55.85 |
| March 28, 2026 | issue | SO-260328-761 | MAIN | 9 | 55.85 | -502.68 | 12 | 670.24 | Oct. 21, 2025: 9 @ 55.85 |
| March 27, 2026 | issue | SO-260327-608 | MAIN | 6 | 55.85 | -335.12 | 21 | 1,172.92 | Oct. 21, 2025: 6 @ 55.85 |
| March 21, 2026 | issue | SO-260321-717 | MAIN | 7 | 55.85 | -390.97 | 27 | 1,508.04 | Oct. 21, 2025: 7 @ 55.85 |
| March 16, 2026 | issue | SO-260316-209 | MAIN | 6 | 55.85 | -335.12 | 34 | 1,899.01 | Oct. 21, 2025: 6 @ 55.85 |
| March 7, 2026 | issue | SO-260307-846 | MAIN | 9 | 55.85 | -502.68 | 40 | 2,234.13 | Oct. 21, 2025: 9 @ 55.85 |
| Feb. 21, 2026 | issue | SO-260221-564 | MAIN | 20 | 55.85 | -1,117.07 | 49 | 2,736.81 | Oct. 21, 2025: 20 @ 55.85 |
| Feb. 19, 2026 | issue | SO-260219-809 | MAIN | 1 | 55.85 | -55.85 | 69 | 3,853.88 | Oct. 21, 2025: 1 @ 55.85 |
| Feb. 15, 2026 | issue | SO-260215-246 | MAIN | 14 | 55.85 | -781.95 | 70 | 3,909.73 | Oct. 21, 2025: 14 @ 55.85 |
| Feb. 9, 2026 | issue | SO-260209-256 | MAIN | 1 | 55.85 | -55.85 | 84 | 4,691.68 | Oct. 21, 2025: 1 @ 55.85 |
| Feb. 3, 2026 | issue | SO-260203-538 | MAIN | 2 | 55.85 | -111.71 | 85 | 4,747.53 | Oct. 21, 2025: 2 @ 55.85 |
| Jan. 31, 2026 | issue | SO-260131-439 | MAIN | 2 | 55.85 | -111.71 | 87 | 4,859.24 | Oct. 21, 2025: 2 @ 55.85 |
| Jan. 31, 2026 | issue | SO-260131-439 | EAST | 6 | 55.85 | -335.12 | 89 | 4,970.94 | Oct. 21, 2025: 6 @ 55.85 |
| Jan. 28, 2026 | issue | SO-260128-354 | MAIN | 26 | 55.85 | -1,452.19 | 95 | 5,306.06 | Oct. 21, 2025: 26 @ 55.85 |
| Dec. 21, 2025 | issue | SO-251221-597 | MAIN | 1 | 55.85 | -55.85 | 121 | 6,758.25 | Oct. 21, 2025: 1 @ 55.85 |
| Dec. 11, 2025 | issue | SO-251211-198 | MAIN | 3 | 55.85 | -167.56 | 122 | 6,814.10 | Oct. 21, 2025: 3 @ 55.85 |
| Dec. 10, 2025 | issue | SO-251210-644 | MAIN | 12 | 55.85 | -670.24 | 125 | 6,981.66 | Oct. 21, 2025: 12 @ 55.85 |
| Dec. 9, 2025 | issue | SO-251209-821 | MAIN | 4 | 55.85 | -223.41 | 137 | 7,651.90 | Oct. 21, 2025: 4 @ 55.85 |
| Dec. 5, 2025 | issue | SO-251205-434 | MAIN | 11 | 55.85 | -614.39 | 141 | 7,875.32 | Oct. 21, 2025: 11 @ 55.85 |
| Dec. 4, 2025 | issue | SO-251204-792 | MAIN | 2 | 55.85 | -111.71 | 152 | 8,489.70 | Oct. 21, 2025: 2 @ 55.85 |
| Dec. 3, 2025 | return | RMA | MAIN | 10 | 55.85 | 558.53 | 154 | 8,601.41 | |
| Nov. 28, 2025 | issue | SO-251128-307 | MAIN | 7 | 55.85 | -390.97 | 144 | 8,042.88 | Oct. 21, 2025: 7 @ 55.85 |
| Nov. 25, 2025 | issue | SO-251125-978 | EAST | 20 | 55.85 | -1,117.07 | 151 | 8,433.85 | Oct. 21, 2025: 20 @ 55.85 |
| Nov. 24, 2025 | issue | SO-251124-348 | MAIN | 11 | 55.98 | -615.77 | 171 | 9,550.91 | June 12, 2025: 2 @ 56.55; Oct. 21, 2025: 9 @ 55.85 |
| Oct. 22, 2025 | issue | SO-251022-324 | EAST | 21 | 55.63 | -1,168.23 | 182 | 10,166.69 | June 7, 2025: 13 @ 55.07; June 12, 2025: 8 @ 56.55 |