|
CITY OF EVERETT-EXHIBIT B&C Date:I 20-Jan-17
<br /> PROJECT HOURS,EXPENSES AND FEE ESTIMATE
<br /> HOURS FOR EACH TASK(Whole Hours Only)
<br /> Direct Salary Task 17 Task 18 Task 19 Task 20 Task 21 Task 22 Task 23 Cost
<br /> Total
<br /> Labor Category Hourly Rates, 2017 2018 Hours
<br /> ($$.CC) Construction Construction S.Smith bland Project
<br /> Final Design Support Support Support Management Contingency As-Built Report
<br /> 1 Project Director Matthias M $ 68.871 5 2 8 $ 551.00
<br /> 2 Managing Consultant Luiting V $ 50.43 10 31 39 15 6 101 $ 5,093.00
<br /> 3 Managing Consultant Stamey M $ 47.12 20 15 30 65 $ 3,063.00
<br /> 5 Sr Tech Analyst Fisher Martin $ 55.51 139 30 30 12 15 2 228 $ 12,656.00
<br /> 6 Sr Consult II Stratten D $ 39.02 52 20 28 100 $ 3,902.00
<br /> 9 Assoc Consult 1 Harmon J $ 25.49 4 6 10 $ 255.00
<br /> 10 Assoc Consult 1 Lundstram K $ 38.32 6 6 12 $ 460.00
<br /> 11 Admin Tech Flores Trixia $ 24.25 0 12 12 $ 306.00
<br /> 12 - $ -
<br /> 13 - $ -
<br /> Total Task Hours 232 30 30 31 68 65 80 536
<br /> Subtotal Direct Salary Cost(DSC),$ $11,592.38 $1,665.30 $1,665.30 $1,563.33 $3,268.24 $3,076.30 $3,440.36 $ 26,271.21
<br /> Overhead on DSC(Indirect cost)@,% 187.96% $21,789.04 $3,130.10 $3,130.10 $2,938.44 $6,142.98 $5,782.21 $6,466.50 $ 49,379.37
<br /> Total Labor Cost,$ $33,381.42 $4,795.40 $4,795.40 $4,501.77 $9,411.22 $8,858.51 $9,906.86 $ 75,850.58
<br /> Task 17 Task18 Task19 Task20 Task21 Task22 Task23
<br /> Expenses,$ Expenses
<br /> Construction Support Management Contingency As-Built Report
<br /> 4 Expense mileage $ 370.00 $ 370.00 $ 740.00
<br /> 5 Expense project supplies/disposal charges $150.00 $ 800.00 $ 950.00
<br /> 8 Per Labor Hr.Tech.Charge I $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ - $
<br /> Total Expenses,$ $150.00 $370.00 $370.00 $0.00 $0.00 $0.00 $ 800.00 $ .1,690.00
<br /> TOTAL LABOR AND EXPENSES $33,531.42 $5,165.40 $5,165.40 $4,501.77 $9,411.22 $8,858.51 $ 10,706.86 $ 77,340.55
<br /> Subconsultant Expenses,$ TasOk 17 Task 18 Task 19 Task 20 Task 21 Task 22 TasOk 23 Sub Expenses
<br /> 1 Subconsultant $0.00
<br /> 2 Subconsultant _ -
<br /> _ $0.00
<br /> 3 Subconsultant - $0.00
<br /> 4 Subconsultant $0.00
<br /> 5 Subconsultant $0.00
<br /> 6 Subconsultant $0.00
<br /> 7 Subconsultant $0.00
<br /> 8 Subconsultant $0.00
<br /> TOTAL SUBCONSULTANTS 0 0 0 0 0 0 0 $0.00
<br /> Subconsultant Admin Mark-up,% I 0.00% 0 0 0 0 0 0 0 $0.00
<br /> Subtotal Cost by Task $33,531.42 $5,165.40 $5,165.40 $4,501.77 $9,411.22 $8,858.51 $10,706.86 $77,340.58
<br /> Fee/Profit(as%of DSC Only) r 10.00% $3,338.14 $479.54 $479.54 $450.18 $941.12 $885.85 $990.69 $7,565.06
<br /> Next Year's Labor Escalation' I 3.00% $627.90 $90.20 $90.20 $84.68 $177.03 $166.63 $186.00 $1,422.64
<br /> Task 17 Task 18 Task 19 Task 20 Task 21 Task 22 Task 23
<br /> TOTAL ESTNATED COST AND FEE,$ Construction Support Management Contingency As-Built Report Total
<br /> $37,497.46 $5,735.14 $5,735.14 $5,036.62 $10,529.37 $9,910.99 $ 11,883.55 $ 56,32827
<br /> •Next year's labor escalation was calculated assuming (, 57.00%1of the work would be completed next year.
<br /> Enter data in yellow 8 green shaded I leeks only.Other formula cells are locked to prevent accidental changes.Them is no password protection.
<br /> I Overa9 Project Multiplier J 2.9B
<br /> I Fee/Profit as a%of Total DSC BOwrMiW I 3.47%
<br /> G:\Seattle\PNWProjects\Everett,City
<br /> of\00048.15_12St&D05_designPrmtsWl_ProjectMa nagement\Amd3_FinalDsgConstruction\Eve rett_1C11_012thSt_Ame nd3_Fina IDesignConstruct_ExhB_ClientForm_Rev_01202017
<br />
|