Project 100022 -Grant Reimbursement <br />This column <br />has been <br />changed from <br />the lookup for <br />the indirect rate <br />to the 47.01 % <br />rate approved <br />Authoriz( 6/25/2010 Grant 618 in the grant. <br />47.01% <br />tota I_r s total total- Total Salary & <br />emplid pay_end_date employee dv service type_work_desc alary °- n- Fringe Indirect Grant Total <br />salary salary <br />tota I_r h o u <br />rs <br />tota I_ <br />total_o_hours n_ho Fiscal Year PSF Difference <br />urs <br />19317 <br />3/13/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />234.56 <br />0 <br />0 <br />352.88 <br />165.89 <br />518.77 <br />8.00 <br />0 <br />0 <br />FY10 <br />736.00 <br />- 217.23 <br />19317 <br />4/10/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />190.58 <br />0 <br />0 <br />286.69 <br />134.77 <br />421.46 <br />6.50 <br />0 <br />0 <br />FY10 <br />598.00 <br />- 176.54 <br />19317 <br />4/24/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />161.26 <br />0 <br />0 <br />244.38 <br />114.88 <br />359.26 <br />5.50 <br />0 <br />0 <br />FY10 <br />506.00 <br />- 146.74 <br />19317 <br />5/8/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />29.32 <br />0 <br />0 <br />44.1 <br />20.73 <br />64.83 <br />1.00 <br />0 <br />0 <br />FY10 <br />92.00 <br />-27.17 <br />19317 <br />6/5/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />146.6 <br />0 <br />0 <br />220.55 <br />103.68 <br />324.23 <br />5.00 <br />0 <br />0 <br />FY10 <br />460.00 <br />- 135.77 <br />19317 <br />6/19/2010 <br />Steeck,Diane M <br />"9100022 <br />EPA Grant Phase 2 <br />146.6 <br />0 <br />0 <br />222.17 <br />104.44 <br />326.61 <br />5.00 <br />0 <br />0 <br />FY10 <br />460.00 <br />- 133.39 <br />19317 <br />7/3/2010 <br />Steeck,Diane M <br />88.97 <br />133.64 <br />62.82 <br />196.46 <br />3.00 <br />0 <br />0 <br />FY10 <br />276.00 <br />-79.54 <br />Billing #1 <br />to LCOG <br />1504.41 <br />707.21 <br />2211.62 <br />34.00 <br />3128.00 <br />- 916.38 <br />19317 <br />7/3/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />118.63 <br />0 <br />0 <br />178.2 <br />83.77 <br />261.97 <br />4.00 <br />0 <br />0 <br />FY10 <br />368.00 <br />- 106.03 <br />19317 <br />7/17/2010 <br />Steeck,Diane M <br />96 <br />1100022 <br />EPA Grant Phase 2 <br />358.93 <br />0 <br />0 <br />538.81 <br />253.29 <br />792.10 <br />12.00 <br />0 <br />0 <br />FY10 <br />1104.00 <br />- 311.90 <br />19317 <br />7/31/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />409.78 <br />0 <br />0 <br />621.39 <br />292.12 <br />913.51 <br />13.70 <br />0 <br />0 <br />FY11 <br />1068.60 <br />- 155.09 <br />19317 <br />8/14/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />254.25 <br />0 <br />0 <br />382.75 <br />179.93 <br />562.68 <br />8.50 <br />0 <br />0 <br />FY11 <br />663.00 <br />- 100.32 <br />19317 <br />8/28/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />358.93 <br />0 <br />0 <br />544.23 <br />255.84 <br />800.07 <br />12.00 <br />0 <br />0 <br />FY11 <br />936.00 <br />- 135.93 <br />19317 <br />9/11/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />523.43 <br />0 <br />0 <br />787.95 <br />370.42 <br />1158.37 <br />17.50 <br />0 <br />0 <br />FY11 <br />1365.00 <br />- 206.63 <br />Billing #2 to LCOG 1st Qtr FY11 <br />3053.33 <br />1435.37 <br />4488.70 <br />67.70 <br />5504.60 <br />- 1015.90 <br />19317 <br />9/25/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />598.2 <br />0 <br />0 <br />907.12 <br />629.63 <br />1536.75 <br />20.00 <br />0 <br />0 <br />FY11 <br />1560.00 <br />-23.25 <br />19317 <br />10/9/2010 <br />Steeck,Diane M <br />96 <br />1100022 <br />EPA Grant Phase 2 <br />538.39 <br />29.91 <br />59.82 <br />0 <br />0 <br />810.54 <br />381.03 <br />1191.57 <br />18.00 <br />0 <br />0 <br />FY11 <br />1404.00 <br />- 212.43 <br />19317 <br />10/23/2010 <br />Steeck,Diane M <br />96 <br />1100022 <br />EPA Grant Phase 2 <br />0 <br />0 <br />45.36 <br />21.32 <br />66.68 <br />1.00 <br />0 <br />0 <br />FY11 <br />78.00 <br />-11.32 <br />19317 <br />11/6/2010 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />0 <br />0 <br />90.06 <br />42.34 <br />132.40 <br />2.00 <br />0 <br />0 <br />FY11 <br />156.00 <br />-23.60 <br />Billing #3 to LCOG 2nd Qtr FY11 <br />1853.08 <br />1074.32 <br />2927.40 <br />41.00 <br />3198.00 <br />- 270.60 <br />19317 <br />1/15/2011 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />15.62 0 0 <br />140.55 0 0 <br />62.47 0 0 <br />46.85 0 0 <br />23.38 <br />10.99 <br />34.37 <br />0.5 <br />FY11 <br />39.00 <br />-4.63 <br />19317 <br />1/29/2011 <br />Steeck,Diane M <br />96 <br />1100022 <br />EPA Grant Phase 2 <br />211.91 <br />99.62 <br />311.53 <br />4.50 <br />FY11 <br />351.00 <br />-39.47 <br />19317 <br />4/23/2011 <br />Steeck,Diane M <br />96 <br />1100022 <br />EPA Grant Phase 2 <br />94.19 <br />44.28 <br />138.47 <br />2.00 <br />FY11 <br />156.00 <br />-17.53 <br />19317 <br />6/4/2011 <br />Steeck,Diane M <br />96 <br />100022 <br />EPA Grant Phase 2 <br />70.12 <br />32.96 <br />103.08 <br />1.50 <br />FY11 <br />117.00 <br />-13.92 <br />Billing #4 <br />to LCOG 3rd & 4th Qtr FY11 <br />399.60 <br />187.85 <br />587.451 <br />8.50 <br />663.00 <br />-75.55 <br />6810.42 <br />1 st Qtr FY11 2nd Qtr FY1 ' 3rd & 4th Qtr FY11 <br />Billing #1 <br />Billing #2 <br />Billing #3 <br />Billing #4 <br />FY 10 Tot <br />FY11 Tot <br />Summa <br />Billed / Revenue <br />$ (2,230.00) <br />$ (4 <br />$ (2,927.40) <br />$ (583.92) <br />$ (2,230.00) <br />$ (7,985.17) <br />Actual Expense <br />$ 2 <br />$ 4 <br />$ 2 <br />$ 587.45 <br />$ 2,211.62 <br />$ 8,003.55 <br />Adjustment <br />-18.38 <br />14.85 <br />0.00 <br />3.53 <br />-18.38 <br />18.38 <br />0.00 <br />AJE 71633 <br />AJE 73845 <br />AJE 73845 <br />AJE 73845 <br />AJE 75380 <br />P: \Cdocs \Contracts \Grants \Fed Plan Recon.xls 1 10/29/2012 <br />