|
Date: 17-Mar-23HOURS FOR EACH TASK (Whole Hours Only)Task 1 Task 1 Task 1 Task 2 Task 2 Task 2 Task 2 Task 3 Task 3 Task 3 Task 3 Task 3 Task 3 Task 4 Task 5 Task 5 Task 6Cost1.1 1.2 1.3 2.1 2.2 2.3 2.4 3.1 3.2 3.3 3.4 3.5 3.6 4.0 5.1 5.21Sr. PIC/Sr. PM Civil (Gaston)100.35$ 44 401$ 2Civil Engineer X (Cole)68.56$ 2242166484642086432236 16,180$ 3Civil Engineer VII (Ho)55.79$ 1641252164841483681216408 22,762$ 4Scientist V (Gray)57.51$ 12416 920$ 5Engineering Designer III (Streiff)35.34$ 24128242468116281612332 11,733$ 6Engineering Tech IV (Kayanda)33.00$ 416832401248124 4,092$ 7Project Coordinator I (Hazelquist)43.00$ 1212 516$ 8Project Admin Assist (Tengbom)33.50$ 424241264 2,144$ 9PIC/PLS Sr. Manager (Yamashita)83.82$ 3030 2,515$ 10Survey Crew Chief III (Johnson)48.45$ 236236 11,434$ 11Survey Office Technician IV (Rusch)42.80$ 119119 5,093$ 12Civil Engineer X (Phengsavath)68.91$ 4824121642881280 5,513$ 13- -$ 14- -$ 15- -$ 16- -$ 17- -$ 18- -$ 19- -$ 20- -$ Total Task Hours46405221085220102363569630723244726000001,661 Subtotal Direct Salary Cost (DSC), $2,15419,8211,0895,2372,2801,37363510,74116,3614,3461,2824,9392,0412,1294,9393,938000083,305$ Overhead on DSC (Indirect cost) @, %175.63%3,78334,8121,9139,1984,0042,4111,11518,86428,7357,6332,2528,6743,5853,7398,6746,9160000146,308$ Total Labor Cost, $5,93754,6333,00214,4356,2843,7841,75029,60545,09611,9793,53413,6135,6265,86813,61310,8540000229,613$ Task 1Task 1Task 1Task 2Task 2Task 2Task 2Task 3Task 3Task 3Task 3Task 3Task 3Task 4Task 5Task 5Task 60001.1 1.2 1.3 2.1 2.2 2.3 2.4 3.1 3.2 3.3 3.4 3.5 3.6 4 5.1 5.2 170 35 35 35 35 35 140 35420$ 250505050250450$ 3-$ 4-$ 5-$ 6-$ 7-$ 8Per Labor Hr. Tech. Charge00000000000000000000-$ Total Expenses, $70350850035508585001402500350000870$ TOTAL LABOR AND EXPENSES6,00754,6683,00214,5206,2843,7841,78529,65545,18112,0643,53413,6135,7666,11813,61310,8890000230,483$ Task 1Task 1Task 1Task 2Task 2Task 2Task 2Task 3Task 3Task 3Task 3Task 3Task 3Task 4Task 5Task 5Task 6000 0 151,399$51,399211,000$11,00036,000$6,0004$05$06$07$08$0TOTAL SUBCONSULTANTS017,00051,39900000000000000000$68,399Subconsultant Admin Mark-up, %5.00%08502,57000000000000000000$3,420Subtotal Cost by Task6,00772,51856,97114,5206,2843,7841,78529,65545,18112,0643,53413,6135,7666,11813,61310,8890000302,302$ Fee/Profit (as % of Total DSC & Overhead)14.30%8497,8134292,0648995412504,2346,4491,7135051,9478058391,9471,552000032,836$ Unanticipated Tasks (Task 6)000000000000000015,00000015,000$ Task 1Task 1Task 1Task 2Task 2Task 2Task 2Task 3Task 3Task 3Task 3Task 3Task 3Task 4Task 5Task 5Task 60001.1 1.2 1.3 2.1 2.2 2.3 2.4 3.1 3.2 3.3 3.4 3.5 3.6 4 5.1 5.2 6,856 80,331 57,400 16,584 7,183 4,325 2,035 33,889 51,630 13,777 4,039 15,560 6,571 6,957 15,560 12,441 15,000 0 0 0 350,138$ * Next year's labor escalation was calculated assuming0.00%of the work would be completed next year. Enter data in yellow & green shadedcells only. Other formula cells are locked to prevent accidental changes. There is no password protection.Overall Project Multiplier3.15Fee/Profit as a % of DSC Only39.42%TotalSub ExpensesExpensesTotal HoursMileagePrinting/ReprographicExpenseExpenseExpenseExpenseExpenseGeoEngineers (Geotechnical Engineering) APS (Utility Locate) subconsultantTCP (Traffic Control ) subconsultantSubconsultantCITY OF EVERETT - EXHIBIT B-1PROJECT HOURS, EXPENSES AND FEE ESTIMATE TOTAL ESTIMATED COST AND FEE, $Labor CategoryDirect Salary Hourly Rates, ($$.CC)Expenses, $Subconsultant Expenses, $SubconsultantSubconsultantSubconsultantSubconsultantS:\1Common\UTILITY PROJECTS\UP 3814 WATER MAIN REPLACEMENT Y\100 Project Management\110 Consulting Contracts\Everett Exhibit B - Consultant Fee Estimate_Water Replacement Y_032823V 2.03/28/2023
|