030ADV24R0029 - Budget Plan Workbook.xlsx

XLSX spreadsheet 83 KB Posted

Attached to
Teaching with Primary Sources - Regional Awards Federal grant opportunity
Opportunity number
030ADV24R0029
Issued by
Library of Congress

About this file

This document is a Budget Plan Workbook for a federal grant opportunity. The Workbook provides detailed instructions and templates for completing the budget plan for a grant application, including sections for personnel, travel, equipment, supplies, contractual costs, other direct costs, subawards, and TPS consortium costs. It also includes instructions for calculating indirect costs, aligning the budget to the proposal narrative, and completing federal award and single audit requirement information.

The key details of the related federal grant opportunity are that it is the Teaching with Primary Sources (TPS) Regional Awards program, managed by the Library of Congress. The purpose is to identify organizations to serve as Regional Partners and manage TPS subaward programs in designated geographic regions. Eligible applicant types include government, nonprofit, and for-profit organizations. The notice provides details on the program background, goals, Regional Partner responsibilities, and the regions available for coverage. Proposals must be submitted electronically to the Library of Congress.

030ADV24R0029 - Budget Plan Workbook

View the file

Other files for this federal grant opportunity

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

Text version

Summary

BUDGET PLAN WORKBOOK

The “Budget Plan Workbook” must demonstrate alignment with the corresponding “Proposal Narrative” and "Budget Plan Narrative." Show a clear alignment to the proposed budget and explain how the budget for the supplemental project supports the achievement of the project’s identified goals (connect to the “Budget Plan Narrative” line items).

Please also complete the "FEDERAL AWARDS" (if applicable) and "SINGLE AUDIT REQUIREMENT" tabs of this Workbook.

PROJECT TITLE: [INSERT PROJECT TITLE HERE]
BUDGET SUMMARY PAGE
BUDGET CATEGORIESINDIRECT COSTSDIRECT COSTSTOTAL AMOUNT
1. ADMINISTRATIVE
a. Personnel Salaries, Wages, & Fringe Benefits$ - 0$ - 0
b. Travel$ - 0$ - 0
c. Equipment$ - 0$ - 0
d. Supplies$ - 0$ - 0
e. Contractual$ - 0$ - 0
f. Other Direct Costs$ - 0$ - 0
2. SUBAWARDS
a. Subawards$ - 0$ - 0
3. TPS CONSORTIUM
a. TPS Consortium$ - 0$ - 0
Indirect Cost Rate: [ENTER HERE]Subtotals$ - 0$ - 0$ - 0
Grand Total:$ - 0
INSTRUCTIONS FOR COMPLETING THE BUDGET PLAN WORKBOOK
1. Direct Costs: The Direct Costs column of the Summary tab will auto-populate based on information entered in the eight (8) successive budget category tabs of this Workbook. All Direct Costs tabs are color-coded to match the three overarching budget categories: 1) Administrative Costs (Green); 2) Subawards (Yellow); and 3) TPS Consortium Costs (Purple). Please read all instructions on each tab carefully before completing them to ensure costs are allocated to the correct category within the Workbook.

2. Indirect Costs: The Indirect Costs column must be completed manually as applicable on the Summary tab, with the exception of Cell G20 (Subtotal of Indirect Costs). Enter the Indirect Cost rate used in Cell B-D20.

3. Review: After completing all eleven (11) “Budget Plan Workbook” tabs, we strongly recommend that the applicant review the totals from each tab to ensure that the amounts match what is listed in the Summary tab Direct Costs columns. Where there are discrepancies, the applicant must correct the errors prior to submitting the application. Please be sure to thoroughly review the “Budget Plan Narrative” for accuracy prior to submitting the application.

4. Note: Amounts of funding should be consistent between the Proposal and Budget Plan Narratives. They should also be clearly aligned with the project activities and objectives as outlined in the Proposal Narrative.

Indirect Costs:

As defined in 2 CFR 200 Appendix IV, Indirect Costs are those that have been incurred for common or joint objectives and cannot be readily identified with a particular final cost objective. Indirect costs are applied equitably across all of the business activities of the organization, according to benefits each gains from the indirect cost. If using Indirect Cost rates, they may not exceed 15%.

Attach a copy of your organization’s policy for determining the percentage to the proposal. Provide additional details as applicable in the Budget Plan Narrative.

NOTE: All budget costs must be allowable – i.e., they must be necessary and reasonable, allocable to the program, and adequately documented (2 CFR 200.403). Please review the Notice of Funding Opportunity for this award to ensure all budgeted expenses are allowable.

Salaries, Wages and Benefits

INSTRUCTIONS FOR COMPLETING THE PERSONNEL SALARIES, WAGES, AND FRINGE BENEFITS TAB
1. In the Position Title field, enter the name (if known) and title of each labor category that will be compensated under this project.

Note 1: DO NOT include fees and expenses for consultants in this section. All such costs must be included in the Contractual tab.

Note 2: DO NOT include honoraria in this section. All such costs must be included under the Other Direct Costs tab.

2. In the Purpose of Position field, describe in brief how each labor category aligns with the project’s narrative and supports the project’s goals, and provide information such as: the duties the person proposed will perform; and, if provided, the number of hours worked per week, month, or for the duration of the project. Provide additional details as applicable in the Budget Plan Narrative.

3. In the Aspect of Project field, select which aspect of the project the labor category proposed will be responsible for from the dropdown menu in the cell.

4. In the Price/Hour field, include the price per hour for each labor category proposed. If using percentage of salary, include the base salary amount in this section.

5. In the Number of Hours field, include the number of hours proposed for the applicable labor category. If using percentage of salary, leave this field blank.

6. In the % of Time field, include the percentage of time that will be spent on the project. If using Price/Hour, leave this field blank.

7. In the Salary/Wages Total field, provide the subtotal of salary/wages for the applicable labor category, NOT including fringe benefits.

8. In the Fringe Benefits Total field, provide the amount for fringe benefits and attach a copy of your organization’s policy to the proposal as applicable. Provide the percentage for the fringe benefits rate in the Budget Plan Narrative.

Note 3: The worksheet will not calculate fringe and salaries based on the percentage of time the personnel will work on project activities. The applicant must manually calculate and enter an amount representing the total amount of funds required for each position(s).

2. PERSONNEL SALARIES, WAGES, & FRINGE BENEFITS
Personnel
Position TitlePurpose of PositionAspect of Project
(Administrative, Subawards, Other)Price/HourNumber of Hours% of
TimeSalary/Wages TotalFringe Benefits TotalTotal Amount
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Subtotals$ - 0$ - 0$ - 0
Salaries, Wages, and Fringe Benefits Subtotal$ - 0

Travel

INSTRUCTIONS FOR COMPLETING THE TRAVEL TAB
1. In the Travel Activity field, include the nature of the travel proposed (e.g. workshop, conference, research, etc.). Each trip must be listed on a separate line. As an example, if proposing two trips to Washington, DC, one for a conference and the other for a workshop, include the information on two separate lines.

Note 1: DO NOT include fees and expenses for consultants in this tab. All such costs must be included in the Contractual tab.

Note 2: DO NOT include fees and expenses for sub-awardee travel in this tab. All such costs must be included in the Subawards or TPS Consortium tabs, as applicable.

2. In the Purpose of Travel Activity field, describe in brief how each travel activity supports the project’s goals. Provide additional details in the Budget Plan Narrative as applicable. Additional details may include: the point of origin for the travel; the destination; and/or the names and dates for the conferences or workshops (if known).

3. In the Number of Travelers field, provide the number of travelers.

4. In the Airfare field, provide the price for the airfare as applicable.

5. In the Hotel field, provide the price for accommodations as applicable.

6. In the Per Diem field, provide the price for per diem as applicable. Use the GSA Travel’s Per Diem Look-Up Tool for per diem rates within the continental US: https://www.gsa.gov/travel

7. In the Local Travel field, provide the price for local transportation as applicable. E.g., mileage for use of privately owned vehicles, taxis, rideshare, public transportation, and rental cars.

8. In the Conference Fees field, provide the total price for all conference or workshop-related fees as applicable.

9. In the Other Fees field, provide the any other fees or travel costs not mentioned above.

Note 3: Entertainment costs are not allowed.

3. TRAVEL
Travel ActivityPurpose of Travel ActivityNumber of Traveler(s)AirfareHotelPer DiemLocal TravelConference FeesOther FeesTotal Amount
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Travel Subtotal$ - 0

Equipment

INSTRUCTIONS FOR COMPLETING THE EQUIPMENT TAB
Equipment is defined as tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $10,000 as described in 2 CFR 200.313.
1. In the Equipment Type field, include each type of equipment that is priced at more than $10,000 each (individual items that are less than $5,000 each must be included in the Supplies tab). Each piece of equipment must be listed on a separate line.

2. In the Purpose of Equipment field, describe in brief how each piece of equipment supports the project’s goals. Provide additional details as applicable in the Budget Plan Narrative.

3. In the Quantity field, provide the number of units of each equipment type that will be purchased.

4. In the Unit Price field, provide the unit price for each piece of equipment.

4. EQUIPMENT
Equipment TypePurpose of EquipmentQuantityUnit PriceTotal Amount
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Equipment Subtotal$ - 0

Supplies

INSTRUCTIONS FOR COMPLETING THE SUPPLIES TAB
In 2 CFR 200.1, Supplies is defined as all tangible personal property other than those described in the definition of equipment in this section. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the non-Federal entity for financial statement purposes or $10,000, regardless of the length of its useful life.
1. In the Supply Type field, include each type of supply that is priced less than $10,000 each (individual items that are more than $5,000 each must be included in the Equipment tab). Each supply type must be listed on a separate line.

2. In the Purpose of Supply field, describe in brief how each type of supply supports the project’s goals. Provide additional details as applicable in the Budget Plan Narrative.

3. In the Quantity field, provide the number of units of the supply that will be purchased.

4. In the Unit Price field, provide the unit price for each type of supply.

Note 1: Entertainment costs are not allowed.

5. SUPPLIES
Supply TypePurpose of SupplyQuantityUnit PriceTotal Amount
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Supply Subtotal$ 0.00

Contractual

INSTRUCTIONS FOR COMPLETING THE CONTRACTUAL TAB
1. In the Contractual Type field, include a description of the type of contract proposed. For example, if proposing to rent a space for a workshop from one vendor and procure services for graphic design from a separate vendor, state “Space Rental for Workshop” and “Graphic Design Services” on two separate lines.

Note 1: DO NOT include honoraria in this section. All such costs must be included under the Other Direct Costs tab.

2. In the Purpose of Product or Service field, describe in brief how each contractual product or service supports the project’s goals. Provide additional details as applicable in the Budget Plan Narrative. Other details may include the type of services the proposed Consultant/Contractor/Vendor will provide, and/or the name of the Consultant/Contractor/Vendor.

3. In the Contractual Amount field, include the total amount for the contract. Provide details on the contractual amount in the Budget Plan Narrative. Details may include travel costs for consultants and/or the rate of payment for the consultant (e.g. flat fee, price/hour, number of hours).

Note 2: Entertainment costs are not allowed.

6. CONTRACTUAL
Contractual TypePurpose of Product or ServiceContractual AmountTotal Amount

Contractual Subtotal $ - 0

Other Direct Costs

INSTRUCTIONS FOR COMPLETING THE OTHER TAB
1. In the Other Items field, include a description of other direct costs proposed that are not covered in previous sections of the Budget Plan Workbook. Costs such as honoraria should be included in this tab.

2. In the Purpose of Item field, describe in brief how each type of proposed direct cost supports the project’s goals. Provide additional details as applicable in the Budget Plan Narrative.

3. In the Other Amount field, include the total amount for the direct cost. Provide additional details as applicable in the Budget Plan Narrative. Details may include the names of the honoraria recipients and price per payment.

Note 1: Entertainment costs are not allowed.

7. OTHER DIRECT COSTS
Other ItemsPurpose of ItemOther AmountTotal Amount

Other Direct Costs Subtotal $ - 0

Subawards

INSTRUCTIONS FOR COMPLETING THE SUBAWARDS TAB
1. In the Expense Name field, include a description of the subaward expense proposed.

2. In the Purpose of Expense field, describe in brief how each subaward expense type supports the project’s goals. Provide additional details as applicable in the Budget Plan Narrative.

3. In the Quantity field, provide the number of subawards proposed, as applicable.

4. In the Award Amount field, provide the amount of each subaward proposed, as applicable.

Note 1: Entertainment costs are not allowed.

6. SUBAWARDS
Subaward ExpensePurpose of Subaward ExpenseQuantityAward AmountTotal Amount
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Subawards Subtotal$ - 0

TPS Consortium

INSTRUCTIONS FOR COMPLETING THE TPS CONSORTIUM TAB
1. In the TPS Consortium Expense field, include a description of the TPS Consortium expense proposed.

2. In the Purpose of Expense field, describe in brief how each TPS Consortium expense type supports the project’s goals. Provide additional details as applicable in the Budget Plan Narrative.

3. In the TPS Consortium Amount field, provide the amount of each expense proposed, as applicable.

Note 1: Entertainment costs are not allowed.

6. TPS CONSORTIUM
TPS Consortium ExpensePurpose of ExpenseTPS Consortium AmountTotal Amount

TPS Consortium Subtotal $ - 0

FEDERAL AWARDS

LIST OF PREVIOUS OR ACTIVE FEDERAL AWARDS, FUNDING, GRANTS, OR FELLOWSHIPS
Please use this section to note any current or previous Federal awards made to your organization within the last fiscal year totaling over $1,000,000 (cumulatively), in accordance with Single Audit requirements.
1. ORGANIZATION NAME:
Name of Award / Project TitleDate(s) of FundingSponsor NameTOTAL AWARDED
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0

SINGLE AUDIT REQUIREMENT

SINGLE AUDIT REQUIREMENT
U.S. Office of Management and Budget (OMB), 2 CFR part 200 Uniform Administrative Requirements, Cost Principles and Audit Requirements Subpart F §200.501 requires non-federal entities to have a single or program audit completed if the entity expends $1,000,000 or more during its fiscal year from ALL federal awards. In following in the spirit of the 2 CFR 200, The Library of Congress verifies its award applicants have met the audit requirements and are in compliance with federal regulations. An Authorized Official must indicate whether your organization is subject to the single audit requirements by typing "Y" or "N" in each field below as applicable. Failure to submit this requirement may result in the rejection of your application.
Our organization has not expended $1,000,000 or more in federal funds for the most recent fiscal year referenced above. The Single Audit is not required for this fiscal year.
Our organization has expended $1,000,000 or more in federal funds for the most recent fiscal year referenced above. The Single Audit is required for this fiscal year.

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