Water Division 2013

Bella Vista Village Property Owners Association
Water Utility Consolidated
For the Twelve Months Ending December 31, 2013
After Audit
December
2013
December
2013
YTD YTD YTD 12 Month PREVIOUS
YR.
DESCRIPTION ACTUAL BUDGET Actual Budget Variance Total Budget ACTUAL
Income
Assessments 100 100 1,200 1,200 0 1,200 1,200
City of Bella Vista 3,534 0 42,432 0 42,432 0 42,230
Water 542,985 493,038 6,822,907 7,239,588 (416,681) 7,239,588 7,386,774
Restricted Revenue 1,310 0 2,127 0 2,127 0 5,640
Other 39,994 40,152 396,301 481,824 (85,523) 481,824 525,056
Total Income 587,923 533,290 7,264,967 7,722,612 (457,645) 7,722,612 7,960,900
Water 152,868 138,249 2,009,943 2,085,209 (75,266) 2,085,209 1,943,335
Total Cost of Goods 152,868 138,249 2,009,943 2,085,209 (75,266) 2,085,209 1,943,335
Gross Profit 435,056 395,041 5,255,024 5,637,403 (382,379) 5,637,403 6,017,565
Expenses
Salary and Wages 8,737 72,914 866,882 941,687 (74,805) 941,687 844,726
Employee Benefits (1,679) 19,244 231,993 250,275 (18,282) 250,275 250,871
Maintenance and Repairs 9,361 24,825 222,887 321,300 (98,413) 321,300 308,022
Supplies 26,903 23,525 191,824 388,060 (196,236) 388,060 274,696
Outside Contracts 7,727 7,462 111,042 113,244 (2,202) 113,244 101,404
Insurance 11,068 10,687 129,259 128,244 1,015 128,244 119,664
Utilities 8,365 8,595 95,321 94,910 411 94,910 86,441
Memberships, Training and Travel 0 162 9,925 13,894 (3,969) 13,894 5,896
Fuel and Oil 6,059 7,569 73,607 82,107 (8,500) 82,107 65,327
Taxes and Permits 11,744 11,146 137,171 137,092 79 137,092 240,606
Professional Services 7,969 0 21,098 15,000 6,098 15,000 3,450
Postage 3,421 3,500 41,556 42,000 (444) 42,000 41,333
Credit Card Fees & Interest Expense 41,930 29,696 377,659 356,352 21,307 356,352 38,819
Other (98,453) 7,500 (153,561) 96,600 (250,161) 96,600 (47,281)
Total Operating Expenses 43,152 226,825 2,356,662 2,980,765 (624,103) 2,980,765 2,333,974
Allocations – MAC 15,099 15,099 185,296 185,296 0 185,296 177,729
Allocations – F & A 66,323 66,323 755,100 755,100 0 755,100 687,326
Total Allocations 81,422 81,422 940,396 940,396 0 940,396 865,055
Pre Depreciation Gross 310,482 86,794 1,957,965 1,716,242 241,724 1,716,242 2,818,535
Depreciation 86,050 88,155 1,044,447 1,062,817 (18,370) 1,062,817 1,003,126
Net Income / Cost of Operations 224,431 (1,361) 913,518 653,425 260,094 653,425 1,815,409