Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) June 30, 2014 General Fund Library Capital Projects RDA CDBG Cemetery Total Assets Cash and cash equivalents 4,102,319 $ 382,302 $ 10,363,532 $ 2,478,574 $ ‐ $ 1,403,959 $ 18,730,686 $ Investments 2,996,008 ‐ 2,996,008 ‐ ‐ ‐ 5,992,016 Accounts receivable (net) 9,342,824 1,479,327 24,768 3,074,312 ‐ ‐ 13,921,231 Due from other governments 21,712 ‐ ‐ ‐ 36,738 ‐ 58,450 Prepaids 122,455 ‐ ‐ ‐ ‐ ‐ 122,455 Restricted cash 397 15,810 104,521 324,503 ‐ ‐ 445,231 Total assets 16,608,305 1,877,439 13,488,829 5,877,389 36,738 1,403,959 39,292,659 Liabilities Accrued Liabilities 1,752,687 78,891 113,419 417,184 14,148 ‐ 2,376,329 Due to other funds ‐ ‐ ‐ ‐ 22,590 ‐ 22,590 Total liabilities 1,752,687 78,891 113,419 417,184 36,738 ‐ 2,398,919 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,003,221 1,460,992 ‐ 3,074,312 ‐ ‐ 10,538,525 Deferred Inflows‐ ambulance billing 126,642 ‐ ‐ ‐ ‐ ‐ 126,642 Total deferred inflows of resources 6,129,863 1,460,992 ‐ 3,074,312 ‐ ‐ 10,665,167 Fund Balance Nonspendable 122,454 ‐ ‐ ‐ ‐ ‐ 122,454 Restricted 163,010 15,810 3,007,276 525,828 ‐ 520,000 4,231,924 Beginning fund balance 9,715,390 314,440 5,681,816 1,830,897 ‐ 839,593 18,383,904 Change in fund balance (1,275,099) 7,306 4,686,318 29,168 ‐ 44,366 3,490,291 Total fund balance 8,725,755 $ 337,556 $ 13,375,410 $ 2,385,893 $ ‐ $ 1,403,959 $ 26,228,573 $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) General Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Sales tax 11,616,251 $ 13,547,887 $ 12,682,000 $ 12,823,460 $ 724,427 $ Property tax 6,469,064 6,561,335 6,619,202 6,619,202 (57,867) Transfers in 4,620,102 4,649,379 4,647,611 4,649,380 Franchise tax 4,993,384 4,931,685 4,825,000 4,825,000 106,685 Administrative fees 3,025,037 2,971,011 2,983,289 2,988,990 (17,979) Parks and recreation 1,615,005 1,657,462 1,504,500 1,509,858 147,604 Fines and forfeitures 1,662,984 1,877,818 1,703,000 1,703,000 174,818 Intergovernmental 4,340,971 1,861,980 1,586,017 1,854,907 7,073 Public safety 1,077,512 1,126,703 1,002,000 1,038,610 88,093 Business license 665,744 662,594 645,000 645,000 17,594 Building permits 772,140 808,814 518,000 518,000 290,814 Miscellaneous 258,687 258,100 187,000 201,680 56,420 Emergency 911 Fees ‐ 423,768 ‐ ‐ 423,768 Sale of fixed assets 1,273,743 ‐ ‐ ‐ ‐ Investment income 137,578 48,938 75,000 75,000 (26,062) Total revenue 42,528,202 41,387,474 38,977,619 39,452,087 Expenditures Payroll General Government 2,865,039 2,930,458 3,000,243 2,985,923 55,465 Police 7,587,287 7,988,247 8,278,453 8,321,495 333,248 Fire 5,556,982 5,774,348 5,953,177 5,961,677 187,329 Public works 1,530,014 1,620,383 1,645,816 1,647,775 27,392 Parks 3,446,488 3,550,155 3,628,515 3,623,515 73,360 ADS 3,567,590 3,670,337 3,796,992 3,817,846 147,509 Operations and maintenance General Government 1,090,945 1,319,177 1,549,596 1,465,380 146,203 Police 1,654,236 1,779,693 1,637,103 1,948,842 169,149 Fire 704,163 727,889 756,905 833,398 105,509 Emergency 911 Services 462,897 894,353 470,585 470,585 (423,768) Public works 837,245 674,341 620,844 825,536 151,195 Class C 3,279,459 1,007,241 428,000 958,575 (48,666) Parks 1,912,822 1,887,847 1,970,029 1,991,921 104,074 ADS 1,015,693 1,196,412 1,314,604 1,330,693 134,281 Capital Outlay General Government 3,790 101,704 ‐ 101,705 1 Police 20,000 ‐ ‐ ‐ ‐ Fire 32,098 2,720 ‐ ‐ (2,720) Public works ‐ 1,400 ‐ ‐ (1,400) Class C 844,846 527,617 879,000 616,799 89,182 Parks ‐ 6,318 ‐ 10,579 4,261 ADS 1,509 29,240 ‐ 29,350 110 Debt Service Principal 1,505,000 1,265,294 1,255,000 1,266,425 1,131 UTOPIA payments 1,583,543 1,615,214 1,619,333 1,619,333 4,119 Interest and fiscal charge 396,651 351,415 363,551 352,126 711 Transfer out 6,302,498 3,740,770 2,034,873 4,125,642 384,872 Total Expenditures 46,200,795 42,662,573 41,202,619 44,305,120 Net change in fund balance (3,672,593) $ (1,275,099) $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Library Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax 1,592,243 $ 1,598,170 $ 1,619,738 $ 1,619,738 $ (21,568) $ Fines and forfeitures 47,328 60,327 45,000 45,000 15,327 Miscellaneous 6,845 7,701 6,500 6,500 1,201 Intergovernmental 53,402 12,180 12,500 25,822 (13,642) Investment income 6,964 5,189 6,000 6,000 (811) Total revenue 1,706,782 1,683,567 1,689,738 1,703,060 Expenditures Payroll 996,299 1,023,471 1,011,204 1,029,633 6,162 Operations and maintenance 464,400 475,015 503,871 513,247 38,232 Capital Outlay 29,489 58,112 55,000 60,517 2,405 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 11,286 ‐ ‐ ‐ ‐ Administrative Fee 98,799 119,663 119,663 119,663 ‐ Total Expenditures 1,600,273 1,676,261 1,689,738 1,723,060 Net change in fund balance 106,509 $ 7,306 $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Capital Projects Fund Current YTD Original Budget Final Budget Variance Revenue Transfers in 3,787,686 2,200,000 4,290,769 (503,083) Intergovernmental 2,525,000 725,000 2,525,000 ‐ Sale of fixed assets 29,336 ‐ ‐ 29,336 Miscellaneous 444,203 425,000 445,335 (1,132) Investment income 39,391 ‐ ‐ 39,391 Total revenue 6,825,616 3,350,000 7,261,104 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 142,177 59,320 164,229 22,052 Fire 79,506 36,420 79,590 84 Public works 352,170 362,313 363,865 11,695 Parks 40,286 43,000 53,500 13,214 ADS 23,778 110,500 135,500 111,722 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 44,000 57,700 57,700 13,700 Fire 197,737 217,282 199,112 1,375 Public works 318,466 1,636,000 3,453,973 3,135,507 Parks 131,700 139,000 140,000 8,300 ADS 584,295 466,120 1,027,120 442,825 Debt Service Principal 23,548 28,500 26,864 3,316 Interest and fiscal charge 1,635 ‐ 1,636 1 Transfer out 200,000 ‐ 200,000 ‐ Total Expenditures 2,139,298 3,156,155 5,903,089 Net change in fund balance 4,686,318 $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) RDA Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax 2,237,283 $ 2,133,581 $ 2,339,342 $ 2,339,342 $ (205,761) $ Bond Proceeds ‐ 1,346,644 ‐ 1,343,000 3,644 Investment income 10,473 11,902 8,000 8,000 3,902 Total revenue 2,247,756 3,492,127 2,347,342 3,690,342 Expenditures Operations and maintenance 533,369 1,049,797 1,243,091 1,241,791 191,994 Capital Outlay ‐ 1,311,799 280,000 1,822,799 511,000 Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 3,000 27,946 ‐ 32,501 4,555 Administrative Fee 76,991 110,118 110,118 110,118 ‐ Transfer out 898,146 963,299 1,064,246 1,083,246 119,947 Total Expenditures 1,511,506 3,462,959 2,697,455 4,290,455 Net change in fund balance 736,250 $ 29,168 $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) MBA Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Transfers in 1,000 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income 1 ‐ ‐ ‐ ‐ Total revenue 1,001 ‐ 1,000 1,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Debt Service Principal ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 10 ‐ 1,000 1,000 1,000 Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ 1,768 ‐ 1,769 1 Total Expenditures 10 1,768 1,000 2,769 Net change in fund balance 991 $ (1,768) $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) CDBG Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Intergovernmental 215,822 $ 36,738 $ 116,679 $ 147,380 $ (110,642) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 215,822 36,738 116,679 147,380 Expenditures Operations and maintenance 203,936 33,516 101,178 126,178 92,662 Administrative Fee 11,886 3,222 15,501 21,202 17,980 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 215,822 36,738 116,679 147,380 Net change in fund balance ‐ $ ‐ $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Cemetery Perpetual Care Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Transfers in 33,873 $ 33,873 $ 33,873 $ 33,873 $ ‐ $ Miscellaneous 1,310 3,510 ‐ ‐ 3,510 Investment income 8,662 6,983 7,000 7,000 (17) Total revenue 43,845 44,366 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 43,845 $ 44,366 $ ---PAGE BREAK--- June 30, 2014 Statement of Net Position ‐ Proprietary Funds (Unaudited) Water Waste Water Power Murray Parkway Telecom Solid Waste Storm Water Fund Fund Fund Fund Fund Fund Fund Total Assets Current assets: Cash and cash equivalents 3,830,040 $ 2,314,780 $ 7,430,301 $ 717,705 $ 102,013 $ 529,016 $ 1,123,062 $ 16,046,917 $ Investments 1,997,339 ‐ 3,994,677 ‐ ‐ ‐ ‐ 5,992,016 Accounts receivable (net) 759,306 328,484 3,032,217 ‐ 6,036 110,091 142,345 4,378,479 Notes receivable ‐ ‐ ‐ ‐ 461,219 ‐ ‐ 461,219 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Prepaids ‐ ‐ 278 250 ‐ ‐ ‐ 528 Inventory ‐ ‐ 2,327,548 84,256 ‐ ‐ ‐ 2,411,804 Total current assets 6,711,780 2,754,414 16,785,021 802,211 569,268 639,107 1,265,407 29,527,208 Noncurrent assets: Restricted cash 24 354,492 1,323 ‐ ‐ ‐ 1,946,801 2,302,640 Investment in joint venture ‐ 3,177,335 ‐ ‐ ‐ ‐ ‐ 3,177,335 Capital Assets: Land 2,155,313 455,921 1,691,650 326,336 ‐ ‐ 2,344,849 6,974,069 Buildings 919,021 949,132 3,410,311 819,374 ‐ ‐ ‐ 6,097,838 Improvements 26,447,023 12,222,810 76,519,089 3,734,149 ‐ ‐ 33,303,318 152,226,389 Machinery and equipment 2,760,754 1,102,902 12,731,528 918,168 ‐ 54,613 1,134,823 18,702,788 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 1,091,111 4,034 30,842 ‐ ‐ ‐ 1,548,551 2,674,538 Accumulated depreciation (14,992,631) (6,599,158) (59,859,775) (4,784,102) ‐ (3,357) (23,961,838) (110,200,861) Total noncurrent assets 18,380,615 11,667,468 38,283,995 1,013,925 ‐ 51,256 16,316,504 85,713,763 Liabilities Current liabilities: Accrued Liabilities 835,856 113,351 4,834,651 68,319 ‐ 89,412 337,045 6,278,634 Due to other funds ‐ ‐ ‐ 125,095 ‐ ‐ ‐ 125,095 Notes payable ‐ ‐ ‐ ‐ 461,219 ‐ ‐ 461,219 Interest payable 19,924 29,310 33,777 ‐ ‐ ‐ 28,156 111,167 Compensated absences 121,978 63,400 418,721 78,609 ‐ 2,522 37,739 722,969 Bonds & leases payable 40,682 128,318 1,200,000 ‐ ‐ ‐ 210,000 1,579,000 Total current liabilities 1,018,440 334,379 6,487,149 272,023 461,219 91,934 612,940 9,278,084 Noncurrent liabilities: Compensated absences 69,102 35,916 237,212 44,533 ‐ 1,430 21,380 409,573 Net OPEB payable 84,714 ‐ 226,696 ‐ ‐ ‐ ‐ 311,410 Bonds payable 2,871,870 2,540,644 8,328,565 ‐ ‐ ‐ 2,676,594 16,417,673 Total noncurrent liabilities 3,025,686 2,576,560 8,792,473 44,533 ‐ 1,430 2,697,974 17,138,656 Total liabilities 4,044,126 2,910,939 15,279,622 316,556 461,219 93,364 3,310,914 26,416,740 Net Position Beginning net position 20,049,365 10,882,975 37,053,995 1,464,610 108,089 495,064 14,731,745 84,785,843 Change in net position 998,904 627,968 2,735,399 34,970 (40) 101,935 (460,748) 4,038,388 Total net position 21,048,269 $ 11,510,943 $ 39,789,394 $ 1,499,580 $ 108,049 $ 596,999 $ 14,270,997 $ 88,824,231 $ ---PAGE BREAK--- June 30, 2014 YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ Proprietary Funds (Unaudited) Water Waste Water Power Murray Parkway Telecom Solid Waste Storm Water Fund Fund Fund Fund Fund Fund Fund Total Operating revenues: Charges for services 5,361,126 $ 4,115,475 $ 34,667,148 $ 1,320,141 $ 70,828 $ 1,368,410 $ 1,596,272 $ 48,499,400 $ Connection fees 11,834 1,475 215,173 ‐ ‐ ‐ ‐ 228,482 Miscellaneous 13,041 750 2,448,355 ‐ ‐ 1,078 248,229 2,711,453 Total operating revenues 5,386,001 4,117,700 37,330,676 1,320,141 70,828 1,369,488 1,844,501 51,439,335 Operating expenses: Wages and benefits 1,334,978 616,567 5,144,765 767,786 ‐ 65,578 578,779 8,508,453 Administrative fees 583,809 379,821 1,569,251 750 ‐ 113,746 89,381 2,736,758 Purchase power ‐ ‐ 19,444,771 ‐ ‐ ‐ ‐ 19,444,771 Operations and maintenance 1,103,439 1,885,326 2,727,425 360,712 71,298 1,006,374 300,095 7,454,669 Depreciation and amortization 1,008,531 428,728 2,973,947 156,394 ‐ 3,357 1,199,304 5,770,261 Total operating expenses 4,030,757 3,310,442 31,860,159 1,285,642 71,298 1,189,055 2,167,559 43,914,912 Operating income (loss) 1,355,244 807,258 5,470,517 34,499 (470) 180,433 (323,058) 7,524,423 Nonoperating revenues (expenses) Investment earnings 28,410 11,581 223,494 2,966 430 2,245 18,796 287,922 Interest and fiscal charges (108,518) (101,428) (551,951) (4,119) ‐ ‐ (72,058) (838,074) Impact fees 137,771 252,863 182,871 ‐ ‐ ‐ 11,603 585,108 Total nonoperating revenues (expenses) 101,593 121,718 (133,399) 471 430 2,245 (33,246) 59,812 Income (loss) before transfers 1,456,837 928,976 5,337,118 34,970 (40) 182,678 (356,304) 7,584,235 Capital contributions 24,524 10,422 3,500 ‐ ‐ ‐ ‐ 38,446 Transfers in (26,780) ‐ 218,264 ‐ ‐ ‐ 7,588 199,072 Transfers out (455,677) (311,430) (2,823,483) ‐ ‐ (80,743) (112,032) (3,783,365) Change in net position 998,904 $ 627,968 $ 2,735,399 $ 34,970 $ (40) $ 101,935 $ (460,748) $ 4,038,388 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) June 30, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 127,304 $ 1,547,679 $ Inventory 70,548 ‐ Total current assets 198,383 1,547,679 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (103,486) ‐ Total noncurrent assets 47,648 ‐ Total assets 246,031 1,547,679 Liabilities Current liabilities: Accrued Liabilities 56,232 268,735 Compensated absences 22,455 7,033 Total current liabilities 78,687 275,768 Noncurrent liabilities: Compensated absences 9,751 3,054 Total noncurrent liabilities 9,751 3,054 Total liabilities 88,438 278,822 Net Assets Beginning net position 69,476 1,371,922 Change in net position 88,117 (103,065) Total net position 157,593 $ 1,268,857 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) June 30, 2014 Central Garage Fund Operating revenues: Charges for services 428,658 $ Miscellaneous 1,460 Total operating revenues 430,118 Operating expenses: Wages and benefits 308,492 Administrative fees 750 Operations and maintenance 28,824 Depreciation and amortization 3,935 Total operating expenses 342,001 Operating income (loss) 88,117 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 88,117 Change in net position 88,117 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) June 30, 2014 Retained Risk Fund Operating revenues: Charges for services 901,673 $ Miscellaneous ‐ Total operating revenues 901,673 Operating expenses: Wages and benefits 176,525 Administrative fees 500 Operations and maintenance 16,268 Professional Fees 224,932 Insurance 475,536 Claims by department: ADS 942 Police 30,347 Parks & Recreation 1,233 Public Works 22,738 Water 29,037 Murray Park Golf 477 Power 23,247 Storm Water 10,553 Total operating expenses 1,012,335 Operating income (loss) (110,662) Nonoperating revenues (expenses) Investment earnings 7,597 Total nonoperating revenues (expenses) 7,597 Income (loss) before transfers (103,065) Change in net position (103,065) $