The URL can be used to link to this page

Home My WebLink About10-110CITY OF LAKEVILLE RESOLUTION NO. 10 -110 RESOLUTION AMENDING THE 2010 BUDGETS BE IT RESOLVED that the 2010 General Fund, Communications Fund, Compensation Liability Fund, Environmental Resources Fund and Equipment Fund are hereby approved and amended for the fiscal year ending December 31, 2010 as per Exhibits A, B, C, D and E respectively as attached hereto. APPROVED this 20 day of December 2010. CITY OF LAKEVILLE ATTEST: i Charlene Friedges, City CI , rk i Exhibit A 2010 GENERAL FUND BUDGET Revenues General property taxes Licenses and permits Intergovernmental revenue Charges for services Court fines Investment income Miscellaneous Total revenues Expenditures Mayor and Council City administration City Clerk Legal Committees /Commissions Planning Community and economic development Inspection General government facilities Finance Information systems Human resources Insurance Police Fire Engineering Streets Parks Recreation Arts Center Other Total expenditures Other financing sources (uses) Transfers from other funds Transfers to other funds Total other financing sources (uses) Net change in fund balance Fund balance, January 1 Fund balance, December 31 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET - $16,117,882 902,341 - 902,341 1,070,554 33,432 1,103,986 1,298,419 3,562 1,301,981 273,055 - 273,055 104,096 - 104,096 96,769 5,145 101,914 19,863,116 42,139 19,905,255 110,726 - 110,726 313,502 9,784 323,286 167,664 - 167,664 65,132 - 65,132 79,254 11,024 90,278 431,982 (7,194) 424,788 274,817 5,684 280,501 891,468 (2,600) 888,868 534,008 - 534,008 555,084 - 555,084 454,341 - 454,341 293,923 8,250 302,173 278,698 - 278,698 8,362,945 21,593 8,384,538 1,371, 591 32,540 1,404,131 720,216 3,000 723,216 2,357,056 93,187 2,450,243 2,152,234 6,172 2,158,406 600,075 3,300 603,375 430,182 - 430,182 309,069 (309,069) - 20,753,967 (124,329) 20,629,638 668,238 (32,185) 636,053 (2,800,000) (185,791) (2,985,791) (2,131,762) (217,976) (2,349,738) (3,022,613) (51,508) (3,074,121) 9,714,615 1,492,110 11,206,725 $ 6,692,002 $ 1,440,602 $ 8,132,604 (continued) Exhibit A (font.) GENERAL FUND SCHEDULE OF REVENUES 2010 ADOPTED BUDGET Taxes Property taxes - current Property taxes - delinquent Fiscal disparities Penalties and interest Mobile home tax Mobile home tax credit Total Taxes Licenses and Permits Licenses Cigarette Trash removal Dog Signs On -sale liquor Sunday liquor Club special license Non - intoxicating liquor on Non - intoxicating liquor off Wine Tree removal Arcade (amusement device) Fireworks Massage Total Licenses 155,909 1,760,094 7,550 41,500 19,070 $ 16,800 $ 3,150 20,000 3,550 107,000 3,800 500 1,200 900 1,000 700 2,490 900 1,500 163,490 2010 AMENDED ADJUST BUDGET - $14,133,759 155,909 1,760,094 7,550 41,500 19,070 $16,117,882 $ 16,800 3,150 20,000 3,550 107,000 3,800 500 1,200 900 1,000 700 2,490 900 1,500 163,490 (continued) Exhibit A (font.) GENERAL FUND SCHEDULE OF REVENUES 2010 ADOPTED BUDGET Licenses and Permits (continued) Permits Plan review fees Building Plumbing Water and sewer Mechanical Grading /Filling Driveway Right of Way Fire burning Electrical Miscellaneous Total Permits Total Licenses and Permits $ 160,862 $ 384,840 55,671 9,174 43,257 250 600 18,000 550 65,347 300 738,851 2010 AMENDED ADJUST BUDGET $ 160,862 384,840 55,671 9,174 43,257 250 600 18,000 550 65,347 300 738,851 $ 902,341 $ - $ 902,341 Interaovernmental State -aid police State -aid fire relief State -aid streets State -aid pensions State POST Board grant State Drug Task Force grant State snowmobile trail maintenance grant Federal, State and County traffic safety grants Federal CDBG community development (Pioneer PI, Federal energy grant Dakota County Special Operations Training grant Dakota Communications Center rebate County recycling grant $ 335,887 $ - $ 335,887 190,209 6,015 196,224 374,962 374,962 21,303 21,303 19,864 19,864 12,000 12,000 200 200 2,100 19,446 21,546 5,000 5,534 10,534 1,600 1,600 2,437 2,437 65,529 65,529 41,900 - 41,900 Total Intergovernmental $ 1,070,554 $ 33,432 $ 1,103,986 (continued) Exhibit A(Cont.) GENERAL FUND SCHEDULE OF REVENUES (continued) 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET Charges for Services General Government Rezoning fees $ 750 $ - $ 750 Platting fees 1,850 1,850 Variance fees 750 750 CUP fees 2,400 2,400 Home occupation fees 450 450 Planner fees 32,001 32,001 Inspection fees 7,679 7,679 General government service charge 15,057 15,057 Tree escrow fund administration 8,000 8,000 Lodging tax fee 7,474 7,474 Fiscal Agent - Dakota Communication Center 59,400 59,400 Fiscal Agent - Ice arenas 16,000 16,000 Investment management fees 26,597 26,597 Sale of maps /copies 400 400 Sale of printed material 50 50 Finance charges 200 - 200 Total General Government 179,058 - 179,058 Public Safety Police department charges 70,122 262 70,384 SRO - ISD 194 contribution 150,804 150,804 Animal pickup 3,910 3,910 Animal storage 8,320 8,320 Animal rabies 2,540 2,540 Restitution 3,000 3,000 Forfeiture - sale of assets 5,000 5,000 Fire contracts 32,265 32,265 Fire department charges 1,750 1,750 ALF - Administrative charge 11,600 - 11,600 Total Public Safety 289,311 262 289,573 (continued) Exhibit A (Cons.) GENERAL FUND SCHEDULE OF REVENUES (continued) 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET Charges for Services (continued) Public Works Engineering platting - preliminary $ 1,500 $ - $ 1,500 Engineering platting -final 1,200 1,200 Engineering plan review fees 5,000 5,000 Engineering developer inspection fees 500 500 Engineering developer contract administration 6,000 6,000 Engineering improvement project design variable 81,900 81,900 Engineering improvement project const. inspection 102,200 102,200 Engineering G.I.S. fees 1,200 1,200 Special assessment admin charge 79,252 79,252 Special assessment searches 220 220 Document/map sales 910 910 Bid plans /specs deposits 1,500 1,500 Street department charges 4,530 4,530 Credit River - Judicial road maintenance 6,635 6,635 Developer street signs installation 7,000 - 7,000 Total Public Works 299,547 - 299,547 Parks and Recreation Recreation activities Brochure ad revenue 5,000 5,000 Youth activities 108,745 3,300 112,045 Youth sport surcharge 36,700 36,700 Youth special events 13,391 13,391 Youth special events donations 1,400 1,400 Adult activities 70,450 70,450 Puppet wagon donations 3,870 3,870 Safety Camp 3,000 3,000 Safety Camp donations 1,100 1,100 Senior Center donations 470 470 Senior Center excursion 20,000 20,000 Senior Center membership surcharge 4,010 4,010 Senior Center rental 440 440 Ritter Farm Park Environmental Learning Center 6,682 6,682 Excursions 7,920 7,920 Tennis lessons 12,582 - 12,582 Total recreation activities 295,760 3,300 299,060 (continued) Exhibit A(Cont.) GENERAL FUND SCHEDULE OF REVENUES 2010 ADOPTED BUDGET Charges for Services (continued) Parks and Recreation (continued) Park rental /maintenance /tournament fees Tree sales (net) Total Parks and Recreation Arts Center Program fees Facility rental /event admissions Total Arts Center Total Charges for Services Court Fines Investment Income Miscellaneous Sale of assets Park rental farming Berres Donations Antenna site leases Other 2010 AMENDED ADJUST BUDGET $ 29,903 $ - $ 29,903 4,500 - 4,500 330,163 3,300 333,463 73,500 73,500 126,840 - 126,840 200,340 - 200,340 $ 1,298,419 $ 3,562 $ 1,301,981 $ 273,055 $ - $ 273,055 5,145 $ 104,096 $ - $ 104,096 $ $ 2,939 $ 2,939 400 400 48,411 5,145 53,556 44,990 44,990 29 - 29 Total Miscellaneous $ 96,769 $ 5,145 $ 101,914 Total Revenues $ 42,139 $19,905,255 (continued) Exhibit A (Cont.) GENERAL FUND SCHEDULE OF REVENUES 2010 ADOPTED BUDGET 2010 AMENDED ADJUST BUDGET Transfers From other funds Communications Fund Environmental Resources Fund Storm Sewer Fund Liquor Fund Utility Fund (Water, Sanitary Sewer, Street Light) Municipal Reserves Fund $ 48,177 $ (6,108) $ 42,069 113,597 (2,281) 111,316 40,827 (3,674) 37,153 142,036 142,036 280,461 (20,122) 260,339 43,140 - 43,140 Total transfers from other funds $ 668,238 $ (32,185) $ 636,053 Transfers to other funds Debt Service Special Assessment Fund Pavement Management Fund Trail Improvement Fund Building Fund Equipment Fund $ (107,490) $ (107,490) (140,374) (140,374) (1,400,000) (1,400,000) (52,136) (52,136) (1,100,000) (185,791) (1,285,791) Total transfers to other funds $(2,800,000) $ (185,791) $(2,985,791 (continued) Exhibit A (Cont.) GENERAL FUND SCHEDULE OF EXPENDITURES Expenditures Mayor and Council Personnel services Commodities Other charges and services Total Committees /Commissions Personnel services Commodities Other charges and services Total City Administration Personnel services Commodities Other charges and services Total City Clerk Personnel services Commodities Other charges and services Capital outlay Total Legal Other charges and services Planning Personnel services Commodities Other charges and services Total 2010 346,826 2010 ADOPTED 50,391 - AMENDED BUDGET ADJUST BUDGET $ 50,224 $ - $ 50,224 50 50 60,452 - 60,452 110,726 - 110,726 40,441 9,659 50,100 908 1,199 2,107 37,905 166 38,071 79,254 11,024 90,278 297,465 7,444 304,909 850 850 15,187 2,340 17,527 313,502 9,784 323,286 105,056 105,056 1,700 1,700 60,458 60,458 450 - 450 167,664 - 167,664 65,132 - 65,132 354,020 (7,194) 346,826 27,571 27,571 50,391 - 50,391 431,982 (7,194) 424,788 (continued) Exhibit A (Cont.) GENERAL FUND SCHEDULE OF EXPENDITURES Expenditures Community and Economic Development Personnel services Commodities Other charges and services Total Inspection Personnel services Commodities Other charges and services Capital outlay Total General Government Facilities Personnel services Commodities Other charges and services Capital outlay Total Finance Personnel services Commodities Other charges and services Capital outlay Total Information Systems Personnel services Commodities Other charges and services Capital outlay Total 2010 200,567 2010 ADOPTED 287,263 AMENDED BUDGET ADJUST BUDGET $ 249,979 $ 150 $ 250,129 350 350 24,488 5,534 30,022 274,817 5,684 280,501 791,529 (2,600) 788,929 20,464 20,464 76,703 76,703 2,772 - 2,772 891,468 (2,600) 888,868 200,567 200,567 43,406 43,406 287,263 287,263 2,772 - 2,772 534,008 - 534,008 489,359 489,359 3,750 3,750 61,422 61,422 553 - 553 555,084 - 555,084 295,766 295,766 8,954 8,954 140,153 140,153 9,468 - 9,468 454,341 - 454,341 (continued) Exh !bit A (Cont.) GENERAL FUND SCHEDULE OF EXPENDITURES Expenditures Human Resources Personnel services Commodities Other charges and services Total Insurance Other charges and services Police Personnel services Commodities Other charges and services Capital outlay Total Fire Personnel services Commodities Other charges and services Total Engineering Personnel services Commodities Other charges and services Total Streets Personnel services Commodities Other charges and services Total 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET $ 245,336 $ - $ 245,336 2,010 2,010 46,577 8,250 54,827 293,923 8,250 302,173 278,698 - 278,698 6,223,339 15,306 6,238,645 347,810 347,810 1,782,485 6,287 1,788,772 9,311 - 9,311 8,362,945 21,593 8,384,538 940,534 3,765 944,299 143,324 21,290 164,614 287,733 7,485 295,218 1,371,591 32,540 1,404,131 647,833 1,500 649,333 15,292 15,292 57,091 1,500 58,591 720,216 3,000 723,216 1,429,994 87,982 1,517,976 681,945 681,945 245,117 5,205 250,322 2,357,056 93,187 2,450,243 (continued) Exh i bit A (Cont.) GENERAL FUND SCHEDULE OF EXPENDITURES Expenditures 2010 ADOPTED BUDGET ADJUST 2010 AMENDED BUDGET Parks Personnel services Commodities Other charges and services Total Recreation Personnel services Commodities Other charges and services Capital outlay Total Arts Center Personnel services Commodities Other charges and services Total Other Total Expenditures $ 1,494,618 $ 1,027 $ 1,495,645 270,730 270,730 386,886 5,145 392,031 2,152,234 6,172 2,158,406 325,814 325,814 25,700 25,700 246,479 3,300 249,779 2,082 - 2,082 600,075 3,300 603,375 215,803 215,803 23,425 23,425 190,954 - 190,954 430,182 - 430,182 309,069 (309,069) - $ (124,329) $20,629,638 (continued) Exhibit A (font.) 2010 GENERAL FUND BUDGET AMENDMENT NOTES (2) Increase Fire Department clothing budget for bunker gear. The 2009 Adopted Budget provided appropriations for this; however the gear was not received until 2010. Fire Clothing (Bunker Gear) $ 21,290 Decrease Fund Balance, December 31, 2010 $ (21,290) (3) Adjust the interdepartmental transfers representing actual share of City Hall overhead costs human resources and information systems support provided to the following funds: Reduce Transfer from Communications Fund $ (6,108) Reduce Transfer from Environmental Resources Fund (2,281) Reduce Transfer from Storm Sewer Trunk Fund (3,674) Reduce Transfer from Utility Fund (Water, Sanitary Sewer, Street Light Operatic (20,122) Decrease Fund Balance, December 31, 2010 $ (32,185) (continued) ADJUSTMENT (1) Transfer appropriations from Contingency and apply to the following Departments for unanticipated expenditures occurring in 2010. City Administration Increase professional services for an ICMA Consulting - HIPP Reset Project. $ 2,340 Committees /Commissions Adjust Pan- O -Prog expenses based on the 2010 actual for: Personnel services 5,563 Commodities 1,199 Other charges and services (96) Human Resources Fire Chief candidate assessments of replacing the Fire Chief in 2010. 8,250 Police City share of cost for professional services related to shooting range site clean -up 4,100 Remove the annual cost of pager rental for the Chaplain (250) Fire Emergency repairs to Ladder Truck L -4, Hydraulic System 7,485 Engineering Traffic control evaluation for the intersection of Flagstaff and 179th Street intersection conducted by SRF Consulting. 1,500 Streets December snow events plowing /snow removal overtime (incl. nenefits) 87,982 Plow truck repairs (2 differentials) 5,205 Decrease 2010 Contingency $ (123,278) (2) Increase Fire Department clothing budget for bunker gear. The 2009 Adopted Budget provided appropriations for this; however the gear was not received until 2010. Fire Clothing (Bunker Gear) $ 21,290 Decrease Fund Balance, December 31, 2010 $ (21,290) (3) Adjust the interdepartmental transfers representing actual share of City Hall overhead costs human resources and information systems support provided to the following funds: Reduce Transfer from Communications Fund $ (6,108) Reduce Transfer from Environmental Resources Fund (2,281) Reduce Transfer from Storm Sewer Trunk Fund (3,674) Reduce Transfer from Utility Fund (Water, Sanitary Sewer, Street Light Operatic (20,122) Decrease Fund Balance, December 31, 2010 $ (32,185) (continued) Exhibit A (Cont.) 2010 GENERAL FUND BUDGET AMENDMENT NOTES (5) Increase appropriations with offsetting revenues for various grants, charges ADJUSTMENT (4) Increase /(Decrease) personnel salary appropriations between departments to more accurately reflect estimated interdepartmental time charged by staff. Committees and Commissions $ 4,096 City Administration 7,444 Planning (7,194) Community and Economic Development 150 Inspections (2,600) Police (4,140) Fire (2,250) Engineering 1,500 Streets 1,967 Parks 1,027 Net $ - (5) Increase appropriations with offsetting revenues for various grants, charges for services, and donations collected in 2010. Revenues: Intergovernmental Revenue Federal CDA Grant - Pioneer Plaza $ 5,534 Federal Highway Enforcement of Aggressive Traffic (HEAT) Grant 19,446 Dakota County Police Special Operations Training Grant (Ft. McCoy) 2,437 State -aid Fire Relief 6,015 Charges for Services Pan -O -Prog Police Security Services (Babe's, VFW) 262 Recreation Youth Activities (Cheer America program - new) 3,300 Donations Lakeville Baseball Assn. Foxborough Park Fence Improvements 3,645 Lakeville Softball Assn. Aronson Park Fence Improvements 1,500 Total Revenues Increase 42,139 Expenditure Appropriations: Committees /Commissions (Pan -O -Prog) 262 Community and Econ. Development Prof. Services (Pioneer Plaza Study) 5,534 Police Personnel (Patrol Overtime Salaries - Grants) 19,446 Police Schools and Conferences (Special Operations Training Grant) 2,437 Fire Relief Association Payment 6,015 Parks ( Foxborough Park and Aronson Park Fence Improvements) 5,145 Recreation (Youth Activities Contractual Services) 3,300 Total Expenditures Increase 42,139 (continued) Exhibit A (Cont.) 2010 GENERAL FUND BUDGET AMENDMENT NOTES ADJUSTMENT (6) Transfer unappropriated Contingency to Equipment Fund as directed by City Council at November 22nd work session. Reduce Contingency $ (185,791) Transfer to Equipment Fund 185,791 Net $ - (7) Adjust the budgeted January 1, 2010 Fund Balance to reflect the actual December 31, 2009 Fund Balance carryforward. Actual Fund Balance, January 1, 2010 $11,206,725 Budgeted Fund Balance, January 1, 2010 9,714,615 Increase Fund Balance, January 1, 2010 $ 1,492,110 Exhibit B 2010 COMMUNICATIONS FUND BUDGET Revenues State -aid pensions Franchise fee Investment income Total Revenues Expenditures Personnel services Commodities Other charges and services Capital outlay Total Expenditures Transfers Transfer to General Fund Transfer to Compensation Liability Fund Total Transfers Net Change in Fund Balance Fund Balance, January 1 Fund Balance, December 31 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET $ 516 $ - $ 516 550,654 550,654 9,017 - 9,017 560,187 - 560,187 312,848 312,848 10,337 10,337 86,842 20,507 107,349 22,205 92,252 114,457 432,232 112,759 544,991 48,177 (6,108) 42,069 7,806 - 7,806 55,983 6,108 49,875 71,972 (106,651) (34,679) 552,039 165,881 717,920 $ 624,011 $ 59,230 $ 683,241 (continued) Exhibit B (Cont.) 2010 COMMUNICATIONS FUND BUDGET AMENDMENT NOTES ADJUSTMENT (1) Increase other charges and services for the following: 2010 Bi- annual community survey - Residential portion $ 15,500 Contract Data Processing - LOGIS 800 Cable TV BTTTF Consultant 4,207 Reduce Fund Balance, December 31, 2010 $ 20,507 (2) Increase capital outlay for Cable TV digital transition equipment. The 2009 Adopted Budget provided appropriations; however the purchases were not completed until 2010. Cable TV Capital Outlay $ 92,252 Reduce Fund Balance, December 31, 2010 $ 92,252 (3) Reduce transfer to General Fund representing the Communications Fund's actual share of City Hall overhead, human resources and information systems support. Reduce Transfer to General Fund $ 6,108 Increase Fund Balance, December 31, 2010 $ 6,108 (4) Increase the budgeted January 1, 2010 Fund Balance to reflect the actual December 31, 2009 Fund Balance carryforward. Actual Fund Balance, January 1, 2010 $ 717,920 Budgeted Fund Balance, January 1, 2010 552,039 Increase Fund Balance, December 31, 2010 $ 165,881 Exhibit C 20.10 COMPENSATION LIABILITY FUND BUDGET Revenues Investment income Expenditures - Personnel Services General government Public safety Public works Parks and recreation Total Expenditures Transfers Transfer from Communications Fund Transfer from Environmental Resources Fund Total Transfers Net Change in Fund Balance Fund Balance, January 1 Fund Balance, December 31 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET $ 9,200 $ 280 $ 8,920 10,673 10,341 21,014 6,833 55,541 62,374 2,498 1,182 3,680 - 4,468 4,468 20,004 71,532 91,536 7,806 7,806 766 - 766 8,572 - 8,572 (2,232) (71,812) (74,044) 899,434 9,920 889,514 $ 897,202 $ 81,732 $ 815,470 (continued) Exh i bit C (Cont.) 2010 COMPENSATION LIABILITY FUND BUDGET AMENDMENT NOTES (1) Decrease investment income to more accurately reflect 2010 market conditions. Estimated - Investment income Budget - Investment income Decrease Fund Balance, December 31, 2010 (2) Increase appropriations related to employee severance and other personnel compensation paid during 2010 including applicable benefits. Building Senior Administrative Assistant Police Sergeant Fire Chief Fire Office Supervisor Other personnel Decrease Fund Balance, December 31, 2010 ADJUSTMENT $ 8,920 9,200 $ 280 $ 3,131 Non -PTO 25,682 Non -PTO 27,471 PTO 602 Non -PTO 14,646 $ 71,532 (3) Decrease the budgeted January 1, 2010 Fund Balance to reflect the actual December 31, 2009 Fund Balance carryforward. Actual Fund Balance, January 1, 2010 $ 889,514 Budget Fund Balance, January 1, 2010 899,434 Decrease Fund Balance, December 31, 2010 i Exhibit D 2010 ENVIRONMENTAL RESOURCES FUND BUDGET Expenditures Personnel services 2010 2010 Commodities ADOPTED AMENDED Other charges and services BUDGET ADJUST BUDGET Revenues 3,002 - 3,002 Intergovernmental revenue 505,091 25,201 530,292 State -aid pensions $ 292 $ - $ 292 Dakota County Soil & Water Conservation grants - 25,201 25,201 Surface water fees 601,003 601,003 Investment income 6,316 - 6,316 Total Revenues 607,611 25,201 632,812 Expenditures Personnel services 190,107 190,107 Commodities 9,407 9,407 Other charges and services 302,575 25,201 327,776 Capital outlay 3,002 - 3,002 Total Expenditures 505,091 25,201 530,292 Transfers Transfer to General Fund 113,597 (2,281) 111,316 Transfer to Compensation Liability Fund 766 766 Transfer to Utility Fund Water Operation (Utility billing admin) 23,932 690 24,622 Sanitary Sewer Operation (Utility billing admin) 13,500 2,960 16,460 Sanitary Sewer Operation (vactor overhead) 2,271 - 2,271 Total Transfers 154,066 1,369 155,435 Net Change in Fund Balance (51,546) (1,369) (52,915) Fund Balance, January 1 497,048 30,065 527,113 Fund Balance, December 31 $ 445,502 $ 28,696 $ 474,198 (continued) Exhibit D (Cont.) 2010 ENVIRONMENTAL RESOURCES FUND BUDGET AMENDMENT NOTES ADJUSTMENT (1) Increase intergovernmental revenues for Dakota County Soil & Water Conservation District grants for rock cribs at the old public works facility ($9,176) and King Park Miracle Field storm pond construction ($16,025) with an offsetting increase in other charges for services. Revenue: Dakota County Soil & Water Conservation District grants $ 25,201 Expenditure: Increase Other Charges and Services (Construction) 25,201 Net $ - (2) Reduce transfer to General Fund representing the Surface Water Mgmt. Fund's actual share of City Hall overhead, human resources and information systems support. Reduce Transfer to General Fund $ 2,281 Increase Fund Balance, December 31, 2010 $ 2,281 (2) Increase transfer to Utility Fund (water and sanitary sewer operations) for the administrative costs for surface water fees share of customer utility billing administrative costs reimbursement. Transfer to Utility Fund Water Operation (Utility billing admin) $ 690 Sanitary Sewer Operation (Utility billing admin) 2,960 Reduce Fund Balance, December 31, 2010 (4) Increase the budgeted January 1, 2010 Fund Balance to reflect the actual December 31, 2009 Fund Balance carryforward. Actual Fund Balance, January 1, 2010 $ 527,113 Budgeted Fund Balance, January 1, 2010 497,048 Increase Fund Balance, December 31, 2010 $ 30,065 Exhibit E 2010 EQUIPMENT FUND BUDGET Revenues ALF Ambulance distribution Dakota Communications Center rebate Federal Police Byrne grant Miscellaneous Total Revenues Expenditures City Clerk Police Fire Streets Parks Total Expenditures Transfers Transfer from General Fund Transfer from Liquor Fund Total Transfers Net Increase /(Decrease) Fund Balance, January 1 Fund Balance, December 31 2010 2010 ADOPTED AMENDED BUDGET ADJUST BUDGET $ 117,032 $ - $ 117,032 131,058 131,058 - 21,576 21,576 10,500 - 10,500 258,590 21,576 280,166 1,422 1,422 190,838 21,576 212,414 386,908 79,624 466,532 102,457 102,457 29,363 - 29,363 710,988 101,200 812,188 1,100,000 185,791 1,285, 791 9,372 - 9,372 1,109,372 185,791 1,295,163 656,974 106,167 763,141 640,931 236,149 877,080 $ 1,297,905 $ 342,316 $ 1,640,221 (continued) Exhibit E (font.) 2010 EQUIPMENT FUND BUDGET AMENDMENT NOTES NOTES ADJUSTMENT (1) Increase intergovernmental revenues for a Federal (Police Byrne) grant to be used to acquire an unmarked squad car. Federal Police Byrne grant $ 21,576 Increase Capital Outlay (unmarked squad car) (21,576) Net $ - (2) Increase appropriations for a replacement Fire Department tender truck (chassis). This truck was budgeted in 2011; however the chassis will be built in 2010 and the truck body be built in 2011. The 2011 budget will be reduced accordingly. Fire Capital Outlay (tender truck chassis) $ 79,624 Decrease Fund Balance, December 31, 2010 $ 79,624 (3) Transfer from General Fund to Equipment Fund as directed by City Council at November 22nd work session. Transfer from General Fund $ 185,791 Increase Fund Balance, December 31, 2010 $ 185,791 (4) Adjust the budgeted January 1, 2010 Fund Balance to reflect the actual December 31, 2009 Fund Balance carryforward. Actual Fund Balance, January 1, 2010 $ 877,080 Budgeted Fund Balance, January 1, 2010 640,931 Increase Fund Balance, January 1, 2010 $ 236,149