Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
C 2008 Budget Discussion
CITY OF CHANHASSEN 7700 Market Boulevard PO Box 147 Chanhassen, MN 55317 Administration Phone: 952.227.1100 Fax: 952.227.1110 Building Inspections Phone: 952.227.1180 Fax: 952.227.1190 Engineering Phone: 952.227.1160 Fax: 952.227.1170 Finance Phone: 952.227.1140 Fax: 952.227.1110 Park & Recreation Phone: 952.227.1120 Fax: 952.227.1110 Recreation Center 2310 Coulter Boulevard Phone: 952.227.1400 Fax: 952.227.1404 Planning & Natural Resources Phone: 952,227.1130 Fax: 952.227,1110 Public Works 1591 Park Road Phone: 952.227.1300 Fax: 952.227.1310 Senior Center Phone: 952.227.1125 Fax: 952.227.1110 Web Site W'INI,ci, chan hassen.mn. us c MEMORANDUM TO: Mayor and City Council &lr- ~ FROM: Greg Sticha, Finance Director DATE: June 25, 2007 SUBJ: Preliminary 2008 Budget Discussion BACKGROUND It is that time of year again when we begin preliminary discussion of the 2008 budget. At this work session, the council will receive information on some of the factors that will influence the 2008 budget, and staff would like council feedback on any items of concern and direction for the department heads as they prepare their budgets. During your recent review of police services with Carver County, it was decided that for 2008 the City will be adding Y2 of a new Investigator and Y2 of a new patrol Officer. This will be a new expense to the city's budget of approximately $100,000 and is included in the attached KFS general fund projection worksheet. We also included a spreadsheet showing the history of new construction growth in the city. The new construction number has a direct impact on the tax levy and effect of the tax bill to the average property owner. We have contacted Carver County for a preliminary estimate for the new construction for this year, and we have been told it will be around 1.8%. Historically, this number has been closer to 3% each of the last few years. Since this number is substantially lower than prior years, it will have a direct impact on our tax levy and budget discussions this year. We have included a calendar for the rest of the year reflecting meeting dates and significant deadlines for completion of the 2008 budget. If any of the dates appeario conflict with other known city deadlines or budget requirements, please let me know as soon as possible. We have also included a snapshot of the 2007 budget versus actual revenues and expenditures in the City's general fund as of May 31st. Also included is the Key Financial Strategies general fund revenue and expenses projection worksheet for 2006 thru 2012. The assumption of this worksheet is using a 3% inflationary adjustment from year to year. The City of Chanhassen · A growing community with clean lakes, quality schools, a channing downtown, thriving businesses, winding trails, and beautiful parks. A great place to live, work, and play. Preliminary 2008 Budget Discussion June 25, 2007 Page 2 012 The Consumer Price Index (CPI) for 2006 was 3.7%. Initial numbers through April of 2007 are much lower at 2.6%. Included in the attachments is the actual US Department of Labor CPI report for April 2007. The financial audit is substantially complete at this time and it appears the general fund had revenues exceed expenditures by $620,000, excluding transfers. This is resulting in a fund balance at the end of 2006 of $4.82 million. Staff is recommending capping the catastrophic reserve in the general fund at $1.3 million. Listed below is a breakdown of the general fund balance at the end of 2006, and the amount that would be available to be transferred to the "Revolving Special Assessment Street Construction Fund" in 2007. Staff will be bringing that recommendation to council in July when the audit results are presented. General Fund Balance at 12-31-06 Required Reserve Per City Policy Catastrophic Reserve $4,820,270 (3,246,550) 0.300.000) Excess Fund Balance Available to Transfer $273,720 RECOMMENDA TION Staff requests feedback from the City Council regarding the level of the initial tax levy, so that we can give clear direction to department directors as they prepare their 2008 budget requests. ATTACHMENTS 1. 2006 Budget vs. Actual Expenditure and Revenue Report through 5-31-2006. 2. 2008 Budget Calendar. 3. 2006-2025 Debt Levies. 4. Key Financial Strategies General Fund projection worksheet. 5. US Department of Labor April 2006 CPI report. 6. Revolving Assessment Fund Worksheet 7. New Construction History F:\GregS\Budget\2008 budget\6-25 prelim bud discussion.doc General Ledger Expense-Budget vs Actual ClTIOF User: danielle CHDSSEN Printed: 06/05/07 11.17:34 Period 01 - 05 Fiscal Year 2007 - 2007 2007 2007 2007 2007 Account Number Description Budget End BalAvail/Uncollect % AvaiVUncollect Expense 101-1110-4020 Temporary & Seasonal Wages 31,600.00 10,900.00 20,700.00 65.51 101-1110-4030 Retirement Contributions 2,500.00 784.66 1,715.34 68.61 101-1110-4050 Workers Compensation 100.00 0.00 100.00 100.00 101-1110-4210 Books and Periodicals 200.00 0.00 200.00 100.00 101-1110-4300 Consulting 13,000.00 13,174.37 -174.37 -1.34 101-1110-4330 Postage 6,000.00 2,965.62 3,034.38 5057 101-1110-4340 Printing and Publishing 37,000.00 19,641.45 17,358.55 46.92 101-1110-4360 Subscriptions and Memberships 28,000.00 6,849.00 21,151.00 7554 101-1110-4370 Travel and Training 3,000.00 1,748.27 1,251.73 4172 101-1110-4375 Promotional Expenses 2,000.00 47.99 1,952.01 97.60 1110 CITY COUNCIL 123,400.00 56,111.36 67,288.64 54.53 10 1-1120-40 10 Salaries and Wages 295,000.00 108,282.13 186,717.87 63.29 10 1-1120-4020 Temporary & Seasonal Wages 6,000.00 0.00 6,000.00 100.00 101-1120-4030 Retirement Contributions 41,100.00 14,727.04 26,372.96 64.17 10 1-1120-4040 Insurance Contributions 42,300.00 17,436.37 24,863.63 58.78 101-1120-4041 Contr Fix 0.00 567.93 -567.93 0.00 101-1120-4050 Workers Compensation 1,100.00 0.00 1,100.00 100.00 101-1120-4120 Equipment Supplies 200.00 0.00 200.00 100.00 101-1120-4130 Program Supplies 100.00 0.00 100.00 100.00 101-1120-4210 Books and Periodicals 200.00 7340 126.60 63.30 10 1-1120-4300 Consulting 2,000.00 5,453.60 -3,453.60 -172.68 101-1120-4310 Telephone and Communications 1,500.00 676.66 823.34 54.89 101-1120-4330 Postage 13,000.00 160.00 12,840.00 98.77 101-1120-4340 Printing and Publishing 1,500.00 118.65 1,381.35 92.09 101-1120-4360 Subscriptions and Memberships 2,500.00 2,199.00 301.00 12.04 101-1120-4370 Travel and Training 5,500.00 1,798.25 3,701.75 67.30 101-1120-4380 Mileage 7,200.00 2,125.00 5,075.00 70.49 10 1-1120-4410 Equipment Rental 18,500.00 6,937.08 11,562.92 6250 101-1120-4530 Repair & Maint - Equipment 300.00 0.00 300.00 100.00 101-1120-4807 Property Tax Expense 0.00 20.00 -20.00 0.00 1120 ADMINISTRATION 438,000.00 160,575.11 277,424.89 63.34 101-1130-4010 Salaries and Wages 177,900.00 65,613.64 112,286.36 63.12 101-1130-4011 Overtime 200.00 0.00 200.00 100.00 101-1130-4030 Retirement Contributions 24,700.00 8,837.85 15,862.15 64.22 10 1-1130-4040 Insurance Contributions 22,200.00 8,973.94 13,226.06 59.58 101-1130-4041 Contr FIx 0.00 349.36 -349.36 0.00 101-1130-4050 Workers Compensation 1,000.00 0.00 1,000.00 ] 00.00 101-1130-4120 Equipment Supplies 200.00 23.75 176.25 88.13 101-1130-4210 Books and Periodicals ]00.00 0.00 100.00 ] 00.00 101-1130-4300 Consulting 42,000.00 5,135.73 36,864.27 87.77 101-1130-430] Auditing 38,000.00 9,581.00 28,4]9.00 74.79 101-1130-4310 Telephone and Communications 300.00 92.12 207.88 69.29 101-1130-4330 Postage 200.00 0.00 200.00 100.00 101-1130-4340 Printing and Publishing 1,500.00 36.21 1,463.79 97.59 101-1130-4360 Subscriptions and Memberships 400.00 160.00 240.00 60.00 101-1130-4370 Travel and Training 9,000.00 2,073.29 6,926.71 76.96 1 2007 2007 2007 2007 Account Number Description Budget End Bal A vaiVUncollect % A vail/Uncollect 101-1130-4530 Repair & Maint - Equipment 100.00 0.00 100.00 100.00 101-1130-4703 Office Equipment 200.00 0.00 200.00 100.00 1130 FINANCE 318,000.00 100,876.89 217,123.11 68.28 101-1140-4302 Legal Consulting 168,000.00 39,862.82 128,137.18 76.27 1140 LEGAL 168,000.00 39,862.82 128,137.18 76.27 101-1142-4302 Legal Consulting 0.00 328.99 -328.99 0.00 1142 ARILD ROSSA VIK LmGATION 0.00 328.99 -328.99 0.00 101-1150-4300 Consulting 100,000.00 4,494.04 95,505.96 95.51 101-1150-4340 Printing and Publishing 100.00 0.00 100.00 100.00 1150 PROPERTY ASSESSMENT 100,100.00 4,494.04 95,605.96 95.51 101-1160-4010 Salaries and Wages 124,300.00 46,661.70 77,638.30 62.46 101-1160-4030 Retirement Contributions 17,300.00 6,620.90 10,679.10 61.73 101-1160-4040 Insurance Contributions 17,900.00 8,310.55 9,589.45 53.57 10 1-1160-4041 Contr FIx 0.00 249.70 -24970 0.00 101-1160-4050 Workers Compensation 500.00 0.00 500.00 100.00 101-1160-4150 Maintenance Materials 1,300.00 575.79 724.21 55.71 101-1160-4210 Books and Periodicals 600.00 318.89 281.11 46.85 101-1160-4260 Small Tools & Equipment 500.00 0.00 500.00 100.00 101-1160-4300 Consulting 78,100.00 18,417.44 59,682.56 76.42 101-1160-4310 Telephone and Communications 1,400.00 314.02 1,085.98 77.57 101-1160-4320 Utilities 12,600.00 4,723.50 7,876.50 62.51 101-1160-4370 Travel and Training 21,700.00 1,900.22 19,799.78 91.24 101-1160-4530 Repair & Maint - Equipment 5,000.00 593.02 4,406.98 88.14 101-1160-4933 Sales Tax 0.00 644.77 -644.77 0.00 1160 MANAGEMENT INFORMATION SYSTEMS 281,200.00 89,330.50 191,869.50 68.23 101-1170-4010 Salaries and Wages 49,600.00 18,709.10 30,890.90 62.28 10 1-1170-40 11 Overtime 2,000.00 1,929.37 70.63 3.53 101-1170-4030 Retirement Contributions 6,900.00 2,888.02 4,011.98 58.14 101-1170-4040 Insurance Contributions 6,600.00 3,160.49 3,439.51 52.11 101-1170-4041 Contr Fix 0.00 124.85 -124.85 0.00 101-1170-4050 Workers Compensation 1,500.00 0.00 1,500.00 100.00 101-1170-4110 Office Supplies 37,000.00 10,701.02 26,298.98 71.08 101-1170-4120 Equipment Supplies 1,000.00 659.24 340.76 34.08 101-1170-4140 Vehicle Supplies 1,000.00 0.00 1,000.00 100.00 101-1170-4150 Maintenance Materials 3.000.00 1,278.15 1,721.85 5740 101-1170-4260 Small Tools & Equipment 500.00 34.09 465.91 93.18 101-1170-4300 Consulting 6,000.00 953.57 5,046.43 84.11 101-1170-4310 Telephone and Communications 16,000.00 6,067.98 9,932.02 62.08 101-1170-4320 Utilities 52,000.00 25,196.26 26,803.74 51.55 101-1170-4330 Postage 0.00 -3.03 3.03 0.00 10 1-1170-4350 Cleaning and Waste Removal 33,000.00 11,683.73 21,316.27 64.59 101-1170-4440 Vehicle License & Registration 100.00 0.00 100.00 100.00 101-1170-4483 General Liability Insurance 205,500.00 274,807.00 -69,307.00 -33.73 101-1170-4510 Repair & Maint- Buildings 5,000.00 2,775.28 2,224.72 44.49 101-1170-4520 Repair & Maint - Vehicles 400.00 0.00 400.00 100.00 101-1170-4530 Repair & Maint - Equipment 1,500.00 714.38 785.62 52.37 101-1170-4933 Sales Tax 0.00 28.57 -28.57 0.00 1170 CITY HALL MAINTENANCE 428,600.00 361,708.07 66,891.93 15.61 101-1180-4020 Temporary & Seasonal Wages 12,500.00 0.00 12,500.00 100.00 10 1-1180-4030 Retirement Contributions 1,000.00 0.00 1,000.00 100.00 101-1180-4110 Office Supplies 200.00 0.00 200.00 100.00 101-1180-4300 Consulting 3,000.00 0.00 3,000.00 100.00 101-1180-4340 Printing and Publishing 2,000.00 0.00 2,000.00 100.00 101-1180-4370 Travel and Training 1,000.00 0.00 1,000.00 100.00 1180 ELECTIONS 19,700.00 0.00 19,700.00 100.00 101-1190-4150 Maintenance Materials 2,000.00 801.67 1,198.33 59.92 2 2007 2007 2007 2007 Account Number Description Budget End Bal A vaiUUncoUect % A vaiUUncollect 101-1190-4260 Small Tools & Equipment 0.00 8.71 -8.71 0.00 101-1190-4300 Consulting 1,000.00 3,888.36 -2,888.36 -288.84 101-1190-4310 Telephone and Communications 2,200.00 646.01 1,553.99 70.64 101-1190-4320 Utilities 63,000.00 26,985.87 36,014.13 57.17 101-1190-4350 Cleaning and Waste Removal 30,000.00 9,771 61 20,228.39 67.43 101-1190-4510 Repair & Maint- Buildings 2,000.00 940.85 1,059.15 52.96 101-1190-4530 Repair & Maint - Equipment 2,000.00 1,662.07 337.93 16.90 1190 LIBRARY BUILDING 102,200.00 44,705.15 57,494.85 56.26 101-1210-4010 Salaries and Wages 58,800.00 22,393.20 36,406.80 61.92 101-1210-4030 Retirement Contributions 8,200.00 3,089.99 5,110.01 62.32 101-1210-4040 Insurance Contributions 6,700.00 2,621.05 4,078.95 60.88 101-1210-4041 Contr Fix 0.00 124.85 -124.85 0.00 10 1-1210-4050 Workers Compensation 500.00 0.00 500.00 100.00 101-1210-4130 Program Supplies 5,000.00 0.00 5,000.00 100.00 101-1210-4300 Consulting 1,250,000.00 15,006.29 1,234,993.71 98.80 101-1210-4375 Promotional Expenses 4,500.00 50.00 4,450.00 98.89 1210 POLICE/CARVER CO CONTRACT 1,333,700.00 43,285.38 1,290,414.62 96.75 101-1220-4010 Salaries and Wages 133,500.00 50,603.63 82,896.37 62.09 101-1220-4011 Overtime 1,000.00 277.44 722.56 72.26 101-1220-4020 Temporary & Seasonal Wages 160,000.00 37,909.67 122,090.33 76.31 101-1220-4030 Retirement Contributions 187,000.00 8,786.45 178,213.55 95.30 101-1220-4040 Insurance Contributions 19,600.00 8,301.02 11,298.98 57.65 101-1220-4041 Contr Fix 0.00 280.94 -280.94 0.00 101-1220-4050 Workers Compensation 14,500.00 0.00 14,500.00 100.00 101-1220-4060 Unemployment 0.00 22.00 -22.00 0.00 101-1220-4120 Equipment Supplies 11,000.00 3,266.04 7,733.96 70.31 101-1220-4130 Program Supplies 5,000.00 301.66 4,698.34 93.97 101-1220-4140 Vehicle Supplies 7,000.00 3,252.21 3,747.79 53.54 101-1220-4150 Maintenance Materials 1,000.00 226.45 773.55 77.36 101-1220-4210 Books and Periodicals 1,000.00 207.45 792.55 79.26 101-1220-4240 Uniforms & Clothing 13,500.00 4,743.58 8,756.42 64.86 101-1220-4260 Small Tools & Equipment 5,000.00 2,386.62 2,613.38 52.27 101-1220-4290 Mise Materials & Supplies 3,500.00 1,337.49 2,162.51 61.79 101-1220-4300 Consulting 16,500.00 3,170.67 13,329.33 80.78 101-1220-4310 Telephone and Communications 6,000.00 1,988.68 4,011.32 66.86 101-1220-4320 Utilities 23,000.00 14,006.99 8,993.01 39.10 101-1220-4350 Cleaning and Waste Removal 7,000.00 2,145 10 4,854.90 69.36 101-1220-4360 Subscriptions and Memberships 3,000.00 1,179.55 1,820.45 60.68 101-1220-4370 Travel and Training 10,000.00 10,305.07 -305.07 -3.05 101-1220-4375 Promotional Expenses 9,000.00 506.91 8,493.09 94.37 10 1-1220-4483 General Liability Insurance 1,000.00 0.00 1,000.00 100.00 101-1220-4510 Repair & Maint- Buildings 7,000.00 2,048.11 4,951.89 70.74 101-1220-4520 Repair & Maint - Vehicles 7,000.00 1,645.05 5,354.95 76.50 101-1220-4530 Repair & Maint - Equipment 5,000.00 3,142.04 1,857.96 37.16 101-1220-4531 Repair & Maint - Radios 9,000.00 2,910.80 6,089.20 67.66 101-1220-4901 RefundslReimbursements 12,500.00 401.25 12,098.75 96.79 101-1220-4933 Sales Tax 0.00 211.00 -211.00 0.00 1220 FIRE PREVENTION & ADMIN 678,600.00 165,563.87 513,036.13 75.60 101-1250-4010 Salaries and Wages 524,000.00 179,954.51 344,045.49 65.66 101-1250-4011 Overtime 2,000.00 357.71 1,642.29 82.11 10 1-1250-4020 Temporary & Seasonal Wages 30,000.00 0.00 30,000.00 100.00 101-1250-4030 Retirement Contributions 72,900.00 24,517.07 48,382.93 66.37 10 1-1250-4040 Insurance Contributions 91,700.00 31,988.31 59,711.69 65.12 101-1250-4041 Contr FIx 0.00 998.80 -998.80 0.00 101-1250-4050 Workers Compensation 3,400.00 0.00 3,400.00 100.00 101-1250-4120 Equipment Supplies 1,000.00 23.01 976.99 97.70 3 2007 2007 2007 2007 Account Number Description Budget End Bal A vaiVUncollect % A vaiVUncollect 101-1250-4130 Program Supplies 800.00 0.00 800.00 100.00 101-1250-4140 Vehicle Supplies 1,500.00 202.09 1,297.91 86.53 101-1250-4210 Books and Periodicals 3,500.00 170.50 3,329.50 95.13 101-1250-4240 Uniforms & Clothing 1,500.00 182.00 1.318.00 87.87 101-1250-4260 Small Tools & Equipment 400.00 60.94 339.06 84.77 101-1250-4300 Consulting 1,000.00 0.00 1,000.00 100.00 101-1250-4310 Telephone and Communications 4,000.00 950.03 3,049.97 76.25 101-1250-4340 Printing and Publishing 2,000.00 889.19 1,110.81 55.54 101-1250-4360 Subscriptions and Memberships 1,000.00 15.00 985.00 98.50 101-1250-4370 Travel and Training 11,000.00 684.90 10,315.10 93.77 101-1250-4375 Promotional Expenses 200.00 0.00 200.00 100.00 101-1250-4440 Vehicle License & Registration 200.00 0.00 200.00 100.00 101-1250-4520 Repair & Maint - Vehicles 1,500.00 326.32 1,173.68 78.25 101-1250-4530 Repair & Maint - Equipment 2,500.00 1,078.13 1,421.87 56.87 101-1250-4901 RefundslReimbursements 0.00 272.31 -272.31 0.00 1250 CODE ENFORCEMENT 756,100.00 242,670.82 513,429.18 67.90 101-1260-4020 Temporary & Seasonal Wages 47,000.00 16,075.50 30,924.50 65.80 101-1260-4021 Temp/Seasonal Overtime 1,000.00 646.50 353.50 35.35 101-1260-4030 Retirement Contributions 4,900.00 2,351.20 2,548.80 52.02 101-1260-4040 Insurance Contributions 600.00 0.00 600.00 100.00 10 1-1260-4041 Contr Fix 0.00 249.70 -249.70 0.00 101-1260-4050 Workers Compensation 700.00 0.00 700.00 100.00 101-1260-4120 Equipment Supplies 500.00 108.97 391.03 78.21 101-1260-4130 Program Supplies 700.00 436.41 263.59 37.66 101-1260-4140 Vehicle Supplies 700.00 191.24 508.76 72.68 101-1260-4210 Books and Periodicals 200.00 32.45 167.55 83.78 101-1260-4240 Uniforms & Clothing 1,800.00 145 19 1,654.81 91.93 101-1260-4300 Consulting 7,000.00 3,974.30 3,025.70 43.22 101-1260-4310 Telephone and Communications 1,000.00 178.93 821.07 82.11 101-1260-4340 Printing and Publishing 500.00 346.13 153.87 30.77 101-1260-4360 Subscriptions and Memberships 300.00 57.00 243.00 81.00 101-1260-4370 Travel and Training 700.00 0.00 700.00 100.00 101-1260-4520 Repair & Maint - Vehicles 1,000.00 0.00 1,000.00 100.00 101-1260-4530 Repair & Maint - Equipment 300.00 0.00 300.00 100.00 101-1260-4531 Repair & Maint - Radios 300.00 354 62 -54.62 -18.21 101-1260-4933 Sales Tax 0.00 25.68 -25.68 0.00 1260 AMINAL CONTROL 69,200.00 25,173.82 44,026.18 63.62 101-1310-4010 Salaries and Wages 383,900.00 149,348.03 234,551.97 61.10 101-1310-4011 Overtime 1,000.00 65.19 934.81 93.48 101-1310-4020 Temporary & Seasonal Wages 10,000.00 1,498.00 8,502.00 85.02 10 1-1310-4030 Retirement Contributions 53,400.00 20,878.52 32,521.48 60.90 10 1-1310-4040 Insurance Contributions 46,300.00 19,300.45 26,999.55 58.31 101-1310-4041 Contr Fix 0.00 842.71 -842.71 0.00 101-1310-4050 Workers Compensation 2,800.00 0.00 2,800.00 100.00 10 1-1310-4060 Unemployment 0.00 3,268.68 -3,268.68 0.00 101-1310-4120 Equipment Supplies 200.00 0.00 200.00 100.00 101-1310-4140 Vehicle Supplies 300.00 0.00 300.00 100.00 101-1310-4210 Books and Periodicals 400.00 66.90 333.10 83.28 101-1310-4300 Consulting 18,000.00 -1,005.62 19,005.62 105.59 101-1310-4303 Engineering Consulting 0.00 1,287.00 -1,287.00 0.00 101-1310-4310 Telephone and Communications 2,000.00 511.71 1,488.29 74.41 101-1310-4330 Postage 400.00 0.00 400.00 100.00 101-1310-4340 Printing and Publishing 1,100.00 25.45 1,074.55 97.69 101-1310-4360 Subscriptions and Memberships 1,200.00 835.00 365.00 30.42 10 1-1310-4370 Travel and Training 3,000.00 1.286.13 1,713.87 57.13 101-1310-4380 Mileage 200.00 11.64 188.36 94.18 4 2007 2007 2007 2007 Account Number Description Budget End BalAvaillUncollect % AvaillUncollect 101-1310-4440 Vehicle License & Registration 300.00 0.00 300.00 100.00 101-1310-4520 Repair & Maint - Vehicles 500.00 0.00 500.00 100.00 101-1310-4530 Repair & Maint - Equipment 3,000.00 2,834.17 165.83 5.53 101-1310-4531 Repair & Maint - Radios 100.00 0.00 100.00 100.00 101-1310-4705 Other Equipment 300.00 0.00 300.00 100.00 101-1310-4933 Sales Tax 0.00 108.94 -108.94 0.00 1310 ENGINEERING 528,400.00 201,162.90 327,237.10 61.93 101-1320-4010 Salaries and Wages 436,400.00 165,861.62 270,538.38 61.99 101-1320-4011 Overtime 10,000.00 6,552.33 3,447.67 34.48 101-1320-4020 Temporary & Seasonal Wages 17 ,800.00 0.00 17,800.00 100.00 10 1-1320-4030 Retirement Contributions 60,700.00 23,875.11 36,824.89 60.67 10 1-1320-4040 Insurance Contributions 72,900.00 29,560.46 43,339.54 59.45 101-1320-4041 Contr FIx 0.00 1,030.04 -1,030.04 0.00 101-1320-4050 Workers Compensation 17,500.00 0.00 17,500.00 100.00 101-1320-4120 Equipment Supplies 47,000.00 19,023.11 27,976.89 59.53 101-1320-4140 Vehicle Supplies 28,000.00 6,750.44 21,249.56 75.89 101-1320-4150 Maintenance Materials 55,000.00 26,698.91 28,301.09 51.46 101-1320-4170 Motor Fuels and Lubricants 0.00 1,148.37 -1,148.37 0.00 101-1320-4210 Books and Periodicals 100.00 0.00 100.00 100.00 101-1320-4240 Uniforms & Clothing 3,700.00 1,195.64 2,504.36 67.69 101-1320-4260 Small Tools & Equipment 2,700.00 896.43 1,80357 66.80 101-1320-4300 Consulting 1,000.00 140.50 859.50 85.95 101-1320-4310 Telephone and Communications 3,500.00 1,071.02 2,428.98 69.40 101-1320-4340 Printing and Publishing 300.00 2940 270.60 90.20 101-1320-4350 Cleaning and Waste Removal 300.00 0.00 300.00 100.00 101-1320-4360 Subscriptions and Memberships 100.00 0.00 100.00 100.00 101-1320-4370 Travel and Training 1,500.00 742.65 757.35 50.49 101-1320-4410 Equipment Rental 1,500.00 0.00 1,500.00 100.00 101-1320-4440 Vehicle License & Registration 600.00 0.00 600.00 100.00 101-1320-4510 Repair & Maint- Buildings 500.00 0.00 500.00 100.00 101-1320-4520 Repair & Maint - Vehicles 2,400.00 1,783.40 616.60 25.69 101-1320-4530 Repair & Maint - Equipment 5,500.00 0.00 5,500.00 100.00 101-1320-4531 Repair & Maint - Radios 2,000.00 0.00 2,000.00 100.00 101-1320-4540 Repair & Maint - Streets 500.00 7,332.51 -6,832.51 -1,366.50 101-1320-4560 Repair & Maint - Signs 13,700.00 3,934.42 9,765.58 71.28 101-1320-4703 Office Equipment 300.00 0.00 300.00 100.00 101-1320-4705 Other Equipment 1,000.00 0.00 1,000.00 100.00 101-1320-4933 Sales Tax 0.00 375.28 -375.28 0.00 1320 STREET MAINTENANCE 786,500.00 298,001.64 488,498.36 62.11 101-1350-4120 Equipment Supplies 4,500.00 246.44 4,253.56 94.52 101-1350-4300 Consulting 300.00 0.00 300.00 100.00 101-1350-4310 Telephone and Communications 600.00 207.90 392.10 65.35 101-1350-4320 . Utilities 290,000.00 108,872.73 181,127.27 62.46 101-1350-4530 Repair & Maint - Equipment 2,500.00 0.00 2,500.00 100.00 101-1350-4565 Repair & Maint - Lights 17,000.00 3,113.74 13,886.26 81.68 1350 STREET LIGHTING & SIGNALS 314,900.00 112,440.81 202,459.19 64.29 101-1370-4010 Salaries and Wages 187,400.00 65,416.53 121,983.47 65.09 101-1370-4011 Overtime 6,500.00 0.00 6,500.00 100.00 101-1370-4030 Retirement Contributions 26,100.00 8,730.20 17,369.80 66.55 101-1370-4040 Insurance Contributions 32,000.00 13,399.34 18,600.66 58.13 101-1370-4041 Contr FIx 0.00 368.17 -368.17 0.00 101-1370-4050 Workers Compensation 6,000.00 0.00 6,000.00 100.00 101-1370-4120 Equipment Supplies 3,300.00 0.00 3,300.00 100.00 101-1370-4140 Vehicle Supplies 500.00 0.00 500.00 100.00 101-1370-4150 Maintenance Materials 1,000.00 1,924.47 -92447 -92.45 101-1370-4170 Motor Fuels and Lubricants 140,000.00 52,659.18 87,340.82 62.39 5 2007 2007 2007 2007 Account Number Description Budget End BalAvail/Uncollect % AvaillUncollect 101-1370-4240 Unifonns & Clothing 1,200.00 109.45 1,090.55 90.88 101-1370-4260 Small Tools & Equipment 4,400.00 454.50 3,945.50 89.67 101-1370-4300 Consulting 1,300.00 278.39 1.021.61 78.59 101-1370-4310 Telephone and Communications 3,800.00 1,046.54 2,753.46 72.46 101-1370-4320 Utilities 23,000.00 12,493.07 10,506.93 45.68 101-1370-4340 Printing and Publishing 100.00 29.40 70.60 70.60 101-1370-4350 Cleaning and Waste Removal 6,100.00 1,595.75 4,504.25 73.84 101-1370-4360 Subscriptions and Memberships 200.00 35.00 165.00 82.50 101-1370-4370 Travel and Training 1,500.00 401.06 1,098.94 73.26 101-1370-4410 Equipment Rental 500.00 0.00 500.00 100.00 101-1370-4440 Vehicle License & Registration 500.00 0.00 500.00 100.00 101-1370-4510 Repair & Maint- Buildings 4,000.00 1,915.29 2,084.71 52.12 101-1370-4520 Repair & Maint - Vehicles 300.00 0.00 300.00 100.00 10 1-1370-4530 Repair & Maint - Equipment 3,800.00 511.18 3,288.82 86.55 101-1370-4531 Repair & Maint - Radios 100.00 0.00 100.00 100.00 101-1370-4703 Office Equipment 500.00 0.00 500.00 100.00 101-1370-4705 Other Equipment 5,500.00 0.00 5,500.00 100.00 1370 CITY GARAGE 459,600.00 161,367.52 298,232.48 64.89 101-1410-4210 Books and Periodicals 200.00 0.00 200.00 100.00 101-1410-4340 Printing and Publishing 3,000.00 1,610.34 1,389.66 46.32 101-1410-4360 Subscriptions and Memberships 200.00 0.00 200.00 100.00 101-1410-4370 Travel and Training 800.00 66.70 733.30 91.66 1410 PLANNING COMMISSION 4,200.00 1,677.04 2,522.96 60.07 101-1420-4010 Salaries and Wages 283,200.00 102,242.19 180,957.81 63.90 101-1420-4030 Retirement Contributions 39,400.00 13,797.13 25,602.87 64.98 101-1420-4040 Insurance Contributions 39,200.00 18,876.31 20,323.69 51.85 101-1420-4041 Contr Fix 0.00 516.38 -516.38 0.00 101-1420-4050 Workers Compensation 1,000.00 0.00 1,000.00 100.00 101-1420-4120 Equipment Supplies 300.00 0.00 300.00 100.00 101-1420-4130 Program Supplies 100.00 0.00 100.00 100.00 101-1420-4140 Vehicle Supplies 100.00 0.00 100.00 100.00 101-1420-4210 Books and Periodicals 200.00 0.00 200.00 100.00 101-1420-4300 Consulting 5,000.00 26.16 4,973.84 99.48 101-1420-4310 Telephone and Communications 200.00 30.52 169.48 84.74 101-1420-4340 Printing and Publishing 200.00 0.00 200.00 100.00 101-1420-4360 Subscriptions and Memberships 1,500.00 0.00 1,500.00 100.00 101-1420-4370 Travel and Training 7,000.00 1,167.59 5,832.41 83.32 101-1420-4520 Repair & Maint - Vehicles 200.00 0.00 200.00 100.00 1420 PLANNING ADMINISTRATION 377,600.00 136,656.28 240,943.72 63.81 101-1421-4300 Consulting 0.00 34,196.53 -34,196.53 0.00 1421 COMP PLAN UPDATE 0.00 34,196.53 -34,196.53 0.00 101-1430-4010 Salaries and Wages 15,900.00 6,029.00 9,871.00 62.08 101-1430-4030 Retirement Contributions 2,200.00 836.07 1,363.93 62.00 101-1430-4040 Insurance Contributions 1,700.00 800.80 899.20 52.89 101-1430-4041 Contr Fix 0.00 31.24 -31.24 0.00 101-1430-4050 Workers Compensation 100.00 0.00 100.00 100.00 101-1430-4300 Consulting 9,500.00 2,100.00 7,400.00 77.89 101-1430-4370 Travel and Training 200.00 0.00 200.00 100.00 101-1430-4375 Promotional Expenses 500.00 0.00 500.00 100.00 1430 SENIOR FACILITY COMMISSION 30,100.00 9,797.11 20,302.89 67.45 101-1510-4130 Program Supplies 100.00 0.00 100.00 100.00 101-1510-4210 Books and Periodicals 100.00 0.00 100.00 100.00 101-1510-4340 Printing and Publishing 900.00 497.20 402.80 44.76 101-1510-4360 Subscriptions and Memberships 700.00 0.00 700.00 100.00 101-1510-4370 Travel and Training 400.00 33.95 366.05 91.51 1510 PARK COMMISSION 2,200.00 531.15 1,668.85 75.86 6 2007 2007 2007 2007 Account Number Description Budget End Bal A vaiVUncollect % A vaiVUncollcct 101-1520-4010 Salaries and Wages 89,200.00 34,829.16 54,370.84 60.95 101-1520-4030 Retirement Contributions 12,400.00 4,693.01 7,706.99 62.15 101-1520-4040 Insurance Contributions 11,400.00 5,189.18 6,210.82 54.48 101-1520-4041 ContrFlx 0.00 124.85 -124.85 0.00 101-1520-4050 Workers Compensation 400.00 0.00 400.00 100.00 101-1520-4120 Equipment Supplies 500.00 26.61 473.39 94.68 101-1520-4130 Program Supplies 200.00 12.76 187.24 93.62 101-1520-4210 Books and Periodicals 100.00 0.00 100.00 100.00 101-1520-4240 Uniforms & Clothing 200.00 0.00 200.00 100.00 101-1520-4300 Consulting 1,100.00 0.00 1,100.00 100.00 101-1520-4310 Telephone and Communications 900.00 199.38 700.62 77.85 101-1520-4330 Postage 400.00 0.00 400.00 100.00 101-1520-4340 Printing and Publishing 1,500.00 246.90 1,253.10 83.54 101-1520-4360 Subscriptions and Memberships 1,200.00 1,055.00 145.00 12.08 101-1520-4370 Travel and Training 3,800.00 1,255.41 2,544.59 66.96 101-1520-4380 Mileage 200.00 24.25 175.75 87.88 1520 PARK ADMINISTRATION 123,500.00 47,656.51 75,84349 61.41 101-1530-4010 Salaries and Wages 43,300.00 16,242.41 27,057.59 62.49 101-1530-4020 Temporary & Seasonal Wages 132,000.00 30,073.73 101,926.27 77.22 101-1530-4030 Retirement Contributions 28,000.00 6,293.79 21,706.21 77.52 101-1530-4040 Insurance Contributions 6,600.00 2,572.30 4,027.70 61.03 101-1530-4041 Contr Fix 0.00 124.85 -124.85 0.00 101-1530-4050 Workers Compensation 4,200.00 0.00 4,200.00 100.00 101-1530-4060 Unemployment 0.00 825.19 -825 .19 0.00 101-1530-4120 Equipment Supplies 8,000.00 1,158.75 6,841.25 85.52 101-1530-4130 Program Supplies 3,000.00 535.79 2,464.21 82.14 101-1530-4150 Maintenance Materials 500.00 0.00 500.00 100.00 101-1530-4300 Consulting 500.00 0.00 500.00 100.00 101-1530-4310 Telephone and Communications 1,500.00 961.25 538.75 35.92 101-1530-4320 Utilities 36,500.00 6,038.78 30,461.22 83.46 101-1530-4360 Subscriptions and Memberships 300.00 0.00 300.00 100.00 101-1530-4370 Travel and Training 400.00 0.00 400.00 100.00 101-1530-4375 Promotional Expenses 300.00 0.00 300.00 100.00 101-1530-4510 Repair & Maint- Buildings 2,500.00 0.00 2,500.00 100.00 101-1530-4530 Repair & Maint - Equipment 1,000.00 335.85 664 15 6642 101-1530-4590 Miscellanous Contract Services 500.00 0.00 500.00 100.00 1530 RECREATION CENTER 269,100.00 65,162.69 203,937.31 75.78 101-1531-4020 Temporary & Seasonal Wages 0.00 489.23 -489.23 0.00 101-1531-4030 Retirement Contributions 0.00 67.79 -67.79 0.00 1531 ROOM RENTAL 0.00 557.02 -557.02 0.00 101-1532-4020 Temporary & Seasonal Wages 0.00 3,258.99 -3,258.99 0.00 101-1532-4030 Retirement Contributions 0.00 293.81 -293.81 0.00 1532 FITNESS 0.00 3,552.80 -3,552.80 0.00 101-1534-4020 Temporary & Seasonal Wages 0.00 22,832.05 -22,832.05 0.00 101-1534-4030 Retirement Contributions 0.00 3,156.05 -3,156.05 0.00 101-1534-4130 Program Supplies 0.00 2,052.35 -2,052.35 0.00 101-1534-4300 Consulting 0.00 2,030.99 -2,030.99 0.00 101-1534-4590 Miscellanous Contract Services 0.00 500.00 -500.00 0.00 1534 DANCE 0.00 30,571.44 -30,571.44 0.00 101-1535-4130 Dance Costumes 0.00 4,294.53 -4,294.53 0.00 1535 DANCE COSTUMES 0.00 4,294.53 -4,294.53 0.00 10 1-1540-4020 Temporary & Seasonal Wages 12,800.00 0.00 12,800.00 100.00 101-1540-4021 Temp/Seasonal Overtime 500.00 0.00 500.00 100.00 101-1540-4030 Retirement Contributions 800.00 0.00 800.00 100.00 101-1540-4050 Workers Compensation 300.00 0.00 300.00 100.00 101-1540-4120 Equipment Supplies 3,800.00 0.00 3,800.00 100.00 7 2007 2007 2007 2007 Account Number Description Budget End BalAvaiVUncollect % AvaiVUncollect 101-1540-4130 Program Supplies 9,100.00 363.25 8,736.75 96.01 10 1-1540-4240 Uniforms & Clothing 500.00 0.00 500.00 100.00 101-1540-4300 Consulting 31,800.00 342.32 31,457.68 98.92 101-1540-4310 Telephone and Communications 3,600.00 1,290.92 2,309.08 64.14 101-1540-4320 Utilities 8,300.00 2,642.22 5,657.78 68.17 101-1540-4340 Printing and Publishing 300.00 0.00 300.00 100.00 1540 LAKE ANN PARK 71,800.00 4,638.71 67,161.29 93.54 101-1550-4010 Salaries and Wages 422,800.00 163,515.30 259,284.70 61.33 101-1550-4011 Overtime 8,000.00 1,530.98 6,469.02 80.86 101-1550-4020 Temporary & Seasonal Wages 79,000.00 6,842.50 72,157.50 91.34 101-1550-4021 Temp/Seasonal Overtime 3,000.00 0.00 3,000.00 100.00 101-1550-4030 Retirement Contributions 58,800.00 22,849.53 35,950.47 61.14 101-1550-4040 Insurance Contributions 71,000.00 32,031.13 38,968.87 54.89 101-1550-4041 Contr Fix 0.00 905.19 -905.19 0.00 101-1550-4050 Workers Compensation 9,500.00 0.00 9,500.00 100.00 101-1550-4120 Equipment Supplies 32,000.00 14,212.17 17,787.83 55.59 101-1550-4140 Vehicle Supplies 8.000.00 691.34 1,302.66 91.28 101-1550-4150 Maintenance Materials 33,000.00 4,240.89 28,759.11 87.15 101-1550-4151 Irrigation Materials 3,000.00 0.00 3,000.00 100.00 101-1550-4240 Uniforms & Clothing 2,800.00 0.00 2,800.00 100.00 101-1550-4260 Small Tools & Equipment 2,500.00 696.92 1,803.08 72.12 101-1550-4300 Consulting 18,000.00 8,716.57 9,283.43 51.57 101-1550-4310 Telephone and Communications 3,700.00 1,570.75 2,129.25 57.55 101-1550-4320 Utilities 6,000.00 4,168.92 1,831.08 30.52 101-1550-4340 Printing and Publishing 400.00 29.40 370.60 92.65 101-1550-4350 Cleaning and Waste Removal 9,000.00 1,289.43 7,710.57 85.67 101-1550-4360 Subscriptions and Memberships 400.00 105.00 295.00 7375 101-1550-4370 Travel and Training 2,000.00 367.05 1,632.95 81.65 101-1550-4400 Rental - Land and Buildings 23,500.00 1,080.46 22,419.54 95.40 101-1550-4410 Equipment Rental 2,000.00 0.00 2,000.00 100.00 101-1550-4440 Vehicle License & Registration 700.00 0.00 700.00 100.00 101-1550-4510 Repair & Maint- Buildings 3,000.00 297.29 2,702.71 90.09 101-1550-4520 Repair & Maint - Vehicles 2,500.00 0.00 2,500.00 100.00 101-1550-4530 Repair & Maint - Equipment 6,500.00 3,715.70 2,724.30 41.91 101-1550-4531 Repair & Maint - Radios 500.00 0.00 500.00 100.00 101-1550-4560 Repair & Maint - Signs 4,000.00 349.34 3,650.66 91.27 101-1550-4705 Other Equipment 4,000.00 4,938.41 -938.41 -23.46 101-1550-4933 Sales Tax 0.00 123.70 -12370 0.00 1550 PARK MAINTENANCE 819,600.00 274,333.97 545,266.03 66.53 101-1551-4260 Small Tools & Equipment 0.00 133.07 -133.Q7 0.00 101-1551-4320 Utilities 0.00 597.43 -597.43 0.00 1551 DOWNTOWN MAINTENANCE 0.00 730.50 -730.50 0.00 101-1560-4010 Salaries and Wages 26,900.00 11,039.30 15,860.70 58.96 101-1560-4030 Retirement Contributions 3,700.00 1,533.17 2,166.83 58.56 101-1560-4040 Insurance Contributions 300.00 0.00 300.00 100.00 101-1560-4050 Workers Compensation 200.00 0.00 200.00 100.00 101-1560-4120 Equipment Supplies 300.00 287.27 12.73 4.24 101-1560-4130 Program Supplies 3,500.00 428.67 3,071.33 87.75 101-1560-4300 Consulting 16,500.00 5,732.27 10,767.73 65.26 101-1560-4340 Printing and Publishing 100.00 0.00 100.00 100.00 101-1560-4350 Cleaning and Waste Removal 200.00 0.00 200.00 100.00 101-1560-4360 Subscriptions and Memberships 100.00 50.00 50.00 50.00 101-1560-4370 Travel and Training 300.00 110.00 190.00 63.33 10 1-1560-4375 Promotional Expenses 200.00 229.72 -29.72 -14.86 101-1560-4380 Mileage 100.00 0.00 100.00 100.00 1560 SENIOR CITIZENS CENTER 52,400.00 19,410.40 32,989.60 62.96 8 2007 2007 2007 2007 Account Number Description Budget End BalAvaiVUncolIect % AvaiVUncollect 101-1600-4010 Salaries and Wages 84,600.00 32,127.40 52,472.60 62.02 10 1-1600-4020 Temporary & Seasonal Wages 64,300.00 0.00 64,300.00 100.00 10 1-1600-4021 Temp/Seasonal Overtime 200.00 0.00 200.00 100.00 10 1-1600-4030 Retirement Contributions 14,900.00 4,472.54 10,427.46 69.98 10 1-1600-4040 Insurance Contributions 10,600.00 4,610.90 5,989.10 56.50 10 1-1600-4041 Contr Fix 0.00 199.76 -199.76 0.00 101-1600-4050 Workers Compensation 1,000.00 0.00 1.000.00 100.00 101-1600-4120 Equipment Supplies 2,000.00 0.00 2,000.00 100.00 101-1600-4130 Program Supplies 13,100.00 1,080.71 12,019.29 91.75 101-1600-4240 Uniforms & Clothing 1,500.00 0.00 1,500.00 100.00 101-1600-4300 Consulting 47,400.00 4,995.55 42,404.45 89.46 101-1600-4310 Telephone and Communications 3,300.00 286.00 3,014.00 91.33 101-1600-4320 Utilities 2,500.00 1,119.17 1,380.83 55.23 101-1600-4330 Postage 200.00 0.00 200.00 100.00 10 1-1600-4340 Printing and Publishing 4,400.00 0.00 4,400.00 100.00 101-1600-4370 Travel and Training 500.00 0.00 500.00 100.00 101-1600-4380 Mileage 500.00 0.00 500.00 100.00 101-1600-4400 Rental - Land and Buildings 5,500.00 0.00 5,500.00 100.00 10 1-1600-4410 Equipment Rental 17,700.00 0.00 17,700.00 100.00 101-1600-4530 Repair & Maint - Equipment 0.00 110.70 -110.70 0.00 1600 RECREATION PROGRAMS 274,200.00 49,002.73 225,197.27 82.13 101-1611-4130 Program Supplies 0.00 1,307.75 -1,307.75 0.00 101-1611-4340 Printing and Publishing 0.00 1,715.20 -1,715.20 0.00 101-1611-4400 Rental - Land and Buildings 0.00 440.98 -440.98 0.00 101-1611-4410 Equipment Rental 0.00 816.86 -816.86 0.00 1611 FEBRUARY FESTIVAL 0.00 4,280.79 -4,280.79 0.00 101-1612-4130 Program Supplies 0.00 1,676.89 -1,676.89 0.00 101-1612-4300 Consulting 0.00 490.60 -490.60 0.00 1612 EASTER EGG CANDY HUNT 0.00 2,167.49 -2,167.49 0.00 101-1613-4130 Program Supplies 0.00 120.00 -120.00 0.00 101-1613-4300 Consulting 0.00 400.00 -400.00 0.00 101-1613-4410 Equipment Rental 0.00 6,265.68 -6,265.68 0.00 1613 FOURTH OF JULY 0.00 6,785.68 -6,785.68 0.00 101-1616-4020 Temporary & Seasonal Wages 0.00 65.00 -65.00 0.00 101-1616-4030 Retirement Contributions 0.00 4.97 -4.97 0.00 1616 SUMMER PLAYGROUND 0.00 69.97 -69.97 0.00 101-1617-4020 Temporary & Seasonal Wages 0.00 6,325.34 -6,325.34 0.00 101-1617 -4030 Retirement Contributions 0.00 483.90 -483.90 0.00 101-1617-4410 Equipment Rental 0.00 2,974.84 -2,974.84 0.00 1617 ICE RINKS 0.00 9,784.08 -9,784.08 0.00 101-1700-4010 Salaries and Wages 21,200.00 8,031.90 13,168.10 62.11 10 1-1700-4020 Temporary & Seasonal Wages 13,600.00 0.00 13,600.00 100.00 101-1700-4030 Retirement Contributions 3,300.00 1,118.06 2,181.94 66.12 10 1-1700-4040 Insurance Contributions 2,600.00 1,152.72 1,447.28 55.66 101-1700-4041 Contr Fix 0.00 49.94 -49.94 0.00 10 1-1700-4050 Workers Compensation 100.00 0.00 100.00 100.00 101-1700-4120 Equipment Supplies 600.00 188.72 411.28 68.55 101-1700-4130 Program Supplies 8,000.00 0.00 8,000.00 100.00 101-1700-4300 Consulting 82,100.00 175.00 81,925.00 99.79 1700 SELF-SUPPORTING PROGRAMS 131,500.00 10,716.34 120,783.66 91.85 101-1710-4300 Consulting 0.00 6,289.20 -6,289.20 0.00 1710 PRESCHOOL SPORTS 0.00 6,289.20 -6,289.20 0.00 101-1711-4130 Program Supplies 0.00 225.00 -225.00 0.00 101-1711-4300 Consulting 0.00 50.00 -50.00 0.00 1711 PRESCHOOL ACTIVITIES 0.00 275.00 -275.00 0.00 101-1730-4300 Consulting 0.00 1,166.00 -1,166.00 0.00 9 Account Number Description 2007 Budget 2007 2007 2007 End BalAvaiVUncollect % AvaiVUncollect 1730 101-1731-4130 101-1731-4300 1731 101-1760-4020 101-1760-4030 1760 101-1761-4300 1761 101-1763-4130 1763 101-1764-4130 1764 101-1766-4130 101-1766-4300 1766 Grand Total Grand Total YOUTH SPORTS Program Supplies Consulting YOUTH ACTIVITIES Temporary & Seasonal Wages Retirement Contributions ADULT SPORTS Consulting ADULT ACTIVITIES Program Supplies SPRING 3-0N-3 BASKETBALL Program Supplies WINTER 3-0N-3 BASKETBALL Program Supplies Consulting SUMMER SOFfBALL 0.00 1,166.00 0.00 259.50 0.00 5,826.27 0.00 6,085.77 0.00 847.20 0.00 117.64 0.00 964.84 0.00 3,147.40 0.00 3,147.40 0.00 41.58 0.00 41.58 0.00 288.68 0.00 288.68 0.00 3,841.41 0.00 2,207.00 0.00 6,048.41 9,062,400.00 2,848,540.33 9,062,400.002,848,540.33 -1,166.00 -259.50 -5,826.27 -6,085.77 -847.20 -117.64 -964.84 -3,147.40 -3,147.40 -41.58 -41.58 -288.68 -288.68 -3,841.41 -2,207.00 -6,048.41 6,213,859.67 6,213,859.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 68.57 68.57 10 General Ledger Revenue-Budget vs Actual CITY OF User' danielle CHlNID8SEN Printed: 06/05/07 11'16.34 Period 01 - 05 Fiscal Year 2007 - 2007 2007 2007 2007 2007 Account Number Description Budget End BalAvaiIlUncollect % AvaiIlUncollect Revenue 101-0000-3002 Allowance for Delinquents 320,000.00 0.00 320,000.00 100.00 10 1-0000-30 10 Current Property Tax -6,558,100.00 0.00 -6,558,100.00 100.00 10 1-0000-3011 Delinquent Property Tax -50,000.00 0.00 -50,000.00 100.00 0000 -6,288,100.00 0.00 -6,288,100.00 100.00 Grand Total -6,288,100.00 0.00 -6,288,100.00 100.00 PROPERTY TAXES -6,288,100.00 0.00 -6,288,100.00 100.00 10\-0000-3205 Dog or Cat 0.00 -17.50 17.50 0.00 0000 0.00 -17.50 17.50 0.00 10\-1120-3284 Garbage Hauler -3,000.00 -1,800.00 -1,200.00 40.00 1120 ADMINISTRATION -3,000.00 -1,800.00 -1,200.00 40.00 101-1210-3213 Solicitor -500.00 -175.00 -325.00 65.00 101-1210-3226 Liquor On and Off Sale -84,000.00 -91,725.87 7,725.87 -9.20 1210 POLICE/CARVER CO CONTRACT -84,500.00 -91,900.87 7,400.87 -8.76 101-1250-3230 Rental Housing License -15,000.00 -8,350.00 -6,650.00 44.33 1250 CODE ENFORCEMENT -15,000.00 -8,350.00 -6,650.00 44.33 101-1260-3203 Dog Kennel -500.00 -446.50 -53.50 10.70 101-1260-3205 Dog or Cat -4,500.00 -2,703.25 -1,796.75 39.93 1260 AMINAL CONTROL -5,000.00 -3,149.75 -1,850.25 37.01 Grand Total -107,500.00 -105,218.12 -2,281.88 2.12 LICENSES -107,500.00 -105,218.12 -2,281.88 2.12 101-0000-3301 Building 0.00 -1,599.50 1,599.50 0.00 101-0000-3309 Fire Suppression 0.00 -37.63 37.63 0.00 0000 0.00 -1,637.13 1,637.13 0.00 101-1210-3308 Gun -1,000.00 -80.00 -920.00 92.00 1210 POLICE/CARVER CO CONTRACT -1,000.00 -80.00 -920.00 92.00 101-1220-3309 Fire Suppression -14,000.00 -9,422.45 -4,577.55 32.70 101-1220-3331 Firework's Application Fee 0.00 -400.00 400.00 0.00 1220 FIRE PREVENTION & ADMIN -14,000.00 -9,822.45 -4,177.55 29.84 101-1250-3301 Building -825,000.00 -261,829.60 -563,170.40 68.26 101-1250-3302 Plan Check -330,000.00 -148,065.02 -181,934.98 55.13 101-1250-3305 Heating & AlC -120,000.00 -42,439.21 -77,560.79 64.63 101-1250-3306 Plumbing -85,000.00 -52,859.07 -32,140.93 37.81 101-1250-3330 Elec Permit App Forms 0.00 -33.00 33.00 0.00 101-1250-3390 Miscellaneous Permits -100.00 -60.00 -40.00 40.00 1250 CODE ENFORCEMENT -1,360,100.00 -505,285.90 -854,814.10 62.85 101-1260-3320 Stable -300.00 0.00 -300.00 100.00 1260 AMINAL CONTROL -300.00 0.00 -300.00 100.00 101-1310-3307 Trenching -35,000.00 -7,673.30 -27,326.70 78.08 101-1310-3390 Miscellaneous Permits -850.00 -185.00 -665.00 78.24 1310 ENGINEERING -35,850.00 -7,858.30 -27,991.70 78.08 101-1420-3311 Sign -6,500.00 -5,150.00 -1,350.00 20.77 101-1420-3390 Miscellaneous Permits -50.00 0.00 -50.00 100.00 1420 PLANNING ADMINISTRATION -6,550.00 -5,150.00 -1,400.00 21.37 Grand Total -1,417,800.00 -529,833.78 -887,966.22 62.63 PERMITS -1,417,800.00 -529,833.78 -887,966.22 62.63 101-1210-3401 Traffic & Ordinance Violation -130,000.00 -38,800.68 -91,199.32 7015 1 2007 2007 2007 2007 Account Number Description Budget End BalAvaiVUncollect % AvaiVUncollect 101-1210-3405 Other Fines and Penalties 0.00 -3,009.73 3,009.73 0.00 1210 POLICE/CARVER CO CONTRACf -130,000.00 -41,810.41 -88,189.59 67.84 101-1260-3402 Vehicle Lock Out -2,500.00 -700 . 00 -1,800.00 72.00 101-1260-3404 Dog or Cat Impound -4,000.00 -2,285.82 -1,714.18 42.85 1260 AMINAL CONTROL -6,500.00 -2,985.82 -3,514.18 54.06 Grand Total -136,500.00 -44,796.23 -91,703.77 67.18 FINES & PENALTIES -136,500.00 -44,796.23 -91,703.77 67.18 10 1-0000-3509 Other Shared Taxes -20,000.00 0.00 -20,000.00 100.00 0000 -20,000.00 0.00 -20,000.00 100.00 101-1210-3510 State Grants -40,000.00 0.00 -40,000.00 100.00 1210 POLICE/CARVER CO CONTRACf -40,000.00 0.00 -40,000.00 100.00 101-1220-3509 Other Shared Taxes -145,000.00 0.00 -145,000.00 100.00 1220 FIRE PREVENTION & ADMIN -145,000.00 0.00 -145,000.00 100.00 Grand Total -205,000.00 0.00 -205,000.00 100.00 INTERGOVERNMENTAL REVENUES -205,000.00 0.00 -205,000.00 100.00 101-0000-3602 Variance & Cond Use Permits 0.00 -50.00 50.00 0.00 0000 0.00 -50.00 50.00 0.00 101-1120-3601 Sale of Documents -250.00 0.00 -250.00 100.00 101-1120-3651 Merchandise Sales 0.00 -180.00 180.00 0.00 1120 ADMINISTRATION -250.00 -180.00 -70.00 28.00 101-1130-3604 Assessment Search -500.00 -435.00 -65.00 13.00 101-1130-3619 Investment Mgmt Fee -75,000.00 0.00 -75,000.00 100.00 1130 FINANCE -75,500.00 -435.00 -75,065.00 99.42 101-1170-3613 Misc. - General Government -2,000.00 -679.64 -1,320.36 66.02 1170 CITY HALL MAINTENANCE -2,000.00 -679.64 -1,320.36 66.02 101-1190-3638 Food Concessions -1,500.00 -456.68 -1,043.32 69.55 1190 LIBRARY BUILDING -1,500.00 -456.68 -1,043.32 69.55 101-1210-3629 Misc.-Public Safety -2,000.00 -826.61 -1,173.39 58.67 1210 POLICE/CARVER CO CONTRACT -2,000.00 -826.61 -1,173.39 58.67 101-1310-3601 Sale of Documents -3,600.00 -488.38 -3,111.62 86.43 101-1310-3605 Plat Recording Fees -7,500.00 -450.00 -7,050.00 94.00 101-1310-3614 Construction Admin Fee -120,000.00 0.00 -120,000.00 100.00 101-1310-3617 Engineering General -1,000.00 0.00 -1,000.00 100.00 101-1310-3629 MiSC.-Public Safety -2,000.00 -900.00 -1,100.00 55.00 1310 ENGINEERING -134,100.00 -1,838.38 -132,261.62 98.63 101-1350-3649 Misc.-Public Works -5,000.00 0.00 -5,000.00 100.00 1350 STREET LIGHTING & SIGNALS -5,000.00 0.00 -5,000.00 100.00 101-1420-3601 Sale of Documents -150.00 -80.00 -70.00 46.67 101-1420-3602 Variance & Cond Use Permits -45,000.00 -15,895.00 -29,105.00 64.68 101-1420-3603 Rezoning -2,000.00 0.00 -2,000.00 100.00 101-1420-3605 Plat Recording Fees -2,500.00 -2,024.00 -476.00 19.04 101-1420-3613 Misc. - General Government -8,000.00 -880.00 -7,120.00 89.00 1420 PLANNING ADMINISTRATION -57,650.00 -18,879.00 -38,771.00 67.25 101-1530-3631 Recreation Center Operations -3,500.00 -1,128.32 -2,371.68 67.76 101-1530-3638 Food concessions 0.00 -250.00 250.00 0.00 1530 RECREATION CENTER -3,500.00 -1,378.32 -2,121.68 60.62 101-1531-3631 Recreation Center Operations -23,000.00 -11,839.30 -11,160.70 48.52 1531 ROOM RENTAL -23,000.00 -11,839.30 -11,160.70 48.52 101-1532-3630 Recreation Program Fees -9,000.00 -1,549.70 -7,450.30 82.78 101-1532-3631 Recreation Center Operations -50,000.00 -13,287.38 -36,712.62 7343 1532 FITNESS -59,000.00 -14,837.08 -44,162.92 74.85 101-1533-3631 Recreation Center Operations -500.00 -97.50 -402.50 80.50 1533 PERSONAL TRAINING -500.00 -97.50 -402.50 80.50 101-1534-3631 Recreation Center Operations -58,000.00 -32,069.42 -25,930.58 44.71 1534 DANCE -58,000.00 -32,069.42 -25,930.58 44.71 101-1540-3635 Watercraft Rental -4,000.00 -347.42 -3,652.58 91.31 2 2007 2007 2007 2007 Account Number Description Budget End BalAvail/Uncollect % AvaiVUncollect 101-1540-3638 Food Concessions -10,500.00 -109.39 -10,390.61 98.96 1540 LAKE ANN PARK -14,500.00 -456.81 -14,043.19 96.85 101-1541-3634 Park Facility Usage Fee -12,000.00 -3,545.80 -8,454.20 70.45 1541 PICNICS -12,000.00 -3,545.80 -8,454.20 70.45 101-1545-3633 Equipment Rental -200.00 0.00 -200.00 100.00 1545 VOLLEYBALL KITIBALLFIELD RENT -200.00 0.00 -200.00 100.00 101-1546-3639 Misc. Park & Rec. -800.00 -720.00 -80.00 10.00 1546 CANOE RACK RENTAL -800.00 -720.00 -80.00 10.00 101-1560-3637 Senior Programs -30,000.00 -12,876.06 -17,123.94 57.08 1560 SENIOR CITIZENS CENTER -30,000.00 -12,876.06 -17,123.94 57.08 101-1600-3636 Self Supporting Programs 0.00 0.50 -0.50 0.00 1600 RECREATION PROGRAMS 0.00 0.50 -0.50 0.00 101-1611-3636 Self Supporting Programs -5,000.00 -4,093.74 -906.26 18.13 1611 FEBRUARY FESTIVAL -5,000.00 -4,093.74 -906.26 18.13 101-1613-3636 Self Supporting Programs -6,400.00 -820.00 -5,580.00 87.19 1613 FOURTH OF JULY -6,400.00 -820.00 -5,580.00 87.19 101-1614-3630 Recreation Program Fees -3,000.00 0.00 -3,000.00 100.00 1614 HALLOWEEN PARTY -3,000.00 0.00 -3,000.00 100.00 101-1616-3630 Recreation Program Fees -18,000.00 -10,733.24 -7,266.76 40.37 1616 SUMMER PLAYGROUND -18,000.00 -10,733.24 -7,266.76 40.37 101-1710-3636 Self Supporting Programs -36,000.00 -25,428.35 -10,571.65 29.37 1710 PRESCHOOL SPORTS -36,000.00 -25,428.35 -10,571.65 29.37 101-1711-3636 Self Supporting Programs -1,600.00 -118.31 -1,481.69 92.61 1711 PRESCHOOL ACTIVITIES -1,600.00 -118.31 -1,481.69 92.61 101-1730-3636 Self Supporting Programs -28,000.00 -11,015.52 -16,984.48 60.66 1730 YOUTH SPORTS -28,000.00 -11,015.52 -16,984.48 60.66 101-1731-3636 Self Supporting Programs -50,000.00 -23,597.21 -26,402.79 52.81 1731 YOUTH ACTIVITIES -50,000.00 -23,597.21 -26,402.79 52.81 101-1760-3636 Self Supporting Programs 0.00 -40.00 40.00 0.00 1760 ADULT SPORTS 0.00 -40.00 40.00 0.00 101-1761-3636 Self Supporting Programs -8,500.00 -4,621.28 -3,878.72 45.63 1761 ADULT ACTIVITIES -8,500.00 -4,621.28 -3,878.72 45.63 101-1763-3636 Self Supporting Programs -650.00 -126.88 -523.12 80.48 1763 SPRING 3-0N-3 BASKETBALL -650.00 -126.88 -523.12 80.48 101-1764-3636 Self Supporting Programs -1,450.00 -747.21 -702.79 48.47 1764 WINTER 3-0N-3 BASKETBALL -1,450.00 -747.21 -702.79 48.47 101-1766-3636 Self Supporting Programs -19,200.00 -17,971.85 -1,228.15 6.40 1766 SUMMER SOFTBALL -19,200.00 -17,971.85 -1,228.15 6.40 101-1767-3636 Self Supporting Programs -3,200.00 0.00 -3,200.00 100.00 1767 FALL SOFTBALL -3,200.00 0.00 -3,200.00 100.00 Grand Total -660,500.00 -200,478.69 -460,021.31 69.65 CHARGES FOR SERVICES -660,500.00 -200,478.69 -460,021.31 69.65 101-0000-3801 Bank Interest Earnings -70,000.00 0.00 -70,000.00 100.00 101-0000-3803 Building Rental 0.00 -1,800.00 1,800.00 0.00 101-0000-3807 Donations -5,000.00 0.00 -5,000.00 100.00 101-0000-3812 Contractor Verification 0.00 -5.00 5.00 0.00 101-0000-3903 RefundslReimbursements 0.00 -1.00 1.00 0.00 101-0000-3910 Miscellaneous Revenue 0.00 -383.45 383.45 0.00 0000 -75,000.00 -2,189.45 -72,810.55 97.08 101-1110-3903 Refunds/Reimbursements 0.00 -14.25 14.25 0.00 1110 CITY COUNCIL 0.00 -14.25 14.25 0.00 101-1120-3802 Equipment Rental & Sale -110,000.00 -30,790.26 -79,209.74 72.01 101-1120-3804 Land Sale 0.00 -1,200.00 1,200.00 0.00 101-1120-3903 RefundslReimbursements -500.00 -4.00 -496.00 99.20 1120 ADMINISTRATION -110,500.00 -31,994.26 -78,505.74 71.05 101-1130-3820 Misc. Other Revenue -5,000.00 -60.00 -4,940.00 98.80 3 2007 2007 2007 2007 Account Number Description Budget End BalAvaiVUncollect % AvaiJ/Uncollect 101-1130-3829 InterestIPenalty -500.00 0.00 -500.00 100.00 10 1-1130-3903 RefundslReimbursements -5,000.00 -0.03 -4,999.97 100.00 101-1130-3980 Cash Short/Over 0.00 -7.22 7.22 0.00 1130 FINANCE -10,500.00 -67.25 -10,432.75 99.36 101-1140-3808 Insurance Reimbursements 0.00 0.00 0.00 0.00 1140 LEGAL 0.00 0.00 0.00 0.00 101-1170-3808 Insurance Reimbursements -5,000.00 0.00 -5,000.00 100.00 101-1170-3903 RefundslReimbursements -600.00 -330.00 -270.00 45.00 1170 CITY HALL MAINTENANCE -5,600.00 -330.00 -5,270.00 94.11 101-1190-3803 Building Rental 0.00 0.00 0.00 0.00 1190 LIBRARY BUILDING 0.00 0.00 0.00 0.00 10 1-1210-3807 Donations -2,000.00 -2,500.00 500.00 -25.00 101-1210-3903 RefundslReimbursements 0.00 0.00 0.00 0.00 1210 POLICE/CARVER CO CONTRACT -2,000.00 -2,500.00 500.00 -25.00 101-1220-3807 Donations 0.00 -500.00 500.00 0.00 101-1220-3903 RefundslReimbursements -2,500.00 0.00 -2,500.00 100.00 1220 FIRE PREVENTION & ADMIN -2,500.00 -500.00 -2,000.00 80.00 101-1250-3816 SAC Retainer -5,000.00 -157,832.25 152,832.25 -3,056.65 101-1250-3818 Sur-Tax Retainer -1,500.00 -276.28 -1,223.72 81.58 101-1250-3903 RefundslReimbursements -1,500.00 -632.90 -867.10 57.81 101-1250-3980 Cash Short/Over 0.00 -0.03 0.03 0.00 1250 CODE ENFORCEMENT -8,000.00 -158,74146 150,741.46 -1,884.27 101-1310-3903 RefundslReimbursements -500.00 -25.00 -475.00 95.00 1310 ENGINEERING -500.00 -25.00 -475.00 95.00 101-1320-3903 RefundslReimbursements -1,250.00 -252.82 -997.18 79.77 101-1320-3910 Miscellaneous Revenue 0.00 -200.00 200.00 0.00 1320 STREET MAINTENANCE -1,250.00 -452.82 -797.18 63.77 101-1350-3903 RefundslReimbursements -11,000.00 -75.32 -10,924.68 99.32 1350 STREET LIGHTING & SIGNALS -11,000.00 -75.32 -10,924.68 99.32 101-1370-3903 RefundslReimbursements -700.00 -62.50 -637.50 91.07 1370 CITY GARAGE -700.00 -62.50 -637.50 91.07 101-1420-3903 RefundslReimbursements -100.00 -26.16 -73.84 73.84 1420 PLANNING ADMINISTRATION -100.00 -26.16 -73.84 73.84 101-1520-3903 Refunds/Reimbursements -5,000.00 0.00 -5,000.00 100.00 1520 PARK ADMINISTRATION -5,000.00 0.00 -5,000.00 100.00 101-1530-3903 RefundslReimbursements 0.00 -8.00 8.00 0.00 1530 RECREATION CENTER 0.00 -8.00 8.00 0.00 101-1534-3903 RefundslReimbursements -500.00 0.00 -500.00 100.00 1534 DANCE -500.00 0.00 -500.00 100.00 101-1550-3903 RefundslReimbursements -500.00 -3,586.80 3,086.80 -617.36 1550 PARK MAINTENANCE -500.00 -3,586.80 3,086.80 -617.36 101-1560-3807 Donations 0.00 -830.56 830.56 0.00 1560 SENIOR CITIZENS CENTER 0.00 -830.56 830.56 0.00 101-1600-3807 Donations -13,000.00 -7,300.00 -5,700.00 43.85 101-1600-3903 RefundslReimbursements -150.00 -53.80 -96.20 64.13 1600 RECREATION PROGRAMS -13,150.00 -7,353.80 -5,796.20 44.08 101-1617-3903 RefundslReimbursements 0.00 -400.00 400.00 0.00 1617 ICE RINKS 0.00 -400.00 400.00 0.00 101-1731-3903 Refu ndslReimbursements -200.00 0.00 -200.00 100.00 1731 YOUTH ACTIVITIES -200.00 0.00 -200.00 100.00 Grand Total -247,000.00 -209,157.63 -37,842.37 15.32 MISC REVENUE -247,000.00 -209,157.63 -37,842.37 15.32 Grand Total -9,062,400.00 -1,089,484.45 -7,972,915.55 87.98 4 Date June 25, 2007 July 16,2007 July 20, 2007 August 3, 2007 August 17, 2007 August 27, 2007 September 10, 2007 September 21,2007 October 8, 2007 October 22, 2007 November 12,2007 November 26, 2007 December 3, 2007 December 10, 2007 December 26, 2007 2008 Budget Calendar Department All Depts/Council Finance Finance All Departments All Departments Finance & Admin Council Finance Finance, Comm Dvlp Task Preliminary review with City Council on 2008 Budget Calendar and Budget Forecasts. Distribute 2007 General Ledger Detail, 2008 Operating Budget Preparation Worksheets, 2008-2012 CIP worksheets. 2008 Payroll and Revenue Projections distributed. Completed operating budget forms returned to Finance. All 2008-2012 CIP requests returned to Finance. Preliminary budget and levy discussion at City Council work session. Approval/Certification of Maximum Proposed Levy to Carver County Auditor. CIP proofs returned to departments. Finance, Admin, Fire Finance, PW, Park & Rec City Council Budget work session PW, Park & Rec City Council Budget work session Community Dvlp. Finance & Admin Council Council Finance Budget work session with City Council Admin, Fire, finance, and CIP. Budget work session continuation of Finance and CIP if needed. Truth in Taxation Hearing Continuation Hearing, if needed, and Budget and CIP Adoption Final Date for 2008 Budget & Levy Certification to Carver County Auditor '" o '" Q) e: e: ~ C Q) '" '" ~.~ ~~LO G~g -1-'" ~~8 OS~ :E -Q) _f!C jgw'U o e: Q) I-Q)'O Cle: o lD a -~'" ~:5 .~ ~o~ 00 .0 g~'o 000: "'Cl 'OE -"'''' ~~.~ :g ~ ~ 0000 ~ lD c- '" ~E'O o-e: 000 "'CllD en a. UJ mS-g ~oS Cl a g,o.~ ~C).3 ::> 00 <0: '" ""0'0 g<'!)5 '" lD c- <( ':; VJ 8&ffffi ~ou Cl c- u'S rn o Lff ai ~gu '" o .~ (a1ii~ o~...J -"'Q) .g~.2 00 '" > ~ <(~f/J g~~ "'OlD Cl -"" Q)~"" a:.~m~ U<o:ll.e: lOCX)OO ~~CllD ~~<O8~~8888>188888 vmJ::::"-lOOJOOC\lVlOo..-comr--LO ~~M~m~m~NN~~NMM~ lOC\lC\I__NOlOOOOO____ COAOlAqqCO co v Ii) Ii) Ii) Ii) Ii) Ii) LO 10 LO COOJ('t)MIOO VVOOO>C\I oU')t'--<e_v ~~~~-~~ COOJMMlOO """"","oomN OLOr--ta.....'V ~~~~~~ 8888 MLOCOCO m(J)Aaim NNC\lC\l 8888 (I') LO co CD mmAmAo)' NC\lNC\I 888 ggg :!g~8 CONCXJO> "'Ct- 05.<:f"': COOJCOC>> v.q-"o:t(\J 8888 0:>0>1'--0> aO cD cD ,...: OljOljOljgj ""0'" ~ co.... co"'~ 00-_-05 "'..,.'" 8 8 8>1 8 8 888 8 08 8 8 8 8 8 LO<OCOO"",""""OOC\lVlf) _OOQ)r--LO ~aOr.D~r.Da005~NN,..:mNMM,.... C\lcoOJ<ommo>ooooo____ ...-_ __ __ v_ v """ 'V lO LO LO LO LO It) LO LO LO 8888888888>188888 ,......-t--M""" V mC\l v LOO"-OO 0) r--LO r.DoiO~r.Da005~NN,..:aONMM,.... (0000>0)0>0>0>00000____ V"""""'" "","v"",""""lOLOlOlOlOli)lOli)lO 8888 COlOm,.... "<DonN MmO),.... <0 (0 co 0> e: _.Q 013 (ij~ Q) 0 >-u <er--OJOlO_NMvLOcor--mmO_ 8888ooooc;c;oooo~~ C\IC\1NC\lC\lC\lC\lC\lC\lC\lC\lC\lC\lC\lC\lC\I '" co '" <0 '" C> '" '" ;;; co '" .... '" ;;; <Xl '" .... 8 co :;;: 8 co o o o o o '" .... <0 <0 '" '" .... o o '" .... '" '" .... <0 '" co :;;: 8 ..,. ..,. ~ ;: o o '" ..,. '" o co o o Ol Ol Ol C> '" '" Cii o I- ~ ~ JI..J g"'ggg ..... ~,...,........ "" cONaiaia5 M~MMM ~ CJ!. m. O'!. O!. ggggggggggggggg ........................................................................... aSa5a5aSaiajajajcOaSaiaiaia5a5 MMMMMMMMMMMMMMM ~~Ol~~~~~~~~~~~~ ~~ ~~~m~~~mmm~~~~~~ ~;.. ~~~~~~~~~~~~~~~~ ~8 ~~~~~~~~w~~~~~~~ l1. )( '" toE ~~~~ro -I) .nC"'imciaS ""C WtOU).,....C\l ~l ~ ~~ '" >,- a>iYl -'a. ]gU ~} ~~~~~~2~~g8~2g~g8888 ~~~mMIDMID~~N~NMM~OOOo MOO~~NOODO~NMMMMNNNN mDN~~~~~~~~~~~~~~~~~ ~':NNN"": .,..:.,..:~a~a.,..:.,..:.,..:.,..:~..,..:.,..: ~ Q) >- 88885~5~5~~~~~~~~~~~ NNNNNNNNNNNNNNNNNNNN e: o 0+= ~ '" ~U5 ~ u: 888888888888888 cS cS 0- 0- 0 0 0 0 0 0 0 0 000 f'-."""f'-.f'-.f'-.f'-.f'-.f'-.f'-.f'-.f'-.f'-.f'-.f'-.f'-. MMMMMMMMMMMMMMM ~ mOo 0'" ou. "'s: a. 888>18>1>1>1>1>18880000 00000000000008888 00000000660000000 ~~~~~~~~~~~~~~~~~ NNNNNNNNNNNNNNNNN '" '0 ",e: 8S "'''' N 88888888888 o. cS ~ ~ ~ ~ ~ ll'i" ..0 ~ LO mmmmmmco(X)(X)coco NNNNNNNNN E '" co '" 0<0: ~~ c- OO E '" ....'" 8<0: "'1rl c- OO E '" <0'" 8<0: '" 1rl c- OO E ",'" 8~ '" 0 Q) c- OO ~f'-.(X)mO~NM~~w"""mmO~NM~~ 8888oooooooooo~~~~~~ NNNNNNNNNNNNNNNNNNNN '" Cii o I- '" co '" ;0 ..,. <0 '" o M o ..,. 8 o o '" '" on o o o o '" '" ..,. 8 '" '" .... '" <ii c. g "5. .s c ~ E '" a .,; ~ ~ .2 ;< 11 " 5 12 .. c " ~ ." 0- '" -g '" c ~ u; ~ il: ~ -g '" 12 "0 " "0 C .8 " ., o ~ lil " ,. > !E 15 ~ " 5 c ~ o "0 ,. ~ 2 3l " " ., 2 .. ~ " .. ~ .~ o M .. ~ " :.c ~ "5 c o E en M .. 12 .. ~ .0 ~ :;: n. ~ CITY OF CHANHASSEN KEY FINANCIAL STRATEGIES Inflation Assumptions for General Fund Revenue 3.00% Expenses 3.00% 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 GENERAL FUND ACTUAL ACTUAL ACTUAL ACTUAL Budgel PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED REVENUE GENERAL PROPERTY TAX 6,118.451 6.461,356 6,229,593 6,185,311 6,288,100 6.476,743 6,671,045 6,871,177 7,077,312 7,289,631 LICENSES 119,905 102,636 132,932 99,809 107,500 110,725 114,047 117,468 120,992 124,622 PERMITS 1,265,597 1,191.420 1,027,205 1,346,154 1,417,800 1.460,334 1,504,144 1,549,268 1,595,746 1,643,619 FINES & PENALTIES 43,732 61,801 104,962 162,946 116,500 159,995 164,795 169,739 174,831 180,076 INTERGOVERNMENTAL REVENUE 223,618 360,226 219,511 237,109 205,000 211,150 217.485 224,009 230,729 237,651 CHARGES FOR CURRENT SERVICES 609,512 721,470 697,532 699,228 660,500 680,315 700,724 721,746 743,399 765,701 OTHER REVENUE 334,072 168,644 390,112 386,321 247,000 314.410 323,842 333,558 343,564 353,871 TOTAL REVENUE 8,714,887 9,067,553 8,801,847 9,116,878 9,042,400 9,413,672 9,696,082 9,986,965 10,286,574 10,595,171 EXPENSES EXCL CAPITAL COSTS GENERAL GOVERNMENT 1,548,062 1,751,744 1,822,354 1,859,326 1,959,200 2,017,976 2,078,515 2,140,871 2,205,097 2,271,250 LAW ENFORCEMENT 2.424,125 2.429.464 2,525,399 2,614.437 2,837,600 3,022,728 3,238.410 3.410,562 3,512,879 3,618,265 PUBLIC WORKS 1,678,314 1,773,655 1,823,564 1,967,815 2,089.400 2,152,082 2,216,644 2,345,644 2.478,513 2,615,389 COMMUNITY DEVELOPMENT 312,446 325,917 362,100 383,979 411,900 424,257 436,985 450,094 463,597 477,505 PARKS AND RECREATION 1,632,218 1,620,979 1,592,911 1,670,616 1,744,300 1,796,629 1,850,528 1,906,044 1,963,225 2,022,122 OTHER USES 815,000 807,786 2,751,497 TOTAL EXPENSES 8,410,165 8,709,545 8,126,328 11,247,670 9,042,400 9,413,672 9,821,082 10,253,215 10,623,311 11,004,510 REVENUE OVER (UNDER) EXPENSES Fund Balance 5,917,535 6,275,543 6,951,062 4,820,270 4,820,270 4,820,270 4,695,270 4.429,020 4,092,283 3,682,943 Policy for Cash Flow' 3,328,530 3,224,552 3,211,210 3,246,550 3,343,947 3,444,265 3,547,593 3,654,021 3,763,641 Catastrophic Reserve .. 1,218,949 1,687,151 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 1,300,000 4,443,501 4,898,381 4,546,550 4,643,947 4,744,265 4,847,593 4,954,021 5,063,641 Percentage of Fund Balance Per Polley 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% Excess Fund Balance 1,832,042 2,052,701 273,720 176,324 76,005 (152,323) (525,001 ) (971,359) 3,682,943 Assumptions. Added On 2006 2007 2008 2009 2010 2011 2012 Permit Revenue Expenses General Government Law Enforcement... 100,000 125,000 75,000 Public Works 62,500 Parks and Recreation 100,000 125,000 137,500 Policy for cash flow is 1/2 of next years property tax and intergovernmental revenue Catastrophic reserve informal policy is cash flow policy listed above plus 15% of next years expenditures New Law enforcement employees include: - 1/2 New Investigator in 2008 - 1/2 Patrol Officer in 2008 - 1/2 New Investigator in 2009 - 1/2 School Resource Office in 2009 - 1/4 Patrol Officer in 2009 - 3/4 Patrol Officer in 2009 News . Bureau of labor Statistics United States Department of labor Washinaton, D.C. 20212 FOR TECHNICAL INFORMATION: Patrick C. Jackman (202) 691-7000 USDL-07-0708 CPI QUICKLINE: (202) 691-6994 TRANSMISSION OF FOR CURRENT AND HISTORICAL MATERIAL IN THIS INFORMATION: (202) 691-5200 RELEASE IS EMBARGOED MEDIA CONTACT: (202) 691-5902 UNTIL 8:30 A.M. (EDT) INTERNET ADDRESS: htto://www.bls.gov/coi/ Tuesday, May 15,2007 CONSUMER PRICE INDEX: APRIL 2007 The Consumer Price Index for All Urban Consumers (CPI-U) increased 0.6 percent in April, before seasonal adjustment, the Bureau of Labor Statistics ofthe U.S. Department of Labor reported today. The April level of 206.686 (1982-84= 1 00) was 2.6 percent higher than in April 2006. The Consumer Price Index for Urban Wage Earners and Clerical Workers (CPI-W) increased 0.8 percent in April, prior to seasonal adjustment. The April level of202.130 (1982-84=100) was 2.5 percent higher than in April 2006. The Chained Consumer Price Index for All Urban Consumers (C-CPI-U) increased 0.5 percent in April on a not seasonally adjusted basis. The April level of 119.543 (December 1999=100) was 2.3 percent higher than in April 2006. Please note that the indexes for the post-2005 period are subject to revision. CPI for All Urban Consumers (CPI-U) On a seasonally adjusted basis, the CPI-U advanced 0.4 percent in April, following a 0.6 percent increase in March. The index for energy increased 2.4 percent after advancing 5.9 percent in March. In April, the index for petroleum-based energy rose 4.6 percent versus a 10.1 percent increase in March. The food index rose 0.4 percent in April, slightly more than in March. The index for all items less food and energy advanced 0.2 percent in April, following a 0.1 percent rise in March; the index for shelter rose 0.3 percent after advancing 0.1 percent in March, resulting from an upturn in the index for lodging away from home. Table A. Percent chan es in CPI for Urban Consumers CPI- SeasonaIl ad'usted Un- a~iusted l2-mos. ended A r. '07 2.6 3.7 3.4 -.4 .6 4.0 .3 2.2 3.7 2.9 3.7 2.3 Compound Expenditure annual rate Category 3-mos. ended Oct. Dec. Jan. A r. '07 All Items -.4 .4 .2 5.7 Food and beverages .3 -.1 .7 6.1 Housing .0 .4 .2 3.4 Apparel -.5 .2 .3 -3.3 Transportation -3.0 1.7 -.8 17.4 Medical care .3 .2 .8 3.9 Recreation .1 -.3 .1 .1 Education and communication .2 -.2 .2 -.1 .3 .5 .3 4.4 Other &oods and .2 .1 .6 .8 .2 .2 .3 2.5 servIces Special Indexes Energy -6.7 -.2 4.2 -1.5 .9 5.9 2.4 43.3 Food .3 -.1 .0 .7 .8 .3 .4 6.1 All Items less food and ener .1 .1 .1 .3 .2 .1 .2 1.9 "0 c ::> LL C 0> E '" '" 0> '" '" <( Cl c os; o > 0> OC I'- (; '" 000 000 000 000 000 ~::!..CO <0 (; '" 000 000 000 666 000 q~<o It) (; '" 000 000 000 666 ~~@ <:t (; '" 000 000 000 c5oo~ 000 q::!.<D ~ '" (; C\I 000 888 c:i o~ o~ 000 q~(O ~ '" (; '" 000 000 000 660 000 q::!..C.D ~ (; '" 000 000 000 000 OCO'" ~~I'- o (; '" 000 000 000 o~ ci c5 o<O<:t O>~ t:::. ,...._ 0> o o '" 000 000 000 o~c5o 000 o. .::!,.<O co o o '" 000 000 000 ci o. c5 o<:t<O tq,,!:e..C) I'- o o '" 000 000 000 C\I- c5 N- It)0lt) I'-"'<:t c-J:::"": <0 o o '" It) o o '" 'D'!- o <:t '" Cii'E 8~~ 1J~c55 'e~~ Q.<(() (ooco It)O><O O><O~ aiC'i<6 I'-~CO co It) 00,.... COO>~ O>I'-CO C'i <6 <:t- 1'-"'''' -It) <0 mOM ~O>o CO"'I'- C\f"":oi 1'-"'<0 f2L{)f'. ooC') <:to>co <0 '" '" N-"":o> '" '" '" ~LO""" moLO 1'-0>1'- <0 '" co .tc-J" <:t"'o> !:e.LO(o 000".... '" 0> <0 LOO><:t ai.q:crf co '" '" eLOCD 00""" 1'-1'-<0 coO>~ "":"":w "'~lt) t::.<:tlt) NLO,.... <:to>1'- <O~I'- mu)ri '" co '" -I'-<:t L{)MM It)~<O A"'''' woci ~~<O or:.!:e.('I') co <0,..... coco<:t ~O>'" "':mcD co <0 <0 <0"'''' c-J- 000 "'00 0>00 cDMt-: <O<Olt) "'- III 0<:t<:tO> 0....-0)0 DooMN oai.t.t 0,............0> q<:t <:t ~ 6""'0)<0 ONNLO O<OMcn Or-:Na> 01'- I'- q ~ olOlOo OC\lLOCO ow,.... 0) O"":NM 0""'-"'" q- - ~ Soma> OWLO...... OCJ')ooro 0""'- ci C\I- O<.o,....f'., q~-f2 ~ oM'coo Q......C\I.q o C\I oo;;t <0 c5~ajN O............('f') q~-~ ~ OCONO> 0('-..0,.... 00<0<0 g~ct~ q~-~ OLONCO OMC)N O""""""lO omcDro OLONCO N_e-e ~ ssss 0.......0,...., OtONOO ci err,...:,.....- OONN CJ)_C-t::::.. ~ oiOt=:'N' ao>..qq 000,...,<0 ooq--uj' 0'" '" q- - ~ OCOWLO O"d"OLO OlOLOO OMNcO DOOM,.... to. q ....-_ oococo OC\Jc:oco ocnC\l..- c-JaSair-.: LO 0....... co 1'-<0 <0 ~N N '" Iii 013 0> c. 0> ~ ~ >- "'",Iii 0 C ~~ ~ ~ Iii ~Q.():o Iii ~ >-~~~~~~ 5a>ar~'e~25 u......J(( a...f:l:u.. >- o OJ o '" 0> cD <0 '" III <:tl'-I'-<:t<:t<:t<:tco ......com,....,....,....,....(Y) <:to "l "'. <:to <:to <:to <:to -i ~~~~~~~; .t <0 V> "'<:tl'-I'-<:t<:t<:tco c.o,....com,....,...........C"') a. <:to "l "'. <:t_ <:t_ <:t_ -i 8~~~~~~; ~ <:t- <0 V> o"'<:tl'-I'-<:t<:tco OtO......rom,....,....C') "l q <:to "l ~ <:to <:to -i ~8~~~~~; C\J....-,.... ~ (0 V> OOM""''''''''''''''''CO ODco......com....-C") o_~q"":('I)_N_""'_~ '!:tmM"d"C\J......""',.... MOOCON,....,CO<l:t C\I...... ~ <0 V> OOO"'<:tl'-I'-CO OaOCO....-COO>M o_O_'1.0_~M_C\!.<t::i M""'CD('I')"'=tN............ (\JMOOCON......""" C\J,.... ,.... ~ <0 V> ooo"'<:tl'-lt) OOO<D.....CON o_o_"'.o.<l:."'.t..: C'1q-O)C'1"l:tNO) N(')OO<DNN N..... ...........- I'- V> OOO(')'!::tN 000(0.....(') o.q"'.o.<:t.t..: (')'l:::tO)(')q-OO "''''00<0''' N..... N '" y; 000('1')00 OOOID(') qq"lq-i (')'I:::t 0) (')..... ",,,,oo<:t C\J........; <0 V> 0000 0000 O_O_~M (')'I:j'o)ID N('l')OO "'C'i o y; 00'" 001'- 00 0 _ _ <0 "'<:t<:t '" '" '" ai o '" V> 00 00 0_0 "'a "'0 .t '" V> o o c:i o o c-J <:t y; LO<D......COo>O.....N 00000............... 00000000 C\JNC\JC\JNC\JNC\J 0> S "0 1l~ u<O en@ c- O> E E '" >-'" '" '" c.~ 0> >- OCco ~ 0> >- ti 0> "0 0: Ul CI) Ul Ul CI) III (.) CI) e tc.. .5 a; CI)~ W::s 'E1Il CI) c (.) .- '-'0 CI) CI) c.. Ul :J CI) Ul- III Ul CI) C '- 0 (.)0 .5 :: CI) CI) WZ 'ES CI) CI) ~ :J Cl)O c.. ~ o - .!:!! ::r: Ul CI) ::s iij > '0 CI) Ul Ul CI) Ul Ul c( C CI) Ul Ul III .r:. C III .r:. o - o >- - (3 CI) ::s ~iij III > CI)_ '- CI) (.).lIl: C '- III ~~ '0 Ul OW .5 c o :;:; (.) ::s '- - Ul C o o :: CI) z '0 CI) - III E :;:; Ul W CI) ::s iij > i.E .lIl: :a~ :2:.g 'O~ .!lc.. III E :;:; Ul W ~ <fl. <fl. ..... 0 0 ~ 0 LO "(ij C\i C\i > ~ ~ o o 0) C\i ~ o o ex> - o Z <fl. <fl. <fl. o ex> ..- 0) C\I ...... C\i C\i C\i ~ o C\I 0) C\i ~ o o ex> o 0 0 0 o 0 0 0 LO 0) ...... LO cr) ~ 00 0> 0) ..- ~ ('I) "l C\I "l ~ C\i ..- ~ 0) LO LO C\I C\I ('I) ..- co C\I 000 0 o 0 0 0 CO III 0) CO o..-oC\i ..- ex> 0 C\I ~ LO CO C\I 0> C\i 0 cr) LO LO ...... ex> 00000 00000 ..- <C!. LO C\I ...... 00 ..- to ..0 ~- CO CO ...... C\I CO LO 0) ..- LO 0) o>ocr)~ro ~ ..- 0 LO 0 o ('I) CO ex> C\I C\i C\i C\i C\i cr) = ('I)~LOCO"""ex> Cl) 000000 > ~~~~~~