The file's text, extracted by GovTribe without its formatting.
Instructions
| ATTACHMENT ----- Contract Cost Worksheets | |
| INSTRUCTIONS | |
| Fill in only those cells highlighted in blue. Cells in green are calculated. | |
| Tab 1 Hourly Rates and Costs | Cell # |
| 1. Fill in firm name | B2 |
| 2. Fill in asbestos inspection costs per structure, cells | B5, C5, D5, E5 |
| 3. Fill in proposed overhead rate | B41 |
| 4. Fill in proposed profit percentage as a whole number, field is formatted as a percentage | B44 |
| Tab 2 Classifications in titles | Cell # |
| 1. Please fit each of your current employee classifications into one of the sixteen contract Rate titles | B4 through Q13 |
| 2. Put no more than ten classifications into each rate category. | |
| 3. Leave unused cells blank | |
| Tab 3 Average Wage Rate Calc | Cell # |
| 1. Enter the direct hourly wage rate (without overhead or profit) for each classification entered in Tab 2 | D4-19, F4-19, H 14-19, J 14-19, l 14-19, N 14-19, P 14-19, R14-19, T 14-19, V 14-19 |
| 2. Leave unused cells blank | |
| Tab 4 Ecological Services Cost | Cell # |
| 1. For each scenario in Section 6.1 provide a cost estimate. | B4-19, G4-19, L4-19, Q4-19, V4-19, AA4-19, AF4-19, AK4-19, AU4-19, AZ4-19 |
| 2. Enter the total number of hours for each rate title used for each scenario | |
| 3. Leave unused cells blank | |
| Tab 5 Hazmat Cost | Cell # |
| 1. For each scenario in Section 6.2 provide a cost estmiate. | B4-19, G4-19, L4-19, Q4-19, V4-19, AA4-19, AF4-19 |
| 2. Enter the total number of hours for each rate title used for each scenario | |
| 3. Leave unused cells blank | |
| Tab 6 Direct Expense Calc | Cell # |
| 1. Enter the direct expenses for each scenario in Tab 4 and Tab 5 | Tab 4 G6 through BR 27 and Tab 5 G35 through AT56 |
| 2. Do not include mileage, meals or lodging in your expenses | |
| 3. Leave unused cells blank | |
| Tab 7 Subcontract Calculations | Cell # |
| 1. Enter the subcontract expenses for each scenario in Tab 4 and Tab 5 | Tab 4 E6 through AU 24 and Tab 5 E33 through AE 51 |
| 2. Leave unused cells blank | |
| Tab 8 Cost Total | Cell # |
| There is nothing to enter under this tab. This is the calculation of the proposal cost total. | NONE |
Tab 1 Hourly Rates and Costs
| ATTACHMENT ____ Contract Cost Package | Fill in only those cells highlighted in blue. Cells in green are calculated. | | | |
| FIRM NAME: | GEI Consultants, Inc. | | | |
| Asbestos Inspections - Bridges | Terms: Lump Sum | | | |
| Cost per single structure | Two to four structures, cost per structure | Five to nine structures, cost per structure | Ten or more structures, cost per structure |
| Asbestos inspection, per bridge structure | $ 694.00 | $ 644.00 | $ 638.00 | $ 594.00 |
| NOTE: Structures requrested at the same time in the same spreadsheet constitute a single request, number of structures for pricing is determined by number of structures in request, not number of project IDs. Prices for long, multiple-section structures such as the Hoan Bridge, Wisconsin River bridges, St Croix river bridges, and Mississippi River bridges, will be negotiated separately at the time of request. | | | | |
| Asbestos inspection, buildings, bridge tender houses, other structures | Terms: average direct hourly rate* | | | |
| Asbestos abatement | Terms: average direct hourly rate* | | | |
| Project Staff | Terms: average direct hourly rate* | | | *the average direct hourly rate for each classification shall be the rate charged for the contract |
| Contract Manager | $ 62.77 | Average Hourly Rate | | |
| Project Supervisor | $ 45.89 | Average Hourly Rate | | |
| Engineer | $ 33.81 | Average Hourly Rate | * | |
| Hydrogeologist | $ 40.34 | Average Hourly Rate | | |
| Scientist | $ 33.16 | Average Hourly Rate | | |
| Field Technician | $ 22.54 | Average Hourly Rate | | |
| CADD, GIS | $ 31.32 | Average Hourly Rate | | |
| Accounting | $ 31.96 | Average Hourly Rate | | |
| Administrative Support | $ 26.75 | Average Hourly Rate | | |
| Asbestos Inspector | $ 39.28 | Average Hourly Rate | | |
| Exterior Abatement Worker | ERROR:#DIV/0! | Average Hourly Rate | | |
| Exterior Asbestos Supervisor | 39.24 | Average Hourly Rate | | |
| Asbestos Worker | ERROR:#DIV/0! | Average Hourly Rate | | |
| Asbestos Supervisor | 39.24 | Average Hourly Rate | | |
| Asbestos Project Designer | ERROR:#DIV/0! | Average Hourly Rate | | |
| Asbestos Management Planner | ERROR:#DIV/0! | Average Hourly Rate | | |
| Equipment and supplies | Terms: direct expense, no markup | | | |
| Subcontractor Costs | Terms: actual cost, no markup | | | |
| Mileage | Terms: current state reimbursement rate | | | |
| Per mile, personal vehicle rate | $0.51/mile | | | |
| Meals | Terms: current state reimbursement rate | | | |
| Breakfast | $ 8.00 | | | |
| Lunch | $ 10.00 | | | |
| Dinner | $ 20.00 | | | |
| Lodging | Terms: current state reimbursement rate, excluding taxes | | | |
| Per night | $82.00 | | | |
| Per night, Milwaukee, Racine and Kenosha counties | $90.00 | | | |
| Overhead rate | Terms: Percentage of Direct Labor | | | |
| Proposed rate | 190.670% | Percentage of Direct Labor | | |
| Profit | Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | | | |
| Proposed Rate | 7.000% | Percentage of Direct Labor + Labor Overhead, NO PROFIT ON SUBCONTRACTORS OR DIRECT EXPENSES | | |
Tab 2 Classifications in Titles
| Classifications included in average wage rate: (list each classification on a separate line, do not insert or delete rows, do not leave blank rows between classifications.) | | | | | | | | | | | | | | | | |
| GEI Consultants, Inc. | Please fill in the actual titles of your staff. Limit 10 titles per classification | | | | | | | | | | | | | | | |
| Rate Title: | Contract Manager | Project Supervisor | Engineer | Hydrogeologist | Scientist | Field Technician | CADD/GIS | Accounting | Administrative Support | Asbestos Inspector | Exterior Abatement Worker | Exterior Asbestos Supervisor | Asbestos Worker | Asbestos Supervisor | Asbestos Project Designer | Asbestos Management Planner |
| Classifications included in Rate Titles: | Project Manager | Project Manager | Senior Engineer | Professional Geologist | Environmental Scientist | Staff Professional | Staff Professional | Project Accountant | Administrative Assistant | Environmental Scientist | eaw1 | Environmental Scientist | aw1 | Environmental Scientist | apd1 | amp1 |
| Vice President | Senior Project Scientist | Geological Engineer | Geological Engineer | Ecologist | Staff Professional | Construction Manager | Project Accountant | Administrative Assistant | Staff Professional | eaw2 | eas2 | aw2 | as2 | apd2 | amp2 |
| EXAMPLE: | Senior Hydrogeologist | Senior Engineer | Engineer | Senior Hydrogeologist | Environmental Scientist | Field Technician | CAD Drafter | acc3 | Administrative Assistant | Senior Project Scientist | eaw3 | eas3 | aw3 | as3 | apd3 | amp3 |
| Rate Title: Scientist | Senior Restoration Ecologist | Senior Engineer | Engineer | Staff Professional | Senior Project Scientist | Technician | GIS Designer | acc4 | adm4 | Environmental Engineer | eaw4 | eas4 | aw4 | as4 | apd4 | amp4 |
| Classifications included in title: Staff scientist 1 | cm5 | Senior Hydrogeologist | Staff Professional | h5 | Staff Professional | Technician | Senior Design Drafter | acc5 | adm5 | Environmental Scientist | eaw5 | eas5 | aw5 | as5 | apd5 | amp5 |
| Staff scientist 2 | cm6 | Senior Professional | Staff Professional | h6 | Wetland Scientist | Technician | Staff Professional | acc6 | adm6 | ai6 | eaw6 | eas6 | aw6 | as6 | apd6 | amp6 |
| Arborist | cm7 | Senior Environmental Scientist | e7 | h7 | Staff Professional | Technician | cad7 | acc7 | adm7 | ai7 | eaw7 | eas7 | aw7 | as7 | apd7 | amp7 |
| Geologist 1 | cm8 | Senior Environmental Scientist | e8 | h8 | Wildlife biologist | Staff Professional | cad8 | acc8 | adm8 | ai8 | eaw8 | eas8 | aw8 | as8 | apd8 | amp8 |
| Geologist 2 | cm9 | Senior Professional | e9 | h9 | Staff Environmental Engineer | ft9 | cad9 | acc9 | adm9 | ai9 | eaw9 | eas9 | aw9 | as9 | apd9 | amp9 |
| Senior Project Technical | cm10 | ps10 | e10 | h10 | Senior Natural Resources Manager | ft10 | cad10 | acc10 | adm10 | ai10 | eaw10 | eas10 | aw10 | as10 | apd10 | amp10 |
| | | | | | | | | | | | | | | | 0 |
Tab 3 Average Wage Rate Calc
| GEI Consultants, Inc. | | Fill in only those cells highlighted in blue. Cells in green are calculated. | | | | | | Do not alter or change the formulas. | | | | | | | | | | | | | |
| | Enter the hourly rate for each classification shown | | | | | | | | | | | | | | | | | | | |
| Title | Average Hourly Rate | Classification 1 | Hourly rate 1 | Classification 2 | Hourly Rate 2 | Classification 3 | Hourly Rate 3 | Classification 4 | Hourly Rate 4 | Classification 5 | Hourly Rate 5 | Classification 6 | Hourly Rate 6 | Classification 7 | Hourly Rate 7 | Classification 8 | Hourly Rate 8 | Classification 9 | Hourly Rate 9 | Classification 10 | Hourly Rate 10 |
| Contract Manager | $62.77 | Project Manager | $ 41.24 | Vice President | $ 83.32 | Senior Hydrogeologist | $ 68.80 | Senior Restoration Ecologist | $ 57.72 | cm5 | | cm6 | | cm7 | | cm8 | | cm9 | | cm10 | |
| Project Supervisor | $45.89 | Project Manager | $ 41.24 | Senior Project Scientist | $ 44.28 | Senior Engineer | $ 37.20 | Senior Engineer | $ 53.56 | Senior Hydrogeologist | $ 44.24 | Senior Professional | $ 46.76 | Senior Environmental Scientist | $ 53.88 | Senior Environmental Scientist | $ 43.28 | Senior Professional | $ 48.60 | ps10 | |
| Engineer | $33.81 | Senior Engineer | $ 37.20 | Geological Engineer | $ 33.12 | Engineer | $ 36.48 | Engineer | $ 34.48 | Staff Professional | $ 29.24 | Staff Professional | $ 32.36 | e7 | | e8 | | e9 | | e10 | |
| Hydrogeologist | $40.34 | Professional Geologist | $ 48.84 | Geological Engineer | $ 33.12 | Senior Hydrogeologist | $ 44.24 | Staff Professional | $ 35.16 | h5 | | h6 | | h7 | | h8 | | h9 | | h10 | |
| Scientist | $33.16 | Environmental Scientist | $ 39.24 | Ecologist | $ 36.08 | Environmental Scientist | $ 32.72 | Senior Project Scientist | $ 44.28 | Staff Professional | $ 29.24 | Wetland Scientist | $ 32.00 | Staff Professional | $ 26.60 | Wildlife biologist | $ 26.00 | Staff Environmental Engineer | $ 29.40 | Senior Natural Resources Manager | $ 36.08 |
| Field Technician | $22.55 | Staff Professional | $ 22.36 | Staff Professional | $ 29.80 | Field Technician | $ 21.64 | Technician | $ 21.52 | Technician | $ 22.28 | Technician | $ 19.28 | Technician | $ 17.00 | Staff Professional | $ 26.48 | ft9 | | ft10 | |
| CADD/GIS | $31.32 | Staff Professional | $ 33.00 | Construction Manager | $ 37.04 | CAD Drafter | $ 31.48 | GIS Designer | $ 25.00 | Senior Design Drafter | $ 34.28 | Staff Professional | $ 27.12 | cad7 | | cad8 | | cad9 | | cad10 | |
| Accounting | $31.96 | Project Accountant | $ 34.96 | Project Accountant | $ 28.96 | acc3 | | acc4 | | acc5 | | acc6 | | acc7 | | acc8 | | acc9 | | acc10 | |
| Administrative Support | $26.75 | Administrative Assistant | $ 24.28 | Administrative Assistant | $ 33.20 | Administrative Assistant | $ 22.76 | adm4 | | adm5 | | adm6 | | adm7 | | adm8 | | adm9 | | adm10 | |
| Asbestos Inspector | $39.28 | Environmental Scientist | $ 32.72 | Staff Professional | $ 35.16 | Senior Project Scientist | $ 44.28 | Environmental Engineer | $ 45.00 | Environmental Scientist | $ 39.24 | ai6 | | ai7 | | ai8 | | ai9 | | ai10 | |
| Exterior Abatement Worker | ERROR:#DIV/0! | eaw1 | | eaw2 | | eaw3 | | eaw4 | | eaw5 | | eaw6 | | eaw7 | | eaw8 | | eaw9 | | eaw10 | |
| Exterior Asbestos Supervisor | $39.24 | Environmental Scientist | $ 39.24 | eas2 | | eas3 | | eas4 | | eas5 | | eas6 | | eas7 | | eas8 | | eas9 | | eas10 | |
| Asbestos Worker | ERROR:#DIV/0! | aw1 | | aw2 | | aw3 | | aw4 | | aw5 | | aw6 | | aw7 | | aw8 | | aw9 | | aw10 | |
| Asbestos Supervisor | $39.24 | Environmental Scientist | $ 39.24 | as2 | | as3 | | as4 | | as5 | | as6 | | as7 | | as8 | | as9 | | as10 | |
| Asbestos Project Designer | ERROR:#DIV/0! | apd1 | | apd2 | | apd3 | | apd4 | | apd5 | | apd6 | | apd7 | | apd8 | | apd9 | | apd10 | |
| Asbestos Management Planner | ERROR:#DIV/0! | amp1 | | amp2 | | amp3 | | amp4 | | amp5 | | amp6 | | amp7 | | amp8 | | amp9 | | amp10 | |
| Example: | Average Hourly Rate | Classification 1 | Hourly rate 1 | Classification 2 | Hourly Rate 2 | Classification 3 | Hourly Rate 3 | Classification 4 | Hourly Rate 4 | Classification 5 | Hourly Rate 5 | Classification 6 | Hourly Rate 6 | | | | | | | | |
| Scientist | $17.52 | Staff Scientist 1 | $ 12.35 | Staff Scientist 2 | $ 13.50 | Staff Scientist 3 | $ 14.75 | Geologist 1 | $ 17.50 | Geologist 2 | $ 23.50 | Senior Project Technical | $ 23.50 | | | | | | | | |