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 />
|