Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
9. MAR 2013
4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- TAXES 00-31.1100 Real Property Tax - Current 1,771,969.00 25,679.88 0.00 905,468.56 0.00 866,500.44 51.10 00-31.1200 Property Tax Prior Yrs 270,000.00 571.55 0.00 ( 5,105.92) 0.00 275,105.92 1.89- 00-31.1310 Motor Vehicle Tax 80,000.00 4,786.43 0.00 44,049.75 0.00 35,950.25 55.06 00-31.1320 Property Tax - Mobile Homes 225.00 0.00 0.00 19.93 0.00 205.07 8.86 00-31.1340 Personal Property - Intangi 22,500.00 2,110.98 0.00 16,630.58 0.00 5,869.42 73.91 00-31.1600 Real Estate Trans Tax 7,000.00 958.08 0.00 4,996.14 0.00 2,003.86 71.37 00-31.1710 Franchise Tax Electric 309,000.00 301,041.52 0.00 301,041.52 0.00 7,958.48 97.42 00-31.1750 Franchise Tax - Cable TV 100,000.00 0.00 0.00 53,093.45 0.00 46,906.55 53.09 00-31.1760 Franchise Tax Telephone 20,000.00 0.00 0.00 8,550.73 0.00 11,449.27 42.75 00-31.3100 Sales & Use Tax Rev (LOS 1,000,000.00 88,673.47 0.00 716,865.06 0.00 283,134.94 71.69 00-31.4200 Alcohol Bev Excise Tax 175,000.00 9,254.23 0.00 109,700.46 0.00 65,299.54 62.69 00-31.4300 Local 3% Alcohol Tax 75,000.00 4,907.40 0.00 57,880.80 0.00 17,119.20 77.17 00-31.6100 Business-Occupational Tax 61,000.00 13,917.50 0.00 46,817.50 0.00 14,182.50 76.75 00-31.6101 Admin Fees - Business Licen 4,400.00 970.00 0.00 3,600.00 0.00 800.00 81.82 00-31.6200 Insurance Premium Tax 148,963.00 0.00 0.00 149,842.12 0.00 ( 879.12) 100.59 00-31.9111 Int Delq Tax Real Property 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-31.9900 Late Charge Revenues 1,500.00 265.50 0.00 848.73 0.00 651.27 56.58 TOTAL TAXES 4,046,557.00 453,136.54 0.00 2,414,299.41 0.00 1,632,257.59 59.66 LICENSES & PERMITS 00-32.2990 Engineering Review 15,000.00 525.00 0.00 5,687.75 0.00 9,312.25 37.92 00-32.2995 Land Disturbing Fees 600.00 0.00 0.00 350.00 0.00 250.00 58.33 00-32.3000 Regulatory Fees 120,000.00 46,174.00 0.00 89,054.00 0.00 30,946.00 74.21 00-32.3101 Building Permits 70,000.00 6,091.00 0.00 71,144.00 0.00 ( 1,144.00) 101.63 00-32.3103 Palms Up Fees 10,000.00 0.00 0.00 0.00 0.00 10,000.00 0.00 00-32.3120 Building Inspections 15,000.00 626.00 0.00 15,403.00 0.00 ( 403.00) 102.69 00-32.3140 Sale of Permit Display- Zon 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-32.3200 Film Permitting Fee 1,250.00 125.00 0.00 1,100.00 0.00 150.00 88.00 00-32.3900 Zoning Variance Requests 3,000.00 900.00 0.00 2,925.00 0.00 75.00 97.50 00-32.3901 Recording Fees 4,000.00 1,750.00 0.00 5,375.00 0.00 ( 1,375.00) 134.38 00-32.4100 Business License Penalty 500.00 0.00 0.00 75.00 0.00 425.00 15.00 TOTAL LICENSES & PERMITS 239,350.00 56,191.00 0.00 191,113.75 0.00 48,236.25 79.85 INTERGOVERNMENTAL 00-33.4400 Grant Revenues 28,816.12 28,816.12 0.00 28,816.12 0.00 0.00 100.00 00-33.6015 Beach Renourish Revenue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INTERGOVERNMENTAL 28,816.12 28,816.12 0.00 28,816.12 0.00 0.00 100.00 CHARGES FOR SERVICES 00-34.1400 Printing-Duplicating Servic 1,000.00 199.65 0.00 1,077.86 0.00 ( 77.86) 107.79 00-34.1700 Admin Svcs Water/Sewer 158,400.00 13,200.00 0.00 118,800.00 0.00 39,600.00 75.00 00-34.1710 Admin Svcs Sanitation 9,900.00 825.00 0.00 7,425.00 0.00 2,475.00 75.00 00-34.1910 Election Qualifying Fee 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.2110 Police Svcs- ID Card Fees 1,400.00 10.00 0.00 260.00 0.00 1,140.00 18.57 00-34.2120 Police Svcs- Accident Rep 300.00 0.00 0.00 107.00 0.00 193.00 35.67 00-34.2130 Spec Police Svcs- False Ala 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.2200 Fire Protect Subscriptions 9,990.00 680.00 0.00 9,970.00 0.00 20.00 99.80 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 00-34.2900 Chatham Cty Salary Reimburs 77,500.00 5,020.00 0.00 48,541.40 0.00 28,958.60 62.63 00-34.2903 Police Cost Reimbursement 8,000.00 0.00 0.00 0.00 0.00 8,000.00 0.00 00-34.2904 Fire Cost Reimbursement 3,000.00 0.00 0.00 2,281.60 0.00 718.40 76.05 00-34.2905 DPW Cost Reimbursement 4,000.00 100.00 0.00 100.00 0.00 3,900.00 2.50 00-34.2906 Parking Cost Reimbursement 1,200.00 9,162.00 0.00 15,045.00 0.00 ( 13,845.00) 253.75 00-34.5415 Parking Revenue Meters 106,377.00 3,694.41 0.00 70,455.50 0.00 35,921.50 66.23 00-34.5416 Parking Rev Decal/Multiday 222,400.00 15,180.00 0.00 119,625.75 0.00 102,774.25 53.79 00-34.5417 Parking Rev PayPal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.5418 Parking Rev- Pay/Display 1,978,154.00 80,584.51 0.00 1,189,820.60 0.00 788,333.40 60.15 00-34.5420 Processing Fee 300.00 33.00 0.00 330.00 0.00 ( 30.00) 110.00 00-34.6100 Animal Control-Shelter Fees 100.00 0.00 0.00 20.00 0.00 80.00 20.00 00-34.6410 Background Check Fees 4,000.00 180.00 0.00 2,845.00 0.00 1,155.00 71.13 00-34.6901 Vehicle Impound Fees 500.00 0.00 0.00 135.00 0.00 365.00 27.00 00-34.7501 City Facilities Rentals 37,500.00 4,090.00 0.00 25,820.00 0.00 11,680.00 68.85 00-34.7520 Camping Fees 595,000.00 65,187.18 0.00 65,187.18 0.00 529,812.82 10.96 00-34.7521 Camp Tent Site 50,000.00 1,663.90 0.00 1,663.90 0.00 48,336.10 3.33 00-34.7522 Cabin Rental Taxable 110,000.00 8,082.85 0.00 8,082.85 0.00 101,917.15 7.35 00-34.7523 Cabin All Taxes Exempt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.7524 Cabin GA Sales Tax Exempt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.7525 Camp Site Reservations 175,000.00 8,612.47 0.00 8,612.47 0.00 166,387.53 4.92 00-34.7526 Cabin Hotel Motel Tax Exemp 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.7527 Camp Store Ice Revenues 7,550.00 296.51 0.00 296.51 0.00 7,253.49 3.93 00-34.7528 Camp Store Propane Revenue 18,000.00 3,479.19 0.00 3,479.19 0.00 14,520.81 19.33 00-34.7529 Camp Store RV Supplies 8,800.00 714.98 0.00 714.98 0.00 8,085.02 8.12 00-34.7530 Camp Store General Revenue 52,000.00 4,650.20 0.00 4,650.20 0.00 47,349.80 8.94 00-34.7531 Camp Site Electricity Fees 1,750.00 332.81 0.00 332.81 0.00 1,417.19 19.02 00-34.7532 Camp Vending Revenue 5,000.00 838.20 0.00 838.20 0.00 4,161.80 16.76 00-34.7533 Campgrd Trolley Tickets 125.00 0.00 0.00 0.00 0.00 125.00 0.00 00-34.7534 Campgrd Misc Revenue 4,000.00 436.48 0.00 436.48 0.00 3,563.52 10.91 00-34.7535 Campgrd Rev- Inhouse Event 550.00 0.00 0.00 0.00 0.00 550.00 0.00 00-34.7536 Cabin Reservations 0.00 ( 1,414.00) 0.00 ( 1,414.00) 0.00 1,414.00 0.00 00-34.7537 Cabin Damage Deposit 100.00 0.00 0.00 0.00 0.00 100.00 0.00 00-34.9301 Returned Ck Fees General 100.00 0.00 0.00 0.00 0.00 100.00 0.00 00-34.9302 Returned Ck Fee MuniCourt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.9303 Returned Ck Fees Parking 300.00 32.00 0.00 96.00 0.00 204.00 32.00 00-34.9304 Returned Ck Fees Campgrd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CHARGES FOR SERVICES 3,652,296.00 225,871.34 0.00 1,705,636.48 0.00 1,946,659.52 46.70 FINES & FORFEITURES 00-35.1170 Police Fines City Portion 450,000.00 8,061.57 0.00 168,721.78 0.00 281,278.22 37.49 00-35.1172 Information Tech Fees 20,000.00 1,210.00 0.00 24,207.00 0.00 ( 4,207.00) 121.04 00-35.1174 Court Cost 50,000.00 1,958.36 0.00 37,796.75 0.00 12,203.25 75.59 00-35.1175 Fines and Violations - Park 390,000.00 14,258.00 0.00 225,424.50 0.00 164,575.50 57.80 00-35.1176 Late Fees - Parking 40,000.00 1,140.00 0.00 34,271.00 0.00 5,729.00 85.68 00-35.1401 Crime Victim Emerg Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-35.1900 Other Fines Police/Court 3,000.00 1,125.48 0.00 4,134.48 0.00 ( 1,134.48) 137.82 TOTAL FINES & FORFEITURES 953,000.00 27,753.41 0.00 494,555.51 0.00 458,444.49 51.89 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- INVESTMENT INCOME 00-36.1000 Interest Revenue 25,000.00 1,517.94 0.00 7,331.90 0.00 17,668.10 29.33 00-36.1001 Interest Rev Campgrd Note 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-36.1002 Int Rev -Water/Sewer Note 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-36.1003 Int Rev -Sanitation Note 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-36.1005 Finance Charge Revenue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INVESTMENT INCOME 25,000.00 1,517.94 0.00 7,331.90 0.00 17,668.10 29.33 CONTRIBUTIONS & DONATIONS 00-37.1001 Police - Contributions 1,000.00 0.00 0.00 0.00 0.00 1,000.00 0.00 00-37.1002 Fire - Contributions 1,000.00 0.00 0.00 2,070.00 0.00 ( 1,070.00) 207.00 00-37.1004 Donations - Various 1,000.00 1,000.00 0.00 1,125.00 0.00 ( 125.00) 112.50 00-37.1010 Community Service Committee 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-37.1175 Condemned Monies-TIPD 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-37.2100 Settlements 0.00 0.00 0.00 5,000.00 0.00 ( 5,000.00) 0.00 00-37.4401 BHT Donations 1,000.00 0.00 0.00 0.00 0.00 1,000.00 0.00 TOTAL CONTRIBUTIONS & DONATIONS 4,000.00 1,000.00 0.00 8,195.00 0.00 ( 4,195.00) 204.88 MISCELLANEOUS 00-38.1002 Rent Cell Phone Antennas 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-38.1003 Lease - Shrine Club 1,573.00 268.36 0.00 1,225.05 0.00 347.95 77.88 00-38.1005 Rents-Royalty-Misc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-38.1006 Lease - North Beach Grill 15,498.00 2,646.00 0.00 11,592.00 0.00 3,906.00 74.80 00-38.1007 YMCA - Non Member Fee 2,500.00 0.00 0.00 1,043.75 0.00 1,456.25 41.75 00-38.1010 Cremation Wall 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-38.3000 Damaged Property Reimbursem 9,221.67 0.00 0.00 3,073.89 0.00 6,147.78 33.33 00-38.9003 Miscellaneous Revenue 3,000.00 ( 500.00) 0.00 30,759.69 0.00 ( 27,759.69) 25.32 TOTAL MISCELLANEOUS 31,792.67 2,414.36 0.00 47,694.38 0.00 ( 15,901.71) 150.02 OTHER FINANCING SOURCES 00-39.1100 Transfer In 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.1200 H/M Transfer In 1,025,000.00 19,309.28 0.00 555,429.10 0.00 469,570.90 54.19 00-39.1300 Prior Yr Fund Balance 18,093.44 0.00 0.00 0.00 0.00 18,093.44 0.00 00-39.2100 Sale of Assets 4,621.83 0.00 0.00 7,428.84 0.00 ( 2,807.01) 160.73 00-39.2101 Sale Land/Greenspace 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3500 Capital Lease Proceeds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3501 Proceeds from GMA/BBT Loan 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.4501 Phone System Revenue 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 1,047,715.27 19,309.28 0.00 562,857.94 0.00 484,857.33 53.72 *** TOTAL REVENUES *** 10,028,527.06 816,009.99 0.00 5,460,500.49 0.00 4,568,026.57 54.45 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Mayor and Council % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1110-51-1100 Salaries & Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-51-1400 Mayor Benefits 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-51-2200 FICA Soc Sec Contribution 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-51-2300 FICA Medicare Contributio 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL PERSONNEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 SERVICES 1110-52-1100 Council Fees 20,400.00 1,762.50 0.00 15,800.00 0.00 4,600.00 77.45 1110-52-1200 Professional Services 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-1201 Studies, Surveys, Consult 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-1232 Videographer 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-2110 Garbage Charges 346.00 27.82 0.00 249.97 0.00 96.03 72.25 1110-52-2202 Repair & Maintain - Vehic 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-2320 Rental Equipment/Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-3100 Property & Liability Insu 6,944.08 0.00 0.00 14,093.37 0.00 ( 7,149.29) 202.96 1110-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-3220 Postage/ Freight 400.00 17.74 0.00 55.37 0.00 344.63 13.84 1110-52-3400 Printing/Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-3500 Training Ethics 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-3501 Travel & Related - Mayor 2,700.00 0.00 0.00 1,703.69 0.00 996.31 63.10 1110-52-3502 Council travel - W.Doyle 2,050.00 0.00 0.00 1,413.59 119.00 517.41 74.76 1110-52-3503 Council Travel- B. Brown 1,700.00 0.00 0.00 839.37 0.00 860.63 49.37 1110-52-3504 Council travel - T.Groove 1,700.00 0.00 0.00 736.46 0.00 963.54 43.32 1110-52-3505 Council travel - B.Garbet 1,700.00 0.00 0.00 878.22 0.00 821.78 51.66 1110-52-3506 Council travel - J. Fox 1,380.00 36.00 0.00 1,056.20 119.00 204.80 85.16 1110-52-3507 Council travel - Wolff 2,070.00 0.00 0.00 1,307.47 0.00 762.53 63.16 1110-52-3600 Dues and Membership Fees 7,229.00 0.00 0.00 6,939.66 0.00 289.34 96.00 1110-52-3700 Education & Training - Co 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-52-3701 Education & Training - Ma 1,700.00 0.00 0.00 435.00 0.00 1,265.00 25.59 1110-52-3702 Education - W.Doyle 1,000.00 505.00 0.00 505.00 0.00 495.00 50.50 1110-52-3703 Education - B Brown 1,350.00 720.00 0.00 1,155.00 0.00 195.00 85.56 1110-52-3704 Education - T. Groover 1,350.00 720.00 0.00 1,284.00 0.00 66.00 95.11 1110-52-3705 Education -B.Garbett 1,350.00 720.00 0.00 1,155.00 0.00 195.00 85.56 1110-52-3706 Education - J. Fox 1,670.00 720.00 0.00 1,655.00 0.00 15.00 99.10 1110-52-3707 Education - Wolff 980.00 505.00 0.00 980.00 0.00 0.00 100.00 1110-52-3990 Service Chgs, Late Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 58,019.08 5,734.06 0.00 52,242.37 238.00 5,538.71 90.45 SUPPLIES 1110-53-1100 Supplies & Materials 1,257.00 0.00 0.00 1,256.35 0.00 0.65 99.95 1110-53-1210 Water/Sewer Charges 288.00 19.36 0.00 177.48 0.00 110.52 61.63 1110-53-1230 Electricity 11,027.00 535.32 0.00 4,624.25 0.00 6,402.75 41.94 1110-53-1270 Gasoline & Diesel Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-53-1310 Food - Officials & Functi 4,443.00 52.66 0.00 3,241.85 0.00 1,201.15 72.97 1110-53-1600 Small Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-53-1710 Volunteer Appreciation 200.00 0.00 0.00 0.00 0.00 200.00 0.00 1110-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 17,215.00 607.34 0.00 9,299.93 0.00 7,915.07 54.02 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Mayor and Council % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 1110-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1110-54-2300 Furniture and Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 1110-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 1110-57-2001 Donations-Council Approve 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Mayor and Council 75,234.08 6,341.40 0.00 61,542.30 238.00 13,453.78 82.12 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Clerk of Council % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1130-51-1100 Salaries & Wages 47,627.00 3,461.54 0.00 33,323.07 0.00 14,303.93 69.97 1130-51-1200 Part Time Seasonal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1130-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1130-51-1400 Employee Benefits 375.00 62.50 0.00 187.50 0.00 187.50 50.00 1130-51-2100 Health Insurance Benefits 6,534.00 514.38 0.00 4,222.35 0.00 2,311.65 64.62 1130-51-2200 FICA Soc Sec Contribution 2,999.00 216.10 0.00 2,054.95 0.00 944.05 68.52 1130-51-2300 FICA Medicare Contributio 701.00 50.54 0.00 480.61 0.00 220.39 68.56 1130-51-2400 Retirement Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1130-51-2600 Unemployment Insurance 4,625.00 0.00 0.00 0.00 0.00 4,625.00 0.00 1130-51-2700 Workers Compensation 184.00 0.00 0.00 124.82 0.00 59.18 67.84 TOTAL PERSONNEL 63,045.00 4,305.06 0.00 40,393.30 0.00 22,651.70 64.07 SERVICES 1130-52-1110 Recodification Service 8,751.00 1,455.23 0.00 4,999.92 0.00 3,751.08 57.14 1130-52-1125 Election Expense 4,049.00 0.00 0.00 0.00 0.00 4,049.00 0.00 1130-52-2110 Garbage Charges 346.00 4.00 0.00 31.40 0.00 314.60 9.08 1130-52-2203 Repair & Maintain - Equip 200.00 0.00 0.00 0.00 0.00 200.00 0.00 1130-52-3100 Property/Liability Insura 964.14 0.00 0.00 906.54 0.00 57.60 94.03 1130-52-3220 Postage/ Freight 150.00 0.00 0.00 0.00 0.00 150.00 0.00 1130-52-3300 Advertising 1,500.00 0.00 0.00 456.76 297.84 745.40 50.31 1130-52-3400 Print & Binding 350.00 0.00 0.00 0.00 0.00 350.00 0.00 1130-52-3500 Travel & Related Expenses 3,350.00 239.81 0.00 2,985.30 0.00 364.70 89.11 1130-52-3600 Dues & Fees 3,200.00 959.00 0.00 3,135.60 0.00 64.40 97.99 1130-52-3700 Educ & Training 1,320.00 0.00 0.00 1,260.00 0.00 60.00 95.45 1130-52-3850 Contract Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1130-52-3930 Record Management 2,600.00 0.00 0.00 324.32 0.00 2,275.68 12.47 TOTAL SERVICES 26,780.14 2,658.04 0.00 14,099.84 297.84 12,382.46 53.76 SUPPLIES 1130-53-1100 Supplies & Materials 2,010.00 165.35 0.00 1,566.39 20.97 422.64 78.97 1130-53-1210 Water/Sewer Chgs 40.00 2.69 0.00 24.66 0.00 15.34 61.65 1130-53-1230 Electricity 1,532.00 74.33 0.00 642.03 0.00 889.97 41.91 1130-53-1400 Books & Periodicals 200.00 0.00 0.00 0.00 0.00 200.00 0.00 1130-53-1600 Small equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1130-53-1720 Uniforms 230.00 0.00 0.00 221.62 0.00 8.38 96.36 TOTAL SUPPLIES 4,012.00 242.37 0.00 2,454.70 20.97 1,536.33 61.71 DEPRECIATION/AMORTIZATIO 1130-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Clerk of Council 93,837.14 7,205.47 0.00 56,947.84 318.81 36,570.49 61.03 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 7 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund City Manager % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1320-51-1100 Salaries & Wages 121,756.00 8,936.52 0.00 84,985.18 0.00 36,770.82 69.80 1320-51-1200 Part Time/Seasonal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-51-1400 Employee Benefits 750.00 62.50 0.00 562.50 0.00 187.50 75.00 1320-51-2100 Health Insurance Benefits 16,027.00 1,320.07 0.00 10,974.21 0.00 5,052.79 68.47 1320-51-2200 FICA Soc Sec Contribution 7,626.00 548.40 0.00 5,213.32 0.00 2,412.68 68.36 1320-51-2300 FICA Medicare Contributio 1,784.00 128.27 0.00 1,219.37 0.00 564.63 68.35 1320-51-2400 Retirement Contributions 14,123.00 1,176.91 0.00 10,592.19 0.00 3,530.81 75.00 1320-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-51-2700 Workers Compensation 504.00 0.00 0.00 475.00 0.00 29.00 94.25 TOTAL PERSONNEL 162,570.00 12,172.67 0.00 114,021.77 0.00 48,548.23 70.14 SERVICES 1320-52-1201 Studies, Surveys, Consult 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-52-1210 Master Plan Development 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-52-2110 Garbage Charges 37.00 2.91 0.00 26.01 0.00 10.99 70.30 1320-52-3100 Property/Liability Insura 1,013.89 0.00 0.00 1,013.89 0.00 0.00 100.00 1320-52-3220 Postage/ Freight 1,171.78 129.92 0.00 846.72 0.00 325.06 72.26 1320-52-3400 Print & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-52-3500 Travel & Related Expenses 1,136.22 338.75 0.00 1,136.22 0.00 0.00 100.00 1320-52-3600 Dues & Fees 1,200.00 125.00 0.00 841.70 0.00 358.30 70.14 1320-52-3700 Educ & Training 1,175.00 50.00 0.00 960.00 0.00 215.00 81.70 1320-52-3850 Contract Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-52-3950 Engineering Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 5,733.89 646.58 0.00 4,824.54 0.00 909.35 84.14 SUPPLIES 1320-53-1100 Supplies & Materials 390.00 0.00 0.00 355.30 0.00 34.70 91.10 1320-53-1210 Water/Sewer Charges 28.00 1.93 0.00 17.69 0.00 10.31 63.18 1320-53-1230 Electricity 778.19 53.35 0.00 460.85 0.00 317.34 59.22 1320-53-1310 Food - Officials & Functi 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-53-1400 Books & Periodicals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-53-1600 Small equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 1,196.19 55.28 0.00 833.84 0.00 362.35 69.71 OTHER COSTS 1320-57-2000 Payment to Other Agencies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1320-57-2002 Contributions Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL City Manager 169,500.08 12,874.53 0.00 119,680.15 0.00 49,819.93 70.61 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 8 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Finance % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1510-51-1100 Salaries & Wages 270,612.00 20,067.10 0.00 170,476.04 0.00 100,135.96 63.00 1510-51-1300 Overtime 1,000.00 110.72 0.00 469.36 0.00 530.64 46.94 1510-51-1400 Employee Benefits 750.00 62.50 0.00 312.50 0.00 437.50 41.67 1510-51-2100 Health Insurance Benefits 46,950.00 3,880.21 0.00 29,654.04 0.00 17,295.96 63.16 1510-51-2200 FICA Soc Sec Contribution 17,847.00 1,238.36 0.00 10,494.40 0.00 7,352.60 58.80 1510-51-2300 FICA Medicare Contributio 4,174.00 289.62 0.00 2,454.37 0.00 1,719.63 58.80 1510-51-2400 Retirement Contributions 41,918.00 3,493.09 0.00 31,437.81 0.00 10,480.19 75.00 1510-51-2600 Unemployment Insurance Py 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-51-2700 Workers Compensation 1,180.00 0.00 0.00 823.71 0.00 356.29 69.81 TOTAL PERSONNEL 384,431.00 29,141.60 0.00 246,122.23 0.00 138,308.77 64.02 SERVICES 1510-52-1105 County Tax Billing Admin 25,000.00 0.00 0.00 18,445.84 0.00 6,554.16 73.78 1510-52-1221 Audit/Accounting Fees 15,000.00 0.00 0.00 13,650.00 0.00 1,350.00 91.00 1510-52-1300 Service Contracts 13,098.00 4,300.00 0.00 4,300.00 600.00 8,198.00 37.41 1510-52-2110 Garbage Charges 71.00 5.60 0.00 49.65 0.00 21.35 69.93 1510-52-2201 Repair/Maint Buildings 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-52-2320 Rent Equip & Vehicles 4,000.00 0.00 0.00 3,190.00 319.00 491.00 87.73 1510-52-3100 Property/Liability Insura 1,950.03 0.00 0.00 1,950.03 0.00 0.00 100.00 1510-52-3220 Postage/Freight 1,400.00 212.62 0.00 756.75 0.00 643.25 54.05 1510-52-3300 Advertising 3,625.16 0.00 0.00 200.00 0.00 3,425.16 5.52 1510-52-3400 Print & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-52-3500 Travel & Related Expenses 1,374.84 0.00 20.20 145.42 0.00 1,229.42 10.58 1510-52-3600 Dues & Fees 1,200.00 180.00 0.00 609.58 300.00 290.42 75.80 1510-52-3700 Educ & Training 3,000.00 0.00 0.00 875.00 0.00 2,125.00 29.17 1510-52-3850 Contract Labor 20,850.00 1,035.00 0.00 13,430.37 0.00 7,419.63 64.41 1510-52-3989 Other Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-52-3990 Service/ Late Chgs 25,989.00 1,195.81 0.00 21,523.95 0.00 4,465.05 82.82 TOTAL SERVICES 116,558.03 6,929.03 20.20 79,126.59 1,219.00 36,212.44 68.93 SUPPLIES 1510-53-1100 Supplies & Materials 5,916.00 254.89 0.00 2,845.63 0.00 3,070.37 48.10 1510-53-1210 Water/Sewer Chgs 55.00 3.81 0.00 34.93 0.00 20.07 63.51 1510-53-1230 Electricity 1,839.83 105.29 0.00 909.56 0.00 930.27 49.44 1510-53-1400 Books/Periodicals 334.00 0.00 0.00 159.00 0.00 175.00 47.60 1510-53-1600 Small Equipment 750.00 0.00 0.00 0.00 0.00 750.00 0.00 1510-53-1703 Cash- Over/Short 0.00 0.00 0.00 11.38 0.00 ( 11.38) 0.00 1510-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 8,894.83 363.99 0.00 3,960.50 0.00 4,934.33 44.53 _________________________________________________________________________________________________________________________________ TOTAL Finance 509,883.86 36,434.62 20.20 329,209.32 1,219.00 179,455.54 64.80 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 9 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Law % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 1530-52-1200 Legal Gen Government 34,000.00 2,000.00 0.00 22,064.23 0.00 11,935.77 64.89 1530-52-1203 Legal/Lawsuits/All Depts 118,000.00 11,815.90 0.00 75,401.80 42,598.20 0.00 100.00 1530-52-1204 Legal/Ethics Comm 4,300.00 0.00 0.00 0.00 0.00 4,300.00 0.00 TOTAL SERVICES 156,300.00 13,815.90 0.00 97,466.03 42,598.20 16,235.77 89.61 INTERFUND/INTERDEPARTMENT 1530-55-2300 Judgements 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INTERFUND/INTERDEPARTMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Law 156,300.00 13,815.90 0.00 97,466.03 42,598.20 16,235.77 89.61 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 10 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Information Technology % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1535-51-1100 Salaries & Wages 106,235.00 7,992.98 0.00 76,223.28 0.00 30,011.72 71.75 1535-51-1400 Employee Benefits 5,100.00 425.00 0.00 3,575.00 0.00 1,525.00 70.10 1535-51-2100 Health Insurance Benefits 15,869.00 1,309.85 0.00 10,914.15 0.00 4,954.85 68.78 1535-51-2200 FICA Soc Sec Contribution 6,903.00 508.80 0.00 4,822.93 0.00 2,080.07 69.87 1535-51-2300 FICA Medicare Contributio 1,614.00 118.98 0.00 1,127.85 0.00 486.15 69.88 1535-51-2400 Retirement Contributions 16,345.00 1,362.05 0.00 12,258.45 0.00 4,086.55 75.00 1535-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-51-2700 Workers Compensation 423.00 0.00 0.00 294.01 0.00 128.99 69.51 TOTAL PERSONNEL 152,489.00 11,717.66 0.00 109,215.67 0.00 43,273.33 71.62 SERVICES 1535-52-1120 Management Support Activi 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-52-1300 Service Contracts 123,500.00 4,032.95 0.00 76,782.76 33,283.58 13,433.66 89.12 1535-52-2110 Garbage Charges 40.00 2.98 0.00 26.22 0.00 13.78 65.55 1535-52-2201 Repair/Maint-Buildings 5,000.00 437.35 0.00 4,056.61 0.00 943.39 81.13 1535-52-2203 Repair/Maint-Equipt 3,000.00 43.74 0.00 2,730.33 43.74 225.93 92.47 1535-52-2320 Rent- Equip & Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-52-3100 Property & Liability Insu 984.96 0.00 0.00 984.96 0.00 0.00 100.00 1535-52-3201 Telephone/Internet Costs 48,600.00 4,985.37 0.00 40,219.74 6,077.25 2,303.01 95.26 1535-52-3203 Cell Phones 7,300.00 633.21 0.00 4,978.88 0.00 2,321.12 68.20 1535-52-3220 Postage/Freight 20.00 0.00 0.00 0.00 0.00 20.00 0.00 1535-52-3400 Print & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-52-3500 Travel & Related Expenses 500.00 0.00 0.00 0.00 0.00 500.00 0.00 1535-52-3600 Dues and fees 200.00 0.00 0.00 0.00 0.00 200.00 0.00 1535-52-3700 Educ & Training 765.00 0.00 0.00 0.00 0.00 765.00 0.00 1535-52-3850 Contract Services 4,324.48 450.00 0.00 1,800.00 500.00 2,024.48 53.19 TOTAL SERVICES 194,234.44 10,585.60 0.00 131,579.50 39,904.57 22,750.37 88.29 SUPPLIES 1535-53-1100 Supplies & Materials 19,000.00 0.00 0.00 13,623.30 0.00 5,376.70 71.70 1535-53-1210 Water/Sewer Chgs 28.00 1.98 0.00 18.15 0.00 9.85 64.82 1535-53-1230 Electricity 1,072.42 54.76 0.00 473.06 0.00 599.36 44.11 1535-53-1600 Small Equipment 29,100.00 0.00 0.00 18,187.40 999.00 9,913.60 65.93 1535-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 49,200.42 56.74 0.00 32,301.91 999.00 15,899.51 67.68 CAPITAL OUTLAY 1535-54-2100 Equip/Machinery 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-54-2101 Backup Power Generator 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-54-2300 Computer Room Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-54-2400 Computers 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-54-2500 Capital Software Purchase 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1535-54-4501 Phone System Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 11 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Information Technology % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- DEPRECIATION/AMORTIZATIO 1535-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 1535-57-2020 Tybee Channel Programming 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 1535-58-1101 Phone System Principal 0.00 0.00 0.00 11,639.89 0.00 ( 11,639.89) 0.00 1535-58-2201 Phone System Interest 2,075.52 0.00 0.00 1,598.46 0.00 477.06 77.01 TOTAL DEBT SERVICE 2,075.52 0.00 0.00 13,238.35 0.00 ( 11,162.83) 637.83 _________________________________________________________________________________________________________________________________ TOTAL Information Technology 397,999.38 22,360.00 0.00 286,335.43 40,903.57 70,760.38 82.22 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 12 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Human Resources % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1540-51-1100 Salaries & Wages 56,392.00 4,241.36 0.00 41,526.12 0.00 14,865.88 73.64 1540-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1540-51-1400 Employee Benefits 2,550.00 212.50 0.00 1,912.50 0.00 637.50 75.00 1540-51-2100 Health Insurance Benefits 9,226.00 727.51 0.00 6,496.09 0.00 2,729.91 70.41 1540-51-2200 FICA Soc Sec Contribution 3,627.00 269.32 0.00 2,628.41 0.00 998.59 72.47 1540-51-2300 FICA Medicare Contributio 855.00 62.98 0.00 614.67 0.00 240.33 71.89 1540-51-2400 Retirement Contributions 7,806.00 650.45 0.00 5,854.05 0.00 1,951.95 74.99 1540-51-2401 Retiree Insurance Premium 4,122.00 277.97 0.00 2,726.01 0.00 1,395.99 66.13 1540-51-2700 Workers Compensation 224.00 0.00 0.00 153.52 0.00 70.48 68.54 1540-51-2900 Wellness Benefits 2,000.00 0.00 0.00 0.00 0.00 2,000.00 0.00 TOTAL PERSONNEL 86,802.00 6,442.09 0.00 61,911.37 0.00 24,890.63 71.32 SERVICES 1540-52-1120 Management Support Activi 2,500.00 275.00 0.00 1,941.82 0.00 558.18 77.67 1540-52-1230 Medical Screening 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1540-52-1231 Drug Testing 3,700.00 275.00 0.00 875.00 0.00 2,825.00 23.65 1540-52-1275 Employee Assistance Expen 3,495.00 0.00 0.00 3,000.00 0.00 495.00 85.84 1540-52-2110 Garbage 22.00 1.81 0.00 15.99 0.00 6.01 72.68 1540-52-3100 Property & Liability Insu 415.37 0.00 0.00 311.52 0.00 103.85 75.00 1540-52-3300 Advertising 1,000.00 0.00 0.00 177.00 0.00 823.00 17.70 1540-52-3400 Print & Binding 500.00 0.00 0.00 0.00 0.00 500.00 0.00 1540-52-3500 Travel & Related Expenses 750.00 0.00 0.00 495.00 0.00 255.00 66.00 1540-52-3600 Dues and Fees 255.00 0.00 0.00 255.00 0.00 0.00 100.00 1540-52-3700 Educ & Training 1,836.00 0.00 0.00 390.00 0.00 1,446.00 21.24 TOTAL SERVICES 14,473.37 551.81 0.00 7,461.33 0.00 7,012.04 51.55 SUPPLIES 1540-53-1100 Supplies & Materials 961.00 59.99 0.00 655.28 0.00 305.72 68.19 1540-53-1210 Water Sewer Chgs 22.00 1.16 0.00 10.59 0.00 11.41 48.14 1540-53-1230 Electricity 660.00 32.02 0.00 276.61 0.00 383.39 41.91 1540-53-1312 Employee Appreciation Lun 500.00 0.00 0.00 263.49 0.00 236.51 52.70 1540-53-1400 Books/Periodicals 139.00 0.00 0.00 0.00 139.00 0.00 100.00 1540-53-1600 Small Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1540-53-1710 Employee Appreciation Awa 1,000.00 54.95 0.00 307.40 0.00 692.60 30.74 1540-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 3,282.00 148.12 0.00 1,513.37 139.00 1,629.63 50.35 _________________________________________________________________________________________________________________________________ TOTAL Human Resources 104,557.37 7,142.02 0.00 70,886.07 139.00 33,532.30 67.93 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 13 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Bldg Maint & Allocations % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 1565-51-1100 Salaries & Wages 134,280.00 10,183.32 0.00 98,892.94 0.00 35,387.06 73.65 1565-51-1300 Overtime Wages 6,090.00 211.40 0.00 2,879.30 0.00 3,210.70 47.28 1565-51-1400 Employee Benefits 750.00 62.50 0.00 562.50 0.00 187.50 75.00 1565-51-2100 Health Insurance Benefits 33,865.00 2,289.39 0.00 19,128.01 0.00 14,736.99 56.48 1565-51-2200 FICA Soc Sec Contribution 8,806.00 648.35 0.00 6,344.77 0.00 2,461.23 72.05 1565-51-2300 FICA Medicare Contributio 2,060.00 151.62 0.00 1,483.74 0.00 576.26 72.03 1565-51-2400 Retirement Contributions 17,089.00 1,424.02 0.00 12,816.18 0.00 4,272.82 75.00 1565-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-51-2700 Workers Compensation 7,585.00 0.00 0.00 7,554.35 0.00 30.65 99.60 TOTAL PERSONNEL 210,525.00 14,970.60 0.00 149,661.79 0.00 60,863.21 71.09 SERVICES 1565-52-2130 Custodial City Hall Build 6,600.00 1,100.00 0.00 4,950.00 0.00 1,650.00 75.00 1565-52-2200 Pest Control 3,000.00 374.86 0.00 2,283.79 187.43 528.78 82.37 1565-52-2201 Repair/Maintain-Buildings 80,000.00 2,039.89 0.00 58,434.03 ( 88.59) 21,654.56 72.93 1565-52-2202 Repair/Maintain-Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-52-2203 Repai/Maintain-Equipment 2,000.00 0.00 0.00 0.00 0.00 2,000.00 0.00 1565-52-3100 Property & Liability Insu 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-52-3500 Travel & Related Expenses 500.00 0.00 0.00 0.00 0.00 500.00 0.00 1565-52-3700 Educ & Training 500.00 0.00 0.00 0.00 0.00 500.00 0.00 TOTAL SERVICES 92,600.00 3,514.75 0.00 65,667.82 98.84 26,833.34 71.02 SUPPLIES 1565-53-1100 Supplies/Materials 3,000.00 59.90 0.00 1,447.08 0.00 1,552.92 48.24 1565-53-1210 Water/Sewer Chgs 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-53-1230 Electricity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-53-1270 Gas & Diesel Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-53-1400 Books/Periodical 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-53-1600 Small Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 3,000.00 59.90 0.00 1,447.08 0.00 1,552.92 48.24 CAPITAL OUTLAY 1565-54-1300 Capital Improvement -Buil 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1565-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 1565-56-1000 Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Bldg Maint & Allocations 306,125.00 18,545.25 0.00 216,776.69 98.84 89,249.47 70.85 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 14 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Municipal Court % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 2650-52-1101 Legal - Judge 3,000.00 200.00 0.00 1,800.00 0.00 1,200.00 60.00 2650-52-1301 Court Reporter 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-52-2130 Custodial 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-52-3700 Educ & Training 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-52-3910 Court Appearance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 3,000.00 200.00 0.00 1,800.00 0.00 1,200.00 60.00 SUPPLIES 2650-53-1100 General Supplies & Materi 100.00 0.00 0.00 0.00 0.00 100.00 0.00 2650-53-1104 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 100.00 0.00 0.00 0.00 0.00 100.00 0.00 OTHER COSTS 2650-57-1008 Indigent Defense Fees 7,000.00 0.00 0.00 7,000.00 0.00 0.00 100.00 TOTAL OTHER COSTS 7,000.00 0.00 0.00 7,000.00 0.00 0.00 100.00 _________________________________________________________________________________________________________________________________ TOTAL Municipal Court 10,100.00 200.00 0.00 8,800.00 0.00 1,300.00 87.13 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 15 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Police Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 3210-51-1100 Salaries & Wages 1,202,501.40 94,341.47 0.00 919,264.17 0.00 283,237.23 76.45 3210-51-1200 Part Time/Seasonal Wages 72,911.00 4,696.39 0.00 53,156.72 0.00 19,754.28 72.91 3210-51-1300 Overtime 65,000.00 7,132.75 0.00 35,735.59 0.00 29,264.41 54.98 3210-51-1400 Employee Benefits 6,000.00 500.00 0.00 4,500.00 0.00 1,500.00 75.00 3210-51-2100 Health Insurance Benefits 207,457.00 18,421.56 0.00 152,171.24 0.00 55,285.76 73.35 3210-51-2200 FICA Soc Sec Contribution 83,524.23 6,610.21 0.00 62,732.86 0.00 20,791.37 75.11 3210-51-2300 FICA Medicare Contributio 20,533.46 1,545.89 0.00 14,671.12 0.00 5,862.34 71.45 3210-51-2400 Retirement Contributions 154,230.08 12,852.42 0.00 115,671.78 0.00 38,558.30 75.00 3210-51-2600 Unemployment payments 20,000.00 0.00 0.00 0.00 0.00 20,000.00 0.00 3210-51-2700 Workers Compensation 74,093.83 0.00 0.00 47,246.24 0.00 26,847.59 63.77 TOTAL PERSONNEL 1,906,251.00 146,100.69 0.00 1,405,149.72 0.00 501,101.28 73.71 SERVICES 3210-52-1200 Legal Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-1225 Physical Evals 1,600.00 0.00 0.00 1,200.00 0.00 400.00 75.00 3210-52-1300 Equip Service Contracts 13,000.00 446.13 0.00 10,965.39 94.23 1,940.38 85.07 3210-52-2110 Garbage Charges 1,010.00 42.03 0.00 378.27 0.00 631.73 37.45 3210-52-2130 Custodial 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-2201 Repair/Maint-Buildings 3,500.00 0.00 0.00 1,850.33 0.00 1,649.67 52.87 3210-52-2202 Repair/Maint-Vehicles 22,661.39 884.03 0.00 17,661.79 132.25 4,867.35 78.52 3210-52-2203 Repair/Maint-Equipment 6,000.00 734.49 0.00 4,117.20 160.00 1,722.80 71.29 3210-52-2320 Rent-Equip & Vehicles 1,676.21 0.00 0.00 412.50 0.00 1,263.71 24.61 3210-52-3100 Property & Liability Insu 19,130.32 0.00 0.00 25,438.38 0.00 ( 6,308.06) 132.97 3210-52-3201 Telephone/ communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3202 Data & Fax Lines 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3205 Radios 3,000.00 0.00 0.00 0.00 0.00 3,000.00 0.00 3210-52-3220 Postage/Freight 700.00 92.10 0.00 397.18 0.00 302.82 56.74 3210-52-3300 Advertising 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3400 Print & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3500 Travel & Related Expenses 12,500.00 3,079.76 0.00 8,495.32 575.97 3,428.71 72.57 3210-52-3600 Dues, Fees, Tags & Titles 850.00 0.00 0.00 668.00 0.00 182.00 78.59 3210-52-3601 GCIC Database Fees 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 3210-52-3602 Certifications 100.00 0.00 0.00 83.00 0.00 17.00 83.00 3210-52-3700 Educ &Training 4,150.00 26.00 0.00 3,713.00 350.00 87.00 97.90 3210-52-3901 Credit Card Svc. Charges 5,536.29 384.82 0.00 2,679.38 0.00 2,856.91 48.40 TOTAL SERVICES 100,414.21 5,689.36 0.00 78,059.74 1,312.45 21,042.02 79.04 SUPPLIES 3210-53-1100 Supplies & Materials 8,700.00 826.31 0.00 7,169.23 145.24 1,385.53 84.07 3210-53-1102 Flags 100.00 0.00 0.00 0.00 0.00 100.00 0.00 3210-53-1103 Investigation & I.D. Supp 4,000.00 52.25 0.00 1,107.33 0.00 2,892.67 27.68 3210-53-1185 Community Police Programs 400.00 0.00 0.00 51.34 0.00 348.66 12.84 3210-53-1190 Animal Control Supplies 300.00 0.00 0.00 9.39 0.00 290.61 3.13 3210-53-1191 Animal Control Costs 500.00 0.00 0.00 0.00 0.00 500.00 0.00 3210-53-1210 Water/Sewer Charges 1,272.00 60.69 0.00 560.73 0.00 711.27 44.08 3210-53-1230 Electricity 12,623.00 1,017.34 0.00 9,578.62 0.00 3,044.38 75.88 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 16 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Police Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 3210-53-1270 Gasoline & Diesel Fuel 50,000.00 6,453.11 0.00 42,953.26 0.00 7,046.74 85.91 3210-53-1310 Food - Officials & Functi 300.00 0.00 0.00 162.00 0.00 138.00 54.00 3210-53-1385 Custody - Food Supplies 500.00 11.01 0.00 151.94 153.64 194.42 61.12 3210-53-1400 Books & Periodicals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-53-1600 Small equipment 25,000.00 0.00 0.00 17,487.86 1,229.70 6,282.44 74.87 3210-53-1601 Safety Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-53-1603 Protective Gear 6,000.00 0.00 0.00 0.00 0.00 6,000.00 0.00 3210-53-1701 Over/Short 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-53-1720 Uniforms & Accessories 17,000.00 898.37 0.00 9,202.09 1,172.84 6,625.07 61.03 TOTAL SUPPLIES 126,695.00 9,319.08 0.00 88,433.79 2,701.42 35,559.79 71.93 CAPITAL OUTLAY 3210-54-2100 Capital Equipment 16,000.00 0.00 0.00 0.00 0.00 16,000.00 0.00 3210-54-2200 Vehicles 27,164.00 0.00 0.00 23,275.00 0.00 3,889.00 85.68 3210-54-2300 Furnitures & Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-54-2600 Capital - Misc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 43,164.00 0.00 0.00 23,275.00 0.00 19,889.00 53.92 DEPRECIATION/AMORTIZATIO 3210-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 3210-57-1150 Jail Expense - Chatham Co 17,000.00 2,055.00 0.00 12,460.00 0.00 4,540.00 73.29 3210-57-2005 Rape Crisis Center 500.00 0.00 0.00 0.00 0.00 500.00 0.00 TOTAL OTHER COSTS 17,500.00 2,055.00 0.00 12,460.00 0.00 5,040.00 71.20 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 2,194,024.21 163,164.13 0.00 1,607,378.25 4,013.87 582,632.09 73.44 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 17 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Beach Patrol % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 3215-51-1100 Salaries & Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3215-51-1200 Part Time/Seasonal Wages 56,232.00 5,728.39 0.00 40,629.07 0.00 15,602.93 72.25 3215-51-1300 Overtime 5,802.00 764.39 0.00 3,298.08 0.00 2,503.92 56.84 3215-51-2100 Health Insurance Benefits 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3215-51-2200 FICA Soc Sec Contribution 3,846.00 400.17 0.00 2,721.04 0.00 1,124.96 70.75 3215-51-2300 FICA Medicare Contributio 899.00 93.62 0.00 636.42 0.00 262.58 70.79 3215-51-2400 Retirement Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3215-51-2700 Workers Compensation 3,412.00 0.00 0.00 2,611.50 0.00 800.50 76.54 TOTAL PERSONNEL 70,191.00 6,986.57 0.00 49,896.11 0.00 20,294.89 71.09 SERVICES 3215-52-2203 Repair & Maintain - Equip 1,000.00 0.00 0.00 952.66 0.00 47.34 95.27 3215-52-3100 Property & Liability Insu 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 1,000.00 0.00 0.00 952.66 0.00 47.34 95.27 SUPPLIES 3215-53-1100 Supplies & Materials 300.00 0.00 0.00 0.00 0.00 300.00 0.00 3215-53-1600 Small Equipment 1,050.00 0.00 0.00 1,049.88 0.00 0.12 99.99 3215-53-1601 Safety Equipment 350.00 0.00 0.00 0.00 0.00 350.00 0.00 3215-53-1720 Uniforms 2,000.00 224.50 0.00 1,610.00 0.00 390.00 80.50 TOTAL SUPPLIES 3,700.00 224.50 0.00 2,659.88 0.00 1,040.12 71.89 CAPITAL OUTLAY 3215-54-2505 Beach Patrol Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 3215-56-1000 Depreciation/Amortization 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Beach Patrol 74,891.00 7,211.07 0.00 53,508.65 0.00 21,382.35 71.45 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 18 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Fire Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 3510-51-1100 Salaries & Wages 75,153.00 5,651.20 0.00 54,842.36 0.00 20,310.64 72.97 3510-51-1200 Part Time/Seasonal Wages 74,313.00 5,551.82 0.00 52,375.16 0.00 21,937.84 70.48 3510-51-1201 Volunteer Awards 3,200.00 0.00 0.00 800.00 0.00 2,400.00 25.00 3510-51-1300 Overtime 800.00 0.00 0.00 0.00 0.00 800.00 0.00 3510-51-1400 Employee Benefits 750.00 62.50 0.00 562.50 0.00 187.50 75.00 3510-51-2100 Health Insurance Benefits 18,966.00 1,469.51 0.00 12,478.33 0.00 6,487.67 65.79 3510-51-2200 FICA Soc Sec Contribution 9,363.00 698.46 0.00 6,731.94 0.00 2,631.06 71.90 3510-51-2300 FICA Medicare Contributio 2,190.00 163.35 0.00 1,574.41 0.00 615.59 71.89 3510-51-2400 Retirement Contributions 5,939.00 494.88 0.00 4,453.92 0.00 1,485.08 74.99 3510-51-2500 GA Firefighters Pen Fund 3,240.00 165.00 0.00 1,530.00 180.00 1,530.00 52.78 3510-51-2700 Workers Compensation 4,893.00 0.00 0.00 4,351.20 0.00 541.80 88.93 3510-51-2900 Other Employee Benefits 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL PERSONNEL 198,807.00 14,256.72 0.00 139,699.82 180.00 58,927.18 70.36 SERVICES 3510-52-1120 Management Support Activi 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3510-52-2110 Garbage 181.00 0.00 0.00 24.16 0.00 156.84 13.35 3510-52-2201 Repair & Maintain - Build 1,695.00 0.00 0.00 971.19 0.00 723.81 57.30 3510-52-2202 Repair & Maintain - Vehic 18,000.00 1,495.50 0.00 11,288.20 0.00 6,711.80 62.71 3510-52-2203 Repair & Maintain - Equip 6,000.00 1,253.75 0.00 3,972.96 0.00 2,027.04 66.22 3510-52-3100 Property & Liability Insu 14,539.57 0.00 0.00 12,299.54 0.00 2,240.03 84.59 3510-52-3200 Communication 22,500.00 0.00 0.00 372.00 10,478.69 11,649.31 48.23 3510-52-3202 Data & Fax Lines 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3510-52-3220 Postage & Freight 380.00 23.84 0.00 153.70 0.00 226.30 40.45 3510-52-3500 Travel & Related Expenses 300.00 0.00 0.00 0.00 0.00 300.00 0.00 3510-52-3600 Dues and Fees 1,000.00 40.00 0.00 79.17 0.00 920.83 7.92 3510-52-3603 Ga Firefighters Assoc Con 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3510-52-3700 Education & Training 1,000.00 0.00 0.00 844.24 0.00 155.76 84.42 3510-52-3850 Contract Labor 1,500.00 0.00 0.00 257.00 0.00 1,243.00 17.13 3510-52-3920 Minor accidents 500.00 0.00 0.00 0.00 0.00 500.00 0.00 TOTAL SERVICES 67,595.57 2,813.09 0.00 30,262.16 10,478.69 26,854.72 60.27 SUPPLIES 3510-53-1100 Supplies & Materials 1,700.00 10.47 0.00 1,422.04 0.00 277.96 83.65 3510-53-1102 Flags 150.00 0.00 0.00 97.39 0.00 52.61 64.93 3510-53-1103 Medical supplies - expend 1,500.00 0.00 0.00 415.08 385.68 699.24 53.38 3510-53-1120 Marine Rescue Operations 1,100.00 0.00 0.00 118.21 0.00 981.79 10.75 3510-53-1122 Calendar Fundraiser 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3510-53-1210 Water & Sewer 820.50 25.72 0.00 629.81 0.00 190.69 76.76 3510-53-1220 Propane 950.00 0.00 0.00 0.00 0.00 950.00 0.00 3510-53-1230 Electricity 4,576.50 293.73 0.00 2,944.27 0.00 1,632.23 64.33 3510-53-1270 Gasoline & Diesel Fuel 8,000.00 1,123.50 0.00 7,410.51 0.00 589.49 92.63 3510-53-1271 Gasoline - EMS Chatham Co 0.00 ( 708.01) 0.00 ( 1,419.39) 0.00 1,419.39 0.00 3510-53-1300 Volunteer Apprec -Wed Dri 3,500.00 169.64 0.00 169.64 0.00 3,330.36 4.85 3510-53-1400 Books & periodicals 200.00 0.00 0.00 35.08 0.00 164.92 17.54 3510-53-1600 Small Equipment 15,900.00 996.71 0.00 9,398.14 120.00 6,381.86 59.86 3510-53-1601 Breathing Apparatus 4,000.00 490.70 0.00 1,977.10 0.00 2,022.90 49.43 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 19 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Fire Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 3510-53-1602 Hose, accessories 2,135.10 0.00 0.00 0.00 0.00 2,135.10 0.00 3510-53-1603 Protective gear 1,164.90 0.00 0.00 1,164.90 0.00 0.00 100.00 3510-53-1710 Volunteer Apprec Awards D 4,800.00 0.00 0.00 4,499.31 0.00 300.69 93.74 3510-53-1720 Uniforms & Accessories 1,700.00 379.90 0.00 960.03 0.00 739.97 56.47 TOTAL SUPPLIES 52,197.00 2,782.36 0.00 29,822.12 505.68 21,869.20 58.10 CAPITAL OUTLAY 3510-54-2100 Machinery & Equipment 13,000.00 0.00 0.00 13,000.00 0.00 0.00 100.00 3510-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3510-54-2300 Furniture & Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 13,000.00 0.00 0.00 13,000.00 0.00 0.00 100.00 DEPRECIATION/AMORTIZATIO 3510-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Fire Administration 331,599.57 19,852.17 0.00 212,784.10 11,164.37 107,651.10 67.54 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 20 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Emergency Management % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 3920-51-1100 Salaries and Wages 36,908.00 2,799.46 0.00 26,760.17 0.00 10,147.83 72.51 3920-51-1200 Part Time/Seasonal Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3920-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3920-51-1400 Employee Benefits 750.00 62.50 0.00 562.50 0.00 187.50 75.00 3920-51-2100 Health Insurance Benefits 9,552.00 775.60 0.00 6,600.58 0.00 2,951.42 69.10 3920-51-2200 FICA Social Security Cont 2,335.00 177.44 0.00 1,694.01 0.00 640.99 72.55 3920-51-2300 FICA Medicare Contributio 546.00 41.50 0.00 396.17 0.00 149.83 72.56 3920-51-2400 Retirement Contributions 5,860.00 549.23 0.00 4,943.07 0.00 916.93 84.35 3920-51-2700 Workers Compensation 154.00 0.00 0.00 154.00 0.00 0.00 100.00 TOTAL PERSONNEL 56,105.00 4,405.73 0.00 41,110.50 0.00 14,994.50 73.27 SERVICES 3920-52-1300 Equipment Service 1,660.00 0.00 0.00 1,167.00 0.00 493.00 70.30 3920-52-2110 Garbage Charges 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3920-52-3100 Property & Liability Insu 5,085.95 0.00 0.00 3,814.48 0.00 1,271.47 75.00 3920-52-3220 Postage & Freight 500.00 0.00 0.00 0.00 0.00 500.00 0.00 3920-52-3225 CRS - Flood Awareness 685.00 0.00 0.00 300.00 0.00 385.00 43.80 3920-52-3500 Travel and Related 800.00 0.00 0.00 79.92 0.00 720.08 9.99 3920-52-3700 Education & Training 500.00 50.00 0.00 50.00 0.00 450.00 10.00 3920-52-3900 Fire Ext. Maintenance 3,000.00 0.00 0.00 179.19 2,700.00 120.81 95.97 TOTAL SERVICES 12,230.95 50.00 0.00 5,590.59 2,700.00 3,940.36 67.78 SUPPLIES 3920-53-1100 Supplies - Emergency Mgmt 490.00 62.05 0.00 338.66 0.00 151.34 69.11 3920-53-1107 Emergency Rations and Sup 1,500.00 1,281.82 0.00 1,281.82 0.00 218.18 85.45 3920-53-1120 Marine Rescue Squadron 600.00 0.00 0.00 0.00 0.00 600.00 0.00 3920-53-1210 Water Sewer Charges 48.00 0.00 0.00 0.00 0.00 48.00 0.00 3920-53-1230 Electicity 2,244.00 0.00 0.00 0.00 0.00 2,244.00 0.00 3920-53-1600 Small Equipment 750.00 339.72 0.00 569.33 0.00 180.67 75.91 3920-53-1601 Safety Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3920-53-1720 Uniforms 200.00 0.00 0.00 0.00 138.00 62.00 69.00 TOTAL SUPPLIES 5,832.00 1,683.59 0.00 2,189.81 138.00 3,504.19 39.91 CAPITAL OUTLAY 3920-54-2505 Emergency Mgmt Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Emergency Management 74,167.95 6,139.32 0.00 48,890.90 2,838.00 22,439.05 69.75 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 21 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Public Works % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 4210-51-1100 Salaries & Wages 655,148.00 45,945.00 0.00 462,795.54 0.00 192,352.46 70.64 4210-51-1200 Part Time/Seasonal Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-51-1300 Overtime 25,000.00 777.32 0.00 11,985.43 0.00 13,014.57 47.94 4210-51-1400 Employee Benefits 6,000.00 562.50 0.00 4,687.50 0.00 1,312.50 78.13 4210-51-2100 Health Insurance Benefits 138,344.00 10,923.81 0.00 87,222.72 0.00 51,121.28 63.05 4210-51-2200 FICA Soc Sec Contribution 44,219.00 2,927.82 0.00 29,690.74 0.00 14,528.26 67.14 4210-51-2300 FICA Medicare Contributio 10,342.00 684.74 0.00 6,943.88 0.00 3,398.12 67.14 4210-51-2400 Retirement Contributions 82,655.00 6,887.91 0.00 61,991.19 0.00 20,663.81 75.00 4210-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-51-2700 Workers Compensation 88,795.00 0.00 0.00 50,074.18 0.00 38,720.82 56.39 TOTAL PERSONNEL 1,050,503.00 68,709.10 0.00 715,391.18 0.00 335,111.82 68.10 SERVICES 4210-52-2140 Landscaping/Lawncare 10,000.00 9.40 0.00 2,407.25 0.00 7,592.75 24.07 4210-52-2141 Trees - Palms Up 2,000.00 0.00 0.00 260.00 0.00 1,740.00 13.00 4210-52-2200 Repair and Maintanance 75,590.00 5,280.78 0.00 56,007.28 419.13 19,163.59 74.65 4210-52-2201 Repair & Maintain - Build 1,200.00 0.00 0.00 892.29 0.00 307.71 74.36 4210-52-2202 Repair & Maintain - Vehic 10,500.00 0.00 0.00 131.00 23.00 10,346.00 1.47 4210-52-2203 Repair & Maintain - Equip 4,000.00 51.03 0.00 1,737.11 33.35 2,229.54 44.26 4210-52-2205 Repair & Maint- Infrastru 18,000.00 910.82 0.00 15,880.23 0.00 2,119.77 88.22 4210-52-2320 Rental - Equipment & Vehi 6,000.00 2,116.00 0.00 4,936.74 0.00 1,063.26 82.28 4210-52-3100 Property & Liability Insu 34,941.61 0.00 0.00 28,710.16 0.00 6,231.45 82.17 4210-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-52-3220 Postage & Freight 300.00 28.24 0.00 293.26 0.00 6.74 97.75 4210-52-3300 Advertising 100.00 0.00 0.00 0.00 0.00 100.00 0.00 4210-52-3500 Travel & Related Expenses 1,000.00 0.00 0.00 793.82 0.00 206.18 79.38 4210-52-3600 Dues, Fees & Licenses 17,000.00 0.00 0.00 12,412.71 0.00 4,587.29 73.02 4210-52-3700 Education and Training 5,000.00 25.00 0.00 3,716.00 0.00 1,284.00 74.32 4210-52-3850 Contract Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-52-3920 Minor Accidents 500.00 0.00 0.00 475.00 0.00 25.00 95.00 4210-52-3990 Service Charges, Late Cha 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 186,131.61 8,421.27 0.00 128,652.85 475.48 57,003.28 69.37 SUPPLIES 4210-53-1100 Supplies & Materials 38,000.00 378.56 0.00 13,227.70 1,457.38 23,314.92 38.64 4210-53-1105 Public Restroom Supplies 16,000.00 738.22 0.00 5,974.24 108.50 9,917.26 38.02 4210-53-1210 Water/Sewer Charges 1,511.00 86.16 0.00 726.73 0.00 784.27 48.10 4210-53-1220 Propane 1,600.00 85.00 0.00 85.00 0.00 1,515.00 5.31 4210-53-1230 Electricity 142,182.00 11,179.05 0.00 88,550.54 0.00 53,631.46 62.28 4210-53-1270 Gasoline & Diesel Fuel 51,000.00 4,336.85 0.00 35,289.81 0.00 15,710.19 69.20 4210-53-1400 Books & Periodicals 500.00 0.00 0.00 385.24 0.00 114.76 77.05 4210-53-1600 Small Equipment 6,000.00 0.00 0.00 928.94 0.00 5,071.06 15.48 4210-53-1601 Safety Equipment 13,000.00 302.42 0.00 8,337.53 0.00 4,662.47 64.13 4210-53-1702 Signs - various 10,000.00 0.00 0.00 7,062.83 0.00 2,937.17 70.63 4210-53-1720 Uniform/ Clothing 6,200.00 0.00 0.00 3,148.06 247.31 2,804.63 54.76 TOTAL SUPPLIES 285,993.00 17,106.26 0.00 163,716.62 1,813.19 120,463.19 57.88 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 22 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Public Works % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 4210-54-1100 Site Improvement 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-54-1410 Infrastructure 82,216.12 3,806.00 0.00 37,529.59 ( 2,600.00) 47,286.53 42.49 4210-54-2100 Machinery & Equipment 6,655.00 0.00 0.00 3,500.00 0.00 3,155.00 52.59 4210-54-2200 Vehicles 17,345.00 0.00 0.00 17,345.00 0.00 0.00 100.00 4210-54-2300 Furniture & Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-54-2500 Other Equipment 7,333.33 0.00 0.00 0.00 0.00 7,333.33 0.00 TOTAL CAPITAL OUTLAY 113,549.45 3,806.00 0.00 58,374.59 ( 2,600.00) 57,774.86 49.12 DEPRECIATION/AMORTIZATIO 4210-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 4210-57-2100 Sweeper Lease Payment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Public Works 1,636,177.06 98,042.63 0.00 1,066,135.24 ( 311.33) 570,353.15 65.14 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 23 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Storm Drainage % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 4250-52-1201 Studies, Survey, Consulta 7,500.00 500.00 0.00 4,500.00 0.00 3,000.00 60.00 4250-52-2102 Drainage Improvements 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 7,500.00 500.00 0.00 4,500.00 0.00 3,000.00 60.00 CAPITAL OUTLAY 4250-54-2100 Machinery & Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4250-54-2102 Drainage Improvements 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Storm Drainage 7,500.00 500.00 0.00 4,500.00 0.00 3,000.00 60.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 24 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Solid Waste Collection % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 4520-52-2110 Curbside Dry Trash Pickup 96,000.00 9,072.36 0.00 69,162.39 0.00 26,837.61 72.04 4520-52-2111 City Dump Pick Up -Waste 140,000.00 6,782.89 0.00 68,666.60 0.00 71,333.40 49.05 4520-52-2112 Compactor - Republic Serv 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 236,000.00 15,855.25 0.00 137,828.99 0.00 98,171.01 58.40 _________________________________________________________________________________________________________________________________ TOTAL Solid Waste Collection 236,000.00 15,855.25 0.00 137,828.99 0.00 98,171.01 58.40 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 25 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Cultural & Recreation % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 6110-51-1100 Salaries & Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-1200 Part Time/Seasonal Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-2100 Health Insurance Benefits 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-2200 Fica Social Security Cont 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-2300 FICA Medicare Contributio 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-2400 Retirement Contribution 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-2600 Unemployment Insurance Py 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-51-2700 Workers Compensation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL PERSONNEL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 SERVICES 6110-52-2110 Garbage Charges 2,200.00 144.11 0.00 1,272.83 0.00 927.17 57.86 6110-52-2130 Custodial 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-2201 Repair & Maintain - Build 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-2202 Vehicle repairs & mainten 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-2203 Repair & Maintain - Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3100 Property & Liability Insu 96,219.44 0.00 0.00 80,012.23 0.00 16,207.21 83.16 6110-52-3201 Telephone 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3202 Fax and Data Lines 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3220 Postage & Freight 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3300 Advertising 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3400 Printing & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3500 Travel & Related Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3600 Dues and Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-52-3700 Education and Training 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 98,419.44 144.11 0.00 81,285.06 0.00 17,134.38 82.59 SUPPLIES 6110-53-1100 Supplies & Materials 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1104 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1105 Public Restroom Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1150 Holiday expense 22,226.00 0.00 0.00 22,122.48 0.00 103.52 99.53 6110-53-1210 Water/Sewer Charges 2,919.00 234.25 0.00 2,383.91 0.00 535.09 81.67 6110-53-1220 Propane 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1230 Electricity 63,492.00 5,030.14 0.00 41,331.93 0.00 22,160.07 65.10 6110-53-1270 Gasoline & Diesel Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1400 Books & Periodicals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1591 Concession Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1600 Small Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1601 Gym - Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-53-1720 Uniforms & Accessories 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 88,637.00 5,264.39 0.00 65,838.32 0.00 22,798.68 74.28 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 26 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Cultural & Recreation % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 6110-54-1100 Capital Outlay-Sites 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-54-1200 Site Improvments 4,912.04 ( 1,165.00) 0.00 3,747.04 0.00 1,165.00 76.28 6110-54-2100 Recreation Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-54-2300 Furniture & Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-54-2500 Other Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-54-2501 Playground Equip/Splashpa 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 4,912.04 ( 1,165.00) 0.00 3,747.04 0.00 1,165.00 76.28 DEPRECIATION/AMORTIZATIO 6110-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 6110-57-1325 Project Read - Royce Lear 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-57-2002 Tybee Beautification Asso 4,500.00 0.00 0.00 0.00 0.00 4,500.00 0.00 6110-57-2003 Tybee Arts Association 1,500.00 0.00 0.00 0.00 0.00 1,500.00 0.00 6110-57-2004 Yeepies 750.00 0.00 0.00 370.92 0.00 379.08 49.46 6110-57-2005 Eastern Surfing Assoc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-57-2006 Beach Bums 750.00 0.00 0.00 0.00 0.00 750.00 0.00 6110-57-2007 Fine Arts Commission 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-57-2008 Friends of the Tybee Thea 7,500.00 7,500.00 0.00 7,500.00 0.00 0.00 100.00 6110-57-2009 American Legion 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-57-2010 Garden Club 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-57-2011 Irish Heritage 750.00 0.00 0.00 0.00 0.00 750.00 0.00 6110-57-2012 United Way Coastal Empire 1,125.00 182.00 0.00 1,309.34 0.00 ( 184.34) 116.39 6110-57-2013 Tybee Fest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-57-2014 Tybee DAC Kids, Inc. 375.00 0.00 0.00 0.00 0.00 375.00 0.00 6110-57-2015 Islands Feral Cats Projec 740.00 0.00 0.00 740.00 0.00 0.00 100.00 TOTAL OTHER COSTS 17,990.00 7,682.00 0.00 9,920.26 0.00 8,069.74 55.14 _________________________________________________________________________________________________________________________________ TOTAL Cultural & Recreation 209,958.48 11,925.50 0.00 160,790.68 0.00 49,167.80 76.58 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 27 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Recreation Centers % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 6122-52-2201 YMCA-Repair & Maintain - 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-2202 YMCA Repair & Maint- Vehi 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3300 YMCA Advertising 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3600 YMCA Camp Class 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3611 YMCA Youth Sports 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3612 YMCA Teen Center 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3613 YMCA Child Care 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3615 YMCA Senior/Adult Program 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-52-3850 YMCA - Director Services 158,450.00 13,204.17 0.00 118,837.53 0.00 39,612.47 75.00 TOTAL SERVICES 158,450.00 13,204.17 0.00 118,837.53 0.00 39,612.47 75.00 SUPPLIES 6122-53-1100 YMCA Gen Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-53-1150 YMCA Holiday Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-53-1270 YMCA - Gasoline 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6122-53-1600 YMCA Small Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 CAPITAL OUTLAY 6122-54-2100 YMCA Capital Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Recreation Centers 158,450.00 13,204.17 0.00 118,837.53 0.00 39,612.47 75.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 28 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Lifeguards % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 6124-51-1100 Salaries & Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-51-1200 Part Time/Seasonal Wages 306,579.00 613.80 0.00 172,586.11 0.00 133,992.89 56.29 6124-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-51-2100 Health Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-51-2200 FICA Soc Sec Contribution 19,007.00 38.05 0.00 10,700.33 0.00 8,306.67 56.30 6124-51-2300 FICA Medicare Contributio 4,446.00 8.90 0.00 2,502.57 0.00 1,943.43 56.29 6124-51-2600 Unemployment Ins 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-51-2700 Workers Compensation 9,627.00 0.00 0.00 7,500.00 0.00 2,127.00 77.91 TOTAL PERSONNEL 339,659.00 660.75 0.00 193,289.01 0.00 146,369.99 56.91 SERVICES 6124-52-1226 Lifeguard Certifications 2,350.00 0.00 0.00 1,454.95 0.00 895.05 61.91 6124-52-2110 Garbage Charges 181.00 0.00 0.00 0.00 0.00 181.00 0.00 6124-52-2130 Custodial 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-2201 Repair & Maintain - Build 1,500.00 583.11 0.00 583.11 0.00 916.89 38.87 6124-52-2203 Repair & Maintain - Equip 4,500.00 0.00 0.00 3,482.07 0.00 1,017.93 77.38 6124-52-2204 Repair & Maintain-Beach & 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-2310 Rental of Building 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-2320 Rental Equip & Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-3100 Property & Liability Insu 1,338.41 0.00 0.00 2,914.80 0.00 ( 1,576.39) 217.78 6124-52-3220 Postage 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-3300 Advertising 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-3590 Enviro Education Allia 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-52-3700 Education & Training 250.00 0.00 0.00 0.00 0.00 250.00 0.00 TOTAL SERVICES 10,119.41 583.11 0.00 8,434.93 0.00 1,684.48 83.35 SUPPLIES 6124-53-1100 General Supplies & Materi 1,521.00 118.88 0.00 1,490.26 0.00 30.74 97.98 6124-53-1104 First Aid Supplies 2,950.00 1,242.51 0.00 2,141.89 764.78 43.33 98.53 6124-53-1210 Water & Sewer 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-53-1230 Electricity 1,200.00 0.00 0.00 0.00 0.00 1,200.00 0.00 6124-53-1270 Gas & Diesel Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6124-53-1600 Small Equipment 3,000.00 492.23 0.00 2,915.33 0.00 84.67 97.18 6124-53-1720 Uniforms 3,500.00 0.00 0.00 18.40 0.00 3,481.60 0.53 TOTAL SUPPLIES 12,171.00 1,853.62 0.00 6,565.88 764.78 4,840.34 60.23 CAPITAL OUTLAY 6124-54-2505 Lifegrd Capital Equipment 8,029.00 0.00 0.00 8,029.00 0.00 0.00 100.00 TOTAL CAPITAL OUTLAY 8,029.00 0.00 0.00 8,029.00 0.00 0.00 100.00 DEPRECIATION/AMORTIZATIO 6124-56-1000 Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Lifeguards 369,978.41 3,097.48 0.00 216,318.82 764.78 152,894.81 58.67 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 29 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Beach Related % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 6125-52-1250 Beach Task Force Expense 2,000.00 108.18 0.00 1,193.20 0.00 806.80 59.66 6125-52-2110 Garbage Beach Related 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 2,000.00 108.18 0.00 1,193.20 0.00 806.80 59.66 SUPPLIES 6125-53-1210 Water/Sewer Chgs 19,041.00 422.10 0.00 8,564.52 0.00 10,476.48 44.98 6125-53-1230 Electricity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6125-53-1235 Beach Oper & Maint 37,366.66 0.00 0.00 22,641.66 0.00 14,725.00 60.59 TOTAL SUPPLIES 56,407.66 422.10 0.00 31,206.18 0.00 25,201.48 55.32 CAPITAL OUTLAY 6125-54-1205 Beach Related Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6125-54-1311 Public Restrooms Beachsid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6125-54-1401 8th Street Dune 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6125-54-1402 Beach Renourishment 300,000.00 14,876.94 0.00 111,876.94 470.50 187,652.56 37.45 6125-54-2105 Capital - Misc. 47,000.00 0.00 0.00 45,142.82 0.00 1,857.18 96.05 TOTAL CAPITAL OUTLAY 347,000.00 14,876.94 0.00 157,019.76 470.50 189,509.74 45.39 _________________________________________________________________________________________________________________________________ TOTAL Beach Related 405,407.66 15,407.22 0.00 189,419.14 470.50 215,518.02 46.84 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 30 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Museums % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 6172-57-2000 Tybee Island Historic Soc 16,125.00 0.00 0.00 16,125.00 0.00 0.00 100.00 6172-57-2001 Marine Science Center 25,212.00 0.00 0.00 25,212.00 0.00 0.00 100.00 TOTAL OTHER COSTS 41,337.00 0.00 0.00 41,337.00 0.00 0.00 100.00 _________________________________________________________________________________________________________________________________ TOTAL Museums 41,337.00 0.00 0.00 41,337.00 0.00 0.00 100.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 31 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund River's End RV Park % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 6180-51-1100 Salaries & Wages 194,536.91 0.00 0.00 0.00 0.00 194,536.91 0.00 6180-51-1200 Part Time/Seasonal Wages 35,837.09 0.00 0.00 0.00 0.00 35,837.09 0.00 6180-51-1300 Overtime 6,000.00 0.00 0.00 0.00 0.00 6,000.00 0.00 6180-51-1400 Employee Benefits 1,500.00 0.00 0.00 0.00 0.00 1,500.00 0.00 6180-51-2100 Health Insurance Benefits 33,482.00 0.00 0.00 0.00 ( 227.69) 33,709.69 0.68- 6180-51-2200 FICA Soc Sec Contributio 14,953.00 0.00 0.00 0.00 0.00 14,953.00 0.00 6180-51-2300 FICA Medicare Contrib 3,497.00 0.00 0.00 0.00 0.00 3,497.00 0.00 6180-51-2400 Retirement Contributions 25,372.00 0.00 0.00 0.00 0.00 25,372.00 0.00 6180-51-2600 Unemployment Insurance 3,300.00 0.00 0.00 0.00 0.00 3,300.00 0.00 6180-51-2700 Workers Compensation 3,895.57 0.00 0.00 0.00 0.00 3,895.57 0.00 TOTAL PERSONNEL 322,373.57 0.00 0.00 0.00 ( 227.69) 322,601.26 0.07- SERVICES 6180-52-2110 Garbage Service 6,408.00 0.00 0.00 0.00 0.00 6,408.00 0.00 6180-52-2130 Custodial Services 1,320.00 0.00 0.00 0.00 0.00 1,320.00 0.00 6180-52-2135 Pool Cleaning Service 3,600.00 0.00 0.00 0.00 0.00 3,600.00 0.00 6180-52-2200 Pest Control 2,869.00 0.00 0.00 0.00 ( 229.00) 3,098.00 7.98- 6180-52-2201 Repair & Maint - Equipme( 1,793.46) 0.00 0.00 0.00 0.00 ( 1,793.46) 0.00 6180-52-2202 Repair & Maint - Vehicle 488.84 0.00 0.00 0.00 0.00 488.84 0.00 6180-52-2203 Repair & Maint - Bldgs 15,000.00 0.00 0.00 0.00 0.00 15,000.00 0.00 6180-52-2205 Repair & Maint -Infrastru 22,507.98 0.00 0.00 0.00 0.00 22,507.98 0.00 6180-52-3100 Property & Liability Insu 7,907.76 0.00 0.00 0.00 0.00 7,907.76 0.00 6180-52-3201 Telephone/ Communications 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-52-3202 Cable, Data & Fax Lines 11,500.00 0.00 0.00 0.00 ( 1,002.21) 12,502.21 8.71- 6180-52-3220 Postage & Freight 817.83 0.00 0.00 0.00 0.00 817.83 0.00 6180-52-3300 Advertising 55,780.72 0.00 0.00 0.00 0.00 55,780.72 0.00 6180-52-3400 Printing & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-52-3500 Travel and Related 2,767.75 0.00 0.00 0.00 0.00 2,767.75 0.00 6180-52-3600 Dues & Fees 5,552.49 0.00 0.00 0.00 0.00 5,552.49 0.00 6180-52-3700 Education & Training 1,719.00 0.00 0.00 0.00 0.00 1,719.00 0.00 6180-52-3800 Permits, Regulatory Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-52-3850 Contract Labor 9,721.93 0.00 0.00 0.00 0.00 9,721.93 0.00 6180-52-3901 Credit Card Chgs 19,000.00 0.00 0.00 0.00 0.00 19,000.00 0.00 TOTAL SERVICES 165,167.84 0.00 0.00 0.00 ( 1,231.21) 166,399.05 0.75- SUPPLIES 6180-53-1100 Supplies and Materials 43,543.00 0.00 0.00 0.00 ( 215.70) 43,758.70 0.50- 6180-53-1102 Flags 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-53-1130 Pool Cleaning Supplies 3,225.00 0.00 0.00 0.00 0.00 3,225.00 0.00 6180-53-1210 Water/Sewer Charges 19,962.00 0.00 0.00 0.00 0.00 19,962.00 0.00 6180-53-1220 Propane 2,130.82 0.00 0.00 0.00 ( 113.80) 2,244.62 5.34- 6180-53-1230 Electricity 75,474.00 0.00 0.00 0.00 0.00 75,474.00 0.00 6180-53-1270 Gasoline & Diesel 900.00 0.00 0.00 0.00 0.00 900.00 0.00 6180-53-1520 Propane RV Park- 12,000.00 0.00 0.00 0.00 ( 121.82) 12,121.82 1.02- 6180-53-1595 Camp Store Groceries 25,600.00 0.00 0.00 0.00 0.00 25,600.00 0.00 6180-53-1596 Camp Store - RV Supls - C 12,000.00 0.00 0.00 0.00 3,035.26 8,964.74 25.29 6180-53-1600 Small Equipment 36,049.31 0.00 0.00 0.00 0.00 36,049.31 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 32 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund River's End RV Park % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 6180-53-1703 Campgrd Over/Short 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-53-1720 Uniforms 603.05 0.00 0.00 0.00 0.00 603.05 0.00 6180-53-2201 RV Supplies Pd Out 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 231,487.18 0.00 0.00 0.00 2,583.94 228,903.24 1.12 CAPITAL OUTLAY 6180-54-1100 Capital Improvements 56,138.50 0.00 0.00 0.00 0.00 56,138.50 0.00 6180-54-2100 Capital Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 56,138.50 0.00 0.00 0.00 0.00 56,138.50 0.00 INTERFUND/INTERDEPARTMENT 6180-55-1100 Admin Services 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INTERFUND/INTERDEPARTMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 6180-56-1000 Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 6180-58-1100 Prin Rev Bond RE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-58-2100 Int BK NY Bond 456885 Cam 280,815.00 0.00 0.00 0.00 0.00 280,815.00 0.00 6180-58-2202 General Fund Note 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-58-3000 Custodian Fees & Charges 541.67 0.00 0.00 0.00 0.00 541.67 0.00 6180-58-4000 Bond Issuance Cost Amorti 6,000.00 0.00 0.00 0.00 0.00 6,000.00 0.00 TOTAL DEBT SERVICE 287,356.67 0.00 0.00 0.00 0.00 287,356.67 0.00 _________________________________________________________________________________________________________________________________ TOTAL River's End RV Park 1,062,523.76 0.00 0.00 0.00 1,125.04 1,061,398.72 0.11 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 33 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Parks Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 6210-51-1100 Salaries 113,749.00 8,388.82 0.00 74,323.26 0.00 39,425.74 65.34 6210-51-1300 Overtime 10,000.00 351.30 0.00 3,169.47 0.00 6,830.53 31.69 6210-51-1400 Employee Benefits 750.00 62.50 0.00 312.50 0.00 437.50 41.67 6210-51-2100 Health Insurance Benefits 25,095.00 1,588.07 0.00 12,783.24 0.00 12,311.76 50.94 6210-51-2200 FICA Social Security Cont 7,719.00 545.76 0.00 4,823.96 0.00 2,895.04 62.49 6210-51-2300 FICA Medicare 1,805.00 127.63 0.00 1,128.17 0.00 676.83 62.50 6210-51-2400 Retirement Contributions 7,423.00 618.53 0.00 5,566.77 0.00 1,856.23 74.99 6210-51-2700 Workers Compensation 3,909.00 0.00 0.00 2,697.94 0.00 1,211.06 69.02 TOTAL PERSONNEL 170,450.00 11,682.61 0.00 104,805.31 0.00 65,644.69 61.49 SERVICES 6210-52-2140 Landscape/Lawncare 1,000.00 0.00 0.00 785.00 0.00 215.00 78.50 6210-52-2202 Repair & Maint- Vehicles 4,000.00 0.00 0.00 0.00 0.00 4,000.00 0.00 6210-52-2203 Repair & Maint- Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-52-2205 Repair & Maint -Infrastru 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-52-3100 Property & Liability Insu 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 5,000.00 0.00 0.00 785.00 0.00 4,215.00 15.70 SUPPLIES 6210-53-1100 General Supplies and Mate 18,600.00 1,595.28 0.00 9,022.12 ( 1,622.17) 11,200.05 39.78 6210-53-1102 Flags 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-53-1210 Water/Sewer Chgs 1,231.00 73.40 0.00 700.85 0.00 530.15 56.93 6210-53-1230 Electricity 4,730.00 275.48 0.00 2,523.43 0.00 2,206.57 53.35 6210-53-1270 Gas & Diesel Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-53-1600 Small Equipment 600.00 0.00 0.00 0.00 0.00 600.00 0.00 TOTAL SUPPLIES 25,161.00 1,944.16 0.00 12,246.40 ( 1,622.17) 14,536.77 42.22 CAPITAL OUTLAY 6210-54-1100 Site Improvements 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 6210-54-1110 Tennis Courts 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-54-1450 Cremation Wall & Mem Plaq 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-54-2105 Mower 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6210-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 DEPRECIATION/AMORTIZATIO 6210-56-1000 Depreciation - Parks 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Parks Administration 205,611.00 13,626.77 0.00 117,836.71 ( 1,622.17) 89,396.46 56.52 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 34 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Zoning and Inspection % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 7220-51-1100 Salaries & Wages 90,324.00 6,801.97 0.00 64,783.15 0.00 25,540.85 71.72 7220-51-1200 Part Time/Seasonal Wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-51-1300 Overtime 500.00 0.00 0.00 0.00 0.00 500.00 0.00 7220-51-1400 Employee Benefits 2,550.00 212.50 0.00 1,912.50 0.00 637.50 75.00 7220-51-2100 Health Insurance Benefits 16,168.00 1,296.95 0.00 9,898.25 0.00 6,269.75 61.22 7220-51-2200 FICA Soc Sec Contribution 5,789.00 431.66 0.00 4,110.85 0.00 1,678.15 71.01 7220-51-2300 FICA Medicare Contributio 1,354.00 100.96 0.00 961.48 0.00 392.52 71.01 7220-51-2400 Retirement contributions 6,856.00 571.27 0.00 5,141.43 0.00 1,714.57 74.99 7220-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-51-2700 Workers Compensation 383.00 0.00 0.00 261.63 0.00 121.37 68.31 TOTAL PERSONNEL 123,924.00 9,415.31 0.00 87,069.29 0.00 36,854.71 70.26 SERVICES 7220-52-1100 Studies/Mstr Plan Upd/Sol 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 7220-52-1200 Legal Notices 1,100.00 0.00 0.00 150.00 240.00 710.00 35.45 7220-52-1202 Engineer Review 15,000.00 0.00 0.00 7,177.50 0.00 7,822.50 47.85 7220-52-1203 Engineer Review - Billabl 15,000.00 700.00 0.00 5,731.25 0.00 9,268.75 38.21 7220-52-1205 County Inspection Contrac 30,000.00 0.00 0.00 14,146.00 15,854.00 0.00 100.00 7220-52-1232 Videographer 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-52-1240 Planning Commission expen 1,000.00 0.00 0.00 111.00 0.00 889.00 11.10 7220-52-2110 Garbage Charges 45.00 3.54 0.00 31.56 0.00 13.44 70.13 7220-52-2201 Repair & Maint- Buildings 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-52-2202 Repair & Maint- Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-52-2203 Repair & Maint- Equipment 2,750.00 270.86 0.00 2,363.88 386.12 0.00 100.00 7220-52-2320 Rental - Equip & Vehicles 11,975.00 975.00 0.00 7,800.00 4,175.00 0.00 100.00 7220-52-3100 Property & Liability Insu 875.45 0.00 0.00 1,663.29 0.00 ( 787.84) 189.99 7220-52-3220 Postage & Freight 750.00 53.66 0.00 206.76 0.00 543.24 27.57 7220-52-3400 Printing & Binding 750.00 0.00 0.00 0.00 0.00 750.00 0.00 7220-52-3500 Travel & Related Expenses 2,500.00 515.00 0.00 1,184.98 0.00 1,315.02 47.40 7220-52-3600 Dues and Fees 1,250.00 11.95 0.00 776.93 103.40 369.67 70.43 7220-52-3700 Educ & Training 2,500.00 50.00 0.00 945.00 0.00 1,555.00 37.80 7220-52-3850 Contract Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 90,495.45 2,580.01 0.00 42,288.15 20,758.52 27,448.78 69.67 SUPPLIES 7220-53-1100 Supplies & Materials 4,993.00 2,453.30 0.00 3,960.28 520.81 511.91 89.75 7220-53-1210 Water/Sewer Chgs 33.00 2.37 0.00 21.94 0.00 11.06 66.48 7220-53-1230 Electricity 1,391.00 67.49 0.00 582.99 0.00 808.01 41.91 7220-53-1400 Books & Periodicals 750.00 0.00 0.00 210.00 0.00 540.00 28.00 7220-53-1600 Small Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 7,167.00 2,523.16 0.00 4,775.21 520.81 1,870.98 73.89 CAPITAL OUTLAY 7220-54-2105 Wayfinding Signs 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-54-2150 GIS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7220-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 35 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Zoning and Inspection % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 7220-54-2300 Furniture & Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 7220-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Zoning and Inspection 221,586.45 14,518.48 0.00 134,132.65 21,279.33 66,174.47 70.14 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 36 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Better Hometown % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 7300-51-1100 Salaries & Wages 41,340.00 3,109.60 0.00 29,663.96 0.00 11,676.04 71.76 7300-51-1400 Employee Benefits 375.00 31.25 0.00 281.25 0.00 93.75 75.00 7300-51-2100 Health Insurance 9,610.00 778.72 0.00 6,611.86 0.00 2,998.14 68.80 7300-51-2200 FICA Social Security 2,586.00 191.16 0.00 1,822.66 0.00 763.34 70.48 7300-51-2300 FICA Medicare 605.00 44.71 0.00 426.30 0.00 178.70 70.46 7300-51-2400 Retirement Contributions 6,110.00 509.13 0.00 4,582.17 0.00 1,527.83 74.99 7300-51-2700 Workers Compensation 159.00 0.00 0.00 112.82 0.00 46.18 70.96 TOTAL PERSONNEL 60,785.00 4,664.57 0.00 43,501.02 0.00 17,283.98 71.57 SERVICES 7300-52-2110 Garbage Charges 17.00 1.38 0.00 11.84 0.00 5.16 69.65 7300-52-3100 Property & Liability Insu 283.01 0.00 0.00 212.24 0.00 70.77 74.99 7300-52-3500 Travel & Related 2,135.00 308.03 0.00 1,049.39 0.00 1,085.61 49.15 7300-52-3600 Dues & Fees 2,175.00 250.00 0.00 1,869.50 0.00 305.50 85.95 7300-52-3700 Education & Training 1,300.00 0.00 0.00 237.50 0.00 1,062.50 18.27 7300-52-3850 BHT Contract Labor 400.00 0.00 0.00 0.00 0.00 400.00 0.00 TOTAL SERVICES 6,310.01 559.41 0.00 3,380.47 0.00 2,929.54 53.57 SUPPLIES 7300-53-1100 Supplies & Materials 4,600.00 150.00 0.00 2,365.95 2,050.00 184.05 96.00 7300-53-1210 Water Sewer Chgs 20.00 0.86 0.00 7.67 0.00 12.33 38.35 7300-53-1230 Electricity 440.00 21.82 0.00 188.47 0.00 251.53 42.83 7300-53-1231 Donated Money Expenses 2,294.47 0.00 0.00 0.00 0.00 2,294.47 0.00 7300-53-1400 Books & Periodicals 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 7,354.47 172.68 0.00 2,562.09 2,050.00 2,742.38 62.71 _________________________________________________________________________________________________________________________________ TOTAL Better Hometown 74,449.48 5,396.66 0.00 49,443.58 2,050.00 22,955.90 69.17 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 37 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Community Development % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SUPPLIES 7520-53-1425 Leadership Tybee 5,106.00 155.94 0.00 528.12 0.00 4,577.88 10.34 TOTAL SUPPLIES 5,106.00 155.94 0.00 528.12 0.00 4,577.88 10.34 CAPITAL OUTLAY 7520-54-1405 S Beach Business District 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1410 Solomon Rd Rehab 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1415 Battery Row 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1420 Butler Ave Brick Crosswal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1425 Leadership Tybee 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1426 TE/Butler Match 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1427 LWCF Trails Match 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1428 US80/McKenzie Crosswalk 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1429 ADA Sidewalk Butler/Silve 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1430 Bike Trail Mem Park 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 7520-56-1000 Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Community Development 5,106.00 155.94 0.00 528.12 0.00 4,577.88 10.34 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 38 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Parking % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 7564-51-1100 Salaries & Wages 134,579.00 6,925.62 0.00 64,430.93 0.00 70,148.07 47.88 7564-51-1200 Part Time/Seasonal Wages 94,629.00 580.45 0.00 38,757.75 0.00 55,871.25 40.96 7564-51-1300 Overtime 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-51-1400 Employee Benefits 1,500.00 62.50 0.00 562.50 0.00 937.50 37.50 7564-51-2100 Health Insurance Benefits 18,500.00 1,497.81 0.00 12,635.56 0.00 5,864.44 68.30 7564-51-2200 FICA Soc Sec Contribution 14,784.00 466.86 0.00 6,409.98 0.00 8,374.02 43.36 7564-51-2300 FICA Medicare Contributio 3,458.00 109.17 0.00 1,499.04 0.00 1,958.96 43.35 7564-51-2400 Retirement Contributions 9,667.00 805.52 0.00 7,249.68 0.00 2,417.32 74.99 7564-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-51-2700 Workers Compensation 7,488.00 0.00 0.00 4,877.41 0.00 2,610.59 65.14 TOTAL PERSONNEL 284,605.00 10,447.93 0.00 136,422.85 0.00 148,182.15 47.93 SERVICES 7564-52-1300 Computer service contract 58,000.00 4,176.50 0.00 37,787.50 14,584.50 5,628.00 90.30 7564-52-2110 Garbage Charges 14.00 1.04 0.00 13.29 0.00 0.71 94.93 7564-52-2202 Repair & Maint- Vehicles 3,650.00 103.86 0.00 1,817.12 0.00 1,832.88 49.78 7564-52-2203 Repair & Maint- Equipment 3,400.00 0.00 0.00 2,146.76 600.00 653.24 80.79 7564-52-2310 Rent Land & Buildings 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-52-2320 Rental Equip & Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-52-2325 Armored Car Service 1,600.00 0.00 0.00 728.40 0.00 871.60 45.53 7564-52-3100 Property & Liability Insu 1,383.22 0.00 0.00 1,383.22 0.00 0.00 100.00 7564-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-52-3220 Postage & Freight 5,000.00 118.17 0.00 3,607.69 0.00 1,392.31 72.15 7564-52-3300 Advertising 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-52-3400 Printing & Binding 177.00 0.00 0.00 177.00 0.00 0.00 100.00 7564-52-3500 Travel & Related Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-52-3600 Dues and Fees 200.00 0.00 0.00 155.33 0.00 44.67 77.67 7564-52-3700 Educ & Training 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-52-3850 Contract Labor 1,000.00 0.00 0.00 320.52 109.36 570.12 42.99 7564-52-3901 Credit Card Service Charg 150,000.00 2,751.38 0.00 72,414.49 2,510.69 75,074.82 49.95 TOTAL SERVICES 224,424.22 7,150.95 0.00 120,551.32 17,804.55 86,068.35 61.65 SUPPLIES 7564-53-1100 Supplies & Materials 20,400.00 3,403.87 0.00 9,179.87 ( 1,681.28) 12,901.41 36.76 7564-53-1110 Parking Meters 63,500.00 0.00 0.00 42,510.28 20,989.72 0.00 100.00 7564-53-1210 Water/Sewer Charges 91.00 0.62 0.00 5.69 0.00 85.31 6.25 7564-53-1230 Electricity 691.88 60.51 0.00 568.22 0.00 123.66 82.13 7564-53-1270 Gas & Diesel Fuel 9,220.17 298.58 0.00 7,476.49 0.00 1,743.68 81.09 7564-53-1590 Inventory - Parking Decal 2,280.00 0.00 0.00 2,280.00 0.00 0.00 100.00 7564-53-1600 Small Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7564-53-1701 Cash/ Short-Over deposits 0.00 ( 9.25) 0.00 ( 76.00) 0.00 76.00 0.00 7564-53-1702 Signs 900.00 0.00 0.00 685.21 0.00 214.79 76.13 7564-53-1720 Uniforms 942.25 77.00 0.00 271.25 671.00 0.00 100.00 TOTAL SUPPLIES 98,025.30 3,831.33 0.00 62,901.01 19,979.44 15,144.85 84.55 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 39 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Parking % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 7564-54-2055 Parking Meter System 14,951.00 0.00 0.00 14,880.00 0.00 71.00 99.53 7564-54-2200 Vehicles 3,500.00 0.00 0.00 3,398.00 0.00 102.00 97.09 7564-54-2410 Capital Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 18,451.00 0.00 0.00 18,278.00 0.00 173.00 99.06 DEPRECIATION/AMORTIZATIO 7564-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Parking 625,505.52 21,430.21 0.00 338,153.18 37,783.99 249,568.35 60.10 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 40 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Debt Service % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 8000-52-1000 Debt Service Transfers Ou 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 8000-58-1200 GMA - Lease / Purchase 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8000-58-1206 GMA lease - Sanitation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8000-58-1211 Debt service - AT&T capit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8000-58-2010 Interest Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8000-58-2200 Interest-Capital Lease 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Debt Service 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 41 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 100-General Fund Other Financing Uses % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- DEPRECIATION/AMORTIZATIO 9000-56-1000 FOTT Grant Match 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 9000-57-4000 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 9000-58-1201 Prin Emergency Siren 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9000-58-2201 Int Emergency Siren 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER FINANCING USES 9000-61-1000 Contingency 173,744.72 0.00 0.00 0.00 0.00 173,744.72 0.00 9000-61-1001 Trans out Solid Waste Fun 60,785.00 0.00 0.00 0.00 0.00 60,785.00 0.00 9000-61-1002 Trans out E911 Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9000-61-1003 Transfer Out Grant Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9000-61-1005 Transfer Out - SPLOST 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9000-61-1555 Trans out River's End RV 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING USES 234,529.72 0.00 0.00 0.00 0.00 234,529.72 0.00 _________________________________________________________________________________________________________________________________ TOTAL Other Financing Uses 234,529.72 0.00 0.00 0.00 0.00 234,529.72 0.00 FUND TOTAL EXPENDITURES 9,992,340.18 534,446.19 20.20 5,745,467.37 165,071.80 4,081,801.01 59.15 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 215-Emergency 911 Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CHARGES FOR SERVICES 00-34.2501 E-911 Wireless Charges 43,495.00 3,578.20 0.00 39,059.84 0.00 4,435.16 89.80 00-34.2520 E911 Landline Charges 37,300.00 0.00 0.00 2,041.69 0.00 35,258.31 5.47 TOTAL CHARGES FOR SERVICES 80,795.00 3,578.20 0.00 41,101.53 0.00 39,693.47 50.87 OTHER FINANCING SOURCES 00-39.1201 Transfers In 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3502 Fund Balance from Prior Yea 3,508.00 0.00 0.00 0.00 0.00 3,508.00 0.00 TOTAL OTHER FINANCING SOURCES 3,508.00 0.00 0.00 0.00 0.00 3,508.00 0.00 *** TOTAL REVENUES *** 84,303.00 3,578.20 0.00 41,101.53 0.00 43,201.47 48.75 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 215-Emergency 911 Fund Police Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 3210-51-1100 Salaries 35,223.00 2,846.60 0.00 27,006.27 0.00 8,216.73 76.67 3210-51-1300 Overtime 4,000.00 0.00 0.00 3,475.53 0.00 524.47 86.89 3210-51-1400 Employee Benefits 0.00 0.00 0.00 ( 1.35) 0.00 1.35 0.00 3210-51-2100 Health Insurance Benefits 12,791.00 958.76 0.00 7,406.60 0.00 5,384.40 57.90 3210-51-2200 FICA Soc Sec 2,308.00 176.49 0.00 1,895.77 0.00 412.23 82.14 3210-51-2300 FICA Medicare 540.00 41.28 0.00 443.40 0.00 96.60 82.11 3210-51-2400 Retirement Contributions 5,500.00 0.00 0.00 0.00 0.00 5,500.00 0.00 3210-51-2700 Workers Compensation 441.00 0.00 0.00 0.00 0.00 441.00 0.00 TOTAL PERSONNEL 60,803.00 4,023.13 0.00 40,226.22 0.00 20,576.78 66.16 SERVICES 3210-52-1221 Audit Fees 1,500.00 0.00 0.00 0.00 0.00 1,500.00 0.00 3210-52-2203 Repair & Maintain - Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3100 Property & Liability Insu 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-52-3201 Telephones 22,000.00 1,715.52 0.00 14,007.81 552.15 7,440.04 66.18 TOTAL SERVICES 23,500.00 1,715.52 0.00 14,007.81 552.15 8,940.04 61.96 CAPITAL OUTLAY 3210-54-2301 Furniture & Fixtures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-54-2501 911 Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEPRECIATION/AMORTIZATIO 3210-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 84,303.00 5,738.65 0.00 54,234.03 552.15 29,516.82 64.99 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 215-Emergency 911 Fund Other Financing Uses % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER FINANCING USES 9000-61-1002 Transfer Out 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING USES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Other Financing Uses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 FUND TOTAL EXPENDITURES 84,303.00 5,738.65 0.00 54,234.03 552.15 29,516.82 64.99 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 275-Hotel / Motel Tax Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- TAXES 00-31.4100 Hotel / Motel Tax 2,000,000.00 38,484.84 0.00 1,107,056.53 0.00 892,943.47 55.35 00-31.9900 Late Charges 50,000.00 133.72 0.00 11,411.22 0.00 38,588.78 22.82 TOTAL TAXES 2,050,000.00 38,618.56 0.00 1,118,467.75 0.00 931,532.25 54.56 *** TOTAL REVENUES *** 2,050,000.00 38,618.56 0.00 1,118,467.75 0.00 931,532.25 54.56 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 275-Hotel / Motel Tax Fund Community Development % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 7520-57-2000 Hutchison Island Tax 341,735.00 4,450.02 0.00 178,588.49 0.00 163,146.51 52.26 7520-57-2001 Chamber - Hotel/Motel fun 683,265.00 8,897.37 0.00 357,069.83 0.00 326,195.17 52.26 TOTAL OTHER COSTS 1,025,000.00 13,347.39 0.00 535,658.32 0.00 489,341.68 52.26 OTHER FINANCING USES 7520-61-1000 H/M Transfer Out 1,025,000.00 19,309.28 0.00 555,429.10 0.00 469,570.90 54.19 TOTAL OTHER FINANCING USES 1,025,000.00 19,309.28 0.00 555,429.10 0.00 469,570.90 54.19 _________________________________________________________________________________________________________________________________ TOTAL Community Development 2,050,000.00 32,656.67 0.00 1,091,087.42 0.00 958,912.58 53.22 FUND TOTAL EXPENDITURES 2,050,000.00 32,656.67 0.00 1,091,087.42 0.00 958,912.58 53.22 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- INTERGOVERNMENTAL 00-33.7101 Drainage Improvements 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.7102 SPLOST Revenue 2008 3,007,828.00 136,875.21 0.00 757,598.77 0.00 2,250,229.23 25.19 00-33.7103 Other Cap Proj Public Safet 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.7104 Greenspace, Bikeways 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.7105 Water / Sewer Projects 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.7106 2003 Other Cap Improvement 667,772.00 0.00 0.00 0.00 0.00 667,772.00 0.00 TOTAL INTERGOVERNMENTAL 3,675,600.00 136,875.21 0.00 757,598.77 0.00 2,918,001.23 20.61 CHARGES FOR SERVICES 00-34.1000 Transfer In 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CHARGES FOR SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 INVESTMENT INCOME 00-36.1000 Interest 0.00 202.83 0.00 1,556.36 0.00 ( 1,556.36) 0.00 TOTAL INVESTMENT INCOME 0.00 202.83 0.00 1,556.36 0.00 ( 1,556.36) 0.00 OTHER FINANCING SOURCES 00-39.1300 Reserve/Prior Year Fund Bal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3000 Other Financing Sources 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 *** TOTAL REVENUES *** 3,675,600.00 137,078.04 0.00 759,155.13 0.00 2,916,444.87 20.65 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Police Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 3210-54-1301 Police Software Upgrade 118,800.00 0.00 0.00 0.00 0.00 118,800.00 0.00 3210-54-1310 Capital Police Building 2,369,746.00 0.00 0.00 11,918.00 0.00 2,357,828.00 0.50 TOTAL CAPITAL OUTLAY 2,488,546.00 0.00 0.00 11,918.00 0.00 2,476,628.00 0.48 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 2,488,546.00 0.00 0.00 11,918.00 0.00 2,476,628.00 0.48 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Fire Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 3510-54-1150 Fire Dept Equipment 35,000.00 0.00 0.00 0.00 0.00 35,000.00 0.00 TOTAL CAPITAL OUTLAY 35,000.00 0.00 0.00 0.00 0.00 35,000.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Fire Administration 35,000.00 0.00 0.00 0.00 0.00 35,000.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Public Works % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 4210-54-1400 Infrastucture 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-54-1401 Bike Path Costs 16,000.00 0.00 0.00 13,957.44 0.00 2,042.56 87.23 TOTAL CAPITAL OUTLAY 16,000.00 0.00 0.00 13,957.44 0.00 2,042.56 87.23 _________________________________________________________________________________________________________________________________ TOTAL Public Works 16,000.00 0.00 0.00 13,957.44 0.00 2,042.56 87.23 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Storm Drainage % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 4250-54-1400 Capital Drainage Proj 101,804.00 0.00 0.00 0.00 0.00 101,804.00 0.00 4250-54-1401 Outfalls 6 & 7th St 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4250-54-1403 Drainage Van Horn/Solomon 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 101,804.00 0.00 0.00 0.00 0.00 101,804.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Storm Drainage 101,804.00 0.00 0.00 0.00 0.00 101,804.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Water Supply % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 4420-54-2100 Machinery 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4420-54-2105 Ft Screven Water Sys Upgr 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4420-54-2107 Butler Ave Water Line 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4420-54-2110 Beachside Looping System 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Water Supply 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 7 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Other Capital Outlay % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 4970-54-1001 Capital Other 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4970-54-2500 TE Grant City Share 71,250.00 1,669.50 0.00 24,334.84 28,939.31 17,975.85 74.77 TOTAL CAPITAL OUTLAY 71,250.00 1,669.50 0.00 24,334.84 28,939.31 17,975.85 74.77 _________________________________________________________________________________________________________________________________ TOTAL Other Capital Outlay 71,250.00 1,669.50 0.00 24,334.84 28,939.31 17,975.85 74.77 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 8 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Cultural & Recreation % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 6110-54-1414 Old Fort Theater 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6110-54-2501 Playground Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Cultural & Recreation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 9 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Lifeguards % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 6124-54-1401 Planning-Consult-Studies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Lifeguards 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 10 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Beach Related % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 6125-54-1400 Beach Crossovers 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6125-54-1402 Beach Renourishment 300,000.00 0.00 0.00 0.00 0.00 300,000.00 0.00 6125-54-1406 North Beach Projects 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 300,000.00 0.00 0.00 0.00 0.00 300,000.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Beach Related 300,000.00 0.00 0.00 0.00 0.00 300,000.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 11 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Museums % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 6172-57-2000 Lighthouse Renovations 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6172-57-2001 Marine Science Center 600,000.00 0.00 0.00 34,378.48 3,000.00 562,621.52 6.23 TOTAL OTHER COSTS 600,000.00 0.00 0.00 34,378.48 3,000.00 562,621.52 6.23 _________________________________________________________________________________________________________________________________ TOTAL Museums 600,000.00 0.00 0.00 34,378.48 3,000.00 562,621.52 6.23 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 12 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Recreation Facilities % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 6190-54-1410 Community Center/Guardhou 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6190-54-1412 Skate Park 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6190-54-1414 Marine Rescue ADA Access 26,500.00 0.00 0.00 0.00 0.00 26,500.00 0.00 TOTAL CAPITAL OUTLAY 26,500.00 0.00 0.00 0.00 0.00 26,500.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Recreation Facilities 26,500.00 0.00 0.00 0.00 0.00 26,500.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 13 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Zoning and Inspection % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 7220-54-2150 GIS 6,500.00 0.00 0.00 0.00 0.00 6,500.00 0.00 TOTAL CAPITAL OUTLAY 6,500.00 0.00 0.00 0.00 0.00 6,500.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Zoning and Inspection 6,500.00 0.00 0.00 0.00 0.00 6,500.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 14 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Community Development % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 7520-54-1405 So Beach Business Distric 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7520-54-1406 Salt Meadows Road Project 30,000.00 0.00 0.00 13,504.03 0.00 16,495.97 45.01 TOTAL CAPITAL OUTLAY 30,000.00 0.00 0.00 13,504.03 0.00 16,495.97 45.01 _________________________________________________________________________________________________________________________________ TOTAL Community Development 30,000.00 0.00 0.00 13,504.03 0.00 16,495.97 45.01 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 15 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Debt Service % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 8000-52-1000 Transfer Out 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 8000-58-1300 Advance Principal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8000-58-2300 Interest/CHATHAM COUNTY A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Debt Service 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 16 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 320-SPLOST Fund Other Financing Uses % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER FINANCING USES 9000-61-1000 Contingency Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING USES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Other Financing Uses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 FUND TOTAL EXPENDITURES 3,675,600.00 1,669.50 0.00 98,092.79 31,939.31 3,545,567.90 3.54 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- INTERGOVERNMENTAL 00-33.1001 TE/Butler 0.00 90,763.68 0.00 90,763.68 0.00 ( 90,763.68) 0.00 00-33.1002 LWCF Trails Grant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.1003 GEFA EECBG 0.00 0.00 0.00 35,854.73 0.00 ( 35,854.73) 0.00 00-33.1004 ElPaso Boat Grant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.1005 Police Grants 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.1009 Misc Donations 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-33.1010 Coastal Incentive Grant 1,080.53 0.00 0.00 1,080.44 0.00 0.09 99.99 00-33.1011 Gov Hwy Safety Grant Revenu 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INTERGOVERNMENTAL 1,080.53 90,763.68 0.00 127,698.85 0.00 ( 126,618.32) 818.17 OTHER FINANCING SOURCES 00-39.1100 Transfer In 0.00 0.00 0.00 ( 15,952.51) 0.00 15,952.51 0.00 TOTAL OTHER FINANCING SOURCES 0.00 0.00 0.00 ( 15,952.51) 0.00 15,952.51 0.00 *** TOTAL REVENUES *** 1,080.53 90,763.68 0.00 111,746.34 0.00 ( 110,665.81) 341.81 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Finance % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 1510-57-3001 Educational Tours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-57-3002 Snow Fence 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-57-3003 EcoSystem Tours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-57-3005 Park of 7 Flags 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1510-57-3006 Recreational Study 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Finance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Grant 2011 % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 2011-57-1002 LWCF Trails 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Grant 2011 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Police Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SUPPLIES 3210-53-1011 Gov Hwy Safety Grant Expe 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-53-1601 Police Safety Equip 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3210-53-1602 El Paso Grant 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Public Works % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- DEPRECIATION/AMORTIZATIO 4210-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4210-56-1001 GEFA EECBG Retrofit 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Public Works 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Other Capital Outlay % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CAPITAL OUTLAY 4970-54-2500 TE Grant Hwy 80 Trail 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4970-54-2505 TE Historic Butler Ave Pe 0.00 119,275.82 0.00 119,275.82 0.00 ( 119,275.82) 0.00 TOTAL CAPITAL OUTLAY 0.00 119,275.82 0.00 119,275.82 0.00 ( 119,275.82) 0.00 _________________________________________________________________________________________________________________________________ TOTAL Other Capital Outlay 0.00 119,275.82 0.00 119,275.82 0.00 ( 119,275.82) 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 7 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Cultural & Recreation % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- DEPRECIATION/AMORTIZATIO 6110-56-1000 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Cultural & Recreation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 8 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Beach Related % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 6125-57-3004 Beach Renourishment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Beach Related 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 9 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 340-Grant Fund Better Hometown % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 7300-52-1010 Coastal Incentive Expense 1,080.53 0.00 0.00 1,078.96 0.00 1.57 99.85 TOTAL SERVICES 1,080.53 0.00 0.00 1,078.96 0.00 1.57 99.85 _________________________________________________________________________________________________________________________________ TOTAL Better Hometown 1,080.53 0.00 0.00 1,078.96 0.00 1.57 99.85 FUND TOTAL EXPENDITURES 1,080.53 119,275.82 0.00 120,354.78 0.00 ( 119,274.25) 138.49 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 505-Water-Sewer Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CHARGES FOR SERVICES 00-34.2900 Water Sewer Cost Reimbursem 0.00 0.00 0.00 642.03 0.00 ( 642.03) 0.00 00-34.4210 Water charges 1,150,000.00 59,201.18 0.00 679,221.36 0.00 470,778.64 59.06 00-34.4215 Capital Cost Recovery 15,000.00 0.00 0.00 8,000.00 0.00 7,000.00 53.33 00-34.4255 Sewer charges 1,350,000.00 93,741.41 0.00 912,879.17 0.00 437,120.83 67.62 00-34.6901 Other fees - tapping fees 5,000.00 0.00 0.00 3,216.80 0.00 1,783.20 64.34 00-34.6902 Other fees - stubbing fees 3,000.00 0.00 0.00 3,018.40 0.00 ( 18.40) 100.61 00-34.6903 Aid to Construction 20,000.00 0.00 0.00 17,801.00 0.00 2,199.00 89.01 00-34.6904 Delinquent Charges 50,000.00 2,655.00 0.00 26,700.00 0.00 23,300.00 53.40 00-34.6905 Other fees Chatham contrct 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.6906 Other Fees - Cuts, Transfer 8,000.00 455.00 0.00 5,040.00 0.00 2,960.00 63.00 TOTAL CHARGES FOR SERVICES 2,601,000.00 156,052.59 0.00 1,656,518.76 0.00 944,481.24 63.69 INVESTMENT INCOME 00-36.1000 Interest 18,000.00 1.46 0.00 25,229.27 0.00 ( 7,229.27) 140.16 TOTAL INVESTMENT INCOME 18,000.00 1.46 0.00 25,229.27 0.00 ( 7,229.27) 140.16 MISCELLANEOUS 00-38.1002 Tower Space Rental Revenue 120,000.00 11,211.59 0.00 121,349.73 0.00 ( 1,349.73) 101.12 00-38.9001 W/S Settlement 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-38.9002 W/S Misc Other Income 5,000.00 0.00 0.00 3,892.35 0.00 1,107.65 77.85 00-38.9003 Service CHG RET'D checks 400.00 32.00 0.00 323.00 0.00 77.00 80.75 TOTAL MISCELLANEOUS 125,400.00 11,243.59 0.00 125,565.08 0.00 ( 165.08) 100.13 OTHER FINANCING SOURCES 00-39.1000 Capital Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.1201 Transfer In 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.1300 Prior Year Fund Balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.2100 Sales of Assets 38,000.00 0.00 0.00 39,948.39 0.00 ( 1,948.39) 105.13 00-39.3000 Proceeds from Long Term Lia 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3501 Proceeds from GMA Leases 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3502 Proceeds from Gen Fund Note 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 38,000.00 0.00 0.00 39,948.39 0.00 ( 1,948.39) 105.13 *** TOTAL REVENUES *** 2,782,400.00 167,297.64 0.00 1,847,261.50 0.00 935,138.50 66.39 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 505-Water-Sewer Fund Sewer Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 4310-51-1100 Salaries & Wages 166,548.00 11,463.24 0.00 120,783.55 0.00 45,764.45 72.52 4310-51-1300 Overtime Wages 12,000.00 490.38 0.00 4,429.28 0.00 7,570.72 36.91 4310-51-1400 Employee Benefits 3,000.00 187.50 0.00 1,812.50 0.00 1,187.50 60.42 4310-51-2100 Health Insurance Benefits 37,593.00 2,972.34 0.00 26,874.51 0.00 10,718.49 71.49 4310-51-2200 FICA Contributions 11,101.00 747.97 0.00 7,830.26 0.00 3,270.74 70.54 4310-51-2300 FICA Medicare Contributio 2,596.00 174.91 0.00 1,831.22 0.00 764.78 70.54 4310-51-2400 Retirement Contributions 11,522.00 960.14 0.00 8,641.26 0.00 2,880.74 75.00 4310-51-2700 Workers Compensation 3,223.00 0.00 0.00 5,599.65 0.00 ( 2,376.65) 173.74 4310-51-2900 Wellness Benefits 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL PERSONNEL 247,583.00 16,996.48 0.00 177,802.23 0.00 69,780.77 71.82 SERVICES 4310-52-1200 Legal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-1201 Engineering/permits 30,000.00 0.00 0.00 13,000.00 2,200.00 14,800.00 50.67 4310-52-1202 Engineering/studies 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 4310-52-1230 Medical Screening 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-1310 Water Analysis 25,000.00 1,767.29 0.00 10,405.19 5,759.91 8,834.90 64.66 4310-52-2110 Dumping Charges 25,000.00 987.10 0.00 15,347.28 6,488.10 3,164.62 87.34 4310-52-2200 Termite/ Pest control WW 500.00 0.00 0.00 0.00 0.00 500.00 0.00 4310-52-2201 Repair & Maintain - Bldgs 5,000.00 259.00 0.00 2,233.29 0.00 2,766.71 44.67 4310-52-2202 Repair & Maintain - Vehic 4,000.00 0.00 0.00 1,625.40 0.00 2,374.60 40.64 4310-52-2203 Repair & Maintain - Equip 82,000.00 7,880.43 0.00 53,876.54 4,919.00 23,204.46 71.70 4310-52-2205 Repair & Maint -Infrastru 35,000.00 1,800.00 0.00 24,323.84 3,030.69 7,645.47 78.16 4310-52-2320 Rental Equipment 21,000.00 0.00 0.00 17,379.95 0.00 3,620.05 82.76 4310-52-3100 Property & Liability Ins 48,798.36 0.00 0.00 50,901.50 0.00 ( 2,103.14) 104.31 4310-52-3201 Telephones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-3202 Fax/Data Lines 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-3220 Postage & Freight 15,000.00 661.37 0.00 5,503.10 3,344.89 6,152.01 58.99 4310-52-3300 Advertising 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-3400 Printing & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-3500 Travel & Related Expense 2,000.00 0.00 0.00 0.00 0.00 2,000.00 0.00 4310-52-3600 Dues & Fees 1,500.00 0.00 0.00 975.67 0.00 524.33 65.04 4310-52-3700 Education & Training 4,000.00 150.00 0.00 1,202.00 0.00 2,798.00 30.05 4310-52-3850 Contract Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-52-3901 Credit Card Collection Ch 2,000.00 0.00 0.00 513.76 0.00 1,486.24 25.69 TOTAL SERVICES 305,798.36 13,505.19 0.00 197,287.52 25,742.59 82,768.25 72.93 SUPPLIES 4310-53-1100 Supplies & Materials 50,000.00 3,874.69 0.00 35,415.89 1,222.56 13,361.55 73.28 4310-53-1210 Water & Sewer Services 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-53-1230 Electricity 150,000.00 8,512.10 0.00 88,983.74 0.00 61,016.26 59.32 4310-53-1270 Gasoline & Diesel Fuel 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-53-1400 Books & Periodicals 500.00 0.00 0.00 0.00 0.00 500.00 0.00 4310-53-1600 Small Equipment 12,000.00 932.95 0.00 11,525.37 0.00 474.63 96.04 4310-53-1720 Uniforms 4,000.00 97.80 0.00 884.53 615.47 2,500.00 37.50 4310-53-1730 Ultraviolet Disinfection 15,000.00 0.00 0.00 4,296.34 3,194.00 7,509.66 49.94 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 505-Water-Sewer Fund Sewer Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 4310-53-1740 Sludge Belt Press Parts 5,000.00 0.00 0.00 3,113.44 0.00 1,886.56 62.27 TOTAL SUPPLIES 236,500.00 13,417.54 0.00 144,219.31 5,032.03 87,248.66 63.11 CAPITAL OUTLAY 4310-54-1401 Sewer Line Rehab & Improv 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-1402 Rehab Lift Station #7 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-1403 Rehab Lift Station #9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-1404 Sewer Lift Station #11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-1405 Hwy 80 Water Sewer Projec 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-1406 Lift Station #6 Improveme 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-1407 Waste Water Treatment Pla 147,700.00 0.00 0.00 136,266.00 0.00 11,434.00 92.26 4310-54-1408 Rehab Lift Station #10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-54-2100 Machinery & Equipment 35,000.00 0.00 0.00 264,259.75 0.00 ( 229,259.75) 755.03 4310-54-2501 Capital Equipment 28,749.00 0.00 0.00 10,812.67 0.00 17,936.33 37.61 TOTAL CAPITAL OUTLAY 211,449.00 0.00 0.00 411,338.42 0.00 ( 199,889.42) 194.53 INTERFUND/INTERDEPARTMENT 4310-55-1100 Administrative Svcs - Gen 79,200.00 6,600.00 0.00 59,400.00 0.00 19,800.00 75.00 TOTAL INTERFUND/INTERDEPARTMENT 79,200.00 6,600.00 0.00 59,400.00 0.00 19,800.00 75.00 DEPRECIATION/AMORTIZATIO 4310-56-1000 Depreciation 240,000.00 24,934.59 0.00 200,010.43 0.00 39,989.57 83.34 TOTAL DEPRECIATION/AMORTIZATIO 240,000.00 24,934.59 0.00 200,010.43 0.00 39,989.57 83.34 DEBT SERVICE 4310-58-1201 Prin CW00014P 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-58-1202 Gen Fund Note - Principal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-58-2201 GMA Leases - Interest Exp 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-58-2202 Gen Fund Note - Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4310-58-2301 Int Exp Loan GEFA CW00014 53,397.19 4,030.27 0.00 21,770.83 0.00 31,626.36 40.77 TOTAL DEBT SERVICE 53,397.19 4,030.27 0.00 21,770.83 0.00 31,626.36 40.77 _________________________________________________________________________________________________________________________________ TOTAL Sewer Administration 1,373,927.55 79,484.07 0.00 1,211,828.74 30,774.62 131,324.19 90.44 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 505-Water-Sewer Fund Water Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 4410-51-1100 Salaries & Wages 161,835.00 12,090.58 0.00 115,191.93 0.00 46,643.07 71.18 4410-51-1300 Overtime 12,000.00 777.20 0.00 8,180.50 0.00 3,819.50 68.17 4410-51-1400 Employee Benefits 3,000.00 187.50 0.00 1,500.00 0.00 1,500.00 50.00 4410-51-2100 Health Insurance Benefits 26,049.00 2,307.99 0.00 16,767.11 0.00 9,281.89 64.37 4410-51-2200 Social Security Contribut 10,778.00 801.32 0.00 7,665.08 0.00 3,112.92 71.12 4410-51-2300 FICA Medicare Contributio 2,521.00 187.40 0.00 1,792.62 0.00 728.38 71.11 4410-51-2400 Retirement Contributions 25,182.00 2,140.52 0.00 19,264.68 0.00 5,917.32 76.50 4410-51-2600 Unemployment Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-51-2700 Workers Compensation 11,769.00 0.00 0.00 11,768.55 0.00 0.45 100.00 4410-51-2900 Wellness Benefit Program 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL PERSONNEL 253,134.00 18,492.51 0.00 182,130.47 0.00 71,003.53 71.95 SERVICES 4410-52-1200 Legal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-1201 Engineering/permits 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 4410-52-1202 Engineering/studies servi 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-1230 Medical Screening 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-1300 Computer Svc Contracts 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-1310 Water Analysis 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 4410-52-2201 Repair & Maintain - Build 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-2202 Repair & Maintain - Vehic 5,000.00 375.21 0.00 2,230.94 262.56 2,506.50 49.87 4410-52-2203 Repair & Maintain - Equip 35,000.00 3,595.18 0.00 15,788.86 0.00 19,211.14 45.11 4410-52-2205 Repair & Maint- Infrastru 85,000.00 1,901.54 0.00 59,754.46 0.00 25,245.54 70.30 4410-52-2320 Rental of Equip & Vehicle 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3100 Property & Liability Insu 3,363.87 0.00 0.00 3,969.29 0.00 ( 605.42) 118.00 4410-52-3201 Telephone 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3202 Data & Fax Lines 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3203 Cell Phones 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3204 Pagers & Beepers 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3220 Postage & Freight 12,000.00 1,009.21 0.00 6,456.01 3,705.58 1,838.41 84.68 4410-52-3300 Advertising 5,000.00 0.00 0.00 0.00 40.00 4,960.00 0.80 4410-52-3330 Legal Notices 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3400 Printing & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3500 Travel & Related Expenses 2,000.00 0.00 0.00 138.17 0.00 1,861.83 6.91 4410-52-3600 Dues & Fees 10,000.00 0.00 0.00 424.17 0.00 9,575.83 4.24 4410-52-3700 Education & Training 2,000.00 50.00 0.00 500.00 0.00 1,500.00 25.00 4410-52-3850 Contract Labor 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-52-3901 Credit Card Svc. Charges 5,000.00 428.43 0.00 3,852.79 0.00 1,147.21 77.06 4410-52-3950 Water Conservation Measur 8,000.00 0.00 0.00 1,634.51 0.00 6,365.49 20.43 TOTAL SERVICES 182,363.87 7,359.57 0.00 94,749.20 4,008.14 83,606.53 54.15 SUPPLIES 4410-53-1100 Supplies & Materials 30,000.00 1,902.85 0.00 15,809.57 235.00 13,955.43 53.48 4410-53-1102 Fire hydrants, gates, val 4,500.00 0.00 0.00 265.72 0.00 4,234.28 5.90 4410-53-1210 Water/Sewer Charges 43,000.00 2,730.83 0.00 33,253.74 0.00 9,746.26 77.33 4410-53-1230 Electricity 30,000.00 2,721.29 0.00 25,415.14 0.00 4,584.86 84.72 4410-53-1270 Gasoline & Diesel Fuel 15,000.00 1,688.69 0.00 12,503.43 0.00 2,496.57 83.36 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 505-Water-Sewer Fund Water Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 4410-53-1400 Books & Periodicals 500.00 0.00 0.00 0.00 0.00 500.00 0.00 4410-53-1560 Inventory - Water Meters& 50,000.00 9,273.40 0.00 46,299.18 0.00 3,700.82 92.60 4410-53-1592 Sprinkler meters-repurcha 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-53-1600 Small equipment 5,000.00 609.53 0.00 4,020.59 0.00 979.41 80.41 4410-53-1702 Cash - Long / Short 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-53-1720 Uniform /Clothing 5,500.00 134.05 0.00 1,826.06 333.03 3,340.91 39.26 TOTAL SUPPLIES 183,500.00 19,060.64 0.00 139,393.43 568.03 43,538.54 76.27 CAPITAL OUTLAY 4410-54-1201 Site Improvement 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-54-2100 Machinery & Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-54-2105 GEFA Ft. Screven Water L 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-54-2107 Butler Avenue Water Line 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-54-2400 Computer Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-54-2500 Capital outlay - water we 55,000.00 0.00 0.00 53,550.00 0.00 1,450.00 97.36 4410-54-2501 Control Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 55,000.00 0.00 0.00 53,550.00 0.00 1,450.00 97.36 INTERFUND/INTERDEPARTMENT 4410-55-1100 Admin Service - General F 79,200.00 6,600.00 0.00 59,400.00 0.00 19,800.00 75.00 TOTAL INTERFUND/INTERDEPARTMENT 79,200.00 6,600.00 0.00 59,400.00 0.00 19,800.00 75.00 DEPRECIATION/AMORTIZATIO 4410-56-1000 Depreciation 280,000.00 0.00 0.00 0.00 0.00 280,000.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 280,000.00 0.00 0.00 0.00 0.00 280,000.00 0.00 OTHER COSTS 4410-57-4000 Bad debt 21,000.00 0.00 0.00 0.00 0.00 21,000.00 0.00 4410-57-4001 Other Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 21,000.00 0.00 0.00 0.00 0.00 21,000.00 0.00 DEBT SERVICE 4410-58-1201 Prin L22WS 2005 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-58-1202 Prin 005 AMR 2009 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-58-1203 Prin 006 Grit Sep 2009 148,871.17 0.00 0.00 0.00 0.00 148,871.17 0.00 4410-58-1204 Prin WS Bond 2005 456881 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-58-1205 Prin L48WS 2007 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4410-58-2100 Int Exp Rev Bond 2005 456 22,320.00 0.00 0.00 7,641.50 0.00 14,678.50 34.24 4410-58-2200 Int Exp BBT Loan AMR 2009 4,529.96 0.00 0.00 3,769.70 0.00 760.26 83.22 4410-58-2201 Int Exp 006 Loan Grit Sep 6,430.35 0.00 0.00 5,253.46 0.00 1,176.89 81.70 4410-58-2203 Bond Amortization Costs 14,400.00 0.00 0.00 0.00 0.00 14,400.00 0.00 4410-58-2205 Int Exp GELAC Loan L48WS 39,758.20 3,033.31 0.00 29,934.58 0.00 9,823.62 75.29 4410-58-2300 Int Exp GEFA Loan L22WS 2 53,255.71 4,385.88 0.00 40,224.72 0.00 13,030.99 75.53 4410-58-3000 Bond Admin Cost 1,700.00 0.00 0.00 625.00 0.00 1,075.00 36.76 TOTAL DEBT SERVICE 291,265.39 7,419.19 0.00 87,448.96 0.00 203,816.43 30.02 _________________________________________________________________________________________________________________________________ TOTAL Water Administration 1,345,463.26 58,931.91 0.00 616,672.06 4,576.17 724,215.03 46.17 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 505-Water-Sewer Fund Other Financing Uses % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER COSTS 9000-57-4000 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER FINANCING USES 9000-61-1000 Contingency 63,009.19 0.00 0.00 0.00 0.00 63,009.19 0.00 TOTAL OTHER FINANCING USES 63,009.19 0.00 0.00 0.00 0.00 63,009.19 0.00 _________________________________________________________________________________________________________________________________ TOTAL Other Financing Uses 63,009.19 0.00 0.00 0.00 0.00 63,009.19 0.00 FUND TOTAL EXPENDITURES 2,782,400.00 138,415.98 0.00 1,828,500.80 35,350.79 918,548.41 66.99 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 540-Solid Waste Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CHARGES FOR SERVICES 00-34.4110 Solid Waste Collection Chrg 437,900.00 40,277.14 0.00 325,475.75 0.00 112,424.25 74.33 00-34.4120 Recycling Program Charges 90,000.00 7,475.72 0.00 67,450.79 0.00 22,549.21 74.95 00-34.4130 Recycled Materials Revenue 10,000.00 1,494.30 0.00 4,569.39 0.00 5,430.61 45.69 00-34.4131 Other Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.4132 Garbage Surcharge 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CHARGES FOR SERVICES 537,900.00 49,247.16 0.00 397,495.93 0.00 140,404.07 73.90 OTHER FINANCING SOURCES 00-39.1201 Transfers In 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-39.3502 Transfer in Gen Fund 60,785.00 0.00 0.00 0.00 0.00 60,785.00 0.00 TOTAL OTHER FINANCING SOURCES 60,785.00 0.00 0.00 0.00 0.00 60,785.00 0.00 *** TOTAL REVENUES *** 598,685.00 49,247.16 0.00 397,495.93 0.00 201,189.07 66.39 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 540-Solid Waste Fund Solid Waste Collection % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 4520-52-1221 Audit & Accounting Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4520-52-2110 Tipping Fees, Dump Charge 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4520-52-2111 Residential Pick Up- Wast 479,000.00 47,066.97 0.00 381,044.14 0.00 97,955.86 79.55 4520-52-2112 Compactors 18,785.60 0.00 0.00 12,785.60 0.00 6,000.00 68.06 4520-52-2113 Republic Services- Compac 49,000.00 6,067.27 0.00 44,117.85 0.00 4,882.15 90.04 TOTAL SERVICES 546,785.60 53,134.24 0.00 437,947.59 0.00 108,838.01 80.09 CAPITAL OUTLAY 4520-54-2100 Machinery & Equipment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 INTERFUND/INTERDEPARTMENT 4520-55-1100 Admin Svc Fees to Gen Fun 9,900.00 825.00 0.00 7,425.00 0.00 2,475.00 75.00 TOTAL INTERFUND/INTERDEPARTMENT 9,900.00 825.00 0.00 7,425.00 0.00 2,475.00 75.00 OTHER COSTS 4520-57-4000 Bad Debts 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 4520-58-1202 Gen Fund Note - Principal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4520-58-2202 Gen Fund Note - Interest 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Solid Waste Collection 556,685.60 53,959.24 0.00 445,372.59 0.00 111,313.01 80.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 540-Solid Waste Fund Recyclables Collection % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 4540-52-2110 Recycling Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Recyclables Collection 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 540-Solid Waste Fund Other Financing Uses % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- OTHER FINANCING USES 9000-61-1000 Contingency Fund 41,999.40 0.00 0.00 0.00 0.00 41,999.40 0.00 TOTAL OTHER FINANCING USES 41,999.40 0.00 0.00 0.00 0.00 41,999.40 0.00 _________________________________________________________________________________________________________________________________ TOTAL Other Financing Uses 41,999.40 0.00 0.00 0.00 0.00 41,999.40 0.00 FUND TOTAL EXPENDITURES 598,685.00 53,959.24 0.00 445,372.59 0.00 153,312.41 74.39 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 555-Rivers End RV Pk & Campgr REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CHARGES FOR SERVICES 00-34.7520 Camping Fees 595,000.00 0.00 0.00 338,026.09 0.00 256,973.91 56.81 00-34.7521 Camp Tent Site 50,000.00 0.00 0.00 25,378.72 0.00 24,621.28 50.76 00-34.7522 Cabin Rental Taxable (13%) 110,000.00 0.00 0.00 59,135.77 0.00 50,864.23 53.76 00-34.7523 Cabin All Taxes Exempt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.7524 Cabin GA Sales Tax Exempt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00-34.7525 Camp Site Reservations 175,000.00 0.00 0.00 106,726.17 0.00 68,273.83 60.99 00-34.7527 Ice Revenues 7,550.00 0.00 0.00 3,320.45 0.00 4,229.55 43.98 00-34.7528 Propane Revenues 18,000.00 0.00 0.00 12,215.86 0.00 5,784.14 67.87 00-34.7529 RV Supplies Revenue 8,800.00 0.00 0.00 4,276.80 0.00 4,523.20 48.60 00-34.7530 Store Revenue 52,000.00 0.00 0.00 20,477.12 0.00 31,522.88 39.38 00-34.7531 Electricity Fees 1,750.00 0.00 0.00 2,034.36 0.00 ( 284.36) 116.25 00-34.7532 Vending Machine Revenue 5,000.00 0.00 0.00 3,985.15 0.00 1,014.85 79.70 00-34.7533 Trolley Ticket Revenue 125.00 0.00 0.00 52.00 0.00 73.00 41.60 00-34.7534 Miscellaneous Revenue 4,000.00 0.00 0.00 2,279.43 0.00 1,720.57 56.99 00-34.7535 Other Revenues In House Eve 550.00 0.00 0.00 225.00 0.00 325.00 40.91 00-34.7536 Cabin Reservations 0.00 0.00 0.00 4,597.96 0.00 ( 4,597.96) 0.00 00-34.7537 Cabin Damage Deposit 100.00 0.00 0.00 25.00 0.00 75.00 25.00 00-34.7538 Campground Sales- Parking P 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CHARGES FOR SERVICES 1,027,875.00 0.00 0.00 582,755.88 0.00 445,119.12 56.70 OTHER FINANCING SOURCES 00-39.1201 Transfers from Other Funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 *** TOTAL REVENUES *** 1,027,875.00 0.00 0.00 582,755.88 0.00 445,119.12 56.70 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 555-Rivers End RV Pk & Campgr River's End RV Park % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- PERSONNEL 6180-51-1100 Salaries & Wages 194,536.91 18,441.37 0.00 130,205.04 0.00 64,331.87 66.93 6180-51-1200 Part Time/Seasonal Wages 35,837.09 1,227.84 0.00 25,908.37 0.00 9,928.72 72.29 6180-51-1300 Overtime 6,000.00 441.68 0.00 3,463.35 0.00 2,536.65 57.72 6180-51-1400 Employee Benefits 1,500.00 125.00 0.00 1,125.00 0.00 375.00 75.00 6180-51-2100 Health Insurance Benefits 33,482.00 2,613.15 0.00 18,336.61 227.69 14,917.70 55.45 6180-51-2200 Social Security Contribut 14,953.00 1,242.97 0.00 9,911.28 0.00 5,041.72 66.28 6180-51-2300 Medicare Contributions 3,497.00 290.71 0.00 2,318.07 0.00 1,178.93 66.29 6180-51-2400 Retirement Contributions 25,372.00 2,114.27 0.00 19,028.43 0.00 6,343.57 75.00 6180-51-2600 Unemployment Ins 3,300.00 0.00 0.00 3,300.00 0.00 0.00 100.00 6180-51-2700 Workers Compensation 3,895.57 0.00 0.00 3,895.57 0.00 0.00 100.00 TOTAL PERSONNEL 322,373.57 26,496.99 0.00 217,491.72 227.69 104,654.16 67.54 SERVICES 6180-52-2110 Garbage Service 6,408.00 540.00 0.00 3,780.00 0.00 2,628.00 58.99 6180-52-2130 Custodial Services 1,320.00 0.00 0.00 0.00 0.00 1,320.00 0.00 6180-52-2135 Pool Cleaning Service 3,600.00 300.00 0.00 2,700.00 0.00 900.00 75.00 6180-52-2200 Pest Control 2,869.00 458.00 0.00 2,411.00 458.00 0.00 100.00 6180-52-2201 Repair & Maint - Equipme( 1,793.46) 0.00 0.00 ( 1,793.46) 154.76 ( 154.76) 91.37 6180-52-2202 Repair & Maintain - Vehic 488.84 539.94 0.00 488.84 0.00 0.00 100.00 6180-52-2203 Repair & Maintain - Bldgs 13,434.43 3,650.00 0.00 11,685.25 250.00 1,499.18 88.84 6180-52-2205 Repair & Maintain - Infra 22,933.55 0.00 0.00 20,538.55 0.00 2,395.00 89.56 6180-52-3100 Property & Liablility Ins 7,907.76 0.00 0.00 5,930.84 0.00 1,976.92 75.00 6180-52-3202 Cable, Data & Fax Lines 11,500.00 2,008.89 0.00 9,328.43 1,002.21 1,169.36 89.83 6180-52-3220 Postage & Freight 817.83 59.52 0.00 409.28 0.00 408.55 50.04 6180-52-3300 Advertising 55,780.72 1,510.00 0.00 55,780.72 0.00 0.00 100.00 6180-52-3400 Printing & Binding 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-52-3500 Travel & Related 2,767.75 0.00 0.00 2,767.75 0.00 0.00 100.00 6180-52-3600 Dues & Fees 5,552.49 0.00 0.00 5,552.49 0.00 0.00 100.00 6180-52-3700 Education & Training 1,719.00 0.00 0.00 1,719.00 0.00 0.00 100.00 6180-52-3800 Permits, Regulatory Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-52-3850 Contract Labor 9,721.93 658.22 0.00 4,621.93 400.00 4,700.00 51.66 6180-52-3901 Credit Card Charges 19,000.00 1,747.49 0.00 13,253.67 0.00 5,746.33 69.76 6180-52-3950 Lodging Compensation 641.85 641.85 0.00 641.85 0.00 0.00 100.00 TOTAL SERVICES 164,669.69 12,113.91 0.00 139,816.14 2,264.97 22,588.58 86.28 SUPPLIES 6180-53-1100 Supplies & Materials 43,543.00 2,468.52 0.00 39,050.93 843.63 3,648.44 91.62 6180-53-1102 Flags 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-53-1130 Pool Cleaning Supplies 3,225.00 0.00 0.00 2,309.35 0.00 915.65 71.61 6180-53-1210 Water/Sewer Charges 19,962.00 1,116.20 0.00 16,465.72 0.00 3,496.28 82.49 6180-53-1220 Propane 2,130.82 312.62 0.00 1,322.80 176.26 631.76 70.35 6180-53-1230 Electricity 74,832.15 6,083.20 0.00 41,019.36 0.00 33,812.79 54.82 6180-53-1270 Gasoline & Diesel 900.00 174.85 0.00 602.08 0.00 297.92 66.90 6180-53-1520 Propane RV Park-COGS 12,000.00 1,881.27 0.00 6,428.39 1,270.82 4,300.79 64.16 6180-53-1595 Camp Store Groceries-COGS 25,600.00 7,172.07 0.00 21,859.30 1,831.97 1,908.73 92.54 6180-53-1596 Camp Store-RV Supplies CO 12,000.00 77.76 0.00 8,594.64 ( 2,903.26) 6,308.62 47.43 6180-53-1600 Small Equipment 36,049.31 14,618.40 0.00 20,827.71 14,618.40 603.20 98.33 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 555-Rivers End RV Pk & Campgr River's End RV Park % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- 6180-53-1703 Over/Short 0.00 0.00 0.00 ( 4.38) 0.00 4.38 0.00 6180-53-1720 Uniforms 603.05 0.00 0.00 603.05 0.00 0.00 100.00 TOTAL SUPPLIES 230,845.33 33,904.89 0.00 159,078.95 15,837.82 55,928.56 75.77 CAPITAL OUTLAY 6180-54-1100 Capital Improvements 57,278.50 0.00 0.00 27,991.00 18,143.40 11,144.10 80.54 6180-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 57,278.50 0.00 0.00 27,991.00 18,143.40 11,144.10 80.54 DEPRECIATION/AMORTIZATIO 6180-56-1000 Depreciation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-56-2000 Amortization 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL DEPRECIATION/AMORTIZATIO 0.00 0.00 0.00 0.00 0.00 0.00 0.00 DEBT SERVICE 6180-58-1100 Capital Lease Principal P 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6180-58-2100 Int Exp Rev Bond RE 280,815.00 0.00 0.00 280,815.00 0.00 0.00 100.00 6180-58-3000 Custodian Fees & Charges 541.67 0.00 0.00 541.67 0.00 0.00 100.00 6180-58-4000 Issuance Costs Amortizati 6,000.00 541.66 0.00 4,874.94 0.00 1,125.06 81.25 TOTAL DEBT SERVICE 287,356.67 541.66 0.00 286,231.61 0.00 1,125.06 99.61 _________________________________________________________________________________________________________________________________ TOTAL River's End RV Park 1,062,523.76 73,057.45 0.00 830,609.42 36,473.88 195,440.46 81.61 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 555-Rivers End RV Pk & Campgr Debt Service % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 8000-52-1000 Transfer Out 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Debt Service 0.00 0.00 0.00 0.00 0.00 0.00 0.00 FUND TOTAL EXPENDITURES 1,062,523.76 73,057.45 0.00 830,609.42 36,473.88 195,440.46 81.61 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 745-Municipal Court Fund REVENUES % OF YEAR COMPLETED: 75.00 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- FINES & FORFEITURES 00-35.1170 Police Fines Non-city 161,383.79 3,790.07 0.00 88,041.27 0.00 73,342.52 54.55 00-35.1401 Crime Vic Emgcy- Addtl pena 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL FINES & FORFEITURES 161,383.79 3,790.07 0.00 88,041.27 0.00 73,342.52 54.55 INVESTMENT INCOME 00-36.1111 Interest Earnings 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL INVESTMENT INCOME 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER FINANCING SOURCES 00-39.1100 Transfer In 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 *** TOTAL REVENUES *** 161,383.79 3,790.07 0.00 88,041.27 0.00 73,342.52 54.55 ============== ============ ============ ============= ============ ============ ====== 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 745-Municipal Court Fund Municipal Court % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 2650-52-1100 LEGAL - JUDGE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-52-1300 Court Reporter 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-52-3850 Court Apperance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 SUPPLIES 2650-53-1100 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-53-1101 Court Supplies 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 OTHER COSTS 2650-57-1001 Jail Construction Act-Cha 37,033.00 3,376.11 0.00 33,050.33 0.00 3,982.67 89.25 2650-57-1002 Victim Witness LVAP 18,426.00 1,748.90 0.00 16,409.71 0.00 2,016.29 89.06 2650-57-1003 Brain & Spinal BSITF 6,599.00 694.00 0.00 5,412.00 0.00 1,187.00 82.01 2650-57-1004 POAB & GSCCCA Fund 88,234.79 8,485.57 0.00 84,305.58 0.00 3,929.21 95.55 2650-57-1005 PO Drivers Educ. DETF 7,286.00 898.58 0.00 7,428.59 0.00 ( 142.59) 101.96 2650-57-1006 GA Crime Victims- CVEF 1,955.00 206.00 0.00 1,586.00 0.00 369.00 81.13 2650-57-1007 State Probation Fee 1,850.00 187.00 0.00 1,665.00 0.00 185.00 90.00 2650-57-1008 Indigent Defense Fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2650-57-3050 Cash Bond Refund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 161,383.79 15,596.16 0.00 149,857.21 0.00 11,526.58 92.86 OTHER FINANCING USES 2650-61-1100 Transfer Out / Gen'l Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING USES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Municipal Court 161,383.79 15,596.16 0.00 149,857.21 0.00 11,526.58 92.86 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 745-Municipal Court Fund Police Administration % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SUPPLIES 3210-53-1704 Peace Officer A&B Fund 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-15-2013 04:23 PM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: MARCH 31ST, 2013 745-Municipal Court Fund Debt Service % OF YEAR COMPLETED: 75.00 EXPENDITURES CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- SERVICES 8000-52-1000 Transfer Out 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SERVICES 0.00 0.00 0.00 0.00 0.00 0.00 0.00 _________________________________________________________________________________________________________________________________ TOTAL Debt Service 0.00 0.00 0.00 0.00 0.00 0.00 0.00 FUND TOTAL EXPENDITURES 161,383.79 15,596.16 0.00 149,857.21 0.00 11,526.58 92.86 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT ***