|
Date:10-Nov-23
<br />EXHIBIT B
<br />Task 700 -
<br />Additional
<br />Work Total
<br />Subtasks 101 -
<br />103 & 107 - 109
<br />Monthly PM
<br />Activities
<br />Subtask 104
<br />Project Kickoff
<br />Meeting
<br />Subtask 106
<br />In-house QC
<br />Reviews
<br />Subtask 201
<br />Field
<br />Exploration
<br />Work Planning
<br />Subtask 202
<br />Field
<br />Explorations
<br />Subtask 203
<br />Geotechnical
<br />Engineering
<br />Design
<br />Subtasks 301 -
<br />305
<br />Assessments
<br />Subtasks 306 -
<br />309
<br />Permit
<br />Applications
<br />Subtask 401
<br />Alt. Route
<br />Assessment
<br />Subtask 402
<br />Topographic
<br />Surveying
<br />Subtask 403
<br />Site Visit
<br />Subtask 404
<br />CFD Analysis
<br />Subtask 405
<br />BDR Report
<br />Subtask 501
<br />30 Percent
<br />Submittal
<br />Subtask 502
<br />60 Percent
<br />Submittal
<br />Subtask 503
<br />90 Percent
<br />Submittal
<br />Subtask 504
<br />Issued for
<br />Const.
<br />Subtask 601
<br />Pre-bid
<br />Walkthrough
<br />Subtasks 602
<br />RFIs and
<br />Addenda
<br />Subtask 603
<br />Bid Review
<br />Task 700 -
<br />Unanticipated
<br />Services
<br />Hours Cost
<br />1 Principle-in-Charge 105.00$ 24 4 4 4 3 2 1 42 4,410$
<br />Project Manager 84.00$ 144 8 4 4 2 8 4 12 45 34 22 11 2 20 320 26,880$
<br />Civil QC 95.00$ 40 8 8 56 5,320$
<br />Project Engineer 62.00$ 104 12 12 12 16 16 16 8 8 20 40 120 100 64 32 8 12 4 80 684 42,408$
<br />Civil Staff Engineer 55.00$ 40 136 60 200 196 110 55 12 86 895 49,225$
<br />CFD Modeling Lead 83.00$ 24 8 8 40 3,320$
<br />Structural Engineer Lead/QC 90.00$ 2 36 4 4 16 8 8 4 2 84 7,560$
<br />Structural Engineer 70.00$ 24 60 126 96 32 8 346 24,220$
<br />Electrical / I&C Lead/QC 113.00$ 2 56 4 2 2 66 7,458$
<br />Electrical Engineer 88.00$ 16 20 30 50 24 16 4 160 14,080$
<br />I&C Engineer 88.00$ 16 24 50 40 20 8 4 162 14,256$
<br />Sr. CAD/GIS/Technician 74.00$ 12 24 40 88 59 42 17 8 20 310 22,940$
<br />CAD/GIS/Technician 45.00$ 40 176 149 105 45 20 535 24,075$
<br />Clerical 40.00$ 20 32 22 15 8 16 113 4,520$
<br />Total Task Hours 272 28 132 16 0 20 20 56 18 20 48 208 316 817 805 506 227 8 48 6 242 3,813
<br />Subtotal Direct Salary Cost (DSC), $21,064 2,242 13,368 1,104 0 1,440 1,328 3,192 1,160 1,384 3,984 12,824 21,184 50,764 51,212 31,687 14,173 496 3,260 416 14,390 250,672$
<br />Overhead on DSC (Indirect cost) @ 180.00%37,915 4,036 24,062 1,987 0 2,592 2,390 5,746 2,088 2,491 7,171 23,083 38,131 91,375 92,182 57,037 25,511 893 5,868 749 25,902 451,209$
<br />Total Labor Cost, $58,979 6,278 37,430 3,091 0 4,032 3,718 8,938 3,248 3,875 11,155 35,907 59,315 142,139 143,394 88,724 39,684 1,389 9,128 1,165 40,292 701,881$
<br />Expenses, $Expenses
<br />Travel expenses 575 2,700 500 575 107 4,457$
<br />Per Labor Hr. Tech. Charge 14.70$ 3,998 412 1,940 235 0 294 294 823 265 294 706 3,058 4,645 12,010 11,834 7,438 3,337 118 706 88 3,557 56,052$
<br />Total Expenses 3,998 987 1,940 235 0 294 294 823 265 294 3,406 3,058 4,645 12,010 11,834 7,438 3,837 693 706 88 3,664 60,509$
<br />TOTAL LABOR AND EXP 62,977 7,265 39,370 3,326 0 4,326 4,012 9,761 3,513 4,169 14,561 38,965 63,960 154,149 155,228 96,162 43,521 2,082 9,834 1,253 43,956 762,390$
<br />Subconsultant Expenses, $Sub Expenses
<br />Environmental Permitting 2,500 500 4,400 14,000 65,000 $86,400
<br />Geotechnical 4,230 500 2,250 7,440 33,800 21,600 1,500 $71,320
<br />Surveying 20,000 $20,000
<br />Unauthorized $0
<br />Total Subconsultant Expenses 21,600 14,000 65,000 $177,720
<br />TOTAL SUBCONSULTANTS 6,730 1,000 6,650 7,440 33,800 21,600 14,000 65,000 0 20,000 0 0 0 0 0 0 0 0 1,500 0 0 $177,720
<br />Subconsultant Admin Mark-up 5.0%337 50 333 372 1,690 1,080 700 3,250 0 1,000 0 0 0 0 0 0 0 0 75 0 0 $8,887
<br />Subtotal Cost by Task 70,044 8,315 46,353 11,138 35,490 27,006 18,712 78,011 3,513 25,169 14,561 38,965 63,960 154,149 155,228 96,162 43,521 2,082 11,409 1,253 43,956 948,997$
<br />FEE (% of Total DSC & Overhead)15.0%8,847 942 5,615 464 0 605 558 1,341 487 581 1,673 5,386 8,897 21,321 21,509 13,309 5,953 208 1,369 175 6,044 105,284$
<br />Federally Funded FEE (% of DSC Only)0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -$
<br />Next Year's Labor Escalation*0.0%0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -$
<br />Total
<br />78,891 9,257 51,968 11,602 35,490 27,611 19,270 79,352 4,000 25,750 16,234 44,351 72,857 175,470 176,737 109,471 49,474 2,290 12,778 1,428 50,000 1,054,281$
<br />* Next year's labor escalation was calculated assuming 80.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 3.22
<br />Profit as a % of Direct Salary Cost (DSC)42.0%
<br />City of Everett - WPCF COMBINED CONVEYANCE IMPROVMENTS
<br />PROJECT HOURS AND BUDGET ESTIMATE
<br />2.8
<br />Direct Salary
<br />RatesLabor Category
<br />TOTAL ESTIMATED COST AND FEE, $
<br />Task 100 - Project Management Task 200 - Geotechnical Engr. Services
<br />Task 300 - Environmental
<br />Permitting Services Task 400 - Basis of Design Report Task 500 - Design & Preparation of Documents for Const.Task 600 - Bid Period Services
|