Attachment J.5 - ROPE Worksheet.xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- Armenia Resilience Activity
- Solicitation number
- 72011124R00005
- Issued by
-
US Agency for International Development
About this file
This document appears to be an attachment titled "Attachment J.5 - ROPE Worksheet.xlsx" that contains a detailed budget estimate for an international development project. The project is focused on strengthening resilience in Armenia through activities in areas such as natural resource management, disaster risk management, agriculture and food security, water resources, and energy systems.
The budget estimate provides a detailed breakdown of expected costs for personnel (both international and local staff), travel, equipment, supplies, contractual grants, program activities, consultants, and other direct costs over a 5-year period. The total estimated cost for the project is $17,094,448. Key positions include a Chief of Party, Technical Advisors, Monitoring and Evaluation Specialists, and various subject matter experts and operational staff. The budget also includes provisions for fringe benefits, indirect costs, and a 5% fee.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 72011124R00005 Amendment 0002.pdf | ||
| Attachment J.5 - ROPE Worksheet (Amended).xlsx | XLSX spreadsheet | |
| Attachment J.7 Unburdened Ceiling Daily Rates (Amended).xlsx | XLSX spreadsheet | |
| NOFO 72011124R00005 Amendment 0001.pdf | ||
| Attachment J.5 - ROPE Worksheet.xlsx | XLSX spreadsheet | |
| Attachment J.7 Unburdened Ceiling Daily Rates.xlsx | XLSX spreadsheet | |
| Attachment J.7 Unburdened Ceiling Daily Rates.xlsx | XLSX spreadsheet | |
| Armenia Resilience RFP 72011124R00005.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Base_Detail
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total Estimate | ||||||||||||||||||
| Jan 2023 - Dec 2023 | Jan 2024 - Dec 2024 | Jan 2025 - Dec 2025 | Jan 2026 - Dec 2026 | Jan 2027 - Dec 2027 | |||||||||||||||||||
| Description | Labor Category | Qualification Level | Unit | No. of Units | Unit Cost (USD) | Year 1 Estimate | Unit | No. of Units | Unit Cost (USD) | Year 2 Estimate | Unit | No. of Units | Unit Cost (USD) | Year 3 Estimate | Unit | No. of Units | Unit Cost (USD) | Year 4 Estimate | Unit | No. of Units | Unit Cost (USD) | Year 5 Estimate |
PERSONNEL
INTERNATIONAL STAFF
| Expatriate Staff | ||||||||||||||||
| Chief of Party | Chief of Party, Project Manager | Sr. expat | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Technical Advisors (2) | Food Security/ Agriculture Expert/Specialist | Sr. Expat | Day | - | Day | - | Day | - | Day | - | Day | 1 | 150 | 150 | 150 | |
| Monitoring and Evaluation Manager | Monitoring, Evaluation, and Learning Specialist | Sr. Expat | Day | - | Day | - | Day | - | Day | - | Day | - | - |
SUBTOTAL INTERNATIONAL STAFF - - - - 150 150
LOCAL IN-COUNTRY STAFF
| Program Staff | ||||||||||||||||
| Deputy Chief of Party (Program and Operations) | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Sr lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Component 1 Manager | Food Security/ Agriculture Expert/Specialist | Sr lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Component 2 Manager North | Food Security/ Agriculture Expert/Specialist | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Component 2 Manager South | Food Security/ Agriculture Expert/Specialist | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Accountant | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Field Agronimist/Monitor North | Food Security/ Agriculture Expert/Specialist | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | 1 | 100 | 100 | 100 | |
| Field Agronimist/Monitor South | Food Security/ Agriculture Expert/Specialist | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Monitoring and Evaluation Manager | Monitoring, Evaluation, and Learning Specialist | Sr CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Monitoring and Evaluation Assistant | Monitoring, Evaluation, and Learning Specialist | Mid Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Youth Specialist/Advisor | Gender/Inclusive Development Expert/ Specialist | Mid Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Gender Equality and Social Inclusion (GESI) Specialist | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |||
| Communications Officer | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - |
| Operational Staff | ||||||||||||||
| Operations Manager | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Sr Lev CCN | Day | - | Day | - | Day | - | - | Day | - | - | ||
| Finance Officer | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Accountant | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Communication and Education Specialist (Component 1) | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Data specialist (Component 1) | Digital Development/ Information Technology Expert/Specialist | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| GIS specialist | Digital Development/ Information Technology Expert/Specialist | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Procurement Specialist | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Office Manager | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Sr Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Information Systems Officer | Digital Development/ Information Technology Expert/Specialist | Mid Lev CCN | Day | - | Day | - | Day | - | Day | - | Day | - | - |
SUBTOTAL NATIONAL STAFF - - - - 100 100
TOTAL PERSONNEL - - - - 250 250
FRINGE BENEFITS
| Fringe - local staff | USAID Preset | Percent | 16.67% | - | - | Percent | 16.67% | - | - | Percent | 16.67% | - | - | Percent | 16.67% | - | - | Percent | 16.67% | 100 | 17 | 17 |
| Fringe - expat staff (corporate NICRA rate) | Corporate NICRA rate, if applicable | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | Percent | 100 | - | - |
TOTAL FRINGE BENEFITS - - - - 17 17
TRAVEL (SEE TRAVEL TABLE FOR ADDITIONAL INFO)
USAID Lump Sum 160,000 80,000 48,000 45,000 55,000 388,000
TOTAL TRAVEL 160,000 80,000 48,000 45,000 55,000 388,000
EQUIPMENT
USAID Lump Sum 120,000 - - - - 120,000
TOTAL EQUIPMENT 120,000 - - - - 120,000
SUPPLIES
USAID Lump Sum 50,000 2,500 2,500 2,500 2,500 60,000
TOTAL SUPPLIES 50,000 2,500 2,500 2,500 2,500 60,000
CONTRACTUAL
GRANTS UNDER CONTRACT
USAID Lump Sum Each 420,000 Each 1,500,000 Each 1,500,000 Each 1,500,000 Each 420,000 5,340,000
SUBTOTAL GRANTS UNDER CONTRACT 420,000 1,500,000 1,500,000 1,500,000 420,000 5,340,000
PROGRAM ACTIVITIES
USAID Lump Sum Each 800,000 Each 1,250,000 Each 1,250,000 Each 1,250,000 Each 250,000 4,800,000
SUBTOTAL PROGRAM ACTIVITIES 800,000 1,250,000 1,250,000 1,250,000 250,000 4,800,000
CONSULTANTS
USAID Lump Sum Day 197,160 Day 250,000 Day 275,000 Day 250,000 Day 100,000 1,072,160
SUBTOTAL CONSULTANTS 197,160 250,000 275,000 250,000 100,000 1,072,160
Subcontracts
National Agrarian University Plug Each 500,000 Each 1,000,000 Each 1,000,000 Each 1,000,000 Each 500,000 4,000,000
SUBTOTAL SUBGRANTS 500,000 1,000,000 1,000,000 1,000,000 500,000 4,000,000
TOTAL CONTRACTUAL 1,917,160 4,000,000 4,025,000 4,000,000 1,270,000 15,212,160
OTHER DIRECT COSTS
USAID Lump Sum 100,000 100,000 100,000 100,000 100,000 500,000
TOTAL OTHER COSTS 100,000 100,000 100,000 100,000 100,000 500,000
DIRECT COSTS 2,347,160 4,182,500 4,175,500 4,147,500 1,427,767 16,280,427
INDIRECT COSTS
| 1 | Overhead (corporate NICRA rate, if applicable) | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
| 2 | G&A (Corpoate NICRA rate, if applicable) | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
| 3 | Subcontract Management (Corporate NICRA rate, if applicable) | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
| 4 | Other NICRA Rate, if applicable | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
| 5 | Other NICRA Rate, if applicable | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
| 6 | Other NICRA Rate, if applicable | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
| 7 | Other NICRA Rate, if applicable | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
TOTAL INDIRECT COSTS - - - - - -
FEE Fee 5.00% 2,347,160 117,358 Fee 5.00% 4,182,500 209,125 Fee 5.00% 4,175,500 208,775 Fee 5.00% 4,147,500 207,375 Fee 5.00% 1,427,767 71,388 814,021
TOTAL COSTS 2,464,518 4,391,625 4,384,275 4,354,875 1,499,155 17,094,448
Formula Sheet
| CountryName | |
| Afghanistan | |
| Aland Islands | |
| Day | Albania |
| Month | Algeria |
| Year | American Samoa |
| Each | Andorra |
| Percent | Angola |
| Total | Anguilla |
| Indirect | Antarctica |
| Fee | Antigua And Barbuda |
| N/A | Argentina |
| Armenia | |
| Aruba | |
| Australia | |
| Austria | |
| Azerbaijan | |
| Bahamas | |
| Bahrain | |
| Bangladesh | |
| Barbados | |
| Belarus | |
| Belgium | |
| Belize | |
| Benin | |
| Bermuda | |
| Bhutan | |
| Bolivia | |
| Bosnia And Herzegovina | |
| Botswana | |
| Bouvet Island | |
| Brazil | |
| British Indian Ocean Territory | |
| Brunei Darussalam | |
| Bulgaria | |
| Burkina Faso | |
| Burundi | |
| Cambodia | |
| Cameroon | |
| Canada | |
| Cape Verde | |
| Cayman Islands | |
| Central African Republic | |
| Chad | |
| Chile | |
| China | |
| Christmas Island | |
| Cocos (Keeling) Islands | |
| Colombia | |
| Comoros | |
| Congo | |
| Congo, The Democratic Republic Of The | |
| Cook Islands | |
| Costa Rica | |
| Cote D'Ivoire | |
| Croatia | |
| Cuba | |
| Cyprus | |
| Czech Republic | |
| Denmark | |
| Djibouti | |
| Dominica | |
| Dominican Republic | |
| Ecuador | |
| Egypt | |
| El Salvador | |
| Equatorial Guinea | |
| Eritrea | |
| Estonia | |
| Ethiopia | |
| Falkland Islands (Malvinas) | |
| Faroe Islands | |
| Fiji | |
| Finland | |
| France | |
| French Guiana | |
| French Polynesia | |
| French Southern Territories | |
| Gabon | |
| Gambia | |
| Georgia | |
| Germany | |
| Ghana | |
| Gibraltar | |
| Greece | |
| Greenland | |
| Grenada | |
| Guadeloupe | |
| Guam | |
| Guatemala | |
| Guernsey | |
| Guinea | |
| Guinea-Bissau | |
| Guyana | |
| Haiti | |
| Heard Island And Mcdonald Islands | |
| Holy See (Vatican City State) | |
| Honduras | |
| Hong Kong | |
| Hungary | |
| Iceland | |
| India | |
| Indonesia | |
| Iran, Islamic Republic Of | |
| Iraq | |
| Ireland | |
| Isle Of Man | |
| Israel | |
| Italy | |
| Jamaica | |
| Japan | |
| Jersey | |
| Jordan | |
| Kazakhstan | |
| Kenya | |
| Kiribati | |
| Korea, Democratic People'S Republic Of | |
| Korea, Republic Of | |
| Kuwait | |
| Kyrgyzstan | |
| Lao People'S Democratic Republic | |
| Latvia | |
| Lebanon | |
| Lesotho | |
| Liberia | |
| Libyan Arab Jamahiriya | |
| Liechtenstein | |
| Lithuania | |
| Luxembourg | |
| Macao | |
| Macedonia, The Former Yugoslav Republic Of | |
| Madagascar | |
| Malawi | |
| Malaysia | |
| Maldives | |
| Mali | |
| Malta | |
| Marshall Islands | |
| Martinique | |
| Mauritania | |
| Mauritius | |
| Mayotte | |
| Mexico | |
| Micronesia, Federated States Of | |
| Moldova, Republic Of | |
| Monaco | |
| Mongolia | |
| Montserrat | |
| Morocco | |
| Mozambique | |
| Myanmar | |
| Namibia | |
| Nauru | |
| Nepal | |
| Netherlands | |
| Netherlands Antilles | |
| New Caledonia | |
| New Zealand | |
| Nicaragua | |
| Niger | |
| Nigeria | |
| Niue | |
| Norfolk Island | |
| Northern Mariana Islands | |
| Norway | |
| Oman | |
| Pakistan | |
| Palau | |
| Palestinian Territory, Occupied | |
| Panama | |
| Papua New Guinea | |
| Paraguay | |
| Peru | |
| Philippines | |
| Pitcairn | |
| Poland | |
| Portugal | |
| Puerto Rico | |
| Qatar | |
| Reunion | |
| Romania | |
| Russian Federation | |
| Rwanda | |
| Saint Helena | |
| Saint Kitts And Nevis | |
| Saint Lucia | |
| Saint Pierre And Miquelon | |
| Saint Vincent And The Grenadines | |
| Samoa | |
| San Marino | |
| Sao Tome And Principe | |
| Saudi Arabia | |
| Senegal | |
| Serbia And Montenegro | |
| Seychelles | |
| Sierra Leone | |
| Singapore | |
| Slovakia | |
| Slovenia | |
| Solomon Islands | |
| Somalia | |
| South Africa | |
| South Georgia And The South Sandwich Islands | |
| Spain | |
| Sri Lanka | |
| Sudan | |
| Suriname | |
| Svalbard And Jan Mayen | |
| Swaziland | |
| Sweden | |
| Switzerland | |
| Syrian Arab Republic | |
| Taiwan, Province Of China | |
| Tajikistan | |
| Tanzania, United Republic Of | |
| Thailand | |
| Timor-Leste | |
| Togo | |
| Tokelau | |
| Tonga | |
| Trinidad And Tobago | |
| Tunisia | |
| Turkey | |
| Turkmenistan | |
| Turks And Caicos Islands | |
| Tuvalu | |
| Uganda | |
| Ukraine | |
| United Arab Emirates | |
| United Kingdom | |
| United States | |
| United States Minor Outlying Islands | |
| Uruguay | |
| Uzbekistan | |
| Vanuatu | |
| Venezuela | |
| Viet Nam | |
| Virgin Islands, British | |
| Virgin Islands, U.S. | |
| Wallis And Futuna | |
| Western Sahara | |
| Yemen | |
| Zambia | |
| Zimbabwe | |
| (Not Specified) |
File details come from the government source that posted it. Updated .