Cost_Proposal_Form_B.xlsx

B0_Instructions

hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is 155.00% % of budget in Current Year (CY) 20.00% Accepted Overhead hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is

hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is 0.00% % of budget in CY+1 60.00% FCCM hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is 0.00% % of budget in CY+1 60.00% FCCM hwym04o: Check with the ODOT Procurement Office if unsure what the current accepted rate is

TOTAL Non-Contingency + Contingency 5 0 0 0 0 0 0 0 0 516 $ 521 $ 157 $ 235 $ - 0 $ 516 $ 908 $ 35 $ - 0 0 0 0 0 0 0 0 0 0 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 0 0 0 0 0 0 0 0 0 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ 521 $ 157 $ 235 $ - 0 $ 516 $ 908 $ 35 $ 944

&"Arial,Bold"&26Instructions for Completing Breakdown of Costs Worksheet

Alameda CTC Breakdown of Costs Worksheet rev 02/11 &"Arial,Italic"Printed &D

Sample Data. Please update when preparing the estimate.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead, FCCM, and escalation at 4.5%.

Hours. Enter estimated hours for each member of the consultant team by sub-task. Hours sum up to the parent task above.

Direct Expenses are detailed in the "ExpenseDetail" tab. The Direct Expenses column (Column Q in this template) should reference the corresponding entry from the ExpenseDetail tab.

At the far right, this spreadsheet calculates the total for each task. Insert/delete tasks as necessary; recommend adding or deleting whole rows to help prevent formulas from becoming invalid. If adding rows, take care to copy applicable formulas to the new row and make sure applicable subtotals and totals incorporate the new rows.

Likewise, when adding/deleting columns.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead, FCCM, and escalation at 4.5%.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead, FCCM, and escalation at 4.5%.

Each sub-task sums up to corresponding parent task using the "Subtotal" function. Also, the totals at the bottom of the Non-Continegency and Contingency sections use the "Subtotal" function. This function was used because it subtotals each task properly and Totals at the bottom without "double counting" all the subtotal lines (which happens if the "Sum" function is used).

Thes cells use the "SUMIF" function to add up the cells in each row that are under the column that matches the titles found in Row 9 (e.g., the "Hours" column sums all the cells that are under columns titled "Hours" in that same row.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead, FCCM, and escalation at 4.5%.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead, FCCM, and escalation at 4.5%.

5. Task Numbers and Names Enter negotiated Scope of Work.

2. Job Classifications Enter Job classifications for each team member. Individuals' names are required.

7. Contingency Tasks/Deliverables Enter proposed Contingency Tasks. Estimated costs for Contingency Tasks must be separate from estimated costs for Non-Contingency Tasks (also called Required Tasks).

3. Direct Salary Rate for Current Year Direct rates must not exceed the maximum direct rates on Consultant's approved Escalated Salary Rate Schedule.

4. Annualized Direct Salary Rate Calculates the direct salary rates with escalation for multi-year contracts. If Consultant uses Negotiated Billing Rates, manually enter the negotiated billing rate instead.

6. Level of Effort Enter estimated number of labor hours for each Job Classification for each subtask (white cells). The task totals will calculate automatically (grey cells).

10. Multipliers for Escalation If current phase of contract covers multiple years, enter the estimated percentage of work to be completed for each year (not applicable for annually renewed contracts).

13. Profit for Escalated Billing Rates Alameda CTC negotiates profit rate with the Prime Consultant. The same profit rate is applied to Prime and all subconsultants under the contract.

11. Multipliers for NBR For Primes or subconsultants using Negotiated Billing Rates, enter zero for ALL the multipliers.

14. Direct Expenses Enter total estimate of direct expenses for each task or subtask. Show detailed breakdown of direct expenses on separate worksheet.

8. Adding rows/columns to spreadsheet A total of 10 tasks are provided. Unhide rows to reveal rows 73-123. Add rows or columns between existing rows/columns and copy applicable formulas to the new row/column. Make sure the new rows/columns are included in the formulas for subtotals and totals.

9. Deleting rows and columns on spreadsheet Recommend hiding rows and columns that are not needed. If deleting rows/columns, make sure applicable subtotals and totals still calculate correctly.

15. Total Profit The total estimated profit can be used as the basis for negotiating the fee on Cost Plus Fixed Fee contracts.

16. Total Cost + Profit The total estimated cost + profit is the basis for the contract's Not To Exceed amount for Time & Materials contracts and Fixed Fee contracts.

1. Contract Numbers and Project Name Info comes from Project Specific Contract or Work Order Contract. For Alameda CTC use only.

12. Multipliers for Escalated Billing Rates Overhead and Fringe rates are specific to the Prime or sub, and is subject to pre-and/or post-award audit by the Alameda CTC.

B1_Breakdown_of_Costs

TOTAL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Alameda CTC Breakdown of Costs Worksheet rev 08/13

&"Arial,Italic"Printed &D

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

These values will be zero if a firm uses Negotiated Billing Rates (NBRs); otherwise, use applicable Overhead and Fringe rates. Escalation not applicable to Annually Renewed contracts.

B2_Cost_Summary Form B2: Breakdown of Costs Summary

PROJECT NAME:

B3_Contact_Info_by_Firm Form B3: Contact Information by Firm

https://www.alamedactc.org/get-involved/contract-equity/ B4_LBCE_Participation