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 (%)
1000241 VER1448 VER1448 Time & Material 2024-01 £2k £1k £1k - - £6k £-1k - £-1k - £6k -38.3% 0.0% -100.0% 0.0% 0.0%
1002522 VER1453 VER1453 Time & Material 2024-01 £0k £0k £0k - - £0k £-0k - £-0k - £0k -32.7% 0.0% -100.0% 0.0% 0.0%
1003269 VER1455 VER1455 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000628 VER1457 VER1457 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000066 VER1458 VER1458 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001178 VER1461 VER1461 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002930 VER1465 VER1465 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000685 VER1467 VER1467 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003666 VER1472 VER1472 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001382 VER1473 VER1473 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004238 VER1474 VER1474 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000138 VER1477 VER1477 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002590 VER1482 VER1482 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004235 VER1483 VER1483 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004235 VER1484 VER1484 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004234 VER1491 VER1491 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002394 VER1495 VER1495 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001543 VER1496 VER1496 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000567 VER1500 VER1500 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000905 VER1501 VER1501 Fixed Price 2024-01 £0k £0k £0k - - - £-0k - £-0k - - -8.0% 0.0% -100.0% 0.0% 0.0%
1003530 VER1503 VER1503 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000286 VER1504 VER1504 Time & Material 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003542 VER1507 VER1507 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003542 VER1508 VER1508 Fixed Price 2024-01 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002726 VER1517 VER1517 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 (%)
1003662 1003662 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1580 VER1580 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1000957 1000957 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1652 VER1652 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005490 1005490 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2079 VER2079 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006492 1006492 1 £11k £11k £11k £11k - - - - - £-11k - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2589 VER2589 £11k £11k £11k £11k - - - - - £-11k - 0.0% 0.0% 0.0% 0.0% 0.0%
1004346 1004346 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1660 VER1660 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003982 1003982 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1901 VER1901 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005146 1005146 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1932 VER1932 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003289 1003289 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1368 VER1368 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003403 1003403 1 £18k £17k £17k £20k - - £-0k - £3k £-20k - -2.4% 0.0% 19.4% 0.0% 0.0%
VER2501 VER2501 £18k £17k £17k £20k - - £-0k - £3k £-20k - -2.4% 0.0% 19.4% 0.0% 0.0%
1002331 1002331 1 £2k £1k £0k - - - £-1k £-1k £-0k - - -32.3% -98.6% -100.0% 0.0% 0.0%
VER1934 VER1934 £2k £1k £0k - - - £-1k £-1k £-0k - - -32.3% -98.6% -100.0% 0.0% 0.0%
1000777 1000777 1 £13k £13k £13k £16k - £8k - - £2k £-16k £8k 0.0% 0.0% 18.7% 0.0% 0.0%
VER2541 VER2541 £13k £13k £13k £16k - £8k - - £2k £-16k £8k 0.0% 0.0% 18.7% 0.0% 0.0%
1006363 1006363 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2561 VER2561 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005183 1005183 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1972 VER1972 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005151 1005151 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1938 VER1938 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002816 1002816 1 £0k £0k £0k - - - £-0k - £-0k - - -10.2% 0.0% -100.0% 0.0% 0.0%
VER1744 VER1744 £0k £0k £0k - - - £-0k - £-0k - - -10.2% 0.0% -100.0% 0.0% 0.0%
1002261 1002261 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1442 VER1442 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005876 1005876 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2224 VER2224 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005778 1005778 1 £1k £0k £0k - - - £-0k - £-0k - - -49.7% 0.0% -100.0% 0.0% 0.0%
VER2210 VER2210 £1k £0k £0k - - - £-0k - £-0k - - -49.7% 0.0% -100.0% 0.0% 0.0%
1001267 1001267 2 £10k £10k £5k £5k - £5k £-0k £-5k £0k £-5k £5k -0.0% -49.5% 3.1% 0.0% 0.0%
VER2454 VER2454 £10k £10k £5k £5k - £5k - £-5k £0k £-5k £5k 0.0% -50.0% 4.8% 0.0% 0.0%
VER1895 VER1895 £0k £0k £0k - - - £-0k £0k £-0k - - -1.0% 22.1% -100.0% 0.0% 0.0%
1004727 1004727 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1955 VER1955 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1006507 1006507 1 £7k £3k £3k £2k - £5k £-3k - £-1k £-2k £5k -48.7% 0.0% -40.9% 0.0% 0.0%
VER2591 VER2591 £7k £3k £3k £2k - £5k £-3k - £-1k £-2k £5k -48.7% 0.0% -40.9% 0.0% 0.0%
1002775 1002775 2 £2k £1k £1k - - - £-2k - £-1k - - -71.3% 0.0% -100.0% 0.0% 0.0%
VER2041 VER2041 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER2128 VER2128 £2k £1k £1k - - - £-2k - £-1k - - -71.3% 0.0% -100.0% 0.0% 0.0%
1004639 1004639 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1949 VER1949 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003666 1003666 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1472 VER1472 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1003692 1003692 1 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
VER1672 VER1672 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%