Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Packet - Water Fund
City of Otsego Enterprise Fund Budget - 2018 Department Requests Water Utility Account Number 49400 - Water Utilitv Fund Fund Department Source Account Revenues 601 49400 601 49400 601 49400 601 49400 TOTAL - OPERATING 601 49400 601 49400 601 49400 601 49400 601 49400 601 49400 601 49400 601 49400 601 49400 601 49400 601 49400 TOTAL - NON OPERATING 37150 WATER SALES 37155 WATER SALES - IRRIGATION 37160 WATER NSF 31900 PENALTIES AND INTEREST 34109 OTHER ADMINISTRATIVE CHARGES 34302 WATER METERS 36100 SPECIAL ASSESSMENTS 36102 SPECIAL ASSESSMENTS - P&I 36210 INTEREST EARNINGS 36213 NET CHANGE IN INVESTMENT FMV 36232 CAPITAL CONTRIB. DEVELOPERS 37165 WATERTOWER RENTALS -ANTENNAS 37170 DNR FEES FOR STATE 38990 OTHER MISCELLANEOUS 38991 REFUNDS & REIMBURSEMENTS TOTAL -REVENUES Expenses 910,963 $ 985,788 $ 995,850 $ 601 49400 101 FULL-TIME EMPLOYEES REGULAR 601 49400 102 WAGES - FT OVERTIME 601 49400 104 WAGES - PT EMPLOYEES 601 49400 119 PAYROLL ALLOCATION 601 49400 121 PERA 601 49400 122 FICA AND MEDICARE 601 49400 123 HEALTH 601 49400 130 OTHER EMPLOYER PAID INS 601 49400 150 WORKERS COMPENSATION 601 49400 191 GERF PENSION EXPENSE TOTAL -PERSONAL SERVICES (27,131) 2,701 601 49400 201 OFFICE SUPPLIES AND EXPENSES 601 49400 202 FUEL 601 49400 206 POSTAGE 601 49400 210 OPERATING SUPPLIES 601 49400 216 CHEMICAL SUPPLIES 601 49400 220 REPAIRS/MAINTSUPPLIES 601 49400 225 UNIFORMS/CLOTHING ALLOWANCE 601 49400 227 SAFETY SUPPLIES 601 49400 228 UTILITY SYSTEM SUPPLIES 601 49400 240 SMALL TOOLS/EQUIPMENT 601 49400 298 W/S FLEET EXPENSES TOTAL - SUPPLIES 1,000 1,500 586 Requested Actual Actual Year -to -Date Budget Budget 2015 2016 2017 2017 2018 $ 893,586 $ 910,963 $ 985,788 $ 995,850 $ 1,160,124 129,647 118,999 155,927 119,000 135,000 (107) 45 60 - - 36,230 38,622 34,850 39,000 39,000 1,059,356 1,068,629 1,176,625 1,153,850 1,334,124 10,550 10,488 8,500 - - 75,460 97,196 70,006 80,600 83,000 32,374 70,267 38,460 - - 29,724 62,329 75,304 91,516 102,088 (7,582) (27,131) 2,701 5,000 4,000 - 481,595 - - - 63,196 67,782 62,597 67,000 73,000 18,597 19,799 21,147 20,988 21,942 692 19 - - - 1,078 262 245 - - 224,089 782,605 200,955 168,588 177,942 1,283,445 1,851,234 1,377, 579 1,322,438 1,512,066 49,513 63,027 51,972 66,368 70,601 1,608 2,933 2,090 2,500 3,000 900 - - - 3,900 4,281 4,726 4,054 5,090 5,520 3,831 4,833 3,964 5,192 5,929 6,157 8,683 8,779 9,530 10,111 1,146 3,005 4,445 2,836 3,027 925 3,686 - - - 68,361 90,893 75,304 91,516 102,088 2,652 3,317 2,701 5,000 4,000 1,818 1,980 - 1,830 2,950 6,172 5,294 6,282 9,306 9,729 7,132 2,023 3,318 9,000 9,000 59,559 75,995 71,471 72,000 81,000 15,395 12,098 23,227 40,000 40,000 1,992 1,426 666 1,375 1,480 1,162 429 - 1,800 1,800 59,758 69,014 68,929 68,175 72,450 2,801 640 1,052 1,000 1,500 586 1,753 - 3,000 3,000 159,027 173,969 177,646 212,486 226,909 1 Comments Includes 1% Rate Increase - See Cash Flow Estimated - Represents Average of Actuals for 2015-2017 (YTD) Estimated - Represents Average of Actuals for 2015-2017 (YTD) 200 Meters at $415 (Cost +$100) Sprint / Verizon / Nextera Estimated 3,450 Accounts at $6.36 (Actual is 3,395 as of 9/20/2017) Currently does not account for Lead Position Allocated 25% of 4,140 Gallons (2016 Actual) at $2.85 (Same Rate as Fleet) Allocated 50% of Monthly Bill Mailings (3,450 Accounts at $0.47) Operational & Preventative Maintenance Items See Detailed Attachment See Detailed Attachment See Detailed Attachment Purchase of 230 Meters (200 New Construction + 30 Replacements) U:\Budget\2018\Utility Funds\2018 UTILITY BUDGETS INPUT (V1.0) Water Fund City of Otsego Enterprise Fund Budget - 2018 Department Requests Water Utility Account Number Fund Department Source 500 CAPITAL OUTLAY (GENERAL) 601 49400 301 601 49400 302 601 49400 303 601 49400 306 601 49400 315 601 49400 320 601 49400 321 601 49400 322 601 49400 350 601 49400 355 601 49400 360 601 49400 361 601 49400 375 601 49400 390 601 49400 402 601 49400 410 601 49400 430 601 49400 437 TOTAL - SERVICES & OTHER CHARGES 1,567 49400 - Water Utilitv Fund Requested Actual Actual Year -to -Date Budget Budget Account Description 2015 2016 2017 2017 2018 LEGAL SERVICES ENGINEERING FEES PLANNING FEES PERMITS & FEES GIS SERVICES TELEPHONE M I LEAG E/TRAVEL UTILITIES PRINT & PUBLISHING DUES & MEMBERSHIPS EDUCATION/TRAINING/CONFERENCES LIABILITY AND PROPERTY INSURAN WATER TEST FEE CONTRACTED SERVICES REPAIRS/MAINT BUILDINGS RENTALS MISCELLANEOUS BANK SERVICE CHARGES 601 49400 500 CAPITAL OUTLAY (GENERAL) 601 49400 501 EQUIPMENT 601 49400 530 IMPROVEMENTS OTHER THAN BLDG 601 49400 550 MOTOR VEHICLES 601 49400 599 CAPITALIZED ASSET OFFSET TOTAL - CAPITAL OUTLAY 60,879 60,940 601 49400 420 DEPRECIATION 601 49400 602 BOND INTEREST 601 49400 720 OPERATING TRANSFERS TOTAL -OTHER 955 1,067 2,186 TOTAL -EXPENSES NET INCOME / (LOSS) - - 340 500 500 41,020 20,001 117,655 238,368 15,000 31,230 20,346 22,910 29,488 31,442 450 1,013 904 4,000 4,000 2,867 2,476 2,757 3,600 4,100 37 363 120 400 400 62,816 60,879 60,940 69,037 72,749 - 136 - 300 300 133 539 108 400 400 6,049 955 1,067 2,186 2,240 7,037 9,776 7,155 10,306 10,231 51,571 70,556 49,565 94,000 86,000 328 - 4,200 1,000 2,000 - 872 654 872 1,465 1,567 - - - - 5,071 4,863 4,975 13,200 6,965 210,174 192,775 273,348 467,657 237,792 - - - 500 750 - 28,013 50,149 15,000 - 12,542 12,660 1,327,086 1,737,130 150,000 - - - 11,750 27,744 (12,542) (36,980) - - - - 3,694 1,377,234 1,764,380 178,494 473,679 481,736 - 510,000 535,000 - - - 100,000 93,820 95,748 43,439 48,561 48,561 49,560 569,427 525,175 48,561 658,561 678,380 1,006,989 986,506 1,952,094 3,194,600 1,423,663 $ 276,456 $ 864,728 $ (574,515) $ (1,872,162) $ 88,403 2 Comments See Detailed Attachment See Detailed Attachment See Detailed Attachment Based on YTD Monthly Average Statutory Publish Requirements (Budget & Financial Statements) MMUA Membership (25%) & Minnesota Rural Water Association See Detailed Attachment Estimate - 5% Increase from 2016-2017 Actual Premiums See Detailed Attachment Shelving at Wellhouse #4 Lease Payments - Utility Bill Folding+ Envelope Stuffing Machine Based on YTD Monthly Average + 5% Increase Computer Replacements (2 Computers at $1,500 Each) - Allocated 25% Draft 2018-2027 CIP (Well #4 / 85th & Maciver Watermain) Allocated 25% of Planned 2018 Fleet Purchases (Crane Truck) Increase to account for depreciation on Tower #1 & Developer Assets WAC Allocation of Debt Service Interest on 2009A Bond General Fund Administration ($39,960) +Jet Vac Debt ($9,600) U:\Budget\2018\Utility Funds\2018 UTILITY BUDGETS INPUT (V1.0) Water Fund City of Otsego Enterprise Fund Budget - 2018 Detail of Line Item Requests Water Utility Budget Account No. & Description 2017 601-49400-216 $ 8,000 CHEMICAL SUPPLIES 56,000 8,000 72,000 601-49400-220 $ 15,000 R/M SUPPLIES 25,000 40,000 601-49400-225 $ 1,000 UNIFORMS/CLOTHING ALLOWANCE 375 1,375 601-49400-302 $ 5,000 ENGINEERING FEES 50,448 182,920 238,368 601-49400-306 $ 20,988 PERMITS & FEES 8,000 400 100 29,488 601-49400-320 $ 1,075 TELEPHONE 1,560 225 360 210 170 3,600 3 Requested Budget 2018 Item Detail / Description Comment $ 6,000 Fluoride Chemical increase forecasted for additional growth & related 66,000 Polyphosphate water production. Reduction in fluoride chemicals is the result 9,000 Chlorine of the City easing into lower concentration limits recently set - by State. 15,000 Corrective Maintenance Items (Ex. Chemical Pumps, Valv 25,000 Equipment Maintenance Items (Ex. Well Pumps, VFD) 40,000 1,000 Clothing Allowance = $400 x 5 Operators (50% Allocation 375 Boot Allowance= $150 x 5 Operators (50% Allocation) 75 Clothing Allowance = $150 x 1 Seasonal Operators (50%) 30 Boot Allowance = $60 x 1 Seasonal Onerators (50%Alloci General Water Engineering (AE2S Instrumentation KLM - Water Tower #1 Rehabilitation Hakanson Anderson - Kadler Avenue Watermain Extension $ 21,942 Minnesota Department of Health Testing ($6.36 at 3,450 Accounts) 9,000 DNR - Water Usage 400 Tier II Permits (4 @ $100) 100 Well Permits (2 @ $50) 31,442 $ 1,075 Employee Cell Phones ($55 x 5) + Replacement Phones ($1,000) - Allocated 25% 1,920 Centuryl-ink Internet + Phone Lines at Facilities ($160 Per Month) 450 Answering Service ($75 Monthly) - Allocated 50% 360 Land Line Telephone Service ($30 Monthly) 210 IPAD's ($35 x 2) - Allocated 25% 85 Rounding Contingency + Inflationary Factor 4,100 Equipment and system components beginning to age. U:\Budget\2018\Utility Funds\2018 UTILITY BUDGETS INPUT (V1.0) 601 -Detail City of Otsego Enterprise Fund Budget -2018 Detail of Line Item Requests Water Utility f Account No. & Description rd Requested Budget Budget 2017 2018 Item Detail / Description Comment 601-49400-360 $ 586 EDUCATION/TRAINING/CONFERENCE 1,600 2,186 601-49400-390 $ 38,392 CONTRACTED SERVICES - 11,000 2,500 2,900 1,000 2,100 12,500 3,500 18,000 750 1,358 $ 640 1 Minnesota Municipal Utilities Association - Citywide Safety Training (16 Total Visits) 1,600 10perator Certification Licensing and Training ($320 x 5 Operators) $ 41,020 Locates (Hakanson) - Based on 2017 YTD Monthly Average + 5% 2,455 Locates (Gopher One) - Based on 2017 YTD Monthly Average 5,000 Electrical 2,500 Itron Service Agreement 2,900 Security Monitoring (3 Water Towers + Booster Station) + Parts & Maintenance 1,100 Lab Testing 4,000 Pavement Management & Lawn Services - Spraying 5,000 Well & Water Tower Related -Inspections/ Cleaning 5,000 Equipment inspections/testing - Generator/ Meters/RPZ 15,000 Distribution Repairs 1,000 Mechanical - Heating & Air Conditioning 1,025 Rounding Contingency+ Inflationary Factor 94,000 1 86,000 U:\Budget\2018\Utility Funds\2018 UTILITY BUDGETS INPUT (V1.0) 601 -Detail 5 City of Otsego, Minnesota Capital Improvement Plan 2018 thru 2027 PROJECTS BY FUNDING SOURCE Source # Priority 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 Total 1601 - Water Utility Well #4 Improvements 601-2018-01 n/a 50,000 50,000 Watermain - 85th & Maciver 601-2018-02 n/a 100,000 100,000 Master Water Study 601-2019-01 n/a 40,000 40,000 Water Tower #2 Refurbish & Coating 601-2020-01 n/a 954,436 954,436 Replacement Well #3 Improvements 601-2020-02 n/a 150,000 150,000 Water Treatment - Well House #2 601-2021-01 n/a 2,000,000 2,000,000 Water Treatment - Well House #3 601-2022-01 n/a 2,000,000 2,000,000 Well #1 Improvements 601-2022-02 n/a 25,000 25,000 Well #2 Improvements 601-2022-03 n/a 25,000 25,000 Water Treatment - Well House #1 601-2023-01 n/a 2,000,000 2,000,000 Water Treatment - Well House #4 601-2024-01 n/a 2,000,000 2,000,000 Well #8 Improvements 601-2025-01 n/a 100,000 100,000 Water Tower #3 Refurbish & Coating 601-2026-01 n/a 750,000 750,000 Replacement Well #6 Improvements 601-2026-02 n/a 50,000 50,000 Well #9 - New Municipal Well 601-2027-01 n/a 1,000,000 1,000,000 Well #5 Improvements 601-2027-02 n/a 70,000 70,000 601 - Water Utility Total 150,000 40,000 1,104,436 2,000,000 2,050,000 2,000,000 2,000,000 100,000 800,000 1,070,000 11,314,436 GRAND TOTAL 150,000 40,000 1,104,436 2,000,000 2,050,000 2,000,000 2,000,000 100,000 800,000 1,070,000 11,314,436 Wednesday, October 18, 2017 City of Otsego C Water Utility Fund v Cash Flow Summary Revised: October 18, 2017 Undetermined Rate Increase 0.00% 3.00% 1.00% 1.00% 2.00% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Base Charge $ 8.62 $ 8.88 $ 8.97 $ 9.06 $ 9.24 $ 9.42 $ 9.70 $ 9.99 $ 10.29 $ 10.60 $ 10.92 $ 11.25 $ 11.59 Consumption Charge (0-10) $ 1.62 $ 1.67 $ 1.69 $ 1.71 $ 1.74 $ 1.77 $ 1.82 $ 1.87 $ 1.93 $ 1.99 $ 2.05 $ 2.11 $ 2.17 Consumption Charge (10+) $ 1.72 $ 1.77 $ 1.79 $ 1.81 $ 1.85 $ 1.89 $ 1.95 $ 2.01 $ 2.07 $ 2.13 $ 2.19 $ 2.26 $ 2.33 Estimated Bill (15k Gallons) $ 33.42 $ 34.43 $ 34.82 $ 35.21 $ 35.89 $ 36.57 $ 37.65 $ 38.74 $ 39.94 $ 41.15 $ 42.37 $ 43.65 $ 44.94 Actual Forecast Budget I Projected 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Operating Revenues Water Sales $ 910,963 $ 1,148,638 $ 1,160,124 $ 1,171,726 $ 1,195,160 $ 1,219,063 $ 1,255,635 $ 1,293,304 $ 1,332,103 $ 1,372,067 $ 1,413,229 $ 1,455,625 $ 1,499,294 Water Sales - Irrigation 118,999 155,927 135,000 135,000 135,000 135,000 135,000 135,000 135,000 135,000 135,000 135,000 135,000 Penalties and Interest 38,622 41,820 39,000 39,000 39,000 39,000 39,000 39,000 39,000 39,000 39,000 39,000 39,000 Other Subtotal 1,068,584 1,346,385 1,334,124 1,345,726 1,369,160 1,393,063 1,429,635 1,467,304 1,506,103 1,546,067 1,587,229 1,629,625 1,673,294 Nonoperating Revenues Antenna Leases 67,782 67,000 73,000 74,500 76,000 77,500 79,000 80,500 82,000 83,500 85,000 86,500 88,000 Water Meter Sales 97,196 80,600 83,000 83,000 83,000 83,000 83,000 83,000 83,000 83,000 83,000 83,000 83,000 Special Assessments 70,268 - - - - - - - - - - - - Investment Interest (Net) 35,198 - - - - - - - - - - - - Other 30,613 20,988 21,942 20,988 20,988 20,988 20,988 20,988 20,988 20,988 20,988 20,988 20,988 Total 1,369,641 1,514,973 1,512,066 1,524,214 1,549,148 1,574,551 1,612,623 1,651,792 1,692,091 1,733,555 1,776,217 1,820,113 1,865,282 Expenses Personal5ervcies 89,073 91,516 102,088 105,151 108,305 111,554 114,901 118,348 121,898 125,555 129,322 133,202 137,198 Supplies 173,969 212,486 226,909 231,447 236,076 240,798 245,614 250,526 255,536 260,647 265,860 271,177 276,601 Services & Other Charges 192,775 467,657 237,792 242,548 247,399 252,347 257,394 262,542 267,792 273,148 278,611 284,183 289,867 Depreciation 481,736 510,000 535,000 545,700 556,614 567,746 579,101 590,683 602,497 614,547 626,838 639,375 652,162 Capital Outlay 40,673 - - - - - - - - - - - - Capital Outlay (General) - 750 - - - - - Capital Outlay (Fleet) - 27,744 - 11,750 - - 8,750 - 100,000 12,000 12,810 Capital Outlay (CIP) - 1,764,380 150,000 40,000 1,104,436 2,000,000 2,050,000 2,000,000 2,000,000 100,000 800,000 1,070,000 - Transfers Out 33,439 38,761 39,960 41,159 42,394 43,665 44,975 46,325 47,714 49,146 50,620 52,139 53,703 Transfers Out - Debt Service - 100,000 93,820 93,820 93,820 93,820 93,820 93,820 93,820 83,020 59,773 35,640 - Transfers Out -Jet Vac 10,000 9,800 9,600 8,200 Total 1,021,665 3,194,600 1,423,663 1,308,024 2,400,794 3,309,930 3,385,805 3,370,993 3,389,258 1,606,063 2,223,024 2,498,526 1,409,531 CashBalance- Beginning 4,090,905 4,882,054 3,712,427 4,335,830 5,097,720 4,802,688 3,635,055 2,440,975 1,312,457 217,787 959,825 1,139,855 1,100,817 Balance Sheet Effects (38,563) Revenues 1,369,641 1,514,973 1,512,066 1,524,214 1,549,148 1,574,551 1,612,623 1,651,792 1,692,091 1,733,555 1,776,217 1,820,113 1,865,282 Expenditures (1,021,665) (3,194,600) (1,423,663) (1,308,024) (2,400,794) (3,309,930) (3,385,805) (3,370,993) (3,389,258) (1,606,063) (2,223,024) (2,498,526) (1,409,531) Noncash -Depreciation 481,736 510,000 535,000 545,700 556,614 567,746 579,101 590,683 602,497 614,547 626,838 639,375 652,162 Cash Balance - Ending $ 4,882,054 $ 3,712,427 $ 4,335,830 $ 5,097,720 $ 4,802,688 $ 3,635,055 $ 2,440,975 $ 1,312,457 $ 217,787 $ 959,825 $ 1,139,855 $ 1,100,817 $ 2,208,731 LJABudget\2018\Cash Flows\Utility Funds 601 -Water City of Otsego Debt Service - Principal 720,000 Water Access Charge Fund Debt Service - Interest 362,120 Cash Flow Summary %V Debt Service - Fiscal Agent Fee's 669 - Revised: October 18, 2017 Capital Outlay - 45,462 - - - Undetermined Debt Principal (2009A) - - - - - - - 270,000 Rate Increase 588,600 2.00% 3.10% 1.00% 1.00% 1.00% 1.00% 1.00% 93,820 1.00% 1.00% 1.00% 1.00% 1.00% Availability Charge $ 1,613.00 $ 1,663.00 $ 1,680.00 $ 1,697.00 $ 1,714.00 $ 1,731.00 $ 1,748.00 $ 1,765.00 $ 1,783.00 $ 1,801.00 $ 1,819.00 $ 1,837.00 Projected Final Plats 253,980 224,676 194,004 100 100 100 100 100 17,195 100 100 100 100 100 Connection Charge $ 1,613.00 $ 1,663.00 $ 1,680.00 $ 1,697.00 $ 1,714.00 $ 1,731.00 $ 1,748.00 $ 1,765.00 $ 1,783.00 $ 1,801.00 $ 1,819.00 $ 1,837.00 Projected Building Permits 1,255,800 695,199 131,500 150 150 150 150 150 23,094 150 150 150 150 150 Actual Forecast I Revenues 1,016,627 Projected 536,091 539,617 533,714 537,637 541,559 545,481 539,570 2016 2017 2018 2019 2020 2021 2022 (1,087,024) 2023 2024 2025 2026 2027 Revenues (916,386) (899,640) Cash Balance - Ending $ 2,997,538 $ 2,915,154 $ 2,365,949 $ 1,818,542 $ 1,255,800 $ 695,199 $ 131,500 $ (436,278) $ (855,716) $ (1,239,861) $ (1,641,724) $ WAC Fee $ 913,682 $ 906,929 $ 420,000 $ 424,250 $ 428,500 $ 432,750 $ 437,000 $ 441,250 $ 445,750 $ 450,250 $ 454,750 $ 459,250 Special Assessments 76,397 42,729 22,271 21,547 11,394 11,067 10,739 10,411 - - - - Investment Interest (Net) 26,548 - - - - - - - - - - - Transfer from Operating - 93,820 93,820 93,820 93,820 93,820 93,820 93,820 93,820 83,020 59,773 35,640 Transfer from SAC - - - - - - - - - - - - Total 1,016,627 1,043,478 536,091 539,617 533,714 537,637 541,559 545,481 539,570 533,270 514,523 494,890 Expenses Debt Service - Principal 720,000 Debt Service - Interest 362,120 Debt Service - Fiscal Agent Fee's 669 - Capital Outlay - 45,462 - - - - Debt Principal (2009A) - - - - - - - 270,000 567,000 588,600 864,000 Debt Interest (2009A) 93,820 93,820 93,820 93,820 93,820 93,820 93,820 93,820 83,020 59,773 35,640 Debt Principal (2010C) 732,600 766,800 799,200 840,600 867,600 918,000 954,000 559,800 250,200 259,200 - Debt Interest (2010C) - 253,980 224,676 194,004 162,036 136,818 93,438 65,439 35,388 17,195 8,813 - Total 1,082,789 1,125,862 1,085,296 1,087,024 1,096,456 1,098,238 1,105,258 1,113,259 959,008 917,415 916,386 899,640 Cash Balance - Beginning 3,040,606 2,997,538 2,915,154 2,365,949 1,818,542 1,255,800 695,199 131,500 (436,278) (855,716) (1,239,861) (1,641,724) Balance Sheet Effects 23,094 Revenues 1,016,627 1,043,478 536,091 539,617 533,714 537,637 541,559 545,481 539,570 533,270 514,523 494,890 Expenditures (1,082,789) (1,125,862) (1,085,296) (1,087,024) (1,096,456) (1,098,238) (1,105,258) (1,113,259) (959,008) (917,415) (916,386) (899,640) Cash Balance - Ending $ 2,997,538 $ 2,915,154 $ 2,365,949 $ 1,818,542 $ 1,255,800 $ 695,199 $ 131,500 $ (436,278) $ (855,716) $ (1,239,861) $ (1,641,724) $ (2,046,474) Bonds Payable $ 9,237,600 $ 8,505,000 $ 7,738,200 $ 6,939,000 $ 6,098,400 $ 5,230,80C $ 4,312,800 $ 3,358,800 $ 2,529,000 $ 1,711,800 $ 864,000 $ U:\Budget\2018\Cash Flows\Utility Funds 360 -WAC