Items / CAB-0016
FR Wire 4 sqmm Prime CAB-0016 · Cables & Wires · Conduit & Cable Co
On hand (COIL)15MAIN 15
Value (FIFO)4,313.77avg 287.58
ClassAX / FCV 0.23
Turnover16.1xlast issue 1 days ago
Days of cover23lead time 14d
Reorder suggested: 200 units (position at or below reorder point: order EOQ), stockout risk low.
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.00 / 30.4375 | 0.657 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.62 / 5.517 | 0.837 |
| 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.837^2 + 0.657^2 * 3.1^2) | 7.7 |
| Reorder point | d * LT + safety stock | 0.657 * 14.0 + 7.7 | 16.9 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 16.9 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 240/yr, S = 45.00, h = 20%, price = 265.31 | 200.0 |
| 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 | 288.38 | 19 | 70,280 | yes |
| 100 | 276.84 | 100 | 69,274 | yes |
| 200 | 265.31 | 200 | 68,991 | yes (chosen if cheapest) |
MOQ 50, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Aug. 27, 2026 | 15 / 50 | 287.58 | 4,313.77 |
Movement ledger 126 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-402 | MAIN | 3 | 287.58 | -862.75 | 15 | 4,313.77 | Aug. 27, 2026: 3 @ 287.58 |
| Oct. 10, 2026 | issue | SO-261010-685 | MAIN | 9 | 287.58 | -2,588.26 | 18 | 5,176.52 | Aug. 27, 2026: 9 @ 287.58 |
| Oct. 7, 2026 | issue | SO-261007-547 | MAIN | 12 | 287.58 | -3,451.01 | 27 | 7,764.78 | Aug. 27, 2026: 12 @ 287.58 |
| Sept. 29, 2026 | issue | SO-260929-100 | MAIN | 1 | 287.58 | -287.58 | 39 | 11,215.79 | Aug. 27, 2026: 1 @ 287.58 |
| Sept. 24, 2026 | issue | SO-260924-769 | MAIN | 1 | 287.58 | -287.58 | 40 | 11,503.38 | Aug. 27, 2026: 1 @ 287.58 |
| Sept. 15, 2026 | issue | SO-260915-612 | MAIN | 8 | 287.58 | -2,300.68 | 41 | 11,790.96 | Aug. 27, 2026: 8 @ 287.58 |
| Sept. 8, 2026 | issue | SO-260908-204 | MAIN | 1 | 287.58 | -287.58 | 49 | 14,091.64 | Aug. 27, 2026: 1 @ 287.58 |
| Sept. 6, 2026 | issue | SO-260906-819 | MAIN | 2 | 285.71 | -571.42 | 50 | 14,379.22 | June 16, 2026: 2 @ 285.71 |
| Sept. 1, 2026 | issue | SO-260901-580 | MAIN | 7 | 285.71 | -1,999.97 | 52 | 14,950.64 | June 16, 2026: 7 @ 285.71 |
| Aug. 27, 2026 | receipt | PO-001751 | MAIN | 50 | 287.58 | 14,379.22 | 59 | 16,950.62 | |
| Aug. 20, 2026 | issue | SO-260820-245 | MAIN | 2 | 285.71 | -571.42 | 9 | 2,571.40 | June 16, 2026: 2 @ 285.71 |
| Aug. 16, 2026 | issue | SO-260816-879 | MAIN | 1 | 285.71 | -285.71 | 11 | 3,142.82 | June 16, 2026: 1 @ 285.71 |
| Aug. 15, 2026 | issue | SO-260815-821 | MAIN | 6 | 285.71 | -1,714.26 | 12 | 3,428.53 | June 16, 2026: 6 @ 285.71 |
| Aug. 14, 2026 | issue | SO-260814-663 | MAIN | 1 | 285.71 | -285.71 | 18 | 5,142.79 | June 16, 2026: 1 @ 285.71 |
| Aug. 9, 2026 | issue | SO-260809-159 | MAIN | 2 | 285.71 | -571.42 | 19 | 5,428.50 | June 16, 2026: 2 @ 285.71 |
| Aug. 6, 2026 | issue | SO-260806-166 | MAIN | 2 | 285.71 | -571.42 | 21 | 5,999.92 | June 16, 2026: 2 @ 285.71 |
| Aug. 3, 2026 | issue | SO-260803-641 | MAIN | 1 | 285.71 | -285.71 | 23 | 6,571.35 | June 16, 2026: 1 @ 285.71 |
| July 31, 2026 | issue | SO-260731-744 | MAIN | 2 | 285.71 | -571.42 | 24 | 6,857.06 | June 16, 2026: 2 @ 285.71 |
| July 24, 2026 | issue | SO-260724-642 | MAIN | 6 | 285.71 | -1,714.26 | 26 | 7,428.48 | June 16, 2026: 6 @ 285.71 |
| July 19, 2026 | issue | SO-260719-104 | MAIN | 1 | 285.71 | -285.71 | 32 | 9,142.74 | June 16, 2026: 1 @ 285.71 |
| July 9, 2026 | issue | SO-260709-389 | MAIN | 1 | 285.71 | -285.71 | 33 | 9,428.45 | June 16, 2026: 1 @ 285.71 |
| July 7, 2026 | issue | SO-260707-338 | MAIN | 7 | 285.71 | -1,999.97 | 34 | 9,714.16 | June 16, 2026: 7 @ 285.71 |
| July 4, 2026 | issue | SO-260704-756 | MAIN | 3 | 285.71 | -857.13 | 41 | 11,714.14 | June 16, 2026: 3 @ 285.71 |
| June 30, 2026 | issue | SO-260630-107 | MAIN | 5 | 285.71 | -1,428.55 | 44 | 12,571.27 | June 16, 2026: 5 @ 285.71 |
| June 27, 2026 | issue | SO-260627-209 | MAIN | 1 | 285.71 | -285.71 | 49 | 13,999.82 | June 16, 2026: 1 @ 285.71 |
| June 16, 2026 | receipt | PO-001577 | MAIN | 50 | 285.71 | 14,285.54 | 50 | 14,285.54 | |
| June 15, 2026 | issue | SO-260615-762 | EAST | 2 | 280.48 | -560.95 | 0 | 0.00 | April 5, 2026: 2 @ 280.48 |
| June 15, 2026 | issue | SO-260615-762 | MAIN | 1 | 280.48 | -280.48 | 2 | 560.95 | April 5, 2026: 1 @ 280.48 |
| June 9, 2026 | issue | SO-260609-908 | MAIN | 6 | 280.48 | -1,682.86 | 3 | 841.43 | April 5, 2026: 6 @ 280.48 |
| June 5, 2026 | issue | SO-260605-403 | EAST | 2 | 280.48 | -560.95 | 9 | 2,524.29 | April 5, 2026: 2 @ 280.48 |
| May 31, 2026 | issue | SO-260531-859 | MAIN | 8 | 280.48 | -2,243.81 | 11 | 3,085.24 | April 5, 2026: 8 @ 280.48 |
| May 10, 2026 | issue | SO-260510-527 | EAST | 9 | 280.48 | -2,524.29 | 19 | 5,329.05 | April 5, 2026: 9 @ 280.48 |
| May 5, 2026 | issue | SO-260505-241 | MAIN | 6 | 280.48 | -1,682.86 | 28 | 7,853.33 | April 5, 2026: 6 @ 280.48 |
| April 29, 2026 | issue | SO-260429-585 | MAIN | 4 | 280.48 | -1,121.90 | 34 | 9,536.19 | April 5, 2026: 4 @ 280.48 |
| April 28, 2026 | issue | SO-260428-947 | MAIN | 3 | 280.48 | -841.43 | 38 | 10,658.10 | April 5, 2026: 3 @ 280.48 |
| April 19, 2026 | issue | SO-260419-470 | MAIN | 1 | 280.48 | -280.48 | 41 | 11,499.52 | April 5, 2026: 1 @ 280.48 |
| April 9, 2026 | issue | SO-260409-935 | MAIN | 4 | 280.48 | -1,121.90 | 42 | 11,780.00 | April 5, 2026: 4 @ 280.48 |
| April 6, 2026 | issue | SO-260406-982 | EAST | 4 | 280.48 | -1,121.90 | 46 | 12,901.91 | April 5, 2026: 4 @ 280.48 |
| April 5, 2026 | transfer | TRF | MAIN → EAST | 17 | warehouse transfer, no cost effect | ||||
| April 5, 2026 | receipt | PO-001386 | MAIN | 50 | 280.48 | 14,023.81 | 50 | 14,023.81 | |
| March 28, 2026 | issue | SO-260328-134 | MAIN | 1 | 275.24 | -275.24 | 0 | 0.00 | Dec. 25, 2025: 1 @ 275.24 |
| March 27, 2026 | issue | SO-260327-203 | MAIN | 6 | 275.24 | -1,651.46 | 1 | 275.24 | Dec. 25, 2025: 6 @ 275.24 |
| March 24, 2026 | issue | SO-260324-477 | MAIN | 6 | 275.24 | -1,651.46 | 7 | 1,926.71 | Dec. 25, 2025: 6 @ 275.24 |
| March 21, 2026 | issue | SO-260321-738 | MAIN | 1 | 275.24 | -275.24 | 13 | 3,578.17 | Dec. 25, 2025: 1 @ 275.24 |
| March 19, 2026 | issue | SO-260319-639 | MAIN | 10 | 275.24 | -2,752.44 | 14 | 3,853.41 | Dec. 25, 2025: 10 @ 275.24 |
| March 14, 2026 | issue | SO-260314-334 | MAIN | 1 | 275.24 | -275.24 | 24 | 6,605.85 | Dec. 25, 2025: 1 @ 275.24 |
| Feb. 26, 2026 | issue | SO-260226-912 | MAIN | 1 | 275.24 | -275.24 | 25 | 6,881.10 | Dec. 25, 2025: 1 @ 275.24 |
| Feb. 23, 2026 | issue | SO-260223-335 | MAIN | 2 | 275.24 | -550.49 | 26 | 7,156.34 | Dec. 25, 2025: 2 @ 275.24 |
| Feb. 13, 2026 | issue | SO-260213-188 | MAIN | 7 | 275.24 | -1,926.71 | 28 | 7,706.83 | Dec. 25, 2025: 7 @ 275.24 |
| Feb. 11, 2026 | issue | SO-260211-772 | MAIN | 4 | 275.24 | -1,100.98 | 35 | 9,633.53 | Dec. 25, 2025: 4 @ 275.24 |
| Feb. 9, 2026 | issue | SO-260209-111 | MAIN | 6 | 275.24 | -1,651.46 | 39 | 10,734.51 | Dec. 25, 2025: 6 @ 275.24 |
| Feb. 6, 2026 | issue | SO-260206-190 | MAIN | 1 | 275.24 | -275.24 | 45 | 12,385.97 | Dec. 25, 2025: 1 @ 275.24 |
| Jan. 23, 2026 | issue | SO-260123-385 | MAIN | 13 | 271.54 | -3,529.98 | 46 | 12,661.21 | Nov. 1, 2025: 8 @ 269.89; Nov. 29, 2025: 1 @ 269.89; Dec. 25, 2025: 4 @ 275.24 |
| Jan. 6, 2026 | issue | SO-260106-936 | MAIN | 3 | 269.89 | -809.67 | 59 | 16,191.19 | Nov. 1, 2025: 3 @ 269.89 |
| Dec. 25, 2025 | receipt | PO-001085 | MAIN | 50 | 275.24 | 13,762.19 | 62 | 17,000.86 | |
| Dec. 13, 2025 | issue | SO-251213-709 | MAIN | 23 | 269.89 | -6,207.45 | 12 | 3,238.67 | Nov. 1, 2025: 23 @ 269.89 |
| Dec. 10, 2025 | issue | SO-251210-955 | MAIN | 2 | 269.89 | -539.78 | 35 | 9,446.12 | Nov. 1, 2025: 2 @ 269.89 |
| Nov. 29, 2025 | return | RMA | MAIN | 1 | 269.89 | 269.89 | 37 | 9,985.90 | |
| Nov. 23, 2025 | issue | SO-251123-424 | MAIN | 6 | 269.89 | -1,619.34 | 36 | 9,716.01 | Nov. 1, 2025: 6 @ 269.89 |
| Nov. 22, 2025 | issue | SO-251122-410 | MAIN | 4 | 269.89 | -1,079.56 | 42 | 11,335.35 | Nov. 1, 2025: 4 @ 269.89 |