The Construction template combines some of the key metrics construction businesses should focus on. These metrics are split across the Construction - Financial Metrics and Construction Metrics pages in Spotlight. To make the most of the template, you will need to:
Most constructon metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:
You can manually enter the data into the Non-Financial tab under Customise Data. Alternatively, enter the data into this Excel template and import it into Spotlight using the Excel import function on the Import tab.
Most report codes needed for the template are automatically assigned by Spotlight. However, for the metrics to calculate correctly you may need to assign some financial report codes manually. To do this, open Customise Data and locate the following accounts, then to assign the specified report code click the report code button:
Formula: Direct Wages / Trading Revenue * 100
Report codes used: EXP.COS.WAG, REV.TRA
Formula: (Cost of goods sold - Direct Wages) / Trading revenue * 100
Report codes used: EXP.COS, EXP.COS.WAG, REV.TRA
Formula: Cost of Sales
Report codes used: EXP.COS
Formula: (Trading revenue - Cost of goods sold) / Trading revenue * 100
Report codes used: REV.TRA, EXP.COS
Formula: Defects
Report codes used: OPR.DEF
Formula: Health & Safety
Report codes used: OPR.SFY
Formula: Customer Satisfaction
Report codes used: CUS.SAT
Formula: (Time - billable (Actual) / Time - billable (Target) -1) * 100
Report codes used: TIM.BIL
Formula: Time - non-billable / (Time - billable + Time - non-billable) * 100
Report codes used: TIM.BIL, TIM.NON
Formula: Staff - Departures (rolling 12 months) / Staff - Total (average, rolling 12 months) * 100
Report codes used: STA.DEP, STA.TOT
