Items / CAB-0006
FR Wire 1.0 sqmm Pro CAB-0006 · Cables & Wires · Conduit & Cable Co
On hand (COIL)51MAIN 51
Value (FIFO)7,192.15avg 141.02
ClassAX / FCV 0.19
Turnover13.1xlast issue 8 days ago
Days of cover31lead 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 | 50.25 / 30.4375 | 1.651 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 9.44 / 5.517 | 1.712 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.980) | 2.054 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 2.054 * sqrt(14.0 * 1.712^2 + 1.651^2 * 3.1^2) | 16.9 |
| Reorder point | d * LT + safety stock | 1.651 * 14.0 + 16.9 | 40.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 40.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 603/yr, S = 45.00, h = 20%, price = 138.63 | 44.2 |
| Inventory position | on hand + on order | 51 + 0 | 51 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 138.63 | 44 | 84,763 | yes (chosen if cheapest) |
MOQ 110, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 21, 2026 | 51 / 110 | 141.02 | 7,192.15 |
Movement ledger 129 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 8, 2026 | issue | SO-261008-529 | MAIN | 18 | 141.02 | -2,538.40 | 51 | 7,192.15 | Sept. 21, 2026: 18 @ 141.02 |
| Oct. 8, 2026 | issue | SO-261008-529 | EAST | 24 | 141.02 | -3,384.54 | 69 | 9,730.55 | Sept. 21, 2026: 24 @ 141.02 |
| Oct. 3, 2026 | issue | SO-261003-613 | MAIN | 20 | 140.96 | -2,819.12 | 93 | 13,115.09 | June 30, 2026: 3 @ 140.58; Sept. 21, 2026: 17 @ 141.02 |
| Sept. 25, 2026 | issue | SO-260925-284 | MAIN | 5 | 140.58 | -702.89 | 113 | 15,934.21 | June 30, 2026: 5 @ 140.58 |
| Sept. 22, 2026 | issue | SO-260922-971 | MAIN | 9 | 140.58 | -1,265.20 | 118 | 16,637.10 | June 30, 2026: 9 @ 140.58 |
| Sept. 21, 2026 | transfer | TRF | MAIN → EAST | 24 | warehouse transfer, no cost effect | ||||
| Sept. 21, 2026 | receipt | PO-001816 | MAIN | 110 | 141.02 | 15,512.48 | 127 | 17,902.29 | |
| Sept. 19, 2026 | issue | SO-260919-736 | MAIN | 4 | 140.58 | -562.31 | 17 | 2,389.82 | June 30, 2026: 4 @ 140.58 |
| Sept. 14, 2026 | issue | SO-260914-577 | MAIN | 6 | 140.58 | -843.46 | 21 | 2,952.13 | June 30, 2026: 6 @ 140.58 |
| Sept. 11, 2026 | issue | SO-260911-610 | MAIN | 2 | 140.58 | -281.16 | 27 | 3,795.59 | June 30, 2026: 2 @ 140.58 |
| Sept. 8, 2026 | issue | SO-260908-647 | MAIN | 3 | 140.58 | -421.73 | 29 | 4,076.75 | June 30, 2026: 3 @ 140.58 |
| Sept. 5, 2026 | issue | SO-260905-490 | MAIN | 6 | 140.58 | -843.46 | 32 | 4,498.48 | June 30, 2026: 6 @ 140.58 |
| Aug. 24, 2026 | issue | SO-260824-291 | MAIN | 34 | 140.58 | -4,779.64 | 38 | 5,341.94 | June 30, 2026: 34 @ 140.58 |
| Aug. 11, 2026 | issue | SO-260811-635 | MAIN | 27 | 140.58 | -3,795.59 | 72 | 10,121.58 | June 30, 2026: 27 @ 140.58 |
| July 31, 2026 | issue | SO-260731-563 | MAIN | 20 | 137.87 | -2,757.32 | 99 | 13,917.17 | May 5, 2026: 8 @ 134.55; June 21, 2026: 1 @ 134.55; June 30, 2026: 11 @ 140.58 |
| July 16, 2026 | issue | SO-260716-622 | MAIN | 1 | 134.55 | -134.55 | 119 | 16,674.50 | May 5, 2026: 1 @ 134.55 |
| July 12, 2026 | issue | SO-260712-115 | MAIN | 2 | 134.55 | -269.10 | 120 | 16,809.05 | May 5, 2026: 2 @ 134.55 |
| July 11, 2026 | issue | SO-260711-445 | MAIN | 12 | 134.55 | -1,614.63 | 122 | 17,078.15 | May 5, 2026: 12 @ 134.55 |
| July 6, 2026 | issue | SO-260706-695 | MAIN | 11 | 134.55 | -1,480.08 | 134 | 18,692.78 | May 5, 2026: 11 @ 134.55 |
| June 30, 2026 | receipt | PO-001611 | MAIN | 110 | 140.58 | 15,463.52 | 145 | 20,172.86 | |
| June 21, 2026 | return | RMA | MAIN | 1 | 134.55 | 134.55 | 35 | 4,709.33 | |
| June 9, 2026 | issue | SO-260609-687 | MAIN | 31 | 134.55 | -4,171.12 | 34 | 4,574.78 | May 5, 2026: 31 @ 134.55 |
| June 4, 2026 | issue | SO-260604-506 | MAIN | 7 | 134.55 | -941.87 | 65 | 8,745.90 | May 5, 2026: 7 @ 134.55 |
| June 2, 2026 | issue | SO-260602-623 | MAIN | 3 | 134.55 | -403.66 | 72 | 9,687.77 | May 5, 2026: 3 @ 134.55 |
| June 2, 2026 | issue | SO-260602-623 | EAST | 9 | 134.55 | -1,210.97 | 75 | 10,091.42 | May 5, 2026: 9 @ 134.55 |
| May 28, 2026 | issue | SO-260528-697 | MAIN | 40 | 133.73 | -5,349.08 | 84 | 11,302.39 | Feb. 15, 2026: 14 @ 132.19; May 5, 2026: 26 @ 134.55 |
| May 24, 2026 | issue | SO-260524-838 | EAST | 2 | 132.19 | -264.39 | 124 | 16,651.47 | Feb. 15, 2026: 2 @ 132.19 |
| May 23, 2026 | issue | SO-260523-141 | EAST | 4 | 132.19 | -528.78 | 126 | 16,915.86 | Feb. 15, 2026: 4 @ 132.19 |
| May 14, 2026 | issue | SO-260514-133 | MAIN | 2 | 132.19 | -264.39 | 130 | 17,444.64 | Feb. 15, 2026: 2 @ 132.19 |
| May 6, 2026 | issue | SO-260506-772 | MAIN | 1 | 132.19 | -132.19 | 132 | 17,709.03 | Feb. 15, 2026: 1 @ 132.19 |
| May 5, 2026 | receipt | PO-001465 | MAIN | 110 | 134.55 | 14,800.75 | 133 | 17,841.22 | |
| April 22, 2026 | issue | SO-260422-858 | MAIN | 22 | 132.19 | -2,908.28 | 23 | 3,040.47 | Feb. 15, 2026: 22 @ 132.19 |
| April 5, 2026 | issue | SO-260405-999 | MAIN | 21 | 132.19 | -2,776.08 | 45 | 5,948.75 | Feb. 15, 2026: 21 @ 132.19 |
| April 3, 2026 | issue | SO-260403-142 | MAIN | 3 | 132.19 | -396.58 | 66 | 8,724.83 | Feb. 15, 2026: 3 @ 132.19 |
| March 19, 2026 | issue | SO-260319-844 | MAIN | 35 | 132.19 | -4,626.80 | 69 | 9,121.41 | Feb. 15, 2026: 35 @ 132.19 |
| March 1, 2026 | issue | SO-260301-475 | MAIN | 17 | 132.49 | -2,252.40 | 104 | 13,748.22 | Jan. 10, 2026: 11 @ 132.66; Feb. 15, 2026: 6 @ 132.19 |
| Feb. 21, 2026 | issue | SO-260221-452 | EAST | 18 | 132.66 | -2,387.84 | 121 | 16,000.62 | Jan. 10, 2026: 18 @ 132.66 |
| Feb. 15, 2026 | transfer | TRF | MAIN → EAST | 31 | warehouse transfer, no cost effect | ||||
| Feb. 15, 2026 | receipt | PO-001231 | MAIN | 110 | 132.19 | 14,541.38 | 139 | 18,388.45 | |
| Feb. 12, 2026 | issue | SO-260212-673 | EAST | 1 | 132.66 | -132.66 | 29 | 3,847.07 | Jan. 10, 2026: 1 @ 132.66 |
| Feb. 9, 2026 | issue | SO-260209-272 | MAIN | 5 | 132.66 | -663.29 | 30 | 3,979.73 | Jan. 10, 2026: 5 @ 132.66 |
| Feb. 4, 2026 | issue | SO-260204-937 | MAIN | 37 | 132.66 | -4,908.33 | 35 | 4,643.02 | Jan. 10, 2026: 37 @ 132.66 |
| Jan. 26, 2026 | issue | SO-260126-413 | MAIN | 11 | 132.66 | -1,459.23 | 72 | 9,551.35 | Jan. 10, 2026: 11 @ 132.66 |
| Jan. 12, 2026 | issue | SO-260112-827 | EAST | 45 | 132.76 | -5,974.22 | 83 | 11,010.58 | Nov. 13, 2025: 18 @ 132.91; Jan. 10, 2026: 27 @ 132.66 |
| Jan. 10, 2026 | transfer | TRF | MAIN → EAST | 30 | warehouse transfer, no cost effect | ||||
| Jan. 10, 2026 | receipt | PO-001134 | MAIN | 110 | 132.66 | 14,592.34 | 128 | 16,984.80 | |
| Dec. 29, 2025 | issue | SO-251229-675 | EAST | 9 | 132.91 | -1,196.23 | 18 | 2,392.46 | Nov. 13, 2025: 9 @ 132.91 |
| Dec. 29, 2025 | issue | SO-251229-675 | MAIN | 13 | 132.91 | -1,727.89 | 27 | 3,588.70 | Nov. 13, 2025: 13 @ 132.91 |
| Dec. 14, 2025 | issue | SO-251214-413 | MAIN | 2 | 132.91 | -265.83 | 40 | 5,316.59 | Nov. 13, 2025: 2 @ 132.91 |
| Dec. 10, 2025 | issue | SO-251210-260 | MAIN | 9 | 132.91 | -1,196.23 | 42 | 5,582.42 | Nov. 13, 2025: 9 @ 132.91 |
| Dec. 9, 2025 | issue | SO-251209-125 | MAIN | 9 | 132.91 | -1,196.23 | 51 | 6,778.65 | Nov. 13, 2025: 9 @ 132.91 |
| Dec. 3, 2025 | issue | SO-251203-823 | MAIN | 18 | 132.91 | -2,392.46 | 60 | 7,974.88 | Nov. 13, 2025: 18 @ 132.91 |
| Dec. 2, 2025 | issue | SO-251202-629 | MAIN | 2 | 132.91 | -265.83 | 78 | 10,367.35 | Nov. 13, 2025: 2 @ 132.91 |
| Nov. 25, 2025 | issue | SO-251125-430 | EAST | 1 | 132.91 | -132.91 | 80 | 10,633.18 | Nov. 13, 2025: 1 @ 132.91 |
| Nov. 24, 2025 | issue | SO-251124-772 | MAIN | 1 | 132.91 | -132.91 | 81 | 10,766.09 | Nov. 13, 2025: 1 @ 132.91 |
| Nov. 23, 2025 | issue | SO-251123-983 | MAIN | 18 | 132.91 | -2,392.46 | 82 | 10,899.01 | Nov. 13, 2025: 18 @ 132.91 |
| Nov. 15, 2025 | issue | SO-251115-961 | MAIN | 10 | 132.91 | -1,329.15 | 100 | 13,291.47 | Nov. 13, 2025: 10 @ 132.91 |
| Nov. 13, 2025 | transfer | TRF | MAIN → EAST | 28 | warehouse transfer, no cost effect | ||||
| Nov. 13, 2025 | receipt | PO-000997 | MAIN | 110 | 132.91 | 14,620.62 | 110 | 14,620.62 | |
| Nov. 2, 2025 | issue | SO-251102-187 | EAST | 1 | 134.46 | -134.46 | 0 | 0.00 | Aug. 21, 2025: 1 @ 134.46 |