Attachment_5_Cost_Worksheet_Template.xlsx

This is a Cost Worksheet Template for a state and local contract opportunity with the State of California Department of Water Resources (DWR) for IFB 10217692 - Phytoplankton Analysis Services. The template is designed for proposers to submit comprehensive cost proposals for phytoplankton identification, enumeration, and measurement services required under Water Right Decision 1641 and DWR special studies. The worksheet structure accommodates labor costs for key personnel across multiple classifications (Program Manager, Staff Assistant, Technician, Clerical), subcontractor costs, and allows for task-based cost breakdowns. Proposers must complete two primary sections: a General Cost Summary Worksheet listing all labor and non-labor costs with associated hourly rates and totals, and a Cost By Task Worksheet that allocates costs across specific project tasks and subtasks.

The General Cost Summary section requires proposers to itemize labor costs with options for loaded rates (indirect costs included) or actual rates with separate overhead calculations, along with sections for indirect costs including overhead and fringe benefits for both prime contractors and subcontractors. Direct costs beyond labor must be itemized and described, including travel, equipment and supplies, and other direct costs, with corresponding justifications. The Cost By Task Worksheet mandates that proposers use fully burdened hourly rates for consultant personnel and break down costs by individual tasks and subtasks, with columns for prime contractor, subcontractor, and total consultant costs. All subcontractor percentages must be shown with mathematical breakdowns rounded to two decimal places, and these percentages must align with the Bidder Declaration form and the General Cost Summary Worksheet totals.