Items / TLS-0014
Clamp Meter Max TLS-0014 · Tools & Testers · ToolMasters Industrial
On hand (EA)9MAIN 9
Value (FIFO)394.55avg 43.84
ClassCY / FCV 0.81
Turnover3.2xlast issue 37 days ago
Days of cover117lead 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 | 2.33 / 30.4375 | 0.077 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.89 / 5.517 | 0.342 |
| 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.342^2 + 0.077^2 * 1.2^2) | 1.0 |
| Reorder point | d * LT + safety stock | 0.077 * 5.0 + 1.0 | 1.4 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.4 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 28/yr, S = 45.00, h = 20%, price = 45.16 | 16.7 |
| Inventory position | on hand + on order | 9 + 0 | 9 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 45.16 | 17 | 1,414 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 13, 2026 | 9 / 9 | 43.84 | 394.55 |
Movement ledger 27 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 13, 2026 | receipt | PO-001797 | MAIN | 9 | 43.84 | 394.55 | 9 | 394.55 | |
| Sept. 9, 2026 | issue | SO-260909-386 | MAIN | 3 | 44.26 | -132.78 | 0 | 0.00 | June 17, 2026: 3 @ 44.26 |
| Aug. 4, 2026 | issue | SO-260804-370 | MAIN | 3 | 44.26 | -132.78 | 3 | 132.78 | June 17, 2026: 3 @ 44.26 |
| July 20, 2026 | issue | SO-260720-655 | MAIN | 4 | 44.14 | -176.58 | 6 | 265.56 | May 19, 2026: 1 @ 43.80; June 17, 2026: 3 @ 44.26 |
| June 17, 2026 | receipt | PO-001584 | MAIN | 9 | 44.26 | 398.34 | 10 | 442.14 | |
| June 10, 2026 | issue | SO-260610-941 | MAIN | 6 | 43.80 | -262.80 | 1 | 43.80 | March 28, 2026: 5 @ 43.80; May 19, 2026: 1 @ 43.80 |
| May 19, 2026 | return | RMA | MAIN | 2 | 43.80 | 87.60 | 7 | 306.60 | |
| May 1, 2026 | issue | SO-260501-820 | MAIN | 4 | 43.80 | -175.20 | 5 | 219.00 | March 28, 2026: 4 @ 43.80 |
| March 28, 2026 | receipt | PO-001364 | MAIN | 9 | 43.80 | 394.20 | 9 | 394.20 | |
| March 22, 2026 | issue | SO-260322-396 | MAIN | 4 | 42.86 | -171.44 | 0 | 0.00 | Sept. 19, 2025: 4 @ 42.86 |
| Jan. 13, 2026 | issue | SO-260113-642 | MAIN | 3 | 42.86 | -128.58 | 4 | 171.44 | Sept. 19, 2025: 3 @ 42.86 |
| Dec. 19, 2025 | issue | SO-251219-595 | MAIN | 3 | 42.43 | -127.29 | 7 | 300.02 | April 10, 2025: 1 @ 41.57; Sept. 19, 2025: 2 @ 42.86 |
| Sept. 19, 2025 | receipt | PO-000857 | MAIN | 9 | 42.86 | 385.74 | 10 | 427.30 | |
| Sept. 13, 2025 | issue | SO-250913-360 | MAIN | 3 | 41.57 | -124.71 | 1 | 41.57 | April 10, 2025: 3 @ 41.57 |
| Sept. 8, 2025 | adjustment | Cycle count | MAIN | -1 | 41.57 | -41.57 | 4 | 166.28 | April 10, 2025: 1 @ 41.57 |
| May 28, 2025 | issue | SO-250528-279 | MAIN | 4 | 41.57 | -166.28 | 5 | 207.84 | April 10, 2025: 4 @ 41.57 |
| April 10, 2025 | receipt | PO-000434 | MAIN | 9 | 41.57 | 374.12 | 9 | 374.12 | |
| April 6, 2025 | issue | SO-250406-375 | MAIN | 3 | 41.98 | -125.92 | 0 | 0.00 | Feb. 4, 2025: 3 @ 41.98 |
| March 1, 2025 | issue | SO-250301-705 | MAIN | 7 | 42.04 | -294.29 | 3 | 125.92 | Nov. 11, 2024: 1 @ 42.44; Feb. 4, 2025: 6 @ 41.98 |
| Feb. 4, 2025 | receipt | PO-000239 | MAIN | 9 | 41.98 | 377.78 | 10 | 420.21 | |
| Jan. 29, 2025 | issue | SO-250129-610 | MAIN | 5 | 42.44 | -212.19 | 1 | 42.44 | Nov. 11, 2024: 5 @ 42.44 |
| Dec. 7, 2024 | issue | SO-241207-497 | MAIN | 5 | 41.87 | -209.34 | 6 | 254.63 | Oct. 20, 2024: 2 @ 41.01; Nov. 11, 2024: 3 @ 42.44 |
| Nov. 11, 2024 | receipt | PO-000030 | MAIN | 9 | 42.44 | 381.95 | 11 | 463.97 | |
| Nov. 5, 2024 | issue | SO-241105-851 | MAIN | 7 | 41.01 | -287.10 | 2 | 82.03 | Oct. 20, 2024: 7 @ 41.01 |
| Oct. 20, 2024 | receipt | PO-000010 | MAIN | 9 | 41.01 | 369.12 | 9 | 369.12 | |
| Oct. 16, 2024 | issue | SO-241016-377 | MAIN | 5 | 42.90 | -214.51 | 0 | 0.00 | Oct. 1, 2024: 5 @ 42.90 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 5 | 42.90 | 214.51 | 5 | 214.51 |