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 (%)
1001543 VER1910 VER1910 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002239 VER1911 VER1911 Time & Material 2024-05 £1k £1k £1k - - £24k £-0k - £-1k - £24k -22.0% 0.0% -100.0% 0.0% 0.0%
1001543 VER1912 VER1912 Time & Material 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002185 VER1913 VER1913 Time & Material 2024-05 £70k £45k - - - - £-25k £-45k - - - -36.2% -100.0% 0.0% 0.0% 0.0%
1002185 VER1914 VER1914 Fixed Price 2024-05 £96k £64k - - - - £-32k £-64k - - - -33.2% -100.0% 0.0% 0.0% 0.0%
1002239 VER1915 VER1915 Fixed Price 2024-05 £0k £0k £0k - - £4k £-0k - £-0k - £4k -33.3% 0.0% -100.0% 0.0% 0.0%
1002185 VER1916 VER1916 Time & Material 2024-05 £69k £50k £50k - - £40k £-19k - £-50k - £40k -27.5% 0.0% -100.0% 0.0% 0.0%
1002185 VER1917 VER1917 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002185 VER1918 VER1918 Time & Material 2024-10 £2k £1k £1k - - - £-1k - £-1k - - -52.2% 0.0% -100.0% 0.0% 0.0%
1002185 VER1919 VER1919 Time & Material 2024-05 £2k £1k £1k - - £36k £-1k - £-1k - £36k -44.7% 0.0% -100.0% 0.0% 0.0%
1002185 VER1921 VER1921 Time & Material 2024-05 £15k £10k £6k - - £32k £-5k £-4k £-6k - £32k -33.3% -42.6% -100.0% 0.0% 0.0%
1002185 VER1922 VER1922 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002185 VER1923 VER1923 Fixed Price 2024-05 £161k £110k £110k - - £63k £-51k - £-110k - £63k -31.7% 0.0% -100.0% 0.0% 0.0%
1002185 VER1924 VER1924 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002185 VER1925 VER1925 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005130 VER1926 VER1926 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1002185 VER1927 VER1927 Fixed Price 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1004986 VER1928 VER1928 Fixed Price 2024-04 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1001371 VER1929 VER1929 Fixed Price 2024-04 £1k £1k £1k - - - £-0k - £-1k - - -39.7% 0.0% -100.0% 0.0% 0.0%
1000997 VER1930 VER1930 Fixed Price 2024-01 £0k £0k £0k - - - - £-0k £-0k - - 0.0% -30.4% -100.0% 0.0% 0.0%
1001289 VER1931 VER1931 Fixed Price 2024-01 £0k £0k £0k - - - - - £-0k - - 0.0% 0.0% -100.0% 0.0% 0.0%
1005146 VER1932 VER1932 Time & Material 2024-05 - - - - - - - - - - - 0.0% 0.0% 0.0% 0.0% 0.0%
1005130 VER1933 VER1933 Time & Material 2024-05 £12k £8k £8k - - - £-4k - £-8k - - -31.4% 0.0% -100.0% 0.0% 0.0%
1002331 VER1934 VER1934 Fixed Price 2024-05 £2k £1k £0k - - - £-1k £-1k £-0k - - -32.3% -98.6% -100.0% 0.0% 0.0%
1005149 VER1935 VER1935 Time & Material 2024-05 £2k £2k £2k - - £23k £-1k - £-2k - £23k -25.7% 0.0% -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%