Loading...
HomeMy WebLinkAbout4.E. Finance N. 6. CITY OF SHAKOPEE 2012 GENERAL FUND BUDGET DIVISION: FINANCE MISSION STATEMENT: Provide accurate and current financial and statistical data to internal departments and the City Council in a timely manner. Manage the City's financial assets effectively and efficiently. ACTIVITY: The major activities of the Finance Department encompass, accounts payable, cash management, accounts receivable, financial reports, special assessments, annual financial report, budget, insurance and many other of lesser importance. GOALS: 1. Provide accurate and timely information to management. 2. Complete the preparation of the City's budget and CAFR on time. 3. Provide quality overall financial services. MEASUREMENT OF GOALS: Cost per capita of Finance Dept. expenditures: (without lodging tax) Actual Actual Budgeted Requested 2009 2010 2011 2012 Expenditures $601,970 $612,694 $642,600 $675,696 Population 34,691 37,076 37,223 37,370 Expenditure /Capita $17.35 $16.53 $17.26 $18.08 Number of checks issued 3,741 3,800 3,800 3,800 Lodging tax not included in performance measures. Staff 2009 2010 2011 2012 Finance Director 1 1 1 1 Senior Accounting Clerk 1 1 .8 1 Accounting Clerk 1 1 1 1 OBJECT DESCRIPTION: Description of lines items: Professional Services: Auditing services $39,300, County TNT notices $3,100, investment safe keeping fees $5,500 and cash manager fees $60,000 both offset by revenue, misc. services as needed $2,000, assessing contract with the county $178,000 and county special assessment fees $2,000, OPEB update $5,000. Software: Financial $46,385, including implementation of Insight Software package, IT charges $4,730. R5509BUD SHOO5P1V CITY OF SHAKOPEE 7/22/2011 11:07:28 By Co, Div (pb), Object (1 Yr Bdgt) - Portrait Budget Report Page - 1 Fiscal Period: 6 / 11 Level Of Rollup 7 2009 2010 6/30/2011 2011 2012 Actual Actual YTD Final Proposed Object Code / Description Amount Amount Actual Budget Budget 01000 GENERAL FUND 15 FINANCE 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 206,875 197,444 146,930 201,040 215,570 6005 OVERTIME -FT 36 1,500 1,500 6002 WAGES 206,911 197,444 146,930 202,540 217,070 6100 BENEFITS 6122 PERA 13,962 13,838 6,678 14,680 15,740 6124 RCA 14,268 13,652 6,315 15,500 16,620 6135 HEALTH 28,590 21,027 10,131 24,200 27,350 6139 POST EMPLOYMENT HEALTH PLAN 900 901 366 900 900 6140 LIFE /LTD 892 664 234 1,000 1,000 6145 DENTAL 1,255 1,203 468 1,440 1,440 6170 WORKERS COMPENSATION 1,467 1,069 514 1,440 1,450 6180 COMPENSATED ABSENCES 3,594 2,010 6,000 6,000 6185 OPEB 2,800 6100 BENEFITS 67,730 54,364 24,706 65,160 70,500 6001 WAGES & BENEFITS 274,641 251,808 171,636 267,700 287,570 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 528 5,750 6210 OFFICE SUPPLIES 1,187 588 195 3,000 2,000 6201 SUPPLIES & SERVICES 1,715 6,339 195 3,000 2,000 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 501 112 396 600 800 6316 EQUIPMENT MAINTENANCE 600 500 6320 LODGING TAX 160,891 182,169 64,437 152,000 180,000 6327 OTHER PROF SERVICES 261,687 285,975 238,273 299,660 310,000 6300 PROFESSIONAL SERVICES 423,078 468,255 303,106 452,860 491,300 6330 COMMUNICATIONS 6332 POSTAGE 1,218 1,760 844 2,060 2,000 6334 TELEPHONE 264 189 65 400 400 6336 PRINTING /PUBLISHING 1,923 752 659 1,000 2,000 6330 COMMUNICATIONS 3,405 2,700 1,568 3,460 4,400 6350 INSURANCE 6352 LIABILITY 6,243 6,942 7,090 5,327 6356 AUTO 9 9 10 9 6350 INSURANCE 6,252 6,951 7,100 5,336 6400 RENTALS 6410 SOFTWARE - ANNUAL FEES 42,105 44,338 20,820 46,590 51,120 6430 BUILDING RENT (IS FUND) 10,440 13,248 6,270 12,540 12,400 6400 RENTALS 52,545 57,586 27,090 59,130 63,520 6470 DUES/TRAINING/TRAVEL 6472 CONFERENCE /SCHOOUTRAINING 303 299 400 600 6475 TRAVEUSUBSISTENCE 553 557 101 600 600 6480 DUES 355 355 285 350 370 R5509BUD SH005P1V CITY OF SHAKOPEE 7/22/2011 11:07:28 By Co, Div (pb), Object (1 Yr Bdgt) - Portrait Budget Report Page - 2 Fiscal Period: 6 / 11 Level Of Rollup 7 2009 2010 6/30/2011 2011 2012 Actual Actual YTD Final Proposed Object Code / Description Amount Amount Actual Budget Budget 6470 DUES/TRAINING/TRAVEL 1,211 1,211 386 1,350 1,570 6200 SUPPLIES AND SERVICES 488,206 543,042 332,345 526,900 568,126 6500 DEPRECIATION 6600 MISCELLANEOUS 6640 DESIGNATED MISCELLANEOUS 6660 CASH SHORT -OVR /BANK FEES 14 13 6 6640 DESIGNATED MISCELLANEOUS 14 13 6 6600 MISCELLANEOUS 14 13 6 6700 CAPITAL OUTLAY 6800 DEBT SERVICE 6840 DEBT SERVICE INTEREST 6000 EXPENDITURES 762,861 794,863 503,986 794,600 855,696 15 FINANCE 762,861 794,863 503,986 794,600 855,696 01000 GENERAL FUND 762,861 794,863 503,986 794,600 855,696 Finance 2012 Budget 2012 0151 Object # Description Management 151 6002 Wages FT - Reg. 215,570 151 6005 Wages OT - Reg. 1,500 151 6015 Wages PT 151 6122 PERA 15,740 151 6124 FICA 16,620 151 6135 Health 27,350 151 6139 PEHP 900 151 6140 Life 1,000 151 6145 Dental 1,440 151 6170 Workers Comp 1,450 151 6180 Compensated Absences 6,000 151 6185 OPEB Total Personnel 287,570 151 6210 Office Supplies 2,000 151 6310 Attorney 800 151 6316 Equipment Maintenance 500 151 6320 Lodging Tax 180,000 151 6327 Other Prof Services 310,000 151 6332 Postage 2,000 151 6334 Telephone 400 151 6336 Printing /Publishing 2,000 151 6352 Liability Insurance 5,327 151 6356 Auto Insurance 9 151 6410 Software 51,120 151 6430 Building Rent (IS FUND) 12,400 151 6472 Conf / School / Training 600 151 6475 Travel /Subsistence 600 151 6480 Dues 370 Total Supplies & Services 568,126 151 6740 Capital Expenditures Total $ 855,696