A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Attachment B - Amendment #9 COST PROPOSAL and CH2M HILL Labor Rate Proposal FORT COLLINS – LOVELAND MUNICIPAL AIRPORT RUNWAY 15/33 REHABILITATION - AIP 3-08-0023-27
NOTE: Input should be allowed only in highlighted cells!!! NOTE: Enter rates in cells B30:P30
(A)
(B)
(C)
(D)
(A)+(B)+(C)+(D)
% difference Independent Analysis Amount Negotiated/ Approved
Total Summary
Labor Expenses
Travel/Per Diem
Special Services
Amount Requested
Scope Development Project Administration/Coordination Services Pre-Design Phase Stakeholder Involvement Subconsultant - Survey HDS (See Sheet below) Subconsultant - Geotechnical Services (Ground Engineering) Total
$4,192 $4,438 $36,204 $9,032
$53,866
$0 $50 $250 $250 $41,901 $17,915 $60,366
$187.00 $0.00 $187.00 $374.00
$748.00
$0.00
$0.00
$0.00
$4,379 $4,488 $36,641 $9,656 $41,901 $17,915 $114,980
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
17915
22290
Labor Hours Scope Development
Total Hours 462
GG BVH Principal-in-Charge Project Manager 8 101
JT JH AMT MB MS LR DB SW Sr. Engineer - Review Staff Av Engineer 3 Staff Av Engineer 2 Staff Av Engineer 1 Electrical Engineer Drainage Engineer Senior Designer CAD Tech. 4 115 28 85 13 13 12 57
GS Contracts 14
TH Accounting 12
Total 462
Total Hours
Principal-in-Charge $217.00
Project Manager $150.00
Sr. Engineer - Review Staff Av Engineer 3 Staff Av Engineer 2 $176.00 $116.00 $108.00
Staff Av Engineer 1 Electrical Engineer Drainage Engineer $94.00 $137.00 $123.00
Senior Designer $107.00
CAD Tech. $86.00
Contracts $116.00
Accounting $61.00
Total Cost per Item
Scoping Meeting (1 meeting) Consultant Scope Development and Project Schedule Cost Proposal Development Subconsultant Scope Development Owner/Consultant Negotiations Estimated Total Labor Production Copier Postage and Freight Estimated Total Expenses Mileage Estimated Total Travel 39 Total Scope Development
2 16 6 6 1 31
2
2
2 4 2 2 1 11
2 2 4 4 4 0 0 0 0 0 0
4 2
4
6
4
$300.00 $2,094.00 $884.00 $764.00 $150.00 $4,192.00
340 $434.00 $1,650.00 $704.00 $464.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $696.00 $244.00
$0.00 $187.00 $187.00 $4,379.00
Project Administration/Coordination Services
Hours
Principal-in-Charge $217.00
Project Manager $150.00
Sr. Engineer - Review Staff Av Engineer 3 Staff Av Engineer 2 $176.00 $116.00 $108.00
Staff Av Engineer 1 Electrical Engineer Drainage Engineer $94.00 $137.00 $123.00
Senior Designer $107.00
CAD Tech. $86.00
Contracts $116.00
Accounting $61.00
Cost per Item
Program Development Project Budget Setup Internal Kickoff Meeting Monthly Budget Review/Projections Monthly Billing Develop and Maintain Design Schedule Monthly Progress Reports Coordinate Subconsultants Contracts Estimated Total Labor Production Copier Postage and Freight Estimated Total Expenses 56 Total Project Administration/Coordination Services
3 9 6 2 6 3 2 6 37
2
2
1 1 1 2 2 1 2 2 12
4 1 1 1 1 1
4
4 2 4 8
0
3
0
1
1
1
0
1
8
$584.00 $858.00 $706.00 $300.00 $544.00 $382.00 $300.00 $764.00 $4,438.00 $50.00 $50.00 $4,488.00
$434.00
$1,800.00
$0.00
$348.00
$0.00
$94.00
$137.00
$123.00
$0.00
$86.00
$928.00
$488.00
Pre-Design Phase
Hours
Principal-in-Charge $217.00
Project Manager $150.00
Sr. Engineer - Review Staff Av Engineer 3 Staff Av Engineer 2 $176.00 $116.00 $108.00
Staff Av Engineer 1 Electrical Engineer Drainage Engineer $94.00 $137.00 $123.00
Senior Designer $107.00
CAD Tech. $86.00
Contracts $116.00
Accounting $61.00
Cost per Item
Pre-Design Meeting Site Visit, Investigations and Data Collection Coordinate Geotechnical Investigation and Survey Review Geotechnical Investigation and Survey Prepare Analysis of Runway Phasing Options Prepare Pavement Design Prepare Preliminary Layout Drawings Prepare Analysis of Runway Construction Costs Prepare Deliverables Plan in hand review meeting Estimated Total Labor Production Copier Postage and Freight Estimated Total Expenses Mileage Estimated Total Travel 77 Total Pre-Design Phase
10 12 10 20 42 18 150 26 18 18 324
2
2
4
2 4 2 4 10 2 10 4 2 6 46
0
4 4 4 8 14 4 24 6 4 6 78
4 4 4 8 16 12 8 32 6 4 6 76 8 4 8 4 12 48 8 12 12 12 56 0 0
28
340 $868.00 $6,900.00 $0.00 $9,048.00 $3,024.00 $7,144.00 $1,644.00 $1,476.00 $1,284.00 $4,816.00 $0.00 $0.00
$1,140.00 $1,440.00 $1,140.00 $2,392.00 $5,062.00 $2,060.00 $15,648.00 $3,334.00 $1,828.00 $2,160.00 $36,204.00 $200.00 $50.00 $250.00 $187.00 $187.00 $36,641.00
V:\IntraDepartment Shares\City Council\Agenda Items\2009 Agenda Items\08 18 09 CC Agenda Items\ITEM 6D FNL_RW_CH2M Fee Exh B
Page 1 of 2
Prepared by CH2M Hill 8/13/2009
A 1 2 3 4 78 79 80 81 82 83 84 85 86 87 88 89 90 91 93 94 95 96 97 98 99 100 101 102 103 104 105
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Attachment B - Amendment #9 COST PROPOSAL and CH2M HILL Labor Rate Proposal FORT COLLINS – LOVELAND MUNICIPAL AIRPORT RUNWAY 15/33 REHABILITATION - AIP 3-08-0023-27
Principal-in-Charge $217.00 Project Manager $150.00 Sr. Engineer - Review Staff Av Engineer 3 Staff Av Engineer 2 $176.00 $116.00 $108.00 Staff Av Engineer 1 Electrical Engineer Drainage Engineer $94.00 $137.00 $123.00 Senior Designer $107.00 CAD Tech. $86.00 Contracts $116.00 Accounting $61.00 Cost per Item
Stakeholder Involvement
Hours
Update mailing List provided by Airport Schedule and Coordinate Meetings with Stakeholders Prepare Meeting Agendas and Presentations Attend and Conduct two stakeholder meetings Estimated Total Labor Production Copier Postage and Freight Estimated Total Expenses Mileage Estimated Total Travel 92 Total Stakeholder Involvement
2 4 40 24 70
0
2 2 16 12 32
0
2 16 12 30
8 0 8 0 0 0 0 0 0
680 $0.00 $4,800.00 $0.00 $3,480.00 $0.00 $752.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$300.00 $532.00 $5,008.00 $3,192.00 $9,032.00 $200.00 $50.00 $250.00 $374.00 $374.00 $9,656.00
DESIGN SURVEY Summary
Design Survey Totals - Design Survey
(A) (B) (C) (D) (A)+(B)+(C)+(D)
Labor
Expenses
Travel/Per Diem
Special Services
Amount Requested
Independent Analysis
$28,462 $28,462
$13,439 $13,439
$41,901 $41,901
HDS Lead Total Hours $157.00
HDS Tech 2 $106.00
HDS Tech 1 $75.00
0 $76.00
Labor Rates 107 Labor Hours 108 Total Labor
106 109 117 118 119
Total Cost
276
16
110
150
40
$28,462.00
John Brown
Total
Basil Hanson
Jason Smith
Associate Engineer Misc. Total Cost
Design Survey
120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 Hours $157.00 $106.00 $75.00 $76.00 Costs per Item
Project Management and QA/QC Travel Set Temporary Control Points HDS Scanning for RW and TW's Topographic Survey for Turf Areas Set Permanent Monuments Extra Field Work and Survey Register Scans and Create Meshes Incorporate scanns to CAD Estimated Total Labor Total Design Services
16 60 32 64 32 32 16 24 40 316
16 30 16 32 16 16 30 16 32 16 16 16 24 150 $11,250.00 40 40 $3,040.00
16 $2,512.00
110 $11,660.00
$2,512.00 $5,430.00 $2,896.00 $5,792.00 $2,896.00 $2,896.00 $1,200.00 $1,800.00 $3,040.00 $28,462.00 $28,462.00
Survey Expenses
2 1,440 1,680 12 4 6 4 1,000 600 792 1360.8 2400 416 1470 4800 1,000
Total Cost per Item
Postage and Freight (scanner equipment - number of shipments) Mileage - employee regular Federal Rate = 0.55/mile Mileage - Survey Vehicle = 0.81/mile Expendable Tools and Equipment ($200/day) Survey Equipment Use ($104/day) GPS Equipment Use ($245/day) Laser Scanner Rental ($1,200/day) Miscellaneous Survey Expenses 144 Total Outside Expenses
$1,200.00 $792.00 $1,360.80 $2,400.00 $416.00 $1,470.00 $4,800.00 $1,000.00 $13,438.80
V:\IntraDepartment Shares\City Council\Agenda Items\2009 Agenda Items\08 18 09 CC Agenda Items\ITEM 6D FNL_RW_CH2M Fee Exh B
Page 2 of 2
Prepared by CH2M Hill 8/13/2009