Attachment 2 - Budget Template (REV 02).xlsx

XLSX spreadsheet 458 KB Posted

Attached to
"Justicia Efectiva Contra la Criminalidad y Corrupcion" Activity
Solicitation number
72052221R00007
Issued by

About this file

This document provides instructions and templates for a budget proposal in response to solicitation number 72052221R00007 from the US Agency for International Development Honduras.

The solicitation seeks professional and technical services for the "Justicia Efectiva Contra la Criminalidad y Corrupcion" Activity to reduce impunity, criminality, and corruption in Honduras by advancing an effective criminal justice system. Subject to availability of funds, USAID/Honduras intends to award one combination contract consisting of a cost reimbursement CLIN 0001 and an IDIQ CLIN 0002 contract for an estimated five-year period from date of award.

The budget templates include a line item award budget, summary budgets by cost category and year for both CLINs, detailed budgets with cost estimates for CLIN 0001 by category and year and CLIN 0002 by labor categories and other direct costs, and a level of effort summary. Instructions require completion of all templates according to the cost category structure and breakdowns, with formulas unlocked and numerical formatting. A detailed budget narrative supporting all cost estimates is also required.

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

INSTRUCTIONS

INSTRUCTIONS SUMMARY (For complete instructions refer to RFP Section L)

The Offeror must follow the structure/breakdowns detailed in the Budget Template. Formulas must be unlocked, cells that contain budget figures shall be formatted as numbers or currency, as applicable, with no decimal places and with comma separators. The Budget Template contains the following tabs/worksheets, all of which must be completed and submitted:
a. Award Budget by Line Item (CLIN)
b. Summary Budget by Cost Category, Year and by CLIN
c. Detailed Budget for CLIN 0001 by Cost Category and Year
d. Level of Effort (LOE) Summary by CLIN
e. Detailed Budget for CLIN 0002 by Cost Category and Year

The Award Budget, Summary Budget and LOE Summary worksheets derive data from the Detailed Budget worksheet, consequently these worksheets consolidate and summarize the information. Consolidated data are figures that appear within a cell because they have been calculated as the result of a formula, and not because they have been manually entered into the cell.

Additionally, a Summary and a Detailed Budget for each major subcontractors for CLIN 0001 must be submitted following the budget template and structure provided in Section J Attachment 2.

The Offeror must submit a cost proposal that complies with the instructions listed below:

(i) The AWARD BUDGET BY LINE ITEM must reflect the requirements of Section B.4. The final negotiated budget will be included in the resulting award.

(ii) The SUMMARY BUDGET BY COST CATEGORY will reflect the summary cost information for each of the major budget category, listing each of the contract year separately, and detailing the program total for the entire contract, item for item, in the last column of the worksheet.

(iii) The DETAILED BUDGET BY COST CATEGORY will reflect every estimated cost item, broken out detailing unit prices and estimated quantities. The detailed budget must reflect the individual cost items for each of the contract year separately, and detail the program total for the entire contract, item for item, in the last column of the worksheet.

(iv) The LEVEL OF EFFORT (LOE) SUMMARY shall support the resources needed for the approach proposed; it will include the quantity of LOE and the proposed cost associated with each category. This information will be used for cost realism analysis.

In addition to the Budget Template the offeror must submit a detailed BUDGET NARRATIVE that supports item for item the cost estimates proposed in its detailed budget. The budget narrative should describe the nature of individual cost items proposed and include a description of the source of that particular cost estimate (historical experience with the cost item, catalogue price, contractor price quotes, etc.). Narratives for the individual cost items must provide a discussion of any estimated escalation rates where applicable. Estimated costs proposed to exceed ceilings imposed by USAID or Federal procurement policy must be fully explained and justified. Budget narrative must be submitted in Word, text accessible.

The budget narrative must be provided in sufficient detail to allow complete cost realism, allowability, and reasonableness analyses of the proposal, therefore it must provide a detailed description and address why these costs are considered realistic, fair and reasonable and necessary to successfully implement the activity. This must include a complete breakdown of cost elements associated with each component and those costs associated with any proposed subcontract.

a_Award Budget by Line Item ATTACHMENT J.2.a: AWARD BUDGET BY LINE ITEM

LINE ITEM No.DESCRIPTION
0001CPFF COMPLETION CLIN – Technical Assistance
Direct Costs (Inclusive of Subcontracts)
Indirect Costs
Grants Under Contract (GUC)
Total Estimated Cost
Fixed Fee
CLIN 0001 Total Estimated Cost + Fixed Fee
0002IDIQ CLIN - Supplemental Technical Assitance
Direct Costs
Indirect Costs
Total Estimated Ceiling
Fixed Fee
CLIN 0002 Total Estimated Ceiling Cost + Fixed Fee
TOTAL CLIN 0001 + CLIN 0002

b_Summary Budget ATTACHMENT J.2.b: SUMMARY BUDGET

DESCRIPTIONYear 1Year 2Year 3Year 4Year 5TOTAL
CLIN 0001
1SALARIES
2FRINGE BENEFITS
3CONSULTANTS
4TRAVEL, TRANSPORTATION, PER DIEM
5ALLOWANCES
6PROCUREMENT (NxP)
7OTHER DIRECT COSTS
8GUCS (if applicable)
9SUBCONTRACTS*
10TOTAL DIRECT COSTS (1 through 9)
11INDIRECT COSTS
12TOTAL ESTIMATED COST (10+11)
13FIXED FEE
14TOTAL ESTIMATED CPFF (CLIN 0001) (12+13)
DESCRIPTIONYear 1Year 2Year 3Year 4Year 5TOTAL
CLIN 0002
aSALARIES & WAGES
bOTHER DIRECT COSTS
cTOTAL DIRECT COSTS (a+b)
dINDIRECT COSTS
eTOTAL ESTIMATED CEILING (c+d)
fFIXED FEE
gTOTAL ESTIMATED CPFF (CLIN 0002) (e+f)

c_Detailed Budget_0001 ATTACHMENT J.2.c: DETAILED BUDGET

CLIN 0001
ITEMSRATEUNITYear 1Year 2Year 3Year 4Year 5
$QTYCOST$QTYCOST$QTYCOST$QTYCOST$QTYCOSTTOTAL
SALARIES - DIRECT LABOR
Long-Term Expatriates (USN/TCN)
<LTTA Expatriate position>
<Insert more Staff lines here>
Long-Term Cooperating Country Nationals (CCNs)
<LTTA CCN position>
<Insert more Staff lines here>
Short-Term Expatriates
<STTA Expatriate position>
<Insert more Staff lines here>
Short-Term Cooperating Country Nationals (CCNs)
<STTA CCN position>
<Insert more Staff lines here>
Home Office Support Staff
<HO Staff position>
<Insert more Staff lines here>
TOTAL SALARIES
FRINGE BENEFITS
Fringe Benefit Rate (ie NICRA)
Local Staff Benefits
<Insert more Fringe lines here>
TOTAL FRINGE
CONSULTANTS
Short-Term U.S./TCN Consultants
<USN/TCN Consultant position>
<Insert more consultant lines here>
Short-Term CCN Consultants
<CCN Consultant position>
<Insert more consultant lines here>
USN/TCN Consultant Pool
CCN Consultant Pool
TOTAL CONSULTANTS
TRAVEL, TRANSPORTATION, AND PER DIEM
Assignment to Post/Repatriation Travel
R&R Travel
Home Leave Travel
In-Country Travel
In-Country Per Diem
U.S. and Third Country Travel
U.S. and Third Country Per Diem
Miscellanueos (includes to/from airport, visa, passports, etc.)
<Insert more lines here, if category not listed>
TOTAL TRAVEL
ALLOWANCES
Post Differential
Temporary Quarters Subsistence Allowance (TQSA)
Living Quarters Allowance (LQA)
Post (Cost of Living) Allowance
Educational Allowance
Educational Travel
Separate Maintenance Allowance (SMA)
Shipment of HHE (Surface Freight)
Shipment of Unaccompanied Baggage (UAB) (Air Freight)
Storage of HHE
Consumables Shipment
<Insert more Allowances lines here, if category not listed>
TOTAL ALLOWANCES
PROCUREMENT
IT Hardware and Software
<Insert line item here>
Office Equipment and Furniture
<Insert line item here>
Vehicles
<Insert line item here>
TOTAL PROCUREMENT
OTHER DIRECT COSTS
Vehicle Fuel
Vehicle Repairs and Maintenance
Vehicle Insurance
Other Vehicle Expenses
Office Rent
Office Utilities (Electric, Heating, etc.)
Office Make-Ready
Office Repairs/Maintenance
Office Supplies
Security Services
Cleaning Services
Cellular/Telephone Service
Internet Service
Postage/Courier
Publications/Subscriptions
Report Preparation and Reproduction
Environmental Compliance/Management
Branding and Marking
Banking Fees
Medical Exams/Inoculations
DBA Insurance or Equivalent
Medevac Coverage
Cellular Phones
Housing Make-Ready
Legal Services/Fees
Other Professional Services/Fees
Seminars, Workshops and Conferences
Participant Training
Other Project Activities
<Insert more ODC lines here, if category not listed>
TOTAL ODC
GRANTS UNDER CONTRACT (if applicable)
<Insert more Grant lines here>
TOTAL GUC
SUBCONTRACTS
<Insert Subcontractor lines here>
TOTAL SUBCONTRACTS
TOTAL DIRECT COSTS
INDIRECT COSTS
Overhead
G&A
SubContracts Handling
<Insert more lines here, if category not listed>
TOTAL INDIRECT COSTS
TOTAL ESTIMATED COST
FIXED FEE/PROFIT
TOTAL ESTIMATED COST PLUS FIXED FEE (CLIN 0001)

d_LOE Summary ATTACHMENT J.2.d: LOE SUMMARY

DESCRIPTIONTOTAL LOETOTAL COST
CLIN 0001
PRIME CONTRACTOR
LTTA - USN/TCN
LTTA - CCN*
STTA - USN/TCN
STTA - CCN
PRIME TOTAL
SUBCONTRACTORS
LTTA - USN/TCN
LTTA - CCN*
STTA - USN/TCN
STTA - CCN
SUBCONTRACTORS TOTAL
TOTAL (CLIN 0001)
DESCRIPTIONTOTAL LOETOTAL COST
CLIN 0002
LTTA - USN/TCN
LTTA - CCN
STTA - USN/TCN
STTA - CCN
TOTAL (CLIN 0002)

*Including administrative non-professional support e_Detailed Budget_0002 ATTACHMENT J.2.e: DETAILED BUDGET

CLIN 0002
ITEMSRATEUNITYear 1Year 2Year 3Year 4Year 5
$QTYCOST$QTYCOST$QTYCOST$QTYCOST$QTYCOSTTOTAL
SALARIES & WAGES
Labor Category 01: Expatriate Senior-Level Advisor
Labor Category 02: Expatriate Mid-Level Advisor
Labor Category 03: Local Senior-Level Advisor
Labor Category 04: Local Mid-Level Advisor
<Insert Labor Categories here, if applicable>
TOTAL SALARIES
OTHER DIRECT COSTS
<Insert ODC lines here, if applicable>
<Insert ODC lines here, if applicable>
TOTAL ODC
TOTAL DIRECT COSTS
INDIRECT COSTS
Overhead
G&A
SubContracts Handling
<Insert more lines here, if category not listed>
TOTAL INDIRECT COSTS
TOTAL ESTIMATED CEILING
FIXED FEE/PROFIT
TOTAL ESTIMATED COST PLUS FIXED FEE (CLIN 0002)

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