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
AZI_1993
CE161HWAssignment3-Alharthy_Abdulaziz.xlsxFee Proposal
| Project Title: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Date: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Prepared by: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Principal | Project | Design | Design | QA/QC | Survey | Survey | Clerical | Materials | CAD | Mileage | Extension | Phase Total | ||||||||||||||||||||||||||||||||||||||||||||||
| Description | Engineer | Manager | Engineer | Tech | Engineer | Manager | Crew | |||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here | Project Initiation and Management | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Enter hours for this job category and task here | Base Mapping Phase | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Topographic Mapping Research | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Hrly Rate from Labor Costs Tab for this category here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put Material Cost Here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put CAD Cost Here |
Home Computer: Home Computer: Put total units of materials here |
Home Computer: Home Computer: Put Mileage Cost Here |
Home Computer: Home Computer: Enter total CAD hours for this task here |
Home Computer: Home Computer: Enter hours for this job category and task here | Topographic Survey | ||||||||||||||||||||||||||||||||||||||||
| Process Topographic Information | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Utility Research | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Right of Way Research | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Prepare Base Map | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Design Development Phase | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Design Kick Off Meeting | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put total mileage here for this task |
Home Computer: Home Computer: Put total units of materials here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: calculate sum of hours for job category times category charge out rate in this cell |
Home Computer: Home Computer: Enter total CAD hours for this task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Sum all costs for each phase heading here |
Home Computer: Home Computer: Put total mileage here for this task |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Sum all costs for each phase heading here |
Home Computer: Home Computer: calculate sum of hours for job category times category charge out rate in this cell. |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put total units of materials here |
Home Computer: Home Computer: Enter total CAD hours for this task here |
Home Computer: Home Computer: Put total mileage here for this task |
Home Computer: Home Computer: Sum all costs for each phase heading here |
Home Computer: Home Computer: calculate sum of hours for job category times category charge out rate in this cell. | 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 Review | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| QA/QC Revisions to Plan Sheets | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Submit Design Development Documents | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Design Document Comment Review Meeting | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Construction Document Phase | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Revise Cover Sheet | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put total units of materials here |
Home Computer: Home Computer: Enter total CAD hours for this task here |
Home Computer: Home Computer: Put total mileage here for this task |
Home Computer: Home Computer: Sum all costs for each phase heading here |
Home Computer: Home Computer: calculate sum of hours for job category times category charge out rate in this cell. | Revise Index sheet | |||||||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Enter hours for this job category and task here |
Home Computer: Home Computer: Put total units of materials here |
Home Computer: Home Computer: Enter total CAD hours for this task here |
Home Computer: Home Computer: Put total mileage here for this task |
Home Computer: Home Computer: Sum all costs for each phase heading here |
Home Computer: Home Computer: calculate sum of hours for job category times category charge out rate in this cell. | 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 Addendum | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home Computer: Home Computer: Sum this column here and compare to Total Estimated Fee. They should be the same number. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 0 | Total Estimated Fee |
Home Computer: Home Computer: Sum all Phase Totals here |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Labor Costs
| Principal | Project Manager | Design Engineer | Design Tech | QA/QC Engr | Survey Mgr | Survey Party Chief | Survey Instrument Person | Clerical | |||||||||||||||||||||||||||||||||||||||||||||||
| $/hr | $/hr | $/hr | $/hr | $/hr | $/hr | $/hr | $/hr | $/hr | |||||||||||||||||||||||||||||||||||||||||||||||
| Base Pay | $75.00 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $62.50 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $62.50 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $56.50 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $62.50 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $60.25 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $55.80 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $45.20 Home Computer: Home Computer: Base pay hourly rate from problem statement table | $40.00 Home Computer: Home Computer: Base pay hourly rate from problem statement table |
||||||||||||||||||||||||||||||||||||||||||||||
| Fringe | $7.50 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Base pay hourly rate from problem statement table | $6.25 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $6.25 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $5.65 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $6.25 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $6.03 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $5.58 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $4.52 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $4.00 Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
|||||||||||||||||||||||||||||||||||||||||||||
| Health | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Base pay hourly rate from problem statement table |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $1.06 Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
||||||||||||||||||||||||||||||||||||||||||||
| Payroll Taxes | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
Home Computer: Home Computer: Base pay hourly rate from problem statement table |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $0.22 Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
|||||||||||||||||||||||||||||||||||||||||||
| Overhead | $10.00 Home Computer: Home Computer: Insert Hourly OH Rate here |
Home Computer: Home Computer: Base pay hourly rate from problem statement table |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $5.00 Home Computer: Home Computer: Insert Hourly OH Rate here |
Home Computer: Home Computer: Base pay hourly rate from problem statement table |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health | $3.50 Home Computer: Home Computer: Insert Hourly OH Rate here | $3.50 Home Computer: Home Computer: Insert Hourly OH Rate here | $25.00 Home Computer: Home Computer: Insert Hourly OH Rate here | $5.00 Home Computer: Home Computer: Insert Hourly OH Rate here | $2.50 Home Computer: Home Computer: Insert Hourly OH Rate here |
||||||||||||||||||||||||||||||||||||||||
| Full Hourly Rate | $93.77 Home Computer: Home Computer: Sum of all hour rates for this worker category |
Home Computer: Home Computer: Base pay hourly rate from problem statement table |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
Home Computer: Home Computer: Insert Hourly OH Rate here | $75.02 Home Computer: Home Computer: Sum of all hour rates for this worker category |
Home Computer: Home Computer: Base pay hourly rate from problem statement table |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
Home Computer: Home Computer: Insert Hourly OH Rate here | $73.52 Home Computer: Home Computer: Sum of all hour rates for this worker category |
Home Computer: Home Computer: Fringe benefit hourly rate from problem statement table |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
Home Computer: Home Computer: Insert Hourly OH Rate here | $66.92 Home Computer: Home Computer: Sum of all hour rates for this worker category |
Home Computer: Home Computer: Health insurance rate converted to hourly rate from problem statement table |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
Home Computer: Home Computer: Insert Hourly OH Rate here |
Home Computer: Home Computer: Sum of all hour rates for this worker category |
Home Computer: Home Computer: Apply payroll taxes rate from problem statement table to sum of Base Pay, Fringe, and Health |
Home Computer: Home Computer: Insert Hourly OH Rate here |
Home Computer: Home Computer: Sum of all hour rates for this worker category |
Home Computer: Home Computer: Insert Hourly OH Rate here |
Home Computer: Home Computer: Sum of all hour rates for this worker category | $55.99 Home Computer: Home Computer: Sum of all hour rates for this worker category | $47.77 Home Computer: Home Computer: Sum of all hour rates for this worker category |
||||||||||||||||||||||||||
| ` | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
