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
| 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 |
| Oct. 24, 2025 | issue | SO-251024-894 | MAIN | 9 | 19.04 | -171.40 | 483 | 9,198.40 | Aug. 30, 2025: 9 @ 19.04 |
| Oct. 20, 2025 | issue | SO-251020-671 | MAIN | 30 | 19.04 | -571.33 | 492 | 9,369.80 | Aug. 30, 2025: 30 @ 19.04 |
| Oct. 13, 2025 | issue | SO-251013-494 | MAIN | 54 | 19.04 | -1,028.39 | 522 | 9,941.12 | Aug. 30, 2025: 54 @ 19.04 |
| Oct. 9, 2025 | issue | SO-251009-413 | MAIN | 11 | 19.04 | -209.49 | 576 | 10,969.52 | Aug. 30, 2025: 11 @ 19.04 |
| Sept. 18, 2025 | issue | SO-250918-320 | MAIN | 66 | 19.05 | -1,257.19 | 587 | 11,179.00 | May 24, 2025: 13 @ 19.06; Aug. 30, 2025: 53 @ 19.04 |
| Sept. 4, 2025 | issue | SO-250904-578 | MAIN | 46 | 19.06 | -876.98 | 653 | 12,436.19 | May 24, 2025: 46 @ 19.06 |
| Sept. 3, 2025 | issue | SO-250903-705 | MAIN | 18 | 19.06 | -343.17 | 699 | 13,313.18 | May 24, 2025: 18 @ 19.06 |
| Aug. 30, 2025 | receipt | PO-000805 | MAIN | 640 | 19.04 | 12,188.35 | 717 | 13,656.34 | |
| Aug. 15, 2025 | issue | SO-250815-760 | MAIN | 104 | 19.06 | -1,982.74 | 77 | 1,467.99 | May 24, 2025: 104 @ 19.06 |
| Aug. 9, 2025 | issue | SO-250809-730 | MAIN | 83 | 19.06 | -1,582.38 | 181 | 3,450.73 | May 24, 2025: 83 @ 19.06 |
| July 30, 2025 | issue | SO-250730-511 | MAIN | 13 | 19.06 | -247.84 | 264 | 5,033.11 | May 24, 2025: 13 @ 19.06 |
| July 28, 2025 | issue | SO-250728-756 | MAIN | 13 | 19.06 | -247.84 | 277 | 5,280.95 | May 24, 2025: 13 @ 19.06 |
| July 20, 2025 | issue | SO-250720-574 | MAIN | 22 | 19.06 | -419.43 | 290 | 5,528.79 | May 24, 2025: 22 @ 19.06 |
| July 16, 2025 | issue | SO-250716-576 | MAIN | 49 | 19.06 | -934.18 | 312 | 5,948.22 | May 24, 2025: 49 @ 19.06 |
| July 14, 2025 | issue | SO-250714-316 | MAIN | 44 | 19.06 | -838.85 | 361 | 6,882.39 | May 24, 2025: 44 @ 19.06 |
| July 4, 2025 | issue | SO-250704-305 | MAIN | 15 | 19.06 | -285.97 | 405 | 7,721.24 | May 24, 2025: 15 @ 19.06 |
| July 4, 2025 | issue | SO-250704-305 | EAST | 6 | 19.06 | -114.39 | 420 | 8,007.22 | May 24, 2025: 6 @ 19.06 |
| July 3, 2025 | issue | SO-250703-370 | MAIN | 12 | 19.06 | -228.78 | 426 | 8,121.60 | May 24, 2025: 12 @ 19.06 |
| June 9, 2025 | issue | SO-250609-725 | EAST | 150 | 19.06 | -2,859.72 | 438 | 8,350.38 | May 24, 2025: 150 @ 19.06 |
| June 4, 2025 | issue | SO-250604-824 | EAST | 13 | 19.06 | -247.84 | 588 | 11,210.10 | May 24, 2025: 13 @ 19.06 |
| May 26, 2025 | issue | SO-250526-388 | MAIN | 108 | 18.49 | -1,996.98 | 601 | 11,457.94 | Jan. 24, 2025: 54 @ 18.17; Feb. 3, 2025: 15 @ 18.17; May 24, 2025: 39 @ 19.06 |
| May 24, 2025 | transfer | TRF | MAIN → EAST | 169 | warehouse transfer, no cost effect | ||||
| May 24, 2025 | receipt | PO-000567 | MAIN | 640 | 19.06 | 12,201.47 | 709 | 13,454.93 | |
| May 16, 2025 | issue | SO-250516-655 | MAIN | 32 | 18.17 | -581.31 | 69 | 1,253.45 | Jan. 24, 2025: 32 @ 18.17 |
| May 12, 2025 | issue | SO-250512-294 | MAIN | 8 | 18.17 | -145.33 | 101 | 1,834.77 | Jan. 24, 2025: 8 @ 18.17 |
| May 5, 2025 | issue | SO-250505-592 | MAIN | 22 | 18.17 | -399.65 | 109 | 1,980.09 | Jan. 24, 2025: 22 @ 18.17 |
| April 17, 2025 | issue | SO-250417-428 | MAIN | 1 | 18.17 | -18.17 | 131 | 2,379.75 | Jan. 24, 2025: 1 @ 18.17 |
| April 7, 2025 | issue | SO-250407-225 | MAIN | 30 | 18.17 | -544.98 | 132 | 2,397.91 | Jan. 24, 2025: 30 @ 18.17 |
| April 3, 2025 | issue | SO-250403-180 | MAIN | 109 | 18.17 | -1,980.09 | 162 | 2,942.89 | Jan. 24, 2025: 109 @ 18.17 |
| March 22, 2025 | issue | SO-250322-477 | MAIN | 52 | 18.17 | -944.63 | 271 | 4,922.99 | Jan. 24, 2025: 52 @ 18.17 |
| March 20, 2025 | issue | SO-250320-733 | MAIN | 8 | 18.17 | -145.33 | 323 | 5,867.62 | Jan. 24, 2025: 8 @ 18.17 |
| March 8, 2025 | issue | SO-250308-185 | MAIN | 63 | 18.17 | -1,144.46 | 331 | 6,012.95 | Jan. 24, 2025: 63 @ 18.17 |
| Feb. 3, 2025 | return | RMA | MAIN | 15 | 18.17 | 272.49 | 394 | 7,157.40 | |
| Feb. 1, 2025 | issue | SO-250201-628 | MAIN | 34 | 18.17 | -617.64 | 379 | 6,884.91 | Jan. 24, 2025: 34 @ 18.17 |
| Feb. 1, 2025 | issue | SO-250201-628 | EAST | 189 | 18.17 | -3,433.37 | 413 | 7,502.56 | Jan. 24, 2025: 189 @ 18.17 |
| Jan. 28, 2025 | issue | SO-250128-104 | MAIN | 31 | 18.17 | -563.15 | 602 | 10,935.93 | Jan. 24, 2025: 31 @ 18.17 |
| Jan. 27, 2025 | issue | SO-250127-189 | EAST | 6 | 18.17 | -109.00 | 633 | 11,499.08 | Jan. 24, 2025: 6 @ 18.17 |
| Jan. 24, 2025 | issue | SO-250124-163 | MAIN | 1 | 18.17 | -18.17 | 639 | 11,608.07 | Jan. 24, 2025: 1 @ 18.17 |
| Jan. 24, 2025 | transfer | TRF | MAIN → EAST | 195 | warehouse transfer, no cost effect | ||||
| Jan. 24, 2025 | receipt | PO-000211 | MAIN | 640 | 18.17 | 11,626.24 | 640 | 11,626.24 | |
| Jan. 16, 2025 | issue | SO-250116-600 | MAIN | 15 | 18.87 | -283.00 | 0 | 0.00 | Oct. 1, 2024: 14 @ 18.87; Dec. 3, 2024: 1 @ 18.87 |
| Jan. 1, 2025 | issue | SO-250101-718 | MAIN | 135 | 18.87 | -2,547.04 | 15 | 283.00 | Oct. 1, 2024: 135 @ 18.87 |
| Dec. 15, 2024 | issue | SO-241215-932 | MAIN | 91 | 18.87 | -1,716.90 | 150 | 2,830.05 | Oct. 1, 2024: 91 @ 18.87 |
| Dec. 11, 2024 | issue | SO-241211-757 | MAIN | 62 | 18.87 | -1,169.75 | 241 | 4,546.95 | Oct. 1, 2024: 62 @ 18.87 |
| Dec. 7, 2024 | issue | SO-241207-853 | MAIN | 28 | 18.87 | -528.28 | 303 | 5,716.70 | Oct. 1, 2024: 28 @ 18.87 |
| Dec. 3, 2024 | return | RMA | MAIN | 1 | 18.87 | 18.87 | 331 | 6,244.98 | |
| Nov. 24, 2024 | issue | SO-241124-179 | MAIN | 2 | 18.87 | -37.73 | 330 | 6,226.11 | Oct. 1, 2024: 2 @ 18.87 |
| Nov. 20, 2024 | issue | SO-241120-998 | MAIN | 30 | 18.87 | -566.01 | 332 | 6,263.84 | Oct. 1, 2024: 30 @ 18.87 |
| Nov. 15, 2024 | issue | SO-241115-106 | MAIN | 34 | 18.87 | -641.48 | 362 | 6,829.85 | Oct. 1, 2024: 34 @ 18.87 |
| Nov. 11, 2024 | issue | SO-241111-471 | MAIN | 107 | 18.87 | -2,018.77 | 396 | 7,471.33 | Oct. 1, 2024: 107 @ 18.87 |
| Oct. 31, 2024 | issue | SO-241031-376 | MAIN | 15 | 18.87 | -283.00 | 503 | 9,490.10 | Oct. 1, 2024: 15 @ 18.87 |
| Oct. 24, 2024 | issue | SO-241024-158 | MAIN | 7 | 18.87 | -132.07 | 518 | 9,773.11 | Oct. 1, 2024: 7 @ 18.87 |
| Oct. 15, 2024 | issue | SO-241015-695 | MAIN | 30 | 18.87 | -566.01 | 525 | 9,905.18 | Oct. 1, 2024: 30 @ 18.87 |
| Oct. 8, 2024 | issue | SO-241008-631 | MAIN | 85 | 18.87 | -1,603.70 | 555 | 10,471.18 | Oct. 1, 2024: 85 @ 18.87 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 640 | 18.87 | 12,074.88 | 640 | 12,074.88 | |