02 · Power BI · SQL · DAX
Project profitability
A project looks healthy until the final account.
Compare budget with actual cost, find the variance and run a delay.
Demo on fictional data — never customer data.
Pick an open project. A delay recalculates expected final cost from booked labour per week.
- Budget
- €185,000
- Actual
- €141,700
- Progress
- 65.0%
- Expected final cost
- €218,000
- Expected margin
- 14.8%
- Target margin
- 30.0%
135 hours above earned hours. Material price is €30 above budget. A 0-week delay adds €0.
Verwachte eindkosten =
DIVIDE ( [Werkelijke kosten], [Voortgang] )
Verwachte marge =
DIVIDE (
[Contractwaarde] - [Verwachte eindkosten],
[Contractwaarde]
)EAC = actual cost / progress · €218,000