|
City of Everett-Exhibit B Date: 28-Feb-13
<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 _ Task 7 Task 8 Task 9 Task 10 Task 11 Task 12 Task 20 Hours Cost
<br /> 1 Principal in Charge $ 48.14 2 6 2 12 _ 1 23 $ 1,107
<br /> 2 Project Manager $ 45.03 10 12 6 20 10 12 6 2 6 84 $ 3,783
<br /> 3 QA/QC Principal - - $ -
<br /> 4 QA/QC Professional - $ -
<br /> 5 Supervising Professional - $ -
<br /> 6 Project Engineer $ 41.93 4 90 6 2 244 12 12 12 30 412 $ 17,275
<br /> 7 Civil Engineer $ 26.40 2 80 4 2 264 12 12 32 50 458 $ 12,091
<br /> 8 Structural Engineer $ 41.93 2 8 2 96 4 8 8 128 $ 5,367
<br /> 9 Electrical Engineer $ 46.58 4 2 48 4 6 8 72 $ 3,354
<br /> 10 AutoCAD Drafter $ 34.16 30 10 264 40 344 $ 11,751
<br /> 11 Professional Land Surveyor _$ 38.82 6 _ 8 $ 311
<br /> 12 Field Survey(2 Person Crew) $ 55.90 36 36 $ 2,012
<br /> 13 Graphics - $ - _
<br /> 14 Project Administrator - $ -
<br /> 15 Project Assistant - $ -
<br /> 16 Staff 5 _ _ - $ -
<br /> 17 Staff 4 - $ -
<br /> 18 Staff 3 _ - $ -
<br /> 19 Staff 2 - $ -
<br /> 20 Staff 1 _ - $ -
<br /> Total Task Hours 12 8 224 26 22 58 926 56 30 60 143 0 0 1,565
<br /> Subtotal Direct Salary Cost(DSC),$ 547 304 7,973 1,093 997 2,801 32,930 2,292 1,090 2,053 4,971 0 0 $ 57,051
<br /> Overhead on DSC(Indirect cost)@ 180.00% 985 547 14,351 1,967 1,795 5,042 59,274 4,126 1,962 3,695 8,948 0 0 $ 102,692
<br /> Total Labor Cost,$ . 1,532 851 22,324 3,060 2,792 7,843 92,204 6,418 3,052 5,748 13,919 0 0 4. 159,743;
<br /> Expenses,$ Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 Task 9 Task 10 Task 11 Task 12 Task 20 Expenses
<br /> Milea e 200 300 300 100 $ 900
<br /> Printing 50 300 $ 350
<br /> $
<br /> $ -
<br /> $ -
<br /> $ -
<br /> $ -
<br /> 0 0 0 0 0 0 0 0 0 0 0 0 0 $ -
<br /> Total Expenses 0 0 250 0 0 300 600 0 100 0 0 0 0 $ O
<br /> TOTAL LABOR AND EXP 1,532 851 22,574 3,060 2,792 8,143 92,804 6,418 3,152 5,748 13,919 0 0 $,_ _ IfffiO3'._
<br /> Subconsultant Expenses,$ Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7, Task 8 Task 9 Task 10 Task 11 Task 12 Task 20 Sub Expenses
<br /> Geotechnical Engineer,PanGEO 4,400 $4,400
<br /> Utility Locates,APS 1,100 $1,100
<br /> $0
<br /> $0
<br /> Total Subconsultant Expenses 0 4,400 0 0 0 1,100 0 0 0 0 0 0 0 $5,500
<br /> TOTAL SUBCONSULTANTS 0 4,400 0 0 0 1,100 0 0 0 0 0 0 0
<br /> Subconsultant Admin Mark-up L 10.0% 0 440 0 0 0 110 0 0 0 0 0 0 0 ' $550
<br /> Subtotal Cost by Task 1,532 5,691 22,574 3,060 2,792 9,353 92,804 6,418 3,152 5,748 13,919 0 0 $ 1,67,O43
<br /> FEE(%of Total DSC&Overhead) 15.00% 230 128 3,349 459 419 1,176 13,831 963 458 862 2,088 0 0 $ 23,963
<br /> Federally Funded FEE(%of DSC Only) 0 0 0 0 0 0 0 0 0 0 0 0 0 $ -
<br /> Next Year's Labor Escalation' 3.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 $ -
<br /> Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 Task 9 Task 10 Task 11 Task 12 Task 20 Total
<br /> TOTAL ESTIMATED COST AND FEE,$ 1,762 5,819 25,923 3,519 3,211 10,529 106,635 7,381 3,610 6,610 16,007 0 0 L__,y $ 191,006
<br /> Next year's labor escalation was calculated assuming I 0.0% jof the work would be completed next year.
<br /> Enter data in yellow&green shaded I cells only. Other formula cells are locked to prevent accidental changes. There is no password protection.
<br /> Overall Project Multiplier I 3.22
<br /> Profit as a%of Direct Salary Cost(DSC) I 42.0%1
<br />
|