Spreadsheet: 04a75507-024c-40db-a996-b3bfa557d9a4
Sheet: Sheet1

CLIENT: UDOT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | 2007-06-26 00:00:00
Project Number:
Project Name: Example EIS
LABOR |  |  |  | Actual | Adjusted
Name | Position | Code | Hours | Rate | Rate * | Total
Manager 1 | Project Principal | PJM33 | 0 | 10 | 10.5 | 0
Manager 2 | Project Manager | PJM22 | 0 | 10 | 10.5 | 0
Manager 3 | [NAME] | [NAME] | 0 | 10 | 10.5 | 0
Manager 4 | Engineering Lead/Traffic | PMJ21 | 0 | 10 | 10.5 | 0
PI Manager | Pub. Invol./CI Assess | MMS02 | 0 | 10 | 10.5 | 0
Engineer 1 | Roadway Design Engr. | PMJ12 | 0 | 10 | 10.5 | 0
Engineer 2 | Roadway Designer | EHI10 | 0 | 10 | 10.5 | 0
Engineer 3 | Roadway Designer | EHI10 | 0 | 10 | 10.5 | 0
NEPA 1 | QC/QA Environmental | PJM32 | 0 | 10 | 10.5 | 0
Engineer 4 | QC/QA Design | PJM15 | 0 | 10 | 10.5 | 0
ENV Specialist 1 | NEPA coord/(4)f/Farmland | SEN20 | 0 | 10 | 10.5 | 0
ENV Specialist 2 | Floodplain & Haz Waste | SEN20 | 0 | 10 | 10.5 | 0
Water 1 | Water Qual/Hydrau/Hyd | EWR20 | 0 | 10 | 10.5 | 0
Water 2 | Hydraulics/Hydrology | EWR10 | 0 | 10 | 10.5 | 0
Water 3 | QC/QA Water Resources | EWR30 | 0 | 10 | 10.5 | 0
ENV Specialist 3 | Noise/Air Quality | SEN30 | 0 | 10 | 10.5 | 0
ENV Specialist 4 | Socioeconomics | PLE02 | 0 | 10 | 10.5 | 0
ENV Specialist 5 | Socioeconomics | MGC11 | 0 | 10 | 10.5 | 0
ENV Specialist 6 | Cum/Indirect Impacts | PLE03 | 0 | 10 | 10.5 | 0
Biolgoist 1 | Biology/Wetlands | SEI30 | 0 | 10 | 10.5 | 0
Biologist 2 | Biology/Wetlands | SEN20 | 0 | 10 | 10.5 | 0
ENV Specialist 1 | Land Use/Visual | SEN20 | 0 | 10 | 10.5 | 0
GIS 1 | GIS/Ped & Bike Trails | SGS10 | 0 | 10 | 10.5 | 0
PI 1 | Public Involve. | MMS01 | 0 | 10 | 10.5 | 0
Tech Editor 1 | Technical Editor | [NAME] | 0 | 10 | 10.5 | 0
CADD 1 | [NAME] | CGE01 | 0 | 10 | 10.5 | 0
Account 1 | Accountant | ACT03 | 0 | 10 | 10.5 | 0
Translation 1 | Spanish/Eng. Translation | PLT20 | 0 | 10 | 10.5 | 0
Admin 1 | Receptionist Admin | ADM01 | 0 | 10 | 10.5 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
*Rate adjustment - Explain in detail here
Subtotal |  |  | 0 |  |  | 0
Overhead | 1.6 |  |  |  |  | 0
Direct Labor plus Overhead |  |  |  |  |  | 0
Fee | 0.12 |  |  |  |  | 0
Total Labor Cost |  |  |  |  |  | 0
DIRECT EXPENSES |  |  |  |  |  | Total Cost
Miscellaneous |  | Postage, Freight, Supplies |  |  |  | 0
Travel |  | Mileage, Auto, Airfare, Meals, Lodging |  |  |  | 0
Mapping/Photos/Survey |  | Maps, Film, Photography, Processing |  |  |  | 0
Printing/Xerox |  | Copies, Printing, Plots |  |  |  | 0
Telephone |  | Telephone, Fax |  |  |  | 0
Computer |  | Technology Charge, Software |  |  |  | 0
Total Direct Expenses |  |  |  |  |  | 0
 |  |  |  |  |  | Cost Estimate
[NAME]
Total Subcontractors |  |  |  |  |  | 0
TOTAL |  |  |  |  |  | 0
Notes:
All four sheets are connected with formulas-don't mess with them.  If you find an error notify [NAME].
And be careful where you enter data-it may have a formula attached.
Position codes (PJM33, [NAME], etc) (Col B) and descriptions (Col A) are examples only,
please refer to the master sheet (worksheeet #5) for others and add lines as needed.
Rates (Col E) should be the actual rate-adjust (Col F) only for projects that will go into next year.
Overhead rate (B21) is our currently approved (2005) rate-it will be adjusted in Dec each year.