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
| 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 |
| Nov. 26, 2025 | issue | SO-251126-982 | MAIN | 13 | 12.92 | -167.98 | 103 | 1,330.96 | Sept. 7, 2025: 13 @ 12.92 |
| Nov. 24, 2025 | issue | SO-251124-170 | MAIN | 11 | 12.92 | -142.14 | 116 | 1,498.94 | Sept. 7, 2025: 11 @ 12.92 |
| Nov. 21, 2025 | issue | SO-251121-697 | MAIN | 3 | 12.92 | -38.77 | 127 | 1,641.08 | Sept. 7, 2025: 3 @ 12.92 |
| Nov. 10, 2025 | issue | SO-251110-164 | EAST | 10 | 12.92 | -129.22 | 130 | 1,679.85 | Sept. 7, 2025: 10 @ 12.92 |
| Nov. 9, 2025 | issue | SO-251109-169 | EAST | 1 | 12.92 | -12.92 | 140 | 1,809.07 | Sept. 7, 2025: 1 @ 12.92 |
| Nov. 6, 2025 | issue | SO-251106-420 | EAST | 1 | 12.92 | -12.92 | 141 | 1,821.99 | Sept. 7, 2025: 1 @ 12.92 |
| Nov. 5, 2025 | issue | SO-251105-638 | EAST | 32 | 12.92 | -413.50 | 142 | 1,834.91 | Sept. 7, 2025: 32 @ 12.92 |
| Oct. 3, 2025 | issue | SO-251003-154 | MAIN | 24 | 12.92 | -310.13 | 174 | 2,248.41 | Sept. 7, 2025: 24 @ 12.92 |
| Oct. 2, 2025 | issue | SO-251002-732 | MAIN | 34 | 12.92 | -439.34 | 198 | 2,558.54 | Sept. 7, 2025: 34 @ 12.92 |
| Sept. 27, 2025 | issue | SO-250927-443 | EAST | 8 | 12.92 | -103.38 | 232 | 2,997.88 | Sept. 7, 2025: 8 @ 12.92 |
| Sept. 7, 2025 | transfer | TRF | MAIN → EAST | 61 | warehouse transfer, no cost effect | ||||
| Sept. 7, 2025 | receipt | PO-000820 | MAIN | 240 | 12.92 | 3,101.26 | 240 | 3,101.26 | |
| Sept. 1, 2025 | issue | SO-250901-836 | MAIN | 16 | 12.83 | -205.30 | 0 | 0.00 | May 4, 2025: 16 @ 12.83 |
| Aug. 28, 2025 | issue | SO-250828-491 | MAIN | 14 | 12.83 | -179.64 | 16 | 205.30 | May 4, 2025: 14 @ 12.83 |
| Aug. 25, 2025 | issue | SO-250825-574 | MAIN | 10 | 12.83 | -128.31 | 30 | 384.94 | May 4, 2025: 10 @ 12.83 |
| Aug. 23, 2025 | issue | SO-250823-623 | MAIN | 4 | 12.83 | -51.33 | 40 | 513.26 | May 4, 2025: 4 @ 12.83 |
| Aug. 22, 2025 | issue | SO-250822-805 | MAIN | 3 | 12.83 | -38.49 | 44 | 564.58 | May 4, 2025: 3 @ 12.83 |
| Aug. 21, 2025 | issue | SO-250821-835 | MAIN | 15 | 12.83 | -192.47 | 47 | 603.08 | May 4, 2025: 15 @ 12.83 |
| Aug. 9, 2025 | issue | SO-250809-215 | MAIN | 4 | 12.83 | -51.33 | 62 | 795.55 | May 4, 2025: 4 @ 12.83 |
| Aug. 2, 2025 | issue | SO-250802-679 | MAIN | 14 | 12.83 | -179.64 | 66 | 846.87 | May 4, 2025: 14 @ 12.83 |
| July 26, 2025 | issue | SO-250726-270 | MAIN | 35 | 12.83 | -449.10 | 80 | 1,026.51 | May 4, 2025: 35 @ 12.83 |
| July 5, 2025 | issue | SO-250705-902 | MAIN | 33 | 12.83 | -423.44 | 115 | 1,475.61 | May 4, 2025: 33 @ 12.83 |
| June 20, 2025 | issue | SO-250620-306 | MAIN | 25 | 12.83 | -320.78 | 148 | 1,899.05 | May 4, 2025: 25 @ 12.83 |
| June 15, 2025 | issue | SO-250615-926 | MAIN | 8 | 12.83 | -102.65 | 173 | 2,219.83 | May 4, 2025: 8 @ 12.83 |
| June 13, 2025 | issue | SO-250613-343 | MAIN | 24 | 12.83 | -307.95 | 181 | 2,322.48 | May 4, 2025: 24 @ 12.83 |
| June 4, 2025 | issue | SO-250604-269 | MAIN | 7 | 12.83 | -89.82 | 205 | 2,630.44 | May 4, 2025: 7 @ 12.83 |
| May 31, 2025 | issue | SO-250531-647 | MAIN | 26 | 12.83 | -333.62 | 212 | 2,720.26 | May 4, 2025: 26 @ 12.83 |
| May 29, 2025 | issue | SO-250529-656 | MAIN | 27 | 12.94 | -349.50 | 238 | 3,053.87 | Dec. 27, 2024: 25 @ 12.95; May 4, 2025: 2 @ 12.83 |
| May 26, 2025 | issue | SO-250526-485 | MAIN | 3 | 12.95 | -38.86 | 265 | 3,403.38 | Dec. 27, 2024: 3 @ 12.95 |
| May 13, 2025 | issue | SO-250513-409 | MAIN | 7 | 12.95 | -90.68 | 268 | 3,442.24 | Dec. 27, 2024: 7 @ 12.95 |
| May 4, 2025 | receipt | PO-000511 | MAIN | 240 | 12.83 | 3,079.54 | 275 | 3,532.91 | |
| April 21, 2025 | issue | SO-250421-599 | MAIN | 43 | 12.95 | -557.00 | 35 | 453.38 | Dec. 27, 2024: 43 @ 12.95 |
| April 16, 2025 | issue | SO-250416-559 | MAIN | 2 | 12.95 | -25.91 | 78 | 1,010.38 | Dec. 27, 2024: 2 @ 12.95 |
| April 15, 2025 | issue | SO-250415-649 | MAIN | 9 | 12.95 | -116.58 | 80 | 1,036.29 | Dec. 27, 2024: 9 @ 12.95 |
| April 4, 2025 | issue | SO-250404-106 | MAIN | 6 | 12.95 | -77.72 | 89 | 1,152.87 | Dec. 27, 2024: 6 @ 12.95 |
| March 27, 2025 | issue | SO-250327-371 | MAIN | 15 | 12.95 | -194.30 | 95 | 1,230.59 | Dec. 27, 2024: 15 @ 12.95 |
| March 13, 2025 | issue | SO-250313-989 | MAIN | 6 | 12.95 | -77.72 | 110 | 1,424.90 | Dec. 27, 2024: 6 @ 12.95 |
| March 7, 2025 | issue | SO-250307-449 | MAIN | 28 | 12.95 | -362.70 | 116 | 1,502.62 | Dec. 27, 2024: 28 @ 12.95 |
| Feb. 28, 2025 | issue | SO-250228-135 | MAIN | 10 | 12.95 | -129.54 | 144 | 1,865.32 | Dec. 27, 2024: 10 @ 12.95 |
| Feb. 24, 2025 | issue | SO-250224-260 | MAIN | 10 | 12.95 | -129.54 | 154 | 1,994.85 | Dec. 27, 2024: 10 @ 12.95 |
| Feb. 23, 2025 | issue | SO-250223-903 | MAIN | 1 | 12.95 | -12.95 | 164 | 2,124.39 | Dec. 27, 2024: 1 @ 12.95 |
| Feb. 20, 2025 | issue | SO-250220-513 | MAIN | 39 | 12.95 | -505.19 | 165 | 2,137.34 | Dec. 27, 2024: 39 @ 12.95 |
| Feb. 17, 2025 | issue | SO-250217-585 | MAIN | 1 | 12.95 | -12.95 | 204 | 2,642.53 | Dec. 27, 2024: 1 @ 12.95 |
| Feb. 12, 2025 | issue | SO-250212-394 | MAIN | 2 | 12.95 | -25.91 | 205 | 2,655.49 | Dec. 27, 2024: 2 @ 12.95 |
| Jan. 31, 2025 | issue | SO-250131-464 | MAIN | 17 | 12.95 | -220.21 | 207 | 2,681.40 | Dec. 27, 2024: 17 @ 12.95 |
| Jan. 10, 2025 | issue | SO-250110-900 | MAIN | 5 | 12.95 | -64.77 | 224 | 2,901.61 | Dec. 27, 2024: 5 @ 12.95 |
| Jan. 7, 2025 | issue | SO-250107-502 | MAIN | 37 | 12.96 | -479.64 | 229 | 2,966.37 | Oct. 1, 2024: 26 @ 12.97; Dec. 27, 2024: 11 @ 12.95 |
| Dec. 27, 2024 | receipt | PO-000141 | MAIN | 240 | 12.95 | 3,108.86 | 266 | 3,446.02 | |
| Dec. 11, 2024 | issue | SO-241211-632 | MAIN | 99 | 12.97 | -1,283.78 | 26 | 337.16 | Oct. 1, 2024: 99 @ 12.97 |
| Dec. 3, 2024 | issue | SO-241203-521 | MAIN | 17 | 12.97 | -220.45 | 125 | 1,620.94 | Oct. 1, 2024: 17 @ 12.97 |
| Nov. 16, 2024 | issue | SO-241116-933 | MAIN | 31 | 12.97 | -401.99 | 142 | 1,841.38 | Oct. 1, 2024: 31 @ 12.97 |
| Nov. 9, 2024 | issue | SO-241109-177 | MAIN | 17 | 12.97 | -220.45 | 173 | 2,243.38 | Oct. 1, 2024: 17 @ 12.97 |
| Oct. 25, 2024 | issue | SO-241025-957 | MAIN | 15 | 12.97 | -194.51 | 190 | 2,463.82 | Oct. 1, 2024: 15 @ 12.97 |
| Oct. 13, 2024 | issue | SO-241013-771 | MAIN | 3 | 12.97 | -38.90 | 205 | 2,658.34 | Oct. 1, 2024: 3 @ 12.97 |
| Oct. 7, 2024 | issue | SO-241007-671 | MAIN | 6 | 12.97 | -77.80 | 208 | 2,697.24 | Oct. 1, 2024: 6 @ 12.97 |
| Oct. 3, 2024 | issue | SO-241003-818 | MAIN | 26 | 12.97 | -337.16 | 214 | 2,775.04 | Oct. 1, 2024: 26 @ 12.97 |
| Oct. 1, 2024 | receipt | PO-000002 | MAIN | 240 | 12.97 | 3,112.20 | 240 | 3,112.20 | |