Leakage Analysis


Reset
Target Fees

£54.5m

 

Planned Fees

£41.4m

Discount:
£-13.1m (-24.0%)

Corrected Fees

£44.8m

Scope Change:
£3.4m (8.1%)

Written Hours

£36.3m

Unrealised Revenue:
£-8.5m (-19.0%)

Revenue Assigned

£29.3m

Leakage:
£-6.9m (-23.6%)

Invoiced

£32.9m

Billing:
£3.5m (12.0%)

Project Leakage Summary
1146 / 1146 projects
Account ID Project ID Project Name Contract Start Month Target Fees Planned Fees Corrected Fees Written Hours Revenue Assigned Invoiced Discount Scope Change Unrealised Revenue Leakage Billing Discount (%) Scope Change (%) Unrealised Rev (%) Leakage (%) Billing (%)
1002303 VER1339 VER1339 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003936 VER1342 VER1342 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000435 VER1343 VER1343 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001484 VER1686 VER1686 Time & Material 2024-01 £0k £0k £0k - £-0k - £-0k - £-0k £-0k £0k -26.6% 0.0% -100.0% 100.0% -100.0%
1003542 VER1859 VER1859 Time & Material 2024-03 £0k £0k £0k - £-0k £12k £-0k £0k £-0k £-0k £12k -0.4% 3.2% -100.0% 100.0% -999.0%
1001393 VER2209 VER2209 Fixed Price 2024-11 £5k £5k £5k - £-0k - £-0k - £-5k £-0k £0k -4.6% 0.0% -100.0% 100.0% -100.0%
1004038 VER1386 VER1386 Time & Material 2024-01 £1k £1k £-0k - £-0k £-0k £0k £-1k £0k £-0k - 7.7% -109.1% -100.0% 100.0% 0.0%
1001419 VER2177 VER2177 Time & Material 2024-10 £1k £0k £0k - £-0k - £-1k £-0k £-0k £-0k £0k -74.7% -27.3% -100.0% 100.0% -100.0%
1004720 VER2061 VER2061 Time & Material 2024-06 £6k £5k £4k - £-0k £43k £-1k £-1k £-4k £-0k £44k -13.8% -13.9% -100.0% 100.0% -999.0%
1001151 VER2194 VER2194 Time & Material 2024-11 £6k £3k £2k - £-0k £126k £-3k £-1k £-2k £-0k £127k -51.6% -20.1% -100.0% 100.0% -999.0%
1004803 VER1735 VER1735 Fixed Price 2024-01 £0k £0k £0k - £-0k - £0k - £-0k £-0k £0k 22.0% 0.0% -100.0% 100.0% -100.0%
1001419 VER2259 VER2259 Time & Material 2024-11 £2k £2k £2k - £-1k - £-0k £-0k £-2k £-1k £1k -17.9% -3.0% -100.0% 100.0% -100.0%
1003975 VER2033 VER2033 Fixed Price 2024-06 £1k £1k £1k - £-1k - - - £-1k £-1k £1k 0.0% 0.0% -100.0% 100.0% -100.0%
1000801 VER1657 VER1657 Fixed Price 2024-01 £3k £2k £2k £3k £-1k £-3k £-0k - £1k £-4k £-2k -15.1% 0.0% 27.1% 353.9% 127.5%
1001733 VER1696 VER1696 Fixed Price 2024-01 £0k £0k £0k - £-2k - £-0k £-0k £-0k £-2k £2k -20.4% -6.5% -100.0% 100.0% -100.0%
1004720 VER2063 VER2063 Fixed Price 2024-06 £8k £6k £5k £2k £-4k £104k £-2k £-1k £-3k £-6k £108k -20.0% -17.5% -66.1% 145.3% -999.0%
1004708 VER1690 VER1690 Fixed Price 2024-01 £2k £2k £2k - £-4k - £-0k - £-2k £-4k £4k -17.5% 0.0% -100.0% 100.0% -100.0%
1001419 VER2028 VER2028 Time & Material 2024-07 £7k £5k £5k - £-5k - £-1k £-0k £-5k £-5k £5k -17.7% -5.9% -100.0% 100.0% -100.0%
1001419 VER1669 VER1669 Time & Material 2024-01 £3k £3k £3k - £-15k - £-0k - £-3k £-15k £15k -0.4% 0.0% -100.0% 100.0% -100.0%
1005836 VER2228 VER2228 Fixed Price 2024-12 £6k £6k £6k - £-15k - £-0k - £-6k £-15k £15k -8.0% 0.0% -100.0% 100.0% -100.0%
1005396 VER2087 VER2087 Time & Material 2024-09 £3k £3k £3k - £-18k - £-1k - £-3k £-18k £18k -21.6% 0.0% -100.0% 100.0% -100.0%
Client Leakage Summary
511 / 511 clients
Account ID / Project ID Account Name / Project Name Project Count Target Fees Planned Fees Corrected Fees Written Hours Revenue Assigned Invoiced Discount Scope Change Unrealised Revenue Leakage Billing Discount (%) Scope Change (%) Unrealised Rev (%) Leakage (%) Billing (%)
1004251 1004251 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1576 VER1576 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005260 1005260 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1986 VER1986 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004817 1004817 2 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1738 VER1738 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1982 VER1982 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004408 1004408 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1535 VER1535 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005222 1005222 2 £0k £0k £0k - - - £-0k - £-0k - - -10.0% 0.0% -100.0% 0.0% 0.0%
VER2144 VER2144 £0k £0k £0k - - - £-0k - £-0k - - -10.0% 0.0% -100.0% 0.0% 0.0%
VER1975 VER1975 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000684 1000684 1 £9k £9k £9k £11k - - - - £1k £-11k - 0.0% 0.0% 16.0% 0.0% 0.0%
VER2569 VER2569 £9k £9k £9k £11k - - - - £1k £-11k - 0.0% 0.0% 16.0% 0.0% 0.0%
1004644 1004644 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1969 VER1969 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001484 1001484 1 £0k £0k £0k - £-0k - £-0k - £-0k £-0k £0k -26.6% 0.0% -100.0% 100.0% -100.0%
VER1686 VER1686 £0k £0k £0k - £-0k - £-0k - £-0k £-0k £0k -26.6% 0.0% -100.0% 100.0% -100.0%
1003975 1003975 2 £1k £1k £1k - £-1k - - - £-1k £-1k £1k 0.0% 0.0% -100.0% 100.0% -100.0%
VER1493 VER1493 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2033 VER2033 £1k £1k £1k - £-1k - - - £-1k £-1k £1k 0.0% 0.0% -100.0% 100.0% -100.0%
1004708 1004708 1 £2k £2k £2k - £-4k - £-0k - £-2k £-4k £4k -17.5% 0.0% -100.0% 100.0% -100.0%
VER1690 VER1690 £2k £2k £2k - £-4k - £-0k - £-2k £-4k £4k -17.5% 0.0% -100.0% 100.0% -100.0%
1005396 1005396 1 £3k £3k £3k - £-18k - £-1k - £-3k £-18k £18k -21.6% 0.0% -100.0% 100.0% -100.0%
VER2087 VER2087 £3k £3k £3k - £-18k - £-1k - £-3k £-18k £18k -21.6% 0.0% -100.0% 100.0% -100.0%