|
CITY OF EVERETT-EXHIBIT B Date 20-May21
<br /> PROJECT HOURS,EXPENSES AND FEE ESTIMATE
<br /> Direct Salary HOURS FOR EACH TASK(Whets Hours Only)
<br /> Labor Category Hourly Rates, Task 100 Task 201 Task 202 Task 300 Task 310 Task 320 Task 400 Task 500 Task 600 Hie Cost
<br /> (SS.CC)
<br /> 1 Project Manager 5 103.88 58 10 58 56 28 210 $ 21.815
<br /> 2 Protect Accountant S 34 68 40 1 41 S 1.422
<br /> 3 Sr Protect Engineer S 85.18 60' 2 62 $ 5,281
<br /> 4 Protect Engineer 5 40 40 12 16 224 24 20 84 12 396 5 15.998
<br /> 5 Senior Civil Designer S 47.37 200 200 $ 9.474
<br /> 6 Process BIM Designer S 4t 15 2 2 4 $ 165
<br /> 7 Senior Civil Engineer $ 67 67 40 24 64 $ 4,331
<br /> 8 Hydraulic Modeler $ 47.05 80 76 156 $ 7,340
<br /> 9 Cost Estimator S 92 42 40 40 $ 3,697
<br /> 10 DC $ 114 55 38 38 $ 4.353
<br /> 11 Transportation Engineer S 5462 36 36 $ 1,966
<br /> Total Task Hours 136 132 126 580 24 24 142 52 31 1,247
<br /> Subtotal Direct Salary Cost(DSC),$ 11,765 6,956 6,885 31,708 970 970 9,293 4,182 3,114 - 5 75,843
<br /> Overhead on DSC(Indirect cost)@,% I 185.00% 21,765 12,869 12,737 58,660 1,795 1,795 17,192 7,737 5.761 ,,, S 140,311
<br /> Total Labor Cost.S 33,530 19,825.. 19,622 90,368 2,765 2.765 26.485 11,919 8,875 6 216,154
<br /> Task 100 Task 201 Task 202 Task 300 Task 310 Task 320 Task 400 Task 600 Task 600
<br /> Expenses,$ *,.f.`ti Expenses
<br /> Total Expenses.S 0 0 0 0 0 0 0 0 0 _
<br /> TOTAL LABOR ANO EXPENSES 33,530 19,625 19,622 90,368 2,765 2,765 26,485 11,919 8,875 .-, 216,1
<br /> SubcoroultaM Expenses,$ Task0
<br /> 100 Task 201 Task 202 Task 300 Task 310 Task 320 Task 400 Task 500 Task 600 ' Sub Expenses
<br /> A,jOavid Evans Associates 25,000 525,000
<br /> 2 HWA GeoSciences 46.555 $46,555
<br /> L SUBCONSULTAN rS 0 46, 0 0 0
<br /> SuoconswtantAcmin Mark-up,% I 5.00% Cl 0 0 0 1,250 2,328 0 0 0 '' 53.578
<br /> Subtotal Cost by Task 33,530 19,825 19,622 90,368 29,015 51,648 26,485 11,919 8,875 ;, - S 291,2e7
<br /> Fee/Profit(as%of Total DSC&Ovemead) ( 12.78% 4,279 2,530 2,504 11,533 353 353 3,380 1,521 1,133 - $ 27,588
<br /> Next Years Labor Escalation' 3-50( 132 78 77 357 11 11 105 47 35 $ 853
<br /> Task 100 Task 201 Task 202' Task 300 Task 310 Task 320 Task 400 Task 500 Task 600 Total
<br /> TOTAL ESTIMATED COST AND FEE,$
<br /> 37,941 22,433 22,203 102,258 29,379 52,012 29,970 13,487 10,043 I{7" $ 319,726
<br /> Next year's labor escalation was calculated assuming 10.00%of the work would be completed next year
<br /> Enter data in yellow&green shaded( I Icells only Other formula cells are locked to prevent accidental changes There is no password protection
<br /> Ovare"Protect Multiplier I 321 I
<br /> 1 FeefProllt as a%of DSC Only I 35.00%1
<br /> c:\pwworking\nat\d0186158\Everett Exhibit B-Consultant Fee Estimate V 2 0 141120.xlsx V 2.0 11/20/2014
<br />
|