Item 25 - Warner Avenue Protected Bike Lanes ( Grand Avenue to Oak Street)

Home Browse Search

Local Assistance Procedures Manual EXHBIT 10-H1 Cost Proposal Exhibit 10-H1 Cost Proposal Actual Cost -Plus -Fixed Fee or Lump Sum or Firm Fixed Price Contracts (Calculations for Anticipated Salary Increases) 1. Calculate average hourly rate for 1st year of the contract (Direct Labor Subtotal divided by total hours) Direct Labor Total Hours Subtotal per Avg Hourly 5 Year Cost per Cost Rate Contract Duration Proposal Proposal $ 2,002.14 / 39 = $51.34 Year 1 Avg Hourly Rate 2. Calculate hourly rate for all periods (Increase the Average hourly rate for a period by proposed escalation %) Avg Hourly Proposed Rate Escalation Year 1 $51.34 + 4% _ $53.39 Year 2 Avg Hourly Year 2 $53.39 + 4% _ $55.53 Year 3 Avg Hourly Year 3 $55.53 + 4% _ $57.75 Year 4 Avg Hourly Rate Year 4 $57.75 + 4% _ $60.06 Year 5 Avg Hourly Rate 3. Calculate estimated hours per year (Multiply estimate % each period by total hours) Estimated % Total Hours Total Hours Completed per Cost Each Period Proposal per Period Year 1 80.00% * 39 = 31.2 Estimated Hours Year 1 Year 2 20.00% * 39 = 7.8 Estimated Hours Year 2 Year 3 0.00% * 39 = 0 Estimated Hours Year 3 Year 4 0.00% * 39 = 0 Estimated Hours Year 4 Year 5 0.00% * 39 = 0 Estimated Hours Year 5 Total 100% Total = 39 4. Calculate Total Costs including Escalation (Multiply average hourly rate by the number of hours) Avg Hourly Estimated Rate Hours (calculated (calculated Cost above) above) Per Period Year 1 $51.34 * 31.2 = $1,601.71 Estimated Hours Year 1 Year 2 $53.39 * 7.8 = $416.45 Estimated Hours Year 2 Year 3 $55.53 * 0 = $0.00 Estimated Hours Year 3 Year 4 $57.75 * 0 = $0.00 Estimated Hours Year 4 Year 5 $60.06 * 0 = $0.00 Estimated Hours Year 5 Total Direct Labor Cost with Escalation = $2,018.16 Direct Labor Subtotal before escalation = $2,002.14 Estimated total of Direct Labor Salary Increase = $16.02 Transfer to Page 1 Page 2 of 3 January 2020