J.04_-_Budget_Format.xlsx

XLSX spreadsheet 104 KB Posted

Attached to
Pakistan Capacity Development Services (PCDS) Federal contract opportunity
Solicitation number
SOL-391-17-0000TBD
Issued by
US Agency for International Development Pakistan

About this file

From the source

BUDGET FORMAT

View the file

Other files for this federal contract opportunity

Other files attached to Pakistan Capacity Development Services (PCDS), newest first.
File Type Posted
Attachment_J.11_-_Q_&_A.pdf PDF
Amendment_-_02.pdf PDF
Revised_Solicitation_-__PCDS-Small_Business.pdf PDF
Amendment_01_-_SOL_PCDS_Small_Business.pdf PDF
SOL_PCDS-Small_Business.pdf PDF
J.06_Interim_Tax_Guidance.pdf PDF
J.08_-_List_of_Direct__Indirect_Partners.xlsx XLSX spreadsheet
J.03_-_IEE.pdf PDF
J.05_-_SF-1034.pdf PDF
J.10_-_SF_LLL_Disclosure_of_Lobbying_Activities.pdf PDF
Attachment_B.pdf PDF
RFI_-_Signed.pdf PDF
Show all 12

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.

Instructions

BUDGET TEMPLATE INSTRUCTIONS

You must save this budget template as .xlsx file, or it will lose some of the formulas.

Do not delete sheets, rows or columns while preparing the budget! Columns and Rows that are not used for the budget should always be hidden, NOT deleted.

There are 4 tabs at the bottom of this workbook.
1. Instructions - Current Tab
2. Detail - This Tab will have the detailed budget with cost categories.
3. Narrative - This Tab will allow you to explain each cost category in further detail.
4. Summary - This Tab is an overall snapshot of what was entered into the Detail Tab.

DETAILED WORKSHEET

Shaded cells indicate special attention needs to be paid to that cell. Do not alter or change any formulas unless you are able to re-connect link(s) within the worksheets

Modifying the Worksheet

Columns for years that will not be used should be HIDDEN. Do NOT delete any columns!

In general, rows can be added as needed. It is better to HIDE unused rows rather than delete. NEVER delete a shaded row, as these rows contain formulas or other required information!

Description

Cells in red have been provided in the Description column for additional entries. Enter a description of the cost item in the space provided. Budget line descriptions are limited to the column width provided. Descriptions longer than the column width will be cut off. If more detail is needed, include that information in the Narrative Tab.

Certain cells in red indicate where to insert additional lines if needed. Insert additional lines above these lines.

Calculation Verification

There are several formulas built into the worksheets to assist with verifying that the spreadsheet is calculating totals correctly. These aids will not identify all the possible calculation errors and are meant only to assist the preparer in identifying and correcting errors. A thorough mathematical review should always be done by the preparer prior to the submission.
Note - The calculation verification formulas do not verify individual budget line calculations. If an individual budget line calculation formula has been altered or deleted, the budget line calculation may be incorrect. Each individual budget line should be recalculated manually when checking the overall budget.

BUDGET NARRATIVE

Care should be exercised to ensure the budget line descriptions in Column A match the descriptions in the budget Detail worksheet.

&G &P of &N

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
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
<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
----------
----------
<Program position>----------
<Program position>----------
<Program position>----------
<Insert more Program Staff lines here>----------
Operational Staff
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
<Field Office>
Program Staff
----------
----------
<Program position>----------
<Program position>----------
<Program position>----------
<Insert more Program Staff lines here>----------
Operational Staff
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------
----------

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 TravelTotal1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!ERROR:#REF!
Local & Domestic TravelTotal1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!Total1ERROR:#REF!ERROR:#REF!ERROR:#REF!

TOTAL TRAVEL ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

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

SUBGRANTS

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 SUBGRANTS - - - - - - 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): Ahmed, Mohib (M/OAA/OD):

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

Ahmed, Mohib (M/OAA/OD): 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-
G&AIndirect-
<Insert more Indirect Cost lines here>

Ahmed, Mohib (M/OAA/OD): 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): 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): 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 Fee - Ties

TOTAL COSTS - - - - - - Ties

Detailed Budget &"Arial,Bold"Mercy Corps &P of &N

Narrative

BUDGET NARRATIVE

Assumptions for Inflation and salary

COST DESCRIPTIONASSUMPTIONSADDITIONAL INFO
PERSONNEL
EXPATRIATE STAFFDESCRIPTIONQUALIFICATIONS
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Expatriate position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Expatriate position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Expatriate Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
HQ TECHNICAL STAFFDESCRIPTIONQUALIFICATIONS
<HQ Technical position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<HQ Technical position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more HQ Technical position lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL PROGRAM STAFF - HEAD OFFICEDESCRIPTIONQUALIFICATIONS
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Program Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL OPERATIONAL STAFF - HEAD OFFICEDESCRIPTIONQUALIFICATIONS
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
0<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL PROGRAM STAFF - FIELD OFFICEDESCRIPTIONQUALIFICATIONS
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Program position><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Insert more Program Staff lines here><Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
NATIONAL OPERATIONAL STAFF - FIELD OFFICEDESCRIPTIONQUALIFICATIONS
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
0<Describe in one or two sentences the purpose and main responsibilities of this position.><Describe in one or two sentences the qulifications required for such position>
FRINGE BENEFITSDESCRIPTION
Benefits - Local Staff<Describe in one or two sentences >
Severance Pay - Local Staff<Describe in one or two sentences >
Pooled Benefits - Expatriates & HQ Staff<Describe in one or two sentences >
Shipping of Household Goods<Describe in one or two sentences >
Relocation Allowances<Describe in one or two sentences >
Storage Reimbursement - Expat Staff<Describe in one or two sentences >
Dependent Education - Expatriate Staff<Describe in one or two sentences >
Host Country Taxes - Expatriate Staff<Describe in one or two sentences >
Danger Pay - Expatriate Staff<Describe in one or two sentences >
Hardship Allowance - Expatriate Staff<Describe in one or two sentences >
R&R Allowances - Expatriate Staff<Describe in one or two sentences >
Other Benefits - Expatriate<Describe in one or two sentences >
Housing - Individual and Shared<Describe in one or two sentences >
Employee Training<Describe in one or two sentences >

TRAVEL SEE TRAVEL TABLE

EQUIPMENTDESCRIPTION
VEHICLES
<Specific vehicle type/model><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
<Specific vehicle type/model><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
<Specific vehicle type/model><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
<Insert more Vehicles lines here><Describe in one or two sentences how the vehicle will be utilized. Include anticipated source/origin if not US.>
CAPITAL EQUIPMENT (NON-PROGRAM)
<Specific capital equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific capital equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific capital equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Capital Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
SUPPLIESDESCRIPTION
GENERAL EQUIPMENTGeneral equipment a unit price greater than $0 but less than $5,000
<Specific general equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific general equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Specific general equipment><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
<Insert more Gen'l. Equipment lines here><Describe in one or two sentences the purpose/how the equipment relates to the office function.>
CONTRACTUALDESCRIPTION
GENERAL PROGRAM ACTIVITIES
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Specific program activity><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
<Insert more Program Activity lines here><Identify the program activity. Describe in one or two sentences the expense and how it relates to a program activity.>
TRAINING
<Specific training activity><Describe in one or two sentences the purpose of the training and how it relates to the program activity.>
<Specific training activity><Describe in one or two sentences the purpose of the training and how it relates to the program activity.>
<Insert more Training lines here><Describe in one or two sentences the purpose of the training and how it relates to the program activity.>
DESIGN, MONITORING AND EVALUATION
Design, Monitoring and Evaluation<Describe in one or two sentences the types of expenses included in the Design, Monitoring and Evaluation cost amount>
EXPATRIATE CONSULTANT
<International consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the office function.>
<International consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the office function.>
<Insert more Int'l. Consultant lines here><Describe in one or two sentences the purpose of the consultancy and how it relates to the office function.>
LOCAL CONSULTANTS
<National consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the program activity.>
<National consultant role><Describe in one or two sentences the purpose of the consultancy and how it relates to the program activity.>
<Insert more Nat'l. Consultant lines here><Describe in one or two sentences the purpose of the consultancy and how it relates to the program activity.>
SUBGRANTS - US ORGANIZATIONS
<Specific subgrant activity>< Describe in one or two sentences the purpose of the subgrant.>
<Specific subgrant activity>< Describe in one or two sentences the purpose of the subgrant.>
<Specific subgrant activity>< Describe in one or two sentences the purpose of the subgrant.>
SUBGRANTS - LOCAL AGENCIES
<Specific local subgrant activity><Describe in one or two sentences the purpose of the subgrant.>
<Specific local subgrant activity><Describe in one or two sentences the purpose of the subgrant.>
<Specific local subgrant activity><Describe in one or two sentences the purpose of the subgrant.>
CONSTRUCTIONDESCRIPTION
CONSTRUCTION - PROGRAM
<Specific construction activity><Identify the construction activity. Describe in one or two sentences the construction program activity.>
<Specific construction activity><Identify the construction activity. Describe in one or two sentences the construction program activity.>
<Insert more Construction lines here><Identify the construction activity. Describe in one or two sentences the construction program activity.>
OTHER DIRECT COSTSDESCRIPTION
HEAD OFFICE COSTS
Vehicle Rent/Lease<Describe in one or two sentences the lease vs buy option, if applicable.>
Vehicle Fuel<Estimated monthly cost>
Vehicle Repairs and Maintenance<Estimated monthly cost>
Vehicle Insurance<Estimated monthly cost>
Other Vehicle Expenses<Estimated monthly cost>
Professional Fees - Audit<Estimated monthly cost>
Professional Fees - Legal<Estimated monthly cost>
Professional Fees - Other<Estimated monthly cost>
Temporary Labor<Estimated monthly cost>
Branding and Marking<Estimated monthly cost>
Equipment Rental<Estimated monthly cost>
Software Licenses<Estimated monthly cost>
Equipment Repairs and Maintenance<Estimated monthly cost>
Advertising<Estimated monthly cost>
Office Rent<Estimated monthly cost>
Office Utilities<Estimated monthly cost>
Office Repairs and Maintenance<Estimated monthly cost>
Warehouse Rent<Estimated monthly cost>
Warehouse Utilities<Estimated monthly cost>
Warehouse Repairs & Maintenance<Estimated monthly cost>
Security Services<Estimated monthly cost>
Office Supplies<Estimated monthly cost>
Warehouse Supplies<Estimated monthly cost>
General Communications Expense<Estimated monthly cost>
Mobile/Cellular Communications<Estimated monthly cost>
Satellite Communications<Estimated monthly cost>
Internet Communications<Estimated monthly cost>
Printing and Photocopying<Estimated monthly cost>
Courier and Postage<Estimated monthly cost>
DBA Insurance<Estimated monthly cost>
Dues, Subscriptions and References<Estimated monthly cost>
Banking and Cash Handling Fees<Estimated monthly cost>
Taxes, Filing and Registration Fees<Estimated monthly cost>
<Insert more ODC lines here><Estimated monthly cost>
FIELD OFFICE COSTS
Vehicle Rent/Lease<Describe in one or two sentences the lease vs buy option, if applicable.>
Vehicle Fuel<Estimated monthly cost>
Vehicle Repairs and Maintenance<Estimated monthly cost>
Vehicle Insurance<Estimated monthly cost>
Other Vehicle Expenses<Estimated monthly cost>
Professional Fees - Legal<Estimated monthly cost>
Professional Fees - Other<Estimated monthly cost>
Temporary Labor<Estimated monthly cost>
Branding and Marking<Estimated monthly cost>
Equipment Rental<Estimated monthly cost>
Equipment Repairs and Maintenance<Estimated monthly cost>
Advertising<Estimated monthly cost>
Office Rent<Estimated monthly cost>
Office Utilities<Estimated monthly cost>
Office Repairs and Maintenance<Estimated monthly cost>
Warehouse Rent<Estimated monthly cost>
Warehouse Utilities<Estimated monthly cost>
Warehouse Repairs & Maintenance<Estimated monthly cost>
Security Services<Estimated monthly cost>
Office Supplies<Estimated monthly cost>
Warehouse Supplies<Estimated monthly cost>
General Communications Expense<Estimated monthly cost>
Mobile/Cellular Communications<Estimated monthly cost>
Satellite Communications<Estimated monthly cost>
Internet Communications<Estimated monthly cost>
Printing and Photocopying<Estimated monthly cost>
Courier and Postage<Estimated monthly cost>
Dues, Subscriptions and References<Estimated monthly cost>
Banking and Cash Handling Fees<Estimated monthly cost>
Taxes, Filing and Registration Fees<Estimated monthly cost>
<Insert more ODC lines here><Estimated monthly cost>
INDIRECT COSTSDESCRIPTION
Overhead<Describe in one or two sentences the how this cost was estimated>
G&A<Describe in one or two sentences the how this cost was estimated>
<Insert more Indirect Cost lines here><Describe in one or two sentences the how this cost was estimated>
FEEDESCRIPTION
Fee-Profit<Reference Fee Calculation Tab>

Budget Narrative &"Arial,Bold"Mercy Corps &P of &N

Summary

BUDGET SUMMARY

Cost CategoryYear 1Year 2Year 3Year 4Year 5Total All Years
a.- 0- 0- 0- 0- 0- 0
b.- 0- 0- 0- 0- 0- 0
c.ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
d.- 0- 0- 0- 0- 0- 0
e.- 0- 0- 0- 0- 0- 0
f.- 0- 0- 0- 0- 0- 0
g.- 0- 0- 0- 0- 0- 0
h.- 0- 0- 0- 0- 0- 0
i.Total Direct ChargesERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
j.Indirect Charges- 0- 0- 0- 0- 0- 0
k.Fee- 0- 0- 0- 0- 0- 0
l.TOTALSERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

&A

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)

image1.png

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