Methodology
Formula & assumptions
Base sleeve length
penetration count × average cut length
Use groups when assembly thicknesses differ.
Purchase target
base length × (1 + cut allowance)
Keeps offcut reserve visible.
Stock pieces
target ÷ sold stock length, rounded up
Final rounding occurs at the supplier unit.
Purchased stock
whole pieces × sold stock length
Shows stock surplus separately from required cut length.