Loading...
HomeMy WebLinkAbout6B 2016 Preliminary Year-End Financial PresentationApril 24, 2017 1 General Fund Revenues Expenditures Reserves Other Funds Enterprise Funds EDA Agenda 2 Revenues exceeded expenditures by $560k Revenues -101.6% of budget Expenditures -95.5% of budget 2016 General Fund 3 Rev vs. Exp 4 2012 2013 2014 2015 2016 Revenues 12,871,570 11,732,430 12,355,519 12,691,919 12,977,951 Expenditures 13,646,417 12,273,537 13,010,133 12,343,813 12,417,778 10,500,000 11,000,000 11,500,000 12,000,000 12,500,000 13,000,000 13,500,000 14,000,000 Revenues Expenditures Revenues 5 Revenue Category Variance Favorable/(Unfavorable) Property Taxes $13,700 Licenses and Permits 121,300 Intergovernmental 46,500 Charges for Services (incl. franchise taxes)33,200 Interest (loss) on Investments (22,900) Fines and Forfeitures 4,700 Miscellaneous Revenue 5,700 Total $ 202,200 Expenditures 6 Expenditure Category Variance Favorable/(Unfavorable) Subtotals by Category Personnel: Employee Turnover, Hiring Delays, etc. $134,000 Other Wages 77,500 Benefit Savings 62,000 Overtime (117,000) Other 1,500 Total Personnel $ 158,000 Current Expenditures: Maintenance Agreements -Street $146,700 Fuel 99,100 Legal / Prosecution Fees 52,600 Operating Supplies –Snow & Ice 32,000 Utilities –Electric and Gas 25,000 Software Service Contract 28,700 Utilities –Park Lighting (39,400) Major Service Contract -Fleet (25,300) Other 85,200 Total Current Expenditures $ 404,600 Capital Outlay Expenditures: Park Improvements & Equipment $ 87,700 Technology 15,900 Other (600) Total Capital Outlay Expenditures $ 103,000 Other (Transfers Out)(74,600) Total Expenditures $ 591,000 Beginning Balance -$6.04M Ending Balance -$6.68M* Reserve Calculation –51.1% CFMP specifies a range between 40% and 50% 2016/17 Budget Amendments ($390,000) Current Balance -$6.3M (48%) *Not Including Budget Amendments General Fund Reserve* 7 General Fund Reserve* 8 $12,188,313 $12,729,968 $12,192,316 $12,985,255 $12,563,945 $12,945,738 $13,070,878 58% 61% 57% 50% 46% 47% 51% $11,500,000 $11,750,000 $12,000,000 $12,250,000 $12,500,000 $12,750,000 $13,000,000 $13,250,000 $13,500,000 2010 2011 2012 2013 2014 2015 2016 Subsequent Year’s Budget Actual Fund Balance * Does not include 2016/17 Budget Amendments Debt Service Issued 2016A Bonds ($3.5 million) Cable Fund Franchise Audit ($45k) Capital Park Enclave Park Improvements Markley Lake Trail Revolving Equipment Equipment purchases approved early 2016 ($1 million) Facilities Management GESP Improvements 100% Complete Other Funds 9 Water Sewer Storm Water Enterprise Funds 10 Total Revenues -$6.31M Water Charges -$3.33M Contributions -$2.55M Total Expenditures -$4.24M Operating -$2.41M Transfers -$1.83M Water 11 Water 12 Infrastructure Projects CIP Ref Budget Actual Comments Manitou Road CIP#10 $250,000 $578,167 Substantially Complete Raspberry Ridge, etc. CIP#10 800,000 0 Project Deferred Welcome Ave CIP#10 0 243,779 Final project funding TH13/150th Street CIP#10 0 87,310 Final project funding Source Water – Well #10 950,000 Project Deferred Total $2,000,000 $909,256 Total Revenues -$4.66M City Sewer Charges -$1.3M MCES Charges -$1.18M Total Expenditures -$3.27M Operating -$2.55M Transfers -$631k Sewer 13 Sewer 14 Street Reconstruction Projects CIP Ref Budget Actual Comments Manitou Road CIP#10 $150,000 $364,455 Substantially Complete Raspberry Ridge, etc. CIP#10 150,000 0 Project Deferred Total $300,000 $364,455 Storm Water 15 Total Revenues -$984k Storm Water Charges -$917k Contributions -$62k Total Expenditures -$757k Operating -$589k Transfers -$168k Storm Water 16 Street Reconstruction Projects CIP Ref Budget Actual Comments Manitou Road CIP #10 $50,000 $56,768 Substantially Complete Raspberry Ridge, etc. CIP #10 50,000 0 Project Deferred Rolling Oaks CIP #10 100,000 Project Deferred Cates Creek CIP #10 75,000 $0 2017 Project Total $275,000 $56,768 2016 Budget -$181,425 Tax Levy -$155,000 Use of Fund Balance -$15,925 Revenues -$170,584 Expenditures -$151,167 Tech Village -$8,830 Economic Development Authority 17 18 Beginning Balance -$6.68M 2016 Parks, Technology, Bridge Repair -$156k Mill & Overlay -$120k 2017 Community Survey -$10.5k Compensation Study -$28k CR 21/TH 13 Consultant -$75k OPEB –35% Funded Ending Balance -$6.3M (48%) Budget Amendments 19