Items / CON-0006
Junction Box Eco CON-0006 · Conduit & Fittings · Conduit & Cable Co
On hand (EA)199MAIN 199
Value (FIFO)2,715.65avg 13.65
ClassCX / FCV 0.16
Turnover3.7xlast issue 6 days ago
Days of cover102lead 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 | 59.33 / 30.4375 | 1.949 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.31 / 5.517 | 1.688 |
| 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.688^2 + 1.949^2 * 3.1^2) | 11.2 |
| Reorder point | d * LT + safety stock | 1.949 * 14.0 + 11.2 | 38.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 38.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 712/yr, S = 45.00, h = 20%, price = 13.65 | 153.2 |
| Inventory position | on hand + on order | 199 + 0 | 199 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 13.65 | 153 | 10,130 | yes (chosen if cheapest) |
MOQ 240, pack size 20, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 8, 2026 | 199 / 240 | 13.65 | 2,715.65 |
Movement ledger 117 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 10, 2026 | issue | SO-261010-408 | MAIN | 40 | 13.65 | -545.86 | 199 | 2,715.65 | Oct. 8, 2026: 40 @ 13.65 |
| Oct. 9, 2026 | issue | SO-261009-873 | MAIN | 1 | 13.65 | -13.65 | 239 | 3,261.51 | Oct. 8, 2026: 1 @ 13.65 |
| Oct. 8, 2026 | receipt | PO-001860 | MAIN | 240 | 13.65 | 3,275.16 | 240 | 3,275.16 | |
| Sept. 29, 2026 | issue | SO-260929-221 | MAIN | 6 | 13.25 | -79.47 | 0 | 0.00 | June 15, 2026: 6 @ 13.25 |
| Sept. 25, 2026 | issue | SO-260925-334 | MAIN | 42 | 13.25 | -556.32 | 6 | 79.47 | May 12, 2026: 42 @ 13.25 |
| Sept. 11, 2026 | issue | SO-260911-896 | MAIN | 3 | 13.25 | -39.74 | 48 | 635.79 | May 12, 2026: 3 @ 13.25 |
| Aug. 29, 2026 | issue | SO-260829-460 | MAIN | 12 | 13.25 | -158.95 | 51 | 675.53 | May 12, 2026: 12 @ 13.25 |
| Aug. 22, 2026 | issue | SO-260822-756 | MAIN | 19 | 13.25 | -251.67 | 63 | 834.48 | May 12, 2026: 19 @ 13.25 |
| Aug. 21, 2026 | issue | SO-260821-766 | MAIN | 10 | 13.25 | -132.46 | 82 | 1,086.15 | May 12, 2026: 10 @ 13.25 |
| Aug. 11, 2026 | issue | SO-260811-337 | MAIN | 15 | 13.25 | -198.69 | 92 | 1,218.60 | May 12, 2026: 15 @ 13.25 |
| Aug. 8, 2026 | issue | SO-260808-552 | MAIN | 4 | 13.25 | -52.98 | 107 | 1,417.29 | May 12, 2026: 4 @ 13.25 |
| July 29, 2026 | issue | SO-260729-730 | MAIN | 2 | 13.25 | -26.49 | 111 | 1,470.27 | May 12, 2026: 2 @ 13.25 |
| July 25, 2026 | issue | SO-260725-425 | MAIN | 4 | 13.25 | -52.98 | 113 | 1,496.76 | May 12, 2026: 4 @ 13.25 |
| July 25, 2026 | issue | SO-260725-425 | EAST | 36 | 13.25 | -476.85 | 117 | 1,549.75 | May 12, 2026: 36 @ 13.25 |
| July 18, 2026 | issue | SO-260718-287 | EAST | 5 | 13.25 | -66.23 | 153 | 2,026.59 | May 12, 2026: 5 @ 13.25 |
| July 15, 2026 | issue | SO-260715-922 | MAIN | 9 | 13.25 | -119.21 | 158 | 2,092.82 | May 12, 2026: 9 @ 13.25 |
| July 6, 2026 | issue | SO-260706-273 | MAIN | 3 | 13.25 | -39.74 | 167 | 2,212.03 | May 12, 2026: 3 @ 13.25 |
| June 28, 2026 | issue | SO-260628-873 | MAIN | 4 | 13.25 | -52.98 | 170 | 2,251.77 | May 12, 2026: 4 @ 13.25 |
| June 27, 2026 | issue | SO-260627-976 | MAIN | 3 | 13.25 | -39.74 | 174 | 2,304.75 | May 12, 2026: 3 @ 13.25 |
| June 26, 2026 | issue | SO-260626-698 | EAST | 1 | 13.25 | -13.25 | 177 | 2,344.49 | May 12, 2026: 1 @ 13.25 |
| June 21, 2026 | issue | SO-260621-109 | MAIN | 4 | 13.25 | -52.98 | 178 | 2,357.73 | May 12, 2026: 4 @ 13.25 |
| June 16, 2026 | issue | SO-260616-689 | MAIN | 9 | 13.25 | -119.21 | 182 | 2,410.72 | May 12, 2026: 9 @ 13.25 |
| June 15, 2026 | return | RMA | MAIN | 6 | 13.25 | 79.47 | 191 | 2,529.93 | |
| June 15, 2026 | issue | SO-260615-591 | MAIN | 39 | 13.25 | -516.58 | 185 | 2,450.45 | May 12, 2026: 39 @ 13.25 |
| June 1, 2026 | issue | SO-260601-411 | MAIN | 14 | 13.25 | -185.44 | 224 | 2,967.04 | May 12, 2026: 14 @ 13.25 |
| May 29, 2026 | issue | SO-260529-677 | MAIN | 1 | 13.25 | -13.25 | 238 | 3,152.48 | May 12, 2026: 1 @ 13.25 |
| May 28, 2026 | issue | SO-260528-955 | EAST | 10 | 13.33 | -133.25 | 239 | 3,165.72 | Jan. 12, 2026: 9 @ 13.33; May 12, 2026: 1 @ 13.25 |
| May 27, 2026 | issue | SO-260527-846 | EAST | 3 | 13.33 | -40.00 | 249 | 3,298.98 | Jan. 12, 2026: 3 @ 13.33 |
| May 26, 2026 | issue | SO-260526-444 | EAST | 13 | 13.33 | -173.34 | 252 | 3,338.98 | Jan. 12, 2026: 13 @ 13.33 |
| May 12, 2026 | transfer | TRF | MAIN → EAST | 68 | warehouse transfer, no cost effect | ||||
| May 12, 2026 | receipt | PO-001485 | MAIN | 240 | 13.25 | 3,178.97 | 265 | 3,512.32 | |
| May 5, 2026 | issue | SO-260505-280 | MAIN | 4 | 13.33 | -53.34 | 25 | 333.36 | Jan. 12, 2026: 4 @ 13.33 |
| May 4, 2026 | issue | SO-260504-462 | MAIN | 4 | 13.33 | -53.34 | 29 | 386.69 | Jan. 12, 2026: 4 @ 13.33 |
| April 28, 2026 | issue | SO-260428-766 | MAIN | 8 | 13.33 | -106.67 | 33 | 440.03 | Jan. 12, 2026: 8 @ 13.33 |
| April 25, 2026 | issue | SO-260425-623 | MAIN | 44 | 13.33 | -586.70 | 41 | 546.70 | Jan. 12, 2026: 44 @ 13.33 |
| April 24, 2026 | issue | SO-260424-845 | MAIN | 2 | 13.33 | -26.67 | 85 | 1,133.41 | Jan. 12, 2026: 2 @ 13.33 |
| April 24, 2026 | issue | SO-260424-845 | EAST | 13 | 13.33 | -173.34 | 87 | 1,160.08 | Jan. 12, 2026: 13 @ 13.33 |
| April 8, 2026 | issue | SO-260408-772 | EAST | 1 | 13.33 | -13.33 | 100 | 1,333.42 | Jan. 12, 2026: 1 @ 13.33 |
| March 24, 2026 | issue | SO-260324-868 | MAIN | 58 | 13.33 | -773.38 | 101 | 1,346.75 | Jan. 12, 2026: 58 @ 13.33 |
| March 22, 2026 | issue | SO-260322-765 | EAST | 6 | 13.33 | -80.01 | 159 | 2,120.14 | Jan. 12, 2026: 6 @ 13.33 |
| March 5, 2026 | issue | SO-260305-672 | MAIN | 3 | 13.33 | -40.00 | 165 | 2,200.14 | Jan. 12, 2026: 3 @ 13.33 |
| Feb. 24, 2026 | issue | SO-260224-713 | MAIN | 2 | 13.33 | -26.67 | 168 | 2,240.15 | Jan. 12, 2026: 2 @ 13.33 |
| Feb. 8, 2026 | issue | SO-260208-184 | MAIN | 24 | 13.33 | -320.02 | 170 | 2,266.81 | Jan. 12, 2026: 24 @ 13.33 |
| Feb. 5, 2026 | issue | SO-260205-477 | EAST | 7 | 13.33 | -93.34 | 194 | 2,586.83 | Jan. 12, 2026: 7 @ 13.33 |
| Feb. 2, 2026 | issue | SO-260202-186 | MAIN | 21 | 13.33 | -280.02 | 201 | 2,680.17 | Jan. 12, 2026: 21 @ 13.33 |
| Jan. 29, 2026 | issue | SO-260129-902 | MAIN | 2 | 13.33 | -26.67 | 222 | 2,960.19 | Jan. 12, 2026: 2 @ 13.33 |
| Jan. 26, 2026 | issue | SO-260126-839 | EAST | 26 | 13.18 | -342.57 | 224 | 2,986.86 | Sept. 7, 2025: 10 @ 12.92; Jan. 12, 2026: 16 @ 13.33 |
| Jan. 25, 2026 | issue | SO-260125-817 | MAIN | 10 | 12.92 | -129.22 | 250 | 3,329.43 | Sept. 7, 2025: 10 @ 12.92 |
| Jan. 23, 2026 | issue | SO-260123-508 | MAIN | 2 | 12.92 | -25.84 | 260 | 3,458.65 | Sept. 7, 2025: 2 @ 12.92 |
| Jan. 12, 2026 | issue | SO-260112-441 | MAIN | 1 | 12.92 | -12.92 | 262 | 3,484.49 | Sept. 7, 2025: 1 @ 12.92 |
| Jan. 12, 2026 | transfer | TRF | MAIN → EAST | 53 | warehouse transfer, no cost effect | ||||
| Jan. 12, 2026 | receipt | PO-001137 | MAIN | 240 | 13.33 | 3,200.21 | 263 | 3,497.41 | |
| Jan. 9, 2026 | issue | SO-260109-868 | MAIN | 19 | 12.92 | -245.52 | 23 | 297.20 | Sept. 7, 2025: 19 @ 12.92 |
| Dec. 28, 2025 | issue | SO-251228-435 | MAIN | 27 | 12.92 | -348.89 | 42 | 542.72 | Sept. 7, 2025: 27 @ 12.92 |
| Dec. 26, 2025 | issue | SO-251226-264 | MAIN | 6 | 12.92 | -77.53 | 69 | 891.61 | Sept. 7, 2025: 6 @ 12.92 |
| Dec. 24, 2025 | issue | SO-251224-108 | MAIN | 1 | 12.92 | -12.92 | 75 | 969.14 | Sept. 7, 2025: 1 @ 12.92 |
| Dec. 22, 2025 | issue | SO-251222-269 | MAIN | 12 | 12.92 | -155.06 | 76 | 982.06 | Sept. 7, 2025: 12 @ 12.92 |
| Dec. 18, 2025 | issue | SO-251218-332 | MAIN | 4 | 12.92 | -51.69 | 88 | 1,137.13 | Sept. 7, 2025: 4 @ 12.92 |
| Dec. 18, 2025 | issue | SO-251218-332 | EAST | 9 | 12.92 | -116.30 | 92 | 1,188.81 | Sept. 7, 2025: 9 @ 12.92 |
| Dec. 8, 2025 | issue | SO-251208-441 | MAIN | 2 | 12.92 | -25.84 | 101 | 1,305.11 | Sept. 7, 2025: 2 @ 12.92 |