Ref. Ares(2019)2876396 - 29/04/2019
Ref. Ares(2022)1336494 - 22/02/2022
Contract number: T05-EUTF-NOA-LY-03-03 (T05.149)
Implementation Period: 06 June 2017 - 05 June 2020
Reporting period: 06 June 2017- 31 December 2018
1. Budget for the Action1 (in USD)
All Years - Overall
Previous expenditures (1-st Interim Report) (Reporting period:
Actual expenditures 06 June 2018 - 31 December 2018 (including commitments)
Total Expenditures
06 June 2017- 05 June 2018)
(expenses incurred
Unit 13
# of units
Unit value
Total Cost
Expenses incurred (in
Legal
Unit 13
# of units
Unit value
Expenses incurred
Legal commitments
plus legal
(in USD)
(in USD)3
USD)
commitments
Total Expenditures
(in USD)
(in USD)
(including beyond the
Total Expenditures
commitments) in USD
(including
(expenses incurred
first year of
(expenses incurred
6 June 2017-31
Costs
beyond the
plus legal
implementation) in
plus legal
December 2018
first year of
commitments) in USD
USD
commitments) in USD
implementatio
n) in USD
1. Human Resources14
1.1 Salaries (gross salaries including social security
charges and other related costs, local staff)4
1.1.1 Technical
1.1.1.1 Local Project Coordinators (Tripoli, Benghazi,
Sabha) - 100%
Per month
108
$ 4
,583.33
$ 4
94,999.64
$ 7
7,096.41
$ 7
7,096.41
Per month
20.0 $ 4
,583.33
$ 9
1,451.71
$ 2
1,226.30
$ 1
12,678.01
$ 1
89,774.42
1.1.1.2 Site engineer (6 municipalities) - 100%
Per month
144
$ 4
,583.33
$ 6 59,999.52
$ 8
8,029.21
$ 8
8,029.21
Per month
32.2 $ 4 ,583.33
$ 1
47,475.16
$ 1 02,435.49
$ 2
49,910.65
$ 3
37,939.86
1.1.2 Administrative/ support staff
1.1.2.1 Procurement Associate - SC3 - 20%
Per month
7.2
$ 1
,420.40
$ 1
0,226.88
$ 4
51.79
$ 4
51.79
Per month
3.4 $ 1 ,420.40
$ 4 ,829.34
$ 3
,590.11
$ 8
,419.45
$ 8
,871.24
1.1.2.2 Human Resources Associate - SC3 - 20%
Per month
7.2
$ 1
,420.40
$ 1
0,226.88
$ 4
53.09
$ 4
53.09
Per month
3.3 $ 1 ,420.40
$ 4 ,735.74
$ 1
,296.86
$ 6
,032.60
$ 6
,485.69
1.1.2.3 Finance Associate - SC3 - 20%
Per month
7.2
$ 1
,420.40
$ 1
0,226.88
$ 1
,168.10
$ 1
,168.10
Per month
1.0 $ 1 ,420.40
$ 1 ,458.67
$ 1
,458.67
$ 2
,626.77
1.1.2.4 Operations Associate - SC3 - 20%
Per month
7.2
$ 1
,420.40
$ 1
0,226.88
$ 4
,522.06
$ 4
,522.06
Per month
1.8 $ 1 ,420.40
$ 2 ,581.56
$ 2
,581.56
$ 7
,103.62
1.2 Salaries (gross salaries including social security
charges and other related costs, expat/int. staff)
1.2.1 Technical
1.2.1.1 Project Manager - P4 - 100%
Per month
36
$ 1
7,772.07
$ 6
39,794.52
$ 1
77,375.08
$ 1 77,375.08
Per month
8.1 $ 1
7,772.07
$ 1
44,634.40
$ 1 44,634.40
$ 3
22,009.48
1.2.1.2 Programme Analyst - P2 - 20%
Per month
7.2
$ 1
3,073.62
$ 9
4,130.06
$ 1
2,641.78
$ 1 2,641.78
Per month
1.5 $ 1
3,073.62
$ 2
0,037.96
$ 2 0,037.96
$ 3
2,679.74
1.2.1.3 Oversight engineer - P3 - 50%
Per month
12
$ 1
5,427.38
$ 1 85,128.56
$ 2
9,930.52
$ 2 9,930.52
Per month
0.5 $ 1
5,427.38
$ 7 ,369.15
$ 3
,447.00
$ 1 0,816.15
$ 4
0,746.67
1.2.2 Administrative/ support staff
1.2.2.1 Procurement Specialist - P3 - 30%
Per month
10.8
$ 1
5,427.38
$ 1 66,615.70
$ 4
4,484.20
$ 4 4,484.20
Per month
1.2 $ 1
5,427.38
$ 1
7,791.12
$ 1 7,791.12
$ 6
2,275.32
1.2.2.2 Finance Analyst - P2 - 15%
Per month
5.4
$ 1
3,073.62
$ 7
0,597.55
$ 1
7,320.51
$ 1 7,320.51
Per month
1.1 $ 1
3,073.62
$ 1
4,232.01
$ 1 4,232.01
$ 3
1,552.52
1.2.2.3 Operations Manager - P4 - 15%
Per month
5.4
$ 1
7,772.07
$ 9
5,969.18
$ 2
4,830.23
$ 2 4,830.23
Per month
0.5 $ 1
7,772.07
$ 8 ,559.20
$ 8
,559.20
$ 3
3,389.43
1.3 Per diems for missions/travel5
1.3.1 Abroad (staff assigned to the Action) - To Tunis
Per diem
54
$ 1
50.00
$ 8
,100.00
$ 1
,845.00
$ 1
,845.00
Per diem
2.8 $ 1
50.00
$ 4
17.00
$ 4
17.00
$ 2
,262.00
1.3.2 Local (staff assigned to the Action) - To Tripoli
Per diem
126
$ 2
16.00
$ 2
7,216.00
$ 5
,379.00
$ 5
,379.00
Per diem
7.3 $ 2
16.00
$ 1 ,573.17
$ -
$ 1
,573.17
$ 6
,952.17
Subtotal Human Resources
$ 2
,483,458.25
$ 4 85,526.98
$ -
$ 4
85,526.98
$ 4
67,146.19
$ 1 31,995.76
$ 5
99,141.95
$ 1 ,084,668.93
2. Travel6
2.1. International travel
Per flight
42
$ 5
00.00
$ 2
1,000.00
$ 2
,064.45
$ 2
,064.45
Per flight
11.4 $ 5
00.00
$ 5 ,720.79
$ 5
,720.79
$ 7
,785.24
2.2 Local transportation
Per month
36
$ 1
,500.00
$ 5
4,000.00
$ 1
1,361.72
$ 1 1,361.72
Per month
0.5 $ 1 ,500.00
$ 8
01.94
$ 8
01.94
$ 1
2,163.66
Subtotal Travel
$ 7
5,000.00
$ 1
3,426.17
$ -
$ 1
3,426.17
$ 6 ,522.73
$ -
$ 6
,522.73
$ 1
9,948.90
3. Equipment and supplies7
3.1 Furniture, computer equipment (Desk, Chair,
Laptop)
Per unit
5
$ 1
,500.00
$ 7
,500.00
$ 4
,217.75
$ -
$ 4
,217.75
Per unit
1.0 $ 1
,500.00
$ 1
,523.37
$ 1
,523.37
$ 5
,741.12
3.2 Other (Maintenance of Photocopier, scanner, and
printers)
Per year
3
$ 1
,000.00
$ 3
,000.00
$ -
$ -
$ -
Per year
2.3 $ 1
,000.00
$ 2
,265.92
$ 2
,265.92
$ 2
,265.92
Subtotal Equipment and supplies
$ 1
0,500.00
$ 4
,217.75
$ -
$ 4
,217.75
$ 3 ,789.29
$ -
$ 3
,789.29
$ 8
,007.04
4. Local office14
4.1 Office rent
Per month
36
$ 2
,600.00
$ 9
3,600.00
$ 4
9,437.10
$ -
$ 4 9,437.10
Per month
$ 2 ,600.00
$ 7
9,011.47
$ 7 9,011.47
$ 1
28,448.57
4.2 Consumables - office supplies
Per month
36
$ 3
00.00
$ 1
0,800.00
$ 6
89.03
$ -
$ 6
89.03
Per month
0.6 $ 3
00.00
$ 1
93.50
$ 1
93.50
$ 8
82.53
4.3 Other services (tel/fax, electricity/heating,
Per month
36
$ 7
40.00
$ 2
6,640.00
$ 2
,315.87
$ -
$ 2
,315.87
Per month
10.0 $ 7
40.00
$ 7 ,434.18
$ 1
,424.08
$ 8
,858.26
$ 1
1,174.13
Subtotal Local office
$ 1 31,040.00
$ 5
2,442.00
$ -
$ 5
2,442.00
$ 8
6,639.15
$ 1
,424.08
$ 8
8,063.23
$ 1
40,505.23
5. Other costs, services8
5.1 Evaluation costs
Per evaluation
1
$ 5
0,000.00
$ 5
0,000.00
$ 1
4,315.40
$ -
$ 1
4,315.40
Per evaluation
$ 5
0,000.00
$ -
$ -
$ 1
4,315.40
5.2. Visibility actions10
5.2.1 Launch of the project
Per event
1
$ 6
,603.00
$ 6
,603.00
$ 4
,893.91
$ 4
,893.91
Per event
0.1 $ 6 ,603.00
$ 4
53.92
$ 4
53.92
$ 5
,347.83
5.2.2 Social media campaing
Per campaign
3
$ 1
0,000.00
$ 3
0,000.00
$ -
$ -
Per campaign
2.2 $ 1
0,000.00
$ 2
1,895.29
$ 2 1,895.29
$ 2
1,895.29
5.2.3 Factsheets and newsletters
Per factsheet
12
$ 1
,500.00
$ 1
8,000.00
$ -
$ -
Per factsheet
4.6 $ 1 ,500.00
$ 6 ,882.07
$ 6
,882.07
$ 6
,882.07
5.2.4 Promotional products/material
Per product
18
$ 6
,000.00
$ 1 08,000.00
$ 1
1,882.62
$ 1 1,882.62
Per product
0.4 $ 6 ,000.00
$ 2 ,432.00
$ 5
9,469.35
$ 6 1,901.35
$ 7
3,783.97
5.2.5 Social media videos
Per video
10
$ 6
,500.00
$ 6
5,000.00
$ -
$ -
Per video
1.7 $ 6 ,500.00
$ 1
0,951.85
$ 2
1,971.95
$ 3
2,923.80
$ 3
2,923.80
5.2.6 Media visits
Per visit
18
$ 1
,300.00
$ 2
3,400.00
$ -
$ -
Per visit
$ 1 ,300.00
$ -
$ -
5.2.7 Photo campaing
Per campaign
1
$ 3
5,000.00
$ 3
5,000.00
$ -
$ -
Per campaign
0.1 $ 3
5,000.00
$ 3 ,294.62
$ 2
7,993.73
$ 3
1,288.35
$ 3
1,288.35
5.2.8 Documentary films
Per film
6
$ 1
2,500.00
$ 7
5,000.00
$ -
$ -
Per film
$ 1
2,500.00
$ -
$ -
5.2.9 Exhibition
Per event
4
$ 6
0,000.00
$ 2 40,000.00
$ -
$ -
Per event
$ 6
0,000.00
$ -
$ -
Subtotal Other costs, services
$ 6 51,003.00
$ 3
1,091.93
$ -
$ 3
1,091.93
$ 4
5,909.75
$ 1 09,435.03
$ 1
55,344.78
$ 1
86,436.71
15 January 2016
Annex 1- Financial Report_2nd Progress Report_revised presentation_April 2019
1
1. Budget for the Action1 (in USD)
All Years - Overall
Previous expenditures (1-st Interim Report) (Reporting period:
Actual expenditures 06 June 2018 - 31 December 2018 (including commitments)
Total Expenditures
06 June 2017- 05 June 2018)
(expenses incurred
Unit 13
# of units
Unit value
Total Cost
Expenses incurred (in
Legal
Unit 13
# of units
Unit value
Expenses incurred
Legal commitments
plus legal
(in USD)
(in USD)3
USD)
commitments
Total Expenditures
(in USD)
(in USD)
(including beyond the
Total Expenditures
commitments) in USD
(including
(expenses incurred
first year of
(expenses incurred
6 June 2017-31
Costs
beyond the
plus legal
implementation) in
plus legal
December 2018
first year of
commitments) in USD
USD
commitments) in USD
implementatio
n) in USD
6. Other
Output 1 - Delivery of essential public services
Activity 1.1.1 - Municipal facilitation
Per activity
1
$ 1
40,000.00
$ 1 40,000.00
$ -
$ -
Per activity
1.0
$ 1
40,000.00
$ 1
37,212.03
$ -
$ 1
37,212.03
$ 1
37,212.03
Activity 1.1.2 - Quick municipal assessment
Per activity
1
$ 3
00,000.00
$ 3 00,000.00
$ 1 20,000.00
$ 1
20,000.00
Per activity
0.3
$ 3
00,000.00
$ 7
9,358.72
$ -
$ 7
9,358.72
$ 1
99,358.72
Activity 1.1.3 - Municipal development desks
Per activity
1
$ 3
60,000.00
$ 3 60,000.00
$ -
$ -
Per activity
$ 3
60,000.00
$ -
$ 3 42,943.11
$ 3
42,943.11
$ 3
42,943.11
Activity 1.1.4 - Conflict analysis
Per activity
1
$ 2
40,000.00
$ 2 40,000.00
$ 1 29,674.38
$ 1
29,674.38
Per activity
0.5
$ 2
40,000.00
$ 1
10,236.82
$ -
$ 1
10,236.82
$ 2
39,911.20
Activity 1.2.1 - Infrastructure/Services/Equipment
Per activity
1
$ 1
0,220,000.00
$ 1
0,220,000.00
$ 3 79,499.50
$ 3
79,499.50
Per activity
0.1
$ 1
0,220,000.00
$ 1
,317,703.51
$ 3
,450,057.34
$ 4
,767,760.85
$ 5 ,147,260.35
Subtotal Output 1
$ 11,260,000.00
$ 629,173.88
$ -
$ 6
29,173.88
$ 1,644,511.08
$ 3,793,000.45
$ 5
,437,511.53
$ 6,066,685.41
Output 2 - Community security
Activity 2.1.1 - RoL assessment
Per activity
1
$ 1
75,000.00
$ 1 75,000.00
$ 5
2,660.20
$ 5
2,660.20
Per activity
0.6
$ 1
75,000.00
$ 1
05,320.40
$ 1
05,320.40
$ 1
57,980.60
Activity 2.1.2 - Technical assistance / Capacity Building
Per activity
1
$ 7
50,000.00
$ 7
50,000.00
$ -
$ -
Per activity
0.1
$ 7
50,000.00
$ 7
8,990.30
$ 2
36,970.90
$ 3
15,961.20
$ 3
15,961.20
Activity 2.2.1 - Refurbishment of facilities / Equipment
Per activity
1
$ 1
,075,000.00
$ 1
,075,000.00
$ -
$ -
Per activity
0.0
$ 1
,075,000.00
$ -
$ 1
,176,923.69
$ 1
,176,923.69
$ 1 ,176,923.69
Activity 2.2.2 - Specialized training
Per activity
1
$ 2
10,000.00
$ 2 10,000.00
$ -
$ -
Per activity
0.0
$ 2
10,000.00
$ -
$ -
$ -
Activity 2.2.3 - Dialogue facilitation
Per activity
1
$ 2
00,000.00
$ 2 00,000.00
$ 3
,372.34
$ 3
,372.34
Per activity
0.2
$ 2
00,000.00
$ 3
6,309.00
$ 1
6,525.75
$ 5
2,834.75
$ 5
6,207.09
Subtotal Output 2
$ 2,410,000.00
$ 5
6,032.54
$ -
$ 5
6,032.54
$ 220,619.70
$ 1,430,420.34
$ 1
,651,040.04
$ 1,707,072.58
Output 3 - Jobs and Economic Development
Activity 3.1.1 - local economy survey
Per activity
1
$ 7
00,000.00
$ 7 00,000.00
$ 2 50,000.00
$ 2
50,000.00
Per activity
0.1
$ 7
00,000.00
$ 1
02,719.71
$ 1
02,719.71
$ 3
52,719.71
Activity 3.1.2 - Incubators
Per activity
1
$ 2
,000,000.00
$ 2
,000,000.00
$ 1 17,404.84
$ 1
17,404.84
Per activity
0.3
$ 2
,000,000.00
$ 6
03,199.46
$ 7
2,390.41
$ 6
75,589.87
$ 7
92,994.71
Activity 3.1.3 - Start-up support
Per activity
1
$ 1
,000,000.00
$ 1
,000,000.00
$ 3 00,000.00
$ 3
00,000.00
Per activity
0.4
$ 1
,000,000.00
$ 3
77,209.09
$ 3
77,209.09
$ 6
77,209.09
Activity 3.2.1 - Vocational/Skills training
Per activity
1
$ 1
,000,000.00
$ 1
,000,000.00
$ -
$ -
Per activity
0.0
$ 1
,000,000.00
$ 4
9,575.50
$ 4
9,575.50
$ 4
9,575.50
Activity 3.2.2 - Matching needs/skills availability
Per activity
1
$ 2
00,000.00
$ 2 00,000.00
$ 2
0,207.92
$ 2
0,207.92
Per activity
0.4
$ 2
00,000.00
$ 8
5,769.18
$ 1
4,819.28
$ 1
00,588.46
$ 1
20,796.38
Subtotal Output 3
$ 4,900,000.00
$ 687,612.76
$ -
$ 6
87,612.76
$ 1,218,472.94
$ 8
7,209.69
$ 1
,305,682.63
$ 1,993,295.39
Subtotal Other
$ 1
8,570,000.00
$ 1
,372,819.18
$ -
$ 1
,372,819.18
$ 3
,083,603.72
$ 5
,310,630.48
$ 8
,394,234.20
$ 9 ,767,053.38
7. Subtotal direct eligible costs of the Action (1-6) -
EU Contribution
$ 2
1,921,001.25
$ 1
,959,524.01
$ -
$ 1
,959,524.01
$ 3
,693,610.83
$ 5
,553,485.35
$ 9
,247,096.18
$ 1
1,206,620.19
8. Indirect costs (for EU: maximum 7% of subtotal of
direct eligible costs of the action as attributable to EU -
All other donors: 8% of subtotal of direct eligible costs
of the action as attributable to other donors)
$ 1
,753,680.10
$ 1
37,166.68
$ -
$ 1
37,166.68
$ 2
58,552.76
$ 3
88,743.97
$ 6
47,296.73
$ 7
84,463.41
9. Total eligible costs of the Action, excluding
reserve (7+ 8)
$ 2
3,674,681.35
$ 2
,096,690.69
$ -
$ 2
,096,690.69
$ 3
,952,163.59
$ 5
,942,229.32
$ 9
,894,392.91
$ 1
1,991,083.60
10. Provision for contingency reserve (maximum 5% of
7, subtotal of direct eligible costs of the Action)
$ 2
22,925.03
11. Total eligible costs (9+10)
$ 2
3,897,606.38
$ 2
,096,690.69
$ -
$ 2
,096,690.69
$ 3
,952,163.59
$ 5
,942,229.32
$ 9
,894,392.91
$ 1
1,991,083.60
12. - Taxes 11
- Contributions in kind 12
$ -
$ -
13. Total accepted11 costs of the Action (11+12)
$ 2
3,897,606.38
$ 2
,096,690.69
$ -
$ 2
,096,690.69
$ 3
,952,163.59
$ 5
,942,229.32
$ 9
,894,392.91
$ 1
1,991,083.60
Total cost of the Action
$ 23,897,606.38
Total EU contribution
$ 1 9,607,400.00
1st Pre-financing payment:
$ 6,586,185.13
2nd Pre-financing payment:
$ 6,399,364.06
Total expenses incurred plus legal commitments:
$ 11,991,083.60
Next instalment (to be requested)
$ 6,398,925.78
15 January 2016
Annex 1- Financial Report_2nd Progress Report_revised presentation_April 2019
2