|
CITY OF EVERETT-EXHIBIT B-1 Date:' 22-Mar-21
<br /> 2023 COMPREHENSIVE SEWER PLAN
<br /> PROJECT HOURS,EXPENSES AND FEE ESTIMATE
<br /> Direct Salary HOURS FOR EACH TASK(Whole Hours Only) Total
<br /> Labor Category Hourly 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 13 Task 14 Hours Cost
<br /> ($$.CC)
<br /> 1 Principal in Charge/Contract Manager/QA $ 105.77 133 0 5 0 6 0 14 0 6 2 22 2 4 194 $ 20,519
<br /> 2 Project Manager $ 96.15 179 14 24 16 36 6- 148 25 26 10 78 27 35 624 $ 59,998
<br /> 4 Project Engineer $ 59.42 86 14 48 64 42 24 304 12 48 20 234 38 156 1,090 $ 64,768
<br /> 6 Hydraulic Modeler $ 45.06 0 0 16 68 16 32 594 0 0 0 212 0 24 962 $ 43,348
<br /> 8 GIS $ 39.42 0 0 8 0 140 0 88 0 0 0 128 0 84 448 $ 17.660
<br /> 9 Staff Engineer-Modeling Support $ 36.54 0 0 12 160 46 28 714 8' 4 0 244 0 84 1,300 $ 47,502
<br /> 11 Engineer-Programming $ 67.31 0 0 0 20 0 0 40 0 0 0 320 0 0 380 S 25.578
<br /> 12 Admin $ 26.52 2 0 0 0 8 2 16 8 8 2 16 8 164 234 $ 6,206
<br /> 13 Project Administrator $ 36.33 70 0 0 0 0 0 0 0 0 0 0 0 0 70 $ 2,543
<br /> Total Task Hours 470 28 113 328 294 92 1918 53 92 34 1254 75 551 0 5,302
<br /> Subtotal Direct Salary Cost(DSC),$ 38,985 2,178 7,163 15,598 14,724 4,521 93,216 3,621 6,345 2,414 69,209 5,278 24,869 0 S 288.121
<br /> Overhead on DSC(Indirect cost)g,% I 192.82% 75,171 4,200 13,812 30,076 28.391 8,717 179,739 6,982 12,234 4,655 133,449 10,177 47,952 0 $ 555.555
<br /> Total Labor Cost,$ 114,156 6.378 20,975 45,674 43,115 13,238 272,955 10,603 18.579 7,069 202,658 15,455 72,821 0 $ 843,676
<br /> Task 1 Task 2 Task 3 Task 4 Task 6 Task 6 Task 7 Task 8 Task 9 Task 10 Task 11 Task 12 Task 13 Task 14
<br /> Expenses,$ ,
<br /> Expenses
<br /> 1 Mileage 34 156 0 0 0 102 0 34 0 68 34 0 $ 426
<br /> 2 Travel 0 0 0 0 0 1,500 0 0 0 1.000 500 0 $ 3,000
<br /> 3 Reproduction 0 0 0 0 0 0 0 0 0 0 0 9,000 $ 9,000
<br /> 8 Per Labor Hr.Tech,Charge I$ 10,00 4,700 280 1,130 3,280 2,940 920 19,180 530 920 340 12.540 750 5,510 0 $ 53,020
<br /> Tota')Expenses,$ 4,734 436 1,130 3,280 2,940 2,522 19,180 564 920 1,408 13,074 9,750 5,510 0 $ 65,448
<br /> TOTAL LABOR AND EXPENSES 118,890 6,814 22,105 48,954 46,055 15,760 292,135 11,167 19,499 8,477 215,732 25,205 78,331 0 $ 909,124
<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 13 Task 14
<br /> Subconsultant Expenses,$ Sub Expenses
<br /> $0
<br /> 1 FCS Group 29.546 $29,546
<br /> 2 ADS 339,039 S339,039
<br /> 3 Industrial Systems Inc. 43,160 $43,160
<br /> TO AL SUBCONSULTAN-S 0 0 0 339,039 0 43,160 0 0 0 0 29,546 0 0 0 $411,745
<br /> Subconsultant Admin Mark-up.% I 5.00% 0 0 0 16,952 0 2,158 0 0 0 0 1,477 0 0 0 $20,587
<br /> Subtotal Cost by Task 118,890 6,814 22,105 404,945 46,055 61,078 292,135 11,167 19,499 8,477 246,755 25,205 78.331 0 $ 1,341,458
<br /> Fee/Profit(as%of Total DSC&Overhead) 10,00% 11,416 638 2,098 4,567 4,312 1.324 27,296 1,060 1,858 707 20,266 1,546 7,282 0 $ 84,370
<br /> Next Year's Labor Escalation' 3.00% 2,637 147 485 1,055 996 306 6,305 245 429 163 4,681 357 1,682 0 S 19.488
<br /> Contingency(5%) 5.00% 50,000 $ 50,000
<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 13 Task 14 Total
<br /> TOTAL ESTIMATED COST AND FEE,$
<br /> 132,943 7,599 24,688 410,567 51,363 62,708 325,736 12,472 21,786 9,347 271,702 27,108 87,295 50,000 $ 1,495,314
<br /> 'Next year's labor escalation was calculated assuming I 70.00%'of the work would be completed next year.
<br /> Enter data in yellow&green shaded' I Ices only. Other formula cells are locked to prevent accidental changes. There is no password protection.
<br /> Overall Project Multiplier I 3,221
<br /> Fee/Profit as a%of DSC Only I 29,28%I
<br /> G:\PDX_BD\Clients\Everett,WA\2022 Comprehensive Sewer Plan 10-20\Sooping\20210322-Exhibit B Everett Comp Plan Fee Estimate V 2.0 11/20/2014
<br />
|