Items / TLS-0002
Digital Multimeter Prime TLS-0002 · Tools & Testers · ToolMasters Industrial
On hand (EA)14MAIN 7, EAST 7
Value (FIFO)765.48avg 54.68
ClassCY / FCV 0.77
Turnover5.0xlast issue 13 days ago
Days of cover66lead 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 | 6.50 / 30.4375 | 0.214 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 4.97 / 5.517 | 0.902 |
| 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.902^2 + 0.214^2 * 1.2^2) | 2.6 |
| Reorder point | d * LT + safety stock | 0.214 * 5.0 + 2.6 | 3.7 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 3.7 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 78/yr, S = 45.00, h = 20%, price = 55.82 | 25.1 |
| Inventory position | on hand + on order | 14 + 0 | 14 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 55.82 | 25 | 4,631 | yes (chosen if cheapest) |
MOQ 2, pack size 1, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Oct. 2, 2026 | 14 / 20 | 54.68 | 765.48 |
Movement ledger 32 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 3, 2026 | issue | SO-261003-242 | MAIN | 8 | 54.69 | -437.51 | 14 | 765.48 | July 15, 2026: 2 @ 54.72; Oct. 2, 2026: 6 @ 54.68 |
| Oct. 2, 2026 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| Oct. 2, 2026 | receipt | PO-001845 | MAIN | 20 | 54.68 | 1,093.55 | 22 | 1,203.00 | |
| Sept. 27, 2026 | issue | SO-260927-659 | MAIN | 10 | 54.72 | -547.24 | 2 | 109.45 | July 15, 2026: 10 @ 54.72 |
| Aug. 11, 2026 | issue | SO-260811-604 | MAIN | 10 | 54.43 | -544.34 | 12 | 656.69 | April 6, 2026: 2 @ 53.27; July 15, 2026: 8 @ 54.72 |
| July 15, 2026 | receipt | PO-001647 | MAIN | 20 | 54.72 | 1,094.49 | 22 | 1,201.03 | |
| July 10, 2026 | issue | SO-260710-336 | MAIN | 3 | 53.27 | -159.81 | 2 | 106.54 | April 6, 2026: 3 @ 53.27 |
| July 10, 2026 | issue | SO-260710-336 | EAST | 6 | 53.27 | -319.63 | 5 | 266.36 | April 6, 2026: 6 @ 53.27 |
| May 7, 2026 | issue | SO-260507-293 | MAIN | 10 | 53.45 | -534.47 | 11 | 585.98 | Feb. 19, 2026: 1 @ 55.03; April 6, 2026: 9 @ 53.27 |
| April 6, 2026 | transfer | TRF | MAIN → EAST | 6 | warehouse transfer, no cost effect | ||||
| April 6, 2026 | receipt | PO-001388 | MAIN | 20 | 53.27 | 1,065.42 | 21 | 1,120.45 | |
| April 2, 2026 | issue | SO-260402-795 | MAIN | 5 | 55.03 | -275.13 | 1 | 55.03 | Feb. 19, 2026: 5 @ 55.03 |
| March 24, 2026 | issue | SO-260324-105 | MAIN | 14 | 55.03 | -770.36 | 6 | 330.15 | Feb. 19, 2026: 14 @ 55.03 |
| Feb. 19, 2026 | receipt | PO-001242 | MAIN | 20 | 55.03 | 1,100.51 | 20 | 1,100.51 | |
| Feb. 13, 2026 | issue | SO-260213-880 | MAIN | 11 | 54.49 | -599.36 | 0 | 0.00 | Sept. 29, 2025: 11 @ 54.49 |
| Jan. 7, 2026 | issue | SO-260107-234 | MAIN | 9 | 54.49 | -490.38 | 11 | 599.36 | Sept. 29, 2025: 9 @ 54.49 |
| Sept. 29, 2025 | receipt | PO-000885 | MAIN | 20 | 54.49 | 1,089.74 | 20 | 1,089.74 | |
| Sept. 24, 2025 | issue | SO-250924-208 | EAST | 7 | 51.18 | -358.26 | 0 | 0.00 | May 21, 2025: 7 @ 51.18 |
| Sept. 24, 2025 | issue | SO-250924-208 | MAIN | 1 | 51.18 | -51.18 | 7 | 358.26 | May 21, 2025: 1 @ 51.18 |
| Aug. 12, 2025 | issue | SO-250812-263 | MAIN | 12 | 51.18 | -614.16 | 8 | 409.44 | May 21, 2025: 12 @ 51.18 |
| May 21, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| May 21, 2025 | receipt | PO-000557 | MAIN | 20 | 51.18 | 1,023.60 | 20 | 1,023.60 | |
| May 14, 2025 | issue | SO-250514-231 | EAST | 4 | 51.87 | -207.46 | 0 | 0.00 | Nov. 19, 2024: 4 @ 51.87 |
| May 14, 2025 | issue | SO-250514-231 | MAIN | 7 | 51.87 | -363.06 | 4 | 207.46 | Nov. 19, 2024: 7 @ 51.87 |
| March 19, 2025 | issue | SO-250319-130 | MAIN | 12 | 52.16 | -625.88 | 11 | 570.53 | Oct. 1, 2024: 3 @ 53.03; Nov. 19, 2024: 9 @ 51.87 |
| Nov. 19, 2024 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Nov. 19, 2024 | receipt | PO-000043 | MAIN | 20 | 51.87 | 1,037.32 | 23 | 1,196.41 | |
| Nov. 15, 2024 | issue | SO-241115-826 | MAIN | 3 | 53.03 | -159.09 | 3 | 159.09 | Oct. 1, 2024: 3 @ 53.03 |
| Nov. 15, 2024 | issue | SO-241115-826 | EAST | 3 | 53.03 | -159.09 | 6 | 318.17 | Oct. 1, 2024: 3 @ 53.03 |
| Oct. 21, 2024 | adjustment | Cycle count | MAIN | -1 | 53.03 | -53.03 | 9 | 477.26 | Oct. 1, 2024: 1 @ 53.03 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 3 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 10 | 53.03 | 530.29 | 10 | 530.29 | |