B C D E F G
1 Oregon Department of Environmental Quality
2 Cleanup Project Cost Estimate
3 Project Estimate Assume GW Monitoring Has No Significant Pathway to SCD
5 Project Name: NW Pipe     ECSI # : 138
6 Project Manager: Jim Orr     Q-Time # :  
7 Project Team Members: JO, AL, MR, MP, SM, and MM Bus. Office # :  
9 Project office/region: NWR        
10 This estimate covers the period starting: 3/1/16      
11 and ending: 3/1/17      
12 General Scope and Assumptions:        
14 ESTIMATE OF PROJECT COST: $32,016      
16 PERSONAL SERVICES (see breakdown, below)     32,016
18 OTHER DIRECT CHARGES          
19 Attorney General ($175/hour)         0
20 Travel ($0.575/mile + food, lodging, tax)       0
21 Contract Payments         0
22 Capital Outlay         0
23 Lab         0
24 TOTAL estimated project costs       $32,016
26 Personal services (technical staff)        
27 Activity   Staff Hours Rate ($/hr) (1) Total $
28 Project Administration   NRS-4 15 187 2,807
29            
30 File Review   NRS-3   166 0
31            
32 Groundwater Site Investigation Work Plan NRS-4 12 187 2,245
33            
34 Draft Site Investigation Work Plan NRS-4   187 0
35     NRS-3   166 0
36            
37 Final SCD Complete All Staff   NRS-4 60 187 11,227
38            
39 SC Implementation   NRS-4   187 0
40     NRS-3   166 0
41            
42 Draft SC Report Review   NRS-4 25 187 4,678
43 SC Decision   NRS-4   187 0
44     NRS-4 Hydro   187  
45     NRS-4   187 0
46     NRS-4   187 0
47 Lead Worker and Manager Review NRS-5 Hydro 30 211.00 6,330
48       142    
49 Total, Technical Staff         27,287
50 Clerical Staff, Regional Manager, HQ Staff [0 - 20% of project budget] 10% 2,729
52 Contingency (added complexity, quality of work products) [20%] 1.00 2,000
54       Total, Personal Services 32,016
56 Notes:          
57 1. Select staff level.          
58 2. Select hours for task.          
59 3. Select contingency for staff or other complexity.      
60 4. Add or change tasks or sub-tasks to address project specific needs.    
62 Top-Step Salary Schedule, 2015-16 (incorporates new LQ Indirect as of Oct. 2015)  
63 Classification Cost/hr.        
64 NRS-1 $130        
65 NRS-2 $147        
66 NRS-3 $166        
67 NRS-4 $187        
68 OPA-3 $187        
69 NRS-4 Hydro $195        
70 NRS-5 $203        
71 NRS-5 Hydro $211        
72 EE3 and NRS-4 Tox $195        
74 Template updated 9/9/15 by Sandra James and Gil Wistar      

Modified_worksheet

  A B C D
1 Rates updated based on "Cost Estimator for 2014 (2014-09-01).xlsx"
2 "Fiscal Year 14" tab with COLA at 2% for 9/1/2014 pay rates  
4 NRS-4 = NRS 4 AA, AD    
5 NRS-4 Hydro = NRS 4 BA, AD    
6 NRS-4 Tox = NRS 4 CA, AD    
7 NRS-4 Sanitarian = NRS 4 DA, AD    
8 OPA-3 Mgmt Non-supervisory = OPA 3 AA, MMN    
10 AG rates are for 2013-2015 biennium    
12 When this spreadsheet gets updated, we should probably also update the webpage at http://www.deq.state.or.us/lq/cu/invoicing.htm

source info