Finance Committee Agenda and Packet 2012 04 16

Home Browse Search

positions in Human Resources to assist with coverage during heavy recruiting for seasonal/summer hiring as well as provide back-up for Human Resources staff during FMLA related absences. 010-321-53100-99 Professional Services – Other (+$10,000) This entire line item was erroneously reduced to zero during the 2012 budget process when it was determined that the City should buy a new fingerprint machine rather than pay maintenance on the current one. This budget restoration will be used for employment testing, evidence destruction, shredding, towing, Accurant Investigative Services, DFAR updates, and Leads Database Services. 010-520-51100-00 Regular Salaries (+$43,530) 010-520-51200-00 FICA Expense (+$3,330) 010-520-51210-00 Retirement Contribution (+$2,180) 010-520-51220-00 Health Insurance (+9,750) 010-520-53100-69 Professional Services – Comp Plan Update (-$58,790) Add budget for new Planner I position and reduce contract services for comprehensive plan update by an equal amount. 010-610-51210-00 Retirement Contribution (+$1,680) 010-610-51220-00 Health Insurance (+$7,310) Correction of budget error – adds employee benefit costs to Museum Services Division. 027-110-57402-00 Transfer to the Capital Projects Fund (+$300,000) 042-499-55310-42 McCaslin Dillon Intersection (+$300,000) Additional City costs fund the City Council selected alternative for this project, which was above and beyond the original scope of work. 028-799-55330-06 Trail Improvements (-$12,500) 028-799-55330-54 Boundary Treatments (-$19,500) 028-799-55330-76 Aquarius Parking Lot (+$32,000) Implements a reduction in the Trail Improvements and Boundary Treatments budget to help fund the Aquarius Parking lot project. 028-799-55330-78 Community Park Dog Pond Repairs (+$77,320) Increase budget due to expanded scope for more permanent solution. Bid awarded on March 20, 2012. 20 PAGE SEVEN 028-799-55XXX-XX Hecla Reservoir – Dam Improvements (+$160,000) Per the subdivision agreement the City is responsible for paying for certain improvements. The dam improvements will be completed by the developer and then the City will be billed. 028-799-55XXX-XX Water Conveyance to Harney Lastoka (+$55,500) Estimated total project cost $222,000. To be cost shared. The City would be responsible for 25%. 029-799-55330-59 Landscape Replacement Programs – Parks (+$14,600) Increase budget for RSSC Landscape Renovation construction contract. 029-110-53100-71 Professional Services – ADA Audit and Transition Plan (+$34,110) 029-799-55220-15 Restroom Improvement Program (-$25,000) Establish budget for new ADA Audit project and reduce Restroom Improvement Program to help fund new project. 033-540-53100-27 Professional Services – Survey (+$31,500) Increase budget for Austin Niehoff Historic Structure Assessment ($12,500) and Old Town Reconnaissance Survey ($19,000). 042-110-55200-21 Steinbaugh Pavilion Improvements (+$23,000) Bids for awning installation came in higher than budget for the base project and staff determined an electronic system would better suit the site which added additional costs. Costs and funding for the project were discussed with City Council at the April 17 Council meeting. 042-110-55xxx-xx Net Motion Hardware & Software (+$23,000) All of Boulder County’s public safety dispatch centers will convert to a new CAD system in about July 2012, and one of the significant attributes of the new system is increased capabilities of mobile computers. Unfortunately, the process for dispatch to communicate with the mobile computers is different from the current design and we have to purchase software and hardware to facilitate the change. Without the software, server, and equipment, the Louisville Police cars’ mobile computer capabilities will cease. 042-499-55310-05 Bridge Repairs (+$44,900) The 96th Street Bridge was evaluated for deficiencies in 2011 resulting in a report recommending additional monitoring and minor repairs. The additional amount will be put towards the 96th Street Bridge report recommendations and perform preliminary evaluation of County Road Bridge. SUBJECT: RESOLUTION NO. __, SERIES 2012, A RESOLUTION AMENDING THE 2012 BUDGET DATE: MAY 1, 2012 21 PAGE EIGHT SUBJECT: RESOLUTION NO. __, SERIES 2012, A RESOLUTION AMENDING THE 2012 BUDGET DATE: MAY 1, 2012 042-499-55xxx-xx South Boulder Road Pedestrian Crossing (+$100,000) This budget amendment represents costs required to install a Pedestrian Crossing at North End and South Boulder Road. This improvement is part of City related commitments from the approved Subdivision Improvement Agreement. 042-499-55xxx-xx US 36 Prepaid Kiosks – FASTER Contribution (+$11,650) New project – Louisville local match for FASTER application to fund 14 pre-paid kiosks along US 36 at each of the BRT stations (2 at each station). Louisville and Superior are each contributing $11,650 (pro-rated share) to fund the kiosks at the US 36/McCaslin Interchange BRT station. Westminster, Broomfield and Boulder are also contributing to match FASTER funds at the Sheridan, Wadsworth and Table Mesa Interchanges. 042-499-55xxx-xx McCaslin Entry Way Sign (+$17,000) New project – RTD has agreed to contribute funds ($8,000) towards the fabrication and installation of a new gateway sign to replace an existing gateway/concrete pier which will need to be relocated as part of RTD’s queue jump project to be constructed on the west bound off-ramp of the US 36 and McCaslin Boulevard Interchange. The new entry sign will be located at McCaslin Boulevard in the roadways’ center raised median, north of the westbound ramps of the US 36/McCaslin Boulevard Interchange. An additional $17,000 (total cost of $25,000) is requested to complete the fabrication and installation of the new entry sign. An agreement would need to be executed between the City and RTD to finalize. 042-499-55310-38 Highway 42 Station Area Master Plan (+$80,000) 042-499-55310-39 Highway 42 Corridor Study (+$150,000) Convert projects from net (of grant) cost to gross cost. 042-799-55330-16 Gateway Improvements (+$21,430) Landscaping and lighting for City entry sign at Hwy. 42 & Paschal Drive. Funding has already been received from Takoda Metropolitan District. 043-110-57042-10 Transfer to Capital Projects – Library (-$44,000) 043-110-57042-50 Transfer to Capital Projects – Transportation (+$107,500) 043-110-57042-60 Transfer to Capital Projects – Municipal Facilities (+$62,500) Adjust interfund transfers from the Impact Fee Fund to the Capital Projects Fund to the current projected maximum. 051-499-55450-22 Radio Signal Water Meters (+$5,180) Purchase of spare meter reading device. 22 PAGE NINE SUBJECT: RESOLUTION NO. __, SERIES 2012, A RESOLUTION AMENDING THE 2012 BUDGET DATE: MAY 1, 2012 Changes to 2012 Revenue Budget (Appendix C to the Resolution) 010-001-41200-00 Sales Tax (+$187,820) 028-001-41200-00 Sales Tax (+$34,660) 033-001-41200-00 Sales Tax (+$12,090) 042-001-41200-00 Sales Tax (+$93,910) Adjust Sales Tax revenue budget to 101% of 2011 actual. 010-001-41205-00 Use Tax – Consumer (+$32,020) 028-001-41205-00 Use Tax – Consumer (+$6,030) 033-001-41205-00 Use Tax – Consumer (+$2,010) 042-001-41205-00 Use Tax – Consumer (+$16,040) Adjust Consumer Use Tax revenue budget to 100% of 2011 actual. 010-001-41300-00 Franchise Tax – Xcel Energy (+$10,430) Adjust Franchise Tax budget to 101.5% of 2011 actual. 010-001-42110-00 Lodging Tax (+$7,140) Adjust Lodging Tax budget to 105% of 2011 actual. 010-001-44505-00 Rec Center Daily User Fees (-$30,600) 010-001-44530-00 Rec Center Swim Lessons (+$34,200) 010-001-44536-00 Rec Center Nite at the Rec (+$4,300) 010-001-44540-00 Rec Center Adult Activity – Fitness/Wellness (+$14,800) 010-001-44550-00 Rec Center Youth Sports Fees (+$9,700) 010-001-44555-00 Rec Center Adult Sports Fees (+$10,100) 010-001-44575-00 Senior Fees (+$10,960) 010-001-44600-00 Memory Square Swim Admission (+$6,400) 010-001-46140-00 Unclassified – Rentals (+$8,000) Adjust Recreation Center revenue budget items to 100% of 2011 actual, except for Daily User Fees, which are adjusted to 99% of 2011 actual. 010-001-45100-00 Court Fines (-$35,110) Adjust Court fines revenue budget to 98% of 2011 actual. 23 PAGE TEN SUBJECT: RESOLUTION NO. __, SERIES 2012, A RESOLUTION AMENDING THE 2012 BUDGET DATE: MAY 1, 2012 010-001-41200-01 Sales Tax – Business Assistance (+$21,060) 010-001-41205-01 Consumer Use Tax – Business Assistance (-$84,970) 010-001-42200-01 Building Permits – Business Assistance (-$21,790) 042-001-41205-01 Sales Tax – Business Assistance (+$10,530) 042-001-41205-01 Consumer Use Tax – Business Assistance (-$42,480) 042-001-41220-01 Building Use Tax – Business Assistance (-$27,120) Adjust Business Assistance “contra-revenue” budget to current estimate based on latest business assistance agreements. 033-001-43420-00 State Grant – Historical Fund (+$19,500) Grant for Austin Niehoff Historic Structure Assessment ($7,500) and grant for Old Town Reconnaissance Survey ($12,000). 042-001-43100-00 RTD Grant – Hwy 42 Station Area Master Plan (+$71,240) 042-001-43210-00 State Grant – Hwy 42/SBR (+$48,300) 042-001-43211-00 State Grant – Hwy 42 Corridor Study (+$117,670) 042-001-43220-00 State Grant – DRCOG – Traffic Signals (+$24,000) Update grant revenue budgets to current estimates for 2012. 042-001-43215-00 State Grant – McCaslin/Dillon (+$669,200) 042-001-43299-00 Grant Revenues – General (-$586,320) Reclassify grant for McCaslin/Dillon Interchange and update amount to latest estimate. 042-001-43299-00 Grant Revenues – General (+$8,000) Add RTD Grant for McCaslin Entry Way Sign. 042-001-48043-00 Transfer from Impact Fee Fund (+$126,000) Adjust interfund transfers from the Impact Fee Fund to the Capital Projects Fund to the current projected maximum. FISCAL IMPACT: The Finance Department has updated revenue, expenditure, and fund balance estimates for all funds based on the proposed budget adjustments in the attached resolution and other information. The following schedule summarizes those estimates for fiscal year 2012. 24 PAGE ELEVEN SUBJECT: RESOLUTION NO. __, SERIES 2012, A RESOLUTION AMENDING THE 2012 BUDGET DATE: MAY 1, 2012 25 PAGE TWELVE SUBJECT: RESOLUTION NO. __, SERIES 2012, A RESOLUTION AMENDING THE 2012 BUDGET DATE: MAY 1, 2012 RECOMMENDATION: To hold a public hearing and approve Resolution No. __, Series 2011 , amending the 2011 budget by amending appropriations in the General Fund, McCaslin Interchange Improvement Fund, Conservation Trust – Land Acquisition Fund, Conservation Trust – Lottery Fund, Historic Preservation, Capital Projects Fund, Impact Fee Fund, Library Construction Fund, Water Utility Fund, Wastewater Utility Fund, Storm Water Utility Fund, Golf Course Fund, Building Maintenance Fund, and Technology Management Fund, and amending budgeted revenue in the General Fund, Conservation Trust – Land Acquisition Fund, Historic Preservation Fund, and Capital Projects Fund. ATTACHMENT(S): • Proposed Resolution No. __, Series 2012 • Exhibit A to the Resolution • Exhibit B to the Resolution • Exhibit C to the Resolution 26 Account Account Current Proposed Proposed Number Description Budget Adjustment Budget Comments/Notes 027-110-57042-00 Transfer to Capital Projects Fund 146,580 20,380 166,960 City Match on McCaslin/Dillon Intersection Project 027-110-57042-00 Transfer to Capital Projects Fund 166,960 40,000 206,960 Transfer For McCaslin Modeling Study Total McCaslin Interchange Fund 60,380 028-799-55330-06 Trail Improvements 55,000 60,000 115,000 Carry-forward for Heritage Park Trail Crossing 028-799-55330-21 New Trails Program 105,900 53,040 158,940 Carry-forward for CC/RC Trail Connection 028-799-55330-54 Boundary Treatments 10,500 9,000 19,500 Increase amount to help fund Aquarius Parking Lot Project 028-799-55330-76 Aquarius Parking Lot -76,170 76,170 Project approved for 2011, delayed to 2012 Total Conservation Trust -Land Fund 1 98,210 029-799-55330-24 Skateboard Park -35,200 35,200 Shade Structure Re-bid in 2012 029-799-55330-59 Landscape Replacement Programs -Parks 53,890 1 28,700 182,590 Recreation Center 029-799-55330-62 Parks and Open Space Signs 15,550 17,900 33,450 Carry-forward for Recreation Center 029-799-55330-77 Drinking Fountains 6,740 8,160 14,900 Community Park -Dog Park Total Conservation Trust -Lottery Fund 1 89,960 042-110-55500-08 Library Automated Materials Handling System -55,000 55,000 Automated Materials Handling System 042-110-55520-08 Computer Hardware -BVSD Fiber Project -68,900 68,900 Carryforward Unspent Project Budget 042-110-55530-11 Human Resource Information System -75,000 75,000 Carryforward Unspent Project Budget 042-499-55310-05 Bridge Repairs -44,900 44,900 Carryforward Unspent Project Budget 042-499-55310-33 South Boulder Road and Highway 42 -2 41,700 241,700 Carryforward Unspent Project Budget 042-499-55310-38 Highway 42 Station Area Master Plan -11,240 11,240 Carryforward net (of grants) amount of project from 2011 to 2012 042-499-55310-39 Highway 42 Corridor Study -1 17,670 117,670 Carryforward net (of grants) amount of project from 2011 to 2012 042-499-55310-42 McCaslin & Dillon Intersection 732,900 1 01,900 834,800 Increase 2012 Budget with Amounts Unspent in 2011 042-499-55310-45 McCaslin Interchange Modeling Study -40,000 40,000 City Share of Study Moved to 2012 042-499-55420-07 Traffic Signals 45,000 63,600 108,600 Carryforward Unspent Project Budget 042-799-55330-33 Median Improvements 25,910 25,500 51,410 Carryforward for South Boulder Road Improvements Total Capital Projects Fund 8 45,410 044-499-55200-08 Library Construction -FF and E -1 05,000 105,000 Automated Materials Handling System Total Library Construction Fund 1 05,000 051-498-55830-01 Water Line Replacement 150,000 40,000 190,000 Carryforward Unspent Project Budget 051-498-55840-07 3 MG Tank 185,000 58,700 243,700 Carryforward Unspent Project Budget 051-498-55840-48 Heating Upgrades -South Plant 67,500 20,000 87,500 Bid approved on 01/17/12 at $78,800 051-499-55360-12 Raw Water & Facilities Plan -65,000 65,000 Carryforward Unspent Project Budget 051-499-55840-60 Solar Bee Mixer in Storage Tanks 10,300 31,000 41,300 Louisville Reservoir Total Water Utility Fund 2 14,700 Appendix A City of Louisville, Colorado Proposed Budget Amendment -Carry Forward of Unused Appropriations from 2011 2012 Annual Budget 27 Account Account Current Proposed Proposed Number Description Budget Adjustment Budget Comments/Notes 052-498-55840-10 Plant Pump Replacement -28,000 28,000 Carryforward Unspent Project Budget 052-499-55840-25 Aeration Blower -7,000 7,000 Carryforward Unspent Project Budget Total Wastewater Utility Fund 35,000 053-499-55840-50 Storm Drainage Manual Update -10,000 10,000 Carryforward Unspent Project Budget Total Storm Water Utility Fund 10,000 054-799-55260-01 Clubhouse Improvements 18,000 30,300 48,300 Carryforward Unspent Project Budget Total Golf Course Fund 30,300 066-110-53500-00 General Facility Improvements 200,000 85,250 285,250 Carryforward Unspent Project Budget Total Building Maintenance Fund 85,250 067-110-55520-00 Computer Hardware 7,050 25,000 32,050 Purchase of 4 servers and Exchange software delayed to 2012 Total Technology Management Fund 25,000 Total for All Funds 1,799,210 28 Account Account Current Proposed Proposed Number Description Budget Adjustment Budget Comments/Notes 010-110-53805-01 Insurance 163,000 2 5,550 188,550 Increase in 2012 Property and Liability Insurance Premiums 010-121-53910-07 Citizen Opinion Survey -Tax Polling -2 2,840 22,840 Correct Budget Error -Omitted Citizen Survey (02/07/12) 010-130-52120-00 Non-Capital Furniture/Equipment/Tools -1,700 1,700 Reclass Digital Recorder from Capital to Operations 010-171-51110-00 Temporary Salaries -9,180 9,180 New PT Temporary Position -HR Analyst 010-171-51200-00 FICA Expense 11,690 700 12,390 New PT Temporary Position -HR Analyst 010-321-53100-99 Professional Services -Other -1 0,000 10,000 Restore for employment testing, evidence destruction, etc. 010-520-51100-00 Regular Salaries 128,580 4 3,530 172,110 New Position Wages -Planner I 010-520-51200-00 FICA Expense 9,840 3,330 13,170 New Position Benefits -Planner I 010-520-51210-00 Retirement Contribution 6,430 2,180 8,610 New Position Benefits -Planner I 010-520-51220-00 Health Insurance 17,550 9,750 27,300 New Position Benefits -Planner I 010-520-53100-69 Professional Services -Comp Plan Update 150,000 (58,790) 91,210 Funding for New Planner I Position 010-610-51210-00 Retirement Contribution -1,680 1,680 Correct Error -Omitted EE Benefits from Museum Division 010-610-51220-00 Health Insurance -7,310 7,310 Correct Error -Omitted EE Benefits from Museum Division Total General Fund 78,960 027-110-57042-00 Transfer to Capital Projects Fund 166,960 3 00,000 466,960 City Match on McCaslin/Dillon Intersection Project Total McCaslin Interchange Fund 3 00,000 028-799-55330-06 Trail Improvements 115,000 (12,500) 102,500 Reduction to help fund Aquarius Parking Lot Project 028-799-55330-54 Boundary Treatments 19,500 (19,500) -Reduction to help fund Aquarius Parking Lot Project 028-799-55330-76 Aquarius Parking Lot 76,170 32,000 108,170 Increase appropriation to cover project expenses 028-799-55330-78 Community Park Dog Pond Repairs 55,000 77,320 132,320 Expanded project scope. Bid awarded 03/30/12. 028-799-55XXX-XX Hecla Reservoir -Dam Improvements -1 60,000 160,000 New Project -Per Subdivision Agreement 028-799-55XXX-XX Water Conveyance to Harney Lastoka -5 5,500 55,500 New Project = 25% City of Louisville Share Total Conservation Trust -Land Fund 2 92,820 029-110-53100-71 Professional Services -ADA Audit and Transition Plan -3 4,110 34,110 New Project -Approved by Council on 01/17/12 029-799-55220-15 Restroom Improvement Program 25,000 (25,000) -Eliminate Project to Help Fund ADA Audit Project 029-799-55330-59 Landscape Replacement Programs -Parks 182,590 1 4,600 197,190 Increase for RSSC Landscape Renovation contract Total Conservation Trust -Lottery Fund 23,710 033-540-53100-27 Professional Services -Survey 77,500 12,500 90,000 Austin Niehoff Historic Structure Assessment 033-540-53100-27 Professional Services -Survey 90,000 19,000 109,000 Old Town Reconnaissance Survey Total Historic Preservation Fund 31,500 042-110-55200-21 Steinbaugh Pavilion Improvements 36,000 23,000 59,000 Addition for Total Bid Amount 042-110-55XXX-XX Net Motion Software & Hardware -2 3,000 23,000 Required upgrade -Boulder County Dispatch 042-499-55310-05 Bridge Repairs 44,900 44,900 89,800 Additional Amount for 96th Street Bridge 042-499-55310-38 Highway 42 Station Area Master Plan 11,240 80,000 91,240 Convert project from net cost to gross cost Appendix B City of Louisville, Colorado Proposed Budget Amendment -Additional Adjustments to 2012 Appropriations 2012 Annual Budget 29 Account Account Current Proposed Proposed Number Description Budget Adjustment Budget Comments/Notes 042-499-55310-39 Highway 42 Corridor Study 117,670 1 50,000 267,670 Convert project from net cost to gross cost 042-499-55310-42 McCaslin & Dillon Intersection 834,800 3 00,000 1,134,800 Additional Budget for Increased Project Scope 042-499-55XXX-XX South Boulder Road Pedestrian Crossing -1 00,000 100,000 New Project per Subdivision Agreement 042-499-55XXX-XX US 36 PrePaid Kiosks -FASTER Contribution -1 1,650 11,650 New Project -Local Match for FASTER Funds 042-499-55XXX-XX McCaslin Entry Way Sign -1 7,000 17,000 New Project -RTD Grant of $8,000 042-799-55330-16 Gateway Improvements -2 1,430 21,430 Landscaping & Lighting for City Entry Sign -Funded by Takoda MD Total Capital Projects Fund 7 70,980 043-110-57042-10 Transfer to Capital Projects -Library 99,000 (44,000) 55,000 Adjust Transfers to Current Projected Maximum 043-110-57042-50 Transfer to Capital Projects -Transportation 40,000 1 07,500 147,500 Adjust Transfers to Current Projected Maximum 043-110-57042-60 Transfer to Capital Projects -Municipal Facilities 60,000 62,500 122,500 Adjust Transfers to Current Projected Maximum Total Impact Fee Fund 1 26,000 051-110-53805-01 Insurance 107,000 1 6,880 123,880 Increase in 2012 Property and Liability Insurance Premiums 051-499-55450-22 Radio Signal Water Meter Readi -5,180 5,180 Purchase of Spare Meter Reader Device Total Water Utility Fund 22,060 052-110-53805-01 Insurance 20,000 3,200 23,200 Increase in 2012 Property and Liability Insurance Premiums Total Wastewater Utility Fund 3,200 Total for All Funds 1,649,230 30 Account Account Current Proposed Proposed Number Description Budget Adjustment Budget Comments/Notes 010-001-41200-00 Sales Tax 5,103,950 187,820 5,291,770 Adjust Sales Tax Budget to 101% of 2011 Actual 010-001-41200-01 Sales Tax -Business Assistance ( 86,860) 21,060 ( 65,800) Adjust Business Assistance to Current Estimate 010-001-41205-00 Use Tax -Consumer 285,750 32,020 317,770 Adjust Consumer Use Tax Budget to 100% of 2011 Actual 010-001-41205-01 Consumer Use Tax -Business Assistance ( 18,790) (84,970) ( 103,760) Adjust Business Assistance to Current Estimate 010-001-41300-00 Franchise Tax -Xcel Energy 742,490 10,430 752,920 Adjust Franchise Tax Budget to 101.5% of 2011 Actual 010-001-41500-00 Lodging Tax 345,190 7,140 352,330 Adjust Lodging Tax Budget to 105% of 2011 Actual 010-001-42110-00 Business License 47,000 13,530 60,530 Adjust Revenue Budget to 100% of 2011 Actual 010-001-42200-01 Building Permits -Business Assistance ( 54,380) (21,790) ( 76,170) Adjust Business Assistance to Current Estimate 010-001-44505-00 Rec Center Daily User Fees 125,000 (30,600) 94,400 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44530-00 Rec Center Swim Lessons 75,000 34,200 109,200 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44536-00 Rec Center Nite at the Rec 38,000 4,300 42,300 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44540-00 Rec Center Adult Activity -Fitness/Wellness 42,000 14,800 56,800 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44550-00 Rec Center Youth Sports Fees 82,000 9,700 91,700 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44555-00 Rec Center Adult Sports Fees 22,000 10,100 32,100 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44575-00 Senior Fees 38,540 10,960 49,500 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-44600-00 Memory Square Swim Admission 33,000 6,400 39,400 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual 010-001-45100-00 Court Fines 216,450 (35,110) 181,340 Adjust Revenue Budget to 100% of 2011 Actual 010-001-46140-00 Unclassified -Rentals 20,000 8,000 28,000 Adjust Rec Ctr Revenue Budget to 100% of 2011 Actual Total General Fund 197,990 028-001-41200-00 Sales Tax 957,550 34,660 992,210 Adjust Sales Tax Budget to 101% of 2011 Actual 028-001-41205-00 Use Tax -Consumer 53,550 6,030 59,580 Adjust Consumer Use Tax Budget to 100% of 2011 Actual Total Conservation Trust -Land Fund 40,690 033-001-41200-00 Sales Tax 318,590 12,090 330,680 Adjust Sales Tax Budget to 101% of 2011 Actual 033-001-41205-00 Use Tax -Consumer 17,850 2,010 19,860 Adjust Consumer Use Tax Budget to 100% of 2011 Actual 033-001-43240-00 State Grant -Historical Fund -7,500 7,500 Grant for Austin Niehoff Historic Structure Assessment 033-001-43240-00 State Grant -Historical Fund 7,500 12,000 19,500 Grant for Old Town Reconnaissance Survey Total Historic Preservation Fund 33,600 042-001-41200-00 Sales Tax 2,551,980 93,910 2,645,890 Adjust Sales Tax Budget to 101% of 2011 Actual 042-001-41200-01 Sales Tax -Business Assistance ( 43,430) 10,530 ( 32,900) Adjust Business Assistance to Current Estimate 042-001-41205-00 Use Tax -Consumer 142,850 16,040 158,890 Adjust Consumer Use Tax Budget to 100% of 2011 Actual 042-001-41205-01 Consumer Use Tax -Business Assistance ( 9,400) (42,480) ( 51,880) Adjust Business Assistance to Current Estimate 042-001-41220-01 Building Use Tax -Business Assistance ( 81,690) (27,120) ( 108,810) Adjust Business Assistance to Current Estimate 042-001-43100-00 RTD Grant -Hwy 42 Station Area Master Plan -71,240 71,240 Remaining Grant Amount for Hwy 42 Station Master Plan 042-001-43210-00 State Grant -Hwy 42/SBR -84,300 84,300 Remaining Grant Amount for SBR/Hwy 42 Project 042-001-43211-00 State Grant -Hwy 42 Corridor Study -117,670 117,670 Remaining Grant Amount for Hwy 42 Corridor Study 042-001-43215-00 State Grant -McCaslin/Dillon -669,200 669,200 Remaining Grant Amount for McCaslin/Dillon Project Appendix C City of Louisville, Colorado Proposed Budget Amendment -Changes to 2012 Revenue Budget 2012 Annual Budget 31 Account Account Current Proposed Proposed Number Description Budget Adjustment Budget Comments/Notes 042-001-43220-00 State Grant -DRCOG -Traffic Signals -24,000 24,000 2011 DRCOG Grant for Traffic Signals 042-001-43299-00 Grant Revenues 586,320 (586,320) -Reclass McCaslin/Dillon Project Grant 042-001-43299-00 Grant Revenues -8,000 8,000 RTD Grant for McCaslin Entry Way Sign 042-001-48043-00 Transfer from Impact Fee Fund 399,000 126,000 525,000 Adjust Transfers to Current Projected Maximum Total Capital Projects Fund 564,970 Total for All Funds 837,250 32 COUNCIL COMMUNICATION TO: MAYOR AND CITY COUNCIL FROM: MALCOLM FLEMING CITY MANAGER DATE: APRIL 16, 2012 SUBJECT: SALES TAX REPORT FOR THE MONTH ENDED FEBRUARY 29, 2012 ORIGINATING DEPARTMENT: CITY MANAGER’S OFFICE SUMMARY: Attached are the revenue reports for sales tax, lodging tax, auto use, building use tax and consumer use tax for the month ending February 29, 2012. The total for all revenues is up 13% YTD over 2011. City sales tax revenue for February 2012 ended up 11% from February 2011 and is 3.4% above budget YTD. The top 50 vendors for 2012 ended the month of February up 8.7% from February 2011 largely due to timing difference in the Telecom/Utilities sector. Excluding this sector, the top 50 were up 2% for the month of February. Current year declines by sector include Technology (-75.8%) and General Merchandise (-3.6%). Current year gains include all other sectors; Grocery (6.2%), Home Improvement (18.4%), Hotels (14.7%), Telecom/Utilities (5.3%), and Restaurants (7.2%). Analysis of all taxpayers for all areas and industry sectors indicate an increase for February 2012 of 11.3% above February 2011. Lodging tax revenue for February 2012 ended 16% above February 2011 and is 2.4% above budget YTD. Auto use tax revenue for February 2012 ended 44.3% above February 2011 and is 2.8% above budget YTD. Building use tax revenue for February 2012 ended 11.2% below February 2011 and is 17.7% below budget YTD. Consumer use tax for the month of February 2012 was $52,354 which is 777% above SUBJECT FEB RUAR Y 2012 SALE S TAX REPO RT AGENDA ITEM 33 PAGE TWO SUBJECT: SALES TAX REPORT FOR THE MONTH ENDED FEBRUARY 29, 2012 DATE: APRIL 16, 2012 February 2011 and 433% above budget YTD. Approximately $43,000 of the revenue received was due to the collection of use tax from 2011. City of Louisville, Colorado Total Sales Tax Revenue by Fund Feb‐12 2012 2012 Fund Budget Actual General 5,103,950 765,459 Cons. Trust 957,550 143,524 Cap. Projects 2,551,980 382,729 Historic Pres. 318,590 47,841 Totals 8,932,070 1,339,553 34 YEAR MONTH SALES TAX USE TAX BLDG USE TAX AUTO USE TAX LODGING TAX AUDIT REVENUE TOTAL 2012 JANUARY 681,326 32,851 27,928 70,085 21,299 ‐833,489 FEBRUARY 656,603 52,354 40,696 81,880 21,356 2 ,109 854,997 MARCH ‐‐‐APRIL ‐‐‐MAY ‐‐‐JUNE ‐‐‐JULY ‐‐‐AUGUST ‐‐‐SEPTEMBER ‐‐‐OCTOBER ‐‐‐NOVEMBER ‐‐‐DECEMBER ‐‐‐YTD TOTALS 1,337,928 85,205 68,624 151,965 42,656 2,109 1,688,486 YTD Variance % to Prior Year 9.3% 396.5% ‐2.2% 25.1% 14.5% ‐89.9% 13.3% 2011 JANUARY 634,012 11,262 24,333 64,708 18,884 18,367 771,564 FEBRUARY 589,984 5,900 45,823 56,736 18,361 2 ,558 719,363 MARCH 776,647 45,119 15,941 77,130 20,385 1 ,870 937,091 APRIL 725,384 15,521 45,812 72,171 22,368 2 ,414 883,671 MAY 734,017 15,403 38,312 73,741 35,261 13,549 910,283 JUNE 871,414 32,373 50,480 87,068 35,938 12,396 1,089,669 JULY 735,710 13,273 83,345 69,746 38,443 34,921 975,438 AUGUST 738,939 22,640 91,563 87,377 40,498 1 ,979 982,996 SEPTEMBER 785,785 43,390 92,181 74,646 32,129 19,005 1,047,136 OCTOBER 718,122 35,381 96,533 89,734 31,123 2 ,663 973,556 NOVEMBER 746,388 27,461 65,564 76,039 23,399 20,683 959,533 DECEMBER 1,052,498 282,224 85,218 69,956 18,766 14,568 1,523,231 YTD TOTALS 9,108,901 549,946 735,105 899,051 335,555 144,973 11,773,530 YTD Variance % to Prior Year 4.4% N/A 175.9% 11.2% 10.1% ‐15.3% 14.5% 2010 JANUARY 652,461 4,958 66,070 15,093 2 ,611 741,193 FEBRUARY 603,533 19,291 61,173 15,512 10,409 709,917 MARCH 772,957 45,287 62,819 19,765 5 ,559 906,387 APRIL 718,508 16,038 62,576 19,502 39,982 856,606 MAY 733,372 48,555 64,894 29,180 5 ,713 881,713 JUNE 804,590 10,210 65,663 34,186 27,224 941,873 JULY 712,442 35,333 69,503 37,078 6 ,045 860,400 AUGUST