Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
8. FEB 2013
4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund REVENUES % OF YEAR COMPLETED: 66.67 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 0.00 0.00 879,788.68 0.00 892,180.32 49.65 00-31.1200 Property Tax Prior Yrs 270,000.00 21,717.28 0.00 ( 5,677.47) 0.00 275,677.47 2.10- 00-31.1310 Motor Vehicle Tax 80,000.00 4,421.15 0.00 39,263.32 0.00 40,736.68 49.08 00-31.1320 Property Tax - Mobile Homes 225.00 19.93 0.00 19.93 0.00 205.07 8.86 00-31.1340 Personal Property - Intangi 22,500.00 2,360.34 0.00 14,519.60 0.00 7,980.40 64.53 00-31.1600 Real Estate Trans Tax 7,000.00 321.68 0.00 4,038.06 0.00 2,961.94 57.69 00-31.1710 Franchise Tax Electric 309,000.00 0.00 0.00 0.00 0.00 309,000.00 0.00 00-31.1750 Franchise Tax - Cable TV 100,000.00 26,472.57 0.00 53,093.45 0.00 46,906.55 53.09 00-31.1760 Franchise Tax Telephone 20,000.00 4,212.97 0.00 8,550.73 0.00 11,449.27 42.75 00-31.3100 Sales & Use Tax Rev (LOS 1,000,000.00 0.00 0.00 451,593.90 0.00 548,406.10 45.16 00-31.4200 Alcohol Bev Excise Tax 175,000.00 9,486.49 0.00 100,446.23 0.00 74,553.77 57.40 00-31.4300 Local 3% Alcohol Tax 75,000.00 3,742.83 0.00 52,973.40 0.00 22,026.60 70.63 00-31.6100 Business-Occupational Tax 61,000.00 6,925.00 0.00 32,900.00 0.00 28,100.00 53.93 00-31.6101 Admin Fees - Business Licen 4,400.00 530.00 0.00 2,630.00 0.00 1,770.00 59.77 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 84.54 0.00 583.23 0.00 916.77 38.88 TOTAL TAXES 4,046,557.00 80,294.78 0.00 1,784,565.18 0.00 2,261,991.82 44.10 LICENSES & PERMITS 00-32.2990 Engineering Review 15,000.00 393.75 0.00 5,162.75 0.00 9,837.25 34.42 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 9,570.00 0.00 42,880.00 0.00 77,120.00 35.73 00-32.3101 Building Permits 70,000.00 9,762.00 0.00 65,053.00 0.00 4,947.00 92.93 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 1,999.00 0.00 14,777.00 0.00 223.00 98.51 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 75.00 0.00 975.00 0.00 275.00 78.00 00-32.3900 Zoning Variance Requests 3,000.00 700.00 0.00 2,025.00 0.00 975.00 67.50 00-32.3901 Recording Fees 4,000.00 0.00 0.00 3,625.00 0.00 375.00 90.63 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 22,499.75 0.00 134,922.75 0.00 104,427.25 56.37 INTERGOVERNMENTAL 00-33.4400 Grant Revenues 28,816.12 0.00 0.00 0.00 0.00 28,816.12 0.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 0.00 0.00 0.00 0.00 28,816.12 0.00 CHARGES FOR SERVICES 00-34.1400 Printing-Duplicating Servic 1,000.00 65.55 0.00 878.21 0.00 121.79 87.82 00-34.1700 Admin Svcs Water/Sewer 158,400.00 13,200.00 0.00 105,600.00 0.00 52,800.00 66.67 00-34.1710 Admin Svcs Sanitation 9,900.00 825.00 0.00 6,600.00 0.00 3,300.00 66.67 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 250.00 0.00 1,150.00 17.86 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 595.00 0.00 9,290.00 0.00 700.00 92.99 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund REVENUES % OF YEAR COMPLETED: 66.67 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,070.45 0.00 43,521.40 0.00 33,978.60 56.16 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 0.00 0.00 0.00 0.00 4,000.00 0.00 00-34.2906 Parking Cost Reimbursement 1,200.00 434.00 0.00 5,883.00 0.00 ( 4,683.00) 490.25 00-34.5415 Parking Revenue Meters 106,377.00 1,327.10 0.00 66,761.09 0.00 39,615.91 62.76 00-34.5416 Parking Rev Decal/Multiday 222,400.00 9,100.00 0.00 104,445.75 0.00 117,954.25 46.96 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 39,775.32 0.00 1,109,236.09 0.00 868,917.91 56.07 00-34.5420 Processing Fee 300.00 45.00 0.00 297.00 0.00 3.00 99.00 00-34.6100 Animal Control-Shelter Fees 100.00 10.00 0.00 20.00 0.00 80.00 20.00 00-34.6410 Background Check Fees 4,000.00 440.00 0.00 2,665.00 0.00 1,335.00 66.63 00-34.6901 Vehicle Impound Fees 500.00 0.00 0.00 135.00 0.00 365.00 27.00 00-34.7500 ATM Transactions 0.00 ( 480.00) 0.00 100.00 ( 100.00) 0.00 0.00 00-34.7501 City Facilities Rentals 37,500.00 3,620.00 0.00 21,730.00 0.00 15,770.00 57.95 00-34.7520 Camping Fees 595,000.00 0.00 0.00 0.00 0.00 595,000.00 0.00 00-34.7521 Camp Tent Site Rentals 50,000.00 0.00 0.00 0.00 0.00 50,000.00 0.00 00-34.7522 Cabin Rental Taxable 110,000.00 0.00 0.00 0.00 0.00 110,000.00 0.00 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 0.00 0.00 175,000.00 0.00 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 0.00 0.00 0.00 0.00 7,550.00 0.00 00-34.7528 Camp Store Propane Revenue 18,000.00 0.00 0.00 0.00 0.00 18,000.00 0.00 00-34.7529 Camp Store RV Supplies 8,800.00 0.00 0.00 0.00 0.00 8,800.00 0.00 00-34.7530 Camp Store General Revenue 52,000.00 0.00 0.00 0.00 0.00 52,000.00 0.00 00-34.7531 Camp Site Electricity Fees 1,750.00 0.00 0.00 0.00 0.00 1,750.00 0.00 00-34.7532 Camp Vending Revenue 5,000.00 0.00 0.00 0.00 0.00 5,000.00 0.00 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 0.00 0.00 0.00 0.00 4,000.00 0.00 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 0.00 0.00 0.00 0.00 0.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 0.00 0.00 64.00 0.00 236.00 21.33 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 74,037.42 0.00 1,479,865.14 ( 100.00) 2,172,530.86 40.52 FINES & FORFEITURES 00-35.1170 Police Fines City Portion 450,000.00 16,936.15 0.00 160,660.21 0.00 289,339.79 35.70 00-35.1172 Information Tech Fees 20,000.00 2,155.00 0.00 22,997.00 0.00 ( 2,997.00) 114.99 00-35.1174 Court Cost 50,000.00 4,182.00 0.00 35,838.39 0.00 14,161.61 71.68 00-35.1175 Fines and Violations - Park 390,000.00 9,045.00 0.00 211,166.50 0.00 178,833.50 54.15 00-35.1176 Late Fees - Parking 40,000.00 1,040.00 0.00 33,131.00 0.00 6,869.00 82.83 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 732.00 0.00 3,009.00 0.00 ( 9.00) 100.30 TOTAL FINES & FORFEITURES 953,000.00 34,090.15 0.00 466,802.10 0.00 486,197.90 48.98 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund REVENUES % OF YEAR COMPLETED: 66.67 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 550.55 0.00 5,042.68 0.00 19,957.32 20.17 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 550.55 0.00 5,042.68 0.00 19,957.32 20.17 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 0.00 0.00 125.00 0.00 875.00 12.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 0.00 0.00 7,195.00 0.00 ( 3,195.00) 179.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 0.00 0.00 956.69 0.00 616.31 60.82 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 0.00 0.00 8,946.00 0.00 6,552.00 57.72 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 28,408.53 0.00 31,259.69 0.00 ( 28,259.69) 41.99 TOTAL MISCELLANEOUS 31,792.67 28,408.53 0.00 45,280.02 0.00 ( 13,487.35) 142.42 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 13,347.40 0.00 536,119.82 0.00 488,880.18 52.30 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 3,562.17 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 16,909.57 0.00 543,548.66 0.00 504,166.61 51.88 *** TOTAL REVENUES *** 10,028,527.06 256,790.75 0.00 4,467,221.53 ( 100.00) 5,561,405.53 44.54 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Mayor and Council % OF YEAR COMPLETED: 66.67 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 14,037.50 0.00 6,362.50 68.81 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.86 0.00 222.15 0.00 123.85 64.21 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 0.00 0.00 37.63 0.00 362.37 9.41 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 169.00 0.00 1,413.59 0.00 636.41 68.96 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 226.46 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 421.20 0.00 1,020.20 0.00 359.80 73.93 1110-52-3507 Council travel - Wolff 1,800.00 583.45 0.00 1,307.47 0.00 492.53 72.64 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 0.00 0.00 0.00 0.00 1,000.00 0.00 1110-52-3703 Education - B Brown 1,350.00 0.00 0.00 435.00 0.00 915.00 32.22 1110-52-3704 Education - T. Groover 1,350.00 129.00 0.00 564.00 0.00 786.00 41.78 1110-52-3705 Education -B.Garbett 1,350.00 0.00 0.00 435.00 0.00 915.00 32.22 1110-52-3706 Education - J. Fox 1,670.00 0.00 0.00 935.00 0.00 735.00 55.99 1110-52-3707 Education - Wolff 1,250.00 0.00 0.00 475.00 0.00 775.00 38.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 3,319.47 0.00 46,508.31 0.00 11,510.77 80.16 SUPPLIES 1110-53-1100 Supplies & Materials 1,257.00 600.00 0.00 1,256.35 0.00 0.65 99.95 1110-53-1210 Water/Sewer Charges 288.00 19.36 0.00 158.12 0.00 129.88 54.90 1110-53-1230 Electricity 11,027.00 536.04 0.00 4,088.93 0.00 6,938.07 37.08 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 1,147.19 0.00 3,189.19 0.00 1,253.81 71.78 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 2,302.59 0.00 8,692.59 0.00 8,522.41 50.49 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Mayor and Council % OF YEAR COMPLETED: 66.67 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 5,622.06 0.00 55,200.90 0.00 20,033.18 73.37 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Clerk of Council % OF YEAR COMPLETED: 66.67 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 29,861.53 0.00 17,765.47 62.70 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 125.00 0.00 250.00 33.33 1130-51-2100 Health Insurance Benefits 6,534.00 412.62 0.00 3,707.97 50.88 2,775.15 57.53 1130-51-2200 FICA Soc Sec Contribution 2,999.00 216.10 0.00 1,838.85 0.00 1,160.15 61.32 1130-51-2300 FICA Medicare Contributio 701.00 50.54 0.00 430.07 0.00 270.93 61.35 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,203.30 0.00 36,088.24 50.88 26,905.88 57.32 SERVICES 1130-52-1110 Recodification Service 8,751.00 1,502.52 0.00 3,544.69 0.00 5,206.31 40.51 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 27.40 0.00 318.60 7.92 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 545.39 0.00 2,745.49 0.00 604.51 81.95 1130-52-3600 Dues & Fees 3,200.00 0.00 0.00 2,176.60 0.00 1,023.40 68.02 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,051.91 0.00 11,441.80 297.84 15,040.50 43.84 SUPPLIES 1130-53-1100 Supplies & Materials 2,010.00 33.68 0.00 1,401.04 0.00 608.96 69.70 1130-53-1210 Water/Sewer Chgs 40.00 2.69 0.00 21.97 0.00 18.03 54.93 1130-53-1230 Electricity 1,532.00 74.42 0.00 567.70 0.00 964.30 37.06 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 110.79 0.00 2,212.33 0.00 1,799.67 55.14 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 6,366.00 0.00 49,742.37 348.72 43,746.05 53.38 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 7 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund City Manager % OF YEAR COMPLETED: 66.67 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 76,048.66 0.00 45,707.34 62.46 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 500.00 0.00 250.00 66.67 1320-51-2100 Health Insurance Benefits 16,027.00 1,096.05 0.00 9,654.14 112.01 6,260.85 60.94 1320-51-2200 FICA Soc Sec Contribution 7,626.00 548.40 0.00 4,664.92 0.00 2,961.08 61.17 1320-51-2300 FICA Medicare Contributio 1,784.00 128.27 0.00 1,091.10 0.00 692.90 61.16 1320-51-2400 Retirement Contributions 14,123.00 1,176.91 0.00 9,415.28 0.00 4,707.72 66.67 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 11,948.65 0.00 101,849.10 112.01 60,608.89 62.72 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 3.01 0.00 23.10 0.00 13.90 62.43 1320-52-3100 Property/Liability Insura 692.08 0.00 0.00 1,013.89 0.00 ( 321.81) 146.50 1320-52-3220 Postage/ Freight 1,171.78 0.00 0.00 716.80 0.00 454.98 61.17 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 257.47 0.00 797.47 0.00 338.75 70.19 1320-52-3600 Dues & Fees 1,200.00 0.00 0.00 716.70 0.00 483.30 59.73 1320-52-3700 Educ & Training 1,175.00 0.00 0.00 910.00 0.00 265.00 77.45 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,412.08 260.48 0.00 4,177.96 0.00 1,234.12 77.20 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 15.76 0.00 12.24 56.29 1320-53-1230 Electricity 1,100.00 53.42 0.00 407.50 0.00 692.50 37.05 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,518.00 55.35 0.00 778.56 0.00 739.44 51.29 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,264.48 0.00 106,805.62 112.01 62,582.45 63.08 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 8 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Finance % OF YEAR COMPLETED: 66.67 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 19,252.63 0.00 150,408.94 0.00 120,203.06 55.58 1510-51-1300 Overtime 1,000.00 0.00 0.00 358.64 0.00 641.36 35.86 1510-51-1400 Employee Benefits 750.00 62.50 0.00 250.00 0.00 500.00 33.33 1510-51-2100 Health Insurance Benefits 46,950.00 3,697.08 0.00 25,773.83 296.03 20,880.14 55.53 1510-51-2200 FICA Soc Sec Contribution 17,847.00 1,181.00 0.00 9,256.04 0.00 8,590.96 51.86 1510-51-2300 FICA Medicare Contributio 4,174.00 276.19 0.00 2,164.75 0.00 2,009.25 51.86 1510-51-2400 Retirement Contributions 41,918.00 3,493.09 0.00 27,944.72 0.00 13,973.28 66.67 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 27,962.49 0.00 216,980.63 296.03 167,154.34 56.52 SERVICES 1510-52-1105 County Tax Billing Admin 25,000.00 1.90 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 0.00 0.00 0.00 4,000.00 9,098.00 30.54 1510-52-2110 Garbage Charges 71.00 5.60 0.00 44.05 0.00 26.95 62.04 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,365.86 0.00 0.00 1,950.03 0.00 ( 584.17) 142.77 1510-52-3220 Postage/Freight 1,400.00 21.67 0.00 544.13 0.00 855.87 38.87 1510-52-3300 Advertising 1,000.00 0.00 0.00 200.00 0.00 800.00 20.00 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 4,000.00 0.00 20.20 145.42 0.00 3,854.58 3.64 1510-52-3600 Dues & Fees 1,200.00 0.00 0.00 429.58 300.00 470.42 60.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 8,895.37 0.00 12,395.37 0.00 8,454.63 59.45 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,369.51 0.00 20,328.14 0.00 5,660.86 78.22 TOTAL SERVICES 115,973.86 10,294.05 20.20 72,197.56 4,619.00 39,157.30 66.24 SUPPLIES 1510-53-1100 Supplies & Materials 5,916.00 145.44 0.00 2,590.74 0.00 3,325.26 43.79 1510-53-1210 Water/Sewer Chgs 55.00 3.81 0.00 31.12 0.00 23.88 56.58 1510-53-1230 Electricity 2,174.00 105.44 0.00 804.27 0.00 1,369.73 36.99 1510-53-1400 Books/Periodicals 334.00 0.00 0.00 159.00 0.00 175.00 47.60 1510-53-1600 Small Equipment 1,000.00 0.00 0.00 0.00 0.00 1,000.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 9,479.00 254.69 0.00 3,596.51 0.00 5,882.49 37.94 _________________________________________________________________________________________________________________________________ TOTAL Finance 509,883.86 38,511.23 20.20 292,774.70 4,915.03 212,194.13 58.38 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 9 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Law % OF YEAR COMPLETED: 66.67 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 20,064.23 0.00 13,935.77 59.01 1530-52-1203 Legal/Lawsuits/All Depts 118,000.00 9,946.50 0.00 63,585.90 54,414.10 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 11,946.50 0.00 83,650.13 54,414.10 18,235.77 88.33 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 11,946.50 0.00 83,650.13 54,414.10 18,235.77 88.33 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 10 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Information Technology % OF YEAR COMPLETED: 66.67 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 68,230.30 0.00 38,004.70 64.23 1535-51-1400 Employee Benefits 5,100.00 425.00 0.00 3,150.00 0.00 1,950.00 61.76 1535-51-2100 Health Insurance Benefits 15,869.00 1,096.05 0.00 9,604.30 106.90 6,157.80 61.20 1535-51-2200 FICA Soc Sec Contribution 6,903.00 508.80 0.00 4,314.13 0.00 2,588.87 62.50 1535-51-2300 FICA Medicare Contributio 1,614.00 118.98 0.00 1,008.87 0.00 605.13 62.51 1535-51-2400 Retirement Contributions 16,345.00 1,362.05 0.00 10,896.40 0.00 5,448.60 66.67 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,503.86 0.00 97,498.01 106.90 54,884.09 64.01 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 118,500.00 7,322.42 0.00 72,749.81 39,800.42 5,949.77 94.98 1535-52-2110 Garbage Charges 40.00 2.98 0.00 23.24 0.00 16.76 58.10 1535-52-2201 Repair/Maint-Buildings 5,000.00 1,428.26 0.00 3,619.26 0.00 1,380.74 72.39 1535-52-2203 Repair/Maint-Equipt 3,000.00 0.00 0.00 2,686.59 193.74 119.67 96.01 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 710.38 0.00 0.00 984.96 0.00 ( 274.58) 138.65 1535-52-3201 Telephone/Internet Costs 48,600.00 2,351.50 0.00 35,234.37 9,003.63 4,362.00 91.02 1535-52-3203 Cell Phones 7,300.00 652.12 0.00 4,345.67 0.00 2,954.33 59.53 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 200.00 0.00 1,350.00 950.00 2,024.48 53.19 TOTAL SERVICES 188,959.86 11,957.28 0.00 120,993.90 49,947.79 18,018.17 90.46 SUPPLIES 1535-53-1100 Supplies & Materials 24,000.00 0.00 0.00 13,623.30 0.00 10,376.70 56.76 1535-53-1210 Water/Sewer Chgs 28.00 1.98 0.00 16.17 0.00 11.83 57.75 1535-53-1230 Electricity 1,347.00 54.84 0.00 418.30 0.00 928.70 31.05 1535-53-1600 Small Equipment 29,100.00 2,714.83 0.00 18,187.40 697.76 10,214.84 64.90 1535-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 54,475.00 2,771.65 0.00 32,245.17 697.76 21,532.07 60.47 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 11 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Information Technology % OF YEAR COMPLETED: 66.67 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 11,639.89 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 11,639.89 0.00 13,238.35 0.00 ( 11,162.83) 637.83 _________________________________________________________________________________________________________________________________ TOTAL Information Technology 397,999.38 37,872.68 0.00 263,975.43 50,752.45 83,271.50 79.08 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 12 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Human Resources % OF YEAR COMPLETED: 66.67 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 37,284.76 0.00 19,107.24 66.12 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,700.00 0.00 850.00 66.67 1540-51-2100 Health Insurance Benefits 9,226.00 1,026.88 0.00 5,768.58 54.78 3,402.64 63.12 1540-51-2200 FICA Soc Sec Contribution 3,627.00 269.32 0.00 2,359.09 0.00 1,267.91 65.04 1540-51-2300 FICA Medicare Contributio 855.00 62.98 0.00 551.69 0.00 303.31 64.53 1540-51-2400 Retirement Contributions 7,806.00 650.45 0.00 5,203.60 0.00 2,602.40 66.66 1540-51-2401 Retiree Insurance Premium 4,122.00 0.00 0.00 2,448.04 0.00 1,673.96 59.39 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,463.49 0.00 55,469.28 54.78 31,277.94 63.97 SERVICES 1540-52-1120 Management Support Activi 2,500.00 288.26 0.00 1,666.82 0.00 833.18 66.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 25.00 0.00 600.00 0.00 3,100.00 16.22 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 14.18 0.00 7.82 64.45 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 315.07 0.00 6,909.52 0.00 7,563.85 47.74 SUPPLIES 1540-53-1100 Supplies & Materials 961.00 0.00 0.00 595.29 0.00 365.71 61.94 1540-53-1210 Water Sewer Chgs 22.00 1.15 0.00 9.43 0.00 12.57 42.86 1540-53-1230 Electricity 660.00 32.06 0.00 244.59 0.00 415.41 37.06 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 0.00 139.00 0.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 0.00 0.00 252.45 0.00 747.55 25.25 1540-53-1720 Uniforms 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 3,282.00 33.21 0.00 1,365.25 0.00 1,916.75 41.60 _________________________________________________________________________________________________________________________________ TOTAL Human Resources 104,557.37 6,811.77 0.00 63,744.05 54.78 40,758.54 61.02 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 13 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Bldg Maint & Allocations % OF YEAR COMPLETED: 66.67 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,960.00 0.00 88,709.62 0.00 45,570.38 66.06 1565-51-1300 Overtime Wages 6,090.00 318.96 0.00 2,667.90 0.00 3,422.10 43.81 1565-51-1400 Employee Benefits 750.00 62.50 0.00 500.00 0.00 250.00 66.67 1565-51-2100 Health Insurance Benefits 33,865.00 1,925.27 0.00 16,838.62 182.06 16,844.32 50.26 1565-51-2200 FICA Soc Sec Contribution 8,806.00 703.17 0.00 5,696.42 0.00 3,109.58 64.69 1565-51-2300 FICA Medicare Contributio 2,060.00 164.43 0.00 1,332.12 0.00 727.88 64.67 1565-51-2400 Retirement Contributions 17,089.00 1,424.02 0.00 11,392.16 0.00 5,696.84 66.66 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 15,558.35 0.00 134,691.19 182.06 75,651.75 64.07 SERVICES 1565-52-2130 Custodial City Hall Build 6,600.00 0.00 0.00 3,850.00 550.00 2,200.00 66.67 1565-52-2200 Pest Control 3,000.00 374.86 0.00 1,908.93 562.29 528.78 82.37 1565-52-2201 Repair/Maintain-Buildings 80,000.00 100.00 0.00 56,394.14 0.00 23,605.86 70.49 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 474.86 0.00 62,153.07 1,112.29 29,334.64 68.32 SUPPLIES 1565-53-1100 Supplies/Materials 3,000.00 653.63 0.00 1,387.18 0.00 1,612.82 46.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 653.63 0.00 1,387.18 0.00 1,612.82 46.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 16,686.84 0.00 198,231.44 1,294.35 106,599.21 65.18 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 14 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Municipal Court % OF YEAR COMPLETED: 66.67 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,600.00 0.00 1,400.00 53.33 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,600.00 0.00 1,400.00 53.33 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,600.00 0.00 1,500.00 85.15 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 15 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Police Administration % OF YEAR COMPLETED: 66.67 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 93,103.96 0.00 824,922.70 0.00 377,578.70 68.60 3210-51-1200 Part Time/Seasonal Wages 72,911.00 5,765.60 0.00 48,460.33 0.00 24,450.67 66.47 3210-51-1300 Overtime 65,000.00 3,213.87 0.00 28,602.84 0.00 36,397.16 44.00 3210-51-1400 Employee Benefits 6,000.00 500.00 0.00 4,000.00 0.00 2,000.00 66.67 3210-51-2100 Health Insurance Benefits 207,457.00 15,685.62 0.00 133,749.68 1,368.22 72,339.10 65.13 3210-51-2200 FICA Soc Sec Contribution 83,524.23 6,354.41 0.00 56,122.65 0.00 27,401.58 67.19 3210-51-2300 FICA Medicare Contributio 20,533.46 1,486.05 0.00 13,125.23 0.00 7,408.23 63.92 3210-51-2400 Retirement Contributions 154,230.08 12,852.42 0.00 102,819.36 0.00 51,410.72 66.67 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 138,961.93 0.00 1,259,049.03 1,368.22 645,833.75 66.12 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 39.41 0.00 10,519.26 133.64 2,347.10 81.95 3210-52-2110 Garbage Charges 1,010.00 42.03 0.00 336.24 0.00 673.76 33.29 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 2,205.24 0.00 16,777.76 175.50 5,708.13 74.81 3210-52-2203 Repair/Maint-Equipment 6,000.00 934.28 0.00 3,382.71 160.00 2,457.29 59.05 3210-52-2320 Rent-Equip & Vehicles 412.50 0.00 0.00 412.50 0.00 0.00 100.00 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 0.00 0.00 305.08 0.00 394.92 43.58 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 10,500.00 502.06 0.00 5,415.56 1,224.97 3,859.47 63.24 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 26.00 0.00 83.00 0.00 17.00 83.00 3210-52-3700 Educ &Training 4,150.00 638.00 0.00 3,687.00 180.00 283.00 93.18 3210-52-3901 Credit Card Svc. Charges 6,800.00 96.25 0.00 2,294.56 0.00 4,505.44 33.74 TOTAL SERVICES 98,414.21 4,483.27 0.00 72,370.38 1,874.11 24,169.72 75.44 SUPPLIES 3210-53-1100 Supplies & Materials 8,700.00 1,220.41 0.00 6,342.92 297.70 2,059.38 76.33 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 6,000.00 22.85 0.00 1,055.08 0.00 4,944.92 17.58 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 54.19 0.00 500.04 0.00 771.96 39.31 3210-53-1230 Electricity 12,623.00 1,064.89 0.00 8,561.28 0.00 4,061.72 67.82 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 16 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Police Administration % OF YEAR COMPLETED: 66.67 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 0.00 0.00 36,500.15 0.00 13,499.85 73.00 3210-53-1310 Food - Officials & Functi 300.00 90.00 0.00 162.00 0.00 138.00 54.00 3210-53-1385 Custody - Food Supplies 500.00 11.10 0.00 140.93 157.52 201.55 59.69 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 3,618.74 0.00 17,487.86 0.00 7,512.14 69.95 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 130.24 0.00 8,303.72 1,198.45 7,497.83 55.90 TOTAL SUPPLIES 128,695.00 6,212.42 0.00 79,114.71 1,653.67 47,926.62 62.76 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 0.00 0.00 10,405.00 0.00 6,595.00 61.21 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 0.00 0.00 10,405.00 0.00 7,095.00 59.46 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 2,194,024.21 149,657.62 0.00 1,444,214.12 4,896.00 744,914.09 66.05 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 17 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Beach Patrol % OF YEAR COMPLETED: 66.67 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 1,494.95 0.00 34,900.68 0.00 21,331.32 62.07 3215-51-1300 Overtime 5,802.00 0.00 0.00 2,533.69 0.00 3,268.31 43.67 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 92.69 0.00 2,320.87 0.00 1,525.13 60.35 3215-51-2300 FICA Medicare Contributio 899.00 21.68 0.00 542.80 0.00 356.20 60.38 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 1,609.32 0.00 42,909.54 0.00 27,281.46 61.13 SERVICES 3215-52-2203 Repair & Maintain - Equip 1,000.00 32.25 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 32.25 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 124.72 0.00 1,385.50 224.50 390.00 80.50 TOTAL SUPPLIES 3,700.00 124.72 0.00 2,435.38 224.50 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 1,766.29 0.00 46,297.58 224.50 28,368.92 62.12 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 18 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Fire Administration % OF YEAR COMPLETED: 66.67 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 49,191.16 0.00 25,961.84 65.45 3510-51-1200 Part Time/Seasonal Wages 74,313.00 5,535.21 0.00 46,823.34 0.00 27,489.66 63.01 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 500.00 0.00 250.00 66.67 3510-51-2100 Health Insurance Benefits 18,966.00 1,281.09 0.00 11,008.82 94.21 7,862.97 58.54 3510-51-2200 FICA Soc Sec Contribution 9,363.00 697.43 0.00 6,033.48 0.00 3,329.52 64.44 3510-51-2300 FICA Medicare Contributio 2,190.00 163.11 0.00 1,411.06 0.00 778.94 64.43 3510-51-2400 Retirement Contributions 5,939.00 989.76 0.00 3,959.04 0.00 1,979.96 66.66 3510-51-2500 GA Firefighters Pen Fund 3,240.00 0.00 0.00 1,365.00 0.00 1,875.00 42.13 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,380.30 0.00 125,443.10 94.21 73,269.69 63.15 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 3.02 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 670.25 0.00 9,792.70 0.00 8,207.30 54.40 3510-52-2203 Repair & Maintain - Equip 6,000.00 0.00 0.00 2,719.21 0.00 3,280.79 45.32 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 13,000.00 0.00 0.00 372.00 10,478.69 2,149.31 83.47 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 0.00 0.00 129.86 0.00 250.14 34.17 3510-52-3500 Travel & Related Expenses 500.00 0.00 0.00 0.00 0.00 500.00 0.00 3510-52-3600 Dues and Fees 1,000.00 0.00 0.00 39.17 0.00 960.83 3.92 3510-52-3603 Ga Firefighters Assoc Con 2,000.00 0.00 0.00 0.00 0.00 2,000.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 60,295.57 673.27 0.00 27,449.07 10,478.69 22,367.81 62.90 SUPPLIES 3510-53-1100 Supplies & Materials 1,500.00 0.00 0.00 1,411.57 0.00 88.43 94.10 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 138.39 946.53 36.90 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 67.20 0.00 604.09 0.00 216.41 73.62 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 266.02 0.00 2,650.54 0.00 1,925.96 57.92 3510-53-1270 Gasoline & Diesel Fuel 8,000.00 0.00 0.00 6,287.01 0.00 1,712.99 78.59 3510-53-1271 Gasoline - EMS Chatham Co 0.00 0.00 0.00 ( 711.38) 0.00 711.38 0.00 3510-53-1300 Volunteer Apprec -Wed Dri 6,000.00 0.00 0.00 0.00 300.00 5,700.00 5.00 3510-53-1400 Books & periodicals 200.00 ( 2.46) 0.00 35.08 0.00 164.92 17.54 3510-53-1600 Small Equipment 15,900.00 2,211.70 0.00 8,401.43 120.00 7,378.57 53.59 3510-53-1601 Breathing Apparatus 6,500.00 0.00 0.00 1,486.40 0.00 5,013.60 22.87 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 19 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Fire Administration % OF YEAR COMPLETED: 66.67 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 7,300.00 0.00 0.00 4,499.31 0.00 2,800.69 61.63 3510-53-1720 Uniforms & Accessories 1,700.00 0.00 0.00 580.13 0.00 1,119.87 34.13 TOTAL SUPPLIES 59,497.00 2,542.46 0.00 27,039.76 558.39 31,898.85 46.39 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 17,596.03 0.00 192,931.93 11,131.29 127,536.35 61.54 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 20 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Emergency Management % OF YEAR COMPLETED: 66.67 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,779.32 0.00 23,960.71 0.00 12,947.29 64.92 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 500.00 0.00 250.00 66.67 3920-51-2100 Health Insurance Benefits 9,552.00 681.44 0.00 5,824.98 47.08 3,679.94 61.47 3920-51-2200 FICA Social Security Cont 2,335.00 176.20 0.00 1,516.57 0.00 818.43 64.95 3920-51-2300 FICA Medicare Contributio 546.00 41.20 0.00 354.67 0.00 191.33 64.96 3920-51-2400 Retirement Contributions 5,860.00 549.23 0.00 4,393.84 0.00 1,466.16 74.98 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,289.89 0.00 36,704.77 47.08 19,353.15 65.51 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 0.00 0.00 0.00 0.00 500.00 0.00 3920-52-3900 Fire Ext. Maintenance 3,000.00 0.00 0.00 179.19 0.00 2,820.81 5.97 TOTAL SERVICES 12,230.95 0.00 0.00 5,540.59 0.00 6,690.36 45.30 SUPPLIES 3920-53-1100 Supplies - Emergency Mgmt 490.00 0.00 0.00 276.61 0.00 213.39 56.45 3920-53-1107 Emergency Rations and Sup 1,500.00 0.00 0.00 0.00 1,226.60 273.40 81.77 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 0.00 0.00 229.61 400.00 120.39 83.95 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 0.00 200.00 0.00 TOTAL SUPPLIES 5,832.00 0.00 0.00 506.22 1,626.60 3,699.18 36.57 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 4,289.89 0.00 42,751.58 1,673.68 29,742.69 59.90 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 21 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Public Works % OF YEAR COMPLETED: 66.67 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 47,310.68 0.00 416,850.54 0.00 238,297.46 63.63 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 724.02 0.00 11,208.11 0.00 13,791.89 44.83 4210-51-1400 Employee Benefits 6,000.00 562.50 0.00 4,125.00 0.00 1,875.00 68.75 4210-51-2100 Health Insurance Benefits 138,344.00 7,912.37 0.00 76,298.91 681.16 61,363.93 55.64 4210-51-2200 FICA Soc Sec Contribution 44,219.00 3,009.21 0.00 26,762.92 0.00 17,456.08 60.52 4210-51-2300 FICA Medicare Contributio 10,342.00 703.75 0.00 6,259.14 0.00 4,082.86 60.52 4210-51-2400 Retirement Contributions 82,655.00 6,887.91 0.00 55,103.28 0.00 27,551.72 66.67 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 67,110.44 0.00 646,682.08 681.16 403,139.76 61.62 SERVICES 4210-52-2140 Landscaping/Lawncare 10,000.00 931.75 0.00 2,397.85 0.00 7,602.15 23.98 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 2,535.88 0.00 50,726.50 348.75 24,514.75 67.57 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 205.71 0.00 1,686.08 33.35 2,280.57 42.99 4210-52-2205 Repair & Maint- Infrastru 18,000.00 3,246.88 0.00 14,969.41 0.00 3,030.59 83.16 4210-52-2320 Rental - Equipment & Vehi 6,000.00 0.00 0.00 2,820.74 2,116.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 0.00 0.00 265.02 0.00 34.98 88.34 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 0.00 0.00 3,691.00 0.00 1,309.00 73.82 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 6,920.22 0.00 120,231.58 2,521.10 63,378.93 65.95 SUPPLIES 4210-53-1100 Supplies & Materials 38,000.00 346.37 0.00 12,849.14 0.00 25,150.86 33.81 4210-53-1105 Public Restroom Supplies 16,000.00 0.00 0.00 5,236.02 0.00 10,763.98 32.73 4210-53-1210 Water/Sewer Charges 1,511.00 72.30 0.00 640.57 0.00 870.43 42.39 4210-53-1220 Propane 1,600.00 0.00 0.00 0.00 0.00 1,600.00 0.00 4210-53-1230 Electricity 142,182.00 11,269.49 0.00 77,371.49 0.00 64,810.51 54.42 4210-53-1270 Gasoline & Diesel Fuel 51,000.00 20.00 0.00 30,952.96 0.00 20,047.04 60.69 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 0.00 0.00 8,035.11 0.00 4,964.89 61.81 4210-53-1702 Signs - various 10,000.00 379.50 0.00 7,062.83 0.00 2,937.17 70.63 4210-53-1720 Uniform/ Clothing 6,200.00 343.90 0.00 3,148.06 0.00 3,051.94 50.78 TOTAL SUPPLIES 285,993.00 12,431.56 0.00 146,610.36 0.00 139,382.64 51.26 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 22 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Public Works % OF YEAR COMPLETED: 66.67 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 0.00 0.00 33,723.59 ( 2,600.00) 51,092.53 37.86 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 0.00 0.00 54,568.59 ( 2,600.00) 61,580.86 45.77 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 86,462.22 0.00 968,092.61 602.26 667,482.19 59.20 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 23 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Storm Drainage % OF YEAR COMPLETED: 66.67 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,000.00 0.00 3,500.00 53.33 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,000.00 0.00 3,500.00 53.33 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,000.00 0.00 3,500.00 53.33 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 24 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Solid Waste Collection % OF YEAR COMPLETED: 66.67 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 8,616.19 0.00 60,090.03 0.00 35,909.97 62.59 4520-52-2111 City Dump Pick Up -Waste 140,000.00 8,691.58 0.00 61,883.71 0.00 78,116.29 44.20 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 17,307.77 0.00 121,973.74 0.00 114,026.26 51.68 _________________________________________________________________________________________________________________________________ TOTAL Solid Waste Collection 236,000.00 17,307.77 0.00 121,973.74 0.00 114,026.26 51.68 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 25 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Cultural & Recreation % OF YEAR COMPLETED: 66.67 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 141.09 0.00 1,128.72 0.00 1,071.28 51.31 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 79,871.46 0.00 16,347.98 83.01 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 141.09 0.00 81,000.18 0.00 17,419.26 82.30 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 180.77 0.00 2,149.66 0.00 769.34 73.64 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 4,579.21 0.00 36,301.79 0.00 27,190.21 57.18 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 4,759.98 0.00 60,573.93 0.00 28,063.07 68.34 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 26 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Cultural & Recreation % OF YEAR COMPLETED: 66.67 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 0.00 0.00 4,912.04 0.00 0.00 100.00 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 0.00 0.00 4,912.04 0.00 0.00 100.00 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 137.40 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 0.00 0.00 0.00 0.00 7,500.00 0.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,127.34 0.00 ( 2.34) 100.21 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 319.40 0.00 2,238.26 0.00 15,751.74 12.44 _________________________________________________________________________________________________________________________________ TOTAL Cultural & Recreation 209,958.48 5,220.47 0.00 148,724.41 0.00 61,234.07 70.84 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 27 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Recreation Centers % OF YEAR COMPLETED: 66.67 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 105,633.36 0.00 52,816.64 66.67 TOTAL SERVICES 158,450.00 13,204.17 0.00 105,633.36 0.00 52,816.64 66.67 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 105,633.36 0.00 52,816.64 66.67 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 28 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Lifeguards % OF YEAR COMPLETED: 66.67 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 0.00 0.00 171,972.31 0.00 134,606.69 56.09 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 0.00 0.00 10,662.28 0.00 8,344.72 56.10 6124-51-2300 FICA Medicare Contributio 4,446.00 0.00 0.00 2,493.67 0.00 1,952.33 56.09 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 0.00 0.00 192,628.26 0.00 147,030.74 56.71 SERVICES 6124-52-1226 Lifeguard Certifications 2,350.00 1,454.95 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 0.00 0.00 0.00 0.00 1,500.00 0.00 6124-52-2203 Repair & Maintain - Equip 3,500.00 0.00 0.00 3,482.07 0.00 17.93 99.49 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 9,119.41 1,454.95 0.00 7,851.82 0.00 1,267.59 86.10 SUPPLIES 6124-53-1100 General Supplies & Materi 1,521.00 0.00 0.00 1,371.38 0.00 149.62 90.16 6124-53-1104 First Aid Supplies 2,950.00 87.03 0.00 899.38 764.78 1,285.84 56.41 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 1,000.00 0.00 0.00 0.00 0.00 1,000.00 0.00 6124-53-1600 Small Equipment 3,000.00 0.00 0.00 2,423.10 0.00 576.90 80.77 6124-53-1720 Uniforms 3,500.00 0.00 0.00 18.40 0.00 3,481.60 0.53 TOTAL SUPPLIES 13,171.00 87.03 0.00 4,712.26 764.78 7,693.96 41.58 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 1,541.98 0.00 213,221.34 764.78 155,992.29 57.84 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 29 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Beach Related % OF YEAR COMPLETED: 66.67 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 101.31 0.00 1,085.02 0.00 914.98 54.25 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 101.31 0.00 1,085.02 0.00 914.98 54.25 SUPPLIES 6125-53-1210 Water/Sewer Chgs 19,041.00 354.59 0.00 8,142.42 0.00 10,898.58 42.76 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 3,166.66 0.00 22,641.66 0.00 14,725.00 60.59 TOTAL SUPPLIES 56,407.66 3,521.25 0.00 30,784.08 0.00 25,623.58 54.57 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 0.00 0.00 97,000.00 14,876.94 188,123.06 37.29 6125-54-2105 Capital - Misc. 47,000.00 514.28 0.00 45,142.82 0.00 1,857.18 96.05 TOTAL CAPITAL OUTLAY 347,000.00 514.28 0.00 142,142.82 14,876.94 189,980.24 45.25 _________________________________________________________________________________________________________________________________ TOTAL Beach Related 405,407.66 4,136.84 0.00 174,011.92 14,876.94 216,518.80 46.59 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 30 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Museums % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 31 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund River's End RV Park % OF YEAR COMPLETED: 66.67 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 0.00 33,482.00 0.00 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 0.00 322,373.57 0.00 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 0.00 2,869.00 0.00 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 ( 1,154.00) 0.00 ( 1,154.00) 1,154.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 0.00 11,500.00 0.00 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 ( 1,154.00) 0.00 ( 1,154.00) 1,154.00 165,167.84 0.00 SUPPLIES 6180-53-1100 Supplies and Materials 43,543.00 ( 631.20) 0.00 ( 631.20) 631.20 43,543.00 0.00 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 ( 52.91) 0.00 ( 52.91) 52.91 2,130.82 0.00 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 ( 738.22) 0.00 ( 738.22) 738.22 12,000.00 0.00 6180-53-1595 Camp Store Groceries 25,600.00 ( 6,004.87) 0.00 ( 6,004.87) 6,004.87 25,600.00 0.00 6180-53-1596 Camp Store - RV Supls - C 12,000.00 ( 3,535.26) 0.00 ( 3,535.26) 3,535.26 12,000.00 0.00 6180-53-1600 Small Equipment 36,049.31 0.00 0.00 0.00 0.00 36,049.31 0.00 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 32 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund River's End RV Park % OF YEAR COMPLETED: 66.67 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 ( 10,962.46) 0.00 ( 10,962.46) 10,962.46 231,487.18 0.00 CAPITAL OUTLAY 6180-54-1100 Capital Improvements 56,138.50 ( 21,347.50) 0.00 ( 21,347.50) 21,347.50 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 ( 21,347.50) 0.00 ( 21,347.50) 21,347.50 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 ( 33,463.96) 0.00 ( 33,463.96) 33,463.96 1,062,523.76 0.00 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 33 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Parks Administration % OF YEAR COMPLETED: 66.67 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,387.13 0.00 65,934.44 0.00 47,814.56 57.96 6210-51-1300 Overtime 10,000.00 115.11 0.00 2,818.17 0.00 7,181.83 28.18 6210-51-1400 Employee Benefits 750.00 62.50 0.00 250.00 0.00 500.00 33.33 6210-51-2100 Health Insurance Benefits 25,095.00 1,243.83 0.00 11,195.17 172.12 13,727.71 45.30 6210-51-2200 FICA Social Security Cont 7,719.00 531.03 0.00 4,278.20 0.00 3,440.80 55.42 6210-51-2300 FICA Medicare 1,805.00 124.20 0.00 1,000.54 0.00 804.46 55.43 6210-51-2400 Retirement Contributions 7,423.00 618.53 0.00 4,948.24 0.00 2,474.76 66.66 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,082.33 0.00 93,122.70 172.12 77,155.18 54.73 SERVICES 6210-52-2140 Landscape/Lawncare 1,000.00 785.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 140.77 0.00 ( 140.77) 0.00 TOTAL SERVICES 5,000.00 785.00 0.00 925.77 0.00 4,074.23 18.52 SUPPLIES 6210-53-1100 General Supplies and Mate 18,600.00 2,336.17 0.00 7,426.84 ( 1,622.17) 12,795.33 31.21 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 627.45 0.00 603.55 50.97 6210-53-1230 Electricity 4,730.00 233.80 0.00 2,247.95 0.00 2,482.05 47.53 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 2,643.37 0.00 10,302.24 ( 1,622.17) 16,480.93 34.50 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 14,510.70 0.00 104,350.71 ( 1,450.05) 102,710.34 50.05 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 34 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Zoning and Inspection % OF YEAR COMPLETED: 66.67 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.96 0.00 57,981.18 0.00 32,342.82 64.19 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,700.00 0.00 850.00 66.67 7220-51-2100 Health Insurance Benefits 16,168.00 1,096.05 0.00 8,601.30 100.45 7,466.25 53.82 7220-51-2200 FICA Soc Sec Contribution 5,789.00 431.66 0.00 3,679.19 0.00 2,109.81 63.55 7220-51-2300 FICA Medicare Contributio 1,354.00 100.96 0.00 860.52 0.00 493.48 63.55 7220-51-2400 Retirement contributions 6,856.00 571.27 0.00 4,570.16 0.00 2,285.84 66.66 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,214.40 0.00 77,653.98 100.45 46,169.57 62.74 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 210.00 740.00 32.73 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 306.25 0.00 5,031.25 175.00 9,793.75 34.71 7220-52-1205 County Inspection Contrac 30,000.00 6,915.50 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 28.02 0.00 16.98 62.27 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,093.02 656.98 0.00 100.00 7220-52-2320 Rental - Equip & Vehicles 11,975.00 975.00 0.00 6,825.00 5,150.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 0.00 0.00 153.10 0.00 596.90 20.41 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 198.00 0.00 669.98 0.00 1,830.02 26.80 7220-52-3600 Dues and Fees 1,250.00 11.95 0.00 764.98 115.35 369.67 70.43 7220-52-3700 Educ & Training 2,500.00 50.00 0.00 895.00 0.00 1,605.00 35.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 8,731.10 0.00 39,708.14 22,161.33 28,625.98 68.37 SUPPLIES 7220-53-1100 Supplies & Materials 4,993.00 136.32 0.00 1,506.98 534.11 2,951.91 40.88 7220-53-1210 Water/Sewer Chgs 33.00 2.37 0.00 19.57 0.00 13.43 59.30 7220-53-1230 Electricity 1,391.00 67.58 0.00 515.50 0.00 875.50 37.06 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 206.27 0.00 2,252.05 534.11 4,380.84 38.87 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 35 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Zoning and Inspection % OF YEAR COMPLETED: 66.67 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 18,151.77 0.00 119,614.17 22,795.89 79,176.39 64.27 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 36 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Better Hometown % OF YEAR COMPLETED: 66.67 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 26,554.36 0.00 14,785.64 64.23 7300-51-1400 Employee Benefits 375.00 31.25 0.00 250.00 0.00 125.00 66.67 7300-51-2100 Health Insurance 9,610.00 681.44 0.00 5,833.14 48.64 3,728.22 61.20 7300-51-2200 FICA Social Security 2,586.00 191.16 0.00 1,631.50 0.00 954.50 63.09 7300-51-2300 FICA Medicare 605.00 44.71 0.00 381.59 0.00 223.41 63.07 7300-51-2400 Retirement Contributions 6,110.00 509.13 0.00 4,073.04 0.00 2,036.96 66.66 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,567.29 0.00 38,836.45 48.64 21,899.91 63.97 SERVICES 7300-52-2110 Garbage Charges 17.00 1.38 0.00 10.46 0.00 6.54 61.53 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 125.00 0.00 741.36 0.00 1,393.64 34.72 7300-52-3600 Dues & Fees 2,175.00 250.00 0.00 1,619.50 0.00 555.50 74.46 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 376.38 0.00 2,821.06 0.00 3,488.95 44.71 SUPPLIES 7300-53-1100 Supplies & Materials 4,600.00 0.00 0.00 2,215.95 0.00 2,384.05 48.17 7300-53-1210 Water Sewer Chgs 20.00 0.86 0.00 6.81 0.00 13.19 34.05 7300-53-1230 Electricity 440.00 21.85 0.00 166.65 0.00 273.35 37.88 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 22.71 0.00 2,389.41 0.00 4,965.06 32.49 _________________________________________________________________________________________________________________________________ TOTAL Better Hometown 74,449.48 4,966.38 0.00 44,046.92 48.64 30,353.92 59.23 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 37 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Community Development % OF YEAR COMPLETED: 66.67 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 0.00 0.00 372.18 0.00 4,733.82 7.29 TOTAL SUPPLIES 5,106.00 0.00 0.00 372.18 0.00 4,733.82 7.29 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 0.00 0.00 372.18 0.00 4,733.82 7.29 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 38 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Parking % OF YEAR COMPLETED: 66.67 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 57,505.31 0.00 77,073.69 42.73 7564-51-1200 Part Time/Seasonal Wages 94,629.00 223.97 0.00 38,177.30 0.00 56,451.70 40.34 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 500.00 0.00 1,000.00 33.33 7564-51-2100 Health Insurance Benefits 18,500.00 1,299.39 0.00 11,137.75 99.21 7,263.04 60.74 7564-51-2200 FICA Soc Sec Contribution 14,784.00 444.75 0.00 5,943.12 0.00 8,840.88 40.20 7564-51-2300 FICA Medicare Contributio 3,458.00 104.00 0.00 1,389.87 0.00 2,068.13 40.19 7564-51-2400 Retirement Contributions 9,667.00 805.52 0.00 6,444.16 0.00 3,222.84 66.66 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 9,865.75 0.00 125,974.92 99.21 158,530.87 44.30 SERVICES 7564-52-1300 Computer service contract 58,000.00 4,176.50 0.00 33,611.00 6,161.00 18,228.00 68.57 7564-52-2110 Garbage Charges 14.00 0.91 0.00 12.25 0.00 1.75 87.50 7564-52-2202 Repair & Maint- Vehicles 3,650.00 0.00 0.00 1,713.26 103.86 1,832.88 49.78 7564-52-2203 Repair & Maint- Equipment 3,400.00 77.45 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 187.38 0.00 728.40 0.00 871.60 45.53 7564-52-3100 Property & Liability Insu 223.35 0.00 0.00 1,383.22 0.00 ( 1,159.87) 619.31 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 0.00 0.00 3,489.52 0.00 1,510.48 69.79 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 3,180.04 0.00 69,663.11 3,260.71 77,076.18 48.62 TOTAL SERVICES 223,264.35 7,622.28 0.00 113,400.37 10,234.93 99,629.05 55.38 SUPPLIES 7564-53-1100 Supplies & Materials 20,400.00 1,555.67 0.00 5,776.00 0.00 14,624.00 28.31 7564-53-1110 Parking Meters 63,500.00 148.99 0.00 42,510.28 19,440.94 1,548.78 97.56 7564-53-1210 Water/Sewer Charges 91.00 0.62 0.00 5.07 0.00 85.93 5.57 7564-53-1230 Electricity 1,851.75 60.89 0.00 507.71 0.00 1,344.04 27.42 7564-53-1270 Gas & Diesel Fuel 9,220.17 0.00 0.00 7,177.91 0.00 2,042.26 77.85 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 ( 0.75) 0.00 ( 66.75) 0.00 66.75 0.00 7564-53-1702 Signs 900.00 451.13 0.00 685.21 0.00 214.79 76.13 7564-53-1720 Uniforms 942.25 0.00 0.00 194.25 0.00 748.00 20.62 TOTAL SUPPLIES 99,185.17 2,216.55 0.00 59,069.68 19,440.94 20,674.55 79.16 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 39 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Parking % OF YEAR COMPLETED: 66.67 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 19,704.58 0.00 316,722.97 29,775.08 279,007.47 55.39 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 40 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Debt Service % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 41 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 100-General Fund Other Financing Uses % OF YEAR COMPLETED: 66.67 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 461,834.31 20.20 5,177,557.22 230,694.41 4,584,088.55 54.12 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 215-Emergency 911 Fund REVENUES % OF YEAR COMPLETED: 66.67 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,651.01 0.00 35,481.64 0.00 8,013.36 81.58 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,651.01 0.00 37,523.33 0.00 43,271.67 46.44 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,651.01 0.00 37,523.33 0.00 46,779.67 44.51 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 215-Emergency 911 Fund Police Administration % OF YEAR COMPLETED: 66.67 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,648.00 0.00 24,159.67 0.00 11,063.33 68.59 3210-51-1300 Overtime 4,000.00 1,216.43 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 866.48 0.00 6,447.84 46.14 6,297.02 50.77 3210-51-2200 FICA Soc Sec 2,308.00 239.60 0.00 1,719.28 0.00 588.72 74.49 3210-51-2300 FICA Medicare 540.00 56.04 0.00 402.12 0.00 137.88 74.47 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 5,026.55 0.00 36,203.09 46.14 24,553.77 59.62 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 12,292.29 742.15 8,965.56 59.25 TOTAL SERVICES 23,500.00 1,715.52 0.00 12,292.29 742.15 10,465.56 55.47 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 6,742.07 0.00 48,495.38 788.29 35,019.33 58.46 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 215-Emergency 911 Fund Other Financing Uses % OF YEAR COMPLETED: 66.67 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 6,742.07 0.00 48,495.38 788.29 35,019.33 58.46 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 275-Hotel / Motel Tax Fund REVENUES % OF YEAR COMPLETED: 66.67 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 26,686.01 0.00 1,068,571.69 0.00 931,428.31 53.43 00-31.9900 Late Charges 50,000.00 8.78 0.00 11,277.50 0.00 38,722.50 22.56 TOTAL TAXES 2,050,000.00 26,694.79 0.00 1,079,849.19 0.00 970,150.81 52.68 *** TOTAL REVENUES *** 2,050,000.00 26,694.79 0.00 1,079,849.19 0.00 970,150.81 52.68 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 275-Hotel / Motel Tax Fund Community Development % OF YEAR COMPLETED: 66.67 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 8,374.17 0.00 174,138.47 0.00 167,596.53 50.96 7520-57-2001 Chamber - Hotel/Motel fun 683,265.00 16,743.31 0.00 348,172.46 0.00 335,092.54 50.96 TOTAL OTHER COSTS 1,025,000.00 25,117.48 0.00 522,310.93 0.00 502,689.07 50.96 OTHER FINANCING USES 7520-61-1000 H/M Transfer Out 1,025,000.00 13,347.40 0.00 536,119.82 0.00 488,880.18 52.30 TOTAL OTHER FINANCING USES 1,025,000.00 13,347.40 0.00 536,119.82 0.00 488,880.18 52.30 _________________________________________________________________________________________________________________________________ TOTAL Community Development 2,050,000.00 38,464.88 0.00 1,058,430.75 0.00 991,569.25 51.63 FUND TOTAL EXPENDITURES 2,050,000.00 38,464.88 0.00 1,058,430.75 0.00 991,569.25 51.63 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund REVENUES % OF YEAR COMPLETED: 66.67 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 119,049.86 0.00 620,723.56 0.00 2,387,104.44 20.64 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 119,049.86 0.00 620,723.56 0.00 3,054,876.44 16.89 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 176.89 0.00 1,353.53 0.00 ( 1,353.53) 0.00 TOTAL INVESTMENT INCOME 0.00 176.89 0.00 1,353.53 0.00 ( 1,353.53) 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 119,226.75 0.00 622,077.09 0.00 3,053,522.91 16.92 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Police Administration % OF YEAR COMPLETED: 66.67 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 0.00 0.00 0.00 0.00 0.00 0.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,369,746.00 0.00 0.00 11,918.00 0.00 2,357,828.00 0.50 _________________________________________________________________________________________________________________________________ TOTAL Police Administration 2,369,746.00 0.00 0.00 11,918.00 0.00 2,357,828.00 0.50 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Fire Administration % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Public Works % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Storm Drainage % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Water Supply % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 7 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Other Capital Outlay % OF YEAR COMPLETED: 66.67 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 125,300.00 0.00 0.00 0.00 0.00 125,300.00 0.00 4970-54-2500 TE Grant City Share 71,250.00 1,686.00 0.00 22,665.34 30,608.81 17,975.85 74.77 TOTAL CAPITAL OUTLAY 196,550.00 1,686.00 0.00 22,665.34 30,608.81 143,275.85 27.10 _________________________________________________________________________________________________________________________________ TOTAL Other Capital Outlay 196,550.00 1,686.00 0.00 22,665.34 30,608.81 143,275.85 27.10 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 8 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Cultural & Recreation % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 9 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Lifeguards % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 10 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Beach Related % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 11 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Museums % OF YEAR COMPLETED: 66.67 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 17,420.88 0.00 34,378.48 0.00 565,621.52 5.73 TOTAL OTHER COSTS 600,000.00 17,420.88 0.00 34,378.48 0.00 565,621.52 5.73 _________________________________________________________________________________________________________________________________ TOTAL Museums 600,000.00 17,420.88 0.00 34,378.48 0.00 565,621.52 5.73 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 12 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Recreation Facilities % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 13 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Zoning and Inspection % OF YEAR COMPLETED: 66.67 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 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 Zoning and Inspection 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 14 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Community Development % OF YEAR COMPLETED: 66.67 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 1,643.97 0.00 13,504.03 0.00 16,495.97 45.01 TOTAL CAPITAL OUTLAY 30,000.00 1,643.97 0.00 13,504.03 0.00 16,495.97 45.01 _________________________________________________________________________________________________________________________________ TOTAL Community Development 30,000.00 1,643.97 0.00 13,504.03 0.00 16,495.97 45.01 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 15 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Debt Service % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 16 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 320-SPLOST Fund Other Financing Uses % OF YEAR COMPLETED: 66.67 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 20,750.85 0.00 96,423.29 30,608.81 3,548,567.90 3.46 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund REVENUES % OF YEAR COMPLETED: 66.67 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 0.00 0.00 0.00 0.00 0.00 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 0.00 0.00 36,935.17 0.00 ( 35,854.64) 418.25 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 0.00 0.00 20,982.66 0.00 ( 19,902.13) 941.89 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Finance % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Grant 2011 % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Police Administration % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Public Works % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Other Capital Outlay % OF YEAR COMPLETED: 66.67 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 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 Other Capital Outlay 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 7 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Cultural & Recreation % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 8 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Beach Related % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 9 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 340-Grant Fund Better Hometown % OF YEAR COMPLETED: 66.67 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 0.00 0.00 1,078.96 0.00 1.57 99.85 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 505-Water-Sewer Fund REVENUES % OF YEAR COMPLETED: 66.67 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 154.20 0.00 642.03 0.00 ( 642.03) 0.00 00-34.4210 Water charges 1,150,000.00 66,181.96 0.00 620,020.18 0.00 529,979.82 53.91 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 100,090.92 0.00 819,137.76 0.00 530,862.24 60.68 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 103.00 0.00 17,801.00 0.00 2,199.00 89.01 00-34.6904 Delinquent Charges 50,000.00 3,180.00 0.00 24,045.00 0.00 25,955.00 48.09 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 525.00 0.00 4,585.00 0.00 3,415.00 57.31 TOTAL CHARGES FOR SERVICES 2,601,000.00 170,235.08 0.00 1,500,466.17 0.00 1,100,533.83 57.69 INVESTMENT INCOME 00-36.1000 Interest 18,000.00 1.32 0.00 25,227.81 0.00 ( 7,227.81) 140.15 TOTAL INVESTMENT INCOME 18,000.00 1.32 0.00 25,227.81 0.00 ( 7,227.81) 140.15 MISCELLANEOUS 00-38.1002 Tower Space Rental Revenue 120,000.00 12,884.79 0.00 110,138.14 0.00 9,861.86 91.78 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 291.00 0.00 109.00 72.75 TOTAL MISCELLANEOUS 125,400.00 12,916.79 0.00 114,321.49 0.00 11,078.51 91.17 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 183,153.19 0.00 1,679,963.86 0.00 1,102,436.14 60.38 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 505-Water-Sewer Fund Sewer Administration % OF YEAR COMPLETED: 66.67 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 13,122.98 0.00 109,320.31 0.00 57,227.69 65.64 4310-51-1300 Overtime Wages 12,000.00 0.00 0.00 3,938.90 0.00 8,061.10 32.82 4310-51-1400 Employee Benefits 3,000.00 187.50 0.00 1,625.00 0.00 1,375.00 54.17 4310-51-2100 Health Insurance Benefits 37,593.00 2,829.01 0.00 23,902.17 195.93 13,494.90 64.10 4310-51-2200 FICA Contributions 11,101.00 820.48 0.00 7,082.29 0.00 4,018.71 63.80 4310-51-2300 FICA Medicare Contributio 2,596.00 191.87 0.00 1,656.31 0.00 939.69 63.80 4310-51-2400 Retirement Contributions 11,522.00 960.14 0.00 7,681.12 0.00 3,840.88 66.66 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 18,111.98 0.00 160,805.75 195.93 86,581.32 65.03 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 2,200.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 0.00 0.00 8,637.90 5,190.50 11,171.60 55.31 4310-52-2110 Dumping Charges 25,000.00 2,234.25 0.00 14,360.18 7,475.20 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 0.00 0.00 1,974.29 0.00 3,025.71 39.49 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 1,973.47 0.00 45,996.11 4,327.95 31,675.94 61.37 4310-52-2205 Repair & Maint -Infrastru 35,000.00 0.00 0.00 22,523.84 0.00 12,476.16 64.35 4310-52-2320 Rental Equipment 21,000.00 11,708.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 650.00 0.00 4,841.73 3,994.89 6,163.38 58.91 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 0.00 0.00 1,052.00 0.00 2,948.00 26.30 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 18,765.72 0.00 183,782.33 23,188.54 98,827.49 67.68 SUPPLIES 4310-53-1100 Supplies & Materials 50,000.00 1,139.77 0.00 31,541.20 1,234.21 17,224.59 65.55 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,619.51 0.00 80,471.64 0.00 69,528.36 53.65 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 0.00 0.00 10,592.42 985.00 422.58 96.48 4310-53-1720 Uniforms 4,000.00 123.21 0.00 786.73 713.27 2,500.00 37.50 4310-53-1730 Ultraviolet Disinfection 15,000.00 2,463.88 0.00 4,296.34 4,209.00 6,494.66 56.70 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 505-Water-Sewer Fund Sewer Administration % OF YEAR COMPLETED: 66.67 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 12,346.37 0.00 130,801.77 7,141.48 98,556.75 58.33 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 52,800.00 0.00 26,400.00 66.67 TOTAL INTERFUND/INTERDEPARTMENT 79,200.00 6,600.00 0.00 52,800.00 0.00 26,400.00 66.67 DEPRECIATION/AMORTIZATIO 4310-56-1000 Depreciation 240,000.00 24,934.59 0.00 175,075.84 0.00 64,924.16 72.95 TOTAL DEPRECIATION/AMORTIZATIO 240,000.00 24,934.59 0.00 175,075.84 0.00 64,924.16 72.95 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,494.35 0.00 17,740.56 0.00 35,656.63 33.22 TOTAL DEBT SERVICE 53,397.19 4,494.35 0.00 17,740.56 0.00 35,656.63 33.22 _________________________________________________________________________________________________________________________________ TOTAL Sewer Administration 1,373,927.55 85,253.01 0.00 1,132,344.67 30,525.95 211,056.93 84.64 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 505-Water-Sewer Fund Water Administration % OF YEAR COMPLETED: 66.67 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,083.70 0.00 103,101.35 0.00 58,733.65 63.71 4410-51-1300 Overtime 12,000.00 851.64 0.00 7,403.30 0.00 4,596.70 61.69 4410-51-1400 Employee Benefits 3,000.00 187.50 0.00 1,312.50 0.00 1,687.50 43.75 4410-51-2100 Health Insurance Benefits 26,049.00 2,334.20 0.00 14,459.12 191.36 11,398.52 56.24 4410-51-2200 Social Security Contribut 10,778.00 805.50 0.00 6,863.76 0.00 3,914.24 63.68 4410-51-2300 FICA Medicare Contributio 2,521.00 188.38 0.00 1,605.22 0.00 915.78 63.67 4410-51-2400 Retirement Contributions 25,182.00 2,140.52 0.00 17,124.16 0.00 8,057.84 68.00 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,591.44 0.00 163,637.96 191.36 89,304.68 64.72 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 329.85 0.00 1,855.73 262.56 2,881.71 42.37 4410-52-2203 Repair & Maintain - Equip 35,000.00 2,388.37 0.00 12,193.68 0.00 22,806.32 34.84 4410-52-2205 Repair & Maint- Infrastru 85,000.00 502.17 0.00 57,852.92 170.00 26,977.08 68.26 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 829.81 0.00 5,446.80 3,903.43 2,649.77 77.92 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 0.00 0.00 450.00 0.00 1,550.00 22.50 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 397.52 0.00 3,424.36 0.00 1,575.64 68.49 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 4,447.72 0.00 87,389.63 4,375.99 90,598.25 50.32 SUPPLIES 4410-53-1100 Supplies & Materials 30,000.00 610.08 0.00 13,906.72 235.00 15,858.28 47.14 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 4,137.08 0.00 30,522.91 0.00 12,477.09 70.98 4410-53-1230 Electricity 30,000.00 3,062.39 0.00 22,693.85 0.00 7,306.15 75.65 4410-53-1270 Gasoline & Diesel Fuel 15,000.00 0.00 0.00 10,814.74 0.00 4,185.26 72.10 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 5 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 505-Water-Sewer Fund Water Administration % OF YEAR COMPLETED: 66.67 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 11,971.25 0.00 37,025.78 0.00 12,974.22 74.05 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 0.00 0.00 3,411.06 0.00 1,588.94 68.22 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 847.82 0.00 1,692.01 467.08 3,340.91 39.26 TOTAL SUPPLIES 183,500.00 20,628.62 0.00 120,332.79 702.08 62,465.13 65.96 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 52,800.00 0.00 26,400.00 66.67 TOTAL INTERFUND/INTERDEPARTMENT 79,200.00 6,600.00 0.00 52,800.00 0.00 26,400.00 66.67 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,370.32 0.00 26,901.27 0.00 12,856.93 67.66 4410-58-2300 Int Exp GEFA Loan L22WS 2 53,255.71 4,406.89 0.00 35,838.84 0.00 17,416.87 67.30 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,777.21 0.00 80,029.77 0.00 211,235.62 27.48 _________________________________________________________________________________________________________________________________ TOTAL Water Administration 1,345,463.26 58,044.99 0.00 557,740.15 5,269.43 782,453.68 41.85 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 6 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 505-Water-Sewer Fund Other Financing Uses % OF YEAR COMPLETED: 66.67 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 143,298.00 0.00 1,690,084.82 35,795.38 1,056,519.80 62.03 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 540-Solid Waste Fund REVENUES % OF YEAR COMPLETED: 66.67 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,301.38 0.00 285,198.61 0.00 152,701.39 65.13 00-34.4120 Recycling Program Charges 90,000.00 7,437.01 0.00 59,975.07 0.00 30,024.93 66.64 00-34.4130 Recycled Materials Revenue 10,000.00 208.95 0.00 3,075.09 0.00 6,924.91 30.75 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 47,947.34 0.00 348,248.77 0.00 189,651.23 64.74 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 47,947.34 0.00 348,248.77 0.00 250,436.23 58.17 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 540-Solid Waste Fund Solid Waste Collection % OF YEAR COMPLETED: 66.67 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 6.00 0.00 ( 6.00) 0.00 4520-52-2111 Residential Pick Up- Wast 479,000.00 47,802.79 0.00 333,971.17 0.00 145,028.83 69.72 4520-52-2112 Compactors 18,785.60 2,410.00 0.00 12,785.60 0.00 6,000.00 68.06 4520-52-2113 Republic Services- Compac 49,000.00 1,174.99 0.00 38,050.58 4,761.57 6,187.85 87.37 TOTAL SERVICES 546,785.60 51,387.78 0.00 384,813.35 4,761.57 157,210.68 71.25 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 6,600.00 0.00 3,300.00 66.67 TOTAL INTERFUND/INTERDEPARTMENT 9,900.00 825.00 0.00 6,600.00 0.00 3,300.00 66.67 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 52,212.78 0.00 391,413.35 4,761.57 160,510.68 71.17 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 540-Solid Waste Fund Recyclables Collection % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 540-Solid Waste Fund Other Financing Uses % OF YEAR COMPLETED: 66.67 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 52,212.78 0.00 391,413.35 4,761.57 202,510.08 66.17 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 555-Rivers End RV Pk & Campgr REVENUES % OF YEAR COMPLETED: 66.67 CURRENT CURRENT PRIOR YEAR Y-T-D TOTAL BUDGET % OF BUDGET PERIOD PO ADJUST. ACTUAL ENCUMBRANCE BALANCE BUDGET ----------------------------------------------------------------------------------------------------------------------------------- CHARGES FOR SERVICES 00-34.7500 ATM Transactions 0.00 ( 2,000.00) 0.00 ( 2,000.00) 0.00 2,000.00 0.00 00-34.7520 Camping Fees 595,000.00 31,410.02 0.00 338,026.09 0.00 256,973.91 56.81 00-34.7521 Tent Site Rents 50,000.00 507.50 0.00 25,378.72 0.00 24,621.28 50.76 00-34.7522 Cabin Rental Taxable (13%) 110,000.00 3,427.00 0.00 59,135.77 0.00 50,864.23 53.76 00-34.7525 Camp Site Reservations 175,000.00 21,246.74 0.00 106,726.17 0.00 68,273.83 60.99 00-34.7527 Ice Revenues 7,550.00 68.65 0.00 3,320.45 0.00 4,229.55 43.98 00-34.7528 Propane Revenues 18,000.00 2,165.56 0.00 12,215.86 0.00 5,784.14 67.87 00-34.7529 RV Supplies Revenue 8,800.00 257.21 0.00 4,276.80 0.00 4,523.20 48.60 00-34.7530 Store Revenue 52,000.00 1,446.31 0.00 20,477.12 0.00 31,522.88 39.38 00-34.7531 Electricity Fees 1,750.00 928.10 0.00 2,034.36 0.00 ( 284.36) 116.25 00-34.7532 Vending Machine Revenue 5,000.00 291.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 443.30 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 2,073.30 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 TOTAL CHARGES FOR SERVICES 1,027,875.00 62,264.69 0.00 580,755.88 0.00 447,119.12 56.50 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 62,264.69 0.00 580,755.88 0.00 447,119.12 56.50 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 555-Rivers End RV Pk & Campgr River's End RV Park % OF YEAR COMPLETED: 66.67 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 13,774.01 0.00 111,763.67 0.00 82,773.24 57.45 6180-51-1200 Part Time/Seasonal Wages 35,837.09 2,015.79 0.00 24,680.53 0.00 11,156.56 68.87 6180-51-1300 Overtime 6,000.00 69.83 0.00 3,021.67 0.00 2,978.33 50.36 6180-51-1400 Employee Benefits 1,500.00 125.00 0.00 1,000.00 0.00 500.00 66.67 6180-51-2100 Health Insurance Benefits 33,482.00 2,073.05 0.00 15,723.46 227.69 17,530.85 47.64 6180-51-2200 Social Security Contribut 14,953.00 986.27 0.00 8,668.31 0.00 6,284.69 57.97 6180-51-2300 Medicare Contributions 3,497.00 230.67 0.00 2,027.36 0.00 1,469.64 57.97 6180-51-2400 Retirement Contributions 25,372.00 2,114.27 0.00 16,914.16 0.00 8,457.84 66.66 6180-51-2600 Unemployment Ins 3,300.00 2,310.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 23,698.89 0.00 190,994.73 227.69 131,151.15 59.32 SERVICES 6180-52-2110 Garbage Service 6,408.00 540.00 0.00 3,240.00 0.00 3,168.00 50.56 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,400.00 0.00 1,200.00 66.67 6180-52-2200 Pest Control 2,869.00 0.00 0.00 1,953.00 458.00 458.00 84.04 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 0.00 0.00 ( 51.10) 0.00 539.94 10.45- 6180-52-2203 Repair & Maintain - Bldgs 15,000.00 1,554.00 0.00 9,189.25 250.00 5,560.75 62.93 6180-52-2205 Repair & Maintain - Infra 22,507.98 0.00 0.00 20,538.55 0.00 1,969.43 91.25 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 0.00 0.00 7,319.54 1,002.21 3,178.25 72.36 6180-52-3220 Postage & Freight 817.83 0.00 0.00 349.76 0.00 468.07 42.77 6180-52-3300 Advertising 55,780.72 2,359.98 0.00 54,270.72 0.00 1,510.00 97.29 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 152.00 0.00 2,767.75 0.00 0.00 100.00 6180-52-3600 Dues & Fees 5,552.49 200.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 0.00 0.00 3,963.71 0.00 5,758.22 40.77 6180-52-3901 Credit Card Charges 19,000.00 1,314.88 0.00 11,506.18 0.00 7,493.82 60.56 6180-52-3950 Lodging Compensation 641.85 0.00 0.00 0.00 0.00 641.85 0.00 TOTAL SERVICES 165,809.69 6,420.86 0.00 128,856.23 1,864.97 35,088.49 78.84 SUPPLIES 6180-53-1100 Supplies & Materials 43,543.00 1,511.22 0.00 37,213.61 843.63 5,485.76 87.40 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,161.17 0.00 15,349.52 0.00 4,612.48 76.89 6180-53-1220 Propane 2,130.82 105.82 0.00 1,063.09 113.80 953.93 55.23 6180-53-1230 Electricity 74,832.15 6,079.82 0.00 34,936.16 0.00 39,895.99 46.69 6180-53-1270 Gasoline & Diesel 900.00 0.00 0.00 427.23 0.00 472.77 47.47 6180-53-1520 Propane RV Park-COGS 12,000.00 1,458.36 0.00 5,285.34 1,270.82 5,443.84 54.63 6180-53-1595 Camp Store Groceries-COGS 25,600.00 10,803.68 0.00 20,692.10 631.97 4,275.93 83.30 6180-53-1596 Camp Store-RV Supplies CO 12,000.00 5,823.07 0.00 12,052.14 ( 2,903.26) 2,851.12 76.24 6180-53-1600 Small Equipment 36,049.31 0.00 0.00 6,209.31 0.00 29,840.00 17.22 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 555-Rivers End RV Pk & Campgr River's End RV Park % OF YEAR COMPLETED: 66.67 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 ( 5.00) 0.00 ( 4.38) 0.00 4.38 0.00 6180-53-1720 Uniforms 603.05 555.55 0.00 603.05 0.00 0.00 100.00 TOTAL SUPPLIES 230,845.33 27,493.69 0.00 136,136.52 ( 43.04) 94,751.85 58.95 CAPITAL OUTLAY 6180-54-1100 Capital Improvements 56,138.50 21,347.50 0.00 49,338.50 18,143.40 ( 11,343.40) 120.21 6180-54-2200 Vehicles 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 56,138.50 21,347.50 0.00 49,338.50 18,143.40 ( 11,343.40) 120.21 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 137,012.50 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,333.28 0.00 1,666.72 72.22 TOTAL DEBT SERVICE 287,356.67 137,554.16 0.00 285,689.95 0.00 1,666.72 99.42 _________________________________________________________________________________________________________________________________ TOTAL River's End RV Park 1,062,523.76 216,515.10 0.00 791,015.93 20,193.02 251,314.81 76.35 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 555-Rivers End RV Pk & Campgr Debt Service % OF YEAR COMPLETED: 66.67 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 216,515.10 0.00 791,015.93 20,193.02 251,314.81 76.35 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT *** 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 745-Municipal Court Fund REVENUES % OF YEAR COMPLETED: 66.67 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 9,701.15 0.00 84,251.20 0.00 77,132.59 52.21 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 9,701.15 0.00 84,251.20 0.00 77,132.59 52.21 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 9,701.15 0.00 84,251.20 0.00 77,132.59 52.21 ============== ============ ============ ============= ============ ============ ====== 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 745-Municipal Court Fund Municipal Court % OF YEAR COMPLETED: 66.67 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 4,190.78 0.00 29,674.22 0.00 7,358.78 80.13 2650-57-1002 Victim Witness LVAP 18,426.00 2,076.73 0.00 14,660.81 0.00 3,765.19 79.57 2650-57-1003 Brain & Spinal BSITF 6,599.00 1,229.50 0.00 4,718.00 0.00 1,881.00 71.50 2650-57-1004 POAB & GSCCCA Fund 88,234.79 11,184.32 0.00 75,820.01 0.00 12,414.78 85.93 2650-57-1005 PO Drivers Educ. DETF 7,286.00 1,228.02 0.00 6,530.01 0.00 755.99 89.62 2650-57-1006 GA Crime Victims- CVEF 1,955.00 366.00 0.00 1,380.00 0.00 575.00 70.59 2650-57-1007 State Probation Fee 1,850.00 430.00 0.00 1,478.00 0.00 372.00 79.89 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 20,705.35 0.00 134,261.05 0.00 27,122.74 83.19 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 20,705.35 0.00 134,261.05 0.00 27,122.74 83.19 4-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 745-Municipal Court Fund Police Administration % OF YEAR COMPLETED: 66.67 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-01-2013 11:31 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 FINANCIAL STATEMENT - UNAUDITED AS OF: FEBRUARY 28TH, 2013 745-Municipal Court Fund Debt Service % OF YEAR COMPLETED: 66.67 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 20,705.35 0.00 134,261.05 0.00 27,122.74 83.19 ============== ============ ============ ============= ============ ============ ====== *** END OF REPORT ***