2014

Sat, September 26, 2015 |

Water Utility
Dated 02/20/14
             
2012 2013 2013 2014 14 Budget to Change
Description Actual Budget Unaudited Budget 13 Actual Percent
           
Income            
Assessments 1,200 1,200 1,200 1,200 0 0.0%
City of Bella Vista 42,230 0 42,432 42,552 120  0.3%
Food and Beverage 0 0 0 0 0  0.0%
Golf 0 0 0 0 0  0.0%
Pro Shop 0 0 0 0 0  0.0%
Other Recreation 0 0 0 0 0  0.0%
RV Park 0 0 0 0 0  0.0%
Facility Use Fees 0 0 0 0 0  0.0%
Boat 0 0 0 0 0  0.0%
Interest on Investments 0 0 0 0 0  0.0%
Water 7,386,774 7,239,588 6,822,907 7,222,726 399,819  5.9%
Sanitation Services 0 0 0 0 0  0.0%
Restricted Revenue 5,640 0 2,127 0 (2,127) ( 100.0%)
Stump Dump 0 0 0 0 0  0.0%
Lot Sales 0 0 0 0 0  0.0%
Transfer Fees 0 0 0 0 0  0.0%
Other 525,056 481,824 396,301 277,800 (118,501) ( 29.9%)
Total Income 7,960,900 7,722,612 7,264,967 7,544,278 279,311  3.8%
           
           
Food and Beverage 0 0 0 0 0  0.0%
Water 1,943,335 2,085,209 2,009,943 2,079,000 69,057  3.4%
Pro Shop 0 0 0 0 0  0.0%
Gun Range 0 0 0 0 0  0.0%
Total Cost of Goods 1,943,335 2,085,209 2,009,943 2,079,000 69,057  3.4%
           
Gross Profit 6,017,565 5,637,403 5,255,024 5,465,278 210,254  4.0%
           
Expenses            
Salary and Wages 844,726 941,687 866,882 959,334 92,452  10.7%
Employee Benefits 250,871 250,275 231,993 261,828 29,835  12.9%
Maintenance and Repairs 308,022 321,300 222,887 320,600 97,713  43.8%
Supplies 274,696 388,060 191,824 383,285 191,461  99.8%
Outside Contracts 101,404 113,244 111,042 117,994 6,952  6.3%
Contract Sanitation Service 0 0 0 0 0  0.0%
Insurance 119,664 128,244 129,259 143,346 14,087  10.9%
Utilities 86,441 94,910 95,321 99,545 4,224  4.4%
Memberships, Training and Travel 5,896 13,894 9,925 12,784 2,859  28.8%
Fuel and Oil 65,327 82,107 73,607 81,902 8,295  11.3%
Taxes and Permits 240,606 137,092 137,171 147,736 10,566  7.7%
Professional Services 3,450 15,000 21,098 25,000 3,902  18.5%
Membership Elections 0 0 0 0 0  0.0%
Postage 41,333 42,000 41,556 42,000 444  1.1%
Credit Card Fees & Interest Expense 38,819 356,352 377,659 356,352 (21,307) ( 5.6%)
Other (47,281) 96,600 (153,561) 57,650 211,211  137.5%
Total Operating Expenses 2,333,974 2,980,765 2,356,662 3,009,355 652,693  27.7%
           
Allocations – MAC 177,729 185,296 185,296 238,704 53,408  28.8%
Allocations – F & A 687,326 755,100 755,100 689,158 (65,942) ( 8.7%)
Total Allocations 865,055 940,396 940,396 927,862 (12,534) ( 1.3%)
           
Pre Depreciation Gross 2,818,535 1,716,242 1,957,965 1,528,061 (429,904) ( 22.0%)
           
Depreciation 1,003,126 1,062,817 1,044,447 1,020,125 (24,322) ( 2.3%)
           
Net Income / Cost of Operations 1,815,409 653,425 913,518 507,936 (405,582) ( 44.4%)
Simple Cash Flow            
Add: Depreciation 1,003,126 1,062,817 1,044,447 1,020,125 (24,322) (2.3%)
Subtract: Capital Projects (1,291,028) (559,000) (464,543) (531,000) (66,457) (14.3%)
Add: From Reserves 904,458 0 26,303 0 (26,303) (100.0%)
Add: Funds for Carry Over Expenses 0 0 0 0 0 0.0%
Subtract: Carry Over Capital Projects (467,774) 0 0 (30,332) (30,332) 0.0%
Add: Reserves for Carry Over Capital 0 0 0 30,332 30,332 0.0%
Add: Financing 0 0 0 0 0 0.0%
Subtract: Debt Service (320,004) (325,000) (324,996) (330,000) (5,004) (1.5%)
           
Simple Cash Flow 1,644,187 832,242 1,194,729 667,061 (527,668) (44.2%)