|
CITY OF EVERETT-EXHIBIT B Dated 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 Hours Cost
<br /> (MCC) PM Geotech Permit 50% 90% Final Bidding SDC
<br /> 1 Project Manager-Bartle,Brian $83 1 1448 8 10 170 $ 14,173
<br /> 2 Project Manager Eng Sr-Bergstrom,Eric $92 - $ -
<br /> 3 Senior Engineer-Koch,John $86 4 88 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 80 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 QC Lead-Pierson,Greg $77 4 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-Gerges,Hany $100 32 32 $ 3,194
<br /> 13 Senior CAD-Bramlett,Linda $45 40 180 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,688
<br /> 19 Enviro Scientist-Fox,Dangelei $35 64 64 $ 2,218
<br /> 20 QC 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 80 $ 2,706
<br /> 25 QC Civil-Hume,Tim $74 6 66 18 $ 1,338
<br /> 26 QC 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 $38 100 80 60 32 272 $ 10,456
<br /> 30 CAD-Eldredge,David $45 - $ -
<br /> 31 QC Structural-Zahller,David $64 10 66 22 $ 1,413
<br /> 32 CAD Elec-Pilapil,Edwin $43 160 160 160 480 $ 20,736
<br /> 33 QC Permitting-Kawamoto,Karissa $69 25 25 $ 1,735
<br /> 34 Enviro Scientist/GIS-Dalzell,Maki $40 216 216 $ 8,720
<br /> 35 Sr.Architect,QC $53 2 4 44 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 80 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,818 2,478 33,886 72,763 57,791 42,584 3,878 25,792 0 $ 253,990_
<br /> Overhead on DSC(Indirect cost)Q,% 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,S Task 800 Task 900 Task 1000 Task 1100 Task 1200 Task 1300 Task 1400 Task 1500 Task 1600 Expenses
<br /> PM Geotech Permit 50% 90% Final Bidding SDC
<br /> 1 91 Miscellaneous $ -
<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 I" 3.70 788 133 2,849 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 $ 748,031
<br /> Subconsultant Expenses,S Task800 Task900 Task 1000 Task 1100 Task1200 Task1300 Task1400 Task1500 Task1600 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 00 0 0 49,215 0 $101,751
<br /> Subconsultant Admin Mark-up,% I 5.00% 0 2,627 0 00 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
<br /> TOTAL ESTIMATED COST AND FEE,$ PM Geotech Permit 50% 90% Final Bidding SDC Total
<br /> 47,692 63,064 109,632 235,183 186,506 137,510 12,898 138,027 0 $ 930,512
<br /> 'Next year's labor escalation was calculated assuming 100.00%of the work would be completed next year.
<br /> Enter data in yellow&green shaded' 1 'cells only. Other formula cells are locked to prevent accidental changes. There is no password protection.
<br /> Overall Project Multiplier I 3.14
<br /> Fee/Profit as a%of DSC Only I 28.50%I
<br /> c:\pwworking\sea\d1937935\FEN Phase 2 Budget_2017-06-09_escalation correction.xlsx V 2.0 11/20/2014
<br />
|