|
Date: 22-Mar-23
<br />EXHIBIT B
<br />Subtask 210 Subtask 220 Subtask 230 Subtask 240 Subtask 310 Subtask 320 Subtask 410 Subtask 420 Subtask 430 Total
<br />Project
<br />Management
<br />Data Collection &
<br />Review
<br />Supplementary
<br />Surveying
<br />Bypass
<br />Pumping
<br />Analysis 50% Design
<br />Permitting
<br />Assistance
<br />Public
<br />Outreach
<br />Assistance
<br />90% Design
<br />Package Internal QA/QC
<br />Final Design
<br />package
<br />Bid Period
<br />Support Hours Cost
<br />1 Project Manager / Quality Control 95.00$ 40 4 4 16 4 4 4 8 4 8 96 9,120$
<br />2 Quality Control 99.00$ 4 0 8 16 8 36 3,564$
<br />3 Project Engineer 65.00$ 32 10 8 8 24 6 4 16 12 12 132 8,580$
<br />4 Staff Engineer 45.00$ 14 20 12 40 4 4 26 24 12 156 7,020$
<br />5 Bypass Designer 65.00$ 2 40 42 2,730$
<br />6 Hyudraulic Modeling 60.00$ 2 40 42 2,520$
<br />7 CAD/GIS Technician 55.00$ 24 24 8 8 24 24 4 116 6,380$
<br />8 Clerical 35.00$ 2 2 12 8 4 28 980$
<br />Total Task Hours 96 36 44 100 132 22 20 78 16 64 40 648
<br />Subtotal Direct Salary Cost (DSC), $7,226 2,000 2,380 6,692 8,204 1,390 1,260 4,190 1,552 3,560 2,440 40,894$
<br />Overhead on DSC (Indirect cost) @ 180.00%13,007 3,600 4,284 12,046 14,767 2,502 2,268 7,542 2,794 6,408 4,392 73,610$
<br />Total Labor Cost, $20,233 5,600 6,664 18,738 22,971 3,892 3,528 11,732 4,346 9,968 6,832 114,504$
<br />Expenses, $Expenses
<br />Travel expenses 100 100 200 400 200 200 400 1,600$
<br />Per Labor Hr. Tech. Charge 14.00$ 1,344 504 616 1,400 1,848 308 280 1,092 224 896 560 9,072$
<br />Total Expenses 1,444 504 716 1,400 2,048 708 480 1,292 224 896 960 10,672$
<br />TOTAL LABOR AND EXP 21,677 6,104 7,380 20,138 25,019 4,600 4,008 13,024 4,570 10,864 7,792 125,176$
<br />Subconsultant Expenses, $Sub Expenses
<br />Surveying 12,065 $12,065
<br />$0
<br />$0
<br />$0
<br />Total Subconsultant Expenses 0 0 0 0 0 0 $12,065
<br />TOTAL SUBCONSULTANTS 0 0 12,065 0 0 0 0 0 0 0 0 $12,065
<br />Subconsultant Admin Mark-up 5.0%0 0 603 0 0 0 0 0 0 0 0 $603
<br />Subtotal Cost by Task 21,677 6,104 20,048 20,138 25,019 4,600 4,008 13,024 4,570 10,864 7,792 137,844$
<br />FEE (% of Total DSC & Overhead)15.0%3,035 840 1,000 2,811 3,446 584 529 1,760 652 1,495 1,025 17,177$
<br />Federally Funded FEE (% of DSC Only)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 -$
<br />Total
<br />24,712 6,944 21,048 22,949 28,465 5,184 4,537 14,784 5,222 12,359 8,817 155,021$
<br />* Next year's labor escalation was calculated assuming 0.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 - 20th Street Sewer Rehabilitation Project
<br />PROJECT HOURS AND BUDGET ESTIMATE
<br />2.8
<br />Billing Salary
<br />RatesLabor Category
<br />TOTAL ESTIMATED COST $
<br />Task 100
<br />Task 200 - Preliminary Design
<br />Task 300 - Ancillary Support
<br />Services Task 400 - Final Design
<br />Task 500
|