BEN-25-048 Exhibit B Budget.xlsx
XLSX spreadsheet 175 KB Posted
- Attached to
- BEN-25-048 SNAP/50
- Solicitation number
- RFP-125291
- Issued by
- Virginia
About this file
This file is a budget template (Exhibit B) for the Virginia Department of Social Services (VDSS) in connection with contract BEN-25-048, which solicits proposals for Supplemental Nutrition Assistance Program Employment and Training (SNAP E&T) services in Virginia. The template provides comprehensive instructions for eligible entities to submit detailed budgets supporting their proposals for employment and training services to SNAP recipients. The budget structure requires applicants to complete multiple worksheets addressing salary and staffing allocations, employee benefits, other direct expenses, matching funds, and indirect costs. Applicants must provide itemized listings of program staff funded through the grant, including names, titles, hours allocated to the program, and salary amounts, along with detailed benefit calculations for each employee. The template also requires documentation of non-salary expenses including rent, office and program costs, equipment purchases, subawards, training and transportation, and other direct program expenses, each with corresponding narrative explanations.
The budget instructions specify that applicants may claim indirect costs using either a de minimis rate (up to 15% of Modified Total Direct Costs for organizations without a federally approved negotiated indirect cost rate) or a Negotiated Indirect Cost Rate Agreement (NICRA) if federally approved. Match funding is not required for every budget category but must be calculated using a specific formula when included; awarded funds cannot supplant existing funds. All expenses must directly relate to the SNAP E&T program, and applicants must provide comprehensive budget narratives with detailed calculations and examples justifying each line item request. The template includes editable fields in yellow for data entry and contains unresolved threaded comments regarding clarifications on staff salary allocation methodology, ongoing training costs, participant support expenses, and other budget considerations.
View the file
Other files
Show all 24
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
| Attachment B - Budget |
| Instructions for Completing Budget Sheets |
P1-Budget Summary: Fill in the cells titled "SUBGRANTEE Name" and "Grant Period" at the top of the worksheet. Proceed to entering budget items on the sheet called "P2 Salary" and continue until you have completed all worksheets that apply to your application.
| P2-Salary This worksheet details which program staff positions will be funded through this grant. |
| Please list names of program staff to be funded. Only list the staff that will be funded (in whole or part) by this grant. (Attachments with a list of staff members will not be accepted.) |
| List the titles of staff. |
| List total hours worked per week. |
| List hours per week spent on THIS program. |
| List # of hours per week to be paid by VDSS. |
| List total gross annual salary. |
| P-3 Itemized Budget for Employee Benefits: This section of the worksheet details the benefits offered to employees of your program. |
| Names and titles of employees will populate from P2 Salary. Be sure to work down the column instead of across for each employee. |
| Enter total amount of each benefit for each employee for the year (except FICA. FICA will be automatically calculated.) |
| Enter the percentage of benefits that you would like VDSS to pay for each employee for each benefit. This may or may not be the same percentage you are requesting for salaries. However, the benefits percentage cannot exceed Column K in the tab called "P2 - Salary." |
| P-4 Other Expenses This tab allows for line items that are being requested for expenses other than salaries and benefits. All expenses must directly relate to THIS program. |
| P 5 Match: This sheet lists the Matching funds to support the project. Although the Application Budget allows match for each line item, you are not required to have match in every budget category for which you request grant funds. |
| Indirect Costs: Complete EITHER Tab P-6 Indirect OR Tab P-6 Indirect (2). |
| P-6 Indirect -- Complete this sheet if you do NOT have a federally approved negotiated cost rate. |
| If you have a federally approved rate, skip this page and go to Tab P-6 Indirect (2). |
| Indirect costs will be based on the de minimus calculation: Up to 15% X MTDC (Modified Total Direct Costs) |
| P-6 Indirect (2) --Complete this sheet only if you have a federally approved negotiated cost rate. |
| Skip this sheet if you filled out Tab P-6 Indirect. |
| Indirect costs will be based on the NICRA (Negotiated Indirect Costs Rate Agreement). |
| P-7 Budget Narrative: Use this worksheet to provide your budget narrative according to amounts requested on Pages 2-4. Provide an in depth summary along with examples of calculations in this sheet. |
| Example: Printing 500 copies of a new brochures. The cost per item is .39. |
| The cost of 500 (brochures) x .39 (each copy) = $195.00. |
ATTACHMENT B
Page &P of &N
RFA #XXX-XX-XXX
FAQ
tc={AF7F08A1-59B3-4D8C-A4FD-336FA08C2523}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
VDSS, recommend typing this information out so applicants can access the links in # 14 and 15 Reply:
Open comment Reply:
Still has not been resolved.
VDSS, recommend typing this information out so applicants can access the links in # 14 and 15
Open comment
Still has not been resolved.
P 1-Budget Summary Please enter data into yellow fields only!
BUDGET SUMMARY - DSS FUNDS
| SUBGRANTEE NAME | |
| Grant Period | |
| Contract # | BEN-25-048 |
| Attachment # | B |
| BUDGET CATEGORY | TOTAL PROGRAM BUDGET (Including amount requested from VDSS) | TOTAL VDSS REQUEST | TOTAL MATCH AMOUNT | TOTAL (Match + VDSS Request) |
| SALARIES | $0.00 | $0.00 | $0.00 | $0.00 |
| EMPLOYEE BENEFITS | $0.00 | $0.00 | $0.00 | $0.00 |
| RENT | $0.00 | $0.00 | $0.00 | $0.00 |
| OFFICE & PROGRAM | $0.00 | $0.00 | $0.00 | $0.00 |
| EQUIPMENT | $0.00 | $0.00 | $0.00 | $0.00 |
| SUBAWARDS | $0.00 | $0.00 | $0.00 | $0.00 |
| TRAINING/TRANSPORTATION |
tc={FF869063-CF4E-4903-ABA3-AAC8B78D7A88}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
What about ongoing training? Should applicants quote a price for this?
Reply:
Open comment Reply:
| Not resolved. | $0.00 | $0.00 | $0.00 | $0.00 | ||
| OTHER | $0.00 | $0.00 | $0.00 | $0.00 | ||
| INDIRECT COSTS | $0.00 | $0.00 | $0.00 |
| Total | $0.00 | $ - 0 | $0.00 | $0.00 | $0.00 | |
| Percentage of Total Program Budget Requested from DSS | ERROR:#DIV/0! | ERROR:#DIV/0! | Erorr will appear until the costs are entered. This will not affect the calculations. | |||
| Awarded funds cannot be used to supplant existing funds. |
Please enter data into yellow fields only!
Instructions can be found on the tab labeled "Instructions"
What about ongoing training? Should applicants quote a price for this?
Not resolved.
ATTACHMENT B
P 2-Salary
| Please enter data into yellow fields only! | |||||||||
| ITEMIZED BUDGET - SALARIES | |||||||||
| SUBGRANTEE NAME: | |||||||||
| Grant Period: | Column K | ||||||||
| Name of Staff (List names of program staff to be funded in whole or part by DSS only) | Title | Total hours per week | # of hours per week spent on this program | # of hours per week spent on this program to be paid by DSS | % of time spent on this program | % of program salary to be paid by DSS | Total Gross Annual Salary | Amount of salary devoted to this program |
tc={7A69B26C-2951-48FC-949A-4B3FFF495840}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
I am confused by this column – why is knowing the estimated amount of the salary proportionate to the employees work on the program important to know?
Reply:
Open comment Reply:
Not resolved. Amount of salary to be paid by DSS Maximum % of benefits that DSS will pay for this employee
| 0% | 0% | $5,000.00 | $5,000.00 | $1,000.00 | 20% |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| 0% | 0% | $0.00 | $0.00 | 0% | |
| $5,000.00 | $5,000.00 | $1,000.00 |
Please enter data into yellow fields only!
I am confused by this column – why is knowing the estimated amount of the salary proportionate to the employees work on the program important to know?
ATTACHMENT B
P 3 Benefits
| Please enter data into yellow fields only! Make sure to work down the column for each employee. | ||||||||||||||||||||
| ITEMIZED BUDGET - BENEFITS | ||||||||||||||||||||
| SUBGRANTEE | ||||||||||||||||||||
| Grant Period: | ||||||||||||||||||||
| Name of Employee | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Title | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total FICA per employee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| % requested from DSS | |||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total RETIREMENT cost per employee | ||||||||||||||||||||||
| % requested from DSS | ||||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total LIFE INSURANCE | |||||||||||||||||||||
| % requested from DSS | |||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total UNEMPLOYMENT | |||||||||||||||||||||
| % requested from DSS | |||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total WORKERS COMP | |||||||||||||||||||||
| % requested from DSS | |||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total HEALTH INSURANCE | |||||||||||||||||||||
| % requested from DSS | |||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total OTHER BENEFITS | |||||||||||||||||||||
| % requested from DSS | |||||||||||||||||||||
| Amt requested from DSS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Benefits per employee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total benefits requested from DSS | $ - 0 |
ATTACHMENT B
P 4-Other Expenses
| Please enter data into yellow fields only! | |||
| ITEMIZED BUDGET - OTHER PROPOSED EXPENSES | |||
| SUBGRANTEE Name: | |||
| Grant Period: | |||
| LINE ITEM | Amount Requested | LINE ITEM | Amount Requested |
| Only list expenses directly related to this program. | ||
| RENT | SUBAWARDS | $ - 0 |
STAFF TRAVEL & TRAINING
tc={BAE1C968-EB5A-40DB-9FA6-C08B6B3807D0}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
What about any other expenses related to delivery of training to COV SNAP participants?
Is this amount a cost per unit? How is the cost determined?
Reply:
Open comment Reply:
| Not resolved. | $ - 0 | |||
| Travel | $ - 0 | |||
| OFFICE and PROGRAM EXPENSES | $0.00 | Training | $ - 0 | |
| Printing | $0.00 | |||
| Postage | $0.00 | OTHER | $ - 0 | |
| Supplies | $0.00 | Other (Specify) | $ - 0 | |
| Utilities | $0.00 | Other (Specify) | $ - 0 | |
| Phone | $0.00 | Other (Specify) | $ - 0 | |
| Participant Support Costs | $0.00 | Other (Specify) | $ - 0 | |
| Program Expenses (Specify) | $0.00 | Other (Specify) | $ - 0 | |
| Program Expenses (Specify) | $0.00 | Other (Specify) | $ - 0 | |
| Program Expenses (Specify) | $0.00 | Other (Specify) | ||
| Program Expenses (Specify) | $0.00 |
| EQUIPMENT | $ - 0 | ||
| Place each individual equipment purchase over $10,000 below. Each equipment purchase under $10,000 should be placed under Supplies above. Place each equipment purchase with a service life of one year or less (no matter the cost) under Supplies as well. | |||
| Equipment Purchase over $10,000 (Specify) | $ - 0 | ||
| Equipment Purchase over $10,000 (Specify) | $ - 0 | ||
| Equipment Leases | Total | $ - 0 | |
| * Awarded funds cannot be used to supplant existing funds. | |||
| Please enter data into the yellow fields only! |
What about any other expenses related to delivery of training to COV SNAP participants?
Is this amount a cost per unit? How is the cost determined?
ATTACHMENT B
P 5 -Match
| Please enter data into yellow fields only! |
| NON-REIMBURSMENT COST |
| SUBGRANTEE Name: | |||||
| Grant Period: | |||||
| BUDGET CATEGORY | BRIEF DESCRIPTION | SOURCE - Supply the orginial source that is providing the cash or in-kind match | CASH | IN-KIND VALUE | TOTAL MATCH |
| Salaries | $ - 0 | $ - 0 | $ - 0 | ||
| Employee Benefits | $ - 0 | $ - 0 | $ - 0 | ||
| Rent | $ - 0 | $ - 0 | $ - 0 | ||
| Office and Program | $ - 0 | $ - 0 | $ - 0 | ||
| Equipment | $ - 0 | $ - 0 | $ - 0 | ||
| Subcontracting Services | $ - 0 | $ - 0 | $ - 0 | ||
| Training & Transportation | $ - 0 | $ - 0 | $ - 0 | ||
| Other | $ - 0 | $ - 0 | $ - 0 | ||
| Total Amount Supplierd by Match | $ - 0 | $ - 0 | $ - 0 |
| To Figure Match: |
| (1) 100% - match % = y% (2) Amount of Award Divided by y% = X (3) x - Amount of Award = Match Amount |
Example - $100,000 grant with a 15% match (You do NOT figure the match by multiplying $100,000 by 15%.)
Calculation based on formula above
| 100% - 15% = 85% |
| $100,000 / 85% = $117,616 match |
The match ($17,646) plus the grant award ($100,000) = $117,646 which is the TOTAL amount of the program budget.
The match of $17,646 is 15% of the total program budget, not 15% of the grant award.
$17,646 / $117,646 = 15%.
ATTACHMENT B
P-6 Indirect
| Please enter data in yellow cells only. |
| Complete EITHER Tab "P-6 Indirect" OR Tab "P-6 Indirect (2)". |
| Complete this sheet if you do NOT have a federally approved negotiated cost rate. |
| If you have a federally approved rate, skip this page and go to Tab P-6 Indirect (2). |
| Note: Indirect costs are not required in your budget. |
| INDIRECT COSTS |
| Subgrantee Name: |
| Grant Period: |
If you have a federally approved indirect costs rate, skip this page and go to Tab P-6 (2).
INDIRECT COSTS -- DE MINIMUS CALCULATION
| DIRECT COSTS | |
| SALARIES | $ - 0 |
| EMPLOYEE BENEFITS | $ - 0 |
| RENT | $ - 0 |
| OFFICE & PROGRAM | $ - 0 |
| EQUIPMENT | $ - 0 |
| SUBAWARDS | $ - 0 |
| TRAINING/TRANSPORTATION | $ - 0 |
| OTHER | $ - 0 |
| TOTAL DIRECT COSTS | $0.00 |
| EXCLUDED EXPENSES | |
| Rent | $ - 0 |
Equipment over $10,000 $ - 0
Subcontracting Expenses: Amount >$50,000 FALSE If Cell B21 is less than $50,000, the message "FALSE" will appear.
| Other Excluded Costs | Enter the total AMOUNT of other excluded costs. | |
| (Other exclusions include participant support costs, capital expenditures, charges for patient care, tuition remission, scholarships and fellowships.) | ||
| Participant Support Costs include direct costs for items such as stipends, subsistence allowances, travel allowances, and registration fees paid to or on behalf of participants or trainees (but not employees) in connection with conferences or trainings. | ||
| Total Excluded Costs | $0.00 |
| Total Direct Costs - Excluded Costs = Base | $0.00 | MTDC (Modified Total Direct Cost) See definition from 2 CFR 200.68 below. |
| Indirect Costs Percentage Rate | 0% | Enter a rate up to 15% here. |
| Base x Percentage Rate = Indirect Costs | $0.00 |
MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs and the portion of each subward or subcontract in excess of $50,000. (Participant Support Costs include direct costs for items such as stipends, subsistence allowances, travel allowances, and registration fees paid to or on behalf of participants or trainees (but not employees) in connection with conferences or trainings.)
ATTACHMENT B
P-6 Indirect (2)
| Complete EITHER Tab "P-6 Indirect" OR Tab "P-6 Indirect (2)". |
| Complete this sheet only if you have a federally approved negotiated cost rate. |
| Skip this sheet if you filled out TAB P-6. |
| Please submit a copy of your NICRA (Negotiated Indirect Cost Rate Agreement) with this application. |
| Indirect Costs are not required in your budget. |
| Please enter data in yellow cells only. |
| INDIRECT COSTS |
| Subgrantee Name: | 0 |
| Grant Period: | 0 |
Skip this sheet if you filled out TAB P-6 Indirect.
| Indirect Costs Calculation with NICRA | ||
| Complete this sheet only if you have a federally approved negotiated cost rate. | ||
| Direct Costs | Skip this sheet if you filled out TAB P-6. | |
| SALARIES | 0 | |
| EMPLOYEE BENEFITS | 0 | |
| RENT | 0 | |
| OFFICE & PROGRAM | 0 | |
| EQUIPMENT | 0 | |
| SUBAWARDS | 0 | |
| TRAINING/TRANSPORTATION | 0 | |
| OTHER | 0 | |
| TOTAL DIRECT COSTS | $0.00 |
| EXCLUDED EXPENSES |
| Please enter the total amount of all excluded expenses from above (according to your NICRA). |
| Total Direct Costs - Excluded Costs = Base | $0.00 | (Note: The base could be MTDC, S&W, S,W&B, or other. ) |
| Federally Approved Indirect Costs Percentage Rate | 0% | Enter federally approved rate here |
| Base x Percentage Rate = Indirect Costs | $0.00 |
ATTACHMENT B
P 7-Budget Narrative
| Please provide a COMPLETE description for all expenses. | ||
| Please enter data in yellow cells only. Rows will expand upon typing. | ||
| BUDGET NARRATIVE | ||
| SUBGRANTEE Name: | ||
| Grant Period: | ||
| Line Item | Budget Request | Narrative Description |
| SALARIES | |
| $ - 0 | |
| BENEFITS | |
| $ - 0 | |
| RENT | |
| $ - 0 | |
| OFFICE and PROGRAM EXPENSES | |
| Printing | $ - 0 |
| Postage | $ - 0 |
| Supplies | $ - 0 |
| Utilities | $ - 0 |
| Phone | $ - 0 |
| Participant Support Costs | $ - 0 |
| Program Expenses (Specify) | $ - 0 |
| Program Expenses (Specify) | $ - 0 |
| Program Expenses (Specify) | $ - 0 |
| Program Expenses (Specify) | $ - 0 |
| EQUIPMENT | |
| Equipment Purchase over $10,000 (Specify) | $ - 0 |
| Equipment Purchase pver $10,000 (Specify) | $ - 0 |
| Equipment Leases | $ - 0 |
| SUBAWARDS | |
| $ - 0 | |
| STAFF TRAVEL & TRAINING | |
| Travel | $ - 0 |
| Training | $ - 0 |
| OTHER | |
| Other (Specify) | $ - 0 |
| Other (Specify) | $ - 0 |
| Other (Specify) | $ - 0 |
| Other (Specify) | $ - 0 |
| Other (Specify) | $ - 0 |
| Other (Specify) | $ - 0 |
| Other (Specify) | $ - 0 |
| INDIRECT | |
| $ - 0 | |
| Total | $0.00 |
ATTACHMENT B
image1.png
File details come from the government source that posted it. Updated .