|
j City of Eugene
<br /> ' Fund 133 -Revenue
<br /> i
<br /> j DEPT_CO (Alp
<br /> FUND CO 133
<br /> Sum of ACTUAL AMOUNT FISCAL YEAR
<br /> ACCOUN ACCOUNT DESC ACCT P 2007 2008 2009
<br /> 41851 Local Motor Vehicle Fuel Tax 1 (259,703) (278,204) (266,432)
<br /> 2 259,703 278,204 266,432
<br /> 3 (286,781) (266,557) (264,990) -
<br /> 4 (301,237) (294,012) (270,388)
<br /> 5 (277,940) (271,520) (241,492)
<br /> i 6 (293,515) (283,151) (163,268)
<br /> 7 (299,662) (271,327) (338,326) Gross MFVT received by ODOT
<br /> 8 ' (278,908) (264,092)
<br /> 9 (185,749) (226,378)
<br /> 10 (326,790) (259,103)
<br /> j 11 (273,481) (176,179)
<br /> 12 (270,738) (253,362)
<br /> 13 564 735 517,925
<br /> ~ 41851 Total 3 359,536 3,083,605 940,137 44.966% {3,000,000)
<br /> 43823 County/City OTIA III Rev Sha 2 (252,986)
<br /> 6
<br /> 43823 Total 252,986
<br /> 43990 Other Agency Share/Proj Cos 1 (4,538,799) $4.5 million from Lane County and $38,799 from EWEB
<br />
<br /> j 3 (1,220,888) (1,099,954) Hwy 99 xfr not earned in prior years
<br /> 5 (1,611,188)
<br /> 6 - -
<br /> 7 (5,300)
<br /> 13 1,220,888 1,099,954
<br /> 43990 Total 390,300 126 234 5,638,753 (5,638,753}
<br /> 47110 Interest On Investments 1 - -
<br /> 2 (1,365)
<br /> 3 (29,630) (53,570) (61,989)
<br /> 4 (2,385) (1,155)
<br /> 5 (2,477) (1,031)
<br /> 6 (30,780) (33,398} (50,150)
<br /> 7 (1,350)
<br /> 8 (2,225)
<br /> 9 (61,488) (36,388)
<br /> 10 (1,754)
<br /> 11 (1,523)
<br /> 12 (70,387) (2,936) -115;689 YTD per 6
<br /> 13 34,814 -100,000 $50Kx2
<br /> 47110 Total 192,285 ' 172,819 115,689 (215,000)
<br /> 48011 Transfer Frm General Fnd 1 -
<br /> 6 1,500,000
<br /> 48011 Total 1,500,000
<br /> 49900 Beginning Working Capital 1 _
<br /> 6 -
<br /> 49900 Total
<br /> 47111 Int on Investments FMV Ad' 2 9,700 -
<br /> 47111 Total 9,700
<br /> 47990 Other Revenue 5 (10,400)
<br /> 7 160 (160)
<br /> 47990 Total 10 400 160
<br /> 47920 Donations 6 197
<br /> 47920 Total 197
<br /> 47991 Billing Clearing Account 8 (8,779)
<br /> 9 8,779
<br /> 47991 Total
<br /> Grand Total (5,704,806) (3,393,255) (6,694,739) {8,853,913)
<br /> SQL
<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_MASTER.FUND_CODE, GL MASTER.BUDGET AMOUNT, GL MASTER.DEPT_CODE,
<br /> GL_MASTER.PROGRAM_CODE, GL MASTER.PROJECT ID
<br /> FROM QUERY GL.dbo.GL_A000UNT GL_ACCOUNT, QUERY GL.dbo.GL_MASTER GL_MASTER
<br /> WHERE GL MASTER.ACCOUNT=GL_ACCOUNT.ACCOUNTAND((GL_MASTER.FISCAL_YEAR>'2001')
<br /> AND (GL MASTER.FUND_CODE='133')AND (GL_MASTER.A000UNT Like'4%'))
<br /> _
<br />
<br />
|