8-Attachment C.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
Operation of Engagement Centers for the Care and Stabilization of Individuals Experiencing High Levels of Intoxication
Solicitation number
545307
Issued by
Wayne County, Detroit City, Michigan

About this file

This is a budget attachment template from the City of Detroit Office of Contracting and Procurement on behalf of the Housing and Revitalization Department for the operation of engagement centers providing care and stabilization services for individuals experiencing high levels of intoxication in Michigan. The document serves as a budgeting tool for organizations submitting proposals to operate one or more engagement centers that provide short-term, safe, supervised environments for individuals who are very intoxicated or impaired due to substance or polysubstance use. The template requires proposers to complete budget tables for Year 1 and Year 2, with automatic calculation of total budget requests.

The budget attachment template includes line items for personnel costs such as program salaries, payroll taxes capped at 7.65%, and fringe benefits, as well as direct expenses and startup costs. The document contains specific examples of expense categories including transportation costs (bus tickets, Uber rides averaging $27 per ride with approximately 100 monthly uses), miscellaneous supplies, and subcontractor fees. The template includes a requirement that administrative costs cannot exceed 10 percent of the total award. The file also contains a secondary sheet showing detailed salary calculations with percentage-based allocations for benefits and other deductions, demonstrating how individual line items should be computed and justified. Budget narratives are mandatory and must be descriptive, justifying eligibility and alignment with program needs for each line item.

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 Attachment C: Engagement Center

Budget Instructions:

• Complete the table below with information about your project and budget

• Fill in budget for Year 1 and Year 2 (total budget request will automatically calculate)

• This is a template. You are not required to provide an amount for each line item.

• Budget narratives MUST be descriptive and justify why/how a line item is eligible and meets program needs.

Organization Name:

Annual Amount Requested: $ - 0

ExpenseTotal Budget RequestYear 1 BudgetYear 2 BudgetBudget Narrative
Program Salary
Personnel Costs
$ - 0$ - 0$ - 0$ 96.15$ 199,992.00$ 199,992.00$ 79,996.80
$ - 0$ - 0$ - 0$ 103.36$ 214,988.80$ 214,988.80$ 85,995.52
$ - 0$ - 0$ - 0$ 196.20$ 408,096.00$ 408,096.00$ 122,428.80
$ - 0$ - 0$ - 0$ 60.25$ 125,320.00$ 125,320.00$ 31,330.00
$ - 0$ - 0$ - 0$ 61.60$ 128,128.00$ 128,128.00$ 12,812.80
$ - 0$ - 0$ - 0200$ 416,000.00$ 416,000.00$ 83,200.00
$ - 0$ - 0$ - 025$ 52,000.00$ 52,000.00$ 52,000.00
$ - 0$ - 0$ - 045$ 93,600.00$ 93,600.00$ 93,600.00
$ - 0$ - 0$ - 025$ 52,000.00$ 52,000.00$ 52,000.00
$ - 0$ - 0$ - 024$ 49,920.00$ 49,920.00$ 49,920.00
$ - 0$ - 0$ - 039.69$ 82,555.20$ 82,555.20$ 16,510.00
Payroll Taxes (7.65% cap)$ - 0$ - 0$ - 0
Fringe Benefits$ - 0$ - 0$ - 0
Direct Expenses
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ 900.00$ 9,900.00600$ 10,500.00
$ - 0$ - 0$ - 0$ 50.00$ 600.0015011250$ 11,850.00
Start Up Costs
$ - 0
$ - 0
$ - 0
$ - 0
Other (Please provide title)
BusticketsUber
$ - 0$ - 0$ - 0$ 300.00$ 1,200.0027.00 average ride100 month=540064800
$ - 0$ - 0$ - 0
$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ 80.00$ 960.003515350060009500
$ - 04
Subcontractor60
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
SUB TOTAL$ - 0$ - 0$ - 0
Admin
Admin can't be higher than 10% of total award$ - 0$ - 0$ - 0
TOTAL$ - 0$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0

Sheet2

New Budget Breakdown
49662.5SalaryCorrect Amount with Percentage applied to Salary468004820449650.12
3799.187.65%3799.18125fica3580.23687.613798.23
10304.9720.75%10304.96875
439.171.00%496.625971110002.3310302.4
1986.54.00%1986.5468482.04496.5
439.171.00%496.62518721928.161986
439.171.00%496.625468482.04496.5
17408.1635.40%17580.525Under stated468482.04496.5
1298713376.6113777.9
$4,668.56SalaryCorrect Amount with Percentage applied to Salary
$357.147.65%357.14484
$443.529.50%443.51324668.564808.624952.88
$421.681.00%46.6856357.14367.86378.89
$186.744.00%186.7424
$46.691.00%46.6856968.73997.791027.72
$46.691.00%46.685646.6948.0949.53
$1,502.4616.50%1127.45724Over stated186.74192.34198.12
46.6948.0949.53
46.6948.0949.53
180018001295.541334.41374.43
30003000
21002100180018541909.62
12001200300030903182.7
10001000210021632227.898
35003500120012361273.08
26002600100010301060.9
300300350036053713.15
$88,741.68$83,870.48260026782758.34
$8,874.1710%$8,387.05300309318.27
$97,615.85Correct Total$92,257.5385188.4487744.190376.408

Sheet1

Yes
No

File details come from the government source that posted it. Updated .