Annex 1 - CSO Summary Budget Template.xlsx
XLSX spreadsheet 113 KB Posted
- Attached to
- Tunisia Civil Society Activity
- Opportunity number
- 72066422RFA00001
About this file
Budget Template
View the file
Other files
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
| USAID/Tunisia |
| Activity Title: CSO Activity |
Prime Recipient Name:
| Cost Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total All Years | |
| a. | Personnel | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| b. | Fringe Benefits | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| c. | Travel | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| d. | Supplies | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| e. | Contractual | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| f. | Construction | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| g. | Other Direct Costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| h. | Total Direct Charges | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| i. | Indirect Charges | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| j. | TOTALS | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
&A
Detail
| USAID/Tunisia | Inflation Factors |
| Activity Title: CSO Activity | Expatriate Salary Increase: |
| National Salary Increase: | |
| Prime Recipient Name: | Cost Inflation Factor: |
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||||
| 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 |
PERSONNEL
INTERNATIONAL STAFF
| Expatriate Staff | ||||||||||||||||||||
| Year | 1 | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | - |
| HQ Technical Staff | |||||||||||||||
| Day | - | Day | - | - | Day | - | - | Day | - | - | Day | - | - | - |
SUBTOTAL INTERNATIONAL STAFF - - - - - - Ties
LOCAL IN-COUNTRY STAFF
| TUNIS OFFICE | |||||||||||||||||||
| TUNIS OFFICE Program Staff | |||||||||||||||||||
| Year | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | - |
| TUNIS OFFICE Operational Staff | |||||||||||||||||||
| Year | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | - |
| FIELD OFFICE | ||||||||||||||||||
| FIELD OFFICE Program Staff | ||||||||||||||||||
| Year | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | Year | - | - | - | |
| FIELD OFFICE Operational Staff | 1 | |||||||||||||||||
| Year | - | Year | 1 | - | - | Year | 1 | - | - | Year | 1 | - | - | Year | - | - | - |
SUBTOTAL NATIONAL STAFF - - - - - - Ties
TOTAL PERSONNEL - - - - - - Ties
FRINGE BENEFITS
| - | - | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | - | |
| - | - | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | - | |
| Expatriate Staff ALLOWANCES (Excluded in Overhead Calculation) | |||||||||||||||
| - | - | - | - | - | - | ||||||||||
| - | - | - | - | - | - | ||||||||||
| - | - | - | - | - | - |
TOTAL FRINGE BENEFITS - - - - - - Ties
TRAVEL (SEE TRAVEL TABLE FOR ADDITIONAL INFO)
| International Travel | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | - |
| Local & Domestic Travel | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | Total | 1 | - | - | - |
TOTAL TRAVEL - - - - - - Ties
EQUIPMENT
Vehicles (Restricted Item-Waivor Required)
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) Each - - - - - -
SUPPLIES
| General Equipment ($1 to $4999) | |||||||
| Each | - | - | - | - | - | - | |
| Each | - | - | - | - | - | - | |
| Each | - | - | - | - | - | - | |
| Each | - | - | - | - | - | - |
TOTAL SUPPLIES - - - - - - Ties
CONTRACTUAL
PROGRAM ACTIVITIES
| General Program Activities | |||||||
| - | |||||||
| Training | |||||||
| - | |||||||
| SUBTOTAL PROGRAM ACTIVITIES | - | - | - | - | - | - | Ties |
CONSULTANTS
| Design, Monitoring and Evaluation | |||||||
| Design, Monitoring and Evaluation | - | - | - | - | - | - |
| Consultants - Program | |||||||||||||||
| Expatriate Consultant | |||||||||||||||
| Senior & Mid Level Technical Assistance | Day | 550 | - | Day | 550 | - | Day | 550 | - | Day | 550 | - | - | - |
| Local Consultant | ||||||||||||||||
| Senior & Mid Level Technical Assistance | Day | 550 | - | Day | 550 | - | Day | 550 | - | Day | 550 | - | Day | 550 | - | - |
SUBTOTAL CONSULTANTS - - - - - - Ties
SUBGRANTS
| Local Organization | |||||||
| - | - | - | - | - | - | ||
| - | - | - | - | - | |||
| SUBTOTAL SUBGRANTS | - | - | - | - | - | - | Ties |
TOTAL CONTRACTUAL - - - - - - Ties
CONSTRUCTION
Construction - Program
TOTAL CONSTRUCTION - - - - - - Ties
OTHER DIRECT COSTS
| TUNIS OFFICE | ||||||
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| FIELD OFFICE | - | - | - | - | - | - |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | - | - | - | - | - | |
| - | ||||||
| - |
TOTAL OTHER COSTS - - - - - - Ties
DIRECT COSTS - - - - - - Ties
INDIRECT COSTS
| Overhead | Indirect | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | - |
| G&A | Indirect | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | Indirect | 0% | - | - | - |
TOTAL INDIRECT COSTS - - - - - - Ties
FEE-PROFIT (ACQ ONLY) Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 - Ties
TOTAL COSTS - - - - - - Ties
Libya LEAP
&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 |
| 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 |
(rounded)
| - 0 | - 0 | - 0 |
| - 0 | - 0 | - 0 |
| Year 1 Sub-Total | - 0 | ||
| - 0 | |||
| - 0 | |||
| - 0 | - 0 | - 0 | |
| Year 3 Sub-Total | - 0 | ||
| - 0 | - 0 | - 0 | |
| Year 4 Sub-Total | - 0 | ||
| - 0 | - 0 | - 0 | |
| - 0 | - 0 | - 0 | |
| - 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 |
| - 0 | |||||||||||
| - 0 | |||||||||||
| 2 | - 0 | - 0 | - 0 | ||||||||
| Year 2 Sub-Total | - 0 | ||||||||||
| 3 | - 0 | - 0 | - 0 | ||||||||
| Year 3 Sub-Total | - 0 | ||||||||||
| 4 | - 0 | - 0 | - 0 | ||||||||
| Year 4 Sub-Total | - 0 | ||||||||||
| 5 | - 0 | - 0 | - 0 | ||||||||
| Year 5 Sub-Total | - 0 | ||||||||||
| TOTAL DOMESTIC TRAVEL | - 0 |
Fee Calculation
| DoD Weighted Guidelines for FEE Calculation (ONLY TO BE USED IN ACQUISITION) |
| (http://www.acq.osd.mil/dpap/dars/dfars/html/r20061004/215_4.htm#215.404-70) |
PURPOSE: This program has been developed to assist in calculating profit/fee
| COST | ENTER COST | Instructions: This section will populate from the "Detail" Sheet. Please validate that the values. | |
| ITEM | CATEGORY | OBJECTIVE | |
| 13 | Material | $0 |
Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):
USAID does not typically buy raw materials to be manufacturered therefore no cost category was included.
14 Subcontracts - Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):
If there is GUC authority, this value should not include the grants under contracts, as fee on assistance is not allowed. Also, consultant rates should be fully burdened with fee inclusive of the rate.
| 15 | Direct Labor & Fringe | - | (All Direct Labor) | |||
| 16 | Indirect Expenses | $0 | (All Indirect Costs) | |||
| 17 | Other Direct Costs | ERROR:#REF! | (All Direct Costs not identified above) | |||
| 18 | Subtotal (13-17) | ERROR:#REF! | (Total cost less G&A,IR&D/B&P,and FCCOM) | |||
| 19 | G & A + OH | - | (G&A Expense and all IR&D/B&P) | |||
| 20 | Total Costs (18-19) | ERROR:#REF! | (Total cost less FCCOM) | |||
| Instructions: Each Activity Manager must justify the assigned weightings for both Technical and Management/Cost Control and the assigned value as well. A discussion must be had with the CO to discuss how to appropriately justify the rating. Also, enter the Contract Risk Type value. This should reflect the overall risk the contractor faces by entering into this contract with USAID. Special attention should be paid in situations where security and location are a factor, as this may increase the Assigned Value. This discussion should be documented within the justification. | ||||||
| ENTER | ENTER | |||||
| CONTRACTOR | ASSIGNED | ASSIGNED | BASE | PROFIT | ||
| RISK FACTORS | WEIGHTINGS | VALUE | (Item 20) | OBJECTIVE | ||
| 21 | Technical |
Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):
Must equal 100% DAU User: DAU User:
Students will need to justify the value assigned. However, students should use the technical incentive range of 7%-11%, norm of 9%. 22 Management/Cost Control
DAU User: DAU User:
| Students will need to justify the value assigned, the value range is 3% - 7%, norm of 5%. | Reserved | |||||
| 23 | Performance Risk (Composite) | 0% | 0.00 | ERROR:#REF! | Sample Justficiation: The assigned weighting for risk factors has been established at 60%; with an assigned value of 9%, for Technical and 40%; with an assigned value of 4% for Management/Cost Control, respectively. This was based on the discussions with the technical office on what proportion of the overall estimated cost revolved around technical approach vs. cost controls. In concurrence with the technical office, the CO was able to determine that management and cost control were of significant weight, but not directly as heavily weighted as the technical risk factor. The contract type risk for the offeror’s is very low as this is a cost reimbursement contract; whereby, the government assumes most of the risk. Additionally, no special concerns to security or unstable geo-political were taken into consideration. Using the structured fee approach, the government is able to set a pre-negotiation fee objective limit of 7.50% for realism against proposed fee by offerors. IAW U.S.C. 2306(d) and 41 U.S.C. 254 (b): (C) For other cost-plus-fixed-fee contracts, the fee shall not exceed 10 percent of the contract’s estimated cost, excluding fee. The pre-negotiation fee objective is within the established statute limitation. |
24 CONTRACT TYPE RISK ERROR:#REF!
| 25 | WORKING CAPITAL | ENTER | ENTER | |
| COSTS | LENGTH | INTEREST | ||
| ENTER PROG PAY RATE | FINANCED | FACTOR | RATE | |
| 0% | 0.00 | 0% |
| ENTER | ENTER | ||
| CONTRACTOR | ASSIGNED | AMOUNT | |
| FACILITIES CAPITAL EMPLOYED | VALUE | EMPLOYED | |
| 26 | Land | 0 | $0 |
| 27 | Buildings | 0% | $0 |
| 28 | Equipment | 0% |
DAU User: DAU User:
Students will need to justify the value assigned, between 10% - 25%, norm of 17.5%.
Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):
USAID does not typically buy raw materials to be manufacturered therefore no cost category was included.
Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):
If there is GUC authority, this value should not include the grants under contracts, as fee on assistance is not allowed. Also, consultant rates should be fully burdened with fee inclusive of the rate.
DAU User: DAU User:
| Students will enter the value, between 0% - 1%, norm of .5%. | $0 | ||||||
| 29 | Cost Efficiency | 0% | ERROR:#REF! | ERROR:#REF! | |||
| 30 | TOTAL PROFIT OBJECTIVE | ERROR:#REF! | |||||
| Negotiation Summary | Instructions: This section will help the Activity Manager and CO establish a pre-negotiation fee objective. This will be particularly important during Cost Realism and Reasonableness analysis. | ||||||
| Proposed | Objective | Negotiated | |||||
| 31 | Total Costs | ERROR:#REF! | |||||
| 32 | Facilities Capital COM (DD Fm 1861) | $0 | |||||
| 33 | Profit | ERROR:#REF! | |||||
| 34 | Total Price (Line 31+32+33) | ERROR:#REF! | |||||
| 35 | Markup Rate (Line 32+33 divided by 31) | % | ERROR:#REF! | % | |||
| 36 | Profit Rate (Line 33 divided by 31) | ERROR:#REF! |
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) |
image1.png
File details come from the government source that posted it. Updated .