|
o
<br /> 0
<br /> CITY OF EVERETT-EXHIBIT B Dater 29-Mar-17
<br /> FEN Phase 2 .
<br /> Direct Salary HOURS FOR EACH TASK(Whole Hours Only) Total .
<br /> Labor Category Hourly Rates, Task 800 Task 900 Task 1000 Task 1100 Task 1200 Task 1300 Task 1400 Task 1500 Task 1600 NOW's ;, Cost
<br /> ($$.CC) PM Geotech Permit 50% 90% Final Bidding SDC ,. -„
<br /> 1 Project Manager-Bartle,Brian $83 144 8 8 •10 170 $ 14,173
<br /> 2 Project Manager Eng Sr-Bergstrom,Eric $92 - $ -
<br /> 3 Senior Engineer-Koch,John $86 4 8 B 8 28 $ 2,411
<br /> 4 Proj Engineer-Zahller,Jeff $64 4 20 100 60 40 16 100 340 $ 21,726_
<br /> 5 Staff Engineer-Mende,Beth $34 20 120 60 40 16 BD 336 $ 11,293
<br /> 6 HVAC Engineer-Sutton,Karl $47 12 48 40 12 2 20 134 $ 6,334
<br /> 7 Sr.Structural Eng-Hijzai,Mark $75 16 40 40 40 40 176 $ 13,184
<br /> 8 OC Lead-Pierson,Greg $77 4
<br /> 4 $ 306
<br /> 9 Sr.Permitting-Hutton,Bonnie $64 86 _ 86 $ 5,501
<br /> 10 Enviro Planner-Gifford,Marissa $36 204 204 $ 7,375
<br /> 11 Enviro Scientist-Danielski,Lisa $46 63 63 $ 2,869
<br /> 12 CFD Modeling-Gorges,Hany $100 32 32 $ . 3,194
<br /> 13 Senior CAD-Bramlett,Linda $45 40 • 100 160 50 16 446 $ 19,954
<br /> • 14 Engineer Sanitary Sr-Allaben,Charlie $91 8 4 4 8 24 $ 2,192
<br /> 15 PE Sanitary-Johnson,Ty $53 32 40 24 6 32 134 $ 7,085
<br /> 16 CAD-Auth,Lisa $39 80 80 60 220 $ 8,611
<br /> 17 Elect Engineer-Salmond,Bob $65 60 60 60 8 60 248 $. 16,212
<br /> 18 Senior CAD-Peruchini,John $49 120 80 60 260 $ 12,666
<br /> 19 Enviro Scientist-Fox,Dangelei $35 64 64 $ 2,218•
<br /> 20 OC Electrical-Kirmeyer,Lance $54 8 8 8 24 $ 1,303-
<br /> 21 Cost Estimating-Blackwell,Dan $72 20 20 16 _ 56 $ 4,026
<br /> 22 CFD Modeling-Strain,Adrian $38 80 80 $ 3,072_
<br /> 23 Structural Eng-Prindle,Doug $45 8 60 • 60 60 _ 40 228 $ 10,162
<br /> 24 Staff Engineer-French,Cameron $34 40 24 16 BO $ 2,706
<br /> 25 OC Civil-Hume,Tim $74 6 6 6 18 $ 1,336
<br /> 26 DC Enviro-Witter,Mike $70 10 10 $ 695
<br /> 27 Project Assistantt-Pardee,Katie $34 8 40 32 24 32 136 $ 4,589
<br /> 28 Project Controller-Springer,Amy $36 53 53 $ 1,893
<br /> 29 Staff Engineer-Rastogi,Astha $36 100 80 60 32 272 $ 10,456
<br /> 30 CAD-Eldredge,David $45 • - - $ -
<br /> 31 OC SWctural-Zahller,David $64 10 6 6 22 $ ' 1,413
<br /> 32 CAD Elec-Pilapil,Edwin $43 • 160 160 160 480 $ 20,736
<br /> 33 OC Permitting-Kawamoto,Karissa $69 25 25 $ 1,735
<br /> 34 Enviro Scientist/GIS-Dalzell,Maki $40 216 216 $ 8,720
<br /> 35 Sr.Architect,OC $53 2 4 4 4 14 $ 742
<br /> 36 Architect $45 8 90 80 40 24 242 $ 10,890
<br /> 37 Arch Designer $35 . 40 40 30 - 12 122 $ 4,270
<br /> 38 Elect EIT-Hutson,Maddi $33 60 100 BO 240 $ 7,920
<br /> 39 $
<br /> 40 - $ -
<br /> Total Task Hours 213 ' 36 770 1546 1252 908 72 490 0 5,287
<br /> Subtotal Direct Salary Cost(DSC),$ 14,618 2,478 33,886 72,763 57,791 42,584 3,878 25,792 0 $ 253,990
<br /> Overhead on DSC(Indirect cost)@,% I 185.00% 27,413 4,584 62,689 134,612 106,913 78,780 7,174 47,715 0 $ 469,880
<br /> Total Labor Cost,$ 42,231 7,062 96,575 207,375 164,704 121,364 11,052 73,507 0 $ 723,870
<br /> Expenses,$ Task 800 Task 900 Task 1000 Task 1100 Task 1200 Task 1300 Task 1400 Task 1500 Task 1600 Exp@nses
<br /> PM Geotech Permit 50% 90% Final Bidding SOC
<br /> 1 91 Miscellaneous $ -
<br /> -
<br /> 2 92 Travel(Mileage) 350 200 200 200 150 50 350 $ 1,500
<br /> 3 92 Outside Travel(air,hotel,car,per diem) $ -
<br /> 4 95 Internal Copying 100 350 750 500 500 500 $ 2,700
<br /> 5 Expense Admin(Outside$only at 5%) $ -
<br /> 6 Flight and Hotel 400 - $ 400
<br /> • 7 Expense $ -
<br /> 8 Per Labor Hr.Tech.Charge $ 3.70 788 133 2,649 5,720. 4,632 3,360 266 1,813 0 $ 19,561
<br /> Total Expenses,$ 1,238 133 3,399 7,070 5,332 4,010 • 316 2,663 0 $ 24,161
<br /> TOTAL LABOR AND EXPENSES 43,469 7,195 99,974 214,445 170,036 125,374 11,368 76,170 0 $ 746,031
<br /> Subeonsultant Expenses,$ Task BOD Task 900 Task01000 Task 1100 Task 1200 Task 1300 Task 1400 Task 1500 Task 1600 Sub Expenses
<br /> 1 HWA 52,536 49,215 $101,751
<br /> • 2 Subconsultant $0 •
<br /> 3 Subconsultant $0_
<br /> 4 Subconsultant _ $0
<br /> 5 Subconsultant _ _ $0
<br /> . 6 Subconsultant • $0
<br /> 7 Subconsultant $0
<br /> 8 Subconsultant $0
<br /> TOTAL SUBCONSULTANTS - 0 52,536 0 0 0 0 0 49,215 0 $101,759
<br /> Subconsultant Admin Mark-up,% 5.00% 0 2,627 0 0 0 0 . 0 2,461 0 $5,088
<br /> Subtotal Cost by Task_ 43,469 62,358 99,974 214,445 170,036 125,374 11,368 127,846 0 $ 854,870
<br /> Fee/Profit(as%of Total DSC&Overhead) 10.00% 4,223 706 9,658 20,738 16,470 12,136 1,105 7,351 0 $ 72,387
<br /> Next Year's Labor Escalation* 3.50% 425 2,830 0 $ 3,255
<br /> Task 800 Task 900 Task 1000 Task 1100 Task 1200 Task 1300 Task 1400 Task 1500 Task 1600 Total
<br /> TOTAL ESTIMATED COST AND FEE,$ PM Geotech Permit 50% 90% Final Bidding SPC
<br /> 47,692 63,064 109,632 235,183 186,506 137,510 12,898 138,027 0 6 930,512
<br /> *Next year's labor escalation was calculated assuming I 100.00%lof the work would be completed next year. _
<br /> Enter data in yellow&green shaded I I 'cells only.Other formula cells are locked to prevent accidental changes.There is no password protection.
<br /> Overall Project Multiplier 1 3.14'
<br /> ' Fee/Profit as a%of DSC Only I 28.50%'
<br /> • 77
<br /> c:\owworkine\sea\d1937935\FEN Phase 2 Budget_2017-06-09_escalation correction.xlsx V 2.0 • 11/20/2014
<br />
|