Loading...
HomeMy WebLinkAboutM. 2014 Budget Hearing Session 2: Public Works Presentation 08-20-13iT k L) k 8655 Public Works Budget Presentation August 20, 2013 S ° °TNB,, Public Works U Organizational Structure PEACE a 1865 Citizens of South Bend �7 City Council Mayor City Clerk ELI rblic Works r vironmental Water Solid Waste Streets & Engineering Central Services Services Sewers �.._ Sewage 1 �, Ops /I Local Road \ Sewer & Street Insurance Engineering Energy Traffic & Lighting Central Project Services ik Releaf Water Major Works Moves Solid Waste Public Works Full -Time Positions 380 370 360 340 320 310 305 300 280 260 240 220 200 2004 2012 2013 296 2014 p4 SpUTH 8�,� U PEACE 1865 2 40 69 IF 6 Public Works Full -Time Positions IW by Division ��dz CTS p4 SpUTH 8�,� U PEACE 1865 Solid Waste Street /Sewers Wastewater /Sewers Organic Resources Water Works Energy Central Services Engineering Staff Additions &Consolidations Additions Division Public Works Position Deputy Director PW Sustainability Sustainability Coordinator Consolidations & Reductions p� SpUTN BE,� v o PEACE ► Y a Division Position Environmental Services Wastewater Operators(2) Water Works Meter Reader Serviceman Central Mechanic Services Parts Chaser Solid Waste Superintendent Drivers(3) Engineering CAD Specialist Energy —Director Financial Services 1865 Water Works Fund 620 — Operating Fund 622 - Capital ' I4 .fir • �M . ). . -L - ; t � t Litz •�f'� lop 1 r p� SpU7'N B�lY U PEACE Y a 1865 Safe Drinking Water &Fire Protection 120,000 41,000 6.1 Billion 546 Miles 5,300 Fire Customers Accounts Gallons water Main Hydrants 16,000,000 15,500,000 15,000,000 14,500,000 14,000,000 13,500,000 13,000,000 �l 2013 -2014 .7% Exp Decrease 2008 2009 2010 2011 2012 2013 2014(P) Revenue — Expense Budget Summary: Fund 620 - Water Works Operating 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Chl Revenue Property Taxes Local Income Taxes Other Taxes Grants /Intergovernmental Charges for Services Interest Earnings Other Income Transfers In Total Revenue Expenditures by Account Type Salaries & Wages Fringe Benefits Other Personnel costs Total Personnel Supplies Professional Services (31xx) Comm /Transportation(32xx) Printing & Advertising (33xx) Insurance (34xx) Utilities (35xx) Repairs & Maintenance (36xx) Debt Service - Principal Debt Service - Interest & Fees Other Services & Charges (39xx) Payment In Lieu of Taxes Transfers Out Other Financing Uses 50xx Total Service & Charges Capital Total Expenditures by Type Net Surplus/ (deficit) Beginning Cash Balance Balance Sheet Adjustments Ending Cash Balance 14, 013, 310 15,411,152 14, 526, 748 4,545 10,309 9,000 60,640 101,042 135,500 71,187 76,306 16,500 14,149, 682 15, 598, 809 14, 687, 748 490,602 436,910 623,117 3,088,519 2,992,296 3,202,525 1,002,403 1,059,555 1,211,265 14,476 12,195 21,060 4,105,398 4,064,046 4,434,850 815,729 735,226 1,107,134 2,051,917 1,657,334 2,946,709 286,462 263,304 292,225 33,314 44,400 63,542 197,028 233,736 220,296 591,902 658,144 694,500 490,602 436,910 623,117 5,184 5,186 3,651 609 319 426 104,081 99,016 125,173 1,398,419 1,468,339 1,541,756 4,294,795 5,215,585 2,451,243 673,420 676,261 291,325 10,127, 733 10, 758, 534 9,253,963 15, 048, 860 15, 557, 806 1 (899,178) 41,003 (108,199) 2,599,402 1,726,272 1,760,723 26,048 (6,552) 1,726,272 1,760,723 1,652,524 6,900,816 14, 612, 253 3,416 9,000 87,113 70,580 8,089 19,500 6,999,434 14, 711, 333 170,275 452,511 1,495,202 3,274,099 555,990 1,303,118 4,868 20,425 2,056,060 4,597,642 441,951 1 1,573,511 940,527 1 2,831,795 137,961 88,710 17,919 5,650 110,148 170,656 289,282 717,600 170,275 452,511 2,546 5,210 46 1,345 58,723 107,485 770,878 1,618,844 1,215,466 2,198,609 148,413 317,650 3,862,184 8,516,065 6,360,195 14, 687, 218 639,239 24,115 1,760,723 1,652,524 (343,176) - 2,056,786 1,676,639 85,505 0.6% - 0.0% (64,920) -47.9% 3,000 18.2% 23,585 0.2% 71,574 2.2% 91,853 7.6% (635) -3.0% 162,792 3.7% 466,377 42.1% (114,914) -3.9% (203,515) -69.6% (57, 892) -91.1% (49,640) -22.5% 23,100 3.3% (170,606) -27.4% 1,559 42.7% 919 215.7% (17,688) -14.1% 77,088 5.0% (252,634) -10.3% 26,325 9.0% (737,898) -8.0% -0.7% p4 SpUTH g� re,.ce o 1865 Water Works Key Performance Indicators (KPI) Measure 2016 Goal 2012 Actual 2013 Est 2014 Target AMR Installation Remaining 0 13,361 3,500 0 Unauthorized Water Loss 10% 10% 12% 12% p� SpUTN BE,� U PEACE ° Automated Payments 80% 71% 74% 76% Average MGD Delivered per FT Employee .221 .221 .215 .215 3" and larger Meters Tested Accurate 88% 80% 80% 84% Work Orders Completed on Schedule 98% NA 91% 95% 1865 Solid Waste x f Ak f i F'F{ IWi"SI Nnk}+ i MI.k _ and 610 — Operating Fund 611 — Depreciation p4 SpUTH 8�,� U PEACE 1865 Trash, Yard Waste, Large Items 6,800 Tons 271000 7,800 32,4000 Yard Tons Lar e g Customers Waste Trash Items 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 J] 2008 2009 2013 -2014 xp Decrease 2010 2011 2012 2013 2014(P) or Revenue ■ Expense Budget Summary: Fund 610 - Solid Waste Operating O4 SOUTH g re,.ce o 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes - - - - - - Grants/ Intergovernmental - - - - - - - Charges for Services 4,772,685 4,805,802 4,766,995 2,425,044 4,766,995 - 0.0% Interest Earnings 3,363 5,359 6,000 2,074 6,000 - 0.0% Other Income 53,324 276,188 484,706 13,617 484,706 - 0.0% Transfers In - - - - - - - Total Revenue 4,829,372 5,087,349 5,257,701 2,440,735 5,257,701 Expenditures by Account Type Salaries & Wages 1,130,953 1,177,119 1,201,776 615,429 1,083,411 (118,365) -9.8% Fringe Benefits 386,786 361,343 448,625 216,892 408,297 (40,328) -9.0% Other Personnel costs 8,570 6,065 11,400 4,276 10,346 1,054 -9.2% Total Personnel 1,526,309 1,544,527 1,661,801 836,597 1,502,054 159,747 -9.6% Supplies 268,820 265,630 241,565 128,950 262,472 20,907 8.7% Professional Services (31xx) 716,104 834,198 991,891 399,377 1,018,755 26,864 2.7% Comm /Transportation(32xx) 1,068 3,143 75,172 840 161,875 86,703 115.3% Printing & Advertising (33xx) 34 34 500 70 250 (250) - 50.0% Insurance (34xx) 214,368 117,216 112,992 56,496 183,702 70,710 62.6% Utilities (35xx) - - - - - - - Repairs & Maintenance (36xx) 694,875 663,267 444,196 321,332 428,339 (15,857) -3.6% Debt Service - Principal - - - - - - - Debt Service - Interest & Fees - - - - - - - Other Services & Charges (39xx) 951,827 1,248,089 1,201,306 538,628 1,031,750 (169,556) - 14.1% Transfers Out 238,852 259,200 784,061 514,339 736,002 (48,059) -6.1% Other Financing Uses 50xx 151,079 151,135 52,500 36,462 52,500 - 0.0% Total Service & Charges 2,968,207 3,276,282 3,662,618 1,867,544 3,613,173 49,445 -1.3% Ca ital - - - - - - - Total Expenditures by Type 4,763,336 5,086,439 5,565,984 2,833,091 5,377,699 188,285 -3.4% Net Surplus/ (deficit) 66,036 910 (308,283) (392,356) (119,998) Beginning Cash Balance 1,136,149 1,202,185 1,203,095 1,203,095 894,812 Balance Sheet Adjustments - - - (47,681) Ending Cash Balance 1,202,185 1,203,095 894,812 763,058 774,814 O4 SOUTH g re,.ce o 1865 Solid Waste Key Performance Indicators (KPI) p� SpUTN BE,� U PEACE ° Measure Missed Collection Calls 2016 Goal 2012 Actual I 2013 Est 2014 Target 11251 795 500 N/A On -Time Trash Collection 208 N/A 208 208 Collection Cost per Customer 10.50 N/A 10.56 10.00 1865 Fund 101— 0602 or PEACE 1865 Ile Infrastructure Projects Economic SR 23 Development LTCP Projects Fire Station #5 Two -Way Improvements - Ignition Park - East Bank Streets Fire Training US 31 - Main & - Diamond Facility y Improvements Lafayette - Ivy Tower Public Works Engineering Expense Budget p� SpUTN BE,� U PEACE ° 1865 Budget Summary: Fund 101 -602 - Engineering p4 SpUTH g� � D d PEACE 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes 1,490,080 1,607,493 1,357,461 622,800 1,109,898 (247,563) - 18.2% Local Income Taxes - - - - - - Other Taxes - - - - - - - Grants /Intergovernmental 12,282 - - - - - - Charges for Services - 51,776 30,000 - - (30,000) - 100.0% Interest Earnings - - - - - - - Other Income 44,830 24,968 6,100 4,136 6,100 - 0.0% Transfers In (Engineering Salaries - - - - - - - Total Revenue 1,547,192 1,684,237 1,393,561 626,936 1,115,998 277,563 Expenditures by Account Type Salaries & Wages 805,916 836,565 462,817 213,966 442,910 (19,907) -4.3% Fringe Benefits 234,607 250,377 156,645 77,077 148,401 (8,244) -5.3% Other Personnel costs 15,640 16,255 17,610 5,091 17,610 - 0.0% Tota I Personnel 1,056,163 1,103,197 637,072 296,134 608,921 28,151 -4.4% Su lies 28,467 15,081 18,624 7,938 18,741 117 0.6% Professional Services (31xx) 69,670 51,772 143,966 43,916 178,983 35,017 24.3% Comm /Transportation(32xx) 11,413 8,608 11,000 4,676 12,500 1,500 13.6% Printing & Advertising (33xx) 1,494 769 2,400 609 2,200 (200) -8.3% Insurance (34xx) 174,024 333,684 465,516 232,758 181,468 (284,048) - 61.0% Utilities (35xx) - - - - - - - Repairs & Maintenance (36xx) 70,814 81,646 86,808 30,030 87,355 547 0.6% Debt Service - Principal - - 11,000 620 6,900 (4,100) - 37.3% Debt Service - Interest & Fees - - 1,000 42 830 (170) -17.0% Other Services & Charges (39xx) 11,518 45,296 16,175 10,214 18,100 1,925 11.9% Transfers Out - - - - - - - Other Financing Uses 50xx 89,724 35,784 - - - - - Total Service & Charges 428,657 557,560 737,865 322,864 488,336 249,529 - 33.8% Capital 33,905 8,399 - - - - - Total Expenditures by Type 1,547,192 1,684,237 1,393,561 626,936 1,115,998 277,563 - 19.9% Net Surplus/ (deficit)- - - p4 SpUTH g� � D d PEACE 1865 F SOUTH 8� Engineering Key Performance Indicators (KPI) 1865 Measure 1 2016 Goal 12012 Actual 1 2013 Est 12014 Ta CSO Projects /% On -time & Under Budget 6/100% N/A 4/100% 6/100% Public Outreach Events 1 18 1 N/A 1 12 1 18 Project Scoping Meetings 1 8 1 N/A 1 7 1 8 Central Services Fund 222 p� SpU7'N gE,� v o PEACE ► Y a 1865 1,000+ Pieces of Equipment Central Services $40 M Equipment Value 2,500 PM Services 2.5 M Copies p� SpUTN BE,� U PEACE Y a 5,000 Purchasing Transactions 1865 Public Works p� SpUTN BE,� U PEACE � a Central Services Revenue &Expense Budget' 1865 Budget Summary: Fund 222 - Central Services p4 SpUTH g� re,.ce o 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes - - - - - - Grants/ Intergovernmental - - - - - - - Charges for Services 3,302,589 6,671,970 7,891,203 3,681,197 7,797,184 (94,019) -1.2% Interest Earnings 1,917 4,688 1,500 2,154 3,000 1,500 100.0% Other Income 36,890 31,401 30,000 73,602 47,190 17,190 57.3% Transfers In - - - - - - - Total Revenue 3,341,396 6,708,059 7,922,703 3,756,953 7,847,374 75,329 -1.0% Expenditures by Account Type Salaries & Wages 1,675,830 1,792,209 2,014,910 917,031 2,007,929 (6,981) -0.3% Fringe Benefits 565,248 620,836 785,324 333,397 725,646 (59,678) -7.6% Other Personnel costs 11,165 10,648 13,749 7,584 17,315 3,566 25.9% Total Personnel 2,252,243 2,423,693 2,813,983 1,258,012 2,750,890 63,093 -2.2% Supplies 120,689 134,871 165,665 77,827 157,877 7,788 -4.7% Professional Services (31xx) - 76,073 173,134 80,303 112,236 (60,898) - 35.2% Comm /Transportation(32xx) 11,367 9,679 12,600 3,994 10,500 (2,100) - 16.7% Printing & Advertising (33xx) 3,634 3,373 23,946 5,137 14,500 (9,446) - 39.4% Insurance (34xx) 43,608 25,020 25,320 12,660 32,325 7,005 27.7% Utilities (35xx) 56,513 3,692,681 4,392,180 2,172, 980 4,517,680 125,500 2.9% Repairs & Maintenance (36xx) 83,036 86,477 102,519 44,079 78,619 (23,900) - 23.3% Debt Service - Principal - 5,655 6,275 3,037 6,497 222 3.5% Debt Service - Interest & Fees - 1,069 - - - - - Other Services & Charges (39xx) 13,330 9,362 17,200 2,400 17,400 200 1.2% Transfers Out - - - - - - - Other Financing Uses 50xx 52,116 54,012 - - - - - Total Service & Charges 263,604 3,963,401 4,753,174 2,324,590 4,789,757 36,583 0.8% Ca ital 118,099 171,295 246,607 24,817 - 246,607 - 100.0% Total Expenditures by Type 2,754,635 6,693,260 7,979,429 3,685,246 7,698,524 280,905 -3.5% Net Surplus/ (deficit) 586,761 14,799 (56,726) 71,708 148,850 Beginning Cash Balance 502,823 999,858 1,090,356 1,090,356 1,033,630 Balance Sheet Adjustments (89,726) 75,699 - (38,467) Ending Cash Balance 999,858 1,090,356 1,033,630 1,123,597 1,182,480 p4 SpUTH g� re,.ce o 1865 O SOUTH 8R0 Central Services PEACE Key Performance Indicators (KPI) 1865 Measure Radio Shop Cost /hr Building Maintenance Labor Savings Print Shop Jobs % On -Time Fleet Availability Stores Orders Delivered w /in 24 h rs Technician Productivity 2016 Goal 2012 Actual 2013 Est 2014 Target $56.00 $46.98 $50.00 $54.00 $69,200 $27,724 $25,900 $66,500 99.8% 100% 99.5% 99.8% 98.9% 98.4% 98.4% 98.5% 99.8% 98.3% 99.5% 99.7% 85% 81.2% 83% 84.5% Energy Office / Central Services Monthly Combined Energy Report: Mav 2012 ODMDared to Mav 2013: €alendarized r-y Department Natural Gas Usa May 2013 [THERMS] Notural6as Usc Mey2022 ITHERM5) qqa� C X79 `�, % CHG Fram LY For The MTH YT6 As Of Apr %CFF3From LY Ekxtricity Use Mof ZW 1-1 Ekti idit Use" [K-4 7r +4 p`p %Im fr LT RwThrWM TTBAS Ot wl %COS ft LT Liquid Fuel Lfte" d3 (GALLONS] Liquid Fud USe May 201.2 (GALLONS) �G a .% CHG Fmm LY For The MTH YrD As or May..% €HG From LY Blackthorn -23 332 91 27A536 4O.W.; 22.21T 36,529 114,312; - 39.1.873 - 31.057d Building i -- 41A 70 15.8771 11.5Y,7 €entra1 194 171 22 13.1.29t 66.18% 25,914 31,.303 5,3&3 - 172094 - 1.2874 321 2L6 75 30.3167% 11.85% Century 1, 47, 1,017 457 94.113e 47.5" 164,191 208y88 Ca7g3j - B.357d -.3374 €ode EnFaremaAt "' 2-W 67 163 242A69e 117.523; 7,454 7g87 (42 3} - 5553d Ulm 2 - 1.287 '39'1 -1.7134 4.63% omrnunity sbnerrt See Be" ford= E3 81 ;18) - 221174 - 288596 Eno neering 565.650 617,711 [32,0521 - 5.19°4 -0.6374 E- 140 13 8.9674 -12 E% Fi re 2,498 1.93$ 560 2E.Wlb 49.W.; 165.$32 111,.105 (5,272♦ -4.7531 -3.1874 5 27 - 5,,95 (218) - 3.4674 -189% Garages 74,016 134 (55,502' -06.4574 - 19.0094 MDrris 248 36.1 _d - 31.55 •5-,?'- 69.252 99ym 130'5.2 - 30.'Wa' -29.42°4 Cir1ganic 217 141 T6 54.0771 32.533; 3,124 1.673 1.451 56.743d -1801% Folais 188 275 i G- - 31.75 - 3.45:, 42.,:55 33,867 4.4702 25.5871 4437% Forks 3,513 2,179 1r33i 65.21071 38.23% 3c -'.L" 3-97,174 156,991; - 15.9147♦ -0.747♦ 7,576 7,064 512 7.2574 -&21% police 3,152 2,555 447 18.7471 22.14% 152.-ig1 154,A47 (6,955; -4.36% - 12.4971 2$762 2 =.8t5 1..737 7.2236 -144% ety 7C -.3 27 63.4071 55A7% Sewer 6,843 5,W77 417 15.34% 5 -52°6 Salid Waste MG 6,743 -,.335 19.41% L(4% eek 554 202 351 169.a2',e 2.4N 27,5401 25 ,965 11936 7AS3e 41434 5,405 6,204 ;605• -12.9631 K4A-% Traffic 947 435 12 1.2991 LCA6% Wo,melvaler ..213 6;965 '7751 -8.6396 9.D)% 568,580 &40,8 342,260' - 33.4374 - 18.5'J',i 734 Ev7 6.8636 4.57'6 Water 3.016 5,356 12.3391 -03.6636 fi.43' 574.344 957027 ♦286,52 24.4536 11.71♦ 3,A6J _.99 437 16.057% 017% Total priar m €onvnunity Investment 24,426 23,595 735 3.1071 24.76% 4837,641 3,676,913 "r276J - 22967% -0.417♦ 34,611 63,016 5 ,596 8.61% -0-W% lCommunity Ynesitment 554 431 123 28A6U 5+735.84°6 iC0.526 3L" 96,£62 2515.247♦ 2436.127♦ Grand Tate 980 B57 3.5671 51.1594 933154 3 6$8151 747 94 -26.3 % -6.6771 1 7WAII 63,0161 5 ,596 1 8.6171 NOTES: ' Community InvesU-Irent prDpertir, arerepor4cd saparatrf due to theirtr2rsitiomi nature. ' WeathernoK maliaed data far electridtyis shown inthe r'apntDtneri h. Weather normalixationremoves v=- atiors 'n weather Frrsm year 4D year amd pnavidesanxxe aocumte comparison oFenergy use from yeorto year. {June data is not Dorn Mete) ' Water and Waste Water purchased new d k7el pawmred rquipmentta increase opera6onalcf ciency. Fuel43t2Lfar this equipment are eaodunded f a-m this report to maintain eq ual imparisons to FY 12 blawill be included in FY13 trnals. �AFr F % n! r 1471 - +Vr'F i are nqp6,re value Whok €ity ?TD SUF=W f Natural Electricity Liquid fuels tj 19t 24.7659 - 9.91% -028% CI Wealha NkKrrmked Data for EJeciris3ty ILacalicn- Cia Of &= Be rid -, BOUTHBENDNOM ALIZED 13uA Mid Nowal 04 nmt O7JtL2018. 9,11 AM Conmdk:p- ENuFb [tented Fbr- Jonff"n EAlfoL3 u MCF" Uae N mmaliaed to 2012 .1� Mar rw f Jul S-P N- ■ 2019 E onz 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 0 1I 2008 2009 2010 2011 2012 2013 -2014 3.7% Exp Decrease 2013 2014(P) Revenue F Expense Budget Summary: Fund 202 - Motor Vehicle Highway O4 SOUTH g re,.ce o 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes 4,814,355 4,582,130 4,749,789 2,396,319 5,633,418 883,629 18.6% Grants /Intergovernmental - - - - - - - Charges for Services 206,635 285,824 228,000 277,154 244,000 16,000 7.0% Interest Earnings 5,314 7,431 7,000 5,820 7,000 - 0.0% Other Income 31,190 30,202 80,300 11,462 5,300 (75,000) - 93.4% Transfers In 507,344 2,700,212 3,626,882 2,276,882 2,839,758 787,124 - 21.7% Total Revenue 5,564,838 7,605,799 8,691,971 4,967,637 8,729,476 37,505 0.4% Expenditures by Account Type Salaries & Wages 2,184,361 2,131,503 2,827,204 1,298,444 2,871,156 43,952 1.6% Fringe Benefits 704,887 708,255 999,276 440,126 1,109,559 110,283 11.0% Other Personnel costs 15,050 14,626 19,455 4,867 15,160 4,295 -22.1% Total Personnel 2,904,298 2,854,384 3,845,935 1,743,437 3,995,875 149,940 3.9% Supplies 2,553,941 2,514,308 3,058,845 663,150 2,955,233 103,612 -3.4% Professional Services (31xx) 34,143 5,618 244,643 82,533 338,014 93,371 38.2% Comm /Transportation(32xx) 11,044 7,514 12,080 3,835 10,020 (2,060) -17.1% Printing & Advertising (33xx) 33 248 1,450 33 1,450 - 0.0% Insurance (34xx) 52,044 62,280 73,308 36,654 165,714 92,406 126.1% Utilities (35xx) 47,515 30,806 49,279 28,821 54,856 5,577 11.3% Repairs & Maintenance (36xx) 236,816 947,260 1,287,346 579,203 570,988 (716,358) -55.6% Debt Service - Principal 278 52,851 178,246 49,719 374,121 195,875 109.9% Debt Service - Interest & Fees - - 20,554 3,591 34,274 13,720 66.8% Other Services & Charges (39xx) 3,234 6,648 18,070 5,675 16,230 (1,840) -10.2% Transfers Out - - - - - - - Other Financing Uses 50xx 170,016 105,900 - - - - - Total Service & Charges 555,123 1,219,125 1,884,976 790,064 1,565,667 (319,309) 269.3% Ca p ita I 149,543 159,602 276,740 23,240 212,220 (64,520) -23.3% Total Expenditures by Type 6,162,905 6,747,419 9,066,496 3,219,891 8,728,995 337,501 -3.7% Net Surplus/ (deficit) (598,067) 858,380 (374,525) 1,747,746 481 Beginning Cash Balance 2,012,185 1,414,118 2,272,498 2,272,498 1,897,973 Balance Sheet Adjustments - - - - Ending Cash Balance 1,414,118 2,272,498 1,897,973 4,020,244 1,898,454 O4 SOUTH g re,.ce o 1865 Budget Summary: Fund 251- Local Roads & Streets p4 SpUTH g� re,.ce o 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes - - - - - - Grants/ Intergovernmental 1,030,958 1,022,508 1,052,643 541,644 1,080,000 27,357 2.6% Charges for Services - - - - - - - Interest Earnings 6,031 7,306 8,500 3,922 8,000 (500) -5.9% Other Income - - - - - - - Transfers In - - - - - - - Total Revenue 1,036,989 1,029,814 1,061,143 545,566 1,088,000 26,857 2.5% Expenditures by Account Type Salaries & Wages - - - - - - - Fringe Benefits - - - - - - - Other Personnel costs - - - - - - - Total Personnel - - - - - - - Supplies 459,406 - 400,000 2,570 350,000 50,000 - 12.5% Professional Services (31xx) 7,500 - 77,500 7,500 7,500 (70,000) - 90.3% Comm /Transportation(32xx) - - - - - - - Printing & Advertising (33xx) - - - - - - - Insurance (34xx) 146,292 115,800 - - - - - Utilities (35xx) - - - - - - - Repairs & Maintenance (36xx) - - - - - - - Debt Service - Principal - - - - - - - Debt Service - Interest & Fees - - - - - - - Other Services & Charges (39xx) - - - - - - - Transfers Out - - - - - - - Other Financing Uses 50xx - - - - - - - Tota l Service & Charges 153,792 115,800 77,500 7,500 7,500 (70,000) - 90.3% Ca ital 1,392,543 425,722 758,424 332,665 725,000 33,424 -4.4% Total Expenditures by Type 2,005,741 541,522 1,235,924 342,735 1,082,500 153,424 - 12.4% Net Surplus/ (deficit) (968,752) 488,292 (174,781) 202,831 5,500 Beginning Cash Balance 2,194,756 1,226,004 1,714,296 1,714,296 1,539,515 Balance Sheet Adjustments - - - - - Ending Cash Balance 1,226,004 1,714,296 1,539,515 1,917,127 1,545,015 p4 SpUTH g� re,.ce o 1865 Budget Summary: Fund 640 - Sewer Repair Insurance p4 SpUTH g� re,.ce o le a 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes - - - - - - - Grants /Intergovernmental - - - - - - - Charges for Services 545,666 544,920 548,000 273,364 548,000 - 0.0% Interest Earnings 2,179 5,003 1,200 2,564 1,200 - 0.0% Other Income - - - - - - - Transfers In - - - - - - - Total Revenue 547,845 549,923 549,200 275,928 549,200 - 0.0% Expenditures by Account Type Salaries & Wages 50,022 51,077 88,301 43,426 128,867 40,566 45.9% Fringe Benefits 16,413 17,149 28,554 11,650 47,322 18,768 65.7% Other Personnel costs 660 660 660 330 1,198 538 81.5% Total Personnel 67,095 68,886 117,515 55,406 177,387 59,872 50.9% Su lies 14,712 21,290 16,771 11,942 17,073 302 1.8% Professional Services (31xx) - - 8,940 4,470 14,845 5,905 66.1% Comm /Transportation(32xx) 410 360 480 180 360 (120) -25.0% Printing & Advertising (33xx) - - - - 237 237 - Insurance (34xx) - - - - - - - Utilities (35xx) - - - - - - - Repairs & Maintenance (36xx) 171,647 190,443 377,663 99,530 303,199 (74,464) -19.7% Debt Service - Principal - 14,218 26,410 13,290 26,580 170 0.6% Debt Service - Interest & Fees - - 2,065 928 1,855 (210) -10.2% Other Services & Charges (39xx) 290 - - - Transfers Out - - - - - - - Other Financing Uses 50xx 14,527 14,578 6,000 2,362 6,000 - 0.0% Total Service & Charges 186,874 219,599 421,558 120,760 353,076 (68,482) 11.8% Capital - - - - - - Total Expenditures by Type 268,681 309,775 555,844 188,108 547,536 8,308 -1.5% Net Surplus/ (deficit) 279,164 240,148 (6,644) 87,820 1,664 Beginning Cash Balance 638,404 921,234 1,160,017 1,160,017 1,153,373 Balance Sheet Adjustments 3,666 (1,365) - - - Ending Cash Balance 921,234 1,160,017 1,153,373 1,247,837 1,155,037 p4 SpUTH g� re,.ce o le a 1865 Budget Summary: Fund 655 - Project Releaf p4 SpUTH g� re,.ce o le a 1865 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes - - - - - - - Grants /Intergovernmental - - - - - - - Charges for Services 429,327 428,726 429,000 215,521 429,000 - 0.0% Interest Earnings 2,111 4,230 2,700 1,821 2,700 - 0.0% Other Income - - - - - - - Transfers In - - - - - - - Total Revenue 431,438 432,956 431,700 217,342 431,700 - 0.0% Expenditures by Account Type Salaries & Wages 39,211 43,772 59,252 760 59,252 - 0.0% Fringe Benefits 3,296 3,645 5,126 330 5,126 - 0.0% Other Personnel costs - - - - - Total Personnel 42,507 47,417 64,378 1,090 64,378 - 0.0% Su lies 7,799 6,688 7,432 347 7,067 365 -4.9% Professional Services (31xx) - 12,312 21,984 9,462 23,190 1,206 5.5% Comm /Transportation(32xx) - - - - - - - Printing & Advertising (33xx) - - - - - - - Insurance (34xx) 12 12 12 6 396 384 3200.0% Utilities (35xx) - - - - - - - Repairs & Maintenance (36xx) 52,421 20,506 39,760 442 5,000 (34,760) - 87.4% Debt Service - Principal - - 36,784 11,001 67,079 30,295 82.4% Debt Service - Interest & Fees - - 5,715 618 5,705 (10) -0.2% Other Services & Charges (39xx) - - - - - - - Transfers Out 230,000 240,000 250,000 250,000 250,000 - 0.0% Other Financing Uses 50xx 12,059 13,717 6,000 2,521 6,000 - 0.0% Total Service & Charges 294,492 286,547 360,255 274,050 357,370 2,885 -0.8% Capital - - - - - - Total Expenditures by Type 344,798 340,652 432,065 275,487 428,815 3,250 -0.8% Net Surplus/ (deficit) 86,640 92,304 (365) (58,145) 2,885 Beginning Cash Balance 682,298 768,938 861,242 861,242 860,877 Balance Sheet Adjustments - - - (3,293) Ending Cash Balance 768,938 861,242 860,877 799,804 863,762 p4 SpUTH g� re,.ce o le a 1865 Budget Summary: Fund 641- Wastewater Operating 34,982,238 14,438,817 33,863,857 1,118,381 -3.2% 2013 2014 2011 2012 Amended 6/30/13 Proposed Variance % Description Actual Actual Budget Actual Budget 2013 -2014 Ch - (434,399) Revenue Property Taxes - - - - - - - Local Income Taxes - - - - - - Other Taxes - - - - - - - Grants /Intergovernmental - - - - - - - Charges for Services 28,701,088 30,906,614 33,008,547 15,447,701 34,460,188 1,451,641 4.4% Interest Earnings 19,879 16,545 12,000 8,972 18,000 6,000 50.0% Other Income 167,635 74,513 93,000 23,338 60,000 (33,000) -35.5% Transfers In 8,429 99,281 18,000 10,359 15,000 3,000 -16.7% Total Revenue 28,897,031 31,096,953 33,131,547 15,490,370 34,553,188 1,421,641 4.3% Expenditures by Account Type Salaries & Wages 4,083,671 4,117,539 4,995,042 2,326,135 4,903,889 (91,153) -1.8% Fringe Benefits 1,289,298 1,346,200 1,724,766 813,511 1,843,533 118,767 6.9% Other Personnel costs 22,827 18,749 30,480 14,593 36,314 5,834 19.1% Total Personnel 5,395,796 5,482,488 6,750,288 3,154,239 6,783,736 33,448 0.5% Su lies 1,643,753 1,605,394 2,117,515 813,441 2,056,422 61,093 -2.9% Professional Services (31xx) 1,824,024 1,667,433 4,216,188 1,674,605 2,899,668 (1,316,520) -31.2% Comm /Transportation(32xx) 45,508 46,324 50,822 17,409 44,374 (6,448) -12.7% Printing & Advertising (33xx) 2,892 2,590 3,450 1,197 2,400 (1,050) -30.4% Insurance(34xx) 240,444 230,640 244,368 122,184 318,961 74,593 30.5% Utilities (35xx) 821,795 835,259 882,288 454,964 999,131 116,843 13.2% Repairs & Maintenance (36xx) 1,430,553 1,240,054 1,413,636 618,246 1,821,672 408,036 28.9% Debt Service - Principal - 114,793 270,056 117,613 323,094 53,038 19.6% Debt Service - Interest & Fees - - 44,840 16,768 36,652 (8,188) -18.3% Other Services & Charges (39xx) 32,456 137,941 68,990 14,089 135,890 66,900 97.0% Payment In Lieu of Taxes 2,290,752 2,405,289 2,775,553 1,387,777 2,914,331 138,778 5.0% Transfers Out 18,112,142 11, 900, 317 13, 377, 561 5,020,395 13, 548, 940 171,379 1.3% Other Financing Uses 50xx 2,726,212 3,471,959 2,766,683 1,025,890 1,978,586 788,097 -28.5% Total Service & Charges 27,526,778 22,052,599 26,114,435 10,471,137 25,023,699 1,090,736 -4.2% Capital - - - - - - - Total Expenditures by Type 34,566,327 29,140,481 34,982,238 14,438,817 33,863,857 1,118,381 -3.2% Net Surplus/ (deficit) (5,669,296) 1,956,472 (1,850,691) 1,051,553 689,331 Beginning Cash Balance 8,381,409 2,716,928 4,431,153 4,431,153 2,580,462 Balance Sheet Adjustments 4,815 (242,247) - (434,399) Ending Cash Balance 2,716,928 4,431,153 2,580,462 5,048,307 3,269,793 04 SpUTH g� � D u o WPFAIM 1865