Loading...
2018 Adopted Budget2018 udget Safe Vibrant Friendly Stable December 11, 2017 City Council Meeting This page intentionally left blank TABLE OF CONTENTS Summary Elected & Appointed Officials…...…………….……….…………………...………….………………………….…1 Tax Levies……………………………..…………….…………………...………….………………………….…3 Consolidated Budgets Summary - All Funds…………….…………………...………….………………………4 General Fund Revenues & Expenditures……..…………………………….....……………………..……………6 General Fund Revenue…..………………………………….…..…….…….……...…....………………………8 General Fund Expenditure….………………………………….…..…….…….……...…....……………………..…12 General Fund General Government: City Council…………………………………………………………….…………..…………………………..…..13 City Management…………………….…………..……………..………..……………..…..………….….………14 General Management…………………….…………..……………..………..……………..…..………….….…15 Human Resources……………………………………………………………………….……….……………..…16 Information Technology………………………………………………………………...…...….….……………17 Legal…..………………………………………………………………...…...….….……………………………...…18 Elections……..……………………….……………………………………...….……………………………….19 City Clerk/Records……………………….……………………………………...….………………………………20 Finance……..……………………….……………………………………...….……………………………….21 Accounting……..……………………….……………………………………...….……………………………….22 Assessing…………………………………………………………………………...…...….….……………………23 Public Safety: Police…………………………………………………………………..………….…..……………….…...…………24 Emergency Management…………….……………………………….………......………..………………...……25 Fire……...…………….……………………………….…………....……..………………...………………………26 Public Works: Summary……...…………….…………………………..………..……...………..………………...………..27 Municipal Center……...…………….…………………………..………..……...………..………………...……28 Engineering ……...…………….………………...……………………….....………………...……………………29 Lighting……………………………...……………..………..…………..……...................................................30 Forestry……………………………...……………..………..…………..……...................................................31 Park Maintenance …...…………….…………………..…………………..…………..………………...……..32 Street Maintenance………………………………………………………………….………..………..…………33 Garage…………………………………………………………………………………...……..………..……………34 Parks & Recreation Recreation…………………………………………………..……………….………………………………………35 Community Development: Summary……...…………….…………………………..………..……...………..………………...………..36 Building Inspections…………………………………………...……...……………………………….…………37 Planning…………………………………………………………………………..………………….…………….…38 Rental Inspections………………………………………………………………...…………….………..………39 General Government: Emergency…………………………………………………………………………...…...….….…………………40 Non-Departmental…………………………………………………………………………...…...….….…………41 TABLE OF CONTENTS Special Revenue Funds Cable TV…………………………………………………………………………………………………………………42 Solid Waste Abatement………………………………………………………………………………………………43 Police Activity……………………………………………………………………………………………………….44 Springbrook Nature Center…………………………………………………………………………………………45 Capital Projects Funds Buildings Improvement……………………………………………………...…..………………..………….……46 Street Improvement…………………………………………………………………………………………………47 Parks Improvement……………………………………………………...…..………………..………….……...…48 Information Technology Improvements…………………………………………………………………………49 Capital Equipment……………………………………………………………………………………………………50 Enterprise Funds Water……………………………………………………………………………………………………………………52 Sanitary Sewer…………………………………………………………………………………………………………54 Storm Water……………………………………………………………………………………………………………56 Municipal Liquor………………………………………………………………………………………………………58 Appendix Staffing Levels - 2015 - 2018…………………..…...……………………..…………..……………..………………59 Budget Calendar……….…………………..…...……………………..…………..……………..……………………60 Elected and Appointed Officials ELECTED OFFICIALS 4 Year Terms Expires December Effective January 2018 MayorScott J.Lund2020 Councilmember At LargeRobert L. Barnette2020 Councilmember, Ward IJames T. Saefke2018 Councilmember, Ward IIDolores M. Varichak2018 Councilmember, Ward IIIAnn R. Bolkcom 2018 APPOINTED OFFICIALS City ManagerWalter T. Wysopal City AttorneyDarcy M. Erickson Prosecuting AttorneyCity of Coon Rapids City ClerkDebra A. Skogen Department Heads: Director of Community DevelopmentScott J. Hickok Director of Finance/TreasurerShelly M. Peterson Director of Human ResourcesDeborah K. Dahl Director of Parks and RecreationJack G. Kirk Director of Public Safety and Emergency ManagementBrian T. Weierke Director of Public WorksJames P. Kosluchar Fire ChiefJohn D. Berg Page 1 This page intentionally left blank Page 2 TAX LEVIES Percent 201620172018Change General Fund$10,537,745$10,537,745$11,064,6325.00% I.S. Capital Projects Fund50,00050,00052,5005.00% Springbrook Nature Center Fund350,724350,724368,2605.00% Debt Service1,262,3663,183,7823,322,5214.36% Total Tax Levy$12,200,835$14,122,251$14,807,9134.86% 10-Year Levy Comparison $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 -0.57%6.84%3.85%1.91%5.13%2.30%1.94%3.97%15.75%4.86% 2009201020112012201320142015201620172018 General FundCapital Improvement FundCapital Equipment Springbrook Nature CenterDebt ServiceI.S. Capital Projects Page 3 CONSOLIDATED BUDGETS SUMMARY - GOVERNMENTAL FUNDS 20152016201720172018 ActualActualBudgetRevisedBudget Revenues By Source: Taxes & Assessments$11,096,812$11,605,122$11,590,000$11,513,300$11,780,600 User Fees & Charges2,692,8062,888,9782,970,2002,940,1152,918,200 Licenses and Permits1,267,5341,150,9541,006,000995,6001,004,400 Intergovernmental Revenue4,375,9727,379,8493,002,4002,873,7003,447,900 Other Income812,8711,242,978514,300774,400907,700 Transfers1,065,4102,047,849732,6001,982,600537,500 Other Sources - Bond Proceeds--50,000,00050,003,137- Total Revenue$21,311,404$26,315,730$69,815,500$71,082,852$20,596,300 Expenditures By Program: General Government$3,326,040$5,253,019$52,087,000$33,104,900$25,557,400 Public Safety7,900,4278,111,9428,513,8008,472,6008,412,900 Public Works4,569,9545,180,0394,762,0004,775,1005,335,500 Parks & Recreation3,422,7566,088,5201,916,1001,945,8002,678,400 Community Development1,651,3441,537,1991,631,7001,601,2001,653,500 Total Expenditures by Program$20,870,520$26,170,719$68,910,600$49,899,600$43,637,700 By Category: Personnel$11,965,522$12,409,103$13,238,800$13,210,500$13,753,500 Supplies796,800752,810883,500867,100836,000 Services & Charges3,265,6263,118,9463,387,9003,308,6003,454,800 Capital Outlay4,465,7638,888,36051,276,00032,389,00025,255,600 Transfers376,8101,001,500124,400124,400337,800 Other Financing Uses/Debt Service----- Total Expenditures by Category$20,870,520$26,170,719$68,910,600$49,899,600$43,637,700 CONSOLIDATED BUDGETS SUMMARY - ENTERPRISE FUNDS 20152016201720172018 ActualActualBudgetRevisedBudget Revenues By Source: Operating Revenue$14,193,682$15,377,882$16,341,900$16,180,900$17,153,600 Intergovernmental Revenue93,403254,34280,000500,000200,000 Other Income405,839112,91640,80040,80036,000 Transfers154,194---- Other Financing Sources----- Total Revenue$14,847,118$15,745,140$16,462,700$16,721,700$17,389,600 Expenditures By Program: Water$3,249,509$4,200,654$4,980,476$7,170,221$4,271,600 Sanitary Sewer5,033,9135,080,5636,040,6006,012,3005,877,316 Storm Water785,6271,541,7981,877,3002,432,3002,596,000 Liquor5,245,8025,440,8695,809,4005,637,5006,045,810 Total Expenditures by Program$14,314,851$16,263,884$18,707,776$21,252,321$18,790,726 By Category: Personnel$1,856,722$1,917,008$2,116,200$2,102,400$2,176,020 Supplies459,440433,9511,197,6001,185,300440,900 Services & Charges11,309,81311,431,49312,375,10012,214,40013,052,106 Capital Outlay-1,813,6412,385,0005,147,8212,601,000 Transfers492,794338,500338,500338,500338,500 Other Financing Uses/Debt Service196,082329,291295,376263,900182,200 Total Expenditures by Category$14,314,851$16,263,884$18,707,776$21,252,321$18,790,726 Page 4 2018CONSOLIDATED BUDGETS - GOVERNMENTAL FUNDS Revenues hƷŷĻƩLƓĭƚƒĻ Аі LƓƷĻƩŭƚǝγƷğƌ ЊАі DĻƓĻƩğƌ \[źĭĻƓƭĻƭğƓķ tƩƚƦĻƩƷǤğǣĻƭ tĻƩƒźƷƭ ЎАі Ўі …ƭĻƩCĻĻƭε /ŷğƩŭĻƭ ЊЍі Expenditures by Program DĻƓĻƩğƌ /ƚƒƒǒƓźƷǤ DƚǝĻƩƓƒĻƓƷ 5ĻǝĻƌƚƦƒĻƓƷͶ ЊАі tğƩƉƭε wĻĭƩĻğƷźƚƓ ЊЋі tǒĬƌźĭ{ğŅĻƷǤ ЌВі tǒĬƌźĭ‘ƚƩƉƭЋЍі Expenditures by Category hƷŷĻƩCźƓğƓĭźƓŭ …ƭĻƭΉ5ĻĬƷͶ tĻƩƭƚƓƓĻƌ /ğƦźƷğƌhǒƷƌğǤ ЏЌі ЊЏі {ĻƩǝźĭĻƭε /ŷğƩŭĻƭ ЊЏі {ǒƦƦƌźĻƭ Ѝі Note: Excludes Bond proceeds and expenses related to Civic Complex Project Page 5 GENERAL FUND REVENUES & EXPENDITURES 20152016201720172018 ActualActualBudgetRevisedBudget REVENUES General Property Taxes$10,474,192$10,589,954$10,612,800$10,537,800$11,115,900 Licenses & Permits1,267,5341,150,9541,006,000995,6001,004,400 Intergovernmental972,6581,262,4321,645,3001,648,6001,820,600 Charges for Services1,901,2112,030,1021,995,6001,968,9002,022,100 Fines & Forfeitures155,499186,418180,000180,000180,000 Special Assessments21,00914,51316,50014,80016,500 Miscellaneous267,945326,893234,200212,400205,700 Transfers569,600532,900452,600452,600287,500 Total Revenues$15,629,648$16,094,166$16,143,000$16,010,700$16,652,700 EXPENDITURES Legislative$129,291$132,018$139,100$139,200$142,300 General Management322,735355,620377,800370,200380,400 Human Resources262,284258,985260,400259,500256,200 City Clerk/Records93,986110,722105,900113,600115,500 Elections6,73260,9656,4009,30065,400 Legal368,650430,805440,400422,500405,600 MIS301,457310,868326,800327,800341,000 City Management$1,355,844$1,527,965$1,517,700$1,502,900$1,564,100 Accounting699,869615,481626,400596,900646,700 Assessing257,264287,545295,500291,700275,900 Finance$957,132$903,026$921,900$888,600$922,600 Police5,770,8125,777,9756,259,3006,227,1006,457,400 Emergency Management12,29015,64017,40015,30018,300 Police$5,783,102$5,793,615$6,276,700$6,242,400$6,475,700 Fire$1,405,354$1,439,218$1,496,200$1,512,100$1,560,400 Municipal Center305,578312,266333,200327,400337,600 Engineering263,754270,723316,700316,600332,100 Lighting228,482229,923253,900245,900265,100 Forestry--53,60053,60073,600 Park Maintenance885,372884,635923,300968,000957,300 Street Maintenance986,1811,002,1721,094,0001,084,2001,075,700 Garage441,823436,868455,900448,000464,300 Public Works$3,111,190$3,136,587$3,430,600$3,443,700$3,505,700 Parks & Recreation$880,439$891,727$951,600$926,300$968,000 Inspections543,360425,727436,100419,700421,700 Planning538,188517,040589,100590,700548,200 Rental Inspections158,909179,381189,000186,200237,900 Community Development$1,240,457$1,122,148$1,214,200$1,196,600$1,207,800 Reserve$-$-$120,000$120,000$122,400 Non-Departmental$140,514$920,376$75,000$38,900$183,700 Total Expenditures$15,003,323$15,866,680$16,143,000$16,010,700$16,652,700 Surplus (Deficit) of Revenues over Expenditures626,325227,486--- Beginning Fund Balance8,317,4848,943,8099,171,2959,171,2959,171,295 Ending Fund Balance$8,943,809$9,171,295$9,171,295$9,171,295$9,171,295 Page 6 2018GENERAL FUND OPERATING REVENUES & EXPENDITURES Revenues Licenses & … Intergov'tal 11% Charges For Services12% Other2% Taxes67% Transfers2% Expenditures by Program Fire 9% Police 39% Public Works 21% Finance 6% Parks & Rec 6% City Mgm't Comm Dev Other 9% 7% 3% Expenditures by Category Supplies 5% Personnel Services Other Services 78% & Charges 17% Page 7 GENERAL FUND REVENUES 20152016201720172018 ActualActualBudgetRevisedBudget Taxes General Property Taxes$10,447,055$10,574,369$10,587,800$10,537,800$11,098,900 Penalty on Delinquent Taxes27,13715,58525,000-17,000 Total Taxes$10,474,192$10,589,954$10,612,800$10,537,800$11,115,900 Special Assessments$21,009$14,513$16,500$14,800$16,500 Licenses & Permits Licenses$287,671$283,742$267,600$269,100$271,100 Permits979,863867,212738,400726,500733,300 Total, Licenses & Permits$1,267,534$1,150,954$1,006,000$995,600$1,004,400 Intergovernmental Federal Grants & Aids$37,532$64,220$24,000$24,000$24,000 State Grants & Aids935,1261,198,2121,621,3001,624,6001,796,600 Total Intergovernmental$972,658$1,262,432$1,645,300$1,648,600$1,820,600 Charges For Services Reimbursements$20,654$13,688$-$15,900$- HRA214,000217,996218,000218,000226,800 Cable TV83,30084,99685,00085,00085,000 Water Fund (Admin & Ops)258,100263,004263,000263,000273,500 Sewer Fund (Admin & Ops)248,800254,004254,000254,000264,200 Storm Fund28,100128,700128,700128,700133,900 Liquor Fund----50,000 Solid Waste Abatement4,000 Other4,3775,3084,3004,2004,200 Public Safety392,580403,964381,000374,000371,500 Public Works361,831369,137417,200365,100365,100 Community Development51,18758,01739,20038,80038,800 Recreation238,282231,288205,200222,200205,100 $1,901,211$2,030,102$1,995,600$1,968,900$2,022,100 Subtotal, Charges for Services Fines & Forfeitures$155,499$186,418$180,000$180,000$180,000 Miscellaneous $267,945$326,893$234,200$212,400$205,700 Other Financing Sources Liquor Fund$88,600$88,500$88,500$88,500$88,500 Closed Debt Service Fund350,000349,998269,700269,700104,600 CIP-Streets131,00094,40294,40094,40094,400 $569,600$532,900$452,600$452,600$287,500 Subtotal, Other Financing Sources TOTAL REVENUES$15,629,648$16,094,166$16,143,000$16,010,700$16,652,700 Page 8 GENERAL FUND REVENUE DETAIL 20152016201720172018% chg ActualActualBudget RevisedBudget2017-2018 GENERAL PROPERTY TAXES 1410-411100Current Ad Valorem$ 10,415,715$ 10,537,098$ 10,537,800$ 10,537,800$11,064,600 1410-411200Delinquent Ad Valorem31,34037,27150,00034,300 - 1410-415100Pen/Interest-Deliq Taxes22,82511,24825,00017,000 - 1410-415200Forfeited Tax Sale Apport4,3124,337 - - - SUBTOTAL$ 10,474,192$ 10,589,954$ 10,612,800$ 10,537,800$11,115,9005% SPECIAL ASSESSMENTS 5112-421100From County-Current$ 20,348$ 14,513$ 14,000$ 11,400$ 14,000 5112-421200From County-Delinquent6612,5003,4002,500 - SUBTOTAL$ 21,009$ 14,513$ 16,500$ 14,800$ 16,5000% LICENSES 1218-431100Liquor & Alcohol$ 73,085$ 68,187$ 66,000$ 66,000$ 66,000 1218-431300Dog Licenses2,9654,2055002,0002,000 5110-431400Contractor License13,51012,04011,30011,30011,300 5114-431200Rental Housing Licenses165,486170,650162,000162,000162,000 1218-431900All Other Licenses32,62528,66027,80027,80029,800 SUBTOTAL$ 287,671$ 283,742$ 267,600$ 269,100$ 271,1001% PERMITS 5110-435100Building Permits$ 581,173$ 400,391$ 371,000$ 369,900$ 371,000 5110-435110Plan Review Fees119,629174,240123,300123,300123,300 5110-435200Electrical Permits54,82266,20749,40049,40049,400 5110-435300Plumbing Permits44,15863,94048,40048,40048,400 5110-435400Heating Permits95,25678,45872,70072,70072,700 2510-435500Fire Code Permits28,84335,78025,30025,30031,000 3140-435600Load Limit Waiver175400500 - - 3140-435700Excavation/ROW/Erosion Permits37,79828,13627,50027,50027,500 5112-435900All Other Permits-Sign/Temp Sign18,00919,66020,30010,00010,000 SUBTOTAL$ 979,863$ 867,212$ 738,400$ 726,500$ 733,300-1% FEDERAL GRANTS & AIDS 2110-441100Federal Grant-Pub Safety/Police$ 36,908$ 54,356$ 24,000$ 24,000$ 24,000 2510-441100Federal Grant-Pub Safety/Fire-9,864 - - - 3174-441400FEMA Disaster Aid624 - - - - SUBTOTAL$ 37,532$ 64,220$ 24,000$ 24,000$ 24,0000% STATE GRANTS & AIDS 1410-443100Local Govt Aid (LGA)$ -$ 250,000$ 756,700$ 756,700$ 918,600 1410-443110PERA Coordinated Aid27,28227,28227,20027,20027,200 2110-443200Police Aid-POST Training12,99412,69412,50012,50030,000 2510-443210Insurance Prem Tax-Fire148,648148,297142,000142,000142,000 2110-443220Insurance Prem Tax-Police309,719325,929289,400289,400289,400 3174-443310Municipal State Aid-Maint430,699389,834390,000382,400382,400 2510-443400State Grants-Public Safety/Fire-8,8506,500 - - 3172-443400State Grants-Public Works/Parks-27,614 - - - 1210-445100Twin Cities Gateway Grant5,7847,7123,5007,9007,000 SUBTOTAL$ 935,126$1,198,212$ 1,621,300$ 1,624,600$ 1,796,60011% REIMBURSEMENTS 2110-450200Reimburse-Public Safety/Police$ 9,718$ 13,358$ -$ 8,600$ - 2510-450200Reimburse-Public Safety/Fire-3307,300 - - 3172-450200Reimburse-Public Works/Park5,295 - - - - 5112-450200Reimburse-Community Dev2,498 - - - - SUBTOTAL$ 17,511$ 13,688$ -$ 15,900$ -0% Page 9 GENERAL FUND REVENUE DETAIL 20152016201720172018% chg ActualActualBudget RevisedBudget2017-2018 GENERAL GOVERNMENT 1216-451400Elections Filing Fees$ -$ 60$ -$ -$ - 1218-451100Sale of Maps56344 - - - 1310-451210Admin Charges 4,1254,7564,0004,2004,200 (Hotel/Motel) 1310-451220Accounting Admin Charges3,143 - - 1310-451320NSF Charges10570 - - - 1312-451300Assessment Searches6030100 - - 1410-451220Admin Charges-HRA214,000217,996218,000218,000226,800 1410-451220Admin Charges-Cable TV83,30084,99685,00085,00085,000 1410-451220Admin Charges-Water, Admin258,100263,004263,000263,000273,500 1410-451220Admin Charges-Sewer, Admin248,800254,004254,000254,000264,200 1410-451220Admin Charges-Sewer, Ops- - - - - 1410-451220Admin Charges-Storm, Admin28,100128,700128,700128,700133,900 1410-451220Admin Charges-Recycling-4,000 - - - 1410-451220Admin Charges-Liquor-50,000 - - - 5110-451100Sale of Maps, Videos & Misc3148200-- SUBTOTAL$ 839,820$ 954,008$ 953,000$ 952,9001,041,6009% PUBLIC SAFETY 2112-453100School Resource Officer$ 195,324$ 212,753$ 208,000$ 208,000208,000 2110-453110Police Security28,05623,1628,00013,50011,500 2110-453120False Alarms1,6503,6755,0002,5002,000 2110-453140Seized Vehicle Storage Fees1,408 - - - - 2110-453160Accident Reports/Photos2,3432,5191,5001,5001,500 2110-453170Investigation Fees25 - - - - 2510-453200Fire Response Fees(804)13,8248,5008,5008,500 5110-453210Fire Impact Surcharge48,77564,52650,00050,00050,000 2111-453150Pawn Shop Transaction Fees115,80383,505100,00090,00090,000 SUBTOTAL$ 392,580$ 403,964$ 381,000$ 374,000$ 371,500-2% PUBLIC WORKS 3140-455100Public Works Construction$ 1,400$ 812$ 900$ 900$ 900.00 3172-455110Public Works Maintenance-Parks614796300- - 3174-455110Public Works Maintenance-Street195- - - - 3140-455130Antenna Rental Fees359,622367,529416,000364,200364,200 SUBTOTAL$ 361,831$ 369,137$ 417,200$ 365,100365,100-12% COMMUNITY DEVELOPMENT 5110-457100License Surcharge$ 13,803$ 3,675$ 3,200$ 3,200$ 3,200 5112-457200Zoning/Subdivision Fees16,02515,20015,00015,00015,000 5112-457210Community Dev Fees1697751,000600600 5112-457220Nuisance Abatement4,7199,7024,0004,0004,000 5114-457300Rental Reinspection Fees14,10025,10014,00014,00014,000 5114-457310Rental Late Fees/Transfers2,3713,5652,0002,0002,000 SUBTOTAL$ 51,187$ 58,017$ 39,200$ 38,80038,800-1% RECREATION 4100-459100Misc. Program Revenue$ -$ 2,958$ -$ -$ - 4101-459100Pre-School Programs-1231,0001,000800 4102-459100After School Programs12,29211,8027,7007,70011,600 4103-459100Youth Instructional6,5186,1668,4008,4005,100 4104-459100Playgrounds5,1093,2694,0004,0003,300 4105-459100Special Events11,16611,2136,2006,2008,700 4106-459100Summer Rocks Program75,69382,55464,30081,30079,800 4107-459100Sports/Athletics61,12949,91655,00055,00040,600 4108-459100Adult Instructional4,8014,0654,5004,5004,500 4109-459100Middle School Programs 13,43315,72915,10015,10010,700 (Zone/Chill) 4113-459100Youth Trips9,60912,6269,0009,00010,000 (Elementary) 4150-459100Senior Programs24,73612,09712,00012,00012,000 4110-459230Equip/Facility Rental13,79618,77018,00018,00018,000 SUBTOTAL$ 238,282$ 231,288$ 205,200$ 222,200$ 205,1000% Page 10 GENERAL FUND REVENUE DETAIL 20152016201720172018% chg ActualActualBudget RevisedBudget2017-2018 FINES & FORFEITURES 1214-461100Fines - Legal$ 155,499$ 186,418$ 180,000$ 180,000$ 180,000 SUBTOTAL$ 155,499$ 186,418$ 180,000$ 180,000$ 180,0000% MISCELLANEOUS REVENUE 1218-475200$ 64,864$ 62,207$ 58,000$ 58,000$ 58,000 3% Gambling Tax 1310-471110Interest Earnings82,64180,32459,00059,00059,000 1310-471120Unrealized Gain/Loss(23,249)24,648 - - - 1410-47410064,62390,94380,90080,90080,900 Insurance Reimbursements 1410-4741101,189335,000 Other Reimbursements - - 1410-47530037,9754,9584,0004,0004,000 Sale of Misc Property 1410-47590011,1765,5563,8003,8003,800 Miscellaneous Revenue 211#-4731009,65023,3759,500 Donations - Public Safety/Police - - 2110-461120Fines - Compliance-1,002 - - - 2110-474100Insurance Reimbursement-3,390 - - - 2110-475300Sale of Misc Property3,3761,260 - - - 2110-475900Misc Revenue124,926 - - - 2510-4731001,3001,700 Donations - Public Safety/Fire - - - 2510-475300Sale of Misc Property4,322300 317#-4741102,5902,984 Other Reimbursements/Parks - - - 317#-475300Sale of Misc Property3,125210 - - - 3172-47590082 Parks Misc. Revenue - - - - 31XX-47310075 Donations - Public Works - - - - 4100-4731002,60020,84610,000 Donations - Recreation - - 4100-4741106405,000 Recreation - Other Reimbursements - - - 4100-475900Miscellaneous683(72)4,000 - - 511#-475###Misc.Revenue2713 - - - SUBTOTAL$ 267,945$ 326,893$ 234,200$ 212,400$ 205,700-12% OTHER FINANCING SOURCES 1410-493100Liquor Fund$ 88,600$ 88,500$ 88,500$ 88,500$ 88,500 1410-493100Closed Debt Service Fund350,000349,998269,700269,700104,600 1410-493100CIP-Streets131,00094,40294,40094,40094,400 SUBTOTAL$ 569,600$ 532,900$ 452,600$ 452,600$ 287,500-36% TOTAL GENERAL FUND REVENUES$ 15,629,648$16,094,166$16,143,000$16,010,700$16,652,7003% Increase (decrease) from prior year$ 331,457$ 464,518$ 422,300$ (83,466)$ 509,700 Page 11 GENERAL FUND EXPENDITURES 20152016201720172018 ActualActualBudgetRevisedBudget PERSONNEL SERVICES 611100Full Time Employee-Regular$7,177,785$7,756,904$8,146,900$8,228,500$8,606,500 611105Part Time Permanent85,062192,501309,900174,000200,100 611110Temporary Employee-Regular725,983662,259653,500647,900735,400 611200Full Time Employee-Overtime336,674314,266305,100346,700333,700 611210Temporary Employee-Overtime1,1294,6372,0008,6005,400 611300Employee Leave412,11221,081--- 611400Severance's & Separations24,238---- 612100Medicare Contribution126,609129,860140,400136,400138,100 612110PERA Contribution939,944933,6741,086,9001,014,3001,055,000 612120Social Security Contribution298,017309,640329,700325,500312,700 612130Deferred Comp Contribution6,2227,1457,2007,4007,400 612140Health Insurance726,323819,782899,400944,500987,000 612150Dental Insurance14,98717,01918,10018,10018,800 612160Life Insurance6,6676,4587,0007,1007,500 612170Cash Benefit294,112288,034305,000255,400257,600 612180Worker's Compensation208,224252,866264,300327,200331,700 Misc Pay 613125950963600600700 (Empl. Recognition) 613130Unemployment Compensation2729,759-8,000- 613140Work Order Transfer-Labor(12,747)(13,649)(12,000)(12,000)(12,000) TOTAL PERSONNEL SERVICES $11,372,562$11,713,199$12,464,000$12,438,200$12,985,600 SUPPLIES Fuels & Lubes 621100$221,797$167,402$251,200$198,900$209,700 Clothing/Laundry Allowance 62111080,75596,87089,20087,30087,700 Office Supplies 62112020,12920,02223,30022,00025,300 Operating Supplies 621130120,382154,973116,500140,300122,400 Supplies for Repair & Maintenance 621140191,374167,488235,600235,700209,900 Small Tools & Minor Equipment 62115022,77014,10529,80035,20033,900 Work Order Transfer-Parts 62116094,45189,99897,70089,50094,100 TOTAL SUPPLIES $751,658$710,858$843,300$808,900$783,000 OTHER SERVICES & CHARGES 631100Professional Services$634,284$615,831$689,900$628,300$603,700 631130Insurance, Non-personnel103,638100,725108,500151,400153,800 631140Administrative Charges4406655005001,000 632100Dues & Subscription, Permit Renewals37,42264,18361,50065,20069,600 632110Transportation17,82416,49717,80017,10018,500 632120Conferences & Schools102,867181,143119,900105,600129,700 633100Advertising7,89710,61711,10015,10016,300 633110Printing & Binding34,39937,64044,90041,70048,200 633120Communication175,009191,496209,500216,600222,500 (phones, postage, etc.) 634100Utility Services313,113331,702361,100336,100385,900 635100Services Contracted, 938,863702,783822,800805,300833,300 Non-Professional 635110Rentals14,03211,41714,90015,20015,300 635120IS Fund Charge18,98817,914--- 638140Miscellaneous3,7442,778123,000123,000125,400 638180Payments to Other Agencies250,174250,132250,300242,500260,900 TOTAL OTHER SERV. & CHGS. $2,652,692$2,535,523$2,835,700$2,763,600$2,884,100 OTHER FINANCING USES 4720 Operating Transfers$226,410$907,100$-$-$- TOTAL GENERAL FUND $ 15,003,323$ 15,866,680$16,143,000$16,010,700$ 16,652,700 Page 12 Department: Legislative Division: City Council (1110) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$94,727$96,615$101,600$100,000$101,700 Supplies8797909002,8002,500 Other Services & Charges33,68534,61336,60036,40038,100 Capital Outlay----- Other Financing Uses----- Totals $129,291$132,018$139,100$139,200$142,300 Method of Financing General Fund $129,291$132,018$139,100$139,200$142,300 Number of Elected Officials5.05.05.05.05.0 Description of Services: The City Council sets policy for the City within guidelines of the City Charter and provides administrative directives through the office of the City Manager. The Council has two regular meetings scheduled each month for purposes of setting policy and other official business of the City. Four commissions submit advice to the City Council. They are as follows: Planning, Appeals, Parks & Recreation and Environmental Quality & Energy. The Charter is a semi-autonomous body in charge of reviewing and setting the governance rules of the City whose members are appointed by the Chief District Judge. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Council/Conference meetings2924303132 Local Board of Appeal and 22121 Equalization meetings 10201 Joint Council/HRA meetings 11111 Joint meeting with other elected board Budget Comments/Issues: Page 13 Department: City Management Summary 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$771,767$870,386$838,700$852,000$920,000 Supplies9,81312,26110,40010,5009,600 Other Services & Charges574,263645,318668,600640,400634,500 Capital Outlay----- Other Financing Uses----- Totals $1,355,844$1,527,965$1,517,700$1,502,900$1,564,100 Method of Financing General Fund $1,355,844$1,527,965$1,517,700$1,502,900$1,564,100 Number of Employees (FTEs)7.07.07.07.07.0 Page 14 Department: City Management Division:General Management (1210) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$264,654$271,973$291,900$290,500$300,100 Supplies3,6153,1853,0003,0003,300 Other Services & Charges54,46580,46282,90076,70077,000 Capital Outlay----- Other Financing Uses----- Totals $322,735$355,620$377,800$370,200$380,400 Method of Financing General Fund $322,735$355,620$377,800$370,200$380,400 Number of Employees (FTEs)2.02.02.02.02.0 Description of Services: The City Manager provides general administrative supervision of all City Departments. This role includes review and approval of budgets, employee and labor management, and the development of policy recommendations for the City Council. The City Manager's office also prepares Council agendas and has responsibility for communication with staff, the City Council, the general public and other governmental agencies. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: City Council & HRA Meeting Agenda2434363336 66666 City Newsletters 798252525 Business Survey 18111 SWOT planning with Council & Dtaff 7545203530 Business Retention Visits 10110 Employee Engagement Survey 11133 Employee All Staff & Supervisor Mtgs Budget Comments/Issues: Page 15 Department: City Management Division:Human Resources (1212) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$202,380$209,941$212,200$217,600$219,200 Supplies1,7005,8123,2002,8002,800 Other Services & Charges58,20443,23245,00039,10034,200 Capital Outlay----- Other Financing Uses----- Totals $262,284$258,985$260,400$259,500$256,200 Method of Financing General Fund $262,284$258,985$260,400$259,500$256,200 Number of Employees (FTEs)2.02.02.02.02.0 Description of Services: Establishes and maintains the personnel policies for the city. Address all human resource matters including recruitment, employee benefits, personnel guidelines, labor negotiations, and compliance. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Recruitment - City Position Filled 13161567 Full-time (Authorized) 53581005560 Part-time/Seasonal* 12%-4%10%-2%-18% Health Insurance - % increase in Premiums Workers Compensation 0.861.081.101.241.2 Workers Comp Mod Factor** 1717151515 Number of Workers Comp Claims $99,582$140,833$210,000$75,000$70,000 Total Cost of Workers Comp Claims * - Excludes 190 Election Judges in 2016 & 2018 ** - A mod factor of 1.0 is considered the norm Budget Comments/Issues: Page 16 Department:City Management Division:Information Technology (IT) (1213) 20152016201720172018 Expenditures by Category ActualActualBudgetRevisedBudget Personnel$213,126$232,529$237,100$233,300$237,400 Supplies3,3151,9112,8003,3001,500 Other Services & Charges85,01676,42886,90091,200102,100 Capital Outlay----- Other Financing Uses----- Totals $301,457$310,868$326,800$327,800$341,000 Method of Financing General Fund $301,457$310,868$326,800$327,800$341,000 Number of Employees (FTEs)2.02.02.02.02.00 Description of Services: Provides information system support, networking support and application development for all city departments. Also coordinates the city's use of information technology through long-range planning and policy development and facilitates communication between the city and its citizens through development of the city's website. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: 900625800595600 Requests for Service 2832151815 Avg Days to Close Service Request 50%23%20%16%20% %of Requests Closed Within 1 Day 35578 Long-term Projects 160225250500500 Users Supported 360500570600625 Devices Supported Budget Comments/Issues: hard count device inventory in 2016, and inclusion of mobile devices within the city. Page 17 Department: City Management Division:Legal (1214) 20152016201720172018 Expenditures by Category ActualActualBudgetRevisedBudget Personnel$-$-$-$-$- Supplies----- Other Services & Charges368,650430,805440,400422,500405,600 Capital Outlay----- Other Financing Uses----- Totals $368,650$430,805$440,400$422,500$405,600 Method of Financing General Fund $368,650$430,805$440,400$422,500$405,600 Number of Employees (FTEs) Description of Services: Provides legal council to the City Council, City Commissions, and City staff on municipal questions and also prosecutes criminal offenses. Two local firms provide legal services. The City Attorney attends Council meetings, provides legal opinions, and aids in the development of ordinances and resolutions. The Prosecuting Attorney prosecutes criminal offenses on behalf of the City. Page 18 Department:City Management Division:Elections (1216) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$272$50,874$-$2,400$54,600 Supplies-700100100700 Other Services & Charges6,4609,3916,3006,80010,100 Capital Outlay----- Other Financing Uses----- Totals $6,732$60,965$6,400$9,300$65,400 Method of Financing General Fund $6,732$60,965$6,400$9,300$65,400 Number of Employees (FTEs) Description of Services: Administers elections and works to minimize any delays experienced by voters. Serves as an important impartial authority for encouraging voter registration, for recruiting and assigning election judges, assisting in the accuracy of the voting equipment, county of ballots and certification of elections results and petitions. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: N/A17,447N/AN/A15,500 # Registered Voters on Election Day # Voting at PrecinctN/A10,999N/AN/A6,324 N/A2,655N/AN/A1,488 # Voting Absentee Ballot N/A78%N/AN/A60% % Voter Turnout Budget Comments/Issues: Page 19 Department:City Management Division:City Clerk/Records (1218) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$91,334$105,069$97,500$108,200$108,700 Supplies1,1846531,3001,3001,300 Other Services & Charges1,4685,0007,1004,1005,500 Capital Outlay----- Other Financing Uses----- Totals $93,986$110,722$105,900$113,600$115,500 Method of Financing General Fund $93,986$110,722$105,900$113,600$115,500 Number of Employees (FTEs)1.01.01.01.01.0 Description of Services: Administers & supervises: the city's records management program and document imaging system, MN Data Practices Act, business licensing and risk management. Maintain City Code and City Charter; monitor local and state legislation; provide research and analysis services, draft city ordinances, resolutions, policy and procedures; provide general information to public officials, general public and city personnel on regulations and polices of the city; serve as liaison to the City Charter Commission and Twin Cities Gateway Tourism, Notary, and special projects as assigned. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: # of Business/Liq Licenses Processed249228250260260 $63,565$63,464$55,000$55,000$60,000 3% Lawful Gambling Tax Received Budget Comments/Issues: environment to prepare for move to new facility Page 20 Department:Finance Summary 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$870,503$810,648$818,000$797,500$817,200 Supplies5,0123,9017,6005,0009,200 Other Services & Charges81,61788,47796,30086,10096,200 Capital Outlay----- Other Financing Uses----- Totals $957,132$903,026$921,900$888,600$922,600 Method of Financing General Fund $957,132$903,026$921,900$888,600$922,600 Number of Employees (FTEs)9.08.08.08.07.8 Page 21 Department:Finance Division:Accounting (1310) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$617,946$539,961$539,000$519,200$557,400 Supplies3,6762,4696,1003,6007,700 Other Services & Charges78,24773,05181,30074,10081,600 Capital Outlay----- Other Financing Uses----- Totals $699,869$615,481$626,400$596,900$646,700 Method of Financing General Fund $699,869$615,481$626,400$596,900$646,700 Number of Employees (FTEs)6.55.55.55.55.5 Description of Services: Responsible for the supervision, administration, and planning of the City's financial activities. These activities include: financial reporting, utility billing & collections, revenue collections, investments, debt management, risk management, grant management, budget preparation, and municipal off-sale liquor operations. The Finance Director/Treasurer and other staff members provide financial information to the City Council, the City Manager and all departments. Also provide financial services to the Fridley Housing and Redevelopment in the maintenance of tax increment data records. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: # of employees paid295*397330280*400 414448400420475 # of utility accts changing ownership 665723694772820 # of utility accts enrolled in autopay $9,600,000$13,755,000$10,200,000$58,555,000$58,705,000 City-wide debt balance 3449360019953 # of properties special assessed *election year for payroll Budget Comments/Issues: Page 22 Department:Finance Division:Assessing (1312) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$252,558$270,687$279,000$278,300$259,800 Supplies1,3361,4321,5001,4001,500 Other Services & Charges3,37015,42615,00012,00014,600 Capital Outlay----- Other Financing Uses----- Totals $257,264$287,545$295,500$291,700$275,900 Method of Financing General Fund $257,264$287,545$295,500$291,700$275,900 Number of Employees (FTEs)2.52.52.52.52.3 Description of Services: Implements the State of Minnesota's property tax statues as they apply to the City of Fridley. Classifies all taxable property and determines the apprised value of all real property within the City. 20152016201720172018 ActualProjected ActualProjectedRevised Key Measures: Total Market Value$2.15 billion$2.26 billion$2.45 billion$2.43 billion$2.45 billion 93.192.795.093.795.0 Sales Ratio (State mandates 90-105%) 2024253737 Tax Court Petitions 428510490500490 All Property Sales Jan 1 - Dec 31 Budget Comments/Issues: outside independent appraisals, which subsequently impacts the Other Services & Charges budget category. For 2017, we are estimating $10,000 in contracted appraisal costs. Page 23 Department:Police Division:Police (2110) 20152016201720172018 Expenditures by Category ActualActualBudgetRevisedBudget Personnel$5,098,093$5,208,515$5,667,200$5,623,600$5,879,100 Supplies207,054218,079237,000212,300216,600 Other Services & Charges377,955359,921372,500406,500380,000 Capital Outlay----- Other Financing Uses100,0007,100--- Totals $5,783,102$5,793,615$6,276,700$6,242,400$6,475,700 Method of Financing General Fund $5,783,102$5,793,615$6,276,700$6,242,400$6,475,700 Number of Employees (FTEs) 41.0041.0041.0041.0040.75 Sworn Officers: 11.6011.3511.3511.3511.35 Civilian Staff: Description of Services: The mission of the Police Department is to promote a safe and desirable city by partnering with the community to preserve life, protect property and defend rights. The Police Department provides professional police and emergency services to the community. Primary activities include enforcement of laws of the state and city, investigation of crimes and apprehension of violators, enforcement of traffic laws for the safe, expeditious movement of traffic and reduction of traffic accidents, promotion of crime prevention, and response to medical emergencies. The Police Department collaborates with local school districts to provide School Resource Officers as a liaison to schools and a mentor to youth. The Police Department provides a dedicated Pawn Detective to regulate pawn shops and investigate pawn-related crime. The Police Department maintains a close liaison with other law enforcement agencies and provides an officer to the Anoka-Hennepin Narcotics and Violent Crime Task Force. The Police Department uses contemporary strategies to solve neighborhood problems and concerns while placing an emphasis on building community partnerships. The Police Department is headed by a Public Safety Director, who is a Licensed Police Officer. The Director is assisted by a non-sworn civilian Office Coordinator. The department is organized into three major areas of responsibility (Patrol, Investigations, and Support), each headed by a Lieutenant, all of whom are Licensed Police Officers. Patrol consists of 28 Licensed Police Officers (6 Sergeants and 22 Patrol Officers) and 5 part-time non-sworn unformed Community Service Officers. Investigations consists of 8 Licensed Police Officers (1 Lieutenant of Investigations, 2 General Assignment Detectives, 1 Pawn Detective, 1 Drug Task Force Detective and 3 School Resource Officers), as well as 1 full- time non-sworn civilian staff member. Support consists of 1 Lieutenant of Support, 1 Sergeant of Records, 1 Special Operations Detective, 3 full-time and 3 part-time non-sworn civilian staff members. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Calls for Service23,21723,22821,50021,22022,000 Criminal offenses - Part I1,0591,0451,1001,0321,050 Criminal offenses - Part II1,4531,3601,6001,2551,300 Physical Arrests9537521,200835800 Traffic Violations1,9562,6012,8001,9822,200 Block Watch Captains175185220180190 Hshlds Reached via Nextdoor.com1,9002,5004,0003,1003,500 Budget Comments/Issues: Page 24 Department:Police Division:Emergency Management (2150) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$-$-$-$-$- Supplies2,9068,3123,4003,5006,000 Other Services & Charges9,3847,32814,00011,80012,300 Capital Outlay----- Other Financing Uses----- Totals $12,290$15,640$17,400$15,300$18,300 Method of Financing General Fund $12,290$15,640$17,400$15,300$18,300 Description of Services: The Emergency Management Division of the Police Department is responsible for planning and implementing response to local, regional or national emergencies or disasters in accordance with State and Federal guidelines. In addition to creating and maintaining an Emergency Operations Plan, the Division is responsible for training personnel for emergencies, support of a corps of volunteer Reserve Officers available to assist Department operations in emergencies, maintaining an outdoor emergency warning system, and operation of an Emergency Operations Center. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Volunteer Reserve Officer Hours1,0072,1041,5502,0002,200 Page 25 Department:Fire Division:Fire (2510) 20152016201720172018 Expenditures by Category ActualActualBudgetRevisedBudget Personnel$1,072,489$1,087,085$1,161,300$1,179,000$1,205,900 Supplies78,45371,74083,70084,70079,000 Other Services & Charges254,413280,393251,200248,400275,500 Capital Outlay----- Other Financing Uses----- Totals $1,405,354$1,439,218$1,496,200$1,512,100$1,560,400 Method of Financing General Fund $1,405,354$1,439,218$1,496,200$1,512,100$1,560,400 Number of Employees (FTEs)7.07.07.07.07.0 Description of Services: The Fire Department provides emergency response service for all hazards including but not limited to fires, medical emergencies, rescues and accidental releases of hazardous materials. The Department also conducts fire code compliance inspections and reviews building plans for code compliance. Its community support programs include: annual fire prevention training for elementary school students, fire education training for groups and businesses, and participation in neighborhood and youth programs. The Department is dispatched by Anoka County and participates in an automatic aid system with three area fire departments and a statewide mutual aid system. Fire personnel are on duty 24 hours per day and the staff consists of full-time and paid on-call firefighters. The City has three fire stations, and operates a fire training facility under a joint powers agreement with two other fire departments. Fridley Firefighters also provide staff to support the MN State Chemical Assessment Team for the North Metro, the Anoka County Fire Protection Council Specialized Rescue Team and Fire Investigation Team and the MN Type III Incident Management Team. 20152016201720172018 Key Measures:ActualActualProjectedRevisedProjected Service Demand: 2,2302,3232,3602,5452,642 Medical Response Fire Response 99124140149182 870946854909900 Other Calls 3,1993,3933,3543,603 Total3,724 Average Response Time: 5.7 Min5.3 Min5.9 Min5.3 Min5.5 Min All Calls 12 Min6.2 Min11.2 Min6.2 Min6.5 Min Building Fires Mutual Aid: 2139303535 Given 920251822 Received Estimated Property Loss Due to Fire: $267,274$366,985$346,060$320,000$350,000 Residential $381,795$62,750$142,782$165,000$160,000 Commercial 3434353436 Number of Firefighters: Prevention: # of Public Education Contacts (Events)4749504550 # of Commercial Prop. Inspections (Con9929057727001,000 Budget Comments/Issues: Emergency Management for air quality monitoring equipment. Union on filling vacant Captain shifts. Page 26 Department:Public Works Summary 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$1,915,630$2,061,660$2,153,500$2,201,700$2,213,900 Supplies371,661338,080436,600418,600399,000 Other Services & Charges823,900736,847840,500823,400892,800 Capital Outlay----- Other Financing Uses----- Totals $3,111,190$3,136,587$3,430,600$3,443,700$3,505,700 Method of Financing General Fund $3,111,190$3,136,587$3,430,600$3,443,700$3,505,700 Number of Employees (FTEs)21.421.422.422.422.4 Page 27 Department:Public Works Division:Municipal Center (3110) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$104,102$131,373$132,600$135,600$138,200 Supplies13,77213,70714,90016,40013,200 Other Services & Charges187,704167,186185,700175,400186,200 Capital Outlay----- Other Financing Uses----- Totals $305,578$312,266$333,200$327,400$337,600 Method of Financing General Fund $305,578$312,266$333,200$327,400$337,600 Number of Employees (FTEs)1.51.51.81.81.8 Description of Services: Maintains the exterior and interior of the Municipal Center Building in a manner which ensures safety for the public and extends the useful life of the facility. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Power consumption3,870 kWh4,010 kWh4,480 kWh4,070 kWh4,480 kWh Natural gas consumption6,750 THM9,110 THM12,640 THM9,480 THM12,640 THM Emergency service calls161213138 Contracted maintenance$107,084$91,822$97,500$90,300$84,000 Budget Comments/Issues: Page 28 Department:Public Works Division:Engineering (3140) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$150,333$176,326$214,700$213,100$221,700 Supplies11,4006,54610,30010,8009,300 Other Services & Charges102,02187,85191,70092,700101,100 Capital Outlay----- Other Financing Uses----- Totals $263,754$270,723$316,700$316,600$332,100 Method of Financing General Fund $263,754$270,723$316,700$316,600$332,100 Number of Employees (FTEs)1.81.82.12.12.1 Description of Services: Develops plans, sets specifications, and determines estimates for capital improvement and safety programs. The Engineering staff also is responsible for the design and construction of streets, sanitary sewer collection systems, storm water facilities, and water treatment and distribution systems. Records are maintained by the Engineering staff on various projects in the City, as-built files, and utility service locations. Also the GIS (Geographic Information System) function is responsible for computer mapping and computer graphic systems. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Capital construction designed$1.95 million$1.83 million$2.40 million$2.77 million$4.40 million Capital const inspected and admin.$1.25 million$3.36 million$5.00 million$6.17 million$6.19 million Project design, inspect & admin. costs7.0%7.2%8.5%10.2%8.5% Act cost of construction vs. bid award+2.5%+2.7%+5.0%+5.5%+5.0% Site permits reviewed3216303030 Site permits reviewed - acres320250300300300 Land alt permits issued2219222225 Right-of-way permits reviewed104105100110105 Utility service permits issued8778808080 Budget Comments/Issues: Page 29 Department:Public Works Division:Lighting (3170) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$22,793$25,036$25,900$25,900$26,600 Supplies2,3442,9246,0006,0006,000 Other Services & Charges203,346201,963222,000214,000232,500 Capital Outlay----- Other Financing Uses----- Totals $228,482$229,923$253,900$245,900$265,100 Method of Financing General Fund $228,482$229,923$253,900$245,900$265,100 Number of Employees (FTEs)0.30.30.30.30.3 Description of Services: Maintains the charges for the electrical overhead street lighting found throughout the City and for all traffic signal systems. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Street lighting maintenance cost$14,455$5,354$18,000$13,500$13,500 Traffic signal maintenance cost$8,200$10,100$10,000$14,500$15,000 Budget Comments/Issues: Page 30 Department:Public Works Division:Forestry (3171) 20152016201720172018 Expenditures by Category ActualActualBudgetRevisedBudget Personnel$-$-$-$-$- Supplies--2,8002,8002,800 Other Services & Charges--50,80050,80070,800 Capital Outlay----- Other Financing Uses----- Totals $-$-$53,600$53,600$73,600 Method of Financing General Fund $-$-$53,600$53,600$73,600 Description of Services: Provides for park, public grounds and street tree maintenance, replacement and management. Primary services are as follows: park and public street tree trimming and removals per accepted standards, inspection for diseased trees, private diseased tree removal management, manage tree replacement program. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Tree Inspections7577806275 City Trees Removed1215506880 City Trees Planted0165087105 Budget Comments/Issues: Page 31 Department:Public Works Division:Park Maintenance (3172) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$634,018$650,625$685,300$701,700$702,700 Supplies111,633107,579117,600137,600120,800 Other Services & Charges139,720126,431120,400128,700133,800 Capital Outlay----- Other Financing Uses----- Totals $885,372$884,635$923,300$968,000$957,300 Method of Financing General Fund $885,372$884,635$923,300$968,000$957,300 Number of Employees (FTEs)5.85.85.85.85.8 Description of Services: Plans, constructs and maintains both active and passive park areas for use by the public. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Park inspections performed432430410400400 Park corrective orders4716201620 Irrigation system repairs168121012 Number of athletic field preparations6864646464 Ice rink maintenance$22,000$20,000$20,000$14,000$20,000 Vegetation management area - acres130160160160160 Vegetation management area cuttings4540424642 Budget Comments/Issues: Page 32 Department:Public Works Division:Street Maintenance (3174) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$698,817$743,227$759,000$786,200$780,500 Supplies207,106183,092258,500218,500219,000 Other Services & Charges80,25875,85376,50079,50076,200 Capital Outlay----- Other Financing Uses----- Totals $986,181$1,002,172$1,094,000$1,084,200$1,075,700 Method of Financing General Fund $986,181$1,002,172$1,094,000$1,084,200$1,075,700 Number of Employees (FTEs)8.38.38.58.58.5 Description of Services: Performs the necessary tasks to reduce the depreciation of streets and upholds the desirable standards of appearance, serviceability and safety. This includes upkeep such as street sweeping, repair of roadway surface areas, and snow/ice removal. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Plowing events (prior winter season)46131013 Sanding events (prior winter season)1213201821 De-icing usage - salt (tons)450412600550600 De-icing usage - sand (tons)350170350200150 Average pavement rating24.8525.3325.3425.3425.16 Pavement repair materials used (tons)747701700620660 Budget Comments/Issues: Page 33 Department:Public Works Division:Garage (3176) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$305,567$335,073$336,000$339,200$344,200 Supplies25,40524,23226,50026,50027,900 Other Services & Charges110,85177,56393,40082,30092,200 Capital Outlay----- Other Financing Uses----- Totals $441,823$436,868$455,900$448,000$464,300 Method of Financing General Fund $441,823$436,868$455,900$448,000$464,300 Number of Employees (FTEs)3.83.83.83.83.8 Description of Services: The Garage Division includes the Public Works maintenance office staff and the mechanics who maintain all city equipment for Public Works, Police, Fire, and other city vehicles. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Annual Fuel Consumption - Diesel21,53320,10025,00022,00021,000 63,66771,03572,00077,00070,000 Annual Fuel Consumption - Gasoline 7570756870 Annual Number of Breakdown Repairs 7273757677 Average Equipment Rating Score $2,500$2,400$2,400$2,200$2,300 Annual Cost per Vehicle $4.0 million$4.1 million$4.2 million$4.2 million$4.1 million Estimated Fleet Value Budget Comments/Issues: Page 34 Department:Parks & Recreation Division:Recreation (4100) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$625,280$643,166$677,900$670,700$689,500 Supplies64,37154,94656,30064,20056,200 Other Services & Charges189,378193,615217,400191,400222,300 Capital Outlay----- Other Financing Uses1,410---- Totals $880,439$891,727$951,600$926,300$968,000 Method of Financing General Fund $880,439$891,727$951,600$926,300$968,000 Number of Employees (FTEs)5.55.55.55.55.5 Description of Services: Provides a wide variety of year-round leisure activities that contribute toward the physical, social, and emotional well-being of citizens of all ages. Programs are provided in the following areas: instructional recreation activities, competitive athletic leagues, fitness activities, special events, cultural arts, and outings. This division also operates a Senior Center which provides social services, recreation, and health and wellness programs. The staff also promotes cooperation among local groups and organizations. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: 311,500315,000315,000300,000300,000 Total Program Participant Hours Scholarship/Fee Assist Participants96721007275 Dollar Amount of fees covered by scholarships/assistance programs 9,9705,3159,0005,0005,500 22,87023,69518,00023,70023,700 Senior Program Volunteer Hours 62,21865,50065,00065,50065,500 Senior Program Participant Hours Budget Comments/Issues: Page 35 Department:Community Development Summary 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$924,072$935,124$985,800$987,800$994,300 Supplies14,47710,27410,80010,80010,900 Other Services & Charges301,908176,750217,600198,000202,600 Capital Outlay----- Other Financing Uses----- Totals $1,240,457$1,122,148$1,214,200$1,196,600$1,207,800 Method of Financing General Fund $1,240,457$1,122,148$1,214,200$1,196,600$1,207,800 Number of Employees (FTEs)9.19.59.79.79.5 Page 36 Department:Community Development Division:Building Inspections (5110) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$295,632$296,575$295,700$303,900$305,800 Supplies8,2724,3503,7003,7003,700 Other Services & Charges239,457124,802136,700112,100112,200 Capital Outlay----- Other Financing Uses----- Totals $543,360$425,727$436,100$419,700$421,700 Method of Financing General Fund $543,360$425,727$436,100$419,700$421,700 Number of Employees (FTEs)3.03.03.03.03.0 Description of Services: Building Inspections enforces the Building Code within the City in order to prevent health and safety hazards. The Building Inspection staff provides City Code information to homeowners, builders, and businesses and also reviews plans and provides coordination of inspections. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Permits Issued5,2752,8262,4952,1052,466 $ 16,674,073$6,525,022$9,332,534$2,647,233$7,651,442 Residential Bldg Permit Value $ 43,930,921$ 38,853,778$ 31,845,056$49,450,767$44,078,488 Commercial Permit Values 389312269327329 Contractor Licesnse Issued Budget Comments/Issues: - 2 hour turnaround on inspection requests, - Within 10 days for commercial inspection plan reviews, - Within 3 days for residential plan reviews. Page 37 Department:Community Development Division:Planning (5112) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel 478,523469,532518,600512,200468,200 4,7643,0273,8003,8003,900 Supplies 54,90144,48166,70074,70076,100 Other Services & Charges ----- Capital Outlay ----- Other Financing Uses Totals $538,188$517,040$589,100$590,700$548,200 Method of Financing General Fund $538,188$517,040$589,100$590,700$548,200 Number of Employees (FTEs)4.54.95.15.14.4 Description of Services: Planning is the principal advisor to the Planning Commission, Appeals Commission, Environmental Quality and Energy Commission, City Council and City Manager on all land use, urban development, energy and environmental functions. This division also administers a variety of recycling programs and administers an aggressive code enforcement program. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: No. of nuisance abatements1221201008585 52625 No. of citations/formal complaints 2012221815 Total No. land use applications 3744303035 Permanent sign permits issued 2625251030 Temporary sign permits issued Budget Comments/Issues: Page 38 Department:Community Development Division:Rental Inspections (5114) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$149,918$169,017$171,500$171,700$220,300 Supplies1,4422,8973,3003,3003,300 Other Services & Charges7,5507,46714,20011,20014,300 Capital Outlay----- Other Financing Uses----- Totals $158,909$179,381$189,000$186,200$237,900 Method of Financing General Fund $158,909$179,381$189,000$186,200$237,900 Number of Employees (FTEs)1.61.61.61.62.1 Description of Services: Rental Inspection provides for the systematic inspection and licensing of rental units in order to protect the health, safety, and welfare of the Community and to preserve the Fridley's valuable housing stock. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Application Fees, Late Fees & RI Fees$181,951$198,165$183,000$185,981$186,000 8829031,1701,1441,244 Licensed Rental Properties 1,7991,5381,8701,5341,460 Units Inspected 7,4098,0139,0006,0006,000 Violations Found Page 39 Department:Reserve Division:Emergency (1412) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$-$-$-$-$- Supplies----- Other Services & Charges--120,000120,000122,400 Capital Outlay----- Other Financing Uses----- Totals $-$-$120,000$120,000$122,400 Method of Financing General Fund $-$-$120,000$120,000$122,400 Number of Employees (FTEs) Description of Services: The Reserve for Contingency absorbs any unexpected costs that occur during the year that were not budgeted. These types of costs are usually in the form of lawsuits or other unexpected expenses. The Reserve also provides funds to carry on City business with no interruption of services to taxpayers when unexpected fluctuations in the economy cause a change in any revenue source. Page 40 Department:Non-Departmental Division:Non-Departmental (1410) 20152016201720172018 Expenditures by CategoryActualActualBudgetRevisedBudget Personnel$-$-$60,000$25,900$164,000 Supplies(61)787--- Other Services & Charges15,57519,58915,00013,00019,700 Capital Outlay----- Other Financing Uses125,000900,000--- Totals $140,514$920,376$75,000$38,900$183,700 Method of Financing General Fund $140,514$920,376$75,000$38,900$183,700 Number of Employees (FTEs) Description of Services: The Non-Departmental Division was established in 1990. This Division accounts for expenditures which cannot be allocated to specific departments and/or divisions. Budget Comments/Issues: to be identified that are unplanned (includes job evaluation, market adjustments, errors or omissions). Another $104,000 of this amount is to fund staffing issues in IT and HR. More work is being done to determine needs and allocation of duties. increase in participation in 2018. Page 41 Cable TV 225 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Franchise Fees$282,251$291,941$290,000$290,000$290,000 Sale of Maps, Videos & Misc44---- Administrative Charges1,100---- Interest Earnings16,12916,03710,00010,00010,000 Unrealized Gain/Loss(4,394)4,758--- Miscellaneous Revenue35,213--26,000- Transfer In--30,00030,000 Total Revenues$330,342$312,736$330,000$356,000$300,000 Expenditures Personnel$147,398$173,882$214,100$215,200$180,100 Supplies5,8553644,4004,4004,400 Other Services/Charges109,353139,227116,300112,200120,800 Capital Outlay--25,000-- Other Financing Uses----250,000 Total Expenditures$262,606$313,473$359,800$331,800$555,300 Surplus (Deficiency) of Revenues $67,737$(737)$(29,800)$24,200$(255,300) over Expenditures Beginning Fund Balance $1,460,963$1,528,700$1,527,963$ 1,527,963$1,552,163 Ending Fund Balance$1,528,700$1,527,963$1,498,163$ 1,552,163$1,296,863 Number of Employees (FTEs) 1.702.002.002.002.00 Description of Services: The Cable TV Fund provides support for the Fridley Municipal Television Channel 17, web design and social media. All regular City Council, Appeals Commission, Planning Commission, and HRA meetings are broadcast live on Channel 17 and reran several times during the week. Staff also provides production services for the Fridley school Board meetings. In addition to broadcasting meetings, staff produce a number of departmental and community event programs. In total, staff produces about 90 programs a year. Other services include: providing an electronic community bulletin board, assisting all City departments with their audio- video needs, programming of Fridley Public Access Channel 15, photography, newsletters, web administration, social media and press releases. The Cable TV Fund also provides equipment necessary for the operations of Channel 17. 20152016201720172018 Key Measures: ActualActualProjectedRevisedProjected Programming Produced Civic Meetings6141605060 Departmental Programs2635303030 Community Events82532 Press Releases1818181818 Newsletters77777 Electronic Newsletter4069606060 Internet Presence Viebit HitsNA10,0007,00013,2007,000 YouTube Hits3,6404,2394,0004,0004,500 (Select Programs are uploaded, Meetings are not) Social media posts775672800800800 Budget Comments/Issues: funding was included in the CIP Page 42 Solid Waste Abatement 237 20152016201720172018 RevenuesActualActualBudgetRevisedBudget State Grants-Gen Gov't$94,869$95,748$102,000$100,000$100,000 Reimbursement-Gen Gov't--8,000-- Recycling Fees284,858288,939290,000290,000302,500 Recycling Penalties7,4947,4706,0006,0006,200 Other Reimbursements-5,235--2,500 Miscellaneous Revenue22,81021,48912,00012,0004,500 Transfer From Other Funds----- Total Revenues$410,031$418,881$418,000$408,000$415,700 Expenditures Personnel$49,730$58,598$50,400$45,500$46,400 Supplies3,6591,0382,7002,7002,700 Other Services/Charges357,497355,415364,400356,400366,600 Capital Outlay----- Other Financing Uses----- Total Expenditures$410,887$415,051$417,500$404,600$415,700 Surplus (Deficiency) of Revenues $(856)$3,830$500$3,400$- over Expenditures Beginning Fund Balance$86,744$85,888$89,718$89,718$93,118 $85,888$89,718$90,218$93,118$93,118 Ending Fund Balance Number of Employees (FTEs) 0.500.500.500.500.50 Description of Services: Fund was established in 1991. It reflects the City's solid waste abatement activities such as curbside recycling and drop-off events to eliminate electronics, appliances and other items from the waste stream. Marketing and educational activities are also supported. 20152016201720172018 Key Measures:ActualActualProjectedRevisedProjected Total recycling tons reported to county (NIC municipal) 2,3122,1872,2002,2002,200 Curbside recycling tonnage, units 1-121,9071,8391,9001,8001,900 Budget Comments/Issues: Page 43 Police Activity 260 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Reimbs-Other City/Cty-Pub Safety $52,324$141,311$137,400$148,200$150,900 Transfer From Other Fund100,000---- Total Revenues$152,324$141,311$137,400$148,200$150,900 Expenditures Personnel$48,777$121,309$128,700$127,500$130,100 Supplies2,1661,0742005,2005,200 Other Services/Charges1,90916,2854,5004,9004,900 Capital Outlay----- Other Financing Uses----- Total Expenditures$52,851$138,668$133,400$137,600$140,200 Surplus (Deficiency) of Revenues $99,473$2,643$4,000$10,600$10,700 over Expenditures Beginning Fund Balance$(97,712)$1,761$4,404$4,404$15,004 Ending Fund Balance$1,761$4,404$8,404$15,004$25,704 Number of Employees (FTEs) 1.001.001.001.001.00 Description of Services: Administers grants received from a variety of intergovernmental agencies. In most cases, grant funds are provided on a reimbursement basis following proper documentation of expenditures, however, in some cases the money is provided in advance to be spent on specific activities outlined in the grant. Budget Comments/Issues: Page 44 Springbrook Nature Center 270 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Current Ad Valorem$343,130$348,795$350,700$350,700$368,200 Delinquent Ad Valorem1,6871,637--- Shelter Rental1,85710018,0005,4006,000 Daycamp41,21355,47355,00071,40065,000 Special Events26,99224,76225,00012,60025,000 School Programs14,5966,76118,00018,90025,000 (Non-Fridley) School Programs8,20810,87010,0002,70010,000 (Fridley Only) Birthday Parties2,7653,1505,0006,3006,000 Public Interpretive Programs1,0712832,0004002,000 Community Groups1,8631,0792,5002,5002,500 Interest Earnings1,2841,5581,0001,0001,000 Unrealized Gain/Loss(517)338--- Gen Contrib/Donations38,69818,569-22,00010,000 Total Revenues$482,846$483,505$487,200$525,900$530,700 Expenditures Personnel$323,866$342,115$381,600$384,100$411,300 Supplies33,05839,47632,90045,90040,700 Other Services/Charges52,72868,12367,00071,50078,400 Capital Outlay---40,000- Other Financing Uses19,400---- Total Expenditures$429,051$449,714$481,500$541,500$530,400 Surplus (Deficiency) of Revenues $53,795$33,791$5,700$(15,600)$300 over Expenditures Beginning Fund Balance$117,157$170,952$204,743$204,743$189,143 Ending Fund Balance$170,952$204,743$210,443$189,143$189,443 Number of Employees (FTEs)3.503.503.504.304.70 Description of Services: Provides a wide range of environmental interpretive programs utilizing various natural resource areas within the city. These programs are available to the general public, local school districts, community groups and organizations. 20152016201720172018 ActualActualProjectedRevisedProjected Key Measures: Program participant hours43,00631,95746,00046,00046,000 Number of school group student visits11,7158,69713,10013,10013,100 Volunteer hours13,59910,30016,00016,00016,000 Budget Comments/Issues: 2016, phase 2 started in late 2016 and is scheduled for completion in 2017. Page 45 BUILDINGS CAPITAL IMPROVEMENTS 405 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Local Government Aid$ 250,000$ -$ -$ -$ - Investment Income 10,399 19,349 - 180,000 120,000 Capital Improvement Plan Bonds - - 50,000,000 50,003,137 - Grants - - - 25,000 - Transfers In - 500,000 - 1,250,000 - Totals$ 260,399$ 519,349$50,000,000$51,458,137$ 120,000 Expenditures by Category Community Center Furniture & Fixtures$ 10,366$ -$ 5,000$ -$ - Police and Public Works Storage Facility - - - - 250,000 Municipal Center Facilities Feasibility Study 8,380 - - - - Municipal Center HVAC Replacement 57,892 - - - - Municipal Center Roof Replacement 2,458 - - - - Municipal Center Repairs 10,295 4,075 - - - Municipal Center Furniture & Fixtures 11,726 - - 5,000 - Municipal Center Exterior Repairs 27,174 - - - - Municipal Center Site Analysis 67,357 - - - - Municipal Center Civic Campus - 1,265,005 48,750,000 29,875,000 21,750,000 Fire Station 2 & 3 Site Upgrades - 15,050 27,000 - - Fire Replace Asphalt - 11,829 - - - Fire Station 2 & 3 Security Upgrades 12,566 - - - - Totals$ 208,214$1,295,959$48,782,000$29,880,000$ 22,000,000 Surplus (Deficiency) of Revenues over (under) Expenditures 52,185 (776,610) 1,218,000 21,578,137 (21,880,000) Beginning Fund Balance$1,397,260$1,449,445$ 629,911$ 672,835$ 22,250,972 Ending Fund Balance $1,449,445$ 672,835$ 1,847,911$22,250,972$ 370,972 Description of Services: The purpose of the Building Capital Improvements budget is to fund repair or replacement of major buildings or building related improvements. The Capital Improvement Plan (CIP) is an integral component for the development of the current year's budget. The CIP is used for planning future expenditures over a multitude of years. The budget is the document that formalizes which projects will proceed. Page 46 STREET CAPITAL IMPROVEMENTS 406 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Municipal State Aid - State Aid Routes$400,049$1,040,848$317,400$317,700$400,000 Municipal State Aid - Local Routes--369,400164,100100,000 State Grants-300,000--- Federal Highway Aid-77,948-75,000459,000 Cost-Share Reimbursements -59,509--- Reimbursements from Business-36,436--- Special Assessments 206,794600,223560,000560,000230,000 Investment Income 16,39823,94115,10020,00010,000 Transfers In-557,849--- Totals$623,241$2,696,754$1,261,900$1,136,800$1,199,000 Expenditures Street Rehabilitation Program$462,662$1,915,395$770,000$770,000$480,000 Sealcoat Program291,095-270,000270,000270,000 Traffic Signal Maint/Retrofit--20,00020,000180,000 Trail/Walk Upgrades9,937427,346100,000100,000200,000 West Moore Lake Ped & Bike Improv.----600,000 Main Street Pedestrian Bridge5,946---- Capital Signage Replacements--15,00015,00015,000 Street Lighting Upgrades--90,00090,000- Traffic Safety Projects--30,00030,00030,000 Transfer to General Fund131,00094,40094,40094,40087,800 Totals$900,640$2,437,141$1,389,400$1,389,400$1,862,800 Surplus (Deficiency) of Revenues over (under) Expenditures (277,399)259,613(127,500)(252,600)(663,800) Reserve for Delayed Projects ---(562,046)- Beginning Fund Balance 2,814,5872,537,1881,505,8312,796,8011,982,155 Ending Fund Balance $2,537,188$2,796,801$1,378,331$1,982,155$1,318,355 Description of Services: The purpose of the Street Improvements budget is to fund repair or replacement of city streets and street related equipment such as signs and street lights. Funding sources for these improvement come from two primary sources, Municipal State Aid and special assessments. The Capital Improvement Plan (CIP) is an integral component for the development of the current year's budget. The CIP is used for planning future projects over a multitude of years. The budget is the document that formalizes which projects will proceed. Funding sources for these improvement come from two primary sources, Municipal State Aid and special assessments. Page 47 PARKS CAPITAL IMPROVEMENTS 407-3172- 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Ad Valorem Tax Levy$ -$ -$ -$ -$ - Liquor Store Proceeds (Transfer In) 75,000 - 75,000 75,000 75,000 Local Government Aid - 25,000 20,000 20,000 125,000 Investment Income 11,048 10,263 15,000 15,000 15,000 Park Dedication Fees - 6,422 75,000 75,000 5,000 Transfer from SNC 19,400 75,000 - - - Miscellaneous 1,536 535 - - - SPRING Foundation Donation 134,320 491,656 - - 300,000 State Bond Funds (Met Council) 1,515,408 3,438,998 - - - Totals$1,756,712$4,047,874$ 185,000$ 185,000$ 520,000 Expenditures by Category Court Surfacing/Overlays$ 25,120$ -$ 32,000$ 32,000$ 32,000 Park Furnishings 5,723 - 12,000 12,000 12,000 Park Parking Lot Resurfacing - 109,554 90,000 90,000 130,000 SNC Boardwalk Replacement 252,281 35,136 5,000 5,000 5,000 Security Cameras in Parks - - 30,000 30,000 - Playground Equipment Repairs/Replacement - 52,629 80,000 80,000 150,000 SPRING Project/Springbrook Nature Center 1,562,768 4,061,215 - - 300,000 Totals$1,845,892$4,258,534$ 249,000$ 249,000$ 629,000 Surplus (Deficiency) of Revenues over (under) Expenditures (89,180) (210,660) (64,000) (64,000) (109,000) Reserve for Delayed Projects (projected prior yr savings) - - - - 80,000 Beginning Fund Balance 1,770,140 1,680,960 1,387,260 1,470,300 1,406,300 Ending Fund Balance $1,680,960$1,470,300$1,323,260$1,406,300$1,377,300 Description of Services: The purpose of the Park Capital Improvements budget is to fund repair or replacement of park equipment or park related improvements. The Capital Improvement Plan (CIP) is an integral component for the development of the current year's budget. The CIP is used for planning future expenditures over a multitude of years. The budget is the document that formalizes which projects will proceed. Page 48 Information Technology Capital Projects 409-1213- 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Property Taxes$50,000$50,000$50,000$50,000$50,000 Local Government Aid-149,99386,00086,000150,000 Charges for Services64,96020,31540,70040,700- Miscellaneous -21,110--- Investment Income8292,2961,5001,5001,500 Transfers In125,000207,100--- Totals$240,789$450,814$178,200$178,200$201,500 Expenditures by Category Technology Purchases/Upgrades$274,449$174,278$173,500$173,500$261,000 Office Equipment/HR20,9226,338--12,000 Public Safety Technology73,2207,35545,70045,700- Recreation Equipment-6,465--- Squad Camera Server Upgrade----36,000 Network Security----8,000 Transfer Out--30,00030,000- Totals$368,591$194,436$249,200$249,200$317,000 Surplus (Deficiency) of Revenues over (under) Expenditures (127,802)256,378(71,000)(71,000)(115,500) Reserve for Delayed Projects ---(40,600)- Beginning Fund Balance$331,393$203,591$407,091$459,969$348,369 Ending Fund Balance $203,591$459,969$336,091$348,369$232,869 Description of Services: The Technology Development fund provides for the purchase of replacement computers, local area and wide area network equipment, printers, peripheral devices, telecommunications improvements and software. It also provides for the purchase of new equipment and software that serves the city as a whole, including major office equipment such as copiers and smartboards. Page 49 CAPITAL EQUIPMENT FUND 410 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Local Government Aid$1,040,477$925,000$462,300$462,300$293,300 Investment Income 8852,2947,5007,5007,500 Auction Proceeds--30,00030,00030,000 Sale of Capital Assets93,67043,673--- Transfer from Liquor Stores175,000175,000175,000175,000175,000 Totals$ 1,310,032$1,145,967$674,800$674,800$505,800 Expenditures by Category Police$292,891$313,174$349,300$349,300$181,600 Fire280,443393,033185,500185,50055,000 Public Works Parks Division132,03161,199129,000129,000101,000 Streets Division568,06129,28442,00042,000167,000 Community Development----30,000 Totals$ 1,273,426$796,690$705,800$705,800$534,600 Surplus (Deficiency) of Revenues over (under) Expenditures 36,606349,277(31,000)(31,000)(28,800) Beginning Fund Balance$382,267$418,873$768,150$768,150$737,150 Ending Fund Balance $418,873$768,150$737,150$737,150$708,350 Description of Services: The Capital Equipment Capital Projects Fund was created in 2012 for the purpose of funding replacement or repair of major capital items that are expected to exceed $5,000 in cost. The primary sources of revenue for the fund are Local Government Aid, capital equipment certificates, liquor store profits and tax levy proceeds. The fund also receives earnings from the auction of surplus city property as well as investment earnings. Page 50 CAPITAL EQUIPMENT FUND (410) CIP - Expenditure Detail New or 20152016201720172018 Replacement ActualActualBudgetRevisedBudget ) ( Police (2110) Police Squad / SUV / Pickup$172,924$186,409$188,000$188,000$181,600 Non-Lethal Force Equipment--40,60040,600- Squad Camrea DVR Rplcmt--42,00042,000- Equipment (Radios)74,73581,53378,70078,700- Emergency Sirens45,23245,232--- Total Police$292,891$313,174$349,300$349,300$181,600 Fire (2510) Fire Engine$204,340$330,144$-$-$- Equipment (Radios)-62,88961,50061,500- Rescue Truck4,346-94,00094,00035,000 Rescue Boat29,660---- SCBA Replacement--30,00030,000- 800 MHz Radio Replacement----20,000 Station AlertingNew33,008---- Emergency Response Trailer9,089---- Total Fire$280,443$393,033$185,500$185,500$55,000 Public Works - Parks Division (3172) Mowers$25,538$10,653$-$-$9,000 Pickup Trucks28,34937,32630,00030,00053,000 Dump Trucks with Plows27,553---39,000 Utility Vehicle for Trail PlowingNew--99,00099,000- Utility Vehicles and Equipment50,59113,220--- Total PW - Parks Division$132,031$61,199$129,000$129,000$101,000 Public Works - Streets Division (3174) Pickup Trucks$82,030$29,284$42,000$42,000$- Dump Trucks with Plows207,447---132,000 Heavy Equipment158,410---- Chipper Replacement----35,000 Aerial Equipment120,174---- Total PW-Streets Division$568,061$29,284$42,000$42,000$167,000 Community Development (5110 & 5114) Building Inspection Vehicle $-$-$-$-$30,000 Total Expenditures$1,273,426$796,690$705,800$705,800$534,600 Page 51 Water 601 20152016201720172018 RevenuesActualActualBudgetRevisedBudget NSF Charges$-$1,680$-$-$- Antenna Lease Fees-50--- Interest Earnings25,91946,95420,30020,3005,200 Unrealized Gain/Loss(5,471)4,561--- Sale of Misc Property-1,357--- Miscellaneous335,48813,830--- Water Sales2,736,0163,150,0233,493,4003,392,6003,775,800 Water Flat Rate Sales11,9003,818--- Connect/Reconnect Fees11,6557,7945,0007,8008,000 Penalties/Forfeit Discount87,779103,74988,500104,000105,000 Water Tapping & Misc Fees23,09019,50728,00020,00020,000 Meter Sales15,50013,9478,50014,00014,000 One-Time Set-up Fees16,69514,59512,00015,00015,000 Total Revenues$3,258,571$3,381,865$3,655,700$3,573,700$3,943,000 Expenditures Personnel$664,978$641,659$688,200$672,900$712,300 Supplies380,559365,0231,090,3001,090,300342,300 Other Services/Charges1,876,5711,727,8961,981,9001,955,6002,118,300 Capital Outlay-1,158,010945,0003,207,821935,000 Other Financing Uses154,194---- Debt Service Interest Expense173,207308,066275,076243,600163,700 Total Expenditures$3,249,509$4,200,654$4,980,476$7,170,221$4,271,600 Surplus (Deficiency) of Revenues over Expenditures (less capital)$9,062$339,221$(379,776)$(388,700)$606,400 Ending Cash Balance$1,958,298$7,340,404$6,123,228$2,151,483$2,125,283 Beginning Fund Balance$9,132,135$9,141,197$9,480,418$9,480,418$9,091,718 $9,141,197$9,480,418$9,100,642$9,091,718$9,698,118 Ending Fund Balance Number of Employees (FTEs) 7.807.807.867.867.85 Description of Services: The Water Division provides treatment, distribution, and metering of the City's drinking water to properties within the City of Fridley. The division also maintain water pressure and fire hydrants used for fire suppression throughout the City. 20152016201720172018 Key Measures: ActualActual Projected Revised Projected Average age of distribution mains52.353.254.053.954.7 Water main breaks2327282626 Water service leaks4933403540 Water distributed - millions of gallons1,2581,2991,2591,2401,250 Water sold - millions of gallons1,1571,1171,0771,0501,100 Average meter age2019131212 Water quality complaints95646 Number of filter backwashes441432440396400 Number of reclaim solids pump downs115130125100100 Utility locate requests3,0852,0972,8003,1003,000 Budget Comments/Issues: flow of water from New Brighton. This increased annual operating cost will continue until New Brighton is able to effectively treat their water, which is anticipated to be concluded at the end of 2018. expenses and the ever growing demand for infrastructure refurbishment, staff is recommending a restructuring of rates consistent with the recently completed rate study. residential meters will be AMRs by the end of 2017, and commercial changeouts will continue in 2018. Page 52 City of Fridley, MN Water Fund ActualBudgetProjected 20152016201720182019202020212022 Rates Inflation 3.00%3.00%3.00%3.00% Revenue growth assumption - non-usage2.00%0.00%0.00%0.00%0.00%0.00%0.00% Investment income yield1.25%1.25%1.25%1.25%1.25%1.25%1.25%1.25% Expense growth - general and admin3.00%3.00%3.00%3.00%3.00%3.00%3.00% Expense growth - contractual3.00%3.00%3.00%3.00%3.00%3.00%3.00% Expense growth - non personnel2.00%2.00%2.00%2.00%2.00%2.00%2.00% Beginning net assets9,132,1359,141,1979,480,4159,071,2639,430,2349,826,189 10,230,023 10,632,903 Operating Revenues Water sales2,907,1233,173,3473,411,4003,787,8103,894,2463,985,6314,079,7584,176,709 Miscellaneous Revenues 149,208 142,000 150,000 150,000 150,000 150,000 150,000 Total Operating Revenues2,907,1233,322,5553,553,4003,937,8104,044,2464,135,6314,229,7584,326,709 Operating Expenses Personnel 664,979 641,659 688,200 701,964 723,023 744,714 767,055 790,067 Other1,510,1251,268,3672,065,3981,562,4951,609,3701,657,6511,707,3801,758,602 Depreciation 748,329 824,554 952,5791,157,4121,192,1341,227,8981,264,7351,302,677 Total Operating Expenses2,923,4332,734,5803,706,1773,421,8713,524,5273,630,2633,739,1713,851,346 Net Operations (16,310) 587,975 (152,777) 515,939 519,719 505,368 490,587 475,363 Non operating revenues (expenses) Interest income 20,448 51,515 20,300 5,182 15,261 18,366 17,267 33,803 Sale of assets 331,000 - - - - - - - Interest and other expenses (171,882) (308,065) (276,675) (162,150) (139,025) (119,900) (104,975) (89,650) Connection fees - 7,793 - - - - - - Transfers in / (out) (154,194) - - - - - - - Total non operating revenue (expenses) 25,372 (248,757) (256,375) (156,968) (123,764) (101,534)(87,708) (55,847) Net increase (decrease) in resources 9,062 339,218 (409,152) 358,971 395,955 403,834 402,879 419,516 Ending net assets9,141,1979,480,4159,071,2639,430,2349,826,18910,230,02310,632,903 11,052,419 CIP Funding Purchase of Capital Assets(1,575,370)(1,158,009)(1,705,000)(1,105,000) (350,000) (945,000) (850,000) (940,000) Bond Proceeds -5,978,414 -1,250,000 - -1,300,000 - Capital costs of prior bonds - -(3,196,991) - - - - - Cross over refunding - -(1,722,307) - - - - - Bond P&I - Future - 15 yrs at 3.0% - - - - (104,708) (104,708) (104,708) (104,708) Bond P&I - Future - 15 yrs at 3.0% - - - - - - - (108,897) Bond Prin - Existing (530,000) (555,000) (845,000) (855,000) (885,000) (670,000) (690,000) (705,000) Beginning Cash3,271,1771,958,2987,340,404 414,5331,220,9161,469,2971,381,3222,704,228 Add net operations (16,310) 587,975 (152,777) 515,939 519,719 505,368 490,587 475,363 Add back depreciation 748,329 824,554 952,5791,157,4121,192,1341,227,8981,264,7351,302,677 Add net non operating 25,372 (248,757) (256,375) (156,968) (123,764) (101,534) (87,708) (55,847) Add capital and bond(2,105,370)4,265,405(7,469,298) (710,000)(1,339,708)(1,719,708) (344,708)(1,858,605) Net change in balance sheet items 35,100 (47,071) - - - - - - Ending Cash1,958,2987,340,404 414,5331,220,9161,469,2971,381,3222,704,2282,567,817 Other investments Ending net assets9,141,1979,480,4159,071,2639,430,2349,826,18910,230,02310,632,903 11,052,419 Target minimum working capital 2,300,6172,426,6882,743,9492,610,9632,410,8052,450,8662,595,4732,631,733 Actual working capital-cash balance1,958,2987,340,404 414,5331,220,9161,469,2971,381,3222,704,2282,567,817 Over (Under) target working capital (342,319)4,913,716(2,329,416)(1,390,047) (941,508)(1,069,544)108,756(63,916) Page 53 Sanitary Sewer 602 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Public Works Main't$ -$ -$ -$ -$ - Interest Earnings12,27014,2318,5008,50018,800 Unrealized Gain/Loss(3,846)3,324--- Fixed Asset Gain/Loss10,672---- Sewer Sales4,642,8865,037,6675,392,7005,392,2005,611,500 Sewer Flat Rate Sales89,358161,575113,800114,300114,300 Connect/Reconnect Fees1,2805505005001,000 Penalties/Forfeit Discount73,57491,96385,00085,00090,000 Grant Proceeds-64,644--- Sewer Tapping & Misc Fees2,5817,2401,5001,5006,000 Transfer In154,194---- Total Revenues$ 4,982,969$ 5,381,194$ 5,602,000$ 5,602,000$ 5,841,600 Expenditures Personnel$ 297,123$ 327,980$ 383,200$ 393,800$ 376,710 Supplies44,60149,51762,40052,40052,300 Other Services/Charges4,679,1644,642,5004,968,4004,939,5005,172,706 Capital Outlay-48,441615,000615,000265,000 Other Financing Uses----- Debt Service Interest Expense13,02512,12511,60011,60010,600 Total Expenditures$ 5,033,913$ 5,080,563$ 6,040,600$ 6,012,300$ 5,877,316 Surplus (Deficiency) of Revenues over Expenditures (less capital)$ (50,944)$ 349,072$ 176,400$ 204,700$ 229,284 Ending Cash Balance $ 1,604,174$ 1,677,086$ 1,580,386$ 1,608,686$ 1,983,576 Beginning Fund Balance $ 5,943,091$ 5,892,147$ 6,241,219$ 6,241,219$ 6,445,919 Ending Fund Balance$ 5,892,147$ 6,241,219$ 6,417,619$ 6,445,919$ 6,675,203 Number of Employees (FTEs) 3.653.653.663.663.65 Description of Services: The Sewer Division provides for maintenance of trunk and collector sanitary sewer systems and sanitary sewer lift stations maintained by the City of Fridley. The division also pays for wastewater treatment based on the sanitary sewer flow from the entire City of Fridley. 20152016201720172018 Key Measures: ActualActual Projected Estimated Projected Sanitary sewer main backups12222 Sanitary sewer system cleaning - miles53.447.550.055.853.4 Sanitary sewer lift station failures10001 Sanitary sewer flow - millions of gallons1,6771,6201,6501,6631,650 Televising inspection of sanitary sewers 5.34.85.04.45.0 - miles Average age of sanitary sewer mains49.2550.2151.2151.1951.71 Clay-tile pipe sanitary sewer mains (%)82.1%81.8%81.8%81.8%80.9% Budget Comments/Issues: MCES to the City will amount to over $4.2 million, which amounts to about 80% of the annual sewer operating budget. recommending a restructuring of rates consistent with the recently completed rate study. Page 54 City of Fridley, MN Sewer Fund ActualBudgetProjected 20152016201720182019202020212022 Rates Inflation 3.25%3.25%3.25%3.25% Revenue growth assumption - non-usage2.00%0.00%0.00%0.00%0.00%0.00%0.00% Investment income yield1.25%1.25%1.25%1.25%1.25%1.25%1.25%1.25% Expense growth - general and admin.3.00%3.00%3.00%3.00%3.00%3.00%3.00% Expense growth - contractual3.00%3.00%3.00%3.00%3.00%3.00%3.00% Expense growth - non personnel2.00%2.00%2.00%2.00%2.00%2.00%2.00% MCES growth assumption4.00%4.00%4.00%4.00%4.00% Beginning net assets 5,943,094 5,892,147 6,151,221 6,340,084 6,616,910 6,890,734 7,135,360 7,359,464 Operating Revenues Sewer charges 4,809,679 5,199,242 5,392,700 5,622,034 5,804,750 5,993,404 6,188,190 6,389,306 Flat rate sales 114,300 114,300 114,300 114,300 114,300 114,300 Miscellaneous Revenues - 99,203 86,500 86,500 89,311 92,214 95,211 98,305 Total Operating Revenues 4,809,679 5,298,445 5,593,500 5,822,834 6,008,361 6,199,918 6,397,701 6,601,911 Operating Expenses Personnel 297,122 327,979 383,200 394,696 406,537 418,733 431,295 444,234 Supplies and other charges Disposal 3,688,859 3,938,323 4,117,087 4,232,781 4,402,092 4,578,176 4,761,303 4,951,755 Other 725,282 545,499 527,800 543,634 559,943 576,741 594,044 611,865 Depreciation 309,628 298,194 371,900 383,057 394,549 406,385 418,577 431,134 Total Operating Expenses 5,020,891 5,109,995 5,399,987 5,554,168 5,763,121 5,980,035 6,205,218 6,438,988 Net Operations (211,212) 188,450 193,513 268,666 245,240 219,883 192,482 162,923 Non operating revenues (expenses) Interest income 8,424 17,555 8,500 18,786 38,159 33,268 39,097 45,447 Sale of assets 10,672 - - - - - - - Interest and other expenses (13,025) (12,125) (13,150) (10,625) (9,575) (8,525) (7,475) (6,350) Connection fees - 550 - - - - - - Intergovermental 64,644 Transfers in / (out) 154,194 - - - - - - - Total non operating revenue (expenses) 160,265 70,624 (4,650) 8,161 28,584 24,743 31,622 39,097 Net increase (decrease) in resources (50,947) 259,074 188,863 276,826 273,824 244,625 224,104 202,020 Ending net assets 5,892,147 6,151,221 6,340,084 6,616,910 6,890,734 7,135,360 7,359,464 7,561,484 CIP Funding Purchase of Capital Assets (250,191) (48,441) (615,000) (265,000) (925,000) (50,000) (665,000) (125,000) Bond Proceeds - - - 1,190,000 - - 665,000 - Bond P&I - Future - 15 yrs at 3.0% - - - - (99,682) (99,682) (99,682) (99,682) Bond P&I - Future - 15 yrs at 3.0% - - - - - - - (55,705) Bond Prin - Existing (30,000) (30,000) (30,000) (35,000) (35,000) (35,000) (35,000) (40,000) Beginning Cash 1,053,825 1,604,174 1,587,087 1,502,850 3,052,733 2,661,424 3,127,752 3,635,751 Add net operations (211,212) 188,450 193,513 268,666 245,240 219,883 192,482 162,923 Add back depreciation 309,628 298,194 371,900 383,057 394,549 406,385 418,577 431,134 Add net non operating 160,265 70,624 (4,650) 8,161 28,584 24,743 31,622 39,097 Add capital and bond (280,191) (78,441) (645,000) 890,000 (1,059,682) (184,682) (134,682) (320,387) Net change in balance sheet items 571,859 (495,914) Ending Cash 1,604,174 1,587,087 1,502,850 3,052,733 2,661,424 3,127,752 3,635,751 3,948,518 Other investments Ending net assets 5,892,147 6,151,221 6,340,084 6,616,910 6,890,734 7,135,360 7,359,464 7,561,484 Target minimum working capital 2,397,757 2,449,051 2,559,669 2,729,813 2,827,493 2,928,982 3,095,058 3,204,414 Actual working capital-cash balance 1,604,174 1,587,087 1,502,850 3,052,733 2,661,424 3,127,752 3,635,751 3,948,518 Over (Under) target working capital (793,583) (861,964) (1,056,819) 322,920 (166,070) 198,770 540,693 744,104 Page 55 Storm Water 603 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Storm Sewer Collection$1,207,193$1,307,874$1,294,000$1,333,000$1,379,000 Harris Pond Assessments3,8113,9653,0003,0003,000 Storm Sewer Penalties12,96912,52015,00015,00014,000 Special Assessment2,057---- Interest Earnings20,50522,40612,00012,00012,000 Unrealized Gain/Loss(6,445)5,755--- Direct to City-Principal2,5601,453--- Grants Proceeds93,403189,69880,000500,000200,000 Other Reimbursements1,000---- Miscellaneous Revenue18051--- Storm Sewer Misc Fees-50--- Total Revenues$1,337,233$1,543,772$1,404,000$1,863,000$1,608,000 Expenses Personnel$393,151$444,384$464,600$478,400$481,400 Supplies16,4265,55012,30015,00015,000 Other Services/Charges366,200571,433566,700605,200746,700 Capital Outlay-511,331825,0001,325,0001,345,000 Other Financing Uses----- Debt Service Interest Expense9,8509,1008,7008,7007,900 Total Expenditures$785,627$1,541,798$1,877,300$2,432,300$2,596,000 Surplus (Deficiency) of Revenues over Expenses (less capital)$551,606$513,305$351,700$755,700$357,000 Ending Cash Balance$1,963,161$2,024,475$1,890,975$1,803,975$1,308,875 Beginning Fund Balance$5,815,098$6,366,704$6,880,009$6,880,009$7,635,709 $6,366,704$6,880,009$7,231,709$7,635,709$7,992,709 Ending Fund Balance Number of Employees (FTEs)5.065.065.055.055.03 Description of Services: The Storm Water division provides for maintenance of trunk and collector storm sewer systems maintained by the City of Fridley. The division also establishes and maintains improvements and programs provided to meet storm water quality goals of the City of Fridley. 20152016201720172018 Key Measures:ActualActual Projected Revised Projected Street sweeping collected - cubic yards1,9272,5432,0001,8002,200 Sediment collected from storm water treatment devices - cubic yards2422202020 Outfall inspections2841252525 Rain gardens constructed44331 Erosion control inspections2018181230 Enforcement actions and notices568310 Budget Comments/Issues: Page 56 (495,600)(4,800)(488,400) 1,583,00021,0001,604,00016,2001,076,2502,099,60012,0002,094,6362,508,473 10.6131.83521,000260,200225,9507,200413,837803,463 2,504,363 Projected -- 20222.00% 3.5% (309,050)(5,600)(302,650) 1,549,000 10.2530.751,529,00020,000510,80015,900255,100865,600210,6501,858,05012,0006,4001,801,024293,6122,094,636876,4882,343,638 Projected -- 2021 2.00% 3.5% (229,200)(6,400)(223,600) 9.901,477,00019,0001,496,000500,80015,6001,725,20012,0001,604,0371,801,0242,176,613 29.71343,200679,700185,9005,600196,987881,213 Projected -- 20202.00% 3.5% (7,200) 1,445,000 9.5728.711,427,00018,000491,00015,300238,400517,900161,8001,424,40020,60012,00080025,4001,308,900295,1371,604,037789,5131,841,563 Projected -- 4, 20192.00% 3.5% (7,900)(495,112) 9.241,379,00017,0001,396,000481,40015,0001,243,10012,0001,804,0121,308,9001,740,5122,621,012 27.74228,800373,800144,100152,900200,000204,100357,000 Budget - 20182.00% 3.5% (8,700)(594,463) 8.931,332,00019,0001,351,000464,60012,30080,0001,052,60080,00012,00083,3002,024,4751,430,0121,698,0632,411,263 26.80201,900293,800298,400381,700 Budget - 20172.00% 4% (9,100) 8.591,307,87416,5861,324,460444,3841,021,36728,1611,963,16161,3142,024,4751,567,109 25.775,550298,295273,138303,093189,6981,453210,212513,305919,857 Actual 20162.00% 0% (9,850) 8.591,223,9731,225,153393,15193,40314,0601,427,4871,963,161 25.771,180130,195252,430775,776449,3774,616102,229551,606535,674775,776 Actual - 2015 75% REVENUE/ EXPENSE PROJECTIONS AND CASHFLOW Residential Rate Per Lot (REF considered 1/3) Per Qtr Cash Balance Ideal (One-year Operating/DS/Capital) Cash Balance Floor (Operating & Debt Service) Total Non-Operating Revenues/Expenses Cash and Cash Equivalents December 31 Change in Depreciation (Since Base Year) Cash and Cash Equivalents January 1 Commericial Rate Per Acre Per Quarter STORM WATER FUND PROJECTIONS Estimated Expenditure Change (%) Non-Operating Revenues (Exps.) Net Increase (Decrease) in cash Actual Depreciation (Base Year) Rate Change Projections (%) Total Operating Revenues Total Operating Expenses Special Assessments Levied ervices and Charges Debt Service (interest only) Intergovernmental revenue Operating Revenues Operating Expenses ating Income Storm Water Sales Personal Services CITY OF FRIDLEY Interest Income Other Revenue Net Income Supplies 10/23/17 S Other Oper Page 57 Municipal Liquor 609 (Fridley Market & Moore Lake Locations) 20152016201720172018 RevenuesActualActualBudgetRevisedBudget Liquor Sales$1,764,217$1,908,217$2,064,400$2,034,400$2,120,000 Wine Sales799,064836,125863,500863,500880,000 Beer Sales2,541,8342,529,7782,693,3002,603,3002,810,800 Miscellaneous Sales103,279111,977120,100120,100122,000 Dep/RTNS/Cooperage634490100100500 Cigarette Sales40,97946,16151,30051,30053,000 Cigars/Chewing Tobacco6,1427,1978,10010,10010,500 Cash Over/(Short)(839)(817)200200200 Sales Tax Over/(Short)28237--- Interest Earnings(375)(1,584)--- Unrealized Gain/Loss16566--- Miscellaneous Revenue13,217462--- Total Revenues$5,268,345$5,438,309$5,801,000$5,683,000$ 5,997,000 Expenditures Personnel$501,470$502,985$580,200$557,300$605,610 Supplies17,85413,86132,60027,60031,300 Other Services/Charges4,387,8784,489,6644,858,1004,714,1005,014,400 Capital Outlay-95,859--56,000 Other Financing Uses338,600338,500338,500338,500338,500 Total Expenditures$5,245,802$5,440,869$5,809,400$5,637,500$ 6,045,810 Surplus (Deficiency) of Revenues over Expenditures (less capital)$22,543$93,299$(8,400)$45,500$7,190 Ending Cash Balance$137,754$169,069$241,769$301,669$340,159 Beginning Fund Balance$890,870$913,413$1,006,712$1,006,712$1,052,212 $913,413$1,006,712$998,312$1,052,212$1,059,402 Ending Fund Balance Number of Employees (FTEs)5.005.005.005.006.00 Description of Services: The Fridley Municipal Liquor Operations was established in 1949. The operations consist of two retail locations with annual sales exceed $5 million. Net proceeds are directed back to the City's General Fund to alleviate the property tax burden on its citizens and businesses. 20152016201720172018 Key Measures:ActualActual Projected Revised Projected Total customers268,226275,168292,924305,296313,308 Average sale price per customer$19.59$19.61$19.80$19.24$19.08 Gross profit percentage25.8%26.3%25.0%26.75%26.50% Net profit percentage before transfers6.9%8.0%7.0%7.50%6.50% Budget Comments/Issues: 2018 budget. ticket count for the Fridley Market location. The Moore Lake location is not open on Sunday, and will maintain its average ticket and customer counts in 2018. increase at our Moore Lake store location. competition from the national liquor retailers. Page 58 STAFFING LEVELS - 2015-2018 Full-Time Equivalents (FTEs) 20152016201720172018% of Service CategoryBudgetary UnitActualActualBudgetRevisedBudgetTotal Public Safety Police52.652.452.3552.3552.10 Police Activity Fund1.001.001.001.001.00 1 Fire 7.007.007.007.007.02 Subtotal 60.6060.3560.3560.3560.1242.7% Public Works: Municipal Center1.531.531.791.791.81 Engineering1.781.782.142.142.13 Park Maintenance5.835.835.825.825.81 Street Maintenance8.268.268.538.538.52 Garage Maintenance3.783.783.833.833.82 Street Lighting0.260.260.270.270.26 Water Utility7.807.807.867.867.85 Sewer Utility3.653.653.663.663.65 Storm Water Utility5.065.065.055.055.03 Subtotal 37.9537.9538.9538.9538.8827.5% Parks & Recreation:Recreation Department5.505.505.505.505.50 Springbrook Nature Center3.503.503.503.504.70 Subtotal 9.009.009.009.0010.206.4% Comm Development:Planning4.454.855.105.104.35 Building Inspections3.003.003.003.003.00 Rental Inspection1.601.601.601.602.10 Solid Waste Abatement0.500.500.500.500.50 2 HRA Assist. Executive Director 1.001.001.001.001.00 Subtotal 10.5510.9511.2011.2010.957.9% 3 General Government:Mayor & City Council 5.005.005.005.005.00 General Management2.002.002.002.002.00 City Clerk1.001.001.001.001.00 Human Resources2.002.002.002.002.00 Cable TV1.702.002.002.002.00 Accounting6.505.505.505.505.50 Assessing2.502.502.502.502.30 IT2.002.002.002.002.00 Municipal Liquor Store5.005.005.005.006.00 Subtotal 22.7022.0022.0022.0022.8015.5% TOTALS 140.8140.3141.5141.5142.95100% 1 Excludes paid on-call firefighters 2 HRA Assistant Executive Director is funded through the HRA levy and not a part of the City's budget 3 Mayor and council members are excluded from FTE totals 4 Excludes election judges Page 59 CITY OF FRIDLEY 2018 Budget Calendar March 20Goals & Objectives Conference Meeting with Council April 7Capital Improvement Program (CIP) forms sent to departments April 21Departments submit capital requests to City Manager and Finance Department May 2Discuss CIP requests via group department manager meeting May 20"Fridley Forum" to Council to address finances, the environment and comprehensive plan with citizens Operating budget work papers, budget request forms are made available to May 26 departments Send request to departments for indicators and key measures July 62018-22 Preliminary CIP sent to City Council July 10City Council budget work session to discuss 2018-22 CIP and establish targets for the General & Enterprise Funds July 17Forecasts completed for compensation and benefits, revenue projections, utility costs, etc August 1Department of Revenue notifies City of State Aid August 28Levy scenerio discussion with Council at conference meeting September 1Department of Revenue notifies City of any applicable levy limit September 1Preliminary budget memo sent to City Council September 11Budget work session to review proposed budget & preliminary levy September 11City Council adopts final 2018-22 CIP September 11Adopt HRA levy September 15Budget instructions and targets provided to departments September 15HRA Levy submitted to County September 25Utility Rate Study presented to Council at conference meeting September 25City Council adopts preliminary levy and budget, and annouces public budget meeting date September 29City Levy submitted to County October 6Departments submit detailed budget requests Week of November 6City Manager sends proposed 2018 budget and revised 2017 budget to city council members Week of November 13Anoka County sends parcel specific proposed tax estimates to taxpayers November 13City Council budget conference meeting to discuss operational budget November 13City Council adopts 2018 utility rates (Water, Sewer, Storm Water & Recycling) November 27City Council holds public meeting on 2018 budget and levy December 11City Council adopts final 2018 budget, tax levy and revised 2017 budget December 28Final 2018 levy certified to Anoka County (and Form TNT) Updated SP 11/07/17 Page 60