KPIs

Overview

This document is used to keep track of the most important calculations in the Holvoet Power BI dashboards.

\({Omzet}_{MTD} = {Omzet}_{PTD} - {Omzet}_{PTD-1}\)

\({COS} = SUM(Kosten Gefactureerd tot nu)\)

\({COS}_{MTD} = {Omzet}_{PTD} - {Omzet}_{PTD-1}\)

\({BM}_{MTD} = {Omzet}_{MTD} - {COS}_{MTD}\)

\({BM\%}_{MTD} = \frac{BM_{MTD}}{Omzet_{MTD}}\)

\({Order}_{PTD} = SUM(Totaal order project, Date <= MAX(Date))\)

\({B\%} = \frac{Basisorder - Budget}{Basisorder}\)

\({Omzet}_{PTD} = \frac{{COS}_{PTD}}{1-IF(ProjectPhase > 6), {R\%}_{EOP}, MIN({R\%}_{EOP}, B\%)}\)

\({BM\%}_{PTD} = \frac{BM_{PTD}}{Omzet_{PTD}}\)

\({PB / S}_{PTD} = ({COS}_{PTD} * R\%_{EOP}) - ({COS}_{PTD} * B\%)\)

\({PB / S}_{EOP} = (COS_{EOP} * R\%_{EOP}) - (COS_{EOP} * B\%)\)

\({CASH}_{PTD} = {Gefactureerd}_{PTD} - {Omzet}_{PTD}\)