|
US Forest Service Contract
<br />Project 5xxxx reconciliation through 12/31/12
<br />Hrs incorrectly coded to the USFS projectLeave coded in error to project - will be calculated in general overhead. Removed project code (535-9630-51100)
<br />Hourly WageFYRecode to 535-9630-5xxxxGJNNameWk TDatehoursSalaryHealthOPSRPWork Typecoded as 694 and thus as Match (DS assumption)
<br />$ 29.92FY1196045218Steeck,Diane M #1931706942010/07/230.514.963.054.25
<br />FY10FY11FY12FY13
<br />LEAVE - Calculated in Overhead
<br />Hourly Rate
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/07/260.514.963.054.25
<br />Steeck, D$ 29.32$ 29.91$ 31.87$ 31.87
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/07/270.514.963.054.25
<br />OPSRP Rate
<br />28.39%28.39%29.90%29.90%
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/07/280.514.963.054.25Health Ins5.946.096.747.14
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/07/290.514.963.054.25
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/08/020.514.963.054.25Taylor, THourly Rate
<br />$ 33.48$ 34.15$ 34.85$ 34.85
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/08/030.720.944.265.94PERS Rate30.29%30.29%33.75%33.75%
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/08/040.720.944.265.94
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/08/050.514.963.054.25Fed Ind Rate
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/08/060.720.944.265.94Stormwater48.33%30.79%25.83%22.95%
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/08/170.514.963.054.25
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/08/198239.2948.7267.93
<br />$ 29.92FY11"96045218Steeck,Diane M #1931706942010/08/240.617.953.655.10
<br />***Based on reports from the GL for total project expenses, the AJE required to
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/08/274119.6424.3633.97
<br />balance this project will need to use actual expenses for the leave time coded in error
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/08/304119.6424.3633.97
<br />to the project, match coded to the project to remove the project # from these
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/12/208239.2848.7267.93
<br />expenses. The estimated expenses have been zeroed out to reflect actuals. In
<br />$ 29.91FY11"96045218Steeck,Diane M #1931706942010/12/218239.2848.7267.93
<br />addition, the 9 hours of staff time coded correctly to the project on 8/24/12 will need
<br />38.7$ 1,721.90
<br />to reflect actual costs for computing total project expenses. kla (1/30/13)
<br />TOTAL1157.58235.68328.64
<br />***38.7$ 1,734.96
<br />Actuals from GL - USE THESE FIGURES1157.53249.23328.20
<br />Hrs incorrectly coded to the USFS projectTime coded in error to project - s/b for other work/projects (did not hit GL project #)
<br />Hourly WageFYNotesGJNNameWk TDatehoursSalaryHealthOPSRP
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/11/249.2275.1756.0378.12
<br />planting maps, task orders, arcpad training, WRT, HGM&ORWAP for MBI, other MBI,
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/11/298239.2848.7267.93
<br />SOS forms, Heritage/PNN invoices, seed inventory wrap-up, Heritage contract amendment
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/11/309.2275.1756.0378.12
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/016.8203.3941.4157.74
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/028.7260.2252.9873.88
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/035.6167.534.1047.55
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/067.5224.3345.6863.69
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/079.2275.1756.0378.12
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/10259.8212.1816.98
<br />WIR CCS reporting, winter site assessments,
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/138239.2848.7267.93
<br />field work memos (LOBR, LYHY), SPROUTs planning
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/1410.5314.0663.9589.16
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/159.7290.1359.0782.37
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/167.2215.3543.8561.14
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/278.2245.2649.9469.63
<br />HGM for MBI, EPA task list, DBP2 monitoring data,
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/286179.4636.5450.95
<br />DBP2 site visit, team mtg,
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/298.2245.2649.9469.63
<br />$ 29.91FY1196045218Steeck,Diane M #1931707932010/12/308.5254.2451.7772.18
<br />$ 31.23FY1196045218Steeck,Diane M #1931707932011/01/109.8306.0559.6886.89
<br />excell training, team building
<br />$ 31.23FY1196045218Steeck,Diane M #1931707932011/01/246.7209.2440.8059.40
<br />mt w/TNC on WV seed, EPA billing, NW Sci article, Monitoring data
<br />$ 31.87FY1296045218Steeck,Diane M #1931707932011/07/204127.4826.9638.12
<br />2 = new project/funding possibility; 2 = Case study
<br />1534605.86934.371309.53$ 6,849.76OTHER PROJECTS
<br />TOTAL
<br />Time coded to project - s/b coded to match (535-9630-51100-621051)
<br />P:\Cdocs\Contracts\Grants\990 US Forest Service Native Plant Materials Research Grant\621050 Reconc thru 12-31-2012.xlsx2/5/2013
<br />
|