top of page

Pipe Stock-Length Planning: Equal Takeoff Metres Can Need Different Orders

Oct 17
5 min read
Original teal and pale-lime Nexora cover showing two pipe cut patterns with equal total finished length but requirements for twelve and fifteen stock bars.

Two approved piece schedules each contain 69.6 m of pipe in 24 pieces. One can be produced from twelve 6 m stock lengths; the other needs fifteen. An order based only on total metres and a generic allowance cannot see that difference. Procurement needs the distribution of finished piece lengths and the constraints on how those pieces may share a stock length.


This is a quantity-planning exercise, not a cutting procedure or installation detail. It begins after the responsible team has established finished piece lengths, fitting allowances and connection details. No extra joint may be introduced merely to make a cutting pattern fit. Product preparation requirements, fabrication tolerances and the actual available stock remain project inputs.


Keep the individual pieces in the procurement model


A total length is a useful reconciliation, but it discards information. Once several short pieces are pooled with a long piece, their combined length must fit within one available stock length after losses and unusable portions. Unused length in one bar cannot automatically make an overlength pattern on another bar possible.


Google’s OR-Tools bin-packing example describes assigning individual items to capacity-limited bins while minimizing the number of bins. For pipe procurement, stock lengths act as the bins, with additional fabrication constraints. Gurobi’s cutting-stock example similarly builds patterns that satisfy piece-size demands. These sources establish the optimization idea; the pipe data and calculations below are original teaching examples.


Build each planning group from genuinely interchangeable stock: the same material, diameter, wall thickness, approved specification and relevant traceability requirements. Then include piece ID, finished length, required quantity, need date and any restriction on stock assignment. A usable remainder of another pipe size cannot offset the shortage just because its length appears in the same spreadsheet.


State the kerf and usable-length assumptions


Both example schedules use 6.000 m stock lengths of one hypothetical pipe item, available without quantity limits. Assume every stock length has 6.000 m usable before cutting, no separate end-trim requirement, and no pre-existing offcuts. Charge a 0.003 m saw kerf for every finished piece released. All shown patterns leave a tail, so each finished piece requires its stated cut in this simplified model.


A pattern containing n finished pieces is feasible only if the sum of their lengths plus n × 0.003 m is no greater than 6.000 m. This is an explicit model convention, not a universal kerf or cutting rule. Actual tools, cutting sequences, end squaring, clamping allowances and material preparation can change usable length and cut count. The fabrication team must supply those inputs.


Schedule A: a pairing that achieves the lower bound


Schedule A requires twelve pieces at 3.200 m and twelve pieces at 2.600 m. Net finished length is 12 × 3.200 + 12 × 2.600 = 69.600 m. There are 24 finished pieces, so modeled kerf totals 24 × 0.003 = 0.072 m. The length-only lower bound is the next whole number above (69.600 + 0.072)/6.000, giving twelve stock lengths.


A feasible pattern uses one 3.200 m piece and one 2.600 m piece per bar. Consumption is 3.200 + 2.600 + 2 × 0.003 = 5.806 m, leaving a 0.194 m tail. Repeating that pattern twelve times exactly supplies both required quantities. Because the feasible plan uses the same twelve bars as the lower bound, twelve is the minimum under the stated assumptions.


Its physical balance is 72.000 m purchased = 69.600 m finished pieces + 0.072 m kerf + 2.328 m tails. The tails are physical remnants; whether they are retained or discarded is a separate decision. Keep the balance visible rather than calling the entire difference between purchased and finished length “saw loss.”


Schedule B: the same metres need fifteen bars


Schedule B instead requires six pieces at 4.400 m and eighteen pieces at 2.400 m. It still contains 69.600 m in 24 pieces, with the same 0.072 m modeled kerf. Its length-only lower bound is also twelve bars, but no allocation can achieve that bound.


Each 4.400 m piece needs its own bar. It cannot share with even one 2.400 m piece because 4.400 + 2.400 + 0.006 = 6.806 m. Those six bars therefore cannot supply any of the eighteen shorter pieces. At most two 2.400 m pieces fit in each additional bar, so the shorter pieces require at least nine more bars. The lower bound from the actual piece combination is six plus nine, or fifteen.


  1. Use six bars with one 4.400 m piece each. Every bar leaves 6.000 − 4.400 − 0.003 = 1.597 m.

  2. Use nine bars with two 2.400 m pieces each. Every bar leaves 6.000 − 4.800 − 0.006 = 1.194 m.

  3. The plan uses fifteen bars and supplies all 24 pieces, proving that the fifteen-bar lower bound is achievable.


Its balance is 90.000 m purchased = 69.600 m finished pieces + 0.072 m kerf + 20.328 m tails. Compared with A, the additional 18.000 m of input is caused by the piece-length combination. It is not evidence that someone measured eighteen metres of extra installed pipe.


Original pipe allocation comparison: Schedule A uses twelve bars each with a 3.2 metre and 2.6 metre piece; Schedule B uses six bars each with one 4.4 metre piece plus nine bars each with two 2.4 metre pieces. Both schedules total 69.6 metres and 24 pieces.

Original quantity-only example. Stock is 6.000 m usable, kerf is 0.003 m per finished piece, and end trims are zero. Every pictured pattern leaves a tail. No added joints are permitted.


Why a percentage allowance misses the decision


A hypothetical 5% addition to either net takeoff gives 69.600 × 1.05 = 73.080 m. Rounding that amount to 6 m stock lengths gives thirteen bars. That would exceed Schedule A’s demonstrated requirement by one bar but leave Schedule B two bars short. The percentage has no way to distinguish the two distributions.


Keep a separate allowance only for an identified exposure outside the demonstrated cut plan, such as unresolved geometry or a documented handling provision. Do not add the same cutting loss again after it is already included in feasible patterns. At an early estimating stage, retain the uncertainty explicitly if a sufficiently developed piece schedule is unavailable.


Treat reusable tails as specific inventory


Assume a local planning threshold of 0.500 m for retaining these example remnants, subject to specification, condition and traceability checks. All fifteen Schedule B tails exceed that threshold; Schedule A’s twelve 0.194 m tails do not. A threshold is a stock-management assumption, not proof that a remnant suits the next piece.


If fifteen new approved 1.100 m pieces of the identical item are needed, each B tail can supply one piece plus a 0.003 m cut. Under the same assumptions, that uses 16.500 m for finished pieces and 0.045 m for new kerf, leaving 20.328 − 16.500 − 0.045 = 3.783 m in smaller remnants. No new full bars are required for that additional demand. This is a conditional reuse calculation, not a promise that the tails will be usable on another job.


Reserve each remnant once, identify its actual length and storage location, and link it to the destination piece. Keep unsuitable or unverified stock out of the available balance. Gurobi’s multiple-stock cutting example explicitly includes initial stock and a remnant-size threshold, illustrating why inventory assumptions belong in the planning model.


Issue an order with a checkable cut allocation


The final purchasing record should connect approved piece IDs to stock IDs or repeated patterns, preserve the kerf and trim convention, and explain unused tails. Check delivery batches and required dates before combining pieces from different work fronts. A mathematically efficient combined plan is unusable if its stock arrives after one crew needs it.


For the broader quantity-to-price workflow, Nexora’s paid MEP Estimators Handbook covers piping takeoff, material pricing, wastage factors and accessory allowances. Use it to strengthen the estimate’s measurement and scope discipline, then prepare the project-specific stock allocation with the fabrication team. The handbook’s stated coverage should not be read as a claim that it includes a cutting-stock optimizer.



Comments

Rated 0 out of 5 stars.
No ratings yet

Add a rating
bottom of page