|
City of Eugene
<br />Fund 133 - Revenue y2
<br />DEPT CO All _
<br />FUND CO All
<br />Sum of ACTUAL AMOUNT
<br />FISCAL YEAR
<br />ACCOUNT
<br />ACCOUNT DESC
<br />ACCT
<br />PERIOD
<br />2007
<br />2008
<br />2009
<br />2010
<br />2011
<br />41851
<br />Local Motor Vehicle Fuel Tax
<br />1
<br />(259,703)
<br />(278,204)
<br />(266,432)
<br />(275,221)
<br />(167,286)
<br />2
<br />259,703
<br />278,204
<br />266,432
<br />275,221
<br />167,286
<br />3
<br />(286,781)
<br />(266,557)
<br />(264,990)
<br />(139,476)
<br />(282,633)
<br />4
<br />(301,237)
<br />(294,012)
<br />(270,388)
<br />(138,704)
<br />(266,604)
<br />5
<br />(277,940)
<br />(271,520)
<br />(241,492)
<br />(127,577)
<br />(271,863)
<br />6
<br />(293,515)
<br />(283,151)
<br />(163,268)
<br />(103,413)
<br />(277,993)
<br />7
<br />(299,662)
<br />(271,327)
<br />(339,163)
<br />(154,350)
<br />8
<br />(278,908)
<br />(264,092)
<br />(228,113)
<br />(126,055)
<br />9
<br />(185,749)
<br />(226,378)
<br />(143,910)
<br />(69,940)
<br />10
<br />(326,790)
<br />(259,103)
<br />(320,860)
<br />(176,936)
<br />11
<br />(273,481)
<br />(176,179)
<br />(247,604)
<br />(135,954)
<br />12
<br />(270,738)
<br />(253,362)
<br />(219,063)
<br />(119,945)
<br />13
<br />(564,735)
<br />(517,925)
<br />(537,258)
<br />(445,946)
<br />41851 Tota
<br />l
<br />(3,359,536)
<br />(3,083,605)
<br />2 976 107
<br />(1,738,296)
<br />(1,099,094)
<br />43823
<br />County/City OTIA III Rev Sha
<br />2
<br />(252,986)
<br />6
<br />43823 Tota
<br />l
<br />(252,986)
<br />43990
<br />Other Agency Share/Proj Cos
<br />1
<br />(4,538,799)
<br />2
<br />(626,340)
<br />3
<br />(1,220,888)
<br />(1,099,954)
<br />5
<br />(1,611,188)
<br />6
<br />0
<br />7
<br />(5,300)
<br />(36,205)
<br />13
<br />1,220,888
<br />1,099,954
<br />626,340
<br />43990 Tota
<br />l
<br />(390,300)
<br />(126,234)
<br />(5,012,413)
<br />(662,545)
<br />47110
<br />Interest On Investments
<br />1
<br />-
<br />-
<br />-
<br />0
<br />2
<br />(1,365)
<br />3
<br />(29,630)
<br />(53,570)
<br />(61,989)
<br />(32,424)
<br />(10,108)
<br />4
<br />(2,385)
<br />(1,155)
<br />0
<br />5
<br />(2,477)
<br />(1,031)
<br />(48)
<br />(1,316)
<br />6
<br />(30,780)
<br />(33,398)
<br />(50,150)
<br />(20,018)
<br />(6,346)
<br />7
<br />(1,350)
<br />(992)
<br />8
<br />(2,225)
<br />(368)
<br />9
<br />(61,488)
<br />(36,388)
<br />(44,898)
<br />(18,276)
<br />10
<br />(1,754)
<br />(18)
<br />11
<br />(1,523)
<br />(14)
<br />12
<br />(70,387)
<br />(2,936)
<br />(43,150)
<br />(16,335)
<br />13
<br />(34,814)
<br />1,316
<br />47110 Tota
<br />l
<br />(192,285)
<br />(172,819)
<br />205129
<br />(85,785)
<br />(17,770)
<br />48011
<br />Transfer Frm General Fnd
<br />1
<br />-
<br />6
<br />1 500 000
<br />48011 Tota
<br />l
<br />(1,500,000)
<br />49900
<br />Beginning Working Capital
<br />1
<br />-
<br />-
<br />-
<br />0
<br />6
<br />0
<br />49900 Tota
<br />l
<br />0
<br />47111
<br />Int on Investments FMV Ad'
<br />2
<br />(9,700)
<br />47111 Tota
<br />l
<br />(9,700)
<br />47990
<br />Other Revenue
<br />5
<br />(10,400)
<br />7
<br />160
<br />47990 Tota
<br />l
<br />(10,400)
<br />160
<br />47920
<br />Donations
<br />6
<br />197
<br />47920 Tota
<br />l
<br />197
<br />47991
<br />Billing Clearing Account
<br />8
<br />779)
<br />
<br />9
<br />9
<br />:77
<br />47991 Tota
<br />l
<br />Grand Total
<br />(5,704,806)
<br />(3,393,255)
<br />(8,193,809)
<br />2 486 625
<br />(1.116.864)
<br />SOL Stmt
<br />SELECT GL MASTER.FISCAL_YEAR, GL_ACCOUNT.ACCOUNT, GL_ACCOUNT.ACCOUNT_DESC, GL_MASTER.DEPTID,
<br />GL_MASTER.ACTUAL_AMOUNT,GL_MASTER.ACCT_PERIOD, GL MASTERYUND CODE,
<br />GL_MASTER.BUDGET AMOUNT, GL_MASTER.DEPT_CODE, GL_MASTER.PROGRAM_CODE, GL_MASTER.PROJECT_ID
<br />FROM QUERY GLAbo.GL_A000UNT GI-ACCOUNT, QUERY_GL.dbo.GL_MASTER GL MASTER
<br />WHERE GL_MASTER.ACCOUNT= GL_ACCOUNT.ACCOUNT AND((GL MASTER.FISCAL_YEAR>2001')
<br />AND GL MASTERYUND CODE In'133';342' AND GL MASTER.A000UNT Uke'41N
<br />3 year average calculation FY07-09
<br />43.7933%
<br />($3,062,630)
<br />-242,134
<br />42.986% (3,120,173,~FY09
<br />38.171% (3,513,760) FY10
<br />Drogrammed all of Hwy 99 Transfer in FY10
<br />-30,462 e
<br />
|