Each table has columns that automatically calculate totals based on the information entered. Worksheet (c), Budget Summary, totals the information entered on Worksheets 1-11.Â
Budget workbook will be available 10/30.
This document is for reference only; all budgets must be submitted as an attachment using the budget workbook. The following worksheets are included within the budget workbook.
The first tab of the workbook includes a linked list of all tables within the workbook. Use the list as a reference, and use the links to navigate between tables.
The Applicant Information table asks for basic information about the organization. Enter contact details, payment method preference, and indirect cost election information.
The Budget Summary table automatically calculates totals, by funding year, of the information entered in the proposed budget tables (1–11). However, cells B14 and C14 may be manually entered if the total direct costs are different than a sum of the totals on Tables 1–10. If this is the case, provide an explanation for this calculation in the budget narrative.
The Proposed Budget worksheets are numbered 1-13. For additional guidance on entering appropriate costs, see the State of Illinois Uniform Grant Budget Template. The following table details and instructions summarize the information included on the Index tab of the workbook.
The Personnel table includes salaries and wages charged to the grant (2 CFR § 200.430). List each position by title, name of employee (if available), salary rate, total percentage of time to be devoted to the project, and length of time they will be employed by the organization. Additionally, enter the percentage of their time each employee will spend on each task.
The Fringe Benefits table includes benefits provided in excess of wages (2 CFR § 200.431). Provide fringe base and rate information for each position. Columns A, B, and E should automatically populate from the Personnel worksheet. However, you may type over these columns if the worksheet does not populate appropriately.
The Travel table includes travel to and from relevant professional development conferences and meetings (2 CFR § 200.474). List who will be traveling, estimated cost, basis, and quantity or duration of the item.
The Equipment table includes property worth more than $5,000 that has a useful life of more than one year (2 CFR § 200.439). List each item of equipment and estimated cost.
The Supplies table includes materials that are expendable or consumed during the course of the project (2 CFR § 200.94). List the supplies by type (office supplies, postage, training materials, copying paper, and other expendable items such as books) and show the basis for computation.
The Contractual Services table includes property or services obtained by contract to carry out the project or program (2 CFR § § 200.318 and 200.92). List the service to be procured by contract and an estimate of the cost.
The Consultant Services and Expenses table includes fees and travel costs for persons providing professional services (2 CFR § 200.459). Enter the name (if known), service to be provided, hourly or daily fee (8-hour day), and estimated time to be spent on the project.
The Occupancy table includes rent and utilities based on percentage of operating costs (2 CFR § 200.465). List items and descriptions by major type and the basis of the computation.
The Training and Education table includes rental space and materials for training activities (2 CFR § 200.472). Enter needs related to training activities to be delivered (not subject to application of indirect costs).
This is not applicable for this program.
The Total Indirect Costs table includes indirect costs per NICRA rates or de minimis (up to 15%). See 2 CFR § 200.413 for definition of direct costs, 2 CFR § 200.405 for definition of allocable costs, and 2 CFR § 200.414 for definition of indirect costs. Enter base rate to calculate indirect costs. If de minimis is selected, submit documentation on the calculation of MTDC within your Program Narrative under Total Indirect Costs.
Provide details and justify why each line item requested within the proposed budget tables are needed to accomplish the scope of work.
Requests for advance payment must be accompanied by an Advance Payment Request Cash Budget (Cash Budget) if the preferred payment method selected is either Advance Payment and Reconcile or Working Capital Advance Method.
The Cash Budget must demonstrate the estimated monthly cash requirements for each month of the program grant term. Advance payments must be limited to the minimum amounts needed and must be timed to be in accordance with the actual, immediate cash requirements of the grantee in carrying out the purpose of the approved program or project. The timing and amount of advance payments must be as close as is administratively feasible to the actual disbursements by the grantee for direct program or project costs and the proportionate share of any allowable indirect costs. Additionally, the grantee entity must make timely payment to subrecipients and contractors.
Please note, if you are awarded and your preferred payment method is advanced payment and reconciliation, you will be asked to send documents that demonstrate your eligibility per 2 CFR § 200.302 and 2 CFR § 200.305. Illinois requires that the following conditions must be met to receive advanced payment.
You must maintain or demonstrate the willingness to maintain both: