jagomart
digital resources
picture1_Estimate Template Excel 40648 | Budget Template Rrf Activation April2020


 252x       Filetype XLSX       File size 0.16 MB       Source: assets.publishing.service.gov.uk


File: Estimate Template Excel 40648 | Budget Template Rrf Activation April2020
sheet 1 1 information table 1 full cost recovery budget project information lead partner organisation project name project number project start date project end date total project cost project country ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: 1 Information

















































TABLE 1: FULL COST RECOVERY BUDGET - PROJECT INFORMATION


Lead Partner Organisation



Project name



Project number



Project start date



Project end date



Total project cost



Project country



Thematic sector



Budget version



Date of budget revision



Exchange Rate



Prepared by

















TABLE 3: Partner details



Partner Name Name SME status



Lead Partner Organisation





Partner 1





Partner 2





Partner 3





Partner 4





Partner 5





Partner 6





Partner 7





Partner 8





Partner 9





Partner 10



















NOTES











































































































































Sheet 2: 2 BUDGET





































































































































































































































































































































































































































Table 1 below relates to costs for this PROJECT ONLY















































































































TABLE 1: CLASSIFY DIRECT COSTS INTO COST CATEGORIES
Budget Projection (Prior Estimate) Actual Spend (Final Report) Variances






Delivered through partner? Do not edit: cells update automatically


Output 1 Output 2 Output 3 Output 4






Output 1 Output 2 Output 3 Output 4






Output 1 Output 2 Output 3 Output 4
Line Code Costs
Budget Heading (for internal purposes) Headlines Line Total Type Unit Cost Name of Unit No of units Times repeated Output 1 No of units Times repeated Output 2 No of units Times repeated Output 3 No of units Times repeated Output 4 Proportion Headlines Line Total Type Unit Cost Unit No of units Times repeated Output 1 No of units Times repeated Output 2 No of units Times repeated Output 3 No of units Times repeated Output 4 Proportion Headlines Line Total Type Unit Cost Unit No of units Times repeated Output 1 No of units Times repeated Output 2 No of units Times repeated Output 3 No of units Times repeated Output 4 Proportion
A Inputs




0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.1
Health

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.2
WASH

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.3
Food

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.4
Livelihoods

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.5
Shelter

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.6
NFIs

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.7
Education

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.8
Cash transfers

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.9
Others

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
A.10
Partner NPAC (see tab 3.1)

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
B Transport




0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
B.1
Transport of materials

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
B.1.1

International shipping
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
B.1.2

Port handling
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
B.1.3

Truck rental
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
C Security




0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
C.1
Staff

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
C.1.1

Guard
PROJECT STAFF COSTS - PAY No 0 0 0














0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
C.2
Equipment

CAPITAL EXPENDITURE No 0 0 0





















































C.3
Risk Management

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D Project logistics and admin (Note: include directly attributable costs only)




0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1
Country Office


No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1.1

Office space (rent, utilities etc)
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1.2

Communications
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1.3

Communications - Capital items
CAPITAL EXPENDITURE No 0 0 0





















































D.1.4

Storage
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1.5

Bank charges
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1.6

Small equipment - capital exp
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.1.7

Insurance
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.2
Field Office


No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
D.2.1

Office space (rent, utilities etc)
PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E Project Staffing Pay, Training and Travel




0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.1
National Technical

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.1.1

[Staff member, e.g. nurse]
PROJECT STAFF COSTS - PAY No 0 0 0














0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.1.2

[Staff member, e.g. nurse]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.2
National Support

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.2.1

[Staff member, e.g. programme officer]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.2.2

[Staff member, e.g. programme officer]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.3
International Technical

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.3.1

[Staff member, e.g. WASH specialist]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.3.2

[Staff member, e.g. WASH specialist]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.4
International Support

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.4.1

[Staff member, e.g. country office manager]
PROJECT STAFF COSTS - PAY No
0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.4.2

[Staff member, e.g. country office manager]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.5
Off-shore Technical

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.5.1

[Staff member, e.g. public health specialist]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.6
Off-shore Support

PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.6.1

[Staff member, e.g. regional director]
PROJECT STAFF COSTS - PAY No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.7
Training

PROJECT ACTIVITIES No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.8
Non-salary benefits

PROJECT STAFF COSTS - TRAVEL & SUBSISTENCE No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
E.9
Staff travel


No
0 0















0 0 0















0 0
















E.9.1

International flights
PROJECT STAFF COSTS - TRAVEL & SUBSISTENCE No 0 0 0















0 0 0















0 0
















E.9.2

Car rental
PROJECT STAFF COSTS - TRAVEL & SUBSISTENCE No 0 0 0















0 0 0















0 0
















F Monitoring and Evaluation




0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
F.1
Monitoring

MONITORING EVALUATION & LESSONS LEARNED No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
F.2
Evaluation

MONITORING EVALUATION & LESSONS LEARNED No 0 0 0




0

0

0

0 0.0% 0 0 0




0

0

0

0 0.0% 0 0 0 #NAME? 0 #NAME? 0 0 0 0 0 0 0 0 0 0 0 0 #NAME?
Totals Do not edit: These cells update automatically




0 0






















































Total of Direct Costs





0
0




0

0

0

0 #DIV/0! 0
0




0

0

0

0 #DIV/0! 0 0 0




0

0

0

0 #NAME?
Non-Project-Attributable Costs (%)




0.0% 0
0




0

0

0

0 #DIV/0! 0
0




0

0

0

0 #DIV/0! 0 0 0




0

0

0

0 #NAME?
Total





0
0




0

0

0

0 #DIV/0! 0
0




0

0

0

0 #DIV/0! 0 0 0




0

0

0

0 #NAME?































































Fully funded by DFID?




Yes DFID funding:

#DIV/0! £ 0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! #DIV/0! DFID funding:

#DIV/0! £ 0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! #DIV/0! DFID funding:

#DIV/0! £


#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! #DIV/0!
Funds transferred to local and national partners










insert % value

















insert % value

















insert % value 0 £0.00 0 0 £0.00 0 0 £0.00 0 0 £0.00 0
































































Output (as in logframe)















Total/ average









Total/ average





#NAME? #NAME? #NAME? #NAME? Total/ average
Number of direct beneficiaries (per output)





Household size (if used)



individuals

()

()

()

() (0) Household size (if used)



individuals

()

()

()

() (0)
0 0 #NAME? 0 #NAME?
- 0 - 0 - 0 - 0
Number of DFID-attributable direct beneficiaries










individuals #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!




individuals #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
0 0 #NAME? 0 #NAME?
#DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! #DIV/0!
Cost per direct beneficiary (CPB)













#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! #DIV/0!







#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0! #DIV/0! £0.00 £0.00 £0.00 £0.00 £0.00 £0.00

#DIV/0! £0.00 £0.00 #DIV/0! £0.00 £0.00 #DIV/0! £0.00 £0.00 #DIV/0! #DIV/0!
































































Output indicator (result)



























0
0
0








#NAME? 0 #NAME? 0 #NAME? 0 #NAME? 0
DFID-attributable output indicator












#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!







#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!















Unit cost of output (cost per result)













#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!








#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!






0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0! 0 0 #DIV/0!

Sheet 3: 3.1 Instructions - NPAC










































































































































































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet information table full cost recovery budget project lead partner organisation name number start date end total country thematic sector version of revision exchange rate prepared by details sme status notes below relates to costs for this only classify direct into categories projection prior estimate actual spend final report variances delivered through do not edit cells update automatically output line code heading internal purposes headlines type unit no units times repeated proportion a inputs health activities wash food livelihoods shelter nfis education cash transfers others npac see tab...

no reviews yet
Please Login to review.