Attachment J.7_Budget Template (2).xlsx
XLSX spreadsheet 153 KB Posted
- Solicitation number
- 72026821R00001
About this file
This document includes a request for proposals for the USAID/Lebanon Water, Sanitation and Conservation Project. USAID seeks proposals to implement a five-year project focused on water, sanitation and conservation in Lebanon through a cost-plus-fixed-fee contract estimated between $104-125 million. Proposals are due January 18, 2021, and the contract is expected to be awarded by September 30, 2021. USAID encourages participation from local Lebanese organizations, small businesses, veteran-owned small businesses, HUB zone small businesses, small disadvantaged businesses, and women-owned small businesses. The principal NAICS code is 541990 and the principal geographic code is 937.
View the file
Other files
Show all 22
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
Summary Budget
ATTACHMENT J.7: DETAILED BUDGET SUMMARY SPREADSHEET
| Please provide the information requested for each year, the totals and a by line item explanation. |
| All amounts in US $. If more subawardees are proposed please insert additional worksheets as needed. |
CLIN CLIN DESCRIPTION Year 1 Year 2 Year 3 Base Total Option 1: Year 4 Option 2: Year 5 BASE AND OPTIONS 1 AND 2 TOTAL Option 3 Increased Quantity BASE AND OPTIONS YEARS AND INCREASED QUANTITY OPTION TOTAL
1 SALARIES
2 FRINGE BENEFITS
3 CONSULTANTS
4 TRAVEL, TRANSPORTATION, PER DIEM
5 ALLOWANCES
6 SUBCONTRACTS*
7 EQUIPMENT
8 OTHER DIRECT COSTS
9 GRANTS
10 TOTAL DIRECT COSTS (1-9)
11 INDIRECT COSTS
12 TOTAL ESTIMATED COST (10+11)
13 FIXED FEE
14 TOTAL ESTIMATED COST INCLUDING FEE (12+13)
| NOTES: |
| *This budget format is to be similarly applied to all major sub-contractor budget presentations. The major sub-contractor(s) are subcontractors whose proposed costs exceed 10% of the offeror’s proposed total or perform a key element of the PWS. |
Prime Costs (US$)
| BUDGET SUMMARY SPREADSHEET: PRIME COSTS (US$) | ||||||||||
| ITEMS | Year 1 | Year 2 | Year 3 | BASE TOTAL | Option 1: Year 4 | Option 2: Year 5 | BASE AND OPTION YEARS TOTAL | Option 3: Increased Quantity | BASE AND OPTION YEARS AND INCREASED QUANTITY OPTION TOTAL | |
| A. SALARIES - DIRECT LABOR | Please insert relevant Unit and Unit Cost Information | |||||||||
| Long-Term Expatriates | ||||||||||
| Long-Term Cooperating Country Nationals (CCNs) | ||||||||||
| Short-Term Expatriates | ||||||||||
| Short-Term Cooperating Country Nationals (CCNs) | ||||||||||
| Home Office Support Staff | ||||||||||
| Total Direct Labor | ||||||||||
| B. FRINGE BENEFITS | ||||||||||
| Total Fringe Benefits | ||||||||||
| C. CONSULTANTS | ||||||||||
| Short-Term U.S./TCN Consultants | ||||||||||
| Short-Term CCN Consultants | ||||||||||
| Total Consultants | ||||||||||
| D. 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 | ||||||||||
| Total Travel, Transportation & Per Diem | ||||||||||
| E. ALLOWANCES | ||||||||||
| Post Differential | ||||||||||
| Temporary Quarters Subsistence Allowance (TQSA) | ||||||||||
| Living Quarters Allowance (LQA) | ||||||||||
| Housing Make-Ready (e.g., security upgrades, electrical work, generators, heating/air conditioning, water cooler, appliances, etc.) | ||||||||||
| Post (Cost of Living) Allowance | ||||||||||
| Educational Allowance | ||||||||||
| Educational Travel | ||||||||||
| Separate Maintenance Allowance (SMA) | ||||||||||
| Shipment of Unaccompanied Baggage (UAB) (Air Freight) | ||||||||||
| Storage of HHE | ||||||||||
| Consumables Shipment | ||||||||||
| Danger Pay | ||||||||||
| Total Allowances | ||||||||||
| F. NON-SECURITY EQUIPMENT | ||||||||||
| Laptop(s) | ||||||||||
| Fax machine(s) | ||||||||||
| Photocopier(s) | ||||||||||
| Household Furniture, Furnishings, and Appliances | ||||||||||
| Total Non-Security Equipment | ||||||||||
| G. OTHER DIRECT COSTS | ||||||||||
| Passports/Visas | ||||||||||
| Medical Exams/Inoculations | ||||||||||
| DBA Insurance or Equivalent | ||||||||||
| Medevac Coverage | ||||||||||
| Project Vehicle Insurance | ||||||||||
| Project Vehicle Operating and Maintenance Costs | ||||||||||
| Office Rent and Utilities (Electric, Heating, etc.) | ||||||||||
| Office Make-Ready | ||||||||||
| Office Equipment Service Contracts/Repairs | ||||||||||
| Office Supplies | ||||||||||
| Telephone/Fax Charges | ||||||||||
| Internet Access | ||||||||||
| Postage/Courier | ||||||||||
| Publications/Subscriptions | ||||||||||
| Report Preparation and Reproduction | ||||||||||
| Seminars, Workshops and Conferences | ||||||||||
| Environmental Compliance/Management | ||||||||||
| In-Country Training | ||||||||||
| U.S. and Third Country Training | ||||||||||
| Office Set-Ups (e.g., desks, chairs, tables, filing cabinets, etc.) | ||||||||||
| Office Computer Set-ups (CPU, monitor, printer, peripherals, UPS, etc.) | ||||||||||
| Telephone Sets and Cellular Phones | ||||||||||
| Total Other Direct Costs | ||||||||||
| H. GRANTS |
| Total Grants Costs |
| I. SUBCONTRACTS |
| Total Subcontracts |
| J. INDIRECT COSTS |
| Overhead |
| G&A |
| SubContracts Handling |
| Total Indirect Costs |
| TOTAL ESTIMATED COST |
| FIXED FEE/PROFIT |
| TOTAL ESTIMATED COST PLUS FIXED FEE |
Subcontractor Costs (US$)
| BUDGET SUMMARY SPREADSHEET: MAJOR SUBCONTRACTOR COSTS (US$) | ||||||||||
| ITEMS | Year 1 | Year 2 | Year 3 | BASE TOTAL | Option 1: Year 4 | Option 2: Year 5 | BASE AND OPTION YEARS TOTALBASE AND OPTION YEARS TOTAL | Option 3: Increased Quantity | BASE AND OPTION YEARS AND INCREASED QUANTITY OPTION TOTAL | |
| A. SALARIES - DIRECT LABOR | Please insert relevant Unit and Unit Cost Information | |||||||||
| Long-Term Expatriates | ||||||||||
| Long-Term Cooperating Country Nationals (CCNs) | ||||||||||
| Short-Term Expatriates | ||||||||||
| Short-Term Cooperating Country Nationals (CCNs) | ||||||||||
| Home Office Support Staff | ||||||||||
| Total Direct Labor | ||||||||||
| B. FRINGE BENEFITS | ||||||||||
| Total Fringe Benefits | ||||||||||
| C. CONSULTANTS | ||||||||||
| Short-Term U.S./TCN Consultants | ||||||||||
| Short-Term CCN Consultants | ||||||||||
| Total Consultants | ||||||||||
| D. 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 | ||||||||||
| Total Travel, Transportation & Per Diem | ||||||||||
| E. ALLOWANCES | ||||||||||
| Post Differential | ||||||||||
| Temporary Quarters Subsistence Allowance (TQSA) | ||||||||||
| Living Quarters Allowance (LQA) | ||||||||||
| Housing Make-Ready (e.g., security upgrades, electrical work, generators, heating/air conditioning, water cooler, appliances, etc.) | ||||||||||
| Post (Cost of Living) Allowance | ||||||||||
| Educational Allowance | ||||||||||
| Educational Travel | ||||||||||
| Separate Maintenance Allowance (SMA) | ||||||||||
| Shipment of Unaccompanied Baggage (UAB) (Air Freight) | ||||||||||
| Storage of HHE | ||||||||||
| Consumables Shipment | ||||||||||
| Danger Pay | ||||||||||
| Total Allowances | ||||||||||
| F. NON-SECURITY EQUIPMENT | ||||||||||
| Laptop(s) | ||||||||||
| Fax machine(s) | ||||||||||
| Photocopier(s) | ||||||||||
| Household Furniture, Furnishings, and Appliances | ||||||||||
| Total Non-Security Equipment | ||||||||||
| G. OTHER DIRECT COSTS | ||||||||||
| Passports/Visas | ||||||||||
| Medical Exams/Inoculations | ||||||||||
| DBA Insurance or Equivalent | ||||||||||
| Medevac Coverage | ||||||||||
| Project Vehicle Insurance | ||||||||||
| Project Vehicle Operating and Maintenance Costs | ||||||||||
| Office Rent and Utilities (Electric, Heating, etc.) | ||||||||||
| Office Make-Ready | ||||||||||
| Office Equipment Service Contracts/Repairs | ||||||||||
| Office Supplies | ||||||||||
| Telephone/Fax Charges | ||||||||||
| Internet Access | ||||||||||
| Postage/Courier | ||||||||||
| Publications/Subscriptions | ||||||||||
| Report Preparation and Reproduction | ||||||||||
| Seminars, Workshops and Conferences | ||||||||||
| Environmental Compliance/Management | ||||||||||
| In-Country Training | ||||||||||
| U.S. and Third Country Training | ||||||||||
| Office Set-Ups (e.g., desks, chairs, tables, filing cabinets, etc.) | ||||||||||
| Office Computer Set-ups (CPU, monitor, printer, peripherals, UPS, etc.) | ||||||||||
| Telephone Sets and Cellular Phones | ||||||||||
| Total Other Direct Costs | ||||||||||
| H. GRANTS |
| Total Grants Costs |
| I. SUBCONTRACTS |
| Total Subcontracts |
| J. INDIRECT COSTS |
| Overhead |
| G&A |
| SubContracts Handling |
| Total Indirect Costs |
| TOTAL ESTIMATED COST |
| FIXED FEE/PROFIT |
| TOTAL ESTIMATED COST PLUS FIXED FEE |
File details come from the government source that posted it. Updated .