Budget Narrative Template.xls
XLS spreadsheet 363 KB Posted
- Solicitation number
- 40DHHS-S3725
- Issued by
- Nevada
About this file
This is a Budget Narrative Template form used by the Division of Welfare & Supportive Services for state and local grant applications. The template is designed to capture detailed budget information for projects and programs funded through the Division, with all activities required to comply with state and local COVID-19 requirements. The form consists of two primary sections: a detailed Budget Narrative that itemizes personnel costs, travel expenses, operating costs, equipment purchases, contractual services, training, and other project-related expenditures, and a Proposed Budget Summary that consolidates expenses across multiple funding sources. The template accommodates multiple employees, contractors, and subrecipients, with built-in formulas that automatically calculate total personnel costs including fringe benefits, travel expenses broken down by in-state and out-of-state trips with component costs for airfare, per diem, lodging, and ground transportation, and indirect costs calculated at a default rate of eight percent of direct expenses.
The budget template requires applicants to provide comprehensive justifications for all expenditures, including detailed descriptions of position duties tied to program objectives, travel purpose and frequency, meal and supply purchases, and equipment justifications for items costing five thousand dollars or more. The form establishes specific guidelines for expense calculations, such as utilizing GSA rates for per diem and lodging and state mileage rates of fifty-four cents per mile unless organizational policies specify lower rates. Applicants must also document the method of contractor selection, scope of work, accountability measures, and program income calculations. The template includes expandable rows for adding or removing employees, contractors, and line items while maintaining formula integrity, and provides space for explaining pending items and documenting federally approved indirect rate agreements.
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 Narrative
| Applicant Name: |
| BUDGET NARRATIVE |
(form revised February 2021)
| All activities, events, meetings etc. will take place in accordance with State and Local compliance requirements related to COVID-19. | ||||||||
| Total Personnel Costs | including fringe | Total: | $0 | |||||
| *Do not delete this row. Grey row used to maintain range of total formulas when employee rows are added/deleted | ||||||||
| List staff, positions, percent of time to be spent on the project, rate of pay, fringe rate, and total cost to this grant. | ||||||||
| Annual Salary | Fringe Rate | % of Time | Months | Percent of Months worked Annual | Amount Requested | Click here to go to an example of how to add extra employee rows | ||
| Name of Employee (if known, otherwise state new position), | ||||||||
| Title of position & Position Control Number | $0.00 | 0.000% | 0.000% | 0 | 0.00% | $0 | ||
| *Insert details to describe position duties as it relates to the funding (specific program objectives) | Click here to go to an example of how to remove extra employee rows | |||||||
| Annual Salary | Fringe Rate | % of Time | Months | Percent of Annual | Amount Requested | |||
| Name of Employee (if known, otherwise state new position), | ||||||||
| Title of position & Position Control Number | $0.00 | 0.000% | 0.000% | 0 | 0.00% | $0 | ||
| *Insert details to describe position duties as it relates to the funding (specific program objectives) | ||||||||
| Annual Salary | Fringe Rate | % of Time | Months | Percent of Annual | Amount Requested | |||
| Name of Employee (if known, otherwise state new position), | ||||||||
| Title of position & Position Control Number | $0.00 | 0.000% | 0.000% | 0 | 0.00% | $0 | ||
| *Insert details to describe position duties as it relates to the funding (specific program objectives) | ||||||||
| Annual Salary | Fringe Rate | % of Time | Months | Percent of Annual | Amount Requested | |||
| Name of Employee (if known, otherwise state new position), | ||||||||
| Title of position & Position Control Number | 0.00% | $0 | ||||||
| *Insert details to describe position duties as it relates to the funding (specific program objectives) | ||||||||
| *Insert new row for each position funded or delete this row. | ||||||||
| *Do not delete this row. Grey row used to maintain range of total formulas when employee rows are added/deleted | ||||||||
| Total Fringe Cost | $0 | Total Salary Cost: | $0 | |||||
| Total Budgeted FTE | 0.00000 | |||||||
| Travel | Total: | $0 | ||||||
| Identify staff who will travel, the purpose, frequency and projected costs. Utilize GSA rates for per diem and lodging (go to www.gsa.gov) and State rates for mileage (54.0 cents) as a guide unless the organization's policies specify lower rates for these expenses. Out-of-state travel or non-standard fares require special justification. | ||||||||
| Out-of-State Travel | $0 | double check formula and revise as needed to include costs of multiple trips | ||||||
| Title of Trip & Destination such as CDC Conference: San Diego, CA | Cost | # of Trips | # of days | # of Staff | ||||
| Airfare: cost per trip (origin & designation) x # of trips x # of staff | $0 | 0 | 0 | $0 | ||||
| Baggage fee: $ amount per person x # of trips x # of staff | $0 | 0 | 0 | $0 | ||||
| Per Diem: $ per day per GSA rate for area x # of trips x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Lodging: $ per day + $ tax = total $ x # of trips x # of nights x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Ground Transportation: $ per r/trip x # of trips x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Mileage: (rate per mile x # of miles per r/trip) x # of trips x # of staff | $0.000 | 0 | 0 | $0 | ||||
| Parking: $ per day x # of trips x # of days x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Justification: Who will be traveling, when and why, tie into program objective(s) or indicate required by funder. | ||||||||
| In-State Travel | $0 | double check formula and revise as needed to include costs of multiple trips | ||||||
| Origin & Destination | Cost | # of Trips | # of days | # of Staff | ||||
| Airfare: cost per trip (origin & designation) x # of trips x # of staff | $0 | 0 | 0 | $0 | ||||
| Baggage fee: $ amount per person x # of trips x # of staff | $0 | 0 | 0 | $0 | ||||
| Per Diem: $ per day per GSA rate for area x # of trips x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Lodging: $ per day + $ tax = total $ x # of trips x # of nights x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Motor Pool:($ car/day + ## miles/day x $ rate per mile) x # trips x # days | $0.00 | 0 | 0 | $0 | ||||
| Mileage: (rate per mile x # of miles per r/trip) x # of trips x # of staff | $0.000 | 0 | 0 | $0 | ||||
| Parking: $ per day x # of trips x # of days x # of staff | $0 | 0 | 0 | 0 | $0 | |||
| Justification: Who will travel and why | ||||||||
| Operating | Total: | $0 | ||||||
| List tangible and expendable personal property, such as office supplies, program supplies, etc. Unit cost for general items are not required. Listing of typical or anticipated program supplies should be included. If providing meals, snacks, or basic nutrition, include these costs here. | ||||||||
| Office supplies $ amount x # of FTE staff x # of mo. | $0.00 | |||||||
| Rent: $ per/mo. x 12 months x # of FTE | $0.00 | |||||||
| Communications | $0.00 | |||||||
| Justification: Provide narrative to justify purchase of meals, snacks, large expense or unusual budget items. Include details how budget item supports deliverables of the project. | ||||||||
| Equipment | Total: | $0 | ||||||
| List Equipment purchase or lease costing $5,000 or more, and justify these expenditures. Also list any computers or computer-related equipment to be purchased regardless of cost. All other equipment costing less than $5,000 should be listed under Supplies. | ||||||||
| Describe equipment | $0.00 | |||||||
| Contractual | $0 | |||||||
| *Do not delete this row. Grey row used to maintain range of total formulas when contractor rows are added/deleted | ||||||||
| Identify project workers who are not regular employees of the organization. Include costs of labor, travel, per diem, or other costs. Collaborative projects with multiple partners should expand this category to break out personnel, travel, equipment, etc., for each site. Sub-awards or mini-grants that are a component of a larger project or program may be included here, but require special justification as to the merits of the applicant serving as a "pass-through" entity, and its capacity to do so. | Click here to go to an example of how to add extra contractor rows | |||||||
| Name of Contractor, Subrecipient: | Total | $0 | ||||||
| Method of Selection: explain, i.e. sole source or competitive bid | Click here to go to an example of how to remove extra contractor row | |||||||
| Period of Performance: xx/xx/xxxx-xx/xx/xxxx | ||||||||
| Scope of Work: Define scope of work - What will be the specific services/tasks that will be completed and specific deliverables? How do deliverables relate to your goals and objectives, how will deliverables achieve your objective(s)? | ||||||||
| * Sole Source Justification: Define if sole source method, not needed for competitive bid | ||||||||
| Budget | ||||||||
| Personnel | $0.00 | Click here to go to an example of how to add extra line items to a contractor | ||||||
| Travel | $0.00 | |||||||
| Total Budget | $0.00 | |||||||
| Method of Accountability: Describe how the progress and performance of the consultant will be monitored. Identify who is responsible for supervising the consultant's work. | ||||||||
| *Do not delete this row. Grey row used to maintain range of total formulas when contractor rows are added/deleted | ||||||||
| Training | Total: | $0 | ||||||
| List all cost associated with Training, including justification of expenditures. | ||||||||
| Describe training | $0.00 | |||||||
| Other | Total: | $0 | ||||||
| Identify and justify these expenditures, which can include virtually any relevant expenditure associated with the project, such as audit costs, car insurance, client transportation, etc. Stipends or scholarships that are a component of a larger project or program may be included here, but require special justification. | ||||||||
| Printing Services: $ amount/mo. x 12 months | $0 | |||||||
| Copier/Printer Lease: $ amount/mo. x 12 months | $0 | |||||||
| Property and Contents Insurance per year | $0 | |||||||
| Other Utilities: $ per quarter | $0 | |||||||
| Postage: $ per mo. x 12 months | $0 | |||||||
| State Phone Line: $ per mo. x 12 months x # 0f FTE | $0 | |||||||
| Voice Mail: $ per mo. x 12 months x # of FTE | $0 | |||||||
| Conference Calls: $ per mo. x 12 months | $0 | |||||||
| Long Distance: $ per mo. x 12 months | $0 | |||||||
| Email: $ per mo. x 12 months x # of FTE | $0 | |||||||
| Justification: Include narrative to justify any special budget line items included in this category, such as stipends, scholarships, marketing brochures or public information. Tie budget piece to project deliverable. | ||||||||
| TOTAL DIRECT CHARGES | $0 | |||||||
| Indirect Charges | Indirect Rate: | 8.000% | $0 | |||||
| Indirect Methodology: Explain how indirect is calculated (e.g. 11% of all direct expenses per Federally approved indirect agreement). If using a Federally approved indirect rate, be sure to include a copy of the agreement to the Division of Welfare and Supportive Services (Division) staff. | ||||||||
| TOTAL BUDGET | Total: | $0 |
Click here to go to an example of how to add extra employee rows Click here to go to an example of how to remove extra employee rows Click here to go to an example of how to add extra contractor rows Click here to go to an example of how to remove extra contractor row Click here to go to an example of how to add extra line items to a contractor All activities, events, meetings etc. will take place in accordance with State and Local compliance requirements related to COVID-19.
Budget Summary
| Applicant Name: | Form 2 | |
| PROPOSED BUDGET SUMMARY |
(form revised February 2021)
| A. | PATTERN BOXES ARE FORMULA DRIVEN - DO NOT OVERRIDE - SEE INSTRUCTIONS | ||||||||
| FUNDING SOURCES | Division of Welfare & Supportive Services (Division) | Other Funding | Other Funding | Other Funding | Other Funding | Other Funding | Other Funding | Program Income | TOTAL |
| SECURED | |||||||||
| ENTER TOTAL REQUEST | $0 | $0 | |||||||
| EXPENSE CATEGORY | |||||||||
| Personnel | $0 | $0 | |||||||
| Travel | $0 | $0 | |||||||
| Operating | $0 | $0 | |||||||
| Equipment | $0 | $0 | |||||||
| Contractual/Consultant | $0 | $0 | |||||||
| Training | $0 | $0 | |||||||
| Other Expenses | $0 | $0 | |||||||
| Indirect | $0 | $0 | |||||||
| TOTAL EXPENSE | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| These boxes should equal 0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Indirect Cost | $0 | Total Agency Budget | $0 | ||||||
| Percent of Subrecipient Budget | 0% | ||||||||
| B. Explain any items noted as pending: | |||||||||
| C. Program Income Calculation: |
&R&"Arial,Italic"&8&Z&F
Add-Remove Lines Examples
| Add/Remove employee rows | |
| Add an employee | |
| 1. | Select/highlight the 3 rows of another employee currently in the budget (1st row is the header row of employee information [row 7 of screenshot], 2nd row is the employee information [row 8 of screenshot], 3rd is the employee narrative [row 9 of screenshot]). |
| Screenshot | |
| 2. | Copy the 3 highlighted rows. This can be done by pressing “CTRL” + “C” or right clicking the highlighted rows and left clicking copy on the menu. |
| Screenshot | |
| 3. | Right click 1 row below what you just copied (row 10 in screenshot below), and left click “Insert Copied Cells”. This will insert 3 rows of an exact copy of your previous 3 row selection. This ensures all formulas are exactly copied and pasted, plus ensures all sum or sum product formulas for personnel/fringe total expand WITH your new employee data. |
| Screenshot | |
| 4. | Screenshot below is example of the final result. Two employee sections of the same information and formulas that followed/expanded without any additional edits. Modify the second employee area to account for the name/position/pay etc.… changes of the new employee area. |
| Screenshot | |
| Remove an employee | |
| 1. | Highlight the 3 rows of employee data you want to delete (1st row is the header row of employee information [row 10 of screenshot], 2nd row is the employee information [row 11 of screenshot], 3rd row is the employee narrative [row 12 of screenshot]). |
| Screenshot | |
| 2. | Press "CTRL" + "-" or right click the rows then left click “Delete”. |
| Screenshot | |
| Add/Remove contractor rows | |
| Add a contractor | |
| 1. | Highlight/Select the row below the "Method of Accountability" row of the previous contractor (row 75 of screenshot). Add a new row by pressing "CTRL" + "+" or right clicking the highlighted row then and left clicking "Insert". |
| Screenshot | |
| 2. | Select/highlight the 10 rows of another contractor currently in the budget (1st row is the row with contractor name and "total" [row 65 of screenshot], 10th row is the "Method of Accountability" row [row 74 of screenshot]). |
| Screenshot | |
| 3. | Right click 1 row below the blank row you just added (row 76 of the screenshot) then right click "Insert Copied Cells". Update the information for the new contractor. |
| Screenshot | |
| Remove a contractor | |
| 1. | Select/highlight the 11 rows of the contractor (the 1st row is the blank row above the contractor's name [row 75 of screenshot], the 11th row is the "Method of Accountability" row [row 85 of screenshot]). Press "CTRL" + - or right click the highlighted area and left click "Delete" |
| Screenshot | |
| Add contractor line item | |
| 1. | Highlight/select the row that says "Travel" (row 72 of screenshot). Add a new row by pressing "CTRL" + "+" or right click the highlighted area then left click "Insert" |
| Screenshot | |
| 2. | Highlight/Select the new blank row (row 72 of screenshot) |
| Screenshot | |
| 3. | Copy the data from the row above by pressing "CTRL" + "D" |
| Screenshot | |
| 4. | Update the category title and amount. Repeat as needed. Adding line items this way ensures that all sum formulas expand with the new data and all new line items retain the same format. |
| Screenshot |
Internal Use Only
| Budget Summary | |||||||||||
| Column | Col A | Col B | Col C | Col D | Col E | Col F | Col G | Col H | Col I | Col J | Total |
| Ideal width | 24 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 123 |
| Current | 24.0 | 14.0 | 11.0 | 11.0 | 11.0 | 11.0 | 11.0 | 11.0 | 11.0 | 11.0 | 126 |
| Difference | 0.0 | 3.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 |
| Result | |||||||||||
| Possible issue | Click on cell and press "F2" to ensure current width is recalculated | ||||||||||
| Budget Narrative | |||||||||||
| Column | Col A | Col B | Col C | Col D | Col E | Col F | Col G | Total | |||
| Ideal width | 31 | 11 | 8 | 10 | 9 | 12 | 12 | 93 | |||
| Current | 31.0 | 11.0 | 8.0 | 10.0 | 9.0 | 12.0 | 12.0 | 93 | |||
| Difference | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | |||
| Result | |||||||||||
| OK | Click on cell and press "F2" to ensure current width is recalculated |
File details come from the government source that posted it. Updated .