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 (%)
1003189 VER2062 VER2062 Fixed Price 2024-01 £0k £0k £0k - - £3k £-0k £-0k £-0k - £3k -12.6% -63.4% -100.0% 0.0% 0.0%
1000628 VER2065 VER2065 Time & Material 2024-07 £2k £1k £1k - - £3k £-1k - £-1k - £3k -40.9% 0.0% -100.0% 0.0% 0.0%
1005482 VER2067 VER2067 Time & Material 2024-07 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001123 VER2068 VER2068 Time & Material 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005440 VER2069 VER2069 Time & Material 2024-08 £0k £0k £0k - - - £-0k £-0k £-0k - - -23.2% -0.8% -100.0% 0.0% 0.0%
1001598 VER2070 VER2070 Fixed Price 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002303 VER2072 VER2072 Time & Material 2024-09 £28k £28k £28k - - £21k - - £-28k - £21k 0.0% 0.0% -100.0% 0.0% 0.0%
1005475 VER2074 VER2074 Fixed Price 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002303 VER2075 VER2075 Time & Material 2024-08 £1k £0k £0k - - £20k £-0k £0k £-0k - £20k -45.7% 39.3% -100.0% 0.0% 0.0%
1000138 VER2076 VER2076 Fixed Price 2024-07 £109k £121k £121k - - £109k £12k £0k £-121k - £109k 11.0% 0.2% -100.0% 0.0% 0.0%
1001462 VER2078 VER2078 Time & Material 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005490 VER2079 VER2079 Time & Material 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001462 VER2080 VER2080 Time & Material 2024-09 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004751 VER2081 VER2081 Time & Material 2024-03 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001393 VER2083 VER2083 Fixed Price 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001598 VER2084 VER2084 Fixed Price 2024-08 £25k £22k £22k - - £44k £-3k - £-22k - £44k -13.1% 0.0% -100.0% 0.0% 0.0%
1003387 VER2086 VER2086 Time & Material 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000138 VER2089 VER2089 Fixed Price 2024-08 £6k £5k £5k - - £2k £-1k - £-5k - £2k -14.0% 0.0% -100.0% 0.0% 0.0%
1005115 VER2090 VER2090 Fixed Price 2024-09 £2k £1k £1k - - - £-1k - £-1k - - -34.8% 0.0% -100.0% 0.0% 0.0%
1001462 VER2092 VER2092 Fixed Price 2024-09 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000302 VER2094 VER2094 Fixed Price 2024-09 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005590 VER2096 VER2096 Time & Material 2024-08 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000138 VER2097 VER2097 Fixed Price 2024-09 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005570 VER2099 VER2099 Fixed Price 2024-09 £0k £0k £0k - - £10k £-0k - £-0k - £10k -7.9% 0.0% -100.0% 0.0% 0.0%
1002394 VER2106 VER2106 Time & Material 2024-09 £0k £0k £0k - - £1k - £0k £-0k - £1k 0.0% 14.3% -100.0% 0.0% 0.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%