8-Attachment C.xlsx
XLSX spreadsheet 31 KB Posted
- 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
| File | Type | Posted |
|---|---|---|
| 5-545307 RFP.pdf | ||
| 3-Attachment D-1 Required Forms Affidavits RFP.pdf | ||
| 4-Attachment D-2 Conditions of Award.pdf | ||
| 2-Equalization Credit Statement.pdf | ||
| 6-Attachment A.pdf | ||
| 7-Attachment B.pdf | ||
| 1-Attachment E - Professional Service Contract Sample.docx | DOCX document |
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
| Expense | Total Budget Request | Year 1 Budget | Year 2 Budget | Budget 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 | $ - 0 | 200 | $ 416,000.00 | $ 416,000.00 | $ 83,200.00 | ||
| $ - 0 | $ - 0 | $ - 0 | 25 | $ 52,000.00 | $ 52,000.00 | $ 52,000.00 | ||
| $ - 0 | $ - 0 | $ - 0 | 45 | $ 93,600.00 | $ 93,600.00 | $ 93,600.00 | ||
| $ - 0 | $ - 0 | $ - 0 | 25 | $ 52,000.00 | $ 52,000.00 | $ 52,000.00 | ||
| $ - 0 | $ - 0 | $ - 0 | 24 | $ 49,920.00 | $ 49,920.00 | $ 49,920.00 |
| $ - 0 | $ - 0 | $ - 0 | 39.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.00 | 600 | $ 10,500.00 | ||||
| $ - 0 | $ - 0 | $ - 0 | $ 50.00 | $ 600.00 | 150 | 11250 | $ 11,850.00 | |||
| Start Up Costs | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Other (Please provide title) | ||||||||||
| Bustickets | Uber | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ 300.00 | $ 1,200.00 | 27.00 average ride | 100 month= | 5400 | 64800 | ||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | ||||||||||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | $ 80.00 | $ 960.00 | 35 | 15 | 3500 | 6000 | 9500 | |
| $ - 0 | 4 | |||||||||
| Subcontractor | 60 | |||||||||
| $ - 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.5 | Salary | Correct Amount with Percentage applied to Salary | 46800 | 48204 | 49650.12 | ||||
| 3799.18 | 7.65% | 3799.18125 | fica | 3580.2 | 3687.61 | 3798.23 | |||
| 10304.97 | 20.75% | 10304.96875 | |||||||
| 439.17 | 1.00% | 496.625 | 9711 | 10002.33 | 10302.4 | ||||
| 1986.5 | 4.00% | 1986.5 | 468 | 482.04 | 496.5 | ||||
| 439.17 | 1.00% | 496.625 | 1872 | 1928.16 | 1986 | ||||
| 439.17 | 1.00% | 496.625 | 468 | 482.04 | 496.5 | ||||
| 17408.16 | 35.40% | 17580.525 | Under stated | 468 | 482.04 | 496.5 | |||
| 12987 | 13376.61 | 13777.9 | |||||||
| $4,668.56 | Salary | Correct Amount with Percentage applied to Salary | |||||||
| $357.14 | 7.65% | 357.14484 | |||||||
| $443.52 | 9.50% | 443.5132 | 4668.56 | 4808.62 | 4952.88 | ||||
| $421.68 | 1.00% | 46.6856 | 357.14 | 367.86 | 378.89 | ||||
| $186.74 | 4.00% | 186.7424 | |||||||
| $46.69 | 1.00% | 46.6856 | 968.73 | 997.79 | 1027.72 | ||||
| $46.69 | 1.00% | 46.6856 | 46.69 | 48.09 | 49.53 | ||||
| $1,502.46 | 16.50% | 1127.45724 | Over stated | 186.74 | 192.34 | 198.12 | |||
| 46.69 | 48.09 | 49.53 | |||||||
| 46.69 | 48.09 | 49.53 | |||||||
| 1800 | 1800 | 1295.54 | 1334.4 | 1374.43 | |||||
| 3000 | 3000 | ||||||||
| 2100 | 2100 | 1800 | 1854 | 1909.62 | |||||
| 1200 | 1200 | 3000 | 3090 | 3182.7 | |||||
| 1000 | 1000 | 2100 | 2163 | 2227.898 | |||||
| 3500 | 3500 | 1200 | 1236 | 1273.08 | |||||
| 2600 | 2600 | 1000 | 1030 | 1060.9 | |||||
| 300 | 300 | 3500 | 3605 | 3713.15 | |||||
| $88,741.68 | $83,870.48 | 2600 | 2678 | 2758.34 | |||||
| $8,874.17 | 10% | $8,387.05 | 300 | 309 | 318.27 | ||||
| $97,615.85 | Correct Total | $92,257.53 | 85188.44 | 87744.1 | 90376.408 |
Sheet1
| Yes |
| No |
File details come from the government source that posted it. Updated .