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 ItemBudget
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

PayrollTaxes 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/TitleTotal Annual CostSSYI HT CostNarrative (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 BenefitsPayrollTax and Fringe RateTotal
(Auto-calculate)Narrative (Required)

Include the breakdown of the taxes and benefits.

- 0- 0Payroll Taxes- 00.00- 0
- 0- 0Fringe Benefits- 00.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 SubcontractsTrainingStaff Travel
MealsFacilitiesParticipant Stipends, Incentives, and Other Assistance
EquipmentSuppliesOther
Indirect Costs
ItemSSYI HT CostNarrative (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 SubcontractsProvide 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 TravelProvide 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
FacilitiesIn 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 AssistanceIn 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 CostsInclude 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 .