Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
20140821Approved Water Sewer Fund FY15 Budget.xlsx
CITY OF TYBEE ISLAND UPDATED WATER & SEWER ENTERPRISE FUND FISCAL YEAR 2014-2015 DETAILED REVENUE AND EXPENSE PROPOSED BUDGET WITH VARIANCES FOR SALARY INCREASES Fund REVENUE 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 EXPENSES FINANCE DEPARTMENT W&S ADMINISTRATION 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 SEWER ADMINISTRATION DIVISION 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 WATER ADMINISTRATION DIVISION 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 OTHER FINANCING USES 505 505 505 505 Dept 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 Total 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 9000 9000 9000 9000 9000 Total Grand Total Object 33 33 33 33 33 33 Total 34 34 34 34 34 34 34 34 34 34 34 Total 36 36 Total 38 38 38 38 38 Total 39 39 39 39 39 39 39 Total Grand Total 51 51 51 51 51 51 51 51 51 52 52 52 52 52 52 53 52 51 51 51 51 51 51 51 51 51 51 51 Total 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 Total 53 53 53 53 53 53 53 53 53 53 53 Total 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 54 Total 55 55 55 55 55 Total 56 56 Total 58 58 58 58 58 Total Grand Total 51 51 51 51 51 51 51 51 51 51 51 51 Total 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 Total 53 53 53 53 53 53 53 53 53 53 53 53 Total 54 54 54 54 54 54 54 54 54 54 54 54 54 Total 55 55 55 55 55 Total 56 56 Total 57 57 57 Total 58 58 58 58 58 58 58 58 58 58 58 Total Grand Total 61 4400 ???? 2900 4210 4215 4255 6901 6902 6903 6904 6905 6906 1000 1002 9001 9002 9003 1201 1300 2100 3000 3501 3502 1100 1300 1400 2100 2200 2300 2400 2600 2700 3100 3220 3400 3500 3700 1100 3990 1100 1111 1300 1400 2100 2200 2300 2400 2700 2900 1200 1201 1202 1230 1310 2110 2200 2201 2202 2203 2205 2320 3100 3201 3202 3203 3220 3300 3400 3500 3600 3700 3850 3901 1100 1210 1230 1270 1400 1600 1700 1720 1730 1740 1400 1401 1402 1403 1404 1405 1406 1407 1409 1410 1411 2100 2200 XXXX XXXX XXXX XXXX XXXX XXXX 2501 1005 1008 1010 1100 1000 2201 2202 XXXX 2301 1100 1111 1300 1400 2100 2200 2300 2400 2600 2700 2900 1200 1201 1202 1230 1300 1310 2201 2202 2203 2205 2320 3100 3201 3202 3203 3204 3220 3300 3330 3400 3500 3600 3700 3850 3901 3920 3950 1100 1102 1210 1230 1270 1400 1560 1592 1600 1702 1720 1201 2100 2105 2107 2200 2400 2500 2501 XXXX XXXX XXXX XXXX 1005 1008 1010 1100 1000 4000 4001 2100 2200 2200 2201 2203 2205 2300 XXXX 3000 1000 Account Description GEFA Loan Proceeds -AMR GEFA Loan Proceeds - ( #7 Main) GMA Loan or SPLOST 2014 GEFA Loan Proceeds (Jones Water Line) GEFA Loan Proceeds - ( #6 Main) Intergovermental Revenues Water Sewer Cost Reimbursemen Water charges Capital Cost Recovery Sewer charges Other fees - tapping fees Other fees - stubbing fees Aid to Construction Delinquent Charges Other fees Chatham contrct pa Other Fees - Cuts, Transfers, Charges for Services Interest Investment Income Tower Space Rental Revenue W/S Settlement W/S Misc Other Income Service CHG RET'D checks Miscellaneous Revenue Transfer In Prior Year Fund Balance Sales of Assets Proceeds from Long Term Liab Proceeds from GMA Leases Proceeds from Gen Fund Note Other Financing Sources Salaries & Wages Overtime Employee Benefits Health Insurance Benefits FICA Soc Sec Contribution FICA Medicare Contributio Retirement Contributions Unemployment Insurance Py Workers Compensation Cola and\or merit and\or bonus Property & Liability Ins Contract Services - Collection Agent Postage & Freight Printing & Binding Travel & Related Education & Training Supplies & Materials Service Charges Salaries & Wages Accrued Vacation Adjustme Overtime Wages Employee Benefits Health Insurance Benefits FICA Contributions FICA Medicare Contributio Retirement Contributions Workers Compensation Wellness Benefits Cola and\or merit and\or bonus Salaries & Benefits: Legal Engineering/permits Engineering/studies Contract Services Medical Screening Water Analysis Dumping Charges Termite/ Pest control WW Repair & Maintain - Bldgs Repair & Maintain - Vehic Repair & Maintain - Equip Repair & Maint -Infrastru Rental Equipment Property & Liability Ins Telephones Fax/Data Lines Cell Phones Postage & Freight Advertising Printing & Binding Travel & Related Expense Dues & Fees Education & Training Contract Labor Credit Card Collection Ch Purchased\Contracted Services Supplies & Materials Water & Sewer Services Electricity Gasoline & Diesel Fuel Books & Periodicals Small Equipment Safety Equipment Uniforms Ultraviolet Disinfection Sludge Belt Press Parts Supplies Capital Building Sewer Line Rehab & Improv Lift Station # 7 Force Main Rehab Lift Station #9 Sewer Lift Station #11 Hwy 80 Water Sewer Projec Lift Station #6 Improveme Waste Water Treatment Pla Sewer Main Liftstation #3 Sewer Main Liftstation # 6 Water Reuse Pump Station Machinery & Equipment (Sludge Thickerner) Vehicles Capital Equipment Capital Outlay Indirect Allocation - A Indirect Allocation - P Indirect Allocation - Acc Administrative Svcs - Gen Cost Allocations Depreciation Depreciation GMA Leases - Interest Exp Gen Fund Note - Interest GEFA Loan Closing Fees Int Exp Loan GEFA CW00014 Debt Service SEWER ADMINSTRATION Salaries & Wages Accrued Vacation Adjustme Overtime Employee Benefits Health Insurance Benefits Social Security Contribut FICA Medicare Contributio Retirement Contributions Unemployment Insurance Workers Compensation Wellness Benefit Program Cola and\or merit and\or bonus Salaries & Benefits: Legal Engineering/permits Engineering/studies servi Medical Screening Computer Svc Contracts Water Analysis Repair & Maintain - Build Repair & Maintain - Vehic Repair & Maintain - Equip Repair & Maint- Infrastru Rental of Equip & Vehicle Property & Liability Insu Telephone Data & Fax Lines Cell Phones Pagers & Beepers Postage & Freight Advertising Legal Notices Printing & Binding Travel & Related Expenses Dues & Fees Education & Training Contract Labor Credit Card Svc. Charges Safety Equipment Water Conservation Measure Purchased\Contracted Services Supplies & Materials Fire hydrants, gates, val Water/Sewer Charges Electricity Gasoline & Diesel Fuel Books & Periodicals Inventory - Water Meters& Sprinkler meters-repurcha Small equipment Cash - Long / Short Uniform /Clothing Supplies Site Improvement Machinery & Equipment GEFA Ft. Screven Water L Jones Avenue Water Line Vehicles Engineering for Water Lin Capital outlay - water wells Control Equipment - Infrastructure - Rehab Fort Screven Well Capital Outlay Indirect Allocation - A Indirect Allocation - P Indirect Allocation - Acc Admin Service - General F Cost Allocations Depreciation Depreciation Bad debt Other Expense Payments to Others Int Exp Rev Bond 2005 456 Int Exp BBT Loan AMR 2009 Int Exp Loan GEFA FY2014 Loan Int Exp GEFA Loan 2013L35WJ Int Exp 006 Loan Grit Sep Bond Amortization Costs Int Exp GELAC Loan L48WS Int Exp GEFA Loan L22WS 2 GEFA Loan Closing Fee Bond Admin Cost Debt Service WATER ADMINISTRATION Prior Year Budget Fund Balance Transfer to General Fund(reim FY14) Transfer to General Fund (prior yr's IT) Contingency Other Financing Uses ALL WATER AND SEWER NET Dept Request 1.5% Cola FY15 Budget 0 492375 0 500000 500000 1492375 0 1111500 10000 1411500 4000 2000 20000 32000 0 5000 2596000 25000 25000 160000 0 3000 400 163400 0 856372 0 0 0 0 856372 5133147 46160 333 0 7508.4 2863 670 4922 0 170 651 28 1200 20166 57 800 1500 667 22000 109695.4 201916 0 7000 4800 51022 13139 3073 23725 3250 0 2715 310640 30800 5000 12312 25000 45000 500 5000 8000 40000 81000 10000 29537 0 0 0 7000 100 0 2000 3500 4000 2000 310749 45000 0 141665 10000 1000 10000 3000 4000 22000 25000 261665 0 0 492375 0 0 0 0 0 0 0 500000 0 770000 0 0 0 0 0 0 0 0 1762375 8567 1244 28732 0 38543 270000 270000 0 0 8500 44074 52574 3006546 159237 0 9000 4800 30940 10617 2483 22300 0 11660 0 2502 253539 0 0 0 0 3000 10000 8000 7000 30000 53224 0 25200 0 0 0 0 7000 7000 0 0 2000 10500 3000 0 6000 2000 8000 181924 35000 4000 40000 36800 10000 0 8000 0 5000 0 3000 141800 0 7000 0 500000 0 0 0 0 65000 0 0 0 572000 8567 1244 28237 0 38048 285000 285000 10288 10288 11347 0 105600 13737.66 0 0 36381 47041 16500 1700 232306.66 1714905.66 0 302000 0 0 302000 5133147.06 -6.00000005215406E-02 Dept Request 1.5% Cola & 1.5% Merit FY15 Budget 0 492375 0 500000 500000 1492375 0 1111500 10000 1411500 4000 2000 20000 32000 0 5000 2596000 25000 25000 160000 0 3000 400 163400 0 862240 0 0 0 0 862240 5139015 46160 333 0 7508.4 2863 670 4922 0 170 1302 28 1200 20166 57 800 1500 667 22000 110346.4 201916 0 7000 4800 51022 13139 3073 23725 3250 0 5430 313355 30800 5000 12312 25000 45000 500 5000 8000 40000 81000 10000 29537 0 0 0 7000 100 0 2000 3500 4000 2000 310749 45000 0 141665 10000 1000 10000 3000 4000 22000 25000 261665 0 0 492375 0 0 0 0 0 0 0 500000 0 770000 0 0 0 0 0 0 0 0 1762375 8567 1244 28732 0 38543 270000 270000 0 0 8500 44074 52574 3009261 159237 0 9000 4800 30940 10617 2483 22300 0 11660 0 5004 256041 0 0 0 0 3000 10000 8000 7000 30000 53224 0 25200 0 0 0 0 7000 7000 0 0 2000 10500 3000 0 6000 2000 8000 181924 35000 4000 40000 36800 10000 0 8000 0 5000 0 3000 141800 0 7000 0 500000 0 0 0 0 65000 0 0 0 572000 8567 1244 28237 0 38048 285000 285000 10288 10288 11347 0 105600 13737.66 0 0 36381 47041 16500 1700 232306.66 1717407.66 0 302000 0 0 302000 5139015.06 -6.00000005215406E-02 Dept Request 1.5% Cola & 2.5% Merit FY15 Budget 0 492375 0 500000 500000 1492375 0 1111500 10000 1411500 4000 2000 20000 32000 0 5000 2596000 25000 25000 160000 0 3000 400 163400 0 866299 0 0 0 0 866299 5143074 46160 333 0 7508.4 2863 670 4922 0 170 1753 28 1200 20166 57 800 1500 667 22000 110797.4 201916 0 7000 4800 51022 13139 3073 23725 3250 0 7309 315234 30800 5000 12312 25000 45000 500 5000 8000 40000 81000 10000 29537 0 0 0 7000 100 0 2000 3500 4000 2000 310749 45000 0 141665 10000 1000 10000 3000 4000 22000 25000 261665 0 0 492375 0 0 0 0 0 0 0 500000 0 770000 0 0 0 0 0 0 0 0 1762375 8567 1244 28732 0 38543 270000 270000 0 0 8500 44074 52574 3011140 159237 0 9000 4800 30940 10617 2483 22300 0 11660 0 6733 257770 0 0 0 0 3000 10000 8000 7000 30000 53224 0 25200 0 0 0 0 7000 7000 0 0 2000 10500 3000 0 6000 2000 8000 181924 35000 4000 40000 36800 10000 0 8000 0 5000 0 3000 141800 0 7000 0 500000 0 0 0 0 65000 0 0 0 572000 8567 1244 28237 0 38048 285000 285000 10288 10288 11347 0 105600 13737.66 0 0 36381 47041 16500 1700 232306.66 1719136.66 0 302000 0 0 302000 5143074.06 -6.00000005215406E-02 Dept Request 1.5% Cola & Bonus FY15 Budget 0 492375 0 500000 500000 1492375 0 1111500 10000 1411500 4000 2000 20000 32000 0 5000 2596000 25000 25000 160000 0 3000 400 163400 0 869613 0 0 0 0 869613 5146388 46160 333 0 7508.4 2863 670 4922 0 170 2051 28 1200 20166 57 800 1500 667 22000 111095.4 201916 0 7000 4800 51022 13139 3073 23725 3250 0 8959 316884 30800 5000 12312 25000 45000 500 5000 8000 40000 81000 10000 29537 0 0 0 7000 100 0 2000 3500 4000 2000 310749 45000 0 141665 10000 1000 10000 3000 4000 22000 25000 261665 0 0 492375 0 0 0 0 0 0 0 500000 0 770000 0 0 0 0 0 0 0 0 1762375 8567 1244 28732 0 38543 270000 270000 0 0 8500 44074 52574 3012790 159237 0 9000 4800 30940 10617 2483 22300 0 11660 0 8099 259136 0 0 0 0 3000 10000 8000 7000 30000 53224 0 25200 0 0 0 0 7000 7000 0 0 2000 10500 3000 0 6000 2000 8000 181924 35000 4000 40000 36800 10000 0 8000 0 5000 0 3000 141800 0 7000 0 500000 0 0 0 0 65000 0 0 0 572000 8567 1244 28237 0 38048 285000 285000 10288 10288 11347 0 105600 13737.66 0 0 36381 47041 16500 1700 232306.66 1720502.66 0 302000 0 0 302000 5146388.06 -6.00000005215406E-02 Variance between FY15 vs FY14 0 492375 0 500000 -1222376 -230001 0 52000 0 52000 0 0 0 0 0 0 104000 0 0 0 0 0 0 0 -302000 782015 -10000 0 0 0 470015 344014 0 0 0 -248.6 0 0 0 0 0 2051 28 1200 20166 0 0 0 0 22000 45196.4 25116 0 -2500 1800 15280 1762 52 3140 172 0 8959 53781 0 -12400 5000 12312 0 0 10000 0 0 3000 5000 -800 -32000 0 0 0 0 -10000 40 0 0 -3000 0 0 0 -22848 10000 0 6725 10000 1000 0 0 0 3450 4050 35225 0 0 492375 0 0 0 0 0 0 -377000 -222378 -100000 695000 -20929 0 0 0 0 0 0 0 467068 0 0.5 0 0 0.5 20000 20000 0 0 8500 -9324 -824 552402.5 -5085 0 0 1800 3370 -315 -73 4600 0 887 0 8099 13283 0 0 -15000 0 0 0 3000 0 0 0 0 1626 0 0 0 0 -5000 1000 0 0 0 0 1000 0 1000 0 0 -12374 5000 0 10000 1800 -10000 0 -22000 0 1000 0 0 -14200 0 -41901 0 -500000 0 -45000 -125000 0 65000 0 0 0 -646901 0 0 -495 0 -495 0 0 10288 0 10288 -5579 -14420 105600 13737.66 -1777 -14300 -1791 -3157 16500 0 94813.66 -555585.34 0 302000 0 0 302000 344013.56 0.439999999944121 Status Quo FY14 Budget 0 0 0 0 1722376 1722376 0 1059500 10000 1359500 4000 2000 20000 32000 0 5000 2492000 25000 25000 160000 0 3000 400 163400 302000 87598 10000 0 0 0 399598 4802374 46160 333 0 7757 2863 670 4922 0 170 0 0 0 57 800 1500 667 0 65899 176800 0 9500 3000 35742 11377 3021 20585 3078 0 263103 0 43200 0 0 0 25000 35000 500 5000 5000 35000 81800 42000 29537 0 0 0 17000 60 0 2000 6500 4000 0 2000 333597 35000 0 134940 0 0 10000 3000 4000 18550 20950 226440 0 0 0 0 0 0 0 0 0 377000 722378 100000 75000 20929 0 0 0 0 0 0 0 1295307 8567 1243.5 28732 0 38542.5 250000 250000 0 0 0 53398 53398 2460387.5 164322 0 9000 3000 27570 10932 2556 17700 0 10773 0 245853 0 0 15000 0 3000 10000 5000 7000 30000 53224 0 23574 0 0 0 0 12000 6000 0 0 2000 10500 2000 0 5000 2000 8000 194298 30000 4000 30000 35000 20000 0 30000 0 4000 0 3000 156000 0 48901 0 1000000 0 45000 125000 0 0 0 0 0 1218901 8567 1243.5 28732 0 38542.5 285000 285000 0 0 0 16926 14420 0 0 1777 14300 38172 50198 0 1700 137493 2276087.5 0 0 0 0 0 4802374 0 FY14 Actual 6-3-2014 0 0 0 0 0 0 988.74 862254.4 26000 1183801.02 10065.2 7700 38184 32980 0 5110 2167083.36 14.31 14.31 164096.26 0 16647.54 128 180871.8 302000 0 379.25 0 0 0 302379.25 2650348.72 38276.86 116.84 0 8864.22 2302.93 538.66 4510.99 0 139.69 0 0 0 0 0 418 92.99 0 55261.18 163414.22 0 7190.4 2065.89 34063.58 10723.54 2507.95 18645.77 2416.39 0 241027.74 0 43200 0 0 0 16674.76 37260.61 0 4106.8 2632.77 24566.48 66248.61 29445.8 29524.73 0 0 0 7453.08 20 0 174.72 6271.51 2421.92 0 0 270001.79 28199.43 0 114774.58 949.74 0 8587.49 2330.56 1216.82 14423.85 18611.46 189093.93 0 0 0 0 0 0 0 0 0 298810.5 29100 0 63783 4384 0 0 0 0 0 0 0 396077.5 8567.16 1243.32 28731.84 0 38542.32 0 0 0 0 0 40693.54 40693.54 1175436.82 150399.06 0 12000.29 2066.22 25790.4 10087.37 2359.11 16194.64 0 8992.14 0 227889.23 0 0 0 0 1025 10000 3024.08 1742.21 22696.63 39895.26 0 23827.72 0 0 0 0 8056.34 20 0 0 0 9888.67 786.77 0 5290 1855.41 2926.9 131034.99 16564 0 34514.6 36695.29 17003.72 0 29791.71 0 1921.02 0 1496.77 137987.11 0 39573.1 0 9618 0 25700 0 0 0 0 0 0 74891.1 8567.16 1243.32 28731.84 0 38542.32 0 0 17355.03 0 17355.03 16926 418.04 0 0 1324.05 0 31796.12 41832.16 0 308.32 92604.69 720304.47 0 0 0 0 0 1951002.47 699346.25 FY14 Budget Balance 0 0 0 0 1722376 1722376 -988.74 197245.6 -16000 175698.98 -6065.2 -5700 -18184 -980 0 -110 324916.64 24985.69 24985.69 -4096.26000000001 0 -13647.54 272 -17471.8 0 87598 9620.75 0 0 0 97218.75 2152025.28 7883.14 216.16 0 -1107.22 560.07 131.34 411.01 0 30.31 0 0 0 57 800 1082 574.01 0 10637.82 13385.78 0 2309.6 934.11 1678.42 653.459999999999 513.05 1939.23 661.61 0 22075.26 0 0 0 0 0 8325.24 -2260.61 500 893.2 2367.23 10433.52 15551.39 12554.2 12.2700000000004 0 0 0 9546.92 40 0 1825.28 228.49 1578.08 0 2000 63595.21 6800.57 0 20165.42 -949.74 0 1412.51 669.44 2783.18 4126.15 2338.54 37346.07 0 0 0 0 0 0 0 0 0 78189.5 693278 100000 11217 16545 0 0 0 0 0 0 0 899229.5 -0.159999999999854 0.180000000000064 0.159999999999854 0 0.180000000000064 250000 250000 0 12704.46 12704.46 1284950.68 13922.94 0 -3000.29 933.78 1779.6 844.629999999999 196.89 1505.36 0 1780.86 0 17963.77 0 0 15000 0 1975 0 1975.92 5257.79 7303.37 13328.74 0 -253.720000000001 0 0 0 0 3943.66 5980 0 0 2000 611.33 1213.23 0 -290 144.59 5073.1 63263.01 13436 4000 -4514.6 -1695.29 2996.28 0 208.290000000001 0 2078.98 0 1503.23 18012.89 0 9327.9 0 990382 0 19300 125000 0 0 0 0 0 1144009.9 -0.159999999999854 0.180000000000064 0.159999999999854 0 0.180000000000064 285000 285000 -17355.03 0 -17355.03 0 14001.96 0 0 452.95 14300 6375.88 8365.84 0 1391.68 44888.31 1555783.03 0 0 0 0 0 2851371.53 -699346.25 FY13 Actual 0 0 0 0 0 0 0 1150000 15000 1350000 5000 3000 20000 50000 0 8000 2601000 18000 18000 120000 0 5000 400 125400 0 0 38000 0 0 0 38000 2782400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 166365.17 4476.27 5647.65 2375 33910.06 10458.85 2560.98 11521.68 5784.35 0 243100.01 0 18400 0 0 0 14747.19 31297.48 0 2233.29 1625.4 75435.83 24323.84 17379.95 55824.31 0 0 0 8771.76 0 0 0 1170.67 1202 0 513.76 252925.48 43089.75 0 118218.67 0 0 11525.37 0 691.53 8934.31 3113.44 185573.07 0 0 0 0 0 0 0 136266 0 0 0 0 264259.75 0 0 0 0 0 0 0 10812.67 411338.42 0 0 0 79200 79200 261801.85 261801.85 57588.25 57588.25 1491527.08 156978.8 824.83 11024.72 2062.5 22922.66 10636.66 2487.57 25686.24 12445.25 245069.23 0 0 0 0 0 0 0 2891.62 17993.11 70523.21 0 7898.23 0 0 0 0 10356.74 4001.56 0 0 138.17 769.17 500 0 5099.28 0 1634.51 121805.6 19488.97 265.72 43998.14 40070.75 20639.05 0 47345.48 0 4020.59 0 2380.26 178208.96 0 0 0 0 0 0 53550 0 0 0 0 0 53550 0 0 0 79200 79200 255081.07 255081.07 8036.61 0 8036.61 23646.75 4829.88 0 0 6873.3 56884.5 43032.76 57556.97 0 1475 194299.16 1135250.63 0 2626777.71 155622.290000001 Variance between FY15 vs FY13 0 492375 0 500000 500000 1492375 0 -38500 -5000 61500 -1000 -1000 0 -18000 0 -3000 -5000 7000 7000 40000 0 -2000 0 38000 0 869613 -38000 0 0 0 831613 2363988 46160 333 0 7508.4 2863 670 4922 0 170 28 1200 20166 57 800 1500 667 22000 109044.4 35550.83 -4476.27 1352.35 2425 17111.94 2680.15 512.02 12203.32 -2534.35 0 64824.99 0 12400 5000 12312 0 10252.81 13702.52 500 2766.71 6374.6 -35435.83 56676.16 -7379.95 -26287.31 0 0 0 -1771.76 100 0 2000 2329.33 2798 0 1486.24 57823.52 1910.25 0 23446.33 10000 1000 -1525.37 3000 3308.47 13065.69 21886.56 76091.93 0 0 492375 0 0 0 0 -136266 0 0 500000 0 505740.25 0 0 0 0 0 0 0 -10812.67 1351036.58 8567 1244 28732 -79200 -40657 8198.14999999999 8198.14999999999 0 0 8500 -13514.25 -5014.25 1512303.92 2258.20000000001 -824.83 -2024.72 2737.5 8017.34 -19.6599999999999 -4.57000000000016 -3386.24 0 -785.25 0 8099 14066.77 0 0 0 0 3000 10000 8000 4108.38 12006.89 -17299.21 0 17301.77 0 0 0 0 -3356.74 2998.44 0 0 1861.83 9730.83 2500 0 900.72 2000 6365.49 60118.4 15511.03 3734.28 -3998.14 -3270.75 -10639.05 0 -39345.48 0 979.41 0 619.74 -36408.96 0 7000 0 500000 0 0 -53550 0 65000 0 0 0 518450 8567 1244 28237 -79200 -41152 29918.93 29918.93 2251.39 0 2251.39 -12299.75 -4829.88 105600 13737.66 -6873.3 -56884.5 -6651.76 -10515.97 16500 225 38007.5 585252.03 0 0 0 0 0 2206600.35 157387.649999999 FY12 Actual 0 0 0 0 0 0 2375.16 981759.2 10000 1395076.49 4825.2 2750 16006 43794 0 6272 2462858.05 20031.99 20031.99 165255.48 0 3999 576 169830.48 0 0 0 0 0 0 0 2652720.52 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 199942.62 0 4212.37 2687.5 41876.52 11666.64 2613.47 10810.68 1751.35 0 275561.15 0 18765 0 0 0 8457.1 37568.25 0 3510.72 3779.91 68398.24 32082.63 3167.25 37122.5 0 0 0 9852.73 20 0 7 810 1428.5 0 1128.67 226098.5 33342.7 0 131955.15 0 0 4948.17 0 1597.37 13074 19860.51 204777.9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72000 72000 213518.27 213518.27 0 0 0 58073.84 58073.84 1050029.66 116466.73 0 9179.58 1562.5 12187.12 8493.03 1986.29 21556.56 0 6655.74 0 178087.55 0 0 0 0 1652.84 9710 185.82 3967.62 39159.17 76839.64 0 2559 0 0 0 0 8754.54 3961.56 0 0 63 9226.2 1225 0 4019.19 0 4394.22 165717.8 25398.49 4227.24 36884.22 35704.66 20107.31 736.96 23713.79 954 7609.4 0 358.86 155694.93 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72000 72000 277212.61 277212.61 26142.48 26142.48 30777 8430.93 0 0 10942.98 14221.13 41447.96 56218.46 0 1620.83 163659.29 1038514.66 0 0 0 0 0 2088544.32 564176.2 Variance between FY15 vs FY12 0 492375 0 500000 500000 1492375 -2375.16 129740.8 0 16423.51 -825.2 -750 3994 -11794 0 -1272 133141.95 4968.01 4968.01 -5255.48000000001 0 -999 -176 -6430.48000000001 0 869613 0 0 0 0 869613 2493667.48 46160 333 0 7508.4 2863 670 4922 0 170 28 1200 20166 57 800 1500 667 22000 109044.4 1973.38 0 2787.63 2112.5 9145.48 1472.36 459.53 12914.32 1498.65 0 32363.85 0 12035 5000 12312 0 16542.9 7431.75 500 1489.28 4220.09 -28398.24 48917.37 6832.75 -7585.5 0 0 0 -2852.73 80 0 1993 2690 2571.5 0 871.33 84650.5 11657.3 0 9709.85000000001 10000 1000 5051.83 3000 2402.63 8926 5139.49 56887.1 0 0 492375 0 0 0 0 0 0 0 500000 0 770000 0 0 0 0 0 0 0 0 1762375 8567 1244 28732 -72000 -33457 56481.73 56481.73 0 0 8500 -13999.84 -5499.84 1953801.34 42770.27 0 -179.58 3237.5 18752.88 2123.97 496.71 743.439999999999 0 5004.26 0 72949.45 0 0 0 0 1347.16 290 7814.18 3032.38 -9159.17 -23615.64 0 22641 0 0 0 0 -1754.54 3038.44 0 0 1937 1273.8 1775 0 1980.81 2000 3605.78 16206.2 9601.51 -227.24 3115.78 1095.34 -10107.31 -736.96 -15713.79 -954 -2609.4 0 2641.14 -13894.93 0 7000 0 500000 0 0 0 0 65000 0 0 0 572000 8567 1244 28237 -72000 -33952 7787.39000000001 7787.39000000001 -15854.48 0 -15854.48 -19430 -8430.93 105600 13737.66 -10942.98 -14221.13 -5066.96 -9177.46 16500 79.1700000000001 68647.37 673889 0 302000 0 0 302000 3038734.74 -545067.259999998 CITY OF TYBEE ISLAND UPDATED WATER & SEWER ENTERPRISE FUND FISCAL YEAR 2014-2015 DETAILED REVENUE AND EXPENSE APPROVED BUDGET WITH VARIANCES FOR SALARY INCREASES Fund REVENUE 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 EXPENSES FINANCE DEPARTMENT W&S ADMINISTRATION 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 SEWER ADMINISTRATION DIVISION 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 WATER ADMINISTRATION DIVISION 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 OTHER FINANCING USES 505 505 Dept 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 1512 Total 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4310 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 4410 9000 9000 9000 Total Grand Total Object 33 33 33 33 33 33 Total 34 34 34 34 34 34 34 34 34 34 34 Total 36 36 Total 38 38 38 38 38 Total 39 39 39 39 39 39 Total Grand Total 51 51 51 51 51 51 51 51 52 52 52 52 52 52 53 52 51 51 51 51 51 51 51 51 51 51 Total 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 Total 53 53 53 53 53 53 53 53 53 53 Total 54 54 54 54 54 Total 55 55 55 55 55 Total 56 56 Total 58 58 58 58 58 Total Grand Total 51 51 51 51 51 51 51 51 51 Total 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 Total 53 53 53 53 53 53 53 53 53 53 Total 54 54 54 54 54 Total 55 55 55 55 Total 56 56 Total 57 57 57 Total 58 58 58 58 58 58 58 58 Total Grand Total 61 61 4400 4400 ???? 4400 4400 2900 4210 4215 4255 6901 6902 6903 6904 6905 6906 1000 1002 9001 9002 9003 1300 2100 3000 3501 3502 1100 1300 2100 2200 2300 2400 2600 2700 3100 3850 3220 3400 3500 3700 1100 3990 1100 1111 1300 1400 2100 2200 2300 2400 2700 1201 1202 1230 1310 2110 2200 2201 2202 2203 2205 2320 3100 3201 3202 3203 3220 3300 3400 3500 3600 3700 3850 3901 1100 1230 1270 1400 1600 1700 1720 1730 1740 1402 2100 1410 2100 1005 1008 1010 1100 1000 2201 2202 3200 2301 1100 1300 1400 2100 2200 2300 2400 2700 1200 1230 1300 1310 2201 2202 2203 2205 2320 3100 3201 3202 3203 3204 3220 3300 3330 3400 3500 3600 3700 3850 3901 3920 3950 1100 1102 1210 1230 1270 1560 1600 1702 1720 2107 1400 XXXX XXXX 1005 1008 1010 1000 4000 4001 2100 2225 2200 2205 2300 3200 3000 1100 1000 Account Description GEFA Loan Proceeds -AMR GEFA Loan Proceeds - ( #7 Main) GMA Loan or SPLOST 2014 GEFA Loan Proceeds (Jones Water Line) GEFA Loan Proceeds - ( #6 Main) Intergovermental Revenues Water Sewer Cost Reimbursemen Water charges Capital Cost Recovery Sewer charges Other fees - tapping fees Other fees - stubbing fees Aid to Construction Delinquent Charges Other fees Chatham contrct pa Other Fees - Cuts, Transfers, Charges for Services Interest Investment Income Tower Space Rental Revenue W/S Settlement W/S Misc Other Income Service CHG RET'D checks Miscellaneous Revenue Prior Year Fund Balance Sales of Assets Proceeds from Long Term Liab Proceeds from GMA Leases Proceeds from Gen Fund Note Other Financing Sources Salaries & Wages Overtime Health Insurance Benefits FICA Soc Sec Contribution FICA Medicare Contributio Retirement Contributions Unemployment Insurance Py Workers Compensation Cola and\or merit and\or bonus Property & Liability Ins Contract Services - ( for Collection Agent) Postage & Freight Printing & Binding Travel & Related Education & Training Supplies & Materials Service Charges Salaries & Wages Accrued Vacation Adjustme Overtime Wages Employee Benefits Health Insurance Benefits FICA Contributions FICA Medicare Contributio Retirement Contributions Workers Compensation Cola and\or merit and\or bonus Salaries & Benefits: Engineering/permits Engineering/studies Contract Services Medical Screening Water Analysis Dumping Charges Termite/ Pest control WW Repair & Maintain - Bldgs Repair & Maintain - Vehic Repair & Maintain - Equip Repair & Maint -Infrastru Rental Equipment Property & Liability Ins Telephones Fax/Data Lines Cell Phones Postage & Freight Advertising Printing & Binding Travel & Related Expense Dues & Fees Education & Training Contract Labor Credit Card Collection Ch Purchased\Contracted Services Supplies & Materials Electricity Gasoline & Diesel Fuel Books & Periodicals Small Equipment Safety Equipment Uniforms Ultraviolet Disinfection Sludge Belt Press Parts Supplies Lift Station # 7 Force Main Machinery & Equipment Sewer Main Liftstation # 6 Machinery & Equipment (Sludge Thickerner) Capital Outlay Indirect Allocation - A Indirect Allocation - P Indirect Allocation - Acc Administrative Svcs - Gen Cost Allocations Depreciation Depreciation GMA Leases - Interest Exp Gen Fund Note - Interest GEFA Loan Closing Fees Int Exp Loan GEFA CW00014 Debt Service SEWER ADMINSTRATION Salaries & Wages Overtime Employee Benefits Health Insurance Benefits Social Security Contribut FICA Medicare Contributio Retirement Contributions Workers Compensation Cola and\or merit and\or bonus Salaries & Benefits: Legal Medical Screening Computer Svc Contracts Water Analysis Repair & Maintain - Build Repair & Maintain - Vehic Repair & Maintain - Equip Repair & Maint- Infrastru Rental of Equip & Vehicle Property & Liability Insu Telephone Data & Fax Lines Cell Phones Pagers & Beepers Postage & Freight Advertising Legal Notices Printing & Binding Travel & Related Expenses Dues & Fees Education & Training Contract Labor Credit Card Svc. Charges Safety Equipment Water Conservation Measure Purchased\Contracted Services Supplies & Materials Fire hydrants, gates, val Water/Sewer Charges Electricity Gasoline & Diesel Fuel Inventory - Water Meters& Small equipment Cash - Long / Short Uniform /Clothing Supplies Jones Avenue Water Line Infrastructure - ( for Rehab Fort Screven Well) Capital Outlay Indirect Allocation - A Indirect Allocation - P Indirect Allocation - Acc Cost Allocations Depreciation Depreciation Bad debt Other Expense Payments to Others Int Exp Rev Bond 2005 456 Int Exp GEFA FY2014 Loan Int Exp GEFA Loan 2013L35WJ Int Exp GELAC Loan L48WS Int Exp GEFA Loan L22WS 2 Loan Closing Cost Fees Bond Admin Cost Debt Service WATER ADMINISTRATION Transfer to General Fund Contingency Other Financing Uses ALL WATER AND SEWER NET Dept Request FY15 Approved Budget 0 492375 0 500000 500000 1492375 0 1111500 10000 1411500 4000 2000 20000 32000 0 5000 2596000 25000 25000 160000 0 3000 400 163400 862240 0 0 0 0 862240 5139015 46160 333 7508.4 2863 670 4922 0 170 1302 28 1200 20166 57 800 1500 667 22000 110346.4 201916 0 7000 4800 51022 13139 3073 23725 3250 5430 313355 30800 5000 12312 25000 45000 500 5000 8000 40000 81000 10000 29537 0 0 0 7000 100 0 2000 3500 4000 2000 310749 45000 141665 10000 1000 10000 3000 4000 22000 25000 261665 492375 7000 500000 770000 1769375 8567 1244 28732 0 38543 270000 270000 0 0 8500 44074 52574 3016261 159237 9000 4800 30940 10617 2483 22300 11660 5004 256041 0 0 3000 10000 8000 7000 30000 53224 0 25200 0 0 0 0 7000 7000 0 0 2000 10500 3000 0 6000 2000 8000 181924 35000 4000 40000 36800 10000 8000 5000 0 3000 141800 500000 65000 0 0 2782882 8567 1244 28237 38048 285000 285000 10288 10288 11347 105600 13737.66 36381 47041 16500 1700 232306.66 1710407.66 302000 0 302000 5139015.06 -6.00000005215406E-02