4. Attachment II_Budget Justification Workbook 16June2021.xlsx

XLSX spreadsheet 116 KB Posted

Attached to
Science, Innovation and Technology Partnership Intermediary Agreement
Opportunity number
PIA-FOA-21-AFRL-0001
Issued by

About this file

Budget Justification Workbook

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

Instructions and Summary Budget Justification Workbook_Cost Share (Instructions) As Of_16June2021

Application/Award Number:Date of Submission:
Organization/Recipient Name :Form submitted by (Name):
Sub-Recipient Name:Phone Number and E-Mail:
(May be award recipient or sub-recipient)
Please read the instructions on each worksheet tab!!!
1. When using this form for award application, negotiation, or budget revision, fill out the blank white cells in workbook tabs a. through j. with total project costs.

2. Colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.

3. Enter detailed support for the project costs identified for each Category line item within each worksheet tab to autopopulate the summary tab.

4. The total budget presented on tabs a. through i. must include both Federal (DOD) and Non-Federal (cost share) portions.

5. All costs incurred by the preparer's sub-recipients, vendors, and Federal Research and Development Centers (FFRDCs), should be entered only in section f. Contractual.

6. Ensure all entered costs are allowable, allocable, and reasonable in accordance with 2 CFR 200, and the applicable cost principles for each entity type: FAR Part 31 for For-Profit entities; and 2 CFR Part 200 Subpart E - Cost Principles for all other non-federal entities and the DoD Research & Development General Terms and Conditions (March 2021).

7. Add rows as needed throughout tabs a. through j. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab.

8. ALL budget period cost categories must be rounded to the nearest dollar.

SUMMARY OF BUDGET CATEGORY COSTS PROPOSED

The values in this summary table are from entries made in subsequent tabs.

Section A - Budget Summary
FederalCost ShareTotal CostsCost Share %Proposed Budget Period Dates
Budget Period 1$0$0$00.00%
Budget Period 2$0$0$00.00%
Budget Period 3$0$0$00.00%
Budget Period 4$0$0$00.00%
Budget Period 5$0$0$00.00%
Total$0$0$00.00%
Section B - Budget Categories
CATEGORYBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Total Costs% of ProjectComments (as needed)
a. Personnel$0$0$0$0$0$00.00%
b. Fringe Benefits$0$0$0$0$0$00.00%
c. Travel$0$0$0$0$0$00.00%
d. Equipment$0$0$0$0$0$00.00%
e. Supplies$0$0$0$0$0$00.00%
f. Contractual
Sub-recipient$0$0$0$0$0$00.00%
Vendor$0$0$0$0$0$00.00%
FFRDC$0$0$0$0$0$00.00%
Total Contractual$0$0$0$0$0$00.00%
g. Construction$0$0$0$0$0$00.00%
h. Other Direct Costs$0$0$0$0$0$00.00%
Total Direct Costs$0$0$0$0$0$00.00%
i. Indirect Charges$0$0$0$0$0$00.00%
Total Costs$0$0$0$0$0$00.00%

Additional Explanation (as needed):

a. Personnel

Budget Justification Workbook_AFRL/RVKE
a. Personnel
INSTRUCTIONS

1. List project costs solely for employees of the entity completing this form. 2. All personnel costs for subrecipients and vendors must be included under f. Contractual. 3. All Participant support costs as defined in 2 CFR 200 must be included under h. Other

4. All personnel should be identified by position title and/or employee name. Enter the amount of time (e.g., hours or % of time) and the base pay rate and the total direct personnel compensation will automatically calculate. Rate basis (e.g., actual salary, labor distribution report, state civil service rates, etc.) must also be identified.

3. If loaded labor rates are utilized, a description of the costs the loaded rate is comprised of must be included in the Additional Explanation section below. The Government must review all components of the loaded labor rate for reasonableness and unallowable costs (e.g. fee or profit).

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

SOW Task #Position TitleBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Project Total HoursProject Total DollarsRate Basis
Time
(Hrs)Pay Rate
($/Hr)Total Budget Period 1Time
(Hrs)Pay Rate
($/Hr)Total Budget Period 2Time
(Hrs)Pay Rate
($/Hr)Total Budget Period 3Time
(Hrs)Pay Rate
($/Hr)Total Budget Period 4Time
(Hrs)Pay Rate
($/Hr)Total Budget Period 5
1Sr. Engineer (EXAMPLE!!!)2000$85.00$170,000200$50.00$10,000200$50.00$10,000200$50.00$10,000200$50.00$10,0002400$190,000Actual Salary
$00$0.00$00$0.00$00$0.00$00$0.00$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
$0$0$0$0$00$0
Total Personnel Costs0$00$00$00$00$00$0

Additional Explanation (as necessary):

b. Fringe

Budget Justification Workbook_AFRL/RVKE
b. Fringe Benefits
INSTRUCTIONS

1. Fill out the table below by position title. If all employees receive the same fringe benefits, you can show "Total Personnel" in the Labor Type column instead of listing out all position titles.

2. The rates and how they are applied should not be averaged to get one fringe cost percentage. Complex calculations should be described/provided in the Additional Explanation section below.

3. The fringe benefit rates should be applied to all positions, regardless of whether those funds will be supported by Federal Share or Recipient Cost Share.

Labor TypeBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Total Project
Personnel CostsRateTotalPersonnel CostsRateTotalPersonnel CostsRateTotalPersonnel CostsRateTotalPersonnel CostsRateTotal
EXAMPLE!!! Sr. Engineer$170,00020%$34,000$10,00020%$2,000$10,00020%$2,000$10,00020%$2,000$10,00020%$2,000$38,000
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
Total:$0$0$0$0$0$0$0$0$0$0$0
A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by the Government for estimating purposes is required at the time of award negotiation if reimbursement for fringe benefits is requested. Please check (X) one of the options below and provide supporting information.
______ A fringe benefit rate has been negotiated with, or approved by, a federal government agency. A copy of the latest rate agreement is/was included with the project application.*

______ There is not a current federally approved rate agreement negotiated and available.**

*Unless the organization has submitted an indirect rate proposal which encompasses the fringe pool of costs, please provide the organization’s benefit package and/or a list of the components/elements that comprise the fringe pool and the cost or percentage of each component/element allocated to the labor costs identified in the Budget Justification.

**When this option is checked, the entity preparing this form shall submit an indirect rate proposal information and which will support the rates being proposed for use in the performance of the proposed project.

Additional Explanation (as necessary):

c. Travel

Budget Justification Workbook_AFRL/RVKE
c. Travel
INSTRUCTIONS

1. Identify Domestic and International Travel as separate items. Examples of Purpose of Travel are site visits, DOD meetings, project mgmt. meetings, etc. Examples of Basis for Estimating Costs are past trips, travel quotes, GSA rates, etc.

2. All listed travel must be necessary for performance of the Statement of Work.

3. Federal travel regulations are contained within the applicable cost principles for all entity types. 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, organizations must follow the regulations prescribed by the General Services Administration.

SOW Task #Purpose of TravelDepart FromDestinationNo. of DaysNo. of TravelersLodging per TravelerFlight per TravelerVehicle per TravelerPer Diem Per TravelerOther Allowable Cost Per TravelerCost per TripBasis for Estimating Costs
Domestic TravelBudget Period 1
1EXAMPLE!!! Visit to AFRL22$250$500$100$160$150$2,320Current GSA rates
$0
$0
$0
$0
International Travel
$0
Budget Period 1 Total$0
Domestic TravelBudget Period 2
$0
$0
$0
$0
International Travel
$0
Budget Period 2 Total$0
Domestic TravelBudget Period 3
$0
$0
$0
$0
International Travel
$0
Budget Period 3 Total$0
Domestic TravelBudget Period 4
$0
$0
$0
$0
International Travel
$0
Budget Period 4 Total$0
Domestic TravelBudget Period 5
$0
$0
$0
$0
International Travel
$0
Budget Period 5 Total$0
PROJECT TOTAL$0

Additional Explanation (as needed):

d. Equipment

Budget Justification Workbook_AFRL/RVKE
d. Equipment
INSTRUCTIONS

1. Equipment is generally defined as an item with an acquisition cost greater than $5,000 and a useful life expectancy of more than one year. Please refer to 2 CFR 200 equipment definitions and treatment.

2. List all equipment below, providing a basis of cost (e.g. vendor quotes, catalog prices, prior invoices, etc.). Briefly justify items as they apply to the Statement of Work. NOTE: During award negotiations, Recipients may be ask to provide a vendor quote for all equipment items over $50,000 in price. If the vendor quote is not an exact price match, provide an explanation in the additional explanation section below. If a vendor quote is not practical, such as for a piece of equipment that is purpose-built, first of its kind, or otherwise not available off the shelf, provide a detailed engineering estimate for how the cost estimate was derived.

SOW Task #Equipment ItemQtyUnit CostTotal CostBasis of CostJustification of need
Budget Period 1
3,4,5EXAMPLE!!! 3D Max Printer2$70,000$140,000Vendor Quote - AttachedReliability testing of XYZ modules
$0
$0
$0
$0
$0
$0
Budget Period 1 Total$0
Budget Period 2
$0
$0
$0
$0
$0
$0
Budget Period 2 Total$0
Budget Period 3
$0
$0
$0
$0
$0
$0
Budget Period 3 Total$0
Budget Period 4
$0
$0
$0
$0
$0
$0
Budget Period 4 Total$0
Budget Period 5
$0
$0
$0
$0
$0
$0
Budget Period 5 Total$0
PROJECT TOTAL$0

Additional Explanation (as needed):

e. Supplies

Budget Justification Workbook_AFRL/RVKE
e. Supplies
INSTRUCTIONS

1. Supplies are generally defined as an item 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 performance. Please refer to 2 CFR 200 for supplies definition and treatment.

2. List all proposed supplies below, providing a basis of costs (e.g. vendor quotes, catalog prices, prior invoices, etc.). Briefly justify the need for the Supplies as they apply to the Statement of Work.

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

NOTE: Supply items must be direct costs to the project at this budget category, and not duplicative of supply costs included in the indirect pool that is the basis of the indirect rate applied for this project.

SOW Task #General Category of SuppliesQtyUnit CostTotal CostBasis of CostJustification of Need
Budget Period 1
4,6EXAMPLE!!! Wireless DAS components10$360.00$3,600Catalog priceFor Alpha prototype - Task 2.4
$0
$0
$0
$0
$0
$0
$0
Budget Period 1 Total$0
Budget Period 2
$0
$0
$0
$0
$0
$0
$0
$0
Budget Period 2 Total$0
Budget Period 3
$0
$0
$0
$0
$0
$0
$0
$0
Budget Period 3 Total$0
Budget Period 4
$0
$0
$0
$0
$0
$0
$0
$0
Budget Period 4 Total$0
Budget Period 5
$0
$0
$0
$0
$0
$0
$0
$0
Budget Period 5 Total$0
PROJECT TOTAL$0

Additional Explanation (as needed):

f. Contractual

Budget Justification Workbook_AFRL/RVKE
f. Contractual
INSTRUCTIONS

1. Provide all costs related to sub-recipients, sub-awardees, vendors, contractors, and FFRDC partners, etc.

2. Sub-recipients (partners, sub-awardees): Subrecipients shall submit a Budget Justification describing all project costs and calculations when their total proposed budget exceeds either (1) $250,000 of the total award costs. These sub-recipient forms may be completed by either the sub-recipients themselves or by the preparer of this form. The budget totals on the sub-recipient's forms must match the sub-recipient entries below.

3. Vendors (including contractors): List all vendors and contractors supplying commercial supplies or services used to support the project. For each Vendor cost with total project costs of $250,000 or more, a Vendor quote must be provided.

4. Federal Funded Research and Development Centers (FFRDCs): FFRDCs must submit a signed Field Work Proposal during award application. The award recipient may allow the FFRDC to provide this information directly to the Government, however project costs. NOTE: Please refer to 2 CFR 200 for sub-recipient and/or vendor definitions and treatment.

SOW Task #Sub-Recipient/Sub-Awardee
Name/OrganizationPurpose and Basis of CostBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Project Total
2,4EXAMPLE!!! XYZ Non-ProfitPartner to Support XYZ training. Cost estimate based on personnel hours.$50,000$50,000$50,000$45,000$35,000$230,000
$0
$0
$0
$0
$0
$0
Sub-total$0$0$0$0$0$0
SOW Task #Vendor/Contractors
Name/OrganizationPurpose and Basis of CostBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Project Total
6EXAMPLE!!! ABC Corp.Vendor for XYZ training marketing. Estimate provided by vendor.$32,000$3,000$25,000$20,000$15,000$95,000
$0
$0
$0
$0
$0
Sub-total$0$0$0$0$0$0
SOW Task #FFRDC
Name/OrganizationPurpose and Basis of CostBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Project Total
$0
$0
Sub-total$0$0$0$0$0$0

Total Contractual $0 $0 $0 $0 $0 $0

Additional Information (as necessary):

g. Construction

Budget Justification Workbook_AFRL/RVKE
g. Construction
INSTRUCTIONS

1. Construction, for the purpose of budgeting, is defined as all types of work done on a particular building, including erecting, altering, or remodeling, and briefly justify its need as it applies to the Statement of Work.

2. Any construction cost, requires priro approval by the Grants and Agreements Officer. 4. Work that is performed by a vendor or subrecipient should be entered under f. Contractual.

Description of construction activities:

SOW Task #General DescriptionCostBasis of CostJustification of need
Budget Period 1
Construction cost is not anticipated in the SOW
Budget Period 1 Total$0
Budget Period 2
Budget Period 2 Total$0
Budget Period 3
Budget Period 3 Total$0
Budget Period 4
Budget Period 4 Total$0
Budget Period 5
Budget Period 5 Total$0
PROJECT TOTAL$0

Additional Explanation (as needed):

h. Other

Budget Justification Workbook_AFRL/RVKE
h. Other Direct Costs
INSTRUCTIONS

1. Other direct costs are direct cost items required for the project which do not fit clearly into other categories. These direct costs must not be included in the indirect costs (for which the indirect rate is being applied for this project). Examples are: Participant Costs, printing costs, etc. which can be directly charged to the project and are not duplicated in indirect costs (overhead costs).

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

SOW Task #General Description and SOPO Task #CostBasis of CostJustification of need
Budget Period 1
5EXAMPLE!!! Participant Cost_Grad student tuition - Task 5. Sub-tasks 1-3$16,000Established UCD costs for 5 StudentsSupport of graduate students working on XYZ Program. Total Gradaute Students_5
Budget Period 1 Total$0
Budget Period 2
Budget Period 2 Total$0
Budget Period 3
Budget Period 3 Total$0
Budget Period 4
Budget Period 4 Total$0
Budget Period 5
Budget Period 5 Total$0
PROJECT TOTAL$0

Additional Explanation (as needed):

i. Indirect

Budget Justification Workbook_AFRL/RVKE
i. Indirect Costs
INSTRUCTIONS

1. Please indicate how the Recipient indirect costs are calculated. If necessary, use the box below to provide additional explanation regarding indirect rate calculations.

2. The rates and how they are applied should not be averaged to get one indirect cost percentage. Complex calculations or rates that do not do not correspond to the below categories should be described/provided in the Additional Explanation section below.

3. The indirect rate should be applied to both the Federal Share and Recipient Cost Share.

Budget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5TotalExplanation of BASE
Provide ONLY Applicable Rates:
Overhead Rate0.00%0.00%0.00%0.00%0.00%
General & Administrative (G&A)0.00%0.00%0.00%0.00%0.00%
FCCM Rate, if applicable0.00%0.00%0.00%0.00%0.00%
OTHER Indirect Rate0.00%0.00%0.00%0.00%0.00%
Indirect Costs (As Applicable):
Overhead Costs$0
G&A Costs$0
FCCM Costs, if applicable$0
OTHER Indirect Costs$0
Total indirect costs requested:$0$0$0$0$0$0
A federally approved indirect rate agreement, or rate proposed (supported and agreed upon by the Government for estimating purposes) is required if reimbursement of indirect costs is requested. Please check (X) one of the options below and provide the requested information if it has not already been provided as requested, or has changed.
______ An indirect rate has been approved or negotiated with a federal government agency. A copy of the latest rate agreement is included with this application, and will be provided electronically to the Contracting Officer for this project.

______ There is not a current, federally approved rate agreement negotiated and available*.

*When this option is checked, the entity preparing this form shall submit an indirect rate proposal information and which will support the rates being proposed for use in performance of the proposed project. Additionally, any non-Federal entity that has never received a negotiated indirect cost rate, except for those non-Federal entities described in Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals, paragraph D.1.b, may elect to charge a de minimis rate of 10% of modified total direct costs (MTDC) which may be used indefinitely, as described in 2 CFR 200.403.

Additional Explanation (as needed):

j. Cost Share

Detailed Budget Justification
j. Cost Share
INSTRUCTIONS

1. A detailed presentation of the cash or cash value of all cost share proposed must be provided. All items below must be identified within the applicable cost category tabs a. through i. In addition to the detailed presentation of the cash or cash value of all cost share proposed provided in the table below, please identify the source organization & amount of each cost share item proposed in the award.

2. Please reference to the FOA Appendix A, Appendix B, and 2 CFR 200 for definitions and information.

3. Funds from other Federal sources MAY NOT be counted as cost share. 4. Cost sharing commitment letters from subrecipients and third parties must be provided with the Recipients proposal or application.

5. NOTE: Vendors may not provide cost share. Any partial donation of goods or services is considered a discount and is not allowable.

Organization/SourceType (Cash or In Kind)Cost Share ItemBudget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5Total Project Cost Share
ABC Company
EXAMPLE!!!CashProject partner ABC Company will provide XYZ for XYZ123 development at the price of $680 per e- learning module.$13,600$13,600
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Totals$0$0$0$0$0$0

Total Project Cost: $0 Cost Share Percent of Award: 0.0%

Additional Explanation (as needed):

SF-424A

Applicant Name:Award Number:
Budget Information - Non Construction Programs
OMB 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.Budget period 1$0$0$0
2.Budget period 2$0$0$0
3.Budget period 3$0$0$0
4.$0
5.Totals$0$0$0$0$0
Section B - Budget Categories
6.Object Class CategoriesGrant Program, Function or ActivityTotal (5)
Budget period 1Budget period 2Budget period 3(4)
a. Personnel$0$0$0$0
b. Fringe Benefits$0$0$0$0
c. Travel$0$0$0$0
d. Equipment$0$0$0$0
e. Supplies$0$0$0$0
f. Contractual$0$0$0$0
g. Construction$0$0$0$0
h. Other$0$0$0$0
i. Total Direct Charges (sum of 6a-6h)$0$0$0$0$0
j. Indirect Charges$0$0$0$0
k. Totals (sum of 6i-6j)$0$0$0$0$0

7. Program Income $0

SF-424A (Rev. 4-92)
Previous Edition UsablePrescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
(a) Grant Program(b) Applicant(c ) State(d) Other Sources(e) Totals
8.Budget period 1$0
9.Budget period 2$0
10.Budget period 3$0
11.$0
12.Total (sum of lines 8 - 11)$0$0$0$0
Section D - Forecasted Cash Needs
Total for 1st Year1st Quarter2nd Quarter3rd Quarter4th quarter
13.Federal$0
14.Non-Federal$0
15.Total (sum of lines 13 and 14)$0$0$0$0$0
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant ProgramFuture Funding Periods (Years)
Budget period 1Budget period 2Budget period 3
16.
17.
18.
19.
20.Total (sum of lines 16-19)$0$0$0$0
Section F - Other Budget Information
21. Direct Charges22. Indirect Charges

23. Remarks

SF-424A (Rev. 4-92)
Previous Edition UsablePrescribed by OMB Circular A-102
Authorized for Local Reproduction

SF-424A Cost Categories

Applicant Name:0Award Number:0
Summary Budget Information
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.Budget Period 1$0$0$0
2.Budget Period 2$0$0$0
3.Budget Period 3$0$0$0
4.Budget Period 4$0$0$0
5.Budget Period 5$0$0$0
6.Totals$0$0$0
Section B - Budget Categories
6.Object Class CategoriesGrant Program, Function or ActivityTotal (5)
Budget Period 1Budget Period 2Budget Period 3Budget Period 4Budget Period 5
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$0$0$0$0$0$0
i. Total Direct Charges (sum of 6a-6h)$0$0$0$0$0$0
j. Indirect Charges$0$0$0$0$0$0
k. Totals (sum of 6i-6j)$0$0$0$0$0$0

7. Program Income $0 image1.emf image2.emf

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