Items / TLS-0003
Voltage Tester Lite TLS-0003 · Tools & Testers · ToolMasters Industrial
On hand (EA)15MAIN 15
Value (FIFO)536.30avg 35.75
ClassCZ / FCV 1.03
Turnover2.7xlast issue 4 days ago
Days of cover107lead 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.25 / 30.4375 | 0.140 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.36 / 5.517 | 0.791 |
| 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.791^2 + 0.140^2 * 1.2^2) | 2.3 |
| Reorder point | d * LT + safety stock | 0.140 * 5.0 + 2.3 | 3.0 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.0 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 51/yr, S = 45.00, h = 20%, price = 36.67 | 25.0 |
| Inventory position | on hand + on order | 15 + 0 | 15 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 36.67 | 25 | 2,052 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Sept. 28, 2026 | 15 / 23 | 35.75 | 536.30 |
Movement ledger 19 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 12, 2026 | issue | SO-261012-577 | EAST | 8 | 35.75 | -286.02 | 15 | 536.30 | Sept. 28, 2026: 8 @ 35.75 |
| Sept. 28, 2026 | transfer | TRF | MAIN → EAST | 8 | warehouse transfer, no cost effect | ||||
| Sept. 28, 2026 | receipt | PO-001837 | MAIN | 23 | 35.75 | 822.32 | 23 | 822.32 | |
| Sept. 23, 2026 | issue | SO-260923-594 | MAIN | 5 | 34.98 | -174.90 | 0 | 0.00 | Jan. 28, 2026: 5 @ 34.98 |
| Sept. 23, 2026 | issue | SO-260923-594 | EAST | 3 | 34.98 | -104.94 | 5 | 174.90 | Jan. 28, 2026: 3 @ 34.98 |
| June 29, 2026 | issue | SO-260629-882 | MAIN | 8 | 34.98 | -279.85 | 8 | 279.85 | Jan. 28, 2026: 8 @ 34.98 |
| March 20, 2026 | issue | SO-260320-728 | MAIN | 10 | 35.26 | -352.57 | 16 | 559.70 | Sept. 11, 2025: 3 @ 35.90; Jan. 28, 2026: 7 @ 34.98 |
| Jan. 28, 2026 | receipt | PO-001181 | MAIN | 23 | 34.98 | 804.56 | 26 | 912.27 | |
| Jan. 23, 2026 | issue | SO-260123-593 | EAST | 2 | 35.90 | -71.80 | 3 | 107.71 | Sept. 11, 2025: 2 @ 35.90 |
| Jan. 23, 2026 | issue | SO-260123-593 | MAIN | 8 | 35.90 | -287.22 | 5 | 179.51 | Sept. 11, 2025: 8 @ 35.90 |
| Nov. 30, 2025 | issue | SO-251130-715 | MAIN | 9 | 35.90 | -323.12 | 13 | 466.73 | Sept. 11, 2025: 9 @ 35.90 |
| Oct. 30, 2025 | issue | SO-251030-514 | MAIN | 6 | 35.15 | -210.91 | 22 | 789.85 | July 30, 2025: 5 @ 35.00; Sept. 11, 2025: 1 @ 35.90 |
| Sept. 11, 2025 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| Sept. 11, 2025 | receipt | PO-000832 | MAIN | 23 | 35.90 | 825.75 | 28 | 1,000.76 | |
| Sept. 6, 2025 | issue | SO-250906-150 | MAIN | 9 | 35.00 | -315.02 | 5 | 175.01 | July 30, 2025: 9 @ 35.00 |
| Aug. 12, 2025 | issue | SO-250812-819 | MAIN | 9 | 35.00 | -315.02 | 14 | 490.03 | July 30, 2025: 9 @ 35.00 |
| July 30, 2025 | receipt | PO-000742 | MAIN | 23 | 35.00 | 805.04 | 23 | 805.04 | |
| July 24, 2025 | issue | SO-250724-603 | MAIN | 12 | 34.84 | -418.04 | 0 | 0.00 | Oct. 1, 2024: 12 @ 34.84 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 12 | 34.84 | 418.04 | 12 | 418.04 | |