Loading...
HomeMy WebLinkAbout2012 Adopted Budget1 i I ,�ii Nrni�CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET (Adopted November 15, 2011) - CITY OF GEM LAKE, MINNE S O TA 2012 ADOPTED BUDGE] (Adopted November 15, 2011) CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET BUDGET SUMMARY BY FUND TYPE REVENUE BUDGET ACCOUNT DESCRIPTION GENERALFUND SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS CAPITAL IMPROVEMENT FUNDS ENTERPRISE FUNDS EXPENDITURE BUDGET GENERALFUND SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS CAPITAL IMPROVEMENT FUNDS ENTERPRISE FUNDS 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTED $442,354 $481,037 $384,402 $326,156 807 585 549 377 149,586 153,793 127,977 132,161 19,436 111.231 12,793 16,861 79,038 177,279 47,309 48,739 11/1512011 011 2012 ECTED ADOPTED 05,070 $282,939 498 377 14,473 125,089 16,989 16,989 50,472 47,452 87,503 $472,846 $343,968 $459,624 $266,386 $411,755 $ 46,438 $419,387 0 0 0 0 0 0 141,581 151.392 149,932 153,465 53,365 151,790 60,791 141,705 1,042 0 0 0 38,933 37,000 63.511 43 RaR sa u" .1 - FUND BALANCE -JANUARY1 $740,071 $857,435 $956,468 $1,061,083 $1,0 1,083 $1,024,460 EXCESS REVENUE OVER EXPENDITURES $105,948 $134,204 $92,159 ($84,574) ($ 9,123) ($151,095) INFRASTRUCTURE CHANGES $11 416 ($35,172) $12,457 $12,000 $17 Snn ¢i'2 cnn Enterprise 8.46% Capital Improvemi 0.00% 2012 ADOPTED BUDGETED EXPENDITURES BY FUND TYPE Debt Service 0.00% 24.33% CHANGE -13.25% 0.00% -5.35% 0.76% -2.64% 1.85 % 0.00% -1.09% 0.00% 20.89% (Adopted November 15, 2011) Page 1 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET THIS PAGE INTENTIONALLY LEFT (Adopted November 15, 2011) Page 2 4110 4190 4160, 41411 41501 41911 41941 4210( 4220( 4230( 42401 43122 4312E 44100 4900 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET GENERAL FUND BUDGET SUMMARY BY ACTIVITY 11/15/2011 REVENUES BY CLASSIFICATION 2008 ACTUAL 2009 ACTUAL 2010 2011 2011 2012 PROPERTY TAXES ACTUAL ADOPTED PROJECTED ADOPTED CHANGE LICENSES & PERMITS $370,861 $421,301 $329,189 $268,234 $ 48,597 $222,172 -1717% INTERGOVERNMENTAL REVENUES 21.664 16,743 16,856 18,905 12.880 21,491 15,005 16.50% CHARGES FOR SERVICES 13,454 9,662 10,796 8,471 8,430 -21.92 % FINES & FORFEITS 3,443 1,172 1,712 550 6,263 550 0.00% MISCELLANEOUS 2,255 1,774 1,811 1,700 2,801 4,060 138.82% TOTAL REVENUES 27,387 26,481 23,123 31,996 17,447 32,722 2.27% $442,354 $481,037 $384,402 $326,156 $3 5,070 $282,939 13.25% EXPENDITURES BY DEPARTMENT GENERAL GOVERNMENT ) CITY COUNCIL $9,463 $6,321 $6,304 $37,266 $5,994 $32,266 -13.42% ) GENERALGOVERNMENT 38,178 42,107 40,424 59,069 0,952 55,771 ) LEGAL SERVICES 32,191 30,944 11,541 28,500 7,000 18,500 -5.58% -35.09% ELECTIONS FINANCIAL ADMINISTRATION 6,105 410 4,352 500 425 4.765 853.00% PLANNING & ZONING 40,712 35,634 37,144 43,580 38,135 43,820 0.55% HERITAGE HALL 18,060 19,344 6,770 9,950 5,233 4,950 -50.25% TOTAL GENERAL GOVERNMENT 22,900 $167,608 19,032 14,681 28,550 37,550 24,850 -12.96% $153,792 $121,214 $207,415 $1 5,289 $184,922 -10.847 PUBLIC SAFETY I POLICE FIRE PROTECTION 76,055 82,245 81,584 84,574 E 3,660 88,000 4.05% ANIMAL CONTROL 16,835 17,839 17.520 16,863 16,862 19,000 12.67% BUILDING INSPECTIONS 0 10,269 702 9,822 98 9,499 100 12,138 153 1,500 1400.00% TOTAL PUBLIC SAFETY $103,159 $110,608 $108,701 $113,675 $11 9,724 12,300 $120,800 1.33% ,399 6.27% PUBLIC WORKS ROAD MAINTENANCE 4,157 28,369 12,831 39,950 14,250 27,950 -30.04% ICE & SNOW REMOVAL 24,044 14,757 23,639 25,715 15,500 25,715 0.00% PARK MAINTENANCE 0 0 0 TOTAL PUBLIC WORKS $28,201 $43,126 $36,470 0 $65,665 $30,750 0 0 $53,665 0.00% -18.27% OPERATING TRANSFERS OPERATING TRANSFERS 45,000 152,098 0 25,000 70,000 60,000 140.00% TOTAL OPERATING TRANSFERS $45,000 $152,098 $0 $25,000 $7 ,000 $60.000 140.00% TOTAL EXPENDITURES $343,968 $459,624 $266,386 $411,755 $34 ,438 $419,387 1.85% FUND BALANCE - JANUARY 1 $174,265 $272,651 $294,065 $412,081 $412,081 $370 EXCESS REVENUE OVER EXPENDITURES $98,386 $21,413 $118,016 ($55,599) ($4 ,368) .713 ($370,713 FUND BALANCE - DECEMBER 31 $272,651 $294,065 $412,081 $326,482 $37 ,713 $234265 -28.25% FUND BALANCE AS A % OF NEXT YEAR'S EXPENDITURES/BUDGET (NET OF TRANS) 88.66% 110.39% 106.55% 90.84% 10 .15% N/A FUND BALANCE AS A % OF CURR YEAR'S EXPENDITURES (NET OF TRANSFERS) 91.20% 95.62% 154.69% 84.42% 13 .10% 65.18 % (Adopted November 15, 2011) Page 3 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 2012 PROPOSED REVENUES BY CLASSIFICATION Property Taxe; 78.52% 2012 ADOPTED EXPENDITURES BY DEPARTMENT Public Works Transfers 12.80%14.31 % Public Safety 28.80% Intergovernmental 2.98% ges for Services 0.19% as & Forfeits 1.43% liscellaneous 11.57% (Adopted November 15, 2011) Page 4 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET GENERAL FUND REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION F'HOPERTY TAXES 31001 CURRENT TAXES 31002 DELINQUENT TAXES 31003 FISCAL DISPARITIES 31004 PENALTIES & INTEREST TOTAL PROPERTY TAXES LICENSES & PERMITS 32100 GENERAL BUSINESS LICENSES 32101 ON -SALE LIQUOR LICENSES 32102 OFF SALE LIQUOR LICENSE 32103 NON -INTOXICATING LIQUOR LICENSES 32104 OTHER PERMITS 32106 TOBACCO LICENSE 32107 CHARITABLE GAMBLING LICENSE 32201 CONTRACTOR LICENSE 32210 BUILDING PERMITS 32211 PLUMBING PERMITS 32212 GAS/HEATING PERMITS 32213 ELECTRICAL PERMITS 32218 FIRE MARSHALL INSPECTION FEE 32219 SEPTIC INSPECTION FEE 32240 ANIMAL CONTROL LICENSE TOTAL LICENSES & PERMITS INTERGOVERNMENTAL REVENUES 33401 LGA 33402 HACA 33430 COUNTY GRANTS & AIDS 33601 SCORE GRANT 33603 POLICE STATE AID 33602 CABLE TV FRANCHISE FEES 33604 OTHER GOVERNMENT AIDS AND GRANTS TOTAL INTERGOV. REVENUES CHARGES FOR SERVICES 32220 SURCHARGE/SAC RETAINAGE 32230 ADMINISTRATIVE CHARGES 34105 PLANNING CHARGES 34110 PLAN CHECK FEES 34120 SALE OF SUPPLIES 34121 SPECIAL ASSESSMENT SEARCHES 34122 ENGINEERING CHARGES 34126 CHARGES FOR LEGAL FEES 34132 INVESTMENT ADMINISTRATIVE CHARGE 34135 CONTRACTUAL SERVICES i U I AL UHAKGES FOR SERVICES FINES & FORFEITS 35100 TRAFFIC & OTHER FINES TOTAL FINES & FORFEITS MISCELLANEOUS REVENUES 36210 INTEREST EARNINGS 36231 CHARITABLE GAMBLING CONTRIBUTIONS 36241 INSURANCE POLICY DIVIDENDS 36200 MISCELLANEOUS 36400 FACILITY RENTAL 39200 TRANSFERSIN TOTAL MISCELLANEOUS TOTAL GENERAL FUND REVENUES 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL AnOPTFn $357,600 $393,062 $323,457 $261,169 3,790 16,799 4,460 0 8,563 11,040 930 7,065 909 399 343 n $370,861 $421,301 $329,189 $268,234 0 1,900 1,275 1,275 2,900 5,100 2,200 2,200 0 0 0 0 0 0 0 0 100 0 675 0 0 350 350 350 0 225 225 225 755 450 825 300 9,172 1,546 5,647 1,100 386 343 511 100 430 235 454 120 920 205 325 500 2,855 3,141 2,938 3,000 3,757 3,091 3,240 3,210 390 270 240 500 $21,664 $16,866 $18,905 $12,8 00 2,808 0 0 0 4,891 0 0 0 143 28 27 0 951 862 873 1,000 4,189 3,892 4,299 5,796 3,761 8,672 4,463 4,000 0 0 0 0 $16,743 $13,454 $9,662 $10,796 143 57 100 100 0 562 402 0 0 0 0 0 3,300 97 659 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 0 456 532 450 0 0 0 0 $3,443 $1,172 $1,712 $550 2,255 1,774 1,811 1,700 $2,255 $1,774 $1,811 $1,700 10,323 3,751 4,739 4,000 4,580 4,632 3,463 5,500 0 768 446 150 83 377 322 350 12,402 16,953 14,153 21,996 0 0 0 n $27,387 $26,481 $23,123 $31,996 442,354 $481,037 $3&4,402 $326,156 11/1512011 011 2012 % IECTED ADOPTED CHANGE A0,601 $216,623 -17.06% 4,150 0 0.00% 2,680 5,549 -21.46% 1,166 0 0.00% 48,597 $222,172 -17.17% 1,800 1,700 33.33% 4,400 4,400 100.00% 0 0 0.00% 0 0 0.00% 1,475 0 0.00% 500 350 0.00% 500 225 0.00% 1,200 300 0,00% 4,330 1,100 0.00% 466 100 0.00% 393 120 0.00% 157 500 0.00% 3,000 3,000 0.00% 31060 3,210 0.00% 210 0 -100.00% 11,491 $15,005 16.50% 0 0 0.00% 0 0 0.00% 25 0 0.00% 796 796 -20.40% 3,650 3,634 -37.30% 4,000 4,000 0.00% 0 0 0.00% 8,471 $8,430 -21.92% 139 100 0.00% 465 0 0.00% 4,700 0 0,00% 494 0 0.00% 0 0 0.00% 0 0 0.00% 0 0 0.00% 0 0 0.00% 465 450 0.00% 0 0 nnni 5,263 !,801 $550 4,060 0.00% 138.82% 701 $4.060 138.82% 1,493 4,500 12.50% ,479 5,500 0.00% 546 150 0.00% 507 400 14.29% ,422 22,172 0,80% 0 0 0.00% ,447 $32,722 2.27% ,070 $282,939 -13.25% (Adopted November 15, 2011) Page 5 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET CITY COUNCIL DEPARTMENT 41100 ACCT. 2008 2009 2010 2011 2011 # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED P OJECTEC PERSONNEL SERVICES 100 WAGES & SALARIES $5,356 $5,356 $5,287 $5,356 $5,356 130 FICA CONTRIBUTIONS 410 410 404 410 410 TOTAL PERSONNEL SERVICES $5,766 $5,766 $5,692 $5,766 $5,766 OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 0 0 308 ADMINISTRATION 725 0 0 0 0 0 0 310 CONFERENCE REGISTRATION FEES 0 555 0 0 333 MEETING EXPENSES 2,450 0 0 1,500 0 364 OTHERINSURANCE 261 0 0 0 0 0 449 COUNCIL CONTINGENCY 261 0 612 30,000 0 228 TOTAL OTHER SERVICES & CHARGES $3,697 $555 $612 $31,500 $228 TOTAL CITY COUNCIL 11/15/2( 2012 o� CHANGE 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -16.67% -15.87% -13.42% (Adopted November 15, 2011) Page 6 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET CLERK/GENERAL GOVERNMENT DEPARTMENT 41900 ACCT. # ACCOUNT DESCRIPTION PERSONNEL SERVICES 100 WAGES & SALARIES 130 FICA CONTRIBUTIONS 131 PERA CONTRIBUTIONS 135 HEALTH INSURANCE 150 WORKER'S COMPENSATION TOTAL PERSONNEL SERVICES SUPPLIES 200 OFFICE SUPPLIES 212 POSTAGE 250 SALES TAX I U I AL SUPPLIES OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 305 ADMINISTRATION 308 PROFESSIONAL SERVICES 309 MISCELLANEOUS 310 CONFERENCE REGISTRATION FEES 320 INTERNET CONNECTION 322 WEB SITE 331 MILEAGE 332 RECORDING SECRETARY 334 COMPUTER SERVICES 346 MARKETING & ADVERTISING 350 PRINTING - OTHER 351 LEGAL NOTICES 352 NEWSLETTER/PUBLIC RELATIONS 361 GENERAL LIABILITY INSURANCE 362 PROPERTY INSURANCE 363 VEHICLE INSURANCE 365 PUBLIC OFFICIALS LIABILITY INSURANCE 384 RECYCLING COLLECTION 434 VLAWMO 435 -MG 436 RCLLG 440 DUES & SUBSCRIPTIONS 450 CHARITABLE GAMBLING DISTRIBUTIONS TOTAL OTHER SERVICES & CHARGES CAPITAL OUTLAY 570 FURNITURE & OFFICE EQUIPMENT 580 OTHER EQUIPMENT/IMPROVEMENTS TOTAL CAPITAL OUTLAY TOTAL CLERK/GENERAL GOVERNMENT 1111512011 2008 2009 2010 2011 1011 2012 ACTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPTED $10,372 $13,651 10,711 16,359 3,000 17,061 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $10,372 $13,651 $10,711 $16,359 $3,000 $17,061 $2,674 $1,666 $1,164 $2,000 $1,000 $2,000 9 1,293 1,211 1,500 1,100 1,500 0 0 0 0 0 0 $2,683 $2,960 $2,375 $3,500 $2,100 $3,500 $318 $0 $0 $0 $0 $0 2,641 3,482 3,536 5,000 2,000 5.000 0 0 0 0 0 0 296 131 228 200 0 200 0 0 0 0 0 0 220 0 0 0 0 0 635 750 600 1,000 670 1,000 502 55 170 250 175 250 1,740 1,878 2,100 2,100 1,800 2,100 1,247 1,360 1,360 1,500 1,500 1,500 0 0 0 0 0 0 0 0 0 0 0 0 673 3,355 1,020 5,000 1,000 2,000 2,514 3,116 2,110 4,000 2,000 3,000 1,183 1,526 1,546 1,800 1,500 1,800 20 0 0 0 0 0 67 64 63 65 50 65 0 57 136 150 200 150 4,290 4,245 9,428 12,000 0,100 12,000 0 0 0 0 0 0 528 491 457 500 462 500 100 100 125 125 125 125 0 20 20 20 20 20 5,708 4,867 4,440 5,500 4,250 5,500 $22,681 $25,496 $27,338 $39,210 $ 5,852 $35,210 $2.441 $0 $0 $0 $0 $0 0 0 0 0 0 0 $2,441 $0 $0 $0 $0 $0 $38,178 $42,107 $40,424 $59,069 $ 0.952 $5.5771 CHANGE 4.29% 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% 0.00% 0.00% 0,00% 0.00% -60.00% -25.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -10.20% 0.00% 0.00% 0.00% (Adopted November 15, 2011) Page 7 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET LEGAL SERVICES DEPARTMENT 41600 ACCT. 2008 2009 2010 2011 2011 11/15/2( 2012 # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPTI OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 0 0 0 303 PROSECUTION 3,295 1,218 630 0 3,500 0 2,000 3,! 304 LEGAL SERVICES 22,055 24,742 10,876 25,000 15,000 15,1 305 LEGAL SERVICES - LAND ISSUES 3,338 4,985 35 0 309 MISCELLANEOUS 0 0 0 0 0 317 LEGAL -ANNEXATION 3,503 0 0 0 0 0 TOTAL OTHER SERVICES & CHARGES $32,191 $30,944 $11,541 $28,500 $17,000 $18„ TOTAL LEGAL SERVICES $32,191 $30,944 $11,541 $28,500 $17,000 $18.' CHANGE 0.00% 0.00% -40.00 % 0.00% 0.00% 0.00% -35.09% -35.09% (Adopted November 15, 2011) Page 8 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET ACCT. # ELECTIONS DEPARTMENT 41410 ACCOUNT DESCRIPTION PERSONNEL SERVICES 100 WAGES & SALARIES 105 TEMPORARY EMPLOYEES 130 FICA CONTRIBUTIONS 160 WORKER'S COMP. TOTAL PERSONNEL SERVICES SUPPLIES 210 OPERATING SUPPLIES - OTHER 212 POSTAGE 250 SALES TAX TOTAL SUPPLIES OTHER SERVICES & CHARGES 308 ADMINISTRATION 309 MISCELLANEOUS 331 MILEAGE 350 OTHER PRINTING 351 LEGAL NOTICES 400 REPAIR/MAINTENANCE EQUIPMENT TOTAL OTHER SERVICES & CHARGES TOTAL ELECTIONS 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTED $0 $0 $0 $0 969 0 851 0 0 0 0 0 0 0 0 0 $969 $0 $851 $0 55 0 12 0 0 0 0 0 0 0 0 0 $55 $0 $12 $0 2,993 0 2,825 0 2,088 0 219 0 0 0 13 0 0 0 0 50 0 0 0 0 0 410 432 450 $5,081 $410 $3,489 $500 $6,105 $410 $4.352 R5oo 11/15/2011 11 2012 % :CTED ADOPTED CHANGE $0 $0 0.00% 0 1,000 0.00% 0 0 0.00% 0 0 0.00% $0 $1,000 0.00% 0 50 0.00% 0 0 0.00% 0 0 0.00% $0 $50 0.00% 0 3,000 0.00% 0 200 0.00% 0 15 0.00% 0 50 0.00% 0 0 0.00% 425 450 0.00% $425 $3,715 643.00% $425 $4,765 853.00% (Adopted November 15, 2011) Page 9 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET FINANCIAL ADMINISTRATION DEPARTMENT 41500 ACCT. 2008 2009 2010 2011 2011 # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED PR JECTEE PERSONNEL SERVICES SUPPLIES 200 OFFICE SUPPLIES 0 0 250 SALES TAX 0 0 0 0 0 0 0 0 TOTAL SUPPLIES $0 $0 $0 $0 $0 OTHER SERVICES & CHARGES 308 ADMINISTRATION 150 0 0 301 AUDITING SERVICES 10,000 7,600 9,007 0 8,080 0 8,135 329 ACCOUNTING SERVICES 29,561 28,034 28,137 35,000 30,000 334 COMPUTER SERVICES 1,001 0 0 309 MISCELLANEOUS EXPENSE 500 0 0 0 0 0 0 TOTAL OTHER SERVICES & CHARGES $40,712 $35,634 $37,144 $43,580 $38,135 TOTAL FINANCIAL ADMINISTRATION $40,712 $35,634 $37,144 $43,580 $38.135 11/15/2011 2012 ' % ADOPTED' CHANGE 0.00% 0.00% $ 0.00% 0.00% 8,320 2.97% 35,000 0.00% 500 0.00% 0 0.00% $43,820 0.55% $431820 0.55% (Adopted November 15, 2011) Page 10 PLANNING & ZONING DEPARTMENT 41910 ACCT. # ACCOUNT DESCRIPTION OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 308 ADMINISTRATION 302 ENGINEERING SERVICES 309 MISCELLANEOUS 315 ZONING ADMINISTRATION 325 NPDES TRAINING 326 NPDES EDUCATION 327 NPDES ADMINISTRATION 332 RECORDING SECRETARY 348 COMP, PLAN UPDATE 433 DUES & SUBSCRIPTIONS TOTAL OTHER SERVICES & CHARGES CAPITAL OUTLAY 570 FURNITURE & OFFICE EQUIPMENT TOTAL CAPITAL OUTLAY TOTAL PLANNING & ZONING CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 1111512011 2008 2009 2010 2011 2011 2012 ACTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPTED CHANGE 5,485 0 0 0 255 0 0.00% 1,752 1,122 2,664 3,000 3,000 3,000 0.00% 2,510 0 497 0 628 0 0.00% 0 0 0 0 0 0 0.00% 1,200 46 184 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 1,050 1,650 1,950 1,350 1,950 0.00% 7,113 17,126 1,774 5,000 0 0 -100.00% 0 0 0 0 0 0 1 0.00% $18,060 $19,344 $6,770 $9,950 $5,233 $4,950 -50.25% 0 0 0 0 0 0 0.00% $0 $0 $0 $0 $0 $0 0.00% $18,060 $19,344 $6,770 $9,950 $5,233 $4,950 -50.25 % (Adopted November 15, 2011) Page 11 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET HERITAGE HALL DEPARTMENT 41940 ACCT. 2008 2009 2010 2011 2011 11/15/201 2012 % # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPTEC CHANGE SUPPLIES 205 CLEANING SUPPLIES 0 0 210 OPERATING SUPPLIES - OTHER 1,377 718 0 609 0 0 0.00% 211 CHEMICALS 2,000 1,200 2,00 0.00% 230 BUILDING MATERIALS 0 0 0 0 0 0 0.00% 250 SALES TAX 22 0 g 0 0 0 0.00% TOTAL SUPPLIES $1,398 $727 0 $609 200 $2,200 0 $1,200 20 $2,2011 0.00% 0.00% OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 2,750 3,090 1,890 4,000 3,000 309 CONTRACT SERVICES 0 1,499 293 4,000 0.00% 321 TELEPHONE 1,162 1,183 1,211 2,200 1,500 2,500 13.64% 362 PROPERTY INSURANCE 406 662 1,500 1,500 1,500 0.00% 381 ELECTRICITY 3,065 3,705 705 3,438 750 3,900 750 750 0.00% 383 GAS 3,900 3,900 0.00% 384 RUBBISH/RECYCLING 1,969 1,586 1,384 3,000 2,000 3,000 0.00% 385 WATER/SEWER UTILITIES 0 1,678 0 1,179 0 383 0 2,000 0 0 0.00% 400 REPAIR/MAINTENANCE - OTHER 482 75 1,200 2,000 0.00% 401 REPAIR/MAINTENANCE - BUILDINGS 318 5,326 332 4,436 500 2,500 500 16,000 500 0.00% TOTAL OTHER SERVICES & CHARGES $11,830 $18,305 $14,072 $20,350 $30,350 4,000 $22,150 60.00% 8.85% CAPITAL OUTLAY 520 BUILDING IMPROVEMENTS 244 0 0 570 FURNITURE & OFFICE EQUIPMNT 0 3,000 3,000 500; -83.33% 580 OTHER EQUIPMENT/IMPROVEMENTS 9,427 0 0 0 0 0 0 0 0.00% TOTAL CAPITAL OUTLAY $9,672 $0 $0 3,000 3,000 0 -100.00% $6,000 $6,000 $500 -91,67% TOTAL BUILDING MAINTENANCE $22,900 $19,032 $14,681 $28 550 $37 550 $24,850 -12.96 % (Adopted November 15, 2011) Page 12 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET POLICE DEPARTMENT 42100 ACCT. 11/15/2011 # ACCOUNT DESCRIPTION 2008 ACTUAL 2009 ACTUAL 2010 2011 2011 2012 ACTUAL ADOPTED PROJECTED ADOPTED OTHER SERVICES & CHARGES 305 REGULAR LAW ENFORCEMENT 73,589 79,779 78,904 81,652 80,828 85,000 306 SPECIAL LAW ENFORCEMENT 0 0 0 307 DISPATCH COSTS 2,466 2,466 2,680 0 2,922 0 2,832 0 3,000 308 ADMINISTRATION 0 0 0 309 MISCELLANEOUS 0 0 0 0 0 0 TOTAL OTHER SERVICES & CHARGES $76,055 $82,245 $81,584 0 $84,574 $ p 3,660 0 $88,000 TOTAL POLICE 'Mnag Oo — -- __.— CHANGE 4.10% 0.00% 2.67 % 0,00% 0.00% 4.05% 4.05% (Adopted November 15, 2011) Page 13 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET FIRE DEPARTMENT 42200 ACCT. 2008 2009 2010 2011 2011 11/15/201 2012 4 ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPTEI OTHER SERVICES & CHARGES 308 ADMINISTRATION $0 $0 $0 $0 $0 309 MISCELLANEOUS 0 0 0 311 FIRE SERVICE 12,907 14,109 13,808 0 13,115 0 13,427 15,0( 312 FIRE MARSHALL SERVICES 3,928 3,730 3,712 3,748 3,435 4,0( TOTAL OTHER SERVICES & CHARGES $16,835 $17,839 $17,520 $16,863 $16,862 $19,0( TOTAL FIRE $16,835 $17,839 $17,520 $16.863 tir AR9 Cio— CHANGE 0.00% 0.00% 14.37% 6.72% 12.67% 12.67% (Adopted November 15, 2011) Page 14 ANIMAL CONTROL DEPARTMENT42300 ACCT. # ACCOUNT DESCRIPTION CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTED 11/15/2011 2012 ADOPTED CHANGE U I HER SERVICES & CHARGES 300 309 323 324 PROFESSIONAL SERVICES MISCELLANEOUS ANIMAL REMOVAL ANIMAL ENFORCEMENT TOTAL OTHER SERVICES & CHARGES 0 0 0 0 $0 0 0 100 602 $702 0 42 0 56 $98 0 0 0 100 $100 0 0 0 153 $153 0 0 0 1,500 $1,500 0.00% 0.00% 0.00% 1400.00% 1400.00% TOTAL ANIMAL CONTROL CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET BUILDING INSPECTIONS DEPARTMENT 42401 ACCT. 11115/201 # ACCOUNT DESCRIPTION 2008 ACTUAL 2009 ACTUAL 2010 ACTUAL 2011 2011 2012 OTHER SERVICES & CHARGES ADOPTED PROJECTED ADOPTE 313 BUILDING INSPECTIONS 7,410 8,559 8,168 9,538 8,538 10,70 309 MISCELLANEOUS 0 0 0 316 BUILDING SECRETARY SERVICES 1,479 760 827 0 2,000 32 334 COMPUTER SERVICES 1,380 504 504 650 1,00 328 CODE ENFORCEMENT 600 504 60 0 0 0 0 0 TOTAL OTHER SERVICES & CHARGES $10,269 $9,822 $9,499 $12,138 $9,724 $12,300 CAPITAL OUTLAY 570 FURNITURE & EQUIPMENT 0 0 TOTAL CAPITAL OUTLAY $0 $0 0 $0 0 0 0 $0 $0 $ TOTAL BUILDING INSPECTIONS $10,269 $9,822 $9,499 $12 138 $9,724 $12,301 CHANGE 12.18% 0.00% -50.00% 0.00% 0.00% 1.33% 0.00% 0.00% 1.33% (Adopted November 15, 2011) Page 16 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET ROAD MAINTENANCE DEPARTMENT 43122 ACCT. # ACCOUNT DESCRIPTION SUPPLIES 211 CHEMICALS 210 OPERATING SUPPLIES - OTHER 224 GRAVEL/STREET MATERIAL 225 SALT/SAND 226 SIGNS, SIGN REPAIR MATERIALS 250 SALES TAX TOTAL SUPPLIES OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 302 ENGINEERING FEES 308 ADMINISTRATION 309 MISCELLANEOUS 327 NPDES-STORMWATER 351 LEGAL NOTICES 382 ELECTRICITY - STREET LIGHTS 385 ROW MAINTENANCE 405 ROAD MAINTENANCE/REPAIR 433 DUES AND SUBSCRIPTIONS TOTAL OTHER SERVICES & CHARGES CAPITAL OUTLAY 540 HEAVY MACHINERY/EQUIPMENT 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTI 11/15/2011 1 2012 ,TED ADOPTED CHANGE 0 0 0 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 424 0 700 0 700 0.00% 0 0 0 0 0 0 0.00% $0 $424 $0 $700 $0 $700 0.00% 0 0 0 0 0 0 0.00% 3,022 7,003 2,771 3,000 3,000 3,000 0.00% 0 0 0 0 0 0 0.00% 0 0 0 0 0 0 0.00% 0 15,581 400 15,000 7,000 10,000 -33.33% 0 0 0 0 0 0 0.00% 854 1,011 953 1,200 1,200 1,200 0.00% 0 2,214 3,491 5,000 0 5,000 0.00% 239 2,093 5,175 15,000 3,000 8,000 -46.67% 42 42 42 50 50 50 0.00% 4,157 $27,944 $12,831 $39,250 $ 4,250 $27.250 -30.57% 0 0 0 0 0 0 0.00% TOTAL CAPITAL OUTLAY $0 $0 $0 $0 $0 $0 0.00% TOTAL ROAD MAINTENANCE $4,157 $28,369 $12,831 $39,950 $14,250 $27950 -3004% (Adopted November 15, 2011) Page 17 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET ICE & SNOW REMOVAL ^ DEPARTMENT 43125 ACCT. 11/15/201 # ACCOUNT DESCRIPTION 2008 ACTUAL 2009 ACTUAL 2010 2011 ACTUAL ADOPTED PROJECTED 2011 2012 ADOPTEE % CHANGE SUPPLIES 225 SALT SAND 7,091 4,160 6,265 10,000 6,000 10,00 0.00% 210 OPERATING SUPPLIES - OTHER 0 0 0 250 SALES TAX 461 276 432 0 715 0 500 0.00% ^ TOTAL SUPPLIES $7,551 $4,435 $6,697 $10,715 $6,500 71 $10,71 p 0.00 0.00% OTHER SERVICES & CHARGES 309 MISCELLANEOUS 0 0 0 0 ^ 400 REPAIR/MAINTENANCE - OTHER 1,110 0 0 0 0.00% 404 REPAIR/MAINTENANCE - CONTRACTUAL 15,383 10,322 16,942 0 15,000 0 10,000 15,00 0.00% TOTAL OTHER SERVICES & CHARGES $16,493 $10,322 $16,942 $15,000 $10,000 $15,00 0.00% 0.00% CAPITAL OUTLAY 540 HEAVY MACHINERY/EQUIPMENT 0 0 0 0 0 n n Anal I O I AL CAP] I AL OUTLAY $0 $0 An TOTAL ICE & SNOW REMOVAL CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET PARK MAINTENANCE DEPARTMENT 4410 ACCT. 11/15/2011 2008 2009 2010 2011 2012 % # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED '�011 PROJECTED ADOPTED CHANGE SUPPLIES 211 CHEMICALS 0 0 0 210 OPERATING SUPPLIES - OTHER 0 0 0 0 0 0.00% LANDSCAPING MATERIALS 0 0 0 0 0 0 0.00% 226 SIGNS, SIGN REPAIR MATERIALS 0 0 0 0 0 0 0.00% 250 SALES TAX 0 0 0 0 0 0.00% TOTAL SUPPLIES $0 0 $0 0 0 0 0 0.00% $0 $0 $0 $0 0.00% OTHER SERVICES & CHARGES 300 PROFESSIONAL SERVICES 0 0 0 404 PARK MAINTENANCE - CONTRACTUAL 0 0 0 0 0 0.00% 400 REPAIR/MAINTENANCE - OTHER 0 0 0 0 0 0 0.00% 309 MISCELLANEOUS 0 0 0 0 0 0.00% 0 0 0 TOTAL i AL OTHER HER Si RvICES & CHARGES 540 580 $0 $0 $0 $0 $0 w n nnoi CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET OPERATING TRANSFERS DEPARTMENT 4900 ACCT. 2008 2009 2010 2011 2011 11/15/21 2012 # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPT 720 TRANSFERS OUT 2004 Improvement Bonds 0 0 0 Improvement Fund - 401 0 0 Road Improvements 0 0 0 25,000 40,000 40, EAB TreatmenUPrevention 0 0 0 Building Improvements/Replacement 0 0 0 10,000 10, City Hall Construction Fund - 402 20,000 27,098 0 0 0 20,000 10 Sewer Fund - 601 25,000 125,000 0 0 0 0 0 TOTAL OPERATING TRANSFERS 45,000 152,098 0 25.000 7n nnn an o� CHANGE 0.00% 60.00 % 0.00% 0.00% 0.00% 0.00% 140.00% (Adopted November 15, 2011) Page 20 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 201 PARK AND PLAYGROUND FUND REVENUE BUDGET 11/15/2011 ACCT. 2008 2009 2010 2011 2�11 2012 # ACCOUNT DESCRIPTION ACTUAL ACTUAL ACTUAL ADOPTED PRO.IECTFn AnOPTPn rWAAII] MISCELLANEOUS 33604 GRANTS $0 $0 $0 $0 1 $0 $0 0.00% 34785 PARK DEDICATION FEES 0 0 36210 INTEREST INCOME 807 585 0 549 0 377 0 0 0.00% 36200 MISCELLANEOUS 0 498 377 -31.36% 39200 TRANSFERSIN 0 0 0 0 0 0 0.00% 0 0 0 0 0 0.00% TOTAL MISCELLANEOUS $807 $585 $549 $377 1 $498 $377 -31.36% TOTAL REVENUES $807 $585 $549 $377 $498 $377 0.00 % -31.36% EXPENDITURE BUDGET' SUPPLIES 210 OPERATING SUPPLIES - OTHER $0 $0 $0 $0 1 235 LANDSCAPING MATERIALS 0 0 $0 $0 0.00% 226 SIGNS & SIGN MATERIALS 0 0 0 0 I 0 0 0.00% 250 SALES TAX 0 0 0 0 0.00% 0 0 0 0 ! 0 0 0 00°/ I U I AL SUPPLIES OTHER SERVICES & CHARGES 302 ENGINEERING FEES 304 LEGALFEES 300 PROFESSIONAL SERVICES 400 REPAIR/MAINTENANCE - OTHER 540 EQUIPMENT $0 $0 $0 $0 0 $0 0.00% 0 0 0 0 0 0 0.00% 0.00% 0.00% 0.00 0.00 TOTAL OTHER SERVICES & CHARGES $0 $0 $0 $0 $0 $0 0.00 CAPITAL OUTLAY 510 LAND 580 OTHERIMPROVEMENTS 720 TRANSFERS OUT TOTAL CAPITAL OUTLAY 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% 0.00% 0.00 $0 $0 $0 $0 $0 $0 0.00% TOTAL EXPENDITURES $0 $0 $0 $0 $0 $0 0.00% FUND BALANCE - JANUARY 1 EXCESS REVENUE OVER EXPENDITURES $35,629 $807 $36,437 $585 $37,022 $549 $37,571 $377 $3/,571 $498 $38,069 $377 FUND BALANCE - DECEMBER 31 $36,437 $37,022 $37 571 $37 948 $30 069 $38 446 2 33% (Adopted November 15, 2011) Page 21 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET THIS PAGE INTENTIONALLY LEFT BLANKr- r r. �I (Adopted November 15, 2011) Page 22 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET DEBT SERVICE FUNDS SUMMARY REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTED 11 /15/2011 11 2012 % 'CTED ADOPTED CHANGE HKUHLKIY IAXES 31001 CURRENT TAXES 31002 DELINQUENT TAXES 31003 FISCAL DISPARITY TAX 31004 PENALTIES & INTEREST TOTAL PROPERTY TAXES $51,232 40 1,169 0 $21,706 2,491 610 0 $49,570 383 143 0 $52,000 0 0 0 $46,643 482 519 (47) $51,300 0 0 0 3.49% -100.00% -100.00% 0.00% $52,440 $24,807 $50,096 $52,000 $ 7,597 $51,300 2.40% SPECIAL ASSESSMENTS 36101 SPECIAL ASSESSMENTS 36102 DELINQUENT SPECIAL ASSESSMENTS 36103 PENALTIES & INTEREST 36104 SPECIAL ASSESSMENTS - PREPAID/SNR 66,718 70 26,480 0 101,153 106 22,602 0 55,642 0 18,009 0 59,362 0 17,174 0 47,604 108 15,575 13,534 56,624 0 13,403 0 1.77% 0.00% -25.57% 0.00% TOTAL FINES & FORFEITS $93,269 $123,861 $73,650 $76,536 $ 3,288 $70,027 -4.92% MISCELLANEOUS 36210 INTEREST EARNINGS 39000 MISCELLANEOUS 39200 BOND PROCEEDS 39300 TRANSFERS IN 3,877 0 0 0 5,126 0 0 0 4,231 0 0 0 3,625 0 0 0 3,588 0 0 0 3,762 0 0 0 -11.08% 0.00% 0.00% 0.00% TOTAL MISCELLANEOUS $3,877 $5,126 $4,231 $3,62E TOTAL REVENUES $149,586 $153,793 $127,977 $132,161 EXPENDITURE BUDGET CAPITAL OUTLAY 601 BOND PRINCIPAL 72,207 89,156 91,179 98,276 602 BOND INTEREST 68,924 61,686 58,203 54,539 603 FISCAL AGENT FEES 450 550 550 650 701 MISCELLANEOUS 0 0 0 0 720 TRANSFERS OUT 0 0 0 0 TOTAL CAPITAL OUTLAY $141,581 $151,392 $149,932 $153,465 TOTAL EXPENDITURES $141,581 $151,392 $149,932 $153,465 FUND BALANCE - JANUARY 1 $366,400 $374,404 $376,805 $354,850 EXCESS REVENUE OVER EXPENDITURES $8,004 $2,401 ($21,956) ($21,303 FUND BALANCE - DECEMBER 31 R374 404 1;147a unl V41A nGn " C-1 ... $3,762-11.08% 25,089 -2.26% 276 100,452 10.17% 539 50,688 -12.91% 550 650 18.18% 0 0 0.00% 0 0 0.00% 365 $151,790 1.24% 365 $151,790 1.24% 850 $315,958 -18.48% (Adopted November 15, 2011) Page 23 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 302 2004IMPROVEMENT BONDS REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION SPECIAL ASSESSMENTS 2008 ACTUAL 2009 ACTUAL 2010 ACTUAL 2011 ADOPTED PR 2011 JECTED 11/15/2011 2012 ADOPTED �� CHANGE 36101 SPECIAL ASSESSMENTS - CURRENT 36102 SPECIAL ASSESSMENTS - DELINQUENT 36103 PENALTIES &INTEREST 36104 SPECIAL ASSESSMENTS - PREPAID/SNR TOTAL FINES & FORFEITS $50,270 70 17,736 0 $68,077 $63,581 106 15,199 0 $78,887 $41,523 0 12,342 0 $53,864 $43,379 0 10,845 0 $54,224 $33,004 gg 8,261 3,534 $44,889 $40,641 -2.12 % OI 0.00% 8,128-34.14% 0 0.00% $48,769 -9.46% MISCELLANEOUS 36210 INTEREST EARNINGS 39100 BOND PROCEEDS 39200 TRANSFERS IN TOTAL MISCELLANEOUS 1,373 0 0 $1,373 1,968 0 0 $1,968 1,622 0 0 $1,622 1,346 0 0 $1,346 1,290 0 0 $1,290 1,346 0 0 $1,346 -17.03% 0.00% 0.00% -17.03% TOTAL REVENUES $69,449 $80,854 $55,487 $55,570 $46,179 $50,115 -9.68°% EXPENDITURE BUDGET CAPITAL OUTLAY 600 BOND PRINCIPAL 610 BOND INTEREST 620 FISCAL AGENT FEES 720 TRANSFERS OUT TOTAL CAPITAL OUTLAY $52,207 18,435 0 0 $70,642 $54,156 16,486 0 0 $70,642 $56,179 14,463 0 0 $70,642 $58,276 12,366 50 0 $70,692 $58,276 12,366 0 0 $70,642 $60,452 10,190 50 0 $70,692 7.61 % -29.55% 0.00% 0.00% 0.077 TOTAL EXPENDITURES $70,642 $70,642 $70,642 $70,692 $70,642 $70,692 0.07% FUND BALANCE - JANUARY 1 $138,003 $136,810 $147,022 $131,866 131,866 $107,403 EXCESS REVENUE OVER EXPENDITURES ($1,193) $10,212 ($15,156) ($15,122) $24,464) ($20,577) FUND BALANCE - DECEMBER 31 $136,810 $147,022 $131,866 $116 744 �107,403 $86,826 34.1 (Adopted November 15, 2011) Page 24 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 303 2006 IMPROVEMENT BONDS REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION SPECIAL ASSESSMENTS 36101 SPECIAL ASSESSMENTS -CURRENT 36102 SPECIAL ASSESSMENTS -DELINQUENT 36103 PENALTIES & INTEREST 36104 SPECIAL ASSESSMENTS - PREPAID/SNR TOTAL FINES & FORFEITS MISCELLANEOUS 36210 INTEREST EARNINGS 39100 BOND PROCEEDS 39200 TRANSFERS IN IUTALMISCELLANEOUS TOTALREVENUES EXPENDITURE BUDGET CAPITAL OUTLAY 600 BOND PRINCIPAL 610 BONDINTEREST 620 FISCAL AGENT FEES 720 TRANSFERS OUT TOTAL CAPITAL OUTLAY 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTED $16,448 $37,572 $14,119 $15,983 0 0 0 0 8,744 7,402 5,667 6,329 0 0 0 0 706 1,958 1,925 1,416 0 0 0 0 0 0 0 0 $706 $1,958 $1,925 $1,416 3,898 $46,932 $21,712 $23.728 11/15/2011 11 2012 CTED ADOPTED 4,60 19 0 7,314 5,275 0 0 1,933 $21,258 1,552 1,416 0 0 0 0 CHANGE 13.20% 0.00% -6.91 % 0.00% 7.44% -26A6 % 0.00% 0.00 u ,552 $1,416-26.46% ,485 $22,674 4.43 % $20,000 $20,000 $20,000 $25,000 $ 5,000 $25,000 10,105 9,245 8,385 7,418 7,418 6,343 0 0 0 50 0 50 0 0 0 0 0 0 $30.105 S29.245 R2R.RRF Q4)AA.A 25.00% -24.35% 0.00% 0.00% CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 304 2007 CAPITAL IMPROVEMENT PLAN BONDS REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION PROPERTYTAXES 31001 CURRENT TAXES 31002 DELINQUENT TAXES 31003 FISCAL DISPARITIES TAXES 31004 PENALTIES & INTEREST TOTAL FINES & FORFEITS MISCELLANEOUS 36210 INTEREST EARNINGS 39100 BOND PROCEEDS 39200 TRANSFERSIN TOTAL MISCELLANEOUS TOTAL REVENUES EXPENDITURE BUDGET CAPITAL OUTLAY 600 BOND PRINCIPAL 610 BONDINTEREST 620 FISCAL AGENT FEES 720 TRANSFERS OUT TOTAL CAPITAL OUTLAY TOTAL EXPENDITURES 11/15/2011 2008 2009 2010 2011 2011 2012 ACTUAL ACTUAL ACTUAL ADOPTED PR JECTED ADOPTED CHANGE $51,232 $21,706 $49,570 $52,000 $46,643 $51,30 -1.35% 40 2,491 383 0 482 0 0.00% 1,169 610 143 0 519 c 0.00% 0 0 0 0 (47) c 0.00% $52,440 $24,807 $50,096 $52,000 $47,597 $51,300 -1.35% 1,798 1,200 683 863 746 1,000 15.87% 0 0 0 0 0 0 0.00% 0 0 0 0 1 0 0 0.00% $1,798 $1,200 $683 $863 $746 $1,000 15.87% $54,238 $26,007 $50,779 $52,863 $48,343 $52,300 -1.07% $0 $15,000 $15,000 $15,000 $15,000 $15,000 0.00% 40,384 35,955 35,355 34,755 34,755 34,155 -1.73% 450 550 550 550 550 550 0.00% 0 0 0 0 0 0 0.00% $40,834 $51,505 $50,905 $50,305 $50,305 $49,705 -1.190 $40,834 $51,505 $50,905 $50,305 $50,305 $49,705 -1.19% FUND BALANCE -JANUARY1 $95,733 $109,136 $83,638 $83,512 EXCESS REVENUE OVER EXPENDITURES $13,404 ($25,498) ($126) $2,558 FUND BALANCE - DECEMBER 31 $109,136 $83,638 $83,512 $86.070 $81,650 $2,595 $84,145 -2.24% (Adopted November 15, 2011) Page 26 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET CAPITAL IMPROVEMENT FUND SUMMARY REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION SPECIAL ASSESSMENTS 36101 SPECIAL ASSESSMENTS 36102 DELINQUENT SPECIAL ASSESSMENTS 36103 PENALTIES & INTEREST 36104 TOTAL SPECIAL ASSESSMENTS MISCELLANEOUS 36210 INTEREST EARNINGS 36200 MISCELLANEOUS 39100 BOND PROCEEDS 39200 TRANSFERSIN TOTAL MISCELLANEOUS TOTAL REVENUES EXPENDITURE BUDGET OTHER SERVICES & CHARGES 302 ENGINEERING FEES 304 LEGAL FEES 335 ARCHITECT FEES 308 OTHER PROFESSIONAL SERVICE 309 MISCELLANEOUS 310 CONFERENCE REGISRATIONS 333 MEETING PREPARATION 351 LEGAL NOTICE PUBICATIONS 610 INTEREST 620 FISCAL AGENT FEES TOTAL OTHER SERVICES & CHARGES CAPITAL OUTLAY 531 OTHERIMPROVEMENTS 520 BUILDING CONSTRUCTION 720 OPERATING TRANSFERS TOTAL CAPITAL OUTLAY TOTAL EXPENDITURES FUND BALANCE - JANUARY 1 EXCESS REVENUE OVER EXPENDITURES FUND BALANCE - DECEMBER 31 11/1512011 2008 2009 2010 2011 2011 2012 CTUAL ACTUAL ACTUAL ADOPTED PROJECTED ADOPTED 0 14,094 12,206 15,966 13,529 16,285 0 0 0 0 2,167 0 0 0 1,383 1,316 1,851 997 $0 $14,094 $13,589 $17,282 $17,547 $17,282 ($564) ($87) ($797) ($421) ($558) ($293) 0 70,126 0 0 0 0 0 0 0 0 0 0 20,000 27,098 0 0 1 0 0 $19,436 $97,137 ($797) ($421) F6989 58) ($293) $19,436 $111,231 $12,793 $16,861 $ $16,989 2,184 0 0 0 0 0 0 0 1,042 0 0 0 (2,391) 0 0 0 0 0 3,785 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,577 $0 $1,042 $0 $0 $0 0 0 0 0 0 0 57,213 0 0 0 0 0 0 141,705 0 0 0 0 $57,213 $141,705 $0 $0 $0 $0 $60,791 $141,705 $1,042 $0 $0 $0 $14,257 ($27,098) ($57,571) ($45,821) ($4 ,821) ($28,832) $41,354) ($30,474) $11,761 $16,861 $1 ,989 $16.989 CHANGE 33.42% 0.00% -27.92% 27.17% -63.24% 0.00% 0.00% 0.00% -63.24% 32.80% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -100.00% 0.00% 0.00% 0.00% 0.00% 74.15% (Adopted November 15, 2011) Page 27 401 IMPROVEMENT FUND REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 11/15/2011 2008 2009 2010 2011 2011 2012 % ACTUAL ACTUAL ACTUAL ADOPTED PR JECTED MISCELLANEOUS ADOPTED CHANGE 36210 INTEREST EARNINGS 362DO MISCELLANEOUS 39100 BOND PROCEEDS 39200 TRANSFERS IN $0 0 0 $0 0 0 $0 0 0 $0 0 0 $14 0 0 $ 0.00% 0.00% 0.00% Road Improvements EAB Treatment/Prevention Building Improvements/Replacement TOTAL MISCELLANEOUS $0 $0 $0 25,000 $25,000 40,000 1 0,000 10,000 $70,014 40,000 10,000 10,000 $60,000 0.00% 0.00% 0.00% 0.00% TOTAL REVENUES $0 $0 $0 $25,000 $70,014 $60,000 0.00% EXPENDITURE BUDGET OTHER SERVICES & CHARGES 302 ENGINEERING FEES 304 LEGAL FEES TOTAL OTHER SERVICES & CHARGES 0 0 $0 0 0 $0 0 0 $0 0 0 $0 0 0 $0 0 0 $0 0.00% 0.00% 0.00% CAPITAL OUTLAY 531 OTHER IMPROVEMENTS 720 OPERATING TRANSFERS 0 0 0 0 0 0 0 0 0 0 0 0 0.00% 0.00% TOTAL CAPITAL OUTLAY $0 $0 $0 $0 $0 $0 0.00% TOTAL EXPENDITURES $0 $0 $0 $0 $0 $0 0.00% $0 1$70,014 $70,015 $60,000 FUND BALANCE - JANUARY 1 $0 $0 $0 $0 EXCESS REVENUE OVER EXPENDITURES $0 $0 $0 $25,000 FUND BALANCE - DECEMBER 31 $0 $0 $0 $25,000 $70,015 $130,015 34214255.26% (Adopted November 15, 2011) Page 28 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 402 CITY HALL CONSTRUCTION REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION 2008 ACTUAL 2009 ACTUAL 2010 ACTUAL 2011 ADOPTED 2011 PROJECTED 11/15/2011 2012 ADOPTED % CHANGE MISCELLANEOUS 36210 INTEREST EARNINGS 36200 MISCELLANEOUS 39100 BOND PROCEEDS 39200 TRANSFERS IN ($564) 0 0 20,000 $0 0 0 27,098 $0 0 0 0 $0 0 0 0 $0 0 0 0 $0 0 0 0 0.00% 0.00% 0,00% 0.00% TOTAL MISCELLANEOUS $19,436 $27,098 $0 $0 $0 $0 0.00% TOTAL REVENUES $19,436 $27,098 $0 $0 $0 $0 0.00% EXPENDITURE BUDGET OTHER SERVICES & CHARGES 302 ENGINEERING FEES 304 LEGAL FEES 308 ADMINISTRATION 309 MISCELLANEOUS 310 CONFERENCE REGISRATIONS 333 MEETING PREPARATION 335 ARCHITECT FEES 351 LEGAL NOTICE PUBICATIONS 610 INTEREST 620 FISCAL AGENT FEES 2,184 0 3,785 0 0 0 (2,391) 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 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 0 0 0 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% TOTAL OTHER SERVICES & CHARGES $3,577 $0 $0 $0 $0 $0 0.00% CAPITAL OUTLAY 531 BUILDING CONSTRUCTION 720 OPERATING TRANSFERS 57,213 n 0 n 0 0 0 - 0 _ 0.00% TOTAL CAPITAL OUTLAY $57,213 $0 $0 $0 $0 $0 0.007 TOTAL EXPENDITURES $60,791 $0 $0 $0 $0 $0 0.00% FUND BALANCE - JANUARY 1 $14,257 ($27,098) $0 $0 $0 $0 EXCESS REVENUE OVER EXPENDITURES ($41,354) $27,098 $0 $0 $0 $0 FUND BALANCE - DECEMBER 31 ($27,098) $0 $0 $0 $0 $0 0.00% (Adopted November 15, 2011) Page 29 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 403 SCHEUNEMAN ROAD IMPROVEMENT REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION 2008 ACTUAL 2009 ACTUAL 2010 ACTUAL 2011 ADOPTED PR 2011 JECTED 11/15/2011 2012 ADOPTED SPECIAL ASSESSMENTS 36101 SPECIAL ASSESSMENTS - CURRENT 36102 SPECIAL ASSESSMENTS - DELINQUENT 36103 PENALTIES & INTEREST 36104 SPECIAL ASSESSMENTS - PREPAID/SNR 0 0 0 0 14,094 0 0 0 12,206 0 1,383 0 15,966 0 1,316 0 13,529 2,167 1,851 0 16,28 99 TOTAL SPECIAL ASSESSMENTS $0 $14,094 $13,589 $17,282 $17,547 $17,282 MISCELLANEOUS 36210 INTEREST EARNINGS 36200 MISCELLANEOUS 39100 BOND PROCEEDS 39200 TRANSFERSIN $0 0 0 0 ($110) 44,460 0 0 ($1,353) 0 0 0 ($672) 0 0 0 ($907) 0 0 0 ($544) 0 0 0 TOTAL MISCELLANEOUS $0 $44,350 ($1,353) ($672) ($907) ($544) TOTAL REVENUES $0 $58,444 $12,236 $16,610 $16,640 $16,738 EXPENDITURE BUDGET OTHER SERVICES & CHARGES 302 ENGINEERING FEES 304 LEGALFEES 0 0 0 0 0 0 0 0 0 0 0 0 TOTAL OTHER SERVICES & CHARGES $0 $0 $0 $0 $0 $0 CAPITAL OUTLAY 531 OTHERIMPROVEMENTS 720 OPERATING TRANSFERS 0 0 141,705 0 0 0 0 0 0 p 0 p TOTAL CAPITAL OUTLAY $0 $141,705 $0 $0 $0 $0 TOTAL EXPENDITURES $0 $141,705 $0 $0 $0 $0 FUND BALANCE - JANUARY 1 EXCESS REVENUE OVER EXPENDITURES $0 $0 $0 ($83,261) ($83,261) $12,236 ($71,025) $16,610 $71,025) $16,640 ($54,415 111,7311 FUND BALANCE - DECEMBER 31 $0 ($83,261) ($71,025) ($54,415) $54.3851 rR. 7 a7 7 o� CHANGE 33.42 % 0.00% -27.92% 27.17% -59.80% 0.00% 0.00% 0.00% -59.80% 36.79 % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -46.95% (Adopted November 15, 2011) Page 30 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET 404 HOFFMAN ROAD IMPROVEMENT REVENUE BUDGET ACCT. 11/1512011 # ACCOUNT DESCRIPTION 2008 ACTUAL 2009 ACTUAL 2010 ACTUAL 2011 �011 2012 ADOPTED PROJECTED ADOPTED CHANGE MISCELLANEOUS 36210 INTEREST EARNINGS $0 $23 $556 $251 $334 $251 36200 MISCELLANEOUS 0 25,666 54 .89 39100 BOND PROCEEDS 0 0 0 0 0 .89% % 39200 TRANSFERSIN 0 0 0 0 0 0 0.00% TOTAL MISCELLANEOUS $0 0 $25,689 0 $556 0 $251 I 0 0 0.00% I $334 $251 -54.89% TOTAL REVENUES $0 $25,689 $556 $251 1 $334 $251 -54,89% EXPENDITURE BUDGET OTHER SERVICES & CHARGES 302 ENGINEERING FEES 0 0 0 304 LEGAL FEES 0 0 0 0.00% 385 ROW MAINTENANCE 0 0 1,042 0 TOTAL OTHER SERVICES & CHARGES $0 $0 $1,042 $0 0 0 100.00% $0 $0 -100.00 % CAPITAL OUTLAY 531 OTHERIMPROVEMENTS 0 0 720 OPERATING TRANSFERS n 0 0 0 0 0.00% I U I AL UAYI I AL UU ILA) TOTAL EXPENDITURES FUND BALANCE - JANUARY 1 EXCESS REVENUE OVER EXPENDITURES FUND BALANCE - DECEMBER 31 $0 $0 $0 $0 $0 $0 0.00% $0 $0 $1,042 $0 $0 $0-100.00% $0 $0 $25,689 $25,204 $'25,204 $25,455 $0 $25,689 ($486) $251 $334 9251 $0 0 (Adopted November 15, 2011) Page 31 ri CITY OF GEM LAKE, MINNESOTA I 2012 ADOPTED BUDGET Ii r-. THIS PAGE INTENTIONALLY LEFT BLANK-� II I! it 1 (Adopted November 15, 2011) Page 32 CITY OF GEM LAKE, MINNESOTA 2012 ADOPTED BUDGET SEWER OPERATING FUND REVENUE BUDGET ACCT. # ACCOUNT DESCRIPTION 2008 2009 2010 2011 ACTUAL ACTUAL ACTUAL ADOPTED 11/15/2011 ill 2012 _CTED ADOPTED o� CHANGE CHARGES FOR SERVCIES 34410 LOCAL SAC CHARGES 34500 SEWER REVENUES - RESIDENTIAL 34600 SEWER REVENUES - COMMERCIAL 34640 CERTIFIED SEWER REVENUES 34650 PENALTIES & INTEREST $668 12,076 37,882 0 80 $670 44,952 0 0 2,774 $671 9,392 30,667 0 2,188 $0 9,460 36,120 0 0 $0 9,632 34,400 0 2,631 $0 9,632 34,400 0 0 0.00% 1.82% -4.76% 0,00% 0.00% TOTAL CHARGES FOR SERVICES 50,707 48,396 42,918 45,580 46,663 44,032 -3,40% SPECIAL ASSESSMENTS 36101 SPECIAL ASSESSMENTS 36102 DELINQUENT SPECIAL ASSESSMENTS 36103 PENALTIES & INTEREST 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% 0.00% 0.00% TOTAL SPECIAL ASSESSMENTS $0 $0 $0 $0 $0 $0 0.00% MISCELLANEOUS 36200 MISCELLANEOUS 36210 INTEREST INCOME 39200 OPERATING TRANSFERS 0 3,331 25,000 0 3,883 125,000 0 4,391 0 0 3,159 0 0 3,810 0 0 3,420 0 0.00% 8.26% 0.00% TOTAL MISCELLANEOUS $28,331 $128,883 $4,391 $3,159 3,810 $3,420 8.26% TOTAL REVENUES $79,038 $177,279 $47,309 $48,739 $ 50,472 $47,452 -2.64% EXPENDITURE BUDGET SUPPLIES 201 OFFICE SUPPLIES 210 OPERATING SUPPLIES 212 POSTAGE 250 SALES TAX 104 0 143 0 427 0 113 0 0 0 202 0 500 0 175 0 300 0 200 0 500 0 200 0 0.00% 0.00% 14.29% 0.00% TOTAL SUPPLIES $247 $540 $202 $675 $500 $700 3.70% OTHER SERVICES & CHARGES 301 AUDITING & ACCOUNTING SERVICES 302 ENGINEERING FEES 318 M.C.E.S. CHARGES 319 LOCATES 329 FINANCIAL SERVICE 334 COMPUTER SERVICES 400 REPAIR/ MAINTENANCE 420 DEPRECIATION 433 DUES & SUBSCRIPTIONS 460 SEWER INSPECTIONS 461 SEWER FLUSHING 2,500 0 17,240 315 5,326 1,890 0 11,416 0 0 0 1,900 0 19,473 538 2,728 320 0 11,502 0 0 0 1,960 3,650 20,362 488 3,110 497 0 12,457 15,758 250 4,778 2,000 0 16,773 700 6,000 500 5,000 12,000 0 0 0 12,500 2,000 0 6,773 500 4,000 550 0 0 0 0 2,080 4,000 13,235 700 4,000 550 5,000 12,500 0 0 10,000 4.00% 0.00% -21.09% 0,00% -33.33% 10.00% 0.00% 4.17% 0.00% 0.00% 0.00% TOTAL OTHER SERVICES & CHARGES $38,686 $36,460 $63,309 $42,973 $ 6,323 $52,065 21,16% CAPITAL OUTLAY 540 HEAVY MACHINERY/EQUIPMENT 530 OTHER EQUIPMENT & IMPROVEMENTS 720 OPERATING TRANSFERS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00% 0.00% 0.00% TOTAL CAPITAL OUTLAY $0 $0 $0 $0 SOT0.00% TOTAL EXPENDITURE BUDGET $38,933 $37,000 $63,511 $43,648 $3 ,823 $52,765 20.89% FUND BALANCE - JANUARY 1 $149,520 $201,041 $306,148 $302,403 $31 ,494 $345,643 EXCESS REVENUE OVER EXPENDITURES DEDUCT INFRASTRUCTION ADDTIONS $40,105 $0 $140,279 ($46,674) ($16,201) $0 $5,091 $0 $10,649 $0 ($5,313) $0 ADD BACK DEPRECIATION $11,416 $11,502 $12,457 $12,000 $1 ,500 $12,500 FUND BALANCE - DECEMBER 31 $201,041 $306,148 $302,403 $319,494 $34 ,643 $352,830 10.43% ,023 $0 rnm $618,523 $0 tnm INVESTMENT IN INFRASTRUCTURE $531,723 $520,308 $555,479 $543,023 $53 ADDITIONS (DELETIONS) $0 $46,674 $0 $0 DEPRECIATION ($11,416) ($11,502) ($12.4571 ($12000) !R1 (Adopted November 15, 2011) Page 33 CITY OF GEM LAKE, MINNESOTA I 2012 ADOPTED BUDGET II THIS PAGE INTENTIONALLY LEFT BLANK, n n !I n (Adopted November 15, 2011) Page 34