Project Analysis


Project Metadata

Account ID

1004235

Account Name

1004235

Project ID

VER2049

Project Name

VER2049

Type

N/A

Manager ID

N/A

Sales Currency

N/A

Project Category

Fixed Price

Competency

N/A

Area of Expertise

N/A

Contract Start

N/A

Allocations Start

2024-07-01

Contract End

N/A

Allocations End

2025-07-01
Project Financials
Overall Financial Summary

Note: Overall totals include all historical data up to and including July 2025.

Target Fees

£244k

 

Planned Fees

£224k

Discount:
£-20k (-8.1%)

Corrected Fees

£384k

Scope Change:
£159k (71.0%)

Written Hours

£352k

Unrealised:
£-32k (-8.3%)

Revenue Assigned

£191k

Leakage:
£-161k (-45.7%)

Invoiced

£190k

Billing:
£-1k (-0.4%)

Revenue Summary by Period

Note: '2025 (Actual)' includes data up to and including July 2025. '2025 (Forecast)' includes data after this date.

Time Period Target Fees Planned Fees Corrected Fees Written Hours Revenue Assigned Invoiced
2025 (Forecast)
(After July 2025)
£0k £0k £0k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£118k £108k £186k £137k £17k £86k
2024 £126k £117k £198k £215k £174k £104k
Pre-2024 £0k £0k £0k £0k £0k £0k
Difference Summary by Period

Note: '2025 (Actual)' includes data up to and including July 2025. '2025 (Planned)' includes data after this date.

Time Period Target Fees Discount Scope Change Unrealised Revenue Leakage Billing
2025 (Forecast)
(After July 2025)
£0k £0k
(0.0%)
£0k
(0.0%)
- - -
2025 (Actual)
(Up to July 2025)
£118k £-11k
(-9.2%)
£78k
(72.8%)
£-49k
(-26.2%)
£-120k
(-87.9%)
£70k
(420.8%)
2024 £126k £-9k
(-7.1%)
£81k
(69.4%)
£17k
(8.6%)
£-40k
(-18.8%)
£-71k
(-40.5%)
Pre-2024 £0k £0k
(0.0%)
£0k
(0.0%)
£0k
(0.0%)
£0k
(0.0%)
£0k
(0.0%)
Monthly Financial Data
2025 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £22k £19k £20k £19k £19k £18k £1k - - - - - £118k
Planned £20k £18k £19k £17k £17k £16k £1k - - - - - £108k
Corrected £34k £30k £31k £30k £30k £29k £1k - - - - - £186k
Written £26k £27k £21k £27k £31k £5k £1k - - - - - £137k
Revenue - - £10k £-12k £19k - - - - - - - £17k
Invoiced - £17k £17k £17k - £35k - - - - - - £86k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target - - - - - - £22k £21k £20k £22k £20k £21k £126k
Planned - - - - - - £20k £19k £19k £20k £19k £19k £117k
Corrected - - - - - - £34k £33k £31k £34k £31k £33k £198k
Written - - - - - - £42k £40k £35k £47k £30k £22k £215k
Revenue - - - - - - - - £114k £33k £27k - £174k
Invoiced - - - - - - - - - £35k £52k £17k £104k
Project Allocations

Note: This table lists all allocation tasks for the project. Non-billable tasks and tasks without an assigned resource are excluded from financial summaries but are shown here for completeness.

Project ID Task ID Resource ID Country Grade Billable Start Date End Date Allocations (%) Target Price Agreed Price Corrected Hours Actual Hours
VER2049 VER2049-2 15296 GB Senior Manager No 2024-07-01 2025-07-01 8% 290.70 205.00 160.00 138.00
VER2049 VER2049-7 15653 IN Senior Consultant No 2024-07-01 2025-07-01 1% 205.00 150.00 20.00 0.00
VER2049 VER2049-3 15710 ZA Senior Consultant No 2024-07-01 2025-04-01 21% 115.00 150.00 330.00 330.00
VER2049 VER2049-4 15871 IN Senior Consultant No 2024-07-01 2025-07-01 57% 205.00 150.00 1205.00 1159.00
VER2049 VER2049-6 15961 ZA Consultant No 2024-07-01 2025-07-01 3% 101.25 130.00 55.00 22.00
VER2049 VER2049-8 15592 US Consultant No 2024-07-01 2025-07-01 4% 252.36 130.00 91.00 51.50
VER2049 VER2049-5 15897 ZA Consultant No 2024-07-01 2025-07-01 33% 101.25 130.00 700.00 632.50
VER2049 VER2049-9 16104 ZA Senior Consultant No 2025-04-01 2025-07-01 9% 123.75 150.00 50.00 50.00
Monthly Project Allocations
2025 Project Allocations

Table cells show: Corrected Hours (Planned + Correction) / Actual Hours (Timesheet) / Difference

Resource ID Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
15296
14.05
12.50
1.55
12.21
10.50
1.71
12.82
10.50
2.32
13.43
10.00
3.43
13.44
7.50
5.94
12.82
6.50
6.32
0.61
0.00
0.61
- - - - -
79.38
57.50
21.88
15653
1.76
0.00
1.76
1.53
0.00
1.53
1.60
0.00
1.60
1.67
0.00
1.67
1.68
0.00
1.68
1.61
0.00
1.61
0.07
0.00
0.07
- - - - -
9.92
0.00
9.92
15710
38.53
0.00
38.53
33.51
0.00
33.51
35.18
0.00
35.18
1.67
0.00
1.67
- - - - - - - -
108.89
0.00
108.89
15871
105.79
121.50
-15.71
91.98
79.00
12.98
96.58
77.50
19.08
101.18
99.00
2.18
101.18
113.00
-11.82
96.58
9.50
87.08
4.60
5.00
-0.40
- - - - -
597.89
504.50
93.39
15961
4.83
0.00
4.83
4.19
6.00
-1.81
4.41
0.50
3.91
4.62
0.00
4.62
4.61
0.00
4.61
4.41
0.00
4.41
0.21
0.00
0.21
- - - - -
27.28
6.50
20.78
15592
7.99
6.50
1.49
6.95
8.50
-1.55
7.29
5.50
1.79
7.65
5.00
2.65
7.64
0.00
7.64
7.29
0.00
7.29
0.35
0.00
0.35
- - - - -
45.16
25.50
19.66
15897
61.45
31.00
30.45
53.43
84.00
-30.57
56.11
49.00
7.11
58.78
66.00
-7.22
58.77
59.50
-0.73
56.11
2.50
53.61
2.67
0.00
2.67
- - - - -
347.32
292.00
55.32
16104 - - -
16.67
4.50
12.17
16.66
32.00
-15.34
15.91
13.50
2.41
0.76
0.00
0.76
- - - - -
50.00
50.00
0.00