Attachment J.5 - Budget Template.xlsx
XLSX spreadsheet 66 KB Posted
- Attached to
- Green Recovery Investment Platform (GRIP)
- Solicitation number
- 7200AA22R00046
About this file
This document contains a budget template for the Green Recovery Investment Platform solicitation issued by the US Agency for International Development. The eight-year budget template outlines estimated costs for personnel, fringe benefits, travel, equipment, supplies, and subcontracts to support program operations. It includes placeholders for inflation factors and estimates $25 million annually for Global Unallocated Costs and $12.5 million annually for Field Support Activities. The total estimated value of the contract is $325 million over eight years.
View the file
Other files
Show all 15
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
Budget Summary
BUDGET TEMPLATE: SOL # 7200AA22R00046
1 The same budget information must be provided for subcontractors when subcontracting approval is requested at award
2. Offerors ar responsible for ensuring accuracy of excel formulas ; Total Fee
3. Plug figures for GUCS and Field Support activities are government estimates; the Offeror can propose alternate amounts corresponding to the specifics of their approach.
| Cost Category - CORE | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Total All Years | |
| a. | Personnel | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| b. | Fringe Benefits | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| c. | Travel | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| d. | Equipment | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| e. | Supplies | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| f. | Subcontracts | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| g. | GUCS | 1,325,000 | 1,325,000 | 1,325,000 | 1,325,000 | 1,325,000 | 1,325,000 | 1,325,000 | 1,325,000 | 25,000,000 |
| h. | Other Direct Costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| i. | Total Direct Charges | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| j. | Indirect Charges | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| k. | Fee-Profit (Non=GUCS) | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| TOTALS - CORE | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Cost Category - FIELD | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Total All Years | |
| Field Support Activities | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | $100,000,000 | |
| GUCs - Field | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | 12,500,000.00 | $100,000,000 | |
| TOTALs - FIELD | 25,000,000.00 | 25,000,000.00 | 25,000,000.00 | 25,000,000.00 | 25,000,000.00 | 25,000,000.00 | 25,000,000.00 | 25,000,000.00 | 200,000,000.00 |
&A
Detail - Core
| Fill in Inflation Factors on right. ---> | Program Office: | Inflation Factors | General Assumptions for Inflation Only |
| Country/Region: | Expatriate Salary Increase: | ||
| Program Name: | National Salary Increase: | ||
| Program Dates: | Cost Inflation Factor: |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |||||||||||||||||||||||||||
| <Dates> | <Dates> | <Dates> | <Dates> | <Dates> | <Dates> | <Dates> | <Dates> | Total Estimate | ||||||||||||||||||||||||||
| Description | Obj. | Out | ||||||||||||||||||||||||||||||||
| Come | 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 | Unit | No. of Units | Unit Cost (USD) | Year 6 Estimate | Unit | No. of Units | Unit Cost (USD) | Year 7 Estimate | Unit | No. of Units | Unit Cost (USD) | Year 8 Estimate |
PERSONNEL
INTERNATIONAL STAFF
| Expatriate Staff | |||||||||||||||||
| <Expatriate position> | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| <Expatriate position> | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| <Insert more Expatriate Staff lines here> | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
| HQ Technical Staff | |||||||||||||||||
| <HQ Technical position> | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| <HQ Technical position> | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| <Insert more HQ Technical position lines here> | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |
SUBTOTAL INTERNATIONAL STAFF - - - - - - - - -
LOCAL IN-COUNTRY STAFF
SUBTOTAL NATIONAL STAFF - - - - - - - - -
TOTAL PERSONNEL - - - - - - - - -
FRINGE BENEFITS
| - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | |
| - | - | - | - | - | - | - | - | - | |||||||||
| - | - | - | - | - | - | - | - | - | |||||||||
| TOTAL FRINGE BENEFITS | - | - | - | - | - | - | - | - | - | ||||||||
| 8 | |||||||||||||||||
| TRAVEL (SEE TRAVEL TABLE FOR ADDITIONAL INFO) |
| International Travel | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | - |
| Local & Domestic Travel | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | - |
TOTAL TRAVEL - - - - - - - - -
EQUIPMENT
| Vehicles (Restricted Item-Waivor Required) | ||||||||||
| <Specific vehicle type/model> | - | - | - | - | - | - | - | - | - | |
| <Specific vehicle type/model> | - | - | - | - | - | - | - | - | - | |
| <Specific vehicle type/model> | - | - | - | - | - | - | - | - | - | |
| <Insert more Vehicles lines here> | - | - | - | - | - | - | - | - | - |
Capital Equipment
Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):
Agreement Officer Pre-Approval Required Prior to Award for Purchase if "Capital Equipment?" Reference (2 CFR 230, 15 b [2]
| Unit Cost $5K> & 1 Year Life Expectancy or More) (22 CFR 226.25 [c] (6) & 22 CFR 226.2) | <Specific capital equipment> | - | - | - | - | - | - | - | - | - | |||||||||
| <Specific capital equipment> | - | - | - | - | - | - | - | - | - | ||||||||||
| <Specific capital equipment> | - | - | - | - | - | - | - | - | - | ||||||||||
| <Insert more Capital Equipment lines here> | - | - | - | - | - | - | - | - | - |
TOTAL EQUIPMENT - - - - - - - - -
SUPPLIES
| General Equipment ($1 to $4999) | ||||||||||
| <Specific general equipment> | - | - | - | - | - | - | - | - | - | |
| <Specific general equipment> | - | - | - | - | - | - | - | - | - | |
| <Specific general equipment> | - | - | - | - | - | - | - | - | - | |
| <Insert more Gen'l. Equipment lines here> | - | - | - | - | - | - | - | - | - | |
| <Insert more Gen'l. Equipment lines here> | - | - | - | - | - | - | - | - | - | |
| <Insert more Gen'l. Equipment lines here> | - | - | - | - | - | - | - | - | - | |
| <Insert more Gen'l. Equipment lines here> | - | - | - | - | - | - | - | - | - | |
| <Insert more Gen'l. Equipment lines here> | - | - | - | - | - | - | - | - | - |
TOTAL SUPPLIES - - - - - - - - -
SUBCONTRACTS
PROGRAM ACTIVITIES
| General Program Activities | ||||||||||
| <Specific program activity> | - | - | - | - | - | - | - | - | - | |
| <Specific program activity> | - | - | - | - | - | - | - | - | - | |
| <Specific program activity> | - | - | - | - | - | - | - | - | - | |
| <Specific program activity> | - | - | - | - | - | - | - | - | - | |
| <Insert more Program Activity lines here> | - | - | - | - | - | - | - | - | - |
| Training | ||||||||||
| <Specific training activity> | - | - | - | - | - | - | - | - | - | |
| <Specific training activity> | - | - | - | - | - | - | - | - | - | |
| <Insert more Training lines here> | - | - | - | - | - | - | - | - | - |
SUBTOTAL PROGRAM ACTIVITIES - - - - - - - - -
CONSULTANTS
| <International consultant role> | - | - | - | - | - | - | - | - | - |
| <International consultant role> | - | - | - | - | - | - | - | - | - |
| <Insert more Int'l. Consultant lines here> | - | - | - | - | - | - | - | - | - |
| Local Consultant | |||||||||
| <National consultant role> | - | - | - | - | - | - | - | - | - |
| <Insert more Nat'l. Consultant lines here> | - | - | - | - | - | - | - | - | - |
SUBTOTAL CONSULTANTS - - - - - - - - -
TOTAL SUBCONTRACTS - - - - - - - - -
GUCS - - - - - - - 25,000,000
OTHER DIRECT COSTS
TOTAL OTHER DIRECT COSTS - - - - - - - - -
DIRECT COSTS - - - - - - - -
INDIRECT COSTS
| Overhead | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | 0% | - | Indirect | 0% | - | Indirect | 0% | - | Indirect | 0% | - | - | ||||||||
| G&A | Indirect | - | - | Indirect | - | - | Indirect | - | - | Indirect | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | - |
| <Insert more Indirect Cost lines here> | - | - | - | - | - |
TOTAL INDIRECT COSTS - - - - - - - - -
FEE-PROFIT: Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 -
TOTAL COSTS - - - - - - - - -
&P of &N
Travel Table
| PER DIEM | ||||
| International Per Diem | (http://aoprals.state.gov/content.asp?content_id=184&menu_id=78) | |||
| US Per Diem | (http://www.gsa.gov/portal/content/104877) | |||
| Country Name | Location Name | Lodging | Meals & Incidentals | TOTAL PER DIEM |
| - 0 | ||||
| - 0 | ||||
| - 0 | ||||
| - 0 | ||||
| - 0 | ||||
| - 0 | ||||
| - 0 | ||||
| - 0 | ||||
| - 0 |
| INTERNATIONAL TRAVEL | |||||||||||
| Year | Origin | Destination | # of Trips | # of Travelers per Trip | Purpose | Estimated Unit Cost - Airfare | Total Cost - Airfare | # of Days | Per Diem Rate | Total Cost - Per Diem | Total Trip Cost |
| 1 | - 0 | - 0 | - 0 | ||||||||
| 1 | - 0 | - 0 | - 0 | ||||||||
| 1 | - 0 | - 0 | - 0 | ||||||||
| Year 1 Sub-Total | - 0 | ||||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| Year 2 Sub-Total | - 0 | ||||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| Year 3 Sub-Total | - 0 | ||||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| Year 4 Sub-Total | - 0 | ||||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| Year 5 Sub-Total | - 0 | ||||||||||
| TOTAL INTERNATIONAL TRAVEL | - 0 |
| DOMESTIC TRAVEL | |||||||||||
| Year | Origin | Destination | # of Trips | # of Travelers per Trip | Purpose | Estimated Unit Cost - Airfare | Total Cost - Airfare | # of Days | Per Diem Rate | Total Cost - Per Diem | Total Trip Cost |
| 1 | - 0 | - 0 | - 0 | ||||||||
| 1 | - 0 | - 0 | - 0 | ||||||||
| 1 | - 0 | - 0 | - 0 | ||||||||
| Year 1 Sub-Total | - 0 | ||||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| Year 2 Sub-Total | - 0 | ||||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| Year 3 Sub-Total | - 0 | ||||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| Year 4 Sub-Total | - 0 | ||||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| Year 5 Sub-Total | - 0 | ||||||||||
| TOTAL DOMESTIC TRAVEL | - 0 |
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 .