|
City of Everett- Exhibit D Date: 12-Sep-16
<br /> PROJECT HOURS AND BUDGET ESTIMATE
<br /> Direct Salary HOURS FOR EACH TASK Total
<br /> Labor Caregory Rates Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Hours Cost
<br /> Surveying Design Cost Est. Bid/Const P.Mngmt. Misc.
<br /> 1 Principle in Charge-W.Bennett $ 89.18 36 8 6 50 $ 4.459
<br /> 2 Project Manager-P.Martinez $ 75.90 10 60 8 32 40 8 158 $ 11,992
<br /> Project Accountant-L.Hurt $ 30.41 4 40 8 52 $ 1,581
<br /> 3 Design Manager-D.Smith $ 45.77 4 70 16 24 8 122 $ 5,584
<br /> 4 Geotechnical Professional-K.Green $ 82.05 16 8 4 28 $ 2,297
<br /> 5 Civil Professional-R.Beieler $ 76.55 30 16 4 50 $ 3,828
<br /> 6 Structural Design Lead-D.Smith $ 45.77 74 36 10 120 $ 5,492
<br /> 7 Civil Design Lead-S.Sztern $ 50.97 4 56 24 8 92 $ 4,689
<br /> 8 Drafter-A.Hukic $ 36.86 80 8 88 $ 3,244
<br /> 9 Drafter-J.Yang $ 44.83 6 80 8 94 $ 4,214
<br /> 10 Estimating Professional-N.Cavalleri $ 39.75 36 4 40 $ 1,590
<br /> Subcontract Reviewer-C.Yeager $ 57.79 6 0 6 $ 347
<br /> 11 Specification Processing-C.Perrine $ 30.82 85 4 89 $ 2,743
<br /> Total Task Hours 34 587 60 148 80 80 989
<br /> Subtotal Direct Salary Cost(DSC),$ 1,883 29,974 2,771 8,993 4,252 4,187 $ 52,060
<br /> Overhead on DSC(Indirect cost)@ I 154.00% 2,900 46,160 4,267 13,849 6,548 6,448 $ 80,172
<br /> Total Labor Cost,$ 4,783 76.134 7.038 22,842 10,800 10,635 ' t" $ 132,232
<br /> Expenses,$ Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Expenses
<br /> (
<br /> Expense 1/Mileage I 0 150 300 600 600 150 '' S 1.800
<br /> Expense 2/Misc I S
<br /> Total Expenses 150 300 0 600 600 150 $ 1,800
<br /> TOTAL LABOR AND EXP 4,933 76,434 7,038 23,442 11,400 10,785 $ 134,032
<br /> Subconsultant Expenses,$ Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 '>^' " ' Sub Expenses
<br /> SUB 1,Surveyor(Perteet) 8,000 $8,000
<br /> SUB 2 $0
<br /> SUB 3 $0
<br /> SUB 4 $0
<br /> Total Subconsultant Expenses 8,000 0 0 0 0 0 $8,000
<br /> TOTAL SUBCONSULTANTS 8,000 0 0 0 0 0 .:_ SSW
<br /> Subconsultant Admin Mark-up I 10.0% 800 0 0 0 0 0 $800
<br /> Subtotal Cost by Task 20 13,733 76,434 7,038 23,442 11,400 10,785 $ :4 142,8
<br /> FEE(%of Total DSC&Overhead) 20.0% 957 15,227 1,408 4,568 2,160 2,127 $ 26,447
<br /> Federally Funded FEE(%of DSC Only) 0.0% 0 0 0 0 0 0 $ -
<br /> Next Year's Labor Escalation' 3.0% 86 1,370 127 411 194 191 $ 2,379.00
<br /> Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Total
<br /> TOTAL ESTIMATED COST AND FEE,$ 14,776 93,031 8,573 28,421 13,754 13,1031,858
<br /> Next year's labor escalation was calculated assuming 50.0% of the work would be completed next year.
<br /> Enter data in yellow&green shaded cells only. Other formula cells are locked to prevent accidental changes. There is no password protection.
<br /> Overall Project Multiplier I 3.05
<br /> Profit as a%of Direct Salary Cost(DSC) I 50.8%
<br />
|