Items / CAB-0013
FR Wire 1.5 sqmm Elite CAB-0013 · Cables & Wires · Conduit & Cable Co
On hand (COIL)20MAIN 20
Value (FIFO)2,702.05avg 135.10
ClassAX / FCV 0.19
Turnover11.8xlast issue 1 days ago
Days of cover29lead 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 | 20.83 / 30.4375 | 0.684 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 3.87 / 5.517 | 0.701 |
| 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 * 0.701^2 + 0.684^2 * 3.1^2) | 6.9 |
| Reorder point | d * LT + safety stock | 0.684 * 14.0 + 6.9 | 16.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 250/yr, S = 45.00, h = 20%, price = 132.68 | 29.1 |
| Inventory position | on hand + on order | 20 + 0 | 20 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 132.68 | 29 | 33,920 | yes (chosen if cheapest) |
MOQ 50, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 1, 2026 | 20 / 50 | 135.10 | 2,702.05 |
Movement ledger 133 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 15, 2026 | issue | SO-261015-144 | MAIN | 8 | 135.10 | -1,080.82 | 20 | 2,702.05 | Sept. 1, 2026: 8 @ 135.10 |
| Oct. 14, 2026 | issue | SO-261014-970 | MAIN | 4 | 135.10 | -540.41 | 28 | 3,782.87 | Sept. 1, 2026: 4 @ 135.10 |
| Oct. 8, 2026 | issue | SO-261008-776 | MAIN | 2 | 135.10 | -270.20 | 32 | 4,323.28 | Sept. 1, 2026: 2 @ 135.10 |
| Sept. 30, 2026 | issue | SO-260930-247 | MAIN | 1 | 135.10 | -135.10 | 34 | 4,593.48 | Sept. 1, 2026: 1 @ 135.10 |
| Sept. 11, 2026 | issue | SO-260911-475 | MAIN | 9 | 135.10 | -1,215.92 | 35 | 4,728.59 | Sept. 1, 2026: 9 @ 135.10 |
| Sept. 7, 2026 | issue | SO-260907-723 | MAIN | 1 | 135.10 | -135.10 | 44 | 5,944.51 | Sept. 1, 2026: 1 @ 135.10 |
| Sept. 6, 2026 | issue | SO-260906-733 | MAIN | 1 | 135.10 | -135.10 | 45 | 6,079.61 | Sept. 1, 2026: 1 @ 135.10 |
| Sept. 4, 2026 | issue | SO-260904-945 | MAIN | 3 | 135.10 | -405.31 | 46 | 6,214.72 | Sept. 1, 2026: 3 @ 135.10 |
| Sept. 2, 2026 | issue | SO-260902-180 | MAIN | 1 | 135.10 | -135.10 | 49 | 6,620.02 | Sept. 1, 2026: 1 @ 135.10 |
| Sept. 1, 2026 | receipt | PO-001764 | MAIN | 50 | 135.10 | 6,755.12 | 50 | 6,755.12 | |
| Aug. 22, 2026 | issue | SO-260822-195 | MAIN | 2 | 128.83 | -257.66 | 0 | 0.00 | June 14, 2026: 2 @ 128.83 |
| Aug. 22, 2026 | issue | SO-260822-195 | EAST | 3 | 128.83 | -386.48 | 2 | 257.66 | June 14, 2026: 3 @ 128.83 |
| Aug. 19, 2026 | issue | SO-260819-784 | MAIN | 10 | 128.83 | -1,288.28 | 5 | 644.14 | June 14, 2026: 10 @ 128.83 |
| Aug. 14, 2026 | issue | SO-260814-261 | MAIN | 4 | 128.83 | -515.31 | 15 | 1,932.42 | June 14, 2026: 4 @ 128.83 |
| July 31, 2026 | issue | SO-260731-438 | MAIN | 7 | 128.83 | -901.80 | 19 | 2,447.74 | June 14, 2026: 7 @ 128.83 |
| July 30, 2026 | issue | SO-260730-184 | MAIN | 1 | 128.83 | -128.83 | 26 | 3,349.54 | June 14, 2026: 1 @ 128.83 |
| July 22, 2026 | issue | SO-260722-265 | MAIN | 1 | 128.83 | -128.83 | 27 | 3,478.36 | June 14, 2026: 1 @ 128.83 |
| July 20, 2026 | issue | SO-260720-313 | MAIN | 6 | 128.83 | -772.97 | 28 | 3,607.19 | June 14, 2026: 6 @ 128.83 |
| July 1, 2026 | issue | SO-260701-785 | MAIN | 9 | 128.83 | -1,159.45 | 34 | 4,380.16 | June 14, 2026: 9 @ 128.83 |
| June 30, 2026 | issue | SO-260630-725 | MAIN | 7 | 128.83 | -901.80 | 43 | 5,539.62 | June 14, 2026: 7 @ 128.83 |
| June 27, 2026 | issue | SO-260627-207 | EAST | 3 | 129.77 | -389.30 | 50 | 6,441.42 | March 22, 2026: 2 @ 130.38; April 17, 2026: 1 @ 128.55 |
| June 26, 2026 | issue | SO-260626-553 | MAIN | 1 | 130.38 | -130.38 | 53 | 6,830.72 | March 22, 2026: 1 @ 130.38 |
| June 22, 2026 | issue | SO-260622-720 | EAST | 6 | 130.38 | -782.25 | 54 | 6,961.09 | March 22, 2026: 6 @ 130.38 |
| June 14, 2026 | transfer | TRF | MAIN → EAST | 12 | warehouse transfer, no cost effect | ||||
| June 14, 2026 | receipt | PO-001571 | MAIN | 50 | 128.83 | 6,441.42 | 60 | 7,743.34 | |
| June 13, 2026 | issue | SO-260613-781 | MAIN | 2 | 130.38 | -260.75 | 10 | 1,301.93 | March 22, 2026: 2 @ 130.38 |
| May 31, 2026 | issue | SO-260531-733 | MAIN | 2 | 130.38 | -260.75 | 12 | 1,562.68 | March 22, 2026: 2 @ 130.38 |
| May 30, 2026 | issue | SO-260530-739 | MAIN | 18 | 130.38 | -2,346.75 | 14 | 1,823.43 | March 22, 2026: 18 @ 130.38 |
| May 23, 2026 | issue | SO-260523-224 | MAIN | 1 | 130.38 | -130.38 | 32 | 4,170.18 | March 22, 2026: 1 @ 130.38 |
| April 20, 2026 | issue | SO-260420-343 | MAIN | 1 | 130.38 | -130.38 | 33 | 4,300.55 | March 22, 2026: 1 @ 130.38 |
| April 19, 2026 | issue | SO-260419-652 | MAIN | 2 | 130.38 | -260.75 | 34 | 4,430.93 | March 22, 2026: 2 @ 130.38 |
| April 18, 2026 | issue | SO-260418-146 | MAIN | 17 | 130.16 | -2,212.73 | 36 | 4,691.68 | Feb. 5, 2026: 2 @ 128.55; March 22, 2026: 15 @ 130.38 |
| April 17, 2026 | return | RMA | MAIN | 1 | 128.55 | 128.55 | 53 | 6,904.41 | |
| April 17, 2026 | issue | SO-260417-519 | MAIN | 1 | 128.55 | -128.55 | 52 | 6,775.86 | Feb. 5, 2026: 1 @ 128.55 |
| April 8, 2026 | issue | SO-260408-495 | MAIN | 2 | 128.55 | -257.10 | 53 | 6,904.41 | Feb. 5, 2026: 2 @ 128.55 |
| April 2, 2026 | issue | SO-260402-513 | MAIN | 1 | 128.55 | -128.55 | 55 | 7,161.51 | Feb. 5, 2026: 1 @ 128.55 |
| March 22, 2026 | receipt | PO-001342 | MAIN | 50 | 130.38 | 6,518.76 | 56 | 7,290.06 | |
| March 21, 2026 | issue | SO-260321-816 | MAIN | 2 | 128.55 | -257.10 | 6 | 771.30 | Feb. 5, 2026: 2 @ 128.55 |
| March 5, 2026 | issue | SO-260305-819 | MAIN | 16 | 128.55 | -2,056.81 | 8 | 1,028.41 | Feb. 5, 2026: 16 @ 128.55 |
| Feb. 24, 2026 | issue | SO-260224-798 | EAST | 2 | 128.55 | -257.10 | 24 | 3,085.22 | Feb. 5, 2026: 2 @ 128.55 |
| Feb. 18, 2026 | issue | SO-260218-898 | MAIN | 9 | 128.55 | -1,156.96 | 26 | 3,342.32 | Feb. 5, 2026: 9 @ 128.55 |
| Feb. 9, 2026 | issue | SO-260209-197 | MAIN | 10 | 128.55 | -1,285.51 | 35 | 4,499.27 | Feb. 5, 2026: 10 @ 128.55 |
| Feb. 8, 2026 | issue | SO-260208-927 | MAIN | 2 | 128.55 | -257.10 | 45 | 5,784.78 | Feb. 5, 2026: 2 @ 128.55 |
| Feb. 7, 2026 | issue | SO-260207-546 | MAIN | 5 | 128.64 | -643.18 | 47 | 6,041.88 | Nov. 2, 2025: 2 @ 128.77; Feb. 5, 2026: 3 @ 128.55 |
| Feb. 5, 2026 | receipt | PO-001198 | MAIN | 50 | 128.55 | 6,427.54 | 52 | 6,685.07 | |
| Jan. 28, 2026 | issue | SO-260128-735 | EAST | 3 | 128.77 | -386.30 | 2 | 257.53 | Nov. 2, 2025: 3 @ 128.77 |
| Jan. 23, 2026 | issue | SO-260123-687 | EAST | 3 | 128.77 | -386.30 | 5 | 643.83 | Nov. 2, 2025: 3 @ 128.77 |
| Jan. 23, 2026 | issue | SO-260123-687 | MAIN | 7 | 128.77 | -901.36 | 8 | 1,030.12 | Nov. 2, 2025: 7 @ 128.77 |
| Jan. 12, 2026 | issue | SO-260112-234 | MAIN | 5 | 128.77 | -643.83 | 15 | 1,931.48 | Nov. 2, 2025: 5 @ 128.77 |
| Jan. 3, 2026 | issue | SO-260103-173 | EAST | 2 | 128.77 | -257.53 | 20 | 2,575.30 | Nov. 2, 2025: 2 @ 128.77 |
| Dec. 29, 2025 | issue | SO-251229-594 | MAIN | 1 | 128.77 | -128.77 | 22 | 2,832.83 | Nov. 2, 2025: 1 @ 128.77 |
| Dec. 27, 2025 | issue | SO-251227-161 | MAIN | 1 | 128.77 | -128.77 | 23 | 2,961.60 | Nov. 2, 2025: 1 @ 128.77 |
| Dec. 23, 2025 | issue | SO-251223-288 | EAST | 3 | 128.77 | -386.30 | 24 | 3,090.36 | Nov. 2, 2025: 3 @ 128.77 |
| Dec. 15, 2025 | issue | SO-251215-682 | MAIN | 1 | 128.77 | -128.77 | 27 | 3,476.66 | Nov. 2, 2025: 1 @ 128.77 |
| Dec. 10, 2025 | issue | SO-251210-541 | EAST | 4 | 128.77 | -515.06 | 28 | 3,605.43 | Nov. 2, 2025: 4 @ 128.77 |
| Dec. 8, 2025 | issue | SO-251208-462 | MAIN | 3 | 128.77 | -386.30 | 32 | 4,120.49 | Nov. 2, 2025: 3 @ 128.77 |
| Dec. 6, 2025 | issue | SO-251206-969 | EAST | 1 | 128.77 | -128.77 | 35 | 4,506.78 | Nov. 2, 2025: 1 @ 128.77 |
| Nov. 22, 2025 | issue | SO-251122-376 | EAST | 1 | 128.77 | -128.77 | 36 | 4,635.55 | Nov. 2, 2025: 1 @ 128.77 |
| Nov. 14, 2025 | issue | SO-251114-202 | MAIN | 13 | 128.77 | -1,673.95 | 37 | 4,764.31 | Nov. 2, 2025: 13 @ 128.77 |
| Nov. 9, 2025 | issue | SO-251109-246 | EAST | 4 | 125.24 | -500.94 | 50 | 6,438.26 | Aug. 30, 2025: 1 @ 125.71; Sept. 4, 2025: 3 @ 125.08 |