The URL can be used to link to this page

FY 2007 Budget AmendmentTHE CITY OF Dus E MEMORANDUM April 30, 2007 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2007 Second Budget Amendment Budget Director Jenny Larson is recommending adoption of the Fiscal Year 2007 Second Budget Amendment. The amendment totals $13,930,742 in additional appropriation authority and an increase in resources of $13,634,333. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2007 budget was adopted in November 2006 and adjustments to reflect the amended Community Development Annual Plan. This amendment also reflects reappropriations of completed or cancelled projects to fund increased operating and capital expenses and includes some budget carryovers from FY 2006 excluded from the first budget amendment. I concur with the recommendation and respectfully request Mayor and City Council approval. ,~ V ,' " ~~ Michael C. Van Milligen MCVM/jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jenny Larson, Budget Director THE CITY OF DuB E MEMORANDUM April 12, 2007 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2007 Second Budget Amendment Budget Director Jenny Larson is recommending that a public hearing be set for May 7, 2007 on a second amendment to the Fiscal Year 2007 budget with amendment totals of $13,930,742 in additional appropriation authority and an increase in resources of $13,634,333. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2007 budget was adopted in November 2006 and adjustments to reflect the amended Community Development Annual Plan. This amendment also reflects reappropriations of completed or cancelled projects to fund increased operating and- capital expenses and includes some budget carryovers from FY 2006 excluded from the first budget amendment. I concur with the recommendation and respectfully request Mayor and City Council approval. ('~ Michael C. Van Milligen MCVM/jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Jenny Larson, Budget Director rxs crrY o~ DUB E ~-~~ MEMORANDUM April 10, 2007 TO: Michael C. Van Milligen, City Manager FROM: Jenny Larson, Budget Director ~,'' SUBJECT: Fiscal Year 2007 Second Budget Amendment The purpose of this memorandum is to present a summary of the action items approved by City Council throughout the year subject to a future budget amendment and to set the public hearing date for the formal budget amendment process as required by Section 384.16 of the Code of Iowa. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2007 budget was adopted in November 2006 and adjustments to reflect the amended Community Development Annual Plan. This amendment also reflects reappropriations of completed or canceled projects to fund increased operating and capital expenses and includes some budget carryovers from FY 2006 excluded from the first budget amendment. Interfund transfers of $6,540,817 are also included. The amendment totals $13,930,742 in additional appropriation authority and an increase in. resources of $13,634,333. Additional revenues added in this amendment with offsetting appropriations are: "` Vision Iowa State Grant ($5,000,000) for DCHS Rivers to the Sea Exhibit, * Federal Tier 2 Grant ($3,037,802} for Transient Boat Docks, '` Dubuque County Historical Society Private Contribution ($1,250,000) for match of Vision Iowa Grant, * Diamond Jo Private Contribution ($1,685,000) for Port of Dubuque Parking Ramp, * Dubuque Industrial West Land Sales ($934,177) for General Fund TIF recovery, * Dubuque Industrial Center West -Theisen. TIF Notes Proceeds ($713,989) for Theisen development, * Assistance to Firefighters Grant ($429,200) for Mobile Data Terminals & Wireless. Network, Dubuque Technology Paris South ($384,807) for Sanitary Sewer TIF recovery, State Grant ($241,347) for Airport radar display, GO Bond Proceeds ($235,468) for Sewer extensions new development, * State REAP Grant ($200,000) for NW Hike/Bike Trail, '` Federal Emergency Assistance Funds ($195,253) for University Ave. Embankment, * Federal Grant ($148,500) for Dubuque History Trail, * DCHS Private Contribution ($149,000) for match on Dubuque History Trail grant, and * Federal HSPG Grant ($55,250) for White Water Creek Bridge. Through the FY 2008 budget process, items were identified to be amended in FY 2007. The Transit Division has determined that the City is not eligible for fixed route bus replacements until FY 2010 and paratransit replacement vehicles until FY 2009. This amendment cancels two capital projects for purchasing frxed route and paratransit replacement vehicles and their associated FTA funds which are rebudgeted in the FY 08-- 12 capital budget. This amendment also cancels the appropriation for the design of the Bunker Hill Golf Course Renovation project ($50,000) which is rebudgeted in the FY 08-12 capital budget. Through this amendment, an additional $100,000 is added from Gunite Rock Storm Sewer to the Problem Properties Management capital project to purchase homes for the Washington Revitalize program. The Economic Development Administration grant for the rehabilitation of the former Adams Company building expired in December and this amendment removes the remaining grant receivable and expenditure (-$297,181). The Federal Building utility appropriations increased $81,937 to reflect actual cost of operating the building and are offset by lease revenue. In addition, $1,935,058 from General Fund balance is added through this amendment to the Federal Building Renovation capital project. The City Council approved the purchase of new parking .gate equipment ($567,000} to be purchased from the Parking Construction fund balance which is included in this amendment. Also approved by City Council is a new Assistant City Manager position in the City Manager office. This amendment adds the appropriation for this position ($43,556). The action step is for City Council to adopt the attached resolution setting the public hearing date for the formal budget amendment process as required by State law. The attached resolution authorizes the City Clerk to publish notification for a public hearing to be held May 7, 2007. Attachments JML RESOLUTION NO. -07 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2006 BUDGET FOR THE CITY OF DUBUQUE Whereas, Iowa Code Section 384.16 provides that the City Council shall set a time and place for a public hearing on amendments to the budget and publish notice before the hearing as provided in Iowa Code Section 362.3. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF DUBUQUE, IOWA: Section 1. That the City Council shall conduct a public hearing on proposed Amendment No. 2 to the Fiscal Year 2007 budget for the City of Dubuque at the Carnegie Stout Public Library Auditorium, 360 West 11th Street, Dubuque, Iowa, on Monday, May 7, 2007, beginning at 6:30 p.m. Section 2. That the City Clerk be and is hereby authorized and directed to publish notice of the public hearing, according to law, together with the required budget information. Passed, approved and adopted this 16th day of April 2007. Roy D. Buol Mayor Attest: Jeanne F. Schneider City Clerk NOTICE OF PUBLIC HEARING AMENDMENT OF CURRENT CITY BUDGET Form 653.C7 The City Council of Dubuque in DUBUQUE County, Iowa will meet at Carnegie Stout Public Library at 6:30 pm on May 7, zoos (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2007 (year) by changing estimates al revenue and expenditure appropriations in the fallowing programs for the reasons given. Additional detail is available at the city dark's office strowing revenues and expendtures by fund type and by activity. Total Budget as certified or last amended Current Amendment Total Budget aRer Current Amendment Revenues 8 Other Financing Sources Taxes Levied on Property 1 ~ 16,420,969 ~~ ~ :~:~0 ~.16,420,969 Less: Uncolleclted Property Taxes-Levy Year 2 0 0 0 Net Current Property Taxes 3 16,420,969 0 16,420,969 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 4,296,807 34,645 4,331,452 Other City Taxes 6 10,737,123 0 10,737,123 Licenses 8 Permits 7 3,167,556 0 3,167,556 Use of Money and Property 8 16,244,932 81,937 16,326,869 Intergovernmental 9 36,017,861 8,113,154 44,131,015 Charges for Services 10 22,645,509 0 22,645,509 Special Assessments 11 1,467,923 0 1,467,923 Miscellaneous 12 5,456,844 4,455,140 9,911,984 Other Financng Sources 13 37,362,538 7,490,274 44,852,812 eta evenuea an er urces E:nendihlres b Other Financing Uses Public Safely 15 ~~ . ~20,707,ti40 .~. 45,361 ~~~20,753,001 Public Works 16 10,934,582 29,364 10,963,946 Health and Social Services 17 986,433 10,300 996,733 Culture and Recreation 1 B 8,267,661 0 8,267,661 Community and Economic Development 19 8,633,021 764,789 9,397,810 General Government 20 5,051,788 137,600 5,189,388 Debt Service 21 3,136,728 0 3,136,728 Capital Projects 22 42,733,297 13,680,320 56,413,617 eta mment iw ies i ures Business Type /Enterprises 24 51,682,572 -736,992 50,945,580 eta ov a es usrness pen rturea 152,133,722 13,930,742 166,064,464 Transfers Out 26 31,148,450 6,540,817 37,689,267 Total ExpendituresJTrensfers Out 27 183,282,172 20,471,559 203,753,731 Excess Revenues d Other Sources Over (UnderjEzpenditurea/TnnsfersOutforFiscalYear 28 .~.~~-29,464,110 . ~..~~-296,409 ~.-29,760,519 Continuing Appropriatlon 29 0 WA 0 Beginning Fund Balance July 1 30 40,188,258 0 40,188,258 Ending Fund Balance June 30 31 10,724,148 -296,409 10,427,739 Explanation al increases or decreases in revenue estimates, appropriations, or available cash This amendment adds additional revenue from grants received, private funding, and the appropriation to spend the monies. Adjustments to railed the amended Community Development Annual Plan budget are inducted along with savings from completed or cancelled projects and available cash balarxx+ is used to fund increased operetions and capital projects. There will be no increase in tax levies to be paid in the wrreM fiscal year named above. Any increase in expenditures set out above will be met from the increased non-property tax revenues and cash balances not budgeted Or considered in this current budget. This will provide for a balanced budget. City Clerk ~~ ', CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION To the Auditor of DUBUQUE County, Iowa: The City Council of Dubuque in said County/Counties met on May 7, 2007 ,at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as to publication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against the amendment. The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any. thereupon, the following resolution was introduced. RESOLUTION No. 261-~7 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE : 2007 (AS AMENDED LAST ON November 6, 2006 .) Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published and the public hearing held, May 7, 2007 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Total Budget as certified or last amended Current Amendment Totat Budget after Current Amendment 'n Sources r Financr nues 8 Othe Reve 9 ~ ~~~ ~ ~ ~ .... Taxes Levied on Property 1 16,420,969 0 16,420,969 Less: Uncollectted Property Taxes-Levy Year 2 0 0 0 Net Current Property Taxes 3 16,420,969 0 16,420,969 Delinquent Property Taxes 4 0 0 0 TIF Revenues 5 4,296,807 34,645 4,331,452 Other City Taxes 6 10,737,123 0 10,737,123 Licenses 8 Permits 7 3,167,556 0 3,167,556 Use of Money and Property 8 16,244,932 81,937 16,326,869 Intergovernmental 9 36,017,861 8,113,154 44,131,015 Charges for Services 10 22,645,509 0 22,645,509 Special Assessments 11 1,467,923 0 1,467,923 Miscellaneous 12 5,456,844 4,455,140 9,911,984 Other Financing Sources 13 37,362,538 7,490,274 44,852,812 Total Revenues andOtharSources 14 153,818,062 20,175,150 173,993,212 in acs r Fin nc U nditures 8 Othe a Ex 9 . ~ . Public Safety 15 20,707,640 45,361 20,753,001 Public Works 16 10,934,582 29,364 10,963,946 Health and Social Services 17 986,433 10,300 996,733 Culture and Recreation 18 8,267,661 0 8,267,661 Community and Economic Devebpment 19 8,633,021 764,789 9,397,810 GeneralGovemment 20 5,051,788 137,600 5,189,388 Debt service 21 3,136,728 0 3,136,728 Capital Projects 22 42,733,297 13,680,320 56,413,617 Total Government Activities 6cpenditures 23 100,451,150 14,667,734 115,118,884 BusinessTypelEnterprises 24 51,682,572 -736,992 50,945,580 Total Gov Activities & Business Expenditures 25 152,133,722 13,930,742 166,064,464 Transfers Out 26 31,148,450 6,540,817 .37,689,267 Total Expendkures/TransfersOut 27 183,282,172 20,471,559 203,753,731 v r r rtes O e n s & Othe Sou Reve ue Excess (Under) ExpenditureslTransfers Out Fiscal Year 28 29,464,110 296,409 . . -29,760,519 Continuin Appropriation 29 0 NIA 0 Beginning Fund Balance July 1 30 40,188,258 0 40,188,258 Ending Fund Balance June 30 31 10,724,148 -296,409 10,427,739 Passed this 7th ~" roerl Signatu2 City Clerk/Finance Officer day of Ma , 2007 learurwa Signature Mayor NOTICE OF PUBLIC HEARING Fermssa.ci AMENDMENT OF CURRENT CITY BUDGET The City Council of Dubuque in DUBUQUE will meet at Carnegie Stout Public Library at 6:30 pm on May 7, 2007 m~~ r~•~ ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2007 ~~, by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given. Additional detail is available at the city Gerk's office showing revenues and expenditures by fund type and by activity. Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues 8 Other Financing Sources Taxes Levied on Property t ~. ~ ~~16,420,969 ~ ~ ~~~~ ~16 420969 Less: Uncolledted Pro Taxes-Le Year 2 0 Net Current Pro Taxes 3 16,420 969 0 16 420 969 Delinquent Property Taxes 4 0 0 TIF Revenues 5 4,296,807 34,645 4 331,452 otherci Taxes s 10,737123 0 10,737,123 Licenses & Permits ~ 3 167 556 0 3,167,556 Use of Money and Properly s 16,244,932 81,937 16 326,869 Inte vemmental s 36,017,861 8,113,154 44131,015 Charges for Services to 22,645,509 0 22 645 509 Special Assessments t 1 1,467,923 0 1,467,923 Miscellaneous t2 5,456,844 4,455,140 9,911,984 otherFinand sources t3 37,362,538 7,490,274 44 852 812 Total Revenues and other Sources t4 153,818,062 20,175 150 173 993 212 Ex itures 8 Other Financing Uses cend Public Safe t5 ~ ~ 20,707,640 .~ ~ ~ ~ 45,361 .~~ ~ ~ 20 753,001 Public works is 10,934,582 29,364 10 963 946 Heatih and Social Services 17 986,433 10,300 996,733 Culture and Recreation t8 8,267,661 0 8 267,661 Community and Economic Devebpment is 8,633,021 764,789 9 397 810 General Government 20 5,051,788 137,600 5,189,388 Debt Service 2t 3,136,728 0 3,136,728 Ca ital Pro 22 42,733,297 13 680,320 56 413 617 Total Government Activities Expenditures 23 100,451,150 14,667,734 115 118 884 BusinessT /Ente rises 2a 51,682,572 -736,992 50,945,580 Total Gov Actlvffies 8 Business Expenditures 25 152 133,722 13 930 742 166,064,464 Transfers Out 2s 31,148,450 6,540 817 37,689,267 Total Ex ndituresrriansfersOut 27 183,282,172 20,471,559 203,753,731 Exeess Revenues 6 Other Sources Over under Ex ndkuresrrransfars Out Fiscal Year 2s ~ -29,464,110 , ~ ~"~-296,409 ~~ ~ ~-29,760 519 Continuin A ro nation 2s N/A 0 Beginni Fund BalanceJu 1 30 40,188,258 40,188,258 Endin Fund Balance June 30 31 10,724,148 -296,409 10427,739 Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds additional revenue from grants received, private funding, and the appropriation to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are inGuded along with savings from completed or cancelled projects and available cash balance is used to fund increased operations and capital projects. There will be no increase in tax levies to be paid in the current fiscal year named above. Any increase in expenditures set out above will be met from the increased non-properly tax revenues and cash balances not budgeted or considered in this current budget. This will provide for a balanced budget. City Clerk/ Finance Officer Name CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT #2 State Department Program Description Engineering Trans29 Transfer to DRA Fund -Utility Franchise Analysis Engineering Trans30 Transfer from Sales Tax Const. -City Hall Maint./Remodel Engineering Trans30 Transfer to Parking Const. Fund -Renovation of City Hall Pkg City. Manager Trans3l Transfer to General -City Manager -Part-time employees City Manager Trans3l Transfer from UDAG -Community Marketing Parking Division Trans32 Transfer to Parking Fund from General Fund -Debt Service Parking Division Trans32 Transfer to Parking Fund from General Fund -Debt Service Water Pollution Control Trans33 Increase Trans from Operating to WPC Const. Fd Water Pollution Control Trans33 Increase Trans from Operating to WPC Const. Fd Water Pollution Control Trans34 Reduce Trans from Bond Proceeds to WPC Const. Fd Water Pollution Control Trans34 Reduce Trans from Bond Proceeds to WPC Const. Fd Public Works Trans35 Transfer from DMASWA -General -Truck Replacement Public Works Trans35 Transfer to RUT fund -Truck Replacement Engineering Trans36 Increase Trans from Operating to Storm Const. Fd Engineering Trans36 Increase Trans from Operating to Storm Const. Fd Parking Division Trans37 Increase Trans from Operating to Parking Const. Fd Parking Division Trans37 Increase Trans from Operating to Parking Const. Fd Parking Division Trans38 Cancel Trans from Greater Downtwon Tif Fund -Debt Service Parking Division Trans38 Cancel Trans from Greater Downtwon Tif Fund -Debt Service Economic Devlopmt Trans39 Trans DICW TIF to General for Cost Recovery Economic Devlopmt Trans39 Trans DICW TIF to General for Cost Recovery Economic Devlopmt Trans40 Trans Kerper TIF to RUT for Cost Recovery Economic Devlopmt Trans40 Trans Kerper T[F to RUT for Cost Recovery TOTAL TRANSFERS GRAND TOTAL WITH TRANSFERS 10-Apr-07 FY 07 FY 07 Expense Revenue Activity / Amount Amount Fund CIP Account Explanation 27,986 100 10010100 91102 Trans funds 51,473 730 7301843 59350 Trans funds 51,473 350 35010350 91730 Trans funds 7,500 265 2651842 91100 Increased hours for grants 7,500 100 10072100 59265 Increased hours for grants (52,159) 630 63046400 59101 Cancel transfer (52,159) 101. 10110101 91630 Cancel transfer 200,000 610 61010610 91710 Depreciation Fund Transfer Adj 200,000 710 71010710 59610 Depreciation Fund Transfer Adj (323,000) 440 44010440 91710 Reduce debt for projects (323,000) 710 71010710 59440 Reduce debt for projects 14,000 250 25054400 59940 Trans funds 14,000 940 94054200 91250 Trans funds 444,991 620 62010620 91720 Depreciation Fund Transfer Adj 444,991 720 72010720 59620 Depreciation Fund Transfer Adj 660,000 630 63010630 91730 Depreciation Fund Transfer Adj 660,000 730 73010730 59630 Depreciation Fund Transfer Adj (84,759) 240 24010240 91630 Cancel transfer for debt service (84,759} 630 63010630 59240 Cancel transfer for debt service 100,000 210 21060210 91100 TIF Transfer 100,000 100 10010100 59210 TIF Transfer 100,000 210 21060210 91100 TIF Transfer 100,000 100 10010100 59210 TIF Transfer 6,540,817 6,540,817 20,471,559 20,175,150 Page 9 CITY OF DUBUQCrE FISCAL YEAR 2007 AMENDMENT #2 FY 07 FY 07 State Expense Revenue Activity / Department Program Description Amount Amount Fund CIP Account Explanation Parks Division Transl5 Trans DRA Dist. To General -Ham House -Paint 2,442 102 10210102 91101 Trans funds Parks Division Transl5 Trans DRA Dist. To General -Ham House -Paint 2,442 101 1011212 59102 Trans funds Parks Division Transl6 Trans Sales Tax to General Fund-EPP Replacement Roofs 3,000 350 35010350 91100 Trans funds Parks Division Transl6 Trans Sales Tax to General Fund-EPP Replacement Roofs 3,000 100 1011584 59350 Trans funds Parks Division Transl7 Trans General Fund to DRA Dist. -EPP Toll Booth 40,000 101 10110101 91102 Trans funds Parks Division Transl7 Trans General Fund to DRA Dist. -EPP Toll Booth 40,000 102 1021759 59101 Trans funds Parks Division Transl8 Transfer to DRA Fund - Shiras Pavilion Improvements 15,014 350 35010350 91102 Trans funds Parks Division Transl8 Transfer from Sales Tax Fund -EPP Stone Work 15,014 102 1021763 59350 Trans funds Parks Division Transl9 Transfer to DRA Fund - Riverfront Porch Improvements 344 350 35010350 91102 Trans funds Parks Division Transl9 Transfer from Sales Tax Fund -EPP Stone Work 344 102 1021763 59350 Trans funds Parks Division Trans20 Transfer to Amer. Riv Proj - A.Y. McDonald Pazk 19,816 350 35010350 91700 Trans funds Parks Division Trans20 Transfer from Sales Tax -EPP Stone Work 19,816 700 7001703 59350 Trans funds Parks Division Trans2l Transfer to General -Prescott School - Basketball/Scoreboard 1,500 101 10110101 91102 Trans funds Parks Division Trans2l Transfer from DRA Fund -Flora Horseshoe Courts 1,500 102 1021759 59101 Trans funds Recreation Division Trans22 Transfer from Sales Tax -Pools Electric Panels 8,000 100 1011030 59350 Trans funds Recreation Division Trans22 Transfer to General -Pools -Paint Pool Tanks 8,000 100 35010350 91101 Trans funds Library Department Trans23 Transfer from Pakking Const. -Library Parking 30,000 101 1011592 59730 Trans funds Parking Division Trans23 Transfer to General Fund -Major Maint. On Ramps 30,000 730 73010730 91101 Trans funds Airport Department Trans24 Transfer from PFC Fund -Radar Display System 12,702 390 3901862 59391 Trans funds Airport Department Trans24 Transfer to Airport Const. Fund -Radar Display System 12,702 391 39110391 91390 Trans funds Engineering Trans25 Transfer from Storm Sewer Fund -University Avenue 46,045 710 7101805 59720 Trans funds Engineering Trans25 Transfer to Sanitary Sewer Fund - Gunite Rock Storm 46,045 720 72010720 91710 Trans funds Engineering Trans26 Transfer from Storm Sewer Fund - NPDES 6,640 100 10055400 59720 Trans funds Engineering Trans26 Transfer to General Fund -Project Engineering 6,640 720 72010720 91100 Trans funds Engineering Trans27 Transfer from Sanitary Sewer Fund -General Sanitary Repairs 6,640 100 10055400 59710 Trans funds Engineering Trans27 Transfer to General Fund -Project Engineering 6,640 710 71010710 91100 Trans funds Engineering Trans28 Transfer from America's River Fund -Port of Dbq Outdoor 323,388 360 3601855 59700 Trans funds Engineering Trans28 Transfer to General Const. Fund - Port of DBQ Outdoor Plaza 323,388 700 70010700 91360 Trans funds Engineering Trans29 Transfer from General Fund -Utility Franchise Analysis 27,986 102 1021857 59100 Trans funds Page S 10-Apr-07 CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT II2 State Department Program Description TRANSFERS Transit Division Trans0l Paratransit Replacement Vehicles-Trans to Transit Transit Division Trans0l Paratransit Replacement Vehicles-Trans from General City Wide Trans02 Trans DRA Dist based on Actual FY06-Adj from budget City Wide Trans02 Trans DRA Dist based on Actual FY06-Adj from budget City Wide Trans03 Trans Capital Portion of Gaming based on Actual FY06 City Wide Trans03 Trans Capital Portion of Gaming based on Actual FY06 City Wide Trans04 Trans DRA Dist/Conf Ctr Savings Used for FY 06 City Wide Trans04 Trans DRA Dist/Conf Ctr Savings Used for FY 06 Economic Devlopmt Trans05 Trans from General Const. Fund to General -Land Sales Economic Devlopmt Trans05 Trans from General Const. Fund to General -Land Sales Economic Devlopmt Trans06 Trans from Dbq Tech. Park Fund to Sewer Fund -Land Sales Economic Devlopmt Trans06 Trans from Dbq Tech. Park Fund to Sewer Fund -Land Sales Housing & Comm Devl Trans07 Transferred from Storm -Gunite Rock Stonn Sewer Engineering Trans07 Transfer to General -Problem Properties Mgmt Housing & Comm Devl Trans08 Transferced from Storm Fund -Gunite Rock Storm Sewer Engineering Trans08 Transfer to General Fund -Housing Administration Economic Devlopmt Trans09 Mcgraw Hill Project -Land Sales Planning Services Trans09 Zoning Code Update -Unified Development Code Ewnomic Devlopmt Trans 10 Trans from Sewer Const. Fund to UDAG - On-site T[F repay Economic Devlopmt Trans 10 Trans to UDAG from Water Pollution Con. - On-site TIF repay Airport Department Trans 11 Rehab Pkg Lots 1,2 and 4 -Trans in Sales Tax Airport Department Transl l Terminal Frontage Rd Rehab-Trans in Sales Tax Engineering Transl2 Transfer from General Fund to Section 8 Engineering Transl2 Transfer from General Fund to Section 8 Engineering Trans 13 Transfer from General Fund -Federal Building Engineering Transl3 Transfer to General Fund -Federal Building Parks Division Trans 14 Trans Sales Tax to General Fund-Highway 20 Landscape Des. Parks Division Transl4 Trans Sales Tax to General Fund-Highway 20 Landscape Des. 10-Apr-07 FY 07 FY 07 Expense Revenue Activity / Amount Amount Fund CIP Account Explanation Transfer Out Transfer In (31,620) 600 6001223 59101 Cancel and Rebudget FY 09 (31,620) 101 10110101 91600. Cancel and Rebudget FY 09 8,888 102 10210102 91100 To cortect transfer 8,888 100 10010100 59102 To cortect transfer 1,187,433 101 10110101 91100 To cortect transfer 1,187;433 100 10010100 59101 To corcect transfer 1,760,331 100 10010100 91102 To correct transfer 1,760,331 102 10210102 59100 To correct transfer 934,177 100 10010100 59360 Trans funds 934,177 360 3601481 91100 Trans funds 384,807 710 71010710 59225 Trans funds 384,807 225 22560225 91710 Trans funds 100,000 101 1011002 59720 Trans funds to Washington Revite 100,000 720 72010720 91101 Trans funds to Washington Revite 5,000 100 10061100 59720 Trans funds to Wash. Revite charette 5,000 720 72010720 91100 Trans funds to Wash. Revite charette 60,000 360 36010360 91100 Funding Mcgraw Hill Impr & UDC 60,000 100 1001551 59360 From Mcgraw Hill Land Sales 225,023 710 71010710 91265 Reapply FY05/06 TIF repay to UDAG 225,023 265 26510265 59710 Reapply FY05/06 TIF repay to UDAG 86,400 350 35010350 91390 C/O 86,400 390 3901037 59350 C/O 71,500 100 1001841 91280 To replace Section 8 with General 71,500 280 28061600 59100 To replace Section 8 with General 71,500 100 1001841 91100 To replace Section 8 with General 71,500 100 10010100 59100 To replace Section 8 with General 15,815 350 35010350 91100 Trans funds 15,815 100 1001114 59350 Trans funds Page 7 CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT #2 State Department Program Description SANITARY SEWER CONSTRUCTION FUND City Manager 8C GIS Enhancements -Software Engineering 8C Sewer Extensions New Development -Construction Engineering 8C Sewer Extensions New Development - GO Bond Proceeds Engineering 8C University Avenue Sanitary Sewer Reconst. -Construction Engineering 8C Comprehensive Sanitary Sewer Master Plan -Consultant Engineering 8C I & I Reduction Program -Construction Engineering 8C General Sanitary Sewer Repairs -Survey Equipment Water Pollution Control 8C Replace Pump Electrical/Cedar St Pump Station Water Pollution Control 8C Dog Track Lift Station -Construction Water Pollution Control 8C Annexation Middle Road -Engineering Services Water Pollution Control 8C Annexation Middle Road - Constmction TOTAL SANITARY SEWER CONST FUND STORM WATER CONSTRUCTION FUND Engineering 8C Gunite Rock Storm Sewer -Construction Engineering 8C Gunite Rock Storm Sewer -Construction Engineering 8C Custer/Allison Henderson Sewer and Detention Basin - Const. Engineering 8C Storm Sewer Improvements/Extensions - Conswction Engineering 8C University Avenue Culvert Extension -Construction Engineering 8C Gunite Rock Storm Sewer -Construction Engineering 8C NPDES Program -Survey Equipment TOTAL STORM WATER CONST FUND PARKING CONSTRUCTION FUND City Manager 8C GIS Enhancements -Software Engineering 8C Renovation of City Hall Parking Lot -Construction Library Department 8C Major Maintenance on Ramps -Construction Parking Division 8C Major Maintenance on Ramps -Equipment Acquisition Parking Division 8C Parking Equipment -Equipment Acquisition TOTAL PARKING CONSTRUCTION FUND WATER CONSTRUCTION FUND City Manager 8C GIS Enhancements -Software TOTAL WATER CONSTRUCTION FUND 10-Apr-07 FY 07 FY 07 Expense Revenue Activity / Amount Amount Fund CIP Account Explanation 2,254 710 7101946 71123 Prespent FY 2008 appropriation 235,468 710 7101350 73510 Increase appropriation 235,468 710 7101350 54210 Increase GO Bond Proceeds . 46,045 710 7101805 73211 Shift from Gunite Rock Storm Sewer 13,986 710 7101644 62716 Shift from I & I Reduction Program (13,986) 710 7101294 73211 Shift to Comp. Sanitary Sewer Master (6,640) 710 7101289 71412 Shift to Project Engineering -Equip. 140,000 710 7101291 73211 Shift from Dog Track Lift Station (140,000) 710 7101731 73211 Shift to Cedar St. Pump Station (53,562) 710 7101731 73211 Cancel &rebudget FY 09 (359,988) 710 7101731 73211 Cancel &rebudget FY 09 (136,423) 235,468 (100,000) 720 7201363 73510 To fund Washington Revite Project (5,000) 720 7201363 73510 To fund Washington Revite charette 12,625 720 7201376 73211 Shift from Storm Sewer Improv. (12,625) 720 7201008 73211 Shift to Custer/Allison Henderson 32,133 720 7201811 73211 Shift from Gunite Rock Storm Sewer (78,178) 720 7201363 73211 Shift from Gunite Rock Storm Sewer (6,640) 720 7201355 71412 Shift to Project Engineering -Equip. (157,685) 2,254 730 7301946 71123 Prespent FY 2008 appropriation 51,473 730 7301843 73210 Shift from City Hall Maint/Remodel (30,000) 730 7301385 73210 Shift to Library Parking 3,215 730 7301385 72417 Increase appropriation -Sec. Cameras 567,000 730 7301958 73410 Cash balance per Council 593,942 - 2,254 740 7401946 71123 2,254 - GRAND TOTAL AMENDMENT #2 13,930,742 13,634,333 Page 6 Prespent FY 2008 appropriation CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT #2 10-Apr-07 FY 07 FY 07 State Expense Revenue Activity / Department Program Description Amount Amount Fund C1P Account Explanation Parks Division 4C Eagle Point Park Stone Work-Construction (15,358) 350 3501677 73211 Shift to EPP - Shiras Pavilion Parks Division 4C Eagle Point Park Stone Work-Construction (19,816) 350 3501677 73211 Shift to EPP - Riverfront Porch Imp. Recreation Division 4C Pools -Electric Panels -Construction (8,000) 350 350.1684 73211 Shift to Pools -Paint Pool Tanks TOTAL SALES TAX FUND 2,924,340 3,037,802 GENERAL CONSTRUCTION FUND Economic Devlopmt SC Dbq Industrial Center West -Land Sales 934,177 360 3601481 54105 Record Land Sales Engineering 2C Port of Dubuque Outdoor Plaza Phase 1 -Construction 323,388 360 3601855 73210 Shift from Port of Dbq Utilities/Eiber Engineering 2C Port of Dubuque Pazking Ramp -Private Contribution 1,685,000 360 3601957 53102 Project started early Engineering 2C Port of Dubuque Parking Ramp -Architectural Services 1,150,000 360 3601957 62711 Project started early Engineering 2C Port of Dubuque Parking Ramp -Construction 535,000 360 3601957 73211 Project started early TOTAL GENERAL CONSTRUCTION FUND 2,008,388 2,619,177 AIRPORT CONSTRUCTION FUND Airport Department 2C Radar Display Grant 241,347 390 3901862 44105 New Grant Airport Department 2C Radar Display Grant -Equipment Acquisition 254,049 390 3901862 72113 New grant appropriation Airport Department 2C Small T-Hanger Replacement/Removal -State Grant 71,107 390 3901689 45701 C/O TOTAL AIRPORT CONSTRUCTION FUND 254,049 312,454 REFUSE FUND Public Works 8 Refuse Collection -State Grant 26,550 670 67054500 45701 New Grant Public Works 8 Refuse Collection -State Grant -Computer equipment 11,000 670 67054500 71120 New grant appropriation Public Works 8 Refuse Collection -State Grant -Engineering Consulting 15,000 670 67054500 62712 New grant appropriation Public Works 8 Refuse Collection -State Grant -Office Supplies 100 670 67054500 62010 New grant appropriation Public Works 8 Refuse Collection -State Grant -Printing & Binding 100 670 67054500 62090 New grant appropriation Public Works 8 Refuse Collection -State Grant -Postage & Shipping 350 670 67054500 62030 New grant appropriation Public Works 8 Refuse Collection -Printing & Binding (1,200) 670 67054500 62090 Shift to safety apparel Public Works 8 Yard Waste Collection -Printing & Binding (220) 670 67054510 62090 Shift to safety apparel Public Works 8 Recycling Collection Program -Promotion (1,080) 670 67054530 62140 Shift to safety apparel Public Works 8 Refuse Collection -Safety Equipment 1,200 670 67054500 61640 Shift from printing & binding Public Works 8 Yard Waste Collection -Safety Equipment 220 670 67054510 61640 Shift from printing & binding Public Works 8 Recycling Collection Program -Safety Equipment 1,080 670 67054530 61640 Shift from promotion TOTAL REFUSE FUND 26,550 26,550 AMERICA'S RIVER PROJECT FUND Civic Center Division 8C Five Flags Renovation -Miscellaneous Revenue 30,156 700 7001044 53605 Record sale of dashier boards Civic Center Division 8C Five Flags Renovation -Construction 30,156 700 7001044 73211 Increase appropriation Engineering 8C Ice Harbor/Port of Dbq Utilities -Construction (109,000) 700 7001050 73211 Shift to Port of Dbq Outdoor Plaza Engineering 8C Port of Dubuque Existing Lots -Construction (45,945) 700 7001521 73211 Shift to Port of Dbq Outdoor Plaza Engineering 8C Port of Dubuque Fiber Optics -Construction (76,166) 700 700151 I 73211 Shift to Port of Dbq Outdoor Plaza Engineering 8C Conference Center -Savings (92,277) 700 7001052 73210 Shift to Port of Dbq Outdoor Plaza Parks Division 4C AY McDonald Park -Construction 22,816 700 7001703 73211 Shift from EPP Stone Work Parks Division 4C AY McDonald Park -Private Participation Revenue 3,000 700 7001703 53102 To record private participation revenue TOTAL AMERICA'S RIVER PROJECT (270,416} 33,156 Page 5 CITY OF Dt1BUQUE FISCAL YEAR 2007 AMENDMENT #2 State Department Program Description SWISS VALLEY -TIF FUND Economic Devlopmt 5 Swiss Valley TIF-Swiss Valley Rebate TOTAL SWISS VALLEY -TIF FUND ROAD USE TAX FUND Public Works 2 Street Maintenance -Truck Replacement TOTAL ROAD USE TAX FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Economic Devlopmt SC CDBG - Commercial/Industrial Building Rehab -Loans Economic Devlopmt SC CDBG -Economic Development Loan Program -Loans Health Services 3 CDBG -Health Services Administration -Deer Mgmt Food Housing & Comm Devl 5 CDBG -Housing Administration -Desks/Chairs Housing & Comm Devl 5 CDBG -Housing Administration -Miscellaneous Services Housing & Comm Devl 5 CDBG - Admin/Monitoring -Desks/Chairs Housing & Comm Devl SC CDBG -Residential Rehab Program -Construction Housing & Comm Devl SC CDBG -Residential Rehab Program -Loans Housing & Comm Devl SC Housing Trust-Iowa Finance Authority -Loans Human Rights 3 CDBG -Human Relations -Promotion TOTAL CDBG FUND UDAG FUND Economic Devlopmt SC Community Marketing -Consultant Services TOTAL UDAG FUND STREET CONSTRUCTION FUND FY 07 Expense Amount 649 10-Apr-07 FY 07 Revenue Activity / Amount Fund CIP Account Explanation 649 249 24960249 62761 TIF Rebate 14,000 250 25054400 71314 Shift from Landfill 14,000 - 220,000 260 2601746 62764 CDBG Amend#2 (200,000) 260 2601235 62764 CDBG Amend#2 (700) 260 26017100 62761 CDBG Amend#2 (1,551) 260 26061100 71211 CDBG Amend#2 (114) 260 26061100 62731 CDBG Amend#2 (4,711) 260 26061800 71211 CDBG Amend#2 (187,378) 260 2601065 73210 CDBG Amend#2 187,378 260 2601065 62764 CDBG Amend#2 50,000 260 2601021 62764 CDBG Amend#2 (1,000) 260 26016100 62140 CDBG Amend#2 61,924 - (7,500) 265 (7,500) - 2651842 62716 Shift to City Manager -Part-Time Emp. Engineering 2C University Ave. Embankment Stabilization Proj.-FHWA Funds 195,253 300 3001080 44170 New Federal Funding Engineering 2C University Ave. Embankment Stabilization Proj.-Construction 195,253 300 3001080 73211 Associated Appropriation Engineering 2C White Water Creek Bridge - HSPG Grant 55,250 300 3001634 45701 New Grant Engineering 2C White Water Creek Bridge -Construction 120,500 300 3001634 73211 New grant appropriation Engineering 2C White Water Creek Bridge -Private Contribution 10,000 300 3001634 53102 Private contribution Engineering 2C Bridge Repairs/Maint -Construction (55,250) 300 3001258 73211 Shift to White Water Creek Bridge TOTAL STREET CONSTRUCTION FUND 260,503 260,503 SALES TAX FUND (20%1 Building Services 6C City Hall Maintenance/Remodel -Construction (51,473) 350 3501045 73210 Shift to Renovation of City Hall Parking Engineering 2C Transient Boat Dock Facility -Main Channel 213,950 350 3501861 73211 Move from Dredging per Council Engineering 2C Transient Boat Dock Facility -Main Channel -Tier 2 Grant 3,037,802 350 .3501861 44170 New Grant Engineering 2C Transient Boat Dock Facility -Main Channel -Construction 3,037,802 350 3501861 73211 New grant appropriation Engineering 2C Ice Harbor Maintenance/Dredging (213,950) 350 3501466 73211 Move to Transient per Council Parks Division 4C Murphy Tennis Court Parking -Construction (15,815) 350 3501679 73211 Shift to Hwy 20 Landscape Design Parks Division 4C Eagle Point Park Stone Work-Construction (3,000) 350 3501677 73211 Shift to EPP Replacement Roofs Page 4 CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT #2 State Department Program Description 10-Apr-07 FY 07 FY 07 Expense Revenue Activity / Amount Amount Fund CIP Account Explanation Engineering 2C Utility Franchise Analysis -Legal Services 36,800 102 1021857 62713 Increase Appropriation Fire Department 1C Mobile Data Terminals & Wireless Network-Asst Fire Grant 429,200 102 1021755 44405 New Grant Parks Division 4C Tree Nursery -Install Walkway -Construction (2,442) 102 1021773 73210 Shift to Ham House -Paint Parks Division 4C EPP -Entry Road/Replace Toll Booth -Architectural Svcs. 40,000 102 1021759 62711 Shift from Flora Storm Sewer Exten. Parks Division 4C EPP - Riverfront Porch Improvements -Construction 344 102 1021762 73210 Shift from EPP Stone Work , Parks Division 4C EPP - Shiras Pavilion Improvements -Construction 15,014 102 1021763 73210 Shift from EPP Stone Work Parks Division 4C Prescott School - Basketball/Scoreboard Equipment Acq. (1,500) 102 1021772 73410 Shift to Flora Horseshoe Courts Parks Division 4C Bunker Hill Golf Course Renovation -Consulting Engineers (50,000) 102 1021785 62712 Cancel & rebudget FY 09 Parks Division 4C Washington Park Renovation -Private Participant 5,000 102 1021605 53102 Record private participation revenue Parks Division 4C Washington Park Renovation -Construction 5,000 102 1021605 73211 Increase appropriation TOTAL GENERAL FUND 8,363,049 6,619,437 TRANSIT FUND Transit Division 8 Bus Operations - ID Card System 3,677 600 60053400 72515 ID Card System Transit Division 8C Replace Fixed Route Buses -FTA Capital (489,275) 600 6001224 44150 Cancel and Rebudget FY 10 Transit Division 8C Replace Fixed Route Buses -Equipment (590,075) 600 6001224 73411 Cancel and Rebudget FY 10 Transit Division 8C Paratransit Replacement Vehicles-FTA Capital (154,380) 600 6001223 44150 Cancel and Rebudget FY 09 Transit Division 8C Paratransit Replacement Vehicles-Equipment (186,000) 600 6001223 73210 Cancel and Rebudget FY 09 TOTAL TRANSIT FUND (772,398) (643,655) DUBUOUE INDUSTRIAL CENTER WEST -TIF FUND Economic Devlopmt 5 Dbq Industrial Center West -Theisen TIF Interest Economic Devlopmt 5 Dbq Industrial Center West -Theisen TIF Note Payment Economic Devlopmt 5 Dbq Industrial Center West -Theisen TIF Note Proceeds Economic Devlopmt 5 DICW TIF-Walter Devl. Spec Bldg-Rebate Economic Devlopmt 5 DICW TIF-Walter Devl. Spec Bldg-Rebate TOTAL DICW-TIF FUND TECH PARK SOUTH -TIF FUND Economic Devlopmt SC Dbq Technology Park South -Land Sales TOTAL TECH PARK SOUTH -TIF FUND 6,239 210 21060210 74112 Theisen Supply TIF Note Interest 707,750 210 21060210 62764 Theisen Supply TIF Note Appropriation 713,989 210 21060210 54215 Theisen Supply TIF Note Proceeds 34,645 210 21060210 41205 Increased TIF revenue 34,645 210 21060210 62761 TIF Rebate 748,634 748,634 384,807 225 22560225 54105 Record Land Sales - 384,807 EAST 7TH STREET -TIF FUND Economic Devlopmt 5 East 7th St TIF-Morrison Rebate TOTAL EAST 7TH STREET -TIF FUND 16,882 230 23060230 62761 TIF Rebate 16,882 - Page 3 CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT #2 10-Apr-07 FY 07 FY 07 State Expense Revenue Activity / Department Program Description Amount Amount Fund CIP Account Explanation Housing & Comm Devl SC Housing Trust-Iowa Fannie Mae Partnership Grant 1,000 100 1001021 62765 Grant Appropriation Human Rights 3 Human Relations -Intercultural Competency Training 12,000 100 10016100 62360 Prespent FY 2008 appropriation Parks Division 4C Comiskey Lights Courts -Equipment Acquisition 12,345 100 1001544 73410 Shift from Miller-Riverview Exp. Parks Division 4C Miller-Riverview Expansion Study - Consulatant Services (10,345) 100 1001779 73210 Shift to Comiskey, Light Courts Parks Division 4C Comiskey Landscape -Landscape Contract (2,000) 100 1001105 73310 Shift to Comiskey, Light Courts Parks Division 4C Highway 20 Landscape Design -Landscaping Contract 15,815 100 1001114 73310 Shift from Murphy Tennis Ct. Parking Parks Division 4C EPP Replacement Roofs, Band Shell, & Log Cabin - Const. 3,000 100 1011584 73210 Shift from EPP Stone Work Parks Division 4C Dubuque History Trail -Federal Grant 148,500 100 1001956 44170 New Grant Parks Division 4C .Dubuque History Trail -Private Contribution 149,000 100 1001956 53102 DCHS Grant Match Parks Division 4C Dubuque History Trail -Consultant Services 29,750 100 1001956 62716 Associated Appropriation Parks Division 4C Dubuque History Trail -Equipment 267,750 100 1001956 73411 Associated Appropriation Planning Services 2C Rivers to the Sea Exhibit -Construction 5,625,000 100 1001856 73210 New grant appropriation Planning Services 2C Rivers to the Sea Exhibit -Consultant Services 625,000 100 1001856 62716 New grant appropriation Planning Services 2C Rivers to the Sea Ezhibit - IDOT Grant 5,000,000 100 1001856 45771 New Grant Planning Services 2C Rivers to the Sea Exhibit -Private Participation 1,250,000 100 1001856 53102 DCHS Grant Match Police Department 1 OWI Prevention Grant 6,900 100 10011769 44125 New Grant Police Department 1 OWI Prevention Grant -Overtime 6,900 100 10011769 61050 Associated Appropriation Police Department 1 Helping Services of NE Iowa Grant 7,256 100 10011324 45771 New Grant Police Department 1 Helping Services of NE Iowa Grant -Overtime 7,256 100 10011324 61051 Associated Appropriation Police Department 1 Governor Traffic Safety Bureau Grant 24,430 100 10011769 44125 New Grant Police Department 1 Governor Traffic Safety Bureau Grant -Overtime 6,930 100 10011769 61050 Associated Appropriation Police Department 1 Governor Traffic Safety Bureau Grant -Equipment 17,500 100 10011769 72218 Associated Appropriation Police Department 1 Byrne/Jag Grant-Pseud. Enforcement Grant -Overtime 4,275 100 10011321 61050 Associated Appropriation Police Department 1 Byrne/Jag Grant-Pseud. Enforcement Grant 4,275 100 10011321 44140 New Grant Police Department 1 Walmart Foundation Safe Neighborhood Heroes Grant 2,500 100 10011700 72417 Associated Appropriation Police Department 1 Walmart Foundation Safe Neighborhood Heroes Grant 2,500 .100 10011700 53102 New Grant Public Works 2C NW HikeBike Trail -ISTEA Grant related spending (415,380) 100 1001157 73211 ISTEA Grant not received Public Works 2C NW HikeBike Trail -ISTEA Grant (415,380) 100 1001157 44165 ISTEA Grant not received Public Works 2C NW HikeBike Trail -Recreation Trails Grant related spending 200,000 100 1001157 73211 New grant appropriation Public Works 2C NW HikeBike Trail -Recreation Trails Grant 200,000 100 1001157 45707 Iowa REAP Grant received Housing & Comm Devl SC Problem Properties Management-Demolition 100,000 101 1011002 73210 To fund Washington Revite Project Library Department 4C Library Parking 30,000 101 1011592 73110 Shift from Major Maint. On Ramps Parks Division 4C Ham House -Paint -Construction 2,442 101 1011212 73210 Shift from Tree Nursery -Walkway Parks Division 4C Flora Storm Sewer Extension -Construction (40,000) 101 1011211 73211 Shift to EPP Toll Booth Replacement Parks Division 4C Flora Horseshoe Courts -Construction 1,500 101 1011724 73211 Shift from Prescott Basketball/Scorebd. Police Department IC In Car Video Recorders-Traffic Safety Serv. Grant 10,500 101 1011580 44125 New Grant Police Department 1C In Car Video Recorders-Traffic Safety Serv. Grant 10,500 101 1011580. 73410 Associated Appropriation Police Department 1C In Car Video Recorders-Equipment (10,955) 101 1011580 73410 Recd Grant /Moved funds to buy Server Police Department 1 C Tape Library/Storage Area Network-Raw Storage Server 10,955 101 1011752 73410 From Car Video to buy Server Recreation Division 4C Pools -Paint Pool Tanks -Construction 15,350 101 1011030 73211 Shift from Recaulk Pool Decks Recreation Division 4C R&S -Recaulk Pool Decks -Construction (3,350) 101 1011098 73210 Shift to Pools -Paint Pool Tanks Recreation Division 4C Pools -Recirculation System -Construction (4,000) 101 1011590 -73211 Shift to Pools -Paint Pool Tanks City Manager 6C GIS Implementation 205,000 102 1021070 62716 Move to Correct Fund City Manager 6C GIS Enhancements -Software 2,254 102 1021946 71123 Prespent FY 2008 appropriation Page 2 CITY OF DUBUQUE FISCAL YEAR 2007 AMENDMENT #2 10-Apr-07 FY 07 FY 07 State Expense Revenue Activity / Department Program Description Amount Amount Fund CIP Account Explanation GENERAL FUND Building Services 6 Federal Building Maintenance -Office Supplies 160 100 10057520 62010 Record Operating Expenses Building Services 6 Federal Building Maintenance -Property Insurance 14,371 100 10057520 62206 Record Operating Expenses Building Services 6 Federal Building Maintenance -Boiler Insurance 504 100 10057520 62207 Record Operating Expenses Building Services 6 Federal Building Maintenance -Mileage 99 100 10057520 62340 Record Operating Expenses , Building Services 6 Federal Building Maintenance -Utility Expense -Gas 1,932 100 10057520 62412 Record Operating Expenses Building Services 6 Federal Building Maintenance -Utility Expense - Stotmwater 333 100 10057520 62415 Record Operating Expenses Building Services 6 Federal Building Maintenance -Utility Expense -Electricity 33,567 100 10057520 62411 Record Operating Expenses Building Services 6 Federal Building Maintenance -Telephone 2,134 100 10057520 62421 Record Operating Expenses Building Services 6 Federal Building Maintenance -Property Maintenance 44,412 100 10057520 62431 Record Operating Expenses Building Services 6 Federal Building Maintenance - Misc.Operating Supplies 11,137 100 10057520 62671 Record Operating Expenses Building Services 6 Federal Building Maintenance - Machinery/Equip. Maint. (18,748) 100 10057520 62611 Move to Property Maintenance Building Services 6 Federal Building Maintenance -Computer (550) 100 10057520 71124 Move to Property Maintenance Building Services 6 Federal Building Maintenance -Auto Replacement (3,480) 100 10057520 71310 Move to Property Maintenance Building Services 6 Federal Building Maintenance -Custodial Equipment (3,834) 100 10057520 71610 Move to Property Maintenance Building Services 6 Federal Building Maintenance -Telephone Related (100) 100 10057520 72418 Move to Property Maintenance Building Services 6 Federal Building Maintenance -Lease Revenue 81,937 100 10057520 43310 Record Additional Lease Revenue City Manager 6 National Community Development Association -Training Fee 1,500 100 10072400 53201 Training fee City Manager 6 Travel Conferences -Additional conference 1,500 100 10072400 62310 Associated Appropriation City Manager 6 Management -Part-time employees 23,450 100 10072100 61020 New position .City Manager 6 Management -Social Security 1,794 100 10072100 61320 New position City Manager 6 Management - IPERS 1,419 100 10072100 61310 New position City Manager 6 Management -Telephone 210 100 10072100 62421 New position City Manager 6 Management -Office Supplies 203 100 10072100 62010 New position City Manager 6 Management -Travel -Conferences 3;485 100 10072100 62310 New position City Manager 6 Management -Travel -City Business 5,015 100 10072100 62320 New position City Manager 6 Management -Dues & Memberships 500 100 10072100 62190 New position City Manager 6 Management -Micro-Computer 3,200 100 10072100 71124 New position City Manager 6 Management -Telephone Related 780 100 10072100 72418 New position City Manager 6 Management -Desks/Chairs 3,500 100 10072100 71211 New position City Manager 6 Management -Part-time employees 6,614 100 10072100 61020 Shift from Community Marketing City Manager 6 Management - IPERS 380 100 10072100 61310 Shift from Community Marketing City Manager 6 Management -Social Security 506 100 10072100 61320 Shift-from Community Marketing City Manager 6 Public Information/GIS -Micro-Computer 3,107 100 10072300 71124 Prespent FY 2008 appropriation City Manager 6C GIS Implementation (205,000) 100 1001070 62716 Move to Correct Fund Economic Devlopmt SC Port of DBQ-Property Acquisition/EDA Grant (Adams) (297,181) 100 1001043 44115 EDA grant expired Economic Devlopmt SC Port of DBQ-Property Acquisition-Reconstruction (297,181) 100 1001043 62731 EDA grant expired Engineering 2 Project Engineering - AutolJeep Replacement 2,084 100 10055400 71310 Increase appropriation Engineering 2 Project Engineering -Survey Equipment 13,280 100 10055400 71412 Shift from NPDES & Gen. San. Sewer Engineering 2C Federal Building Renovation -Consulting Engineers 214,991 100 1001841 62712 From General Fund balance Engineering 2C Federal Building Renovation -Construction 1,720,067 100 1001841 73210 From General Fund balance Health Services 3 Community Health.Bioterrorism Reimb. 10,000 100 10017400 45771 To record Bioterrorism grant Housing & Comm Devl 5 Housing Administration -Consulting Services 5,000 100 10061100 62716 To fund Washington Revile charette , Housing & Comm Devl SC Housing Trust-Iowa Fannie Mae Partnership Grant 1,000 100 1001021 45703 New Grant Page 1