10 book capital projects - 2013 budget

7/28/2019 10 Book Capital Projects - 2013 Budget

1/37

City of South Euclid 2012 Budget Workpapers

CAPITAL PROJECTS

GENERAL IMPROVEMENT & REPAIR - FUND #408

NOPEC grant-Mayfield Rd street lights 408.4000.44152 46,428

Energy Conservation Grant 408.4000.44156 0

Grants-Miscellaneous 408.4000.44199 0

Refunds 408.8000.48102 0

Insurance reimbursements 408.8000-48103 110,049

Playground of Possibilities 408.8000.48115 7,416Miscellaneous 408.8000.48999 6,068

OAQDA Loan proceeds 408.9000.49107 374,441

Transfers In from the General Fund 408.9000.49101 235,000

Total $779,402

Unencumbered Balance 1/1/13 $2,436

2013 Certified Estimated Revenues

Donations - Playground of Possibilities

Insurance reimbursement-Playground of PossNOPEC grant - Mayfield Rd traffic lamps

OAQDA Loan proceeds

Nopec grant - OAQDA project

Transfers In from the General Fund 252,050

2013 Appropriations are not to exceed: $254,486

current budget $252,050

ending balance $2,436

Revenues Received in 2012:

3/22/2013


2/37


CAPITAL PROJECTS


Actual Actual Actual Actual Budget

2009 2010 2011 2012 2013

Personal Services $0 $0 $0 $0

Materials and Supplies 0 0 0 0

Contractual Services 265,284 296,566 1,289,268 987,356 252,050

Other Charges 0 0 0 0

$265,284 $296,566 $1,289,268 $987,356 $252,050

3/22/2013


3/37


CAPITAL PROJECTS



CONTRACTUAL SERVICES 2009 2010 2011 2012 2013

Police

Building/structures 1110.52502 60,000 0 0 2,100

Vehicles 1110.52507 15,274 63,085 49,816 51,421 0

Equipment 1110.52508 0 0 0 0

Pistol Range 1110.52515 0 0

narrow band 1110.52535 25,000 25,000 47,529 0

Fire

Building/structures 1120.52502 0 0 0 0

Vehicles 1120.52507 12,085 12,085 0 0

Equipment 1120.52508 0 0

Recreation

Land/ land improvements 3310.52501 0 0 0 0

Streets 3310.52503 0 0 0 0

Park equip & repairs 3310.52508 0 0 4,034 8,913 0

Playground 3310.52521 1,437 (35) 564,430 76 0

Pools

Building/structures 3320.52502 0 0 17,742 4,774 0

Equipment (83,000 grant) 3320.52508 6,605 216 0 100,000

Community Center

Furniture/Fixtures 3350.52407 7,743 0 0

Building/structures 3350.52502 0 0 84,875 4,325

Parking lots 3350.52505 0 0 0

Equipment 3350.52508 8,068 9,858

Computerization 3350.52516 0 0 0 1,3503/22/2013


4/37


CAPITAL PROJECTS




Building Department

4410.52502 0 0 0

Vehicles 4410.52507 8,567 8,567 0

Computerization 4410.52516 0 80 0 4,286 9,150

Economic Development

Master plan study 4430.52351 0 0 0

Community Relations

Computerization 4440.52516 1,570 0

Sewer Maintenance

Sewers 5540.52506 0 0 0

Ramblewood Sanitary Sewer 5540.52520 0 0 0

Flood Control

5550.52501 0 0 0

Service Department

Building/structures 6610.52502 0 0 0

Vehicles 6610.52507 139,190 149,172 39,198 108,160 109,000

Equipment 6610.52508 0 0 44,374 79,864

Fuel Storage 6610.52517 0 0 0

Emulsion Distribution 6610.52518 0 0 0

Computerization 6610.52516 0 0 4,939

Service Garage3/22/2013


5/37


CAPITAL PROJECTS




Consultants 6620.52354 0 0 0

Building/structures 6620.52502 0 0 0 112,549

Sewers 6620.52506 0 0 0

Equipment 6620.52508 0 0 0

Street Construction & Maintenance

Streets 6630.52503 0 0 0

Crack Sealing 6630.52504 11,528 14,987 15,000 28,163 30,000

Sidewalk repairs

Parking Lots

Parking Lots 6650.52505 0 0 0

Miscellaneous 6650.52799 0 0 0

Mayor

Vehicles 7710.52507 2,856 2,856 0

Computerization 7710.52516 1,530 0 450

Finance Department

Computerization 7730.52516 0 9,077 0 234

Court

Furniture & Fixtures 7750.52407 0 0 0

Building/structures 7750.52502 0 0 0

Equipment 7750.52508 0 0 0

Computerization 7750.52516 0 0 0

3/22/2013


6/37


CAPITAL PROJECTS




Municipal Complex

Land/ land improvements 7780.52501 0 0

Building/structures 7780.52502 0 0 45,396 4,239

Equipment 7780.52508 26,120 33,605

Telephone System 7780.52510 0 0 1,015

H.V.A.C. 7780.52511 0 0 298,516 452,696

Computerization 7780.52516 0 8,376 2,506 0

General Services

Consultants 7790.52354 0 0 28,238 36,664

Land/ land improvements 7790.52501 0 0 0

Parking Lots 7790.52505 0 0 0

Traffic signals/control devices 7790.52509 0 0 30,000

Parking Meters 7790.52512 0 0 0

City Signage 7790.52513 0 0 0

Dumpster & Enclosures 7790.52514 0 0 0

Computerization 7790.52516 0

Fuel Storage 7790.52517 0

Wireless- parks & Community Center 7790.52530 0 0 0

War Memorial 7790.52730 0 0 0

Demolition 7790.52737 0 0 0

Miscellaneous 7790.52799 0 0 0

3/22/2013


7/37


CAPITAL PROJECTS




Transfers

TOTALS $265,284 $296,566 $1,289,268 $987,356 $252,050

3/22/2013


8/37


CAPITAL PROJECTS

SAFETY FORCES VEHICLE FUND - FUND #409

Interest Income 409.7000.47102 745Miscellaneous 409.8000.48141 $0

Insurance reimbursement 409.8000.48103 $0

Reverse 911 409.8000.48514 $0

Transfer from General Fund 409.9000.49101 $0

Total $0



EMS interest -PNC Bank 1,000




This fund was established by Ordinance #08-01 to account for the accumulation of funds for the subsequent purchase of safety vehicles.

Revenue in this Fund will be derived from transfers from the General Fund in an amount not to exceed $200,000 annually.


3/22/2013


9/37


CAPITAL PROJECTS



2009 2010 2011 2012 2013

Personal Services $0 $0 $0 $0

Materials and Supplies 0 0 0 0

Contractual Services 0 0 0 0 0

Other Charges 5,876 5,414 635,799 216,875 622,000

$5,876 $5,414 $635,799 $216,875 $622,000

3/22/2013


10/37


CAPITAL PROJECTS




Bank fees (new 2012) 52359 $0 $0 $0 $0

$0 $0 $0 $0 $0


OTHER CHARGES 2009 2010 2011 2012 2013

Vehicles 52507 $0 $0 $630,385 $185,500 $162,000

Equipment (new 2012) 52743 $31,324 $52,000

Reverse 911 52713 $5,876 $5,414 $5,414 $0 $8,000

Miscellaneous 52799 $51

Transfer out 52901 $0 $400,000

TOTALS $5,876 $5,414 $635,799 $216,875 $622,000

3/22/2013


11/37

CAPITAL PROJECTS

POLICE VEHICLES & EQUIPMENT FUND -FUND 411

Transfer from General Fund 411.9000.49101 $0

Total $0



Transfer from General Fund



ending balance $0

This fund was established by Ordinance #36-09 to account for the accumulation of funds for the subsequent

purchase of Police vehicles and equipment. Revenue in this Fund will be derived from net revevue from the



12/37

CAPITAL PROJECTS


Actual Actual Actual Actual Actual Budget

2000 2009 2010 2011 2012 2013

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

Materials and Supplies 0 0 0 0 0

Contractual Services 0 0 0 0 21,589 2,077

Other Charges 0 0 0 0 0 0

$0 $0 $0 $0 $21,589 $2,077


13/37

CAPITAL PROJECTS



CONTRACTUAL SERVICE 2009 2010 2011 2012 2013

Equipment 52743 $21,589 $2,077

TOTALS $0 $0 $0 $21,589 $2,077


OTHER CHARGES 2009 2010 2011 2012 2013

Transfer out 52901

TOTALS $0 $0 $0 $0 $0


14/37


CAPITAL PROJECTS

RECREATION CONTINGENCY - FUND #418

This amount is appropriated every year in the event that City Council may approve expenditures from this fund.

Source: Transamerica Delaval, Inc. $95,000

: John & John Jr. Agresta 55,000$150,000

None $0

Total $0

Unencumbered Balance 1/1/13 $0

2013 Certified Estimated Revenues 02013 Appropriations are not to exceed: $0

This fund was established in 1985 for the purpose to provide such funds for recreation expenditures and improvements as directed by City

Council. The $150,000 was established from the sale of land owned by the City which was determined to be not functional for City use.


3/22/2013


15/37


CAPITAL PROJECTS

RECREATION CONTINGENCY - FUND #418


2009 2010 2011 2012 2013




Other Charges 0 0 0 0 0

$0 $0 $0 $0 $0

3/22/2013


16/37


CAPITAL PROJECTS

RECREATION CONTINGENCY - FUND #418.3310



Buildinds/structures 52502 0 0

Miscellaneous 52799 5,000 0

Transfers out 52901 0 0

TOTALS 0 0 0 0 0

3/22/2013


17/37


CAPITAL PROJECTS

WATER DISTRIBUTION INFRUSTRUCTURE - FUND #424

In 2009, the City of South Euclid entered into a joint economic development agreement with the City of Cleveland whereby the City of Clevelan

has assumed ownership, including capital improvement and repair responsibilities, for the public water mains within the City of South Euclid,

in return for South Euclid sharing a portion of any tax revenue that would be generated by any business that might relocate from Cleveland to

South Euclid.

Under this agreement South Euclid can elect to replace failing water mains under a municipal public bidding and contract process. The cost of th

work, including engineering and supervision, is then eligible to reimbursement by the City of Cleveland.

Water Distribution reimb 424.2000.42120 $709,602

Total $709,602



Cleveland Water Dept 1,607,622

2013 Appropriations are not to exceed: $1,764,808

current budget $1,608,556



3/22/2013


18/37


CAPITAL PROJECTS



2009 2010 2011 2012 2013



Contractual Services 0 0 2,426,396 863,431 1,608,556


$0 $0 $2,426,396 $863,431 $1,608,556

3/22/2013


19/37


CAPITAL PROJECTS


Actual Actual Actual Actual Actual Budget

CONTRACTUAL SERVICES 2000 2009 2010 2011 2012 2013

Engineering fees 52326 162,747 157,067 53,639 101,328

Inspections 52327 29,790 51,167 71,728

Contractor Fees 52328 803,314 2,239,207 758,315 1,435,000

Legal Advertising 52715 332 310 500

TOTALS $0 0 0 2,426,396 863,431 1,608,556

3/22/2013


20/37


CAPITAL PROJECTS

ROAD IMPROVEMENT & RESURFACING - FUND #425

Real Property Taxes 425.1000.41102 856,433

Personal Property Taxes 425.1000.41103 33

10% Rollback 425.2000.42102 61,208

2.5% Rollback 425.2000.42103 51,948

Homestead 425.2000.42104 26,294

Refunds 425.2000.48102 0

Suburban Watermain 425.8000.48250 0

OPWC loan proceeds 425.9000.49109 0

Transfers from General Fund 425.9000.49101 0

Total $995,916


2013 Certified Estimated Revenues 843,892

DOPWIC Loan





The source of income for this fund is the 3-Mill property tax levy which is expected to generate $535,000 in 2010. The city issued new debt

in the amount of $1,000,000 to finance road improvements in the year 2003.

3/22/2013


21/37


22/37


CAPITAL PROJECTS

ROAD IMPROVEMENT & RESURFACING - FUND #425



Outside legal fees 6630.52324 1,351 1,422 1,492 2,000

Engineer fees 6630.52326 39,924 62,738 74,428 70,333 49,285

Inspection fees 6630.52327 13,301 30,400 25,479 24,320 22,500

Contractor fees 6630.52328 546,709 201,602 1,475,322 537,786 645,000

Suburban Watermain 6630.52337 0 0

Auditor/treasurer collection fees 6630.52358 3,592 8,750 17,118 17,523 18,000

Legal Adversing (new 2010) 6630.52715 1,604 312 950 1,000

Bond Principal 8850.52601 240,000 250,000 255,300 263,500 275,000

Bond Interest 8850.52602 95,510 88,310 80,530 63,386 58,000

Note Principal 8850.52603 0 0 0 0

Note Interest 8850.52604 0 0 0

Transfer 0

TOTALS $940,387 $644,826 $1,929,981 $977,798 $1,070,785

3/22/2013


23/37


CAPITAL PROJECTS

FLOOD CONTROL - FUND #426

Special Assessments 426.3000.43101 2,074,114

Special Assess-Ramblewood 426.3000.43104 22,278Federal Funds 426.4000.44101 0

OPWC grant 426.4000.44112 0

County Grant 426.4000.44120 0

Suburban Watermain Ren 426.8000.48250 0

Transfers in 426.9000.49101 464,650

OPWC Loan Proceeds 426.9000.49109 453,337

Total Revenues Received in 2012: $3,014,379


2013 Certified Estimated Revenues 1,950,000OPWC loan proceeds

SWIF Grant 166,000

cleveland water dept

Ramblewood assessments 21,000




On December 23, 1996, City Council passed Ordinance 55-96, an Ordinance permitting the City to certify special assessments for improvingthe City sewerage system. This increased the sewer rental fee from $33 per unit to $132. These fees help pay for the first phase of the

program. Due to the time frame of assessments to the County by September, it was the desire of Council to establish the Flood Control Fund

(Ordinance 16-97) and also issue a bond anticipation note to start the program (Ordinance 13-97). In June, 2000, the Council increased the

fee per connection by $99, bringing the total to $231 a year. In 2001 an additional bond anticipation note was issued for $4,900,000 to

assist in financing major sewer projects including the City's share to the Bexley Infrastructure Project. In 2003, the principal was reduced by

$500,000. A 15 year Bond was be issued for the balance of $4,400,000.


3/22/2013


24/37


CAPITAL PROJECTS



2009 2010 2011 2012 2013



Contractual Services 2,189,237 1,749,274 2,737,718 3,742,033 2,586,713

Other Charges 0 0 0 0

$2,189,237 $1,749,274 $2,737,718 $3,742,033 $2,586,713

3/22/2013


25/37


CAPITAL PROJECTS



CONTRACTUAL SERVICES 2009 2010 2011 2012 2013Outside Legal Expense 5550.52324 1,524 1,603 1,683 2,000

Engineer fees 5550.52326 144,078 112,896 249,294 139,357 141,000

Inspections 5550.52327 45,922 25,247 56,326 71,440 34,000

Contractor 5550.52328 $1,251,907 $917,885 $1,600,262 $2,697,960 $1,532,000

Backflow devices 5550.52329 $2,000 $1,000 $0 $2,000

Consultants 5550.52354 12,571 4,500 10,000 0 5,000

Auditor / treasurer collection fees 5550.52358 19,890 20,309 19,601 20,815

Sewer Maintenance-Contractor 5550.52374 99,017 101,650 100,000

Miscellaneous 5550.52799 2,566 3,609 11,846 12,526 12,000Legal Advertising (new 2010) 6630.52715 0 675 0 1,000

Bond principal 8850.52601 325,000 340,000 344,700 356,500 371,000

Bond interest 8850.52602 128,794 119,044 86,330 84,799 79,000

Note principal 8850.52603 83,163 85,887 88,701 91,608 93,000

Note interest 8850.52604 64,216 61,491 58,677 55,771 55,000

OPWC principal 8850.52605 109,607 54,803 109,607 109,607 159,713

Other Principal 52697 0 0

Other Interest 52698 0 0

Easements (new 2006) 52720 0

Transfer- City Share Issue II Projects 0

TOTALS $2,189,237 $1,749,274 $2,737,718 $3,742,033 $2,586,713

Huntington - Sewer bond OPWC 52605

Principal-52601 371,000 Nine Mile Creek 25,600

Interest-52602 79,000 Bexley Drainage 62,372

Liberty Rd Bridge 37,800

Ohio Water Development Auth loan Whitehall Rd Bridge 9,441

Principal-52603 92,000 Argonne Rd 24,500

Interest-52604 56,000 159,7133/22/2013


26/37


CAPITAL PROJECTS

SIDEWALK IMPROVEMENT - FUND #427

Assessments Received

Total $0

Unencumbered Balance 1/1/13 $7

2013 Certified Estimated Revenues 0

Transfer from General Fund 0

2013 Appropriations are not to exceed: $7


This fund accounts for the activities associated with the City's Sidewalk Inspection program. The program is designed to provide systematic

inspection of all the sidewalks within the City's borders by inspecting specific areas each year. The revenues and expenses each year may

vary greatly and are contingent upon the size and condition of sidewalks targeted for repair/replacement.

General Fund was subject to the approval of the Tax Commissioner of the State of Ohio and Cuyahoga County Common Please Court. The

transfer has been approved by both the State Tax Commissioner and the Common Pleas Court. This money and future assesments received

will be transferred into the General Fund and this fund will be closed.

3/22/2013


27/37


CAPITAL PROJECTS



2009 2010 2011 2012 2013





$0 $0 $0 $0 $0

3/22/2013


28/37


CAPITAL PROJECTS




Engineer 52326 0

Inspections 52327 0

Contractor 52328 $0

Transfers 52901 0

Miscellaneous 52999 0

Principal - Note Payment 0

Interest on Notes 0

TOTALS $0 $0 $0 $0 $0

3/22/2013


29/37


CAPITAL PROJECTS

STANHOPE PARKING LOT - FUND #430

Assessments Received

Total $0



Transfer from General Fund 0


current budget $0



3/22/2013


30/37


CAPITAL PROJECTS



2009 2010 2011 2012 2013





$0 $0 $0 $0 $0

3/22/2013


31/37


CAPITAL PROJECTS




Engineer 52326 0

Inspections 52327 0

Contractor 52328 $0

Transfers 52901 0

Miscellaneous 52999 0

Principal - Note Payment 0

Interest on Notes 0

TOTALS $0 $0 $0 $0 $0

3/22/2013


32/37


CAPITAL PROJECTS

ISSUE II PROJECTS - #431

Reimbursements from State of Ohio

Interest on loan proceeds (City portion)

Total $0

Unencumbered Balance 1/1/13

2013 Appropriations are not to exceed: $0

current budget $0

ending balance $0

This fund accounts for the expenses related to the construction of projects financed completely or in part by Issue II awards.

In the year 2003, the Whitehall Bridge Replacement project was approved for Issue II funding. The project will be financed with a 30%

grant, 30% zero-interest, 20 year loan, and a 40% City contribution. Construction expenses are approved by the City, and then forwarded

to the State for payment on our behalf which creates a draw on our grant/loan.


In the year 2001, the Bexley-Ellison Sewer project was approved for Issue II funding. This project is being done in conjunction with the

City of Cleveland Heights. Since we are considered the lead City, we will account for the entire project and be reimbursed from Cleveland

Heights for their share. The City of South Euclid's share of the project cost (appox. $1.8 million) was funded from the issuance of Notes

in 2001.

3/22/2013


33/37


CAPITAL PROJECTS

ISSUE II PROJECTS - FUND #431


2009 2010 2011 2012 2013Personal Services $0 $0 $0 $0 $0


Contractual Services 0 0 0 464,650 0


$0 $0 $0 $464,650 $0

3/22/2013


34/37


CAPITAL PROJECTS

ISSUE II PROJECTS - FUND #431


Liberty Road Bridge Project 2009 2010 2011 2012 2013Construction $0

Engineering 0

Inspection 0

Miscellaneous 0

Transfers 0

Return of Temporary Advance 0TOTALS $0 $0 $0 $0 $0

Bexley Infrastructure Phase I 2009 2010 2011 2012 2013Construction $0

Engineering 0

Inspection 0

Miscellaneous 0TOTALS $0 $0 $0 $0 $0

Whitehall Bridge Replacement 2009 2010 2011 2012 2013

Construction

Engineering 52326 0

Inspection 52327 0Miscellaneous 0

TOTALS $0 $0 $0 $0 $0

Other 52799transfers out 52901 464,650

Total $0 $464,650 $0

3/22/2013


35/37


CAPITAL PROJECTS

LAND ACQUISITION FUND - FUND # 440

Reimbursements for expenses paid 440.8000.48104 77,307

Sale of Land 440.8000.48154 209,515

Advance from General Fund 440.9000.49102 0

BRF CRF Loan Proceeds 440.9000-49110 0

Bond Proceeds 440.9000.49112 14,130,000

Note Proceeds 440.9000.49113 3,900,000

Premium on Debt Issuance 440.9000.49114 1,464,751

Total $19,781,573

Unencumbered Balance 1/1/13 $1,685,553

Advance from General Fund

Sale of land to GFS

Greenvale note $1,800,000Cedar Center Note Proceeds $2,100,000

Refund Real estate taxes paid GFS property

Reimb from GFS for road






In January 2007 the City issued $17,000,000 5.5% Taxable Real Estate Acquisition and Urban Redevelopment General Obligation Bond

Anticipation Notes for the purchase of Cedar Center. In January of 2009 the 2008 note was paid and a new note of $18,550,000 was issued to

cover the principal and interst of the old note. This note will mature in January 2010. The note was again renewed with a maturity date of

September 30, 2010

In December 2006 the City took out a $1,800,000 Special Obligation Note for the purchase of 9 properties on Greenvale Rd. The note was

renewed in 2007,2008 and 2009. Interest only has been paid.

3/22/2013


36/37


CAPITAL PROJECTS

LAND ACQUISITION - FUND #440


2009 2010 2011 2012 2013Personal Services $0 $0 $0 $0 $0


Contractual Services 124,013 0 1,521,476 11,958 0

Other Charges 20,701,991 40,729,457 0 19,640,083 4,788,690

$20,826,004 $40,729,457 $1,521,476 $19,652,041 $4,788,690

3/22/2013


37/37


CAPITAL PROJECTS

LAND ACQUISITION - FUND #440



Water 7790-52303 205.41

Outside Legal Expenses 7790-52324 $124,013 $0 $90,053 $1,200Engineering 7790-52326 $55,937 $0

inspections 7790-52327 $8,588 $0

Contractor fees 7790-52328 $0 $244,715 $3,272

Real property appraisal 7790-52348 $5,950

Real eastate taxes 7790-52397 $0 $0 $130,845 $801

Land/land improvements 7790-52501 $0 $0 $986,615 $0

Demolition 7790-52737 $0 $0 $0 $0

Miscellaneous 7790-52799 $16,856 $0 $4,723 $530

TOTALS $124,013 $0 $1,521,476 $11,958 $0


OTHER 2009 2010 2011 2012 2013

Advances out (new 2010) 9910-59102 0

DEBT SERVICE

Note Principal - Greenvale 8850-52603 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000

Note Interest - Greenvale 8850-52604 59,235 59,235 26,028 25,060 26,100

Note Principal - Cedar Center 8850-52603 18,010,000 37,775,000 19,270,000 17,270,000 2,100,000

Note Interest - Cedar Center 8850-52604 808,199 792,970 220,489 227,236

Cedar Center G.O Bond Principal 705,000

Cedar Center G.O Bond Interest 157,590

BRF/CRF Loan Interest 8850-52606 24,557 79,514 32,407

BRF/CRF Loan Principal 8850-52607 864,252

Debt Issuance cost 8850-52680 222,738 131,642 317,787

TOTAL OTHER 20,701,991 40,729,457 19,640,083 4,788,690

TOTAL 20,826,004 40,729,457 1,521,476 19,652,041 4,788,690

Principal interest total

CEDAR CENTER NOTE 2,100,000 0 2,100,000

CEDAR CENTER G.O. Bond 705,000 157,590 862,590

Greenvale Note 1,800,000 26,100 1,826,100

4,605,000 183,690 4,788,690

Create a new line item for

Bond Principal and Interest

3/22/2013

10 book capital projects - 2013 budget

Documents