Items / CAB-0039
FR Wire 1.5 sqmm Lite CAB-0039 · Cables & Wires · Conduit & Cable Co
On hand (COIL)43MAIN 18, EAST 25
Value (FIFO)12,166.02avg 282.93
ClassAX / FCV 0.22
Turnover12.2xlast issue 0 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 | 45.50 / 30.4375 | 1.495 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 10.19 / 5.517 | 1.846 |
| 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.846^2 + 1.495^2 * 3.1^2) | 17.1 |
| Reorder point | d * LT + safety stock | 1.495 * 14.0 + 17.1 | 38.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 38.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 546/yr, S = 45.00, h = 20%, price = 256.17 | 440.0 |
| Inventory position | on hand + on order | 43 + 0 | 43 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 278.45 | 30 | 153,583 | yes |
| 220 | 267.31 | 220 | 151,845 | yes |
| 440 | 256.17 | 440 | 151,103 | yes (chosen if cheapest) |
MOQ 110, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 25, 2026 | 43 / 110 | 282.93 | 12,166.02 |
Movement ledger 122 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-381 | MAIN | 6 | 282.93 | -1,697.58 | 43 | 12,166.02 | Aug. 25, 2026: 6 @ 282.93 |
| Oct. 13, 2026 | issue | SO-261013-546 | MAIN | 8 | 282.93 | -2,263.44 | 49 | 13,863.60 | Aug. 25, 2026: 8 @ 282.93 |
| Oct. 9, 2026 | issue | SO-261009-381 | MAIN | 3 | 282.93 | -848.79 | 57 | 16,127.04 | Aug. 25, 2026: 3 @ 282.93 |
| Oct. 8, 2026 | issue | SO-261008-667 | MAIN | 3 | 282.93 | -848.79 | 60 | 16,975.84 | Aug. 25, 2026: 3 @ 282.93 |
| Oct. 5, 2026 | issue | SO-261005-274 | MAIN | 17 | 282.93 | -4,809.82 | 63 | 17,824.63 | Aug. 25, 2026: 17 @ 282.93 |
| Oct. 1, 2026 | issue | SO-261001-503 | MAIN | 2 | 282.93 | -565.86 | 80 | 22,634.45 | Aug. 25, 2026: 2 @ 282.93 |
| Sept. 27, 2026 | issue | SO-260927-298 | MAIN | 25 | 282.93 | -7,073.26 | 82 | 23,200.31 | Aug. 25, 2026: 25 @ 282.93 |
| Sept. 23, 2026 | issue | SO-260923-331 | MAIN | 8 | 275.32 | -2,202.56 | 107 | 30,273.57 | Aug. 23, 2026: 5 @ 270.75; Aug. 25, 2026: 3 @ 282.93 |
| Sept. 12, 2026 | issue | SO-260912-186 | MAIN | 2 | 270.75 | -541.51 | 115 | 32,476.13 | Aug. 23, 2026: 2 @ 270.75 |
| Aug. 26, 2026 | issue | SO-260826-869 | MAIN | 6 | 270.75 | -1,624.52 | 117 | 33,017.64 | Aug. 23, 2026: 6 @ 270.75 |
| Aug. 25, 2026 | issue | SO-260825-767 | MAIN | 2 | 270.75 | -541.51 | 123 | 34,642.16 | June 28, 2026: 2 @ 270.75 |
| Aug. 25, 2026 | transfer | TRF | MAIN → EAST | 23 | warehouse transfer, no cost effect | ||||
| Aug. 25, 2026 | receipt | PO-001745 | MAIN | 110 | 282.93 | 31,122.37 | 125 | 35,183.67 | |
| Aug. 23, 2026 | return | RMA | MAIN | 13 | 270.75 | 3,519.79 | 15 | 4,061.30 | |
| Aug. 18, 2026 | issue | SO-260818-645 | EAST | 26 | 270.75 | -7,039.59 | 2 | 541.51 | June 28, 2026: 26 @ 270.75 |
| Aug. 18, 2026 | issue | SO-260818-645 | MAIN | 1 | 270.75 | -270.75 | 28 | 7,581.09 | June 28, 2026: 1 @ 270.75 |
| Aug. 16, 2026 | issue | SO-260816-722 | MAIN | 20 | 270.75 | -5,415.07 | 29 | 7,851.85 | June 28, 2026: 20 @ 270.75 |
| Aug. 15, 2026 | issue | SO-260815-828 | MAIN | 22 | 270.75 | -5,956.57 | 49 | 13,266.91 | June 28, 2026: 22 @ 270.75 |
| Aug. 9, 2026 | issue | SO-260809-546 | MAIN | 1 | 270.75 | -270.75 | 71 | 19,223.48 | June 28, 2026: 1 @ 270.75 |
| July 27, 2026 | issue | SO-260727-941 | MAIN | 16 | 270.75 | -4,332.05 | 72 | 19,494.24 | June 28, 2026: 16 @ 270.75 |
| July 24, 2026 | issue | SO-260724-483 | MAIN | 1 | 270.75 | -270.75 | 88 | 23,826.29 | June 28, 2026: 1 @ 270.75 |
| July 21, 2026 | issue | SO-260721-740 | MAIN | 2 | 270.75 | -541.51 | 89 | 24,097.04 | June 28, 2026: 2 @ 270.75 |
| July 18, 2026 | issue | SO-260718-867 | EAST | 6 | 270.75 | -1,624.52 | 91 | 24,638.55 | June 28, 2026: 6 @ 270.75 |
| July 16, 2026 | issue | SO-260716-404 | MAIN | 9 | 270.75 | -2,436.78 | 97 | 26,263.07 | June 28, 2026: 9 @ 270.75 |
| July 4, 2026 | issue | SO-260704-153 | MAIN | 4 | 270.75 | -1,083.01 | 106 | 28,699.85 | June 28, 2026: 4 @ 270.75 |
| July 1, 2026 | issue | SO-260701-150 | MAIN | 10 | 267.91 | -2,679.10 | 110 | 29,782.86 | April 17, 2026: 7 @ 267.91; April 23, 2026: 2 @ 267.91; April 29, 2026: 1 @ 267.91 |
| June 28, 2026 | transfer | TRF | MAIN → EAST | 34 | warehouse transfer, no cost effect | ||||
| June 28, 2026 | receipt | PO-001607 | MAIN | 110 | 270.75 | 29,782.86 | 120 | 32,461.96 | |
| June 19, 2026 | issue | SO-260619-572 | MAIN | 18 | 267.91 | -4,822.38 | 10 | 2,679.10 | April 17, 2026: 18 @ 267.91 |
| June 12, 2026 | issue | SO-260612-292 | MAIN | 5 | 267.91 | -1,339.55 | 28 | 7,501.48 | April 17, 2026: 5 @ 267.91 |
| June 11, 2026 | issue | SO-260611-782 | MAIN | 5 | 267.91 | -1,339.55 | 33 | 8,841.03 | April 17, 2026: 5 @ 267.91 |
| June 9, 2026 | issue | SO-260609-193 | MAIN | 6 | 267.91 | -1,607.46 | 38 | 10,180.58 | April 17, 2026: 6 @ 267.91 |
| June 4, 2026 | issue | SO-260604-164 | MAIN | 1 | 267.91 | -267.91 | 44 | 11,788.04 | April 17, 2026: 1 @ 267.91 |
| May 24, 2026 | issue | SO-260524-132 | MAIN | 13 | 267.91 | -3,482.83 | 45 | 12,055.95 | April 17, 2026: 13 @ 267.91 |
| May 13, 2026 | issue | SO-260513-800 | MAIN | 4 | 267.91 | -1,071.64 | 58 | 15,538.77 | April 17, 2026: 4 @ 267.91 |
| May 4, 2026 | issue | SO-260504-654 | MAIN | 5 | 267.91 | -1,339.55 | 62 | 16,610.41 | April 17, 2026: 5 @ 267.91 |
| May 3, 2026 | issue | SO-260503-981 | MAIN | 13 | 267.91 | -3,482.83 | 67 | 17,949.96 | April 17, 2026: 13 @ 267.91 |
| May 2, 2026 | issue | SO-260502-939 | MAIN | 15 | 267.91 | -4,018.65 | 80 | 21,432.79 | April 17, 2026: 15 @ 267.91 |
| May 1, 2026 | issue | SO-260501-593 | MAIN | 17 | 267.91 | -4,554.47 | 95 | 25,451.44 | April 17, 2026: 17 @ 267.91 |
| April 29, 2026 | return | RMA | MAIN | 1 | 267.91 | 267.91 | 112 | 30,005.91 | |
| April 23, 2026 | return | RMA | MAIN | 2 | 267.91 | 535.82 | 111 | 29,738.00 | |
| April 23, 2026 | issue | SO-260423-190 | MAIN | 1 | 267.91 | -267.91 | 109 | 29,202.18 | April 17, 2026: 1 @ 267.91 |
| April 23, 2026 | issue | SO-260423-190 | EAST | 2 | 271.04 | -542.08 | 110 | 29,470.09 | Feb. 13, 2026: 2 @ 271.04 |
| April 17, 2026 | receipt | PO-001415 | MAIN | 110 | 267.91 | 29,470.09 | 112 | 30,012.17 | |
| April 15, 2026 | issue | SO-260415-764 | EAST | 1 | 271.04 | -271.04 | 2 | 542.08 | Feb. 13, 2026: 1 @ 271.04 |
| April 12, 2026 | issue | SO-260412-983 | EAST | 4 | 271.04 | -1,084.17 | 3 | 813.13 | Feb. 13, 2026: 4 @ 271.04 |
| April 9, 2026 | issue | SO-260409-830 | EAST | 22 | 271.04 | -5,962.92 | 7 | 1,897.29 | Feb. 13, 2026: 22 @ 271.04 |
| April 9, 2026 | issue | SO-260409-830 | MAIN | 5 | 271.04 | -1,355.21 | 29 | 7,860.21 | Feb. 13, 2026: 5 @ 271.04 |
| April 4, 2026 | issue | SO-260404-447 | MAIN | 6 | 271.04 | -1,626.25 | 34 | 9,215.42 | Feb. 13, 2026: 6 @ 271.04 |
| March 28, 2026 | issue | SO-260328-111 | MAIN | 1 | 271.04 | -271.04 | 40 | 10,841.67 | Feb. 13, 2026: 1 @ 271.04 |
| March 14, 2026 | issue | SO-260314-439 | MAIN | 44 | 271.04 | -11,925.84 | 41 | 11,112.71 | Feb. 13, 2026: 44 @ 271.04 |
| March 8, 2026 | issue | SO-260308-333 | MAIN | 4 | 271.04 | -1,084.17 | 85 | 23,038.55 | Feb. 13, 2026: 4 @ 271.04 |
| Feb. 27, 2026 | issue | SO-260227-723 | MAIN | 24 | 270.23 | -6,485.43 | 89 | 24,122.72 | Nov. 24, 2025: 3 @ 264.52; Feb. 13, 2026: 21 @ 271.04 |
| Feb. 24, 2026 | issue | SO-260224-129 | MAIN | 4 | 264.52 | -1,058.08 | 113 | 30,608.15 | Nov. 24, 2025: 4 @ 264.52 |
| Feb. 13, 2026 | transfer | TRF | MAIN → EAST | 29 | warehouse transfer, no cost effect | ||||
| Feb. 13, 2026 | receipt | PO-001224 | MAIN | 110 | 271.04 | 29,814.60 | 117 | 31,666.23 | |
| Feb. 10, 2026 | issue | SO-260210-347 | MAIN | 11 | 264.52 | -2,909.71 | 7 | 1,851.63 | Nov. 24, 2025: 11 @ 264.52 |
| Feb. 4, 2026 | issue | SO-260204-383 | MAIN | 3 | 264.52 | -793.56 | 18 | 4,761.34 | Nov. 24, 2025: 3 @ 264.52 |
| Jan. 26, 2026 | issue | SO-260126-935 | MAIN | 21 | 264.52 | -5,554.90 | 21 | 5,554.90 | Nov. 24, 2025: 21 @ 264.52 |
| Jan. 23, 2026 | issue | SO-260123-824 | MAIN | 11 | 264.52 | -2,909.71 | 42 | 11,109.79 | Nov. 24, 2025: 11 @ 264.52 |