|
s
<br /> CITY OF EVERETT-EXHIBIT B-COORDINATION OF SR07 AND SROB CSO CONTROL AND SEWER"O"PROJECT
<br /> PROJECT HOURS,EXPENSES AND FEE ESTIMATE Dated 3 Ocl-18
<br /> HOURS FOR EACH TASK(Whole Howe Only)
<br /> Direct Salary Task 1 Task 2 Task 3 Task 4 Task 6 Task 6 Task 7 Tasl.8 Cost
<br /> Labor Category Hourly Rotas,
<br /> Project Total
<br /> ($$.CC) Management and Hours
<br /> Hydraulic
<br /> OA/OC Flow Monitoring Model Calibration Analysls/Modeling Additional Services
<br /> 1 Principal In Charge/Contract Manager(J.Gross) $ 79.00 8 0
<br /> 2 Project Manager(P.Cunningham) $ 58.00 0 0 0 0 8 $ 632
<br /> 3 Project Engineer(S.Palmerton) 24 8 40 140 0 0
<br /> 4 OA $ 38.00 0 8 40 240 0 212 $ 12,298
<br /> 5 Engineer 0 328 $ 12,484
<br /> 6 Electrical Engineer $ -
<br /> 7 Senior Professional,Road Design - $
<br /> 8 Professional,Road Design - -
<br /> 9 Road Design - $ -
<br /> 10 Structural Engineer - $ -
<br /> 11 Hydraulic Modeler(D.Harms) - 6 -
<br /> 12 Cost Estimator $ 74.50 40 2 16 40 0 - $
<br /> 13 Cost Estimator OA _ 0 98 $ 7,301
<br /> - $
<br /> 14 GIS(C.Tolentino) $ 39.00 0 0 0 S
<br /> 15 Protect Administrator(U.Pierson) $ 40.0090 40 9 1,3-
<br /> 20
<br /> 8 9
<br /> 16 CADD Manager 0 0 0 0 8 S 320
<br /> 17 Clerical(S.SIOerman) $ 35.00 1g 0 $
<br /> 18 Slag 0 - $ 1,120
<br /> 19 Staff 16 0 0 32
<br /> 20 Staff -
<br /> - $
<br /> Total Task Hours $ -
<br /> 90 is 138 476 0 0 $
<br /> Subtotal Direct Salary Cost(DSC),$ 5,884 917 fi,1360 0 728
<br /> Overhead on DSC(Indirect cost)©,% 22,340 0 0 0 5 $ 34,390
<br /> 162.27% 8,880 1,386 9,977 34,017 0 g 0
<br /> Tolallidsor CoaLS 14,844 2,313 18,629 5
<br /> 68,357 0 0 0 0
<br /> Expenses,$ Tack 1 Task 2 Tack 3 Tack 4 Task 6 Tack 6 Their 7 Task s
<br /> Management end Flew Monitoring Model Calibration AnelysidModeling Additional Servlcss Expanses
<br /> 1 Relnbursable Expenses 266 260
<br /> 100 100 10,OD0 $ 10,700
<br /> N 2 Communication Charge(3%of labor)
<br /> 3 Expense 445 69 496 1,576
<br /> 4 Expense $$
<br /> 2,584
<br /> ' 5 Expense $
<br /> 6 Expense $ -
<br /> 7 Expense $ -
<br /> -
<br /> E
<br /> 8 Per Labor Hr.Tech.Charge
<br /> -I 0 0 0 S
<br /> Iola!Expanses,$ 0 0 0 0 0 $ -
<br /> TOTAL LABOR AND EXPENSES 696 319 696 1,875 10,000 0 0 0 1$ 19,2-
<br /> 89
<br /> 15,639 2,832 17,124 68,032 10,000 0 0
<br /> 8ubconsulianl Expanses,$ Tashi Tech 2 Tech 3 Task., Task $L7.=-.g11A3,3YX
<br /> Task 6 Task B Task 7 Task 8 .-
<br /> 1 Subconsullanl(ADS) ;Suh Expenses
<br /> 2 Subconsullant 56,277
<br /> 3 Suhconsultant _ $68,2$5
<br /> 4 Subconsullanl 80
<br /> 6 Subconsullanl _ _ - $0
<br /> 6 Subconsullanl SO
<br /> 7 Subconsullanl $6
<br /> 8 Subconsullenl _ _ $0
<br /> $0
<br /> TOTAL BUBCONBULTANTS
<br /> 9 58,277 $0
<br /> Suboonaullent Atlmin Mark-up,% 0 5 0 0 0 800,577
<br /> Subtotal Cost by Task I 5.00% 0 2814 0 0 0
<br /> 15,639 83,823 17,124 0 0 $2,914
<br /> FexdProflt(as%ofTotel DSC$Overhead) 1 12.00% 68,032 10,00 0 0 0 ,r,S.. 16,61 B
<br /> 805
<br /> Next Years Labor Escalation' I _ 1,781 278 1,983 8,783 0 0 D $ 11,815
<br /> 3.00% 299 47 333 1,136 0 0 0 $ 1,816
<br /> Task 1 Task2 Task 3 Task 4 Tek 8 Task Task2 Task
<br /> TOTAL E87IMATED COOT AND FEE,$ Management and Flow Monitoring Modal Calibration Anslysia/Modaling Additional Sarvloe Total
<br /> 17,616 64,148 16,440 65,831 10,000 5 0 5 _
<br /> Next year's labor escalation was calculated assuming I 60.00Nof the work would be completed next year.
<br /> Enter data In yellow&green shaded I cells only.Other formula cells are looked to prevent accidental changes.There Is no password protection.
<br /> I Overall Project Multiplier I 2.83
<br /> Fee/Proft as a%or 080 Only I 3027%3
<br /> •
<br /> 5x\Projects\Everett\Sewer 0 Modeling\Project Management\Scope and Budget\Everett Sewer 0 Exhibit 8-Consultant Fee Estlmate.xlsx V 2.0
<br /> 11/20/2014
<br />
|