· report:317 date ,09/25/2013 fund :051 department,30 index :305210 harford county, md -...

181
Water & Sewer BUDGET DATA FY15 BUDGET WORKSHEETS DATE 09/2013

Upload: others

Post on 14-Dec-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

Water & Sewer

BUDGET DATA FY15

BUDGET WORKSHEETS

DATE 09/2013

Page 2:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT,30INDEX :305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M ABINGDON

TIME: 14:14PAGE: 735

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

SUBDBJECT FY 12 FY 13 FY 14 FY 15

1101 CURRENT AUTHORIZED POSITIONS 1,593,749 1,554,462 1,603,909

1103 TEMPORARY 17,794 13,845 26,772

1105 UNIFORM ALLOWANCE -174

1201 RETIREMENT (OLD) 4,423 6,128

1202 PENSION (NEW) 179,465 150,942 160,391

1204 TEMPORARY (NEW PLAN) 1,128

1300 FLEX CREDITS 826 430

1301 WORKER'S COMPENSATION 44,577 49,785 50,981

1304 BLUECHDICE-FDRMERLY FREESTATE 95,489 245,303 261,854

1307 MPOS 78,867

1308 LIFE 3,943 3,827 4,795

1309 BC/BS-PREFERRED PROVIDER 210,142 111,534 175,607

1319 BENEFITS-SUPPLEMENTAL 3,450 3,075 3,000

1320 DELTA DENTAL PPO 11,146 9,539 11,023

1321 DELTA DENTAL PLUS 10,758 12,672 16,748

1350 OPEB 12B,553 174,391

1355 PEHP (POST EMPLOYMENT HEALTH PLAN) 29,143 33,551 31,946

1501 OVERTIME 87,343 167,011 148,500

1602 SOCIAL SECURITY 128,419 130,907 136,728

1801 SHIFT DIFFERENTIAL 6,866 7,155 8,000

Page 3:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WDRKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14: 14PAGE: 736

SUBOBJECT

10 SUBTOTAL

AUDITEDFY 12

2,634,779

AUDITEDFY 13

2,674,557

ORIGINALBUDGETFY 14

2.641 ,382

DEPARTMENTREQUEST

FY 15

Page 4:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE ,09/25/2013

FUND :051DEPARTMENT,30INDEX :305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB0ECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME, 14,14PAGE, 737

SUBOB0ECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2101

2102

2103

2106

2199

2201

OFFICE EQUIPMENT

COMMUNICATION EQUIPMENT

VEHICLE & OPERATING EQUIPMENT

NOTES'

TO ALLOW FOR RENTAL OF

MACHINERY. ADDED PER

FLEET MANAGER

SPACE & REAL ESTATE RENTAL

NOTES'

NATIONAL RAILROAD

PASSENGER CORP.

(NRPC) AMTRAK LEASES

OTHER RENTS & UTILITIES

ELECTRICITY

9.329

1.498

141

20.052

8,887

429

28

138

23,329

11,000

12,500

1,500

165

21,000

Page 5:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPDRT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305210

HARFORD COUNTY, MD - SYSTEMWIDE S. 1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14: 14PAGE: 738

SUBOBIJECT

2202

2302

2304

2305

HEATING FUEL (GAS)

TELEPHONE SERVICE

ANSWERING SERVICE

EMERGENCY REPORTING SYSTEMS

NOTES:

COSTS ASSOCIATED WITH

CONTRACTOR'S INFO

EXCHANGE WHICH IS

LEGISLATED BY STATE OF

MD AS WELL AS COSTS

ASSOCIATED WITH 24-HR.

NOTIFICATION FOR MISS

UTILITY. PAGERS FOR

39 EMPLOYEES.

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REOUEST

FY 12 FY 13 FY 14 FY 15

4,174 5,221 7,000

16,763 16.818 18,500

3,719 5,178 4,100

13,381 13,240 20,000

2306 FAX SERVICES 889 842 1,000

Page 6:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305210

HARFORD CDUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14: 14PAGE: 739

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2401

2402

2504

2609

2614

PERSONNEL/RECRUITMENT

LEGAL NOTICE

NOTES:

NOTIFICATION OF

BIANNUAL FLUSHING.

PERFORMANCE BOND(EMPLOYEE)

CO FACILITY REPAIR & RENOVATION

NOTES:

CY METER TESTING. HVAC.

CROSSWALK HATCHING,

ETC.

UTILITY LINE MAINTENANCE CONTRACT

NOTES:

MONUMENTAL PAVING.

55

19

76

145.157

98.589

72

125.000

142.435

100

100

140.000

100.000

Page 7:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305210

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER DPERATINGPUBLIC WDRKSWATER O&M ABINGDDN

TIME: 14: 14PAGE: 740

SUBDBvECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2620

2621

2699

2101

2102

2103

WATER LINE REHAB/REPAIR

SEWER LINE REHAB/REPAIR

OTHER PROFESSIONAL SERVICES

NOTES:

SIMPLEX GRINNELL,

STROCKS LOCKS, ETC.

UNIFORM RENTAL

DFFICE EQUIPMENT SERVICE

COMMUNICATION SERVICE

NDTES:

ADD-ONS FOR TWO WAY

RADIOS (OUTSIDE

SPEAKERS) .

11 , 672

125

4,114

6,430

25

3,865

3.113

4.651

6,250

1,005

40,000

5,000

7,000

50

4,000

Page 8:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14:14PAGE: 741

AUDITEDSUBOBJECT FY 12

2704 OPERATING EQUIPMENT

NOTES:

SERVICE FOR SMALL POWER

TOOLS, PUMPS,

GENERATORS, ETC.

45

AUDITEDFY 13

45

ORIGINALBUDGETFY 14

300

DEPARTMENTREQUEST

FY 15

270B

2799

BUILDING/CUSTODIAL SERVICES

OTHER

NOTES:

YEARLY MAINTENANCE

CONTRACT FOR ITRON,

TIME CLOCK, BOILER,

FIRE EXTINGUISHERS,

FIRE SUPPRESSION SYSTEM,

GENERATOR. AND

CITYWORKS.

7,261

20,354

5,968

13,059

B,ooo

25,000

Page 9:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE : 09/25/2013

FUND :051OEPARTMENT:30INOEX :305210

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUB08JECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGOON

TIME: 14:14PAGE: 742

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2804

2899

MD AMERICAN FIRE HYDRANT CHARGES

NOTES:

162 EA. X $109.98 =$17,817 X 2 (BI-YRLY)

$35,634/YEAR

OTHER

NOTES:

PAYMENT TO PRIVATE

UTILITIES FOR WATER

USAGE

17,817

20,310

54,059

-15,296

38,000

2,400

20 SUBTOTAL 406,460 414,471 466,715

Page 10:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14:14PAGE: 743

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3101 GENERAL OFFICE SUPPLIES 2.099 3.034 2.5OC

3103 PRINTING-COMMERCIAL

3104 DUPLICATING MACHINE SUPPLIES

3199 OTHER OFFICE SUPPLIES

3201 DELIVERY CHARGES

3202 GENERAL OFFICE MAILING

3301 PAPER SUPPLI ES

3302 JANITORIAL SUPPLIES & EQUIPMENT

3401 MEALS-SPECIAL PURPOSE

3402 ICE AND BOTTLED WATER

3499 OTHER FOOD SUPPLIES

3501 UNIFORMS-PURCHASE

798

1.596

43

1.802

1,149

913

433

2.705

107

62

830

682

715

2.980

56B

1.008

808

4.840

1.166

1.0OC

1,600

3.000

1.700

1.100

60C

5.000

800

Page 11:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX ,305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER DPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14:14PAGE: 744

SUBDBJECT

3504

3505

3506

3507

3510

3513

3515

3516

3518

3519

EQUIPMENT REPAIR PARTS

LANDSCAPE & GROUNDS MATERIAL

SMALL TOOLS

AUDIO VISUAL SUPPLIES

BUILDING SUPPLIES

CHEMICALS IN BULK

SAFETY EQUIPMENT

MEDICAL SUPPLIES

WATER METER REPAIR PARTS

W&S LINES SERVICE PARTS

NOTES;

INCREASE DUE TO COST

OF PARTS AND NO-LEAD

LAW IN EFFECT 1/01/12.

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY ,. FY 15

10,678 13,496 12,000

931 1 • 181 1,000

8,351 8,126 8,000

75 180 200

390 .5 300

3,707 2,721 5,000

11,752 15,690 12,000

568 258 250

23,263 1,377 29,000

51,056 62,618 60,000

Page 12:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX : 305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER OaM ABINGDON

TIME: 14:14PAGE: 745

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3522

3523

3524

3525

3527

3528

3530

3531

3534

3550

3551

3552

CRUSHED AGGREGATE

BITUMINOUS CONCRETE

LIOUIO BITUMINOUS

CONCRETE, MORTAR & CEMENT

COMPUTER HARDWARE COMPONENTS

COMPUTER SUPPLIES

TRAFFIC SIGNS AND MARKINGS

PAINT

OIL a LUBRICANTS

BRICKS, BLOCKS, PRECAST CONCRETE PRODUCT

PIPES, CULVERTS, & FITTINGS

GRATES, MANHOLE COVER-OTHER APPURTENANCE

NOTES:

17,265

2,166

4,043

239

305

3,000

360

607

61,809

5,233

10,937

2,049

52

4,948

162

3,000

545

1,552

50,401

24,091

20,000

3,000

4,800

250

300

1,000

3,000

400

1,200

60,000

20,000

Page 13:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

ROADWAY BOXES. METER

FRAMES AND COVERS.

Page 14:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX :805210

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER C&M ABINGDON

TIME: 14:14PAGE: 746

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3595

3599

3601

UNANTICIPATED MAINTENANCE

OTHER SUPPLIES & MATERIALS

WATER METER PUCHASES

NOTES:

ALLOWS FOR 400 NEW

METER INSTALLATIONS

AND 1,600 REPAIRS.

(2,000 METERS"

APPROX. $205/EA.

166

314,898

10.972

225,444

50.000

200

410,000

30 SUBTOTAL 533,399 455,646 719,200

Page 15:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14:14PAGE: 747

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

4101

4104

4108

4202

4502

4601

4702

4703

COUNTY OWNED VEHICLES

FUEL CHARGES

NON-TARGETED CHARGES-FVS

PARKING AND TOLLS

PROFESSIONAL BOOKS & PERIODICALS

MEMBERSHIP FEES & DUES

IN-HOUSE TRAINING

TRAINING SEMINARS, COURSES & MEETINGS

NOTES:

FEES FOR SEMINARS AND

TRAINING BY AWWA, AMRA,

ITRON, APWA, MIFRI,ETC.

ANTICIPATING 24 MOE

RECERTIFICATIONS.

$150/EA., NOT

INCLUDING TEMPORARY

CERTIFICATES OR

72,710

99.460

23,582

58

702

242

109

3.154

56,468

100,205

23,617

114

372

324

2,443

80,000

100,000

25.000

100

800

500

5.000

Page 16:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

TESTING.

Page 17:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE ,09/25/2013

FUND ,051DEPARTMENT:30INDEX ,305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14:14PAGE, 748

SUBOBJECT

40 SUBTOTAL

AUDITEDFY 12

200.017

AUDITEDFY 13

183,543

ORIGINALBUDGETFY 14

211,400

DEPARTMENTREQUEST

FY 15

Page 18:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX ,305210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER a SEWER OPERATINGPUBLIC WORKSWATER OaM ABINGDON

TIME: 14: 14PAGE: 749

SUBOBJECT

5222 PRINTER

5237 HEX-A-GRAM a METERS

NOTES,

REPLACEMENT OF TWO

HANDHELDS (S7.ooo/EA. l.

ADDITIONAL MOBILE

COLLECTOR, AND

WORKING TOWARD MONTHLV

READS.

5302 CHAIRS

5306 TABLES

5504 SAWS-ALL TVPES

5508 GENERATORS

5511 PUMPS

AUDITEDFY 12

26,700

2,145

AUDITEDFY 13

116

30.705

625

109

ORIGINALBUDGETFV 14

35.000

1,500

1,000

1,500

DEPARTMENTREQUEST

FY 15

Page 19:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX :305210

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET,

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON

TIME: 14:14PAGE: 750

$UBOBJECT

5517

5523

5533

5536

5540

5601

5602

TAMPERS

HYDRAULIC POWER TOOLS

TESTING GAUGE

LEAK OETECTION EQUIPMENT

SHORING BOX

NOTES:

LARGER WORK AREA FOR

EMPLOYEES, MOBILITY,

AND BETTER PROTECTION.

RADIO-MOBILE

RADIO-PORTABLE

AUDITEDFY 12

2,495

9,782

2,000

70

62

AUDITEDFY 13

485

ORIGINALBUDGETFY 14

2,000

2,000

13,000

2.500

3,000

DEPARTMENTREQUEST

FY 15

50 SUBTOTAL

INDEX 305210 SUBTOTAL

43,254

3,817.909

32,040

3,760,257

61,500

4,100,197

Page 20:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUND :051DEPARTMENT:30INOEX : 305220

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M PERRYMAN

TIME: 14:14PAGE: 751

SUBOBJECTAUOITEO

FY 12AUOITEO

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1355

1501

1602

1801

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

BC/BS-PREFERREO PROVIOER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

54,347

6,229

2B1

1,590

1,578

3,549

122

6,754

70

294

3B8

4,532

897

7,505

4,750

1,725

52,017

5,082

24

1,810

4,725

121

4,891

120

294

303

5,606

1,342

4,389

4,366

1,636

55,413

5,541

1,756

6,241

154

5,782

120

333

430

913

6,000

4.828

1,700

10 SUBTOTAL 94,611 86,726 89,211

Page 21:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14:14PAGE: 752

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2103

2201

2302

2609

VEHICLE & OPERATING EQUIPMENT

NOTES:

RENT FOR SPECIALIZED

EQUIPMENT

ELECTRICITY

TELEPHONE SERVICE

NOTES:

CHARGING ERROR IN

FY11&FY12

CO FACILITY REPAIR & RENOVATION

NOTES:

WATER D&M PERRYMAN

-REPLACE VENTILATION

FANS (40+ YRS OLD)

IN CHEMICAL STORAGE

167,363

4,369

6,320

181,477

1,378

5,603

100

250,000

500

27,000

AREA 20.000

Page 22:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

-REPLACE 2 DOORS

AND 1 GLASS

WINDOW

-OTHER REPAIRS

AS NEEDED

TOTAL

4,500

2,500

27,000

Page 23:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX ,305220

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISIDN DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14: 14PAGE, 753

SUBOBJECTAUDITED

FY 12AUOITEO

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREOUEST

FY 15

2699

2704

2707

2708

OTHER PROFESSIONAL SERVICES

OPERATING EQUIPMENT

NOTES'

PREVENTIVE MAINTENANCE

FOR METER CALIBRATION,

GENERATORS, HOIST,

FIRE EXTINGUISHERS.

POWER/MCC. BACKFLOWS

CL2/S02. HVAC.

UNDER/ABOVE GROUND

STORAGE TANKS

AND BOILERS

GROUNDS MAINTENANCE

BUILDING/CUSTODIAL SERVICES

14,714

2,338

2,699

1,186

16, 165

2,497

5,849

224

16.500

4.955

3.700

1.200

20 SUBTOTAL 198.989 213,193 303,955

Page 24:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INOEX : 305220

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14:14PAGE: 754

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3201

3301

3302

3399

3504

3506

3513

DELIVERY CHARGES

PAPER SUPPLIES

JANITORIAL SUPPLIES & EOUIPMENT

OTHER JANITORIAL SUPPLIES

EQUIPMENT REPAIR PARTS

NOTES;

REPAIR PARTS FOR

EXISTING AND EXPANDING

PLANT AND EQUIPMENT

SMALL TOOLS

CHEMICALS IN BULK

NOTES:

CHEMICALS REQUIREO FOR

WATER TREATMENTS TO

MEET FEOERALANO STATE

DRINKING WATER

1 , 111

234

275

13,480

337.006

936

350

418

6

9.903

162

328.608

1.000

200

200

14.000

100

380.000

Page 25:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REQUIREMENTS

Page 26:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE ,09/25/2013

FUND :051DEPARTMENT: 30INDEX :305220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14: 14PAGE: 755

SUBOBJECT

3514 LABORATORY SUPPLIES

3515 SAFETY EQUIPMENT

3531 PAINT

3532 DIESEL FUEL

NOTES,

FUEL TO POWER LARGE

GENERATORS

ORIGINAL DEPARTMENTAUDITED AUDITED BUOGET REOUEST

FY 12 FY 13 FY 14 FY 15

2,746 3,679 2,SOO

88 762 200

9 72

300

3534

3599

OIL & LUBRICANTS

OTHER SUPPLIES & MATERIALS 847

148 200

30 SUBTOTAL 355,796 345,044 398,700

Page 27:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE ,09/25/2013

FUND ,051DEPARTMENT,30INDEX ,305220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14:14PAGE: 756

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

4601

4703

MEMBERSHIP FEES & DUES

TRAINING SEMINARS, COURSES & MEETINGS 150 700

100

400

40 SUBTOTAL 150 700 500

5131 waS-WELLS AND WELL DEVELOPMENTS

NOTES,

ANNUAL INSPECTION AND

MAINTENANCE OF WELLS IN

PERRYMAN WELLFIELD.

PLANNED ANALYSIS OF

33,886 29,B72 35,000

WELLS 1,2,4,5,6,8

AND 9

REHAB/REPAIR OF

2 WELLS PER YEAR

TOTAL

10,000

25,000

35,000

Page 28:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX : 305220

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14:14PAGE: 757

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

OEPARTMENTREOUEST

FY 15

5315

5316

ELECTRIC HEATERS

NOTES:

MULTI YEAR PROJECT TO

REPLACE 36+ YR OLD

CEILING HEATERS

AIR CONDITIONERS

NOTES:

WATER O&M PERRYMAN

LARGE AIR CONDITIONERS

FOR WELLHOUSES TO KEEP

THE VFD'S OPERATING IN

1,336 197 1,650

1,500

5511

5556

SUMMER HEAT

PUMPS

LABORATORY EQUIPMENT

NOTES:

WATER O&M PERRYMAN

1,500

2,557 3,849 28,000

4.000

Page 29:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPLACE OLD HACH C117

CHLORINE ANALYZER FOR

MANDATORY COMPLIANCE

TESTING UNDER FEDERAL

SAFE DRINKING WATER ACT

Page 30:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M PERRYMAN

TIME: 14:14PAGE: 758

SUBDBJECT

5598 OTHER EQUIPMENT

NOTES:

AUDITEDFY 12

13,650

AUDITEDFY 13

3,008

ORIGINAL8UDGETFY 14

2,800

DEPARTMENTREQUEST

FY 15

WATER O&M PERRYMAN

DAMPNER FOR SODA ASH

50 SUBTOTAL

INDEX 305220 SUBTOTAL

METERING PUMPS 2,800

51,429

700,975

36,926

682,589

72,950

865,316

Page 31:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INOEX :305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB,JECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M LONG BOOSTER STATIONS

TIME: 14:14PAGE: 759

SUBOB,JECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFV 14

DEPARTMENTREOUEST

FY 15

1101

1202

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1355

1501

1602

1801

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREOITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

Be/SS-PREFERRED PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT OIFFERENTIAL

33,431

3,830

205

1, 140

443

87

8,382

35

358

97

2,780

224

3,249

2,772

566

32,231

3.152

14

1,304

517

86

7.842

60

358

76

4,013

447

1,771

2,552

366

35.893

3,589

1.285

1,053

112

9,391

60

405

158

228

2,500

2,976

500

10 SUBTOTAL 57,599 54,789 58, 150

Page 32:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT;317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX :305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M LONG BOOSTER STATIONS

TIME' 14,14PAGE: 760

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2103

2201

2609

VEHICLE & OPERATING EQUIPMENT

ELECTRICITY

CO FACILITY REPAIR & RENOVATION

NOTES:

WATER O&M LONG BOOSTER STATION

- REHAB 2 LARGE PUMPS/

MOTORS (BYNUM, COUNTRY

800

271,066

64,925

293,604

23,342

500

290,000

42.500

WALK)

- CONTRACT PRESSURE

20,000

WASHING - FOUNTAIN GREEN

TANK 12,500

- OTHER REPAIRS AS NEEDED

10.000

2612

TOTAL

ENGINEERING SERVICES

NOTES'

42,500

50,600 65,000

CONTINUED SERVICES FOR

Page 33:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

WRITING SPECS AND

INSPECTION OF PAINTING

PROJECTS (ELEVATED

WATER TANKS AND SMALLER

PROJECTS • OTHER SITES

Page 34:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT: 30INDEX : 305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M LONG BOOSTER STATIONS

TIME: 14:14PAGE: 761

SUBOBJECT

2699 OTHER PROFESSIONAL SERVICES

2701 UNIFORM RENTAL

2704 OPERATING EQUIPMENT

2707 GROUNDS MAINTENANCE

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

2,938 325 225

664 627 700

4,088 6,845 10,100

7,517 8,062 7,763

20 SUBTOTAL 351,998 383,405 416,788

3201

3301

3302

3504

3505

3506

DELIVERY CHARGES

PAPER SUPPLIES

JANITORIAL SUPPLIES & EQUIPMENT

EQUIPMENT REPAIR PARTS

LANDSCAPE & GROUNDS MATERIAL

SMALL TOOLS

684

70

14,305

495

1,253

42

312

15,729

1,100

100

80

20,000

100

250

Page 35:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER DPERATINGPUBLIC WORKSWATER O&M LONG BDDSTER STATIDNS

TIME: 14: 14PAGE: 762

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

3513

3514

3515

3531

3532

3534

CHEMICALS IN BULK

NDTES:

CHEMICALS REQUIRED FOR

DISINFECTION TO MEET

FEDERAL SDWA STANDARDS

LABORATORY SUPPLIES

SAFETY EQUIPMENT

PAINT

DIESEL FUEL

OIL & LUBRICANTS

6,943

913

9

2,162

8

10,939

306

310

1,718

658

11,000

1,500

200

400

4,000

150

30 SUBTOTAL 25,589 31,267 38,880

Page 36:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M LONG BOOSTER STATIONS

TIME: 14: 14PAGE: 763

5UBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

5290 ELECTRONIC PROCESS CONTROL EQUIP-W&S

NOTES:

WATER D&M LONG BOOSTER STATION

ELECTRONIC

SCADA PROCESSING

CARDS FOR NEW

4,500

5315

5501

5511

5553

RADIO

ELECTRIC HEATERS

AIR COMPRESSOR

PUMPS

FLOW METER

NOTES:

4,500

546

1,293

3,999

3,406

4,999

1,500

6,400

2,000

WATER D&M LONG BOOSTER STATION

CHART RECORDER FOR

FLOW ANO PRESSURE

READINGS AT

STATIONS 2,000

Page 37:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002OIVI5ION OETAIlEO 5UMMARY BY 5UBOBJECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M lONG BOOSTER STATIONS

TIME: 14: 14PAGE: 764

SUBOBJECT

559B OTHER EQUIPMENT

NOTES:

WATER O&M LONG BOOSTER STATION

-REPLACEMENT OF OlO/

WORN EQUIPMENT •

VARIOUS BOOSTERS;

-2 MAGNA ORIVE COUP-

LINGS FOR BETTER ENERGY

EFFICIENCY. LESS PUMP/

MOTOR WEAR. 1 AT BYNUM

BOOSTER AND 1 GLEN-

RIDGE

AUDITEDFY 12

3,462

AUDITEDFY 13

14,622

ORIGINALBUOGETFY 14

25,500

DEPARTMENTREQUEST

FY 15

PHASE 2 OF 3 14,500

-REPLACE CHECK VALVE AT

PRESTON MANOR STATION.

PHASE 2 OF 3

-REPLACE AGING HACH

Cui7 CL2 ANALYZER

7,000

MONITORS Cl2 RESIOUAlS

IN THE ORINKING WATER

SYSTEM

TOTAL

4,000

25,500

Page 38:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 305240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY $UBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M LONG BOOSTER STATIONS

TIME: 14:14PAGE: 765

SUBOBJECT

5602

5699

RADIO-PORTABLE

OTHER

NOTES:

AUDITEDFY 12

AUDITEDFY 13

1,544

ORIGINALBUDGETFY 14

1,100

DEPARTMENTREQUEST

FY 15

ONE (1) RAOIO

REPLACEMENT FOR WATER

SCADA SYSTEM. THESE

TRANSMIT SIGNALS FROM

WATER TOWERS/BOOSTERS

TO CONTROL COMPUTERS

@ AWlP. WILL REPLACE

OLDEST RADIO EACH YEAR,

SO SPARE IS AVAILABLE

IN CASE OF SURGE OR

LIGHTNING STRIKE.

50 SUBTOTAL

INDEX 305240 SUBTOTAL

12.706

447,892

21.165

490,626

41,000

554.818

Page 39:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WDRKSWATER D&M HAVRE DE GRACE

TIME: 14:14PAGE: 766

SUBDBuECTAUDITED

FY 12AUDITED

FY 13

DRIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1308

1309

1319

1320

1321

1350

1501

1602

1801

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

LIFE

BC/BS-PREFERRED PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPEB

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

89,876

10,324

74

2.650

279

18,644

480

654

338

7,428

12,298

7,972

5,430

90,320

8,802

89

3,137

279

18.705

480

654

338

11,309

7.921

7.655

5,241

90,116

9.012

3.226

336

20.949

480

741

384

9,000

8,042

6,000

10 SUBTOTAL 156,447 154.930 148,286

Page 40:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISIoN DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & $EWER OPERATINGPUBLIC WORKSWATER D&M HAVRE DE GRACE

TIME: 14:14PAGE: 767

SUBOBJECT

2201

2302

2609

ELECTRICITY

TELEPHONE SERVICE

CO FACILITY REPAIR & RENOVATION

NOTES:

WATER O&M HAVRE DE GRACE

REPAIR/UPGRADES OF PLANT

AND EQUIPMENT:

-REHAB OF 1ST OF 3

FINISHED WATER

AUDITEDFY 12

115,239

3.516

197,169

AUDITEDFY 13

83, 186

3,244

36,901

ORIGINALBUDGETFY 14

150,000

3,500

49,500

DEPARTMENTREQUEST

FY 15

PUMPS

-REHAB 2ND OF 3

FINISHED WATER

MOTORS

-PAINT PIPING,

DOORS AND WALLS

INSIDE PLANT

12,500

3,500

B,500

EXTERIOR IMPROVEMENTS

TO SOUTHSIDE

OF PLANT

-OTHER REPAIRS

AS NEEDED

15,000

10,000

Page 41:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

....o....,.r

..'"'"g

Page 42:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INOEX : 305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBvECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER DaM HAVRE DE GRACE

TIME: 14:14PAGE: 768

SUBOBvECT

2699 OTHER PROFESSIONAL SERViCES

2701 UNIFORM RENTAL

2704 OPERATING EQUIPMENT

20 SUBTOTAL

ORIGINAL DEPARTMENTAUDITED AUDITED BUOGET REQUEST

FY 12 FY 13 FY 14 FY 15

15,166 11 , 161 15,000

526 4B7 500

1,150 2,020 9,085

------------- ------------- ------------- -------------332,766 136,999 227,585

3101 GENERAL OFFICE SUPPLIES 50

3201 DELIVERY CHARGES 820 1,095 800

3202 GENERAL OFFICE MAILING 25

3301 PAPER SUPPLIES 99 326 200

3302 JANITORIAL SUPPLIES & EQUIPMENT 480 627 500

3504 EQUIPMENT REPAIR PARTS 13.149 8,556 27,000

3505 LANDSCAPE & GROUNDS MATERIAL 39

Page 43:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051oEPARTMENT:30INDEX :304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION OETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14:14PAGE: 705

SUBoBUECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1304

1307

130B

1309

1319

1320

1321

1322

1350

1355

1501

1602

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHoICE-FoRMERLY FREESTATE

MPOS

LIFE

BC/BS-PREFERREO PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

HoHP

oPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

673,855

77,417

206

6,B23

15,152

1,921

67,831

3,800

1,589

3,03B

11,045

57,442

4,484

1,375

48,809

659,000

64,722

279

7,B34

25,014

1,023

59,406

3.300

654

4,646

64,034

4,473

2,368

48,481

680.811

68.081

7.872

28.016

1,260

69,632

3,600

741

5,447

4,564

1,000

51.075

10 SUBTOTAL 973,887 945.234 922.099

Page 44:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :304110

HARFORD COUNTY, MD - 5YSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WDRKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14:14PAGE: 706

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2101

2106

2201

2302

2306

2402

2603

2604

2699

DFFICE EQUIPMENT

SPACE & REAL ESTATE RENTAL

NDTES:

LEASE FOR OFFICE SPACE

LOCATED AT 145 NORTH

HICKORY AVENUE

ELECTRICITY

TELEPHONE SERVICE

FAX SERVICES

LEGAL NOTICE

MANAGEMENT SERVICES

FINANCIAL/AUDIT

OTHER PROFESSIONAL SERVICES

19,653

68,034

2,667

276

53

267

9,216

22,842

73,694

2,663

254

155

300,394

6,092

20,572

72,000

2,700

3,750

250

300

9,500

3,000

Page 45:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14:14PAGE: 707

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2706

270B

2711

DATA PROCESSING SOFTWARE-MAINTENANCE

BUILDING/CUSTODIAL SERVICES

SECURITY SYSTEMS

6,620 9,9BO 6,650

1,300

1,000

20 SUBTOTAL 106,7B6 416,074 121,022

3101 GENERAL OFFICE SUPPLIES 2,103 933 3,000

3103 PRINTING-COMMERCIAL 124 227 100

3104 DUPLICATING MACHINE SUPPLIES 99 644 1,000

3199 OTHER OFFICE SUPPLIES 1,000

NOTES:

FLOOR MATS FOR NEW

ADMINISTRATIVE BUILDING

AND MAILBOX LARGE

ENOUGH FOR PACKAGES/

DRAWINGS

3201 DELIVERY CHARGES 100 B4 200

3202 GENERAL OFFICE MAILING 902 1, 194 1,500

Page 46:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,D9/25/2013

FUND :051DEPARTMENT: 30INDEX :304110

HARFORD CDUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME, 14,14PAGE: 708

SUBOBJECT

3301 PAPER SUPPLIES

NDTES,

AUDITEDFY 12

AUDITEDFY 13

ORIGINALBUDGETFY 14

500

DEPARTMENTREQUEST

FY 15

PAPER SUPPLIES FOR

NEW ADMINISTRATIVE

BUILDING

3302

3506

vANITORIAL SUPPLIES & EQUIPMENT

NOTES,

TRASH BAGS FOR NEW

ADMINISTRATIVE

BUILDING

SMALL TODLS

NOTES:

SNDW SHOVEL FOR NEW

ADMINISTRATIVE

BUILDING

54

7

100

25

Page 47:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX ;304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBuECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATIDN

TIME: 14; 14PAGE: 709

SU8D8JECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3507

3512

3515

3516

3528

3530

AUDID VISUAL SUPPLIES

DRAFTING & DISPLAY SUPPLIES

SAFETY EQUIPMENT

NOTES:

FIRE EXTINGUISHERS

FOR NEW ADMINISTRATIVE

BUILDING

MEDICAL SUPPLIES

NDTES:

1ST AID KIT FOR

NEW ADMINISTRATIVE

BUILDING

COMPUTER SUPPLIES

TRAFFIC SIGNS AND MARKINGS 219

156

101

540

100

150

30 SUBTOTAL 3,541 3,406 8,215

Page 48:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :304110

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB~ECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSAOMINISTRATION

TIME: 14:14PAGE: 710

ORIGINALAUDITED AUDITED BUDGET

SUBOB~ECT FY 12 FY 13 FY 14

4101 COUNTY OWNED VEHICLES 1,423 1,463 300

DEPARTMENTREQUEST

FY 15

4104

4108

4201

4202

4301

4401

4402

4502

4601

4703

FUEL CHARGES

NON-TARGETED CHARGES-FVS

MILEAGE

PARKING AND TOLLS

TRANSPORTATION COSTS

MEALS

LODGING

PROFESSIONAL BOOKS & PERIODICALS

MEMBERSHIP FEES & DUES

TRAINING SEMINARS, COURSES & MEETINGS

NOTES:

TRAINING FOR NINE (9)

EMPLOYEES TO ATTEND

ONE (1) COURSE AT

$125 EACH

2,592

197

52

364

15,099

1,012

2,232

459

64

377

9

157

682

15,140

420

2,000

200

50

200

100

100

300

17,000

1,125

Page 49:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPDRT:317DATE :09/25/2013

FUND :051oEPARTMENT:3oINDEX :304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14:14PAGE: 711

SUBoBJECT

40 SUBTOTAL

AUDITEDFY 12

20,739

AUDITEDFY 13

21,003

ORIGINALBUDGETFY 14

21,375

DEPARTMENTREQUEST

FY 15

Page 50:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051DEPARTMENT:3QINOEX :304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14: 14PAGE: 712

SUBOBJECTAUOITEO

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

5210

5220

5229

5302

AUDIO VISUAL SUPPLIES

NOTES:

PROJECTOR FOR TRAINING

ROOM AND MONITOR FOR

ENTRANCE WAY

PERSONAL COMPUTER

VACUUM CLEANER

NOTES:

FOR NEW AOMINISTRATIVE

BUILDING

CHAIRS

NOTES:

75 FOLOING CHAIRS FOR

TRAINING ROOM IN NEW

ADMINISTRATIVE BUILDING

495

2,610

280

3.150

Page 51:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14:14PAGE: 713

SUBOBJECT

5306 TABLES

NOTES:

FOUR (4) FOLDING TABLES

IN TRAINING ROOM AND FOUR

(4) TABLES IN LUNCH ROOM

AUDITEDFY 12

AUDITEDFY 13

ORIGINALBUDGETFY 14

2,500

DEPARTMENTREQUEST

FY 15

50 SUBTOTAL 495 8,540

7301 PRO RATA SHARES 1,"461,476 1,967,196 2,268,666

70 SUBTOTAL 1,461,476 1,967, 196 2,268,666

Page 52:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :304110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSADMINISTRATION

TIME: 14:14PAGE: 714

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

8233 FLEET DAILY CARPOOL RENTALS 22

80 SUBTOTAL

INDEX 304110 SUBTOTAL

22

2,566,952 3.352.913 3,349,917

Page 53:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :304130

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSDEPRECIATION

TIME: 14:14PAGE: 715

SUBOBJECT

7501 DEPRECIATION

AUDITEDFY 12

9,638,801

AUDITEDFY 13

10,824,246

ORIGINALBUDGETFY 14

9,200,000

DEPARTMENTREQUEST

FY 15

70 SUBTOTAL

INDEX 304130 SUBTOTAL

9,638,801

9,638,801

10,824,246

10,824,246

9,200,000

9,200,000

Page 54:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INOEX :304140

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARV BV SUBOBJECT

FISCAL VEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSGENERAL INVENTORY

TIME: 14:14PAGE: 716

SUBOBJECTAUDITED

FV 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FV 15

3699 OTHER (AUDIT ONLY) 50,000

30 SUBTOTAL

INDEX 304140 SUBTOTAL

50,000

50,000

Page 55:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 304200

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBvECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSINDUSTRIAL WASTE MANAGEMENT

TIME: 14:14PAGE: 717

SUBOBvECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1304

1307

1308

1309

1320

1321

1350

1355

1501

1602

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

Be/aS-PREFERRED PROVIDER

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

97,708

11,219

59

2,339

1,578

2,631

209

21,671

1,018

402

8,066

B97

9,312

7,864

97,532

9,548

14

2,697

17,7B4

210

3,804

1,018

319

10,572

B95

9,618

8.028

97,373

9,737

2,762

19,919

252

4,261

1.154

363

913

9,000

8,099

10 SUBTOTAL 164,973 162,039 153,833

Page 56:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :304200

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSINDUSTRIAL WASTE MANAGEMENT

TIME: 14:14PAGE: 718

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2302

2499

2699

TELEPHONE SERVICE

OTHER ADVERTISING

NOTES:

EPA REQUIRED NOTICE OF

PUBLICATION FOR

INDUSTRIAL VIOLATIONS

OTHER PROFESSIONAL SERVICES

NOTES:

INDUSTRIAL WASTE MANAGEMENT

- CONTRACT LAB SERVICES

FOR TESTING INOUSTRIAL

SAMPLES FOR FED/STATE

REGULATORY COMPLIANCE

1,214

2,936

1,300

2,251

1,200

200

3,000

MONITORING

20 SUBTOTAL

3,000

4,150 3,551 4,400

Page 57:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUNO :051OEPARTMENT:30INOEX :304200

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSINDUSTRIAL WASTE MANAGEMENT

TIME: 14:14PAGE: 719

SUBOBJECTAUOITEO

FY 12AUOITEO

FY 13

ORIGINALBUDGETFY 14

OEPARTMENTREOUEST

FY 15

3101

3103

3202

3514

GENERAL OFFICE SUPPLIES

PRINTING-COMMERCIAL

NOTES:

PRINT PRE-NUMBEREO SEPTIC

HAULER PERMITS, 3-PART

HAULER MANIFESTS,SEPTIC

HAULER TRUCK OECALS,

AND BUSINESS CARDS

GENERAL OFFICE MAILING

NOTES:

MAILING INDUSTRIAL

PERMIT PACKAGES ANO

NOTICES

LABORATORY SUPPLIES

1,365

80

24

485

1 , 111

60

1,800

100

Page 58:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 304200

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WDRKSINDUSTRIAL WASTE MANAGEMENT

TIME: 14:14PAGE: 720

AUDITEDSUBOBvECT FY 12

3515 SAFETY EQUIPMENT

30 SUBTOTAL

120

1,589

AUDITEDFY 13

95

1,751

DRIGINALBUDGETFY 14

125

2,025

DEPARTMENTREOUEST

FY 15

4202

4502

4601

4703

PARKING AND TOLLS

PROFESSIONAL BOOKS & PERIODICALS

NOTES:

BOOKS/OTHER PUBLICATIONS

RELATED TO INDUSTRIAL

TREATMENT AND COMPLIANCE

WITH PRETREATMENT

STANDARDS

MEMBERSHIP FEES & DUES

TRAINING SEMINARS. COURSES & MEETINGS

10

20

130

95

30

100

20

250

40 SUBTOTAL 160 95 400

Page 59:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 304200

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSINDUSTRIAL WASTE MANAGEMENT

TIME: 14:14PAGE: 721

SUBOBJECT

INDEX 304200 SUBTOTAL

AUDITEDFY 12

170,872

AUDITEDFY 13

167,436

ORIGINALBUDGETFY 14

160,658

DEPARTMENTREQUEST

FY 15

Page 60:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :304300

HARFORO COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 722

5UBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1304

1307

130B

1309

1319

1320

1321

1350

1355

1501

1602

1B01

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

BC/BS-PREFERRED PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

151,330

17,012

334

5,441

9,336

1,316

296

19,657

240

120

1,750

14,852

8,070

17,926

13,029

1,169

131,315

12,935

35

5,031

26, 102

324

4,165

240

413

1,673

9,442

7,158

15,015

11,268

3,040

133,335

13,333

4,325

31, B64

399

4,664

574

1,931

7,302

18,000

11,654

1,000

10 SUBTOTAL 261,878 228,156 228,381

Page 61:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT: 30INDEX ,304300

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLI C WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 723

AUDITEDSUBOBJECT FY 12

2101 OFFICE EQUIPMENT

2103 VEHICLE & OPERATING EQUIPMENT

NOTES,

RENT OF HIGH LIFT, WELDING

TANKS AND OTHER SPECIALIZED

EQUIPMENT THAT IS MORE COST

EFFECTIVE TO RENT THAN

PURCHASE FOR OCCASIONAL

USE

659

257

AUDITEDFY 13

664

166

ORIGINALBUDGETFY 14

660

250

DEPARTMENTREQUEST

FY 15

2201 ELECTRICITY

NOTES'

PROJECTED FY 14 COST

ELECTRICAL BUOGET WILL

INCREASE WITH THE ENR

UPGRADE DUE TO

INCREASED NUMBER OF

PUMPS, LIGHTING AND

PROCESS EQUIPMENT.

151.878 142.087 250,000

Page 62:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT: 30INDEX :304300

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 724

SUBOBJECTAUOITEO

FY 12AUDITED

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FY 15

2202

2302

2306

2499

2609

HEATING FUEL (GAS)

TELEPHONE SERVICE

FAX SERVICES

OTHER ADVERTISING

CO FACILITY REPAIR & RENOVATION

NOTES:

JOPPATOWNE SEWAGE

TREATMENT PLANT

REPAIR PROJECTS

-INSTALLATION COST

FOR THE NEW WEIR COVERS

ON #2 OF 3 SECONDARY

1,158

8,502

277

69,766

1,212

10,376

238

181

108,799

1,250

9,500

300

130,500

CLARIFIERS

-INSTALL LIGHTNING

PROTECTION FOR SLOGS

IN PLANT. LIGHTNING

STRIKE DAMAGE IN AUG

22,000

2012.PH 1 OF 3. 30,000

-INSTALLATION OF OIFFUSERS

TO SUPPLY AIR TO THE

Page 63:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

EFFLUENT TO INCREASE

THE D.O. (DISSOLVED

DXYGEN)LEVEL BEFORE

DISCHARGE. THE NEW

ENR PROCESS WILL

REDUCE THE DO LEVEL

IN THE FILTERS. 3.500

-REBUILD OR

REPLACEMENT OF (1)

PUMP IN PUMPING

STATION H51A.THESE

PUMPS HAVE BEEN IN

SERVICE SINCE 1987.

REBUILD/REPLACEMENT

2 OF 2. 25,000

EVALUATE & REHAB

HVAC SYSTEM IN

ADMINISTRATION

BUILDING INCLUDING

15 YEAR OLD HEAT

PUMP 20,000

- OTHER REPAIRS AS

NEEDED TO PLANT AND

EQUIPMENT 30.000

Page 64:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:3QINDEX :304300

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 725

SUBOBvECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2612

2699

ENGINEERING SERVICES

OTHER PROFESSIONAL SERVICES

NOTES:

vOPPATOWNE SEWERAGE

TREATMENT PLANT

- CONTRACT LAB

SERVICES -NEW INCREASED

375

10,373

9,818

8,410 8.710

2701

2703

2704

MONITORING

-CONTRACT COURIER TO

TRANSPORT LAB

SAMPLES

EMERGENCY PUMP OUTS

AS NEEDED

UNIFORM RENTAL

COMMUNICATION SERVICE

OPERATING EQUIPMENT

S,910

2,300

500

904

950

6,435

858

950

12,310

1,000

1,000

17 ,040

Page 65:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051OEPARTMENT,30INDEX ,304300

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME' 14,14PAGE, 726

SUBDBJECTAUDITED

FY 12AUDITED

FV 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2707

270B

GROUNDS MAINTENANCE

BUILDING/CUSTODIAL SERVICES

4,555

5.4B2

5,823

6.067

4,555

5.BOO

20 SUBTOTAL 261,571 307.959 430,565

3101 GENERAL OFFICE SUPPLIES a43 1,015 500

3199 OTHER OFFICE SUPPLIES B1

3201 DELIVERY CHARGES 754 619 500

3202 GENERAL OFFICE MAILING 30 B2 30

3301 PAPER SUPPLIES 54 50

3302 JANITORIAL SUPPLIES & EQUIPMENT 66 50

3504 EQUIPMENT REPAIR PARTS 24,848 20,877 65,000

3506 SMALL TOOLS Boa 1,006 500

Page 66:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPDRT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :304300

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 727

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3510

3513

BUILDING SUPPLIES

CHEMICALS IN BULK

NOTES:

THE CHEMICAL BUDGET

WILL INCREASE WITH

THE ENR UPGRADE

402

25,430 20,920

200

49,700

3526 COMPUTER SOFTWARE

3528 COMPUTER SUPPLIES

3527 COMPUTER HARDWARE COMPONENTS

3514

3515

3531

3532

LABORATORY SUPPLIES

SAFETY EQUIPMENT

PAINT

DIESEL FUEL

156

199 1,382

1,452

791

63

79

4,189 2,504

160

300

50

5.000

Page 67:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :304300

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPA TOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 728

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FY 15

3534 OIL & LUBRICANTS 159 100

30 SUBTOTAL 57,867 50,942 122,140

4101 COUNTY OWNED VEHICLES 2,201 3.933 2,500

4104 FUEL CHARGES 4,406 5,154 4.000

4108 NON-TARGETED CHARGES-FVS 1,300 663 1,000

4502 PROFESSIONAL BOOKS & PERIODICALS 50

4703 TRAINING SEMINARS, COURSES & MEETINGS 550 500

------------- ------------- ------------- -------------40 SUBTOTAL 7,907 10.300 8,050

Page 68:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUNO :051DEPARTMENT: 30INDEX :304300

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY 8Y SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 729

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

OEPARTMENTREQUEST

FY 15

5142

5222

5290

5299

5508

5511

5553

5556

5598

W&S-PLANT IMPROVEMENTS

PRINTER

ELECTRONIC PROCESS CONTROL EQUIP-W&S

OTHER OFFICE EQUIPMENT

GENERATORS

PUMPS

FLOW METER

LABORATORY EQUIPMENT

OTHER EQUIPMENT

NOTES:

3RD OF 6 PROCESS MIXER

REPLACEMENTS PLANT'S SIX

PROCESS REACTOR MIXERS.

AGE AND DETERIORATION

NECESSITATE REPLACEMENT/

UPGRADE

-PURCHASE WEIR COVERS

ON #2 OF 3 SECONOARY

CLARIFIERS. COVERS

-747

1.139

28,829

1,612

8,345

927

680

20,758

1,000

12,767

2,062

6.678

3,937 50.000

Page 69:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

TO STOP ALGAE GROWTH

AND WHICH CAUSES

PROBLEMS WITH NEW

ENR DENITRIFICATION

FILTERS

Page 70:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPDRT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX : 304300

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSJOPPATOWNE SEWERAGE TREAT PLAN

TIME: 14:14PAGE: 730

SUBOB0ECT

5699 OTHER

NOTES:

AUDITEDFY 12

1,580

AUDITEDFY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

50 SU8TDTAL 40,758 48,809 50,000

7102 PAYMENTS TO OTHER GOVT AGENCIES 10,430 10,000 11,000

70 SUBTOTAL

INDEX 304300 SU8TDTAL

10,430

640,411

10,000

656,166

11,000

850,136

Page 71:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,D9/25/2013

FUND ,051DEPARTMENT:30INDEX ,305101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBuECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER ENGINEERING

TIME: 14:14PAGE: 731

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1501

1602

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

BC/BS-PREFERRED PRDVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPEB

DVERTIME

SOCIAL SECURITY

405,161

46,521

491

2,600

14,659

582

44,670

600

915

2,571

33,451

30,008

406,502

39,803

135

3,012

23,651

582

32,601

600

987

2,571

50,924

30,538

466,149

46,615

3,075

25,224

840

54,771

600

1,036

4,063

200

35,646

10 SUBTDTAL 582,229 591,906 638,219

Page 72:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPU8LIC WORKSWATER ENGINEERING

TIME: 14:14PAGE; 732

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2101

2302

2402

2699

2899

OFFICE EQUIPMENT

TELEPHONE SERVICE

LEGAL NOTICE

OTHER PROFESSIONAL SERVICES

OTHER

1,107

612

10,952

3,146

561

21,131

3,000

600

100

21,450

100

20 SUBTOTAL 12,671 24,838 25,250

3101

3103

3104

3201

3202

GENERAL OFFICE SUPPLIES

PRINTING-COMMERCIAL

DUPLICATING MACHINE SUPPLIES

DELIVERY CHARGES

GENERAL OFFICE MAILING

1,032

128

99

9

522

111

18

-3

1,100

50

250

Page 73:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :305101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER ENGINEERING

TIME: 14:14PAGE: 733

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3302

3506

3507

3512

3515

3526

~ANITORIAL SUPPLIES & EQUIPMENT

SMALL TOOLS

AUDIO VISUAL SUPPLIES

DRAFTING & DISPLAY SUPPLIES

SAFETY EQUIPMENT

COMPUTER SOFTWARE

314

32

3

63

54

61

500

150

300

30 SUBTOTAL 1,582 861 2,350

4104

4202

4502

4601

4703

FUEL CHARGES

PARKING ANO TOLLS

PROFESSIONAL BOOKS & PERIODICALS

MEMBERSHIP FEES & DUES

TRAINING SEMINARS, COURSES & MEETINGS

25

65

16B

525

25

354

34

210

100

50

100

300

600

40 SUBTOTAL 783 623 1,150

Page 74:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX :305101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB0ECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER ENGINEERING

TIME: 14:14PAGE: 734

SUBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

5220 PERSONAL COMPUTER 495

50 SUBTOTAL

INDEX 305101 SUBTOTAL

495

597,760 618,228 666,969

Page 75:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT ,30INOEX :305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET,

WATER & SEWER OPERATINGPUBLI C WORKSWATER O&M HAVRE DE GRACE

TIME: 14:14PAGE: 769

SUBOBJECT

3506 SMALL TOOLS

AUDITEDFY 12

AUDITEDFY 13

41

ORIGINALBUDGETFY 14

200

DEPARTMENTREQUEST

FY 15

3507

3513

3514

3515

3516

3527

3528

3531

3532

3534

AUDIO VISUAL SUPPLIES

CHEMICALS IN BULK

LABORATORY SUPPLIES

SAFETY EQUIPMENT

MEDICAL SUPPLIES

COMPUTER HARDWARE COMPONENTS

COMPUTER SUPPLIES

PAINT

DIESEL FUEL

OIL & LUBRICANTS

230

26,887 19,081 40,000

5,486 8,519 6,000

405 525 400

8 84 25

133

83 100

111 100

6,564 2,262 6,500

418 1,767 400

30 SUBTOTAL 54,599 43,246 82,250

Page 76:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUNO :051OEPARTMENT:30INOEX : 305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M HAVRE DE GRACE

TIME: 14: 14PAGE: 770

AUDITEDSUBOBJECT FY 12

4703 TRAINING SEMINARS, COURSES & MEETINGS

40 SUBTOTAL

50

50

AUDITEDFY 13

600

600

ORIGINALBUoGETFY 14

300

300

DEPARTMENTREoUEST

FY 15

5315

5501

5511

5598

ELECTRIC HEATERS

AIR COMPRESSOR

PUMPS

OTHER EQUIPMENT

NOTES:

WATER D&M HAVRE DE GRACE

-INSTALL HACH 1720E

TURBIDIMETER

WITH 5E2oo CONTROLLER.

NEED TO REPLACE THIS

AGING ANALYZERS FOR

COMPLIANCE

778

13.231

304

2. 118

10.174

19,583

750

4,300

27,700

TESTING 8.700

-REPLACE 1 AGING HACH

C117 CHLORINE ANALYZER

FOR COMPLIANCE TESTING.

Page 77:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

VERY CRITICAL FOR PLANT

OPERATIONS 4,000

-REPLACE AGING CHECK

VALVE ON PUMP #2

PHASE 2 OF 3 15,000

TOTAL 27,700

Page 78:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX : 305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M HAVRE DE GRACE

TIME: 14:14PAGE: 771

SUBOBJECT

50 SUBTOTAL

AUDITEDFY 12

14,009

AUDITEDFY 13

32.179

ORIGINALBUDGETFV 14

32,750

DEPARTMENTREQUEST

FY 15

Page 79:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305250

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M HAVRE DE GRACE

TIME: 14:14PAGE: 772

SUBoBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

8212

8225

8233

8799

INSPECTION

APPLIED OVERHEAD

FLEET DAILY CARPOOL RENTALS

OTHER INTERGOVERNMENTAL

NOTES:

MONTHLY PAYMENTS TO CITY

OF HAVRE DE GRACE FOR

PURCHASE OF FINISHED WATER.

520,000

4,OB9

3,435

140

300,000 620,000

80 SUBTOTAL

INDEX 305250 SUBTOTAL

520,000

1,077,871

307,664

675,618

620,000

1,111,171

Page 80:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051DEPARTMENT:3QINOEX :305255

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER DaM SOLIDS HANDLING FACILITY

TIME: 14:14PAGE: 773

SUBOBJECTAUOITEO

FY 12AUOITEO

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2609

2699

2704

CO FACILITY REPAIR & RENOVATION

NOTES:

WATER D&M SOLIDS

HANOLING FACILITY

-REPAIRS TO FACILITY

ANO EQUIPMENT AS

THEY AGE

OTHER PROFESSIONAL SERVICES

OPERATING EQUIPMENT

5,000

43 19

5,000

6,000

2,000

20 SUBTOTAL 43 19 13,000

Page 81:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :305255

HARFORO COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M SOLIDS HANDLING FACILITY

TIME: 14:14PAGE: 774

SUBOBJECT

3504

3506

3513

3515

3532

3534

EQUIPMENT REPAIR PARTS

SMALL TOOLS

CHEMICALS IN BULK

SAFETY EQUIPMENT

DIESEL FUEL

OIL & LUBRICANTS

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

112 5.000

417

13.000

300

2,452 847 6.000

257 100

30 SUBTOTAL 3.238 847 24.400

5511 PUMPS 2.800

50 SUBTOTAL

INDEX 305255 SUBTOTAL 3.281 866

2.800

40,200

Page 82:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INOEX : 305260

HARFORO COUNTY. MO - SYSTEMWIOE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M uOPPATOWNE

TIME: 14: 14PAGE: 775

SUBOBJECTAUDITEO

FY 12AUOITEO

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1201

1202

1301

130B

1309

1321

1350

1501

1602

CURRENT AUTHORIZED POSITIONS

RETIREMENT (OLO)

PENSION (NEW)

WORKER'S COMPENSATION

LIFE

BC/BS-PREFERREO PROVIOER

OELTA OENTAL PLUS

OPEB

OVERTIME

SOCIAL SECURITY

28.815

4.423

647

29

3,317

188

2,379

314

2.123

10,139

3.100

746

12

1,382

78

3,621

840

27,748

2.775

738

35

4,564

287

2.123

10 SUBTOTAL 42,235 19,918 38,270

2802 TELEPHONE SERVICE 448 26

20 SUBTOTAL 448 26

Page 83:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051DEPARTMENT:30INDEX :305260

HARFORD CDUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M JOPPA TOWNE

TIME: 14: 14PAGE: 776

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3201

3506

3515

3518

3519

3601

DELIVERY CHARGES

SMALL TDDLS

SAFETY EQUIPMENT

WATER METER REPAIR PARTS

NOTES:

CONTINUATION OF

PLAN FOR MONTHLY

METER READING

W&S LINES SERVICE PARTS

WATER METER PUCHASES

NDTES,

CONTINUATION OF

PLAN FOR MONTHLY

METER READING

15

60

413

11,633

246

39,997

15

586

50,000

21,000

50,000

30 SUBTDTAL

INDEX 305260 SUBTOTAL

52,364

95,047

50,601

70,545

71,000

109,270

Page 84:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 777

SUBOBJECT

10 SUBTOTAL

1101

1202

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1355

1501

1602

1801

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

8C/BS-PREFERREo PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

oPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

1.548.347 1,464,715 1.630.524

177,219 152,016 163.052

760 691

44,715 49,895 50.935

40,596 86,702 108,035

31.280

3.440 3,449 4,333

208.224 187.051 217,443

6.795 6.920 7.140

5.266 5.250 6,128

11. 101 11.231 13,882

119,180 161,477

38,783 37,343 34.228

187,770 101,747 125.000

132.194 125.895 136,321

30.330 26.516 28,000

------------- ------------- ------------- -------------2.586.000 2.420.898 2,525,021

Page 85:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX : 305280

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPU8LIC WORKSWATER O&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 778

SUBOBJECT

2101 OFFICE EOUIPMENT

2103 VEHICLE & OPERATING EQUIPMENT

2199 OTHER RENTS & UTILITIES

NOTES:

RENTAL OF GAS

CYLINDER FOR LA8

TESTING AND

FOR OPERATION

OF FORKTRUCK

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

6.195 6,075 6,200

786 500

1.461 3,125 1,000

2201

2204

2302

2306

ELECTRICITY

HEATING FUEL(OIL)

TELEPHONE SERVICE

FAX SERVICES

527,461

22.796

15,067

290

575.847

16,578

17,809

264

600.000

27.000

16,000

280

Page 86:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT,30INDEX ,305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON-BIG INCH

TIME: 14: 14PAGE: 779

SUBOBJECT

2402 LEGAL NOTICE

NOTES:

ANNUAL PUBLICATION OF

CONSUMER CONFIDENCE

REPORT IN LOCAL PAPER

AS REQUIRED BV EPA

AUDITEDFY 12

3,334

AUDITEDFV 13

3,334

ORIGINALBUDGETFY 14

3,500

DEPARTMENTREQUEST

FV 15

2609 CO FACILITY REPAIR & RENOVATION

NOTES,

WATER O&M ABINGDON-BIG INCH

-PHASE 3 OF 5 OF MULTI-

VEAR PROJECT TO REPLACE

TWO 24" FINISHED WATER

BUTTERFLY VALVES ON ZONE

2 PIPING. (CONTRACT

116,689 233,546 103,500

FOR LABOR DNL V)

-PHASE 9 OF MULTI-

19,000

YEAR PROJECT TO REPLACE

THREE 24" BUTTERFLY

VALVES ON TRI-CON

SETTLED WATER PIPING

Page 87:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

(LABOR ONLY) 28,000

-PAINT 6 EXTRA LARGE

OUTSIDE ODORS AND 7

REGULAR DOORS. REPAIR

OR REPLACE TWO

OUTSIDE DOORS 11,500

-REGULAR REPAIRS AS

NEEDED FOR PLANT

AND EQUIPMENT FOR

EXPANED PLANT 45,000

TOTAL 103,500

Page 88:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :305280

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 780

SUBOBJECTAUOITEO

FY 12AUDITED

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FY 15

2612

2699

2701

2703

ENGINEERING SERVICES

OTHER PROFESSIONAL SERVICES

NOTES:

CONTRACT LAB SERVICES

FOR DRINKING WATER AND

TREATMENT PROCESS

MONITORING

ANNUAL WATER PLANT

LAGOON CLEAN OUT

UNIFORM RENTAL

COMMUNICATION SERVICE

NOTES:

AWTP'$ SHARE OF

SERVICE CONTRACT ON

VEHICLE-MOUNTED

RAOIOS

2,000

81,013

6,303

910

100,035

5,B47

910

60,000

6,300

910

Page 89:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT:30INOEX :305280

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER a SEWER OPERATINGPUBLIC WORKSWATER OaM ABINGOON-BIG INCH

TIME: 14:14PAGE: 781

SU80BJECT

2704 OPERATING EOUIPMENT

2707 GROUNDS MAINTENANCE

270B BUILOING/CUSTOOIAL SERVICES

2799 OTHER

NOTES:

IMPLEMENTATION

OF CITYWORKS PROGRAM

SOFTWARE LINKING

WATER TREATMENT WITH

WATER/WASTEWATER

MAINTENANCE. EXPANSION

OF PROGRAM FROM

ORIGINAL SITE IN W&S

MAINTENANCE INTO

OPERATIONS

ORIGINAL DEPARTMENTAUDITED AUDITED BUOGET REQUEST

FY 12 FY 13 FY 14 FY 15

16, 156 18,507 23,180

1,421 4,176 2,500

6,774 B,008 8,000

100,000

2803 UTILITY WATER a SEWER PURCHASE

NOTES:

170,761 180.416 190,000

Page 90:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

RAW WATER PURCHASED

FROM BALTIMORE CITY

DELIVERED THROUGH BIG

INCH

Page 91:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT,30INDEX ,305280

HARFORO COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER OaM ABINGDON-BIG INCH

TIME: 14: 14PAGE: 782

SU8D8JECT

2899 OTHER

AUDITEDFY 12

1,525

AUDITEDFY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

20 SUBTDTAl 9BO,942 1,174,477 1,148,870

3101 GENERAL OFFICE SUPPLIES 5,139 2,639 2,000

3102 PRINTING-IN-HOUSE 106 51

3103 PRINTING-COMMERCIAL 1,849 1,995 1,750

NOTES,

PRINTING EPA MANDATED

CONSUMER CONFIDENCE

REPORTS DISTRIBUTED TO

ALL HARFORD COUNTY

WATER CUSTOMERS IN

QUARTERLY WATER AND

SEWER BILLINGS

3104 DUPLICATING MACHINE SUPPLIES 543 895 600

Page 92:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 783

SUBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3201

3202

3301

3302

3399

3401

3402

DELIVERY CHARGES

GENERAL OFFICE MAILING

PAPER SUPPLIES

JANITORIAL SUPPLIES & EQUIPMENT

OTHER JANITORIAL SUPPLIES

MEALS-SPECIAL PURPOSE

NOTES:

MEAL VOUCHERS FOR

EMPLOYEES ON EMERGENCY

OVERTIME PER HARFORD

COUNTY POLICY AND UNION

AGREEMENT.

ICE AND BOTTLED WATER

NOTES:

ICE FOR TRANSPORT OF

WATER SAMPLES. DISTILLED

2,56B

50

812

1,917

1,516

308

5,228

73

454

1,854

57

933

336

2,500

100

900

1,300

1,500

400

Page 93:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

WATER FOR LAB USE.

Page 94:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX : 305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WDRKSWATER CaM ABINGDON-BIG INCH

TIME: 14:14PAGE: 784

SUBOBJECT

3504

3505

3506

3513

3514

EOUIPMENT REPAIR PARTS

LANDSCAPE & GROUNDS MATERIAL

SMALL TOOLS

CHEMICALS IN BULK

LABORATORY SUPPLIES

NOTES:

ADDITIONAL REAGENTS FOR

NEW ANALYZERS, MORE

THAN 3 TIMES NUMBER OF

ANALYZERS IN NEW PLANT

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REOUEST

FY 12 FY 13 FY 14 FY 15

41,214 49,755 69,700

119 49 100

1,695 2,465 2,000

370,867 527,534 500,000

39,556 25,679 36,000

3515

3516

3521

SAFETY EQUIPMENT

MEDICAL SUPPLIES

SAND, SALT & OTHER BULK DE-ICERS

7,939

80

480

5,703

82

720

7,000

100

400

Page 95:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX : 305280

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 785

SU8DBJECT

3526

3527

3528

3531

3532

3534

3595

COMPUTER SOFTWARE

COMPUTER HARDWARE COMPONENTS

COMPUTER SUPPLIES

PAINT

DIESEL FUEL

OIL & LUBRICANTS

NDTES:

PLANT EXPANSION HAS

2+ TIMES EQUIPMENT

AND MIXERS REQUIRING

MAINTENANCE TO

MANUFACTURERS' SPECS

UNANTICIPATED MAINTENANCE

NOTES:

CONTINGENCY FOR

DRIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

88

168

1,643 3,095 2,000

1,073 359 500

5,917 3,555 10,000

326 4,683 6,500

30,000

Page 96:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

UNEXPECTED EMERGENCIES

IN WATER PLANT AND

WATER DISTRIBUTION

SYSTEM

Page 97:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051DEPARTMENT:30INDEX :305280

HARFDRD CDUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISIDN DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON-BIG INCH

TIME: 14: 14PAGE: 786

SUBOBJECT

30 SUBTOTAL

AUDITEDFY 12

484,985

AUDITEDFY 13

638,282

ORIGINALBUDGETFY 14

675,350

DEPARTMENTREQUEST

FY 15

Page 98:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX : 305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 787

$UBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGErFY 14

DEPARTMENTREQUEST

FY 15

4101

4104

4108

4201

4202

4502

4601

4702

4703

COUNTY OWNED VEHICLES

FUEL CHARGES

NON-TARGETED CHARGES-FV$

MILEAGE

PARKING AND TOLLS

PROFESSIONAL BOOKS & PERIODICALS

MEMBERSHIP FEES & DUES

IN-HOUSE TRAINING

TRAINING SEMINARS. COURSES & MEETINGS

12,292

25,020

5,486

120

153

185

49

1.825

8,400

30,369

2,516

16

49

729

3,740

3,003

13,000

20,000

5,000

50

200

200

3,700

40 SUBTOTAL 45, 130 48,822 42. 150

Page 99:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT:30INDEX ;305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET,

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 788

SUBDBJECT

5233

5290

SHREDDER

ELECTRONIC PROCESS CONTROL EQUIP-W&S

NOTES;

WATER O&M ABINGDON-BIG INCH

REPLACEMENT PARTS FOR

CRITICAL CONTROL EQUIP-

MENT: 3 UPS, 2 WORK

STATIONS, 3 SCADA

AUDITEDFY 12

200

2,366

AUDITEDFY 13

ORIGINALBUDGETFY 14

10,000

DEPARTMENTREQUEST

FY 15

MONITORS, PROCESS

5304

5315

5316

LOGIC CONTROLLER,

1 INDUSTRIAL MODEM 10,000

SHELVING

ELECTRIC HEATERS

AIR CONDITIONERS

NOTES:

WATER O&M ABINGDON-BIG INCH

AIR CONDITIONER FOR

STOREKEEPERS' QFFICE

4,100

2,097

979

1,500

1,500

Page 100:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

IN FORMER CHLORINE

ROOM 1,500

Page 101:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051DEPARTMENT:30INOEX :305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGOON-BIG INCH

TIME: 14:14PAGE: 789

SUBOBJECT

5501 AIR COMPRESSOR

AUDITEDFY 12

AUOITEOFY 13

348

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

5503

5511

5515

5553

5556

BLOWERS

PUMPS

SPREADERS

FLOW METER

LABORATORY EQUIPMENT

NOTES,

WATER D&M ABINGDON-BIG INCH

-1 HACH C17 CHLORINE

ANALYZER. 1 OF 3 TO

REPLACE AGING UNITS

FOR MANDATORY COM-

8,822

2,697

2,544

9,091

8,485

5,352

1,396

8,493

18,200

4,000

5598

PLIANCE TESTING

OTHER EQUIPMENT

NOTES:

4,000

10,277 47,974 66,300

Page 102:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

- BUTTERFLY VALVES­

MULTI-YEAR PROJECTS:

THREE & FOUR OF 28

24" VALVES 27,000

- REPLACE 1 MIXER

PER YEAR ON-GOING

PROJECT 3,200

-REPLACE 18+ YR

OLD 15 HP VFO FOR

WASTE PUMP PHASE

2 OF 2 3,500

-REPLACE LEVEL

TRANSMITTER FOR

FERRIC BULK TANK.

CRITICAL TO MONITOR

TANK LEVEL DURING

FILLING SO TANK

OOES NOT OVERFLOW 3,400

-REPLACE 18+ YEAR

OLO LOW RANGE

TURBIDIMETER WITH

CONTROLLER. CRITICAL

TO OAILY OPERATIONS

TO MAINTAIN CONTINUOUS

WATER QUALITY

MONITORING 4, 000

-SHELVING FOR NEW

INVENTORY CONTROL

ROOM 3,000

-3 HACH 1720E TURBI­

OIMETERS WITH SC2QO

CONTROLLER. PHASE 1

OF 3 FOR COMPLIANCE

Page 103:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

TESTING 8,700

-REPLACE COAGULANT

DAY TANK MIXER 13,500

TOTAL 66,300

Page 104:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305280

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M ABINGDON-BIG INCH

TIME: 14:14PAGE: 790

SUBOBJECT

5602 RADIO-PORTABLE

AUDITEDFV 12

515

AUDITEDFY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

50 SUBTOTAL

INDEX 305280 SUBTOTAL

42.109

4,139,766

73,027

4,355,506

101,500

4,492,891

Page 105:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :305290

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M-CARBON TREATMENT PLAN

TIME: 14:14PAGE: 791

SUBOBJECT

2201

2609

2704

ELECTRICITY

CO FACILITY REPAIR & RENOVATION

OPERATING EQUIPMENT

AUDITEDFY 12

4,646

90

AUDITEDFY 13

6,160

90

ORIGINALBUDGETFY 14

7,000

200

90

DEPARTMENTREQUEST

FY 15

20 SUBTOTAL 4,736 6,250 7,290

3201 DELIVERY CHARGES 76 24 100

3504 EQUIPMENT REPAIR PARTS 131 200

3514 LABQRATORY SUPPLIES 200

3515 SAFETY EQUIPMENT 100

------------- ------------- ------------- -------------30 SUBTOTAL 207 24 600

Page 106:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 305290

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB0ECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER D&M-CARBON TREATMENT PLAN

TIME: 14:14PAGE: 792

SUBOBJECT

5553 FLOW METER

NOTES:

AUDITEDFY 12

WATER O&M CARBON

TREATMENT PLANT

REPLACE 1 FLOW METER

TO MAINTAIN UP TO

1,071

AUDITEDFY 13

1,208

ORIGINALBUDGETFY 14

2,200

DEPARTMENTREQUEST

FY 15

559B

DATE EQUIPMENT

OTHER EQUIPMENT

NOTES:

WATER O&M CARBON

TREATMENT PLANT

REPLACEMENT OF 2

CRITICAL PIECES OF

EQUIPMENT: (MULTI-YR

PROJECT) :

- 1 FOXBORO FLOW

TRANSMITTER

2,200

1,800

1.597 1,735 4,300

- 1 CHART RECORDER PART

OF MULTI-YR PROJECT TO

REPLACE ORIGINAL PLANT

Page 107:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

INSTRUMENTS

TOTAL

2.500

4,300

Page 108:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT ,30INDEX ,305290

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISIDN DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWATER O&M-CARBON TREATMENT PLAN

TIME: 14:14PAGE: 793

SUBOBJECT

50 SUBTOTAL

INDEX 305290 SUBTOTAL

AUDITEDFY 12

2.668

7.611

AUDITEDFY 13

2.943

9.217

DRIGINALBUDGETFY 14

6,500

14,390

DEPARTMENTREQUEST

FY 15

Page 109:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX :306101

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 SMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER ENGINEERING

TIME: 14:14PAGE: 794

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREOUEST

FY 15

1101

1202

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1501

1602

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

Be/aS-PREFERRED PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

OELTA OENTAL PLUS

OPEB

OVERTIME

SOCIAL SECURITY

405,165

46,523

491

2.600

14,659

582

44,672

600

915

2,570

33,451

30.009

406.506

39.804

135

3.012

23,651

582

32,601

600

987

2.570

50,924

30.537

466,149

46,615

3.075

25,224

840

54,771

600

1.036

4,063

200

35,646

10 SUBTOTAL 582,237 591,909 638.219

Page 110:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ;09/25/2013

FUND ;051DEPARTMENT:30INDEX :306101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER ENGINEERING

TIME: 14:14PAGE: 795

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

2101

2302

2402

2699

2706

OFFICE EQUIPMENT

TELEPHONE SERVICE

LEGAL NOTICE

OTHER PROFESSIONAL SERVICES

DATA PROCESSING SOFTWARE-MAINTENANCE

5,139

3,207

786

2,864

3,093

3,549

299

3,000

3,200

100

450

2,900

20 SUBTOTAL 11,996 6,941 9,650

3101 GENERAL OFFICE SUPPLIES 1,032 522 1,100

3103 PRINTING-COMMERCIAL 128 111 50

3104 DUPLICATING MACHINE SUPPLIES 99 250

3201 DELIVERY CHARGES 9 14

3202 GENERAL OFFICE MAILING 9 -3

3302 JANITORIAL SUPPLIES & EQUIPMENT 32

3506 SMALL TOOLS 3

3507 AUDIO VISUAL SUPPLI ES 63

Page 111:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INDEX :306101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER ENGINEERING

TIME: 14: 14PAGE: 796

AUDITEDSUBOBJECT FY 12

3512 DRAFTING & DISPLAY SUPPLIES 314

AUDITEDFY 13

54

ORIGINALBUDGETFY 14

400

DEPARTMENTREQUEST

FY 15

3515

3527

SAFETY EQUIPMENT

COMPUTER HAROWARE COMPONENTS

61

50

150

30 SUBTOTAL 1,591 907 1,950

4104

4202

4502

4601

4703

FUEL CHARGES

PARKING AND TOLLS

PROFESSIONAL BOOKS & PERIODICALS

MEMBERSHIP FEES & DUES

TRAINING SEMINARS, COURSES & MEETINGS

25

65

168

750

25

358

34

360

100

50

100

300

800

40 SUBTOTAL 1,008 777 1,350

Page 112:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :306101

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER ENGINEERING

TIME: 14: 14PAGE: 797

SUBOBuECTAUDITED

FY 12AUOITEO

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FY 15

5220 PERSONAL COMPUTER 495

50 SUBTOTAL

INDEX 306101 SUBTOTAL

495

597,327 600,534 651.169

Page 113:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX :306210

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M ABINGDON

TIME: 14:14PAGE: 798

SUBOBJECTAUDITED

FY 12AUOITED

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FV 15

1101

1103

1105

1201

1202

1204

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1355

1501

1602

1801

CURRENT AUTHORIZEO POSITIONS

TEMPORARY

UNIFORM ALLOWANCE

RETIREMENT (OLD)

PENSION (NEW)

TEMPORARY (NEW PLAN)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

Be/aS-PREFERRED PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

OELTA OENTAL PLUS

OPES

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

1,124,173

17,794

-174

4,423

125,769

746

31,223

44,850

46.544

2,767

134,707

3,450

7,659

4,970

88,747

24,659

91,B09

94,232

7,379

1,107,854

13,845

3,100

107,200

207

35,268

123,846

2,716

95,235

3,075

7,569

5,294

119,027

29,077

137,066

95,439

7,921

1,143,667

26,772

114,367

1,128

36,391

134,606

3,395

139,093

3,000

8,806

7,857

27,382

155,000

102,008

8,000

Page 114:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT; 317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :306210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M ABINGDON

TIME: 14:14PAGE: 799

SUBDBJECT

10 SUBTOTAL

AUDITEDFY 12

1,B55,121

AUDITEDFY 13

1,893,739

ORIGINALBUDGETFY 14

1,911,472

DEPARTMENTREDUEST

FY 15

Page 115:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051OEPARTMENT,30INOEX :306210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002OIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER a SEWER OPERATINGPUBLIC WORKSSEWER DaM ABINGDON

TIME: 14:14PAGE: 800

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2101

2102

2103

2106

2199

2201

2202

2302

2304

2305

2401

2402

2609

OFFICE EQUIPMENT

COMMUNICATION EQUIPMENT

VEHICLE & OPERATING EQUIPMENT

SPACE & REAL ESTATE RENTAL

OTHER RENTS & UTILITIES

ELECTRICITY

HEATING FUEL (GAS)

TELEPHONE SERVICE

ANSWERING SERVICE

EMERGENCY REPORTING SYSTEMS

PERSONNEL/RECRUITMENT

LEGAL NOTICE

CO FACILITY REPAIR a RENOVATION

9,329

30

141

12,9B5

4,174

8,570

3,719

13,381

55

19

131

8,527

429

30

138

12,657

5,221

9.253

5,178

13,240

5,050

11,000

12,500

200

150

15,500

7,000

10,000

4,100

15,000

100

50

6,000

Page 116:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306210

HARFDRD CDUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISIDN DETAILED SUMMARY BY SUBOBuECT

FISCAL YEAR 15 BMR WORKSHEET

WATER a SEWER OPERATINGPUBLIC WORKSSEWER DaM ABINGDON

TIME: 14:14PAGE: 801

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

2612

2614

2620

2621

2699

2701

ENGINEERING SERVICES

UTILITY LINE MAINTENANCE CONTRACT

WATER LINE REHAB/REPAIR

SEWER LINE REHAB/REPAIR

OTHER PROFESSIONAL SERVICES

NOTES:

ROOT CONTROL ON

SUBDIVISION RIGHT-

OF-WAYS,

GRUBBING/CLEARING

OF SEWER INTERCEPTOR

EASEMENTS, AND

CONTRACTED SEWER SERVICE

CALIBRATE/TEST OFF-SITE

SEWER FLOW METERS.

UNIFDRM RENTAL

1,597

5,603

69,426

62,897

6,430

6,090

83,744

94,084

6,250

30,000

90,000

90,000

7,000

Page 117:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDB~ECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M ABINGDON

TIME: 14:14PAGE: 802

SUBOBJECT

2703 COMMUNICATION SERVICE

2704 OPERATING EQUIPMENT

2708 BUILDING/CUSTODIAL SERVICES

2799 OTHER

20 SUBTOTAL

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

3,865 1,005 4,000

842 45 1,000

7,261 5,96B 8,000

11,854 425 14,500

------------- ------------- ------------- -------------222,309 257,334 326,100

3101 GENERAL OFFICE SUPPLIES 1,605 3,039 2,500

3103 PRINTING-COMMERCIAL 668 552 700

3104 DUPLICATING MACHINE SUPPLIES 1,590 635 1,800

3199 OTHER OFFICE SUPPLIES 43 75

3201 DELIVERY CHARGES 1,397 1,125 1,700

3202 GENERAL OFFICE MAILING 7 16 50

3301 PAPER SUPPLIES 910 1,252 1,100

3302 JANITORIAL SUPPLIES & EQUIPMENT 601 825 700

3401 MEALS-SPECIAL PURPOSE 887 1,087 2,000

Page 118:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :306210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER a SEWER OPERATINGPUBLIC WORKSSEWER O&M ABINGDON

TIME: 14: 14PAGE: 803

1,102 1,000

15.196 18,500

1,355 700

6,153 5,500

167 100

45 300

1,590 5,000

13,711 12.000

230 250

5,175 4,000

10,937 20,000

AUDITEDSUBOBJECT FY 12

3402 ICE AND BOTTLED WATER 105

3499 OTHER FOOD SUPPLIES lB2

3501 UNIFORMS-PURCHASE 830

3504 EQUIPMENT REPAIR PARTS 15,471

3505 LANDSCAPE & GROUNDS MATERIAL 960

3506 SMALL TOOLS 4,659

3507 AUDIO VISUAL SUPPLIES 74

3510 BUILDING SUPPLIES 399

3513 CHEMICALS IN BULK 5,458

3515 SAFETY EQUIPMENT 10,585

3516 MEDICAL SUPPLIES 270

3519 was LINES SERVICE PARTS 3,120

3522 CRUSHED AGGREGATE 13,514

AUDITEDFY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

Page 119:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :306210

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M ABINGDON

TIME: 14:14PAGE: 804

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

3523

3525

3526

3527

3528

BITUMINOUS CONCRETE

CONCRETE. MORTAR & CEMENT

COMPUTER SOFTWARE

COMPUTER HARDWARE COMPONENTS

COMPUTER SUPPLIES

2,086

3,293

239

1,250

4,290

3,000

4,000

400

500

300

3530

3531

3533

3534

3550

3551

3552

TRAFFIC SIGNS AND MARKINGS

PAINT

GASOLINE

OIL & LUBRICANTS

BRICKS, BLOCKS, PRECAST CONCRETE PRODUCT

PIPES, CULVERTS, & FITTINGS

GRATES. MANHOLE COVER-OTHER APPURTENANCE

NOTES:

REPLACEMENT OF ONE

1,888 479

2,99B 539

2,133 2.116

201 270

952 277

5,997 2,968

3.151 1,961

2,000

3,000

3,000

200

1,000

6,000

25,000

Page 120:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

MANHOLE' $4,000.

REPLACEMENT OF MH

COVERS ARE $2oo/EA.

UNLESS WATERTIGHT

$250/EA.

Page 121:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER OaM ABINGDON

TIME: 14:14PAGE: 805

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

3595

3599

UNANTICIPATED MAINTENANCE

OTHER SUPPLIES a MATERIALS 115 160

50,000

100

30 SUBTOTAL 86,388 78,502 176,475

4101 COUNTY OWNED VEHICLES 58,574 48,205 60,000

4104 FUEL CHARGES 66,955 65,937 70,000

4108 NON-TARGETED CHARGES-FVS 19,903 22,783 26,000

4202 PARKING AND TOLLS 34 30 50

4502 PROFESSIONAL BOOKS & PERIODICALS 423 169 500

4601 MEMBERSHIP FEES & DUES 242 324 400

4703 TRAINING SEMINARS, COURSES & MEETINGS 7,313 2,818 7,000

------------- ------------- ------------- -------------40 SUBTOTAL 153,444 140,266 163,950

Page 122:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306210

HARFORO COUNTY, MO - 5YSTEMWIOE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB0ECT

FISCAL YEAR 15 BMR WORKSHEET

WATER a 5EWER OPERATINGPUBLIC WORKS5EWER oaM ABINGOON

TIME: 14:14PAGE: 806

SUBOBJECT

5222

5302

PRINTER

CHAIRS

AUDITEDFY 12

AUDITEDFY 13

116

625

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

5306 TABLES

5504 SAWS-ALL TYPES

5508 GENERATORS

5511 PUMPS

5523 HYORAULIC POWER TOOLS

5536 LEAK DETECTION EQUIPMENT

5540 SHORING BOX

5598 OTHER EQUIPMENT

5601 RADIO-MOBILE

5602 RADIO-PORTABLE

2.145

2.500

995

70

62

116

5,200

4B4

85,665

1.500

1,500

1,500

2,500

900

3.000

Page 123:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306210

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSSEWER o&M ABINGDON

TIME: 14:14PAGE: 807

SUBoBJECT

50 SUBTOTAL

AUDITEDFY 12

5,772

AUDITEDFY 13

92.206

ORIGINALBUDGETFY 14

10,900

DEPARTMENTREQUEST

FY 15

Page 124:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX :306210

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M ABINGOON

TIME: 14: 14PAGE: 808

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREOUEST

FY 15

7102 PAYMENTS TO OTHER GOVT AGENCIES 4,000

70 SUBTOTAL

INOEX 306210 SUBTOTAL 2,323,640

4,000

2,466,047 2.588.897

Page 125:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

TIME: 14: 14PAGE: 809

1307 MPDS

1350 OPEB

1602 SOCIAL SECURITY

1801 SHIFT DIFFERENTIAL

STATIONS

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REOUEST

FY 12 FY 13 FY 14 FY 15

734,211 696.401 705,130

83,975 68.147 70,513

147 190

21,480 24,764 23,998

43,394 71,012 86.525

17.103

1,374 1,346 1,652

103.487 85,682 95,965

420 420

3,170 3,309 3,937

6,215 6,285 7,414

60,965 84,005

3,138 6,039 6,161

66,539 84,411 80,000

60,721 58,232 60,006

1,016 871 800

------------- ------------- ------------- -------------1,207.355 1,191,114 1,142,101

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M PUMP/METER

1308 LIFE

1304 BLUECHOICE-FORMERLY FREESTATE

1101 CURRENT AUTHORIZED POSITIONS

1300 FLEX CREDITS

1301 WORKER'S COMPENSATION

10 SUBTOTAL

1321 DELTA DENTAL PLUS

1202 PENSION (NEW)

1319 BENEFITS-SUPPLEMENTAL

1320 DELTA DENTAL PPO

1355 PEHP (POST EMPLOYMENT HEALTH PLAN)

1501 OVERTIME

1309 BC/BS-PREFERRED PROVIDER

FUND :051DEPARTMENT:30INDEX :306220

SUBOBJECT

Page 126:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORL 317OATE ,09/25/2013

FUNO ,051DEPARTMENT:30INDEX :306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 8MR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 810

SU808JECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2103

2201

2202

2302

2305

2609

VEHICLE & OPERATING EQUIPMENT

ELECTRICITY

HEATING FUEL (GAS)

TELEPHONE SERVICE

EMERGENCY REPORTING SYSTEMS

CO FACILITY REPAIR & RENOVATION

NOTES:

SEWER O&M PUMP/METER STATION

- REGULAR PUMP/MOTOR

REPAIRS TO 57 STATIONS

AS NEEDED. PUMP REBUILDS

AT TOLLGATE, COUNTRY WALK,

SINGERWDS, BILL BASS,

AND HOME GRINDER SEWERS.

ROOF REPAIRS-BILL BASS

AND EAST BAKER AVE.

FENCE MODIFICATION FOR

BETTER ACCESS TO

8.903

389,404

122

19,620

121

234,508

6,932

433,340

853

29,752

140

259,545

1,500

550.000

800

20.000

120

202,000

Page 127:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

CHURCH CREEK. 150,000

-PAINT OF STRUCTURES

AND EQUIPMENT. PLUMTREE

SPS PRIORITY FOR FY14.

18.000

PAVING AND STONE DRIVE­

WAY UPGRADES FOR SAFETY,

PROTECT VEHICLES AND

EQUIPMENT. PARTIAL

REPAIRS TO EXISTING

PAVEMENT. PLUMTREE

ESTATES OUTSIDE FENCE

AND ADD GUARDRAIL ALONG

CURVE. OTHERS REPAIRS

AT RIVERSIDE SOUTH,

WASHINGTON AVE, ROUTE 40,

40, EVERGREEN HEIGHTS

8,000

HOIST, GENERATOR,

AND EQUIPMENT REPAIRS

AS FOUND IN ANNUAL

INSPECTIONS AND

PLANNED ANNUAL

SERVICE 26,000

Page 128:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INOEX :306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14: 14PAGE: B 11

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2612 ENGINEERING SERVICES

NOTES:

SEWER O&M PUMP/METER STATION

-ENGINEERING OESIGN

OF UPGRADES TO THE

PLUMTREE SPS. WILL

RELOCATE FLOWMETER

ANO DESIGN A PUMP

BYPASS SYSTEM TO

BYPASS THE STATION

IN EMERGENCY

$ 10,000

-ENGINEERING DESIGN

TO UPGRADE THE

ACCESS POINTS FOR

CLEANING THE WETWELL

CURRENTLY ONE HATCH

FOR BOTH CREWS AND

VAC TRUCK HOSES

AND EQUIPMENT

THIS IS A MAJOR

SAFETY ISSUE.

JOPPA FARM SPS

1.125 15.000

Page 129:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

$ 5.000

Page 130:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051DEPARTMENT ,30INDEX ,306220

HARFORO COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WDRKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME,14,14PAGE, 812

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFV 14

DEPARTMENTREQUEST

FY 15

2699 DTHER PRDFESSIDNAL SERVICES

NOTES:

SEWER D&M PUMP/METER STATIDNS

- BI-ANNUAL PUMPDUT DF

OF HOME BASED SEWER

25,489 57,281 58,000

SYSTEMS 16,000

- EMERGENCY PUMPDUTS AT

STATIONS AND HOME

SYSTEMS

-ARC FLASH STUDY NEW

REQUIREMENT BY OSHA

TO EVALUATE ADEQUACY

10,000

OF ELECTRICAL SYSTEMS

AVERAGE SITE CQSTS

2701

2703

3500-5500

UNIFORM RENTAL

COMMUNICATION SERVICE

32,000

4,069

1,250

3,882

1,250

3,900

1,250

Page 131:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT: 30INDEX :306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL VEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 813

SUBOBJECTAUDITED

FV 12AUDITED

FV 13

ORIGINALBUOGETFV 14

DEPARTMENTREQUEST

FV 15

2704

2707

270B

2803

OPERATING EQUIPMENT

NOTES:

ANNUAL PREVENTIVE

MAINTENANCE CONTRACTS

FOR METER CALIBRATION,

GENERATORS, HOIST, WELLS,

FIRE EXTINGUISHERS,

POWER/Mee, BACKFLOWS,

STORAGE TANKS, GRIT/SCUM,

BOILERS, CL2/S02, ANO

UST /ASV

GROUNDS MAINTENANCE

BUILDING/CUSTODIAL SERVICES

UTILITY WATER & SEWER PURCHASE

NOTES:

WATER FOR GLEN EAGLES $PS

PURCHASED FROM MO AMERICAN

WATER COMPANY

28,625

12,749

467

28, 154

13,199

400

590

34,840

16,000

500

Page 132:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX : 306220

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M PUMP/METER STATIONS

TIME: 14:14PAGE: 814

SUBOBIJECT

20 SUBTOTAL

AUDITEDFY 12

727,052

AUDITEDFY 13

835,318

ORIGINALBUDGETFY 14

909,910

DEPARTMENTREOUEST

FY 15

Page 133:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051DEPARTMENT:30INDEX :306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 815

SUBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3101

3103

3201

3202

3299

3301

3302

3401

3504

3505

3506

3510

GENERAL OFFICE SUPPLIES

PRINTING-COMMERCIAL

DELIVERY CHARGES

GENERAL OFFICE MAILING

OTHER POSTAGE EXPENSE

PAPER SUPPLIES

JANITORIAL SUPPLIES & EOUIPMENT

MEALS-SPECIAL PURPOSE

EQUIPMENT REPAIR PARTS

LANOSCAPE & GROUNDS MATERIAL

SMALL TOOLS

BUILDING SUPPLIES

3,195

25

3,342

126

311

471

1,007

67,942

3,200

673

725

30

2,045

125

26

107

59

706

55,879

507

1,683

620

2,000

100

3.000

150

200

400

1,100

BO,ooo

3.500

700

Page 134:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051OEPARTMENT:30INDEX ,306220

HARFORD COUNTY, MD - SVSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14: 14PAGE: 816

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFV 14

DEPARTMENTREQUEST

FY 15

3513 CHEMICALS IN BULK 7,356 10,000

3514 LABORATORY SUPPLIES

3515 SAFETY EQUIPMENT

3522 CRUSHED AGGREGATE

3527 COMPUTER HARDWARE COMPONENTS

3528 COMPUTER SUPPLIES

3530 TRAFFIC SIGNS AND MARKINGS

3531 PAINT

3532 DIESEL FUEL

3534 OIL & LUBRICANTS

3541 NATURAL GAS

3599 OTHER SUPPLIES & MATERIALS

406

13,588

209

189

7,456

71

1,229

16

210

12,568

827

22,223

985

1,051

10,000

200

150

100

4,000

1,000

500

100

Page 135:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INDEX :306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY $UBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14: 14PAGE: 817

SUBOBJECT

30 SUBTOTAL

AUDITEDFY 12

110,812

AUDITEDFY 13

100,376

ORIGINALBUDGETFY 14

117,200

DEPARTMENTREOUE5T

FY 15

Page 136:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INOEX : 306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 818

SUBOBJECTAUDITED

FY 12AUOITEO

FY 13

ORIGINALBUDGETFY 14

OEPARTMENTREQUEST

FY 15

4101

4104

4108

4202

4502

4601

4703

COUNTY OWNED VEHICLES

FUEL CHARGES

NON-TARGETED CHARGES-FVS

PARKING AND TOLLS

PROFESSIONAL BOOKS & PERIODICALS

MEMBERSHIP FEES & OUES

TRAINING SEMINARS, COURSES & MEETINGS

19,791

67,079

8,904

B3

37S

1,016

17.675

58. 177

4,533

21S

755

3,747

21,000

70.000

9,000

B5

50

400

2,000

40 SUBTOTAL 97,248 85,102 102,535

Page 137:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX ; 306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 819

SUBOBJECTAUOITEO

FY 12AUDITED

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREOUEST

FY 15

5142 W&S-PLANT IMPROVEMENTS

NOTES:

SEWER O&M PUMP/METER STATION

-CONTINUE ON-GOING

PROGRAM TO PROTECT

STATIONS FROM POWER

29,602 71 ,711 105,500

SURGES/SPIKES $5,000

-CONTINUE YRLY PROGRAM

REPLACING FLOAT/BUBBLER

SYSTEMS WITH MODERN

SUBMERSIBLE TRANSOUCERS

FOR ACCURATE, RELIABLE

LEVEL READINGS $35,500

-IMPROVEMENTS TO PUMP

#2 AT BILL BASS SPS.

PUMP#2 IS PRESENTLY

A CONSTANT SPEED PUMP

THAT CAN ONLY BE USED

A BACK-UP TO THE OTHER

TWO. PROJECT WILL

MOOIFY THIS TO A

MAGNA-DRIVE UNIT FOR

VARIABLE PUMP SPEEDS

Page 138:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

ALLOWING ROTATION

ACROSS ALL THREE PUMPS

AND REDUCING WEAR AND

TEAR. $65,000

Page 139:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 820

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

5290

5315

ELECTRONIC PROCESS CONTROL EQUIP-W&S

ELECTRIC HEATERS

NOTES:

SEWER O&M PUMP/METER STATION

ELECTRIC HEATERS

PURCHASED TO PROTECT

EQUIPMENT AND PIPES

IN STATIONS DURING

COLD WEATHER( 2 PER

597

1.497 2,500

5501

YR)

AIR COMPRESSOR

NOTES:

$2,500

2,359 6,000

SEWER O&M PUMP/METER STATION

REPLACE COMPRESSORS AT

AVERAGE OF 3 STATIONS

PER YEAR. UNITS USED TO

OPERATE PROCESS CONTROL

EQUIPMENT. PORTABLE

UNIT CAN BE USED TO

Page 140:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

RUN TOOLS AND PROCESS

EQUIPMENT AS BACK-UP.

$6,000

Page 141:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051OEPARTMENT:30INDEX : 306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M PUMP/METER STATIONS

TIME: 14:14PAGE: 821

SUBOBJECT

5503

5508

BLOWERS

NOTES:

GENERATORS

NOTES:

AUDITEDFY 12

11,070

SEWER O&M PUMP/METER STATION

CONTINUE ON-GOING PROGRAM

TO REPLACE 1-2 WETWELL

BLOWERS PER YEAR.

BLOWERS FOR ODOR

CONTROL AND SAFE

VENTILATION OF

STATIONS

SEWER O&M PUMP/METER STATION

WE HAVE 55+ BACK-UP

EMERGENCY GENERATORS

IN THE SYSTEM. SOME

FAILING AND BECOMING

COSTLY TO MAINTAIN.

SOME 20+ YRS OLD WITH

UNAVAILABLE PARTS.

AUDITEDFY 13

15.944

31.712

ORIGINALBUOGETFY 14

7,000

33,500

DEPARTMENTREOUEST

FY 15

Page 142:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

FUNDS WILL PROVIDE

ANNUAL BUDGETS TO

KEEP STATIONS GENERATORS

UP-TO-DATE. NEXT

PROJECT WILL BE PERRY

AVE SPS. 30,000

PORTABLE GENERATOR/WELDER

FOR UTILITY TRUCK SO

IN-HOUSE MECHANICS CAN

DO FIELD REPAIRS

WITHOUT CALLING IN

A CONTRACTOR 3,500

Page 143:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

TIME: 14: 14PAGE: 822

STATIONS

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

41,562 77,078 55,000

3,460

2,076 3,050

6,272 5,204 24,000

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M PUMP/METER

SUBOBJECT

FUND :051DEPARTMENT ,30INDEX ,306220

5511 PUMPS

5533 TESTING GAUGE

5553 FLOW METER

5598 OTHER EQUIPMENT

NOTES:

-CONTINUE ANNUAL

PROGRAM TO INSTALL

UPDATED AUTOMATIC

TRANSFER SWITCHES (2

PER YEAR).

-OSHA LAW REQUIRES

CONFINED SPACE GAS

METERS TO MONITOR

AIR QUALITY WHEN

CREWS ENTER CONFINED

SPACES.

5608 TOWER, ANTENNA, ETC 12,612 9,922 16,000

NOTES:

Page 144:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPLACE AND UPGRADE SCAD A

SYSTEM ANTENNAS, RADIOS.

CABLES AND RTU PANELS

CRITICAL FOR 24/7 DATA

TRANSMISSION. PART OF ON­

GOING MAINTENANCE OF

SCADA SYSTEM. MULTI-YR

UPGRADE PROJECT.

$16,000

Page 145:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT: 30INDEX ,306220

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14:14PAGE: 823

SUBOBJECT

50 SUBTOTAL

AUDITEDFY 12

109,610

AUDITEDFY 13

216,118

ORIGINALBUDGETFY 14

249.500

DEPARTMENTREQUEST

FY 15

Page 146:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051OEPARTMENT:30INDEX : 306220

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M PUMP/METER STATIONS

TIME: 14: 14PAGE: 824

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

8233 FLEET DAILY CARPOOL RENTALS 262 734

80 SUBTOTAL

INDEX 306220 SUBTOTAL

262

2.252.339

734

2,428,762 2,521,246

Page 147:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051DEPARTMENT:30INDEX : 306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SOD RUN

TIME: 14:14PAGE, 825

SUBDBvECT

10 SUBTOTAL

1101

1202

1300

1301

1304

1307

1308

1309

1319

1320

1321

1350

1355

1501

1602

1801

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

MPOS

LIFE

BC/BS-PREFERRED PROVIDER

BENEFITS-SUPPLEMENTAL

DELTA DENTAL PPO

DELTA DENTAL PLUS

OPES

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

1,941,372 1,974,958 2,090,226

222,061 193,143 209,023

1 , 117 1, 154

58, 189 64,788 65,487

75,368 234,690 248,935

100,507

4,294 4,265 5,516

236,621 119,051 213,716

4,560 4,860 4,200

7,711 6,957 7,339

15,841 15,673 22,346

142,421 181,357

61,873 51,455 52,482

269,799 242,650 220,000

167,627 167,708 178,909

31,469 21,465 30,000

------------- ------------- ------------- -------------3,340,830 3,284, 174 3,348,179

Page 148:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT,317OATE ,09/25/2013

FUND :051DEPARTMENT,30INDEX :306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME, 14,14PAGE: 826

SUBOBJECT

2101 OFFICE EQUIPMENT

2103 VEHICLE & OPERATING EQUIPMENT

2201 ELECTRICITY

NOTES:

SEWER O&M SOD RUN

ELECTRICITY TO POWER

PLANT WITH EXPANDED ENR

TREATMENT AND OUALIFY­

ING FOR MAXIMUM CREDITS

FROM PEAK LOADS

CREDIT PROGRAM

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

5,616 5,773 5,600

2,525 896 2,000

987,208 966,437 1,200,000

2204

2302

2305

HEATING FUEL(DIL)

TELEPHONE SERVICE

EMERGENCY REPORTING SYSTEMS

14,418

21,965

140

22,418

25,349

140

35,000

28,000

150

Page 149:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT, 30INDEX ,306230

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 827

AUDITED AUDITEDSUBOBJECT FY 12 FY 13

2306 FAX SERVICES 6,915 320

ORIGINALBUDGETFY 14

280

DEPARTMENTREOUEST

FY 15

2402 LEGAL NOTICE

NOTES:

ADVERTISING BY MOE ON

PERMIT MATTERS AND

NPDES PERMIT NOTICES

150

2609 CO FACILITY REPAIR & RENOVATION

NOTES,

SEWER O&M SOD RUN

-REBUILD 1 INFLUENT

BAR SCREEN, 17 YEARS OF

SERVICE, FAILURE WILL

CAUSE PERMIT VIOLATION

70,000

-ALGAE SWEEP REPAIR ON

2 OF 8 SECONDARY CLARIFIERS,

FAILURE WILL CAUSE

PROBLEMS WITH DENITRIFI-

CATION, PHASE 2 OF 4

568,154 505,119 944,500

Page 150:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

20,000

-REPAIR KSB MIXERS AND IR

PUMPS, ESSENTIAL PART OF

TREATMENT BASINS, 80 +

UNITS MUST BE IN SER-

VICE TO RUN ENR

PROCESSES 70.000

-POST AERATION WIRING

REPLACEMENTS (PH 1 OF

2) IDENTIFIED AS HIGH

PRIORITY FOR FAILURE IN

SR FACILITY PLAN 38,000

-LABDR CDSTS TD INSTALL

PUMPS PURCHASED AS CAPI-

TAL ITEMS 45.000

-REBUILD RAW SEWAGE

PUMP #S CRITICAL TO PRE­

VENT OVERFLOW. PH 3 OF 5

32,000

-REBUILD 1 SMALL DIGES­

TER MIXING PUMP (MRSL)

PH 3 DF 3 12,000

-REPLACE VFO FOR RAW

SEWAGE PUMP #1 WITH

MAGNA DRIVE. PH 2 OF 2.

100,000

-REPL CONTROL PANEL FOR

BELT FILTER PRESS #3,

MDVE TO SAFER PLACE TD

PREVENT FUTURE DAMAGE

1S,OOO

- REBUILD 1 GRAVITY BELT

THICKENER W!HYDRAULIC

Page 151:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

POWER PACK. CRITICAL TO

THICKENING WASTE ACTI-

VATED SLUDGE 35,000

-REBUILD 1 OF 8 POST­

AERATORS NEEDED TO IN­

SURE SUFFICIENT 02 IN

EFFLUENT TO MEET PERMIT

REQUIREMENTS 30.000

-PAINTING THROUGHOUT YR

INCLUDING BAR SCREEN, EX­

TERIOR DOORS. HARSH

ENVIRONMENT 50,000

- REPL AREA LIGHTING wi

MORE EFFECIENT LED UNITS,

PAINT POLES. COVERS 6 OF

16 LIGHTS 22,500

- REFURB 4 OF 8 GRIT

PANS USED TO HAUL SCREEN­

INGS TO LANDFILL. PH 2

OF 2 7,000

- PC DISTRIBUTION GATE

BOX REPLACEMENT. HIGH

RISK 108,000

-UNDERGROUND ELEC FEEDER

CABLE REPAIRS, PH OF 3

65.000

-REBUILD GRINDER BODY

ON 1ST OF 4 PRIMARY

SLUDGE PUMPS 10.000

-REBUILD WHESSO-VAREK

WASTE GAS FLARES THAT

BURN OFF EXCESS METHANE

Page 152:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

GAS PRODUCED IN

ANAEROBIO DIGESTION 25,000

-PURCHASE & INSTALL

SHREDDER OEWATER

PUMPS 1 & 2, HOMOGENIZES

TRASH AND PLASTICS

TO KEEP THEM OUT OF

LAND APPLICATION 35,000

- OTHER REPAIRS AS

NEEDED 155,000

Page 153:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306230

HARFDRD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: B28

5UBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2612 ENGINEERING SERVICES

NOTES:

-5TH YR OF ENGINEERING

CONSULTANT AND SERVICE

CONTRACTS FOR ELECTRONIC

PROCESS CONTROL AND

SCADA SYSTEMS. SERVICE

(INCLUDING EMERGENGY

RESPDNSE) AND TECHNICAL

INPUT FOR PLANNING SYSTEM

28,271 12,658 100,000

REPAIRS, UPGRADES,

ENHANCEMENTS

-STUDY FOR GAS TO

50,000

2699

ENERGY DPTIMIZATION.

ENHANCE PRODUCTIVITY

OF METHANE GENERATORS.

50,000

OTHER PROFESSIONAL SERVICES

NOTES:

SEWER D&M SOD RUN

730,407 765,165 1,031,000

Page 154:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

- BIOSOLIOS

COST FOR HANLOING

SOLIDS. LAGOON PUMP OUT ,

LAND APPLICATION,

LANDFILL

(AS NEEDED) 1,000000

- SCALE FEE FOR

WEIGHING TRUCKS 11,000

- CONTRACTED LAB

SERVICES TD TEST

FOR NPDES COMPLIANCE

AND TREATMENT

PROCESS MONITORING 20,000

Page 155:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306230

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER DaM SOD RUN

TIME: 14:14PAGE: 829

SUBOBJECT

2701

2703

2704

2707

2708

2899

UNIFORM RENTAL

COMMUNICATION SERVICE

OPERATING EQUIPMENT

GROUNDS MAINTENANCE

BUILOING/CUSTOOIAL SERVICES

OTHER

NOTES:

TIPPING FEE FOR GRIT

DISPOSAL AT He LANDFILL

UNDER AUTHORIZED RATE

AUOITEOFY 12

6,854

1,992

74,628

8,280

13,255

27.731

AUDITEDFY 13

6,545

1,902

66,466

B,2BO

13,730

18,556

ORIGINALBUDGETFY 14

7,000

2,000

78,770

8,280

14,000

29,000

DEPARTMENTREOUEST

FY 15

20 SUBTOTAL 2,498,359 2,419,754 3,485,730

Page 156:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INOEX :306230

HARFORD COUNTY, MD - SYSTEMWIOE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SOO RUN

TIME: 14:14PAGE: 830

SUBOBJECT

3101 GENERAL OFFICE SUPPLIES

3103 PRINTING-COMMERCIAL

3199 OTHER OFFICE SUPPLIES

NOTES:

TAPES AND PERMANENT MARKING

MATERIAL FOR PIPES AND

EQUIPMENT AND OTHER

SPECIALITY ITEMS

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REOUEST

FY 12 FY 13 FY 14 FY 15

9,507 5. 151 7,000

542 176 400

994 121 700

3201

3202

3299

DELIVERY CHARGES

GENERAL OFFICE MAILING

OTHER POSTAGE EXPENSE

NOTES:

PO BOX RENTAL IN PERRYMAN

12,501

369

110

B,457

B06

104

11,000

350

110

Page 157:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT,317DATE ,09/25/2013

FUND :051DEPARTMENT ,30INDEX :306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 831

SUBOBJECT

3301 PAPER SUPPLIES

AUDITEDFY 12

4,00B

AUDITEDFY 13

4,449

ORIGINALBUDGETFY 14

4,000

DEPARTMENTREQUEST

FY 15

3302

3401

3402

3499

3504

JANITORIAL SUPPLIES & EOUIPMENT

MEALS-SPECIAL PURPOSE

ICE AND BOTTLED WATER

NOTES:

BOTTLED DRINKING WATER FOR

DRINKING, BOTTLED DISTILLED

WATER FOR LAB, AND ICE FOR

PRESERVING LAB SAMPLES

DURING TRANSPORT. PLANT

DOES NOT HAVE POTABLE

WELL

OTHER FOOD SUPPLIES

EQUIPMENT REPAIR PARTS

NOTES:

SEWER O&M 500 RUN

6.096

872

910

32

257,B11

8,704

920

1.010

224.317

6,000

900

2.000

237,000

Page 158:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

PARTS TO REBUILD

A GRINDER BODY

ON 1 OF 4 SLUDGE

PUMPS, YEAR

2 OF 4 12.000

Page 159:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET.

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 832

SUBOBJECTAUOITEO

FY 12AUOITEO

FY 13

ORIGINALBUOGETFY 14

DEPARTMENTREQUEST

FY 15

3505

3506

3510

3513

3514

LANDSCAPE & GROUNDS MATERIAL

SMALL TOOLS

NOTES:

STANDARD AND

SPECIALIZED TOOLS

FOR UNIT OF SKILLED

MECHANICS TO MAINTAIN

3 TREATMENT PLANTS

BUILDING SUPPLIES

CHEMICALS IN BULK

LABORATORY SUPPLIES

NOTES:

REAGENTS AND OTHER LAB

SUPPLIES USED IN SR LAB

FOR TREATMENT PROCESS

ANALYSIS AND NPDES

COMPLIANCE MONITORING

1,964

16,171

11.781

402,933

50,973

459

19,59B

14.188

404,377

62,442

1,500

10,000

10,000

715,000

55,000

Page 160:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

INCREASED AMOUNT OF

ANALYSIS WITH ENR

Page 161:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WDRKSHEET

WATER & SEWER OPERATINGPUBLIC WDRKSSEWER D&M SDD RUN

TIME: 14:14PAGE: 833

SUBDBJECT

3515

3516

3521

3522

3526

3527

SAFETV EQUIPMENT

MEDICAL SUPPLIES

SAND, SALT & DTHER BULK DE-ICERS

CRUSHED AGGREGATE

NOTES:

TO MAINTAIN PARKING AREAS

AND DRIVES ARDUND PLANT

DURING CONTRACTOR WORK ON

ENR UPGRAOE

COMPUTER SOFTWARE

COMPUTER HARDWARE COMPONENTS

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

31,332 42,416 25,000

593 162 500

1,237 387 1,200

761 264 1,000

54

2,314

3528

3530

COMPUTER SUPPLIES

TRAFFIC SIGNS AND MARKINGS

18

189

506 200

100

Page 162:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317OATE :09/25/2013

FUNO :051DEPARTMENT: 30INDEX :306230

HARFORO COUNTY, MO - SYSTEMWIOE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 834

AUDITED AUDITEDSUBOBJECT FY 12 FY 13

3531 PAINT 1,206 757

ORIGINALBUDGETFY 14

500

DEPARTMENTREQUEST

FY 15

3532

3534

3541

DIESEL FUEL

NOTES:

DIESEL FUEL FOR PLANT

EQUIPMENT AND GENERATORS

AND FOR PORTABLE TANKS

ON TRUCK USED TO FUEL

GENERATORS IN THE FIELO

OIL & LUBRICANTS

NATURAL GAS

NOTES:

LP GAS FOR FORKLIFTS,

AND PILOTS ON

HEAT EXCHANGERS, AND

FOR 2 LP-POWERED

GENERATORS

8,262

4,655

1,860

7,802

4,156

2,838

10,000

4,500

2,000

Page 163:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX :306230

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SOD RUN

TIME: 14:14PAGE: B35

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3560

3595

3599

COMPUTER-NETWORKS

UNANTICIPATED MAINTENANCE

NOTES:

TO COVER UNANTICIPATED

EMERGENCIES IN

WASTEWATER OPERATIONS

OTHER SUPPLIES & MATERIALS 216

28

655

50,000

300

30 SUBTOTAL 827,903 817,618 1,156,260

4101

4104

4108

4202

COUNTY OWNED VEHICLES

FUEL CHARGES

NON-TARGETED CHARGES-FVS

PARKING AND TOLLS

55,320

32,359

50,931

513

65,102

35,OB7

65,970

205

55,000

32,000

45,000

100

Page 164:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 836

AUDITEDSUBOBJECT FY 12

4502 PROFESSIONAL BOOKS & PERIODICALS 929

AUDITEDFY 13

790

ORIGINALBUDGETFY 14

500

DEPARTMENTREQUEST

FY 15

4601

4702

4703

MEMBERSHIP FEES & DUES

NOTES:

was OPERATIONS POLICY

LIMITS MEMBERSHIP TO

1 PER WORK UNIT

IN-HOUSE TRAINING

TRAINING SEMINARS. COURSES & MEETINGS

NOTES:

STAFF DEVELOPMENT PLAN

PROVIDES CLASSES MANDA­

TORY FOR COMPLIANCE

WITH MOE LICENSE

REQUIREMENTS

3,707

346

1,907

1,001

4,368

2,500

7,000

Page 165:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306230

HARFORD COUNTY. MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER o&M SOD RUN

TIME: 14:14PAGE: 837

5UBOBJECT

40 SUBTOTAL

AUDITEDFY 12

146,012

AUDITEDFY 13

172,523

ORIGINALBUDGETFY 14

142,100

DEPARTMENTREQUEST

FY 15

Page 166:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER DaM SOD RUN

TIME: 14:14PAGE: 838

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

5142

5210

5222

5229

5290

5302

5304

5306

5307

5315

5399

5499

5501

waS-PLANT IMPROVEMENTS

AUDIO VISUAL SUPPLIES

PRINTER

VACUUM CLEANER

ELECTRONIC PROCESS CONTROL EQUIP-Was

CHAIRS

SHELVING

TABLES

LOCKERS

ELECTRIC HEATERS

OTHER FURNITURE & FIXTURES

OTHER

AIR COMPRESSOR

200

665

261

-68

559

9,275

1,550

260

2,963

2,030

12,614

26,805

2,164

882

158

857

335

2,972

3,370

28,000

Page 167:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SOD RUN

TIME: 14:14PAGE: 839

SUBOBJECT

5503

5511

5513

BLOWERS

NOTES:

PUMPS

NOTES:

SWEEPERS

-PURCHASE BLOWER

AND THREE WAY MOTOR-

OPERATED VALVE FOR

ONE OF TWO GRIT

CHAMBERS. TO REMOVE

DEBRIS AND INORGANICS.

PHASE 1 OF 2.

REPLACE/UPGRADE

PUMPS IN 57 STATIONS

AND OVER 300 HOME

SEWER SYSTEMS

AUDITEDFY 12

4,485

AUDITEOFY 13

39

108,973

22,000

ORIGINALBUDGETFY 14

35,000

108,000

DEPARTMENTREQUEST

FY 15

Page 168:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBDBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 840

SUBOBJECT

5553

5556

FLOW METER

LABORATORY EQUIPMENT

NOTES:

-LAB EQUIPMENT:

-DR3900 REPLACE

SPECTROPHOTOMETER

MODEL NO LONGER

SERVICED BY VENDOR

-REPLACE FIA FLOW

INJECTION VALVES AT

END OF FUNCTIONAL

LIFE

-REPLACE PARISTALTIC

PUMP FOR FIA FLOW

AT END OF FUNCTIONAL

LIFE

TOTAL

4,200

6,000

9.000

19,200

AUDITEDFY 12

13,209

25,510

AUDITEDFY 13

12,877

21,949

ORIGINALBUDGETFY 14

19.200

DEPARTMENTREQUEST

FY 15

Page 169:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT: 30INDEX ,306230

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SOD RUN

TIME: 14:14PAGE: 841

SUBDBJECT

5598

5602

5613

OTHER EOUIPMENT

NOTES:

-PURCHASE FOUR KSB

PROCESS MIXERS.

-DIRECT DRIVE UNITS-

MORE EFFICIENT WITH

LOWER REPAIR COSTS.

OLD MIXERS HAVE 15

PLUS YRS SERVICE TIME

-2ND YEAR REPLACING

CERAMIC DIFFUSERS IN

BNR BASINS WITH LESS

EXPENSIVE LOW PRESSURE

MEMBRANES WITH

MEMBRANE PLATE DOMES

RADIO-PORTABLE

REPEATER-MOBILE

AUDITEDFY 12

77,060

3,832

AUDITEDFY 13

64,389

3,243

2,320

ORIGINALBUDGETFY 14

95,000

DEPARTMENTREQUEST

FY 15

50 SUBTOTAL 181,210 246,528 285,200

Page 170:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT: 30INDEX :306230

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER D&M SOD RUN

TIME: 14:14PAGE: 842

SUBOBJECT

7102 PAYMENTS TO OTHER GOVT AGENCIES

70 SUBTOTAL

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

24,787 18,968 25,000

------------- ------------- ------------- -------------24,787 18,968 25,000

8233 FLEET DAILY CARPOOL RENTALS 289 4,132

80 SUBTOTAL

INDEX 306230 SUBTOTAL

2B9

7,019,390

4,132

6.963,697 8,442.469

Page 171:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND ,051DEPARTMENT:30INDEX : 306240

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SPRING MEADOWS

TIME: 14:14PAGE: 843

SUBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

1101

1202

1300

1301

1304

1308

1309

1320

1321

1350

1355

1501

1602

1801

CURRENT AUTHORIZED POSITIONS

PENSION (NEW)

FLEX CREDITS

WORKER'S COMPENSATION

BLUECHOICE-FORMERLY FREESTATE

LIFE

BC/BS-PREFERRED PROVIDER

DELTA DENTAL PPD

DELTA DENTAL PLUS

DPEB

PEHP (POST EMPLOYMENT HEALTH PLAN)

OVERTIME

SOCIAL SECURITY

SHIFT DIFFERENTIAL

53,776

5,800

186

1,817

4,751

103

6,391

633

4,196

2,690

6,485

4,666

949

32,573

3,205

1,503

6,979

96

1,630

108

494

4,586

2,684

4,016

2,819

1,217

34,568

3,457

1,204

7,911

126

3,651

104

689

2,738

6,000

3,157

700

10 SUBTOTAL 92,443 61,910 64,305

Page 172:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUNO :051DEPARTMENT:30INDEX : 306240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOB0ECT

FISCAL YEAR 15 BMR WORKSHEET

WATER B SEWER OPERATINGPUBLIC WORKSSEWER OBM SPRING MEAOOWS

TIME: 14: 14PAGE: 844

SUBOBJECT

2201

2302

2499

2609

ELECTRICITY

TELEPHONE SERVICE

OTHER ADVERTISING

NOTES:

AOVERTISING COSTS

ASSOCIATED WITH

NPDES PERMIT

CO FACILITY REPAIR & RENOVATION

NOTES:

SEWER C&M SPRING MEADOWS

- CONTINUED REPLACEMENT

OF TANK GRATING. MOSH

INSPECTION REQUIREMENTS

HAVE BEEN MET.

ADDITONAL GRATING

AUDITEDFY 12

8.099

482

335

AUDITEDFY 13

7,906

459

280

8.005

ORIGINALBUDGETFY 14

10,000

500

300

49,500

DEPARTMENTREQUEST

FY 15

NEEDED. 1,500

COAT INSIDE OF CONCRETE

PLANT PROCESS TANKS -

Page 173:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

DETERIORATING AFTER 26 YRS.

LEAK COULD CAUSE PERMIT

VIOLATION. 45,000

- OTHER REPAIRS AS

NE EOEO 3. 000

Page 174:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX : 306240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SPRING MEADOWS

TIME: 14:14PAGE: 845

5UBDBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2699 OTHER PROFESSIONAL SERVICES

NOTES:

SEWER O&M SPRING MEADOWS

CONTRACT LAB TESTING

TESTING OF PLANT

2,260 4,435 2,350

2704

2707

SAMPLES

- EMERGENCY PUMPOUTS

AS NEEDED

OPERATING EQUIPMENT

GROUNDS MAINTENANCE

850

1,500

511 732 1,080

2,000

20 SUBTOTAL 11,687 21.817 65,730

Page 175:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX ; 306240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M SPRING MEADOWS

TIME: 14: 14PAGE; 846

SUBDBJECT

3201

3504

3506

3510

3515

DELIVERY CHARGES

EQUIPMENT REPAIR PARTS

SMALL TOOLS

BUILDING SUPPLIES

SAFETY EQUIPMENT

ORIGINAL DEPARTMENTAUDITED AUDITED BUDGET REQUEST

FY 12 FY 13 FY 14 FY 15

247 130 100

2,601 6,715 5,000

440

94 100

229 250

30 SUBTOTAL 2,942 7,514 5,450

4601

4703

MEMBERSHIP FEES & DUES

TRAINING SEMINARS, COURSES & MEETINGS

50

250

40 SUBTOTAL 50 250

Page 176:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPDRT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :306240

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER DPERATINGPUBLIC WDRKSSEWER OaM SPRING MEADOWS

TIME: 14:14PAGE: 847

SUBDBJECTAUDITED

FV 12AUDITED

FV 13

ORIGINAL8UDGETFY 14

OEPARTMENTREQUEST

FY IS

5399

5503

5505

5508

5511

5531

5556

OTHER FURNITURE & FIXTURES

BLOWERS

NDTES:

REPLACE 1 PROCESS

BLOWER (3RD OF 6) NEEDED

TO MAINTAIN AIR TO DRGAN-

ISMS IN EXTENDED AERA-

lION TREATMENT

CEMENT MIXER

GENERATORS

PUMPS

WELDER

LABORATORY EQUIPMENT

239

3,930

299

1,000

2,126

3,497

2,762

2,000

2,000

50 SUBTOTAL 4.169 9,684 4,000

Page 177:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 306240

HARFORD COUNTY, MO - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER C&M SPRING MEADOWS

TIME: 14:14PAGE: 848

AUDITEDSUBOBJECT FY 12

7102 PAYMENTS TO OTHER GQVT AGENCIES

NOTES:

ANNUAL SLUDGE

GENERATOR FEE

PAID TO MOE

BASED ON VOLUME

OF BIOSOLIDS

PRODUCED IN

TREATMENT

70 SUBTOTAL

394

394

AUDITEDFY 13

199

199

ORIGINALBUDGETFY 14

400

400

DEPARTMENTREQUEST

FY 15

INDEX 306240 SUBTOTAL 111,635 101,174 140,135

Page 178:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT: 317OATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 306260

HARFORO COUNTY. MO - SYSTEMWIOE 5.1.1.002OIVISION OETAILEO SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M JOPPATOWNE

TIME: 14: 14PAGE: 849

$U80BJECTAUDITED

FY 12AUOITEO

FY 13

ORIGINALBUOGETFY 14

OEPARTMENTREQUEST

FY 15

1101

1201

1202

1301

1308

1309

1321

1350

1501

1602

CURRENT AUTHORIZED POSITIONS

RETIREMENT (OLO)

PENSION (NEW)

WORKER'S COMPENSATION

LI FE

Be/aS-PREFERRED PROVIDER

DELTA DENTAL PLUS

OPES

OVERTIME

SOCIAL SECURITY

28,815

4.423

647

29

3,317

188

2,379

314

2,123

10.139

3,100

746

12

1.382

78

3,621

840

27,748

2.775

738

35

4,564

287

2.123

10 SUBTOTAL 42,235 19,918 38,270

2609

2699

CO FACILITY REPAIR & RENOVATION

OTHER PROFESSIONAL SERVICES

NOTES:

DUKE'S ROOT CONTROL.

326

24.000 17 . 810 25.000

20 SUBTOTAL 24,326 17.810 25.000

Page 179:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051OEPARTMENT:30INDEX : 306260

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSSEWER O&M JOPPATDWNE

TIME: 14:14PAGE: 850

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

3504

3519

EQUIPMENT REPAIR PARTS

was LINES SERVICE PARTS

91

3,088 8,672

200

6,000

30 SUBTOTAL

INDEX 306260 SUBTOTAL

3,179

69,740

8,672

46.400

6,200

69,470

Page 180:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE ,09/25/2013

FUND :051DEPARTMENT,30INDEX ,307110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWHITEFORD/CARDIFF SERVICE COMMUNITY

TIME: 14: 14PAGE: 851

SUBOB<JECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

2609

2699

2704

CO FACILITY REPAIR & RENOVATION

OTHER PROFESSIONAL SERVICES

OPERATING EQUIPMENT 900

2,500

900

300

4,000

1,500

20 SUBTOTAL 900 3,400 5,800

3202

3519

3599

GENERAL OFFICE MAILING

was LINES SERVICE PARTS

OTHER SUPPLIES & MATERIALS

1,492

2,500

200

1,500

4,000

30 SUBTOTAL 3,992 5,700

Page 181:  · REPORT:317 DATE ,09/25/2013 FUND :051 DEPARTMENT,30 INDEX :305210 HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002 DIVISION DETAILED SUMMARY BY SUBOBJECT FISCAL YEAR 15 BMR WORKSHEET

REPORT:317DATE :09/25/2013

FUND :051DEPARTMENT:30INDEX :307110

HARFORD COUNTY, MD - SYSTEMWIDE 5.1.1.002DIVISION DETAILED SUMMARY BY SUBOBJECT

FISCAL YEAR 15 BMR WORKSHEET

WATER & SEWER OPERATINGPUBLIC WORKSWHITEFORD/CARDIFF SERVICE COMMUNITY

TIME: 14: 14PAGE: 852

SUBOBJECTAUDITED

FY 12AUDITED

FY 13

ORIGINALBUDGETFY 14

DEPARTMENTREQUEST

FY 15

7102 PAYMENTS TO OTHER GOVT AGENCIES

NOTES:

AS REQUIRED BY THE

INTERSTATE AGREEMENT.

PAYMENTS ARE MADE TO

DELTA BOROUGH FOR

TREATMENT OF WASTE.

60,000 60,000 60,000

70 SUBTOTAL

INDEX 307110 SUBTOTAL

DEPARTMENT 30 SUBTOTAL

60,000

60.900

36,340,119

60,000

67,392

38.338,219

60,000

71,500

40.050,819