Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) October 31, 2013 General Fund Library Capital Projects RDA MBA CDBG Cemetery Total Assets Cash and cash equivalents 7,007,804 $ (86,634) $ 10,407,767 $ 1,724,520 $ 1,758 $ ‐ $ 1,375,508 $ 20,430,723 $ Accounts receivable (net) 6,453,038 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 10,257,118 Due from other governments 1,444 ‐ ‐ ‐ ‐ ‐ ‐ 1,444 Prepaids 17,865 ‐ ‐ ‐ ‐ ‐ ‐ 17,865 Restricted cash 668,996 15,757 200,000 250,000 ‐ ‐ ‐ 1,134,753 Total assets 14,149,147 1,393,861 10,607,767 4,313,862 1,758 ‐ 1,375,508 31,841,903 Liabilities Accrued Liabilities 855,001 50 ‐ ‐ ‐ ‐ ‐ 855,051 Total liabilities 855,001 50 ‐ ‐ ‐ ‐ ‐ 855,051 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 9,818,282 Total deferred inflows of resources 6,014,202 1,464,738 ‐ 2,339,342 ‐ ‐ ‐ 9,818,282 Fund Balance Restricted 362,764 15,730 638,349 827,056 ‐ ‐ 520,000 2,363,899 Beginning fund balance 9,962,698 314,520 8,050,744 1,529,669 1,768 ‐ 839,593 20,698,992 Change in fund balance (3,045,518) (401,177) 1,918,674 (382,205) (10) ‐ 15,915 (1,894,321) Total fund balance 7,279,944 $ (70,927) $ 10,607,767 $ 1,974,520 $ 1,758 $ ‐ $ 1,375,508 $ 21,168,570 $ ---PAGE BREAK--- October 31, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) General Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Property tax 210,677 $ 212,791 $ 6,619,202 $ 6,619,202 $ (6,406,411) $ Sales tax 2,056,431 2,197,078 12,682,000 12,682,000 (10,484,922) Franchise tax 1,298,274 1,219,227 4,825,000 4,825,000 (3,605,773) Business license 213,495 210,300 645,000 645,000 (434,700) Building permits 176,869 438,083 518,000 518,000 (79,917) Fines and forfeitures 527,107 565,281 1,703,000 1,703,000 (1,137,719) Miscellaneous 64,349 76,407 187,000 194,500 (118,093) Sale of fixed assets 1,282,052 ‐ ‐ ‐ ‐ Intergovernmental 254,274 275,219 1,586,017 1,701,459 (1,426,240) Public safety 328,005 334,483 1,002,000 1,002,000 (667,517) Parks and recreation 639,995 642,895 1,504,500 1,504,500 (861,605) Transfers in 1,540,032 1,549,204 4,647,611 4,647,611 (3,098,407) Administrative fees 1,008,045 989,268 2,983,289 2,988,990 (1,999,722) Investment income 67,044 15,146 75,000 75,000 (59,854) Total revenue 9,666,649 8,725,382 38,977,619 39,106,262 Expenditures Payroll General Government 840,442 817,993 3,000,243 3,000,243 2,182,250 Police 2,157,471 2,267,366 8,278,453 8,311,495 6,044,129 Fire 1,643,747 1,663,669 5,953,177 5,961,677 4,298,008 Public works 475,230 498,675 1,645,816 1,645,816 1,147,141 Parks 1,083,705 1,109,480 3,628,515 3,628,515 2,519,035 ADS 1,017,726 1,043,176 3,796,992 3,796,992 2,753,816 Operations and maintenance General Government 409,277 603,392 1,549,596 1,550,996 947,604 Police 758,046 831,675 1,963,774 2,077,164 1,245,489 Fire 285,196 308,627 900,819 932,819 624,192 Public works 254,267 139,203 620,844 810,844 671,641 Class C 329,329 259,085 428,000 528,000 268,915 Parks 769,918 731,943 1,970,029 1,983,529 1,251,586 ADS 451,933 425,045 1,314,604 1,320,305 895,260 Capital Outlay Class C 489,920 363,495 879,000 1,047,374 683,879 Parks ‐ 2,361 ‐ ‐ (2,361) Debt Service Principle ‐ 86,066 1,255,000 1,255,000 1,168,934 UTOPIA payments 526,969 537,509 1,619,333 1,619,333 1,081,824 Interest and fiscal charge 80,123 70,848 363,551 363,551 292,703 Transfer out 11,624 11,292 2,034,873 2,694,873 2,683,581 Total Expenditures 11,604,923 11,770,900 41,202,619 42,528,526 Net change in fund balance (1,938,274) $ (3,045,518) $ ---PAGE BREAK--- October 31, 2013 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 51,242 $ 51,783 $ 1,619,738 $ 1,619,738 $ (1,567,955) $ Fines and forfeitures 14,462 18,307 45,000 45,000 (26,693) Miscellaneous 1,898 2,444 6,500 6,500 (4,056) Intergovernmental 38,911 13,322 12,500 25,822 (12,500) Investment income 1,302 522 6,000 6,000 (5,478) Total revenue 107,815 86,378 1,689,738 1,703,060 Expenditures Payroll 314,502 286,586 1,011,204 1,029,546 742,960 Operations and maintenance 156,990 161,081 503,871 498,851 337,770 Capital Outlay 1,481 ‐ 55,000 55,000 55,000 Administrative Fee 32,932 39,888 119,663 119,663 79,775 Total Expenditures 505,905 487,555 1,689,738 1,703,060 Net change in fund balance (398,090) $ (401,177) $ ---PAGE BREAK--- October 31, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) Capital Projects Fund Current YTD Original Budget Final Budget Variance Revenue Transfers in ‐ 2,200,000 2,860,000 (2,860,000) Intergovernmental 2,525,000 725,000 2,525,000 ‐ Sale of fixed assets ‐ ‐ ‐ ‐ Miscellaneous 414,080 425,000 425,000 (10,920) Investment income 15,138 ‐ ‐ 15,138 Total revenue 2,954,218 3,350,000 5,810,000 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 53,410 59,320 59,320 5,910 Fire 38,220 36,420 70,510 32,290 Public works 223,484 362,313 363,865 140,381 Parks 19,502 43,000 43,000 23,498 ADS 5,000 110,500 110,500 105,500 Capital Outlay General Government ‐ ‐ ‐ ‐ Police ‐ 57,700 57,700 57,700 Fire 129,441 217,282 183,192 53,751 Public works 32,453 1,636,000 3,434,448 3,401,995 Parks 98,847 139,000 139,000 40,153 ADS 424,029 466,120 666,120 242,091 Transfer out ‐ ‐ 200,000 200,000 Total Expenditures 1,035,544 3,156,155 5,356,155 Net change in fund balance 1,918,674 $ ---PAGE BREAK--- October 31, 2013 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,339,342 $ 2,339,342 $ (2,339,342) $ Miscellaneous ‐ ‐ ‐ ‐ ‐ Investment income 3,459 3,215 8,000 8,000 (4,785) Total revenue 3,459 3,215 2,347,342 2,347,342 Expenditures Operations and maintenance 13,408 60,636 1,243,091 1,243,091 1,182,455 Capital Outlay ‐ ‐ 280,000 280,000 280,000 Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge ‐ ‐ ‐ ‐ ‐ Administrative Fee 25,668 36,704 110,118 110,118 73,414 Transfer out 299,380 288,080 1,064,246 1,064,246 776,166 Total Expenditures 338,456 385,420 2,697,455 2,697,455 Net change in fund balance (334,997) $ (382,205) $ ---PAGE BREAK--- October 31, 2013 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 332 $ ‐ $ 1,000 $ 1,000 $ (1,000) $ Sale of fixed assets ‐ ‐ ‐ ‐ ‐ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 332 ‐ 1,000 1,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Debt Service Principle ‐ ‐ ‐ ‐ ‐ Interest and fiscal charge 10 10 1,000 1,000 990 Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 10 10 1,000 1,000 Net change in fund balance 322 $ (10) $ ---PAGE BREAK--- October 31, 2013 YTD Statement of Revenues, Expenditures, and Changes in Fund Balance (Unaudited) CDBG Fund Prior YTD Current YTD Original Budget Final Budget Variance Revenue Intergovernmental 94,478 $ ‐ $ 116,679 $ 147,380 $ (147,380) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue 94,478 ‐ 116,679 147,380 Expenditures Operations and maintenance 90,824 ‐ 101,178 126,178 126,178 Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee 3,653 ‐ 15,501 21,202 21,202 Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures 94,477 ‐ 116,679 147,380 Net change in fund balance 1 $ ‐ $ ---PAGE BREAK--- October 31, 2013 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 11,292 $ 11,292 $ 33,873 $ 33,873 $ (22,581) $ Miscellaneous (100) 2,300 ‐ ‐ 2,300 Investment income 3,417 2,323 7,000 7,000 (4,677) Total revenue 14,609 15,915 40,873 40,873 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Capital Outlay ‐ ‐ ‐ ‐ ‐ Administrative Fee ‐ ‐ ‐ ‐ ‐ Transfer out ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 14,609 $ 15,915 $ ---PAGE BREAK--- October 31, 2013 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 6,704,727 $ 2,001,294 $ 14,300,013 $ 717,116 $ 101,953 $ 500,277 $ 721,841 $ 25,047,221 $ Accounts receivable (net) 377,060 248,605 2,517,739 ‐ 3,304 81,455 84,424 3,312,587 Notes receivable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Due from other funds 125,095 ‐ ‐ ‐ ‐ ‐ ‐ 125,095 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,081,882 84,507 ‐ ‐ ‐ 2,166,389 Total current assets 7,206,882 2,361,049 18,899,634 801,623 523,847 581,732 806,265 31,181,032 Noncurrent assets: Restricted cash 201 353,500 294,107 ‐ ‐ ‐ 3,054,314 3,702,122 Investment in joint venture ‐ 3,312,153 ‐ ‐ ‐ ‐ ‐ 3,312,153 Capital Assets: Land 2,155,313 455,921 1,691,650 326,336 ‐ ‐ 2,344,849 6,974,069 Buildings 904,024 949,132 3,410,311 797,534 ‐ ‐ ‐ 6,061,001 Improvements 25,395,326 10,691,325 76,243,203 3,734,149 ‐ ‐ 32,867,440 148,931,443 Machinery and equipment 3,116,440 1,231,707 12,986,078 961,556 ‐ ‐ 1,141,285 19,437,066 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 840,333 1,393,186 3,650 ‐ ‐ ‐ 688,877 2,926,046 Accumulated depreciation (14,748,095) (6,447,312) (58,860,153) (4,724,366) ‐ ‐ (23,182,157) (107,962,083) Total noncurrent assets 17,663,542 11,939,612 39,527,873 1,095,209 ‐ ‐ 16,914,608 87,140,844 Deferred Outflows of Resources Bond defeasance costs ‐ ‐ 131,513 ‐ ‐ ‐ ‐ 131,513 Total deferred outflows of resources ‐ ‐ 131,513 ‐ ‐ ‐ ‐ 131,513 Liabilities Current liabilities: Accrued Liabilities 9,569 77,013 4,068,926 6,369 ‐ ‐ ‐ 4,161,877 Due to other funds ‐ ‐ ‐ 125,095 ‐ ‐ ‐ 125,095 Notes payable ‐ ‐ ‐ ‐ 418,590 ‐ ‐ 418,590 Interest payable ‐ ‐ 49,017 ‐ ‐ ‐ ‐ 49,017 Compensated absences 139,994 60,921 368,312 71,739 ‐ 2,038 36,985 679,989 Bonds & leases payable ‐ ‐ 1,545,000 ‐ ‐ ‐ 210,000 1,755,000 Total current liabilities 149,563 137,934 6,031,255 203,203 418,590 2,038 246,985 7,189,568 Noncurrent liabilities: Compensated absences 81,157 35,317 213,516 41,588 ‐ 1,182 21,442 394,202 Net OPEB payable 92,071 ‐ 337,556 ‐ ‐ ‐ ‐ 429,627 Bonds payable 3,150,446 2,811,172 13,040,883 ‐ ‐ ‐ 2,897,326 21,899,827 Total noncurrent liabilities 3,323,674 2,846,489 13,591,955 41,588 ‐ 1,182 2,918,768 22,723,656 Total liabilities 3,473,237 2,984,423 19,623,210 244,791 418,590 3,220 3,165,753 29,913,224 Net Position Beginning net position 19,688,332 10,803,893 36,387,176 1,464,610 105,065 454,154 14,662,743 83,565,973 Change in net position 1,708,855 512,345 2,548,634 187,431 192 124,358 (107,623) 4,974,192 Total net position 21,397,187 $ 11,316,238 $ 38,935,810 $ 1,652,041 $ 105,257 $ 578,512 $ 14,555,120 $ 88,540,165 $ ---PAGE BREAK--- October 31, 2013 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 3,094,787 $ 1,343,698 $ 13,967,165 $ 635,487 $ 19,368 $ 458,478 $ 569,213 $ 20,088,196 $ Connection fees 7,483 775 99,465 ‐ ‐ ‐ ‐ 107,723 Miscellaneous 1,249 375 604,970 (14,388) ‐ ‐ 3,254 595,460 Total operating revenues 3,103,519 1,344,848 14,671,600 621,099 19,368 458,478 572,467 20,791,379 Operating expenses: Wages and benefits 360,287 191,718 1,467,449 245,417 ‐ 16,879 140,336 2,422,086 Administrative fees 194,604 126,608 523,084 252 ‐ 37,916 29,792 912,256 Purchase power ‐ ‐ 7,381,113 ‐ ‐ ‐ ‐ 7,381,113 Operations and maintenance 432,971 462,638 1,077,069 131,615 19,321 253,124 78,817 2,455,555 Depreciation and amortization 338,512 141,756 970,502 53,269 ‐ ‐ 400,132 1,904,171 Total operating expenses 1,326,374 922,720 11,419,217 430,553 19,321 307,919 649,077 15,075,181 Operating income (loss) 1,777,145 422,128 3,252,383 190,546 47 150,559 (76,610) 5,716,198 Nonoperating revenues (expenses) Investment earnings 13,852 3,703 84,455 1,004 145 715 6,716 110,590 Interest and fiscal charges (25,235) (34,397) ‐ (4,119) ‐ ‐ (8,322) (72,073) Impact fees 86,192 224,723 132,956 ‐ ‐ ‐ 7,937 451,808 Total nonoperating revenues (expenses) 83,602 194,029 237,411 (3,115) 145 715 6,331 519,118 Income (loss) before transfers 1,860,747 616,157 3,489,794 187,431 192 151,274 (70,279) 6,235,316 Transfers out (151,892) (103,812) (941,160) ‐ ‐ (26,916) (37,344) (1,261,124) Change in net position 1,708,855 $ 512,345 $ 2,548,634 $ 187,431 $ 192 $ 124,358 $ (107,623) $ 4,974,192 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) October 31, 2013 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents (17,030) $ 1,593,581 $ Inventory 79,617 ‐ Total current assets 62,587 1,593,581 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (100,862) ‐ Total noncurrent assets 50,272 ‐ Total assets 112,859 1,593,581 Liabilities Current liabilities: Accrued Liabilities ‐ 250,000 Compensated absences 21,101 4,474 Total current liabilities 21,101 254,474 Noncurrent liabilities: Compensated absences 9,698 2,057 Total noncurrent liabilities 9,698 2,057 Total liabilities 30,799 256,531 Net Assets Beginning net position 69,476 1,371,921 Change in net position 12,584 (34,871) Total net position 82,060 $ 1,337,050 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) October 31, 2013 Central Garage Fund Operating revenues: Charges for services 115,440 $ Miscellaneous ‐ Total operating revenues 115,440 Operating expenses: Wages and benefits 86,621 Administrative fees 252 Operations and maintenance 14,671 Depreciation and amortization 1,312 Total operating expenses 102,856 Operating income (loss) 12,584 Nonoperating revenues (expenses) Investment earnings ‐ Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) ‐ Income (loss) before transfers 12,584 Change in net position 12,584 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) October 31, 2013 Retained Risk Fund Operating revenues: Charges for services 300,564 $ Miscellaneous ‐ Total operating revenues 300,564 Operating expenses: Wages and benefits 35,829 Administrative fees 168 Operations and maintenance 13,596 Legal Fees 58,666 Insurance 173,791 Claims by department: Fire ‐ Police 18,592 Parks & Recreation 100 Public Works 20,568 Water 6,061 Storm Water 10,553 Total operating expenses 337,924 Operating income (loss) (37,360) Nonoperating revenues (expenses) Investment earnings 2,489 Total nonoperating revenues (expenses) 2,489 Income (loss) before transfers (34,871) Change in net position (34,871) $