Water Utility Fund
<br />Revenue, Expenditures, & Changes to Fund Balance
<br />June 30, 2018 - Budgetary Basis & Cash Basis
<br />2017 2018
<br />Audited Current Actuals @ Percent Current Percent
<br />Actuals Budget 06/30/18 of Budget Estimate of Budget
<br />Revenue:
<br />Intergovernmental Revenue 335,181 - - -
<br />Charges for Services:
<br />User Fees 5,851,124 6,089,240 1,421,368 23.3% 5,794,630 95.2%
<br />Tap Fees 4,659,014 3,371,190 1,617,186 48.0% 3,138,310 93.1%
<br />Miscellaenous Revenue 416,444 250,760 153,077 61.0% 350,960 140.0%
<br />Other Financing Sources - - 1,000 1,000
<br />Total Revenue 11,261,763 9,711,190 3,192,632 32.9% 9,284,900 95.6%
<br />Expenditures:
<br />Central Fund -Wide Charges
<br />Utility Billing
<br />Water Utility Engineering
<br />Water Plant Operations
<br />Raw Water Operations
<br />Water Distribution
<br />Water Treatment Plant Builidng Maintenance
<br />Debt Service
<br />Replacement Capital - Public Works
<br />Capital - Public Works
<br />Total Expenditures
<br />476,752 495,150 234,517 47.4% 498,650 100.7%
<br />135,665 153,830 53,211 34.6% 154,090 100.2%
<br />69,564 96,490 31,876 33.0% 96,700 100.2%
<br />1,324,028 2,137,480 620,674 29.0% 2,138,240 100.0%
<br />481,185 971,380 352,465 36.3% 971,380 100.0%
<br />461,871 583,450 202,083 34.6% 585,000 100.3%
<br />186,069 219,750 64,725 29.5% 221,990 101.0%
<br />976,824 987,190 121,172 12.3% 987,190 100.0%
<br />2,049,987 2,992,600 665,904 22.3% 2,992,600 100.0%
<br />1,869,152 6,839,570 2,764,772 40.4% 6,854,270 100.2%
<br />8,031,098 15,476,890 5,111,399 33.0% 15,500,110 100.2%
<br />Revenue Over/(Under) Expenditures 3,230,664 (5,765,700) (1,918,768) (6,215,210)
<br />Beginning Working Capital 14,666,139 17,896,803 17,896,803 17,896,803
<br />Ending Working Capital 17,896,803 12,131,103 15,978,035 11,681,593
<br />Revenue
<br />3,192,632
<br />9,711,190
<br />9,284,900
<br />• Current Budget • Current Estimate ■ Year -To -Date
<br />Expenditures
<br />5,111,399
<br />• Current Budget Current Estimate ■ Year -To -Date
<br />15,476,890
<br />15,500,110
<br />1,200,000
<br />1,000,000
<br />600,000
<br />600,000
<br />400,000
<br />200,000
<br />Combined Water User Fee Revenue
<br />Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
<br />- 2017 Actual
<br />� 2018 Budget
<br />2018 Actual
<br />12
<br />
|