Items / CAB-0007
FR Wire 1.0 sqmm Max CAB-0007 · Cables & Wires · Conduit & Cable Co
On hand (COIL)35MAIN 35
Value (FIFO)1,396.98avg 39.91
ClassCX / FCV 0.24
Turnover7.3xlast issue 1 days ago
Days of cover57lead 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 | 18.67 / 30.4375 | 0.613 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.44 / 5.517 | 0.805 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.900) | 1.282 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.282 * sqrt(14.0 * 0.805^2 + 0.613^2 * 3.1^2) | 4.6 |
| Reorder point | d * LT + safety stock | 0.613 * 14.0 + 4.6 | 13.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 13.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 224/yr, S = 45.00, h = 20%, price = 37.27 | 160.0 |
| Inventory position | on hand + on order | 35 + 0 | 35 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 40.51 | 50 | 9,472 | yes |
| 80 | 38.89 | 80 | 9,142 | yes |
| 160 | 37.27 | 160 | 9,002 | yes (chosen if cheapest) |
MOQ 40, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 11, 2026 | 35 / 40 | 39.91 | 1,396.98 |
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. 15, 2026 | issue | SO-261015-321 | MAIN | 7 | 40.31 | -282.19 | 35 | 1,396.98 | Aug. 11, 2026: 2 @ 41.31; Oct. 11, 2026: 5 @ 39.91 |
| Oct. 14, 2026 | issue | SO-261014-503 | MAIN | 1 | 41.31 | -41.31 | 42 | 1,679.17 | Aug. 11, 2026: 1 @ 41.31 |
| Oct. 13, 2026 | issue | SO-261013-188 | MAIN | 1 | 41.31 | -41.31 | 43 | 1,720.48 | Aug. 11, 2026: 1 @ 41.31 |
| Oct. 12, 2026 | issue | SO-261012-750 | MAIN | 1 | 41.31 | -41.31 | 44 | 1,761.79 | Aug. 11, 2026: 1 @ 41.31 |
| Oct. 11, 2026 | receipt | PO-001869 | MAIN | 40 | 39.91 | 1,596.55 | 45 | 1,803.09 | |
| Oct. 10, 2026 | issue | SO-261010-742 | MAIN | 4 | 41.31 | -165.23 | 5 | 206.54 | Aug. 11, 2026: 4 @ 41.31 |
| Oct. 6, 2026 | issue | SO-261006-278 | MAIN | 2 | 41.31 | -82.62 | 9 | 371.78 | Aug. 11, 2026: 2 @ 41.31 |
| Sept. 29, 2026 | issue | SO-260929-439 | MAIN | 4 | 41.31 | -165.23 | 11 | 454.39 | Aug. 11, 2026: 4 @ 41.31 |
| Sept. 16, 2026 | issue | SO-260916-757 | MAIN | 14 | 41.31 | -578.32 | 15 | 619.63 | Aug. 11, 2026: 14 @ 41.31 |
| Sept. 5, 2026 | issue | SO-260905-538 | MAIN | 3 | 41.31 | -123.93 | 29 | 1,197.94 | Aug. 11, 2026: 3 @ 41.31 |
| Aug. 22, 2026 | adjustment | Cycle count | MAIN | -1 | 41.31 | -41.31 | 32 | 1,321.87 | Aug. 11, 2026: 1 @ 41.31 |
| Aug. 21, 2026 | issue | SO-260821-640 | MAIN | 1 | 41.31 | -41.31 | 33 | 1,363.18 | Aug. 11, 2026: 1 @ 41.31 |
| Aug. 17, 2026 | issue | SO-260817-346 | MAIN | 11 | 41.14 | -452.51 | 34 | 1,404.49 | June 9, 2026: 5 @ 40.93; Aug. 11, 2026: 6 @ 41.31 |
| Aug. 16, 2026 | issue | SO-260816-516 | MAIN | 2 | 40.93 | -81.86 | 45 | 1,856.99 | June 9, 2026: 2 @ 40.93 |
| Aug. 11, 2026 | receipt | PO-001711 | MAIN | 40 | 41.31 | 1,652.34 | 47 | 1,938.85 | |
| July 28, 2026 | issue | SO-260728-534 | MAIN | 6 | 40.93 | -245.59 | 7 | 286.52 | June 9, 2026: 6 @ 40.93 |
| July 24, 2026 | issue | SO-260724-445 | MAIN | 5 | 40.93 | -204.66 | 13 | 532.10 | June 9, 2026: 5 @ 40.93 |
| July 13, 2026 | issue | SO-260713-813 | MAIN | 1 | 40.93 | -40.93 | 18 | 736.76 | June 9, 2026: 1 @ 40.93 |
| July 12, 2026 | issue | SO-260712-119 | MAIN | 1 | 40.93 | -40.93 | 19 | 777.69 | June 9, 2026: 1 @ 40.93 |
| July 8, 2026 | issue | SO-260708-184 | MAIN | 1 | 40.93 | -40.93 | 20 | 818.62 | June 9, 2026: 1 @ 40.93 |
| July 5, 2026 | issue | SO-260705-353 | MAIN | 11 | 40.93 | -450.24 | 21 | 859.55 | June 9, 2026: 11 @ 40.93 |
| June 10, 2026 | issue | SO-260610-438 | MAIN | 4 | 40.93 | -163.72 | 32 | 1,309.80 | June 9, 2026: 4 @ 40.93 |
| June 9, 2026 | issue | SO-260609-947 | MAIN | 4 | 40.93 | -163.72 | 36 | 1,473.52 | June 9, 2026: 4 @ 40.93 |
| June 9, 2026 | receipt | PO-001564 | MAIN | 40 | 40.93 | 1,637.24 | 40 | 1,637.24 | |
| June 5, 2026 | issue | SO-260605-920 | MAIN | 7 | 39.57 | -277.00 | 0 | 0.00 | March 25, 2026: 7 @ 39.57 |
| June 2, 2026 | issue | SO-260602-247 | MAIN | 2 | 39.57 | -79.14 | 7 | 277.00 | March 25, 2026: 2 @ 39.57 |
| May 30, 2026 | issue | SO-260530-606 | MAIN | 15 | 39.57 | -593.57 | 9 | 356.14 | March 25, 2026: 15 @ 39.57 |
| May 21, 2026 | issue | SO-260521-501 | MAIN | 2 | 39.57 | -79.14 | 24 | 949.72 | March 25, 2026: 2 @ 39.57 |
| May 3, 2026 | issue | SO-260503-891 | MAIN | 1 | 39.57 | -39.57 | 26 | 1,028.86 | March 25, 2026: 1 @ 39.57 |
| April 25, 2026 | issue | SO-260425-745 | MAIN | 2 | 39.57 | -79.14 | 27 | 1,068.43 | March 25, 2026: 2 @ 39.57 |
| April 17, 2026 | issue | SO-260417-946 | MAIN | 5 | 39.57 | -197.86 | 29 | 1,147.57 | March 25, 2026: 5 @ 39.57 |
| April 16, 2026 | issue | SO-260416-800 | MAIN | 6 | 39.57 | -237.43 | 34 | 1,345.43 | March 25, 2026: 6 @ 39.57 |
| March 25, 2026 | receipt | PO-001349 | MAIN | 40 | 39.57 | 1,582.86 | 40 | 1,582.86 | |
| March 21, 2026 | issue | SO-260321-293 | MAIN | 7 | 39.02 | -273.11 | 0 | 0.00 | Feb. 10, 2026: 7 @ 39.02 |
| March 11, 2026 | issue | SO-260311-594 | MAIN | 10 | 39.02 | -390.16 | 7 | 273.11 | Feb. 10, 2026: 10 @ 39.02 |
| March 5, 2026 | issue | SO-260305-858 | MAIN | 10 | 39.02 | -390.16 | 17 | 663.27 | Feb. 10, 2026: 10 @ 39.02 |
| Feb. 19, 2026 | issue | SO-260219-669 | MAIN | 8 | 39.02 | -312.13 | 27 | 1,053.43 | Feb. 10, 2026: 8 @ 39.02 |
| Feb. 12, 2026 | issue | SO-260212-481 | MAIN | 6 | 39.18 | -235.10 | 35 | 1,365.55 | Dec. 5, 2025: 1 @ 40.02; Feb. 10, 2026: 5 @ 39.02 |
| Feb. 10, 2026 | receipt | PO-001212 | MAIN | 40 | 39.02 | 1,560.63 | 41 | 1,600.65 | |
| Jan. 29, 2026 | issue | SO-260129-312 | MAIN | 2 | 40.02 | -80.04 | 1 | 40.02 | Dec. 5, 2025: 2 @ 40.02 |
| Jan. 27, 2026 | issue | SO-260127-167 | MAIN | 4 | 40.02 | -160.08 | 3 | 120.06 | Dec. 5, 2025: 4 @ 40.02 |
| Jan. 24, 2026 | issue | SO-260124-197 | MAIN | 8 | 40.02 | -320.16 | 7 | 280.14 | Dec. 5, 2025: 8 @ 40.02 |
| Jan. 24, 2026 | issue | SO-260124-197 | EAST | 10 | 40.02 | -400.21 | 15 | 600.31 | Dec. 5, 2025: 10 @ 40.02 |
| Dec. 23, 2025 | issue | SO-251223-801 | MAIN | 1 | 40.02 | -40.02 | 25 | 1,000.52 | Dec. 5, 2025: 1 @ 40.02 |
| Dec. 17, 2025 | issue | SO-251217-231 | MAIN | 1 | 40.02 | -40.02 | 26 | 1,040.54 | Dec. 5, 2025: 1 @ 40.02 |
| Dec. 16, 2025 | issue | SO-251216-677 | MAIN | 1 | 40.02 | -40.02 | 27 | 1,080.56 | Dec. 5, 2025: 1 @ 40.02 |
| Dec. 15, 2025 | issue | SO-251215-823 | MAIN | 8 | 40.02 | -320.16 | 28 | 1,120.58 | Dec. 5, 2025: 8 @ 40.02 |
| Dec. 10, 2025 | issue | SO-251210-832 | MAIN | 1 | 40.02 | -40.02 | 36 | 1,440.74 | Dec. 5, 2025: 1 @ 40.02 |
| Dec. 6, 2025 | issue | SO-251206-336 | MAIN | 4 | 39.62 | -158.48 | 37 | 1,480.76 | Sept. 28, 2025: 1 @ 38.42; Dec. 5, 2025: 3 @ 40.02 |
| Dec. 5, 2025 | transfer | TRF | MAIN → EAST | 10 | warehouse transfer, no cost effect | ||||
| Dec. 5, 2025 | receipt | PO-001035 | MAIN | 40 | 40.02 | 1,600.82 | 41 | 1,639.24 | |
| Nov. 30, 2025 | issue | SO-251130-128 | MAIN | 1 | 38.42 | -38.42 | 1 | 38.42 | Sept. 28, 2025: 1 @ 38.42 |
| Nov. 29, 2025 | issue | SO-251129-933 | MAIN | 6 | 38.39 | -230.36 | 2 | 76.84 | Sept. 13, 2025: 4 @ 38.42; Sept. 15, 2025: 2 @ 38.35 |
| Nov. 25, 2025 | issue | SO-251125-910 | MAIN | 6 | 38.42 | -230.51 | 8 | 307.20 | Sept. 13, 2025: 6 @ 38.42 |
| Nov. 24, 2025 | issue | SO-251124-136 | MAIN | 1 | 38.42 | -38.42 | 14 | 537.71 | Sept. 13, 2025: 1 @ 38.42 |
| Nov. 20, 2025 | issue | SO-251120-457 | MAIN | 1 | 38.42 | -38.42 | 15 | 576.12 | Sept. 13, 2025: 1 @ 38.42 |
| Nov. 9, 2025 | issue | SO-251109-727 | MAIN | 3 | 38.42 | -115.25 | 16 | 614.54 | Sept. 13, 2025: 3 @ 38.42 |
| Nov. 6, 2025 | issue | SO-251106-358 | MAIN | 1 | 38.42 | -38.42 | 19 | 729.80 | Sept. 13, 2025: 1 @ 38.42 |
| Oct. 22, 2025 | issue | SO-251022-616 | MAIN | 2 | 38.42 | -76.84 | 20 | 768.21 | Sept. 13, 2025: 2 @ 38.42 |
| Oct. 22, 2025 | issue | SO-251022-616 | EAST | 3 | 38.42 | -115.25 | 22 | 845.05 | Sept. 13, 2025: 3 @ 38.42 |