Loading...
HomeMy Public PortalAbout20170426Packet.pdf AGENDA BUDGET WORKSHOP OF TYBEE ISLAND CITY COUNCIL APRIL 26, 2017 3:30pm Please silence all cell phones during Council Meetings I. Budget – General Fund II. Adjournment *PLEASE NOTE: Citizens wishing to speak on items listed on the agenda, other than public hearings, should do so during the citizens to be heard section. Citizens wishing to place items on the council meeting agenda must submit an agenda request form to the City Clerk’s office by Thursday at 5:00PM prior to the next scheduled meeting. Agenda request forms are available outside the Clerk’s office at City Hall and at www.cityoftybee.org. THE VISION OF THE CITY OF TYBEE ISLAND “is to make Tybee Island the premier beach community in which to live, work, and play.” THE MISSION OF THE CITY OF TYBEE ISLAND “is to provide a safe, secure and sustainable environment by delivering superior services through responsible planning, preservation of our natural and historic resources, and partnership with our community to ensure economic opportunity, a vibrant quality of life, and a thriving future.” CITY OF TYBEE ISLAND CITY COUNCIL 1ST BUDGET WORKSHOP FOR GENERAL FUND OPERATING & CAPITAL BUDGET APRIL 26, 2017 @ 3:30 PM CITY HALL AUDITORIUM AGENDA Budget Highlight Item No.Department Budget Highlight Report Page No. Financial Report Page No. Revenue 3-5 3-5 1 City Council 4 6 2 Clerk of Council 4 8 3 City Manager 5 9 4 Finance Department 5-6 10-15 5 Legal 6 16 6 Information Technology Department 6 17-18 7 Human Reources Department 7 19 8 Public Works - Building Maintenance 7 20 9 Municipal Court 7 21 10 Police - Administration Department 7 22-23 11 Police - Beach Patrol Division 8 24 12 Fire - Administration Department 8 26-27 13 Emergency Management 8 28 14 Public Works - Adminstration Department 9 29-30 15 Public Works Storm Drainage 9 32 16 Public Works Solid Waste Collection 9 32 17 Public Works Cultural & Recreation Division 9 33 18 Non - Profits Agencies 10 34 19 YMCA 10 35 20 Fire - Ocean Rescue Division 10 36 21 Beach Related 10 37 22 Non-Profit Museums 10 38 23 Public Works Parks Administration Division 10 40 24 North Beach Concession Stand 10 41 25 Parkways and Boulevards 11 42 26 Planning & Zoning Department 11 43-44 27 Main Street Department 11 45 28 South Business District 11 46 29 Parking Services Division 11 47-48 30 Debt Service 11 49 31 Other Financing Uses 12 50 CITY OF TYBEE ISLAND FISCAL YEAR 2017-2018 PROPOSED OPERATING AND CAPITAL BUDGET GENERAL FUND APRIL 26, 2017 1 General Fund FY18 Budget Highlights April 24, 2017 CITY OF TYBEE ISLAND FISCAL YEAR 2017-2018 PROPOSED OPERATING AND CAPITAL BUDGET GENERAL FUND BUDGET HIGHLIGHTS The General Fund budget request for fiscal year 2017-2018 is $ 12,173,432. The budget decreased by a net amount of ($1,116,543) from the current year’s amended budget of $13,289,975. The budget includes an increase of $231,977 is related to the addition of five new employee positions shown below: Department\Position Name Position Grade Salary/Fica/Medicare Information Technology Support Specialist Grade 107 57,884.00$ Planning & Zoning Adm Specialist Grade 105 -$ Fire Department Firefighter Grade 106 49,608.00$ Firefighter Grade 106 49,608.00$ Firefighter Grade 106 49,608.00$ Subtotal 148,824.00$ Parking Services Parking Enforcement 25,269.00$ Total Budget for New Positions General Fund 231,977.00$ DEPARTMENTS REQUESTED POSITIONS The consumer price index for calendar year 2016 was 2.5%. The proposed budget includes a 3% increase in salary, FICA and Medicare cost ($167,000 for all funds) for all full-time and permanent part-time positions in case cost of living or merit raises are granted. Currently, the City’s health insurance plan with Blue Cross Blue Shield of Georgia runs for 18 months, from July 1, 2016 through December 31, 2017. As of January 1, 2018, the health insurance premiums may increase as high as 60% due to particular circumstances and the uncertainty of the Affordable Care Act. The fiscal year 2018 budget includes a 23% or $232,983 increase in health insurance premiums for now. The City will have more precise cost of the health insurance premiums by October, 2017. 2 General Fund FY18 Budget Highlights April 24, 2017 The departments’ capital projects budgets increased by $590,620 from $702,480 to $1,293,100. The City’s capital projects budget for the departments’ is shown below: Department/Description Capital Budget Marsh Hen Trail - Pedestrian Path 586,500.00 Information Technology 15,000.00 Public Works - Building Maintenance 160,000.00 Police Department 148,000.00 Public Works - Adminstration 263,000.00 Public Works - Cultural & Recreation 32,100.00 Beach Related 25,000.00 Fire - Lifeguards 14,000.00 Parking Services 49,500.00 Total Capital Projects 1,293,100.00 The capital out lay budget did in include $125,000 in the Information Technology Department to acquire a Mobile Command Unit Truck; however, in an effort to reduce the budget it has been removed, but the department wishes for that the City Council considers including it in the budget. The table below explains than information included in the budget request report. COLUMN TITLE COLUMN DESCRIPTION FY2015 Actual =Represents the fiscal year 2014-2015 actual audited revenue or expense balances for each line item in the fund. FY 2016 Actual =Represents fiscal year 2015-2016's actual audited year-to-date revenues or expenses for each line item. FY2017 Current Budget =Represents fiscal year 2016-2017's current budget for each line item in the department's budget. FY2017 Year-to-Date =Represents fiscal year 2015-2016's year-to-date and encumbered revenues or expenses for each line item. FY2018 Proposed Budget =Represents the Department Head’s fiscal year 2018 proposed budget request. Budget Change 2017 vs. 2018 =Represents the difference between the current budget (blue) and the department’s budget request for FY18 3 General Fund FY18 Budget Highlights April 24, 2017 General Fund Department Revenues - Pages 3 to 5 Taxes - Budget $4,096,300 increased by $191,150 • 100.00.31.1100 - Real Property Tax (current) is expected to increase by $50,000 due to improvements made to property post-hurricane damage; • 100.00.31.1310, Motor Vehicle Tax Tag Settlement – will decrease by ($13,000) • 100.00.31.1315, TAVT Motor Vehicle Tax, will decrease by ($10,000); • 100.00.31.1710, Franchise – Electric may increase by $23,000; • 100.00.31.1340, Personal Property Intangible by $30,000; • 100.00.31.1750, Cable TV may increase by $25,000; • 100.00.31.3100, Sales & Use Tax Revenue (LOST) $70,000; • 100.00.31.3103, Energy Excise Tax may increase by $1,300; • 100.00.31.4300, Alcohol 3% Tax may increase by $15,000; • 100.00.31.4300, Local 3% Alcohol Tax by $10,000; Licenses & Permits - Budget $228,000 increased by $400 • 100.00.32.2990, Engineering Review decreased by ($800); • 100.00.32.3101, Building Permits increased by $2,000; • 100.00.32.3120, Building Inspections, decreased by ($ 3.000); • 100.00.32.3200, Filming Permit, decreased by ($1,000); • 100.00.32.3900, Zoning Variance Requests decreased by ($1,500); • 100.00.32.3901, Recording Fees decreased by ($800); and • 100.00.32.3912, Short-term Registration increased by $4,000; Intergovernmental - Budget $244,000 decreased by ($44,208) • 100.00.33.1010, Coastal Incentive Grant, decreased by ($30,000) due to completion of the grant; and • 10100.00.33.1025, Grant –DNR – decreased ($14,400) due to completion of the grant. Charges for Service - Budget $3,281,100 increased by $125,530 • 100.00.34.1910, Election Qualifying Fees increased by $600 due to it being an election year; • 100.00.34.2900, Chatham County Salary Reimbursement, increased by $5,000 based on prior years actual; • 100.00.34.2906, Parking Cost Reimbursement decreased by ($13,000) due to decreased motion picture filming; • 100.00.34.4150, City Dump Revenue, increased by $4,000 based on current years actual collection; • 100.00.34.5415, Parking Revenue Meters budget is reallocated and included in the 100.00.34.5418, Parking Rev – Pay/Display line item due to the manner that the money is counted the coins from the parking meters cannot be separated from the coins collected from the pay & display machines; • 100.00.34.5418, Parking Pay/Display/Parking Meter increased $145,000 due to free parking and increase in tourism due to advertising on the Today Show identifying Tybee is as having the best beach; • 100.00.34.7502, Concession Stand Sales – decreased to $0 due to the stand not being in operation this summer; and • 100.00.34.7532, Vending Machine sales – decreased to $0 due to the City not operating the concession stand this summer. 4 General Fund FY18 Budget Highlights April 24, 2017 Fines and Fees - Budget $792,000 decreased by ($82,000) • 100.00.35.1170, Fines and Fees, decreased by ($70,000); • 100.00.35.1176, Late Fees – Park - decreased by ($10, 000); and • 100.00.35.1900. Other Fines Police/Court decreased by ($2,000). Miscellaneous Revenue - Budget $78,301 increased by $4,400 • 100.00.38.1006, Lease North Beach Grill, increase by $48,600 due to monthly rent increase closer to market value; • 100.00.38.1010, Cremation Wall, decreased by ($100); • 100.00.35.1176, Late Fees – Park - decreased by ($10, 000); • 100.00.38.3000, Damaged Property Reimbursement decreased to $0; and • 100.00.38.3526. Miscellaneous Revenue decreased by ($44,000). Other Financing Sources - Budget $3,438,731 decreased by ($1,308,815) • 100.00.39.1100, Transfer in from Fund 220, Grant Fund decreased by ($157,000); • 100.00.39.1200, Transfer in from Hotel-Motel Fund increased by $27,501 from $1,385,000 to $1412,501; • 100.00.39.1300, Prior Year Fund Balance decreased by ($1,179,316) from $3,205,546 to $2,026,230. This line item is used to balance the difference between the expenditure over revenue shortage; the money will come from the City’s fund balance. General Fund Department Expenditures 1. City Council Department: Page 6 - $235,245 City Council budget increased by $11,015 from $224,230 to $ 235,245 due to the following reasons: • 100-1110-52-3507 Travel – Paul Wolff decreased by ($1,500), the City Council agreed to reimburse the former council member for travel because he serves on committees as the City’s liaison; • 100-1110-52-3710 Travel – Julie Livingston decreased by ($800.00) • 100-1110.52-3600 Dues & Membership fees increased by $1,000; • 100-1110.52-3711 Education – John Mayor increased by $1,800; • 100-1110.57-2100 Flowers increased by $100 2. Clerk of Council Department: Page 8 - $108,335 The City Clerk’s budget increased by $4,505 from $103,830 to $108,335 due to the following: • 100.1130.51-1100 Salaries & Wages increased by $2,752 for cost of livings or merit increase; • 100.1130.51-1400 Employee Benefits increased by $1,800 to provide Clerk with a car allowance of $150 per month; • 100.1130.51-2100 Health insurance increased by $1,471 due to pending insurance increase in Jan. 2018; • 100.1130.51.2400 Retirement contributions decreased by ($481) because the annual contribution declined; and • 100-1130-53-1100 Supplies & materials decreased by ($1,000). 5 General Fund FY18 Budget Highlights April 24, 2017 3. City Manager Department: Page 9 - $278,287 The City Manager’s budget decreased by ($10,384) from $288,671 to $278,287 due to the following: • 100.1320.51.1100 Salary & Wages increased by $21,710 due to increase new City Manager’s salary being higher than the previous City Manager’s salary; • 100.1320.51.2100 Health Insurance increased by $16,365 due to 23% increase in premiums and the change in premium coverage from employee and spouse to family coverage; • 100.1320.52.1300, Contract Services, decreased by ($55,000) as this line item was used to pay Greenline Architects & Engineers for planning the renovations of the city hall building as well as other items; • 100.1320.52.3220, Postage/Freight increased by $1,400 from $1,400 to $2,800 to pay for mailing the short term registration forms; • 100.1320.53.1100, Supplies & Materials, increased by $1,500 from $1,500 to $3,000 in provide the new City Manager with any necessary items; • 100.1320.53.1600, Small Equipment, $4,000 – a budget was established to allow the new City Manager to purchase any items needed; and • 100.1320.53.1720, Uniforms, $200 is added to allow the City Manager to purchase City logo shirts. 4. Finance Department: Pages 10-15 - $515,743 The Finance Department’s budget increased by$18,188 from $497,555 to $515,743 due to the following: Finance – Director – Budget $134,947, increased by $6,128 • 100.1510.51.1100 – Salary & Wages increased by 3% for cost of living or merit increase; • 100.1510.51.2100 – Health Insurance increased by 23% due to the premium increasing in January 2018; • 100.1510.51.2200 – FICA increased by 3% due to cost of living or merit increases; • 100.1510.51.2300 – Medicare increased by 3% due to cost of living or merit increases; and • 100.1510.51.2400 – Retirement decreased by .018% Finance – Accounting – Budget $302,806, increased by $37,155 • 100.1512.51.1100 – Salary & Wages increased by 3% for cost of living or merit increase; • 100.1512.51.2100 – Health Insurance increased by 23% due to the premium increasing in January 2018; • 100.1512.51.2200 – FICA increased by 3% due to cost of living or merit increases; • 100.1512.51.2300 – Medicare increased by 3% due to cost of living or merit increases; and • 100.1512.51.2400 – Retirement decreased by .018%; 100.1512.52.1221 – Auditing Accounting Fees increased by $7,100 to pay for the Single Audit reporting requirements and the inclusion of an another Special Revenue Fund; • 100.1512.52.3100 – Property & Liability Insurance, $400 is added to pay for GIRMA insurance • 100.1512.52.1105, County Tax Billing Admin Fee, $25,000 used to pay for Chatham County managing the bi- annual billing and collection of the City’s real and personal property taxes; • 100.1512.52.1300, Service Contracts, $35,788 – Finance is carrying forward the $28,000 contract with GFOA whose performing the reserve risked based analysis; • In the Accounting Division, Advertisement, 100.1512.52.3300, is used to pay for the advertising the budget, SPLOST reports, and property taxes. The ad’s cost up to $1,800 per ad for a full page; • 100.1512.52.3400 – Printing & Binding, $ 1,200 is used to pay for printing check stock as needed; • 100.1512.52.3500 – Travel & Related, $4,000 is used to pay for stay finance, payroll, accounts payable and GASB training seminars; • 100.1512.52.3850 – Contract Labor, $20,000 is used to pay for contract labor, and general administrating needs; • 100.1512.52.3990 – Service Charges, Late Fee, $40,000 increased by $5,000 due to the addition of another merchant services accounts for a credit card machine used by the Parking Service Division; 6 General Fund FY18 Budget Highlights April 24, 2017 • 100.1512.53.1600 – Small Equipment, $5,000 used to pay for a new updated credit card machine for Cashier; purchase laptop and a desktop printer for the Accountant; and • 100.1512.55.1010 – Indirect Allocation – Accounting – ($125,028) used to allocate cost relating to providing accounting services to the water & sewer department, solid waste collection fund and the rivers’ end RV campground and park fund. Finance Revenue Division – Budget, $0 • Moved the personnel cost to Finance – Payroll Division Finance Accounts Payable Division – Budget, $34,167 The cost related to processing invoices will increase by $475 due to reduction of Postage & Freight (100.1517.52.3220) by ($2,000); Supplies & Material (100.1517.53.1100) decreased by ($1,700); and Personnel Cost increased by 3% due to cost of living or merit increases. Finance Payroll Division – Budget, $44,523 The budget increased by $30,187.00 because currently one employee’s salary and benefits is split between the Revenue Division (68%) and the Payroll Division (32%), for FY2018 the salary is only included in the payroll division’s budget. 5. Legal: Page 16 - $246,605 The legal expenditures’ budget is $246,605, a decrease of ($5,395) over the current year’s budget • 100.1530.1203, Legal - The City’s contracts out the city attorney services to Callaway, Braun, Riddle & Hughes, P.C; although the current fiscal year budget is $246,000. The budget for next fiscal year is $240,000 • 100.1530.55.5500, Insurance Deductibles – GIRMA, $4,605 – This covers the City’s $1,000 deductibles with our liability insurance company, GIRMA. 6. Information Technology Department: Page 17-18 $606,338 The IT Department’s budget increased by $49,182 from $557,156 to $606,338 due to the following: • Personnel: Salary and Benefits increased by $64,805 due to the addition of a new position, 3% increase for a cost of living or merit increase and due to a 23% increase in the health insurance. • Purchased Contract Services decreased by ($2,140) from $326,700 to $324,560 primarily due to the following: o 100.1535.52.1300, Service Contracts – o 100.1535. 52.2320, Rent – Equipment & Vehicles, $14,000, increased by $2,500 for rental of new mail machine o 100.1535.52.3700, Education and training, $5,000 increase by $2,000 to go back to school for training; o 100.1535.53.1600, Small Equipment $30,000 to purchase iPad, ups, access points, cams, cradle points and nas. • Capital Outlay’s budget remains the same from amount, $15,000 o 100.1535.54.2400, $15,000 to purchase computers for departments and upgrade the Microsoft Packages to version, 2016. o IT removed the $125,000 capital item to purchase a mobile command unit that can be used during an evacuation of the City. 7 General Fund FY18 Budget Highlights April 24, 2017 7. Human Resources Department: Page 19 - $115,570 The HR Department’s budget had a net change increase of $3,395 from $112,175 to $115,570 primarily due to 3% increase in salary, FICA & Medicare for a cost of living or merit increase and for a 23% increase in health insurance. 8. Public Works – Building Maintenance: Page 20 - $ 598,746 The Public Works Department’s Building Maintenance Division budget increased by $290,756 from $307,990 to $ 598,746 primarily due to the following: • Personnel Cost increased by $19, 966 to include a 3% increase in salary, FICA & Medicare for a cost of living or merit increase and for a 23% increase in health insurance. • Purchased\Contracted Services increased by $ 120,790 from $72,010 to $ 192,800 due to the following: o 100.1565.52.2130, Custodial City Hall Building, budget increased by $133,400 from $6,600 because the City Council wants to consider outsourcing the janitorial cleaning services for all City Buildings with the exception of the Rivers End RV Campground and Park and the restrooms at the North Beach Concession Stand; and o 100.1565.52.3100, Property & Liability insurance decreased by ($ 12,310). 9. Municipal Court: Page 21 - $ 167,234 The Municipal Court’s budget increased by $11,265 from $155,969 to $167,234 primarily due to the following: • Personnel Cost increased by $10,665 to include a 3% increase in salary, FICA & Medicare for a cost of living or merit increase and for a 23% increase in health insurance. • Purchased\Contracted Services increased by $600 from $19,600 to $ 20,200 due to the following: 100.2650.52.1385, Custody – Food Supplies, budget of $600 was added to this department from the Police Department’s Administrations budget. 10. Police Administration Department: Page 22-23 - $2,421,133 Police administration budget increased by $189,604, from $2,279,993.27 to $ 2,421,133 due to the following: • Personnel Costs increased by $92,254 due to a 3% increase for a cost of living or merit raise; 23% increase for health insurance premium raise and a .018% decrease in retirement contribution; • Purchased\Contracted Services has a net decrease of ($17,500) due to the following: o 100.3210.52.1300 – Equipment Service Contracts, $20,000 MDS annual maintenance for $3,928 and Tyler Software Annual Maintenance; o 100.3210.52.2201, Repair/Maint – Building, increased by $2,000 for repairs due to aging building; o 100.3210.52.2202, Repair/Maint – Vehicles, increased by 3,000 due to more vehicles added to fleet; o 100.3210.52.2320,Rent- Equipment & Vehicles, $5,000 needed for Orange Crush weekend; o 100.3210.52.3100, Property & Liability Insurance, $12,000 increased due to $30,000 increase in premium because of claims filed; and o 100.3210.52.3700, Education and Training, $17,500 additional officers will need to recertify. • Supplies increased by $7,850 from $ 222,730 to $ 230,580 due to the following: o 100.3210.53.1600, Small Equipment, increased by $10,000 for new LIDAR/PBT’s; o 100.3210.53.1616, Small Equipment-radios & Tasers, $44,150 for new radios and encryption of older radios; o 100.3210.54.2100, Capital Equipment, $ 35,000 for 3 new beach vehicles and for Animal Control’s uses; and • Capital Outlay increased by $107,000 from $41,000 to $ 148,000 due to the following: o 100.3210.54.2200, Vehicles, increased by $110,000 for new transport van and 2 new patrol units. 8 General Fund FY18 Budget Highlights April 24, 2017 11. Police Park Beach Patrol Division: Page 24 - Budget $364,901 Police Park (Beach) Patrol Division Police Park Patrol budget increased by $9,427 from $355,474 to $355,474 due to the City adding 2 new full time police officer positions and 4 part-time beach ambassador positions. 12. Fire Administration Department: Page 26-27 - $695,866 The Fire Administration Department’s budget increased by $200,900, from $494,966 to $ 695,866 due to the following: • Personnel Costs increased by $182,301 due to o a 3% increase for a cost of living or merit raise; o 23% increase for health insurance premium raise; o a .018% decrease in retirement contribution; and o 3 full-time firefighter positions were added for total costs of $148,824. • Purchased\Contracted Services has a net increase of $12,040 due to the following: o 100.3510-52-2201- Building maintenance- $15,000- expand the sleeping quarters for new employees and updates showers in sleeping quarters; o 100.3510.52.3100, Property & Liability Insurance, $30,000 increased by $7,000 due to claims from FY2016; • Supplies has a net increase of $6,559 due to the following: o 100.3510-53-1602- Hose and accessories- $6,000- Replace the 5’ LDH on Ladder 5. The Fire Department found a lot of cracks in the jacket that will cause a catastrophic failure if not replaced. o 100.3510-53-1720- Uniforms-$8,000- Ordering New Class A uniforms for career guys and certified volunteers. Uniforms for new employees; and o 100.03510-53-1100 – Supplies and Materials – $9,000-new station furniture and supplies if we get new employees • Capital Outlay has a net increase of $6,559 due to the following: o Gear Extractor-$8,000- This will help keep gear clean and help protect firefighters. NFPA 1851 wants geared cleaned at least 2 times a year. This will help prolong the life of turnout gear. 13. Emergency Management Department: Page 28 - $81,773 Emergency Management’s budget increased by $14,786, from $66,987 to $81,773 due to the following: • Personnel Costs increased by $3,258 due to o A 3% increase for a cost of living or merit raise; o A 23% increase for health insurance premium raise; and o A .018% decrease in retirement contribution. • Purchased\Contracted Services has a net increase of $11,015 due to the following: 100.3920-52-3225- CRS – Flood Awareness program, $12,000 • Supplies have a net increase of $513 in order to purchase more storm supplies. 9 General Fund FY18 Budget Highlights April 24, 2017 14. Public Works Administration Department: Page 29-30 - $1,894,136 Public Works Administration budget increased by $89,489 from $1,804,647 to $1,894,136 due to the following: • Personnel Costs increased by $102,339 due to o A 3% increase for a cost of living or merit raise; o A 23% increase for health insurance premium raise; o A .018% decrease in retirement contribution; o Overtime increased by $27,800 from $14,200 to $ 42,000. • Purchased\Contracted Services has a net decreased by a net amount of ($2,925). • Supplies have a net decrease by ($9,925) due to the decrease in the number of signs purchased. Capital Outlay budget remains that same amount as the current year’s budget which is $263,000; o 100.4210.54.1410, Infrastructure, $ 83,000, for road projects and match for the LMIG Grant; o 100.4210.54.1416, Infrastructure – LMIG Grant, $40,000 for annual road projects approved by the GDOT; o 100.4210.54.2100, Machinery & Equipment, $75,000 for ADS – Flexstorm EL HD Square X 100; and o 100.4210.54.2200, Vehicles, $65,000 for a heavy duty dump truck. The schedule below shows are other capital projects items that the Public Works Department listed a capital outlay needs for fiscal year 2018, but these items are not included in the budget. Some discussions took place during the April 17, 2017 Budget Workshop regarding seeking financing for the $186,000, Street Sweeper and $75,000 Heavy Duty Dump Truck. PROJECT DESCRIPTIONS Grand Total FY2018 Projects GeparPmenP of PuNlic Jorks Sweeper 186,000 12 Cots, 39 cases (12/case) of meals w/heaters 3,820 Storm Drain CIPP - Captain's Row 66,138 Cues QZ II Pole Camera 12,200 z-Spray Max - 16HP Vanguard, 60 gal spray syst 11,131 Sprayer, Spreader, Seeder, Aerator & tank 1,500 2 New Restrooms 90,000 3 New Compators - Southend business & Yard 100,000 3 New Crossovers 60,000 0 0 TOTAL CIP:274,831 15. Public Works Storm Drainage Division: Page 32 - $12,000 Public Works Storm Drainage Division budget remains unchanged from the current year’s budget of $12,000. 16. Public Works Solid Waste Collection Division: Page 33 - $90,000 Public Works Solid Waste Collection Division budget decreased by ($60,000) from the current year’s budget of $150,000 because the current budget reflects the cost related to the hurricane clean up. 17. Public Works Cultural & Recreation Division: Page 34 - ($172,540 - $39,640) = $132,900 Public Works Cultural & Recreation Division budget increased by $1,000 due to increase in garbage collection costs. 10 General Fund FY18 Budget Highlights April 24, 2017 18. Non-Profit Agencies: Page 34 - $39,640 The non-profit agencies budgets are $39,640, an increase of $25. 19. YMCA: Page 135 - $168,950 The current budget for the YMCA recreation department is $168,950. 20. Fire – Ocean Rescue (Lifeguards) Division: Page 36 - $496,821 The Fire Ocean Rescue Division’s budget increased by $47,899, from $448,922 to $496,821 due to the following: • Personnel Costs increased by $38,891 due to o Marginal increases for annual raises given to returning employees; • Purchased\Contracted Services has a net decrease of ($2,989): • Supplies has a net increase of $12,997 due to the following: o 100.6124-53-1104- $10,000- First Aid - need to replace 3 AEDS o 100.6124-53-1100 General Supplies-$10,000- need more fins, mask and snorkels. Update scuba equipment for certified divers • Capital Outlay has a net decrease of ($1,000) due to the following: o 100.6124.54.2200, Vehicle, $14,000 is requested to purchase a kabuto. 21. Beach Related: Page 37 - $125,300 The Beach Related Division’s budget increased by $3,600, from $121,700 to $125,300 as compared to the current year’s budget. 22. Non-Profit Museums: Page 38 - $41,337 The non-profit museums agencies budget remains unchanged. 23. Public Works Parks Administration Division: Page 40 - $265,068 Public Works Parks Administration budget decreased by a net amount of ($5,582) from $270,650 to $265,068 due to the following: • Personnel Costs increased by $7,729 due to o A 3% increase for a cost of living or merit raise; o A 23% increase for health insurance premium raise; and o Overtime decreased by ($5,000) from $12,000 to $ 7,000. 24. North Beach Concession Stand: Page 41 - $78,300 The City’s restrooms and a concession stand facility budget is $ 78,300. After lost a little more than ($87,000) in operating the Concession Stand on its own, the City decided to lease the facility to a vendor who will be allowed to sale food. The budget includes the following: • 100.6222.52.2130, Custodial Services, $40,000; • 100.6222.52.2210, Pest Control, $300; • 100.6222.52.3100, Property & Liability Insurance, $ 3,000; • 100.6222.53.1210, Water/Sewer Charges, $ 30,000; and • 100.6222.53.1230, Electricity, $5,000. 11 General Fund FY18 Budget Highlights April 24, 2017 25. Parkways and Boulevards: Page 42 – $586,500 The purpose of this budget is to finance the Marsh Hill Pedestrian Trail. The total budget of $586,500 includes the following: 100.6230.54.1400, Infrastructure, $387,500 is the City’s share of for the project taken from the Greenspace Fund Balance account; and 100.6230.54.1417, Infrastructure – DOT Grant, $199,000 is the grant from the Georgia Department of Transportation that can be used for the construction cost. 26. Planning and Zoning Department: Page 43-44 - $298,767 Planning and Zoning Department budget decreased by a net amount of ($10,282) from $309,049 to $298,797 due to the following: • Personnel Costs increased by $19,758 due to o A 3% increase for a cost of living or merit raise; and o A 23% increase for health insurance premium raise; • Purchased\Contracted Services has a net decrease of ($30,040) due to completion of the master plan study. 27. Main street Department: Page 45 - $100,489 The Main street Department budget decreased by a net amount of ($9,910) from $110,399 to $100,489 due to the following: • Personnel Costs increased by $1,146 due to o A 3% increase for a cost of living or merit raise; and o A 23% increase for health insurance premium raise. • Purchased\Contracted Services has a net decrease of ($11,056) due to completion of a grant study. 28. South Business District: Page 46 - $25,000 The South Business District budget decreased by a net amount of ($8,448) from $33,448 to $25,000 29. Parking Service Division: Page 47-48 - $608,848 Parking Department budget decreased by a net amount of ($236) from $609,084 to $608,848 due to the following: • Personnel Costs increased by $35,767 due to o A 3% increase for a cost of living or merit raise; o A 23% increase for health insurance premium raise; and o The addition of a new part-time permanent year round employee costing $25,230 annually. • Capital Outlay decreased by a net amount of ($38,500) due to the following: o 100.7564.54.2200, Vehicles, $ 15,000 for a new truck; and o 100.7564.54.2410, Capital Equipment, $ 34,500. 30. Debt Service: Page 49 - $9,550 This section of the budget should be used to report the principle and interest payment of all outstanding loans related to the General Fund. Debt service balance for FY2018 is $9,550 due to the following: • 100.8000.58.1145, principle – DPW, the loan from SunTrust for 2 pieces of equipment purchased for the Public Works Department is $9,530; and the interest expense, 100.8000.58.2230 is $20. This debt will be paid off in full in August of 2017. • The debt service for the telephone system will be paid off in June of 2017. 12 General Fund FY18 Budget Highlights April 24, 2017 31. Other Financing Uses: Page 50 - $ 763,350 This section of the budget is used to record transfers out of the General Fund to other funds. The transfers out of the General Fund budget decreased by ($2,253,358) from $3,016,708 to $763,350 due to the following: • 100.9000.61.1001, transfer out to the Solid Waste Collection Fund is increased by $1,524 from $262,526 to $264,050 because the yard waste removal service cost paid by the City for residents will be properly re- classified from the General Fund to the Solid Waste Collection Fund; therefore, the City must transfer the money into the Solid Waste Collection Fund as “other financing sources” revenue; • 100.9000.61.1002, transfer out to the emergency 911 telephone fund decreased by ($29,264) from $328,564 to $299,300; and • 100.9000.61.1555, transfer out to the River’s End RV Park Fund decreased by ($49,913) to $0 because the director came up with enough revenue for FY2018 to balance the fund’s budget. 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 1 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund FINANCIAL SUMMARY ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ REVENUES -------- TAXES 4,098,534.31 4,124,391.49 3,905,150.00 2,851,846.19 4,096,300.00 191,150.00 LICENSES & PERMITS 235,095.49 223,921.50 227,600.00 231,682.81 228,000.00 400.00 INTERGOVERNMENTAL 83,590.29 58,274.31 288,208.00 79,733.46 244,000.00 ( 44,208.00) CHARGES FOR SERVICES 3,168,311.97 3,411,952.13 3,155,570.00 2,107,007.40 3,281,100.00 125,530.00 FINES & FORFEITURES 865,565.44 857,906.45 874,000.00 246,053.50 792,000.00 ( 82,000.00) INVESTMENT INCOME 10,137.16 17,755.83 15,000.00 14,902.66 15,000.00 0.00 CONTRIBUTIONS & DONATIONS 375.00 410.00 3,000.00 200.00 0.00 ( 3,000.00) MISCELLANEOUS 90,203.29 39,263.12 73,901.00 71,799.78 78,301.00 4,400.00 OTHER FINANCING SOURCES 1,940,549.63 1,566,287.00 4,747,546.00 885,764.00 3,438,731.00 ( 1,308,815.00) TOTAL REVENUES 10,492,362.58 10,300,161.83 13,289,975.00 6,488,989.80 12,173,432.00 ( 1,116,543.00) ============== ============== ============== ============== ============== ============== EXPENDITURES ------------ Mayor and Council 177,705.39 204,164.61 224,230.00 160,640.76 235,245.00 11,015.00 Clerk of Council 92,664.09 97,006.26 103,830.00 73,750.33 108,335.00 4,505.00 City Manager 186,238.15 198,141.69 288,671.00 208,610.66 278,287.00 ( 10,384.00) Finance 119,801.78 119,897.60 128,819.00 102,216.91 134,947.00 6,128.00 Finance - Accounting 107,214.24 175,456.15 265,651.00 124,355.38 302,806.00 37,155.00 Finance - Revenue Admin 29,268.44 41,403.78 36,058.00 15,695.15 0.00 ( 36,058.00) Finance - A/P 36,949.45 39,858.40 33,691.00 24,963.50 34,167.00 476.00 Finance - Payroll 47,786.42 33,845.48 14,336.00 ( 13,532.23) 44,523.00 30,187.00 Law 161,023.30 231,537.57 252,000.00 175,757.12 246,605.00 ( 5,395.00) Information Technology 595,024.58 470,835.74 557,156.00 446,359.31 606,338.00 49,182.00 Human Resources 98,785.70 101,656.37 112,175.00 83,520.11 115,570.00 3,395.00 Bldg Maint & Allocations 332,497.53 276,876.72 307,990.00 228,248.28 598,746.00 290,756.00 Municipal Court 12,399.80 12,400.01 155,969.00 98,902.03 167,234.00 11,265.00 Police Administration 2,357,122.16 2,279,993.27 2,231,529.00 1,757,428.28 2,421,133.00 189,604.00 Beach Patrol 73,371.16 118,636.17 355,474.00 176,429.81 364,901.00 9,427.00 Fire Administration 331,051.72 336,202.08 494,966.00 331,733.99 695,866.00 200,900.00 Emergency Management 64,878.52 64,349.02 66,987.00 56,403.70 81,773.00 14,786.00 Public Works 1,632,915.34 1,601,502.04 1,804,647.00 1,105,123.86 1,894,136.00 89,489.00 Storm Drainage 11,374.92 7,500.00 12,000.00 6,250.00 12,000.00 0.00 Solid Waste Collection 271,925.42 256,174.41 150,000.00 79,304.17 90,000.00 ( 60,000.00) Cultural & Recreation 111,813.28 162,491.59 171,515.00 115,194.49 172,540.00 1,025.00 Recreation Centers 158,450.00 158,450.04 168,950.00 124,670.84 168,950.00 0.00 Lifeguards 384,907.71 404,377.45 448,922.00 201,989.48 496,821.00 47,899.00 Beach Related 117,213.90 78,317.16 121,700.00 59,264.91 125,300.00 3,600.00 Museums 108,707.00 34,836.00 41,337.00 41,337.00 41,337.00 0.00 Parks Administration 204,271.07 235,960.31 270,650.00 195,551.94 265,068.00 ( 5,582.00) Park Areas - Concession 0.00 19,829.28 97,485.00 75,645.49 78,300.00 ( 19,185.00) Parkways and Boulevards 0.00 0.00 224,000.00 12,500.00 586,500.00 362,500.00 Zoning and Inspection 198,552.10 244,892.29 309,049.00 210,950.76 298,767.00 ( 10,282.00) Better Hometown 98,657.73 95,183.65 110,399.00 76,769.80 100,489.00 ( 9,910.00) 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 2 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund FINANCIAL SUMMARY ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ Community Development 12,172.68 17,170.00 33,448.00 33,661.68 25,000.00 ( 8,448.00) Parking 911,755.40 440,558.81 609,084.00 359,527.82 608,848.00 ( 236.00) Debt Service 65,424.32 74,941.64 70,549.00 56,154.72 9,550.00 ( 60,999.00) Other Financing Uses 200,267.11 318,276.00 3,016,708.00 353,974.57 763,350.00 ( 2,253,358.00) TOTAL EXPENDITURES 9,312,190.41 8,952,721.59 13,289,975.00 7,159,354.62 12,173,432.00 ( 1,116,543.00) ============== ============== ============== ============== ============== ============== REVENUE OVER/(UNDER) EXPENDITURES 1,180,172.17 1,347,440.24 0.00 ( 670,364.82) 0.00 0.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 3 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund REVENUES Y ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ TAXES 00-31.1100 Real Property Tax - Current 1,514,646.96 1,561,422.01 1,550,000.00 988,707.13 1,600,000.00 50,000.00 00-31.1200 Property Tax Prior Yrs 165,048.21 159,759.19 170,000.00 104,712.17 170,000.00 0.00 00-31.1310 Motor Vehicle Tax Tag Settl 48,092.04 24,962.47 20,000.00 12,435.14 7,000.00 ( 13,000.00) 00-31.1315 TAVT - Motor Vehicle Tax 129,442.14 101,538.44 70,000.00 55,287.04 100,000.00 30,000.00 00-31.1317 AVT Transportation Taxes 0.00 2,435.39 1,100.00 0.00 1,100.00 0.00 00-31.1320 Property Tax - Mobile Homes 368.41 315.86 150.00 287.62 100.00 ( 50.00) 00-31.1340 Personal Property - Intangi 33,446.75 37,046.95 23,000.00 19,926.85 30,000.00 7,000.00 00-31.1600 Real Estate Trans Tax 14,630.22 14,020.21 8,500.00 8,669.57 11,000.00 2,500.00 00-31.1710 Franchise Tax Electric 325,361.29 330,926.77 322,900.00 322,938.39 320,000.00 ( 2,900.00) 00-31.1750 Franchise Tax - Cable TV 122,357.84 133,619.55 100,000.00 65,875.46 125,000.00 25,000.00 00-31.1760 Franchise Tax Telephone 12,941.07 10,702.52 13,000.00 4,929.63 10,000.00 ( 3,000.00) 00-31.3100 Sales & Use Tax Rev (LOST) 1,157,975.34 1,132,807.21 1,050,000.00 773,705.36 1,120,000.00 70,000.00 00-31.3103 Energy Excise Tax 16,299.35 17,642.17 14,700.00 14,750.20 16,000.00 1,300.00 00-31.4200 Alcohol Bev Excise Tax 204,073.90 214,491.28 190,000.00 137,910.46 205,000.00 15,000.00 00-31.4300 Local 3% Alcohol Tax 127,642.52 136,502.10 120,000.00 89,345.30 130,000.00 10,000.00 00-31.6100 Business-Occupational Tax 57,211.50 66,039.00 57,000.00 57,259.00 57,000.00 0.00 00-31.6101 Admin Fees - Business Licen 4,380.00 5,160.00 4,100.00 4,530.00 4,100.00 0.00 00-31.6200 Insurance Premium Tax 161,264.98 172,285.12 186,000.00 186,618.26 186,000.00 0.00 00-31.6225 Insurance Company Taxes 1,120.00 1,160.00 1,000.00 980.00 1,000.00 0.00 00-31.9111 Int Delq Tax Real Property 0.00 0.00 1,300.00 1,504.33 1,500.00 200.00 00-31.9900 Late Charge Revenues 2,231.79 1,555.25 2,400.00 1,474.28 1,500.00 ( 900.00) TOTAL TAXES 4,098,534.31 4,124,391.49 3,905,150.00 2,851,846.19 4,096,300.00 191,150.00 LICENSES & PERMITS 00-32.2990 Engineering Review 7,131.00 6,431.27 4,800.00 4,943.75 4,000.00 ( 800.00) 00-32.2995 Land Disturbing Fees 300.00 600.00 300.00 300.00 300.00 0.00 00-32.3000 Regulatory Fees 102,097.50 104,450.00 100,000.00 99,495.00 100,000.00 0.00 00-32.3101 Building Permits 81,734.29 81,531.88 78,000.00 81,412.32 80,000.00 2,000.00 00-32.3103 Palms Up Fees 12,925.00 0.00 1,000.00 2,750.00 1,000.00 0.00 00-32.3120 Building Inspections 21,982.50 25,285.85 23,000.00 23,446.74 20,000.00 ( 3,000.00) 00-32.3200 Film Permitting Fee 1,475.00 1,250.00 11,000.00 11,325.00 10,000.00 ( 1,000.00) 00-32.3900 Zoning Variance Requests 2,450.00 1,450.00 1,000.00 600.00 1,000.00 0.00 00-32.3901 Recording Fees 4,375.00 1,750.00 2,000.00 1,125.00 1,200.00 ( 800.00) 00-32.3912 Short-Term Registration 0.00 0.00 6,000.00 5,625.00 10,000.00 4,000.00 00-32.4100 Business License Penalty 625.20 1,172.50 500.00 660.00 500.00 0.00 TOTAL LICENSES & PERMITS 235,095.49 223,921.50 227,600.00 231,682.81 228,000.00 400.00 INTERGOVERNMENTAL 00-33.1010 Coastal Incentive Grant 0.00 0.00 30,000.00 30,000.00 0.00 ( 30,000.00) 00-33.1011 Gov Hwy Safety Grant Revenu 7,998.00 10,000.00 0.00 0.00 0.00 0.00 00-33.1025 Grant - DNR 0.00 13,690.11 14,400.00 4,925.00 0.00 ( 14,400.00) 00-33.4400 DOT LMIG Grant Rev (estimat 34,664.93 34,584.20 44,808.00 44,808.46 45,000.00 192.00 00-33.4403 Grant Revenue - GEFA 20,927.36 0.00 0.00 0.00 0.00 0.00 00-33.4410 GDOT Grant Revenue 0.00 0.00 199,000.00 0.00 199,000.00 0.00 00-33.4450 Grant - Dept Economic Devlo 20,000.00 0.00 0.00 0.00 0.00 0.00 TOTAL INTERGOVERNMENTAL 83,590.29 58,274.31 288,208.00 79,733.46 244,000.00 ( 44,208.00) CHARGES FOR SERVICES 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 4 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund REVENUES Y ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ 00-34.1400 Printing-Duplicating Servic 1,980.96 1,782.66 1,800.00 1,702.60 1,800.00 0.00 00-34.1500 Taxable Sales - Cashier 17.86 0.00 0.00 0.00 0.00 0.00 00-34.1910 Election Qualifying Fee 0.00 612.00 0.00 0.00 600.00 600.00 00-34.2120 Police Svcs- Accident Rep 500.00 0.00 100.00 0.00 0.00 ( 100.00) 00-34.2200 Fire Protect Subscriptions 11,705.00 14,545.16 14,500.00 13,317.64 14,500.00 0.00 00-34.2900 Chatham Cty Salary Reimburs 72,097.01 80,326.55 65,000.00 66,176.62 70,000.00 5,000.00 00-34.2904 Fire Cost Reimbursement 0.00 0.00 120.00 120.00 0.00 ( 120.00) 00-34.2905 DPW Cost Reimbursement 1,805.00 750.00 300.00 200.00 300.00 0.00 00-34.2906 Parking Cost Reimbursement 22,053.50 136,333.10 20,000.00 25,236.00 7,000.00 ( 13,000.00) 00-34.4150 City Dump Revenue 0.00 25,328.00 26,000.00 25,569.00 30,000.00 4,000.00 00-34.5415 Parking Revenue Meters 170,038.23 6,082.25 0.00 150.00 0.00 0.00 00-34.5416 Parking Rev Decal/Multiday 246,397.00 249,069.20 240,000.00 157,075.00 240,000.00 0.00 00-34.5418 Parking Rev- Pay/Display 2,594,614.71 2,840,489.62 2,725,000.00 1,768,842.32 2,870,000.00 145,000.00 00-34.5419 Parking Revenue - Jaycee Pa 1,068.91 1,296.31 800.00 535.20 800.00 0.00 00-34.5420 Processing Fee 1,165.53 1,341.00 1,000.00 1,015.50 1,000.00 0.00 00-34.6100 Animal Control-Shelter Fees 25.00 0.00 0.00 0.00 0.00 0.00 00-34.6410 Background Check Fees 4,771.00 3,947.50 3,000.00 2,951.50 3,000.00 0.00 00-34.6901 Vehicle Impound Fees 1,430.00 0.00 100.00 0.00 0.00 ( 100.00) 00-34.7501 City Facilities Rentals 37,215.00 48,110.00 42,000.00 28,175.00 42,000.00 0.00 00-34.7502 Concession Sales 0.00 0.00 14,050.00 13,989.80 0.00 ( 14,050.00) 00-34.7532 Vending Machine Revenue 0.00 0.00 1,200.00 1,616.22 0.00 ( 1,200.00) 00-34.7533 Campgrd Trolley Tickets 1,205.26 1,686.78 300.00 239.00 0.00 ( 300.00) 00-34.7534 Campgrd Misc Revenue 0.00 ( 4.00) 0.00 0.00 0.00 0.00 00-34.9301 Returned Ck Fees General 0.00 96.00 50.00 0.00 0.00 ( 50.00) 00-34.9303 Returned Ck Fees Parking 222.00 160.00 250.00 96.00 100.00 ( 150.00) TOTAL CHARGES FOR SERVICES 3,168,311.97 3,411,952.13 3,155,570.00 2,107,007.40 3,281,100.00 125,530.00 FINES & FORFEITURES 00-35.1170 Police Fines City Portion 453,827.81 421,869.28 490,000.00 0.00 420,000.00 ( 70,000.00) 00-35.1172 Information Tech Fees 26,725.59 50,055.00 18,000.00 0.00 18,000.00 0.00 00-35.1174 Court Cost 47,574.60 89,697.38 32,000.00 0.00 32,000.00 0.00 00-35.1175 Fines and Violations - Park 285,158.05 253,772.93 280,000.00 210,915.50 280,000.00 0.00 00-35.1176 Late Fees - Parking 49,010.43 33,869.07 45,000.00 29,548.00 35,000.00 ( 10,000.00) 00-35.1900 Other Fines Police/Court 3,268.96 8,642.79 9,000.00 5,590.00 7,000.00 ( 2,000.00) TOTAL FINES & FORFEITURES 865,565.44 857,906.45 874,000.00 246,053.50 792,000.00 ( 82,000.00) INVESTMENT INCOME 00-36.1000 Interest Revenue 10,137.16 17,755.83 15,000.00 14,902.66 15,000.00 0.00 TOTAL INVESTMENT INCOME 10,137.16 17,755.83 15,000.00 14,902.66 15,000.00 0.00 CONTRIBUTIONS & DONATIONS 00-37.4401 BHT Donations 375.00 410.00 3,000.00 200.00 0.00 ( 3,000.00) TOTAL CONTRIBUTIONS & DONATIONS 375.00 410.00 3,000.00 200.00 0.00 ( 3,000.00) MISCELLANEOUS 00-38.1003 Lease - Shrine Club 1,649.59 1,670.10 1,600.00 1,257.75 1,600.00 0.00 00-38.1005 Rents-Royalty-Misc 2,000.00 1.00 1.00 1.00 1.00 0.00 00-38.1006 Lease - North Beach Grill 17,155.95 17,794.96 17,400.00 16,561.70 66,000.00 48,600.00 00-38.1007 YMCA - Non Member Fee 0.00 872.00 500.00 0.00 500.00 0.00 00-38.1010 Cremation Wall 225.00 450.00 300.00 225.00 200.00 ( 100.00) 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 5 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund REVENUES Y ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ 00-38.3000 Damaged Property Reimbursem 95.00 417.53 100.00 0.00 0.00 ( 100.00) 00-38.9003 Miscellaneous Revenue 69,077.75 18,057.53 54,000.00 53,754.33 10,000.00 ( 44,000.00) TOTAL MISCELLANEOUS 90,203.29 39,263.12 73,901.00 71,799.78 78,301.00 4,400.00 OTHER FINANCING SOURCES 00-39.1100 Transfer In 302,000.00 0.00 157,000.00 0.00 0.00 ( 157,000.00) 00-39.1200 H/M Transfer In 1,443,316.13 1,566,287.00 1,385,000.00 885,764.00 1,412,501.00 27,501.00 00-39.1300 Prior Yr Fund Balance 1,556.00 0.00 3,205,546.00 0.00 2,026,230.00 ( 1,179,316.00) 00-39.2100 Sale of Assets 26,077.50 0.00 0.00 0.00 0.00 0.00 00-39.3526 SunTrust Bank Loan Proc - P 167,600.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER FINANCING SOURCES 1,940,549.63 1,566,287.00 4,747,546.00 885,764.00 3,438,731.00 ( 1,308,815.00) TOTAL REVENUES 10,492,362.58 10,300,161.83 13,289,975.00 6,488,989.80 12,173,432.00 ( 1,116,543.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 6 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Mayor and Council EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1110-51-1100 Salaries & Wages 20,400.00 28,600.00 28,800.00 31,000.00 37,200.00 8,400.00 1110-51-1400 Mayor Benefits 8,025.00 8,300.00 8,400.00 7,000.00 8,400.00 0.00 1110-51-2200 FICA Soc Sec Contribution 1,741.46 2,139.00 5,134.00 2,356.00 5,150.00 16.00 1110-51-2300 FICA Medicare Contributio 407.25 683.85 1,201.00 551.00 1,200.00 ( 1.00) TOTAL PERSONNEL 30,573.71 39,722.85 43,535.00 40,907.00 51,950.00 8,415.00 SERVICES 1110-52-1201 Studies, Surveys, Consult 13,094.00 1,685.00 5,000.00 4,024.98 5,000.00 0.00 1110-52-1232 Videographer 0.00 0.00 0.00 0.00 395.00 395.00 1110-52-2110 Garbage Charges 389.90 406.44 395.00 342.09 0.00 ( 395.00) 1110-52-3100 Property & Liability Insu 91,742.61 116,735.24 110,800.00 80,010.46 110,800.00 0.00 1110-52-3220 Postage/ Freight 112.59 153.60 200.00 62.92 200.00 0.00 1110-52-3300 Advertisment 0.00 20.00 0.00 10.00 0.00 0.00 1110-52-3501 Travel & Related - Mayor 2,034.14 4,597.38 4,500.00 2,554.62 4,500.00 0.00 1110-52-3502 Council travel - W.Doyle 1,556.36 2,504.76 3,300.00 1,771.03 3,300.00 0.00 1110-52-3503 Council Travel- B. Brown 905.85 729.00 3,300.00 838.72 3,300.00 0.00 1110-52-3504 Council travel - Rob Call 439.84 324.60 0.00 0.00 0.00 0.00 1110-52-3505 Council travel - B.Garbet 1,011.12 1,135.24 3,300.00 1,379.76 3,300.00 0.00 1110-52-3506 Council travel - Monty Pa 657.88 2,020.00 3,300.00 2,667.61 3,300.00 0.00 1110-52-3507 Council travel - Paul Wol 3,058.40 2,459.64 2,000.00 259.34 500.00 ( 1,500.00) 1110-52-3508 Council Travel - Julie Li 0.00 258.00 3,300.00 1,025.20 3,300.00 0.00 1110-52-3509 Council - John Major 0.00 317.08 3,300.00 0.00 3,300.00 0.00 1110-52-3600 Dues and Membership Fees 8,630.98 9,537.10 11,000.00 10,851.11 12,000.00 1,000.00 1110-52-3700 Education & Training - Co 0.00 0.00 0.00 0.00 2,000.00 2,000.00 1110-52-3701 Education & Training - Ma 475.00 1,840.00 2,000.00 1,216.20 2,000.00 0.00 1110-52-3702 Education - W.Doyle 1,710.00 1,160.00 2,000.00 720.00 2,000.00 0.00 1110-52-3703 Education - B Brown 950.00 610.00 2,000.00 580.00 2,000.00 0.00 1110-52-3704 Education - Rob Callahan 1,125.00 350.00 0.00 0.00 0.00 0.00 1110-52-3705 Education -B.Garbett 1,435.00 1,450.00 2,000.00 1,065.00 2,000.00 0.00 1110-52-3706 Education - M.Parks 1,200.00 1,085.00 2,000.00 50.00 2,000.00 0.00 1110-52-3707 Education - Paul Wolf 1,075.00 1,387.88 0.00 0.00 0.00 0.00 1110-52-3710 Education - Julie Livings 0.00 725.00 2,800.00 1,720.00 2,000.00 ( 800.00) 1110-52-3711 Education - John Major 0.00 375.00 200.00 0.00 2,000.00 1,800.00 TOTAL SERVICES 131,603.67 151,865.96 166,695.00 111,149.04 169,195.00 2,500.00 SUPPLIES 1110-53-1100 Supplies & Materials 3,145.39 1,179.89 1,250.00 1,222.49 1,250.00 0.00 1110-53-1210 Water/Sewer Charges 290.73 353.82 250.00 450.35 250.00 0.00 1110-53-1230 Electricity 6,860.95 7,250.40 7,200.00 4,688.18 7,200.00 0.00 1110-53-1310 Food - Officials & Functi 4,451.12 3,406.92 4,200.00 1,696.45 4,200.00 0.00 1110-53-1710 Volunteer Appreciation 199.94 0.00 300.00 0.00 300.00 0.00 1110-53-1720 Uniforms 0.00 0.00 300.00 112.25 300.00 0.00 TOTAL SUPPLIES 14,948.13 12,191.03 13,500.00 8,169.72 13,500.00 0.00 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 7 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Mayor and Council EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY ______________ ______________ ______________ ______________ ______________ ______________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS 1110-57-2100 Flowers 579.88 384.77 500.00 415.00 600.00 100.00 TOTAL OTHER COSTS 579.88 384.77 500.00 415.00 600.00 100.00 TOTAL Mayor and Council 177,705.39 204,164.61 224,230.00 160,640.76 235,245.00 11,015.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 8 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Clerk of Council EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1130-51-1100 Salaries & Wages 54,562.55 55,791.29 55,212.00 44,834.74 57,965.00 2,753.00 1130-51-1400 Employee Benefits 1,200.00 1,200.00 1,200.00 1,000.00 3,000.00 1,800.00 1130-51-2100 Health Insurance Benefits 6,348.76 6,716.10 7,116.00 6,759.61 8,587.00 1,471.00 1130-51-2200 FICA Soc Sec Contribution 3,426.25 3,471.53 3,498.00 2,789.36 3,780.00 282.00 1130-51-2300 FICA Medicare Contributio 801.28 811.86 818.00 652.34 884.00 66.00 1130-51-2400 Retirement Contributions 6,200.00 5,599.80 6,111.00 5,092.40 5,630.00 ( 481.00) 1130-51-2700 Workers Compensation 149.35 170.76 181.00 168.19 195.00 14.00 TOTAL PERSONNEL 72,688.19 73,761.34 74,136.00 61,296.64 80,041.00 5,905.00 SERVICES 1130-52-1110 Recodification Service 6,790.32 5,114.70 3,500.00 2,898.69 3,500.00 0.00 1130-52-1125 Election Expense 0.00 0.00 4,049.00 0.00 4,049.00 0.00 1130-52-1325 Contract Service - Class 0.00 372.00 0.00 0.00 0.00 0.00 1130-52-2110 Garbage Charges 12.80 11.34 50.00 12.44 50.00 0.00 1130-52-3100 Property/Liability Insura 235.49 283.00 400.00 317.56 400.00 0.00 1130-52-3300 Advertising 1,400.64 1,302.30 1,500.00 377.48 1,500.00 0.00 1130-52-3500 Travel & Related Expenses 1,965.02 2,344.01 2,770.00 2,113.75 2,770.00 0.00 1130-52-3600 Dues & Fees 227.50 255.00 300.00 241.98 300.00 0.00 1130-52-3700 Educ & Training 1,250.00 2,035.00 2,080.00 1,455.00 2,080.00 0.00 1130-52-3930 Record Management 759.80 205.00 500.00 0.00 500.00 0.00 TOTAL SERVICES 12,641.57 11,922.35 15,149.00 7,416.90 15,149.00 0.00 SUPPLIES 1130-53-1100 Supplies & Materials 4,746.71 2,867.16 3,500.00 886.31 2,000.00 ( 1,500.00) 1130-53-1115 Supplies - Mayors Motorca 0.00 0.00 300.00 274.42 400.00 100.00 1130-53-1150 Supplies & Materials - Ev 1,897.72 2,040.35 3,000.00 0.00 3,000.00 0.00 1130-53-1210 Water/Sewer Chgs 7.26 9.79 45.00 12.41 45.00 0.00 1130-53-1230 Electricity 189.02 199.75 500.00 129.16 500.00 0.00 1130-53-1600 Small equipment 0.00 1,529.69 0.00 0.00 0.00 0.00 1130-53-1720 Uniforms 493.62 156.02 200.00 120.03 200.00 0.00 TOTAL SUPPLIES 7,334.33 6,802.76 7,545.00 1,422.33 6,145.00 ( 1,400.00) DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS 1130-57-3000 Payment to Others 0.00 4,519.81 7,000.00 3,614.46 7,000.00 0.00 TOTAL OTHER COSTS 0.00 4,519.81 7,000.00 3,614.46 7,000.00 0.00 TOTAL Clerk of Council 92,664.09 97,006.26 103,830.00 73,750.33 108,335.00 4,505.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 9 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund City Manager EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1320-51-1100 Salaries & Wages 133,053.90 143,792.62 141,872.00 112,334.91 163,582.00 21,710.00 1320-51-1300 Overtime 0.00 0.00 500.00 4,179.27 500.00 0.00 1320-51-1400 Employee Benefits 1,200.00 1,200.00 1,200.00 800.00 1,200.00 0.00 1320-51-2100 Health Insurance Benefits 16,444.28 17,480.88 18,482.00 14,199.01 34,847.00 16,365.00 1320-51-2200 FICA Soc Sec Contribution 8,199.67 8,865.55 10,823.00 7,182.86 10,247.00 ( 576.00) 1320-51-2300 FICA Medicare Contributio 1,917.54 2,073.43 2,537.00 1,679.92 2,397.00 ( 140.00) 1320-51-2400 Retirement Contributions 16,025.00 13,866.72 14,089.00 11,740.70 13,915.00 ( 174.00) 1320-51-2700 Workers Compensation 490.00 511.32 777.00 784.21 893.00 116.00 TOTAL PERSONNEL 177,330.39 187,790.52 190,280.00 152,900.88 227,581.00 37,301.00 SERVICES 1320-52-1300 Contract Services 0.00 0.00 85,000.00 50,024.64 30,000.00 ( 55,000.00) 1320-52-1325 Contract Service - Class 0.00 743.00 0.00 0.00 0.00 0.00 1320-52-2110 Garbage Charges 32.59 32.10 37.00 23.92 37.00 0.00 1320-52-3100 Property/Liability Insura 616.68 745.17 1,009.00 840.22 1,009.00 0.00 1320-52-3220 Postage/ Freight 1,166.82 1,233.12 1,400.00 1,211.32 2,800.00 1,400.00 1320-52-3300 Advertising 60.00 120.00 60.00 40.00 60.00 0.00 1320-52-3400 Print & Binding 0.00 0.00 0.00 0.00 200.00 200.00 1320-52-3500 Travel & Related Expenses 1,762.32 1,204.78 1,400.00 708.48 1,400.00 0.00 1320-52-3600 Dues & Fees 1,097.00 4,152.73 4,400.00 1,530.07 4,400.00 0.00 1320-52-3700 Educ & Training 2,214.00 765.00 2,300.00 0.00 2,300.00 0.00 TOTAL SERVICES 6,949.41 8,995.90 95,606.00 54,378.65 42,206.00 ( 53,400.00) SUPPLIES 1320-53-1100 Supplies & Materials 1,395.79 757.07 1,500.00 680.95 3,000.00 1,500.00 1320-53-1210 Water/Sewer Charges 22.82 27.83 35.00 35.43 50.00 15.00 1320-53-1230 Electricity 539.74 570.37 650.00 368.83 650.00 0.00 1320-53-1310 Food - Officials & Functi 0.00 0.00 600.00 245.92 600.00 0.00 1320-53-1600 Small equipment 0.00 0.00 0.00 0.00 4,000.00 4,000.00 1320-53-1720 Uniforms 0.00 0.00 0.00 0.00 200.00 200.00 TOTAL SUPPLIES 1,958.35 1,355.27 2,785.00 1,331.13 8,500.00 5,715.00 OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ TOTAL City Manager 186,238.15 198,141.69 288,671.00 208,610.66 278,287.00 ( 10,384.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 10 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Finance EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1510-51-1100 Salaries & Wages 86,520.74 91,031.94 90,326.00 73,328.72 94,829.00 4,503.00 1510-51-1400 Employee Benefits 1,200.00 1,200.00 1,200.00 1,000.00 1,200.00 0.00 1510-51-2100 Health Insurance Benefits 5,990.30 6,892.50 7,291.00 6,921.42 8,790.00 1,499.00 1510-51-2200 FICA Soc Sec Contribution 5,345.61 5,594.41 5,675.00 4,474.68 5,954.00 279.00 1510-51-2300 FICA Medicare Contributio 1,250.31 1,308.39 1,327.00 1,046.41 1,392.00 65.00 1510-51-2400 Retirement Contributions 8,980.00 8,062.95 9,242.00 7,701.50 9,075.00 ( 167.00) 1510-51-2700 Workers Compensation 160.06 239.06 293.00 283.78 307.00 14.00 TOTAL PERSONNEL 109,447.02 114,329.25 115,354.00 94,756.51 121,547.00 6,193.00 SERVICES 1510-52-1325 Contract Services - Class 0.00 372.00 0.00 0.00 0.00 0.00 1510-52-3100 Property/Liability Insura 1,184.40 1,423.38 1,960.00 1,622.18 1,900.00 ( 60.00) 1510-52-3500 Travel & Related Expenses 4,574.24 475.40 4,000.00 2,246.58 4,000.00 0.00 1510-52-3600 Dues & Fees 25.00 210.00 300.00 120.00 300.00 0.00 1510-52-3700 Educ & Training 1,748.00 780.00 4,640.00 2,237.25 4,600.00 ( 40.00) TOTAL SERVICES 7,531.64 3,260.78 10,900.00 6,226.01 10,800.00 ( 100.00) SUPPLIES 1510-53-1100 Supplies & Materials 967.94 288.33 300.00 195.67 300.00 0.00 1510-53-1210 Water/Sewer Chgs 57.04 84.83 65.00 88.58 100.00 35.00 1510-53-1230 Electricity 1,349.54 1,272.45 1,500.00 950.14 1,500.00 0.00 1510-53-1400 Books/Periodicals 0.00 0.00 200.00 0.00 200.00 0.00 1510-53-1600 Small Equipment 449.00 661.96 500.00 0.00 500.00 0.00 1510-53-1703 Cash- Over/Short ( 0.40) 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 2,823.12 2,307.57 2,565.00 1,234.39 2,600.00 35.00 OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Finance 119,801.78 119,897.60 128,819.00 102,216.91 134,947.00 6,128.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 11 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Finance - Accounting EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1512-51-1100 Salaries & Wages 53,754.00 103,452.80 162,936.00 96,054.45 170,310.00 7,374.00 1512-51-1300 Overtime 1,059.23 1,119.43 2,850.00 2,131.89 2,500.00 ( 350.00) 1512-51-1400 Employee Benefits 200.00 3,100.00 3,000.00 3,500.00 4,200.00 1,200.00 1512-51-2100 Health Insurance Benefits 12,989.82 20,827.42 33,919.00 26,689.17 47,004.00 13,085.00 1512-51-2200 FICA Soc Sec Contribution 3,121.77 6,859.93 7,160.00 6,252.06 10,559.00 3,399.00 1512-51-2300 FICA Medicare Contributio 730.07 1,604.10 1,675.00 1,462.24 2,470.00 795.00 1512-51-2400 Retirement Contribution 8,342.54 11,261.00 10,024.00 9,646.13 9,765.00 ( 259.00) 1512-51-2700 Workers Compensation 170.04 237.80 407.00 483.18 456.00 49.00 TOTAL PERSONNEL 80,367.47 148,462.48 221,971.00 146,219.12 247,264.00 25,293.00 SERVICES 1512-52-1105 County Tax Billing Admin 21,729.83 21,871.64 25,000.00 19,524.74 25,000.00 0.00 1512-52-1221 Audit Accounting Fees 23,000.00 29,900.00 29,900.00 29,700.00 37,000.00 7,100.00 1512-52-1300 Service Contracts 2,370.00 2,764.29 35,788.00 900.72 35,000.00 ( 788.00) 1512-52-1325 Contract Services - Class 0.00 372.00 0.00 0.00 0.00 0.00 1512-52-2110 Garbage Charges 78.38 97.89 270.00 83.54 270.00 0.00 1512-52-3100 Property & Liability Insu 0.00 0.00 0.00 0.00 400.00 400.00 1512-52-3220 Postage & Freight 280.50 212.56 400.00 118.56 400.00 0.00 1512-52-3300 Advertising 4,988.82 1,625.00 7,200.00 1,850.00 5,200.00 ( 2,000.00) 1512-52-3400 Printing & Binding 457.76 0.00 1,150.00 0.00 1,200.00 50.00 1512-52-3500 Travel & Related 3,131.26 2,205.99 2,600.00 288.02 4,000.00 1,400.00 1512-52-3600 Dues and Fees 455.86 359.48 500.00 453.04 500.00 0.00 1512-52-3700 Education and Training 2,621.00 1,728.34 1,800.00 120.00 2,500.00 700.00 1512-52-3850 Contract Labor 8,144.04 7,605.13 20,000.00 12,862.81 20,000.00 0.00 1512-52-3990 Service Charges, Late Fee 31,213.06 37,648.74 35,000.00 27,186.86 40,000.00 5,000.00 TOTAL SERVICES 98,470.51 106,391.06 159,608.00 93,088.29 171,470.00 11,862.00 SUPPLIES 1512-53-1100 Supplies & Materials 3,646.68 3,661.15 4,000.00 1,749.04 4,000.00 0.00 1512-53-1600 Small Equipment 1,725.00 1,599.57 5,000.00 0.00 5,000.00 0.00 1512-53-1703 Cash - Over/Short Deposi( 193.46) 5.85 100.00 ( 11.27) 100.00 0.00 TOTAL SUPPLIES 5,178.22 5,266.57 9,100.00 1,737.77 9,100.00 0.00 CAPITAL OUTLAY 1512-54-2100 Machinery & Equipment 7,862.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 7,862.00 0.00 0.00 0.00 0.00 0.00 INTERFUND/INTERDEPARTMENT 1512-55-1010 Indirect Allocation - Ac( 84,663.96) ( 84,663.96) ( 125,028.00) ( 116,689.80) ( 125,028.00) 0.00 TOTAL INTERFUND/INTERDEPARTMENT ( 84,663.96) ( 84,663.96) ( 125,028.00) ( 116,689.80) ( 125,028.00) 0.00 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 12 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Finance - Accounting EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Finance - Accounting 107,214.24 175,456.15 265,651.00 124,355.38 302,806.00 37,155.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 13 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Finance - Revenue Admin EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1514-51-1100 Salaries & Wages 23,347.45 33,700.00 20,799.00 8,575.00 0.00 ( 20,799.00) 1514-51-1300 Overtime 103.05 82.44 952.00 41.22 0.00 ( 952.00) 1514-51-1400 Employee Benefits 500.00 400.00 1,200.00 0.00 0.00 ( 1,200.00) 1514-51-2100 Health Insurance Benefits 3,335.79 4,556.72 5,134.00 1,853.94 0.00 ( 5,134.00) 1514-51-2200 FICA Soc Sec Contribution 1,461.77 2,007.43 2,526.00 534.21 0.00 ( 2,526.00) 1514-51-2300 FICA Medicare Contributio 341.88 452.93 591.00 124.94 0.00 ( 591.00) 1514-51-2400 Retirement Contributions 0.00 0.00 4,543.00 4,453.60 0.00 ( 4,543.00) 1514-51-2700 WorkersCompensation 28.50 54.26 163.00 0.00 0.00 ( 163.00) TOTAL PERSONNEL 29,118.44 41,253.78 35,908.00 15,582.91 0.00 ( 35,908.00) SERVICES ______________ ______________ ______________ ______________ ______________ ______________ SUPPLIES 1514-53-1100 Supplies & Materials 150.00 150.00 150.00 112.24 0.00 ( 150.00) TOTAL SUPPLIES 150.00 150.00 150.00 112.24 0.00 ( 150.00) TOTAL Finance - Revenue Admin 29,268.44 41,403.78 36,058.00 15,695.15 0.00 ( 36,058.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 14 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Finance - A/P EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1517-51-1100 Salaries & Wages 44,866.47 45,857.00 47,158.00 38,852.17 48,576.00 1,418.00 1517-51-1300 Overtime 755.29 1,399.53 500.00 2,266.61 500.00 0.00 1517-51-2100 Health Insurance Benefits 6,311.92 6,689.94 7,053.00 6,735.74 8,513.00 1,460.00 1517-51-2200 FICA Soc Sec Contribution 2,828.53 2,899.00 2,955.00 2,549.35 3,043.00 88.00 1517-51-2300 FICA Medicare Contributio 661.59 678.00 691.00 596.20 712.00 21.00 1517-51-2400 Retirement Contributions 4,960.00 4,996.84 4,925.00 4,104.10 4,710.00 ( 215.00) 1517-51-2700 Workers Compensation 138.57 136.60 153.00 138.74 157.00 4.00 TOTAL PERSONNEL 60,522.37 62,656.91 63,435.00 55,242.91 66,211.00 2,776.00 SERVICES 1517-52-1325 Contract Services - Class 0.00 372.00 0.00 0.00 0.00 0.00 1517-52-3220 Postage & Freight 487.52 665.07 3,000.00 708.20 1,000.00 ( 2,000.00) 1517-52-3500 Travel & Related 121.74 629.00 1,700.00 0.00 1,800.00 100.00 1517-52-3700 Education & Training 325.00 375.00 500.00 295.90 1,800.00 1,300.00 TOTAL SERVICES 934.26 2,041.07 5,200.00 1,004.10 4,600.00 ( 600.00) SUPPLIES 1517-53-1100 Supplies & Materials 737.46 405.06 3,200.00 512.19 1,500.00 ( 1,700.00) TOTAL SUPPLIES 737.46 405.06 3,200.00 512.19 1,500.00 ( 1,700.00) INTERFUND/INTERDEPARTMENT 1517-55-1005 Indirect Allocation - A ( 25,244.64) ( 25,244.64) ( 38,144.00) ( 31,795.70) ( 38,144.00) 0.00 TOTAL INTERFUND/INTERDEPARTMENT ( 25,244.64) ( 25,244.64) ( 38,144.00) ( 31,795.70) ( 38,144.00) 0.00 TOTAL Finance - A/P 36,949.45 39,858.40 33,691.00 24,963.50 34,167.00 476.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 15 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Finance - Payroll EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1519-51-1100 Salaries & Wages 34,707.24 25,398.00 18,730.00 0.00 38,154.00 19,424.00 1519-51-1300 Overtime 1,040.82 41.22 448.00 0.00 0.00 ( 448.00) 1519-51-1400 Employee Benefits 700.00 700.00 0.00 0.00 0.00 0.00 1519-51-2100 Health Insurance Benefits 4,989.97 2,200.00 2,416.00 0.00 10,768.00 8,352.00 1519-51-2200 FICA Soc Sec Contribution 2,160.02 1,640.00 1,190.00 0.00 2,366.00 1,176.00 1519-51-2300 FICA Medicare Contributio 505.15 400.00 278.00 0.00 554.00 276.00 1519-51-2400 Retirement Contributions 7,500.00 6,823.36 2,138.00 1,113.40 3,586.00 1,448.00 1519-51-2700 Workers Compensation 86.43 145.00 77.00 144.70 126.00 49.00 TOTAL PERSONNEL 51,689.63 37,347.58 25,277.00 1,258.10 55,554.00 30,277.00 SERVICES 1519-52-3220 Postage & Freight 49.83 0.00 0.00 0.00 0.00 0.00 1519-52-3500 Travel & Related 117.60 755.65 1,000.00 0.00 1,000.00 0.00 1519-52-3700 Education & Training 325.00 325.00 390.00 0.00 400.00 10.00 TOTAL SERVICES 492.43 1,080.65 1,390.00 0.00 1,400.00 10.00 SUPPLIES 1519-53-1100 Supplies & Materials 500.00 312.89 500.00 26.17 400.00 ( 100.00) TOTAL SUPPLIES 500.00 312.89 500.00 26.17 400.00 ( 100.00) INTERFUND/INTERDEPARTMENT 1519-55-1008 Indirect Allocation - P ( 4,895.64) ( 4,895.64) ( 12,831.00) ( 14,816.50) ( 12,831.00) 0.00 TOTAL INTERFUND/INTERDEPARTMENT ( 4,895.64) ( 4,895.64) ( 12,831.00) ( 14,816.50) ( 12,831.00) 0.00 TOTAL Finance - Payroll 47,786.42 33,845.48 14,336.00 ( 13,532.23) 44,523.00 30,187.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 16 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Law EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES 1530-52-1200 Legal Gen Government 0.00 495.00 0.00 0.00 0.00 0.00 1530-52-1203 Legal/Lawsuits/All Depts 158,456.00 226,757.37 246,000.00 171,757.12 240,000.00 ( 6,000.00) 1530-52-1204 Legal/Ethics Comm 0.00 0.00 0.00 0.00 2,000.00 2,000.00 TOTAL SERVICES 158,456.00 227,252.37 246,000.00 171,757.12 242,000.00 ( 4,000.00) INTERFUND/INTERDEPARTMENT 1530-55-5500 Insurance Deductibles - G 2,567.30 4,285.20 6,000.00 4,000.00 4,605.00 ( 1,395.00) TOTAL INTERFUND/INTERDEPARTMENT 2,567.30 4,285.20 6,000.00 4,000.00 4,605.00 ( 1,395.00) TOTAL Law 161,023.30 231,537.57 252,000.00 175,757.12 246,605.00 ( 5,395.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 17 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Information Technology EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1535-51-1100 Salaries & Wages 110,131.11 116,195.51 116,720.00 93,507.85 158,482.00 41,762.00 1535-51-1300 Overtime 0.00 181.70 6,000.00 323.90 7,000.00 1,000.00 1535-51-1400 Employee Benefits 6,000.00 6,000.00 7,000.00 5,000.00 9,000.00 2,000.00 1535-51-2100 Health Insurance Benefits 16,354.83 17,361.24 18,349.00 16,926.09 35,338.00 16,989.00 1535-51-2200 FICA Soc Sec Contribution 7,029.60 7,382.83 8,043.00 5,968.75 10,820.00 2,777.00 1535-51-2300 FICA Medicare Contributio 1,643.92 1,726.59 1,881.00 1,395.87 2,530.00 649.00 1535-51-2400 Retirement Contributions 14,774.99 13,072.95 12,513.00 10,426.80 12,000.00 ( 513.00) 1535-51-2700 Workers Compensation 310.64 324.65 415.00 328.97 558.00 143.00 TOTAL PERSONNEL 156,245.09 162,245.47 170,921.00 133,878.23 235,728.00 64,807.00 SERVICES 1535-52-1300 Service Contracts 140,432.83 161,774.50 236,000.00 215,966.96 233,560.00 ( 2,440.00) 1535-52-1325 Contract Services - Class 0.00 743.00 0.00 0.00 0.00 0.00 1535-52-2110 Garbage Charges 41.71 41.73 50.00 35.01 50.00 0.00 1535-52-2201 Repair/Maint-Buildings 2,043.09 1,075.00 5,000.00 3,336.47 5,000.00 0.00 1535-52-2203 Repair/Maint-Equipt 9,156.29 5,329.88 5,000.00 4,992.35 6,000.00 1,000.00 1535-52-2320 Rent- Equip & Vehicles 0.00 7,009.73 11,500.00 7,944.56 14,000.00 2,500.00 1535-52-3100 Property & Liability Insu 568.13 685.44 950.00 771.87 950.00 0.00 1535-52-3201 Telephone/Internet Costs 66,195.29 62,171.61 58,000.00 49,420.26 57,400.00 ( 600.00) 1535-52-3203 Cell Phones 7,635.53 5,559.84 0.00 0.00 0.00 0.00 1535-52-3500 Travel & Related Expenses 0.00 0.00 1,200.00 0.00 0.00 ( 1,200.00) 1535-52-3600 Dues and fees 0.00 0.00 0.00 18.51 100.00 100.00 1535-52-3700 Educ & Training 0.00 0.00 3,000.00 60.00 5,000.00 2,000.00 1535-52-3850 Contract Services 8,950.00 5,203.17 6,000.00 1,700.00 2,500.00 ( 3,500.00) TOTAL SERVICES 235,022.87 249,593.90 326,700.00 284,245.99 324,560.00 ( 2,140.00) SUPPLIES 1535-53-1100 Supplies & Materials 529.53 550.00 500.00 327.13 500.00 0.00 1535-53-1210 Water/Sewer Chgs 29.65 36.19 35.00 46.10 50.00 15.00 1535-53-1230 Electricity 701.89 895.35 1,000.00 479.57 500.00 ( 500.00) 1535-53-1600 Small Equipment 15,752.54 36,466.29 43,000.00 21,114.41 30,000.00 ( 13,000.00) TOTAL SUPPLIES 17,013.61 37,947.83 44,535.00 21,967.21 31,050.00 ( 13,485.00) CAPITAL OUTLAY 1535-54-2100 Machinery & Equipment 0.00 6,500.00 0.00 0.00 0.00 0.00 1535-54-2101 Backup Power Generator 45,893.00 0.00 0.00 0.00 0.00 0.00 1535-54-2300 Computer Room Equipment 99,999.20 0.00 0.00 0.00 0.00 0.00 1535-54-2400 Computers 40,850.81 14,548.54 15,000.00 6,267.88 15,000.00 0.00 TOTAL CAPITAL OUTLAY 186,743.01 21,048.54 15,000.00 6,267.88 15,000.00 0.00 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 18 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Information Technology EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ DEBT SERVICE ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Information Technology 595,024.58 470,835.74 557,156.00 446,359.31 606,338.00 49,182.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 19 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Human Resources EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1540-51-1100 Salaries & Wages 57,463.93 61,524.74 62,223.00 49,593.62 64,092.00 1,869.00 1540-51-1400 Employee Benefits 3,000.00 3,000.00 3,000.00 2,500.00 3,000.00 0.00 1540-51-2100 Health Insurance Benefits 6,379.48 6,756.90 7,132.00 6,797.12 8,605.00 1,473.00 1540-51-2200 FICA Soc Sec Contribution 3,635.97 3,879.64 4,044.00 3,147.95 4,160.00 116.00 1540-51-2300 FICA Medicare Contributio 850.35 907.33 946.00 736.20 973.00 27.00 1540-51-2400 Retirement Contributions 7,770.00 6,989.76 6,511.00 5,425.60 6,235.00 ( 276.00) 1540-51-2700 Workers Compensation 162.37 170.76 209.00 175.27 215.00 6.00 1540-51-2900 Wellness Benefits 3,320.88 3,410.54 3,500.00 600.00 3,000.00 ( 500.00) TOTAL PERSONNEL 82,582.98 86,639.67 87,565.00 68,975.76 90,280.00 2,715.00 SERVICES 1540-52-1120 Management Support Activi 1,606.56 1,575.96 1,700.00 1,379.50 1,700.00 0.00 1540-52-1231 Drug Testing 4,289.46 4,040.90 4,500.00 2,575.41 4,500.00 0.00 1540-52-1275 Employee Assistance Expen 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 0.00 1540-52-1300 Contract Services 0.00 0.00 0.00 91.00 0.00 0.00 1540-52-1325 Contract Services - Class 372.00 372.00 0.00 0.00 0.00 0.00 1540-52-2110 Garbage 25.20 24.45 30.00 20.42 30.00 0.00 1540-52-3100 Property & Liability Insu 173.07 206.19 280.00 229.65 280.00 0.00 1540-52-3220 Postage 342.15 322.57 400.00 221.28 450.00 50.00 1540-52-3300 Advertising 1,218.32 293.54 1,000.00 0.00 1,000.00 0.00 1540-52-3500 Travel & Related Expenses 682.00 571.00 900.00 0.00 900.00 0.00 1540-52-3600 Dues and Fees 285.00 315.00 300.00 450.00 425.00 125.00 1540-52-3700 Educ & Training 869.00 803.00 1,200.00 320.00 1,200.00 0.00 1540-52-3725 Education & Training -Int 0.00 0.00 2,000.00 0.00 2,000.00 0.00 1540-52-3850 Contract Services 0.00 0.00 1,500.00 338.35 1,500.00 0.00 TOTAL SERVICES 12,862.76 11,524.61 16,810.00 8,625.61 16,985.00 175.00 SUPPLIES 1540-53-1100 Supplies & Materials 864.51 567.60 914.00 548.40 900.00 ( 14.00) 1540-53-1210 Water Sewer Chgs 17.34 21.17 22.00 26.93 30.00 8.00 1540-53-1230 Electricity 410.40 433.71 464.00 280.44 575.00 111.00 1540-53-1312 Employee Appreciation Lun 964.19 2,145.90 2,500.00 1,760.73 2,500.00 0.00 1540-53-1710 Employee Appreciation Awa 889.75 323.71 500.00 212.53 500.00 0.00 1540-53-1720 Uniforms 193.77 0.00 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 3,339.96 3,492.09 4,400.00 2,829.03 4,505.00 105.00 INTERFUND/INTERDEPARTMENT ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS 1540-57-2012 Unitied Way Coastal Empir 0.00 0.00 2,800.00 3,089.71 3,200.00 400.00 1540-57-2100 Flowers 0.00 0.00 600.00 0.00 600.00 0.00 TOTAL OTHER COSTS 0.00 0.00 3,400.00 3,089.71 3,800.00 400.00 TOTAL Human Resources 98,785.70 101,656.37 112,175.00 83,520.11 115,570.00 3,395.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 20 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Bldg Maint & Allocations EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 1565-51-1100 Salaries & Wages 132,235.66 133,812.01 136,477.00 117,925.93 149,700.00 13,223.00 1565-51-1300 Overtime Wages 7,892.42 4,243.74 10,000.00 5,526.40 7,000.00 ( 3,000.00) 1565-51-1400 Employee Benefits 2,100.00 2,300.00 2,400.00 2,000.00 2,400.00 0.00 1565-51-2100 Health Insurance Benefits 27,294.34 30,638.84 36,199.00 32,932.84 43,439.00 7,240.00 1565-51-2200 FICA Soc Sec Contribution 8,818.19 8,702.04 9,234.00 7,779.17 9,864.00 630.00 1565-51-2300 FICA Medicare Contributio 2,062.36 2,035.14 2,175.00 1,819.40 2,307.00 132.00 1565-51-2400 Retirement Contributions 18,044.60 19,916.86 13,676.00 11,395.90 14,210.00 534.00 1565-51-2700 Workers Compensation 7,015.02 7,953.00 13,319.00 9,678.94 14,526.00 1,207.00 TOTAL PERSONNEL 205,462.59 209,601.63 223,480.00 189,058.58 243,446.00 19,966.00 SERVICES 1565-52-1325 Contract Services - Class 0.00 1,486.00 0.00 0.00 0.00 0.00 1565-52-2130 Custodial City Hall Build 6,600.00 6,600.00 6,600.00 5,500.00 140,000.00 133,400.00 1565-52-2200 Pest Control 3,749.73 3,401.32 3,720.00 3,719.94 3,800.00 80.00 1565-52-2201 Repair/Maintain-Buildings 47,133.74 53,107.49 39,380.00 19,457.54 39,000.00 ( 380.00) 1565-52-3100 Property & Liability Insu 109.51 1,305.37 22,310.00 6,084.62 10,000.00 ( 12,310.00) TOTAL SERVICES 57,592.98 65,900.18 72,010.00 34,762.10 192,800.00 120,790.00 SUPPLIES 1565-53-1100 Supplies/Materials 1,373.96 732.55 2,500.00 927.60 2,500.00 0.00 TOTAL SUPPLIES 1,373.96 732.55 2,500.00 927.60 2,500.00 0.00 CAPITAL OUTLAY 1565-54-1315 Building Improvements 18,900.00 642.36 10,000.00 0.00 160,000.00 150,000.00 1565-54-1319 Building Imprv Storm Dama 0.00 0.00 0.00 3,500.00 0.00 0.00 1565-54-2100 Machinery & Equipment 49,168.00 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 68,068.00 642.36 10,000.00 3,500.00 160,000.00 150,000.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Bldg Maint & Allocations 332,497.53 276,876.72 307,990.00 228,248.28 598,746.00 290,756.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 21 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Municipal Court EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 2650-51-1100 Salaries & Wages 0.00 0.00 86,550.00 63,887.50 91,225.00 4,675.00 2650-51-1300 Overtime 0.00 0.00 0.00 2,891.36 1,000.00 1,000.00 2650-51-1400 Employee Benefits 0.00 0.00 2,400.00 200.00 0.00 ( 2,400.00) 2650-51-2100 Health Insurance Benefits 0.00 0.00 14,089.00 12,023.75 20,679.00 6,590.00 2650-51-2200 FICA Soc Sec Contribution 0.00 0.00 5,367.00 4,152.67 5,718.00 351.00 2650-51-2300 FICA Medicare Contributio 0.00 0.00 1,255.00 971.19 1,337.00 82.00 2650-51-2400 Retirement Contributions 0.00 0.00 9,331.00 7,613.73 9,680.00 349.00 2650-51-2700 Workers Compensation 0.00 0.00 277.00 118.48 295.00 18.00 TOTAL PERSONNEL 0.00 0.00 119,269.00 91,858.68 129,934.00 10,665.00 SERVICES 2650-52-1101 Legal - Judge 2,400.00 2,400.00 10,000.00 1,800.00 10,000.00 0.00 2650-52-1300 Service Contracts 0.00 0.00 1,500.00 354.00 1,500.00 0.00 2650-52-1385 Custody - Food Supplies 0.00 0.00 0.00 0.00 600.00 600.00 2650-52-3100 Property/Liability Insura 0.00 0.00 200.00 0.00 200.00 0.00 2650-52-3500 Travel & Related Expenses 0.00 0.00 2,400.00 423.24 2,400.00 0.00 2650-52-3600 Dues & Fees 0.00 0.00 1,000.00 0.00 1,000.00 0.00 2650-52-3700 Educ & Training 0.00 0.00 4,500.00 0.00 4,500.00 0.00 TOTAL SERVICES 2,400.00 2,400.00 19,600.00 2,577.24 20,200.00 600.00 SUPPLIES 2650-53-1100 Supplies & Materials 0.00 0.00 300.00 299.41 300.00 0.00 2650-53-1400 Books/Periodicals 0.00 0.00 500.00 0.00 500.00 0.00 2650-53-1600 Small Equipment 0.00 0.00 1,200.00 0.00 1,200.00 0.00 2650-53-1703 Cash- Over/Short 0.00 0.00 100.00 0.00 100.00 0.00 TOTAL SUPPLIES 0.00 0.00 2,100.00 299.41 2,100.00 0.00 OTHER COSTS 2650-57-1008 Indigent Defense Fees 9,999.80 10,000.01 15,000.00 4,166.70 15,000.00 0.00 TOTAL OTHER COSTS 9,999.80 10,000.01 15,000.00 4,166.70 15,000.00 0.00 TOTAL Municipal Court 12,399.80 12,400.01 155,969.00 98,902.03 167,234.00 11,265.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 22 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Police Administration EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 3210-51-1100 Salaries & Wages 1,292,084.79 1,173,472.47 1,114,825.00 858,456.86 1,157,372.00 42,547.00 3210-51-1200 Part Time/Seasonal Wages 39,677.07 93,644.64 77,378.00 87,801.24 79,699.00 2,321.00 3210-51-1300 Overtime 74,262.80 79,826.97 50,000.00 70,126.68 50,000.00 0.00 3210-51-1400 Employee Benefits 7,694.58 9,500.00 7,200.00 6,400.00 9,600.00 2,400.00 3210-51-2100 Health Insurance Benefits 207,046.84 208,907.19 213,194.00 184,215.11 260,962.00 47,768.00 3210-51-2200 FICA Soc Sec Contribution 87,449.26 83,731.49 77,463.00 61,549.40 80,394.00 2,931.00 3210-51-2300 FICA Medicare Contributio 20,451.79 19,582.37 18,116.00 14,394.71 18,802.00 686.00 3210-51-2400 Retirement Contributions 140,861.03 122,389.89 117,844.00 99,050.17 111,555.00 ( 6,289.00) 3210-51-2700 Workers Compensation 50,245.96 53,664.96 68,079.00 61,189.72 67,969.00 ( 110.00) TOTAL PERSONNEL 1,919,774.12 1,844,719.98 1,744,099.00 1,443,183.89 1,836,353.00 92,254.00 SERVICES 3210-52-1225 Physical Evals 0.00 1,125.00 2,500.00 900.00 2,500.00 0.00 3210-52-1300 Equip Service Contracts 11,484.41 11,574.09 20,000.00 11,338.38 20,000.00 0.00 3210-52-1325 Contract Services - Class 5,151.50 10,685.50 0.00 0.00 0.00 0.00 3210-52-2110 Garbage Charges 584.40 610.29 800.00 481.41 0.00 ( 800.00) 3210-52-2130 Custodial 3,913.54 7,842.50 10,000.00 5,943.28 10,000.00 0.00 3210-52-2201 Repair/Maint-Buildings 966.77 1,836.89 3,000.00 1,381.07 5,000.00 2,000.00 3210-52-2202 Repair/Maint-Vehicles 20,724.09 20,469.83 29,200.00 26,126.85 28,000.00 ( 1,200.00) 3210-52-2203 Repair/Maint-Equipment 2,960.59 3,040.24 5,000.00 2,539.09 7,500.00 2,500.00 3210-52-2320 Rent-Equip & Vehicles 2,251.44 1,363.44 2,500.00 0.00 5,000.00 2,500.00 3210-52-3100 Property & Liability Insu 59,241.35 70,607.27 101,000.00 80,938.74 82,000.00 ( 19,000.00) 3210-52-3220 Postage/Freight 612.42 698.55 700.00 571.50 500.00 ( 200.00) 3210-52-3500 Travel & Related Expenses 15,884.11 16,651.67 22,000.00 19,899.83 19,700.00 ( 2,300.00) 3210-52-3600 Dues, Fees, Tags & Titles 844.20 1,488.30 2,000.00 1,579.00 2,000.00 0.00 3210-52-3602 Certifications 489.00 335.50 2,500.00 1,591.00 2,500.00 0.00 3210-52-3700 Educ &Training 9,298.00 18,065.00 17,500.00 14,558.46 17,500.00 0.00 3210-52-3850 Contract Labor 0.00 14,037.50 0.00 0.00 0.00 0.00 3210-52-3901 Credit Card Svc. Charges 2,018.50 3,814.34 5,000.00 1,457.63 4,000.00 ( 1,000.00) TOTAL SERVICES 136,424.32 184,245.91 223,700.00 169,306.24 206,200.00 ( 17,500.00) SUPPLIES 3210-53-1100 Supplies & Materials 10,088.76 16,783.55 15,000.00 8,461.54 15,000.00 0.00 3210-53-1103 Investigation & I.D. Supp 2,389.29 2,499.87 2,500.00 1,469.09 2,500.00 0.00 3210-53-1185 Community Police Programs 1,110.34 1,458.21 3,000.00 1,546.80 3,000.00 0.00 3210-53-1190 Animal Control Supplies 0.00 41.10 500.00 31.98 500.00 0.00 3210-53-1191 Animal Control Costs 100.00 100.00 150.00 100.00 150.00 0.00 3210-53-1210 Water/Sewer Charges 1,001.01 628.53 900.00 459.00 750.00 ( 150.00) 3210-53-1230 Electricity 28,388.10 24,120.84 29,100.00 19,457.37 28,000.00 ( 1,100.00) 3210-53-1270 Gasoline & Diesel Fuel 66,543.35 44,156.96 51,980.00 38,117.28 54,680.00 2,700.00 3210-53-1310 Food - Officials & Functi 289.34 498.36 2,500.00 460.37 2,500.00 0.00 3210-53-1385 Custody - Food Supplies 349.67 367.85 600.00 216.22 0.00 ( 600.00) 3210-53-1600 Small equipment 8,744.46 3,104.01 5,000.00 2,654.24 15,000.00 10,000.00 3210-53-1601 Safety Equipment 1,653.01 1,636.00 18,850.00 16,628.47 18,850.00 0.00 3210-53-1603 Protective Gear 4,555.00 6,596.50 7,500.00 6,558.88 7,500.00 0.00 3210-53-1615 Small Equipment-camera's 11,427.05 33,621.04 0.00 0.00 0.00 0.00 3210-53-1616 Small Equipment-radios & 70,916.00 0.00 44,150.00 3,678.15 44,150.00 0.00 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 23 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Police Administration EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ 3210-53-1619 Small Equipment-Storm Dam 0.00 0.00 3,000.00 0.00 0.00 ( 3,000.00) 3210-53-1620 Small Equipment-Tech Fees 26,083.41 19,202.08 18,000.00 4,286.42 18,000.00 0.00 3210-53-1720 Uniforms & Accessories 12,497.63 12,474.26 20,000.00 14,269.77 20,000.00 0.00 TOTAL SUPPLIES 246,136.42 167,289.16 222,730.00 118,395.58 230,580.00 7,850.00 CAPITAL OUTLAY 3210-54-2100 Capital Equipment 0.00 73,761.84 38,000.00 26,542.57 35,000.00 ( 3,000.00) 3210-54-2125 Software - Capital 0.00 999.92 0.00 0.00 0.00 0.00 3210-54-2200 Vehicles 53,907.38 0.00 0.00 0.00 110,000.00 110,000.00 3210-54-2300 Furnitures & Fixtures 879.92 8,976.46 3,000.00 0.00 3,000.00 0.00 TOTAL CAPITAL OUTLAY 54,787.30 83,738.22 41,000.00 26,542.57 148,000.00 107,000.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Police Administration 2,357,122.16 2,279,993.27 2,231,529.00 1,757,428.28 2,421,133.00 189,604.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 24 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Beach Patrol EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 3215-51-1100 Salaries & Wages 0.00 0.00 151,018.00 101,179.80 238,560.00 87,542.00 3215-51-1200 Part Time/Seasonal Wages 54,651.31 95,988.16 90,480.00 18,617.87 0.00 ( 90,480.00) 3215-51-1300 Overtime 7,171.68 7,410.08 5,600.00 11,002.56 5,600.00 0.00 3215-51-2100 Health Insurance Benefits 19.86 103.88 63,117.00 22,267.96 73,795.00 10,678.00 3215-51-2200 FICA Soc Sec Contribution 3,832.38 6,516.51 15,342.00 9,745.80 15,138.00 ( 204.00) 3215-51-2300 FICA Medicare Contributio 896.44 1,524.14 3,589.00 2,279.30 3,540.00 ( 49.00) 3215-51-2400 Retirement Contributions 0.00 0.00 4,865.00 4,053.50 8,720.00 3,855.00 3215-51-2700 Workers Compensation 2,079.27 1,881.81 12,963.00 2,948.71 12,548.00 ( 415.00) TOTAL PERSONNEL 68,650.94 113,424.58 346,974.00 172,095.50 357,901.00 10,927.00 SERVICES 3215-52-2203 Repair & Maintain - Equip 1,313.04 1,406.50 1,500.00 1,222.33 0.00 ( 1,500.00) TOTAL SERVICES 1,313.04 1,406.50 1,500.00 1,222.33 0.00 ( 1,500.00) SUPPLIES 3215-53-1100 Supplies & Materials 0.00 69.83 500.00 20.90 500.00 0.00 3215-53-1600 Small Equipment 1,239.85 1,493.26 2,000.00 0.00 2,000.00 0.00 3215-53-1601 Safety Equipment 273.45 350.00 500.00 0.00 500.00 0.00 3215-53-1720 Uniforms 1,893.88 1,892.00 4,000.00 3,091.08 4,000.00 0.00 TOTAL SUPPLIES 3,407.18 3,805.09 7,000.00 3,111.98 7,000.00 0.00 CAPITAL OUTLAY ______________ ______________ ______________ ______________ ______________ ______________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Beach Patrol 73,371.16 118,636.17 355,474.00 176,429.81 364,901.00 9,427.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 25 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund City Marshall EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL ______________ ______________ ______________ ______________ ______________ ______________ ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 26 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Fire Administration EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 3510-51-1100 Salaries & Wages 71,097.19 131,343.51 185,533.00 134,771.11 304,836.00 119,303.00 3510-51-1200 Part Time/Seasonal Wages 87,160.62 43,595.26 53,936.00 39,829.82 55,554.00 1,618.00 3510-51-1201 Volunteer Awards 700.00 300.00 300.00 0.00 0.00 ( 300.00) 3510-51-1300 Overtime 88.07 822.77 6,000.00 7,098.61 12,500.00 6,500.00 3510-51-1400 Employee Benefits 1,100.00 1,700.00 2,400.00 2,000.00 2,400.00 0.00 3510-51-2100 Health Insurance Benefits 18,774.98 16,733.97 44,841.00 30,746.19 82,492.00 37,651.00 3510-51-2200 FICA Soc Sec Contribution 9,929.02 11,021.37 15,592.00 11,389.44 23,268.00 7,676.00 3510-51-2300 FICA Medicare Contributio 2,322.11 2,577.56 3,688.00 2,663.71 5,442.00 1,754.00 3510-51-2400 Retirement Contributions 10,040.00 8,727.84 8,224.00 6,852.60 14,290.00 6,066.00 3510-51-2500 GA Firefighters Pen Fund 4,225.00 4,400.00 4,500.00 2,500.00 6,000.00 1,500.00 3510-51-2600 Unemployment Insurance 0.00 0.00 3,583.00 3,583.00 12,084.00 8,501.00 3510-51-2700 Workers Compensation 4,187.00 4,787.00 7,968.00 6,783.49 0.00 ( 7,968.00) TOTAL PERSONNEL 209,623.99 226,009.28 336,565.00 248,217.97 518,866.00 182,301.00 SERVICES 3510-52-1325 Contract Services - Class 0.00 743.00 0.00 0.00 0.00 0.00 3510-52-2110 Garbage 224.00 262.59 260.00 253.17 300.00 40.00 3510-52-2201 Repair & Maintain - Build 1,474.67 2,610.72 10,000.00 9,248.20 15,000.00 5,000.00 3510-52-2202 Repair & Maintain - Vehic 13,820.67 12,967.78 20,000.00 8,648.82 20,000.00 0.00 3510-52-2203 Repair & Maintain - Equip 4,395.73 8,022.24 12,000.00 3,903.58 12,000.00 0.00 3510-52-3100 Property & Liability Insu 15,385.50 18,211.45 23,000.00 16,017.96 30,000.00 7,000.00 3510-52-3200 Communication 7,880.09 840.81 10,000.00 2,938.62 10,000.00 0.00 3510-52-3220 Postage & Freight 392.48 199.54 500.00 152.36 500.00 0.00 3510-52-3500 Travel & Related Expenses 0.00 147.01 3,400.00 795.35 3,400.00 0.00 3510-52-3600 Dues and Fees 144.30 346.00 500.00 200.57 500.00 0.00 3510-52-3603 Ga Firefighters Assoc Con 0.00 ( 1,092.50) 0.00 0.00 0.00 0.00 3510-52-3700 Education & Training 394.87 1,276.22 11,150.00 3,066.09 11,150.00 0.00 3510-52-3850 Contract Labor 13,469.00 300.00 8,000.00 80.00 8,000.00 0.00 TOTAL SERVICES 57,581.31 44,834.86 98,810.00 45,304.72 110,850.00 12,040.00 SUPPLIES 3510-53-1100 Supplies & Materials 896.54 6,052.60 7,000.00 4,726.53 9,000.00 2,000.00 3510-53-1102 Flags 97.95 0.00 100.00 0.00 100.00 0.00 3510-53-1103 Medical supplies - expend 1,166.43 2,078.90 4,000.00 301.48 4,000.00 0.00 3510-53-1120 Marine Rescue Operations 0.00 0.00 300.00 0.00 300.00 0.00 3510-53-1210 Water & Sewer 799.85 678.91 825.00 583.70 900.00 75.00 3510-53-1220 Propane 1,184.99 258.09 1,500.00 365.08 1,500.00 0.00 3510-53-1230 Electricity 6,079.53 5,767.50 5,316.00 4,471.18 5,400.00 84.00 3510-53-1270 Gasoline & Diesel Fuel 5,495.64 4,265.66 6,000.00 4,655.97 6,000.00 0.00 3510-53-1271 Gasoline - EMS Chatham C( 345.09) 0.00 700.00 0.00 700.00 0.00 3510-53-1300 Volunteer Apprec -Wed Dri 1,787.96 1,465.34 2,000.00 516.78 2,000.00 0.00 3510-53-1400 Books & periodicals 70.00 0.00 1,000.00 0.00 1,000.00 0.00 3510-53-1600 Small Equipment 7,061.57 10,753.24 7,500.00 6,436.90 7,500.00 0.00 3510-53-1601 Breathing Apparatus 3,979.40 455.55 500.00 0.00 750.00 250.00 3510-53-1602 Hose, accessories 175.00 1,016.00 4,850.00 4,850.00 6,000.00 1,150.00 3510-53-1603 Protective gear 30,489.30 24,702.65 9,000.00 3,058.95 9,000.00 0.00 3510-53-1710 Volunteer Apprec Awards D 3,419.00 3,450.00 4,000.00 3,775.95 4,000.00 0.00 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 27 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Fire Administration EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ 3510-53-1720 Uniforms & Accessories 1,488.35 3,746.83 5,000.00 4,468.78 8,000.00 3,000.00 TOTAL SUPPLIES 63,846.42 64,691.27 59,591.00 38,211.30 66,150.00 6,559.00 CAPITAL OUTLAY ______________ ______________ ______________ ______________ ______________ ______________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS 3510-57-5000 Loss on Disposition of F/ 0.00 666.67 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 0.00 666.67 0.00 0.00 0.00 0.00 TOTAL Fire Administration 331,051.72 336,202.08 494,966.00 331,733.99 695,866.00 200,900.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 28 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Emergency Management EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 3920-51-1100 Salaries and Wages 38,307.86 39,793.43 40,517.00 32,064.90 41,736.00 1,219.00 3920-51-1400 Employee Benefits 1,200.00 1,100.00 1,200.00 1,000.00 1,200.00 0.00 3920-51-2100 Health Insurance Benefits 9,921.89 10,566.90 11,164.00 9,912.76 13,330.00 2,166.00 3920-51-2200 FICA Social Security Cont 2,449.57 2,535.41 2,586.00 2,050.03 2,662.00 76.00 3920-51-2300 FICA Medicare Contributio 572.79 592.98 605.00 479.51 623.00 18.00 3920-51-2400 Retirement Contributions 5,025.00 4,904.33 4,243.00 3,535.40 4,015.00 ( 228.00) 3920-51-2700 Workers Compensation 160.00 167.67 225.00 247.78 232.00 7.00 TOTAL PERSONNEL 57,637.11 59,660.72 60,540.00 49,290.38 63,798.00 3,258.00 SERVICES 3920-52-1300 Equipment Service 0.00 0.00 150.00 0.00 150.00 0.00 3920-52-1325 Contract Services - Class 0.00 372.00 0.00 0.00 0.00 0.00 3920-52-3100 Property & Liability Insu 409.77 453.48 600.00 477.33 600.00 0.00 3920-52-3225 CRS - Flood Awareness 360.00 660.00 1,135.00 1,080.00 12,000.00 10,865.00 3920-52-3500 Travel and Related 110.05 118.72 500.00 0.00 500.00 0.00 3920-52-3700 Education & Training 315.00 120.00 500.00 0.00 500.00 0.00 3920-52-3900 Fire Ext. Maintenance 1,507.50 1,776.53 1,850.00 671.00 2,000.00 150.00 TOTAL SERVICES 2,702.32 3,500.73 4,735.00 2,228.33 15,750.00 11,015.00 SUPPLIES 3920-53-1100 Supplies - Emergency Mgmt 95.92 38.49 112.00 1,928.95 200.00 88.00 3920-53-1107 Emergency Rations and Sup 670.92 810.68 1,000.00 2,715.08 1,000.00 0.00 3920-53-1600 Small Equipment 3,584.25 59.76 150.00 0.00 575.00 425.00 3920-53-1720 Uniforms 188.00 278.64 450.00 240.96 450.00 0.00 TOTAL SUPPLIES 4,539.09 1,187.57 1,712.00 4,884.99 2,225.00 513.00 CAPITAL OUTLAY ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Emergency Management 64,878.52 64,349.02 66,987.00 56,403.70 81,773.00 14,786.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 29 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Public Works EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 4210-51-1100 Salaries & Wages 653,851.96 705,183.78 708,033.00 532,917.50 737,364.00 29,331.00 4210-51-1300 Overtime 25,415.22 24,814.45 14,200.00 22,145.61 42,000.00 27,800.00 4210-51-1400 Employee Benefits 12,700.00 11,800.00 12,000.00 8,600.00 12,000.00 0.00 4210-51-2100 Health Insurance Benefits 140,418.35 142,158.19 155,994.00 120,257.15 195,987.00 39,993.00 4210-51-2200 FICA Soc Sec Contribution 42,586.44 45,661.63 47,866.00 34,646.95 49,065.00 1,199.00 4210-51-2300 FICA Medicare Contributio 9,959.92 10,678.95 11,199.00 8,102.84 11,475.00 276.00 4210-51-2400 Retirement Contributions 86,215.04 68,614.97 69,428.00 57,856.90 71,390.00 1,962.00 4210-51-2700 Workers Compensation 35,055.36 21,203.48 37,357.00 28,522.49 39,135.00 1,778.00 TOTAL PERSONNEL 1,006,202.29 1,030,115.45 1,056,077.00 813,049.44 1,158,416.00 102,339.00 SERVICES 4210-52-1201 Studies, Survey, Consulta 400.00 0.00 0.00 0.00 0.00 0.00 4210-52-1325 Contract Services - Class 0.00 6,687.00 0.00 0.00 0.00 0.00 4210-52-2140 Landscaping/Lawncare 2,636.24 8,096.10 10,000.00 3,396.65 10,000.00 0.00 4210-52-2141 Trees - Palms Up 500.00 2,455.00 3,000.00 2,400.00 3,000.00 0.00 4210-52-2200 Repair and Maintanance 57,154.71 0.00 0.00 0.00 0.00 0.00 4210-52-2201 Repair & Maintain - Build 1,160.71 2,385.73 3,170.00 52.65 3,170.00 0.00 4210-52-2202 Repair & Maintain - Vehic 13,875.22 55,632.55 60,000.00 37,013.72 60,000.00 0.00 4210-52-2203 Repair & Maintain - Equip 2,336.72 4,247.48 11,000.00 9,510.00 11,000.00 0.00 4210-52-2205 Repair & Maint- Infrastru 27,718.20 45,363.10 47,500.00 10,221.33 37,500.00 ( 10,000.00) 4210-52-2219 Repair & Maint -Infras Da 0.00 0.00 0.00 0.00 19,550.00 19,550.00 4210-52-2320 Rental - Equipment & Vehi 1,150.10 1,700.00 2,500.00 1,703.40 2,500.00 0.00 4210-52-3100 Property & Liability Insu 30,924.00 26,259.05 23,400.00 14,953.47 19,000.00 ( 4,400.00) 4210-52-3220 Postage & Freight 173.37 111.24 200.00 0.00 200.00 0.00 4210-52-3300 Advertising 160.00 100.00 200.00 0.00 200.00 0.00 4210-52-3500 Travel & Related Expenses 664.04 790.43 1,000.00 821.20 1,000.00 0.00 4210-52-3600 Dues, Fees & Licenses 17,736.00 13,602.08 21,075.00 18,060.53 18,000.00 ( 3,075.00) 4210-52-3700 Education and Training 2,417.44 1,437.72 4,000.00 2,438.46 4,000.00 0.00 4210-52-3850 Contract Labor 0.00 1,992.00 15,000.00 5,280.00 10,000.00 ( 5,000.00) 4210-52-3990 Service Charges, Late Cha 0.00 1,264.30 9,500.00 1,756.78 9,500.00 0.00 TOTAL SERVICES 159,006.75 172,123.78 211,545.00 107,608.19 208,620.00 ( 2,925.00) SUPPLIES 4210-53-1100 Supplies & Materials 20,963.87 17,750.24 19,925.00 12,517.18 20,000.00 75.00 4210-53-1105 Public Restroom Supplies 15,923.32 16,640.08 16,000.00 7,456.33 16,000.00 0.00 4210-53-1210 Water/Sewer Charges 1,435.45 1,004.20 2,000.00 1,052.92 2,000.00 0.00 4210-53-1230 Electricity 117,415.92 116,935.29 120,000.00 86,253.27 120,000.00 0.00 4210-53-1270 Gasoline & Diesel Fuel 48,851.70 28,220.96 51,000.00 22,597.37 51,000.00 0.00 4210-53-1400 Books & Periodicals 0.00 43.98 0.00 0.00 0.00 0.00 4210-53-1600 Small Equipment 3,998.36 18,515.41 24,100.00 2,166.72 24,100.00 0.00 4210-53-1601 Safety Equipment 8,467.61 8,029.70 9,000.00 7,866.77 9,000.00 0.00 4210-53-1702 Signs - various 7,216.46 7,425.92 25,000.00 2,438.38 15,000.00 ( 10,000.00) 4210-53-1720 Uniform/ Clothing 3,656.61 5,179.82 7,000.00 5,944.11 7,000.00 0.00 TOTAL SUPPLIES 227,929.30 219,745.60 274,025.00 148,293.05 264,100.00 ( 9,925.00) 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 30 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Public Works EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 4210-54-1100 Site Improvement 0.00 16,460.00 0.00 0.00 0.00 0.00 4210-54-1315 Building Improvements 0.00 6,208.22 0.00 269.33 0.00 0.00 4210-54-1410 Infrastructure 9,212.00 62,000.20 83,000.00 19,688.90 83,000.00 0.00 4210-54-1416 Infrastructure - LMIG Gra 34,665.00 43,450.00 40,000.00 0.00 40,000.00 0.00 4210-54-2100 Machinery & Equipment 195,900.00 37,698.79 75,000.00 0.00 75,000.00 0.00 4210-54-2200 Vehicles 0.00 13,700.00 65,000.00 16,214.95 65,000.00 0.00 TOTAL CAPITAL OUTLAY 239,777.00 179,517.21 263,000.00 36,173.18 263,000.00 0.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Public Works 1,632,915.34 1,601,502.04 1,804,647.00 1,105,123.86 1,894,136.00 89,489.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 31 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Street Cleaning EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES ______________ ______________ ______________ ______________ ______________ ______________ ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 32 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Storm Drainage EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES 4250-52-1201 Studies, Survey, Consulta 11,374.92 7,500.00 12,000.00 6,250.00 12,000.00 0.00 TOTAL SERVICES 11,374.92 7,500.00 12,000.00 6,250.00 12,000.00 0.00 CAPITAL OUTLAY ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Storm Drainage 11,374.92 7,500.00 12,000.00 6,250.00 12,000.00 0.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 33 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Solid Waste Collection EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES 4520-52-2110 Curbside Dry Trash Pickup 112,785.76 119,276.90 0.00 0.00 0.00 0.00 4520-52-2111 City Dump Pick Up -Waste 130,358.20 92,993.73 150,000.00 79,304.17 90,000.00 ( 60,000.00) TOTAL SERVICES 243,143.96 212,270.63 150,000.00 79,304.17 90,000.00 ( 60,000.00) CAPITAL OUTLAY 4520-54-1410 Infrastruture 0.00 43,903.78 0.00 0.00 0.00 0.00 4520-54-2100 Machinery & Equipment 28,781.46 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 28,781.46 43,903.78 0.00 0.00 0.00 0.00 TOTAL Solid Waste Collection 271,925.42 256,174.41 150,000.00 79,304.17 90,000.00 ( 60,000.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 34 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Cultural & Recreation EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL ______________ ______________ ______________ ______________ ______________ ______________ SERVICES 6110-52-2110 Garbage Charges 1,923.98 2,359.45 2,200.00 2,617.83 3,200.00 1,000.00 6110-52-3100 Property & Liability Insu 9,069.07 7,763.16 8,400.00 0.00 8,400.00 0.00 TOTAL SERVICES 10,993.05 10,122.61 10,600.00 2,617.83 11,600.00 1,000.00 SUPPLIES 6110-53-1150 Holiday expense 22,417.59 22,309.15 23,000.00 21,613.55 23,000.00 0.00 6110-53-1210 Water/Sewer Charges 3,598.62 3,735.92 4,000.00 2,878.22 4,000.00 0.00 6110-53-1230 Electricity 62,215.51 61,049.62 62,200.00 47,048.29 62,200.00 0.00 TOTAL SUPPLIES 88,231.72 87,094.69 89,200.00 71,540.06 89,200.00 0.00 CAPITAL OUTLAY 6110-54-1315 Building Improvements 0.00 0.00 32,100.00 1,567.60 32,100.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 32,100.00 1,567.60 32,100.00 0.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS 6110-57-2000 Fresh Air Home 0.00 350.00 500.00 500.00 500.00 0.00 6110-57-2001 Tybee Island Maritime Aca 0.00 19,000.00 10,000.00 10,000.00 10,000.00 0.00 6110-57-2004 Yeepies 561.43 472.16 575.00 429.00 600.00 25.00 6110-57-2007 Veteran's Monument Commit 0.00 30,000.00 0.00 0.00 0.00 0.00 6110-57-2008 Friends of the Tybee Thea 7,500.00 10,000.00 25,000.00 25,000.00 25,000.00 0.00 6110-57-2010 Garden Club 0.00 500.00 500.00 500.00 500.00 0.00 6110-57-2011 Irish Heritage 750.00 750.00 1,500.00 1,500.00 1,500.00 0.00 6110-57-2012 United Way Coastal Empire 3,037.08 3,462.13 0.00 0.00 0.00 0.00 6110-57-2015 Islands Feral Cats Projec 740.00 740.00 740.00 740.00 740.00 0.00 6110-57-2991 Farmers Market 0.00 0.00 500.00 500.00 500.00 0.00 6110-57-2993 Tybee MLK 0.00 0.00 300.00 300.00 300.00 0.00 TOTAL OTHER COSTS 12,588.51 65,274.29 39,615.00 39,469.00 39,640.00 25.00 TOTAL Cultural & Recreation 111,813.28 162,491.59 171,515.00 115,194.49 172,540.00 1,025.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 35 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Recreation Centers EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES 6122-52-3850 YMCA - Director Services 158,450.00 158,450.04 168,950.00 124,670.84 168,950.00 0.00 TOTAL SERVICES 158,450.00 158,450.04 168,950.00 124,670.84 168,950.00 0.00 SUPPLIES ______________ ______________ ______________ ______________ ______________ ______________ CAPITAL OUTLAY ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Recreation Centers 158,450.00 158,450.04 168,950.00 124,670.84 168,950.00 0.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 36 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Lifeguards EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 6124-51-1100 Salaries & Wages 0.00 0.00 0.00 142.02 354,262.00 354,262.00 6124-51-1200 Part Time/Seasonal Wages 308,804.10 319,276.36 319,335.00 147,581.39 0.00 ( 319,335.00) 6124-51-1300 Overtime 0.00 0.00 0.00 0.00 1,200.00 1,200.00 6124-51-2200 FICA Soc Sec Contribution 19,145.84 19,795.20 19,799.00 9,158.87 22,039.00 2,240.00 6124-51-2300 FICA Medicare Contributio 4,477.81 4,629.54 4,630.00 2,142.08 5,154.00 524.00 6124-51-2600 Unemployment Ins 3,843.00 0.00 0.00 0.00 0.00 0.00 6124-51-2700 Workers Compensation 8,732.57 8,951.69 8,988.00 7,547.71 8,988.00 0.00 TOTAL PERSONNEL 345,003.32 352,652.79 352,752.00 166,572.07 391,643.00 38,891.00 SERVICES 6124-52-1226 Lifeguard Certifications 2,561.95 4,797.94 4,500.00 350.00 4,500.00 0.00 6124-52-2201 Repair & Maintain - Build 363.66 891.99 20,892.00 328.53 15,000.00 ( 5,892.00) 6124-52-2203 Repair & Maintain - Equip 5,202.59 5,333.77 7,000.00 2,906.82 10,000.00 3,000.00 6124-52-2320 Rental Equip & Vehicles 0.00 0.00 2,197.00 2,196.60 2,000.00 ( 197.00) 6124-52-3100 Property & Liability Insu 2,358.15 3,732.71 4,400.00 3,556.76 4,500.00 100.00 6124-52-3220 Postage 0.00 16.98 178.00 0.00 178.00 0.00 TOTAL SERVICES 10,486.35 14,773.39 39,167.00 9,338.71 36,178.00 ( 2,989.00) SUPPLIES 6124-53-1100 General Supplies & Materi 2,099.82 1,599.78 8,200.00 4,733.37 10,000.00 1,800.00 6124-53-1104 First Aid Supplies 3,056.41 5,264.44 5,000.00 3,192.10 10,000.00 5,000.00 6124-53-1270 Gas & Diesel Fuel 3,278.44 2,426.45 5,000.00 780.63 5,000.00 0.00 6124-53-1600 Small Equipment 3,171.26 14,859.63 17,803.00 2,865.08 20,000.00 2,197.00 6124-53-1720 Uniforms 5,690.86 6,351.97 6,000.00 615.02 10,000.00 4,000.00 TOTAL SUPPLIES 17,296.79 30,502.27 42,003.00 12,186.20 55,000.00 12,997.00 CAPITAL OUTLAY 6124-54-2200 Capital Outlay - Vehicles 0.00 6,449.00 0.00 13,892.50 14,000.00 14,000.00 6124-54-2505 Lifegrd Capital Equipment 12,121.25 0.00 15,000.00 0.00 0.00 ( 15,000.00) TOTAL CAPITAL OUTLAY 12,121.25 6,449.00 15,000.00 13,892.50 14,000.00 ( 1,000.00) DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Lifeguards 384,907.71 404,377.45 448,922.00 201,989.48 496,821.00 47,899.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 37 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Beach Related EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES 6125-52-1250 Beach Task Force Expense 36,000.00 36,000.00 56,000.00 27,000.00 36,000.00 ( 20,000.00) 6125-52-2110 Garbage Beach Related 0.00 0.00 0.00 ( 333.60) 0.00 0.00 TOTAL SERVICES 36,000.00 36,000.00 56,000.00 26,666.40 36,000.00 ( 20,000.00) SUPPLIES 6125-53-1210 Water/Sewer Chgs 12,614.58 11,526.62 15,000.00 6,629.18 15,000.00 0.00 6125-53-1235 Beach Oper & Maint 38,659.00 29,657.50 49,000.00 24,790.00 47,500.00 ( 1,500.00) 6125-53-1310 Food - Officials & Functi 1,349.99 1,133.04 1,700.00 1,179.33 1,800.00 100.00 TOTAL SUPPLIES 52,623.57 42,317.16 65,700.00 32,598.51 64,300.00 ( 1,400.00) CAPITAL OUTLAY 6125-54-1402 Beach Renourishment 0.00 0.00 0.00 0.00 25,000.00 25,000.00 6125-54-2105 Beach Crossovers 28,590.33 0.00 0.00 0.00 0.00 0.00 TOTAL CAPITAL OUTLAY 28,590.33 0.00 0.00 0.00 25,000.00 25,000.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Beach Related 117,213.90 78,317.16 121,700.00 59,264.91 125,300.00 3,600.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 38 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Museums EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ OTHER COSTS 6172-57-2000 Tybee Is Historic Soc Gra 16,125.00 16,125.00 16,125.00 16,125.00 16,125.00 0.00 6172-57-2001 Marine Science Center Gra 25,212.00 25,212.00 25,212.00 25,212.00 25,212.00 0.00 6172-57-4000 Bad Debt Expense 67,370.00 ( 6,501.00) 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 108,707.00 34,836.00 41,337.00 41,337.00 41,337.00 0.00 TOTAL Museums 108,707.00 34,836.00 41,337.00 41,337.00 41,337.00 0.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 39 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund River's End RV Park EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL ______________ ______________ ______________ ______________ ______________ ______________ ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 40 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Parks Administration EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 6210-51-1100 Salaries 104,653.42 130,143.33 130,308.00 110,550.55 137,654.00 7,346.00 6210-51-1300 Overtime 6,556.76 6,634.17 12,000.00 5,048.02 7,000.00 ( 5,000.00) 6210-51-1400 Employee Benefits 1,100.00 1,200.00 1,200.00 1,000.00 1,200.00 0.00 6210-51-2100 Health Insurance Benefits 37,193.19 35,217.04 45,559.00 34,294.66 50,040.00 4,481.00 6210-51-2200 FICA Social Security Cont 6,986.52 8,554.73 8,937.00 7,229.36 9,043.00 106.00 6210-51-2300 FICA Medicare 1,634.00 2,000.68 2,088.00 1,690.77 2,115.00 27.00 6210-51-2400 Retirement Contributions 13,466.18 12,684.90 12,618.00 10,514.30 13,195.00 577.00 6210-51-2700 Workers Compensation 2,555.37 2,782.26 3,629.00 4,014.27 3,821.00 192.00 TOTAL PERSONNEL 174,145.44 199,217.11 216,339.00 174,341.93 224,068.00 7,729.00 SERVICES 6210-52-1325 Contract Services - Class 0.00 1,486.00 0.00 0.00 0.00 0.00 6210-52-2203 Repair & Maint- Equipment 0.00 0.00 14,100.00 5,532.88 14,100.00 0.00 6210-52-3100 Property & Liability Insu 269.08 304.32 300.00 322.89 500.00 200.00 TOTAL SERVICES 269.08 1,790.32 14,400.00 5,855.77 14,600.00 200.00 SUPPLIES 6210-53-1100 General Supplies and Mate 7,417.50 8,476.60 12,000.00 8,949.54 12,000.00 0.00 6210-53-1102 Flags 0.00 1,566.32 0.00 0.00 0.00 0.00 6210-53-1210 Water/Sewer Chgs 888.27 838.10 1,231.00 623.26 1,200.00 ( 31.00) 6210-53-1230 Electricity 3,994.08 4,155.12 5,900.00 3,324.77 5,900.00 0.00 6210-53-1600 Small Equipment 0.00 7,244.74 8,900.00 2,456.67 7,300.00 ( 1,600.00) TOTAL SUPPLIES 12,299.85 22,280.88 28,031.00 15,354.24 26,400.00 ( 1,631.00) CAPITAL OUTLAY 6210-54-1100 Site Improvements 17,556.70 12,672.00 0.00 0.00 0.00 0.00 6210-54-1410 Infrastructure -PhillipsJ 0.00 0.00 11,880.00 0.00 0.00 ( 11,880.00) TOTAL CAPITAL OUTLAY 17,556.70 12,672.00 11,880.00 0.00 0.00 ( 11,880.00) DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Parks Administration 204,271.07 235,960.31 270,650.00 195,551.94 265,068.00 ( 5,582.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 41 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Park Areas - Concession EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 6222-51-1100 Salaries & Wages 0.00 1,549.13 20,282.00 20,230.39 0.00 ( 20,282.00) 6222-51-1200 Part Time/Seasonal 0.00 313.50 2,040.00 1,974.50 0.00 ( 2,040.00) 6222-51-2100 Health Insurance Benefits 0.00 0.00 1,920.00 1,901.68 0.00 ( 1,920.00) 6222-51-2200 FICA Soc Sec Contribution 0.00 115.49 1,408.00 1,376.70 0.00 ( 1,408.00) 6222-51-2300 FICA Medicare Contributio 0.00 27.01 401.00 321.98 0.00 ( 401.00) 6222-51-2700 Workers Compensation 0.00 0.00 104.00 31.95 0.00 ( 104.00) TOTAL PERSONNEL 0.00 2,005.13 26,155.00 25,837.20 0.00 ( 26,155.00) SERVICES 6222-52-1300 Service Contracts 0.00 0.00 800.00 612.93 0.00 ( 800.00) 6222-52-2110 Garbage Charges 0.00 0.00 1,000.00 1,000.80 0.00 ( 1,000.00) 6222-52-2130 Custodial Services 0.00 2,300.00 36,750.00 17,940.00 40,000.00 3,250.00 6222-52-2200 Repair and Maintanance 0.00 0.00 3,675.00 3,172.39 0.00 ( 3,675.00) 6222-52-2210 Pest Control 0.00 0.00 1,625.00 693.00 300.00 ( 1,325.00) 6222-52-3100 Property & Liability Insu 0.00 0.00 1,000.00 0.00 3,000.00 2,000.00 6222-52-3800 Permits, Regulatory Fees 0.00 0.00 0.00 500.00 0.00 0.00 6222-52-3901 Credit Card Svc. Charges 0.00 0.00 2,250.00 1,829.19 0.00 ( 2,250.00) TOTAL SERVICES 0.00 2,300.00 47,100.00 25,748.31 43,300.00 ( 3,800.00) SUPPLIES 6222-53-1100 Supplies & Materials 0.00 8,205.06 14,816.70 14,558.32 0.00 ( 14,816.70) 6222-53-1210 Water/Sewer Charges 0.00 0.00 1,000.00 1,091.20 30,000.00 29,000.00 6222-53-1230 Electricity 0.00 159.08 2,100.00 2,376.37 5,000.00 2,900.00 6222-53-1520 Groceries-COGS 0.00 1,572.86 3,700.00 3,474.54 0.00 ( 3,700.00) 6222-53-1523 Sundries - COGS 0.00 5,288.10 2,600.00 2,551.13 0.00 ( 2,600.00) 6222-53-1600 Small Equipment 0.00 0.00 3.30 0.00 0.00 ( 3.30) 6222-53-1703 Over/Short 0.00 0.00 10.00 8.42 0.00 ( 10.00) 6222-53-1720 Uniforms 0.00 299.05 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 0.00 15,524.15 24,230.00 24,059.98 35,000.00 10,770.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Park Areas - Concession 0.00 19,829.28 97,485.00 75,645.49 78,300.00 ( 19,185.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 42 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Parkways and Boulevards EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 6230-54-1400 Infrastructure 0.00 0.00 25,000.00 12,500.00 387,500.00 362,500.00 6230-54-1417 Infrastructure - DOT Gran 0.00 0.00 199,000.00 0.00 199,000.00 0.00 TOTAL CAPITAL OUTLAY 0.00 0.00 224,000.00 12,500.00 586,500.00 362,500.00 TOTAL Parkways and Boulevards 0.00 0.00 224,000.00 12,500.00 586,500.00 362,500.00 ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 43 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Zoning and Inspection EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 7220-51-1100 Salaries & Wages 67,086.75 87,309.40 98,151.00 86,313.13 104,894.00 6,743.00 7220-51-1300 Overtime 255.70 126.22 1,000.00 423.23 1,000.00 0.00 7220-51-1400 Employee Benefits 1,500.00 1,000.00 3,000.00 1,000.00 3,000.00 0.00 7220-51-2100 Health Insurance Benefits 11,342.73 12,864.27 18,103.00 18,704.55 24,421.00 6,318.00 7220-51-2200 FICA Soc Sec Contribution 4,212.49 5,482.92 6,333.00 5,440.09 6,504.00 171.00 7220-51-2300 FICA Medicare Contributio 985.15 1,282.31 1,481.00 1,272.30 1,521.00 40.00 7220-51-2400 Retirement contributions 10,890.00 10,828.80 3,214.00 2,678.20 9,585.00 6,371.00 7220-51-2700 Workers Compensation 251.19 222.20 327.00 230.39 442.00 115.00 TOTAL PERSONNEL 96,524.01 119,116.12 131,609.00 116,061.89 151,367.00 19,758.00 SERVICES 7220-52-1100 Studies/Mstr Plan Upd/Sol 0.00 47,580.00 48,000.00 43,920.00 48,000.00 0.00 7220-52-1200 Legal Notices 300.00 190.00 300.00 240.00 300.00 0.00 7220-52-1202 Engineer Review 9,625.00 2,931.25 18,000.00 3,193.75 18,000.00 0.00 7220-52-1203 Engineer Review - Billabl 9,512.50 6,956.26 12,000.00 5,906.25 12,000.00 0.00 7220-52-1205 County Inspection Contrac 33,214.72 45,000.00 50,000.00 33,750.00 50,000.00 0.00 7220-52-1240 Planning Commission expen 1,314.15 0.00 1,500.00 14.00 1,500.00 0.00 7220-52-1300 Contract Services 40,381.75 13,428.75 30,000.00 0.00 0.00 ( 30,000.00) 7220-52-1325 Contract Services - Class 0.00 743.00 0.00 0.00 0.00 0.00 7220-52-2110 Garbage Charges 49.37 49.86 50.00 41.85 60.00 10.00 7220-52-3100 Property & Liability Insu 996.10 1,453.81 1,550.00 1,250.44 1,500.00 ( 50.00) 7220-52-3220 Postage & Freight 211.66 109.12 1,000.00 56.78 1,000.00 0.00 7220-52-3400 Printing & Binding 0.00 0.00 500.00 0.00 500.00 0.00 7220-52-3500 Travel & Related Expenses 369.00 1,203.17 3,480.00 1,517.13 3,480.00 0.00 7220-52-3600 Dues and Fees 721.20 361.90 1,000.00 790.47 1,000.00 0.00 7220-52-3700 Educ & Training 225.00 1,299.00 3,500.00 1,295.00 3,500.00 0.00 TOTAL SERVICES 96,920.45 121,306.12 170,880.00 91,975.67 140,840.00 ( 30,040.00) SUPPLIES 7220-53-1100 Supplies & Materials 1,566.23 775.34 2,500.00 2,115.03 2,500.00 0.00 7220-53-1210 Water/Sewer Chgs 36.66 43.25 60.00 55.06 60.00 0.00 7220-53-1230 Electricity 838.85 886.46 1,030.00 573.21 1,030.00 0.00 7220-53-1400 Books & Periodicals 0.00 265.00 300.00 0.00 300.00 0.00 7220-53-1720 Uniforms 165.90 0.00 170.00 169.90 170.00 0.00 TOTAL SUPPLIES 2,607.64 1,970.05 4,060.00 2,913.20 4,060.00 0.00 CAPITAL OUTLAY 7220-54-2150 GIS 2,500.00 2,500.00 2,500.00 0.00 0.00 ( 2,500.00) TOTAL CAPITAL OUTLAY 2,500.00 2,500.00 2,500.00 0.00 0.00 ( 2,500.00) 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 44 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Zoning and Inspection EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS 7220-57-2000 Payment to Other Agencies 0.00 0.00 0.00 0.00 2,500.00 2,500.00 TOTAL OTHER COSTS 0.00 0.00 0.00 0.00 2,500.00 2,500.00 TOTAL Zoning and Inspection 198,552.10 244,892.29 309,049.00 210,950.76 298,767.00 ( 10,282.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 45 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Better Hometown EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 7300-51-1100 Salaries & Wages 41,967.58 43,659.57 42,828.00 34,335.16 44,117.00 1,289.00 7300-51-1300 Overtime 0.00 0.00 3,000.00 1,101.13 1,000.00 ( 2,000.00) 7300-51-1400 Employee Benefits 1,200.00 1,200.00 1,200.00 1,000.00 1,200.00 0.00 7300-51-2100 Health Insurance 9,928.68 10,169.45 11,191.00 9,928.49 13,360.00 2,169.00 7300-51-2200 FICA Social Security 2,629.87 2,734.81 2,942.00 2,219.72 2,872.00 ( 70.00) 7300-51-2300 FICA Medicare 614.99 639.55 703.00 519.11 672.00 ( 31.00) 7300-51-2400 Retirement Contributions 5,500.00 4,458.63 4,620.00 3,849.30 4,405.00 ( 215.00) 7300-51-2700 Workers Compensation 119.05 119.74 144.00 115.32 148.00 4.00 TOTAL PERSONNEL 61,960.17 62,981.75 66,628.00 53,068.23 67,774.00 1,146.00 SERVICES 7300-52-1300 Contract Services 0.00 6,000.00 6,000.00 6,000.00 0.00 ( 6,000.00) 7300-52-1325 Contract Services - Class 0.00 372.00 0.00 0.00 0.00 0.00 7300-52-2110 Garbage Charges 19.32 18.24 20.00 15.21 20.00 0.00 7300-52-3100 Property & Liability Insu 311.80 376.85 550.00 424.98 550.00 0.00 7300-52-3220 Postage & Freight 0.00 2,349.34 2,400.00 14.04 1,000.00 ( 1,400.00) 7300-52-3300 Advertising 5,645.36 7,769.98 9,620.00 8,396.78 9,620.00 0.00 7300-52-3500 Travel & Related 2,654.38 1,970.12 2,116.00 1,642.94 2,110.00 ( 6.00) 7300-52-3600 Dues & Fees 2,224.59 1,751.50 2,300.00 1,786.01 2,300.00 0.00 7300-52-3700 Education & Training 3,158.00 1,355.00 1,475.00 580.00 1,475.00 0.00 7300-52-3800 Contract Labor 0.00 0.00 8,400.00 2,400.00 4,800.00 ( 3,600.00) 7300-52-3850 BHT Contract Labor 755.00 6,200.00 1,050.00 400.00 1,000.00 ( 50.00) TOTAL SERVICES 14,768.45 28,163.03 33,931.00 21,659.96 22,875.00 ( 11,056.00) SUPPLIES 7300-53-1100 Supplies & Materials 1,235.40 3,290.02 6,510.00 1,612.64 6,510.00 0.00 7300-53-1210 Water Sewer Chgs 12.97 15.76 30.00 20.06 30.00 0.00 7300-53-1230 Electricity 305.74 323.09 300.00 208.91 300.00 0.00 7300-53-1231 Donated Money Expenses 375.00 410.00 3,000.00 200.00 3,000.00 0.00 TOTAL SUPPLIES 1,929.11 4,038.87 9,840.00 2,041.61 9,840.00 0.00 OTHER COSTS 7300-57-2010 Post Theater Sub Grantee 20,000.00 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER COSTS 20,000.00 0.00 0.00 0.00 0.00 0.00 TOTAL Better Hometown 98,657.73 95,183.65 110,399.00 76,769.80 100,489.00 ( 9,910.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 46 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Community Development EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SUPPLIES 7520-53-1100 Supplies and Material 0.00 17,170.00 33,448.00 33,661.68 15,000.00 ( 18,448.00) TOTAL SUPPLIES 0.00 17,170.00 33,448.00 33,661.68 15,000.00 ( 18,448.00) CAPITAL OUTLAY 7520-54-1405 S Beach Business District 12,172.68 0.00 0.00 0.00 10,000.00 10,000.00 TOTAL CAPITAL OUTLAY 12,172.68 0.00 0.00 0.00 10,000.00 10,000.00 DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Community Development 12,172.68 17,170.00 33,448.00 33,661.68 25,000.00 ( 8,448.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 47 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Parking EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ PERSONNEL 7564-51-1100 Salaries & Wages 79,676.64 88,843.04 91,303.00 73,995.22 93,738.00 2,435.00 7564-51-1200 Part Time/Seasonal Wages 43,042.75 60,215.67 70,391.00 49,768.28 96,491.00 26,100.00 7564-51-1300 Overtime 0.00 1,039.92 1,500.00 2,440.93 1,500.00 0.00 7564-51-1400 Employee Benefits 700.00 0.00 2,400.00 1,000.00 2,400.00 0.00 7564-51-2100 Health Insurance Benefits 15,548.04 14,853.56 17,498.00 15,959.79 20,975.00 3,477.00 7564-51-2200 FICA Soc Sec Contribution 7,632.90 9,305.31 10,416.00 7,886.85 12,038.00 1,622.00 7564-51-2300 FICA Medicare Contributio 1,785.14 2,176.29 2,436.00 1,844.50 2,815.00 379.00 7564-51-2400 Retirement Contributions 11,455.00 10,559.88 5,426.00 4,521.20 8,905.00 3,479.00 7564-51-2600 Unemployment Insurance 525.00 0.00 2,409.00 0.00 0.00 ( 2,409.00) 7564-51-2700 Workers Compensation 4,254.34 2,334.49 4,402.00 2,131.04 5,087.00 685.00 TOTAL PERSONNEL 164,619.81 189,328.16 208,181.00 159,547.81 243,949.00 35,768.00 SERVICES 7564-52-1300 Computer service contract 49,775.73 42,884.27 65,000.00 37,482.00 68,000.00 3,000.00 7564-52-1325 Contract Services - Colle 9,010.28 3,610.37 12,000.00 3,007.99 12,000.00 0.00 7564-52-1326 Contract Services - Class 0.00 742.00 0.00 0.00 0.00 0.00 7564-52-1330 Contract Services - Amano 50,700.00 19,800.00 7,000.00 3,900.00 0.00 ( 7,000.00) 7564-52-2110 Garbage Charges 22.64 21.84 27.00 18.18 27.00 0.00 7564-52-2202 Repair & Maint- Vehicles 2,933.07 2,976.96 4,000.00 1,369.10 4,500.00 500.00 7564-52-2203 Repair & Maint- Equipment 1,007.00 0.00 13,000.00 830.00 15,000.00 2,000.00 7564-52-2325 Armored Car Service 1,262.22 1,350.96 3,000.00 1,225.22 3,000.00 0.00 7564-52-3100 Property & Liability Insu 5,582.92 6,493.16 5,100.00 4,166.93 6,500.00 1,400.00 7564-52-3220 Postage & Freight 2,509.60 3,104.23 3,500.00 1,635.34 3,500.00 0.00 7564-52-3300 Advertising 40.00 0.00 40.00 0.00 40.00 0.00 7564-52-3400 Printing & Binding 237.00 0.00 250.00 35.00 250.00 0.00 7564-52-3500 Travel & Related Expenses 0.00 0.00 1,000.00 659.00 1,000.00 0.00 7564-52-3600 Dues and Fees 114.00 142.50 150.00 147.02 150.00 0.00 7564-52-3700 Educ & Training 0.00 0.00 1,000.00 0.00 1,000.00 0.00 7564-52-3850 Contract Services 0.00 0.00 200.00 0.00 200.00 0.00 7564-52-3901 Credit Card Service Charg 130,520.80 130,362.95 138,000.00 88,377.20 140,000.00 2,000.00 TOTAL SERVICES 253,715.26 211,489.24 253,267.00 142,852.98 255,167.00 1,900.00 SUPPLIES 7564-53-1100 Supplies & Materials 14,579.08 17,304.18 19,624.00 12,939.66 19,800.00 176.00 7564-53-1110 Parking Meters 23,410.57 0.00 0.00 0.00 0.00 0.00 7564-53-1210 Water/Sewer Charges 14.22 18.80 32.00 23.93 32.00 0.00 7564-53-1230 Electricity 1,293.68 1,307.07 1,400.00 952.47 1,400.00 0.00 7564-53-1270 Gas & Diesel Fuel 5,550.93 3,236.40 8,300.00 2,487.43 8,300.00 0.00 7564-53-1590 Inventory - Parking Decal 2,552.00 3,209.00 2,880.00 2,880.00 3,250.00 370.00 7564-53-1600 Small Equipment 21,368.49 13,558.28 26,200.00 24,446.05 26,200.00 0.00 7564-53-1701 Cash/ Short-Over deposits 26.00 136.85 100.00 ( 2,114.75) 100.00 0.00 7564-53-1702 Signs 203.36 126.00 300.00 0.00 300.00 0.00 7564-53-1720 Uniforms 422.00 844.83 800.00 512.24 850.00 50.00 TOTAL SUPPLIES 69,420.33 39,741.41 59,636.00 42,127.03 60,232.00 596.00 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 48 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Parking EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ CAPITAL OUTLAY 7564-54-2055 Parking Meter System 424,000.00 0.00 0.00 0.00 0.00 0.00 7564-54-2200 Vehicles 0.00 0.00 15,000.00 15,000.00 15,000.00 0.00 7564-54-2410 Capital Equip 0.00 0.00 73,000.00 0.00 34,500.00 ( 38,500.00) TOTAL CAPITAL OUTLAY 424,000.00 0.00 88,000.00 15,000.00 49,500.00 ( 38,500.00) DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ TOTAL Parking 911,755.40 440,558.81 609,084.00 359,527.82 608,848.00 ( 236.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 49 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Debt Service EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ SERVICES ______________ ______________ ______________ ______________ ______________ ______________ DEBT SERVICE 8000-58-1125 Principle - Phone System 16,492.60 16,971.06 13,051.00 13,050.62 0.00 ( 13,051.00) 8000-58-1145 Note Payable -DPW Current 45,631.97 55,709.27 56,630.00 42,385.29 9,530.00 ( 47,100.00) 8000-58-2230 Interest Expense - Public 2,010.13 1,581.25 680.00 582.60 20.00 ( 660.00) 8000-58-2235 Interest Expense -Phone S 1,158.52 680.06 188.00 136.21 0.00 ( 188.00) 8000-58-3200 Loan Closing Cost Fees 131.10 0.00 0.00 0.00 0.00 0.00 TOTAL DEBT SERVICE 65,424.32 74,941.64 70,549.00 56,154.72 9,550.00 ( 60,999.00) TOTAL Debt Service 65,424.32 74,941.64 70,549.00 56,154.72 9,550.00 ( 60,999.00) ============== ============== ============== ============== ============== ============== 4-25-2017 11:26 AM C I T Y O F T Y B E E I S L A N D PAGE: 50 PROPOSED BUDGET WORKSHEET AS OF: JUNE 30TH, 2017 100-General Fund Other Financing Uses EXPENDITURES ------------- 2017 ------------- 2015 2016 CURRENT Y-T-D + 2018 BUDGET ACTUAL ACTUAL BUDGET ENCUMBERED BUDGET VARIANCE _________________________________________________________________________________________________________________________________________ DEPRECIATION/AMORTIZATIO ______________ ______________ ______________ ______________ ______________ ______________ OTHER COSTS ______________ ______________ ______________ ______________ ______________ ______________ DEBT SERVICE ______________ ______________ ______________ ______________ ______________ ______________ OTHER FINANCING USES 9000-61-1000 Contingency 0.00 0.00 48,737.00 0.00 0.00 ( 48,737.00) 9000-61-1001 Trans out Solid Waste Fun 0.00 0.00 262,526.00 98,542.94 264,050.00 1,524.00 9000-61-1002 Trans out E911 Fund 64,825.11 318,276.00 328,564.00 227,485.63 299,300.00 ( 29,264.00) 9000-61-1003 Transfer Out - Capital Pr 0.00 0.00 0.00 0.00 200,000.00 200,000.00 9000-61-1060 Transfer to Water & Sewer 0.00 0.00 81,558.00 0.00 0.00 ( 81,558.00) 9000-61-1220 Transfer to Grant Fund 22 0.00 0.00 445,410.00 0.00 0.00 ( 445,410.00) 9000-61-1340 Transfer to Capital Grant 0.00 0.00 1,800,000.00 0.00 0.00 ( 1,800,000.00) 9000-61-1555 Trans out River's End RV 135,442.00 0.00 49,913.00 27,946.00 0.00 ( 49,913.00) TOTAL OTHER FINANCING USES 200,267.11 318,276.00 3,016,708.00 353,974.57 763,350.00 ( 2,253,358.00) TOTAL Other Financing Uses 200,267.11 318,276.00 3,016,708.00 353,974.57 763,350.00 ( 2,253,358.00) ============== ============== ============== ============== ============== ============== TOTAL EXPENDITURES 9,312,190.41 8,952,721.59 13,289,975.00 7,159,354.62 12,173,432.00 ( 1,116,543.00) ============== ============== ============== ============== ============== ============== *** END OF REPORT ***