Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
ITEM 1 attach_6 Draft - Final Water Fund Budget (11-18-2015)
City of Otsego Water Utility Fund Budget Summary December 31, 2016 Fund Account Description REVENUES 601 37150 Water Sales 601 37155 Water Sales - Irrigation 601 37160 Water NSF 601 31900 Penalties and Interest OPERATING 601 34109 Other Administrative Charges 601 34302 Water Meters 601 36100 Special Assessments 601 36102 Special Assessments - P & 1 601 36210 Investment Interest 601 36213 Change in Investments FMV 601 36232 Developer Contributions 601 37165 Water Tower Leases 601 37170 DNR Fees Collected 601 38990 Miscellaneous 601 38991 Refunds & Reimbursements NON -OPERATING TOTAL REVENUES EXPENDITURES 601 49400 101 Full -Time Employees 601 49400 102 FT Overtime 601 49400 104 Part -Time Employees 601 49400 119 Payroll Allocation 601 49400 121 PERA 601 49400 122 FICA 601 49400 123 Health 601 49400 130 Other Insurance 601 49400 140 Unemployment Compensation 601 49400 150 Workers Compensation PERSONAL SERVICES 601 49400 201 Office Supplies 601 49400 202 Fuel 601 49400 206 Postage 601 49400 210 Operating Supplies 601 49400 216 Chemical Supplies 601 49400 220 R & M Supplies 601 49400 225 Uniform/Clothing Allowance 601 49400 227 Safety Supplies 601 49400 228 Utility System Supplies 601 49400 240 Small Tools and Equipment 601 49400 298 Fleet Expenses SUPPLIES Actual Actual Actual Budget YTD - Nov Proposed 2012 2013 2014 2015 2015 2016 2015 Comments 2016 Comments 838,013 862,413 883,966 1,052,500 866,808 925,000 - 139,419 106,747 75,000 129,647 90,000 (85) 43 (565) - 82 - 30,047 35,281 35,000 33,245 30,000 837,928 1,031,921 1,025,429 1,162,500 1,029,782 1,045,000 1,684 15,313 15,225 - 10,400 - 57,219 70,313 70,056 68,000 66,041 88,400 79,090 72,224 (4,551) - 40,224 - 12,226 4,095 6,168 - 17,226 30,272 42,919 - (38,665) - - - 42,530 - - - 55,168 64,050 52,538 60,000 61,061 66,000 - 16,422 17,426 18,600 18,597 19,080 6,082 2,600 13,185 - 692 - 1,078 228,695 236,625 255,496 146,600 198,093 173,480 1,066,624 1,268,547 1,280,926 1,309,100 1,227,875 1,218,480 27,826 78,353 27,060 47,720 39,156 61,983 - - 709 1,100 1,333 1,250 - - 2,032 300 900 - 24,960 3,750 - - - - 2,008 4,979 2,080 3,662 3,438 4,742 1,921 5,613 2,086 3,758 3,086 4,837 2,458 5,257 3,087 8,679 - - 161 663 274 - 5,411 7,777 322 717 2,142 1,905 3,029 59,334 98,936 38,046 67,361 55,229 83,618 7,036 11,651 11,203 10,000 2,631 5,000 202 162 - 6,833 2,766 2,963 4,595 4,720 6,261 6,600 4,672 8,820 41,061 99,139 108,994 4,110 15,809 9,200 - - - 58,000 48,295 60,000 7,850 5,152 2,555 14,820 13,570 15,000 1,254 901 1,100 1,197 1,475 809 319 1,000 1,020 1,500 - - 45,000 57,221 65,700 8,065 4,929 500 2,551 400 - 3,322 2,600 544 2,600 60,744 130,951 138,484 150,563 150,277 172,658 2.5% Rate Increase (2/11/13) No rate increase. Conservative Increase Slight Decrease to be Conservative 170 Meters at $400 200 Meters at $442 Sprint / Verizon / Nextera 2,924 Connections at $6.36 3,000 Connections at $6.36 (9/29/15) 25 % of Utility Employees 25 % of Utility Employees Utility Total - $4,400 Utility Total - $5,000 Utility Total - $1,650 7.50 % of Gross Wages 7.65% of Gross Wages Health / Dental / LTD / STD / Life Based on 7/1/15 - 7/1/16 Invoice General Office / Printer Ink / Envelopes / Folding Machine Lease 50% of 3,644 Gallons at $3.75 25% of 3,950 Gallons at $3.00 50% of 2,200 Monthly Bills at $0.49 50% of 3,000 Monthly Bills at $0.49 See Attachment See Attachment See Attachment Transducer / Variable Frequency Drive 1 Hanging Heaters / Chemical Pumps 50% of 4 Staff Allowances of $550 50% of 5 Staff Allowances of $550; Additional $200 for New Staff Arc Flash suit/traffic vest/ear plugs/glasses, Traffic Vests / Ear Plugs / Safety Glasses / 1 st aid kit supplies, insolated tools, trench 1st Aid Kits / Arc Flash PPE / Cones box (1/2), tripod 170 Meters at $260 225 Meters at $292 (200 New / 25 Replace) Hydrant king nut stop removal / Drill Hose Bander ($200) / Valve Cutter ($200) 8 oil changes@ $40e, 4 fire rotate @ $15e, 8 oil changes@ $40e, 4 tire rotate @ $15e, Jet Vac oil $420, Crane truck cable, Air Jet Vac oil $420, Crane truck cable, Air Filter, Light, Battery, Brakes, wheel well Filter, Light, Battery , Brakes, wheel well paint, trany flush@$200.(1/2). Fuel moved paint, trany flush@$200.(1/2). Fuel moved to 402 to 402 U:\Budget\2016\Utility Funds\Water Water Fund Summary 601 49400 301 Legal 232 462 500 500 601 49400 302 Engineering Fees 7,145 1,920 42,550 15,000 35,939 5,000 WHP amendment 2 601 49400 303 Planning Fees 750 175 - 500 - - 601 49400 306 Permits & Fees 7,713 150 25,296 29,000 20,715 27,580 DNR Appropration 9000/Tierll DNR ($8,000) / Tier II (4 @ $100) / MDH 4x125=500/MDH connectionfees (6.36 per (3,000 @ $6.36) / Well Permits (2 @ $50) connection@2724 in 2014) estimating 2924 2015; 2 well maintenance permits 50e 601 49400 315 GIS Services 190 2,501 1,647 3,000 450 4,000 601 49400 320 Telephone - 2,181 2,593 2,301 2,257 3,420 2 hard lines @ 213.53/ mo=2562.36 50 % - Hard Lines ($220 Month) / Cell 4 cell = [(50+40(3)]x12=2040 Phones (5 @ $50 Month) / New Devices ($1,200) 601 49400 321 Mileage & Travel - 91 - - - - 601 49400 322 Utilities 50,368 54,189 69,607 57,000 52,649 59,000 601 49400 350 Print & Publishing 2,559 265 - 300 - 300 601 49400 355 Dues & Memberships 392 623 629 340 328 352 MRWA=$225/2 MMUA $404/2; AWWA $25 50%- MMUA ($400 / 3) / MRWA ($260) AWWA ($25) 601 49400 360 Education/Training/Conferences - 650 2,076 2,859 5,749 1,500 MMUA allocation for safety training = CEU (5 @ $300) 3718/2 250 x 4 = 1000 601 49400 361 Liability & Property Insurance 6,690 - 8,046 6,268 4,408 10,688 5% Increase + More In Depth Allocation 601 49400 375 Water Test Fee 437 16,240 - - - - Moved to Line Item 306 601 49400 390 Contracted Services 207,144 117,551 51,213 58,600 38,562 83,580 See Attachment See Attachment 601 49400 402 Repairs & Maintenance Services - 4,755 571 - 328 - 601 49400 410 Rentals - 38 - 601 49400 430 Miscellaneous - 1,566 - 601 49400 437 Bank Service Charges - - - - 4,399 8,400 50 % - Credit Card Fees / PSN Online Payment Fees / ACH / Bank Service Charges @ $1,400 Monthly SERVICES & OTHER CHARGES 283,621 201,754 204,265 175,668 167,351 204,320 601 49400 420 Depreciation 473,379 475,224 472,761 502,200 - 510,000 Rough Estimate of 2% Growth Rough Estimate of 2% over 2015 Budget. 601 49400 501 Equipment - 320 - - - 19,600 See Attachment 601 49400 530 Improvements Other Than Buildings - 12,542 428,600 Based on Draft 2016 CIP 601 49400 550 Motor Vehicles - 8,750 Based on Draft 2016 CIP 601 49400 602 Bond Interest - - 424,914 - - All Debt Service Paid from WAC Fund 601 49400 720 Operating Transfers 9,800 - 52,889 56,638 30,800 43,439 Reimburse General Fund ($56,638) Reimburse General Fund ($33,439) / Jet Vac Debt Transfer ($10,000) OTHER 483,179 475,544 525,650 983,752 43,342 1,010,389 TOTAL EXPENDITURES 886,878 907,184 906,446 1,377,344 416,198 1,470,985 CHANGE IN FUND NET ASSETS 179,745 361,362 374,480 (68,244) 811,677 (252,505) Fund Cash Balance 1,823,474 2,539,591 3,327,541 4,059,125 U:\Budget\2016\Utility Funds\Water Water Fund Summary City of Otsego Water Utility Fund Cash Flow Summary Revised: November 18, 2015 Rate Increase 2.50 % 2.50 % 2.50% 0.00 % 0.00 % 0.00 % 0.00 % Base Charge $ 8.00 $ 8.20 $ 8.41 $ 8.62 $ 8.62 $ 8.62 $ 8.62 $ 8.62 $ 8.62 Consumption Charge (0-10) $ 1.60 $ 1.54 $ 1.58 $ 1.62 $ 1.62 $ 1.62 $ 1.62 $ 1.62 $ 1.62 Consumption Charge (10+) $ 1.60 $ 1.64 $ 1.68 $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.72 Actual Actual Actual Projected Projected Projected Projected Projected Projected 2012 2013 2014 2015 2016 2017 2018 2019 2020 Comments Operating Revenues Water Sales $ 838,013 $ 862,413 $ 883,966 $ 925,000 $ 925,000 $ 925,000 $ 925,000 $ 925,000 $ 925,000 2015 Budget was $1,052,000 Water Sales - Irrigation - 139,419 106,747 75,000 90,000 90,000 90,000 90,000 90,000 Conservative Increase in 2016 Penalties and Interest - 30,047 35,281 35,000 30,000 30,000 30,000 30,000 30,000 Small Decrease in 2016 to be more Conservative. Other (85) 43 (565) Subtotal 837,928 1,031,922 1,025,429 1,035,000 1,045,000 1,045,000 1,045,000 1,045,000 1,045,000 Nonoperating Revenues Antenna Leases 55,168 64,050 52,538 60,000 66,000 66,000 66,000 66,000 66,000 2016 Projection - Then Flat Water Meter Sales 57,219 70,313 70,056 68,000 88,400 88,400 88,400 88,400 88,400 200 Meters @ $442. Special Assessments 91,316 76,319 1,617 - - - - - - Investment Interest (Net) 17,226 (8,393) 42,919 - - - - - - Other 7,766 34,335 88,366 18,600 19,080 19,080 19,080 19,080 19,080 Total 1,066,623 1,268,546 1,280,925 1,181,600 1,218,480 1,218,480 1,218,480 1,218,480 1,218,480 Expenses Personal Servcies 59,334 98,936 38,046 67,361 83,618 85,290 86,996 88,736 90,511 2016 Prelim Budget - Then 2% Inflation Supplies 60,744 130,951 138,484 150,563 172,658 176,111 179,633 183,226 186,891 2016 Prelim Budget - Then 2% Inflation Services & Other Charges 283,621 201,754 204,265 175,668 204,320 208,406 212,575 216,826 221,163 2016 Prelim Budget- Then 2% Inflation Depreciation 473,379 475,224 472,761 502,200 510,000 510,000 510,000 510,000 510,000 2016 Projection - Then Flat Capital Outlay 8,550 24,519 18,055 - - - - - - Capital Outlay (CIP) - - - - 456,950 - 689,585 250,000 510,000 Based on Draft 2016 CIP Nonoperating - - - - - - - - - Transfers Out - - 52,889 56,638 33,439 40,000 40,000 40,000 40,000 Transfer to General Fund for staff reimbursement. Transfers Out - Jet Vac 9,800 30,800 10,000 9,800 9,600 8,200 Transfer to Debt Fund 399 for Jet Vac Total 895,428 931,384 924,500 983,230 1,470,985 1,029,608 1,728,389 1,296,988 1,558,564 Cash Balance - Beginning 1,166,092 1,823,474 2,539,591 3,327,541 4,028,111 4,285,606 4,984,478 4,984,569 5,416,061 Balance Sheet Effects 12,808 (96,269) (41,236) Revenues 1,066,623 1,268,546 1,280,925 1,181,600 1,218,480 1,218,480 1,218,480 1,218,480 1,218,480 Expenditures (895,428) (931,384) (924,500) (983,230) (1,470,985) (1,029,608) (1,728,389) (1,296,988) (1,558,564) Noncash - Depreciation 473,379 475,224 472,761 502,200 510,000 510,000 510,000 510,000 510,000 Cash Balance - Ending $ 1,823,474 $ 2,539,591 $ 3,327,541 $ 4,028,111 $ 4,285,606 $ 4,984,478 $ 4,984,569 $ 5,416,061 $ 5,585,977 Current Cash = $4,059,125 Water Utility 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 2012 2013 2014 2015 2016 2017 2018 2019 2020 Expenses ll� Operating Revenues tCash Balance - Ending