Attachment 2 - Budget Template (REV 02).xlsx
XLSX spreadsheet 458 KB Posted
- Solicitation number
- 72052221R00007
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 |
| 0001 | CPFF 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 | |
| 0002 | IDIQ 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
| DESCRIPTION | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL | |
| CLIN 0001 | |||||||
| 1 | SALARIES | ||||||
| 2 | FRINGE BENEFITS | ||||||
| 3 | CONSULTANTS | ||||||
| 4 | TRAVEL, TRANSPORTATION, PER DIEM | ||||||
| 5 | ALLOWANCES | ||||||
| 6 | PROCUREMENT (NxP) | ||||||
| 7 | OTHER DIRECT COSTS | ||||||
| 8 | GUCS (if applicable) | ||||||
| 9 | SUBCONTRACTS* | ||||||
| 10 | TOTAL DIRECT COSTS (1 through 9) | ||||||
| 11 | INDIRECT COSTS | ||||||
| 12 | TOTAL ESTIMATED COST (10+11) | ||||||
| 13 | FIXED FEE | ||||||
| 14 | TOTAL ESTIMATED CPFF (CLIN 0001) (12+13) |
| DESCRIPTION | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL | |
| CLIN 0002 | |||||||
| a | SALARIES & WAGES | ||||||
| b | OTHER DIRECT COSTS | ||||||
| c | TOTAL DIRECT COSTS (a+b) | ||||||
| d | INDIRECT COSTS | ||||||
| e | TOTAL ESTIMATED CEILING (c+d) | ||||||
| f | FIXED FEE | ||||||
| g | TOTAL ESTIMATED CPFF (CLIN 0002) (e+f) |
c_Detailed Budget_0001 ATTACHMENT J.2.c: DETAILED BUDGET
| CLIN 0001 | ||||||||||||||||||
| ITEMS | RATE | UNIT | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||
| $ | QTY | COST | $ | QTY | COST | $ | QTY | COST | $ | QTY | COST | $ | QTY | COST | TOTAL | |||
| 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
| DESCRIPTION | TOTAL LOE | TOTAL 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) |
| DESCRIPTION | TOTAL LOE | TOTAL 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 | ||||||||||||||||||
| ITEMS | RATE | UNIT | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||
| $ | QTY | COST | $ | QTY | COST | $ | QTY | COST | $ | QTY | COST | $ | QTY | COST | TOTAL | |||
| 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 .