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: | Bay West | | | |
| 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 | $ 900.00 | $ 800.00 | $ 600.00 | $ 500.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 | $ 114.07 | Average Hourly Rate | | |
| Project Supervisor | $ 87.05 | Average Hourly Rate | | |
| Engineer | $ 70.67 | Average Hourly Rate | * | |
| Hydrogeologist | $ 60.04 | Average Hourly Rate | | |
| Scientist | $ 48.03 | Average Hourly Rate | | |
| Field Technician | $ 42.02 | Average Hourly Rate | | |
| CADD, GIS | $ 51.03 | Average Hourly Rate | | |
| Accounting | $ 42.03 | Average Hourly Rate | | |
| Administrative Support | $ 36.03 | Average Hourly Rate | | |
| Asbestos Inspector | $ 35.33 | Average Hourly Rate | | |
| Exterior Abatement Worker | 32.39 | Average Hourly Rate | | |
| Exterior Asbestos Supervisor | 61.835 | Average Hourly Rate | | |
| Asbestos Worker | 32.39 | Average Hourly Rate | | |
| Asbestos Supervisor | 61.835 | Average Hourly Rate | | |
| Asbestos Project Designer | 94.22 | Average Hourly Rate | | |
| Asbestos Management Planner | 94.22 | 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 | $70.00 | | | |
| Per night, Milwaukee, Racine and Kenosha counties | $80.00 | | | |
| Overhead rate | Terms: Percentage of Direct Labor | | | |
| Proposed rate | 65% | Percentage of Direct Labor | | |
| Profit | Terms: percentage of labor and overhead, no profit on subcontractors or direct expenses | | | |
| Proposed Rate | 6% | 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.) | | | | | | | | | | | | | | | | |
| Bay West | 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: | Sr. Project Manager II | Project Manager | Staff Professional IV | Staff Professional II | Staff Professional I | Field Technician I | GIS Tech | Office Support | Office Support | Field Technician I | Field Technician I | Site Supervisor I | Field Technician I | Site Supervisor I | Sr. Project Manager I | Sr. Project Manager I |
| Sr. Project Manager III | Sr. Project Manager I | e2 | Staff Professional III | s2 | Field Technician II | GIS Analyst I | Staff Professional I | adm2 | Field Technician II | | Site Supervisor II | | Site Supervisor II | | |
| EXAMPLE: | cm3 | PS3 | e3 | h3 | s3 | Field Technician III | GIS Analyst II | acc3 | adm3 | ai3 | | eas3 | | as3 | | |
| Rate Title: Scientist | cm4 | PS4 | e4 | h4 | S4 | Field Technician IV | cad4 | acc4 | adm4 | ai4 | | eas4 | | as4 | | |
| Classifications included in title: Staff scientist 1 | cm5 | PS5 | e5 | h5 | S5 | ft5 | cad5 | acc5 | adm5 | ai5 | | eas5 | | as5 | | |
| Staff scientist 2 | cm6 | ps6 | e6 | h6 | s6 | ft6 | cad6 | acc6 | adm6 | ai6 | eaw6 | eas6 | aw6 | as6 | apd6 | amp6 |
| Arborist | cm7 | ps7 | e7 | h7 | s7 | ft7 | cad7 | acc7 | adm7 | ai7 | eaw7 | eas7 | aw7 | as7 | apd7 | amp7 |
| Geologist 1 | cm8 | ps8 | e8 | h8 | s8 | ft8 | cad8 | acc8 | adm8 | ai8 | eaw8 | eas8 | aw8 | as8 | apd8 | amp8 |
| Geologist 2 | cm9 | ps9 | e9 | h9 | s9 | ft9 | cad9 | acc9 | adm9 | ai9 | eaw9 | eas9 | aw9 | as9 | apd9 | amp9 |
| Senior Project Technical | cm10 | ps10 | e10 | h10 | s10 | ft10 | cad10 | acc10 | adm10 | ai10 | eaw10 | eas10 | aw10 | as10 | apd10 | amp10 |
| | | | | | | | | | | | | | | | 0 |
Tab 3 Average Wage Rate Calc
| Bay West | | 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 | $114.07 | Sr. Project Manager II | $ 108.07 | Sr. Project Manager III | $ 120.07 | cm3 | | cm4 | | cm5 | | cm6 | | cm7 | | cm8 | | cm9 | | cm10 | |
| Project Supervisor | $87.05 | Project Manager | $ 78.05 | Sr. Project Manager I | $ 96.05 | PS3 | | PS4 | | PS5 | | ps6 | | ps7 | | ps8 | | ps9 | | ps10 | |
| Engineer | $70.67 | Staff Professional IV | $ 70.67 | e2 | | e3 | | e4 | | e5 | | e6 | | e7 | | e8 | | e9 | | e10 | |
| Hydrogeologist | $60.04 | Staff Professional II | $ 57.04 | Staff Professional III | $ 63.03 | h3 | | h4 | | h5 | | h6 | | h7 | | h8 | | h9 | | h10 | |
| Scientist | $48.03 | Staff Professional I | $ 48.03 | s2 | | s3 | | S4 | | S5 | | s6 | | s7 | | s8 | | s9 | | s10 | |
| Field Technician | $42.02 | Field Technician I | $ 33.02 | Field Technician II | $ 39.02 | Field Technician III | $ 45.02 | Field Technician IV | $ 51.03 | ft5 | | ft6 | | ft7 | | ft8 | | ft9 | | ft10 | |
| CADD/GIS | $51.03 | GIS Tech | $ 42.02 | GIS Analyst I | $ 48.03 | GIS Analyst II | $ 63.03 | cad4 | | cad5 | | cad6 | | cad7 | | cad8 | | cad9 | | cad10 | |
| Accounting | $42.03 | Office Support | $ 36.03 | Staff Professional I | $ 48.03 | acc3 | | acc4 | | acc5 | | acc6 | | acc7 | | acc8 | | acc9 | | acc10 | |
| Administrative Support | $36.03 | Office Support | $ 36.03 | adm2 | | adm3 | | adm4 | | adm5 | | adm6 | | adm7 | | adm8 | | adm9 | | adm10 | |
| Asbestos Inspector | $35.33 | Field Technician I | $ 32.39 | Field Technician II | $ 38.27 | ai3 | | ai4 | | ai5 | | ai6 | | ai7 | | ai8 | | ai9 | | ai10 | |
| Exterior Abatement Worker | $32.39 | Field Technician I | $ 32.39 | 0 | | 0 | | 0 | | 0 | | eaw6 | | eaw7 | | eaw8 | | eaw9 | | eaw10 | |
| Exterior Asbestos Supervisor | $61.84 | Site Supervisor I | $ 55.95 | Site Supervisor II | $ 67.72 | eas3 | | eas4 | | eas5 | | eas6 | | eas7 | | eas8 | | eas9 | | eas10 | |
| Asbestos Worker | $32.39 | Field Technician I | $ 32.39 | 0 | | 0 | | 0 | | 0 | | aw6 | | aw7 | | aw8 | | aw9 | | aw10 | |
| Asbestos Supervisor | $61.84 | Site Supervisor I | $ 55.95 | Site Supervisor II | $ 67.72 | as3 | | as4 | | as5 | | as6 | | as7 | | as8 | | as9 | | as10 | |
| Asbestos Project Designer | $94.22 | Sr. Project Manager I | $ 94.22 | 0 | | 0 | | 0 | | 0 | | apd6 | | apd7 | | apd8 | | apd9 | | apd10 | |
| Asbestos Management Planner | $94.22 | Sr. Project Manager I | $ 94.22 | 0 | | 0 | | 0 | | 0 | | 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 | | | | | | | | |