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 />Subtotal Total Hours <br />Per Cost <br />per Cost <br />Proposal <br />Proposal <br />Avg Hourly 5 Year <br />Rate Contract Duration <br />$ 24,211.09 / 471 = $51.40 Year 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 />Year 1 $51.40 <br />+ 5% _ <br />$53.97 <br />Year 2 Avg Hourly Rate <br />Year 2 $53.97 <br />+ 5% _ <br />$56.67 <br />Year 3 Avg Hourly Rate <br />Year 3 $56.67 <br />+ 5% _ <br />$59.51 <br />Year 4 Avg Hourly Rate <br />Year 4 $59.51 <br />+ 5% _ <br />$62.48 <br />Year 5 Avg Hourly Rate <br />3. Calculate estimated hours per year (Multiply estimate % each period by total h, <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 />90.00% <br />* 471 = <br />423.9 <br />Estimated Hours Year 1 <br />Year 2 <br />10.00% <br />* 471 = <br />47.1 <br />Estimated Hours Year 2 <br />Year 3 <br />0.00% <br />* 471 = <br />0 <br />Estimated Hours Year 3 <br />Year 4 <br />0.00% <br />* 471 — <br />0 <br />Estimated Hours Year 4 <br />Year 5 <br />0.00% <br />* 471 = <br />0 <br />Estimated Hours Year 5 <br />Total <br />100% <br />Total = <br />471 <br />4. Calculate Total Costs including Escalation (Multiply average hourly rate by the number of hours) <br />Avg Hourly Estimated <br />Rate Hours <br />(calculated (calculated <br />Cost <br />above) above) <br />Per Period <br />Year 1 $51.40 * 423.9 = <br />$21,789.98 <br />Estimated Hours Year 1 <br />Year 2 $53.97 * 47.1 = <br />$2,542.16 <br />Estimated Hours Year 2 <br />Year 3 $56.67 * 0 = <br />$0.00 <br />Estimated Hours Year 3 <br />Year 4 $59.51 * 0 = <br />$0.00 <br />Estimated Hours Year 4 <br />Year 5 $62.48 * 0 = <br />$0.00 <br />Estimated Hours Year 5 <br />Total Direct Labor Cost with Escalation = <br />$24,332.15 <br />Direct Labor Subtotal before escalation = <br />$24,211.09 <br />Estimated total of Direct Labor Salary = <br />$121.06 <br />Transfer to Page 1 <br />Period 1 = Contract inception through 6/30/21 Period 2 = 7/1/21 through 6/30/22 <br />Period 3 = 7/l/22 through 6/30/23 Period 4 = 7/l/23 through 6/30/24 Period 5 = 7/l/24 through 6/30/25 <br />Page 2 of 3 <br />January 2020 <br />