Items / CON-0017
Bend 20mm Prime CON-0017 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)85MAIN 85
Value (FIFO)506.08avg 5.95
ClassCX / FCV 0.18
Turnover7.5xlast issue 11 days ago
Days of cover50lead 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 | 52.17 / 30.4375 | 1.714 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.21 / 5.517 | 1.669 |
| 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 * 1.669^2 + 1.714^2 * 3.1^2) | 10.5 |
| Reorder point | d * LT + safety stock | 1.714 * 14.0 + 10.5 | 34.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 34.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 626/yr, S = 45.00, h = 20%, price = 5.72 | 440.0 |
| Inventory position | on hand + on order | 85 + 0 | 85 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 5.96 | 217 | 3,987 | yes |
| 440 | 5.72 | 440 | 3,895 | yes (chosen if cheapest) |
| 880 | 5.48 | 880 | 3,945 | yes |
MOQ 220, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 19, 2026 | 77 / 220 | 5.95 | 458.45 | |
| Sept. 25, 2026 | 8 / 8 | 5.95 | 47.63 |
Movement ledger 125 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 5, 2026 | issue | SO-261005-137 | EAST | 33 | 5.95 | -196.48 | 85 | 506.08 | Aug. 19, 2026: 33 @ 5.95 |
| Oct. 4, 2026 | issue | SO-261004-907 | MAIN | 18 | 5.95 | -107.17 | 118 | 702.56 | Aug. 19, 2026: 18 @ 5.95 |
| Oct. 1, 2026 | issue | SO-261001-572 | EAST | 7 | 5.95 | -41.68 | 136 | 809.73 | Aug. 19, 2026: 7 @ 5.95 |
| Sept. 28, 2026 | issue | SO-260928-604 | EAST | 32 | 5.95 | -190.52 | 143 | 851.41 | Aug. 19, 2026: 32 @ 5.95 |
| Sept. 27, 2026 | issue | SO-260927-409 | MAIN | 24 | 5.95 | -142.89 | 175 | 1,041.93 | Aug. 19, 2026: 24 @ 5.95 |
| Sept. 25, 2026 | return | RMA | MAIN | 8 | 5.95 | 47.63 | 199 | 1,184.83 | |
| Sept. 18, 2026 | issue | SO-260918-455 | MAIN | 16 | 5.95 | -95.26 | 191 | 1,137.19 | Aug. 19, 2026: 16 @ 5.95 |
| Sept. 16, 2026 | issue | SO-260916-424 | MAIN | 2 | 5.95 | -11.91 | 207 | 1,232.46 | Aug. 19, 2026: 2 @ 5.95 |
| Sept. 10, 2026 | issue | SO-260910-945 | MAIN | 2 | 5.95 | -11.91 | 209 | 1,244.37 | Aug. 19, 2026: 2 @ 5.95 |
| Sept. 9, 2026 | issue | SO-260909-800 | EAST | 4 | 5.95 | -23.82 | 211 | 1,256.27 | Aug. 19, 2026: 4 @ 5.95 |
| Aug. 30, 2026 | issue | SO-260830-722 | MAIN | 3 | 5.95 | -17.86 | 215 | 1,280.09 | Aug. 19, 2026: 3 @ 5.95 |
| Aug. 23, 2026 | issue | SO-260823-853 | MAIN | 12 | 5.84 | -70.13 | 218 | 1,297.95 | April 15, 2026: 4 @ 5.82; May 5, 2026: 6 @ 5.82; Aug. 19, 2026: 2 @ 5.95 |
| Aug. 20, 2026 | issue | SO-260820-431 | MAIN | 2 | 5.82 | -11.65 | 230 | 1,368.08 | April 15, 2026: 2 @ 5.82 |
| Aug. 19, 2026 | transfer | TRF | MAIN → EAST | 76 | warehouse transfer, no cost effect | ||||
| Aug. 19, 2026 | receipt | PO-001729 | MAIN | 220 | 5.95 | 1,309.86 | 232 | 1,379.73 | |
| Aug. 7, 2026 | issue | SO-260807-618 | MAIN | 43 | 5.82 | -250.37 | 12 | 69.87 | April 15, 2026: 43 @ 5.82 |
| July 31, 2026 | issue | SO-260731-586 | MAIN | 4 | 5.82 | -23.29 | 55 | 320.24 | April 15, 2026: 4 @ 5.82 |
| July 6, 2026 | issue | SO-260706-302 | MAIN | 3 | 5.82 | -17.47 | 59 | 343.53 | April 15, 2026: 3 @ 5.82 |
| July 4, 2026 | issue | SO-260704-122 | MAIN | 45 | 5.82 | -262.02 | 62 | 361.00 | April 15, 2026: 45 @ 5.82 |
| July 3, 2026 | issue | SO-260703-641 | MAIN | 3 | 5.82 | -17.47 | 107 | 623.02 | April 15, 2026: 3 @ 5.82 |
| June 28, 2026 | issue | SO-260628-558 | MAIN | 1 | 5.82 | -5.82 | 110 | 640.49 | April 15, 2026: 1 @ 5.82 |
| June 26, 2026 | issue | SO-260626-417 | MAIN | 5 | 5.82 | -29.11 | 111 | 646.31 | April 15, 2026: 5 @ 5.82 |
| June 25, 2026 | issue | SO-260625-219 | MAIN | 15 | 5.82 | -87.34 | 116 | 675.42 | April 15, 2026: 15 @ 5.82 |
| June 24, 2026 | issue | SO-260624-185 | MAIN | 13 | 5.82 | -75.69 | 131 | 762.76 | April 15, 2026: 13 @ 5.82 |
| June 21, 2026 | issue | SO-260621-706 | MAIN | 6 | 5.82 | -34.94 | 144 | 838.45 | April 15, 2026: 6 @ 5.82 |
| June 15, 2026 | issue | SO-260615-580 | MAIN | 13 | 5.82 | -75.69 | 150 | 873.39 | April 15, 2026: 13 @ 5.82 |
| June 10, 2026 | issue | SO-260610-843 | MAIN | 1 | 5.82 | -5.82 | 163 | 949.08 | April 15, 2026: 1 @ 5.82 |
| May 25, 2026 | issue | SO-260525-229 | MAIN | 8 | 5.82 | -46.58 | 164 | 954.91 | April 15, 2026: 8 @ 5.82 |
| May 21, 2026 | issue | SO-260521-424 | MAIN | 21 | 5.82 | -122.27 | 172 | 1,001.49 | April 15, 2026: 21 @ 5.82 |
| May 8, 2026 | issue | SO-260508-290 | MAIN | 15 | 5.82 | -87.34 | 193 | 1,123.76 | April 15, 2026: 15 @ 5.82 |
| May 5, 2026 | return | RMA | MAIN | 6 | 5.82 | 34.94 | 208 | 1,211.10 | |
| May 3, 2026 | issue | SO-260503-618 | MAIN | 5 | 5.82 | -29.11 | 202 | 1,176.17 | April 15, 2026: 5 @ 5.82 |
| April 26, 2026 | issue | SO-260426-606 | MAIN | 13 | 5.82 | -75.69 | 207 | 1,205.28 | April 15, 2026: 13 @ 5.82 |
| April 15, 2026 | receipt | PO-001410 | MAIN | 220 | 5.82 | 1,280.97 | 220 | 1,280.97 | |
| April 13, 2026 | issue | SO-260413-622 | MAIN | 25 | 5.79 | -144.85 | 0 | 0.00 | Nov. 19, 2025: 24 @ 5.80; Dec. 14, 2025: 1 @ 5.68 |
| March 30, 2026 | issue | SO-260330-515 | MAIN | 21 | 5.80 | -121.78 | 25 | 144.85 | Nov. 19, 2025: 21 @ 5.80 |
| March 27, 2026 | issue | SO-260327-465 | MAIN | 4 | 5.80 | -23.20 | 46 | 266.63 | Nov. 19, 2025: 4 @ 5.80 |
| March 15, 2026 | issue | SO-260315-194 | MAIN | 27 | 5.80 | -156.57 | 50 | 289.83 | Nov. 19, 2025: 27 @ 5.80 |
| Feb. 21, 2026 | issue | SO-260221-201 | MAIN | 27 | 5.80 | -156.57 | 77 | 446.40 | Nov. 19, 2025: 27 @ 5.80 |
| Feb. 20, 2026 | issue | SO-260220-583 | MAIN | 8 | 5.80 | -46.39 | 104 | 602.97 | Nov. 19, 2025: 8 @ 5.80 |
| Feb. 19, 2026 | issue | SO-260219-380 | MAIN | 12 | 5.80 | -69.59 | 112 | 649.36 | Nov. 19, 2025: 12 @ 5.80 |
| Feb. 7, 2026 | issue | SO-260207-406 | MAIN | 7 | 5.80 | -40.59 | 124 | 718.94 | Nov. 19, 2025: 7 @ 5.80 |
| Jan. 29, 2026 | issue | SO-260129-513 | MAIN | 8 | 5.80 | -46.39 | 131 | 759.54 | Nov. 19, 2025: 8 @ 5.80 |
| Jan. 26, 2026 | issue | SO-260126-212 | MAIN | 18 | 5.80 | -104.38 | 139 | 805.93 | Nov. 19, 2025: 18 @ 5.80 |
| Jan. 24, 2026 | issue | SO-260124-656 | MAIN | 17 | 5.80 | -98.58 | 157 | 910.31 | Nov. 19, 2025: 17 @ 5.80 |
| Jan. 8, 2026 | issue | SO-260108-165 | MAIN | 8 | 5.80 | -46.39 | 174 | 1,008.89 | Nov. 19, 2025: 8 @ 5.80 |
| Jan. 1, 2026 | issue | SO-260101-453 | MAIN | 8 | 5.80 | -46.39 | 182 | 1,055.28 | Nov. 19, 2025: 8 @ 5.80 |
| Dec. 30, 2025 | issue | SO-251230-495 | MAIN | 32 | 5.80 | -185.44 | 190 | 1,101.67 | July 4, 2025: 1 @ 5.68; Nov. 19, 2025: 31 @ 5.80 |
| Dec. 23, 2025 | issue | SO-251223-356 | MAIN | 3 | 5.68 | -17.04 | 222 | 1,287.12 | July 4, 2025: 3 @ 5.68 |
| Dec. 14, 2025 | return | RMA | MAIN | 1 | 5.68 | 5.68 | 225 | 1,304.15 | |
| Dec. 12, 2025 | issue | SO-251212-921 | MAIN | 1 | 5.68 | -5.68 | 224 | 1,298.47 | July 4, 2025: 1 @ 5.68 |
| Dec. 10, 2025 | issue | SO-251210-269 | MAIN | 7 | 5.68 | -39.75 | 225 | 1,304.15 | July 4, 2025: 7 @ 5.68 |
| Dec. 2, 2025 | issue | SO-251202-488 | MAIN | 1 | 5.68 | -5.68 | 232 | 1,343.91 | July 4, 2025: 1 @ 5.68 |
| Nov. 19, 2025 | receipt | PO-001008 | MAIN | 220 | 5.80 | 1,275.76 | 233 | 1,349.59 | |
| Nov. 5, 2025 | issue | SO-251105-565 | MAIN | 27 | 5.68 | -153.34 | 13 | 73.83 | July 4, 2025: 27 @ 5.68 |
| Nov. 4, 2025 | issue | SO-251104-279 | MAIN | 14 | 5.68 | -79.51 | 40 | 227.16 | July 4, 2025: 14 @ 5.68 |
| Oct. 22, 2025 | issue | SO-251022-993 | MAIN | 1 | 5.68 | -5.68 | 54 | 306.67 | July 4, 2025: 1 @ 5.68 |
| Oct. 21, 2025 | issue | SO-251021-855 | MAIN | 6 | 5.68 | -34.07 | 55 | 312.35 | July 4, 2025: 6 @ 5.68 |
| Oct. 19, 2025 | issue | SO-251019-314 | MAIN | 37 | 5.68 | -210.13 | 61 | 346.43 | July 4, 2025: 37 @ 5.68 |
| Oct. 10, 2025 | issue | SO-251010-718 | MAIN | 10 | 5.68 | -56.79 | 98 | 556.55 | July 4, 2025: 10 @ 5.68 |