08 book special rev 2011 budget

8/2/2019 08 Book Special Rev 2011 Budget

1/73

City of South Euclid 2011 Budget Workpapers

SPECIAL REVENUE FUNDS

OPERATION HOME IMPROVEMENT - FUND 103/104

County Reimbursements

County Grants-Other 103-4000-44120 $850

Nuisance abatements - County 103.4000.44121 14,091

GNI Grant Revenue 103.4000.44122 415,272

Grants- miscellaneous 103-4000-44199 1,695

Nuisance abatements 103.5000.45351 19,322

Community Garden 103.8000.48117 1,318

HUD Dollar Program 103.8000.48155 19,027

Total $471,574

Unencumbered Balance 1/1/11 $150,7842011 Certified Estimated Revenues 0

Nuisance abatements 65,000

GNI Grant 384,728

Sale of houses-GNI grant 260,000

2011 Appropriations are not to exceed: $860,512

current budget $515,406

Revenues Received in 2010

This fund is the grant program by the County that reimburses the City for nuisance abatements. The City invoiced the property owner for

expenses incurred by the City. The County does not require the City to reimburse them. Therefore we will have additional money for future

abatements. This fund also includes various grants for the purpose of home improvements.

Fund #104 was combined with #103 in 2010.

10/12/2011


2/73


ending balance $345,106

10/12/2011


3/73




Actual Actual Actual Actual Budget

2007 2008 2009 2010 2011

Personal Services $0 $0 $0 $0 $0

Materials and Supplies 0 0 0 0 0

Contractual Services 0 0 0 0 164,906

Other Charges 87,653 59,101 257,408 523,957 350,500

$87,653 $59,101 $257,408 $523,957 $515,406

10/12/2011


4/73




BudgetCONTRACTUAL SERVICE 2011

GNI Grant Expense (new 2011) 52352 $164,906

$164,906


OTHER CHARGES 2007 2008 2009 2010 2011Auditor/Treasurer Collection fees 52358 $5,920 $191 $500

Abatement of Nuisances 52738 $87,653 $59,101 $257,408 $508,766 $350,000

Return of Temporary Advance 9910-52902 $110,000 $15,000

TOTALS $87,653 $59,101 $257,408 $523,957 $350,500

10/12/2011


5/73



COPS GRANT - FUND 106

State - Aggressiving Driving Reimbursement $0

Funded Aggressive Driving Grant (completed) 0Total $0

Unencumbered Balance 1/1/11 $0

0

2011 Appropriations are not to exceed: $0

current budget $0

ending balance $0

Revenues Received in 2010:

This Fund is used to account for various grant activity that benefit the Police Department. In the past it has accounted for the COPS

Fast Grant and the COPS Universal Hiring Grant, both of which allowed the hiring of additional Community Policing Officers. In

2001, a category was created to account for the activities resulting from the Aggressive Driving Grant received from the State. This

Fund can be used to account for future grants which benefit the Police Department.

10/12/2011


6/73



COPS GRANT - FUND 106


2007 2008 2009 2010 2011

Personal Services $0 $0 $0 $0 $0


Contractual Services 0 0 0 0 0

Other Charges 162 290 255 907 0

$162 $290 $255 $907 $0

10/12/2011


7/73



COPS GRANT - FUND 106.1110


2007 2008 2009 2010 2011

Personal services

Wages part time permanent 52103 $0

Police Pension 52151 0

Workers Compensation 52163 0

Medicare 52153 0

TOTALS $0 $0 $0 $0 $0

Other

Equipment 52743 162 290 255 907 0

COPS Grant

TOTALS $162 $290 $255 $907 $0

10/12/2011


8/73



COMMUNITY DIVERSION PROGRAM - FUND 107

Community Diversion Program 107.4000.44135 $460

Refunds 107.8000.48102

Reimbursements 107.8000.48108

Total $460

Unencumbered Balance 1/1/11 $1,993

Revenues from County 0

Juvenile Accountability Grant 107.4000.44130 50,000

Fines generated from program (approximate) 0




The Community Diversion Program was funded by utilizing a State grant awarded in 1999. The fund accounts for the qualifying

expenses incurred to administer the City's Community Diversion Program (established in 1998). The original grant expired in 2000. In

2001 the Cuyahoga County Juvenile Court funded the program for six months. For 2010, we have currently do not havea commitment

from the County to assist funding the program.

10/12/2011


9/73


ending balance $68

10/12/2011


10/73





2007 2008 2009 2010 2011

Personal Services $16,471 $12,832 $10,184 $716 $25

Materials and Supplies 347 0 0 $222 0


Other Charges 5,530 490 3,014 0 50,000

$22,348 $13,322 $13,197 $938 $51,925

10/12/2011


11/73





Personal 2007 2008 2009 2010 2011

Wages part time permanent - 1110 52103 $11,760 $11,022 $8,513 $477

P.E.R.S. - 1110 52150 $797 $1,649 $1,273 $78

Medicare - 1110 52153 $87 $160 $185 $7

Workers Compensation - 1110 52163 381 0 212 154 25

Total Personal - 1110 16,471 12,832 10,184 716 25

Wages part time permanent - 1130 52103 $291 $0

P.E.R.S. - 1130 52150 $41 $0

Medicare - 1130 52153 $4 $0

Workers Compensation - 1130 52163 0

Total Personal - 1130 0 336 0 0 0

TOTAL PERSONAL 716 25

Supplies 52421 $347 $222

Total Materials & Supplies 347 0 0 $222 $0

Schools 52701 $0 $0 $0

Conferences/meetings 52703 $2,651 $0 $3,014 $0

Juvenile Accountability Grant 52709 50,000

Program Expenses 52722 $213 $490 $0 $0

Return of Temporary Advance

Total Other Charges 5,530 490 3,014 0 50,000

TOTALS $22,348 $13,322 $13,197 $938 $50,025

CONTRACTUAL SERVICES 2007 2008 2009 2010 2011

Other contractual services 1110 52398 $1,90010/12/2011


12/73


TOTALS $0 $0 $0 $0 $1,900

10/12/2011


13/73



STREET CONSTRUCTION & MAINTENANCE - FUND 202

** Pursuant to passage of Ordinance 19-97

MVL fees 202.2000.42113 109,554$

Gasoline tax 202.2000.42114 580,646

Street openings/repairs 202.5000.45252 28,507

Animal Control Service 202.5000.45259 12,636

Miscellaneous 202.2000.45301 -

Salt sales 202.2000.48153 7,966

Advance from Gen fund 202.9000.49102 -

Total 739,309$

Unencumbered Balance 1/1/2011 70,052$

2011 Certified Estimated Revenues 680,000

Reimbursement for Animal warden 6,000

Advance from General fund 25,000

2011 Appropriations are not to exceed: 781,052$


ending balance 10,524$

Sources of revenue are 92 1/2% of all gasoline tax and auto license fees** returned to the City by the State of Ohio. The amount

received is determined by the number of auto license registrations in the City.

Under State law, this fund must be used only for street maintenance and repairs. This fund, therefore, helps to pay the cost of

operating our Service Department since those wages and expenses attributable to street maintenance may be paid out of this fund.

For example, wages and related fringe benefits of snow plowing, patching and other maintenance may be paid from this fund.


10/12/2011


14/73



STREET CONSTRUCTION & MAINTENANCE - FUND 202


2007 2008 2009 2010 2011

Personal Services $613,721 $632,044 $630,004 $588,039 $593,528

Materials and Supplies 249,511 235,514 178,049 111,851 142,000

Contractual Services 38,479 29,601 21,490 24,955 34,750

Other Charges 4,503 8,561 1,037 0 250

$906,214 $905,720 $830,580 $724,845 $770,528

10/12/2011


15/73



STREET CONSTRUCTION & MAINTENANCE - FUND 202.6630


PERSONAL SERVICES 2007 2008 2009 2010 2011

Wages full time 52101 $421,012 $408,646 $422,325 $383,450 $381,704

Wages Part Time permanent 52103 $2,181 $0 $0 $0 $0

Overtime 52106 39,728 44,096 25,698 28,522 $31,000

Sick Leave Incentive 52109 1,206 531 1,078 $1,600

Commercial Drivers License 52115 1,500 2,000 2,000 2,250 $2,000

P.E.R.S. 52150 63,095 74,742 63,026 55,796 $58,003

Medicare 52153 3,401 5,148 5,427 5,597 $6,007

Medical insurance 52160 47,681 58,711 73,909 77,925 $76,188

AFSCME insurance 52161 17,968 19,710 19,710 17,520 $17,568

Workers Compensation 52163 8,624 9,028 8,298 7,990 $10,358

Uniform maintenance 52171 5,456 4,106 4,299 4,582 $4,700

Boot Allowance 52172 1,575 3,150 3,150 2,800 $2,800

OSHA 52173 1,500 1,500 1,630 529 $1,600

TOTALS $613,721 $632,044 $630,004 $588,039 $593,528

10/12/2011


16/73




Hire Longevity 2010 Budget

Name or Position date amount Wages Wage/hr Wages Hosp 2011family/single

0

DiGeronimo, Nick 10/21/91 1,675 22.39 22.39 46,571 service-family 46,774

Johnson, Jonathan 9/9/02 850 22.39 22.39 46,571 service-single 46,812

Manfroni, Dave 10/3/83 1,675 22.39 22.39 46,571 service-family 46,812

Miller, Brian 9/19/02 850 22.39 22.39 46,571 service-family 49,000

Rudyk, Jim 3/13/00 1,125 23.56 23.56 49,005 service-family 49,187

Sumlin, Willie 10/8/90 1,425 22.39 22.39 46,571 service-family 46,785

Thompson, Al 5/16/88 1,675 18.62 18.62 38,730 service-single 39,135

Valente, Ray 10/29/96 1,125 22.39 22.39 46,571 service-single 46,799

0

wages 367,162 371,304 371,304longevity 10,400 0 10,400 10,400

52101 381,704

Part Time Employees 00 0

52105 0 0

Overtime 52106 0 29,000 31,000Sick leave incentive 52109 1,600

Benefit wage base 414,304# of employees Rate

Comm drivers license 52115 8 250 2,000Boot allowance 52172 8 350 2,800

2011

10/12/2011


17/73


medicare = 1.45% 6,007

P.E.R.S. at 14% $58,003

AFSCME 52161 8 183 $17,568

Hospitalization:

serv family 5 serv single 3

cash option $100.00 per emp per month 0 0

: Service Family $1,046.00 per emp per month 62,760

: Service Single $373.00 per empl per month 13,428

76,188 76,188

Workers' Comp at 2.5000% of benefit wage base 10,358Non Service Life Insurance per employee per month 0

Dental (Safety) per employee/depend per month 0

Uniform maintenance 52171 4,700

10/12/2011


18/73






Electricity -Traffic Signal 52301 $16,227 $14,913 $16,560 $17,859 $19,000

Telephone 52304 $271 $330 $444 $453 $500

Other Communication Expense 52315 4,344 4,806 3,616 3,541 3,750

Drug tests 52333 0 0 0 0

Bridge Expense (new 2007) 52375 2,700 4,000 120 1,116 1,500

Traffic light maintenance 52378 14,147 4,802 0 1,987 10,000

Outside labor 52396 0 0 0 0

Other contractual services 52398 790 750 750 0 0

TOTALS $38,479 $29,601 $21,490 $24,955 $34,750


MATERIALS AND SUPPLIES 2007 2008 2009 2010 2011

Equipment Maintenance supplies 52426 1,327 4,965 0 0 0

Street maintenance supplies 52427 19,005 20,883 24,969 24,829 25,000

StreetTraffic Signal supplies 52429 0 0 0 0 0

Sign Shop Supplies 52430 2,456 1,429 1,284 883 2,000

Salt 52431 116,950 83,000 65,438 (3,041) 0

Gas and Oil 52432 $109,773 $125,237 $86,358 $89,180 $115,000

TOTALS $249,511 $235,514 $178,049 $111,851 $142,000


OTHER CHARGES 2007 2008 2009 2010 2011

School 52701 4,153 3,161 1,012 0 0

Equipment 52743 350 4,900 0 0 0

Misc. Charges 52799 0 500 25 0 250

Return of Advance 52799 0 0 0 0 0

TOTALS $4,503 $8,561 $1,037 $0 $25010/12/2011


19/73



STATE HIGHWAY - FUND 203

** Pursuant to passage of Ordinance 19-97

MVL fees 203.2000.42113 $101

Gasoline tax 203.2000.42114 55,861

Total $55,962






7 1/2% of all gasoline tax and auto license registration fees** are returned to the City by the State of Ohio. These are the only source

of revenues for this fund.


Generally used for the same purpose as the Street Construction, Maintenance, and Repairs Fund, except that the work and materials

used must be for the maintenance of State highways in the City. In South Euclid, Mayfield Road is a state route.

10/12/2011


20/73



STATE HIGHWAY - FUND 203


2007 2008 2009 2010 2011

Personal Services $41,018 $61,312 $42,440 $0 $0

Materials and Supplies 2,000 12,000 0 67,954 46,200


Other Charges 0 0 0 0 0

$43,018 $73,312 $42,440 $67,954 $46,200

10/12/2011


21/73



STATE HIGHWAY - FUND 203.6640



Wages full time 52101 $27,592 $39,148 $36,087 $0

Overtime 52106 $1,319 $1,984 $7 $0

Sick Leave Incentive 52109 $0 $453 $0

Commercial Drivers License 52115 0 250 250 0

P.E.R.S. 52150 3,396 6,831 4,344 0

Medicare 52153 275 588 285 0

Medical insurance 52160 8,436 9,492 (1,581) 0

AFSCME insurance 52161 1,077 2,190 1,643 0

Workers Compensation 52163 723 829 754 0Uniform maintenance 52171 0 197 0

Boot Allowance 52172 175 350 175 0

TOTALS $41,018 $61,312 $42,440 $0 $0

10/12/2011


22/73






0

0 00 00 00 00 00 00 00 00 00 0 0

Part Time Employees 00 00 00 0 0

Overtime 0 0 0

Total Longevity 0.00

Benefit wage base 0

medicare = 1.45% 0

P.E.R.S. at 14% $0

2010

10/12/2011


23/73


Hospitalization:

serv family 0 serv single 0

:Service Family $1,046.00 per emp per month 0:Service Single $373.00 per empl per month 0

0 0

Workers' Comp at 2.5000% of benefit wage base 0

Non Service Life Insurance per employee per month 0


10/12/2011


24/73


10/12/2011


25/73





MATERIALS AND SUPPLIES 2007 2008 2009 2010 2011Street maintenance supplies 52427 0 0 0 0

Salt 52431 $2,000 $12,000 0 67,204 45,000

Miscellaneous 52499 0 0 750 1,200

TOTALS $2,000 $12,000 $0 $67,954 $46,200

10/12/2011


26/73



PARKING LOTS & PARKING METERS - FUND #205

Expenses of this fund are wages, and costs for cleaning and maintenance of such lots.

Lot #1 Cedar Center 205.5000.45311

Lot #2 Rushton 205.5000.45312

Maintenance - County Receipts 205.5000.46313

Refunds 205.8000.48102

Transfers from General Fund 205.9000.49101 20,000

Total $20,000


2011 Certified Estimated Revenues

Transfers from General Fund



ending balance $579


Income from parking meters and court fines imposed on parking violations are revenues credited to this fund. Collections are made

weekly from Lot 1 (Cedar Center) and Lot 2 (Mayfield and Green Roads). Parking fines are collected by the Court on behalf of the

City.

10/12/2011


27/73



PARKING LOTS & PARKING METERS - FUND #205


2007 2008 2009 2010 2011

Personal Services $9,453 $2,233 $27 $0 $0



Other Charges 1,566 6,238 0 618 1,000

$66,353 $70,076 $42,345 $16,874 $39,000

10/12/2011


28/73



PARKING LOTS & PARKING METERS - FUND #205.6650



Wages part time permanent 52103 $7,890 1,434 0 0 0

Sick Leave Incentive 52109 0 0 0 0

Commercial Driver License 52115 0 0 0 0 0

P.E.R.S. 52150 373 340 0 0

Medicare 52153 36 21 0 0 0

Medical insurance 52160 0 0 0 0 0

AFSME insurance 52161 0 0 0 0 0

Life insurance 52162 0 0 0 0 0

Workers Compensation 52163 407 167 27 0

Uniform maintenance 52171 747 271 0 0

Boot Allowance 52172 0 0 0 0 0

TOTALS $9,453 $2,233 $27 $0 $0

10/12/2011


29/73



PARKING LOTS & PARKING METERS - FUND #205.6650



Electricity lot lights 52301 4,077 11,572 12,848 13,779 15,000

Other Communication Expense 52315 131 143 60 36 0

Auditor/treasurer fees 52358 17 5 0 0 0

Maintenance & repair 52370 $452 $471 $0 $0 $0

Snow Removal 52389 4,816 0 0 0 0

Real estate taxes 52397 42,803 45,245 26,637 0 20,000

TOTALS $52,296 $57,436 $39,545 $13,814 $35,000



Postage 52404 2,959 2,908 2,773 2,442 3,000

Operating supplies 52421 79 158 0 0 0

Equipment Maintenance supplies 52426 0 1,104 0 0 0

TOTALS $3,038 $4,170 $2,773 $2,442 $3,000


OTHER CHARGES 2007 2008 2009 2010 2011

Equipment 52743 $1,487 $6,238 $0 $0

Miscellaneous 52799 79 0 0 618 1,000

TOTALS $1,566 $6,238 $0 $618 $1,000

10/12/2011


30/73



SWIMMING POOLS - FUND #206

Miscellaneous Revenues 206.5000.45401 758

Pool passes 206.5000.45402 $45,800

Photo I.D. income 206.5000.45403 0

Tickets - Bexley 206.5000.45404 16,529

Tickets - Victory 206.5000.45405 3,489

Tickets- Splash Park 206.5000.45406 2,228

Swimming lessons 206.5000.45407 9,900

Pool Rental 206.5000.45410 1,020

Concessions - Bexley 206.5000.45411 0

Concessions - Quarry 206.5000.45412 0

SELRec 206.5000.45415 2,496

Total User Charges 82,220

Transfers-In from the General Fund 206.9000.49101 270,000

Total All Revenues $352,220



Transfers from General Fund 235,000



Income from passes sold, learn-to-swim and daily admission fees. An operating transfer is made annually from the General

Fund to subsidize operations. Additional revenue is derived from a percentage of concession sales.

Costs are salaries for swim pool personnel and related costs plus expenditures for maintaining and operating a safe pool

operation. Other expenses include the cost of a service employee that prepares the pools opening, including minor repair,

painting and general maintenance.


10/12/2011


31/73



10/12/2011


32/73



SWIMMING POOLS - FUND #206


2007 2008 2009 2010 2011Personal Services $198,028 $208,930 $193,597 $162,973 $202,874



Other Charges 9,557 7,144 13,690 10,994 17,600

$304,882 $328,423 $315,554 $264,402 $324,074

10/12/2011


33/73



SWIMMING POOLS - FUND #206.3320


PERSONAL SERVICES 2007 2008 2009 2010 2011Wages Part Time seasonal 52105 154,592 163,779 164,704 138,579 172,000

Concession Wages 52107 14,111 14,080 0 0 0

Sick Leave Incentive 52109 0 0 0 0

P.E.R.S. 52150 23,365 24,900 23,059 19,401 24,080

Medicare 52153 2,446 2,563 2,388 2,008 2,494

Workers Compensation 52163 3,514 3,608 3,446 2,985 4,300

TOTALS $198,028 $208,930 $193,597 $162,973 $202,874

10/12/2011


34/73






0

00 00 0

Pool manager-Pete Titus 8,000 8,0000 00 0

0 00

0 0164,000 164,000

Part Time Employees 0 172,0000 00 00 0 0

Overtime 0 0 0

Total Longevity 0.00

Benefit wage base 172,000

medicare = 1.45% 2,494

P.E.R.S. at 14% $24,080

2010

10/12/2011


35/73


Hospitalization:

total family 0 total single 0

:Non Service Family $1,223.00 per emp per month 0:Non Service Single $437.00 per empl per month 0

0 0

Workers' Comp at 2.5000% of benefit wage base 4,300



10/12/2011


36/73





CONTRACTUAL SERVICES 2007 2008 2009 2010 2011Electricity 52301 26,695 33,647 36,161 33,231 37,000

Natural Gas 52302 11,031 23,613 13,635 5,597 15,000

Water 52303 12,884 11,939 18,970 20,786 22,000

Telephone 52304 3,556 1,700 3,283 4,280 5,000

Personnel Hiring (new 2006) 52356 2,126 2,483 2,185 2,500 2,500

Maintenance & repairs 52370 5,080 2,635 6,854 901 3,000

SELREC 52394 7,500 7,725 7,957 9,306 0

Other contractual services 52398 2,603 3,270 3,239 4,000

TOTALS $68,872 $86,345 $92,316 $79,841 $88,500



Postage 52404 37 67 100

Operating supplies 52421 $16,716 $15,098 15,914 10,528 15,000

Concession Supplies 52451 11,709 10,906 0 0 0

TOTALS $28,425 $26,004 $15,951 $10,594 $15,100


OTHER CHARGES 2007 2008 2009 2010 2011

Training 52704 $500 $1,362 $1,385 $1,245 $1,500

Refunds 52716 25 60 0 0 100

Pool Painting 52728 0 0 2,083 0 3,000

Recreation improvements 52729 0 3,456 3,256 4,000

Equipment 52743 7,006 3,443 4,956 3,838 4,000

Miscellaneous 52799 $2,026 $2,279 $1,811 $2,655 $5,000 10/12/2011


37/73


TOTALS $9,557 $7,144 $13,690 $10,994 $17,600 0

splash park open 6/08

check ulities for 2012

10/12/2011


38/73



PERMISSIVE MOTOR VEHICLE TAX - FUND #207

Permissive Tax Receipts 207.2000.42115 $128,079

Immobilization/Vehicle Fee 207.6000.46139 $0

Advances in 207.9000.49102 $0

Total $128,079






The Permissive Motor Vehicle Fund accounts for additional motor vehicle registration fees designated for maintenance and

repair of streets within the City.


10/12/2011


39/73



PERMISSIVE MOTOR VEHICLE TAX - FUND #207


2007 2008 2009 2010 2011Personal Services $0 $0 $0 $0 $0




$200,000 $149,999 $109,903 $130,000 $130,000

10/12/2011


40/73



PERMISSIVE MOTOR VEHICLE TAX - FUND #207.6630


CONTRACTUAL SERVICES 2007 2008 2009 2010 2011Repairs by Contractor $0 $0 $0 $0

TOTALS $0 $0 $0 $0 $0



Salt 52431 $209,980 $137,930 $109,903 $130,000 $130,000

TOTALS $209,980 $137,930 $109,903 $130,000 $130,000


OTHER CHARGES 2007 2008 2009 2010 2011

advances out 9920-52902 60000

Return of Advance 52799 0 0 0

0 0 0 0

10/12/2011


41/73



HUD GRANTS - CITY STREETS - FUND #215

Federal Revenue $0

Total $0

Unencumbered Balance 1/1/11 $0

2011 Certified Estimated Revenues 0


The HUD Grants - City Streets Fund accounted for the grant the City received in 2001 from the Department of Housing and

Urban Development through Cuyahoga County for the purpose of resurfacing Victory Drive. For 2003, the City received a

grant to resurface Prasse.


10/12/2011


42/73









$0 $0 $0 $0 $0

10/12/2011


43/73





CONTRACTUAL SERVICES 2007 2008 2009 2010 2010Repairs by Contractor 54000 $0 $0 $0 $0

Inspections 54100 0 0 0 0

Return of Temporary Advances 59900 0 0 0 0

TOTALS $0 $0 $0 $0 $0

10/12/2011


44/73



POLICE RANGE FUND # 220

ARRA Stimulus money 220.4000.44107 $0

Criminal Nuisance Fine 220.6000.46132 $12,788

False Alarm Fines 220.6000.46133 $1,743

miscellaneous police income 220.8000.48140 $0

Range rental 220.8000.48206 11,325

Total $25,856



Grant2011 Appropriations are not to exceed: $43,988



The Police Range Fund was created in December 2007. Its purpose will be to accumulate funds deriving from range rental fees and a

percentage of criminal nuisance and false alarm abatements. The revenues collected will be used to maintain and improve the firing

range.


10/12/2011


45/73



POLICE RANGE FUND (220)


2007 2008 2009 2010 2011Personal Services

Materials and Supplies 3,823 25,000

Contractual Services (19,872) 0

Other Charges 0 15,000

$0 $0 $0 ($16,049) $40,000

10/12/2011


46/73



POLICE RANGE FUND (220)


CONTRACTUAL SERVICES 2007 2008 2009 2010 2011Auditor/Treasurer Collection Fees 52358 351 106

Range repair 52371 134,821 (19,978)

TOTALS $0 $0 $135,172 (19,872) $0


MATERIALS AND SUPPLIES 2007 2008 2009 2010 2011Range expese / supplies 52441 $0 $3,823 $25,000

TOTALS $0 $0 $0 $3,823 $25,000


OTHER 2007 2008 2009 2010 2011

Equipment 52743 $28,300 $0 $15,000

$0 $0 $28,300 $0 $15,000

10/12/2011


47/73



LAW ENFORCEMENT TRUST - FUND #221

DUI Education Enforcement 221.4000.44133 $0

Local Highway Safety Program 221.4000.44134 0

Grant-Law Enforcement 221.4000.44136 11,837

DUI Education Enforcement 221.6000.46112 1,504

Misc Fines & Forfeitures 221.6000.46131 2,876Immobilization Fees 221.6000.46139 480

Continuing Professional Trng 221.8000.48135 800

Miscellaneous 221.8000.48144 1,802

Total $19,299

nencum ere a ance ,





The Law Enforcement Fund accounts for the resources obtained from confiscated monies from criminal offenses and designated (by statestatute) for expenditures that would enhance the Police Department.


10/12/2011


48/73



LAW ENFORCEMENT TRUST - FUND #221

Actual Actual Actual Actual Buuget

2007 2008 2009 2010 2011Personal Services $0 $0 $0 $0

Materials and Supplies 0 0 0 0


Other Charges 29,548 12,247 9,105 12,136 100,000

$29,548 $12,247 $9,105 $12,136 $100,000

10/12/2011


49/73



LAW ENFORCEMENT TRUST - FUND #221.1110


OTHER CHARGES 2007 2008 2009 2010 2011Continuing Professional Educ 52704 6,460 1,850 0

Equipment 52743 58400 0 2,938 0 11,639 50,000

Miscellaneous 52799 50100 $1,996 $2,849 $7,255 $497 $50,000

TOTALS $1,996 $12,247 $9,105 $12,136 $100,000


CONTRACTUAL SERVICES 2007 2008 2009 2010 2011Range Repair 52371 15,033 0

0 0

10/12/2011


50/73



FEMA FIREFIGHTERS GRANT - FUND #222

Federal Grant - Other 222.4000.44101 $0

FEMA Grant 222.4000.44142 $0

City match $0

Advanced from General Fund 222.9000.49102 $0

Total $0

Unencumbered Balance 1/1/11: $0



current budget $0

ending balance $0

The FEMA Firefighters Grant fund was established to account for the activity related to a grant awarded in 2001 from the Federal

Emergency Management Agency to purchase various equipment for use by the Firefighters.


10/12/2011


51/73



FEMA FIREFIGHTERS GRANT - FUND #222





Other Charges 16,120 83,663 0 49,522 0

$16,120 $83,663 $0 $49,522 $0

10/12/2011

2011 B d W k


52/73



FEMA FIREFIGHTERS GRANT - FUND #222.1120


OTHER CHARGES 2007 2008 2009 2010 2011Training 52704 0 0 0

Building improvements 52731 0 0 0

Equipment 52743 $0 $77,763 $0 $0

Miscellaneous 52799 0 0 0

Health & Wellness (Physicals) 0 0 0

EMS Grant Fund $0 $0 $0

Return of Advance 52902 0 0 49,522

TOTALS $0 $77,763 $0 $49,522 $0

10/12/2011


53/73

Cit f S th E lid 2011 B d t W k


54/73



STREET LIGHTING - #511






$394,631 $431,079 $426,839 $468,052 $496,000

10/12/2011

Cit f S th E lid 2011 Budget Workpapers


55/73



STREET LIGHTING - #511.5530


Contractual Services 2007 2008 2009 2010 2011Street Lighting Contract 52301 $393,711 $403,191 $423,223 $463,568 $490,000

Special Assessment Fees 52358 3,636 3,987 3,615 4,485 6,000

TOTALS $397,347 $407,178 $426,839 $468,052 $496,000


Other 2007 2008 2009 2010 2011

Miscellaneous 52799 0 0 2,731 0

TOTALS $0 $0 $2,731 $0 $0

10/12/2011



56/73


within the city.

Other revenues received are for sewers cleaned by our Sewer Rental Fund employees. The charge is $100.00 per cleaning.

Special Assessments 516.3000.43101 $336,849

Sewers Cleaned 516.5000.45257 19,860

Transfer from General Fund 516.9000.49101 0

Total $356,709

Unencumbered Balance 1/1/11: $50,8792011 Certified Estimated Revenues 340,000

Transfers from General Fund 0




The Sewer Rental Fund accounts for special assessment revenue that is expended for the maintenance of the sewer system

This fund was established by Ordinance 65-56 at $6.00 per year per connection. The rate was changed by Ordinance 12-78 to increase

the charge to $12.00 per connection. Ordinance 29-86 established the additional increase for the Sewer Rehabilitation Fund.

Ordinance 18-87, again, increased the total charge to $66.00; $54 for Sewer Rehabilation and $12 for Sewer Rental. Ordinance 22-91

reduced the charge back to $12 per connection, all credited to the Sewer Rental Fund. Ordinance 17-93 increased the yearly charge to

$21 per connection, and Ordinance 10-94 increased the yearly charge to $33 per connection. The anticipated revenues are

approximately $370,000 per year. These assessments appear on property tax bills.



SEWER MAINTENANCE - #516

10/12/2011



57/73



SEWER MAINTENANCE - #516 (5540)


2007 2008 2009 2010 2011Personal Services $316,049 $281,050 $265,217 $322,134 $290,356



Other Charges 1,500 2,138 599 600 2,000

$452,648 $413,708 $361,533 $423,600 $318,756

10/12/2011



58/73



SEWER MAINTENANCE - #516.5540


PERSONAL SERVICES 2007 2008 2009 2010 2011Wages full time 52101 $212,840 $173,674 $184,242 $224,916 $189,960

Overtime 52106 22,483 27,910 9,863 11,175 $12,000

Sick Leave Incentive 52109 106 565 585 $600

Commercial Drivers License 52115 1,000 1,250 1,250 1,000 $1,250

P.E.R.S. 52150 33,295 33,617 27,322 32,267 $28,358

Medicare 52153 1,921 2,879 2,795 2,921 $2,937

Medical insurance 52160 28,342 28,167 27,741 31,798 $35,256

AFSCME insurance 52161 8,280 7,300 6,570 10,950 $10,980

Workers Compensation 52163 5,434 4,305 2,922 2,708 $5,064Uniforms Maintance 52171 2,454 1,841 1,947 2,065 $2,200

Boot Allowance 52172 1,400 1,050 1,400 1,750 $1,750

TOTALS $316,049 $281,050 $265,217 $322,134 $290,356

10/12/2011



59/73






Carlo, John 4/1/2008 17.95 37,336 service-single 37,777

Hruska, Jim 10/25/1999 1,125.00 23.84 49,587 service-family 49,160

Kocevar, Bill 5/6/1991 1,425.00 22.39 46,571 service-family 46,285

Spears, Darren(3 months moved to 10/27/1997 1,125.00 22.39 11,643 service-single 13,000Wilk , Jim 5/22/06 850.00 18.62 38,730 cash 39,213

0wages 183,867 185,435 185,435longevity 4,525 4,525 4,525

52101 189,960

Part Time Employees 00 00 0

Overtime 52106 12,000 12,000 12,000

Sick leave incentive 52109 0 0 600

Benefit wage base 202,560# of employees rate

Comm drivers license 52115 5 250 1,250Boot allowance 52172 5 350 1,750

medicare = 1.45% 2,937

P.E.R.S. at 14% $28,358

2011

10/12/2011



60/73


AFSCME 52161 5 183 $10,980

Hospitalization:

serv family 2 serv single 2cash option $100.00 per emp per month 1 1,200

:Service Family $1,046.00 per emp per month 25,104

:Service Single $373.00 per empl per month 8,952

35,256 35,256

Workers' Comp at 2.5000% of benefit wage base 5,064



Uniform maintenance 52171 2,200

10/12/2011



61/73





CONTRACTUAL SERVICES 2007 2008 2009 2010 2011Other Communication Expense 52315 345 376 231 159 400

Engineering/Inspections 52326 0 0 0 0 0

Auditor/Treasurer Collections 52358 3,348 3,649 3,280 3,349 4,000

Sewer maint-contrctr(moved to 426 52374 122,864 114,906 89,300 75,575 0

Video Taping of Sewers 52381 5,675 8,200 0 10,000 10,000

TOTALS $132,232 $127,131 $92,812 $89,084 $14,400

Actual Actual Actual Actual BudgetMATERIALS AND SUPPLIES 2007 2008 2009 2010 2011

Landscape supplies 52424 $2,867 $3,389 $2,906 $3,800 $4,000

Equipment Maint and Materials 52426 0 0 0 0 0

Sewer Maintnance Supplies 52428 5,153 9,554 7,204 7,983 8,000

TOTALS $2,867 $3,389 $2,906 $11,783 $12,000


OTHER CHARGES 2007 2008 2009 2010 2011

Memberships/dues 52705 0 0 0 0

Retention Basin Maintenance 52735 0 0 0 0 1,000

Equipment 52743 1,500 2,138 599 600 1,000

TOTALS $1,500 $2,138 $599 $600 $2,000

TOTAL OTHER $28,400 10/12/2011



62/73

City of South Euclid g p p

The balance available in this fund at December 31, 2009 was $ 1,250.75

Total $0

Unencumbered Balance 1/1/11: $1,251




ending balance $0

In order to comply with regulations set down by the Northeast Ohio Regional Sewer District and the U.S. and Ohio Environmental

Protection Agency, the City of South Euclid decided to implement the hydro-brake system. The Sewer Rehabilitation Fund was created in

1987, and reduced in 1991. The total revenues collected for this fund were $2,285,489. There were reimbursements collected in this fund

totaling $229,028. A transfer of $350,000 was approved by City Council on November 8, 1993 to the Escrow Account for Mayfield Road

Reconstruction Project.


SEWER REHABILITATION - #517


10/12/2011



63/73

y g p p








$0 $0 $0 $0 $1,251

10/12/2011



64/73

y g p p




CONTRACTUAL SERVICES 2007 2008 2009 2010 2011Sewer Maintnance 52374 $0 $0 $0 $0 $1,251

TOTALS $0 $0 $0 $0 $1,251

10/12/2011



65/73

y


POLICE PENSION - FUND 614

Real Property Taxes 614.1000.41102 $103,951

Personal Property Taxes 614.1000.41103 $11110% Rollback 614.2000.42102 $10,487

2.5% Rollback 614.2000.42103 $2,181

Homestead 614.2000.42104 $4,347

Total $121,077






Ohio State Law provides for the mandatory collection of a portion of Police and Fire Pension contributions throught the property tax

collected by the County. The City of South Euclid pension liability is greater than what is collected through this revenue source, so the

difference is made up from the General Fund.


10/12/2011



66/73


POLICE PENSION - FUND 614





Other Charges 76 62 724 1,600 2,000

$145,076 $80,062 $158,224 $140,600 $137,000

10/12/2011



67/73


POLICE PENSION - FUND 614.1110

Actual Actual Actual Actual BudgetCONTRACTUAL SERVICES 2007 2008 2009 2010 2011

Police Pension 52393 $145,000 $80,000 $157,500 $139,000 $135,000

Accrued liabilty payment(new 2012) 52393

TOTALS $145,000 $80,000 $157,500 $139,000 $135,000


OTHER CHARGES 2007 2008 2009 2010 2011

Auditor/Treasurer collection fee 52358 $76 $150 $724 $1,600 $2,000TOTALS $76 $62 $724 $1,600 $2,000

10/12/2011



68/73


FIRE PENSION - FUND 615

Real Property Taxes 615.1000.41102 $103,951

Personal Property Taxes 615.1000.41103 $111

10% Rollback 615.2000.42102 $10,4872.5% Rollback 615.2000.42103 $2,181

Homestead 615.2000.42104 $4,347

Total $121,077






Ohio State Law provides for the mandatory collection of a portion of Police and Fire Pension contributions throught the property taxcollected by the County. The City of South Euclid pension liability is greater than what is collected through this revenue source, so the

difference is made up from the General Fund.


10/12/2011



69/73


FIRE PENSION - FUND 615.1120





Other Charges 76 62 724 1,600 2,000

$145,076 $120,062 $120,724 $143,600 $131,500

10/12/2011



70/73


FIRE PENSION - FUND 615.1120

Actual Actual Actual Actual BudgetCONTRACTUAL SERVICES 2007 2008 2009 2010 2011

Fire Pension 52393 $145,000 $120,000 $120,000 $142,000 $129,500

Accrued liability payment(new 2012) 52393

TOTALS $145,000 $120,000 $120,000 $142,000 $129,500


OTHER CHARGES 2007 2008 2009 2010 2011

Auditor/Treasurer Collection fee 52358 $76 $150 $724 $1,600 $2,000TOTALS $76 $62 $724 $1,600 $2,000

10/12/2011



71/73


SICK LEAVE BENEFIT - FUND #926

General Fund Transfer 926.9000.49101 50,000

Total $50,000


2011 Certified Estimated Revenues-Transfer from General Fund 50,000




The Sick Leave Benefit Fund was established in order to provide an opportunity to accumulate the funds required to fund the current and

future accrued liability of sick leave earned but not used by employees. It is funded through operating transfers from the General Fund.


10/12/2011



72/73


SICK LEAVE BENEFIT - FUND #926


2007 2008 2009 2010 2011Personal Services $11,799 $21,222 $42,877 $0 $70,000




$11,799 $21,222 $42,877 $0 $70,000

10/12/2011



73/73


SICK LEAVE BENEFIT - FUND #926.7790


PERSONAL SERVICES 2007 2008 2009 2010 2011Sick Leave Benefit Fund 52116 $11,799 $21,222 $42,677 $0 $70,000

Medicare 52153 $201 $0 $0

TOTALS $11,799 $21,222 $42,877 $0 $70,000

08 book special rev 2011 budget

Documents