The URL can be used to link to this page

70-06 OrdinanceRECORD OF ORDINANCES Dayton Legal Blank, Inc. Form No. 30043 Ordinance No. 70-06 Passed . 20 AN ORDINANCE TO ADOPT THE ANNUAL OPERATING BUDGET FOR THE FISCAL YEAR ENDING DECEMBER 31, 2007, AND DECLARING AN EMERGENCY. WHEREAS, Section 8.02 (a) of the Dublin City Charter requires the City Manager to prepare and submit the annual budget to City Council; and WHEREAS, City Council has received and reviewed the annual budget for 2007; and WHEREAS, the Administration has incorporated into the attached 2007 Operating Budget all modifications as requested by City Council as a result of the budget review workshops. NOW, THEREFORE, BE IT ORDAINED by the Council o he City of Dublin, Franklin, Union and Delaware Counties, State of Ohio, of the elected members concurring that: Section 1. The 2007 Annual Operating Budget attached as an Exhibit be, and hereby is, adopted. Section 2. This ordinance is declared to be an emergency necessary for the health, safety and welfare of the residents of the City of Dublin, and for the further reason that the annual operating budget must be in effect by January 1, 2007, therefore this Ordinance shall be in effect on January 1, 2007. Passed on this ~~day of ~ ~e~ ~ , 2006. Mayor -Presiding Officer ATTEST: Clerk of Council I hereby certify that copies of this Ordinance/Resolution were posted in the City of Dublin in accordance with Section 731.25 of the Ohio Revised Code. Depu Clerk of Council, Dublin, Ohio City Manager 5200 Emerald Parkway • Dublin, OH 43017 Phone: 614-410-4400 • Fax: 614-410-4490 CITY OF DUBLIN To: Members of Dublin City Council From: Jane S. Brautigam, City Manager 5, ~"~ ~a,,...~., d Date: December 6, 2006 Initiated By: Marsha I. Grigsby, Director of Finance Michele M. Hoyle, Director of Fiscal Administration Re: Ordinance No. 70-06 -Adoption of 2007 Operating Budget SUMMARY: Memo Ordinance No. 70-06 provides for the adoption of the 2007 Operating Budget. Following the 2007 budget review workshops, the modifications requested by City Council have been incorporated in the budget document as well as the companion Annual Appropriations Ordinance, Ordinance No. 79-06. Following are modifications and additional information resulting from the budget workshops: General Fund Community Relations (pages 61-63) Funding for cable television programming was reduced by $54,000 to $81,000. This level of funding provides for production and broadcasting of 22 regular City Council meetings, and for twelve episodes of "It's Happening in Dublin." Further information regarding the revised proposal for cable television is provided in the attached memo from Sandra Puskarcik. Capital Improvements Tax Fund Capital Improvements Tax Fund (pages 209-212) Funding for the portable surveillance system budgeted for Police in 2006 has been carried over and appropriated as part of the 2007 Operating Budget. Implementation of the Wi-Fi system opened new possibilities for this project, and the potential of vendors not previously considered when this project was budgeted. Police and Information Technology are working together on this project and plan to determine a vendor in the first quarter of 2007. Enforcement and Education Fund Police (pages 189-191) The final budget document accurately reflects that Police did not request any funding for 2007 within this Fund. December 7, 2006 Ordinance 70-06 - 2007 Operating Budget Page 2 Sanitary Sewer Fund Streets and Utilities (pages 221-224) Account 2563 has been reduced, as the funding for purchase of the sewer vactor vehicle has been moved into the 2006 Operating Budget. By advancing this purchase into 2006, the City avoids the usual price increase of approximately four percent. In addition, the 2007 model will be produced with a new diesel engine that will add $15,000 to the cost of the vehicle as well as require a low sulphur fuel for which the City does not have the dispensing capability. We will also take delivery of the vehicle earlier in 2007, and will have use of it for more of the year. Ordinance No. 80-06 provides the funding authorization needed for 2006. ()thPr itPmc Several issues were discussed for which follow-up information was requested: - Health benefits for permanent part-time employees -Human Resources will provide information to City Council regarding this issue, including information from other cities as to if these benefits are provided, and to what extent. Included will be analysis of the option of providing coverage for the employee only. That report will be provided to City Council in the first quarter of 2007. - Eligibility issues and the possibility of offering employees incentives to opt out of the City's health insurance plan also are under review; it is anticipated that further information about these issues will be provided to the Administrative Committee of City Council in the first half of 2007 prior to any proposed changes for 2008. - A graph illustrating the funding breakdown by program area of the 2007 Operating Budget is attached. The largest percentage, "General Government", comprises operations of the Offices of Legislative Affairs and the City Manager, as well as those areas that support City operations including Legal Services, Finance, Administrative Services and Fleet Management. The next-largest segment, over one-quarter of budgeted operating funds, is allocated for "Leisure Services", which includes recreation and parks programming, and special events. Police, street lighting and early warning sirens make up "Security of Persons and Property", while "Community Environment" reflects the development functions of Land Use and Long Range Planning and Engineering. "Transportation" includes street maintenance, and transportation signage and traffic signals. Solid Waste Management is reflected as a "Basic Utility" in this graph. (Water and Sewer, as enterprise operations, are not included for the purpose of comparing general operating expenditures.) Finally, because the City's agreement with the Franklin County Board of Health is included as part of General Government, only the cemetery operation is considered "Public Health" for purposes of this graph. - Further information regarding the cost per square foot renovation costs for the proposed renovations at the Dublin Community Recreation Center. A memo from Michelle Crandall is attached. Also noted during discussions at the budget workshops: - The change to a villa at the Memorial Tournament will be made for 2007, and revisited during review of the 2008 Operating Budget. December 7, 2006 Ordinance 70-06 - 2007 Operating Budget Page 3 - Funding is included ($20,000) within the budget for the Office of the City Manager to further explore the potential of implementation of impact fees in some form. However, these funds will not be spent until staff, including the new Director of Land Use and Long Range Planning, provide a recommendation to City Council for consideration as to how to proceed. Attached is a copy of the slide presentation made to City Council by Tom Pippin on May 8, 2006 for your information. RECOMMENDATION: We recommend passage of Ordinance 70-06 (Adoption of the 2007 Operating Budget) as an emergency so that it becomes effective January 1, 2007, as required by the Revised City Charter. Attachments Division of Community Relations 5620 Post Road • Dublin, OH 43017 c~TY of nueLirr Phone: 614-410-4545 • Fax: 614-410-4535 To: Dublin City Council From: Jane S. Brautigam, City Manager Initiated by: Sandra Puskarcik, Director of Community Relations David Ball, Community Relations Specialist Date: December 7, 2006 Re: 2007 DTV Adjustments Memo At the November 15 City Council budget meeting, Dublin City Council modified the Community Relations budget request for 2007 cable TV programming from $135,000 to $81,000. The revised budget allows for 12 monthly episodes of "It's Happening in Dublin" and 22 City Council regular meetings. Attached is a sample week schedule representing our revised plan for DTV programming in 2007. We plan to begin offering programming February with the first monthly episode of "It's Happening in Dublin," the professionally produced 30-minute news magazine show. Shared Vision Communications also will tape the City Council meetings beginning with the first February meeting. In addition, we plan to use existing equipment and an intern to create a series of evergreen "City service" features, which will be developed into a library of stories that will be interspersed with other DTV programming. The features might include such topics as landscaping tips from our horticulture department, holiday safety advice from the police, planting appropriate trees near power lines, and so forth. These topics would be developed using existing City-owned equipment and an intern. The general plan is to offer "It's Happening" and evergreen service features every other day. City Council meetings will be shown on the opposite days. It's also important to note that we arranged these schedules to coordinate with the audio feed that plays while the cable bulletin board is on the air. This audio feed is a local reading service for people with visual impairments and includes The Columbus Dispatch and newspaper advertisements in the morning, serialized books each day and weekly newspapers on Friday afternoons. In preparation for the 2007 Council meetings, staff will be painting the wall behind Council a shade of blue to improve how the meetings look on tape. Shared Vision Communications also believes they have resolved last year's technical problems associated with the sound quality. Community Relations staff will be meeting with representatives of Dublin Schools December 11 to clarify the schools' level of interest in taking advantage of this community communications tool. The City will not be funding their programming, but wants to make this opportunity available to them and believes their participation will result in a broader range of programming. 0 c 0 v a m a v cn v ~n C~ v (D ~• W 0 v a v ~' S 3 O ;Z7 v a 0 m m a ~. 0 m ~' (D v c a 0 ~ -~ -~ ~ 0 ~ 0 O O 00 00 " ~ ~ ' O O ' U1 W CP A W ~ U W W W 'd N W N "d ~ W s ~ N ~ N s ~ ~ ~ -~ O ~ O O .. W O N 00 W 00 N W o W o • W O - ~ W O - 6 ~ W O - O ~ W O ~ ~ O - 3 O - ~ O - ~ O ~ O -o 3 W 0 ~ • W o N ' W o N O v 3 O v ' ~ ~ ~ o a a ~ ~ a o ~ ~ 3 ~ 3 ~ ~ . ~ ~ ~ ~ 3 3 3 ~ ~ ~ ~ 3 ~ ~ ~ 3 3 n ~ ~ ~ ~ o~ ~ ~~~~oo o o o o o o a o o o ~ o r: 'm m o m o m m m m m ~~ (n <n ~ to ~ ~ ~ to ~ ~ c v • ~ n n~ • v • m - v ' o N v ~ v v v v ' ' '~•DD D D D D D D D D D D ~ ~ ~ ~ ~ ~ g g ~ ~ ~ C7 C7 C7 C7 C7 C7 C~ C7 C7 C7 C~ C7 n 2 2 = 2 2 2 = 2 2 2 2 2 ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ N ~ 5 r. D O O O ~ D O D O O ~ cn m m m m m m m m m m m m m o m cc c~ ~ ~" Cn cn cn Cn tn U`> cn (n cn cn c m a • vvvm~~vvv aaa~aaaaa • ~• __ _• _. • . • • ~ a ~• n~ a ~• m a ~. v a _. o ~ ~, a~ a ~• cczap c 2 3 ~ n ~ ~ '~ D ~ D ~ D ~ D ~ D 'U D ~ D "O D ~ D ~ D ~ tn a _ _ ~ _ _ _ ~ ~ '* - 'a `~ ' ~ -1 -i ~ --I -I -i -i --I -1 ~ «. ~ a (~ C7 C7 C7 n C7 C7 C~ C7 C7 N ~ 2 = 2 2 2 2 2 2 2 = 7 ~ ~ ~ ~ ~ ~ ao ~ ~ ~ ~ ~ o o o o o 0 0 0 0 0 0 0 ~ o r; m w m n, m n, m n~ o o m v m m m v co v m m v~ ~n cn ~n in u~ ~n v~ cn ~n cn ~n ~ v a ~ Q ~ : « ~ : . « v -o m -~ v m -o ~ m -o -o ~ a ~~ n ~• ~~ ~• g• ~ ~' ~' . ~' g' ~' D D D D D D D D D D D D 3 = c~ c~ c> c~ c~ c~ ~ c~ C~ c> c~ c~ Q. ~ 2 = = 2 = 2 2 2 = = 2 = o~ ;I7 fn fn ~ ~ r. ~l 1l :U T1 07 (~ O ~ ~ ~ 0 ~ ~ ~ ~ 0 -1 v p~^ ~ ~ fl v v v aoi °o ~ U) (A (A Cn (A Cn (A ' (n ' (n UZ c _a . c 2 ~ n a a ~ a ~ a ~ ~ y n 'D D ~ D ~ D "~ D ~ D ~ D 0 D U D ~ D ~ D ~ ~' ~ ~ ~ ~ a ~ ' a o ~ -I -~ ~ -I -i -~ ~ -I -I fl- °~ y ~ 7 ~ c C7 C) C~ C~ n C~ n C~ C~ C~ x _ 2 2 2 2 2 2 2 2 2 ~ 3 ~ (~ r r r ~7 m ~ :CJ~~~0~ ~ 0 ~ 0 ~ ~ ~ 0 0 0 ~ ~ ~ 0 0 0 °o aoi m ni v v tncn tn ~n tn cn cn tn tn cn ~n tn Q; ~ • C D D ~ ~ ~• ~ cn ~ ~• ~ ~. < < ~ ~ ~•~•~•~•DD m D m D ~ D ~ D m D ~ D ~ D m D m D v D ~ _ ~ -I ~ ~ -I -I ~ --~ -i -i -~ -I c 'o ~ ~ (~c~ C~ C) C~ n (~ C~ C~ C~ C~ c~ n D D ,D 2= 2 2 2 2 2 2 2 2 2 2 . ~ ~ ~ = m m m ~ ~ ~ ~ ~~~~~~~~~ ~ ~ ~ ~ ~ ~ cncn~+ ~ ~. o o o o o o o o o o cn (D ~ CD (D CD CD CD CD tD fD CD v v v~ ID v v v N (D v CD v CD ~ CD m (D v CD v ~D <D 7 vj cc a p CI) (!~ (A (n ' (A (A Ui Cn (A (A ' ~ .~ n. ' QaQ.Qaana~ ~ 5' ~' S' ~ ' ' ' a ~' a S' ~ ~~ a ~' a S" ~ 5 3 ?.nc 2 ~ a ~ m D ~ D ~ D O D m D ~ D ~ D m D m D o D c ~ ~ ~ ~ S S ~ m ~ ~ ='G `~ -i -i -I -i ~ -i -I -i ~ -i . y 3 ~ C7 C7 C7 C7 n C7 C7 C7 C7 C~ N 2 2 2 2 2 2 2 2 2 2 ~ ~ ~ ~ ~ ~ ~3 ~ ~ ~ ~ ~ ~ ~ ~ C~ p p p p p p 0 0 p p f/~ m m m m m m co m rn m co m m m m ~ ~ ~ Cn ~ ~ ~ (~ ~ ~ ~ c 3 v a " v a ' a~ n. ' m Q ' y ~ sv ~ ' n~ : ' v ~ ' v ~ • v a. ' m ~ ~ v ~ ~' v ~' v « ~~ a~ ~ ~' ~ n ~ D ~ D ~ D ~ D ~ D ~ D ~ D ~ D ~ D ~ D Q ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ S ~ ~ -1 -~ ~ -1 -i ~ ~ --1 -i c C~ C~ C~ n n C~ (~ C~ C~ C~ n 2 2 2 2 2 2 2 2 2 2 C7 0 c 3 m n' co .~ r~ I~"'1 r 0 N bA '.d ~/ . ~{ ~~ ^0 ~--~I 0 ^~ P1 N O ~ o °~. it C~ .,~ a V ~~ o L7 0 ~ ~ M 0 C L a~ ~ ~ ~ o ~, a .~~ ~ ~ v ~ V1 .r., C O U r-+ C o C Lam, ~--I .> ~--i W .. .:~ ~r .~ 0 \° 0 N f,ITY OF DLBLIN Office of the City Manager 5200 Emerald Parkway • Dublin, OH 43017 Phone: 614-410-4400 • Fax: 614-410-4490 To: Members of Dublin City Council From: Jane Brautigam, City Manager Date: December 4, 2006 Re: DCRC Renovations -Follow-up from Operating Budget Meeting Initiated by: Michelle L Crandall, Director of Administrative Services Summary Memo During Council's November 15, 2006 operating budget workshop, Council Member Keenan requested a cost per square foot breakdown of the Dublin Community Recreation Center (DCRC) renovation cost estimates. The total preliminary cost estimates for the flooring replacement and front desk/office renovations are $807,139. Including overhead, profit, contingency estimates and architectural fees, the total cost of the floor demolition, floor prep and flooring installation is estimated at approximately $409,000. Please note that this is a revised flooring estimate, as the original breakdown provided to Council did not contain portions of architectural fees and other indirect costs. Approximately 14,300 square feet of flooring is planned for replacement, equating to a cost of $28.60/square foot. The remainder of the project, which is estimated at approximately $398,000, is difficult to break down into a square foot cost estimate, as there are various areas of demolition, renovation and new-build, along with other items such as acoustical tiling on portions of the walls, new furniture/fixtures/equipment, display boards, signage, painting, electrical/mechanical modifications, etc. that are spread throughout the first floor. All of these renovations are planned within the same 14,300 square feet as the floor replacement. ~ ~ W ~ C~ N ~ ~ ~ ~p ~ ~ ~D "S Q . A . ~' l~J D ~ W ~ ~ ~ C D ~ ~' ~ ~~ (C ~ `< ~ (D ~ C ~ n ~ ~ ~ ~ ~ ~ N ~ ~ C7 ~ n ~ ~ ~ ~ ~~ ~ N O ~ ~ ~ o ~ C 3'1 T. C7 ~ Q ~ ~ Z ~ ~ • 0 ~ ~ ~ ~ ~ ~' X ~ CQ O O C ~ Q ~ ~ ~ ~ N ~ N ~ < ~' CD O _ O -, N O o ~ o CD N O ~ ~.. ~ S z~'!. r n •' ~ ~ x ~~© N ~ '~ O ~ a. ~ ~ ~ t1 ~ ~n-r ~ ~ ~ v _~ ~ ~' X ~ (D ~ ~ ~ ~ ~ 0 ~~ _ ~ CD ~ Sp ~ CD ~ Q ~ ~ ~ ~ ~ ~ c~ v n o ~ CD ~ ~ O ~ ~ C7 C fn Q. ~ o ~ ~ ~ N Vii .-. CD ~, ~ _~ ~ O C7 C Cn O. ~ 0 ~ ~ ~ v ~ n r+ ~ ~ ~ ~. ~ Q Q ~, v ~ ~ ~ _ O~ ~ Q r+ n~ o ~, ~~ ~x ~~ V "~ O~ ~: D c~ CD SU W ~ O n N ~ `C ~ h' ~ "~ ~ _ • v ~ ~ p ~ ~ ~ 0 C7 = ~ ~ ~ o ~cQ ~• O ~. ~ C ~ CQ N ~ ~ ~ O ~ C n• ~ ~. ~ ~ ~ ~ ~ ~ Q ~- G~ ~ p CD ~ ~ O N , ,~,~ ~ ~ ~ ~ ~ ~ ~ ^+' O ~ ~ ~ ~ ~' ~~j _ ~ CD ~ ~-~. C ~ c D ~ ~ ~ ~ ~ f~ ' ~ O ~ p C ~ ~ ~ ~ O ~ ~ ~ ~ m ~ ~ CD ~ ~ ~ ~ ~ ~ m ~ ~=. o o , m ~ ~ ~ ~ o ~v ~ o ~ cQ o~ z ~' ~~ ~x ~~ ^ ^ ^ ^ ^ ^ ^ ~~~ ~ ~ ° ~ o rn v ° ~ n o ~ n ~~ o~~ ~' ~ ° ~ ~' ~ Q ~ ~~ ~ ~ m ~ o ~ mQ ~ oo ~ ~cn ~ ~ Do. v ~ ~ o a, ~ ~ '`~ ~ ~ CD CD ~ ~ ~ r+ _ 1~ J~ .~ ~ ~ r+ ~ ~ ~ `~ ~ ~ G ~_ ~- rn ~ CD ~ ~ ~ ~ ~ ~ ~' CD ~ ~ ~ ~• ~ ,-+ ~ ~ ~ O O ~ ~ ~ ~ ~+ ~_ O ~ ~ ~ ~ ~ CD ~ ~ CAD V ~ ~ ~ ~ ~ ~ ~ ~ v ~ n CD ~ ~ ~" Q ~ ~ ~ ~ .J X o~•. r ~ •' ~x ~~ o~~~v~ ~~ ~~~ o O _. ~ ~ ~. N ~ ~~ m~c~' O Sy ~ ~• O n ~ iv ~ ~• ~ O C7 ~ C7 ~. n CD n • ~ ~ ~--~ ~ ~ N CAD v CD ~ ~ ~ n Q ~ n ~ v N ~ p ~ CAD ~ C7 ~ ~ O ~ ~ ~ ~ ~ ~ cD v~ v ~ cD ~ N ~ ~ ~ ~• ~ ~ ~' CD ^* O CD D O ~ ~ ~ ~ ~ ~ cNn ~ ~ ~ ~ p ~' ~- O ~ v ~ N ~ O ~. ~ O~~* z `~ r ~ "' ~x ~~ d7 p ~E„ ~~ z ,~: ~x ~~ W Isom ~ ~ x ~'~s~ ~ ~ o' r* o ~ m ~ o ~o-h ~ ~ ~ (Q~ ~ n- ~ ~ ~ ~ O v ~ ~ n Q n O ~ ~ OJ cn O ~ ~ (Q '~ ~ ~ ~' ~ cn Q rn (D N ~ o ~ ~ -~ CD ~ ~ rn r* m m ~ cQ O .: N ~ ~ ~ ~ < ~ ~ ~ .~ ~ ~ 3 3 c~ v~~. boo (D -~ ~ CD ~ n. ~ ~ .~ ~ ~ (p n O ~ CAD ~. Q ~ ~ CD ~ ~ ~ O ~ ,-+ r+ ~ ~_ ~ O~ O ~ ~ N ~ ~ ~ ~ ~ n. ~ ~ rn ~ ~ ~ ~ ~ ~ ~~ ~~c~ ~ N ~ ~ ~ ~~ o ~ ~ a v ~ ~ ~ X O =F ~ ~ ~D ~ n ~ r+ O -i, ~ ~ ~ CD ~ ~_' CQ~ ~ CD ~ ~ (D (~ ^-- ,-+ ~p O ~ v v ~, Q. m ~ v Q n. v n m II 0 r--r v v 0 CD Cn O C~. (Q O CD O J Q ~. U7 z~ ~x ~~ 0 ~~ cn 0 ~ °c' o ~ ~ m `~ ~ ~ ~'~ ~ ~ -~ ~ m m o ~ ~ ~ p ° ~ o °- o o ~o ~ g~ ~ on n ~ c ~ o m o v ~ ~ o ~ ~ ~ ~ ~ 3 cn z v ,~ ~ ~ o v a O ~ ~ O Q O < ~ Q ~ fA - CD C D ~ ~ -~ ~ ~ C7 n ~ ~ !v ~ _ rt ~ ~ Q ~. ~ ~; ~ n - ~ CD ~Q ~D O O CQ O ~ ~ n O , .~ O ~ N ~ n n Q ~ ~ n (D c Q Z O ~ ~ (A ~ "O ~ ~ ~ ~ n ~ ~ n• ~~ • ~ , -~- C ~ ~ ~ (~D ~ O O cD ~ n p ~ ~' c CD fn v ~'~ o~ m ° n'~ < v N Q ~ ~ gm ~ ~ ~ m <. , ~~ m o ~ m _ ~~ ~ c n o ~~o _ ~3 ~' ° ~ n ~v~ m~ v __ ~ ~ n o ~' N ~, a ~ ~ ~ ~~~~ moo c n ~= ~ ~ `~ Q z ~ ~ ° x . c . . ~- cn ~ cfl O ~ ~~ v ~--r _ C~ ~ ~ Q 0 '"': _. ~ ~ ~ ~ ~ r-r ' C O ~, h O ^~ l~ . . ^ ^ ^ ^ ^ ^ ^ D cn - ~, D T, cn ~ cQ D n m cn cn ~ o ~ ~ ~ v ~ v o ~ ~ ~ ~ ~ ~ ° ~ ~ ° ~ cn ,~ a ~ ~ ~ . ~ ~ ~ v ~ ~ . ~ ~ -~ ~ ' ~ ~ cn ~ ~ ~ ~ ~. ~' ~ cn ~ ~ ~ ~ ~ ~, o 0 ~, 0 ~ ~ o m m ° o ~,. Q C7 p ~ n n' con ° - ~ ~ ~. ~ ~ ° ~ a ~ ~ o ~ ~ o ~ v ~ ~ ~ ~ _ o ~ ~ ~' _ ~ o o ~ c v _ , o co ~ ~ ~ 0 rn o ,~ ~ N cn m ~ cQ ° ~ ~ cn ~ ~ co v ~ ~ ~~ su o ~ ~ ° cn v a rn ~ ~ co ~ ~ ~ ~ < ~ ~ <? ~ ~ ~ v cn ~. -v cn v o ~ ~ o_ ~ ~- _ c~ o c o o Q Q '-~ Q Q ~ ~ ~ ~ ~ rn o ~ ~ ~' ~ o ~ rn . ~ ~ v c~ ~ ~ ~ o v ~ ~ ~ ~ ° ° ~ ~ o ~. ' m m CD ~ ~ ~ ~ ~ m ,,~ ° ~ ~ ~, z ~, ~ ~ a . •• r c ~ ~ n x © ~ ~~ ~_ ~. C7 CD CD -~ cD p ~E~„ ~~ z ~ n ~s ax ~~ ;~ w iv ~ ~ ~ ~ ~ o D ~ ~ ~ v to ~~ ~ =* cu _ ~ G n ~ n n o 3 o ~ O ~ ~ ~ ~, ~ ~ ~ ~, ~ ~ ~ ~ ~ ~ ~ o ~ ~ ~ ~ ~+ ~ .~ ~ = ~~ o o v ~ m ~ ~ ~ D ~' ~ o ~ m Q ~. c B ~ CD ~ `~ o ~ a ~ o o ~ ~' ~ rn o n ~ ~ ~ ~ ~. ~ ~ m cu rn v su' ~ ~.. ~ v ~ ~-r ~ CD r-f- ~ N 'G < CD ~ Q D CD N ~ O C D ~ . ~ Q r+ ~ ~ O v N ~ c Q ~ O N ~ ~ C - ~ ~ ~ ~ CD ~ ~ ~, ~ ~ CD ~ ~ c ~ O v N ~. ~ (D O '~ iU ~- "'I"L CD CD r c~ C~ n -O '~' Q C~ O~ O C C N ~ ~ ~ CD CD ~ ~ ~ , ~ ~ ~ ~ ~ CD CD ~ n ~ ~ C7 CD - ~ ~ ~ ~ ~ Cn n _ ~ ~ r+ r+ ~ - ~~ ~ ~ ~ ~ ~ ~ ~ Q ~ ~~ O ~ ~ ~ ~ ~ ~ CD ~' ~ ~ ~ ~ ~ ~ ~ ~ ~ CD ~ ' " ~ Q 0 CD Q ~ _ ~ O ~ tin ~ ~ ~ C~ ~ ~ C7 ~ C ~ cQ n ~ ~ ~ ~ O O ~ ~ r+ ~ ~ ~ ~ ~ ~ O ~. ~ ~ ~ ~ ~ ,-+ ~G O ~ ,~ n ~ n O ~ ~ ~ O ~ ~ -s ~ N.• ~ ~ ~G ~~ O CD ~ C7 v n~~ v r~'' ~x ~~ CITY 4F DUBLIN Office of the City Manager 5200 Emerald Parkway, Dublin, Ohio 43016 Phone: 614-410-4400 • Fax: 614-410-4490 To: Members of Dublin City Council From: Jane S. Brautigam, City Manager~~ c~-,.-•.~.5 (~ ~ ~ ,,,,J Date: November 2, 2006 Initiated By: Marsha I. Grigsby, Director of Finance Michele M. Hoyle, Director of Fiscal Administration Memo Re: Ordinance 70-06, Authorizing the Adoption of the Annual Operating Budget for 2007 Summary: Ordinance 70-06 authorizes the adoption of the 2007 Annual Operating Budget. City Council workshops to review the proposed 2007 budget are scheduled for Wednesday, November 8, and Wednesday, November 15, at 6:30 p.m. The complete schedule for all workshops is attached. Recommendation: Following completion of the budget workshops, staff will recommend passage of this ordinance on December 11, 2006. Attachments November 2, 2006 CI'Y'Y OF PUBLiN. Office of the To Members of Dublin City Council and Citizens of the City of Dublin: City Manager 5200 Emerald Parkway ublin, Ohio 43011-1006 ._.._:~ne/iDD:614-410-4400 I am pleased to present for your consideration the 2007 Proposed Operating Fax:614-410-4490 Budget for the City of Dublin. Dublin continues to reap the benefits of a Web Site: www.dublin.oh.us diverse economy that successfully addresses the needs of both corporate citizens and residents, allowing the City to provide unparalleled public services. The 2007 Proposed Operating Budget emphasizes the high quality of life we provide for the Dublin community. The 2007 Proposed Operating Budget was prepared in accordance with the City Charter, the time frames established by the annual budget calendar, and adherence to stated financial management policies and guidelines. The 2007 Proposed Operating Budget includes minimal but key personnel additions. A communications technician is added to the Police communications center to meet the increased demand anticipated from the addition of wireless 911 service. Funding for this position is expected to be offset in part by grants from the State of Ohio and Franklin County. Also added are two staff positions within Parks and Open Space - a forestry assistant, whose main focus will be street trees and other duties associated with the City's sidewalk replacement program, and a position to assist with landscape design work for manicured rights-of--way and other work related to transportation projects, and to manage contracts associated with maintaining those projects. The 2007 Proposed Operating Budget also reallocates personnel resources to respond to service needs. In several cases, rather than proposing staff increases, existing vacancies were evaluated and redeployed to better suit work unit staffing needs. Examples include changes within Recreation Services, where funding from a vacant position provides resources to add program supervisors for adult and teen programming, reassignments for existing employees. Engineering also took advantage of several vacant positions to meet clerical and project inspector needs. Recognizing changes in case load, Courts combined two positions, the probation officer and diversion officer, into one job entitled community justice officer. These two full-time positions are now proposed as one full-time and one part-time position. Our ability to capitalize on the opportunities provided by staff vacancies in order to improve service delivery is one of the ways in which the -1- City of Dublin demonstrates accountability and good stewardship of resources to our constituents. New programs are few in number but significant. Following a successful pilot in 2006, Community Relations includes funding of $135,000 to fully implement cable broadcasting of City Council meetings, and "It's Happening in Dublin", a television magazine showcasing events and activities in the City. In 2007, St. Patrick's Day falls on a Saturday, prompting continuation of the traditional "Blarney Bash" in 2007. However, as reflected in the 2007 Proposed Operating Budget, this event shifts in 2008 to a smaller scale focused on Historic Dublin. This change allows Special Events to redirect those efforts and resources toward the Dublin Irish Festival. Because much of the funding for the March event has been part of the previous year's budget, this change in 2008 affects the 2007 Proposed Operating Budget for Special Events. Control of employee benefits costs continues to present a challenge. In spite of plan design changes for non-bargaining employees and communications technicians, 2006 medical claims expenses increased over seventeen percent compared to 2005. It is important to note that as aself-funded entity, we will experience occasional high-claim years. In 2006, claims expenses significantly affected the balance in the Employee Benefits Fund, requiring an average increase in funding rates of seventeen percent for 2007. As we move forward in the Healthy by Choice health management initiative, we are optimistic that our employee wellness efforts, along with continued review of plan design will help mitigate these increases. However, for 2007, this increase impacts the overall growth in personnel costs. The Proposed Operating Budget for 2007 in the General and Special Revenue Funds projects operating revenues of approximately $59.7 million, and operating expenditures of $63.5 million. As a result of successful incentives offered to businesses to relocate or expand in Dublin, economic development represents a significant area of increased expenditures of over twenty percent, recognizing City Council's goal of focusing on well-rounded economic development to ensure the future financial security of the City. The chart below compares total proposed operating revenues to total Proposed Operating expenditures. The "gap" reflected in the prior years has allowed the City to increase capital programming as part of the annual Capital Improvements Program update approved by City Council earlier this year. The 2007 Proposed Operating Budget reflects a 6.55% rate of operating expenditure growth over the 2006 Operating Budget. -2- 2007 Budget by Expenditure Type Capital ~~ Salaries 22 % ~r ~ ~ i yf ~~i ;:,~j~ ,.~ ,~ ~k,~~'~~ 28% ~ u ry ~~ ! 1" f ~~ '~ Debt 11% Benefits Operating 10% Capital ther 1% Expenses 28% The 2007 Proposed Operating Budget continues Dublin's tradition of high quality services to both residents and corporate citizens. At the same time it reflects the fiscal responsibility which the City of Dublin demands, and which our stakeholders deserve. Respectfully submitted, ~~ s. ~~ Jane S. Brautigam City Manager -4- Operating Revenues vs Operating Expenditures in Millions $70 $50 - _ _ $40 - -- -- - -- $30 ~ ~ ~ ~ ~ ~Ja ~Ja ~Ja ,~JV ~Jm awe Boa O~PG O`1'PG O~PG O~`PG ~~PG ~y~\~ ~oQo `LO `LO ~O `y0 `y0 ~p~~° OO~Q ti The City's undesignated General Fund balance, which accounts for the majority of the City's reserves, is projected to be $27.67 million at year-end 2006 (including a $5.7 million advance to be repaid in 2007). This balance equates to approximately 60 percent of the estimated 2006 operating expenditures, including operating transfers, in the General Fund. This level of undesignated fund balance provides a sufficient reserve and is looked upon favorably by rating agencies, as evidenced by the City's Aaa rating from Moody's Investors Service and AAA from Fitch Ratings. A primary focus of the budget process is to ensure that sufficient fund balances are available to provide necessary funding for unanticipated needs or opportunities, and to ensure satisfactory cash flow. The City's conservative budget philosophy has resulted in actual General Fund revenues exceeding actual General Fund expenditures for many years. Since 2000, the General Fund balance has exceeded 50 percent of the General Fund expenditures. The undesignated General Fund balance will continue to be closely monitored to ensure the City's financial stability. As illustrated on the chart below, the 2007 Proposed Operating Budget continues the City's long-standing investment in infrastructure. The largest share of the budget, however, remains employee wages and benefits, making efforts to contain both critical in the long run. In 2007, the City will conduct negotiations with the City's two largest labor unions, the Fraternal Order of Police (representing police officers and sergeants), and the United Steel Workers of America (representing maintenance workers, custodians and mechanics.) The outcome of these negotiations will play a major role in the City's financial flexibility in future budgets. -3- C C.i r~ r~o. ~ ~ ~~`1~~-0 to 2007 Operating Budget CITY OF DUBLIN, OHIO OPERATING BUDGET FOR 2007 TABLE OF CONTENTS City Manager's Budget Message ...................................................................................................... 1 Mission Statement ....................................................................................................................... ... 5 List of Officials ............................................................................................................................ ... 7 City Council Goals ..................................................................................................................... ....9 Dublin Community Profile .......................................................................................................... ..11 Form of Government and City Organizational Structure ........................................................... ..13 Table of Organization ................................................................................................................. ..14 Financial Management Policies ....................................................... ... 15 . ........................................ Accounting and Fund Structure .................................................................................................. .. ..17 Budget Procedures ...................................................................................................................... ..19 Summary By Fund ....................................................................................................................... .. 23 Revenue Projections .................................................................................................................... ..25 Revenue Comparisons -All Funds ................................................................................................ 31 Revenue Comparisons -General Fund ........................................................................................... 32 Expenditure and Budget Summary ................................................................................................ 33 Expenditure and Budget Summary -General Fund ....................................................................... 35 Comparison of Operating Revenues and Expenditures ............................................................... ..36 Appropriations Summary ............................................................................................................ ..37 Appropriations Summary -General Fund .................................................................................. ..38 Staffing Summary ....................................................................................................................... ..39 Debt Administration .................................................................................................................... ..41 2007 Debt Service Schedule ......................................................................................................... 43 Government Finance Officers Association Distinguished Budget Presentation Award .............. ..44 GENERAL FUND City CounciUBoards and Commissions ....................................................................................... 45 Office of the City Manager ............................................................................................................ 49 Miscellaneous Accounts/Contingencies .................................................................................. 53 Human Resources ................................................................................................................... 57 Community Relations .............................................................................................................. 61 Legal Services ......................................................................................................................... 65 Finance Office of the Director of Finance .................................................................... Procurement .............................................................................................. Transfers and Advances ............................................................................ Miscellaneous Accounts ........................................................................... Accounting and Auditing ................................................................................ Taxation .......................................................................................................... Public Service Office of the Director of Public Service ...................... ........................ 69 ........................72 ........................ 75 ........................77 ........................ 81 ........................ 85 . ........................................................... 89 Solid Waste Management .................................................................................................. 93 Fleet Maintenance ............................................................................................................. 97 Engineering ........................................................................................................................... 101 Miscellaneous ................................................................................................................. 104 Building Standards ................................................................................................................ 107 Land Use and Long Range Planning ............................................................................................ 111 Parks and Recreation Parks ...................:..................................................................................................................115 CITY OF DUBLIN, OHIO OPERATING BUDGET FOR 2007 TABLE OF CONTENTS (continued) Economic Development Office of the Director of Economic Development ..................................................................119 --. Administrative Services Office of the Director of Administrative Services .....................:......................................... .123 Information Technology ........................................................................................................ 127 Court Services ....................................................................................................................... 131 Records Management ..................................................................................................... 135 ._ Facilities Management .......................................................................................................... 139 SPECIAL REVENUE FUNDS Street Maintenance and Repair Fund m" Streets and Utilities ............................................................................................................. 143 .:: Engineering ........................................................................................................................... 147 State Highway Improvements Fund ~`'~' Streets and Utilities ............................................................................................................. 151 Engineering .......................................................................................................................... 154 Cemetery Fund Parks and Recreation a Cemetery Maintenance ................................................................................................... 157 Recreation Fund Parks and Recreation Recreation Services ........................................................................................................ 161 Community Recreation Center ........................................................................................ 165 Administrative Services Community Recreation Center -Facilities ....................................................................... 169 `~' Safety Fund Safety Po ice .............................................................................................................................. 173 ~P.. Swimming Pool Fund Parks and Recreation ~~ Dublin Municipal Pools ................................................................................................... 177 ,~-, Permissive Tax Fund ................................................................................................................... 181 HoteUMotel Tax Fund Community Relations ........................................................................................................... 185 Taxation ............................................................................................................................... 187 Education and Enforcement Fund Police ................................................................................................................................... 189 Law Enforcement Trust Fund Po ice ................................................................................................................................... 193 Mayor's Court Computer Fund Court Services ....................................................................................................................... 197 Accrued Leave Reserve Fund .....................................:................................................................ 201 ~_, CITY OF DUBLIN, OHIO OPERATING BUDGET FOR 2007 TABLE OF CONTENTS (continued) DEBT SERVICE FUNDS General Obligation Debt Service Fund ........................................................................................ 205 Special Assessment Debt Service Funds ...................................................................................... 207 CAPITAL PROJECTS FUNDS Capital Improvement Tax Fund ................................................................................................... 209 Parkland Acquisition Fund ........................................................................................................... 213 ENTERPRISE FUNDS Water Fund Streets and Utilities ............................................................................................................... 215 Accounting and Auditing ...................................................................................................... 217 Engineering ........................................................................................................................... 219 Sewer Fund Streets and Utilities ............................................................................................................... 221 Accounting and Auditing ...................................................................................................... 223 Engineering ........................................................................................................................... 22 5 Merchandising Fund Community Relations ....................................................................:....................................... 227 INTERNAL SERVICE FUNDS Employee Benefits Self-Insurance Fund ...................................................................................... 231 Workers' Compensation Self-Insurance Fund .............................................................................. 235 FIDUCIARY FUNDS Income Tax Revenue Sharing Fund ............................................................................................. 239 Agency Fund ................................................................................................................................ 239 Dublin Convention and Visitors Bureau Fund ............................................................................. 239 Glossary of Terms ....................................................................................................................... 241 THIS PAGE LEFT BLANK INTENTIONALLY CITY OF DUBLIN.. December 11, 2006 4 ~~ ~; ~~ ~. ~.. Office of the Cty Manager To Members of Dublin City Council and Citizens of the City of Dublin: 5200 Emerald Parkway Dublin, Ohio 43011-1006 Phane/TDD:614-410-4400 I am pleased to present for your consideration the 2007 Operating Budget for Eax:614-410-4490 the City of Dublin. Dublin continues to reap the benefits of a diverse Web Site: www.dublin.oh.us economy that successfully addresses the needs of both corporate citizens and residents, allowing the City to provide unparalleled public services. The 2007 Operating Budget emphasizes the high quality of life we provide for the Dublin community. ~~ The 2007 Operating Budget was prepared in accordance with the City Charter, the time frames established by the annual budget calendar, and adherence to stated financial management policies and guidelines. ~. '~" The 2007 Operating Budget includes minimal but key personnel additions. A communications technician is added to the Police communications center to meet the increased demand anticipated from the addition of wireless 911 '~" service. Funding for this position is expected to be offset in part by grants from the State of Ohio and Franklin County. Also added are two staff positions within Parks and Open Space - a forestry assistant, whose main '"'° focus will be street trees and other duties associated with the City's sidewalk ,~„ replacement program, and a position to assist with landscape design work for manicured rights-of--way and other work related to transportation projects, and ~"` to manage contracts associated with maintaining those projects. The 2007 Operating Budget also reallocates personnel resources to respond to `" service needs. In several cases, rather than proposing staff increases, existing ,,,,, vacancies were evaluated and reassigned to better suit work unit staffing needs. Examples include changes within Recreation Services, where funding from a vacant position provides resources to add program supervisors for ~, adult and teen programming, reassignments for existing employees. Engineering also took advantage of several vacant positions to meet clerical and project inspector needs. Recognizing changes in case load, Court Services combined two positions, the probation officer and diversion officer, into one job entitled community justice officer. These two full-time positions are now funded as one full-time and one part-time position. Our ability to ~• capitalize on the opportunities provided by staff vacancies in order to improve ~, service delivery is one of the ways in which the City of Dublin demonstrates accountability and good stewardship of resources to our constituents. -1- New programs are few in number but significant. Following a successful pilot in 2006, the 2007 Operating Budget for Community Relations includes ~ funding of $81,000 to fully implement cable broadcasting of City Council „~ meetings, and "It's Happening in Dublin", a television magazine showcasing events and activities in the City. •~ .~ In 2007, St. Patrick's Day falls on a Saturday, prompting continuation of the traditional "Blarney Bash" in 2007. However, as reflected in the 2007 "~" Operating Budget, this event shifts in 2008 to a smaller scale focused on ~,. Historic Dublin. This change allows Special Events to redirect those efforts and resources toward the Dublin Irish Festival. Because much of the funding ~"' for the March event has been part of the previous year's budget, this change in .~ 2008 affects the 2007 Operating Budget for Special Events. Control of employee benefits costs continues to present a challenge. In spite •• of plan design changes for non-bargaining employees and communications technicians, 2006 medical claims expenses were significantly higher than '" originally projected, increasing over eight percent. It is important to note that as aself-funded entity, we will experience occasional high-claim years. In 2006, claims expenses significantly affected the balance in the Employee Benefits Self-Insurance Fund, requiring an average increase in funding rates of seventeen percent for 2007. While employee wellness efforts began in 2006, in 2007, the City will implement the Healthy by Choice health "~ management initiative, in which non-bargaining employees and '^ communications technicians will work actively toward reducing health risks. As we move forward in this health management initiative, we are optimistic '~ that our employee wellness efforts, along with continued review of plan ""° design will help mitigate these increases. However, for 2007, this increase impacts the overall growth in personnel related costs. The Operating Budget for 2007 in the General and Special Revenue Funds projects operating revenues of approximately $59.7 million, and operating ~ expenditures of $63.5 million. As a result of successful incentives offered to '~ businesses to relocate or expand in Dublin, economic development represents a significant area of increased expenditures of over twenty percent, ~ recognizing City Council's goal of focusing on well-rounded economic '"" development to ensure the future financial security of the City . ,r The following chart compares total operating revenues to total operating `°"` expenditures. The "gap" reflected in the prior years has allowed the City to ~, increase capital programming as part of the annual Capital Improvements Program update approved by City Council earlier this year. The 2007 `~` Operating Budget reflects a 6.55% rate of operating expenditure growth over „~ the 2006 Operating Budget. .. -2- Operating Revenues vs Operating Expenditures in Millions $70 $60 - $50 $30 o'~Ja o'~Ja o~J~ o~Ja o~Ja awe ale` ~oO,~P ~oo~P ~oo~P ~oo~P ~oo~P O~~~t~~ oo1~J ,tio `L The City's undesignated General Fund balance, which accounts for the majority of the City's reserves, is projected to be $27.4 million at year-end 2006 (including a $5.7 million advance to be repaid in 2007). This balance equates to approximately 57 percent of the estimated 2006 operating expenditures, including operating transfers, in the General Fund. This level of undesignated fund balance provides a sufficient reserve and is looked upon favorably by rating agencies, as evidenced by the City's Aaa rating from ~~~~ Moody's Investors Service and AAA from Fitch Ratings. A primary focus of the budget process is to ensure that sufficient fund .balances are available to provide necessary funding for unanticipated needs or opportunities, and to ensure satisfactory cash flow. The City's conservative budget philosophy has resulted in actual General Fund revenues exceeding actual General Fund expenditures for many years. Since 2000, the General ~- Fund balance has exceeded 50 percent of the General Fund expenditures. The undesignated General Fund balance will continue to be closely monitored to ensure the City's financial stability. As illustrated on the following chart, the 2007 Operating Budget continues the City's long-standing investment in infrastructure. The largest share of the ~'" budget, however, remains employee wages and benefits, making efforts to ,,,,, contain both critical in the long run. In 2007, the City will conduct negotiations with the City's two largest labor unions, the Fraternal Order of ~"' Police (representing police officers and sergeants), and the United Steel ,.. Workers of America (representing maintenance workers, custodians and mechanics.) The outcome of these negotiations will play a major role in the "" City's financial flexibility in future budgets. -3- ZQ07 Budget by Expenditure Type Capital Salaries 25% 26% Debt Benefits 12% 10% Other Operating Expenses Capital 26% j 1% The 2007 Operating Budget continues Dublin's tradition of high quality services to both residents and corporate citizens. At the same time it reflects the fiscal responsibility which the City of Dublin demands, and which our stakeholders deserve. Respectfully submitted, ~~~5 . ,~ Jane S. Brautigam City Manager -4- t_ITl C)F~ I1t E31.1ti_ '~ Mission Statement ~. The City of Dublin strives to preserve and enhance the unique high quality of life offered to those who live or work in our community by providing the vision, ~, leadership and performance standards which allow for managed growth and development. We endeavor to deliver our services cost-effectively, with an emphasis on quality and innovation. The City of Dublin seeks recognition in the ~~„ field of local government as being responsive, cooperative, and culturally and ~~ environmentally sensitive, while embracing the highest standards of integrity and accountability to those we serve. Core Values The City of Dublin operates under a set of seven key core values: integrity, respect, communication, teamwork, accountability, positive attitude and dedication to service. Staff members use these seven values as the basis for daily decision-making, including the decisions that go into the budget process. -5- >,. THIS PAGE LEFT BLANK INTENTIONALLY CITY OF DUBLiN_ 2007 OPERATING BUDGET CITY OF DUBLIN, OHIO COUNCIL Marilee Chinnici-Zuercher, Mayor Timothy A. Lecklider, Vice- Mayor Cathy A. Boring Michael H. Keenan Thomas M. McCash John G. Reiner Amy J. Salay Clerk of Council, Anne Clarke City Manager, Jane. S. Brautigam Deputy City Manager/Director ofPublic Service -Frank A. Ciarochi Deputy City Manager/Director of Finance -Marsha I. Grigsby Deputy City Manager/ Director of Economic Development -Dana L. McDaniel Deputy City Manager/Chief ofPolice-Michael R. Epperson Director of Law -Stephen J. Smith -7- THIS PAGE LEFT BLANK INTENTIONALLY C11Y OF DUBLUt_ 2007 OPERATING BUDGET -CITY OF DUBLIN Dublin City Council Goals 2006 -2007 To assist the City Manager in the implementation ofCouncil-established goals, all City operating units are charged with placing City Council goals as an operational priority. Although not always reflected as specific budget items in the operating and/or capital improvement budgets, the daily functions and activities of all operating units are closely linked to these goals, and, as such, are important to highlight as part of the overall budget document. On Apri13, 2006, City Council reaffirmed the goals adopted in Resolution 07-05, a statement of the strategic vision for the City of Dublin and goals related to key elements of that vision. These goals are grouped into two categories based on the level of priority determined by consensus of City Council. This motion represents the outcome of City Council's goal setting process, and serves as guide for City residents, visitors, staff and officials in understanding the high quality of life in the City of Dublin. High Priority Goals Ensure well-planned growth for the future of the US 33 Corridor, working in cooperation with other regional jurisdictions. Focus on well rounded economic development to ensure the future financial security of the City of Dublin. This will include retention and expansion of existing businesses and attraction of new businesses and opportunities. Future economic development will building on the City's existing technological and knowledge-based industries. Revitalize Historic Dublin into a vibrant town center through the adoption of an updated vision and development plan for the District. Acquire key pieces of land relative to the City's green space, park, right-of--way and other projected land use needs. Create a vision for the State Route 161 Corridor Plan Moderate Goals Create venues and opportunities for citizen interaction and engagement. Review and evaluate utility options to ensure the best future services for the City of Dublin. Finalize decisions to develop Coffinan Park and evaluate appropriate locations for the municipal complex and other public facilities. Create a vision and development plan for the Bridge Street area, which complements and supports Historic Dublin. Develop integrated parks, pedestrian facilities and open space providing visual and physical connectivity throughout the community. Such facilities should incorporate public art components and utilize lower maintenance elements. -9- THIS PAGE LEFT BLANK INTENTIONALLY C17Y OF DUBLIN_ 2007 OPERATING BUDGET -CITY OF DUBLIN Dublin Community Profile Encompassing approximately 23 square miles, Dublin is in the northwest corner of the Columbus metropolitan area and is home to nearly 38,900 residents and more than 60,000 corporate citizens. Dublin's extensive growth began in the 1970s, due in large part to the completion of the I-270 outerbelt and the development of the Muirfield Village Golf Club and residential community. Due to this rapid business and residential growth, Dublin officially became a city in August 1987. Dublin's residential market offers something for every lifestyle, from historic neighborhoods to contemporary condominiums and breathtaking estates. Dublin residents are primarily upwardly mobile, young, married and employed, with most having children living at home. On the following page, a chart showing Dublin's economic and demographic statistics illustrates the growth in the City over the past ten years. The City owns more than 1,000 acres of parkland and approximately 77 miles of bike paths to complement an active citizenry. The City owns and operates the Dublin Community Recreation Center (an 110,000-square foot facility that includes fitness facilities, two indoor pools, classrooms, community halls and a black-box theater). It also has two outdoor municipal pools. In 2004, Money magazine named Dublin the second best city (under 100,000 population) in which to live in the central region of the United States. The City also enjoys solid financial ratings, having received a Aaa from Moody's Investors Service and AAA from Fitch Ratings. Offering a unique quality of life with natural beauty, historic sights and tourist attractions, Dublin is a great place to live, work and visit. The City of Dublin appreciates art and culture. The City sponsors the Dublin Irish Festival, one of the largest Irish celebrations of its kind in the country. Nearly 92,000 people attended the event in 2006. Dublin also is home to many major companies. It is international headquarters for Wendy's International, Ashland Chemical, Verizon Wireless, Cardinal Health and Online Computer Library Center. The income taxes generated by these and nearly 2,700 other businesses are the primary source of funding for the City. A listing of the City's principal businesses and approximate number of employees is included on the following page. Most of the residents of Dublin live in Dublin City School District, one of the 15 largest school districts in Ohio. Although nearly 13,500 students attend Dublin Schools, the schools consistently perform among the top districts academically in Ohio. -11- 2007 OPERATING BUDGET -CITY OF DUBLIN Demographic and Economic Statistics Last Ten Years Per Estimated Capita Personal Personal Year Population Income Income 1996 22,069 $ 678,334,853 $ 30,737 1997 29,000 891,373,000 30,737 1998 28,826 886,024,762 30,737 1999 30,132 926,167,284 30,737 2000 31,392 1,290,901,824 41,122 2001 34,397 1,414,473,434 41,122 2002 35,500 1,459, 831,000 41,122 2003 36,300 1,492,728,600 41,122 2004 37,590 1,545,775,980 41,122 2005 38,900 1,599,645,800 41,122 EMPLOYER Nationwide Insurance Enterprises Cardinal Health Qwest Communications Dublin City Schools Cellco/Verizon Wireless Ashland Chemical Co. Check Free Corporation Medco Health Solutions, Inc. Wendy's International Online Computer Library Center Pacer Global Logistics CareWorks Laboratory Corp. of America BMW Financial Services OSI Collection Services City of Dublin IBM Corporation Principal Businesses by Employment Percentage of Approx. # Total City Business Rank of Employees Employment (I) Insurance & Financial 1 4,400 5.76% Pharmaceuticals 2 1,773 2.32% Telecommunications 3 1,700 2.23% Education 4 1,608 2.10% Telecommunications 5 1,500 1.96% Research & Developmt 6 1,400 1.83% Electronic Bill Payments 7 900 1.18% Retailers/Wholesalers 8 780 1.02% Restaurant Chain/Corp 9 762 1.00% Computer Library 10 740 0.97% Transportation Logistics I 1 675 0.88% Insurance & Financial 12 625 0.82% Medical Laboratory Testg 13 530 0.69% Financial Institutions 14 440 0.58% Financial Institutions 15 400 0.52% Government 16 390 0.51 Computers/Data Processing 16 390 0.51% 19,013 24.89%~ Note: (l) Total City Employment is based on the number of W-2's filed with the City of Dublin, Department of Taxation for 2005. This figure does not include outstanding accounts receivable and extension filers. Source: City of Dublin, Comprehensive Annual Financial Statement for the fiscal year ended December 31, 2005. -12- ~, a~~ 2007 OPERATING BUDGET -CITY OF DUBLIN Form of Government The City of Dublin was platted as a village under the laws of the State of Ohio in 1810. The City is a home rule municipal corporation and operates under its own charter. Voters adopted the City's original Charter on July 24, 1979, and revised the charter in 1996. The City's original Charter and the Revised Charter have provided for aCouncil/City Manager form of government. The legislative authority is vested by the Charter in aseven-member Council with overlapping four-year terms. Three members are elected at-large and four members are elected from wards. The City Council fixes compensation of City officials and employees, and enacts ordinances and resolutions relating to City services; tax levies; appropriating and borrowing money; licensing and regulating businesses and trades; and other municipal purposes. The presiding officer is the Mayor, who is a member of City Council and is elected by City Council for atwo-year term. The Vice Mayor is also a member of City Council, elected by City Council for atwo-year term. The City Manager is the chief executive and administrative officer of the City and is appointed by the City Council to serve at its pleasure. The City Manager is charged with the responsibility for the administration of all municipal affairs as empowered by the Charter. City Organizational Structure The City's organizational structure is designed to support quality services in a successful, efficient and effective manner. The City Manager is supported by three Deputy City Managers and a Chief of Police, as well as a management team comprised primarily of directors from across the organization. Nearly 400 permanent full-time employees work for the City. -13- Q Z `~ m --~ Z O ~ Q z _ F"' ° o ~ ,~, _ z o ~ ~ a ~ N ~.. Z m ~ Q C~ 0 -14- 2007 OPERATING BUDGET -CITY OF DUBLIN FINANCIAL MANAGEMENT POLICIES OPERATING BUDGET POLICIES • The City will pay for all current expenditures with current revenues and fund balances. The City will avoid budgetary procedures that balance current expenditures at the expense of future years, such as postponing expenditures, underestimating expenditures, overestimating revenues, or utilizing short-term borrowing to balance the budget. • The budget will provide for adequate maintenance and repair of capital assets and for their orderly replacement. • The City will protect against catastrophic losses through a combination of insurance and self-insurance funded programs. • The City will maintain a budgetary control system to help it adhere to the budget. • Financial reports, which compare actual performance with the budget, are available on-line for budgetary review by the departments/divisions. RESERVE POLICIES • The City will appropriate $150,000 to a contingency account in the General Fund to provide for non-recurring and unanticipated expenditures. • For 2007, the City will maintain 20% of the 2006 estimated revenues in the General Fund as reserves to address unforeseen contingencies or to be able to take advantage of opportunities that may arise. CAPITAL IMPROVEMENT PROGRAM POLICIES • The City will develop afive-year Capital Improvements Program on an annual basis. • The City will enact an annual capital improvement budget based on the multi-yeaz Capital Improvements Program. • The City will coordinate development of the capital improvement budget with development of the operating budget. -15- 2007 OPERATING BUDGET -CITY OF DUBLIN DEBT MANAGEMENT POLICIES • The City will confine long-term borrowing to capital improvement projects. • When the City finances capital projects by issuing debt, it will repay the debt within a period not to exceed the expected useful life of the project. • The City will evaluate issuing debt and pay-as-you-go financing to maintain flexibility for the future. • The City will continually seek to maintain and improve our current bond rating to minimize borrowing costs and to ensure that access to credit is preserved. • The City will follow a policy of full disclosure on financial reports and official statements. REVENUE POLICIES • The City will estimate its annual revenues by a conservative, objective, and analytical process. • Non-recurring revenues will be used only to fund non-recurring expenditures. • The City will encourage a diversified and stable local economy to avoid excessive reliance on any one industry or business for income tax revenues. • The City will update the Cost of Services Study on an annual basis to calculate the costs of providing services and consider such information when establishing user charges. PURCHASING POLICIES • Purchases will be made in accordance with federal, state, and municipal requirements. • Purchases will be made in an impartial, economical, competitive, and efficient manner. • Purchases will be made from the lowest priced and most responsive vendor. Qualitative factors such as vendor reputation and financial condition will be considered, as well as price. -16- 2007 OPERATING BUDGET -CITY OF DUBLIN Accounting and Fund Structure Basis of Accounting The City follows the guidance of the Government Accounting Standards Board (GASB) Statement No. 34 in presenting its annual financial statements. Statement No. 34 requires that both government-wide full-accrual basis statements, and fund-level modified-accrual basis statements, be included in annual reports. Under the full-accrual basis of accounting, revenues are recorded when earned, and expenses are recorded at the time a liability is incurred, regardless of the timing of the related cash flows. Under the modified-accrual basis of accounting, revenues are recorded when received, or if they are both measurable and collectible within 60 days after year-end (soon enough to pay currently maturing liabilities). Expenditures are recorded when the related fund liability is incurred, with the exception of certain long-term liabilities which are recognized only when expected to be liquidated with existing resources (such as some compensated absences), or debt service which is recognized when due and paid. Fund AccountinE -Fund Tunes The City of Dublin operates from and administers several different types of funds. A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities. Like other state and local governments, Dublin uses fund accounting to ensure and demonstrate compliance with finance-related requirements. The following are the fund types used by the City: General Fund: The General Fund is the primary operating fund of the City and is used to account for all financial resources except those required to be accounted for in another fund. The largest revenue source to the City's General Fund is the local income tax. The General Fund is used to finance many of the services traditionally associated with local government, including parks, planning, economic development and the general administration of the City government, as well as any other activity for which a special fund has not been created. Special Revenue Funds: Special revenue funds are used to account for the proceeds of specific revenue sources that are legally restricted to expenditures for specified purposes. The City's special revenue funds include the Street Maintenance and Repair Fund, into which the City's share of gasoline taxes and motor vehicle registration fees are deposited; the Recreation Fund, for user fees associated with the City's numerous recreation programs and programs provided at the Dublin Community Recreation Center; and the Safety Fund, into which property tax revenues earmarked for police services and contractual revenues for provision of dispatching services to Washington Township are deposited. The City also has special revenue funds for operation of the City's special events, outdoor pools, and for other purposes. Debt Service Funds: Debt service funds are used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest and related costs. Included are funds for general obligation debt as well as funds generated by special assessments for debt issued to finance those specific projects. -17- 2007 OPERATING BUDGET -CITY OF DUBLIN Fund Accounting -Fund Tvnes (Continued) Capital Projects Funds: Capital projects funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by proprietary funds and trust funds). Enterprise Funds: Enterprise funds are used to account for operations that are financed and operated in a manner similar to private businesses, where the costs of providing goods or services to the general public on a continuing basis are financed or recovered primarily through user charges. The City operates three enterprise funds: Water Fund. The Water Fund is an enterprise fund that accounts for activities associated with the City's water supply. The City is connected to the City of Columbus water system, which provides supply, purification and distribution services. The City is responsible for the construction and maintenance of the water lines. Revenues are derived from user charges, specifically surcharges based on consumption and one-time initial tap-in fees. Expenses relate to the ongoing maintenance of the system. Sewer Fund. The Sewer Fund is an enterprise fund that accounts for activities associated with the City's sanitary sewers. The City is connected to the City of Columbus sanitary sewer system, which provides sewage treatment services. The City is responsible for the construction and maintenance of the sanitary sewer lines. Revenues are derived from user charges, specifically surcharges based on usage and one-time initial tap in fees. Expenses relate to the ongoing maintenance of the system. The City's storm sewers and drainage systems are not included in the fund's activities, but are instead included in governmental activities. Merchandising Fund. The Merchandising Fund accounts for the purchase and sale ofDublin-branded retail merchandise, such as apparel and souvenir items. Internal Service Funds: Internal service funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the City, or to other governmental units, on acost-reimbursement basis. The City maintains two internal service funds to account for the City's employee benefits self- insurance plan and workers' compensation self-insurance plan activities. Citywide program expenditures are incurred in the funds and the City's various departments reimburse the internal service funds for those costs. Fiduciary Funds These funds are used for assets held by the City in a trustee capacity or as an agent for individuals, private organizations, other governmental units, and/or other funds. Agency funds include deposits and unclaimed monies held for individuals and private organizations, hoteUmotel taxes collected on behalf of the Dublin Convention and Visitor's Bureau, building surcharges, sewer capacity charges, court assessments, revenue sharing and payroll withholdings held for other governmental units. -18- 2007 OPERATING BUDGET -CITY OF DUBLIN Budget Procedures Tax Budget The City is required by state statute to adopt an annual appropriation cash basis tax budget. All funds except agency funds are legally required to be budgeted utilizing encumbrance accounting. The tax budget is adopted by City Council, after a public hearing is held, by July 15 of each yeaz. The budget is submitted to the Franklin and Delawaze County Auditors, as Secretaries to the County Budget Commissions, by July 20 of each yeaz, for the period January 1 to December 31 of the following year. Union County no longer requires submission of a Tax Budget. The Franklin County Commission (the Commission) determines if the budget substantiates a need to levy the full amount of authorized property tax rates and reviews revenue estimates. The Commission certifies its actions to the City on or around September 1. As part of this certification, the City receives the official certificate of estimated resources, which states the projected revenue of each fund. On or about January 1, the certificate of estimated resources is amended to include unencumbered fund cash balances at December 31. Prior to December 31, the City must revise its budget so that total contemplated expenditures from any fund during the ensuing total fiscal year will not exceed the amount stated in the certificate of estimated resources. For the 2007 budget yeaz, the tax budget was approved by City Council on June 19, 2006, and was forwarded to the Franklin County Budget Commission before the deadline of July 20, 2006. Basis of Budaetina Budgets for all City fund types are prepazed on a cash basis. This basis of budgeting means that revenues are recorded when received in cash and expenditures aze recorded when encumbered or paid in cash. Appropriations City Council is required by Charter to adopt an appropriation ordinance prior to the beguining of the ensuing fiscal year. The appropriation ordinance controls expenditures at the fund and function or major organizational unit level (the legal level of control) and may be amended or supplemented by Council during the yeaz as required. Appropriations within an organizational unit may be transferred within the same organizational unit with approval of the City Manager. Unencumbered appropriations lapse at year-end and may be reappropriated in the following yeaz's budget. Encumbrances outstanding at year-end are carried forwazd in the following year. The prior yeaz appropriations corresponding to these encumbrances aze also carried forward as part of the budgetary authority for the next year and aze included in the revised budget amounts shown in the budget to actual comparisons. -19- 2007 OPERATING BUDGET -CITY OF DUBLIN Budget Procedures (Continued) Encumbrances The City establishes encumbrances by which purchase orders, contracts and other commitments are recorded to set aside a portion of the applicable appropriation. An encumbrance reserves the available spending authority as a commitment for a future expenditure. Budgetary Controls In addition to internal accounting controls, the City maintains budgetary controls. The objective of these budgetary controls is to ensure compliance with legal provisions outlined in the annual appropriation ordinance approved by City Council. Activities of all funds, with the exception of advances, aze included in the annual appropriation ordinance. All funds except Agency Funds are legally required to be budgeted. Upon adoption of the annual appropriation ordinance by City Council, it becomes the formal budget for City operations. The appropriation ordinance controls expenditures at the object level and may be amended or supplemented by City Council during the year as required. Appropriations within a functional unit maybe transferred within the same unit with approval of the City Manager. Financial reports, which compaze actual performance with the budget, are available on- line to directors so they are able to review the financial status and measure the effectiveness of the budgetary controls. The financial reports are distributed to City Council on a quarterly basis. The City also maintains an encumbrance accounting system as one technique for accomplishing budgetary control. At the end of the yeaz, outstanding encumbrances aze carried forward to the new year and unencumbered amounts lapse. The Annual Budget Process City Council has adopted an annual budget calendar. The calendar has established time frames for preparing, reviewing, and adopting the City's five-yeaz capital improvements program and the annual operating budget. The calendaz is a planning tool that provides consistency from yeaz-to-yeaz and ensures the budget documents are adopted in a timely manner. • General time frames established by annual budget calendar are as follows: - Proposed operating budget completed by the end of October. - City Council review during November. - Adoption by yeaz-end. -20- 2007 OPERATING BUDGET -CITY OF DUBLIN Specific Time Frames for the 2007 Operating Budget July 31, 2006 On-line budgeting set-up was completed. August 15, 2006 A Budget Kick-Off Meeting was held for the City Manager's Executive Team and major divisions, to outline the guidelines under which the 2007 Operating Budget would be developed. August 16, 2996 Following that meeting, the budget development memo was sent to all directors, outlining the same guidelines described above. Review training of the on-line budgeting system was completed at the same time. September 6, 2006 Revenue estimates were completed. Budget requests were forwarded to Directors for fmal review and modifications. September 13.2006 2007 budget requests were submitted to Director of Fiscal Administration. September 25, 2006 Comparison of estimated resources to budget requests, debt service and capital improvement program was completed. . October 2- 6, 2006 Budget review meetings with the Budget Review Committee, consisting of the City Manager, Assistant City Manager, Director of Finance, Director of Fiscal Administration, and the Budget Analyst. October 11, 2006 The Budget Review Committee forwarded proposed adjustments to budget requests to directors. October 29, 2006 Final budget decisions were then incorporated and the budget finalized. November 2, 2006 The proposed 2007 operating budget was assembled for distribution to City Council and City administrative staff. November 6, 2006 First reading by Dublin City Council of the 2007 Operating Budget. November 8, 2006 City Council budget workshop. November 15, 2006 City Council budget workshop. December 11, 2006 Public hearing and passage of the 2007 Operating Budget by Dublin City Council. -21- THIS PAGE LEFT BLANK INTENTIONALLY CITY OF DUBI1Ui_ _O 2 O Z J 07 LL }O ~ ~ UZ H~ W LL (, J ~ Q ~ LL 00 O O } Z ~ Q Q W ~ a~ O~ 0 0 N ~ ~ 000 ~ O~ ~ n O N 000 M ~~~ f~ O CA N O M O_ lI) CA ~ N M O ~~ CA O O N ~ O (D (O O O~ O N N CO I~ N ~ ~ O M ~ M O ~ CO ~-- tb t1) 00 ~ CNO ~ ~ (O (h C ~ ~ ~-- N (U 0] ~ C ~ ~ ~ O O In ~ QD N - ~ N .~ C N W N F- 0000 CAO ' O ' Cn ' 00 y Cn 0 lA N N 0 M N M O -O N N In O Cn P ~~ CD 7 (A O N j 0 h 0 (~ 00 M (O N ~ a 0 N N Cn Cn ~ 00 Cn ~ ~ N O C N Cn N ~ O O O - (U 00 M 1~ O ~ cyi jp M W X W (D Cn ~i~ OMMM000~Cn Cl) 0 M r t0 N O h O CP aD M~ O In ~ ~ N o0 O (p ap CO M a Q) M ~ V (A .0. `~ M hCDMOM000COO NMCO (0 ~ O 000 M~~ N .- r- ~ 0 ~ ~ n ~ O '~ w~> ~ M t` O ~ ~" M as O O ' O O O O ' ' ' ' ' ' ' 'p C O O 0000 ~~ 0 0 0 0 0 w N O ~ O CD CA 'N ~ 0 N '7 00 W ~ 69 Cl) Otn000OO000000 M Cn COMN OOONh 0Cn0 M CC7 M CO CD to et CO to O M N O ~ N M CD (D O N 0~ (A N Ch N N C9 C ~ ~ ~ ~~~~ V M M E ~ ~ ~ ri ~i .~ o ~ wa .O M Cl7 CO I~ ~ M M M M ~ In lf) O M 00 ~! N O CD P O (A 0 CO CO to CA 00 N CO N N r (A CO ~~ O O ~_ O n0 ~ N CO ~ n (A N ~ m t` 00 N ~ U (P n O N CO a0 ~ O M~ ~ ~ M N~ N CO ~ N M CO O O ~ ~ U ~ ~ C ~ N ~ N m C ~ ~ ~ a ..- c Z ~ ~ ~ ~ tL ~~E E w?~ W CO >O U~ N a N ~ ~ $ ~ I- .~ E aNi Z c~ ~j c W o a w CO - o rnU Ww~ ao ~a~i~~c>u J ~ ~~ L CO C>7 j i C ~ Z• V J Q ~ Z' ~, C_ -N O O w O ~ w Q~ N N >' E~~ -~ W~~ 3 V ~ ~ ~ O ~ Z W o.r E v ~? E E~~ 3 ~ ~,~ w a~~a~a~m3a~ovmmmU u C7 v~cncnc)av~<na=wJ~~Q n (A (A 00 N O M QO N h N M M M O O M N ll) In 00 M M O) N CD CO M O M N P CO O 00 O CD ~ ~ ~ N ~ r N O ~ ~ N ~ ~ 0~ (p AMMO N N " " o o " o o o ' _ _ M ~ O to M ~ 0tn O CO O r- ~ ~ 0 ~ 0 0 0 0 0 0 ~ O t C 0 O M 1~ N O O r M O O O 0 to N to M O N O 0 O M N ~ (O to d' ~ M M O ~ P O Cn M ~- 000N NOM00NI~NMM 0 0 M N ~ ~ 0 M n ~ C 0 ~ N ~ ( O O C 0 C O ~ O ~(P P CA~~M~hCO Cn CO N~ ~ O 0N ~ M 0 O i d ' Ch C 0~~ 0 m O ~ N~ ~ h a N O~ i~ p i~ i~ i i~ p O O O O " 0 0 ~ M O O h MO Cn0 00 ' 000000 GOON O R CA 000000 M non M~ ~ooooo ~ ~ O O M O O ~ ~ N N C C C) C O r O .-- r- N CD M N V C1) N M 00~N hOMONhNMM ~ h ~ I~ aD In Cn 00 M M ~ N M~ t` ~ N I~ O to O 0 l!7 0 ~ ~i~tn ~ ~ ~MO (A N~0 0 ~ CO ~ M M E O N N CA 0 N N N N ~ ~ Z x a~i aci a~i ~ ~ U c h N ~ ~ ~ LL LL N N N O U U C~~ LL ~ E a> H ~NQQ O>Ea°ia a~ c o a~-- a o o-a E s~ a~ to ~ ._ ._ m m a n-~°~~H~-LL of"U U U U ` Y ~ Q N CU J E > C I- - Y y ~ (0 Cn !n N ~0 ~ ~ C = ~ ~ U N O .~ ~ O a '~- Y~ O -~ N F U ~E C~cn°-'coy UUdU~~ I~VH~d -23- Z E d c O O Z J m <L H ~ . ~ U Z h- ~ W W (~ J ~ Q ~ LL m O U } Z ~ Qa ~ ~ W ~ a~ ~ 0 O O N ~ CA ' O CO ' f~ 00 00 ' ~ O O O O 00 (0 M M ~ M d' 0 O CC N 0 ~ O O O CA h 0 0 0 (A O ~ f~ V' 1~ O ~ (O (A N ^ nCA (OO NAM OO~OOMh N0M M~ O(Ah O N O 00 O ~ I~ 00 er ~ CA N ~ C ~ ^ M 0 ~ ~ ~ ~ (n CA M ~F ~f 00 0 N ~ 7 CO O 0 r 0 N (O M C (C i ~ (0 0 r m CV ~ ~ C 0 O r r i i r r r r i 0 i i O r r i r r i t r r i ~ O ~ ~ ~ O O O W ~ N N O (O O O E y M M ~ ~ w N ~ y C W N 00000 ' 000 ' O ' 00 ~ f~ ' 000 OO 000 ' N 0 0 0 0 C0 0 0 0 O 0 0 0 N O O N 0 0 0 y .- OO O N O O N O O O O h M 0 ~~ 0 0 0 N Y NNE M 00 O 00 h 000 f~ 0000 CO CO O N 0 ~ O 0 O 0 0 M c} n r O Cp ~~ 0 E C M M 0 to n 0 0 O N E .N W x t} O0)CO ' h 0000 ' 00000000 MM0 MO 000 COO ~ y ~ M 0 O O OlnOao~ (A CA M Ncr(O (A h 0 0 0 (0 O OCn~OOMh 0 O s{ (ABM N O 0~ ~ Cp (A 0 ~CAI~N ` ~ CC 0) (A V 00 Ch M M CO CA M _O O CO O f~ M O_ O st ~ a0 (h 0 0 O ~t~ ~ N O cr O 0 O 0 ~ 1~ ~ CA t7) M A ~ M~NN~ , N0.- MOMhCD 0CO (OO ( O N MOD O(0 •N ~> N N ~~ O to ~ r W ~ Q ~ r ~~ r r O O r r O O O O r r i i r r r r r r r i C O O 0 0 0 0 ~ 0O 0000 ~ ~ ~ 0O 0000 ~ •-CO OOM~ C W ~ O O O O O 0 N Efl O 0 0 0 0 0 ''' 0 ' 0' ' 0 0 0 0 O N O 0 0 O O O O O O O O O 0000(0 O O O O 0 0 0 0 O 0 0 N N N O O O O ~ N ON00 00 MCO ~tP OOON 1~ ~ CA O ~ O CO O (0 CO 0 N M O M O (O Cn CO O O Ch (O O Ch 1~ ~ O O fA m ~ M M N V 0 O 1~ O CO r- h N Cp ~ CO ~ M O O M O (A ~ 00 N - > ~ 0 r CV ~ N iN ~ O W b9 ~ ~ ' CA (D ' 1~ tlD W ' 0 0 0 0 0 0 00 M 0 O~ O O CO O O ~ M 0 O CA (P M (A h 0 0 0 O O 0~ N (A CO ~ CO (~ 00 f~ 0 0 O 0 N of CO 0 0 a* 0 0 ~ CA ~ CO C~ M V CA Q) n O (A O~ M~ N '~ O M O ~ 00 M CO CP N O to 0 m m O N r(j O ~ C ~ C O ~ Mr CA7 `' Maw 00N OmNO 0 ( ) OM CA0 MO 0 0 ~ ~ m C N U C (6 ~ U ~ 7 C C ll ~ ~ ~ ~ ~ CO ll l1 Z y y C ~ UF-F- C 'v ~ CN Lm N ~ ~ 0 O 7 7 N ~ "" O (n i C6 ~ N CU N C LL C ll lL LL p uJ ~ :-. ~ ~ O U LL c w ~LL 7LL ~FtL ~ Z U~ ~ c~- LL aHco oNEu.~ ~ rya ~~> m ~ ~ ~ c ~ ~ a a ~ ~ m •~ t~ ~ ~ c~i v~ ~ `~ ~ m U } a ~ c a ~?~~~~ ~v_-o °?~ o cgs y E f° c a c Z a°i Q ~-- c a~ 0..5.E 3 E E m mt ~?,:?O yr Z m y~ H~ o ~~ v o a~i ;o ~a~~=u~wwa~cn~~~U-<n w~cn~ ?w~ u.HSUU F°- -24- 2007 OPERATING BUDGET -CITY OF DUBLIN Revenue Projections for 2007 Projecting revenues is an important element in the preparation of an operating budget. The City's Annual Budget Calendar reflects that the projection of revenues is completed prior to receiving budget requests. Revenue projections and their level of growth should be used to evaluate the level of growth allowed for operating expenditures. As stated in our Capital Improvements Program (C1P), both City Council and the administrative staff recognize that controlling the rate of growth on the expenditure side will provide additional funding for capital improvements. As part of the City's budget philosophy, as reflected in the Financial Management Policies section of the budget document, we will continue to estimate annual revenues by a conservative, objective, and analytical process. It is better to underestimate revenues which result in an increase in our fund balances than to overestimate and have a shortfall. Our goal is to make reasonable revenue projections, especially for our key revenues such as income taxes; property taxes; intergovernmental revenues; and charges for services. The following information provides projections for the major revenue sources of the City for 2007. The information provides actual information for 2004 and 2005, estimates for 2006, and projections for 2007, 2008, and 2009. General Fund Income Taxes (General Fund only) 2004 39,830,235 2005 43,490,912 2006 45,013,000 2007 46,363,500 2008 47,986,000 2009 49,426,000 The actual revenue and projections reflect 75% of the total income taxes collected. The remaining 25% is reflected in the Capital Improvements Tax Fund and by Ordinance can only be used for capital improvements. Income tax revenues are our largest revenue source. In 2007 income tax revenues are estimated to comprise 91 % of our General Fund operating revenues (does not include transfers or advances) and 78% of all operating revenues. Because of the importance of our income tax collections, we monitor income tax collections on a daily basis. Our 2006 income tax revenues are estimated to increase 3.5% over 2005 collections. This estimate is based on collections through October. In making current year estimates, we have relied on the Receipt Summary Report, a report that compazes the current year collections by type to last year's collections by type, and an in-house spreadsheet indicating total collections - 25 - 2007 OPERATING BUDGET -CITY OF DUBLIN General Fund (Continued) by month, percentage of increase/decrease and each month's collection as a percentage of total collection for past years. Through October, income tax revenues were up approximately 9.7%. Withholding income tax revenues, which generally comprise 80% of the City's total income tax revenues, are up 6.2% in 2006 over the same time period in 2005. The next few years' income tax revenue collections will depend the sustainability of the current economy, nationally and locally. The City has aggressively pursued high-end commercial development which has resulted in several major corporate expansions and several corporate relocations to Dublin. The Dublin Methodist Hospital is scheduled to open in late 2007, and will have a positive impact on income tax revenues. In conjunction with our existing tax base, we are hopeful that our revenue projections are low and unanticipated revenue will be available for subsequent programming. The 2007, 2008, and 2009 projected rates of growth are consistent with projections utilized in the 2007-2011 CIP. Our projections reflect a 3.0% growth rate for 2007, a 3.5% growth rate for 2008, and a 3.0% growth rate in the year 2009. Intergovernmental Revenues There are several different revenues that comprise intergovernmental revenues in the General Fund. The two most significant revenues are local government and estate taxes. Local Government 2004 1,258,011 2005 1,292,922 2006 1,243,475 2007 1,329,475 2008 1,300,000 2009 1,300,000 Local government is the State of Ohio's revenue sharing program, whereby local governmental entities share a portion of the State's sales tax, income'tax, corporate franchise tax, and public utility excise tax. A portion of the funds are distributed directly from the State of Ohio to the City and a portion of the funds are distributed to the counties who, in turn, distribute to local governmental entities. The 2007 projection reflects an increase in this funding source. This projection is based on a confirmation of the 2007 distribution from Franklin County. The projections for 2008 and 2009 assume revenues slightly lower than the 2007 estimate, as this program is frequently targeted in State budget reduction discussions. -26- 2007 OPERATING BUDGET -CITY OF DUBLIN General Fund (Continued) Estate Taxes 2004 1,169,893 2005 725,615 2006 123,403 2007 25,000 2008 25,000 2009 25,000 Estate taxes are a highly volatile revenue source. Despite recent State law changes increasing the amount of an estate that is exempt from taxation, this revenue could become more significant in the future as the City's population ages. The conservative projection reflects the unpredictability of this revenue source. Licenses and Permits Various licenses and permits are issued by the City with the vast maj ority of which are related to development and building activity with the City. 2004 2,952,533 2005 2,987,208 2006 2,222,923 2007 1,769,480 2008 1,300,000 2009 1,300,000 The City has adopted a fee structure based on the cost of providing services. The intent of this method is to identify the benefactor of a service that is not a general public service and charge them a user fee based on the cost to provide the service. The total revenue collected for development and building activity fees is dependent upon the economy and can fluctuate significantly from year to year. Special Revenue Funds Motor Vehicle License Taxes and Gasoline Taxes 2004 1,591,323 2005 1,536,907 2006 1,550,590 2007 1,503,315 2008 1,500,000 2009 1,500,000 These revenues can only be used. for the repair and maintenance of streets and state highways and are based on the number of motor vehicle license registrations. The City receives 34% of the motor vehicle registration fees charged for vehicles registered in one of our taxing districts. The gasoline taxes received by the City are based on the number of vehicles -27- 2007 OPERATING BUDGET -CITY OF DUBLIN Special Revenue Funds (Continued) registered in our taxing districts and the amount of state assessed gasoline taxes collected. The Ohio General Assembly approved increases in the gasoline tax of $0.02/gallon each year effective July 1 of 2003, 2004, and 2005, respectively, for a total increase of 0.06/gallon by July 1, 2005. In addition, the General Assembly redirected a total of $180 million per year in gasoline taxes to local governments beginning July 1, 2007. However, consumption decreases tied to recent increases in fuel costs have reduced the revenues initially projected from this source. Due to errors in distribution by the Ohio Bureau of Motor Vehicles, these revenues fluctuate based on the results of motor vehicle registration audits performed by local jurisdictions. Recreation Fees In 1996, the Dublin Community Recreation Center (DCRC) was opened. When the rate structure was established for Phase 1 of the DCRC, the intent was that operating costs would be significantly covered by user fees collected. The rates established for other recreational programming are based on a goal of 50% cost recovery. DCRC Total Onlv Recreation 2004 2,572,635 3,445,165 2005 2,563,592 3,418,640 2006 2,478,875 3,411,245 2007 2,294,025 3,140,620 2008 2,293,000 3,140,000 2009 2,293,000 3,140,000 The revenues established for recreational programming have continued to recover at approximately 50% of the cost. Phase I of the DCRC substantially recovers operating costs. Hotel/Motel Taxes 2004 1,467,592 2005 1,578,766 2006 1,685,000 2007 1,650,000 2008 1,600,000 2009 1,600,000 These amounts reflect 75% of the total hoteUmotel taxes collected. The remaining 25% is recorded in the Dublin Convention & Visitor's Bureau (DCVB) Fund and distributed to the Bureau on a monthly basis. The City, the DCVB, and administrators from the local hotels continued to work to identify ~" "slow times" as far as hotel vacancies and to schedule events to maximize occupancy rates. -. They have worked with event organizers to coordinate schedules and promote events that result in overnight stays in the City. ~q: -28- 2007 OPERATING BUDGET -CITY OF DUBLIN Special Revenue Funds (Continued) The 2007 projection reflects a slight reduction in this revenue source to remain conservative. The DCVB is projecting a slight rate of growth for the coming year. Capital Projects Funds The primary funding source for the Five-Year Capital Improvements Program (CIP) is the City's income tax revenue. Projecting income tax revenues for the five year period is a significant element in determining resources available for capital programming. Income Taxes 2004 13,276,743 2005 14,496,970 2006 15,004,364 2007 15,454,495 2008 15,995,402 2009 16,475,264 The actual revenue and projections reflect 25% of the total income taxes collected. The remaining 75% is reflected in the General Fund and will comprise 78 % of all operating revenues. Property Taxes 2004 2,441,252 2005 2,606,049 2006 2,855,915 2007 2,799,350 2008 2,840,000 2009 2,880,000 Beginning in 2001, the City's inside millage was allocated 100% to the Parkland Acquisition Fund resulting in no property tax revenue being credited to the General Fund. This reallocation has addressed a City Council goal to identify a revenue source for the purpose of acquiring parkland, open space, and recreational facility sites. In 2007, a portion of the inside millage will be allocated to the Capital Improvements Tax Fund to provide a funding source for the US 33/State Route 161/Post Road Interchange Improvement Project. This estimate combines projected receipts to both funds. -29- 2007 OPERATING BUDGET -CITY OF DUBLIN Enterprise Funds Water and Sewer Surcharges 2004 2,199,909 2005 2,594,892 2006 2,334,000 2007 2,468,000 2008 2,510,000 2009 2,545,000 The user fees provide the funding for ongoing maintenance of the water and sewer systems. User fees have not been increased since 1996. The revenue projections for 2008-2009 are based on the current rate and a projected growth in users. Water and Sewer Taa Fees (Capacity Charees) 2004 1,769,652 2005 2,241,856 2006 1,725,000 2007 900,000 2008 720,000 2009 720,000 We have experienced a higher rate of revenue growth from capacity charges because of higher than expected growth in residential taps issued. In addition, sewer capacity charges increased to $1,800 for a'/4" tap on July 1, 2005, and are scheduled to increase to $2,000 for a '/a" tap on January 1, 2007. The estimates reflected assume the issuance of 250 new tap permits in 2007, 200 in 2008, and 200 in 2009. The Administration has made tentative projections for revenues and expenses in the Water and Sewer Funds through 2018. The projections are revised annually. The Community Plan update and the information available from the geographic information system (GIS) provides information on the availability of developable land, the type of development and the infrastructure needs based on the anticipated development. -30- 2007 OPERATING BUDGET-CITY OF DUBLIN -Revenue Comparisons -All Funds 2005 Actual 2006 Budget 2006 Estimate 2007 Budget GENERAL FUND $52,318,699 $53,417,721 $53,226,054 $57,374,335 SPECIAL REVENUE FUNDS Street Maintenance and Repair 3,093,947 3,360,100 2,743,051 3,416,550 State Highway Improvements 121,091 108,460 123,290 121, 365 Cemetery 153,428. 116,630 70,160 166,630 Recreation 5,918,727 7,037,100 6,161,245 7,110,620 Safety 9,080,862 9,698,501 8,962,551 9,572,516 Swimming Pool 757,536 992,900 998,049 985,400 Permissive Tax 121,190 101, 300 106,129 104,800 Hotel/Motel Tax 2,820,999 2,166,300 3,048,034 2,439,500 Enforcement and Education 3,471 2,895 2,785 2,925 Law Enforcement Trust 4,561 3,160 3,819 3,375 Mandatory Drug Fine 54 50 49 50 Mayor's Court Computer 33,345 31,780 24,127 32,250 Accrued Leave Reserves 304,375 307,200 209,080 302,000 DEBT SERVICE FUNDS General Obligation Bond Retirement 7,681,087 7,708,938 7,733,221 10,350,493 Special Assessment Bond Retirement 18,084 16,400 16,882 16,100 1992 Special Assessment Bond Retirement 121,966 119,745 121,042 119,725 2001 Special Assessment Bond Retirement 136,779 129,700 129,700 125,500 CAPITAL PROJECTS FUNDS Capital Improvements Tax 22,400,701 15,081,832 16,216,782 24,840,545 Park Development 3,065,430 2,875,950 3,488,869 1,673,850 Woemer-Temple TIF 16,695 16,000 7,773 7,700 Ruscilli TIF 328,233 327,000 362,777 360,000 PizzutiTIF 225,924 225,000 360,149 230,000 Transportation Improvement 16,214 - - - Thomas/Kohler TIF 446,606 428,000 478,238 410,000 McKitrickTIF 1,506,479 2,506,300 1,665,000 1,550,000 Perimeter CenterTlF 261,783 761,000 291,277 1,175,000 Rings Road TIF 334,250 334,000 306,816 305,000 Perimeter West TIF 325,110 330,000 385,644 380,000 Upper Metro Place TIF 258,976 235,000 265,047 264,000 Rings/FrantzTIF 419,194 419,000 451,798 450,000 Historic Dublin Parking TIF 2,484 2,400 6,604 6,600 Clean Ohio Grant Fund 6,071 - - - Emerald Pkwy Phase 5 TIF 995,336 1,159,830 1,394,288 150,000 Emerald Pkwy Phase 8 TIF 9,500 600,000 - 600,000 Perimeter Loop TIF 1,722,345 30,200 37,006 32,000 Tartan West TIF Fund 2,416,200 250,000 1,513,551 - Shamrock Blvd. TIF Fund 19,500 2,000,000 337,983 2,030,000 Land Acquisition Fund 6,608,000 4,900,000 2,000,000 500,000 Riverside/SR 161 TIF 43,000 350,000 - 350,000 Lifetime Fi[ness TIF 0 500,000 500,000 1,400,000 COIC Improvement Fund 305,700 750,000 7,031,000 5,706,000 Irelan Place TIF 83,221 5,200 Shier Rings Road TIF 6,978 6,800 ENTERPRISE FUNDS Water 2,561,422 1,604,300 2,247,000 1,703,800 Sewer 2,920,581 2,315,500 2,561,600 2,266,352 Merchandising 17,441 10,410 13,450 10,620 INTERNAL SERVICE FUNDS Employee Benefits Self-Insurance 3,751,728 3,755,500 3,737,450 4,663,125 Worker's Compensation 151,471 418,300 392,250 447,425 FIDUCIARY FUNDS Cemetery Perpetual Care 50,104 39,000 47,510 39,200 Convention and Visitors' Bureau 526,255 480,000 544,000 .480,000 Other Agency 2,454,680 1,986,500 2,521,679 1,834,500 TOTALS 136,857,614 130,009,902 132,935,008 146,121,851 Less: Transfers and advances (35,719,348) (33,503,028) (34,431,538) (43,832,110) Sub-total 101,138,266 96,506,874 98,503,470 102,289,741 Debt Issuances/SIB and OWDA Loans - - - - TOTALREVENUE $101,138,266 $96,506,874 $98,503,470 $102,289,741 12/11/2006 Filename:n\fa\jan\076udget\revcomp7A -31- 2007 OPERATING BUDGET -CITY OF DUBLIN Revenue Comparisons -General Fund 2005 2006 2006 2007 Actual Bud et Estimate Bud et TAXES Income Taxes $43,490,912 $43,550,500 $45,013,000 $46,363,500 INTERGOVERNMENTAL REVENUE Personal Property Reimbursement 8,644 6,880 6,880 6,880 Local Government 1,292,922 1,284,132 1,243,475 1,329,475 Estate Taxes 725,615 25,000 123,403 25,000 Cigarette Taxes 620 500 500 500 Liquor and Beer Permits 46,092 30,000 48,241 35,000 Grants-State & Federal 10,458 250,000 282,504 - CHARGES FOR SERVICES General Fees and Charges 20,393 1,500 44,234 1,500 Sale of Fuel 660,708 475,000 475,000 475,000 FINES,LICENSES AND PERMITS Fines and Forfeitures 477,222 360,000 390,000 360,000 Licenses and Permits 2,987,282 1,663,735 2,222,923 1,769,480 OTHER REVENUES Interest Income 670,557 555,000 779,225 642,000 Other 169,274 133,000 246,707 135,000 NONOPERATING REVENUE Transfers/Advances 1,758,000 5,082,474 2,349,962 6,231,000 TOTAL GENERAL FUND REVENUE $52,318,699 $53,417,721 $53,226,054 $57,374,335 12/11/2006 Filename:n\fa\jan\2007budget\revcomp07 _32_ 2007 OPERATING BUDGET -CITY OF DUBLIN Expenditure and Budget Summary 2006 2005 Revised 2006 2007 Actual Budget Estimate Budget General Fund $56,298,848 $55,437,327 $53,816,650 $61,028,254 special Revenue Funds itreet Maintenance and Repair Fund Streets and Utilities 2,398,134 3,000,391 2,484,375 2,695,800 Engineering 683,622 933,706 774,025 831,750 3,081,756 3,934,097 3,258,400 3,527,550 Mate Highway Fund Streets and Utilities 60,269 112,500 112,500 225,000 Engineering 18,396 33,208 17,300 25,000 78,665 145,708 129,800 250,000 Cemetery Fund 127,873 149,846 112,900 157,550 Cemetery 127,873 149,846 112,900 157,550 Recreation Fund Recreation Services 1,438,478 1,836,829 1,537,550 1,919,450 Community Recreation Center 3,233,854 3,770,170 3,358,750 3,662,700 Community Recreation Center Facilities 1,319,545 1,708,916 1,549,050 1,596,575 5,991,877 7,315,915 6,445,350 7,178,725 safety Fund 8,753,615 9,607,427 8,883,100 10,083,125 Police 8,753,615 9,607,427 8,883,100 10,083,125 Swimming Pool Fund 807,156 1,045,090 935,450 1,056,400 Dublin Municipal Pools 807,156 1,045,090 935,450 1,056,400 Permissive Tax Fund HoteUMotel Tax Fund Community Relations 1,946,367 2,184,120 2,153,850 2,466,175 Taxation 786,775 872,603 863,350 828,560 2,733,142 3,056,723 3,017,200 3,294,735 Education and Enforcement Fund - 3,000 - - Police - 3,000 - - Law Enforcement Fund 72,541 29,000 19,900 49,425 Police 72,541 29,000 19,900 49,425 dayor's Court Computer Fund 33,780 24,607 12,850 24,950 Court Services 33,780 24,607 12,850 24,950 .ccrued Leave Reserve Fund - 138,500 78,500 109,000 Finance - 138,500 78,500 109,000 lecial Revenue Fund Totals 21,680,405 25,449,913 22,893,450 25,731,460 S 1/2006 name:n\fa\janb76udgel~awazds~summary by org -33- 2007 OPERATING BUDGET -CITY OF DUBLIN Expenditure and Budget Summary 2006 2005 Revised 2006 2007 Actual Budget Estimate Budget Debt Service Funds General Obligation Debt Service Special lAssessment Bond Retirement Fund 1992 Special Assessment Bond Retirement Fund 2001 Special Assessment Bond Retirement Fund Capital Projects Funds Capital Improvements Tax Fund Parkland Acquisition Fund Enterprise Funds Water Fund Streets and Utilities Accounting and Auditing Facilities Engineering Sewer Fund Streets and Utilities Accounting and Auditing Engineering Merchandising Fund Community Relations Enterprise Fund Totals Internal Service Funds Employee Benefits Self-Insurance Fund Workers' Compensation Self-Insurance Fund Fiduciary Funds Income Tax Revenue Sharing Fund Agency Fund Dublin Convention and Visitor's Bureau Fund TOTALS 7,756,182 7,807,872 7,804,223 10,336,014 6,106 5,750 5,738 5,369 126,541 122,165 122,165 122,770 129,122 127 270 135 591 125 254 8,017,951 8,063,057 8,067,717 10,589,407 21,881,850 27,577,242 26,252,609 25,714,310 2,121,177 4,793,065 3,694,565 4034410 24,003,027 32,370,307 29,947,174 29,748,720 452,189 478,421 431,800 425,850 1,314,707 382,850 665,850 ~ 358,760 19,758 - _ _ 362,631 319,031 117,600 4 761 100 2,149,285 1,180,302 1,215,250 5,545,710 975,192 1,748,452 1,561,703 1,099,095 1,041,443 1,218,015 1,218,015 1,350,725 1,327,532 1,668,247 1,467,150 2 320 500 3,344,167 4,634,714 4,246,868 4,770,320 8,888 10,100 6,550 10 000 8,888 10,100 6,550 10,000 5,502,340 5,825,116 5,468,668 10,326,030 3,892,392 4,307,158 4,231,950 4,507,150 135,910 840,864 499,500 561425 4,028,302 5,148,022 4,731,450 5,068,575 891,210 1,274, 863 1,274, 863 1,248,000 1,25 7,034 1,467, 800 1,347,900 1,046,500 521,881 562,714 554,300 480,000 2,670,125 3,305,377 3,177,063 2,774,500 $122,200,998 $135,599,119 $128,102,172 $145,266,946 Recap of 2007: Total Amount Budgeted $145,266,946 Project funds tamed forward 17,372,352 Less: Transfers (43,832,110) Total Expenditures $118,807,188 wt vzoob -34- ''°` Filename:n\Ca\jan\07budgettawards~summary by org ,~. 2007 OPERATING BUDGET -CITY OF DUBLIN Expenditure and Budget Summary General Fund 2006 2005 Revised 2006 2007 Actual Budget Estimate Budget General Fund City Council $478,335 $553,102 $502,200 $556,150 Boards and Commissions 21,389 36,750 16,800 36,750 Office of the Ciry Manager 506,259 553,685 513,800 579,625 Miscellanous AccoundContingencies 470,503 883,500 806,800 859,925 Human Resources 1,353,885 1,564,019 1,438,850 1,504,550 Community Relations 958,366 970,280 918,800 1,033,175 Legal Services 1,527,092 1,561,712 1,430,000 1,610,000 Finance -Office of the Director 469,609 510,101 494,900 523,100 Procurement 200,894 234,196 220,150 201,450 Transfers and Advances 24,950,500 17,825,000 20,256,000 22,800,000 Miscellaneous Accounts 273,348 416,750 416,700 376,604 Accounting and Auditing 542,526 595,304 573,200 595,725 Taxation 2,294,659 2,419,733 2,287,500 2,555,700 Public Services -Office of the Director 353,218 347,781 287,000 359,825 Solid Waste Management 2,162,808 2,557,769 2,289,300 2,712,450 Fleet Maintenance 1,793,521 1,961,182 1,818,650 2,009,050 Engineering 2,784,719 2,954,307 2,650,450 2,879,500 Streetlighting 219,569 271,524 264,200 314,000 Building Standards 1,321,952 1,482,733 1,332,750 ],555,200 Land Use and Long Range Planning 2,287,184 2,775,226 2,351,900 2,541,600 Parks and Recreation Parks 4,928,617 5,783,357 5,192,850 5,945,175 Economic Development - Office of the Director 1,742,146 3,340,647 2,955,000 3,791,325 Administrative Services -Office of the Director 342,524 386,681 358,1 SO 393,075 Information Technology 1,786,226 2,329,085 1,817,250 2,286,675 Court Services 471,471 510,468 440,650 467,750 Records Management 155,404 214,996 164,250 225,200 Facilities Management 1,902,124 2,397,439 2,018,550 2,314,675 TOTAL $56,298,848 $55,437,327 $53,816,650 $61,028,254 -35- aoa~ oPExa~r~vG BUDGET - errY o~ DuB~,Ilv Comparison of Operating Revennes and Expenditures 2007 Operating Revenues by Source Fines/Licenses/ Char es for Permits Other Revenue 9 q% 3 /o S~_....,... Intergovernment 5% Other 4% Income Taxes 77% 2007 General Operating Expenditures by Type Capital Outlay Other 2% Expenses 42% Salaries 41% Benefits 15% -36- 2007 OPERATING BUDGET -CITY OF DUBLIN 2007 Appropriations Summary by Expenditure C ategory -All Funds Personal Services Other Expenses Cauital Outlav Total General Fund $ 18,708,050 $ 19,119,229 $ 400,975 $ 38,128,254 Special Revenue Funds Svee[ Maintenance and Repair Fund Streets and Utilities 1,815,950 852,400 27,450 $ 2,695,800 Engineering 346,700 440,750 44,300 $ 831,750 State Highway Fund Streets and Utilities - - 225,000 $ 225,000 Eny~neering - 25,000 - $ 25,000 Cemetery Fund I t 1,800 31,350 14,400 $ 157,550 Recreation Fund Recreation Services 1,289,800 628,650 1,000 $ 1,919.450 Community Recreation Center 2,238,025 1,382,950 41,725 $ 3,662,700 Community Recreation Center Facilities 1,042,425 415,950 138,200 $ 1,596,575 Safety Fund 9,391,400 672,175 19,550 $ 10,083,125 Swimming Pool Fund 559,300 353,300 143,800 $ 1,056,400 Permissive Tax Fund - - - $ - Ho[el/Mo[el Tax Fund 482,325 2,560,325 - $ 3,042,650 Educations and Enforcement Fund - - - $ - Law Enforcement fund - 27,075 22,350 $ 49,425 Mayor's Court Computer Fund - 24,950 - $ 24,950 Accrued Leave Reserve Fund 109,000 - - $ 109,000 Debt Service Funds General Obligation Debt Service - 10,336,014 - $ 10,336,014 Special Assessments - 253,393 - $ 253,393 Capital Projects Funds Capitallmprovements Tax Fund - - 15,063,000 $ 15,063,000 Parkland Acquisition Fund - 30,000 3,420,000 $ 3,450,000 Enterprise Funds Water fund Streets and Utilities 145,650 280,200 - S 425.850 Accounting and Auditing - 358,760 - $ 358,760 Engineering 18,600 52,500 4,690,000 $ 4,761,100 Sewer Fund Streets and Utilities 547,975 408,750 142,370 $ 1,099,095 Accounting andAudi[ing - 1,350,725 - S 1,350,725 Engineering 128,500 142,000 2,050,000 $ 2,320,500 Merchandise Fund - 10,000 - $ 10,000 Internal Service Funds Employee Benefits Self-Insurance Fund 20,450 4,486,700 - $ 4,507,150 Workers Compensation Self-Insurance Fund - 561,425 - $ 561,425 Fiduciary Funds Income Tax Revenue Sharing Fund - 1,248,000 - $ 1,248,000 Agency Fund - 1,046,500 - $ 1,046,500 Dublin Convention and Visitor's Bureau Fund 480,000 $ 480,000 Totals $ 36,955,950 $ 47,579,071 $ 26,444,120 $ 110,979,141 Nole: Does not include uansfers or advances. -37- 2007 OPERATING BUDGET -CITY OF DUBLIN 2007 Appropriations Summary by Expenditure Category -General Fund General Fund Ciry Council Boards and Commissions Office of the City Manager Miscellanous Account/Contingencies Human Resources Community Relations Legal Services Finance -Office of the Director Procurement Miscellaneous Accounts Accounting and Auditing Taxation Public Services -Office of the Director Solid Waste Management Fleet Maintenance Engineering Streetlighting Building Standards Land Use and Long Range Planning Parks and Recreation Parks Economic Development -Office of the Director Administrative Services -Office of the Director Informarion Technology Court Services Records Management Facilities Management Total Note: Does not include transfers or advances. Personal Services Other Exaenses Capital Outlav Total 403,475 147,675 5,000 $ 556,150 9,750 27,000 - $ 36,750 509,125 70,500 - $ 579,625 - 859,925 - $ 859,925 832,075 669,575 2,900 $ 1,504,550 530,525 502,650 - $ 1,033,175 - 1,610,000 - $ 1,610,000 503,850 19,250 - $ 523,100 67,750 133,700 - $ 201,450 - 376,604 - $ 376,604 530,750 62,475 2,500 $ 595,725 463,325 2,090,875 1,500 $ 2,555,700 320,775 38,050 1,000 $ 359,825 772,900 1,938,050 1,500 $ 2,712,450 635,300 1,351,750 22,000 $ 2,009,050 2,364,900 496,600 18,000 $ 2,879,500 - 309,000 5,000 $ 314,000 1,191,750 358,450 5,000 $ 1,555,200 2,180,325 360,775 500 $ 2,541,600 3,893,900 1,758,125 293,150 $ 5,945,175 307,775 3,482,050 1,500 $ 3,791,325 347,275 45,000 800 $ 393,075 1,039,850 1,244,825 2,000 $ 2,286,675 352,350 112,900 2,500 $ 467,750 116,200 108,500 500 $ 225,200 1,334,125 944,925 35,625 $ 2,314,675 $ 18,708,050 $ 19,119,229 $ 400,975 $ 38,228,254 -38- 2007 OPERATING BUDGET -CITY OF DUBLIN Staffing Comparison by Function Full-Time Employees This table and chart, and the table on the fallow page, reflect full-time employees only. The 2007 Operating Budget also funds 249 part-time and seasonal positions throughout the City. 2004 2005 2006 2007 Authorized Authorized Authorized Authorized General Government 87 91 94 94 Community Environment 77 77 70 71 Basic Utility Services 11 11 16 19 Leisure Time Activities 89 88 85 86 Security of Persons & Property 93 92 92 93 Public Health Services 1 1 1 1 Transportation 30 31 31 27 TOTALS 388 391 389 391 Staffing by Function Transportation Public Health Services General Government Security of Persons & Property Community Environment Leisure Time Basic Utility Activities Services -39- aQO7 Q~~~~vG sU~E~r - errY of DUB~.~ Staffing by Work Unit Work Unit City Council Office of the City Manager Human Resources Community Relations Special Events Finance/ Office of the Director Procurement Accounting and Auditing Taxation Office of Director of Devebpment Public Service/ Office of Director Solid Waste Management Streets and Utilities Water Maintenance Sewer Maintenance Fleet (formerly Vehicle) Maintenance Engineering Traffic MaintenancelfransportaGon Signage Building Standards Land Use and Long Range Planning Parks and RecreatiorUParks (formerly Grounds) Cemetery Maintenance Recreation Services Community Recreation Center Economic Devebpment Administrative Services InfortnaGon Technology Court Services/Records Management Facilities Management Community Recreation Center -Facilities Police TOTALS 2004 2005 2006 2007 See Authorized Authorized Authorized Authorized Note 3 3 3 3 6 5 4 4 9 9 9 9 8 8 8 8 3 3 3 3 11 5 5 5 1 1 1 1 0 6 6 6 5 5 5 5 4 0 0 0 4 3 3 3 4 4 5 10 (1) 30 25 25 22 (1) 2 2 2 1 (1) 9 9 9 8 (1) 7 7 7 8 (2) 28 30 30 30 (3) 0 6 6 5 (3) 15 14 14 14 23 26 26 27 (4) 44 45 44 46 (5) 1 1 1 1 6 6 6 6 18 18 17 16 (6) 3 3 3 3 0 4 4 4 11 12 12 12 7 7 7 6 (7) 15 16 17 17 18 16 15 15 93 92 92 93 (8) 388 391 389 391 NOTES: (1) Several changes were made among work units within Streets and Utilities to better reflect how staffing is utilized. (2) Apart-time Gerical position was upgraged to full-time. (3) Although Engineering shows no net increase in staffing, several positions were reallocated among Transportation Signage, Engineering and land Use/Long Range Planning. The net effect provides for the addition of two (2) engineering inspectors and the conversion of a part-time clerical to full-time. For further detail, please see Engineering under Tab 1. (4) A landscape architect position was transferred from Engineering. (5) An assistant forester and a contract specialist were added. (6) A facilities reservations coordinator was added to streamline the reservation process; two other vacant positions (recreation specialist and operations supervisor) were eliminated. (7) Two full-time positions (probation officer and diversion officer) were combined into 1.5 community justice officer positions, to better reflect workload. (8) A communications technician position was added in anticipation of implementation of wireless 911 services. ~a ~, Zoa7 oPE1zATnvG BUDGET - CITY of DuBl,nv Debt Administration Dublin's infrastructure needs are met through afive-year Capital Improvements Program (CIP); ~" currently, the 2007-2011 CIF programs $147.3 million in major capital improvements. Several capital projects over the past few years have been funded utilizing proceeds from long-term debt. The City's CIP document provides a summary of additional infrastructure needs anticipated to be funded with long-term debt. By policy, fifteen percent of income tax revenues are allocated for ,~,,, debt service. Annual debt service for income tax funded projects totals 8.3% of 2007 projected income tax revenues. `" As of December 31, 2006, the City will have $71.9 million in long-term debt outstanding. Of the ,,., total, $2.1 million will be retired using revenues generated by the City's water system operations, $12.2 million will be retired using revenues generated by the City's sewer system operations, • ~ $2.1 million will be retired through the collection of special assessments, $3.5 million retired using property tax revenues, $1.7 million retired using hoteUmotel tax revenues, and $13.2 million retired using service payments in lieu of taxes. The remaining $37.1 million, or about 51.6%, will be retired with income tax revenue. "`" In 1998, the City entered into an agreement with the City of Columbus to cost-share in the I- 270/Sawmill Road Single Point Urban Interchange roadway improvement project. The City's original commitment of $1,200,000 and associated interest will be retired over ten years. ¢*~ Funding for this commitment ($130,860) is included in the 2007 Operating Budget within the General Obligation Debt Fund. Under current state statutes, the City's general obligation debt issuances are subject to a legal limitation based on the total assessed value of real and personal property. Total general obligation debt of the City, exclusive of certain exempt debt, shall never exceed 10.5% of the total assessed valuation. The unvoted general obligation debt of the City cannot exceed 5.5% of the total assessed valuation. At December 31, 2005, the City had a legal debt margin for total ~.. debt of $167,608,639 and a legal debt margin for unvoted debt of $100,640,525. ,,,. -41- 2007 OPERATING BUDGET -CITY OF DUBLIN Debt Administration (Continued} In 1990, the City received voter approval to issue $57 million in voted general obligation debt for specifically identified functional categories such as transportation improvements and the construction of a community recreation center. This approval provided the City with the capacity ~"` to incur additional debt, for the identified functional categories, which would otherwise exceed ~ statutorily established non-voted debt limits at that time. The City's policy, as documented in the CIP, is that the voted debt would be retired using income tax revenues and not property taxes. No ""~ new voted debt was issued in 2006. Therefore, as of December 31, 2006, $55,067,000 in voted debt authority will have been utilized, leaving $1,933,000 of voted debt authority available for ~° future use. ,., When bonds were last issued in 2001, the City received a "AAA" rating from Fitch Ratings. In May 2004, Moody's Investors Service upgraded the City's rating from the previous "Aal with a ,,,~ positive outlook", to "Aaa", after completing a review that evaluated the City's existing financial condition, current developments and trends, and prospects for growth. Both are the respective iw agency's highest rating available, and enable the City's debt to be issued at lower interest rates, resulting in substantial reductions in future debt service payments. Both ratings were reaffirmed when the City issued refunding bonds in September, 2004. The City's diverse and growing ,~ economic base, strong regional and local economies, the City's history of operating surpluses and the continued use of that surplus to fund capital projects, and the City's continued long-term "` planning efforts will help maintain high credit ratings. -42- ~. we Unvoted Bonds (G.O.) • Water Tower Construction • Swimming Pool Construction • Water System Improvements • Frantz Road Improvements • Semce Complex " Sanitary Sewer hnprovements 1 RingsBlazer Water Tower 2 Upper Scioto West Branch (OWDA) ` Avery-Mu~eld Interchange (SB Loan) Rings Road [mprovements(T[F) Arts Facility Acquisition Arts Facility Renovation Perimeter Drive Extension(TIF) Emerald Parkway-Phase 7A(TIF) • Service Complex Sawmill Interchange (SPUI)Ciry of Cols) Parkland Acq -Riverside/Hard (OMB) • Municipal Pool South (OMB) " Aryshire Drive Culvert Repl. (OPWC) 2007 OPERATING BUDGET-CITY OF DUBLIN Debt Service Schedule Date 2007 Of Interest Ord. Res. Original O/S Principal Interest Issue Rate No. No. Amount Principal Payment Payment 12-01-90 4. t ~ % t 13-90 N/A 2,200,000 617,605 144,913 26,033. 18 12-01-90 4.15% 1t4-90 N/A 1,200,000 330,261 77,491 13,921. 06 l2-O1-90 4.15% 112-90 N/A 1,550,000 432,884 101,571 18,24(1. 82 12-O1-90 4.15% ll(i-90 N/A 455,000 141,807 33,273 5,977. 40 12-01-90 4.15% 115-90 N/A 2,400,000 673,581 158,047 28,392. 68 12-01-90 4.15% 117-90 N/A 1,800,000 488,860 114,705 20,606. 32 10-15-94 6.t4% 94-94 N/A 4,100,000 2,190,000 220,000 138,760. 00 OI-01-99 4.35% N/A OI-95 19,716,717 12,155,954 837,298 513,422. 85 09-01-99 5.17% 84-99 N/A 8,316,788 6,631,537 364,417 261,656. 00 12-01-00 5.22% 139-00 N/A 3,535,000 2,911,515 160,152 130,501. 96 12-O1-00 5.22% 136-00 N/A 1,360,000 1,119,003 60,821 50,143. 04 IL-01-00 5.22 % 143-00 NIA 755,000 621,906 33,270 27,850. 14 12-01-00 5.22 % 140-00 N/A 3,940,000 3,?53,804 176,986 145,807. 66 12-01-00 5.22 % 137-00 N/A 2,020,000 1,668,771 88,772 74,727. 20 12-01-O1 4.42% 112-01 N/A 3,675,000 2,980,000 150,000 129,793. 76 Ob-IS-98 4.34% N/A 1,200,000 240,000 120,000 10,860. 00 04-14-04 2.67% 24-04 N/A 1,518,000 960,000 314,000 20,280. 46 04-14-04 4.30% 23-04 N/A 2,986,000 2,788,000 111,000 111,563. 65 07-01-04 0.00% N/A 39-02 279,748 209,811 27,975 0. 00 40,415,199 3,294,690 1,728,5 44 09-01-87 7.375% 82-87 96-87 95,623 5,000 5,000 368. 75 10-O1-92 5.51% 107-92 46-90 165,000 15,000 15,000 900. 00 12-0t-01 4.42% 117-01 N/A 1,700,000 1,380,000 65,000 60,228. 76 1,400,000 85,000 61,497. 51 07-01-79 6.50% 56-79 34A-79 225,000 30,000 10,000 1,950. 00 12-01-90 4.14% 118-90 N/A 315,000 90,913 22,174 4,027. 48 12-01-90 4.14% 119-90 N/A 890,000 142,435 59,130 10,739. 94 12-01-90 4.14% 120-90 N/A 1,225,000 322,653 78,696 14,293. 58 IO-01-92 4.23% 108-92 N/A 4,100,000 1,285,000 275,000 57,970. 00 02-01-96 4.53% 123-95 N/A 6,615,000 1,955,000 555,000 94,300. 00 10-I 5-98 4.66 % 98-98 N/A 3,998,000 2,788,000 180,000 133,170. 50 IO-IS-98 4.62 % 97-98 N/A 7,518,000 5,062,000 360,000 242,687. 00 10-IS-98 4.01 % 96-98 N/A 1,403,000 180,000 180,000 9,000. 00 10-IS-98 4.56°/ 96-98 N/A 7,874,000 5,229,000 445,000 252,346. 50 12-01-00 5.20% 141-00 N/A 5,555,000 4,472,766 263,773 204,363. 36 12-01-00 5.20% 142-00 N/A 6,565,000 5,277,832 307,099 241,204. 94 12-OI-00 5.22% 138-00 N!A 3,135,000 2,509,402 134,128 115,997. 96 29,445,001 2,870,000 1,382,051. 26 10-15-94 6.14% 90-94 N/A 1,185,000 660,000 65,000 41,820. 00 660,000 65,000 41,820. 00 $71,920.300 $6,314,690 3,?13,912. 95 Unvoted Special Assessment Bonds Shier-Rings Waterline Dublin Village Center Lighting Ballantrae Voted Bonds (G.O.) #2 Sewer (II-02-76) • Coffrrtan Road Extension • Municipal Facility(Land) • N.E. Quadrant Parkhmd • Dublin Justice Center • Conununity Recreation Center • Recreation Center expansion ` Emerald Pazkway Bridge Emerald Pazkway-Phase I (TIF) Emerald Pazkway-Phase 2(TIF) • Woerner-Temple Road • Emerald Pazkway Overpass-Phase 7 Coffman Park Expansion firer Voted Special Assessment Bonds Tuller Road Total Debt Payments " Supported by income tax revenue. I Supported by Water Fund revenues. 2 Supported by Sewer Fund revenues. au~ Filename:\fa\jan\2007 Operating Budget\2007 Debt Schedules -43- wtr General Fund 1 Street Maintenance & Repair Fund 2 State Highway Improvements Fund 3 Cemetery Fund 4 Recreation Fund 5 Safety Fund 6 Swimming Pool Fund ~ Permissive Tax Fund g HoteUMotel Tax Fund 9 Education & Enforcement Fund 10 Law Enforcement Trust Fund 11 Mayor's Court Computer Fund 12 Accrued Leave Reserve Fund 13 Debt Service Funds 14 Capital Improvements Tax Fund 15 Parkland Acquisition Fund 16 Water Fund 1'7 Sewer Fund lg Merchandising Fund 19 Internal Service Funds 20 Fiduciary Funds 21 Glossary of Terms 22 .~. THIS PAGE LEFT BLANK INTENTIONALLY CI'T'Y' OF T)U$LIN_ .., City Council STATEMENT OF FUNCTIONS: The legislative powers of the City, as provided by the Revised Charter of the City of Dublin and the Constitution of the State of Ohio, are vested in the City Council. The City Counci} consists of seven members elected for terms of four years each. All members of City Council must be residents of Dublin at the time of their nomination and throughout their term of office. City Council officers consist of the Mayor and the Vice-Mayor. The Mayor is the ceremonial head of the City and presides over all City Council meetings. The Vice-Mayor performs these duties in the absence of the Mayor. City Council meetings are generally held on the first and third Mondays of each month. City Council's responsibilities include reviewing, deliberating, and passing legislation as prescribed by the Revised Charter and the laws of the State of Ohio applicable to municipalities. City Council establishes long-range policies for the City. A Clerk of Council is appointed by the City Council and serves at its pleasure. The Clerk of Council keeps an accurate and complete journal of the proceedings of City Council and performs such other duties as the City Council requires. OBJECTIVES AND ACTIVITIES: • To continue to be responsive to the needs and concerns of the citizens of Dublin. • To establish goals for the community to be implemented by staff and/or City Council. • To set policy in a clear and consistent manner in order to provide a framework for administrative implementation. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Mayor 1 l Vice-Mayor 1 1 Council Member 5 S Clerk of Council 1 1 Deputy Clerk of Council 1 1 Office Assistant II 1 1 TOTAL 10 10 NOTES AND ADJUSTMENTS: A portion of the salaries for the Mayor and Vice Mayor are allocated to the Court Services Budget. Council -45- 12/1 l/06 2007 Budget -City of Dublin, Ohio ~,, General Fund City Council Legislative Affairs 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1510 ~., Personal Services 2110 Salaries/Wages 240,472 247,650 257,650. 245,000 257,300 2111 Overtime Wages 6,305 7,500 10,000 10,000 10,000 2112 Other Wages 0 500 500 0 0 2120 Employee Benefits 117,578 117,250 117,250 116,800 136,175 364,355 372,900 385,400 371,800 403,475 Other Expenses 2201 Conference/Mileage 7,327 30,000 17,500 14,300 30,000 2211 Meeting Expenses 2,404 3,500 3,532 2,300 3,500 2212 Long Term Strategic Plan. 5,666 15,000 15,000 12,500 7,000 2240 Ceremonial Functions 19,822 25,100 25,250 19,600 25,000 2320 Communications 4,180 4,500 4,702 3,450 4,500 2330 Rents/Leases 14,027 15,050 17,560 16,000 15,050 2349 Professional Services 24,580 16,000 20,500 17,400 12,000 ~" 2351 Maint. of Equipment 3,181 5,925 6,589 4,300 5 925 . 2370 Advertising 23,304 30,000 28,500 22,550 , ~ 30,000 2391 Memberships/Subscriptions 4,950 7,500 7,807 5,300 7,500 `4 2410 Office Supplies 4,263 7,200 9,762 6,600 7,200 ~„< 113, 704 159, 775 156, 702 124, 300 147, 675 Capital Outlay 2520 Equipment & Furniture 276 6,000 11,000 6,100 5,000 276 6,000 11,000 6,100 5,000 TOTALS $478,335 $538,675 $553,102 $502,200 $556,150 -46- 2007 Budget -City of Dublin, Ohio General Fund City Council Boards and Commissions 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1520 Personal Services 2110 Salaries/Wages 8,400 8,400 8,400 8,400 8,400 2120 Employee Benefits 1,156 1,350 1,350 1,350 1,350 9,556 9,750 9,750 9,750 9,750 Other Expenses 2201 Conference/Mileage 11,078 25,000 25,000 6,000 25,000 2211 Meeting Expenses 230 1,000 1,000 500 1,000 2391 Memberships/Subscriptions 525 1,000 1,000 550 1,000 11,833 27,000 27,000 7,050 27,000 TOTALS $21,389 $36,750 $36,750 $16,800 $36,750 -47- City Council Boards and Commissions • BUDGET SUMMARY: • 101-1510 • Accounts 21 IO and 2111 provide funding for the salaries/wages of Council Members and staffing reflected under Personnel Data. • Account 2120 includes funding for medical insurance premiums for City Council Members and staff. • Account 2201 includes $3,500 for travel and training for each Council Member, $2,500 for travel and training for the Clerk of Council, $2,500 for the Deputy Clerk of Council for the Certified Municipal Clerk Career Development program, and $500 for the Office Assistant II. • Account 2212 provides funding for long-term strategic planning workshops. Council retreat was moved to the City Manager's miscellaneous accounts. • Account 2240 includes funds for reimbursable business expenses and for citywide ceremonial functions, which are reviewed and approved by the Mayor and the City Manager. These include such items as the annual recognition event hosted by City Council during the Memorial Tournament for City board/commission members and board members of various Dublin organizations; complimentary passes for all City board and commission members for the Dublin Irish Festival; Memorial Tournament badge package for Council Members, receptions/dinners hosted by City Council for public officials from various jurisdictions; purchase of tickets or tables at regional events/recognition programs supported by the City; attendance by Council Members representing the City at various dinners or meetings; memorial donations; birthday and special occasion recognition; parade expenses, including signage, hospitality and flowers; photography services for ceremonial purposes; City logo wear for Council Members; and purchase of Dublin merchandise for various recognition programs. • Account 2320 provides funds for monthly fax line service for each Council Member's home and for cellular phones for the Council office. • Account 2330 provides funding for lease and maintenance of a large volume copier and scanner in the Council offices at City Hall. • Account 2349 provides funding for codification services. The City Manager's evaluation was moved to the City Manager's miscellaneous accounts. • Account 2370 provides funds for advertising expenses for public meeting notices and agenda publication as required by the Revised Charter. • Account 2520 provides funding for miscellaneous furniture/equipment for Council offices. • 101-1520 • Account 2110 provides funding for the salaries/wages of Planning and Zoning Commission members and the Council representative to the Planning and Zoning Commission. • Account 2201 provides funding for general travel and training for board and commission members in accordance with the guidelines established by City Council. In addition, Planning and Zoning Commission members are each allocated up to $2,500 per year for relevant training. • Account 2211 provides funding for expenses related to meetings sponsored by various City advisory boards, commissions, committees and task forces. Council -48- 12/ 11 /06 Office of the City Manager STATEMENT OF FUNCTIONS: The City Manager is the Chief Administrative and Law Enforcement Officer of the City and is charged with the responsibility for the administration of all municipal affairs as empowered by the Revised Charter of the City of Dublin, City Ordinances or Resolutions, and State laws. Some of the City Manager's primary responsibilities include: directing and supervising the administration of all departments and functions of the City; attending all Council meetings; ensuring that all laws, Revised Charter provisions, and ordinances and resolutions of Council are faithfully executed; preparing the annual budget and capital improvement program; publishing an annual report of the financial and administrative activities of the City; and executing, on behalf of the City, all contracts and agreements. OBJECTIVES AND ACTIVITIES: • To implement goals established by City Council. • To provide leadership and direction for Staff. • To be responsive to needs of the community and to advise citizenry regarding the structure and activities of the City organization. • To facilitate citizen involvement and requests for service. PERSONNEL DATA POSITION TITLE 2006 2007 CURRENT NUMBER ADOPTED City Manager 1 1 Senior Project Manager 1 1 Executive Assistant 1 1 Office Assistant I 1 1 Intern t t TOTAL 5 5 NOTES AND ADJUSTMENTS: CityMgr -49- 12/ 11 /06 2007 Budget -City of Dublin, Ohio General Fund City Manager Office of the Director 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1110 Personal Services ~; 2110 Salaries/Wages 320,259 352,600 352,600 337,000 367,100 2111 Overtime Wages 3,749 2,500 2,500 2,500 2,500 2112 Other Wages 5,757 10,000 10,000 5,400 10,000 ~ 2119 Instant Bonuses 418 15,000 15,000 4,800 15,000 2120 Employee Benefits 117,195 121,150 121,150 120,900 114,525 447,378 501,250 501,250 470,600 509,125 Other Expenses 2201 Conference/Mileage 9,871 5,250 5,250 4,850 5,250 2210 Reimbursable Business Exl 631 1,500 1,500 1,000 ,. 1,500 2211 Meeting Expenses 1,020 1,500 1,500 850 1,500 2230 Staff Goaf Setting 16,393 0 12,500 10,000 4,500 2320 Communications 1,966 2,250 2,459 2,200 2,350 2349 Professional Services 16,394 0 17,500 17,500 1,000 °- 2351 Maint. of Equipment 394 1,000 1,000 200 500 2380 Printing & Reproductions 1,082 500 500 500 ~.-. 500 2390 Misc Contractual Services 1,358 3,300 3,300 1,000 2,500 2391 Memberships/Subscriptions 4,688 2,500 2,500 2,500 3,650 „, 2410 Office Supplies 1,246 2,000 2,226 1,600 2,000 2420 Operating Supplies 138 1,000 1,000 400 1,000 2440 Small Tools & Minor Equip 1,525 500 500 100 250 ~-; 2812 Special Projects/Programs 325 0 0 0 , 44,000 57,031 21,300 51,735 42,700 70,500 Capital Outlay 2520 Equipment & Furniture 1,850 700 700 500 0 ~- 1,850 700 700 500 0 TOTALS $506,259 $523,250 $553,685 $513,800 $579,625 ~~• -50- Office of the City Manager BUDGET SUMMARY: • Account 2110 reflects contract provisions for the City Manager and funding for other staffing within the Office of the City Manager. • Account 2112 provides funding for one Intern position. • Account 2l 19 provides funding for the employee instant bonus program. • Account 2210 includes reimbursable business expenses for the City Manager as specified by contract. • Account 2211 includes funding for meetings sponsored by the City. This may include food, beverages, and associated supplies. • Account 2320 is for charges associated with providing the City Manager, Senior Project Manager, and Executive Assistant with cellular phones and long distance telephone charges for the office. • Account 2391 includes funding for memberships in Ohio City Managers Association, International City Managers Association, and other similar organizations. • Account 2812 is for special projects. Projects included in 2007 are start-up of a visual arts commission, analysis and possible implementation of impact fees, and programming in response to issues identified within the 2006 climate survey. CityMgr -51- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CTIY nF DUBLIN.. Miscellaneous Accounts/Contingencies STATEMENT OF FUNCTIONS: These are miscellaneous accounts within the General Fund which are not directly related to the operational costs of a specific function. The functional "supervision" of these accounts is provided by the Office of the City Manager. Funds are appropriated to the contingency account to beheld for any unforeseen expenses during the current fiscal year. The expenditures are required to be approved by the City Manager. NOTES AND ADJUSTMENTS: MiscAccts -53- 12/11/06 «~a- 2007 Budget -City of Dublin, Ohio General Fund City Manager Miscellaneous 2005 2006 2006 2006 2007 ~. Actual Budget Revised Budget Estimate Budget 101-1119 Other Expenses 2349 Professional Services 0 0 162,000 146,000 96,000 2362 Workers' Compensation 128,500 402,200 402,200 362,750 437,425 ` 2391 Memberships/Subscriptions 44,447 47,400 45,400 45,400 100,700 2392 County Wide Disaster Serv 24,728 26,900 28,900 27,650 30,800 2399 Animal Control 62,800 50,000 50,000 50,000 0 2821 GrantslCommunity Org 35,000 35,000 35,000 35,000 35,000 ~: 2823 Leadership Dublin 10,000 10,000 10,000 10,000 10,000 2840 Settlement Claims 110,000 0 0 0 0 2990 Contingencies 55,028 150,000 150,000 130,000 150,000 ;~. 470,503 721,500 883,500 806,800 859,925 TOTALS $470,503 $721,500 $883,500 $806,800 $859,925 ' -54- Miscellaneous Accounts/Contingencies BUDGET SUMMARY: 101-1119 • Account 2349 provides funding for federal and state legislative education, executive recruitment, executive team building, and Council retreat. • Account 2362 provides funding for the City's workers' compensation program. This amount reflects the City's self-insured program costs and premium costs for the first quarter of 2006, during which the City was covered by the fully insured Ohio Bureau of Workers Compensation program. • Account 2391 includes funds for memberships/subscriptions to the US 33 Corridor Accord, Ohio Municipal League, the National League of Cities, Mid-Ohio Regional Planning Commission, MORPC regional growth strategy plan, the Delaware County Regional Planning Commission, the Central Ohio Municipal Alliance and any other citywide memberships/subscriptions. • Account 2399 has been reduced because animal control services have been transferred to professional services in the Parks & Open Space Budget. • Account 2821 provides funding for the Dublin Counseling Center. • Account 2823 provides funding for Leadership Dublin. MiscAccts -55- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CI7Y QF DUBLIN.. ~:. ~. Human Resources STATEMENT OF FUNCTIONS: Human Resources is managed by the Director of Human Resources, who reports directly to the City Manager. Human Resources provides strategic leadership and direction to the organization in all functional areas of Human Resources Management including recruitment and selection; classification and compensation; performance management; wage and salary administration; benefits administration; labor/employee relations; policy analysis/development; organizational analysis/development; and training & development. Human Resources also provides leadership and direction to the organization in all functional areas of Risk Management and Occupational Safety & Health. OBJECTIVES & ACTIVITIES: • To function as a strategic business partner in the organization -providing guidance, strategic direction and consultation to all segments of the organization to assist each segment in fulfilling its mission, goals, and objectives. • To lead the organization in workforce planning efforts to ensure personnel are strategically .deployed in the organization.. • To develop, administer, and evaluate new recruitment/selection strategies based on identified key competencies inherent to each position; partnering with all organizational units in the selection of highly qualified, highly competent, and highly effective human resources/human capital. • To provide leadership and guidance to the organization in developing and implementing new benefit and related health management strategies. • To provide leadership, guidance, and direction to the organization in the administration of a new classification & compensation system, ensuring that all managerial and supervisory personnel are effectively trained in the administration of the new compensation system. • To implement a new performance .management system and provide ongoing leadership and direction to the organization to facilitate better employee communication, improve performance, and ensure better documentation of performance evaluations; ensure that al] managerial and supervisory personnel are trained in the administration of the new performance management system. • To implement and administer supervisory training programs that focus on skilUcompetency development. • To provide leadership to management bargaining team in negotiation process for new Collective Bargaining Agreements with the FOP capital City Lodge (Police Officers, Corporals, Sergeants) and United Steelworkers (Maintenance Workers, Auto Mechanics, Custodial Workers). • To implement anew Human Resources Information System CHRIS) that will enhance the efficiency and tracking ability of HR, the delivery of services by HR, and that will provide a self- service component for employees to self-manage their own information. • To manage insurance, risk management, and employee safety programs. • To administer the new self-insured worker's compensation program. PERSONNEL DATA 2006 2007 POSTIION TITLE CURRENT NUMBER ADOPTED Director, Human Resources Human Resource Manager Human Resource Coordinator 3 3 Human Resource Technician 1 1 Safety Administrator/Risk Manager 1 1 Risk Management Specialist 1 1 Administrative Assistant 1 1 TOTAL 9 9 NOTES AND ADJUSTMENTS: Human Resources - 57- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund City Manager Human Resources 2005 2006 2006 2006 2007 ~, Actual Budget Revised Budget Estimate Budget 101-1120 Personal Services 2110 Salaries/W.ages 486,531 534,200 534,200 512,750 546,775 2111 Overtime Wages 3,048 3,500 3,500 3,500 3,000 2112 Other Wages 0 0 0 0 0 ~. 2120 Employee Benefits 167,478 178,400 178,400 165,000 199,500 2125 Employee Training & Dev. 99,149 28,000 67,467 50,000 36,600 "~' 2126 Tuition Reimbursement 27,784 45,000 44,441 35,700 45,000 2140 Uniforms & Clothing 1,174 1,200 1,200 1,200 1,200 785,164 790,300 829,208 768,150 832,075 Other Expenses 2201 Conference/Mileage 4,487 8,250 10,750 10,200 11,000 ~` 2210 Reimbursable Business Exl 2,372 3,100 8,100 5,900 7,500 2211 Meeting Expenses 0 0 3,000 2,100 4,000 2320 Communications 3,716 ~ 4,000 4,286 3,750 4,900 2330 Rents/Leases 6,777 7,200 7,200 7,000 4,975 2349 Professional Services 71,971 68,665 146,953 121,550 79,050 2351 Maint. of Equipment 3,542 3,550 5,700 5,500 6,700 ~s 2360 Insurance & Bonding 371,486 418,200 408,200 408,200 441,650 2365 Insurance Claims paid 253 10,000 9,767 6,150 10,000 2370 Advertising 32,227 19,250 24,387 22,000 16,500 ~'' 2380 Printing & Reproductions 68 3,000 3,000 700 1,500 2390 Misc Contractual Services 31,468 30,500 32,586 29,700 28,400 2391 Memberships/Subscriptions 6,354 7,000 8,000 6,500 7,000 _" 2410 Office Supplies 5,864 10,000 8,500 8,550 12,000 , 2440 Small Tools & Minor Equip 355 6,000 6,000 6,000 6,800 2810 Employee Awards Program 7,571 3,000 3,000 2,050 3,500 `~ 2812 Special Projects/Programs 3,828 3,750 12,750 3,750 4,500 , 2815 Risk Mgt./Safety Programs 16,382 19,600 28,132 17,000 19,600 568,721 625,065 730,311 666,600 669,575 Capital Outlay 2520 Equipment & Furniture 0 0 4,500 4,100 TOTALS 0 $1,353,885 0 $1,415,365 4,500 $1,564,019 4,100 $1,438,850 2,900 '' 2,900 ~.. $1,504,550 -58- Human Resources BUDGET SUMMARY: • Account 2125 provides funding for supervisory and non-supervisory training on an organization-wide basis (e.g. sexual harassment, employment discrimination, employment practices, drug & alcohol awareness, management skills). This account also provides funding for conversational Spanish. • Account 2140 provides funds for the purchase of Dublin City Staff shirts for newly hired employees. • Account 2320 includes funding for cellular phones and local and long distance telephone charges. • Account 2349 provides funding for grievance arbitration, employment screening procedures, criminal record checks, driving record checks, drug and alcohol testing, polygraph examinations, psychological evaluations for police personnel, and medical examinations for certain new hires. This account also provides funding for consulting fees related to ongoing administration of the new classification & compensation system. • Account 2360 provides funding for the City's contribution to the CORMA (Central Ohio Risk Management Association) self-insured loss fund and for stop loss premiums for the coverage period October 1, 2007 to October 1, 2008. • Account 2370 provides funding for recruitment announcements in newspapers, professional/trade journals and publications, and on various websites. • Account 2390 includes funding for the Employee Assistance Program, a citywide program. This account also includes funding for the City's monthly maintenance fee for HR Smart, the City's on-line employment application program. • Account 2$10 funds the employee service awards. • Account 2815 provides funding for a wide variety of employee safety programs, some of which are mandated by State safety regulations. Human Resources -59- l 2/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITY t~F I3Uf31.iN.. Community Relations STATEMENT OF FUNCTIONS: Community Relations/Communications serves as in-house support to all City functions for communication counsel, public information campaigns, message and issues management, graphic design and branding, publications and ceremonial and special project needs. Communications is responsible for internal communications, external communications and media relations, and the City and Dublin Irish Festival Web sites and Intranet site and employees. Community Relations also coordinates City services required for events held within the City of Dublin through the Special Event Permit process. OBJECTIVES AND ACTIVITIES: • To manage communications and marketing for City programs and/or special projects to include goals, objectives, strategies, tactics, key messages and measurement of results. • To serve as public information officers for all City departments. • To promote City Council goals, achievements and initiatives including economic development and Historic Dublin. • To develop and administer the City's internal communications program, employee recognition events program and the City's overall recognition program. • "I'o administer the community event application and permit process. • To facilitate citywide media, spokesperson and presentation training. • To conduct citywide Public Opinion and Citizen Satisfaction survey. • To write speeches and talking points for Mayor, City Council members, City Manager, Management staff and other key officials. • To coordinate press conferences, dedications, and special projects, such as the State of the City Address, park dedications, Arbor Day, Veterans Project, Cable "1'V Program and the City's Bicentennial Celebration. • To manage the City's Web sites and electronic communications (i.e., 1610, cable communications). • To oversee a Graphic Guidelines Program. • To implement the Civic Association Initiative via regular correspondence, bi-annual meetings, block party package and float initiative. • To establish and administer the citywide photo library and media tracking system. • To coordinate citywide Memorial Tournament activities to enhance relationships with community leaders and VIPs for economic development, relationship building and international recognition. • To support the special events team in coordinating and implementing the Dublin Irish Festival, Independence Day Celebration, St. Patrick's Day Celebration and Spooktacular. • To serve as a liaison to Historic Dublin to promote their events and special projects, to coordinate ceremonial tree lighting efforts and facilitate the banner and pennant program. PERSONNEL DATA .2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Community Relations 1 1 Public Information Officer 3 3 Website Editor 1 1 Administrative Assistant 1 I Office Assistant II I I Community Relations Assistant I I Intern 1 I Office Assistant II-Seasonal/ 3 1 1 months TOTAL 10 10 NOTES & ADJUSTMENTS: The Personal Services costs for the Director, Administrative Assistant, Community Relations Assistant, and Office Assistant II are allocated fifty percent (50%) to this budget and fifty percent (50%) to the Hote1/Motel Tax Fund. Comm Relations - 61- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund ' City Manager ~~ Community Relations 2005 2006 2006 2006 2007 ,~ Actual Budget Revised Budget Estimate Budget - - 101-1130 Personal Services 2110 2111 2112 2120 Salaries/Vllages Overtime Wages Other Wages Employee Benefits 324,057 9,562 31,910 121,590 340,200 7,750 20,100 121,100 345,200 6,750 21,100 121,100 336,700 6,750 20,100 118,500 362,475 7,750 20,100 140,200 ;~, 487,119 489,150 494,150 482,050 530,525 ~, Other Expenses 2201 Conference/Mileage 5,472 10,250 4,250 3,000 10,250 ' 2211 Meeting Expenses 852. 2,000 2,000 1,050 1,650 , 2320 Communications 20,169 14,850 18,474 16,600 11,025 2330 Rents/Leases 5,965 6,600 8,235 7,650 6,600 ' 2349 Professional Services 78,093 57,700 68,650 57,900 57,600 ~t 2351 Maint. of Equipment 420 875 875 450 875 2370 Advertising 17,787 20,000 22,213 21,900 20,000 `"" 2380 Printing & Reproductions 32,175 32,100 33,350 33,150 28,850 2390 Misc Contractual Services 5,581 3,900 9,479 9,250 3,900 2391 Memberships/Subscriptions 3,870 4,350 4,350 3,800 4,900 ~' 2410 Office Supplies 7,378 11,500 8,854 8,750 10,200 2420 Operating Supplies 52,655 11,800 10,800 7,500 11,500 2440 Small Tools & Minor Equip 4,094 900 900 900 900 '~` 2812 Special Projects/Programs 44,975 91,250 93,850 75,000 155,200 2813 Promotional Programs 191,761 198,950 189,850 189,850 179,200 471,247 467,025 476,130 436,750 502,650 TOTALS $958,366 $956,175 $970,280 $918,800 $1,033,175 ~_ -62- Community Relations BUDGET SUMMARY: • Account 2110 provides wages and salaries for communications personnel. • Account 2l 12 includes one intern and a seasonal Office Assistant II position. • Account 22 ] 1 provides funding for business luncheons, internal working meetings and an annual Central Ohio Public Information Officer luncheon. • .Account 2320 includes funding for cellular phones and courier service charges. • Account 2330 provides funding to lease a copier. • Account 2349 includes funding for consulting services for communications; photography; videography; graphic design for the annual report, bike map revisions, Dublin Community Recreation Center program brochure; Dublin Life contract fee and for storing web pages. • Account 23S 1 provides maintenance for fax machine, copier and services for 1610 AM radio station. • Account 2370 provides funding for the comprehensive In Touch ad in the local newspaper. • Account 2380 includes funding for printing costs for the annual report, bike path map, brochure shells, economic development brochure and civic association print materials. • Account 2420 includes funding for Historic Dublin lamppost banners and pennants. • Account 2812 includes funding for the 2008 Community Satisfaction survey; citywide Employee Recognition Program; City director receptions; new park openings; the Civic Association Initiative including block party supplies, president's manual and parade initiative; ceremonial tree lighting; historic preservation; Veterans Day activities; Dr. Martin Luther King Jr. Day activities; Bicentennial planning; cable television programming; employee recognition events including Star Celebration, employee breakfast at the Memorial Tournament and employee tickets for the Dublin Irish Festival. • Account 2813 provides funding for the City's involvement with the Memorial Tournament, which includes a hospitality area, badge package, daily tickets, advertising in the Memorial Tournament Magazine, 20 positions for the Nicklaus/Flick golf school and designation as host of the corporate outing and the media room. Also included is funding for citywide recognition gifts and promotional purchases. Comm Relations -63- 12/11/06 w THIS PAGE LEFT BLANK INTENTIONALLY CITY QF DUBLIN.. Legal Services STATEMENT OF FUNCTIONS: The Law Director provides legal representation to City Council, the City Manager, the administrative departments, and various Boards and Commissions. The Law Director is appointed by the City Manager with the approval of City Council. Currently this position is filled on a contractual basis. Periodically, other legal counsel is retained for specialized problems or legal work. The Director of Law prepares ordinances, resolutions, legal opinions, contracts, agreements and legal documents. The Director also advises City Officials of pending legislation affecting municipal operations. In addition, either the Director or one of the Director's assistants prosecutes all criminal cases which come before the Dublin Mayor's Court. OBJECTIVES AND ACTIVITIES: To provide legal counsel in accordance with the contract. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director of Law 1 1 Assistant Director of Law 2 2 TOTAL 3 ~ 3 NOTES AND ADJUSTMENTS: Numerous associates within the firm of Schottenstein, Zox, and Dunn work under the direction of the Director of Law to provide legal counsel for the City. Law -65- 12/11/06 ice- 2007 Budget =City of Dublin, Ohio General Fund City Manager ' Legal Services 2005 2006 2006 2006 2007 ,~ Actual Budget Revised Budget Estimate Budget 101-1140 ~; Other Expenses "`' 2345 Legal Services 945,058 890,000 890,000 860,000 ~,: 935,000 2346 Other Legal Services 491,456 500,000 590,000 520,000 525,000 ""' 2349 Professional Services 90,578 150,000 81,712 50,000 150,000 ,~: 1,527,092 1,540,000 1,561,712 1,430,000 1,610,000 ,~; TOTALS $1,527,092 $1,540,000 $1,561,712 $1,430,000 $1,610,000 -66- ~,- Legal Services BUDGET SUMMARY: • Account 2345 is used to pay for general services provided by the Director of Law, including Mayor's Court. • Account 2346 provides funding for special legal services provided by the Director of Law, for example, in the areas of labor relations, telecommunications and bond counsel related to the issuance of debt. In 2007, funding is included for negotiations of two labor agreements. • Account 2349 includes funds for services related to economic development and other outside legal services as needed. Law -67- 12/ 11 /06 ~k- 9 ia.: t ie, THIS PAGE LEFT BLANK INTENTIONALLY CITY OF Dtfl3LIN.. Finance/Office of the Director STATEMENT OF FUNCTIONS: The Director of Finance assists the City Manager in the preparation and administration of the operating budget, the capital improvements program, and is responsible for the administration of the City's debt and the various economic development and tax increment financing agreements. The Director of Finance also has administrative authority over Taxation, Procurement, and Accounting and Auditing. OBJECTIVES AND ACTIVITIES: • To help maintain a fiscally sound government and to conform to regulations by improving methods for financial planning and capital improvement planning. • To provide assistance to the City Manager in the preparation and administration of the City's operating and capital budgets. • To update, on an annual basis, the costs of all services provided by the City and to compare and evaluate the service cost with the service revenue. • To maintain the financial records, ensure compliance with economic development commitments, and allocate funds in accordance with the applicable agreements for the City's various Tax Increment Financing Districts and Community Reinvestment Areas. • To administer the City's debt financing function with the goal of maintaining the AAA rating from Fitch Ratings and Aaa rating from Moody's Investors Service. • To receive the Distinguished Budget Presentation Award for the 2007 Operating Budget. • To develop, implement and administer the City's procurement functions, including competitive bid processes and utilization of cooperative purchasing alternatives. PERSONNEL DATA POSITION TITLE Director, Finance/Deputy City Manager Director, Fiscal Administration Financial Analyst Budget Analyst Procurement Assistant Administrative Assistant TOTAL 6 NOTES AND ADJUSTMENTS: 2006 2007 CURRENT NUMBER ADOPTED 1 1 1 1 1 1 1 l 1 1 1 1 FinAdm -69- 12/11/06 2007 Budget -City of Dublin, Ohio ffiva , General Fund ~~ Finance '"" Office of th e Director 2005 2006 2006 2006 2007 ,.„,.. Actual Budget Revised Budget Estimate Budget 101-1210 Personal Services 2110 Salaries/Wages 357,008 375,350 383,350 373,200 383,150 2111 Overtime Wages 154 0 100 100 250 2120 Employee Benefits 106,893 108,400 108,400 108,050 120,450 , 464,055 483,750 491,850 481,350 503,850 ,~, Other Expenses ~~ 2201 Conference/Mileage 427 6,500 3,100 1,300 6,500 2320 Communications 434 600 887 650 650 "` 2340 Accounting/Auditing Serv 500 500 500 500 500 2380 Printing & Reproductions 1,181 3,500 4,589 4,200 4,000 2390 Misc Contractual Services 1,654 7,500 7,500 5,700 6,000 2391 Memberships/Subscriptions 441 575 675 600 600 „~, 2410 Office Supplies 917 1,000 1,000 600 1,000 5,554 20,175 18,251 13,550 19,250 TOTALS $469,609 $503,925 $510,101 $494,900 $523,100 ~r_ n= - , -70- Finance/Office of the Director BUDGET SUMMARY: • Account 2110 funds wages and salaries for personnel as outlined. • Account 2380 provides funding for the printing of the City's operating and capital budgets and the cost study document. The number of hard copy documents will be fewer due to the rise in CD Rom versions. • Account 2390 funds consultation for upgrades and modifications needed to the cost of services study software. FinAdm -71- 12/11/06 2007 Budget -City of Dublin, Ohio ,~ General Fund '"" Finance Procurement 2005 2006 2006 2006 2007 ~* Actual Budget Revised Budget Estimate Budget 101-1211 Personal Services "° 2110 Salaries/Wages 43,012 45,050 45,050 43,200 46,550 2111 Overtime Wages 966 500 500 450 500 2120 Employee Benefits 18,337 18,150 18,150 17,900 20,700 62,315 63,700 63,700 61,550 67,750 Other Expenses '~ ~~. 2201 Conference/Mileage 75 500 500 500 500 2320 Communications 39,723 45,150 45,150 45,150 45,675 2330 Rents/Leases 28,087 32,050 39,002 32,000 18,400 2351 Maint. of Equipment 6,234 10,450 10,950 10,450 9,800 2370 Advertising 13,751 13,000 12,450 10,000 13,000 2391 Memberships/Subscriptions 495 525 525 500 1,125 ,p,. 2410 Office Supplies 33,138 46,500 41,869 40,000 25,000 2420 Operating Supplies 195 500 550 500 700 2429 Coffee/Misc. Supplies 16,881 19,500 19,500 19,500 19,500 138,579 168,175 170,496 158,600 133,700 TOTALS $200,894 $231,875 $234,196 $220,150 $201,450 ., -72- Finance/ Procurement BUDGET SUMMARY: • Account 2320 reflects postage expenses for City Hall that formerly had been included in the Facilities budget. • Account 2330 includes funding for rental of the City Hall postage machine and water coolers; both have been shifted to this budget from the Facilities budget. Also included here are leases for a copier, a shredder, and a fax machine for City Hall, previously included in the Taxation budget. • Account 2351 provides funding for maintenance for copiers, shredder and fax machine in City Hall and for per-copy charges for the various copiers. • Account 2370 provides funding for bid notices/legal advertisements for public improvement and construction projects. • Account 2410 provides funding for letterhead stationery/envelopes, business cards, note cards, and folders for citywide usage. • Account 2429 provides funding for coffee and related supplies to make coffee available to City staff and visitors during meetings at City buildings. Procurement -73- 12/ 11 /06 i~a THIS PAGE LEFT BLANK INTENTIONALLY CITY ElF DUBLllV.. ~,,. Finance/ Transfers/Advances STATEMENT OF FUNCTIONS: The General Fund is the general operating fund of the City; money can be transferred from the General Fund to any other fund with approval of City Council. A transfer is the permanent movement of money from one fund to another. Operating transfers are made to the Street Maintenance and Repair Fund, the Recreation Fund, the Safety Fund, the Cemetery Fund and the Swimming Pool Fund to supplement revenues directly credited to those funds. Funds are transferred when their fund balance drops below the. average monthly expenditures anticipated. Transfers to the Capital Improvements Tax Fund and other capital project funds are based on projects identified in the City's Five-Year Capital Improvements Program (CIP). To the extent that cash reserves become available in the General Fund, additional capital projects are programmed in the C1P. An advance is a temporary movement of money from one fund to another. The City has utilized advances, for the most part, to provide initial funding for capital projects associated with the tax increment financing districts. NOTES AND ADJUSTMENTS: Transfer ~ -75- 12/ 11 /d6 2007 Budget-City of Dublin, Ohio General Fund 2006 Finance 2005 2006 Revised 2006 .2007 Transfers/Advances Actual Budget Budget Estimate Budget 101-1217 Transfers 2710 Street Maintenance Fund $1,500,000 $2,000,000 $2,000,000 $1,250,000 $2,000,000 2711 Recreation Fund 2,500,000 4,000,000 4,000,000 2,750,000 4,000,000 2712 Safety Fund 7,800,000 8,725,000 8,725,000 7,700,000 8,600,000 2714 General Bond Retirement Fund 0 0 0 0 0 2715 Capital Improvements Tax Fund 6,187,500 0 0 0 7,500,000 2718 Swimming Pool Fund 200,000 600,000 600,000 400,000 550,000 2720 Cemetery Fund 125,000 100,000 100,000 50,000 150,000 2723 Land Acquisition Fund 0 0 2,400,000 2,400,000 0 101-1218 Advances (1) 2737 Perimeter West TIF 30,000 0 0 0 0 2739 Land Acquisition Fund 6,608,000 0 0 0 0 2740 COIC Improvement Fund 0 0 0 5,706,000 0 TOTALS $24,950,500 $15,425,000 $17,825,000 $20,256,000 $22,800,000 (1) Advances are not required to be appropriated, they are reflected for cash flow purposes. ~4- -76- Finance/ Miscellaneous Accounts STATEMENT OF FUNCTIONS: These are miscellaneous accounts within the General Fund which are not directlyrelated to the operational costs of a specific function. The functional "supervision" of these accounts is provided by the Department of Finance. The cost of the City's annual audit has been reflected in the Miscellaneous Accounts due to its citywide nature NOTES AND ADJUSTMENTS: MiscAccts -77- 12/I 1/06 2007 Budget -City of Dublin, Ohio ..~ General Fund Finance Miscellaneous 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1219 Other Expenses 2301 County Auditor Deductions 12,202 15,000 15,000 15,000 14,000 2340 Accounting/Auditing Serv 53,586 55,000 55,000 55,000 55,000 2398 Real Estate Taxes 54,064 160,250 160,250 160,250 108,000 2309 Health Services 153,496 .186,500 186,500 186,450 199,604 273,348 416,750 416,750 416,700 376,604 TOTALS $273,348 $416,750 $416,750 $416,700 $376,604 -78- Finance/ Miscellaneous Accounts BUDGET SUMMARY: • Account 2301 provides funding for election expenses and expenses related to advertising and collecting delinquencies. These fees are deducted from the City's property tax settlements. • Account 2309 provides funding for the City's contract with the Franklin County Board of Health . • Account 2340 provides funding for the City's annual audit. The audit will be prepared by Clark, Schaefer, Hackett, and Company. 2007 will be the second year of a three year contract. • Account 2398 funds real estate taxes for properties owned by the City that are not tax-exempt based on usage, or for which property tax exemption is pending. The expense was increased in 2006 for real estate taxes for properties acquired for development of the COIC. MiscAccts -79- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CITY OF UUBLIN.. Finance/Accounting & Auditing STATEMENT OF FUNCTIONS: Accounting & Auditing is responsible for maintaining the financial records ofthe City including: recording all receipts and expenditures; processing the City's payroll, maintaining capital asset records, internally examining and auditing accounts of the various departments and preparation of the City's Comprehensive Annual Financial Report (CAFR). OBJECTIVES AND ACTIVITIES: • To receive an unqualified audit opinion and the Certificate of Achievement For Excellence in Financial Reporting for the City's CAFR. • To collect, deposit, and accurately account for City monies received, and ensure compliance with established procedures. • To pay vendors providing goods and services to the City in a timely manner, account for expenditures accurately and ensure compliance with established procedures. • To ensure accurate and timely payment of employees' wages, salaries and benefits in accordance with the City's labor contracts, administrative policies, and federal and state regulations. • To safekeep and invest City monies in a manner consistent with the Ohio Revised Code and the City's investment policy. • To maintain accountability for the City's capital assets. PERSONNEL DATA POSITION TITLE 2006 CURRENT NUMBER 2007 ADOPTED Director, Accounting & Auditing 1 1 Accountant 1 1 Payroll Specialist 1 1 Accounting Specialist 2 2 Accounting Assistant 1 1 Accounting Specialist (part-time) 1 ~ TOTAL ~ 7 NOTES AND ADJUSTMENTS: FinAdm -81- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Finance Accounting and Auditing 2005 2006 2006 2006 2007 ~. Actual Budget Revised Budget Estimate Budget 101-1220 Personal Services 2110 SalariesNVages 355,082 384,200 384,200 375,000 2111 Overtime Wages 6,979 5,000 5,000 4,900 2112 Other Wages 3,194 0 0 0 2120 Employee Benefits 116,572 121,650 121,650 112,000 481,827 Other Expenses 2201. Conference/Mileage 2320 Communications 2340 Accounting/Auditing Serv 2349 Professional Services 2351 Maint. of Equipment 2370 Advertising 2380 Printing & Reproductions 2390 Misc Contractual Services 2391 Memberships/Subscriptions 2410 Office Supplies Capital Outlay 397,550 5,000 "` 0 ,~, 128,200 530,750 5, 500 `~ 1,000 550 30,000 500 ,~ 100 1,500 ~` 15,000 1,825 6,500 `" 62,475 2520 Equipment & Furniture 1,660 2,500 1,500 1,500 2,500 ~.. 1,660 2,500 1,500 1,500 2,500 ,~„ TOTALS $542,526 $586,325 $595,304 $573,200 $595,725 '~' -82- 1,288 974 550 30,000 0 42 1,831 14,573 1,924 7,857 59,039 510,850 5,500 1,000 9,050 30,000 500 100 1,500 15,000 1,825 8,500 72,975 510,850 5,500 1,000 18,280 32,500 500 100 1, 500 13,249 1,825 8, 500 82,954 491,900 4,000 1,000 17,500 32,500 500 100 1,100 13,000 1, 700 8,400 79,800 Finance/Account4tig & Auditing BUDGET SUMMARY: • Account 2110 provides funding for staff positions listed under the statement of functions. • Account 2340 is reduced because the golf course audit is done every other year. The next audit is scheduled in 2008. The only allocation here is for the GOFA CAFR filing. • Account 2349 provides funding for the use of an investment advisor for most of the City's portfolio. • Account 2370 provides funding for the public notice of the availability of the City's financial statements as required by the Ohio Revised Code. • Account 2380 provides funding for the printing of the City's Comprehensive Annual Financial Reports (CAFR). The number of hard copies of the document to be produced will be reduced and compact disk versions will be used to distribute the document where appropriate, reducing the cost of printing. • Account 2390 provides funding for custodial fees related to investment accounts, fees associated with the City's purchasing card program and an audit of motor vehicle registrations. • Account 2410 provides funding for blank check stock, leave request forms for City employees and other forms and general office supplies. FinAcctAud -83- 12/11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITY (lF DUBLIN.. ~,t. r, Finance/Taxation .' STATEMENT OF FUNCTIONS: The primary function of Taxation is to administer the City Income and Hotel/Motel Tax Ordinances by '~ insuring the highest degree of compliance within a framework of effective and efficient tax administration. Taxation is responsible for the collection of all tax revenues, refunds, audits, delinquency collections, compliance projects and other duties as assigned. This office processes over 24,000 annual returns, over 17,000 estimated tax forms, and 60,000 withholding forms. In 2005, there were 4,219 accounts activated and ~'' 260 inactivated for a net gain of 3,959 new accounts and over 1,700 extensions granted. Preliminary and final '~ audits are conducted to insure that all tax obligations have been fulfilled. The Director of Taxation works closely with businesses to insure proper and timely filing, paying and processing of all tax forms. OBJECTIVES AND ACTIVITIES: "~" • To operate an efficient, organized and cooperative tax office. • To maintain prompt processing time frames on all returns and refunds. ~'" • To review withholding frequencies on all accounts and make necessary adjustments. "s • To closely monitor progress of collection efforts through formally established delinquency procedures. "' • To monitor income tax legislation and update income tax ordinance as necessary. '"~ • To accept W-2's via magnetic tape or diskette. • To accept payments processed through the Ohio Business Gateway. "" To cross-train Taxation staff. '"" • To implement telefiling, electronic filing and electronic funds transfer for withholding accounts. • To evaluate and implement a pilot program to allow Dublin residents who live and work in Dublin to "t"" file electronically (W2 income only for the pilot program). ~" • To provide assistance in the administration of tax increment financing and economic development agreements. • To scan all tax documents to enable records to be accessed quickly and efficiently at each work- ~+- station. • To barcode returns for imaging to allow staff to audit returns via computer. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Taxation 1 1 ~, Accounting Specialist 4 4 ~,,, Office Assistant II (part-time) 1 1 Office Assistant I (part-time) 1 1 TOTAL 7 7 NOTES AND ADJUSTMENTS: r FinTax -gs- 12/11/06 - 2007 Budget -City of Dublin, Ohio General Fund ,~. Public Service Office of the Director 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget ~ 101-1310 .w Personal Services w~ 2110 SalarieslWages 212,393 222,975 232,975 195,000 230,950 2111 Overtime W a es 9 1,714 4,000 3,000 1,500 4,000 '" 2112 Other Wages 10,343 14,000 4,000 0 14,000 2120 Employee Benefits 62,365 63,950 64,950 58,000 71,825 ~ rr 286,815 304,925 304,925 254,500 320,775 Other Expenses 2201 Conference/Mileage 4,138 4,500 5,500 4,500 4,500 ! 2210 Reimbursable Business Exl 34 500 500 150 500 2211 Meeting Expenses 573 1,000 1,000 200 1,000 2320 Communications 17,339 3,000 3,611 1,850 2,300 2330 Rents/Leases 14,469 11,400 12,431 12,000 11,400 2349 Professional Services 7,190 350 4,350 4,000 5,000 2351 Maint. of Equipment 8,348 6,100 6,600 5,000 6,100 2380 Printing & Reproductions 1,050 2,000 1,986 1,200 2,000 2390 Misc Contractual Services 1,576 0 0 0 0 2391 Memberships/Subscriptions 1,523 1,525 1,525 1,400 1,350 2410 Office Supplies 2,250 2,400 2,853 1,700 2,400 2420 Operating Supplies 632 1,500 1,500 0 1,500 59,122 34,275 41,856 32,000 Capital Outlay 2520 Equipment & Furniture 7,281 1,000 1,000 - 500 38,050 7,281 1,000 1,000 500 1,000 TOTALS $353,218 $340,200 $347,781 $287,000 $359,825 -90- Public Service/ Office of the Director BUDGET SUMMARY: • Account 2210 provides funding for business meeting expenses and for luncheons with public officials from other jurisdictions, consultants and contractors. • Account 2320 includes funding for long-distance telephone charges and cellular phones. • Account 2330 provides funding for lease of a copier. • Account 2349 includes an allocation for miscellaneous accreditation consulting. Service -91- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CITY f1F ITUQLIN.. Public Service/ Solid Waste Management STATEMENT OF FUNCTIONS: The City of Dublin seeks recognition in the field of local government as being environmentally sensitive. To this end the City will provide a comprehensive solid waste management program. This program will provide services to Dublin residents with an emphasis on reduction, reuse, recycling, and beautification. This program will ensure the City's compliance with all solid waste management rules and regulations. All related services will be provided with the highest quality forces on customer satisfaction. OBJECTIVES AND ACTIVITIES: • To deliver the highest quality curbside chipper/leaf pickup service in the central Ohio area. • To continue to ensure our contracted refuse services are of the highest quality. • To maintain good customer relations by providing quality service pickup. • To keep storm systems free of leaf debris. • To keep the City's. right-of--way free of unsightly and unsafe vegetative debris piles. • To perforni chipper/leaf pickups in an economical efficient manner. • To continue to inform and educate the public on the City's solid waste programs. PERSONNEL DATA POSITION TITLE Operations Administrator Maintenance Workers Seasonal Maintenance Workers Crew Supervisor Office Assistant II 2006 2007 CURRENT NUMBER ADOPTED 4 7 0 3 0 1 0 1 13 TOTAL NOTES AND ADJUSTMENTS: This budget reflects two administrator positions allocated at 50% and 33%. 100% of a Crew Supervisor is allocated here. The budget consists of three additional maintenance workers, one which is transferred from the Street Maintenance budget, one which is transferred from the Sewer budget, and one which is transferred from the Water budget. The Office Assistant II position is allocated here at 100% and the Director position is allocated at 25%. SwMgmt -93- 12/ 11!06 2007 Budget -City of Dublin, Ohio General Fund Public Service S I' o id Waste Management 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1311 Personal Services 2110 Salaries/Wages 256,454 326,650 326,650 242,300 750 _. 459 2111 Overtime Wages 20,457 5,500 21,500 18,000 , 37 500 2112 Other Wages 35,714 30,000 14,000 14,000 , 46 000 2120 Employee Benefits 110,642 125,375 125,375 121,000 , 225 450 2140 Uniforms & Clothing 4,553 5,250 6,300 4,100 , 4,200 427,820 492,775 493,825 399,400 772,900 Other Expenses 2201 Conferences/Mileage 255 2,000 2,000 300 2 000 2320 Communications 580 2,750 2,750 0 , 0 2330 Rents/Leases 0 10,000 10,000 5,000 10 000 2349 Other Professional Serv 10,992 18,000 27,300 10,000 , 4 500 ' 2351 Maint. of Equipment 5,124 5,000 5,000 ~ 5,000 , 5 000 2370 Advertising 6,796 8,250 7,750 7,450 , 1 000 2380 Printing & Reproductions 232 2,500 2,500 1,700 , 1 000 ~~ 2391 Memberships/Subscriptions 220 1,650 2,050 1,000 , 250 2410 Office Supplies 196 300 300 150 800 2420 Operating Supplies 0 0 500 300 5 900 2440 Small Tools & Minor Equip 3,975 4,000 4,100 4,000 , 4 000 2811 Refuse Collect./Recycling 1,695,653 1,854,675 1,981,194 1,850,000 , 1 893 150 2813 Promotional Programs 10,965 9,000 18,500 5,000 , , 10,450 1,734,988 1,918,125 2,063,944 1,889,900 1,938,050 Capital Outlay ~,., 2520 Equipment & Furniture 0 0 0 0 1,500 0 0 0 0 1,500 TOTALS $2,162,808 $2,410,900 $2,557,769 $2,289,300 $2,712,450 -94- ~,: Public Service/ Solid Waste Management BUDGET SUMMARY: • Account 2201 provided funds to attend the Solid Waste Association of North America (SWANA) Conference which includes recycling certification for the Operations Administrator. • Account 2330 provides contingency funding to rent a tub grinder and related equipment that will be needed in case of a weather emergency resulting in significant damage. • Account 2349 provides funding for professional services to remove city facility hazardous waste and dead animals. • Account 2370 provides funding for advertising needs. Funding for Earthweek, Greenwise, and Household Hazardous Waste has been transferred to 2813 (Promotional Programs). • Account 2380 reflects printing and reproduction costs related to program advertising (account 2370 above.) • Account 2420 is a new account to the solid waste budget. It includes funding for operation supplies including waste hauler permits, paint, nuts/bolts, and other consumable items. • Account 2811 provides funding for the City's refuse/recycling contract with Rumpke, which was bid in 2004 fora 3-year term with two optional renewals. In addition, this account provides funds for small facility recycling containers, tipping fees for dumpsters/special events, additional recycling containers for citywide program, and decorative recycling containers for formal events. • Account 2813 provides funding for Greenwise Commercial Recycling, Earthweek, Irish Festival, Household Hazardous Waste, and curb markers for new subdivisions. • Account 2520 provides funding for two additional file cabinets. SwMgmt -95- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY errY nF ~US~N_ ~~,. Public Service /Fleet Maintenance STATEMENT OF FUNCTIONS: The Fleet Maintenance function provides city staff with safe, well-maintained transportation, enabling them to perform their job tasks with highly maintained vehicles that reflect a positive image on the individual and the City as a whole. Goals include ensuring all City equipment is serviced in a timely manner, ensuring unsafe equipment is not in service at any time, expediently turning around down equipment economically, and preserving the City's fleet with proven preventive maintenance procedure. OBJECTIVES AND ACTIVITIES: • Provide the highest vehicle maintenance standards. • Properly maintain fleet to ensure all City equipment is safe for use. • Add equipment to fleet as needed to ensure right equipment is available to do the job safely and economically and deliver the service to our residents at expected, levels. • Implement consistent preventative maintenance procedures to ensure maximum usage of equipment. • Hold auctions on a regular basis to eliminate older equipment from the fleet. PERSONNEL DATA POSITION TITLE Office Administrator Automotive Mechanic I Office Assistant II Office Assistant I (part-time) TOTAL 2006 2007 CURRENT NUMBER ADOPTED 6 6 0 1 1 0 8 NOTES AND ADJUSTMENTS: This budget includes the reclassification of the part time Office Assistant I position to a full time Office Assistant II position. Fleet -97- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Public Service Fleet Maintenance 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1321 Personal Services 2110 Salaries/Vl/ages 370,118 398,350 398,350 390,000 438 650 2111 Overtime Wages 15,703 15,000 15,000 8,050 , 10,000 2120 Employee Benefits 146,887 168,850 168,850 150,550 181,875 2140 Uniforms & Clothing 7,144 7,950 8,090 3,800 4,775 ,~ 539,852 590,150 590,290 552,400 635,300 Other Expenses 2201 2320 2330 2349 2351 2390 2410 2420 2421 2431 2440 Conference/Mileage Communications Rents/Leases Professional Services Maint. of Equipment Misc Contractual Services Office Supplies Operating Supplies Fuel Vehicle Maintenance Small Tools & Minor Equip 2,320 1,140 113 9,314 14,727 8,270 815 11,102 991,092 204,834 8,544 5,750 1,200 2,000 19,000 32,000 20,000 1,000 12,000 .900,000 245,000 8,050 5,750 1,404 2,000 21,108 33,000 20,000 1,502 12,246 998,084 265,748 8,050 2,450 1,000 1,300 9,300 30,300 19,100 1,150 12,200 948,000 233,400 6,050 6,000 1,200 2,100 20,000 32,000 20,000 1,000 12,000 995,400 257,000 5,050 ~#~ 1,252,271 1,246,000 1,368,892 1,264,250 1,351,750 Capital Outlay 2520 Equipment & Furniture 1,398 2,000 2,000 2,000 22,000 1,398 2,000 2,000 2,000 22,000 TOTALS $1,793,521 $1,838,150 $1,961,182 $1,818,650 $2,009,050 "' -98- Public Service /Fleet Maintenance BUDGET SUMMARY• • Account 2110 and 2120 provide funding for fleet maintenance employees. • Account 2320 provides funding for pagers and cellular phones. • Account 2330 provides funding for a copier lease and special tool rental. • Account 2349 includes funds for the removal of hazardous materials in accordance with federal guidelines, including used motor oil, oil filters and tires. • Account 2351 provides funding for various equipment inspections, outside body repairs, and the radio service contract. • Account 2390 provides funds for the citywide surplus auction, car washes as needed and for fire extinguisher inspection. • Account 2420 includes funding for soaps, wax degreasers, decal materials and welding materials. • Account 2421 provides funding for fuel and other petroleum products. Approximately 50% of the fuel is consumed by the Dublin City School District and Washington Township and is reimbursed based on actual usage. The fuel request is based on $2.45 per gallon. • Account 2431 provides funding for the repair and maintenance of all City-owned vehicles and equipment. • Account 2440 provides funding for hand tools and special tools due to model year changes. • Account 2520 provides funding for air circulation/chillers, oil and grease dispensers, and additional shelving. Fleet -99- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY GITY (lF UUBLIN.. Public Service /Engineering STATEMENT OF FUNCTIONS: Engineering provides services such as design review, pavement management, operation and maintenance of traffic signals, street lights, warning system, pump stations, drafting, surveying, civil project inspection, design, operation and maintenance of water distribution, storm and sanitary sewers, streams, retention and detention basins, oversight of City public improvements and consultation on proposed projects to various City departments. The City Engineer is charged with enforcing standards for all work in the public rights-of--way. This function reviews the engineering aspects of all development projects and provides significant support to Streets and Utilities, Parks and Recreation, and Facilities Management regarding the maintenance of City infrastructure. The City Engineer is called on to provide advice and information to City Council and the Planning and Zoning Commission. OBJECTIVES AND ACTIVITIES: • To maintain City infrastructure by establishing a maintenance program for sanitary and storm sewers, manholes, streets, curb and gutters, sidewalks, bikepaths, traffic signals, streams and ponds. • To oversee timely completion of City sponsored public improvement projects. • To ensure comprehensive, timely review of engineering drawings and plans for capital improvements, subdivisions and development related projects. • To coordinate with other governmental agencies in regard to issues such as pursuing federal and state grants, sewer, water and other applicable issues. To continue the implementation of the comprehensive stormwater maintenance and improvement program. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Engineering 1 c Engineering Manager 3 3 Civil Engineer 7 7 Engineering Assistant 3 1 Traffic Signal Technician 1 1 Electrical Worker 4 ~ 4 Engineering Project Coordinator 2 2 Engineering Project Inspector 4 6 ROW/Easement Survey Specialist 1 1 Landscape Architect 1 0 Administrative Assistant 1 1 Office Assistant I 1 2 Staff Assistant I 1 1 Office Assistant I (part-time) 1 0 Intern 1 0 TOTAL 32 30 NOTES AND ADJUSTMENTS: One Engineering Assistant position was changed to an Engineering Project Inspector and one Engineering Assistant position was eliminated. The Landscape Architect position has been transferred to Land Use & Long Range Planning. The Office Assistant I art-time) was changed to a full-time Office Assistant I. A Streets Crew Supervisor was transferred here as an Engineering Project Inspector and the Intern position was eliminated. Engineer -101- 12/ 11/06 2007 Budget -City of Dublin, Ohio General Fund Public Service Engineering 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget ~u 101-1330 Personal Services 2110 2111 2112 2120 2140 Salaries/V1/ages Overtime Wages Other Wages Employee Benefits Uniforms & Clothing 1,525,909 49,309 10,625 523,374 6,671 1,692,400 40,000 16,500 555,800 7,500 1,692,400 40,000 16,500 555,800 7,500 1,542,000 39,100 5,000 528,200 6,100 1,688,400 40,000 0 629,000 7,500 ti ' «~ 2,115,888 2,312,200 2,312,200 2,120,400 2,364,900 Other Expenses 2201 Conferences/Mileage 20,038 20,500 18,584 15,100 19,500 2211 Meeting Expenses 1,528 700 2,700 2,200 2,500 r 2320 Communications 17,412 25,000 27,068 23,850 21,900 2330 Rents/Leases 7,631 7,700 7,700 7,650 7,700 2346 Eng.lnspection 133,032 150,000 150,000 112,000 150,000 2348 Plan Review 19,403 40,000 40,000 5,000 40,000 2349 Other Professional Serv 429,752 221,500 335,390 320,000 217,500 2351 Maint. of Equipment 851 2,000 2,000 1,000 2,000 2380 Printing and Reproduction 8,318 13,500 13,500 5,500 10,000 2391 Memberships/Subscriptions 4,015 5,000 5,000 2,550 5,000 2410 Office Supplies 8,984 11,500 11,500 9,600 12,000 2420 Operating Supplies 8,474 8,500 8,500 7,600 8,500 2910 Refunds 0 0 0 0 0 659,438 505,900 621,942 512,050 496,600 Capital Outlay ~,. 2520 Equipment & Furniture 9,393 12,000 20,165 18,000 18,000 °- 9,393 12,000 20,165 18,000 18,000 ~' TOTALS $2,784,719 $2,830,100 $2,954,307 $2,650,450 $2,879,500 -102- ~~: Public Service /Engineering BUDGET SUMMARY: • Account 2110 includes funding for current and proposed positions as described. • Account 2211 includes funding for group meetings sponsored by the City. Funding is included for food, beverages, and associated supplies. • Account 2346 provides funding for inspection of construction materials by the City of Columbus, contract geo-technical testing services and contract inspection services. • Account 2348 provides funding for consultant and specialized plan review. • Account 2349 provides funding for consulting services, including surveying, the 2007 updates to the travel demand model, a professional critique of roundabout design, annual ground water monitoring, the National Pollution Discharge Elimination System (NPDES) permit fee and required public education and outreach, and traffic calming and signal warrant studies. There are also design costs associated with capital projects included in the CIP. • Account 2380 provides funding for printing contract documents and plans related to the City's capital improvement projects. • Account 2520 includes funding for two additional mylar cabinets, replacement task chairs, lateral file cabinet, typewriter, stove for 5800 Building, miscellaneous equipment needs. Engineer -103- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Public Service Miscellaneous 2005 2006 2006 2006 2007 } Actual Budget Revised Budget Estimate Budget 101-1339 Other Expenses 2310 Utilities 161,732 153,000 173,284 173,200 174 000 2430 Repair & Maintenance 57,151 90,000 96,240 90,000 , 135,000 218,883 243,000 269,524 263,200 309,000 ,. Capital Outlay ~e 2520 Equipment & Furniture 686 5,000 2,000 1,000 5,000 686 5,000 2,000 1,000 5,000 r TOTALS $219,569 $248,000 $271,524 $264,200 $314,000 -104- Public Service /Miscellaneous BUDGET SUMMARY: Account 2310 provides funding for electrical service to the City's streetlights and outdoor early warning siren system. . Account 2430 provides funding to purchase parts and supplies for the City's streetlights and outdoor early warning siren system. The 2007 budget includes funding for the upgrade of 1/4 of the City's sirens. Account 2520 funds equipment for street lighting and the outdoor early warning siren system. PubServMisc -105- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY ,, CITY OF I?Uli1.IN.. Public Service /Building Standards STATEMENT OF FUNCTIONS: Building Standards is under the administrative direction of the Director of Building Standards (Certified Building Official) who reports to the Director of Public Service. The primary responsibility of Building Standards is to ensure that all new construction, both commercial and residential, complies with all applicable state, local, and national building codes. OBJECTIVES AND ACTIVITIES: • To ensure that all new construction complies with all applicable state, local, and national building codes. • Perform plan reviews on applications; perform inspections, issue permits and issue certificates of occupancy. • Provide direction and communicate with the construction applicants and the public. • Provide timely information regarding levels and types of construction activity within the City to City departments, applicants, and the public. • Provide architectural support to city projects. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Building Standards 1 1 Commercial Plans Examiner 1 1 Building Inspector 4 4 Electrical Inspector 1 1 Electrical Inspector (part-time) 1 1 Residential Plans Examiner 1 1 Staff Assistant 1 1 Office Assistant II 4 4 Senior Building Inspector 1 1 TOTAL 15 15 NOTES AND ADJUSTMENTS Bldg -107- 12/ I 1 /06 2007 Budget -City of Dublin, Ohio General Fund Public Service Building Standards 2005 2006 2006 Actual Budget Revised Budget 006 Estimate 007 Budget 101-1340 Personal Services 2110 Salaries/Vlfages 774,040 820,600 819,100 808,000 860 900 2111 Overtime Wages 17,649 16,500 16,500 16 500 , 16 500 2112 .Other Wages 0 1,000 2,500 , 2,500 , 1 000 2120 Employee Benefits 268,980 274,625 274,625 264,400 , 310 850 2140 Uniforms & Clothing 1,841 2,500 2,500 2,000 , 2,500 1,062,510 1,115,225 1,115,225 1,093,400 1,191,750 "~' Other Expenses 2201 Conferences/Mileage 10,795 12,500 12,525 8,000 12 500 2211 Meeting Expenses 863 1,000 1,000 900 , 2 000 2320 Communications 5,129 6,550 8,664 7,550 , 5 950 2330 Rents/Leases 2,628 3,200 3,726 0 , 3 500 2347 Building Inspection Serv 152,466 187,500 203,248 120,000 , 187 000 2348 Plan Review 51,330 70,000 71,070 61,500 , 75 000 2349 Other Professional Serv 1,851 2,500 3,500 3,100 , 15 000 2351 Maint. of Equipment 2,335 3,000 3,636 3,500 , 1 000 2380 Printing and Reproduction 4,434 6,000 7,165 4,900 , 6 000 '~` 2390 Contractual Services 0 16,000 9,000 0 , 16 000 2391 Memberships/Subscriptions 1,591 2,000 2,000 1,700 , 2 500 2410 Office Supplies 8,044 10,500 13,940 6,700 , 10 500 ~~ 2420 Operating Supplies 7,292 9,000 9,534 5,900 , 9 000 2910 Refunds 8,070 7,500 13,500 12,000 , 12,500 256,828 337,250 362,508 235,750 358,450 Capital Outl ay 2520 Equipment & Furniture 2,614 5,000 5,000 3,600 5,000 2,614 5,000 5,000 3,600 5,000 TOTALS $1,321,952 $1,457,475 $1,482,733 $1,332,750 $1,555,200 ,~. -108- Public Service /Building Standards BUDGET SUMMARY: • Account 2140 includes apparel for seven inspectors, including boots, hats and gloves, one long sleeved shirt, and one short sleeved shirt which are replaced annually; and heavy winter coats, weather-resistant jackets and rain gear, rubber outer boots and a coverall suit which are replaced as needed. • Account 2320 funds long distance and mobile phone usage. • Account 2330 provides for lease of a copier. • Account 2347 includes funding for plumbing inspection services from the Franklin County Board of Health. Fees collected directly offset this expense. A higher than normal workload is anticipated due to increased commercial activity including construction of the hospital. • Account 2348 funds contract services needed to complement the plan review which is completed in-house. • Account 2349 provides funding for hiring an outside consultant for specific technical advice in conjunction with COIC. • Account 2390 funds outside temporary help if needed, to back-up in-house staff. Bldg -109- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CI't~c' nF I}UBLINL .. Land Use and Long Range Planning STATEMENT OF FUNCTIONS: Land Use and Long Range Planning was created in 2005 as part of citywide reorganization, and is administered by the Director of Planning. Land Use and Long Range Planning is responsible for the City's land use, planning, and zoning functions, including the enforcement of the Zoning Code, and serves as staff to several commissions. Activities relate to the following functional areas: review of development proposals; preparing/updating the Community Plan; project analysis; area studies; code enforcement; land use modeling and impact analysis; capital improvement programming and economic development support; code amendment preparation; and customer service operations (such as garage sale permits). OBJECTIVES AND ACTIVITIES: • To be responsive to citizens on planning issues and facilitating a citizen participation process. • To plan the orderly, high quality growth of the City by updating the Community Plan. • To assist economic development activities by providing land use/site design support. • To assist in the coordination and the implementation of the capital improvement program. • To manage development proposals through the public hearing process. • To administer development regulations. • To be responsive to City Council goals. • To ensure compliance with all orders of City Council, Planning Commission, Board of Zoning Appeals, Architectural Review Board, and various special subcommittees, task forces, and other groups. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Land Use & Long Range Planning 1 1 Planning Manager 1 1 Planner II 5 5 Planner I 5 5 Code Enforcement Supervisor 1 1 Code Enforcement Officer 2 2 Landscape Architect 0 1 Landscape Inspector 2 2 Development Review Specialist 3 3 Administrative Assistant 2 2 Office Assistant I 3 3 Office Assistant II 1 1 Planner I (part-time) 1 0 Planning Intern 6 6 Landscape Intern 1 0 TOTAL 34 33 NOTES AND ADJUSTMENTS: The Landscape Architect was transferred here from Engineering. Land Use -111- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Land Use/Long Range Plans Office of the Director 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1410 Personal Services 2110 Salaries/Wages 1,218,067 1,366,050 1,366,050 .1,220,000 1,457,200 2111 Overtime Wages 38,104 37,500 37,500 37,500 37,500 2112 Other W ages 112, 581 105,100 105,100 90,100 118,825 2120 Employee Benefits 444,101 478,900 478,900 450,000 563 300 ~~ 2140 Uniforms & Clothing 3,387 5,025 5,549 3,000 , 3,500 1,816,240 1,992,575 1,993,099 1,800,600 2,180,325 ~` Other Expenses 2201 Conferences/Mileage 28,375 31,400 33,460 30,200 34,000 2211 Meetin Ex enses 9 p 5,224 5,500 6,050 5,100 5,500 "' 2320 Communications 20,401 22,200 22,282 8,000 17,200 '~ 2330 Rents/Leases 21,597 27,800 30,351 26,600 27,200 2344 Planning Services 311,578 85,000 426,729 341,650 125,000 2349 Other Professional Serv 15,516 27,800 81,000 52,550 32,800 2351 Maint. of Equipment 10,672 15,400 16,805 15,100 8,075 2370 Advertising 1,006 7,500 7,500 6,200 0 2380 Printing and Reproduction 6,460 60,500 62,257 5,350 60,500 '~ 2390 Contractual Services 7,157 9,200 15,248 6,000 4,000 2391 Memberships/Subscriptions 9,624 9,000 11,397 8,000 9,000 2410 Office Supplies 7,643 13,200 15,714 10,700 10,500 2420 Operating Supplies 6,251 16,000 16,700 7,200 8,000 2830 Code Enforcement 7,209 10,400 11,634 10,050 8,000 . 2910 Refunds 7,040 11,000 11,000 5,100 11,000 ~' 465,753 351,900 768,127 537,800 360,775 Capital Ou tlay 2520 Equipment & Furniture 5,191 0 14,000 13,500 500 ,,_ r 5,191 0 14,000 13,500 500 TOTALS $2,287,184 $2,344,475 $2,775,226 $2,351,900 $2,541,600 -112- Land Use and Long Range Planning BUDGET SUMMARY: • Account 2110 and 2120 provide full-year funding for the current positions reflected under Personnel Data. • Account 2112 provides wages for interns. • Account 2201 includes funding for participating in the HTE Users Group conference, and for attendance at the American Planning Association conference. • Account 2211 provides funding for group meetings sponsored by the City. Funding is included for food, beverages, and associated supplies. • Account 2344 provides funding for Central Ohio Innovation Center consulting services and to revise various elements of the zoning code. • Account 2349 includes consulting and other services. • Account 2380 includes funding for printing of the updated Community Plan. • Account 2390 provides funding for temporary clerical services as needed. • Account 2420 includes funding for photography and presentation materials. • Account 2830 provides funding to resolve code enforcement problems. Land Use -113- 12/11/06 ~~,. THIS PAGE LEFT BLANK INTENTIONALLY CITY OF I?UBLIIV.. ,~: Parks and Recreation/ Parks and Open Space STATEMENT OF FUNCTIONS: The City of Dublin takes pride in providing its residents and visitors the highest quality public parks to pursue their active and passive outdoor needs. Parks strives to be both environmentally and economically sound in its management of public areas including parks, gateways and rights-of--way. By staff establishing and adhering to the highest standards, each user will be assured the proper environment for their enjoyment. OBJECTIVES AND ACTIVITIES: • To provide residents and visitors with the highest quality of public lands that is aesthetically pleasing and functionally sound. PERSONNEL DATA POSITION TITLE 2006 CURRENT NUMBER 2007 ADOPTED Director, Parks and Open Space 1 1 City Horticulturist 1 1 City Forester 1 1 Landscape Architect 1 1 Contract Specialist 0 1 Operations Administrator 1 ~ 1 Crew Supervisor 7 7 Maintenance Worker 20 20 Assistant Horticulturist 5 5 Assistant Forester 4 5 Office Assistant II i 1 Administrative Assistant 1 1 Nature Education Coordinator 1 1 Seasonal Maintenance Worker 41 41 Office Assistant Useasonal 1 0 Office Assistant I (part-time) 0 1 Interns 1 1 TOTAL 87 89 NOTES AND ADJUSTMENTS: A Contract Specialist and Assistant Forester were added. A seasonal Office Assistant I was changed to an Office Assistant I (part-time). Parks -115- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Parks and Recreation Parks and Open Space 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1620 '"' Personal Services 2110 Salaries/Wages 1,938,299 2,105,900 2,105,900 1,966,800 2 236 950 2111 Overtime Wages 100,858 100,000 105,000 105,000 , , 100 000 2112 Other Wages 450,878 545,300 545,300 470,900 , 489 250 2120 Employee Benefits 842,750 894,650 894,650 865,800 , 1 001 100 2140 Uniforms & Clothing 73,305 106,500 107,603 65,000 , , 66,600 3,406,090 3,752,350 3,758,453 3,473,500 3,893,900 ~" Other Expenses 2201 Conferences/Mileage 27,480 42,725 42,760 32,000 42 500 2310 Utilities 128,817 137,000 160,522 142,900 , 152 000 2320 Communications 17,322 12,850 25,258 21,600 , 11 250 "' 2330 Rents/Leases 6,945 11,850 13,337 12,150 , 8 100 2351 Maint. of E ui ment q P 1,775 800 1,077 1,000 , 500 '~- 2390 Misc Contractual Services 695,355 878,750 901,166 781,900 984 700 '" 2391 Memberships/Subscriptions 4,736 5,600 5,600 5,000 , 7 600 2410 Office Supplies 8,052 9,450 11,803 9,150 , 9 750 2420 Operating Supplies 58,154 67,650 74,255 55,750 , 67 400 '~ 2421 Reforestation 29,436 0 98,395 87,150 , 0 2428 Special Events 6,214 7,875 9,014 8,200 8,000 2432 Park Maintenance 209,248 210,000 224,788 213,850 281,350 `'" 2433 Equipment Maintenance 41,933 98,525 ~ 108,199 76,000 153 350 2440 Small Tools & Minor Equip 19,150 23,350 26,843 20,300 , 475 20 2812 Special Projects/Programs 7,939 5,475 5,475 4,100 , 11,150 1,262,556 1,511,900 1,708,492 1,471,050 1,758,125 Capital Ou tlay 2510 Land & Land Improvements 161,670 187,900 217,949 160,000 192 600 ~.~. 2520 Equipment & Furniture 98,301 94,125 98,463 88,300 , 100,550 259,971 282,025 316,412 248,300 293,150 TOTALS $4,928,617 $5,546,275 $5,783,357 $5,192,850 $5,945,175 ~. ~- -116- Parks and Recreation/ Parks BUDGET SUMMARY: • Accounts 2110 and 2120 include funding for staffing which includes an additional Assistant Forester and Contract Specialist. Funding also includes transferring a Seasonal Office Assistant I to a permanent part- time Office Assistant I. • Account 2310 provides funding for electricity, natural gas and water and sewer charges for services provided in the City's parks. • Account 2320 provides funding for pay phones in the parks, cellular phones, and local and long-distance telephone charges. • Account 2330 provides funding for copier leases and miscellaneous equipment rental. • Account 2390 provides funding for contractual services for arborist work, rights-of--way maintenance, mulching, plant replacement and addition for "groomed" rights-of--way and other miscellaneous areas. • Account 2432 provides funding for all soil amendments, sod, grass seed, mulch, fertilizer and chemicals. • Account 2433 provides funding for equipment maintenance and parks maintenance equipment, including work associated with Ballantrae water play area, pond aerators, and irrigation systems. • Account 2510 includes funding for tree replacement for various subdivisions, plant materials, bike path mitigation, and additional pond aerators. • Account 2520 includes funding for additional irrigation wheel, park furniture, two-way radios, seeder, rototiller, chemical sprayer, and concrete mixer. • Account 2812 provides funding for Civic Beautification Awards Program and Arbor Day celebration, Nature Education, and Green Team plantings. Parks -117- 12/ 11 /06 ~. ~: THIS PAGE LEFT BLANK INTENTIONALLY CITY flF UUBLIIV_ ~, ~. Economic Development STATEMENT OF FUNCTION: This function is administered by the Deputy City Manager/Director of Economic Development who reports directly to the City Manager. The function is responsible for the implementation of the City's economic development program and strategy. The Director is responsible for the development and implementation of local business attraction, retention, and expansion programs; coordination of activities with various private and public organizations involved in local and regional economic development; the integration of local economic development objectives with broader community planning policies and goals; provide project management to expedite permit coordination and plan review for targeted commercial development projects; serve as the City's housing officer, implement business development activities; maintain involvement with community organizations; administer City's incentive programs; and serve as a local business ombudsman to assist with development issues and help ensure quality development within the City. OBJECTIVES AND ACTIVITIES: • To provide an ongoing business retention and expansion program. • To ensure timely permitting of private improvements and facilitate project completion. • To build local partnerships. • To provide direction and cultivate positive community image. • To research, develop, and implement new methods and procedures to strengthen and improve relations with the development community. • To continue to implement the goals and objectives identified. in the Community Plan and the Economic Development Strategy. • To assist the City Manager with special projects. • To promote the orderly high quality growth of the City. • To interact with other government agencies. PERSONNEL DATA POSITION TITLE 2006 2007 CURRENT NUMBER ADOPTED Director, Economic Development/Deputy City Mgr Administrative Specialist Economic Development Administrator TOTAL 1 1 1 1 1 1 3 3 NOTES AND ADJUSTMENTS: EcoDev -119- 12/ 11 /06 <: 2007 Budget -City of Dublin, Ohio General Fund Economic Development Office of the Director 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget w 101-1710 .~ Personal Services 2110 Salaries/VNages 184,271 141,100 141,100 133,000 2111 Overtime Wages 17 2,500 2,500 1,500 2120 Employee Benefits 60,047 55,400 55,400 55,000 230,350 1,000 76,425 Other Expenses 244,335 199, 000 199,000 189, 500 307,775 2201 Conference/Mileage 173 4,500 4,500. 500 3,500 2210 Reimbursable Business Exl 1,037 3,000 3,000 100 3,000 ~" 2211 Meeting Expenses 11,771 7,000 7,225 4,550 18 500 2320 Communications 3,451 1,800 3,766 2,400 , 1,400 ,~, 2349 Professional Services 66,749 185,000 246,246 82,750 190,000 2380 Printing & Reproductions 4,069 10,000 10,000 2,500 10,000 2391 Memberships/Subscriptions 4,521 11,175 11,175 5,400 21,050 ; 2410 Office Supplies 592 1,200 1,475 500 1,200 2822 Economic Development 208,307 547,000 347,210 303,400 633 400 2825 Economic Dev Incentives 1,194,934 2,066,550 2,505,550 2,362,200 , 2,600,000 , 1,495,604 2,837,225 3,140,147 2,764,300 3,482,050 Capital Ou tlay 2520 Equipment& Furniture 2,207 1,500 1,500 1,200 1,500 '~"` 2,207 1,500 1,500 1,200 1,500 TOTALS $1,742,146 $3,037,725 $3,340,647 $2,955,000 $3,791,325 -120- ~. Economic Development BUDGET SUMMARY: • Account 2210 includes funds for business meeting expenses for luncheons with developers, business leaders, prospective industries, etc. • Account 2211 provides funding for group meetings sponsored by the City, including the 2007 Health, Innovation & Technology Outlook. • Account 2349 includes funding for consultation related to economic development, the continued implementation of the WiFi project and fiber expansion, telecommunications engineering and to explore extension of electric and gas aggregation to small businesses. • Account 2380 funds printed project and marketing materials and event invitations for economic development. • Account 2822 includes funds to support economic development programs including regional outreach, economic outlook, business attraction, retention and expansion; along with regional and joint partnerships. This account also includes expenses associated with the WiFi Agreement and right-of- way acquisition and maintenance of DubLINK. • Account 2825 reflects economic development incentives that are part of this program. Ecodev -121- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITY ~F DUBLIN_ Administrative Services /Office of the Director STATEMENT OF FUNCTIONS: Administrative Services, created in 2005, provides direction and oversight to Court Services, Information Technology, Facilities Management and Volunteer Services. OBJECTIVES AND ACTIVITIES: • To provide leadership and direction to the staff within Information Technology, Volunteer Services, Court Services and Facilities Management. • To ensure the City's goals and objectives are reached in each of the functional areas in an efficient, effective and responsive manner. • To provide appropriate learning and development opportunities to employees and employee teams. • To provide citywide special project support as needed. • To provide support to the Community Services Advisory Commission. • To provide a comprehensive, citywide volunteer program, to allow citizens an opportunity for meaningful service within their community. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Administrative Services 1 1 Volunteer Administrator 1 1 Administrative Specialist I 1 Administrative Assistant 1 1 Intern 1 1 TOTAL 5 5 NOTES AND ADJUSTMENTS: AdminServ -123- i 2/ I 1 /06 2007 Budget -City of Dublin, Ohio , General Fund "" Administrative Services Office of the Director 2005 2006 2006 2006 2007 , Actual Budget Revised Budget Estimate Budget 101-1910 n. Personal Services 2110 Salaries/V1/ages 239,481 251,150 251,150 245,000 262,650 2111 Overtime Wages 3,100 3,000 4,100 4,000 4,500 ' 2112 Other Wages 4,573 6,725 5,625 5,200 6,725 2120 Employee Benefits 65,170 67,150 67,150 66,750 73,200 2140 Uniforms & Clothing 0 200 200 200 200 312,324 328,225 328,225 321,150 347,275 Other Expenses 2201 Conference/Mileage 5,655 5,500 6,000 5,500 5,500 2211 Meeting Expenses 686 1,250 750 500 1,350 2320 Communications 2,182 3,825 4,166 3,200 3,850 2330 Rents/Leases 0 1,000 1,000 0 1,000 2349 Professional Services 0 5,000 9,500 9,100 5,000 2370 Advertising 0 0 0 0 600 '~" 2380 Printing & Reproductions 3,077 11,550 11,550 3,900 7,900 , 2390 Misc Contractual Services 1,000 0 0 0 0 2391 Memberships/Subscriptions 2,685 2,500 2,600 1,200 2,500 2410 Office Supplies 1,334 2,500 2,790 2,000 2,500 , 2420 Operating Supplies 0 2,500 2,500 1,400 2,000 2812 Special Projects/Programs 13,581 17,500 17,600 10,200 12,800 ~' 30,200 53,125 58,456 37,000 45,000 Capital Outlay ~., 2520 Equipment & Furniture 0 0 0 0 800 du 0 0 0 0 800 TOTALS $342,524 $381,350 $386,681 $358,150 $393,075 -124- Administrative Services /Office of the Director BUDGET SUMMARY: • Account 2110 reflects funding for staffing as outlined under "Personnel Data" for Administrative Services and Volunteer Services. • Account 211 ] provides funding for overtime to oversee volunteer activities, staffing special events and staffing Community Services Advisory Commission (CSAC) meetings. • Account 2112 provides funding for one Intern. • Account 2140 provides funding for staff shirts for volunteer and special events. • Account 2201 provides funding for professional conferences, training and development. • Account 2211 provides funding for special event supplies and community service site meetings, meeting/training supplies and attendance at monthly professional organization meetings. • Account 2320 is for cellular phones usage fees/accessories/replacement, long distance telephone charges, express mail and courier services. • Account 2349 provides funding for strategic business plan development and 360° evaluations. • Account 2370 is for news advertising for volunteers and events. • Account 2380 provides funding for printing including forms, photography, training manuals, signage and posters, badges, cards and specialty papers, and miscellaneous printing/copying needs. • Account 2420 is for volunteer shirts as well as miscellaneous operating supplies. • Account 28 ] 2 provides funding for recognition presentations and programs, teen program support, recognition and awards items, volunteer on-site event management needs, and employee appreciation/recognition. AdminServ -125- 12/ 1 l /06 THIS PAGE LEFT BLANK INTENTIONALLY ,~ errs ~F ~tJS~N_ Administrative Services /Information Technology STATEMENT OF FUNCTIONS: The administration of the City's information technology is the responsibility of the Director of Information Technology (IT). This involves planning, maintaining, developing, overseeing and managing the City's local area and wide area networks, the IBM iSeries (AS/400) Systems, all personal computers, the citywide telephone system, and any other technology related issue. IT must also enhance and promote the utilization of technology so that city operations realize the benefits of using technology as a tool. The goal of Information Technology is to improve productivity, improve decision-making, increase staff and citizen safety, and to enhance services to the entire Dublin community. This function continues to grow with the expectation that the functional responsibilities will continue to expand as a result of continued employment growth and the rapidly changing world of technology. OBJECTIVES AND ACTIVITIES: • Provide vision, leadership and direction for evaluating and re-evaluating current and emerging technologies and implementing cost-effective technology solutions. • Enhance services to the entire Dublin community through the appropriate and proactive use of technology. • Provide a reliable infrastructure/network to effectively and efficiently use technologies. • Provide timely and efficient technical support to all work units. • Become business partners with work units by assisting them in operational improvements, through an understanding of their business processes and needs and managing the implementation of technology solutions to meet those needs. • Provide comprehensive project management services for implementing technology solutions, including procurement, contract negotiations, professional services, software integration and project status reporting. • To provide technology solutions that meet overall City objectives. • Develop and retain motivated, competent staff to meet these business objectives. PERSONNEL DATA POSITION TITLE 2006 2007 CURRENT NUMBER ADOPTED Director, Information Technology 1 1 Information Technology Project Leader 3 3 Network Operations Manager I 1 Network Administrator 1 1 Information Technology Analyst 2 2 Geographic Information Systems Coordinator 1 1 Administrative Assistant I 1 GIS Analyst 2 2 Intern (GIS / PC Analyst) 1 1 TOTAL 13 13 NOTES AND ADJUSTMENTS: InfoTec -127- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Administrative Services Information Technology 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 101-1920 ,-., Personal Services ,, 2110 Salaries/Wages 683,727 758,025 748,025 658,700 751,150 , 2111 Overtime Wages 18,250 18,000 18,000 13,500 18,000 2112 Other Wages 3,083 10,000 20,000 5,500 10,000 ..,. 2120 Employee Benefits 218,235 237,825 237,825 190,000 260,700 923,295 1,023,850 1,023,850 867,700 1,039,850 w .~ Other Expenses 2201 Conference/Mileage 46,763 62,500 90,003 75,000 62,500 ~¢ 2320 Communications 177,611 231,100 236,220 160,000 221 300 2349 Professional Services 168,163 228,125 313,737 150,300 , 323,375 2351 Maint. of Equipment 450,129 591,650 613,798 523,600 597,150 2391 Memberships/Subscriptions 5,660 5,500 5,500 2,800 5 500 2410 Office Supplies 6,669 10,500 13,840 9,300 , 10,000 , 2420 Operating Supplies 7,100 14,850 27,679 25,000 25,000 862,095 1,144,225 1,300,777 946,000 1,244,825 Capital Outlay ~' 2520 Equipment & Furniture 836 2,000 4,458 3,550 2,000 ~. ~: 836 2,000 ~ 4,458 3,550 2,000 TOTALS $1,786,226 $2,170,075 $2,329,085 $1,817,250 $2,286,675 ~: ,. ., -128- Administrative Services /Information Technology BUDGET SUMMARY: • Account 2320 includes funds for citywide local phone usage, long-distance telephone charges, communication fees for the Internet, cellular phones, monthly citywide fees for telephone service, and mobile computing fees for Police and Building Standards, Code Enforcement, Engineering, and Streets & Utilities. • Account 2349 provides for computer consulting services for the implementation of new applications; to enhance present application usage; and for special projects when specific expertise is desired and/or to augment the staffing assignments due to workload. There is an increase in professional services due to the planned implementation of three major systems -citywide Work Orders /Asset Management, HR Management, and the Citizen Request Management (CRM). • Account 2351 provides funding for hardware and software maintenance fees- • Account 2520 provides funding for office storage and office chairs. InfoTec -I29- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY ' ~ CITY OF BUBLIN_ Administrative Services /Court Services STATEMENT OF FUNCTIONS: Court Services serves as the judicial branch of the City. Court Services is responsible for monitoring all court operations including the collection of fines, preparing the court docket, and for processing all criminal and traffic citations. As a sentencing alternative, Adult Probation, Adult and Juvenile Diversion, Juvenile Traffic Diversion, and Provided No Conviction programs are offered. Court Services is also responsible for implementing and operating the City's Records Management Program, which includes both on and off-site central storage, microfilming and optical imaging. OBJECTIVES AND ACTIVITIES: • To enforce court orders. • To maintain high levels of accuracy on all court records. • To effectively administer the adult probation, adult and juvenile diversion, juvenile traffic diversion, and the provided no convictions programs. • To eliminate unnecessary time delays in scheduling adult probation cases, diversion cases and in processing court documents. • To effectively monitor all sentencing alternatives cases for compliance with court orders. • To maintain harmonious relations between the Mayor, the prosecutors, the Police and the court staffin order to better serve the public. • To maintain secure and orderly courtroom operations. • To provide information and outreach about the criminal justice system to the public. PERSONNEL DATA POSITION TITLE Court Administrator (2) Probation Officer Diversion Officer Court Clerk Records Management Technician (1) Staff Assistant (3) Community Justice Officer Community Justice Officer (Part-time) TOTAL 2006 2007 CURRENT NUMBER ADOPTED 0 1 0 2 2 1 1 1 1 0 1 0 1 7 7 NOTES AND ADJUSTMENTS: A portion of the salaries for the Mayor and Vice-Mayor is allocated to the Court Services budget. Court ~" Services also performs the additional duties of Records Management to comply with conditions set forth in the Ohio Revised Code. Salaries, wages and benefits have been allocated to Court Services and Records Management for each position as follows: (1) allocates one hundred percent (100%) to Records Management, (2) allocates fifty percent (50%) to Court Services and fifty percent (50%) to Records Management and (3) allocates seventy-five percent (75%) to Court Services and twenty-five percent (25%) to Records Management. The titles for the Probation Officer and the Diversion Officer have been changed to fulltime and parttime Community Justice Officers. AdmCourt - 131- 12/ 11 /06 2007 Budget -City of Dublin, Ohio ~$. General Fund w- Administrative Services Court Services 2005 2006 2006 2006 2007 „~; Actual Budget Revised Budget Estimate Budget 101-1930 Personal Services 2110 Salaries/Wages 263,015 277,200 277,200 256,000 2111 Overtime Wages 4,401 3,600 3,600 3,100 2120 Employee Benefits 103,289 104,500 104,500 98,000 370,705 385,300 385,300 357,100 Other Expenses 2201 Conference/Mileage 7,466 7,500 7,500 7,400 2320 Communications 2,792 5,300 5,300 2,650 2330 Rents/Leases 2,530 2,750 3,210 3,000 2345 Legal Services 1,682 2,125 2,345 2,300 2349 Professional Services 59,628 64,500 70,331 45,000 2351 Maint. of Equipment 761 900 1,053 1,000 2390 Misc Contractual Services 6,339 12,300 12,349 7,500 2391 Memberships/Subscriptions 1,111 900 900 800 2410 Office Supplies 16,696 4,500 5,630 4,800 2420 Operating Supplies 0 12,900 12,900 6,150 2820 Probation Supplies 0 500 500 0 2910 Refunds 32 100 100 100 99,037 114,275 122,118 80,700 250,400 3,600 '" 98,350 352,350 7,000 4,500 "~` 2,975 2,125 64,500 900 12,000 900 ~" 4,500 12,900 500 ~" 100 112,900 ~:. 2,500 Capital Outlay 2520 Equipment & Furniture 1,729 3,050 3,050 2,850 __ ~. 1,729 3,050 3,050 2,850 2,500 TOTALS $471,471 $502,625 $510,468 $440,650 $467,750 -132- Administrative Services /Court Services BUDGET SUMMARY: • Account 2110 and 2120 budgets for the allocations identified under Notes and Adjustments. • Account 2201 includes training funds allocated to all court staff except the Records Management Technician position. This account also includes funds for Mayor and Vice Mayor required Couri training. • Account 2345 provides funding for services provided by the Delaware County Prosecutor's office and the Franklin County Public Defenders office. • Account 2349 includes funds for prisoner boarding and medical services at the Franklin County Jail, the City's share of the Franklin County Municipal- Court's operational costs, interpreter's fees, and fees for use of a magistrate, as needed. • Account 2390 provides funding for credit card payment processing fees, witness fees, checking account fees and the yearly microfiche docketing project. • Account 2420 provides funding for specific supplies that are necessary to court operations like probation forms, court pockets, citations and criminal complaint forms. • Account 2820 includes costs for participants' workbooks for educational programs. Participants will reimburse the City for the cost of workbooks. This account also includes funding for drug testing kits and related supplies. • Account 2520 provides funding for an overhead for the Community Justice Officer's office and a wall mounted storage cabinet for office supplies. AdmCourt -133 - 12/1 U06 .n THIS PAGE LEFT BLANK INTENTIONALLY ,~ CI1Y flF I?UBLIN.. ~.. Administrative Services /Records Management STATEMENT OF FUNCTIONS: Records Management was established to maintain efficient methods for storage and retrieval of documents and to eliminate the unnecessary retention of obsolete records. As part of Records Management, a central storage facility was created to reduce the amount of "prime" office space being utilized by active and inactive records. Operated by Court Services, the central storage facility allows for active and inactive records to be examined, archived andlor scheduled for destruction in accordance with the procedures established in the Ohio Revised Code and standards accepted by the City of Dublin Records Commission. Records Management also supervises the micro- imaging of permanent records as well as electronically imaging documents for more efficient storage and multiple user access. OBJECTIVES AND ACTIVITIES: Records Management • To continue to develop and implement Records Management policies to provide consistency in maintaining records for the City of Dublin. • To continue to micro-image permanent documents for archival and historical purposes. • To effectively administer a central storage facility for archival of active and inactive records and the scheduled destruction of obsolete records. • To assist all city divisions in maintaining their records in accordance with Ohio Revised Code and standards accepted by the City of Dublin Records Commission. • To continue the implementation of an integrated citywide document imaging project. NOTES AND ADJUSTMENTS: Court Services administers Records Management for the City. The following reflects the estimated percentage of services allocated for both Court Services and Records Management for each position: the Records Management Technician allocates 100% of their time to Records Management; the Director of Couri Services allocates 50% of their time to Records Management, and the Administrative Assistant allocates 25% of their time to Records Management. Records Mgmt -I35- 12/11/06 2007 Budget -City of Dublin, Ohio General Fund Administrative Services Records Management 2005 2006 2006 2006 2007 ~.. Actual .Budget Revised Budget Estimate Budget 101-1931 Personal Services 2110 Salaries/V1lages 80,078 85,400 85,300 71,400 80,700 ~µ 2111 Overtime Wages 13 0 100 100 250 "` 2120 Employee Benefits 31,105 32,550 32,550 30,100 35,250 ~_ 111,196 117,950 117,950 101,600 116,200 „~ Other Expenses ~" 2201 Conference/Mileage 0 500 500 0 3,500 2349 Professional Services 34,204 75,000 77,754 48,600 90,000 ~' 2351 Maint. of Equipment 3,361 3,600 3,600 3,500 3,750 ,,,~ 2390 Misc Contractual Services 5,399 8,300 11,140 9,100 8,300 2391 Memberships/Subscriptions 0 500 500 350 500 `~`t 2410 Office Supplies 1,244 2,450 3,052 1,100 2,450 ,: 44,208 90,350 96,546 62,650 108,500 Capital Outlay 2520 Equipment & Furniture 0 500 500 0 500 0 500 500 0 500 TOTALS $155,404 $208,800 $214,996 $164,250 $225,200 ~~ -136- Administrative Services /Records Management BUDGET SUMMARY: 101-1931 • Account 21 I 0 and 2120 includes funding for the percentage of time allocated to Records Management by the Court Services staff. • Account 2201 provides funding for training of additional personnel for city wide document imaging. • Account 2349 includes funding for the purpose of microfilming hard copy documents. It also includes funds for document imaging of hard copy documents as needed. This account shows a significant increase due to the expansion of the document imaging project. • Account 2351 provides funding for maintenance contracts for a copier and three microfilm readers. • Account 2390 includes funding for off-site records storage and retrieval of all computer back-up tapes, microfilmed originals and historical paper documents, and on-site records destruction. Records Mgmt -137- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY e~r~~ c~F nuat~ti.. w Administrative Services /Facilities STATEMENT OF FUNCTIONS: Facilities protects the City's investment in public buildings by insuring that both the appearance and functions are preserved. This is accomplished by adhering to proper preventive maintenance programs, performing repairs in a professional manner and as quickly as possible, maintaining a save and clean environment for building occupants and visitors, and by seeking the most efficient utilization of space and energy resources. OBJECTIVES AND ACTIVITIES: • To establish and implement a proactive preventive maintenance program. • To perform regular inspections of City facilities and equipment. • To provide custodial services in City facilities. • To perform repairs to equipment and facility components. • To provide oversight for facility construction and renovation projects. • To perform citywide space needs evaluation, planning and design. • To perform set-up and breakdown of space for certain activities held in City facilities, including parks and outdoor pools. PERSONNEL DATA POSITION TITLE Facilities Manager Operations Administrator Crew Supervisor Maintenance Worker Custodians Office Assistant II Seasonal Maintenance Worker Office Assistant I /seasonal TOTAL NOTES AND ADJUSTMENTS: 2006 2007 CURRENT NUMBER ADOPTED 6 5 10 6 0 1 27 24 Reduction in seasonal maintenance workers reflects the expanded use ofprivate vendors for weekend custodial services. Facilities -139- 12/ 11 /06 2007 Budget -City of Dublin, Ohio ~~- General Fund Administra tive Services Facilities Management 2005 2006 2006 2006 2007 ~~ Actual Budget Revised Budget Estimate Budget 101-1940 Personal Services 2110 Salaries/Vllages 633,848 769,250 769,250 726,000 817,200 2111 Overtime Wages 43,708 34,000 64,000 64,000 35,000 2112 Other Wages 97,897 128,800 98,800 91,200 94,350 2120 Employee Benefits 286,679 347,100 347,100 323,000 368,175 2140 Uniforms & Clothing 17,078 21,475 25,157 12,800 19,400 1,079,210 1,300,625 1,304,307 1,217,000 1,334,125 Other Expenses 2201 Conference/Mileage 6,663 8,500 8,500 7,000 8,500 ,~ 2211 Meeting Expenses 0 150 150 100 150 2310 Utilities 330,333 452,525 486,860 346,000 400,600 2320 Communications 4,796 11,450 13,381 5,500 10,350 2330 Rents/Leases 3,453 4,700 5,500 4,900 4,700 2350 Maint. of Facilities 121,424 121,500 132,444 90,700 126,500 2390 Misc Contractual Services 181,504 211,050 247,178 185,000 246,200 2391 Memberships/Subscriptions 251 1,500 1,500 600 1,300 ~~ 2410 Office Supplies 3,514 4,900 6,458 3,700 4,300 2420 Operating Supplies 134,146 133,675 154,994 132,700 137,025 2440 Small Tools & Minor Equip 4,773 5,300 5,300 2,400 5,300 790,857 955,250 1,062,265 778,600 944,925 Capital Outlay 2520 Equipment & Furniture 2,833 1,200 17,367 16,050 1,000 ~~~ 2530 Bldgs. & Other Structures 29,224 13,150 13,500 6,900 34,625 32,057 14,350 30,867 22,950 35,625 TOTALS $1,902,124 $2,270,225 $2,397,439 $2,018,550 $2,314,675 ~,. -140- Administrative Services !Facilities BUDGET SUMMARY: • Accounts 2110 provides funding for wages and salaries for Facilities staff. • Account 2111 provides funding for overtime wages to provide staff coverage for maintenance projects, emergency call-ins and special events. • Account 2112 provides funding for six seasonal workers and a seasonal office assistant I. • Account 2310 provides funding for electricity, natural gas and water and sewer charges for City facilities with the exception of the Community Recreation Center. • Account 2320 provides funding for cellular phones and pagers, all long distance phone charges, postage for the Service Center mail meter, and funds for express mail and courier services. • Account 2330 provides funding for the Service Center postage meter and miscellaneous rental equipment. • Account 2350 includes funding for ongoing general maintenance of City-owned facilities. The increase reflects an anticipated rise in certain material costs. • Account 2390 includes funding for preventive maintenance contracts for systems and services throughout City-owned facilities and cleaning services for carpet, resilient flooring and upholstery. Included this year is funding for contract custodial services in the parks on weekends. • Account 2410 provides funding for office supplies and postage meter supplies. • Account 2420 includes funding for custodial and maintenance supplies. • Account 2440 includes hand tools, ladders, and vacuum sweepers. • Account 2520 provides funding for one radio and charger. • Account 2530 provides funding for specific facility renovation/repair projects that are smaller in scope than projects funded in the Capital Improvement Program. Facilities -141- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CIT~~ i?F UUI3LIh~ ~• ~r z Public Service /Streets and Utilities STATEMENT OF FUNCTIONS: Streets and Utilities is the direct responsibility of the Director of Streets & Utilities, who reports to the Director of Public Service. The Street Maintenance program involves the maintenance, repair and improvement of all City streets, including the state highways. Snow plowing and street salting are charged to this program. Programs include mosquito control and guardrail repair/replacement and support to special events. OBJECTIVES AND ACTIVITIES: • Actively pursue cost comparisons between in-house staff and outsourcing. • Provide well-maintained streets and rights-of--way ensuring safe travel and enhancing the beauty of our City. • Clean all city streets four times per year to enhance the neighborhoods and construction areas. • Plan, coordinate, and execute all special events activities in a professional and economical manner. • Continued development of a comprehensive inspection procedure for catch basins, manholes, guardrails, vegetation control, trash, signage, and pavement conditions. • Actively pursue re-accreditation with the American Public Works Association to ensure exceptional city services are being provided by utilizing efficient and effective processes. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Director, Streets and Utilities I 1 Assistant Director of Streets & Utilities 1 0 Operations Administrator 0 1 Crew Supervisor 4 3 Maintenance Worker 16 15 Seasonal Maintenance Worker I 1 7 Administrative Assistant 1 1 Office Assistant II 2 1 Office Assistant I (part-time) 1 0 Office Assistant I /seasonal 0 1 TOTAL 37 30 NOTES AND ADJUSTMENTS: The Assistant Director of Streets and Utilities has been reclassified as an operations administrator. 50% of the Director and 3.2% of crew supervisors are allocated here. One maintenance worker and three seasonal maintenance workers were transferred to the solid waste budget. One parftime office assistant I was transferred to the fleet maintenance budget and reclassified to a fulltime office assistant II.One office assistant II was transferred to the solid waste budget. One seasonal maintenance worker position was utilized to fund the seasonal office assistant I. StreetMt -143- 12/ 11 /06 2007 Budget -City of Dublin, Ohio Street Maint & Repair Public Service Streets and Utilities 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 210-1320 .~:. Personal Services 2110 Salaries/W ages 1,049,510 1,069,000 1,079,000 1,068,700 1,088,125 ` 2111 Overtime Wages 71,854 115,600 110,600 97,250 100,000 2112 Other Wages 114,983 191,000 181,000 150,150 124,500 ~' 2120 Employee Benefits 453,508 474,800 479,800 450,700 472,075 2140 Uniforms & Clothin 9 31,405 40,250 44,660 33,200 31,250 ~,.. 1,721,260 1,890,650 1,895,060 1,800,000 1,815,950 Other Expenses >;: 2201 Conferences/Mileage 17,843 26,500 26,500 15,900 26 500 2302 Repair Services 21,231 47,250 59,506 33,350 , 32 500 2320 Communications 17,517 8,800 13,800 12,850 , 10 950 .~. 2330 Rents/Leases 23,116 40,900 42,389 29,150 , 40,400 2349 Other Professional Serv 32,916 50,000 53,552 30,900 92 000 2351 Maint. of Equipment 5,583 20,375 21,266 20,000 , 17 500 „~ 2391 Memberships/Subscriptions 1,486 1,725 1,725 1,725 , 800 "~' 2410 Office Supplies 4,236 6,000 6,081 5,500 8 000 2420 Operating Supplies 117,210 181,250 206,705 102,500 , 156 100 2422 Street Salt 402,311 355,200 617,862 400,000 , 400 900 "' 2428 Special Events 22,388 24,000 24,945 16,200 , 53,500 2440 Small Tools & Minor Equip 8,586 23,000 23,000 13,300 13,250 674,423 785,000 1,097,331 681,375 852,400 Capital Outlay ~~ ,. 2520 Equipment & Furniture 2,451 8,000 8,000 3,000 27,450 "` 2,451 8,000 8,000 3,000 27,450 TOTALS $2,398,134 $2,683,650 $3,000,391 $2,484,375 $2,695,800 ,;~. ,~, -144- Public Service /Streets and Utilities BUDGET SUMMARY: • Account 2201 includes funding for training in the following areas: OHSA, vector control, equipment operation, snow removal, concrete and asphalt repair, and traffic control. • Account 2302 provides funding for mailbox repairs, and other emergency street and drainage repairs. • Account 2320 provides funding for long-distance telephone charges and cellular phones. • Account 2330 includes funding for the rental of an additional front end loader during snow season, other equipment rentals necessary in operations, the DTN weather monitoring system, and copier leases. • Account 2349 includes funding for herbicide control, street sweeping, lab tests, animal control, and the repairs of guardrails. In addition, this account provides funding for costs associated with American Public Works re-accreditation including fees, site visits, and meals. • Account 2391 includes funding for memberships in the following organizations: American Public Works Association, Ohio Certified Public Manager's Association, and Ohio City Manager's Association. • Account 2420 includes funding for operating supplies such as cold mix, hot mix, gravel, liquid calcium, curb and catch basin repair supplies, construction materials, and mosquito control chemicals. • Account 2422 provides funding for the City's annual purchase of street salt; the budget is based on the purchase of approximately 8,000 tons of salt. • Account 2428 includes funding for special event materials such as gravel, pipe, barrier walls, free standing fencing, and meal provisions. • Account 2440 includes. funding for miscellaneous vector control, traffic control, weed eaters, and hand tools. • Account 2520 includes funding for hand held radios, cell phones, cones, barrels, bamcades, and liquid dispensing systems for salt trucks. StreetMt -145- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CITY {)F DL~IiL1N.. Public Service /Engineering STATEMENT OF FUNCTION: This program, formerly a function of Streets and Utilities, is responsible for installing, repairing, and maintaining all street name signs and traffic control signs within the publicright-of--way, and maintaining all pavement markings such as crosswalk lines, stop bars, center lines and school zone markings. Also included within this unit is traffic signal maintenance and operation. OBJECTIVES AND ACTIVITIES: • To provide well-maintained streets that are clearly signed and marked. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Crew Supervisor 1 0 Maintenance Worker 4 4 Sign Worker 1 1 TOTAL 6 5 NOTES AND ADJUSTMENTS: A crew supervisor moved to engineering project inspector in the General Fund. Traffic Maint &Signage -147- 12/11/06 2007 Budget -City of Dublin, Ohio Street Maint & Repair ~~ Public Service Engineering 2005 2006 2006 2006 2007 3~, Actual Budget Revised Budget Estimate Budget " 210-1330 '" Personal Services 2110 Salaries/Wages 252,953 286,500 .286,500 262,800 236,075 2111 Overtime Wages 6,239 15,000 15,000 9,050 10 000 ~ 2120 Employee Benefits 95,049 120,025 120,025 103,100 , 95,625 „ 2140 Uniforms & Clothing ~ 4,448 5,000 5,000 3,200 5,000 358,689 426,525 426,525 378,150 346,700 Other Expenses 2201 Conferences/Mileage 0 4,500 4,500 4,000 4,500 2302 Repair Services 5,100 20,000 14,200 10,000 20,000 2310 Utilities 21,116 37,000 37,010 17,350 30,000 2320 Communications 303 3,000 3,000 550 2,350 2349 Other Professional Serv 88,335 100,000 101,500 101,100 100,000 2351 Maint. of Equipment 1,057 2,500 2,500 1,300 2,500 ' 2420 Operating Supplies 6,342 18,000 16,500 10,650 18,000 2428 Special Events 1,030 4,200 14,300 12,000 5,000 2430 Repair & Maintenance 98,261 120,000 170,496 140,800 130,000 2440 Small Tools & Minor Equip 5,309 8,400 8,400 5,200 8,400 2441 Signs 96,771 120,000 124,300 82,450 120,000 323,624 437,600 496,706 385,400 440,750 Capital Outlay 2520 Equipment & Furniture 1,309 0 10,475 10,475 44,300 1,309 0 10,475 10,475 44,300 TOTALS $683,622 $864,125 $933;706 $774,025 $831,750 Ki ~~.. -148- Public Service /Engineering BUDGET SUMMARY: • Accounts 2110, 2111, 2112, and 2120 include funds for the street and traffic sign fabrication and pavement marking operations, formerly included in Streets and Utilities. • Account 2302 funds painting of poles for street lighting. • Account 2310 funds utilities for operation of traffic signals. • Account 2349 reflects the cost of a contract for pavement marking. • Account 2441 provides funding for materials and supplies needed for sign fabrication. • Account 2520 funds two portable message boards and backup power supply cabinets for traffic signals at key intersections. Traffic Maint & Signage -149- 12/11/06 ~~- THIS PAGE LEFT BLANK INTENTIONALLY CIT'Y' i)F UUI3LiN~ J Public Service/ Highway Maintenance STATEMENT OF FUNCTIONS: This program is identical to the street maintenance program as outlined in the street maintenance section, except this covers work performed on the various state highways located within the City. The monies utilized for this section are from the State Highway Maintenance Improvements Fund which is generated by motor vehicle registration fees and gasoline tax revenues, and can only be spent for this limited purpose. NOTES AND ADJUSTMENTS: There are no personnel assigned to Highway Maintenance. Highway -151- 12/11/06 2007 Budget -City of Dublin, Ohio State Highway Public Service Streets and Utilities 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 211-1320 Personal Services 2110 Salaries/VVages 46,900 52,100 52,100 52,100 0 4.. 2111 Overtime Wages 500 5,400 5,400 5,400 p 2112 Other Wages 5,000 9,000 9,000 9,000 0 ~~ 2120 Employee Benefits 7,869 22,000 22,000 22,000 0 60,269 88,500 88,500 88,500 0 Other Expenses 2422 Street Salt 0 24,000 24,000 24,000 p 0 24,000 24,000 24,000 0 Capital Outlay 2550 Street Maint. Projects 0 0 0 0 225,000 0 0 0 0 225,000 TOTALS $60,269 $112,500 $112,500 $112,500 $225,000 ~: ~.: ~;> -152- Public Service/ Highway Maintenance BUDGET SUMMARY: • Account 2550 provides funding for the Riverside Drive overlay-SR 161 to north limits and the Dublin Road overlay-SR 161 to Glick Road. Highway ~ -153- 12/I I/06 2007 Budget -City of Dublin, Ohio State Highway Public Service Engineering 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget ~w 211-1330 '""~ Other Expenses 2310 Utilities 18,396 32,000 33,208 17,300 25,000 18,396 32,000 33,208 17,300 25,000 TOTALS $18,396 $32,000 $33,208 $17,300 $25,000 -154- Public Service /Engineering BUDGET SUMMARY: • Account 2310 provides funding for the cost of utilities related to the operation of traffic signals that are located on State highways. Highwyts -155- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITY ~F DUBLIN.. 4 Parks and Recreation /Cemetery Maintenance STATEMENT OF FUNCTIONS: The City of Dublin recognizes its responsibility to provide the proper grounds for its permanent residents by striving to protect and enhance its active and historical cemeteries. Cemetery Maintenance facilitates the burial process with the greatest of respect and assures proper care of these sacred grounds by adherence to the highest of maintenance standards. OBJECTIVES AND ACTIVITIES: • To provide proper burial grounds that reflect Dublin's high standards and to assure a most respectful burial process. PERSONNEL DATA POSITION TITLE Maintenance Worker Seasonal Maintenance Worker TOTAL NOTES AND ADJUSTMENTS: 2006 2007 CURRENT NUMBER ADOPTED 1 1 2 2 3 3 Cemetery -157- 12/ 11 /06 2007 Budget -City of Dublin, Ohio ,~~, Cemetery µ_ Parks and Recreation Cemetery Maintenance 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget ,5r. 212-1621 Personal Services , 2110 Salaries/Wages 44,077 47,550 47,550 41,800 47,950 2111 Overtime Wages 7,680 4,000 5,000 5,000 4,000 2112 Other Wages 33,640 32,500 31,500 15,100 32,500 2120 Employee Benefits 24,561 25,425 25,425 21,850 27,350 109,958 109,475 109,475 83,750 111,800 Other Expenses 2201 Conferences/Mileage 0 250 250 0 250 ~` 2310 Utilities 70 500 579 550 500 2349 Other Professional Serv 300 1,500 1,500 300 1,500 ee 2351 Maint. of Equipment 709 1,500 2,500 1,000 1,500 "~' 2380 Printing and Reproduction 6,405 1,250 1,250 600 1,250 2390 Contractual Services 433 4,750 8,750 6,300 16,750 2410 Office Supplies 589 500 500 500 500 "~ 2430 Repair & Maintenance 6,013 9,100 9,050 4,100 9,100 14,519 19,350 24,379 13,350 31,350 Capital Outlay ~~ 2510 Land & Land Improvements 558 12,800 15,242 15,100 12,800 2520 Equipment & Furniture 2,838 700 750 700 1,600 3,396 13,500 15,992 15,800 14,400 Y_., OTALS $127,873 $142,325 $149,846 $112,900 ~r. $157,550 -158- Parks and Recreation /Cemetery Maintenance BUDGET SUMMARY: • Account 2390 provides funding for the transaction expenses related to the acceptance of Visa/MasterCard, and vault company services. This account also includes arborist work which has increased due to routine pruning which needs to be done and older trees declining in health which requires removal of trees. • Account 2430 includes funding for repairing monuments, removing trees, grass seed, concrete, topsoil, and fertilizers. • Account 2510 includes funding for fence and stone wall work, headstone repairs and replacements, and tree plantings. • Account 2520 includes funding for replacement of trimmer and addition ofmulching deck for mower. Cemetery -159- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CI'R' OF UUf3LIN.. ~~ 5 Parks and Recreation /Recreation Services STATEMENT OF FUNCTIONS: Recreation Services is responsible for developing, implementing and delivering quality recreation and leisure services to the residents of Dublin and the Dublin School District. The Recreation staff is dedicated to a comprehensive programming standard that insures equitable opportunities to all customers, based onprinciples ofself-actualization and strength of community, and in a manner that is fiscally responsible and cost efficient. OBJECTIVES AND ACTIVITIES: • To provide proactive management, proficiency, efficiency to all Recreation Services functions. • To provide safe quality leisure time activities and opportunities. • To provide continuing education and training for the Recreation Staff. • To promote participation in recreation programs through comprehensive marketing strategies. • To insure accessibility for citizens of Dublin. • To provide the highest quality service to Dublin residents. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Recreation Services Administrator 1 1 Recreation Program Supervisor 3 4 Recreation Program Coordinator 2 1 TOTAL 6 6 SEASONAL STAFF Front Desk 2.38 FTE 2.38 FTE Intern .87 FTE .87 FTE Open Gym & Sports 2.42 FTE 2.68 FTE Wyandot Discovery Camp 5.53 SFTE 6.46 FTE Recreation Leader 1.30 FTE 1.30 FTE Summer Program Supervisors: 3.21 FTE 3.69 FTE Teens (Teen Lounge staff) _ 1.03 FTE 1.03 FTE Jr. Kidzone .94 SFTE .25 SFTE Misc. Camps (holidays,specialty, nature) 1.20 FTE 1.27 FTE Special Events .48 FTE .52 FTE My First Camp .49 FTE .49 FTE Travel Aides .13 FTE .13 FTE Head Front Desk .61 FTE .61 FTE Wellness Assistant .50 FTE .50 FTE Senior Programs Asst. 0 FTE .50 FTE TOTAL 21.09 FTE 22.68 FTE NOTES AND ADJUSTMENTS: Implementation of newly adopted division strategies includes the modification of existing organizational structure which promotes proactive management of each function, maximizing proficiency, program succession and age- group transition. Modifications to the organizational structure include the delegation of responsibilities of the vacant Teen/Adult/Special Needs Program Supervisor position, and the allocation of functions to specific program areas in order to meet the objectives. Rec -161- 12/11/06 2007 Budget -City of Dublin, Ohio Recreation °~ Parks and Recreation ,~, Recreation 2005 2006 2006 2006 2007 .~ Actual Budget Revised Budget Estimate Budget 213-1630 ~,; Personal Services 2110 Salaries/VNages 441,796 429,675 429,675 408,600 2111 Overtime Wages 2,428 3,000 4,000 4,000 2112 Other Wages 342,718 447,225 445,725 362,000 2120 Employee Benefits 190,665 203,250 203,250 200,400 2140 Uniforms & Clothing 8,568 9,800 11,431 11,200 530,475 3,000 481,500 ~:: 264,550 10,275 "~' 986,175 1,092,950 1,094,081 986,200 1,289,800 Other Expenses 2201 Conferences/Mileage 9,847 11,800 12,524 10,800 650 8 2320 Communications 7,720 14,450 14,921 10,100 , 20,700 2330 Rents/Leases 41,982 88,525 94,252 .58,000 88,025 2349 Other Professional Serv 134,393 197,150 215,342 160,000 208 500 2351 Maint. of Equipment 1,581 3,300 3,440 1,550 , 3,300 , 2370 Advertising 1,326 2,350 2,350 1,200 3,850 "~` 2380 Printing & Reproductions 17,157 23,300 29,800 16,000 18 000 2390 Misc Contractual Services 34,444 98,000 98,000 85,500 , 45,000 2391 Memberships/Subscriptions 1,455 2,550 2,625 1,500 3,125 2410 Office Supplies 10,367 12,150 15,511 15,500 14,150 2420 Operating Supplies 53,227 69,050 74,492 55,300 68,350 2442 Sports Equipment 10,925 16,700 16,700 12,000 16,700 2840 Special Events 1,277 1,700 1,700 1 500 1 800 2841 Sr. Citizens Activities 20,674 27,525 31,525 , 25,600 , 27,725 2842 Sports Leagues 30,528 40,775 54,066 46,400 40,775 ..w 2910 Refunds 58,970 60,000 60,000 40,800 60,000. ~ . 435,873 669,325 727,248 541,750 628,650 Capital Outlay 2520 Equipment & Furniture 16,430 15,500 15,500 9,600 1,000 16,430 15,500 15,500 9,600 1,000 TOTALS $1,438,478 $1,777,775 $1,836,829 $1,537,550 $1,919,450 -162- Parks and Recreation/ Recreation Services BUDGET SUMMARY: • Account 2112 includes funding for increased Open Gym safety and operations supervision, and accommodate growth in youth camps, teen programs, and new adult programming. Also includes funding for needed support for Adult/Senior program area. • Account 2320 includes funding for increase in postage and bulk mailings, cell phone usage for Recreation Program Supervisors (teens) (2) and a Recreation Program Coordinator (1) year round to provide direct point of contact to all camp sites, counselors and DCRC staff. • Account 2349 includes funding for additional camps and associated expenses for 2007, primarily in the sports, teen and adult program areas. • Account 2370 includes funding for implementation of division marketing strategy specific to each programming area. • Account 2380 reduced funding for cost savings with new program brochure format and printing. Account also includes funding for printing costs associated with the publication of the Parks and Recreation Master Plan. • Account 2390 includes a decrease due to the completion of the Parks and Recreation Master Plan contracted services in 2006. • Account 2391 includes funding to accommodate fee increases for professional organization membership fees, COPRA, NRPA, etc.). • Account 2520 reflects a reduction in 2007. Renovation purchases for the Teen Lounge and Wee Folk Room operations occurred in 2006. Rec -163- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CITE' t)F DUBLl?+i.. Parks and Recreation /Community Recreation Center STATEMENT OF FUNCTIONS: The Dublin Community Recreation Center (DCRC) is a well managed, efficiently operated, state of the art facility providing the highest standards of organized and open leisure activities to the residents of Dublin and the Dublin School District. Through well-planned facility management and programming, the DCRC is committed to the highest level of service our internal and external customers expect and deserve. OBJECTIVES AND ACTIVITIES: • To provide excellent customer service and maximize operational efficiency. • To provide safe, quality leisure activities and services. • To provide a combination of open recreation and structured program opportunities. • To provide a facility, which meets or exceeds all state and local health and safety requirements. • To provide continuing education and training for all DCRC staff. PERSONNEL DATA POSITION TITLE 2006 2007 CURRENT NUMBER ADOPTED Director, Recreation Services 1 1 Recreation Service Administrator 3 3 Recreation Program Supervisor 3 3 Recreation Operations Supervisor 1 0 Membership Services Supervisor 1 1 Facility Reservations Supervisor 1 1 Theater Supervisor 1 1 Recreation Program Coordinator 3 2 Recreation Operations Coordinator 1 2 Facility Reservations Coordinator 0 1 Recreation Specialist 1 0 Administrative Assistant 1 1 Manager on Duty (part-time) 1 1 TOTAL 18 17 PART-TIME STAFF Fitness/Wellness 9.78 FTE 10.53 FTE Aquatics 22.47 FTE 22.47 FTE Front Desk Workers 4.40 FTE 4.40 FTE Babysitters 5.24 FTE 5.29 FTE Intern 1.57 FTE 1.57 FTE Head Front Desk .65 FTE .65 FTE Theater Staff .67 FTE 1.15 FTE Manager on Duty .50 FTE 1.25 FTE TOTAL 45.28 FTE 47.31 FTE NOTES AND ADJUSTMENTS: Implementation of newly adopted div ision strategies includes the modification of existing organizational - ° structure which promotes proactive management of each function, maximizing pro ficiency, program succession, and age-group transition. Modifications to the organizational structure includes the delegation of responsibilities of the Teen/Adult/Special Needs Program Supervisor position and the allocation of functions to specific program areas in order to meet the division objectives. CRC -165- 12/11/06 2007 Budget -City of Dublin, Ohio Recreation _• Parks and Recreation Community Recreation Ctr 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 213-1631 Personal Services 2110 Salaries/Wages 725,199 800,775 760,775 740,000 2111 Overtime Wages 27,671 25,000 25,000 22,500 2112 Other Wages 955,339 1,002,850 1,042,850 977,550 2120 Employee Benefits 367,503 401,250 401,250 383,000 2140 Uniforms & Clothing 7,411 9,925 13,999 12,200 730,500 21,000 1,071,750 403,150 11,625 2,083,123 2,239,800 2,243,874 2,135,250 Other Expenses 2,238,025 2201 Conferences/Mileage 21,282 32,425 39,751 35,100 30,850 2310 Utilities 533,624 743,975 752,518 598,000 659,000 2320 Communications 18,154 21,525 24,209 20,050 20,250 2330 Rents/Leases 12,871 17,200 22,134 16,600 17,700 2349 Other Professional Serv 120,192 157,500 192,887 175,000 239,350 2351 Maint. of Equipment 1,498 3,350 3,350 1,500 3,350 °~ 2370 Advertising 18,864 22,000 28,516 20,400 26,000 2380 Printing & Reproductions 40,422 45,300 56,578 54,500 36,000 2390 Misc Contractual Services 37,883 53,900 55,910 42,100 50,500 `~' 2391 Memberships/Subscriptions 3,500 5,400 6,160 2,250 5,950 2410 Office Supplies 17,633 20,700 24,700 17,600 21,000 2420 Operating Supplies 28,749 34,850 43,315 30,250 41,250 ~'" 2425 Merchandise for resale 6,814 9,000 9,000 6,300 9,000 ,h~: 2426 Program Supplies 69,008 54,875 63,254 40,100 52,350 2430 Repair & Maintenance 60,197 54,200 72,128 66,500 54,000 2440 Small Tools & Minor Equip 1,992 2,250 2,753 2,000 2,250 2442 Sports Equipment 81,807 20,550 23,693 23,600 65,850 2812 Special Projects/Programs 3,228 3,900 6,400 4,100 3,300 2910 Refunds 37,254 45,000 45,000 30,400 45,000 ,. 1,114,972 1,347,900 1,472,256 1,186,350 1,382,950 Capital Ou tlay 2520 Equipment & Furniture 35,759 34,200 54,040 37,150 41,725 35,759 34,200 54,040 37,150 41,725 wQ~ TOTALS $3,233,854 $3,621,900 $3,770,170 $3,358,750 $3,662,700 ~~ -166- Parks and Recreation /Community Recreation Center BUDGET SUMMARY: • Account 2112 includes funding to accommodate additional Theater performances, mandatory City training, expanded Wee Folk Room hours of operation and increased ages (6wks. - 12 yrs.), and to fully implement the part time Manager On Duty coverage pilot program designed in 2006. • Account 2140 includes funding for staff uniforms. Increased costs due to pricing and replenishment of inventory due to staff turnover and new uniform color schemes. • Account 2320 includes funding for replacement communication radios for DCRC operations. • Account 2349 includes funding for fitness personal trainers to accommodate demand. The increase results from a change in 2006 of the procedures for compensating personal trainers. In 2005 and part of 2006 fees were collected by the personal trainer; 60% was retained by the trainer and 40% was then submitted to the City. All fees will now collected by the City and the 60% contracted amount is paid out to the trainer; therefore reflecting an expense in the operating budget. • Account 2370 includes advertising funds for the DCRC/Theater to promote additional programs expected for 2007. • Account 2380 reflects decreased funding due to new operations software to manage Wee Folk Room and Outdoor Pool facility passes and tokens. • Account 2420 includes funding for mobile storage facilities for DCRC equipment. • Account 2442 includes funding for replacement of worn cardiovascular equipment. Existing equipment is 3-6 years old and is beyond the warranty period for replacement parts and labor. CRC -167- 12/11/06 'THIS PAGE LEFT BLANK IN'TEN'TIONALLY C1Tl' ()F UUBLII~.. ~. Administrative Services/ Community Recreation Center -Facilities STATEMENT OF FUNCTIONS: Facilities protects the City's investment in the Recreation Center by insuring that both the appearance and functions are preserved. This is accomplished by adhering to proper preventive maintenance programs, performing repairs in a professional mariner and as quickly as possible, maintaining a save and clean environment for building occupants and visitors, and by seeking the most efficient utilization of space and energy resources. OBJECTIVES AND ACTIVITIES: • 'fo establish and implement a proactive preventive maintenance program. • To perform regular inspections of facilities and equipment. • To provide custodial services at the Recreation Center. • To perform repairs to equipment and facility components. • To provide oversight for certain recreation construction and renovation projects. • To perform set-up and breakdown of space for certain activities held in the Recreation Center. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Maintenance Crew Leader 2 2 Maintenance Worker 3 3 Custodians 10 10 Seasonal Maintenance Worker 3 3 TOTAL 18 18 NOTES AND ADJUSTMENTS: RecFac -169- ] 2/ 11 /06 2007 Budget -City of Dublin, Ohio Recreation .- Administrat ive Services Facilities M anagement 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 213-1940 Personal Services 2110 Salaries/Wages 626,738 624,550 624,550 580,000 635,575 2111 Overtime Wages 68,240 45,000 45,000 45,000 45,000 rr 2112 Other Wages 70,266 40,450 40,450 35,100 40,450 2120 Employee Benefits 289,744 296,925 296,925 264,750 306,700 2140 Uniforms & Clothing 11,238 13,900 19,053 17,550 14,700. 1,066,226 1,020,825 1,025,978 942,400 1,042,425 °`~` Other Expenses 2201 Conferences/Mileage 4,588 4,750 5,600 5,450 4,750 ~,; 2211 Meeting Expenses 0 500 500 500 250 2320 Communications 1,070 1,900 2,080 1,800 2,250 2330 Rents/Leases 1,998 2,500 2,500 2,350 2,500 2350 Maint. of Equipment 51,528 76,450 92,143 86,450 71,500 2390 Misc Contractual Services 92,598 148,175 188,539 153,200 220,750 '"`' 2391 Memberships/Subscriptions 0 100 100 100 250 2420 Operating Supplies 86,928 105,850 125,111 112,600 108,500 2440 Small Tools & Minor Equip 2,554 6,400 8,090 5,100 5,200 241,264 346,625 424,663 367,550 415,950 '" Capital Outlay 2520 Equipment & Furniture 10,495 1,000 1,000 1,000 1,000 ~, 2530 Bldgs. & Other Structures 1,560 250,500 257,275 238,100 137,200 12,055 251,500 258,275 239,100 138,200 TOTALS $1,319,545 $1,618,950 $1,708,916 $1,549,050 $1,596,575 m -170- Administrative Services/ Community Recreation Center -Facilities BUDGET SUMMARY: • Account 2110 provides funding for staff salaries and wages. • Account 2112 provides funding for three seasonal staff. • Account 2140 provides funding for uniform clothing for all crew leaders, maintenance/custodian and seasonal staff. • Account 2320 provides funding for a pager, cellular phones, accessories, and replacement costs as well as long-distance phone charges. • Account 2350 includes funding for ongoing general maintenance and repair of the Recreation Center. • Account 2390 includes funding for preventive maintenance contracts for systems and services, technical maintenance services, inspections, cleaning services for carpet, resilient flooring and upholstery, and weekend custodial services. • Account 2420 provides funding for custodial supplies, light bulbs, filters, paints and other miscellaneous supplies to maintain the facility. • Account 2440 provides funding for hand tools, ladders and vacuum sweepers. • Account 2520 provides funding for one radio and charger. • Account 2530 provides funding for specific facility renovation/repair projects that are smaller in scope than projects funded in the Capital Improvement Program. The 2006 budget included painting of the pool areas which resulted in a higher budget than in 2007. RecFac -171- 12/11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITE' #)F UI~BLI~.. L~ Safety /Police STATEMENT OF FUNCTIONS: Police, under the direction of the Chief of Police, is comprised of three work units: Operations, Support Services, and Technical Services. Operations consists of the following: patrol, traffic enforcement and accident investigations, field training, bicycle patrol, and the K-9 and reserve officer program. The primary responsibility ofthe Operations Bureau is the maintenance of public order, involving the protection of constitutional guarantees, the enforcement of the law and the provision of services necessary to respond to other needs of the Community. Support Services will include the detective section, internal affairs, the DARE and school resource office programs, neighborhood watch, special events and court liaison. Technical Services, created in 2005, includes the communications center, records, property room, accreditation and training, technology support and accounting budgeting and clerical support. The primary responsibility of Technical Services is to provide the required support services for all of Police. Police works in cooperation with local, and State and Federal law enforcement agencies in gathering information on criminal activity. Other functions include: appearing as witnesses in court cases, identifying and providing educational resources to assist the community in crime prevention and planning for long-range community needs as they relate to future police services. OBJECTIVES AND ACTIVITIES • To enhance the quality of life in the community. • To provide an increased level of advanced training for staff. • To increase proactive policing methods in an effort to reduce the incidence of crime. • To increase traffic enforcement and education activities in an effort to reduce the community's accident rate. • To d~°,~elop improved partnerships with various community entities necessary to reduce criminal activity. • To respond effectively to neighborhood traffic concerns. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Chief, Police/Deputy City Manager 1 1 Police Lieutenant 2 2 Civilian Bureau Commander 1 1 Police Sergeant 7 7 Police Corporal 6 6 Police Officer 53 53 Administrative Specialist 1 1 Office Assistant II 4 4 Property Technician 1 1 Communications Technician 14 15 Communications Supervisor 2 2 TOTAL 92 93 NOTES AND ADJUSTMENTS : A communications technician was added to meet the added demand of wireless 911. Police -173- 12/11/06 2007 Budget -City of Dublin, Ohio Safety ,~. Safety Police 2005 2006 2006 2006 2007 ,, Actual Budget Revised Budget Estimate Budget uw 214-1820 Personal Services 2110 Salaries/VVages 5,417,538 5,857,550 5,857,550 5,593,100 2111 Overtime Wages 428,997 395,125 395,125 365,000 2112 Other Wages 0 0 0 0 2120 Employee Benefits 2,207,076 2,475,475 2,475,475 2,210,000 2140 Uniforms & Clothing 136,040 128,050 140,856 136,800 8,189,651 8,856,200 8,869,006 8,304,900 Other Expenses 2201 Conferences/Mileage 99,460 119,600 144,146 125,500 2211 Meeting Expenses 1,735 4,000 6,150 5,000 2213 Seminar Expenses 10,415 13,500 13,500 8,450 2301 County Auditor Deductions 5,195 5,000 6,000 4,700 2320 Communications 39,145 57,400 63,381 45,500 2330 Rents/Leases 7,497 13,500 15,154 10,100 2349 Other Professional Serv 6,690 11,000 11,473 5,000 2351 Maint. of Equipment 176,977 228,675 232,961 190,000 2390 Contractual Services 20,145 22,350 26,729 16,000 2391 Memberships/Subscriptions 28,090 37,325 37,325 32,400 2410 Office Supplies 18,806 30,000 32,445. 21,050 2420 Operating Supplies 52,348 67,000 73,787 52,650 2851 DARE Program 33,411 30,775 32,106 26,350 2910 Refunds 22 500 500 0 499,936 640,625 695,657 542,700 Capital Outlay 2520 Equipment & Furniture 64,028 35,750 42,764 35,500 19,550 64,028 35,750 42,764 35,500 19,550 `' TOTALS $8,753,615 $9,532,575 $9,607,427 $8,883,100 $10,083,125 -174- Safety/ Police BUDGET SUMMARY: • Account 2110 and 2120 provide funding for staff. • Account 2140 provides funding for uniform allowances and dry cleaning as provided for in the negotiated FOP contract. • Account 2211 includes funds for ayear-end staff retreat. This retreat is aone-day, locally held retreat with the objective of closing out the current year and preparing for the upcoming one. Additionally, it provides funding for group meetings sponsored by the City. Funding is included for food, beverages, and associated supplies. • Account 2213 provides funding for expenditures related to seminars sponsored by the Police. The expenditures are sometimes offset by fees charged to participants. Funds for the Bike Rodeo and Battle of the Badges are also included in this account. • Account 2330 provides funding to lease copiers, fax machines and other office equipment for the Police. • Account 2349 provides funding for polygraphs, laboratory testing, and law enforcement support from other local, state and federal agencies. The increase is a result of Ohio BCI web check fees. • Account 2351 provides funding for maintenance agreements for all departmental equipment including but not limited to the radio system radios and consoles in the Communication Center. The increased funding continues to reflect additional users and numbers of communications equipment covered under maintenance agreements. • Account 2390 has increased for additional contracted security used for. special events. • Account 2391 includes continuation of a program through the Ohio Office of Criminal Justice Services (OCJS) through which police officers from various local jurisdictions are able to share information through a computer network. • Account 2420 includes funding for equipment, ammunition, Operation Kidprint supplies, jail supplies, range supplies, canine food and supplies, and other miscellaneous operating supplies that are needed. • Account 2851 includes funding for all DARE related supplies and activities. • Account 2520 includes funding for equipment and office furniture, "Stealthstat", replacement fitness room equipment, replacement bike equipment, replacement canine equipment and tracking software and other miscellaneous operating equipment. Police -175- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY C11~' t)F UU[ILIIti.. ~r. 7 Parks and Recreation /Dublin Municipal Pools STATEMENT OF FUNCTIONS: The Dublin North and South Community Pools are seasonal operations which provide the community diverse aquatic related recreation opportunities. Pool facilities include a main pool, tot pool, waterslide, concession stand, and a water play/spray area. OBJECTIVES AND ACTIVITIES: • To operate a swimming facility, which meets or exceeds all state health and safety requirements. • To offer open swim times for general public use. • To offer a comprehensive aquatics program including swim lessons for all ages, a traveling swim team program for school age youth, and water exercise classes. • To provide continuing education and safety training for all pool staff. • To increase open recreation opportunities at the facility and incorporate community based activities. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED SEASONAL STAFF: Pool Manager 5.00 SFTE 5.00 SFTE Concession Manager 1.34 SFTE 1.34 SFTE Assistant Concession Manager 3.26 SFTE 3.26 SFTE Pool Lifeguard 39.42 SFTE 39.42 SFTE Desk Staff/Concession Staff 20.36 SFTE 20.36 SFTE Swim Team Coaches 9.92 SFTE 9.92 SFTE Swim Instructors 3.58 SFTE 3.58 SFTE TOTALS 82.88 SFTE 82.88 SFTE NOTES AND ADJUSTMENTS: The Aquatics Program Supervisor and two Aquatics Program Coordinators reflected in the Community Recreation Center budget have time allocated to the outdoor pool. 20% of the Aquatics Recreation Administrator, 30% of the Aquatics Program Supervisor, 5% of one Aquatics Program Coordinator, and 40% of a second Aquatics Program Coordinator's time is allocated to this budget. In addition, 5% ofthe Director's time is also allocated to the outdoor pool budget. Pool -177- 12/11/06 2007 Budget -City of Dublin, Ohio Pool Parks and Recreation Recreation 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 215-1630 Personal Services 2110 Salaries/VVages 32,382 51,400 51,400 51,400 63,675 2111 Overtime Wages 0 2,000 2,000 0 2,000 2112 Other Wages 367,645 386,400 386,400 368,750 392,450 2120 Employee Benefits 64,328 84,500 84,500 66,000 84,725 2140 Uniforms & Clothing 14,096 14,450 14,575 14,550 16,450 478,451 538,750 538,875 500,700 559,300 Other Expenses :: 2201 Conferences/Mileage 707 1,000 1,000 500 1,000 2310 Utilities 103,829 156,575 171,452 134,000 150,000 2320 Communications 2,029 5,500 6,200 5,400 4,800 2349 Other Professional Serv 218 3,850 3,350 1,050 3,850 2390 Misc Contractual Services 0 600 600 600 10,600 2391 Memberships/Subscriptions 900 1,250 1,335 1,000 1,550 2410 Office Supplies 556 2,100 2,100 2,100 4,200 2420 Operating Supplies 3,888 8,000 9,639 9,150 15,000 2423 Concessions 51,461 54,000 63,000 58,000 54,000 2424 Pool Supplies/Chemicals 53,199 59,500 61,708 57,300 59,500 2426 Program Supplies 2,954 4,800 4,800 2,600 4,800 2430 Repair & Maintenance 45,364 97,175 106,851 101,000 40,000 2910 Refunds 0 4,000 4,000 1,250 4,000 265,105 398,350 436,035 373,950 353,300 Capital Outlay 2520 Equipment & Furniture 63,600 27,700 29,680 25,800 49,500 2530 Bldgs. & Other Structures 0 49,500 40,500 35,000 94,300 63,600 77,200 70,180 60,800 143,800 :; TOTALS $807,156 $1,014,300 $1,045,090 $935,450 $1,056,400 ,, -178- Parks and Recreation /Dublin Municipal Pools BUDGET SUMMARY: • Account 21 12 provides funding for the seasonal staff salaries. • Account 2201 provides funding for training outdoor pool managers lifeguards and travel expenses for state and local lifeguard competition. • Account 2310 provides funding for electric, natural gas, and water and sewer services. • Account 2320 provides funding for the monthly charges associated with the pay phone located at the pool, a cellular phone, City radio communications and local and long-distance telephone charges. • Account 2349 provides funding for operating licenses and seasonal pool preparations. • Account 2390 provides funding for new themed activity series for both outdoor pools. • Account 2391 provides funding for swim team league fees. Fees will increase in 2007. • Account 2410 provides funding for RecTrac software applications and ability for pool passes to be purchased and scanned at the pool facility. Currently processed only at the DCRC. • Account 2420 provides funding for implementation of new facility signage program. • Account 2426 provides funds for swim team supplies such as trophies and other program supplies associated with outdoor swim lessons and other swim programs. • Account 2520 includes funding for replacement chairs, safety equipment, starting block covers, and replacement of wading pool play feature. • Account 2530 provides funding for liquid chlorine conversion pumps and storage for both pool facilities for cost savings and more efficient chemical application. Pool -179- 12/11 /06 THIS PAGE LEFT BLANK INTENTIONALLY C17~' t)F DUBLI?~.. 8 Permissive Tax Fund STATEMENT OF FUNCTIONS: Funds are received from the County $5.00 Motor Vehicle License Tax Fund as individual projects are approved by the Franklin County Engineer's Office and Franklin County Commissioners. Projects must be for roadway construction or improvements. Funds are also received from legislation approved by Franklin and Delaware Counties to increase license registration fees in two $5.00 increments. The City receives 50% of the "first $5.00 increment". The revenue received can only be spent on roads and bridges. NOTES AND ADJUSTMENTS: PermTax -181- 12/ 11 /06 2007 Budget-City of Dublin, Ohio Permissive Tax Fund 2006 Public Services 2005 2006 Revised 2006 2007 Engineering Actual Budaet Budaet Estimate Budget 216-1330 Capital Outlay 2550 Street Construction $0 $0 $0 $0 $0 -182- Permissive Tax Fund BUDGET SUMMARY: • No expenditures are currently anticipated in this fund for 2007. PermTax -183- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CIT3' E)F DUIiLLN.. 9 Community Relations STATEMENT OF FUNCTIONS: 75% of the hoteUmotel tax revenues are credited to HoteUMotel Tax Fund in accordance with City Ordinance No. l 33- 87. The remaining 25% is distributed to the Dublin Convention and V isitors Bureau (DCVB). From the Hotel/Motel Tax Fund, the City allocates 25% of the total revenue to the Dublin Arts Council (DAC), up to a maximum as specified in a lease agreement executed for the DAC's use of a City-owned facility. Funds may be distributed to other organizations through City Council review of submitted hoteUmotel tax grant applications. City-sponsored events are approved through the normal budget process. For 2007, these include St. Patrick's Day, Independence Day, Dublin Irish Festival (DIF), and Spooktacular. Community Relations plans, implements, and manages special events that enhance the City's image and stimulates visitors' and residents' attendance supporting the mission of the DCVB. OBJECTIVES AND ACTIVITIES: • To plan, implement, and manage City-sponsored festivals, events and parades in a professional and fiscally responsible manner. • To ensure that City Council's goals of fostering community pride and spirit by creating events and encouraging community participation are achieved. • To develop mission statements, event policies and budgets. • To establish, develop, and cultivate effective relations among the City, community organizations, schools and corporate and media sponsors involved in the special events process. • To cultivate relationships with cultural and tourism boards in the United States, Canada and Ireland to enhance artistic and cultural elements and increase overnight attendance in Dublin hotels. • To secure cash sponsorships for City of Dublin events by creating and maintaining mutually beneficial partnerships with Iocal, regional and national corporations. • To secure in-kind donations of goods and services to reduce expenses and to enhance the event experience. • To secure and build relationships with media partners to reach targeted audiences in local, regional, national and international markets. • To promote events through the planning and execution of marketing campaigns. • To cultivate relationships with community organizations by providing fundraising opportunities in support of community initiatives. • To plan, staff, and allocate the resources of various functions to support City-sponsored events. • To unite and organize City divisions to ensure the safety and comfort of visitors to events. • To develop and negotiate contracts with entertainers and agents in conjunction with risk management and legal counsel. • To develop and manage a wide range of children's and youth entertainment and activities. • To plan and implement special event support services including transportation, accommodations, receptions, and hospitality. • To serve on the Board of Trustees of the Dublin Convention and Visitors Bureau as an ex-officio member. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Event Administrator 3 3 Intern I 1 TOTAL 4 4 NOTES AND ADJUSTMENTS: As noted in the General Fund, the Director of Community Relations, the Administrative Assistant, Community Relations Assistant, and Office Specialist II are allocated 50% to this budget. Numerous temporary employees are used throughout the year to staff City-sponsored special events. SpEvents -185- 12/ 11!06 2007 Budget -City of Dublin, Ohio Hotel/Motel Tax City Manager Community Relations 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 217-1130 Personal Services 2110 Salaries/VVages 279,818 291,100 291,100 290,000 305,900 2111 Overtime Wages 10,058 7,750 13,750 13,750 7,750 2112 Other Wages 36,621 41,450 39,450 38,650 48,750 2120 Employee Benefits 104,485 105,450 105,450 94,800 118,925 2140 Uniforms & Clothing 1,666 1,000 1,100 1,100 1,000 f 432,648 446,750 450,850 438,300 482,325 Other Expenses 2201 Conferences/Mileage 14,052 9,950 13,950 13,800 14,000 2211 Meeting Expenses 4,244 4,650 3,650 3,350 5,150 2320 Communications 8,771 14,700 16,857 8,300 10,550 2349 Other Professional Serv 1,164,912 1,287,450 1,346,937 1,345,400 1,513,400 2370 Advertising 70,330 64,750 67,350 67,250 82,050 2380 Printing & Reproductions 33,681 45,250 35,250 35,000 41,800 2390 Misc Contractual Services 1,730 500 7,934 7,700 600 2391 Memberships/Subscriptions 2,266 2,000 2,000 1,900 2,000 2410 Office Supplies 4,135 4,000 4,242 3,900 4,000 2420 Operating Supplies 166,328 177,900 172,550 170,000 209,000 2440 Small Tools & Minor Equip 975 2,000 2,850 2,650 3,900 2812 Special Projects/Programs 21,450 28,500 25,500 25,500 63,500 2813 Promotional Programs 3,261 5,250 6,250 5,700 5,750 2815 Volunteer Program 17,434 27,950 24,950 23,350 28,150 2910 Refunds 150 0 3,000 1,750 0 1,513,719 1,674,850 1,733,270 1,715,550 1,983,850 TOTALS $1,946,367 $2,121,600 $2,184,120 $2,153,850 $2,466,175 -186- 2007 Budget -City of Dublin, Ohio Hotel/Motel Tax Finance Taxation 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 217-1230 Other Expenses 2821 Grants/Community Org. 49,745 40,000 86,103 80,850 75,000 2822 Grants/DAC 481,992 492,000 490,000 486,000 501,475 2823 Grants/DCVB 80,000 40,300 40,300 40,300 0 2790 Transfers 175,038 256,200 256,200 256,200 252,085 786,775 828,500 872,603 863,350 828,560 TOTALS $786,775 $828,500 $872,603 $863,350 $828,560 -187- Community Relations BUDGET SUMMARY: 217-1130 • Account 2211 provides funding for internal working luncheons, committee luncheons/dinners and sponsorship meetings and dinners. • Account 2112 includes one intern, seasonal and temporary employees to work at City-sponsored events. • Account 2320 includes funding for courier services, event bulk mailings, DIF field phone lines and the cost of special events phones and radio rental for all events. • Account 2349 includes professional services for City sponsored events including photography, marketing and PR services and graphic design for consistent branding; citywide ASCAP and BMI and SEASAC music licensing: parade float entries; entertainment and activities including fireworks, exhibitors, musicians and dancers. Operational services include sound and electrical professionals; rentals including tents, generators, ice trucks, light towers, port-a johns, stages, fencing, lights, tables, chairs, shuttle service, radios, golf carts and payments to beverage serving fundraising groups. A significant amount of these expenditures is offset by revenue. The increase in 2007 is largely a function of the 20`h anniversary DIF. • Account 2370 includes funds for event advertising in print and electronic media to attract visitors and overnight guests. • Account 2380 includes funds for event print materials including fliers, brochures, invitations, postcards, tickets, coupons and maps. • Account 2420 includes funding for float supplies, awards, decorations, prizes, crafts, table coverings, signage, wristbands, entryways, hand stamps, alcohol, soda and water for City-sponsored events. Beverage sales generate offsetting revenue. • Account 2440 provides funds for replacement tents, new public address system and mist fans. • Account 2812 provides funding for committee ceremonial needs and Irish Academy. One time activities including the Irish Tatoo and special 20"' Anniversary events as well as new power for the south field. A significant portion of the Academy cost will be offset by participant revenue. • Account 2815 includes funding for volunteer programs, primarily the DIF. Budgeted items include orientation handbooks, T-shirts, awards, printing, shuttles, and recognition event. 217-1230 • Account 2821 is an allocation for grants to community organizations in accordance with the Hotel/Motel Grant Application Guidelines. $20,000 is earmarked for grants to support events within the Historic District. • Account 2822 provides funding for distribution with the Dublin Arts Council in accordance with the lease agreement executed for 7125 Riverside Drive. • Account 2790 transfers funding for debt service associated with the acquisition and renovation of 7125 Riverside Drive. :mow SpEvents -188- 12/11/06 10 Safety/ Police Ordinance 96-90 authorized the establishment of the Enforcement and Education Fund. Revenues in this fund are derived from fines received in accordance with Section 4511.99 ofthe Ohio Revised Code. This fund is to be used by the Police to pay those costs it incurs in enforcing Section 4511.19 of the Ohio Revised Code, in educating the public of laws governing the operation of a motor vehicle while under the influence of alcohol, the dangers of operating a motor vehicle while under the influence of alcohol and other information relating to the operating of a motor vehicle and the consumption of alcoholic beverages. NOTES AND ADJUSTMENTS: Ed/Enf -189- 12/ 11 /06 ~~; 2007 Budget -City of Dublin, Ohio Enforcement & Education Safety ~` Police 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 218-1820 Other Expenses 2420 Operating Supplies 0 3,000 3,000 0 0 0 3,000 3,000 0 0 TOTALS $0 $3,000 $3,000 $0 $0 ,~ ~. -190- Safety/ Police BUDGET SUMMARY: There are no requests in the fund for 2007. EdEnf -191- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY errs` t)F DUBLIN.. 11 Safety /Police STATEMENT OF FUNCTIONS: Ordinance 94-90 authorized the establishment of the Law Enforcement Trust Fund. Revenues in the fund are derived from contraband property seizures in accordance with Section 2933.43 of the Ohio Revised Code. This fund is to be used to pay the costs of prolonged or complex investigations or prosecutions, to provide reasonable technical training or expertise, to provide matching funds to obtain federal grants to aid law enforcement, or for other law enforcement purposes that City Council determines to be appropriate. NOTES AND ADJUSTMENTS: LawEnf -193- 12/ 11 /06 2007 Budget -City of Dublin, Ohio Law Enforcement -. Safety Police 2005 2006 2006 2006 2007 ~_ Actual Budget Revised Budget Estimate Budget 219-1820 Other Expenses ~;~ 2330 Rents/Leases 277 1,000 2,000 1,900 2,000 2420 Operating Supplies 0 20,000 19,000 10,000 25,075 "` 277 21,000 21,000 11,900 27,075 Capital Outlay '~' 2520 Equipment & Furniture 72,264 8,000 8,000 8,000 22,350 72,264 8,000 8,000 8,000 22,350 TOTALS $72,541 $29,000 $29,000 $19,900 $49,425 ~:: ,~. -194- Safety ~ Police BUDGET SUMMARY: Account 2330 provides for the lease and rental of undercover vehicles used in drug investigations, surveillance and other covert operations. Account 2420 provides for the increased number of drug investigations to purchase contraband and pay informants. Additionally, we are requesting supplies for crowd control situations. Account 2520 provides for the purchase of crowd control suits and riot shields. LawEnf -195- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY C1Tl' t}F DllB1ZN.. 12 Administrative Services/ Court Services STATEMENT OF FUNCTIONS: Ordinance 41-93 authorized the establishment of the Mayor's Court Computer Fund. Revenues in this fund are derived from fees received in accordance with Substitute Senate Bill 246. This fund is to be used by Court Services to pay those costs it incurs for any operational costs and/or any subsequent updates for the court computer. The City currently assesses a fee of five dollars ($5.00) per case; however, Substitute Senate Bill 246 allowed the fee to be set as high as ten dollars ($ l 0.00). Computer -197- 12/ 11 /06 2007 Budget -City of Dublin, Ohio Mayor's Court Computer ~x. Administrative Services Court Services 2005 2006 2006 2006 2007 ~r • Actual Budget Revised Budget Estimate Budget 221-1930 Other Expenses ~.. 2201 Conference/Mileage 1,095 4,000 4,000 1,500 4,000 2351 Maint. of Equipment 29,979 18,500 18,707 9,600 20,450 2410 Office Supplies 0 500 500 500 500 ~H 31,074 23,000 23,207 11,600 24,950 Capital Outlay 2520 Equipment & Furniture 2,706 1,400 1,400 1,250 0 ~, 2,706 1,400 1,400 1,250 0 TOTALS $33,780 $24,400 $24,607 $12,850 $24 950 „~ , ~: • -198- Administrative Services/ Court Services BUDGET SUMMARY: • Account 2201 includes funding for designated staff members to attend the HTE National and Regional Users Group conferences and GBS (probation/diversion) annual software training. • Account 2351 includes funding for computer maintenance fees for the AS/400, HTE and GBS applications as well as the LEADS usage fees. Computer -199- 12/11/06 THIS NAGE LEFT BLANK INTENTIONALLY CITY' nF IIUBLL~i.. ~.. :. ~;.; 13 Finance/ Accrued Leave Reserve Fund STATEMENT OF FUNCTIONS: The Ohio Revised Code Section 5705.13 provides for the establishment of reserve funds for certain purposes, one of which is for the payment of accumulated sick, vacation and compensatory leave upon termination of employment or retirement. Because the City of Dublin will have a significant number oflong-term employees either reach retirement age or the point of eligibility within either the Ohio Public Employees Retirement System or the Police/Fire Pension Fund System, the City's liability for payments for accrued leave balances is estimated to be substantial beginning in the next few years. These costs represent a liability accrued over a number of years. In order to prevent a disproportionate impact of these payments on any one budget year, the 2005 budget established a reserve fund and began deposits into it in anticipation of this liability. NOTES AND ADJUSTMENTS: Contributions to this fund represent a percentage of full-time wages. Because Police personnel represent over fifty percent of the estimated liability, the contribution from the Safety Fund will be a greater percentage of full-time wages than all other divisions. The 2007 estimate assumes a contribution of 2.9% of full-time wages from the Safety Fund, and 0.9% of full-time wages for all other functions. Accrued Leave -201- 12/11/06 2007 Budget -City of Dublin, Ohio- Accrued Leave Reserves Finance ''" Office of the Director 2005 2006 2006 2006 2007 ~_ Actual Budget Revised Budget Estimate Budget 222-1210 Personal Services 2124 Accrued Leave Payout 0 138,500 138,500 78,500 109,000 0 138,500 138,500 78,500 109,000 TOTALS $0 $138,500 $138,500 $78,500 $109,000 ,,,~ ~: -202- Finance/ Accrued Leave Reserve Fund BUDGET SUMMARY: • Account 2124 reflects the estimated payments that will be made for accrued leaves in 2007 based on anticipated retirements. Accrued Leave -203- 12/11/06 THIS PAGE LEFT BLANK INTENTIONALLY CITI' OF UL~t3LIN.. ~~ .: 14 General Obligation Debt Service STATEMENT OF FUNCTIONS: These funds reflect the cost of paying the principal and interest on various outstanding bond and. note issues. Sources of funding include property taxes and transfers from the Capital Improvements Tax Fund and various Tax Increment Financing Funds. NOTES AND ADJUSTMENTS: Budget requests for debt service payments reflect debt service obligation for both long-term and short-term debt issued by the City. The debt service payments for Water Fund and Sewer Fund obligation are budgeted as debt service payments directly in the Water and Sewer Funds instead of transferring the money to the General Obligation Debt Service Fund and reflecting the debt payments in that Fund. Debt -205- 12/ 11 /06 2007 Budget -City of Dublin, Ohio General Debt Service Finance Accounting and Auditing 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 310 0210 .~ Other Expenses 2301 County Auditor Deductions 185 350 350 350 200 - } 185 350 350 350 200 Debt Service 2601 Debt Issuance Costs 23,806 20,000 23,000 22,461 20,000 ~` 2610 Principal-Water 232,790 240,615 240,616 240,615 246 484 2611 Principal-Parks Programs 606,178 701,010 701,011 701,009 , 715 315 2612 Principal-Transportation 2,469,926 2,565,154 2,565,154 2,565,154 , 3,621,646 "~ 2613 Principal-Land & Bldgs 1,413,793 1,465,660 1,465,660 1,465,658 1,471,268 2614 Principal-Sewer 126,332 121,974 121,974 121,974 124 705 2615 Principal-Stormwater 27,975 27,975 27,975 27,975 , 27,975 '~' 2620 Interest-Water 63,100 53,905 53,905 53,905 44,281 2621 Interest-Parks Programs 307,139 295,898 292,896 290,000 276 058 2622 Interest-Transportation 1,797,145 1,692,442 1,692,442 1,692,400 , 3,233 162 ~" 2623 Interest-Land & Bldgs 654,535 595,141 595,141 595,022 , 532 363 2624 Interest-Sewer 33,278 27,748 27,748 27,700 , 22,557 7,755,997 7,807,522 7,807,522 7,803,873 10,335,814 TOTALS $7,756,182 $7,807,872 $7,807,872 $7,804,223 $10,336,014 ~x -206- ~,: 2007 Budget -City of Dublin, Ohio Special Assessment Debt Service Funds 2006 Finance 2005 2006 Revised 2006 2007 Office of the Director Actual Budget Budget Estimate Budget 320-0210 Debt Service 2301 County Auditors' Deductions $0 $0 $0 $0 $0 2610 Principal-Water and Sewer 5,000 5,000 5,000 5,000 5,000 2620 Interest-Water and Sewer 1,106 750 750 738 369 TOTALS $6,106 $5,750 $5,750 $5,738 $5,369 321-0210 Debt Service 2301 County Auditors' Deductions 106 50 50 50 50 2612 Principal-Transportation 75,000 75,000 75,000 75,000 80,000 2622 Interest-Transportation 51,435 47,115 47,115 47,115 42,720 TOTALS $126,541 $122,165 $122,165 $122,165 $122,770 322-0210 Debt Service 2301 County Auditor Deductions 26 25 25 62 25 2612 Principal-Transportation 65,000 65,000 65,000 65,000 65,000 2622 Interest-Transportation 64,096 62,245 62,245 62,244 60,229 2791 Advances 0 0 0 8,285 0 TOTALS $129,122 $127,270 $127,270 $135,591 $125,254 -207- THIS PAGE LEFT BLANK INTENTIONALLY CITY OF DUBLIN., 15 General Capital Improvements STATEMENT OF FUNCTIONS: This fund was created by City Council and has as its express purposes: the purchase of equipment, apparatus, property, construction of buildings, structures, roads and other public improvements as needed. City income tax collections are directly credited to this fund each year in accordance with Ordinance No. 17-87. Additional revenue is provided by transfers from the General Fund and interest income. NOTES AND ADJUSTMENTS: In accordance with State requirements, separate funds will be established when notes bonds are issued for specific projects and the associated expenditures will also be assigned to that fund. Funding is based on the 2007-201 l Capital Improvements Program. Several significant projects are funded in the 2007 budget: COIC Improvement Fund The Central Ohio Innovation Center (COIC) Fund has been established to account for the infrastructure improvements determined necessary for the development of the COIC. In 2005/2006 the City began design and right-of--way acquisition related to the US33/SR161/Post Road interchange improvements. In 2007 construction will be initiated. Annual Street Maintenance Propr.~m This is an annual allocation for repairing the City's roadways. Avery Road widening-Phase 1 Phase 1 has been identified as the roadway from Shier Rings Road to Woerner Temple Road. An OPWC grant application will be submitted in the fall of 2006 for Phase 1. In 2007, the construction of a roundabout at Tuswell Drive and the roadway widening for the roundabout is programmed. Villa eg P_kwy/Shamrock Blvd extension (TIF) This allocation provides for the extension of Shamrock Boulevard from its present northern temunis to Village Parkway. Riverside Dr/SR161 (TIF) This project provides for additional turn lanes and an upgrade to the existing traffic signal and streetscape improvements. Design for this project is programmed in 2007. Municipal Facilities This allocation is to address near-term space needs for the City's facilities until such time that a new municipal building is built. The construction of the future Municipal Building is not programmed in the 2007-2011 CIP. Eiterman Road extension-south of Woerner Temple Road This project provides for the continued extension of Eiterman Road from Woerner Temple Road to Rings Road. The allocation for 2007 is part of the City's contribution to the project which is shared with Hilliard Schools. Emerald Fields (N.E. Ouad Park) This project provides for the development of the park in accordance with the completed Master Plan. Construction of the ball diamonds is allocated in 2007. Avery Park The 2007 allocation for this park is for rebuilding ball diamonds #3 and #4 and the tennis courts. Vehicle and equipment storage facility This allocation will be utilized to construct a cold storage building at 6351 Shier Rings Road. This facility will be used to store vehicles and equipment and protect them from the weather. CIP -249- 12/11/06 2007 Budget -City of Dublin, Ohio Capital Improvements Tax Development Economic Development 2005 Actual 2006 2006 2006 Budget Revised Budget Estimate 2007 Budget 401-0314 Other Expenses 2790 Transfers 5,021,675 5,900,000 5,986,910 5,975,000 8 401 310 2791 Advances 3,534,340 0 0 2,027,937 , , 2.250.000 8,556,015 5,900,000 5,986,910 8,002,937 10,651,310 Capital Outlay 2510 Land & Land Improvements 1,066,514 250,000 965,000 950,000 200 000 2511 Park & Bikeway Imp. 1,747,742 2,303,000 3,908,469 3,523,469 , 2 134 000 2522 Police Capital Equip. 361,376 358,000 468,000 468,000 , , 67 000 ~~ 2523 City Maint. Equipment 688,346 1,187,000 1,516,385 1,016,385 , 738 000 2530 Bldgs. & Other Structures 38,428 500,000 529,102 29,102 , 1 950 000 2550 Street Maint. Projects 4,290,122 6,604,000 10,015,616 9,000,000 , , 6 482 000 2562 Storm Sewer Imp. 976,348 1,125,000 1,359,672 534,672 , , 1 125 000 2571 Computer Hardware/Softwn 756,795 1,091,000 1,341,243 1,341,243 , , 1 187 300 2572 Building Repairs & Renova 493,167 385,525 507,495 507,495 , , 104 700 2573 Utility Burial 2,848,550 0 554,350 554 306 , p , 2579 Other Projects 1,800 200,000 200,000 , 200,000 850 000 „~ 2599 Contingencies 56,647 225,000 225,000 125,000 , 225,000 13,325,835 14,228,525 21,590,332 18,249,672 15,063,000 TOTALS $21,881,850 $20,128,525 $27,577,242 $26,252,609 $25,714,310 -210- 2007 Budget-City of Dublin, Ohio Capital Improvement Tax Capital 401-0314 Capital Outlay 2510 Land and Land Improvements Land Acquisition $200,000 2511 Park and Bikeway Improvements Park renovations/improvements 159,000 Avery Park 450,000 Davis log cabin 90,000 Kiwanis Boardwalk extension 45,000 Darree Fields Development 290,000 DCRC Hvac 400,000 Emerald Fields (NE Quad Park) 700,000 2522 Police Capital Equipment Bi-directional amplifiers for schools 15,000 New/replacement speed trailers 22,000 Portable surveillance system (carryover from 2006) 30,000 2523 City Maintenance Capital Projects Fleet management program-replacements 420,000 Fleet management program-equipment 253,000 Guardrail replacement 65,000 2530 Buildings and Other Structures Vehicle and equipment storage facility 400,000 Municipal facilities 1,550,000 2550 Transportation Projects Annual street maintenance program 2,347,000 Annual roadside improvements 85,000 Annual bikeway maintenance 40,000 Bikeway connections/additions 30,000 Annual sidewalk program 125,000 Riverside Drive overlay-SR 161 to north limits (in State Highway Fund) 0 Dublin Road overlay-SR 161 to Glick Road (in State Highway Fund) 0 Avery Road widening-Phase 1 3,100,000 $200,000 2,134,000 67,000 738,000 1,950,000 -211- ., 2007 Budget-City of Dublin, Ohio Capital Improvement Tax Capital 2550 Transportation Projects(continued) Eiterman Road extension-south of Woerner Temple Rd 685,000 Avery-Muirfield Dr.North Corridor-Hospital ramp 70,000 6,482,000 2562 Stormwater Improvements Annual Storm Sewer maintenance 300 000 Stormwater improvements , 825,000 2570 Other Projects & Equipment 1,125, 000 2571 Computer hardware/software 1,187 300 2572 Building repairs and renovations , 104 700 2579 Synthetic Turf at Dublin high schools , 100 000 2579 Veterans project , 250 000 2579 Historic Dublin , 500,000 2,142,000 2599 Contingencies 225,000 2710 Transfers 225,000 Land Acquisition Fund 500,000 Debt 7,901,310 2791 Advances 8,401,310 Village Pkwy/Shamrock Blvd. extension 1,500 000 Riverside Drive/ SR 161 (TIF) , 350,000 Sawmill Rd/Hard Rd intersection (TIF) 400,000 2,250,000 TOTAL $25, 714,310 -212- ., 16 Parkland Acquisition Fund STATEMENT OF FUNCTIONS: Chapter 152 of the Codified Ordinances of Dublin provides for the payment of fees in lieu of parkland dedication. These fees are credited to the parkland Acquisition Fund for the purpose of acquiring recreational facility sites, open space and/or parkland. NOTES AND ADJUSTMENTS: Funding programmed for 2007 is based on the 2007-2011 Capital Improvements Program (CIP). One ofCity Council's goals for 2001 was to identify a process to set aside additional funds to preserve undeveloped land. As a means of accomplishing this goal, the City's "inside millage" from property taxes is credited to the Parkland Acquisition Fund. This practice is reviewed each year as a part of the tax budget process. In 2007, as reflected in the 2007 - 2011 CIP, the City will allocate .95 mills of the total 1.75 mills to the Parkland Acquisition Fund, and the remaining .80 mills to the Capital Improvements Tax Fund. ParkAcq -213- 12/ I 1 /06 2007 Budget-City of Dublin, Ohio Parkland Acquisition 2006 Finance 2005 2006 Revised 2006 2007 Office of the Director Actual Budget Budget Estimate Budget 402-0210 Other Expenses 2349 Other Professional Services $0 $0 $4,500 $4,500 $0 2791 Advances 0 0 0 0 0 0 0 4,500 4,500 0 Capital Outlay 2510 Land and Land Improvements 1,560,065 3,072,000 4,167,500 3,098,965 3,420,000 402-0219 (miscellaneous} Other Expenses 2301 County Auditor Deductions 32,296 25,000 34,000 31,000 30,000 402-0314 Transfers 2790 Transfers 528,816 587,065 587,065 560,100 584,410 TOTALS $2,121,177 $3,684,065 $4,793,065 $3,694,565 $4,034,410 -214- 17 Public Service/ Water Maintenance STATEMENT OF FUNCTIONS: This program is under the joint supervision of the Directors of Public Service, Streets and Utilities, and Engineering. Under this work program falls the budgeting and fiscal control function, planning and design of all new construction and improvements of the water distribution system which is tied to the City of Columbus system under a service contract. The Administration works in cooperation with architects, engineers, consultants, builders, and developers in planning improvements to the Dublin portion of the system. Also included is the hydrant maintenance program. OBJECTIVES AND ACTIVITIES: Continue the ongoing hydrant maintenance program in-house with a significant cost savings. Prepare hydrants for repainting and continue the ongoing maintenance of hydrants. Locate all watch valves. PERSONNEL DATA POSITION TITLE Maintenance Worker Seasonal Maintenance Worker TOTAL NOTES AND ADJUSTMENTS: 2006 2007 CURRENT NUMBER ADOPTED 2 1 2 2 4 3 Ten percent (10%) of the operations administrator position reflected in the Sewer Fund is allocated to this budget. Thirty percent (30%) of a crew supervisor is also charged to this budget based on actual time worked in this area. One maintenance worker position has been transferred to the solid waste budget to reflect actual time worked in each area. Water -215- 12/ 11!06 2007 Budget -City of Dub lin, Ohio Water Public Service ~~ Streets and Utilities 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 610-1320 Personal S ervices -. ~: 2110 Salaries/V1/ages 109,283 113,125 128,125 128,000 74,325 . 2111 Overtime Wages 13,819 3,000 6,000 6,000 3,000 2112 Other Wages 28,243 40,000 32,000 30,000 32,450 2120 Employee Benefits 48,004 52,425 57,425 52,100 33,675 2140 Uniforms & Clothing 2,511 4,750 5,114 3,300 2,200 201,860 213,300 228,664 219,400 145,650 Other Expenses „~, 2201 Conferences/Mileage 406 1,500 1,500 500 1,500 2303 Hydrant Maint. & Repair 74,480 69,400 64,842 50,350 75,000 2310 Utilities 83,754 84,000 100,512 .93,550 110,000 2320 Communications 299 900 900 500 300 , 2351 Maint. of Equipment 550 10,000 10,000 2,000 5,000 :. 2390 Misc Contractual Services 765 600 600 500 60,000 2420 Operating Supplies 22,554 55,200 45,403 40,000 14,400 ,,, 2440 Small Tools & Minor Equip 4,769 6,000 6,000 5,000 4,000 2910 Refunds 62,752 10,000 20,000 20,000 10,000 250,329 237,600 249,757 212,400 280,200 ' Capital Outlay 2520 Equipment & Furniture 0 0 0 0 0 0 0 0 0 0 TOTALS $452,189 $450,900 $478,421 $431,800 $425,850 ~" -216- 2007 Budget -City of Dublin, Ohio Water Fund 2006 Finance 2005 2006 Revised 2006 2007 Office of the Director Actual Budget Budget Estimate Budget 610-1210 Debt Service 2610 Principal 215,000 230,000 230,000 230,000 220,000 2620 Interest 165,807 152,850 152,850 152,850 138,760 610-0314 Other Expenses 2791 Advances 933,900 0 0 283,000 p Water Fund Administrative Services Facilities 610-1940 Capital Outlay 2530 Buildin & Other Structures 19 758 0 0 0 0 TOTALS $1,334,465 $382,850 $382,850 $665,850 $358,760 -217- Public Service/ Water Maintenance „~ BUDGET SUMMARY: 610-1320 "' • Account 2112 includes funding for seasonal maintenance workers. • Account 2310 provides funding for utility costs related to the operation of the water system. • Account 2390 provides funding for flushing and pumping of hydrants completed by the Washington Township Fire Department. 610-1210 • Accounts 2610 and 2620 provide funding for debt service obligations for the Rings RoadBlazer Parkway Water Tower bond issue. Water -218- 12/11/06 2007 Budget -City of Dublin, Ohio Water Public Service Engineering 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 610-1330 Personal Services 2110 Salaries/Vllages 8,020 10,100 10,100 6,400 13 950 2120 Employee Benefits 2,125 2,675 2,675 1,800 , 4,650 10,145 12,775 12,775 8,200 18,600 Other Expenses 2201 Conferences/Mileage 2349 Other Professional Serv 2351 Maint. of Equipment 1,214 2,000 2,000 1,000 2,000 70,960 50,000 51,222 40,000 50,000 0 500 500 0 500 72,174 52,500 53,722 Capital Outlay 2520 Equipment & Furniture 2561 Water System Imp. 0 0 4,000 280,312 200,000 248,534 41,000 52,500 3,400 0 65.000 4.690.000 280,312 200,000 252,534 68,400 4,690,000 TOTALS $362,631 $265,275 $319,031 $117,600 $4,761,100 -219- Public Service/ Water Maintenance Budget Summary: • Accounts 2110 and 2120 provide funding for the allocation of a civil engineer position. • Account 2349 provides funding to maintain the computer modeling program developed during the Community Plan process. This program is used to track water pressure and identify system needs. • Account 2561 provides funding as identified in 2007-2011 CIP for the construction of a new water tower, water tower maintenance, water line oversizing and water system improvements. ~~; Water -220- 12/ 11 /06 18 Pnblic Service/ Sewer Maintenance STATEMENT OF FUNCTIONS: This work program is under the joint supervision of the Directors of Public Service, Streets and Utilities, and Engineering. This work program includes the budgeting and €iscal control function, planning and design of all new construction, improvements and removal of infiltration and inflow sources. Streets and Utilities are responsible for the execution of maintenance on the entire sanitary sewer system, and also conducts inspection of lines and collects data on the system for use by Engineering. Engineering analyzes system data to estimate amounts of extraneous flow to be eliminated, reconvnends the repair and work program and new construction to be performed. The City staff works in cooperation with homeowners, engineers, consultants, builders, developers, Ohio Environmental Protection Agency, and with the City of Columbus which provides wastewater treatment and a service contract. OBJECTIVES AND ACTIVITIES: • To minimize infiltration and inflow in both the public and private portions of the sanitary sewer system. • To assess condition of subsurface infrastructure underlying streets which are programmed for resurfacing in order that repairs be made as part of the street resurfacing program. • To provide a safe work environment for all employees and ensure the safety of the public. • To update the computer modeling program for the sewerage system. PERSONNEL DATA 2006 2007 POSITION TITLE CURRENT NUMBER ADOPTED Engineering Project Inspector Operations Administrator 1 1 Crew Supervisor ] l Maintenance Worker 6 5 Seasonal Maintenance Worker 1 1 TOTAL 10 9 NOTES AND ADJUSTMENTS: The operations administrator position is allocated 84% to this budget to reflect actual time spent in this area. One maintenance worker position has been transferred to the solid waste budget to reflect actual time spent in that area. Fifty percent (50%) of a crew supervisor position is allocated to this budget to reflect actual time spent in this area. Sewer -221- 12/ 11 /06 2007 Budget -City of Dublin, Ohio Sewer Public Service Streets and Utilities 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 620-1320 Personal Services 2110 Salaries/VVages 320,704 368,925 361,925 351,900 2111 Overtime Wages 29,136 30,000 40,000 40,000 2112 Other Wages 7,829 17,500 14,500 12,000 2120 Employee Benefits 127,460 156,700 156,700 150,700 2140 Uniforms & Clothing 6,728 8,825 9,453 6,900 !~4 349,450 30,000 16,225 -~~ 152, 300 5,200 491,857 581,950 582,578 561,500 553,175 Other Expenses ,; 2201 Conferences/Mileage 9,678 10,050 5,040 4,050 17,650 2310 Utilities 63 500 500 0 500 2320 Communications 449 2,150 2,150 550 1,800 ~.. 2349 Other Professional Serv 292,722 150,000 140,000 101,400 75,000 2351 Maint. of Equipment 8,311 13,250 13,250 13,000 32,300 2390 Misc Contractual Services 67,585 42,000 52,342 40,400 83,500 2410 Office Supplies 2,971 4,000 4,154 3,600 3,000 2420 Operating Supplies 11,076 20,350 20,686 10,100 11,800 2430 Repair & Maintenance 9,321 500,000 523,412 430,000 159,000 2440 Small Tools & Minor Equip 5,127 12,000 13,330 6,700 4,000 2910 Refunds 75,720 10,000 20,000 19,400 15,000 483,023 764,300 ~ 794,864 629,200 403,550 Capital Outlay 2520 Equipment & Furniture 302 2563 Sanitary Sewer Imp. 0 1,000 0 371,000 0 371,000 0 142,370 0 302 1,000 371,000 371,000 142,370 °~ TOTALS $975,182 $1,347,250 $1,748,442 $1,561,700 $1,099,095 -222- ~. 2007 Budget -City of Dublin, Ohio Sewer Finance Office of the Director 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 620-1210 Debt Service 2614 Principal-Sewer 588,881 619,965 619,965 619,965 837,300 2624 Interest-Sewer 452,562 598,050 598,050 598,050 513,425 1,041,443 1,218,015 1,218,015 1,218,015 1,350,725 TOTALS $1,041,443 $1,218,015 $1,218,015 $1,218,015 $1,350,725 -223- Public Service/ Sewer Maintenance BUDGET SUMMARY: 620-1320 • Account 2201 includes funding for the training of personnel in accordance with Occupational Safety and Health Administration (OSHA) requirements. • Account 2349 includes funding for services related to televising and cleaning the sewer system. ~ Account 2351 includes funding to maintain and repair sewer equipment. • Account 2390 includes funding for the pump station maintenance contract, Delaware County Engineering Fund, contracted fees to dump sewer trucks, and contracted storm sewer repairs. • Account 2420 is funding for supplies necessary for doing in house sewer cleaning and repairs. • Account 2430 provides funding for the repair and maintenance of the sewer system including grades rings, ground rims/covers, precast concrete inlets, bioxide treatments, and a contingency amount for unforeseen repairs to the sewer system. All major contracted repairs of the sewer system have been transferred to the CIP account. • Account 2520 provides funding for additional equipment needed in the sewer budget including flow tote bands and monitors, remote camera locater, sewer easement machine, easement camera system, and replacement air monitors. The increase in 2006 was the result of purchasing a sewer vactor truck. 620-1210 • Accounts 2614 and 2624 provide funding for debt service obligations related to the Upper Scioto West Branch Interceptor. .,> Sewer -224- 12/ 11 /06 2007 Budget -City of Dublin, Ohio Sewer Public Service Engineering 2005 2006 2006 2006 2007 Actual Budget Revised Budget Estimate Budget 620-1330 Personal Services 2110 Salaries/Wages 74,901 84,075 84,075 76,700 92,900 2111 Overtime Wages 1,409 750 4,750 600 800 2120 Employee Benefits 25,226 30,100 30,100 24,350 34,300 2140 Uniforms & Clothing 0 500 500 0 500 101,536 115,425 119,425 101,650 128,500 Other Expenses 2201 Conferences/Mileage 198 2,000 2,000 500 2,000 2349 Other Professional Serv 108,099 125,000 151,432 88,050 125,000 2390 Misc Contractual Services 0 5,000 5,000 0 5,000 2420 Operating Supplies 0 10,000 10,000 500 10,000 108,297 142,000 168,432 89,050 142,000 Capital Outlay 2563 Sanitary Sewer Imp. 1,117,699 1,375,000 1,380,390 1,276,450 2,050,000 1,117,699 1,375,000 1,380,390 1,276,450 2,050,000 TOTALS $1,327,532 $1,632,425 $1,668,247 $1,467,150 $2,320,500 -225- Public Service/ Sewer Maintenance Budget Summary: • Accounts 2110 and 2120 provide funding for the allocation for a civil engineer position and for the engineering project inspector. • Account 2349 provides funding to maintain the computer modeling program developed during the Community Plan process. This program will be used to identify system improvements for future programming in the CIP. • Account 2420 provides funding for chemicals used to mitigate odor. • Account 2563 provides funding as identified in 2007-2011 CIP. to include sanitary sewer improvements, sewer lining and repairs, and sewer line oversizing. Sewer -226- 12/ 11 /06 ~~ 19 Community Relations STATMENT OF FUNCTIONS: Ordinance 11-93 authorized the establishment of the Merchandising Fund. Dublin merchandise is available for resale. The revenue from the sale of the merchandise is used to purchase merchandise, as the intent of the merchandising campaign is to be self-supporting. Merck -227- 12/11/06 ,. 2007 Bu dget -City of Dublin, Ohio s Merchandising City Manager Community Relations 2005 2006 2006 2006 2007 ~ Actual Budget Revised Budget Estimate Budget , 630-1130 Other Expenses ,„ 2390 Misc Contractual Services 591 100 400 300 300 ., 2420- Operating Supplies 8,174 10,000 9,700 6,250 9,700 2910 Refunds 123 0 0 0 0 8,888 10,100 10,100 6,550 10,000 ,, TOTALS $8,888 $10,100 $10,100 $6,550 $10,000 -228- r: Community Relations BUDGET SUMMARY: • Accoifit 2390 is an allocation for estimated sales tax payments to the State of Ohio. • Account 2420 provides funding to buy merchandise for resale. Merch -229- 12/11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITY t1F DUBLIN.. 20 Internal Service /Employee Benefits Self-Insurance STATEMENT OF FUNCTIONS: The Employee Benefits Self-Insurance Fund has been established to account for monies received from other funds as payment for providing medical, dental and vision benefits. The Employee Benefits Self-Insurance Fund makes payments for services provided to employees (claims), the third party administrator(s) and for stop-loss coverage. The budgeted amounts are based on the expected dollar value of claims that would be paid under the plan, third party administrator fees, and the premium for stop-loss insurance. "Premiums" are charged to benefit accounts based on the estimated cost of coverage as determined by the third party administrator. The Employee Benefits Self-Insurance Fund will provide a new Wellness benefit and a Flexible Spending Account benefit for non-union personnel and communications technicians in 2007. NOTES AND ADJUSTMENTS: The monthly funding level ("premium equivalent") for 2007 is $1,071 ($12,852/year) for family coverage and $411 ($4,932/year) for single coverage for non-union personnel and communications technicians. The monthly funding level ("premium equivalent") for 2007 is $422 ($5,064/year) for single coverage and $1,143 ($13,716/year) for family coverage for personnel represented by the Fraternal Order of Police (police officers and sergeants) and United Steel Workers of American (maintenance and custodial workers, and mechanics . This fund contains $65,000 for a new comprehensive wellness benefit that will combine active wellness programming with third party administration services. Included in this total is funding for the health risk assessment, on-site health screenings and health coaching. Also funded is the current Wellworks program and $20,450 to cover 1/3 of the salary/wages for the Fitness/Wellness Supervisor at the Recreation Center. IntServ -231- 12/ 11 /06 2007 Budget -City of Dublin, Ohio , Emp. Benefits Self Ins. ~° City Manager , Human Resources 2005 2006 2006 2006 2007 . Actual Budget Revised Budget Estimate Budget 701-1120 ~,,. Personal Services 2110 Salaries/VVages 0 18,000 18,000 18,000 18,000 2120 Employee Benefits 0 2,450 2,450 2,450 2,450 0 20,450 20,450 20,450 20,450 Other Expenses 2309 Third Party Admin. 229,889 241,000 241,000 241,000 265,000 2361 Medical,Dental,Rx,Vision 3,384,227 3,210,000 3,660,000 3,660,000 3,850,000 2364 Stop Loss Coverage 211,803 250,000 283,198 208,000 243,500 2390 Misc Contractual Services 66,473 92,700 102,510 102,500 128,200 3,892,392 3,793,700 4,286,708 4,211,500 4,486,700 ~- TOTALS $3,892,392 $3,814,150 $4,307,158 $4,231,950 $4,507,150 ` ~. -232- Internal Service/ Employee Benefits Self Insurance BUDGET SUMMARY: • Account 2110 and 2120 funds salary and benefit costs associated with the City's wellness program, specifically the fitness/wellness coordinator. These expenses will reflect actual hours allocable to this program. • Account 2309 reflects funding for third-party administration fees from United Health Care (UHC), Envision Rx and EBMC, the administrator of the City's new flexible spending programs and vision services benefit. • Account 2364 provides funding for astop-loss insurance policy to protect the City against catastrophic or extraordinarily high cost claims. • Account 2390 includes funding for the City's new comprehensive wellness benefit. Funding is included for continuation of the comprehensive health risk assessment, on-site screenings and health coaching. Also funded is continuation of professional benefits consultation; in 2007, continuation of return on investment analysis, and further review of plan design is anticipated. IntServ -233- 12/ 11 /06 THIS PAGE LEFT BLANK INTENTIONALLY CITI' DF DUBLIN.. Internal Service/ Workers' Compensation Fund STATEMENT OF FUNCTIONS: The Workers' Compensation Fund has been established to cover the costs associated with the City's Workers' Compensation coverage under aself-insurance plan. Funds are transferred from the General Fund to cover premiums, claims, and third party administration fees associated with the City's Workers' Compensation coverage. NOTES AND ADJUSTMENTS: This budget reflects estimated costs for the City's Self-Insurance Workers' Compensation coverage which includes expected medical expenses and compensation associated with work-related injuries and illnesses from January 1, 2007-December 31, 2008. This budget also reflects estimated fees for excess workers' compensation insurance coverage and volunteer insurance coverage. IntServ -235- 12/11/06 2007 Budget -City of Dublin, Ohio Workers' Comp. Self Ins. City Manager Human Resources 2005 2006 2006 2006 2007 ~~ Actual Budget Revised Budget Estimate Budget 703-1120 ~,~, Other Expenses 2309 Third Party Admin. 7,416 42,565 42,565 14,500 25,725 2363 Claims 0 131,860 131,860 35,000 220,000 '~" 2364 Stop Loss Coverage 128,494 662,439 662,439 450,000 311,700 2390 Misc Contractual Services 0 4,000 4,000 0 4,000 135,910 840,864 840,864 499,500 561,425 ~~ . TOTALS $135,910 $840,864 $840,864 $499,500 $561,425 . ~. ~- Sid- evs4 ". Ns5 Vii- -236- Interna} Service/ Workers' Compensation Fund BUDGET SUMMARY: Account 2309 includes the administrative fee for the self-funded program, independent medical evaluations of injured employees, and administrative fees for unemployment compensation and the state tail fund. Account 2363 reflects the estimated claims expenses for 2007 as aself-funded program. Account 2364 includes the estimated premium payment to OBWC for the first three months of 2006, prior to the start of the self-funded program, as well as the required payment to the state guarantee fund and the state fee for aself-insured plan. Also included are the excess coverage premium and volunteer coverage premium. IntServ -237- 12/ 11 /06 ., THIS PAGE LEFT BLANK INTENTIONALLY CITE' nF DUBLIN.. ~: 21 Fiduciary Funds STATEMENT OF FUNCTIONS: These funds reflect the cost of reimbursing developers for the cost of installing certain public improvements (water & sewer reimbursement), for refunding permit bonding fees deposited with the City to ensure completion of a project. A specific agency fund has been established for the collection of taxes on behalf of the Dublin Convention & Visitor's Bureau, the collection and distribution of a building surcharge mandated by State law and for the collection and distribution of income tax revenues that are required, by Revenue Sharing Agreements, to be shared with the Dublin City School District. NOTES AND ADJUSTMENTS: Agency -239- 12/ I 1 /06 2007 Budget-City of Dublin, Ohio Fiduciary Funds 2006 Finance 2005 2006 Revised 2006 2007 Office of the Director Actual Budget Budget Estimate Budget Income Tax. Revenue Sharing 802-0210 2390 Contractual Obligation-CRAs 891,210 1 182,000 1 274 863 1 274,863 1 248 000 TOTALS $891,210 $1,182,000 $1,274,863 $1,274,863 $1;248,000 Agency Fund 805-0210 2304 Sewer Tap Paybacks 839,350 600,000 1,020,000 939 500 700 000 2305 Water Tap Paybacks 0 0 0 , , 2307 Project Maintenance Bonds 0 5,000 3,900 0 2 000 0 5 000 2910 2914 Refunds Refunds-Conditional Occupancy 8,823 359 100 3,000 300 000 11,000 3 , 10,850 , 5,000 2916 Refunds-BD of Bldg Standards , 21,175 , 12,000 80,000 23,000 351,250 20 000 300,000 12 000 2917 Refunds-CRC Deposits 21,863 20,000 23,100 , 20 450 , 20 000 2919 Refunds- Theatre Admissions 534 2,000 1,000 , 0 , 1 000 2921 Refunds-Vendor Bonds 2,000 2,000 2,000 1 500 , 1 500 2923 Refunds-Washington Twp 1,575 2,000 2,000 , 1 000 , 1 000 2924 Refund-Hydrant Permit 1 900 2 000 1 000 , 1 000 , 1 000 TOTALS $1,256,320 $948,000 $1,467,000 $1,347,550 $1,046,500 Dublin Convention and Visitors Bureau 804-0211 2824 Payment to Dublin Convention & Visitors Bureau $521,881 $480,000 $562,714 $554,300 $480,000 TOTALS $521,881 $480,000 $562,714 $554,300 $480,000 -240- 2007 OPERATING BUDGET -CITY OF DUBLIN GLOSSARY OF TERMS While not inclusive, this glossary is provided to assist the reader with definitions of some unfamiliar terms used in the budget document. Accrual Basis - a basis of accounting in which transactions are recognized at the time they are incurred or obligated, rather then when cash is received or spent. Agency fund - a type of fiduciary (trust) fund used to account for assets held by the City as an agent for individuals, other governments and/or other funds. Appropriation -authorization from the legislative authority (City Council) to expend funds for a specific purpose or category of purposes. Appropriations are for the current fiscal year, and lapse at the end of the fiscal year if not obligated for a specific purpose. Bond Rating - a measure of the City's credit-worthiness determined by established outside agencies by reviewing the City's financial viability and practices. A high bond rating results in favorable interest rates when the City borrows funding for long term capital projects. Budget -the financial operating plan for a given time period which provides estimates of expenditures and revenues for that time period and outlines the assumptions under which those estimates were made. Budget Calendar -the schedule of key dates that are followed in the preparation and adoption of the budget. Budgetary basis -the basis under which the budget estimates are made. Capital Asset (as defined by the City of Dublin) -tangible property that has a cost or dollar value of $50 or more, and has a useful life of five (5) years or more. Capital Outlay - a category of expenditures that includes items greater than a certain value and/or expected to last for greater than a specified time period. Capital Improvements Program (CIP) -five-year plan for infrastructure and other long term investments such as roadways, technology, vehicles, parks, etc. Capital Improvements Tax Fund - represents the 25% of the local income tax collected for the purpose of funding capital improvements. Capital Projects Fund - are used to account for the financial resources to be used for the acquisition or construction of major capital facilities other than those financed by Proprietary Funds and Trust Funds. Capital Project - a major construction, acquisition, or renovation activity that adds value to or significantly increases the useful life of the government's physical assets. Cash basis - a basis of accounting or budgeting in which transactions are recognized only when cash is increased or decreased. -241- 2007 OPERATING BUDGET -CITY OF DUBLIN Cemetery Fund - a fund provided to account for revenue received from the sale of cemetery lots and interment fees. Expenditures are restricted to the maintenance of the City's cemeteries. Cemetery Perpetual Care Fund -established in order to set aside funds so that when all the City's cemetery burial lots are sold, there are funds remaining to properly maintenance all cemetery lots in perpetuity. City Charter - a document ratified by a vote of the people that outlines the guidelines and policies under which a city will operate. Council-Manager form of government -the form of government in which an elected City Council hires a professional city manager to serve as the chief administrative official for the City, as opposed to an elected mayor. Contingency - a budgeted reserve set aside for emergencies or unforeseen expenditures not otherwise included within the budget. Debt Service -the cost of paying principal and interest on borrowed funds according to a predetermined schedule. Dublin Convention and Visitors Bureau Fund -accounts for 25% of the tax imposed on ~,; establishments that provide sleeping accommodations for transient guests and is due to the Dublin Visitors and Convention Bureaus as required by state law. , Employee Benefits Self-Insurance Fund -includes monies received from other funds as payment for providing medical, dental and vision benefits. The Employee Benefits Self- Insurance Fund may make payments for service provided to employees, for reimbursements to employees who have paid providers, to third party administrators for claim payment or ' administration, for stop-loss coverage, or any other similar purposes. Encumbrance -the commitment of appropriated funds to purchase an item or service; to encumber funds means to commit them for a specified future expenditure. Enforcement and Education Fund -provided to account for revenue received from penalties assessed in accordance with violations involving Section 4511.19, Ohio Revised Code. Expenditures are restricted to educating the public of laws governing the operation of a motor vehicle while under the influence of alcohol and other information relating to the operation of a motor vehicle and the consumption of alcoholic beverages. Enterprise fund -used to account for operations that are financed and operated in a manner similar to private business enterprises -where the intent is the costs of providing goods or services to the _.. public on a continuing basis be financed or recovered primarily through user charges. „a Expenditure - the payment for goods or services; in a cash -based budget such as the City of '"`y Dublin's, expenditures are recognized only when the cash payment for the cost of goods received or services rendered is made. Fiscal Year -the twelve-month period designated as the operating year for accounting and budget purposes; in the case of the City of Dublin, January 1 -December 31, or calendar year. -242- 2007 OPERATING BUDGET -CITY OF DUBLIN Full -Time Equivalent (FTE) -represents an employee working a standard 40-hour workweek, or its equal in terms of hours comprised of more than one employee Fund -the basis on which governmental accounting system are organized; an independent financial and accounting entity with aself-balancing set of accounts in which transactions relating to resources, expenditures, assets and liabilities are recorded. Funds are established to account for the use of restricted revenue sources and to carry on specific activities. General Fund -the general operating fund used to fund public services used to account for all financial resources except those required to be accounted for in another fund. General Obligation Debt -debt backed by the full faith, credit and taxing power of a government. General Obligation Debt Service Fund -accounts for the accumulation of resources and payment of general obligation bond principal and interest from governmental resources. Grant - a contribution by a government or other entity to support a particular function Home rule -the term used to describe the powers of municipal corporations operating under a charter which provides for or authorizes a method of procedure in the passage and publication of legislation, the making of improvements, and the levying of assessments differing from the method prescribed by general law, may pass and publish such legislation, make such improvements, and levy such assessments under the general law or in accordance with the procedure provided for or authorized by its charter. Hotel Motel Tax Fund -fund into which taxes derived from hotel room stays (bed taxes) are deposited; this fund accounts for 75% of the tax imposed on establishments that provide sleeping accommodations for transient guests. Expenditures are restricted to the advancement of cultural development, beautification of public property, improvement of the historic district and any other project or expenditure which would enhance the City's appeal to visitors and tourists. Income Tax Revenue Sharing Fund -fund into which income taxes to be shared with Dublin City Schools in conjunction with certain economic development agreements are deposited for payment to the schools. Infrastructure -the physical assets of a government, including but not limited to public buildings, streets, curbs and traffic control devices, water and sewer facilities, and parks and public lands. Internal service fund -used to account for the financing of goods or services provided by one department or agency of the City to other departments or agencies on acost-reimbursement basis. Charges are intended only to recoup the total cost of such services Lapse of appropriation -the expiration of appropriation authority at the end of the fiscal year if it is neither expended nor encumbered for a specific purpose. Law Enforcement Trust Fund -accounts for all cash or cash proceeds that are a result of contraband property seizures and forfeitures of property. -243- >,:. 2007 OPERATING BUDGET -CITY OF DUBLIN Mandatory Drug Fine Fund -includes revenue from mandatory fines imposed for drug offense convictions in accordance with Section 2925.03, Ohio Revised Code. Expenditures are restricted to law enforcement efforts pertaining to drug offenses. Mayor's Court Computer Fund -represents an additional fee collected for computerization of the Mayor's Court in accordance with Ohio Revised Code Section 1901.261. Merchandising Fund - fund for receipts from sales of Dublin-related merchandise and related costs. Operating Expenditure - a costs of personnel, materials, services and equipment required for a City unit to function. Operating Revenue -income received by the government to pay for ongoing operations, including items such as taxes, fees for services, investment earnings, grant revenues, etc. Operating Transfer - an amount moved from one fund to another to support the funding of services in the recipient fund. Parkland Acquisition Fund -created to account for property taxes and development fees collected for the purpose of funding acquisition of recreational facility sites, open space, and/or parkland. Permissive Tax Fund -accounts for permissive tax fees received in addition to the motor vehicle license tax. Expenditures are restricted to construction or permanent improvements of the streets and state highways within the City. Personal Services - a category of expenditures that represents the amounts paid for all costs associated with personnel, including wages and benefits paid by the City. Policy - a guiding principal which defines the underlying rules which will direct decision-making processes. Program - a group of related activities intended to accomplish a specific objective. Recreation Fund -created to account for revenues and expenditures for parks and recreation programs and activities, including the Community Recreation Center. Reserve - funds set aside that are earmarked for a specific future use. Revenue -sources of income received during a fiscal year, operating transfers from other funds, and other financing sources such as the proceeds derived from the sale of fixed assets. Safety Fund -accounts for revenues and expenditures for the operations of the City's Police Department. Major revenue sources are property taxes and subsidies from the General Fund. Service Payment -payment made in lieu of real estate taxes for purposes of retiring debt for improvements in a designated tax-increment financing (T1F) district. -244- ~„ 2007 OPERATING BUDGET -CITY OF DUBLIN Sewer Fund -provided to account for capacity charges for connecting into the sewer system and the costs associated with the maintenance and repair of the City's sewer lines. Special Assessment Debt -debt issued for a specified purpose and based. on collection of taxes levied against apre-determined set of properties for that purpose. Special Assessment Debt Service Fund - provided to account for the accumulation of resources and payment of special assessment bond principal and interest from special assessment levies with governmental commitment. Special Revenue Fund -used to account for the proceeds of specific revenue sources (other than expendable trusts or major capital projects) that are legally restricted to expenditures for specified purposes. State Highway Improvement Fund -provided to account for the allocation of revenues derived from motor vehicle license fees and gasoline taxes. Expenditures are restricted by state law to maintenance and repair of state highways within the City. Street Maintenance and Repair Fund -provided to account for the allocation of revenues derived from motor vehicle license fees and gasoline taxes. Expenditures are restricted by state law to maintenance and repair of streets within the City. Swimming Pool Fund- includes revenues and expenditures for outdoor swimming pool programs and activities at both outdoor facilities, excluding the capital cost of the swimming pool. Tax-increment financing (TIF) - A method used for funding public improvements whereby real estate tax revenue increases resulting from those improvements are directed toward paying for those improvements Unencumbered Balance - the remaining balance within a fund that is not obligated for any other purpose. User fee (or charge) -the payment of a fee for direct receipt of a public service by the party who benefits from the service. Water Fund -provided to account for the collection of a user surcharge, permit fees and the costs associated with the maintenance and repair of the City's water lines. Workers' Compensation Self-Insurance Fund -fund for the accumulation of funds to insure the claims portion of the state administered workers' compensation system. -245- THIS PAGE LEFT BLANK INTENTIONALLY CITY ~F UUBLTN.. ., ~;..