Items / TLS-0015
Voltage Tester Max TLS-0015 · Tools & Testers · ToolMasters Industrial
On hand (EA)13MAIN 9, EAST 4
Value (FIFO)2,134.60avg 164.20
ClassCY / FCV 0.89
Turnover2.5xlast issue 42 days ago
Days of cover119lead 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 | 3.33 / 30.4375 | 0.110 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.98 / 5.517 | 0.540 |
| 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.540^2 + 0.110^2 * 1.2^2) | 1.6 |
| Reorder point | d * LT + safety stock | 0.110 * 5.0 + 1.6 | 2.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 2.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 40/yr, S = 45.00, h = 20%, price = 161.55 | 10.6 |
| Inventory position | on hand + on order | 13 + 0 | 13 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 161.55 | 11 | 6,799 | yes (chosen if cheapest) |
MOQ 1, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| July 15, 2026 | 2 / 11 | 158.83 | 317.66 | |
| Sept. 9, 2026 | 11 / 11 | 165.18 | 1,816.95 |
Movement ledger 29 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Sept. 9, 2026 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Sept. 9, 2026 | receipt | PO-001785 | MAIN | 11 | 165.18 | 1,816.95 | 13 | 2,134.60 | |
| Sept. 4, 2026 | issue | SO-260904-775 | MAIN | 7 | 158.83 | -1,111.79 | 2 | 317.66 | July 15, 2026: 7 @ 158.83 |
| Aug. 4, 2026 | issue | SO-260804-990 | MAIN | 4 | 158.51 | -634.02 | 9 | 1,429.45 | March 2, 2026: 2 @ 158.18; July 15, 2026: 2 @ 158.83 |
| July 15, 2026 | receipt | PO-001648 | MAIN | 11 | 158.83 | 1,747.10 | 13 | 2,063.47 | |
| July 9, 2026 | issue | SO-260709-485 | MAIN | 7 | 158.18 | -1,107.28 | 2 | 316.37 | March 2, 2026: 7 @ 158.18 |
| May 31, 2026 | issue | SO-260531-791 | MAIN | 4 | 157.02 | -628.09 | 9 | 1,423.64 | Oct. 16, 2025: 2 @ 155.86; March 2, 2026: 2 @ 158.18 |
| March 2, 2026 | receipt | PO-001276 | MAIN | 11 | 158.18 | 1,740.01 | 13 | 2,051.74 | |
| Feb. 26, 2026 | issue | SO-260226-464 | MAIN | 5 | 155.86 | -779.32 | 2 | 311.73 | Oct. 16, 2025: 5 @ 155.86 |
| Jan. 5, 2026 | issue | SO-260105-766 | MAIN | 2 | 155.86 | -311.73 | 7 | 1,091.04 | Oct. 16, 2025: 2 @ 155.86 |
| Jan. 5, 2026 | issue | SO-260105-766 | EAST | 4 | 152.31 | -609.23 | 9 | 1,402.77 | May 26, 2025: 2 @ 148.75; Oct. 16, 2025: 2 @ 155.86 |
| Oct. 16, 2025 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Oct. 16, 2025 | receipt | PO-000925 | MAIN | 11 | 155.86 | 1,714.49 | 13 | 2,012.00 | |
| Oct. 9, 2025 | issue | SO-251009-957 | MAIN | 7 | 148.75 | -1,041.25 | 2 | 297.50 | May 26, 2025: 7 @ 148.75 |
| Sept. 13, 2025 | issue | SO-250913-804 | MAIN | 4 | 151.43 | -605.71 | 9 | 1,338.76 | March 5, 2025: 2 @ 154.11; May 26, 2025: 2 @ 148.75 |
| May 26, 2025 | receipt | PO-000579 | MAIN | 11 | 148.75 | 1,636.26 | 13 | 1,944.47 | |
| May 21, 2025 | issue | SO-250521-691 | MAIN | 3 | 154.11 | -462.32 | 2 | 308.21 | March 5, 2025: 3 @ 154.11 |
| April 30, 2025 | issue | SO-250430-617 | MAIN | 4 | 154.11 | -616.43 | 5 | 770.53 | March 5, 2025: 4 @ 154.11 |
| March 5, 2025 | issue | SO-250305-560 | MAIN | 4 | 149.96 | -599.83 | 9 | 1,386.96 | March 3, 2025: 2 @ 145.81; March 5, 2025: 2 @ 154.11 |
| March 5, 2025 | receipt | PO-000316 | MAIN | 11 | 154.11 | 1,695.17 | 13 | 1,986.79 | |
| March 3, 2025 | return | RMA | MAIN | 2 | 145.81 | 291.62 | 2 | 291.62 | |
| Feb. 28, 2025 | issue | SO-250228-494 | EAST | 4 | 145.81 | -583.23 | 0 | 0.00 | Nov. 23, 2024: 4 @ 145.81 |
| Jan. 5, 2025 | issue | SO-250105-799 | MAIN | 6 | 145.81 | -874.85 | 4 | 583.23 | Nov. 23, 2024: 6 @ 145.81 |
| Dec. 14, 2024 | adjustment | Cycle count | MAIN | -1 | 145.81 | -145.81 | 10 | 1,458.08 | Nov. 23, 2024: 1 @ 145.81 |
| Nov. 23, 2024 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Nov. 23, 2024 | receipt | PO-000057 | MAIN | 11 | 145.81 | 1,603.89 | 11 | 1,603.89 | |
| Nov. 18, 2024 | issue | SO-241118-263 | MAIN | 5 | 153.47 | -767.36 | 0 | 0.00 | Oct. 1, 2024: 5 @ 153.47 |
| Oct. 30, 2024 | adjustment | Cycle count | MAIN | -1 | 153.47 | -153.47 | 5 | 767.36 | Oct. 1, 2024: 1 @ 153.47 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 6 | 153.47 | 920.84 | 6 | 920.84 | |