J.2 Budget and Budget Narrative Template.xlsx

XLSX spreadsheet 149 KB Posted

Attached to
Por la Protección de Defensores y Periodistas (PDP) (Defenders and Journalists Protection)
Solicitation number
72052321R00001
Issued by

About this file

This document contains an Independent Government Cost Estimate (IGCE) template for a federal assistance opportunity with the United States Agency for International Development (USAID) in Mexico.

The IGCE template provides instructions and formatting to estimate costs for the "Por la Protección de Defensores y Periodistas (PDP)" program, which aims to improve the capacity of governmental and non-governmental actors to protect Mexican journalists and human rights defenders. The template includes tabs for inputting details on personnel costs by position, fringe benefits, travel expenses, equipment, supplies, and indirect costs over a five-year period. Narrative sections provide guidance on assumptions for inflation, salary increases, and qualifications for key personnel. The template offers functions to automatically calculate subtotals and totals by cost category and year to estimate the total program budget.

View the file

Other files

File Type Posted
Attachment 1 of Amendment 2 - RFP 7205231R00001 PDP Changes.pdf PDF
72052321R00001 Amendment 2 signed.pdf PDF
Amendment 2 _ 72052321R00001 Track changes.pdf PDF
72052321R00001 Amendment 1 signed.pdf PDF
Attachment 2 - Questions and Answers - RFP 72052321R00001 PDP.pdf PDF
Attachment 4 - Attachment J.12 CDCS_Mexico-_September_2020-August_2025_v.Dec11_4.pdf PDF
Amendment 1 _ 72052321R00001 Track changes.pdf PDF
Attachment 3 - Attachment J.2 Budget Narrative Template.docx DOCX document
Attachment 1 - RFP 7205231R00001 PDP Changes.pdf PDF
J.2 Budget Narrative Template.docx DOCX document
J.2 Budget Template.xlsx XLSX spreadsheet
J.1 Statement of Objectives (SOO).pdf PDF
J.3 Initial Environmental Examination (IEE).pdf PDF
J.6 Small Business Subcontracting Plan Template.pdf PDF
J.5 Disclosure of Lobbying Activities Continuation Sheet.pdf PDF
J.1 Statement of Objectives (SOO).pdf PDF
J.5 Disclosure of Lobbying Activities.pdf PDF
J.7 Contractor Employee Biographical Data Sheet.pdf PDF
J.11 Illustrative Indicators List.pdf PDF
J.10 Past Performance Information (PPI) Form.pdf PDF
Solicitation 72052321R00001 - signed.pdf PDF
J.4 Branding Strategy, Branding Implementation Plan (Template) and Marking Plan (Template).pdf PDF
J.8 Quality Assurance Surveillance Plan (QASP).pdf PDF
J.9 Past Performance Matrix.xlsx XLSX spreadsheet
Show all 24

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

Cover Page

INDEPENDENT GOVERNMENT COST ESTIMATE
(IGCE) GUIDE AND TEMPLATE INSTRUCTIONS
BUREAU FOR MANAGEMENT (M)
OFFICE OF ACQUISITION AND ASSISTANCE
MANDATORY TEMPLATE SERIES

09/22/2016 v2

Instructions

IGCE TEMPLATE INSTRUCTIONS

You must save this IGCE as .xlsx file, or it will lose some of the formulas.

You should always use a blank template when creating a new IGCE. Do not reuse a template used for a previous program. The most current version of the template is available on the USAID Templates Website.

Do not delete sheets, rows or columns while preparing the IGCE! Columns and Rows that are not used for the IGCE should always be hidden, NOT deleted.

There are 6 tabs at the bottom of this workbook.
1. Instructions - Current Tab
2. Detail - This Tab will have the detailed IGCE with cost categories
3. Narrative - This Tab will allow you to explain each cost category in further detail. This will be the basis the CO/AO and Activity Manager base their cost realism and cost reasonableness analysis on.
4. IGCE Summary - This Tab is an overall snapshot of what was entered into the Detial Tab.
5. Travel Table- This Tab will allow you to list out expected travel for the requirement.
6. Fee Calculation - For contracts only. This tab has separate instructions and help you calculate fee using the DoD Weighted Guidelines Approach.

DETAILED WORKSHEET

Shaded cells indicate special attention needs to be paid to that cell. Do not alter or change any formulas unless you are able to re-connect link(s) within the worksheets

Modifying the Worksheet

Columns for years that will not be used should be HIDDEN. Do NOT delete any columns!

In general, rows can be added as needed. It is better to HIDE unused rows rather than delete. NEVER delete a shaded row, as these rows contain formulas or other required information!

Completing the IGCE Header

Enter the information for each header row in each yellow highlighted cell. Once an entry has been made, the cell will no longer be highlighted yellow. Additionally the headers will show up on other sheets that have been linked

Entering Inflation Factors

Enter the estimated Inflation Factors for the type of expense in the appropriate yellow shaded cell. The percentage will be applied to the unit cost for Years 2 to 5. Some costs do not automatically receive an inflation adjustment. Activity Managers should determine on a case by case basis for these costs whether increases in years 2 to 5 are necessary. All inflation factors should be justified.
Note - For costs that are first incured in year two or later, an initial unit cost needs to be included in year one for the inflation factor to be automatically calculated.
Expatriate Salary Increase: Inflation Factor is applied to expatriate, regional and HQ salaries.
National Salary Increase: Inflation Factor is applied to national staff salaries.
Cost Inflation Factor: Inflation Factor is applied to certain expense categories. Other categories do not automatically calculate an increased unit cost for inflation. Care should be taken when preparing the IGCE to ensure that cost inflation is applied to each applicable cost.

Example:

Labeling Column Sections for Year and Date

The IGCE template is separated into column sections by year.

Enter the expected year period in the space for <Dates>.

Separating Costs by Office within the Worksheet

Costs within each cost category should be shown separately for each office supporting and/or implementing the program. The template is formatted for the country office and one field office. Additional field offices can be inserted into the worksheet if there is more than one field office supporting or implementing the program.

Description

Cells in red have been provided in the Description column for additional entries. Enter a description of the cost item in the space provided. IGCE line descriptions are limited to the column width provided. Descriptions longer than the column width will be cut off. If more detail is needed, include that information in the Narrative Tab.

Certain cells in red indicate where to insert additional lines if needed. Insert additional lines above these lines.

Calculation Verification

There are several formulas built into the worksheets to assist with verifying that the spreadsheet is calculating totals correctly. These aids will not identify all the possible calculation errors and are meant only to assist the preparer in identifying and correcting errors. A thorough mathematical review should always be done by the Activity Manager prior to the IGCE being submitted to the CO/AO.
Note - The calculation verification formulas do not verify individual IGCE line calculations. If an individual IGCE line calculation formula has been altered or deleted, the IGCE line calculation may be incorrect. Each individual IGCE line should be recalculated manually when checking the overall IGCE.
Detail Sheet - Rows:
Each row that includes a total calculation has a formula to check the total in the column at the end of the row. If a cost is not calculated correctly, it will say "ERROR."

IGCE NARRATIVE

Care should be exercised to ensure the IGCE line descriptions in Column A match the descriptions in the IGCE Detail worksheet.

The IGCE Narrative is intended to assist the preparer, and should be modified, edited or deleted as needed.

&P of &N

Detail

Fill in Inflation Factors on right. --->Program Office:Inflation FactorsGeneral Assumptions for Inflation Only
Country/Region:Expatriate Salary Increase:
Program Name:National Salary Increase:
Program Dates:Cost Inflation Factor:
Year 1Year 2Year 3Year 4Year 5
<Dates><Dates><Dates><Dates><Dates>Total Estimate
DescriptionObj.Out
ComeUnitNo. of UnitsUnit Cost (USD)Year 1 EstimateUnitNo. of UnitsUnit Cost (USD)Year 2 EstimateUnitNo. of UnitsUnit Cost (USD)Year 3 EstimateUnitNo. of UnitsUnit Cost (USD)Year 4 EstimateUnitNo. of UnitsUnit Cost (USD)Year 5 Estimate

PERSONNEL

INTERNATIONAL STAFF

Expatriate Staff
Country Director----------
Deputy Country Director----------
Finance & Compliance Manager----------
Operations Manager----------
Chief of Party----------
Deputy Chief of Party----------
Program Coordinator----------
Program Manager----------
Technical Advisor----------
Monitoring and Evaluation Manager----------
<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 - - - - - - Ties

LOCAL IN-COUNTRY STAFF

<Head Office>
Program Staff
Project Manager----------
Project Officer----------
<Program position>----------
<Program position>----------
<Program position>----------
<Insert more Program Staff lines here>----------
Operational Staff
Senior Finance Officer----------
Bookkeeper----------
Cashier----------
<Insert more Finance Staff lines here>----------
Operations Officer----------
Procurement Officer----------
Procurement Assistant----------
Logistics Officer----------
<Insert more Logistics Staff lines here>----------
Office Manager----------
Human Resources Manager----------
Information Systems Officer----------
Receptionist----------
Translator/Interpreter----------
<Insert more Admin Staff lines here>----------
Driver----------
Guard----------
Cleaner----------
<Insert more Other Staff lines here>----------
<Field Office>
Program Staff
Project Manager----------
Project Officer----------
<Program position>----------
<Program position>----------
<Program position>----------
<Insert more Program Staff lines here>----------
Operational Staff
Senior Finance Officer----------
Bookkeeper----------
Cashier----------
<Insert more Finance Staff lines here>----------
Operations Officer----------
Procurement Officer----------
Procurement Assistant----------
Logistics Officer----------
<Insert more Logistics Staff lines here>----------
Office Manager----------
Human Resources Manager----------
Information Systems Officer----------
Receptionist----------
Translator/Interpreter----------
<Insert more Admin Staff lines here>----------
Driver----------
Guard----------
Cleaner----------
<Insert more Other Staff lines here>----------

SUBTOTAL NATIONAL STAFF - - - - - - Ties

TOTAL PERSONNEL - - - - - - Ties

FRINGE BENEFITS

Benefits - Local Staff-----------
Severance Pay - Local Staff-----------
Pooled Benefits - Expatriates & HQ Staff-----------
Shipping of Household Goods------
Relocation Allowances------
Storage Reimbursement - Expat Staff------
Dependent Education - Expatriate Staff------
Host Country Taxes - Expatriate Staff------
Danger Pay - Expatriate Staff------
Hardship Allowance - Expatriate Staff------
R&R Allowances - Expatriate Staff------
Other Benefits - Expatriate------
Housing - Individual and Shared----------
Employee Training----------

TOTAL FRINGE BENEFITS - - - - - - Ties

TRAVEL (SEE TRAVEL TABLE FOR ADDITIONAL INFO)

International TravelTotal1--Total1--Total1--Total1--Total1---
Local & Domestic TravelTotal1--Total1--Total1--Total1--Total1---

TOTAL TRAVEL - - - - - - Ties

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
<Specific capital equipment>------
<Specific capital equipment>------
<Specific capital equipment>------
<Insert more Capital Equipment lines here>------

TOTAL EQUIPMENT - - - - - - Ties

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 - - - - - - Ties

CONTRACTUAL

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 - - - - - - Ties

CONSULTANTS

Design, Monitoring and Evaluation
Design, Monitoring and Evaluation------
Consultants - Program
Expatriate Consultant
<International consultant role>------
<International consultant role>------
<Insert more Int'l. Consultant lines here>------
Local Consultant
<National consultant role>------
<National consultant role>------
<Insert more Nat'l. Consultant lines here>------

SUBTOTAL CONSULTANTS - - - - - - Ties

SUBGRANTS

US Organization
<Specific subgrant activity>------
<Specific subgrant activity>------
<Specific subgrant activity>------
Local Organization
<Specific local subgrant activity>------
<Specific local subgrant activity>------
<Specific local subgrant activity>------

SUBTOTAL SUBGRANTS - - - - - - Ties

TOTAL CONTRACTUAL - - - - - - Ties

CONSTRUCTION

Construction - Program
<Specific construction activity>Each-Each-Each-Each-Each--
<Specific construction activity>Each-Each-Each-Each-Each--
<Insert more Construction lines here>Each-Each-Each-Each-Each--

TOTAL CONSTRUCTION - - - - - - Ties

OTHER DIRECT COSTS

<Head Office>
Vehicle Rent/Lease----------
Vehicle Fuel----------
Vehicle Repairs and Maintenance----------
Vehicle Insurance----------
Other Vehicle Expenses----------
Professional Fees - Audit----------
Professional Fees - Legal----------
Professional Fees - Other----------
Temporary Labor----------
Branding and Marking----------
Equipment Rental----------
Software Licenses----------
Equipment Repairs and Maintenance----------
Advertising----------
Office Rent----------
Office Utilities----------
Office Repairs and Maintenance----------
Warehouse Rent----------
Warehouse Utilities----------
Warehouse Repairs & Maintenance----------
Security Services----------
Office Supplies----------
Warehouse Supplies----------
General Communications Expense----------
Mobile/Cellular Communications----------
Satellite Communications----------
Internet Communications----------
Printing and Photocopying----------
Courier and Postage----------
DBA Insurance----------
Dues, Subscriptions and References----------
Banking and Cash Handling Fees----------
Taxes, Filing and Registration Fees----------
<Insert more ODC lines here>----------
<Field Office>
Vehicle Rent/Lease----------
Vehicle Fuel----------
Vehicle Repairs and Maintenance----------
Vehicle Insurance----------
Other Vehicle Expenses----------
Professional Fees - Legal----------
Professional Fees - Other----------
Temporary Labor----------
Branding and Marking----------
Equipment Rental----------
Equipment Repairs and Maintenance----------
Advertising----------
Office Rent----------
Office Utilities----------
Office Repairs and Maintenance----------
Warehouse Rent----------
Warehouse Utilities----------
Warehouse Repairs & Maintenance----------
Security Services----------
Office Supplies----------
Warehouse Supplies----------
General Communications Expense----------
Mobile/Cellular Communications----------
Satellite Communications----------
Internet Communications----------
Printing and Photocopying----------
Courier and Postage----------
Dues, Subscriptions and References----------
Banking and Cash Handling Fees----------
Taxes, Filing and Registration Fees----------
<Insert more ODC lines here>----------

TOTAL OTHER COSTS - - - - - - Ties

DIRECT COSTS - - - - - - Ties

INDIRECT COSTS

Overhead Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):

Utilize previous NICRA's if possible to come up with a reasonable estimate.

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)Indirect--Indirect0%--Indirect0%--Indirect0%--Indirect0%---
G&AIndirect--Indirect0%--Indirect0%--Indirect0%--Indirect0%---
<Insert more Indirect Cost lines here>

Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):

Additional Indirect Costs will require the preparer to insert the base of application and equations.

Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):

Assumption: Overhead rate is to be charged to Personnel, Fringe, and Contractual Line Items. Tip: For Cost Realism and Resonableness, this may be an area of differentiation for the offerors/recipients cost proposal as each orgniazation calculates the base differently.

Ahmed, Mohib (M/OAA/OD): Ahmed, Mohib (M/OAA/OD):

Assumption: G&A being charged to all Direct Costs. This also may be an area where the offeror/recipient may calculate this cost differently. -

TOTAL INDIRECT COSTS - - - - - - Ties

FEE-PROFIT (ACQ ONLY) Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 - Ties

TOTAL COSTS - - - - - - Ties

Narrative

BUDGET NARRATIVE

Program Office:Assumptions for Inflation and salary
Country/Region:
Program Name:
Program Dates:
COST DESCRIPTIONASSUMPTIONSADDITIONAL INFO
PERSONNEL
EXPATRIATE STAFFDESCRIPTIONQUALIFICATIONS
Country Director<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Deputy Country Director<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Finance & Compliance Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Operations Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Chief of Party<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Deputy Chief of Party<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Program Coordinator<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Program Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Technical Advisor<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Monitoring and Evaluation Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Expatriate position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Expatriate position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Expatriate Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
HQ TECHNICAL STAFFDESCRIPTIONQUALIFICATIONS
<HQ Technical position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<HQ Technical position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more HQ Technical position lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL PROGRAM STAFF - HEAD OFFICEDESCRIPTIONQUALIFICATIONS
Project Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Project Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Program Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL OPERATIONAL STAFF - HEAD OFFICEDESCRIPTIONQUALIFICATIONS
Senior Finance Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Bookkeeper<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Cashier<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Finance Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Operations Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Procurement Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Procurement Assistant<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Logistics Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Logistics Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Office Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Human Resources Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Information Systems Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Receptionist<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Translator/Interpreter<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Admin Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Driver<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Guard<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Cleaner<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Other Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL PROGRAM STAFF - FIELD OFFICEDESCRIPTIONQUALIFICATIONS
Project Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Project Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Program Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL OPERATIONAL STAFF - FIELD OFFICEDESCRIPTIONQUALIFICATIONS
Senior Finance Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Bookkeeper<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Cashier<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Finance Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Operations Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Procurement Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Procurement Assistant<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Logistics Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Logistics Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Office Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Human Resources Manager<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Information Systems Officer<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Receptionist<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Translator/Interpreter<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Admin Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Driver<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Guard<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
Cleaner<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Other Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
FRINGE BENEFITSDESCRIPTION
Benefits - Local Staff<Describe in one or two sentences >
Severance Pay - Local Staff<Describe in one or two sentences >
Pooled Benefits - Expatriates & HQ Staff<Describe in one or two sentences >
Shipping of Household Goods<Describe in one or two sentences >
Relocation Allowances<Describe in one or two sentences >
Storage Reimbursement - Expat Staff<Describe in one or two sentences >
Dependent Education - Expatriate Staff<Describe in one or two sentences >
Host Country Taxes - Expatriate Staff<Describe in one or two sentences >
Danger Pay - Expatriate Staff<Describe in one or two sentences >
Hardship Allowance - Expatriate Staff<Describe in one or two sentences >
R&R Allowances - Expatriate Staff<Describe in one or two sentences >
Other Benefits - Expatriate<Describe in one or two sentences >
Housing - Individual and Shared<Describe in one or two sentences >
Employee Training<Describe in one or two sentences >

TRAVEL SEE TRAVEL TABLE

EQUIPMENTDESCRIPTION
VEHICLES
<Specific vehicle type/model><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
<Specific vehicle type/model><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
<Specific vehicle type/model><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
<Insert more Vehicles lines here><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
CAPITAL EQUIPMENT (NON-PROGRAM)
<Specific capital equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific capital equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific capital equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Capital Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
SUPPLIESDESCRIPTION
GENERAL EQUIPMENTGeneral equipment a unit price greater than $0 but less than $5,000
<Specific general equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific general equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific general equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
CONTRACTUALDESCRIPTION
GENERAL PROGRAM ACTIVITIES
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Insert more Program Activity lines here><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
TRAINING
<Specific training activity><Describe in one or two sentences the purpose of the training and how it relates to the program activity.>
<Specific training activity><Describe in one or two sentences the purpose of the training and how it relates to the program activity.>
<Insert more Training lines here><Describe in one or two sentences the purpose of the training and how it relates to the program activity.>
DESIGN, MONITORING AND EVALUATION
Design, Monitoring and Evaluation<Describe in one or two sentences the types of expenses included in the Design, Monitoring and Evaluation cost amount>
EXPATRIATE CONSULTANT
<International consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the office function.>
<International consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the office function.>
<Insert more Int'l. Consultant lines here><Describe in one or two sentences the purpose of the consultancy and how it relates to the office function.>
LOCAL CONSULTANTS
<National consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the program activity.>
<National consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the program activity.>
<Insert more Nat'l. Consultant lines here><Describe in one or two sentences the purpose of the consultancy and how it relates to the program activity.>
SUBGRANTS - US ORGANIZATIONS
<Specific subgrant activity>< Describe in one or two sentences the purpose of the subgrant.>
<Specific subgrant activity>< Describe in one or two sentences the purpose of the subgrant.>
<Specific subgrant activity>< Describe in one or two sentences the purpose of the subgrant.>
SUBGRANTS - LOCAL AGENCIES
<Specific local subgrant activity><Describe in one or two sentences the purpose of the subgrant.>
<Specific local subgrant activity><Describe in one or two sentences the purpose of the subgrant.>
<Specific local subgrant activity><Describe in one or two sentences the purpose of the subgrant.>
CONSTRUCTIONDESCRIPTION
CONSTRUCTION - PROGRAM
<Specific construction activity><Identify the construction activity. Describe in one or two sentences the construction program activity.>
<Specific construction activity><Identify the construction activity. Describe in one or two sentences the construction program activity.>
<Insert more Construction lines here><Identify the construction activity. Describe in one or two sentences the construction program activity.>
OTHER DIRECT COSTSDESCRIPTION
HEAD OFFICE COSTS
Vehicle Rent/Lease<Describe in one or two sentences the lease vs buy option, if applicable.>
Vehicle Fuel<Estimated monthly cost>
Vehicle Repairs and Maintenance<Estimated monthly cost>
Vehicle Insurance<Estimated monthly cost>
Other Vehicle Expenses<Estimated monthly cost>
Professional Fees - Audit<Estimated monthly cost>
Professional Fees - Legal<Estimated monthly cost>
Professional Fees - Other<Estimated monthly cost>
Temporary Labor<Estimated monthly cost>
Branding and Marking<Estimated monthly cost>
Equipment Rental<Estimated monthly cost>
Software Licenses<Estimated monthly cost>
Equipment Repairs and Maintenance<Estimated monthly cost>
Advertising<Estimated monthly cost>
Office Rent<Estimated monthly cost>
Office Utilities<Estimated monthly cost>
Office Repairs and Maintenance<Estimated monthly cost>
Warehouse Rent<Estimated monthly cost>
Warehouse Utilities<Estimated monthly cost>
Warehouse Repairs & Maintenance<Estimated monthly cost>
Security Services<Estimated monthly cost>
Office Supplies<Estimated monthly cost>
Warehouse Supplies<Estimated monthly cost>
General Communications Expense<Estimated monthly cost>
Mobile/Cellular Communications<Estimated monthly cost>
Satellite Communications<Estimated monthly cost>
Internet Communications<Estimated monthly cost>
Printing and Photocopying<Estimated monthly cost>
Courier and Postage<Estimated monthly cost>
DBA Insurance<Estimated monthly cost>
Dues, Subscriptions and References<Estimated monthly cost>
Banking and Cash Handling Fees<Estimated monthly cost>
Taxes, Filing and Registration Fees<Estimated monthly cost>
<Insert more ODC lines here><Estimated monthly cost>
FIELD OFFICE COSTS
Vehicle Rent/Lease<Describe in one or two sentences the lease vs buy option, if applicable.>
Vehicle Fuel<Estimated monthly cost>
Vehicle Repairs and Maintenance<Estimated monthly cost>
Vehicle Insurance<Estimated monthly cost>
Other Vehicle Expenses<Estimated monthly cost>
Professional Fees - Legal<Estimated monthly cost>
Professional Fees - Other<Estimated monthly cost>
Temporary Labor<Estimated monthly cost>
Branding and Marking<Estimated monthly cost>
Equipment Rental<Estimated monthly cost>
Equipment Repairs and Maintenance<Estimated monthly cost>
Advertising<Estimated monthly cost>
Office Rent<Estimated monthly cost>
Office Utilities<Estimated monthly cost>
Office Repairs and Maintenance<Estimated monthly cost>
Warehouse Rent<Estimated monthly cost>
Warehouse Utilities<Estimated monthly cost>
Warehouse Repairs & Maintenance<Estimated monthly cost>
Security Services<Estimated monthly cost>
Office Supplies<Estimated monthly cost>
Warehouse Supplies<Estimated monthly cost>
General Communications Expense<Estimated monthly cost>
Mobile/Cellular Communications<Estimated monthly cost>
Satellite Communications<Estimated monthly cost>
Internet Communications<Estimated monthly cost>
Printing and Photocopying<Estimated monthly cost>
Courier and Postage<Estimated monthly cost>
Dues, Subscriptions and References<Estimated monthly cost>
Banking and Cash Handling Fees<Estimated monthly cost>
Taxes, Filing and Registration Fees<Estimated monthly cost>
<Insert more ODC lines here><Estimated monthly cost>
INDIRECT COSTSDESCRIPTION
Overhead<Describe in one or two sentences the how this cost was estimated>
G&A<Describe in one or two sentences the how this cost was estimated>
<Insert more Indirect Cost lines here><Describe in one or two sentences the how this cost was estimated>
FEEDESCRIPTION
Fee-Profit<Reference Fee Calculation Tab>

IGCE Summary

IGCE SUMMARY

Program Office:
Country/Region:
Program Name:
Program Dates:
Cost CategoryYear 1Year 2Year 3Year 4Year 5Total 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.Equipment- 0- 0- 0- 0- 0- 0
e.Supplies- 0- 0- 0- 0- 0- 0
f.Contractual- 0- 0- 0- 0- 0- 0
g.Construction- 0- 0- 0- 0- 0- 0
h.Other Direct Costs- 0- 0- 0- 0- 0- 0
i.Total Direct Charges- 0- 0- 0- 0- 0- 0
j.Indirect Charges- 0- 0- 0- 0- 0- 0
k.Fee-Profit- 0- 0- 0- 0- 0- 0
l.TOTALS- 0- 0- 0- 0- 0- 0

&A

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 NameLocation NameLodgingMeals & IncidentalsTOTAL PER DIEM
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
INTERNATIONAL TRAVEL
YearOriginDestination# of Trips# of Travelers per TripPurposeEstimated Unit Cost - AirfareTotal Cost - Airfare# of DaysPer Diem RateTotal Cost - Per DiemTotal 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
YearOriginDestination# of Trips# of Travelers per TripPurposeEstimated Unit Cost - AirfareTotal Cost - Airfare# of DaysPer Diem RateTotal Cost - Per DiemTotal 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

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

COSTENTER COSTInstructions: This section will populate from the "Detail" Sheet. Please validate that the values.
ITEMCATEGORYOBJECTIVE
13Material$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.

15Direct Labor & Fringe-(All Direct Labor)
16Indirect Expenses$0(All Indirect Costs)
17Other Direct Costs-(All Direct Costs not identified above)
18Subtotal (13-17)(Total cost less G&A,IR&D/B&P,and FCCOM)
19G & A + OH-(G&A Expense and all IR&D/B&P)
20Total Costs (18-19)(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.
ENTERENTER
CONTRACTORASSIGNEDASSIGNEDBASEPROFIT
RISK FACTORSWEIGHTINGSVALUE(Item 20)OBJECTIVE
21Technical

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
23Performance Risk (Composite)0%0.00Sample 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

25WORKING CAPITALENTERENTER
COSTSLENGTHINTEREST
ENTER PROG PAY RATEFINANCEDFACTORRATE
0%0.000%
ENTERENTER
CONTRACTORASSIGNEDAMOUNT
FACILITIES CAPITAL EMPLOYEDVALUEEMPLOYED
26Land0$0
27Buildings0%$0
28Equipment0%

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
29Cost Efficiency0%ERROR:#VALUE!
30TOTAL PROFIT OBJECTIVEERROR:#VALUE!
Negotiation SummaryInstructions: 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.
ProposedObjectiveNegotiated
31Total Costs
32Facilities Capital COM (DD Fm 1861)$0
33ProfitERROR:#VALUE!
34Total Price (Line 31+32+33)ERROR:#VALUE!
35Markup Rate (Line 32+33 divided by 31)%ERROR:#VALUE!%
36Profit Rate (Line 33 divided by 31)ERROR:#VALUE!

Formula Sheet

CountryName
Afghanistan
Aland Islands
DayAlbania
MonthAlgeria
YearAmerican Samoa
EachAndorra
PercentAngola
TotalAnguilla
IndirectAntarctica
FeeAntigua And Barbuda
N/AArgentina
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

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .