Items / CON-0028
Bend 20mm Max CON-0028 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)47MAIN 47
Value (FIFO)500.00avg 10.64
ClassCX / FCV 0.16
Turnover10.3xlast issue 2 days ago
Days of cover56lead 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 | 25.42 / 30.4375 | 0.835 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.15 / 5.517 | 0.753 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(14.0 * 0.753^2 + 0.835^2 * 3.1^2) | 4.9 |
| Reorder point | d * LT + safety stock | 0.835 * 14.0 + 4.9 | 16.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 305/yr, S = 45.00, h = 20%, price = 11.06 | 111.4 |
| Inventory position | on hand + on order | 47 + 0 | 47 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 11.06 | 111 | 3,617 | yes (chosen if cheapest) |
MOQ 120, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 27, 2026 | 47 / 120 | 10.64 | 500.00 |
Movement ledger 99 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-928 | MAIN | 21 | 10.64 | -223.41 | 47 | 500.00 | July 27, 2026: 21 @ 10.64 |
| Oct. 12, 2026 | issue | SO-261012-805 | MAIN | 2 | 10.64 | -21.28 | 68 | 723.41 | July 27, 2026: 2 @ 10.64 |
| Oct. 7, 2026 | issue | SO-261007-131 | MAIN | 5 | 10.64 | -53.19 | 70 | 744.69 | July 27, 2026: 5 @ 10.64 |
| Oct. 5, 2026 | issue | SO-261005-199 | MAIN | 1 | 10.64 | -10.64 | 75 | 797.88 | July 27, 2026: 1 @ 10.64 |
| Oct. 2, 2026 | issue | SO-261002-624 | MAIN | 5 | 10.64 | -53.19 | 76 | 808.52 | July 27, 2026: 5 @ 10.64 |
| Sept. 30, 2026 | issue | SO-260930-629 | MAIN | 7 | 10.64 | -74.47 | 81 | 861.71 | July 27, 2026: 7 @ 10.64 |
| Sept. 15, 2026 | issue | SO-260915-340 | MAIN | 3 | 10.64 | -31.92 | 88 | 936.18 | July 27, 2026: 3 @ 10.64 |
| Sept. 4, 2026 | issue | SO-260904-191 | MAIN | 21 | 10.64 | -223.41 | 91 | 968.09 | July 27, 2026: 21 @ 10.64 |
| Aug. 23, 2026 | issue | SO-260823-431 | MAIN | 16 | 10.77 | -172.33 | 112 | 1,191.50 | March 20, 2026: 8 @ 10.90; July 27, 2026: 8 @ 10.64 |
| Aug. 16, 2026 | issue | SO-260816-659 | MAIN | 8 | 10.90 | -87.22 | 128 | 1,363.83 | March 20, 2026: 8 @ 10.90 |
| July 27, 2026 | receipt | PO-001679 | MAIN | 120 | 10.64 | 1,276.61 | 136 | 1,451.05 | |
| July 18, 2026 | issue | SO-260718-978 | MAIN | 27 | 10.90 | -294.37 | 16 | 174.44 | March 20, 2026: 27 @ 10.90 |
| June 25, 2026 | issue | SO-260625-745 | MAIN | 12 | 10.90 | -130.83 | 43 | 468.81 | March 20, 2026: 12 @ 10.90 |
| June 16, 2026 | issue | SO-260616-144 | MAIN | 4 | 10.90 | -43.61 | 55 | 599.64 | March 20, 2026: 4 @ 10.90 |
| June 15, 2026 | issue | SO-260615-574 | MAIN | 6 | 10.90 | -65.42 | 59 | 643.25 | March 20, 2026: 6 @ 10.90 |
| June 4, 2026 | issue | SO-260604-773 | MAIN | 7 | 10.90 | -76.32 | 65 | 708.67 | March 20, 2026: 7 @ 10.90 |
| May 12, 2026 | issue | SO-260512-167 | MAIN | 6 | 10.90 | -65.42 | 72 | 784.99 | March 20, 2026: 6 @ 10.90 |
| May 2, 2026 | issue | SO-260502-918 | MAIN | 13 | 10.90 | -141.73 | 78 | 850.40 | March 20, 2026: 13 @ 10.90 |
| April 26, 2026 | issue | SO-260426-560 | MAIN | 1 | 10.90 | -10.90 | 91 | 992.14 | March 20, 2026: 1 @ 10.90 |
| April 15, 2026 | issue | SO-260415-209 | MAIN | 4 | 10.90 | -43.61 | 92 | 1,003.04 | March 20, 2026: 4 @ 10.90 |
| April 14, 2026 | issue | SO-260414-471 | MAIN | 3 | 10.90 | -32.71 | 96 | 1,046.65 | March 20, 2026: 3 @ 10.90 |
| April 8, 2026 | issue | SO-260408-457 | MAIN | 14 | 10.90 | -152.64 | 99 | 1,079.36 | March 20, 2026: 14 @ 10.90 |
| April 6, 2026 | issue | SO-260406-190 | MAIN | 7 | 10.90 | -76.32 | 113 | 1,231.99 | March 20, 2026: 7 @ 10.90 |
| March 20, 2026 | receipt | PO-001335 | MAIN | 120 | 10.90 | 1,308.31 | 120 | 1,308.31 | |
| March 6, 2026 | issue | SO-260306-955 | MAIN | 16 | 10.43 | -166.83 | 0 | 0.00 | Nov. 2, 2025: 16 @ 10.43 |
| March 5, 2026 | issue | SO-260305-349 | MAIN | 4 | 10.43 | -41.71 | 16 | 166.83 | Nov. 2, 2025: 4 @ 10.43 |
| Feb. 17, 2026 | issue | SO-260217-257 | MAIN | 2 | 10.43 | -20.85 | 20 | 208.54 | Nov. 2, 2025: 2 @ 10.43 |
| Feb. 13, 2026 | issue | SO-260213-932 | MAIN | 9 | 10.43 | -93.84 | 22 | 229.39 | Nov. 2, 2025: 9 @ 10.43 |
| Feb. 11, 2026 | issue | SO-260211-936 | MAIN | 11 | 10.43 | -114.69 | 31 | 323.23 | Nov. 2, 2025: 11 @ 10.43 |
| Feb. 9, 2026 | issue | SO-260209-491 | MAIN | 3 | 10.43 | -31.28 | 42 | 437.93 | Nov. 2, 2025: 3 @ 10.43 |
| Feb. 8, 2026 | issue | SO-260208-293 | MAIN | 1 | 10.43 | -10.43 | 45 | 469.21 | Nov. 2, 2025: 1 @ 10.43 |
| Feb. 1, 2026 | issue | SO-260201-477 | MAIN | 5 | 10.43 | -52.13 | 46 | 479.63 | Nov. 2, 2025: 5 @ 10.43 |
| Jan. 26, 2026 | issue | SO-260126-630 | MAIN | 12 | 10.43 | -125.12 | 51 | 531.77 | Nov. 2, 2025: 12 @ 10.43 |
| Jan. 16, 2026 | issue | SO-260116-101 | MAIN | 15 | 10.43 | -156.40 | 63 | 656.89 | Nov. 2, 2025: 15 @ 10.43 |
| Dec. 29, 2025 | issue | SO-251229-868 | MAIN | 10 | 10.43 | -104.27 | 78 | 813.29 | Nov. 2, 2025: 10 @ 10.43 |
| Dec. 25, 2025 | issue | SO-251225-823 | MAIN | 4 | 10.43 | -41.71 | 88 | 917.56 | Nov. 2, 2025: 4 @ 10.43 |
| Dec. 22, 2025 | issue | SO-251222-272 | MAIN | 1 | 10.43 | -10.43 | 92 | 959.27 | Nov. 2, 2025: 1 @ 10.43 |
| Dec. 20, 2025 | issue | SO-251220-952 | MAIN | 2 | 10.43 | -20.85 | 93 | 969.69 | Nov. 2, 2025: 2 @ 10.43 |
| Dec. 18, 2025 | issue | SO-251218-401 | MAIN | 1 | 10.43 | -10.43 | 95 | 990.55 | Nov. 2, 2025: 1 @ 10.43 |
| Dec. 14, 2025 | issue | SO-251214-270 | MAIN | 8 | 10.43 | -83.41 | 96 | 1,000.97 | Nov. 2, 2025: 8 @ 10.43 |
| Nov. 28, 2025 | issue | SO-251128-836 | MAIN | 15 | 10.43 | -156.40 | 104 | 1,084.39 | Nov. 2, 2025: 15 @ 10.43 |
| Nov. 25, 2025 | issue | SO-251125-881 | MAIN | 1 | 10.43 | -10.43 | 119 | 1,240.79 | Nov. 2, 2025: 1 @ 10.43 |
| Nov. 3, 2025 | issue | SO-251103-742 | MAIN | 6 | 10.28 | -61.69 | 120 | 1,251.22 | June 14, 2025: 6 @ 10.28 |
| Nov. 2, 2025 | receipt | PO-000974 | MAIN | 120 | 10.43 | 1,251.22 | 126 | 1,312.90 | |
| Oct. 21, 2025 | issue | SO-251021-121 | MAIN | 4 | 10.28 | -41.12 | 6 | 61.69 | June 14, 2025: 4 @ 10.28 |
| Oct. 19, 2025 | issue | SO-251019-228 | MAIN | 7 | 10.28 | -71.97 | 10 | 102.81 | June 14, 2025: 7 @ 10.28 |
| Oct. 18, 2025 | issue | SO-251018-214 | MAIN | 1 | 10.28 | -10.28 | 17 | 174.78 | June 14, 2025: 1 @ 10.28 |
| Oct. 12, 2025 | issue | SO-251012-800 | MAIN | 6 | 10.28 | -61.69 | 18 | 185.06 | June 14, 2025: 6 @ 10.28 |
| Oct. 9, 2025 | issue | SO-251009-545 | MAIN | 2 | 10.28 | -20.56 | 24 | 246.75 | June 14, 2025: 2 @ 10.28 |
| Sept. 28, 2025 | issue | SO-250928-315 | MAIN | 3 | 10.28 | -30.84 | 26 | 267.31 | June 14, 2025: 3 @ 10.28 |
| Sept. 25, 2025 | issue | SO-250925-230 | MAIN | 8 | 10.28 | -82.25 | 29 | 298.15 | June 14, 2025: 8 @ 10.28 |
| Sept. 21, 2025 | issue | SO-250921-975 | MAIN | 14 | 10.28 | -143.94 | 37 | 380.40 | June 14, 2025: 14 @ 10.28 |
| Sept. 20, 2025 | issue | SO-250920-853 | MAIN | 3 | 10.28 | -30.84 | 51 | 524.34 | June 14, 2025: 3 @ 10.28 |
| Sept. 19, 2025 | issue | SO-250919-382 | MAIN | 5 | 10.28 | -51.41 | 54 | 555.18 | June 14, 2025: 5 @ 10.28 |
| Sept. 8, 2025 | issue | SO-250908-517 | MAIN | 1 | 10.28 | -10.28 | 59 | 606.59 | June 14, 2025: 1 @ 10.28 |
| Aug. 22, 2025 | issue | SO-250822-664 | MAIN | 2 | 10.28 | -20.56 | 60 | 616.87 | June 14, 2025: 2 @ 10.28 |
| Aug. 17, 2025 | issue | SO-250817-740 | MAIN | 3 | 10.28 | -30.84 | 62 | 637.43 | June 14, 2025: 3 @ 10.28 |
| Aug. 8, 2025 | issue | SO-250808-972 | MAIN | 2 | 10.28 | -20.56 | 65 | 668.28 | June 14, 2025: 2 @ 10.28 |
| Aug. 2, 2025 | issue | SO-250802-186 | MAIN | 23 | 10.28 | -236.47 | 67 | 688.84 | June 14, 2025: 23 @ 10.28 |
| July 26, 2025 | issue | SO-250726-455 | MAIN | 1 | 10.28 | -10.28 | 90 | 925.31 | June 14, 2025: 1 @ 10.28 |