Loading...
5.3.A. SR 11-08-2010Item # 5.3. of ~~ ^..- aver MEMORANDUM TO: Mayor and City Council FROM: Tim Simon, Finance Director DATE: November 8, 2010 SUBJECT: Enterprise Fund Budgets (Liquor and Wastewater) The 2011 budgets for the liquor and wastewater operations will be presented and discussed on Monday. The garbage fund budget will be presented at an upcoming meeting. Copies of the budgets and capital improvements for the next several years are attached for your review. Dave Potvin, liquor store manager, will be present to review the 2011 budget. In addition, we will review the cash flow analysis of the liquor fund for the next several years. As part of the budget process, staff has reviewed the customer user rates for wastewater. Staff is not recommending a utility rate change. Gary Leirmoe, chief operator, will be present to discuss the current year operating costs and the anticipated capital improvement projects in the next couple of years. In addition, we will review the cash flow analysis of the wastewater fund for the next several years. Final adoption of the budgets will be on the agenda in December. C:\Users\jmiller\AppData\Local\Microsoft\Windows\Temporary Internet Files\Low\Content.IES\68D8GBW0\enterprise%20budgets[1 ].doc WWTP 201 I Goals ^ Abandon River Line due to age, condition and location. ^ Jet and clean the western half of the City. ^ Maintain a high level of service and operations. 11-04-2010 10:41 AM 602-WASTEWATER TREATMENT SYS ' REVENUES CZTY OF ELK RIVER PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 3RD, 2010 (---------------- 2010 ---------------) (--------- 2011 ) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET wastewater Treatment Intergovernmental Rev Special Assessments 602-3-0000-3610 Special Assmts-County TOTAL Special Assessments Other Revenue 602-3-0000-3621 Interest Income 602-3-0000-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 602-3-0000-3721 Sewer Customer Charges 602-3-0000-3725 Sewer Connection Fee TOTAL Sales TOTAL wastewater Treatment TOTAL REVENUES 0 0 2,176 0 0 ( 1,179) 2,200 0 0 0 2,176 0 0 ( 1,179) 2,200 0 316,012 190,614 71,859 76,050 76,050 19,782 44,750 0 11,673 9,546 2,362 0 0 863 1,750 0 327,685 200,160 74,221 76,050 76,050 20,644 46,500 0 1,442,546 1,501,619 1,500,247 1,558,100 1,558,100 1,109,885 1,526,400 0 959,412 351,620 105,647 189,100 189,100 237,314 109,250 0 2,431,958 1,853,239 1,605,894 1,747,200 1,747,200 1,347,200 1,635,650 0 2, 759,643 2,053,399 1,682,291 1,823,250 1,823,250 1,366,664 1;654,350 0 2,759,643 2,053,399 1,682,291 1,823,250 1,823,250 1,366,664 1,684,350 0 11-04-2010 10:41 AM 602-WASTEWATER TREATMENT SYS WWTS Administration EXPENDITURES Personal Services 602-4-9010-4101 Regular Pay 602-4-9010-4104 PERA 602-4-9010-4105 FICA 602-4-9010-4106 Other Retirement Contributions 602-4-9010-4107 Medicare 602-4-9010-4108 Insurance 602-4-9010-4109 Workers Comp TOTAL Personal Services Supplies 602-4-9010-4201 Office Supplies TOTAL Supplies Other Services & Charges 602-4-9010-4301 Audit Fees 602-4-9010-4303 Engineering Fees 602-4-9010-4319 Other Professional Services 602-4-9010-4321 Telephone 602-4-9010-4322 Postage 602-4-9010-4331 Travel, Conferences & Schools 602-4-9010-4359 Publishing 602-4-9010-4404 Equip Repair/Maint Services 602-4-9010-4420 Depreciation 602-4-9010-4433 Dues & Subscriptions TOTAL Other Services & Charges Debt Service 602-4-9010-4601 Principal 602-4-9010-4611 Interest 602-4-9010-4621 Agent .Fees 602-4-9010-4631 Amortization Expense TOTAL Debt Service Transfers Out 602-4-9010-4721 Transfer-General Fund 602-4-9010-4730 Transfer-Debt Service TOTAL Transfers Out CITY OF ELK RIVER PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 3RD, 2010 ~-----------'---- 2010 ---------------) ~--------- 2011 --------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET 37,168 40,191 40,043 65,550 65,550 32,622 66,500 0 2,351 2,567 2,708 4,600 4,600 2,377 4,800 0 2,219 2,326 2,320 4,050 4,050 1,970 4,150 0 ( 1,245) 1,492 3,418 0 0 0 0 0 519 544 543 950 950 461 1,000 0 3.,880 3,654 3,840 8,200 8,200 3,280 8,600 0 5,150 4,157 4,174 5,300 5,300 6,047 6,050 0 50,042 54,930 57,046 88,650 88,650 46,757 91,100 0 1,279 1,313 831 3,050 3,050 1,032 1,800 0 1,279 1,313 831 3,050 3,050 1,032 1,800 0 4,485 3,600 4,320 4,450 4,450 4,440 4,600 0 10,216 15,921 7,095 26,250 26,250 711 25,000 0 6,975 2,190 2,549 52,800 52,800 3,430 2,800 0 2,273 3,468 3,306 3,200 3,200 3,186 3,400 0 167 145 255 500 500 60 500 0 1,682 1,927 850 2,250 2,250 1,338 2,250 0 340 0 0 300 300 0 300 0 1,601 1,360 1,755 1,400 1,400 1,133 1,500 0 852,651 835,424 833,135 914,000 914,000 0 993,600 0 0 682 200 350 350 200 400 0 880,390 867,716 853,468 1,005,500 1,005,500 14,497 1,034,350 0 0 0 0 160,000 160,000 160,000 160,000 0 54,188 49,851 45,019 42,000 42,000 23,424 36,700 0 403 403 403 450 450 403 0 0 2,624 2,624 2,624 0 0 0 0 0 57,214 52,877 48,046 202,450 202,450 183,826 196,700 0 20,000 41,000 50,000 50,000 50,000 50,000 75,000 0 15,000 15,000 _ 15,000 15,000 15,000 15,000 15,000 0 35,000 56,000 65,000 65,000 65,000 65,000 90,000 0 TOTAL WWTS Administration 1,023,925 1,032,836 1,024,391 1,364,650 1,364,650 311,112 1,413,950 0 11-04-2010 10:41 AM 602-WASTEWATER TREATMENT SYS WWTS Plant EXPENDITURES CITY OF ELK RIVER PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 3RD, 2010 ~----- - --- - - --- 2010 -- - - -----------)~---------- 2011 ----------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET Personal 5erv ices 602-4-9020-4101 Regular Pay 602-4-9020-4102 Overtime Pay 602-4-9020-4104 PERA 602-4-9020-4105 FICA 602-4-9020-4107 Medicare 602-4-902 D-4108 Insurance 602-4-9020-4109 Workers Comp TOTAL Personal Services Supplies 602-4-9020-4212 Fuels & Lubs 602-4-9020-4219 Operating Supplies 602-4-9020-4221 Equipment Parts TOTAL Supplies Other Services & Charges 602-4-9020-4361 Insurance 602-4-9020-4384 Waste Disposal 602-4-9020-4389 Utilities 602-4-9020-4404 Equip Repair/Maint Services 602-4-9020-4405 Cleaning Services 602-4-9020-4409 Contractual Services 602-4-9020-4417 Uniform Rental 602-4-9020-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 602-4-9020-4560 Equipment TOTAL Capital Outlay TOTAL WWTS Plant 171,041 185,310 172,285 163,900 163,900 148,549 166,200 0 13,930 12,769 11,720 10,000 10,000 9,998 12,000 0 11,480 11,748 12,241 12,200 12,200 11,619 12,900 0 11,133 11,828 10,636 10,800 10,800 9,791 11,050 0 2,604 2,766 2,488 2,500 2,500 2,290 2,600 0 20,082 22,472 21,458 20,500 20,500 19,827 21,500 0 293 2,853 257 0 0 0 0 0 230,562 249,746 231,084 219,900 219,900 202,073 226,250 0 1,738 1,948 2,843 3,000 3,000 1,447 3,000 0 48,859 30,329 34,101 68,400 68,400 23,830 88,400 0 19,912 16,125 17,234 22,000 22,000 10,102 20,000 0 70,509 48,402 54,178 93,400 93,400 35,379 111,400 0 9,666 9,115 9,099 9,000 9,000 4,913 10,600 0 4,906 16,430 11,967 10,000 10,000 9,393 10,000 0 116,673 113,657 139,070 122,600 122,600 102,232 122,600 0 25,204 20,879 15,671 16,000 24,000 17,151 28,000 0 609 915 374 0 0 0 0 0 26,690 76,989 32,767 48,000 48,000 41,951 48,000 0 2,583 3,177 3,650 3,500 3,500 3,131 4,000 0 6,060 6,105 5,983 6,500 6,500 6,116 7,100 0 192,390 247,267 218,581 215,600 223,600 184,886 230,300 0 0 0 0 18,000 18,000 23,796 0 0 0 0 0 18,000 18,000 23,796 0 0 493,462 545,415 503,843 546,900 554,900 446,135 567,950 0 11-04-2010 10:41 AM 602-WASTEWATER TREATMENT SYS wwTS Laboratory EXPENDITURES Personal Services 602-4-9030-4101 Regular Pay 602-4-9030-4102 Overtime Pay 602-4-9030-4104 PERA 602-4-9030-4105 FICA 602-4-9030-4107 Medicare 602-4-9030-4108 Insurance TOTAL Personal Services Supplies 602-4-9030-4219 Operating Supplies 602-4-9030-4221 Equipment Parts TOTAL Supplies Other Services & Charges 602-4-9030-4319 Other Professional Services 602-4-9030-4404 Equip Repair/Maint Services 602-4-9030-4437 Taxes & Licenses TOTAL Other Services & Charges Capital Outlay 602-4-9030-4560 Equipment TOTAL Capital Outlay TOTAL WWTS Laboratory CITY OF ELK RIVER PAGE: 4 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 3RD, 2010 ~---------------- 2010 --------------) ~--------- 2011 ---------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CZTY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET 33,903 33,368 33,101 39,350 39,350 27,164 39,900 0 3,877 3,487 1,783 4,200 4,200 2,028 4,000 0 2,355 2,348 2,349 3,050 3,050 2,116 3,200 0 2,270 2,146 2,027 2,700 2,700 1,799 2,700 0 531 502 474 650 650 421 650 0 4,265 3,922 3,789 _ 4,900 4,900 3,048 5,150 0 47,202 45,772 43,524 54,850 54,850 36,576 55,600 0 12,591 15,674 15,320 15,750 15,750 9,124 15,000 0 985 107 6,129 _ 6,OD0 6,000 954 4,000 0 13,576 15,781 21,450 21,750 21,750 10,078 19,000 0 8,144 7,217 8,090 8,000 8,000 4,377 9,000 0 640 210 500 1,000 1,000 330 1,000 0 3,200 0 3,300 4,500 4,500 0 6,000 0 11,984 7,427 11,890 13,500 13,500 4,707 16,000 0 0 0 0 11,000 3,000 0 0 0 0 0 0 11,000 3,000 0 0 0 72,762 68,951 76,864 101,100 93,100 51,361 90,600 0 11-04-2010 10:41 AM 602-WASTEWATER TREATMENT SYS Sewer Operations EXPENDITURES Personal Services 602-4-9040-4101 Regular Pay 602-4-9040-4102 Overtime Pay 602-4-9040-4104 PERA 602-4-9040-4105 FICA 602-4-9040-4107 Medicare 602-4-9040-4108 Insurance TOTAL Personal Services Supplies 602-4-9040-4212 Fuels & Lubs 602-4-9040-4219 operating Supplies 602-4-9040-4221 Equipment Parts TOTAL Supplies Other Services & Charges 602-4-9040-4404 Equip Repair/Maint Services TOTAL Other Services & Charges Capital Outlay 602-4-9040-4530 Improvement Project Contract TOTAL Capital Outlay CITY OF ELK RIVER PAGE: 5 PROPOSED BUDGET WORKSHEET AS OF : NOVEMBER 3RD, 2010 ( --------------- 2010 --- ---'------) t-------- 2011 ----------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CSTY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET 18,743 16,326 19,806 29,500 29,500 27,132 29,900 0 520 1,579 228 500 500 129 500 0 1,198 1,148 1,353 2,100 2,100 1,918 2,20D 0 1,159 1,077 1,190 1,850 1,850 1,621 1,900 0 271 252 278 450 450 379 450 0 2,326 2,357 2,459 3,700 3,700 3,752 3,850 0 24,218 22,739 25,313 38,100 38,100 34,931 38,800 0 3,747 4,757 4,337 5,000 5,000 3,772 3,000 0 2,362 3,078 4,762 3,200 3,200 1,536 3,200 0 9,074 9,754 4,885 8, D00 8,000 2,072 8,000 _ 0 15,182 17,588 13,984 16,200 16,200 7,380 14,200 0 14,620 23,127 16,978 17,000 17,000 8,146 17,000 0 14,620 23,127 16,978 17,000 17,000 8,146 17,000 0 0 0 0 0 0 0 500,000 0 0 0 0 0 0 0 500, 000 0 TOTAL Sewer Operations 54,020 63,454 56,275 71,300 71,300 50,457 570,000 0 ~ 11-04-2010 10:41 AM I 602-WASTEWATER TREATMENT SYS Lift Stations I EXPENDITURES CITY OF ELK RIVER PAGE: 6 PROPOSED BUDGET WORKSHEET AS OF: NOVEMBER 3RD, 2010 ~-------------- 2010 - -----) t------ 2011 ---------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET Personal Services 602-4-9050-4101 Regular Pay 602-4-9050-4102 Overtime Pay 602-4-9050-4104 PERA 602-4-9050-4105 FICA 602-4-9050-4107 Medicare 602-4-9050-4108 Insurance TOTAL Personal Services Supplies 602-4-9050-4212 Fue 1s & Lubs 602-4-9050-4219 Operating Supplies 602-4-9050-4221 Equipment Parts TOTAL Supplies Other Services & Charges 602-4-9050-4321 Telephone 602-4-9050-4389 Utilities 602-4-9050-4404 Equip Repair/Maint Services TOTAL Other Services & Charges TOTAL Lift Stations 32,480 33,929 32,487 29,500 29,500 29,693 29,900 0 2,819 2,057 649 4,900 4,900 1,809 2,500 0 2,178 2,553 2,205 2,400 2,400 2,285 2,350 0 2,099 2,123 1,900 2,150 2,150 1,942 2,000 0 491 496 444 500 500 454 800 0 3,846 3,636 4,043 3,700 3,700 3,498 3,850 0 43,913 44,794 41,729 43,150 43,150 39,681 41,100 0 2,484 2,511 1,605 3,000 3,000 1;574 3,000 0 25,895 4,284 2,072 5,000 5,000 353 3,000 0 6,477_ 5,326 6,784 6,200 6,200 1,607 6,000 0 34,856 12,121 10,460 14,200 14,200 3,534 12,000 0 727 443 138 800 800 0 800 0 35,888 43,879 44,321 46,000 46,000 32,771 46,000 0 _ 64,638 90,780 91,407 54,000 54,000 __31,883 132,200 0 100,953 135,103 135,867 100,800 100,800 64,654 179,000 0 179,722 192,018 188,056 158,150 158,150 107,869 232,100 0 I TOTAL EXPENDITURES REVENUE OVER/(UNDER) EXPENDITURES 1,823,891 1,902,704 1,849,428 2,242,100 2,242,100 966,934 2,874,600 0 935,753 150,695 ( 167,137) ( 418,850) ( 418,850) 399,731 ( 1,190,250) 0 Capital Improvement Plan 2011 rhru 2015 Department Sewer Department City of Elk River, Minnesota Contact Chief Wastewater Operator Type Improvement Project # WW-02 Useful Life IS years Project Name Lift Station Rehabilitation ~ Category Utilities Priority n/a Description ?011 Replace control panels at Hwy 10 & Simonet Lift Stations. ?014 Rehab oldest lift stations this is a ongoing maintenance item. Justification Expenditures 2011 2012 2013 2014 2015 Total Construction/Maintenance 79,000 60,000 139,000 Total 79,000 60,000 139,000 Funding Sources 2011 2012 2013 2014 2015 Total Sewer Fund 79,000 60,000 139,000 Total 79,000 60,000 139,000 2011-1015C~1P/TAL IMPROVEMENT PLAN Page 1 Capital Improvement Plan 2011 rhru 2015 Department Sewer Department City of Elk River, Minnesota contact Chief Wastewater Operator Type Equipment ' Project # WW-03 Useful Life ]0 years ', Project Name .TetNaCUUm tl'UCIC '~ Category Heavy Equipment __ Priority n/a Description Zeplace the current JetNac truck for the sewer division Justification In 2013 the sewer divisions jet/vac truck will be 10 years old and have reached its planned replacement age. Given the miles of sewer lines that need to be cleaned each year it is important to have dependable equipment for the sewer division to perform one of its key functions. Expenditures 2011 2012 2013 2014 2015 Total Equipment 400,000 400,000 Total Funding Sources 2011 aoo,ooo 2012 2013 2014 aoo,ooo 2015 Total Sewer Fund 400,000 400,000 Total 400,000 400,000 20] 1-2015 CAP/TAL IMPROVEMENT PLAN Page 2 Capital Improvement Plan 2011 thru 2015 Department Sewer Department City of Elk River, Minnesota Contact Chief Wastewater Operator _- _ _ ___ Type Building ', Project # Ww-QS Useful Life 20 years Project Name $u1~dingS ' Category Buildings __ _ __ _, Priority n/a Description ~ 2015 -Storage building and lab expansion Justification Expenditures 2011 2012 2013 2014 2015 Total Buildings 200,000 200,000 Total Funding Sources 2011 200,000 2012 2013 2014 2015 200,000 Total Sewer Fund 200,000 200,000 Total 200,000 200,000 201 /-20/5 CAP77AL IMPROVEMENT PLAN Page 3 Capital Improvement Plan City of Elk River, Minnesota Project # ww-0( ', Project !name Vehicle Replacement Description 2012 - 1998 pickup replacement 2014 - 1-ton with hoist replacement 2011 thru 2015 Department Contact __ ___ Type Useful Life Category Priority Sewer Department Chief Wastewater Operator Vehicle 10 years Vehicles n/a Justification annual replacement of vehicles after approximately 10 years and is adjusted based on maintenance costs and condition ~f vehicles. Expenditures 2011 2012 2013 2014 2015 Total Vehicles 30,000 70,000 100,000 Total Funding Sources 2011 30,000 2012 2013 70,000 2014 2015 100,000 Total Sewer Fund 30,000 70,000 100,000 Total 30,000 70,000 700,000 2011-20/S CAP/T,9L IMPROf~ENfENT PLAN Page a Capital Improvement Plan 2011 rhru 2015 Department Sewer Department City of Elk River, M1I]IleSOta Contact Chief Wastewater Operator __ Project # wW-J<4 Type Equipment Useful Life 15 years Project Name Upgrade Boiler category Equipment Priority n/a Description Replace current boiler for primary digester Justification Expenditures 2011 2012 2013 2014 2015 Total Equipment 125,000 125,000 Total Funding Sources 2011 125,000 2012 2013 2014 2015 125,000 Total Sewer Fund 125,000 125,000 Total 125,000 125,000 2011-~0I5 CAY/T,4G Iti1PROl~E'.~LIENT PLAN Page 5 Capital Improvement Plan 2011 thru 2015 Department Sewer Department City of Elk River, Minnesota Contact Chief Wastewater Operator __ ___. Type Equipment Project # ww-19 II Useful Life 15 years Project Name Upgrade TF, Controls & Pumps Category Equipment Priority n/a Description Jpgrade from 1.6 to 2.2 mgd. Justification Expenditures 2011 2012 2013 2014 2015 Total Equipment 150,000 150,000 Total 150,000 150,000 Funding Sources 2011 2012 2013 2014 2015 Total Sewer Fund 150,000 150,000 Total 150,000 150,000 201 /-1015 CAP/"f.~iL 1~'LGPROt~E.tilEN7'PLAN Page 6 Capital Improvement Plan 2011 thru 2015 Department Sewer Department City of Elk River, M1nrieSOta Contact Engineer Type Unassigned Project # WW-22 ', Useful Life 20 years Project Name RIVeI'L.lnO abandonment lillpl@Illeritatlon ~' Category Unassigned __ __ ___ __ Priority n/a Description ~ Implementation of the abandonment of the river sewer line including potential lift station, sewer mainline and home service construction Justification ~ Che river sewer line is one of the oldest in the City system. It is in very poor condition and portions of it are inaccessible for proper repairs and maintenance. Expenditures 2011 2012 2013 2014 2015 Total Construction/Maintenance 500,000 500,000 Total 500,000 500,000 Funding Sources 2011 2012 2013 2014 2015 Total Sewer Fund 500,000 500,000 Total 500,000 500,000 201 /-20/5 CAPITAL IMPROl~EMENT PGAN Page 7 Capital Improvement Plan 2011 rhru 2015 Department Sewer Department City of Elk River, Minnesota Contact Engineer Type Improvement Project # WW-24 Useful Life 25 years Project ;name Bio solids disposal handling Category Unassigned Priority n/a Implementation of improvements at the WWTP to change the sludge (Bio Solids) handling as the sewage flow grows. Justification ~ Che current method of sludge (Bio Solid) storage and land application on 150 acres of City owned property will not be ;conomically feasible long term as the WWTP flow grows from 1.2 MGD currently to 3.6 MGD ultimate capacity. Expenditures 2011 2012 2013 2014 2015 Total ConstructionlMaintenance 2,000,000 2,000,000 Total 2,000,000 2,000,000 Funding Sources 2011 2012 2013 2014 2015 Total Sewer Fund 2,000,000 2,000,000 Total z,ooo,ooo z,ooo,ooo 201 l-20/S CAP/TAL Ih1PROVEMENT PLAN Page A Capital Improvement Plan 2011 rhru 2015 Department Sewer Department City of Elk River, M1YlYleSOta Contact Chief Wastewater Operator ---- ---- ', Project # ww-2$ ' Type Technology Useful Life ]0 years Project Name SCADA System Category Technology/Communiciations Priority n/a Description Zemote monitoring of lift stations throughout the City sewer system. Justification Che SCADA system will allow for reporting of alarms quicker and quicker response time. The system will be tied in Nith the different alarms systems at the treatment plant. The current system is monitoring 64 alarms and starting to neet capacity. Expenditures 2011 2012 2013 2014 2015 Total Software/Hardware 450,000 450,000 Total Funding Sources 2011 450,000 2012 2013 2014 2015 450,000 Total Sewer Fund 450,000 450,000 Total 450,000 450,000 2011-2015 CAP/T,9/, IMPROVE.~If;'NT PLAN Page 9 Liquor 201 I Goals ^ Regain market share lost to new competition and reach total sales of $6,200,000. ^ Become known as a destination for Micro and Craft beers. ^ Start on-line server training fox new employees and pass all compliance checks. 11-04-2010 10:46 AM 603-LIQUOR REVENUES CITY OF ELK RIVER PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: OCTOBER 31ST, 2010 (----------------- 2010 ----------------) (------- 2011 -------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET Liquor Other Revenue 603-3-0000-3621 Interest Income TOTAL Other Revenue TOTAL Liquor Northbound Liquor ----------------- ----------------- Other Revenue 603-3-9110-3625 Refunds & Reimbursements 603-3-9110-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 603-3-9110-3781 Liquor 603-3-9110-3782 Beer 603-3-9110-3783 Wine 603-3-9110-3784 Taxable Mdse Sales 603-3-9110-3785 Non-Taxable Mdse Sales 603-3-9110-3786 Bottle Deposits 603-3-9110-3791 ATM Revenue 603-3-9110-3792 Cash Over TOTAL sales TOTAL Northbound Liquor Westbound Liquor ---------------- ---------------- Other Revenue 603-3-9150-3625 Refunds & Reimbursements 603-3-9150-3629 Miscellaneous Revenue TOTAL Other Revenue Sales 603-3-9150-3781 Liquor 603-3-9150-3782 Beer 603-3-9150-3783 Wine 603-3-9150-3784 Taxable Mdse Sales 603-3-9150-3785 Non-Taxable Mdse Sales 133,166 _125,346 __68,932 83,900 83,900 17,354 63,100 0 133,166 125,346 68,932 83,900 83,900 17,354 63,100 0 133,166 125,346 68,932 83,900 53,900 17,354 63,100 0 0 1, 830 0 0 0 0 1,198 43 198 2,000 2,000 121 2,000 1,198 43 2,028 2,000 2,000 121 2,000 1,352,993 1,373,003 1,350,093 1,380,800 1,380,800 1,030,086 1,344,000 1,939,066 1,957,159 1,901,786 1,984,900 1,984,900 1,485,902 1,932,000 768,647 766,350 749,328 776,700 776,700 554,204 756,000 99,950 99,253 96,997 129,450 129,450 74,245 126,000 77,313 77,831 60,351 43,150 43,150 40,482 42,000 199 ( 169) ( 211) 0 0 305 0 971 988 910 1,000 1,000 687 1,000 5 53 0 0 ___ 0 426 _ 0 4,239,144 4,274,468 4,159,254 4,316,000 4,316,000 3,186,336 4,201,000 4,240,342 4,274,511 4,161,281 4,318,000 4,318,000 3,186,457 4,203,000 0 0 11, 256 D 0 0 0 3,335 2,325 2,593 1,500 1,500 1,878 1,500 3,335 2,325 13,849 1,500 1,500 1,878 1,500 533,799 579,715 572,155 594,000 594,000 448,646 594,000 593,220 942,092 922,078 970,200 970,200 787,518 950,400 285,773 327,284 339,917 336,600 336,600 254,425 356,400 46,433 46,655 47,066 59,400 59,400 37,480 59,400 39,362 40,000 36,915 19,800 19,800 29,918 19,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11-04-2010 10:46 AM CZTY OF ELK RIVER PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: OCTOBER 31ST, 2010 603-LIQUOR REVENUES 603-3-9150-3786 Bottle Deposits 603-3-9150-3791 ATM Revenue 603-3-9150-3792 Cash Over TOTAL Sales TOTAL westbound Liquor ( -------------- -- 2010 ---- -----------)( ---- ---- 2011 ----------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMZN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET 1 150 ( 230) 0 0 ( 160) 0 0 823 925 1,026 1,500 1,500 696 1,500 0 0 0 0 0 0 354 0 0 1,799,411 1,936,821 1,918,928 1,981,500 1,981,500 1,558,876 1,981,500 0 1,802,746 1,939,146 1,932,777 1,983,000 1,983,000 1,560,754 1,983,000 0 I TOTAL REVENUES 6,176,255 6,339,003 6,162,990 6,384,900 6,384,900 4,764,566 6,249,100 0 11-04-2010 10:46 AM 603-LIQUOR Northbound-Cost of Sales EXPENDITURES CITY OF ELK RIVER PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: OCTOBER 31ST, 2010 (- 2010 ---------------) ~------- 2011 ----------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET Supplies 603-4-9111-4251 Liquor 927,271 948,583 926,524 966,550 966,550 714,332 927,350 0 603-4-9111-4252 Beer 1,460,372 1,482,052 1,447,702 1,508,550 1,508,550 1,081,071 1,487,650 0 603-4-9111-4253 Wine 514,569 512,274 504,361 520,400 520,400 369,452 506,500 0 603-4-9111-4255 Soft Drinks/Misc 105,887 112,792 88,158 _ 112,200 112,200 57,068 109,200 0 TOTAL Supplies 3,008,098 3,055,701 2,966,745 3,107,700 3,107,700 2,221,923 3,030,700 0 Other Services & Charges 603-4-9111-4332 Freight 19,948 20,700 20,019 27,000 27,000 15,069 25,000 _ 0 TOTAL Other Services & Charges 19,948 20,700 20,019 27,000 27,000 15,069 25,000 0 TOTAL Northbound-Cost of Sales 3,028,046 3,076,401 2,986,765 3,134,700 3,134,700 2,236,992 3,055,700 0 11-04-2010 10:46 AM 603-LIQUOR Northbound-Operations EXPENDITURES CITY PROPOSED AS OF: 007 ACTUAL OF ELK RIVER BUDGET WORKSHEET OCTOBER 31ST, 008 ACTUAL 2010 ~ 2009 ACTUAL - APPROVED BUDGET 010 ------ CURRENT BUDGET --------) t Y-T-D ACTUAL PAGE: 4 -------- 2011 REQUESTED BUDGET --------) CITY ADMIN BUDGET Personal Services 603-4-9112-4101 Regular Pay 148,136 178,682 188,583 190,600 190,600 177,568 187,600 0 603-4-9112-4102 Overtime Pay 5,832 605 641 0 0 190 0 0 603-4-9112-4103 Part-time Pay 117,257 93,736 87,935 106,800 106,800 68,766 106,800 0 603-4-9112-4104 PERA 16,155 17,509 18,350 20,800 20,800 16,447 23,950 0 603-4-9112-4105 FICA 16,362 16,248 16,511 18,450 18,450 15,248 20,500 0 603-4-9112-4106 Other Retirement Contributions 964 25,105 ( 72) 0 0 0 0 0 603-4-9112-4107 Medicare 3,827 3,800 3,862 4,300 4,300 3,566 4,800 0 603-4-9112-4108 Insurance 13,176 18,557 19,444 20,600 20,600 23,144 27,200 0 603-4-9112-4109 Workers Comp 2,719 3,144 3,541 3,850 3,850 4,194 4,650 0 603-4-9112-4110 Re-employment Compensation 0 0 71 0 0 0 0 0 TOTAL Personal Services 324,429 357,387 338,866 365,400 365,400 309,123 375, 500 0 Supplies 603-4-9112-4212 Fuels & Lubs 284 262 181 300 300 148 300 0 603-4-9112-4217 Uniform Allowance 1,185 587 73 1,000 1,000 520 1,000 0 603-4-9112-4219 Operating Supplies 5,937_ 12,132 5,748 13,700 13,700 12,408 10,000 0 TOTAL Supplies 7,406 12,981 6,003 15,000 15,000 13,076 11,300 0 Other Services & Charges 603-4-9112-4301 Audit Fees 2,990 2,400 2,880 3,000 3,000 2,960 3,050 0 603-4-9112-4319 Other Professional Services 0 0 0 0 0 747 0 0 603-4-9112-4321 Telephone 2,572 2,529 2,412 2,500 2,500 2,095 2,500 0 603-4-9112-4322 Postage 0 5 0 0 0 0 0 0 603-4-9112-4331 Travel, Conferences & Schools 277 66 45 500 500 21 500 0 603-4-9112-4349 Advertising/Marketing 15,086 15,366 14,509 17,000 17,000 4,528 8,000 0 603-4-9112-4361 Insurance 12,154 12,912 12,133 12,800 12,600 6,090 12,900 0 603-4-9112-4389 Utilities 28,429 31,306 31,223 30,000 30,000 24,449 30,000 0 603-4-9112-4404 Equip Repair/Maint Services 13,309 8,228 22,990 21,000 21,000 6,278 21,400 0 603-4-9112-4405 Cleaning Services 447 543 544 2,000 2,000 273 3,000 0 603-4-9112-4420 Depreciation 58,496 46,198 46,731 45,850 45,850 0 47,350 0 603-4-9112-4431 Cash Short 0 0 275 0 0 366 0 0 603-4-9112-4433 Dues & Subscriptions 1,608 2,475 3,630 2,400 2,400 3,545 3,500 0 603-4-9112-4437 Taxes & Licenses 749 178 384 300 300 ( 57,356) 400 0 603-4-9112-4438 Credit Card Fees 56,072 59,484 58,879 62,000 62,000 44,864 62,000 0 603-4-9112-4440 Miscellaneous 2,411 1,843 1,196 1,000 1,000 42 0 0 TOTAL Other Services & Charges 194,601 183,533 197,831 200,350 200,350 38,900 194,600 0 Capital Outlay 603-4-9112-4560 Equipment 0 0 0 0 0 0 15,000 0 TOTAL Capital Outlay 0 0 0 0 0 0 15,000 0 Transfers Out 603-4-9112-4720 Transfers 9,500 207,248 113,600 90,250 90,250 92,815 90,000 0 603-4-9112-4721 Transfer-General Fund 219,900 226,000 248,600 248,600 248,600 248,600 270,000 0 603-4-9112-4730 Transfer-Debt Service 38,300 _ 38,300 38,300 0 0 0 0 0 TOTAL Transfers Out 267,700 471,548 400,500 338,850 338,850 341,415 360,000 0 11-04-2010 10:46 AM 603-LIQUOR Northbound-Operations EXPENDITURES TOTAL Northbound-Operations CITY OF ELK RIVER PAGE: 5 PROPOSED BUDGET WORKSHEET AS OF: OCTOBER 31ST, 2010 { - - ----------- -- 2010 ----- ------------) {--- - ----- 2011 -- - - - ---) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET 794,136 1,025,448 943,200 919,600 919,600 702,515 956,400 0 11-04-2010 10:46 AM CITY OF ELK RIVER PAGE: 6 PROPOSED BUDGET WORKSHEET AS OF: OCTOBER 31ST, 2010 603-LIQUOR westbound-Cost of Sales (- ---------------- 2010 --- - ------------)1---------- 2011 - - - - ---) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN EXPENDITURES ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET Supplies 603-4-9151-4251 Liquor 357,357 378,031 382,634 415,800 415,800 308,513 409,850 0 603-4-9151-4252 Beer 678,389 697,044 705,211 737,350 737,350 567,098 731,800 0 603-4-9151-4253 Wine 188,170 211,085 223,734 225,500 225,500 173,471 238,800 0 603-4-9151-4255 Soft Drinks/Misc 58,216 49,240 46,403 51,500 51,500 47,509 51,500 0 TOTAL Supplies 1,282,131 1,335,399 1,357,983 1,430,150 1,430,150 1,096,592 1,431,950 0 Other Services & Charges 603-4-9151-4332 Freight 8,127 9,264 9,850 _ 12,000 12,000 7, OS1 _ 11,000 0 TOTAL Other Services & Charges 8,127 9,264 9,850 12,000 12,000 7,081 11,000 0 TOTAL Westbound-Cost of Sales 1,290,258 1,344,663 1,367,832 1,442,150 1,442,150 1,103,673 1,442,950 0 11-04-2010 10:46 AM 603-LIQUOR westbound-Operations EXPENDITURES CITY OF ELK RIVER PAGE: 7 PROPOSED BUDGET WORKSHEET AS OF: OCTOBER 31ST, 2010 (- ---- 2010 ---------------) (--------- 2011 --------) 2007 2008 2009 APPROVED CURRENT Y-T-D REQUESTED CITY ADMIN ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET PerSOnal SerV1C2S 603-4-9152-4101 Regular Pay 603-4-9152-4102 Overtime Pay 603-4-9152-4103 Part-time Pay 603-4-9152-4104 PERA 603-4-9152-4105 FICA 603-4-9152-4106 Other Retirement Contributions 603-4-9152-4107 Medicare 603-4-9152-4108 Insurance 603-4-9152-4109 Workers Comp 603-4-9152-4110 Re-employment Compensation TOTAL Personal Services Supplies 603-4-9152-4212 Fuels & Lubs 603-4-9152-4217 Uniform Allowance 603-4-9152-4219 Operating Supplies TOTAL Supplies Other Services & Charges 603-4-9152-4301 Audit Fees 603-4-9152-4319 Other Professional Services 603-4-9152-4321 Telephone 603-4-9152-4331 Travel, Conferences & Schools 603-4-9152-4349 Advertising/Marketing 603-4-9152-4361 Insurance 603-4-9152-4389 Utilities 603-4-9152-4404 Equip Repair/Maint Services 603-4-9152-4405 Cleaning Services 603-4-9152-4420 Depreciation 603-4-9152-4431 Cash Short 6D3-4-9152-4433 Dues & Subscriptions 603-4-9152-4437 Taxes & Licenses 603-4-9152-4438 Credit Card Fees 603-4-9152-4440 Miscellaneous TOTAL Other Services & Charges Debt Service 603-4-9152-4601 Principal 6D3-4-9152-4611 Interest 603-4-9152-4631 Amortization Expense TOTAL Debt Service TOTAL westbound-Operations TOTAL EXPENDITURES REVENUE OVER/(UNDER) EXPENDITURES 134,207 141,687 142,756 142,900 142,900 78,113 75,300 0 0 0 0 0 0 209 0 0 57,075 56,347 61,163 SS,000 58,000 59,547 73,100 0 11,586 12,704 13,700 14,050 14,050 10,120 9,900 0 11,237 11,268 11,609 12,450 12,450 5,613 8,450 0 1,029 14,591 501 0 0 0 0 0 2,628 2;635 2,715 2,900 2,900 2,014 2,000 0 19,799 20,821 21,865 22,900 22,900 12,250 15,600 0 1,906 2,249 2,575 2,650 2,650 2,675 3,150 0 0 0 8 0 0 229 0 0 239,467 262,302 256,892 255,850 255,850 173,770 190,500 0 284 261 181 300 300 163 300 0 1,128 587 0 1,000 1,000 565 1,000 0 4,292 6,825 7,570 9,200 9,200 8,137 8,000 0 5,704 7,672 7,752 10,500 10,500 8,868 9,300 0 2,990 2,400 2,880 3,000 3,000 2,960 3,050 0 0 0 0 0 0 2, 000 0 0 2,587 2,688 2,612 2,600 2,600 2,240 2,600 0 71 30 44 500 500 13 500 0 12,775 15,439 14,493 17,000 17,000 3,927 8,000 0 7,923 8,005 7,769 8,150 8,150 2,834 8,400 0 22,946 25,408 25,544 25,000 25,000 20,194 25,000 0 5,365 5,216 4,656 7,000 7,000 3,646 7,500 0 0 0 0 500 500 0 1,250 0 79,290 79,290 79,660 75,400 75,400 0 75,800 0 44 86 19 0 0 360 0 0 1,325 1,350 1,992 1,200 1,200 2,044 1,800 0 170 177 170 300 300 ( 26,018) 400 0 23,655 26,167 27,705 30,000 30,000 23,486 30,000 0 606 843 513 1,000 1,000 6 0 0 159,746 167,099 168,056 171,650 171,650 37,692 164,300 0 0 0 0 100,000 100,000 100,000 150,000 0 51,938 48,656 44,457 41,850 41,850 23,475 36,250 0 414 414 414 0 0 0 0 0 52,352 49,070 44,871 141,850 141,850 123,475 186,250 0 457,269 486,143 477,570 579,850 579,850 343,804 550,350 0 5,569,710 5,932,655 5,775,368 6,076,300 6,076,300 4,386,984 6,005,400 0 606,545 406,348 387,622 308,600 308,600 377,582 243,700 0 !f Capital Improvement Plan 2011 rhrtl 2015 pepartment Liquor Fund City of Elk River, Minnesota Contact Liquor Store Manager __ _ _ _ Type Maintenance 'Project # )(s-O1< ' Useful Life 10 years Project Name Northbound Building Maintenance ' Category Building Maintenance -- ___ Priority n/a Description ~ Remodel Office - 2011 Rooftop 1-NAC - 2012 Refrigeration - 2012 Walkin Cooler display doors - 2012 Justification ~ The remodel and repairs are the original items from when the store opened in 1997. Due to normal course of use and life of the equipment it is critical to replace and remodel in a timely manner. Expenditures 2011 2012 2013 2014 2015 Total Equipment Building Maintenance 15,000 67,000 67,000 15,000 Total Funding Sources 15,000 2011 67,000 2012 2013 82,000 2014 2015 Total Liquor Fund 15,000 67,000 82,000 Total 15,000 67,000 82,000 2011-2015 CAPITAL /MPROl~EMENT PLAN Page 1