Amendment No. 1_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
View the file
Other files for this federal contract opportunity
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 2: 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 |
b_Summary Budget
ATTACHMENT 2: SUMMARY BUDGET
| DESCRIPTION | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL | |
| 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-9) | ||||||
| 11 | INDIRECT COSTS | ||||||
| 12 | TOTAL ESTIMATED COST (10+11) | ||||||
| 13 | FIXED FEE | ||||||
| 14 | TOTAL 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 2: DETAILED BUDGET
| 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 |
d_LOE Summary
ATTACHMENT 2: LOE SUMMARY
| DESCRIPTION | TOTAL LOE | TOTAL 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 .