Items / CSM-0006
Cable Lubricant Nova CSM-0006 · Consumables · ToolMasters Industrial
On hand (TUBE)15MAIN 15
Value (FIFO)406.51avg 27.10
ClassCZ / NCV 1.87
Turnover1.3xlast issue 189 days ago
Days of cover457lead 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 | 1.00 / 30.4375 | 0.033 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.87 / 5.517 | 0.339 |
| 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.339^2 + 0.033^2 * 1.2^2) | 1.0 |
| Reorder point | d * LT + safety stock | 0.033 * 5.0 + 1.0 | 1.1 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.1 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 12/yr, S = 45.00, h = 20%, price = 28.18 | 13.8 |
| 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 | 28.18 | 14 | 416 | yes (chosen if cheapest) |
MOQ 21, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Jan. 21, 2026 | 15 / 24 | 27.10 | 406.51 | Oct. 18, 2026 |
Movement ledger 12 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| April 10, 2026 | issue | SO-260410-645 | MAIN | 3 | 27.10 | -81.30 | 15 | 406.51 | Jan. 21, 2026: 3 @ 27.10 |
| March 22, 2026 | issue | SO-260322-371 | MAIN | 6 | 27.10 | -162.61 | 18 | 487.82 | Jan. 21, 2026: 6 @ 27.10 |
| Jan. 21, 2026 | receipt | PO-001167 | MAIN | 24 | 27.10 | 650.42 | 24 | 650.42 | |
| Jan. 16, 2026 | issue | SO-260116-838 | EAST | 3 | 26.77 | -80.31 | 0 | 0.00 | Oct. 1, 2024: 3 @ 26.77 |
| Sept. 3, 2025 | issue | SO-250903-458 | EAST | 1 | 26.77 | -26.77 | 3 | 80.31 | Oct. 1, 2024: 1 @ 26.77 |
| Sept. 3, 2025 | issue | SO-250903-458 | MAIN | 2 | 26.77 | -53.54 | 4 | 107.08 | Oct. 1, 2024: 2 @ 26.77 |
| Aug. 15, 2025 | issue | SO-250815-151 | MAIN | 2 | 26.77 | -53.54 | 6 | 160.63 | Oct. 1, 2024: 2 @ 26.77 |
| June 6, 2025 | issue | SO-250606-759 | MAIN | 3 | 26.77 | -80.31 | 8 | 214.17 | Oct. 1, 2024: 3 @ 26.77 |
| March 31, 2025 | issue | SO-250331-653 | MAIN | 5 | 26.77 | -133.86 | 11 | 294.48 | Oct. 1, 2024: 5 @ 26.77 |
| Oct. 27, 2024 | issue | SO-241027-339 | MAIN | 5 | 26.77 | -133.86 | 16 | 428.34 | Oct. 1, 2024: 5 @ 26.77 |
| Oct. 1, 2024 | transfer | TRF | MAIN → EAST | 4 | warehouse transfer, no cost effect | ||||
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 21 | 26.77 | 562.19 | 21 | 562.19 | |