Attachment J.7_Budget Template [AMENDMENT 1].xlsx

XLSX spreadsheet 90 KB Posted Dec 16, 2020

Attached to: USAID/Lebanon Water, Sanitation and Conservation (WSC) Project
Solicitation number: 72026821R00001
Issued by: US Agency for International Development Middle East Regional Program Office Frankfurt

About this file

Written by GovTribe AI · Dec 27, 2023

This document includes a budget template attachment and related request for proposals for the USAID/Lebanon Water, Sanitation and Conservation Project. The budget template provides a detailed format for offerors to submit pricing for direct labor costs, fringe benefits, consultants, travel and transportation expenses, allowances, equipment, other direct costs, grants, subcontracts, and indirect costs across base years and multiple option periods. The request for proposals seeks implementation services for the USAID/Lebanon WSC Project, with an anticipated cost-plus-fixed-fee completion contract value ranging from $104 million to $125 million over five years. Offerors must submit performance work statements by January 18, 2021 outlining their technical approaches. The contract is expected to be awarded by September 30, 2021 and encourages participation from local Lebanese organizations, small businesses, and other specified business types.

View the file

Other files

File	Type	Posted
USAID_Lebanon_WSC RFP AMENDMENT NO. 2 - SF30-16c.pdf	PDF	Jan 21, 2021
USAID_Lebanon_WSC_RFP_Amendment_02.pdf	PDF	Jan 21, 2021
Attachment J.11_USAID Lebanon Vetting Mission Order.pdf	PDF	Dec 16, 2020
USAID_Lebanon_WSC_Answers to Questions from Interested Offerors.pdf	PDF	Dec 16, 2020
USAID_Lebanon_WSC_SF30-16c.pdf	PDF	Dec 16, 2020
Attachment J.d_Lebanon CSP IDIQ FY2020 Annual Report_ 2020 December 14 (Final).pdf	PDF	Dec 16, 2020
USAID_Lebanon_WSC_RFP_Amendment 1.pdf	PDF	Dec 16, 2020
Revised Attachment J.1_SOO.pdf	PDF	Dec 16, 2020
Attachment J.7_Budget Template (2).xlsx	XLSX spreadsheet	Dec 3, 2020
Attachment J.5 PAST PERFORMANCE MATRIX.xlsx	XLSX spreadsheet	Dec 3, 2020
USAID_Lebanon_WSC_RFP_Final.pdf	PDF	Dec 3, 2020
Attachment J.1a_USAID-LEBANON-GENDER-ASSESSMENT-Final-assessment 2019.pdf	PDF	Dec 3, 2020
Attachment J.6 Model Subcontracting Plan Template.doc	DOC document	Dec 3, 2020
Attachment J.1b_Rapid Youth Assessment.docx	DOCX document	Dec 3, 2020
Attachment J.1c_LWP-Y5Annual-report-docx_Final.pdf	PDF	Dec 3, 2020
Attachment J.8 USAID Local Compensation Plan Summary - Updated.pdf	PDF	Dec 3, 2020
Attachment J.2_AID-1420-17-6-13-19FINAL.doc	DOC document	Dec 3, 2020
Attachment J.4 Past Performance Questionnaire (1).docx	DOCX document	Dec 3, 2020
Attachment J.9_IEE.pdf	PDF	Dec 3, 2020
Attachment J.10 AID_500-13_Partner_Information_Form.doc	DOC document	Dec 3, 2020
Attachment J.3 Disclosure of Lobbying Activities (1).docx	DOCX document	Dec 3, 2020
Attachment J.1_WSC_SOO.docx	DOCX document	Dec 3, 2020

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 20% 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

IQO (US$)

	BUDGET SUMMARY SPREADSHEET: PRIME COSTS (US$)
	ITEMS	Option 3: Increased Quantity:
Year 1	Option 3: Increased Quantity:
Year 2	Option 3: Increased Quantity:
Year 3	Option 3: Increased Quantity:
Year 4	Option 3: Increased Quantity:
Year 5	Option 3: Increased Quantity:
TOTAL	Please insert relevant Unit and Unit Cost Information
	A. SALARIES - DIRECT LABOR
	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 Dec 16, 2020.