Items / TLS-0013
Wire Stripper Eco TLS-0013 · Tools & Testers · ToolMasters Industrial
On hand (EA)7MAIN 1, EAST 6
Value (FIFO)897.21avg 128.17
ClassCZ / FCV 1.02
Turnover4.1xlast issue 12 days ago
Days of cover45lead time 5d
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 | 4.75 / 30.4375 | 0.156 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.87 / 5.517 | 0.882 |
| 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(5.0 * 0.882^2 + 0.156^2 * 1.2^2) | 2.5 |
| Reorder point | d * LT + safety stock | 0.156 * 5.0 + 2.5 | 3.3 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.3 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 57/yr, S = 45.00, h = 20%, price = 133.52 | 13.9 |
| Inventory position | on hand + on order | 7 + 0 | 7 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 133.52 | 14 | 7,975 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| March 8, 2026 | 7 / 22 | 128.17 | 897.21 |
Movement ledger 24 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 4, 2026 | issue | SO-261004-358 | MAIN | 11 | 128.17 | -1,409.90 | 7 | 897.21 | March 8, 2026: 11 @ 128.17 |
| Sept. 29, 2026 | issue | SO-260929-531 | MAIN | 7 | 127.78 | -894.43 | 18 | 2,307.11 | Jan. 22, 2026: 3 @ 127.24; March 8, 2026: 4 @ 128.17 |
| March 8, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| March 8, 2026 | receipt | PO-001295 | MAIN | 22 | 128.17 | 2,819.81 | 25 | 3,201.54 | |
| March 3, 2026 | issue | SO-260303-723 | MAIN | 9 | 127.24 | -1,145.20 | 3 | 381.73 | Jan. 22, 2026: 9 @ 127.24 |
| Feb. 3, 2026 | issue | SO-260203-262 | MAIN | 3 | 127.24 | -381.73 | 12 | 1,526.94 | Jan. 22, 2026: 3 @ 127.24 |
| Feb. 3, 2026 | issue | SO-260203-262 | EAST | 7 | 127.24 | -890.71 | 15 | 1,908.67 | Jan. 22, 2026: 7 @ 127.24 |
| Jan. 22, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Jan. 22, 2026 | receipt | PO-001171 | MAIN | 22 | 127.24 | 2,799.38 | 22 | 2,799.38 | |
| Jan. 16, 2026 | issue | SO-260116-218 | MAIN | 5 | 126.27 | -631.35 | 0 | 0.00 | Oct. 15, 2025: 5 @ 126.27 |
| Jan. 16, 2026 | issue | SO-260116-218 | EAST | 7 | 126.27 | -883.89 | 5 | 631.35 | Oct. 15, 2025: 7 @ 126.27 |
| Nov. 25, 2025 | issue | SO-251125-342 | MAIN | 10 | 126.27 | -1,262.69 | 12 | 1,515.23 | Oct. 15, 2025: 10 @ 126.27 |
| Oct. 15, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Oct. 15, 2025 | receipt | PO-000922 | MAIN | 22 | 126.27 | 2,777.93 | 22 | 2,777.93 | |
| Oct. 10, 2025 | issue | SO-251010-315 | MAIN | 9 | 129.20 | -1,162.80 | 0 | 0.00 | July 30, 2025: 9 @ 129.20 |
| Aug. 15, 2025 | issue | SO-250815-235 | MAIN | 13 | 129.20 | -1,679.60 | 9 | 1,162.80 | July 30, 2025: 13 @ 129.20 |
| July 30, 2025 | receipt | PO-000743 | MAIN | 22 | 129.20 | 2,842.40 | 22 | 2,842.40 | |
| July 25, 2025 | issue | SO-250725-686 | MAIN | 5 | 127.71 | -638.56 | 0 | 0.00 | April 5, 2025: 5 @ 127.71 |
| July 25, 2025 | issue | SO-250725-686 | EAST | 4 | 127.71 | -510.85 | 5 | 638.56 | April 5, 2025: 4 @ 127.71 |
| June 29, 2025 | issue | SO-250629-264 | MAIN | 13 | 127.71 | -1,660.26 | 9 | 1,149.41 | April 5, 2025: 13 @ 127.71 |
| April 5, 2025 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| April 5, 2025 | receipt | PO-000415 | MAIN | 22 | 127.71 | 2,809.66 | 22 | 2,809.66 | |
| March 30, 2025 | issue | SO-250330-967 | MAIN | 11 | 126.84 | -1,395.28 | 0 | 0.00 | Oct. 1, 2024: 11 @ 126.84 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 11 | 126.84 | 1,395.28 | 11 | 1,395.28 | |