Contract and billing control for Metro Line 7 advisory services
Consultant hours, deliverables, budgets and invoices for Metro Line 7 brought into one dataset, with Power BI dashboards that made billing deviations visible early.
Delivered by Rhyline’s founder as project controls and data analyst at Metro de Santiago, Chile (June to August 2024).
-
Challenge
The technical advisory contracts for the construction of Metro Line 7 involved more than 20 consultants and engineering specialists. Hours, deliverables, contract budgets and monthly invoices were spread across several spreadsheets, which made it difficult to check billed hours against approved work.
-
Approach
Standardised how consultant hours, deliverables, contract budgets and invoices were recorded, so that every record could be traced and compared month by month.
-
Solution
A structured Excel database that consolidated the spreadsheets into one dataset, Power BI dashboards for contract execution, consultant utilisation and budget consumption against plan, and a monthly contract monitoring report for the project managers.
-
Result
More than 1,500 consulting hours a month were monitored in one place. Comparing billed hours with approved work reports and submitted deliverables identified inconsistencies in consultant billing and made deviations and workload imbalances visible early.