Aller au contenu
Website
Format: XLSX / PDF Standard: Excel · PDF · CFC · management DOC 05

Excel Grid for Tracking Site Profitability (Planned Budget vs Actual Costs Comparison by CFC)

Hours sold versus hours clocked, planned materials versus invoices, subcontracting: the alert before the margin disappears.

Interactive tool: productivity-rate gap, projected net result and red alert at mid-site

Loading the tool…

📄 The « Brut de chantier » pack to download (free)

XLSXPDF

Site Profitability Grid (Planned vs Actual)

Hours sold versus hours clocked, planned materials versus invoices, subcontracting: the alert before the margin disappears.

  • Table per CFC package: hours, materials, subcontracting
  • Alert gauge: hours budget consumed above physical progress
  • Planned margin against actual margin
  • PDF: user guide for the grid and blank planned / actual table to print

Excel workbook (.xlsx) with formulas · Printable PDF document

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.

2. Why confusing « Markup » and « Margin Rate » loses craftsmen money

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.

📥 Ready-to-use pack · free

Download the document

The file is displayed on screen right away and we also send it to you by e-mail.

Your address is used to send you this file. See our privacy policy.