Items / CSM-0002
Contact Cleaner Spray Lite CSM-0002 · Consumables · ToolMasters Industrial
On hand (TUBE)9MAIN 9
Value (FIFO)119.02avg 13.22
ClassCZ / SCV 1.91
Turnover0.7xlast issue 0 days ago
Days of cover548lead 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 | 0.50 / 30.4375 | 0.016 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 0.96 / 5.517 | 0.174 |
| 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.174^2 + 0.016^2 * 1.2^2) | 0.5 |
| Reorder point | d * LT + safety stock | 0.016 * 5.0 + 0.5 | 0.6 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 0.6 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 6/yr, S = 45.00, h = 20%, price = 13.99 | 13.9 |
| 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 | 13.99 | 14 | 123 | yes (chosen if cheapest) |
MOQ 17, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 19, 2025 | 9 / 24 | 13.22 | 119.02 | Feb. 13, 2026 |
Movement ledger 12 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 16, 2026 | issue | SO-261016-317 | MAIN | 3 | 13.22 | -39.67 | 9 | 119.02 | May 19, 2025: 3 @ 13.22 |
| July 7, 2026 | issue | SO-260707-503 | MAIN | 1 | 13.22 | -13.22 | 12 | 158.69 | May 19, 2025: 1 @ 13.22 |
| May 2, 2026 | issue | SO-260502-991 | MAIN | 2 | 13.22 | -26.45 | 13 | 171.92 | May 19, 2025: 2 @ 13.22 |
| April 16, 2026 | issue | SO-260416-958 | MAIN | 3 | 13.22 | -39.67 | 15 | 198.37 | May 19, 2025: 3 @ 13.22 |
| Sept. 15, 2025 | issue | SO-250915-248 | MAIN | 4 | 13.22 | -52.90 | 18 | 238.04 | May 19, 2025: 4 @ 13.22 |
| June 8, 2025 | issue | SO-250608-102 | MAIN | 3 | 13.25 | -39.74 | 22 | 290.94 | Oct. 1, 2024: 1 @ 13.29; May 19, 2025: 2 @ 13.22 |
| May 19, 2025 | receipt | PO-000549 | MAIN | 24 | 13.22 | 317.39 | 25 | 330.68 | |
| May 14, 2025 | issue | SO-250514-970 | MAIN | 3 | 13.29 | -39.87 | 1 | 13.29 | Oct. 1, 2024: 3 @ 13.29 |
| March 9, 2025 | issue | SO-250309-150 | MAIN | 5 | 13.29 | -66.45 | 4 | 53.16 | Oct. 1, 2024: 5 @ 13.29 |
| Feb. 6, 2025 | issue | SO-250206-958 | MAIN | 4 | 13.29 | -53.16 | 9 | 119.61 | Oct. 1, 2024: 4 @ 13.29 |
| Oct. 17, 2024 | issue | SO-241017-230 | MAIN | 4 | 13.29 | -53.16 | 13 | 172.78 | Oct. 1, 2024: 4 @ 13.29 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 17 | 13.29 | 225.94 | 17 | 225.94 |