2013

Sat, September 26, 2015 |

Water Utility
As of July 10, 2013
           
           
2011 2012 2012 2013 13 Budget to Change
Description Actual Budget Actual Budget 12 Actual Percent
           
Income            
Assessments 0 0 1,200 1,200 0 0.0%
City of Bella Vista 42,281 42,480 42,230 0 (42,230) (100.0%)
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,009,443 7,098,938 7,386,774 7,239,588 (147,186) (2.0%)
Sanitation Services 0 0 0 0 0 0.0%
Restricted Revenue 20,043 0 5,640 0 (5,640) (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 488,629 459,756 525,056 481,824 (43,232) (8.2%)
Total Income 7,560,396 7,601,174 7,960,900 7,722,612 (238,288) (3.0%)
           
           
Food and Beverage 0 0 0 0 0 0.0%
Water 2,005,589 2,079,768 1,943,335 2,085,209 141,874 7.3%
Pro Shop 0 0 0 0 0 0.0%
Printing 0 0 0 0 0 0.0%
Foreclosed Lots 0 0 0 0 0 0.0%
Gun Range 0 0 0 0 0 0.0%
Total Cost of Goods 2,005,589 2,079,768 1,943,335 2,085,209 141,874 7.3%
           
Gross Profit 5,554,806 5,521,406 6,017,565 5,637,403 (380,161.51) (6.3%)
           
Expenses            
Salary and Wages 870,916 900,836 844,726 941,687 96,962 11.5%
Employee Benefits 237,778 294,048 250,871 250,275 (596) (0.2%)
Maintenance and Repairs 283,922 295,630 308,022 321,300 13,278 4.3%
Supplies 295,662 348,190 274,696 388,060 113,364 41.3%
Outside Contracts 111,147 143,664 101,404 113,244 11,840 11.7%
Contract Sanitation Service 0 0 0 0 0 0.0%
Insurance 120,434 135,862 119,664 128,244 8,580 7.2%
Utilities 81,483 89,770 86,441 94,910 8,469 9.8%
Memberships, Training and Travel 3,939 10,600 5,896 13,894 7,998 135.6%
Fuel and Oil 72,176 75,857 65,327 82,107 16,780 25.7%
Taxes and Permits 105,932 99,267 240,606 137,092 (103,514) (43.0%)
Professional Services 3,956 0 3,450 15,000 11,551 334.8%
Membership Elections 0 0 0 0 0 0.0%
Postage 50,365 60,000 41,333 42,000 667 1.6%
Credit Card Fees & Interest Expense 54,244 194,250 38,819 356,352 317,533 818.0%
Other 709,668 5,674 (47,281) 96,600 143,881 304.3%
Total Operating Expenses 3,001,621 2,653,648 2,333,974 2,980,765 646,791 27.7%
           
Allocations – MAC 0 177,729 177,729 185,296 7,567 4.3%
Allocations – F & A 0 687,326 687,326 755,100 67,774 9.9%
Total Allocations 0 865,055 865,055 940,396 75,341 8.7%
           
Pre Depreciation Gross 2,553,185 2,002,702 2,818,535 1,716,242 (1,102,293) (39.1%)
           
Depreciation 979,391 1,062,221 1,003,126 1,062,817 59,691 6.0%
           
Net Income / Cost of Operations 1,573,794 940,481 1,815,409 653,425 (1,161,984) (64.0%)
           
Simple Cash Flow            
Add: Depreciation 979,391 1,062,221 1,003,126 1,062,817 59,691 6.0%
Subtract: Capital Projects (566,166) (1,114,020) (1,291,028) (559,000) 732,028 56.7%
Add: From Reserves 3,637,140 900,472 904,458 0 (904,458) (100.0%)
Add: Funds for Carry Over Expenses 0 0 0 0 0 0.0%
Subtract: Carry Over Capital Projects (3,396,023) (597,037) (467,774) 0 467,774 100.0%
Add: Reserves for Carry Over Capital 0 0 0 0 0 0.0%
Add: Financing 0 0 0 0 0 0.0%
Subtract: Debt Service (853,796) (320,004) (320,004) (325,000) (4,996) (1.6%)
           
Simple Cash Flow 1,374,340 872,113 1,644,187 832,242 (811,945) (49.4%)