Water Main Replacement "Y" Improvements - Amendment 2, Prepare I-5 Bridge Segment as separate Phase2 Project
<br />Date: 30-May-24
<br />HOURS FOR EACH TASK (Whole Hours Only)
<br />Task 600 Task 600 Task 600 Task 600 Task 600 Task 800 Task 800 Task 800 Cost
<br />600-001 600-002 600-003 600-004 600-005 800-001 800-002 800-003
<br />1 Sr. PIC/Sr. PM Civil (Gaston) 100.35$ - -$
<br />2 Civil Engineer X (Cole) 68.56$ 2 4 8 16 4 4 4 16 58 3,976$
<br />3 Civil Engineer VII (Ho) 55.79$ 4 2 24 24 8 36 12 110 6,137$
<br />4 Civil Engineer X - Structural (Doherty) 68.58$ 2 4 12 8 12 4 12 54 3,703$
<br />5 Engineering Designer IV (O'Connell)39.68$ 8 24 24 4 12 12 84 3,333$
<br />6 Engineering Tech IV (Kayanda) 33.00$ 8 4 8 2 4 26 858$
<br />7 Project Coordinator I (Hazelquist) 43.00$ 6 6 258$
<br />8 Project Admin Assist (Tengbom) 33.50$ 8 4 8 20 670$
<br />9 PIC/PLS Sr. Manager (Yamashita) 83.82$ - -$
<br />10 Survey Crew Chief III (Johnson)48.45$ - -$
<br />11 Survey Office Technician IV (Rusch) 42.80$ - -$
<br />12 Civil Engineer X (Phengsavath) 68.91$ 4 2 6 413$
<br />13 - -$
<br />14 - -$
<br />15 - -$
<br />16 - -$
<br />17 - -$
<br />18 - -$
<br />19 - -$
<br />20 - -$
<br />Total Task Hours 0 24 18 76 92 30 62 40 22 364
<br />Subtotal Direct Salary Cost (DSC), $0 1,079 928 3,929 4,745 1,768 3,303 2,243 1,355 19,350$
<br />Overhead on DSC (Indirect cost) @, %175.63%0 1,895 1,630 6,901 8,334 3,105 5,801 3,939 2,380 33,985$
<br />Total Labor Cost, $0 2,974 2,558 10,830 13,079 4,873 9,104 6,182 3,735 53,335$
<br />0 Task 600 Task 600 Task 600 Task 600 Task 600 Task 800 Task 800 Task 800
<br /> 600-001 600-002 600-003 600-004 600-005 800-001 800-002 800-003
<br />1 100 250 350$
<br />2 -$
<br />3 -$
<br />4 -$
<br />5 -$
<br />6 -$
<br />7 -$
<br />8 Per Labor Hr. Tech. Charge 0 0 0 0 0 0 0 0 0 -$
<br />Total Expenses, $0 0 0 0 100 0 0 250 0 350$
<br />TOTAL LABOR AND EXPENSES 0 2,974 2,558 10,830 13,179 4,873 9,104 6,432 3,735 53,685$
<br />0 Task 600 Task 600 Task 600 Task 600 Task 600 Task 800 Task 800 Task 800
<br /> 600-001 600-002 600-003 600-004 600-005 800-001 800-002 800-003
<br />1 $0
<br />2 $0
<br />3 $0
<br />4 $0
<br />5 $0
<br />6 $0
<br />7 $0
<br />8 $0
<br />TOTAL SUBCONSULTANTS 0 0 0 0 0 0 0 0 $0
<br />Subconsultant Admin Mark-up, %5.00%0 0 0 0 0 0 0 0 0 $0
<br />Subtotal Cost by Task 0 2,974 2,558 10,830 13,179 4,873 9,104 6,432 3,735 53,685$
<br />Fee/Profit (as % of Total DSC & Overhead)14.30%0 425 366 1,549 1,870 697 1,302 884 534 7,627$
<br />Unanticipated Tasks 0 0 0 0 0 0 0 0 -$
<br />0 Task 600 Task 600 Task 600 Task 600 Task 600 Task 800 Task 800 Task 800
<br /> 600-001 600-002 600-003 600-004 600-005 800-001 800-002 800-003
<br />0 3,399 2,924 12,379 15,049 5,570 10,406 7,316 4,269 61,312$
<br />* Next year's labor escalation was calculated assuming 0.00%
<br />Enter data in yellow & green shaded
<br />Overall Project Multiplier 3.15
<br />Fee/Profit as a % of DSC Only 39.42%
<br />Total
<br />Sub Expenses
<br />Expenses
<br />Total
<br />Hours
<br />Mileage
<br />Expense
<br />Expense
<br />Expense
<br />Expense
<br />Expense
<br />Expense
<br />Subconsultant
<br />Subconsultant
<br />Subconsultant
<br />Subconsultant
<br />CITY OF EVERETT - EXHIBIT B
<br />PROJECT HOURS, EXPENSES AND FEE ESTIMATE
<br />
<br />TOTAL ESTIMATED COST AND FEE, $
<br />Labor Category
<br />Direct Salary
<br />Hourly Rates,
<br />($$.CC)
<br />Expenses, $
<br />Subconsultant Expenses, $
<br />Subconsultant
<br />Subconsultant
<br />Subconsultant
<br />Subconsultant
<br />O:\PROJECT\21000\21001A\09 Corporate\Contracts\Amendments\Amend2_Ph2 PS&E and Constr Support\Water Y Amend 2_Phase 2 PSE Docs - Consultant Fee Estimate_053024.xlsxV 2.0 11/20/2014
|