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

File Type Posted
BEN-25-048 Exhibit K Assurances Non-Construction Programs.pdf PDF
BEN-25-048 Exhibit H Statement of Work .docx DOCX document
BEN-25-048- RFP .docx DOCX document
BEN-25-048 Appendix D COV Ramp Assessment.xlsx XLSX spreadsheet
BEN-25-048 Exhibit D Statement of Work (SOW) Change Order Template.docx DOCX document
BEN-25-048 Appendix A State Corporation Commission Form.docx DOCX document
BEN-25-048- Exhibit M-2 Cloud Oversight Services (COV RAMP) Nondisclosure Agreement.docx DOCX document
BEN-25-048 Exhibit N Service Level Agreements.docx DOCX document
BEN-25-048 Appendix E Supplier Exceptions to VITA Standard Contract.docx DOCX document
BEN-25-048 Addendum No. 1 .pdf PDF
BEN-25-048 Exhibit G Certification Regarding Lobbying.pdf PDF
BEN-25-048 Appendix D-1 COV Ramp Guidance and Requirements.docx DOCX document
BEN-25-048 Exhibit J Electronic Data Interchange Form.docx DOCX document
BEN-25-048 Exhibit F Contract.docx DOCX document
BEN-25-048 Exhibit M COVRamp Security Questionnaire.xlsx XLSX spreadsheet
BEN-25-048 SNAP 50 50 Preproposal Conference .pptx PPTX presentation
BEN-25-048 Appendix F CoVA W9 .pdf PDF
BEN-25-048- Exhibit A Requirements.xlsx XLSX spreadsheet
BEN-25-048 Appendix C Supplier Profile .docx DOCX document
BEN-25-048 Exhibit I FFATA.docx DOCX document
BEN-25-048 Exhibit C Activities and Outcomes Form.pdf PDF
BEN-25-048 Appendix B Proprietary Confidential Information Identification Form (1).pdf PDF
BEN-25-048 Exhibit E Cloud Terms and Conditions .docx DOCX document
BEN-25-048 Exhibit L Supplier Procurement and Subcontracting Plan.docx DOCX document
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 CATEGORYTOTAL PROGRAM BUDGET (Including amount requested from VDSS)TOTAL VDSS REQUESTTOTAL MATCH AMOUNTTOTAL (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 DSSERROR:#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)TitleTotal 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 DSSTotal Gross Annual SalaryAmount 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.0020%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
0%0%$0.00$0.000%
$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 Employee00000000000000000000
Title00000000000000000000
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 ITEMAmount RequestedLINE ITEMAmount Requested
Only list expenses directly related to this program.
RENTSUBAWARDS$ - 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.00Training$ - 0
Printing$0.00
Postage$0.00OTHER$ - 0
Supplies$0.00Other (Specify)$ - 0
Utilities$0.00Other (Specify)$ - 0
Phone$0.00Other (Specify)$ - 0
Participant Support Costs$0.00Other (Specify)$ - 0
Program Expenses (Specify)$0.00Other (Specify)$ - 0
Program Expenses (Specify)$0.00Other (Specify)$ - 0
Program Expenses (Specify)$0.00Other (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 LeasesTotal$ - 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 CATEGORYBRIEF DESCRIPTIONSOURCE - Supply the orginial source that is providing the cash or in-kind matchCASHIN-KIND VALUETOTAL 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 CostsEnter 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.00MTDC (Modified Total Direct Cost) See definition from 2 CFR 200.68 below.
Indirect Costs Percentage Rate0%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 CostsSkip this sheet if you filled out TAB P-6.
SALARIES0
EMPLOYEE BENEFITS0
RENT0
OFFICE & PROGRAM0
EQUIPMENT0
SUBAWARDS0
TRAINING/TRANSPORTATION0
OTHER0
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 Rate0%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 ItemBudget RequestNarrative 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 .