Attachment J.4 Summary and Detailed Budget Template.xlsx

XLSX spreadsheet 291 KB Posted

Attached to
Monitoring, Evaluation, Collaboration, and Learning Activity (MECLA) Federal contract opportunity
Solicitation number
72030625R00001
Issued by
US Agency for International Development Afghanistan

About this file

Written by GovTribe AI ·

This is a detailed budget template spreadsheet (Attachment J.4) designed for a 5-year USAID contract proposal. The template includes sections for both prime contractor and subcontractor costs, with line items broken down across multiple categories: personnel (including expatriates and local nationals), fringe benefits, allowances, consultants, travel, equipment, other direct costs, grants under contract, security costs, and indirect costs. The template also contains detailed travel tables for both international and domestic travel planning.

The budget template is structured to capture comprehensive cost elements specific to international development work, including items like post differential allowances, educational allowances, danger pay, medevac coverage, and security costs (armored vehicles, security training, personal protection equipment). Each section requires unit costs, number of units, and total costs per year, with automatic summation across the 5-year period. The template includes specific notes indicating that major subcontractors (those exceeding 20% of total costs or performing key SOW elements) must provide similarly detailed budgets.

View the file

Other files for this federal contract opportunity

Other files attached to Monitoring, Evaluation, Collaboration, and Learning Activity (MECLA), newest first.
File Type Posted
MECLA RFP Amendment 0003 - Solicitation Suspension.pdf PDF
MECLA RFP Amendment 0002 - Additional Questions and Answers.pdf PDF
MECLA RFP Questions and Answers.pdf PDF
MECLA RFP 72030625R00001 - Amend 0001_executed.pdf PDF
MECLA RFP 72030625R00001_Revised 01.10.2025.pdf PDF
Attachment J.10 MECLA IEE ASIA 24-137.pdf PDF
Attachment J.3 Past Performance Information Matrix.xlsx XLSX spreadsheet
Attachment J.11 USAID Evaluation_Policy.pdf PDF
Attachment J.1 AID 1420-17 Contractor Employee Biographical Data Sheet.pdf PDF
Attachment J.8 SF-LLL (Rev. 7-97) Disclosure of Lobbying Activities.pdf PDF
Attachment J.6 Mission Order 201.06 - National Security Screening.pdf PDF
Attachment J.2 Subcontracting Plan Template.doc DOC document
Attachment J.7 Guidance in Developing a Security Plan.docx DOCX document
Request for Proposal (RFP) 72030625R00001_MECLA .pdf PDF
Attachment J.5 AID 500-13 Partner Information Form (PIF) - April 2024 - FINAL.pdf PDF
Attachment J.9 Certification Regarding Trafficking in Persons Compliance Plan.pdf PDF
Show all 16

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
Try for free Login

Text version

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

Summary Budget

ATTACHMENT J.4: 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 subcontractors are proposed please insert additional worksheets as needed.

CLIN CLIN DESCRIPTION Year 1 Year 2 Year 3 Option Year 4 Option Year 5 Total (Five Years)

1Personnel (Salary and Wages)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
2Fringe Benefits$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
3Allowances$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
4Consultants$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
5Travel, Transportation, and Per Diem$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
6Non-Security Equipment (Equipment and supplies)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
7Subcontracts$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
8Other Direct Costs (ODCs)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9Grants under Contract (GUCs)*$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
9Security Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11Opportunity Response Mechanism (ORM) **$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
10TOTAL DIRECT COSTS (1+9)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
11INDIRECT COSTS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
12TOTAL ESTIMATED COST (10+11)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
13FIXED FEE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
14TOTAL ESTIMATED COST INCLUDING FEE (12+13)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
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 SOW.
Equipment: To include all non-security equipment.

Prime Costs (US$)

BUDGET SUMMARY SPREADSHEET: PRIME COSTS (US$)
ITEMSYear 1Year 2Year 3Year 4Year 5TOTAL
UnitNo. of UnitsUnit Cost (USD)Year 1 EstimateUnitNo. of UnitsUnit Cost (USD)Year 2 EstimateUnitNo. of UnitsUnit Cost (USD)Year 3 EstimateUnitNo. of UnitsUnit Cost (USD)Year 4 EstimateUnitNo. of UnitsUnit Cost (USD)Year 5 Estimate(FIVE YEARS )
A. SALARIES - DIRECT LABORPlease 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. 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)
Danger Pay
Total Allowances
D. CONSULTANTS
Short-Term U.S./TCN Consultants
Short-Term CCN Consultants
Total Consultants
E. 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
Shipment of Household Effects (HHE) (Ocean Shipment)
Shipment of Unaccompanied Baggage (UAB) (Air Freight)
Shipment of Privately-Owned Vehicle (POV) (Ocean Shipment)
Storage of HHE
Consumables Shipment
Total Travel, Transportation & Per Diem
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 UNDER CONTRACT
Total Security Costs
I. SUBCONTRACTS
Total Subcontracts
J. SECURITY COSTS
Fully Armored Vehicles and/or Light Armored Vehicles
Security Training
Personal Protection Equipment
Total Security Costs
K. INDIRECT COSTS
Overhead
G&A
SubContracts Handling
Total Indirect Costs
TOTAL ESTIMATED COST
FIXED FEE/PROFIT
TOTAL ESTIMATED COST PLUS FIXED FEE

Subcontractor Detail Budget

BUDGET SUMMARY SPREADSHEET: SUBCONTRACTOR COSTS (US$)\

[SUBCONTRACTOR NAME]

ITEMSYear 1Year 2Year 3Year 4Year 5TOTAL
UnitNo. of UnitsUnit Cost (USD)Year 1 EstimateUnitNo. of UnitsUnit Cost (USD)Year 2 EstimateUnitNo. of UnitsUnit Cost (USD)Year 3 EstimateUnitNo. of UnitsUnit Cost (USD)Year 4 EstimateUnitNo. of UnitsUnit Cost (USD)Year 5 Estimate(FIVE YEARS )
A. SALARIES - DIRECT LABORPlease 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
Shipment of Household Effects (HHE) (Ocean Shipment)
Shipment of Unaccompanied Baggage (UAB) (Air Freight)
Shipment of Privately-Owned Vehicle (POV) (Ocean Shipment)
Storage of HHE
Consumables Shipment
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)
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. SECURITY COSTS
Fully Armored Vehicles and/or Light Armored Vehicles
Security Training
Personal Protection Equipment
Total Security 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

Travel Table

PER DIEM
International Per Diem(http://aoprals.state.gov/content.asp?content_id=184&menu_id=78)
US Per Diem(http://www.gsa.gov/portal/content/104877)
Country NameLocation NameLodgingMeals & IncidentalsTOTAL PER DIEM
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
INTERNATIONAL TRAVEL
YearOriginDestination# of Trips# of Travelers per TripPurposeEstimated Unit Cost - AirfareTotal Cost - Airfare# of DaysPer Diem RateTotal Cost - Per DiemTotal Trip Cost
1- 0- 0- 0
1- 0- 0- 0
1- 0- 0- 0
Year 1 Sub-Total- 0
2- 0- 0- 0
2- 0- 0- 0
2- 0- 0- 0
Year 2 Sub-Total- 0
3- 0- 0- 0
3- 0- 0- 0
3- 0- 0- 0
Year 3 Sub-Total- 0
4- 0- 0- 0
4- 0- 0- 0
4- 0- 0- 0
Year 4 Sub-Total- 0
5- 0- 0- 0
5- 0- 0- 0
5- 0- 0- 0
Year 5 Sub-Total- 0
TOTAL INTERNATIONAL TRAVEL- 0
DOMESTIC TRAVEL
YearOriginDestination# of Trips# of Travelers per TripPurposeEstimated Unit Cost - AirfareTotal Cost - Airfare# of DaysPer Diem RateTotal Cost - Per DiemTotal Trip Cost
1- 0- 0- 0
1- 0- 0- 0
1- 0- 0- 0
Year 1 Sub-Total- 0
2- 0- 0- 0
2- 0- 0- 0
2- 0- 0- 0
Year 2 Sub-Total- 0
3- 0- 0- 0
3- 0- 0- 0
3- 0- 0- 0
Year 3 Sub-Total- 0
4- 0- 0- 0
4- 0- 0- 0
4- 0- 0- 0
Year 4 Sub-Total- 0
5- 0- 0- 0
5- 0- 0- 0
5- 0- 0- 0
Year 5 Sub-Total- 0
TOTAL DOMESTIC TRAVEL- 0

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