The file's text, extracted by GovTribe without its formatting.
INSTRUCTIONS
| Attachment 5 Cost Worksheet Template must be submitted as the Excel file itself with your proposal. |
| GENERAL COST SUMMARY WORKSHEET |
| Proposer shall complete the General Cost Proposal Worksheet to list all associated cost such as labor cost for all key personnel (including subcontractors) who will be working on the project and include their job titles/classifications, hours of service, hourly rate, and total projected cost. Proposer shall list all direct and indirect costs including any miscellaneous costs in the General Cost Proposal Worksheet. |
| % BREAKDOWN WORKSHEET |
| Proposer shall show the percentage math breakdown of all subcontractors declared. Please reference the cells used. Percentages shall be rounded to two decimal places. The Bidder Declaration form subcontractor percentage must match what is shown in the SB DVBE % Breakdown worksheet and your math breakdown. |
| Proposer shall show the percentage math breakdown of the Scope of Work tasks according to Attachment 3, Exhibit A - Section F. Proposer shall provide justification if they cannot meet the minimum percentage and dollar amount. |
| COST BY TASK WORKSHEET |
| Proposer shall complete the Total Cost By Tasks to breakdown the cost by tasks, subtasks, rate per hour and hours for each key personnel (including subcontractors) who will be working on this project and include their job titles/classification. |
| No miscellaneous or direct/indirect cost (other than labor) should be listed on the Cost By Task. |
&"-,Bold"INSTRUCTIONS&"-,Regular"
GENERAL COST SUMMARY
| CONTRACTOR: | CONTRACTOR NAME |
| GENERAL COST SUMMARY | | |
| PROJECT STAFF - LABOR COSTS | | | | | | |
| LABOR | | HOURS | | RATE | | TOTAL |
| r | | Loaded Rates (indirect costs included in the hourly rate) | | | | | |
| r | | Actual Rates (overhead listed below) | | | | | |
| r | | Other (describe): | | | | | |
| Job Title/Classification: | Program Manager | 0 | @ | $0 | = | $ - 0 |
| | Staff Assistant | 0 | @ | $0 | = | $ - 0 |
| | Technician | 0 | @ | $0 | = | $ - 0 |
| | Clerical | 0 | @ | $0 | = | $ - 0 |
| Sub-Totals: | | 0 | @ | $0 | = | $ - 0 |
| SUBCONTRACTOR(S) | | | | | | |
| LABOR | | HOURS | | RATE | | TOTAL |
| r | | Loaded Rates (indirect costs included in the hourly rate) | | | | | |
| r | | Actual Rates (overhead listed below) | | | | | |
| r | | Other (describe): | | | | | |
| Job Title/Classification: | | 0 | @ | 0 | = | $ - 0 |
| OTHER | | | | | | |
| | Other costs (describe) | 0 | | 0 | | $ - 0 |
| Sub-Totals: | | 0 | | | = | $ - 0 |
| INDIRECT COSTS (OVERHEAD AND FRINGE BENEFITS) | | | | | | |
| | VARIABLE | | RATE | | TOTAL |
| Overhead Rate (general and administrative) | 0 | @ | 0 | = | $ - 0 |
| Fringe Benefits | 0 | @ | 0 | = | $ - 0 |
| Sub-Contractor Overhead Rate (general and administrative) | 0 | @ | 0 | = | $ - 0 |
| SubContractor Fringe Benefits | 0 | @ | 0 | = | $ - 0 |
| Sub-Totals: | | | | | | $ - 0 |
| DIRECT COSTS (OTHER THAN LABOR) | | | | | | |
| Travel Costs | 0 | @ | 0 | = | $ - 0 |
| Insert description(s) including number of trips and summary of costs. | | | | | |
| Equipment and Supplies (Itemized) | 0 | @ | 0 | = | $ - 0 |
| Insert description(s) including reason for product or service to be purchased. | | | | | |
| Other Direct Costs (Itemized) | 0 | @ | 0 | = | $ - 0 |
| Insert description(s) including item summary, and purpose/use | | | | | |
| Sub-Contractor Travel Costs | 0 | @ | 0 | = | $ - 0 |
| Insert description(s) including number of trips and summary of costs. | | | | | |
| Sub-Contractor Equipment and Supplies (Itemized) | 0 | @ | 0 | = | $ - 0 |
| Insert description(s) including reason for product or service to be purchased. | | | | | |
| Sub-Contractor Other Direct Costs (Itemized) | 0 | @ | 0 | = | $ - 0 |
| Insert description(s) including item summary, and purpose/use | | | | | |
| Sub-Totals: | | | | | | $ - 0 |
TOTAL: $ - 0
GENERAL COST PROPOSAL WORKSHEET
% Breakdown
| Minimum Dollar Amounts as Outlined in Attachment 3, Exhibit A - Section F | | | | | | |
| Project Staff - Labor Costs | Subcontractor(s) Labor | Indirect Costs | Direct Costs | Total $ | Percentage |
| Task 1: Trusted Messenger Network Engagement of 25% ($150,000) | | | | | $ - 0 | ERROR:#DIV/0! |
| Task 2: Alumni Recruitment Champion Activation of 30% ($180,000) | | | | | $ - 0 | ERROR:#DIV/0! |
| Task 3: Creative Asset Production and Distribution of 33% ($200,000) | | | | | $ - 0 | ERROR:#DIV/0! |
| Task 4: Project Manager, Evaluation & Performance Reporting of 12% ($70,000) | | | | | $ - 0 | ERROR:#DIV/0! |
| Note: Please reference cells used in your formulas. | | | | | | |
| Subcontractor(s) Percentage Breakdown | | | | | | |
| Subcontractor(s) Name | Subcontractor(s) Labor | Indirect Costs | Direct Costs | Total $ | Percentage | |
| | | | $ - 0 | ERROR:#DIV/0! | |
| | | | $ - 0 | ERROR:#DIV/0! | |
| | | | $ - 0 | ERROR:#DIV/0! | |
Note: Please note if the subcontractor is a SB/DVBE. Reference cells used in your formulas. Otherwise, leave blank if no subcontractors.
| Prime Percentage Breakdown | | | | | |
| Prime Contractor Name | Project Staff - Labor Costs | Indirect Costs | Direct Costs | Total $ | Percentage |
| | | | $ - 0 | ERROR:#DIV/0! |
Note: Please note if you, the prime, is a SB/DVBE. Reference cells used in your formulas.
COST BY TASK
| CONTRACTOR COST SHEET | | | |
| CONTRACTOR: | CONTRACTOR NAME | |
| | | NOTE: FOR CONSULTANT HOURLY RATES, USE FULLY BURDENED RATE. SEE GENERAL COST WORKSHEET |
| PRIME CONTRACTOR | | | SUBCONTRACTOR | | | SUBCONTRACTOR | | | TOTAL COST - ALL CONSULTANTS |
| Name | STAFF X (NAME) | STAFF X (NAME) | Total Cost ($$) | STAFF X (NAME) | STAFF X (NAME) | Total Cost ($$) | STAFF X (NAME) | STAFF X (NAME) | Total Cost ($$) | |
| Title | Job Title/Classification | Job Title/Classification | | Job Title/Classification | Job Title/Classification | | Job Title/Classification | Job Title/Classification | | |
| Rate Per Hour | $0.00 per hour | $0.00 per hour | | $0.00 per hour | $0.00 per hour | | $0.00 per hour | $0.00 per hour | | |
| Hours | Hours | | Hours | Hours | | Hours | Hours | | |
| FILL IN TASKS BELOW | | | | | | | | | | |
| ADD TASKS/SUBTASKS AS NECESSARY | | | | | | | | | | |
| TASK 1 | | | | | | | | | | |
| Task 1.1 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| Task 1.2 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| Task 1.3 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| TOTAL ALL TASK 1 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | $ - 0 |
| TASK 2 | | | | | | | | | | |
| Task 2.1 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| Task 2.2 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| TOTAL ALL TASK 2 | 0 | 0 | $ - 0 | 0 | 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 |
| TASK 3 | | | | | | | | | | |
| Task 3.1 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| Task 3.2 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| Task 3.3 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | |
| TOTAL ALL TASK 3 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | 0 | 0 | $0.00 | $ - 0 |
| TOTAL ALL TASKS | | | | | | | | | | | | |
| 0.00 | 0.00 | $ - 0 | $ - 0 | 0.00 | 0.00 | $ - 0 | $ - 0 | 0.00 | 0.00 | $ - 0 | $ - 0 |
COST BY TASK WORKSHEET