Items / CAB-0009
FR Wire 4 sqmm Classic CAB-0009 · Cables & Wires · Conduit & Cable Co
On hand (COIL)94MAIN 94
Value (FIFO)32,792.84avg 348.86
ClassAX / FCV 0.28
Turnover10.3xlast issue 4 days ago
Days of cover55lead 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 | 51.58 / 30.4375 | 1.695 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 14.56 / 5.517 | 2.639 |
| 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 * 2.639^2 + 1.695^2 * 3.1^2) | 23.0 |
| Reorder point | d * LT + safety stock | 1.695 * 14.0 + 23.0 | 46.8 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 46.8 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 619/yr, S = 45.00, h = 20%, price = 357.81 | 27.9 |
| Inventory position | on hand + on order | 94 + 0 | 94 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 357.81 | 28 | 223,329 | yes (chosen if cheapest) |
MOQ 100, pack size 10, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 8, 2026 | 94 / 100 | 348.86 | 32,792.84 |
Movement ledger 128 movements, latest 60 shown - show all
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-924 | MAIN | 1 | 348.86 | -348.86 | 94 | 32,792.84 | Oct. 8, 2026: 1 @ 348.86 |
| Oct. 11, 2026 | issue | SO-261011-646 | MAIN | 12 | 350.07 | -4,200.88 | 95 | 33,141.70 | Aug. 23, 2026: 7 @ 350.94; Oct. 8, 2026: 5 @ 348.86 |
| Oct. 10, 2026 | issue | SO-261010-264 | MAIN | 17 | 350.94 | -5,965.97 | 107 | 37,342.58 | Aug. 23, 2026: 17 @ 350.94 |
| Oct. 8, 2026 | receipt | PO-001859 | MAIN | 100 | 348.86 | 34,886.00 | 124 | 43,308.54 | |
| Oct. 1, 2026 | issue | SO-261001-551 | MAIN | 3 | 350.94 | -1,052.82 | 24 | 8,422.54 | Aug. 23, 2026: 3 @ 350.94 |
| Sept. 27, 2026 | issue | SO-260927-506 | MAIN | 11 | 350.94 | -3,860.33 | 27 | 9,475.36 | Aug. 23, 2026: 11 @ 350.94 |
| Sept. 26, 2026 | issue | SO-260926-152 | MAIN | 6 | 350.94 | -2,105.64 | 38 | 13,335.69 | Aug. 23, 2026: 6 @ 350.94 |
| Sept. 21, 2026 | issue | SO-260921-643 | MAIN | 4 | 350.94 | -1,403.76 | 44 | 15,441.33 | Aug. 23, 2026: 4 @ 350.94 |
| Sept. 19, 2026 | issue | SO-260919-242 | MAIN | 4 | 350.94 | -1,403.76 | 48 | 16,845.09 | Aug. 23, 2026: 4 @ 350.94 |
| Sept. 17, 2026 | issue | SO-260917-565 | MAIN | 5 | 350.94 | -1,754.70 | 52 | 18,248.84 | Aug. 23, 2026: 5 @ 350.94 |
| Sept. 16, 2026 | issue | SO-260916-923 | MAIN | 2 | 350.94 | -701.88 | 57 | 20,003.54 | Aug. 23, 2026: 2 @ 350.94 |
| Sept. 6, 2026 | issue | SO-260906-994 | MAIN | 3 | 350.94 | -1,052.82 | 59 | 20,705.42 | Aug. 23, 2026: 3 @ 350.94 |
| Aug. 30, 2026 | issue | SO-260830-945 | MAIN | 3 | 350.94 | -1,052.82 | 62 | 21,758.24 | Aug. 23, 2026: 3 @ 350.94 |
| Aug. 28, 2026 | issue | SO-260828-438 | MAIN | 21 | 350.94 | -7,369.73 | 65 | 22,811.05 | Aug. 23, 2026: 21 @ 350.94 |
| Aug. 27, 2026 | issue | SO-260827-143 | MAIN | 8 | 350.94 | -2,807.51 | 86 | 30,180.78 | Aug. 23, 2026: 8 @ 350.94 |
| Aug. 24, 2026 | issue | SO-260824-837 | MAIN | 25 | 359.86 | -8,996.60 | 94 | 32,988.29 | June 17, 2026: 19 @ 362.68; Aug. 23, 2026: 6 @ 350.94 |
| Aug. 23, 2026 | receipt | PO-001739 | MAIN | 100 | 350.94 | 35,093.93 | 119 | 41,984.89 | |
| Aug. 20, 2026 | issue | SO-260820-308 | MAIN | 9 | 362.68 | -3,264.14 | 19 | 6,890.96 | June 17, 2026: 9 @ 362.68 |
| Aug. 11, 2026 | issue | SO-260811-905 | MAIN | 15 | 362.68 | -5,440.23 | 28 | 10,155.10 | June 17, 2026: 15 @ 362.68 |
| Aug. 10, 2026 | issue | SO-260810-251 | MAIN | 2 | 362.68 | -725.36 | 43 | 15,595.34 | June 17, 2026: 2 @ 362.68 |
| July 31, 2026 | issue | SO-260731-797 | MAIN | 3 | 362.68 | -1,088.05 | 45 | 16,320.70 | June 17, 2026: 3 @ 362.68 |
| July 29, 2026 | issue | SO-260729-602 | MAIN | 12 | 362.68 | -4,352.19 | 48 | 17,408.75 | June 17, 2026: 12 @ 362.68 |
| July 17, 2026 | issue | SO-260717-986 | MAIN | 11 | 362.68 | -3,989.51 | 60 | 21,760.94 | June 17, 2026: 11 @ 362.68 |
| July 10, 2026 | issue | SO-260710-893 | MAIN | 3 | 362.68 | -1,088.05 | 71 | 25,750.44 | June 17, 2026: 3 @ 362.68 |
| July 7, 2026 | issue | SO-260707-539 | MAIN | 1 | 362.68 | -362.68 | 74 | 26,838.49 | June 17, 2026: 1 @ 362.68 |
| July 4, 2026 | issue | SO-260704-265 | MAIN | 25 | 362.68 | -9,067.06 | 75 | 27,201.17 | June 17, 2026: 25 @ 362.68 |
| June 17, 2026 | receipt | PO-001583 | MAIN | 100 | 362.68 | 36,268.23 | 100 | 36,268.23 | |
| June 14, 2026 | issue | SO-260614-197 | EAST | 29 | 358.01 | -10,382.29 | 0 | 0.00 | April 13, 2026: 29 @ 358.01 |
| June 6, 2026 | issue | SO-260606-692 | EAST | 6 | 358.01 | -2,148.06 | 29 | 10,382.29 | April 13, 2026: 6 @ 358.01 |
| June 6, 2026 | issue | SO-260606-692 | MAIN | 7 | 358.01 | -2,506.07 | 35 | 12,530.35 | April 13, 2026: 7 @ 358.01 |
| May 29, 2026 | issue | SO-260529-897 | MAIN | 21 | 358.01 | -7,518.21 | 42 | 15,036.42 | April 13, 2026: 21 @ 358.01 |
| May 28, 2026 | issue | SO-260528-107 | MAIN | 37 | 358.01 | -13,246.37 | 63 | 22,554.62 | April 13, 2026: 37 @ 358.01 |
| April 13, 2026 | transfer | TRF | MAIN → EAST | 35 | warehouse transfer, no cost effect | ||||
| April 13, 2026 | receipt | PO-001405 | MAIN | 100 | 358.01 | 35,800.99 | 100 | 35,800.99 | |
| April 8, 2026 | issue | SO-260408-912 | MAIN | 17 | 356.56 | -6,061.51 | 0 | 0.00 | Feb. 10, 2026: 17 @ 356.56 |
| April 3, 2026 | issue | SO-260403-692 | MAIN | 18 | 356.56 | -6,418.07 | 17 | 6,061.51 | Feb. 10, 2026: 18 @ 356.56 |
| March 28, 2026 | issue | SO-260328-795 | MAIN | 2 | 356.56 | -713.12 | 35 | 12,479.59 | Feb. 10, 2026: 2 @ 356.56 |
| March 21, 2026 | issue | SO-260321-391 | MAIN | 1 | 356.56 | -356.56 | 37 | 13,192.71 | Feb. 10, 2026: 1 @ 356.56 |
| March 17, 2026 | issue | SO-260317-181 | MAIN | 10 | 356.56 | -3,565.60 | 38 | 13,549.26 | Feb. 10, 2026: 10 @ 356.56 |
| March 13, 2026 | issue | SO-260313-344 | MAIN | 7 | 356.56 | -2,495.92 | 48 | 17,114.86 | Feb. 10, 2026: 7 @ 356.56 |
| March 7, 2026 | issue | SO-260307-252 | MAIN | 30 | 356.56 | -10,696.79 | 55 | 19,610.78 | Feb. 10, 2026: 30 @ 356.56 |
| March 6, 2026 | issue | SO-260306-430 | MAIN | 5 | 356.56 | -1,782.80 | 85 | 30,307.57 | Feb. 10, 2026: 5 @ 356.56 |
| Feb. 25, 2026 | issue | SO-260225-699 | MAIN | 17 | 354.53 | -6,027.05 | 90 | 32,090.36 | Jan. 6, 2026: 7 @ 351.64; Feb. 10, 2026: 10 @ 356.56 |
| Feb. 10, 2026 | receipt | PO-001213 | MAIN | 100 | 356.56 | 35,655.96 | 107 | 38,117.41 | |
| Feb. 8, 2026 | issue | SO-260208-148 | MAIN | 3 | 351.64 | -1,054.91 | 7 | 2,461.45 | Jan. 6, 2026: 3 @ 351.64 |
| Feb. 5, 2026 | issue | SO-260205-509 | MAIN | 13 | 351.64 | -4,571.27 | 10 | 3,516.36 | Jan. 6, 2026: 13 @ 351.64 |
| Feb. 1, 2026 | issue | SO-260201-624 | MAIN | 39 | 351.64 | -13,713.82 | 23 | 8,087.64 | Jan. 6, 2026: 39 @ 351.64 |
| Jan. 20, 2026 | issue | SO-260120-602 | MAIN | 40 | 351.38 | -14,055.34 | 62 | 21,801.46 | Oct. 24, 2025: 2 @ 346.58; Jan. 6, 2026: 38 @ 351.64 |
| Jan. 18, 2026 | issue | SO-260118-579 | MAIN | 21 | 346.58 | -7,278.14 | 102 | 35,856.80 | Oct. 24, 2025: 21 @ 346.58 |
| Jan. 6, 2026 | receipt | PO-001125 | MAIN | 100 | 351.64 | 35,163.64 | 123 | 43,134.94 | |
| Dec. 26, 2025 | issue | SO-251226-400 | MAIN | 8 | 346.58 | -2,772.62 | 23 | 7,971.30 | Oct. 24, 2025: 8 @ 346.58 |
| Dec. 25, 2025 | issue | SO-251225-762 | MAIN | 24 | 346.58 | -8,317.87 | 31 | 10,743.92 | Oct. 24, 2025: 24 @ 346.58 |
| Dec. 20, 2025 | issue | SO-251220-657 | MAIN | 1 | 346.58 | -346.58 | 55 | 19,061.80 | Oct. 24, 2025: 1 @ 346.58 |
| Dec. 5, 2025 | issue | SO-251205-632 | MAIN | 3 | 346.58 | -1,039.73 | 56 | 19,408.37 | Oct. 24, 2025: 3 @ 346.58 |
| Dec. 4, 2025 | issue | SO-251204-698 | MAIN | 5 | 346.58 | -1,732.89 | 59 | 20,448.11 | Oct. 24, 2025: 5 @ 346.58 |
| Nov. 30, 2025 | issue | SO-251130-194 | MAIN | 5 | 346.58 | -1,732.89 | 64 | 22,181.00 | Oct. 24, 2025: 5 @ 346.58 |
| Nov. 25, 2025 | issue | SO-251125-580 | MAIN | 5 | 346.58 | -1,732.89 | 69 | 23,913.89 | Oct. 24, 2025: 5 @ 346.58 |
| Nov. 19, 2025 | issue | SO-251119-300 | MAIN | 14 | 346.58 | -4,852.09 | 74 | 25,646.78 | Oct. 24, 2025: 14 @ 346.58 |
| Nov. 13, 2025 | issue | SO-251113-722 | MAIN | 7 | 346.58 | -2,426.05 | 88 | 30,498.87 | Oct. 24, 2025: 7 @ 346.58 |
| Nov. 11, 2025 | issue | SO-251111-102 | MAIN | 11 | 345.73 | -3,803.07 | 95 | 32,924.92 | Aug. 24, 2025: 6 @ 345.03; Oct. 24, 2025: 5 @ 346.58 |