Optimization & Yield

How Planning Horizon Affects Lumber Recovery Outcomes

How Planning Horizon Affects Lumber Recovery Outcomes

When sawmill planners talk about “optimizing” production, they usually mean making the best decisions for the next shift or the next day. This feels rational — you work with what you know, you keep things manageable. But this approach has a hidden cost that compounds over time.

What is the local-optimum trap in sawmill planning?

Consider a simple example: you have two production lines and a mix of log grades coming in over the next two weeks. Each shift, you allocate the best-fit logs to keep both lines running at maximum throughput. The shift ends. Recovery looks acceptable. You do the same tomorrow.

What you can’t see is that the log grades arriving in day 8 would have unlocked a yield improvement of 4% on Line 1 — but only if Line 2 had run a slightly different pattern in day 3 to prepare the right intermediate stock.

By optimising locally, you’ve permanently closed off a globally better path.

“Optimizing each shift in isolation looks efficient — but it systematically prevents your mill from finding the globally best plan.”

Why does horizon length matter more at scale?

At 50,000 m³/year, the effect is modest. At 200,000+ m³/year, the compounding cost of local optimisation is measured in millions of euros annually. Not because individual decisions are wrong — they’re locally correct — but because the search space for a better global plan was never explored.

What recovery uplift do longer planning horizons deliver?

Across mills we’ve worked with, extending the planning horizon from shift-level to 2–4 weeks consistently improves lumber recovery by 2–5 percentage points.

Planning approachTypical recovery range
Shift-by-shift (manual)58–62%
Day-ahead planning61–65%
2-week horizon optimization64–68%
4-week horizon optimization66–70%

Figures are illustrative averages across softwood operations in Northern Europe.

What Multi-Horizon Planning Actually Does

A multi-horizon planning system holds three timescales simultaneously:

Operational (1–3 days): Detailed shift-level sequences, specific log-to-product assignments, line changeover timing.

Tactical (1–2 weeks): Batch composition, grade allocation, stock build strategy, maintenance windows.

Strategic (2–4 weeks): Demand fulfilment sequencing, log intake pacing, product mix alignment with order book.

Each level informs the others. The tactical layer prevents the operational layer from making locally optimal but globally destructive choices.

The Constraint Interaction Problem

Recovery isn’t just about log quality. It’s about the interaction of constraints:

  • Log grade distribution across intake windows
  • Product specification requirements from the order book
  • Blade wear patterns and maintenance scheduling
  • Drying capacity and kiln sequencing
  • Intermediate stock levels between production stages

Manual planning handles each of these sequentially and approximately. A constraint-aware optimization engine handles them simultaneously and exactly — within the bounds of what’s computationally tractable.

Practical Implication

If your mill currently plans one shift or one day ahead, the path to better recovery isn’t better shift-level decisions. It’s extending the horizon over which decisions are coordinated.

The first step is usually visibility: knowing what logs are arriving when, what orders need to be filled on what timeline, and where the binding constraints actually sit. The second step is optimization over that extended horizon — which is why the choice between spreadsheet-based planning and dedicated software matters more than most mills expect. We examine that gap in detail in our comparison of Excel-based planning versus dedicated sawmill software.

Both are tractable problems with the right tools.



SawmillSmart is a production planning and optimization system for sawmills. Learn more about how it works or talk to us about your operation.

Frequently Asked Questions

How much recovery uplift can a longer planning horizon actually deliver?

Across mills we have worked with, extending from shift-by-shift planning to a 2–4 week rolling horizon typically lifts lumber recovery by 2–5 percentage points. The gain comes from better global log allocation, sequenced drying, and avoiding stock build-ups in the wrong dimensions.

Why does mill size amplify the effect?

Local-optimum losses compound across volume. At 50,000 m³/year the cost is modest; at 200,000+ m³/year, the same percentage loss is measured in millions of euros annually — not because individual decisions are wrong, but because the better global plan is never explored.

What is “multi-horizon” planning?

A planning system that holds three timescales at once: operational (1–3 days, shift-level sequences), tactical (1–4 weeks, log allocation and order sequencing), and strategic (1–3 months, capacity and contract decisions). Each horizon informs the others.

Won’t a longer horizon just produce a plan that changes constantly?

Rolling replanning recalculates the full window on each new input — log delivery slip, urgent order, machine downtime — instead of starting from scratch each morning. The planner reviews and approves changes rather than rebuilding.

Can we get this uplift while staying on Excel?

Realistically, no. A rolling 2–4 week plan with constraint-aware log allocation is structurally beyond a manually-maintained spreadsheet. See why Excel destroys margin in sawmill planning and why horizon length matters more than most sawmills think.

SawmillSmart
Estimate your +5 pp yield uplift

Send us a snapshot of your current planning horizon, order book, and log inventory. We'll model what extending the horizon from shift-level to 2–4 weeks of rolling planning would change for lumber recovery and on-time delivery — using numbers from your own data.

Get a recovery assessment → How rolling planning works