Docstoc

05

Document Sample
05 Powered By Docstoc
					05.01 Financial Absorption by Priority Axis

Report Definition – 05.01 Financial Absorption by Priority Axis
Customer Project Manager Issue Issue date Status Prepared by : Department of Communities and Local Government : Nigel Williams : 1.0 : 30th March 2009 : For Review : Tony Banbury

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 1 of 10

05.01 Financial Absorption by Priority Axis

Document Control
Amendment History:
Date 30/03/09 23/04/09 Issue 0.1 1.0 Status First draft Updated following UAT Author TB TB

Distribution: Name and role Project Team Project Manager 1.0 I R

I R S

Not issued For information only – no action required For review – comments to be directed to the Project Manager For sign-off

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 2 of 10

05.01 Financial Absorption by Priority Axis

Report Definition
Report Title Report Reference Category Purpose Ad hoc / Standard Developed by End Users Access / Distribution Frequency of Use Data Refresh Output Media Report Description: Financial Absorption by Priority Axis 05.01 Programme Monitoring Shows programme level financials by priority axis Ad hoc Tony Banbury MA, RDA users Reporting tool Ad hoc Daily PDF (default), HTML Shows programme level financials by priority axis. Users are prompted for an RDA, programme and an exchange rate to be used when converting unspent allocations from Euros to GBP. The report shows aggregated allocation, commitment and spend values in order to gauge a programme‟s financial performance by priority axis.

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 3 of 10

05.01 Financial Absorption by Priority Axis

Suggested Report Layout Top level layout (by priority axis)

1

2

3

4

5

6

7

8

11 9 10 12

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 4 of 10

05.01 Financial Absorption by Priority Axis

Drill-through layout (by project)

13

14

15

5

6

7

8

16

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 5 of 10

05.01 Financial Absorption by Priority Axis

Report Items
The report layout adheres to the standard report template. Ref 1 Label Priority Axis Description Priority Axis Source – Framework ref Programme > Programme Financials > By Programme Priority Axis > Programme Priority Axis Identifier Programme > Programme Financials > By Programme Priority Axis > Allocation > Allocation Grant Total EUR Programme Financials > By Programme Priority Axis > Expenditure Grant Total GBP + ((Programme > Programme Financials > By Programme Priority Axis > Allocation Grant Total EUR - Programme Financials > By Programme Priority Axis > Expenditure Grant Total EUR) * (1 / <EUR Ex Rate>) ) 4 Current Commitment The total ERDF commitment in GBP for existing live, financially complete or closed projects. If a project is currently under amendment, the commitment value used is that of the latest live version of the project The amount in ERDF for projects which are currently closed or financially complete where the grant spent did not match the committed grant. Programme > Programme Financials > By Programme Priority Axis > Commitment > Commitment Grant Total GBP Currency Format Text Comments

2

ERDF Allocation Sterling Allocation

Allocation Grant €

Currency

3

Allocation Grant £

Currency

<EUR Ex Rate> = the exchange rate value entered in the report‟s prompt page

5

Reported Underspend

Project > Project Financials > By Expenditure Category Type > Commitment > Commitment Grant Total GBP Project > Project Financials > By Expenditure Category Type > Expenditure > Expenditure Grant Total GBP

Currency

Where “Current Project Status” in („Closed‟, „Financially Complete‟)

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 6 of 10

05.01 Financial Absorption by Priority Axis

Ref 6

Label Contract Revisions

Description For projects that are currently under revision, the difference between the latest live version of the project and the version currently being revised

Source – Framework ref Project Historical > Project Financials > By Expenditure Category Type > Commitment > Commitment Grant Total GBP (Where “Project Status Grouping” = „Under Revision‟ and “Latest Status Flag” = „Y‟ and “Latest Project Flag” = „Y‟) Project Historical > Project Financials > By Expenditure Category Type > Commitment > Commitment Grant Total GBP (Where “Latest Status Flag” = „Y‟ and “Latest Live Project Flag” = „Y‟)

Format Currency

Comments

7

Pipeline Value

The commitment for projects that have yet to be live

Project Historical > Project Financials > By Expenditure Category Type > Commitment > Commitment Grant Total GBP

Currency

Where “Project Status Grouping” = „Pipeline‟ and “Latest Status Flag” = „Y‟ and “Latest Project Flag” = „Y‟

8

Potential Commitment

The sum of the previous four values - Current Commitment + Reported Underspend + Contract Revisions + Pipeline Value Sterling Allocation - Potential Commitment Current Commitment / Sterling Allocation shown as a percentage The total authorised ERDF spend to date Payments to Date / Sterling Allocation shown as a percentage

Current Commitment + Reported Underspend + Contract Revisions + Pipeline Value

Currency

9 10

Uncommitted Resources Commitment as % of Allocation Payments to Date Payments as % of Allocation

Sterling Allocation - Potential Commitment Current Commitment / Sterling Allocation

Currency Percentage

11

Programme > Programme Financials > By Programme Priority Axis > Expenditure > Expenditure Grant Total GBP Payments to Date / Sterling Allocation

Currency

12

Percentage

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 7 of 10

05.01 Financial Absorption by Priority Axis

Ref 13 14 15

Label Priority Axis Project Identifier Current Commitment

Description Priority Axis Project Identifier The total ERDF commitment in GBP for existing live, financially complete or closed projects. If a project is currently under amendment, the commitment value used is that of the latest live version of the project The total authorised ERDF spend to date

Source – Framework ref Project > Project Priority Axis Identifier Project > Project Identifier Project Historical > Project Financials > By Expenditure Category Type > Commitment > Commitment Grant Total GBP

Format Text Text Currency

Comments

Where “Latest Status Flag” = „Y‟ and “Latest Live Project Flag” = „Y‟

16

Payments to Date

Project > Project Financials > By Expenditure Category Type > Expenditure > Expenditure Grant Total GBP

Currency

Note: All commitment totals have been reduced by any irregularities that are in recovery

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 8 of 10

05.01 Financial Absorption by Priority Axis

Summary Data
Detail any aggregations within the report, including sub totals. Item ERDF Allocation Sterling Allocation Current Commitment Reported Underspend Contract Revisions Pipeline Value Potential Commitment Uncommitted Resources Commitment as % of Allocation Payments to Date Payments as % of Allocation Comments Overall total Overall total Overall total Overall total Overall total Overall total Overall total Overall total Overall calculation Overall total Overall calculation

Parameter List
Parameters available to users are to be presented via a separate “Prompt Page”. The prompt page adheres to the standard report template. Sequence Name Report Field Source Framework Ref Programme > Programme Detail > RDA Code Programme > Programme Name Cascade from RDA Comments Optional Default Value None Free Form Entry N Drop down N Drop down Multiple Select N

1

RDA

RDA Code

N

2

Programme

Programme Name

N

None

N

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 9 of 10

05.01 Financial Absorption by Priority Axis

Sequence

Name

Report Field

Source Framework Ref N/A

Comments

Optional

Default Value The current treasury EUR exchange rate

Free Form Entry Y

Multiple Select N

3

Euro Exchange Rate for Unspent Allocation

N/A

Include the current Treasury Euro exchange rate beside the prompt‟s label (Programme > Programme Detail > Treasury Exchange Rate)

N

Sort Order
Report Field Priority Axis Project Identifier Direction Asc Asc Horizontal / Vertical (applies to Crosstab reports only)

1d8810db-5b1f-49d9-98c3-4e31bc7c381b.doc

page 10 of 10


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:8
posted:1/14/2010
language:English
pages:10
Lingjuan Ma Lingjuan Ma
About