Project Analysis


Project Metadata

Account ID

1004653

Account Name

1004653

Project ID

VER2137

Project Name

VER2137

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-10-01

Contract End

N/A

Allocations End

2025-04-01
Project Financials
Overall Financial Summary

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

Target Fees

£411k

 

Planned Fees

£362k

Discount:
£-49k (-11.8%)

Corrected Fees

£459k

Scope Change:
£97k (26.7%)

Written Hours

£414k

Unrealised:
£-45k (-9.8%)

Revenue Assigned

£405k

Leakage:
£-9k (-2.2%)

Invoiced

£453k

Billing:
£48k (11.8%)

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)
£264k £221k £269k £271k £273k £360k
2024 £147k £141k £190k £143k £133k £93k
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)
£264k £-43k
(-16.3%)
£48k
(21.7%)
£2k
(0.7%)
£1k
(0.5%)
£87k
(31.9%)
2024 £147k £-6k
(-3.8%)
£49k
(34.6%)
£-47k
(-24.6%)
£-11k
(-7.4%)
£-39k
(-29.6%)
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 £92k £82k £86k £4k - - - - - - - - £264k
Planned £77k £69k £72k £3k - - - - - - - - £221k
Corrected £94k £83k £87k £4k - - - - - - - - £269k
Written £91k £84k £93k £4k - - - - - - - - £271k
Revenue £91k £80k £97k £4k - - - - - - - - £273k
Invoiced £138k - £221k - - - - - - - - - £360k
2024 Financial Data
Metric Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Target - - - - - - - - - £51k £47k £49k £147k
Planned - - - - - - - - - £49k £45k £47k £141k
Corrected - - - - - - - - - £66k £60k £63k £190k
Written - - - - - - - - - £46k £47k £50k £143k
Revenue - - - - - - - - - £43k £45k £44k £133k
Invoiced - - - - - - - - - - £93k - £93k
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
VER2137 VER2137-1 15411 JP Director No 2024-10-01 2025-04-01 49% 262.74 246.82 517.70 386.00
VER2137 VER2137-2 15698 JP Senior Manager No 2024-10-01 2025-04-01 64% 224.52 212.90 672.00 663.00
VER2137 VER2137-3 15733 JP Manager No 2024-10-01 2025-04-01 8% 199.84 189.01 80.00 80.00
VER2137 VER2137-4 15393 NL Business Associate No 2024-10-01 2025-04-01 46% 189.01 189.01 480.00 457.00
VER2137 VER2137-6 15637 JP Senior Manager No 2025-01-02 2025-04-01 75% 226.56 160.16 384.00 384.00
VER2137 VER2137-7 16036 JP Senior Consultant No 2025-01-02 2025-04-01 38% 171.88 109.38 192.00 136.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
15411
90.89
46.00
44.89
79.04
106.00
-26.96
82.99
74.00
8.99
3.95
16.00
-12.05
- - - - - - - -
256.87
242.00
14.87
15698
117.98
170.00
-52.02
102.59
112.00
-9.41
107.73
160.00
-52.27
5.13
0.00
5.13
- - - - - - - -
333.43
442.00
-108.57
15733
14.05
0.00
14.05
12.21
0.00
12.21
12.82
0.00
12.82
0.62
0.00
0.62
- - - - - - - -
39.70
0.00
39.70
15393
84.28
82.00
2.28
73.28
40.00
33.28
76.95
95.00
-18.05
3.66
0.00
3.66
- - - - - - - -
238.17
217.00
21.17
15637
132.00
128.00
4.00
120.00
120.00
0.00
126.00
136.00
-10.00
6.00
0.00
6.00
- - - - - - - -
384.00
384.00
0.00
16036
66.00
64.00
2.00
60.00
64.00
-4.00
63.00
8.00
55.00
3.00
0.00
3.00
- - - - - - - -
192.00
136.00
56.00