The URL can be used to link to this page

Home My WebLink AboutNovember 6, 2006 Budget Work Session 590 40th Avenue N.E., Columhia Heights, MN 55421-3878 (763) 706-3600 TDD (763) 706-3692 Visit Our Website at: www.ci.columbia-heights.l1lll.us Mavor Gary L. Peterson Counci/members Robert A. Williams Bruce Nawrocki Tammera Ericson Diehm Bruce Ke/zenberg Citv Manaaer Walt Fehst CITY OF COLUMBIA HEIGHTS ADMIN/STRA TION NOTICE OF CITY COUNCIL MEETING ************ to be held in the CITY OF COLUMBIA HEIGHTS as follows: Meeting of: Date of Meeting: Time of Meeting: Location of Meeting: Purpose of Meeting: COLUMBIA HEIGHTS CITY COUNCIL NOVEMBER 6, 2006 7:00 P.M. CONFERENCE ROOM 1 BUDGET MEETING AGENDA 1. Community Development budget-7:00 p.m. 2. Police Department budget -7:30 p.m. 3. Finance/IS budget - 8:00 p.m. 4. Liquor budget- 8:30 p.m. The City of Columbia Heights does not discriminate on the basis of disability in the admission or access to, or treatment or employment in, its services, programs, or activities. Upon request, accommodation will be provided to allow individuals with disabilities to participate in all City of Columbia Heights' services, programs, and activities. Auxiliary aids for handtapped persons are available upon request when the request is made at least 96 hours in advance. Please call the City Council Secntary at 706-3611, to make arrangements. (TDD/706-3692 for deaf or hearing impaired only) THE CiTY OF COLUMBIA HEIGHTS DOES NOT DISCRIMINATE ON THE BASIS OF DISABILITY IN EMPLOYMENT OR THE PROVISION OF SERVICES EQUAL OPPORTUNITY EMPLOYER .... c:: (1) E C. o - (1) > (1) c ~ .- c:: ~ E E o o ~ 0) ..c ""'0 -+-' C .8~uc C .-"- (I) >. ogEE~ +J::Joo..o Soc.Q..c c' 0 -+-' (I) U ~ ::J (/) ~w 0) 0)= s......() I 2004 2005 2006 Proposed 2007 PERSONAL SERVICES 279,360 382,703 493,455 465,571 <f n I . Major Changes Personnel 2007: - Elimination of the Point of Sale Inspector Position- ( ) . Wage and Fringe Increases - Adjustment - $26,981 ai t r Total Total F.T.E Total Total Comp Total Total Comp Position Title 2006 2007 Salaries Fringe & Fringe Salaries Fringe & Fringe Com Dev Assistant 1.00 1.00 64,356 16,120 80,476 68,306 17,964 86,270 Secretary 1.00 1.00 38,544 12,545 51,089 41,141 6,424 47,565 Director 1.00 1.00 88, 118 19,613 107,731 93,510 21,767 115,277 Com. Dev. Specialist 1.00 1.00 45,084 13,632 58,716 49,718 15,176 64,894 Planner 1.00 1.00 60,216 15,571 75,787 66,266 17,327 83,593 Secretary II Permits 1.00 1.00 37,873 12,549 50,422 40,661 11 ,634 52,295 Building Official 1.00 1.00 57,912 15,173 73,085 63,350 17,221 80,571 Point of Sale 1.00 0.00 41 ,000 13,865 54,865 0 0 0 Subtotal 8.00 7.00 433,103 119,068 552,171 422,952 107,513 530,465 a1 '"\d" ""C Q) 001'- 00 c..O ON S- O- I'- 0) LO ..... ~ ~ <.0 o o N I'- 0) LO ..... ~ ~ LO 0 0 0 0 I'- N ..... ('f) ~ IIIIIIIIIIIIIIIIIII - ~ LO 0 N 0 N ('f) ..... CO ill! rVI r 2004 2005 2006 Proposed 2007 132,037 116,300 73, 187 122,651 (f c co - (L Q) > -- en c Q) ..c Q) s..... lIII_ a. E 0 () s..... . . CO -c Q) Q) ~ en I co 0 Q) ~ ..., '- Q) U ..c C ....... -- s..... Q) 0 '+- > 0 co 0 ..c 0 ... ......... 0 co I.(') Q) La ..c fF7 ....... ......... co I -0 en 0 a. Q) 1.('):) c 0 -- ("t') .....J . '-::;1 III III Inl , r I, nferen The following training, travel, conference, and membership expenses are proposed for 2007: . State Mandated Training Building Official Training . Conferences & Out of Town Travel Annual Kennedy and Graven Public Law Update (in town) Ehlers Annual Financial Conference (in town) . Local Travel Association of Metropolitan Municipalities League of Minnesota Cities Sensible Land Use Coalition Metro Council Livable Communities Advisory Committee Responding to citizens complaints . Memberships International Code Council Association of Minnesota Building Officials Sensible Land Use Coalition Minnesota Building Permit Technicians Association American Planning Association Economic Development Association of Minnesota Urban Land Institute . Educational Reimbursement $ 1,320 $ 750 $ 750 $ 915 $ 200 $ 100 $ 960 $ 50 $ 610 $ 300 $ 485 $ 2,280 u1 r:: 1III111111111111111 .IIIIIIIIIIIIIII .... "d en ()) 0) C co ..c o o Z . '"'C Q) C C co - c.. .... en c: Q) en co ..c u L.. ::J IIIIIIIIIIIIIIIIIIII c.. ........ c Q) E - c.. -- ::J iIIllIIIIIIIIIIIIII 0- Q) - co ........ -- c.. co u 0 Z . "d Total Budget Compared to Year Budgets Adopted Adopted City Manager Community Development Actual Budget Budget Proposed 2004 2005 2006 2007 Revenue Taxes 197,419 246,331 246,331 317,228 Licenses And Permits 0 0 533,714 564,158 Intergovernmental Revenue 12,889 0 0 0 Charges For Current Services 0 0 0 0 Fines And Forfeits 0 0 0 0 Miscellaneous 4,185 0 35,140 35,825 Sales And Related Charges 0 0 0 0 Allocations 0 0 0 0 Trans and Non Rev Receipts 249,582 293,630 0 0 Total Revenue 464,075 539,961 815,185 917,211 Expenses Personal Services 279,360 383,454 493,455 465,571 Supplies 8,325 13,700 14,597 14,597 Other Services and Charges 132,037 116,300 73,187 122,651 Capital Outlay 0 0 0 0 Contingencies & Transfers 27,423 45,882 233,946 314,392 Total Expenses 447,145 559,336 815,185 917,211 (f CD ...c ~ ..... c: cu e..... ..(1) 1..0) CO" c..~ cum c" cu cu .~ en -0 oc.. c..o 1'-1.. oc.. o N 0== ~ () c c o :J :;:i 0 co ~ c >. CD~ cnU a... "V \0 o o N ~ \0 ~ Q) ..n S Q) > o Z I Proposed 2003 2004 2005 2006 2007 SALARY $1,855,532 $1,769,786 $1,769,749 $1,846,702 $2,020,953 FRINGE $476,252 $450,282 $450,495 $483,399 $542, 142 TOTAL $2,331,784 $2,220,068 $2,290,256 $2,314,281 $2,563,094 +4.60/0 -4.80/0 +30/0 +10/0 +7.80/0 u:f FUND NUMBER 101-42100 2007 Police Proposed Budget SUMMARY OF COST FACTORS FOR THE COMING YEAR Explanation of Personnel 2006 Adopted 2007 Proposed Total Total F.T.E Total Total Comp Total Total Comp Position Title 2006 2007 Salaries Fringe & Fringe Salaries Fringe & Fringe Chief of Police 1.00 1.00 93,288 20,583 113,871 98,982 24,369 123,351 Captain 1.00 1.00 73,748 17,715 91,463 78,212 20,821 99,033 Sergeants 3.00 3.00 211,903 51,772 263,675 230,706 52,597 283,303 Corporal 3.00 3.00 192,917 48,941 241,858 204,712 55,525 260,237 Police Officers 17.00 17.00 996,933 256,211 1,253,144 1,108,545 299,399 1,407,944 Chiefs Secretary 1.00 1.00 39,910 12,318 52,228 42,313 11,874 54,187 Support SeNces SupeNsor 1.00 1.00 48,464 13,526 61 ,990 51 ,392 15,161 66,553 Records Tech 2.00 2.00 72,682 23,621 96,303 79,634 23,024 102,658 Comm SeNce Officer 2.00 2.00 71,986 25,602 97,588 72,291 23,938 96,229 Clerk Typist 1.00 1.00 34,371 11 ,529 45,900 36,426 13,000 49,426 Inv/Liasion/Corp Pay 10,500 1,581 12,081 11 ,340 1,905 13,245 PT Murzyn Hall CSO 6,400 528 6,928 Subtotal 32.00 .32.00 1,846,702 483,399 2,330,101 2,020,953 542,141 2,563,094 Labor Allocation From: 101.42500 (12,281) (3,539) (15,820) (10,578) (2,969) (13,547) I Total 1,834,421 479,860 2,314,281 2,010,375 539,172 2,549,5471 u1 r I 41 Contracts are settled though the end of 2007. - Personnel costs are up approximately 7.80/0 in 2007 due to pay increases in 2006 and 2007 and step increases set by Union Contract. There is also a large increase in PERA retirement contributions for 2007. 41 Li nes that have increased: - 1010 Regular Employees +$123,771 - 1011 Part Time Employees +$6,400 - 1020 Overtime +$2,347 - 1031 Holiday Pay +$5,503 - 1041 Court Pay +$3,825 - 1043 Training Pay +$2,625 - 1045 Longevity +$1,972 - 1210 PERA Contribution +$40,810 - 1220 FICA +$4,192 - 1300 Insurance +$530 - 1510 Workers Comp Ins. +$5,218 41 Lines that have decreased: - No lines have decreased a:f v -0 L.() CD f'... ("f) CJ) a ~ ~ 0 ... 0 c... a f'... a 0 N co + s.... tF7 CL L.() ~ CD ("f) 0 a ~ L.() ... . a f'... a N co + tF7 L.() a a N a a a ... f'... co tF7 ~ o f'... . N + ~ o o N a a CD ... ~ co tF7 ~ o a !II- a ~ - ("f) a 0 a CD CD ... . a ~ a N co + tF7 Ii . Lines that have increased: - 2000 Office Supplies +$605 - 2070 Training and Instructional Supplies +$2,370 - 2175 Food Supplies +$400 - 2172 Uniforms +$172 - 2282 Gas, Oil and Lubricants $5,800 (Fleet Vehicles) . Lines that have decreased: - 2010 Minor Equipment -$4,825 - 2011 Computer Equipment -$1,695 - 2020 Computer Supplies -$305 - 2030 Printing and Printed Forms -$656 - 2160 Maintenance and Construction Materials -$52 - 2170 Program Supplies -$98 - 2171 General Supplies -$76 - 2280 Vehicle Repair and Parts -$2,250 u:f II!I I Proposed 2003 2004 2005 2006 2007 $228,063 $221 ,144 $219,401 $215,031 $219,131 +11.30/0 -30/0 -0.80/0 -20/0 +1.80/0 <f r IlIi I r . Lines that have increased: - 4080 Vehicle Repairs +$1,675 - 4033 Misc. Charges +$3,535 - 4330 Subscriptions & Memberships +$150 . Lines that have decreased: - 3210 Telephone and Telegraph -$1,350 - 3430 Advertising Other -$10 - 3500 Legal Notice Publishing -$100 u1 II1II II1II Inl , I, III 1 The following training, travel, conference, and membership expenses are proposed for 2007: State Mandated Training $12,000 - This includes use of force and firearms training, 20 hours per officer each year - First Responder 16 hours every two years - Pursuit Driving training 16 hours every three years . Conferences & Out of Town Travel Expense 2004 - State Conference Chief, Captain, Sergeants and Corporals - Explorers at Breezy Point . Local Travel 2005 2006 (Through Sept) $462 $1,050 $371 $800 $104.34 $1,320 Includes lunch and parking reimbursement for officers attending training in the metro area. $991.51 $651.93 $852.27 u:f /ill! I 11II I , I, IlII I The following training, travel, conference, and membership expenses are proposed for 2007: . Memberships & Subscriptions International Association of Chiefs of Police $100 Chief MN Chiefs of Police Association $225 Chief/Captain National Night Out Association $25 Corp. Bonesteel Anoka Co. Chiefs Association $20 Chief/Captain Tri City Law Enforcement Association $60 Inv. Markham National Animal Control Association $35 CSO Boham Police Law Enforcement Assistants Association $20 Mary/Cheray Minnesota Crime Prevention Association $40 CSO Boham Membership Total $525 League of Minnesota Cities Directory $36 Anoka Co. ACCAP Resource Guide $14 Annual/Update Traffic & Criminal Code Books $943 Hudson Street Maps $34 Justice & Planning Mgmt (Grant Update) $175 National Law Enforcement Directory $124 Subscriptions Total $1316 Grand Total $1841 <f I, faren IIIlI IIIlI Inl r , The following training, travel, conference, and membership expenses are proposed for 2007: . Educational Reimbursement This money is used to reimburse officers and civilian personnel who are preparing themselves for promotion by obtaining college degrees 2005 2006 $786.78 $1,000 2007 $1 ,000 u:1 ital III UI The following Capital Equipment purchases are proposed for 2007: . Two full-size marked squads . Miscellaneous Equipment for Squads - Two Prisoner Safety Divider - Two Squad Light Bar TOTAL $50,000 $2,130 .$2,130 $54,260 This is the same as 2006. ~ l1li In l1li In r This area of the budget covers transfers, contingencies, and other items not included in the previous categories. . Transfers - Transfer from Liquor . Cover cost of Liquor Detail - Monday - Saturday 8: 15 - 10: 15 pm . Cover Cost of DARE Program . Capital Equipment - Transferred from Refuse/Recycling - . Covers CSO cost Refuse Enforcement . Covers cost of CSO'S for Recycling Program Total $33,267 $9,000 $7,780 .$14,228 $64,275 (f t III I liII I . Recommended Add $45,000 - Staff is requesting and recommending an add or increase to the police budget in the amount of $45,000 to continue the Grid "8" Detail year round. It is projected that there will be under expending in the 2006 Police Department Budget to at least partially cover this expense. (f Total Budget Compared r Year Budgets Adopted Department City Manager Police Actual Actual Budget Proposed Proposed 2004 2005 2006 2007 2007 Revenue Taxes 1,322,933 1,356,415 1,866,132 1,921,259 1,921,259 Licenses And Permits 45,090 46,950 46,400 47,500 47,500 Intergovernmental Revenue 974,803 624,191 553,979 608,107 608,107 Charges For Current Services 186,773 210,094 166,158 166,158 166,158 Fines And Forfeits 82,677 80,284 70,000 70,000 70,000 Miscellaneous 74,882 77,324 75,692 47,948 47,948 Sales And Related Charges 0 0 0 0 0 Allocations 0 0 0 0 0 Trans and Non Rev Receipts 26,370 109,875 69,664 72,054 72,054 Total Revenue 2,713,528 2,505,133 2,848,025 2,933,026 2,933,026 Expenses Personnel Services 2,123,748 2,316,265 2,365,851 2,563,094 2,563,094 Supplies 75,296 86,530 91 , 185 91,185 91 ,185 Other Services and Charges 220,992 199,769 232,126 236,226 236,226 Capital Outlay 41,190 80,333 54,260 54,260 54,260 Contingencies & Transfers 30 20 89,398 0 0 Total Expenses 2,461,256 2,682,917 2,832,820 2,944,765 2,944,765 cQ 2005 Population # of Sworn Arrests # of Part # of Part 010 of Crime Officers 1 Crimes 2 Crimes Cleared Columbia Heights 18,579 24 1.24/1000 1,299 1,200 1,788 43% CH (Hilltop) 792 (Authorized) 173 125 188 51% HT 19,371 23 1.21/1,000 1,472 1,325 1,976 (actual) Anoka 18,005 27 1.5/1,000 649 844 908 32% Crystal 22,441 27 1.23/1,000 876 913 878 50% Hastings 19,867 25 1.25/1,000 624 569 790 46% Hopkins 17,268 26 1.52/1,000 717 664 932 43% New Brighton 21,930 28 1.32/1,000 601 673 702 36% New Hope 20,484 27 1.35/1,000 890 776 1,174 40% South St Paul 19,861 25 1.25/1,000 770 784 1,210 31% West St Paul 19,628 25 1.27/1,000 978 1,315 1,217 36% Brooklyn Center 28,595 42 1.47/1,000 1,380 2,109 2,063 41% Richfield 34,359 43 1.26/1,000 1,388 1,585 1,829 44% White Bear lake 24,588 26 1.05/1,000 808 902 867 38% Shoreview 27,328 Contract with 213 401 375 40% ~ Ramsey County Grants Listing - Royal Blue grants are open - Grant # Approved #1 S-275 COMPLETE State, Office of Drug Policy #2F-272 #94-DM-CX-0 1 08 DOJ #3F-273 95-CF-WX-3204 COPS FAST (Applied for extension to Nov. 30, 1998) #4S-274 COPS/Overtime #5F-276-42100 96-LBVX-2491 Block Grant #6F-277 COPSMORE '96 97-CM-WX-0474 Supplement--Extended to 5/31/99 #7F /COPSMORE '96 Fridley authored #9F COMPLETE #10F COMPLETE Items Denied Amount Intent of Grant $40,000 '92-'93 $40,000 '93-'94 New officer hires (2) Nelson, Fischer $135,623 COlVIPLETE New officer hires (2) Klostennan, Bonesteel $75,0003 years New officer hire .Taret Stoffregen 8-28-95 to 2-2-96 Joe Sturdevant 5-6-96 COMPLETE 01-01-99 $30,000 COMPLETE Overtime and equipment 7-1-96 to 6-30-97 $20,349 10/1/96-12/31/96 COMPLETE Equipment: (2) video cameras & (2) laptop computers $43,238 COMPLETE $26,145 Evidence Techn. $26,145 Equip.: lap top computers $17,093 Civilian personnel (2 time CSO) $88,350 COMPLETE Photo imaging system $ 1 ,000 DARE Grant $2,000 DARE Grant ~ Grants Listing - Royal Blue grants are open - Grant # Approved #11F-276-42110 Approved 10-01-97 97-LBVX-2058 (1998 LLEBG grant) #12S-278 Approved 8-21-97 #14S-274 Approved 12-30-97 #15F 98-LBVX-2058 (1999 LLEBG grant) 10/1/98-9/30-2000 276-42111 #16F Approved 9/1/98-8/31/99 4498-CM-WX-1653 (277-42120 #17F Approved 11/1/98-11/1/99 #274 State ofMN Comm. Oriented Policing #18S Juvenile Account. Incentive Block Gr. 90268 Extended to June 1999 278-42100 #19S Juvenile Account. Incentive Block Grant 90478 Fund 278-42101 #20 Year 2000 Overtime Fund 274-42100-1020 21F SBP99 School Based Partnership Fund 279-42100-1010 #1999SBWX0026 Items Denied Amount Intent of Grant $21,986 COMPLETE 10-1-97 to 9-30-99 Equipment. Fund 271 was transferred to Fund 276 $12,155 COMPLETE 12-21-98 Juv. Justice Funds, work crew supervisor supervisor supplies, graffiti cleanup cleanup $30,000 COMPLETE 12-98 Overtime 11-1-97 to 10-31-98 $24,605 COMPLETE 1999 Equipment Block Grant $15,145 COMPLETE Equipment (Award $411,358 w/match $3,787) Requested extension to 6-30-01 $20,000 COMPLETE Overtime Grant $10,454 COMPLETE Project Safety Net, Graffiti cleanup program COMPLETE Project Safety Net, graffiti cleanup supv 1/1/99-12/31/99 $10,000 COMPLETE Awarded 11-4-99 $92,342 COMPLETE 8-02 Awarded 8-1-99 <f Grants Listing - Royal Blue grants are open - Grant # Approved #22F 99002448 Vest Grant #24 DOJ, LLEBG Block Grant 2000LB-BX-0190 Fund #276-42112 #25 Juv. Accountability Incentive Grant 90637 Fund #278-42102 #26 McKnight Foundation Grant 883-42100 #27 FY 2000 L.E. Block Grant 2000-LB-BX-0594 Fund # 276-42113 #28 Juv. Accountability Incentive Grant 90691 FY 2000-2001 Fund #278-42103 #29 FY2001 LE Block Grant 2001-02 2001-LB-BX-2643 Fund #276-42114 Items Denied Amount Intent of Grant $2,975 ($1,487.50 award) Vest purchase reimbursement ongoing $23,945+$2,661 match COMPLETE Block Grant, equipment 10/1/99-9/30/2001 $10,444 COMPLETE Juvenile Programs 1/1/2000-12/31/2000 $16,000 COMPLETE $21,578+$2,398 match COMPLETE A warded 9-6-00 10-01-99 to 9-30-01 $9,874 w/match $1,097 COMPLETE A warded +$2,000 Conference $22,698 w/match $2,522 COMPLETE Awarded 7-20-01 10-1-2000 to 9-30-2002 (f Grants Listing - Royal Blue grants are open - Grant # Approved #30 Juv. Accountability Incentive Block Grant 90945 FY 2002-2003 4-01-2002 to 9-30-2003 Extended to 9-30-2004 Fund 278-42104 #31 FY 2002 LE Block Grant 2002-03 2002-LB-BX-1304 Fund #276-42115 #32 Juv. Accountability Incentive Block Grant 91011 FY 2003-2004 Fund #278-42105 #33 .luv. Accountability Incentive Block Grant 2004-00114 FY 2004-2005 Fund 278-42106 #34 2004 Citizens Corp Grant 2000-9675 7/1/04 to 11/30/05 or until completed Fund 272-42130 20#35 FY2003 L.E. Block Grant Fund 276-42116 #36 2004 L.E. Terrorism Prevention Grant 60 portable radios & 911 computerized reverse dialing system Items Denied Amount $9,640 w/match $1,071 Balance $767.67 COMPLETE Intent of Grant A warded $17,241+$1,916 match COMPLETE Awarded 7-10-02 10-01-2001 to 9-30-2003 $8,035 w/match $893 COMPLETE Awarded 12-02 4-01-2003 to 3-31-2004 $5,898 w/match $655 COMPLETE Awarded 4-1-004 $13,654 COMPLETE Awarded 7/2004 Train citizens for emergency response $12,166 + $1,402 match COMPLETE Awarded 9-4-0303-LB-BX-2246 $186,600 COMPLETE A warded a1 Grants Listing - Royal Blue grants are open - #37 Joint Powers Agreement BCA IBIS remote fingerprint units #38 2006CKWX611 U.S. DOJ COPS 2006 Secure Our Schools Grant Items Denied $0.00 Awarded 3-16-06 $51,598 Awarded September 18,2006 Match of $51,598 to be paid by School District ~ v ~ o ~ ~ ~ ~ C]) ..c ..p...I ...... t: (1) E L: co c.. (1) C (1) (.) t: co t: -.... u.. 0== +-' U C C o ::J ........ 0 roU ..p...I c ~ C])~ C/)U C]) '- 0... 'd I 2003 2004 2005 2006* Proposed 2007* PERSONAL $552,146 $505,596 $526,281 $560,080 $566,300 SERVICES (8.4 )0/0 4.10/0 6.40/0 1 . 1 0/0 *Includes Line item #8100 Contingencies for 2006 and 2007 <f FUND NUMBER 101.41510 2007 FINANCE BUDGET SUMMARY OF COST FACTORS FOR THE COMING YEAR Explanation of Personnel 2006 Adopted 2007 Proposed Total Total F.T.E Total Total Comp Total Total Comp Position Title 2006 2007 Salaries Fringe & Fringe Salaries Fringe & Fringe Finance Director 1.00 1.00 95,762 19,930 115,692 101,610 22,015 123,625 Asst Finance Director 1.00 1.00 65,322 15,955 81,277 70,451 18,021 88,472 Acctg Cordinator 1.00 1.00 45,374 13,116 58,490 47,042 14,561 61,603 Payroll Clerk 1.00 1.00 40,118 12,369 52,487 44,516 14,194 58,710 Acctg Clerk I:Utility 1.00 1.00 35,814 11,757 47,571 37,977 11 ,267 49,244 Acctg Clerk II:Utility 1.00 1.00 37,395 11,982 49,377 39,641 6,229 45,870 Acctg Clerk II: Finance 0.72 0.72 26,197 3,728 29,925 25,318 3,672 28,990 Receptionist 1.00 1.00 35,336 11,688 47,024 37,457 11,191 48,648 Secretary II 1.00 1.00 37,395 11,982 49,377 39,641 11,509 51,150 Meter Reader 0.25 0.25 6,547 963 7,510 6,947 1,041 7,988 lotal 8.97 8.97 425,260 113,470 538,730 450,600 113,700 564,300 cr1 n nnel . No Major Changes in Personnel in 2007: - Recommend maintaining current staffing level . Lines that have increased: - Increases in most personnel budget line items . Lines that have decreased: - Insurance line item decreased $4,480 - Budgeted in prior years at maximum employer contribution possible under contracts - Budgeted for 2007 at employer contribution required for projected employee participation levels - $2,000 put into Contingency (f Ii 2003 2004 2005 2006 Proposed 2007 $16,022 $27,472 $18,930 $26,400 $24,800 71 0/0 (31 )0/0 390/0 (6)0/0 Q uooli . Lines that have increased: - Computer Equipment has a net increase of $1,500 which includes $3,000 budgeted for software to fulfill a new reporting mandate, offset by reductions in other computer items . Lines that have decreased: - Printing & Printed Forms for Utility Billing are budgeted at $1 ,200 less for 2007 due to more forms being printed in-house a1 l1li I r 2003 2004 2005 2006 Proposed 2007 $57,607 $79,374 $62,912 $79,254 $83,200 380/0 (21 0/0) 260/0 50/0 ~ r ther r . Lines that have increased: - Expert & Professional Services - Postage - Credit Card Fees . Lines that have decreased: - Repair and Maintenance IIIIB rVI $ 2,300 $ 3,900 $ 2,000 $(3,000) (f The following training, travel, conference, and membership expenses are proposed for 2007: . State-Mandated Training - Public Finance Officer Course - 40 hours annual accounting education for CPA certification . Other training - Other financial seminars - Software training · Out of Town Travel & Lodging - Government Finance Officers Assn State Conference - Government Finance Officers Assn National Conference feren I, , r . Educational Reimbursement - Staff development for internal succession $ 600 $1 ,200 $ 400 $ 800 $ 400 $1,900 $2,000 cCf 11II 111II Inl , r r ) . Local Travel - Mileage reimbursements, primarily for meter reading . Memberships - MN Society of CPAs 1 @ - MN Municipal Clerks and Finance Officers Assn 1 @ - MN Government Finance Officers Assn 2@ - National Government Finance Officers Assn 2@ $ 300 $ 175 $ 50 $ 50 $ 175 a1 th 11II I ina U . Transfers to General Fund For labor for billing, meter reading, and administration - From Water Fund $76,813 - From Sewer Fund $76,812 . Transfers to Information Systems Fund For I/S services and equipment replacement - From Water Fund - From Sewer Fund $35,000 $35,000 . Contingency - For new insurance budgeting method $ 2,000 a1 (]) s.... co en (]) en 0 0 CO 0 0 ..c 0 0 t) "" "" L{) L{) s.... :::J Y7 Y7 ,.., e.. ......., c: ......., e e (]) (]) E E e.. e.. .- :::J .- IIIIIIIIIIIIIIIIIII :::J 0- 0- (]) W 0> e s.... s.... CO .- Q) Q) ......., - +-' S .- . . -0 CO - e.. l"- e S Q) co 0 co en ,.., () 0 ..c C> !lll1IIIIIIIIIIIIII N C> I C c 0> s.... - - e ~ co - - .- .- .- E co co ~ -c >. >. 0 (]) (]) +-' +-' .- .- - -0 - - - en .- ~ +-' +-' 0 co => => e.. s.... (]) 0> ..c 0 e.. s.... l- e.. :J "\:1 Total Budget Compared to Prior Year Budgets Summary by Class Finance 1 0 1 -41 51 0 Revenue Taxes Licenses And Perm its Intergovernm ental Revenue Charges For Current Services Fines And Forfeits Miscellaneous Sales And Related Charges Allocations Trans and Non Rev Receipts Total Revenue Expenses Personal Services Supplies Other Services and Charges Capital Outlay Contingencies & Transfers Total Expenses Sum m a ry Revenue Expense Change to Fund Balance Adopted o epartm ent City Manager Actual Actual Budget Proposed Proposed 2004 2005 2006 2007 2007 162,473 179,400 272,311 347,758 347,758 1,009 819 1,100 1,100 1,100 77,223 54,318 43,379 67,197 67,197 0 0 0 0 0 0 0 0 0 0 6,413 3,665 3,531 4,454 4,454 (19) 9 0 0 0 0 0 0 0 0 351,832 311,648 309,244 215,491 215,491 598,931 549,867 629,565 636,000 636,000 505,596 526,281 538,729 564,300 564,300 16,334 15,613 17,200 16,600 16,600 50,144 36,572 52,279 53,100 53,100 0 0 0 0 0 0 0 21,351 2,000 2,000 5T2,074 . 578,466 629,559 636,000 636,000 598,931 549,867 629,565 636,000 636,000 572,074 578,466 629,559 636,000 636,000 26,857 (28,599) 6 0 0 (f Total Budget Compared to Prior Year Budgets Summary by Class Water Adm inistration 601-49440 Revenue Taxes Licenses And Perm its Intergovernm ental Revenue Charges For Current Services Fines And Forfeits Miscellaneous Sales And Related Charges Allocations Trans and Non Rev Receipts Total Revenue Expenses Personal Services Supplies Other Services and Charges Capital Outlay Contingencies & Transfers Total Expenses Summary Revenue Expense Change to Fund Balance Adopted Department City Manager Actual Actual Budget Proposed Proposed 2004 2005 2006 2007 2007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 817 816 2,882 2,984 2,984 134,411 117,062 138,792 128,811 128,811 0 0 0 0 0 7,431 2,279 0 0 0 142,659 120,157 141,674 131,795 131,795 0 0 0 0 0 5,510 1,859 4,600 4,100 4,100 14,896 12,919 14,550 14,300 14,300 0 0 10,000 5,000 5,000 123,022 112,855 112,830 111,813 111,813 143,428 127,633 141,980 135,213 135,213 142,659 120,157 141,674 131,795 131,795 143,428 127,633 141,980 135,213 135,213 (T69)-- (7,476) (306r---(3,~n8l----(3-;-4r8l a:1 Total Budget Compared to rior Year Budgets Summary by Class Sewer Adm inistration 602-49490 Revenue Taxes Licenses And Perm its Intergovernm ental Revenue Charges For Current Services Fines And Forfeits Miscellaneous Sales And Related Charges Allocations Trans and Non Rev Receipts Total Revenue Expenses Personal Services Supplies Other Services and Charges Capital Outlay Contingencies & Transfers Total Expenses Summary Revenue Expense Change to Fund Balance Adopted Department City Manager Actual Actual Budget Proposed Proposed 2004 2005 2006 2007 2007 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5,994 3,239 3,969 5,616 5,616 104,144 97,106 113,828 111,779 111 ,779 0 0 0 0 0 20,811 12,220 0 0 0 130,949 112,565 117,797 117,395 117 ,395 0 0 0 0 0 5,627 1 ,458 4,600 4,100 4,100 11,695 9,874 10,925 14,300 14,300 0 0 10,000 5,000 5,000 123,022 112,855 112,830 111,812 111,812 140,344 124,187 138,355- 135,212 135,212 130,949 140,344 112,565 124,187 117,797 138,355 117,395 135,212 117,395 135,212 (9,395) (11,622) (20,558) (17,817) (17,817) a1 lIII I tt The total change proposed for the 2007 budget: - Finance - Utility Billing increase $ 6,441 (decrease) .$(9,910) - Total (decrease) $(3,469) a1 \7 ;:s ~ ~ ~ ~ ~ e t--- o o N .. Q) C) -C ::J III Q.) ...c '+-' 0== '+-' U C C o ::J -....... 0 roO '+-' c >. Q):!:: 000 Q.) L.. .. c: Q) E ~ ca c. Q) c en .... v I 2003 2004 2005 2006 Proposed 2007 SALARY $109,557 $111,178 $126,880 $126,904 $135,656 FRINGE $29,800 $30,151 $32,489 $31,343 $35,135 TOTAL $139,357 $141,329 $159,369 $158,247 $170,762 +1.40/0 +12.80/0 -0.70/0 +7.90/0 .... ~ FUND NUMBER 720- 49980,49981 2007 FINANCE BUDGET SUMMARY OF COST FACTORS FOR THE COMING YEAR Explanation of Personnel 2006 Adopted 2007 Proposed Total Total F.T.E Total Total Comp Total Total Comp Position Title 2006 2007 Salaries F ri ng e & Fringe Salaries Fringe & Fringe IS Director 1.00 1.00 68,580 16,401 84,981 72,794 18,273 91,067 IS Technician 1.00 1.00 46,824 13,305 60,129 49,622 14,913 64,535 P.T.lmaging 0.50 0.50 11,500 1,637 13,137 13,240 1,920 15,160 Total 2.50 2.50 126,904 31,343 158,247 135,656 35,106 170,762 a1 III J I . Major Changes Personnel 2007: - No changes in IS personnel since 2006 . Lines that have increased: - 1010 Regular Employees - 1210 PERA contribution - 1220 FICA contribution - 1300 Insurance - 1510 Workers comp . Lines that have decreased: $8,752 $857 $670 $2, 160 $76 - none a1 Ii 2003 2004 2005 2006 Proposed 2007 $33,350 $70,655 $15,850 $19,386 $13,170 +119.90/0 -77.60/0 +22.30/0 -32.1 0/0 (f uopli . Lines that have increased: - none . Lines that have decreased: - 2000 Office supplies - 2010 Minor equipment - 2011 Computer equipment - 2020 Computer supplies $106 $213 $5,684 $213 a1 r Ell rVI n har 2003 2004 2005 2006 Proposed 2007 $24,367 $31 ,905 $51 ,427 $56,582 $60,628 +30.90/0 +61.20/0 +10.00/0 + 7.20/0 a1 ther III! I s . Lines that have increased: - 3250 Other Communications - 4000 Repair and Maintenance Services - 4100 Rents and Leases $4,260 $2 $200 . Lines that have decreased: - 3050 Expert and Professional Services - 4330 Subscription, Membership $310 $106 (f II1II ral , r I, C fer The following training, travel, conference, and membership expenses are proposed for 2006: . State Mandated Training - None . Conferences & Out of Town Travel - None . Local Travel $225 - Budgeted for local travel to seminars and IT professional meetings . Memberships - None . Educational Reimbursement - None u1 r lIIl I lIIl I . This area of the budget covers transfers, contingencies, and other items not included in the previous categories. . Transfers - From Water fund - From Sewer fund - From Gen Gov fund - From Cable TV fund - From Refuse fund - From Liquor fund - From Garage fund TOTAL: . Contingencies - $8,000 was budgeted in contingencies to cover unknown and unbudgeted expenses. $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $25,000 $235,000 (f CD LO V s.... I'- CO (j) "'" en LO CD T'"'"' en Y7 CO ..c t) s.... :J 0.. ........ C en CD CD E -c 0.. CO -- s.... 11- :J 0) C- o.. W :J CO ~ s.... ........ 0 - -- . . 0..<0 Z CO 0 U 0 CD N C 0) s.... -c c S -- c ~ -c CO 0 s.... - CD CD - S en 2: 0 CD 0.. CD ..c 0 CJ) l- s.... 0.. . I III I t . 150+ computer users . 8 locations: City Hall, Public Works, Recreation, ibrary, subsidized high-rise building, 3 municipal liquor stores . Remote access to the network . 70+ different programs . 130+ desktop and laptop computers . 14 network servers . 44 printers . 180 phones, 190 voicemail boxes . Web-site (f uaget Compared to or Year Budgets Adopted Department City Manager IS Actual Actual Budget Proposed Proposed 2004 2005 2006 2007 2007 Revenue Taxes 0 0 0 0 0 Licenses And Permits 0 0 0 0 0 Intergm..emmental Revenue 0 0 0 0 0 Charges For Current Serv;ces 0 0 0 0 0 Fines And Forfeits 0 0 0 0 0 Miscellaneous 1,029 0 1,100 0 0 Sales And Related Charges 0 0 0 0 0 Allocations 0 0 0 0 0 Trans and Non Rev Receipts 299,143 235,000 235,000 235,000 235,000 Total Revenue 300,172 235,007 236,100 235,000 235,000 Expenses Personal Services 141,330 159,369 158,247 170,762 170,762 Supplies 70,655 15,850 19,386 13,170 13,170 Other Services and Charges 31,905 51,427 56,582 60,628 60,628 Capital Outlay 0 37,925 26,625 15,975 15,975 Contingencies & Transfers 0 5,000 8,000 8,000 8,000 Total Expenses 243,890 269,571 268,840 268,535 268,535 a1 Q) ... (1) C) -c :J In "- o o N +-i' 0== +-i' 0 C C o :J -- 0 roU +-i' >. Q):t= cnU Q) s...... . ... c.. (1) C ... o :J e- II ... ..J I 2003 2004 2005 2006 Proposed 2007 PERSONNEL $760,614 $812,600 $831,633 $824,284 $869,163 SERVICES STORE 1 $339,958 $334,392 $347,461 $354,558 $379,697 STORE 2 $235,562 $263,809 $272,175 $277,849 $295,602 STORE 3 $185,094 $214,399 $211,997 $191,877 $193,864 Ilocation Explanation of Personnel 2006 Adopted 2007 Proposed Total Total F.T.E Total Total Camp Total Total Camp Pas ition Title 2006 2007 Salaries Fringe & Fringe Salaries Fringe & Fringe Liquor Manager 1.00 1.00 82,272 19,568 101,840 83,734 21,149 104,883 Asst Liquor Mgr 7.00 7.00 306,743 94,7 49 401 ,492 322,827 105,807 428,634 P.T. Clerk 0.50 0.50 23,290 3,654 26,944 24,713 3,947 28,660 Cashiers & Stockers 14.50 16.50 251 ,493 39,458 290,951 264,579 42,406 306,985 Subtotal 23.001 25.00 663,7981 ...157,4291....../821,227 695,8531 173,3091 869,162 labor Allocation To: 609-49791 (10.50) (11.00) (289,203) (65,355) (354,558) (306,547) (73,150) (379,697) 609-49792 (5.50) (9.00) (222,897) (54,953) (277,850) (237,453) (58,148) (295,601 ) 609-49793 (7.00 ) (5.00) (152,049) (39,828) (191,877) (151,853) (42,011) (193,864 ) nnel . Major Changes Personnel 2007: - Lines that have increased: . Labor for Liquor Store Managers budget has increased due to cost of living increases and one manager going thru the step increases - Lines that have decreased: . No lines have decreased Ii 2003 2004 2005 2006 Proposed 2007 $20,864 $22,870 $23,370 $23,320 $29,700 o ~ Q) :::J -0 >. - ~ ..c 0'> .- - C/) -0 Q) C/) cu .. ~ "'C (.) ()) c Cf) .- CO Q) 0.. ~ ~ :::J (.) ..c 0'> C C __ C/)-- Q) 0 ())::.=O'> > 0.. C/) CO 0..-0 ...c :::J 0 ........, C/) 0 co-O'> ...c ~ '+- ........, Q) 0 Cf) c~ ()) Q) C/) c<.98 :::J A . II1II I 2003 2004 2005 2006 Proposed 2007 $432,472 $427,057 $460,477 $492,578 $498,144 t 11II I . Lines that have increased: - Repair and Maintenance Services increased due to rising costs of external labor services - We project CAM will increase at the two stores that are not city-owned due to labor and other costs incurred . Lines that have decreased: - No significant decreases III III Inl , r I, The following training, travel, conference, and membership expenses are proposed for 2007: . Liquor Training y All employees must attend the beverage alcohol training administrated by MMBA in order to receive insurance discount · Conferences & Out of Town Travel y MMBA Conference held in May 2007 . Memberships y MMBA - Minnesota Municipal Beverage Association Member 11III 11III Inanel This area of the budget covers transfers, contingencies, and other items not included in the previous categories. . Vandalism ~ Each store has budgeted $1,000 to cover insurance deductible in the event of vandalism or other damage/loss c -- Q) C/) co ..c u '- :J c.. ........ c Q) ... E c.. -- :J 0- W 11II- co ........ -- c.. co () . ........ Q) - 0 0> C "'"0 Q) :J 11I_ ...c ...c - C/) - ... -- '- s CO Q) Q) >. '- Q) C/) ..c -- ~:5 . Total Budget Compared Year Budoets ... - -SudgefZOlYf - -- Summary by Class Adopted Department City Manager Adopted Liquor Actual Actual Budget Proposed Proposed Budget 2004 2005 2006 2007 2007 2007 Revenue Taxes 0 0 0 0 0 0 Licenses And Permits 0 0 0 0 0 0 Intergovernmental Revenue 0 0 0 0 0 0 Charges For Current Services 0 0 0 0 0 0 Fines And Forfeits 0 0 0 0 0 0 Miscellaneous 98,155 53,811 80,000 78,000 78,000 0 Sales And Related Charges 6,946,060 6,687,635 7,093,050 7,510,100 7,510,100 0 Allocations 0 0 0 0 0 0 Trans and Non Rev Receipts 533 347 0 0 0 0 Total Revenue 7,044,748 6,741,793 7,173,050 7,588,100 7,588,100 0 Expenses Personal Services 812,600 839,133 824,287 869,163 869,163 0 Supplies! Cost of Goods Sold 5,335,608 5,237,672 5,484,820 5,855,000 5,855,000 0 Other Services and Charges 427,057 437,055 492,578 498,144 498,144 0 Capital Outlay 0 0 0 0 0 0 Contingencies & Transfers 0 0 3,000 3,000 3,000 0 Total Expenses 6,575,265 6,513,860 6,804,685 7,225,307 7,225,307 0 IQUOR REVENUE Store #1 Store #2 Store #3 609 609 609 Revenue Interest on Investments 35,051 28,787 14,162 Discounts-Store (7,500) (4,000) 0 Sales-Liquor 1,164,000 870,000 500,000 Sales-Beer 1,600,000 1,350,100 720,000 Sales-Wine 360,000 396,000 60,000 Sales-Miscellaneous Taxable 34,100 31 ,500 17,000 Sales-Non Taxable 28,000 29,500 15,000 Sales-Cigarettes 80,000 45,000 47,500 Sales-Lottery 78,000 56,000 46,900 Cash Over/Short (3,500) (2,500) (1,000) Total Revenue 3,368,151 2,800,387 1,419,562 Cost of Goods Sold 2,590,450 2,173,800 1,061,050 Net Operating Income 777,701 626,587 358,512 Expenses Personal Services 379,697 295,602 193,864 Supplies 16,150 7,900 5,650 Other Services and Charges 259,541 188,301 50,302 Capital Outlay 0 0 0 Contingencies & Transfers 1,000 1,000 1,000 Total Expenses 656,388 492,803 250,816 Summary Total Revenue 3,368,151 2,800,387 1,419,562 Total Expenses 3,246,838 2,666,603 1,311,866 Net Income 121,313 133,784 107,696