Items / CSM-0008
Cable Lubricant Nova CSM-0008 · Consumables · ToolMasters Industrial
On hand (TUBE)4MAIN 4
Value (FIFO)119.03avg 29.76
ClassCZ / FCV 1.05
Turnover4.5xlast issue 14 days ago
Days of cover70lead 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.75 / 30.4375 | 0.057 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 1.83 / 5.517 | 0.332 |
| 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.332^2 + 0.057^2 * 1.2^2) | 1.0 |
| Reorder point | d * LT + safety stock | 0.057 * 5.0 + 1.0 | 1.2 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.2 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 21/yr, S = 45.00, h = 20%, price = 30.84 | 17.5 |
| Inventory position | on hand + on order | 4 + 0 | 4 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 30.84 | 17 | 755 | yes (chosen if cheapest) |
MOQ 15, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| Feb. 21, 2026 | 4 / 24 | 29.76 | 119.03 | Nov. 18, 2026 |
Movement ledger 18 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| Oct. 2, 2026 | issue | SO-261002-141 | MAIN | 8 | 29.76 | -238.06 | 4 | 119.03 | Feb. 21, 2026: 8 @ 29.76 |
| Sept. 13, 2026 | issue | SO-260913-760 | MAIN | 4 | 29.76 | -119.03 | 12 | 357.08 | Feb. 21, 2026: 4 @ 29.76 |
| Aug. 10, 2026 | issue | SO-260810-847 | MAIN | 4 | 29.76 | -119.03 | 16 | 476.11 | Feb. 21, 2026: 4 @ 29.76 |
| July 1, 2026 | issue | SO-260701-570 | MAIN | 4 | 29.76 | -119.03 | 20 | 595.14 | Feb. 21, 2026: 4 @ 29.76 |
| Feb. 21, 2026 | receipt | PO-001248 | MAIN | 24 | 29.76 | 714.17 | 24 | 714.17 | |
| Feb. 16, 2026 | issue | SO-260216-538 | MAIN | 4 | 28.84 | -115.36 | 0 | 0.00 | March 22, 2025: 4 @ 28.84 |
| Jan. 29, 2026 | issue | SO-260129-218 | MAIN | 2 | 28.84 | -57.68 | 4 | 115.36 | March 22, 2025: 2 @ 28.84 |
| Oct. 26, 2025 | issue | SO-251026-319 | MAIN | 3 | 28.84 | -86.52 | 6 | 173.05 | March 22, 2025: 3 @ 28.84 |
| Sept. 19, 2025 | issue | SO-250919-535 | MAIN | 4 | 28.84 | -115.36 | 9 | 259.57 | March 22, 2025: 4 @ 28.84 |
| July 1, 2025 | issue | SO-250701-559 | MAIN | 4 | 28.84 | -115.36 | 13 | 374.93 | March 22, 2025: 4 @ 28.84 |
| June 28, 2025 | issue | SO-250628-800 | MAIN | 4 | 28.84 | -115.36 | 17 | 490.30 | March 22, 2025: 4 @ 28.84 |
| May 3, 2025 | issue | SO-250503-360 | MAIN | 3 | 28.84 | -86.52 | 21 | 605.66 | March 22, 2025: 3 @ 28.84 |
| March 22, 2025 | receipt | PO-000364 | MAIN | 24 | 28.84 | 692.18 | 24 | 692.18 | |
| March 16, 2025 | issue | SO-250316-218 | MAIN | 5 | 29.30 | -146.49 | 0 | 0.00 | Oct. 1, 2024: 5 @ 29.30 |
| Feb. 6, 2025 | issue | SO-250206-814 | MAIN | 5 | 29.30 | -146.49 | 5 | 146.49 | Oct. 1, 2024: 5 @ 29.30 |
| Dec. 5, 2024 | adjustment | Cycle count | MAIN | -1 | 29.30 | -29.30 | 10 | 292.98 | Oct. 1, 2024: 1 @ 29.30 |
| Nov. 12, 2024 | issue | SO-241112-308 | MAIN | 4 | 29.30 | -117.19 | 11 | 322.28 | Oct. 1, 2024: 4 @ 29.30 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 15 | 29.30 | 439.47 | 15 | 439.47 |