← All projects

Case study 03 · Business Partnering / Commercial Performance

Client Profitability & Resource Planning

Connecting financial performance, client revenue, and resource utilization to improve understanding of profitability and support commercial decisions.

01

Overview

Bringing together revenue, cost and people data to show which clients and projects create value — and where effort and return are out of balance.

02

Business Problem

Revenue was visible by client, but the cost of serving each client — especially people's time — sat elsewhere. Without that connection, profitability conversations relied on assumptions rather than evidence.

03

Approach

  • Linked client revenue with staff time and direct costs at a consistent level of detail.
  • Agreed allocation principles with business leaders so the results would be trusted.
  • Built views for both finance and commercial teams, using their own language.
  • Connected profitability with forward-looking resource and capacity planning.
04

Solution

A client and project profitability model connected to resource planning, giving management a shared view of revenue, cost-to-serve, utilisation and margin by client.

05

Technology

  • Microsoft Power BI
  • Excel
  • Power Query
  • Resource and time data
06

Business Impact

  • Better understanding of profitability drivers.
  • Improved visibility into resource allocation.
  • Stronger, evidence-based commercial discussions.
  • More informed operational and management decisions.
07

Lessons Learned

Profitability analysis is as much about trust as about arithmetic. Involving business leaders in the allocation logic turned a finance report into a shared management tool.

Next case study

Global FP&A & Multi-Entity Reporting

Read next →