1. How do you steer your ongoing sites with the « Planned vs Actual » cross-table?
The principle is simple: compare, package by package, what you sold and what the site really consumes. The gap warns you while it is still possible to correct.
1.1 Live comparison by CFC package: hours sold in the quote versus hours actually logged on the site
Each CFC package receives the hours budget of the quote and the hours logged by the team. A gauge compares the percentage of hours consumed with the percentage of physical progress: if you have consumed 60% of the hours for 40% of progress, the alert turns red and you know where to look.
1.2 Tracking of material supplier invoices (with a waste rate of 5% to 15%) and of subcontractor statements
The second table compares the planned materials (quantities of the quote increased by the waste rate, from 5% to 15% depending on the trade) with the invoices received, and picks up the subcontractors' statements. The planned margin and the actual margin are displayed side by side, package by package.
Adding a percentage to your costs and calculating a margin on the selling price do not give the same result. The confusion is frequent and costly.
2.1 The mathematical demonstration: why adding +20% to your costs gives only 16.67% margin on the selling price
A cost of CHF 100 marked up by 20% sells for CHF 120; the profit of CHF 20 represents 20 / 120, i.e. 16.67% of the selling price. To really obtain a 20% margin, you must divide the cost by 0.80, that is, mark up by 25%. The workbook formula is cost / (1 − margin rate).
2.2 The mid-course alert rule: act when the site is at 50% progress rather than discovering the loss at the fiduciary 6 months later
At 50% progress, half the site is still left to correct: invoice a change order, renegotiate a daywork rate, change the productivity rate. After acceptance, only the loss remains. Set yourself a control point at mid-site and an alert threshold (hours consumed above progress).
3. Frequently asked questions about margin calculation and profitability in construction (FAQ)
3.1 What multiplier coefficient should be applied to the purchase of materials to cover waste, transport and overheads?
There is no single coefficient: take the waste rate of the material (5% to 15%), add transport and handling, then the share of overheads. To obtain a target margin, then divide by (1 − margin rate), for example 0.85 for 15%.
3.2 How often should the profitability grid of an ongoing site be updated?
Every week for logged hours, every month for supplier invoices and subcontractor statements, and systematically at 25%, 50% and 75% progress. A grid kept up to date takes less than ten minutes a week.
3.3 How do you include unbilled work in progress (TEC) at the accounting close on 31 December?
Work carried out but not invoiced at the closing date is recorded as an asset, valued at cost or, depending on the method chosen, at the partial selling price, under the rules of the Code of Obligations (CO) on the presentation of accounts. Your fiduciary sets the method; our closing calendar lists the deadlines.
Keywords covered: calculate site margin excel · dashboard tracking building site profitability · cost control construction Swiss SMEs · tracking planned vs logged hours excel · difference between margin rate and markup rate craftsman · alert threshold hours overrun site.
The articles of the Code of Obligations (CO), the Civil Code (CC), the Criminal Code (CP), the Debt Enforcement Act (LP), the AVS Act (LAVS), the Accident Insurance Act (LAA) and the Posted Workers Act (LDet) cited were re-read on Fedlex on 6 November 2026. The articles of the SIA 118 standard, which is not freely available, are given according to our fact sheets and must be checked in the edition applicable to your contract. Updated: 7 November 2026.