7-Attachment C- Budget Proposal Template RFP 545870.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Year-Round Emergency Shelters
- Solicitation number
- 545870
- Issued by
- Wayne County, Detroit City, Michigan
About this file
This is a Budget Proposal Template (Attachment C) for RFP 545870, submitted to the City of Detroit Office of Contracting and Procurement on behalf of the Housing and Revitalization Department for a Year-Round Emergency Shelters contract. The template provides a structured framework for organizations to submit detailed budget proposals including personnel costs, fringe benefits, direct expenses, startup costs, and administrative expenses. The budget narrative requires detailed descriptions justifying each line item, including full-time equivalent (FTE) staffing positions and how costs meet program needs.
The budget template establishes key financial parameters, including a payroll tax cap of 7.65% and an administrative cost ceiling of no more than 10% of the total award amount. Personnel costs represent the primary budget category, with multiple salary positions listed at varying hourly rates and annual amounts. Direct expenses include items such as supplies, transportation (with specific calculations for average monthly rides), and miscellaneous operational costs. The template contains multiple budget breakdowns and percentage allocations across different cost categories, with corrected totals and adjusted amounts reflecting various percentage applications. Subcontractor costs are also accommodated within the budget structure. The document demonstrates a comprehensive approach to capturing all project-related expenses while maintaining fiscal controls through percentage caps on administrative and payroll costs.
View the file
Other files
Show all 11
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: Application Budget
Budget Instructions:
• Complete the table below with information about your project and budget
• This is a template. You can edit as necessary.
• 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 Budget Request Budget Narrative Must include detailed description for each line item, including number of FTE for each staff position.
| Program Salary | ||||||||
| Personnel Costs | ||||||||
| $ - 0 | $ 96.15 | $ 199,992.00 | $ 199,992.00 | $ 79,996.80 | ||||
| $ - 0 | $ 103.36 | $ 214,988.80 | $ 214,988.80 | $ 85,995.52 | ||||
| $ - 0 | $ 196.20 | $ 408,096.00 | $ 408,096.00 | $ 122,428.80 | ||||
| $ - 0 | $ 60.25 | $ 125,320.00 | $ 125,320.00 | $ 31,330.00 | ||||
| $ - 0 | $ 61.60 | $ 128,128.00 | $ 128,128.00 | $ 12,812.80 | ||||
| $ - 0 | 200 | $ 416,000.00 | $ 416,000.00 | $ 83,200.00 | ||||
| $ - 0 | 25 | $ 52,000.00 | $ 52,000.00 | $ 52,000.00 | ||||
| $ - 0 | 45 | $ 93,600.00 | $ 93,600.00 | $ 93,600.00 | ||||
| $ - 0 | 25 | $ 52,000.00 | $ 52,000.00 | $ 52,000.00 | ||||
| $ - 0 | 24 | $ 49,920.00 | $ 49,920.00 | $ 49,920.00 | ||||
| $ - 0 | ||||||||
| $ - 0 | 39.69 | $ 82,555.20 | $ 82,555.20 | $ 16,510.00 | ||||
| Payroll Taxes (7.65% cap) | $ - 0 | |||||||
| Fringe Benefits | $ - 0 | |||||||
| Direct Expenses | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | $ 900.00 | $ 9,900.00 | 600 | $ 10,500.00 | ||||
| $ - 0 | $ 50.00 | $ 600.00 | 150 | 11250 | $ 11,850.00 | |||
| Start Up Costs | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| Other (Please provide title) | ||||||||
| $ - 0 | $ 300.00 | $ 1,200.00 | 27.00 average ride | 100 month= | 5400 | 64800 | ||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| $ - 0 | $ 80.00 | $ 960.00 | 35 | 15 | 3500 | 6000 | 9500 | |
| $ - 0 | 4 | |||||||
| Subcontractor | 60 | |||||||
| $ - 0 | ||||||||
| $ - 0 | ||||||||
| SUB TOTAL | $ - 0 | |||||||
| Admin | ||||||||
| Admin can't be higher than 10% of total award | $ - 0 | |||||||
| TOTAL | $ - 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 .