/
Case study
Case Study
BGC Housing Group
Industry
Residential Construction
The Situation
BGC Housing Group stopped selling retail homes in April 2023, management and Board priorities shifted and its reporting had to shift also
The Opportunity
As construction costs continued to rise and labour shortages lengthened build times, cash flow and working capital management became critical reporting items. Additionally, providing for these increased costs required deep modelling expertise and auditor management
The Solution
✓ Developed new management reporting process and output
Based on shifting priorities and what key stakeholders needed visibility on, reporting outputs and process were reconfigured. Tight, systemised process meant accurate, insightful month end reports for management and Board were delivered on time
✓ Developed Powerbi dashboard for WIP reporting
WIP gross margin varied widely across builds depending on brand, spec (single / multistorey) , and when the build began. Dashboard enabled the team to dig deeper into the numbers month on month to identify trends and inform actions
✓ Developed cashflow model that separated single, double and triple storey builds
Economics on single and multistorey jobs were fundamentally different, but this was less of a problem initially when there were so many single storey builds on ground. As jobs on ground reduced, mix of multistorey builds increased throwing out forecast which was built on averages. New model, built up from job level scheduling, delivered more accuracy
✓ Built out provision model and managed audit process
Combination of post COVID stimulus and a WA construction labour shortage drove a fundamental mismatch between supply and demand driving unprecedented levels of construction inflation. Modelling what this provision should be at a job level was a complex process that we owned and managed throughout the audit process

