City of Eugene - Public Works Admin <br />Fund 343 Experience Estimates <br />1/28/2011 <br />'tUk.p .C(~,LAID <br />AMO'UN'T" <br />AG`COUtIT ' 2009 ' ` ' 209b 'ii / , 2099, C3Cand TPfal EE <br />4 99 <br />47110 <br />0.00 <br />(5.616.00) <br />(4,089.00) <br />(9,705.00) <br />(4,089.00)b <br />47190 <br />(6.65) <br />(9.21) <br />(15.86) <br />49155 <br />(485,000.00) <br />(6,015,000.00) <br />(2,150,000.00) <br />(8,650,000.00) <br />(10,199,021.00) Line of Credit BA = 0 <br />49900 <br />0.00 <br />0.00 <br />0.00 <br />E. <br />4 Total <br />(485,006.65) <br />(6,020 625.21) <br />(2154 089.00) <br />(8,659,720.86) <br />6 93 <br />61270 <br />1,601.16 <br />7,749.50 <br />1,124.16 <br />10,474.82 <br />61400 <br />3,042.85 <br />3,042.85 <br />61430 <br />1,666.70 <br />330.99 <br />1,997.69 <br />61731 <br />1,174.36 <br />3,172.20 <br />4,346.56 <br />61735 <br />0.00 <br />2,172,917.46 <br />3,776,704.67 <br />5,949,622.13 <br />61736 <br />1,859.33 <br />32,928.48 <br />59,834.35 <br />94,622.16 <br />61739 <br />4,027.00 <br />59,442.98 <br />97,704.93 <br />161,174.91 <br />61797 <br />0.00 <br />0.00 <br />0.00 <br />61799 <br />0.00 <br />0.00 <br />0.00 <br />61800 <br />7,945.25 <br />7,945.25 <br />61810 <br />250.00 <br />250.00 <br />61837 <br />1,510.76 <br />1,173.06 <br />2,683.82 <br />61862 <br />950.00 <br />950.00 <br />61864 <br />336.37 <br />4,936.58 <br />1,248.00 <br />6,520.95 <br />61890 <br />42,715.00 <br />85,778.00 <br />125,027.05 <br />253,520.05 <br />61891 <br />381,480.84 <br />491,615.08 <br />283,482.63 <br />1,156,578.55 <br />61898 <br />5,862.57 <br />23,813.13 <br />39,824.80 <br />69,500.50 <br />61899 <br />24,506.84 <br />395,407.21 <br />471,406.54 <br />891,320.59 <br />62900 <br />2,232.00 <br />3,375.25 <br />1,358.76 <br />6,966.01 <br />99 <br />61800 <br />0.00 <br />0.00 <br />0.00 <br />Assume all capital <br />6 Total <br />465,795.47 <br />3,296,501.43 <br />4,859,219.94 <br />8,621,516.84 <br />12,897,702.00 approp spent <br />d Historically spend <br />around $16,000. Life <br />of the Bond should <br />8........ 99 <br />89914 <br />16,683.25 <br />16,059.07 <br />458.34 <br />33,200.66 <br />16,000.00 be $130,000 <br />8 Total <br />16,683.25 <br />16,059.07 <br />458.34 <br />33,200.66 <br />e <br />9 99 98000 0.00 0.00 0.00 <br />9 Total 0.00 0.00 0.00 <br />2 527,83 -r 2 OS 0 2 705 588 28> , , <br />SQL Stmt <br />SELECT GL_MASTER.FISCAL_YEAR, GL_MASTER.FUND_CODE, left(GL_MASTER.DEPTID,2)AS'DV', GL_ACCOUNT.ACCOUNT, <br />left(GL_ACCOUNT.ACCOUNT,1) AS Type, GL_MASTER.ACTUAL_AMOUNT <br />FROM QUERY_GL.dbo.GL_A000UNT GL-ACCOUNT, QUERY_GL.dbo.GL_MASTER GL_MASTER <br />WHERE GL_ACCOUNT.ACCOUNT = GL_MASTER.A000UNT AND ((GL_MASTER.FUND_CODE='343') AND (GL_ACCOUNT.ACCOUNT-'40000')) <br />