Copy of Attachment C-Budget Form.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- 27EHSSSYIGRANTHTKA: Grant Application for the SSYI Human Trafficking Intervention Program
- Solicitation number
- BD-27-1039-EHS01-EHS01-132905
- Issued by
- Massachusetts
About this file
This is a budget form template for the Safe and Successful Youth Initiative Human Trafficking Intervention Program (SSYI HT), issued by the Massachusetts Executive Office of Health and Human Services (EOHHS), Office of Children, Youth and Families. The form serves as the financial submission component for grant applications to implement human trafficking intervention services. The budget form is structured to capture detailed payroll information, including staff positions, annual costs, and the portion funded by SSYI HT, along with comprehensive documentation of taxes and fringe benefits. Applicants must complete three fiscal year budget periods: FY2027 (January 1, 2027–June 30, 2027), FY2028 (July 1, 2027–June 30, 2028), and FY2029 (July 1, 2028–June 30, 2029). The form requires narrative justifications for all cost categories and maintains an automated calculation system that populates summary totals based on detailed entries.
The budget form accommodates multiple cost categories including consultants and subcontracts, training, staff travel, meals, facilities, participant stipends and incentives, equipment, supplies, and other direct costs, with all entries requiring detailed narratives explaining the necessity and methodology for allocation. Indirect costs are capped at 15% of total direct costs, consistent with EOHHS-approved rates, and the form includes automated alerts when this threshold is exceeded. Organizations must identify all personnel by name or "TBD" status if positions remain unfilled, provide comprehensive breakdown of payroll taxes and fringe benefits, and justify facility costs through allocation methodologies such as full-time equivalent (FTE) calculations. The template is designed with locked gray cells that auto-populate based on entries in unlocked blue cells, streamlining data compilation and reducing calculation errors for applicant organizations responding to this human trafficking intervention grant opportunity.
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
Instructions
| Executive Office of Health and Human Services, Office of Children, Youth and Families |
| Safe and Successful Youth Initiative Human Trafficking Intervention Program (SSYI HT) |
| Instructions |
| Throughout the budget form, enter data only in the blue cells that are unlocked and available for editing. Gray cells in the form are locked; some auto-populate based on your entries in the blue cells and others are for EOHHS use. |
| Budget Summary Spreadsheet |
| Organization Name: Input your organization's name. |
| Fiscal Year: Choose the applicable fiscal year from the dropdown list next to "Fiscal Year." |
| Completed by: Enter the name of the person who completed the budget form. |
The budget summary will auto-populate based on the entries made in the Payroll and Other Direct and Indirect Costs spreadsheets.
| Auto-populated Messages |
| A red message may appear below the budget in row 25. This message says, "The budget's indirect rate should not exceed 15%." The message will disappear when the budget's total indirect cost divided by the total direct costs is less than or equal to 15%. |
| Payroll Spreadsheet |
| Enter salary information in the Payroll spreadsheet. |
Scroll to the right to enter tax and fringe benefits information.
The sum of these numbers will auto-calculate in the Budget Summary spreadsheet.
| Other Direct and Indirect Costs Spreadsheet |
| Use the hyperlinks provided in the Other Direct and Indirect Costs sheet to quickly navigate between line items on the sheet. |
Enter all nonpayroll information in the Other Direct and Indirect Costs sheet.
Enter indirect costs at the bottom of the Other Direct and Indirect Costs sheet.
The sum of these numbers will auto-calculate in the Budget Summary spreadsheet.
Page &P of &N
Budget Summary
| SSYI HT Budget |
| Organization Name: |
| Fiscal Year: |
| Completed by: |
| Line Item | Budget |
| Program Staff Payroll | - |
| Taxes and Fringe Benefits | - |
| Taxes and Fringe Benefits Rate | |
| Payroll Total | - |
| Consultants and Subcontracts | - |
| Training | - |
| Staff Travel | - |
| Meals | - |
| Facilities | - |
| Participant Stipends, Incentives, and Other Assistance | - |
| Equipment | - |
| Supplies | - |
| Other | - |
| Nonpayroll Total | - |
| Total Direct Expenses | - |
| Indirect Expenses | - |
| Indirect Rate | |
| Expenses Total | - |
&K00-049Executive Office of Health and Human Services Office of Children, Youth and Families Safe and Successful Youth Initiative Human Trafficking (SSYI HT) Grant
Payroll
| Payroll | Taxes and Fringe Benefits |
| Enter data in the blue cells; gray cells with numbers auto-calculate. | |
| Personnel |
Include the staff name and official job title. If a staff person has not been hired or identified please use "TBD" in place of a name, but still identify the official job title.
| Staff Name/Title | Total Annual Cost | SSYI HT Cost | Narrative (Required) | |
| Please provide a description of each staff's position person and their role in implementation. | Portion of Salary Funded By SSYI HT |
| (Auto-calculate) | Taxes and Fringe Benefits | Payroll | Tax and Fringe Rate | Total | |
| (Auto-calculate) | Narrative (Required) |
Include the breakdown of the taxes and benefits.
| - 0 | - 0 | Payroll Taxes | - 0 | 0.00 | - 0 |
| - 0 | - 0 | Fringe Benefits | - 0 | 0.00 | - 0 |
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 | ||||
| - 0 | - 0 |
Other Direct and Indirect Costs
| Other Direct and Indirect Costs | ||
| Consultants and Subcontracts | Training | Staff Travel |
| Meals | Facilities | Participant Stipends, Incentives, and Other Assistance |
| Equipment | Supplies | Other |
| Indirect Costs | ||
| Item | SSYI HT Cost | Narrative (Required) |
Narrative justifications of costs are required for each line item. Please refer to the instructions for each cost category for information on what to include in the narrative.
| Consultants and Subcontracts | Provide a justification for consultants or subcontractors and include the number of hours per month or year. | |
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Training | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Staff Travel | Provide a justification for travel and transportation costs, and include the mileage reimbursement rate used. | |
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Meals | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Facilities | In addition to a justification, include the annual cost, the cost that will be charged to this grant, and the methodology for allocating these costs to this grant (e.g., basing the annual facilities cost on the number of FTEs included in this grant). | |
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Participant Stipends, Incentives, and Other Assistance | In addition to a justification, supply the breakdown of the costs by the types of assistance to be provided. | |
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Equipment (for items over $5,000) | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Supplies | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Other | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| - 0 | ||
| Indirect Costs | Include the indirect cost rate, which should not exceed the EOHHS approved rate of 15%. | |
| - 0 |
Sheet1
| FY2027 (January 1, 2027–June 30, 2027) |
| FY2028 (July 1, 2027–June 30, 2028) |
| FY2029 (July 1, 2028–June 30, 2029) |
File details come from the government source that posted it. Updated .