Full Text
Balance Sheet ‐ Governmental Funds (Unaudited) October 31, 2014 General Fund Library Capital Projects RDA Cemetery Total Assets Cash and cash equivalents 1,069,123 $ (75,079) $ 9,688,028 $ 1,716,305 $ 1,418,314 $ 13,816,691 $ Investments 3,014,872 ‐ 3,014,871 ‐ ‐ 6,029,743 Accounts receivable (net) 6,488,820 1,460,991 60,000 3,074,312 ‐ 11,084,123 Prepaids 34,725 ‐ ‐ ‐ ‐ 34,725 Restricted cash 687,782 15,835 104,521 312,950 ‐ 1,121,088 Total assets 11,295,322 1,401,747 12,867,420 5,103,567 1,418,314 32,086,370 Liabilities Accrued Liabilities 834,712 49 ‐ 1,000 ‐ 835,761 Due to other funds ‐ ‐ ‐ ‐ ‐ ‐ Total liabilities 834,712 49 ‐ 1,000 ‐ 835,761 Deferred Inflows of Resources Deferred Inflows‐ property taxes 6,003,221 1,460,991 ‐ 3,074,312 ‐ 10,538,524 Deferred Inflows‐ ambulance billing 126,642 ‐ ‐ ‐ ‐ 126,642 Total deferred inflows of resources 6,129,863 1,460,991 ‐ 3,074,312 ‐ 10,665,166 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 8,440,290 321,747 10,368,134 1,860,064 883,958 21,874,193 Change in fund balance (4,395,007) (396,850) (507,990) (357,637) 14,356 (5,643,128) Total fund balance 4,330,747 $ (59,293) $ 12,867,420 $ 2,028,255 $ 1,418,314 $ 20,585,443 $ ---PAGE BREAK--- October 31, 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 2,197,078 $ 2,280,226 $ 12,943,703 $ 12,973,703 $ (10,693,477) $ Property tax 212,791 217,324 6,618,221 6,618,221 (6,400,897) Transfers in 1,549,204 1,555,268 4,665,816 4,665,816 (3,110,548) Franchise tax 1,219,227 1,200,085 4,842,000 4,842,000 (3,641,915) Administrative fees 989,268 1,035,168 3,105,489 3,105,489 (2,070,321) Parks and recreation 642,895 614,543 1,564,500 1,564,500 (949,957) Fines and forfeitures 565,281 552,575 1,818,000 1,818,000 (1,265,425) Intergovernmental 275,219 200,553 1,609,284 1,688,456 (1,487,903) Public safety 334,483 571,190 1,039,500 1,058,683 (487,493) Business license 210,300 209,631 655,000 655,000 (445,369) Building permits 438,083 324,697 525,250 525,250 (200,553) Miscellaneous 76,407 72,798 226,500 226,500 (153,702) Emergency 911 Fees ‐ ‐ ‐ 423,000 (423,000) Investment income 15,149 27,295 60,000 60,000 (32,705) Total revenue 8,725,385 8,861,353 39,673,263 40,224,618 Expenditures Payroll General Government 817,993 994,409 3,174,759 3,216,259 2,221,850 Police 2,267,366 2,569,623 8,369,388 8,402,431 5,832,808 Fire 1,663,669 1,898,916 6,122,724 6,131,224 4,232,308 Public works 498,675 589,819 1,718,878 1,718,878 1,129,059 Parks 1,109,480 1,243,337 3,717,183 3,717,183 2,473,846 ADS 1,043,176 1,221,690 3,959,412 3,945,412 2,723,722 Operations and maintenance General Government 603,392 635,728 1,024,356 1,398,522 762,794 Police 668,340 695,172 1,713,702 1,840,531 1,145,359 Fire 236,670 268,588 821,482 824,848 556,260 Emergency 911 Services 235,293 251,070 503,620 926,620 675,550 Public works 139,203 136,702 834,732 834,732 698,030 Class C 259,085 287,497 325,000 325,000 37,503 Parks 731,943 706,343 2,056,046 2,056,046 1,349,703 ADS 425,045 452,536 1,293,334 1,293,334 840,798 Capital Outlay Class C 363,495 599,098 1,000,000 1,068,298 469,200 Parks 2,361 ‐ ‐ 43,000 43,000 Debt Service Principal 86,066 83,565 1,278,566 1,278,566 1,195,001 UTOPIA payments 537,509 548,259 1,647,520 1,647,520 1,099,261 Interest and fiscal charge 70,848 62,676 308,061 308,061 245,385 Transfer out 11,292 11,332 34,000 34,000 22,668 Total Expenditures 11,770,901 13,256,360 39,902,763 41,010,465 Net change in fund balance (3,045,516) $ (4,395,007) $ ---PAGE BREAK--- October 31, 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 51,783 $ 52,915 $ 1,619,738 $ 1,619,738 $ (1,566,823) $ Fines and forfeitures 18,307 18,016 45,000 45,000 (26,984) Miscellaneous 2,444 2,554 6,500 6,500 (3,946) Intergovernmental 13,322 38,300 12,000 50,300 (12,000) Investment income 522 432 6,131 6,131 (5,699) Total revenue 86,378 112,217 1,689,369 1,727,669 Expenditures Payroll 286,586 344,503 1,036,140 1,036,140 691,637 Operations and maintenance 161,081 113,906 473,404 511,704 397,798 Capital Outlay ‐ ‐ 55,000 55,000 55,000 Transfer out ‐ 9,050 ‐ 9,050 ‐ Administrative Fee 39,888 41,608 124,825 124,825 83,217 Total Expenditures 487,555 509,067 1,689,369 1,736,719 Net change in fund balance (401,177) $ (396,850) $ ---PAGE BREAK--- October 31, 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 406,716 200,000 606,716 (200,000) Intergovernmental 959,847 ‐ 959,847 ‐ Investment income 31,259 ‐ ‐ 31,259 Total revenue 1,397,822 200,000 1,566,563 Expenditures Small Equipment General government ‐ ‐ ‐ ‐ Police 62,268 85,500 85,500 23,232 Fire ‐ 42,800 42,800 42,800 Public works 30,802 192,392 252,392 221,590 Parks 18,949 170,000 170,000 151,051 ADS 480 50,000 150,000 149,520 Capital Outlay General Government ‐ ‐ ‐ ‐ Police 145,688 295,000 295,000 149,312 Fire ‐ 452,863 452,863 452,863 Public works 1,498,887 732,000 3,884,603 2,385,716 Parks 32,699 475,000 475,000 442,301 ADS 105,977 219,602 1,032,318 926,341 Debt Service Principal 8,394 24,139 24,139 15,745 Interest and fiscal charge ‐ 1,050 1,050 1,050 Transfer out 1,668 5,000 5,000 3,332 Total Expenditures 1,905,812 2,745,346 6,870,665 Net change in fund balance (507,990) $ ---PAGE BREAK--- October 31, 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 ‐ $ ‐ $ 3,074,312 $ 3,074,312 $ (3,074,312) $ Rents ‐ 2,538 ‐ ‐ 2,538 Investment income 3,216 3,476 9,500 9,500 (6,024) Total revenue 3,216 6,014 3,083,812 3,083,812 Expenditures Operations and maintenance 60,636 11,370 1,670,778 1,670,778 1,659,408 Capital Outlay ‐ ‐ 100,000 350,000 350,000 Debt Service Principal ‐ ‐ 262,000 262,000 262,000 Interest and fiscal charge ‐ 11,671 22,040 22,040 10,369 Administrative Fee 36,704 38,860 116,567 116,567 77,707 Transfer out 288,080 301,750 1,064,937 1,078,379 776,629 Total Expenditures 385,420 363,651 3,236,322 3,499,764 Net change in fund balance (382,204) $ (357,637) $ ---PAGE BREAK--- October 31, 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 ‐ $ ‐ $ 50,000 $ 61,119 $ (61,119) $ Investment income ‐ ‐ ‐ ‐ ‐ Total revenue ‐ ‐ 50,000 61,119 Expenditures Operations and maintenance ‐ ‐ 50,000 61,119 61,119 Total Expenditures ‐ ‐ 50,000 61,119 Net change in fund balance ‐ $ ‐ $ ---PAGE BREAK--- October 31, 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 11,292 $ 11,332 $ 34,000 $ 34,000 $ (22,668) $ Miscellaneous 2,300 750 ‐ ‐ 750 Investment income 2,323 2,274 8,000 8,000 (5,726) Total revenue 15,915 14,356 42,000 42,000 Expenditures Operations and maintenance ‐ ‐ ‐ ‐ ‐ Total Expenditures ‐ ‐ ‐ ‐ Net change in fund balance 15,915 $ 14,356 $ ---PAGE BREAK--- October 31, 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,369,568 $ 3,072,950 $ 7,947,299 $ 739,587 $ 101,692 $ 489,236 $ (37,161) $ 15,683,171 $ Investments 2,009,915 ‐ 4,019,829 ‐ ‐ ‐ ‐ 6,029,744 Accounts receivable (net) 720,034 359,461 3,442,427 ‐ 6,904 125,573 154,947 4,809,346 Notes receivable ‐ ‐ ‐ ‐ 461,219 ‐ ‐ 461,219 Due from other funds 81,295 ‐ ‐ ‐ ‐ ‐ ‐ 81,295 Due from other governments ‐ 111,150 ‐ ‐ ‐ ‐ ‐ 111,150 Inventory ‐ ‐ 2,256,949 84,255 ‐ ‐ ‐ 2,341,204 Total current assets 6,180,812 3,543,561 17,666,504 823,842 569,815 614,809 117,786 29,517,129 Noncurrent assets: Restricted cash 47 259,930 202,659 ‐ ‐ ‐ 1,949,907 2,412,543 Investment in joint venture ‐ 3,240,382 ‐ ‐ ‐ ‐ ‐ 3,240,382 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,762,079 1,117,862 12,844,838 963,667 ‐ 54,613 1,134,823 18,877,882 Intangibles ‐ ‐ 3,759,027 ‐ ‐ ‐ ‐ 3,759,027 Construction in progress 2,450,470 4,034 68,591 21,000 ‐ ‐ 2,459,566 5,003,661 Accumulated depreciation (15,324,464) (6,756,738) (60,870,171) (4,816,234) ‐ (5,178) (24,365,294) (112,138,079) Total noncurrent assets 19,409,489 11,493,333 37,625,994 1,048,292 ‐ 49,435 16,827,169 86,453,712 Liabilities Current liabilities: Accrued Liabilities 10,657 93,379 3,387,631 28,352 ‐ ‐ ‐ 3,520,019 Due to other funds ‐ ‐ ‐ 84,422 ‐ ‐ ‐ 84,422 Notes payable ‐ ‐ ‐ ‐ 461,219 ‐ ‐ 461,219 Interest payable 19,924 29,310 33,777 ‐ ‐ ‐ ‐ 83,011 Compensated absences 121,978 63,400 418,721 78,609 ‐ 2,522 37,739 722,969 Bonds & leases payable ‐ ‐ 1,200,000 ‐ ‐ ‐ 210,000 1,410,000 Total current liabilities 152,559 186,089 5,040,129 191,383 461,219 2,522 247,739 6,281,640 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 3,026,644 8,328,565 ‐ ‐ ‐ 2,676,594 16,903,673 Total noncurrent liabilities 3,025,686 3,062,560 8,792,473 44,533 ‐ 1,430 2,697,974 17,624,656 Total liabilities 3,178,245 3,248,649 13,832,602 235,916 461,219 3,952 2,945,713 23,906,296 Net Position Beginning net position 21,048,269 11,510,943 39,789,394 1,499,580 108,049 596,999 14,270,997 88,824,231 Change in net position 1,363,787 277,302 1,670,502 136,638 547 63,293 (271,755) 3,240,314 Total net position 22,412,056 $ 11,788,245 $ 41,459,896 $ 1,636,218 $ 108,596 $ 660,292 $ 13,999,242 $ 92,064,545 $ ---PAGE BREAK--- October 31, 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 2,947,131 $ 1,380,404 $ 13,621,577 $ 638,225 $ 22,497 $ 469,940 $ 582,598 $ 19,662,372 $ Connection fees 4,429 600 97,820 ‐ ‐ ‐ ‐ 102,849 Miscellaneous 719 ‐ 703,747 (18,607) ‐ ‐ 460 686,319 Total operating revenues 2,952,279 1,381,004 14,423,144 619,618 22,497 469,940 583,058 20,451,540 Operating expenses: Wages and benefits 452,163 199,960 1,677,530 276,889 ‐ 27,408 169,523 2,803,473 Administrative fees 210,244 130,744 544,672 252 ‐ 37,100 31,268 954,280 Purchase power ‐ ‐ 7,904,619 ‐ ‐ ‐ ‐ 7,904,619 Operations and maintenance 428,595 563,837 702,960 144,486 22,149 286,829 177,809 2,326,665 Depreciation and amortization 336,249 157,580 984,879 53,381 ‐ 1,820 403,456 1,937,365 Total operating expenses 1,427,251 1,052,121 11,814,660 475,008 22,149 353,157 782,056 15,926,402 Operating income (loss) 1,525,028 328,883 2,608,484 144,610 348 116,783 (198,998) 4,525,138 Nonoperating revenues (expenses) Investment earnings 18,179 5,205 96,796 1,195 199 797 4,079 126,450 Interest and fiscal charges (39,848) (49,044) (3,127) ‐ ‐ (9,440) (101,461) Impact fees 75,486 146,220 102,956 ‐ ‐ ‐ 6,523 331,185 Gain (loss) on sale of fixed assets 741 ‐ ‐ 900 ‐ ‐ ‐ 1,641 Total nonoperating revenues (expenses) 54,558 102,381 199,750 (1,032) 199 797 1,162 357,815 Income (loss) before transfers 1,579,586 431,264 2,808,234 143,578 547 117,580 (197,836) 4,882,953 Transfers in ‐ 5,280 5,280 ‐ ‐ ‐ 5,004 15,564 Transfers out (215,799) (159,242) (1,143,012) (6,940) ‐ (54,287) (78,923) (1,658,203) Change in net position 1,363,787 $ 277,302 $ 1,670,502 $ 136,638 $ 547 $ 63,293 $ (271,755) $ 3,240,314 $ ---PAGE BREAK--- Statement of Net Position ‐ Internal Service Funds ‐ (Unaudited) October 31, 2014 Central Garage Retained Risk Fund Fund Assets Current assets: Cash and cash equivalents 60,000 $ 1,572,486 $ Investments 14,040 ‐ Inventory 72,872 ‐ Total current assets 146,912 1,572,486 Noncurrent assets: Capital Assets: Machinery and equipment 151,134 ‐ Accumulated depreciation (104,798) ‐ Total noncurrent assets 46,336 ‐ Total assets 193,248 1,572,486 Liabilities Current liabilities: Accrued Liabilities 45 250,000 Compensated absences 22,455 7,033 Total current liabilities 22,500 257,033 Noncurrent liabilities: Compensated absences 9,751 3,054 Total noncurrent liabilities 9,751 3,054 Total liabilities 32,251 260,087 Net Assets Beginning net position 157,593 1,268,857 Change in net position 3,404 43,542 Total net position 160,997 $ 1,312,399 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) October 31, 2014 Central Garage Fund Operating revenues: Charges for services 127,586 $ Miscellaneous 587 Total operating revenues 128,173 Operating expenses: Wages and benefits 101,741 Administrative fees 252 Operations and maintenance 19,184 Depreciation and amortization 1,312 Total operating expenses 122,489 Operating income (loss) 5,684 Nonoperating revenues (expenses) Investment earnings 31 Gain (loss) on sale of fixed assets ‐ Total nonoperating revenues (expenses) 31 Income (loss) before transfers 5,715 Transfers out (2,311) Change in net position 3,404 $ ---PAGE BREAK--- YTD Statement of Revenues, Expenses, and Changes in Net Position ‐ (Unaudited) October 31, 2014 Retained Risk Fund Operating revenues: Charges for services 335,952 $ Miscellaneous ‐ Total operating revenues 335,952 Operating expenses: Wages and benefits 70,104 Administrative fees 168 Operations and maintenance 4,718 Professional Fees 23,423 Insurance 173,473 Claims by department: ADS 250 Police 1,304 Water 3,739 Fire 2,443 Murray Park Golf 182 Power 9,932 Storm Water 425 Total operating expenses 290,161 Operating income (loss) 45,791 Nonoperating revenues (expenses) Investment earnings 2,317 Total nonoperating revenues (expenses) 2,317 Income (loss) before transfers 48,108 Transfers out (4,566) Change in net position 43,542 $