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 (%)
1002174 VER1519 VER1519 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000952 VER1523 VER1523 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001599 VER1524 VER1524 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004017 VER1526 VER1526 Fixed Price 2024-01 £0k £0k £0k - - - - £0k £-0k - - 0.0% 16.0% -100.0% 0.0% 0.0%
1004306 VER1527 VER1527 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004337 VER1529 VER1529 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002262 VER1531 VER1531 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004298 VER1532 VER1532 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004408 VER1535 VER1535 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002263 VER1539 VER1539 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003761 VER1541 VER1541 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001223 VER1542 VER1542 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001418 VER1545 VER1545 Fixed Price 2024-01 £7k £7k £7k £0k - £3k - - £-6k £-0k £3k 0.0% 0.0% -96.5% 0.0% 0.0%
1001298 VER1547 VER1547 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004445 VER1551 VER1551 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004432 VER1554 VER1554 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003542 VER1557 VER1557 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002234 VER1558 VER1558 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004378 VER1559 VER1559 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001045 VER1560 VER1560 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003751 VER1563 VER1563 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003132 VER1564 VER1564 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001462 VER1569 VER1569 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004445 VER1570 VER1570 Fixed Price 2024-01 £1k £1k £1k - - - £-0k - £-1k - - -34.8% 0.0% -100.0% 0.0% 0.0%
1001266 VER1572 VER1572 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.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 (%)
1000092 1000092 1 £0k £0k £0k - - - £-0k - £-0k - - -25.9% 0.0% -100.0% 0.0% 0.0%
VER49 VER49 £0k £0k £0k - - - £-0k - £-0k - - -25.9% 0.0% -100.0% 0.0% 0.0%
1000286 1000286 2 £1k £1k £1k - - £37k £-0k - £-1k - £37k -20.3% 0.0% -100.0% 0.0% 0.0%
VER1504 VER1504 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1889 VER1889 £1k £1k £1k - - £37k £-0k - £-1k - £37k -20.3% 0.0% -100.0% 0.0% 0.0%
1004713 1004713 3 £4k £2k £2k - - £9k £-1k - £-2k - £9k -36.2% 0.0% -100.0% 0.0% 0.0%
VER1676 VER1676 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1993 VER1993 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1992 VER1992 £4k £2k £2k - - £9k £-1k - £-2k - £9k -36.2% 0.0% -100.0% 0.0% 0.0%
1006374 1006374 1 £14k £9k £9k £12k - - £-5k - £3k £-12k - -32.4% 0.0% 29.1% 0.0% 0.0%
VER2567 VER2567 £14k £9k £9k £12k - - £-5k - £3k £-12k - -32.4% 0.0% 29.1% 0.0% 0.0%
1000523 1000523 2 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1790 VER1790 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER667 VER667 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000139 1000139 4 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1800 VER1800 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1818 VER1818 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1851 VER1851 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1905 VER1905 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003281 1003281 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1639 VER1639 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006411 1006411 1 £71k £30k £30k £5k - - £-41k - £-25k £-5k - -57.7% 0.0% -83.3% 0.0% 0.0%
VER2584 VER2584 £71k £30k £30k £5k - - £-41k - £-25k £-5k - -57.7% 0.0% -83.3% 0.0% 0.0%
1000844 1000844 1 £0k £0k £0k - - £3k - £-0k £-0k - £3k 0.0% -45.0% -100.0% 0.0% 0.0%
VER2242 VER2242 £0k £0k £0k - - £3k - £-0k £-0k - £3k 0.0% -45.0% -100.0% 0.0% 0.0%
1004304 1004304 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1632 VER1632 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002424 1002424 2 £3k £3k £3k - - - - - £-3k - - 0.0% 0.0% -100.0% 0.0% 0.0%
VER2395 VER2395 £3k £3k £3k - - - - - £-3k - - 0.0% 0.0% -100.0% 0.0% 0.0%
VER1870 VER1870 £0k £0k £0k - - - - - £-0k - - 0.0% 0.0% -100.0% 0.0% 0.0%
1003936 1003936 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1342 VER1342 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006389 1006389 1 £86k £72k £72k £15k - - £-14k - £-57k £-15k - -16.8% 0.0% -79.5% 0.0% 0.0%
VER2598 VER2598 £86k £72k £72k £15k - - £-14k - £-57k £-15k - -16.8% 0.0% -79.5% 0.0% 0.0%
1002548 1002548 2 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER897 VER897 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER894 VER894 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002930 1002930 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1465 VER1465 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005693 1005693 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2123 VER2123 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004172 1004172 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1439 VER1439 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006544 1006544 2 £4k £3k £3k £11k - - £-0k - £8k £-11k - -8.1% 0.0% 231.7% 0.0% 0.0%
VER2592 VER2592 £3k £2k £2k £10k - - £-0k - £7k £-10k - -7.1% 0.0% 302.9% 0.0% 0.0%
VER2590 VER2590 £1k £1k £1k £1k - - £-0k - £0k £-1k - -10.6% 0.0% 33.9% 0.0% 0.0%
1001312 1001312 1 £2k £2k £2k £2k - - - - £-0k £-2k - 0.0% 0.0% -16.7% 0.0% 0.0%
VER2410 VER2410 £2k £2k £2k £2k - - - - £-0k £-2k - 0.0% 0.0% -16.7% 0.0% 0.0%
1000798 1000798 2 £2k £2k £2k - - - £-0k £-0k £-2k - - -8.6% -1.8% -100.0% 0.0% 0.0%
VER2286 VER2286 £2k £2k £2k - - - £-0k - £-2k - - -8.6% 0.0% -100.0% 0.0% 0.0%
VER1876 VER1876 £0k £0k £0k - - - £-0k £-0k £-0k - - -8.6% -63.9% -100.0% 0.0% 0.0%
1003944 1003944 1 £0k £0k £0k - - - - - £-0k - - 0.0% 0.0% -100.0% 0.0% 0.0%
VER1773 VER1773 £0k £0k £0k - - - - - £-0k - - 0.0% 0.0% -100.0% 0.0% 0.0%
1003899 1003899 2 £7k £6k £4k - - - £-1k £-2k £-4k - - -18.6% -26.3% -100.0% 0.0% 0.0%
VER1977 VER1977 £7k £6k £4k - - - £-1k £-2k £-4k - - -18.6% -26.3% -100.0% 0.0% 0.0%
VER1211 VER1211 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003428 1003428 2 £1k £1k £1k - - - £-0k - £-1k - - -2.6% 0.0% -100.0% 0.0% 0.0%
VER2324 VER2324 £1k £1k £1k - - - £-0k - £-1k - - -2.6% 0.0% -100.0% 0.0% 0.0%
VER1644 VER1644 £0k £0k £0k - - - £-0k - £-0k - - -3.6% 0.0% -100.0% 0.0% 0.0%
1003269 1003269 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1455 VER1455 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005440 1005440 1 £0k £0k £0k - - - £-0k £-0k £-0k - - -23.2% -0.8% -100.0% 0.0% 0.0%
VER2069 VER2069 £0k £0k £0k - - - £-0k £-0k £-0k - - -23.2% -0.8% -100.0% 0.0% 0.0%