Attachment II_Budget Justification Workbook_17june20.xlsx
XLSX spreadsheet 67 KB Posted
- Attached to
- Future Scholars for Science, Technology, Engineering, and Mathematics (STEM) Workforce Development Programs
- Opportunity number
- FOA20AFRLRVKE0001
About this file
Budget Justification Workbook
View the file
Other files
Show all 14
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 (5 Period) | Instructions and Summary | Version: V.1 | |
| Year: 2020 | |||
| Solicitations, Announcement Number: | Date of Submission: | ||
| Contractor or Recipient: | Form submitted by: |
| Please read the instructions on each worksheet tab before starting. If you have any questions, please ask the Point of Contact specified in the Solicitation or Announcement. |
| 1. If using this form for contract proposal, award application, negotiation, or budget revision, fill out workbook tabs a. through i., as applicable, with total project costs. |
2. Enter detailed information for the project costs identified for each Cost Element Category within each worksheet tab to auto populate the summary tab.
3. Ensure all entered costs are allowable, allocable, and reasonable are in accordance with the applicable administrative requirements prescribed in 2 CFR 200 Uniform Administration Requirement, Cost Principles, and Audit Requirements for Federal Awards; FAR Part 31 Contract Cost Principles and Procedures; and the Terms and Conditions specified in the Solicitation or Announcement.
4. Add rows as needed throughout tabs a. through i. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab. 5. The total budget presented on tabs a. through i. must include both Federal (DoD) and Non-Federal (cost share, if applicable). 6. ALL budget period cost categories must be rounded to the nearest dollar.
SUMMARY OF BUDGET CATEGORY COSTS PROPOSED
The values in this summary table represent entries made in subsequent workbook tabs.
| Section A - Budget Summary | ||||||||
| Federal | Total Costs | Proposed Budget Period Dates | ||||||
| Budget Period 1 | $0 | $0 | ||||||
| Budget Period 2 | $0 | $0 | ||||||
| Budget Period 3 | $0 | $0 | ||||||
| Budget Period 4 | $0 | $0 | ||||||
| Budget Period 5 | $0 | $0 | ||||||
| Total | $0 | $0 | ||||||
| Section B - Budget Categories | ||||||||
| CATEGORY | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Total Costs | % of Project | Comments (as needed) |
| a. Personnel | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| b. Fringe Benefits | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| c. Travel | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| d. Equipment | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| e. Materials/Supplies | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| f. Contractual | ||||||||
| Sub-contractor/ Sub-recipient | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| Consultant/Vendor | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| FFRDC | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| Total Contractual | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| g. Construction | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| h. Other Direct Costs | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| Sub-Total Direct Costs | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| i. Indirect Charges | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% | |
| Total Cost | $0 | $0 | $0 | $0 | $0 | $0 | 0.00% |
Additional Explanation (as needed):
a. Personnel
| Budget Justification Workbook |
| a. Personnel |
| INSTRUCTIONS |
1. List project costs solely for personnel or labor cost of the entity completing this form. All personnel or labor costs for sub-contractors or subrecipientsmust be included under f. Contractual.
2. All personnel should be identified by position title and not employee name. Enter the amount of time (e.g., hours or % of time) and the base pay rate. Rate basis (e.g., actual salary, labor distribution report, 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 may review all proposed 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.
| Task # | Position Title | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Project Total Hours | Project Total Dollars | Rate Basis | ||||||
| Time | |||||||||||||||
| (Hrs) | Pay Rate | ||||||||||||||
| ($/Hr) | Total Budget Period 1 | Time | |||||||||||||
| (Hrs) | Pay Rate | ||||||||||||||
| ($/Hr) | Total Budget Period 2 | Time | |||||||||||||
| (Hrs) | Pay Rate | ||||||||||||||
| ($/Hr) | Total Budget Period 3 | Time | |||||||||||||
| (Hrs) | Pay Rate | ||||||||||||||
| ($/Hr) | Total Budget Period 4 | Time | |||||||||||||
| (Hrs) | Pay Rate | ||||||||||||||
| ($/Hr) | Total Budget Period 5 | ||||||||||||||
| $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 | $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 | $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 | $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 | $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 | $0 | $0 | 0 | $0 | |||||||||
| $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||
| $0 | $0 | $0 | $0 | $0 | 0 | $0 | |||||||||
| Total Personnel Costs | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 |
Additional Explanation (as needed):
b. Fringe
| Budget Justification Workbook |
| b. Fringe Benefits |
| INSTRUCTIONS |
1. Fill out the table below by position titles. The rates and how they are applied should not be averaged to get one fringe cost percentage.
2. Fringe benefit rates are usually applied to all positions. If fringe rates are not applied to all positions please provide information.
| Labor Type | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Total Project | ||||||||||
| Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | Personnel Costs | Rate | Total | ||
| $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 |
| Please check (X) one of the options below and provide the requested information if not previously submitted. |
| ______ A fringe benefit rate has been negotiated with, or approved by, a federal government agency. |
______ 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.
** When a fringe benefit rate has been negotiated with, or approved by, a federal government agency. Provide a copy of the latest rate agreement.
Additional Explanation (as necessary): Please use this box (or an attachment) to list the elements that comprise your fringe benefits and how they are applied to your base (e.g. Personnel) to arrive at your fringe benefit rate. Complex calculations should be described/provided in this section.
c. Travel
| Budget Justification Workbook |
| c. Travel |
| INSTRUCTIONS |
1. Identify Foreign and Domestic Travel as separate items and provide basis for estimating cost. Examples of Basis for Estimating Costs are GSA rates, etc.
2. Federal travel regulations are contained within the applicable cost principles for all entity types.
| Task # | Purpose of Travel | Depart From | Destination | No. of Days | No. of Travelers | Lodging per Traveler | Flight per Traveler | Vehicle per Traveler | Per Diem Per Traveler | Cost per Trip | Basis for Estimating Costs |
| Domestic Travel | Budget Period 1 | ||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 1 Total | $0 | ||||||||||
| Domestic Travel | Budget Period 2 | ||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 2 Total | $0 | ||||||||||
| Domestic Travel | Budget Period 3 | ||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 3 Total | $0 | ||||||||||
| Domestic Travel | Budget Period 4 | ||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| $0 | |||||||||||
| International Travel | |||||||||||
| $0 | |||||||||||
| Budget Period 4 Total | $0 | ||||||||||
| Domestic Travel | Budget 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 |
| d. Equipment |
| INSTRUCTIONS |
1. 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 proposed effort. If it is existing equipment, provide logical support for the estimated value shown.
2. 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.
3. Please refer to the applicable 2 CFR 200, or FAR Part 31; and specified terms and conditions specified in the Solicitation or Announcement for specific Equipment definitions, treatment, or inventory. 4. Please refer to the solicitation or announcement for additional equipment or property information such as, but not limited to Gorvernment Furnished Equipment or Property.
| Task # | Equipment Item | Qty | Unit Cost | Total Cost | Basis of Cost | Justification of need |
| Budget Period 1 | ||||||
| $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. Materials_Supplies
| Budget Justification Workbook |
| e. Material/Supplies |
| INSTRUCTIONS |
1. List all proposed material/supplies below, providing a basis of costs (e.g. vendor quotes, catalog prices, prior invoices, etc.). 2. Briefly justify the need for the materials/supplies as they apply to the proposed effort. Note that material/supply items must be direct costs to the proposed effort at this budget category, and not duplicative of material/supply costs included in the indirect pool that is the basis of the indirect rate applied for the proposed effort.
3. Please refer to the applicable 2 CFR 200, or FAR Part 31; and specified terms and conditions specified in the Solicitation or Announcement for specific Material definitions, treatment, or inventory.
| SOPO Task # | General Category of Supplies | Qty | Unit Cost | Total Cost | Basis of Cost | Justification of need |
| Budget Period 1 | ||||||
| $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
| Detailed Budget Justification |
| f. Contractual |
| INSTRUCTIONS - PLEASE READ!!! |
1. Provide all costs related to contractual contracts or agreements with sub-contractors, sub-recipients, consultants or vendors and Federal Funded Research and Development Centers (FFRDS) organizations.
2. Subject to the Solicitation or Announcement type, sub-contractors, sub-recipients (sub-awardees), vendors, consultants or FFRDs may have to submit a Budget Justification describing all project costs and calculations. 3. Please refer to the applicable 2 CFR 200 or FAR Part 31 for applicable sub-contractor or sub-riciepients requirements. 4. Please reference to the Solicitation or Announcements Terms and Condition for additional requirements concerning Flowdown Requirements for sub-contractors, sub-recipients, etc.
| Task # | Sub-Contracts/Sub-Recipients/Sub-Awards | ||||||||
| Name/Organization | Purpose and Basis of Cost | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Project Total | ||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| Sub-total | $0 | $0 | $0 | $0 | $0 | $0 |
| Task # | Consultants or Vendors | ||||||||
| Name/Organization | Purpose and Basis of Cost | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Project Total | ||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| $0 | |||||||||
| Sub-total | $0 | $0 | $0 | $0 | $0 | $0 |
| Task # | FFRDC | ||||||||
| Name/Organization | Purpose and Basis of Cost | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Project Total | ||
| $0 | |||||||||
| $0 | |||||||||
| Sub-total | $0 | $0 | $0 | $0 | $0 | $0 |
Total Contractual $0 $0 $0 $0 $0 $0
Additional Explanation (as needed):
g. Construction
| Budget Justification Workbook |
| g. Construction (If Applicable) |
| INSTRUCTIONS |
1. List all proposed construction below, providing a basis of cost such as engineering estimates, prior construction, etc., and briefly justify its need as it applies to the proposed effort. 2. Please refer to the applicable 2 CFR 200 or FAR Part 31 for additional information.
Overall description of construction activities:
| Task # | General Description | Cost | Basis of Cost | Justification of need |
| Budget Period 1 |
| 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 |
| h. Other Direct Costs |
| INSTRUCTIONS |
1. Other direct costs are direct cost items required for the proposed effort which do not fit clearly into other categories. These direct costs must not be included in the indirect costs (for which the indirect rate may be applied too). Examples are: tuition, stipends, subsistence, other participant/trainee support cost, printing costs, etc. which may be directly charged to the proposed effort 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.
| Task # | General Description and SOPO Task # | Cost | Basis of Cost | Justification of need |
| Budget Period 1 |
| 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 |
| i. Indirect Costs |
| INSTRUCTIONS |
1. Fill out the table below to indicate how the indirect costs are calculated. Use the box below to provide additional explanation regarding the indirect rate calculation.
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 (if applicable).
| Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period 4 | Budget Period 5 | Total | Explanation of BASE | |
| Provide ONLY Applicable Rates: | |||||||
| Overhead Rate | 0.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 applicable | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| OTHER Indirect Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | ||
| Indirect Costs (As Applicable): | |||||||
| Labor Facility | $0 | ||||||
| Overhead Cost | $0 | ||||||
| Material Overhead Cost | $0 | ||||||
| G&A Costs or F&A Cost | $0 | ||||||
| OTHER Indirect Rate | $0 | ||||||
| Cost of Money (As Applicable) | |||||||
| Facility COM | $0 | ||||||
| Overhead COM | $0 | ||||||
| Material COM | $0 | ||||||
| G&A or F&A COM | |||||||
| OTHER FCCM Costs, if applicable | $0 | ||||||
| $0 | |||||||
| Total indirect costs requested: | $0 | $0 | $0 | $0 | $0 | $0 |
| A federally approved indirect rate agreement, or rate proposed may be 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 agreement information, which will support the rates being proposed for use in performance of the proposed effort. ** For Federal Assistance Agreements (Grants or Cooperative Agreements), an entity that has never received a negotiated indirect cost rate, may elect to charge a de minimis rate of 10% of modified total direct costs (MTDC) which may be used indefinitely (See 2 CFR 200.414 for detailed information).
You must provide an explanation (below or in a separate attachment) and show how your indirect cost rate was applied to this budget in order to come up with the indirect costs shown.
Additional Explanation (as needed): *IMPORTANT: Please use this box (or an attachment) to further explain how your total indirect costs were calculated. If the total indirect costs are a cumulative amount of more than one calculation or rate application, the explanation and calculations should identify all rates used, along with the base they were applied to (and how the base was derived), and a total for each (along with grand total).
Sheet1
File details come from the government source that posted it.