ATTACHMENT J.2 - BUDGET TEMPLATE.xlsx

XLSX spreadsheet 192 KB Posted

Attached to
Community Violence Prevention Activity Federal contract opportunity
Solicitation number
72053220R00001
Issued by
US Agency for International Development Jamaica

About this file

Written by GovTribe AI ·

This document includes a budget template and travel table for estimating costs associated with the Community Violence Prevention Activity in Jamaica. The activity aims to support communities, parents, and families in preventing youth violence and developing pathway programs for at-risk youth. It will be implemented in three to five prioritized communities selected in conjunction with USAID/Jamaica and the Jamaican Ministry of National Security from the parishes of Kingston, St. Andrew, St. James, St. Catherine, and Clarendon. The budget template provides lines for estimating personnel, fringe benefits, travel, equipment, supplies, contractual, and indirect costs over five years. Inflation factors should be input on the right side. The travel table requires inputting details of international and domestic trips, such as origin, destination, number of trips and travelers, estimated airfare and per diem costs.

View the file

Other files for this federal contract opportunity

Other files attached to Community Violence Prevention Activity, newest first.
File Type Posted
COMET II Final Report_FINAL.pdf PDF
Questions & Answers.pdf PDF
Solicitation No. 72053220R00001 - Amendment No. 001.pdf PDF
Solicitation No. 72053220R00001 Community Violence Prevention (CVP) Activity.pdf PDF
ATTACHMENT J.9 LOCAL COMPENSATION PLAN (JAMAICA).pdf PDF
ATTACHMENT J.8 JA CBSI amend LAC-IEE-15-08.pdf PDF

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.

Detail

Fill in Inflation Factors on right. --->Program Office:Inflation FactorsGeneral Assumptions for Inflation Only
Country/Region:Expatriate Salary Increase:
Program Name:National Salary Increase:
Program Dates:Cost Inflation Factor:
Year 1Year 2Year 3Year 4Year 5
<Dates><Dates><Dates><Dates><Dates>Total Estimate
DescriptionObj.Out
ComeUnitNo. 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

PERSONNEL

INTERNATIONAL STAFF

Expatriate Staff
Country Director----------
Deputy Country Director----------
Finance & Compliance Manager----------
Operations Manager----------
Chief of Party----------
Deputy Chief of Party----------
Program Coordinator----------
Program Manager----------
Technical Advisor----------
Monitoring and Evaluation Manager----------
<Expatriate position>----------
<Expatriate position>----------
<Insert more Expatriate Staff lines here>----------
HQ Technical Staff
<HQ Technical position>----------
<HQ Technical position>----------
<Insert more HQ Technical position lines here>----------

SUBTOTAL INTERNATIONAL STAFF - - - - - - Ties

LOCAL IN-COUNTRY STAFF

<Head Office>
Program Staff
Project Manager----------
Project Officer----------
<Program position>----------
<Program position>----------
<Program position>----------
<Insert more Program Staff lines here>----------
Operational Staff
Senior Finance Officer----------
Bookkeeper----------
Cashier----------
<Insert more Finance Staff lines here>----------
Operations Officer----------
Procurement Officer----------
Procurement Assistant----------
Logistics Officer----------
<Insert more Logistics Staff lines here>----------
Office Manager----------
Human Resources Manager----------
Information Systems Officer----------
Receptionist----------
Translator/Interpreter----------
<Insert more Admin Staff lines here>----------
Driver----------
Guard----------
Cleaner----------
<Insert more Other Staff lines here>----------
<Field Office>
Program Staff
Project Manager----------
Project Officer----------
<Program position>----------
<Program position>----------
<Program position>----------
<Insert more Program Staff lines here>----------
Operational Staff
Senior Finance Officer----------
Bookkeeper----------
Cashier----------
<Insert more Finance Staff lines here>----------
Operations Officer----------
Procurement Officer----------
Procurement Assistant----------
Logistics Officer----------
<Insert more Logistics Staff lines here>----------
Office Manager----------
Human Resources Manager----------
Information Systems Officer----------
Receptionist----------
Translator/Interpreter----------
<Insert more Admin Staff lines here>----------
Driver----------
Guard----------
Cleaner----------
<Insert more Other Staff lines here>----------

SUBTOTAL NATIONAL STAFF - - - - - - Ties

TOTAL PERSONNEL - - - - - - Ties

FRINGE BENEFITS

Benefits - Local Staff-----------
Severance Pay - Local Staff-----------
Pooled Benefits - Expatriates & HQ Staff-----------
Shipping of Household Goods------
Relocation Allowances------
Storage Reimbursement - Expat Staff------
Dependent Education - Expatriate Staff------
Host Country Taxes - Expatriate Staff------
Danger Pay - Expatriate Staff------
Hardship Allowance - Expatriate Staff------
R&R Allowances - Expatriate Staff------
Other Benefits - Expatriate------
Housing - Individual and Shared----------
Employee Training----------

TOTAL FRINGE BENEFITS - - - - - - Ties

TRAVEL (SEE TRAVEL TABLE FOR ADDITIONAL INFO)

International TravelTotal1--Total1--Total1--Total1--Total1---
Local & Domestic TravelTotal1--Total1--Total1--Total1--Total1---

TOTAL TRAVEL - - - - - - Ties

EQUIPMENT

Vehicles (Restricted Item-Waivor Required)
<Specific vehicle type/model>------
<Specific vehicle type/model>------
<Specific vehicle type/model>------
<Insert more Vehicles lines here>------
Capital Equipment
<Specific capital equipment>------
<Specific capital equipment>------
<Specific capital equipment>------
<Insert more Capital Equipment lines here>------

TOTAL EQUIPMENT - - - - - - Ties

SUPPLIES

General Equipment ($1 to $4999)
<Specific general equipment>------
<Specific general equipment>------
<Specific general equipment>------
<Insert more Gen'l. Equipment lines here>------
<Insert more Gen'l. Equipment lines here>------
<Insert more Gen'l. Equipment lines here>------
<Insert more Gen'l. Equipment lines here>------
<Insert more Gen'l. Equipment lines here>------

TOTAL SUPPLIES - - - - - - Ties

CONTRACTUAL

PROGRAM ACTIVITIES

General Program Activities
<Specific program activity>------
<Specific program activity>------
<Specific program activity>------
<Specific program activity>------
<Insert more Program Activity lines here>------
Training
<Specific training activity>------
<Specific training activity>------
<Insert more Training lines here>------

SUBTOTAL PROGRAM ACTIVITIES - - - - - - Ties

CONSULTANTS

Design, Monitoring and Evaluation
Design, Monitoring and Evaluation------
Consultants - Program
Expatriate Consultant
<International consultant role>------
<International consultant role>------
<Insert more Int'l. Consultant lines here>------
Local Consultant
<National consultant role>------
<National consultant role>------
<Insert more Nat'l. Consultant lines here>------

SUBTOTAL CONSULTANTS - - - - - - Ties

GRANTS UNDER CONTRACT (GUC)

US Organization
<Specific subgrant activity>------
<Specific subgrant activity>------
<Specific subgrant activity>------
Local Organization
<Specific local subgrant activity>------
<Specific local subgrant activity>------
<Specific local subgrant activity>------

SUBTOTAL GRANTS UNDER CONTRACT (GUC) - - - - - - Ties

TOTAL CONTRACTUAL - - - - - - Ties

CONSTRUCTION

Construction - Program
<Specific construction activity>Each-Each-Each-Each-Each--
<Specific construction activity>Each-Each-Each-Each-Each--
<Insert more Construction lines here>Each-Each-Each-Each-Each--

TOTAL CONSTRUCTION - - - - - - Ties

OTHER DIRECT COSTS

<Head Office>
Vehicle Rent/Lease----------
Vehicle Fuel----------
Vehicle Repairs and Maintenance----------
Vehicle Insurance----------
Other Vehicle Expenses----------
Professional Fees - Audit----------
Professional Fees - Legal----------
Professional Fees - Other----------
Temporary Labor----------
Branding and Marking----------
Equipment Rental----------
Software Licenses----------
Equipment Repairs and Maintenance----------
Advertising----------
Office Rent----------
Office Utilities----------
Office Repairs and Maintenance----------
Warehouse Rent----------
Warehouse Utilities----------
Warehouse Repairs & Maintenance----------
Security Services----------
Office Supplies----------
Warehouse Supplies----------
General Communications Expense----------
Mobile/Cellular Communications----------
Satellite Communications----------
Internet Communications----------
Printing and Photocopying----------
Courier and Postage----------
DBA Insurance----------
Dues, Subscriptions and References----------
Banking and Cash Handling Fees----------
Taxes, Filing and Registration Fees----------
<Insert more ODC lines here>----------
<Field Office>
Vehicle Rent/Lease----------
Vehicle Fuel----------
Vehicle Repairs and Maintenance----------
Vehicle Insurance----------
Other Vehicle Expenses----------
Professional Fees - Legal----------
Professional Fees - Other----------
Temporary Labor----------
Branding and Marking----------
Equipment Rental----------
Equipment Repairs and Maintenance----------
Advertising----------
Office Rent----------
Office Utilities----------
Office Repairs and Maintenance----------
Warehouse Rent----------
Warehouse Utilities----------
Warehouse Repairs & Maintenance----------
Security Services----------
Office Supplies----------
Warehouse Supplies----------
General Communications Expense----------
Mobile/Cellular Communications----------
Satellite Communications----------
Internet Communications----------
Printing and Photocopying----------
Courier and Postage----------
Dues, Subscriptions and References----------
Banking and Cash Handling Fees----------
Taxes, Filing and Registration Fees----------
<Insert more ODC lines here>----------

TOTAL OTHER COSTS - - - - - - Ties

DIRECT COSTS - - - - - - Ties

INDIRECT COSTS

Overhead : Ahmed, Mohib (M/OAA/OD):

Utilize previous NICRA's if possible to come up with a reasonable estimate.

: Ahmed, Mohib (M/OAA/OD):

Agreement Officer Pre-Approval Required Prior to Award for Purchase if "Capital Equipment?" Reference (2 CFR 230, 15 b [2]

Unit Cost $5K> & 1 Year Life Expectancy or More) (22 CFR 226.25 [c] (6) & 22 CFR 226.2)Indirect--Indirect0%--Indirect0%--Indirect0%--Indirect0%---
G&AIndirect--Indirect0%--Indirect0%--Indirect0%--Indirect0%---
<Insert more Indirect Cost lines here>

: Ahmed, Mohib (M/OAA/OD):

Additional Indirect Costs will require the preparer to insert the base of application and equations.

: Ahmed, Mohib (M/OAA/OD):

Assumption: Overhead rate is to be charged to Personnel, Fringe, and Contractual Line Items. Tip: For Cost Realism and Resonableness, this may be an area of differentiation for the offerors/recipients cost proposal as each orgniazation calculates the base differently.

: Ahmed, Mohib (M/OAA/OD):

Assumption: G&A being charged to all Direct Costs. This also may be an area where the offeror/recipient may calculate this cost differently. -

TOTAL INDIRECT COSTS - - - - - - Ties

FEE-PROFIT (ACQ ONLY) Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 Fee - - 0 - Ties

TOTAL COSTS - - - - - - Ties

&P of

Summary

BUDGET SUMMARY

Country/Region:
Program Name:
Program Dates:
Cost CategoryYear 1Year 2Year 3Year 4Year 5Total All Years
a.Personnel- 0- 0- 0- 0- 0- 0
b.Fringe Benefits- 0- 0- 0- 0- 0- 0
c.Travel- 0- 0- 0- 0- 0- 0
d.Equipment- 0- 0- 0- 0- 0- 0
e.Supplies- 0- 0- 0- 0- 0- 0
f.Contractual- 0- 0- 0- 0- 0- 0
g.Construction- 0- 0- 0- 0- 0- 0
h.Other Direct Costs- 0- 0- 0- 0- 0- 0
i.Total Direct Charges- 0- 0- 0- 0- 0- 0
j.Indirect Charges- 0- 0- 0- 0- 0- 0
k.Fee-Profit- 0- 0- 0- 0- 0- 0
l.TOTALS- 0- 0- 0- 0- 0- 0

&A

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

Formula Sheet

CountryName
Afghanistan
Aland Islands
DayAlbania
MonthAlgeria
YearAmerican Samoa
EachAndorra
PercentAngola
TotalAnguilla
IndirectAntarctica
FeeAntigua And Barbuda
N/AArgentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Bosnia And Herzegovina
Botswana
Bouvet Island
Brazil
British Indian Ocean Territory
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Cayman Islands
Central African Republic
Chad
Chile
China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo
Congo, The Democratic Republic Of The
Cook Islands
Costa Rica
Cote D'Ivoire
Croatia
Cuba
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands (Malvinas)
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
French Southern Territories
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana
Haiti
Heard Island And Mcdonald Islands
Holy See (Vatican City State)
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran, Islamic Republic Of
Iraq
Ireland
Isle Of Man
Israel
Italy
Jamaica
Japan
Jersey
Jordan
Kazakhstan
Kenya
Kiribati
Korea, Democratic People'S Republic Of
Korea, Republic Of
Kuwait
Kyrgyzstan
Lao People'S Democratic Republic
Latvia
Lebanon
Lesotho
Liberia
Libyan Arab Jamahiriya
Liechtenstein
Lithuania
Luxembourg
Macao
Macedonia, The Former Yugoslav Republic Of
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia, Federated States Of
Moldova, Republic Of
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Mariana Islands
Norway
Oman
Pakistan
Palau
Palestinian Territory, Occupied
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saint Helena
Saint Kitts And Nevis
Saint Lucia
Saint Pierre And Miquelon
Saint Vincent And The Grenadines
Samoa
San Marino
Sao Tome And Principe
Saudi Arabia
Senegal
Serbia And Montenegro
Seychelles
Sierra Leone
Singapore
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Georgia And The South Sandwich Islands
Spain
Sri Lanka
Sudan
Suriname
Svalbard And Jan Mayen
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Taiwan, Province Of China
Tajikistan
Tanzania, United Republic Of
Thailand
Timor-Leste
Togo
Tokelau
Tonga
Trinidad And Tobago
Tunisia
Turkey
Turkmenistan
Turks And Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
United States Minor Outlying Islands
Uruguay
Uzbekistan
Vanuatu
Venezuela
Viet Nam
Virgin Islands, British
Virgin Islands, U.S.
Wallis And Futuna
Western Sahara
Yemen
Zambia
Zimbabwe
(Not Specified)

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