Attachment 2 - Budget Template.xlsx

XLSX spreadsheet 373 KB Posted

Attached to
AMENDMENT NO. 1 to SOLICITATION - Building Climate Resilience (BCR) Activity Federal contract opportunity
Solicitation number
72052221R00002
Issued by
US Agency for International Development Honduras

View the file

Other files for this federal contract opportunity

Other files attached to AMENDMENT NO. 1 to SOLICITATION - Building Climate Resilience (BCR) Activity, newest first.
File Type Posted
Amendment No. 1_Attachment 11 - Q&As Document.pdf PDF
Amendment No.1_Attachment 1.h. Estrategia de Monitoreo_Calidad de Agua.pdf PDF
Amendment No. 1_Attachment 3 - Branding Strategy.pdf PDF
Amendment No. 1_Attachment 1.f. Migration Indicators Guidance.pdf PDF
Amendment No. 1_Attachment 1.e. USAIDs Geotargeting Approach.pdf PDF
Amendment No. 1_Attachment 1.g. Results Framework.pdf PDF
Amendment No. 1_72052221R00002 final.pdf PDF
Amendment No. 1_Attachment 2 - Budget Template.xlsx XLSX spreadsheet
Amendment No. 1_Attachment 4 - Key Indvidual Certification.pdf PDF
Amendment No. 1_Attachment 1.i. Analisis Rápido de los Ecosistemas Críticos.pdf PDF
Amendment No. 1_72052221R00002 Revised RFPfinal.pdf PDF
Amendment No. 1_RFP Cover letter final.pdf PDF
RFP 72052221R00002.pdf PDF
Attachment 10 - Subcontrating Plan.pdf PDF
Attachment 1. d USAID_FY_2021_Honduras_Country_Roadmap_en_US.pdf PDF
Attachment 1. c USAID_FY_2020_Honduras_Country_Roadmap_en_US.pdf PDF
Attachment 1. a USAID_Honduras CDCS Public Version_CLEAN.pdf PDF
RFP 7205221R00002Cover letter.pdf PDF
Attachment 9 - LCP 10OCT2021.pdf PDF
Attachment 5 - EBD Form No. AID 1420-17.doc DOC document
Attachment 4 - Key Indvidual Certification.pdf PDF
Attachment 8 - Sample Work Plan.pdf PDF
Attachment 1. b Western Honduras VA_ENGLISH_FINAL.pdf PDF
Attachment 7 - Past Performance Matrix.xlsx XLSX spreadsheet
Attachment 6 - LACIEE2105 ETD HO - Amend LACIEE1634 Extreme Poverty Sustainably Reduced.pdf PDF
Attachment 3 - Branding Strategy.pdf PDF
Show all 26

On GovTribe

Work with this file on GovTribe

  • 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 insturctins 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
b. Summary Budget by Cost Category, Year and Period (if applicable)
c. Detailed Budget by Cost Category, Year and Period (if applicable)
d. Level of Effort (LOE) Summary by Period (if applicable)

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

(3) 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.X.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
Fixed Fee
Estimated Cost
Fixed Fee
CLIN 0002 Total Estimated Ceiling Cost + Max Fixed Fee
TOTAL CLIN 0001 + CLIN 0002

b_Summary Budget ATTACHMENT J.X.b: SUMMARY BUDGET

DESCRIPTIONYear 1Year 2Year 3Year 4Year 5TOTAL
1SALARIES
2FRINGE BENEFITS
3CONSULTANTS
4TRAVEL, TRANSPORTATION, PER DIEM
5ALLOWANCES
6PROCUREMENT (NxP)
7OTHER DIRECT COSTS
8GUCS (if applicable)
9SUBCONTRACTS*
10TOTAL DIRECT COSTS (1-9)
11INDIRECT COSTS
12TOTAL ESTIMATED COST (10+11)
13FIXED FEE
14TOTAL ESTIMATED COST PLUS FEE (12+13)
NOTES:
*This budget format is to be similarly applied to all major sub-contractor budget presentations.
Please provide the information requested for each period year, the totals and a by line item explanation.
All amounts in US $. Please insert additional worksheets for mayor-subcontrators as needed.

c_Detailed Budget ATTACHMENT J.X.c: DETAILED BUDGET

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

d_LOE Summary ATTACHMENT J.2.d: LOE SUMMARY

DESCRIPTIONTOTAL LOETOTAL COST
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

*Including administrative non-professional support

Sheet1

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