Items / CAB-0034
FR Wire 2.5 sqmm Classic CAB-0034 · Cables & Wires · Conduit & Cable Co
On hand (COIL)15MAIN 15
Value (FIFO)1,069.60avg 71.31
ClassBX / FCV 0.26
Turnover26.1xlast issue 0 days ago
Days of cover20lead time 14d
Reorder suggested: 50 units (position at or below reorder point: order EOQ), stockout risk medium.
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 | 22.83 / 30.4375 | 0.750 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 6.04 / 5.517 | 1.095 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(14.0 * 1.095^2 + 0.750^2 * 3.1^2) | 7.8 |
| Reorder point | d * LT + safety stock | 0.750 * 14.0 + 7.8 | 18.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 18.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 274/yr, S = 45.00, h = 20%, price = 70.49 | 41.8 |
| Inventory position | on hand + on order | 15 + 0 | 15 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 70.49 | 42 | 19,890 | yes (chosen if cheapest) |
MOQ 50, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 7, 2026 | 15 / 50 | 71.31 | 1,069.60 |
Movement ledger 131 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-994 | MAIN | 2 | 71.31 | -142.61 | 15 | 1,069.60 | Sept. 7, 2026: 2 @ 71.31 |
| Oct. 13, 2026 | issue | SO-261013-197 | MAIN | 11 | 71.31 | -784.38 | 17 | 1,212.22 | Sept. 7, 2026: 11 @ 71.31 |
| Oct. 8, 2026 | issue | SO-261008-800 | MAIN | 7 | 71.31 | -499.15 | 28 | 1,996.59 | Sept. 7, 2026: 7 @ 71.31 |
| Oct. 3, 2026 | issue | SO-261003-384 | MAIN | 12 | 71.31 | -855.68 | 35 | 2,495.74 | Sept. 7, 2026: 12 @ 71.31 |
| Oct. 2, 2026 | issue | SO-261002-994 | MAIN | 2 | 71.31 | -142.61 | 47 | 3,351.42 | Sept. 7, 2026: 2 @ 71.31 |
| Sept. 12, 2026 | issue | SO-260912-341 | MAIN | 1 | 71.31 | -71.31 | 49 | 3,494.04 | Sept. 7, 2026: 1 @ 71.31 |
| Sept. 10, 2026 | issue | SO-260910-737 | MAIN | 8 | 71.65 | -573.17 | 50 | 3,565.34 | July 10, 2026: 8 @ 71.65 |
| Sept. 7, 2026 | receipt | PO-001777 | MAIN | 50 | 71.31 | 3,565.34 | 58 | 4,138.52 | |
| Sept. 6, 2026 | issue | SO-260906-925 | MAIN | 1 | 71.65 | -71.65 | 8 | 573.17 | July 10, 2026: 1 @ 71.65 |
| Sept. 4, 2026 | issue | SO-260904-873 | MAIN | 4 | 71.65 | -286.59 | 9 | 644.82 | July 10, 2026: 4 @ 71.65 |
| Sept. 1, 2026 | issue | SO-260901-774 | MAIN | 1 | 71.65 | -71.65 | 13 | 931.41 | July 10, 2026: 1 @ 71.65 |
| Aug. 26, 2026 | issue | SO-260826-750 | MAIN | 6 | 71.65 | -429.88 | 14 | 1,003.05 | July 10, 2026: 6 @ 71.65 |
| Aug. 23, 2026 | issue | SO-260823-681 | MAIN | 1 | 71.65 | -71.65 | 20 | 1,432.93 | July 10, 2026: 1 @ 71.65 |
| Aug. 22, 2026 | issue | SO-260822-675 | MAIN | 1 | 71.65 | -71.65 | 21 | 1,504.58 | July 10, 2026: 1 @ 71.65 |
| Aug. 19, 2026 | issue | SO-260819-516 | MAIN | 1 | 71.65 | -71.65 | 22 | 1,576.23 | July 10, 2026: 1 @ 71.65 |
| Aug. 17, 2026 | issue | SO-260817-959 | MAIN | 1 | 71.65 | -71.65 | 23 | 1,647.87 | July 10, 2026: 1 @ 71.65 |
| Aug. 16, 2026 | issue | SO-260816-821 | MAIN | 9 | 71.65 | -644.82 | 24 | 1,719.52 | July 10, 2026: 9 @ 71.65 |
| Aug. 12, 2026 | issue | SO-260812-592 | MAIN | 1 | 71.65 | -71.65 | 33 | 2,364.34 | July 10, 2026: 1 @ 71.65 |
| July 28, 2026 | issue | SO-260728-683 | MAIN | 1 | 71.65 | -71.65 | 34 | 2,435.98 | July 10, 2026: 1 @ 71.65 |
| July 25, 2026 | issue | SO-260725-526 | MAIN | 1 | 71.65 | -71.65 | 35 | 2,507.63 | July 10, 2026: 1 @ 71.65 |
| July 20, 2026 | issue | SO-260720-981 | MAIN | 4 | 71.65 | -286.59 | 36 | 2,579.28 | July 10, 2026: 4 @ 71.65 |
| July 15, 2026 | issue | SO-260715-597 | MAIN | 10 | 71.65 | -716.47 | 40 | 2,865.86 | July 10, 2026: 10 @ 71.65 |
| July 10, 2026 | receipt | PO-001638 | MAIN | 50 | 71.65 | 3,582.33 | 50 | 3,582.33 | |
| July 9, 2026 | issue | SO-260709-163 | MAIN | 3 | 69.46 | -208.39 | 0 | 0.00 | April 21, 2026: 3 @ 69.46 |
| June 25, 2026 | issue | SO-260625-387 | MAIN | 5 | 69.46 | -347.32 | 3 | 208.39 | April 21, 2026: 5 @ 69.46 |
| June 24, 2026 | issue | SO-260624-957 | MAIN | 12 | 69.46 | -833.58 | 8 | 555.72 | April 21, 2026: 12 @ 69.46 |
| May 30, 2026 | issue | SO-260530-951 | MAIN | 11 | 69.46 | -764.11 | 20 | 1,389.29 | April 21, 2026: 11 @ 69.46 |
| May 29, 2026 | issue | SO-260529-510 | MAIN | 7 | 69.46 | -486.25 | 31 | 2,153.41 | April 21, 2026: 7 @ 69.46 |
| May 22, 2026 | issue | SO-260522-894 | MAIN | 11 | 69.46 | -764.11 | 38 | 2,639.66 | April 21, 2026: 11 @ 69.46 |
| April 27, 2026 | issue | SO-260427-284 | MAIN | 1 | 69.46 | -69.46 | 49 | 3,403.77 | April 21, 2026: 1 @ 69.46 |
| April 21, 2026 | receipt | PO-001426 | MAIN | 50 | 69.46 | 3,473.24 | 50 | 3,473.24 | |
| April 10, 2026 | issue | SO-260410-460 | MAIN | 4 | 67.09 | -268.37 | 0 | 0.00 | Jan. 27, 2026: 4 @ 67.09 |
| April 6, 2026 | issue | SO-260406-736 | MAIN | 14 | 67.09 | -939.29 | 4 | 268.37 | Jan. 27, 2026: 14 @ 67.09 |
| March 29, 2026 | issue | SO-260329-326 | MAIN | 10 | 67.09 | -670.92 | 18 | 1,207.66 | Jan. 27, 2026: 10 @ 67.09 |
| March 7, 2026 | issue | SO-260307-995 | MAIN | 6 | 67.09 | -402.55 | 28 | 1,878.59 | Jan. 27, 2026: 6 @ 67.09 |
| Feb. 27, 2026 | issue | SO-260227-156 | MAIN | 1 | 67.09 | -67.09 | 34 | 2,281.14 | Jan. 27, 2026: 1 @ 67.09 |
| Feb. 23, 2026 | issue | SO-260223-973 | MAIN | 1 | 67.09 | -67.09 | 35 | 2,348.23 | Jan. 27, 2026: 1 @ 67.09 |
| Feb. 6, 2026 | issue | SO-260206-704 | MAIN | 15 | 67.10 | -1,006.45 | 36 | 2,415.33 | Dec. 8, 2025: 1 @ 67.16; Jan. 27, 2026: 14 @ 67.09 |
| Feb. 2, 2026 | issue | SO-260202-485 | MAIN | 6 | 67.16 | -402.96 | 51 | 3,421.78 | Dec. 8, 2025: 6 @ 67.16 |
| Jan. 27, 2026 | receipt | PO-001179 | MAIN | 50 | 67.09 | 3,354.62 | 57 | 3,824.74 | |
| Jan. 18, 2026 | issue | SO-260118-672 | MAIN | 2 | 67.16 | -134.32 | 7 | 470.12 | Dec. 8, 2025: 2 @ 67.16 |
| Jan. 11, 2026 | issue | SO-260111-132 | MAIN | 22 | 67.16 | -1,477.54 | 9 | 604.45 | Dec. 8, 2025: 22 @ 67.16 |
| Jan. 5, 2026 | issue | SO-260105-260 | MAIN | 2 | 67.16 | -134.32 | 31 | 2,081.98 | Dec. 8, 2025: 2 @ 67.16 |
| Dec. 25, 2025 | issue | SO-251225-553 | MAIN | 10 | 67.16 | -671.61 | 33 | 2,216.30 | Dec. 8, 2025: 10 @ 67.16 |
| Dec. 25, 2025 | issue | SO-251225-553 | EAST | 12 | 66.93 | -803.12 | 43 | 2,887.91 | Oct. 23, 2025: 5 @ 66.60; Dec. 8, 2025: 7 @ 67.16 |
| Dec. 8, 2025 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| Dec. 8, 2025 | receipt | PO-001038 | MAIN | 50 | 67.16 | 3,358.04 | 55 | 3,691.03 | |
| Dec. 7, 2025 | issue | SO-251207-255 | MAIN | 4 | 66.60 | -266.39 | 5 | 332.99 | Oct. 23, 2025: 4 @ 66.60 |
| Nov. 30, 2025 | issue | SO-251130-581 | MAIN | 2 | 66.60 | -133.20 | 9 | 599.38 | Oct. 23, 2025: 2 @ 66.60 |
| Nov. 28, 2025 | issue | SO-251128-518 | MAIN | 3 | 66.60 | -199.79 | 11 | 732.58 | Oct. 23, 2025: 3 @ 66.60 |
| Nov. 21, 2025 | issue | SO-251121-674 | MAIN | 14 | 66.60 | -932.38 | 14 | 932.38 | Oct. 23, 2025: 14 @ 66.60 |
| Nov. 15, 2025 | issue | SO-251115-524 | MAIN | 13 | 66.60 | -865.78 | 28 | 1,864.75 | Oct. 23, 2025: 13 @ 66.60 |
| Nov. 13, 2025 | issue | SO-251113-889 | MAIN | 4 | 66.60 | -266.39 | 41 | 2,730.53 | Oct. 23, 2025: 4 @ 66.60 |
| Oct. 28, 2025 | issue | SO-251028-607 | MAIN | 11 | 67.39 | -741.33 | 45 | 2,996.92 | Aug. 20, 2025: 5 @ 68.06; Oct. 21, 2025: 1 @ 68.06; Oct. 23, 2025: 5 @ 66.60 |
| Oct. 23, 2025 | receipt | PO-000943 | MAIN | 50 | 66.60 | 3,329.92 | 56 | 3,738.25 | |
| Oct. 22, 2025 | issue | SO-251022-509 | MAIN | 2 | 68.06 | -136.11 | 6 | 408.34 | Aug. 20, 2025: 2 @ 68.06 |
| Oct. 21, 2025 | return | RMA | MAIN | 1 | 68.06 | 68.06 | 8 | 544.45 | |
| Oct. 14, 2025 | issue | SO-251014-843 | MAIN | 13 | 68.06 | -884.73 | 7 | 476.39 | Aug. 20, 2025: 13 @ 68.06 |
| Oct. 11, 2025 | issue | SO-251011-260 | MAIN | 2 | 68.06 | -136.11 | 20 | 1,361.12 | Aug. 20, 2025: 2 @ 68.06 |
| Oct. 4, 2025 | issue | SO-251004-518 | MAIN | 1 | 68.06 | -68.06 | 22 | 1,497.23 | Aug. 20, 2025: 1 @ 68.06 |