Water Division 2012

Bella Vista Village Property Owners Association
Water Consolidated
For the Twelve Months Ending December 31, 2012 After Audit
December 2012 December 2012 YTD YTD YTD 12 Month PREVIOUS YR.
DESCRIPTION ACTUAL BUDGET Actual Budget Variance Total Budget ACTUAL
Income
Assessments 100 0 1,200 0 1,200 0 0
City of Bella Vista 3,511 3,540 42,230 42,480 (250) 42,480 42,281
Water 484,360 494,177 7,386,774 7,098,938 287,836 7,098,938 7,009,443
Restricted Revenue 711 0 5,640 0 5,640 0 20,043
Other 15,667 38,124 525,056 459,756 65,300 459,756 488,629
Total Income 504,349 535,841 7,960,900 7,601,174 359,726 7,601,174 7,560,396
Water 145,225 145,235 1,943,335 2,079,768 (136,433) 2,079,768 2,005,589
Total Cost of Goods 145,225 145,235 1,943,335 2,079,768 (136,433) 2,079,768 2,005,589
Gross Profit 359,124 390,606 6,017,565 5,521,406 496,159 5,521,406 5,554,806
Expenses
Salary and Wages 18,495 71,245 844,726 900,836 (56,110) 900,836 870,916
Employee Benefits 8,715 23,089 250,871 294,048 (43,177) 294,048 237,778
Maintenance and Repairs 82,743 23,200 308,022 295,630 12,392 295,630 283,922
Supplies 37,985 15,770 274,696 348,190 (73,494) 348,190 295,662
Outside Contracts 11,792 9,727 101,404 143,664 (42,260) 143,664 111,147
Insurance 8,766 11,138 119,664 135,862 (16,199) 135,862 120,434
Utilities 6,315 8,160 86,441 89,770 (3,329) 89,770 81,483
Memberships, Training and Travel 339 150 5,896 10,600 (4,704) 10,600 3,939
Fuel and Oil 4,454 6,992 65,327 75,857 (10,530) 75,857 72,176
Taxes and Permits 112,031 8,191 240,606 99,267 141,339 99,267 105,932
Professional Services 0 0 3,450 0 3,450 0 3,956
Postage 3,333 5,000 41,333 60,000 (18,667) 60,000 50,365
Credit Card Fees & Interest Expense (129,438) 30,875 38,819 194,250 (155,431) 194,250 54,244
Other (77,151) (1,326) (47,281) 5,674 (52,955) 5,674 709,668
Total Operating Expenses 88,379 212,211 2,333,974 2,653,648 (319,674) 2,653,648 3,001,621
Allocations – MAC 14,451 14,451 177,729 177,729 0 177,729 0
Allocations – F & A 56,970 56,970 687,326 687,326 0 687,326 0
Total Allocations 71,421 71,421 865,055 865,055 0 865,055 0
Pre Depreciation Gross 199,324 106,974 2,818,535 2,002,702 815,833 2,002,702 2,553,185
Depreciation 87,704 87,878 1,003,126 1,062,221 (59,095) 1,062,221 979,391
Net Income / Cost of Operations 111,620 19,096 1,815,409 940,481 874,927 940,481 1,573,794