Case Study: Powering Wilson Construction with finance insight
Key results
The challenge
Wilson Construction gathered multiple spreadsheets for 100+ projects with estimated monthly billing and compiled them into a single Excel spreadsheet, seeking a holistic view of operations and less spreadsheet dependence.
The solution
Wilson Construction integrated Prophix with its existing ERP rather than replacing it, automating monthly financial statements and work-in-progress (WIP) reports and forecasting production from actual quantities in MS Project.
“We can now forecast production based on actual quantities coming from MS Project and compare it to the budget to determine if a project is tracking on margin.”
MGMarty GardnerCFO, Wilson Construction
The results, in context
Wilson Construction saved up to 4 days per month on weekly reporting and up to 2 weeks per month on GL and WIP reporting, while gaining the ability to recognize margin fade in a timely and accurate manner.