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