Project Analysis


Project Metadata

Account ID

1004272

Account Name

1004272

Project ID

VER1647

Project Name

VER1647

Type

N/A

Manager ID

N/A

Sales Currency

N/A

Project Category

Time & Material

Competency

N/A

Area of Expertise

N/A

Contract Start

N/A

Allocations Start

2023-12-19

Contract End

N/A

Allocations End

2025-11-29
Project Financials
Overall Financial Summary

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

Target Fees

£364k

 

Planned Fees

£300k

Discount:
£-64k (-17.5%)

Corrected Fees

£264k

Scope Change:
£-36k (-12.0%)

Written Hours

£323k

Unrealised:
£58k (22.1%)

Revenue Assigned

£273k

Leakage:
£-49k (-15.3%)

Invoiced

£216k

Billing:
£-57k (-21.0%)

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)
£79k £66k £59k £0k £0k £0k
2025 (Actual)
(Up to July 2025)
£140k £117k £105k £67k £32k £58k
2024 £224k £183k £160k £255k £242k £158k
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)
£79k £-13k
(-16.5%)
£-7k
(-10.7%)
- - -
2025 (Actual)
(Up to July 2025)
£140k £-23k
(-16.5%)
£-13k
(-10.7%)
£-37k
(-35.6%)
£-36k
(-53.0%)
£26k
(81.9%)
2024 £224k £-40k
(-18.1%)
£-24k
(-12.9%)
£96k
(60.0%)
£-14k
(-5.4%)
£-83k
(-34.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 £21k £18k £19k £20k £20k £19k £21k £19k £20k £21k £18k - £220k
Planned £18k £15k £16k £17k £17k £16k £18k £16k £17k £18k £15k - £184k
Corrected £16k £14k £14k £15k £15k £14k £16k £14k £15k £16k £14k - £164k
Written £16k £20k £20k £11k £1k £0k - - - - - - £67k
Revenue £15k £20k £1k £-5k £1k - - - - - - - £32k
Invoiced - £12k £12k £12k £23k - - - - - - - £58k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target £14k £17k £17k £18k £19k £17k £21k £20k £19k £21k £19k £20k £224k
Planned £11k £14k £14k £14k £15k £14k £18k £17k £16k £18k £16k £17k £183k
Corrected £10k £11k £11k £12k £12k £12k £16k £15k £14k £16k £14k £15k £160k
Written £34k £33k £27k £27k £17k £27k £21k £19k £18k £16k £10k £7k £255k
Revenue £37k £32k £29k £27k £13k £31k £18k £12k £15k £6k £13k £10k £242k
Invoiced £24k - £12k £24k £12k - £24k - £12k £12k £24k £12k £158k
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
VER1647 VER1647-4 108 NL Director No 2023-12-19 2025-11-29 1% 287.50 185.00 50.00 130.00
VER1647 VER1647-3 15296 GB Senior Manager No 2024-01-02 2025-11-29 7% 290.70 247.64 271.00 270.50
VER1647 VER1647-9 15551 GB Manager No 2024-01-03 2025-11-29 2% 267.44 174.53 66.00 66.00
VER1647 VER1647-5 15710 ZA Senior Consultant No 2024-01-03 2025-11-29 4% 115.00 113.21 156.00 156.00
VER1647 VER1647-8 15685 GB Manager No 2024-01-04 2025-11-29 4% 267.44 174.53 145.00 144.50
VER1647 VER1647-7 15756 ZA Manager No 2024-01-05 2025-11-29 26% 142.50 113.21 1040.00 986.00
VER1647 VER1647-6 15697 ZA Manager No 2024-01-22 2025-11-29 3% 142.50 113.21 128.50 128.50
VER1647 VER1647-10 15961 ZA Consultant No 2024-06-17 2025-11-29 16% 101.25 113.21 489.50 458.00
VER1647 VER1647-11 15897 ZA Consultant No 2024-06-18 2025-11-29 2% 101.25 113.21 47.00 36.50
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
108
2.26
0.00
2.26
1.97
11.00
-9.03
2.06
1.00
1.06
2.16
0.00
2.16
2.16
0.00
2.16
2.06
1.00
1.06
2.26
0.00
2.26
2.07
0.00
2.07
2.16
0.00
2.16
2.26
0.00
2.26
1.97
0.00
1.97
-
23.39
13.00
10.39
15296
12.48
13.00
-0.52
10.86
11.00
-0.14
11.41
10.00
1.41
11.95
13.50
-1.55
11.94
3.00
8.94
11.40
0.00
11.40
12.49
0.00
12.49
11.40
0.00
11.40
11.95
0.00
11.95
12.49
0.00
12.49
10.86
0.00
10.86
-
129.23
50.50
78.73
15551
3.05
0.00
3.05
2.65
0.00
2.65
2.78
0.00
2.78
2.92
0.00
2.92
2.91
0.00
2.91
2.78
0.00
2.78
3.05
0.00
3.05
2.77
0.00
2.77
2.92
0.00
2.92
3.05
0.00
3.05
2.64
0.00
2.64
-
31.52
0.00
31.52
15710
7.21
0.00
7.21
6.26
0.00
6.26
6.58
0.00
6.58
6.89
0.00
6.89
6.89
0.00
6.89
6.57
0.00
6.57
7.20
0.00
7.20
6.57
0.00
6.57
6.89
0.00
6.89
7.21
0.00
7.21
6.26
0.00
6.26
-
74.53
0.00
74.53
15685
6.72
5.00
1.72
5.83
2.00
3.83
6.12
13.00
-6.88
6.43
22.00
-15.57
6.41
0.00
6.41
6.12
0.00
6.12
6.72
0.00
6.72
6.12
0.00
6.12
6.43
0.00
6.43
6.72
0.00
6.72
5.83
0.00
5.83
-
69.45
42.00
27.45
15756
48.23
72.00
-23.77
41.93
66.50
-24.57
44.03
69.00
-24.97
46.13
18.83
27.30
46.12
0.00
46.12
44.03
0.00
44.03
48.23
0.00
48.23
44.03
0.00
44.03
46.13
0.00
46.13
48.23
0.00
48.23
41.93
0.00
41.93
-
499.02
226.33
272.69
15697
6.10
0.00
6.10
5.30
0.00
5.30
5.56
0.00
5.56
5.83
0.00
5.83
5.83
0.00
5.83
5.57
0.00
5.57
6.09
0.00
6.09
5.56
0.00
5.56
5.82
0.00
5.82
6.09
0.00
6.09
5.30
0.00
5.30
-
63.05
0.00
63.05
15961
29.63
30.50
-0.87
25.76
63.00
-37.24
27.04
60.00
-32.96
28.34
17.00
11.34
28.34
0.00
28.34
27.04
0.00
27.04
29.63
0.00
29.63
27.05
0.00
27.05
28.34
0.00
28.34
29.63
0.00
29.63
25.76
0.00
25.76
-
306.56
170.50
136.06
15897
2.85
2.50
0.35
2.48
0.00
2.48
2.61
0.00
2.61
2.73
0.00
2.73
2.73
0.00
2.73
2.61
0.00
2.61
2.84
0.00
2.84
2.61
0.00
2.61
2.72
0.00
2.72
2.84
0.00
2.84
2.48
0.00
2.48
-
29.50
2.50
27.00