Your bill and your schedule have never met.

This is the join. Everything in Track 1 lived on one side of it, everything in Track 2 so far has lived on the other, and this is the week they are welded together.

Why they do not agree

The bill is sorted by trade. All the reinforcement in one place, all the concrete in another, all the formwork in a third. It has to be. It is a measurement document, written to a standard method, so that six contractors can price the same job and the client can compare the answers.

The schedule is sorted by sequence and location. Pile cap A, then pile cap B, then the ground beams. It has to be. It is a construction document, written to describe the order in which a building can physically come out of the ground.

Neither of them is wrong. They were built by different people, in different offices, for different readers, in different weeks.

And they are never going to reconcile themselves.

Look at what that picture actually says. It is not a tidy one-to-one join. It is a mess, and the mess has three separate shapes.

One bill item lands on many activities. The 200 tonnes of steel are placed by fourteen different crews on fourteen different dates.

One activity draws on many bill items. “Pile cap A” consumes reinforcement, concrete, formwork and excavation — four different lines of the bill, four different trades.

And some things exist on only one side. Erecting the tower crane is a real activity that costs real money and appears in no measured item. The preliminaries are $85,200 of real cost that no activity places. A provisional sum is $30,000 sitting in the bill with no scope attached to it at all.

The shortcut everybody takes

Faced with this, the planner does the obvious thing. Fourteen activities, one item, $289,388. Divide.

Twenty thousand six hundred and seventy dollars per activity. Job done, coffee, lunch.

It is the single most destructive thing you can do to a cost report, and I have watched it happen on three continents.

What it costs

Here is the same reinforcement package, mapped properly — not by percentage, but by tonnes. Where the steel actually is.

Notice the shape of it. The substructure — pile caps, beams, rafts — is ten activities and only 93 tonnes. The slabs and the core are four activities and 86 tonnes. The heavy steel is at the top of the building, and the top of the building is at the end of the programme.

Now go to the data date. Ten of the fourteen activities are complete. The substructure is finished, the columns are up. On site, 114 tonnes of steel are in the ground.

Actual cost to date on the package: $190,000. Real invoices. Real steel. That number is not in dispute.

Spread the item evenly and you claim ten-fourteenths of it — $206,706 of earned value — and your CPI is 1.09. Under budget. The report is green. Nobody asks a question.

Map it by tonnes and you have earned $164,951, and your CPI is 0.87. You are losing thirteen cents in every dollar, and you have four activities left holding 86 tonnes of the heaviest, most congested, slowest steel on the job.

Same site. Same steel. Same invoices. Twenty-two points of CPI, created entirely by a spreadsheet decision that took four seconds.

And look at the number the bad map produced. 1.09. You have seen it before — it was the false green in Week 1, when the steel invoice had not landed yet. Two completely different lies, arriving at the same comfortable number. That is not a coincidence. Comfortable numbers are what broken systems produce.

How to actually build the map

It is a matrix. Bill items down the side, activities across the top, and in each cell the quantity of that item consumed by that activity.

Three rules, and they are not negotiable.

Every row must close. The allocations across a row sum to the bill quantity. Two hundred tonnes in the bill, two hundred tonnes in the matrix. If it does not close, you have either lost scope or invented it, and both will find you.

Every activity must have a home. Erecting the crane, dewatering, mobilising — if an activity carries cost and no bill item, it belongs to preliminaries, and preliminaries get spread by time, not by work. They are the cost of being there, so they are earned by being there.

Every bill item must have an owner. A provisional sum with no scope cannot be mapped to an activity, because there is no activity. Hold it outside the baseline, visibly, until the scope arrives. The day it becomes real work, it enters the map and the budget moves — formally, with a change record.

That matrix is not administration. It is the object that makes every number in the rest of this track possible. Time-phase it and you have planned value. Measure against it and you have earned value. Group it and you have control accounts.

Why planners resist it

Because it is dull, it takes two days, and nobody asks for it.

And because it exposes people. The moment the map exists, you can see that activity “Slab L3 — rebar” is carrying $28,939 of steel and has a four-day duration with a gang of seven, which means somebody is expecting five tonnes a day, which means the estimator's assumption from Week 2 is now sitting on the critical path where the site manager can read it.

That is the point. The map is what turns a commercial folder into a construction plan.

Practical insight

Take your largest bill item. Find every activity in your schedule that places some of it. Write the quantities in a column and add them up.

If the column does not equal the bill quantity, stop — you have just found the gap between what you sold and what you plan to build, and you found it before the client did.

If it does close, you now own the most valuable spreadsheet on the project, and you can answer a question nobody else on the job can: how much of this item should be complete today?

Key takeaways

✔ The BoQ is sorted by trade. The schedule is sorted by sequence. They will never reconcile themselves.
✔ The join is many-to-many: one item across many activities, one activity across many items.
✔ Some activities have no bill item (crane, dewatering). Some bill items have no activity (prelims, provisional sums). Both must be handled explicitly.
✔ Spreading an item evenly across its activities inflated earned value by $41,755 and turned a CPI of 0.87 into 1.09.
✔ Allocate quantities, not percentages. Every row must close back to the bill.
✔ Preliminaries are earned by time, not by work — they are the cost of being there.
✔ The mapping matrix is the object that makes planned value, earned value and control accounts possible. Nothing works without it.

What is coming next

Two rows in that map do not behave like the others.

One is the $85,200 of preliminaries — a number that grows if the job runs late, whether or not a single extra tonne of steel is fixed. The other is the $47,553 of contingency, which is not a cost at all. It is a bet.

Next week: who owns the contingency, how it is sized, and why the day a project manager quietly spends it to hide a variance is the day your forecast stops meaning anything.