Suggested Budget Detail.xlsx

XLSX spreadsheet 50 KB Posted

Attached to
Outdoor Recreation Legacy Partnership Program (ORLP) Recurring Notice 5 Year
Opportunity number
P25AS00189
Issued by

About this file

This is a budget detail template spreadsheet from the Department of the Interior National Park Service for the Outdoor Recreation Legacy Partnership (ORLP) Program. The template provides detailed instructions and formatting for applicants to submit their proposed project budgets, requiring breakdown of costs across multiple categories including personnel, fringe benefits, travel, equipment, supplies, contractual services, construction, other direct costs, and indirect costs.

The template requires both federal and non-federal (cost match) portions to be detailed, with a mandatory 1:1 (50%) minimum non-federal match requirement. It includes specific formatting rules, such as only filling in light blue cells, and requires detailed justification for all costs in accordance with 2 CFR 200. The spreadsheet automatically calculates totals and populates an SF-424A Budget Information form. The template emphasizes that all costs must be allowable, allocable, and reasonable, with special instructions for handling subrecipient costs exceeding 35% of total project costs and vendor selection requirements following procurement standards in 2 CFR 200.317-200.326.

Suggested Budget Detail.xlsx

View the file

Other files

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

Budget Justification

Detailed Budget JustificationU.S. Department of the Interior - National Park Service
Award Number:(Not Available at Application)Award Recipient:
General Instructions
1. Only fill in light blue cells, white cells contain instructions, headers, or summary calculations and should not be modified.

2. The Summary section at the end will auto-fill when each budget subsection is completed.

3. Budget categories must include both Federal and Non-Federal (cost match) portions. All costs must be directly relevant to the project objectives.

4. All costs incurred by the preparer's sub-recipients and vendors should be entered only in section f. Contractual.

5. All costs must be allowable, allocable, and reasonable in accordance with the administrative requirements and applicable cost principles prescribed in 2 CFR 200.

6. Rows can be added as needed throughout sections a. through j. If rows are added, formulas/calculations may need to be adjusted.

Cost Match Instructions
1. The budget must include at least the minimum Federal to non-Federal required match, if applicable.

2. Cost Match can be either Cash or In-kind. Cash Cost Match - encompasses all contributions to the project incurred and paid for during the project. This includes Cost Match payments for personnel, supplies, equipment, activities and items necessary for the project. In-kind Cost Match - encompasses all contributions to the project that do not involve a payment or reimbursement and represent donated items or services that are necessary to the performance of the project. This includes volunteer personnel hours, donated existing equipment, donated existing supplies, etc. The market value and calculations for all In-kind cost match items must be justified and explained.

3. Funds from other Federal sources MAY NOT be counted as cost match. Non-Federal sources include any source not originally derived from Federal funds.

4. Fee or profit, including foregone fee or profit, are not allowable as project costs (including cost match). The project may only incur those costs that are allowable and allocable to the project (including cost match) as determined in accordance with the administrative requirements and cost principles in 2 CFR 200.

a. Personnel
1. Personnel are staff employed by the lead applicant organization. Personnel costs for subrecipients and vendors must be included under f. Contractual.

2. Identify all personnel by position title. Enter the amount of time (i.e., hours or % of time) and the base pay rate and the total will automatically calculate. Also include the basis of rate (e.g., actual salary, labor distribution report, state civil service rates, etc.). Personnel costs may only include time spent working directly on the project.

3. If a position and hours are attributed to multiple employees (e.g. Technician working 2500 hours) the number of employees for that position title must be identified.

Position TitleTime (Hrs or %)Rate (Hr or Salary)Total CostFederal ShareCost MatchRate Basis
EXAMPLE!!! Sr. Engineer400$46.00$18,400$14,000$4,400Actual Salary
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
Total0$0$0$0
b. Fringe Benefits
1. Fill out the table below by position title. If all employees receive the same rate, you may list Total Personnel in the Position column instead of listing out all position titles. If more than one rate is used, list each rate separately. Complex calculations should be provided in the Comments section.

2. Fringe rates may not exceed what is currently provided by the organization. If a federally approved Fringe rate exists, provide the rate agreement with the application.

Position TitlePersonnelRateTotal CostFederal ShareCost MatchComments (as needed)
EXAMPLE!!! Sr. Engineer$18,40020%$3,680$1,680$2,000
$0$0
$0$0
$0$0
$0$0
$0$0
Total:$0$0$0$0
c. Travel
1. All travel must be necessary for performance of the project objectives.

2. Travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organizations written travel policy. In absence of a written travel policy, organization's must follow the regulations prescribed by the General Services Administration (GSA): www.gsa.gov.

FromTo# of Days# of TravelersLodging per TravelerFlight per TravelerVehicle per TravelerPer Diem per TravelerCost per TripFederal ShareCost MatchBasis for Estimate
DenverWashington, D.C.22$250$500$100$160$2,020$1,520$500GSA rates
$0$0
$0$0
$0$0
$0$0
$0$0
Total$0$0$0
d. Equipment
1. Equipment is generally defined as one item with an acquisition cost greater than $5,000 and a useful life of more than one year. Refer to the supplies section for items of lesser value and useful life.

2. List all equipment noting its purpose in the project and the basis of cost (e.g. vendor quotes, catalog prices, prior invoices, etc.). If it is existing equipment, provide a justification for its estimated value.

3. Note that equipment items with a residual value of $5,000 or more at the end of the award will be subject to the equipment disposition regulations in 2 CFR 200.313.

Equipment ItemQuantityUnit CostTotal CostFederal ShareCost MatchBasis of CostPurpose
EXAMPLE!!! Commercial Printer1$12,000$12,000$8,000$4,000Vendor QuotePrinting of photographs and brocures
$0$0
$0$0
$0$0
$0$0
$0$0
Total$0$0$0
e. Supplies
1. Supplies are generally defined as items with an acquisition cost of $5,000 or less and a useful life expectancy of less than one year. Supplies are generally consumed during the project.

2. List all supplies noting their purpose in the project and the basis of cost (e.g. vendor quotes, catalog prices, prior invoices, etc.). Supply items must be direct costs to the project and not duplicative of supply costs covered in the indirect rate.

3. Multiple supply items valued at $5,000 or less used to assemble an equipment item with a value greater than $5,000 and useful life of more than one year should be included in the equipment section.

Supply ItemQuantityUnit CostTotal CostFederal ShareCost MatchBasis of CostPurpose
EXAMPLE!!! Photo Laminate800$2.00$3,600$3,600$0Catalog priceLamination of the printed photographs
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
$0$0
Total$0$0$0
f. Contractual
1. List all third party costs as either sub-recipients or contractors. A sub-recipient (partner, sub-awardee) is a legal entity to which a subaward is made, who has performance measured against whether the objectives of the grant project are met, is responsible for project-related decision-making, must adhere to the applicable grant program compliance requirements, and uses the Federal funds to carry out a program of the organization. A contractor (vendor): is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to many different purchasers, operates in a competitive environment, provides goods or services that are ancillary to the operation of the grant project, and is not subject to compliance requirements of the Federal program. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status.

2. For each sub-recipient budget cost that is 35% or more of the total project costs, a separate budget justification form must be submitted with the application. The sub-recipient budget justification may be completed by the lead applicant or the sub-recipient.

3. List all vendors supplying commercial supplies or services used to support the project. For each Vendor budget cost that is 35% or more of the total project costs, a vendor price quote must be submitted with the application. All vendor work must be competitively selected in accordance with the procurement standards in 2 CFR 200.317 - 200.326.

Subrecipient NamePurposeTotal CostFederal ShareCost MatchBasis of Cost
EXAMPLE!!! XYZ Corp.Partner to develop training curriculum for teachers$25,000$10,000$15,000Personnel and supplies costs
$0$0
$0$0
$0$0
$0$0
$0$0
Subtotal$0$0$0
Vendor NamePurposeTotal CostFederal ShareCost MatchBasis of Cost
EXAMPLE!!! ABC Corp.Vendor to perform photograph scanning$8,000$0$8,000Cost per 800 photos
$0$0
$0$0
$0$0
$0$0
$0$0
Subtotal$0$0$0
Total$0$0$0
g. Construction
1. Construction is generally defined as construction, alteration, or repair (including dredging, excavating, and painting) of buildings, structures, or other real property.

2. List all proposed construction below, providing a basis of cost such as engineering estimates, prior construction, etc., and purpose as it applies to the Project Objectives.

General DescriptionPurposeTotal CostFederal ShareCost MatchBasis of Cost
EXAMPLE!!! Construct Parking LotTo build a parking structure for the museum$22,000$12,000$10,000Engineering estimate
$0
$0
$0
$0
$0
Total$0$0$0
h. Other Direct Costs
1. Other direct costs are direct cost items required for the project which do not fit clearly into other categories. Indirect Costs should not be included in this section.

2. Basis of cost are items such as vendor quotes, prior purchases of similar or like items, published price list, established organizational rates, etc.

Cost ItemPurposeTotal CostFederal ShareCost MatchBasis of Cost
EXAMPLE!!! 4 Grad student tuitionSupport of graduate students working on project$16,000$12,000$4,000Established University tuition rate
$0
$0
$0
$0
$0
Total$0$0$0
i. Indirect Costs
1. Indirect costs are costs an organization incurs for common or joint objectives that cannot be specifically identified with one organizational cost objective or project.

2. Applicants may apply established indirect rates if they have been approved or negotiated with a Federal government agency, and a copy is included with this application.

3. If the applicant does not have a current Federally approved rate agreement they may elect to apply a rate limited to 10% of total direct costs.

Rate TypeFederal Rate?Base DescriptionBase TotalRateTotal CostFed ShareCost Match
EXAMPLE!!! Indirect RateYesTotal Direct costs excluding equipment, tuition, and subgrants greater than $25,000$113,02042.80%$48,373$28,373$20,000
EXAMPLE!!! Overhead RateNoTotal Direct Costs$141,02015.00%$21,153$5,000$16,153
$0$0
$0$0
$0$0
$0$0
Total$0$0$0

Summary Figures in this summary table are calculated from entries made in subsequent categories, only blank white cells require data entry.

CategoryTotal CostFederal ShareCost MatchCost Match %Comments (as needed)
a. Personnel$0$0$0ERROR:#DIV/0!
b. Fringe Benefits$0$0$0ERROR:#DIV/0!
c. Travel$0$0$0ERROR:#DIV/0!
d. Equipment$0$0$0ERROR:#DIV/0!
e. Supplies$0$0$0ERROR:#DIV/0!
f. Contractual$0$0$0ERROR:#DIV/0!
g. Construction$0$0$0ERROR:#DIV/0!
h. Other Direct Costs$0$0$0ERROR:#DIV/0!
i. Indirect Charges$0$0$0ERROR:#DIV/0!
Total Costs$0$0$0ERROR:#DIV/0!

SF424A

SF424A Budget Information
The below SF424A Budget is autopopulated from entries made on the Budget Justification Tab. No data entry is required here.
Award Number:(Not Available at Application)Award Recipient:0OMB Approval No. 0348-0044
Section A - Budget Summary
Grant Program Function or ActivityCatalog of Federal Domestic Assistance NumberEstimated Unobligated FundsNew or Revised Budget
FederalNon-FederalFederalNon-FederalTotal
(a)(b)(c )(d)(e)(f)(g)
1.$0$0$0
2.
3.
4.
5.Totals$0$0$0
Section B - Budget Categories
6.Object Class CategoriesGrant Program, Function or ActivityTotal (5)
FederalNon-Federal
a. Personnel$0$0$0
b. Fringe Benefits$0$0$0
c. Travel$0$0$0
d. Equipment$0$0$0
e. Supplies$0$0$0
f. Contractual$0$0$0
g. Construction$0$0$0
h. Other$0$0$0
i. Total Direct Charges (sum of 6a-6h)$0$0$0
j. Indirect Charges$0$0$0
k. Totals (sum of 6i-6j)$0$0$0

7. Program Income $0 $0 $0

SF-424A (Rev. 4-92)
Previous Edition UsableAuthorized for Local ReproductionPrescribed by OMB Circular A-102

&"Arial Narrow,Regular"&8Page &P of &N

&"Arial Narrow,Regular"&8Page &P of &N

Federal Use Only

This tab is for federal use only, containing list information. DO NOT manipulate any information on this tab.
SF424, 9. Type of Applicant List:
A. State
B. Municipal
C. County
D. Township
E. Interstate
F. Intermunicipal
G. Special District
H. Independent School District
I. State Controlled Institution of Higher Education
J. Private University
K. Indian Tribe
L. Individual
M. Profit Organization
N. Other (specify below)
O. Not for Profit Organization
(leave blank)
Instructions and Summary, 1., Project Type List:
A. Capital Project
B. Documentation
C. Oral History
D. Preservation
E. Interpretation & Education
F. Planning
G. Real Property Acquisition
Instructions and Summary, 2., Consent List:
Yes
No
N/A

Sheet1

Yes
No

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