PU Monthly Report Volume III Issue II-August

Issue II - August

Volume III

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014–June 2015)

Created and Compiled by Nicole Brown and Christopher Starling

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

AGENDA

Revenues............................................................................................................................................................................ 3-6 Expenditures....................................................................................................................................................................... 7-8 Utility Billing ............................................................................................................................................................................9 Administrative Operations .............................................................................................................................................. 10-12 Water Operations ........................................................................................................................................................... 13-15 Waste Water Operations ................................................................................................................................................ 17-18 Capital Improvement Projects ........................................................................................................................................ 20-27

ADDITIONAL ISSUES

2

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

REVENUES BY MONTH

FY 14 Actual

FY 15 Actual

Difference

ACTUAL FY 15

$19,985,697

$20,236,782

$251,085

Jul

$16,999,850

$18,717,840

$1,717,990

Aug

$22,000,000

$16,386,948

Sep

$18,727,445

Oct

$19,000,000

$15,305,435

Nov

$16,529,018

Dec

$16,000,000

$16,139,908

Jan

$12,911,167

Feb

$13,000,000

$15,252,810

Mar

$16,060,484

Apr

$16,536,748

May

$10,000,000

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

$17,843,475

Jun

FY 2014

FY 2015

Total

$198,678,985

$38,954,622

$1,969,075

Percentage Collected 10%

REVENUES BY MUNICIPALITY

$1,268,612

Raleigh/Garner-84%

Rolesville-1%

$32,882,893

$576,695

Wake Forest-7%

$1,094,158

Knightdale-3%

Wendell-1%

$2,593,084

Zebulon-3%

$539,180

3

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

RALEIGH/GARNER REVENUE

FY 14 Actual

FY15 Actual

Difference

ACTUAL FY 15

$16,515,203

$16,829,524

$314,321

Jul

$14,276,897

$16,053,369

$1,776,472

Aug

$19,000,000

$13,700,437

Sep

$16,000,000

$15,991,021

Oct

$12,857,533

Nov

$13,000,000

$14,204,553

Dec

$10,000,000

$13,877,375

Jan

$7,000,000

$10,597,336

Feb

$12,976,037

Mar

$4,000,000

$13,704,359

Apr

$1,000,000

$14,064,107

May

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

$14,409,582

Jun

FY 2014 FY 2015

Total

$167,174,440

$32,882,893

$2,090,793

Percentage Collected: 17%

KNIGHTDALE REVENUE

FY14 Actual

FY15 Actual

Difference

ACTUAL FY 15

$867,533

$596,363

($271,170)

Jul

$449,156

$497,795

$48,639

Aug

$900,000

$480,879

Sep

$800,000

$494,914

Oct

$700,000

$463,449

Nov

$600,000

$477,947

Dec

$500,000

$447,497

Jan

$477,528

Feb

$400,000

$410,875

Mar

$300,000

$515,583

Apr

$200,000

$455,136

May

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

$501,364

Jun

FY 2014 FY 2015

Total

$6,041,861

$1,094,158

($222,531)

Percentage Collected: 21%

November 2012 - Increase to Sewer Capital Facility Charge and Sewer Capital

4

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WAKE FOREST REVENUE

FY 14 Actual

FY 15 Actual

Difference

ACTUAL FY 15

$1,384,623

$1,405,539

$20,916

Jul

$1,322,027

$1,187.545

($134,482)

Aug

$2,000,000

$1,312,464

Sep

$1,700,000

$1,285,433

Oct

$1,099,456

Nov

$1,400,000

$1,031,400

Dec

$1,100,000

$1,050,554

Jan

$800,000

$1,028,433

Feb

$1,036,161

Mar

$500,000

$1,068,044

Apr

$200,000

$1,111,264

May

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

$2,070,728

Jun

FY 2014 FY15

Total

$14,800,587

$2,593,084

($113,566)

Percentage Collected: 21%

June 2014 - One time payment of $710,000

ROLESVILLE REVENUE

FY 14 Actual

FY 15 Actual

Difference

ACTUAL FY 15

$660,528

$301,554

($358,974)

Jul

$413,740

$237,626

($176,114)

Aug

$700,000

$304,400

Sep

$600,000

$367,960

Oct

$500,000

$346,280

Nov

$229,284

Dec

$400,000

$216,296

Jan

$300,000

$170,291

Feb

$229,897

Mar

$200,000

$189,798

Apr

$100,000

$316,268

May

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

$307,724

Jun

FY 2014 FY 2015

Total

$3,752,466

$539,180

($535,088)

Percentage Collected: 30%

5

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WENDELL REVENUE

FY14 Actual

FY 15 Actual

Difference

ACTUAL FY 15

Jul

$217,565

$284,776

$67,211

Aug

$209,431

$291,919

$82,488

$300,000

Sep

$247,791

Oct

$239,936

$250,000

Nov

$220,580

Dec

$235,219

$200,000

Jan

$224,434

Feb

$265,685

$150,000

Mar

$255,196

Apr

$240,655

$100,000

May

$230,025

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Jun

$243,039

FY 2014 FY 2015

Total

$2,829,566

$576,695

$149,699

Percentage Collected: 23%

ZEBULON REVENUE

FY 14 Actual

FY 15 Actual

Difference

ACTUAL FY 15

Jul

$340,245

$819,026

$478,781

Aug

$328,599

$449,586

$120,987

$850,000

Sep

$340,977

$725,000

Oct

$348,181

Nov

$318,137

$600,000

Dec

$350,615

$475,000

Jan

$323,752

$350,000

Feb

$371,894

Mar

$344,644

$225,000

Apr

$342,035

$100,000

May

$359,948

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Jun

$311,038

FY 2014 FY 2015

Total

$4,080,065

$1,268,612

$599,768

Percentage Collected: 38%

6

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

EXPENDITURES BY MONTH

FY 14 Actual

FY 15 Actual

Difference

$61,000,000

Jul

$5,337,885

$5,301,129

($36,756)

Aug

$6,438,835

$6,772,809

$333,974

$51,000,000

Sep

$6,236,368

$41,000,000

Oct

$56,291,859

Nov

$7,716,059

$31,000,000

Dec

$6,495,185

Jan

$31,090,779

$21,000,000

Feb

$8,913,078

$11,000,000

Mar

$6,340,572

Apr

$6,682,937

$1,000,000

May

$32,148,836

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Jun

$8,571,787

FY 2014 FY 2015

Total

$182,264,180

$12,073,938

$297,218

FY14 Oct 2013 - 50% of Departmental Transfer Were Booked $43,082,261 May 2014 - 25% of Departmental Transfer Were Booked $21,990,838

OPERATING EXPENDITURES BY DIVISION

7

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

310 Operating Fund

FY 14 Actual YTD (July-August)

FY 15 Adopted Budget

FY 15 Actual YTD (July-August)

% Spent

Division

Administration - 5210

$863,069

$8,768,345

$671,347

8%

CIP Management - 5215

$340,446

$2,640,427

$368,613

14%

Water Plants - 5220

$2,695,862

$21,419,426

$2,900,258

14%

Resource Recovery - 5230

$2,671,496

$23,172,848

$3,056,262

13%

Reuse - 5235*

$476,919

$13,863

$640

5%

Utility Billing - 5245**

580,897

$5,859,642

$738,938

13%

Sewer Maintenance - 5250

$1.188.905

$11.594.729

$1,250,360

11%

Construction - 5260

$42,741

-

-

-

Water Distribution - 5270

$982,464

$9,908,390

$1,231,930

12%

Meters - 5280

$711,401

$5,690,119

$724,618

13%

Utility Support - 5285

$303,771

$2,733,758

$319,686

12%

Special Appropriations - 5290

$961,489

$120,808,467

$811,106

0.7%

Total

$11,776,720

$212,610,014***

$12,073,938

5.4%

320 Water Infrastructure Replacement Fund

FY14 Actual YTD (July-August)

FY15 Adopted Budget

FY 15 Actual YTD (July-August)

% Spent

-

$2,888,422

-

0%

325 Sewer Infrastructure Replacement Fund

FY14 Actual YTD (July-August)

FY15 Adopted Budget

FY 15 Actual YTD (July-August)

% Spent

-

$6,112,089

-

0%

*In FY 14 5230 and 5235 were combined into 5230, Resource Recovery but some expenditures will occur due to prior year encumbrances. **In FY 14 5245, Utility Billing was moved from the General Fund to Public Utilities. ***In FY 15 two funds added for Water/Sewer Infrastructure Replacement

8

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

ACCOUNTS BY CALENDAR YEAR TO DATE

190,000

170,000

150,000

130,000

110,000

90,000

70,000

50,000

30,000

10,000

2010

2011

2012

2013

2014

Avg. Active Accounts Total Accounts

UTILITY BILLING CALLS FISCAL YEAR TO DATE

38,889

80,608

Total Calls: 119,497

ACD: Automatic Call Distribution COR: City of Raleigh Calls

ACD Calls COR Calls

9

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

PUBLIC INFORMATION OFFICE STATUS REPORT

Project Manager

Completion Date

Project Name

%

Status

PIO Staff meet monthly to discuss projects and assignments

Monthly PIO Meetings

CD

100%

7/2014

Communication Pipeline

CD

-

Ongoing Activity Suspended

Distribution of tickets, food coordination, mascot coordination

Carolina Mudcats Employee Appreciate Event

CD

50%

8/2014

Created and ordered new hydrant and toilet mascot, created guidelines for mascot appearance requests

Mascot Creation and Development

CD/MB 90%

Ongoing

Water System Master Plan Tracer Study

CD

100%

6/2014 Created temp ID badges for NCSU volunteers

Marlin Communication System

CD

-

Ongoing Updated various articles and news related content

Boil Water Advisory/Boil Water Notice Procedures

Revise letters concerning release and notification letters

CD

-

Ongoing

Completed media training for executive management, rebranding campaign, crisis management workshop

Marketing Consultant Project Management

CD

-

Ongoing

Web Content Changes

All

-

Ongoing BWA/Cancellations; Cross Connection forms updated

Road/Repair closures, BWA Cancellation and NACWA Awards

Press Releases

CD

-

Ongoing

CD/MB/ LH

Environmental Awards

10%

Ongoing Prepare email notification to colleges for 2015

Volunteer Program Training

CD

25%

8/2014 Created volunteer training program for employees

Video Productions Training

KT

50%

-

Rescheduled for a later date

It Matters Where You Pay; If It’s Not Toilet Tissue; Report Backups and Overflows; Annual Water Quality

AYS Articles

CD

100% Ongoing

CD/MB/ LH/EB

Public Utilities Calendar

25%

8/2014 Finalizing photo selection and content

RFQ for Interpreter Services (Language Line) for Public Utilities

Drafted RFQ, listed possible firms, awaiting comments from Carman

CD

50%

Ongoing

10

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

PERSONAL INJURIES BY CALENDAR YEAR

80

60

40

20

0

2010

2011

2012

2013

2014

Plants

Operations

2010

2011

2012

2013

2014

52

61

24

22

0

UFOC

22

13

7

9

0

Plants

74

74

31

31

0

Totals

VEHICLE INCIDENTS BY CALENDAR YEAR

40

30

20

10

0

2010

2011

2012

2013

2014

Operations Injury

Operations No Injury

Plants Injury

Plants No Injury

2010

2011

2012

2013

2014

Injury

3

3

0

0

0

UFOC

0

0

0

0

0

Plants

No Injury

38

13

13

10

0

UFOC

15

14

6

8

0

Plants

56

30

19

18

0

Totals

*Due to software transition 2014 data unavailable

11

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

POSITION REPORT

Authorized Positions

632

Vacant Positions

87

Approved to Hire

61

Acting

8

APPROVED TO HIRE

Customer Service Representative

5

Senior Service Specialist

4

PU Equipment Operator I

4

Sewer Monitoring Technician

1

Water Meter Mechanic

2

Microbiologist

1

Laboratory Analyst

1

Assistant Public Utilities Director

1

Environmental Monitoring Technician

2

PU Equipment Operator II

3

Industrial Maintenance Electrician

1

PU Equipment Operator III

3

Sewer Monitoring Supervisor II

1

Sr. Treatment Plant Operator

1

Maintenance Analyst/Planner

5

Accounting Technician

1

Operations Analyst

1

Training & Development Manager

1

Sr. Computer Systems Specialist

1

PU Service Specialist

5

GIS Specialist

1

Administrative Assistant

1

Treatment Plant Operator

1

Utilities Supervisor I

1

Utilities Supervisor III

3

Utility Safety Coordinator

1

Utilities Technician

2

Process Control Training Officer

1

Industrial Pretreatment Technician

2

Business Process analyst

1

Plant Maintenance Mechanic

2

Customer Service Specialist

1

12

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WATER DISTRIBUTION FISCAL YEAR TO DATE

Valves Installed/ Inserted

Hydrants Repaired

Hydrants New/ Replaced

Hydrants Serviced

Valves Exercised

Valves Replaced

Valve Box Replaced

Blow Off Repaired

261

51

3,236

1,336

2

7

47

5

Leak Detect % Surveyed

Leaks/Breaks Per 100 Mile YTD

Water Serv. Replaced

Water Serv. Repaired

Water Serv. Abandoned

Water Serv. Installed

Locates Requested

Boil H20 Advisories

32

18

13

7

5%

5.74

14,466

0

METER OPERATIONS CALENDAR YEAR TO DATE

Field Activities Completed

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

10,004

8,804

9,141

8,823

10,422

11,393

11,400

11,605

-

-

-

-

Cross Connection Control Program

Total Containment Backflow Assemblies

Backflows Tested Calendar Year to Date

Compliance Percentage

27,218

18,249

67%

METER SETS BY CALENDAR YEAR

4,000

3,500

3,000

2,500

2,000

1,500

1,000

500

2010

2011

2012

2013

2014

13

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WATER SUPPLY DAYS REMAINING

Days Water Supply Remain

346

Days Left in Year 2014

122

Projection Date For Water Supply Exhausted

August 12, 2015

Average Lake Levels

Falls Lake

Lake Benson

Lake Wheeler

251.78

234.49

282.16

AVERAGE DAILY PUMPAGE BY MONTH

70.00

60.00

50.00

40.00

30.00

PPB MGD

20.00

10.00

0.00

Jan Feb Mar

Apr

May Jun Jul

Aug Sep Oct

Nov Dec

2011 2012 2013 2014

ENTRY POINTS DISINFECTION BYPRODUCTS

100.0

80.0

60.0

40.0

20.0

0.0

Jan Feb Mar

Apr

May Jun Jul

Aug Sep Oct

Nov Dec

EMJ

DEB

Max Allowable

PPB-Parts per Billion

14

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

TOTAL ORGANIC CARBON REMOVAL YEAR TO DATE

90

80

70

60

50

40

30

20

10

0

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

EMJWTP

DEBWTP

Min. Required

FILTERED TURBIDITY YEAR TO DATE

0.35

0.30

0.25

0.20

NTU

0.15

0.10

0.05

0.00

Jan Feb Mar

Apr

May

Jun

Jul

Aug Sep Oct

Nov

Dec

EMJWTP

DEBWTP

Max Allowable

NTU-Nephelometric Turbidity Unit

15

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

SEWER FLUSHING

Operation Center

Month (Miles)

Calendar Year to Date (Miles)

Raleigh

59.39

427.10

South Raleigh

11.74

137.79

East Raleigh

2.45

16.50

North Raleigh

8.39

49.14

Percentage of System Complete

Month Total

Calendar Year to Date Total

27.40%

81.97

630.53

SSO’S CALENDAR YEAR TO DATE

2014

2013

2012

2011

2010

2009

2008

2007

0

20

40

60

80

100

Avg SSO Volume / 1,000

Total # of SSOs for Year

Year SSO # thru 08/31/2014

Average SSO Volume per 1,000

Total # of SSO’s for Year

No. of SSO’s per 100 Miles of Sewer

Year

SSO # through 8/31/14

Volume

2014

37

502,464

14

37

1.61

2013

33

623,555

19

57

2.48

2012

21

395,360

19

31

1.35

2011

29

530,666

18

36

1.57

2010

38

1,724,230

45

63

2.74

2009

51

4,863,005

95

55

2.39

2008

44

183,270

4

68

2.96

2007

38

2,468,964

65

69

3.00

16

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

TOTAL NITROGEN COMPARISON FOR NRWWTP

1,800,000

Debit

Discharged Nitrogen Limit

Benchmark

1,600,000

1,400,000

1,200,000

1,000,000

800,000

600,000

400,000

200,000

0

1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014

1995

2013

2014

Month

TN Conc. mg/L TN Dschg. lbs TN Conc. mg/L TN Dschg. lbs

TN Conc. mg/L

TN Dschg. lbs

January

11.43

92,850

1.29

14,236

2.95

33,124

February

11.77

96,556

2.01

21,330

2.54

27,396

March

11.38

98,122

2.53

28,806

3.05

37,101

April

17.53

133,685

1.52

17,311

2.15

24,440

May

13.94

109,311

1.71

20,274

2.00

23,842

June

10.88

92,445

1.15

13,406

1.41

14,812

July

14.10

116,289

1.24

14,236

1.31

14,067

August

15.65

132,835

1.32

14,463

1.89

21,853

September

13.30

110,245

1.87

20,225

October

13.34

130,024

3.26

33,698

November

11.08

96,279

2.68

27,025

December

13.64

108,298

2.52

29,996

Projected Total

1,316,939

356,584

392,502

Avg

13.17

1.94

2.16

*Flow Total (YTD) to Reuse through distribution and irrigation (Neuse River+Little Creek+Smith Creek) = 179.674 MG *Debit Information Capture Started in 2008 *Limit changed in 1999 from 676,496 to 682,483

17

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

AVERAGE FLOW VS REUSE IN MILLIONS OF GALLONS

55.000

50.000

45.000

40.000

35.000

30.000

25.000

Jan Feb Mar

Apr

May Jun July Aug Sep Oct

Nov Dec

NRWWTP SCWWTP LCWWTP Reuse

Month

Neuse River WWTP

Smith Creek WWTP

Little Creek WWTP

Reuse

January

43.430

1.519

0.997

0.087

February

46.188

1.715

1.017

0.325

March

47.049

1.885

1.007

0.417

April

45.434

1.784

0.991

0.624

May

46.108

1.769

0.888

0.869

June

41.986

1.619

0.645

1.218

July

41.533

1.632

0.636

1.159

August

44.722

1.678

0.687

0.850

September

-

-

-

-

October

-

-

-

-

November

-

-

-

-

December

-

-

-

-

18

All financial data is from the city’s financial management system. This is an unaudited report.

Capital Improvement Projects Monthly Performance Report FY 15 (July 2014-June 2015)

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WATER AND SEWER MAINS ACCEPTED BY YEAR IN FT

350,000

300,000

250,000

200,000

150,000

100,000

50,000

0

2009

2010

2011

2012

2013

2014

Type

2009

2010

2011

2012

2013

2014

Gravity Sewer Accepted

45,453

45,883

34,532

8,274

20,445

4,819

Water Main Accepted

46,116

18,817

17,390

6,981

4,194

-

Reclaimed Water

37,712

19,932

8,880

4,088

12,418

-

Force Main

3,103

10,302

-

-

965

254

Force Main Lined (CIPP)

2,336

-

564

-

-

-

CIPP/Lined/Burst Gravity Sewer

-

9,305

2,679

79,749

478

605

Water Main Replaced

-*

-*

-*

7,356

35,407

7,840

Gravity sewer Replaced

-*

-*

-*

8,299

20,378

9,943

Force main Replaced/Rehabbed

-

-

-

-

-

119

Priv. Dev.: Gravity Sewer Accepted**

85,142

59,719

68,532

72,772

67,198

38,503

Priv. Dev.: Water Main Accepted**

128,042

52,903

39,668

59,237

96,507

44,423

Totals

347,904

216,861

172,245

246,756

257,990

106,506

*-Water and Sewer main replaced were previously in water and sewer main accepted **Includes data from Public Works Inspectors

20

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WATER AND SEWER MAINS ACCEPTED-AUGUST

Gravity Sewer accepted

Water Main accepted

Reclaimed Water

Force Main

CIPP/lined/burst Gravity Sewer

Gravity Sewer Replaced

Water Main Replaced

Force Main replaced/rehabbed

Priv. Dev. : Gravity Sewer accepted

Priv. Dev. : Water Main accepted

500

3,500

6,500

9,500

12,500

15,500

Inspections

Feet

Gravity Sewer Accepted

534

Water Main Accepted

-

Reclaimed Water

-

Force Main

-

CIPP/Lined/Burst Gravity Sewer

-

Gravity Sewer Replaced

727

Water Main Replaced

261

Force Main Replaced/Rehabbed

-

Private Development. : Gravity Sewer Accepted*

13,262

Private Development. : Water Main Accepted*

14,370

* Merger Town Only

21

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

EMJ WTP PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

FLOCC & Sed. Basin Full Scale Pilot

ES

Design

Hazen & Sawyer 95%

11/2014

Continuing Design

Raw Water Reservoir Cover

PA

On Hold

-

0%

-

On Hold

Sodium Permanganate Improvements

DWSRF Application for 0% Loan Approved

PA

Design

Hazen & Sawyer 95%

12/2014

Brown and Caldwell

Clearwell Assessment Diving Complete

Clearwell Rehabilitation

RR

PER

17%

-

Wastewater Collection and Pumping Improvements (Phase II)

PA

On Hold

Jacobs

-

-

Reassigning Contract

Municipal Engineering

Warehouse Expansion

PA

Design

100%

9/2014

Bid Date August 2014

Raw Water Reservoir Sludge Removal

PA

On Hold

-

-

-

-

UV/Solids Handling

PA

-

-

-

-

-

DE BENTON PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Settling Tank Dewatering Facilities Wrenn Road Lagoon Improvements

Advertise RFP/RFQ August 2014

DL

PER

Jacobs

95%

9/2014

Water & Waste Construction Wharton-Smith, Inc.

Demonstration/Substantial Completion

DL

Construction

95%

9/2014

Backwash Waste Recycling Facility

PA/RR

Construction

50%

12/2014

-

Hazen and Sawyer

DEB Reservoir

EN

Design

-

-

Received SUP February 2014

22

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

SEWER MAIN REPLACEMENT PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Reviewing 95% Plans 90% of Main Interceptor and 100% of Laterals Added Section of Sewer Replacement on Hold until July Project Information Meeting in August Working on Tunnel at Burgess

Sanitary Sewer Siphon Rehabilitation

RR

Design

Hydrostructures 95%

9/2014

Centurion Construction

Marsh Creek Sanitary Sewer Replacement

RR

Construction

95%

9/2014

Chamberlain, Clark SS Replacement

ES

Construction

Moffat Pipe

70%

3/2015

Hammond Rd SS Relocation

RR

Scoping

Dewberry

-

TBD

Gorman St. Sewer Rehab./Replacement

AB

Construction

Moffat Pipe

35%

12/2014

Desktop Review Extended Submitted to Development Review N-T-P February 2014

Aerial Crossing Replacements II

RR

PER

URS

75%

-

Aerial Crossing Replacements I

RR

Design

Dewberry

90%

-

Leafcrest Sewer Realignment

AB

Construction

Moffat Pipe

0%

12/2014

City Coordination Meeting in August

Lake Wheeler Rd Stream Relocation

RR

Design

Kimley-Horn 60%

1/2015

Flow Monitors Removed, Report Underway

Beaman Lake Creek Interceptor Evaluation

JG

Study

Hydrostructures 50%

-

Upper Pigeon House Sewer Interceptor Replacement

Advertisement in August

EN

Design

GHD

100%

2/2016

Ashe Av/Park Av/Cox Av Water and Sewer Replacement

JF Wilkerson Contracting

DL

Construction

0%

4/2015

N-T-P July 2014

Negotiations and Settlement

Eton Rd Sewer and Aerial Replacement

DL

Design

Aecom

100%

4/2014

Edens Land Corp.

Seaboard Station Sanitary Sewer Evaluation

AB

Planning

0%

12/2014

Scoping

Lower Marsh Creek Interceptor Evaluation

RR

PER

Hydrostructures 100%

6/2014

Complete

North Hills Dr, East St, E. Lenoir, Corporation Pkwy CCTV Investigation

DL

Design

Hydrostructures 50%

11/2014

Design in Process

23

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

SEWER MAIN REPLACEMENT PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Royal Oak, Circle Dr (Garner) Sewer and AC Water Line Replacement

RR

Design

Kimley-Horn 30%

9/2014

Additional Work being Added

Study Completed Moving into Design

Concord Dr. Area CCTV Investigation

DL

Design

Kimley-Horn 0%

11/2014

Lakestone Dr. Outfall CCTV Investigation

The Wooten Company

DL

Design

0%

9/2014

Field Work Beginning

Forum Dr., Brandywood Ct., Farmgate Rd, Outfalls CCTV Investigation

DL

Design

WK Dickson 0%

-

Task Order Executed

Church St, E. Lenoir, Corporation Pkwy

DL

Design

URS

95%

8/2014

Field Work Completed

Marlowe Rd/Drewry Ln CCTV Investigation

DL

Design

Kimley-Horn 70%

9/2014

Field Work in Progress

McKim & Creed

Redesign around Johnson Property

Williamson/Iredell Sewer Rehabilitation

AB

Design

50%

9/2014

Lake Dam Rd. Aerial Replacement

DL

Design

AECOM 100%

4/2014

Informal Bidding August 2014

North Crabtree Interceptor Rehabilitation

Metra Industries

EN

Construction

100% 11/2013

Final Change Order Complete

NRWWTP PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

PC Construction

N-T-P July 2014

Filters 1-12 Rehabilitation

EN

Construction

0%

7/2015

15 MGD Expansion - Ph. III Primary Clarifiers and BNR Basin

PC Construction

ES

Construction

20%

1/2016

Excavation for Clarifiers

Administration Building and Lab Renovations

DTW Architects

JG

Design

100%

9/2014

Bid October 2014

Dewatering Building Improvements and Odor Control

Freese & Nichols

RR

Scoping

0%

-

-

15 MGD Expansion - Ph. IV Secondary Clarifiers, RAS, Methanol,

Hazen & Sawyer

AB

Design

45%

2/2015

-

Anaerobic Digesters, THP, CHP

AB

Pre-Design

-

-

-

RFP Issued June 2014

Designer Selection and Contract Negotiation

Anaerobic Digestion Project

ES

Design

PU

90%

12/2014

24

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

SEWER SYSTEM EXPANSION/EXTENSION PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Pipe Laying Upstream of Pigeon House Branch

Crabtree Basin Wastewater System Conveyance Improvements Phase I Crabtree Basin Wastewater System Conveyance Improvements Phase II Upper Walnut Creek Interceptor Rehabilitation Lower Walnut Creek Interceptor Rehabilitation Lower Crabtree Creek North Sewer Outfall

Park Construction

AB

Construction

90%

6/2014

Hazen & Sawyer

EN

Design

95%

9/2014

Advertisement in August

Continuing Coordination and PER Design of New Parallel Sewer Line

TBD

ES

Design

Kimley Horn 98%

McKim & Creed

ES

Design

1%

TBD

Rivers & Associates

JG

Design

99%

TBD

Final Development Review

Busted Rock Outfall

JG

Design

Wooten 100%

-

On Hold Due to WCPSS

Fowler Dr. and Vandora Springs Rd. Sewer Extension

Easements Obtained, Power Pole Relocation Underway

JG

Design

Edens

100%

TBD

Coronado Drive SS Extension

JG

Construction JF Wilkerson 100%

9/2014

Construction Complete

Crabtree Valley Sewer Extension Replacement

McKim & Creed

EN

PER

-

Scoping Underway

JF Wilkerson Contracting

Construction is Substantially Complete

Knollrock Drive SS Extension

JG

Construction

100%

9/2014

Mango Creek Sanitary Sewer Assessment

-

-

-

-

-

-

Aversboro Force Main

JG

Construction JF Wilkerson 0%

6/2015

Contracts Routing

ASSET MANAGEMENT PROJECTS

Project Manager

Current Phase

Completion Date

Status

Project Name

Vendor

%

Upper Pigeon House Water and Sewer Assessment

McKim and Creed

Contract for Council Approval July 2014

JS

Design

0%

11/2014

State Street Water and Sewer Assessment

Contract Approved by City Council August 2014

JS

Design

CDM Smith 0%

11/2014

2” Galvanized Water Mains

JS

Planning

0%

12/2014

Initial Street Selection

Forcemain Assessment

JS

Planning

0%

12/2014

Critically Ranking/ARV Project

25

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

SEWER PUMP STATION PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Walnut Creek LS Improvements 4th VTSH Pump

EN

Construction Dellinger

95%

9/2014

Construction Ongoing

Aversboro PS

EN

Construction

-

0%

-

Receive Bidgs August 2014

Walnut Creek LS Improvements Screw Rehab

Hazen and Sawyer

EN

On Hold

100%

-

Waiting Funding

Pump Station Rehab and Replacement Hwy 50

Water & Waste

RR

Construction

10%

12/2014

N-T-P June 2014

East Neuse Regional Pump Station

AB

PER/EIS

Jacobs

65%

8/2015

Received Draft EIS

Crabtree LS Improvements

EN

Pre-Design

TBD

0%

TBD

PS Evaluation Complete

Neuse River Pump Station Pump Addition

RR

PER

Highfill

60%

9/2014

Evaluating Pump Options

PS Rehab and Replacement Greenspring/Green Willow

Brown and Caldwell

RR

PER

100%

2/2014

Scoping for Design Phase

Forestville Farms/Brighton/Wake High Meadows PS Evaluation

RR

PER

Highfill

100%

9/2014

Complete

REUSE WATER IMPROVEMENTS

Project Manager

Current Phase

Completion Date

Status

Project Name

Vendor

%

Expansion Segment #4

JF Wilkerson Contracting

EN

Construction

95%

9/2014

RR Encroachment Back to RR

Master Plan Update

EN

PER

CDM Smith 50%

12/2014

Neuse River Sampling Complete

Sunnybrook Reuse Tank Discharge

JG

PER

Kimley Horn

-

-

Scoping

26

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

WATER MAIN REPLACEMENTS

Project Manager

Completion Date

Project Name

Current Phase

Vendor

%

Status

Design of Water and Sewer Replacement

2012 Water Line Replacements #2

ES

Design

McKim & Creed 50%

9/2014

Mack Todd Rd. & W. Gannon Improvements

JG

Design

Edens Corp.

90%

TBD

Design in Progress

Informal Bidding August 2014

Aurora Dr Bridge –WL Replacement

RR

Prebid

-

-

-

Centurion Construction

Final Change Order August 2014

2011 Water Line Replacements #3

RR

Construction

98%

9/2014

2011 Water Line Replacements #4A

JG

Construction

Moffat Pipe

0%

-

Contract Routing

Contracts Routing for Combined Project Design of Water and Sewer Replacements Design of Water and Sewer Replacements Design of Water and Sewer Replacements Design of Water and Sewer Replacements Design of Water line Around Cargill Plant Design of Water and Sewer Replacements Design of Water and Sewer Replacements

2012 Water Line Replacements #3

ES

Construction

TA Loving

0%

10/2015

The Wooten Company The Wooten Company

2012 Water Replacements #3A

ES

Design

12/2014

2012 Water Replacements #3B

ES

Design

40%

2/2015

2013 Water Line Replacements #1

ES

Design

AECOM

90%

11/2014

Highfill Infrastructure Highfill Infrastructure Highfill Infrastructure

2013 Water Line Replacements #2

ES

Design

95%

10/2014

2014 Water Line Replacements #1

ES

Design

0%

5/2015

2014 Water Line Replacements #2

ES

Design

0%

8/2015

2014 Water Line Replacements #3

ES

Design

McKim & Creed 95%

8/2015

WATER SYSTEM IMPROVEMENTS

Project Manager

Completion Date

Project Name

Current Phase

Vendor

%

Status

DEBWTP Garner Water Mains

PA

Design

Arcadis

100%

9/2014

Bid August 2014

Hazen and Sawyer

Field Work Complete

Master Plan Update

EN

Pre-Design

40%

1/2015

Springdale Tank Replacement

EN

Pre-Design

Wooten

0%

-

Kick-Off

Wendell Blvd Water Main Extension

RR

Design

McKim & Creed 90%

9/14

Plans in Review

27

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

NCDOT/PUBLIC WORKS CONFLICT PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Pre-Con August 2014 Hammond Rd Agreement Public Meeting September 2014

NCDOT U-4432 Tryon Road

JG

Construction

NCDOT

0%

-

NCDOT Vaughn Melton

NCDOT I-440 Crawleigh

JS

Coordination

10%

-

Public Works Hillsborough Streetscape

JS

Design

Kimley Horn

65%

-

Public Works Capital Blvd.-Spring Forest to Old Wake Forest Public Works South and Lenoir 2 Way Conversion

JS

Design

-

10%

-

-

Additional Survey Needed Transportation Bonds Approved

JG

Design

Kimely Horn

40%

-

Public Works Mitchell Mill

JG

Design

Kimley Horn

75%

-

NCDOT Capital Blvd (Peace St. to Wade Ave)

EN

Design

-

-

-

-

MISCELLANEOUS PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Little Creek WWTP Filter Rehabilitation

DL

Construction

Aqua Aerobics

-

Contracts Executed

-

Little River Reservoir Draft EIS

KW

Planning

Hazen & Sawyer 75%

6/2014

Draft EIS in Process

Telemetry System Improvements Ph. III Smith Creek WWTP Maintenance Building

Construction (Phase 3)

Crown Castle Lease Needed Completed Under Slab Utilities Completing Final Draft

PA

CITI

97%

9/2014

ES

Construction SBC Construction 65%

12/2014

Sewer Capacity Study

JS

Study

Black and Veatch 99%

Complete

Substantial Completion

UFOC East and West Lot Improvements

JG

Construction Riley Contracting 90%

10/2014

EMJ - Phase II- 90%, Falls Lake Compiling Laboratory Data

VA Security Improvements Phase I & II

PA

Construction

CITI

95%

9/2014

Central Laboratory Study

DL

Study

Hazen & Sawyer 90%

9/2014

Interior Architecture

Utility Billing Renovations Lake Woodard

JG

Design

10%

-

Space Study

East Operations

JG

Design

DTW Architects 50%

-

28

All financial data is from the city’s financial management system. This is an unaudited report.

CITY OF RALEIGH PUBLIC UTILITIES Monthly Performance Report FY 15 (July 2014-June 2015)

MERGER TOWN PROJECTS

Project Manager

Current Phase

Completion Date

Project Name

Vendor

%

Status

Highfill Infrastructure Engineering Green Engineering Park Construction

PWS Permit Review

Zebulon BPS Generator

PA

Design

98%

8/2014

Zebulon Beaver Dam Creek Interceptor Project

95%

ES

Design

TBD

Starting Easement Acquisition

Knightdale Lower Mango Creek Parallel Interceptor

AB

Construction

98%

9/2014

Punch List

Wake Forest Richland Creek Parallel Interceptor Wake Forest Smith Creek Parallel Interceptor

DL

Design

WK Dickson 98%

9/2014

Easements

Park Construction

DL

Construction

0%

12/2015

Contract Routing

Wake Forest I&I Improvements

DL

Construction TA Loving 97% 10/2014

Added N & S Allen Sewer

Martin Pond Road Water Transmission Main Extension

Withers and Ravenel Centurion Construction

Easements and ROW Work

JG

Design

65%

TBD

Installation of a Second Booster Pump

Zebulon Booster PS

ES

Design

15%

9/2014

West Juniper

JS

Bidding

TA Loving

0%

10/2014

Construction Beginning

Zebulon Water Projects

DL

Design

WK Dickson 80%

9/2014

Design in Progress

Various Wendell Gravity Sewer Extensions Town of Wake Forest Stadium Dr. Improvements

-

-

-

-

-

-

JG

Design

Kimley Horn 50%

6/2015

Construction Planned in 2016

29

All financial data is from the city’s financial management system. This is an unaudited report.

Made with