Attachment J.5 - ROPE Worksheet (Amended).xlsx
XLSX spreadsheet 74 KB Posted
- Attached to
- Armenia Resilience Activity
- Solicitation number
- 72011124R00005
- Issued by
-
US Agency for International Development
About this file
This document is an Excel worksheet titled "Attachment J.5 - ROPE Worksheet (Amended)" that provides cost estimates for a federal contract opportunity. The worksheet includes estimated costs for international and local in-country staff, fringe benefits, travel, equipment, supplies, contractual grants, program activities, consultants, subcontracts, and other direct costs over a 5-year period from 2025 to 2029. The key personnel categories include Chief of Party, Technical Advisors, Monitoring and Evaluation Manager, and various local staff roles such as Component Managers, Agronomists, and Operations staff. The worksheet requires the offeror to certify its standard business practice for billing paid absences for US citizen (USC) and third-country national (TCN) project staff. The total estimated cost over the 5-year period is $17,094,168.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 72011124R00005 Amendment 0002.pdf | ||
| 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 | |
| Armenia Resilience RFP 72011124R00005.pdf | ||
| Attachment J.5 - ROPE Worksheet.xlsx | XLSX spreadsheet | |
| Attachment J.7 Unburdened Ceiling Daily Rates.xlsx | XLSX spreadsheet |
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 By submitting this worksheet, (insert offeror's name) hereby certifies that it is (insert offeror's name) standandard business practice to (select one of the following two options) (option 1) "direct bill paid absence for USC and TCN project staff and therefore bill 260 work-days per year for such staff." (or option 2) "recover the cost of paid absence for USC and TCN project staff through an indirect rate and it is (insert offeror's name) established and verifiable business practice to direct bill (insert number) work-days per year."
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total Estimate | ||||||||||||||||||
| Jan 2025 - Dec 2025 | Jan 2026 - Dec 2026 | Jan 2027 - Dec 2027 | Jan 2028 - Dec 2028 | Jan 2029 - Dec 2029 | |||||||||||||||||||
| 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 | Senior level USC | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Technical Advisors (2) | Food Security/ Agriculture Expert/Specialist | Senior level USC | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Monitoring and Evaluation Manager | Monitoring, Evaluation, and Learning Specialist | Senior level USC | Day | - | Day | - | Day | - | Day | - | Day | - | - |
SUBTOTAL INTERNATIONAL STAFF - - - - - -
LOCAL IN-COUNTRY STAFF
| Program Staff | ||||||||||||||
| Deputy Chief of Party (Program and Operations) | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Component 1 Manager | Food Security/ Agriculture Expert/Specialist | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Component 2 Manager North | Food Security/ Agriculture Expert/Specialist | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Component 2 Manager South | Food Security/ Agriculture Expert/Specialist | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Accountant | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Field Agronimist/Monitor North | Food Security/ Agriculture Expert/Specialist | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Field Agronimist/Monitor South | Food Security/ Agriculture Expert/Specialist | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Monitoring and Evaluation Manager | Monitoring, Evaluation, and Learning Specialist | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Monitoring and Evaluation Assistant | Monitoring, Evaluation, and Learning Specialist | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Youth Specialist/Advisor | Gender/Inclusive Development Expert/ Specialist | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Gender Equality and Social Inclusion (GESI) Specialist | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Communications Officer | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - |
| Operational Staff | ||||||||||||||
| Operations Manager | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Senior level CCN / TCN | Day | - | Day | - | Day | - | - | Day | - | - | ||
| Finance Officer | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Accountant | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Communication and Education Specialist (Component 1) | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Data specialist (Component 1) | Digital Development/ Information Technology Expert/Specialist | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| GIS specialist | Digital Development/ Information Technology Expert/Specialist | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Procurement Specialist | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Office Manager | Operations (Finance, Administration, Contracts, Procurements, Communications, and similar) | Senior level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - | |
| Information Systems Officer | Digital Development/ Information Technology Expert/Specialist | Mid Level CCN / TCN | Day | - | Day | - | Day | - | Day | - | Day | - | - |
SUBTOTAL NATIONAL STAFF - - - - - -
TOTAL PERSONNEL - - - - - -
FRINGE BENEFITS
| Fringe - local staff | USAID Preset | Percent | 16.67% | - | - | Percent | 16.67% | - | - | Percent | 16.67% | - | - | Percent | 16.67% | - | - | Percent | 16.67% | - | - | - |
| Fringe - expat staff (corporate NICRA rate) | Corporate NICRA rate, if applicable | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | - |
TOTAL FRINGE BENEFITS - - - - - -
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,500 16,280,160
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,500 71,375 814,008
TOTAL COSTS 2,464,518 4,391,625 4,384,275 4,354,875 1,498,875 17,094,168
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 .