من جدول الكميات إلى الهامش المتوقع: ضبط تكلفة المقاولات في ERPFrom BOQ to Forecast Margin: How Construction ERP Cost Control Actually Works

Most contracting companies build the Bill of Quantities (BOQ) carefully at tender stage, and then it becomes a side spreadsheet nobody revisits until there's a dispute. The problem is that the approved budget and actual spend get tracked in two different places, so the company finds out there's a margin problem after the project closes — not while it can still act. The difference between the two approaches is simple: does the BOQ turn into a live cost structure that updates every day, or does it stay a frozen pricing document?

From Bill of Quantities to a Real Cost Structure

The first step is linking every BOQ line item to a WBS (Work Breakdown Structure) node and a specific cost center. In a system like Odoo, this happens through Analytic Accounting: every project gets its own analytic plan, and every cost center under it (materials, labor, subcontractors) gets its own analytic code. Every purchase invoice, timesheet hour, or progress claim posts automatically to the right code, instead of being manually reconciled in a spreadsheet at month-end. This isn't a feature that works out of the box — it requires configuration and mapping to your company's actual cost structure, and that's exactly what happens during setup.

Budget vs. Actual Isn't Enough on Its Own

Most tracking tools stop at "budget vs. actual" — two numbers. The problem is those two numbers say nothing about the future: if you've spent 10% of the budget and completed only 5% of the project, budget-vs-actual will tell you "still within range," while in reality you're heading for a clear overrun. That's why you need a third number: the projected cost at completion.

A single project card — contract value, certified value, spend, and forecast profit in one view, updating with every transaction.

The number that matters here is "forecast margin" and the Cost Performance Index (CPI) — not just "how much have you spent," but "is this project trending toward profit or loss if it continues at this rate." That's the real difference between a system that records what happened and a system that shows you what's coming.

ETC, EAC, and VAC: Knowing Your Final Project Cost Before It's Final

Getting to that "forecast margin" number requires three linked calculations — these aren't marketing terms, they're standard Earned Value Management metrics:

• ETC (Estimate to Complete) — the projected cost to finish the remaining work, based on the current spend rate per cost center.
• EAC (Estimate at Completion) — the total projected cost for the whole project = actual cost to date + open commitments + ETC.
• VAC (Variance at Completion) — the difference between the original budget and EAC. A negative VAC means the project is trending over budget, and by how much.

The real value is that these calculations run per cost center (materials, labor, subcontractors), not just at the whole-project level. That means you can pinpoint exactly which element is threatening the margin, instead of just sensing that "something's off" without knowing where.

Cost-to-completion control — budget, ETC, EAC and VAC broken down by cost component (material, labor, subcontract) and WBS node, with the largest cost risks ranked automatically.

Ranked Risk Instead of Guesswork

Once you have EAC and VAC per cost component, you can rank them by size: "largest forecast overrun" and "largest budget-fallback exposure" (meaning cost items still resting on an assumption rather than a confirmed price). That turns "I have a feeling cost is a problem" into a specific sentence: this exact item, this exact amount, needs a decision now. That difference matters a lot when you're in front of a management committee or a funding bank.

Starting Gradually: One Project Before the Whole Portfolio

As with any change in how you work, it's best to start with one active project: map its BOQ to a clear WBS and cost centers, and run ETC/EAC/VAC calculations on it for a month. You'll clearly notice the difference between the old "budget vs. actual" view and the new "forecast cost at completion" view, and then you can roll it out to the rest of the portfolio with confidence. This step isn't separate from tracking contracts, variation orders, and progress claims — both draw on the same data, and every time the contract updates, EAC updates with it automatically.

To see how it all connects in practice, take a look at the Odoo ERP for construction page, which walks through these exact screens. If you're comparing ERP systems before deciding, see our guide to the best ERP system in Saudi Arabia 2026. Or book a free consultation and we'll review your current project's cost structure together.