jagomart
digital resources
picture1_Budget Spreadsheet 41067 | Budget Template For Programme Proposals Final 2


 176x       Filetype XLSX       File size 0.18 MB       Source: www.un.org


File: Budget Spreadsheet 41067 | Budget Template For Programme Proposals Final 2
sheet 1 general instructions general instructions 1 please do not merge cells 2 please do not delete any column 3 please do not change column and row headers 3 blue ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: General Instructions
General Instructions:
1. Please do not merge cells;
2. Please do not delete any column;
3. Please do not change column and row headers;
3. Blue, orange and yellow cells are formulas and should not be altered. Fill ONLY the white cells.
4. All budget lines must indicate the exact amount to two decimal places
5. For UNTFHS funding, Tables 1, 2 and 3 should be linked and report the same total by reporting object class, annual total per implementing organization, and total programme budget. Refer to the provided example.

Table 1. "Detailed Budget":
1. This table should the proposed funding requirements to implement the all outputs and activities of the entire programme (i.e. both UNTHFS and co-funding sources, etc). Refer to Section VI. Budget of the UNTFHS Guidelines (9th revision; 1 May 2016).
2. Grey cells from "G" to "Q" must remain blank.
3. Add as many rows as required, based on the number of objectives, outputs, activities but ensure to maintain the template formatting, logic of the table and formulas.
4. Please enter one value type per cell from column G forward as per example provided in blue font.
5. The total columns -marked with an asterisk (*) - of the two budget sections (Item line budget* and Annual budget*) must be equal. Please refer to the example provided in blue.
6. Units and quantities have to be clearly specified for each budget line of the activities. Please refer  to the example (blue font). The lead agency/programme coordination team is responsible for the consolidation of the information from various implementing organizations by ensuring consistency in the use of unit and figures for similar activities.
7. The number, title and duration/number of days for each contract/consultancy should be consistent with the information provided in the narrative description of the Concept Note document.
8. Each budget item line must indicate the object class under which the cost will be financially reported. This information should be entered in the column "O" - Reporting Object Class. Please enter only one of the seven reporting object class per line. Please refer to the below Annex I regarding the seven reporting object classes. (The eighth reporting object class is Indirect Support Costs and is based on 7% of the total programme costs).
9. Each budget item line of the activities must indicate the implementing partners (IPs) and the funding sources, even in cases where the entire activity is carried out by the same IP and/or funded by the same funding source. Please see the example in the template.
10. Please remove the red font tips throughout the table when the consolidate budget document is ready for submission.

Table 2. Budget by object class:
1. This table relates only to the proposed UNTFHS funding source and will be the reference document for the review of the financial reporting submitted during the life of the programme by each IP.
2. This table should be linked to Table 1. by Detailed budget and consolidates the amount for each implementing partner by year and by reporting object class. This will be the basis for the amount to be included in the financial agreement with the UNTFHS and is the basic information that ensures alignment of progress narrative reports on the activities with the financial reporting/utilization of UNTFHS funds. The example provided in the template should be of assistance.
3. The 8 reporting categories used in this table are the one selected and defined by the working group on financial reporting of the United Nations System Chief Executives Board Secretariat (CEB) in 2010. The CEB working group included the UN entities of the UNDG group, namely UN, UNDP, UNICEF, UNFPA, FAO, UNHCR, UNESCO, WFP and WHO. The main change from the past category is disuse of "Acquisition" which was replaced by/split between the two object classes: “Equipment vehicles and furniture” and “Supplies commodities materials”.
4. To assist in the budgeting and financial reporting, please refer to the pasted screencut from a CEB document defining each object class.
5. Please note that Individual consultant/contractor costs fall under the object class “staff and personnel”.
6. Please note that “Travel” should include staff and non-staff travel directly related to the programme.



Sheet 2: Table 1. Detailed budget
Project Title










UNTFHS Programme ref. #










Implementing Organization










Country










Date




























Table 1: Detailed budget by results





















Item line budget* Annual budget*




Detailed description $ Unit Quantity Total* Year 1 Year 2 Year 3 The outputs and activities of the programme should include the proposed funding requirements to implement all outputs and activities for the entire programme (i.e. both UNTHFS funding and the co-funding sources). Total* In order to determine the budget amount for each reporting class, only one object class for each row should be included. If an activity will require budgeted funds under different object classes, then please create/add another row. Reporting Object class In order to determine the funding for each implementing partner (IP), only one IP should be included. If more than one IP will jointly implementing the same activity, then please create/add another row. Implementing partner (IP) In order to determine the proposed funding requirements between the various funding sources (i.e. UNTFHS, Govt XYZ, Entity1, etc), please include only one funding source for each row. If more than one funding source will fund the same activity, then please create/add another row. Funding sources

Objective 1: To enhance the understanding of the application of the human security approach and its usage as a tool for developing effective policies and programmes by Governments, non-governmental bodies as well as regional and sub-regional intergovernmental institution towards the achievement of Agenda 2063 and the SDGs.








Output 1.1: High-Level Event on “Making a lasting impact: An integrated approach for the realization of Agenda 2063 and the achievement of the SDGs”








Activity 1.1.1: Establish a joint Steering Committee to provide strategic oversight and garner the political commitment necessary to develop the AHSI, including the Deputy Chairperson of the AUC and senior representatives of ECA, UNOAU, the African Development Bank, and others.
This is further detailed below as follows:

Below should include the budgeted requriements (what services and/or goods to be acquired) with the detailed costs.
i.e. for travel include the tickets costs, DSA and terminal, for catering include the cost per person, venue costs, printing costs, etc.). See below examples.



22,680.00 22,680.00 - - 22,680.00 Guidance:
1. Please leave blank the cell in correspondence to the total by activity, and instead specify the object class in each of the breakdown line.
2. Even if the whole activity fall into one object class, please repeat it in each row.
3. Pls use only and solely the provided list in "budget summary by obj class".Do not add any word or description. See example.
Guidance:
1. Please leave blank the cell in correspondence to the total by activity, and instead specify the IO in each of the breakdown line.
2. Please in the breakdown lines of the same activity, repeat the name of the IO, even if the whole activity is carried out by the same IO.
Guidance:
1. Please leave blank the cell in correspondence to the row where are reported totals, and instead specify the funding source in each of the breakdown line of each activity.
2. Please in the breakdown lines of the same activity, repeat the funding source, even if the whole activity is funded by the same source.


Domestic flight tickets for project training delivery
DSA $100 x 2 National Trainers x 6 days= $1,200; 
100.00 staff 12 1,200.00 1,200.00

1,200.00 Travel on official business ECA UNTFHS

DSA for 2 staff (national) deliverying the training in XX town (6 days)



100.00 day 72 7,200.00 7,200.00

7,200.00 Travel on official business ECA UNTFHS

Fee for 2 National Trainer per each training to gov. officials 75.00 day 72 5,400.00 5,400.00

5,400.00 Staff and other personnel expenses ECA Govt XYZ

Coffee break and lunch for 132 trainees (22 participants each training per 5 days)
50.00 person 132 6,600.00 6,600.00

6,600.00 Contractual services ECA UNTFHS

Cost of venue 10.00 day 30 300.00 300.00

300.00 Contractual services ECA ECA

Training materials including ( 132 participants) …… 15.00 person 132 1,980.00 1,980.00

1,980.00 Contractual services ECA UNTFHS

Activity 1.1.2: Draft the concept note and agenda for the High-Level Event in October 2018
This is further detailed below as follows:



2,300.00 2,300.00 - - 2,300.00




As mentioned above, include the budgeted required with the details of how the amount is estimated. (i.e. for consultants indicate the number of days and the cost per day). 250.00 person/day 5 1,250.00 1,250.00

1,250.00 Staff and other personnel expenses



For example, if the consultant needs to travel, include ticket, Dsa and terminal as per the below examples:


- -

-




Domestic flight tickets for project training delivery
Tkt cost $300/persons
300.00 person 1 300.00 300.00

300.00




DSA for 2 consultant (6 days)
DSA $150 x 1 consultants x 5 days= $750; 
150.00 person/day 5 750.00 750.00

750.00








-


-




Activity 1.1.3: Organize the logistics and outreach to ensure high-level and broad participation in the High-Level Event.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-




Activity 1.1.4: Establish the Terms of Reference and Work Plan for the Steering Committee, including the frequency of their meetings.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-




Output 1.2: A report on the technical workshop on the sidelines of the HLE to build the capacities of practitioners in the application of human security as a tool for developing effective policies and programmes towards the achievement of Agenda 2063 and the SDGs.








Activity 1.2.1: Undertake a scoping of relevant institutions and individuals in Governments, non-Governmental bodies, regional and sub-regional intergovernmental institutions to engage in the technical workshop.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 1.2.2: Draft the concept note and agenda for the technical workshop in October 2018 (1/2 day)
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 1.2.3: Organize the logistics and outreach to ensure broad participation in the technical workshop
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-












- -

-








- -

-








- -

-




Activity 1.2.4: Draft a summary report on the technical workshop to inform the development of the AHSI.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-












- -

-












- -

-












- -

-








- -

-




Objective 1 Sub-Total


24,980.00 24,980.00 - - 24,980.00






















Objective 2: To develop the African Human Security Index (AHSI) as a universal yet contextually relevant tool to guide policy development and monitor progress across the nexus of socioeconomic development, good governance, human rights, and peace and stability towards Agenda 2063 and the SDGs.
















Output 2.1: Draft African Human Security Index for piloting in two countries.
















Activity 2.1.1: Establish a joint AU-UN technical working group (TWG) and ToR to define the scope, methodology and piloting of the AHSI. The TWG will report to the Steering Committee and its membership with comprise of technical experts from the AU, ECA, UNOAU, ADB, APRM, NEPAD, Regional Economic Communities (RECs), HSU, and others as determined by the Steering Committee.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 2.1.2: Organize a ½ day technical roundtable on the sidelines of the HLE and technical workshop (in objective 1) involving the TWG as well as representatives from the two pilot countries. [see note in Output 1.2 above]
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 2.1.3: Draft the concept note and agenda for the technical roundtable in October 2018
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 2.1.4: Organize the logistics and outreach to ensure broad participation in the technical workshop
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-












- -

-












- -

-












- -

-




Activity 2.1.4: Organize the logistics and outreach to ensure broad participation in the technical workshop
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-












- -

-












- -

-




Activity 2.1.5: Draft a summary report on the technical roundtable including the work plan for the development of the AHSI.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-












- -

-












- -

-




Activity 2.1.6: Develop the AHSI as a contextualized index that would provide strategic orientation based on a clearly defined methodology and rigorous analytical work. The AHSI will build upon existing data and processes, and will help strengthen interlinkages between the African Governance Architecture, the African Peace and Security Architecture, and Africa’s development architecture as embodied in NEPAD and APRM.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-












- -

-








- -

-








- -

-




Objective 2 Sub-Total


- - - - -






















Objective 3: To pilot the AHSI in two countries to refine and codify the AHSI methodology for application by Member States of the African Union.
















Output 3.1: Summary reports for each pilot country with recommendations to refine and codify the AHSI for broader application
















Activity 3.1.1: Based on the technical workshop, develop a work plan for the piloting of the AHSI in two countries.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 3.1.2: Establish country-specific working groups to liaise with the TWG.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 3.1.3: Pilot the AHSI in two countries to refine and codify the AHSI.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 3.1.4: Monitor and evaluate the piloting of the AHSI.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-












- -

-












- -

-




Activity 3.1.5: Draft a summary report for each pilot with recommendations to refine and codify the AHSI for broader application.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Objective 3 Sub-Total


- - - - -








































Objective 4: To make recommendations on how the AUC and the Member States of the AU can most effectively apply the AHSI to advance Agenda 2063 and the SDGs, and to highlight these recommendations at the High-Level Political Forum on Sustainable Development in 2019 (HLPF).
















Output 4.1: Recommendations from the AUC on the application of the AHSI
















Activity 4.1.1: Formulate recommendations and an action plan on how the AUC and the Member States of the AU can most effectively apply the AHSI to advance Agenda 2063 and the SDGs.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 4.1.2: Hold policy dialogues with AU Member States to share information on the AHSI, findings from the pilots, and recommendations for broader application.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Activity 4.1.3: Present AHSI and recommendations at the HLPF 2019 in New York.
This is further detailed below as follows:



- - - - -




Same as above, include the budgeted requirements with details on how the amounts is estimated.


- -

-








- -

-








- -

-








- -

-








- -

-




Objective 4 Sub-Total


- - - - -












































































Total Programme Cost (Requested from UNTFHS) -A



16,980.00 - - 16,980.00 Guidance: Please ensure the Total Project Cost values represent the portion to be funded by UNTFHS. Either add the amounts that pertain to the UNTFHS funding (under "Funding sourcese") or use the sumif function.

Indirect support costs (7% of the total programme cost above) -B



1,188.60 0 0 1,188.60




TOTAL PROGRAMME BUDGET - requested from UNTFHS
(total programme costs A + indirect support costs B)




18,168.60 - - 18,168.60






















OTHER FUNDING SOURCES (no UNTFHS)



Year 1 Year 2 Year 3 Total












-












-












-












-




TOTAL



- - - -






















OVERALL TOTAL PROGRAMME COSTS
(Requested amount from UNTFHS + Other Funding Source (no UNTFHS)




18,168.60 - - 18,168.60 Guidance: Please ensure the Total Project Cost values result as the sum of the Objectives Sub-totals. In this regard, particular attention should be given when adding rows for (1 )additional activities and/or (2) for additional item lines under each activities and replicate the formatting and formulas as per sample.







































Sheet 3: Table 2. Budget by object class
Blue and yellow cells are formulas and should not be altered. Fill ONLY the while cells.




























Table 2: Budget Summary by reporting object class (per each Implementing Organization) funded by UNTFHS







Table 2: Budget revision by reporting object class (for the whole programme funded by UNTFHS)



















ECA













Object Class Approved Budget (US$)


Object Class Approved Budget (US$)

Year 1 Year 2 Year 3 Total % over Programme Cost



Year 1 Year 2 Year 3 Total % over Programme Cost
Staff and other personnel expenses Suggest you use the sumif function to sum up the amounts funded by the UNTFHS under each object class. -

- 0.00%


Staff and other personnel expenses - - - - 0.00%
Travel on official business 8,400.00 - - 8,400.00 49.47%


Travel on official business 8,400.00 - - 8,400.00 49.47%
Contractual services 8,580.00

8,580.00 50.53%


Contractual services 8,580.00 - - 8,580.00 50.53%
Operating expenses -

- 0.00%


Operating expenses - - - - 0.00%
Equipment, vehicles and furniture (including depreciation) -

- 0.00%


Equipment, vehicles and furniture (including depreciation) - - - - 0.00%
Supplies, commodities and materials -

- 0.00%


Supplies, commodities and materials - - - - 0.00%
Transfers and grants to counterparts -

- 0.00%


Transfers and grants to counterparts - - - - 0.00%
Total programme cost 16,980.00 - - 16,980.00 100.00%


Total programme cost 16,980.00 - - 16,980.00 100.00%
Indirect support costs (7% of the total programme cost) 1,188.60 #NAME? #NAME? #NAME? #NAME?


Indirect support costs (7% of the total programme cost) 1,188.60 #NAME? #NAME? #NAME? #NAME?
Total programme budget 18,168.60 #NAME? #NAME? #NAME? #NAME?


Total programme budget 18,168.60 #NAME? #NAME? 18,168.60 107.00%















Org B













Object Class Approved Budget (US$)









Year 1 Year 2 Year 3 Total % over Programme Cost








Staff and other personnel expenses -

- #DIV/0!








Travel on official business -

- #DIV/0!








Contractual services -

- #DIV/0!








Operating expenses - - - - #DIV/0!








Equipment, vehicles and furniture (including depreciation) -

- #DIV/0!








Supplies, commodities and materials -

- #DIV/0!








Transfers and grants to counterparts -

- #DIV/0!








Total programme cost - - - - #DIV/0!








Indirect support costs (7% of the total programme cost) - #NAME? #NAME? - #DIV/0!








Total programme budget - #NAME? #NAME? - #DIV/0!























Org C













Object Class Approved Budget (US$)









Year 1 Year 2 Year 3 Total % over Programme Cost








Staff and other personnel expenses


- #DIV/0!








Travel on official business


- #DIV/0!








Contractual services


- #DIV/0!








Operating expenses


- #DIV/0!








Equipment, vehicles and furniture (including depreciation)


- #DIV/0!








Supplies, commodities and materials


- #DIV/0!








Transfers and grants to counterparts


- #DIV/0!








Total programme cost - - - - #DIV/0!








Indirect support costs (7% of the total programme cost) - #NAME? #NAME? #NAME? #NAME?








Total programme budget - #NAME? #NAME? #NAME? #NAME?























Org D













Object Class Approved Budget (US$)









Year 1 Year 2 Year 3 Total % over Programme Cost








Staff and other personnel expenses


- #DIV/0!








Travel on official business


- #DIV/0!








Contractual services


- #DIV/0!








Operating expenses


- #DIV/0!








Equipment, vehicles and furniture (including depreciation)


- #DIV/0!








Supplies, commodities and materials


- #DIV/0!








Transfers and grants to counterparts


- #DIV/0!








Total programme cost - - - - #DIV/0!








Indirect support costs (7% of the total programme cost) - #NAME? #NAME? #NAME? #NAME?








Total programme budget - #NAME? #NAME? #NAME? #NAME?























Org E













Object Class Approved Budget (US$)









Year 1 Year 2 Year 3 Total % over Programme Cost








Staff and other personnel expenses


- #DIV/0!








Travel on official business


- #DIV/0!








Contractual services


- #DIV/0!








Operating expenses


- #DIV/0!








Equipment, vehicles and furniture (including depreciation)


- #DIV/0!








Supplies, commodities and materials


- #DIV/0!








Transfers and grants to counterparts


- #DIV/0!








Total programme cost - - - - #DIV/0!








Indirect support costs (7% of the total programme cost) - #NAME? #NAME? #NAME? #NAME?








Total programme budget - #NAME? #NAME? #NAME? #NAME?























Org F













Object Class Approved Budget (US$)









Year 1 Year 2 Year 3 Total % over Programme Cost








Staff and other personnel expenses


- #DIV/0!








Travel on official business


- #DIV/0!








Contractual services


- #DIV/0!








Operating expenses


- #DIV/0!








Equipment, vehicles and furniture (including depreciation)


- #DIV/0!








Supplies, commodities and materials


- #DIV/0!








Transfers and grants to counterparts


- #DIV/0!








Total programme cost - - - - #DIV/0!








Indirect support costs (7% of the total programme cost) - #NAME? #NAME? #NAME? #NAME?








Total programme budget - #NAME? #NAME? #NAME? #NAME?









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

...Sheet general instructions please do not merge cells delete any column change and row headers blue orange yellow are formulas should be altered fill only the white all budget lines must indicate exact amount to two decimal places for untfhs funding tables linked report same total by reporting object class annual per implementing organization programme refer provided example table quot detailed this proposed requirements implement outputs activities of entire ie both unthfs cofunding sources etc section vi guidelines th revision may grey from g q remain blank add as many rows required based on number objectives but ensure maintain template formatting logic enter one value type cell forward in font columns marked with an asterisk sections item line equal units quantities have clearly specified each nbsp lead agencyprogramme coordination team is responsible consolidation information various organizations ensuring consistency use unit figures similar title durationnumber days contractconsu...

no reviews yet
Please Login to review.