Items / TLS-0001
Wire Stripper Prime TLS-0001 · Tools & Testers · ToolMasters Industrial
On hand (EA)7MAIN 7
Value (FIFO)2,038.98avg 291.28
ClassBZ / FCV 1.10
Turnover7.9xlast issue 5 days ago
Days of cover53lead 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.00 / 30.4375 | 0.131 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.40 / 5.517 | 0.797 |
| Service level / z | z = Phi^-1(service level) | Phi^-1(0.950) | 1.645 |
| Safety stock | z * sqrt(LT * sd_d^2 + d^2 * sd_LT^2) | 1.645 * sqrt(5.0 * 0.797^2 + 0.131^2 * 1.2^2) | 2.9 |
| Reorder point | d * LT + safety stock | 0.131 * 5.0 + 2.9 | 3.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 48/yr, S = 45.00, h = 20%, price = 300.29 | 8.5 |
| 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 | 300.29 | 8 | 14,913 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| March 17, 2026 | 7 / 18 | 291.28 | 2,038.98 |
Movement ledger 21 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 11, 2026 | issue | SO-261011-330 | MAIN | 6 | 291.28 | -1,747.70 | 7 | 2,038.98 | March 17, 2026: 6 @ 291.28 |
| July 24, 2026 | issue | SO-260724-395 | MAIN | 6 | 291.46 | -1,748.75 | 13 | 3,786.68 | Dec. 9, 2025: 1 @ 292.33; March 17, 2026: 5 @ 291.28 |
| March 17, 2026 | receipt | PO-001329 | MAIN | 18 | 291.28 | 5,243.10 | 19 | 5,535.44 | |
| March 12, 2026 | issue | SO-260312-946 | MAIN | 9 | 292.33 | -2,631.01 | 1 | 292.33 | Dec. 9, 2025: 9 @ 292.33 |
| Jan. 7, 2026 | issue | SO-260107-455 | MAIN | 13 | 293.75 | -3,818.71 | 10 | 2,923.34 | Oct. 25, 2025: 5 @ 296.01; Dec. 9, 2025: 8 @ 292.33 |
| Dec. 9, 2025 | receipt | PO-001040 | MAIN | 18 | 292.33 | 5,262.02 | 23 | 6,742.06 | |
| Dec. 4, 2025 | issue | SO-251204-394 | MAIN | 5 | 296.01 | -1,480.04 | 5 | 1,480.04 | Oct. 25, 2025: 5 @ 296.01 |
| Nov. 24, 2025 | issue | SO-251124-774 | MAIN | 8 | 296.01 | -2,368.06 | 10 | 2,960.08 | Oct. 25, 2025: 8 @ 296.01 |
| Oct. 25, 2025 | receipt | PO-000952 | MAIN | 18 | 296.01 | 5,328.14 | 18 | 5,328.14 | |
| Oct. 20, 2025 | issue | SO-251020-438 | MAIN | 7 | 275.53 | -1,928.70 | 0 | 0.00 | June 3, 2025: 7 @ 275.53 |
| Sept. 10, 2025 | issue | SO-250910-111 | MAIN | 5 | 275.53 | -1,377.65 | 7 | 1,928.70 | June 3, 2025: 5 @ 275.53 |
| Sept. 10, 2025 | issue | SO-250910-111 | EAST | 6 | 275.53 | -1,653.17 | 12 | 3,306.35 | June 3, 2025: 6 @ 275.53 |
| June 3, 2025 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| June 3, 2025 | receipt | PO-000601 | MAIN | 18 | 275.53 | 4,959.52 | 18 | 4,959.52 | |
| May 30, 2025 | issue | SO-250530-277 | MAIN | 6 | 277.00 | -1,662.00 | 0 | 0.00 | Nov. 1, 2024: 6 @ 277.00 |
| March 10, 2025 | adjustment | Cycle count | MAIN | -2 | 277.00 | -554.00 | 6 | 1,662.00 | Nov. 1, 2024: 2 @ 277.00 |
| March 1, 2025 | issue | SO-250301-632 | MAIN | 11 | 277.75 | -3,055.28 | 8 | 2,216.01 | Oct. 1, 2024: 1 @ 285.28; Nov. 1, 2024: 10 @ 277.00 |
| Feb. 16, 2025 | adjustment | Cycle count | MAIN | -1 | 285.28 | -285.28 | 19 | 5,271.29 | Oct. 1, 2024: 1 @ 285.28 |
| Nov. 1, 2024 | receipt | PO-000019 | MAIN | 18 | 277.00 | 4,986.01 | 20 | 5,556.56 | |
| Oct. 29, 2024 | issue | SO-241029-854 | MAIN | 7 | 285.28 | -1,996.93 | 2 | 570.55 | Oct. 1, 2024: 7 @ 285.28 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 9 | 285.28 | 2,567.48 | 9 | 2,567.48 | |