Attachment_5_Cost_Worksheet_Template.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
RFP Secondary #CV26-105 California Service Corps Recruitment Activation
Solicitation number
0000040925
Issued by
Sacramento County, San Francisco City, California

About this file

This is a Cost Worksheet Template for a state and local contract opportunity requiring proposers to submit detailed cost breakdowns across multiple worksheets. The contract encompasses four primary tasks: Task 1—Trusted Messenger Network Engagement (minimum 25% or $150,000), Task 2—Alumni Recruitment Champion Activation (minimum 30% or $180,000), Task 3—Creative Asset Production and Distribution (minimum 33% or $200,000), and Task 4—Project Manager, Evaluation & Performance Reporting (minimum 12% or $70,000). Proposers must complete three interconnected worksheets: a General Cost Summary Worksheet detailing all labor costs for key personnel and subcontractors with job titles, hourly rates, and projected totals; a Percentage Breakdown Worksheet demonstrating the mathematical allocation of costs across subcontractors and scope of work tasks; and a Cost By Task Worksheet breaking down expenses by individual tasks and subtasks with personnel classifications, hourly rates, and hours worked.

The template requires proposers to identify whether labor rates are fully loaded (with indirect costs included) or actual rates with separate overhead documentation. Proposers must itemize all direct costs including travel, equipment, supplies, and other expenses for both prime contractors and subcontractors. The percentage breakdown section mandates that subcontractor allocations match declarations on the Bidders Declaration form and that proposers justify any inability to meet minimum percentages and dollar amounts by task. The template accommodates multiple subcontractors and requires notation of SB/DVBE status for both subcontractors and prime contractors, with all formulas and cell references documented for verification purposes.

View the file

Other files

File Type Posted
Attachment_1_Proposal_Checklist.docx DOCX document
Attachment_2_Notice_to_Bidders.pdf PDF
Attachment_3_Draft_Standard_Agreement.pdf PDF
Attachment_4_SOW_Template.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

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
LABORHOURSRATETOTAL
rLoaded Rates (indirect costs included in the hourly rate)
rActual Rates (overhead listed below)
rOther (describe):
Job Title/Classification:Program Manager0@$0=$ - 0
Staff Assistant0@$0=$ - 0
Technician0@$0=$ - 0
Clerical0@$0=$ - 0
Sub-Totals:0@$0=$ - 0
SUBCONTRACTOR(S)
LABORHOURSRATETOTAL
rLoaded Rates (indirect costs included in the hourly rate)
rActual Rates (overhead listed below)
rOther (describe):
Job Title/Classification:0@0=$ - 0
OTHER
Other costs (describe)00$ - 0
Sub-Totals:0=$ - 0
INDIRECT COSTS (OVERHEAD AND FRINGE BENEFITS)
VARIABLERATETOTAL
Overhead Rate (general and administrative)0@0=$ - 0
Fringe Benefits0@0=$ - 0
Sub-Contractor Overhead Rate (general and administrative)0@0=$ - 0
SubContractor Fringe Benefits0@0=$ - 0
Sub-Totals:$ - 0
DIRECT COSTS (OTHER THAN LABOR)
Travel Costs0@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 Costs0@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 CostsSubcontractor(s) LaborIndirect CostsDirect CostsTotal $Percentage
Task 1: Trusted Messenger Network Engagement of 25% ($150,000)$ - 0ERROR:#DIV/0!
Task 2: Alumni Recruitment Champion Activation of 30% ($180,000)$ - 0ERROR:#DIV/0!
Task 3: Creative Asset Production and Distribution of 33% ($200,000)$ - 0ERROR:#DIV/0!
Task 4: Project Manager, Evaluation & Performance Reporting of 12% ($70,000)$ - 0ERROR:#DIV/0!
Note: Please reference cells used in your formulas.
Subcontractor(s) Percentage Breakdown
Subcontractor(s) NameSubcontractor(s) LaborIndirect CostsDirect CostsTotal $Percentage
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#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 NameProject Staff - Labor CostsIndirect CostsDirect CostsTotal $Percentage
$ - 0ERROR:#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 CONTRACTORSUBCONTRACTORSUBCONTRACTORTOTAL COST - ALL CONSULTANTS
NameSTAFF X (NAME)STAFF X (NAME)Total Cost ($$)STAFF X (NAME)STAFF X (NAME)Total Cost ($$)STAFF X (NAME)STAFF X (NAME)Total Cost ($$)
TitleJob Title/ClassificationJob Title/ClassificationJob Title/ClassificationJob Title/ClassificationJob Title/ClassificationJob 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
HoursHoursHoursHoursHoursHours
FILL IN TASKS BELOW
ADD TASKS/SUBTASKS AS NECESSARY
TASK 1
Task 1.100$0.0000$0.0000$0.00
Task 1.200$0.0000$0.0000$0.00
Task 1.300$0.0000$0.0000$0.00
TOTAL ALL TASK 100$0.0000$0.0000$0.00$ - 0
TASK 2
Task 2.100$0.0000$0.0000$0.00
Task 2.200$0.0000$0.0000$0.00
TOTAL ALL TASK 200$ - 000$ - 000$ - 0$ - 0
TASK 3
Task 3.100$0.0000$0.0000$0.00
Task 3.200$0.0000$0.0000$0.00
Task 3.300$0.0000$0.0000$0.00
TOTAL ALL TASK 300$0.0000$0.0000$0.00$ - 0
TOTAL ALL TASKS
0.000.00$ - 0$ - 00.000.00$ - 0$ - 00.000.00$ - 0$ - 0

COST BY TASK WORKSHEET

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