Methodology
Formula & assumptions
Base linear run
segment length × segment count
Total measured run before waste.
Purchase target
base run × (1 + waste %)
Adds cut/handling allowance.
Stock pieces
ceil(target ÷ stock length)
Rounds to whole pieces.
Surplus
purchased length − target
Planning remainder before cut optimization.