o prepare a fee proposal for the design of 2 miles of roadway given the tasks show in the table above and the example spreadsheet
CE 161 Homework Assignment 3
The ABC Engineering, Inc. has negotiated a scope of work for the design of a roadway project. The
roadway project includes demolition of some existing improvements within the right of way,
construction of sewer, water, and storm drain improvements within the right of way, grading and
compaction of the roadway subgrade, construction of the roadway curb, gutter and sidewalk,
construction of the roadway structural section, and signing and striping of the roadway. ABC has now
been asked to submit a cost proposal for the scope, which is listed below:
Your assignment is to use the following information to prepare a fee proposal for the design of 2 miles
of roadway given the tasks show in the table above and the example spreadsheet. Rename file before
uploading it to Blackboard to LASTNAME_HW4.xlsx
Negotiated Scope of Work
Scope
Project Initiation and Management
Base Mapping Phase
Topographic Mapping Research
Topographic Survey
Process Topographic Information
Utility Research
Right of Way Research
Prepare Base Map
Design Development Phase
Design Kick Off Meeting
Prepare Cover Sheet
Prepare Index sheet
Prepare Demolition Sheets
Prepare Roadway Plan and Profile Sheets
Prepare Roadway Striping and Signing Sheets
Prepare 8” Sanitary Sewer Plan and Profile Sheets
Prepare 12” Water Plana and Profile Sheets
Prepare 18” Storm Drain Plan and Profile Sheets
Prepare Detail Sheet
Prepare Quantity Take Offs
Prepare Cost Estimates
Assemble Deliverables
QA/QC Revisions to Plan Sheets
Assemble Deliverables
Submit Design Development Documents
Design Document Comment Review Meeting
Construction Document Phase
Revise Cover Sheet
Revise Index sheet
Scope
Revise Demolition Plan
Revise Roadway Plan and Profile Sheets
Revise Roadway Striping and Signing Sheets
Revise 8” Sanitary Sewer Plan and Profile Sheets
Revise 12” Water Plana and Profile Sheets
Revise 18” Storm Drain Plan and Profile Sheets
Revise Detail Sheets
Revise Quantity Take Offs
Revise Cost Estimates
Revise Specifications
Prepare Bid Proposal Form
QA/QC Revisions to Plan Sheets
Assemble Deliverables
Submit Design Development Documents
Construction Document Comment Review Meeting
Bid Document Phase
Final Revisions to Plan Sheets
Final Revisions to Specifications
Finalize Quantities
Finalize Bid Proposal form
Finalize Cost Estimate based on Bid Proposal form
Submit Bid Package documents
Pre‐Bid Meeting
Respond to Requests for Information
Prepare Addendums
Design Plan Set Sheets:
Sheet size is 24” high x 36” wide
Design scale is 1” = 30’ horizontal, 1” = 2 feet vertical for all P&P Sheets, sheets coverage is 30 inches per
sheet
Sheets will be single plan and profile
Sheet Count:
1 Cover Sheet
1 Index Sheet
5 Roadway P&Ps are separate plans
5 Roadway Signing and Striping are separate plans
5 Sewer, water, and storm drain P&Ps are on the same set of plans
2 Detail sheets for Roadway construction
1 Detail sheet for Roadway striping
2 Detail sheets for Water, Sewer, and Storm Drain construction
Design Specifications:
Sheet size if 81/2” wide x 11” high
Sheet count is:
Cover Page (template file from client)
Table of Contents (template file from client)
Boiler Plate (provided by client)
Technical Specifications (format provide by client)
Bid Proposal (format provided by client)
Contract Documents (provided by client)
Labor Costs Project Initiation and Management:
Principal Engineer time is 10% of the total sum of the Design Engineer and QA/QC Engineer times for all
phases
Project Manager – 10 hours
Labor, Material, and CAD Costs Base Mapping:
Assume Material Costs are $45.00 for this phase includes markup
Assume that CAD cost = 100% of the surveyor manager labor category time
Assume Survey Crew Material Costs are $6.50/hour of survey crew time
Assume that CAD times = 100% of the design tech labor category times
Assume that CAD times = 40% of an Engineer and PM labor category times
Assume no CAD cost for Principal
Assume CAD cost = 100% of clerical labor category time
Topographic Mapping Research
Survey Manager – 2 hours of research and set up for survey crew
Topographic Survey
Survey Crew – 60 hours
Project Location is 40 miles round trip from survey office
Project Manager ‐ 0.2 hours
Survey Manager 2 hrs
Process Topographic Information
Survey Manager 2 hr
Design Tech 40 hr
PM 0.5 hr
Design Engineer 1.0 hr
QA/QC Engineer 8 hr
Survey Crew 2 hr
Utility Search:
1 Project Manager – 0.5 hours
1 Design Tech – 3 hours
1 QA/QC Engineer – 1 hour
Right of Way Research:
1 Project Manager – 0.5 hours
1 Survey Manager – 3 hours
1 QA/QC Engineer – 1 hour
Prepare Base Map
1 Project Manager – 0.5 hours
1 Survey Manager – 1 hours
2 Design Engineers – 2 hours each
1 QA/QC Engineer – 4 hour
Labor Costs Design Development Phase:
Assume Material Costs are $10.00 per plan sheet includes mark up
Full time is 8 hours per day
Assume that CAD times = 100% of the design tech labor category times
Assume that CAD times = 40% of the Design Engineer , QA/QC Engineer, and PM labor category times
Assume no CAD cost for Principal
Assume CAD cost = 100% of clerical labor category time
Kick off Meeting
Project Manager 3 hrs
Clerical 1 hr
Mileage 20 miles round trip
Prepare Cover Sheet:
Project Manager ‐ 1 hours
1 Design Engineer – 2 hours
1 Design Tech – 6 hours
1 QA/QC Engineer – 1 hour
Prepare Index Sheet:
Project Manager ‐ 0.2 hours
1 Design Engineer – 2 hours
1 Design Tech – 6 hours
1 QA/QC Engineer – 1 hour
Prepare Demolition Sheet
Project Manager ‐ 0.5 hours
1 Design Engineer – 8 hours
1 Design Tech – 16 hours
1 QA/QC Engineer – 4 hour
Prepare Roadway P&P Sheets
Project Manager ‐ 0.5 hours
1 Design Engineer – 8 hours
1 Design Tech – 40 hours
1 QA/QC Engineer – 8 hour
Prepare Roadway Striping Sheets
Project Manager ‐ 0.5 hours
1 Design Engineer – 2 hours
1 Design Tech – 10 hours
1 QA/QC Engineer – 4 hour
Prepare Sewer, Water, and Storm Drain P&P Sheets
Project Manager ‐ 0.5 hours
1 Engineer – 16 hours
1 Design Tech – 80 hours
1 QA/QC Engineer – 8 hour
Prepare Each Detail Sheet:
Project Manager ‐ 0.5 hours
1 Design Engineer – 2 hours
1 Design Tech – 6 hours
1 QA/QC Engineer – 2 hour
Prepare Quantity Takeoff
Project Manager ‐ 0.5 hours
1 Design Engineer – 4 hours
1 QA/QC Engineer – 4 hours
Prepare Cost Estimate
1 Design Engineer – 4 hours
1 QA/QC Engineer – 1 hour
QA/QC Revisions
3 Design Engineers – 4 hour each
2 Design Techs – 16 hours each
Assemble Deliverables and Submit to Client:
Project Manager – 2.5 hours
Clerical – 1 hour
Design Development Deliverables Comment Review Meeting
Project Manager – 2 hours
Client office is 20 miles round trip from office
Labor Costs Construction Document Phase:
Assume Material Costs are $8.00 per plan sheet includes markup
Full time is 8 hours per day
Assume that CAD times = 100% of the design tech labor category times
Assume that CAD times = 30% of the Design Engineer , QA/QC Engineer, and PM labor category times
Assume no CAD cost for Principal
Assume CAD cost = 100% of clerical labor category time
Revise Cover Sheet:
Project Manager ‐ 0.2 hours
1 Design Engineer – 1 hours
1 Design Tech – 2 hours
1 QA/QC Engineer – 1 hour
Revise Index Sheet:
Project Manager ‐ 0.2 hours
1 Design Engineer – 1 hours
1 Design Tech – 2 hours
1 QA/QC Engineer – 1 hour
Revise Demolition Sheet
Project Manager ‐ 0.5 hours
1 Design Engineer – 4 hours
1 Design Tech – 10 hours
1 QA/QC Engineer – 2 hour
Revise Roadway
Project Manager ‐ 0.5 hours
1 Design Engineer – 4 hours
1 Design Tech – 16 hours
1 QA/QC Engineer – 6 hour
Revise Roadway Striping Plan
Project Manager ‐ 0.5 hours
1 Design Engineer – 1 hours
1 Design Tech – 6 hours
1 QA/QC Engineer – 2 hour
Revise Sewer, Water, and Storm Drain all sheets
Project Manager ‐ 0.5 hours
1 Engineer – 8 hours
1 Design Tech – 24 hours
1 QA/QC Engineer – 6 hour
Revise Each Detail Sheet all sheets:
Project Manager ‐ 0.5 hours
1 Design Engineer – 1 hours
1 Design Tech – 2 hours
1 QA/QC Engineer – 1 hour
Revise Quantity Takeoff
1 Design Engineer ‐ .1 hour
1 QA/QC Engineer – 1 hour
Revise Cost Estimate
1 Design Engineer – 1 hour
1 QA/QC Engineer – 1 hour
Prepare Specifications
1 Design Engineer – 16 hours
1 Clerical – 4 hours
1 QA/QC Engineer – 2 hours
$25 costs
Prepare Bid Proposal Form
1 Design Engineer – 2 hours
1 Clerical – 2 hours
1 QA/QC Engineer – 1 hours
QA/QC Revisions
2 Design Engineers – 4 hour each
2 Design Techs – 8 hours each
QA/QC Engineer ‐ 4 hour
Assemble Deliverables and Submit to Client:
Project Manager – 2.5 hours
Clerical – 1 hour
$100 Costs
Construction Document Deliverables Comment Review Meeting
Project Manager – 2 hours
Client office is 20 miles round trip from office
Labor Costs Bid Document Phase:
Assume Material Costs are $6.00 per plan sheet includes markup
Full time is 8 hours per day
Assume that CAD times = 100% of the design tech labor category times
Assume that CAD times = 20% of an Engineer and PM labor category times
Assume no CAD cost for Principal
Assume CAD cost = 100% of clerical labor category time
Finalize Revisions Plan Sheets for all sheets:
Project Manager – 2 hours
2 Design Engineers – 4 hours each
2 Design Techs – 3 hour each
1 QA/QC Engineering 4 hours
Finalize Revisions to Specifications:
2 Design Engineers ‐ 2 hours each
1 Clerical – 3 hours
1 QA/QC Engineer – 2 hours
Finalize Quantities:
2 Design Engineers – 2 hours each
1 QA/QC Engineer – 1 hour
Finalize Bid Proposal Form:
1 Clerical – 1 hour
1 QA/QC Engineer 0.2 hours
Finalize Cost Estimate based on Bid Proposal Form:
1 Design Engineer – 1 hour
1 QA/QC Engineer 0.2 hours
Submit Bid Package Documents:
Project Manager – 2 hours
1 Clerical – 1 hour
1 Design Tech – 1 hour
Attend Pre‐Bid Meeting:
Project Manager – 3 hours
1 Design Engineer – 3 hours
Client office is 20 mile round trip from engineer’s office
Respond to RFIs
Project Manager – 3 hours
1 Design Engineer – 3 hours
Prepare Addendum
Project Manager – 2 hours
2 Design Engineers – 1 hour each
Labor Costs are per the table below:
Category Base Pay
$/hr
Fringe Benefits
$/hr
Health Insurance
$/employee/day
SS, SDI, Unemployment,
Workers Compensation
% of Total Salary
Principal 75.00 7.50 25.33 21.5
Project Manager 62.50 6.25 25.33 21.5
Design Engineer 62.50 6.25 25.33 21.5
Design Tech 56.50 5.65 25.33 21.5
QA/QC Engineer 62.50 6.25 25.33 21.5
Survey Manager 60.25 6.03 25.33 21.5
Party Chief 55.80 5.58 25.33 21.5
Instrument Person 45.20 4.52 25.33 21.5
Clerical 40.00 4.00 25.33 21.5
Equipment or Labor Category Overhead Costs
$/hr
CAD equipment $8.00
Software $3.50
Office overhead‐ Engineer $5.00
Office overhead ‐ Principal $10.00
Office overhead ‐ PM $5.00
Office overhead ‐ Clerical $2.50
Office overhead ‐ Surveyor $5.00
Office overhead – Survey Crew $25.00
Office overhead – Design Tech $3.50
Mileage is $1.00 per mile.