Laserfiche WebLink
Local Assistance Procedures Manual EXHBIT 10-Hi <br />Cost Proposal <br />Exhibit 10-H Cost Proposal <br />Actual Cost -Plus -Fixed Fee or hump Simi (Firm Fixed Price) contracts <br />(Calculations for Anticipated Salary Increases) <br />Consultant Kimley-Horn and Associates, Inc. Contract No. 18-036 Date 5/15/2018 <br />1. Calculate average hourly rate for Ist Period of the contract (Direct Labor Subtotal divided by total hours) <br />Direct Labor <br />Total Hours Avg Hourly <br />Subt per <br />per Cost Contract Duration <br />Rate <br />Cost Proposal <br />Proposal <br />$ 12,754.44 / <br />306 = $41.68 Period 1 Avg Hourly Rate <br />2. Calculate hourly rate for all periods (Increase the Average hourly rate for a period by proposed escalation %) <br />Avg Hourly <br />Proposed <br />Rate <br />Escalation <br />Period 1 <br />$41.68 <br />+ 5% _ <br />$43.77 <br />Period 2 Avg Hourly Rate <br />Period 2 <br />$43.77 <br />+ 5% = <br />$45.95 <br />Period 3 Avg Hourly Rate <br />Period 3 <br />$45.95 <br />+ 5% = <br />S48.25 <br />Period 4 Avg Hourly Rate <br />Period 4 <br />$48.25 <br />+ 5% _ <br />$50.66 <br />Period 5 Avg Hourly Rate <br />3. Calculate estimated hours per year (Multiply estimate % each period by total hours) <br />Estimated % <br />Total Hours <br />Total Hours <br />Completed Each <br />per Cost <br />per Period <br />Period <br />Proposal <br />Period 1 <br />100,00% * <br />306 <br />306 <br />Estimated Hours Period I <br />Period 2 <br />0.00% * <br />306 <br />= 0 <br />Estimated Hours Period 2 <br />Period 3 <br />0.00% * <br />306 <br />= 0 <br />Estimated Hours Period 3 <br />Period 4 <br />0.00% * <br />306 <br />= 0 <br />Estimated Hours Period 4 <br />Period 5 <br />0.00% * <br />306 <br />= 0 <br />Estimated Hours Period 5 <br />Total <br />100% <br />Total <br />= 306 <br />4. Calculate Total Costs including Escalation (multiply average hourly rate by the number of hours) <br />Avg Hourly Estimated <br />Rate Hours <br />Cost <br />(catauiated above) (calculated above) <br />Per Period <br />Period 1 $41.68 * 306 = <br />$12,754,44 <br />Estimated Hours Period 1 <br />Period 2 $43.77 * 0 = <br />$0.00 <br />Estimated Hours Period 2 <br />Period 3 $45.95 * 0 = <br />$0.00 <br />Estimated Hours Period 3 <br />Period 4 $48,25 * 0 = <br />$0.00 <br />Estimated Hours Period 4 <br />Period 5, $50,66 * 0 = <br />$0.00 <br />Estimated Hours Period 5 <br />Total Direct Labor Cost with Escalation = <br />$12,754.44 <br />Direct Labor Subtotal before escalation = <br />$12,754.44 <br />Estimated total of Direct Labor Salary Increase = <br />($0.00) <br />Transfer to Page 1 <br />Period I = 7/1/18 through 6/30/19 Period 2 =7/1/19 through 6/30/20 Period 3 = 7/l/20 through 6/30/21 <br />Period 4 = 7/1/21 through 6/30/22 Period 5 = 7/1/22 through 6/30/23 <br />6enslet IS+mtta Anz Regifui2! Transpertafipn Bike Station <br />