Commercial Foresight ยท Decision support
Forward Order Book
The order book is the operational truth of the business: what it has quoted, won, contracted and scheduled. Reconciled against the external pipeline, it shows the gap between the work forming outside the company and the commitments inside it.
Weighted committed demand
26,475 t
Order book tonnes weighted by commercial stage
External expected demand
8,880 t
Probability weighted signals not yet in the order book (2 linked signals counted once)
Reconciled forecast
35,355 t
Committed plus external, no double counting
Capacity gap
5,355 t
Reconciled demand exceeds period capacity
Two systems, one forecast
External demand forecast
What may happen in the market: where, when, which products and how early the evidence is emerging. It helps the company prepare for work it has not yet won.
Internal order book
What the company has quoted, won, contracted, received purchase orders for and scheduled to deliver. It is the basis for production, sourcing, transport and invoicing plans.
Reconciled commercial forecast
Expected demand plus committed demand plus operational capacity. Combining the two carelessly would double count demand; keeping them disconnected would miss emerging constraints. Linked signals are counted once.
Reconciled commercial forecast
Set the production and haulage capacity for the period. The reconciled forecast is compared against it to expose a future capacity gap before it becomes a missed delivery, an emergency carrier booking or a margin problem.
| Component | Tonnes | Basis |
|---|---|---|
| Committed demand, stage weighted | 26,475 | Order book records weighted by commercial stage |
| External expected demand, unlinked | 8,880 | Signals not yet represented in the order book |
| Reconciled forecast | 35,355 | Committed plus external, linked signals counted once |
| Period capacity | 30,000 | User supplied assumption |
| Capacity gap | 5,355 | Secure production, stock or carriers before the window |
Order book
| Record | Material | Site | Stage | Tonnes | Weighted | Delivery window | Latest change |
|---|---|---|---|---|---|---|---|
| OB 1041 | CBR45 Road Base | Quarry Node 1 | Awarded or contracted | 20,000 | 16,000 | Nov 2026 to Feb 2027 | Variation pending: stage 2 quantities under review |
| OB 1042 | 20mm Aggregate | Quarry Node 4 | Purchase order received | 6,500 | 6,175 | Nov 2026 | Split order: 2,500 t rescheduled to December |
| OB 1043 | 40MPa Ready Mix | Plant 2 | Quoted or negotiated | 3,200 | 1,600 | Dec 2026 | Negotiated rates awaiting countersign |
| OB 1044 | Fine Washed Sand | Quarry Node 4 | Scheduled for delivery | 1,800 | 1,800 | Next 14 days | Delivery slots confirmed with carrier |
| OB 1045 | Drainage Rock | Quarry Node 7 | Delivered and invoiced | 900 | 900 | Completed Oct 2026 | Invoiced; margin reconciliation due |
Quantity changes, delivery date moves, cancellations, variations, split orders and rescheduling are tracked on each record. A 20,000 tonne contract does not necessarily mean 20,000 tonnes will be delivered next month.
Order book stages
| Category | What it means for forecasting | Illustrative weight |
|---|---|---|
| Early market opportunity | Possible future demand; low commitment | 10% |
| Identified project or tender | Potential requirement with developing evidence | 25% |
| Quoted or negotiated | Commercial opportunity; award and volume remain uncertain | 50% |
| Awarded or contracted | Stronger evidence, subject to contractual conditions | 80% |
| Purchase order received | Specific authorised demand, subject to scope and schedule | 95% |
| Scheduled for delivery | Near term operational commitment | 100% |
| Delivered and invoiced | Actual activity for cost, margin and reporting reconciliation | 100% |
Weights are illustrative defaults. Each company maps these categories to its own real workflow and conversion history rather than adopting universal stages.
External pipeline
| Signal | Project | Tonnes | Probability | Status | Evidence |
|---|---|---|---|---|---|
| SIG 01 | Project token North 1 | 20,000 | 90% | Linked: counted once | Linked to order book record OB 1041 |
| SIG 02 | Project token City 4 | 3,200 | 70% | Linked: counted once | Linked to order book record OB 1043 |
| SIG 03 | Project token West 2 | 14,000 | 45% | Unlinked: adds to forecast | Tender documents reference pavement works |
| SIG 04 | Project token South 6 | 8,600 | 30% | Unlinked: adds to forecast | Early contractor involvement announced |
Illustrative assumptions, not live company intelligence. Authorised contracts, production, delivery and finance evidence are required before commercial reliance. Management retains decision authority.
Discuss a pilot