Items / TLS-0006
Digital Multimeter Classic TLS-0006 · Tools & Testers · ToolMasters Industrial
On hand (EA)7MAIN 7
Value (FIFO)1,614.58avg 230.65
ClassBZ / FCV 1.20
Turnover3.9xlast issue 49 days ago
Days of cover46lead 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.67 / 30.4375 | 0.153 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 5.60 / 5.517 | 1.016 |
| 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 * 1.016^2 + 0.153^2 * 1.2^2) | 3.7 |
| Reorder point | d * LT + safety stock | 0.153 * 5.0 + 3.7 | 4.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 4.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 56/yr, S = 45.00, h = 20%, price = 234.37 | 10.4 |
| 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 | 234.37 | 10 | 13,602 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| April 10, 2026 | 7 / 22 | 230.65 | 1,614.58 |
Movement ledger 30 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Aug. 28, 2026 | issue | SO-260828-313 | MAIN | 6 | 230.65 | -1,383.92 | 7 | 1,614.58 | April 10, 2026: 6 @ 230.65 |
| Aug. 28, 2026 | issue | SO-260828-313 | EAST | 7 | 230.65 | -1,614.58 | 13 | 2,998.50 | April 10, 2026: 7 @ 230.65 |
| July 6, 2026 | adjustment | Cycle count | MAIN | -2 | 230.65 | -461.31 | 20 | 4,613.08 | April 10, 2026: 2 @ 230.65 |
| April 10, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| April 10, 2026 | receipt | PO-001396 | MAIN | 22 | 230.65 | 5,074.38 | 22 | 5,074.38 | |
| April 4, 2026 | issue | SO-260404-400 | MAIN | 2 | 230.92 | -461.84 | 0 | 0.00 | Jan. 14, 2026: 2 @ 230.92 |
| April 4, 2026 | issue | SO-260404-400 | EAST | 7 | 230.92 | -1,616.43 | 2 | 461.84 | Jan. 14, 2026: 7 @ 230.92 |
| March 27, 2026 | adjustment | Cycle count | MAIN | -1 | 230.92 | -230.92 | 9 | 2,078.26 | Jan. 14, 2026: 1 @ 230.92 |
| Feb. 4, 2026 | issue | SO-260204-656 | MAIN | 12 | 230.92 | -2,771.02 | 10 | 2,309.18 | Jan. 14, 2026: 12 @ 230.92 |
| Jan. 14, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Jan. 14, 2026 | receipt | PO-001145 | MAIN | 22 | 230.92 | 5,080.20 | 22 | 5,080.20 | |
| Jan. 8, 2026 | issue | SO-260108-221 | MAIN | 12 | 227.41 | -2,728.89 | 0 | 0.00 | Sept. 28, 2025: 12 @ 227.41 |
| Nov. 3, 2025 | issue | SO-251103-448 | MAIN | 10 | 227.41 | -2,274.08 | 12 | 2,728.89 | Sept. 28, 2025: 10 @ 227.41 |
| Sept. 28, 2025 | receipt | PO-000881 | MAIN | 22 | 227.41 | 5,002.97 | 22 | 5,002.97 | |
| Sept. 24, 2025 | issue | SO-250924-594 | EAST | 5 | 227.50 | -1,137.50 | 0 | 0.00 | July 15, 2025: 5 @ 227.50 |
| Sept. 24, 2025 | issue | SO-250924-594 | MAIN | 6 | 227.50 | -1,365.00 | 5 | 1,137.50 | July 15, 2025: 6 @ 227.50 |
| Aug. 9, 2025 | issue | SO-250809-248 | MAIN | 11 | 227.50 | -2,502.50 | 11 | 2,502.50 | July 15, 2025: 11 @ 227.50 |
| July 15, 2025 | transfer | TRF | MAIN → EAST | 5 | warehouse transfer, no cost effect | ||||
| July 15, 2025 | receipt | PO-000713 | MAIN | 22 | 227.50 | 5,004.99 | 22 | 5,004.99 | |
| July 9, 2025 | issue | SO-250709-558 | MAIN | 10 | 215.59 | -2,155.90 | 0 | 0.00 | Feb. 9, 2025: 10 @ 215.59 |
| May 26, 2025 | issue | SO-250526-714 | MAIN | 9 | 215.59 | -1,940.31 | 10 | 2,155.90 | Feb. 9, 2025: 9 @ 215.59 |
| April 26, 2025 | issue | SO-250426-579 | MAIN | 5 | 214.37 | -1,071.84 | 19 | 4,096.21 | Oct. 27, 2024: 2 @ 212.54; Feb. 9, 2025: 3 @ 215.59 |
| Feb. 9, 2025 | receipt | PO-000252 | MAIN | 22 | 215.59 | 4,742.98 | 24 | 5,168.05 | |
| Feb. 4, 2025 | issue | SO-250204-205 | MAIN | 8 | 212.54 | -1,700.30 | 2 | 425.07 | Oct. 27, 2024: 8 @ 212.54 |
| Nov. 12, 2024 | issue | SO-241112-323 | MAIN | 12 | 212.54 | -2,550.45 | 10 | 2,125.37 | Oct. 27, 2024: 12 @ 212.54 |
| Oct. 27, 2024 | receipt | PO-000013 | MAIN | 22 | 212.54 | 4,675.82 | 22 | 4,675.82 | |
| Oct. 22, 2024 | issue | SO-241022-201 | MAIN | 8 | 222.65 | -1,781.21 | 0 | 0.00 | Oct. 1, 2024: 8 @ 222.65 |
| Oct. 22, 2024 | issue | SO-241022-201 | EAST | 3 | 222.65 | -667.95 | 8 | 1,781.21 | Oct. 1, 2024: 3 @ 222.65 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 11 | 222.65 | 2,449.17 | 11 | 2,449.17 | |