Items / CON-0022
Bend 20mm Eco CON-0022 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)427MAIN 427
Value (FIFO)8,451.57avg 19.79
ClassAX / FCV 0.13
Turnover4.2xlast issue 2 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 | 160.33 / 30.4375 | 5.268 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 20.73 / 5.517 | 3.758 |
| 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.758^2 + 5.268^2 * 3.1^2) | 44.3 |
| Reorder point | d * LT + safety stock | 5.268 * 14.0 + 44.3 | 118.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 118.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 1923/yr, S = 45.00, h = 20%, price = 19.86 | 208.7 |
| Inventory position | on hand + on order | 427 + 0 | 427 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 19.86 | 209 | 39,014 | yes (chosen if cheapest) |
MOQ 640, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 17, 2026 | 427 / 640 | 19.79 | 8,451.57 |
Movement ledger 115 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 14, 2026 | issue | SO-261014-680 | MAIN | 94 | 19.79 | -1,860.53 | 427 | 8,451.57 | Sept. 17, 2026: 94 @ 19.79 |
| Oct. 7, 2026 | issue | SO-261007-855 | MAIN | 15 | 19.79 | -296.89 | 521 | 10,312.10 | Sept. 17, 2026: 15 @ 19.79 |
| Oct. 5, 2026 | issue | SO-261005-651 | MAIN | 3 | 19.79 | -59.38 | 536 | 10,608.99 | Sept. 17, 2026: 3 @ 19.79 |
| Oct. 1, 2026 | issue | SO-261001-842 | MAIN | 43 | 19.79 | -851.09 | 539 | 10,668.37 | Sept. 17, 2026: 43 @ 19.79 |
| Sept. 22, 2026 | issue | SO-260922-856 | MAIN | 67 | 19.82 | -1,327.71 | 582 | 11,519.47 | May 7, 2026: 9 @ 19.97; Sept. 17, 2026: 58 @ 19.79 |
| Sept. 17, 2026 | receipt | PO-001808 | MAIN | 640 | 19.79 | 12,667.46 | 649 | 12,847.18 | |
| Sept. 14, 2026 | issue | SO-260914-970 | MAIN | 28 | 19.97 | -559.13 | 9 | 179.72 | May 7, 2026: 28 @ 19.97 |
| Sept. 9, 2026 | issue | SO-260909-234 | MAIN | 4 | 19.97 | -79.88 | 37 | 738.85 | May 7, 2026: 4 @ 19.97 |
| Sept. 8, 2026 | issue | SO-260908-432 | MAIN | 57 | 19.97 | -1,138.23 | 41 | 818.72 | May 7, 2026: 57 @ 19.97 |
| Aug. 31, 2026 | issue | SO-260831-918 | MAIN | 136 | 19.97 | -2,715.77 | 98 | 1,956.95 | May 7, 2026: 136 @ 19.97 |
| Aug. 11, 2026 | issue | SO-260811-936 | MAIN | 38 | 19.97 | -758.82 | 234 | 4,672.72 | May 7, 2026: 38 @ 19.97 |
| Aug. 5, 2026 | issue | SO-260805-180 | MAIN | 33 | 19.97 | -658.97 | 272 | 5,431.54 | May 7, 2026: 33 @ 19.97 |
| July 27, 2026 | issue | SO-260727-372 | MAIN | 33 | 19.97 | -658.97 | 305 | 6,090.51 | May 7, 2026: 33 @ 19.97 |
| July 22, 2026 | adjustment | Cycle count | MAIN | -1 | 19.97 | -19.97 | 338 | 6,749.49 | May 7, 2026: 1 @ 19.97 |
| July 16, 2026 | issue | SO-260716-653 | MAIN | 38 | 19.97 | -758.82 | 339 | 6,769.46 | May 7, 2026: 38 @ 19.97 |
| July 11, 2026 | issue | SO-260711-370 | MAIN | 9 | 19.97 | -179.72 | 377 | 7,528.28 | May 7, 2026: 9 @ 19.97 |
| July 7, 2026 | issue | SO-260707-778 | MAIN | 10 | 19.97 | -199.69 | 386 | 7,708.00 | May 7, 2026: 10 @ 19.97 |
| July 2, 2026 | issue | SO-260702-681 | MAIN | 52 | 19.97 | -1,038.38 | 396 | 7,907.68 | May 7, 2026: 52 @ 19.97 |
| June 25, 2026 | issue | SO-260625-513 | MAIN | 1 | 19.97 | -19.97 | 448 | 8,946.07 | May 7, 2026: 1 @ 19.97 |
| June 24, 2026 | issue | SO-260624-419 | MAIN | 30 | 19.97 | -599.07 | 449 | 8,966.04 | May 7, 2026: 30 @ 19.97 |
| June 24, 2026 | issue | SO-260624-419 | EAST | 58 | 19.97 | -1,158.20 | 479 | 9,565.10 | May 7, 2026: 58 @ 19.97 |
| June 19, 2026 | issue | SO-260619-273 | MAIN | 7 | 19.97 | -139.78 | 537 | 10,723.30 | May 7, 2026: 7 @ 19.97 |
| June 7, 2026 | issue | SO-260607-723 | EAST | 16 | 19.97 | -319.50 | 544 | 10,863.08 | May 7, 2026: 16 @ 19.97 |
| June 4, 2026 | issue | SO-260604-885 | EAST | 7 | 19.97 | -139.78 | 560 | 11,182.58 | May 7, 2026: 7 @ 19.97 |
| June 2, 2026 | issue | SO-260602-548 | EAST | 14 | 19.97 | -279.56 | 567 | 11,322.37 | May 7, 2026: 14 @ 19.97 |
| May 22, 2026 | issue | SO-260522-708 | EAST | 17 | 19.97 | -339.47 | 581 | 11,601.93 | May 7, 2026: 17 @ 19.97 |
| May 20, 2026 | issue | SO-260520-336 | MAIN | 25 | 19.97 | -499.22 | 598 | 11,941.40 | May 7, 2026: 25 @ 19.97 |
| May 16, 2026 | issue | SO-260516-998 | MAIN | 51 | 19.13 | -975.41 | 623 | 12,440.62 | Jan. 17, 2026: 34 @ 18.70; May 7, 2026: 17 @ 19.97 |
| May 15, 2026 | issue | SO-260515-992 | EAST | 20 | 18.70 | -374.08 | 674 | 13,416.04 | Jan. 17, 2026: 20 @ 18.70 |
| May 9, 2026 | issue | SO-260509-406 | MAIN | 24 | 18.70 | -448.90 | 694 | 13,790.12 | Jan. 17, 2026: 24 @ 18.70 |
| May 7, 2026 | transfer | TRF | MAIN → EAST | 132 | warehouse transfer, no cost effect | ||||
| May 7, 2026 | receipt | PO-001470 | MAIN | 640 | 19.97 | 12,780.10 | 718 | 14,239.02 | |
| April 27, 2026 | issue | SO-260427-342 | MAIN | 42 | 18.70 | -785.57 | 78 | 1,458.92 | Jan. 17, 2026: 42 @ 18.70 |
| April 21, 2026 | issue | SO-260421-287 | MAIN | 64 | 18.70 | -1,197.06 | 120 | 2,244.49 | Jan. 17, 2026: 64 @ 18.70 |
| April 15, 2026 | issue | SO-260415-669 | MAIN | 12 | 18.70 | -224.45 | 184 | 3,441.55 | Jan. 17, 2026: 12 @ 18.70 |
| April 11, 2026 | issue | SO-260411-180 | MAIN | 23 | 18.70 | -430.19 | 196 | 3,666.00 | Jan. 17, 2026: 23 @ 18.70 |
| April 2, 2026 | issue | SO-260402-575 | MAIN | 23 | 18.70 | -430.19 | 219 | 4,096.20 | Jan. 17, 2026: 23 @ 18.70 |
| March 26, 2026 | issue | SO-260326-225 | MAIN | 14 | 18.70 | -261.86 | 242 | 4,526.39 | Jan. 17, 2026: 14 @ 18.70 |
| March 23, 2026 | issue | SO-260323-682 | MAIN | 34 | 18.70 | -635.94 | 256 | 4,788.25 | Jan. 17, 2026: 34 @ 18.70 |
| March 22, 2026 | issue | SO-260322-736 | MAIN | 8 | 18.70 | -149.63 | 290 | 5,424.19 | Jan. 17, 2026: 8 @ 18.70 |
| March 15, 2026 | issue | SO-260315-236 | MAIN | 42 | 18.70 | -785.57 | 298 | 5,573.82 | Jan. 17, 2026: 42 @ 18.70 |
| March 10, 2026 | issue | SO-260310-771 | MAIN | 1 | 18.70 | -18.70 | 340 | 6,359.39 | Jan. 17, 2026: 1 @ 18.70 |
| March 1, 2026 | issue | SO-260301-772 | MAIN | 68 | 18.70 | -1,271.88 | 341 | 6,378.10 | Jan. 17, 2026: 68 @ 18.70 |
| Feb. 26, 2026 | issue | SO-260226-228 | MAIN | 180 | 18.70 | -3,366.74 | 409 | 7,649.98 | Jan. 17, 2026: 180 @ 18.70 |
| Feb. 13, 2026 | issue | SO-260213-736 | MAIN | 1 | 18.70 | -18.70 | 589 | 11,016.71 | Jan. 17, 2026: 1 @ 18.70 |
| Feb. 1, 2026 | issue | SO-260201-545 | MAIN | 2 | 18.70 | -37.41 | 590 | 11,035.42 | Jan. 17, 2026: 2 @ 18.70 |
| Jan. 21, 2026 | issue | SO-260121-333 | MAIN | 119 | 18.91 | -2,249.94 | 592 | 11,072.83 | Aug. 30, 2025: 71 @ 19.04; Jan. 17, 2026: 48 @ 18.70 |
| Jan. 18, 2026 | issue | SO-260118-114 | MAIN | 26 | 19.04 | -495.15 | 711 | 13,322.77 | Aug. 30, 2025: 26 @ 19.04 |
| Jan. 17, 2026 | receipt | PO-001153 | MAIN | 640 | 18.70 | 11,970.62 | 737 | 13,817.92 | |
| Dec. 31, 2025 | issue | SO-251231-627 | MAIN | 24 | 19.04 | -457.06 | 97 | 1,847.30 | Aug. 30, 2025: 24 @ 19.04 |
| Dec. 25, 2025 | issue | SO-251225-491 | MAIN | 58 | 19.04 | -1,104.57 | 121 | 2,304.36 | Aug. 30, 2025: 58 @ 19.04 |
| Dec. 21, 2025 | issue | SO-251221-126 | MAIN | 9 | 19.04 | -171.40 | 179 | 3,408.93 | Aug. 30, 2025: 9 @ 19.04 |
| Dec. 17, 2025 | issue | SO-251217-728 | MAIN | 3 | 19.04 | -57.13 | 188 | 3,580.33 | Aug. 30, 2025: 3 @ 19.04 |
| Dec. 14, 2025 | issue | SO-251214-334 | MAIN | 4 | 19.04 | -76.18 | 191 | 3,637.46 | Aug. 30, 2025: 4 @ 19.04 |
| Dec. 10, 2025 | issue | SO-251210-415 | MAIN | 31 | 19.04 | -590.37 | 195 | 3,713.64 | Aug. 30, 2025: 31 @ 19.04 |
| Dec. 6, 2025 | issue | SO-251206-399 | MAIN | 48 | 19.04 | -914.13 | 226 | 4,304.01 | Aug. 30, 2025: 48 @ 19.04 |
| Nov. 16, 2025 | issue | SO-251116-888 | MAIN | 23 | 19.04 | -438.02 | 274 | 5,218.14 | Aug. 30, 2025: 23 @ 19.04 |
| Nov. 9, 2025 | issue | SO-251109-660 | MAIN | 123 | 19.04 | -2,342.45 | 297 | 5,656.16 | Aug. 30, 2025: 123 @ 19.04 |
| Oct. 29, 2025 | issue | SO-251029-299 | MAIN | 1 | 19.04 | -19.04 | 420 | 7,998.61 | Aug. 30, 2025: 1 @ 19.04 |
| Oct. 28, 2025 | issue | SO-251028-301 | MAIN | 62 | 19.04 | -1,180.75 | 421 | 8,017.65 | Aug. 30, 2025: 62 @ 19.04 |