Items / CSM-0004
Contact Cleaner Spray Prime CSM-0004 · Consumables · ToolMasters Industrial
On hand (TUBE)21MAIN 21
Value (FIFO)745.03avg 35.48
ClassCY / SCV 0.90
Turnover1.1xlast issue 77 days ago
Days of cover274lead 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 | 2.33 / 30.4375 | 0.077 |
| Daily demand sd | monthly sd / sqrt(30.4375) | 2.09 / 5.517 | 0.380 |
| 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.380^2 + 0.077^2 * 1.2^2) | 1.1 |
| Reorder point | d * LT + safety stock | 0.077 * 5.0 + 1.1 | 1.5 |
| Order-up-to S | d * (LT + R) + z * sqrt((LT + R) * sd_d^2 + d^2 * sd_LT^2) | R = 0 days | 1.5 |
| EOQ (best price tier) | sqrt(2 * D * S / H), H = holding rate * unit cost | D = 28/yr, S = 45.00, h = 20%, price = 35.22 | 18.9 |
| Inventory position | on hand + on order | 21 + 0 | 21 |
Price break evaluation (annual cost at each tier's EOQ)
| From qty | Unit cost | Order qty | Annual cost | Feasible |
|---|---|---|---|---|
| 0 | 35.22 | 19 | 1,119 | yes (chosen if cheapest) |
MOQ 16, pack size 12, ordering cost 45.00.
Open cost layers
| Received | Left / in | Unit cost | Value | Expiry |
|---|---|---|---|---|
| May 7, 2026 | 21 / 24 | 35.48 | 745.03 | Feb. 1, 2027 |
Movement ledger 16 movements
| Date | Type | Ref | Warehouse | Qty | Unit cost | Value change | Qty after | Value after | Cost layers consumed |
|---|---|---|---|---|---|---|---|---|---|
| July 31, 2026 | issue | SO-260731-350 | MAIN | 4 | 35.13 | -140.51 | 21 | 745.03 | May 27, 2025: 1 @ 34.08; May 7, 2026: 3 @ 35.48 |
| May 7, 2026 | receipt | PO-001472 | MAIN | 24 | 35.48 | 851.46 | 25 | 885.54 | |
| May 4, 2026 | issue | SO-260504-893 | MAIN | 3 | 34.08 | -102.24 | 1 | 34.08 | May 27, 2025: 3 @ 34.08 |
| April 23, 2026 | issue | SO-260423-345 | EAST | 4 | 34.08 | -136.32 | 4 | 136.32 | May 27, 2025: 4 @ 34.08 |
| Feb. 5, 2026 | issue | SO-260205-446 | MAIN | 4 | 34.08 | -136.32 | 8 | 272.64 | May 27, 2025: 4 @ 34.08 |
| Dec. 9, 2025 | issue | SO-251209-744 | EAST | 3 | 34.08 | -102.24 | 12 | 408.95 | May 27, 2025: 3 @ 34.08 |
| Nov. 8, 2025 | issue | SO-251108-180 | MAIN | 4 | 34.08 | -136.32 | 15 | 511.19 | May 27, 2025: 4 @ 34.08 |
| Oct. 6, 2025 | issue | SO-251006-378 | MAIN | 6 | 33.98 | -203.86 | 19 | 647.51 | Oct. 1, 2024: 1 @ 33.46; May 27, 2025: 5 @ 34.08 |
| May 27, 2025 | transfer | TRF | MAIN → EAST | 7 | warehouse transfer, no cost effect | ||||
| May 27, 2025 | receipt | PO-000581 | MAIN | 24 | 34.08 | 817.91 | 25 | 851.37 | |
| May 23, 2025 | issue | SO-250523-297 | MAIN | 3 | 33.46 | -100.38 | 1 | 33.46 | Oct. 1, 2024: 3 @ 33.46 |
| April 10, 2025 | issue | SO-250410-209 | MAIN | 3 | 33.46 | -100.38 | 4 | 133.84 | Oct. 1, 2024: 3 @ 33.46 |
| Jan. 15, 2025 | issue | SO-250115-824 | MAIN | 3 | 33.46 | -100.38 | 7 | 234.21 | Oct. 1, 2024: 3 @ 33.46 |
| Nov. 2, 2024 | issue | SO-241102-238 | MAIN | 3 | 33.46 | -100.38 | 10 | 334.59 | Oct. 1, 2024: 3 @ 33.46 |
| Oct. 25, 2024 | issue | SO-241025-734 | MAIN | 3 | 33.46 | -100.38 | 13 | 434.97 | Oct. 1, 2024: 3 @ 33.46 |
| Oct. 1, 2024 | receipt | PO-000004 | MAIN | 16 | 33.46 | 535.34 | 16 | 535.34 | |